<?php
    include_once("../../cfg/db.php");
    include_once("../controllers/sales.php");
    include_once("../controllers/utility.php");
    include_once("../controllers/brand.php");
    include_once("../controllers/model.php");
    include_once("../controllers/color.php");
    include_once("../controllers/vehicle.php");
    include_once("../controllers/insurance.php");
    include_once("../controllers/insurance_type.php");
    include_once("../controllers/finance.php");
    include_once("../controllers/group_manager.php");
    include_once("../controllers/sales_consultant.php");
    include_once("../controllers/sales.php");
    include_once("../compliance/required_fields.php");
    
    $sales = new Sales();
    $utility = new Utility();
    $brand = new Brand();
    $model = new Model();
    $color = new Color();
    $vehicle = new vehicle(); 
    $insurance_company = new Insurance();
    $insurance_type = new InsuranceType();
    $finance_company = new Finance();
    $group_manager = new GroupManager();
    $sales_consultant = new SalesConsultant();
    $required_fields = new RequiredFields();
    $sales = new Sales();
 
if(!isset($_SESSION['user']['id'])){
	echo "Session Expired.";
    exit;
}

    $server_method = $_SERVER["REQUEST_METHOD"];
 $granted_company_ids = $utility->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;
}

?>