Example #1
0
    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');
Example #2
0
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;
}
Example #3
0
<?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');