0 && $_REQUEST['type'] == 'deleted') { $TitleText .= " (" . getLanguageText('TEXT-DELETED') . ")"; } // Start the template and output buffering startTemplate(); $templatePageTitle = $TitleText; // Ensure that only valid user types have access to this module if (!in_array($_SESSION['UserInfo']['type'],array('SuperUser','System Administrator','Application Administrator','Administration Team','Schedule Team','Financial','Financial Team'))) { echo("
\n"); $error_message = getLanguageText('ERRORMSG-ACCESS-DENIED'); include "form.messages.php"; return; } $school_num = $school_record['record_num']; ?>
0) { if (array_key_exists('start_date',$_POST) && strlen($_POST['start_date']) > 0) $start_date = date("Y-m-d 00:00:00",strtotime($_POST['start_date'])); if (array_key_exists('end_date',$_POST) && strlen($_POST['end_date']) > 0) { $end_date = $_POST['end_date']; if ($end_date < substr($start_date,0,10)) { $end_date = substr($start_date,0,10); $error_message = getLanguageText('ERRORMSG-INVALID-DATE-RANGE'); } $end_date = date("Y-m-d 23:59:59",strtotime($end_date)); } $sdate = substr($start_date,0,10); $edate = substr($end_date,0,10); $twhere = "AND posting_time BETWEEN '$start_date' AND '$end_date' "; // View only a selected userid $uwhere = ""; unset($selected_user); if (array_key_exists('selected_user',$_POST) && strlen($_POST['selected_user']) > 0) { $selected_user = $_POST['selected_user']; $uwhere = "AND payer_email = '$selected_user' "; } // Build argument string for GET $args = "&start_date=" . urlencode($start_date); $args .= "&end_date=" . urlencode($end_date); if (isset($selected_user)) $args .= "&selected_user=$selected_user"; $args .= "&error_message=" . urlencode($error_message); header("Location: /?action=$action$args"); exit(); } if (array_key_exists('action',$_GET) && array_key_exists('start_date', $_GET)) { $start_date = $_GET['start_date']; $end_date = $_GET['end_date']; $sdate = substr($start_date,0,10); $edate = substr($end_date,0,10); $twhere = "AND posting_time BETWEEN '$start_date' AND '$end_date' "; // View only a selected userid $uwhere = ""; unset($selected_user); if (array_key_exists('selected_user',$_GET) && strlen($_GET['selected_user']) > 0) { $selected_user = $_GET['selected_user']; $uwhere = "AND payer_email = '$selected_user' "; } } $message_width = 600; include "form.messages.php"; ?> 0) { ?>

0) $mc_gross = "$" . number_format($mc_gross,2); if ($mc_fee > 0) $mc_fee = "$" . number_format($mc_fee,2); // Add info tips if ($payment_status == 'Pending') { $span_id = "status_$record_num"; $otipSpans .= "

\n"; $otipSpanIDs[] = $span_id; $payment_status = "Pending"; } // Unknown posting results if ($posting_result == '') { $results = db_query("SELECT * FROM user_account WHERE school_num = $school_num AND payment_reference = '$txn_id'"); if (db_num_rows($results) > 0) { $posting_result = 'Posted'; } else { $posting_result = 'Error'; } } // Error postings if ($posting_result == 'Error') { $span_id = "result_$record_num"; if (strlen($posting_message) == 0) $posting_message = "Unknown Posting Error"; $otipSpans .= "\n"; $otipSpanIDs[] = $span_id; $msg = getLanguageText('TEXT-CONFIRM-UPDATE'); $posting_result = "Error"; } // Successful postings if ($posting_result == 'Posted') { $span_id = "result_$record_num"; $results = db_query("SELECT * FROM user_account WHERE school_num = $school_num AND payment_reference = '$txn_id'"); if (db_num_rows($results) > 0) { $otipSpanIDs[] = $span_id; $otipSpans .= "" . $otipTABLE; $otipSpans .= sprintf($otipROW2,"Transaction Num:",$trx_num); $otipSpans .= sprintf($otipROW2,"Item:",$item_name); $otipSpans .= sprintf($otipROW2,"Business:",$business); $otipSpans .= sprintf($otipROW2,"Receiver:",$receiver_email); $row = db_fetch_array($results); $otipSpans .= sprintf($otipROW2,"User Acct TRX:",$record_num); $order_payments = $row['order_payments']; $orders = explode("|",$order_payments); for ($i = 0; $i < count($orders); $i++) { $order_num = preg_replace('/\{(\d+):\d+.\d+\}/','{$1}',$orders[$i]); if (!is_numeric($order_num)) continue; // Get order info $results = db_query("SELECT * FROM hotlunch_order_header WHERE school_num = $school_num AND record_num = $order_num"); $row = db_fetch_array($results); // Get schedule info $schedule_num = $row['schedule_num']; $schedule_name = "Unknown"; if (is_numeric($schedule_num) && $schedule_num > 0) { $schedule_name = db_getVal("SELECT schedule_name FROM hotlunch_schedules WHERE school_num = $school_num AND record_num = $schedule_num"); } // Get person info $person_num = $row['ordered_by_num']; $oname = "Unknown"; if (is_numeric($person_num) && $person_num > 0) { $oname = db_getVal("SELECT concat(first_name,' ',last_name) FROM people WHERE school_num = $base_school_num AND record_num = $person_num"); } $otipSpans .= "

\n"; $otipSpans .= sprintf($otipROW2,"Order Number: ",$order_num); $otipSpans .= sprintf($otipROW2,"Ordered By: ",$oname); $otipSpans .= sprintf($otipROW2,"Order Schedule: ",$schedule_name); // $otipSpans .= sprintf($otipROW2,"Order Status: ",$row['status']); $otipSpans .= sprintf($otipROW2,"Order Date: ",$row['added_date']); // $otipSpans .= sprintf($otipROW2,"Last Updated: ",$row['updated_date']); } $otipSpans .= "\n"; $posting_result = "Posted"; } else { if ($row['payment_status'] != 'Pending') { $otipSpanIDs[] = $span_id; $otipSpans .= "\n"; $posting_result = "" . "Warning"; } else { $posting_result = "Pending"; } } } if ($posting_result == 'Pending') { $ppFields = array("payment_date","item_name","business","receiver_email","transaction_subject","txn_type","first_name","last_name","payer_email","payer_status", "mc_currency","mc_gross","mc_fee","reference","payment_type","payment_status","pending_reason","trx_num","posting_message"); $results = db_query("SELECT * FROM user_paypal_transactions WHERE school_num = $school_num AND txn_id = '$txn_id' ORDER BY record_num"); $span_id = "pending_$record_num"; $otipSpans .= "\n"; $posting_result = "Pending"; $posting_result = "" . "Pending"; } // Format name $name = "$first_name $last_name"; if (is_numeric($user_num) && $user_num > 0) { $results = db_query("SELECT * FROM users WHERE school_num = $base_school_num AND record_num = $user_num"); if (db_num_rows($results)) { $row = db_fetch_array($results); $span_id = "user_$user_num"; if (!in_array($span_id,$otipSpanIDs)) { $user_balance = db_getVal("select sum(transaction_amount) as balance from user_account where school_num = $school_num and user_num = $user_num AND (deleted != 'Y' OR deleted IS NULL)"); $user_balance = floatval($user_balance); $otipSpans .= "\n"; $otipSpanIDs[] = $span_id; } $name = "$name"; } $pemail = $payer_email; if (strlen($pemail) > 20) $pemail = substr($pemail,0,20) . "..."; $payer_email = "$pemail"; } ?>