<div id="br_location" class="tabcontent"> <!-- start Br Location tabContent --> <div class="location_container mt-5"> <div class="col-12 col-sm-9 col-xs-12 col-md-9"> <div class="location_card"> <div class="location_filter"> <form action="location_br.php" method="post" id="br_zone_search"></form> <h5>Division</h5> <select id="zone_list" name="br_zone_name" class="" form="br_zone_search"> <option value="">select any zone</option> <option value="Chattogram North Zone">Chattogram North</option> <option value="Chattogram South Zone">Chattogram South</option> <option value="Dhaka North Zone">Dhaka North</option> <option value="Dhaka South Zone">Dhaka South</option> <option value="Dhaka Zone">Dhaka Zone</option> <option value="Barishal Zone">Barishal</option> <option value="Cumilla Zone">Cumilla</option> <option value="Khulna Zone">Khulna</option> <option value="Rajshahi Zone">Rajshahi</option> <option value="Sylhet Zone">Sylhet</option> </select> <h5>Branch Name</h5> <input type="text" name="br_name" form="br_zone_search" class="br_name" placeholder="enter br name"> <input type="submit" name="br_search_btn" class="search_btn" form="br_zone_search" value="Search" style="border:none;"> </div> <div class="location_card_text"> <div class="table-responsive"> <table id="brTable" class="table table-striped table-bordered" style="width:101%"> <thead class="alert-success text-center"> <tr> <th>Sl</th> <th>Zone</th> <th>Br. Name</th> <th>Br. code</th> <th>Address</th> <th>Mobile no</th> <th>Details</th> </tr> </thead> <tbody> <?php if (empty($br_sql)) { $br_sql = "select * from location where type='branch'"; } $result = $conn->query($br_sql); // print_r($br_sql); while ($rows = $result->fetch_assoc()) { ?> <tr> <td><?php echo $rows['id']; ?></td> <td><?php echo $rows['zone_name']; ?></td> <td><?php echo $rows['br_name']; ?></td> <td><?php echo $rows['br_code']; ?></td> <td><?php echo $rows['br_address']; ?></td> <?php $phone = $rows['br_manager'] . ', ' . $rows['man_opration']; ?> <td><?php echo $phone; ?></td> <td><a class="btn ab" id="<?php echo $rows['id']; ?>"> <!-- <i class="fas fa-info fa-sm" style="color: #00762a;"></i> --> <i class="fa-solid fa-circle-info fa-xl"></i> </a></td> </tr> <?php } ?> </tbody> </table> </div> </div> </div> </div> </div> <!-- moral details start --> <div class="modal fade " id="locationModal" data-bs-keyboard="false" tabindex="-1" aria-labelledby="myModalLabel" aria-hidden="true"> <div class="modal-dialog modal-dialog-centered modal-xl location_modal"> <div class="modal-content map_moral"> </div> </div> </div> <!-- moral details end --> <!-- End Br Location tabcontent --> </div> <div id="sub_br_location" class="tabcontent"> <!-- start sub_br_location tabContent --> <div class="location_container mt-5"> <div class="col-12 col-sm-9 col-xs-12 col-md-9"> <div class="location_card"> <div class="location_card_text"> <div class="table-responsive"> <table id="subbrTable" class="table table-striped table-bordered" style="width:100%"> <thead class="alert-success text-center"> <tr> <th>Sl</th> <th>Sub Br. Name</th> <th>Address</th> <th>Main Branch</th> <th>Phone no</th> </tr> </thead> <tbody> <?php $sl = 1; if (empty($sub_br_sql)) { $sub_br_sql = "select * from location where type='sub branch'"; } $result = $conn->query($sub_br_sql); while ($rows = $result->fetch_assoc()) { ?> <tr> <td><?php echo $sl++; ?></td> <td><?php echo $rows['br_name']; ?></td> <td><?php echo $rows['br_address']; ?></td> <td><?php echo $rows['mother_br']; ?></td> <td><?php echo $rows['phone_no']; ?></td> </tr> <?php } ?> </tbody> </table> </div> </div> </div> </div> </div> <!-- End sub_br_location tabcontent --> </div> <div id="atm_location" class="tabcontent"> <!-- start atm_location tabContent --> <div class="location_container mt-5"> <div class="col-12 col-sm-9 col-xs-12 col-md-9"> <div class="location_card"> <div class="location_filter"> <form action="atm.php" method="post" id="atm_zone_search"></form> <h6>Division</h6> <select id="zone_list" name="atm_zone_name" class="" form="atm_zone_search"> <option value="">select any division</option> <option value="Chattogram Division">Chattogram</option> <option value="Rangpur Division">Rangpur</option> <option value="Dhaka Division">Dhaka</option> <option value="Barishal Division">Barishal</option> <option value="Khulna Division">Khulna</option> <option value="Sylhet Division">Sylhet</option> <option value="Rajshahi Division">Rajshahi</option> </select> <h6>Atm Name</h6> <input type="text" name="atm_name" form="atm_zone_search" class="atm_name" placeholder="enter ATM Name"> <input type="submit" name="atm_search_btn" class="search_btn" form="atm_zone_search" value="Search" style="border:none;"> </div> <div class="location_card_text"> <div class="table-responsive"> <table id="atmTable" class="table table-striped table-bordered" style="width:101%"> <thead class="alert-success text-center"> <tr> <th>Sl</th> <th>Division</th> <th>Branch</th> <th>ATM Name</th> <th>Address</th> <th>Details</th> </tr> </thead> <tbody> <?php // include('config.php'); $sl = 1; if (empty($atm_sql)) { $atm_sql = "select * from location where type='atm'"; } // print_r($atm_sql); $result = $conn->query($atm_sql); while ($rows = $result->fetch_assoc()) { ?> <tr> <td><?php echo $sl++; ?></td> <td><?php echo $rows['zone_name']; ?></td> <td><?php echo $rows['mother_br']; ?></td> <td><?php echo $rows['br_name']; ?></td> <td><?php echo $rows['br_address']; ?></td> <td><a class="btn ab" id="<?php echo $rows['id']; ?>"> <!-- <i class="fas fa-info fa-sm" style="color: #00762a;"></i> --> <i class="fa-solid fa-circle-info fa-xl"></i> </a></td> </tr> <?php } ?> </tbody> </table> </div> </div> </div> </div> </div> <!-- moral details start --> <div class="modal fade " id="atmModal" data-bs-keyboard="false" tabindex="-1" aria-labelledby="myModalLabel" aria-hidden="true"> <div class="modal-dialog modal-xl location_modal"> <div class="modal-content atm_moral"> </div> </div> </div> <!-- moral details end --> <!-- End atm_location tabcontent --> </div> <div id="crm_location" class="tabcontent"> <!-- start crm_location tabContent --> <div class="location_container mt-5"> <div class="col-12 col-sm-9 col-xs-12 col-md-9"> <div class="location_card"> <div class="location_filter"> <form action="crm.php" method="post" id="zone_search"></form> <h6>Division</h6> <select id="zone_list" name="zone_name" class="" form="zone_search"> <option value="">select any division</option> <option value="Chattogram Division">Chattogram</option> <option value="Rangpur Division">Rangpur</option> <option value="Dhaka Division">Dhaka</option> <option value="Barishal Division">Barishal</option> <option value="Khulna Division">Khulna</option> <option value="Sylhet Division">Sylhet</option> <option value="Rajshahi Division">Rajshahi</option> </select> <h6>CRM Name</h6> <input type="text" name="crm_name" form="zone_search" class="crm_name" placeholder="enter Sub br Name"> <input type="submit" name="search_btn" class="search_btn" form="zone_search" value="Search" style="border:none;"> </div> <div class="location_card_text"> <div class="table-responsive"> <table id="crmTable" class="table table-striped table-bordered" style="width:101%"> <thead class="alert-success text-center"> <tr> <th>Sl</th> <th>Division</th> <th>Branch</th> <th>CRM Name</th> <th>Address</th> <th>Details</th> </tr> </thead> <tbody> <?php $sl = 1; if (empty($crm_sql)) { $crm_sql = "select * from location where type='CRM'"; } $result = $conn->query($crm_sql); while ($rows = $result->fetch_assoc()) { ?> <tr> <td><?php echo $sl++; ?></td> <td><?php echo $rows['zone_name']; ?></td> <td><?php echo $rows['mother_br']; ?></td> <td><?php echo $rows['br_name']; ?></td> <td><?php echo $rows['br_address']; ?></td> <td><a class="btn ab" id="<?php echo $rows['id']; ?>"> <!-- <i class="fas fa-info fa-sm" style="color: #00762a;"></i> --> <i class="fa-solid fa-circle-info fa-xl"></i> </a></td> </tr> <?php } ?> </tbody> </table> </div> </div> </div> </div> </div> <!-- moral details start --> <div class="modal fade " id="crmModal" data-bs-keyboard="false" tabindex="-1" aria-labelledby="myModalLabel" aria-hidden="true"> <div class="modal-dialog modal-xl location_modal"> <div class="modal-content crm_moral"> </div> </div> </div> <!-- moral details end --> <!-- End crm_location tabcontent --> </div> <div id="collection_booth" class="tabcontent"> <!-- start collection_booth_location tabContent --> <div class="location_container mt-5"> <div class="col-12 col-sm-9 col-xs-12 col-md-9"> <div class="location_card"> <div class="location_card_text"> <div class="table-responsive"> <table id="collectionTable" class="table table-striped table-bordered" style="width:101%"> <thead class="alert-success text-center"> <tr> <th>Sl</th> <th>Collection Booth Name</th> <th>Controlling Branch</th> <th>Inauguration Date</th> </tr> </thead> <tbody> <?php $sl = 1; if (empty($collection_sql)) { $collection_sql = "select * from location where type='collection booth'"; } $result = $conn->query($collection_sql); while ($rows = $result->fetch_assoc()) { ?> <tr> <td><?php echo $sl++; ?></td> <td><?php echo $rows['br_name']; ?></td> <td><?php echo $rows['mother_br']; ?></td> <td><?php echo $rows['inaguration']; ?></td> </tr> <?php } ?> </tbody> </table> </div> </div> </div> </div> </div> <!-- End collection_booth_location tabcontent --> </div> <div id="agent_outlet" class="tabcontent"> <!-- start agent_outlet_location tabContent --> <div class="location_container mt-5"> <div class="col-12 col-sm-9 col-xs-12 col-md-9"> <div class="location_card"> <div class="location_card_text"> <div class="table-responsive"> <table id="agentTable" class="table table-striped table-bordered" style="width:101%"> <thead class="alert-success text-center"> <tr> <th>Sl</th> <th>Outlet Name</th> <th>Agent Name</th> <th>Address</th> <!--<th>Phone no</th>--> </tr> </thead> <tbody> <?php $sl = 1; if (empty($agent_sql)) { $agent_sql = "select * from location where type='agent'"; } $result = $conn->query($agent_sql); while ($rows = $result->fetch_assoc()) { ?> <tr> <td><?php echo $sl++; ?></td> <td><?php echo $rows['br_name']; ?></td> <td><?php echo $rows['zone_name']; ?></td> <td><?php echo $rows['br_address']; ?></td> </tr> <?php } ?> </tbody> </table> </div> </div> </div> </div> </div> <!-- End agent_outlet_location tabcontent --> </div>