| Línea 48... |
Línea 48... |
| 48 |
|
48 |
|
| 49 |
public function fetchAllDataTable($search, $page = 1, $records_per_page = 10, $order_field= 'title', $order_direction = 'ASC', $idCompany)
|
49 |
public function fetchAllDataTable($search, $page = 1, $records_per_page = 10, $order_field= 'title', $order_direction = 'ASC', $idCompany)
|
| 50 |
{
|
50 |
{
|
| 51 |
$prototype = new PlanningObjectivesAndGoalsObjectives();
|
51 |
$prototype = new PlanningObjectivesAndGoalsObjectives();
|
| 52 |
$select = $this->sql->select(self::_TABLE);
|
52 |
$select = $this->sql->select(self::_TABLE);
|
| 53 |
$select->where->equalTo('id_company', $idCompany)->equalTo('status', 'a');
|
53 |
$select->where->equalTo('id_company', $idCompany);
|
| Línea 54... |
Línea 54... |
| 54 |
$select->where->notEqualTo('status', PlanningObjectivesAndGoalsObjectives::STATUS_DELETE);
|
54 |
$select->where->notEqualTo('status', PlanningObjectivesAndGoalsObjectives::STATUS_DELETE);
|
| 55 |
|
55 |
|
| Línea 74... |
Línea 74... |
| 74 |
}
|
74 |
}
|
| 75 |
public function fetchAll($idCompany)
|
75 |
public function fetchAll($idCompany)
|
| 76 |
{
|
76 |
{
|
| 77 |
$prototype = new PlanningObjectivesAndGoalsObjectives();
|
77 |
$prototype = new PlanningObjectivesAndGoalsObjectives();
|
| 78 |
$select = $this->sql->select(self::_TABLE);
|
78 |
$select = $this->sql->select(self::_TABLE);
|
| 79 |
$select->where->equalTo('id_company', $idCompany);
|
79 |
$select->where->equalTo('id_company', $idCompany)->equalTo('status', 'a');
|
| 80 |
$select->where->notEqualTo('status', PlanningObjectivesAndGoalsObjectives::STATUS_DELETE);
|
80 |
$select->where->notEqualTo('status', PlanningObjectivesAndGoalsObjectives::STATUS_DELETE);
|
| 81 |
return $this->executeFetchAllObject($select, $prototype);
|
81 |
return $this->executeFetchAllObject($select, $prototype);
|
| 82 |
}
|
82 |
}
|
| 83 |
public function insert($datos)
|
83 |
public function insert($datos)
|
| 84 |
{
|
84 |
{
|