430 lines
16 KiB
PHP
430 lines
16 KiB
PHP
<?php
|
|
/**
|
|
* The model file of test suite module of ZenTaoPMS.
|
|
*
|
|
* @copyright Copyright 2009-2015 禅道软件(青岛)有限公司(ZenTao Software (Qingdao) Co., Ltd. www.cnezsoft.com)
|
|
* @license ZPL(http://zpl.pub/page/zplv12.html) or AGPL(https://www.gnu.org/licenses/agpl-3.0.en.html)
|
|
* @author Chunsheng Wang <chunsheng@cnezsoft.com>
|
|
* @package testsuite
|
|
* @version $Id: model.php 5114 2013-07-12 06:02:59Z chencongzhi520@gmail.com $
|
|
* @link http://www.zentao.net
|
|
*/
|
|
?>
|
|
<?php
|
|
class testsuiteModel extends model
|
|
{
|
|
/**
|
|
* Build select string.
|
|
*
|
|
* @param array $products
|
|
* @param int $productID
|
|
* @param string $currentModule
|
|
* @param string $currentMethod
|
|
* @param string $extra
|
|
* @access public
|
|
* @return string
|
|
*/
|
|
public function select($products, $productID, $currentModule, $currentMethod, $extra = '')
|
|
{
|
|
if(!$productID)
|
|
{
|
|
unset($this->lang->product->setMenu->branch);
|
|
return;
|
|
}
|
|
|
|
setcookie("lastProduct", $productID, $this->config->cookieLife, $this->config->webRoot, '', $this->config->cookieSecure, true);
|
|
$currentProduct = $this->product->getById($productID);
|
|
|
|
$dropMenuLink = helper::createLink('product', 'ajaxGetDropMenu', "objectID=$productID&module=$currentModule&method=$currentMethod&extra=$extra");
|
|
$output = "<div class='btn-group angle-btn'><div class='btn-group'><button data-toggle='dropdown' type='button' class='btn btn-limit' id='currentItem' ><span class='text'>{$currentProduct->name}</span> <span class='caret'></span></button><div id='dropMenu' class='dropdown-menu search-list' data-ride='searchList' data-url='$dropMenuLink'>";
|
|
$output .= '<div class="input-control search-box has-icon-left has-icon-right search-example"><input type="search" class="form-control search-input" /><label class="input-control-icon-left search-icon"><i class="icon icon-search"></i></label><a class="input-control-icon-right search-clear-btn"><i class="icon icon-close icon-sm"></i></a></div>';
|
|
$output .= "</div></div>";
|
|
if($currentProduct->type != 'normal')
|
|
{
|
|
$this->app->loadLang('branch');
|
|
$branchName = $this->lang->branch->main;
|
|
$output .= "<div class='btn-group'><button id='currentBranch' type='button' class='btn btn-limit'>{$branchName} </button></div></div>";
|
|
}
|
|
$output .= '</div>';
|
|
|
|
return $output;
|
|
}
|
|
|
|
/**
|
|
* Create a test suite.
|
|
*
|
|
* @param int $productID
|
|
* @access public
|
|
* @return bool|int
|
|
*/
|
|
public function create($productID)
|
|
{
|
|
$suite = fixer::input('post')
|
|
->trim('name')
|
|
->stripTags($this->config->testsuite->editor->create['id'], $this->config->allowedTags)
|
|
->setIF($this->lang->navGroup->testsuite != 'qa', 'project', $this->session->project)
|
|
->add('product', (int)$productID)
|
|
->add('addedBy', $this->app->user->account)
|
|
->add('addedDate', helper::now())
|
|
->remove('uid')
|
|
->get();
|
|
$suite = $this->loadModel('file')->processImgURL($suite, $this->config->testsuite->editor->create['id'], $this->post->uid);
|
|
$this->dao->insert(TABLE_TESTSUITE)->data($suite)
|
|
->batchcheck($this->config->testsuite->create->requiredFields, 'notempty')
|
|
->checkFlow()
|
|
->exec();
|
|
if(!dao::isError())
|
|
{
|
|
$suiteID = $this->dao->lastInsertID();
|
|
$this->file->updateObjectID($this->post->uid, $suiteID, 'testsuite');
|
|
return $suiteID;
|
|
}
|
|
return false;
|
|
}
|
|
|
|
/**
|
|
* Get test suites of a product.
|
|
*
|
|
* @param int $productID
|
|
* @param string $orderBy
|
|
* @param object $pager
|
|
* @param string $param
|
|
* @access public
|
|
* @return array
|
|
*/
|
|
public function getSuites($productID, $orderBy = 'id_desc', $pager = null, $param = '')
|
|
{
|
|
return $this->dao->select("*")->from(TABLE_TESTSUITE)
|
|
->where('product')->eq((int)$productID)
|
|
->beginIF($this->lang->navGroup->testsuite != 'qa')->andWhere('project')->eq($this->session->project)->fi()
|
|
->andWhere('deleted')->eq(0)
|
|
->beginIF(strpos($param, 'all') === false)->andWhere("(`type` = 'public' OR (`type` = 'private' and addedBy = '{$this->app->user->account}'))")->fi()
|
|
->beginIF(strpos($param, 'review') !== false)->andWhere("FIND_IN_SET('{$this->app->user->account}', `reviewers`)")->fi()
|
|
->orderBy($orderBy)
|
|
->page($pager)
|
|
->fetchAll('id');
|
|
}
|
|
|
|
/**
|
|
* Get test suites pairs of a product.
|
|
*
|
|
* @param int $productID
|
|
* @access public
|
|
* @return array
|
|
*/
|
|
public function getSuitePairs($productID)
|
|
{
|
|
return $this->dao->select("id, name")->from(TABLE_TESTSUITE)
|
|
->where('product')->eq((int)$productID)
|
|
->beginIF($this->lang->navGroup->testsuite != 'qa')->andWhere('project')->eq($this->session->project)->fi()
|
|
->andWhere('deleted')->eq(0)
|
|
->andWhere("(`type` = 'public' OR (`type` = 'private' and addedBy = '{$this->app->user->account}'))")
|
|
->orderBy('id_desc')
|
|
->fetchPairs();
|
|
}
|
|
|
|
/**
|
|
* Get unit suite.
|
|
*
|
|
* @param int $productID
|
|
* @param string $orderBy
|
|
* @access public
|
|
* @return array
|
|
*/
|
|
public function getUnitSuites($productID, $orderBy = 'id_desc')
|
|
{
|
|
return $this->dao->select("*")->from(TABLE_TESTSUITE)
|
|
->where('product')->eq((int)$productID)
|
|
->andWhere('deleted')->eq(0)
|
|
->andWhere('type')->eq('unit')
|
|
->orderBy($orderBy)
|
|
->fetchAll('id');
|
|
}
|
|
|
|
/**
|
|
* Get test suite info by id.
|
|
*
|
|
* @param int $suiteID
|
|
* @param bool $setImgSize
|
|
* @access public
|
|
* @return object
|
|
*/
|
|
public function getById($suiteID, $setImgSize = false)
|
|
{
|
|
$suite = $this->dao->select('*')->from(TABLE_TESTSUITE)->where('id')->eq((int)$suiteID)->fetch();
|
|
$suite = $this->loadModel('file')->replaceImgURL($suite, 'desc');
|
|
if($setImgSize) $suite->desc = $this->file->setImgSize($suite->desc);
|
|
return $suite;
|
|
}
|
|
|
|
/**
|
|
* Update a test suite.
|
|
*
|
|
* @param int $suiteID
|
|
* @access public
|
|
* @return bool|array
|
|
*/
|
|
public function update($suiteID)
|
|
{
|
|
$oldSuite = $this->dao->select("*")->from(TABLE_TESTSUITE)->where('id')->eq((int)$suiteID)->fetch();
|
|
$suite = fixer::input('post')
|
|
->stripTags($this->config->testsuite->editor->edit['id'], $this->config->allowedTags)
|
|
->add('id', $suiteID)
|
|
->add('lastEditedBy', $this->app->user->account)
|
|
->add('lastEditedDate', helper::now())
|
|
->remove('uid')
|
|
->get();
|
|
$suite = $this->loadModel('file')->processImgURL($suite, $this->config->testsuite->editor->edit['id'], $this->post->uid);
|
|
$this->dao->update(TABLE_TESTSUITE)->data($suite)
|
|
->autoCheck()
|
|
->batchcheck($this->config->testsuite->edit->requiredFields, 'notempty')
|
|
->checkFlow()
|
|
->where('id')->eq($suiteID)
|
|
->exec();
|
|
if(!dao::isError())
|
|
{
|
|
$this->file->updateObjectID($this->post->uid, $suiteID, 'testsuite');
|
|
return common::createChanges($oldSuite, $suite);
|
|
}
|
|
return false;
|
|
}
|
|
|
|
/**
|
|
* Link cases.
|
|
*
|
|
* @param int $suiteID
|
|
* @access public
|
|
* @return void
|
|
*/
|
|
public function linkCase($suiteID)
|
|
{
|
|
if($this->post->cases == false) return;
|
|
$postData = fixer::input('post')->get();
|
|
foreach($postData->cases as $caseID)
|
|
{
|
|
$row = new stdclass();
|
|
$row->suite = $suiteID;
|
|
$row->case = $caseID;
|
|
$row->version = $postData->versions[$caseID];
|
|
$this->dao->replace(TABLE_SUITECASE)->data($row)->exec();
|
|
}
|
|
}
|
|
|
|
/**
|
|
* Get linked cases for suite.
|
|
*
|
|
* @param int $suiteID
|
|
* @param string $orderBy
|
|
* @param object $pager
|
|
* @param bool $append
|
|
* @access public
|
|
* @return array
|
|
*/
|
|
public function getLinkedCases($suiteID, $orderBy = 'id_desc', $pager = null, $append = true)
|
|
{
|
|
$suite = $this->getById($suiteID);
|
|
$cases = $this->dao->select('t1.*,t2.version as caseVersion')->from(TABLE_CASE)->alias('t1')
|
|
->leftJoin(TABLE_SUITECASE)->alias('t2')->on('t1.id=t2.case')
|
|
->where('t2.suite')->eq($suiteID)
|
|
->beginIF($this->lang->navGroup->testsuite != 'qa')->andWhere('t1.project')->eq($this->session->project)->fi()
|
|
->andWhere('t1.product')->eq($suite->product)
|
|
->andWhere('t1.product')->eq($suite->product)
|
|
->andWhere('t1.deleted')->eq(0)
|
|
->orderBy($orderBy)
|
|
->page($pager)
|
|
->fetchAll('id');
|
|
if(!$append) return $cases;
|
|
|
|
$this->loadModel('common')->saveQueryCondition($this->dao->get(), 'testcase', false);
|
|
return $this->loadModel('testcase')->appendData($cases);
|
|
}
|
|
|
|
/**
|
|
* Get linked cases pairs of suite.
|
|
*
|
|
* @param int $suiteID
|
|
* @access public
|
|
* @return array
|
|
*/
|
|
public function getLinkedCasePairs($suiteID)
|
|
{
|
|
$suite = $this->getById($suiteID);
|
|
return $this->dao->select('t1.id, t1.title')->from(TABLE_CASE)->alias('t1')
|
|
->leftJoin(TABLE_SUITECASE)->alias('t2')->on('t1.id=t2.case')
|
|
->where('t2.suite')->eq($suiteID)
|
|
->beginIF($this->lang->navGroup->testsuite != 'qa')->andWhere('t1.project')->eq($this->session->project)->fi()
|
|
->andWhere('t1.product')->eq($suite->product)
|
|
->andWhere('t1.product')->eq($suite->product)
|
|
->andWhere('t1.deleted')->eq(0)
|
|
->orderBy('id_desc')
|
|
->fetchPairs('id');
|
|
}
|
|
|
|
/**
|
|
* Get unlinked cases for suite.
|
|
*
|
|
* @param object $suite
|
|
* @param int $param
|
|
* @param object $pager
|
|
* @access public
|
|
* @return array
|
|
*/
|
|
public function getUnlinkedCases($suite, $param = 0, $pager = null)
|
|
{
|
|
if($this->session->testsuiteQuery == false) $this->session->set('testsuiteQuery', ' 1 = 1');
|
|
$queryID = (int)$param;
|
|
if($queryID)
|
|
{
|
|
$query = $this->loadModel('search')->getQuery($queryID);
|
|
if($query)
|
|
{
|
|
$this->session->set('testsuiteQuery', $query->sql);
|
|
$this->session->set('testsuiteForm', $query->form);
|
|
}
|
|
}
|
|
|
|
$query = $this->session->testsuiteQuery;
|
|
$allProduct = "`product` = 'all'";
|
|
if(strpos($query, '`product` =') === false) $query .= " AND `product` = {$suite->product}";
|
|
if(strpos($query, $allProduct) !== false) $query = str_replace($allProduct, '1', $query);
|
|
|
|
$linkedCases = $this->getLinkedCases($suite->id, 'id_desc', null, $append = false);
|
|
$cases = $this->dao->select('*')->from(TABLE_CASE)->where($query)
|
|
->andWhere('id')->notIN(array_keys($linkedCases))
|
|
->beginIF($this->lang->navGroup->testsuite != 'qa')->andWhere('project')->eq($this->session->project)->fi()
|
|
->andWhere('deleted')->eq(0)
|
|
->orderBy('id desc')
|
|
->page($pager)
|
|
->fetchAll();
|
|
return $cases;
|
|
}
|
|
|
|
/**
|
|
* Delete suite and library.
|
|
*
|
|
* @param int $suiteID
|
|
* @param string $table
|
|
* @access public
|
|
* @return bool
|
|
*/
|
|
public function delete($suiteID, $table = '')
|
|
{
|
|
parent::delete(TABLE_TESTSUITE, $suiteID);
|
|
$this->dao->delete()->from(TABLE_SUITECASE)->where('suite')->eq($suiteID)->exec();
|
|
return !dao::isError();
|
|
}
|
|
|
|
/**
|
|
* Get can import cases.
|
|
*
|
|
* @param int $productID
|
|
* @param int $libID
|
|
* @param int $branch
|
|
* @param string $orderBy
|
|
* @param object $pager
|
|
* @access public
|
|
* @return array
|
|
*/
|
|
public function getCanImportCases($productID, $libID, $branch, $orderBy = 'id_desc', $pager = null, $browseType = '', $queryID = 0)
|
|
{
|
|
$query = '';
|
|
if($browseType == 'bysearch')
|
|
{
|
|
if($queryID)
|
|
{
|
|
$this->session->set('testsuiteQuery', ' 1 = 1');
|
|
$query = $this->loadModel('search')->getQuery($queryID);
|
|
if($query)
|
|
{
|
|
$this->session->set('testsuiteQuery', $query->sql);
|
|
$this->session->set('testsuiteForm', $query->form);
|
|
}
|
|
}
|
|
else
|
|
{
|
|
if($this->session->testsuiteQuery == false) $this->session->set('testsuiteQuery', ' 1 = 1');
|
|
}
|
|
|
|
$query = $this->session->testsuiteQuery;
|
|
$allLib = "`lib` = 'all'";
|
|
$withAllLib = strpos($query, $allLib) !== false;
|
|
if($withAllLib) $query = str_replace($allLib, 1, $query);
|
|
if(!$withAllLib) $query .= " AND `lib` = '$libID'";
|
|
}
|
|
|
|
|
|
$this->loadModel('branch');
|
|
$product = $this->loadModel('product')->getById($productID);
|
|
$branches = $product->type != 'normal' ? array(BRANCH_MAIN => $this->lang->branch->main) + $this->branch->getPairs($productID, 'active') : array(0);
|
|
$canImport = array();
|
|
foreach($branches as $branchID => $branchName) $canImport += $this->getCanImportModules($productID, $libID, $branchID);
|
|
|
|
return $this->dao->select('*')->from(TABLE_CASE)->where('deleted')->eq(0)
|
|
->beginIF($browseType != 'bysearch')->andWhere('lib')->eq($libID)->fi()
|
|
->beginIF($browseType == 'bysearch')->andWhere($query)->fi()
|
|
->andWhere('id')->in(array_keys($canImport))
|
|
->andWhere('product')->eq(0)
|
|
->orderBy($orderBy)
|
|
->page($pager)
|
|
->fetchAll('id');
|
|
}
|
|
|
|
/**
|
|
* Get imported case modules.
|
|
*
|
|
* @param int $productID
|
|
* @param int $libID
|
|
* @param int $branch
|
|
* @access public
|
|
* @return array
|
|
*/
|
|
public function getCanImportModules($productID, $libID, $branch)
|
|
{
|
|
$importedModules = $this->dao->select('fromCaseID,module')->from(TABLE_CASE)
|
|
->where('product')->eq($productID)
|
|
->andWhere('lib')->eq($libID)
|
|
->andWhere('branch')->eq($branch)
|
|
->andWhere('fromCaseID')->ne('')
|
|
->andWhere('deleted')->eq(0)
|
|
->fetchGroup('fromCaseID', 'module');
|
|
foreach($importedModules as $fromCaseID => $modules) $importedModules[$fromCaseID] = array_combine(array_keys($modules), array_keys($modules));
|
|
|
|
$libCases = $this->loadModel('caselib')->getLibCases($libID, 'all');
|
|
|
|
$modules = $this->loadModel('tree')->getOptionMenu($productID, 'case', 0, $branch);
|
|
|
|
$canImportModules = array();
|
|
foreach($libCases as $caseID => $case)
|
|
{
|
|
$caseModules = !empty($importedModules[$caseID]) ? $importedModules[$caseID] : array();
|
|
$canImportModules[$caseID] = array_diff_key($modules, $caseModules);
|
|
if(!empty($canImportModules[$caseID])) $canImportModules[$caseID]['ditto'] = $this->lang->testcase->ditto;
|
|
if(empty($canImportModules[$caseID])) unset($canImportModules[$caseID]);
|
|
}
|
|
|
|
return $canImportModules;
|
|
}
|
|
|
|
/**
|
|
* Build testsuite menu.
|
|
*
|
|
* @param object $suite
|
|
* @param string $type
|
|
* @access public
|
|
* @return string
|
|
*/
|
|
public function buildOperateMenu($suite, $type = 'view')
|
|
{
|
|
$menu = '';
|
|
$params = "suiteID=$suite->id";
|
|
|
|
if($type == 'view') $menu .= $this->buildFlowMenu('testsuite', $suite, $type, 'direct');
|
|
|
|
$menu .= $this->buildMenu('testsuite', 'linkCase', $params, $suite, $type, 'link', '', '', '', '', $this->lang->testsuite->linkCase);
|
|
$menu .= $this->buildMenu('testsuite', 'edit', $params, $suite, $type);
|
|
$menu .= $this->buildMenu('testsuite', 'delete', $params, $suite, $type, 'trash', 'hiddenwin');
|
|
|
|
return $menu;
|
|
}
|
|
}
|