* @package caselib * @version $Id: model.php 5114 2013-07-12 06:02:59Z chencongzhi520@gmail.com $ * @link https://www.zentao.net */ ?> loadModel('product')->getPairs(); if(!empty($products) and $this->session->product) $this->loadModel('qa')->setMenu($this->session->product); if(empty($products)) $this->loadModel('qa')->setMenu(); $this->lang->qa->menu->caselib['subModule'] .= ',testcase'; if(!isset($this->lang->qa->menu->testcase['exclude'])) $this->lang->qa->menu->testcase['exclude'] = ''; $this->lang->qa->menu->testcase['exclude'] .= ',testcase-view,testcase-edit,testcase-batchedit'; if($libraries) { $libName = ''; if(!isset($libraries[$libID])) { $lib = $this->getByID($libID); $libName = $lib ? $lib->name : ''; } $currentLibName = zget($libraries, $libID, $libName); setCookie("lastCaseLib", (string)$libID, $this->config->cookieLife, $this->config->webRoot, '', false, true); $dropMenuLink = helper::createLink('caselib', 'ajaxGetDropMenu', "objectID={$libID}&module=caselib&method=browse"); $output = "
"; $this->lang->switcherMenu = $output; } return true; } /** * 通过 id 获取用例库信息。 * Get caselib info by id. * * @param int $libID * @param bool $setImgSize * @access public * @return object|false */ public function getByID($libID, $setImgSize = false) { $lib = $this->dao->select('*')->from(TABLE_TESTSUITE)->where('id')->eq($libID)->fetch(); if(!$lib) return false; $lib = $this->loadModel('file')->replaceImgURL($lib, 'desc'); if($setImgSize) $lib->desc = $this->file->setImgSize($lib->desc); return $lib; } /** * 更新用例库。 * Update a caselib. * * @param object $lib * @access public * @return bool */ public function update($lib) { $oldLib = $this->dao->select('*')->from(TABLE_TESTSUITE)->where('id')->eq($lib->id)->fetch(); $this->lang->testsuite->name = $this->lang->caselib->name; $this->lang->testsuite->desc = $this->lang->caselib->desc; $this->dao->update(TABLE_TESTSUITE)->data($lib, 'uid') ->autoCheck() ->batchcheck($this->config->caselib->edit->requiredFields, 'notempty') ->checkFlow() ->where('id')->eq($lib->id) ->checkFlow() ->exec(); if(dao::isError()) return false; $this->loadModel('file')->updateObjectID($lib->uid, $lib->id, 'caselib'); $changes = common::createChanges($oldLib, $lib); if(!$changes) return true; $actionID = $this->loadModel('action')->create('caselib', $lib->id, 'edited'); $this->action->logHistory($actionID, $changes); return true; } /** * 删除用例库。 * Delete library. * * @param int $libID * @param string $table * @access public * @return bool */ public function delete($libID, $table = '') { $this->dao->update(TABLE_TESTSUITE)->set('deleted')->eq('1')->where('id')->eq($libID)->exec(); $this->loadModel('action')->create('caselib', $libID, 'deleted', '', actionModel::CAN_UNDELETED); return !dao::isError(); } /** * 获取用例库键对。 * Get libraries. * * @access public * @return array */ public function getLibraries() { return $this->dao->select('id, name')->from(TABLE_TESTSUITE)->where('product')->eq(0)->andWhere('deleted')->eq(0)->andWhere('type')->eq('library')->orderBy('order_desc, id_desc')->fetchPairs(); } /** * 获取用例库列表。 * Get library list. * * @param string $type * @param string $orderBy * @param object $pager * @access public * @return array */ public function getList($type = 'all', $orderBy = 'id_desc', $pager = null) { return $this->dao->select('*')->from(TABLE_TESTSUITE) ->where('product')->eq(0) ->andWhere('deleted')->eq(0) ->andWhere('type')->eq('library') ->beginIF($type == 'review')->andWhere("FIND_IN_SET('{$this->app->user->account}', `reviewers`)")->fi() ->orderBy($orderBy) ->page($pager) ->fetchAll('id', false); } /** * 获取用例库列表。 * Get library pairs. * * @param string $type * @param string $orderBy * @param object $pager * @access public * @return array */ public function getPairs($type = 'all', $orderBy = 'id_desc', $pager = null) { return $this->dao->select('id,name')->from(TABLE_TESTSUITE) ->where('product')->eq(0) ->andWhere('deleted')->eq(0) ->andWhere('type')->eq('library') ->beginIF($type == 'review')->andWhere("FIND_IN_SET('{$this->app->user->account}', `reviewers`)")->fi() ->orderBy($orderBy) ->page($pager) ->fetchPairs(); } /** * 创建用例库，插入一个用例库对象到数据库。 * Create a lib case, insert a lib object into database. * * @param object $lib * @access public * @return int|false */ public function create($lib) { $this->lang->testsuite->name = $this->lang->caselib->name; $this->lang->testsuite->desc = $this->lang->caselib->desc; $this->dao->insert(TABLE_TESTSUITE)->data($lib) ->batchcheck($this->config->caselib->create->requiredFields, 'notempty') ->check('name', 'unique', "deleted = '0'") ->checkFlow() ->exec(); if(dao::isError()) return false; $libID = $this->dao->lastInsertID(); $this->loadModel('file')->updateObjectID($this->post->uid, $libID, 'caselib'); $this->loadModel('action')->create('caselib', $libID, 'opened'); return $libID; } /** * 获取用例库的用例。 * Get lib cases. * * @param int $libID * @param string $browseType * @param int $queryID * @param int $moduleID * @param string $sort * @param object $pager * @param string $from * @access public * @return array */ public function getLibCases($libID, $browseType, $queryID = 0, $moduleID = 0, $sort = 'id_desc', $pager = null, $from = 'qa') { $browseType = $browseType == 'bymodule' && $this->session->libBrowseType && $this->session->libBrowseType != 'bysearch' ? $this->session->libBrowseType : $browseType; if(!in_array($browseType, array('bymodule', 'all', 'wait', 'review', 'bysearch'))) return array(); $moduleIdList = $moduleID ? $this->loadModel('tree')->getAllChildId($moduleID) : '0'; if($browseType == 'bysearch') { if($queryID) { $query = $this->loadModel('search')->getQuery($queryID); $this->session->set('caselibQuery', ' 1 = 1'); if($query) { $this->session->set('caselibQuery', $query->sql); $this->session->set('caselibForm', $query->form); } } else { if($this->session->caselibQuery == false) $this->session->set('caselibQuery', ' 1 = 1'); } $queryLibID = $libID; $allLib = "`lib` = 'all'"; $caseQuery = '(' . $this->session->caselibQuery; if(strpos($this->session->caselibQuery, $allLib) !== false) { $caseQuery = str_replace($allLib, '1', $caseQuery); $queryLibID = 'all'; } $caseQuery .= ')'; $stmt = $this->dao->select('*')->from(TABLE_CASE) ->where('product')->eq(0) ->beginIF($libID)->andWhere('lib')->eq($libID)->fi() ->andWhere('deleted')->eq('0') ->andWhere($caseQuery) ->beginIF($queryLibID != 'all')->andWhere('lib')->eq($libID)->fi() ->beginIF($this->app->tab != 'qa' && $from != 'doc')->andWhere('project')->eq($this->session->project)->fi(); } else { $stmt = $this->dao->select('*')->from(TABLE_CASE) ->where('product')->eq(0) ->beginIF($libID)->andWhere('lib')->eq($libID)->fi() ->andWhere('deleted')->eq('0') ->beginIF($moduleIdList)->andWhere('module')->in($moduleIdList)->fi() ->beginIF($browseType == 'wait')->andWhere('status')->eq($browseType)->fi() ->beginIF($browseType == 'review')->andWhere("FIND_IN_SET('{$this->app->user->account}', `reviewers`)")->fi(); } return $stmt->orderBy($sort)->page($pager)->fetchAll('id'); } /** * 获取用例库 1.5 级下拉的链接。 * Get lib link. * * @param string $module * @param string $method * @access public * @return string */ public function getLibLink($module, $method) { if($module == 'tree') return helper::createLink($module, $method, "libID=%s&type=caselib¤tModuleID=0"); if($module == 'caselib' && $method != 'create') return helper::createLink($module, $method, "libID=%s"); return helper::createLink('caselib', 'browse', "libID=%s"); } /** * 创建导入的用例。 * Create from import. * * @param int $libID * @access public * @return bool */ public function createFromImport($libID) { $data = fixer::input('post')->get(); /* 获取表单的用例数据，并且检查必填。*/ /* Get the form data and check required. */ $cases = $this->caselibTao->initImportedCase($data); if(dao::isError()) return false; $oldCaseIdList = zget($data, 'id', array()); $forceNotReview = $this->loadModel('testcase')->forceNotReview(); $oldCases = $this->testcase->getByList($oldCaseIdList); $oldSteps = $this->testcase->fetchStepsByList($oldCaseIdList); $this->dao->begin(); foreach($cases as $key => $caseData) { $key = (int)$key; $caseData->lib = $libID; if(!empty($data->id[$key]) && !$this->post->insert) { $caseID = $data->id[$key]; if(!isset($oldCases[$caseID])) continue; $oldCase = $oldCases[$caseID]; if(!isset($oldCase->steps)) $oldCase->steps = zget($oldSteps, $caseID, array()); $this->caselibTao->updateImportedCase($key, $caseData, $data, $forceNotReview, $oldCase); } else { $caseData->version = 1; $caseData->openedBy = $this->app->user->account; $caseData->openedDate = helper::now(); $caseData->status = $forceNotReview ? 'normal' : 'wait'; $this->testcase->create($caseData); } } $this->dao->commit(); if(dao::isError()) return false; if($data->isEndPage) { if($this->session->fileImport) @unlink($this->session->fileImport); unset($_SESSION['fileImport']); } return true; } /** * 判断操作是否可以点击。 * Judge an action is clickable or not. * * @param object $object * @param string $action * @access public * @return bool */ public function isClickable($object, $action) { $action = strtolower($action); if($action == 'createcase') return !empty($object->lib) && empty($object->product); return common::hasPriv('caselib', $action); } /** * 获取导出的用例。 * Get cases to export. * * @param string $exportType * @param string $orderBy * @param int $limit * @access public * @return array */ public function getCasesToExport($exportType, $orderBy, $limit) { $queryCondition = $this->session->testcaseQueryCondition; if($this->session->testcaseOnlyCondition) { return $this->dao->select('*')->from(TABLE_CASE)->where($queryCondition) ->beginIF($exportType == 'selected')->andWhere('id')->in($this->cookie->checkedItem)->fi() ->orderBy($orderBy) ->beginIF($limit)->limit($limit)->fi() ->fetchAll('id'); } $cases = array(); $orderBy = " ORDER BY " . str_replace(array('|', '^A', '_'), ' ', $orderBy); $stmt = $this->dao->query($queryCondition . $orderBy . ($limit ? ' LIMIT ' . $limit : '')); while($row = $stmt->fetch()) { $caseID = $row->id; if($exportType == 'selected' && strpos(",{$this->cookie->checkedItem},", ",$caseID,") === false) continue; $cases[$caseID] = $row; } return $cases; } /** * 构建查询表单。 * Build search form. * * @param int $libID * @param array $libraries * @param int $queryID * @param string $actionURL * @access public * @return array */ public function buildSearchConfig($libID) { $this->loadModel('testcase'); /* Set lib for search. */ $this->config->testcase->search['params']['module']['values'] = $this->loadModel('tree')->getOptionMenu($libID, 'caselib'); /* Unset fields for search. */ if(!$this->config->testcase->needReview) unset($this->config->testcase->search['params']['status']['values']['wait']); unset($this->config->testcase->search['fields']['lib']); unset($this->config->testcase->search['params']['lib']); unset($this->config->testcase->search['fields']['product']); unset($this->config->testcase->search['params']['product']); unset($this->config->testcase->search['fields']['branch']); unset($this->config->testcase->search['params']['branch']); unset($this->config->testcase->search['fields']['scene']); unset($this->config->testcase->search['params']['scene']); unset($this->config->testcase->search['fields']['lastRunner']); unset($this->config->testcase->search['params']['lastRunner']); unset($this->config->testcase->search['fields']['lastRunResult']); unset($this->config->testcase->search['params']['lastRunResult']); unset($this->config->testcase->search['fields']['lastRunDate']); unset($this->config->testcase->search['params']['lastRunDate']); /* Set search params. */ $this->config->testcase->search['module'] = 'caselib'; $_SESSION['searchParams']['module'] = 'caselib'; $searchConfig = $this->loadModel('search')->processBuildinFields('testcase', $this->config->testcase->search); $searchConfig['params'] = $this->search->setDefaultParams('caselib', $searchConfig['fields'], $searchConfig['params']); return $searchConfig; } }