Advertisement
Guest User

Untitled

a guest
May 7th, 2014
201
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 6.17 KB | None | 0 0
  1. <?php
  2.    require_once '../../../dbinfo.inc.php';
  3.    session_start();
  4.    
  5.    // CHECK IF THE USER IS LOGGED ON ACCORDING
  6.    // TO THE APPLICATION AUTHENTICATION
  7.    if(!isset($_SESSION['username'])){
  8.        echo <<< EOD
  9.        <h1>You are UNAUTHORIZED !</h1>
  10.        <p>INVALID usernames/passwords<p>
  11.        <p><a href="login.php">LOGIN PAGE</a><p>
  12. EOD;
  13.        exit;
  14.    }
  15.    // GENERATE THE APPLICATION PAGE
  16.    $conn = oci_pconnect(ORA_CON_UN, ORA_CON_PW, ORA_CON_DB);
  17.    
  18.    // 1. SET THE CLIENT IDENTIFIER AFTER EVERY CALL
  19.    // 2. USING UNIQUE VALUE FOR BACK END USER
  20.    oci_set_client_identifier($conn, $_SESSION['username']);
  21.    $username = htmlentities($_SESSION['username'], ENT_QUOTES);
  22. ?>
  23.  
  24. <!DOCTYPE html>
  25. <html lang="en">
  26. <head>
  27.     <meta charset="utf-8">
  28.     <meta http-equiv="X-UA-Compatible" content="IE=edge">
  29.     <meta name="viewport" content="width=device-width, initial-scale=1">
  30.     <title>PT. WELTES ENERGI NUSANTARA | Fabrication Monitoring</title>
  31.    
  32.     <!-- Bootstrap -->
  33.     <link href="../Monitoring/css/bootstrap.min.css" rel="stylesheet">
  34.     <link href="../Monitoring/css/progress-bar.css" rel="stylesheet">
  35.     <link href="../Monitoring/css/black.css" rel="stylesheet">
  36.    
  37.     <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
  38.     <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
  39.     <!--[if lt IE 9]>
  40.       <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
  41.       <script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
  42.     <![endif]-->
  43.    
  44.     <script src="../Monitoring/js/jquery.js"></script>
  45.     <script src="../Monitoring/js/powertable.min.js"></script>
  46.     <script src="../Monitoring/js/tooltip.js"></script>
  47.     <script src="../Monitoring/js/bootstrap.min.js"></script>
  48.    
  49.     <script>
  50.          // ===================================== //
  51.     // ===================================== //
  52.        $(function(){
  53.         // SHOW RECORD
  54.         $('#headmark').change(function(){
  55.             $.post('update_fabrication_data.php',
  56.                                 {action: "show",
  57.                                  hm:$('#headmark').val()},
  58.                                  function(res){
  59.             $('#result').html(res);
  60.             });    
  61.         });
  62.                
  63.                  $('#project li a').click(function(){
  64.                         $.post('update_fabrication.php',
  65.                                 {action: "show",
  66.                                  project:$(this).text()}
  67.                                  );
  68.                 });
  69.     });
  70.     </script>
  71.    
  72.    
  73. </head>
  74. <body data-spy="scroll" data-target=".navbar">
  75. <div class="container">
  76. <nav class="navbar" role="navigation">
  77.  
  78.   <!-- Brand and toggle get grouped for better mobile display -->
  79.   <div class="navbar-header">
  80.     <button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
  81.       <span class="sr-only">Toggle navigation</span>
  82.       <span class="icon-bar"></span>
  83.       <span class="icon-bar"></span>
  84.       <span class="icon-bar"></span>
  85.     </button>
  86.         <?php
  87.             echo '<p class="navbar-text navbar-right">Hello, <a href="#" class="navbar-link">'.$username.'</a></p>';
  88.         ?>
  89.   <a class="navbar-brand glyphicon glyphicon-home toolti" data-placement="middle" title="Go to WELTES Home" href="../../../index.html"> </a>
  90.   </div>
  91.  
  92.   <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
  93.     <ul class="nav navbar-nav">
  94.        
  95.       <li class="dropdown">
  96.         <a href="#" class="dropdown-toggle" data-toggle="dropdown"><strong class="glyphicon glyphicon-align-left"></strong> <strong> &nbsp NAVIGATE</strong> <b class="caret"></b></a>
  97.         <ul class="dropdown-menu">
  98.           <li><a href="e1.html">Fabrication QC</a></li>
  99.           <li class="divider"></li>
  100.           <li><a href="e2.html">Link 1</a></li>
  101.                   <li><a href="e3.html">Link 2</a></li>
  102.           <li><a href="e4.html">Link 3</a></li>
  103.           <li><a href="e5.html">Link 4</a></li>
  104.           <li class="divider"></li>
  105.           <li><a href="../../../logout.php">SIGN OUT</a></li>
  106.         </ul>
  107.       </li>
  108.      
  109.       <li class="dropdown">
  110.         <?php        
  111.             $projectParse = oci_parse($conn, 'SELECT DISTINCT PROJECT_NAME FROM FABRICATION');
  112.             oci_execute($projectParse);
  113.  
  114.             echo '<a href="#" class="dropdown-toggle" data-toggle="dropdown"><strong class="glyphicon glyphicon-road"></strong> <strong> &nbsp PROJECT</strong> <b class="caret"></b></a>';
  115.             echo '<ul class="dropdown-menu" id="project">';
  116.  
  117.             while($row = oci_fetch_array($projectParse,OCI_ASSOC))
  118.                 {
  119.                     echo "<li><a href='#'>$row[PROJECT_NAME]</a></li>";
  120.                 }
  121.             echo '</ul>';
  122.         ?>
  123.       </li>
  124.      
  125.   </div><!-- /.navbar-collapse -->
  126. </nav>
  127.     <script>
  128.         $(function(){
  129.             $("#test").powertable({
  130.             showsize: "25",
  131.             loadmoresize: "25"
  132.             });
  133.           });
  134.     </script>
  135. <div class="well well-sm">
  136. <span class="h1 text-info">
  137. <p class="text-center">FABRICATION UPDATE</p>
  138. </span>
  139. <p class="text-center"><i>PT. WELTES ENERGI NUSANTARA | Process Division | Fabrication Update</i></p>
  140.  
  141.     <form class="form-inline" role="form">
  142.         <div class ="form-group">
  143.             <?php        
  144.                  $result = oci_parse($conn, 'SELECT DISTINCT HEAD_MARK FROM FABRICATION WHERE PROJECT_NAME = :projName');
  145.                  
  146.                  oci_bind_by_name($result, "projName", $_POST["project"]);
  147.                  oci_execute($result);
  148.                  
  149.                  echo '<label><SELECT name="headmark" id="headmark" class="form-control input-sm" placeholder="Select Project">'.'<br>';
  150.                  echo '<OPTION VALUE=" ">'."Project Select".'</OPTION>';
  151.  
  152.                  while($row = oci_fetch_array($result,OCI_ASSOC)){
  153.                  $HM = $row ['HEAD_MARK'];
  154.                  echo "<OPTION VALUE='$HM'>$HM</OPTION>";
  155.                  }
  156.                  echo '</SELECT></label><br />';
  157.              ?>
  158.         </div>
  159.     </form>
  160.  
  161.         <div id="result"></div>
  162.  
  163. <br><br><br><br>
  164. </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement