PopTable('header', 'Search'); echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&modfunc=list method=POST>"; echo '<TABLE>'; echo '<TR><TD>Beginning Date</TD><TD>' . PrepareDate('_begin', DBDate(), false) . '</TD></TR>'; echo '<TR><TD>Ending Date</TD><TD>' . PrepareDate('_end', DBDate(), false) . '</TD></TR>'; PrepareSchool(SessionSchool(), '', SessionCurSchool()); echo '<TR><TD>Report</TD><TD>'; echo '<SELECT name=type> <OPTION value=stubillingcredits>Student Billing Credits</OPTION> <OPTION value=stubillingdebits>Student Billing Debits</OPTION> <OPTION value="stubillingwaived debits">Student Billing Waived Debits</OPTION> <OPTION value=lunchcredits>Lunch Credits</OPTION> <OPTION value=lunchdebits>Lunch Debits</OPTION> </SELECT>'; echo '</TD></TR>'; $accounts_RET = DBGet(DBQuery("SELECT ID,TITLE FROM STU_BILLING_ACCOUNTS WHERE SYEAR='" . GetSysYear() . "'")); if (count($accounts_RET)) { echo '<TR><TD>Account</TD><TD>'; echo '<SELECT name=account_id> <OPTION value="">Not Specified</OPTION>'; foreach ($accounts_RET as $value) { echo "<OPTION value={$value['ID']}>{$value['TITLE']}</OPTION>"; } echo '</SELECT>'; echo '</TD></TR>'; } echo '<TR><TD colspan=2 align=center>'; Buttons('Find', 'Reset'); echo '</TD></TR>'; echo '</TABLE>'; PopTable('footer');
function makeAccountInput($value = '') { $QI = DBQuery("SELECT TITLE,ID FROM STU_BILLING_ACCOUNTS WHERE SYEAR='" . GetSysYear() . "' ORDER BY TITLE"); $RET = DBReturnNoWord($QI, $count); $return .= "<SELECT name=account_id>"; foreach ($RET as $account) { $return .= "<OPTION value={$account['ID']}"; if ($account[ID] == $value) { $return .= " SELECTED"; } $return .= ">{$account['TITLE']}</OPTION>"; } $return .= "</SELECT>"; return $return; }
<?php DrawHeader('Pre-Defined Fee Report'); if ($_REQUEST[modfunc] == '') { echo '<BR>'; PopTable('header', 'Search'); echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&modfunc=list method=POST>"; echo '<TABLE>'; Warehouse('searchstu'); echo '<TR><TD>Pre-Defined Fee</TD><TD>'; echo '<SELECT name=fee_id>'; $RET = DBGet(DBQuery("SELECT TITLE,ID FROM STU_BILLING_DEFINED_FEES WHERE SYEAR='" . GetSysYear() . "'")); if (count($RET)) { foreach ($RET as $value) { echo "<OPTION value='{$value['ID']}'>{$value['TITLE']}</OPTION>"; } } echo '</SELECT>'; echo '</TD></TR>'; echo '<TR><TD>Show Students</TD><TD>'; echo '<SELECT name=editor> <OPTION value=with>With this Fee</OPTION> <OPTION value=without>Without this Fee</OPTION> <OPTION value=waived>With this Fee Waived</OPTION> </SELECT>'; echo '</TD></TR>'; PrepareSchool(SessionSchool(), '', SessionCurSchool()); Warehouse('searchgrade'); Warehouse('searchyear'); echo '<TR><TD colspan=2 align=center>'; Buttons('Find', 'Reset');