Server IP : 162.240.98.243 / Your IP : 3.16.48.43 Web Server : Apache System : Linux server.bti.yaw.mybluehostin.me 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : btiyawmy ( 1003) PHP Version : 7.2.34 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/btiyawmy/www/login.easenup.in/ |
Upload File : |
<?php session_start(); require_once("../LoginManager.php"); require_once("../DBManager.php"); include("workdeskmenu.php"); include("opdtest2322.php"); ?> <div class="content-wrapper"> <!-- Content Header (Page header) --> <section class="content-header"> <style> /* Automatic Serial Number Row */ .css-serial { counter-reset: serial-number; /* Set the serial number counter to 0 */ } .css-serial td:first-child:before { counter-increment: serial-number; /* Increment the serial number counter */ content: counter(serial-number); /* Display the counter */ } </style> <input type="search" class="light-table-filter" data-table="order-table" placeholder="Search" /> <br><br> <table id="example2" class="order-table table table-bordered table-hover css-serial"> <thead> <tr> <th><strong>SR.NO</strong></th> <th><strong>Tarif Name</strong></th> <th><strong>Status</strong></th> <th><strong>Action</strong></th> </tr> </thead> <?php include("dbconnection.php"); $narayan=LoginManager::currentUser(); $usertype=LoginManager::getUserTypeByuname("$narayan"); $sql ="SELECT * FROM site_users WHERE userno='$usertype'"; $qsql = mysqli_query($con,$sql); if($rs = mysqli_fetch_array($qsql)) { $sqlpatient1 = "SELECT * FROM tarif"; $qsqlpatient1 = mysqli_query($con,$sqlpatient1); while($rsn = mysqli_fetch_array($qsqlpatient1)) { echo"<tr><td> </td><td> <b>$rsn[tarifname]</b> </td>"; if (is_numeric($rsn[tarifid])) { $DisplayForm=True; $sql1 ="SELECT * FROM tarifrate WHERE hospitalid='$rs[entered_by]' And tarifid='$rsn[tarifid]'"; $qsql1 = mysqli_query($con,$sql1); while($rh1 = mysqli_fetch_array($qsql1)) $DisplayForm=False; echo ""; } if($DisplayForm) { echo"<td>Pending</td>"; } else { $sql1 ="SELECT * FROM tarifrate WHERE hospitalid='$rs[entered_by]' And tarifid='$rsn[tarifid]'"; $qsql1 = mysqli_query($con,$sql1); while($rs1 = mysqli_fetch_array($qsql1)) echo" "; } if (is_numeric($rsn[tarifid])) { $DisplayForm=True; $sql1 ="SELECT * FROM tarifrate WHERE hospitalid='$rs[entered_by]' And tarifid='$rsn[tarifid]'"; $qsql1 = mysqli_query($con,$sql1); if($rh1 = mysqli_fetch_array($qsql1)) $DisplayForm=False; echo ""; } if($DisplayForm) { echo""; } else { $sql1 ="SELECT * FROM tarifrate WHERE hospitalid='$rs[entered_by]' And tarifid='$rsn[tarifid]'"; $qsql1 = mysqli_query($con,$sql1); if($rs1 = mysqli_fetch_array($qsql1)) echo" <td>Updated</td> "; } echo" <td> "; if (is_numeric($rsn[tarifid])) { $DisplayForm=True; $sql1 ="SELECT * FROM tarifrate WHERE hospitalid='$rs[entered_by]' And tarifid='$rsn[tarifid]'"; $qsql1 = mysqli_query($con,$sql1); while($rh1 = mysqli_fetch_array($qsql1)) $DisplayForm=False; echo ""; } if($DisplayForm) { echo"<a href='tarifrate.php?tarifid=$rsn[tarifid]'> <i class='fa fa-plus-square' aria-hidden='true' style='font-size:20px'></i></a>"; } else { echo"<a href='edit_tarifrate.php?tarifid=$rsn[tarifid]'> <i class='fa fa-pencil-square-o' aria-hidden='true' style='font-size:20px'></i></a> | <a href='view_tarifrate.php?tarifid=$rsn[tarifid]'> <i class='fa fa-eye' aria-hidden='true' style='font-size:20px'></i></a> "; } echo" </td> </tr> "; } } ?> </tbody> <tfoot> </tfoot> </table>