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