/** * reset attributes to initial values * @return void */ function reset() { $this->_log->trace("resetting Result"); $this->error_message_str = ""; $this->error_log_str = ""; $this->error_str = ""; $this->error_element = ""; $this->result_str = ""; }
/** * pass attributes to User class * @return array $list_state_array array containing attribute values of this object */ function pass() { $list_state_array = array(); $this->_log->trace("passing ListState (title=" . $this->list_title . ", order=" . $this->order_by_field . ", asc=" . $this->order_ascending . ", page=" . $this->current_page . ")"); $list_state_array['order_by_field'] = $this->order_by_field; $list_state_array['order_ascending'] = $this->order_ascending; $list_state_array['archived'] = $this->archived; $list_state_array['filter_str'] = $this->filter_str; $list_state_array['filter_str_sql'] = $this->filter_str_sql; $list_state_array['total_records'] = $this->total_records; $list_state_array['total_pages'] = $this->total_pages; $list_state_array['current_page'] = $this->current_page; $this->_log->trace("passed ListState"); return $list_state_array; }
/** * open database connection, select database and return link identifier or FALSE * @return resource|bool link identifier or FALSE in case of any error */ function connect() { $this->_log->trace("opening db connection (host=" . $this->host . ", user="******")"); $db_link = @mysql_connect($this->host, $this->user, $this->passwd); if (!$db_link) { $this->error_str = "unable to connect to database (host=" . $this->host . ", user="******")"; $this->_log->error($this->error_str); return FALSE; } $succes = mysql_select_db($this->database, $db_link); if (!$succes) { $this->error_str = "unable to select database (db=" . $this->database . ")"; $this->_log->error($this->error_str); return FALSE; } return $db_link; }
/** * remove database table of current DatabaseTable object * @return bool indicates if database table has been removed */ function drop() { $this->_log->trace("drop DatabaseTable (table_name=" . $this->table_name . ")"); # check if database connection is working if ($this->_check_database_connection() == FALSE) { return FALSE; } # check if database table exists if (!$this->_database->table_exists($this->table_name)) { $this->_handle_error("DatabaseTable does not exist in database", "ERROR_DATABASE_EXISTENCE"); return FALSE; } $query = "DROP TABLE " . $this->table_name; $result = $this->_database->query($query); if ($result == FALSE) { $this->_handle_error("could not drop DatabaseTable", "ERROR_DATABASE_PROBLEM"); return FALSE; } $this->_log->trace("dropped DatabaseTable (table_name=" . $this->table_name . ")"); return TRUE; }
/** * get html value of specified type of field * @param $field_type string type of field * @param $field_options string options for given field * @param $db_field_name string db field name * @param $record array array of record name and values * @return string returned html */ function get_field_value($field_type, $field_options, $db_field_name, $record) { $field_value = $record[$db_field_name]; $this->_log->trace("get field value (field_type={$field_type}, field_options={$field_options}, db_field_name={$db_field_name}, field_value={$field_value})"); if ($field_type == FIELD_TYPE_DEFINITION_BOOL) { if ($field_value == 0) { $html_str = translate("LABEL_NO"); } else { $html_str = translate("LABEL_YES"); } } else { if (stristr($field_type, "DATE")) { $html_str = str_replace('-', '‑', get_date_str(DATE_FORMAT_FANCY, $field_value, $this->_user->get_date_format())); } else { if ($field_type == FIELD_TYPE_DEFINITION_AUTO_CREATED) { if ($field_options == NAME_DATE_OPTION_NAME) { $html_str = str_replace('-', '‑', $record[DB_CREATOR_FIELD_NAME]); } else { if ($field_options == NAME_DATE_OPTION_DATE) { $html_str = str_replace('-', '‑', get_date_str(DATE_FORMAT_FANCY, $record[DB_TS_CREATED_FIELD_NAME], $this->_user->get_date_format())); } else { if ($field_options == NAME_DATE_OPTION_DATE_NAME) { $html_str = str_replace('-', '‑', get_date_str(DATE_FORMAT_NORMAL, $record[DB_TS_CREATED_FIELD_NAME], $this->_user->get_date_format())); $html_str .= " (" . $record[DB_CREATOR_FIELD_NAME] . ")"; } } } } else { if ($field_type == FIELD_TYPE_DEFINITION_AUTO_MODIFIED) { if ($field_options == NAME_DATE_OPTION_NAME) { $html_str = str_replace('-', '‑', $record[DB_MODIFIER_FIELD_NAME]); } else { if ($field_options == NAME_DATE_OPTION_DATE) { $html_str = str_replace('-', '‑', get_date_str(DATE_FORMAT_FANCY, $record[DB_TS_MODIFIED_FIELD_NAME], $this->_user->get_date_format())); } else { if ($field_options == NAME_DATE_OPTION_DATE_NAME) { $html_str = str_replace('-', '‑', get_date_str(DATE_FORMAT_NORMAL, $record[DB_TS_MODIFIED_FIELD_NAME], $this->_user->get_date_format())); $html_str .= " (" . $record[DB_MODIFIER_FIELD_NAME] . ")"; } } } } else { if ($field_type == FIELD_TYPE_DEFINITION_NOTES_FIELD) { if (count($field_value) > 0) { $html_str = "\n"; foreach ($field_value as $note_array) { $html_str .= " <p><span class=\"note_creator\">"; $html_str .= str_replace('-', '‑', get_date_str(DATE_FORMAT_NORMAL, $note_array[DB_TS_CREATED_FIELD_NAME], $this->_user->get_date_format())); $html_str .= " (" . $note_array[DB_CREATOR_FIELD_NAME] . ")</span> "; $html_str .= transform_str($note_array["_note"]) . "</p>"; } } else { $html_str = "-"; } } else { if ($field_type == FIELD_TYPE_DEFINITION_TEXT_FIELD) { $html_str = transform_str($field_value); } else { if ($field_type == FIELD_TYPE_DEFINITION_PASSWORD) { $html_str = "********"; } else { if ($field_type == FIELD_TYPE_DEFINITION_ATTACHMENTS) { if ($field_value == 0) { $html_str = " "; } else { $html_str = "<span class=\"icon icon_attachment\"> </span>"; } } else { if ($field_type == FIELD_TYPE_DEFINITION_SELECTION) { if ($this->configuration[HTML_TABLE_PAGE_TYPE] != PAGE_TYPE_LIST) { $html_str = translate($field_value); } else { $html_str = $field_value; } } else { $html_str = $field_value; } } } } } } } } } $this->_log->trace("got field value"); return $html_str; }