<?php
class M_lead extends CI_Model{
	private $table = "progress";
	private $primary = "ID";

	function ListLead($limit=5,$offset=0,$order_column='',$order_type='asc'){
		date_default_timezone_set('Asia/Jakarta');
        if(empty($order_column) || empty($order_type))
            $this->db->order_by($this->primary,'asc');
        else
            $this->db->order_by($order_column,$order_type);

        $date=date("Y-m-d");
        $res = $this->db->query("SELECT
                                ID,
                                SERVICE_ORDER,
                                TECHNICIAN,
                                STATUS,
                                SERVICE_ADVISOR,
                                REPAIR_TYPE,
                                POLICE_NO,
                                CUSTOMER,
                                DELIVERY_TIME,
                                FINISH_TIME AS clockoff,
                                format(((TIME_TO_SEC(curtime())-TIME_TO_SEC(DELIVERY_TIME))/60),0) AS beda FROM progress
                                WHERE  DATE(delivery_date)='$date'
                                AND service_advisor<>'THS'
                                and (repair_type<>'PDI' and repair_type<>'BOR' and repair_type<>'THS' and repair_type<>'PRT')
                                and (status='20' or status='30' or status='39') having beda >='-25'
                                ");
        return $res;

    }

     function jumlah(){
        $date=date("Y-m-d");
        $sql = $this->db->query("SELECT COUNT(*) as tot, format(((TIME_TO_SEC(curtime())-TIME_TO_SEC(DELIVERY_TIME))/60),0) AS beda FROM progress
                                WHERE  DATE(delivery_date)='$date'
                                AND service_advisor<>'THS'
                                and (repair_type<>'PDI' and repair_type<>'BOR' and repair_type<>'THS' and repair_type<>'PRT')
                                and (status='20' or status='30' or status='39') having beda >='-25'");
        $tot = "";
        foreach($sql->result() as $row)
        {
            $tot = $row->tot;
        }

        return $tot;
    }



}