| | |
| | | //$querystring = str_replace("{RECORDID}",$record[$table_idx],$querystring); |
| | | $app->uses('tform'); |
| | | $querystring = str_replace("{AUTHSQL}",$app->tform->getAuthSQL('r'),$querystring); |
| | | $querystring = str_replace("{AUTHSQL-A}",$app->tform->getAuthSQL('r','a'),$querystring); |
| | | $querystring = str_replace("{AUTHSQL-B}",$app->tform->getAuthSQL('r','b'),$querystring); |
| | | |
| | | //* Getting the records |
| | | $tmp_records = $app->db->queryAllRecords($querystring); |
| | |
| | | //* Get config variable |
| | | $list_name = $this->listDef['name']; |
| | | $search_prefix = $this->listDef['search_prefix']; |
| | | |
| | | if(isset($_REQUEST['Filter']) && !isset($_SESSION['search'][$list_name])) { |
| | | //* Jump back to page 1 of the list when a new search gets started. |
| | | $_SESSION['search'][$list_name]['page'] = 0; |
| | | } |
| | | |
| | | //* store retrieval query |
| | | foreach($this->listDef['item'] as $i) { |
| | | $field = $i['field']; |
| | | |
| | | //*TODO: comment = hat sich die suche ge�ndert |
| | | //* The search string has been changed |
| | | if(isset($_REQUEST[$search_prefix.$field]) && isset($_SESSION['search'][$list_name][$search_prefix.$field]) && $_REQUEST[$search_prefix.$field] != $_SESSION['search'][$list_name][$search_prefix.$field]){ |
| | | $this->searchChanged = 1; |
| | | |
| | |
| | | $record[$key] = htmlentities(stripslashes($record[$key]),ENT_QUOTES,$conf["html_content_encoding"]); |
| | | break; |
| | | |
| | | case 'DATE': |
| | | case 'DATETSTAMP': |
| | | if ($record[$key] > 0) { |
| | | // is value int? |
| | | if (ereg("^[0-9]+[.]?[0-9]*$", $record[$key], $p)) { |
| | | $record[$key] = date($this->lng('conf_format_dateshort'), $record[$key]); |
| | | } else { |
| | | $record[$key] = date($this->lng('conf_format_dateshort'), strtotime($record[$key])); |
| | | } |
| | | } |
| | | break; |
| | | case 'DATE': |
| | | if ($record[$key] > 0) { |
| | | // is value int? |
| | | if (ereg("^[0-9]+[.]?[0-9]*$", $record[$key], $p)) { |
| | |
| | | } |
| | | break; |
| | | |
| | | case 'DATE': |
| | | case 'DATETSTAMP': |
| | | if($record[$key] > 0) { |
| | | $record[$key] = date('Y-m-d',strtotime($record[$key])); |
| | | } |
| | | break; |
| | | |
| | | case 'DATE': |
| | | if($record[$key] != '' && $record[$key] != '0000-00-00') { |
| | | $record[$key] = $record[$key]; |
| | | } |
| | | break; |
| | | |
| | | case 'DATETIME': |
| | | if($record[$key] > 0) { |