| | |
| | | private $id; |
| | | public $idx_key; |
| | | public $DataRowColor; |
| | | public $SQLExtWhere = ''; |
| | | public $SQLOrderBy = ''; |
| | | public $SQLExtWhere = ''; |
| | | public $SQLOrderBy = ''; |
| | | public $SQLExtSelect = ''; |
| | | |
| | | public function onLoad() |
| | | { |
| | |
| | | $order_by_sql = "GROUP BY mailuser_id ".$order_by_sql; |
| | | } |
| | | } |
| | | |
| | | if($this->SQLExtSelect != '') { |
| | | if(substr($this->SQLExtSelect,0,1) != ',') $this->SQLExtSelect = ','.$this->SQLExtSelect; |
| | | $extselect .= $this->SQLExtSelect; |
| | | } |
| | | |
| | | return 'SELECT '.$app->listform->listDef['table'].'.*'.$extselect.' FROM '.$app->listform->listDef['table']."$join WHERE $sql_where $order_by_sql $limit_sql"; |
| | | } |
| | | |
| | |
| | | $limits = array('5'=>'5','15'=>'15','25'=>'25','50'=>'50','100'=>'100','999999999' => 'all'); |
| | | |
| | | //* create options and set selected, if default -> 15 is selected |
| | | |
| | | $options = ''; |
| | | foreach($limits as $key => $val){ |
| | | $options .= '<option value="'.$key.'" '.(isset($_SESSION['search']['limit']) && $_SESSION['search']['limit'] == $key ? 'selected="selected"':'' ).(!isset($_SESSION['search']['limit']) && $key == '15' ? 'selected="selected"':'').'>'.$val.'</option>'; |
| | | } |
| | | $app->tpl->setVar('search_limit','<select name="search_limit" style="width:50px">'.$options.'</select>'); |
| | | $app->tpl->setVar('search_limit','<select name="search_limit" class="search_limit">'.$options.'</select>'); |
| | | |
| | | $app->tpl->setVar('toolsarea_head_txt',$app->lng('toolsarea_head_txt')); |
| | | $app->tpl->setVar($app->listform->wordbook); |
| | | $app->tpl->setVar('form_action', $app->listform->listDef['file']); |
| | | |
| | | if(isset($_SESSION['show_info_msg'])) { |
| | | $app->tpl->setVar('show_info_msg', $_SESSION['show_info_msg']); |
| | | unset($_SESSION['show_info_msg']); |
| | | } |
| | | if(isset($_SESSION['show_error_msg'])) { |
| | | $app->tpl->setVar('show_error_msg', $_SESSION['show_error_msg']); |
| | | unset($_SESSION['show_error_msg']); |
| | | } |
| | | |
| | | //* Parse the templates and send output to the browser |
| | | $this->onShowEnd(); |
| | | } |
| | | |
| | | private function onShowEnd() |
| | | public function onShowEnd() |
| | | { |
| | | global $app; |
| | | $app->tpl_defaults(); |