示例#1
0
 public function approval()
 {
     PHPWS_Core::initCoreClass('DBPager.php');
     PHPWS_Core::initModClass('calendar', 'Suggestion.php');
     $pager = new DBPager('calendar_suggestions', 'Calendar_Suggestion');
     $pager->setModule('calendar');
     $pager->setTemplate('admin/approval.tpl');
     $pager->setOrder('submitted', null, true);
     $pager->addRowTags('getTpl');
     $pager->addToggle('class="bgcolor2"');
     $page_tags['TITLE_LABEL'] = dgettext('calendar', 'Title / Time / Description');
     $page_tags['LOCATION_LABEL'] = dgettext('calendar', 'Location');
     $page_tags['ACTION_LABEL'] = dgettext('calendar', 'Action');
     $pager->setEmptyMessage(dgettext('calendar', 'No suggestions to approve.'));
     $pager->addPageTags($page_tags);
     $this->title = dgettext('calendar', 'Suggested events');
     $this->content = $pager->get();
 }
示例#2
0
 public static function getAdminPager()
 {
     $pager = new \DBPager('intern_admin', '\\Intern\\Admin');
     $pager->setModule('intern');
     $pager->setTemplate('admin_pager.tpl');
     $pager->setEmptyMessage('No admins found.');
     $pager->addRowTags('rowTags');
     $pager->joinResult('department_id', 'intern_department', 'id', 'name', 'department_name');
     //$pager->db->setTestMode();
     // Set a default order
     if (!isset($_REQUEST['orderby'])) {
         $pager->setOrder('department_name');
     }
     /***** Row Background Color Toggles ******/
     $pager->addToggle('tablerow-bg-color1');
     $pager->addToggle('tablerow-bg-color2');
     // Search
     $pager->setSearch('username');
     return $pager->get();
 }
示例#3
0
 /**
  * Special Interest Group DBPager for lottery
  *
  * @param unknown $group
  * @param unknown $term
  * @throws InvalidArgumentException
  */
 public static function specialInterestPager($group, $term)
 {
     PHPWS_Core::initCoreClass('DBPager.php');
     $pager = new DBPager('hms_new_application', 'LotteryApplication');
     $pager->setModule('hms');
     $pager->addRowTags('specialInterestTags');
     $pager->db->addJoin('left outer', 'hms_new_application', 'hms_lottery_application', 'id', 'id');
     // Gotta add column from hms_lottery_application so you can order by special_interest.
     $pager->db->addColumn('hms_lottery_application.*');
     $pager->addWhere('hms_new_application.term', $term);
     // If student is in special interest group already then only show them in the list when their group
     // is selected in the drop down. Or show them everywhere is they're not in a group.
     $pager->addWhere('hms_lottery_application.special_interest', $group, '=', 'OR', 'in_group');
     $pager->addWhere('hms_lottery_application.special_interest', 'NULL', '=', 'OR', 'in_group');
     if ($group == 'honors') {
         $pager->addWhere('hms_lottery_application.honors_pref', 1);
     } else {
         if ($group == 'watauga_global') {
             $pager->addWhere('hms_lottery_application.wg_pref', 1);
         } else {
             if ($group == 'teaching') {
                 $pager->addWhere('hms_lottery_application.tf_pref', 1);
             } else {
                 if (substr($group, 0, 8) == 'sorority') {
                     // starts with 'sorority'
                     $pager->addWhere('hms_lottery_application.sorority_pref', $group);
                 } else {
                     if ($group == 'special_needs') {
                         $pager->addWhere('hms_new_application.physical_disability', 1, '=', 'OR', 'blah');
                         $pager->addWhere('hms_new_application.psych_disability', 1, '=', 'OR', 'blah');
                         $pager->addWhere('hms_new_application.medical_need', 1, '=', 'OR', 'blah');
                         $pager->addWhere('hms_new_application.gender_need', 1, '=', 'OR', 'blah');
                     } else {
                         // bad group
                         throw new InvalidArgumentException('Invalid special interest group specified.');
                     }
                 }
             }
         }
     }
     $pager->setOrder('hms_lottery_application.special_interest', 'desc');
     $pager->setTemplate('admin/special_interest_pager.tpl');
     $pager->setEmptyMessage('No students found.');
     $pager->setReportRow('specialInterestCsvRow');
     return $pager->get();
 }
