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