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