/** * Store a newly created resource in storage. * * @param Request $request * @return Response */ public function store(Request $request) { $transaction = new Transaction(); $transaction->item_name = $request->get('item_name'); $transaction->quantity = $request->get('quantity'); $transaction->price = $request->get('price'); $transaction->save(); return redirect('/transaction')->withSuccess("Transaction added {$transaction->item_name}"); }
public function receiveToken(Request $request) { $token = (string) $request->input('token'); $transaction = new Transaction(); $transaction->associated_name = $request->has('associated_name') ? $request->input('associated_name') : ''; $transaction->contains_please = $request->has('contains_please') ? $request->input('contains_please') : 0; $transaction->charge(100, ['source' => $token]); $transaction->save(); return response()->json(['status' => 'success']); }
/** * Handle the event. * * @param SubscriptionSucceeded $event * @return void */ public function handle(SubscriptionSucceeded $event) { // Get subscription id $query = Subscription::where('paymill_subscription_id', $event->subscription['id'])->first(); $transaction = new Transaction(); $transaction->paymill_transaction_id = $event->transaction['id']; $transaction->user_id = $event->userId; $transaction->subscription_id = $query->id; $transaction->amount = $event->transaction['amount']; $transaction->status = $event->transaction['status']; $transaction->response_code = $event->transaction['response_code']; $transaction->save(); }
public function getPartydue($invoiceId) { $totalPrice = 0; $totalAmount = 0; $sale = Sale::where('invoice_id', '=', $invoiceId)->first(); $saleDetails = SAleDetail::where('invoice_id', '=', $invoiceId)->get(); $transactions = Transaction::where('invoice_id', '=', $invoiceId)->where('payment_method', '=', 'Check')->where('type', '=', 'Receive')->where('cheque_status', '=', 1)->get(); foreach ($saleDetails as $saleDetail) { $totalPrice = $totalPrice + $saleDetail->price * $saleDetail->quantity; } $totalPrice -= $sale->discount_percentage; foreach ($transactions as $transaction) { $totalAmount = $totalAmount + $transaction->amount; } $transactions2 = Transaction::where('invoice_id', '=', $invoiceId)->where('type', '=', 'Receive')->where('payment_method', '!=', 'Check')->get(); foreach ($transactions2 as $transaction) { $totalAmount = $totalAmount + $transaction->amount; } $due = $totalPrice - $totalAmount; if ($due > 0) { return "Due is {$due}"; } else { return 'No due'; } }
public function testRemoveInUseTag() { $tags = $this->createTags(); $t = Transaction::create(['date' => '01/01/2016', 'name' => 'Rent', 'value' => 625]); $tags[0]->transactions()->save($t); $this->visitTagsPage()->press('Delete')->seePageIsTags()->seeInElement('ul.tags li', $tags[0]->name)->seeInElement('.alert-danger', 'Tag cannot be removed while in use'); }
/** * agreed to buy * @param Request * @return [type] */ public function postBuy(Request $request) { //MENU $mainMenu = Category::getParentMenu(); $allMenu = Category::getAllMenu($mainMenu); //HOT PRODUCTS. $hotProduct = Product::hotProduct(); //DISCOUNT PRODUCTS. $discountProduct = Product::discountProduct(); if (\Session::has('giohang')) { $data = \Session::get('giohang'); if ($request->get('account_number') != null) { $account_number = $request->get('account_number'); } else { $account_number = null; } $transaction = ['customer_id' => \Auth::id(), 'ship_id' => \Session::get('ship'), 'pay_id' => \Session::get('pay'), 'amount' => \Session::get('total'), 'message' => $request->get('message'), 'security' => time(), 'account_number' => $request->get('account_number')]; //dd($transaction); $transactions = Transaction::create($transaction); //dd($transactions->toArray()); foreach ($data as $key => $value) { $order = ['transaction_id' => $transactions->id, 'product_id' => $value['id'], 'qty' => $value['qty'], 'price_order' => $value['price'], 'discount_order' => $value['discount']]; $orders = Order::create($order); } $this->getCancel(); return view('fornindex.shopping_succeed', compact('allMenu', 'hotProduct', 'discountProduct')); } }
/** * Handle the event. * * @param SubscriptionFailed $event * @return void */ public function handle(SubscriptionFailed $event) { // Stop event propagation if subscription does not exists if (!$event->userId) { return false; } // Get subscription id $subscriptionQuery = Subscription::where('paymill_subscription_id', $event->subscription['id'])->first(); $transaction = new Transaction(); $transaction->paymill_transaction_id = $event->transaction['id']; $transaction->subscription_id = $subscriptionQuery->id; $transaction->user_id = $event->userId; $transaction->amount = $event->transaction['amount']; $transaction->status = $event->transaction['status']; $transaction->response_code = $event->transaction['response_code']; $transaction->save(); }
/** * показываем список транзакций за указанную дату для текущего пользователя * * @return \Illuminate\Http\Response */ public function getList($date = '') { $date = $date ?: date("Y-m-d"); $start = \Carbon::createFromFormat("Y-m-d", $date)->startOfDay()->toDateTimeString(); $end = \Carbon::createFromFormat("Y-m-d", $date)->endOfDay()->toDateTimeString(); // return ['content' => Transaction::with('card')->where('user_id', $this->user->id)->where('created_at', '>=', $start)->where('created_at', '<=', $end)->orderBy('created_at', 'DESC')->get()]; }
public function markResolved($id) { $transaction = Transaction::findOrFail($id); $transaction->markResolved(); $this->emailUser($transaction, "Resolved", "good"); $this->grantMembershipIfApplicable($transaction); return Redirect::back()->with("good", "Successfully marked payment as resolved."); }
public function update($id, $status) { if ($transaction = Transaction::find($id)) { $transaction->status = $status; $transaction->save(); } // Redirect back to the checkout return redirect($transaction->redirect_url); }
public function transaction($id) { $transaction = \App\Transaction::where('transaction_number', '=', $id)->get(); foreach ($transaction as $trns) { $t_num = $trns->transaction_number; } // dd($t_num); return view('dashboard.admin.transaction')->with(['transaction' => $transaction, 'user' => \Auth::User(), 't_num' => $t_num]); }
/** * @return bool */ public function process() { while ($line = fgetcsv($this->csv, 1000, ';')) { $transaction = Transaction::firstOrNew(['statement' => $line[2], 'amount' => $this->doConvertion($line[3]), 'balance' => $this->doConvertion($line[4]), 'executed' => Carbon::createFromFormat('d-m-Y', $line[0]), 'rate' => Carbon::createFromFormat('d-m-Y', $line[1])]); if (!$this->account->addTransaction($transaction)) { return false; } } return true; }
public function getDelete($id) { $transactions = \App\Transaction::find($id); if (is_null($transactions)) { \Session::flash('flash_message', 'Transaction not found.'); return redirect('/transactions/' . $transactions->account_id); } $transactions->delete(); \Session::flash('flash_message', 'Your "' . $transactions->trans_name . '" transaction was deleted.'); return redirect('/transactions/' . $transactions->account_id); }
/** * @param $id * @return \Illuminate\Http\RedirectResponse */ public function checkin($id) { $lastTransaction = Transaction::findLatest($id); if (!$lastTransaction->get()->isEmpty() && $lastTransaction->in_or_out == 'OUT') { $transaction = new Transaction(); $transaction->in_or_out = 'IN'; $transaction->transaction_id = $this->generateTransactionId($transaction->in_or_out); $transaction->due_date = NULL; $transaction->equipment_id = $id; $transaction->username = Auth::id(); // temporary $transaction->person_id = $lastTransaction->person_id; // temporary $transaction->save(); $this->generateReceiptEmail($transaction); return redirect()->route('inventory.index'); } else { return redirect()->route('inventory.index'); } }
public function destroy($id) { $userid = Auth::id(); $currentTransaction = Transaction::where('user_id', '=', $userid)->findOrFail($id); $purchasedItem = Item::where('user', $userid)->where('sku', $currentTransaction->sku)->first(); $inventoryQuantity = $currentTransaction->quantity; $newQuantity = $inventoryQuantity + $purchasedItem->quantity; $purchasedItem->update(array('quantity' => $newQuantity)); $currentTransaction->delete(); return redirect('home'); }
public function get_money(Request $request) { if ($request->register_id == null || $request->money == null || $request->code == null) { return $this->responseBadRequest('Not enough parameters!'); } $register_id = $request->register_id; $money = str_replace(array('.', ','), '', $request->money); $code = $request->code; $register = Register::find($register_id); if ($register->status == 1) { return $this->responseBadRequest('Học viên này đã đóng tiền rồi'); } $register->money = $money; $register->paid_time = format_time_to_mysql(time()); $register->note = $request->note; $register->staff_id = $this->user->id; $regis_by_code = Register::where('code', $code)->first(); if ($regis_by_code != null) { return $this->responseBadRequest('code is already existed'); } else { $register->code = $code; $register->status = 1; $register->save(); $transaction = new Transaction(); $transaction->money = $money; $transaction->sender_id = $this->user->id; $transaction->receiver_id = $register->id; $transaction->sender_money = $this->user->money; $transaction->note = "Học viên " . $register->user->name . " - Lớp " . $register->studyClass->name; $transaction->status = 1; $transaction->type = 1; $transaction->save(); DB::insert(DB::raw("\n insert into attendances(`register_id`,`checker_id`,class_lesson_id)\n (select registers.id,-1,class_lesson.id\n from class_lesson\n join registers on registers.class_id = class_lesson.class_id\n where registers.id = {$register->id}\n )\n ")); $current_money = $this->user->money; $this->user->money = $current_money + $money; $this->user->save(); send_mail_confirm_receive_studeny_money($register, ["*****@*****.**", "*****@*****.**"]); } $return_data = array('data' => ['money' => $register->money, 'code' => $register->code, 'paid_time' => format_date_full_option($register->paid_time)], 'message' => "success"); return $this->respond($return_data); }
public function getConfirm($tnx) { // return $tnx; $tnx_id = Crypt::decrypt($tnx); $rTw = substr($tnx_id, 0, 3); if ($rTw == 'r2w') { $confirmVar = Transaction::where('tnx_id', $tnx_id)->get(); return view('accounts.transferConfirmation', compact('confirmVar')); } else { $confirmVar = Transaction::where('tnx_id', $tnx_id)->get(); $forReceiver = Transaction::where('tnx_id', $tnx_id)->first()->related_id; $receiver = User::where('id', $forReceiver)->first()->username; return view('accounts.transferConfirmation', compact('confirmVar', 'receiver')); } }
public function getComplete3($id) { $register2 = Transaction::find($id); $register2->cheque_status = 1; if ($register2->payment_method == "Check") { if ($register2->cheque_date == '') { $register2->cheque_date = date("m/d/Y", time()); } $accountPayment = NameOfAccount::find($register2->account_name_id); $accountPayment->opening_balance = $accountPayment->opening_balance - $register2->amount; $accountPayment->save(); } $register2->save(); return Redirect::to('dashboard'); }
public function getPurchasedue($invoiceId) { $totalPrice = $this->getTotalAmount($invoiceId); $totalAmount = 0; $transactions = Transaction::where('invoice_id', '=', $invoiceId)->where('payment_method', '=', 'Check')->where('type', '=', 'Payment')->where('cheque_status', '=', 1)->get(); foreach ($transactions as $transaction) { $totalAmount = $totalAmount + $transaction->amount; } $transactions2 = Transaction::where('invoice_id', '=', $invoiceId)->where('type', '=', 'Payment')->where('payment_method', '!=', 'Check')->get(); foreach ($transactions2 as $transaction) { $totalAmount = $totalAmount + $transaction->amount; } $due = $totalPrice[0]->total - $totalAmount; return $due; }
public function placeOrder($request) { $shoppingCart = $request->session()->get('cart'); $shoppingCartItems = $request->session()->get('items'); $user = Auth::user(); $code = $request->input('coupon'); $coupon = Coupon::ofCode($code); $transaction = Transaction::create(array('id' => md5(uniqid()), 'coupon' => is_object($coupon) ? $coupon->id : '', 'user_id' => $user->id, 'order_data' => json_encode($shoppingCartItems), 'real_charges' => $request->input('realCharges'), 'amount_off' => $request->input('amountOff'))); ShoppingCartItem::where('shopping_cart_id', $shoppingCart->id)->delete(); if (is_object($coupon)) { Coupon::where('id', $coupon->id)->update(['times_redeemed' => $coupon->times_redeemed + 1]); } $request->session()->forget('items'); $request->session()->put('itemsCtr', 0); }
protected function computeBalance($id) { $balance = 0; $transactions = Transaction::where('investor_id', $id)->orderBy('transactionDate', 'asc')->get(); foreach ($transactions as $key => $value) { if ($value->transactionType->account_type === 'DR') { $balance -= $value->amount; } else { $balance += $value->amount; } $value->runningBalance = $balance; $value->save(); } return $balance; }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { // get user's categories $categories = Category::with('transactions')->where('user_id', Auth::user()->id)->orderBy('name', 'ASC')->get(); // get all transactions of the user $transactions = Transaction::where('user_id', Auth::user()->id)->get(); // calculate total income and total expense $incomeTotal = $transactions->where('type', 'DEPOSIT')->sum('amount'); $expenseTotal = $transactions->where('type', 'WITHDRAWAL')->sum('amount'); // get uncategorized transactions $transactions = Transaction::where('user_id', Auth::user()->id)->whereNull('category_id')->get(); // stuff to pass into view $title = "Categories"; $heading = "Categories"; return view('categories.index', compact('categories', 'transactions', 'incomeTotal', 'expenseTotal', 'title', 'heading')); }
public function verify() { $data = \Input::all(); $transaction = \App\Transaction::where('transaction_number', '=', $data['t_num'])->get(); $status = \App\Status::find(1); foreach ($transaction as $trns) { $trns->verify(); $slots = $trns->slots; foreach ($slots as $slot) { $slot->verifySlot($slot); $slot->rank($slot); } } $trns->verify(); return redirect('valence'); }
/** * заполнение таблицы пранзакций */ private function transactionsTable() { Transaction::truncate(); $u = User::count(); $c = Card::count(); $i = 0; while ($i < 10) { ++$i; Transaction::create(['user_id' => rand(1, $u), 'card_id' => rand(1, $c), 'money' => rand(0, 1000)]); } $crd = Card::all(); foreach ($crd as $v) { $v->balance = Transaction::where('card_id', $v->id)->sum('money'); $v->save(); } }
/** * Responds to requests to */ public function getPage($id = null) { // get the transaction $transaction = \App\Transaction::where('public_item_id', '=', $id)->first(); //dump($transaction); $transactionArray = $transaction->public_item->toArray(); //dump($transactionArray); $transactionArray["transaction_type"] = $transaction->transaction_type; $transactionArray["transaction_date"] = $transaction->created_at; $transactionArray["tax"] = $transaction->tax; $transactionArray["total"] = $transaction->total; //dump($transactionArray); $transactionObject = (object) $transactionArray; //$addedItemsArray = $addedItems->toArray(); return view('pongo.transaction_details')->with('transaction', $transactionObject); }
public function save($id, TransactionItemSaveRequest $request, ProductRepository $productRepository) { $transactionItem = $this->transactionItemRepository->getById($id); if ($transactionItem && Gate::denies('save', $transactionItem)) { return $this->json->error('You cannot alter other\'s Transactions ...'); } if (!$transactionItem) { $transactionItem = new TransactionItem(); } $product = $productRepository->getById($request->get('amazon_product_id')); if (!$product) { return $this->json->error('No Product Associated'); } $transactionItem->fill($request->except(['transaction_id'])); Transaction::find($request->get('transaction_id'))->items()->save($transactionItem); return $this->json->success(); }
public function getDashboard() { $reports = new Report(); $totalProducts = $reports->getTotalProducts(); $totalImports = $reports->getTotalImports(); $totalSales = $reports->getTotalSalesToday(); $totalPurchase = $reports->getTotalPurchaseToday(); $accountsBalance = $reports->getAccountBalances(); $accountBalanceTransfers = $reports->getBalanceTransferFullReport(); $stocksBranch = $reports->getStocksBranch(); $stockRequisitions = StockRequisition::orderBy('id', 'desc')->take(3)->get(); $latestTransactions = Transaction::orderBy('id', 'desc')->take(5)->get(); $register = Transaction::where('payment_method', '=', 'check')->where('type', '=', 'Receive')->where('cheque_status', '=', 0)->orderBy('id', 'desc')->get(); $purchaseregister = Transaction::where('payment_method', '=', 'check')->where('type', '=', 'Payment')->where('cheque_status', '=', 0)->orwhere('type', '=', 'Expense')->where('cheque_status', '=', 0)->orderBy('id', 'desc')->get(); //var_dump($stockRequisitions); return view('Users.dashboard')->with('latestTransactions', $latestTransactions)->with('totalProducts', $totalProducts)->with('totalSales', $totalSales)->with('stockRequisitions', $stockRequisitions)->with('stocksBranch', $stocksBranch)->with('accountsBalance', $accountsBalance)->with('accountBalanceTransfers', $accountBalanceTransfers)->with('totalPurchase', $totalPurchase)->with('totalImports', $totalImports)->with('register', $register)->with('purchaseregister', $purchaseregister); }
public function process() { $transactionID = Input::get('transactionID'); $transaction = Transaction::where('transaction_id', '=', $transactionID)->first(); $logs = Log::where('transaction_id', '=', $transactionID)->get(); $recentLog = Log::where('transaction_id', '=', $transactionID)->orderBy('created_at', 'desc')->first(); if (Input::has('create')) { // Redirect to different route / URI return Redirect::route('superadmin/create_transaction')->with('transactionID', $transactionID); // Alternatively, you could process action 1 here } elseif (Input::has('update')) { // Process action 2 return Redirect::route('superadmin/update_transaction')->with('transaction', $transaction)->with('logs', $logs)->with('recentLog', $recentLog); } elseif (Input::has('out')) { // Process action 3 return Redirect::route('superadmin/out_transaction')->with('transaction', $transaction)->with('logs', $logs)->with('users', '')->with('recentLog', $recentLog); } }
/** * Display the specified resource. * * @param int $id * @return Response */ public function showTransaction() { // $transaction = Transaction::find($id); $id = Input::get('transaction_id'); $pw = Input::get('password'); // $transaction = Transaction::find($id); $transaction = Transaction::where('transaction_id', '=', $id)->first(); if ($transaction == null) { return Redirect::route('customer')->with('transaction', $transaction)->with('message', 'Invalid Transaction ID or Password'); } else { $transpas = $transaction->password; if ($transpas == $pw) { return Redirect::route('customer')->with('transaction', $transaction)->with('message', 'Transaction found'); } else { return Redirect::route('customer')->with('transaction', $transaction)->with('message', 'Invalid Transaction ID or Password'); } } }
public function complete(Request $request, $id) { $userid = Auth::id(); $transaction_id = Transaction::where('user_id', $userid)->where('status', 'open')->first()->transaction_id; $totalValue = Transaction::where('user_id', $userid)->where('status', 'open')->sum('price'); $tax = 0.08; $total = $totalValue * $tax + $totalValue; $change = $id; $notes = $request->input('notes'); $cash_received = $change + $total; //store receipt Receipt::create(array('transaction_id' => $transaction_id, 'user_id' => $userid, 'total' => $total, 'cash_received' => $cash_received, 'change' => $change, 'notes' => $notes)); //close transaction $transactionItems = Transaction::where('user_id', $userid)->where('status', 'open')->get(); foreach ($transactionItems as $item) { $item->update(array('status' => 'closed')); } return redirect('home'); }