<?php
/**
 * The tao file of doc module of ZenTaoPMS.
 *
 * @copyright   Copyright 2009-2023 禅道软件（青岛）有限公司(ZenTao Software (Qingdao) Co., Ltd. www.zentao.net)
 * @license     ZPL(https://zpl.pub/page/zplv12.html) or AGPL(https://www.gnu.org/licenses/agpl-3.0.en.html)
 * @author      Shujie Tian <tianshujie@easycorp.ltd>
 * @package     doc
 * @link        https://www.zentao.net
 */
class docTao extends docModel
{
    /**
     * 获取编辑过的文档ID列表。
     * Get the list of doc id list that have been edited.
     *
     * @access protected
     * @return array
     */
    protected function getEditedDocIdList()
    {
        return $this->dao->select('objectID')->from(TABLE_ACTION)
            ->where('objectType')->eq('doc')
            ->andWhere('action')->in('edited')
            ->andWhere('actor')->eq($this->app->user->account)
            ->andWhere('vision')->eq($this->config->vision)
            ->fetchPairs();
    }

    /**
     * 获取已排序的执行数据。
     * Get ordered executions.
     *
     * @param  int       $append
     * @access protected
     * @return array
     */
    protected function getOrderedExecutions($append = 0)
    {
        $myObjects    = $normalObjects = $closedObjects = array();
        $projectPairs = $this->dao->select('id,name')->from(TABLE_PROJECT)->where('type')->eq('project')->fetchPairs('id');
        $executions   = $this->dao->select('*')->from(TABLE_EXECUTION)
            ->where('deleted')->eq(0)
            ->andWhere('type')->in('sprint,stage')
            ->andWhere('multiple')->eq('1')
            ->andWhere('vision')->eq($this->config->vision)
            ->beginIF(!$this->app->user->admin)->andWhere('id')->in($this->app->user->view->sprints)->fi()
            ->beginIF($append)->orWhere('id')->eq($append)->fi()
            ->orderBy('order_asc')
            ->fetchAll('id');

        foreach($executions as $id => $execution)
        {
            if($execution->type == 'stage' && $execution->grade != 1)
            {
                $parentExecutions = $this->dao->select('id,name')->from(TABLE_EXECUTION)->where('id')->in(trim($execution->path, ','))->andWhere('type')->in('stage,sprint')->orderBy('grade')->fetchPairs();
                $execution->name  = implode('/', $parentExecutions);
            }
            $execution->name = zget($projectPairs, $execution->project) . ' / ' . $execution->name;

            if($execution->status != 'done' && $execution->status != 'closed' && $execution->PM == $this->app->user->account)
            {
                $myObjects[$id] = $execution->name;
            }
            elseif($execution->status != 'done' && $execution->status != 'closed' && !($execution->PM == $this->app->user->account))
            {
                $normalObjects[$id] = $execution->name;
            }
            elseif(in_array($execution->status, array('done', 'closed')))
            {
                $closedObjects[$id] = $execution->name;
            }
        }

        return array($myObjects, $normalObjects, $closedObjects);
    }

