2 // Copyright (C) 2006-2016 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
>
29 table
.mymaintable
, table
.mymaintable td
, table
.mymaintable th
{
30 border
: 1px solid
#aaaaaa;
31 border
-collapse
: collapse
;
33 table
.mymaintable td
, table
.mymaintable th
{
34 padding
: 1pt
4pt
1pt
4pt
;
38 <script type
="text/javascript" src
="../../library/textformat.js?v=<?php echo $v_js_includes; ?>"></script
>
39 <script type
="text/javascript" src
="../../library/dynarch_calendar.js"></script
>
40 <?php
include_once("{$GLOBALS['srcdir']}/dynarch_calendar_en.inc.php"); ?
>
41 <script type
="text/javascript" src
="../../library/dynarch_calendar_setup.js"></script
>
42 <script type
="text/javascript" src
="../../library/dialog.js?v=<?php echo $v_js_includes; ?>"></script
>
43 <script type
="text/javascript" src
="../../library/js/jquery-1.9.1.min.js"></script
>
44 <script type
="text/javascript" src
="../../library/js/report_helper.js?v=<?php echo $v_js_includes; ?>"></script
>
46 <script language
="JavaScript">
48 var mypcc
= '<?php echo $GLOBALS['phone_country_code
'] ?>';
50 $
(document
).ready(function() {
51 oeFixedHeaderSetup(document
.getElementById('mymaintable'));
52 var win
= top
.printLogSetup ? top
: opener
.top
;
53 win
.printLogSetup(document
.getElementById('printbutton'));
59 <body leftmargin
='0' topmargin
='0' marginwidth
='0' marginheight
='0'>
63 <h2
><?php
xl('Destroyed Drugs','e'); ?
></h2
>
65 <form name
='theform' method
='post' action
='destroyed_drugs_report.php'>
67 <table border
='0' cellpadding
='3'>
71 <?php
xl('From','e'); ?
>:
72 <input type
='text' name
='form_from_date' id
='form_from_date'
73 size
='10' value
='<?php echo $form_from_date ?>'
74 onkeyup
='datekeyup(this,mypcc)' onblur
='dateblur(this,mypcc)' title
=<?php
xl('yyyy-mm-dd','e','\'','\''); ?
>>
75 <img src
='../pic/show_calendar.gif' align
='absbottom' width
='24' height
='22'
76 id
='img_from_date' border
='0' alt
='[?]' style
='cursor:pointer'
77 title
=<?php
xl('Click here to choose a date','e','\'','\''); ?
>>
79  
;<?php
xl('To','e'); ?
>:
80 <input type
='text' name
='form_to_date' id
='form_to_date'
81 size
='10' value
='<?php echo $form_to_date ?>'
82 onkeyup
='datekeyup(this,mypcc)' onblur
='dateblur(this,mypcc)' title
=<?php
xl('yyyy-mm-dd','e','\'','\''); ?
>>
83 <img src
='../pic/show_calendar.gif' align
='absbottom' width
='24' height
='22'
84 id
='img_to_date' border
='0' alt
='[?]' style
='cursor:pointer'
85 title
=<?php
xl('Click here to choose a date','e','\'','\''); ?
>>
88 <input type
='submit' name
='form_refresh' value
=<?php
xl('Refresh','e'); ?
>>
90 <input type
='button' value
='<?php echo xla('Print'); ?>' id
='printbutton' />
101 <table width
='98%' id
='mymaintable' class='mymaintable'>
103 <tr bgcolor
="#dddddd">
105 <?php
xl('Drug Name','e'); ?
>
108 <?php
xl('NDC','e'); ?
>
111 <?php
xl('Lot','e'); ?
>
114 <?php
xl('Qty','e'); ?
>
117 <?php
xl('Date Destroyed','e'); ?
>
120 <?php
xl('Method','e'); ?
>
123 <?php
xl('Witness','e'); ?
>
126 <?php
xl('Notes','e'); ?
>
132 if ($_POST['form_refresh']) {
133 $where = "i.destroy_date >= '$form_from_date' AND " .
134 "i.destroy_date <= '$form_to_date'";
136 $query = "SELECT i.inventory_id, i.lot_number, i.on_hand, i.drug_id, " .
137 "i.destroy_date, i.destroy_method, i.destroy_witness, i.destroy_notes, " .
138 "d.name, d.ndc_number " .
139 "FROM drug_inventory AS i " .
140 "LEFT OUTER JOIN drugs AS d ON d.drug_id = i.drug_id " .
142 "ORDER BY d.name, i.drug_id, i.destroy_date, i.lot_number";
144 // echo "<!-- $query -->\n"; // debugging
145 $res = sqlStatement($query);
148 while ($row = sqlFetchArray($res)) {
149 $drug_name = $row['name'];
150 $ndc_number = $row['ndc_number'];
151 if ($row['drug_id'] == $last_drug_id) {
152 $drug_name = ' ';
153 $ndc_number = ' ';
158 <?php
echo $drug_name ?
>
161 <?php
echo $ndc_number ?
>
164 <a href
='../drugs/destroy_lot.php?drug=<?php echo $row['drug_id
'] ?>&lot=<?php echo $row['inventory_id
'] ?>'
165 style
='color:#0000ff' target
='_blank'>
166 <?php
echo $row['lot_number'] ?
>
170 <?php
echo $row['on_hand'] ?
>
173 <?php
echo oeFormatShortDate($row['destroy_date']) ?
>
176 <?php
echo $row['destroy_method'] ?
>
179 <?php
echo $row['destroy_witness'] ?
>
182 <?php
echo $row['destroy_notes'] ?
>
186 $last_drug_id = $row['drug_id'];
195 <script language
='JavaScript'>
196 Calendar
.setup({inputField
:"form_from_date", ifFormat
:"%Y-%m-%d", button
:"img_from_date"});
197 Calendar
.setup({inputField
:"form_to_date", ifFormat
:"%Y-%m-%d", button
:"img_to_date"});