File manager

File manager - Edit - /home/autoph/public_html/data03252025consolidation/app/sales/sales_information.php

Back
<?php include('../../cfg/db.php'); $fmt = new NumberFormatter('PHP', NumberFormatter::CURRENCY); if(isset($_POST['sales_id'])){ $id = $db->escape($_POST['sales_id']); $where_data = " s.id='$id' "; } if(isset($_POST['order_number'])){ $order_number = $db->escape($_POST['order_number']); $where_data = " s.order_number='$order_number' "; } $fmt = new NumberFormatter('PHP', NumberFormatter::CURRENCY); if(isset($_POST['customer_id'])){ $customer_record_id = $db->escape(trim($_POST['customer_id'])); } else { $customer_record_id = ""; } //get customer name $customer_name = ""; $customer_email = ""; $customer_mobile = ""; $customer_type = ""; $query = "SELECT IF(ci.type = 1, concat(ci.first_name,' ',ci.middle_name,' ',ci.last_name, ' ', IF(suffix_id < 1, '', (SELECT suffix_name FROM all_suffix WHERE id = ci.suffix_id ))) ,ci.corporation_name ) as name, cc.email_1,cc.mobile_phone_1,ci.type FROM customer ci INNER JOIN customer_contact cc ON ci.id = cc.customer_id INNER JOIN customer_dms cd ON cd.customer_record_id=ci.id WHERE ci.id = (SELECT customer_record_id FROM customer_dms WHERE customer_dms_id='$customer_record_id' LIMIT 1) LIMIT 1"; // echo $query; return; $customer_info = $db->sql_query($query); foreach($customer_info as $customer_info_data){ $customer_name = $customer_info_data['name']; $customer_email = $customer_info_data['email_1']; $customer_mobile = $customer_info_data['mobile_phone_1']; $customer_type = (intval($customer_info_data['type'])) ? 'Individual' : 'Corporate' ; } $query_sales_info = "SELECT %s FROM sales s INNER JOIN source_brand sb ON s.brand_id = sb.id INNER JOIN source_car_model scm ON s.model_id = scm.id INNER JOIN source_insurance_company sic ON s.insurance_company_id=sic.id INNER JOIN source_insurance_type sit ON s.insurance_type_id=sit.id INNER JOIN source_of_inquiry soq ON s.source_id=soq.id INNER JOIN source_mode_of_contact smoc ON s.mode_of_contact_id=smoc.id INNER JOIN source_company_dealer scd ON s.company_dealer_id=scd.id INNER JOIN source_dealer sd ON scd.dealer_id=sd.id INNER JOIN source_company sc ON scd.company_id=sc.id INNER JOIN employee e ON s.upload_by=e.id INNER JOIN all_suffix alls ON e.suffix_id=alls.id INNER JOIN source_dms sdms ON s.dms_id=sdms.id WHERE %s "; //echo $query_sales_info; return; $fields = " sc.code as company,sd.code as dealer,s.customer_id, s.order_number, s.serial_number, s.engine_number, s.conduction_sticker,s.plate_number, s.po_number, s.floor_plan_amount, DATE_FORMAT(s.activity_date, '%M %d, %Y') AS activity_date, s.sales_cost, s.sale_price, s.sale_discount, DATE_FORMAT(s.insurance_expiration_date, '%M %d, %Y') AS insurance_expiration_date, sic.name AS insurance_company, sit.name AS insurance_type, soq.name AS inquiry_source, smoc.name AS mode_of_contact, s.warehouse, s.stock_number, s.age_of_unit, s.body_size_code, s.claim_number, s.claim_amount, s.deal_number, DATE_FORMAT(s.deal_date, '%M %d, %Y') AS deal_date, s.sales_person, DATE_FORMAT(s.delivery_date, '%M %d, %Y') AS delivery_date, sd.name AS source_dealer, sc.name AS source_company, DATE_FORMAT(s.date_uploaded, '%M %d, %Y - %h:%i:%s %p') AS date_uploaded, e.first_name AS efname, e.middle_name AS emname, e.last_name AS elname, alls.suffix_name AS suffix, sdms.name AS dms ,sb.name as brand,scm.name as model,s.brand_id,s.model_id "; $count_data = " count(1) "; //echo sprintf($query_sales_info,$fields,$where_data); return; $sales_info = $db -> return_result(sprintf($query_sales_info,$fields,$where_data)); $count = $db -> select(sprintf($query_sales_info,$count_data,$where_data)); $get_brand_model = "SELECT sb.name as brand, scm.name as model FROM `vehicle` v INNER JOIN source_brand sb ON v.`brand_id` = sb.id INNER JOIN source_car_model scm ON v.`model_id` = scm.id WHERE 1 "; if($count == 0){ //$arr_v['customer_id'] = ""; $arr_v['customer_id'] = ""; $arr_v['customer_name'] = ""; $arr_v['customer_email'] = ""; $arr_v['customer_mobile'] = ""; $arr_v['customer_type'] = ""; $arr_v['order_number'] = ""; $arr_v['po_number'] = ""; $arr_v['serial_number'] = ""; $arr_v['engine_number'] = ""; $arr_v['cs_number'] = ""; $arr_v['plate_number'] = ""; $arr_v['warehouse'] = ""; $arr_v['stock_number'] = ""; $arr_v['age_of_unit'] = ""; $arr_v['body_size_code'] = ""; $arr_v['sales_cost'] = ""; $arr_v['sale_price'] = ""; $arr_v['sale_discount'] = ""; $arr_v['claim_amount'] = ""; $arr_v['floor_plan_amount'] = ""; $arr_v['sales_person'] = ""; $arr_v['claim_number'] = ""; $arr_v['deal_number'] = ""; $arr_v['deal_date'] = ""; $arr_v['dealer'] = ""; $arr_v['company'] = ""; $arr_v['source_company'] = ""; $arr_v['source_dealer'] = ""; $arr_v['delivery_date'] = ""; $arr_v['source'] = ""; $arr_v['mode_of_contact'] = ""; $arr_v['insurance_company'] = ""; $arr_v['insurance_type'] = ""; $arr_v['insurance_expiration_date'] = ""; $arr_v['date_uploaded'] = ""; $arr_v['uploaded_by'] = ""; $arr_v['model'] = ""; $arr_v['brand'] = ""; $arr_v['dms'] = ""; $arr_v['activity_date'] = ""; } else { foreach($sales_info AS $data){ $car['brand'] = ""; $car['model'] = ""; if(isNotEmpty($data['plate_number']) && isNotEmpty($data['conduction_sticker'])){ $get_brand_model = $get_brand_model." AND v.plate_number='".$data['plate_number']."' OR v.conduction_sticker='".$data['conduction_sticker']."'"; $car_info = $db -> sql_query($get_brand_model); foreach($car_info as $car_data){ $car['brand'] = $car_data['brand']; $car['model'] = $car_data['model']; } } else if(isNotEmpty($data['plate_number'])){ $get_brand_model = $get_brand_model." AND v.plate_number= '".$data['plate_number']."'"; $car_info = $db -> sql_query($get_brand_model); foreach($car_info as $car_data){ $car['brand'] = $car_data['brand']; $car['model'] = $car_data['model']; } } else if(isNotEmpty($data['conduction_sticker'])){ $get_brand_model = $get_brand_model." AND v.conduction_sticker= '".$data['conduction_sticker']."'"; $car_info = $db -> sql_query($get_brand_model); foreach($car_info as $car_data){ $car['brand'] = $car_data['brand']; $car['model'] = $car_data['model']; } } $suffix = $data['suffix']; if($data['suffix'] == "None"){ $suffix = ""; } $arr_v['customer_name'] = $customer_name; $arr_v['customer_email'] =$customer_email; $arr_v['customer_mobile'] = $customer_mobile; $arr_v['customer_type'] = $customer_type; $arr_v['customer_id'] = $data['customer_id']; $arr_v['order_number'] = $data['order_number']; $arr_v['po_number'] = $data['po_number']; $arr_v['serial_number'] = $data['serial_number']; $arr_v['engine_number'] = $data['engine_number']; $arr_v['cs_number'] = $data['conduction_sticker']; $arr_v['plate_number'] = $data['plate_number']; $arr_v['warehouse'] = $data['warehouse']; $arr_v['stock_number'] = $data['stock_number']; $arr_v['age_of_unit'] = $data['age_of_unit']; $arr_v['body_size_code'] = $data['body_size_code']; $arr_v['sales_cost'] = ($data['sales_cost'] <> '' ) ? $fmt->formatCurrency($data['sales_cost'], "Php") : ""; $arr_v['sale_price'] = ($data['sale_price'] <> '' ) ? $fmt->formatCurrency($data['sale_price'], "Php") : ""; $arr_v['sale_discount'] = ($data['sale_discount'] <> '' ) ? $fmt->formatCurrency($data['sale_discount'], "Php") : ""; $arr_v['claim_amount'] = ($data['claim_amount'] <> '' ) ? $fmt->formatCurrency($data['claim_amount'], "Php") : ""; $arr_v['floor_plan_amount'] = ($data['floor_plan_amount'] <> '' ) ? $fmt->formatCurrency($data['floor_plan_amount'], "Php") : ""; $arr_v['sales_person'] = $data['sales_person']; $arr_v['claim_number'] = $data['claim_number']; $arr_v['deal_number'] = $data['deal_number']; $arr_v['deal_date'] = $data['deal_date']; $arr_v['source_company'] = $data['source_company']; $arr_v['source_dealer'] = $data['source_dealer']; $arr_v['delivery_date'] = $data['delivery_date']; $arr_v['source'] = $data['inquiry_source']; $arr_v['mode_of_contact'] = $data['mode_of_contact']; $arr_v['insurance_company'] = $data['insurance_company']; $arr_v['insurance_type'] = $data['insurance_type']; $arr_v['insurance_expiration_date'] = $data['insurance_expiration_date']; $arr_v['activity_date'] = $data['activity_date']; $arr_v['brand'] = (intval($data['brand_id']) <> 0) ? $data['brand'] : $car['brand']; $arr_v['model'] = (intval($data['model_id']) <> 0) ? $data['model'] : $car['model']; $arr_v['dealer'] = $data['dealer']; $arr_v['company'] = $data['company']; $arr_v['date_uploaded'] = $data['date_uploaded']; $arr_v['uploaded_by'] = $data['efname'] . " " . $data['emname'] . " " . $data['elname'] . " " . $suffix; $arr_v['dms'] = $data['dms']; } } echo json_encode($arr_v); function isNotEmpty($data){ return preg_match('/\S/', $data); } ?>

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