query("default_links", "SELECT * FROM default_links WHERE record_id = $column_id"); if ($column_default_link_res->num_rows > 0) { $column_default_link = $column_default_link_res->fetch_assoc(); $columns[] = $column_default_link['parent_table_column']; $as_columns[] = $column_default_link['custom_header']; $function[] = $column_default_link['function']; $display_method[] = $column_default_link['display_method']; $onclick[] = $column_default_link['onclick']; $onclick_file[] = $column_default_link['onclick_file']; $icon[] = $column_default_link['icon']; $send_column[] = $column_default_link['send_column']; $custom_text[] = $column_default_link['custom_text']; $prefix[] = $column_default_link['prefix_on_value']; $postfix[] = $column_default_link['postfix_on_value']; $number_formater[] = $column_default_link['number_format']; $number_format_decimal[] = $column_default_link['number_format_decimal']; $link_table[] = $column_default_link['child_table_name']; $linK_table_column_return[] = $column_default_link['pull_column_name']; } } //QUERY TO GET THE DATA $sql_select = []; $i = 0; foreach ($columns as $column) { $sql_select[] = $column . " AS " . str_replace([',', "'", ".", " ", "-", "/"], '', $as_columns[$i]); $i++; } $sql_select_string = count($sql_select) > 0 ? implode(",", $sql_select) : "*"; $table_data_res = $db->query($table_name, "SELECT " . $sql_select_string . " FROM " . $table_name . " WHERE " . $where_data . " " . $order_by . " " . $limit); if ($table_data_res->num_rows > 0) { while ($row = $table_data_res->fetch_assoc()) { echo ""; $column_index = 0; foreach ($row as $column => $value) { // if there is costom static text like EDIT, PDF if ($custom_text[$column_index] != null || $custom_text[$column_index] != '') { $text_to_show = $custom_text[$column_index]; } else { // calculate, reach other tables for data and get values if ($link_table[$column_index] != '') { if ($function[$column_index] == 'SUM') { $link_table_res = $db->query($link_table[$column_index], "SELECT SUM(" . $send_column[$column_index] . ") as `value` FROM " . $link_table[$column_index] . " WHERE " . $linK_table_column_return[$column_index] . " = '" . $value . "'"); if ($link_table_res->num_rows > 0) { $link_table_row = $link_table_res->fetch_assoc(); $text_to_show = $link_table_row['value']; } } else if ($function[$column_index] == 'COUNT') { $link_table_res = $db->query($link_table[$column_index], "SELECT COUNT(" . $linK_table_column_return[$column_index] . ") as `value` FROM " . $link_table[$column_index] . " WHERE " . $linK_table_column_return[$column_index] . " = '" . $value . "'"); if ($link_table_res->num_rows > 0) { $link_table_row = $link_table_res->fetch_assoc(); $text_to_show = $link_table_row['value']; } } else if ($function[$column_index] == 'AVG') { $link_table_res = $db->query($link_table[$column_index], "SELECT AVG(" . $send_column[$column_index] . ") as `value` FROM " . $link_table[$column_index] . " WHERE " . $linK_table_column_return[$column_index] . " = '" . $value . "' ORDER BY record_id DESC LIMIT 1"); if ($link_table_res->num_rows > 0) { $link_table_row = $link_table_res->fetch_assoc(); $text_to_show = $link_table_row['value']; } } else if ($function[$column_index] == 'MIN') { $link_table_res = $db->query($link_table[$column_index], "SELECT MIN(" . $send_column[$column_index] . ") as `value` FROM " . $link_table[$column_index] . " WHERE " . $linK_table_column_return[$column_index] . " = '" . $value . "' ORDER BY record_id DESC LIMIT 1"); if ($link_table_res->num_rows > 0) { $link_table_row = $link_table_res->fetch_assoc(); $text_to_show = $link_table_row['value']; } } else if ($function[$column_index] == 'MAX') { $link_table_res = $db->query($link_table[$column_index], "SELECT MAX(" . $send_column[$column_index] . ") as `value` FROM " . $link_table[$column_index] . " WHERE " . $linK_table_column_return[$column_index] . " = '" . $value . "' ORDER BY record_id DESC LIMIT 1"); if ($link_table_res->num_rows > 0) { $link_table_row = $link_table_res->fetch_assoc(); $text_to_show = $link_table_row['value']; } } else { $link_table_res = $db->query($link_table[$column_index], "SELECT " . $linK_table_column_return[$column_index] . " FROM " . $link_table[$column_index] . " WHERE record_id = '" . $value . "' ORDER BY record_id DESC LIMIT 1"); if ($link_table_res->num_rows > 0) { $link_table_row = $link_table_res->fetch_assoc(); $text_to_show = $link_table_row[$linK_table_column_return[$column_index]]; } } } else { $text_to_show = $value; } } // check if its a number and give it a number format if ($number_formater[$column_index] == 1) { $text_to_show = number_format((Float) $text_to_show, $number_format_decimal[$column_index], '.', ','); } // add a defined prefix to the value if ($prefix[$column_index] != null || $prefix[$column_index] != '') { $text_to_show = $prefix[$column_index] . $text_to_show; } // add a defined postfix to the value if ($postfix[$column_index] != null || $postfix[$column_index] != '') { $text_to_show = $text_to_show . $postfix[$column_index]; } // check if there is a redirect set up if ($onclick[$column_index] == 'REDIRECT') { $onclick_function = "onclick=\"window.location.href = '" . $onclick_file[$column_index] . "?record_id=" . $row[str_replace([',', "'", ".", " ", "-", "/"], '', $as_columns[$column_index])] . "'\""; } else if ($onclick[$column_index] == 'POPUP') { $onclick_function = "onclick=\"open_iframe('" . $onclick_file[$column_index] . "?record_id=" . $row[str_replace([',', "'", ".", " ", "-", "/"], '', $as_columns[$column_index])] . "')\""; } else { $onclick_function = ""; } if ($display_method[$column_index] == 'BUTTON') { $text_to_show = ""; } else if ($display_method[$column_index] == 'ICON') { $text_to_show = $text_to_show . " "; } else if ($display_method[$column_index] == 'PROGRESS BAR') { $text_to_show = '
'; } echo "" . $text_to_show . ""; $column_index++; } echo ""; } } } else { $table_data_res = $db->query($table_name, "SELECT * FROM " . $table_name . " WHERE 1 ORDER BY record_id DESC " . $limit); if ($table_data_res->num_rows > 0) { while ($row = $table_data_res->fetch_assoc()) { echo ""; foreach ($row as $column => $value) { echo "" . $value . ""; } echo ""; } } } ?> query("user_table_views", "DELETE FROM user_table_views WHERE user_id = '" . $_SESSION['user_id'] . "' AND table_name = '" . $_POST['table_name'] . "'"); // insert the table order for the user under user table_data $column_ids = json_decode($_POST['columns'], true); foreach ($column_ids as $column_id) { $db->query("user_table_views", "INSERT INTO user_table_views (user_id, table_name, default_link_id) VALUES ('" . $_SESSION['user_id'] . "', '" . $_POST['table_name'] . "', '" . $column_id . "')"); } } class table { public $table_name; public $file_path = null; public $custom_organization; public $columns = []; public $searchable_columns = []; public $linked_tables = []; public $pull_from = []; public $functions = []; public $display_method = []; public $onclick = []; public $onclick_file = []; public $icon = []; public $send_column = []; public $custom_text = []; function __construct($table_name) { $this->table_name = $table_name; $db = new db(); ?>

