format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $uniqueRefID=$user_data['u_id']; $MyAPIcode = mysql_result(mysql_query("SELECT `SMSAPICode` FROM `asa_versioning_db` WHERE `type`='Live'"),0); $MyPasswd = mysql_result(mysql_query("SELECT `SMSAPIPass` FROM `asa_versioning_db` WHERE `type`='Live'"),0); if(isset($_POST['done'])){ $sendEmail = mysql_escape_string($_POST['sendEmail']); $sendSMS = mysql_escape_string($_POST['sendSMS']); $ActionReferenceIDa = mysql_escape_string($_POST['ActionReferenceIDa']); $myFollowUpNotes = mysql_escape_string($_POST['myFollowUpNotes']); $cStatus=mysql_result(mysql_query("SELECT `current_status` FROM `prf_request_hdr` WHERE `reference_code`='$ActionReferenceIDa'"),0); switch($cStatus){ case '1'://Head $notifyThisPerson=mysql_result(mysql_query("SELECT `dept_head_id` FROM `prf_request_hdr` WHERE `reference_code`='$ActionReferenceIDa'"),0); break; case '2'://GM $notifyThisPerson=mysql_result(mysql_query("SELECT `approving_GM_id` FROM `prf_request_hdr` WHERE `reference_code`='$ActionReferenceIDa'"),0); break; case '3'://Asset Validation $notifyThisPerson=mysql_result(mysql_query("SELECT `authorizing_dept_id` FROM `prf_request_hdr` WHERE `reference_code`='$ActionReferenceIDa'"),0); break; case '4'://Admin - Sourcing $notifyThisPerson=mysql_result(mysql_query("SELECT `approving_admin_id` FROM `prf_request_hdr` WHERE `reference_code`='$ActionReferenceIDa'"),0); break; case '5'://Execom Canvass Approval $subCatID=mysql_result(mysql_query("SELECT `sub_category_id` FROM `prf_request_hdr` WHERE `reference_code`='$ActionReferenceIDa'"),0); $notifyThisPerson=mysql_result(mysql_query("SELECT `execom_id` FROM `prf_expenseitems` WHERE `category_id`='$subCatID'"),0); break; case '6'://PO Creation/Approval $notifyThisPerson=mysql_result(mysql_query("SELECT `approving_admin_id` FROM `prf_request_hdr` WHERE `reference_code`='$ActionReferenceIDa'"),0); break; case '7'://Delivery Status $notifyThisPerson=mysql_result(mysql_query("SELECT `approving_admin_id` FROM `prf_request_hdr` WHERE `reference_code`='$ActionReferenceIDa'"),0); break; case '8'://Admin Tagging of Asset $notifyThisPerson=mysql_result(mysql_query("SELECT `approving_admin_id` FROM `prf_request_hdr` WHERE `reference_code`='$ActionReferenceIDa'"),0); break; } $empUFnamey = mysql_result(mysql_query("SELECT u_fname FROM vts_users WHERE u_id='$notifyThisPerson'"),0); $empUFname = mysql_result(mysql_query("SELECT u_fname FROM vts_users WHERE u_id='$notifyThisPerson'"),0); $deptHeadEmail= mysql_result(mysql_query("SELECT email FROM vts_users WHERE u_id='$notifyThisPerson'"),0); mysql_query("INSERT INTO prf_ff_message(ref_code,sender_id,message,send_to,sms,email,date,time) VALUES('{$ActionReferenceIDa}','{$uniqueRefID}','{$myFollowUpNotes}','{$notifyThisPerson}','{$sendSMS}','{$sendEmail}','{$prfDate}','{$prfTime}')"); //######################################################################################################################### //######################################################################################################################### if($sendSMS==='sms'){ $SMSMessage = "Hi ". $empUFname. "! ". " You have unread message regarding your purchase request. Please login you Autohub Connect to access this message."; $result = itexmo($notifyThisPerson, $SMSMessage,$MyAPIcode,$MyPasswd); if ($result == ""){ //echo ''; }else if ($result == 0){ //echo "SMS Sent!"; } else{ //echo "Error Num ". $result . " was encountered!"; } } //######################################################################################################################### //######################################################################################################################### if($sendEmail ==='email'){ $from = "support@autohubgroup.com"; $to = $deptHeadEmail; $subject = "NEW PURCHASE REQUEST"; $msgBox = "Hi ".$empUFname."! You have unread message regarding your purchase request. Please login you Autohub Connect to access this message. Autohub Support"; //######################################################################################################################### //######################################################################################################################### } } ?>
NO REF. CODE DATE COMPANY DEALER REQ. CATEGOY REQ. TYPE STATUS
0 AND `current_status` < 90 AND `deleted` = 0"); while($row=mysql_fetch_array($getItemHdrDeptHead)){ $count = $count + 1; $prfCompID = $row['comp_id']; $prfCompName = mysql_result(mysql_query("SELECT comp_name from vts_company WHERE comp_id = $prfCompID"),0); $prfDealID = $row['deal_id']; $prfDealName = mysql_result(mysql_query("SELECT deal_name from vts_dealerships WHERE deal_id = $prfDealID"),0); $prfCatID = $row['category_id']; $prfCatName = mysql_result(mysql_query("SELECT description from prf_expensecategory WHERE id= $prfCatID"),0); $prfSubCatID = $row['sub_category_id']; $prfSubCatName = mysql_result(mysql_query("SELECT description from prf_expenseitems WHERE id= $prfSubCatID"),0); $prfDeptApproverID = $row['dept_head_id']; $prfDeptApproverFName=mysql_result(mysql_query("SELECT u_fname from vts_users WHERE u_id= $prfDeptApproverID"),0); $prfDeptApproverLName=mysql_result(mysql_query("SELECT u_lname from vts_users WHERE u_id= $prfDeptApproverID"),0); $prfStatus = $row['current_status']; ?>".$count.""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } //################################################################################################################################################################################## ?>
".strtoupper($row['reference_code'])."".strtoupper($row['date_created'])."".strtoupper($prfCompName)."".strtoupper($prfDealName)."".strtoupper($prfCatName)."".strtoupper($prfSubCatName).""; $status = $row['current_status']; $statusName =mysql_result(mysql_query("SELECT status_name FROM prf_status WHERE sequence = $status"),0); echo $statusName; echo""; $checkUnReadMail = 1; $withMail ='📩'; $noMail = '✉'; if($checkUnReadMail > 0){ echo "".$withMail.""; }else{ echo $noMail; } echo"
Selected Record: