/library/Dao/Td/Tudu/Tudu.php

Large files files are truncated, but you can click here to view the full file

<?php
/**
 * Tudu Dao
 *
 * LICENSE
 *
 *
 * @category   Dao
 * @package    Dao_Td
 * @subpackage Tudu
 * @copyright  Copyright (c) 2009-2010 Shanghai Best Oray Information S&T CO., Ltd.
 * @link       http://www.oray.com/
 * @version    $Id: Tudu.php 2809 2013-04-07 09:57:05Z cutecube $
 */

/**
 * @category   Dao
 * @package    Dao_Td
 * @subpackage Tudu
 * @copyright  Copyright (c) 2009-2010 Shanghai Best Oray Information S&T CO., Ltd.
 */
class Dao_Td_Tudu_Tudu extends Oray_Dao_Abstract
{
    const STATUS_UNSTART  = 0;   // 未开始
    const STATUS_DOING    = 1;   // 进行中
    const STATUS_DONE     = 2;   // 已完成
    const STATUS_REJECT   = 3;   // 已拒绝
    const STATUS_CANCEL   = 4;   // 已取消

    const SPECIAL_CYCLE = 1;
    const SPECIAL_VOTE  = 2; // 投票

    const TYPE_TASK    = 'task';
    const TYPE_NOTICE  = 'notice';
    const TYPE_DISCUSS = 'discuss';
    const TYPE_MEETING = 'meeting';

    /**
     * 用户角色
     * @var string
     */
    const ROLE_ACCEPTER = 'to';      // 接收人
    const ROLE_SENDER   = 'from';    // 发送人
    const ROLE_CC       = 'cc';      // 被抄送

    /**
     * Initialize object
     *
     * Called from {@link __construct()} as final step of object instantiation.
     *
     * @return void
     */
    public function init()
    {}

    /**
     * Get record
     *
     * SELECT t.org_id AS orgid, t.board_id AS boardid, t.tudu_id AS tuduid, t.cycle_id AS cycleid,
     * t.type, t.subject, t.from, t.to, t.cc, t.priority, t.privacy,
     * p.post_id AS postid, p.content, p.poster_info AS posterinfo, p.attach_num AS attachnum,
     * t.last_post_time AS lastposttime, t.last_poster AS lastposter,
     * t.view_num AS viewnum, t.reply_num AS replynum, t.log_num AS lognum,
     * t.percent, t.score, t.status, t.special,
     * t.start_time AS starttime, t.end_time AS endtime,
     * t.total_time AS totaltime, t.elapsed_time AS elapsedtime,
     * t.accept_time AS accepttime, t.create_time AS create_time,
     * tu.unique_id AS uniqueid, TRIM(LEADING ',' FROM tu.labels) labels,
     * tu.is_read AS isread, tu.is_forward AS isforward,
     * t.is_draft AS isdraft, t.is_done AS isdone
     * FROM td_tudu t
     * LEFT JOIN td_post p ON p.tudu_id = t.tudu_id AND p.is_first = 1
     * LEFT JOIN td_tudu_user tu ON tu.tudu_id = t.tudu_id AND tu.unique_id = ?
     * WHERE t.tudu_id = ?
     *
     * @param array $condition
     * @param array $filter
     * @return Dao_Td_Tudu_Record_Tudu
     */
    public function getTudu(array $condition, $filter = null)
    {
        if (empty($condition['tuduid'])
            || empty($condition['uniqueid'])) {
            return null;
        }

        $table   = "td_tudu t "
                 . "LEFT JOIN td_post p ON p.tudu_id = t.tudu_id AND p.is_first = 1 "
                 . "LEFT JOIN td_tudu_group g ON g.tudu_id = p.tudu_id "
                 . "LEFT JOIN td_class c ON t.class_id = c.class_id AND t.org_id = c.org_id AND t.board_id = c.board_id "
                 . "LEFT JOIN td_flow f ON t.flow_id = f.flow_id AND t.org_id = f.org_id AND t.board_id = f.board_id "
                 . "LEFT JOIN td_tudu_user tu ON tu.tudu_id = t.tudu_id AND tu.unique_id = "
                 . $this->_db->quote($condition['uniqueid']) . " "
                 . "LEFT JOIN td_tudu_flow fl ON fl.tudu_id = t.tudu_id";

        $columns = "t.org_id AS orgid, t.board_id AS boardid, t.tudu_id AS tuduid, t.cycle_id AS cycleid, t.prev_tudu_id AS prevtuduid, "
                 . "t.type, t.subject, t.from, t.to, t.cc, t.bcc, t.priority, t.privacy, t.password, t.is_auth AS isauth, fl.current_step_id AS stepid, "
                 . "p.post_id AS postid, p.content, p.header, p.poster_info AS posterinfo, p.attach_num AS attachnum, t.app_id AS appid, "
                 . "t.last_post_time AS lastposttime, t.last_poster AS lastposter, t.last_forward AS lastforward, "
                 . "t.view_num AS viewnum, t.reply_num AS replynum, t.log_num AS lognum, t.cycle_num AS cyclenum, "
                 . "fl.step_num as stepnum, t.percent, t.score, t.status, t.special, t.notify_all AS notifyall, t.accep_mode AS accepmode,"
                 . "t.start_time AS starttime, t.end_time AS endtime, t.need_confirm AS needconfirm, "
                 . "t.total_time AS totaltime, t.elapsed_time AS elapsedtime, "
                 . "t.accept_time AS accepttime, t.create_time AS createtime, "
                 . "tu.unique_id AS uniqueid, TRIM(LEADING ',' FROM tu.labels) labels, "
                 . "tu.is_read AS isread, tu.is_forward AS isforward, tu.mark, "
                 . "tu.role, tu.percent AS selfpercent, tu.forward_info AS forwardinfo, "
                 . "tu.tudu_status AS selftudustatus, tu.accept_time AS selfaccepttime, tu.auth_code AS authcode, "
                 . "t.is_draft AS isdraft, t.is_done AS isdone, t.is_top AS istop, p.is_send AS issend, "
                 . "t.class_id AS classid, t.flow_id AS flowid, c.class_name AS classname, "
                 . "g.type AS nodetype, g.parent_tudu_id AS parentid, g.root_tudu_id AS rootid";
        $where   = array();

        $where[] = 't.tudu_id = ' . $this->_db->quote($condition['tuduid']);

        if (isset($filter['orgid'])) {
            $where[] = 't.org_id = ' . $this->_db->quote($filter['orgid']);
        }

        // WHERE
        $where = implode(' AND ', $where);

        $sql = "SELECT {$columns} FROM {$table} WHERE {$where} LIMIT 0, 1";

        $record = $this->_db->fetchRow($sql);

        if (!$record) {
            return null;
        }

        return Oray_Dao::record('Dao_Td_Tudu_Record_Tudu', $record);
    }