示例#4
0
    /**
     * Lists the contents of a folder for adminstrative changes.
     * @param object $folder
     * @param boolean $pick_image
     */
    public function folderContents($folder)
    {
        $links = array();
        javascript('jquery');
        $src = PHPWS_SOURCE_HTTP . 'mod/filecabinet/javascript/folder_options/contents.js';
        \Layout::addJSHeader("<script type='text/javascript' src='{$src}'></script>", 'folder-options');
        Layout::addStyle('filecabinet');
        PHPWS_Core::initCoreClass('DBPager.php');
        $dir_write = true;
        if (!is_writable($folder->getFullDirectory())) {
            $this->cabinet->message .= dgettext('filecabinet', 'Warning: this folder\'s directory is not writable.');
            $dir_write = false;
        }
        if ($folder->ftype == IMAGE_FOLDER) {
            javascript('lightbox');
            PHPWS_Core::initModClass('filecabinet', 'Image.php');
            $pager = new DBPager('images', 'PHPWS_Image');
            $pager->setTemplate('Forms/image_grid.tpl');
            $limits[9] = 9;
            $limits[16] = 16;
            $limits[25] = 25;
            $operation = 'iop';
            $command = 'upload_image_form';
            $label = _('Add image');
        } elseif ($folder->ftype == DOCUMENT_FOLDER) {
            PHPWS_Core::initModClass('filecabinet', 'Document.php');
            $pager = new DBPager('documents', 'PHPWS_Document');
            $pager->setTemplate('Forms/file_list.tpl');
            $limits[10] = 10;
            $limits[25] = 25;
            $limits[50] = 50;
            $operation = 'dop';
            $label = _('Add document');
            $command = 'upload_document_form';
            $pager->addSortHeader('downloaded', sprintf('<abbr title="%s">%s</abbr>', dgettext('filecabinet', 'Downloaded'), dgettext('filecabinet', 'DL')));
        } elseif ($folder->ftype = MULTIMEDIA_FOLDER) {
            PHPWS_Core::initModClass('filecabinet', 'Multimedia.php');
            $pager = new DBPager('multimedia', 'PHPWS_Multimedia');
            $pager->setTemplate('Forms/multimedia_grid.tpl');
            $limits[9] = 9;
            $limits[16] = 16;
            $limits[25] = 25;
            $label = _('Add media');
            $command = 'upload_multimedia_form';
            $operation = 'mop';
        }
        if (Current_User::allow('filecabinet', 'edit_folders', $folder->id, 'folder')) {
            if ($dir_write) {
                $links[] = $folder->uploadLink('button');
            }
            if ($folder->ftype == MULTIMEDIA_FOLDER) {
                //$links[] = $folder->rtmpLink();
                $salt = array('mop' => 'edit_rtmp', 'folder_id' => $folder->id);
                $authkey = \Current_User::getAuthKey(PHPWS_Text::saltArray($salt));
                $links[] = <<<EOF
<button class="btn btn-default show-modal" data-authkey="{$authkey}" data-command="edit_rtmp" data-operation="{$operation}" data-folder-id="{$folder->id}"><i class="fa fa-cloud"></i> Add RTMP video</button>
EOF;
            }
            //$links[] = $folder->editLink();
            $salt = array($operation => 'edit_folder', 'folder_id' => $folder->id);
            $authkey = \Current_User::getAuthKey(PHPWS_Text::saltArray($salt));
            $links[] = <<<EOF
<button class="btn btn-default show-modal" data-authkey="{$authkey}" data-command="edit_folder_modal" data-operation="aop" data-folder-id="{$folder->id}"><i class="fa fa-edit"></i> Edit</button>
EOF;
        }
        if ($this->cabinet->panel) {
            $pagetags['BACK'] = PHPWS_Text::moduleLink('<i class="fa fa-reply"></i> ' . dgettext('filecabinet', 'Back to folder list'), 'filecabinet', array('tab' => $this->cabinet->panel->getCurrentTab()), null, null, 'btn btn-default');
        }
        if (!empty($links)) {
            $pagetags['ADMIN_LINKS'] = implode(' ', $links);
        }
        $pagetags['MODAL'] = $this->getModal();
        $pagetags['ACTION_LABEL'] = dgettext('filecabinet', 'Action');
        $pager->setLimitList($limits);
        $pager->setSearch('file_name', 'title', 'description');
        $pager->addWhere('folder_id', $folder->id);
        $pager->setOrder('title', 'asc', true);
        $pager->setModule('filecabinet');
        $pager->addPageTags($pagetags);
        $pager->addRowTags('rowTags');
        $pager->addSortHeader('title', dgettext('filecabinet', 'Title'));
        $pager->addSortHeader('file_name', dgettext('filecabinet', 'File name'));
        $pager->addSortHeader('file_type', dgettext('filecabinet', 'File type'));
        $pager->addSortHeader('size', dgettext('filecabinet', 'Size'));
        $pager->setEmptyMessage(dgettext('filecabinet', 'Folder is empty.'));
        $this->cabinet->content = $pager->get();
    }