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'])){ $itemQTY = mysql_escape_string($_POST['itemQTY']); $itemAmount = mysql_escape_string($_POST['itemAmount']); $myCanvassCode = mysql_escape_string($_POST['myCanvassCode']); $myVendorCode = mysql_escape_string($_POST['myVendorCode']); $ItemRecordID = mysql_escape_string($_POST['ItemRecordID']); $myCanvassID=mysql_result(mysql_query("SELECT `id` FROM `prf_uploadedcanvass` WHERE `ref_code`='$myCanvassCode'"),0); $checkIfExistA = mysql_result(mysql_query("SELECT COUNT(id) FROM prf_canvass_sheet WHERE `canvass_id`='$myCanvassID' AND `item_id`='$ItemRecordID'"),0); if($checkIfExistA == 0){ mysql_query("INSERT INTO prf_canvass_sheet(item_id,canvass_id,quantity,amount,added_by,date_added) VALUES('{$ItemRecordID}','{$myCanvassID}','{$itemQTY}','{$itemAmount}','{$uniqueRefID}','{$prfDate}')"); } } ?> ".$cvCode.""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>

"; echo $venCode; echo "

"; echo strtoupper($venName); echo "

".$csRow['quantity']."

".$csRow['amount']."

📑