public function getSpecificTransactions($id)
{
$acc_name = Transaction::with('banks')->DefaultApartment()->where('account_id', '=', $id)->first();
$lists = Transaction::where('account_id', '=', $id)->DefaultApartment()->latest()->paginate(20);
$accounts = Bankncash::DefaultApartment()->get();
$last = Transaction::with('banks')->where('account_id', '=', $id)->DefaultApartment()->latest()->first();
return view('transaction.specifictransactions', compact('lists', 'accounts', 'acc_name', 'last'));
}
public function lastTransactions($total = 20)
{
$transacions = Transaction::where('project_id', $this->id)->orderBy('created_at', 'DESC')->take($total)->get();
$textResult = "";
foreach ($transacions as $transacion) {
$textResult .= $transacion->created_at . " - " . $transacion->transtype . " - " . $transacion->params . "<br>";
}
return $textResult;
}
/**
*
* @param array $filter
* @return mixed
*/
public function buildQueryForCalculatingBalance(array $filter)
{
// Prepare the query
$query = Transaction::where('transactions.user_id', Auth::user()->id);
// Apply filters to the transaction query
foreach ($filter as $type => $value) {
switch ($type) {
case "singleDate":
case "fromDate":
case "toDate":
$query = $this->filterBasicsRepository->filterDates($query, $type, $value, true);
break;
case "accounts":
$query = $this->filterBasicsRepository->filterAccounts($query, $value);
break;
}
}
return $query;
}
public function getTransactions($id = Null)
{
if ($id == Null) {
\App::abort(404, 'Invalid User Id');
} else {
$user_id = $id;
}
$user = \App\User::where('id', $user_id)->first();
$myTransactions = \App\Models\Transaction::where('user_id', $user_id)->orderBy('created_at', 'desc')->get();
//dd($myTransactions);
return view('user.transactions', ['_menus' => $this->menuItems, 'login_url' => $this->login_url, 'transactions' => $myTransactions, 'user' => $user, 'dashBoardDetailsByAuthUser' => $this->userrepo->generalOverViewByAuthUser($user_id)]);
}
public function getReportsByDate()
{
$result = Transaction::where('created_at', '<=', Carbon::now())->where('type', '!=', 'Transfer')->get(['description as title', 'created_at as start'])->toArray();
$events['weekends'] = true;
$events['header'] = ["left" => "prev,next today", "center" => "title", "right" => "month,agendaWeek,agendaDay"];
$events['editable'] = false;
$events['eventLimit'] = true;
$events['events'] = $result;
$events['eventColor'] = '#116063';
return view('reports.datecalendar', compact('events'));
}
public function get_data_detail($id)
{
$transaction = Transaction::where('transactions.id', '=', $id)->join('customers', 'transactions.customer_id', '=', 'customers.id')->join('users', 'transactions.user_id', '=', 'users.id')->select('transactions.*', 'customers.name', 'customers.address', 'customers.phone', 'customers.membership', 'users.name as username')->firstOrFail();
$list_detail = TransactionDetail::where('transaction_details.transaction_id', '=', $id)->join('packages', 'transaction_details.package_id', '=', 'packages.id')->select('transaction_details.*', 'transaction_details.id as detail_id', 'packages.*')->paginate(25);
$data = ['transaction' => $transaction, 'detail_transaction' => $list_detail];
return $data;
}
public function getInviteFriends()
{
$authId = Auth::user()->id;
$myTransactions = \App\Models\Transaction::where('user_id', $authId)->orderBy('created_at', 'desc')->get();
//dd($myTransactions);
return view('home.invite-friends', ['_menus' => $this->menuItems, '_errorNotification' => $this->errorNotification, 'login_url' => $this->login_url, 'transactions' => $myTransactions, 'dashBoardDetailsByAuthUser' => $this->userrepo->generalOverViewByAuthUser($authId)]);
}
public function getTransactions($status = -1)
{
//any status
if ($status == -1) {
return Transactions::where('user_id', '=', $this->id)->orderBy('created_at', 'desc')->get()->all();
}
//status = $status
if ($status >= 0 && $status <= 3) {
return Transactions::where('user_id', '=', $this->id)->where('status', '=', $status)->orderBy('created_at', 'desc')->get()->all();
}
}
public function deleteOlderThan(Carbon $date)
{
$affected_rows = Transaction::where('updated_at', '<', $date)->delete();
return;
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
$lists = Transaction::where('payer_id', '=', $id)->get();
return view('crm.profileshow', compact('lists'));
}
