public function subscriptionsAction()
{
$idvalue = $this->_request->getParams('id');
$bookDetail = $this->modelPublications->getInfoByPublisherId($idvalue['id']);
$subscriptions_data = $this->modelSubscriptions->fetchAll('product_id=' . $idvalue['id'] . '');
$this->view->subscriptiondata = $subscriptions_data;
$whrcls = 'id=' . $idvalue['id'] . '';
$get_publicationname = $this->modelPublications->getListWhere($whrcls);
$modelCategory = new Publisher_Model_DbTable_Books();
$getBrandInfo = $modelCategory->getBrandInfo($get_publicationname[0]->title);
if (!empty($getBrandInfo)) {
$titleBrand = $getBrandInfo['brand'];
} else {
$titleBrand = $get_publicationname[0]->title;
}
$this->view->publicationname = $titleBrand;
}
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 exportfreereportxlsAction()
{
$category = $this->_request->getParam('category');
$brand = $this->_request->getParam('brand');
$productid = $this->_request->getParam('productid');
$frmdate = $this->_request->getParam('frmdate');
$todate = $this->_request->getParam('todate');
$publisher_id = $this->_request->getParam('publisher');
$modelCategory = new Publisher_Model_DbTable_Books();
$brand_exp = explode("**", $brand);
$request_list = $this->modelBooks->getProductReport($category, $brand_exp[0], $productid, $frmdate, $todate, $publisher_id);
$request_list = $this->modelBooks->getProductFreeReport($category, $brand_exp[0], $productid, $frmdate, $todate, $publisher_id);
$separator = ",";
// separate column in csv
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>
</tr>';
foreach ($request_list as $req) {
$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 = $getParentBrandInfo['brand'] . " - " . $titleBrand;
}
}
$title = stripslashes($titleBrand);
$catInfo = $modelCategory->getCategoryInfo($req['cat_id']);
$publiseherDetails = $this->modelPublisher->getInfoByPublisherId($req['publisher_id']);
$publisherName = $publiseherDetails['publisher'];
$totalDownLoad = $req['no_download'];
$publication_id = $req['id'];
$price = $req['price'];
$quantity = $req['total_count'];
$category_name = $catInfo['category_name'];
$totalPurchase = $req['best_seller'];
$content .= '<tr>
<td>' . $publication_id . '</td>
<td>' . stripslashes($title) . '</td>
<th>' . $category_name . '</th>
<td>' . $publisherName . '</td>
<td>' . $totalDownLoad . '</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="5" class="list-not-found">Data Not Found</td></tr>';
}
$content .= '</table>';
$file = "freereport";
$filename = $file . "_" . time() . ".xls";
$test = $content;
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename={$filename}");
echo $test;
exit;
}
