File manager

File manager - Edit - /home/autoph/public_html/data03252025consolidation/app/table/bank_table.php

Back
<?php include_once("../../cfg/db.php"); include_once("../../api/controllers/utility.php"); $utility = new Utility(); $type = $db->escape($_GET['type']); $granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1' ; $search = ""; $offset = ""; $offset_limit = ""; if(isset($_GET['search'])){ $search = $db -> escape(trim($_GET['search'])); } if(isset($_GET['offset'])){ $offset = $db -> escape(trim($_GET['offset'])); } if(isset($_GET['limit'])){ $limit = $db -> escape(trim($_GET['limit'])); $offset_limit = " LIMIT ". $offset.",".$limit; } if($type == 1){ // bank table --> REMOVED, changed as dropdown $json_arr['rows'] = array(); $query = "SELECT id, name FROM bank_db WHERE status != 0"; $query_list = $db->sql_query($query); while($row = $query_list->fetch_assoc()) { $json_arr['rows'] = array_merge($json_arr['rows'], array(array( 'id'=>$row['id'], 'bank_name'=>$row['name'] ))); } echo json_encode($json_arr); } else if($type == 2){ // bank branches $json_arr['rows'] = array(); $number_count = 0; $bank_clause = ""; $company = ""; $dealer = ""; $start_date = ""; $end_date = ""; $date_q = ""; $start_date = $db->escape($_GET['start_date']); $end_date = $db->escape($_GET['end_date']); // echo "> " . $_GET['company']; return; if(isset($_GET['start_date']) && $_GET['start_date'] != ""){ //policy start date starting range $start_date = $db->escape($_GET['start_date']); } if(isset($_GET['end_date']) && $_GET['end_date'] != ""){ //policy start date ending range $end_date = $db->escape($_GET['end_date']); $date_q = " AND bd.date_added BETWEEN '$start_date' AND '$end_date' "; } if(isset($_GET['bank_id']) && $_GET['bank_id'] != 0){ $bank_id = $db->escape($_GET['bank_id']); $bank_clause = " AND bdl.bank_id = '$bank_id' "; } if(isset($_GET['company']) && $_GET['company'] != 0){ $company = $db->escape($_GET['company']); $company = " AND bdl.company_id = '$company' "; } else { $company = " AND bdl.company_id IN(" . $granted_company_ids . ") "; } if(isset($_GET['dealer']) && $_GET['dealer'] != 0){ $dealer = $db->escape($_GET['dealer']); $dealer = " AND bdl.dealer_id = '$dealer' "; } $count = " COUNT(1) "; $fields = " bdl.id AS record_id, bdl.bank_id, bd.abbreviation AS bank_name, bda.name AS area, bdl.branch_name, bdl.branch_contact_number, sc.code AS company, sd.name AS dealer "; $query = "SELECT %s FROM bank_db_list bdl INNER JOIN bank_db bd ON bd.id = bdl.bank_id INNER JOIN bank_db_areas bda ON bda.id = bdl.area_id INNER JOIN source_company sc ON sc.id = bdl.company_id INNER JOIN source_dealer sd ON sd.id = bdl.dealer_id WHERE concat(bda.name, bdl.branch_name) LIKE '%%".$search."%%' " . $bank_clause . $date_q . " AND bda.status = 1 " .$company.$dealer. " GROUP BY bdl.bank_id, bdl.branch_name ORDER BY bdl.branch_name"; // echo sprintf($query, $fields); return; $bank_list = $db->sql_query(sprintf($query, $fields) . $offset_limit); $bank_list_count = $db->select("SELECT COUNT(1) FROM (" . sprintf($query, $fields) . ") AS count"); while($row = $bank_list->fetch_assoc()) { $number_count++; $json_arr['rows'] = array_merge($json_arr['rows'], array(array( 'no'=>$number_count, 'bank_id'=>$row['bank_id'], 'bank_name'=>$row['bank_name'], 'record_id'=>$row['record_id'], 'branch_name'=>$row['branch_name'], 'branch_area'=>$row['area'], 'owner'=>$row['company'] . "/" . $row['dealer'] ))); } $json_arr['total'] = $bank_list_count; echo json_encode($json_arr); } else if($type == 3){ // Branch head infos $json_arr['rows'] = array(); $address = ""; $bank_id = $db->escape($_GET['bank_id']); $branch_name = $db->escape($_GET['branch_name']); $count = " COUNT(1) "; $fields = " bdl.id AS record_id, bd.abbreviation AS bank, bda.name AS area, bdl.branch_name, bdl.branch_contact_number, bdl.branch_head, bdl.bh_contact, bdl.bh_email, DATE_FORMAT(bdl.bh_birthday, '%b %d, %Y') AS bh_birthday, bdl.bh_position, bdl.branch_address, concat(e1.first_name, ' ', e1.last_name) AS uploaded_by, concat(e2.first_name, ' ', e2.last_name) AS last_modified_by, bdl.facebook, DATE_FORMAT(bdl.date_added, '%b %d, %Y / %h:%i:%s %p') AS date_added, DATE_FORMAT(bdl.date_modified, '%b %d, %Y / %h:%i:%s %p') AS date_modified "; $query = "SELECT %s FROM bank_db_list bdl INNER JOIN bank_db bd ON bd.id = bdl.bank_id INNER JOIN bank_db_areas bda ON bda.id = bdl.area_id INNER JOIN employee e1 ON e1.id = bdl.uploaded_by INNER JOIN employee e2 ON e2.id = bdl.last_modified_by WHERE bdl.bank_id = '$bank_id' AND bdl.branch_name = '$branch_name' AND bdl.status = 1"; // echo sprintf($query, $fields); return; $bh_info_list = $db->sql_query(sprintf($query, $fields) . $offset_limit); $bh_info_count = $db->select(sprintf($query, $count)); while($row = $bh_info_list->fetch_assoc()) { $json_arr['rows'] = array_merge($json_arr['rows'], array(array( 'record_id'=>$row['record_id'], 'branch_contact_number'=>$row['branch_contact_number'], 'branch_head'=>$row['branch_head'], 'bh_contact'=>$row['bh_contact'], 'bh_email'=>$row['bh_email'], 'bh_birthday'=>$row['bh_birthday'], 'bh_position'=>$row['bh_position'], 'bank'=>$row['bank'], 'area'=>$row['area'], 'branch_name'=>$row['branch_name'], 'bh_facebook'=>$row['facebook'], 'uploaded_by'=>$row['uploaded_by'], 'last_modified_by'=>trim($row['last_modified_by']), 'date_added'=>$row['date_added'], 'date_modified'=>$row['date_modified'] ))); } $json_arr['address'] = $db->select("SELECT branch_address FROM bank_db_list WHERE bank_id = '$bank_id' AND branch_name = '$branch_name' AND status = 1 LIMIT 1"); $json_arr['total'] = $bh_info_count; echo json_encode($json_arr); } else if($type == 4){ // bank report table $json_arr['rows'] = array(); $bank = ""; $company = ""; $dealer = ""; $start_date = ""; $end_date = ""; $date_q = ""; $start_date = $db->escape($_GET['start_date']); $end_date = $db->escape($_GET['end_date']); if(isset($_GET['start_date']) && $_GET['start_date'] != ""){ //policy start date starting range $start_date = $db->escape($_GET['start_date']); } if(isset($_GET['end_date']) && $_GET['end_date'] != ""){ //policy start date ending range $end_date = $db->escape($_GET['end_date']); $date_q = " AND bdl.date_added BETWEEN '$start_date' AND '$end_date' "; } if(isset($_GET['bank_id']) && $_GET['bank_id'] != 0){ $bank = $db->escape($_GET['bank_id']); $bank = " AND bdl.bank_id = '$bank' "; } if(isset($_GET['company']) && $_GET['company'] != 0){ $company = $db->escape($_GET['company']); $company = " AND bdl.company_id = '$company' "; } else { $company = " AND bdl.company_id IN(" . $granted_company_ids . ") "; } if(isset($_GET['dealer']) && $_GET['dealer'] != 0){ $dealer = $db->escape($_GET['dealer']); $dealer = " AND bdl.dealer_id = '$dealer' "; } $count = " COUNT(1) "; $fields = " bdl.id AS record_id, bdl.bank_id, bd.abbreviation AS bank_name, bda.name AS area, bdl.branch_name, bdl.branch_contact_number, bdl.branch_head, bdl.bh_contact, bdl.bh_position, sc.code AS company, sd.code AS dealer "; $query = "SELECT %s FROM bank_db_list bdl INNER JOIN bank_db_areas bda ON bda.id = bdl.area_id INNER JOIN bank_db bd ON bd.id = bdl.bank_id INNER JOIN source_company sc ON sc.id = bdl.company_id INNER JOIN source_dealer sd ON sd.id = bdl.dealer_id WHERE concat(bdl.branch_name, bdl.branch_head, bdl.bh_contact, bdl.branch_contact_number) LIKE '%%".$search."%%' " .$bank.$company.$dealer.$date_q. " AND bdl.status = 1 ORDER BY bdl.branch_name"; // echo sprintf($query, $fields); return; $bank_report_list = $db->sql_query(sprintf($query, $fields) . $offset_limit); // $bank_report_count = $db->select(sprintf($query, $count)); $bank_report_count = $db->select("SELECT COUNT(1) FROM (" . sprintf($query, $fields) . ") AS count"); while($row = $bank_report_list->fetch_assoc()){ $json_arr['rows'] = array_merge($json_arr['rows'], array(array( 'record_id'=>$row['record_id'], 'bank_id'=>$row['bank_id'], 'bank'=>$row['bank_name'], 'area'=>$row['area'], 'company'=>$row['company'], 'dealer'=>$row['dealer'], 'branch_name'=>$row['branch_name'], 'branch_contact_number'=>$row['branch_contact_number'], 'branch_head'=>$row['branch_head'], 'bh_contact'=>$row['bh_contact'], 'bh_position'=>$row['bh_position'] ))); } $json_arr['total'] = $bank_report_count; echo json_encode($json_arr); } ?>

| ver. 1.4 | . | PHP 8.1.32 | Generation time: 0.01 | proxy | phpinfo | Settings