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