/** * Searching Customer * * @param unknown $sender * @param unknown $param * * @throws Exception * */ public function searchSupplier($sender, $param) { $results = $errors = array(); try { $items = array(); $searchTxt = isset($param->CallbackParameter->searchTxt) ? trim($param->CallbackParameter->searchTxt) : ''; foreach (Supplier::getAllByCriteria('name like :searchTxt or contactName like :searchTxt', array('searchTxt' => $searchTxt . '%')) as $supplier) { $items[] = $supplier->getJson(); } $results['items'] = $items; } catch (Exception $ex) { $errors[] = $ex->getMessage(); } $param->ResponseData = StringUtilsAbstract::getJson($results, $errors); }
private function _getSuppliers(array $params) { $searchTxt = trim(isset($params['searchTxt']) ? $params['searchTxt'] : ''); $pageSize = isset($params['pageSize']) && ($pageSize = trim($params['pageSize'])) !== '' ? $pageSize : DaoQuery::DEFAUTL_PAGE_SIZE; $pageNo = isset($params['pageNo']) && ($pageNo = trim($params['pageNo'])) !== '' ? $pageNo : null; $orderBy = isset($params['orderBy']) ? $params['orderBy'] : array(); $where = array('name like :searchTxt or description like :searchTxt'); $sqlParams = array('searchTxt' => '%' . $searchTxt . '%'); $stats = array(); $items = Supplier::getAllByCriteria(implode(' AND ', $where), $sqlParams, true, $pageNo, $pageSize, $orderBy, $stats); $results = array(); $results['items'] = array_map(create_function('$a', 'return $a->getJson();'), $items); $results['pageStats'] = $stats; return $results; }