application/modules/ticket/models/rpt_slip_gaji_model.php
//use for datatable with live filtering
use for datatable with live filtering
use for datatable with live filtering
function slip_lembur_no()
    {
        $query = $this->db->query('select a.empcode, B.empname, a.attd_date,a.attd_code, a.remarks
from gang_activity a
RIGHT JOIN emp_master B
ON a.empcode = b.empcode
where a.attd_date BETWEEN "2018-01-01" AND "2018-01-30"
GROUP BY a.empcode, b.empname, a.attd_date');
        return $query->result_array();
    }
function slip_lembur_no ( ) { $ query = $ this -> db -> query ( 'select a.empcode, B.empname, a.attd_date,a.attd_code, a.remarks
from gang_activity a
RIGHT JOIN emp_master B
ON a.empcode = b.empcode
where a.attd_date BETWEEN "2018-01-01" AND "2018-01-30"
GROUP BY a.empcode, b.empname, a.attd_date' ) ; return $ query -> result_array ( ) ; }
use for datatable with live filtering
use for datatable with live filtering