query("SELECT * FROM user_table WHERE authorizationrights = 'GRANTED' "))
{ while ($row = $result->fetch_assoc() ) { $stdd=$stdd. " " . $row['Email'] ." "; }
}
$connect->close();
?>
proc
CREATED.DATE
INITIATOR
DEPARTMENT
SUBJECT.OF.PROCUREMENT
H.O.D
DATE
B.DESK
DATE
AO.APPROVALS
FA.DATE
P.D.U
CREATED DATE
INITIATOR
DEPARTMENT
SUBJECT.OF.PROCUREMENT
H.O.D
DATE
B.DESK
DATE
AO.APPROVALS
FA.DATE
P.D.U
'.$str123.''; }
else
{
$str1234=array();
$str1234=explode('_',$tempstr);
$cnt = count( $str1234);
if($str1234[$cnt-1]==''){ return ''.$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('proc/connect/config.php');
$sql = "SELECT * FROM procreqn WHERE PROCUREMENTSTATUS ='WAITING'
GROUP BY REQUISITIONID ORDER BY TIMESTAMP DESC";
$res = $conn->query($sql);
while($row=$res->fetch_assoc()){
echo ''.
''.$row["TIMESTAMP"].' '.
getIndicator($row["RFPUSERNAME"]).
getIndicator($row["INITIATORDEPT"]).
getIndicator($row["SUBJECTOFPROCUREMENT"]).
getIndicator($row["CORACTION"]).
getIndicator($row["CORDATE"]).
getIndicator($row["CONFSTATUS"]).
getIndicator($row["CONFDATE"]).
getIndicator($row["AOACTION"]).
getIndicator($row["CONFDATE"]).
''.$row["PROCUREMENTSTATUS"].' ';
}
?>