public function expenses() { $expenses = Expense::all(); $organization = Organization::find(1); $pdf = PDF::loadView('erpreports.expensesReport', compact('expenses', 'organization'))->setPaper('a4')->setOrientation('potrait'); return $pdf->stream('Expense List.pdf'); }
function create() { if ($_POST) { unset($_POST['send']); unset($_POST['_wysihtml5_mode']); unset($_POST['files']); $config['upload_path'] = './files/media/'; $config['encrypt_name'] = TRUE; $config['allowed_types'] = '*'; $this->load->library('upload', $config); if ($this->upload->do_upload()) { $data = array('upload_data' => $this->upload->data()); if ($_POST['attachment_description'] == "") { $_POST['attachment_description'] = $data['upload_data']['orig_name']; } $_POST['attachment'] = $data['upload_data']['file_name']; } $expense = Expense::create($_POST); if (!$expense) { $this->session->set_flashdata('message', 'error:' . $this->lang->line('messages_create_expense_error')); } else { $this->session->set_flashdata('message', 'success:' . $this->lang->line('messages_create_expense_success')); } redirect('expenses'); } else { $this->view_data['expenses'] = Expense::all(); $this->view_data['next_reference'] = Expense::last(); $this->view_data['projects'] = Project::all(); $this->view_data['core_settings'] = Setting::first(); $this->view_data['companies'] = Company::find('all', array('conditions' => array('inactive=?', '0'))); $this->theme_view = 'modal'; $this->view_data['categories'] = Expense::find_by_sql("select category from expenses group by category"); $this->view_data['title'] = $this->lang->line('application_create_expense'); $this->view_data['form_action'] = 'expenses/create'; $this->content_view = 'expenses/_expense'; } }
/** * Display a listing of expenses * * @return Response */ public function index() { $expenses = Expense::all(); return View::make('expenses.index', compact('expenses')); }
public static function getTotalExpenses() { $totalExpenses = Expense::all()->sum('sum'); return $totalExpenses; }
/** * view * Retrieves rows from database. */ public function view() { return Expense::all(); }