query($table_name, "SELECT $column FROM " . $table_name . " WHERE " . $where_data . " " . $order_by . " " . $limit . ""); while ($table_data = $table_res->fetch_assoc()) { $index_for_columns = 0; foreach ($columns as $column_name) { if ($custom_text[$index_for_columns] == null) { if ($linked_tables[$index_for_columns] != null) { if ($functions[$index_for_columns] == "COUNT") { // COUNT FUNCTION CALCULATION $value_res = $db->query($linked_tables[$index_for_columns], "SELECT " . $functions[$index_for_columns] . "(*) AS CNT FROM " . $linked_tables[$index_for_columns] . " WHERE " . $pull_from[$index_for_columns] . " = " . $table_data['record_id']); // echo "SELECT " . $functions[$index_for_columns] . "(*) AS CNT FROM " . $linked_tables[$index_for_columns] . " WHERE " . $pull_from[$index_for_columns] . " = " . $table_data['record_id'] . "
"; if ($value_res->num_rows > 0) { $value = $value_res->fetch_assoc(); $returned_value = $value['CNT']; } else { $returned_value = "LINK TO TABLE FAILED : SELECT " . $pull_from[$index_for_columns] . " FROM " . $linked_tables[$index_for_columns] . " WHERE record_id = " . $table_data[$column_name]; } } else if ($functions[$index_for_columns] == "SUM") { // COUNT FUNCTION CALCULATION $value_res = $db->query($linked_tables[$index_for_columns], "SELECT " . $functions[$index_for_columns] . "($pull_from[$index_for_columns]) AS SM FROM " . $linked_tables[$index_for_columns] . " WHERE " . $pull_from[$index_for_columns] . " = " . $table_data['record_id']); // echo "SELECT " . $functions[$index_for_columns] . "($pull_from[$index_for_columns]) AS SM FROM " . $linked_tables[$index_for_columns] . " WHERE " . $pull_from[$index_for_columns] . " = " . $table_data['record_id']; if ($value_res->num_rows > 0) { $value = $value_res->fetch_assoc(); $returned_value = $value['SM']; } else { $returned_value = "LINK TO TABLE FAILED : SELECT " . $pull_from[$index_for_columns] . " FROM " . $linked_tables[$index_for_columns] . " WHERE record_id = " . $table_data[$column_name]; } } else { // BASIC QUERY $value_res = $db->query($linked_tables[$index_for_columns], "SELECT " . $pull_from[$index_for_columns] . " FROM " . $linked_tables[$index_for_columns] . " WHERE record_id = " . $table_data[$column_name]); if ($value_res->num_rows > 0) { $value = $value_res->fetch_assoc(); $returned_value = $value[$pull_from[$index_for_columns]]; } else { $returned_value = "N/A"; } } } else { $returned_value = $table_data[$column_name]; } } else { $returned_value = $custom_text[$index_for_columns]; } // function to do on click if ($onclick[$index_for_columns] == "REDIRECT") { $onclick_html = "onclick='window.location.href = \"" . $onclick_file[$index_for_columns] . "?record_id=" . $table_data[$send_column[$index_for_columns]] . "\"'"; } else if ($onclick[$index_for_columns] == "POPUP") { $onclick_html = "onclick='open_iframe(\"" . $onclick_file[$index_for_columns] . "?record_id=" . $table_data[$send_column[$index_for_columns]] . "\")'"; } else { $onclick_html = ""; } // build display method of data if ($display_method[$index_for_columns] == "BUTTON") { echo ""; } else if ($display_method[$index_for_columns] == "ICON") { $icon_class = $icon[$index_for_columns]; // comes from POST echo ""; echo $returned_value; if ($icon_class != "") { echo " "; } echo ""; } else if ($display_method[$index_for_columns] == "PROGRESS BAR") { ?>
$returned_value"; } $index_for_columns++; } ?> query($table_name, "SELECT * FROM $table_name WHERE " . $where_data . " " . $order_by . " " . $limit . ""); while ($table_data = $table_res->fetch_assoc()) { $table_columns_res = $db->query($table_name, "SHOW COLUMNS FROM $table_name"); while ($columns = $table_columns_res->fetch_assoc()) { if (in_array($columns['Field'], $exclude_columns_array)) continue; $all_link_columns_under_table = $db->query("default_links", "SELECT * FROM default_links WHERE parent_table_name = '" . $table_name . "' AND parent_table_column = '" . $columns['Field'] . "'"); if ($all_link_columns_under_table->num_rows > 0) { $linked_tables_data = $all_link_columns_under_table->fetch_assoc(); if ($linked_tables_data['custom_text'] == "") { if ($linked_tables_data['child_table_name'] != "") { $get_linked_value = $db->query($linked_tables_data['child_table_name'], "SELECT " . $linked_tables_data['pull_column_name'] . " FROM " . $linked_tables_data['child_table_name'] . " WHERE record_id = " . $table_data[$columns['Field']]); if ($get_linked_value->num_rows > 0) { $linked_value = $get_linked_value->fetch_assoc(); $returned_value = $linked_value[$linked_tables_data['pull_column_name']]; } else { $returned_value = "LINK TO TABLE FAILED : SELECT " . $linked_tables_data['child_table_column'] . " FROM " . $linked_tables_data['child_table_name'] . " WHERE record_id = " . $table_data[$columns['Field']]; } } else { $returned_value = $table_data[$columns['Field']]; } } else { $returned_value = $linked_tables_data['custom_text']; } // function to do on click if ($linked_tables_data["onclick"] == "REDIRECT") { $onclick_html = "onclick='window.location.href = \"" . $linked_tables_data["onclick_file"] . "?record_id=" . $table_data[$linked_tables_data["send_column"]] . "\"'"; } else if ($linked_tables_data["onclick"] == "POPUP") { $onclick_html = "onclick='open_iframe(\"" . $linked_tables_data["onclick_file"] . "?record_id=" . $table_data[$linked_tables_data["send_column"]] . "\")'"; } else { $onclick_html = ""; } // build display method of data if ($linked_tables_data["display_method"] == "BUTTON") { echo ""; } else if ($linked_tables_data["display_method"] == "ICON") { $icon_class = $linked_tables_data["icon"]; // comes from POST echo ""; echo $returned_value; if ($icon_class != "") { echo ""; } echo ""; } else if ($linked_tables_data["display_method"] == "PROGRESS BAR") { ?>
$returned_value"; } } else { echo '' . @$table_data[$columns['Field']] . ''; } $index_for_columns++; } ?> table_name = $table_name; $db = new db(); ?>

file_path = $file_path; } function __destruct() { $db = new db(); $loading = new loading(); $exclude_columns_array = ['record_id', 'password']; ?> query("user_table_views", "SELECT * from user_table_views WHERE table_name = '" . $this->table_name . "'"); if ($table_view_res->num_rows > 0) { $this->custom_organization = true; echo ""; $this->columns = []; while ($table_view = $table_view_res->fetch_assoc()) { $this->columns[] = $table_view['column_name']; $this->pull_from[] = $table_view['pull_column']; $this->linked_tables[] = $table_view['match_to_table']; $this->functions[] = $table_view['function']; $this->display_method[] = $table_view['display_method']; $this->onclick[] = $table_view['onclick']; $this->onclick_file[] = $table_view['onclick_file']; $this->icon[] = $table_view['icon']; $this->send_column[] = $table_view['send_column']; $this->custom_text[] = $table_view['custom_text']; if ($table_view['custom_header'] != "") { echo ''; } else { if ($table_view['function'] == 'COUNT') { ?> ' . strtoupper(str_replace("_", " ", $table_view['column_name'])) . ''; } } } if ($this->file_path != null) { echo ""; } echo ""; } else { $this->custom_organization = false; ?> query($this->table_name, "SHOW COLUMNS FROM " . $this->table_name . ""); while ($row = $table_columns_res->fetch_assoc()) { $this->columns[] = $row['Field']; if (in_array($row['Field'], $exclude_columns_array)) continue; echo ''; } if ($this->file_path != null) { echo ""; } ?>
' . $table_view['custom_header'] . ' ACTIONS
' . strtoupper(str_replace("_", " ", $row['Field'])) . 'ACTIONS
loading_dots(); ?>