/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(AccountRequest $request) { $account = new Account(['glosa' => $request['glosa'], 'montoDebe' => $request['sumDebe'], 'montoHaber' => $request['sumHaber'], 'transaction_id' => $request['nume']]); $account->save(); Session::flash('message', 'Comprobante creado'); return redirect()->route('newAccount'); }
/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { // validate request $this->validate($request, ['name' => 'required|max:32']); // limit user to max 5 accounts if (User::find(Auth::user()->id)->accounts->count() >= 5) { // stuff to pass into view $title = "Error"; $errmsg = "You have reached your maximum account limit."; return view('errors.error', compact('errmsg', 'title', 'heading')); } // prevent duplicate categories $accounts = User::find(Auth::user()->id)->accounts; foreach ($accounts as $account) { if (strcasecmp($account->name, $request->name) == 0) { // stuff to pass into view $title = "Error"; $errmsg = "You already have a account with the name."; return view('errors.error', compact('errmsg', 'title', 'heading')); } } // create a new account $account = new Account(); // assign data $account->user_id = Auth::user()->id; $account->name = $request->name; // save the new record $account->save(); // flash message session()->flash('flash_message', 'Account created successfully.'); // redirect to accounts index return redirect()->route('accounts.index'); }
/** * Store a newly created resource in storage. * * @param Request $request * @return Response */ public function store(Request $request) { $this->validate($request, ['account' => 'required|unique:accounts|max:100']); $account = new Account(); $account->account = $request->account; $account->save(); Session::flash('flash_message', 'Account successfully added!'); return redirect()->route("account.index"); }
public function postStore() { $validator = Validator::make(Input::all(), $this->rules); if ($validator->fails()) { return Redirect::back()->withErrors($validator)->withInput(); } else { $game = Game::findOrFail(Input::get('game_id')); $account = new Account(['username' => Input::get('username'), 'password' => Input::get('password'), 'user_id' => Auth::user()->id, 'game_id' => $game->id]); $account->save(); return Redirect::to(route('account.show', $account->id)); } }
public function accounts($num = 20) { for ($i = 0; $i < $num; $i++) { $account = new Account(); $account->name = $this->faker->company; $account->description = $this->faker->text(200); $account->type = $this->faker->randomElement($array = array('personal', 'corporate')); $account->save(); if ($account->type == 'corporate') { $this->users($this->faker->numberBetween(2, 30), $account->id, null); } else { $this->users(1, $account->id, null); } } User::rebuild(); $this->rebuildLeads(); return \Response::make(200); }
/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(LoanApprovalRequest $request) { $appli = LoanApplication::findOrFail($request->id); //$appli->accepted = $request::get('accept'); //$appli->save(); //if($appli->accepted=='true'){ if ($request->accept == 'true') { $acc = new Account(); $acc->loan_id = $appli->loan_id; $acc->member_id = $appli->member_id; $acc->terms = $appli->terms; $acc->amountGranted = $appli->amountGranted; $acc->comaker = $appli->comaker; $acc->dateGranted = $request->date; $acc->dueDate = $acc->dateGranted; $acc->dueDate->addDays($acc->terms); $acc->balance = $acc->amountGranted; $acc->save(); $ledger = new Ledger(); $ledger->account_id = $acc->id; $ledger->curDate = $acc->dateGranted; $ledger->particulars = $request->particular; $ledger->reference = $request->reference; $ledger->avaiment = $acc->amountGranted; $ledger->amountPayed = 0; $ledger->interestDue = 0.0; $ledger->penaltyDue = 0.0; $ledger->principal = 0.0; $ledger->interestPayed = 0.0; $ledger->penaltyPayed = 0.0; $ledger->balance = $acc->amountGranted; $acc->balance = $acc->amountGranted; //toodo $ledger->save(); } $appli->delete(); flash()->success("Success!"); return redirect('/admin'); }
public function run() { $start_date = ''; $end_date = ''; $folderpath = 'database/seeds/seed_files'; $folders = File::directories($folderpath); $latest = '11232015'; foreach ($folders as $value) { $_dir = explode("/", $value); $cnt = count($_dir); $name = $_dir[$cnt - 1]; $latest_date = DateTime::createFromFormat('mdY', $latest); $now = DateTime::createFromFormat('mdY', $name); if ($now > $latest_date) { $latest = $name; } } $file_path = $folderpath . "/" . $latest . "/Store Mapping.xlsx"; echo (string) $file_path, "\n"; // dd($file_path); Model::unguard(); DB::statement('SET FOREIGN_KEY_CHECKS=0;'); DB::table('audit_templates')->truncate(); Excel::selectSheets('Sheet1')->load($file_path, function ($reader) { $records = $reader->get(); $records->each(function ($row) { if (!is_null($row->template)) { $template = AuditTemplate::where('template', $row->template)->first(); if (count($template) == 0) { $newtemplate = new AuditTemplate(); $newtemplate->template_code = $row->channel_code; $newtemplate->template = $row->template; $newtemplate->save(); } } }); }); DB::table('grade_matrixs')->truncate(); Excel::selectSheets('Sheet1')->load($file_path, function ($reader) { $records = $reader->get(); $records->each(function ($row) { if (!is_null($row->enrollment_type)) { $matrix = GradeMatrix::where('desc', $row->enrollment_type)->first(); if (count($matrix) == 0) { $newmatrix = new GradeMatrix(); $newmatrix->desc = $row->enrollment_type; $newmatrix->save(); } } }); }); DB::table('users')->truncate(); DB::table('role_user')->truncate(); Excel::selectSheets('Sheet1')->load($file_path, function ($reader) { $records = $reader->get(); $records->each(function ($row) { if (!is_null($row->fullname)) { $userlist = explode("/", $row->fullname); $emaillist = explode("/", $row->email); // dd($row); for ($i = 0; $i < count($userlist); $i++) { $user = User::where('username', $row->username)->first(); if (count($user) == 0) { if (empty($emaillist[$i])) { $email = strtolower($row->username . "@unilever.com"); } else { $email = strtolower($emaillist[$i]); } $newuser = User::create(array('name' => strtoupper($userlist[$i]), 'email' => $email, 'username' => $row->username, 'password' => Hash::make('password'))); $newuser->roles()->attach(3); } else { // $user->name = strtoupper($row->fullname); // $user->username = $row->username; // $user->email = strtolower($row->email); // $user->update(); // if(!$user->hasRole('field')){ // $user->roles()->attach(3); // } // echo $user->hasRole('field'); } } } }); }); DB::table('accounts')->truncate(); Excel::selectSheets('Sheet1')->load($file_path, function ($reader) { $records = $reader->get(); $records->each(function ($row) { if (!is_null($row->account)) { $account = Account::where('account', $row->account)->first(); if (count($account) == 0) { $newaccount = new Account(); $newaccount->account = $row->account; $newaccount->save(); } } }); }); DB::table('customers')->truncate(); Excel::selectSheets('Sheet1')->load($file_path, function ($reader) { $records = $reader->get(); $records->each(function ($row) { if (!is_null($row->account)) { // var_dump($row); $account = Account::where('account', $row->account)->first(); if (!empty($account)) { $customer = Customer::where('account_id', $account->id)->where('customer_code', $row->customer_code)->where('customer', $row->customer)->first(); if (count($customer) == 0) { $newcustomer = new Customer(); $newcustomer->account_id = $account->id; $newcustomer->customer_code = $row->customer_code; $newcustomer->customer = $row->customer; $newcustomer->save(); } } } }); }); DB::table('areas')->truncate(); Excel::selectSheets('Sheet1')->load($file_path, function ($reader) { $records = $reader->get(); $records->each(function ($row) { if (!is_null($row->account)) { $account = Account::where('account', $row->account)->first(); if (!empty($account)) { $customer = Customer::where('account_id', $account->id)->where('customer_code', $row->customer_code)->where('customer', $row->customer)->first(); if (!empty($customer)) { $area = Area::where('customer_id', $customer->id)->where('area', $row->area)->first(); if (count($area) == 0) { $newarea = new Area(); $newarea->customer_id = $customer->id; $newarea->area = $row->area; $newarea->save(); } } } } }); }); DB::table('regions')->truncate(); Excel::selectSheets('Sheet1')->load($file_path, function ($reader) { $records = $reader->get(); $records->each(function ($row) { if (!is_null($row->account)) { $region = Region::where('region_code', $row->region_code)->where('region', $row->region)->first(); if (count($region) == 0) { $newregion = new Region(); $newregion->region_code = $row->region_code; $newregion->region = $row->region; $newregion->save(); } } }); }); DB::table('distributors')->truncate(); Excel::selectSheets('Sheet1')->load($file_path, function ($reader) { $records = $reader->get(); $records->each(function ($row) { if (!is_null($row->account)) { $dis = Distributor::where('distributor_code', $row->distributor_code)->where('distributor', $row->distributor)->first(); if (count($dis) == 0) { $newdis = new Distributor(); $newdis->distributor_code = $row->distributor_code; $newdis->distributor = strtoupper($row->distributor); $newdis->save(); } } }); }); DB::table('stores')->truncate(); DB::table('store_user')->truncate(); Excel::selectSheets('Sheet1')->load($file_path, function ($reader) { $records = $reader->get(); $records->each(function ($row) { if (!is_null($row->account)) { $account = Account::where('account', $row->account)->first(); if (!empty($account)) { $customer = Customer::where('account_id', $account->id)->where('customer_code', $row->customer_code)->where('customer', $row->customer)->first(); if (!empty($customer)) { $region = Region::where('region_code', $row->region_code)->first(); $dis = Distributor::where('distributor_code', $row->distributor_code)->first(); $store = Store::where('account_id', $account->id)->where('customer_id', $customer->id)->where('region_id', $region->id)->where('distributor_id', $dis->id)->where('store_code', $row->store_code)->where('store', $row->store_name)->first(); if (count($store) == 0) { $template = AuditTemplate::where('template', $row->template)->first(); $matrix = GradeMatrix::where('desc', $row->enrollment_type)->first(); $newstore = new Store(); $newstore->account_id = $account->id; $newstore->customer_id = $customer->id; $newstore->region_id = $region->id; $newstore->distributor_id = $dis->id; $newstore->store_code = $row->store_code; $newstore->store = $row->store_name; $newstore->grade_matrix_id = $matrix->id; $newstore->audit_template_id = $template->id; $newstore->save(); $emaillist = explode("/", $row->email); for ($i = 0; $i < count($emaillist); $i++) { if (empty($emaillist[$i])) { $email = strtolower($row->username . "@unilever.com"); } else { $email = strtolower($emaillist[$i]); } $user = User::where('email', $email)->first(); $newstore->users()->attach($user->id); } } else { $emaillist = explode("/", $row->email); for ($i = 0; $i < count($emaillist); $i++) { if (empty($emaillist[$i])) { $email = strtolower($row->username . "@unilever.com"); } else { $email = strtolower($emaillist[$i]); } $user = User::where('email', $email)->first(); $store->users()->attach($user->id); } } } } } }); }); DB::statement('SET FOREIGN_KEY_CHECKS=1;'); Model::reguard(); }
public function account(Request $request) { $login = Login::where('remember_token', '=', $request->header('token'))->where('status', '=', '1')->where('login_from', '=', $request->ip())->first(); $account = new Account(); $account->addedBy = $login->member_id; $account->memberId = $request['memberId']; $account->amount = $request['amount']; $account->type = $request['type']; $account->save(); $returnData = array('status' => 'ok', 'account' => $account, 'message' => "Account updated Successfully", 'code' => 200, 'account' => $account); return $returnData; }
public function transferToDelivery(Request $request) { $metaData = MetaData::where('meta_key', 'server_status')->first(); if ($metaData['meta_value'] == 0) { $errorData = array('status' => 'fail', 'message' => 'Sorry! Server is closed. Please try later.', 'code' => '422'); return Response::json($errorData, 422); } $login = Login::where('remember_token', '=', $request->header('token'))->where('login_from', '=', $request->ip())->join('members', 'members.id', '=', 'logins.member_id')->where('logins.status', '=', '1')->first(); $clientStock = ClientStock::find($request['clientStockId']); $account = new Account(); if ($account->getAccount($login->member_id) < $clientStock->remaining_cost + $clientStock->delivery_charge) { $errorData = array('status' => 'fail', 'message' => 'Insufficient Balance!', 'code' => '422'); return Response::json($errorData, 422); } if ($clientStock->memberId != $login->member_id) { $errorData = array('status' => 'fail', 'message' => 'Invalid Request!', 'code' => '422'); return Response::json($errorData, 422); } else { $clientStock->status = 4; $clientStock->save(); $account = new Account(); $account->ticket = $clientStock->ticket; $account->amount = $clientStock->remaining_cost + $clientStock->delivery_charge; $account->type = 0; $account->addedBy = $login->member_id; $account->memberId = $clientStock->memberId; $account->save(); $returnData = array('status' => 'ok', 'code' => '200', 'clientStock' => $clientStock, 'account' => $account); return Response::json($returnData, 200); } }
public function postIndex() { $user = Auth::user(); $id = Input::get('payment'); /* *There is an invisible field called form that tells what form was submitted * */ if (Input::get('form') == 'trans') { $monthNum = substr(Input::get('date'), 0, 2); $month = date('M', mktime(0, 0, 0, $monthNum, 10)); $year = substr(Input::get('date'), -4); $transaction = new Transaction(); $transaction->userID = $user->id; $transaction->date = Input::get('date'); $transaction->amount = Input::get('amount'); $transaction->typeID = Input::get('type'); $transaction->note = Input::get('note'); $transaction->year = $year; $transaction->month = $month; if ($id == 'cash') { $month = Month::where('userID', $user->id)->where('name', $month)->where('year', date("Y"))->first(); $month->cash -= Input::get('amount'); $month->save(); $transaction->accountID = 0; } else { $transaction->accountID = $id; $account = Account::find($id); //add for credit subtract for bank if ($account->accountType == 'c') { $account->balance += Input::get('amount'); } else { $account->balance -= Input::get('amount'); } $account->save(); } $transaction->save(); return redirect('options')->with('message', 'Transaction added successfully.'); } else { if (Input::get('form') == 'type') { $type = new Type(); $type->userID = $user->id; $type->name = Input::get('name'); $type->save(); return redirect('options')->with('message', 'Category added successfully.'); } else { if (Input::get('form') == 'payment') { $monthNum = substr(Input::get('date'), 0, 2); $month = date('M', mktime(0, 0, 0, $monthNum, 10)); $year = substr(Input::get('date'), -4); $amount = Input::get('amount'); $bankID = Input::get('bank'); $ccID = Input::get('payment'); $note = Input::get('note'); $date = Input::get('date'); if ($ccID == 'cash') { $month2 = Month::where('userID', $user->id)->where('name', $month)->first(); $month2->cash = $month2->cash + $amount; $month2->save(); if ($bankID == 'cash') { $month2 = Month::where('userID', $user->id)->where('name', $month)->first(); $month2->cash = $month2->cash - $amount; $month2->save(); } else { $bank = Account::find($bankID); $bank->balance = $bank->balance - $amount; $bank->save(); } $transfer = new Transfer(); $transfer->userID = $user->id; $transfer->creditAccountID = $bankID; $transfer->debitAccountID = 0; $transfer->amount = $amount; $transfer->note = $note; $transfer->date = $date; $transfer->year = $year; $transfer->month = $month; $transfer->save(); } else { $cc = Account::find($ccID); if ($bankID == 'cash') { $month2 = Month::where('userID', $user->id)->where('name', $month)->first(); $month2->cash = $month2->cash - $amount; $month2->save(); } else { $bank = Account::find($bankID); $bank->balance = $bank->balance - $amount; $bank->save(); } if ($cc->accountType == 'b') { //transfer $cc->balance = $cc->balance + $amount; $transfer = new Transfer(); $transfer->userID = $user->id; $transfer->creditAccountID = $bankID; $transfer->debitAccountID = $ccID; $transfer->amount = $amount; $transfer->note = $note; $transfer->date = $date; $transfer->year = $year; $transfer->month = $month; $transfer->save(); } else { //payment $cc->balance = $cc->balance - $amount; $payment = new Payment(); $payment->userID = $user->id; $payment->creditAccountID = $bankID; $payment->debitAccountID = $ccID; $payment->amount = $amount; $payment->note = $note; $payment->date = $date; $payment->year = $year; $payment->month = $month; $payment->save(); } $cc->save(); } return redirect('options')->with('message', 'Payment saved successfully.'); } else { if (Input::get('form') == 'cc') { $cc = new Account(); $cc->userID = $user->id; $cc->name = Input::get('name'); $cc->balance = Input::get('balance'); $cc->creditLimit = Input::get('limit'); $cc->statementDay = Input::get('date'); $cc->accountType = 'c'; $cc->save(); return redirect('options')->with('message', 'Credit Card added successfully.'); } else { if (Input::get('form') == 'bank') { $bank = new Account(); $bank->userID = $user->id; $bank->name = Input::get('name'); $bank->balance = Input::get('balance'); $bank->accountType = 'b'; $bank->save(); return redirect('options')->with('message', 'Bank Account added successfully.'); } else { if (Input::get('form') == 'income') { $date = Input::get('date'); $monthNum = substr($date, 0, 2); $month = date('M', mktime(0, 0, 0, $monthNum, 10)); $amount = Input::get('amount'); $bankID = Input::get('bank'); $year = substr(Input::get('date'), -4); $income = new Income(); $income->userID = $user->id; $income->month = $month; $income->amount = $amount; $income->note = Input::get('note'); $income->date = $date; $income->year = $year; if ($bankID == "cash") { $income->accountID = 0; $month = Month::where('userID', $user->id)->where('name', $month)->first(); $month->cash = $month->cash + $amount; $month->save(); } else { $income->accountID = $bankID; $bank = Account::find($bankID); $bank->balance = $bank->balance + $amount; $bank->save(); } $income->save(); return redirect('options')->with('message', 'Income added successfully.'); } } } } } } }
public function addBusStop(Request $request, $id) { $input = $request->all(); $agent = Merchant::find($id); if (isset($input['type']) && $input['type'] == 'genticket') { $validator = Validator::make($request->all(), ["terminal_id" => "required", "ticket_type" => "required"]); if ($validator->fails()) { if ($request->ajax()) { return response()->json($validator->messages()); } else { return \Redirect::back()->withErrors($validator)->withInput(); } } //$input = $request->all(); $stack = new Ticketstack(); $stack->batch_code = Ticket::stackCode(); $stack->created_at = date("Y-m-d H:i:s"); $stack->save(); $ticket = new Ticket(); $terminal = Busstop::where("id", "=", trim($input['terminal_id']))->first(); $count = $input['qty']; $account = Account::where("app_id", "=", $input['app_id'])->first(); for ($k = 1; $k <= $count; $k++) { $time = time(); DB::table('ticketseed')->insert(['code' => $time]); $mid = DB::table("ticketseed")->max("id"); //$amount = ($input['ticket_type'] == 1) ? $terminal->one_way_to_fare : $terminal->one_way_from_fare ; $amount = 1000; Ticket::insert(array("code" => $ticket->ticketCode($mid), "account_id" => $account->id, "app_id" => $input['app_id'], "agent_id" => $id, "serial_no" => $ticket->uniqueID($mid), "terminal_id" => $terminal->id, "stack_id" => $stack->id, "route_id" => $input['route_id'], "amount" => $amount, "ticket_type" => $input['ticket_type'])); } $account->balance += $amount * $input['qty']; $agent->balance += $amount * $input['qty']; $account->update(); $agent->update(); } else { $account = new Account(); $mid = Account::uniqueID() + 1; $terminal_id = DB::table("busstops")->where("short_name", "=", $input['short_name'])->pluck("id"); $account->merchant_id = $input['merchant_id']; $account->busstop_id = $terminal_id; $m = $account->merchant_id + $mid; $realid = uniqid($m); $realid = substr($realid, -1, 5); $realid = $realid . str_pad($mid, 5, 0, STR_PAD_LEFT); $account->account_id = uniqid($m); if ($account->save()) { return response()->json("record saved successfully"); } } }
/** * save. * * @param Account $account account * @param Request $input 输入 */ public function savePost($account, $input) { $account->fill($input); return $account->save(); }
/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(CreateLoanRequest $request) { //dd($request->loan_id); $acc = new Account(); $acc->loan_id = $request->loan_id; $acc->member_id = $request->member_id; $acc->terms = $request->terms; $acc->amountGranted = $request->amount; $acc->comaker = $request->comaker; $acc->dateGranted = $request->dateGranted; $acc->dueDate = $acc->dateGranted; $acc->dueDate->addDays($acc->terms + 1); $acc->balance = $acc->amountGranted; $acc->save(); $insurance = 0.0; $cbu = 0.0; $sfee = 0.0; $advint = 0.0; switch ($acc->loan_id - 1) { case 0: $today = \Carbon\Carbon::now(); $mm = $today->month; if ($mm == 12 || $mm == 1) { $insurance = 0; //todo } else { if ($mm >= 6 && $mm <= 8) { $insurance = $acc->amountGranted * 0.15; } } $cbu = 500 * $acc->member->landArea; break; case 1: $cbu = 500; break; case 2: case 3: case 4: case 5: $advint = $acc->amountGranted * $acc->loan->intRate * $acc->terms / 360 / 2; break; case 6: //wala break; } $sfee = $acc->amountGranted * $acc->loan->sFee; //$total = $advint+$pcic+$insurance+$sfee+$sdeposit+$mortuary+$cbu+$balance+$penalty; $total = $advint + $insurance + $sfee + $cbu; $net = $acc->amountGranted - $total; $ledger = new Ledger(); $ledger->account_id = $acc->id; $ledger->curDate = date('Y-m-d'); $ledger->particulars = 'LOAN'; $ledger->reference = $acc->id; $ledger->avaiment = $acc->amountGranted; $ledger->amountPayed = 0; $ledger->interestDue = 0.0; $ledger->penaltyDue = 0.0; $ledger->principal = 0.0; $ledger->interestPayed = 0.0; $ledger->penaltyPayed = 0.0; $ledger->balance = $acc->amountGranted; $acc->balance = $acc->amountGranted; //toodo $ledger->save(); $inwords = $this->convert_number_to_words($net); return \PDF::loadHTML(view('reports.report1', compact('insurance', 'cbu', 'sfee', 'advint', 'total', 'net', 'acc', 'inwords')))->stream('test.pdf'); //flash()->success("Success!"); //return redirect('/admin'); }