<?php

//é possível extender My_Model para reutilizar métodos básicos
Class AlocationVehicle extends My_Model{
    //define o nome da tabela, utilizada em métodos básicos da classe my_model
    public $table="module_fleets_alocation_vehicle"; 
    
    public  function allList(){
        return ORM::for_table($this->table)
                ->table_alias('av')
                    ->select('av.*')
                    ->select('c.account', 'account')
                    ->select('v.board', 'board')
                    ->select('v.brand', 'brand')
                    ->select('v.model', 'model')
                    ->join('crm_accounts', array('c.id', '=', 'av.employee_id'), 'c')
                    ->join('module_fleets_vehicle', array('v.id', '=', 'av.module_fleets_vehicle_id'), 'v')
                ->order_by_asc('out')
                ->order_by_desc('date_out')
                ->find_many();  
    }
}