proc

='$date' ORDER BY id DESC LIMIT 1"; $res = $conn->query($sql); while($row=$res->fetch_assoc()){ $TIMESTAMP = $row['TIMESTAMP']; $PAYMENTDATE = $row['PAYMENTDATE']; $PMTSERIALID = $row['PMTSERIALID']; $PAYMENTTYPE = $row['PAYMENTTYPE']; $USERINITIALS = $row['USERINITIALS']; $QUARTERACCOUNTABLE=$row['QUARTERACCOUNTABLE']; $USERTITLE = $row['USERTITLE']; $USERINO=$row['USERINO']; $UTILITYTYPE = $row['UTILITYTYPE']; $id = $row['id']; $PLANDETAILS = $row['PLANDETAILS']; $CODE = $row['CODE']; $FINANCIALPERIOD = $row['FINANCIALPERIOD']; $FIRSTQTR = $row['FIRSTQTR']; $SECONDQTR = $row['SECONDQTR']; $THIRDQTR=$row['THIRDQTR']; $FOURTHQTR = $row['FOURTHQTR']; $BUDGETAMOUNT=$row['BUDGETAMOUNT']; $BUDGETSTATUS = $row['BUDGETSTATUS']; } ?>

Budget sub item

Budget code Financial year

Bal on 1st QTR Bal on 2nd QTR

Bal on 3rd QTR Bal on 4th QTR

Total balance Budget status

Cheque No. Project

Payee

Payment quater Payment No.

Created date Serial No.

Details of payment Amount Action

='$date' GROUP BY PMTNO ORDER BY TIMESTAMP DESC"); while($res = mysqli_fetch_array($result)) { $sdtsrr = $res['QUARTERACCOUNTABLE']."***".$res['PMTNO']; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ''; echo ""; } ?>

P/NO. SERIAL/NO. CREATED DATE PAYMENT QTR PAYMENT SUM ACTION PRING

".$res['PMTNO']." ".$res['PMTSERIALID']." ".$res['PAYMENTDATE']." ".$res['QUARTERACCOUNTABLE']." ".$res['SUM(AMOUNTPAYABLE)']." print

Budget sub item

Budget code		Financial year

Bal on 1st QTR		Bal on 2nd QTR

Bal on 3rd QTR		Bal on 4th QTR

Total balance		Budget status

Cheque No.		Project

Payee

Payment quater		Payment No.

Created date		Serial No.

P/NO.	SERIAL/NO.	CREATED DATE	PAYMENT QTR	PAYMENT SUM	ACTION	PRING
".$res['PMTNO']."	".$res['PMTSERIALID']."	".$res['PAYMENTDATE']."	".$res['QUARTERACCOUNTABLE']."	".$res['SUM(AMOUNTPAYABLE)']."		print

Generate new payment

Generate payment(s)

Payment date

Payment s/n

Payment quater

1ST QUARTER 2ND QUARTER 3RD QUARTER 4TH QUARTER

Payment type

CHEQUE EFT

User initials

Title

User PFN

Update projects / contract details

Add new contract

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

S/NO SERVICE PROVIDER CONTRACT CONTRACT VALUE PAYMENT SHEDULE TENURE STARTDATE ENDDATE REMAINING PERIOD EXTENSION (END DATE) RESPONSIBILITY CENTER ACCOUNTABLE CONSULTED CONTRACT MANAGER

S/NO SERVICE PROVIDER CONTRACT CONTRACT VALUE PAYMENT SHEDULE TENURE STARTDATE ENDDATE REMAINING PERIOD EXTENSION (END DATE) RESPONSIBILITY CENTER ACCOUNTABLE CONSULTED CONTRACT MANAGER

".$res['id']." ".$res['SERVICEPROVIDER']." ".$res['CONTRACT']." ".$res['CONTRACTVALUE']." ".$res['PAYMENTSHEDULE']." ".$res['TENURE']." ".$res['STARTDATE']." ".$res['ENDDATE']." ".$res['year']." Yrs ".$res['month']." Months ".$res['day']." Days ".$res['EXTENSIONENDDATE']." ".$res['RESPONSIBILITYCENTER']." ".$res['ACCOUNTABLE']." ".$res['CONSULTED']." ".$res['CONTRACTMANAGER']."