format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $activeID=$user_data['u_id']; if(isset($_POST['done'])){ $getAuthority = mysql_escape_string($_POST['getAuthority']); $getExecom = mysql_escape_string($_POST['getExecom']); $getCompany = mysql_escape_string($_POST['getCompany']); //$getCompID = mysql_result(mysql_query("SELECT company FROM vts_users WHERE u_id='$getExecom'"),0); $checkIfExist = mysql_result(mysql_query("SELECT COUNT(1) FROM prf_execommembers WHERE execom_id='$getExecom' AND `authority`='$getAuthority' AND `comp_id`='$getCompany'"),0); if($checkIfExist > 0){ //mysql_query("DELETE FROM `db_vts`.`prf_execommembers` WHERE execom_id='$getExecom' AND `authority`='$getAuthority'"); }else{ mysql_query("INSERT INTO prf_execommembers(comp_id,execom_id,authority) VALUES('{$getCompany}','{$getExecom}','{$getAuthority}')"); } } echo ""; $getExecomList = mysql_query("SELECT 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'].""; echo ""; } echo "

".strtoupper($row['u_lname']).", ".strtoupper($row['u_fname'])."

".$exeType."

".strtoupper($companyName)."

"; exit(); ?>