Proyectos de Subversion LeadersLinked - Services

Rev

Rev 1 | Mostrar el archivo completo | | | Autoría | Ultima modificación | Ver Log |

Rev 1 Rev 146
Línea 59... Línea 59...
59 
     */
 59 
     */
60 
    public function fetchAllDataTableByCompanyIdAndGoalId($company_id, $goal_id, $search, $page = 1, $records_per_page = 10, $order_field= 'title', $order_direction = 'ASC')
 60 
    public function fetchAllDataTableByCompanyIdAndGoalId($company_id, $goal_id, $search, $page = 1, $records_per_page = 10, $order_field= 'title', $order_direction = 'ASC')
61 
    {
 61 
    {
62 
        $prototype = new PlanningTask();
 62 
        $prototype = new PlanningTask();
63 
        $select = $this->sql->select(self::_TABLE);
 63 
        $select = $this->sql->select(self::_TABLE);
64 
        $select->where->equalTo('company_id', $goal_id);
 64 
        $select->where->equalTo('company_id', $company_id);
65 
        $select->where->equalTo('goal_id', $goal_id);
 65 
        $select->where->equalTo('goal_id', $goal_id);
Línea 66... Línea 66...
66 
 
 66 
 
67
67
68
68
69 
        if($search) {
 69 
        if($search) {
Línea -... Línea 70...
- 
 
 70 
            $select->where->like('title', '%' . $search . '%');
- 
 
 71 
        }
Línea 70... Línea 72...
70 
            $select->where->like('title', '%' . $search . '%');
 72 
        $select->order($order_field . ' ' . $order_direction);
71 
        }
 73