query("SELECT * FROM user_table WHERE authorizationrights = 'GRANTED' ")) { while ($row = $result->fetch_assoc() ) { $stdd=$stdd. ""; } } $connect->close(); ?>
DATE | S/NO. | EST COST | ACTION | ".$res['TIMESTAMP']." | "; echo "".$res['REQUISITIONID']." | "; echo "".$res['SUBTOTAL']." | "; echo ''; echo " | Delete | "; } ?>
---|
DATE | S/NO. | EST.COST | ACTION | ".$res['TIMESTAMP']." | "; echo "".$res['REQUISITIONID']." | "; echo "".$res['SUBTOTAL']." | "; echo ''; } ?> |
---|
ORDER.NO. | CREATED | INITIATOR | DEPARTMENT | SUBJECT.OF.PROCUREMENT | EST.COST | ACTION | PDU.STATUS |
---|---|---|---|---|---|---|---|
ORDER NO. | CREATED DATE | INITIATOR | DEPARTMENT | SUBJECT OF PROCUREMENT | EST COST | ACTION | PDU.STATUS | ".$res['JOBNUMBER']." | "; echo "".$res['TIMESTAMP']." | "; echo "".$res['RFPUSERNAME']." | "; echo "".$res['INITIATORDEPT']." | "; echo "".$res['SUBJECTOFPROCUREMENT']." | "; echo "".$res['SUBTOTAL']." | "; echo "View | Print | "; echo "".$res['ORDERSTATUS']." | "; } ?>
My e-procurement requisitions follow up
JOB NO. | CREATED | H.O.D | DATE | B.DESK | DATE | AO.APPROVALS | FA.DATE | P.D.U | ALLOCATED.TO | JOB.STATUS |
---|---|---|---|---|---|---|---|---|---|---|
JOB NO. | CREATED | H.O.D | DATE | B.DESK | DATE | AO.APPROVALS | FA.DATE | P.D.U | OFFICER | JOB.STATUS | '.$str123.' | '; } else{ return ''.$str123.' | '; } } return false; } function getIndicator($str123){ $str123 = trim($str123); $tempstr = str_replace('__','_',$str123); if($str123==''){ return ''.$str123.' | '; } else { $str1234=array(); $str1234=explode('_',$tempstr); $cnt = count( $str1234); if($str1234[$cnt-1]==''){ return ''.$str123.' | '; } else{ return ''.$str123.' | '; } } } require('connect/config.php'); $sql = "SELECT * FROM procreqn WHERE CORACTION ='AUTHORISED' AND SENDTO ='$rm' AND ACTION = 'PENDING' GROUP BY REQUISITIONID ORDER BY TIMESTAMP DESC"; $res = $conn->query($sql); while($row=$res->fetch_assoc()){ echo '
'.$row["JOBNUMBER"].' | '. ''.$row["TIMESTAMP"].' | '. getIndicator($row["CORACTION"]). getIndicator($row["CORDATE"]). getIndicator($row["CONFSTATUS"]). getIndicator($row["CONFDATE"]). getIndicator($row["AOACTION"]). getIndicator($row["CONFDATE"]). getIndicator($row["PROCUREMENTSTATUS"]). getIndicator($row["OFFICERALLOCATED"]). ''.$row["ACTION"].' |