Server IP : 162.240.98.243 / Your IP : 3.144.28.70 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("dbconnection.php"); require_once('../../DBManager.php'); require_once('../../LoginManager.php'); ?> <?php include("dbconnection.php"); require_once('../../DBManager.php'); require_once('../../patientmanager.php'); include("header.php"); include("dashboard_pharma.php"); ?> <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> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script> <style> h2 { color: #4287f5; } a img { border: none; } #memo { padding-top: 50px; margin: 0 20px 0 60px; border-bottom: 1px solid #ddd; height: 150px; } #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> <div class="content-wrapper"> <div class='center'> <section id="memo"> <div class="logo"> <?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)) { $sql ="SELECT * FROM hco WHERE adminid='$rs[entered_by]'"; $qsql = mysqli_query($con,$sql); if($rs = mysqli_fetch_array($qsql)) { $sql ="SELECT * FROM admin WHERE id='$rs[adminid]'"; $qsql = mysqli_query($con,$sql); if($ra = mysqli_fetch_array($qsql)) { echo" <img data-logo='' src='../uploads/$rs[Logo]' /> </div> <div class='company-info'> <div>$ra[hsname]</div> <div> <span style='font-size:18px'>$rs[Street] | $rs[Locality]</br>$ra[EmailID] | $ra[numbers]</p></span> </div> "; } } } ?> <br> </section> <br> <?php include("dbconnection.php"); $sql1 ="SELECT * FROM patient WHERE patientid='$_GET[patientid]'"; $qsql1 = mysqli_query($con,$sql1); if($rspi1 = mysqli_fetch_array($qsql1)) { $sqlpatient = "SELECT * FROM medicine_slot WHERE prescriptionid='$_GET[prescriptionid]' AND srno='$_GET[srno]' AND action='Paid'"; $qsqlpatient = mysqli_query($con,$sqlpatient); if($rsp = mysqli_fetch_array($qsqlpatient)) { $sqlpatient1 = "SELECT * FROM site_users WHERE userno='$rsp[entered_by]'"; $qsqlpatient1 = mysqli_query($con,$sqlpatient1); if($rsn = mysqli_fetch_array($qsqlpatient1)) { echo" <div class='checkbox'><span style='float: left; font-size:19px;'>Date : 12/11/2021</span><span style='float: right; font-size:19px;'>Invoice Number :<b>$rsp[srno]</b></span></div> <br> <div class='checkbox'><span style='float: left; font-size:19px;'>UHID : $rspi1[patientid]</span><span style='float: right; font-size:19px;'>Name :<b>$rspi1[patientname]</b></span></div> <br> <div class='checkbox'><span style='float: left; font-size:19px;'>Age: $rspi1[dob]</span><span style='float: right; font-size:19px;'>SEX :<b>$rspi1[gendor]</b></span></div> <div class='card-body'> <table id='example2' class='table table-bordered table-hover'> <thead> <tr> <th><strong>Date & Time <br>Created By </strong></th> <th><strong>Medicine Name</strong></th> <th><strong>Batch No</strong></th> <th><strong>Price </strong></th> </tr> "; }}} ?> </thead> <?php include("dbconnection.php"); $sqlpatient2 = "SELECT * FROM medicine_charge WHERE WHERE prescriptionid=$_GET[prescriptionid] AND patientid=$_GET[patientid] AND status='1' AND srno='$_GET[srno]'"; $qsqlpatient2 = mysqli_query($con,$sqlpatient2); if($rsn2 = mysqli_fetch_array($qsqlpatient2)) { { $sqlpatient1 = "SELECT * FROM site_users WHERE userno='$rsn2[entered_by]'"; $qsqlpatient1 = mysqli_query($con,$sqlpatient1); if($rsn = mysqli_fetch_array($qsqlpatient1)) { $pricedue=$rsn2[pricetotal]; echo " <tbody> <tr> <td> $rsn2[created_at] <br>$rsn[name]</td> "; if (is_numeric($rsn2[medicine_id])) { $sql1 ="SELECT * FROM medicine_stok WHERE medicine_id='$rsn2[medicine_id]'"; $qsql1 = mysqli_query($con,$sql1); while($rh1 = mysqli_fetch_array($qsql1)) echo "<td>$rh1[DRUGS_name]</td>"; } echo " <td> $rsn2[batchno]</td> <td> $pricedue</td> </tr> "; } } } ?> </tbody> <tfoot> </tfoot> </table> <?php $sqlpatient2 = "SELECT * FROM medicine_charge WHERE WHERE prescriptionid=$_GET[prescriptionid] AND patientid=$_GET[patientid] AND status='1' AND srno='$_GET[srno]'"; $qsqlpatient2 = mysqli_query($con,$sqlpatient2); if($rsn2 = mysqli_fetch_array($qsqlpatient2)) { $sqlpatient21 = "SELECT * FROM medicine_inventory WHERE Batch_number='$rsn2[batchno]'"; $qsqlpatient21 = mysqli_query($con,$sqlpatient21); if($rsn21 = mysqli_fetch_array($qsqlpatient21)) { echo" <div class='checkbox'><span style='float: left; font-size:19px;'>Amount In Word:<b> "; $number = $rsn2[pricetotal]; $no = floor($number); $point = round($number - $no, 2) * 100; $hundred = null; $digits_1 = strlen($no); $i = 0; $str = array(); $words = array('0' => '', '1' => 'one', '2' => 'two', '3' => 'three', '4' => 'four', '5' => 'five', '6' => 'six', '7' => 'seven', '8' => 'eight', '9' => 'nine', '10' => 'ten', '11' => 'eleven', '12' => 'twelve', '13' => 'thirteen', '14' => 'fourteen', '15' => 'fifteen', '16' => 'sixteen', '17' => 'seventeen', '18' => 'eighteen', '19' =>'nineteen', '20' => 'twenty', '30' => 'thirty', '40' => 'forty', '50' => 'fifty', '60' => 'sixty', '70' => 'seventy', '80' => 'eighty', '90' => 'ninety'); $digits = array('', 'hundred', 'thousand', 'lakh', 'crore'); while ($i < $digits_1) { $divider = ($i == 2) ? 10 : 100; $number = floor($no % $divider); $no = floor($no / $divider); $i += ($divider == 10) ? 1 : 2; if ($number) { $plural = (($counter = count($str)) && $number > 9) ? 's' : null; $hundred = ($counter == 1 && $str[0]) ? ' and ' : null; $str [] = ($number < 21) ? $words[$number] . " " . $digits[$counter] . $plural . " " . $hundred : $words[floor($number / 10) * 10] . " " . $words[$number % 10] . " " . $digits[$counter] . $plural . " " . $hundred; } else $str[] = null; } $str = array_reverse($str); $result = implode('', $str); $points = ($point) ? "." . $words[$point / 10] . " " . $words[$point = $point % 10] : ''; echo "Rupees ". $result . "Only" . ""; echo"</b></b></span></div> <br> <div class='checkbox'><span style='float: left; font-size:19px;'>Payment Mode :<b>$rsn2[paymentmode]/$rsn2[status]</b></b></span></div> <br> <div class='checkbox'><span style='float: right; font-size:19px;'>Total Amount : $rsn2[price]</span></div> <br> <div class='checkbox'><span style='float: right; font-size:19px;'>Total Discount : <b>"; $discountin=$rsn2[price]-$rsn2[pricetotal]; echo" $discountin </b></span></div> <br> <div class='checkbox'><span style='float: right; font-size:19px;'>Total GST : <b>"; $disGST=$rsn2[pricetotal]/100; $GSTfinal=$disGST*$rsn21[gst]; $GRANDTOTAL=$rsn2[pricetotal]; echo" $GSTfinal </b></span></div> <br> <div class='checkbox'><span style='float: right; font-size:19px;'>Grand Total : <b>$GRANDTOTAL</b></span></div> <br> "; echo" <br> <div class='checkbox'> <b>Note</b></div> <div class='checkbox'><ol type='1'><li>Please carry the original slip, at the time of collection of report</li> <li>Report will be issued from collection counter</li> <li>Report will be generated at given time period, according to turn around time policy displayed on reception</li> </ol> "; } } ?> </div>