public function activesubscriptionAction()
{
$producturrency = new Admin_Model_DbTable_Countries();
$id = $this->_request->getParam('id', 0);
$this->modelSubscription = new Publisher_Model_DbTable_Subscriptions();
if ($id > 0 && $this->modelSubscription->isExist($id)) {
$data['status'] = 1;
$success = $this->modelSubscription->update($data, 'id="' . $id . '"');
if ($success) {
echo "Subscription deleted successfully." . "#####";
echo "<fieldset class='dashboard_fieldset'>\n\t\t<legend>Store Price</legend><table width='100%' class='table-list' border='0' cellspacing='0' cellpadding='0'><tr>\n\t\t<td width='50%'><div align='left'><strong>Store</strong></div></td>\n\t\t<td width='30%'><div align='left'><strong>Language</strong></div></td>\n\t\t<td width='10%'><div align='left'><strong>Subscription type</strong></div></td>\n\t\t<td width='10%'><div align='left'><strong>Number of issues</strong></div></td>\n\t\t<td width='10%'><div align='left'><strong>Price</strong></div></td>\n\t\t<td width='20%'><div align='left'><strong>Group Price</strong></div></td>\n\t\t<td width='10%'><div align='left'><strong>Action</strong></div></td>\n\t\t</tr>";
$modelSubscription = new Publisher_Model_DbTable_Subscriptions();
$subscriptionList = $modelSubscription->getSubscriptionList($_POST['productid']);
for ($jj = 0; $jj < count($subscriptionList); $jj++) {
$deletePriceUrl = $this->view->url(array('module' => 'publisher', 'controller' => 'book', 'action' => 'deletesubscription', 'id' => $subscriptionList[$jj]['id']), '', true);
echo "<tr><td><div align='left'>";
$modelCountry = new Publisher_Model_DbTable_Books();
$producturrency = new Admin_Model_DbTable_Countries();
$countryRecord = $modelCountry->getCountryName($subscriptionList[$jj]['country_sub']);
echo $countryRecord['country'];
echo "</div></td><td><div align='left'>";
$modelLanguage = new Publisher_Model_DbTable_Books();
$languageRecord = $modelLanguage->getLanguageName($subscriptionList[$jj]['language_sub']);
echo $languageRecord['language_name'];
echo "</div></td><td><div align='left'>";
echo $subscriptionList[$jj]['subscription_type'];
echo "</div></td><td><div align='left'>";
echo $subscriptionList[$jj]['number_of_issues'];
echo "</div></td><td><div align='left'>";
echo $producturrency->getCurrencyInfo($subscriptionList[$jj]['country_sub']) . "" . $subscriptionList[$jj]['individual_price'];
echo "</div></td><td><div align='left'>";
echo $producturrency->getCurrencyInfo($subscriptionList[$jj]['country_sub']) . $subscriptionList[$jj]['group_price_sub'];
echo "</div></td><td><div align='left'>";
/*echo "<a class='action-icon' href='".$deletePriceUrl."' onclick='return deletesubscription(this.href);' title='Delete'>";
echo "<img src='".$this->view->serverUrl().$this->view->baseUrl()."/public/css/publisher/images/trash.gif' height='10' width='10'>";
echo "</a> ";*/
?>
<?php
if ($subscriptionList[$jj]['status'] == '1') {
?>
<a class="action-icon" href="<?php
echo $this->view->url(array('module' => 'publisher', 'controller' => 'book', 'action' => 'inactivesubscription', 'id' => $subscriptionList[$jj]['id']), '', true);
?>
" title="Deactivate Subscription" onclick="return inactivesubscription(this.href,'tab2','book');"><img alt="Active" src="<?php
echo $this->view->serverUrl() . $this->view->baseUrl();
?>
/public/css/admin/images/active.png"/></a>
<?php
} else {
?>
<a class="action-icon" href="<?php
echo $this->view->url(array('module' => 'publisher', 'controller' => 'book', 'action' => 'activesubscription', 'id' => $subscriptionList[$jj]['id']), '', true);
?>
" title="Activate Subscription" onclick="return activesubscription(this.href,'tab2','book');"><img alt="Inactive" src="<?php
echo $this->view->serverUrl() . $this->view->baseUrl();
?>
/public/css/admin/images/inactive.png"/></a>
<?php
}
?>
<a href="javascript:void(0);" onclick="return updatesubscription1('<?php
echo $subscriptionList[$jj]['id'];
?>
','<?php
echo $this->view->serverUrl() . $this->view->baseUrl() . "/publisher/book/savesubscription";
?>
','<?php
echo $_POST['productid'];
?>
','<?php
echo $subscriptionList[$jj]['id'];
?>
','<?php
echo $this->view->serverUrl() . $this->view->baseUrl() . "/publisher/book/savesubscription";
?>
','<?php
echo $_POST['productid'];
?>
');">
<img src="<?php
echo $this->view->serverUrl() . $this->view->baseUrl() . "/public/css/publisher/images/icon_edit.png";
?>
" width="10" height="10"/>
</a>
<?php
echo "</div></td></tr>";
}
if (count($subscriptionList) == 0) {
echo "<tr><td colspan='6' align='center'>No Record Found</td></tr>";
}
if (!empty($price_error)) {
foreach ($price_error as $error_msg) {
echo "<tr><td colspan='4'><strong><font color='red'>" . $error_msg . "</font></strong></td></tr>";
}
}
echo "</table></fieldset>";
exit;
} else {
echo "<font color='red'><strong>Sorry!, unable to activate subscription</strong></font>";
exit;
}
}
}
function displayorderAction()
{
########################## data ###########################
$orderIdForPurchase = $this->_getParam('orderid');
$producturrency = new Admin_Model_DbTable_Countries();
$modelAuthor = new Publisher_Model_DbTable_Publishers();
$tempObj = new Model_DbTable_Checkout();
$creditHistoryObj = new User_Model_DbTable_Chistory();
$transactionHistoryObj = new User_Model_DbTable_Transactionhistory();
$productPrice = new Publisher_Model_DbTable_BookPrices();
$modelImage = new Publisher_Model_DbTable_BookImages();
$modelStore = new Admin_Model_DbTable_Countries();
$productPrice = new Publisher_Model_DbTable_BookPrices();
$modelSubscription = new Publisher_Model_DbTable_Subscriptions();
$this->modelBooks = 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();
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);
}
$datahistory = "<div class='top_heading'>\t\t\t\t\n\t\t \t<div class='item'>Item(s)</div>\n\t\t <div class='prices'>Subscription Type</div>\n\t\t <div class='prices'>Price</div>";
if ($company_data->account_type == '1') {
$datahistory .= "<div class='quantity'>Qty</div>";
} else {
$datahistory .= "<div class='quantity'> </div>";
}
$datahistory .= "<div class='total'>Total</div>\n\t\t </div>";
$orderData = $creditHistoryObj->fetchAll("order_id='" . $orderIdForPurchase . "'");
$dataDet = '';
foreach ($orderData as $dataDet) {
$price = $dataDet['price'];
$subscription_data = $modelSubscription->fetchAll('id="' . $dataDet['subscription_type'] . '"');
$product_details = $this->modelBooks->fetchRow("id='" . $dataDet['bookid'] . "'");
$transaction_details = $transactionHistoryObj->fetchRow("id='" . $dataDet['transaction_id'] . "'");
$catInfo = $this->modelBooks->getCategoryInfo($product_details['cat_id']);
$getCurrencyName = $producturrency->getCurrencyCode($dataDet['store_id']);
$authorInfo = $modelAuthor->getInfoByPublisherId($product_details['publisher_id']);
$imageInfo = $modelImage->getImageInfoByProductId($product_details['id']);
$total_price = $total_price + $producturrency->currencyconverter($getCurrencyName, "NGN", $dataDet['quantity'] * $price);
if ($dataDet['payment_status'] == 1) {
$orderStatus = 'Approved';
} elseif ($dataDet['payment_status'] == 2) {
$orderStatus = 'Declined';
} else {
$orderStatus = 'Pending';
}
if (count($subscription_data) > 0) {
$subtype = $subscription_data[0]->subscription_type;
} else {
$subtype = "N/A";
}
$datahistory .= '<div class="cart_detail">
<div class="item_content">
<img src="' . $this->view->serverUrl() . $this->view->baseUrl() . '/' . USER_UPLOAD_DIR . 'thumb1_' . $imageInfo['image_name'] . '" width="140" height="175" alt="">
<h5>' . stripslashes($dataDet['book_name']) . '</h5>';
if ($authorInfo['first_name'] != '') {
$datahistory .= '<span><em>by: </em> ' . stripslashes($authorInfo['first_name'] . ' ' . $authorInfo['last_name']) . '</span>';
}
$datahistory .= '<span><em>Category: </em> ' . stripslashes($catInfo['category_name']) . '</span>
<span><em>publisher:</em> ' . stripslashes($authorInfo['publisher']) . '</span>
</div>
<div class="space_content"></div>
<div class="prices_content">' . $subtype . '</div>
<div class="prices_content">₦' . $producturrency->currencyconverter($getCurrencyName, "NGN", $price) . '</div>
<div style="float: left;padding: 5% 0;text-align: center;width: 70px;">
<div class="">';
if ($dataDet['group_id'] != 0) {
$datahistory .= '<div >' . $dataDet['quantity'] . '</div>';
}
$datahistory .= '</div>
</div>
<div class="total_content">₦' . @number_format($producturrency->currencyconverter($getCurrencyName, "NGN", $dataDet['quantity'] * $price), 2) . '</div>
</div>';
if ($company_data->account_type == '1') {
$finalsubprice = $finalsubprice + $dataDet['quantity'] * $price;
} else {
$finalsubprice = $finalsubprice + $price;
}
}
$datahistory .= '<div class="shipping_total">
<div class="row">
<div class="lt">Subtotal</div>
<div class="rt">₦' . @number_format($total_price, 2) . '</div>
</div>
<div class="row" style="border:none;">
<div class="lt">Tax</div>
<div class="rt">₦' . '00.00</div>
</div>
<div class="row subtotal">
<div class="lt">Total</div>
<div class="rt">₦' . @number_format($total_price, 2) . '</div>
</div>
<div class="row subtotal">
<div class="lt">Order Id</div>
<div class="rt">' . $orderIdForPurchase . '</div>
</div>
<div class="row subtotal">
<div class="lt">Payment Status</div>
<div class="rt">' . $orderStatus . '</div>
</div>
</div>';
$this->view->datahistory = $datahistory;
$this->view->orderId = $orderIdForPurchase;
$this->view->transactionId = $orderData[0]['transaction_id'];
$this->view->orderStatus = $orderStatus;
$this->view->responseDescription = $transaction_details['responseDescription'];
}
