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