public function destroy($id) { $targetExpense = Expense::find($id); if ($targetExpense) { $targetExpense->delete(); return $this->index(); } else { return $this->index(); } }
public function home() { $total = $this->User->query("SELECT SUM(amount) as total FROM expenses WHERE house_id='" . $this->Session->read("Auth.User.House") . "' AND user_id='" . $this->Session->read("Auth.User.id") . "' AND active=1"); App::import('Model', 'Expense'); $mExpense = new Expense(); $expenses_id = $mExpense->query("SELECT expense_id FROM expenses_users WHERE user_id='" . $this->Session->read("Auth.User.id") . "'"); $expenses_id = Set::classicExtract($expenses_id, '{n}.expenses_users.expense_id'); $yourExpenses = $mExpense->find('all', array('conditions' => array('Expense.id' => $expenses_id, 'Expense.house_id' => $this->Session->read('Auth.User.House'), 'Expense.active' => 1))); $myTotal = 0.0; foreach ($yourExpenses as $expense) { $myTotal += $expense['Expense']['amount'] / count($expense['Perro']); } $totalP = $this->User->query("SELECT SUM(amount) as total FROM loans WHERE lender_id='" . $this->Session->read("Auth.User.id") . "' AND active=1"); $total2P = $this->User->query("SELECT SUM(amount) as total FROM loans WHERE borrower_id='" . $this->Session->read("Auth.User.id") . "' AND active=1"); $totalPaymentsP = $this->User->query("SELECT SUM(payments.amount) as total FROM payments, loans WHERE loans.id=payments.loan_id AND loans.lender_id='" . $this->Session->read("Auth.User.id") . "' AND loans.active=1 AND payments.active=1"); $totalPayments2P = $this->User->query("SELECT SUM(payments.amount) as total FROM payments, loans WHERE loans.id=payments.loan_id AND loans.borrower_id='" . $this->Session->read("Auth.User.id") . "' AND loans.active=1 AND payments.active=1"); $this->set(array('total' => $total[0][0]['total'], 'myTotal' => $myTotal, 'totalP' => $totalP['0']['0']['total'], 'total2P' => $total2P['0']['0']['total'], 'totalPaymentsP' => $totalPaymentsP['0']['0']['total'], 'totalPayments2P' => $totalPayments2P['0']['0']['total'])); }
function delete($id = FALSE) { $expense = Expense::find($id); $expense->delete(); $this->content_view = 'expenses/all'; if (!$expense) { $this->session->set_flashdata('message', 'error:' . $this->lang->line('messages_delete_expense_error')); } else { $this->session->set_flashdata('message', 'success:' . $this->lang->line('messages_delete_expense_success')); } redirect('expenses'); }
function item($id = FALSE) { if ($_POST) { unset($_POST['send']); $_POST = array_map('htmlspecialchars', $_POST); if ($_POST['name'] != "") { $_POST['name'] = $_POST['name']; $_POST['value'] = $_POST['value']; $_POST['type'] = $_POST['type']; } else { if ($_POST['item_id'] == "-") { $this->session->set_flashdata('message', 'error:' . $this->lang->line('messages_add_item_error')); redirect('invoices/view/' . $_POST['invoice_id']); } else { $rebill = explode("_", $_POST['item_id']); if ($rebill[0] == "rebill") { $itemvalue = Expense::find_by_id($rebill[1]); $_POST['name'] = $itemvalue->description; $_POST['type'] = $_POST['item_id']; $_POST['value'] = $itemvalue->value; $itemvalue->rebill = 2; $itemvalue->invoice_id = $_POST['invoice_id']; $itemvalue->save(); } else { $itemvalue = Item::find_by_id($_POST['item_id']); $_POST['name'] = $itemvalue->name; $_POST['type'] = $itemvalue->type; $_POST['value'] = $itemvalue->value; } } } $item = InvoiceHasItem::create($_POST); if (!$item) { $this->session->set_flashdata('message', 'error:' . $this->lang->line('messages_add_item_error')); } else { $this->session->set_flashdata('message', 'success:' . $this->lang->line('messages_add_item_success')); } redirect('invoices/view/' . $_POST['invoice_id']); } else { $this->view_data['invoice'] = Invoice::find($id); $this->view_data['items'] = Item::find('all', array('conditions' => array('inactive=?', '0'))); $this->view_data['rebill'] = Expense::find('all', array('conditions' => array('project_id=? and (rebill=? or invoice_id=?)', $this->view_data['invoice']->project_id, 1, $id))); $this->theme_view = 'modal'; $this->view_data['title'] = $this->lang->line('application_add_item'); $this->view_data['form_action'] = 'invoices/item'; $this->content_view = 'invoices/_item'; } }
/** * Show the form for editing the specified expense. * * @param int $id * @return Response */ public function edit($id) { $expense = Expense::find($id); $accounts = Account::all(); return View::make('expenses.edit', compact('expense', 'accounts')); }
/** * Show the form for editing the specified expense. * * @param int $id * @return Response */ public function edit($id) { $expense = Expense::find($id); return View::make('expenses.edit', compact('expense')); }
public function delete_destroy($object_id = false) { $expense = Expense::find($object_id); $expense->delete(); return Redirect::to_action('expenses@index'); }