format("Y-m-d");
//if submit/ save to databasevar
if(isset($_POST['done'])){
$itemCode = mysql_escape_string($_POST['itemCode']);
$actionNote = mysql_escape_string($_POST['actionNotes']);
$actionNotes= "Return to Canvass: ".$actionNote;
$newStat = mysql_escape_string($_POST['newStat']);
$userID = mysql_escape_string($_POST['userID']);
$prfCode = mysql_escape_string($_POST['prfCode']);
$curStatusName = mysql_result(mysql_query("SELECT `status_name` FROM `prf_status` WHERE `id`='$newStat'"),0);
$getItemPRFCode = mysql_result(mysql_query("SELECT `header_ref_code` FROM `prf_request_detl` WHERE `id`='$itemCode'"),0);
if(!empty($itemCode)){
if ($getItemPRFCode != $prfCode){
echo '';
exit();
}else{
$curItemStatus = mysql_result(mysql_query("SELECT `item_status` FROM `prf_request_detl` WHERE `id`='$itemCode'"),0);
if($curItemStatus < 9){
mysql_query("UPDATE `prf_request_detl` SET `item_status`='$newStat', `approved_amount`= 0,`approved_qty`=0,`approved_proposal_code`=0,`award_to_vendor_id`=0,`awarded`=0,`canvass_sheet_creation_ts`='',`create_canvass_sheet`=0,`execom_approval_ts`='',`for_execom_canvass_approval`=0,`user_approval_ts`='',`user_canvass_approval`=0 WHERE `header_ref_code`='$prfCode' AND `deleted`=0 AND `id`='$itemCode'");
mysql_query("DELETE FROM `prf_execomcanvassapproval` WHERE `prf_ref_code` = '$prfCode' AND `item_code`='$itemCode'");
mysql_query("DELETE FROM `prf_validate_links` WHERE `po_code` = '$prfCode' AND `link` LIKE '%exapr%' AND `item_id`='$itemCode'");
}else{
echo '';
exit();
}
}
}else{
mysql_query("UPDATE `prf_request_detl` SET `item_status`='$newStat', `approved_amount`= 0,`approved_qty`=0,`approved_proposal_code`=0,`award_to_vendor_id`=0,`awarded`=0,`canvass_sheet_creation_ts`='',`create_canvass_sheet`=0,`execom_approval_ts`='',`for_execom_canvass_approval`=0,`user_approval_ts`='',`user_canvass_approval`=0 WHERE `header_ref_code`='$prfCode' AND `deleted`=0");
mysql_query("DELETE FROM `prf_execomcanvassapproval` WHERE `prf_ref_code` = '$prfCode'");
mysql_query("DELETE FROM `prf_validate_links` WHERE `po_code` = '$prfCode' AND `link` LIKE '%exapr%'");
}
//mysql_query("UPDATE `prf_validate_links` SET `completed`='$newStat' WHERE `reference_code`='$prfCode'");
//AUDIT LOGS======================================================
//AUDIT LOGS======================================================
mysql_query("INSERT INTO prf_changes_logs(action_taken,user_id,old_info,new_info,ref_number,item_id)
VALUES('{$actionNotes}','{$userID}','','{$newStat}','{$prfCode}','{$itemCode}')");
//AUDIT LOGS======================================================
//AUDIT LOGS======================================================
echo "Status: ".$curStatusName."
";
}
?>