<?php

//ini_set('display_errors', 1);
//ini_set('display_startup_errors', 1);
//error_reporting(E_ALL);

    $db = new SQLite3('./api/.db.db');
    $res = $db->query("SELECT * FROM store");
    $res2 = $db->query("SELECT version FROM store");
	$row = $res->fetchArray();
	$catss = array();
	while($rows = $res2->fetchArray() ){
		array_push($catss, $rows['version']);
	}
	//print_r($cats);
	$cats = array_unique($catss);
	//print_r($cats);
    if (isset($_POST['store']))
    {	
		$icon = $_POST['icon'];
		if ($icon != ""){
			$icon = str_replace("'", "&apos;", $icon);
			$icon = str_replace('"', '&quot;', $icon);
			$icon = str_replace("<", "&lt;", $icon);
			$icon = str_replace(">", "&gt;", $icon);
			$icon = str_replace("&", "&amp;", $icon);
		}
		$name = $_POST['name'];
		if ($name != ""){
			$name = str_replace("'", "&apos;", $name);
			$name = str_replace('"', '&quot;', $name);
			$name = str_replace("<", "&lt;", $name);
			$name = str_replace(">", "&gt;", $name);
			$name = str_replace("&", "&amp;", $name);
		}
		$url = $_POST['url'];
		if ($url != ""){
			$url = str_replace("'", "&apos;", $url);
			$url = str_replace('"', '&quot;', $url);
			$url = str_replace("<", "&lt;", $url);
			$url = str_replace(">", "&gt;", $url);
			$url = str_replace("&", "&amp;", $url);
		}
		$vidz = $_POST['vidz'];
		if ($vidz != ""){
			$vidz = str_replace("'", "&apos;", $vidz);
			$vidz = str_replace('"', '&quot;', $vidz);
			$vidz = str_replace("<", "&lt;", $vidz);
			$vidz = str_replace(">", "&gt;", $vidz);
			$vidz = str_replace("&", "&amp;", $vidz);
		}
		if ($_POST['base64'] == ''){$base64 = '';}else{$base64 = base64_encode($_POST['base64']);}
        $db->exec("INSERT INTO store(added_date,base64,icon,name,url,version,version_code,vidz) VALUES('".time()."','".$base64."','".$icon."','".$name."','".$url."','".$_POST['version']."','".$_POST['version_code']."','".$vidz."')");
        header("Location: store.php");
    }

    include ('includes/header.php');
?>

<div class="has-sidebar-left has-sidebar-tabs">
    <div class="container-fluid relative animatedParent animateOnce p-lg-5">
        <div class="col-md-8 mx-auto">
            <div class="card-body">
                <div class="card bg-primary text-white">
                    <div class="card-header card-header-warning">
                        <center>
                            <h2><i class="icon icon-window-restore"></i> Add Store Config</h2>
                        </center>
                    </div>

                    <div class="card-body">
                            <form method="post">
                                <div class="form-group">
                                    <label class="form-label " for="version" >Category Name</label>
                                    <input class="form-control" list="catlist" name="version" autocomplete="off">
									  <datalist id="catlist">
									   <?php
									  foreach($cats as $value) { ?>
									  <option value="<?= $value ?>"><?= $value ?></option>
									  <?php } ?>
									</datalist>
                                </div>   
                                <div class="form-group">
                                    <label class="form-label " for="name" >App Name</label>
                                    <input class="form-control" id="name" name="name" value="" type="text"/>
                                </div>

                                <div class="form-group">
                                    <label class="form-label " for="url" >App URL</label>
                                    <input class="form-control" id="url" name="url" value="" type="text"/>
                                </div>
                                <div class="form-group">
                                    <label class="form-label " for="icon" >App Icon</label>
                                    <input class="form-control" id="icon" name="icon" value="" type="text"/>
                                </div>
                                <div class="form-group">
                                    <label class="form-label " for="base64" >App Description (HTML Friendly)</label>
                                    <input class="form-control" id="base64" name="base64" value="" type="text"/>
                                </div>
                                <div class="form-group">
                                    <label class="form-label " for="vidz" >Preview Video</label>
                                    <input class="form-control" id="vidz" name="vidz" value="" type="text"/>
                                </div>
                                <div class="form-group">
                                    <label class="form-label " for="version_code" >Category Pin (Blank For None)</label>
                                    <input class="form-control" id="version_code" name="version_code" value="" type="text"/>
                                </div>       
                                <div class="form-group">
                                    <center>
                                        <button class="btn btn-info " name="store" type="submit">
                                            <i class="icon icon-check"></i> Submit
                                        </button>
                                    </center>
                                </div>
                            </form>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<?php include ('includes/footer.php');?>

</body>
</html>