File manager

File manager - Edit - /home/autoph/public_html/portal/includes/pms_editdepartmentKRA.php

Back
<html> <head> <title>THE AUTOHUB GROUP</title> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" href="css/screen_white.css"> <link rel="stylesheet" href="ajs/vendors/jQueryUI/jquery-ui.css"> <script src="ajs/vendors/jQueryUI/jquery-1.12.4.js"></script> <script src="ajs/vendors/jQueryUI/jquery-ui.js"></script> </head> <script type="text/javascript" charset="utf-8"> $( function() { var userName = <?php $d = mysql_query( "SELECT * FROM `kras` WHERE `tag`='DEAL' AND `deal_code`='$dealCode' ORDER BY `kra` ASC" ); $usernames = array(); while( $r = mysql_fetch_assoc($d) ) { $usernames[] = $r['kra'].'---'.$r['id']; } echo json_encode( $usernames ); ?>; $( "#dealKRAList" ).autocomplete({ source: userName }); } ); </script> <?php $kraID =$_GET['id']; $dealerID = mysql_result(mysql_query("SELECT `deal_id` FROM `kras` WHERE `id`='$kraID'"),0); $dealerKRAID = mysql_result(mysql_query("SELECT `kra_deal_id` FROM `kras` WHERE `id`='$kraID'"),0); $deptID = mysql_result(mysql_query("SELECT `dept_id` FROM `kras` WHERE `id`='$kraID'"),0); $deptName = mysql_result(mysql_query("SELECT `name` FROM `departments` WHERE `id`='$deptID'"),0); $dealerCode = mysql_result(mysql_query("SELECT `deal_code` FROM `kras` WHERE `id`='$kraID'"),0); $dealName = mysql_result(mysql_query("SELECT `name` FROM `dealers` WHERE `dcode`='$dealerCode'"),0); $dealerKRAID = mysql_result(mysql_query("SELECT `kra_deal_id` FROM `kras` WHERE `id`='$kraID'"),0); $kraNameDealer = mysql_result(mysql_query("SELECT `kra` FROM `kras` WHERE `id`='$dealerKRAID'"),0); $kraNameDept = mysql_result(mysql_query("SELECT `kra` FROM `kras` WHERE `id`='$kraID'"),0); $kraWeight = mysql_result(mysql_query("SELECT `kra_weight` FROM `kras` WHERE `id`='$kraID'"),0); if(isset($_POST['SaveRecord'])){ $kraID =$_GET['id']; $kraDepartment = $_POST['kraDepartment']; $exKRADept = explode('---',$kraDepartment); $myDeptID = $exKRADept[1]; $myDeptCode = mysql_result(mysql_query("SELECT `code` FROM `departments` WHERE `id`='$myDeptID'"),0); echo "MY DEPT ID IS ".$myDeptID; $kraDealer = $_POST['kraDealer']; $exKRADeal = explode('---',$kraDealer); $kraDealCode = $exKRADeal[1]; $myDealID = mysql_result(mysql_query("SELECT `id` FROM `dealers` WHERE `dcode`='$kraDealCode'"),0); $myCompCode = mysql_result(mysql_query("SELECT `ccode` FROM `dealers` WHERE `dcode`='$kraDealCode'"),0); $myCompID = mysql_result(mysql_query("SELECT `id` FROM `company` WHERE `code`='$myCompCode'"),0); $kraDealKRA = $_POST['kraDealKRA']; $exKRADealer = explode('---',$kraDealKRA); $dealerKRAID = $exKRADealer[1]; $kraDeptDesc = $_POST['kraDeptDesc']; $kraEditWeight = $_POST['kraEditWeight']; $kraDeptDesc = mysql_real_escape_string($kraDeptDesc); mysql_query("UPDATE `kras` SET `comp_id`='$myCompID',`deal_id`='$myDealID',`dept_id`='$myDeptID',`deal_code`='$kraDealCode',`comp_code`='$myCompCode',`dept_code`='$myDeptCode',`kra`='$kraDeptDesc',`kra_weight`='$kraEditWeight', `tag`='DEPT',`kra_deal_id`='$dealerKRAID' WHERE `id`='$kraID'"); echo "<div class='ContinueMSG'>"; echo " <h3 class='lightGradient' style='width:99%;font-family:Calibri Light;font-size:18px;font-weight:bold;padding-left:5px;padding-top:2px;'>NEW RECORD SAVED...</h3>"; echo "<div style='top:3px;left:95.5%;position:absolute;z-index:3;background:transparent'> <a href='main_new.php?view=106&sid=PT1&sview=100&tab=2#id-0' > <center>X</center> </a> </div>"; echo " <br><br><h2 style='margin-top:2px;text-align:center;width:100%;font-family:Calibri Light;font-size:16px;font-weight:normal'>NEW DEPARTMENT CREATED...</h2> <p style='font-family:Calibri Light;font-size:14px;color:#0B610B;font-weight:bold;padding-top:0px'> <br><br> <center><a href='main_new.php?view=106&sid=PT1&sview=100&tab=2#id-0' ><input type='button' class='button' value='CLOSE' style='width:80px;'></a></center> </a> </p>"; echo "</div>"; } ?> <body> <center> <div style='width:98%;border:1px solid #E6E6E6;height:310px;padding:5px'> <form action='' method='POST'> <table style='width:100%;border:1px solid white'> <tr style='background:white;border:1px solid white'> <td valign='top' style='background:white;border:1px solid white;border-right:1px solid white;width:50%'> <div align='left' class="form-group" style='width:100%;padding:10px;font-size:12px;color:black;font-weight:normal'> SELECT DEPARTMENT:<BR> <ABBR title='SELECT DEALERSHIP'> <input REQUIRED id='deptList' class='textbox' value='<?php echo $deptName .'---'.$deptID;?>' type="text" value='' placeholder="" name="kraDepartment" style='background:white;width:100%;margin-top:5px;font-size:14px;font-weight:bold'> </ABBR> </div> </td> <td valign='top' style='background:white;border:1px solid white;border-right:1px solid white;width:50%'> <div align='left' class="form-group" style='width:100%;padding:10px;font-size:12px;color:black;font-weight:normal'> SELECT DEALERSHIP:<BR> <ABBR title='SELECT DEALERSHIP'> <input REQUIRED id='dealList' class='textbox' value='<?php echo $dealName .'---'.$dealerCode;?>' type="text" value='' placeholder="" name="kraDealer" style='background:white;width:100%;margin-top:5px;font-size:14px;font-weight:bold'> </div> </td> <tr style='background:white;border:1px solid white'> <td colspan='2' valign='top' style='background:white;border:1px solid white;border-right:1px solid white;width:100%'> <div align='left' class="form-group" style='padding:10px;font-size:12px;color:black;font-weight:normal;border:1px solid white'> DEALERSHIPS KRA:<BR> <ABBR title='SELECT/TYPE DEALERSHIPS KRA'> <input REQUIRED id='dealKRAList' class='textbox' type="text" value='<?php echo $kraNameDealer.'---'.$dealerKRAID;?>' placeholder="" name="kraDealKRA" style='background:white;width:100%;margin-top:5px;font-size:14px;font-weight:bold'> </ABBR> </div> </td> </tr> <tr style='background:white;border:1px solid white'> <td colspan='2' valign='top' style='background:white;border:1px solid white;border-right:1px solid white;width:100%'> <div align='left' class="form-group" style='padding:10px;font-size:12px;color:black;font-weight:normal;border:1px solid white'> DEPARTMENT KRA:<br> <ABBR title='DEALERS KRA should have a matching record or entry under the Company KRA'> <input REQUIRED class='textbox' type="text" value='<?php echo $kraNameDept;?>' placeholder="" name="kraDeptDesc" style='background:white;width:100%;margin-top:5px;font-size:14px;font-weight:bold'></ABBR> </div> </td> </tr> <tr style='background:white;border:1px solid white'> <td colspan='2' valign='top' style='background:white;border:1px solid white;border-right:1px solid white;width:100%'> <div align='left' class="form-group" style='padding:10px;font-size:12px;color:black;font-weight:normal'> WEIGHT ALLOCATION: <BR> <p style='text-align:bottom;line-height:80%;font-family:Calibri Light;font-size:12px;padding-left:0px;color:gray;font-weight:normal'> <ABBR title='KRA WEIGHT ALLOCATION'> <input REQUIRED class='textbox' type="text" value='<?php echo $kraWeight;?>' placeholder="WEIGHT" name="kraEditWeight" style='background:white;width:25%;margin-top:5px;font-size:14px;font-weight:bold'></ABBR> </p> </div> </td> </tr> </table> <div align='right' class="form-group" style='padding:10px'> <input type='submit' class='submit' name='SaveRecord' value='SAVE RECORD'> <a href='main_new.php?view=106&sid=PT1&sview=100&tab=2#id-0'><input type='button' class='submit' name='Exit' value='EXIT' style='width:100px;'></a> </div> </form> </div> </center> </body> </html>

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