    /**
     * 获取关联产品的数据。
     * Get the data of the linked product.
     *
     * @param  int       $productID
     * @param  string    $userView
     * @access protected
     * @return array
     */
    protected function getLinkedProductData($productID, $userView = '')
    {
        $storyIdList = $this->dao->select('id')->from(TABLE_STORY)
            ->where('product')->eq($productID)
            ->andWhere('deleted')->eq('0')
            ->beginIF(!$this->app->user->admin)->andWhere('product')->in($userView)->fi()
            ->get();

        $epicIdList = $this->dao->select('id')->from(TABLE_STORY)
            ->where('product')->eq($productID)
            ->andWhere('deleted')->eq('0')
            ->andWhere('type')->eq('epic')
            ->beginIF(!$this->app->user->admin)->andWhere('product')->in($userView)->fi()
            ->fetchPairs();

        $requirementIdList = $this->dao->select('id')->from(TABLE_STORY)
            ->where('product')->eq($productID)
            ->andWhere('deleted')->eq('0')
            ->andWhere('type')->eq('requirement')
            ->beginIF(!$this->app->user->admin)->andWhere('product')->in($userView)->fi()
            ->fetchPairs();

        $planIdList = $this->dao->select('id')->from(TABLE_PRODUCTPLAN)
            ->where('product')->eq($productID)
            ->andWhere('deleted')->eq('0')
            ->beginIF(!$this->app->user->admin)->andWhere('product')->in($userView)->fi()
            ->get();

        $releasePairs = $this->dao->select('id')->from(TABLE_RELEASE)
            ->where('product')->eq($productID)
            ->andWhere('deleted')->eq('0')
            ->beginIF(!$this->app->user->admin)->andWhere('product')->in($userView)->fi()
            ->fetchPairs('id');

        $casePairs = $this->dao->select('id')->from(TABLE_CASE)
            ->where('product')->eq($productID)
            ->andWhere('deleted')->eq('0')
            ->beginIF(!$this->app->user->admin)->andWhere('product')->in($userView)->fi()
            ->fetchPairs('id');

        $resultPairs = $this->dao->select('id')->from(TABLE_TESTRESULT)->where('case')->in($casePairs)->fetchPairs('id', 'id');

        return array($storyIdList, $epicIdList, $requirementIdList, $planIdList, $releasePairs, $casePairs, $resultPairs);
    }

    /**
     * 获取我创建的文档。
     * Get docs created by me.
     *
     * @param  array     $hasPrivDocIdList
     * @param  string    $sort
     * @param  object    $pager
     * @access protected
     * @return array
     */
    protected function getOpenedDocs($hasPrivDocIdList, $sort, $pager = null)
    {
        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('t1.lib')->ne(0)
            ->andWhere('t1.id')->in($hasPrivDocIdList)
            ->beginIF($this->config->doc->notArticleType)->andWhere('t1.type')->notIN($this->config->doc->notArticleType)->fi()
            ->andWhere('t1.addedBy')->eq($this->app->user->account)
            ->andWhere('t1.vision')->in($this->config->vision)
            ->andWhere('t1.templateType')->eq('')
            ->orderBy($sort)
            ->page($pager)
            ->fetchAll('id');
    }

    /**
     * 获取我编辑过的文档。
     * Get the docs that I have edited.
     *
     * @param  string    $sort
     * @param  object    $pager
     * @access protected
     * @return array
     */
    protected function getEditedDocs($sort, $pager = null)
    {
        $docIdList = $this->dao->select('objectID')->from(TABLE_ACTION)
            ->where('objectType')->eq('doc')
            ->andWhere('actor')->eq($this->app->user->account)
            ->andWhere('action')->eq('edited')
            ->andWhere('vision')->eq($this->config->vision)
            ->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('t1.id')->in(array_keys($docIdList))
            ->andWhere('t1.lib')->ne(0)
            ->andWhere('t1.vision')->in($this->config->vision)
            ->beginIF($this->config->doc->notArticleType)->andWhere('t1.type')->notIN($this->config->doc->notArticleType)->fi()
            ->orderBy($sort)
            ->page($pager)
            ->fetchAll('id');
    }

    /**
     * 获取按照编辑时间倒序排序的文档。
     * Get the docs ordered by edited date.
     *
     * @param  array     $hasPrivDocIdList
     * @param  array     $allLibIDList
     * @param  object    $pager
     * @access protected
     * @return array
     */
    protected function getOrderedDocsByEditedDate($hasPrivDocIdList, $allLibIDList, $pager = null)
    {
        return $this->dao->select('*')->from(TABLE_DOC)
            ->where('deleted')->eq(0)
            ->andWhere('id')->in($hasPrivDocIdList)
            ->andWhere('templateType')->eq('')
            ->beginIF($this->config->doc->notArticleType)->andWhere('type')->notIN($this->config->doc->notArticleType)->fi()
            ->andWhere('lib')->in($allLibIDList)
            ->andWhere('vision')->in($this->config->vision)
            ->orderBy('editedDate_desc')
            ->page($pager)
            ->fetchAll('id');
    }

