public function load_db_table_data($blank_data = FALSE)
{
$return_data = parent::load_db_table_data($blank_data);
$url_action = url::set_url_rewrite_var(url::get_url_level_count(), "url_action", FALSE);
$url_action_on_encoded_field = url::set_url_rewrite_var(url::get_url_level_count(), "url_action_on_encoded_field", FALSE);
$url_action_on_field = $this->decrypt_field_name($url_action_on_encoded_field);
if ($url_action == "unlink-uploaded-file") {
\k1lib\forms\file_uploads::unlink_uploaded_file($this->db_table_data[1][$url_action_on_field]);
$this->db_table_data[1][$url_action_on_field] = NULL;
$this->db_table->update_data($this->db_table_data[1], $this->db_table_data_keys[1]);
\k1lib\html\html_header_go(\k1lib\urlrewrite\get_back_url());
}
return $return_data;
}
public function finish_board($do_redirect = TRUE, $custom_redirect = FALSE)
{
if ($this->sql_action_result !== NULL) {
if ($custom_redirect === FALSE) {
if (isset($_GET['back-url'])) {
$get_params = [];
$url_to_go = \k1lib\urlrewrite\get_back_url();
} else {
$get_params = ["auth-code" => "--authcode--"];
$url_to_go = "{$this->controller_object->get_controller_root_dir()}{$this->controller_object->get_board_read_url_name()}/--rowkeys--/";
}
$url_to_go = url::do_url($url_to_go, $get_params);
} else {
$url_to_go = url::do_url($custom_redirect);
}
$this->create_object->post_insert_redirect($url_to_go, $do_redirect);
}
}
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;
}
}