File manager

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

Back
<?php include 'core/init.php'; protected_page(); $uniqueRefID = $user_data['u_id']; //echo $uniqueRefID; $prfDate = date_create() ->format("Y-m-d"); $prtTime =Explode(":", date('H:i:s')); $txDate = explode("-",$prfDate); $refYear = $txDate[0]; $refMonth = $txDate[1]; $refMinute = $prtTime[1]; $refSecond = $prtTime[2]; $NewRefCode = $refMonth.''.$refMinute.''.$refSecond; ?> <!DOCTYPE html> <html lang="en"> <head> <link rel="stylesheet" type="text/css" href="css/bootstrap.css"/> <link rel="stylesheet" type="text/css" href="css/jquery-ui.css"/> <meta charset="UTF-8" name="viewport" content="width=device-width, initial-scale=1"/> </head> <body> <div class='NewPRFHeader'> <p class='PRFBodyTitle'>📝  ACTIVE PROPOSALS(Expired proposal will not be listed here...)</p> </div> <!--########################## MAIN TABLE WINDOW ############################################--> <!--########################################################################################################--> <div class='NewPRFBody'> <div class='NewPRFBodyMenu'> <div class='searchDIVA'> <!--<b class='BodyTopMenu' id='LoadNewPRFForm' onclick='showActionSlipForm()'>➕ New Purchase </b> --> <b class='BodyTopMenu'>📠 Print </b> <b class='BodyTopMenu' onclick="javascript:getInfoCode(this);">⬇ Upload Proposal</b> </div> <div class='searchDIVB'> <input type='hidden' id='userActiveID' value='<?php echo $uniqueRefID;?>'> <input type='text' id='SearchCanvass' placeholder='Search Record.' class='textSearch' style='width:70%;margin:0px;border:1px solid lightgray;'> <button id='goSearchCanvass' class='searchButton' style='width:25%'> 🔍       Search</button> </div> </div> <div id='mainTable' class='PRFTableBody'> <div style='width:100%;height:33px;background:white'> <table> <thead> <th style='width:5%'>REC. NO</th> <th style='width:7%'>REF. CODE</th> <th style='width:7%'>DATE ADDED</th> <th style='width:8%'>VENDOR CODE</th> <th style='width:34%'>VENDOR NAME</th> <th style='width:10%'>VALIDITY DATE</th> <th style='width:15%'>UPLAODED BY</th> <th style='width:5%'>FILE</th> </thead> </table> </div> <div class='PRFTableItems'> <table> <?php $getItemHdr = mysql_query("SELECT * FROM `prf_uploadedcanvass` WHERE `deleted`= 0 AND `validity_date` > '$prfDate' ORDER BY id DESC"); while($row=mysql_fetch_array($getItemHdr)){ $uploadedBy=$row['uploaded_by']; $vID=$row['vendor_id']; $myVendorName = mysql_result(mysql_query("SELECT sup_name FROM prf_suppliers WHERE id='$vID'"),0); $reqByFName = mysql_result(mysql_query("SELECT u_fname FROM vts_users WHERE u_id='$uploadedBy'"),0); $reqByLName = mysql_result(mysql_query("SELECT u_lname FROM vts_users WHERE u_id='$uploadedBy'"),0); ?><tr onclick="javascript:getInfo(this);" onDblclick="javascript:showCanvassOption(this);" ><?php echo "<td style='width:5%'>".$row['id']."</td>"; echo "<td style='width:7%'>".strtoupper($row['ref_code'])."</td>"; echo "<td style='width:7%'>".strtoupper($row['date_added'])."</td>"; echo "<td style='width:8%;text-align:left'>".strtoupper($row['vendor_code'])."</td>"; echo "<td style='width:34%;text-align:left'>".$myVendorName."</td>"; echo "<td style='width:10%;text-align:left'>".strtoupper($row['validity_date'])."</td>"; echo "<td style='width:15%'>".strtoupper($reqByLName).", ".strtoupper($reqByFName)."</td>"; echo "<td style='width:5%;text-align:center'><a href='https://www.autohub.ph/connect/home/FILES/canvass/".$row['file_code']."' target='_blank'>View</a></td>"; echo "</tr>"; } ?> <tr><td colspan='9' ><hr style='padding:0px;background:transparent;border:0px;border-bottom:1px solid gray'></td> <tr> <td colspan='2' style='background:white;font-family:Yu Gothic; font-size:13px;color: #f97d43 ;height:20px;font-family:Yu Gothic Light;font-weight:bold;color:black'>Selected Record:</td> <td colspan='7' style='background:white;'> <input type='text' id='selectedPRFHeaderID' class='TableBottomLabel' style='border:0px solid white;text-align:left;font-family:Yu Gothic Light;font-weight:bold;color:black' disabled> </td> </tr> </table> </div> </div> </div> <!--########################## POPUP ACTION WINDOW FOR DELETE AND VIEW DETAILS ############################################--> <!--########################################################################################################--> <div id="MyUploadForm" class="uploadForm"> <div class='PopUpWindowTitle'> 🪧 Upload Proposal <div class='PopUpWindowClose'> <b onclick="javascript:hideUploadForm(this);" style='font-weight:bold'> ✕ </b> </div> </div> <table> <tr> <td style='padding:5px;width:100%;background:lightgray;font-family:Yu Gothic; font-size:16px;color:red ;font-weight:normal;text-align:left'> <form action = "" method="post" enctype="multipart/form-data" style='background:white;border:0px solid gray;text-align:left;font-family:Arial;font-size:12px;color:black;border-bottom:0px solid lightgray;margin-top:10px'> <div style='width:48.2%;float:left;padding:10px;background:white;margin-left:10px;padding-bottom:0px'>Referece Code:<br> <input type="text" disabled id="canvassCode" style="font-family:Arial;font-size:12px;color:blue;font-weight:bold;margin:2px;padding:6.5px;border:0px solid white"> </div> <div style='width:48.2%;float:left;padding:10px;background:white;padding-bottom:0px'>Validity Date:<br> <input type="date" id="validityDate" style="font-family:Arial;font-size:12px;color:blue;font-weight:bold;margin:2px;padding:2px;"> </div> <div style='width:96.5%;float:left;padding:10px;background:white;margin-left:10px;padding-bottom:5px'>Select Vendor:<br> <select id='vendorCode' class='DropDownButton' style='margin:0px;' > <option value=''>-- Select --</option> <?php $getSuppliersList = mysql_query("SELECT * FROM `prf_suppliers` WHERE `deleted`=0 ORDER BY `sup_name` ASC"); while($row=mysql_fetch_array($getSuppliersList)){ echo "<option value='".$row['id']."'>".strToupper($row['sup_name'])."</option>"; } ?> </select> </div> <div style='width:96.5%;float:left;padding:10px;background:white;margin-left:10px;padding-bottom:5px'> <b style='font-family:Yu Gothic Light;font-size:14px;padding:3px'>Select Canvass Document:</b><br><input type="file" value="Upload" id="canvassFile" required style='padding;6px;float:left;background:white;width:100%;text-align:left;border:0px;float:left;font-family:Calibri;font-size:12px;margin-bottom:0px'> </div> <div style='width:96.5%;float:left;padding:10px;background:white;margin-left:10px;padding-bottom:5px'>Remarks:<br> <textarea rows='1' id='myNotes' style='width:100%;padding:10px'></textarea> </div> </form> </td> </tr> <tr> <td colspan='1' style='padding:10px;width:250px;background:lightgray;border-top:0px solid gray;text-align:center;padding-top:5px'> <div style='width:100%;float:right;height:63px;padding:10px;background:lightgray'> <button onclick="javascript:showUpdatePRFForm(this);" id='uploadCanvass' class='PopUpLowerButtonR' >⬇    Upload Proposal</button> </div> </td> </tr> </table> </div> </body> </html> <!--- LOCALIZED COPY OF JAVASCRIPT --> <script type="text/javascript" src="http://code.jquery.com/jquery-1.9.1.js"></script> <script type="text/javascript"> $(document).ready(function(){ //====================================================================================================== $("#uploadCanvass").click(function(){ var canvassCode = $("#canvassCode").val(); var myNotes = $("#myNotes").val(); var userActiveID = $("#userActiveID").val(); var validityDate = $("#validityDate").val(); var vendorCode = $("#vendorCode").val(); var file_data = $('#canvassFile').prop('files')[0]; var form_data = new FormData(); // Create a FormData object canvassCode validityDate vendorProposal form_data.append('file', file_data); // Append all element in FormData object form_data.append('canvassCode', canvassCode); form_data.append('myNotes', myNotes); form_data.append('userActiveID', userActiveID); form_data.append('validityDate', validityDate); form_data.append('vendorCode', vendorCode); if(file_data==''){ alert('No record has been selected. ERROR: File upload failed.'); exit(); } if(vendorCode==''){ alert('ERROR: Please select vendor to continue.'); exit(); } if(validityDate==''){ alert('ERROR: Invalid validity date.'); exit(); } ShowUploadBar(); //alert('its working'); //return false; $.ajax({ url : 'PRF_UPLOAD_CANVASS_FILE.php', // point to server-side PHP script dataType : 'text', // what to expect back from the PHP script, if anything cache : false, contentType : false, processData : false, data : form_data, type : 'post', success : function(output){ $("#mainTable").html(output); ShowUploadBar(); hideUploadForm(); } }); $('#canvassFile').val(''); /* Clear the file container / }); $("#goSearchCanvass").click(function(){ var SearchCanvass = $("#SearchCanvass").val(); ShowUploadBar(); $.ajax({ url: "PRF_Search_CanvassFile.php", type: "POST", async: false, data: { "SearchCanvass": SearchCanvass, "done": 1 }, success: function(d){ ShowUploadBar(); $("#mainTable").html(d); } }) }); //====================================================================================================== function updateCREATENEWPRF(){ $.ajax({ url: "PRF_Update_CREATE_NEW_PRF.php", type: "POST", async: false, data: { "trans":1 }, success: function(d){ updatePostedPRF(); $("#unPostedPRFRequestCount").html(d); } }) } //====================================================================================================== function updatePostedPRF(){ $.ajax({ url: "PRF_Update_POSTEDPRF.php", type: "POST", async: false, data: { "trans":2 }, success: function(d){ $("#PostedPRFRequestCount").html(d); } }) } //====================================================================================================== function updateApprovalPRF(){ $.ajax({ url: "PRF_procIncomingInfo.php", type: "POST", async: false, data: { "trans":2 }, success: function(d){ $("#forMyApprovalCount").html(d); } }) } //====================================================================================================== function refreshMainTable(){ $.ajax({ url: "PRF_MainTableHeaderDisplay.php", type: "POST", async: false, data: { }, success: function(d){ //invShowAssignMsg(); $("#mainTable").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) } }); </script> <!--- LOCALIZED COPY OF JAVASCRIPT --> <script type="text/javascript"> function hideActionSlipForm(){ $("#PRFCreateNewRequest").fadeOut(500); }; function showActionSlipForm(){ $("#PRFCreateNewRequest").fadeIn(500); }; function hideUploadForm(){ $("#MyUploadForm").fadeOut(500); }; function showUploadForm(){ $("#MyUploadForm").fadeIn(500); }; function hideUpdatePRFForm(){ $("#PRFUPDATENewRequest").fadeOut(500); }; function showUpdatePRFForm(){ $("#PRFUPDATENewRequest").fadeIn(500); $("#showActionViewDelete").fadeOut(500); }; function getInfo(row) { var x=row.cells; document.getElementById("selectedPRFHeaderID").value = x[1].innerHTML; document.getElementById("selectedPRFHeaderIDLabel").value = x[1].innerHTML; document.getElementById("ActionReferenceID").value = x[1].innerHTML; document.getElementById("ActionReferenceIDDesc").value = "Ref.#: " + x[1].innerHTML; document.getElementById("UpdateuReferenceID").innerHTML = x[1].innerHTML; document.getElementById("UpdatePRFReferenceNumber").value = x[1].innerHTML; } function getInfoCode(row) { var x=row.cells; var canvassCodeID = <?php echo $NewRefCode;?> +""+ Math.floor(Math.random() 888) + <?php echo $uniqueRefID;?>; document.getElementById("canvassCode").value= canvassCodeID;//<?php echo $NewRefCode;?> +""+ Math.floor(Math.random() * 888) + <?php echo $uniqueRefID;?>; showUploadForm(); } //LOAD DEALER BASED ON SELECTED COMPANY function showDealership(str) { //alert(str); if (str == "") { document.getElementById("myDealerList").innerHTML = ""; return; } else { if (window.XMLHttpRequest) { // code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp = new XMLHttpRequest(); } else { // code for IE6, IE5 xmlhttp = new ActiveXObject("Microsoft.XMLHTTP"); } xmlhttp.onreadystatechange = function() { if (xmlhttp.readyState == 4 && xmlhttp.status == 200) { document.getElementById("myDealerList").innerHTML = xmlhttp.responseText; } } xmlhttp.open("GET","PRF_LOAD_DealerBySelectedCompany.php?q="+str,true); xmlhttp.send(); } } //LOAD DEALER BASED ON SELECTED COMPANY function showCategoryItems(str) { //alert(str); if (str == "") { document.getElementById("CategorySubItem").innerHTML = ""; return; } else { if (window.XMLHttpRequest) { // code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp = new XMLHttpRequest(); } else { // code for IE6, IE5 xmlhttp = new ActiveXObject("Microsoft.XMLHTTP"); } xmlhttp.onreadystatechange = function() { if (xmlhttp.readyState == 4 && xmlhttp.status == 200) { document.getElementById("CategorySubItem").innerHTML = xmlhttp.responseText; } } xmlhttp.open("GET","PRF_LOAD_ExpenseCategoryItems.php?q="+str,true); xmlhttp.send(); } } </script>

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