'; $header_checkboxes = ' ' . _( 'Expense' ) . ' & ' . _( 'Income' ) . '  '; $header_checkboxes .= ' ' . _( 'Staff Payroll' ) . '  '; if ( $RosarioModules['Student_Billing'] ) { $header_checkboxes .= ' ' . _( 'Student Billing' ) . ''; } DrawHeader( $header_checkboxes, '' ); DrawHeader( _( 'Report Timeframe' ) . ': ' . PrepareDate( $start_date, '_start', false ) . '   ' . _( 'to' ) . '   ' . PrepareDate( $end_date, '_end', false ), SubmitButton( _( 'Go' ) ) ); echo ''; // Accounting. if ( ! isset( $_REQUEST['accounting'] ) || $_REQUEST['accounting'] == 'true' ) { $accounting_payments = DBGetOne( "SELECT sum(AMOUNT) AS AMOUNT FROM ACCOUNTING_PAYMENTS WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' AND PAYMENT_DATE BETWEEN '" . $start_date . "' AND '" . $end_date . "' AND STAFF_ID IS NULL" ); $accounting_incomes = DBGetOne( "SELECT sum(f.AMOUNT) AS AMOUNT FROM ACCOUNTING_INCOMES f WHERE f.SYEAR='" . UserSyear() . "' AND f.SCHOOL_ID='" . UserSchool() . "' AND f.ASSIGNED_DATE BETWEEN '" . $start_date . "' AND '" . $end_date . "'" ); } // Staff salaries. if ( ! empty( $_REQUEST['staff_payroll'] ) ) { $staffpayroll_payments = DBGetOne( "SELECT sum(p.AMOUNT) AS AMOUNT FROM ACCOUNTING_PAYMENTS p, STAFF s WHERE p.SYEAR='" . UserSyear() . "' AND s.SYEAR=p.SYEAR AND p.SCHOOL_ID='" . UserSchool() . "' AND p.PAYMENT_DATE BETWEEN '" . $start_date . "' AND '" . $end_date . "' AND p.STAFF_ID=s.STAFF_ID AND p.SYEAR=s.SYEAR" ); $staffpayroll_incomes = DBGetOne( "SELECT sum(f.AMOUNT) AS AMOUNT FROM ACCOUNTING_SALARIES f, STAFF s WHERE f.SYEAR='" . UserSyear() . "' AND s.SYEAR=f.SYEAR AND f.SCHOOL_ID='" . UserSchool() . "' AND f.ASSIGNED_DATE BETWEEN '" . $start_date . "' AND '" . $end_date . "' AND f.STAFF_ID=s.STAFF_ID AND f.SYEAR=s.SYEAR" ); } // Student Billing. if ( ! empty( $_REQUEST['student_billing'] ) && $RosarioModules['Student_Billing'] ) { $billing_payments = DBGetOne( "SELECT sum(AMOUNT) AS AMOUNT FROM BILLING_PAYMENTS WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' AND PAYMENT_DATE BETWEEN '" . $start_date . "' AND '" . $end_date . "'" ); $billing_fees = DBGetOne( "SELECT sum(f.AMOUNT) AS AMOUNT FROM BILLING_FEES f WHERE f.SCHOOL_ID='" . UserSchool() . "' AND f.ASSIGNED_DATE BETWEEN '" . $start_date . "' AND '" . $end_date . "'" ); } echo '
'; PopTable( 'header', _( 'Totals' ) ); echo ''; $total = 0; // Accounting. if ( ! isset( $_REQUEST['accounting'] ) || $_REQUEST['accounting'] == 'true' ) { echo ''; echo ''; $total += $accounting_payments - $accounting_incomes; } // Staff salaries. if ( ! empty( $_REQUEST['staff_payroll'] ) ) { echo ''; echo ''; $total += $staffpayroll_payments - $staffpayroll_incomes; } // Student Billing. if ( ! empty( $_REQUEST['student_billing'] ) && $RosarioModules['Student_Billing'] ) { echo ''; echo ''; $total += $billing_payments - $billing_fees; } echo '' . ''; echo '

' . _( 'Expenses' ) . ': ' . '	' . Currency( $accounting_payments ) . '
' . _( 'Less' ) . ': ' . _( 'Incomes' ) . ': ' . '	' . Currency( $accounting_incomes ) . '
' . _( 'Salaries' ) . ': ' . '	' . Currency( $staffpayroll_payments ) . '
' . _( 'Less' ) . ': ' . _( 'Staff Payments' ) . ': ' . '	' . Currency( $staffpayroll_incomes ) . '
' . _( 'Student Payments' ) . ': ' . '	' . Currency( $billing_payments ) . '
' . _( 'Less' ) . ': ' . _( 'Fees' ) . ': ' . '	' . Currency( $billing_fees ) . '
' . _( 'Total' ) . ': ' . '	' . Currency( $total ) . '

'; PopTable( 'footer' );