* @package doc * @version $Id: model.php 881 2010-06-22 06:50:32Z chencongzhi520 $ * @link https://www.zentao.net */ class docModel extends model { /** * @var actionModel */ public $action; // api doc type const DOC_TYPE_API = 'api'; const DOC_TYPE_REST = 'restapi'; /** * Adjust the action clickable. * * @param object $story * @param string $action * @access public * @return bool */ public static function isClickable(object $doc, string $action): bool { global $app; $action = strtolower($action); if(!empty($doc->frozen) && in_array($action, array('edit', 'delete'))) return false; if($action == 'movedoc') return $doc->addedBy == $app->user->account; return true; } /** * Get objectID by Lib. * * @param object $lib * @param string $libType * @access public * @return int */ public function getObjectIDByLib($lib, $libType = '') { if(empty($lib)) return 0; if(empty($libType)) $libType = $lib->type; $objectID = ($libType == 'custom' || $libType == 'mine') ? $lib->parent : zget($lib, $libType, 0); return (int)$objectID; } /** * 通过ID获取文档库信息。 * Get library by id. * * @param int $libID * @access public * @return object|false */ public function getLibByID(int $libID): object|bool { if(common::isTutorialMode()) return $this->loadModel('tutorial')->getDocLib(); return $this->dao->findByID($libID)->from(TABLE_DOCLIB)->fetch(); } /** * 通过ID获取空间类型 * Get space type by id. * * @param int|string $spaceID * @access public * @return string */ public function getSpaceType(int|string $spaceID): string { if(is_string($spaceID) && strpos($spaceID, '.') !== false) return explode('.', $spaceID)[0]; return $this->dao->findByID((int)$spaceID)->from(TABLE_DOCLIB)->fetch('type'); } /** * 获取api文档库。 * Get api libraries. * * @param int $appendLib * @param string $objectType nolink|product|project * @param int $objectID * @return array */ public function getApiLibs(int $appendLib = 0, string $objectType = '', int $objectID = 0): array { $libs = $this->dao->select('*')->from(TABLE_DOCLIB) ->where('deleted')->eq(0) ->andWhere('type')->eq('api') ->beginIF(!empty($objectType) && $objectID > 0 && $objectType != 'nolink')->andWhere($objectType)->eq($objectID)->fi() ->beginIF($objectType == 'nolink') ->andWhere('product')->eq(0) ->andWhere('project')->eq(0) ->andWhere('execution')->eq(0) ->fi() ->beginIF(!empty($appendLib))->orWhere('id')->eq($appendLib)->fi() ->orderBy('order_asc, id_asc') ->fetchAll('id', false); return array_filter($libs, array($this, 'checkPrivLib')); } /** * 获取文档库。 * Get libraries. * * @param string $type all|includeDeleted|hasApi|product|project|execution|custom|mine * @param string $extra withObject|notdoc * @param int|string $appendLibs * @param int $objectID * @param string $excludeType product|project|execution|custom|mine * @access public * @return array */ public function getLibs(string $type = '', string $extra = '', int|string $appendLibs = '', int $objectID = 0, string $excludeType = ''): array { /* 如果当前在模板中，则不过滤项目和执行库。 */ if(in_array($type, array('project', 'execution')) && $objectID) { $object = $this->loadModel('project')->fetchByID((int)$objectID); if($object->isTpl) dao::$filterTpl = 'never'; } $projects = $this->loadModel('project')->getPairsByProgram(0, 'all', false, 'order_asc'); $products = $this->loadModel('product')->getPairs(); $executions = $this->loadModel('execution')->getPairs(0, 'all', 'multiple,leaf'); $waterfalls = array(); if(empty($objectID) && $type == 'execution') { $waterfalls = $this->dao->select('t1.id,t2.name')->from(TABLE_EXECUTION)->alias('t1') ->leftJoin(TABLE_PROJECT)->alias('t2')->on('t1.project=t2.id') ->where('t1.type')->eq('stage') ->andWhere('t2.type')->eq('project') ->andWhere('t2.model')->eq('waterfall') ->andWhere('t1.deleted')->eq('0') ->andWhere('t2.deleted')->eq('0') ->fetchPairs('id', 'name'); } $libPairs = $this->getLibPairs($type, $extra, $objectID, $excludeType, $products, $projects, $executions, $waterfalls); if(!empty($appendLibs)) { $stmt = $this->dao->select('*')->from(TABLE_DOCLIB)->where('id')->in($appendLibs)->orderBy("`order`_asc, id_asc")->query(); while($lib = $stmt->fetch()) { if($lib->type == 'custom' && $lib->parent == 0) continue; if(!isset($libPairs[$lib->id]) && $this->checkPrivLib($lib, $extra)) $libPairs[$lib->id] = $lib->name; } } return $libPairs; } /** * 获取文档库键值对。 * Get doc liberary pairs. * * @param string $type all|includeDeleted|hasApi|product|project|execution|custom|mine * @param string $extra withObject|notdoc * @param int $objectID * @param string $excludeType product|project|execution|custom|mine * @param array $products * @param array $projects * @param array $executions * @param array $waterfalls * @access public * @return array */ public function getLibPairs(string $type, string $extra = '', int $objectID = 0, string $excludeType = '', array $products = array(), array $projects = array(), array $executions = array(), array $waterfalls = array()): array { if(in_array($type, array('all', 'includeDeleted', 'hasApi'))) { $stmt = $this->dao->select('*')->from(TABLE_DOCLIB) ->where('vision')->eq($this->config->vision) ->beginIF($type == 'all')->andWhere('deleted')->eq(0)->fi() ->beginIF($type != 'hasApi')->andWhere('type')->ne('api')->fi() ->beginIF($excludeType)->andWhere('type')->notin($excludeType)->fi() ->orderBy('`order`_asc') ->query(); } else { $stmt = $this->dao->select('*')->from(TABLE_DOCLIB) ->where('deleted')->eq(0) ->beginIF($type != 'product' or $this->config->vision != 'or')->andWhere('vision')->eq($this->config->vision)->fi() ->beginIF($type)->andWhere('type')->eq($type)->fi() ->beginIF(!$type)->andWhere('type')->ne('api')->fi() ->beginIF($objectID && strpos(',product,project,execution,', ",$type,") !== false)->andWhere($type)->eq($objectID)->fi() ->beginIF(($type == 'custom' || $type == 'mine') && !$objectID)->andWhere('parent')->ne(0)->fi() ->beginIF(($type == 'custom' || $type == 'mine') && $objectID)->andWhere('parent')->eq($objectID)->fi() ->orderBy('`order`_asc') ->query(); } $libPairs = array(); while($lib = $stmt->fetch()) { if($lib->product != 0 && !isset($products[$lib->product])) continue; if($lib->execution != 0 && !isset($executions[$lib->execution])) continue; if($lib->project != 0 && !isset($projects[$lib->project]) && $lib->type == 'project') continue; if($this->checkPrivLib($lib, $extra)) { if(strpos($extra, 'withObject') !== false) { if($lib->product != 0) $lib->name = zget($products, $lib->product, '') . ' / ' . $lib->name; if($lib->execution != 0) { $lib->name = zget($executions, $lib->execution, '') . ' / ' . $lib->name; $lib->name = ltrim($lib->name, '/'); if(!empty($waterfalls[$lib->execution])) $lib->name = $waterfalls[$lib->execution] . ' / ' . $lib->name; $lib->name = trim($lib->name, '/'); } if($lib->project != 0) $lib->name = zget($projects, $lib->project, '') . ' / ' . $lib->name; if($lib->type == 'mine' || $lib->type == 'custom') { if($lib->parent == 0) continue; $parentLib = $this->getLibByID($lib->parent); $lib->name = $parentLib->name . ' / ' . $lib->name; } } $libPairs[$lib->id] = $lib->name; } } return $libPairs; } /** * 获取一个项目下的执行库。 * Get execution libraries by project. * * @param int $projectID * @access public * @return array */ public function getExecutionLibPairsByProject($projectID, $extra = '', $executions = array()) { $libs = $this->dao->select('*')->from(TABLE_DOCLIB) ->where('deleted')->eq(0) ->andWhere('type')->eq('execution') ->andWhere('project')->eq($projectID) ->beginIF($this->config->vision != 'or')->andWhere('vision')->eq($this->config->vision)->fi() ->fetchAll('', false); $libPairs = array(); foreach($libs as $lib) { if($this->checkPrivLib($lib)) { if(strpos($extra, 'withObject') !== false) { $lib->name = zget($executions, $lib->execution, '') . ' / ' . $lib->name; $lib->name = ltrim($lib->name, '/'); } $libPairs[$lib->id] = $lib->name; } } return $libPairs; } /** * 获取有权限访问的文档库。 * Get grant libs by doc. * * @access public * @return array */ public function getPrivLibsByDoc(): array { static $libs; if($libs === null) { $libs = array(); $stmt = $this->dao->select('lib,`groups`,users')->from(TABLE_DOC)->where('acl')->ne('open')->andWhere("(`groups` != '' or users != '')")->query(); $account = ",{$this->app->user->account},"; $userGroups = $this->app->user->groups; while($lib = $stmt->fetch()) { if(strpos(",$lib->users,", $account) !== false) { $libs[$lib->lib] = $lib->lib; } elseif($lib->groups) { foreach($userGroups as $groupID) { if(strpos(",$lib->groups,", ",$groupID,") !== false) { $libs[$lib->lib] = $lib->lib; break; } } } } } return $libs; } /** * 创建一个文档库。 * Create a lib. * * @param object $lib * @param string $libType wiki|api * @param string $type api|project|product|execution|custom|mine * @access public * @return int|bool */ public function createLib(object $lib, string $type = '', string $libType = ''): int|bool { if(!empty($_POST['newSpace'])) { if(!$lib->spaceName) { dao::$errors['spaceName'] = sprintf($this->lang->error->notempty, $this->lang->doc->space); return false; } $space = clone $lib; $space->name = $space->spaceName; $space->parent = 0; $space->acl = 'open'; $spaceID = $this->docTao->doInsertLib($space); if(dao::isError()) return false; $lib->parent = $spaceID; $this->loadModel('action')->create('docspace', $spaceID, 'created'); } elseif($lib->parent <= 0 && $type == 'custom') { dao::$errors['parent'] = sprintf($this->lang->error->notempty, $this->lang->doc->space); return false; } if($lib->execution) $lib->type = 'execution'; if($lib->type == 'execution' && $lib->execution && !$lib->project) { $execution = $this->loadModel('execution')->getByID((int)$lib->execution); $lib->project = $execution->project; } if($libType == 'api') { $lib->type = 'api'; $this->checkApiLibName($lib, $type); } $libID = $this->docTao->doInsertLib($lib, $this->config->doc->createlib->requiredFields); $this->dao->update(TABLE_DOCLIB)->set('`order`')->eq($libID)->where('id')->eq($libID)->exec(); if(dao::isError()) return false; return $libID; } /** * 创建一个API接口库。 * Creat a api doc library. * * @param object $formData * @access public * @return bool|int */ public function createApiLib(?object $formData = null): bool|int { $this->app->loadLang('api'); /* Replace doc library name. */ $this->lang->doclib->name = $this->lang->doclib->apiLibName; $this->lang->doclib->baseUrl = $this->lang->api->baseUrl; $this->lang->doclib->project = $this->lang->api->project; $this->lang->doclib->product = $this->lang->api->product; if($formData->libType == 'product') $this->config->api->createlib->requiredFields .= ',product'; if($formData->libType == 'project') $this->config->api->createlib->requiredFields .= ',project'; $this->checkApiLibName($formData, $formData->libType); if(dao::isError()) return false; $formData->type = static::DOC_TYPE_API; $this->dao->insert(TABLE_DOCLIB)->data($formData, 'libType')->autoCheck() ->batchCheck($this->config->api->createlib->requiredFields, 'notempty') ->exec(); if(dao::isError()) return false; $libID = $this->dao->lastInsertID(); $this->loadModel('action')->create('doclib', $libID, 'created'); return $libID; } /** * 更新一个API接口库。 * Update an api lib. * * @param int $id * @param object $formData * @access public * @return array|false */ public function updateApiLib(int $id, ?object $formData = null): array|bool { $oldLib = $this->getLibByID($id); /* Replace doc library name. */ $this->app->loadLang('api'); $this->lang->doclib->name = $this->lang->doclib->apiLibName; $this->lang->doclib->baseUrl = $this->lang->api->baseUrl; $this->lang->doclib->project = $this->lang->api->project; $this->lang->doclib->product = $this->lang->api->product; $this->checkApiLibName($formData, $formData->type, $id); if(dao::isError()) return false; $formData->type = static::DOC_TYPE_API; $this->dao->update(TABLE_DOCLIB)->data($formData, 'type')->autoCheck() ->batchCheck($this->config->api->editlib->requiredFields, 'notempty') ->where('id')->eq($id) ->exec(); if(dao::isError()) return false; $changes = common::createChanges($oldLib, $formData); if($changes) { $actionID = $this->loadModel('action')->create('docLib', $id, 'Edited'); $this->action->logHistory($actionID, $changes); } return $changes; } /** * 更新一个文档库。 * Update a doc lib. * * @param int $libID * @param object $lib * @access public * @return array|bool */ public function updateLib(int $libID, object $lib): array|bool { $oldLib = $this->getLibByID($libID); if($oldLib->type == 'project') { $libCreatedBy = $this->dao->select('*')->from(TABLE_ACTION)->where('objectType')->eq('doclib')->andWhere('objectID')->eq($libID)->andWhere('action')->eq('created')->fetch('actor'); $openedBy = $this->dao->findById($oldLib->project)->from(TABLE_PROJECT)->fetch('openedBy'); if($lib->acl == 'private' && $lib->acl == 'custom') $lib->users .= ',' . $libCreatedBy ? $libCreatedBy : $openedBy; } if($oldLib->acl != $lib->acl && $lib->acl == 'open') $lib->users = ''; if($oldLib->type == 'api') { $type = 'nolink'; if(!empty($oldLib->product)) $type = 'product'; if(!empty($oldLib->project)) $type = 'project'; $lib->product = $oldLib->product; $lib->project = $oldLib->project; $this->checkApiLibName($lib, $type, $libID); } $this->dao->update(TABLE_DOCLIB)->data($lib, 'space')->autoCheck() ->batchCheck($this->config->doc->editlib->requiredFields, 'notempty') ->where('id')->eq($libID) ->exec(); $this->moveLib($libID, $lib); if(dao::isError()) return false; return common::createChanges($oldLib, $lib); } /** * 通过类型获取文档列表数据。 * Get doc list data by browse type. * * @param string $browseType all|bySearch|openedbyme|editedbyme|byediteddate|collectedbyme * @param int $queryID * @param int $moduleID * @param string $sort * @param object $pager * @access public * @return array */ public function getDocsByBrowseType(string $browseType, int $queryID, int $moduleID, string $sort, ?object $pager = null) { if($browseType == 'all') return $this->getDocs(0, 0, $browseType, $sort, $pager); $allLibs = $this->getLibs('all'); $allLibIDList = array_keys($allLibs); $hasPrivDocIdList = $this->getPrivDocs($allLibIDList, $moduleID); if($browseType == 'bySearch') { $docs = $this->getMyDocListBySearch($queryID, $hasPrivDocIdList, $allLibIDList, $sort, $pager); } elseif($browseType == "openedbyme") { $docs = $this->docTao->getOpenedDocs($hasPrivDocIdList, $sort, $pager); } elseif($browseType == 'editedbyme') { $docs = $this->docTao->getEditedDocs($sort, $pager); } elseif($browseType == 'byediteddate') { $docs = $this->docTao->getOrderedDocsByEditedDate($hasPrivDocIdList, $allLibIDList, $pager); } elseif($browseType == "collectedbyme") { $docs = $this->docTao->getCollectedDocs($hasPrivDocIdList, $sort, $pager); } if(empty($docs)) return array(); if(!in_array($browseType, array('bySearch', 'openedbyme', 'editedbyme'))) return $this->processCollector($docs); $objects = array(); list($objects['project'], $objects['execution'], $objects['product']) = $this->getObjectsByDoc(array_keys($docs)); foreach($docs as $docID => $doc) { $doc->objectID = zget($doc, $doc->objectType, 0); $doc->objectName = ''; if(isset($objects[$doc->objectType])) { $doc->objectName = zget($objects[$doc->objectType], $doc->objectID); } else { if($doc->objectType == 'mine') $doc->objectName = $this->lang->doc->person; if($doc->objectType == 'custom') $doc->objectName = $this->lang->doc->team; } } return $this->processCollector($docs); } /** * 获取搜索后的文档列表。 * Get doc list by search. * * @param int $queryID * @param array $hasPrivDocIdList * @param array $allLibIDList * @param string $sort * @param object $pager * @access public * @return array */ public function getMyDocListBySearch(int $queryID, array $hasPrivDocIdList, array $allLibIDList, string $sort, ?object $pager = null): array { if($queryID) { $query = $this->loadModel('search')->getQuery($queryID); if($query) { $this->session->set('contributeDocQuery', $query->sql); $this->session->set('contributeDocForm', $query->form); } else { $this->session->set('contributeDocQuery', ' 1 = 1'); } } else { if($this->session->contributeDocQuery == false) $this->session->set('contributeDocQuery', ' 1 = 1'); } $query = $this->getDocQuery($this->session->contributeDocQuery); $query = preg_replace('/(`\w+`)/', 't1.$1', $query); $docIDList = $this->dao->select('objectID')->from(TABLE_ACTION) ->where('objectType')->eq('doc') ->andWhere('objectID')->in($hasPrivDocIdList) ->andWhere('actor')->eq($this->app->user->account) ->andWhere('action')->eq('edited') ->fetchAll('objectID'); return $this->dao->select('t1.*, t2.name as libName, t2.type as objectType')->from(TABLE_DOC)->alias('t1') ->leftJoin(TABLE_DOCLIB)->alias('t2')->on("t1.lib=t2.id") ->where('t1.deleted')->eq(0) ->andWhere($query) ->andWhere('t1.lib')->in($allLibIDList) ->andWhere('t1.templateType')->eq('') ->andWhere('t1.vision')->in($this->config->vision) ->beginIF($this->config->doc->notArticleType)->andWhere('t1.type')->notIN($this->config->doc->notArticleType)->fi() ->andWhere('t1.addedBy', 1)->eq($this->app->user->account) ->orWhere('t1.id')->in(array_keys($docIDList)) ->markRight(1) ->orderBy($sort) ->page($pager) ->fetchAll('id', false); } /** * 替换查询语句中的all。 * Replace all in query. * * @param string $query * @access public * @return string */ public function getDocQuery(string $query): string { $allLib = "`lib` = 'all'"; if(strpos($query, $allLib) !== false) { $libPairs = $this->loadModel('doc')->getLibs('all'); $libIdList = empty($libPairs) ? 0 : implode(',', array_keys($libPairs)); $query = str_replace($allLib, '1', $query); $query = $query . ' AND `lib` ' . helper::dbIN($libIdList); } $allProject = "`project` = 'all'"; if(strpos($query, $allProject) !== false) { $projectPairs = $this->loadModel('project')->getPairsByProgram(); $projectIdList = empty($projectPairs) ? 0 : implode(',', array_keys($projectPairs)); $query = str_replace($allProject, '1', $query); $query = $query . ' AND `project` in (' . $projectIdList . ')'; } $allProduct = "`product` = 'all'"; if(strpos($query, $allProduct) !== false) { $productPairs = $this->loadModel('product')->getPairs(); $productIdList = empty($productPairs) ? 0 : implode(',', array_keys($productPairs)); $query = str_replace($allProduct, '1', $query); $query = $query . ' AND `product` ' . helper::dbIN($productIdList); } $allExecution = "`execution` = 'all'"; if(strpos($query, $allExecution) !== false) { $executionPairs = $this->loadModel('execution')->getPairs(); $executionIdList = empty($executionPairs) ? 0 : implode(',', array_keys($executionPairs)); $query = str_replace($allExecution, '1', $query); $query = $query . ' AND `execution` ' . helper::dbIN($executionIdList); } return $query; } /** * 获取文档模板列表。 * Get document template list. * * @param int $libID * @param string $type * @param string $orderBy * @param object $pager * @param string $searchName * @access public * @return array */ public function getDocTemplateList(int $libID = 0, string $type = 'all', string $orderBy = 'id_desc', ?object $pager = null, string $searchName = ''): array { return $this->dao->select('t1.*')->from(TABLE_DOC)->alias('t1') ->leftJoin(TABLE_MODULE)->alias('t2')->on('t1.module=t2.id') ->where('t2.type')->eq('docTemplate') ->andWhere('t1.builtIn')->eq('0') ->andWhere('t1.vision')->eq($this->config->vision) ->beginIF(!$this->app->user->admin)->andWhere("(t1.`status` = 'normal' or (t1.`status` = 'draft' and t1.`addedBy`='{$this->app->user->account}'))")->fi() ->beginIF($libID)->andWhere('t1.lib')->eq($libID)->fi() ->beginIF($type == 'draft')->andWhere('t1.status')->eq('draft')->fi() ->beginIF($type == 'released')->andWhere('t1.status')->eq('normal')->fi() ->beginIF($type == 'createdByMe')->andWhere('t1.addedBy')->eq($this->app->user->account)->fi() ->beginIF($searchName)->andWhere('t1.title')->like("%{$searchName}%")->fi() ->orderBy($orderBy) ->page($pager) ->fetchAll('', false); } /** * 通过文档ID获取文档所属产品、项目、执行。 * Get projects, executions and products by docIdList. * * @param array $docIdList * @access public * @return array */ public function getObjectsByDoc(array $docIdList = array()): array { $projects = $executions = $products = array(); if(empty($docIdList)) return array($projects, $executions, $products); $projects = $this->dao->select('t1.id, t1.name')->from(TABLE_PROJECT)->alias('t1') ->leftJoin(TABLE_DOC)->alias('t2')->on('t1.id=t2.project') ->where('t2.id')->in($docIdList) ->andWhere('t2.execution')->eq(0) ->fetchPairs(); $executions = $this->dao->select('t1.id, t1.name')->from(TABLE_EXECUTION)->alias('t1') ->leftJoin(TABLE_DOC)->alias('t2')->on('t1.id=t2.execution') ->where('t2.id')->in($docIdList) ->fetchPairs(); $products = $this->dao->select('t1.id, t1.name')->from(TABLE_PRODUCT)->alias('t1') ->leftJoin(TABLE_DOC)->alias('t2')->on('t1.id=t2.product') ->where('t2.id')->in($docIdList) ->fetchPairs(); return array($projects, $executions, $products); } /** * 获取当前文档库下的文档列表数据。 * Get doc list by libID. * * @param int $libID * @param int $moduleID * @param string $browseType all|draft * @param string $orderBy * @param object $pager * @access public * @return array */ public function getDocs(int $libID, int $moduleID, string $browseType, string $orderBy, ?object $pager = null): array { if(common::isTutorialMode()) return $this->loadModel('tutorial')->getDocs(); if(empty($libID) && $browseType != 'all') return array(); $docIdList = $this->getPrivDocs($libID ? array($libID) : array(), $moduleID, 'children'); $docs = $this->dao->select('*')->from(TABLE_DOC) ->where('deleted')->eq(0) ->andWhere('vision')->eq($this->config->vision) ->andWhere('templateType')->eq('') ->andWhere('id')->in($docIdList) ->beginIF($browseType == 'all')->andWhere("(status = 'normal' or (status = 'draft' and addedBy='{$this->app->user->account}'))")->fi() ->beginIF($browseType == 'draft')->andWhere('status')->eq('draft')->andWhere('addedBy')->eq($this->app->user->account)->fi() ->orderBy($orderBy) ->page($pager) ->fetchAll('id',false); $this->loadModel('common')->saveQueryCondition($this->dao->get(), 'doc', true); return $this->processCollector($docs); } /** * Get docs by id list. * * @param array $docIdList * @access public * @return array */ public function getDocsByIdList(array $docIdList): array { return $this->dao->select('*')->from(TABLE_DOC)->where('id')->in($docIdList)->fetchAll('id', false); } /** * 获取文档列表数据。 * Get doc list. * * @param array $libs * @param string $spaceType * @param int $excludeID * @param bool $queryTemplate * @access public * @return array */ public function getDocsOfLibs(array $libs, string $spaceType, int $excludeID = 0, $queryTemplate = false): array { $docs = $this->dao->select('t1.*,t3.content')->from(TABLE_DOC)->alias('t1') ->leftJoin(TABLE_MODULE)->alias('t2')->on('t1.module=t2.id') ->leftJoin(TABLE_DOCCONTENT)->alias('t3')->on('t1.id=t3.doc and t1.version=t3.version') ->where('t1.lib')->in($libs) ->andWhere('t1.vision')->eq($this->config->vision) ->beginIF(!$queryTemplate)->andWhere('t1.templateType')->eq('')->andWhere('t2.type')->eq('doc')->fi() ->beginIF($queryTemplate)->andWhere('t1.templateType')->ne('')->andWhere('t1.builtIn')->eq('0')->andWhere('t2.type')->eq('docTemplate')->fi() ->andWhere("(t1.status = 'normal' or (t1.status = 'draft' and t1.addedBy='{$this->app->user->account}'))") ->andWhere("(t2.deleted = '0' or t1.parent != '0')") ->beginIF(!empty($excludeID))->andWhere("NOT FIND_IN_SET('{$excludeID}', t1.`path`)")->andWhere('t1.id')->ne($excludeID)->fi() ->orderBy('t1.`order` asc, t1.id asc') ->fetchAll('id', false); $rootDocs = $this->dao->select('t1.*,t3.content')->from(TABLE_DOC)->alias('t1') ->leftJoin(TABLE_DOCCONTENT)->alias('t3')->on('t1.id=t3.doc and t1.version=t3.version') ->where('t1.lib')->in($libs) ->andWhere('t1.vision')->eq($this->config->vision) ->beginIF(!$queryTemplate)->andWhere('t1.templateType')->eq('')->fi() ->beginIF($queryTemplate)->andWhere('t1.templateType')->ne('')->andWhere('builtIn')->eq('0')->fi() ->andWhere("(t1.status = 'normal' or (t1.status = 'draft' and t1.addedBy='{$this->app->user->account}'))") ->andWhere('t1.module')->in(array('0', '')) ->beginIF(!empty($excludeID))->andWhere("NOT FIND_IN_SET('{$excludeID}', t1.`path`)")->andWhere('t1.id')->ne($excludeID)->fi() ->orderBy('`order` asc, id_asc') ->fetchAll('id', false); $docs = arrayUnion($docs, $rootDocs); $docs = $this->docTao->filterDeletedDocs($docs); $docs = $this->filterPrivDocs($docs, $spaceType); $docs = $this->processCollector($docs); foreach($docs as &$doc) { $doc->lib = (int)$doc->lib; $doc->module = (int)$doc->module; $doc->deleted = boolval($doc->deleted); $doc->isCollector = strpos($doc->collector, ',' . $this->app->user->account . ',') !== false; $doc->title = htmlspecialchars_decode($doc->title); if(!empty($doc->keywords) && is_string($doc->keywords)) $doc->keywords = htmlspecialchars_decode($doc->keywords); $doc->hasContent = !empty($doc->content) ? true : false; unset($doc->content); unset($doc->draft); } $apis = $this->loadModel('api')->getApiListBySearch(0, 0, '', $libs); foreach($apis as &$api) { $api->id = "api.$api->id"; $api->lib = (int)$api->lib; $api->module = (int)$api->module; $api->deleted = boolval($api->deleted); $api->originTitle = $api->title; $api->icon = "api is-$api->method"; $api->title = "$api->method $api->path $api->title"; $docs[$api->id] = $api; } return $docs; } /** * 过滤出有权限的文档列表。 * Filter docs which has privilege. * * @param array $docs * @param string $spaceType * @access public * @return array */ public function filterPrivDocs(array $docs, string $spaceType): array { $privDocs = array(); $noPrivDocs = array(); foreach($docs as $doc) { $this->setDocPriv($doc, $spaceType); if($doc->readable || $doc->editable) $privDocs[$doc->id] = $doc; else $noPrivDocs[] = $doc->id; } foreach($noPrivDocs as $docID) { foreach($privDocs as $doc) { if(strpos(",{$doc->path},", ",{$docID},") !== false) unset($privDocs[$doc->id]); } } return $privDocs; } /** * 设置文档的权限。 * Set doc privilege. * * @param object $doc * @access public * @return object */ public function setDocPriv(object $doc, string $spaceType): object { $currentAccount = $this->app->user->account; $userGroups = $this->app->user->groups; $doc->readable = false; $doc->editable = false; $isOpen = $doc->acl == 'open'; $isAuthorOrAdmin = $doc->addedBy == $currentAccount || ($this->app->user->admin && $spaceType !== 'mine'); $isInReadUsers = strpos(",$doc->readUsers,", ",$currentAccount,") !== false; $isInEditUsers = strpos(",$doc->users,", ",$currentAccount,") !== false; if($isOpen || $isAuthorOrAdmin || $isInReadUsers || $isInEditUsers) { $doc->editable = $isOpen || $isAuthorOrAdmin || $isInEditUsers; $doc->readable = $isOpen || $isAuthorOrAdmin || $isInReadUsers || $doc->editable; if($spaceType == 'template') $doc->editable = ($isOpen && common::hasPriv('doc', 'editTemplate')) || $isAuthorOrAdmin || $isInEditUsers; } elseif(!empty($doc->groups) || !empty($doc->readGroups)) { $isInReadGroups = false; $isInEditGroups = false; foreach($userGroups as $groupID) { if(strpos(",$doc->groups,", ",$groupID,") !== false) $isInEditGroups = true; if(strpos(",$doc->readGroups,", ",$groupID,") !== false) $isInReadGroups = true; } $doc->editable = $isInEditGroups; $doc->readable = $isInReadGroups || $doc->editable; } return $doc; } /** * 获取我的空间下的文档列表数据。 * Get mine list. * * @param string $type view|collect|createdby|editedby * @param string $browseType all|draft|bysearch * @param int $queryID * @param string $orderBy * @param object $pager * @access public * @return array */ public function getMineList(string $type, string $browseType, int $queryID = 0, string $orderBy = 'id_desc', ?object $pager = null): array { $query = ''; if($browseType == 'bysearch') { $query = $this->buildQuery($type, $queryID); $query = preg_replace('/(`\w+`)/', 't1.$1', $query); } if(in_array($type, array('view', 'collect', 'createdby', 'editedby'))) $docs = $this->getMySpaceDocs($type, $browseType, $query, $orderBy, $pager); $this->loadModel('tree'); $currentAccount = $this->app->user->account; $objects = array(); $modules = array(); list($objects['project'], $objects['execution'], $objects['product']) = $this->getObjectsByDoc(array_keys($docs)); foreach($docs as $docID => $doc) { if(!isset($modules[$doc->lib])) $modules[$doc->lib] = $this->tree->getOptionMenu((int)$doc->lib, 'doc', 0, 'all', 'nodeleted', 'all', ' > '); $doc->moduleName = zget($modules[$doc->lib], $doc->module); $doc->moduleName = ltrim((string)$doc->moduleName, '/'); $doc->objectID = zget($doc, $doc->objectType, 0); $doc->objectName = ''; $doc->editable = false; $isOpen = $doc->acl == 'open'; $isAuthorOrAdmin = $doc->acl == 'private' && ($doc->addedBy == $currentAccount || ($this->app->user->admin)); $isInReadUsers = strpos(",$doc->readUsers,", ",$currentAccount,") !== false; $isInEditUsers = strpos(",$doc->users,", ",$currentAccount,") !== false; if($isOpen || $isAuthorOrAdmin || $isInReadUsers || $isInEditUsers) { $doc->editable = $isOpen || $isAuthorOrAdmin || $isInEditUsers; } if(isset($objects[$doc->objectType][$doc->objectID])) { $doc->objectName = $objects[$doc->objectType][$doc->objectID]; } else { if($doc->objectType == 'mine') $doc->objectName = $this->lang->doc->person; if($doc->objectType == 'custom') $doc->objectName = $this->lang->doc->team; } } $docs = $this->filterPrivDocs($docs, 'mine'); return $this->processCollector($docs); } /** * 获取我的空间下的文档列表数据。 * Get doc list under the my space. * * @param string $type view|collect|createdby|editedby * @param string $browseType all|draft|bysearch * @param string $orderBy * @param string $query * @param object $pager * @param string $appendDocs * @param string $filterDocs * @access public * @return array */ public function getMySpaceDocs(string $type, string $browseType, string $query = '', string $orderBy = 'id_desc', ?object $pager = null, string $appendDocs = '', string $filterDocs = ''): array { if(!in_array($type, array('all', 'view', 'collect', 'createdby', 'editedby'))) return array(); $allLibs = $this->getLibs('all'); $allLibIDList = array_keys($allLibs); $hasPrivDocIdList = $this->getPrivDocs($allLibIDList); if(in_array($type, array('view', 'collect'))) { $docSQL = $this->dao->select('MAX(id)')->from(TABLE_DOCACTION) ->where('action')->eq($type) ->andWhere('actor')->eq($this->app->user->account) ->groupBy('doc') ->get(); $docs = $this->dao->select('t1.*,t2.date,t3.name as libName,t3.type as objectType')->from(TABLE_DOC)->alias('t1') ->leftJoin(TABLE_DOCACTION)->alias('t2')->on("t1.id=t2.doc") ->leftJoin(TABLE_DOCLIB)->alias('t3')->on("t1.lib=t3.id") ->where('t1.deleted')->eq(0) ->andWhere('t1.templateType')->eq('') ->andWhere('t1.lib')->ne(0) ->andWhere('t1.type')->in($this->config->doc->docTypes) ->andWhere('t1.vision')->eq($this->config->vision) ->andWhere('t2.id')->subIn($docSQL) ->beginIF(!common::hasPriv('doc', 'productSpace'))->andWhere('t3.type')->ne('product')->fi() ->beginIF(!common::hasPriv('doc', 'projectSpace'))->andWhere('t3.type')->notIN('project,execution')->fi() ->beginIF(!common::hasPriv('doc', 'teamSpace'))->andWhere('t3.type')->ne('custom')->fi() ->beginIF(in_array($browseType, array('all', 'bysearch')))->andWhere("(t1.status = 'normal' or (t1.status = 'draft' and t1.addedBy='{$this->app->user->account}'))")->fi() ->beginIF($browseType == 'draft')->andWhere('t1.status')->eq('draft')->andWhere('t1.addedBy')->eq($this->app->user->account)->fi() ->beginIF($browseType == 'bysearch')->andWhere($query)->fi() ->beginIF($browseType == 'bykeyword')->andWhere('t1.status')->eq('normal')->fi() ->beginIF($browseType == 'bykeyword' && $query)->andWhere('t1.title')->like("%$query%")->fi() ->beginIF(!empty($hasPrivDocIdList))->andWhere('t1.id')->in($hasPrivDocIdList)->fi() ->beginIF($filterDocs)->andWhere('t1.id')->notIN($filterDocs)->fi() ->beginIF($appendDocs)->orWhere('t1.id')->in($appendDocs)->fi() ->orderBy($orderBy) ->page($pager, 't1.id') ->fetchAll('id', false); } else { $docIdList = $type == 'editedby' ? $this->docTao->getEditedDocIdList() : array(); $docs = $this->dao->select('t1.*,t2.name as libName,t2.type as objectType')->from(TABLE_DOC)->alias('t1')->leftJoin(TABLE_DOCLIB)->alias('t2')->on("t1.lib=t2.id") ->where('t1.deleted')->eq(0) ->andWhere('t1.lib')->ne(0) ->andWhere('t1.templateType')->eq('') ->andWhere('t1.vision')->eq($this->config->vision) ->andWhere('t1.type')->in($this->config->doc->docTypes) ->beginIF($type == 'createdby')->andWhere('t1.addedBy')->eq($this->app->user->account)->fi() ->beginIF($type == 'editedby')->andWhere('t1.id')->in($docIdList)->fi() ->beginIF(!common::hasPriv('doc', 'productSpace'))->andWhere('t2.type')->ne('product')->fi() ->beginIF(!common::hasPriv('doc', 'projectSpace'))->andWhere('t2.type')->notIN('project,execution')->fi() ->beginIF(!common::hasPriv('doc', 'teamSpace'))->andWhere('t2.type')->ne('custom')->fi() ->beginIF($browseType == 'draft')->andWhere('t1.status')->eq('draft')->andWhere('t1.addedBy')->eq($this->app->user->account)->fi() ->beginIF($browseType == 'bysearch')->andWhere($query)->fi() ->beginIF($browseType == 'bykeyword')->andWhere('t1.status')->eq('normal')->fi() ->beginIF($browseType == 'bykeyword' && $query)->andWhere('t1.title')->like("%$query%")->fi() ->beginIF(!empty($hasPrivDocIdList))->andWhere('t1.id')->in($hasPrivDocIdList)->fi() ->beginIF($filterDocs)->andWhere('t1.id')->notIN($filterDocs)->fi() ->beginIF($appendDocs)->orWhere('t1.id')->in($appendDocs)->fi() ->orderBy($orderBy) ->page($pager) ->fetchAll('id', false); } return $docs; } /** * 获取有权限查看的文档ID列表。 * Get grant doc id list. * * @param array $libIdList * @param int $moduleID * @param string $mode normal|all|chidren * @access public * @return array */ public function getPrivDocs(array $libIdList = array(), int $moduleID = 0, string $mode = 'normal'): array { $modules = $moduleID && $mode == 'children' ? $this->loadModel('tree')->getAllChildID($moduleID) : $moduleID; /* 团队空间下的空间列出所有子库的文档。 */ if(count($libIdList) == 1) { $libID = current($libIdList); $lib = $this->getLibByID((int)$libID); if($lib->type == 'custom' && $lib->parent == 0) { $libs = $this->dao->select('*')->from(TABLE_DOCLIB)->where('parent')->eq($libID)->andWhere('deleted')->eq('0')->fetchAll(); foreach($libs as $subLib) { if($this->checkPrivLib($subLib)) $libIdList[] = $subLib->id; } } } $docs = $this->dao->select("`id`,`addedBy`,`type`,`lib`,`acl`,`users`,`readUsers`,`groups`,`readGroups`,`status`,`path`,`deleted`")->from(TABLE_DOC) ->where('vision')->eq($this->config->vision) ->andWhere('templateType')->eq('') ->beginIF(!empty($modules))->andWhere('module')->in($modules)->fi() ->beginIF($mode == 'normal')->andWhere('deleted')->eq(0)->fi() ->beginIF($this->config->doc->notArticleType)->andWhere('type')->notIN($this->config->doc->notArticleType)->fi() ->beginIF($libIdList)->andWhere('lib')->in($libIdList)->fi() ->fetchAll('id'); $docs = $this->batchCheckPrivDoc($docs); $docIdList = array_keys($docs); return array_combine($docIdList, $docIdList); } /** * 通过ID获取文档信息。 * Get doc info by id. * * @param int $docID * @param int $version * @param bool $setImgSize * @access public * @return object|false */ public function getByID(int $docID, int $version = 0, bool $setImgSize = false): object|bool { if(common::isTutorialMode()) return $this->loadModel('tutorial')->getDoc(); $doc = $this->dao->select('*')->from(TABLE_DOC) ->where('id')->eq((int)$docID) ->andWhere('vision')->eq($this->config->vision) ->fetch(); if(!$doc) return false; $docs = $this->processCollector(array($doc->id => $doc)); $doc = $docs[$doc->id]; $version = $version ? $version : $doc->version; $doc->releasedBy = $doc->releasedDate = ''; if($doc->status == 'normal') { $releaseInfo = $this->dao->select('*')->from(TABLE_ACTION) ->where('objectType')->eq('doc') ->andWhere('objectID')->eq($docID) ->andWhere('action')->eq('releaseddoc') ->fetch(); $doc->releasedBy = $releaseInfo ? $releaseInfo->actor : $doc->addedBy; $doc->releasedDate = $releaseInfo ? $releaseInfo->date : $doc->addedDate; } return $this->processDoc($doc, (int)$version, $setImgSize); } /** * 通过文档ID和版本号获取文档内容，当 $version 为 0 时，获取文档的草稿内容。 * Get doc content by docID and version, when $version is 0, get doc draft content. * * @param int $docID * @param int $version * @access public * @return ?object */ public function getContent(int $docID, int $version): ?object { $docContent = $this->dao->select('*')->from(TABLE_DOCCONTENT)->where('doc')->eq($docID)->andWhere('version')->eq($version)->fetch(); if($docContent) { $docContent->addedDate = empty($docContent->addedDate) ? null : $docContent->addedDate; $docContent->editedDate = empty($docContent->editedDate) ? null : $docContent->editedDate; $docContent->title = htmlspecialchars_decode($docContent->title); return $docContent; } return null; } /** * 处理文档数据。 * Process doc data. * * @param object $doc * @param bool $setImgSize * @access public * @return object */ public function processDoc(object $doc, int $version, bool $setImgSize = false): object { /* When file change then version add one. */ $files = $this->loadModel('file')->getByObject('doc', $doc->id); $docFiles = array(); $docContent = $this->getContent($doc->id, $version); if($docContent) { foreach($files as $file) { $this->loadModel('file')->setFileWebAndRealPaths($file); if(strpos(",{$docContent->files},", ",{$file->id},") !== false) $docFiles[$file->id] = $file; } /* Check file change. */ if($version == $doc->version && ((empty($docContent->files) && $docFiles) || (!empty($docContent->files) && count(explode(',', trim($docContent->files, ','))) != count($docFiles)))) { unset($docContent->id); $doc->version += 1; $docContent->version = $doc->version; $docContent->files = join(',', array_keys($docFiles)); $this->dao->insert(TABLE_DOCCONTENT)->data($docContent)->exec(); $this->dao->update(TABLE_DOC)->set('version')->eq($doc->version)->where('id')->eq($doc->id)->exec(); } } $doc->files = $docFiles; $doc->title = isset($docContent->title) ? $docContent->title : $doc->title; $doc->digest = isset($docContent->digest) ? $docContent->digest : ''; $doc->content = isset($docContent->content) ? $docContent->content : ''; $doc->rawContent = isset($docContent->rawContent) ? $docContent->rawContent : ''; $doc->contentType = isset($docContent->type) ? $docContent->type : ''; $doc->contentVersion = isset($docContent->version) ? $docContent->version : $version; $doc->keywords = (!empty($doc->keywords) && is_string($doc->keywords)) ? htmlspecialchars_decode($doc->keywords) : $doc->keywords; if($doc->type != 'url' && $doc->contentType != 'markdown' && $doc->contentType != 'doc') $doc = $this->loadModel('file')->replaceImgURL($doc, 'content,draft'); if($setImgSize) $doc->content = $this->file->setImgSize($doc->content); $doc->productName = $doc->executionName = $doc->moduleName = ''; if($doc->product) $doc->productName = $this->dao->findByID($doc->product)->from(TABLE_PRODUCT)->fetch('name'); if($doc->execution) $doc->executionName = $this->dao->findByID($doc->execution)->from(TABLE_EXECUTION)->fetch('name'); if($doc->module) { if($doc->type == 'article' && $doc->parent) { $doc->moduleName = $this->dao->findByID($doc->parent)->from(TABLE_DOC)->fetch('title'); } elseif(!empty($doc->templateType)) { $modules = $this->getTemplateModules(); $modules = array_column($modules, 'fullName', 'id'); $doc->moduleName = zget($modules, $doc->module); } else { $doc->moduleName = $this->dao->findByID($doc->module)->from(TABLE_MODULE)->fetch('name'); } } return $doc; } /** * 通过ID列表获取文档信息。 * Get docs info by id list. * * @param array $docIdList * @access public * @return array */ public function getByIdList(array $docIdList = array()): array { return $this->dao->select('*,t1.id as docID,t1.type as docType,t1.version as docVersion,t2.type as contentType')->from(TABLE_DOC)->alias('t1') ->leftJoin(TABLE_DOCCONTENT)->alias('t2')->on('t1.id=t2.doc and t1.version=t2.version') ->where('t1.id')->in($docIdList) ->andWhere('deleted')->eq(0) ->fetchAll('docID', false); } /** * 获取团队空间下的空间。 * Get team spaces. * * @access public * @return array */ public function getTeamSpaces(): array { if(common::isTutorialMode()) return $this->loadModel('tutorial')->getSubSpaces('custom'); return $this->getSpacePairs('custom'); } /** * 获取文档模板中的空间。 * Get doctemplate spaces. * * @access public * @return array */ public function getDocTemplateSpaces() { if(common::isTutorialMode()) return $this->loadModel('tutorial')->getTeamSpaces(); $spaces = $this->getSpacePairs('doctemplate'); if(empty($spaces)) $this->initDocTemplateSpaces(); return $this->getSpacePairs('doctemplate'); } /** * 初始化文档模板空间。 * Init doctemplate spaces. * * @access public * @return array */ public function initDocTemplateSpaces() { $this->loadModel('doctempalte'); $defaultSpaces = $this->config->doctemplate->defaultSpaces; foreach($defaultSpaces as $code => $childs) { $spaceID = $this->doInsertLib($this->initDocDefaultSpaces($code)); foreach($childs as $childCode) $this->doInsertLib($this->initDocDefaultSpaces($childCode, $spaceID)); } } /** * 初始化文档模板空间。 * Init doctemplate spaces. * * @access public * @return array */ public function initDocDefaultSpaces($code, $parent = 0) { $space = new stdclass(); $space->type = 'doctemplate'; $space->vision = 'rnd'; $space->parent = $parent; $space->name = $this->lang->doctemplate->$code; $space->acl = 'open'; $space->addedBy = 'system'; $space->addedDate = helper::now(); return $space; } /** * 获取团队空间或我的空间下的空间。 * Get team spaces or my spaces. * * @param string $type all|mine|custom * @param bool $withType * @access public * @return array */ public function getSubSpacesByType(string $type = 'all', bool $withType = false): array { if(common::isTutorialMode()) return $this->loadModel('tutorial')->getSubSpaces($type); $objectLibs = $this->dao->select('*')->from(TABLE_DOCLIB) ->where('deleted')->eq(0) ->andWhere('parent')->eq(0) ->andWhere('vision')->eq($this->config->vision) ->beginIF($type == 'all')->andWhere('type')->in('mine,custom')->fi() ->beginIF($type != 'all')->andWhere('type')->eq($type)->fi() ->beginIF($type == 'mine')->andWhere('addedBy')->eq($this->app->user->account)->fi() ->orderBy('type_desc') ->fetchAll('', false); $pairs = array(); foreach($objectLibs as $key => $lib) { if($lib->type === 'mine' && $lib->addedBy != $this->app->user->account) { unset($objectLibs[$key]); continue; } if($this->checkPrivLib($lib)) { $key = $withType ? "{$lib->type}.{$lib->id}" : $lib->id; $pairs[$key] = $type == 'all' ? $this->lang->doc->spaceList[$lib->type] . '/' . $lib->name : $lib->name; } } return $pairs; } /** * 获取lib的targetSpace，返回的是type.id。 * * @access public * @return string */ public function getLibTargetSpace($lib) { $type = $lib->type; if(in_array($type, array('product', 'project'))) { $targetSpace = "{$type}.{$lib->$type}"; } else { $targetSpace = "{$type}.{$lib->parent}"; } return $targetSpace; } /** * 解析targetSpace。 * * @param string $targetSpace * @param string $paramType type|id * @access public * @return array */ public function getParamFromTargetSpace($targetSpace, $paramType = 'type') { $params = explode('.', $targetSpace); if($paramType == 'type') return $params[0]; if($paramType == 'id') return $params[1]; } /** * 获取所有子空间。 * Get all sub spaces. * * @param string $spaceType * @access public * @return array */ public function getAllSubSpaces(string $spaceType = 'all') { $productList = $this->config->vision == 'rnd' && in_array($spaceType, array('all', 'product')) ? $this->loadModel('product')->getPairs('nocode') : array(); $projectList = ($this->config->vision == 'rnd' || $this->config->vision == 'lite') && in_array($spaceType, array('all', 'project', 'execution')) ? $this->loadModel('project')->getPairsByProgram() : array(); $spaceList = array(); if($spaceType == 'all') { $spaceList = $this->dao->select('*')->from(TABLE_DOCLIB) ->where('deleted')->eq(0) ->andWhere('parent')->eq(0) ->andWhere('vision')->eq($this->config->vision) ->andWhere('type', true)->eq('custom') ->orWhere('(type')->eq('mine')->andWhere('addedBy')->eq($this->app->user->account) ->markRight(2) ->orderBy('type_desc') ->fetchAll('', false); } $productPairs = $projectPairs = $spacePairs = array(); foreach($productList as $productID => $productName) $productPairs["product.{$productID}"] = $this->lang->doc->spaceList['product'] . '/' . $productName; foreach($projectList as $projectID => $projectName) $projectPairs["project.{$projectID}"] = $this->lang->doc->spaceList['project'] . '/' . $projectName; foreach($spaceList as $space) { if($this->checkPrivLib($space)) $spacePairs["{$space->type}.{$space->id}"] = $this->lang->doc->spaceList[$space->type] . '/' . $space->name; } return array_merge($spacePairs, $productPairs, $projectPairs); } /** * 获取空间列表。 * Get spaces. * * @param string $type * @param int $spaceID * @access public * @return array */ public function getSpaces($type = 'custom', $spaceID = 0) { $spaces = array(); if($type == 'mine' || $type == 'custom') { $pairs = $this->getSubSpacesByType($type); foreach($pairs as $key => $value) $spaces[] = array('id' => $key, 'name' => $value, 'type' => $type, 'canModify' => true); } if($type == 'product') { $account = $this->app->user->account; $products = $this->loadModel('product')->getList(); $spaceID = $this->product->checkAccess($spaceID, $products); foreach($products as $product) { $isMine = $product->status == 'normal' && $product->PO == $account; $canModify = common::canModify('product', $product); $spaces[] = array('id' => $product->id, 'name' => $product->name, 'isMine' => $isMine, 'type' => $type, 'canModify' => $canModify); } } if($type == 'project') { $projects = $this->loadModel('project')->getListByCurrentUser('*', 'skip'); $involvedProjects = $this->project->getInvolvedListByCurrentUser(); $spaceID = $this->project->checkAccess($spaceID, $projects); foreach($projects as $project) { $isMine = $project->status != 'closed' && isset($involvedProjects[$project->id]); $canModify = common::canModify('project', $project); $spaces[] = array('id' => $project->id, 'name' => $project->name, 'isMine' => $isMine, 'type' => $type, 'canModify' => $canModify); } } if($type === 'execution' && $spaceID) { $execution = $this->loadModel('execution')->getByID($spaceID); $canModify = common::canModify('execution', $execution); $spaces[] = array('id' => $execution->id, 'name' => $execution->name, 'canModify' => $canModify); } $spaceIDs = array_column($spaces, 'id'); if(!in_array($spaceID, $spaceIDs) && !empty($spaces)) $spaceID = $spaces[0]['id']; return array($spaces, $spaceID); } /** * 创建独立的文档。 * Create a seperate docs. * * @param object $doc * @access public * @return array|false|string */ public function createSeperateDocs(object $doc): array|bool|string { if($doc->acl == 'open') $doc->users = $doc->groups = ''; if(empty($doc->lib) && strpos((string)$doc->module, '_') !== false) list($doc->lib, $doc->module) = explode('_', $doc->module); if(empty($doc->lib)) return dao::$errors['lib'] = sprintf($this->lang->error->notempty, $this->lang->doc->lib); $files = $this->loadModel('file')->getUpload(); if(empty($files) || isset($files['name'])) return dao::$errors['files'] = sprintf($this->lang->error->notempty, $this->lang->doc->uploadFile); $lib = $this->getLibByID($doc->lib); $doc = $this->loadModel('file')->processImgURL($doc, $this->config->doc->editor->create['id'], (string)$this->post->uid); $doc->product = $lib->product; $doc->project = $lib->project; $doc->execution = $lib->execution; $docContent = new stdclass(); $docContent->title = $doc->title; $docContent->content = ''; $docContent->type = $doc->contentType; $docContent->digest = ''; $docContent->version = 1; unset($doc->contentType); unset($doc->rawContent); return $this->insertSeperateDocs($doc, $docContent, $files); } /** * 批量插入独立的文档。 * Insert seperate docs. * * @param object $doc * @param object $docContent * @param array $files * @access public * @return array|bool */ public function insertSeperateDocs(object $doc, object $docContent, array $files): array|bool { $this->loadModel('file'); $doc->draft = ''; $docsAction = array(); foreach($files as $file) { $title = $file['title']; $position = strrpos($title, '.'); if($position > 0) $title = substr($title, 0, $position); $doc->title = $title; $this->dao->insert(TABLE_DOC)->data($doc, 'content')->autoCheck() ->batchCheck($this->config->doc->create->requiredFields, 'notempty') ->exec(); if(dao::isError()) return false; $docID = $this->dao->lastInsertID(); /* Update order and path. */ $path = ",{$docID}"; if(!empty($doc->parent)) { $parentDoc = $this->getByID($doc->parent); $path = $parentDoc->path . $path; } $this->dao->update(TABLE_DOC)->set('`order`')->eq($docID)->set('path')->eq($path)->where('id')->eq($docID)->exec(); $this->file->updateObjectID($this->post->uid, $docID, 'doc'); $fileTitle = $this->file->saveAFile($file, 'doc', $docID); $docsAction[$docID] = $fileTitle; if(empty($fileTitle)) continue; if(dao::isError()) { dao::$errors['message'][] = 'doc#' . ($file->title) . dao::getError(true); continue; } $docContent->doc = $docID; $docContent->files = ',' . $fileTitle->id; $docContent->title = $title; $docContent->content = ''; $docContent->type = isset($docContent->type) ? $docContent->type : 'attachment'; $docContent->digest = ''; $docContent->version = 1; $this->dao->insert(TABLE_DOCCONTENT)->data($docContent)->exec(); $this->loadModel('score')->create('doc', 'create', $docID); } if(dao::isError()) return false; return array('status' => 'new', 'docsAction' => $docsAction, 'docType' => 'attachment', 'libID' => $doc->lib); } /** * 创建一个文档。 * Create a doc. * * @param object $doc * @access public * @return array|bool|string */ public function create(object $doc): array|bool|string { if($doc->acl == 'open') $doc->users = $doc->groups = ''; if(empty($doc->lib) && strpos((string)$doc->module, '_') !== false) list($doc->lib, $doc->module) = explode('_', $doc->module); if(empty($doc->lib)) return dao::$errors['lib'] = sprintf($this->lang->error->notempty, $this->lang->doc->lib); $isDoc = empty($doc->templateType); $isDraft = $doc->status == 'draft'; $lib = $this->getLibByID($doc->lib); if($doc->contentType != 'doc') $doc = $this->loadModel('file')->processImgURL($doc, $this->config->doc->editor->create['id'], (string)$this->post->uid); if($isDoc) { $doc->product = $lib->product; $doc->project = $lib->project; $doc->execution = $lib->execution; } $docContent = new stdclass(); $docContent->title = $doc->title; $docContent->content = $doc->content; $docContent->type = $doc->contentType; $docContent->rawContent = isset($doc->rawContent) ? $doc->rawContent : ''; $docContent->digest = ''; $docContent->version = $isDraft ? 0 : 1; $docContent->fromVersion = 0; $docContent->addedBy = $this->app->user->account; $docContent->addedDate = helper::now(); $docContent->editedBy = $docContent->addedBy; $docContent->editedDate = $docContent->addedDate; unset($doc->contentType); unset($doc->rawContent); $requiredFields = $isDraft ? 'title' : ($isDoc ? $this->config->doc->create->requiredFields : $this->config->doc->createTemplate->requiredFields); if(strpos("url|word|ppt|excel", $doc->type) !== false) $requiredFields = trim(str_replace(",content,", ",", ",{$requiredFields},"), ','); $checkContent = strpos(",$requiredFields,", ',content,') !== false; if($checkContent && strpos("url|word|ppt|excel|", $lib->type) === false) { $requiredFields = trim(str_replace(',content,', ',', ",$requiredFields,"), ','); if(empty($docContent->content)) return dao::$errors['content'] = sprintf($this->lang->error->notempty, $this->lang->doc->content); } $files = $this->loadModel('file')->getUpload(); if($doc->type == 'attachment' && empty($doc->copy) && (empty($files) || isset($files['name']))) return dao::$errors['files'] = sprintf($this->lang->error->notempty, $this->lang->doc->uploadFile); $doc->draft = $isDraft ? $docContent->content : ''; $doc->vision = $this->config->vision; $doc->version = $isDraft ? 0 : 1; $this->dao->insert(TABLE_DOC)->data($doc, 'content,copy')->autoCheck()->batchCheck($requiredFields, 'notempty')->exec(); if(dao::isError()) return false; $docID = $this->dao->lastInsertID(); $path = ",{$docID},"; if($doc->parent) { $parentDoc = $this->getByID($doc->parent); $path = ',' . trim($parentDoc->path, ',') . ',' . $path; $doc->module = $parentDoc->module; } $this->dao->update(TABLE_DOC)->set('`order`')->eq($docID)->set('path')->eq($path)->where('id')->eq($docID)->exec(); $this->file->updateObjectID($this->post->uid, $docID, 'doc'); $files = $this->file->saveUpload('doc', $docID); $docContent->doc = $docID; $docContent->files = implode(',', array_keys($files)); if(!empty($doc->template)) $docContent->rawContent = $this->loadExtension('zentaomax')->getTemplateContent((int)$doc->template, $docID); $this->dao->insert(TABLE_DOCCONTENT)->data($docContent)->exec(); $this->loadModel('score')->create('doc', $isDoc ? 'create' : 'createTemplate', $docID); return array('status' => 'new', 'id' => $docID, 'files' => $files, 'docType' => $doc->type, 'libID' => $doc->lib); } /** * 保存文档内容。 * Save doc content. * * @param int|object $doc 文档ID或文档对象 Document ID or doc object. * @param object $docData * @param int $version 文档版本号 Document version. * @param array $files 附件ID列表 Attachment ID list. * @access public * @return object */ public function saveDocContent(int $docID, object $docData, int $version, array $files = array()): object { /* 获取文档草稿作为要更新的内容。 */ $docContent = $this->getContent($docID, 0); if(!$docContent) $docContent = new stdClass(); $docContent->editedBy = $docData->editedBy; $docContent->editedDate = helper::now(); $docContent->rawContent = $docData->rawContent; $docContent->content = $docData->content; $docContent->title = $docData->title; $docContent->type = $docData->contentType; $docContent->version = $version; /* 如果没有文档草稿内容，则创建一个新的 doccontent 对象。 */ /* If current doc has no draft data, create a new docContent data. */ if(empty($docContent->id)) { $docContent->doc = $docID; $docContent->addedBy = $docContent->editedBy; $docContent->addedDate = $docContent->editedDate; $docContent->files = (!empty($docData->files) && is_string($docData->files)) ? (',' . $docData->files) : implode(',', $files); $docContent->fromVersion = isset($docData->fromVersion) ? $docData->fromVersion : max(0, ($version - 1)); $this->dao->insert(TABLE_DOCCONTENT)->data($docContent)->exec(); $docContent->id = $this->dao->lastInsertID(); } /* 如果有草稿内容，则直接将草稿内容作为新的版本内容。 */ /* If current doc has draft data,update the draft data as new version. */ else { $docContent->files = trim($docContent->files . ',' . implode(',', $files), ','); $this->dao->update(TABLE_DOCCONTENT)->data($docContent)->where('id')->eq($docContent->id)->exec(); } return $docContent; } /** * 编辑一个文档。 * Update a doc. * * @param int $docID * @param object $doc * @access public * @return array|string|bool */ public function update(int $docID, object $doc): array|string|bool { /* 检查必填项。 Check required fields. */ $requiredFields = $doc->status == 'draft' ? 'title' : $this->config->doc->edit->requiredFields; if(strpos(",$requiredFields,", ',content,') !== false) { $requiredFields = trim(str_replace(',content,', ',', ",$requiredFields,"), ','); if(isset($doc->content) && empty($doc->content)) return dao::$errors['content'] = sprintf($this->lang->error->notempty, $this->lang->doc->content); } $files = $this->loadModel('file')->saveUpload('doc', $docID); if(dao::isError()) return false; $deletedFiles = !empty($doc->deleteFiles) ? explode(',', $doc->deleteFiles) : array(); unset($doc->deleteFiles); $oldDoc = $this->getByID($docID); $changes = common::createChanges($oldDoc, $doc); $oldRawContent = isset($oldDoc->rawContent) ? $oldDoc->rawContent : ''; $newRawContent = isset($doc->rawContent) ? $doc->rawContent : ''; $onlyRawChanged = $oldRawContent != $newRawContent; $isDraft = $doc->status == 'draft'; $version = $isDraft ? 0 : ($oldDoc->version + 1); $changed = $deletedFiles || $files || $onlyRawChanged || (!$isDraft && $oldDoc->version == 0); $basicInfoChanged = false; foreach($changes as $change) { if(in_array($change['field'], array('module', 'lib', 'acl', 'groups', 'users'))) $basicInfoChanged = true; if($change['field'] == 'content' || $change['field'] == 'title' || $change['field'] == 'rawContent') $changed = true; if($change['field'] == 'content') $onlyRawChanged = false; } $docFiles = array_diff(array_merge(array_keys($files), array_keys($oldDoc->files)), $deletedFiles); if(empty($docFiles) && !empty($deletedFiles)) return dao::$errors['files'] = sprintf($this->lang->error->notempty, $this->lang->doc->uploadFile); if($onlyRawChanged) $changes[] = array('field' => 'content', 'old' => $oldDoc->content, 'new' => $doc->content); if(!empty($deletedFiles) || !empty($files)) $changes[] = array('field' => 'files', 'old' => implode(',', array_keys($oldDoc->files)), 'new' => implode(',', $docFiles)); if($changed) $this->saveDocContent($docID, $doc, $version, $docFiles); else $version = $oldDoc->version; if(dao::isError()) return false; $doc->version = max($version, $oldDoc->version); $doc->draft = $isDraft ? $doc->content : ''; $doc->content = $doc->title; if(empty($doc->status)) $doc->status = $isDraft ? $oldDoc->status : 'normal'; if(isset($doc->parent) && $doc->parent != $oldDoc->parent) { $path = ",{$docID}"; if($doc->parent) { $parentDoc = $this->getByID($doc->parent); $path = $parentDoc->path . $path; $doc->module = $parentDoc->module; } $doc->path = $path; } unset($doc->files); $this->dao->update(TABLE_DOC)->data($doc, 'content,contentType,rawContent,fromVersion,deleteFiles') ->autoCheck() ->batchCheck($requiredFields, 'notempty') ->where('id')->eq($docID) ->exec(); if(dao::isError()) return false; if($files) $this->file->updateObjectID($this->post->uid, $docID, 'doc'); /* 文档标题变了要同步修改交付物名称. */ if(in_array($this->config->edition, array('ipd', 'max')) && $oldDoc->title != $doc->title) { $this->dao->update(TABLE_PROJECTDELIVERABLE) ->set('name')->eq($doc->title) ->set('docVersion')->eq($doc->version) ->where('doc')->eq($docID) ->andWhere('status')->eq('draft') ->exec(); } /* 如果修改了父模板，子模板也同步更新相关信息。*/ /* If the parent template is modified, the child template will also update the relevant information synchronously. */ if(!empty($oldDoc->templateType) && empty($doc->parent) && $basicInfoChanged) { $this->dao->update(TABLE_DOC) ->set('module')->eq($doc->module) ->set('lib')->eq($doc->lib) ->set('acl')->eq($doc->acl) ->where("FIND_IN_SET('{$docID}', `path`)") ->exec(); } if(in_array($oldDoc->contentType, array('html', 'attachment', 'markdown')) && !in_array($doc->contentType, array('html', 'attachment', 'markdown'))) { $objectType = !empty($doc->templateType) ? 'doctemplate' : 'doc'; $this->loadModel('action')->create($objectType, $docID, 'convertToNewDoc'); } return array('changes' => $changes, 'files' => $files, 'deletedFiles' => $deletedFiles); } /** * 为更新文档处理数据。 * Process data for update a doc. * * @param object $oldDoc * @param object $doc * @access public * @return array */ public function processDocForUpdate(object $oldDoc, object $doc): array { $editingDate = $oldDoc->editingDate ? json_decode($oldDoc->editingDate, true) : array(); unset($editingDate[$this->app->user->account]); $doc->editingDate = json_encode($editingDate); if($doc->acl == 'open') $doc->users = $doc->groups = ''; if($doc->type == 'chapter' && $doc->parent) { $parentDoc = $this->dao->select('*')->from(TABLE_DOC)->where('id')->eq((int)$doc->parent)->fetch(); if(strpos($parentDoc->path, ",$oldDoc->id,") !== false) return dao::$errors['parent'] = $this->lang->doc->errorParentChapter; $doc->module = $parentDoc->module; } $oldDocContent = $this->dao->select('*')->from(TABLE_DOCCONTENT)->where('doc')->eq($oldDoc->id)->andWhere('version')->eq($oldDoc->version)->fetch(); if($oldDocContent) { $oldDoc->title = $oldDocContent->title; $oldDoc->digest = $oldDocContent->digest; $oldDoc->content = $oldDocContent->content; $oldDoc->contentType = $oldDocContent->type; } $lib = !empty($doc->lib) ? $this->getLibByID($doc->lib) : ''; if(!isset($doc->contentType) || $doc->contentType !== 'doc') $doc = $this->loadModel('file')->processImgURL($doc, $this->config->doc->editor->edit['id'], (string)$this->post->uid); if(!empty($lib)) { $doc->product = $lib->product; $doc->execution = $lib->execution; } return array($doc, $oldDocContent); } /** * 构造搜索条件。 * Build search query. * * @param string $type * @param int $queryID * @access public * @return string */ public function buildQuery(string $type, int $queryID = 0): string { $queryName = $type . 'libDocQuery'; $queryForm = $type . 'libDocForm'; if($queryID) { $query = $this->loadModel('search')->getQuery($queryID); if($query) { $this->session->set($queryName, $query->sql); $this->session->set($queryForm, $query->form); } else { $this->session->set($queryName, ' 1 = 1'); } } else { if($this->session->$queryName == false) $this->session->set($queryName, ' 1 = 1'); } $query = $this->session->$queryName; if(strpos($query, "`lib` = 'all'") !== false) $query = str_replace("`lib` = 'all'", '1', $query); if(strpos($query, "`lib` = ''") !== false) $query = str_replace("`lib` = ''", '1', $query); return $query; } /** * 获取执行文档库的所属模块的键值对。 * Gets the key-value pair of the module by execution ID. * * @access public * @return array */ public function getExecutionModulePairs(): array { return $this->dao->select('t1.id,t1.name')->from(TABLE_MODULE)->alias('t1') ->leftJoin(TABLE_DOCLIB)->alias('t2')->on('t1.root = t2.id') ->where('t1.type')->eq('doc') ->andWhere('t2.execution')->ne('0') ->fetchPairs(); } /** * 检查是否有权限访问文档库/文档。 * Check priv for lib. * * @param object|false|null $object * @param string $extra * @param string $docID * @access public * @return bool */ public function checkPrivLib(object|bool|null $object, string $extra = '', string $docID = ''): bool { if(empty($object)) return false; static $hasPrivLibs; if(isset($hasPrivLibs[$object->id])) return $hasPrivLibs[$object->id]; $hasPrivLibs[$object->id] = true; /* Only the creator can access the document library under my space. */ if($object->type == 'mine' && $object->addedBy == $this->app->user->account) return true; if($this->app->user->admin && $object->type != 'mine') return true; if($object->acl == 'open') return true; /* When view a document, check whether current user has permission to access the document library. */ $account = ',' . $this->app->user->account . ','; if(isset($object->addedBy) && $object->addedBy == $this->app->user->account) return true; if(isset($object->users) && strpos(",{$object->users},", $account) !== false) return true; if(!empty($object->groups)) { $userGroups = $this->app->user->groups; foreach($userGroups as $groupID) { if(strpos(",$object->groups,", ",$groupID,") !== false) return true; } } $isProjectLib = $object->project && !$object->execution; if($isProjectLib && $object->acl == 'default') { if($this->loadModel('project')->checkPriv($object->project)) return true; $this->setDocPrivError($docID, $object->project, 'project'); } /* The user has permission to access the owning document library that can access the document. */ if(strpos($extra, 'notdoc') !== false) { static $extraDocLibs; if($extraDocLibs === null) $extraDocLibs = $this->getPrivLibsByDoc(); if(isset($extraDocLibs[$object->id])) return true; } /* If the acl is default, the document library cannot be accessed without object permission. */ if($object->acl == 'default' && (!empty($object->product) || !empty($object->execution))) { $acls = $this->app->user->rights['acls']; if(!empty($acls['products']) && !in_array($object->product, $acls['products'])) { $this->setDocPrivError($docID, $object->product, 'product'); $hasPrivLibs[$object->id] = false; return false; } if(!empty($object->execution) && !empty($acls['sprints']) && !in_array($object->execution, $acls['sprints'])) { $this->setDocPrivError($docID, $object->execution, 'execution'); $hasPrivLibs[$object->id] = false; return false; } if(!empty($object->execution)) { $result = $this->loadModel('execution')->checkPriv($object->execution); if(!$result) $this->setDocPrivError($docID, $object->execution, 'execution'); $hasPrivLibs[$object->id] = $result; return $result; } if(!empty($object->product)) { $result = $this->loadModel('product')->checkPriv($object->product); if(!$result) $this->setDocPrivError($docID, $object->product, 'product'); $hasPrivLibs[$object->id] = $result; return $result; } } $hasPrivLibs[$object->id] = false; return false; } /** * 设置文档权限错误 * Set doc priv error. * * @param string $docID * @param int $objectID * @param string $type * @access private * @return void */ public function setDocPrivError(string $docID, int $objectID, string $type): void { if(!array_key_exists("doc_{$docID}_nopriv", $_SESSION)) return; $objectName = ''; if($type == 'product') $objectName = $this->loadModel('product')->getByID($objectID)->name; elseif($type == 'execution') $objectName = $this->loadModel('execution')->getByID($objectID)->name; elseif($type == 'project') $objectName = $this->loadModel('project')->getByID($objectID)->name; if(!empty($objectName)) $_SESSION["doc_{$docID}_nopriv"] = sprintf($this->lang->doc->nopriv, $objectName); } /** * 批量检查文档权限 * Batch check doc priv. * * @param array $docs * @access public * @return array */ public function batchCheckPrivDoc(array $docs): array { $libIdList = array_column($docs, 'lib'); $libs = $this->dao->select('id,type,product,project,execution,addedBy,acl,users,`groups`')->from(TABLE_DOCLIB)->where('id')->in($libIdList)->fetchAll('id'); $hasPrivDocs = array(); foreach($docs as $doc) { if(!$this->checkPrivLib(zget($libs, $doc->lib, null), '', (string)$doc->id)) continue; if(!$this->checkPrivDoc($doc, false)) continue; $hasPrivDocs[$doc->id] = $doc; } return $hasPrivDocs; } /** * 检查文档权限。 * Check privilege for the document. * * @param object $doc * @access public * @return bool */ public function checkPrivDoc(object $doc, bool $checkLib = true): bool { if(!isset($doc->lib)) return false; /* Asset document don't check privilege. */ if((isset($doc->assetLibType) && $doc->assetLibType) || $doc->type == 'article') return true; /* My document are accessible only to the creator. */ if($doc->status == 'draft' && $doc->addedBy != $this->app->user->account) return false; if($doc->status == 'normal' && $this->app->user->admin) return true; if(empty($doc->templateType)) { static $libs = array(); if($checkLib) { if(!isset($libs[$doc->lib])) $libs[$doc->lib] = $this->getLibByID((int)$doc->lib); if(!$this->checkPrivLib($libs[$doc->lib], '', (string)$doc->id)) return false; } } if(in_array($doc->acl, array('open', 'public'))) return true; /* Whitelist users can access private document. */ $account = $this->app->user->account; if(isset($doc->addedBy) && $doc->addedBy == $account) return true; if(strpos(",{$doc->users},", ",{$account},") !== false || strpos(",{$doc->readUsers},", ",{$account},") !== false) return true; if($doc->groups || $doc->readGroups) { foreach($this->app->user->groups as $groupID) { if(strpos(",{$doc->groups},", ",{$groupID},") !== false || strpos(",{$doc->readGroups},", ",{$groupID}") !== false) return true; } } return false; } /** * 通过对象ID获取文档库。 * Get libs by object. * * @param string $type * @param int $objectID * @param int $appendLib * @param int $limit * @access public * @return array */ public function getLibsByObject(string $type, int $objectID = 0, int $appendLib = 0, int $limit = 0): array { if(common::isTutorialMode()) return $this->loadModel('tutorial')->getDocLibs(); if(!in_array($type, array('mine', 'custom', 'product', 'project', 'execution', 'doctemplate'))) return array(); if(in_array($type, array('mine', 'custom', 'doctemplate'))) { $objectLibs = $this->dao->select('*')->from(TABLE_DOCLIB) ->where('deleted')->eq(0) ->andWhere('vision')->eq($this->config->vision) ->andWhere('type')->eq($type) ->andWhere('parent')->eq($objectID) ->beginIF(!empty($appendLib))->orWhere('id')->eq($appendLib)->fi() ->orderBy('`order` asc, id_asc') ->limit($limit) ->fetchAll('id', false); } else { $objectLibs = $this->dao->select('*')->from(TABLE_DOCLIB) ->where('deleted')->eq(0) ->andWhere('vision')->eq($this->config->vision) ->andWhere($type)->eq($objectID) ->beginIF($type == 'project')->andWhere('type')->in('api,project')->fi() ->beginIF(!empty($appendLib))->orWhere('id')->eq($appendLib)->fi() ->orderBy('`order` asc, id_asc') ->limit($limit) ->fetchAll('id', false); $executionIDList = array(); if($type == 'project') $executionIDList = $this->loadModel('execution')->getPairs($objectID, 'all', 'multiple,leaf'); if($executionIDList) { $objectLibs += $this->dao->select('*')->from(TABLE_DOCLIB) ->where('deleted')->eq(0) ->andWhere('vision')->eq($this->config->vision) ->andWhere('execution')->in(array_keys($executionIDList)) ->andWhere('type')->eq('execution') ->beginIF(!empty($appendLib))->orWhere('id')->eq($appendLib)->fi() ->orderBy('`order` asc, id_asc') ->limit($limit) ->fetchAll('id', false); } } $libs = array(); foreach($objectLibs as $lib) { if($this->checkPrivLib($lib)) $libs[$lib->id] = $lib; } $itemCounts = $this->statLibCounts(array_keys($libs)); foreach($libs as $libID => $lib) $libs[$libID]->allCount = $itemCounts[$libID]; return $libs; } /** * 获取指定类型各个子空间文档库概要信息。 * Get doclib summary of each sub space. * * @param string $type * @param array $libIDList * @param int $limit * @access public * @return array */ public function getLibsOfSpaces(string $type, string|array $spaceList, $limit = 5) { if(is_string($spaceList)) $spaceList = explode(',', $spaceList); if(empty($spaceList)) return array(); $map = array(); $libIDList = array(); foreach($spaceList as $spaceID) { $libs = $this->getLibsByObject($type, (int)$spaceID, 0, $limit); $libIDList = array_merge($libIDList, array_keys($libs)); $map[$spaceID] = array_values($libs); } $docs = $this->dao->select("`id`,`addedBy`,`type`,`lib`,`acl`,`users`,`readUsers`,`groups`,`readGroups`,`status`,`path`,`deleted`")->from(TABLE_DOC) ->where('lib')->in($libIDList) ->andWhere('builtIn')->eq('0') ->andWhere('type')->ne('chapter') ->fetchAll(); $docs = $this->docTao->filterDeletedDocs($docs); $docs = $this->batchCheckPrivDoc($docs); $docCounts = array(); foreach($docs as $doc) { if(!isset($docCounts[$doc->lib])) $docCounts[$doc->lib] = 0; $docCounts[$doc->lib] ++; } $executionLibs = array(); foreach($map as $spaceID => &$libs) { foreach($libs as &$lib) { $lib->docs = isset($docCounts[$lib->id]) ? $docCounts[$lib->id] : 0; if($lib->type != 'execution') continue; if(!isset($executionLibs[$lib->execution])) $executionLibs[$lib->execution] = array(); $executionLibs[$lib->execution][] = $lib; } } if(!empty($executionLibs)) { $executionPairs = $this->dao->select('id,name')->from(TABLE_EXECUTION)->where('id')->in(array_keys($executionLibs))->fetchPairs(); foreach($executionLibs as $executionID => &$libList) { foreach($libList as &$lib) { $lib->originName = $lib->name; $lib->executionName = $executionPairs[$executionID]; $lib->name = $lib->executionName . '/' . $lib->name; } } } return $map; } /** * 获取空间下的文档库。 * Get libs of space. * * @param string $type * @param int $spaceID * @access public * @return array */ public function getLibsOfSpace(string $type, int $spaceID): array { $libs = $this->getLibsByObject($type, $spaceID); $executionIDList = array(); $apiLibs = array(); foreach($libs as &$lib) { if($lib->type == 'api') $apiLibs[$lib->id] = $lib; if($lib->type != 'execution') continue; $executionIDList[] = $lib->execution; } if($type == 'project' && !empty($executionIDList)) { $executionPairs = $this->dao->select('id,name')->from(TABLE_EXECUTION)->where('id')->in($executionIDList)->filterTpl('skip')->fetchPairs(); foreach($libs as &$lib) { if($lib->type != 'execution') continue; $lib->originName = $lib->name; $lib->executionName = $executionPairs[$lib->execution]; $lib->name = $lib->executionName . '/' . $lib->name; } } if(!empty($apiLibs)) { $releases = $this->loadModel('api')->getReleaseByQuery(array_keys($apiLibs)); $releaseMap = array(); foreach($releases as $release) $releaseMap[$release->lib][] = $release; foreach($apiLibs as &$lib) $lib->versions = isset($releaseMap[$lib->id]) ? $releaseMap[$lib->id] : array(); } return $libs; } /** * 获取已排序的对象数据。 * Get ordered objects for doc. * * @param string $objectType * @param string $returnType nomerge|merge * @param int $append * @access public * @return array */ public function getOrderedObjects(string $objectType = 'product', string $returnType = 'merge', int $append = 0): array { $myObjects = $normalObjects = $closedObjects = array(); if($objectType == 'product') { list($myObjects, $normalObjects, $closedObjects) = $this->getOrderedProducts($append); } elseif($objectType == 'project') { list($myObjects, $normalObjects, $closedObjects) = $this->getOrderedProjects($append); } elseif($objectType == 'execution') { list($myObjects, $normalObjects, $closedObjects) = $this->docTao->getOrderedExecutions($append); } if($returnType == 'nomerge') return array($myObjects, $normalObjects, $closedObjects); return $myObjects + $normalObjects + $closedObjects; } /** * 获取已排序的产品数据。 * Get ordered products. * * @param int $append * @access public * @return array */ public function getOrderedProducts(int $append = 0): array { $myObjects = $normalObjects = $closedObjects = array(); $products = $this->loadModel('product')->getList(); if($append && !isset($products[$append])) $products[$append] = $this->product->getByID($append); foreach($products as $id => $product) { if(!$product) continue; if($product->status != 'closed' && $product->PO == $this->app->user->account) { $myObjects[$id] = $product->name; } elseif($product->status != 'closed' && !($product->PO == $this->app->user->account)) { $normalObjects[$id] = $product->name; } elseif($product->status == 'closed') { $closedObjects[$id] = $product->name; } } return array($myObjects, $normalObjects, $closedObjects); } /** * 获取已排序的项目数据。 * Get ordered projects. * * @param int $append * @access public * @return array */ public function getOrderedProjects(int $append = 0): array { $this->loadModel('program'); /* Project permissions for DocLib whitelist. */ $myObjects = $normalObjects = $closedObjects = array(); $orderedProjects = array(); if($this->app->tab == 'doc') { $myObjects = $this->dao->select('t1.id, t1.name')->from(TABLE_PROJECT)->alias('t1') ->leftJoin(TABLE_DOCLIB)->alias('t2')->on('t2.project=t1.id') ->where("CONCAT(',', t2.users, ',')")->like("%,{$this->app->user->account},%") ->andWhere('t1.vision')->eq($this->config->vision) ->andWhere('t1.deleted')->eq(0) ->beginIF(!$this->app->user->admin)->andWhere('t1.id')->in($this->app->user->view->projects)->fi() ->fetchPairs(); } $objects = $this->dao->select('*')->from(TABLE_PROJECT) ->where('type')->eq('project') ->andWhere('vision')->eq($this->config->vision) ->andWhere('deleted')->eq(0) ->beginIF(!$this->app->user->admin)->andWhere('id')->in($this->app->user->view->projects)->fi() ->beginIF($append)->orWhere('id')->eq($append)->fi() ->orderBy('order_asc') ->fetchAll('id', false); foreach($objects as $objectID => $object) { $object->parent = $this->program->getTopByID($object->parent); $orderedProjects[$objectID] = $object; unset($objects[$object->id]); } foreach($orderedProjects as $id => $project) { if($project->status != 'done' && $project->status != 'closed' && $project->PM == $this->app->user->account) { $myObjects[$id] = $project->name; } elseif($project->status != 'done' && $project->status != 'closed' && !($project->PM == $this->app->user->account)) { $normalObjects[$id] = $project->name; } elseif($project->status == 'done' || $project->status == 'closed') { $closedObjects[$id] = $project->name; } } return array($myObjects, $normalObjects, $closedObjects); } /** * 统计文档库下的模块和文档数量。 * Stat module and document counts of lib. * * @param array $idList * @access public * @return array */ public function statLibCounts(array $idList): array { if(empty($idList)) return array(); $moduleCounts = $this->dao->select("`root`, count(id) as moduleCount")->from(TABLE_MODULE) ->where('type')->eq('doc') ->andWhere('root')->in($idList) ->andWhere('deleted')->eq(0) ->groupBy('root') ->fetchPairs(); $docs = $this->dao->select("`id`,`addedBy`,`type`,`lib`,`acl`,`users`,`readUsers`,`groups`,`readGroups`,`status`,`path`,`deleted`")->from(TABLE_DOC) ->where('lib')->in($idList) ->andWhere('type')->ne('chapter') ->andWhere('deleted')->eq('0') ->andWhere('builtIn')->eq('0') ->andWhere('module')->eq('0') ->fetchAll(); $docs = $this->docTao->filterDeletedDocs($docs); $docs = $this->batchCheckPrivDoc($docs); $docCounts = array(); foreach($docs as $doc) { if(!isset($docCounts[$doc->lib])) $docCounts[$doc->lib] = 0; $docCounts[$doc->lib] ++; } $itemCounts = array(); foreach($idList as $libID) { $docCount = isset($docCounts[$libID]) ? $docCounts[$libID] : 0; $moduleCount = isset($moduleCounts[$libID]) ? $moduleCounts[$libID] : 0; $itemCounts[$libID] = $docCount + $moduleCount; } return $itemCounts; } /** * 获取文档库的附件。 * Get lib files. * * @param string $type product|project|execution * @param int $objectID * @param string|bool $searchTitle * @param string $browseType * @param int $param * @param string $orderBy * @param object $pager * @access public * @return array */ public function getLibFiles(string $type, int $objectID, string $browseType = '', int $param = 0, string $orderBy = 'id_desc', ?object $pager = null): array { if(!in_array($type, array('execution', 'project', 'product'))) return array(); $searchModule = "{$type}DocFile"; $queryID = (int)$param; $this->loadModel('search')->setQuery($searchModule, $queryID); $docFileQuery = $this->session->{$searchModule . 'Query'}; list($bugIdList, $testReportIdList, $caseIdList, $docIdList, $storyIdList, $epicIdList, $requirementIdList, $planIdList, $releaseIdList, $issueIdList, $meetingIdList, $reviewIdList, $designIdList, $executionIdList, $taskIdList, $buildIdList, $testtaskIdList, $resultIdList) = $this->getLinkedObjectData($type, $objectID); $files = $this->dao->select('*')->from(TABLE_FILE) ->where('size')->gt('0') ->andWhere('deleted')->eq('0') ->andWhere("(objectType = '$type' and objectID = $objectID)", true) ->beginIF($docIdList)->orWhere("(objectType = 'doc' and objectID in ($docIdList))")->fi() ->orWhere("(objectType = 'bug' and objectID in ($bugIdList))") ->orWhere("(objectType = 'testreport' and objectID in ($testReportIdList))") ->orWhere("(objectType = 'testcase' and objectID in ($caseIdList))") ->beginIF($type == 'product') ->orWhere("(objectType in ('story', 'requirement', 'epic') and objectID in ($storyIdList))") ->orWhere("(objectType = 'release' and objectID in ($releaseIdList))") ->orWhere("(objectType = 'productplan' and objectID in ($planIdList))") ->orWhere("(objectType = 'stepResult' and objectID in ($resultIdList))") ->fi() ->beginIF($type == 'project') ->orWhere("(objectType = 'execution' and objectID in ($executionIdList))") ->orWhere("(objectType = 'issue' and objectID in ($issueIdList))") ->orWhere("(objectType = 'review' and objectID in ($reviewIdList))") ->orWhere("(objectType = 'meeting' and objectID in ($meetingIdList))") ->orWhere("(objectType = 'design' and objectID in ($designIdList))") ->fi() ->beginIF($type == 'project' || $type == 'execution') ->orWhere("(objectType = 'task' and objectID in ($taskIdList))") ->orWhere("(objectType = 'build' and objectID in ($buildIdList))") ->orWhere("(objectType = 'testtask' and objectID in ($testtaskIdList))") ->beginIF($storyIdList)->orWhere("(objectType = 'story' and objectID in ($storyIdList))")->fi() ->fi() ->markRight(1) ->beginIF($browseType == 'bySearch')->andWhere("($docFileQuery)")->fi() ->orderBy($orderBy) ->page($pager) ->fetchAll('id', false); $this->loadModel('file'); $testResults = empty($resultIdList) ? array() : $this->dao->select('id,`case`')->from(TABLE_TESTRESULT)->where('id')->in($resultIdList)->fetchPairs('id', 'case'); foreach($files as $file) { $this->file->setFileWebAndRealPaths($file); $file->rawObjectType = $file->objectType; if($file->objectType == 'story' && $type == 'product') { if(in_array($file->objectID, $epicIdList)) $file->objectType = 'epic'; if(in_array($file->objectID, $requirementIdList)) $file->objectType = 'requirement'; } if($file->objectType == 'stepResult' && $testResults[$file->objectID]) { $file->objectType = 'testcase'; $file->objectID = $testResults[$file->objectID]; } } return $files; } /** * 获取关联产品/项目/执行的数据。 * Get linked product/project/execution data. * * @param string $type product|project|execution * @param int $objectID * @access public * @return array */ public function getLinkedObjectData(string $type, int $objectID): array { if(!in_array($type, array('execution', 'project', 'product'))) return array(); $userView = $this->app->user->view->products; if($type == 'project') $userView = $this->app->user->view->projects; if($type == 'execution') $userView = $this->app->user->view->sprints; $bugIdList = $testReportIdList = $caseIdList = $resultIdList = $testtaskIdList = $storyIdList = $epicIdList = $requirementIdList = $planIdList = $releaseIdList = $executionIdList = $taskIdList = $buildIdList = $issueIdList = $meetingIdList = $designIdList = $reviewIdList = 0; $bugPairs = $this->dao->select('id')->from(TABLE_BUG)->where($type)->eq($objectID)->andWhere('deleted')->eq('0')->beginIF(!$this->app->user->admin)->andWhere($type)->in($userView)->fi()->fetchPairs('id'); if(!empty($bugPairs)) $bugIdList = implode(',', $bugPairs); $testReportPairs = $this->dao->select('id')->from(TABLE_TESTREPORT)->where($type)->eq($objectID)->andWhere('deleted')->eq('0')->beginIF(!$this->app->user->admin)->andWhere($type)->in($userView)->fi()->fetchPairs('id'); if(!empty($testReportPairs)) $testReportIdList = implode(',', $testReportPairs); $field = $type == 'execution' ? 'project' : $type; $casePairs = $this->dao->select('`case`')->from(TABLE_PROJECTCASE)->where($field)->eq($objectID)->beginIF(!$this->app->user->admin)->andWhere($field)->in($userView)->fi()->fetchPairs('case'); if(!empty($casePairs)) $caseIdList = implode(',', $casePairs); $docs = $this->dao->select('*')->from(TABLE_DOC)->where($type)->eq($objectID)->fetchAll('id', false); $docs = $this->batchCheckPrivDoc($docs); $docIdList = empty($docs) ? 0 : $this->dao->select('id')->from(TABLE_DOC)->where($type)->eq($objectID)->andWhere('vision')->eq($this->config->vision)->andWhere('id')->in(array_keys($docs))->get(); if($type == 'product') { list($storyIdList, $epicIdList, $requirementIdList, $planIdList, $releasePairs, $casePairs, $resultPairs) = $this->docTao->getLinkedProductData($objectID, $userView); if(!empty($releasePairs)) $releaseIdList = implode(',', $releasePairs); if(!empty($casePairs)) $caseIdList = implode(',', $casePairs); if(!empty($resultPairs)) $resultIdList = implode(',', $resultPairs); } elseif($type == 'project') { list($storyIdList, $issueIdList, $meetingIdList, $reviewIdList, $designIdList, $executionIdList, $taskIdList, $buildIdList) = $this->getLinkedProjectData($objectID); } elseif($type == 'execution') { list($storyIdList, $taskIdList, $buildIdList, $testtaskIdList) = $this->getLinkedExecutionData($objectID); } return array($bugIdList, $testReportIdList, $caseIdList, $docIdList, $storyIdList, $epicIdList, $requirementIdList, $planIdList, $releaseIdList, $issueIdList, $meetingIdList, $reviewIdList, $designIdList, $executionIdList, $taskIdList, $buildIdList, $testtaskIdList, $resultIdList); } /** * 获取关联项目的数据。 * Get linked project data. * * @param int $projectID * @access public * @return array */ public function getLinkedProjectData(int $projectID): array { $project = $this->loadModel('project')->getByID($projectID); $storyIdList = $issueIdList = $meetingIdList = $reviewIdList = $designIdList = $executionIdList = $taskIdList = $buildIdList = 0; $projectIDList = $this->dao->select('*')->from(TABLE_PROJECT)->where('id')->eq($projectID)->orWhere('project')->eq($projectID)->fetchPairs('id', 'id'); $storyIdList = $this->dao->select('story')->from(TABLE_PROJECTSTORY)->where('project')->in($projectIDList)->fetchPairs('story', 'story'); if(in_array($this->config->edition, array('max', 'ipd'))) { $issueIdList = $this->dao->select('id')->from(TABLE_ISSUE) ->where('project')->eq($projectID) ->andWhere('deleted')->eq('0') ->beginIF(!$this->app->user->admin)->andWhere('project')->in($this->app->user->view->projects)->fi() ->get(); $meetingIdList = $this->dao->select('id')->from(TABLE_MEETING) ->where('project')->eq($projectID) ->andWhere('deleted')->eq('0') ->beginIF(!$this->app->user->admin)->andWhere('project')->in($this->app->user->view->projects)->fi() ->get(); $reviewIdList = $this->dao->select('id')->from(TABLE_REVIEW) ->where('project')->eq($projectID) ->andWhere('deleted')->eq('0') ->beginIF(!$this->app->user->admin)->andWhere('project')->in($this->app->user->view->projects)->fi() ->get(); } $designIdList = $this->dao->select('id')->from(TABLE_DESIGN) ->where('project')->eq($projectID) ->andWhere('deleted')->eq('0') ->beginIF(!$this->app->user->admin)->andWhere('project')->in($this->app->user->view->projects)->fi() ->get(); $executionIdList = $this->loadModel('execution')->getIdList($projectID); $taskPairs = $this->dao->select('id')->from(TABLE_TASK) ->where('execution')->in($executionIdList) ->andWhere('deleted')->eq('0') ->beginIF(!$this->app->user->admin)->andWhere('execution')->in($this->app->user->view->sprints)->fi() ->fetchPairs('id'); if(!empty($taskPairs)) $taskIdList = implode(',', $taskPairs); $buildPairs = $this->dao->select('id')->from(TABLE_BUILD) ->where('execution')->in($executionIdList) ->andWhere('deleted')->eq('0') ->beginIF(!$this->app->user->admin)->andWhere('execution')->in($this->app->user->view->sprints)->fi() ->fetchPairs('id'); if(!empty($buildPairs)) $buildIdList = implode(',', $buildPairs); $executionIdList = $executionIdList ? implode(',', $executionIdList) : 0; $storyIdList = $storyIdList ? implode(',', $storyIdList) : 0; return array($storyIdList, $issueIdList, $meetingIdList, $reviewIdList, $designIdList, $executionIdList, $taskIdList, $buildIdList); } /** * 获取关联执行的数据。 * Get linked execution data. * * @param int $executionID * @access public * @return array */ public function getLinkedExecutionData(int $executionID): array { $storyIdList = $taskIdList = $buildIdList = $testtaskIdList = 0; $execution = $this->loadModel('execution')->getByID($executionID); $project = $execution ? $this->loadModel('project')->getByID((int)$execution->project) : ''; if($project && !$project->hasProduct) $storyIdList = $this->dao->select('story')->from(TABLE_PROJECTSTORY)->where('project')->eq($executionID)->fetchPairs('story', 'story'); $storyIdList = $storyIdList ? implode(',', $storyIdList) : ''; $taskPairs = $this->dao->select('id')->from(TABLE_TASK) ->where('execution')->eq($executionID) ->andWhere('deleted')->eq('0') ->beginIF(!$this->app->user->admin)->andWhere('execution')->in($this->app->user->view->sprints)->fi() ->fetchPairs('id'); if(!empty($taskPairs)) $taskIdList = implode(',', $taskPairs); $buildPairs = $this->dao->select('id')->from(TABLE_BUILD) ->where('execution')->eq($executionID) ->andWhere('deleted')->eq('0') ->beginIF(!$this->app->user->admin)->andWhere('execution')->in($this->app->user->view->sprints)->fi() ->fetchPairs('id'); if(!empty($buildPairs)) $buildIdList = implode(',', $buildPairs); $testtaskPairs = $this->dao->select('id')->from(TABLE_TESTTASK) ->where('execution')->eq($executionID) ->andWhere('deleted')->eq('0') ->beginIF(!$this->app->user->admin)->andWhere('execution')->in($this->app->user->view->sprints)->fi() ->fetchPairs('id'); if(!empty($testtaskPairs)) $testtaskIdList = implode(',', $testtaskPairs); return array($storyIdList, $taskIdList, $buildIdList, $testtaskIdList); } /** * 获取附件的来源。 * Get file source pairs. * * @param array $files * @access public * @return array */ public function getFileSourcePairs(array $files): array { $sourceList = array(); $sourcePairs = array(); foreach($files as $file) { if(!isset($sourceList[$file->objectType])) $sourceList[$file->objectType] = array(); $sourceList[$file->objectType][$file->objectID] = $file->objectID; } $this->app->loadConfig('action'); foreach($sourceList as $type => $idList) { $table = zget($this->config->objectTables, $type, ''); $field = zget($this->config->action->objectNameFields, $type, ''); if(empty($table) || empty($field)) continue; $sourcePairs[$type] = $this->dao->select('id,' . $field)->from($table)->where('id')->in($idList)->fetchPairs('id', $field); } return $sourcePairs; } /** * 获取文件图标。 * Get file icon. * * @param array $files * @access public * @return array */ public function getFileIcon(array $files): array { $this->app->loadConfig('file'); $fileIcon = array(); foreach($files as $file) { if(in_array($file->extension, $this->config->file->imageExtensions)) continue; switch($file->extension) { case in_array($file->extension, array('zip', 'tar', 'gz', 'bz2', 'rar')): $iconClass = 'icon-file-archive'; break; case in_array($file->extension, array('csv', 'xls', 'xlsx')): $iconClass = 'icon-file-excel'; break; case in_array($file->extension, array('doc', 'docx')): $iconClass = 'icon-file-word'; break; case in_array($file->extension, array('ppt', 'pptx')): $iconClass = 'icon-file-powerpoint'; break; case in_array($file->extension, array('pdf')): $iconClass = 'icon-file-pdf'; break; case in_array($file->extension, array('mp3', 'ogg', 'wav')): $iconClass = 'icon-file-audio'; break; case in_array($file->extension, array('avi', 'mp4', 'mov')): $iconClass = 'icon-file-video'; break; case in_array($file->extension, array('txt', 'md')): $iconClass = 'icon-file-text'; break; case in_array($file->extension, array('html', 'htm')): $iconClass = 'icon-file-globe'; break; default: $iconClass = 'icon-file'; break; } $fileIcon[$file->id] = ""; } return $fileIcon; } /** * 获取文档的树形结构。 * Get doc tree. * * @param int $libID * @access public * @return array */ public function getDocTree(int $libID): array { $docTrees = $this->loadModel('tree')->getTreeStructure($libID, 'doc'); array_unshift($docTrees, array('id' => 0, 'name' => '/', 'type' => 'doc', 'actions' => false, 'root' => $libID)); foreach($docTrees as $i => $tree) { $tree = (object)$tree; $docTrees[$i] = $this->buildDocNode($tree, $libID); } if(empty($docTrees[0]->children)) array_shift($docTrees); return $docTrees; } /** * 构造文档节点。 * Build doc node. * * @param object $node * @param int $libID * @access public * @return object */ public function buildDocNode(object $node, int $libID): object { $node = (object)$node; static $docGroups; if(empty($docGroups)) { $docs = $this->dao->select('*')->from(TABLE_DOC)->where('lib')->eq($libID)->andWhere('deleted')->eq(0)->fetchAll('', false); $docs = $this->batchCheckPrivDoc($docs); $docGroups = array(); foreach($docs as $doc) $docGroups[$doc->module][$doc->id] = $doc; } if(!empty($node->children)) foreach($node->children as $i => $child) $node->children[$i] = $this->buildDocNode($child, $libID); if(!isset($node->id)) $node->id = 0; $node->type = 'module'; $docs = isset($docGroups[$node->id]) ? $docGroups[$node->id] : array(); $menu = !empty($node->children) ? $node->children : array(); if(!empty($docs)) { $docItems = array(); foreach($docs as $doc) { $docItem = new stdclass(); $docItem->type = 'doc'; $docItem->id = $doc->id; $docItem->title = $doc->title; $docItem->acl = $doc->acl; $docItem->url = helper::createLink('doc', 'view', "doc=$doc->id"); $buttons = ''; if(common::hasPriv('doc', 'edit')) $buttons .= html::a(helper::createLink('doc', 'edit', "docID={$doc->id}"), "", 'hiddenwin', "class='btn-icon' title='{$this->lang->doc->edit}'"); if(common::hasPriv('doc', 'delete')) $buttons .= html::a(helper::createLink('doc', 'delete', "docID={$doc->id}"), "", 'hiddenwin', "class='btn-icon' title='{$this->lang->doc->delete}'"); $docItem->buttons = $buttons; $docItem->actions = false; $docItems[] = $docItem; } /* Reorder children. The doc is top of menu. */ if($menu) $docItems = array_merge($docItems, $menu); $node->children = $docItems; } $node->docsCount = isset($node->children) ? count($node->children) : 0; $node->actions = false; return $node; } /** * 获取文档的统计信息。 * Get statistic information. * * @access public * @return object */ public function getStatisticInfo(): object { $today = date('Y-m-d'); $statistic = new stdclass(); $statistic->totalDocs = $this->dao->select('COUNT(1) AS count')->from(TABLE_DOC) ->where('deleted')->eq('0') ->andWhere('type')->in($this->config->doc->docTypes) ->andWhere('templateType')->eq('') ->andWhere('vision')->eq($this->config->vision) ->fetch('count'); $statistic->todayEditedDocs = $this->dao->select('count(DISTINCT `objectID`) as count')->from(TABLE_ACTION)->alias('t1') ->leftJoin(TABLE_DOC)->alias('t2')->on("t1.`objectID`=t2.id and t1.`objectType`='doc'") ->where('t1.objectType')->eq('doc') ->andWhere('t1.action')->eq('edited') ->andWhere('t1.actor')->eq($this->app->user->account) ->andWhere('t1.vision')->eq($this->config->vision) ->andWhere('LEFT(t1.date, 10)')->eq($today) ->andWhere('t2.deleted')->eq(0) ->andWhere('t2.type')->in($this->config->doc->docTypes) ->fetch('count'); $statistic->myEditedDocs = $this->dao->select('count(DISTINCT t1.`objectID`) as count')->from(TABLE_ACTION)->alias('t1') ->leftJoin(TABLE_DOC)->alias('t2')->on("t1.`objectID`=t2.id and t1.`objectType`='doc'") ->where('t1.objectType')->eq('doc') ->andWhere('t1.action')->eq('edited') ->andWhere('t1.actor')->eq($this->app->user->account) ->andWhere('t1.vision')->eq($this->config->vision) ->andWhere('t2.lib')->ne(0) ->andWhere('t2.deleted')->eq(0) ->andWhere('t2.type')->in($this->config->doc->docTypes) ->fetch('count'); $myStatistic = $this->dao->select("COUNT(1) AS `myDocs`, SUM(views) as `docViews`, SUM(collects) as `docCollects`")->from(TABLE_DOC) ->where('addedBy')->eq($this->app->user->account) ->andWhere('type')->in($this->config->doc->docTypes) ->andWhere('templateType')->eq('') ->andWhere('deleted')->eq(0) ->andWhere('vision')->eq($this->config->vision) ->andWhere('lib')->ne(0) ->fetch(); $statistic->myDocs = $myStatistic->myDocs; $statistic->myDoc = new stdclass(); $statistic->myDoc->docViews = $myStatistic->docViews; $statistic->myDoc->docCollects = $myStatistic->docCollects; return $statistic; } /** * 获取收信人和抄送人列表。 * Get toList and ccList. * * @param object $doc * @access public * @return bool|array */ public function getToAndCcList(object $doc): bool|array { /* Set toList and ccList. */ $toList = ''; $ccList = str_replace(' ', '', trim($doc->mailto, ',')); if(empty($ccList)) return false; if(strpos($ccList, ',') === false) { $toList = $ccList; $ccList = ''; } else { $commaPos = strpos($ccList, ','); $toList = substr($ccList, 0, $commaPos); $ccList = substr($ccList, $commaPos + 1); } return array($toList, $ccList); } /** * 获取下拉菜单的链接。 * Get the dropmenu link. * * @param string $type product|project * @param int $objectID * @access public * @return string */ public function getDropMenuLink(string $type, int $objectID): string { if(!in_array($type, array('product', 'project'))) return ''; $currentModule = $this->app->rawModule; $currentMethod = $this->app->rawMethod; if($currentModule == 'api' && $currentMethod == 'index') { $currentModule = 'doc'; $currentMethod = $type . 'Space'; } return helper::createLink('doc', 'ajaxGetDropMenu', "objectType={$type}&objectID={$objectID}&module={$currentModule}&method={$currentMethod}"); } /** * 统计当前页面上文件的数量和大小。 * Count the number and size of files on the current page. * * @param array $files * @access public * @return string */ public function summary(array $files): string { $filesCount = 0; $sizeCount = 0; $extensionCount = array(); $extensionSummary = ''; foreach($files as $file) { if(!isset($extensionCount[$file->extension])) $extensionCount[$file->extension] = 0; $sizeCount += $file->size; $filesCount++; $extensionCount[$file->extension] ++; } /* Unit conversion. */ $i = 0; while ($sizeCount > 1024 and $i <= 4) { $sizeCount = $sizeCount / 1024; $i++; } $unitList = array('B', 'K', 'M', 'G', 'T'); $sizeCount = round($sizeCount, 1) . $unitList[$i]; /* Summary of each type. */ foreach($extensionCount as $extension => $count) { if(in_array($this->app->getClientLang(), array('zh-cn', 'zh-tw'))) { $extensionSummary .= $extension . ' ' . $count . $this->lang->doc->ge . $this->lang->doc->point; } else { $extensionSummary .= $extension . ' ' . $this->lang->doc->ge . ' ' . $count . $this->lang->doc->point; } } $extensionSummary = rtrim($extensionSummary, $this->lang->doc->point); return sprintf($this->lang->doc->summary, $filesCount, $sizeCount, $extensionSummary); } /** * 设置文档的导航。 * Set doc menu by type. * * @param string $type mine|project|execution|product|custom * @param int $objectID * @param int $libID * @param int $appendLib * @access public * @return array|string */ public function setMenuByType(string $type, int $objectID, int $libID, int $appendLib = 0): array|string { if(empty($type)) { $doclib = $this->getLibByID($libID); $type = $doclib->type == 'execution' ? 'project' : $doclib->type; $objectID = isset($doclib->{$type}) ? $doclib->{$type} : 0; } $isExecution = in_array($this->app->tab, array('project', 'doc')) && $type == 'execution'; $type = $isExecution ? 'project' : $type; $objectDropdown = array('text' => '', 'link' => ''); $appendObject = $objectID; if(in_array($type, array('project', 'product', 'execution'))) { $object = $this->dao->select('id,name,status,deleted' . ($isExecution ? ',project' : ''))->from($this->config->objectTables[$type])->where('id')->eq($objectID)->fetch(); $objectID = $isExecution ? (int)$object->project : $objectID; if(empty($object)) return helper::createLink($type, $type == 'project' && $this->config->vision != 'lite' ? 'createGuide' : 'create', $type == 'project' && $this->config->vision == 'lite' ? 'model=kanban' : ''); $this->loadModel($type); $objects = $this->getOrderedObjects($type, 'merge', $objectID); $objectID = method_exists($this->$type, 'saveState') ? $this->{$type}->saveState($objectID, $objects) : $this->{$type}->checkAccess($objectID, $objects); $libs = $this->getLibsByObject($type, $objectID, $appendLib); if(($libID == 0 || !isset($libs[$libID])) && !empty($libs)) $libID = reset($libs)->id; if($this->app->tab != 'doc' && isset($libs[$libID])) { $objectDropdown['text'] = zget($libs[$libID], 'name', ''); } else { $objectDropdown['text'] = zget($objects, $objectID, ''); $objectDropdown['link'] = $this->getDropMenuLink($type, $appendObject); } } else { if($type == 'custom' || $type == 'doctemplate') { $spaces = $type == 'custom' ? $this->getTeamSpaces() : $this->getDocTemplateSpaces(); if(empty($objectID)) $objectID = (int)key($spaces); if(!isset($spaces[$objectID])) $objectID = (int)key($spaces); } $libs = $this->getLibsByObject($type, $objectID, $appendLib); if(($libID == 0 || !isset($libs[$libID])) && !empty($libs)) $libID = reset($libs)->id; if(isset($libs[$libID])) $objectDropdown['text'] = zget($libs[$libID], 'name', ''); if($type == 'custom' || $type == 'doctemplate') { $spaceExtra = $type == 'custom' ? 'nomine' : 'doctemplate'; $objectDropdown['text'] = zget($spaces, $objectID, ''); $objectDropdown['link'] = helper::createLink('doc', 'ajaxGetSpaceMenu', "libID={$objectID}&module={$this->app->rawModule}&method={$this->app->rawMethod}&extra={$spaceExtra}"); } $object = $this->dao->select('id,name,deleted')->from(TABLE_DOCLIB)->where('id')->eq($objectID)->fetch(); } $tab = strpos(',my,doc,product,project,execution,', ",{$this->app->tab},") !== false ? $this->app->tab : 'doc'; if($type == 'mine') $type = 'my'; if($type == 'custom') $type = 'team'; if($tab == 'doc' && !common::hasPriv('doc', $type . 'Space')) return helper::createLink('user', 'deny', "module=doc&method={$type}Space"); if($tab != 'doc' && method_exists($type . 'Model', 'setMenu')) { $this->loadModel($type)->setMenu($objectID); } elseif($tab == 'doc' && isset($this->lang->doc->menu->{$type}['alias'])) { $this->lang->doc->menu->{$type}['alias'] .= ',' . $this->app->rawMethod; } return array($libs, $libID, $object, $objectID, $objectDropdown); } /** * 通过搜索获取文档列表数据。 * Get docs by search. * * @param string $type product|project|execution|custom|book * @param int $objectID * @param int $libID * @param int $queryID * @param string $orderBy * @param object $pager * @access public * @return array */ public function getDocsBySearch(string $type, int $objectID, int $libID, int $queryID, string $orderBy = 'id_desc', ?object $pager = null): array { $query = $this->buildQuery($type, $queryID); $libs = $this->getLibsByObject($type, $objectID, $libID); $docIdList = $this->getPrivDocs(array_keys($libs)); $docs = $this->dao->select('*')->from(TABLE_DOC) ->where('deleted')->eq(0) ->andWhere('builtIn')->eq('0') ->andWhere($query) ->andWhere('lib')->in(array_keys($libs)) ->andWhere('vision')->eq($this->config->vision) ->beginIF($this->config->doc->notArticleType)->andWhere('type')->notIN($this->config->doc->notArticleType)->fi() ->beginIF(!empty($docIdList))->andWhere('id')->in($docIdList)->fi() ->andWhere("(status = 'normal' or (status = 'draft' and addedBy='{$this->app->user->account}'))") ->orderBy($orderBy) ->page($pager) ->fetchAll('id', false); $this->loadModel('common')->saveQueryCondition($this->dao->get(), 'doc', true); return $this->processCollector($docs); } /** * 获取给定文档库的目录列表。 * Get modules from libs. * * @param array $libs Lib id list. * @param string $type doc|api * @access public * @return array */ public function getModulesOfLibs(array $libs, $type = 'doc,api') { $types = explode(',', $type); return $this->dao->select('*')->from(TABLE_MODULE) ->where('root')->in($libs) ->beginIF(count($types) > 1)->andWhere('type')->in($types)->fi() ->beginIF(count($types) == 1)->andWhere('type')->eq($type)->fi() ->andWhere('deleted')->eq('0') ->orderBy('grade desc, `order`') ->fetchAll('id', false); } /** * Get module tree. * * @param int $rootID * @param int $moduleID * @param string $type doc|api * @param int $parent * @param array $modules * @access public * @return array */ public function getModuleTree($rootID, $moduleID = 0, $type = 'doc', $parent = 0, $modules = array(), $docID = 0) { if(is_array($modules) and empty($modules)) { $modules = $this->dao->select('*')->from(TABLE_MODULE) ->where('root')->eq((int)$rootID) ->andWhere('type')->eq($type) ->andWhere('deleted')->eq(0) ->orderBy('grade desc, `order`') ->fetchAll('id', false); } $moduleTree = array(); foreach($modules as $module) { if($module->parent != $parent) continue; unset($modules[$module->id]); $item = new stdclass(); $item->id = $module->id; $item->name = $module->name; $item->objectType = $module->type; $item->type = 'module'; $item->libID = $rootID; $item->active = $module->id == $moduleID ? 1 : 0; $item->order = $module->order; $item->children = $this->getModuleTree($rootID, $moduleID, $type, $module->id, $modules, $docID); $showDoc = $this->loadModel('setting')->getItem('owner=' . $this->app->user->account . '&module=doc&key=showDoc'); $showDoc = $showDoc === '0' ? 0 : 1; if($this->app->rawMethod == 'view' and $module->type != 'api' and $showDoc) { $docIDList = $this->getPrivDocs(array($rootID), $module->id); $docs = $this->dao->select('*, title as name')->from(TABLE_DOC) ->where('id')->in($docIDList) ->andWhere('deleted')->eq(0) ->fetchAll('id', false); if(!empty($docs)) { $docs = array_values($docs); foreach($docs as $doc) $doc->active = $doc->id == $docID ? 1 : 0; $item->children = array_merge($docs, $item->children); } } $moduleTree[$module->id] = $item; } return array_values($moduleTree); } /** * 获取文档库的树形结构。 * Get lib tree. * * @param int $libID * @param array $libs * @param string $type mine|product|project|execution|api|custom * @param int $moduleID * @param int $objectID * @param string $browseType bysearch|byrelease * @param int $param * @param int $docID * @access public * @return array */ public function getLibTree(int $libID, array $libs, string $type, int $moduleID, int $objectID = 0, string $browseType = '', int $param = 0, int $docID = 0): array { if(common::isTutorialMode()) return $this->loadModel('tutorial')->getLibTree(); $type = $this->app->tab == 'doc' && $type == 'execution' ? 'project' : $type; list($libTree, $apiLibs, $apiLibIDList) = $this->getObjectTree($libID, $libs, $type, $moduleID, $objectID, strtolower($browseType), $param, $docID); $libTree = $this->processObjectTree($libTree, $type, $libID, $objectID, $apiLibs, $apiLibIDList); if($type != 'project') $libTree = array_values($libTree[$type]); if($type == 'mine') { $children = $libTree; $libType = isset($this->app->rawParams['type']) ? $this->app->rawParams['type'] : ''; $libType = $this->app->rawMethod == 'view' ? 'mine' : $libType; $mineMethods = array('mine' => 'myLib', 'view' => 'myView', 'collect' => 'myCollection', 'createdBy' => 'myCreation', 'editedBy' => 'myEdited'); $libTree = array(); foreach($mineMethods as $type => $mineMethod) { if($mineMethod != 'myLib' && !common::hasPriv('doc', $mineMethod)) continue; $myItem = new stdclass(); $myItem->id = 0; $myItem->name = $type == 'mine' ? '' : $this->lang->doc->{$mineMethod}; $myItem->type = $type; $myItem->objectType = 'doc'; $myItem->objectID = 0; $myItem->hasAction = false; $myItem->active = strtolower($libType) == strtolower($type) ? 1 : 0; if($type == 'mine') $myItem->children = $children; $libTree[] = $myItem; } } return $libTree; } /** * 获取产品、项目、执行文档库的树形结构。 * Get a tree structure of the product, project, and execution document library. * * @param int $libID * @param array $libs * @param string $type mine|product|project|execution|api|custom * @param int $moduleID * @param int $objectID * @param string $browseType bysearch|byrelease * @param int $docID * @param int $param * @access public * @return array */ public function getObjectTree(int $libID, array $libs, string $type, int $moduleID = 0, int $objectID = 0, string $browseType = '', int $param = 0, int $docID = 0): array { if($type == 'project') { $executionLibs = array(); foreach($libs as $lib) { if($lib->type != 'execution') continue; $executionLibs[$lib->execution][$lib->id] = $lib; } $executionPairs = $this->dao->select('id,name')->from(TABLE_EXECUTION)->where('id')->in(array_keys($executionLibs))->fetchPairs(); } $release = $browseType == 'byrelease' && $param ? $this->loadModel('api')->getRelease(0, 'byId', $param) : null; $libTree = array($type => array()); $apiLibs = $apiLibIDList = array(); foreach($libs as $lib) { $item = $this->buildLibItem($libID, $lib, $type, $moduleID, $objectID, $browseType, $docID, $release); if(($type == 'project' && $lib->type != 'execution') || $type != 'project') { if($item->type == 'docLib') $libTree[$lib->type][$lib->id] = $item; if($item->type == 'apiLib') $apiLibs[$lib->id] = $item; } else { $executionID = $lib->execution; if(empty($libTree['execution'][$executionID])) { $execution = new stdclass(); $execution->id = $executionID; $execution->name = zget($executionPairs, $executionID); $execution->type = 'execution'; $execution->active = $item->active; $execution->hasAction = false; $execution->objectType = 'execution'; $execution->children = array(); if(count($executionLibs[$executionID]) == 1) { $execution->id = $item->id; $execution->type = 'docLib'; $execution->hasAction = true; $execution->children = $item->children; } $libTree['execution'][$executionID] = $execution; if(count($executionLibs[$executionID]) == 1) continue; } $libTree['execution'][$executionID]->active = $item->active ? 1 : $libTree['execution'][$executionID]->active; $libTree['execution'][$executionID]->children[] = $item; } if($item->type == 'apiLib') $apiLibIDList[] = $lib->id; } return array($libTree, $apiLibs, $apiLibIDList); } /** * 构建文档库树形结构的节点。 * Build a node of the tree structure of the document library. * * @param int $libID * @param object $lib * @param string $type mine|product|project|execution|api|custom * @param int $moduleID * @param int $objectID * @param string $browseType bysearch|byrelease * @param int $docID * @param object|null|bool $release * @access public * @return object */ public function buildLibItem(int $libID, object $lib, string $type, int $moduleID = 0, int $objectID = 0, string $browseType = '', int $docID = 0, mixed $release = null): object { $releaseModule = array(); if($release && $release->lib == $lib->id) { foreach($release->snap['modules'] as $module) $releaseModule[$module['id']] = (object)$module; } $item = new stdclass(); $item->id = $lib->id; $item->type = $lib->type == 'api' ? 'apiLib' : 'docLib'; $item->name = $lib->name; $item->parent = isset($lib->parent) ? $lib->parent : ''; $item->order = $lib->order; $item->main = zget($lib, 'main', 0); $item->objectType = $type; $item->objectID = $objectID; $item->addedBy = $lib->addedBy; $item->active = $lib->id == $libID && $browseType != 'bysearch' ? 1 : 0; $item->children = $this->getModuleTree($lib->id, $moduleID, $lib->type == 'api' ? 'api' : 'doc', 0, $releaseModule, $docID); $showDoc = $this->loadModel('setting')->getItem('owner=' . $this->app->user->account . '&module=doc&key=showDoc'); $showDoc = $showDoc === '0' ? 0 : 1; $showDocWithNotAPI = $showDoc && $lib->type != 'api'; $isSpace = $lib->type == 'custom' && $lib->parent == 0; if($this->app->rawMethod == 'view' && $showDocWithNotAPI && !$isSpace) { $docIDList = $this->getPrivDocs(array($lib->id)); $docs = $this->dao->select('*, title as name')->from(TABLE_DOC) ->where('id')->in($docIDList) ->andWhere("(status = 'normal' or (status = 'draft' && addedBy='{$this->app->user->account}'))") ->andWhere('deleted')->eq(0) ->andWhere('module')->eq(0) ->fetchAll('id', false); if(!empty($docs)) { $docs = array_values($docs); foreach($docs as $doc) $doc->active = $doc->id == $docID ? 1 : 0; $item->children = array_merge($docs, $item->children); } } return $item; } /** * 处理产品、项目、执行的文档库树形结构。 * Process the tree structure of the document library of product, project, and execution. * * @param array $libTree * @param array $apiLibs * @param array $apiLibIDList * @param string $type mine|product|project|execution|api|custom * @param int $libID * @param int $objectID * @access public * @return array */ public function processObjectTree(array $libTree, string $type, int $libID = 0, int $objectID = 0, array $apiLibs = array(), array $apiLibIDList = array()): array { if(in_array($type, array('product', 'project', 'execution'))) { $libTree[$type] = array_merge($libTree[$type], $apiLibs); if($type == 'project' && !empty($libTree['execution'])) $libTree['execution'] = array_values($libTree['execution']); $annex = new stdclass(); $annex->id = 'annex'; $annex->name = $this->lang->doclib->files; $annex->type = 'annex'; $annex->objectType = $type; $annex->objectID = $objectID; $annex->active = empty($libID) ? 1 : 0; if($type == 'project') { $newLibTree = array(); foreach($libTree as $key => $libs) { $newLibTree[$key] = $libs; if($key == 'project') $newLibTree['annex'][''] = $annex; } $libTree = $newLibTree; } else { $libTree[$type][''] = $annex; } } elseif($type == 'api') { $libTree[$type] = array_merge($libTree[$type], $apiLibs); } /* Add release for api. */ $releases = $this->loadModel('api')->getReleaseByQuery($apiLibIDList); foreach($libTree as &$libList) { foreach($libList as &$lib) { if(!is_object($lib) || $lib->type != 'apiLib') continue; $lib->versions = array(); foreach($releases as $index => $release) { if($lib->id != $release->lib) continue; $lib->versions[] = $release; unset($releases[$index]); } if(empty($lib->versions)) continue; /* Set default version. */ $defaultVersion = new stdclass(); $defaultVersion->id = 0; $defaultVersion->version = $this->lang->build->common; $lib->versions = array_merge(array($defaultVersion), $lib->versions); } } return $libTree; } /** * 检查接口库名称。 * Check api library name. * * @param object $lib * @param string $libType product|project * @param int $libID * @access public * @return bool */ public function checkApiLibName($lib, $libType, $libID = 0): bool { $sameNames = $this->dao->select('*') ->from(TABLE_DOCLIB) ->where('`product`')->eq($lib->product) ->andWhere('`project`')->eq($lib->project) ->andWhere('`name`')->eq($lib->name) ->andWhere('`type`')->eq('api') ->beginIF(!empty($libID))->andWhere('`id`')->ne($libID)->fi() ->fetchAll('', false); if(count($sameNames) > 0 && $libType == 'product') dao::$errors['name'] = $this->lang->doclib->apiNameUnique[$libType] . sprintf($this->lang->error->unique, $this->lang->doclib->name, $lib->name); if(count($sameNames) > 0 && $libType == 'project') dao::$errors['name'] = $this->lang->doclib->apiNameUnique[$libType] . sprintf($this->lang->error->unique, $this->lang->doclib->name, $lib->name); if(count($sameNames) > 0 && $libType == 'nolink') dao::$errors['name'] = $this->lang->doclib->apiNameUnique[$libType] . sprintf($this->lang->error->unique, $this->lang->doclib->name, $lib->name); return !dao::isError(); } /** * 创建一个操作。 * Create an action. * * @param int $docID * @param string $action view|collect * @param string $account * @access public * @return int|bool */ public function createAction(int $docID, string $action, string $account = ''): int|bool { if(empty($docID)) return false; $docStatus = $this->dao->select('status')->from(TABLE_DOC)->where('id')->eq($docID)->fetch('status'); if(empty($account))$account = $this->app->user->account; if($action == 'collect') $this->dao->delete()->from(TABLE_DOCACTION)->where('doc')->eq($docID)->andWhere('action')->eq('collect')->andWhere('actor')->eq($account)->exec(); if($action == 'view') { $lastView = $this->dao->select('date')->from(TABLE_DOCACTION)->where('doc')->eq($docID)->andWhere('action')->eq('view')->andWhere('actor')->eq($account)->orderBy('id_desc')->fetch('date'); if($lastView and (time() - strtotime($lastView) < 4)) return false; } $data = new stdclass(); $data->doc = $docID; $data->action = $action; $data->actor = $account; $data->date = helper::now(); $this->dao->insert(TABLE_DOCACTION)->data($data)->autoCheck()->exec(); if(dao::isError()) return false; $actionID = $this->dao->lastInsertID(); if($action == 'view' && $docStatus == 'normal') $this->dao->update(TABLE_DOC)->set('views = views + 1')->where('id')->eq($docID)->exec(); if($action == 'collect') $this->dao->update(TABLE_DOC)->set('collects = collects + 1')->where('id')->eq($docID)->exec(); return $actionID; } /** * 获取文档的所有操作信息。 * Get action by doc ID. * * @param int $docID * @param string $action view|collect * @param string $account * @access public * @return object|false */ public function getActionByObject(int $docID, string $action, string $account = ''): object|bool { if(empty($account)) $account = $this->app->user->account; return $this->dao->select('*')->from(TABLE_DOCACTION)->where('doc')->eq($docID)->andWhere('action')->eq($action)->andWhere('actor')->eq($account)->fetch(); } /** * 删除一个动作。 * Delete an action. * * @param int $actionID * @access public * @return bool */ public function deleteAction(int $actionID): bool { $action = $this->dao->select('*')->from(TABLE_DOCACTION)->where('id')->eq($actionID)->fetch(); if(!$action) return false; $this->dao->delete()->from(TABLE_DOCACTION)->where('id')->eq($actionID)->exec(); if($action->action == 'collect') $this->dao->update(TABLE_DOC)->set('collects = collects - 1')->where('id')->eq($action->doc)->exec(); return !dao::isError(); } /** * 处理文档的收藏者信息。 * Process collector to account. * * @param array $docs * @access public * @return array */ public function processCollector(array $docs): array { $actionGroup = $this->dao->select('*')->from(TABLE_DOCACTION)->where('doc')->in(array_keys($docs))->andWhere('action')->eq('collect')->fetchGroup('doc', 'actor'); foreach($docs as $docID => $doc) { $doc->collector = ''; if(isset($actionGroup[$docID])) $doc->collector = ',' . implode(',', array_keys($actionGroup[$docID])) . ','; } return $docs; } /** * 检查文档是否正在被其他人编辑。 * Check other editing. * * @param int $docID * @access public * @return bool */ public function checkOtherEditing(int $docID): bool { $now = time(); $account = $this->app->user->account; $docID = (int)$docID; $doc = $this->dao->select('id,editingDate')->from(TABLE_DOC)->where('id')->eq($docID)->fetch(); if(empty($doc)) return false; $editingDate = $doc->editingDate ? json_decode($doc->editingDate, true) : array(); $otherEditing = false; foreach($editingDate as $editingAccount => $timestamp) { if($editingAccount != $account && ($now - $timestamp) <= $this->config->doc->saveDraftInterval) { $otherEditing = true; break; } } $editingDate[$account] = $now; $this->dao->update(TABLE_DOC)->set('editingDate')->eq(json_encode($editingDate))->where('id')->eq($docID)->exec(); return $otherEditing; } /** * 获取文档动态。 * Get document dynamic. * * @param object $pager * @access public * @return array */ public function getDynamic(?object $pager = null): array { $allLibs = $this->getLibs('hasApi'); $hasPrivDocIdList = $this->getPrivDocs(array(), 0, 'all'); $apiList = $this->loadModel('api')->getPrivApis('all'); $actionCondition = $this->loadModel('action')->getActionCondition('doc'); $actions = $this->dao->select('*')->from(TABLE_ACTION) ->where('vision')->eq($this->config->vision) ->andWhere('((objectType')->eq('doclib') ->andWhere('objectID')->in(array_keys($allLibs)) ->markRight(1) ->orWhere('(objectType')->eq('doc') ->andWhere('objectID')->in($hasPrivDocIdList) ->markRight(1) ->orWhere('(objectType')->eq('api') ->andWhere('objectID')->in(array_keys($apiList)) ->markRight(2) ->beginIF($actionCondition)->andWhere("($actionCondition)")->fi() ->orderBy('date_desc,id_asc') ->page($pager) ->fetchAll('', false); return $this->loadModel('action')->transformActions($actions); } /** * 将当前用户从文档的正在编辑者列表中移除。 * Removes the current user from the list of people editing the document. * * @param object|bool $doc * @access public * @return bool */ public function removeEditing(object|bool $doc): bool { if(empty($doc->id) || empty($doc->editingDate)) return false; $account = $this->app->user->account; $editingDate = json_decode($doc->editingDate, true); if(!isset($editingDate[$account])) return false; unset($editingDate[$account]); $this->dao->update(TABLE_DOC)->set('editingDate')->eq(json_encode($editingDate))->where('id')->eq($doc->id)->exec(); return !dao::isError(); } /** * 获取编辑过文档的用户列表。 * Get editors of a document. * * @param int $docID * @param string $objectType * @access public * @return array */ public function getEditors(int $docID = 0, string $objectType = 'doc'): array { if(!$docID) return array(); $actions = $this->dao->select('*')->from(TABLE_ACTION) ->where('objectType')->eq($objectType) ->andWhere('objectID')->eq($docID) ->andWhere('action')->in('edited') ->orderBy('date_desc') ->fetchAll('id', false); $editors = array(); foreach($actions as $action) { $editor = new stdclass(); $editor->account = $action->actor; $editor->date = $action->date; $editors[] = $editor; } return $editors; } /** * 构造搜索表单。 * Build search form. * * @param string $libID * @param array $libs * @param int $queryID * @param string $actionURL * @param string $type mine|product|project|execution|custom * @access public * @return void */ public function buildSearchForm(int $libID, array $libs, int $queryID, string $actionURL, string $type): void { $this->loadModel('product'); if($this->app->rawMethod == 'contribute') { $this->config->doc->search['module'] = 'contributeDoc'; $this->config->doc->search['params']['project']['values'] = $this->loadModel('project')->getPairsByProgram(0, 'all', false, 'order_asc') + array('all' => $this->lang->doc->allProjects); $this->config->doc->search['params']['execution']['values'] = $this->loadModel('execution')->getPairs(0, 'all', 'multiple,leaf,noprefix,withobject') + array('all' => $this->lang->doc->allExecutions); $this->config->doc->search['params']['lib']['values'] = $this->loadModel('doc')->getLibs('all', 'withObject') + array('all' => $this->lang->doclib->all); $this->config->doc->search['params']['product']['values'] = $this->product->getPairs() + array('all' => $this->lang->doc->allProduct); unset($this->config->doc->search['fields']['module'], $this->config->doc->search['params']['module']); } else { if(!isset($libs[$libID])) $libs[$libID] = $this->getLibByID($libID); $libPairs = array(); $queryName = $type . 'libDoc'; foreach($libs as $lib) { if(empty($lib)) continue; if($lib->type == 'api') continue; $libPairs[$lib->id] = $lib->name; } if($type == 'project') { $this->config->doc->search['params']['execution']['values'] = $this->loadModel('execution')->getPairs((int)$this->session->project, 'all', 'multiple,leaf,noprefix') + array('all' => $this->lang->doc->allExecutions); } else { if($type == 'mine' || $type == 'createdby') { unset($this->config->doc->search['fields']['addedBy'], $this->config->doc->search['params']['addedBy']); if($type == 'mine') unset($this->config->doc->search['fields']['editedBy'], $this->config->doc->search['params']['editedBy']); } unset($this->config->doc->search['fields']['execution'], $this->config->doc->search['params']['execution']); } if(in_array($type, array('view', 'collect', 'createdby', 'editedby'))) $libPairs = $this->getLibs('all', 'withObject'); $this->config->doc->search['module'] = $queryName; $this->config->doc->search['params']['lib']['values'] = $libPairs + array('all' => $this->lang->doclib->all); unset($this->config->doc->search['fields']['product'], $this->config->doc->search['params']['product']); unset($this->config->doc->search['fields']['module'], $this->config->doc->search['params']['module']); } unset($this->config->doc->search['params']['status']['values']['']); $this->config->doc->search['actionURL'] = $actionURL; $this->config->doc->search['queryID'] = $queryID; $this->loadModel('search')->setSearchParams($this->config->doc->search); } /** * 删除附件。 * Delete files. * * @param array $idList * @access public * @return bool */ public function deleteFiles(array $idList): bool { if(empty($idList)) return true; $this->dao->update(TABLE_FILE)->set('deleted')->eq('1')->where('id')->in($idList)->exec(); return !dao::isError(); } /** * 通过ID获取产品/项目/执行的信息。 * Get product/project/execution by ID. * * @param string $type product|project|execution * @param int $objectID * @access public * @return object|false */ public function getObjectByID(string $type, int $objectID): object|bool { $table = zget($this->config->objectTables, $type, ''); if(!$table) return false; return $this->dao->select('*')->from($table)->where('id')->eq($objectID)->fetch(); } /** * 更新文档库顺序。 * Update doclib order. * * @param int $catalogID * @param int $order * @access public * @return bool */ public function updateDoclibOrder(int $id, int $order): bool { $this->dao->update(TABLE_DOCLIB)->set('`order`')->eq($order)->where('id')->eq($id)->exec(); return !dao::isError(); } /** * 更新文档顺序。 * Update doc order. * * @param array $sortedIdList * @access public * @return void */ public function updateDocOrder(array $sortedIdList): void { /* Remove programID. */ $sortedIdList = array_values(array_filter(array_map(function($id){return (is_numeric($id) and $id > 0) ? $id : null;}, $sortedIdList))); if(empty($sortedIdList)) return; $docs = $this->dao->select('`order`, id')->from(TABLE_DOC)->where('id')->in($sortedIdList)->orderBy('order_asc')->fetchPairs('order', 'id'); /* Update order by sorted id list. */ foreach($docs as $order => $id) { $newID = array_shift($sortedIdList); if($id == $newID) continue; $this->dao->update(TABLE_DOC)->set('`order`')->eq($order)->where('id')->eq($newID)->exec(); } } /** * 更新目录顺序。 * Update catalog order. * * @param int $catalogID * @param int $order * @param string $order * @access public * @return bool */ public function updateOrder(int $catalogID, int $order, string $type = 'doc'): bool { $this->dao->update(TABLE_MODULE)->set('`order`')->eq($order)->where('id')->eq($catalogID)->andWhere('type')->eq($type)->exec(); return !dao::isError(); } /** * 更新文档中的附件信息。 * Update doc file. * * @param int $docID * @param int $fileID * @access public * @return bool */ public function updateDocFile(int $docID, int $fileID): bool { $docContent = $this->dao->select('t1.*')->from(TABLE_DOCCONTENT)->alias('t1') ->leftJoin(TABLE_DOC)->alias('t2')->on('t1.doc=t2.id and t1.version=t2.version') ->where('t2.id')->eq($docID) ->fetch(); unset($docContent->id); $docContent->files = trim(str_replace(",{$fileID},", ',', ",{$docContent->files},"), ','); $docContent->version += 1; $this->dao->insert(TABLE_DOCCONTENT)->data($docContent)->exec(); if(dao::isError()) return false; $this->dao->update(TABLE_DOC)->set('version')->eq($docContent->version)->where('id')->eq($docID)->exec(); return !dao::isError(); } /** * 移动文档库。 * Move library. * * @param int $docID * @param object $data * @access public * @return bool */ public function moveLib(int $libID, object $data): bool { if(empty($libID) || empty($data->space)) return false; $lib = $this->getLibByID($libID); $spaceType = $this->getParamFromTargetSpace($data->space, 'type'); $spaceID = $this->getParamFromTargetSpace($data->space, 'id'); if(is_numeric($spaceID)) { $data->type = $spaceType; if($spaceType == 'mine') $data->addedBy = $this->app->user->account; /* 先清空所有标志性字段，如果是项目空间、执行空间、产品空间，则直接改对应字段，否则就是我的空间和团队空间 */ if($lib->product) $data->product = 0; if($lib->project) $data->project = 0; if($lib->execution) $data->execution = 0; if($lib->parent) $data->parent = 0; if(in_array($spaceType, array('project', 'product', 'execution'))) { $data->$spaceType = $spaceID; } else { $data->parent = $spaceID; } } else { return false; } $changes = common::createChanges($lib, $data); if(empty($changes)) return false; unset($data->space); $this->dao->update(TABLE_DOCLIB)->data($data)->where('id')->eq($libID)->exec(); $getFromTo = function ($obj) { if(!in_array($obj->type, array('project', 'product'))) return "{$obj->type}.{$obj->parent}"; if(isset($obj->project)) return "{$obj->type}.{$obj->project}"; return "{$obj->type}.{$obj->product}"; }; $from = $getFromTo($lib); $to = $getFromTo($data); $actionID = $this->loadModel('action')->create('docLib', $libID, 'Moved', '', json_encode(array('from' => $from, 'to' => $to))); $this->action->logHistory($actionID, $changes); return true; } /** * Batch move document. * * @param object $data * @param array $docIdList * @access public * @return bool */ public function batchMoveDoc(object $data, array $docIdList): bool { $this->dao->update(TABLE_DOC)->data($data)->where('id')->in($docIdList)->exec(); return !dao::isError(); } /** * 删除文档。 * Delete document. * * @param string $table * @param int $id * @access public * @return bool */ public function delete(string $table, int $id): bool { if($table != TABLE_DOC) return false; $this->dao->update($table)->set('deleted')->eq('1')->where('id')->eq($id)->exec(); $this->loadModel('action')->create('doc', $id, 'deleted', '', ACTIONMODEL::CAN_UNDELETED); return !dao::isError(); } /** * 判断文档库下是否有其他人创建的文档。 * Check if there are other documents created under the document library. * * @param object $lib * @access public * @return bool */ public function hasOthersDoc(object $lib): bool { if($lib->type != 'custom') return false; $docID = $this->dao->select('id')->from(TABLE_DOC) ->where('vision')->eq($this->config->vision) ->andWhere('templateType')->eq('') ->andWhere('deleted')->eq(0) ->andWhere('lib')->eq($lib->id) ->andWhere('addedBy')->ne($this->app->user->account) ->fetch('id'); return !empty($docID); } /** * 构建模板类型数据。 * Build data of template type module. * * @param int $scope * @param int $parent * @param string $name * @param string $code * @param int $grade * @param string $path * @access public * @return object */ public function buildTemplateModule($scope, $parent, $name, $code, $grade = 1, $path = '') { $module = new stdclass(); $module->type = 'docTemplate'; $module->root = $scope; $module->parent = $parent; $module->name = $name; $module->short = $code; $module->grade = $grade; $module->path = $path; return $module; } /** * 检查文档模板是否已升级。 * Check if doc template has been upgraded * * @access public * @return bool */ public function checkIsTemplateUpgraded() { $templateModule = $this->dao->select('1')->from(TABLE_MODULE)->where('type')->eq('docTemplate')->fetch(); return !empty($templateModule); } /** * 升级模板类型数据。 * Upgrade document template types. * * @access public * @return bool */ public function upgradeTemplateTypes() { $currentLang = $this->app->getClientLang(); $conditions = "`module` = 'baseline' AND `section` = 'objectList' AND `vision` = '{$this->config->vision}'"; $templateTypes = $this->dao->select('`key`, `value`')->from(TABLE_LANG)->where($conditions)->andWhere('lang')->eq($currentLang)->fetchPairs(); if(empty($templateTypes)) $templateTypes = $this->dao->select('`key`, `value`')->from(TABLE_LANG)->where($conditions)->andWhere('lang')->eq('all')->fetchPairs(); if(empty($templateTypes)) { $this->app->loadLang('baseline'); $templateTypes = $this->lang->baseline->objectList; } $usedTemplateTypes = $this->dao->select('`key`, `value`')->from(TABLE_LANG)->alias('t1') ->leftJoin(TABLE_DOC)->alias('t2')->on('t1.key = t2.templateType') ->leftJoin(TABLE_MODULE)->alias('t3')->on('t1.module = t3.id') ->where('t1.module')->eq('baseline') ->andWhere('t1.section')->eq('objectList') ->andWhere('t1.lang', true)->ne($currentLang) ->orWhere('t1.vision')->ne($this->config->vision) ->markRight(1) ->andWhere('t1.key')->notin(array_keys($templateTypes)) ->andWhere('t3.type')->eq('docTemplate') ->andWhere('t2.lib')->eq('') ->andWhere('t2.module')->eq('') ->andWhere('t2.deleted')->eq(0) ->fetchPairs(); $oldTemplateTypes = array_filter(arrayUnion($templateTypes, $usedTemplateTypes)); if(empty($oldTemplateTypes)) return true; $this->loadModel('setting'); foreach(array('rnd', 'or') as $vision) { $scopeMaps = $this->setting->getItem("vision={$vision}&owner=system&module=doc&key=builtInScopeMaps"); $scopeMaps = json_decode($scopeMaps, true); $scopeID = $vision == 'rnd' ? zget($scopeMaps, 'project', 0) : zget($scopeMaps, 'product', 0); if(!$scopeID) continue; $parentTypes = array(); foreach($this->lang->docTemplate->types as $key => $value) { $module = $this->buildTemplateModule($scopeID, 0, $value, $key, 1); $this->dao->insert(TABLE_MODULE)->data($module)->exec(); if(dao::isError()) return false; $moduleID = $this->dao->lastInsertID(); $this->dao->update(TABLE_MODULE)->set('path')->eq(",{$moduleID},")->where('id')->eq($moduleID)->exec(); $parentTypes[$key] = $moduleID; } foreach($oldTemplateTypes as $key => $value) { $parentKey = zget($this->config->doc->templateTypeParents, $key, 'other'); $parentID = $parentTypes[$parentKey]; $module = $this->buildTemplateModule($scopeID, $parentID, $value, $key, 2); $this->dao->insert(TABLE_MODULE)->data($module)->exec(); if(dao::isError()) return false; $moduleID = $this->dao->lastInsertID(); $this->dao->update(TABLE_MODULE)->set('path')->eq(",{$parentID},{$moduleID},")->where('id')->eq($moduleID)->exec(); } } return true; } /** * 添加内置的模板范围。 * Add built in scopes. * * @access public * @return bool */ public function addBuiltInScopes() { $builtInScopes = $this->dao->select('*')->from(TABLE_DOCLIB)->where('type')->eq('template')->andWhere('main')->eq('1')->fetchAll(); if(!empty($builtInScopes)) return; $this->loadModel('setting'); $scope = new stdClass(); $scope->type = 'template'; $scope->main = '1'; $scope->addedBy = 'system'; $scope->addedDate = helper::now(); foreach($this->lang->docTemplate->builtInScopes as $vision => $scopeList) { $scopeMaps = array(); $scope->vision = $vision; foreach($scopeList as $scopeKey => $scopeName) { if(empty($scopeName)) continue; $scope->name = $scopeName; $this->dao->insert(TABLE_DOCLIB)->data($scope)->exec(); $scopeID = $this->dao->lastInsertID(); $scopeMaps[$scopeKey] = $scopeID; } if(!empty($scopeMaps)) $this->setting->setItem("system.doc.builtInScopeMaps@{$vision}", json_encode($scopeMaps)); } } /** * 添加内置的模板分类。 * Add built in template type. * * @access public * @return void */ public function addBuiltInDocTemplateType() { $rndScopeMaps = $this->loadModel('setting')->getItem('vision=rnd&owner=system&module=doc&key=builtInScopeMaps'); $rndScopeMaps = json_decode($rndScopeMaps, true); $projectScopeID = zget($rndScopeMaps, 'project', 0); $builtInTemplateTypes = $this->dao->select('id')->from(TABLE_MODULE)->where('type')->eq('docTemplate')->andWhere('root')->eq($projectScopeID)->fetchPairs(); if(!empty($builtInTemplateTypes)) return; $this->app->loadLang('baseline'); $parentTemplateTypes = array_filter($this->lang->docTemplate->types, function($key){return in_array($key, array('plan', 'story', 'design', 'test'));}, ARRAY_FILTER_USE_KEY); foreach($parentTemplateTypes as $parentKey => $parentValue) { /* 创建文档模板一级分类。*/ /* Add the parent type of doc template. */ $parentType = $this->buildTemplateModule($projectScopeID, 0, $parentValue, $parentKey, 1); $this->dao->insert(TABLE_MODULE)->data($parentType)->exec(); $parentTypeID = $this->dao->lastInsertID(); $this->dao->update(TABLE_MODULE)->set('path')->eq(",{$parentTypeID},")->where('id')->eq($parentTypeID)->exec(); /* 创建文档模板二级分类。*/ /* Add the child type of doc template. */ foreach($this->config->docTemplate->builtInTypes[$parentKey] as $childKey) { $childType = $this->buildTemplateModule($projectScopeID, $parentTypeID, $this->lang->baseline->objectList[$childKey], $childKey, 2); $this->dao->insert(TABLE_MODULE)->data($childType)->exec(); $childTypeID = $this->dao->lastInsertID(); $this->dao->update(TABLE_MODULE)->set('path')->eq(",{$parentTypeID},{$childTypeID},")->where('id')->eq($childTypeID)->exec(); } } } /** * 升级文档模板的范围和类型。 * Upgrade lib and module of template. * * @param array $templateIdList * @access public * @return bool */ public function upgradeTemplateLibAndModule(array $templateIdList = array()) { $templateList = $this->dao->select('*')->from(TABLE_DOC)->where('id')->in($templateIdList)->fetchAll('id'); if(empty($templateList)) return true; $this->loadModel('setting'); $rndScopeMaps = $this->setting->getItem('vision=rnd&owner=system&module=doc&key=builtInScopeMaps'); $orScopeMaps = $this->setting->getItem('vision=or&owner=system&module=doc&key=builtInScopeMaps'); $rndScopeMaps = json_decode($rndScopeMaps, true); $orScopeMaps = json_decode($orScopeMaps, true); $moduleGroup = $this->dao->select('root,short,id')->from(TABLE_MODULE)->where('deleted')->eq('0')->andWhere('root')->in(array($rndScopeMaps['project'], $orScopeMaps['product']))->fetchGroup('root', 'short'); foreach($templateList as $id => $template) { $templateVision = $template->vision; $templateType = $template->templateType; $templateScopeID = $templateVision == 'or' ? zget($orScopeMaps, 'product', 0) : zget($rndScopeMaps, 'project', 0); $moduleList = zget($moduleGroup, $templateScopeID, array()); $moduleInfo = isset($moduleList[$templateType]) ? $moduleList[$templateType] : zget($moduleList, 'other', ''); $template->lib = $templateScopeID; $template->module = empty($moduleInfo) ? 0 : $moduleInfo->id; $template->assignedDate = helper::isZeroDate($template->assignedDate) ? null : $template->assignedDate; $template->approvedDate = helper::isZeroDate($template->approvedDate) ? null : $template->approvedDate; $this->dao->update(TABLE_DOC)->data($template)->where('id')->eq($id)->exec(); if(dao::isError()) return false; } return true; } /** * 获取文档模板类型的模块。 * Get modules of doc template type. * * @param bool $onlyNode * @param string|int $root * @param string $grade * @access public * @return array */ public function getTemplateModules($root = 'all', $grade = 'all') { $modules = $this->dao->select('*')->from(TABLE_MODULE) ->where('deleted')->eq('0') ->andWhere('type')->eq('docTemplate') ->beginIF($root != 'all')->andWhere('root')->eq($root)->fi() ->beginIF($grade != 'all')->andWhere('grade')->eq($grade)->fi() ->fetchAll('id'); foreach($modules as $module) { $path = explode(',', trim($module->path, ',')); $names = array(''); foreach($path as $id) { if(!isset($modules[$id])) continue; $names[] = $modules[$id]->name; } $module->fullName = implode('/', $names); } return array_values($modules); } /** * 获取范围数据。 * Get scope items. * * @param array $scopeList * @access public * @return array */ public function getScopeItems(array $scopeList = array()) { $items = array(); foreach($scopeList as $scope) $items[] = array('value' => $scope->id, 'text' => $scope->name); return $items; } /** * 判断一个模块是否是内置的文档模板类型。 * Judge whether a module is builtin template type. * * @param array $scopeIdList * @access public * @return bool */ public function getScopeTemplates(array $scopeIdList = array()) { $scopeTemplates = array(); foreach($scopeIdList as $scopeID) { $templates = $this->getHotTemplates($scopeID, 5); $scopeTemplates[$scopeID] = $this->filterPrivDocs($templates, 'template'); } return $scopeTemplates; } /** * 获取范围内的最近顶层文档模板。 * Get the recent top template of scope. * * @param int $scopeID * @param int $limit * @access public * @return array */ public function getHotTemplates($scopeID = 0, $limit = 0) { return $this->dao->select('t1.*, CASE WHEN t1.addedDate > t1.editedDate THEN t1.addedDate ELSE t1.editedDate END as hotDate')->from(TABLE_DOC)->alias('t1') ->leftJoin(TABLE_MODULE)->alias('t2')->on('t1.module = t2.id') ->where('t2.type')->eq('docTemplate') ->andWhere('t1.builtIn')->eq('0') ->andWhere('t1.deleted')->eq('0') ->andWhere('t1.status')->eq('normal') ->andWhere('t1.parent')->eq(0) ->andWhere('t1.vision')->eq($this->config->vision) ->beginIF($scopeID)->andWhere('t1.lib')->eq($scopeID)->fi() ->orderBy('hotDate_desc') ->beginIF($limit)->limit($limit)->fi() ->fetchAll('', false); } /** * 删除一个文档模板。 * Delete a doc template. * * @param string $table * @param int $id * @param string $objectType * @access public * @return void */ public function deleteTemplate(int $id) { if(empty($id)) return false; $this->dao->update(TABLE_DOC)->set('deleted')->eq(1)->where('id')->eq($id)->exec(); $this->loadModel('action')->create('doctemplate', $id, 'deleted', '', ACTIONMODEL::CAN_UNDELETED); return true; } /** * 添加文档模板类型。 * Add template type. * * @param object $moduleData * @access public * @return int */ public function addTemplateType($moduleData) { $this->dao->insert(TABLE_MODULE)->data($moduleData)->autoCheck()->exec(); $moduleID = $this->dao->lastInsertID(); $path = $moduleData->grade == 1 ? ",{$moduleID}," : ",{$moduleData->parent},{$moduleID},"; $this->dao->update(TABLE_MODULE)->set('path')->eq($path)->set('short')->eq("custom{$moduleID}")->where('id')->eq($moduleID)->exec(); return $moduleID; } /** * 获取某个模板类型下的所有模板。 * Get template list by type. * * @param int|null $type * @param string $status * @access public * @return int */ public function getTemplatesByType($type = null, $status = 'all') { $types = array(); if(!is_null($type)) { $subTypes = $this->dao->select('id')->from(TABLE_MODULE) ->where('deleted')->eq('0') ->andWhere('parent')->eq($type) ->andWhere('type')->eq('docTemplate') ->fetchPairs('id'); $types = array_values($subTypes); $types[] = $type; } return $this->dao->select('t1.*')->from(TABLE_DOC)->alias('t1') ->leftJoin(TABLE_MODULE)->alias('t2')->on('t1.module=t2.id') ->where('t1.deleted')->eq('0') ->andWhere('t2.type')->eq('docTemplate') ->andWhere('t1.builtIn')->eq('0') ->andWhere('t1.vision')->eq($this->config->vision) ->beginIF(!is_null($type))->andWhere('t1.module')->in($types)->fi() ->beginIF($status != 'all')->andWhere('t1.status')->eq($status)->fi() ->fetchAll('id', false); } /** * 获取上次访问的文档对象。 * Get last viewed doc object. * * @param string $type * @access public * @return string */ public function getLastViewed(string $type): string|null { $typeList = array('lastViewedSpace', 'lastViewedSpaceHome', 'lastViewedLib'); if(!in_array($type, $typeList)) return null; return $this->loadModel('setting')->getItem("owner={$this->app->user->account}&module=common§ion=doc&key=doc-$type"); } /** * 设置上次访问的文档对象。 * Set last viewed doc object. * * @param array $value * @access public * @return void */ public function setLastViewed(array $value): void { $items = array(); foreach($value as $k => $v) { if(in_array($k, array('lastViewedSpace', 'lastViewedSpaceHome', 'lastViewedLib'))) $items["doc-$k"] = $v; } if(!empty($items)) $this->loadModel('setting')->setItems("{$this->app->user->account}.common.doc", $items); } /** * 获取文档块。 * Get doc block. * * @param int $blockID * @access public * @return object|bool */ public function getDocBlock(int $blockID): object|bool { return $this->dao->select('*')->from(TABLE_DOCBLOCK)->where('id')->eq($blockID)->fetch(); } /** * 获取文档块内容。 * Get doc block content. * * @param int $blockID * @access public * @return array|bool */ public function getDocBlockContent(int $blockID): array|bool { $content = $this->dao->select('content')->from(TABLE_DOCBLOCK)->where('id')->eq($blockID)->fetch('content'); if(!$content) return false; return json_decode($content, true); } /** * 获取文档块列表。 * Get doc block list. * * @param int $docID * @access public * @return ?object */ public function getZentaoList(int $blockID): ?object { $blockData = $this->dao->select('*')->from(TABLE_DOCBLOCK)->where('id')->eq($blockID)->fetch(); if(!is_object($blockData)) return null; if(is_string($blockData->content)) $blockData->content = json_decode($blockData->content); return $blockData; } /** * 通过parentID获取子文档列表。 * Get docs by parentID. * * @param int $parentID * @access public * @return array */ public function getDocsByParent(int $parentID): array { return $this->dao->select('*')->from(TABLE_DOC) ->where('parent')->eq($parentID) ->andWhere('status')->eq('normal') ->andWhere('deleted')->eq(0) ->orderBy('`order` asc, id_asc') ->fetchAll('id', false); } /** * 通过标题获取标题ID。 * Get ID by title. * * @param int $originPageID 当前Confluence文档ID * @param string $title 选择的父页面标题 * @access public * @return int */ public function getDocIdByTitle(int $originPageID, string $title = ''): int { if(!defined('CONFLUENCE_TMPRELATION')) define('CONFLUENCE_TMPRELATION', '`confluencetmprelation`'); $docID = $this->dao->dbh($this->dbh)->select('BID')->from(CONFLUENCE_TMPRELATION)->where('BType')->eq('zdoc')->andWhere('AID')->eq($originPageID)->fetch('BID'); $doc = $this->getByID((int)$docID); $docIdList = $this->dao->select('id')->from(TABLE_DOC)->where('lib')->eq($doc->lib)->andWhere('title')->eq($title)->andWhere('status')->eq('normal')->andWhere('deleted')->eq(0)->fetchAll(); $idList = array(); foreach($docIdList as $item) $idList[] = $item->id; $parentID = $this->dao->dbh($this->dbh)->select('BID')->from(CONFLUENCE_TMPRELATION)->where('BType')->eq('zdoc')->andWhere('BID')->in($idList)->fetch('BID'); return $parentID ? (int)$parentID : 0; } /** * 通过Confluence的用户ID获取对应禅道的用户信息。 * Retrieve the user information of the corresponding Zen path through Confluence's user ID. * * @param string $userName * @access public * @return object|false */ public function getUserByConfluenceUserID(string $userName): object|false { return $this->dao->select('t2.*') ->from(JIRA_TMPRELATION)->alias('t1') ->leftJoin(TABLE_USER)->alias('t2')->on('t1.BID = t2.account') ->where('t1.AID')->eq($userName) ->andWhere('t1.Btype')->eq('zuser') ->andWhere('t1.Atype')->eq('juser') ->andWhere('t2.deleted')->eq('0') ->fetch(); } /** * 构建文档层级。 * * @param array $docs * @param array $modules * @param bool $addPrefix * @access public * @return array */ public function buildNestedDocs(array $docs, array $modules = array(), bool $addPrefix = true): array { if(!empty($modules)) { $moduleList = array(); $modules = $this->dao->select('*')->from(TABLE_MODULE)->where('id')->in(array_keys($modules))->fetchAll('id'); foreach($modules as $moduleID => $module) { $moduleKey = $addPrefix ? 'm_' . $moduleID : $moduleID; $module->id = $moduleKey; $module->title = $module->name; $module->parent = empty($module->parent) ? 0 : ($addPrefix ? 'm_' . $module->parent : $module->parent); $moduleList[$moduleKey] = $module; } foreach($docs as $doc) { if(!$doc) continue; if(empty($doc->parent) && !empty($doc->module)) $doc->parent = $addPrefix ? 'm_' . $doc->module : $doc->module; } $docs = $docs + $moduleList; } $children = array(); foreach($docs as $doc) { if(!$doc) continue; $children[$doc->parent][] = $doc; } /* 找到所有根节点，如果没有parent为0的文档，尝试找到父节点不在docs中的文档。*/ $rootDocs = isset($children[0]) ? $children[0] : array(); if(empty($rootDocs)) { foreach($docs as $doc) { if(!isset($docs[$doc->parent])) $rootDocs[$doc->id] = $doc; } } $result = array(); foreach($rootDocs as $rootDoc) $result[$rootDoc->id] = $this->buildDocItems($rootDoc->id, $rootDoc->title, $children); return $result; } /** * 构建文档items。 * * @param int|string $docID * @param string $docTitle * @param array $children * @access public * @return array */ public function buildDocItems(int|string $docID, string $docTitle, array $children): array { $items = array('value' => $docID, 'text' => $docTitle); if(isset($children[$docID])) { foreach($children[$docID] as $childDoc) { $items['items'][] = $this->buildDocItems($childDoc->id, $childDoc->title, $children); } } return $items; } /** * 获取文档模板的范围。 * Get the scope of template. * * @access public * @return array */ public function getTemplateScopes(): array { return $this->dao->select('*')->from(TABLE_DOCLIB)->where('type')->eq('template')->andWhere('vision')->eq($this->config->vision)->andWhere('deleted')->eq('0')->fetchAll('id'); } /** * 更新模板范围。 * Update the scope of template. * * @param array scopeList * @access public * @return void */ public function updateTemplateScopes(array $scopeList = array()) { foreach($scopeList as $id => $name) { $this->dao->update(TABLE_DOCLIB)->set('name')->eq($name)->where('id')->eq($id)->andWhere('vision')->eq($this->config->vision)->exec(); } } /** * 插入模板范围。 * Insert the scope of template. * * @param array scopeList * @access public * @return void */ public function insertTemplateScopes(array $scopeList = array()) { foreach($scopeList as $name) { if(empty($name)) continue; $scope = new stdClass(); $scope->name = $name; $scope->type = 'template'; $scope->main = '0'; $scope->vision = $this->config->vision; $scope->addedBy = $this->app->user->account; $scope->addedDate = helper::now(); $this->dao->insert(TABLE_DOCLIB)->data($scope)->exec(); } } /** * 删除模板范围。 * Delete the scope of template. * * @param array scopeList * @access public * @return void */ public function deleteTemplateScopes(array $scopeIdList = array()) { $this->dao->update(TABLE_DOCLIB)->set('deleted')->eq('1')->where('id')->in($scopeIdList)->exec(); } /** * 复制模板，将研发界面的除Wiki类型的模板复制到OR界面，将OR界面的所有文档模板复制到研发界面。 * Copy templates of R&D interface, except for wiki type templates, to OR interface, and copy all templates of OR interface to R&D interface. * * @param array templateIdList * @access public * @return void */ public function copyTemplate(array $templateIdList = array()) { if(empty($templateIdList)) return array(); $oldTemplateList = $this->dao->select('*')->from(TABLE_DOC)->where('id')->in($templateIdList)->fetchAll('id'); $oldContentList = $this->dao->select('*')->from(TABLE_DOCCONTENT)->where('doc')->in($templateIdList)->fetchGroup('doc', 'id'); $oldChapterList = $this->dao->select('*')->from(TABLE_DOC)->where('template')->ne('')->andWhere('type')->in('chapter,article')->fetchGroup('template', 'id'); $newTemplateList = array(); foreach($oldTemplateList as $oldTemplateID => $template) { /* 研发界面的Wiki类型模板不复制到OR界面。*/ /* The wiki type template of R&D interface is not copied to OR interface. */ if($template->vision == 'rnd' && $template->type == 'book') continue; /* 复制模板及模板内容。*/ /* Copy template and content. */ unset($template->id); $templateVision = $template->vision == 'rnd' ? 'or' : 'rnd'; $template->vision = $templateVision; $template->assignedDate = helper::isZeroDate($template->assignedDate) ? null : $template->assignedDate; $template->approvedDate = helper::isZeroDate($template->approvedDate) ? null : $template->approvedDate; $this->dao->insert(TABLE_DOC)->data($template)->exec(); $newTemplateID = $this->dao->lastInsertID(); foreach($oldContentList[$oldTemplateID] as $content) { unset($content->id); $content->doc = $newTemplateID; $content->addedDate = helper::isZeroDate($content->addedDate) ? null : $content->addedDate; $content->editedDate = helper::isZeroDate($content->editedDate) ? null : $content->editedDate; $this->dao->insert(TABLE_DOCCONTENT)->data($content)->exec(); } /* OR界面的Wiki类型模板复制到研发界面。*/ /* Copy the wiki type template of OR interface to R&D interface. */ if($template->type == 'book' && isset($oldChapterList[$oldTemplateID])) { $chapterList = $oldChapterList[$oldTemplateID]; $chapterContent = $this->dao->select('*')->from(TABLE_DOCCONTENT)->where('doc')->in(array_keys($chapterList))->fetchGroup('doc', 'id'); foreach($chapterList as $oldChapterID => $chapter) { unset($chapter->id); $chapter->vision = 'rnd'; $chapter->template = $newTemplateID; $this->dao->insert(TABLE_DOC)->data($chapter)->exec(); $newChapterID = $this->dao->lastInsertID(); foreach($chapterContent[$oldChapterID] as $content) { unset($content->id); $content->doc = $newChapterID; $this->dao->insert(TABLE_DOCCONTENT)->data($content)->exec(); } } } if(!isset($newTemplateList['all'])) $newTemplateList['all'] = array(); if(!isset($newTemplateList['wiki'])) $newTemplateList['wiki'] = array(); if(!isset($newTemplateList['html'])) $newTemplateList['html'] = array(); $newTemplateList['all'][] = $newTemplateID; if($template->type == 'book') $newTemplateList['wiki'][] = $newTemplateID; if($template->type == 'html' || $template->type == 'markdown') $newTemplateList['html'][] = $newTemplateID; } return $newTemplateList; } /** * 添加内置文档模板。 * Add the built-in doc template. * * @access public * @return void */ public function addBuiltInDocTemplateByType() { $builtInDocTemplateType = array('PP', 'SRS', 'HLDS', 'DDS', 'ADS', 'DBDS', 'ITTC', 'STTC'); $builtInDocTemplate = $this->dao->select('*')->from(TABLE_DOC)->where('builtIn')->eq('1')->andWhere('templateType')->in($builtInDocTemplateType)->fetchAll(); if(!empty($builtInDocTemplate)) return; $rndScopeMaps = $this->loadModel('setting')->getItem('vision=rnd&owner=system&module=doc&key=builtInScopeMaps'); $rndScopeMaps = json_decode($rndScopeMaps, true); $projectScopeID = zget($rndScopeMaps, 'project', 0); $modulePairs = $this->dao->select('short,id')->from(TABLE_MODULE)->where('root')->eq($projectScopeID)->andWhere('type')->eq('docTemplate')->fetchPairs('short'); $builtInTemplate = new stdClass(); $builtInTemplate->lib = $projectScopeID; $builtInTemplate->type = 'text'; $builtInTemplate->addedBy = 'system'; $builtInTemplate->addedDate = helper::now(); $builtInTemplate->builtIn = '1'; $templateContent = new stdClass(); $templateContent->type = 'doc'; $templateContent->version = 1; $templateContent->addedBy = 'system'; $templateContent->addedDate = helper::now(); $this->loadModel('upgrade'); $this->app->loadLang('baseline'); foreach($builtInDocTemplateType as $type) { /* 创建与分类同名的内置文档模板。*/ /* Add the doc template with the same name as the type. */ $builtInTemplate->module = zget($modulePairs, $type, 0); $builtInTemplate->title = $this->lang->baseline->objectList[$type]; $builtInTemplate->templateType = $type; $this->dao->insert(TABLE_DOC)->data($builtInTemplate)->exec(); $templateID = $this->dao->lastInsertID(); /* 获取模板的动态区块。*/ /* Get the block of doc template. */ $templateBlock = $this->upgrade->getTemplateBlock($templateID); $templateHtml = empty($templateBlock) ? '' : "

