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 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 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(); }
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>
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(); }