function body_content()
{
global $FANNIE_OP_DB;
$dbc = FannieDB::get($FANNIE_OP_DB);
$qmodel = new ShelfTagQueuesModel($dbc);
$deptSubList = $qmodel->toOptions();
$ret = '';
if (!empty($this->msgs)) {
$ret .= '<div class="alert alert-success">';
$ret .= $this->msgs;
$ret .= '</div>';
}
ob_start();
?>
<form action="CreateTagsByManu.php" method="get">
<div class="form-group">
<label>Name or UPC prefix</label>
<input type="text" name="manufacturer" id="manu-field"
class="form-control" required />
</div>
<div class="form-group">
<label>Page</label>
<select name="sID" class="form-control">
<?php
echo $deptSubList;
?>
</select>
</div>
<p>
<button type="submit" class="btn btn-default">Create Shelftags</button>
</p>
</form>
<?php
$this->add_onload_command('$(\'#manu-field\').focus();');
return $ret . ob_get_clean();
}
function body_content()
{
global $FANNIE_OP_DB, $FANNIE_URL;
$vid = FormLib::get_form_value('vid');
if ($vid === '') {
return "<i>Error: no vendor selected</i>";
}
$dbc = FannieDB::get($FANNIE_OP_DB);
$cats = "";
$p = $dbc->prepare_statement("SELECT i.vendorDept, d.name \n FROM vendorItems AS i\n LEFT JOIN vendorDepartments AS d\n ON i.vendorID=d.vendorID AND i.vendorDept=d.deptID\n WHERE i.vendorID=?\n GROUP BY i.vendorDept, d.name\n ORDER BY i.vendorDept");
$rp = $dbc->exec_statement($p, array($vid));
while ($rw = $dbc->fetch_row($rp)) {
if ($rw['vendorDept'] == 0 && empty($rw['name'])) {
continue;
}
$cats .= "<option value={$rw['0']}>{$rw['0']} {$rw['1']}</option>";
}
if ($cats == "") {
$cats = "<option value=\"\">Select a subcategory...</option><option selected>All</option>";
$this->addOnloadCommand('catchange()');
} else {
$cats = "<option value=\"\">Select a subcategory...</option>" . $cats;
}
ob_start();
?>
<div id="categorydiv" class="form-inline">
<select id=categoryselect onchange="catchange();" class="form-control">
<?php
echo $cats;
?>
</select>
<select id=brandselect onchange="brandchange();" class="form-control">
<option>Select a subcategory first...</option>
</select>
<select id="shelftags" class="form-control">
<option value="-1">Shelf Tag Page</option>
<?php
$queues = new ShelfTagQueuesModel($dbc);
echo $queues->toOptions();
?>
</select>
</div>
<hr />
<div id="contentarea">
<?php
if (isset($_REQUEST['did'])) {
echo showCategoryItems($vid, $_REQUEST['did']);
}
?>
</div>
<div id="loading-bar" class="col-sm-6 collapse">
<div class="progress">
<div class="progress-bar progress-bar-striped active" style="width:100%;"
role="progressbar" aria-valuenow="100" aria-valuemin="0" aria-valuemax="100">
<span class="sr-only">Loading</span>
</div>
</div>
</div>
<input type="hidden" id="vendorID" value="<?php
echo $vid;
?>
" />
<input type="hidden" id="urlpath" value="<?php
echo $FANNIE_URL;
?>
" />
<p><a href="VendorIndexPage.php?vid=<?php
echo $vid;
?>
" class="btn btn-default">Home</a></p>
<?php
$this->add_script('browse.js');
return ob_get_clean();
}
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;
}
public function delete_id_upc_view()
{
$dbc = $this->connection;
$dbc->selectDB($this->config->get('OP_DB'));
$tag = new ShelftagsModel($dbc);
$tag->id($this->id);
$tag->upc(BarcodeLib::padUPC($this->upc));
$tag->load();
$ret = <<<HTML
<form action="{{SELF}}" method="post">
<div class="panel panel-default">
<div class="panel-heading">Selected Tag</div>
<div class="panel-body">
{{upc}} - {{brand}} {{description}}
</div>
</div>
<div class="panel panel-default">
<div class="panel-heading">Delete</div>
<div class="panel-body">
<div class="form-group">
<a href="?_method=delete&id={{id}}&upc={{upc}}&confirm=1" class="btn btn-danger">
{{ICON}} Remove Tag from Queue
</a>
</div>
</div>
</div>
<div class="panel panel-default">
<div class="panel-heading">Move</div>
<div class="panel-body">
<div class="form-group">
<label>Move to another Queue</label>
<select name="newID" class="form-control">
{{QUEUES}}
</select>
</div>
<div class="form-group">
<button class="btn btn-default" type="submit">Move Tag</button>
</div>
<input type="hidden" name="oldID" value="{{id}}" />
<input type="hidden" name="upc" value="{{upc}}" />
</div>
</div>
</form>
HTML;
$queues = new ShelfTagQueuesModel($dbc);
$ret = str_replace('{{SELF}}', $_SERVER['PHP_SELF'], $ret);
$ret = str_replace('{{id}}', $this->id, $ret);
$ret = str_replace('{{upc}}', $this->upc, $ret);
$ret = str_replace('{{brand}}', $tag->brand(), $ret);
$ret = str_replace('{{description}}', $tag->description(), $ret);
$ret = str_replace('{{QUEUES}}', $queues->toOptions(), $ret);
$ret = str_replace('{{ICON}}', \COREPOS\Fannie\API\lib\FannieUI::deleteIcon(), $ret);
return $ret;
}
>
</div>
<p>
<label>Price</label>
<span class="alert-success h3">
<strong><?php
printf("%.2f", $price);
?>
</strong>
</span>
<input type='hidden' name='price' size=8 value=<?php
echo $price;
?>
/>
<button type="submit" class="btn btn-default"
name="submit" value="New">Create Tag</button>
</p>
<div class="form-group form-inline">
<label>Barcode page</label>
<select name=subID class="form-control">
<?php
$qm = new ShelfTagQueuesModel($dbc);
echo $qm->toOptions($superID);
?>
</select>
</div>
</form>
</div>
</body>
</html>
function body_content()
{
global $FANNIE_OP_DB;
ob_start();
?>
<div class="col-sm-8">
<ul class="nav nav-tabs" role="tablist">
<li class="active"><a href="ShelfTagIndex.php">Regular shelf tags</a></li>
<li><a href="BatchShelfTags.php">Batch shelf tags</a></li>
</ul>
<p>
<div class="form-group form-inline">
<label>Offset</label>:
<input type="number" class="price-field form-control" id=offset value=0 />
<label>Layout</label>:
<select id=layoutselector class="form-control">
<?php
foreach ($this->layouts as $l) {
if ($l == $this->config->get('DEFAULT_PDF')) {
echo "<option selected>" . $l . "</option>";
} else {
echo "<option>" . $l . "</option>";
}
}
?>
</select>
<label>Sort</label>:
<select id="tag-sort" class="form-control">
<option>Department</option>
<option>Alphabetically</option>
<option>Order Entered</option>
</select>
</div>
</p>
<table class="table">
<?php
$dbc = FannieDB::get($FANNIE_OP_DB);
$query = $dbc->prepare("\n SELECT s.shelfTagQueueID, \n s.description, \n count(distinct t.upc) AS ct\n FROM ShelfTagQueues AS s\n LEFT JOIN shelftags AS t ON s.shelfTagQueueID = t.id\n GROUP BY shelfTagQueueID,\n s.description\n ORDER BY shelfTagQueueID");
$result = $dbc->execute($query);
if ($dbc->numRows($result) == 0) {
$queues = new ShelfTagQueuesModel($dbc);
$queues->initQueues();
$result = $dbc->execute($query);
}
$rows = array();
while ($row = $dbc->fetch_row($result)) {
$rows[] = $row;
}
$zeroID = $dbc->query('SELECT upc FROM shelftags WHERE id=0');
array_unshift($rows, array(0, 'Default', $dbc->numRows($zeroID)));
foreach ($rows as $row) {
$this->printRow($row);
}
?>
</table>
</div>
<div class="col-sm-3">
<a href="CreateTagsByDept.php">Create Tags By Department</a>
<br />
<a href="CreateTagsByManu.php">Create Tags By Brand</a>
</div>
<?php
return ob_get_clean();
}
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();
}
function body_content()
{
global $FANNIE_OP_DB;
$dbc = FannieDB::get($FANNIE_OP_DB);
$deptsQ = $dbc->prepare_statement("select dept_no,dept_name from departments order by dept_no");
$deptsR = $dbc->exec_statement($deptsQ);
$deptsList = "";
$qmodel = new ShelfTagQueuesModel($dbc);
$deptSubList = $qmodel->toOptions();
while ($deptsW = $dbc->fetch_array($deptsR)) {
$deptsList .= "<option value={$deptsW['0']}>{$deptsW['0']} {$deptsW['1']}</option>";
}
$ret = '';
if (!empty($this->msgs)) {
$ret .= '<div class="alert alert-success">';
$ret .= $this->msgs;
$ret .= '</div>';
}
ob_start();
?>
<form action="CreateTagsByDept.php" method="get">
<div class="row form-group form-horizontal">
<label class="col-sm-2">Department Start</label>
<div class="col-sm-4">
<select onchange="$('#deptStart').val($(this).val());"
class="form-control">
<?php
echo "{$deptsList}\n";
?>
</select>
</div>
<div class="col-sm-2">
<input type=text name=deptStart id=deptStart class="form-control" value=1 />
</div>
</div>
<div class="row form-group form-horizontal">
<label class="col-sm-2">Department End</label>
<div class="col-sm-4">
<select onchange="$('#deptEnd').val($(this).val());"
class="form-control">
<?php
echo "{$deptsList}\n";
?>
</select>
</div>
<div class="col-sm-2">
<input type=text name=deptEnd id=deptEnd class="form-control" value=1 />
</div>
</div>
<div class="row form-group form-horizontal">
<label class="col-sm-2">Page</label>
<div class="col-sm-4">
<select name="sID" class="form-control">
<?php
echo $deptSubList;
?>
</select>
</div>
<div class="col-sm-2">
<button type="submit" class="btn btn-default">Create Shelftags</button>
</div>
</div>
</form>
<?php
return $ret . ob_get_clean();
}
