break; case "returns.php": $table = 'loaned_hardware'; $primaryKey = 'eagle_id'; $where = 'checkout_auth = 1'; break; default: $table = 'hardware'; $primaryKey = 'hardware_id'; } /*-----------------------END CONFIG-----------------------*/ //get table columns // Array of database columns which should be read and sent back to DataTables. // The `db` parameter represents the column name in the database, while the `dt` // parameter represents the DataTables column identifier. In this case simple // indexes $columnNames = get_column_heads($table); $columns = array(); for ($i = 0; $i < count($columnNames); $i++) { $pushArray = array('db' => $columnNames[$i], 'dt' => $i); array_push($columns, $pushArray); } if (isset($joinQuery)) { $results = SSP::simple($_GET, $sqlDetails, $table, $primaryKey, $columns, $joinQuery); } elseif (isset($where)) { $results = SSP::complex($_GET, $sqlDetails, $table, $primaryKey, $columns, $where); } else { $results = SSP::simple($_GET, $sqlDetails, $table, $primaryKey, $columns); } //query and echo results echo json_encode(linkDataTablesID($results, $url));
<?php require_once $_SERVER['DOCUMENT_ROOT'] . '/include/functions.php'; //config $columnSetting = "front"; //initialize page variables $title = ucfirst(basename(__FILE__, '.php')); $header = 'Return Request'; $description = 'Please find item in system that you checked out. After, request to return so administrator can approve your item return.'; $columns = format_column_heads(truncate_columns(get_column_heads("loaned_hardware"), 4)); $types = get_types(); require_once $_SERVER['DOCUMENT_ROOT'] . '/include/table_template.php';
<?php require_once $_SERVER['DOCUMENT_ROOT'] . '/include/functions.php'; //config $columnSetting = "front"; //initialize page variables $title = ucfirst(basename(__FILE__, '.php')); $header = 'Find Hardware'; $description = 'Filter your search by category, or search for a specific hardware ID, type of hardware, model, or location to best determine if there is hardware available to suit your needs.'; $columns = format_column_heads(truncate_columns(get_column_heads("hardware"), 6)); $types = get_types(); require_once $_SERVER['DOCUMENT_ROOT'] . '/include/table_template.php';