public function do_html_object() { if ($this->db_table_data) { $this->div_container->set_attrib("class", "row k1lib-crudlexs-" . $this->css_class); $this->div_container->set_attrib("id", $this->object_id); $table_alias = \k1lib\db\security\db_table_aliases::encode($this->db_table->get_db_table_name()); $data_group = new \k1lib\html\div("k1lib-data-group"); $data_group->set_id("{$table_alias}-fields"); $data_group->append_to($this->div_container); $text_fields_div = new \k1lib\html\div("row"); $data_label = $this->get_labels_from_data(1); if (!empty($data_label)) { $this->remove_labels_from_data_filtered(); (new \k1lib\html\h3($data_label, "k1lib-data-group-title " . $this->css_class, "label-field-{$this->object_id}"))->append_to($data_group); } $labels = $this->db_table_data_filtered[0]; $values = $this->db_table_data_filtered[1]; $row = $data_group->append_div("row"); foreach ($values as $field => $value) { if (array_search($field, $this->fields_to_hide) !== FALSE) { continue; } if ($value !== 0 && $value !== NULL) { /** * ALL the TEXT field types are sendend to the last position to show nicely the HTML on it. */ $field_type = $this->db_table->get_field_config($field, 'type'); $field_alias = $this->db_table->get_field_config($field, 'alias'); if ($field_type == 'text') { $div_rows = $text_fields_div->append_div("large-12 column k1lib-data-item"); } else { $div_rows = $row->append_div($this->html_column_classes . " k1lib-data-item"); } if (!empty($field_alias)) { $div_rows->set_id("{$field_alias}-row"); } $label = $div_rows->append_div("k1lib-data-item-label")->set_value($labels[$field]); $value_div = $div_rows->append_div("k1lib-data-item-value")->set_value($value); if (!empty($field_alias)) { $div_rows->set_id("row-{$field_alias}"); $label->set_id("label-{$field_alias}"); if (method_exists($value, "set_id")) { $value->set_id("value-{$field_alias}"); } else { $value_div->set_id("value-{$field_alias}"); } } } } $text_fields_div->append_to($data_group); return $this->div_container; } else { return FALSE; } }
static function default_type(creating $crudlex_obj, $field) { $field_encrypted = $crudlex_obj->encrypt_field_name($field); if (!empty($crudlex_obj->db_table->get_field_config($field, 'refereced_table_name')) && self::$do_fk_search_tool && array_search($field, self::$fk_fields_to_skip) === FALSE) { $div_input_group = new \k1lib\html\div("input-group"); $input_tag = new \k1lib\html\input("text", $field_encrypted, NULL, "k1lib-input-insert input-group-field"); if (!empty($crudlex_obj->db_table->get_field_config($field, 'placeholder'))) { $input_tag->set_attrib("placeholder", $crudlex_obj->db_table->get_field_config($field, 'placeholder')); } else { $input_tag->set_attrib("placeholder", input_helper_strings::$input_fk_placeholder); } $input_tag->set_attrib("k1lib-data-group-" . $crudlex_obj->db_table->get_field_config($field, 'refereced_table_name'), TRUE); $input_tag->append_to($div_input_group); $div_input_group_button = new \k1lib\html\div("input-group-button"); $div_input_group_button->append_to($div_input_group); /** * FK TABLE EXTRACTOR */ $refereced_column_config = $crudlex_obj->db_table->get_field_config($field, 'refereced_column_config'); // while (!empty($refereced_column_config['refereced_column_config'])) { //// $refereced_column_config = $refereced_column_config['refereced_column_config']; // } $this_table = $crudlex_obj->db_table->get_db_table_name(); $this_table_alias = \k1lib\db\security\db_table_aliases::encode($this_table); $fk_table = $refereced_column_config['table']; $fk_table_alias = \k1lib\db\security\db_table_aliases::encode($fk_table); // $crudlex_obj->set_do_table_field_name_encrypt(); $static_values = $crudlex_obj->db_table->get_constant_fields(); $static_values_enconded = $crudlex_obj->encrypt_field_names($static_values); $search_button = new \k1lib\html\input("button", "search", "", "button fi-page-search fk-button"); $search_button->set_attrib("style", "font-family:foundation-icons"); $url_params = ["back-url" => $_SERVER['REQUEST_URI']]; $url_params = array_merge($static_values_enconded, $url_params); $url_to_search_fk_data = url::do_url(self::$url_to_search_fk_data . "{$fk_table_alias}/list/{$this_table_alias}/", $url_params); $search_button->set_attrib("onclick", "javascript:use_select_row_keys(this.form,'{$url_to_search_fk_data}')"); $search_button->append_to($div_input_group_button); $div_input_group->link_value_obj($input_tag); return $div_input_group; } elseif (strstr("date,date-past,date-future", $crudlex_obj->db_table->get_field_config($field, 'validation')) !== FALSE) { $div_input_group = new \k1lib\html\div("input-group"); $input_tag = new \k1lib\html\input("text", $field_encrypted, NULL, "k1lib-input-insert input-group-field datepicker"); $input_tag->set_attrib("placeholder", input_helper_strings::$input_date_placeholder); $input_tag->set_attrib("k1lib-data-datepickup", TRUE); $input_tag->append_to($div_input_group); $div_input_group_button = new \k1lib\html\div("input-group-button"); $div_input_group_button->append_to($div_input_group); $search_button = new \k1lib\html\a("#", "", "_self", "button fi-calendar"); $search_button->append_to($div_input_group_button); $div_input_group->link_value_obj($input_tag); return $div_input_group; } else { $input_tag = new \k1lib\html\input("text", $field_encrypted, NULL, "k1lib-input-insert"); $input_tag->set_attrib("placeholder", $crudlex_obj->db_table->get_field_config($field, 'placeholder')); return $input_tag; } }
/** * * @return \k1lib\html\div */ public function do_pagination() { $div_pagination = new \k1lib\html\div("k1lib-crudlexs-list-pagination clearfix", $this->get_object_id() . "-pagination"); $div_scroller = $div_pagination->append_div("float-left pagination-scroller"); $div_page_chooser = $div_pagination->append_div("float-left pagination-rows"); if ($this->db_table_data && self::$rows_per_page <= $this->total_rows) { $page_get_var_name = $this->get_object_id() . "-page"; $rows_get_var_name = $this->get_object_id() . "-rows"; $this_url = APP_URL . \k1lib\urlrewrite\url::get_this_url() . "#" . $this->get_object_id() . "-pagination"; if ($this->actual_page > 2) { $this->page_first = url::do_url($this_url, [$page_get_var_name => 1, $rows_get_var_name => self::$rows_per_page]); } else { $this->page_first = "#"; } if ($this->actual_page > 1) { $this->page_previous = url::do_url($this_url, [$page_get_var_name => $this->actual_page - 1, $rows_get_var_name => self::$rows_per_page]); } else { $this->page_previous = "#"; } if ($this->actual_page < $this->total_pages) { $this->page_next = url::do_url($this_url, [$page_get_var_name => $this->actual_page + 1, $rows_get_var_name => self::$rows_per_page]); } else { $this->page_next = "#"; } if ($this->actual_page <= $this->total_pages - 2) { $this->page_last = url::do_url($this_url, [$page_get_var_name => $this->total_pages, $rows_get_var_name => self::$rows_per_page]); } else { $this->page_last = "#"; } /** * HTML UL- LI construction */ $ul = new \k1lib\html\ul("pagination k1lib-crudlexs " . $this->get_object_id()); $ul->append_to($div_scroller); // First page LI $li = $ul->append_li(); // function append_a($href = NULL, $label = NULL, $target = NULL, $alt = NULL, $class = NULL, $id = NULL) { $a = $li->append_a($this->page_first, "‹‹", "_self", "k1lib-crudlexs-first-page"); if ($this->page_first == "#") { $a->set_attrib("class", "disabled"); } // Previuos page LI $li = $ul->append_li(""); $a = $li->append_a($this->page_previous, "‹", "_self", "k1lib-crudlexs-previous-page"); if ($this->page_previous == "#") { $a->set_attrib("class", "disabled"); } /** * Page GOTO selector */ $page_selector = new \k1lib\html\select("goto_page", "k1lib-crudlexs-page-goto", $this->get_object_id() . "-page-goto"); $page_selector->set_attrib("onChange", "use_select_option_to_url_go(this)"); for ($i = 1; $i <= $this->total_pages; $i++) { $option_url = url::do_url($this_url, [$page_get_var_name => $i, $rows_get_var_name => self::$rows_per_page]); $option = $page_selector->append_option($option_url, $i, $this->actual_page == $i ? TRUE : FALSE); } $ul->append_li()->append_child($page_selector); // Next page LI $li = $ul->append_li(""); $a = $li->append_a($this->page_next, "›", "_self", "k1lib-crudlexs-next-page"); if ($this->page_next == "#") { $a->set_attrib("class", "disabled"); } // Last page LI $li = $ul->append_li(""); $a = $li->append_a($this->page_last, "››", "_self", "k1lib-crudlexs-last-page"); if ($this->page_last == "#") { $a->set_attrib("class", "disabled"); } /** * PAGE ROWS selector */ $num_rows_selector = new \k1lib\html\select("goto_page", "k1lib-crudlexs-page-goto", $this->get_object_id() . "-page-rows-goto"); $num_rows_selector->set_attrib("onChange", "use_select_option_to_url_go(this)"); foreach (self::$rows_per_page_options as $num_rows) { if ($num_rows <= $this->total_rows) { $option_url = url::do_url($this_url, [$page_get_var_name => 1, $rows_get_var_name => $num_rows]); $option = $num_rows_selector->append_option($option_url, $num_rows, self::$rows_per_page == $num_rows ? TRUE : FALSE); } else { break; } } if ($this->total_rows <= self::$rows_limit_to_all) { $option_url = url::do_url($this_url, [$page_get_var_name => 1, $rows_get_var_name => $this->total_rows]); $option = $num_rows_selector->append_option($option_url, $this->total_rows, self::$rows_per_page == $this->total_rows ? TRUE : FALSE); } $label = new \k1lib\html\label("Show", $this->get_object_id() . "-page-rows-goto"); $label->set_attrib("style", "display:inline"); $label->append_to($div_page_chooser); $num_rows_selector->append_to($div_page_chooser); } return $div_pagination; }
/** * * @param \k1lib\crudlexs\class_db_table $db_table * @param array $field_links_array * @param string $title * @param string $board_root * @param string $board_create * @param string $board_read * @param boolean $show_create * @return \k1lib\html\div|boolean */ public function create_related_list(class_db_table $db_table, $field_links_array, $title, $board_root, $board_create, $board_read, $board_list, $use_back_url = FALSE, $clear_url = FALSE) { $table_alias = \k1lib\db\security\db_table_aliases::encode($db_table->get_db_table_name()); $detail_div = new \k1lib\html\div(); $this->related_list = $this->do_related_list($db_table, $field_links_array, $board_root, $board_read); if (!empty($this->related_list)) { $current_row_keys_text = $this->read_object->get_row_keys_text(); $current_row_keys_text_auth_code = md5(\k1lib\K1MAGIC::get_value() . $current_row_keys_text); $detail_div->set_class("k1lib-related-data-list {$table_alias}"); $related_title = $detail_div->append_h4($title, "{$table_alias}"); $detail_div->append_div("related-messaje"); if ($data_loaded) { $get_vars = ["auth-code" => $current_row_keys_text_auth_code, "back-url" => $_SERVER['REQUEST_URI']]; $all_data_url = url::do_url(APP_URL . $board_root . "/" . $board_list . "/{$current_row_keys_text}/", $get_vars, FALSE); $this->related_html_object_show_all_data = \k1lib\html\get_link_button($all_data_url, board_read_strings::$button_all_data, "tiny"); if ($this->related_show_all_data) { $related_title->set_value($this->related_html_object_show_all_data, TRUE); } } if ($use_back_url) { $get_vars = ["auth-code" => $current_row_keys_text_auth_code, "back-url" => $_SERVER['REQUEST_URI']]; $create_url = url::do_url(APP_URL . $board_root . "/" . $board_create . "/{$current_row_keys_text}/", $get_vars, TRUE); } else { $get_vars = ["auth-code" => $current_row_keys_text_auth_code]; $create_url = url::do_url(APP_URL . $board_root . "/" . $board_create . "/{$current_row_keys_text}/", $get_vars, TRUE, ['back-url'], FALSE); } $this->related_html_object_show_new = \k1lib\html\get_link_button($create_url, board_list_strings::$button_new, "tiny"); if ($this->related_show_new) { $related_title->set_value($this->related_html_object_show_new, TRUE); } $this->related_list->do_html_object()->append_to($detail_div); $this->related_html_table_object = $this->related_list->get_html_table(); if ($db_table->get_total_rows() > $this->related_rows_to_show) { $this->related_list->do_pagination()->append_to($detail_div); $this->related_list->do_row_stats()->append_to($detail_div); } listing::$rows_per_page = $actual_rows_per_page; } // TODO: NONSENSE line ! // $this->set_related_show_new(TRUE); return $detail_div; }