<?php include('include/sidebar.php'); ?>
<!-- Start Welcome area -->

<?php include('include/header.php'); ?>

<?php
$q = "SELECT * FROM govt_permission limit 1";
$result  = mysqli_query($conn,$q);
$row = mysqli_fetch_assoc($result);
$count =  mysqli_num_rows($result);

if(isset($_POST['submit'])){
    $title=$_POST['title'];

    $fileurl=$_POST['fileurl'];

    if($_FILES['file']['name']!=''){
        $file = uniqid().$_FILES['file']['name'];
        $path = 'uploads/'.$file;
        $file_size=$_FILES['file']['size'];
    }else{
        $path=$fileurl;
        $file_size=$_POST['file_size'];
    }



    if ($count>0) {
        $que="UPDATE `govt_permission` SET `file`='$path',`title`='$title',`file_size`='$file_size' LIMIT 1";
        unlink($fileurl);

    }else{
        $que="INSERT INTO govt_permission (file,title,file_size) values('$path','$title','$file_size')";  
    }
    if ($conn->query($que) === TRUE) {

        move_uploaded_file($_FILES['file']['tmp_name'], $path);
        echo '<script>alert("Updated successfully"); location.href="state_government_permission"</script>';
    }else {
      echo '<script>alert("Something went wrong");</script>';
  }
}


?>
<div class="breadcome-area">
    <div class="container-fluid">
        <div class="row">
            <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
                <div class="breadcome-list">
                    <div class="row">
                        <div class="col-lg-6 col-md-6 col-sm-6 col-xs-6">
                            <div class="breadcomb-wp">
                                <div class="breadcomb-icon">
                                    <i class="icon nalika-home"></i>
                                </div>
                                <div class="breadcomb-ctn">
                                    <h2>State Government Permission</h2>
                                </div>
                            </div>
                        </div>

                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
</div>
<div class="single-product-tab-area mg-b-30">

    <!-- Single pro tab review Start-->

    <div class="single-pro-review-area">

        <div class="container-fluid">

            <div class="row">

                <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">

                    <div class="review-tab-pro-inner">
                        <form method="post" enctype="multipart/form-data">
                            <div id="myTabContent" class="tab-content custom-product-edit">

                                <div class="row">

                                    <div class="col-lg-6 col-md-6 col-sm-6 col-xs-12">

                                        <div class="file-upload-inner ts-forms" style="margin-bottom:15px;">
                                            <div class="input prepend-small-btn">
                                                <div class="file-button">
                                                    Browse
                                                    <input type="file" name="file" accept="application/pdf,application/vnd.ms-excel" onchange="document.getElementById('prepend-small-btn').value = this.value;">
                                                </div>
                                                <input type="text" id="prepend-small-btn"  placeholder="Select File" readonly>
                                                <input type="hidden" name="fileurl" value="<?php echo $row['file'] ?>">
                                                <input type="hidden" name="file_size" value="<?php echo $row['file_size'] ?>">
                                            </div>
                                        </div>


                                        <div class="input-group mg-b-pro-edt">

                                            <input type="text" class="form-control" name="title" placeholder="Title" value="<?php echo $row['title'] ?>" required>

                                        </div>
                                        <div class="text-center custom-pro-edt-ds">

                                            <button type="submit" class="btn btn-ctl-bt waves-effect waves-light m-r-10" value="submit" name="submit">Save

                                            </button>

                                            <a href="index" class="btn btn-ctl-bt waves-effect waves-light">cancel

                                            </a>

                                        </div>
                                    </div>



                                </div>
                            </div>
                        </form>
                    </div>

                </div>

            </div>

        </div>

    </div>

</div>

</div>
<?php include('include/footer.php'); ?>