public function form_content() { $ret = '<form method="get"> <div class="col-sm-5"> <label>Coupon</label> <select name="coupon_id" class="form-control">'; $dbc = $this->connection; $dbc->selectDB($this->config->get('OP_DB')); $hc = new HouseCouponsModel($dbc); foreach ($hc->find() as $obj) { if ($obj->description() == '') { continue; } $ret .= sprintf('<option value="%s">%s</option>', $obj->coupID(), $obj->description()); } $ret .= '</select> <p> <button type="submit" class="btn btn-default">Submit</button> </p> </div>'; $ret .= FormLib::standardDateFields(); $ret .= '</form>'; return $ret; }
private function listHouseCoupons() { $FANNIE_URL = $this->config->get('URL'); $this->add_script($FANNIE_URL . 'src/javascript/fancybox/jquery.fancybox-1.3.4.js?v=1'); $this->add_css_file($FANNIE_URL . 'src/javascript/fancybox/jquery.fancybox-1.3.4.css'); $dbc = FannieDB::get($this->config->get('OP_DB')); $ret = '<form action="HouseCouponEditor.php" method="get">'; $ret .= '<p>'; $ret .= '<button type="submit" name="new_coupon_submit" class="btn btn-default" value="New Coupon">New Coupon</button>'; $ret .= ' '; $ret .= '<button type="button" class="fancybox-btn btn btn-default" href="explainify.html">Explanation of Settings</button>'; $this->add_onload_command('$(\'.fancybox-btn\').fancybox();'); $ret .= '</p>'; $ret .= '</form>'; $ret .= '<table class="table">'; $ret .= '<tr><th>ID</th><th>Name</th><th>Value</th><th>Expires</th></tr>'; $model = new HouseCouponsModel($dbc); foreach ($model->find('coupID') as $obj) { if (strstr($obj->endDate(), ' ')) { $tmp = explode(' ', $obj->endDate()); $obj->endDate($tmp[0]); } $report_dates = array(date('Y-m-d', strtotime($obj->startDate())), date('Y-m-d', strtotime($obj->endDate()))); /** If coupon period is more than 45 days, use the current month as a reporting period */ if (strtotime($report_dates[1]) - strtotime($report_dates[0]) > 86400 * 45) { $report_dates = array(date('Y-m-01'), date('Y-m-t')); } $ret .= sprintf('<tr><td>#%d <a href="HouseCouponEditor.php?edit_id=%d">Edit</a></td> <td>%s</td><td>%.2f%s</td><td>%s</td> <td> <a href="%sws/barcode-pdf/?upc=%s&name=%s" class="btn btn-default">Print Barcode</a> <a href="%sreports/ProductMovement/ProductMovementModular.php?upc=%s&date1=%s&date2=%s" class="btn btn-default">Usage Report</a> <a href="%smodules/plugins2.0/CoreWarehouse/reports/CWCouponReport.php?coupon-id=%d&date1=%s&date2=%s" class="btn btn-default %s">Member Baskets</a> </tr>', $obj->coupID(), $obj->coupID(), $obj->description(), $obj->discountValue(), $obj->discountType(), $obj->endDate(), $FANNIE_URL, '499999' . str_pad($obj->coupID(), 5, '0', STR_PAD_LEFT), urlencode($obj->description()), $FANNIE_URL, '499999' . str_pad($obj->coupID(), 5, '0', STR_PAD_LEFT), $report_dates[0], $report_dates[1], $FANNIE_URL, $obj->coupID(), $report_dates[0], $report_dates[1], \COREPOS\Fannie\API\FanniePlugin::isEnabled('CoreWarehouse') ? '' : 'collapse'); } $ret .= '</table>'; $dbc->close(); return $ret; }