Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- error_reporting(0);
- session_start();
- include '../config.php';
- $id = $_GET['id'];
- if(!isset($id))
- {
- $id = "";
- $get = mysql_query("select * from pos_unit");
- }else{
- $id = $_GET['id'];
- $get = mysql_query("select * from pos_unit where pos_unit_id = $id");
- }
- $_SESSION['id'] = $id;
- $query = mysql_query("select * from pos_unit where pos_unit_name like '%Director%'and item_type = 0") or die (mysql_error());
- $queryname = mysql_query("select * from pos_unit where pos_unit_id = '$id'");
- $fetchname = mysql_fetch_array($queryname);
- $posname = $fetchname['pos_unit_name'];
- $query1 = mysql_query("select * from checklist where check_ok = '$posname' and check_status = 0");
- $num = mysql_query("select * from checklist where check_status = 0 group by check_code") or die (mysql_error());
- $numrow = mysql_num_rows($num);
- $num1 = mysql_query("select * from checklist where check_status = 2 group by check_code") or die (mysql_error());
- $numrow1 = mysql_num_rows($num1);
- if($numrow == 0)
- {
- $class = "";
- }else
- {
- $class = "<span class='alert_notify blue'>".$numrow."</span>";
- }
- if($numrow1 == 0)
- {
- $class2 = '';
- }else{
- $class2 = "<li><a href='./dirrevkpi.php' ><span class='stats_icon administrative_docs_sl'><span class='alert_notify orange'>".$numrow1."</span></span><span class='label'>KPI Review</span></a></li>";
- }
- ?>
- <!DOCTYPE HTML>
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
- <meta name="viewport" content="width=device-width"/>
- <title>Performance Management System</title>
- <link href="../css/reset.css" rel="stylesheet" type="text/css" media="screen">
- <link href="../css/layout.css" rel="stylesheet" type="text/css" media="screen">
- <link href="../css/themes.css" rel="stylesheet" type="text/css" media="screen">
- <link href="../css/typography.css" rel="stylesheet" type="text/css" media="screen">
- <link href="../css/styles.css" rel="stylesheet" type="text/css" media="screen">
- <link href="../css/shCore.css" rel="stylesheet" type="text/css" media="screen">
- <link href="../css/bootstrap.css" rel="stylesheet" type="text/css" media="screen">
- <link href="../css/jquery.jqplot.css" rel="stylesheet" type="text/css" media="screen">
- <link href="../css/jquery-ui-1.8.18.custom.css" rel="stylesheet" type="text/css" media="screen">
- <link href="../css/data-table.css" rel="stylesheet" type="text/css" media="screen">
- <link href="../css/form.css" rel="stylesheet" type="text/css" media="screen">
- <link href="../css/ui-elements.css" rel="stylesheet" type="text/css" media="screen">
- <link href="../css/wizard.css" rel="stylesheet" type="text/css" media="screen">
- <link href="../css/sprite.css" rel="stylesheet" type="text/css" media="screen">
- <link href="../css/gradient.css" rel="stylesheet" type="text/css" media="screen">
- <link href='http://fonts.googleapis.com/css?family=Droid+Sans' rel='stylesheet' type='text/css'>
- <!--[if IE 7]>
- <link rel="stylesheet" type="text/css" href="css/ie/ie7.css" />
- <![endif]-->
- <!--[if IE 8]>
- <link rel="stylesheet" type="text/css" href="css/ie/ie8.css" />
- <![endif]-->
- <!--[if IE 9]>
- <link rel="stylesheet" type="text/css" href="css/ie/ie9.css" />
- <![endif]-->
- <!-- Jquery -->
- <script src="../js/jquery-1.7.1.min.js"></script>
- <script src="../js/jquery-ui-1.8.18.custom.min.js"></script>
- <script src="../js/jquery.ui.touch-punch.js"></script>
- <script src="../js/chosen.jquery.js"></script>
- <script src="../js/uniform.jquery.js"></script>
- <script src="../js/bootstrap-dropdown.js"></script>
- <script src="../js/bootstrap-colorpicker.js"></script>
- <script src="../js/sticky.full.js"></script>
- <script src="../js/jquery.noty.js"></script>
- <script src="../js/selectToUISlider.jQuery.js"></script>
- <script src="../js/fg.menu.js"></script>
- <script src="../js/jquery.tagsinput.js"></script>
- <script src="../js/jquery.cleditor.js"></script>
- <script src="../js/jquery.tipsy.js"></script>
- <script src="../js/jquery.peity.js"></script>
- <script src="../js/jquery.simplemodal.js"></script>
- <script src="../js/jquery.jBreadCrumb.1.1.js"></script>
- <script src="../js/jquery.colorbox-min.js"></script>
- <script src="../js/jquery.idTabs.min.js"></script>
- <script src="../js/jquery.multiFieldExtender.min.js"></script>
- <script src="../js/jquery.confirm.js"></script>
- <script src="../js/elfinder.min.js"></script>
- <script src="../js/accordion.jquery.js"></script>
- <script src="../js/autogrow.jquery.js"></script>
- <script src="../js/check-all.jquery.js"></script>
- <script src="../js/data-table.jquery.js"></script>
- <script src="../js/ZeroClipboard.js"></script>
- <script src="../js/TableTools.min.js"></script>
- <script src="../js/jeditable.jquery.js"></script>
- <script src="../js/duallist.jquery.js"></script>
- <script src="../js/easing.jquery.js"></script>
- <script src="../js/full-calendar.jquery.js"></script>
- <script src="../js/input-limiter.jquery.js"></script>
- <script src="../js/inputmask.jquery.js"></script>
- <script src="../js/iphone-style-checkbox.jquery.js"></script>
- <script src="../js/meta-data.jquery.js"></script>
- <script src="../js/quicksand.jquery.js"></script>
- <script src="../js/raty.jquery.js"></script>
- <script src="../js/smart-wizard.jquery.js"></script>
- <script src="../js/stepy.jquery.js"></script>
- <script src="../js/treeview.jquery.js"></script>
- <script src="../js/ui-accordion.jquery.js"></script>
- <script src="../js/vaidation.jquery.js"></script>
- <script src="../js/mosaic.1.0.1.min.js"></script>
- <script src="../js/jquery.collapse.js"></script>
- <script src="../js/jquery.cookie.js"></script>
- <script src="../js/jquery.autocomplete.min.js"></script>
- <script src="../js/localdata.js"></script>
- <script src="../js/excanvas.min.js"></script>
- <script src="../js/jquery.jqplot.min.js"></script>
- <script src="../js/chart-plugins/jqplot.dateAxisRenderer.min.js"></script>
- <script src="../js/chart-plugins/jqplot.cursor.min.js"></script>
- <script src="../js/chart-plugins/jqplot.logAxisRenderer.min.js"></script>
- <script src="../js/chart-plugins/jqplot.canvasTextRenderer.min.js"></script>
- <script src="../js/chart-plugins/jqplot.canvasAxisTickRenderer.min.js"></script>
- <script src="../js/chart-plugins/jqplot.highlighter.min.js"></script>
- <script src="../js/chart-plugins/jqplot.pieRenderer.min.js"></script>
- <script src="../js/chart-plugins/jqplot.barRenderer.min.js"></script>
- <script src="../js/chart-plugins/jqplot.categoryAxisRenderer.min.js"></script>
- <script src="../js/chart-plugins/jqplot.pointLabels.min.js"></script>
- <script src="../js/chart-plugins/jqplot.meterGaugeRenderer.min.js"></script>
- <script src="../js/custom-scripts.js"></script>
- <script src="../js/dataTables.fnGetHiddenNodes.js"></script>
- <script src="../js/dataTables.fnGetFilteredNodes.js"></script>
- <script>
- function confirmDelete() {
- var question = confirm("Are you sure want to delete?");
- if(question){
- return true;
- }else{
- return false;
- }
- }
- </script>
- <script>
- $(function(){
- $("[name=selectpos]").change(function(){
- var val = $(this).val();
- var year;
- if (typeof val !== 'undefined') {
- year = val;
- }
- else {
- year = '';
- }
- window.location.href = './dirkpiapp.php?id='+year;
- return true;
- });
- });
- </script>
- <script>
- function changeFormAction(url)
- {
- document.getElementById('form1').action = url;
- document.getElementById('form1').submit();
- }
- </script>
- <script>
- $(document).ready(function () {
- oTable = $('#action_tbl').dataTable();
- } );
- $('form[name=form1]').submit(function(){
- $(oTable.fnGetHiddenNodes()).find('input:checked').appendTo(this);
- } );
- $('.checkall').click( function() {
- $('input', oTable.fnGetFilteredNodes()).attr('checked',this.checked);
- } );
- </script>
- </head>
- <body id="theme-default" class="full_block">
- <div id="container">
- <div id="header" class="blue_lin">
- <div style="padding-top:10px; padding-left:20px; float:left;">
- <h1 style="margin:0px;">PT *******</h1>
- </div>
- <div class="header_right">
- <div id="user_nav">
- <ul>
- <li class="user_thumb"><a href="#"><span class="icon"><img src="../images/user_thumb.png" width="30" height="30" alt="User"></span></a></li>
- <li class="user_info"><span class="user_name">Administrator</span><span><a href="#">Profile</a> | <a href="#">Settings</a> | <a href="#">Help?</a></span></li>
- <li class="logout"><a href="#"><span class="icon"></span>Logout</a></li>
- </ul>
- </div>
- </div>
- </div>
- <div class="page_title gray_sai">
- <span class="title_icon"><span class="pp"></span></span>
- <a href="dirkpiapp.php"><h3>Performance Planning</h3></a>
- </div>
- <div style="margin-left:1%; margin-bottom:-4.5%; margin-top:2.5%;">
- <select name="selectpos" style="width:200px;" class="chzn-select" data-placeholder="Select Director">
- <option value=""></option>
- <?php while($ee = mysql_fetch_array($query))
- {
- ?>
- <option value="<?php echo $ee['pos_unit_id'] ?>"<?php if($id == $ee['pos_unit_id']) echo "selected" ?>><?php echo $ee['pos_unit_name']; ?></option>
- <?php
- } ?>
- </select>
- </div>
- <div class="switch_bar">
- <ul>
- <li><a href="../dashboard.php"><span class="stats_icon home_sl"></span><span class="label">Home</span></a></li>
- <li><a href="./directorate.php"><span class="stats_icon hire_me_sl"></span><span class="label">KPI</span></a></li>
- <li><a href="./assigndirkpi.php"><span class="stats_icon customers_sl"></span><span class="label">Assign KPI</span></a></li>
- <li><a href="./dirdashboard.php"><span class="stats_icon order_sl"></span><span class="label">Dashboard</span></a></li>
- <li><a href="./dirchecklistkpi.php"><span class="stats_icon issue_sl"></span><span class="label">Checklist KPI</span></a></li>
- <li><a href="./dirtodiv.php"><span class="stats_icon my_account_sl"></span><span class="label">Cascading</span></a></li>
- <li><a href="./dirkpiapp.php" style="background:#21A2EB; color: #FFFFFF;"><span class="stats_icon check_sl"></span><span class="label">KPI Approval</span></a></li>
- <?php echo $class2; ?>
- </ul>
- </div>
- <div id="content" style="margin-left:0;">
- <div class="grid_container">
- <div class="grid_12 full_block">
- <form id="form1" action="#" method="post" name="form1">
- <div class="widget_wrap">
- <div class="widget_top">
- <span class="h_icon blocks_images"></span>
- <?php $gget = mysql_fetch_array($get) ?>
- <h6><?php if($id == ""){
- echo "Directorate";
- } else {
- echo $gget['pos_unit_name'];
- } ?> Approval KPI</h6>
- </div>
- <div class="widget_content">
- <table <?php if($id == ""){
- echo "style='display:none;'";
- } else {
- echo "";
- } ?> class="display" id="action_tbl">
- <thead>
- <tr>
- <th rowspan="2" class="center">
- <input name="checkall" type="checkbox" value="<?php while($b = mysql_fetch_array($query1))
- {
- $kpiid = $b['check_id']." ";
- echo $kpiid;
- } ?>" class="checkall">
- </th>
- <th rowspan="2">
- No.
- </th>
- <th rowspan="2">
- Perspective
- </th>
- <th rowspan="2">
- Strategic Objectives
- </th>
- <th rowspan="2">
- KPI Code
- </th>
- <th rowspan="2">
- KPI
- </th>
- <th rowspan="2">
- Unit
- </th>
- <th rowspan="2">
- KPI Type
- </th>
- <th colspan="2">
- <?php if($id == ""){
- echo "Directorate";
- } else {
- echo $gget['pos_unit_name'];
- } ?>
- </th>
- <th rowspan="2">
- Responsible Person<br>for Input
- </th>
- <th rowspan="2">
- Responsible Person<br>for Evaluation
- </th>
- </tr>
- <tr>
- <th>Weight</th>
- <th>Target</th>
- </tr>
- </thead>
- <tbody>
- <?php
- $query2 = mysql_query("select pos_unit_name from pos_unit where pos_unit_id = '$id'");
- $exq2 = mysql_fetch_array($query2);
- $posunitname = mysql_real_escape_string($exq2['pos_unit_name']);
- $query1 = mysql_query("select * from checklist where check_pos = '$posunitname' and check_status = '0'");
- $i = 0;
- while($a = mysql_fetch_array($query1))
- {
- $code = $a['check_code'];
- $weight = $a['check_weight_step_2'];
- $query4 = mysql_query("select sum(check_weight_step_2) from checklist where check_ok = '$posunitname'") or die (mysql_error());
- $exq4 = mysql_fetch_array($query4);
- $sum2 = round($exq4[0],2);
- $sum = ($weight / $sum2) * 100;
- $sum = round($sum,2);
- $query3 = mysql_query("select * from corporate_kpi where kpi_code = '$code'");
- $exq3 = mysql_fetch_array($query3);
- $pers = $exq3['kpi_persp'];
- $strtg = $exq3['kpi_strat'];
- $name = $exq3['kpi_name'];
- $targ = $exq3['kpi_target'];
- $unit = $exq3['kpi_unit'];
- $type = $exq3['kpi_type'];
- ?>
- <tr class="gradeA" style="font-size:11px;">
- <td class="center tr_select ">
- <input name="checkbox[]" type="checkbox" value="<?php echo $a['check_id']; ?>">
- </td>
- <td>
- <?php
- $i++;
- echo $i; ?>.
- </td>
- <td>
- <?php echo $pers; ?>
- </td>
- <td>
- <?php echo $strtg; ?>
- </td>
- <td>
- <input type="hidden" name="code[]" value="<?php echo $code ?>">
- <?php echo $code; ?>
- </td>
- <td>
- <?php echo $name; ?>
- </td>
- <td>
- <?php echo $unit; ?>
- </td>
- <td>
- <?php echo $type; ?>
- </td>
- <td class="center"><?php echo $sum."%"; ?></td>
- <td class="center"><?php if($unit == '%') {$unit = $unit; } else {$unit = "";} echo $targ.$unit; ?></td>
- <td>
- </td>
- <td>
- </td>
- </tr>
- <?php } ?>
- </tbody>
- <tfoot>
- <tr>
- <th></th>
- <th>
- </th>
- <th>
- </th>
- <th>
- </th>
- <th>
- </th>
- <th>
- </th>
- <th>
- </th>
- <th>
- </th>
- <th>
- <?php $query5 = mysql_query("select * from checklist where check_ok = '$posunitname' and check_status = '0'");
- $total = 0;
- while ($exq5 = mysql_fetch_array($query5))
- {
- $weight2 = $exq5['check_weight_step_2'];
- $querysum = mysql_query("select sum(check_weight_step_2) from checklist where check_ok = '$posunitname' and check_status = '0'") or die (mysql_error());
- $fetchsum = mysql_fetch_array($querysum);
- $summ = round($fetchsum[0],2);
- $sum3 = ($weight2/$summ) * 100;
- $sum3 = round($sum3,2);
- $total += $sum3;
- $total = round($total,2);
- }
- $total."%";
- ?>
- </th>
- <th></th>
- <th></th>
- <th></th>
- </tr>
- </tfoot>
- </table>
- <input style="float:right; margin-top:5px;" onclick="changeFormAction('./appdirkpi.php')" type="submit" name="app" value="Approve" class="btn_small btn_blue">
- </div>
- </div>
- </form>
- </div>
- <span class="clear"></span>
- </div>
- <span class="clear"></span>
- </div>
- </div>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement