pcms

NO	DESCRIPTION OF INVENTORY	CATEGORY	LOCATION	CONDITION	QTY COUNTED	QTY IN LEDGER	VARIANCE
NO	DESCRIPTION OF INVENTORY	CATEGORY	LOCATION	CONDITION	QTY COUNTED	QTY IN LEDGER	VARIANCE
'.$x.'	'.$row['PROPERTYDESCRIPTION'].'	'.$row['CATEGORY'].'	'.$row['LOCATION'].'	'.$row['FUNCTIONALSTATUS'].'	'.$row['SUM(QTYVERIFIED)'].'	'.$row['COUNT(id)'].'	'.$row['variance'].'

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

'.$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('configconns.php'); $sql = "SELECT id,PROPERTYDESCRIPTION,CATEGORY, CODIFICATIONSTATUS,ENGRAVEDNUMBER, VERIFICATIONSTATUS, DATEOFPURCHASE, MAKE,PROPERTYCOST,SUPPLIEDBY, LOCATION,RESPONSIBLEOFFICER,OFFICERCONTACT,FUNCTIONALSTATUS, SERVICEREQUIREMENT,NEXTDUESERVICE,REMINDDATE, PHYSICALSTATUS, CURDATE(), TIMESTAMPDIFF(YEAR,DATEOFPURCHASE,CURDATE()) AS age FROM properties ORDER BY CATEGORY DESC"; $res = $conn->query($sql); while($row=$res->fetch_assoc()){ echo ''. ''. ''. getIndicator($row["PROPERTYDESCRIPTION"]). getIndicator($row["CATEGORY"]). getIndicator($row["LOCATION"]). getIndicator($row["RESPONSIBLEOFFICER"]). getIndicator($row["PROPERTYCOST"]). getIndicator($row["age"]). getIndicator($row["SUPPLIEDBY"]). ''; } ?>

S/NO.	PROPERTY.NO.	DESCRIPTION	CATEGORY	LOCATION	RESPONSIBLE.OFFICER	COST	AGE/YRS	SUPPLIER	STATUS
S/NO.	PROPERTY.NO.	DESCRIPTION	CATEGORY	LOCATION	RESPONSIBLE.OFFICER	COST	AGE/YRS	SUPPLIER	STATUS
'.$str123.'	'.$str123.'	'.$str123.'	'.$str123.'	'.$str123.'
'.$row["id"].'	'.$row["ENGRAVEDNUMBER"].'	'.$row["PHYSICALSTATUS"].'

ASSET REGISTRATION FORM

Description

Category

Codification	PENDING	CODIFIED	N/A	Registration No.

Hold type	PURCHASED	DONATION	RENTAL	Recieved date

Asset make		Cost

Supplier / Donor /Rented from

Asset location

Officer responsible		Phone contact

Functional status	OPERATIONAL	FAULTY	Serviceability	NOT APPLICABLE	APPLICABLE

If applicable,please add service dates

Next service date		Remind date

Launch verification	IGNORE LAUNCH ALL

Event one :

On launch, verified properties will be set for => re-verification

Event two:

On launch, pending properties will be reset => due for verification

Add new asset

Verification laucher