query("SELECT * FROM user_table WHERE authorizationrights = 'GRANTED' "))
{ while ($row = $result->fetch_assoc() ) { $stdd=$stdd. " " . $row['Email'] ." "; }
}
$connect->close();
?>
Ntihc | imm system
Procurement orders due for review and approval 35% Complete (success)
DATE
NO.
EST.COST
ACTION
";
echo "".$res['CONFDATE']." ";
echo "".$res['JOBNUMBER']." ";
echo "".$res['SUBTOTAL']." ";
echo '
';
}
?>
Confirmation of funding 35% Complete (success)
20% Complete (warning)
20% Complete (warning)
10% Complete (danger)
Reviewed by 35% Complete (success)
20% Complete (warning)
20% Complete (warning)
10% Complete (danger)
APPROVED DATE
ORDER NO.
SUBJECT OF PROCUREMENT
ESTIMATED COST
ORDER.STATUS
ICON
ACTION
APPROVED DATE
ORDER NO.
SUBJECT OF PROCUREMENT
ESTIMATED COST
ORDER.STATUS
ICON
ACTION
";
echo "".$res['AODATE']." ";
echo "".$res['JOBNUMBER']." ";
echo "".$res['SUBJECTOFPROCUREMENT']." ";
echo "".$res['SUBTOTAL']." ";
echo "".$res['ORDERSTATUS']." ";
echo ' ';
echo "View
| Print ";
}
?>
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
{
$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('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 ''.
''.$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"].' ';
}
?>
35% Complete (success)
20% Complete (warning)
20% Complete (warning)
10% Complete (danger)
Copyright © 2017 Naguru Teenage Information and Health Center All rights
reserved.