function thisLineItem($patient_id, $encounter_id, $description, $transdate, $qty, $cypfactor, $irnumber = '')
{
global $product, $productcyp, $producttotal, $productqty, $grandtotal, $grandqty;
$invnumber = empty($irnumber) ? "{$patient_id}.{$encounter_id}" : $irnumber;
$rowcyp = sprintf('%01.2f', $cypfactor);
$rowresult = sprintf('%01.2f', $rowcyp * $qty);
$rowproduct = $description;
if (!$rowproduct) {
$rowproduct = 'Unknown';
}
if ($product != $rowproduct) {
if ($product) {
// Print product total.
if ($_POST['form_csvexport']) {
if (!$_POST['form_details']) {
echo '"' . display_desc($product) . '",';
echo '"' . $productqty . '",';
echo '"' . formatcyp($productcyp) . '",';
echo '"' . formatcyp($producttotal) . '"' . "\n";
}
} else {
?>
<tr bgcolor="#ddddff">
<td class="detail" colspan="<?php
echo $_POST['form_details'] ? 3 : 1;
?>
">
<?php
if ($_POST['form_details']) {
echo xl('Total for ');
}
echo display_desc($product);
?>
</td>
<td class="dehead" align="right">
<?php
echo $productqty;
?>
</td>
<td class="dehead" align="right">
<?php
echo formatcyp($productcyp);
?>
</td>
<td class="dehead" align="right">
<?php
echo formatcyp($producttotal);
?>
</td>
</tr>
<?php
}
// End not csv export
}
$producttotal = 0;
$productqty = 0;
$product = $rowproduct;
$productleft = $product;
$productcyp = $rowcyp;
}
if ($_POST['form_details']) {
if ($_POST['form_csvexport']) {
echo '"' . display_desc($product) . '",';
echo '"' . oeFormatShortDate(display_desc($transdate)) . '",';
echo '"' . display_desc($invnumber) . '",';
echo '"' . display_desc($qty) . '",';
echo '"' . formatcyp($rowcyp) . '",';
echo '"' . formatcyp($rowresult) . '"' . "\n";
} else {
?>
<tr>
<td class="detail">
<?php
echo display_desc($productleft);
$productleft = " ";
?>
</td>
<td class="dehead">
<?php
echo oeFormatShortDate($transdate);
?>
</td>
<td class="detail">
<?php
echo $invnumber;
?>
</td>
<td class="dehead" align="right">
<?php
echo $qty;
?>
</td>
<td class="dehead" align="right">
<?php
echo formatcyp($rowcyp);
?>
</td>
<td class="dehead" align="right">
<?php
echo formatcyp($rowresult);
?>
</td>
</tr>
<?php
}
// End not csv export
}
// end details
$producttotal += $rowresult;
$grandtotal += $rowresult;
$productqty += $qty;
$grandqty += $qty;
}
function thisLineItem($patient_id, $encounter_id, $rowcat, $description, $transdate, $qty, $amount, $irnumber = '')
{
global $product, $category, $producttotal, $productqty, $cattotal, $catqty, $grandtotal, $grandqty;
global $productleft, $catleft;
$invnumber = $irnumber ? $irnumber : "{$patient_id}.{$encounter_id}";
$rowamount = sprintf('%01.2f', $amount);
$patdata = sqlQuery("SELECT " . "p.fname, p.mname, p.lname, p.pubpid, p.DOB, " . "p.street, p.city, p.state, p.postal_code, " . "p.ss, p.sex, p.status, p.phone_home, " . "p.phone_biz, p.phone_cell, p.hipaa_notice " . "FROM patient_data AS p " . "WHERE p.pid = ? LIMIT 1", array($patient_id));
$pat_name = $patdata['fname'] . ' ' . $patdata['mname'] . ' ' . $patdata['lname'];
if (empty($rowcat)) {
$rowcat = xl('None');
}
$rowproduct = $description;
if (!$rowproduct) {
$rowproduct = xl('Unknown');
}
if ($product != $rowproduct || $category != $rowcat) {
if ($product) {
// Print product total.
if ($_POST['form_csvexport']) {
if (!$_POST['form_details']) {
echo '"' . display_desc($category) . '",';
echo '"' . display_desc($product) . '",';
echo '"' . $productqty . '",';
echo '"';
bucks($producttotal);
echo '"' . "\n";
}
} else {
?>
<tr bgcolor="#ddddff">
<td class="detail">
<?php
echo text(display_desc($catleft));
$catleft = " ";
?>
</td>
<td class="detail" colspan="3">
<?php
if ($_POST['form_details']) {
echo xlt('Total for') . ' ';
}
echo text(display_desc($product));
?>
</td>
<?php
if ($GLOBALS['sales_report_invoice'] == 0 || $GLOBALS['sales_report_invoice'] == 2) {
?>
<td>
</td>
<?php
}
?>
<td align="right">
</td>
<td align="right">
<?php
echo text($productqty);
?>
</td>
<td align="right">
<?php
text(bucks($producttotal));
?>
</td>
</tr>
<?php
}
// End not csv export
}
$producttotal = 0;
$productqty = 0;
$product = $rowproduct;
$productleft = $product;
}
if ($category != $rowcat) {
if ($category) {
// Print category total.
if (!$_POST['form_csvexport']) {
?>
<tr bgcolor="#ffdddd">
<td class="detail">
</td>
<td class="detail" colspan="3">
<?php
echo xlt('Total for category') . ' ';
echo text(display_desc($category));
?>
</td>
<?php
if ($GLOBALS['sales_report_invoice'] == 0 || $GLOBALS['sales_report_invoice'] == 2) {
?>
<td>
</td>
<?php
}
?>
<td align="right">
</td>
<td align="right">
<?php
echo text($catqty);
?>
</td>
<td align="right">
<?php
text(bucks($cattotal));
?>
</td>
</tr>
<?php
}
// End not csv export
}
$cattotal = 0;
$catqty = 0;
$category = $rowcat;
$catleft = $category;
}
if ($_POST['form_details']) {
if ($_POST['form_csvexport']) {
echo '"' . display_desc($category) . '",';
echo '"' . display_desc($product) . '",';
echo '"' . oeFormatShortDate(display_desc($transdate)) . '",';
if ($GLOBALS['sales_report_invoice'] == 1 || $GLOBALS['sales_report_invoice'] == 2) {
echo '"' . $pat_name . '",';
}
if ($GLOBALS['sales_report_invoice'] == 0 || $GLOBALS['sales_report_invoice'] == 2) {
echo '"' . display_desc($invnumber) . '",';
}
if ($GLOBALS['sales_report_invoice'] == 1) {
echo '"' . $patient_id . '",';
}
// echo '"' . display_desc($invnumber) . '",';
echo '"' . display_desc($qty) . '",';
echo '"';
bucks($rowamount);
echo '"' . "\n";
} else {
?>
<tr>
<td class="detail">
<?php
echo text(display_desc($catleft));
$catleft = " ";
?>
</td>
<td class="detail">
<?php
echo text(display_desc($productleft));
$productleft = " ";
?>
</td>
<td>
<?php
echo text(oeFormatShortDate($transdate));
?>
</td>
<?php
if ($GLOBALS['sales_report_invoice'] == 0 || $GLOBALS['sales_report_invoice'] == 2) {
?>
<td>
</td>
<?php
}
if ($GLOBALS['sales_report_invoice'] == 1 || $GLOBALS['sales_report_invoice'] == 2) {
?>
<td>
<?php
echo text($pat_name);
?>
</td>
<?php
}
?>
<td class="detail">
<?php
if ($GLOBALS['sales_report_invoice'] == 0 || $GLOBALS['sales_report_invoice'] == 2) {
?>
<a href='../patient_file/pos_checkout.php?ptid=<?php
echo attr($patient_id);
?>
&enc=<?php
echo attr($encounter_id);
?>
'>
<?php
echo text($invnumber);
?>
</a>
<?php
}
if ($GLOBALS['sales_report_invoice'] == 1) {
echo text($patient_id);
}
?>
</td>
<?php
if ($GLOBALS['sales_report_invoice'] == 0) {
?>
<td>
</td>
<?php
}
?>
<td align="right">
<?php
echo text($qty);
?>
</td>
<td align="right">
<?php
text(bucks($rowamount));
?>
</td>
</tr>
<?php
}
// End not csv export
}
// end details
$producttotal += $rowamount;
$cattotal += $rowamount;
$grandtotal += $rowamount;
$productqty += $qty;
$catqty += $qty;
$grandqty += $qty;
}
function thisLineItem($patient_id, $encounter_id, $rowcat, $description, $transdate, $qty, $amount, $irnumber = '')
{
global $product, $category, $producttotal, $productqty, $cattotal, $catqty, $grandtotal, $grandqty;
global $productleft, $catleft;
$invnumber = $irnumber ? $irnumber : "{$patient_id}.{$encounter_id}";
$rowamount = sprintf('%01.2f', $amount);
if (empty($rowcat)) {
$rowcat = 'None';
}
$rowproduct = $description;
if (!$rowproduct) {
$rowproduct = 'Unknown';
}
if ($product != $rowproduct || $category != $rowcat) {
if ($product) {
// Print product total.
if ($_POST['form_csvexport']) {
if (!$_POST['form_details']) {
echo '"' . display_desc($category) . '",';
echo '"' . display_desc($product) . '",';
echo '"' . $productqty . '",';
echo '"';
bucks($producttotal);
echo '"' . "\n";
}
} else {
?>
<tr bgcolor="#ddddff">
<td class="detail">
<?php
echo display_desc($catleft);
$catleft = " ";
?>
</td>
<td class="detail" colspan="3">
<?php
if ($_POST['form_details']) {
echo xl('Total for') . ' ';
}
echo display_desc($product);
?>
</td>
<td align="right">
<?php
echo $productqty;
?>
</td>
<td align="right">
<?php
bucks($producttotal);
?>
</td>
</tr>
<?php
}
// End not csv export
}
$producttotal = 0;
$productqty = 0;
$product = $rowproduct;
$productleft = $product;
}
if ($category != $rowcat) {
if ($category) {
// Print category total.
if (!$_POST['form_csvexport']) {
?>
<tr bgcolor="#ffdddd">
<td class="detail">
</td>
<td class="detail" colspan="3">
<?php
echo xl('Total for category') . ' ';
echo display_desc($category);
?>
</td>
<td align="right">
<?php
echo $catqty;
?>
</td>
<td align="right">
<?php
bucks($cattotal);
?>
</td>
</tr>
<?php
}
// End not csv export
}
$cattotal = 0;
$catqty = 0;
$category = $rowcat;
$catleft = $category;
}
if ($_POST['form_details']) {
if ($_POST['form_csvexport']) {
echo '"' . display_desc($category) . '",';
echo '"' . display_desc($product) . '",';
echo '"' . oeFormatShortDate(display_desc($transdate)) . '",';
echo '"' . display_desc($invnumber) . '",';
echo '"' . display_desc($qty) . '",';
echo '"';
bucks($rowamount);
echo '"' . "\n";
} else {
?>
<tr>
<td class="detail">
<?php
echo display_desc($catleft);
$catleft = " ";
?>
</td>
<td class="detail">
<?php
echo display_desc($productleft);
$productleft = " ";
?>
</td>
<td>
<?php
echo oeFormatShortDate($transdate);
?>
</td>
<td class="detail">
<a href='../patient_file/pos_checkout.php?ptid=<?php
echo $patient_id;
?>
&enc=<?php
echo $encounter_id;
?>
'>
<?php
echo $invnumber;
?>
</a>
</td>
<td align="right">
<?php
echo $qty;
?>
</td>
<td align="right">
<?php
bucks($rowamount);
?>
</td>
</tr>
<?php
}
// End not csv export
}
// end details
$producttotal += $rowamount;
$cattotal += $rowamount;
$grandtotal += $rowamount;
$productqty += $qty;
$catqty += $qty;
$grandqty += $qty;
}
function thisLineItem($product_id, $warehouse_id, $patient_id, $encounter_id, $rowprod, $rowwh, $transdate, $qtys, $irnumber = '')
{
global $warehouse, $product, $secqtys, $priqtys, $grandqtys;
global $whleft, $prodleft;
// left 2 columns, blank where repeated
global $last_warehouse_id, $last_product_id, $product_first;
$invnumber = empty($irnumber) ? $patient_id ? "{$patient_id}.{$encounter_id}" : "" : $irnumber;
// Product name for this detail line item.
if (empty($rowprod)) {
$rowprod = 'Unnamed Product';
}
// Warehouse name for this line item.
if (empty($rowwh)) {
$rowwh = 'None';
}
if ($warehouse_id != $last_warehouse_id || $product_id != $last_product_id) {
if ($product_first && $last_warehouse_id != '~' || !$product_first && $last_product_id) {
$secei = getEndInventory($last_product_id, $last_warehouse_id);
// Print second-column totals.
if ($_POST['form_csvexport']) {
if (!$_POST['form_details']) {
if ($product_first) {
echo '"' . display_desc($product) . '"';
echo ',"' . display_desc($warehouse) . '"';
} else {
echo '"' . display_desc($warehouse) . '"';
echo ',"' . display_desc($product) . '"';
}
echo ',"' . ($secei - $secqtys[0] - $secqtys[1] - $secqtys[2] - $secqtys[3]) . '"';
// start inventory
echo ',"' . $secqtys[0] . '"';
// sales
echo ',"' . $secqtys[1] . '"';
// purchases
echo ',"' . $secqtys[2] . '"';
// transfers
echo ',"' . $secqtys[3] . '"';
// adjustments
echo ',"' . $secei . '"';
// end inventory
echo "\n";
}
} else {
// Warehouse totals and not export:
?>
<tr bgcolor="#ddddff">
<?php
if ($product_first) {
?>
<td class="detail">
<?php
echo display_desc($prodleft);
$prodleft = " ";
?>
</td>
<td class="detail" colspan='3'>
<?php
if ($_POST['form_details']) {
echo xl('Total for') . ' ';
}
echo display_desc($warehouse);
?>
</td>
<?php
} else {
?>
<td class="detail">
<?php
echo display_desc($whleft);
$whleft = " ";
?>
</td>
<td class="detail" colspan='3'>
<?php
if ($_POST['form_details']) {
echo xl('Total for') . ' ';
}
echo display_desc($product);
?>
</td>
<?php
}
?>
<td class="dehead" align="right">
<?php
echo $secei - $secqtys[0] - $secqtys[1] - $secqtys[2] - $secqtys[3];
?>
</td>
<td class="dehead" align="right">
<?php
echo $secqtys[0];
?>
</td>
<td class="dehead" align="right">
<?php
echo $secqtys[1];
?>
</td>
<td class="dehead" align="right">
<?php
echo $secqtys[2];
?>
</td>
<td class="dehead" align="right">
<?php
echo $secqtys[3];
?>
</td>
<td class="dehead" align="right">
<?php
echo $secei;
?>
</td>
</tr>
<?php
}
// End not csv export
}
$secqtys = array(0, 0, 0, 0);
if ($product_first) {
$whleft = $warehouse = $rowwh;
$last_warehouse_id = $warehouse_id;
} else {
$prodleft = $product = $rowprod;
$last_product_id = $product_id;
}
}
if ($product_first && $product_id != $last_product_id || !$product_first && $warehouse_id != $last_warehouse_id) {
if ($product_first && $last_product_id || !$product_first && $last_warehouse_id != '~') {
$priei = $product_first ? getEndInventory($last_product_id) : getEndInventory(0, $last_warehouse_id);
// Print first column total.
if (!$_POST['form_csvexport']) {
?>
<tr bgcolor="#ffdddd">
<td class="detail">
</td>
<td class="detail" colspan="3">
<?php
echo xl('Total for') . ' ';
echo display_desc($product_first ? $product : $warehouse);
?>
</td>
<td class="dehead" align="right">
<?php
echo $priei - $priqtys[0] - $priqtys[1] - $priqtys[2] - $priqtys[3];
?>
</td>
<td class="dehead" align="right">
<?php
echo $priqtys[0];
?>
</td>
<td class="dehead" align="right">
<?php
echo $priqtys[1];
?>
</td>
<td class="dehead" align="right">
<?php
echo $priqtys[2];
?>
</td>
<td class="dehead" align="right">
<?php
echo $priqtys[3];
?>
</td>
<td class="dehead" align="right">
<?php
echo $priei;
?>
</td>
</tr>
<?php
}
// End not csv export
}
$priqtys = array(0, 0, 0, 0);
if ($product_first) {
$prodleft = $product = $rowprod;
$last_product_id = $product_id;
} else {
$whleft = $warehouse = $rowwh;
$last_warehouse_id = $warehouse_id;
}
}
if ($_POST['form_details'] && $product_id && $qtys[0] + $qtys[1] + $qtys[2] + $qtys[3]) {
if ($_POST['form_csvexport']) {
if ($product_first) {
echo '"' . display_desc($product) . '"';
echo ',"' . display_desc($warehouse) . '"';
} else {
echo '"' . display_desc($warehouse) . '"';
echo ',"' . display_desc($product) . '"';
}
echo ',"' . oeFormatShortDate(display_desc($transdate)) . '"';
echo ',"' . display_desc($invnumber) . '"';
echo ',"' . $qtys[0] . '"';
// sales
echo ',"' . $qtys[1] . '"';
// purchases
echo ',"' . $qtys[2] . '"';
// transfers
echo ',"' . $qtys[3] . '"';
// adjustments
echo "\n";
} else {
?>
<tr>
<?php
if ($product_first) {
?>
<td class="detail">
<?php
echo display_desc($prodleft);
$prodleft = " ";
?>
</td>
<td class="detail">
<?php
echo display_desc($whleft);
$whleft = " ";
?>
</td>
<?php
} else {
?>
<td class="detail">
<?php
echo display_desc($whleft);
$whleft = " ";
?>
</td>
<td class="detail">
<?php
echo display_desc($prodleft);
$prodleft = " ";
?>
</td>
<?php
}
?>
<td class="dehead">
<?php
echo oeFormatShortDate($transdate);
?>
</td>
<td class="detail">
<?php
echo $invnumber;
?>
</td>
<td class="detail">
</td>
<td class="dehead" align="right">
<?php
echo $qtys[0];
?>
</td>
<td class="dehead" align="right">
<?php
echo $qtys[1];
?>
</td>
<td class="dehead" align="right">
<?php
echo $qtys[2];
?>
</td>
<td class="dehead" align="right">
<?php
echo $qtys[3];
?>
</td>
<td class="detail">
</td>
</tr>
<?php
}
// End not csv export
}
// end details
for ($i = 0; $i < 4; ++$i) {
$secqtys[$i] += $qtys[$i];
$priqtys[$i] += $qtys[$i];
$grandqtys[$i] += $qtys[$i];
}
}
echo "<center>";
switch ($ac) {
case 'add':
$result = add($link, $shop_db);
break;
case 'list':
$result = list_goods($link, $shop_db);
break;
case 'del':
$result = del($link, $shop_db);
break;
case 'modify':
$result = modify($link, $shop_db);
break;
case 'desc':
$result = display_desc($link, $shop_db);
break;
case 'addcar':
$result = addcar($link, $shop_db);
break;
case 'mycar':
$result = mycar($link, $shop_db);
break;
case 'cleanmycar':
$result = cleanmycar($link, $shop_db);
break;
default:
display_index();
}
echo "</center>";
//var_dump($result);exit;