"; /* 添加模板内容。*/ /* Add the content of doc template. */ $templateContent->content = $templateHtml; $templateContent->rawContent = json_encode(array('$migrate' => 'html', '$data' => $templateHtml)); $templateContent->doc = $templateID; $templateContent->title = $builtInTemplate->title; $this->dao->insert(TABLE_DOCCONTENT)->data($templateContent)->exec(); } /* 记录文档模板的更新时间。*/ /* Record the time of upgrade doc template. */ $this->setting->setItem("system.doc.upgradeTime", helper::now()); } /** * 遍历文档的区块。 * For each doc block. * * 下面为一个遍历文档中所有附件，并获取所有附件 sourceId 例子： * * ```php * // 定义遍历回调函数： * $callback = function($block, $data, $level) * { * if(!empty($block['props']['sourceId'])) $data[] = $block['props']['sourceId']; * return $data; * }; * * // 遍历文档，并获取最终的 sourceId 列表： * $sourceIdList = static::forEachDocBlock($rawContent, $callback, array(), 'affine:attachment'); * ``` * * @param array $rawContent 文档的区块内容 * @param callable $callback 回调函数，用于处理每个区块，参数包括区块内容、传递的数据、区块级别、区块索引 * @param mixed $data 用于在遍历过程中需要传递的数据，此参数可选，默认为 null * @param string $flavours 区块的 flavour，例如 affine:attachment，可以用英文逗号匹配多个 flavour，如果为空则匹配所有 flavour * @param string $types 区块的 type，包括页面（page）和块（block），默认仅匹配块（block），如果为空则匹配所有类型 * @param ?array $props 区块的 props，例如 array('type' => 'h1')，可以指定多个属性值 * @param int $level 区块的级别，用于递归遍历，如果要指定起始级别，则可以使用此参数指定，默认为 0 * @param int $index 区块的索引，用于递归遍历，如果要指定起始索引，则可以使用此参数指定，默认为 0 * @access public * @return void */ public static function forEachDocBlock(array $rawContent, callable $callback, mixed $data = null, string $flavours = '', string $types = 'block', ?array $props = null, int $level = 0, int $index = 0): mixed { /* 如果内容是列表，则遍历列表。 */ if(array_is_list($rawContent)) { foreach($rawContent as $idx => $block) { $data = static::forEachDocBlock($block, $callback, $data, $flavours, $types, $props, $level, $idx); } return $data; } /* 获取内容类型。 */ if(!isset($rawContent['type'])) return $data; $type = $rawContent['type']; /* 判断内容是否匹配类型。 */ $blockMatched = empty($types) || str_contains(',' . $types . ',', ',' . $type . ','); /* 判断内容是否匹配 flavour。 */ if($blockMatched && !empty($flavours)) { $flavour = empty($rawContent['flavour']) ? '' : $rawContent['flavour']; $blockMatched = !empty($flavour) && str_contains(',' . $flavours . ',', ',' . $flavour . ','); } /* 判断内容是否匹配 props。 */ if($blockMatched && !empty($props)) { $blockProps = isset($rawContent['props']) ? $rawContent['props'] : null; if(empty($blockProps)) { $blockMatched = false; } else { foreach($props as $prop => $value) { if($blockProps[$prop] !== $value) { $blockMatched = false; break; } } } } /* 如果内容匹配，则调用回调函数。 */ if($blockMatched) { $data = $callback($rawContent, $data, 0, $level, $index); } /* 如果内容是页面，则遍历页面内容。 */ if($type === 'page') { return static::forEachDocBlock($rawContent['blocks'], $callback, $data, $flavours, $types, $props, $level + 1); } /* 如果内容包含 children，则遍历 children。 */ $children = isset($rawContent['children']) ? $rawContent['children'] : null; if(empty($children)) return $data; return static::forEachDocBlock($children, $callback, $data, $flavours, $types, $props, $level + 1); } }