<?php
#######################CHECK ERROR ###################################

ini_set('display_errors', 0);
ini_set('display_startup_errors', 0);
error_reporting(E_ALL); 
include 'chk.php';
######################################################################


$db = new SQLite3('./api/.boxbr_dash.db');

//db call
//table name
$table_name = "boxbrdash";
//current file var
$base_file = basename($_SERVER["SCRIPT_NAME"]);
// file dir
$target_dir = 'apksimage/';

$file_path = (isset($_SERVER['HTTPS']) && ($_SERVER['HTTPS'] !== 'off') ? 'https' : 'http') . '://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . '/'.$target_dir;

if (!file_exists($target_dir)) {
	mkdir($target_dir, 511, true);
}
$res = $db->query('SELECT * FROM boxbrdash WHERE id=\'' . $_GET['update'] . '\'');
$row = $res->fetchArray();
$upu = '&update='.$_GET['update'];

if (isset($_POST['submit'])) {
	
    $linktype = $_POST['linktype'];
	if ($_POST['linktype'] == '0') {
	    
	$target_file = $target_dir. $_FILES['image']['name'];
	
	$uploadOk = 1;
	
	$apkurl = $_POST['url'];
    $target_file2 = $target_dir . basename($apkurl);
	$file_ext2 = strtolower(end(explode('.', $apkurl)));
	
	$file_ext = strtolower(end(explode('.', $_FILES['image']['name'])));
	$extensions = ['gif','WEBP','webp', 'GIF', 'png', 'PNG', 'jpg', 'JPG', 'jpeg', 'JPEG', 'bmp', 'BMP', 'mp4', 'MP4', 'mpeg', 'MPEG', 'avi', 'AVI','apk','APK'];
	


$urld= $row['imageurl'];
$file_to_delete = basename(parse_url($urld, PHP_URL_PATH));
	$file_to_delete = 'apksimage/' . $file_to_delete;
	
//echo $file_to_delete;
	if (file_exists($file_to_delete)) {
		
	unlink($file_to_delete);
	$msg = '?messageA=The file already exists and has been replaced.';
	}else { 
		$msg = '?messageS=Success, Image File uploaded.'; }

	$uploadOk = 1;

	if (50000000 < $_FILES['image']['size']) {
		$msg = '?messageE=Sorry, your file is too large.';
		//echo $msg;
		$uploadOk = 0;
	}
	
	if (in_array($file_ext, $extensions) === false) {
		//$errors[] = 'extension not allowed, please choose a JPEG or PNG or GIF or MP4 file.';
				$msg = '?messageE=Sorry, only Image or Video or APK files are allowed.';
		//echo $msg;
		
	
		$uploadOk = 0;
	}


	if ($uploadOk == 0) {
	    
	header("Location: {$base_file}".$msg.$upu);
	}
	else if (move_uploaded_file($_FILES['image']['tmp_name'], $target_file)) {
		$boxbr_patch = '' . $file_path . $_FILES['image']['name']. '';
			$dashimg = $boxbr_patch;
		
	    $createdon = date('Y-m-d H:i:s');
    //$extension = 'png';

	$db->exec('UPDATE boxbrdash SET 
	title=\'' . $_POST['title'] . '\', 
	imageurl=\'' . $dashimg . '\', 
	url=\''.$apkurl.'\', 
	linktype=\'' . $_POST['linktype'] . '\', 
	description=\'BoxBR Apks Rebrand\', 
	createdon=\'' . $createdon . '\'
	WHERE   id=\'' . $_POST['id'] . '\'');


	$db->close();
	header('Location: dash.php'.$msg);
	
	}
}else{
	$imageurl = $_POST['imageurl'];
    $target_file = $target_dir . basename($imageurl);
    
	$apkurl = $_POST['url'];
	$file_ext2 = strtolower(end(explode('.', $apkurl)));
	
		
	$file_ext = strtolower(end(explode('.', $imageurl)));
	
		$extensions = ['gif','WEBP','webp', 'GIF', 'png', 'PNG', 'jpg', 'JPG', 'jpeg', 'JPEG', 'bmp', 'BMP', 'mp4', 'MP4', 'mpeg', 'MPEG', 'avi', 'AVI','apk','APK'];

	if (in_array($file_ext, $extensions) === false) {
		//$errors[] = 'extension not allowed, please choose a JPEG or PNG or GIF or MP4 file.';
				$msg = '?messageE=Sorry, only JPG or PNG or GIF files are allowed.';
		//echo $msg;
		
		
	header("Location: {$base_file}".$msg.$upu);
	}else{
	
		$msg = '?messageS=Saved!, Url of updated..';
		
		
$urld= $row['imageurl'];
$file_to_delete = basename(parse_url($urld, PHP_URL_PATH));
	$file_to_delete = 'apksimage/' . $file_to_delete;
	
//echo $file_to_delete;
	if (file_exists($file_to_delete)) {
		
	unlink($file_to_delete);
	}
	    $createdon = date('Y-m-d H:i:s');
    $type = $_POST['type'];
    
	$db->exec('UPDATE boxbrdash SET 
	title=\'' . $_POST['title'] . '\', 
	imageurl=\'' . $imageurl . '\',
	url=\'' . $apkurl . '\', 
	linktype=\'' . $_POST['linktype'] . '\', 
	description=\'BoxBR Apks Rebrand\', 
	createdon=\'' . $createdon . '\'
	WHERE   id=\'' . $_POST['id'] . '\'');
	$db->close();
	header('Location: dash.php'.$msg);
	}
  }	

}

