<?php

namespace App\Models;

use App\Core\Database;
use App\Core\Model;

class Vehicle extends Model
{

    public function getVehicleDataByCS($cs)
    {
        $query = "SELECT v.*,
        sc.name as company,
         sd.name as dealer,
         sb.name as brand,
         scm.name as model,
         scmv.name as model_variant ,
        cc.mobile_phone_1,
        cc.email_1,
        sd.id as dealer_id
         FROM vehicle v 
        LEFT OUTER JOIN source_company_dealer scd
        ON v.company_dealer_id = scd.id
        LEFT OUTER JOIN source_company sc
        ON scd.company_id = sc.id
        LEFT OUTER JOIN source_dealer sd
        ON scd.dealer_id = sd.id
        LEFT OUTER JOIN source_brand sb
        ON v.brand_id = sb.id
        LEFT OUTER 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
        LEFT OUTER JOIN customer c
        ON v.customer_record_id = c.id
        LEFT OUTER JOIN customer_contact cc
        ON c.id = cc.customer_id
        WHERE 1 AND v.conduction_sticker = ? ";
        $paramType = "s";
        $paramValue = array(
            $cs,
        );
        return Database::connect()->runQuery($query, $paramType, $paramValue);
    }

    public function updateVehiclePlate($array_data)
    {
        $query = "UPDATE `vehicle`
        SET
        `plate_number` = ?,
        `modified_by` = ?,
        `date_modified` = NOW()
        WHERE `id` = ?
        ";
        $paramType = "sii";
        $paramValue = array(
            $array_data['plate'],
            $array_data['user_id'],
            $array_data['vehicle_id'],
        );
        $result =  Database::connect()->update($query, $paramType, $paramValue);
        return $result;
    }
    public function updateVehicleOr($array_data)
    {
        $query = "UPDATE `vehicle`
        SET
        `official_receipt` = ?,
        `modified_by` = ?,
        `date_modified` = NOW()
        WHERE `id` = ?
        ";
        $paramType = "sii";
        $paramValue = array(
            $array_data['or'],
            $array_data['user_id'],
            $array_data['vehicle_id'],
        );
        $result =  Database::connect()->update($query, $paramType, $paramValue);
        return $result;
    }
    public function updateVehicleCr($array_data)
    {
        $query = "UPDATE `vehicle`
        SET
        `certificate_of_registration` = ?,
        `modified_by` = ?,
        `date_modified` = NOW()
        WHERE `id` = ?
        ";
        $paramType = "sii";
        $paramValue = array(
            $array_data['cr'],
            $array_data['user_id'],
            $array_data['vehicle_id'],
        );
        $result =  Database::connect()->update($query, $paramType, $paramValue);
        return $result;
    }
    public function updateVehicleMv($array_data)
    {
        $query = "UPDATE `vehicle`
        SET
        `mv_file` = ?,
        `modified_by` = ?,
        `date_modified` = NOW()
        WHERE `id` = ?
        ";

        $paramType = "sii";
        $paramValue = array(
            $array_data['mv'],
            $array_data['user_id'],
            $array_data['vehicle_id'],
        );
        $result =  Database::connect()->update($query, $paramType, $paramValue);
        return $result;
    }
    public function updateVehicleEngineNo($array_data)
    {
        $query = "UPDATE `vehicle`
        SET
        `engine_number` = ?,
        `modified_by` = ?,
        `date_modified` = NOW()
        WHERE `id` = ?
        ";

        $paramType = "sii";
        $paramValue = array(
            $array_data['engine_no'],
            $array_data['user_id'],
            $array_data['vehicle_id'],
        );
        $result =  Database::connect()->update($query, $paramType, $paramValue);
        return $result;
    }
    public function updateVehicleChassisNo($array_data)
    {
        $query = "UPDATE `vehicle`
        SET
        `chassis_number` = ?,
        `modified_by` = ?,
        `date_modified` = NOW()
        WHERE `id` = ?
        ";

        $paramType = "sii";
        $paramValue = array(
            $array_data['chassis_no'],
            $array_data['user_id'],
            $array_data['vehicle_id'],
        );
        $result =  Database::connect()->update($query, $paramType, $paramValue);
        return $result;
    }
}