Edit: result_radiology-old.php

Editing: result_radiology-old.php

Kembali

<?php include 'includes/session.php'; ?>
<?php 
	include 'includes/header.php'; 
	include '../timezone.php';
	$range_to = date('m/d/Y');
	$range_from = date('m/d/Y', strtotime('-30 day', strtotime($range_to)));
	$userid=$_SESSION["userID"];
	$id_login= $_SESSION["uc"];
?>

<body class="hold-transition skin-blue sidebar-mini">
<div class="wrapper">
  <?php include 'includes/navbar.php'; ?>
  <?php include 'includes/menubar.php'; ?>
  
  <div class="content-wrapper">
    
    <section class="content-header">
      <h1>
        Result Radiology
      </h1>
      <ol class="breadcrumb">
        <li><a href="home.php"><i class="fa fa-dashboard"></i> Home</a></li>
        <li class="active">Result Radiology</li>
      </ol>
    </section>
    
    <section class="content">
      <?php
        if(isset($_SESSION['error'])){
          echo "
            <div class='alert alert-danger alert-dismissible'>
              <button type='button' class='close' data-dismiss='alert' aria-hidden='true'>&times;</button>
              <h4><i class='icon fa fa-warning'></i> Error!</h4>
              ".$_SESSION['error']."
            </div>
          ";
          unset($_SESSION['error']);
        }
        if(isset($_SESSION['success'])){
          echo "
            <div class='alert alert-success alert-dismissible'>
              <button type='button' class='close' data-dismiss='alert' aria-hidden='true'>&times;</button>
              <h4><i class='icon fa fa-check'></i> Success!</h4>
              ".$_SESSION['success']."
            </div>
          ";
          unset($_SESSION['success']);
        }
		
      ?>
      <div class="row">
        <div class="col-xs-12">
          <div class="box">
            
			  <form method="POST" class="form-inline" id="listabsen" target="_blank">
			  <table><tr>
			  <td>
			  <input type="text" class="form-control pull-right col-sm-8" id="idf" name="idf" onkeyup='searchTable()' placeholder="search...">
			  </td>
			  <td>
			  <input type="text" class="form-control pull-right col-sm-8" id="reservation" name="date_range" value="<?php echo (isset($_GET['range'])) ? $_GET['range'] : $range_from.' - '.$range_to; ?>">
              </td>
			  <td><button type="button" class="btn btn-primary btn-sm btn-flat" id="printabsen"><span class="glyphicon glyphicon-print"></span> Print</button>
			  </td>
			  
			  </tr></table> 
			  </form>
            <div class="box-body">
              <table id="example1" class="fl-table">
                 <thead>
                  <th>No.</th>
                  <th>Date</th>
                  <th>List of Plan</th> 
                  <th>Name Doctor</th>
                  <th>Name Patient</th>
				  <th>Triagem</th>
				  <tbody>                
                 
                  <?php
                    $sql = "Select
					c1.Nom1,
					c1.Date_Time,
					c1.Treatments,
					d1.SSN,
					d1.F_Name,
					d1.L_Name,
					p1.SSN,
					p1.F_Name,
					p1.L_Name,
					c1.Complains,
					c1.Findings,
					c1.Medicines,
					c1.Allergies
					From
					consultation AS c1
					Left Join doctor AS d1 ON c1.Doctor_SSN = d1.SSN
					Left Join patient AS p1 ON c1.Patient_SSN = p1.SSN
					Where
					c1.Treatments ='RADIOLOGY' AND c1.r_radiology = 'Sim'
					";
					
					$query = $conn->query($sql);
					$i=0;
                    while($row = $query->fetch_array()){
					$i++;
                      echo "
                        <tr>
	                      <td>".$i."."."</td>
						  <td>".date('M d, Y', strtotime($row[1]))."</td>
						  
                          <td>".$row[10]."</td>
						  <td>".$row[3]. "-".$row[4]." ".$row[5]."</td>
					      <td>".$row[6]."-".$row[7]." ".$row[8]."</td>
						  <td>".$row[9]."</td>
                        </tr>";
                    }
                  ?>
                </tbody>
              </table>
            </div>
          </div>
        </div>
      </div>
    </section>   
  </div>
  <?php include 'includes/footer.php'; ?>
  <?php include 'includes/radiology_modal.php'; ?>
</div>
<?php include 'includes/scripts.php'; ?>

</script>

<?php include 'includes/datatable_initializer.php'; ?>
</body>
</html>