public function indexAction() { try { $item_price_form = new Application_Form_ItemPriceForm(); $this->view->form = $item_price_form; $itemPriceMapper = new Application_Model_ItemPriceMapper(); $item_price = new Application_Model_ItemPrice(); $request = $this->getRequest(); if ($request->isPost()) { $request_type = $request->getParam("request_type", false); if ($request_type) { if ($request_type == "add") { $params = $request->getParams(); if ($item_price_form->isValid($params)) { foreach ($params as $param => $value) { $item_price->__set($param, $value); } if ($itemPriceMapper->addNewItemPrice($item_price)) { $this->view->message = " Item Price Type 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 ($itemPriceMapper->deleteItemPriceById($id)) { $this->view->hasMessage = true; $this->view->messageType = "success"; $this->view->message = "Item Price deleted successfully."; } else { $this->view->hasMessage = true; $this->view->messageType = "danger"; $this->view->message = "Error occured while deleting. Please try again."; } } } } $itemPrices = $itemPriceMapper->getAllItemPrice(); $this->view->itemPrices = $itemPrices; $this->authorised = true; } catch (Exception $ex) { $this->authorised = false; $this->view->hasMessage = true; $this->view->messageType = "danger"; $this->view->message = $ex->getTraceAsString(); } }
public function getItemPriceByServiceIdCatIdDelName($service_id, $delivery_name, $category_id) { //echo $franchise_id;exit; $query = "SELECT * FROM `item_price`\n INNER JOIN `items` on items.item_id = item_price.item_id WHERE \n item_price.service_id= '" . $service_id . "' AND \n item_price.delivery_type_name= '" . $delivery_name . "' AND \n items.category_id='" . $category_id . "'"; // $query = "SELECT * FROM `item_price` // INNER JOIN `items` on items.item_id = item_price.item_id WHERE item_price.service_id= '".$service_id."' AND item_price.delivery_type_name= '".$delivery_name."' AND items.category_id='".$category_id."'"; // echo $query;exit; $stmt = $this->_db_table->getAdapter()->query($query); $result = $stmt->fetchAll(); //print_r($result);exit; if (count($result) == 0) { return false; } $price_arr_obj = array(); foreach ($result as $row) { $prices = new Application_Model_ItemPrice(); foreach ($row as $key => $value) { $prices->__set($key, $value); } $price_arr_obj[] = $prices; } return $price_arr_obj; }