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

My.rejected orders  

 Pending confirmations

Budget.desk (Waiting   )

My.approvals (pending  

My.reviews (approved  

Recieved (PDU   )

Procurement progress as of:

General procurement tracker
'.$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('proc/connect/config.php'); $sql = "SELECT * FROM procreqn WHERE CORACTION ='AUTHORISED' AND CONFEXTENSION ='$rm' AND AOACTION = 'APPROVED' AND ACTION = 'PENDING' GROUP BY REQUISITIONID ORDER BY TIMESTAMP DESC"; $res = $conn->query($sql); while($row=$res->fetch_assoc()){ echo ''. ''. getIndicator($row["RECIEVEDDATE"]). getIndicator($row["SUBJECTOFPROCUREMENT"]). getIndicator($row["SUBTOTAL"]). getIndicator($row["OFFICERALLOCATED"]). getIndicator($row["THRESHOLD"]). getIndicator($row["SUPPLIER"]). getIndicator($row["ACTUALCOST"]). getIndicator($row["PAYMENTSTATUS"]). getIndicator($row["PENDINGREQUIREMENTS"]). ''; } ?>
ORDER.NO. RECIEVED SUBJECT.OF.PROCUREMENT EST.COST ALLOCATED.TO RECOMMEDED.METHOD SHORTLISTED PROVIDER ACTUAL COST PAYMENT STATUS PENDING REQUIREMENTS ORDER STATUS
ORDER.NO. RECIEVED SUBJECT OF PROCUREMENT EST.COST ALLOCATED.TO RECOMMEDED.METHOD SHORTLISTED.PROVIDER ACTUAL.COST PAYMENT.STATUS REQUIREMENTS ORDER.STATUS
'.$str123.''.$str123.''.$str123.''.$str123.''.$str123.'
'.$row["JOBNUMBER"].''.$row["ORDERSTATUS"].'