    /**
     * Get records
     *
     * SQL here..
     *
     * @param array $condition
     * @param array $filter
     * @param array $sort
     * @param int   $maxCount
     * @return Oray_Dao_Recordset
     */
    public function getTudus(array $condition, $filter = null, $sort = null, $maxCount = null)
    {
        $table   = "td_tudu t LEFT JOIN td_tudu_group g ON t.tudu_id = g.tudu_id";
        $columns = 't.org_id AS orgid, t.board_id AS boardid, t.tudu_id AS tuduid, `from`, `to`, is_draft AS isdraft, subject, '
                 . 'g.type AS nodetype, g.parent_tudu_id AS parentid';
        $where   = array();
        $order   = array();
        $limit   = '';

        if (!empty($condition['tuduids']) && is_array($condition['tuduids'])) {
            $where[] = 't.tudu_id IN(' . implode(',', array_map(array($this->_db, 'quote'), $condition['tuduids'])) . ')';
        }

        if (!empty($condition['parentid'])) {
            $where[] = 'g.parent_tudu_id = ' . $this->_db->quote($condition['parentid']);

            if (!empty($condition['uniqueid'])) {
                $where[] = 'g.unique_id = ' . $this->_db->quote($condition['uniqueid']);
            }
        }

        if (empty($where)) {
            return new Oray_Dao_Recordset();
        }

        // WHERE
        $where = implode(' AND ', $where);
        if ($where) {
            $where = 'WHERE ' . $where;
        }

        $sort  = $this->_formatSort($sort);
        foreach ($sort as $key => $val) {
            switch ($key) {
                default:
                    continue 2;
            }
            $order[] = $key . ' ' . $val;
        }

        // ORDER
        $order = implode(', ', $order);
        if ($order) {
            $order = 'ORDER BY ' . $order;
        }

        // LIMIT
        if (is_int($maxCount) && $maxCount > 0) {
            $limit = 'LIMIT ' . $maxCount;
        }

        $sql = "SELECT $columns FROM $table $where $order $limit";
        $records = $this->_db->fetchAll($sql);

        return new Oray_Dao_Recordset($records, 'Dao_Td_Tudu_Record_Tudus');
    }

    /**
     *
     * @param $condition
     * @param $filter
     */
    public function getUserTudus(array $condition, $filter = null, $offset = null, $count = null)
    {
        $table = "td_tudu t "
               . "LEFT JOIN td_tudu_group g ON g.tudu_id = t.tudu_id "
               . "LEFT JOIN td_tudu_user tu ON tu.tudu_id = t.tudu_id AND tu.unique_id = "
               . $this->_db->quote($condition['uniqueid'])
               . "LEFT JOIN td_post AS p ON p.tudu_id = t.tudu_id AND p.is_first = 1";

        $columns = "t.org_id AS orgid, t.board_id AS boardid, t.tudu_id AS tuduid, t.is_done AS isdone, t.percent, t.cycle_id AS cycleid, t.percent, t.reply_num AS replynum, t.accept_time AS lastaccepttime, "
                 . "t.last_post_time AS lastposttime, t.is_done, t.priority, t.privacy, t.password, t.start_time AS starttime, t.end_time AS endtime, p.attach_num AS attachnum, tu.accept_time as accepttime, "
                 . "t.type, t.subject, t.from, t.to, t.cc, t.bcc, t.status, t.is_draft AS isdraft, t.need_confirm AS needconfirm, tu.unique_id AS uniqueid, "
                 . "TRIM(LEADING ',' FROM tu.labels) labels, tu.role, tu.accepter_info AS accepterinfo, tu.tudu_status AS selfstatus, tu.is_read as isread, g.type as nodetype ";
        $where   = array();
        $limit   = '';

        if (empty($condition)) {
            return null;
        }

        if (!empty($condition['uniqueid'])) {
            $where[] = 'tu.unique_id = ' . $this->_db->quote($condition['uniqueid']);
        }

        if (!empty($condition['labelid'])) {
            $table  .= ' LEFT JOIN td_tudu_label AS tl ON tl.unique_id = tu.unique_id AND tl.tudu_id = tu.tudu_id';
            $where[] = 'tl.label_id = ' . $this->_db->quote($condition['labelid']);
        }

        if (!empty($condition['type'])) {
            $where[] = 't.type = ' . $this->_db->quote($condition['type']);
        }

        // 关键字
        if (!empty($condition['keyword'])) {
            $keyword = $this->_db->quote('%' . $condition['keyword'] . '%');
            $where[] = 't.subject LIKE ' . $keyword;
        }

        if (!$filter || !isset($filter['role']) || $filter['role'] == true) {
            $where[] = 'tu.role IS NOT NULL';
        }

        if (!$filter || !isset($filter['isdone']) || $filter['isdone'] == true) {
            $where[] = 't.status <= 2';
            $where[] = 't.is_done = 0';
        }

        $where = implode(' AND ', $where);
        if ($where) {
            $where = 'WHERE ' . $where;
        }

        if (null !== $count) {
            $limit = 'LIMIT';
            if (null !== $offset) {
                $limit .= ' ' . (int) $offset . ',';
            }

            $limit .= ' ' . (int) $count;
        }

        $sql = "SELECT $columns FROM $table $where ORDER BY last_post_time DESC $limit";

        $records = $this->_db->fetchAll($sql);

        if (!$records) {
            return array();
        }

        return $records;
    }

