File manager

File manager - Edit - /home/autoph/public_html/connectv1/app/sales/vehicle_sales_information.php.bak

Back
<?php include('../../cfg/db.php'); $order_number = $db->escape($_POST['order_number']); $fmt = new NumberFormatter('PHP', NumberFormatter::CURRENCY); //echo $id; return; //get customer name if(isset($_POST['cust_id'])){ $customer_record_id = $db->escape(trim($_POST['cust_id'])); } else { $customer_record_id = ""; } //echo $customer_record_id; return; $customer_name = ""; $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 FROM customer ci 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"; $customer_name = $db->select($query); $query_sales_info = "SELECT s.customer_id, s.order_number, s.serial_number, s.engine_number, s.conduction_sticker, s.po_number, s.floor_plan_amount, s.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 FROM sales s 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.order_number='$order_number'"; //echo $query_sales_info; return; $sales_info = $db -> return_result($query_sales_info); $count = $db -> sql_query($query_sales_info) -> num_rows; if($count == 0){ //$arr_v['customer_id'] = ""; $arr_v['customer_id'] = ""; $arr_v['customer_name'] = ""; $arr_v['order_number'] = ""; $arr_v['po_number'] = ""; $arr_v['serial_number'] = ""; $arr_v['engine_number'] = ""; $arr_v['cs_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['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['dms'] = ""; $arr_v['activity_date'] = ""; } else { foreach($sales_info as $data){ $suffix = $data['suffix']; if($data['suffix'] == "None"){ $suffix = ""; } $arr_v['customer_name'] = $customer_name; $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['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['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