0) $start_date = date("Y-m-d 00:00:00",strtotime($_REQUEST['start_date'])); if (array_key_exists('end_date',$_REQUEST) && strlen($_REQUEST['end_date']) > 0) { $end_date = $_REQUEST['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 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',$_REQUEST) && strlen($_REQUEST['selected_usernum']) > 0) { $selected_usernum = intval($_REQUEST['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 payment methods unset($selected_payment_method); if (array_key_exists('selected_payment_method',$_REQUEST) && strlen($_REQUEST['selected_payment_method']) > 0) { if (isset($selected_transaction_type) && $selected_transaction_type != 'Payment') unset($selected_payment_method); else { $selected_payment_method = db_escape_string($_REQUEST['selected_payment_method']); $uwhere .= "AND ua.payment_method = '$selected_payment_method' "; $print_cmd .= "&selected_payment_method=$selected_payment_method"; } } // View only selected schedule $swhere = ""; $selected_schedule_num = 0; if (array_key_exists('selected_schedule_num',$_REQUEST) && strlen($_REQUEST['selected_schedule_num']) > 0) { $selected_schedule_num = db_escape_string($_REQUEST['selected_schedule_num']); $uwhere .= "AND ua.schedule_num = '$selected_schedule_num' "; $print_cmd .= "&selected_schedule_num=$selected_schedule_num"; } // Set query sort order $order_by = "ORDER BY payment_time,record_num"; $print_cmd .= "&sort=" . urlencode($sort); $message_width = 600; include "form.messages.php"; ?>

: : : $name ($type - $userid)\n"); } ?> : : = '$end_date' " . "AND status != 'Deleted' " . "ORDER BY schedule_start_date DESC"; $schedules = db_query($query); while ($row = db_fetch_array($schedules)) { $sname = $row['schedule_name']; $rnum = $row['record_num']; $selected = ""; if ($selected_schedule_num == $rnum) $selected = " selected='selected'"; echo(" $sname\n"); } ?>