    /**
     * 读取图度组
     *
     * @param array $condition
     * @param array $filter
     */
    public function getTuduGroups(array $condition, $filter = null)
    {
        $table   = "td_tudu t "
                 . "LEFT JOIN td_tudu_group g ON g.tudu_id = t.tudu_id "
                 . "INNER JOIN td_tudu_user tu ON tu.tudu_id = t.tudu_id";
        $columns = "t.org_id AS orgid, t.board_id AS boardid, tu.unique_id AS uniqueid, t.tudu_id AS tuduid, "
                 . "t.subject, t.type, t.from, t.to, g.type AS nodetype";
        $where   = array();
        $bind    = array();

        if (isset($condition['uniqueid'])) {
            $where[] = "tu.unique_id = :uniqueid";
            $bind['uniqueid'] = $condition['uniqueid'];
        }

        if (isset($condition['orgid'])) {
            $where[] = "t.org_id = :orgid";
            $bind['orgid'] = $condition['orgid'];
        }

        if ($filter && array_key_exists('isdraft', $filter)) {
            if (null !== $filter['isdraft']) {
                $where[] = "t.is_draft = " . ($filter['isdraft'] ? 1 : 0);
            }
        } else {
            $where[] = "t.is_draft = 0";
        }

        if ($filter && array_key_exists('isdone', $filter)) {
            if (null !== $filter['isdone']) {
                $where[] = "t.is_done = " . ($filter['isdone'] ? 1 : 0);
            }
        } else {
            $where[] = "t.is_done = 0";
        }

        $where[] = "(g.type = 'node' OR  g.type = 'root')";

        // WHERE
        $where = implode(' AND ', $where);
        if ($where) {
            $where = 'WHERE ' . $where;
        }

        $sql = "SELECT $columns FROM $table $where ORDER BY t.last_post_time DESC";

        $records = $this->_db->fetchAll($sql, $bind);

        if (!$records) {
            return new Oray_Dao_Recordset();
        }

        return new Oray_Dao_Recordset($records, 'Dao_Td_Tudu_Record_TuduGroups');
    }

    /**
     *
     *
     * @param $condition
     * @param $filter
     * @param $sort
     * @param $maxCount
     */
    public function getGroupTudus(array $condition, $filter = null, $sort = null, $maxCount = null)
    {
        $table   = "td_tudu t "
                 . "LEFT JOIN td_post p ON p.tudu_id = t.tudu_id AND p.is_first = 1 "
                 . "LEFT JOIN td_tudu_group g ON g.tudu_id = p.tudu_id "
                 . "LEFT JOIN td_class c ON t.class_id = c.class_id AND t.org_id = c.org_id AND t.board_id = c.board_id "
                 . "LEFT JOIN td_tudu_flow fl ON fl.tudu_id = t.tudu_id "
                 . "LEFT JOIN td_tudu_user tu ON tu.tudu_id = t.tudu_id AND tu.unique_id = "
                 . $this->_db->quote($condition['uniqueid']);

        $columns = "t.org_id AS orgid, t.board_id AS boardid, t.tudu_id AS tuduid, t.cycle_id AS cycleid, t.prev_tudu_id AS prevtuduid, "
                 . "t.type, t.subject, t.from, t.to, t.cc, t.priority, t.privacy, t.password, fl.current_step_id AS stepid, "
                 . "p.post_id AS postid, '' AS content, '' AS posterinfo, p.attach_num AS attachnum, "
                 . "t.last_post_time AS lastposttime, t.last_poster AS lastposter, t.last_forward AS lastforward, "
                 . "t.view_num AS viewnum, t.reply_num AS replynum, t.log_num AS lognum, "
                 . "t.percent, t.score, t.status, t.special, t.notify_all AS notifyall, t.accep_mode AS accepmode, "
                 . "t.start_time AS starttime, t.end_time AS endtime, t.complete_time AS completetime, t.need_confirm AS needconfirm, "
                 . "t.total_time AS totaltime, t.elapsed_time AS elapsedtime, "
                 . "t.accept_time AS accepttime, t.create_time AS createtime, "
                 . "tu.unique_id AS uniqueid, TRIM(LEADING ',' FROM tu.labels) labels, "
                 . "tu.is_read AS isread, tu.is_forward AS isforward, tu.mark, "
                 . "tu.role, tu.percent AS selfpercent, tu.forward_info AS forwardinfo, "
                 . "tu.tudu_status AS selftudustatus, tu.accept_time AS selfaccepttime, "
                 . "t.is_draft AS isdraft, t.is_done AS isdone, t.is_top AS istop, p.is_send AS issend, "
                 . "t.class_id AS classid, t.flow_id AS flowid, c.class_name AS classname, "
                 . "g.type AS nodetype, g.parent_tudu_id AS parentid";
        $where   = array();
        $order   = array();
        $limit   = '';

        if (!empty($condition['tuduids']) && is_array($condition['tuduids'])) {
            $where[] = 't.tudu_id IN(' . implode(',', array_map(array($this->_db, 'quote'), $condition['tuduids'])) . ')';
        }

        if (!empty($condition['parentid'])) {
            $where[] = 'g.parent_tudu_id = ' . $this->_db->quote($condition['parentid']);
        }

        if (!empty($condition['senderid'])) {
            $where[] = 'g.unique_id = ' . $this->_db->quote($condition['senderid']);
        }

        if (!empty($condition['role'])) {
            $where[] = 'tu.role = ' . $this->_db->quote($condition['role']);
        }

        if (!empty($condition['starttime']) && !empty($condition['endtime'])) {
            $startTime = (int) $condition['starttime'];
            $endTime   = (int) $condition['endtime'];
            $where[] = "(((t.start_time >= {$startTime} AND t.start_time <= {$endTime}) "
                 . "OR (t.end_time >= {$startTime} AND t.end_time <= {$endTime}) "
                 . "OR ((t.start_time <= {$startTime} OR t.start_time IS NULL) "
                 . "AND (t.end_time >= {$endTime} OR t.end_time IS NULL)))"
                 . "AND (((t.complete_time <= {$endTime} AND t.complete_time >= {$startTime}) "
                 . "OR (t.complete_time >= {$endTime} AND t.complete_time >= {$startTime})) "
                 . "OR t.complete_time IS NULL) OR (t.status <= 1 AND DATEDIFF(FROM_UNIXTIME(UNIX_TIMESTAMP(), '%Y-%m-%d'), FROM_UNIXTIME(t.end_time, '%Y-%m-%d')) > 0 AND t.end_time <= {$endTime}))";

            // 不显示“已取消”，和“已拒绝并确认“的图度
            $where[] = '(t.status <= 2 OR (t.status = 3 AND t.is_done = 0)) ';
        }

        if ($filter && array_key_exists('isdraft', $filter)) {
            if (null !== $filter['isdraft']) {
                $where[] = 't.is_draft = ' . ($filter['isdraft'] ? 1 : 0);
            }
        } else {
            $where[] = 't.is_draft = 0';
        }

        if (empty($where)) {
            return new Oray_Dao_Recordset();
        }

        // WHERE
        $where = implode(' AND ', $where);
        if ($where) {
            $where = 'WHERE ' . $where;
        }

        $sort  = $this->_formatSort($sort);
        foreach ($sort as $key => $val) {
            switch ($key) {
                case 'lastposttime':
                    $key = 'last_post_time';
                    break;
                case 'subject':
                    $key = 'subject';
                    break;
                case 'endtime':
                    $key = 'end_time';
                    break;
                case 'from':
                    $key = '`from`';
                    break;
                case 'to':
                    $key = '`to`';
                    break;
                case 'istop':
                    $key = 'is_top';
                    break;
                default:
                    continue 2;
                    break;
            }
            $order[] = $key . ' ' . $val;
        }

        // ORDER
        $order = implode(', ', $order);
        if ($order) {
            $order = 'ORDER BY ' . $order;
        }

        // LIMIT
        if (is_int($maxCount) && $maxCount > 0) {
            $limit = 'LIMIT ' . $maxCount;
        }

        $sql = "SELECT $columns FROM $table $where $order $limit";

        $records = $this->_db->fetchAll($sql);

        return new Oray_Dao_Recordset($records, 'Dao_Td_Tudu_Record_Tudu');
    }

