Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function loadAllRes(){
- $query = [
- "key" => "R.reservation_id",
- "from" => "ws_reservations R INNER JOIN ws_persons P ON R.reservation_id = P.reservation_id",
- "columns" => array(
- array( 'db' => 'R.reservation_id', 'dt' => 0 ),
- array( 'db' => 'R.reservation_id', 'dt' => 1 ),
- array( 'db' => 'concat(firstname, " ", lastname)', 'dt' => 2, 'as' => 'name'),
- array( 'db' => 'concat(section, " - ", grave)','dt' => 3 , 'as' => 'location'),
- array( 'db' => 'R.res_date', 'dt' => 4 ),
- ),
- "where" => "is_vet = 1",
- ];
- $whereR = (!isset($query['where'])) ? null : $query['where'];
- echo json_encode(
- SSP::complex( $_POST, $query['key'], $query['from'], $query['columns'], $whereR, null)
- );
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement