Пример #1
0
 /**
  * 期限を更新する
  *
  * @param   string  $circularId	回覧ID
  * @return  boolean (true:正常/false:異常)
  * @access	public
  */
 function extendPeriod()
 {
     $columns = array('circular_id' => $this->_request->getParameter('circular_id'), 'period' => $this->_request->getParameter('period'));
     if (!$this->_db->updateExecute('circular', $columns, 'circular_id', true)) {
         return false;
     }
     return true;
 }
Пример #2
0
 /**
  * ポータル(自分が作成者 または 回覧者の回覧を一覧表示する)画面用のデータを取得
  *
  * @access public
  */
 function getPortalCircular()
 {
     $moduleId = $this->_request->getParameter('module_id');
     $fromStatement = "FROM {circular} C " . "LEFT JOIN {circular_user} U " . "ON C.circular_id = U.circular_id " . "AND U.receive_user_id = ? " . "AND U.reply_flag = ? " . "INNER JOIN {pages} P " . "ON C.room_id = P.room_id " . "INNER JOIN {blocks} B " . "ON P.page_id = B.page_id " . "AND B.module_id = ? " . "WHERE (C.post_user_id = ? " . "OR U.receive_user_id = ?) " . "AND (C.period = '' " . "OR C.period >= ? ) ";
     $sql = "SELECT MIN(B.block_id) AS block_id " . $fromStatement . "GROUP BY C.room_id";
     $params = array($this->_user_id, CIRCULAR_LIST_TYPE_UNSEEN, $moduleId, $this->_user_id, $this->_user_id, timezone_date());
     $blockIdString = $this->_db->execute($sql, $params, null, null, false, array($this, '_makeImplodeString'));
     if ($blockIdString === false) {
         $this->_db->addError();
         return false;
     }
     if (empty($blockIdString)) {
         return array();
     }
     $sql = "SELECT C.circular_id, " . "C.circular_subject, " . "C.icon_name, " . "C.period, " . "C.insert_user_name, " . "C.update_time, " . "B.block_id " . $fromStatement . "AND B.block_id IN (" . $blockIdString . ") " . "ORDER BY C.update_time DESC ";
     $result = $this->_db->execute($sql, $params, CIRCULAR_PORTAL_LIST_COUNT, null, true, array($this, "_callbackGetPortalCircular"));
     if ($result === false) {
         $this->_db->addError();
         return false;
     }
     return $result;
 }