private function _viewentries()
{
$type = Input::get('type', 'created_at');
$data['daterange'] = Input::get('record_range', '');
//Session::put('ss_select_banktype', $type);
Larasset::start('header')->css('daterangepicker');
Larasset::start('footer')->js('moment', 'daterangepicker');
Larasset::start('footer')->js('dataTables-min', 'dataTables-bootstrap');
$data['entries'] = Bankentry::with(array('user' => function ($q) {
$q->select('id', 'name');
}));
//Is the person Admin or not
if (User::permitted('role.admin') !== true) {
$data['entries'] = $data['entries']->where('id', Auth::user()->id);
}
if ($data['daterange'] !== '' && strpos($data['daterange'], '-') !== FALSE) {
$fromandto = explode('-', $data['daterange']);
$from = $fromandto[0];
$to_plus_1day = strtotime('now') - strtotime('yesterday') + strtotime($fromandto[1]);
$to = date('Y/n/d', $to_plus_1day);
$data['from'] = date('Y/n/d', strtotime($fromandto[0]));
$data['to'] = date('Y/n/d', strtotime($fromandto[1]));
} else {
$to = date('Y/n/d', strtotime('today'));
$from = date('Y/n/d', mktime(0, 0, 0, date('n') - 6, 1, date('y')));
$data['from'] = $from;
$data['to'] = $to;
}
$data['entries'] = $data['entries']->whereBetween('deposit_date', array(sqldate($from), sqldate($to)));
$data['entries'] = $data['entries']->orderby('deposit_date', 'desc')->paginate(10);
//tt($data);
return $data;
}
