/**
* Display search results
*
* @return \Illuminate\Http\Response
*/
public function search(Request $request)
{
// get a list of all transfers
$transfers = Transfer::where('user_id', Auth::user()->id)->where('comment', 'LIKE', '%' . $request->q . '%');
// remember total records
session()->flash('total_count', ceil($transfers->count() / 25));
// sort
if (!empty($request->sort)) {
$transfers = $transfers->orderBy($request->sort, $request->order)->simplePaginate(25);
} else {
$transfers = $transfers->orderBy('date', 'desc')->simplePaginate(25);
}
// stuff to pass into view
$action = 'TransfersController@search';
$emptyMsg = "No Results for '" . $request->q . "'";
$title = "Search Transfers";
$heading = "Search Transfers - '" . $request->q . "'";
$request->flash();
return view('transfers.index', compact('transfers', 'action', 'emptyMsg', 'title', 'heading'));
}
public function paymentDelete($type, $id)
{
$user = Auth::user();
$date = Input::get('date');
$amount = Input::get('amount');
$bankID = Input::get('bank');
$accountID = Input::get('payment');
$note = Input::get('note');
//add intial trans back onto
if ($type == 0) {
//tansfer
$trans = Transfer::where('id', $id)->where('userID', $user->id)->first();
if ($trans->creditAccountID == 0) {
$month = Month::where('userID', $user->id)->where('name', date('M'))->first();
$month->cash = $month->cash + $trans->amount;
$month->save();
} else {
$debit = Account::find($trans->creditAccountID);
$debit->balance = $debit->balance + $trans->amount;
$debit->save();
}
if ($trans->debitAccountID == 0) {
$month = Month::where('userID', $user->id)->where('name', date('M'))->first();
$month->cash = $month->cash - $trans->amount;
$month->save();
} else {
$debit = Account::find($trans->debitAccountID);
$debit->balance = $debit->balance + $trans->amount;
$debit->save();
}
} else {
//payment
$trans = Payment::where('id', $id)->where('userID', $user->id)->first();
//add initial payment amount back on
if ($trans->creditAccountID == 0) {
$month = Month::where('userID', $user->id)->where('name', date('M'))->first();
$month->cash = $month->cash + $trans->amount;
$month->save();
} else {
$credit = Account::find($trans->creditAccountID);
$credit->balance = $credit->balance + $trans->amount;
$credit->save();
}
//add initial payment back on
$debit = Account::find($trans->debitAccountID);
$debit->balance = $debit->balance + $trans->amount;
$debit->save();
}
$trans->forceDelete();
return redirect('home')->with('message', 'Payment/Transfer deleted successfully.');
}
