public function deletepriceAction()
{
$id = $this->_request->getParam('id', 0);
$parent_publication_id = $this->_request->getParam('parentid', 0);
$modelPrice = new Publisher_Model_DbTable_BookPrices();
$currentrecord = $modelPrice->CurrentRow($id);
if ($id > 0 && $modelPrice->isExist($id)) {
$success = $modelPrice->delete('id=' . $id);
if ($success) {
echo "<table width='100%' class='table-list' border='0' cellspacing='0' cellpadding='0'><tr>\n<td width='50%'><div align='left'><strong>Country</strong></div></td>\n<td width='30%'><div align='left'><strong>Language</strong></div></td>\n<td width='10%'><div align='left'><strong>Price</strong></div></td>\n<td width='10%'><div align='left'><strong>Action</strong></div></td>\n</tr>";
$modelPrice = new Publisher_Model_DbTable_BookPrices();
$priceList = $modelPrice->getPriceList($currentrecord['product_id']);
for ($jj = 0; $jj < count($priceList); $jj++) {
$deletePriceUrl = $this->view->url(array('module' => 'publisher', 'controller' => 'issues', 'action' => 'deleteprice', 'id' => $priceList[$jj]['id'], 'parentid' => $parent_publication_id), '', true);
echo "<tr><td><div align='left'>";
$modelCountry = new Publisher_Model_DbTable_Books();
$countryRecord = $modelCountry->getCountryName($priceList[$jj]['country_id']);
echo $countryRecord['country'];
echo "</div></td><td><div align='left'>";
$modelLanguage = new Publisher_Model_DbTable_Books();
$languageRecord = $modelLanguage->getLanguageName($priceList[$jj]['language_id']);
echo $languageRecord['language_name'];
echo "</div></td><td><div align='left'>";
echo $priceList[$jj]['price'];
echo "</div></td><td><div align='left'>";
echo "<a class='action-icon' href='" . $deletePriceUrl . "' onclick='return deleteprice(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> ";
echo "</div></td></tr>";
}
echo "</table>";
exit;
} else {
echo "<font color='red'><strong>Sorry!, unable to delete price</strong></font>";
exit;
}
}
}
public function deletepriceAction()
{
$id = $this->_request->getParam('id', 0);
$modelPrice = new Publisher_Model_DbTable_BookPrices();
$currentrecord = $modelPrice->CurrentRow($id);
if ($id > 0 && $modelPrice->isExist($id)) {
$success = $modelPrice->delete('id=' . $id);
if ($success) {
echo "<table width='100%' class='table-list' border='0' cellspacing='0' cellpadding='0'><tr>\n<td width='20%'><div align='left'><strong>Country</strong></div></td>\n<td width='20%'><div align='left'><strong>Language</strong></div></td>\n<td width='10%'><div align='left'><strong>Price</strong></div></td>\n<td width='20%'><div align='left'><strong>Group Price</strong></div></td>\n<td width='10%'><div align='left'><strong>Action</strong></div></td>\n</tr>";
$modelPrice = new Publisher_Model_DbTable_BookPrices();
$priceList = $modelPrice->getPriceList($currentrecord['product_id']);
for ($jj = 0; $jj < count($priceList); $jj++) {
$deletePriceUrl = $this->view->url(array('module' => 'publisher', 'controller' => 'book', 'action' => 'deleteprice', 'id' => $priceList[$jj]['id']), '', true);
echo "<tr><td><div align='left'>";
$modelCountry = new Publisher_Model_DbTable_Books();
$countryRecord = $modelCountry->getCountryName($priceList[$jj]['country_id']);
echo $countryRecord['country'];
echo "</div></td><td><div align='left'>";
$modelLanguage = new Publisher_Model_DbTable_Books();
$languageRecord = $modelLanguage->getLanguageName($priceList[$jj]['language_id']);
echo $languageRecord['language_name'];
echo "</div></td><td><div align='left'>";
echo "\$" . $priceList[$jj]['price'];
echo "</div></td><td><div align='left'>";
echo "\$" . $priceList[$jj]['group_price'];
echo "</div></td><td><div align='left'>";
echo "<a class='action-icon' href='" . $deletePriceUrl . "' onclick='return deleteprice(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> ";
?>
<a href="javascript:void(0);" onclick="return updateprice1('<?php
echo $priceList[$jj]['id'];
?>
','<?php
echo $this->view->serverUrl() . $this->view->baseUrl() . "/publisher/book/saveprice";
?>
','<?php
echo $currentrecord['product_id'];
?>
');"'<?php
echo $priceList[$jj]['id'];
?>
','<?php
echo $this->view->serverUrl() . $this->view->baseUrl() . "/publisher/book/saveprice";
?>
','<?php
echo $formData['id'];
?>
');">
<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>";
}
echo "</table>";
exit;
} else {
echo "<font color='red'><strong>Sorry!, unable to delete price</strong></font>";
exit;
}
}
}
public function exportusercsvAction()
{
$bookname = $this->_request->getParam('searchword');
$booktype = $this->_request->getParam('booktype');
$isbnnumber = $this->_request->getParam('searchisbn');
if (isset($bookname) && (trim($bookname) != "" || trim($booktype) != "" || trim($isbnnumber) != "")) {
$bookname = trim($bookname);
$booktype = trim($booktype);
$isbnnumber = trim($isbnnumber);
$getBrandIds = $this->modelBrand->getBrandIds($bookname);
$whrcls = "";
if ($bookname != "") {
$whrcls .= " title LIKE '%" . $bookname . "%'";
if (!empty($getBrandIds)) {
$whrcls .= " OR title in(" . $getBrandIds . ")";
}
}
if ($booktype != "") {
if ($bookname != "") {
$whrcls .= " AND product_type LIKE '%" . $booktype . "%'";
} else {
$whrcls .= " product_type LIKE '%" . $booktype . "%'";
}
}
if (!empty($isbnnumber)) {
if ($bookname != "") {
$whrcls .= " AND isbn_number LIKE '%" . $isbnnumber . "%'";
} elseif ($booktype != "") {
$whrcls .= " AND isbn_number LIKE '%" . $isbnnumber . "%'";
} else {
$whrcls .= " isbn_number LIKE '%" . $isbnnumber . "%'";
}
}
// $prodList=$this->modelPublications->getListWhere($whrcls);
$sql = "select id,title,product_type,parent_brand_id,author_id,publish_time,publisher,publisher_id,admin_approve,isbn_number,is_featured from pclive_products where {$whrcls} order by id desc";
//$request_list=$this->modelconnections->fetchAll("intro_id='".$_SESSION['Zend_Auth']['storage']->user_id."' and conn_linkedin_id!=''");
$request_list = $this->modelPublications->getAdapter()->fetchAll($sql);
} else {
//$prodList=$this->modelPublications->getList();
$sql = "select id,title,parent_brand_id,product_type,author_id,publish_time,publisher,publisher_id,admin_approve,isbn_number,is_featured from pclive_products order by id desc";
//$request_list=$this->modelconnections->fetchAll("intro_id='".$_SESSION['Zend_Auth']['storage']->user_id."' and conn_linkedin_id!=''");
$request_list = $this->modelPublications->getAdapter()->fetchAll($sql);
}
$separator = ",";
// separate column in csv
$modelCategory = new Publisher_Model_DbTable_Books();
$productPrice = new Publisher_Model_DbTable_BookPrices();
if (count($request_list) > 0) {
$csv_output = "";
$csv_output .= "Title / Brand" . $separator . "Genre" . $separator . "Author / Publisher" . $separator . "ISBN / ISSN" . $separator . "Publish Time" . $separator . "Status" . $separator . "Featured\n";
$content = '<table class="table-list" cellpadding="0" cellspacing="0" width="100%">
<tr>
<th>Title / Brand</th>
<th>Genre</th>
<th>Author / Publisher</th>
<th>ISBN / ISSN</th>
<th>Publish Time</th>
<th>Price</th>
<th>Account Number</th>
<th>Account Holder Name</th>
<th>Banker</th>
<th>Status</th>
<th>Featured</th>
</tr>';
foreach ($request_list as $req) {
$productPriceInfo = array();
$productPriceInfo = $productPrice->getPriceList($req['id']);
$price_details = '';
foreach ($productPriceInfo as $priceDet) {
$countryDet = $modelCategory->getCountryName($priceDet['country_id']);
if ($priceDet['price'] != '') {
$price_details .= $priceDet['price'] . "(P) ";
}
if ($priceDet['group_price'] != '') {
$price_details .= $priceDet['group_price'] . "(GP) ";
}
$price_details .= "in " . $countryDet['country'] . "<br/>";
}
$getBrandInfo = $modelCategory->getBrandInfo($req['title']);
if (!empty($getBrandInfo)) {
$titleBrand = $getBrandInfo['brand'];
} else {
$titleBrand = $req['title'];
}
if (!empty($req['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);
$genreInfo = $this->modelGenre->getGenreInfo($req['product_type']);
$genre = $genreInfo['genre'];
$publisher_info_array = array();
$publisher_info_array = $this->modelPublications->getPublisherInfo($req['publisher_id']);
$account_det = " Account No:" . $publisher_info_array['account_no'] . " Account Holder Name:" . $publisher_info_array['account_no'] . " Bank Name:" . $publisher_info_array['banker'];
/* if(!empty($publisher_info_array))
{
$publisherName =$publisher_info_array['first_name']." ".$publisher_info_array['last_name'];
}
else
{
$publisherName = $req['publisher'];
} */
$publisherName = $req['publisher'];
$isbnNumber = $req['isbn_number'];
$pubTime = $req['publish_time'];
if ($req['admin_approve'] == '1') {
$status = "Aproved";
} else {
$status = "Not Aproved";
}
if ($req['is_featured'] == '1') {
$featured = "Yes";
} else {
$featured = "No";
}
$content .= '<tr>
<td>' . str_replace(",", "", $title) . '</td>
<td>' . str_replace(",", "", $genre) . '</td>
<td>' . stripslashes($publisherName) . '</td>
<td>' . $isbnNumber . '</td>
<td>' . $pubTime . '</td>
<td>' . $price_details . '</td>
<td>' . $publisher_info_array['account_no'] . '</td>
<td>' . $publisher_info_array['account_holder_name'] . '</td>
<td>' . $publisher_info_array['banker'] . '</td>
<td>' . $status . '</td>
<td>' . $featured . '</td>
</tr>';
$csv_output .= str_replace(",", "", $title) . $separator . str_replace(",", "", $genre) . $separator . str_replace(",", "", $publisherName) . $separator . str_replace(",", "", $isbnNumber) . $separator . str_replace(",", "", $pubTime) . $separator . str_replace(",", "", $status) . $separator . $featured . "\n";
}
} else {
$content .= '<tr><td colspan="8" class="list-not-found">Data Not Found</td></tr>';
}
$content .= '</table>';
$file = "publications";
$filename = $file . "_" . time() . ".xls";
$test = $content;
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename={$filename}");
echo $test;
exit;
/*header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-type: application/vnd.ms-excel");
header("Content-type: application/vnd.ms-excel");
header("Content-type: application/xls");
//header("Content-disposition: excel".time().".csv");
header("Content-Disposition: attachment; filename=".$filename.".xls");
header( "Content-disposition: filename=".$filename.".xls");
print $csv_output;
exit;*/
}