    /**
     * 获取用户图度箱的图度列表
     *
     * SELECT t.org_id AS orgid, t.board_id AS boardid, t.tudu_id AS tuduid, t.cycle_id AS cycleid,
     * t.type, t.subject, t.from, t.to, t.cc, t.priority, t.privacy,
     * t.last_post_time AS lastposttime, t.last_poster AS lastposter,
     * t.view_num AS viewnum, t.reply_num AS replynum, t.log_num AS lognum, t.percent, t.score, t.status,
     * t.start_time AS starttime, t.end_time AS endtime,
     * t.total_time AS totaltime, t.elapsed_time AS elapsedtime,
     * t.create_time AS create_time, p.post_id AS postid, p.content, '' AS posterinfo, p.attach_num AS attachnum,
     * tu.unique_id AS uniqueid, TRIM(LEADING ',' FROM tu.labels) labels,
     * tu.is_read AS isread, tu.is_forward AS isforward, is_draft AS isdraft, is_done AS isdone
     * FROM td_tudu t
     * LEFT JOIN td_post p ON p.tudu_id = t.tudu_id AND p.is_first = 1
     * INNER JOIN td_tudu_user tu ON tu.tudu_id = t.tudu_id
     * LEFT JOIN td_tudu_label tl ON tl.tudu_id = t.tudu_id AND tl.unique_id = tu.unique_id
     * WHERE tu.unique_id = ? AND tl.label_id = ?
     *
     * @param array $condition
     * @param mixed $sort
     * @param int $page
     * @param int $pageSize
     * @return Oray_Dao_Recordset
     */
    public function getTuduPage(array $condition = null, $sort = null, $page = null, $pageSize = null)
    {
        $table   = 'td_tudu t '
                 . 'LEFT JOIN td_post p ON p.tudu_id = t.tudu_id AND p.is_first = 1 '
                 . 'LEFT JOIN td_tudu_group g ON g.tudu_id = p.tudu_id '
                 . 'INNER JOIN td_tudu_user tu ON tu.tudu_id = t.tudu_id '
                 . "LEFT JOIN td_class c ON t.class_id = c.class_id AND t.org_id = c.org_id AND t.board_id = c.board_id "
                 . 'LEFT JOIN td_tudu_label tl ON tl.tudu_id = t.tudu_id AND tl.unique_id = tu.unique_id '
                 . 'LEFT JOIN td_tudu_cycle tc ON tc.cycle_id = t.cycle_id '
                 . 'LEFT JOIN td_tudu_flow fl ON fl.tudu_id = t.tudu_id ';

        $columns = "t.org_id AS orgid, t.board_id AS boardid, t.tudu_id AS tuduid, t.cycle_id AS cycleid, t.prev_tudu_id AS prevtuduid, "
                 . "t.type, t.subject, t.from, t.to, t.cc, t.priority, t.privacy, t.password, fl.current_step_id AS stepid, t.app_id AS appid, "
                 . "t.last_post_time AS lastposttime, t.last_poster AS lastposter, t.last_forward AS lastforward, t.flow_id AS flowid, "
                 . "t.view_num AS viewnum, t.reply_num AS replynum, t.log_num AS lognum, t.percent, t.score, t.status, "
                 . "t.special, t.start_time AS starttime, t.end_time AS endtime, t.complete_time AS completetime, t.notify_all AS notifyall, "
                 . "t.total_time AS totaltime, t.elapsed_time AS elapsedtime, t.need_confirm AS needconfirm, "
                 . "t.create_time AS createtime, t.accept_time AS accepttime, t.accep_mode AS accepmode, "
                 . "p.post_id AS postid, '' AS content, '' AS posterinfo, p.attach_num AS attachnum, "
                 . "tu.unique_id AS uniqueid, TRIM(LEADING ',' FROM tu.labels) labels, tu.mark, "
                 . "tu.is_read AS isread, tu.is_forward AS isforward, is_draft AS isdraft, t.is_done AS isdone, t.is_top AS istop, "
                 . "tu.role, tu.percent AS selfpercent, tu.forward_info AS forwardinfo, "
                 . "tu.tudu_status AS selftudustatus, tu.accept_time AS selfaccepttime, "
                 . "t.class_id AS classid, c.class_name AS classname, tc.display_date AS displaydate, "
                 . "g.type AS nodetype, g.parent_tudu_id AS parentid";
        $primary = "t.tudu_id";
        $recordClass = "Dao_Td_Tudu_Record_Tudu";
        $where = array();
        $order = array();

        // $condition...
        if (isset($condition['tuduindexnum'])) {
            if (is_array($condition['tuduindexnum'])) {
                $arr = array_map('intval', $condition['tuduindexnum']);
                $where[] = 't.tudu_index_num IN (' . implode(',', $arr) . ')';
            } else {
                $where[] = 't.tudu_index_num = ' . $condition['tuduindexnum'];
            }
        }

        if (isset($condition['uniqueid'])) {
            $where[] = 'tu.unique_id = ' . $this->_db->quote($condition['uniqueid']);
        }

        if (isset($condition['label'])) {
            $where[] = 'tl.label_id = ' . $this->_db->quote($condition['label']);
        }

        // 板块
        if (isset($condition['boardid'])) {
            $where[] = 't.board_id = ' . $this->_db->quote($condition['boardid']);
        }

        // 主题分类
        if (isset($condition['classid'])) {
            $where[] = 't.class_id = ' . $this->_db->quote($condition['classid']);
        }

        // 查找已读状态
        if (isset($condition['isread'])) {
            $where[] = 'tu.is_read = ' . ($condition['isread'] ? 1 : 0);
        }

        // 关键字
        if (!empty($condition['keyword'])) {
            $keyword = $this->_db->quote('%' . $condition['keyword'] . '%');
            $where[] = 't.subject LIKE ' . $keyword;
        }

        // 发送人
        if (!empty($condition['from'])) {
            $from = $this->_db->quote('%' . $condition['from'] . '%');
            $where[] = 't.from LIKE ' . $from;
        }

        // 接收人
        if (!empty($condition['to'])) {
            $to = $this->_db->quote('%' . $condition['to'] . '%');
            $where[] = 't.to LIKE ' . $to;
        }

        // 状态
        if (isset($condition['status'])) {
            if (is_array($condition['status'])) {
                foreach ($condition['status'] as $item) {
                    $status[] = $this->_db->quote($item);
                }
                $where[] = 't.status IN (' . implode(',', $status) . ')';
            } else if (is_int($condition['status'])) {
                $where[] = 't.status = ' . $condition['status'];
            }
        }

        // 类型
        if (!empty($condition['type'])) {
            $where[] = 't.type = ' . $this->_db->quote($condition['type']);
        }

        // 已完成
        if (isset($condition['isdone'])) {
            $where[] = 't.is_done = ' . ($condition['isdone'] ? 1 : 0);
        }

        // 甘特图
        if(!empty($condition['startdate']) && !empty($condition['enddate'])) {
            $startDate = (int) $condition['startdate'];
            $endDate = (int) $condition['enddate'];
             $where[] = "(((t.start_time >= {$startDate} AND t.start_time <= {$endDate}) "
                 . "OR (t.end_time >= {$startDate} AND t.end_time <= {$endDate}) "
                 . "OR ((t.start_time <= {$startDate} OR t.start_time IS NULL) "
                 . "AND (t.end_time >= {$endDate} OR t.end_time IS NULL)))"
                 . "AND (((t.complete_time <= {$endDate} AND t.complete_time >= {$startDate}) "
                 . "OR (t.complete_time >= {$endDate} AND t.complete_time >= {$startDate})) "
                 . "OR t.complete_time IS NULL) OR (t.status <= 1 AND DATEDIFF(FROM_UNIXTIME(UNIX_TIMESTAMP(), '%Y-%m-%d'), FROM_UNIXTIME(t.end_time, '%Y-%m-%d')) > 0 AND t.end_time <= {$endDate}))";
        }

        $array = array(
            'createtime' => 't.create_time',
            'endtime'    => 't.end_time',
            'starttime'  => 't.start_time'
        );

        // createtime, endtime, starttime
        foreach ($array as $key => $col) {
            if (!isset($condition[$key])) {
                continue ;
            }

            if (is_array($condition[$key])) {
                $arr = array();
                if (isset($condition[$key]['start'])) {
                    $arr[] = $col . ' >= ' . (int) $condition[$key]['start'];
                }

                if (isset($condition[$key]['end'])) {
                    $arr[] = $col . ' <= ' . (int) $condition[$key]['end'];
                }

                if ($arr) {
                    $where[] = '(' . $col . ' IS NOT NULL AND ' . implode(' AND ', $arr) . ')';
                }
            } elseif (is_int($condition[$key])) {
                $where[] = '(' . $col . ' IS NOT NULL AND ' . $col . ' >= ' . $condition[$key] . ')';
            }
        }

        // 过期
        if (isset($condition['expiredate']) && is_int($condition['expiredate'])) {
            $where[] = '(tu.is_read = 0 OR t.start_time IS NULL OR t.start_time <= ' . $condition['expiredate'] . ')';
        }

        // WHERE
        $where = implode(' AND ', $where);
        if ($where) {
            $where = 'WHERE ' . $where;
        }

        // 格式化排序参数
        $sort = $this->_formatSort($sort);
        foreach ($sort as $key => $val) {
            switch ($key) {
                case 'lastposttime':
                    $key = 'last_post_time';
                    break;
                case 'subject':
                    $key = 'subject';
                    break;
                case 'endtime':
                    $key = 'end_time';
                    break;
                case 'starttime':
                    $key = 'start_time';
                    break;
                case 'from':
                    $key = '`from`';
                    break;
                case 'to':
                    $key = '`to`';
                    break;
                case 'istop':
                    $key = 'is_top';
                    break;
                case 'percent':
                    $key = 'percent';
                    break;
                default:
                    continue 2;
                    break;
            }
            $order[] = $key . ' ' . $val;
        }

        // ORDER
        $order = implode(', ', $order);
        if ($order) {
            $order = 'ORDER BY ' . $order;
        }

        if (null === $pageSize && null === $page) {
            $sql = "SELECT $columns FROM $table $where $order";
        } else {

            // 使用默认的分页大小
            if (null === $pageSize) {
                $pageSize = self::$_defaultPageSize;
            }

            if ($page < 1) $page = 1;

            $sql = "SELECT $columns FROM $table $where $order LIMIT " . $pageSize * ($page - 1) . ", " . $pageSize;
        }

        $records = $this->_db->fetchAll($sql);

        return new Oray_Dao_Recordset($records, $recordClass);
    }

