File manager

File manager - Edit - /home/autoph/public_html/connectv1/app/finance/finance_information.php

Back
<?php include_once("../../cfg/db.php"); include_once("../../api/controllers/utility.php"); $type = $db->escape($_POST['type']); $json_arr['rows'] = array(); if($type == 1){ // ----------------------------------------------- FINANCE TABLE LIST --> $plate_cs_number = $db->escape($_POST['plate_cs_number']); $count = " COUNT() "; $fields = " f.plate_cs_number1, f.plate_cs_number2, fsb.name AS brand, f.customer_fullname, sc.code AS company, sd.name AS dealer, f.customer_mobile_number, f.customer_email, DATE_FORMAT(f.date_uploaded, '%b %d, %Y / %h:%i:%s %p') AS date_uploaded, concat(e1.first_name, ' ', e1.last_name) AS uploaded_by, concat(e2.first_name, ' ', e2.last_name) AS modified_by, DATE_FORMAT(f.date_modified, '%b %d, %Y / %h:%i:%s %p') AS date_modified "; $query = "SELECT %s FROM finance f INNER JOIN source_company sc ON f.company_id = sc.id INNER JOIN source_dealer sd ON f.dealer_id = sd.id INNER JOIN finance_source_brand fsb ON fsb.id = f.brand_id INNER JOIN employee e1 ON e1.id = f.uploaded_by INNER JOIN employee e2 ON e2.id = f.modified_by WHERE f.plate_cs_number1 = '$plate_cs_number' ORDER BY f.brand_id DESC LIMIT 1"; // echo sprintf($query, $fields); return; $finance_query = $db->sql_query(sprintf($query, $fields)); while($row = $finance_query->fetch_assoc()) { $modifier = ""; $date_modified = ""; trim($row['modified_by']) == "Unknown" ? $modifier = "-" : $modifier = $row['modified_by']; $row['date_modified'] == "" ? $date_modified = "" : $date_modified = " (" . $row['date_modified'] . ")"; $json_arr['rows'] = array_merge($json_arr['rows'], array( 'plate_cs_number'=>$row['plate_cs_number2'] == "" ? $row['plate_cs_number1'] : $row['plate_cs_number1'] . "/" . $row['plate_cs_number2'], 'brand'=>$row['brand'], 'customer_fullname'=>$row['customer_fullname'], 'customer_mobile_number'=>$row['customer_mobile_number'], 'customer_email'=>$row['customer_email'], 'company'=>$row['company'], 'dealer'=>$row['dealer'], 'uploaded_by'=>$row['uploaded_by'], 'date_uploaded'=>$row['date_uploaded'], 'modified_by'=>$modifier . $date_modified )); } echo json_encode($json_arr['rows']); } else if($type == 2){ // ----------------------------------------------- resources/views/common/scripts/finance/finance_information.js [function: loadFinanceDetails] --> $policy_number = $db->escape($_POST['policy_number']); $policy_issue_date = strtotime($db->escape($_POST['policy_issue_date'])); $date = date('Y-m-d', $policy_issue_date); $count = " COUNT() "; $fields = " f.customer_fullname, f.customer_mobile_number, f.customer_email, f.sales_consultant, f.customer_address, f.bank_name, fsb.name AS brand, fscm.name AS model, fscmv.name AS variant, f.locked_in, f.locked_in_years, f.terms, DATE_FORMAT(f.date_uploaded, '%b %d, %Y / %h:%i:%s %p') AS date_uploaded, concat(e.first_name, ' ', e.last_name) AS uploaded_by, concat(e2.first_name, ' ', e2.last_name) AS modified_by, DATE_FORMAT(f.date_modified, '%b %d, %Y') AS date_modified, f.add_source "; $query = "SELECT %s FROM finance f INNER JOIN finance_source_brand fsb ON fsb.id = f.brand_id INNER JOIN finance_source_car_model fscm ON fscm.id = f.model_id INNER JOIN finance_source_car_model_variant fscmv ON fscmv.id = f.variant_id INNER JOIN employee e ON e.id = f.uploaded_by INNER JOIN employee e2 ON e2.id = f.modified_by WHERE f.policy_number = '$policy_number' AND f.policy_issue_date = '$date'"; // echo sprintf($query, $fields); return; $finance_query = $db->sql_query(sprintf($query, $fields)); while($row = $finance_query->fetch_assoc()) { $json_arr['rows'] = array_merge($json_arr['rows'], array( 'customer_fullname'=>$row['customer_fullname'], 'mobile_number'=>$row['customer_mobile_number'], 'email'=>$row['customer_email'], 'customer_email'=>$row['customer_email'], 'brand'=>$row['brand'], 'model'=>$row['model'], 'variant'=>$row['variant'], 'sales_consultant'=>$row['sales_consultant'], 'customer_address'=>$row['customer_address'], 'bank_name'=>$row['bank_name'], 'locked_in_years'=>$row['locked_in_years'] == 0 ? "0" : $row['locked_in_years'], 'locked_in'=>$row['locked_in'] == 0 ? "No" : "Yes", 'terms'=>$row['terms'], 'uploaded_by'=>$row['uploaded_by'], 'modified_by'=>$row['modified_by'], 'date_uploaded'=>$row['date_uploaded'], 'date_modified'=>$row['date_modified'], 'add_source'=>$row['add_source'] == 1 ? "(By import)" : "(Manual add)", )); } echo json_encode($json_arr['rows']); } ?>

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