0) $naction = $_GET['naction']; // // Parse any parameters // $where = "where school_num = $school_num "; // View only a selected user_num if (isset($selected_user_num) && strlen($selected_user_num) > 0) { $where .= "and user_num = '" . intval($selected_user_num) . "' "; $ParametersEntered = true; } // View only a selected order_num if (isset($selected_order_num) && strlen($selected_order_num) > 0) { $where .= "and order_num = '" . intval($selected_order_num) . "' "; $ParametersEntered = true; } // View only a selected people_num if (isset($selected_people_num) && strlen($selected_people_num) > 0) { $where .= "and ordered_by_num = '" . intval($selected_people_num) . "' "; $ParametersEntered = true; } if ($dateSearch) { $where .= "and updated_time BETWEEN '$selected_start_date 00:00:00' AND '$selected_end_date 23:59:59' "; $ParametersEntered = true; } if (!isset($selected_start_date)) $selected_start_date = date("Y-m-d",time()); if (!isset($selected_end_date)) $selected_end_date = date("Y-m-d",time()); ?>

: :

:

:

: $userid - $name\n"); } ?>

0) { $columnHeaders = array(getLanguageText('TEXT-USER'), getLanguageText('TEXT-STUDENT'), getLanguageText('TEXT-ORDER-NUMBER'), getLanguageText('TEXT-DATE'), getLanguageText('TEXT-TOTAL'), getLanguageText('TEXT-BALANCE'), getLanguageText('TEXT-ACTIVITY')); } $query = "SELECT * " . "FROM hotlunch_order_change_log $where order by log_time"; $entries = db_query($query); $data = array(); $balance = 0; $prev = 0; while ($row = db_fetch_assoc($entries)) { extract($row); $student = "Unknown"; if ($ordered_by_num > 0) { $results = db_query("SELECT * FROM people WHERE school_num IN ($school_num, $base_school_num) AND record_num = $ordered_by_num"); $student = ""; if (db_num_rows($results)) { $person = db_fetch_assoc($results); $student = $person['first_name'].' '.$person['last_name']; $user_num = $person['user_num']; $snum = $person['school_num']; if ($snum != $base_school_num) $student = "$student"; } } $userid = "Unknown"; if ($user_num > 0) { $results = db_query("SELECT * FROM users WHERE school_num IN ($school_num, $base_school_num) AND record_num = $user_num"); $userid = ""; if (db_num_rows($results)) { $user = db_fetch_assoc($results); $userid = $user['first_name'].' '.$user['last_name']; } } $schedule = "Unknown"; if ($schedule_num > 0) { $results = db_query("SELECT * FROM hotlunch_schedules WHERE school_num = $school_num AND record_num = $schedule_num"); $schedule = ""; if (db_num_rows($results)) { $row = db_fetch_assoc($results); $schedule = $row['schedule_name']; } } $prefix = '$'; if (strstr($order_action,"PAYMENT") !== FALSE) { $prefix = ''; $order_change = $order_total - $prev; $balance = 0; $ot = ''; } else { $order_change = $order_total - $prev; $balance += $order_change; $ot = $order_total; } $prev = $order_total; if ($balance < 0) $bal = '-$'.number_format($balance,2); else $bal = '$'.number_format($balance,2); if (isset($selected_order_num) && intval($selected_order_num) > 0) { $data[] = array("$userid", $student, $order_num, date("Y-m-d H:i:s",$log_time), $prefix.$ot, $bal, "$order_action"); } else { $data[] = array("$userid", $student, $order_num, $schedule, date("Y-m-d H:i:s",$log_time), $prefix.$ot, "$order_action"); } } listDataCustom($data,$columnHeaders,$action,array(),'N'); } ?>