File "location-edit.php"
Full path: /home/fsibplc/public_html/admin/location-edit.php
File
size: 22.57 B (22.57 KB bytes)
MIME-type: text/x-php
Charset: utf-8
Download Open Edit Advanced Editor Back
<?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);
?>
<form action="code.php" method="POST" enctype="multipart/form-data" id="post-form">
<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 )
{
?>
<?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{
}
?>
</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">
<label for="">Meta Description</label>
<textarea name="meta_description" id="meta_description" class="form-control" rows="4"></textarea>
</div>
<div class="col-md-6 md-3 hide">
<label for="">Meta Keyword</label>
<textarea name="meta_keyword" id="meta_keyword" class="form-control" rows="4"></textarea>
</div>
<div class="col-md-6 md-3">
<label for="Status">Status</label>
<input type="checkbox" name="status" width="70px" height="70px" />
Checked = Hidden, Unchecked = Visible
</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');
?>
<script>
$( 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"){
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 == "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>