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;