/**
overriding the basic form since I need several extra fields
*/
protected function basicForm()
{
global $FANNIE_OP_DB, $FANNIE_URL;
$dbc = FannieDB::get($FANNIE_OP_DB);
$vendors = new VendorsModel($dbc);
ob_start();
?>
<form enctype="multipart/form-data" class="form-horizontal" action="<?php
echo $_SERVER['PHP_SELF'];
?>
" id="FannieUploadForm" method="post">
<div class="form-group col-sm-6">
<label class="control-label col-sm-3">Vendor</label>
<div class="col-sm-9"><select name=vendorID class="form-control">
<?php
foreach ($vendors->find('vendorName') as $v) {
printf("<option %s value=%d>%s</option>", $v->vendorName() == 'SPARTAN NASH' ? 'selected' : '', $v->vendorID(), $v->vendorName());
}
?>
</select></div>
</div>
<div class="form-group col-sm-6">
<label class="control-label col-sm-3">Order Date</label>
<div class="col-sm-9"><input type="text" class="form-control date-field" name="orderDate" id="orderDate" /></div>
</div>
<div class="form-group col-sm-6">
<label class="control-label col-sm-3">PO#/Invoice#</label>
<div class="col-sm-9"><input type="text" class="form-control" name="identifier" /></div>
</div>
<div class="form-group col-sm-6">
<label class="control-label col-sm-3">Recv'd Date</label>
<div class="col-sm-9"><input type="text" class="form-control date-field" name="recvDate" id="recvDate" /></div>
</div>
<div class="form-group col-sm-6">
<label class="control-label col-sm-3">Filename</label>
<div class="col-sm-9"><input type="file" class="form-control" name="FannieUploadFile" id="FannieUploadFile" /></div>
</div>
<div class="form-group col-sm-6">
<button type="submit" class="btn btn-default">Upload File</button>
<button type="button" class="btn btn-default"
onclick="location='PurchasingIndexPage.php'; return false;">Home</button>
</div>
<?php
return ob_get_clean();
}
function form_content()
{
$dbc = FannieDB::get($this->config->get('OP_DB'));
ob_start();
?>
<form method = "get" action="<?php
echo $_SERVER['PHP_SELF'];
?>
">
<div class="col-sm-5">
<div class="form-group">
<label>Date Start</label>
<input type=text id=date1 name=date1
class="form-control date-field" required />
</div>
<div class="form-group">
<label>Date End</label>
<input type=text id=date2 name=date2
class="form-control date-field" required />
</div>
<div class="form-group">
<label>Vendor</label>
<select name="vendorID" class="form-control">
<option value="">All</option>
<?php
$vendors = new VendorsModel($dbc);
foreach ($vendors->find('vendorName') as $obj) {
printf('<option value="%d">%s</option>', $obj->vendorID(), $obj->vendorName());
}
?>
</select>
</div>
<p>
<button type="submit" class="btn btn-default btn-core">Submit</button>
<button type="reset" class="btn btn-default btn-reset">Start Over</button>
</p>
</div>
<div class="col-sm-5">
<?php
echo FormLib::date_range_picker();
?>
</div>
</form>
<?php
return ob_get_clean();
}
function post_save_handler()
{
global $FANNIE_OP_DB;
$upcs = FormLib::get('upc', array());
if (!is_array($upcs) || empty($upcs)) {
echo 'Error: invalid data';
return false;
}
$dept = FormLib::get('dept');
$tax = FormLib::get('tax');
$local = FormLib::get('local');
$brand = FormLib::get('brand');
$vendor = FormLib::get('vendor');
$dbc = FannieDB::get($FANNIE_OP_DB);
$vlookup = new VendorsModel($dbc);
for ($i = 0; $i < count($upcs); $i++) {
$model = new ProductsModel($dbc);
$upc = BarcodeLib::padUPC($upcs[$i]);
$model->upc($upc);
$model->store_id(1);
if (isset($dept[$i])) {
$model->department($dept[$i]);
}
if (isset($tax[$i])) {
$model->tax($tax[$i]);
}
if (isset($local[$i])) {
$model->local($local[$i]);
}
if (isset($brand[$i])) {
$model->brand($brand[$i]);
}
if (isset($vendor[$i])) {
$vlookup->reset();
$vlookup->vendorName($vendor[$i]);
foreach ($vlookup->find('vendorID') as $obj) {
$model->default_vendor_id($obj->vendorID());
break;
}
}
if (in_array($upc, FormLib::get('fs', array()))) {
$model->foodstamp(1);
} else {
$model->foodstamp(0);
}
if (in_array($upc, FormLib::get('disc', array()))) {
$model->discount(1);
} else {
$model->discount(0);
}
if (in_array($upc, FormLib::get('scale', array()))) {
$model->scale(1);
} else {
$model->scale(0);
}
$model->modified(date('Y-m-d H:i:s'));
$try = $model->save();
if ($try) {
$model->pushToLanes();
} else {
$this->save_results[] = 'Error saving item ' . $upc;
}
if (isset($vendor[$i]) && $vendor[$i] != '' || isset($brand[$i]) && $brand[$i] != '') {
$extra = new ProdExtraModel($dbc);
$extra->upc($upc);
if (isset($vendor[$i]) && $vendor[$i] != '') {
$extra->distributor($vendor[$i]);
}
if (isset($brand[$i]) && $brand[$i] != '') {
$extra->manufacturer($brand[$i]);
}
$extra->save();
}
$this->upcs[] = $upc;
}
return true;
}
public function post_file_view()
{
$inv_no = '';
$inv_date = '';
$po_no = '';
$line = 0;
for ($line; $line < count($this->filedata); $line++) {
$data = $this->filedata[$line];
if (isset($data[4]) && $data[4] == 'Invoice No:') {
$inv_no = $data[6];
} elseif (isset($data[4]) && $data[4] == 'PO #:') {
$po_no = $data[6];
} elseif (isset($data[4]) && $data[4] == 'Order Date:') {
$inv_date = \COREPOS\Fannie\API\data\FileData::excelFloatToDate($data[6]);
} elseif (in_array('Ordered', $data) && in_array('Price', $data)) {
break;
// item data begins
}
}
$ret = '<form method="post">';
$ret .= '<div class="form-group">
<label>Invoice #</label>
<input type="text" name="invoice_num" class="form-control" value="' . $inv_no . '" />
</div>';
$ret .= '<div class="form-group">
<label>PO #</label>
<input type="text" name="po_num" class="form-control" value="' . $po_no . '" />
</div>';
$ret .= '<div class="form-group">
<label>Invoice Date</label>
<input type="text" name="invoice_date" class="form-control date-field" value="' . $inv_date . '" />
</div>';
$dbc = FannieDB::get($this->config->get('OP_DB'));
$vendors = new VendorsModel($dbc);
$ret .= '<div class="form-group">
<label>Vendor</label>
<select class="form-control" name="vendorID">';
$vendorID = 0;
foreach ($vendors->find('vendorName') as $obj) {
$ret .= sprintf('<option %s value="%d">%s</option>', preg_match('/cpw/i', $obj->vendorName()) ? 'selected' : '', $obj->vendorID(), $obj->vendorName());
if (preg_match('/cpw/i', $obj->vendorName())) {
$vendorID = $obj->vendorID();
}
}
$ret .= '</select></div>';
$ret .= '<table class="table">
<tr>
<th>SKU</th>
<th>UPC</th>
<th>Item</th>
<th>Unit Size</th>
<th>Case Size</th>
<th># of Cases</th>
<th>Unit Cost</th>
<th>Total Cost</th>
</tr>';
$upcP = $dbc->prepare('
SELECT upc
FROM vendorItems
WHERE vendorID=?
AND sku=?');
for ($line; $line < count($this->filedata); $line++) {
$data = $this->filedata[$line];
if (!is_numeric($data[0]) || !is_numeric($data[5]) || !is_numeric($data[7])) {
// not an item line
continue;
}
$numCases = $data[1];
$description = $data[2];
$sku = $data[5];
$caseCost = $data[6];
$totalCost = $data[7];
list($caseSize, $unitSize) = $this->caseAndUnit($description);
$unitCost = $caseCost / $caseSize;
$upc = '';
$upcR = $dbc->execute($upcP, array($vendorID, $sku));
if ($upcR && $dbc->numRows($upcR)) {
$upcW = $dbc->fetchRow($upcR);
$upc = $upcW['upc'];
}
$ret .= sprintf('<tr>
<td><input type="text" name="sku[]" size="8" value="%s" class="form-control input-sm" /></td>
<td><input type="text" name="upc[]" size="13" value="%s" class="form-control upc-field input-sm" /></td>
<td><input type="text" name="desc[]" value="%s" class="form-control input-sm" /></td>
<td><input type="text" name="size[]" size="3" value="%s" class="form-control input-sm" /></td>
<td><input type="text" name="units[]" size="4" value="%s" class="form-control input-sm" /></td>
<td><input type="text" name="qty[]" size="3" value="%d" class="form-control input-sm" /></td>
<td>
<div class="input-group">
<div class="input-group-addon">$</div>
<input type="text" name="unitCost[]" size="5" value="%.2f" class="form-control input-sm" />
</div>
</td>
<td>
<div class="input-group">
<div class="input-group-addon">$</div>
<input type="text" name="totalCost[]" size="5" value="%.2f" class="form-control input-sm" />
</div>
</td>
</tr>', $sku, $upc, $description, $unitSize, $caseSize, $numCases, $unitCost, $totalCost);
}
$ret .= '</table>
<p>
<button type="submit" class="btn btn-default">Import Invoice</button>
</p>
</form>';
$this->addScript('../../item/autocomplete.js');
$this->addOnloadCommand("bindAutoComplete('.upc-field', '../../ws/', 'item');\n");
return $ret;
}
$descript = str_replace("'", "", $descript);
$descript = str_replace("\"", "", $descript);
$descript = $sql->escape($descript);
if (empty($manufacturer)) {
$manufacturer = '';
}
if (empty($distributor)) {
$distributor = '';
}
$manufacturer = str_replace("'", "", $manufacturer);
$distributor = str_replace("'", "", $distributor);
// lookup vendorID by name
$vendorID = 0;
$vendor = new VendorsModel($sql);
$vendor->vendorName($distributor);
foreach ($vendor->find('vendorID') as $obj) {
$vendorID = $obj->vendorID();
break;
}
$stamp = date("Y-m-d H:i:s");
$model = new ProductsModel($sql);
$model->upc($upc);
$model->description($descript);
$model->brand($manufacturer);
$model->normal_price($price);
$model->tax($tax);
$model->scale($Scale);
$model->foodstamp($FS);
$model->department($dept);
$model->inUse($inUse);
$model->modified($stamp);
function post_u_view()
{
global $FANNIE_OP_DB, $FANNIE_URL;
$this->addScript('from-search.js');
$ret = '<form action="BatchFromSearch.php" method="post">';
$ret .= '<div class="form-group form-inline">';
$dbc = FannieDB::get($FANNIE_OP_DB);
$types = $dbc->query('SELECT batchTypeID, typeDesc, discType FROM batchType');
$discTypes = array();
$ret .= '<select name="batchType" id="batchType" class="form-control"
onchange="discountTypeFixup()">';
while ($row = $dbc->fetch_row($types)) {
$ret .= sprintf('<option value="%d">%s</option>', $row['batchTypeID'], $row['typeDesc']);
$discTypes[] = $row;
}
$ret .= '</select>';
foreach ($discTypes as $row) {
$ret .= sprintf('<input type="hidden" id="discType%d" value="%d" />', $row['batchTypeID'], $row['discType']);
}
$name = FannieAuth::checkLogin();
$ret .= '
<label>Name</label>: ';
$ret .= '<input type="text" class="form-control" name="batchName" value="' . ($name ? $name : 'Batch') . ' ' . date('M j') . '" />';
$ret .= '
<label>Start</label>: <input type="text" class="form-control date-field" id="startDate" value="' . date('Y-m-d') . '" name="startDate" />
';
$ret .= '
<label>End</label>: <input type="text" class="form-control date-field" id="endDate" value="' . date('Y-m-d') . '" name="endDate" />
</div>';
$owners = $dbc->query('SELECT super_name FROM MasterSuperDepts GROUP BY super_name ORDER BY super_name');
$ret .= '<div class="form-group form-inline">
<label>Owner</label>: <select name="batchOwner" class="form-control" id="batchOwner"><option value=""></option>';
while ($row = $dbc->fetch_row($owners)) {
$ret .= '<option>' . $row['super_name'] . '</option>';
}
$ret .= '<option>IT</option></select>
<button type="submit" name="createBatch" value="1"
class="btn btn-default">Create Batch</button>
</div>';
$ret .= '<hr />';
list($in_sql, $args) = $dbc->safeInClause($this->upcs);
$query = 'SELECT p.upc, p.description, p.normal_price, m.superID,
MAX(CASE WHEN v.srp IS NULL THEN 0.00 ELSE v.srp END) as srp
FROM products AS p
LEFT JOIN vendorItems AS v ON p.upc=v.upc AND p.default_vendor_id=v.vendorID
LEFT JOIN MasterSuperDepts AS m ON p.department=m.dept_ID
WHERE p.upc IN ( ' . $in_sql . ')
GROUP BY p.upc, p.description, p.normal_price, m.superID
ORDER BY p.upc';
$prep = $dbc->prepare($query);
$result = $dbc->execute($prep, $args);
$ret .= '<div id="saleTools" class="form-group form-inline">';
$ret .= '<label>Markdown</label>
<div class="input-group">
<input type="text" id="mdPercent" class="form-control" value="10" onchange="markDown(this.value);" />
<span class="input-group-addon">%</span>
</div>
<button type="submit" class="btn btn-default" onclick="markDown($(\'#mdPercent\').val()); return false">Go</button>';
$ret .= ' ';
$ret .= '<label>or</label>
<div class="input-group">
<span class="input-group-addon">$</span>
<input type="text" id="mdDollar" class="form-control" value="0.00" onchange="discount(this.value);" />
</div>
<button type="submit" class="btn btn-default" onclick="discount($(\'#mdDollar\').val()); return false">Go</button>';
$ret .= '</div>';
$ret .= '<div id="priceChangeTools" class="form-group form-inline">';
$ret .= '<button type="submit" class="btn btn-default" onclick="useSRPs(); return false;">Use Vendor SRPs</button>';
$ret .= ' ';
$ret .= '<select name="preferredVendor" class="form-control" onchange="reCalcSRPs();">
<option value="0">Auto Choose Vendor</option>';
$vendors = new VendorsModel($dbc);
foreach ($vendors->find('vendorName') as $vendor) {
$ret .= sprintf('<option value="%d">%s</option>', $vendor->vendorID(), $vendor->vendorName());
}
$ret .= '</select>';
$ret .= ' ';
$ret .= '<label>Markup</label>
<div class="input-group">
<input type="text" id="muPercent" class="form-control" value="10" onchange="markUp(this.value);" />
<span class="input-group-addon">%</span>
</div>
<button type="submit" class="btn btn-default" onclick="markUp($(\'#muPercent\').val()); return false">Go</button>';
$ret .= ' ';
$ret .= '<label>Tags</label> <select name="tagset" class="form-control" id="tagset"><option value="">No Tags</option>';
$queues = new ShelfTagQueuesModel($dbc);
$ret .= $queues->toOptions();
$ret .= '</select>';
$ret .= '</div>';
$ret .= '<table class="table">';
$ret .= '<tr><th>UPC</th><th>Description</th><th>Retail</th>
<th id="newPriceHeader">Sale Price</th></tr>';
$superDetect = array();
while ($row = $dbc->fetch_row($result)) {
$ret .= sprintf('<tr class="batchItem">
<td><input type="hidden" name="upc[]" class="itemUPC" value="%s" />%s</td>
<td>%s</td>
<td>$%.2f<input type="hidden" class="currentPrice" value="%.2f" /></td>
<td><div class="input-group">
<span class="input-group-addon">$</span>
<input type="text" name="price[]" class="itemPrice form-control" value="0.00" />
<input type="hidden" class="itemSRP" value="%.2f" />
</div>
</td>
</tr>', $row['upc'], $row['upc'], $row['description'], $row['normal_price'], $row['normal_price'], $row['srp']);
if (!isset($superDetect[$row['superID']])) {
$superDetect[$row['superID']] = 0;
}
$superDetect[$row['superID']]++;
}
$ret .= '</table>';
$ret .= '</form>';
// auto-detect likely owner & tag set by super department
$tagPage = array_search(max($superDetect), $superDetect);
if ($tagPage !== false) {
$this->add_onload_command("\$('#tagset').val({$tagPage});\n");
$this->add_onload_command("\$('#batchOwner').val(\$('#tagset option:selected').text());\n");
}
// show sale or price change tools as appropriate
$this->add_onload_command('discountTypeFixup();');
// don't let enter key on these fields trigger form submission
$this->add_onload_command("\$('#mdPercent').bind('keypress', noEnter);\n");
$this->add_onload_command("\$('#mdDollar').bind('keypress', noEnter);\n");
$this->add_onload_command("\$('#muPercent').bind('keypress', noEnter);\n");
return $ret;
}
function form_content()
{
global $FANNIE_OP_DB;
$dbc = FannieDB::get($FANNIE_OP_DB);
$deptQ = $dbc->prepare_statement("select dept_no,dept_name from departments order by dept_no");
$deptR = $dbc->exec_statement($deptQ);
$depts = array();
while ($deptW = $dbc->fetch_array($deptR)) {
$depts[$deptW['dept_no']] = $deptW['dept_name'];
}
$superQ = $dbc->prepare_statement("SELECT superID,super_name FROM superDeptNames \n ORDER BY superID");
$superR = $dbc->exec_statement($superQ);
$supers = array();
while ($superW = $dbc->fetch_row($superR)) {
$supers[$superW['superID']] = $superW['super_name'];
}
$subs = array();
if (count($depts) > 0) {
$dept_numbers = array_keys($depts);
$first = $dept_numbers[0];
$subsP = $dbc->prepare('
SELECT subdept_no,
subdept_name
FROM subdepts
WHERE dept_ID=?
ORDER BY subdept_no');
$subsR = $dbc->execute($subsP, array($first));
while ($subsW = $dbc->fetch_row($subsR)) {
$subs[$subsW['subdept_no']] = $subsW['subdept_name'];
}
}
ob_start();
?>
<form method="get" action="ProductListPage.php">
<ul class="nav nav-tabs" role="tablist">
<li class="active"><a href="#dept-tab" data-toggle="tab"
onclick="$('#supertype').val('dept');">By Department</a></li>
<li><a href="#manu-tab" data-toggle="tab"
onclick="$('#supertype').val('manu');">By Brand</a></li>
<li><a href="#vendor-tab" data-toggle="tab"
onclick="$('#supertype').val('vendor');">By Vendor</a></li>
</ul>
<input id="supertype" name="supertype" type="hidden" value="dept" />
<div class="tab-content">
<p>
<div class="tab-pane active" id="dept-tab">
<div class="row form-horizontal">
<div class="col-sm-8">
<?php
echo FormLib::standardDepartmentFields('deptSub');
?>
</div>
</div>
</div>
<div class="tab-pane" id="manu-tab">
<div class="form-group form-inline">
<label><?php
echo _('Brand');
?>
</label>
<input type=text name=manufacturer class="form-control" />
</div>
<div class="form-group form-inline">
<label><input type=radio name=mtype value=prefix checked />
UPC prefix</label>
<label><input type=radio name=mtype value=name />
<?php
echo _('Brand name');
?>
</label>
</div>
</div>
<div class="tab-pane" id="vendor-tab">
<div class="form-group form-inline">
<label>Vendor</label>
<select name="vendor" class="form-control">
<?php
$vendors = new VendorsModel($dbc);
foreach ($vendors->find('vendorName') as $v) {
printf('<option value="%d">%s</option>', $v->vendorID(), $v->vendorName());
}
?>
</select>
</div>
</div>
</p>
</div>
<div class="form-group form-inline">
<label>Sort by</label>
<select name="sort" class="form-control">
<option>Department</option>
<option>UPC</option>
<option>Description</option>
</select>
<label>
<input type=checkbox name="inUse" value="1" checked />
In Use
</label>
|
<label>
<input type=checkbox name=excel />
Excel
</label>
</div>
<?php
if ($this->config->get('STORE_MODE') == 'HQ') {
$picker = FormLib::storePicker();
echo '<div class="form-group form-inline">
<label>Store</label> ' . $picker['html'] . '</div>';
}
?>
<p>
<button type=submit name=submit class="btn btn-default btn-core">Submit</button>
<button type=reset id="reset-btn" class="btn btn-default btn-reset"
onclick="$('#super-id').val('').trigger('change');">Start Over</button>
</p>
</form>
<?php
return ob_get_clean();
}
public function get_view()
{
$dbc = FannieDB::get($this->config->get('OP_DB'));
$ret = '<form action="' . $_SERVER['PHP_SELF'] . '" method="get">
<div class="form-group">
<label>Vendor</label>
<select name="id" class="form-control">';
$vendors = new VendorsModel($dbc);
foreach ($vendors->find('vendorName') as $obj) {
$ret .= sprintf('<option value="%d">%s</option>', $obj->vendorID(), $obj->vendorName());
}
$ret .= '</select>
</div>
<div class="form-group">
<button type="submit" class="btn btn-default">Continue</button>
</div>';
return $ret;
}
public function post_file_view()
{
$invoice_num = false;
$invoice_date = false;
$po_num = false;
$items = array();
$lines = explode("\n", $this->file_content);
$pattern = '/\\d+\\s+(\\d+)\\s+[^0-9]*(\\d\\d\\d+)\\s+(.*?)\\s\\s+(.*?)\\s+([0-9-]+)\\s+\\d+\\s+\\$?([0-9\\.]+)\\s+\\$?([0-9\\.]+)\\s+\\$?([0-9\\.]+)/';
echo '<form action="' . $_SERVER['PHP_SELF'] . '" method="post">';
echo '<table class="table">';
echo '<tr><thead>
<th>SKU</th>
<th>UPC</th>
<th>Description</th>
<th>Total Cost</th>
<th># Cases</th>
<th>Units/Case</th>
<th>Unit Size</th>
<th>Unit Cost</th>
</tr>
</thead>';
for ($i = 0; $i < count($lines); $i++) {
$line = trim($lines[$i]);
$fields = preg_split('/\\s{2,}/', $line);
if (count($fields) == 0) {
continue;
}
if ($i == 1 && count($fields) >= 6) {
$invoice_num = $fields[2];
$po_num = $fields[3];
$invoice_date = $fields[5];
} else {
if (!preg_match($pattern, $line, $matches)) {
/**
Excessively wide fields can break the layout and split the single PDF line
into two text lines. Try joining consecutive lines and see if they
match the single-line pattern
*/
if ($i + 1 < count($lines) && preg_match($pattern, $line . ' ' . $lines[$i + 1], $matches)) {
$i++;
} else {
continue;
}
}
$numCases = $matches[1];
$sku = $matches[2];
$description = $matches[3];
list($caseSize, $unitSize) = $this->caseAndUnit($description);
$upc = $matches[5];
if (strlen($upc) == 5 && $upc[0] == '9') {
$upc = substr($upc, 1);
} elseif (strstr($upc, '-')) {
$upc = substr($upc, 0, strlen($upc) - 1);
}
$upc = str_replace('-', '', $upc);
$upc = BarcodeLib::padUPC($upc);
$receivedCost = $matches[7];
printf('<tr>
<td><input type="number" class="form-control input-sm" name="sku[]" value="%s" /></td>
<td><input type="number" class="form-control input-sm" name="upc[]" value="%s" /></td>
<td><input type="text" class="form-control input-sm" name="description[]" value="%s" /></td>
<td>
<div class="input-group">
<span class="input-group-addon">$</span>
<input type="text" class="form-control input-sm" name="total[]" value="%.2f" />
</div>
</td>
<td><input type="number" class="form-control input-sm" name="cases[]" value="%s" /></td>
<td><input type="text" class="form-control input-sm" name="units[]" value="%s" /></td>
<td><input type="text" class="form-control input-sm" name="size[]" value="%s" /></td>
<td>
<div class="input-group">
<span class="input-group-addon">$</span>
<input type="text" class="form-control input-sm" name="cost[]" value="%.2f" />
</div>
</td>
</tr>', $sku, $upc, $description, $receivedCost, $numCases, $caseSize, $unitSize, $receivedCost / $numCases / $caseSize);
}
}
echo '</table>';
printf('<div class="form-group">
<label>Invoice #</label>
<input type="text" name="invoice_num" value="%s" class="form-control" />
</div>', $invoice_num);
printf('<div class="form-group">
<label>PO #</label>
<input type="text" name="po_num" class="form-control" value="%s" />
</div>', $po_num);
printf('<div class="form-group">
<label>Invoice Date</label>
<input type="text" class="form-control date-field" name="invoice_date" value="%s" />
</div>', $invoice_date);
$dbc = FannieDB::get($this->config->get('OP_DB'));
$vendors = new VendorsModel($dbc);
echo '<div class="form-group">
<label>Vendor</label>
<select class="form-control" name="vendorID">';
foreach ($vendors->find('vendorName') as $obj) {
printf('<option %s value="%d">%s</option>', preg_match('/albert/i', $obj->vendorName()) ? 'selected' : '', $obj->vendorID(), $obj->vendorName());
}
echo '</select></div>';
echo '<p>
<button type="submit" class="btn btn-default">Import Invoice</button>
</p>';
echo '</form>';
}
function AjaxCallback()
{
$db = $this->db();
$json = array();
if (FormLib::get('action') == 'addVendor') {
$name = FormLib::get('newVendorName');
if (empty($name)) {
$json['error'] = 'Name is required';
} else {
$vendor = new VendorsModel($db);
$vendor->vendorName($name);
if (count($vendor->find()) > 0) {
$json['error'] = 'Vendor "' . $name . '" already exists';
} else {
$max = $db->query('SELECT MAX(vendorID) AS max
FROM vendors');
$newID = 1;
if ($max && ($maxW = $db->fetch_row($max))) {
$newID = (int) $maxW['max'] + 1;
}
$vendor->vendorAbbreviation(substr($name, 0, 10));
$vendor->vendorID($newID);
$vendor->save();
$json['vendorID'] = $newID;
$json['vendorName'] = $name;
}
}
} elseif (FormLib::get('dept_defaults') !== '') {
$json = array('tax' => 0, 'fs' => False, 'nodisc' => False);
$dept = FormLib::get_form_value('dept_defaults', '');
$p = $db->prepare_statement('SELECT dept_tax,dept_fs,dept_discount
FROM departments WHERE dept_no=?');
$r = $db->exec_statement($p, array($dept));
if ($db->num_rows($r)) {
$w = $db->fetch_row($r);
$json['tax'] = $w['dept_tax'];
if ($w['dept_fs'] == 1) {
$json['fs'] = True;
}
if ($w['dept_discount'] == 0) {
$json['nodisc'] = True;
}
}
} elseif (FormLib::get('vendorChanged') !== '') {
$v = new VendorsModel($db);
$v->vendorName(FormLib::get('vendorChanged'));
$matches = $v->find();
$json = array('error' => false);
if (count($matches) == 1) {
$json['localID'] = $matches[0]->localOriginID();
$json['vendorID'] = $matches[0]->vendorID();
} else {
$json['error'] = true;
}
}
echo json_encode($json);
}
/**
First page. Show vendor list.
*/
function get_view()
{
global $FANNIE_OP_DB;
$model = new VendorsModel(FannieDB::get($FANNIE_OP_DB));
$ret = '';
$ret .= '<form class="form" action="EditOnePurchaseOrder.php" method="get">';
$ret .= '<div class="form-group">';
$ret .= '<label>Select a vendor</label>';
$ret .= '<select name="id" class="form-control">';
foreach ($model->find('vendorName') as $vendor) {
$ret .= sprintf('<option value="%d">%s</option>', $vendor->vendorID(), $vendor->vendorName());
}
$ret .= '</select>';
$ret .= '</div>';
$ret .= '<p><button type="submit" class="btn btn-default">Go</button>';
$ret .= ' ';
$ret .= '<button type="button" class="btn btn-default"
onclick="location=\'PurchasingIndexPage.php\'; return false;">Home</button></p>';
$ret .= '</form>';
return $ret;
}
public function get_view()
{
$dbc = $this->connection;
$dbc->selectDB($this->config->OP_DB);
$prep = $dbc->prepare("\n SELECT superID,\n super_name \n FROM MasterSuperDepts\n WHERE superID > 0\n GROUP BY superID,\n super_name");
$res = $dbc->execute($prep);
$opts = "<option value=99 selected>All</option>";
while ($row = $dbc->fetch_row($res)) {
$opts .= "<option value={$row['0']}>{$row['1']}</option>";
}
$vmodel = new VendorsModel($dbc);
$vopts = "";
foreach ($vmodel->find('vendorName') as $obj) {
$vopts .= sprintf('<option value="%d">%s</option>', $obj->vendorID(), $obj->vendorName());
}
$queues = new ShelfTagQueuesModel($dbc);
$qopts = $queues->toOptions();
ob_start();
?>
<form action=VendorPricingBatchPage.php method="get">
<label>Select a Vendor</label>
<select name="id" class="form-control">
<?php
echo $vopts;
?>
</select>
<label>and a Super Department</label>
<select name=super class="form-control">
<?php
echo $opts;
?>
</select>
<label>Show all items</label>
<select name=filter class="form-control">
<option>No</option>
<option>Yes</option>
</select>
<label>Shelf Tag Queue</label>
<select name="queueID" class="form-control">
<?php
echo $qopts;
?>
</select>
<br />
<p>
<button type=submit class="btn btn-default">Continue</button>
</p>
</form>
<?php
return ob_get_clean();
}