include ('includes/header.php');

echo ' <!-- Begin Page Content -->' . "\n";
echo '        <div class="container-fluid">' . "\n";
echo "\n";


if (isset($_GET['message'])) {
	echo '<div class="alert alert-danger bg-primary py-3" id="flash-msg"><h4 align="center" class="m-0 font-weight-bold text-white"><i class="icon fa fa-check"></i> '.$_GET['message'].'</h4></div>';
}
if (isset($_GET['messageA'])) {
	echo '<div class="alert alert-danger bg-primary py-3" id="flash-msg"><h4 align="center" class="m-0 font-weight-bold text-white"><i class="icon fa fa-check"></i> '.$_GET['messageA'].'</h4></div>';
}
if (isset($_GET['messageE'])) {
	echo '<div class="alert alert-danger bg-danger py-3" id="flash-msg"><h4 align="center" class="m-0 font-weight-bold text-white"><i class="icon fa fa-times"></i> '.$_GET['messageE'].'</h4></div>';
}
if (isset($_GET['messageS'])) {
	echo '<div class="alert alert-danger bg-success py-3" id="flash-msg"><h4 align="center" class="m-0 font-weight-bold text-white"><i class="icon fa fa-check"></i> '.$_GET['messageS'].'</h4></div>';
}


echo '          <!-- Content Row -->' . "\n";
echo '          <div class="row">' . "\n";
echo "\n";
echo '            <!-- First Column -->' . "\n";
echo '            <div class="col-lg-12">' . "\n";
echo "\n";
echo '              <!-- Custom codes -->' . "\n";
echo '                <div class="card text-text-primary">' . "\n";
echo '                <div class="card-header bg-primary py-3">' . "\n";
echo '                <center><h4 align="center" class="m-0 text-white"><i class="fas fa-server" style="font-size:20px">&nbsp;&nbsp;</i> Editar App</h4>
                        
						</center>
' . "\n";

echo '                </div>' . "\n";

