<?php
include '../scat.php';
include '../lib/item.php';
include '../lib/fpdf/alphapdf.php';
include '../lib/fpdf/ean13.php';
$a = array();
$in = $_REQUEST['in'];
$ex = $_REQUEST['ex'];
if ($ex) {
$exa = preg_split('/\\s+/', $ex);
$in .= ' -' . join(' -', $exa);
}
$items = item_find($db, $in, FIND_OR);
$default_height = $height = 1;
$cols = 3;
$pdf = new AlphaPDF('P', 'in', 'Letter');
$pdf->SetCompression(true);
$pdf->SetMargins(0, 0);
$pdf->SetAutoPageBreak(false);
$x = $y = 0;
$light = 96;
$basefontsize = 6;
$label_width = 2.625;
foreach ($items as $item) {
$bx = 0.25 + $x * ($label_width + 0.125);
$by = 0.5 + $y * $height;
$vmargin = 0.125;
if ($x == 0 && $y == 0) {
$pdf->AddPage();
if ($_REQUEST['debug']) {
function item_load($db, $id)
{
$items = item_find($db, "item:{$id}", FIND_ALL);
return $items[0];
}
<?php
include '../scat.php';
include '../lib/item.php';
include '../lib/fpdf/alphapdf.php';
include '../lib/php-barcode.php';
if ($q = $_REQUEST['q']) {
$items = item_find($db, $q, 0);
if (!$items) {
die_json("No items found.");
}
} else {
$id = (int) $_REQUEST['id'];
$items = array(item_load($db, $id));
if (!$items[0]) {
die_json("No such item.");
}
}
$trim = $_REQUEST['trim'];
$left_margin = 0.2;
$label_width = 2.0;
$label_height = 0.75;
$basefontsize = 9;
$vmargin = 0.1;
$dummy = new AlphaPDF('P', 'in', array($label_width, $label_height));
$pdf = new AlphaPDF('P', 'in', array($label_width, $label_height));
foreach ($items as $item) {
$pdf->AddPage();
$pdf->Rotate(270);
$pdf->SetFont('Helvetica', '');
$pdf->SetFontSize($size = $basefontsize);
$txn_id = (int) $_REQUEST['txn'];
$item = (int) $_REQUEST['item'];
$search = $_REQUEST['q'];
if (!$search && !$item) {
die_jsonp('no query specified');
}
if ($txn_id) {
$txn = txn_load($db, $txn_id);
if ($txn['paid']) {
die_jsonp("This order is already paid!");
}
}
if (!$search) {
$search = "item:{$item}";
}
$items = item_find($db, $search, $_REQUEST['all'] ? FIND_ALL : 0);
// limit ourselves to 10 items
array_splice($items, 10);
/* if it is just one item, go ahead and add it to the invoice */
if (count($items) == 1) {
if (!$txn_id) {
$q = "START TRANSACTION;";
$r = $db->query($q);
if (!$r) {
die_query($db, $q);
}
$q = "SELECT 1 + MAX(number) AS number FROM txn WHERE type = 'customer'";
$r = $db->query($q);
if (!$r) {
die_query($db, $q);
}
<?php
include '../scat.php';
include '../lib/item.php';
$q = $_GET['q'];
if (!$q) {
exit;
}
$options = 0;
if ($_REQUEST['all']) {
$options += FIND_ALL;
}
if ($_REQUEST['or']) {
$options += FIND_OR;
}
if ($_REQUEST['sales']) {
$options += FIND_SALES;
}
$items = item_find($db, $q, $options);
echo jsonp(array('items' => $items));
