public function cartAction() { $tempObj = new Model_DbTable_Checkout(); $formdata = $this->getRequest()->getPost(); $creditHistoryObj = new User_Model_DbTable_Chistory(); $UsersubObj = new Model_DbTable_Usersubscription(); $product_details = new Publisher_Model_DbTable_Books(); $storage_company = new Zend_Auth_Storage_Session('company_type'); $company_data = $storage_company->read(); $storage = new Zend_Auth_Storage_Session('account_type'); $data = $storage->read(); $modelSubscription = new Publisher_Model_DbTable_Subscriptions(); $subscription_price = 0; if ($data->id) { $user_id = $data->id; } elseif ($company_data->id) { $user_id = $company_data->id; } if ($company_data->account_type == '1') { $groupObj = new Company_Model_DbTable_Groups(); $groupList = $groupObj->getGroupList($company_data->id); } if (count($groupList) > 0 && $_POST['subscription_type'] == '') { $group_id = $groupList[0]['id']; } /* else { $group_id = 0; //$price_to_show = $subscription_data[0]->individual_price; } */ $group_id = 0; $sessionid = session_id(); if ($this->getRequest()->isPost()) { $product_id = $formdata['product_id']; //$user_id = $formdata['user_id']; $user_type = $formdata['user_type']; $store_id = $formdata['store_id']; $getallData = $tempObj->fetchAll("session_id='" . $sessionid . "' and product_id='" . $product_id . "' and user_id='" . $user_id . "'"); $quntity = $formdata['quantity']; if ($_POST['chk_button'] == 'Subscribe') { $subscription_type = $_POST['subscription_type']; $subscription_data = $modelSubscription->fetchAll('id="' . $subscription_type . '"'); } else { $subscription_type = ""; $subscription_data = ""; } if ($company_data->account_type == '1' && count($subscription_data) > 0) { $subscription_price = $subscription_data[0]->group_price_sub; $subscription_name = $subscription_data[0]->subscription_type; $subscription_store = $subscription_data[0]->country_sub; $subscription_language = $subscription_data[0]->language_sub; $subscription_issues = $subscription_data[0]->number_of_issues; $company_id = $user_id; } if ($company_data->account_type != '1' && count($subscription_data) > 0) { $subscription_price = $subscription_data[0]->individual_price; $subscription_name = $subscription_data[0]->subscription_type; $subscription_store = $subscription_data[0]->country_sub; $subscription_language = $subscription_data[0]->language_sub; $subscription_issues = $subscription_data[0]->number_of_issues; $company_id = $user_id; } //$purchasedBook = $creditHistoryObj->fetchAll("bookid ='".$product_id."' and userid='".$user_id."' and payment_status=1"); $data_product = $product_details->fetchAll('id="' . $product_id . '"'); if ($data_product[0]['cat_id'] == '3') { $purchasedBook = $UsersubObj->fetchAll("product_id ='" . $product_id . "' and user_id='" . $user_id . "'"); } if ($data_product[0]['cat_id'] != '3' && count($subscription_data) == 0) { $purchasedBook = $UsersubObj->fetchAll("product_id ='" . $product_id . "' and user_id='" . $user_id . "'"); } /* else if($data_product[0]['cat_id']!='3' && count($subscription_data)>0) { $purchasedBook = $UsersubObj->fetchAll("product_id ='".$product_id."' and user_id='".$user_id."' and subscription_type='".$_POST['subscription_type']."'"); } */ if (count($purchasedBook) > 0) { $is_purchase = 1; } else { $is_purchase = 0; } /* if($group_id!='0' && $formdata['subscription_type']=='') { $this->modelCompany = new Company_Model_DbTable_Companies(); $listGroupMember = $this->modelCompany->getMemberByGroupId($group_id); $quntity = count($listGroupMember); } */ if ($quntity == '' && $company_data->account_type != '1') { $quntity = '1'; } else { $quntity = '0'; } if (count($getallData) == 0) { $data_array = array("product_id" => $product_id, "store_id" => $store_id, "user_id" => $user_id, "user_type" => $user_type, "session_id" => $sessionid, "quntity" => $quntity, "group_id" => $group_id, "is_purchase" => $is_purchase, "subscription_type" => $subscription_type, "subscription_name" => $subscription_name, "subscription_price" => $subscription_price, "subscription_store" => $subscription_store, "subscription_language" => $subscription_language, "subscription_issues" => $subscription_issues, "company_id" => $company_id); $tempObj->insert($data_array); } else { $data_array = array("subscription_type" => $subscription_type, "subscription_price" => $subscription_price, "quntity" => $quntity, "subscription_store" => $subscription_store, "subscription_language" => $subscription_language, "subscription_name" => $subscription_name, "subscription_issues" => $subscription_issues); $where = "session_id='" . $sessionid . "' and product_id='" . $product_id . "'"; $tempObj->update($data_array, $where); } } $this->view->sesid = $sessionid; }