query("SELECT * FROM user_table WHERE authorizationrights = 'GRANTED' ")) { while ($row = $result->fetch_assoc() ) { $stdd=$stdd. ""; } } $connect->close(); ?>
Pending supplies | ...... |
---|
...... | ....... | ..... |
---|
DATE | ORDER NO. | USER.UNIT | ACTION | ".$res['APPBYDATE']." | "; echo "".$res['ORDERSERIALID']." | "; echo "".$res['REQUESTINGUNIT']." | "; echo "Issue | Print | "; } ?>
---|
DATE | SERIAL.NO. | RECIEVED.FROM | LPO.NO. | INVOICE.NO. | ORDER.COST | RECIEVED.AS | ACTION | ".$res['GOODSRECIEVEDDATE']." | "; echo "".$res['ORDERSERIALID']." | "; echo "".$res['SERVICEPROVIDER']." | "; echo "".$res['LPONO']." | "; echo "".$res['INVOICENO']." | "; echo "".$res['TOTALCOST']." | "; echo "".$res['GOODSRECEIVABLETYPE']." | "; echo "Update   | grn | lpo | "; } ?>
---|
DATE | SERIAL.NO | APPROVED.BY | REQUESTING UNIT | FACILITY NANE | ORDER.TYPE | REQN.TYPE | ACTION | ".$res['DATECREATED']." | "; echo "".$res['ORDERSERIALID']." | "; echo "".$res['APPBYNAME']." | "; echo "".$res['REQUESTINGUNIT']." | "; echo "".$res['FACILITYNANE']." | "; echo "".$res['ORDERTYPE']." | "; echo "".$res['REQUISTIONTYPE']." | "; echo "Print standard | "; } ?>
---|
DATE | SERIAL.NO | APPROVED.BY | REQUESTING UNIT | FACILITY NANE | ORDER.TYPE | REQN.TYPE | ACTION | ".$res['DATECREATED']." | "; echo "".$res['ORDERSERIALID']." | "; echo "".$res['APPBYNAME']." | "; echo "".$res['REQUESTINGUNIT']." | "; echo "".$res['FACILITYNANE']." | "; echo "".$res['ORDERTYPE']." | "; echo "".$res['REQUISTIONTYPE']." | "; echo "Print general | "; } ?>
---|
DATE | SERIAL.NO | APPROVED.BY | REQUESTING UNIT | FACILITY NANE | ORDER.TYPE | REQN.TYPE | ACTION | ".$res['DATECREATED']." | "; echo "".$res['ORDERSERIALID']." | "; echo "".$res['APPBYNAME']." | "; echo "".$res['REQUESTINGUNIT']." | "; echo "".$res['FACILITYNANE']." | "; echo "".$res['ORDERTYPE']." | "; echo "".$res['REQUISTIONTYPE']." | "; echo "
---|
DATE RECIEVED | DESCRIPTION | UOM | LOCATION | SUPPLIER | LPO.NUMBER | INVOICE.NO. | QTY | UNIT.PRICE | AMOUNT |
---|---|---|---|---|---|---|---|---|---|
DATE RECIEVED | DESCRIPTION | UOM | LOCATION | SUPPLIER | LPO.NUMBER | INVOICE.NO. | QTY | UNIT.PRICE | AMOUNT | ".$res['GOODSRECIEVEDDATE']." | "; echo "".$res['DESCRIPTION']." | "; echo "".$res['UNITOFMEASURE']." | "; echo "".$res['STORELOCATION']." | "; echo "".$res['SERVICEPROVIDER']." | "; echo "".$res['LPONO']." | "; echo "".$res['INVOICENO']." | "; echo "".$res['QTYRECIEVED']." | "; echo "".$res['UNITCOST']." | "; echo "".$res['amountex']." | "; } ?>