| Server IP : 162.240.98.243 / Your IP : 18.219.239.118 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/public_html/login.easenup.in/ |
Upload File : |
<?php
session_start();
require_once('../DBManager.php');
require_once('../LoginManager.php');
require_once('../patientmanager.php');
include 'workdeskmenu.php';
include 'header.php';
include("dbconnection.php");
?>
<!DOCTYPE html>
<html>
<body>
<body>
<h2 align='center'> Invoice</h2>
<style>
#topright {
position: absolute;
right: 0;
top: 0;
margin-top: 73px;
margin-right: 30px;
display: block;
height: 70px;
width: 70px;
background: url(TRbanner.gif) no-repeat;
text-indent: -999em;
text-decoration: none;
}
#toprightj {
position: absolute;
right: 0;
top: 0;
margin-top: 73px;
margin-right: 120px;
display: block;
height: 70px;
width: 70px;
background: url(TRbanner.gif) no-repeat;
text-indent: -999em;
text-decoration: none;
}
#toprightb {
position: absolute;
right: 0;
top: 0;
margin-top: 73px;
margin-right: 200px;
display: block;
height: 70px;
width: 70px;
background: url(TRbanner.gif) no-repeat;
text-indent: -999em;
text-decoration: none;
}
.center {
border: 1px solid grey;
text-align:;
}
.center2 {
border: 5px solid grey;
text-align:;
}
<style>
h2 {
color: #5287f5;
}
a img {
border: none;
}
#memo {
padding-top: 50px;
margin: 0 20px 0 60px;
border-bottom: 1px solid #ddd;
height: 200px;
}
#memo .logo {
float: left;
margin-right: 20px;
}
#memo .logo img {
width: 150px;
height: 100px;
}
#memo .company-info {
float: right;
text-align: right;
}
#memo .company-info > div:first-child {
font-weight: bold;
font-size: 22px;
color: #1e73be;
}
#memo .company-info span {
font-size: 11px;
min-width: 20px;
}
</style>
</style>
</head>
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<div class='center'>
<div id="container">
<?php
?>
<table>
<thead>
<th>Date & Time</th>
<th>Invoice</th>
<th>Towards</th>
<th>Action</th>
</thead>
<tbody>
<?php
$sql5 ="SELECT vendor,invoice_no,status,created_at FROM implant_purchasereport WHERE invoice_no='$_GET[invoice_id]' AND vendor='$_GET[vendor]' AND status='1' GROUP BY vendor,invoice_no,status,created_at";
$qsql5 = mysqli_query($con,$sql5);
while($re5 = mysqli_fetch_array($qsql5)){
if($re5['status']=='1'){
?>
<tr>
<td><?php echo $re5['created_at']; ?></td>
<td><?php echo $_GET['vendor']; ?></td>
<td>
<lable> Purchase</lable>
</td>
<td><?php echo "<a class='tooltiplink' data-title='View' href='view_implant_purchase_invoice.php?invoice_no=$re5[invoice_no]&vendor=$re5[vendor]'> <i class='fa fa-eye' style='font-size:20px;'></i> </a>
"; ?></td>
</tr>
<?php } } ?>
<!--return data-->
<?php
$RetuneMedicine="SELECT * FROM `impant_purchase_return` WHERE invoice='$_GET[invoice_id]' AND vendor='$_GET[vendor]' AND status='1'";
$QRM=mysqli_query($con,$RetuneMedicine);
while($RowRM=mysqli_fetch_array($QRM)) {
?>
<tr>
<td><?php echo $RowRM['created_at']; ?></td>
<td><?php echo $RowRM['id']; ?></td>
<td>
<lable> Return</lable>
</td>
<td><?php echo "<a class='tooltiplink' data-title='View' href='view_implant_purchase_invoice.php?pid=$RowRM[id]'> <i class='fa fa-eye' style='font-size:20px;'></i> </a>
"; ?></td>
</tr>
<?php }
?>
</tbody>
</table>
<?php ?>
</div>
</div></div>
<?php
?>