File manager

File manager - Edit - /home/autoph/public_html/connectv1/api/sales/sales.php

Back
<?php include_once("../../cfg/db.php"); if ($_SERVER["REQUEST_METHOD"] != "POST") { $return_arr["message"]=" You are not allowed to do this action."; echo $return_arr["message"]; return; } if(isset($_REQUEST['apiKey']) ){ $apiKey = $_REQUEST['apiKey']; if($apiKey === '43245237842'){ if(isset($_REQUEST['customer_id'])){ $customer_record_id = $db -> escape(trim($_REQUEST['customer_id'])); echo json_encode(getFilteredSalesData($customer_record_id,'ASC','2',$db)); }else{ $return_arr["message"]=" You are not allowed to do this action."; echo $return_arr["message"]; return; } }else{ $return_arr["message"]=" You are not allowed to do this action."; echo $return_arr["message"]; return; } }else{ $return_arr["message"]=" You are not allowed to do this action."; echo $return_arr["message"]; return; } function getFilteredSalesData($customer_record_id,$order_by,$sort_by,$db){ $customer_id = " AND v.customer_record_id = $customer_record_id "; switch(intval($sort_by)){ case 1: //lastname $filter_sort_by = " c.last_name "; break; case 2: //firstname $filter_sort_by = " c.first_name "; break; case 3: //corporation name $filter_sort_by = " c.corporation_name "; break; case 4: //date created $filter_sort_by = " s.activity_date "; break; case 5: //date uploaded $filter_sort_by = " s.date_uploaded "; break; } $return_data['sales'] = array(); $query = "SELECT %s FROM sales s INNER JOIN vehicle v ON s.vehicle_id = v.id LEFT OUTER JOIN service se ON se.vehicle_id = v.id INNER JOIN source_brand sb ON v.brand_id=sb.id INNER JOIN source_car_model scm ON v.model_id=scm.id INNER JOIN source_company_dealer scd ON scd.id=s.company_dealer_id INNER JOIN source_company sc ON sc.id = scd.company_id INNER JOIN source_dealer sd ON sd.id= scd.dealer_id INNER JOIN employee e ON s.upload_by = e.id INNER JOIN source_dms sdms ON sc.dms_id = sdms.id LEFT OUTER JOIN customer c ON v.customer_record_id = c.id LEFT OUTER JOIN customer_contact cc ON c.id = cc.customer_id LEFT OUTER JOIN customer_category ccat ON c.category_id = ccat.id LEFT OUTER JOIN sales_consultant sct ON s.sales_person = sct.id WHERE 1 %s /* custromer ids / AND v.status = 1 AND s.status = 1 GROUP BY v.id ORDER BY $filter_sort_by $order_by"; $count = " count(1) "; $fields = " v.brand_id,v.model_id, sb.name as brand, scm.name as model,s.id, s.order_number, s.po_number, s.activity_date, s.customer_id,s.sales_cost,s.sale_price,s.sale_discount,s.claim_amount,s.floor_plan_amount,v.conduction_sticker,v.plate_number,s.serial_number,s.engine_number,s.claim_number,s.deal_number,s.deal_date,s.stock_number, s.warehouse,s.age_of_unit,sdms.name as dms_name,sc.code as company_name,sd.code as dealer_name, s.date_uploaded,concat(e.first_name,' ',e.last_name) as upload_by,CONCAT(sct.first_name, ' ', sct.last_name) as sales_person, IF( c.type = 1, concat(c.first_name,' ',c.middle_name,' ',c.last_name),c.corporation_name ) as name "; echo (sprintf($query, $fields,$customer_id)); exit; $data_list = $db -> sql_query(sprintf($query, $fields,$customer_id)); $query_count = $db -> select("SELECT COUNT() FROM ( ".sprintf($query, $count,$customer_id)." ) as total_count"); if( $query_count > 0){ $record_counter = 1; foreach ($data_list as $data){ $return_data['sales'] = array_merge($return_data['sales'],array(array( // 'No.'=>$record_counter++, 'record_id'=>$data['id'], 'customer_id'=>$data['customer_id'], 'brand'=> $data['brand'], 'model'=> $data['model'], 'plate_number'=>$data['plate_number'], 'conduction_sticker'=>$data['conduction_sticker'], 'order_number'=>$data['order_number'], 'po_number'=>$data['po_number'], 'sales_cost'=>($data['sales_cost'] <> '' ) ? number_format($data['sales_cost'],2) : "", 'sale_price'=>($data['sale_price'] <> '' ) ? number_format($data['sale_price'],2) : "", 'sale_discount'=>($data['sale_discount'] <> '' ) ? number_format($data['sale_discount'],2) : "", 'claim_amount'=>$data['claim_amount'], 'floor_plan_amount'=>$data['floor_plan_amount'], 'serial_number'=>$data['serial_number'], 'engine_number'=>$data['engine_number'], 'claim_number'=>$data['claim_number'], 'deal_number'=>$data['deal_number'], 'deal_date'=>$data['deal_date'], 'stock_number'=>$data['stock_number'], 'warehouse'=>$data['warehouse'], 'age_of_unit'=>$data['age_of_unit'], 'sales_person'=>$data['sales_person'], 'dms'=>$data['dms_name'], 'company'=>$data['company_name'], 'dealer'=>$data['dealer_name'], 'sales_date'=>$data['activity_date'], 'date_uploaded'=>$data['date_uploaded'], 'upload_by'=>$data['upload_by'], ))); } $return_data['found'] = $query_count." Record".((intval($query_count) < 2) ? '' : 's' )." Found"; }else{ $return_data['found'] = "No Record Found"; // $return_data = array_merge($return_data,array(array('Order Number'=>'','PO Number'=>'','Date'=>'','Sales Person'=>'','Customer Name'=>''))); } $return_data['total'] = $query_count; return array($return_data); } function isNotEmpty($data){ return preg_match('/\S/', $data); } function quote($str) { return sprintf("'%s'", $str); } ?>

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