PHP helper::dbIN方法代码示例

 /**
  * Import from Bug. 
  * 
  * @param  int    $projectID 
  * @param  string $orderBy 
  * @param  int    $recTotal 
  * @param  int    $recPerPage 
  * @param  int    $pageID 
  * @access public
  * @return void
  */
 public function importBug($projectID = 0, $browseType = 'all', $param = 0, $recTotal = 0, $recPerPage = 30, $pageID = 1)
 {
     if (!empty($_POST)) {
         $mails = $this->project->importBug($projectID);
         if (dao::isError()) {
             die(js::error(dao::getError()));
         }
         foreach ($mails as $mail) {
             $this->sendmail($mail->taskID, $mail->actionID);
         }
         /* Locate the browser. */
         die(js::locate($this->createLink('project', 'importBug', "projectID={$projectID}"), 'parent'));
     }
     /* Set browseType, productID, moduleID and queryID. */
     $browseType = strtolower($browseType);
     $queryID = $browseType == 'bysearch' ? (int) $param : 0;
     /* Save to session. */
     $uri = $this->app->getURI(true);
     $this->app->session->set('bugList', $uri);
     $this->app->session->set('storyList', $uri);
     $this->app->session->set('projectList', $uri);
     $this->loadModel('bug');
     $projects = $this->project->getPairs('nocode');
     $this->project->setMenu($projects, $projectID);
     /* Load pager. */
     $this->app->loadClass('pager', $static = true);
     $pager = new pager($recTotal, $recPerPage, $pageID);
     $title = $projects[$projectID] . $this->lang->colon . $this->lang->project->importBug;
     $position[] = html::a($this->createLink('project', 'task', "projectID={$projectID}"), $projects[$projectID]);
     $position[] = $this->lang->project->importBug;
     /* Get users, products and projects.*/
     $users = $this->project->getTeamMemberPairs($projectID, 'nodeleted');
     $products = $this->dao->select('t1.product, t2.name')->from(TABLE_PROJECTPRODUCT)->alias('t1')->leftJoin(TABLE_PRODUCT)->alias('t2')->on('t1.product = t2.id')->where('t1.project')->eq($projectID)->fetchPairs('product');
     if (!empty($products)) {
         unset($projects);
         $projects = $this->dao->select('t1.project, t2.name')->from(TABLE_PROJECTPRODUCT)->alias('t1')->leftJoin(TABLE_PROJECT)->alias('t2')->on('t1.project = t2.id')->where('t1.product')->in(array_keys($products))->fetchPairs('project');
     } else {
         $projectName = $projects[$projectID];
         unset($projects);
         $projects[$projectID] = $projectName;
     }
     /* Get bugs.*/
     $bugs = array();
     if ($browseType != "bysearch") {
         $bugs = $this->bug->getActiveAndPostponedBugs(array_keys($products), $projectID, $pager);
     } else {
         if ($queryID) {
             $query = $this->loadModel('search')->getQuery($queryID);
             if ($query) {
                 $this->session->set('importBugQuery', $query->sql);
                 $this->session->set('importBugForm', $query->form);
             } else {
                 $this->session->set('importBugQuery', ' 1 = 1');
             }
         } else {
             if ($this->session->importBugQuery == false) {
                 $this->session->set('importBugQuery', ' 1 = 1');
             }
         }
         $bugQuery = str_replace("`product` = 'all'", "`product`" . helper::dbIN(array_keys($products)), $this->session->importBugQuery);
         // Search all project.
         $bugs = $this->project->getSearchBugs($products, $projectID, $bugQuery, $pager, 'id_desc');
     }
     /* Build the search form. */
     $this->config->bug->search['actionURL'] = $this->createLink('project', 'importBug', "projectID={$projectID}&browseType=bySearch&param=myQueryID");
     $this->config->bug->search['queryID'] = $queryID;
     if (!empty($products)) {
         $this->config->bug->search['params']['product']['values'] = array('' => '') + $products + array('all' => $this->lang->project->aboveAllProduct);
     } else {
         $this->config->bug->search['params']['product']['values'] = array('' => '');
     }
     $this->config->bug->search['params']['project']['values'] = array('' => '') + $projects + array('all' => $this->lang->project->aboveAllProject);
     $this->config->bug->search['params']['plan']['values'] = $this->loadModel('productplan')->getPairs(array_keys($products));
     $this->config->bug->search['module'] = 'importBug';
     $this->config->bug->search['params']['confirmed']['values'] = array('' => '') + $this->lang->bug->confirmedList;
     $this->config->bug->search['params']['module']['values'] = $this->loadModel('tree')->getOptionMenu($projectID, $viewType = 'bug', $startModuleID = 0);
     unset($this->config->bug->search['fields']['resolvedBy']);
     unset($this->config->bug->search['fields']['closedBy']);
     unset($this->config->bug->search['fields']['status']);
     unset($this->config->bug->search['fields']['toTask']);
     unset($this->config->bug->search['fields']['toStory']);
     unset($this->config->bug->search['fields']['severity']);
     unset($this->config->bug->search['fields']['resolution']);
     unset($this->config->bug->search['fields']['resolvedBuild']);
     unset($this->config->bug->search['fields']['resolvedDate']);
     unset($this->config->bug->search['fields']['closedDate']);
     unset($this->config->bug->search['params']['resolvedBy']);
     unset($this->config->bug->search['params']['closedBy']);
     unset($this->config->bug->search['params']['status']);
//.........这里部分代码省略.........

 /**
  * Get dynamic by search. 
  * 
  * @param  array  $products 
  * @param  array  $projects 
  * @param  int    $queryID 
  * @param  string $orderBy 
  * @param  object $pager 
  * @access public
  * @return array 
  */
 public function getDynamicBySearch($products, $projects, $queryID, $orderBy = 'date_desc', $pager)
 {
     $query = $queryID ? $this->loadModel('search')->getQuery($queryID) : '';
     /* Get the sql and form status from the query. */
     if ($query) {
         $this->session->set('actionQuery', $query->sql);
         $this->session->set('actionForm', $query->form);
     }
     if ($this->session->actionQuery == false) {
         $this->session->set('actionQuery', ' 1 = 1');
     }
     $allProduct = "`product` = 'all'";
     $allProject = "`project` = 'all'";
     $actionQuery = $this->session->actionQuery;
     $productID = 0;
     if (preg_match("/`product` = '(\\d*)'/", $actionQuery, $out)) {
         $productID = $out[1];
     }
     /* If the sql not include 'product', add check purview for product. */
     if (strpos($actionQuery, $allProduct) === false) {
         if (!in_array($productID, array_keys($products))) {
             return array();
         }
     } else {
         $actionQuery = str_replace($allProduct, '1', $actionQuery);
     }
     /* If the sql not include 'project', add check purview for project. */
     if (strpos($actionQuery, $allProject) === false) {
         $actionQuery = $actionQuery . ' AND `project`' . helper::dbIN(array_keys($projects));
     } else {
         $actionQuery = str_replace($allProject, '1', $actionQuery);
     }
     $actionQuery = str_replace("`product` = '{$productID}'", "`product` LIKE '%,{$productID},%'", $actionQuery);
     $actions = $this->getBySQL($actionQuery, $orderBy, $pager);
     if (!$actions) {
         return array();
     }
     return $this->transformActions($actions);
 }

 /**
  * Get bugs by search. 
  * 
  * @param  int    $productID 
  * @param  array  $projects 
  * @param  int    $queryID 
  * @param  string $orderBy 
  * @param  object $pager 
  * @access public
  * @return array
  */
 public function getBySearch($productID, $projects, $queryID, $orderBy, $pager)
 {
     if ($queryID) {
         $query = $this->loadModel('search')->getQuery($queryID);
         if ($query) {
             $this->session->set('bugQuery', $query->sql);
             $this->session->set('bugForm', $query->form);
         } else {
             $this->session->set('bugQuery', ' 1 = 1');
         }
     } else {
         if ($this->session->bugQuery == false) {
             $this->session->set('bugQuery', ' 1 = 1');
         }
     }
     /* check the purview of projects.*/
     if (strpos($this->session->bugQuery, '`project`') === false) {
         $var = $this->session->bugQuery . 'AND `project`' . helper::dbIN(array_keys($projects));
         $this->session->set('bugQuery', "{$var}");
     }
     $bugQuery = str_replace("`product` = 'all'", '1', $this->session->bugQuery);
     // Search all product.
     $bugs = $this->dao->select('*')->from(TABLE_BUG)->where($bugQuery)->andWhere('deleted')->eq(0)->orderBy($orderBy)->page($pager)->fetchAll();
     return $bugs;
 }

 /**
  * Create not in part.
  * 
  * @param  string|array $ids   list string by ',' or an array
  * @access public
  * @return object the sql object.
  */
 public function notin($ids)
 {
     if ($this->inCondition and !$this->conditionIsTrue) {
         return $this;
     }
     $this->sql .= ' NOT ' . helper::dbIN($ids);
     return $this;
 }

 /**
  * Get bugs by search. 
  * 
  * @param  int    $productID 
  * @param  int    $queryID 
  * @param  string $orderBy 
  * @param  object $pager 
  * @access public
  * @return array
  */
 public function getBySearch($productID, $queryID, $orderBy, $pager = null, $branch = 0)
 {
     if ($queryID) {
         $query = $this->loadModel('search')->getQuery($queryID);
         if ($query) {
             $this->session->set('bugQuery', $query->sql);
             $this->session->set('bugForm', $query->form);
         } else {
             $this->session->set('bugQuery', ' 1 = 1');
         }
     } else {
         if ($this->session->bugQuery == false) {
             $this->session->set('bugQuery', ' 1 = 1');
         }
     }
     if (strpos($this->session->bugQuery, '`product`') === false) {
         $var = $this->session->bugQuery . ' AND `product` = ' . $productID;
         $this->session->set('bugQuery', "{$var}");
     }
     $allProduct = "`product` = 'all'";
     $bugQuery = $this->session->bugQuery;
     if (strpos($this->session->bugQuery, $allProduct) !== false) {
         $products = array_keys($this->loadModel('product')->getPrivProducts());
         $bugQuery = str_replace($allProduct, '1', $this->session->bugQuery);
         $bugQuery = $bugQuery . ' AND `product`' . helper::dbIN($products);
     }
     if ($branch) {
         $bugQuery .= " AND `branch` in('0','{$branch}')";
     }
     $bugs = $this->dao->select('*')->from(TABLE_BUG)->where($bugQuery)->andWhere('deleted')->eq(0)->orderBy($orderBy)->page($pager)->fetchAll();
     return $bugs;
 }

 /**
  * Get stories through search.
  * 
  * @access public
  * @param  int    $productID 
  * @param  int    $queryID 
  * @param  string $orderBy 
  * @param  object $pager 
  * @access public
  * @return array
  */
 public function getBySearch($productID, $queryID, $orderBy, $pager, $projectID = '')
 {
     if ($projectID != '') {
         $products = $this->loadModel('project')->getProducts($projectID);
     } else {
         $products = $this->loadModel('product')->getPairs();
     }
     $query = $queryID ? $this->loadModel('search')->getQuery($queryID) : '';
     /* Get the sql and form status from the query. */
     if ($query) {
         $this->session->set('storyQuery', $query->sql);
         $this->session->set('storyForm', $query->form);
     }
     if ($this->session->storyQuery == false) {
         $this->session->set('storyQuery', ' 1 = 1');
     }
     $allProduct = "`product` = 'all'";
     $storyQuery = $this->session->storyQuery;
     $queryProductID = $productID;
     if (strpos($this->session->storyQuery, $allProduct) !== false) {
         $storyQuery = str_replace($allProduct, '1', $this->session->storyQuery);
         $queryProductID = 'all';
     }
     $storyQuery = $storyQuery . ' AND `product`' . helper::dbIN(array_keys($products));
     $storyQuery = $this->loadModel('search')->replaceDynamic($storyQuery);
     return $this->getBySQL($queryProductID, $storyQuery, $orderBy, $pager);
 }

 /**
  * Browse cases.
  * 
  * @param  int    $productID 
  * @param  string $browseType 
  * @param  int    $param 
  * @param  string $orderBy 
  * @param  int    $recTotal 
  * @param  int    $recPerPage 
  * @param  int    $pageID 
  * @access public
  * @return void
  */
 public function browse($productID = 0, $browseType = 'all', $param = 0, $orderBy = 'id_desc', $recTotal = 0, $recPerPage = 20, $pageID = 1)
 {
     /* Set browseType, productID, moduleID and queryID. */
     $browseType = strtolower($browseType);
     $productID = $this->product->saveState($productID, $this->products);
     $moduleID = $browseType == 'bymodule' ? (int) $param : 0;
     $queryID = $browseType == 'bysearch' ? (int) $param : 0;
     /* Set menu, save session. */
     $this->testcase->setMenu($this->products, $productID);
     $this->session->set('caseList', $this->app->getURI(true));
     $this->session->set('productID', $productID);
     $this->session->set('moduleID', $moduleID);
     $this->session->set('browseType', $browseType);
     $this->session->set('orderBy', $orderBy);
     /* Load lang. */
     $this->app->loadLang('testtask');
     /* Load pager. */
     $this->app->loadClass('pager', $static = true);
     $pager = pager::init($recTotal, $recPerPage, $pageID);
     $sort = $this->loadModel('common')->appendOrder($orderBy);
     /* By module or all cases. */
     if ($browseType == 'bymodule' or $browseType == 'all') {
         $childModuleIds = $this->tree->getAllChildId($moduleID);
         $this->view->cases = $this->testcase->getModuleCases($productID, $childModuleIds, $sort, $pager);
     } elseif ($browseType == 'needconfirm') {
         $this->view->cases = $this->dao->select('t1.*, t2.title AS storyTitle')->from(TABLE_CASE)->alias('t1')->leftJoin(TABLE_STORY)->alias('t2')->on('t1.story = t2.id')->where("t2.status = 'active'")->andWhere('t1.deleted')->eq(0)->andWhere('t2.version > t1.storyVersion')->orderBy($sort)->page($pager)->fetchAll();
     } elseif ($browseType == 'bysearch') {
         if ($queryID) {
             $query = $this->loadModel('search')->getQuery($queryID);
             if ($query) {
                 $this->session->set('testcaseQuery', $query->sql);
                 $this->session->set('testcaseForm', $query->form);
             } else {
                 $this->session->set('testcaseQuery', ' 1 = 1');
             }
         } else {
             if ($this->session->testcaseQuery == false) {
                 $this->session->set('testcaseQuery', ' 1 = 1');
             }
         }
         $queryProductID = $productID;
         $allProduct = "`product` = 'all'";
         $caseQuery = '(' . $this->session->testcaseQuery;
         if (strpos($this->session->testcaseQuery, $allProduct) !== false) {
             $products = array_keys($this->loadModel('product')->getPrivProducts());
             $caseQuery = str_replace($allProduct, '1', $caseQuery);
             $caseQuery = $caseQuery . ' AND `product`' . helper::dbIN($products);
             $queryProductID = 'all';
         }
         $caseQuery .= ')';
         $this->view->cases = $this->dao->select('*')->from(TABLE_CASE)->where($caseQuery)->beginIF($queryProductID != 'all')->andWhere('product')->eq($productID)->fi()->andWhere('deleted')->eq(0)->orderBy($sort)->page($pager)->fetchAll();
     }
     /* save session .*/
     $this->loadModel('common')->saveQueryCondition($this->dao->get(), 'testcase', $browseType != 'bysearch' ? false : true);
     /* Build the search form. */
     $this->config->testcase->search['params']['product']['values'] = array($productID => $this->products[$productID], 'all' => $this->lang->testcase->allProduct);
     $this->config->testcase->search['params']['module']['values'] = $this->loadModel('tree')->getOptionMenu($productID, $viewType = 'case');
     $this->config->testcase->search['actionURL'] = $this->createLink('testcase', 'browse', "productID={$productID}&browseType=bySearch&queryID=myQueryID");
     $this->config->testcase->search['queryID'] = $queryID;
     $this->loadModel('search')->setSearchParams($this->config->testcase->search);
     /* Assign. */
     $this->view->title = $this->products[$productID] . $this->lang->colon . $this->lang->testcase->common;
     $this->view->position[] = html::a($this->createLink('testcase', 'browse', "productID={$productID}"), $this->products[$productID]);
     $this->view->position[] = $this->lang->testcase->common;
     $this->view->productID = $productID;
     $this->view->productName = $this->products[$productID];
     $this->view->moduleTree = $this->tree->getTreeMenu($productID, $viewType = 'case', $startModuleID = 0, array('treeModel', 'createCaseLink'));
     $this->view->moduleID = $moduleID;
     $this->view->pager = $pager;
     $this->view->users = $this->user->getPairs('noletter');
     $this->view->orderBy = $orderBy;
     $this->view->browseType = $browseType;
     $this->view->param = $param;
     $this->display();
 }

 /**
  * Browse cases of a test task.
  * 
  * @param  string $taskID 
  * @param  string $browseType  bymodule|all|assignedtome
  * @param  int    $param 
  * @param  int    $recTotal 
  * @param  int    $recPerPage 
  * @param  int    $pageID 
  * @access public
  * @return void
  */
 public function cases($taskID, $browseType = 'all', $param = 0, $orderBy = 'id_desc', $recTotal = 0, $recPerPage = 20, $pageID = 1)
 {
     /* Save the session. */
     $this->app->loadLang('testcase');
     $this->session->set('caseList', $this->app->getURI(true));
     /* Load pager. */
     $this->app->loadClass('pager', $static = true);
     $pager = pager::init($recTotal, $recPerPage, $pageID);
     /* Set the browseType and moduleID. */
     $browseType = strtolower($browseType);
     $moduleID = $browseType == 'bymodule' ? (int) $param : 0;
     $queryID = $browseType == 'bysearch' ? (int) $param : 0;
     /* Append id for secend sort. */
     $sort = $this->loadModel('common')->appendOrder($orderBy);
     /* Get task and product info, set menu. */
     $task = $this->testtask->getById($taskID);
     if (!$task) {
         die(js::error($this->lang->notFound) . js::locate('back'));
     }
     $productID = $task->product;
     $this->testtask->setMenu($this->products, $productID);
     if ($browseType == 'bymodule' or $browseType == 'all') {
         $modules = '';
         if ($moduleID) {
             $modules = $this->loadModel('tree')->getAllChildID($moduleID);
         }
         $this->view->runs = $this->testtask->getRuns($taskID, $modules, $sort, $pager);
     } elseif ($browseType == 'assignedtome') {
         $this->view->runs = $this->testtask->getUserRuns($taskID, $this->session->user->account, $sort, $pager);
     } elseif ($browseType == 'bysearch') {
         if ($queryID) {
             $query = $this->loadModel('search')->getQuery($queryID);
             if ($query) {
                 $this->session->set('testcaseQuery', $query->sql);
                 $this->session->set('testcaseForm', $query->form);
             } else {
                 $this->session->set('testcaseQuery', ' 1 = 1');
             }
         } else {
             if ($this->session->testcaseQuery == false) {
                 $this->session->set('testcaseQuery', ' 1 = 1');
             }
         }
         $queryProductID = $productID;
         $allProduct = "`product` = 'all'";
         $caseQuery = $this->session->testcaseQuery;
         if (strpos($this->session->testcaseQuery, $allProduct) !== false) {
             $products = array_keys($this->loadModel('product')->getPrivProducts());
             $caseQuery = str_replace($allProduct, '1', $this->session->testcaseQuery);
             $caseQuery = $caseQuery . ' AND `product`' . helper::dbIN(array_keys($products));
             $queryProductID = 'all';
         }
         $caseQuery = $this->loadModel('search')->replaceDynamic($caseQuery);
         $caseQuery = preg_replace('/`(\\w+)`/', 't2.`$1`', $caseQuery);
         $this->view->runs = $this->dao->select('t2.*,t1.*, t2.version as caseVersion')->from(TABLE_TESTRUN)->alias('t1')->leftJoin(TABLE_CASE)->alias('t2')->on('t1.case = t2.id')->where($caseQuery)->andWhere('t1.task')->eq($taskID)->orderBy(strpos($sort, 'assignedTo') !== false ? 't1.' . $sort : 't2.' . $sort)->page($pager)->fetchAll();
     }
     $this->loadModel('common')->saveQueryCondition($this->dao->get(), 'testcase', false);
     /* Save testcaseIDs session for get the pre and next testcase. */
     $testcaseIDs = '';
     foreach ($this->view->runs as $run) {
         $testcaseIDs .= ',' . $run->case;
     }
     $this->session->set('testcaseIDs', $testcaseIDs . ',');
     /* Build the search form. */
     $this->loadModel('testcase');
     $this->config->testcase->search['params']['product']['values'] = array($productID => $this->products[$productID], 'all' => $this->lang->testcase->allProduct);
     $this->config->testcase->search['params']['module']['values'] = $this->loadModel('tree')->getOptionMenu($productID, $viewType = 'case');
     $this->config->testcase->search['actionURL'] = inlink('cases', "taskID={$taskID}&browseType=bySearch&queryID=myQueryID");
     $this->loadModel('search')->setSearchParams($this->config->testcase->search);
     $this->view->title = $this->products[$productID] . $this->lang->colon . $this->lang->testtask->cases;
     $this->view->position[] = html::a($this->createLink('testtask', 'browse', "productID={$productID}"), $this->products[$productID]);
     $this->view->position[] = $this->lang->testtask->common;
     $this->view->position[] = $this->lang->testtask->cases;
     $this->view->productID = $productID;
     $this->view->productName = $this->products[$productID];
     $this->view->task = $task;
     $this->view->users = $this->loadModel('user')->getPairs('noclosed,nodeleted,qafirst');
     $this->view->moduleTree = $this->loadModel('tree')->getTreeMenu($productID, $viewType = 'case', $startModuleID = 0, array('treeModel', 'createTestTaskLink'), $extra = $taskID);
     $this->view->browseType = $browseType;
     $this->view->param = $param;
     $this->view->orderBy = $orderBy;
     $this->view->taskID = $taskID;
     $this->view->moduleID = $moduleID;
     $this->view->treeClass = $browseType == 'bymodule' ? '' : 'hidden';
     $this->view->pager = $pager;
     $this->display();
 }

 /**
  * 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}";
         /* Skip empty values. */
         if ($this->post->{$valueName} == false) {
             continue;
         }
         if ($this->post->{$valueName} == 'null') {
             $this->post->{$valueName} = '';
         }
         // Null is special, stands to empty.
         /* Set and or. */
         $andOr = strtoupper($this->post->{$andOrName});
         if ($andOr != 'AND' and $andOr != 'OR') {
             $andOr = 'AND';
         }
         $where .= " {$andOr} ";
         /* Set filed name. */
         $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") {
             $where .= ' LIKE ' . $this->dbh->quote("%{$value}%");
         } elseif ($operator == "notinclude") {
             $where .= ' NOT LIKE ' . $this->dbh->quote("%{$value}%");
         } elseif ($operator == 'belong') {
             if ($this->post->{$fieldName} == 'module') {
                 $allModules = $this->loadModel('tree')->getAllChildId($value);
                 $where .= helper::dbIN($allModules);
             } else {
                 $where .= ' = ' . $this->dbh->quote($value) . ' ';
             }
         } else {
             $where .= $operator . ' ' . $this->dbh->quote($value) . ' ';
         }
     }
     $where .= " )";
     /* Save to session. */
     $querySessionName = $this->post->module . 'Query';
     $formSessionName = $this->post->module . 'Form';
     $this->session->set($querySessionName, $where);
     $this->session->set($formSessionName, $_POST);
 }

 /**
  * Get stories through search.
  * 
  * @access public
  * @param  int    $productID 
  * @param  int    $queryID 
  * @param  string $orderBy 
  * @param  object $pager 
  * @param  string $projectID 
  * @access public
  * @return array
  */
 public function getBySearch($productID, $queryID, $orderBy, $pager = null, $projectID = '')
 {
     if ($projectID != '') {
         $products = $this->loadModel('project')->getProducts($projectID);
     } else {
         $products = $this->loadModel('product')->getPairs();
     }
     $query = $queryID ? $this->loadModel('search')->getQuery($queryID) : '';
     /* Get the sql and form status from the query. */
     if ($query) {
         $this->session->set('storyQuery', $query->sql);
         $this->session->set('storyForm', $query->form);
     }
     if ($this->session->storyQuery == false) {
         $this->session->set('storyQuery', ' 1 = 1');
     }
     $allProduct = "`product` = 'all'";
     $storyQuery = $this->session->storyQuery;
     $queryProductID = $productID;
     if (strpos($this->session->storyQuery, $allProduct) !== false) {
         $storyQuery = str_replace($allProduct, '1', $this->session->storyQuery);
         $queryProductID = 'all';
     }
     $storyQuery = $storyQuery . ' AND `product`' . helper::dbIN(array_keys($products));
     if ($projectID != '') {
         $branches = array(0 => 0);
         foreach ($products as $product) {
             $branches += $product->branches;
         }
         $storyQuery .= " AND `branch`" . helper::dbIN($branches);
         $storyQuery .= " AND `status` != 'draft'";
     }
     return $this->getBySQL($queryProductID, $storyQuery, $orderBy, $pager);
 }