file_path = $file_path; } function all_column_names_from_table_as_select($start_column, $start_id) { $db = new db(); $columns = ""; $columns .= ""; $default_links_res = $db->query("default_links", "SELECT * FROM default_links WHERE parent_table_name = '" . $this->table_name . "' AND custom_header != '$start_column'"); if ($default_links_res->num_rows > 0) { while ($default_link = $default_links_res->fetch_assoc()) { $columns .= ""; } } return $columns; } function __destruct() { $db = new db(); $loading = new loading(); $exclude_columns_array = ['record_id', 'password']; ?> query("user_table_views", "SELECT * FROM user_table_views WHERE user_id = '" . $_SESSION['user_id'] . "' AND table_name = '" . $this->table_name . "' ORDER BY record_id ASC"); if ($user_table_views_res->num_rows > 0) { $this->custom_organization = true; while ($user_table_views = $user_table_views_res->fetch_assoc()) { $this->columns[] = $user_table_views['default_link_id']; $default_links_res = $db->query("default_links", "SELECT * FROM default_links WHERE record_id = '" . $user_table_views['default_link_id'] . "'"); $default_link = $default_links_res->fetch_assoc(); if ($default_link['searchable'] == 1) { $this->searchable_columns[] = $default_link['parent_table_column']; } ?> query("default_links", "SELECT * FROM default_links WHERE parent_table_name = '" . $this->table_name . "'"); if ($default_links_res->num_rows > 0) { $this->custom_organization = true; while ($default_link = $default_links_res->fetch_assoc()) { $this->columns[] = $default_link['record_id']; if ($default_link['searchable'] == 1) { $this->searchable_columns[] = $default_link['parent_table_column']; } ?> custom_organization = false; ?> query($this->table_name, "SHOW COLUMNS FROM " . $this->table_name); if ($table_columns_res->num_rows > 0) { while ($table_column = $table_columns_res->fetch_assoc()) { $this->columns[] = $table_column['Field']; } } } } ?>
loading_dots(); ?>