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

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

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


if(isset($_POST['submit'])){

    if ($_FILES['image']['name']!='') {
        $image=uniqid().$_FILES['image']['name'];
        $path = 'uploads/'.$image;
        unlink($_POST['img_url']);
    }else{
        $path=$_POST['img_url'];
    }

    if ($_FILES['image1']['name']!='') {
        $image1=uniqid().$_FILES['image1']['name'];
        $path1 = 'uploads/'.$image1;
        unlink($_POST['img_url1']);
    }else{
        $path1=$_POST['img_url1'];
    }
    
    if ($_FILES['image2']['name']!='') {
        $image2=uniqid().$_FILES['image2']['name'];
        $path2 = 'uploads/'.$image2;
        unlink($_POST['img_url2']);
    }else{
        $path2=$_POST['img_url2'];
    }


    $vision=$_POST['vision'];
    $mission=$_POST['mission'];
    $feature=$_POST['feature'];
    if ($count>0) {
        $que="UPDATE `about_emrs` SET `vision`='$vision',`vision_img`='$path',`mission`='$mission',`mission_img`='$path1',`feature`='$feature',`feature_img`='$path2' LIMIT 1";
    }else{
     $que="INSERT INTO about_emrs (vision,vision_img,mission,mission_img,feature,feature_img) values('$vision','$path','$mission','$path1','$feature','$path2')";  
 }

 if ($conn->query($que) === TRUE) {
    move_uploaded_file($_FILES['image']['tmp_name'], $path);
    move_uploaded_file($_FILES['image1']['tmp_name'], $path1);
    move_uploaded_file($_FILES['image2']['tmp_name'], $path2);
    echo '<script>alert("Updated successfully"); location.href="vision_and_mission"</script>';
}else {
  echo '<script>alert("Something went wrong");</script>';
}
}



?>

<style>
    #myTabContent .input-group{
        width: 100%;
    }
</style>
<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>Edit Vision & Mission</h2>
                                </div>
                            </div>
                        </div>
                        <div class="col-lg-6 col-md-6 col-sm-6 col-xs-6">
                                        <!-- <div class="breadcomb-report">
                                            <button data-toggle="tooltip" data-placement="left" title="Download Report" class="btn"><i class="icon nalika-download"></i></button>
                                        </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">
                                        <!-- vision -->
                                        <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="image" accept="image/*" onchange="document.getElementById('prepend-small-btn').value = this.value;">
                                                </div>
                                                <input type="text" id="prepend-small-btn"  placeholder="Select Image" readonly>
                                                <input type="hidden" name="img_url" value="<?php echo $row['vision_img'] ?>">
                                            </div>
                                        </div>
                                    </div>
                                    <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;">
                                      <img src="<?php echo $row['vision_img'] ?>" style="width: 100px;">
                                  </div>
                              </div>
                              <div class="col-lg-12 col-md-12 col-sm-6 col-xs-12">
                                <div class="input-group mg-b-pro-edt">
                                    <textarea rows="6" class="form-control" id="editor" required name="vision">
                                        <?php echo $row['vision'] ?>
                                    </textarea>

                                </div>
                            </div>
                            <!-- mission -->
                            <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="image1" accept="image/*" onchange="document.getElementById('prepend-small-btn1').value = this.value;">
                                    </div>
                                    <input type="text" id="prepend-small-btn1"  placeholder="Select Image" readonly>
                                    <input type="hidden" name="img_url1" value="<?php echo $row['mission_img'] ?>">
                                </div>
                            </div>
                        </div>
                        <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;">
                          <img src="<?php echo $row['mission_img'] ?>" style="width: 100px;">
                      </div>
                  </div>
                  <div class="col-lg-12 col-md-12 col-sm-6 col-xs-12">
                    <div class="input-group mg-b-pro-edt">
                        <textarea rows="6" class="form-control" id="editor2" required name="mission">
                            <?php echo $row['mission'] ?>
                        </textarea>

                    </div>
                </div>
                <!-- Features -->
                <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="image2" accept="image/*" onchange="document.getElementById('prepend-small-btn2').value = this.value;">
                        </div>
                        <input type="text" id="prepend-small-btn2"  placeholder="Select Image" readonly>
                        <input type="hidden" name="img_url2" value="<?php echo $row['feature_img'] ?>">
                    </div>
                </div>
            </div>
            <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;">
              <img src="<?php echo $row['feature_img'] ?>" style="width: 100px;">
          </div>
      </div>
      <div class="col-lg-12 col-md-12 col-sm-6 col-xs-12">
        <div class="input-group mg-b-pro-edt">
            <textarea rows="6" class="form-control" id="editor3" required name="feature">
                <?php echo $row['feature'] ?>
            </textarea>

        </div>



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

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

            </button>

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

            </a>

        </div>

    </div>



</div>

</div>

</div>

<div class="row">

    <div class="col-lg-6 col-md-6 col-sm-12 col-xs-12" style="padding-right: 30px;">



    </div>

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

</div>

</div>

</div>

</div>

</div>

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