private function getVendorInfo($id) { global $FANNIE_OP_DB, $FANNIE_ROOT; $dbc = FannieDB::get($FANNIE_OP_DB); $ret = ""; $nameQ = $dbc->prepare_statement("SELECT vendorName FROM vendors WHERE vendorID=?"); $nameR = $dbc->exec_statement($nameQ, array($id)); $model = new VendorsModel($dbc); $model->vendorID($id); $model->load(); $ret .= '<div>'; $ret .= "<b>Id</b>: {$id} <b>Name</b>: " . $model->vendorName(); $ret .= '</div>'; $itemQ = $dbc->prepare_statement("SELECT COUNT(*) FROM vendorItems WHERE vendorID=?"); $itemR = $dbc->exec_statement($itemQ, array($id)); $num = 0; if ($itemR && ($row = $dbc->fetch_row($itemR))) { $num = $row[0]; } $ret .= ' <div class="row"> <div class="container-fluid col-sm-3">'; $ret .= ' <div class="panel panel-default"> <div class="panel-heading">Catalog</div> <div class="panel-body"> This vendor contains ' . $num . ' items<br />'; if ($num > 0) { $ret .= "<a href=\"BrowseVendorItems.php?vid={$id}\">Browse vendor catalog</a>"; if ($num <= 750) { $ret .= "<br />"; $ret .= "<a href=\"EditVendorItems.php?id={$id}\">Edit vendor catalog</a>"; } } $ret .= "<br />"; $ret .= "<a href=\"DefaultUploadPage.php?vid={$id}\">Upload new vendor catalog</a>"; $ret .= "<br />"; $ret .= "<a href=\"VendorIndexPage.php?vid={$id}&autoAdd=1\">Add existing items to catalog</a>"; $ret .= '</div></div>'; $ret .= '</div><div class="container-fluid col-sm-3">'; $ret .= ' <div class="panel panel-default"> <div class="panel-heading">Mappings</div> <div class="panel-body">'; $ret .= "<a href=\"UploadPluMapPage.php?vid={$id}\">Upload PLU/SKU mapping</a>"; $ret .= "<br />"; $ret .= "<a href=\"SkuMapPage.php?id={$id}\">View or Edit PLU/SKU mapping</a>"; $ret .= "<br />"; $ret .= "<a href=\"UnitBreakdownPage.php?id={$id}\">View or Edit Breakdown mapping</a>"; $ret .= '</div></div>'; $ret .= '</div><div class="container-fluid col-sm-3">'; $ret .= ' <div class="panel panel-default"> <div class="panel-heading">Margin</div> <div class="panel-body">'; $itemQ = $dbc->prepare("SELECT COUNT(*) FROM vendorDepartments WHERE vendorID=?"); $itemR = $dbc->execute($itemQ, array($id)); $num = 0; if ($itemR && ($row = $dbc->fetch_row($itemR))) { $num = $row[0]; } $ret .= '<p>'; $ret .= "<a href=\"../../batches/UNFI/\">Vendor Price Batch Tools</a>"; $ret .= "</p><p>"; if ($num == 0) { $ret .= "<a href=\"VendorDepartmentEditor.php?vid={$id}\">This vendor's items are not yet arranged into subcategories</a>"; $ret .= '<p />'; $ret .= "<a href=\"VendorDepartmentUploadPage.php?vid={$id}\">Upload Subcategory List</a>"; } else { $ret .= "This vendor's items are divided into "; $ret .= $num . " subcategories"; $ret .= "<br />"; $ret .= "<a href=\"VendorDepartmentEditor.php?vid={$id}\">View or Edit vendor-specific margin(s)</a>"; $ret .= "<br />"; $ret .= "<a href=\"VendorMarginsPage.php?id={$id}\">And Even More Margins</a>"; $ret .= '<p />'; $ret .= "<a href=\"VendorDepartmentUploadPage.php?vid={$id}\">Upload Subcategory List</a>"; } $ret .= '</p>'; $ret .= ' <div class="form-group"> <div class="input-group"> <span class="input-group-addon">Shipping</span> <input type="text" id="vc-shipping" name="shipping" onchange="saveShipping(this.value);" title="Markup percentage to account for shipping fees" class="form-control" value="' . $model->shippingMarkup() * 100 . '" /> <span class="input-group-addon">%</span> </div> </div> <div class="form-group"> <div class="input-group"> <span class="input-group-addon">Discount Rate</span> <input type="text" id="vc-discount" name="discount-rate" title="Markdown percentage from catalog list costs" onchange="saveDiscountRate(this.value);" class="form-control" value="' . $model->discountRate() * 100 . '" /> <span class="input-group-addon">%</span> </div> </div>'; $ret .= '</div></div>'; $ret .= '</div></div>'; $ret .= ' <div class="panel panel-default"> <div class="panel-heading">Contact Info</div> <div class="panel-body"> <div class="form-alerts"></div>'; $ret .= '<form role="form" class="form-horizontal" onsubmit="saveVC(' . $id . '); return false;" id="vcForm">'; $ret .= '<div class="form-group"> <label for="vcPhone" class="control-label col-sm-1">Phone</label> <div class="col-sm-10"> <input type="tel" class="form-control" id="vcPhone" name="phone" value="' . $model->phone() . '" /> </div> </div>'; $ret .= '<div class="form-group"> <label for="vcFax" class="control-label col-sm-1">Fax</label> <div class="col-sm-10"> <input type="text" id="vcFax" class="form-control" name="fax" value="' . $model->fax() . '" /> </div> </div>'; $ret .= '<div class="form-group"> <label for="vcEmail" class="control-label col-sm-1">Email</label> <div class="col-sm-10"> <input type="text" class="form-control" id="vcEmail" name="email" value="' . $model->email() . '" /> </div> </div>'; $ret .= '<div class="form-group"> <label for="vcWebsite" class="control-label col-sm-1">Website</label> <div class="col-sm-10"> <input type="text" class="form-control" id="vcWebsite" name="website" value="' . $model->website() . '" /> </div> </div>'; $ret .= '<div class="form-group"> <label for="vc-local-id" class="control-label col-sm-1">Local</label> <div class="col-sm-10"> <select class="form-control" name="local-origin-id"> <option value="0">No</option>'; $origins = new OriginsModel($dbc); $origins->local(1); foreach ($origins->find('shortName') as $origin) { $ret .= sprintf('<option %s value="%d">%s</option>', $origin->originID() == $model->localOriginID() ? 'selected' : '', $origin->originID(), $origin->shortName()); } $ret .= '</select> </div> </div>'; $ret .= '<div class="form-group"> <label for="vcNotes" class="control-label col-sm-1">Ordering Notes</label> <div class="col-sm-10"> <textarea class="form-control" rows="5" name="notes" id="vcNotes">' . $model->notes() . '</textarea> </div> </div>'; $ret .= '<button type="submit" class="btn btn-default">Save Vendor Contact Info</button>'; $ret .= '</form>'; $ret .= '</div></div>'; $delivery = new VendorDeliveriesModel($dbc); $delivery->vendorID($id); $delivery->load(); $ret .= '<p class="form-inline form-group"><label class="control-label" for="deliverySelect">Delivery Schedule</label>: '; $ret .= '<select class="delivery form-control" name="frequency" id="deliverySelect"><option>Weekly</option></select>'; $ret .= ' <label for="regular" class="control-label">Regular</label>: <input type="checkbox" class="delivery" name="regular" id="regular" ' . ($delivery->regular() ? 'checked' : '') . ' />'; $dt = mktime(0, 0, 0, 6, 15, 2014); // date doesn't matter; just need a sunday $labels = ''; $checks = ''; for ($i = 0; $i < 7; $i++) { $func = strtolower(date('l', $dt)); $labels .= '<th><label for="' . $func . '">' . date('D', $dt) . '</label></th>'; $checks .= '<td><input type="checkbox" id="' . $func . '" name="' . $func . '" ' . ($delivery->{$func}() ? 'checked' : '') . ' class="delivery" /></td>'; $dt = mktime(0, 0, 0, date('n', $dt), date('j', $dt) + 1, date('Y', $dt)); } $ret .= '<table class="table"><tr>' . $labels . '</tr><tr>' . $checks . '</tr></table>'; $ret .= 'Next 2 deliveries: ' . '<span id="nextDelivery">' . date('D, M jS', strtotime($delivery->nextDelivery())) . '</span>' . ' and ' . '<span id="nextNextDelivery">' . date('D, M jS', strtotime($delivery->nextNextDelivery())) . '</span>'; $ret .= '</p>'; echo $ret; }