    /**
     * 获取版块的图度列表
     *
     * SELECT
     * t.org_id AS orgid, t.board_id AS boardid, t.tudu_id AS tuduid, t.cycle_id AS cycleid,
     * t.type, t.subject, t.from, t.to, t.cc, t.priority, t.privacy,
     * t.last_post_time AS lastposttime, t.last_poster AS lastposter,
     * t.view_num AS viewnum, t.reply_num AS replynum, t.log_num AS lognum, t.percent, t.score, t.status,
     * t.special, t.start_time AS starttime, t.end_time AS endtime,
     * t.total_time AS totaltime, t.elapsed_time AS elapsedtime,
     * t.create_time AS createtime, t.accept_time AS accepttime,
     * p.post_id AS postid, '' AS content, '' AS posterinfo, p.attach_num AS attachnum,
     * tu.unique_id AS uniqueid, TRIM(LEADING ',' FROM tu.labels) labels,
     * tu.is_read AS isread, tu.is_forward AS isforward, is_draft AS isdraft, is_done AS isdone,
     * g.type AS nodetype, g.parent_tudu_id AS parentid
     *
     * FROM td_tudu t
     * LEFT JOIN td_tudu_group g ON g.tudu_id = p.tudu_id
     * LEFT JOIN td_post p ON p.tudu_id = t.tudu_id AND p.is_first = 1
     * LEFT JOIN td_tudu_user tu ON tu.tudu_id = t.tudu_id AND tu.unique_id = ?
     *
     * WHERE t.is_draft = 0
     * AND t.org_id = ?
     * AND t.board_id = ?
     *
     * @param array $condition
     * @param mixed $sort
     * @param int $page
     * @param int $pageSize
     * @return Oray_Dao_Recordset
     */
    public function getBoardTuduPage(array $condition = null, $sort = null, $page = null, $pageSize = null)
    {
        $uniqueId = isset($condition['uniqueid'])
                  ? $this->_db->quote($condition['uniqueid'])
                  : "''";

        $table    = "td_tudu t "
                  . "LEFT JOIN td_post p ON p.tudu_id = t.tudu_id AND p.is_first = 1 "
                  . "LEFT JOIN td_tudu_group g ON g.tudu_id = p.tudu_id "
                  . "LEFT JOIN td_class c ON t.class_id = c.class_id AND t.org_id = c.org_id AND t.board_id = c.board_id "
                  . 'LEFT JOIN td_tudu_cycle tc ON tc.cycle_id = t.cycle_id '
                  . "LEFT JOIN td_tudu_user tu ON tu.tudu_id = t.tudu_id AND tu.unique_id = " . $uniqueId;
        $columns  = "t.org_id AS orgid, t.board_id AS boardid, t.tudu_id AS tuduid, t.cycle_id AS cycleid, "
                  . "t.type, t.subject, t.from, t.to, t.cc, t.priority, t.privacy, t.password, "
                  . "t.last_post_time AS lastposttime, t.last_poster AS lastposter, t.flow_id AS flowid, "
                  . "t.view_num AS viewnum, t.reply_num AS replynum, t.log_num AS lognum, t.percent, t.score, t.status, "
                  . "t.special, t.start_time AS starttime, t.end_time AS endtime, t.need_confirm AS needconfirm, "
                  . "t.total_time AS totaltime, t.elapsed_time AS elapsedtime, t.accep_mode AS accepmode, "
                  . "t.create_time AS createtime, t.accept_time AS accepttime, "
                  . "p.post_id AS postid, '' AS content, '' AS posterinfo, p.attach_num AS attachnum, "
                  . "tu.unique_id AS uniqueid, TRIM(LEADING ',' FROM tu.labels) labels, tu.mark, "
                  . "tu.is_read AS isread, tu.is_forward AS isforward, is_draft AS isdraft, is_done AS isdone, t.is_top AS istop, "
                  . "t.class_id AS classid, c.class_name AS classname, tc.display_date AS displaydate, "
                  . "g.type AS nodetype, g.parent_tudu_id AS parentid";
        $primary  = "t.tudu_id";
        $recordClass = "Dao_Td_Tudu_Record_Tudu";
        $where = array();
        $order = array();

        if (isset($condition['orgid'])) {
            $where[] = 't.org_id = ' . $this->_db->quote($condition['orgid']);
        }

        if (isset($condition['boardid'])) {
            if (is_array($condition['boardid'])) {
                $where[] = 't.board_id IN(' . implode(',', array_map(array($this->_db, 'quote'), $condition['boardid'])) . ')';
            } else {
                $where[] = 't.board_id = ' . $this->_db->quote($condition['boardid']);
            }
        }

        // 关键字
        if (!empty($condition['keyword'])) {
            $keyword = $this->_db->quote('%' . $condition['keyword'] . '%');
            $where[] = 't.subject LIKE ' . $keyword;
        }

        // 发送人
        if (!empty($condition['from'])) {
            $from = $this->_db->quote('%' . $condition['from'] . '%');
            $where[] = 't.from LIKE ' . $from;
        }

        // 接收人
        if (!empty($condition['to'])) {
            $to = $this->_db->quote('%' . $condition['to'] . '%');
            $where[] = 't.to LIKE ' . $to;
        }

        // 主题分类
        if (isset($condition['classid'])) {
            $where[] = 'c.class_id = ' . $this->_db->quote($condition['classid']);
        }

        // 类型
        if (!empty($condition['type'])) {
            if (is_array($condition['type'])) {
                $where[] = 't.type IN ( ' . implode(',', array_map(array($this->_db, 'quote'), $condition['type'])) . ')';
            } else {
                $where[] = 't.type = ' . $this->_db->quote($condition['type']);
            }
        }

        if (isset($condition['priority']) && is_int($condition['priority'])) {
            $where[] = 't.priority = ' . $condition['priority'];
        }

        if (isset($condition['status']) && is_int($condition['status'])) {
            $where[] = 't.status = ' . $condition['status'];
        }

        // 创建时间
        if (isset($condition['createtime'])) {
            if (is_array($condition['createtime'])) {
                $array = array();
                if (isset($condition['createtime']['start']) && is_int($condition['createtime']['start'])) {
                    $array[] = 't.create_time >= ' . $condition['createtime']['start'];
                }

                if (isset($condition['createtime']['end']) && is_int($condition['createtime']['end'])) {
                    $array[] = 't.create_time <= ' . $condition['createtime']['end'];
                }

                if ($array) {
                    $where[] = '(' . implode(' AND ', $array) . ')';
                }
            } elseif (is_int($condition['createtime'])) {
                $where[] = 't.create_time >= ' . $condition['createtime'];
            }
        }

        // 创建时间
        if (isset($condition['endtime'])) {
            if (is_array($condition['endtime'])) {
                $array = array();
                if (isset($condition['endtime']['start']) && is_int($condition['endtime']['start'])) {
                    $array[] = 't.end_time >= ' . $condition['endtime'];
                }

                if (isset($condition['endtime']['end']) && is_int($condition['endtime']['end'])) {
                    $array[] = 't.end_time <= ' . $condition['endtime'];
                }

                if ($array) {
                    $where[] = '(' . implode(' AND ', $array) . ')';
                }
            } elseif (is_int($condition['endtime'])) {
                $where[] = 't.end_time >= ' . $condition['endtime'];
            }
        }

        // 过期
        if (isset($condition['expiredate']) && is_int($condition['expiredate'])) {
            $where[] = '(t.is_done <> 1 OR t.create_time >= ' . $condition['expiredate'] . ')';
        }

        // 过滤草稿
        $where[] = 't.is_draft = 0';

        if (isset($condition['privacy'])) {
            $where[] = '(t.privacy = 0 OR tu.unique_id = ' . $uniqueId . ')';
        }

        if (isset($condition['self'])) {
            $where[] = 'tu.unique_id = ' . $uniqueId;
        }

        // WHERE
        $where = implode(' AND ', $where);

        // 格式化排序参数
        $sort = $this->_formatSort($sort);
        foreach ($sort as $key => $val) {
            switch ($key) {
                case 'lastposttime':
                    $key = 'last_post_time';
                    break;
                case 'subject':
                    $key = 'subject';
                    break;
                case 'endtime':
                    $key = 'end_time';
                    break;
                case 'istop':
                    $key = 'is_top';
                    break;
                default:
                    continue 2;
                    break;
            }
            $order[] = $key . ' ' . $val;
        }

        // ORDER
        $order = implode(', ', $order);

        // 使用默认的分页大小
        if (null === $pageSize) {
            $pageSize = self::$_defaultPageSize;
        }

        /**
         * @see Oray_Db_Paginator
         */
        require_once 'Oray/Db/Paginator.php';

        // 初始化分页器
        $paginator = new Oray_Db_Paginator(array(
            Oray_Db_Paginator::ADAPTER      => $this->_db,
            Oray_Db_Paginator::RECORD_CLASS => $recordClass,
            Oray_Db_Paginator::PAGE_SIZE    => $pageSize,
            Oray_Db_Paginator::TABLE        => $table,
            Oray_Db_Paginator::PRIMARY      => $primary,
            Oray_Db_Paginator::COLUMNS      => $columns,
            Oray_Db_Paginator::WHERE        => $where,
            Oray_Db_Paginator::ORDER        => $order
        ));

        // 返回查询结果
        return $paginator->query($page);
    }

