File manager

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

Back
<?php class Sales { function create_sales($sales_id, $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, $dms_id, $company_id, $dealer_id, $db){ $query = " SELECT id FROM source_company_dealer WHERE company_id='$company_id' AND dealer_id='$dealer_id' AND type='1'"; $comp_deal_id = $db -> return_result($query); //echo $query; return; foreach($comp_deal_id AS $cdi){ $compdeal_id = $cdi['id']; } $create_sales_query = " INSERT INTO `sales`(`id`, `plate_number`, `conduction_sticker`, `brand_id`, `model_id`, `order_number`, `po_number`, `activity_date`, `sales_cost`, `sale_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_id`, `insurance_type_id`, `insurance_expiration_date`, `finance_company_id`, `sales_person`, `finance_expiration_date`, `dms_id`, `company_dealer_id`) VALUES ('$sales_id', NULLIF('$plate_number',''), NULLIF('$conduction_sticker',''), '$brand_id', '$model_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', '$sales_consultant', '$finance_expiration_date', '$dms_id','$compdeal_id')"; $rows_affected = $db->sql_query_num_inserted($create_sales_query); //echo $create_sales_query; return; if($rows_affected > 0){ $return_arr['message'] = 'Inserted'; $return_arr['status'] = 1; } else { $return_arr['message'] = 'Not Inserted'; $return_arr['status'] = 0; } echo json_encode($return_arr); } function create_sales_brands_offered($data_to_insert, $db){ $query = "INSERT INTO `sales_brands_offered`(`sales_id`, `brand_id`, `model_id`, `description`) VALUES ".$data_to_insert.""; $rows_affected = $db->sql_query_num_inserted($query); return $rows_affected; //"('$vehicle_id','".$brands_offered_id."', '$offered['Model']', '$offered['Description']', '1')"; } // function create_vehicle_sales($sales_id, $customer_number, $end_user, $brand_id, $model_id, $plate_number, $conduction_sticker, $mode_of_sale_id, $insurance_company_id, $insurance_type_id, // $insurance_expiration_date, $finance_company_id, $finance_expiration_date, $driver, $delivery_date, $group_manager_id, $sales_consultant_id, $source_of_sale_id, $type_of_payment_id, // $dms_id, $company_id, $dealer_id, $db){ // $query = " // SELECT id // FROM source_company_dealer // WHERE company_id='$company_id' AND dealer_id='$dealer_id' AND type='1'"; // $comp_deal_id = $db -> return_result($query); //echo $query; return; // $compdeal_id = ""; // foreach($comp_deal_id AS $cdi){ // $compdeal_id = $cdi['id']; // } // $customer_id = $customer_number . $dms_id . $compdeal_id; // //create sales // $create_vehicle_sales_query = " // INSERT INTO `sales` (`id`, `customer_id`, `end_user`, `brand_id`, `model_id`, `plate_number`, `conduction_sticker`, `mode_of_sale_id`, `insurance_company_id`, `insurance_type_id`, // `insurance_expiration_date`, `finance_company_id`, `finance_expiration_date`, `driver`, `delivery_date`, `group_manager_id`, `sales_person`, `source_id`, `type_of_payment_id`, // `dms_id`, `company_dealer_id`) // VALUES ('$sales_id', '$customer_id', '$end_user', '$brand_id', '$model_id', '$conduction_sticker', '$plate_number', '$mode_of_sale_id', '$insurance_company_id', // '$insurance_type_id', '$insurance_expiration_date', '$finance_company_id', '$finance_expiration_date', '$driver', '$delivery_date', 'group_manager_id', '$sales_consultant_id', '$source_of_sale_id', // '$type_of_payment_id', '$dms_id', '$compdeal_id')"; // $rows_affected_sales = $db->sql_query_num_inserted($create_vehicle_sales_query); //echo $create_vehicle_sales_query; // return $rows_affected_sales; // } function create_vehicle_sales($id,$customer_id,$vehicle_id,$conduction_sticker,$plate_number,$order_number,$floor_plan_amount,$activity_date,$sales_cost,$sale_price,$sale_discount,$insurance_company_id,$insurance_type_id,$insurance_expiration_date,$finance_company_id,$finance_expiration_date,$source_id,$mode_of_contact_id,$warehouse,$stock_number,$age_of_unit,$body_size_code,$claim_number,$claim_amount,$deal_number,$deal_date,$sales_person,$driver,$delivery_date,$type_of_payment_id,$group_manager_id,$company_dealer_id,$purchase_car_as_id,$upload_by,$status,$end_user,$mode_of_sale_id,$asa_sales_manager,$asa_sales_consultant,$db){ $query = "INSERT INTO `sales`(`id`, `customer_id`, `vehicle_id`, `conduction_sticker`, `plate_number`, `order_number`, `floor_plan_amount`, `activity_date`, `sales_cost`, `sale_price`, `sale_discount`, `insurance_company_id`, `insurance_type_id`, `insurance_expiration_date`, `finance_company_id`, `finance_expiration_date`, `source_id`, `mode_of_contact_id`, `warehouse`, `stock_number`, `age_of_unit`, `body_size_code`, `claim_number`, `claim_amount`, `deal_number`, `deal_date`, `sales_person`, `driver`, `delivery_date`, `type_of_payment_id`, `group_manager_id`, `company_dealer_id`, `purchase_car_as_id`, `upload_by`, `date_uploaded`, `status`, `end_user`, `mode_of_sale_id`,`asa_group_manager_id`,`asa_sales_person`) VALUES ('$id','$customer_id',NULLIF('$vehicle_id',''),NULLIF('$conduction_sticker',''),NULLIF('$plate_number',''),NULLIF('$order_number', ''),'$floor_plan_amount','$activity_date','$sales_cost','$sale_price','$sale_discount','$insurance_company_id','$insurance_type_id','$insurance_expiration_date','$finance_company_id','$finance_expiration_date','$source_id','$mode_of_contact_id','$warehouse','$stock_number','$age_of_unit','$body_size_code','$claim_number','$claim_amount','$deal_number','$deal_date','$sales_person','$driver','$delivery_date','$type_of_payment_id','$group_manager_id','$company_dealer_id','$purchase_car_as_id','$upload_by',NOW(),'$status','$end_user','$mode_of_sale_id','$asa_sales_manager','$asa_sales_consultant')"; // echo $query;exit; return $db->sql_query_num_inserted($query); } // $query = "INSERT INTO `sales`(`id`, `customer_id`, `vehicle_id`, `conduction_sticker`, `plate_number`, `order_number`, `floor_plan_amount`, `activity_date`, `sales_cost`, `sale_price`, `sale_discount`, `insurance_company_id`, `insurance_type_id`, `insurance_expiration_date`, `finance_company_id`, `finance_expiration_date`, `source_id`, `mode_of_contact_id`, `warehouse`, `stock_number`, `age_of_unit`, `body_size_code`, `claim_number`, `claim_amount`, `deal_number`, `deal_date`, `sales_person`, `driver`, `delivery_date`, `type_of_payment_id`, `group_manager_id`, `company_dealer_id`, `purchase_car_as_id`, `upload_by`, `date_uploaded`, `status`, `end_user`, `mode_of_sale_id`,`asa_group_manager_id`,`asa_sales_person`) // VALUES ('$id','$customer_id',NULLIF('$vehicle_id',''),NULLIF('$conduction_sticker',''),NULLIF('$plate_number',''),NULLIF('$order_number', ''),'$floor_plan_amount','$activity_date','$sales_cost','$sale_price','$sale_discount', // IF('$insurance_company_id' = '','0','$insurance_company_id'), // IF('$insurance_type_id' = '','0','$insurance_type_id'), // '$insurance_expiration_date', // IF('$finance_company_id' = '','0','$finance_company_id'), // '$finance_expiration_date','$source_id', // IF('$mode_of_contact_id' = '','0','$mode_of_contact_id'), // '$warehouse','$stock_number','$age_of_unit','$body_size_code','$claim_number','$claim_amount','$deal_number','$deal_date','$sales_person','$driver','$delivery_date', // IF('$type_of_payment_id' = '','0','$type_of_payment_id'), // IF('$group_manager_id' = '','0','$group_manager_id'), // '$company_dealer_id', // IF('$purchase_car_as_id' = '','0','$purchase_car_as_id'), // '$upload_by',NOW(),'$status','$end_user', // IF('$mode_of_sale_id' = '','0','$mode_of_sale_id'), // IF('$asa_sales_manager' = '','0','$asa_sales_manager'), // IF('$asa_sales_consultant' = '','0','$asa_sales_consultant'))"; // // echo $query;exit; // return $db->sql_query_num_inserted($query); // } function update_vehicle_sales($id,$customer_id,$vehicle_id,$conduction_sticker,$plate_number,$order_number,$floor_plan_amount,$activity_date,$sales_cost,$sale_price,$sale_discount,$insurance_company_id,$insurance_type_id,$insurance_expiration_date,$finance_company_id,$finance_expiration_date,$source_id,$mode_of_contact_id,$warehouse,$stock_number,$age_of_unit,$body_size_code,$claim_number,$claim_amount,$deal_number,$deal_date,$sales_person,$driver,$delivery_date,$type_of_payment_id,$group_manager_id,$company_dealer_id,$purchase_car_as_id,$modified_by,$status,$end_user,$mode_of_sale_id,$asa_sales_manager,$asa_sales_consultant,$db){ $query = "UPDATE `sales` SET `customer_id`= '$customer_id', `vehicle_id`= NULLIF('$vehicle_id','') , `conduction_sticker`= NULLIF('$conduction_sticker', ''), `plate_number`= NULLIF('$plate_number', ''), `order_number`=NULLIF('$order_number', '') , `floor_plan_amount`= '$floor_plan_amount', `activity_date`='$activity_date' , `sales_cost`= '$sales_cost', `sale_price`= '$sale_price', `sale_discount`= '$sale_discount', `insurance_company_id`= '$insurance_company_id', `insurance_type_id`='$insurance_type_id' , `insurance_expiration_date`= '$insurance_expiration_date', `finance_company_id`= '$finance_company_id', `finance_expiration_date`= '$finance_expiration_date', `source_id`='$source_id' , `mode_of_contact_id`='$mode_of_contact_id' , `warehouse`='$warehouse' , `stock_number`= '$stock_number', `age_of_unit`='$age_of_unit' , `body_size_code`= '$body_size_code', `claim_number`='$claim_number' , `claim_amount`= '$claim_amount', `deal_number`='$deal_number' , `deal_date`= '$deal_date', `sales_person`= '$sales_person', `driver`='$driver' , `delivery_date`= '$delivery_date', `type_of_payment_id`= '$type_of_payment_id', `group_manager_id`= '$group_manager_id', `company_dealer_id`='$company_dealer_id' , `purchase_car_as_id`='$purchase_car_as_id' , `modified_by`= '$modified_by', `date_modified`=NOW() , `status`='$status' , `end_user`='$end_user' , `mode_of_sale_id` = '$mode_of_sale_id', `asa_group_manager_id` = '$asa_sales_manager', `asa_sales_person` = '$asa_sales_consultant' WHERE id = '$id' "; // echo $query; return $db->sql_query_num_inserted($query); } function read_sales_brands_offered($sales_id, $db){ $query = "SELECT sbo.id,sbo.`brand_id`, sb.name as brand_name,sbo.`model_id`, scm.name as model_name,sbo.description FROM `sales_brands_offered` sbo INNER JOIN source_brand sb ON sbo.`brand_id` = sb.id INNER JOIN source_car_model scm ON sbo.`model_id` = scm.id WHERE sbo.sales_id = '$sales_id' "; $sales_brands_offered = $db -> return_result($query); //echo $query_read_brands_offered; return; $json = []; foreach($sales_brands_offered AS $details){ $json[] = [ 'sales_id'=>$details['id'], 'brand_id'=>$details['brand_id'], 'brand_name'=>$details['brand_name'], 'model_id'=>$details['model_id'], 'model_name'=>$details['model_name'], 'description'=>$details['description'] ]; } echo json_encode($json); } function read_sales_dms($sales_id, $db){ //deprecated $query_read_vehicle_dms = " SELECT sdms.id AS dms_id, sc.id AS company_id, sd.id AS dealer_id ,sc.name as company_name,sd.name as dealer_name,sc.code as company_code,sd.code as dealer_code FROM `sales` s 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_dms sdms ON sc.dms_id = sdms.id INNER JOIN source_dealer sd ON sd.id = scd.dealer_id WHERE s.id = '$sales_id'"; $vehicle_dmss = $db -> return_result($query_read_vehicle_dms); //echo $query_read_vehicle_dms; return; $json = []; foreach($vehicle_dmss AS $vdms){ $json[] = ['dms_id'=>$vdms['dms_id'], 'company_id'=>$vdms['company_id'], 'company_name'=>$vdms['company_name'], 'company_code'=>$vdms['company_code'], 'dealer_id'=>$vdms['dealer_id'], 'dealer_name'=>$vdms['dealer_name'], 'dealer_code'=>$vdms['dealer_code']]; // $json[] = ['vehicle_id'=>$vdms['id'],'dms_id'=>$vdms['dms_id'],'dms_name'=>$vdms['dms_name'], 'company_code'=>$vdms['company_code'], 'company_name'=>$vdms['company_name'], // 'dealer_code'=>$vdms['dealer_code'], 'dealer_name'=>$vdms['dealer_name']]; } echo json_encode($json); } function read_vehicle_sales_details($customer_id, $db){ $query_read_vehicle_sales_details = " SELECT s.mode_of_sale_id, s.insurance_company_id, s.insurance_type_id, s.finance_company_id, s.insurance_expiration_date, s.finance_expiration_date, s.delivery_date, s.driver, s.source_id, s.type_of_payment_id, s.end_user FROM sales s WHERE s.customer_id = '$customer_id'"; $vehicle_sales_details = $db -> return_result($query_read_vehicle_sales_details); //echo $query_read_vehicle_sales_details; return; $json = array(); foreach($vehicle_sales_details AS $details){ $json = [ 'mod-dd-mode-of-sale'=>$details['mode_of_sale_id'], 'mod-dd-insurance-company'=>$details['insurance_company_id'], 'mod-dd-insurance-type'=>$details['insurance_type_id'], 'mod-dd-finance-company'=>$details['finance_company_id'], 'mod-insurance-exp-date'=>$details['insurance_expiration_date'], 'mod-finance-exp-date'=>$details['finance_expiration_date'], 'mod-delivery-date'=>$details['delivery_date'], 'mod-driver'=>$details['driver'], 'mod-dd-source-of-sale'=>$details['source_id'], 'mod-dd-type-of-payment'=>$details['type_of_payment_id'], 'mod-end-user'=>$details['end_user'] ]; } return $json; } function read_vehicle_sales($vehicle_id, $db){ $query = "SELECT s.`customer_id`,s.`order_number`,s.mode_of_sale_id,s.type_of_payment_id,s.group_manager_id,CONCAT(sc.first_name,' ',sc.last_name) as group_manager_name, s.`sales_person`,CONCAT(scs.first_name,' ',scs.last_name) as sales_person_name,s.`source_id`,s.`sales_cost`,s.`sale_price`,s.`sale_discount`,s.`activity_date`,s.`end_user`,s.`driver`,s.`delivery_date`,s.`insurance_company_id`,sic.name as insurance_company_name,s.insurance_type_id,s.insurance_expiration_date,s.`finance_company_id`, sfc.name as finance_company_name,s.finance_expiration_date,s.asa_group_manager_id,s.asa_sales_person FROM `sales` s LEFT OUTER JOIN sales_consultant sc ON s.group_manager_id = sc.id LEFT OUTER JOIN sales_consultant scs ON s.`sales_person` = scs.id INNER JOIN source_insurance_company sic ON s.`insurance_company_id` = sic.id INNER JOIN source_finance_company sfc ON s.`finance_company_id` = sfc.id WHERE s.`vehicle_id` = '$vehicle_id' "; $vehicle = $db -> return_result($query); $json = array(); foreach($vehicle as $vehicle_data){ $json = [ 'mod-customer-number'=> explode("_", $vehicle_data['customer_id'])[0], 'mod-order-number'=>$vehicle_data['order_number'], 'mod-dd-mode-of-sale'=>$vehicle_data['mode_of_sale_id'], 'mod-dd-type-of-payment'=>$vehicle_data['type_of_payment_id'], 'mod-dd-group-manager'=>$vehicle_data['group_manager_id'], 'mod-dd-group-manager-name'=>$vehicle_data['group_manager_name'], 'mod-dd-sales-consultant'=>$vehicle_data['sales_person'], 'mod-dd-sales-consultant-name'=>$vehicle_data['sales_person_name'], 'mod-dd-source-of-sale'=>$vehicle_data['source_id'], 'mod-sales-cost'=>$vehicle_data['sales_cost'], 'mod-sales-price'=>$vehicle_data['sale_price'], 'mod-sales-discount'=>$vehicle_data['sale_discount'], 'mod-sales-date'=>$vehicle_data['activity_date'], 'mod-end-user'=>$vehicle_data['end_user'], 'mod-driver'=>$vehicle_data['driver'], 'mod-delivery-date'=>$vehicle_data['delivery_date'], 'mod-dd-insurance-company'=>$vehicle_data['insurance_company_id'], 'mod-dd-insurance-company-name'=>$vehicle_data['insurance_company_name'], 'mod-dd-insurance-type'=>$vehicle_data['insurance_type_id'], 'mod-insurance-exp-date'=>$vehicle_data['insurance_expiration_date'], 'mod-dd-finance-company'=>$vehicle_data['finance_company_id'], 'mod-dd-finance-company-name'=>$vehicle_data['finance_company_name'], 'mod-finance-exp-date'=>$vehicle_data['finance_expiration_date'], 'mod-dd-sales-consultant-asa'=>$vehicle_data['asa_sales_person'], 'mod-dd-group-manager-asa'=>$vehicle_data['asa_group_manager_id'] ]; } // echo json_encode($json); return $json; } function read_vehicle_sales_main($vehicle_id, $db){ $query = "SELECT s.`customer_id`,s.`order_number`,s.mode_of_sale_id,smos.name as mode_of_sale_name,s.type_of_payment_id,s.group_manager_id,CONCAT(sc.first_name,' ',sc.last_name) as group_manager_name, s.`sales_person`,CONCAT(scs.first_name,' ',scs.last_name) as sales_person_name,s.`source_id`,s.`sales_cost`,s.`sale_price`,s.`sale_discount`,s.`activity_date`,s.`end_user`,s.`driver`,s.`delivery_date`,s.`insurance_company_id`,sic.name as insurance_company_name,s.insurance_type_id,s.insurance_expiration_date,s.`finance_company_id`, sfc.name as finance_company_name,s.finance_expiration_date, soi.name as source_name,sot.name as insurance_type_name,stp.name as type_of_payment_name, DATE_FORMAT(s.date_uploaded, '%M %d, %Y - %h:%i:%s %p') AS date_uploaded, e.first_name, e.last_name, sdms.name as dms_name, scy.code as company_code,sdr.code as dealer_code, sb.name as brand_name, scm.name as model_name,scmv.name as model_variant, v.conduction_sticker FROM `sales` s INNER JOIN vehicle v ON s.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 LEFT OUTER JOIN source_car_model_variant scmv ON v.model_variant_description = scmv.id INNER JOIN source_company_dealer scd ON v.company_dealer_id = scd.id INNER JOIN source_company scy ON scd.company_id = scy.id INNER JOIN source_dealer sdr ON scd.dealer_id = sdr.id INNER JOIN source_dms sdms ON scy.dms_id = sdms.id LEFT OUTER JOIN sales_consultant sc ON s.group_manager_id = sc.id LEFT OUTER JOIN sales_consultant scs ON s.`sales_person` = scs.id LEFT OUTER JOIN source_insurance_company sic ON s.`insurance_company_id` = sic.id LEFT OUTER JOIN source_finance_company sfc ON s.`finance_company_id` = sfc.id INNER JOIN source_of_inquiry soi ON s.source_id = soi.id INNER JOIN source_insurance_type sot ON s.`insurance_type_id` = sot.id INNER JOIN source_type_of_payment stp ON s.type_of_payment_id = stp.id INNER JOIN source_mode_of_sale smos ON s.mode_of_sale_id = smos.id INNER JOIN employee e ON s.upload_by = e.id WHERE s.`vehicle_id` = '$vehicle_id' LIMIT 1"; // echo $query;exit; $vehicle = $db -> return_result($query); $json = array(); foreach($vehicle as $vehicle_data){ $json = [ 'information-sale-order-no'=> $vehicle_data['order_number'],//explode("_", $vehicle_data['customer_id'])[0], 'information-sale-date'=>$vehicle_data['activity_date'], 'information-sale-mode'=>$vehicle_data['mode_of_sale_name'], 'information-sale-type-of-payment'=>$vehicle_data['type_of_payment_name'], 'information-sale-gm'=>$vehicle_data['group_manager_name'], 'information-sale-sc'=>$vehicle_data['sales_person_name'], 'information-sale-source'=>$vehicle_data['source_name'], 'information-sale-cost'=>$vehicle_data['sales_cost'], 'information-sale-price'=>$vehicle_data['sale_price'], 'information-sale-discount'=>$vehicle_data['sale_discount'], 'information-sale-driver'=>$vehicle_data['driver'], 'information-sale-delivery-date'=>$vehicle_data['delivery_date'], 'information-sale-insurance-company'=>$vehicle_data['insurance_company_name'], 'information-sale-insurance-type'=>$vehicle_data['insurance_type_name'], 'information-sale-insurance-expiration'=>$vehicle_data['insurance_expiration_date'], 'information-sale-finance-company'=>$vehicle_data['finance_company_name'], 'information-sale-finance-expiration'=>$vehicle_data['finance_expiration_date'], 'information-sale-end-user'=>$vehicle_data['end_user'], 'information-sale-brand'=>$vehicle_data['brand_name'], 'information-sale-model'=>$vehicle_data['model_name'], 'information-sale-model-variant'=>$vehicle_data['model_variant'], 'information-conduction-sticker'=>$vehicle_data['conduction_sticker'], 'sales-date-uploaded'=>$vehicle_data['date_uploaded'], 'sales-dealer'=>$vehicle_data['dealer_code'], 'sales-company'=>$vehicle_data['company_code'], 'sales-dms'=>$vehicle_data['dms_name'], // 'sales_profileDisplay'=>"dist/img/customer/".$vehicle_data['photo_name'], 'sales-uploaded-by'=>$vehicle_data['first_name']. ' '.$vehicle_data['last_name'] ]; } // echo json_encode($json); return $json; } function read_sales_details($sales_id, $db){ $query_read_sales_details = " SELECT s.order_number, s.po_number, DATE_FORMAT(s.activity_date, '%m/%d/%Y') AS activity_date, s.sales_cost, s.sale_price, s.floor_plan_amount, s.claim_number, s.claim_amount, s.deal_number, DATE_FORMAT(s.deal_date, '%m/%d/%Y') AS deal_date, DATE_FORMAT(s.delivery_date, '%m/%d/%Y') AS delivery_date, s.warehouse, s.stock_number, s.age_of_unit, s.body_size_code FROM sales s WHERE s.id = '$sales_id'"; $sales_details = $db -> return_result($query_read_sales_details); //echo $query_read_sales_details; return; $json = []; foreach($sales_details AS $details){ $json[] = ['order_number'=>$details['order_number'], 'po_number'=>$details['po_number'], 'activity_date'=>$details['activity_date'], 'sales_cost'=>$details['sales_cost'], 'sales_price'=>$details['sale_price'], 'floor_plan_amount'=>$details['floor_plan_amount'], 'claim_number'=>$details['claim_number'], 'claim_amount'=>$details['claim_amount'], 'deal_number'=>$details['deal_number'], 'deal_date'=>$details['deal_date'], 'delivery_date'=>$details['delivery_date'], 'warehouse'=>$details['warehouse'], 'stock_number'=>$details['stock_number'], 'age_of_unit'=>$details['age_of_unit'], 'body_size_code'=>$details['body_size_code']]; } echo json_encode($json); } function read_sales_insurance($sales_id, $db){ $query_read_sales_insurance = " SELECT s.insurance_company_id, s.insurance_type_id, DATE_FORMAT(s.insurance_expiration_date, '%m/%d/%Y') AS insurance_expiration_date, s.finance_company_id, DATE_FORMAT(s.finance_expiration_date, '%m/%d/%Y') AS finance_expiration_date FROM sales s WHERE s.id = '$sales_id'"; $sales_insurance = $db -> return_result($query_read_sales_insurance); //echo $query_read_sales_insurance; return; $json = []; foreach($sales_insurance AS $details){ $json[] = ['insurance_company_id'=>$details['insurance_company_id'], 'insurance_type_id'=>$details['insurance_type_id'], 'insurance_expiration_date'=>$details['insurance_expiration_date'], 'finance_company_id'=>$details['finance_company_id'], 'finance_expiration_date'=>$details['finance_expiration_date']]; } echo json_encode($json); } // function check_vehicle($conduction_sticker, $db){ // $query_check_vehicle = " // SELECT s.order_number, s.po_number, DATE_FORMAT(s.activity_date, '%m/%d/%Y') AS activity_date, s.sales_cost, s.sale_price, s.floor_plan_amount, s.claim_number, s.claim_amount, s.deal_number, // DATE_FORMAT(s.deal_date, '%m/%d/%Y') AS deal_date, DATE_FORMAT(s.delivery_date, '%m/%d/%Y') AS delivery_date, s.warehouse, s.stock_number, s.age_of_unit, s.body_size_code // FROM sales s // WHERE s.id = '$sales_id'"; // $sales_details = $db -> return_result($query_read_sales_details); //echo $query_read_sales_details; return; // $json = []; // foreach($sales_details AS $details){ // $json[] = ['order_number'=>$details['order_number'], 'po_number'=>$details['po_number'], 'activity_date'=>$details['activity_date'], 'sales_cost'=>$details['sales_cost'], // 'sales_price'=>$details['sale_price'], 'floor_plan_amount'=>$details['floor_plan_amount'], 'claim_number'=>$details['claim_number'], 'claim_amount'=>$details['claim_amount'], // 'deal_number'=>$details['deal_number'], 'deal_date'=>$details['deal_date'], 'delivery_date'=>$details['delivery_date'], 'warehouse'=>$details['warehouse'], // 'stock_number'=>$details['stock_number'], 'age_of_unit'=>$details['age_of_unit'], 'body_size_code'=>$details['body_size_code']]; // } // echo json_encode($json); // } // function read_vehicle_dms($vehicle_id, $db){ // $query_read_vehicle_dms = " // SELECT sdms.id, sdms.name // FROM `vehicle` v // INNER JOIN source_dms sdms ON v.`dms_id` = sdms.id // WHERE v.id = '$vehicle_id'"; // $vehicle_dmss = $db -> return_result($query_read_vehicle_dms); //echo $query_read_vehicle_dms; return; // $json = []; // foreach($vehicle_dmss AS $vdms){ // $json[] = ['vehicle_id'=>$vdms['id'],'dms_id'=>$vdms['id'],'dms_name'=>$vdms['name']]; // } // echo json_encode($json); // } function read_sales_by_conduction_sticker($conduction_sticker,$db){ $query = "SELECT 1 FROM `sales` WHERE `conduction_sticker` = '$conduction_sticker' "; return $db -> select($query); } function read_sales_by_plate_number($plate_number,$db){ $query = "SELECT 1 FROM `sales` WHERE `plate_number` = '$plate_number' "; return $db -> select($query); } function read_conduction_sticker_by_sales_id($sales_id,$db){ return $db->select("SELECT `conduction_sticker` FROM `sales` WHERE `id` = '$sales_id' "); } function read_plate_number_by_sales_id($sales_id,$db){ return $db->select("SELECT `plate_number` FROM `sales` WHERE `id` = '$sales_id' "); } function get_sales_id_by_vehicle_id($vehicle_id,$db){ return $db->select("SELECT id FROM sales WHERE vehicle_id = '$vehicle_id' LIMIT 1"); } function delete_sales_offered($sales_id,$db){ return $db->sql_query_num_inserted("DELETE FROM `sales_brands_offered` WHERE sales_id='$sales_id' "); } function read_sales_total_number($start_date,$end_date,$company,$granted_company_ids,$db){ $company_filter = (intval($company) === 0) ? $granted_company_ids : $company ; $date_filter = ($start_date !== '' && $end_date !== '') ? " AND s.date_uploaded BETWEEN DATE_FORMAT('$start_date', '%Y-%m-%d 00:00:00') AND DATE_FORMAT('$end_date', '%Y-%m-%d 23:59:00') " : '' ; return $db -> select("SELECT SUM((SELECT count(1) FROM (SELECT sc.dms_id FROM sales s INNER JOIN vehicle v ON s.vehicle_id = v.id INNER JOIN source_company_dealer scd ON s.company_dealer_id = scd.id INNER JOIN source_company sc ON scd.company_id = sc.id INNER JOIN source_dms sd ON sc.dms_id = sd.id WHERE s.status = 1 AND v.status = 1 AND scd.company_id IN (".$company_filter.") $date_filter GROUP BY s.id ) as t2 WHERE t2.dms_id = source_dms.id ) ) as total_count FROM `source_dms` WHERE status = 1 "); } function read_mode_of_sale_id_by_name($name, $db){ return $db -> select("SELECT id FROM `source_mode_of_sale` WHERE 1 AND `name` = '$name' "); } function create_mode_of_sale($name, $db){ return $db -> sql_query_id("INSERT INTO source_mode_of_sale (`name`, `status`) VALUES ('$name', '0')"); } function read_type_of_payment_id_by_name($name, $db){ return $db -> select("SELECT id FROM `source_type_of_payment` WHERE 1 AND `name` = '$name' "); } function create_type_of_payment($name, $db){ return $db -> sql_query_id("INSERT INTO source_type_of_payment (`name`, `status`) VALUES ('$name', '0')"); } function read_source_of_sale_id_by_name($name, $db){ return $db -> select("SELECT id FROM `source_of_inquiry` WHERE 1 AND `name` = '$name' "); } function create_source_of_sale($name, $db){ return $db -> sql_query_id("INSERT INTO source_of_inquiry (`name`, `status`) VALUES ('$name', '0')"); } function read_sales_consultant_id_by_name($name, $db){ return $db -> select("SELECT id FROM `sales_consultant` WHERE 1 AND `first_name` = '$name' "); } function create_sales_consultant($name, $db){ return $db -> sql_query_id("INSERT INTO sales_consultant (`first_name`, `status`) VALUES ('$name', '0')"); } } ?>

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