Server IP : 162.240.98.243 / Your IP : 18.190.253.210 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/Pharmacy/ |
Upload File : |
<?php session_start(); require_once('../../DBManager.php'); require_once('../../LoginManager.php'); require_once('../../patientmanager.php'); include 'menu.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 purchasereport WHERE invoice_no='$_GET[invoice_no]' 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_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 `PurchaseRetuneMedicine` WHERE invoice_no='$_GET[invoice_no]' 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_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 ?>