public static function storeData($data) { $date = $data['date']; unset($data['date']); if (!empty($data)) { foreach ($data as $tempdata) { $dbcurrency = Currency::where('currency_name', $tempdata['currency'])->get(); if (empty($dbcurrency->all())) { $newcurrency = new Currency(); $newcurrency->currency_name = $tempdata['currency']; $newcurrency->save(); } $currencyid = Currency::where('currency_name', $tempdata['currency'])->first()->id; $search = ['date' => $date, 'currency_id' => $currencyid]; $dbvalues = Value::where($search)->get(); if (empty($dbvalues->all())) { $newvalue = new Value(); $newvalue->currency_id = $currencyid; $newvalue->value = $tempdata['value']; $newvalue->date = $date; $newvalue->save(); } } } else { $search = ['date' => $date, 'currency_id' => '0']; $dbvalues = Value::where($search)->get(); if (empty($dbvalues->all())) { $newvalue = new Value(); $newvalue->currency_id = '0'; $newvalue->value = '0'; $newvalue->date = $date; $newvalue->save(); } } }
public function index() { $data = Company::with('currency')->get(); $currency = Currency::all(); $timezones = Common::timezone(); return view('companies.list', ['data' => $data, 'currency' => $currency, 'timezones' => $timezones]); }
/** * Update the specified resource in storage. * PUT /currencies/{id} * * @param int $id * @return Response */ public function update($id, Request $request) { $currency = Currency::findOrFail($id); $this->validate($request, Currency::$rules); $currency->update($request->all()); return redirect('currencies')->with('success', l('This record has been successfully updated :: (:id) ', ['id' => $id], 'layouts') . $request->get('name')); }
/** * Run the database seeds. * * @return void */ public function run() { $currency = Currency::create(['ISO_symbol' => 'KUD', 'Kudos_exchange' => 1.0, 'country_organization' => 'Kudotsu', 'type' => 'Virtual', 'description' => 'Kudos', 'daily_limit' => 1000000.0, 'transaction_limit' => 100000.0]); $currency = Currency::create(['ISO_symbol' => 'USD', 'Kudos_exchange' => 1000.0, 'country_organization' => 'US', 'type' => 'Country', 'description' => 'US Dollar', 'daily_limit' => 1000.0, 'transaction_limit' => 100.0]); $currency = Currency::create(['ISO_symbol' => 'SGD', 'Kudos_exchange' => 7142.0, 'country_organization' => 'SG', 'type' => 'Country', 'description' => 'Singapore Dollar', 'daily_limit' => 1000.0, 'transaction_limit' => 50.0]); $currency = Currency::create(['ISO_symbol' => 'AUD', 'Kudos_exchange' => 7400.0, 'country_organization' => 'AU', 'type' => 'Country', 'description' => 'Australian Dollar', 'daily_limit' => 2000.0, 'transaction_limit' => 100.0]); }
/** * Fetch currencies from database * * @param bool * * @return Illuminate\Database\Eloquent\Collection (of Currency) */ protected function getCurrencies($withTrashed) { $currencies = Currency::select('id', 'code', 'name')->orderBy('name'); if ($withTrashed) { $currencies->withTrashed(); } return $currencies->get(); }
public function index() { //krabab tänase päeva feedi $date = date("Y-m-d", mktime(0, 0, 0, date("m"), date("d") - 1, date("Y"))); if (Helpers::CheckDB($date) == 0) { Helpers::StoreAll($date); } $dbcurrency = Currency::lists('currency_name', 'id'); return view('index', compact('dbcurrency')); }
/** * Run the database seeds. * * @return void */ public function run() { DB::table('currencies')->delete(); Currency::create(['currency_code' => 'INR', 'name' => 'indian rupee']); Currency::create(['currency_code' => 'USD', 'name' => 'US dollar']); }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { $currency = Currency::findOrFail($id); $currency->delete(); Session::flash('message', 'El registro fue eliminado'); return redirect()->route('settings.currency.index'); }
/** * Bootstrap the application services. * * @return void */ public function boot() { // Currencies view()->composer(array('customers.edit', 'customer_invoices.create', 'companies.edit', 'customer_groups.create', 'customer_groups.edit'), function ($view) { $view->with('currencyList', \App\Currency::lists('name', 'id')); }); // Customer Groups view()->composer(array('customers.edit'), function ($view) { $view->with('customer_groupList', \App\CustomerGroup::lists('name', 'id')); }); // Payment Methods view()->composer(array('customers.edit', 'customer_invoices.create', 'customer_groups.create', 'customer_groups.edit'), function ($view) { $view->with('payment_methodList', \App\PaymentMethod::lists('name', 'id')); }); // Sequences view()->composer(array('customers.edit', 'customer_invoices.create', 'customer_groups.create', 'customer_groups.edit'), function ($view) { $view->with('sequenceList', \App\Sequence::lists('name', 'id')); }); // Invoice Template view()->composer(array('customers.edit', 'customer_invoices.create', 'customer_groups.create', 'customer_groups.edit'), function ($view) { $view->with('customerinvoicetemplateList', \App\Template::where('model_name', '=', 'CustomerInvoice')->lists('name', 'id')); }); // Carriers view()->composer(array('customers.edit', 'customer_invoices.create', 'customer_groups.create', 'customer_groups.edit'), function ($view) { $view->with('carrierList', \App\Carrier::lists('name', 'id')); }); // Sales Representatives view()->composer(array('customers.edit', 'customer_invoices.create'), function ($view) { $view->with('salesrepList', \App\SalesRep::select(DB::raw('concat (firstname," ",lastname) as name, id'))->lists('name', 'id')); }); // Price Lists view()->composer(array('customers.edit', 'customer_groups.create', 'customer_groups.edit'), function ($view) { $view->with('price_listList', \App\PriceList::lists('name', 'id')); }); // Warehouses view()->composer(array('products.create', 'stock_movements.create', 'configurationkeys.key_group_2', 'customer_invoices.create'), function ($view) { $whList = \App\Warehouse::with('address')->get(); $list = []; foreach ($whList as $wh) { $list[$wh->id] = $wh->address->alias; } $view->with('warehouseList', $list); // $view->with('warehouseList', \App\Warehouse::lists('name', 'id')); }); // Taxes view()->composer(array('customer_invoices.create', 'products.create', 'products.edit'), function ($view) { $view->with('taxList', \App\Tax::orderby('percent', 'desc')->lists('name', 'id')); }); view()->composer(array('products.create', 'products.edit', 'customer_invoices.create'), function ($view) { $view->with('taxpercentList', \App\Tax::lists('percent', 'id')); }); // Languages view()->composer(array('users.create', 'users.edit'), function ($view) { $view->with('languageList', \App\Language::lists('name', 'id')); }); // Categories view()->composer(array('products.create', 'products._panel_main_data'), function ($view) { $view->with('categoryList', \App\Category::orderby('name', 'asc')->lists('name', 'id')); }); // Stock Movement Types view()->composer(array('stock_movements.index', 'stock_movements.create'), function ($view) { $view->with('movement_typeList', \App\StockMovement::stockmovementList()); }); }
/** * Run the database seeds. * * @return void */ public function run() { $usd = \App\Currency::where('name', 'USD')->first(); $user = \App\User::where('email', '*****@*****.**')->first(); \App\BankAccount::firstOrCreate(['amount' => 0, 'user_id' => $user->getKey(), 'currency_id' => $usd->getKey()]); }
public function checkPayerAccount($payer, $request) { // check validity of payer account // check transaction log for the day // check sufficient kudos // debit from paypal if required // send notification to payer and payee if ($payer->account_status->status = 'active') { // Calculate number of kudos $noOfKudos = Currency::findOrFail($request->txn_currencyid)->Kudos_exchange * $request->amount_in_txn_currency; // Check transaction_limit if ($payer->transaction_limit_kudos >= $noOfKudos) { session()->flash('flash_message', 'Within transaction limit.'); // Check daily_limit if ($payer->kudos_used_today + $noOfKudos <= $payer->daily_limit_kudos) { session()->flash('flash_message', 'Within daily limit'); // Check if need to go to payment gateway if ($payer->kudos_available_balance < $noOfKudos) { if ($this->PaypalApproved()) { session()->flash('flash_message', 'Approved by Payment Gateway'); return 0; } else { session()->flash('flash_message', 'Unapproved by Payment Gateway, try another card'); return 85; } } else { session()->flash('flash_message', 'Transaction approved using existing kudos.'); return 0; } } else { session()->flash('flash_message', 'Exceeded daily limit'); return 51; } } else { session()->flash('flash_message', 'Exceeded transaction limit.'); return 51; } } else { session()->flash('flash_message', 'Payer account not active'); } session()->flash('flash_message', 'Payer account not approved - unknown error'); return 14; }
/** * @param $currency * * @return mixed */ static function getCurrency($currency) { $list = Currency::all()->last(); return $list->{$currency}; }
/** * Get currency name by id * @param $currencyId * * @return mixed */ public static function getCurrencyName($currencyId) { return Currency::select('name')->where('id', $currencyId)->get()->get(0)->name; }
/** * Display a listing of the resource. * * @return Response */ public function index() { return \App\Currency::get(); }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { $deleteChecked = Input::get('list'); if ($deleteChecked) { foreach ($deleteChecked as $delete) { $resumdel1 = Currency::where('id', $delete)->delete(); } Session::flash('message', 'Successfully deleted'); } else { } return Redirect::to('currency'); }
/** * Run the database seeds. * * @return void */ public function run() { \App\Currency::firstOrCreate(['name' => 'USD']); \App\Currency::firstOrCreate(['name' => 'MXN']); \App\Currency::firstOrCreate(['name' => 'EUR']); }
/** * Updates a currency * * @param $input * @param $id * * @return array */ public function update($input, $id) { $currency = $this->currency->findOrFail($id); $currency->update(['name' => $input->name, 'exchange_rate' => $this->money->toStoredMoney($input->exchange_rate)]); return ["id" => $currency->id]; }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request) { $currency = Currency::find($request->id); $currency->currency_code = $request->currency_code; $currency->currency_symbol = $request->currency_symbol; $currency->currency_name = $request->currency_name; $currency->country = $request->country; $currency->save(); return redirect('/currency'); }
/** * Show the form for editing the specified resource. * * @param int $id * @return Response */ public function edit($id) { $tags = Tag::lists('name', 'id'); $albums = Album::lists('name', 'id'); $event = Event::findOrFail($id); $prices = $event->prices->toArray(); $arr = array(); foreach ($prices as $price) { $p = array(); $p['name'] = $price['name']; $p['amount'] = $price['amount']; array_push($arr, $p); } $event['hiddenprice'] = json_encode($arr); $currencies = Currency::all(); $event = $event->formatEvent(); if ($event->banner_id == null) { $event['bannerid'] = ''; $event['bannername'] = ''; } else { $event['bannerid'] = $event->banner_id; $event['bannername'] = $event->banner->name; } if ($event->start == null) { $event['daterange'] = ''; } else { $event['daterange'] = $event->start->format('d/m/Y H:s') . ' - ' . $event->end->format('d/m/Y H:s'); } return view('admin.event.edit', compact('event', 'tags', 'albums', 'currencies')); }
public function getCurrencies() { return json_decode(Currency::all()); }