Exemplo n.º 1
0
 private function _view()
 {
     $daterange = Input::get('record_range', '');
     //Session::put('ss_select_expen', $type);
     Larasset::start('header')->css('daterangepicker');
     Larasset::start('footer')->js('moment', 'daterangepicker');
     Larasset::start('footer')->js('dataTables-min', 'dataTables-bootstrap');
     $data['entries'] = Expenditure::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('user_id', Auth::user()->id);
     }
     if ($daterange !== '' && strpos($daterange, '-') !== FALSE) {
         $fromandto = explode('-', $daterange);
         $from = $fromandto[0];
         $to_plus_1day = strtotime('now') - strtotime('yesterday') + strtotime($fromandto[1]);
         $to = date('Y/n/d', $to_plus_1day);
         $data['from'] = format_date2($fromandto[0]);
         $data['to'] = format_date2($fromandto[1]);
     } else {
         $to = date('Y/n/d', strtotime('today'));
         $from = date('Y/n/d', strtotime('first day of this month'));
         $data['to'] = format_date2($to);
         $data['from'] = format_date2($from);
     }
     $data['entries'] = $data['entries']->whereBetween('date', array(sqldate($from), sqldate($to)));
     //$data['entries'] = $data['entries']->orderby('date', 'desc')->paginate(10);
     $data['entries'] = $data['entries']->orderby('date', 'desc')->get();
     //tt($data);
     return $data;
 }
 private function _view()
 {
     $type = Input::get('type', 'created_at');
     $daterange = Input::get('record_range', '');
     //Session::put('ss_select_expen', $type);
     Larasset::start('header')->css('daterangepicker');
     Larasset::start('footer')->js('moment', 'daterangepicker');
     Larasset::start('footer')->js('dataTables-min', 'dataTables-bootstrap');
     $data['entries'] = Expenditure::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('user_id', Auth::user()->id);
     }
     if ($daterange !== '' && strpos($daterange, '-') !== FALSE) {
         $fromandto = explode('-', $daterange);
         $from = $fromandto[0];
         $to_plus_1day = strtotime('now') - strtotime('yesterday') + strtotime($fromandto[1]);
         $to = date('Y/n/d', $to_plus_1day);
         $data['from'] = format_date2($fromandto[0]);
         $data['to'] = format_date2($fromandto[1]);
     } else {
         $to = date('Y/n/d', strtotime('today'));
         $from = date('Y/n/d', strtotime('first day of this month'));
         $data['to'] = format_date2($to);
         $data['from'] = format_date2($from);
     }
     $data['entries'] = $data['entries']->whereBetween('date', array(sqldate($from), sqldate($to)));
     //$data['entries'] = $data['entries']->orderby($type, 'desc')->paginate(10);
     $data['entries'] = $data['entries']->orderby('date', 'asc')->get();
     //dd($data['entries']->toArray());
     $saleslog = Salelog::whereBetween('created_at', array(sqldate($from), sqldate($to)))->select('unitprice', 'costprice', 'quantity', 'total_unitprice')->orderby('receipt_id', 'desc')->get();
     $profitmargin = 0;
     foreach ($saleslog as $field) {
         //tt( $field->total_unitprice - ( $field->costprice * $field->quantity ) , true);
         $profitmargin += $field->total_unitprice - $field->costprice * $field->quantity;
     }
     $data['profitmargin'] = $profitmargin;
     //tt($data);
     return $data;
 }