File manager

File manager - Edit - /home/autoph/public_html/data03252025consolidation/app/bank/crud_bank_details.php

Back
<?php include_once("../../cfg/db.php"); include_once("../../api/controllers/utility.php"); $utility = new Utility(); $type = $_POST['type']; if($type == 1){ // read details (dist/js/bank/bank_information.js) $json_arr = array(); $record_id = $db->escape($_POST['edit_id']); $query = "SELECT bdl.bank_id, bdl.branch_name, bdl.area_id, bdl.branch_address, bdl.branch_contact_number, bdl.branch_head, bdl.bh_contact, bdl.bh_email, DATE_FORMAT(bdl.bh_birthday, '%m/%d/%Y') AS bh_birthday, bdl.bh_position 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 WHERE bdl.id = '$record_id'"; // echo $query; return; $bank_details_query = $db->sql_query($query); foreach($bank_details_query AS $row){ $json_arr['bank_id'] = $row['bank_id']; $json_arr['branch_name'] = $row['branch_name']; $json_arr['area_id'] = $row['area_id']; $json_arr['branch_contact_number'] = $row['branch_contact_number']; $json_arr['branch_head'] = $row['branch_head']; $json_arr['branch_address'] = $row['branch_address']; $json_arr['bh_contact'] = $row['bh_contact']; $json_arr['bh_email'] = $row['bh_email']; $json_arr['bh_birthday'] = $row['bh_birthday']; $json_arr['bh_position'] = $row['bh_position']; } echo json_encode($json_arr); } else if($type == 2){ // update (dist/js/bank/bank_information.js) $json_arr = array(); $current_date = $db->select("SELECT NOW() AS now"); $bank_id = $db->escape($_POST['bank_id']); $branch_name = $db->escape($_POST['branch_name']); $update_id = $db->escape($_POST['edit_id']); $updated_bank = $db->escape($_POST['updated_bank']); $updated_branch_name = $db->escape($_POST['updated_branch_name']); $updated_area = $db->escape($_POST['updated_area']); $updated_address = strtoupper($db->escape($_POST['updated_address'])); $updated_branch_contact = $db->escape($_POST['updated_branch_contact']); $updated_branch_head = strtoupper($db->escape($_POST['updated_branch_head'])); $updated_bh_contact = $db->escape($_POST['updated_bh_contact']); $updated_bh_email = strtoupper($db->escape($_POST['updated_bh_email'])); $updated_bh_birthday = $db->escape($_POST['updated_bh_birthday']); $updated_bh_position = strtoupper($db->escape($_POST['updated_bh_position'])); if(isset($updated_bh_birthday) && $updated_bh_birthday != ""){ $updated_bh_birthday = $utility->convert_sql_date($updated_bh_birthday, 'mm/dd/yyyy'); } $update_query = "UPDATE bank_db_list SET `bank_id` = '$updated_bank', `branch_name` = '$updated_branch_name', `area_id` = '$updated_area', `branch_contact_number` = '$updated_branch_contact', `branch_head` = '$updated_branch_head', `bh_contact` = '$updated_bh_contact', `bh_email` = '$updated_bh_email', `bh_birthday` = '$updated_bh_birthday', `bh_position` = '$updated_bh_position', `date_modified` = '$current_date' WHERE id = '$update_id'"; // echo $update_query; return; $updated = $db->sql_query_num_inserted($update_query); if($updated > 0){ $db->sql_query("UPDATE bank_db_list SET `branch_address` = '$updated_address' WHERE bank_id = '$bank_id' AND branch_name = '$branch_name'"); $json_arr['status'] = 1; } else { $json_arr['status'] = 0; } echo json_encode($json_arr); } else if($type == 3){ // load audit trail (dist/js/bank/bank_information.js) $record_id = $db->escape($_POST['record_id']); $json_arr = array(); $query = "SELECT DATE_FORMAT(bdl.date_added, '%b %d, %Y / %h:%i:%s %p') AS date_added, concat(e1.first_name, ' ', e1.last_name) AS uploaded_by, DATE_FORMAT(bdl.date_modified, '%b %d, %Y / %h:%i:%s %p') AS date_modified, concat(e2.first_name, ' ', e2.last_name) AS last_modified_by FROM bank_db_list bdl INNER JOIN employee e1 ON e1.id = bdl.uploaded_by INNER JOIN employee e2 ON e2.id = bdl.last_modified_by WHERE bdl.id = '$record_id' AND bdl.status = 1"; // echo $query; return; $query_list = $db->sql_query($query); foreach($query_list AS $row){ $json_arr['date_added'] = $row['date_added']; $json_arr['added_by'] = $row['uploaded_by']; // $json_arr['last_modified_by'] = $row['last_modified_by'] . " (" . $row['date_modified'] . ")"; trim($row['last_modified_by']) == "Unknown" ? $json_arr['last_modified_by'] = "" : $json_arr['last_modified_by'] = $row['last_modified_by'] . " (" . $row['date_modified'] . ")"; } echo json_encode($json_arr); } else if($type == 4){ // add new (dist/js/bank/bank_list.js) $json_arr = array(); $current_date = $db->select("SELECT CURDATE() AS now"); $current_user = $_SESSION['user']['id']; $add_bank = $db->escape($_POST['add_bank']); $add_branch_name = strtoupper($db->escape($_POST['add_branch_name'])); $add_area = $db->escape($_POST['add_area']); $add_address = strtoupper($db->escape($_POST['add_address'])); $add_branch_contact = $db->escape($_POST['add_branch_contact']); $add_branch_head = strtoupper($db->escape($_POST['add_branch_head'])); $add_bh_contact = $db->escape($_POST['add_bh_contact']); $add_bh_email = strtoupper($db->escape($_POST['add_bh_email'])); $add_bh_birthday = $db->escape($_POST['add_bh_birthday']); $add_bh_position = strtoupper($db->escape($_POST['add_bh_position'])); if(isset($add_bh_birthday) && $add_bh_birthday != ""){ $add_bh_birthday = $utility->convert_sql_date($add_bh_birthday, 'mm/dd/yyyy'); } $insert_query = "INSERT INTO `bank_db_list` ( `bank_id`, `area_id`, `branch_head`, `branch_name`, `branch_address`, `branch_contact_number`, `bh_email`, `bh_birthday`, `bh_contact`, `bh_position`, `uploaded_by`, `last_modified_by`, `date_modified`, `status` ) VALUES ( '$add_bank', '$add_area', '$add_branch_head', '$add_branch_name', '$add_address', '$add_branch_contact', '$add_bh_email', '$add_bh_birthday', '$add_bh_contact', '$add_bh_position', '$current_user', '$current_user', '$current_date', 1 )"; // echo $insert_query; return; $insert_query_execute = $db->sql_query_num_inserted($insert_query); if($insert_query_execute > 0){ $json_arr['status'] = 1; // success } else { $json_arr['status'] = 0; // failed } echo json_encode($json_arr); } ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings