public function optAdd()
{
// $campain = new Campain;
//
// $campain->start_at = '2016/01/01';
// $campain->end_at = '2016/01/20';
// $campain->description = 'Description 2';
// $campain->cost = 140;
// $campain->gain = 310;
// $campain->target = "19;male;UIO;20-45";
// $campain->company_id = 1;
//
// $campain->save();
$campain = Campain::find(2);
print_r($campain->company->name);
die;
}
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]);
}
