0 && $_REQUEST['type'] == 'deleted') { $TitleText = getLanguageText('TEXT-DELETED-PAYPAL-TRANSACTIONS'); } // 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'))) { $error_message = getLanguageText('ERRORMSG-ACCESS-DENIED'); header("Location: /?error_message=".urlencode($error_message)); exit(); } $school_num = $school_record['record_num']; $print_cmd = ""; // Handle selected date ranges $start_date = date("Y-m-d 00:00:00",time()); $end_date = date("Y-m-d 23:59:59",time()); 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); if (!isset($twhere)) $twhere = ''; $twhere .= "AND transaction_datetime BETWEEN '$start_date' AND '$end_date' "; $print_cmd .= "&start_date=$sdate&end_date=$edate"; // View only a selected userid $uwhere = ""; unset($selected_usernum); if (array_key_exists('selected_usernum',$_POST) && strlen($_POST['selected_usernum']) > 0) { $selected_usernum = intval($_POST['selected_usernum']); $userid = db_getVal("SELECT userid FROM users WHERE record_num = $selected_usernum"); $uwhere = "AND ua.user_num = $selected_usernum "; $print_cmd .= "&selected_usernum=$selected_usernum"; } // View only selected transaction types $selected_transaction_type = 'Payment'; $uwhere .= "AND ua.transaction_type = '$selected_transaction_type' "; // View only selected payment methods $selected_payment_method = 'PayPal'; $uwhere .= "AND ua.payment_method = '$selected_payment_method' "; // View only selected schedule $swhere = ""; $selected_schedule_num = 0; if (array_key_exists('selected_schedule_num',$_POST) && strlen($_POST['selected_schedule_num']) > 0) { $selected_schedule_num = intval($_POST['selected_schedule_num']); $uwhere .= "AND ua.schedule_num = '$selected_schedule_num' "; $print_cmd .= "&selected_schedule_num=$selected_schedule_num"; } // Process an optional type parameter unset($deleteType); if (array_key_exists('type',$_REQUEST) && strlen($_REQUEST['type']) > 0 && $_REQUEST['type'] == 'deleted') { $deleteType = $_REQUEST['type']; $uwhere .= "AND deleted = 'Y' "; $print_cmd .= "&type=$deleteType"; } else { $deleteType = "active"; $uwhere .= "AND (deleted != 'Y' OR deleted IS NULL) "; } ?>