<?php

namespace App\Models\Customer;

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

class Activity
{
    public function store($paramValue)
    {
        $query = "INSERT INTO `customer_activities`(
            `id`, 
            `customer_id`, 
            `vehicle_id`, 
            `user_id`, 
            `activity`, 
            `status`
            ) 
        VALUES (?,?,?,?,?,?)";
        return Database::connect()->insert($query, "iiiisi", $paramValue);
    }

    public function storeInsurance($paramValue)
    {
        $query = "INSERT INTO `customer_activity_insurance_status`(
            `id`,
            `customer_id`,
            `user_id`,
            `plate_number`,
            `conduction_sticker`, 
            `insurance_company`, 
            `policy_number`, 
            `issue_date`, 
            `start_date`, 
            `end_date`, 
            `progress`, 
            `status`) 
        VALUES (?,?,?,?,?,?,?,?,?,?,?,?)";
        return Database::connect()->insert($query, "iiissssssssi", $paramValue);
    }

    public function template($paramValue)
    {
        $query = "SELECT * FROM `customer_activity_template` WHERE 1 AND id = ?";
        return Database::connect()->selectQuery($query, "i", $paramValue);
    }
}