| REC. ID | NAME | AUTHORITY | COMPANY |
|---|
";
$getExecomList = mysql_query("SELECT vts_users.company,vts_users.u_id,vts_users.u_fname,vts_users.u_lname,prf_execommembers.id,prf_execommembers.execom_id,prf_execommembers.authority,prf_execommembers.comp_id FROM `vts_users` JOIN `prf_execommembers` ON `prf_execommembers`.execom_id = vts_users.u_id WHERE `vts_users`.u_id=`prf_execommembers`.execom_id AND `prf_execommembers`.deleted=0 ORDER BY authority,company,u_lname ASC");
while($row=mysql_fetch_array($getExecomList)){
$companyName=mysql_result(mysql_query("SELECT comp_name FROM vts_company WHERE comp_id='".$row['comp_id']."'"),0);
$getAuthority= $row['authority'];
if($getAuthority == 1){
$exeType ='SINGLE APPROVER - Approval matrix WILL NOT be used';
}
if($getAuthority == 3){
$exeType ='GROUP OF EXECOM - Approval matrix WILL be used';
}
if($getAuthority == 2){
$exeType ='VP / SVP - Approval matrix WILL be used';
}
if($getAuthority == 4){
$exeType ='AVP\'s - Approval matrix WILL be used';
}
?>
".$row['id']."
".strtoupper($row['u_lname']).", ".strtoupper($row['u_fname'])."
".strtoupper($exeType)."
".strtoupper($companyName)." ";
echo " ";
}
echo "";
?>
SELECT EMPLOYEE:
EMPLOYEE NAME:
COMPANY NAME:
LEVEL OF AUTHORITY:
LEVEL OF AUTHORITY:
NO MATRIX = This will be used if MATRIX Table is OFF
VP/SVP/PRESIDENT = SVP/ CFO/President/ Ms.Owee (Any of the Three (3) plus additional Required Officer (Owee)
EXECOM MEMBERS = Required 3 EXECOM Members plus additiona required officer (WQT)
For GM's and Department Approval, the system will automatically detect the GM or the department head if required
NO MATRIX = This will be used if MATRIX Table is OFF
VP/SVP/PRESIDENT = SVP/ CFO/President/ Ms.Owee (Any of the Three (3) plus additional Required Officer (Owee)
EXECOM MEMBERS = Required 3 EXECOM Members plus additiona required officer (WQT)
For GM's and Department Approval, the system will automatically detect the GM or the department head if required