先講一下寫本文要解決的問題，後端有很多from表單查詢列表，之前的寫法自己寫原生sql或者orm支援的封裝的多where查詢，在自己的專案的model或者repository一般都封裝了許多要查詢的欄位校驗查詢條件，這樣一來又要複寫許多程式碼，很多框架都會封裝許多interface，但是實際專案中每個model維護的欄位都不一樣。
下面講一下實現思路：
1. 封裝一個建立查詢表的介面buildFrom 來接接收引數建立表單。
2.封裝一個接收前端提交過來的查詢引數拼裝需要搜尋的查詢sql（可session或cache中）。
3.自己模型需要serach的時候傳一個bysearch引數來接收存的sql。
buildFrom程式碼控制器程式碼邏輯如下：
```
<?php
public function buildForm($module = '', $searchFields = '', $fieldParams = '', $actionURL = '', $queryID = 0)
{
if($queryID == 0 and $this->session->queryID != false)
{
$queryID = $this->session->queryID;
$this->session->set('queryID', false);
}
if(empty($module)){
$module = empty($module) ? $this->session->searchParams['module'] : $module;
$searchFields = empty($searchFields) ? json_decode($this->session->searchParams['searchFields'], true) : $searchFields;
$fieldParams = empty($fieldParams) ? json_decode($this->session->searchParams['fieldParams'], true) : $fieldParams;
}else{
$sessionKey = 'searchParams'.$module;
$searchFields = empty($searchFields) ? json_decode($this->session->$sessionKey['searchFields'], true) : $searchFields;
$fieldParams = empty($fieldParams) ? json_decode($this->session->$sessionKey['fieldParams'], true) : $fieldParams;
}
$this->search->initSession($module, $searchFields, $fieldParams);
$this->json(array(
'module' => $module,
"fields" => $searchFields,
"params" => $this->search->setDefaultParams($searchFields, $fieldParams),
));
}
// 返回查詢sql
public function buildQuery($queryID = '')
{
$this->search->buildQuery();\
$this->json(array("code"=>200));
}
```
model程式碼用的initSession這個方法：
```
<?php
class searchModel extends model
{
/**
* Set search params to session.
*
* @param array $searchConfig
* @access public
* @return void
*/
public function setSearchParams($searchConfig)
{
$searchParams['module'] = $searchConfig['module'];
$searchParams['searchFields'] = json_encode($searchConfig['fields']);
$searchParams['fieldParams'] = json_encode($searchConfig['params']);
$searchParams['actionURL'] = $searchConfig['actionURL'];
$searchParams['queryID'] = isset($searchConfig['queryID']) ? $searchConfig['queryID'] : 0;
/* remove onlybody for url*/
$onlybodyParam = $this->config->requestType == 'GET' ? '&onlybody=yes' : '?onlybody=yes';
$searchParams['actionURL'] = str_replace($onlybodyParam, '', $searchParams['actionURL']);
//防止多個瀏覽器頁面同時訪問，session亂的問題
$this->session->set('searchParams'.$searchConfig['module'], $searchParams);
$this->session->set('searchParams', $searchParams);
}
/**
* Build the query to execute.
*
* @access public
* @return void
*/
public function buildQuery()
{
/* Init vars. */
$where = '';
$groupItems = $this->config->search->groupItems;
$groupAndOr = strtoupper($this->post->groupAndOr);
if($groupAndOr != 'AND' and $groupAndOr != 'OR') $groupAndOr = 'AND';
for($i = 1; $i <= $groupItems * 2; $i ++)
{
/* The and or between two groups. */
if($i == 1) $where .= '(( 1 ';
if($i == $groupItems + 1) $where .= " ) $groupAndOr ( 1 ";
/* Set var names. */
$fieldName = "field$i";
$andOrName = "andOr$i";
$operatorName = "operator$i";
$valueName = "value$i";
if($this->post->$fieldName == '' || $this->post->$valueName == ''){
continue;
}
/* Skip empty values. */
if($this->post->$valueName == false) continue;
if($this->post->$valueName == 'null') $this->post->$valueName = ''; // Null is special, stands to empty.
if($this->post->$valueName == 'ZERO') $this->post->$valueName = 0; // ZERO is special, stands to 0.
if($this->post->module == 'suppliergoods'){
if($this->post->$fieldName == 'createdDate'){
$this->post->$fieldName = 'left(`createdDate`,10)';
$this->post->$valueName = substr($this->post->$valueName, 0, 10);
}
}else if($this->post->module == 'surveyexam'){
if($this->post->$fieldName == 'a.status'){
$this->post->$fieldName = 'a.`status`';
}
}else if($this->post->module == 'agent'){
if($this->post->$fieldName == 'createdBy'){
$this->post->$fieldName = 'U.`realname`';
}
} else if($this->post->module == 'itembank'){
if($this->post->$fieldName == 'createdBy'){
$this->post->$fieldName = 't2.`realname`';
}
}else if($this->post->module == 'performanceexam'){
if($this->post->$fieldName == 'checkedBy'){
$this->post->$fieldName = 'b.`realname`';
}
}else if($this->post->module == 'knowledge'){
if($this->post->$fieldName == 'a.publishDate'){
$this->post->$fieldName = 'left(a.`publishDate`,10)';
$this->post->$valueName = substr($this->post->$valueName, 0, 10);
}
}else if($this->post->module == 'complain'){
if($this->post->$fieldName == 't1.processDate'){
$this->post->$fieldName = 'left(t1.`processDate`,10)';
$this->post->$valueName = substr($this->post->$valueName, 0, 10);
}
if($this->post->$fieldName == 't1.appiontDate'){
$this->post->$fieldName = 'left(t1.`appiontDate`,10)';
$this->post->$valueName = substr($this->post->$valueName, 0, 10);
}
}else if($this->post->module == 'turnover'){
if($this->post->$fieldName = 'date'){
$this->post->$fieldName = 'left(`date`, 10)';
}
if($this->post->$fieldName == 'left(`date`, 10)'){
$this->post->$fieldName = 'left(`date`, 10)';
$this->post->$valueName = substr($this->post->$valueName, 0, 10);
}elseif($this->post->$fieldName == 'left(`date`, 7)'){
$this->post->$fieldName = 'left(`date`, 7)';
$this->post->$valueName = substr($this->post->$valueName, 0, 7);
}elseif($this->post->$fieldName == 'count(`order`)'){
$this->post->$fieldName = 'count(`order`)';
}elseif($this->post->$fieldName == 'sum(`amount`)'){
$this->post->$fieldName = 'sum(`amount`)';
}
}
if(in_array($this->post->$fieldName, array('A.editedDate','attendDate','signinDate','createdDate','editedDate','startDate','endDate','assignDate','transformationDate','nextDate','a.createdDate','appointDate','releaseDate','a.uploadDate','A.assignDate','A.appointDate','A.createdDate','a.auditDate','A.transformationDate'))) {
$this->post->$fieldName = 'left('.$this->post->$fieldName.',10)';
$this->post->$valueName = substr($this->post->$valueName, 0, 10);
}
/* Set and or. */
$andOr = strtoupper($this->post->$andOrName);
if($andOr != 'AND' and $andOr != 'OR') $andOr = 'AND';
$where .= " $andOr ";
/* Set filed name. not use `` if has alias. */
if(strpos($this->post->$fieldName, '.') === false)
{
if(strpos(',suppliergoods|surveyexam', $this->post->module)){
$where .= $this->post->$fieldName;
if($this->post->module == 'surveyexam' && $this->post->$fieldName == 'a.`status`'){
if($this->post->$valueName == 1){
}elseif($this->post->$valueName == 2){
}
}
}elseif($this->post->module == 'turnover'){
if($this->post->$fieldName == 'left(`date`, 10)'){
$where .= $this->post->$fieldName;
}elseif($this->post->$fieldName == 'left(`date`, 7)'){
$where .= $this->post->$fieldName;
}elseif($this->post->$fieldName == 'count(`order`)'){
$where .= $this->post->$fieldName;
}elseif($this->post->$fieldName == 'sum(`amount`)'){
$where .= $this->post->$fieldName;
}else{
$where .= '`' . $this->post->$fieldName . '` ';
}
}else{
if(in_array($this->post->$fieldName, array('left(A.editedDate,10)','left(A.transformationDate,10)','left(attendDate,10)','left(signinDate,10)','left(createdDate,10)','left(editedDate,10)','left(startDate,10)','left(endDate,10)'
,'left(assignDate,10)','left(transformationDate,10)','left(nextDate,10)','left(a.createdDate,10)','left(appointDate,10)','left(releaseDate,10)','left(a.uploadDate,10)','left(A.assignDate,10)','left(A.appointDate,10)','left(a.auditDate,10)'))){
$where.= $this->post->$fieldName;
}else{
$where .= '`' . $this->post->$fieldName . '` ';
}
}
}
elseif($this->post->$fieldName == 'contract.productLine')
{
/* Search contracts by product or product line. */
$where .= ' id ';
}
else
{
$where .= $this->post->$fieldName . ' ';
}
/* Set operator. */
$value = $this->post->$valueName;
$operator = $this->post->$operatorName;
if(!isset($this->lang->search->operators[$operator])) $operator = '='
if($operator == "include")
{
if($this->post->$fieldName == 'contract.productLine')
{
$where .= helper::dbIN($contracts);
}
else
{
if($this->post->$fieldName == 'o.product') $value = ',' . $value . ',';
$where .= ' LIKE ' . $this->dbh->quote("%" . trim($value) ."%");
}
}
elseif($operator == "notinclude")
{
if($this->post->$fieldName == 'contract.productLine')
{
$where .= ' NOT ' . helper::dbIN($contracts);
}
else
{
$where .= ' NOT LIKE ' . $this->dbh->quote("%" . trim($value) . "%");
}
}
elseif($operator == 'belong')
{
if($this->post->$fieldName == 'module' or $this->post->$fieldName == 'area' or $this->post->$fieldName == 'industry')
{
if($value == 0) $where .= ' RLIKE ' . $this->dbh->quote("[0-9]*");
$allModules = $this->loadModel('tree')->getAllChildId($value);
if($allModules) $where .= helper::dbIN($allModules);
}
elseif($this->post->$fieldName == 'dept')
{
$allDepts = $this->loadModel('dept')->getAllChildId($value);
$where .= helper::dbIN($allDepts);
}
elseif($this->post->$fieldName == 'contract.productLine')
{
$where .= " = '-1'";
}
else
{
$where .= ' = ' . $this->dbh->quote(trim($value)) . ' ';
}
}
else
{
if($this->post->$fieldName == 'contract.productLine')
{
if($operator == '=')
{
$where .= helper::dbIN($contracts);
}
elseif($operator == '!=')
{
$where .= ' NOT ' . helper::dbIN($contracts);
}
else
{
$where .= " = '-1'";
}
}
else
{
$where .= $operator . ' ' . $this->dbh->quote(trim($value)) . ' ';
}
}
}
$where .=" ))";
//echo $where;exit;
/* Save to session. */
$querySessionName = $this->post->module . 'Query';
$formSessionName = $this->post->module . 'Form';
$this->session->set($querySessionName, $where);
$this->session->set($formSessionName, $_POST);
}
/**
* Init the search session for the first time search.
*
* @param string $module
* @param array $fields
* @param array $fieldParams
* @access public
* @return void
*/
public function initSession($module, $fields, $fieldParams)
{
$formSessionName = $module . 'Form';
if($this->session->$formSessionName != false) return;
for($i = 1; $i <= $this->config->search->groupItems * 2; $i ++)
{
/* Var names. */
$fieldName = "field$i";
$andOrName = "andOr$i";
$operatorName = "operator$i";
$valueName = "value$i";
$currentField = key($fields);
$operator = isset($fieldParams[$currentField]['operator']) ? $fieldParams[$currentField]['operator'] : '=';
$queryForm[$fieldName] = key($fields);
$queryForm[$andOrName] = 'and';
$queryForm[$operatorName] = $operator;
$queryForm[$valueName] = '';
if(!next($fields)) reset($fields);
}
$queryForm['groupAndOr'] = 'and';
$this->session->set($formSessionName, $queryForm);
}
/**
* Set default params for selection.
*
* @param array $fields
* @param array $params
* @access public
* @return array
*/
public function setDefaultParams($fields, $params)
{
$hasProduct = false;
$hasProject = false;
$hasUser = false;
$hasOrganize = false;
$hasOfflinecourse = false;
$hasAgentleavel = false;
$groupUsers = false;
$fields = array_keys($fields);
foreach($fields as $fieldName)
{
if(empty($params[$fieldName])) continue;
if($params[$fieldName]['values'] == 'products') $hasProduct = true;
if($params[$fieldName]['values'] == 'users') $hasUser = true;
if($params[$fieldName]['values'] == 'projects') $hasProject = true;
if($params[$fieldName]['values'] == 'organize') $hasOrganize = true;
if($params[$fieldName]['values'] == 'offlinecourses') $hasOfflinecourse = true;
if($params[$fieldName]['values'] == 'agentlevels') $hasAgentleavel = true;
if($params[$fieldName]['values'] == 'process') $hasProcess = true;
if($params[$fieldName]['values'] == 'welfare') $hasWelfarerecord = true;
if($params[$fieldName]['values'] == 'groupUsers') $groupUsers = true;//獲取自己的下級賬戶
if($params[$fieldName]['values'] == 'onlinecourseagentlevels') $hasonlinecourseagentlevel= true;//獲取自己的下級賬戶
if($params[$fieldName]['values'] == 'selectlevel') $selectlevel= true;//獲取自己的下級賬戶
if($params[$fieldName]['values'] == 'smallwx') $smallwx = true;//獲取微信小號
if($params[$fieldName]['values'] == 'linkwx') $linkwx = true;//獲取微聯鎖號
if($params[$fieldName]['values'] == 'contract') $contract = true;
if($params[$fieldName]['values'] == 'gthcontract') $gthcontract = true;
if($params[$fieldName]['values'] == 'thirdorganize') $thirdorganize = true;
if($params[$fieldName]['values'] == 'salerole') $hasSalerole = true;
if($params[$fieldName]['values'] == 'offlineteacher') $hasOfflineteacher = true;
if($params[$fieldName]['values'] == 'complainlevel') $hascomplainlevel = true;
}
if($hascomplainlevel){
$complainlevels= $this->loadModel('complainlevel')->getComplainLevelPairs();
}
if($hasOfflineteacher){
$offlineteachers = $this->loadModel('offlineteacher')->getofflineteacherPairs();
}
if($hasSalerole){
$Saleroles = $this->loadModel('agent')->getSaleRoleLists();
}
if($thirdorganize)
{
$thirdorganizes = $this->loadModel('organize')->getThirdsOrganizePairs();
}
if($gthcontract)
{
$gthcontracts = $this->loadModel('gthcontract','gth')->getContractList();
}
if($contract)
{
$contracts = $this->loadModel('contract','fi')->getContractList();
}
if($smallwx)
{
$smallwxs = $this->loadModel('agent')->getSmallwxPairs();
}
if($linkwx)
{
$linkwxs = $this->loadModel('agent')->getLinkwxPairs();
}
if($selectlevel)
{
$selectlevels = $this->loadModel('onlinestudy')->getdoubleonlinelist();
}
if($hasonlinecourseagentlevel)
{
$hasonlinecourseagentlevels = $this->loadModel('onlinecourseagentlevel')->getOnlineCourseAgentlevelList();
}
if($hasWelfarerecord)
{
$hasWelfarerecords = $this->loadModel('welfare')->getWelfarePairs();
}
if($hasAgentleavel)
{
$hasAgentleavels = $this->loadModel('agentlevel')->getAgentLevelList()；
}
if($hasOfflinecourse)
{
$offlinecourses = $this->loadModel('offlinecourse')->getOfflinecoursePairs();
}
if($hasUser)
{
$users = $this->loadModel('user')->getPairs('nodeleted,noforbidden');
$users['$@me'] = $this->lang->search->me;
}
if($hasOrganize)
{
$organizes = $this->loadModel('organize')->getPairs('nodeleted,noforbidden');
}
if($hasProcess){
$process = $this->loadModel('process')->getProcessInfo();
}
if($groupUsers){//getUserAllPairs
$groupList = $this->loadModel('group')->getgroupByParentId($this->app->user->groupId);//$userGroup->group
if(!empty($groupList)){
$groupList = array_keys($groupList);
$userPairs = $this->loadModel('group')->getUserAllPairs($groupList);
}else{
$userPairs = [];
}
$userPairs['$@me'] = $this->lang->search->me;
}
if($hasProduct) $products = $this->loadModel('product', 'sys')->getPairs();
if($hasProject) $projects = $this->loadModel('project', 'proj')->getPairs();
foreach($fields as $fieldName)
{
if(!isset($params[$fieldName])) $params[$fieldName] = array('operator' => '=', 'control' => 'input', 'values' => '');
if($params[$fieldName]['values'] == 'users') $params[$fieldName]['values'] = $users;
if($params[$fieldName]['values'] == 'products') $params[$fieldName]['values'] = $products;
if($params[$fieldName]['values'] == 'projects') $params[$fieldName]['values'] = $projects;
if($params[$fieldName]['values'] == 'organize') $params[$fieldName]['values'] = $organizes;
if($params[$fieldName]['values'] == 'offlinecourses') $params[$fieldName]['values'] = $offlinecourses;
if($params[$fieldName]['values'] == 'agentlevels') $params[$fieldName]['values'] = $hasAgentleavels;
if($params[$fieldName]['values'] == 'process') $params[$fieldName]['values'] = $process;
if($params[$fieldName]['values'] == 'welfare') $params[$fieldName]['values'] = $hasWelfarerecords;
if($params[$fieldName]['values'] == 'groupUsers') $params[$fieldName]['values'] = $userPairs;
if($params[$fieldName]['values'] == 'onlinecourseagentlevels') $params[$fieldName]['values'] = $hasonlinecourseagentlevels;
if($params[$fieldName]['values'] == 'selectlevel') $params[$fieldName]['values'] = $selectlevels;
if($params[$fieldName]['values'] == 'smallwx') $params[$fieldName]['values'] = $smallwxs;
if($params[$fieldName]['values'] == 'linkwx') $params[$fieldName]['values'] = $linkwxs;
if($params[$fieldName]['values'] == 'contract') $params[$fieldName]['values'] = $contracts;
if($params[$fieldName]['values'] == 'gthcontract') $params[$fieldName]['values'] = $gthcontracts;
if($params[$fieldName]['values'] == 'thirdorganize') $params[$fieldName]['values'] = $thirdorganizes;
if($params[$fieldName]['values'] == 'salerole') $params[$fieldName]['values'] = $Saleroles;
if($params[$fieldName]['values'] == 'offlineteacher') $params[$fieldName]['values'] = $offlineteachers;
if($params[$fieldName]['values'] == 'complainlevel') $params[$fieldName]['values'] = $complainlevels;
if(is_array($params[$fieldName]['values']))
{
/* For build right sql when key is 0 and is not null. e.g. confirmed field. */
if(isset($params[$fieldName]['values'][0]) and $params[$fieldName]['values'][0] !== '')
{
$params[$fieldName]['values'] = array('ZERO' => $params[$fieldName]['values'][0]) + $params[$fieldName]['values'];
unset($params[$fieldName]['values'][0]);
}
else
{
$params[$fieldName]['values'] = $params[$fieldName]['values'];// + array('null' => $this->lang->search->null);
}
}
}
return $params;
}
/**
* Get a query.
*
* @param int $queryID
* @access public
* @return string
*/
public function getQuery($queryID)
{
$query = $this->dao->findByID($queryID)->from(TABLE_USERQUERY)->fetch();
if(!$query) return false;
/* Decode html encode. */
$query->form = htmlspecialchars_decode($query->form, ENT_QUOTES);
$query->sql = htmlspecialchars_decode($query->sql, ENT_QUOTES);
$query->form = unserialize($query->form);
$query->sql = $this->replaceDynamic($query->sql);
return $query;
}
/**
* Save current query to db.
*
* @access public
* @return void
*/
public function saveQuery()
{
$sqlVar = $this->post->module . 'Query';
$formVar = $this->post->module . 'Form';
$sql = $this->session->$sqlVar;
if(!$sql) $sql = ' 1 = 1 ';
$query = fixer::input('post')
->add('account', $this->app->user->account)
->add('form', serialize($this->session->$formVar))
->add('sql', $sql)
->get();
$this->dao->insert(TABLE_USERQUERY)->data($query)->autoCheck()->check('title', 'notempty')->exec();
}
/**
* Get title => id pairs of a user.
*
* @param string $module
* @access public
* @return array
*/
public function getQueryPairs($module)
{
$queries = $this->dao->select('id, title')
->from(TABLE_USERQUERY)
->where('account')->eq($this->app->user->account)
->andWhere('module')->eq($module)
->orderBy('id_asc')
->fetchPairs();
if(!$queries) return array('' => $this->lang->search->myQuery);
$queries = array('' => $this->lang->search->myQuery) + $queries;
return $queries;
}
/**
* Get records by the conditon.
*
* @param string $module
* @param string $moduleIds
* @param string $conditions
* @access public
* @return array
*/
public function getBySelect($module, $moduleIds, $conditions)
{
if($module == 'story')
{
$pairs = 'id,title';
$table = 'zt_story';
}
else if($module == 'task')
{
$pairs = 'id,name';
$table = 'zt_task';
}
$query = '`' . $conditions['field1'] . '`';
$operator = $conditions['operator1'];
$value = $conditions['value1'];
if(!isset($this->lang->search->operators[$operator])) $operator = '=';
if($operator == "include")
{
$query .= ' LIKE ' . $this->dbh->quote("%$value%");
}
elseif($operator == "notinclude")
{
$where .= ' NOT LIKE ' . $this->dbh->quote("%$value%");
}
else
{
$query .= $operator . ' ' . $this->dbh->quote($value) . ' ';
}
foreach($moduleIds as $id)
{
if(!$id) continue;
$title = $this->dao->select($pairs)
->from($table)
->where('id')->eq((int)$id)
->andWhere($query)
->fetch();
if($title) $results[$id] = $title;
}
if(!isset($results)) return array();
return $this->formatResults($results, $module);
}
/**
* Format the results.
*
* @param array $results
* @param string $module
* @access public
* @return array
*/
public function formatResults($results, $module)
{
/* Get title field. */
$title = ($module == 'story') ? 'title' : 'name';
$resultPairs = array('' => '');
foreach($results as $result) $resultPairs[$result->id] = $result->id . ':' . $result->$title;
return $resultPairs;
}
/**
Replace dynamic account and date.
*
* @param string $query
* @access public
* @return string
*/
public function replaceDynamic($query)
{
$this->app->loadClass('date');
$lastWeek = date::getLastWeek();
$thisWeek = date::getThisWeek();
$lastMonth = date::getLastMonth();
$thisMonth = date::getThisMonth();
$yesterday = date::yesterday();
$today = date::today();
if(strpos($query, '$') !== false)
{
$query = str_replace('$@me', $this->app->user->account, $query);
$query = str_replace("'\$lastMonth'", "'" . $lastMonth['begin'] . "' and '" . $lastMonth['end'] . "'", $query);
$query = str_replace("'\$thisMonth'", "'" . $thisMonth['begin'] . "' and '" . $thisMonth['end'] . "'", $query);
$query = str_replace("'\$lastWeek'", "'" . $lastWeek['begin'] . "' and '" . $lastWeek['end'] . "'", $query);
$query = str_replace("'\$thisWeek'", "'" . $thisWeek['begin'] . "' and '" . $thisWeek['end'] . "'", $query);
$query = str_replace("'\$yesterday'", "'" . $yesterday . "' and '" . $yesterday . "'", $query);
$query = str_replace("'\$today'", "'" . $today . "' and '" . $today . "'", $query);
}
return $query;
}
/**
* replace defined table names.
*
* @param string $sql
* @access public
* @return void
*/
public function replaceTableNames($sql)
{
if(preg_match_all("/TABLE_[A-Z]+/", $sql, $out))
{
foreach($out[0] as $table)
{
if(!defined($table)) continue;
$sql = str_replace($table, trim(constant($table), '`'), $sql);
}
}
return $sql;
}
}
// 呼叫查詢邏輯 配置語言包 lang.php
if(!isset($lang->agentlevel)) $lang->agentlevel = new stdclass();
$lang->agentlevel->id = 'ID';
$lang->agentlevel->type = '型別';
$lang->agentlevel->levleId = '等級名稱';
$lang->agentlevel->sort = '排序';
$lang->agentlevel->discount = '折扣';
//配置查詢引數 config.php
global $lang, $app;
$app->loadLang('agentlevel','crm');
$config->agentlevel->search['module'] = 'agentlevel';
$config->agentlevel->search['fields']['type'] = $lang->agentlevel->type;
$config->agentlevel->search['fields']['levleId'] = $lang->agentlevel->levleId;
$config->agentlevel->search['fields']['discount'] = $lang->agentlevel->discount;
$config->agentlevel->search['fields']['goodsPrice'] = $lang->agentlevel->goodsPrice;
$config->agentlevel->search['params']['type'] = array('operator' => '=', 'control' => 'select', 'values' => $lang->agentlevel->typeList,'class'=>'');
$config->agentlevel->search['params']['levleId'] = array('operator'=> '=', 'control' => 'select','values' => 'agentlevels','class'=>'');
$config->agentlevel->search['params']['discount'] = array('operator' => 'include', 'control' => 'input', 'values' => '');
// 控制器裡呼叫controller.php
public function browse($mode = 'all',$search = '', $orderBy = 'id_desc', $recTotal = 0, $recPerPage = 20, $pageID = 1)
{
$this->app->loadClass('pager', $static = true);
$pager = new pager($recTotal, $recPerPage, $pageID);
$customers = $this->agentlevel->getList($mode = $mode, $orderBy, $pager,$search);
$data['title'] = $this->lang->service->list;
$data['mode'] = $mode;
$data['orderBy'] = $orderBy;
$data['pager'] = $this->loadModel('common', 'sys')->getPager($pager);//以陣列形式返回
$data['agentlevel'] = (array)$customers;//查詢資料
$this->loadModel('search', 'sys');
$this->search->setSearchParams($this->config->agentlevel->search);
$this->json($data);
}
// model.php
public function getList($mode = 'all', $orderBy = 'id_desc', $pager = null,$search = '')
{
if(strpos($orderBy, 'id') === false){
if(empty($orderBy)){
$orderBy .= 'id_desc';
}else{
$orderBy .= ', id_desc';
}
}
if($this->session->agentlevelQuery === false) $this->session->set('agentlevelQuery', ' 1 = 1');
$contractQuery = $this->loadModel('search', 'sys')->replaceDynamic($this->session->agentlevelQuery);
return $this->dao->select('*')->from(TABLE_AGENTLEVEL)
->where('1')->eq(1)
->andWhere('status')->ne('99')
->beginIF(strtolower($search) == 'bysearch')->andWhere($contractQuery)->fi()
->orderBy($orderBy)
->page($pager)
->fetchAll();
}
本作品採用《CC 協議》，轉載必須註明作者和本文連結