File manager

File manager - Edit - /home/autoph/public_html/connect/home/PRF/PRF_AddToCanvassSheet.php

Back
<?php include 'core/init.php'; //$connect_error = 'Sorry, we\'re experiencing connection problem. Please try again later... Thank you!'; //mysql_connect('localhost','root','aee1024') or die ($connect_error); //mysql_select_db('db_vts') or die($connect_error); //error_reporting(1); 193 * 1067 * 215 $prfDate = date_create() ->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}')"); } } ?> <table> <?php $getActiveProposals = mysql_query("SELECT * FROM `prf_canvass_sheet` WHERE `deleted`=0 AND item_id='$ItemRecordID'"); while($csRow = mysql_fetch_array($getActiveProposals)){ $cvsID = $csRow['id']; $cvID = mysql_result(mysql_query("SELECT `canvass_id` FROM `prf_canvass_sheet` WHERE `id`='$cvsID'"),0); $venCode = mysql_result(mysql_query("SELECT `vendor_code` FROM `prf_uploadedcanvass` WHERE `id`='$cvID'"),0); $cvCode = mysql_result(mysql_query("SELECT `ref_code` FROM `prf_uploadedcanvass` WHERE `id`='$cvID'"),0); $venName = mysql_result(mysql_query("SELECT `vendor_name` FROM `prf_uploadedcanvass` WHERE `id`='$cvID'"),0); $cvFileCode = mysql_result(mysql_query("SELECT `file_code` FROM `prf_uploadedcanvass` WHERE `id`='$cvID'"),0); ?><tr onClick ="javascript:getEndorsedCanvassInfo(this);" onDblClick="javascript:showRemoveCanvassOption(this);"><?php echo "<td style='width:15%;font-size:12px;padding:3px;color:black'>".$cvCode."</td>"; echo "<td style='width:15%;font-size:12px;padding:3px;color:black'>"; echo $venCode; echo "</td>"; echo "<td style='width:40%;font-size:12px;padding:3px;color:black'>"; echo strtoupper($venName); echo "</td>"; echo "<td style='width:10%;font-size:12px;padding:3px;color:black;text-align:center'>".$csRow['quantity']."</td>"; echo "<td style='width:15%;font-size:12px;padding:3px;color:black;text-align:right'>".$csRow['amount']."</td>"; echo "<td style='width:5%;text-align:center'><a href='https://www.autohub.ph/connect/home/FILES/canvass/".$cvFileCode."' target='_blank'>📑</a></td>"; echo "</tr>"; } ?> </table>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings