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'])){ $selectedHDRID = mysql_escape_string($_POST['selectedHDRID']); $chkStatus = mysql_result(mysql_query("SELECT COUNT(1) FROM prf_request_detl WHERE header_ref_code ='$selectedHDRID' AND `po_code`!=''"),0); if($chkStatus > 0 ){ echo ""; }else{ //$checkIfApproved = mysql_result(mysql_query("SELECT `current_status` FROM prf_request_hdr WHERE `reference_code`='$selectedHDRID'"),0); mysql_query("UPDATE prf_request_hdr SET current_status = 93,deleted = 1 WHERE reference_code='$selectedHDRID'"); mysql_query("UPDATE prf_request_detl SET item_status = 93, deleted = 1 WHERE header_ref_code='$selectedHDRID'"); } echo "
NO REF. CODE DATE COMPANY DEALER REQ. CATEGOY REQ. TYPE
"; //$getItemHdr = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `deleted`=0 AND `request_by`='$uniqueRefID' AND `current_status` = 1 ORDER BY id DESC"); $getItemHdrDeptHead = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `request_by` ='$uniqueRefID' AND `current_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 ""; } //################################################################################################################################################################################## ?>
".strtoupper($row['reference_code'])."".strtoupper($row['date_created'])."".strtoupper($prfCompName)."".strtoupper($prfDealName)."".strtoupper($prfCatName)."".strtoupper($prfSubCatName).""; $checkUnReadMail = 1; $withMail ='📩'; $noMail = '✉'; if($checkUnReadMail > 0){ echo "".$withMail.""; }else{ echo $noMail; } echo"
Selected Record: