File manager

File manager - Edit - /home/autoph/public_html/portal/includes/menu/masterfile/pms_kra_department.php

Back
<?php $dealName=mysql_result(mysql_query("SELECT `name` FROM `departments` WHERE `id`='$compID'"),0); echo "<h3 class='lightGradient' style='width:99.5%;font-family:Calibri Light;font-size:16px;font-weight:normal;padding-left:5px;padding-top:2px;'>ACTIVE KEY RESULTS AREA FOR DEALERSHIP LEVEL --- <b style='font-size:16px'>".$dealName."</b></h3>"; echo "<div style='top:114px;left:97.8%;position:absolute;z-index:3'> <a href='main_new.php?view=&sview=&tab=0#id-0' style='display:block;width:17px;height:17px;border:1px solid gray;background:lightgray;border-radius:2px'> <center>X</center> </a> </div>"; echo "<div style='width:99.8%;border:0px solid gray;min-height:400px;background:#f4f4f4'>"; ?> <div class='lightGradientA' style='width:98.5%;height:40px;border:1px solid lightgray;padding-left:20px;padding-top:3px'> <a href='main_new.php?view=106&sview=100&sid=PT1&action=new&tab=2#id-0'><ABBR title='Add New Record'><img src='./images/new.png' onmouseover="this.src='images/new_.png';" onmouseout="this.src='images/new.png';" /></ABBR></a> <a href='main_new.php?view=106&sview=721&sid=ADV&action=edit&tab=0#id-0'><ABBR title='Advance Search Module'><img src='./images/filter_a.png' onmouseover="this.src='images/filter_b.png';" onmouseout="this.src='images/filter_a.png';" /></ABBR></a> <div class='lightGradientA' style='margin-top:5px;position:relative;height:30px;width:500px;border:1px solid #f2f2f;top:-40px;left:100px;padding-top:4px;border-left:1px solid lightgray;padding-left:30px'> <form action='' method='GET'> <input type='hidden' name='view' value='106'> <input type='hidden' name='sview' value='100'> <input type='hidden' name='tab' value='2'> <input type='hidden' name='sid' value='PT1'> Search : <input type='text' name='searchBox' value='' style='padding-left:10px;width:300px;border:1px solid gray;background:white;height:30px;border-radius:5px 0px 0px 5px'> <input type='submit' name='goSearch' value='Search' style='width:70px;border:1px solid gray;height:30px;border-radius:0px 5px 5px 0px'> </form> </div> <!--<div align='left' style='top:137px;left:53%;height:30px;width:200px;float:left;position:absolute;border:0px solid red'> <ABBR title='Edit Record'><img src='./images/advancesearch_a.png' onmouseover="this.src='images/advancesearch_b.png';" onmouseout="this.src='images/advancesearch_a.png';" /></ABBR></a> </div>--> </div> <div class='contentTable'> <?php if(isset($_GET['searchBox'])){ $searchString=$_GET['searchBox']; $qq=mysql_query("SELECT * FROM `kras` WHERE `status`='1' AND `tag`='DEPT' AND `deal_id`='$dealID' AND `kra` LIKE '%$searchString%' ORDER by `kra` ASC "); }else{ $qq=mysql_query("SELECT * FROM `kras` WHERE `status`='1' AND `tag`='DEPT' AND `deal_id`='$dealID' ORDER by `kra` ASC "); } echo "<div STYLE='height: 490px; width: 100%; font-size: 12px; overflow: auto;'> <table style='width:100%; height:100% border:1px solid gray; border-collapse:collapse;'>"; echo "<tr> <th class='Gradient' align='center' style='width:2%;background:#f5f5f5;border:1px solid lightgray;font-size:12px'></th> <th class='Gradient' align='center' style='width:2%;background:#f5f5f5;border:1px solid lightgray;font-size:12px'></th> <th class='Gradient' align='center' style='width:2%;background:#f5f5f5;border:1px solid lightgray;font-size:12px'></th> <th class='Gradient' align='left' style='padding-left:5px;width:60%;background:#f5f5f5;border:1px solid lightgray;font-size:12px'>KEY RESULTS AREA</th> <th class='Gradient' align='left' style='padding-left:5px;width:5%;background:#f5f5f5;border:1px solid lightgray;font-size:12px'>COMPANY</th> <th class='Gradient' align='left' style='padding-left:5px;width:5%;background:#f5f5f5;border:1px solid lightgray;font-size:12px'>DEALERSHIP</th> <th class='Gradient' align='left' style='padding-left:5px;width:5%;background:#f5f5f5;border:1px solid lightgray;font-size:12px'>DEPARTMENT</th> <th class='Gradient' align='left' style='padding-left:5px;width:5%;background:#f5f5f5;border:1px solid lightgray;font-size:12px'>WEIGHT</th> <th class='Gradient' align='left' style='padding-left:5px;width:5%;background:#f5f5f5;border:1px solid lightgray;font-size:12px'>ACTIVE KPI</th> <th class='Gradient' align='left' style='width:10%;background:#f5f5f5;border:1px solid lightgray;font-size:12px'>STATUS</th>"; echo "</tr>"; while($row = mysql_fetch_array($qq)){ echo "<tr>"; echo "<td class='tableList' align='center'> <ABBR title='Delete Record'><a href='main_new.php?id=".$row['id']."&view=106&sview=100&sid=PT1&action=edit&tab=2#id-0'> <img src='images/rica/delete_b.png'></img></a></ABBR> </td>"; echo "<td class='tableList'> <ABBR title='Edit Record'><a href='main_new.php?id=".$row['id']."&view=106&sview=100&sid=PT1&action=edit&tab=2#id-0'> <img src='images/rica/edit_a.png'></img></a> </td>"; echo "<td class='tableList'> <ABBR title='Add/Edit Key Performance Indicator (KPI)'><a href='main_new.php?id=".$row['id']."&dID=".$row['deal_id']."&cID=".$row['comp_id']."&deptID=".$row['dept_id']."&view=106&sview=100&sid=PT1&action=kpi&tab=2#id-0'> <img src='images/rica/kpi.png'></img></a></ABBR> </td>"; echo "<td class='tableList'>" . STRTOUPPER($row['kra']) . "</td>"; echo "<td class='tableList'>" . STRTOUPPER($row['comp_code']) . "</td>"; echo "<td class='tableList'>" . STRTOUPPER($row['deal_code']) . "</td>"; echo "<td class='tableList'>" . STRTOUPPER($row['dept_code']) . "</td>"; echo "<td class='tableList'>" . STRTOUPPER($row['kra_weight']) . "</td>"; echo "<td class='tableList' align='center'>"; $deptID = $row['dept_id']; $kraID = $row['id']; $kpiCount = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `kpi_list` WHERE `dept_id`='$deptID' AND `kra_id`='$kraID'"),0); echo "<center><ABBR title='Add/Edit Key Performance Indicator (KPI)'><a href='main_new.php?id=".$row['id']."&view=106&sview=100&sid=PT1&action=kpi&tab=2#id-0'> ".$kpiCount."</a></ABBR></center>"; echo "</td>"; echo "<td class='tableList'>"; $stat = $row['status']; if($stat == 1){ echo 'ACTIVE'; }else { echo 'INACTIVE'; } echo "</td>"; echo "</tr>"; } echo "</table>"; ?> </div> <?php echo "</div>"; ?>

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