public function indexAction()
{
try {
$coupon_form = new Application_Form_CouponForm();
$this->view->form = $coupon_form;
$couponsMapper = new Application_Model_CouponsMapper();
$coupons = new Application_Model_Coupons();
$request = $this->getRequest();
if ($request->isPost()) {
$request_type = $request->getParam("request_type", false);
if ($request_type) {
if ($request_type == "add") {
$params = $request->getParams();
if ($coupon_form->isValid($params)) {
foreach ($params as $param => $value) {
$coupons->__set($param, $value);
}
if ($couponsMapper->addNewCoupon($coupons)) {
$this->view->message = "Coupon added successfully";
$this->view->hasMessage = true;
$this->view->messageType = "success";
} else {
$this->view->message = "Error occured while adding. Please try again";
$this->view->hasMessage = true;
$this->view->messageType = "danger";
}
} else {
$this->view->message = "Error occured while Adding. Please fill form correctly";
$this->view->hasMessage = true;
$this->view->messageType = "danger";
}
} elseif ($request_type == "delete") {
$id = $request->getParam("id");
if ($couponsMapper->deleteCouponById($id)) {
$this->view->hasMessage = true;
$this->view->messageType = "success";
$this->view->message = "Coupon deleted successfully.";
} else {
$this->view->hasMessage = true;
$this->view->messageType = "danger";
$this->view->message = "Error occured while deleting. Please try again.";
}
}
}
}
$coupon = $couponsMapper->getAllCoupons();
$this->view->coupons = $coupon;
$this->authorised = true;
} catch (Exception $ex) {
$this->authorised = false;
$this->view->hasMessage = true;
$this->view->messageType = "danger";
$this->view->message = $ex->getMessage();
}
}
public function getCouponByCouponCode($code)
{
//$where = array("LOWER(coupon_code) =?" => strtolower($code));
$query = "SELECT * FROM coupons WHERE LOWER(`coupon_code`)='" . strtolower($code) . "'";
$stmt = $this->_db_table->getAdapter()->query($query);
$result = $stmt->fetch();
//$result = $this->_db_table->fetchRow($where);
//print_r($result);echo "jfj";
if (!$result) {
return false;
}
$coupon_object = new Application_Model_Coupons();
foreach ($result as $key => $value) {
$coupon_object->__set($key, $value);
}
return $coupon_object;
}
