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());
}