    /**
     * 获取符合条件的图度数量
     *
     * @param $condition
     */
    public function getTuduCount(array $condition)
    {
        $table = 'td_tudu t ';

        if (isset($condition['orgid'])) {
            $where[] = 't.org_id = ' . $this->_db->quote($condition['orgid']);
        }

        if (isset($condition['type'])) {
            $where[] = 't.type = ' . $this->_db->quote($condition['type']);
        }

        if (isset($condition['boardid'])) {
            $where[] = 't.board_id = ' . $this->_db->quote($condition['boardid']);
        }

        if (isset($condition['uniqueid'])) {
            $table  .= 'INNER JOIN td_tudu_user tu ON tu.tudu_id = t.tudu_id ';
            $where[] = 'tu.unique_id = ' . $this->_db->quote($condition['uniqueid']);

            if (isset($condition['labelid'])) {
                $table  .= 'LEFT JOIN td_tudu_label tl ON tl.tudu_id = t.tudu_id AND tl.unique_id = tu.unique_id ';
                $where[] = 'tl.label_id = ' . $this->_db->quote($condition['labelid']);
            }
        }

        // 草稿
        if (isset($condition['isdraft'])) {
            $where[] = 't.is_draft = ' . ($condition['isdraft'] ? 1 : 0);
        }

        // 查找已读状态
        if (isset($condition['isread'])) {
            $where[] = 'tu.is_read = ' . ($condition['isread'] ? 1 : 0);
        }

        // 关键字
        if (!empty($condition['keyword'])) {
            $keyword = $this->_db->quote('%' . $condition['keyword'] . '%');
            $where[] = 't.subject LIKE ' . $keyword;
        }

        // 发送人
        if (!empty($condition['from'])) {
            $from = $this->_db->quote('%' . $condition['from'] . '%');
            $where[] = 't.from LIKE ' . $from;
        }

        // 接收人
        if (!empty($condition['to'])) {
            $to = $this->_db->quote('%' . $condition['to'] . '%');
            $where[] = 't.to LIKE ' . $to;
        }

        // 状态
        if (isset($condition['status'])) {
            if (is_array($condition['status'])) {
                foreach ($condition['status'] as $item) {
                    $status[] = $this->_db->quote($item);
                }
                $where[] = 't.status IN (' . implode(',', $status) . ')';
            } else if (is_int($condition['status'])) {
                $where[] = 't.status = ' . $condition['status'];
            }
        }

        // 版块
        if (!empty($condition['boardid'])) {
            $where[] = 't.board_id = ' . $this->_db->quote($condition['boardid']);
        }

        // 主题分类
        if (isset($condition['classid'])) {
            $where[] = 't.class_id = ' . $this->_db->quote($condition['classid']);
        }

        // 已完成
        if (isset($condition['isdone'])) {
            $where[] = 't.is_done = ' . ($condition['isdone'] ? 1 : 0);
        }

        $array = array(
            'createtime' => 't.create_time',
            'endtime'    => 't.end_time',
            'starttime'  => 't.start_time'
        );

        // createtime, endtime, starttime
        foreach ($array as $key => $col) {
            if (!isset($condition[$key])) {
                continue ;
            }

            if (is_array($condition[$key])) {
                $arr = array();
                if (isset($condition[$key]['start'])) {
                    $arr[] = $col . ' >= ' . (int) $condition[$key]['start'];
                }

                if (isset($condition[$key]['end'])) {
                    $arr[] = $col . ' <= ' . (int) $condition[$key]['end'];
                }

                if ($arr) {
                    $where[] = '(' . implode(' AND ', $arr) . ')';
                }
            } elseif (is_int($condition[$key])) {
                $where[] = $col . ' >= ' . $condition[$key];
            }
        }

        // 过期
        if (isset($condition['expiredate']) && is_int($condition['expiredate'])) {
            $where[] = '(tu.is_read = 0 OR t.start_time IS NULL OR t.start_time <= ' . $condition['expiredate'] . ')';
        }

        // WHERE
        $where = implode(' AND ', $where);
        if ($where) {
            $where = 'WHERE ' . $where;
        }

        $sql = "SELECT COUNT(0) FROM {$table} {$where}";

        $count = (int) $this->_db->fetchOne($sql);

        return $count;
    }