?>

                         <div class="card-body">
								<form method="post" enctype="multipart/form-data">
								
                        <div  type="hidden" class="form-group">
						   <input type="hidden" name="id" value="<?=$row['id'] ?>">
                          <input type="hidden" id="id" class="form-control text-primary" name="id" value="<?=$row['id'] ?>">
                        </div>
                         <div class="form-group">
                          <label class="bmd-label-floating"><strong>Nome do app</strong></label>

                          <input type="text" id="title" class="form-control text-primary" name="title" value="<?=$row['title'] ?>">

                        </div>
						                                <div class="form-group ">
                                   <label class="control-label " for="vpn_config">
                                       <strong>Select o tipo:</strong>
                                  </label>
                                 <div class="input-group">
									  <select class="form-control linktype" id="linktype" name="linktype">
										  <option data-value="op0" value="0" <?=$row['linktype']=='0'?'selected':'' ?>>Usar uma URL da Image
										  </option>
										  <option data-value="op1" value="1" <?=$row['linktype']=='1'?'selected':'' ?>>Enviar arquivo da Image
									  </select>
                                    </div>
                                </div>
							
						  
						    <div class="activeu">
							<div class="form-group ">
                             <label class="control-label"><strong> Url Externa de Imagem</strong></label>
                                <div class="input-group">
                                 <input  class="form-control" type="text" name="imageurl" value="<?=$row['imageurl'] ?>" placeholder="Arquivos devem ser .gif ou .png ou .jpg...">
                                </div>
                             </div>
                         </div>
						 
						                       <div class="actived">
                        <div class="form-group ">
                            <label class="control-label"> <strong> Enviar arquivo de Imagem</strong></label>
						      <div class="input-group">
						      	<div class="custom-file">
					        	<input type="file" class="custom-file-input" name="image" id="intro" placeholder="Choose Intro" onchange="uploadintro(this)" aria-describedby="intro">
			<label class="custom-file-label" for="intro" placeholder="Choose Background Image"><span id="image-intro"></span></label>
				          	   </div>
			                </div>
		        	     </div>
		    	       </div>
						
                        
							<div class="form-group ">
                             <label class="control-label"><strong> Nome do pacote</strong></label>
                                <div class="input-group">
                                 <input  class="form-control" type="text" name="url" value="<?=$row['url'] ?>" placeholder="Coloque o pacote (com.app.nome)"/>
                                </div>
                             </div>
                        <div align="center" class="form-group mb-3">
									<br>
										<button class="btn btn-success btn-icon-split" name="submit" type="submit"><span class="icon text-white-50"><i class="fas fa-save"></i>&nbsp;&nbsp;</span><span class="text"> Editar app</span></button>
                                </div>
                            </form>
                            </div>
                        </div>
                    </div>
                    <!-- Column -->
                </div>
            </div>
            <!-- ============================================================== -->
            <!-- End Container fluid  -->
            <!-- ============================================================== -->

    <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
    <script>
//select activecode form
//var response = {};
//response.val = "op2";
//$("#codemode option[data-value='" + response.val +"']").attr("selected","selected");

//hide activecode form
$('.actived').show(); 

$('.activeu').hide(); 


//Show/hide activecode select
$(document).ready(function(){
  $('.linktype').change(function(){
    if($('.linktype').val() > 0) {
      $('.actived').hide(); 
      $('.activeu').show(); 
    } else {
      $('.activeu').hide(); 
      $('.actived').show(); 
     document.getElementById("activeu").value = ' ';
    } 
  });
  $('.linktype').ready(function(){
    if($('.linktype').val() > 0) {
      $('.actived').hide(); 
      $('.activeu').show(); 
    }else {
      $('.activeu').hide(); 
      $('.actived').show(); 
     document.getElementById("actived").value = ' ';
      
    } 
  });
});
</script>
<script>
function formSubmit(radioObj){
  if(radioObj.checked){
    document.getElementById("onoff").submit();

  }
}
</script>
<?php
// JAVA TARGET
echo '<script>';
echo 'function uploadintro(target) {' . "\n";
echo "\t" . 'document.getElementById("image-intro").innerHTML = target.files[0].name;' . "\n";
echo '}' . "\n";
echo "\n";
echo '$(document).ready(function() {' . "\n";
echo '    if (location.hash) {' . "\n";
echo '        $("a[href=\'" + location.hash + "\']").tab("show");' . "\n";
echo '    }' . "\n";
echo '    $(document.body).on("click", "a[data-toggle=\'tab\']", function(event) {' . "\n";
echo '        location.hash = this.getAttribute("href");' . "\n";
echo '    });' . "\n";
echo '});' . "\n";
echo '$(window).on("popstate", function() {' . "\n";
echo '    var anchor = location.hash || $("a[data-toggle=\'tab\']").first().attr("href");' . "\n";
echo '    $("a[href=\'" + anchor + "\']").tab("show");' . "\n";
echo '});' . "\n";
echo "\n";
echo '</script>';
//INCLUDE FUNCTIONS
echo '    <br><br><br>';
include 'includes/footer.php';
require 'includes/boxbr.php';
echo '      </body>' . "\n";

?>