PK''�ZNMsales_about_side.phpnu�[��

Order Number:

PO Number:

Sales Date:

Sales Cost:

Sales Price:

Brand :
Model :
Plate Number :
Conduction Sticker :
Serial Number :
Engine Number :
Customer :
Type:
Email:
Mobile:
Sales Person:

PK''�Z��d�q�qmodal/add_sales.phpnu�[�� PK''�ZS�C,nnsales_information.phpnu�[��

Date created:

Customer Discount

Floor Plan Amount

Claim Number

Claim Amount

Deal Number

Deal Date

Delivery Date

Warehouse

Stock Number

Age of Unit

Body Size Code

Insurance Company

Insurance Type

Insurance Expiration Date

Date Uploaded:

Uploaded By:

DMS:
Company:
Dealer:

PK�;�Z�9!F�� sales.phpnu�[�� 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); } ?>PK�;�Z 4�6�� error_lognu�[��[24-Jun-2025 08:59:28 Asia/Manila] PHP Warning: mysqli::query(): (HY000/3): Error writing file '/tmp/MYrCdqWA' (Errcode: 28 - No space left on device) in /home/autoph/public_html/connectv1/cfg/func.php on line 30 [25-Jun-2025 15:08:11 Asia/Manila] PHP Warning: mysqli::query(): (HY000/3): Error writing file '/tmp/MYXNgLvZ' (Errcode: 28 - No space left on device) in /home/autoph/public_html/connectv1/cfg/func.php on line 30 PK�;�ZU��tntnsalesv2.phpnu�[��isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1' ; if(isset($_REQUEST['apiKey']) ){ $apiKey = $_REQUEST['apiKey']; if($apiKey === '1289076901116235' && $utility->isPostMethod($server_method)){ //Create $vehicle_id = isset($_REQUEST['vehicle_id']) ? $db->escape($_REQUEST['vehicle_id']) : '-1'; $sale_id = $utility->generate_uuid($db); $vehicle_data = isset($_REQUEST['sales_data']) ? $_REQUEST['sales_data'] : '{}'; $vehicle_data_array = json_decode($vehicle_data, true); $vehicle_data_array = array_map(array($utility, 'upperCaseNestedArray'), $vehicle_data_array); $vehicle_data_array = array_map(array($db, 'escape'), $vehicle_data_array); $insurance_company_name = ($vehicle_data_array["mod-dd-insurance-company"]); if($utility->isNotEmpty($insurance_company_name)){ $insurance_company_id = $insurance_company->read_insurance_company_id_by_name($insurance_company_name, $db); if(!$utility->isNotEmpty($insurance_company_id)){ $insurance_company_id = $insurance_company->create_insurance_company($insurance_company_name, $db); } } else { $insurance_company_id = 0; } // echo $insurance_company_id;exit; $finance_company_name = ($vehicle_data_array["mod-dd-finance-company"]); if($utility->isNotEmpty($finance_company_name)){ $finance_company_id = $finance_company->read_finance_company_id_by_name($finance_company_name, $db); if(!$utility->isNotEmpty($finance_company_id)){ $finance_company_id = $finance_company->create_finance_company($finance_company_name, $db); } } else { $finance_company_id = 0; } //DATE FORMATS $insurance_expiration_date = ""; if($utility->isNotEmpty($vehicle_data_array["mod-insurance-exp-date"])){ $insurance_expiration_date = $utility->convert_sql_date($vehicle_data_array["mod-insurance-exp-date"],'mm/dd/yyyy'); } $finance_expiration_date = ""; if($utility->isNotEmpty($vehicle_data_array["mod-finance-exp-date"])){ $finance_expiration_date = $utility->convert_sql_date($vehicle_data_array["mod-finance-exp-date"],'mm/dd/yyyy'); } $delivery_date = ""; if($utility->isNotEmpty($vehicle_data_array["mod-delivery-date"])){ $delivery_date = $utility->convert_sql_date($vehicle_data_array["mod-delivery-date"],'mm/dd/yyyy'); } $sales_date = ""; if($utility->isNotEmpty($vehicle_data_array["mod-sales-date"])){ $sales_date = $utility->convert_sql_date($vehicle_data_array["mod-sales-date"],'mm/dd/yyyy'); } $insert_vehicle_sales = $sales->create_vehicle_sales( $sale_id, '',//$customer_dms_id, $vehicle_id, '',//$vehicle_data_array['mod-cs-number'], '',//$vehicle_data_array['mod-plate-number'], $vehicle_data_array['mod-order-number'], '',//$floor_plan_amount, $sales_date, $vehicle_data_array['mod-sales-cost'], $vehicle_data_array['mod-sales-price'], $vehicle_data_array['mod-sales-discount'], $insurance_company_id, $vehicle_data_array['mod-dd-insurance-type'], $insurance_expiration_date, $finance_company_id, $finance_expiration_date, $vehicle_data_array['mod-dd-source-of-sale'], '0',//$mode_of_contact_id, '',//$warehouse, '',//$stock_number, '',//$age_of_unit, '',//$body_size_code, '',//$claim_number, '',//$claim_amount, '',//$deal_number, '',//$deal_date, $vehicle_data_array['mod-dd-sales-consultant'], $vehicle_data_array['mod-driver'], $delivery_date, $vehicle_data_array['mod-dd-type-of-payment'], $vehicle_data_array['mod-dd-group-manager'], '0',//$company_dealer_id, '',//$purchase_car_as_id, $_SESSION['user']['id'], '1',//$status $vehicle_data_array['mod-end-user'], $vehicle_data_array['mod-dd-mode-of-sale'], $db); $vehicle_brands_offered = isset($_REQUEST['vehicle_brands_offered']) ? $_REQUEST['vehicle_brands_offered'] : '' ; $vehicle_brands_offered_array = array(); if($vehicle_brands_offered <> ''){ $vehicle_brands_offered = array_map(array($utility, 'upperCaseNestedArray'), $vehicle_brands_offered); $vehicle_brands_offered = array_map(array($db, 'escape'), $vehicle_brands_offered); foreach ($vehicle_brands_offered as $offered){ $description = ($offered['Description']); $brands_offered_id = ($offered['Brand']); $model_offered_id = ($offered['Model']); // $model_offered_name = ($offered['Model']); // $model_offered_id = $model->read_model_id_by_name($model_offered_name, $db); $vehicle_brands_offered_array[] = "('$sale_id','" . $brands_offered_id."', '".$model_offered_id."', '".$description."')"; } $vehicle_brands_offered_to_insert = implode(',', $vehicle_brands_offered_array); $sales->create_sales_brands_offered($vehicle_brands_offered_to_insert, $db); } if($insert_vehicle_sales > 0){ $return_arr["status"] = 1; $return_arr["message"] = "Successfully inserted"; }else { $return_arr["status"] = 0; $return_arr["message"] = "Record not inserted"; } echo json_encode($return_arr); }else if($apiKey === '1767826750337195' && $utility->isPostMethod($server_method)){ //Update $vehicle_id = isset($_REQUEST['vehicle_id']) ? $db->escape($_REQUEST['vehicle_id']) : '-1'; $sale_id = $sales->get_sales_id_by_vehicle_id($vehicle_id,$db); $vehicle_data = isset($_REQUEST['sales_data']) ? $_REQUEST['sales_data'] : '{}'; $vehicle_data_array = json_decode($vehicle_data, true); $vehicle_data_array = array_map(array($utility, 'upperCaseNestedArray'), $vehicle_data_array); $vehicle_data_array = array_map(array($db, 'escape'), $vehicle_data_array); $insurance_company_name = ($vehicle_data_array["mod-dd-insurance-company"]); if($utility->isNotEmpty($insurance_company_name)){ $insurance_company_id = $insurance_company->read_insurance_company_id_by_name($insurance_company_name, $db); if(!$utility->isNotEmpty($insurance_company_id)){ $insurance_company_id = $insurance_company->create_insurance_company($insurance_company_name, $db); } } else { $insurance_company_id = 0; } $finance_company_name = ($vehicle_data_array["mod-dd-finance-company"]); if($utility->isNotEmpty($finance_company_name)){ $finance_company_id = $finance_company->read_finance_company_id_by_name($finance_company_name, $db); if(!$utility->isNotEmpty($finance_company_id)){ $finance_company_id = $finance_company->create_finance_company($finance_company_name, $db); } } else { $finance_company_id = 0; } // echo $finance_company_id;exit; //DATE FORMATS $insurance_expiration_date = ""; if($utility->isNotEmpty($vehicle_data_array["mod-insurance-exp-date"])){ $insurance_expiration_date = $utility->convert_sql_date($vehicle_data_array["mod-insurance-exp-date"],'mm/dd/yyyy'); } $finance_expiration_date = ""; if($utility->isNotEmpty($vehicle_data_array["mod-finance-exp-date"])){ $finance_expiration_date = $utility->convert_sql_date($vehicle_data_array["mod-finance-exp-date"],'mm/dd/yyyy'); } $delivery_date = ""; if($utility->isNotEmpty($vehicle_data_array["mod-delivery-date"])){ $delivery_date = $utility->convert_sql_date($vehicle_data_array["mod-delivery-date"],'mm/dd/yyyy'); } $sales_date = ""; if($utility->isNotEmpty($vehicle_data_array["mod-sales-date"])){ $sales_date = $utility->convert_sql_date($vehicle_data_array["mod-sales-date"],'mm/dd/yyyy'); } // $insert_vehicle_sales = $sales->create_vehicle_sales( // $sale_id, // '',//$customer_dms_id, // $vehicle_id, // '',//$vehicle_data_array['mod-cs-number'], // '',//$vehicle_data_array['mod-plate-number'], // $vehicle_data_array['mod-order-number'], // '',//$floor_plan_amount, // $sales_date, // $vehicle_data_array['mod-sales-cost'], // $vehicle_data_array['mod-sales-price'], // $vehicle_data_array['mod-sales-discount'], // $insurance_company_id, // $vehicle_data_array['mod-dd-insurance-type'], // $insurance_expiration_date, // $finance_company_id, // $finance_expiration_date, // $vehicle_data_array['mod-dd-source-of-sale'], // '0',//$mode_of_contact_id, // '',//$warehouse, // '',//$stock_number, // '',//$age_of_unit, // '',//$body_size_code, // '',//$claim_number, // '',//$claim_amount, // '',//$deal_number, // '',//$deal_date, // $vehicle_data_array['mod-dd-sales-consultant'], // $vehicle_data_array['mod-driver'], // $delivery_date, // $vehicle_data_array['mod-dd-type-of-payment'], // $vehicle_data_array['mod-dd-group-manager'], // '0',//$company_dealer_id, // '',//$purchase_car_as_id, // '0',//$vehicle_data_array['mod-dd-dms'], // $_SESSION['user']['id'], // '1',//$status // '',//$end_user_name, // $vehicle_data_array['mod-dd-mode-of-sale'], // $db); $insert_vehicle_sales = $sales->update_vehicle_sales( $sale_id, '',//$customer_dms_id, $vehicle_id, '',//$vehicle_data_array['mod-cs-number'], '',//$vehicle_data_array['mod-plate-number'], $vehicle_data_array['mod-order-number'], '',//$floor_plan_amount, $sales_date, $vehicle_data_array['mod-sales-cost'], $vehicle_data_array['mod-sales-price'], $vehicle_data_array['mod-sales-discount'], $insurance_company_id, $vehicle_data_array['mod-dd-insurance-type'], $insurance_expiration_date, $finance_company_id, $finance_expiration_date, $vehicle_data_array['mod-dd-source-of-sale'], '0',//$mode_of_contact_id, '',//$warehouse, '',//$stock_number, '',//$age_of_unit, '',//$body_size_code, '',//$claim_number, '',//$claim_amount, '',//$deal_number, '',//$deal_date, $vehicle_data_array['mod-dd-sales-consultant'], $vehicle_data_array['mod-driver'], $delivery_date, $vehicle_data_array['mod-dd-type-of-payment'], $vehicle_data_array['mod-dd-group-manager'], '0',//$company_dealer_id, '',//$purchase_car_as_id, $_SESSION['user']['id'], '1',//$status $vehicle_data_array['mod-end-user'], $vehicle_data_array['mod-dd-mode-of-sale'], $db); $vehicle_brands_offered = isset($_REQUEST['vehicle_brands_offered']) ? $_REQUEST['vehicle_brands_offered'] : '' ; $sales->delete_sales_offered($sale_id,$db); $vehicle_brands_offered_array = array(); if($vehicle_brands_offered <> ''){ $vehicle_brands_offered = array_map(array($utility, 'upperCaseNestedArray'), $vehicle_brands_offered); $vehicle_brands_offered = array_map(array($db, 'escape'), $vehicle_brands_offered); foreach ($vehicle_brands_offered as $offered){ $description = ($offered['Description']); $brands_offered_id = ($offered['Brand']); $model_offered_id = ($offered['Model']); // $model_offered_name = ($offered['Model']); // $model_offered_id = $model->read_model_id_by_name($model_offered_name, $db); $vehicle_brands_offered_array[] = "('$sale_id','" . $brands_offered_id."', '".$model_offered_id."', '".$description."')"; } $vehicle_brands_offered_to_insert = implode(',', $vehicle_brands_offered_array); $sales->create_sales_brands_offered($vehicle_brands_offered_to_insert, $db); } if($insert_vehicle_sales > 0){ $return_arr["status"] = 1; $return_arr["message"] = "Successfully updated"; }else { $return_arr["status"] = 0; $return_arr["message"] = "Record not updated"; } echo json_encode($return_arr); } else if($apiKey === '3900331554582720' && $utility->isPostMethod($server_method)){ //Create $plate_number = isset($_REQUEST['plate_number']) ? $_REQUEST['plate_number'] : '-1'; $conduction_sticker = isset($_REQUEST['conduction_sticker']) ? $_REQUEST['conduction_sticker'] : '-1'; $brand_name = isset($_REQUEST['brand']) ? $_REQUEST['brand'] : '-1'; $model_name = isset($_REQUEST['model']) ? $_REQUEST['model'] : '-1'; $color_name = isset($_REQUEST['color']) ? $_REQUEST['color'] : '-1'; $order_number = isset($_REQUEST['order_number']) ? $_REQUEST['order_number'] : '-1'; $po_number = isset($_REQUEST['po_number']) ? $_REQUEST['po_number'] : '-1'; $sales_date = isset($_REQUEST['sales_date']) ? $_REQUEST['sales_date'] : '-1'; $sales_cost = isset($_REQUEST['sales_cost']) ? $_REQUEST['sales_cost'] : '-1'; $sales_price = isset($_REQUEST['sales_price']) ? $_REQUEST['sales_price'] : '-1'; $floor_plan_amount = isset($_REQUEST['floor_plan_amount']) ? $_REQUEST['floor_plan_amount'] : '-1'; $claim_amount = isset($_REQUEST['claim_amount']) ? $_REQUEST['claim_amount'] : '-1'; $deal_number = isset($_REQUEST['deal_number']) ? $_REQUEST['deal_number'] : '-1'; $claim_number = isset($_REQUEST['claim_number']) ? $_REQUEST['claim_number'] : '-1'; $deal_date = isset($_REQUEST['deal_date']) ? $_REQUEST['deal_date'] : '-1'; $delivery_date = isset($_REQUEST['delivery_date']) ? $_REQUEST['delivery_date'] : '-1'; $warehouse = isset($_REQUEST['warehouse']) ? $_REQUEST['warehouse'] : '-1'; $stock_number = isset($_REQUEST['stock_number']) ? $_REQUEST['stock_number'] : '-1'; $age_of_unit = isset($_REQUEST['age_of_unit']) ? $_REQUEST['age_of_unit'] : '-1'; $body_size_code = isset($_REQUEST['body_size_code']) ? $_REQUEST['body_size_code'] : '-1'; $insurance_company = isset($_REQUEST['insurance_company']) ? $_REQUEST['insurance_company'] : '-1'; $insurance_type = isset($_REQUEST['insurance_type']) ? $_REQUEST['insurance_type'] : '-1'; $insurance_expiration_date = isset($_REQUEST['insurance_expiration_date']) ? $_REQUEST['insurance_expiration_date'] : '-1'; $financing_company = isset($_REQUEST['financing_company']) ? $_REQUEST['financing_company'] : '-1'; $finance_expiration_date = isset($_REQUEST['finance_expiration_date']) ? $_REQUEST['finance_expiration_date'] : '-1'; $sales_consultant = isset($_REQUEST['sales_consultant']) ? $_REQUEST['sales_consultant'] : '-1'; $group_manager = isset($_REQUEST['group_manager']) ? $_REQUEST['group_manager'] : '-1'; $dms_id = isset($_REQUEST['dms_id']) ? $_REQUEST['dms_id'] : '-1'; $company_id = isset($_REQUEST['company_id']) ? $_REQUEST['company_id'] : '-1'; $dealer_id = isset($_REQUEST['dealer_id']) ? $_REQUEST['dealer_id'] : '-1'; $brand_id = $brand->read_brand_id_by_name($brand_name, $db); if(!$utility->isNotEmpty($brand_id)){ $brand_id = $brand->create_brand($brand_name, $db); } $model_id = $model->read_model_id_by_name($model_name, $db); if(!$utility->isNotEmpty($model_id)){ $model_id = $model->create_model($model_name, $db); } $color_id = $color->read_color_id_by_name($color_name, $db); if(!$utility->isNotEmpty($color_id)){ $color_id = $color->create_color($color_name, $db); } $sales->create_sales($utility->generate_uuid($db), $plate_number, $conduction_sticker, $brand_id, $model_id, $color_id, $order_number, $po_number, $sales_date, $sales_cost, $sales_price, $floor_plan_amount, $claim_amount, $deal_number, $claim_number, $deal_date, $delivery_date, $warehouse, $stock_number, $age_of_unit, $body_size_code, $insurance_company, $insurance_type, $insurance_expiration_date, $financing_company, $finance_expiration_date, $sales_consultant, $group_manager, $dms_id, $company_id, $dealer_id, $db); } else if($apiKey === '1985222949852720' && $utility->isPostMethod($server_method)){ //Read Vehicle Sale Details $vehicle_id = isset($_REQUEST['vehicle_id']) ? $_REQUEST['vehicle_id'] : '-1'; $vehicle_sales_information = $sales->read_vehicle_sales_details($customer_id, $db); $vehicle_sales_information['mod-dd-insurance-company'] = $insurance_company->read_insurance_company_name_by_id($vehicle_sales_information['mod-dd-insurance-company'], $db); $vehicle_sales_information['mod-dd-insurance-type'] = $insurance_type->read_insurance_type_name_by_id($vehicle_sales_information['mod-dd-insurance-type'], $db); $vehicle_sales_information['mod-dd-finance-company'] = $finance_company->read_finance_company_name_by_id($vehicle_sales_information['mod-dd-finance-company'], $db); echo json_encode(array($vehicle_sales_information)); } else if($apiKey === '4045810733767125' && $utility->isPostMethod($server_method)){ //Read Vehicle Sale Details $vehicle_id = isset($_REQUEST['vehicle_id']) ? $_REQUEST['vehicle_id'] : '-1'; $vehicle_sales_information = $sales->read_vehicle_sales($vehicle_id, $db); if(count($vehicle_sales_information) > 0){ $vehicle_sales_information['mod-sales-date'] = $utility->convert_sql_date_to_date_picker($vehicle_sales_information['mod-sales-date']); $vehicle_sales_information['mod-insurance-exp-date'] = $utility->convert_sql_date_to_date_picker($vehicle_sales_information['mod-insurance-exp-date']); $vehicle_sales_information['mod-finance-exp-date'] = $utility->convert_sql_date_to_date_picker($vehicle_sales_information['mod-finance-exp-date']); $vehicle_sales_information['mod-delivery-date'] = $utility->convert_sql_date_to_date_picker($vehicle_sales_information['mod-delivery-date']); echo json_encode(array($vehicle_sales_information)); }else{ echo json_encode(array()); } // $vehicle_sales_information['mod-dd-insurance-company'] = $insurance_company->read_insurance_company_name_by_id($vehicle_sales_information['mod-dd-insurance-company'], $db); // $vehicle_sales_information['mod-dd-insurance-type'] = $insurance_type->read_insurance_type_name_by_id($vehicle_sales_information['mod-dd-insurance-type'], $db); // $vehicle_sales_information['mod-dd-finance-company'] = $finance_company->read_finance_company_name_by_id($vehicle_sales_information['mod-dd-finance-company'], $db); } else if($apiKey === '9718832291017422' && $utility->isPostMethod($server_method)){ //Read Vehicle Sale Details $vehicle_id = isset($_REQUEST['vehicle_id']) ? $_REQUEST['vehicle_id'] : '-1'; $vehicle_sales_information = $sales->read_vehicle_sales_main($vehicle_id, $db); if(count($vehicle_sales_information) > 0){ $vehicle_sales_information['information-sale-date'] = $utility->convert_sql_date_to_date_picker($vehicle_sales_information['information-sale-date']); $vehicle_sales_information['information-sale-insurance-expiration'] = $utility->convert_sql_date_to_date_picker($vehicle_sales_information['information-sale-insurance-expiration']); $vehicle_sales_information['information-sale-finance-expiration'] = $utility->convert_sql_date_to_date_picker($vehicle_sales_information['information-sale-finance-expiration']); $vehicle_sales_information['information-sale-delivery-date'] = $utility->convert_sql_date_to_date_picker($vehicle_sales_information['information-sale-delivery-date']); // $vehicle_sales_information['mod-dd-insurance-company'] = $insurance_company->read_insurance_company_name_by_id($vehicle_sales_information['mod-dd-insurance-company'], $db); // $vehicle_sales_information['mod-dd-insurance-type'] = $insurance_type->read_insurance_type_name_by_id($vehicle_sales_information['mod-dd-insurance-type'], $db); // $vehicle_sales_information['mod-dd-finance-company'] = $finance_company->read_finance_company_name_by_id($vehicle_sales_information['mod-dd-finance-company'], $db); echo json_encode(array($vehicle_sales_information)); }else{ echo '[]'; } } else if($apiKey === '5339702066391571' && $utility->isPostMethod($server_method)){ //Read Brands Offered $vehicle_id = isset($_REQUEST['vehicle_id']) ? $_REQUEST['vehicle_id'] : '-1' ; $sales_id = $sales->get_sales_id_by_vehicle_id($vehicle_id,$db); $sales->read_sales_brands_offered($sales_id, $db); } else if($apiKey === '0566944804071901' && $utility->isPostMethod($server_method)){ //Check Vehicle $conduction_sticker = $_REQUEST['sales_cs_number']; $sales->check_vehicle($conduction_sticker, $db); } else if($apiKey === '7652381353555841' && $utility->isPostMethod($server_method)){ //Read Sales Details $sales_id = isset($_REQUEST['sales_id']) ? $_REQUEST['sales_id'] : '-1' ; $sales->read_sales_details($sales_id, $db); } else if($apiKey === '1468546553238321' && $utility->isPostMethod($server_method)){ //Read Sales Insurance $sales_id = isset($_REQUEST['sales_id']) ? $_REQUEST['sales_id'] : '-1' ; $sales->read_sales_insurance($sales_id, $db); } else if($apiKey === '7367406445221787' && $utility->isPostMethod($server_method)){ //Read Sales DMS $vehicle_id = isset($_REQUEST['vehicle_id']) ? $_REQUEST['vehicle_id'] : '-1' ; $sales_id = $sales->get_sales_id_by_vehicle_id($vehicle_id,$db); $sales->read_sales_dms($sales_id, $db); } else if($apiKey === '2635594972100656'){ //Update } else if($apiKey === '8969188301030014'){ //Delete }else if($apiKey === '1459051109379886' && $utility->isPostMethod($server_method)){ //Read Customer Interest $start_date = isset($_REQUEST['startDate']) ? $db->escape($_REQUEST['startDate']) : '' ; $end_date = isset($_REQUEST['endDate']) ? $db->escape($_REQUEST['endDate']) : '' ; $company = isset($_REQUEST['company']) ? $db->escape($_REQUEST['company']) : '0' ; $return_arr["total"]= $sales->read_sales_total_number($start_date,$end_date,$company,$granted_company_ids,$db); echo json_encode($return_arr); }else if($apiKey === '3892635489643867' ){ //Read Customer Interest $search = isset($_REQUEST['search']) ? $_REQUEST['search'] : '' ; $offset = isset($_REQUEST['offset']) ? $_REQUEST['offset'] : '' ; $limit = isset($_REQUEST['limit']) ? $_REQUEST['limit'] : '' ; $url = 'https://www.autohub.ph/connect/LOAD_SALES_PERSON.php'; $params = array('apiKey' => $apiKey, 'search' => $search, 'offset' => $offset, 'limit' => $limit); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL,$url); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS,http_build_query($params)); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); $server_output = curl_exec($ch); curl_close ($ch); echo $server_output; } 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; } ?>PK''�ZNMsales_about_side.phpnu�[��PK''�Z��d�q�q]modal/add_sales.phpnu�[��PK''�ZS�C,nnq�sales_information.phpnu�[��PK�;�Z�9!F�� $�sales.phpnu�[��PK�;�Z 4�6�� error_lognu�[��PK�;�ZU��tntnԹsalesv2.phpnu�[��PK��(