Ntihc | imm system

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

CHEQUE PAYMENT VOUCHER

Payee		Project

Budget line description	Cheque Vr No.

	Date

*	DETAILS OF PAYMENT	BUDGET DETAILS	ACCOUNT / CODE	AMOUNT (UGX)

Cheque No.		TOTAL Shs.

Amount in words.

Prepared by:		Reviewed by:

Reviewed and approved by:		Date

Recieved by:		Date

Budget amount	Expenditure to date	Amount requested	Balance on budget

	Send to:

Payment voucher(s)

Reviewed and approved payments

"; echo ""; echo ""; echo ""; echo ""; echo ''; echo ""; } ?>

DATE	S/NO.	CHEQUE NO.	AMOUNT	VIEW	ACTION
".$res['TIMESTAMP']."	".$res['VOUCHERID']."	".$res['CHEQUENO']."	".$res['SUBTOTAL']."	\|	Print

Payment tracker | Add budget description

query($sql); $x=1; $bal = 0; while($row=$res->fetch_assoc()){ echo''. ''. ''. ''. ''. ''. ''. ''. ''. ''; $x=$x+1; } ?>

NO	PERIOD	PAYEE	CHEQUE.NO	AMOUNT	PROJECT	BUDGET DESCRIPTION	CODE
NO	PERIOD	PAYEE	CHEQUE.NO	AMOUNT	PROJECT	BUDGET DESCRIPTION	CODE
'.$x.'	'.$row['DATECREATED'].'	'.$row['PAYEE'].'	'.$row['CHEQUENO'].'	'.$row['SUM(SUBTOTAL)'].'	'.$row['PROJECT'].'	'.$row['BUDGETLINEDESCRIPTION'].'	'.$row['CODE'].'

Procurement Tracker

'.$str123.''; } else { $str1234=array(); $str1234=explode('_',$tempstr); $cnt = count( $str1234); if($str1234[$cnt-1]==''){ return ''; } else{ return ''; } } return false; } function getIndicator($str123){ $str123 = trim($str123); $tempstr = str_replace('__','_',$str123); if($str123==''){ return ''; } else { $str1234=array(); $str1234=explode('_',$tempstr); $cnt = count( $str1234); if($str1234[$cnt-1]==''){ return ''; } else{ return ''; } } } require('connect/config.php'); $sql = "SELECT * FROM procreqn WHERE CORACTION ='AUTHORISED' AND CONFEXTENSION ='$rm' AND AOACTION = 'APPROVED' AND ACTION = 'PENDING' GROUP BY REQUISITIONID ORDER BY TIMESTAMP DESC"; $res = $conn->query($sql); while($row=$res->fetch_assoc()){ echo ''. ''. ''. getIndicator($row["SUBJECTOFPROCUREMENT"]). getIndicator($row["SUBTOTAL"]). getIndicator($row["OFFICERALLOCATED"]). getIndicator($row["THRESHOLD"]). getIndicator($row["SUPPLIER"]). getIndicator($row["ACTUALCOST"]). ''. getIndicator($row["PENDINGREQUIREMENTS"]). ''; } ?>

ORDER.NO.	RECIEVED	SUBJECT.OF.PROCUREMENT	EST.COST	ALLOCATED.TO	RECOMMEDED.METHOD	SHORTLISTED PROVIDER	ACTUAL COST	PAYMENT STATUS	PENDING REQUIREMENTS	ORDER STATUS
ORDER.NO.	RECIEVED	SUBJECT OF PROCUREMENT	EST.COST	ALLOCATED.TO	RECOMMEDED.METHOD	SHORTLISTED.PROVIDER	ACTUAL.COST	PAYMENT.STATUS	REQUIREMENTS	ORDER.STATUS
'.$str123.'	'.$str123.'	'.$str123.'	'.$str123.'	'.$str123.'
'.$row["JOBNUMBER"].'	'.$row["RECIEVEDDATE"].'	'.$row["PAYMENTSTATUS"].'	'.$row["ORDERSTATUS"].'

New budget line description by Objective

Objective	Financial period

*	BUDGET LINE DESCRIPTION	CODE	BUDGET SUM

Ntihc M.E team 5 mins

Payment voucher(s)