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']); $totalAmount = mysql_escape_string($_POST['totalAmount']); $totalAmountxxx = mysql_escape_string($_POST['totalAmount']); $itemTotalAmount = str_replace(',','',$totalAmountxxx); $itemAmountXX = mysql_escape_string($_POST['itemAmount']); $itemAmount = str_replace(',','',$itemAmountXX); $myCanvassCode = mysql_escape_string($_POST['myCanvassCode']); $myVendorCode = mysql_escape_string($_POST['myVendorCode']); $ItemRecordID = mysql_escape_string($_POST['ItemRecordID']); $itemSpecs = mysql_escape_string($_POST['itemSpecs']); $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){ $dumAmount = number_format($itemAmount,2,'.',','); $dumTotalAmount = number_format($itemTotalAmount,2,'.',','); mysql_query("DELETE FROM `prf_canvass_sheet` WHERE `item_id` = '$ItemRecordID' AND `canvass_id`='$myCanvassID'"); mysql_query("INSERT INTO prf_canvass_sheet(item_id,canvass_id,quantity,amount,added_by,date_added,item_specs,total_item_qty_amount,dummy_amount,dummy_total_amount) VALUES('{$ItemRecordID}','{$myCanvassID}','{$itemQTY}','{$itemAmount}','{$uniqueRefID}','{$prfDate}','{$itemSpecs}','{$itemTotalAmount}','{$dumAmount}','{$dumTotalAmount}')"); //} } ?> ".$cvCode.""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>

"; echo $venCode; echo "

"; echo strtoupper($venName); echo "

".$csRow['quantity']."

".$csRow['amount']."

📑