false, 'show_title' => false, 'show_subpanels' => false, 'show_search' => true, 'show_footer' => false, 'show_javascript' => false, 'view_print' => false,); function MeetingsViewListbytype() { parent::ViewList(); } function listViewProcess(){ if (!$eapmBean = EAPM::getLoginInfo('LotusLive', true) ) { $smarty = new Sugar_Smarty(); echo $smarty->fetch('include/externalAPI/LotusLive/LotusLiveSignup.'.$GLOBALS['current_language'].'.tpl'); return; } $apiName = 'LotusLive'; $api = ExternalAPIFactory::loadAPI($apiName,true); $api->loadEAPM($eapmBean); $quickCheck = $api->quickCheckLogin(); if ( ! $quickCheck['success'] ) { $errorMessage = string_format(translate('LBL_ERR_FAILED_QUICKCHECK','EAPM'), array('LotusLive')); $errorMessage .= ''; echo $errorMessage; return; } $this->processSearchForm(); $this->params['orderBy'] = 'meetings.date_start'; $this->params['overrideOrder'] = true; $this->lv->searchColumns = $this->searchForm->searchColumns; $this->lv->show_action_dropdown = false; $this->lv->multiSelect = false; unset($this->searchForm->searchdefs['layout']['advanced_search']); if(!$this->headers) { return; } if(empty($_REQUEST['search_form_only']) || $_REQUEST['search_form_only'] == false){ $this->lv->ss->assign("SEARCH",false); if ( !isset($_REQUEST['name_basic']) ) { $_REQUEST['name_basic'] = ''; } $this->lv->ss->assign('DCSEARCH',$_REQUEST['name_basic']); $this->lv->setup($this->seed, 'include/ListView/ListViewDCMenu.tpl', $this->where, $this->params); $savedSearchName = empty($_REQUEST['saved_search_select_name']) ? '' : (' - ' . $_REQUEST['saved_search_select_name']); echo $this->lv->display(); } } function listViewPrepare() { $oldRequest = $_REQUEST; parent::listViewPrepare(); $_REQUEST = $oldRequest; } function processSearchForm(){ // $type = 'LotusLiveDirect'; $type = 'LotusLive'; $where = " meetings.type = '$type' AND meetings.status != 'Held' AND meetings.status != 'Not Held' AND meetings.date_start > UTC_TIMESTAMP() - 7200 AND ( meetings.assigned_user_id = '".$GLOBALS['db']->quote($GLOBALS['current_user']->id)."' OR exists ( SELECT id FROM meetings_users WHERE meeting_id = meetings.id AND user_id = '".$GLOBALS['db']->quote($GLOBALS['current_user']->id)."' AND deleted = 0 ) ) "; if ( isset($_REQUEST['name_basic']) ) { $name_search = trim($_REQUEST['name_basic']); if ( ! empty($name_search) ) { $where .= " AND meetings.name LIKE '".$GLOBALS['db']->quote($name_search)."%' "; } } $this->where = $where; } }