コード例 #1
0
 public function read()
 {
     global $ilDB;
     $this->news = array();
     $types = array();
     $data = array();
     $query = 'SELECT * FROM payment_news WHERE 1 = 1 ';
     if ($this->isPublicSection()) {
         $query .= "AND visibility = %s ";
         $types[] = 'text';
         $data[] = 'public';
     }
     if ($this->getArchiveDate() !== null && $this->getArchiveDate() > 0) {
         switch ($this->getMode()) {
             case self::TYPE_NEWS:
                 $query .= "AND creation_date >= %s ";
                 $types[] = 'timestamp';
                 $data[] = date('Y-m-d H:i:s', $this->getArchiveDate());
                 break;
             case self::TYPE_ARCHIVE:
                 $query .= "AND creation_date < %s ";
                 $types[] = 'timestamp';
                 $data[] = date('Y-m-d H:i:s', $this->getArchiveDate());
                 break;
         }
     }
     $query .= 'ORDER BY update_date DESC ';
     $result = $ilDB->queryF($query, $types, $data);
     while ($record = $ilDB->fetchAssoc($result)) {
         $oNewsItem = new ilShopNewsItem();
         $oNewsItem->setId($record['news_id']);
         $oNewsItem->setCreationDate($record['creation_date']);
         $oNewsItem->setUpdateDate($record['update_date']);
         $oNewsItem->setTitle($record['news_title']);
         $oNewsItem->setContent($record['news_content']);
         $oNewsItem->setVisibility($record['visibility']);
         $oNewsItem->setUserId($record['user_id']);
         $this->news[] = $oNewsItem;
     }
     return $this;
 }
コード例 #2
0
 public function confirmDelete($view)
 {
     global $ilUser, $rbacreview;
     if (!$rbacreview->isAssigned($ilUser->getId(), SYSTEM_ROLE_ID)) {
         $this->ilErr->raiseError($this->lng->txt('permission_denied'), $this->ilErr->MESSAGE);
     }
     if (!isset($_GET['news_id'])) {
         ilUtil::sendInfo($this->lng->txt('payment_news_missing_id'));
         switch ($view) {
             case 'archive':
                 return $this->showArchive();
                 break;
             case 'news':
             default:
                 return $this->showNews();
                 break;
         }
     }
     include_once 'Services/Utilities/classes/class.ilConfirmationGUI.php';
     $c_gui = new ilConfirmationGUI();
     $c_gui->setHeaderText($this->lng->txt('payment_news_delete_sure'));
     $c_gui->addHiddenItem('news_id', (int) $_GET['news_id']);
     $oNewsItem = new ilShopNewsItem($_GET['news_id']);
     $title = $oNewsItem->getTitle();
     $c_gui->addItem($news_title, $_GET['news_id'], $title);
     switch ($view) {
         case 'archive':
             $c_gui->setFormAction($this->ctrl->getFormAction($this, 'performDeleteArchiveNews'));
             $c_gui->setConfirm($this->lng->txt('confirm'), 'performDeleteArchiveNews');
             $c_gui->setCancel($this->lng->txt('cancel'), 'showArchive');
             $this->showArchive($c_gui->getHTML());
             break;
         case 'news':
         default:
             $c_gui->setFormAction($this->ctrl->getFormAction($this, 'performDeleteNews'));
             $c_gui->setConfirm($this->lng->txt('confirm'), 'performDeleteNews');
             $c_gui->setCancel($this->lng->txt('cancel'), 'showNews');
             $this->showNews($c_gui->getHTML());
             break;
     }
     return true;
 }