Tiny File Manager

Back Back Up Advanced Editor

<?php

include('config/dbcon.php');
include('authentication.php');
//session_start();

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

<div class="container-fluid px-4">
    
       <div class="row mt-4">
        <div class="col-md-12">
        <?php include('message.php'); ?>
         <div class="card">
                <div class="card-header">
                    <h4>Edit Location<a href="location-view.php" class="btn btn-danger float-end">Back</a></h4>
                     
                </div>
                <div class="card-body">
                <?php
               if (isset($_GET['id']) && filter_var($_GET['id'], FILTER_VALIDATE_INT)) {
                 $post_id = mysqli_real_escape_string($conn, $_GET['id']); 
                 $location_type = mysqli_real_escape_string($conn, $_GET['type']);
              //  $gallery_id = $_GET['id'];
               
                    $stmt = $conn->prepare("SELECT * FROM location WHERE id= ? LIMIT 1"); 
                    $stmt->bind_param("i", $post_id);
                    $stmt->execute();
                    $result = $stmt->get_result();
                    $stmt->close();

/*    $post_query = "SELECT * FROM posts WHERE id= '$post_id' LIMIT 1";
                    $post_query_res = mysqli_query($con, $post_query);*/

if(mysqli_num_rows($result) > 0)
                    {
                        $post_row = mysqli_fetch_array($result);
                        ?>

<input type="hidden" name="location_id" value="<?= $post_row['id'] ?>">
                          
                            <div class="row">
                            <div class="col-md-6 md-3" id="loc_type_div">
                                 <label for="">Location Type</label>
                                                       
                                 
                                 
                                <input type="text" name="loc_type" id="loc_type" value="<?=  $location_type ?>"  class="form-control" readonly>
                            </div>
                                       
                                </div>

<div class="col-md-6 md-3 hide" id="zone_name">
                                    <label for="">Zone</label>
                                     
                                            <select name="zone_name" class="form-control">
                                                <option value="">--Select Zone--</option>
                                                      <?php 
                                            //      $locationid = $post_row['id'];
                                                $query = "SELECT DISTINCT(zone_name) FROM `location` Where type = 'branch'";
                                                $query_run = mysqli_query($con, $query); 
                                                if(mysqli_num_rows($query_run) > 0 )
                                                {
                                                    ?>

<?php 
                                                foreach($query_run as $queryitem)
                                                { 
                                                ?>
                                                 
                                                <option value="<?=$queryitem['zone_name']; ?>" <?= $post_row['zone_name'] == $queryitem['zone_name'] ? 'selected':''?> >
                                                     <?=$queryitem['zone_name']; ?>
                                                </option>
                                                <?php
                                                } 
                                                ?>

</select>
                                           <?php     
                                        }else{

}
                                    ?>
                                                <!-- <option value="Dhaka North Zone">Dhaka North Zone</option>
                                                <option value="Dhaka South Zone">Dhaka South Zone</option>
                                                <option value="Chattogram North Zone">Chattogram North Zone</option> 
                                                <option value="Chattogram South Zone">Chattogram South Zone</option>
                                                <option value="Rajshahi Zone">Rajshahi Zone</option>
                                                <option value="Sylhet Zone">Sylhet Zone</option>
                                                <option value="Khulna Zone">Khulna Zone</option>
                                                <option value="Cumilla Zone">Cumilla Zone</option>
                                                <option value="Barishal Zone">Barishal Zone</option>

</select>-->
                                </div>
                                <div class="col-md-6 md-3 hide" id="zone_name_div">
                                    <label for="">Division-<?= $post_row['zone_name'];?></label>
                                     
                                            <select name="zone_name" class="form-control">
                                                <option value="">--Select Division--</option>
                                                
                                                <?php 
                                            //      $locationid = $post_row['id'];
                                              //  if($post_row['type'] == 'branch') { $type = "branch"; } elseif ($post_row['type'] == 'CRM'){ $type = "CRM"; } else { $type = "ATM"; } 
                                                $query = "SELECT DISTINCT(zone_name) FROM `location` Where type = 'ATM'";
                                                $query_run = mysqli_query($con, $query); 
                                                if(mysqli_num_rows($query_run) > 0 )
                                                {
                                                    ?>

</select>
                                           <?php     
                                        }else{

}
                                    ?>
                                </div>
                                <div class="col-md-6 md-3 hide" id="br_name">
                                  <label for="">Name</label>
                                    <input type="text" name="br_name" value="<?= $post_row['br_name'] ?>"  class="form-control">
                                </div>

<div class="col-md-6 md-3 hide" id="agent_name">
                                  <label for="">Agent Name</label>
                                    <input type="text" name="zone_name" value="<?= $post_row['zone_name'] ?>"  class="form-control">
                                </div>

<div class="col-md-6 md-3 hide"  id="br_address">
                                  <label for="">Address</label>
                                    <input type="text" name="br_address" value="<?= $post_row['br_address'] ?>" class="form-control">
                                </div>
                                
                                <div class="col-md-6 md-3 hide" id="lattitude" >
                                  <label for="">Lattitude</label>
                                    <input type="text" name="lattitude" value="<?= $post_row['lattitude'] ?>" class="form-control">
                                </div>
                                <div class="col-md-6 md-3 hide" id="longitude" >
                                  <label for="">Longitude</label>
                                    <input type="text" name="longitude" value="<?= $post_row['longitude'] ?>" class="form-control">
                                </div>
                              
                                <div class="col-md-6 md-3 hide" id="email">
                                  <label for="">Email</label>
                                    <input type="email" name="email" value="<?= $post_row['email'] ?>" class="form-control">
                                </div>

<div class="col-md-6 md-3 hide" id="br_manager">
                                  <label for="">Branch Manager Phone</label>
                                    <input type="text" name="br_manager" value="<?= $post_row['br_manager'] ?>" class="form-control">
                                </div>

<div class="col-md-6 md-3 hide" id="man_opration">
                                  <label for="">Operation Manager Phone</label>
                                    <input type="text" name="man_opration" value="<?= $post_row['man_opration'] ?>" class="form-control">
                                </div>

<div class="col-md-6 md-3 hide" id="br_code">
                                  <label for=""><?php if ($post_row['type'] == 'branch') { echo "Branch"; }elseif ($post_row['type'] == 'CRM'){ echo "CRM"; } else { echo "ATM"; } ?> Code</label>
                                    <input type="text" name="br_code" value="<?= $post_row['br_code'] ?>" class="form-control">
                                </div>

<div class="col-md-6 md-3 hide" id="routing_no">
                                  <label for="">Routing No</label>
                                    <input type="text" name="routing_no" value="<?= $post_row['routing_no'] ?>" class="form-control">
                                </div>

<div class="col-md-6 md-3 hide" id="phone_no">
                                  <label for="">Phone No</label>
                                    <input type="text" name="phone_no" value="<?= $post_row['phone_no'] ?>" class="form-control">
                                </div>  
                                <div class="col-md-6 md-3 hide" id="fax">
                                  <label for="">FAX No</label>
                                    <input type="text" name="fax" value="<?= $post_row['fax'] ?>" class="form-control">
                                </div>

<div class="col-md-6 md-3 hide" id="mother_br">
                                  <label for="">Mother Branch</label>
                                    <input type="text" name="mother_br" value="<?= $post_row['mother_br'] ?>" class="form-control">
                                </div> 
                                <div class="col-md-6 md-3 hide" id="inaguration">
                                  <label for="date">Inaguration Date</label>
                                  <input id="datepicker" width="276" value="<?= $post_row['inaguration'] ?>" name="inaguration" placeholder="dd-mm-yyyy"/>
                                </div>
                               
                                <div class="col-md-6 md-3 hide" id="sub_button">
                                       <button type="submit" class="btn btn-primary" name="location_update">Save location</button> 
                                </div>
                                
                            </div>
                        </form>

<?php

}else{
                    ?>
                    <h4>No Record Found.</h4>

<?php
                }
                }
                ?>

