} $class_name = "TransportProgramming"; //$class_name1="MyExpense"; //$class_name2="MyExpensePerson"; $table_name = $class_name::get_table_name(); $order_name = !empty($_GET["order_name"]) ? $_GET["order_name"] : 'id'; $order_type = !empty($_GET["order_type"]) ? $_GET["order_type"] : 'ASC'; //echo get_where_string($class_name); $page = !empty($_GET['page']) ? (int) $_GET["page"] : 1; $per_page = 20; $where = get_where_string($class_name); $total_count = $class_name::count_all_where($where); $pagination = new Pagination($page, $per_page, $total_count); require_once LIB_PATH . DS . 'download' . DS . 'download_csv.php'; $sql = "SELECT * FROM {$table_name} "; $sql .= " " . get_where_string($class_name); if (isset($order_name)) { $sql .= " ORDER BY {$order_name} {$order_type} "; } $sql .= "LIMIT {$per_page} "; $sql .= "OFFSET {$pagination->offset()}"; //echo "<p>$sql</p>"; //unset($_GET); $result_class = $class_name::find_by_sql($sql); $query_string = remove_get(array('view', 'page')); $view_full_table = !empty($_GET) ? (int) $_GET["view"] : 0; if ($view_full_table == 1) { $page_link_view = $class_name::$page_manage . $query_string . "page=" . u($page) . "&view=" . u(0); $page_link_text = $class_name::$page_name . " short view"; //$add_view="&view=".u(1); $offset = "col-md-offset-2";
public static function display_table_head_new($long_short = 0, $edit = true) { // $query_string= urldecode($_SERVER['QUERY_STRING']); $query_string = remove_get(array('order_name', 'order_type', 'page')); if ($long_short == 1) { $table_field = static::$db_fields_table_display_full; } else { $table_field = static::$db_fields_table_display_short; } $output = ""; $where = get_where_string(get_called_class()); $found_count = static::count_all_where($where); $total_count = static::count_all(); if ($found_count !== $total_count) { // $output.="<b>Found records: <span style='color:blue;'> ".h($found_count)." of ".h($total_count)."</span></b> | "; } foreach ($_GET as $key => $val) { $key_clean = str_replace("_", " ", $key); $key_clean = ucfirst($key_clean); if (!empty($_GET[$key]) && !in_array($key, array('page', 'view'))) { // $output.="<b>".h($key_clean)." <span style='color:blue;'> ".h(urldecode($_GET[$key]))."</span></b> | "; } } // $output.= "<tr>"; foreach ($table_field as $fieldname) { if (property_exists(new static(), $fieldname)) { $fieldname = str_replace("_", " ", $fieldname); $fieldname = ucfirst($fieldname); $output .= "<th class='text-center'>" . $fieldname . "</th>"; } } if ($edit) { // $output.= "<th colspan=\"1\" class=\"text-center\" style='vertical-align:middle;'>Actions</th>"; $output .= "<th>Actions</th>"; $output .= "<th></th>"; } // $output.= "</tr>"; return $output; }