| | |
| | | global $app, $conf; |
| | | |
| | | //* Add Global Limit from selectbox |
| | | if(!empty($_POST['search_limit']) AND intval($_POST['search_limit'])){ |
| | | $_SESSION['search']['limit'] = $_POST['search_limit']; |
| | | } |
| | | if(!empty($_POST['search_limit']) AND $app->functions->intval($_POST['search_limit'])){ |
| | | $_SESSION['search']['limit'] = $app->functions->intval($_POST['search_limit']); |
| | | } |
| | | |
| | | //* Get Config variables |
| | | $list_name = $this->listDef['name']; |
| | | $search_prefix = $this->listDef['search_prefix']; |
| | | $records_per_page = (empty($_SESSION['search']['limit']) ? $this->listDef['records_per_page'] : $_SESSION['search']['limit']) ; |
| | | $records_per_page = (empty($_SESSION['search']['limit']) ? $app->functions->intval($this->listDef['records_per_page']) : $app->functions->intval($_SESSION['search']['limit'])) ; |
| | | $table = $this->listDef['table']; |
| | | |
| | | //* set PAGE to zero, if in session not set |
| | |
| | | } |
| | | |
| | | //* set PAGE to worth request variable "PAGE" - ? setze page auf wert der request variablen "page" |
| | | if(isset($_REQUEST["page"])) $_SESSION["search"][$list_name]["page"] = intval($_REQUEST["page"]); |
| | | if(isset($_REQUEST["page"])) $_SESSION["search"][$list_name]["page"] = $app->functions->intval($_REQUEST["page"]); |
| | | |
| | | //* PAGE to 0 set, if look for themselves ? page auf 0 setzen, wenn suche sich ge�ndert hat. |
| | | if($this->searchChanged == 1) $_SESSION['search'][$list_name]['page'] = 0; |
| | | |
| | | $sql_von = intval($_SESSION['search'][$list_name]['page'] * $records_per_page); |
| | | $sql_von = $app->functions->intval($_SESSION['search'][$list_name]['page'] * $records_per_page); |
| | | $record_count = $app->db->queryOneRecord("SELECT count(*) AS anzahl FROM $table WHERE $sql_where"); |
| | | $pages = intval(($record_count['anzahl'] - 1) / $records_per_page); |
| | | $pages = $app->functions->intval(($record_count['anzahl'] - 1) / $records_per_page); |
| | | |
| | | |
| | | $vars['list_file'] = $_SESSION['s']['module']['name'].'/'.$this->listDef['file']; |
| | |
| | | public function getPagingHTML($vars) |
| | | { |
| | | global $app; |
| | | $content = '<a href="'."javascript:loadContent('".$vars['list_file'].'?page=0'.$vars['page_params']."');".'">' |
| | | .'<img src="themes/'.$_SESSION['s']['theme'].'/icons/x16/arrow_stop_180.png"></a> '; |
| | | |
| | | // we want to show at max 17 page numbers (8 left, current, 8 right) |
| | | $show_pages_count = 17; |
| | | |
| | | $show_pages = array(0); // first page |
| | | if($vars['pages'] > 0) $show_pages[] = $vars['pages']; // last page |
| | | for($p = $vars['page'] - 2; $p <= $vars['page'] + 2; $p++) { // surrounding pages |
| | | if($p > 0 && $p < $vars['pages']) $show_pages[] = $p; |
| | | } |
| | | |
| | | $l_start = $vars['page'] - 13; |
| | | $l_start -= ($l_start % 10) + 1; |
| | | $h_end = $vars['page'] + 23; |
| | | $h_end -= ($h_end % 10) + 1; |
| | | for($p = $l_start; $p <= $h_end; $p += 10) { // surrounding pages |
| | | if($p > 0 && $p < $vars['pages'] && !in_array($p, $show_pages, true) && count($show_pages) < $show_pages_count) $show_pages[] = $p; |
| | | } |
| | | |
| | | $l_start = $vars['page'] - 503; |
| | | $l_start -= ($l_start % 100) + 1; |
| | | $h_end = $vars['page'] + 603; |
| | | $h_end -= ($h_end % 100) + 1; |
| | | for($p = $l_start; $p <= $h_end; $p += 100) { // surrounding pages |
| | | if($p > 0 && $p < $vars['pages'] && !in_array($p, $show_pages, true) && count($show_pages) < $show_pages_count) $show_pages[] = $p; |
| | | } |
| | | |
| | | $l_start = $vars['page'] - 203; |
| | | $l_start -= ($l_start % 25) + 1; |
| | | $h_end = $vars['page'] + 228; |
| | | $h_end -= ($h_end % 25) + 1; |
| | | for($p = $l_start; $p <= $h_end; $p += 25) { // surrounding pages |
| | | if($p > 0 && $p < $vars['pages'] && abs($p - $vars['page']) > 30 && !in_array($p, $show_pages, true) && count($show_pages) < $show_pages_count) $show_pages[] = $p; |
| | | } |
| | | |
| | | sort($show_pages); |
| | | $show_pages = array_unique($show_pages); |
| | | |
| | | //* Show Back |
| | | if(isset($vars['show_page_back']) && $vars['show_page_back'] == 1){ |
| | | $content .= '<a href="'."javascript:loadContent('".$vars['list_file'].'?page='.$vars['last_page'].$vars['page_params']."');".'">' |
| | | .'<img src="themes/'.$_SESSION['s']['theme'].'/icons/x16/arrow_180.png"></a> '; |
| | | $content = '<a class="btn-page first-page" href="'."javascript:loadContent('".$vars['list_file'].'?page=0'.$vars['page_params']."');".'">' |
| | | .'<img src="themes/'.$_SESSION['s']['theme'].'/icons/x16/arrow_stop_180.png"></a> '; |
| | | $content .= '<a class="btn-page previous-page" href="'."javascript:loadContent('".$vars['list_file'].'?page='.$vars['last_page'].$vars['page_params']."');".'">' |
| | | .'<img src="themes/'.$_SESSION['s']['theme'].'/icons/x16/arrow_180.png"></a> '; |
| | | } |
| | | $content .= ' '.$this->lng('page_txt').' '.$vars['next_page'].' '.$this->lng('page_of_txt').' '.$vars['max_pages'].' '; |
| | | $content .= ' '.$this->lng('page_txt').' '; |
| | | $prev = -1; |
| | | foreach($show_pages as $p) { |
| | | if($prev != -1 && $p > $prev + 1) $content .= '<span class="page-spacer">...</span>'; |
| | | $content .= '<a class="link-page' . ($p == $vars['page'] ? ' current-page' : '') . '" href="'."javascript:loadContent('".$vars['list_file'].'?page='.$p.$vars['page_params']."');".'">'. ($p+1) .'</a>'; |
| | | $prev = $p; |
| | | } |
| | | //.$vars['next_page'].' '.$this->lng('page_of_txt').' '.$vars['max_pages'].' '; |
| | | //* Show Next |
| | | if(isset($vars['show_page_next']) && $vars['show_page_next'] == 1){ |
| | | $content .= '<a href="'."javascript:loadContent('".$vars['list_file'].'?page='.$vars['next_page'].$vars['page_params']."');".'">' |
| | | $content .= '<a class="btn-page next-page" href="'."javascript:loadContent('".$vars['list_file'].'?page='.$vars['next_page'].$vars['page_params']."');".'">' |
| | | .'<img src="themes/'.$_SESSION['s']['theme'].'/icons/x16/arrow.png"></a> '; |
| | | } |
| | | $content .= '<a href="'."javascript:loadContent('".$vars['list_file'].'?page='.$vars['pages'].$vars['page_params']."');".'">' |
| | | $content .= '<a class="btn-page last-page" href="'."javascript:loadContent('".$vars['list_file'].'?page='.$vars['pages'].$vars['page_params']."');".'">' |
| | | .'<img src="themes/'.$_SESSION['s']['theme'].'/icons/x16/arrow_stop.png"></a>'; |
| | | } |
| | | return $content; |
| | | } |
| | | |
| | |
| | | if(is_array($record) && count($record) > 0 && is_array($this->listDef['item'])) { |
| | | foreach($this->listDef['item'] as $field){ |
| | | $key = $field['field']; |
| | | //* Apply filter to record value. |
| | | if(isset($field['filters']) && is_array($field['filters'])) { |
| | | $app->uses('tform'); |
| | | $record[$key] = $app->tform->filterField($key, (isset($record[$key]))?$record[$key]:'', $field['filters'], 'SHOW'); |
| | | } |
| | | if(isset($record[$key])) { |
| | | switch ($field['datatype']){ |
| | | case 'VARCHAR': |
| | |
| | | break; |
| | | |
| | | case 'INTEGER': |
| | | $record[$key] = intval($record[$key]); |
| | | $record[$key] = $app->functions->intval($record[$key]); |
| | | break; |
| | | |
| | | case 'DOUBLE': |
| | |
| | | break; |
| | | |
| | | case 'INTEGER': |
| | | $record[$key] = intval($record[$key]); |
| | | $record[$key] = $app->functions->intval($record[$key]); |
| | | break; |
| | | |
| | | case 'DOUBLE': |