File manager

File manager - Edit - /home/autoph/public_html/connect/home/exapr.php

Back
<?php include_once 'core/init.php'; $myUID = $user_data['u_id']; $prfDate = date_create() ->format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $prfDateTime=$prfDate. " ".$prfTime; $getToken=$_GET['token']; $getItemID=$_GET['id']; echo "<input type='hidden' id='myTokenomics' value='".$getToken."'>"; ?> <html> <head> <title>AUTOHUB CONNECT</title> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <link rel="icon" href="images/ahg_logo.png"> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script> <style> table{ border-collapse:collapse; width:100%; border:1px solid gray; } table{ border-collapse:collapse; } tr{ background: #fffff ; border:1px solid white; } tr:nth-child(odd){ background: #f1eef2 ; border:1px solid white; } tr:hover { background: #ffffff ; border-collapse:collapse; border:1px solid lightgray; cursor:pointer; } th{ padding:5px; font-family:Yu Gothic; color: #505055 ; font-size:12px; font-weight:normal; border:1px solid gray; text-align:left; background:#bfbfc4 ; } td{ padding:5px; font-family:Yu Gothic; color: #39393a; font-size:11px; font-weight:normal; border:1px solid white; text-align:left; } .commentBox{ height:80%;width:96%;float:left;border:1px solid lightgray;background: #fdfbee ;min-height:350px;overflow:auto;padding:5px; } .commentTypeBox{ height:auto;width:96%;float:left;border:1px solid lightgray;background: #fdfbee ;min-height:350px; ;padding:10px; } .PopForm{ width:42%; float:left; background-color:white; margin:4.98%; margin-left:27.8%; margin-top:5px; margin-bottom:5px; position:absolute; z-index:9999; border:1px solid gray; top:100px; display:none; min-height:400px; padding:10px; border-radius:10px; } .headerDiv{ width:44%; float:left; background-color:black; margin-left:28%; margin-top:5px; margin-bottom:5px; } .aConnect{ font-family:Yu Gothic; font-size: 2vw; color:white; margin:0px; padding:50px; width:30%; float:right; background:black; text-align:center; font-weight:bold; } .itemDisplay{ width:55%; float:left; background-color:#ddddde; margin:5%; margin-left:22.5%; margin-top:5px; height:auto; box-shadow:1px 1px #e6e7e7 ; border-top:3px solid #ff0000 ; border-radius:5px 5px 0px 0px; padding-bottom:10px; margin-bottom:1px solid red; } .LoadCanvassFromUser{ float:left;width:98.5%;padding:2px;height:180px;margin:5px;box-shadow: #e5e5e1 3px 3px;background:white;border:1px solid gray; } .textClass{ text-align:left;font-size:1vw;font-weight:bold;background:transparent;border:0px;width:100%; } .viewRequest{ padding:0px; background: #fc6e31; font-family:Yu Gothic; color:white; font-size:1.5vw; font-weight:normal; border:1px solid #fe5208 ; border-radius:5px; width:25%; margin-left:37.5%; margin-bottom:80px; text-align:center; } .loadcanvassuser{ font-size:1vw; padding:10px; font-family:Yu Gothic Light; text-align:left; } .divSelectedVendor{ float:left;width:100%%;padding:5px;height:120px; background:white;border:1px solid gray; } .grantText{ padding:3px;text-align:left;font-family:Yu Gothic Light;font-size:1vw;color:black; } .vendorName{ width:60%; float:left; background:white; } .vendorInfo{ width:35%; float:left; background:white; } .grantButton{ float:right;padding:5px;padding-top:10px;padding-bottom:10px;background:#000000;margin:3px;border-radius:5px;color:white;text-align:center;margin-right:3px;;width:14%;font-size:.8vw } .canvassList{ height:50%;width:100%;float:left;background:#ffffff;border:1px solid gray;padding-bottom:5px;margin-bottom:5px;min-height:250px; } .grantHeight{ height:40%;width:100%;float:left;background:#f1f3f4;border:1px solid #dadadb } .approverView{ font-family:Yu Gothic Light;font-size:1vw;color:#5f5f61; } .tableItem{ width:80%;margin-left:10% } .NoRecord{ float:left;width:90%;padding:80px;text-align:center;background:white; } .footerB{ border:0px solid white;border-bottom:1px solid lightgray;width:44%;margin-left:28%; } @media only screen and (max-width:810px){ /* For mobile phones: / .PopForm{ width:66%; float:left; background-color:white; margin:4.98%; margin-left:14.5%; margin-top:5px; margin-bottom:5px; position:absolute; z-index:9999; border:1px solid gray; top:100px; display:none; height:auto; min-height:500px; padding:10px; border-radius:10px; } .headerDiv{ width:70%; float:left; background-color:black; margin-left:15%; margin-top:5px; margin-bottom:5px; } .commentBox{ height:80%;width:96%;float:left;border:1px solid lightgray;background: #fdfbee ;min-height:350px;overflow:auto;padding:5px; } .commentTypeBox{ height:auto;width:96%;float:left;border:1px solid lightgray;background: #fdfbee ;min-height:350px; ;padding:10px; } .aConnect{ font-family:Yu Gothic; font-size: 3vw; color:white; margin:0px; width:30%; float:right; background:black; padding:20px; text-align:center; } .itemDisplay{ font-size: 2vw; width:70%; float:left; background-color: #ddddde; padding:5px; margin-left:14%; height:auto; box-shadow:1px 1px #e6e7e7 ; border-top:3px solid #ff0000 ; border-radius:5px 5px 0px 0px; padding-bottom:10px; border-bottom:1px solid #ff0000; } .textClass{ text-align:left; font-size:1.8vw; font-weight:normal; background:transparent; border:0px; width:100%; color: #060c55 ; } .viewRequest{ padding:5px; background: #fc6e31; font-family:Yu Gothic; color:white; font-size:1vw; font-weight:normal; border:1px solid #fe5208 ; border-radius:5px; width:60%; margin-top:10px; margin-left:20%; margin-bottom:30px; text-align:center; } .loadcanvassuser{ font-size:1.8vw; padding:10px; font-family:Yu Gothic Light; text-align:left; } .LoadCanvassFromUser{ float:left;width:95.5%;padding:2px;height:180px;margin:5px;background:white;border:1px solid gray; } .divSelectedVendor{ float:left;width:97.6%;padding:5px;height:140px; background:white;border:1px solid gray; } .grantText{ padding:3px;text-align:left;font-family:Yu Gothic Light;font-size:1.8vw;color:black; } .vendorName{ width:100%; float:left; background:white; } .vendorInfo{ width:100%; float:left; background:white; } .grantButton{ font-size:1vw;float:right;padding:8px;padding-top:10px;padding-bottom:10px;background:#000000;margin:5px;border-radius:5px;color:white;text-align:center;margin-right:10px;width:30%;margin-top:15px; } .canvassList{ height:45%;width:99.5%;float:left;background:#ffffff;border:1px solid gray;padding-bottom:5px;margin-bottom:5px; } .grantHeight{ height:40%;width:99.7%;float:left;background:#f1f3f4;border:1px solid #dadadb } .approverView{ font-family:Yu Gothic Light;font-size:1.8vw;color: #5f5f61 } .tableItem{ width:100%;margin-left:0% } .NoRecord{ float:left;width:80%;padding:80px;text-align:center;background:white; } .footerB{ border:0px solid white;border-bottom:1px solid lightgray;width:70%;margin-left:15%; } } @media only screen and (max-width:500px){ / For mobile phones: / .PopForm{ width:91%; float:left; background-color:white; padding:5px; margin:5px; position:absolute; z-index:9999; border:1px solid gray; top:90px; display:none; min-height:500px; border-radius:10px; } .commentBox{ height:80%;width:96%;float:left;border:1px solid lightgray;background: #fdfbee ;min-height:350px;overflow:auto;padding:5px; } .commentTypeBox{ height:auto;width:96%;float:left;border:1px solid lightgray;background: #fdfbee ;min-height:350px; ;padding:10px; } .headerDiv{ width:95%; float:left; background-color:black; padding:5px; margin:5px; } .aConnect{ font-family:Yu Gothic; font-size: 3vw; color:white; margin:0px; width:30%; float:right; background:black; padding:20px; text-align:center; } .itemDisplay{ font-size: 4vw; width:95%; float:left; background-color: #ddddde; padding:5px; margin:5px; height:auto; box-shadow:1px 1px #e6e7e7 ; border-top:3px solid #ff0000 ; border-radius:5px 5px 0px 0px; padding-bottom:10px; border-bottom:1px solid #ff0000; } .textClass{ text-align:left; font-size:3vw; font-weight:bold; background:transparent; border:0px; width:100%; color: #060c55 ; } .viewRequest{ padding:5px; background: #fc6e31; font-family:Yu Gothic; color:white; font-size:4vw; font-weight:normal; border:1px solid #fe5208 ; border-radius:5px; width:60%; margin-top:10px; margin-left:20%; margin-bottom:30px; text-align:center; } .loadcanvassuser{ font-size:3vw; padding:10px; font-family:Yu Gothic Light; text-align:left; } .LoadCanvassFromUser{ float:left;width:95.5%;padding:2px;height:180px;margin:5px;background:white;border:1px solid gray; } .divSelectedVendor{ float:left;width:97%;padding:5px;height:140px; background:white;border:1px solid gray; } .grantText{ padding:3px;text-align:left;font-family:Yu Gothic Light;font-size:3vw;color:black; } .vendorName{ width:100%; float:left; background:white; } .vendorInfo{ width:100%; float:left; background:white; } .grantButton{ font-size:2.5vw;float:right;padding:3px;padding-top:10px;padding-bottom:10px;background:#000000;margin:3px;border-radius:5px;color:white;text-align:center;margin-right:3px;width:30%;margin-top:15px; } .canvassList{ height:45%;width:99.5%;float:left;background:#ffffff;border:1px solid gray;padding-bottom:5px;margin-bottom:5px; } .grantHeight{ height:29%;width:99.7%;float:left;background:#f1f3f4;border:1px solid #dadadb } .approverView{ font-family:Yu Gothic Light;font-size:3vw;color: #5f5f61 } .tableItem{ width:100%;margin-left:0% } .NoRecord{ float:left;width:60%;padding:80px;text-align:center;background:white; } .footerB{ border:0px solid white;border-bottom:1px solid lightgray;width:98%;margin-left:1%; } } @media only screen and (max-width:428px){ / For mobile phones: / .PopForm{ width:91%; float:left; background-color:white; padding:5px; margin:5px; position:absolute; z-index:9999; border:1px solid gray; top:90px; display:none; min-height:470px; border-radius:10px; } .headerDiv{ width:95%; float:left; background-color:black; padding:5px; margin:5px; } .aConnect{ font-family:Yu Gothic; font-size: 4vw; color:white; margin:0px; width:30%; float:right; background:black; padding:20px; text-align:center; } .itemDisplay{ font-size: 4vw; width:95%; float:left; background-color: #ddddde ; padding:5px; margin:5px; height:auto; box-shadow:1px 1px #e6e7e7 ; border-top:3px solid #ff0000 ; border-radius:5px 5px 0px 0px; padding-bottom:10px; border-bottom:1px solid #ff0000; } .textClass{ text-align:left; font-size:3.5vw; font-weight:normal; background:transparent; border:0px; width:100%; color: #060c55 ; } .viewRequest{ padding:10px; background: #fc6e31; font-family:Yu Gothic; color:white; font-size:4vw; font-weight:normal; border:1px solid #fe5208 ; border-radius:5px; width:60%; margin-top:10px; margin-left:19%; margin-bottom:30px; text-align:center; } .loadcanvassuser{ font-size:3vw; padding:10px; font-family:Yu Gothic Light; text-align:left; } .LoadCanvassFromUser{ float:left;width:95.5%;padding:2px;height:180px;margin:5px;background:white;border:1px solid gray; } .divSelectedVendor{ float:left;width:97%;padding:5px;height:150px; background:white;border:1px solid gray; } .grantText{ padding:3px;text-align:left;font-family:Yu Gothic Light;font-size:3vw;color:black; } .vendorName{ width:100%; float:left; background:white; } .vendorInfo{ width:100%; float:left; background:white; padding-top:10px; padding-bottom:10px; } .grantButton{ font-size:2.5vw;float:right;padding:5px;padding-top:10px;padding-bottom:10px;background:#000000;margin:3px;border-radius:5px;color:white;text-align:center;margin-right:3px;width:24%;margin-top:10px;font-weight:bold; } .canvassList{ height:45%;width:99.5%;float:left;background:#ffffff;border:1px solid gray;padding-bottom:5px;margin-bottom:5px; } .grantHeight{ height:35%;width:99.7%;float:left;background:#f1f3f4;border:1px solid #dadadb } .approverView{ font-family:Yu Gothic Light;font-size:3vw;color: #5f5f61 } .tableItem{ width:100%;margin-left:0% } .NoRecord{ float:left;width:60%;padding:80px;text-align:center;background:white; } .footerB{ border:0px solid white;border-bottom:1px solid lightgray;width:98%;margin-left:1%; } } <!-- NEW SET OF VERTICAL MENU CSS --> </style> </head> <body> <?php $myUid= $_GET['uid']; $myCode = $_GET['code']; echo "<input type='hidden' id='MyCode' value='".$myCode."'>"; echo "<input type='hidden' id='SeletedPRFItemID'>"; echo "<input type='hidden' id='senderID' value='".$myUid."'>"; $chkAuth = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `id`='$getItemID' AND `execom_token`='$getToken'"),0); $chkLink = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_validate_links` WHERE `code`='$myCode' AND `uid`='$myUid'"),0); //Check if link is altered; if($chkLink==0){ echo "<center><p style='align:center;margin:100px;color:red;font-size:16px'>ERROR: Invalid Token. Please contact your system for assistance.</p></center>"; exit(); } //echo "count: ".$chkAuth; if($chkAuth==0){ echo "<center><p style='align:center;margin:100px;color:red;font-size:16px'>ERROR: Invalid Token. Please contact your system for assistance.</p></center>"; }else{ if($_GET['uid']==''){ echo "<center><p style='align:center;margin:100px;color:red;font-size:16px'>ERROR: Your session is not valid or recognized by the system. Please click or copy/paste the link sent to your mobile number to fix this error. Thank you!</p></center>"; exit; } $chkToken = md5(md5($getItemID)); if($chkToken==$getToken){ ?> <div class='headerDiv'> <img src='./images/ahg_logo_white.png' border='0px solid blue' style='width:40%;margin:0%;float:left'></img> <div class='aConnect'>CONNECT</div> </div> <!--#########################################################################--> <div id="loadBaraData" style="display:none;position:absolute;top:3%;left:40%;width:50px;padding:5px;padding-left:2px;padding-right:2px;height:50px;background:transparent;z-index:9999;border:0px solid gray;z-index:999999999999999999"> <div id="uploadBar" style="font-family:Calibri;font-size:14px;color:gray;text-align:center;margin-top:0px;background:white;display:block;width:100px;height:95px;border-radius:10px;position:relative;left:5px;padding:8px;z-index:999999999999999999;border:1px solid lightgray"> <img src='images/ajaxLoader2.gif' width="auto" height="auto" /><br><br><center>Please wait<center></div> </div> </div> <input type='hidden' id='uid' value='<?php echo $myUid;?>'> <!--#########################################################################--> <div id='activeExecomApproval' style='background:#fff;'> <table class='tableItem' id='LoadUserApprovedCanvassItem' > <?php $getItemHdr = mysql_query("SELECT FROM `prf_request_detl` WHERE `for_execom_canvass_approval`= 1 AND `deleted`=0 AND `awarded`='0' AND `execom_approval_ts`='' AND `execom_token`='$chkToken'"); $getItemHdrCount = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `for_execom_canvass_approval`= 1 AND `deleted`=0 AND `awarded`='0' AND `execom_token`='$chkToken'"),0); $chkIfIApproved = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_validate_links` WHERE `uid`='$myUid' AND `code`='$myCode' AND `completed`=1"),0); if($chkIfIApproved > 0){ echo "<div class='NoRecord'>-- Record no longer exists. If you think this is an error please contact procurement. --</div> "; exit(); } if($getItemHdrCount == 0){ echo "<div class='NoRecord'>-- No record found --</div> "; }else{ while($row=mysql_fetch_array($getItemHdr)){ $myPRFNumber = $row['header_ref_code']; $itmID=$row['id']; $itemSpecs = mysql_result(mysql_query("SELECT `item_specs` FROM `prf_canvass_sheet` WHERE `item_id` = '$itmID' AND `item_specs`=''"),0); $dealID=$row['dealer_id']; $dealName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='$dealID'"),0); $companyID=$row['comp_id']; $companyName =mysql_result(mysql_query("SELECT `comp_code` FROM `vts_company` WHERE `comp_id`='$companyID'"),0); $reqNameID = mysql_result(mysql_query("SELECT `request_by` FROM `prf_request_hdr` WHERE `reference_code`='".$row['header_ref_code']."'"),0); echo "<input type='hidden' id='requestorID' value='".$reqNameID."'>"; $purpose = mysql_result(mysql_query("SELECT `purpose_of_request` FROM `prf_request_hdr` WHERE `reference_code`='".$row['header_ref_code']."'"),0); $prfAttachment = mysql_result(mysql_query("SELECT `document_name` FROM `prf_attachment` WHERE `prf_number`='".$row['header_ref_code']."'"),0); $dateNeeded = mysql_result(mysql_query("SELECT `date_needed` FROM `prf_request_hdr` WHERE `reference_code`='".$row['header_ref_code']."'"),0); $catID = mysql_result(mysql_query("SELECT `category_id` FROM `prf_request_hdr` WHERE `reference_code`='".$row['header_ref_code']."'"),0); $SubcatID = mysql_result(mysql_query("SELECT `sub_category_id` FROM `prf_request_hdr` WHERE `reference_code`='".$row['header_ref_code']."'"),0); $Category = mysql_result(mysql_query("SELECT `description` FROM `prf_expensecategory` WHERE `id`='".$catID."'"),0); $ProposalCount = mysql_result(mysql_query("SELECT COUNT(id) FROM prf_canvass_sheet WHERE `item_id`='$itmID'"),0); $reqNameFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$reqNameID'"),0); $reqNameLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$reqNameID'"),0); ?><tr onClick ="javascript:getInfo(this);" ><?php echo "<td style='background:white;width:0px;font-size:1px;color:white'>".$row['id']."</id>"; echo "<td style='background:white'>"; echo "<div class='itemDisplay'>"; echo "<div style='float:left;width:100%;height:10px;font-family:Yu Gothic Light;font-size:2.5vw;color:gray;'></div>"; echo "<div style='float:left;width:21%;padding-left:10px;' class='ApproverView'>Record ID: <input disabled type='text' value='".$row['id']."' id='itemID' class='textClass'></div>"; echo "<div style='float:left;width:45%;' class='ApproverView'>Requestor: <input disabled type='text' value='".$reqNameLName. ", ".$reqNameFName."' id='requestorName' class='textClass'></div>"; echo "<div style='float:left;width:30% ' class='ApproverView'>Date Needed: <input disabled type='text' value='".$dateNeeded."' id='dateNeeded' class='textClass'></div>"; echo "<div style='margin-top:15px;margin-bottom:15px;float:left;width:96%; padding-left:10px' class='ApproverView'>Item Description: <textarea rows='4' disabled id='itemDescription' class='textClass' style='padding:5px;border:1px solid lightgray;background:white'>".$row['item_description']." ".$itemSpecs." </textarea></div>"; echo "<div style='float:left;width:30%;padding-left:10px' class='ApproverView'>Category: <input disabled type='text' value='".$Category."' id='itemCategory' class='textClass'></div>"; echo "<div style='float:left;width:26%;padding-left:10px' class='ApproverView'>Company: <input disabled type='text' value='".$companyName."' id='itemCategory' class='textClass'></div>"; echo "<div style='float:left;width:20%;' class='ApproverView'>Quantity: <input disabled type='text' value='".$row['quantity']."' id='requestorName' class='textClass'></div>"; echo "<div style='float:left;width:100%;margin-left:10px;margin-top:10px' class='ApproverView' style='padding:5px;text-align:right;margin:5px;color:blue;padding-left:15px;font-weight:bold;margin-top:10px;font-weight:bold'><u>Purpose of Request</u>:<br> <p style='font-family:Yu Gothic Light;font-size:12px;color:black;padding:3px;background:transparent;margin:2px'>".$purpose."</p>"; echo "</div>"; //(".$ProposalCount.") echo "<div style='float:left;width:100%;' class='ApproverView' style='padding:0px;margin:5px;color:blue'><br><center><u style='font-family:Yu Gothic Light;font-weight:bold;color:blue;padding:1px;background:yellow'>CLICK HERE TO VIEW PROPOSALS</u></center></div>"; echo "<div style='float:left;width:100%;height:30px;font-family:Yu Gothic Light;font-size:2vw;color:black;background;#ddddde'></div>"; echo "<div style='float:left;width:95%;height:25;font-family:Yu Gothic Light;background: #ffffff;padding:10px;margin:0px;text-align:center'>"; $checkComment = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_execomnotes` WHERE `item_id`='$itmID'"),0); if($checkComment == 0){ echo "<b style='margin:5px;text-align:center;font-family:Calibri;font-size:16px;color:black;font-weight:normal;background:yellow;'>NO COMMENT FOUND. </b>"; }else{ if($checkComment > 1){ $isMany ='S'; }else{ $isMany=''; } echo "<p style='margin:0px;padding:0px;font-size:20px;color:gray;width:100%;font-weight:bold;color:red'> ACTIVE COMMENT".$isMany."</p>"; } echo "</div>"; echo "<div style='float:left;width:95%;height:auto;font-family:Yu Gothic Light;background: #ffffff;padding:10px;margin:0px;text-align:center'>"; echo "<b style='margin:5px;text-align:center;font-family:Calibri;font-size:16px;color:black;font-weight:normal;background:yellow; '>APPROVED BY:<br></b>"; $getExecomApproval = mysql_query("SELECT * FROM `prf_execomcanvassapproval` WHERE `item_code`='$itmID'"); while($row=mysql_fetch_array($getExecomApproval)){ $aprByExecomID = $row['approved_by_execom']; $ExVendorID = $row['vendor_id']; $exVenName = mysql_result(mysql_query("SELECT `sup_name` FROM `prf_suppliers` WHERE `id`='$ExVendorID'"),0); $xFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$aprByExecomID'"),0); $xLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$aprByExecomID'"),0); echo "<p style='margin:5px;text-align:center;font-family:Calibri;font-size:12px;color:black;font-weight:normal;margin-left:0px'>". strtoupper($xFName) ." " . strtoupper($xLName) ." ( AWARDED TO: ".$exVenName.") </p>"; } echo "</div>"; if($checkComment > 0){ echo "<div id='myCommentSummary' class='commentBox' style='height:auto;margin:0px;width:97%;border:1px solid gray;background:white'>"; //echo 'myITEM'. $itmID; $getComments = mysql_query("SELECT * FROM `prf_execomnotes` WHERE `item_id`='$itmID' ORDER BY `id` DESC"); while($row=mysql_fetch_array($getComments)){ $getSender = $row['sender_id']; if($getSender == $myUID){ $color =' #047f22 '; }else{ $color ='#49584c '; } $serFName = mysql_result(mysql_query("SELECT u_fname FROM `vts_users` WHERE `u_id`='$getSender'"),0); $serLName = mysql_result(mysql_query("SELECT u_lname FROM `vts_users` WHERE `u_id`='$getSender'"),0); echo "<p style='margin:10px;padding:10px;font-family:Calibri;margin-bottom:15px;Calibri;font-size:12px;color:$color;background:#f6fff8;border1px solid #eff3f0 ;border-radius:8px;box-shadow:1px 1px lightgray'>"; echo "<b style='font-family:Calibri;font-size:10px;'> SENDER: ".$serFName. " ".$serLName."</b><br><br>"; echo $row['my_notes']."<br><br>"; echo "<i style='padding:5px;float:right;font-family:Calibri;font-size:10px'>".$row['timestamp']."</i>"; echo "<br></p>"; } echo "</div>"; } echo "</div>"; echo "</td>"; echo "<td style='background:white;width:0px;font-size:1px;color:white'>.</id>"; echo "</tr>"; // echo "<td style='background:white;width:0px;font-size:1px;color:red'>".$row['item_description']."</id>"; //echo "<tr><td colspan='2' style='text-align:center;background:white;padding:5px;padding-top:0px'> //<p class='viewRequest'>View Canvass</p></td></tr>"; } } ?> </table> </div> <div class='footerB'></div> <?php }else{ echo "<center><p style='align:center;margin:100px;color:red;font-size:16px'>ERROR: Your session is not valid or recognized by the system. Please click or copy/paste the link sent to your mobile number to fix this error. Thank you!</p></center>"; } } ?> <!--###################################################################################################################################--> <div id="noteBoxForm" class='PopForm' style='min-height:600px;height:auto;background:white;z-index:9999999;'> <div class='PopUpWindowTitle'> 🗒 COMMENT BOX: <div class='PopUpWindowClose' style='float:right;cursor:pointer'> <b onclick="javascript:hideNoteBox(this);" style='font-weight:bold'> ✕ </b> </div> </div> <div id='myCommentSummary' class='commentBox'> <?php //echo 'myITEM'. $itmID; $getComments = mysql_query("SELECT * FROM `prf_execomnotes` WHERE `item_id`='$itmID' ORDER BY `id` DESC"); while($row=mysql_fetch_array($getComments)){ $getSender = $row['sender_id']; if($getSender == $myUID){ $color =' #047f22 '; }else{ $color ='#49584c '; } $serFName = mysql_result(mysql_query("SELECT u_fname FROM `vts_users` WHERE `u_id`='$getSender'"),0); $serLName = mysql_result(mysql_query("SELECT u_lname FROM `vts_users` WHERE `u_id`='$getSender'"),0); echo "<p style='margin:10px;padding:10px;font-family:Calibri;margin-bottom:15px;Calibri;font-size:12px;color:$color;background:#f6fff8;border1px solid #eff3f0 ;border-radius:8px;box-shadow:1px 1px lightgray'>"; echo "<b style='font-family:Calibri;font-size:10px;'> SENDER: ".$serFName. " ".$serLName."</b><br><br>"; echo $row['my_notes']."<br><br>"; echo "<i style='padding:5px;float:right;font-family:Calibri;font-size:10px'>".$row['timestamp']."</i>"; echo "<br></p>"; } ?> </div> <div class='commentTypeBox'> <p style='width:100%;margin:0px;padding:2px'>TYPE YOUR COMMENT HERE:</p> <textarea id='myComment' rows="5"style='width:100%;height:70%;padding:10px;border:1px solid lightgray;'></textarea> <b style='padding-top:10px;float:left;width:100%;;font-family:Calibri;font-size:12px;'>PRF Number:</b><br> <input type='text' disabled id='myReqCompany' value='<?php echo $myPRFNumber;?>' style='width:100%;float:left;font-family:Calibri;color:gray;font-size:12px;border:0px'> <b style='padding-top:10px;float:left;width:100%;;font-family:Calibri;font-size:12px;'>Company:</b><br> <input type='text' disabled id='myReqCompany' value='<?php echo $companyName;?>' style='width:100%;float:left;font-family:Calibri;color:gray;font-size:12px;border:0px'> <b style='padding-top:10px;float:left;width:100%;;font-family:Calibri;font-size:12px;'>Requested by:</b><br> <input type='text' disabled id='myRequestedBy' value='<?php echo $reqNameLName. ", ".$reqNameFName;?>' style='width:100%;float:left;font-family:Calibri;color:gray;font-size:12px;border:0px'> <b style='padding-top:10px;float:left;width:100%;font-family:Calibri;font-size:12px;'>Purpose of Request:</b><br> <input type='text' disabled id='myPurpose' value='<?php echo $purpose;?>' style='width:100%;float:left;font-family:Calibri;color:gray;font-size:12px;border:0px'> <center><p class='grantButton' id='submitComment' style='width:25%; '>SUBMIT</p> <p class='grantButton' style='width:25%; ' onclick="javascript:hideNoteBox(this);">CLOSE</p> </center> </div> </div> <!--###################################################################################################################################--> <div id="CanvassInfoForm" class='PopForm' style='background: white '> <div id='itemCanvassList' class='canvassList' style='background:white;height:auto;overflow:auto'> </div> <div id='selectedCanvassItem' class='grantHeight' style='background:white;padding:0px'> <div class='divSelectedVendor' style='background:white;%'> <div class='vendorName'> <b style='width:100%;font-size:12px;color:red;font-family:Yu Gothic Light'>SELECTED VENDOR (Item will be awarded to this vendor):</b> <input type='hidden' id='ExecomSelectedCanvassID' class='grantText' style='width:97%;'> <div style='float:left;width:100% '> <textarea id='selectedVendor' class='grantText' style='width:100%;background: #fdf65d ;border:1px solid red'></textarea> </div> </div> <div class='vendorInfo'> <div style='float:right;width:35%;margin-left:10px;'> <b style='font-size:14px;color:red;font-family:Yu Gothic Light'>Quantity:</b> <input disabled type='text' id='selectedVendorQty' class='grantText' style='background: #fdf65d ;width:100%;text-align:center;border:1px solid red'> </div> <div style='float:left;width:55%;margin-left:10px;'> <b style='font-size:14px;color:red;font-family:Yu Gothic Light'>Amount:</b> <input disabled type='text' id='selectedVendorAmount' class='grantText' style='background: #fdf65d ;width:100%;text-align:center;border:1px solid red'> </div> </div> <div class='vendorInfo' style='font-family:calibri;font-size:12px;'> <?php $compName = mysql_result(mysql_query("SELECT `comp_name` FORM `vts_company` WHERE `comp_id`='$companyID'"),0); echo strtoupper($compName); ?> </div> </div> <p id='ExecomAwardToVendor' class='grantButton' style='width:15%'>APPROVE</p> <p id='ExecomReCanvass' class='grantButton' style='width:20%' >RE-CANVASS</p> <p id='ExecomNotes' onClick ="javascript:showNoteBox(this);" class='grantButton' style='width:15%'>COMMENT</p> <p class='grantButton' style='width:15%' onclick="javascript:hideCanvassInfo(this);">CLOSE</p> </div> <table style='width:100%'> <tr> <td class='loadcanvassuser' style='background:white;width:20%;cursor:pointer;width:10%;padding:3px;padding-left:20px'>GREEN COLOR = Recommended by End-user:<div style='width:100%;height:20px;background:#a8fc9c;border:1px solid #2dcb18'></div></td> </tr> <tr> <td class='loadcanvassuser' style='background:white;width:20%;cursor:pointer;width:10%;padding:3px;padding-left:20px;font-size:12px'> <u style='font-weight:bold;color:blue'>COMPANY:</u><?php echo $companyName. " <br> <u style='font-weight:bold;color:blue'>DEALER:</u> ".$dealName." <br> <u style='font-weight:bold;color:blue'>REQUESTED BY:</u> ".$reqNameLName.", " . $reqNameFName; ?> </td> </tr> <tr> <td class='loadcanvassuser' style='background:white;width:20%;cursor:pointer;width:10%;padding:3px;padding-left:20px;font-size:12px'> <u style='font-weight:bold;color:blue'>PURPOSE OF REQUEST:</u><br> <?php echo $purpose;?> </td> </tr> <tr> <td class='loadcanvassuser' style='background:white;width:20%;cursor:pointer;width:10%;padding:3px;padding-left:20px;font-size:12px'> <?php if($prfAttachment!=''){ echo "<a href='https://www.autohub.ph/connect/home/FILES/prfdoc/".$prfAttachment."' style='width:100%;padding:4px;color:blue;text-align:center'><u style='font-weight:bold;color:blue'>VIEW ATTACHMENT:</u></a>"; }else{ echo "<b style='width:100%;padding:4px;color:blue;text-align:center'><u style='font-weight:bold;color:blue'>NO ATTACHMENT</u></b>"; } ?> </td> </tr> </table> </div> <!--###################################################################################################################################--> <!--###################################################################################################################################--> <!--- LOCALIZED COPY OF JAVASCRIPT --> <script src="//cdn.jsdelivr.net/npm/sweetalert2@11"></script> <script src="sweetalert2.all.min.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <script type="text/javascript" src="http://code.jquery.com/jquery-1.9.1.js"></script> <script type="text/javascript"> $(document).ready(function(){ //====================================================================================================== //====================================================================================================== $("#submitComment").click(function(){ var myComment = $("#myComment").val(); var itemID = $("#SeletedPRFItemID").val(); var senderID = $("#senderID").val(); var requestorID = $("#requestorID").val(); if(myComment==''){ alert("ERROR: Please type your comment..."); return false; } //alert(senderID); //return false; ShowUploadBar(); $.ajax({ url: "prf_saveExecomComment.php", type: "POST", async: false, data: { "myComment": myComment, "senderID": senderID, "requestorID": requestorID, "itemID": itemID, "done": 1 }, success: function(d){ ShowUploadBar(); $("#myCommentSummary").html(d); $("#myComment").val(''); // hideNoteBox(); } }) }); //====================================================================================================== $("#LoadUserApprovedCanvassItem").click(function(){ var itemID = $("#SeletedPRFItemID").val(); //alert(itemID); showCanvassInfo(); //exit; ShowUploadBar(); $.ajax({ url: "prf_loadCanvassSheetWithApprovedByUser.php", type: "POST", async: false, data: { "itemID": itemID, "done": 1 }, success: function(d){ ShowUploadBar(); $("#itemCanvassList").html(d); } }) }); //====================================================================================================== //====================================================================================================== $("#ExecomReCanvass").click(function(){ var itemID = $("#SeletedPRFItemID").val(); var ExecomSelectedCanvassID = $("#ExecomSelectedCanvassID").val(); var selectedVendorAmount = $("#selectedVendorAmount").val(); var selectedVendorQty = $("#selectedVendorQty").val(); var myTokenomics = $("#myTokenomics").val(); //alert(itemID); //exit; if(confirm("CONFIRM ACTION:\nReturn to procurement, need additional proposal? Press 'OK' button to proceed...")){ ShowUploadBar(); $.ajax({ url: "prf_execomReturnToProcurement.php", type: "POST", async: false, data: { "itemID": itemID, "ExecomSelectedCanvassID": ExecomSelectedCanvassID, "selectedVendorAmount": selectedVendorAmount, "myTokenomics": myTokenomics, "selectedVendorQty": selectedVendorQty, "done": 1 }, success: function(d){ ShowUploadBar(); $("#activeExecomApproval").html(d); hideCanvassInfo(); Swal.fire({ position: 'top-end', icon: 'success', title: 'Process complete', showConfirmButton: false, timer: 1500 }) } }) } }); //====================================================================================================== //====================================================================================================== $("#ExecomAwardToVendor").click(function(){ var itemID = $("#SeletedPRFItemID").val(); var MyCode = $("#MyCode").val(); var uid = $("#uid").val(); var ExecomSelectedCanvassID = $("#ExecomSelectedCanvassID").val(); var selectedVendorAmount = $("#selectedVendorAmount").val(); var selectedVendorQty = $("#selectedVendorQty").val(); //alert(ExecomSelectedCanvassID); //return false; if(ExecomSelectedCanvassID==''){ alert("ERROR: Please select proposal to continue..."); return false; } if(selectedVendorAmount==''){ alert("ERROR: Please select proposal to continue..."); return false; } if(selectedVendorQty==''){ alert("ERROR: Please select proposal to continue..."); return false; } if(itemID==''){ alert("ERROR: Unable to detected selected record. Please contact System Admin for assistance. "); return false; } showCanvassInfo(); //alert(uid); //exit; ShowUploadBar(); $.ajax({ url: "prf_CanvassAwardToVendor.php", type: "POST", async: false, data: { "itemID": itemID, "uid": uid, "MyCode": MyCode, "ExecomSelectedCanvassID": ExecomSelectedCanvassID, "selectedVendorAmount": selectedVendorAmount, "selectedVendorQty": selectedVendorQty, "done": 1 }, success: function(d){ ShowUploadBar(); $("#ExecomSelectedCanvassID").val(''); $("#selectedVendorAmount").val(''); $("#activeExecomApproval").html(d); hideCanvassInfo(); Swal.fire({ position: 'top-end', icon: 'success', title: 'Process complete', showConfirmButton: false, timer: 1500 }) } }) }); }); </script> <script type="text/javascript"> function hideCanvassInfo(){ $("#CanvassInfoForm").fadeOut(500); }; function showCanvassInfo(){ $("#CanvassInfoForm").fadeIn(500); }; function hideNoteBox(){ $("#noteBoxForm").fadeOut(500); }; function showNoteBox(){ $("#noteBoxForm").fadeIn(500); }; function getInfo(row) { var x=row.cells; //alert('test'); // ITEM_ID rin ito document.getElementById("SeletedPRFItemID").value = x[0].innerHTML; } function ShowUploadBar() { var div = document.getElementById("loadBaraData"); if (div.style.display == 'none') { div.style.display = ''; } else { div.style.display = 'none' } } </script>

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