    /**
     * 获取我收藏的文档。
     * Get the docs that I have collected.
     *
     * @param  array     $hasPrivDocIdList
     * @param  string    $sort
     * @param  object    $pager
     * @access protected
     * @return array
     */
    protected function getCollectedDocs($hasPrivDocIdList, $sort, $pager = null)
    {
        return $this->dao->select('t1.*')->from(TABLE_DOC)->alias('t1')
            ->leftJoin(TABLE_DOCACTION)->alias('t2')->on("t1.id=t2.doc AND t2.action='collect'")
            ->where('t1.deleted')->eq(0)
            ->andWhere('t1.lib')->ne(0)
            ->andWhere('t1.templateType')->eq('')
            ->andWhere('t1.id')->in($hasPrivDocIdList)
            ->beginIF($this->config->doc->notArticleType)->andWhere('t1.type')->notIN($this->config->doc->notArticleType)->fi()
            ->andWhere('t2.actor')->eq($this->app->user->account)
            ->andWhere('t1.vision')->in($this->config->vision)
            ->orderBy($sort)
            ->page($pager)
            ->fetchAll('id');
    }

    /**
     * 获取空间。
     * Get space pairs.
     *
     * @param  string     $type
     * @access protected
     * @return array
     */
    protected function getSpacePairs($type)
    {
        $objectLibs = $this->dao->select('*')->from(TABLE_DOCLIB)
            ->where('type')->eq($type)
            ->andWhere('deleted')->eq(0)
            ->andWhere('parent')->eq(0)
            ->andWhere('vision')->eq($this->config->vision)
            ->fetchAll();

        $pairs = array();
        foreach($objectLibs as $lib)
        {
            if($this->checkPrivLib($lib)) $pairs[$lib->id] = $lib->name;
        }

        return $pairs;
    }

    /**
     * 更新文档。
     * Update document.
     *
     * @param  int       $docID
     * @param  object    $doc
     * @param  bool      $basicInfoChanged
     * @access protected
     * @return void
     */
    public function doUpdateDoc($docID, $doc, $basicInfoChanged = false)
    {
        $this->dao->update(TABLE_DOC)->data($doc)->autoCheck()->where('id')->eq($docID)->exec();

        if(empty($doc->parent) && $basicInfoChanged)
        {
            $childData = new stdclass();
            $childData->module = $doc->module;
            $childData->lib    = $doc->lib;
            $childData->acl    = $doc->acl;
            if(isset($doc->groups)) $childData->groups = $doc->groups;
            if(isset($doc->users))  $childData->users  = $doc->users;

            $this->dao->update(TABLE_DOC)->data($childData)->where("FIND_IN_SET('{$docID}', `path`)")->exec();
        }
    }

    /**
     * 插入文档库。
     * Insert doclib.
     *
     * @param  object    $lib
     * @param  string    $requiredFields
     * @access protected
     * @return int|false
     */
    protected function doInsertLib($lib, $requiredFields = '')
    {
        $this->dao->insert(TABLE_DOCLIB)->data($lib, 'spaceName')->autoCheck()
            ->batchCheck($requiredFields, 'notempty')
            ->exec();

        if(dao::isError()) return false;
        return $this->dao->lastInsertID();
    }

    /**
     * Filter deleted documents.
     *
     * @param  array     $docs
     * @access protected
     * @return array
     */
    protected function filterDeletedDocs($docs)
    {
        $deletedDocs = array();
        foreach($docs as $docID => $doc)
        {
            if($doc->deleted == '0') continue;

            unset($docs[$docID]);

            $docPath = trim($doc->path, ',');
            if(empty($docPath))
            {
                $docPath = $docID;
                if(!empty($doc->parent)) $docPath = $doc->parent . ',' . $docPath;
            }
            $doc->path = ',' . $docPath . ',';
            $deletedDocs[$doc->id] = $doc->path;
        }

        foreach($deletedDocs as $deletedPath)
        {
            foreach($docs as $docID => $doc)
            {
                if($deletedPath && strpos($doc->path, $deletedPath) !== false) unset($docs[$docID]);
            }
        }

        return $docs;
    }
}