function exportorderhistoryAction() { $productPrice = new Publisher_Model_DbTable_BookPrices(); $producturrency = new Admin_Model_DbTable_Countries(); $modelCategory = new Publisher_Model_DbTable_Books(); $order_key = $this->_request->getParam('order_key'); $to_date = $this->_request->getParam('to_date'); $from_date = $this->_request->getParam('from_date'); $subscription_name = $this->_request->getParam('subscription_name'); $user_type = $this->_request->getParam('user_type'); $formData = $this->getRequest()->getPost(); $where = ''; if (isset($order_key) && $order_key != '') { $condition .= ' and order_id="' . $order_key . '"'; } if (isset($from_date) && $from_date != '') { $condition .= ' and date(start_date) ="' . $from_date . '"'; } if (isset($to_date) && $to_date != '') { $condition .= ' and date(end_date) ="' . $to_date . '"'; } if (isset($subscription_name) && $subscription_name != '') { $condition .= ' and subscription_name ="' . $subscription_name . '"'; } if (isset($user_type) && $user_type == 'individual') { $condition .= ' and user_id > 0 and group_id=0'; } if (isset($user_type) && $user_type == 'Group') { $condition .= ' and user_id > 0 and group_id > 0'; } $formData = $this->getRequest()->getPost(); $productData = $this->modelUserSubscription->fetchAll('subscription_type > 0 ' . $condition . ''); $productPrice = new Publisher_Model_DbTable_BookPrices(); $producturrency = new Admin_Model_DbTable_Countries(); $this->modelCompanydata = new Model_DbTable_Companies(); $this->group_members = new Company_Model_DbTable_Groups(); $request_list = $productData; if (count($request_list) > 0) { $csv_output = ""; //$csv_output.="First Name".$separator."Last Name".$separator."User Name".$separator."Country".$separator."Email".$separator."Phone\n"; $content = '<table class="table-list" cellpadding="0" cellspacing="0" width="100%"> <tr> <th>Order Id</th> <th>User</h> <th>Group Name</th> <th>Company User</th> <th>Title / Brand</th> <th>Subscription Name</th> <th>Number of issues</th> <th>Number of Downloaded issues</th> <th>Subscription Price</th> <th>Start Date</th> <th>End Date</th> </tr>'; $sNumber = 1; foreach ($request_list as $row) { $this->sessCompanyInfo = $this->modelCompanydata->getInfoByUserId($row['user_id']); $this->sesscompany_user = $this->modelCompanydata->getInfoByUserId($row['company_id']); $this->sessgroup_members = $this->group_members->getInfoByGroupId($row['group_id']); $modelCategory = new Publisher_Model_DbTable_Books(); $getProductInfo = $this->modelCompany->getProductInfo($row['product_id']); $getBrandInfo = $modelCategory->getBrandInfo($getProductInfo['title']); if (!empty($getBrandInfo)) { $titleBrand = $getBrandInfo['brand']; } else { $titleBrand = $getProductInfo['title']; } if (!empty($getProductInfo['parent_brand_id'])) { $productInfo = $this->modelCompany->getProductInfo($getProductInfo['parent_brand_id']); $getParentBrandInfo = $modelCategory->getBrandInfo($productInfo['title']); if (!empty($getParentBrandInfo)) { $titleBrand = $getParentBrandInfo['brand'] . " - " . $titleBrand; } } $getCurrencyName = $producturrency->getCurrencyCode($row['country']); $totNairaPrice = $producturrency->currencyconverter($getCurrencyName, "NGN", $row['subscription_price']); $content .= '<tr> <td>' . $row['order_id'] . '</td> <td>' . $this->sessCompanyInfo['first_name'] . " " . $this->sessCompanyInfo['last_name'] . '</td> <td>' . $this->sesscompany_user['first_name'] . " " . $this->sesscompany_user['last_name'] . '</td> <td>' . $this->sessgroup_members['group_name'] . '</td> <td>' . stripslashes($titleBrand) . '</td> <td>' . $row['subscription_name'] . '</td> <td>' . $row['number_of_issues'] . '</td> <td>' . $row['number_of_downloaded'] . '</td> <td>' . $producturrency->getCurrencyInfo($row['country']) . @number_format($totNairaPrice, 2) . '</td> <td>' . $row['start_date'] . '</td> <td>' . $row['end_date'] . '</td> </tr>'; $sNumber++; } } else { $content .= '<tr><td colspan="8" class="list-not-found">Data Not Found</td></tr>'; } $content .= '</table>'; $file = "subscription_report"; $filename = $file . "_" . time() . ".xls"; $test = $content; header("Content-type: application/vnd.ms-excel"); header("Content-Disposition: attachment; filename={$filename}"); echo $test; exit; }
public function freereportAction() { $producturrency = new Admin_Model_DbTable_Countries(); $this->view->messages = $this->_flashMessenger->getMessages(); $this->_helper->layout->disableLayout(); $formData = $this->getRequest()->getPost(); $storage = new Zend_Auth_Storage_Session('publisher_type'); $sessDataIds = $storage->read(); if (isset($formData['manager']) && trim($formData['manager']) != "" && $formData['userList'] != '') { $assign_user_id = trim($formData['userList']); $publisher_id = $sessDataIds->id; if ($formData['from_date'] != '' && $formData['to_date'] != '') { $bookList = $this->modelBooks->getPublicationAssignListDateFree($publisher_id, $assign_user_id, $formData['from_date'], $formData['to_date']); } else { $bookList = $this->modelBooks->getPublicationAssignListFree($publisher_id, $assign_user_id); } } else { if ($formData['from_date'] != '' && $formData['to_date'] != '') { $bookList = $this->modelBooks->getPublicationProductListDateFree($this->parentPublisherId, $formData['from_date'], $formData['to_date']); } else { $bookList = $this->modelBooks->getPublicationProductListFree($this->parentPublisherId); } } foreach ($bookList as $bookDetails) { $getCurrencyName = $producturrency->getCurrencyCode($bookDetails['store_id']); //echo $bookDetails['purchaseAmount']."<br/>"; $price_t = $producturrency->currencyconverter($getCurrencyName, "NGN", $bookDetails['cr_price']); $totalPrice = $totalPrice + $bookDetails['best_seller'] * $price_t; } $page = $this->_getParam('page', 1); $paginator = Zend_Paginator::factory($bookList); $paginator->setItemCountPerPage(10); $paginator->setCurrentPageNumber($page); $this->view->totalCount = count($bookList); $this->view->pageSize = 10; $this->view->page = $page; $this->view->bookList = $paginator; $this->view->parentPublisherId = $this->parentPublisherId; $this->view->formData = $formData; $this->view->totalPrice = $totalPrice; }
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']; }
public function expordetailsreportxlsAction() { $modelCategory = new Publisher_Model_DbTable_Books(); $producturrency = new Admin_Model_DbTable_Countries(); $productPrice = new Publisher_Model_DbTable_BookPrices(); $separator = ","; $publication = $this->_request->getParam('publication'); $request_list = $this->modelBooks->gerDetailsReportsById($publication); if (count($request_list) > 0) { $csv_output = ""; //$csv_output.="First Name".$separator."Last Name".$separator."User Name".$separator."Country".$separator."Email".$separator."Phone\n"; $content = '<table class="table-list" cellpadding="0" cellspacing="0" width="100%"> <tr> <th>Publication Id</th> <th>Title / Brand</th> <th>Category</th> <th>Publisher</th> <th>Total Downloads</th> <th>Total Purchase</th> <th>Unit Price</th> <th>Total Amount</th> <th>Last Purchased</th> </tr>'; foreach ($request_list as $req) { //$req['country']; //$countryName = $this->modelUsers->getCountryInfo($req['country']); $getBrandInfo = $modelCategory->getBrandInfo($req['title']); if (!empty($getBrandInfo)) { $titleBrand = $getBrandInfo['brand']; } else { $titleBrand = $req['title']; } if (!empty($row->parent_brand_id)) { $productInfo = $this->modelPublications->fetchRow('id=' . $req['parent_brand_id']); $getParentBrandInfo = $modelCategory->getBrandInfo($productInfo->title); if (!empty($getParentBrandInfo)) { $titleBrand = $titleBrand . ' (' . $getParentBrandInfo['brand'] . ')'; } } $title = stripslashes($titleBrand); $catInfo = $modelCategory->getCategoryInfo($req['cat_id']); $productPriceInfo = $productPrice->getPriceByStoreId($req['id'], $req['store_id']); $publiseherDetails = $this->modelPublisher->getInfoByPublisherId($req['publisher_id']); $publisherName = $publiseherDetails['publisher']; $totalDownLoad = $req['no_download']; $publication_id = $req['id']; $price = $req['price']; $quantity = $req['quantity']; $category_name = $catInfo['category_name']; $totalPurchase = $req['best_seller']; $currency = $producturrency->getCurrencyInfo($req['store_id']); $currencyN = $producturrency->getCurrencyInfo(226); if ($req['group_id'] != 0) { $price = $productPriceInfo['group_price']; } else { $price = $productPriceInfo['group_price']; } $getCurrencyName = $producturrency->getCurrencyCode($req['store_id']); $tot = $req['quantity'] * $req['price']; $totNairaPrice = $producturrency->currencyconverter($getCurrencyName, "NGN", $tot); $content .= '<tr> <td>' . $publication_id . '</td> <td>' . $title . '</td> <th>' . $category_name . '</th> <td>' . $publisherName . '</td> <td>' . $totalDownLoad . '</td> <td>' . $quantity . '</td> <td>' . $currency . $price . '</td> <td>' . $currencyN . $totNairaPrice . '</td> <td>' . $req['add_date'] . '</td> </tr>'; //$csv_output .= str_replace(",","",$req['first_name']).$separator.str_replace(",","",$req['last_name']).$separator.str_replace(",","",$req['user_name']).$separator.str_replace(",","",$countryName['country']).$separator.str_replace(",","",$req['user_email']).$separator.str_replace(",","",$req['phone'])."\n"; } } else { $content .= '<tr><td colspan="8" class="list-not-found">Data Not Found</td></tr>'; } $content .= '</table>'; $file = "report"; $filename = $file . "_" . time() . ".xls"; $test = $content; header("Content-type: application/vnd.ms-excel"); header("Content-Disposition: attachment; filename={$filename}"); echo $test; exit; }