    /**
     * 统计符合条件的图度数量 -- 此方法将丢弃，请使用 getTuduCount 代替
     *
     * @param array $condition
     * @depared
     */
    public function countTudu(array $condition)
    {
        $table    = 'td_tudu t '
                  . 'INNER JOIN td_tudu_user tu ON tu.tudu_id = t.tudu_id '
                  . 'LEFT JOIN td_tudu_label tl ON tl.tudu_id = t.tudu_id AND tl.unique_id = tu.unique_id';

        // $condition...
        if (isset($condition['uniqueid'])) {
            $where[] = 'tu.unique_id = ' . $this->_db->quote($condition['uniqueid']);
        }

        if (isset($condition['label'])) {
            $where[] = 'tl.label_id = ' . $this->_db->quote($condition['label']);
        }

        // 状态
        if (isset($condition['isdraft']) && is_int($condition['isdraft'])) {
            $where[] = 't.is_draft = ' . (int) $condition['isdraft'];
        }

        // 查找已读状态
        if (isset($condition['isread'])) {
            $where[] = 'tu.is_read = ' . ($condition['isread'] ? 1 : 0);
        }

        // 关键字
        if (!empty($condition['keyword'])) {
            $keyword = $this->_db->quote('%' . $condition['keyword'] . '%');
            $where[] = 't.subject LIKE ' . $keyword;
        }

        // 发送人
        if (!empty($condition['from'])) {
            $from = $this->_db->quote('%' . $condition['from'] . '%');
            $where[] = 't.from LIKE ' . $from;
        }

        // 接收人
        if (!empty($condition['to'])) {
            $to = $this->_db->quote('%' . $condition['to'] . '%');
            $where[] = 't.to LIKE ' . $to;
        }

        // 状态
        if (isset($condition['status']) && is_int($condition['status'])) {
            $where[] = 't.status = ' . $condition['status'];
        }

        // 版块
        if (!empty($condition['boardid'])) {
            $where[] = 't.board_id = ' . $this->_db->quote($condition['boardid']);
        }

        // 主题分类
        if (isset($condition['classid'])) {
            $where[] = 't.class_id = ' . $this->_db->quote($condition['classid']);
        }

        // 类型
        if (!empty($condition['type'])) {
            $where[] = 't.type = ' . $this->_db->quote($condition['type']);
        }

        // 已完成
        if (isset($condition['isdone'])) {
            $where[] = 't.is_done = ' . ($condition['isdone'] ? 1 : 0);
        }

        $array = array(
            'createtime' => 't.create_time',
            'endtime'    => 't.end_time',
            'starttime'  => 't.start_time'
        );

        // createtime, endtime, starttime
        foreach ($array as $key => $col) {
            if (!isset($condition[$key])) {
                continue ;
            }

            if (is_array($condition[$key])) {
                $arr = array();
                if (isset($condition[$key]['start'])) {
                    $arr[] = $col . ' >= ' . (int) $condition[$key]['start'];
                }

                if (isset($condition[$key]['end'])) {
                    $arr[] = $col . ' <= ' . (int) $condition[$key]['end'];
                }

                if ($arr) {
                    $where[] = '(' . implode(' AND ', $arr) . ')';
                }
            } elseif (is_int($condition[$key])) {
                $where[] = $col . ' >= ' . $condition[$key];
            }
        }

        // 过期
        if (isset($condition['expiredate']) && is_int($condition['expiredate'])) {
            $where[] = '(tu.is_read = 0 OR t.start_time IS NULL OR t.start_time <= ' . $condition['expiredate'] . ')';
        }

        // WHERE
        $where = implode(' AND ', $where);
        if ($where) {
            $where = 'WHERE ' . $where;
        }

        $sql = "SELECT COUNT(0) FROM {$table} {$where}";

        $count = (int) $this->_db->fetchOne($sql);

        return $count;
    }

