function index() { data('TotalWeek', mOrder::totalThisWeek()); data('TotalMonth', mOrder::totalThisMonth()); data('TotalYear', mOrder::totalThisYear()); data('TotalAlltime', mOrder::totalAlltime()); $Model = new mOrder(); $Model->related(new mCustomer()); //$Model->related(new mOrderStatus); $Model->join('orderstatus/next_step'); $Model->db->select('order.*, customer.*, orderstatus.*')->select('next_step.orderstatus_id AS nextstatusid', FALSE)->select('next_step.name AS nextstatusname', FALSE)->select('next_step.noun AS nextstatusnoun', FALSE); //->order_by('order.createddate', 'DESC'); data('TableData', $Model); $this->display('orders/list'); }