public function showEditForm($upc, $display_mode = 1, $expand_mode = 1)
{
$upc = BarcodeLib::padUPC($upc);
$dbc = $this->db();
$p = $dbc->prepare_statement('SELECT * FROM scaleItems WHERE plu=?');
$r = $dbc->exec_statement($p, array($upc));
$scale = array('itemdesc' => '', 'weight' => 0, 'bycount' => 0, 'tare' => 0, 'shelflife' => 0, 'label' => 133, 'graphics' => 0, 'text' => '', 'netWeight' => 0);
$found = false;
if ($dbc->num_rows($r) > 0) {
$scale = $dbc->fetch_row($r);
$found = true;
}
if (!$found && $display_mode == 2 && substr($upc, 0, 3) != '002') {
return '';
}
$css = '';
if ($expand_mode == 1) {
$css = '';
} else {
if ($found && $expand_mode == 2) {
$css = '';
} else {
$css = 'display:none;';
}
}
$ret = '<div id="ScaleItemFieldset" class="panel panel-default">';
$ret .= "<div class=\"panel-heading\">\n <a href=\"\" onclick=\"\$('#ScaleFieldsetContent').toggle();return false;\">\n Scale</a>\n </div>";
$ret .= '<div id="ScaleFieldsetContent" class="panel-body" style="' . $css . '">';
$p = $dbc->prepare_statement('SELECT description FROM products WHERE upc=?');
$r = $dbc->exec_statement($p, array($upc));
$reg_description = '';
if ($dbc->num_rows($r) > 0) {
$w = $dbc->fetch_row($r);
$reg_description = $w['description'];
}
$ret .= sprintf('<input type="hidden" name="s_plu" value="%s" />', $upc);
$ret .= "<table style=\"background:#ffffcc;\" class=\"table\">";
$ret .= sprintf("<tr><th colspan=2>Longer description</th><td colspan=5><input size=35 \n type=text name=s_longdesc maxlength=100 value=\"%s\" \n class=\"form-control\" /></td></tr>", $reg_description == $scale['itemdesc'] ? '' : $scale['itemdesc']);
$ret .= "<tr><th>Weight</th><th>By Count</th><th>Tare</th><th>Shelf Life</th>";
$ret .= "<th>Net Wt (oz)</th><th>Label</th><th>Safehandling</th></tr>";
$ret .= '<tr><td><select name="s_type" class="form-control" size="2">';
if ($scale['weight'] == 0) {
$ret .= "<option value=\"Random Weight\" selected /> Random</option>";
$ret .= "<option value=\"Fixed Weight\" /> Fixed</option>";
} else {
$ret .= "<option value=\"Random Weight\" /> Random</option>";
$ret .= "<option value=\"Fixed Weight\" selected /> Fixed</option>";
}
$ret .= '</select></td>';
$ret .= sprintf("<td align=center><input type=checkbox value=1 name=s_bycount %s /></td>", $scale['bycount'] == 1 ? 'checked' : '');
$ret .= sprintf("<td align=center><input type=text class=\"form-control\" name=s_tare value=\"%s\" /></td>", $scale['tare']);
$ret .= sprintf("<td align=center><input type=text class=\"form-control\" name=s_shelflife value=\"%s\" /></td>", $scale['shelflife']);
$ret .= sprintf("<td align=center><input type=text class=\"form-control\" name=s_netwt value=\"%s\" /></td>", $scale['netWeight']);
$ret .= "<td><select name=s_label size=2 class=\"form-control\">";
$label_attr = \COREPOS\Fannie\API\item\ServiceScaleLib::labelToAttributes($scale['label']);
if ($label_attr['align'] == 'horizontal') {
$ret .= "<option value=horizontal selected>Horizontal</option>";
$ret .= "<option value=vertical>Vertical</option>";
} else {
$ret .= "<option value=horizontal>Horizontal</option>";
$ret .= "<option value=vertical selected>Vertical</option>";
}
$ret .= '</select></td>';
$ret .= sprintf("<td align=center><input type=checkbox value=1 name=s_graphics %s /></td>", $scale['graphics'] > 0 ? 'checked' : '');
$ret .= '</tr>';
$ret .= "<tr><td colspan=7>";
$ret .= '<div class="col-sm-6">';
$ret .= "<b>Expanded text:<br />\n <textarea name=s_text rows=4 cols=45 class=\"form-control\">";
$ret .= $scale['text'];
$ret .= "</textarea>";
$ret .= '</div>';
$scales = new ServiceScalesModel($dbc);
$mapP = $dbc->prepare('SELECT upc
FROM ServiceScaleItemMap
WHERE serviceScaleID=?
AND upc=?');
$deptP = $dbc->prepare('SELECT p.upc
FROM products AS p
INNER JOIN superdepts AS s ON p.department=s.dept_ID
WHERE p.upc=?
AND s.superID=?');
$ret .= '<div class="col-sm-6">';
foreach ($scales->find('description') as $scale) {
$checked = false;
$mapR = $dbc->execute($mapP, array($scale->serviceScaleID(), $upc));
if ($dbc->num_rows($mapR) > 0) {
// marked in map table
$checked = true;
} else {
$deptR = $dbc->execute($deptP, array($upc, $scale->superID()));
if ($dbc->num_rows($deptR) > 0) {
// in a POS department corresponding
// to this scale
$checked = true;
}
}
$css_class = '';
$title = '';
if ($checked) {
$online = \COREPOS\Fannie\API\item\ServiceScaleLib::scaleOnline($scale->host());
$css_class = $online ? 'has-success' : 'has-danger';
$title = $online ? 'Scale Online' : 'Scale Offline';
}
$ret .= sprintf('<div class="form-group %s" title="%s"><div class="checkbox">
<label class="control-label">
<input type="checkbox" name="scaleID[]" id="scaleID%d" value=%d %s />
%s</label>
</div></div>', $css_class, $title, $scale->serviceScaleID(), $scale->serviceScaleID(), $checked ? 'checked' : '', $scale->description());
}
$ret .= '</div>';
$ret .= "</td></tr>";
$ret .= '</table></div></div>';
return $ret;
}
public function preview_content()
{
$scales = new ServiceScalesModel($this->connection);
$ret = '<fieldset><legend>Send to Scales</legend>';
foreach ($scales->find('description') as $obj) {
$ret .= sprintf('<label>
<input type="checkbox" name="scales[]" value="%d" /> %s
</label><br />', $obj->serviceScaleID(), $obj->description());
}
$ret .= '</fieldset>';
$ret .= '<label><input type="checkbox" name="prodPricing" />
Update POS Product Pricing</label>';
return $ret;
}
function post_u_view()
{
global $FANNIE_OP_DB, $FANNIE_URL;
$this->add_script($FANNIE_URL . '/src/javascript/jquery.js');
$this->add_css_file($FANNIE_URL . '/src/style.css');
$ret = '';
$ret .= '<form action="SyncFromSearch.php" method="post">';
$scales = new ServiceScalesModel(FannieDB::get($FANNIE_OP_DB));
$ret .= '<div class="panel panel-default">
<div class="panel-heading">Scales</div>
<div class="panel-body">';
foreach ($scales->find('description') as $scale) {
$ret .= sprintf('<input type="checkbox" class="scaleID" name="scaleID[]"
id="scaleID%d" value="%d" />
<label for="scaleID%d">%s</label><br />', $scale->serviceScaleID(), $scale->serviceScaleID(), $scale->serviceScaleID(), $scale->description());
}
$ret .= '</div></div>';
$ret .= '<p><button type="submit" name="sendall" value="1"
class="btn btn-default">Sync All Items</button></p>';
$ret .= '<div id="alert-area"></div>';
$ret .= '<table class="table">';
$ret .= '<tr>
<th>UPC</th>
<th>Description</th>
<th>Price</th>
<th>Last Changed</th>
<th>Send Now</th>
</tr>';
$model = new ScaleItemsModel(FannieDB::get($FANNIE_OP_DB));
foreach ($this->upcs as $upc) {
$model->plu($upc);
if (!$model->load()) {
continue;
}
$ret .= sprintf('<tr id="row%s">
<td>%s</td>
<td>%s</td>
<td>%.2f</td>
<td>%s</td>
<td><button type="button" class="btn btn-default"
onclick="sendOne(\'%s\'); return false;">Sync Item</button></td>
<input type="hidden" name="upcs[]" value="%s" />
</tr>', $model->plu(), $model->plu(), $model->mergeDescription(), $model->price(), $model->modified(), $model->plu(), $model->plu());
}
$ret .= '</table>';
$ret .= '</form>';
return $ret;
}
public function get_view()
{
global $FANNIE_OP_DB;
$dbc = FannieDB::get($FANNIE_OP_DB);
$scales = new ServiceScalesModel($dbc);
$supers = array();
$result = $dbc->query('SELECT superID, super_name FROM superDeptNames ORDER BY super_name');
while ($row = $dbc->fetch_row($result)) {
$supers[$row['superID']] = $row['super_name'];
}
$ret = '<form action="' . $_SERVER['PHP_SELF'] . '" method="post">';
$ret .= '<table class="table">
<tr><th>Description</th><th>Host</th><th>Type</th><th>Scale Dept.</th><th>POS Super Dept</th>
<th>Store # (EP)</th><th>Dept # (EP)</th><th>Address # (EP)</th>
</tr>';
foreach ($scales->find('description') as $scale) {
$ret .= sprintf('<tr>
<input type="hidden" name="id[]" value="%d" />
<td><input type="text" name="description[]"
class="form-control" value="%s" /></td>
<td><input type="text" name="host[]"
class="form-control" value="%s" /></td>
<td><input type="text" name="type[]"
class="form-control" value="%s" /></td>
<td><input type="text" name="scaleDept[]"
class="form-control" value="%s" /></td>
', $scale->serviceScaleID(), $scale->description(), $scale->host(), $scale->scaleType(), $scale->scaleDeptName());
$ret .= '<td><select name="super[]" class="form-control">
<option value="">None</option>';
foreach ($supers as $id => $name) {
$ret .= sprintf('<option %s value="%d">%s</option>', $scale->superID() !== null && $scale->superID() == $id ? 'selected' : '', $id, $name);
}
$ret .= '</select></td>';
$ret .= sprintf('
<td><input type="text" name="store-no[]"
class="form-control" value="%d" /></td>
<td><input type="text" name="dept-no[]"
class="form-control" value="%d" /></td>
<td><input type="text" name="address-no[]"
class="form-control" value="%d" /></td>', $scale->epStoreNo(), $scale->epDeptNo(), $scale->epScaleAddress());
$ret .= '</tr>';
}
$ret .= '</table>';
$ret .= '<p><button type="submit" class="btn btn-default">Save Changes</button>';
$ret .= ' ';
$ret .= '<button type="button" class="btn btn-default"
onclick="location=\'ScaleEditor.php?new=true\';return false;">Add Scale</button>
</p>';
$ret .= '</form>';
return $ret;
}
