format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $myUID = $user_data['u_id']; if(isset($_POST['done'])){ $UpdatePRFReferenceNumber = mysql_escape_string($_POST['UpdatePRFReferenceNumber']); $UpdateprfCompanySelected = mysql_escape_string($_POST['UpdateprfCompanySelected']); $UpdatemyDealerList = mysql_escape_string($_POST['UpdatemyDealerList']); $UpdateprfCategorySelected = mysql_escape_string($_POST['UpdateprfCategorySelected']); $UpdateCategorySubItem = mysql_escape_string($_POST['UpdateCategorySubItem']); $UpdatePurposeOfReqeust = mysql_escape_string($_POST['UpdatePurposeOfReqeust']); $UpdateDateNeeded = mysql_escape_string($_POST['UpdateDateNeeded']); $UpdateprfApprovingHead = mysql_escape_string($_POST['UpdateprfApprovingHead']); $UpdatetxtAddItemDesc = mysql_escape_string($_POST['UpdatetxtAddItemDesc']); $UpdatetxtAddItemQty = mysql_escape_string($_POST['UpdatetxtAddItemQty']); $UpdateUnitOfMeasure = mysql_escape_string($_POST['UpdateUnitOfMeasure']); $UnitOfMeasure = mysql_escape_string($_POST['UnitOfMeasure']); $itemCategoryCleanUpdate = mysql_escape_string($_POST['UpdateItemCategory']); $itemCategoryUpdate = str_replace(' ', '', $itemCategoryCleanUpdate); //check if item class do exist in the database. If not exist insert this class as new $chkIFitemCategoryExist = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_item_category` WHERE `item_category`='$itemCategoryUpdate'"),0); if($chkIFitemCategoryExist == 0 ){ mysql_query("INSERT INTO prf_item_category(item_category,asset_cat) VALUES('{$itemCategoryUpdate}','{$UpdateprfCategorySelected}')"); } $UpdateitemCategoryID = mysql_result(mysql_query("SELECT `id` FROM `prf_item_category` WHERE `item_category`='$itemCategoryUpdate'"),0); //ADD FIRST ITEM TO PRF DETAILS $hrdID = mysql_result(mysql_query("SELECT id from prf_request_hdr WHERE reference_code='$UpdatePRFReferenceNumber' AND comp_id ='$UpdateprfCompanySelected'"),0); mysql_query("INSERT INTO prf_request_detl(item_class,header_id,header_ref_code,comp_id,dealer_id,category_id,sub_category_id,item_description,uom,quantity,date_created, time_created) VALUES('{$UpdateitemCategoryID}','{$hrdID}','{$UpdatePRFReferenceNumber}','{$UpdateprfCompanySelected}','{$UpdatemyDealerList}','{$UpdateprfCategorySelected}','{$UpdateCategorySubItem}','{$UpdatetxtAddItemDesc}','{$UpdateUnitOfMeasure}','{$UpdatetxtAddItemQty}','{$prfDate}','{$prfTime}')"); //$getItemDetl = mysql_query("SELECT * FROM prf_request_detl WHERE header_ref_code='$UpdatePRFReferenceNumber' AND `comp_id`='$UpdateprfCompanySelected'"); $getItemDetl = mysql_query("SELECT * FROM prf_request_detl WHERE header_ref_code='$UpdatePRFReferenceNumber' AND `deleted`=0"); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row=mysql_fetch_array($getItemDetl)){ $count = $count + 1; $itemClassID = $row['item_class']; $itemClassDes = mysql_result(mysql_query("SELECT `item_category` FROM `prf_item_category` WHERE `id`='$itemClassID'"),0); ?>".$count.""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

NO	REF. #	ITEM TYPE	ITEM DESCRIPTION	UoM	QUANTITYx
".strtoupper($row['header_ref_code'])."	".strtoupper($itemClassDes)."	".strtoupper($row['item_description'])."	".strtoupper($row['uom'])."	".$row['quantity']."

"; exit(); } ?>