2 // Copyright (C) 2006-2015 Rod Roark <rod@sunsetsystems.com>
4 // This program is free software; you can redistribute it and/or
5 // modify it under the terms of the GNU General Public License
6 // as published by the Free Software Foundation; either version 2
7 // of the License, or (at your option) any later version.
9 // This report lists destroyed drug lots within a specified date
12 require_once("../globals.php");
13 require_once("$srcdir/patient.inc");
14 require_once("../drugs/drugs.inc.php");
15 require_once("$srcdir/formatting.inc.php");
17 $form_from_date = fixDate($_POST['form_from_date'], date('Y-01-01'));
18 $form_to_date = fixDate($_POST['form_to_date'] , date('Y-m-d'));
22 <?php
html_header_show();?
>
23 <title
><?php
xl('Destroyed Drugs','e'); ?
></title
>
24 <link rel
='stylesheet' href
='<?php echo $css_header ?>' type
='text/css'>
26 <style type
="text/css">@import
url(../../library
/dynarch_calendar
.css
);</style
>
27 <script type
="text/javascript" src
="../../library/textformat.js"></script
>
28 <script type
="text/javascript" src
="../../library/dynarch_calendar.js"></script
>
29 <?php
include_once("{$GLOBALS['srcdir']}/dynarch_calendar_en.inc.php"); ?
>
30 <script type
="text/javascript" src
="../../library/dynarch_calendar_setup.js"></script
>
31 <script type
="text/javascript" src
="../../library/dialog.js"></script
>
32 <script language
="JavaScript">
33 var mypcc
= '<?php echo $GLOBALS['phone_country_code
'] ?>';
35 $
(document
).ready(function() {
36 var win
= top
.printLogSetup ? top
: opener
.top
;
37 win
.printLogSetup(document
.getElementById('printbutton'));
42 <body leftmargin
='0' topmargin
='0' marginwidth
='0' marginheight
='0'>
46 <h2
><?php
xl('Destroyed Drugs','e'); ?
></h2
>
48 <form name
='theform' method
='post' action
='destroyed_drugs_report.php'>
50 <table border
='0' cellpadding
='3'>
54 <?php
xl('From','e'); ?
>:
55 <input type
='text' name
='form_from_date' id
='form_from_date'
56 size
='10' value
='<?php echo $form_from_date ?>'
57 onkeyup
='datekeyup(this,mypcc)' onblur
='dateblur(this,mypcc)' title
=<?php
xl('yyyy-mm-dd','e','\'','\''); ?
>>
58 <img src
='../pic/show_calendar.gif' align
='absbottom' width
='24' height
='22'
59 id
='img_from_date' border
='0' alt
='[?]' style
='cursor:pointer'
60 title
=<?php
xl('Click here to choose a date','e','\'','\''); ?
>>
62  
;<?php
xl('To','e'); ?
>:
63 <input type
='text' name
='form_to_date' id
='form_to_date'
64 size
='10' value
='<?php echo $form_to_date ?>'
65 onkeyup
='datekeyup(this,mypcc)' onblur
='dateblur(this,mypcc)' title
=<?php
xl('yyyy-mm-dd','e','\'','\''); ?
>>
66 <img src
='../pic/show_calendar.gif' align
='absbottom' width
='24' height
='22'
67 id
='img_to_date' border
='0' alt
='[?]' style
='cursor:pointer'
68 title
=<?php
xl('Click here to choose a date','e','\'','\''); ?
>>
71 <input type
='submit' name
='form_refresh' value
=<?php
xl('Refresh','e'); ?
>>
73 <input type
='button' value
='<?php echo xla('Print'); ?>' id
='printbutton' />
84 <table border
='0' cellpadding
='1' cellspacing
='2' width
='98%'>
85 <tr bgcolor
="#dddddd">
87 <?php
xl('Drug Name','e'); ?
>
90 <?php
xl('NDC','e'); ?
>
93 <?php
xl('Lot','e'); ?
>
96 <?php
xl('Qty','e'); ?
>
99 <?php
xl('Date Destroyed','e'); ?
>
102 <?php
xl('Method','e'); ?
>
105 <?php
xl('Witness','e'); ?
>
108 <?php
xl('Notes','e'); ?
>
113 if ($_POST['form_refresh']) {
114 $where = "i.destroy_date >= '$form_from_date' AND " .
115 "i.destroy_date <= '$form_to_date'";
117 $query = "SELECT i.inventory_id, i.lot_number, i.on_hand, i.drug_id, " .
118 "i.destroy_date, i.destroy_method, i.destroy_witness, i.destroy_notes, " .
119 "d.name, d.ndc_number " .
120 "FROM drug_inventory AS i " .
121 "LEFT OUTER JOIN drugs AS d ON d.drug_id = i.drug_id " .
123 "ORDER BY d.name, i.drug_id, i.destroy_date, i.lot_number";
125 // echo "<!-- $query -->\n"; // debugging
126 $res = sqlStatement($query);
129 while ($row = sqlFetchArray($res)) {
130 $drug_name = $row['name'];
131 $ndc_number = $row['ndc_number'];
132 if ($row['drug_id'] == $last_drug_id) {
133 $drug_name = ' ';
134 $ndc_number = ' ';
139 <?php
echo $drug_name ?
>
142 <?php
echo $ndc_number ?
>
145 <a href
='../drugs/destroy_lot.php?drug=<?php echo $row['drug_id
'] ?>&lot=<?php echo $row['inventory_id
'] ?>'
146 style
='color:#0000ff' target
='_blank'>
147 <?php
echo $row['lot_number'] ?
>
151 <?php
echo $row['on_hand'] ?
>
154 <?php
echo oeFormatShortDate($row['destroy_date']) ?
>
157 <?php
echo $row['destroy_method'] ?
>
160 <?php
echo $row['destroy_witness'] ?
>
163 <?php
echo $row['destroy_notes'] ?
>
167 $last_drug_id = $row['drug_id'];
175 <script language
='JavaScript'>
176 Calendar
.setup({inputField
:"form_from_date", ifFormat
:"%Y-%m-%d", button
:"img_from_date"});
177 Calendar
.setup({inputField
:"form_to_date", ifFormat
:"%Y-%m-%d", button
:"img_to_date"});