query("SELECT * FROM user_table WHERE authorizationrights = 'GRANTED' ")) { while ($row = $result->fetch_assoc() ) { $stss=$stss. ""; } } $connect->close(); ?> pcms

    • CURRENT ASSETS VERIFICATION REPORT

    FROM TO

    query("SELECT COUNT(id),PROPERTYDESCRIPTION, CATEGORY, LOCATION, SUM(QTYVERIFIED), FUNCTIONALSTATUS, COUNT(id)-SUM(QTYVERIFIED) as variance FROM properties WHERE PHYSICALSTATUS = 'AVAILABLE' AND VERIFICATIONSTATUS ='YES' GROUP BY PROPERTYDESCRIPTION ORDER BY CATEGORY DESC"); $count = $res->num_rows; if($count > 0) { while($row=$res->fetch_array()) { ?> 0) { ?>
    DESCRIPTION OF INVENTORY CATEGORY LOCATION CONDITION QTY COUNTED QTY IN LEDGER VARIANCE

    Prepared by   Reviewd and approved by
    Name   Name
    Date style="width:100%; text-align:left;background-color:#FFF;border:0px;">   Date style="width:100%; text-align:left;background-color:#FFF;border:0px;">
    Signature   Signature