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(); } } }
/** * Show the form for creating a new resource. * * @return Response */ public function create(Request $request) { if ($request['currencyId'] != 0) { $retcurrency = Currency::whereId($request['currencyId'])->first(); if ($retcurrency) { $currency = Currency::find($request['currencyId']); $currency->name = $request['name']; $currency->save(); Session::flash('message', 'currency Updated Successfully'); } } else { $currency = new Currency(); $currency->name = $request['name']; $currency->save(); Session::flash('message', 'currency added Successfully'); } return Redirect::to('currency'); }