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