public function getcategorylist($param) { $department_id = $param['department_id']; $departmentAvailable = $this->tools->departmentAvailable($department_id); $this->criteria->add(WebImageCategoryPeer::DEPARTMENT_ID, $departmentAvailable, Criteria::IN); /* FILTER */ if (!empty($param['filter'])) { $filter = $param['filter']; if (!empty($filter['title'])) { $this->criteria->add(WebImageCategoryPeer::NAME, '%' . $filter['title'] . '%', Criteria::LIKE); } if (!empty($filter['initial'])) { $this->criteria->add(WebImageCategoryPeer::INITIAL, '%' . $filter['initial'] . '%', Criteria::LIKE); } if (!empty($filter['section'])) { $this->criteria->add(WebImageCategoryPeer::DEPARTMENT_ID, $filter['section'], Criteria::EQUAL); } } $this->criteria->addAscendingOrderByColumn(WebImageCategoryPeer::NAME); $itemsTemp = WebImageCategoryPeer::doSelect($this->criteria); $items = array(); foreach ($itemsTemp as $item) { $temp = $item->toArray(); $temp['section'] = $item->getDepartment()->toArray(); $items[] = $temp; } $output = array('success' => 1, 'data' => $items); $this->jsonwrapper->print_json($output); }
public static function retrieveByPKs($pks, $con = null) { if ($con === null) { $con = Propel::getConnection(self::DATABASE_NAME); } $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(); $criteria->add(WebImageCategoryPeer::ID, $pks, Criteria::IN); $objs = WebImageCategoryPeer::doSelect($criteria, $con); } return $objs; }