query("SELECT * FROM budgetcoder WHERE codestatus = 'ACTIVE' ")) { while ($row = $result->fetch_assoc() ) { $stss=$stss. ""; } } $connect->close(); ?> query("SELECT * FROM user_table WHERE authorizationrights = 'GRANTED' ")) { while ($row = $result->fetch_assoc() ) { $stdd=$stdd. ""; } } $connect->close(); ?> Ntihc | imm system

General petty cash expenditure Summary

query($sql); $x=1; $bal = 0; while($row=$res->fetch_assoc()){ $bal=($bal+ intval($row['CREDIT']))-intval($row['IMP_DEBIT']); echo''. ''. ''. ''. ''. ''. ''. ''. ''. ''. ''. ''; $x=$x+1; } ?>
NO. DATE MONTH EXPENDITURE DETAILS VOUCHER-NO. CREDIT DEBIT BALANCE BUDGET-LINE CODE
NO DATE FISCAL (M) EXPENDITURE DETAILS VOUCHER-NO. CREDIT DEBIT BALANCE BUDGET LINE CODE
'.$x.''.$row['RECIEVEDDATE'].''.$row['FISCALMONTH'].' / '.$row['FISCALYEAR'].''.$row['IMPREST_DESCRIPTION'].''.$row['ORDERNO'].''.$row['CREDIT'].''.$row['IMP_DEBIT'].''.$bal.''.$row['BUDGETLINE'].''.$row['CODE'].'

Monthly payments by budget line

query($sql); $x=1; $bal = 0; while($row=$res->fetch_assoc()){ echo''. ''. ''. ''. ''. ''. ''. ''; $x=$x+1; } ?>
NO MONTH YEAR AMOUNT (UGX) BUDGET LINE CODE
NO FISCAL (M) FISCAL (Y) AMOUNT (UGX) BUDGET LINE CODE
'.$x.''.$row['FISCALMONTH'].''.$row['FISCALYEAR'].''.$row['SUM(IMP_DEBIT)'].''.$row['BUDGETLINE'].''.$row['CODE'].'
Cash payments by vourcher number

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>
PMT.DATE FISCAL MONTH VOUCHER.NO PAYEE AMOUNT PAID BY ACTION
PMT.DATE FISCAL MONTH VOUCHER.NO PAYEE AMOUNT PAID BY ACTION
".$res['RECIEVEDDATE']."".$res['FISCALMONTH']."/ ".$res['FISCALYEAR']."".$res['ORDERNO']."".$res['RECIEVEDBY']."".$res['SUM(IMP_DEBIT)']."".$res['PAIDBY']."Open