File manager

File manager - Edit - /home/autoph/public_html/connectv1/app/finance_pdc/pdc_information.php

Back
<?php include_once("../../cfg/db.php"); include_once("../../api/controllers/utility.php"); $utility = new Utility(); $type = $db->escape($_POST['type']); if($type == 1){ // resources/views/common/scripts/finance_pdc/pdc_information > function loadPDCInformation() $pdc_plate_cs_number1 = $db->escape($_POST['pdc_plate_cs_number1']); $json_arr['rows'] = array(); $count = " COUNT(*) "; $fields = " fp.plate_cs_number1, fp.plate_cs_number2, fsb.name AS brand, fp.client_name, sc.code AS company, sd.name AS dealer, fp.client_mobile, fp.client_email, DATE_FORMAT(fp.date_added, '%b %d, %Y / %h:%i:%s %p') AS date_added, concat(e1.first_name, ' ', e1.last_name) AS added_by, concat(e2.first_name, ' ', e2.last_name) AS modified_by, DATE_FORMAT(fp.date_modified, '%b %d, %Y / %h:%i:%s %p') AS date_modified "; $query = "SELECT %s FROM finance_pdc fp INNER JOIN source_company sc ON fp.company_id = sc.id INNER JOIN source_dealer sd ON fp.dealer_id = sd.id INNER JOIN finance_source_brand fsb ON fsb.id = fp.brand_id INNER JOIN employee e1 ON e1.id = fp.added_by INNER JOIN employee e2 ON e2.id = fp.modified_by WHERE fp.plate_cs_number1 = '$pdc_plate_cs_number1' GROUP BY fp.plate_cs_number1"; // echo sprintf($query, $fields); return; $pdc_query = $db->sql_query(sprintf($query, $fields)); while($row = $pdc_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_number1'] != "" && $row['plate_cs_number2'] == "" ? $row['plate_cs_number1'] : ($row['plate_cs_number1'] == "" && $row['plate_cs_number2'] != "" ? $row['plate_cs_number2'] : $row['plate_cs_number1'] . "/" . $row['plate_cs_number2']), 'brand'=>$row['brand'], 'client_name'=>$row['client_name'], 'client_mobile'=>$row['client_mobile'], 'client_email'=>$row['client_email'], 'company'=>$row['company'], 'dealer'=>$row['dealer'], 'uploaded_by'=>$row['added_by'], 'date_added'=>$row['date_added'], 'modified_by'=>$modifier . $date_modified )); } echo json_encode($json_arr['rows']); } else if($type == 2){ // resources/views/common/scripts/finance_pdc/pdc_information > click pdc information table: get info $record_id = $db->escape($_POST['record_id']); $json_arr = array(); $query = "SELECT fp.client_name, fp.client_mobile, fp.client_email, bd.abbreviation AS bank, fp.branch, fscm.name AS model, fscmv.name AS variant, fp.check_amount, DATE_FORMAT(fp.date_added, '%b %d, %Y / %h:%i:%s %p') AS date_added, DATE_FORMAT(fp.date_modified, '%b %d, %Y / %h:%i:%s %p') AS date_modified, concat(e1.first_name, ' ', e1.last_name) AS added_by, concat(e2.first_name, ' ', e2.last_name) AS modified_by FROM finance_pdc fp INNER JOIN bank_db bd ON bd.id = fp.bank_id INNER JOIN finance_source_car_model fscm ON fscm.id = fp.model_id INNER JOIN finance_source_car_model_variant fscmv ON fscmv.id = fp.variant_id INNER JOIN employee e1 ON e1.id = fp.added_by INNER JOIN employee e2 ON e2.id = fp.modified_by WHERE fp.id = '$record_id'"; // echo $query; return; $pdc_info_query_list = $db->sql_query($query); foreach($pdc_info_query_list AS $row){ $json_arr['client_name'] = $row['client_name']; $json_arr['client_mobile'] = $row['client_mobile']; $json_arr['client_email'] = $row['client_email']; $json_arr['bank_branch'] = $row['bank'] . " / " . $row['branch']; $json_arr['check_amount'] = $row['check_amount']; $json_arr['model'] = $row['model']; $json_arr['variant'] = $row['variant']; $json_arr['date_added'] = $row['date_added']; $json_arr['added_by'] = $row['added_by']; $json_arr['modified_by'] = $row['modified_by'] . " (" . $row['date_modified'] . ")"; } echo json_encode($json_arr); } ?>

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