format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $activeID=$user_data['u_id']; if(isset($_POST['getData'])){ $start = mysql_real_escape_string($_POST['start']); $limit = mysql_real_escape_string($_POST['limit']); $infCanvass = mysql_real_escape_string($_POST['infCanvass']); if($infCanvass=='' || $infCanvass == null){ $getItemHdr = mysql_query("SELECT * FROM `prf_request_detl` WHERE `deleted`=0 AND `for_canvass` = 1 AND `user_canvass_approval`=0 AND `item_status`=4 AND `canvass_by`=0 AND `ahg_admin_id`!=0 ORDER BY `ahg_admin_date` ASC LIMIT $start, $limit"); //SELECT * FROM `prf_request_detl` WHERE `deleted`=0 AND `for_canvass` = 1 AND `user_canvass_approval` = 0 AND `item_status`=4 AND `canvass_by`=0 }else{ $getItemHdr = mysql_query("SELECT * FROM `prf_request_detl` WHERE `deleted`=0 AND `for_canvass` = 1 AND `user_canvass_approval`=0 AND `item_status`=4 AND `canvass_by`=0 AND `header_ref_code`='$infCanvass' AND `ahg_admin_id`!=0 ORDER BY `ahg_admin_date` ASC"); } while($row=mysql_fetch_array($getItemHdr)){ $itemRefCode=$row['header_ref_code']; $attDoc =mysql_result(mysql_query("SELECT `attachment` FROM `prf_request_hdr` WHERE `reference_code`='$itemRefCode'"),0); $Cat = $row['category_id']; $SubCat = $row['sub_category_id']; $CatName = mysql_result(mysql_query("SELECT description FROM prf_expensecategory WHERE id='$Cat'"),0); $SubCatName = mysql_result(mysql_query("SELECT description FROM prf_expenseitems WHERE id='$SubCat'"),0); $compCode = mysql_result(mysql_query("SELECT comp_code FROM vts_company WHERE comp_id='".$row['comp_id']."'"),0); $dealCode = mysql_result(mysql_query("SELECT deal_code FROM vts_dealerships WHERE deal_id='".$row['dealer_id']."'"),0); $reqBy = mysql_result(mysql_query("SELECT request_by FROM prf_request_hdr WHERE reference_code='$itemRefCode'"),0); $canBy = $row['canvass_by']; $reqByFName = mysql_result(mysql_query("SELECT u_fname FROM vts_users WHERE u_id='$reqBy'"),0); $reqByLName = mysql_result(mysql_query("SELECT u_lname FROM vts_users WHERE u_id='$reqBy'"),0); $picTS = $row['date_time_pick']; $canByFName = mysql_result(mysql_query("SELECT u_fname FROM vts_users WHERE u_id='$canBy'"),0); $canByLName = mysql_result(mysql_query("SELECT u_lname FROM vts_users WHERE u_id='$canBy'"),0); $getPRFApprovalCode = mysql_result(mysql_query("SELECT current_status FROM prf_request_hdr WHERE reference_code='$itemRefCode' "),0); //if($getPRFApprovalCode == 4){ //onDblclick="javascript:showActionViewDelete(this);" ?>".$row['id'].""; echo "".strtoupper($row['header_ref_code']).""; echo "".strtoupper($row['ahg_admin_date']).""; echo "".strtoupper($dealCode).""; echo "".strtoupper($row['item_description']).""; echo "".strtoupper($row['quantity']).""; echo "".strtoupper($reqByLName).", ".strtoupper($reqByFName).""; echo "".strtoupper($canByLName).", ".strtoupper($canByFName)."
".$picTS.""; echo "".strtoupper($CatName).""; echo ""; $chkAttachment = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_attachment` WHERE `prf_number` = '".$row['header_ref_code']."'"),0); $withMail ='📝'; $attFilename = mysql_result(mysql_query("SELECT `document_name` FROM `prf_attachment` WHERE `prf_number` = '".$row['header_ref_code']."'"),0); $noMail = '-'; if($chkAttachment > 0){ echo "📑"; }else{ echo $noMail; } echo""; echo ""; //} } } ?>