</div>
            </div>

</div>

</div>
</div>

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

$( document ).ready(function() {
    var Type = document.getElementById('loc_type').value;

if (Type == "branch") {
        document.getElementById('zone_name').style.display = "block";
        document.getElementById('zone_name_div').style.display = "none";
        document.getElementById('br_name').style.display = "block";
        document.getElementById('agent_name').style.display = "none";
        document.getElementById('br_address').style.display = "block";
        document.getElementById('inaguration').style.display = "block";
        document.getElementById('lattitude').style.display = "block";
        document.getElementById('longitude').style.display = "block";
        document.getElementById('email').style.display = "block";
        document.getElementById('br_manager').style.display = "block";
        document.getElementById('man_opration').style.display = "block";
        document.getElementById('br_code').style.display = "block";
        document.getElementById('routing_no').style.display = "block";
        document.getElementById('phone_no').style.display = "block";
        document.getElementById('fax').style.display = "block";
        document.getElementById('mother_br').style.display = "none";
        document.getElementById('sub_button').style.display = "block";

}

if(Type == "sub branch"){

document.getElementById('zone_name').style.display = "none";
        document.getElementById('zone_name_div').style.display = "none";
        document.getElementById('br_name').style.display = "block";
        document.getElementById('agent_name').style.display = "none";
        document.getElementById('br_address').style.display = "block";
        document.getElementById('inaguration').style.display = "block";
        document.getElementById('lattitude').style.display = "block";
        document.getElementById('longitude').style.display = "block";
        document.getElementById('email').style.display = "none";
        document.getElementById('br_manager').style.display = "none";
        document.getElementById('man_opration').style.display = "none";
        document.getElementById('br_code').style.display = "none";
        document.getElementById('routing_no').style.display = "none";
        document.getElementById('phone_no').style.display = "block";
        document.getElementById('fax').style.display = "none";
        document.getElementById('mother_br').style.display = "block";
         document.getElementById('sub_button').style.display = "block";

}

if(Type == "atm"){

document.getElementById('zone_name').style.display = "none";
        document.getElementById('zone_name_div').style.display = "block";
        document.getElementById('br_name').style.display = "block";
        document.getElementById('agent_name').style.display = "none";
        document.getElementById('br_address').style.display = "block";
        document.getElementById('inaguration').style.display = "block";
        document.getElementById('lattitude').style.display = "block";
        document.getElementById('longitude').style.display = "block";
        document.getElementById('email').style.display = "none";
        document.getElementById('br_manager').style.display = "none";
        document.getElementById('man_opration').style.display = "none";
        document.getElementById('br_code').style.display = "block";
        document.getElementById('routing_no').style.display = "none";
        document.getElementById('phone_no').style.display = "none";
        document.getElementById('fax').style.display = "none";
        document.getElementById('mother_br').style.display = "block";
         document.getElementById('sub_button').style.display = "block";
        }

if(Type == "CRM"){

if(Type == "collection booth"){

document.getElementById('zone_name').style.display = "none";
        document.getElementById('zone_name_div').style.display = "none";
        document.getElementById('br_name').style.display = "block";
        document.getElementById('agent_name').style.display = "none";
        document.getElementById('br_address').style.display = "none";
        document.getElementById('inaguration').style.display = "block";
        document.getElementById('lattitude').style.display = "none";
        document.getElementById('longitude').style.display = "none";
        document.getElementById('email').style.display = "none";
        document.getElementById('br_manager').style.display = "none";
        document.getElementById('man_opration').style.display = "none";
        document.getElementById('br_code').style.display = "none";
        document.getElementById('routing_no').style.display = "none";
        document.getElementById('phone_no').style.display = "none";
        document.getElementById('fax').style.display = "none";
        document.getElementById('mother_br').style.display = "block";
         document.getElementById('sub_button').style.display = "block";
        }
        if(Type == "agent"){

document.getElementById('zone_name').style.display = "none";
        document.getElementById('zone_name_div').style.display = "none";
        document.getElementById('br_name').style.display = "block";
        document.getElementById('agent_name').style.display = "block";
        document.getElementById('br_address').style.display = "block";
        document.getElementById('inaguration').style.display = "block";
        document.getElementById('lattitude').style.display = "none";
        document.getElementById('longitude').style.display = "none";
        document.getElementById('email').style.display = "none";
        document.getElementById('br_manager').style.display = "none";
        document.getElementById('man_opration').style.display = "none";
        document.getElementById('br_code').style.display = "none";
        document.getElementById('routing_no').style.display = "none";
        document.getElementById('phone_no').style.display = "block";
        document.getElementById('fax').style.display = "none";
        document.getElementById('mother_br').style.display = "none";
         document.getElementById('sub_button').style.display = "block";
        }
        if(Type == "hide"){

document.getElementById('zone_name').style.display = "none";
        document.getElementById('zone_name_div').style.display = "none";
        document.getElementById('br_name').style.display = "none";
        document.getElementById('agent_name').style.display = "none";
        document.getElementById('br_address').style.display = "none";
        document.getElementById('inaguration').style.display = "none";
        document.getElementById('lattitude').style.display = "none";
        document.getElementById('longitude').style.display = "none";
        document.getElementById('email').style.display = "none";
        document.getElementById('br_manager').style.display = "none";
        document.getElementById('man_opration').style.display = "none";
        document.getElementById('br_code').style.display = "none";
        document.getElementById('routing_no').style.display = "none";
        document.getElementById('phone_no').style.display = "none";
        document.getElementById('fax').style.display = "none";
        document.getElementById('mother_br').style.display = "none";
        document.getElementById('sub_button').style.display = "none";
        }

return Type;

});

</script>