.then(function (amount) {
var totalResult = +amount.count || 0;
if (totalResult > 0) {
var paginator = new pagination.SearchPaginator({
prelink:'/',
current: page,
rowsPerPage: perPage,
totalResult: totalResult
});
var pageData = paginator.getPaginationData();
db.func(`fn_getreposbytag`, [tag, perPage, page])
.then(function (data) {
res.status(200)
.json({
status: 'success',
data: data,
pageData: {
previous: pageData.previous,
next: pageData.next,
first: pageData.first,
last: pageData.last,
},
});
})
.catch(function (err) {
return next(err);
});
} else {
return next('No data');
}
})
q.all([products.searchProducts(config.mysql,q,data,1),products.searchProducts(config.mysql,q,data,0)]).then(function(results){
$arr['projects'] = [];
var pagination = require('pagination');
var paginator = new pagination.SearchPaginator({prelink:'javascript:paginationSearch', current: data.spage, rowsPerPage: req.body.limit, totalResult: results[1][0].length,ajax : true});
$arr.isbuynowsearch = $arr.isfeaturedsearch = $arr.isauctionsearch = '';
if(req.param('type') == '1')
{
$arr.isauctionsearch = 'checked';
}
if(req.param('type') == '2')
{
$arr.isbuynowsearch = 'checked';
}
if(req.param('type') == '3')
{
$arr.isfeaturedsearch = 'checked';
}
$arr['pagination_html'] = paginator.render();
$arr['projects']['project'] = products.shortDescribe(results[0][0]);
common.tplFile('search.tpl');
common.headerSet(1);
common.loadTemplateHeader(req,res,$arr);
});
database.query( countquery, pager_args.condition_args, function (err, result) {
if ( err ) { console.log( countquery ); callback(err, null); return; }
var total_count = _.parseInt( App.model('common').safeGetCount( result ) );
if( !_.isNull( current ) )
{
offset_limit = self.culcOffset( current, limit, total_count );
}
var arg = {
prelink : pager_args.prelink,
current : offset_limit.current,//pager_args.current,
rowsPerPage : pager_args.rowsPerPage,
totalResult : total_count,
pageLinks : 20
};
var pager = new pagination.SearchPaginator( arg );
var paginator = {
page_index : self.renderPager( pager.getPaginationData() ),
page_detail: pager.getPaginationData()
};
var valuequery = "SELECT " + column + " FROM " + from + " " + where + ( ( order ) ? " ORDER BY " + order : "" ) + ( ( limit ) ? " LIMIT " + limit : "" ) + ( " OFFSET " + offset_limit.offset );
database.query( valuequery, pager_args.condition_args, function (err, result) {
if ( err ) { console.log( valuequery ); callback(err, null); return; }
var data = App.model('common').safeGetResult( result );
exit( err, { paginator : paginator, data: data } );
});
});
q.all([stores.view(req,$arr.config.mysql,q),stores.viewStoreProducts(req,$arr.config.mysql,q,1),stores.viewStoreCategories(req,$arr.config.mysql,q),stores.viewStoreFeaturedProducts(req,$arr.config.mysql,q),stores.viewStoreProducts(req,$arr.config.mysql,q,0)]).then(function(results)
{
console.log(3);
if(results[0][0].length == 0)
{
res.writeHead(302, {
'Location': '/'
});
res.end();return false;
}
$arr.nulldata = null;
$arr.store = results[0][0][0];
$arr.storeProducts = results[1][0];
$arr.storeCategories = results[2][0];
$arr.storeFProducts = results[3][0];
$arr.paginations = results[4][0];
//$arr['pagination'] = products.shortDescribe(results[1][0]).length;
var pagination = require('pagination');
var paginator = new pagination.SearchPaginator({
prelink: 'javascript:paginationStore',
current: req.body.page,
rowsPerPage: 15,
totalResult: $arr.paginations.length,
ajax: true
});
$arr['pagination_html'] = paginator.render();
common.tplFile('store/view.tpl');
common.headerSet(1);
common.loadTemplateHeader(req,res,$arr);
});
q.all([bids.mywonauctions(req,config.mysql,q),bids.totalmywonauctions(req,config.mysql,q)]).then(function(results)
{ $arr['pagination'] = results[1][0].length;
$arr['mybids'] = results[0][0];
var pagination = require('pagination');
var paginator = new pagination.SearchPaginator({prelink:'/dashboard/wonauctions', current: req.body.page, rowsPerPage: 10, totalResult: $arr['pagination']});
$arr['pagination_html'] = paginator.render();
common.tplFile('wonauctions.tpl');
common.headerSet(1);
common.loadTemplateHeader(req,res,$arr);
});
q.all([admin.allreviews(req,config.mysql,q,0),admin.allreviews(req,config.mysql,q,1)]).then(function(result)
{
$arr['review'] = result[0][0];
$arr['reviews'] = result[1][0].length;
var paginator = new pagination.SearchPaginator({prelink:'/reviews/', current: req.body.page, rowsPerPage: 10, totalResult: $arr['reviews']});
$arr['pagination_html'] = paginator.render();
common.tplFile('reviews.tpl');
common.headerSet(1);
common.loadTemplateHeader(req,res,$arr);
});
countQuery.count(function(err,count){
totalcnt = count;
page_list = Math.ceil(totalcnt/results_per_page);
var paginator = new pagination.SearchPaginator({prelink:'/selimList.html?currPage=', current: page_num, rowsPerPage: results_per_page, totalResult: totalcnt});
var paging = paginator.getPaginationData();
query.skip((page_num-1)*results_per_page).limit(results_per_page).exec('find',function(err,data){
console.log("currPage:::"+err);
res.render("index",{data: data,size: data.length,pageList: page_list,currPage: page_num,paging: paging});
res.end();
});
});
q.all([dashboard.mybuynow(req,config.mysql,q,1),dashboard.mybuynow(req,config.mysql,q,0)]).then(function(results)
{ $arr['pagination'] = results[1][0].length;
$arr['mybids'] = results[0][0];
var pagination = require('pagination');
var paginator = new pagination.SearchPaginator({prelink:'/dashboard/buynow', current: data.dspage, rowsPerPage: req.body.perlimit , totalResult: $arr['pagination'] });
$arr['pagination_html'] = paginator.render();
common.tplFile('mybids.tpl');
common.headerSet(1);
common.loadTemplateHeader(req,res,$arr);
});
q.all([dashboard.getPayments(req,config.mysql,q),dashboard.getAllPayments(req,config.mysql,q)]).then(function(results)
{
$arr['payments'] = results[0][0];
$arr['cnt'] = results[1][0].length;
var pagination = require('pagination');
var paginator = new pagination.SearchPaginator({prelink:'/dashboard/payments', current: req.body.page, rowsPerPage: 15, totalResult: $arr['cnt']});
$arr.pagination_html = paginator.render();;
common.tplFile('payments.tpl');
common.headerSet(1);
common.loadTemplateHeader(req,res,$arr);
});
exports.create = function(c) {
var cnf = {
totalResult:0,
current: 1,
rowsPerPage: 20,
prelink: './'
}
var func = function(p) {
if(!p) return null;
var r = {p:p, l:'?page='+p}
if(c.req && c.req.query) {
r.l = []
for(var i in c.req.query) {
if(i != 'page') r.l.push(i + '=' + c.req.query[i])
}
r.l.push('page=' + p)
r.l = '?' + r.l.join('&')
}
return r
}
if(c.limit) cnf.rowsPerPage = c.limit
if(c.start) {
cnf.current = Math.floor(c.start/c.limit) + 1
}
if(c.total) cnf.totalResult = c.total
var paginator = new pagination.SearchPaginator(cnf);
var res = paginator.getPaginationData()
if(res.next == 0) res.next = null;
else res.next = func(res.next)
res.previous = func(res.previous)
if(res.range.indexOf(res.first) != -1) res.first = null
else res.first = func(res.first)
if(res.range.indexOf(res.last) != -1) res.last = null
else res.last = func(res.last)
for(var i in res.range) {
res.range[i] = func(res.range[i])
}
return res;
}
q.all([messages.mymessages(req,config.mysql,q,0),messages.mymessages(req,config.mysql,q,1),messages.mymessages(req,config.mysql,q,2)]).then(function(results)
{
$arr['pagination'] = results[1][0].length;
$arr['messages'] = results[0][0];
$arr['unreadmessage'] = results[2][0].length;
var pagination = require('pagination');
var paginator = new pagination.SearchPaginator({prelink:'/dashboard/messages/'+req.body.action, current: req.body.page, rowsPerPage: 10, totalResult: $arr['pagination']});
$arr['pagination_html'] = paginator.render();
common.tplFile('messages.tpl');
common.headerSet(1);
common.loadTemplateHeader(req,res,$arr);
});
}, (error, response) => {
let paginator = new pagination.SearchPaginator({
prelink: '/',
current: req.page,
rowsPerPage: req.limit,
totalResult: response.hits.total
});
res.render(
'index', {
q: req.query.q,
result: response,
paginator: paginator.getPaginationData()
}
);
});
q.all([dashboard.listfeedback(req,$arr.config.mysql,q,1),dashboard.listfeedback(req,$arr.config.mysql,q,0),dashboard.listfeedbackrating(req,$arr.config.mysql,q)]).then(function(results)
{
$arr.feedbacks=results[0][0];
$arr.ratings = results[2][0];
$arr['pagination'] = results[1][0].length;
console.log('pagiation:'+$arr['pagination']);
var pagination = require('pagination');
var paginator = new pagination.SearchPaginator({prelink:'/dashboard/feedback', current: req.body.page, rowsPerPage: req.body.perlimit, totalResult: $arr['pagination']});
$arr['pagination_html'] = paginator.render();
common.tplFile('feedback_1.tpl');
common.headerSet(1);
common.loadTemplateHeader(req,res,$arr);
});
q.all([bids.mywon(req,config.mysql,q,1),bids.mywon(req,config.mysql,q,0)]).then(function(results)
{ $arr['pagination'] = results[1][0].length;
$arr['mybids'] = products.shortDescribe(results[0][0]);
var pagination = require('pagination');
fquery = '';
if(typeof(req.param('cmd')) !== 'undefined')
{
fquery = '?cmd='+req.param('cmd');
}
var paginator = new pagination.SearchPaginator({prelink:'/dashboard/mywon'+fquery, current: data.dspage, rowsPerPage: req.body.perlimit, totalResult: $arr['pagination']});
$arr['pagination_html'] = paginator.render();
common.tplFile('mywon.tpl');
common.headerSet(1);
common.loadTemplateHeader(req,res,$arr);
});
q.all([products.savedsearch(req,config.mysql,q,1),products.savedsearch(req,config.mysql,q,0)]).then(function(results){
$arr['pagination'] = results[0][0].length;
$arr['searchlist'] = results[1][0];
var pagination = require('pagination');
fquery = '';
if(typeof(req.param('cmd')) !== 'undefined')
{
fquery = '?cmd='+req.param('cmd');
}
var paginator = new pagination.SearchPaginator({prelink:'/dashboard/searchitems/'+fquery, current: req.body.page, rowsPerPage: 10, totalResult: $arr['pagination']});
$arr['pagination_html'] = paginator.render();
common.tplFile('searchitems.tpl');
common.headerSet(1);
common.loadTemplateHeader(req,res,$arr);
});
q.all([products.searchProducts(config.mysql,q,data,1),products.searchProducts(config.mysql,q,data,0)]).then(function(results){
$arr['projects'] = [];
var pagination = require('pagination');
var paginator = new pagination.SearchPaginator({prelink:'javascript:paginationSearch', current: data.spage, rowsPerPage: req.body.limit, totalResult: results[1][0].length,ajax : true});
$arr['pagination_html'] = paginator.render();
$arr['projects']['project'] = products.shortDescribe(results[0][0]);
if(typeof(req.param('ajax')) === 'undefined')
{
common.tplFile('search.tpl');
common.headerSet(1);
}
else{
common.tplFile('search-ajax.tpl');
common.headerSet(0);
}
common.loadTemplateHeader(req,res,$arr);
});
q.all([stores.viewStoreProducts(req,$arr.config.mysql,q,1),stores.viewStoreProducts(req,$arr.config.mysql,q,0)]).then(function(results)
{
$arr.nulldata = null;
$arr.storeProducts = results[0][0];
$arr.paginations = results[1][0];
//$arr['pagination'] = products.shortDescribe(results[1][0]).length;
var pagination = require('pagination');
var paginator = new pagination.SearchPaginator({
prelink: 'javascript:paginationStore',
current: req.body.page,
rowsPerPage: 15,
totalResult: $arr.paginations.length,
ajax: true
});
$arr['pagination_html'] = paginator.render();
common.tplFile('store/storeproducts.tpl');
common.headerSet(1);
common.loadTemplateHeader(req,res,$arr);
});
q.all([forums.cat_questions(req,config.mysql,q,req.body.id,0),forums.cat_questions(req,config.mysql,q,req.body.id,1)]).then(function(results){
$arr['questions'] = results[0][0];
$arr['pagination'] = results[1][0].length;
var pagination = require('pagination');
fquery = '';
if (typeof(req.param('cmd')) !== 'undefined') {
fquery = '?cmd=' + req.param('cmd');
}
var paginator = new pagination.SearchPaginator({
prelink: '/forum/category/'+req.body.id+ fquery,
current: req.body.page,
rowsPerPage: req.body.perlimit,
totalResult: $arr['pagination']
});
$arr['pagination_html'] = paginator.render();
common.tplFile('forum/discussion.tpl');
common.headerSet(1);
common.loadTemplateHeader(req,res,$arr);
});
q.all([forums.getQuestion(req, config.mysql, q,req.body.id),forums.getAnswer(req, config.mysql, q,req.body.id,1),forums.getKudos(req, config.mysql, q,req.body.id),forums.countKudos(req, config.mysql, q,req.body.id),forums.getAnsKudos(req, config.mysql, q,req.body.id),forums.getAnswer(req, config.mysql, q,req.body.id,0)]).then(function (results) {
$arr['questions'] = results[0][0][0];
$arr['answers'] = results[1][0];
$arr['allkudos'] = results[2][0];
$arr['kudo_count'] = results[3][0][0].kudos;
$arr['ans_kudo'] = results[4][0];
$arr['answers_length'] = results[5][0].length;
var paginator = new pagination.SearchPaginator({
prelink: '/forum/questionpage/'+req.body.id,
current: req.body.page,
rowsPerPage: 5,
totalResult: $arr['answers_length']
});
$arr['pagination_html'] = paginator.render();
console.log( $arr['ans_kudo'] );
common.tplFile('forum/questionpage.tpl');
common.headerSet(1);
common.loadTemplateHeader(req,res,$arr);
});