Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require_once '../../../dbinfo.inc.php';
- session_start();
- // CHECK IF THE USER IS LOGGED ON ACCORDING
- // TO THE APPLICATION AUTHENTICATION
- if(!isset($_SESSION['username'])){
- echo <<< EOD
- <h1>You are UNAUTHORIZED !</h1>
- <p>INVALID usernames/passwords<p>
- <p><a href="login.php">LOGIN PAGE</a><p>
- EOD;
- exit;
- }
- // GENERATE THE APPLICATION PAGE
- $conn = oci_pconnect(ORA_CON_UN, ORA_CON_PW, ORA_CON_DB);
- // 1. SET THE CLIENT IDENTIFIER AFTER EVERY CALL
- // 2. USING UNIQUE VALUE FOR BACK END USER
- oci_set_client_identifier($conn, $_SESSION['username']);
- $username = htmlentities($_SESSION['username'], ENT_QUOTES);
- ?>
- <!DOCTYPE html>
- <html lang="en">
- <head>
- <meta charset="utf-8">
- <meta http-equiv="X-UA-Compatible" content="IE=edge">
- <meta name="viewport" content="width=device-width, initial-scale=1">
- <title>PT. WELTES ENERGI NUSANTARA | Fabrication Monitoring</title>
- <!-- Bootstrap -->
- <link href="../Monitoring/css/bootstrap.min.css" rel="stylesheet">
- <link href="../Monitoring/css/progress-bar.css" rel="stylesheet">
- <link href="../Monitoring/css/black.css" rel="stylesheet">
- <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
- <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
- <!--[if lt IE 9]>
- <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
- <script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
- <![endif]-->
- <script src="../Monitoring/js/jquery.js"></script>
- <script src="../Monitoring/js/powertable.min.js"></script>
- <script src="../Monitoring/js/tooltip.js"></script>
- <script src="../Monitoring/js/bootstrap.min.js"></script>
- <script>
- // ===================================== //
- // ===================================== //
- $(function(){
- // SHOW RECORD
- $('#headmark').change(function(){
- $.post('update_fabrication_data.php',
- {action: "show",
- hm:$('#headmark').val()},
- function(res){
- $('#result').html(res);
- });
- });
- $('#project li a').click(function(){
- $.post('update_fabrication.php',
- {action: "show",
- project:$(this).text()}
- );
- });
- });
- </script>
- </head>
- <body data-spy="scroll" data-target=".navbar">
- <div class="container">
- <nav class="navbar" role="navigation">
- <!-- Brand and toggle get grouped for better mobile display -->
- <div class="navbar-header">
- <button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
- <span class="sr-only">Toggle navigation</span>
- <span class="icon-bar"></span>
- <span class="icon-bar"></span>
- <span class="icon-bar"></span>
- </button>
- <?php
- echo '<p class="navbar-text navbar-right">Hello, <a href="#" class="navbar-link">'.$username.'</a></p>';
- ?>
- <a class="navbar-brand glyphicon glyphicon-home toolti" data-placement="middle" title="Go to WELTES Home" href="../../../index.html"> </a>
- </div>
- <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
- <ul class="nav navbar-nav">
- <li class="dropdown">
- <a href="#" class="dropdown-toggle" data-toggle="dropdown"><strong class="glyphicon glyphicon-align-left"></strong> <strong>   NAVIGATE</strong> <b class="caret"></b></a>
- <ul class="dropdown-menu">
- <li><a href="e1.html">Fabrication QC</a></li>
- <li class="divider"></li>
- <li><a href="e2.html">Link 1</a></li>
- <li><a href="e3.html">Link 2</a></li>
- <li><a href="e4.html">Link 3</a></li>
- <li><a href="e5.html">Link 4</a></li>
- <li class="divider"></li>
- <li><a href="../../../logout.php">SIGN OUT</a></li>
- </ul>
- </li>
- <li class="dropdown">
- <?php
- $projectParse = oci_parse($conn, 'SELECT DISTINCT PROJECT_NAME FROM FABRICATION');
- oci_execute($projectParse);
- echo '<a href="#" class="dropdown-toggle" data-toggle="dropdown"><strong class="glyphicon glyphicon-road"></strong> <strong>   PROJECT</strong> <b class="caret"></b></a>';
- echo '<ul class="dropdown-menu" id="project">';
- while($row = oci_fetch_array($projectParse,OCI_ASSOC))
- {
- echo "<li><a href='#'>$row[PROJECT_NAME]</a></li>";
- }
- echo '</ul>';
- ?>
- </li>
- </div><!-- /.navbar-collapse -->
- </nav>
- <script>
- $(function(){
- $("#test").powertable({
- showsize: "25",
- loadmoresize: "25"
- });
- });
- </script>
- <div class="well well-sm">
- <span class="h1 text-info">
- <p class="text-center">FABRICATION UPDATE</p>
- </span>
- <p class="text-center"><i>PT. WELTES ENERGI NUSANTARA | Process Division | Fabrication Update</i></p>
- <form class="form-inline" role="form">
- <div class ="form-group">
- <?php
- $result = oci_parse($conn, 'SELECT DISTINCT HEAD_MARK FROM FABRICATION WHERE PROJECT_NAME = :projName');
- oci_bind_by_name($result, "projName", $_POST["project"]);
- oci_execute($result);
- echo '<label><SELECT name="headmark" id="headmark" class="form-control input-sm" placeholder="Select Project">'.'<br>';
- echo '<OPTION VALUE=" ">'."Project Select".'</OPTION>';
- while($row = oci_fetch_array($result,OCI_ASSOC)){
- $HM = $row ['HEAD_MARK'];
- echo "<OPTION VALUE='$HM'>$HM</OPTION>";
- }
- echo '</SELECT></label><br />';
- ?>
- </div>
- </form>
- <div id="result"></div>
- <br><br><br><br>
- </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement