public function export(Request $request)
{
$store = new Store();
$builder = $store->newQuery()->join('agent_store', 'agent_store.sid', '=', 'stores.id')->groupBy('stores.id');
$page = $request->input('page') ?: 0;
$pagesize = $request->input('pagesize') ?: config('site.pagesize.export', 1000);
$total = $this->_getCount($request, $builder);
if (empty($page)) {
$this->_of = $request->input('of');
$this->_table = $store->getTable();
$this->_total = $total;
$this->_pagesize = $pagesize > $total ? $total : $pagesize;
return $this->view('admin.store.export');
}
$data = $this->_getExport($request, $builder, null, ['stores.*', DB::raw('COUNT(`agent_store`.`aid`) as `agents-count`')]);
return $this->success('', FALSE, $data);
}
public function export(Request $request)
{
$store = new Store();
$builder = $store->newQuery()->join('agent_store', 'agent_store.aid', '=', 'stores.id')->where('aid', '=', $this->agent->getKey())->groupBy('stores.id');
$page = $request->input('page') ?: 0;
$pagesize = $request->input('pagesize') ?: config('site.pagesize.export', 1000);
$total = $this->_getCount($request, $builder);
if (empty($page)) {
$this->_of = $request->input('of');
$this->_table = $store->getTable();
$this->_total = $total;
$this->_pagesize = $pagesize > $total ? $total : $pagesize;
return $this->view('agent-backend.store.export');
}
$data = $this->_getExport($request, $builder, null, 'stores.*');
return $this->success('', FALSE, $data);
}