public function update(array $data) { $keyword = Keyword::find($data['keyword_id']); $keyword->keyword = $data['keyword']; $keyword->match_type = $data['match_type']; $keyword->save(); return $keyword; }
public function roi() { $userName = Auth::user()->name; $campains = Campain::all(); $resp = array(); foreach ($campains as $campain) { $id = $campain->id; $cost = $campain->cost; $gain = $campain->gain; $roi = ($gain - $cost) / $cost; $resp[$id] = $roi; } arsort($resp); $report = []; foreach ($resp as $key => $value) { $roi = number_format($value, 2); $campain = Campain::find($key); $lists = DB::table('links')->where('campain_id', '=', $key)->get(); $keywords = []; foreach ($lists as $list) { $keyword_id = $list->keyword_id; $keyword = Keyword::find($keyword_id); $keywords[] = $keyword->text; } $report[] = ["campain" => $campain->description, "roi" => $roi, "keywords" => $keywords]; } return view('report.roi', ['userName' => $userName, 'reports' => $report]); }