    /**
     * Create tudu
     *
     * @param $params
     * @return string|false
     */
    public function createTudu(array $params)
    {
        if (empty($params['orgid'])
            || empty($params['boardid'])
            || empty($params['tuduid'])
            || empty($params['type'])
            || empty($params['from'])
            || !array_key_exists('subject', $params)) {
            return false;
        }

        $address = self::formatAddress($params['from'], true);

        $createTime = empty($params['createtime']) ? time() : (int) $params['createtime'];

        $table = "td_tudu";
        $bind = array(
            'org_id'         => $params['orgid'],
            'board_id'       => $params['boardid'],
            'tudu_id'        => $params['tuduid'],
            'type'           => $params['type'],
            'subject'        => $params['subject'],
            'from'           => $params['from'],
            'priority'       => empty($params['priority']) ? 0 : (int) $params['priority'],
            'privacy'        => empty($params['privacy']) ? 0 : (int) $params['privacy'],
            'is_draft'       => 1,
            'last_poster'    => $address ? $address[0] : '',
            'last_post_time' => $createTime,
            'create_time'    => $createTime
            );

        if (isset($params['to'])) {
            $bind['to'] = $params['to'];
        }
        if (isset($params['cc'])) {
            $bind['cc'] = $params['cc'];
        }
        if (isset($params['bcc'])) {
            $bind['bcc'] = $params['bcc'];
        }
        if (isset($params['starttime'])) {
            $bind['start_time'] = $params['starttime'];
        }
        if (isset($params['endtime'])) {
            $bind['end_time'] = $params['endtime'];
        }
        if (isset($params['totaltime'])) {
            $bind['total_time'] = (int) $params['totaltime'];
        }
        if (isset($params['elapsedtime'])) {
            $bind['elapsed_time'] = (int) $params['elapsedtime'];
        }
        if (isset($params['accepttime'])) {
            $bind['accept_time'] = (int) $params['accepttime'];
        }
        if (isset($params['percent'])) {
            $bind['percent'] = (int) $params['percent'];
        }
        if (isset($params['status'])) {
            $bind['status'] = (int) $params['status'];
        }
        if (isset($params['viewnum'])) {
            $bind['view_num'] = (int) $params['viewnum'];
        }
        if (isset($params['isdone'])) {
            $bind['is_done'] = $params['isdone'] ? 1 : 0;
        }
        if (isset($params['istop'])) {
            $bind['is_top'] = $params['istop'] ? 1 : 0;
        }
        if (isset($params['notifyall'])) {
            $bind['notify_all'] = $params['notifyall'] ? 1 : 0;
        }
        if (!empty($params['prevtuduid'])) {
            $bind['prev_tudu_id'] = $params['prevtuduid'];
        }

        if (!empty($params['stepid'])) {
            $bind['step_id'] = $params['stepid'];
        }
        if (!empty($params['appid'])) {
            $bind['app_id'] = $params['appid'];
        }
        if (isset($params['special']) && is_int($params['special'])) {
            $bind['special'] = $params['special'];
        }
        if (isset($params['cycleid'])) {
            $bind['cycle_id'] = $params['cycleid'];
        }
        if (isset($params['flowid'])) {
            $bind['flow_id'] = $params['flowid'];
  …