public function jqgrid(Request $request)
{
// return dd($request->all());
if (Auth::check()) {
if (in_array('ADD_EDIT_CAMPAIGN', $this->permission)) {
$validate = \Validator::make($request->all(), ['name' => 'required']);
if ($validate->passes()) {
$camp_id = substr($request->input('id'), 3);
if (User::isSuperAdmin()) {
$campaign = Campaign::find($camp_id);
} else {
$usr_company = $this->user_company();
$campaign = Campaign::whereHas('getAdvertiser', function ($q) use($usr_company) {
$q->whereHas('GetClientID', function ($p) use($usr_company) {
$p->whereIn('user_id', $usr_company);
});
})->find($camp_id);
}
if ($campaign) {
$data = array();
$audit = new AuditsController();
if ($campaign->name != $request->input('name')) {
array_push($data, 'Name');
array_push($data, $campaign->name);
array_push($data, $request->input('name'));
$campaign->name = $request->input('name');
}
if ($campaign->daily_max_impression != $request->input('daily_max_imp')) {
array_push($data, 'Daily Max Impression');
array_push($data, $campaign->daily_max_impression);
array_push($data, $request->input('daily_max_imp'));
$campaign->daily_max_impression = $request->input('daily_max_imp');
}
if ($campaign->cpm != $request->input('cpm')) {
array_push($data, 'CPM');
array_push($data, $campaign->cpm);
array_push($data, $request->input('cpm'));
$campaign->cpm = $request->input('cpm');
}
if ($campaign->daily_max_budget != $request->input('daily_max_budget')) {
array_push($data, 'Daily Max Budget');
array_push($data, $campaign->daily_max_budget);
array_push($data, $request->input('daily_max_budget'));
$campaign->daily_max_budget = $request->input('daily_max_budget');
}
$audit->store('campaign', $camp_id, $data, 'edit');
$campaign->save();
return $msg = ['success' => true, 'msg' => "your Campaign Saved successfully"];
}
return $msg = ['success' => false, 'msg' => "Please Select a Campaign First"];
}
return $msg = ['success' => false, 'msg' => "Please Check your field"];
}
return $msg = ['success' => false, 'msg' => "You don't have permission"];
}
return Redirect::to('/user/login');
}
public function campaign_bulk(Request $request)
{
// return dd($request->all());
if (Auth::check()) {
if (in_array('ADD_EDIT_CAMPAIGN', $this->permission)) {
$validate = $this->validation($request);
if ($validate->passes()) {
$usr_company = $this->user_company();
$audit = new AuditsController();
$audit_key = $audit->generateRandomString();
if ($request->input('advertiser_id') == 'all' and !$request->has('campaign_list')) {
if ($request->input('client_id') == 'all') {
if (User::isSuperAdmin()) {
$campaign_list = Campaign::get(['id'])->toArray();
} else {
$campaign_list = Campaign::whereHas('getAdvertiser', function ($q) use($usr_company) {
$q->whereHas('GetClientID', function ($p) use($usr_company) {
$p->whereIn('user_id', $usr_company);
});
})->get(['id'])->toArray();
}
} elseif ($request->input('client_id') != 'all') {
if (User::isSuperAdmin()) {
$campaign_list = Campaign::whereHas('getAdvertiser', function ($q) use($request) {
$q->where('client_id', $request->input('client_id'));
})->get(['id'])->toArray();
} else {
////////////////////////
$campaign_list = Campaign::whereHas('getAdvertiser', function ($q) use($usr_company, $request) {
$q->whereHas('GetClientID', function ($p) use($usr_company, $request) {
$p->where('id', $request->input('client_id'))->whereIn('user_id', $usr_company);
});
})->get(['id'])->toArray();
}
}
} elseif ($request->input('advertiser_id') != 'all' and !$request->has('campaign_list')) {
if (User::isSuperAdmin()) {
$campaign_list = Campaign::whereHas('getAdvertiser', function ($q) use($request) {
$q->where('id', $request->input('advertiser_id'));
})->get(['id'])->toArray();
} else {
////////////////////////
$campaign_list = Campaign::whereHas('getAdvertiser', function ($q) use($usr_company, $request) {
$q->where('id', $request->input('advertiser_id'))->whereHas('GetClientID', function ($p) use($usr_company, $request) {
$p->whereIn('user_id', $usr_company);
});
})->get(['id'])->toArray();
}
} else {
$campaign_list = explode(',', $request->input('campaign_list'));
}
if (count($campaign_list) > 0) {
foreach ($campaign_list as $index) {
$data = array();
if (!$request->has('campaign_list')) {
$campaign_id = $index['id'];
$campaign = Campaign::find($campaign_id);
} else {
$campaign_id = $index;
if (User::isSuperAdmin()) {
$campaign = Campaign::find($campaign_id);
} else {
$usr_company = $this->user_company();
$campaign = Campaign::whereHas('getAdvertiser', function ($q) use($usr_company) {
$q->whereHas('GetClientID', function ($p) use($usr_company) {
$p->whereIn('user_id', $usr_company);
});
})->find($campaign_id);
}
}
if ($campaign) {
if ($request->has('date_range')) {
$check_date = $this->date_validation($request->input('date_range'));
if (!$check_date) {
return Redirect::back()->withErrors(['success' => false, 'msg' => 'please check your date range!']);
}
$date_range = explode('-', $request->input('date_range'));
$start_date = Carbon::createFromFormat('m/d/Y', str_replace(' ', '', $date_range[0]))->toDateString();
$end_date = Carbon::createFromFormat('m/d/Y', str_replace(' ', '', $date_range[1]))->toDateString();
}
if ($request->has('name')) {
array_push($data, 'Name');
array_push($data, $request->input('name'));
$campaign->name = $request->input('name');
}
if ($request->has('active')) {
$active = 'Inactive';
if ($request->input('active') == 'on') {
$active = 'Active';
}
array_push($data, 'Status');
array_push($data, $active);
$campaign->status = $active;
}
if ($request->has('max_impression')) {
array_push($data, 'Max Imps');
array_push($data, $request->input('max_impression'));
$campaign->max_impression = $request->input('max_impression');
}
if ($request->has('daily_max_impression')) {
array_push($data, 'Daily Max Imps');
array_push($data, $request->input('daily_max_impression'));
$campaign->daily_max_impression = $request->input('daily_max_impression');
}
if ($request->has('max_budget')) {
array_push($data, 'Max Budget');
array_push($data, $request->input('max_budget'));
$campaign->max_budget = $request->input('max_budget');
}
if ($request->has('daily_max_budget')) {
array_push($data, 'Daily Max Budget');
array_push($data, $request->input('daily_max_budget'));
$campaign->daily_max_budget = $request->input('daily_max_budget');
}
if ($request->has('cpm')) {
array_push($data, 'CPM');
array_push($data, $request->input('cpm'));
$campaign->cpm = $request->input('cpm');
}
if ($request->has('advertiser_domain_name')) {
array_push($data, 'Domain Name');
array_push($data, $request->input('advertiser_domain_name'));
$campaign->advertiser_domain_name = $request->input('advertiser_domain_name');
}
if ($request->has('description')) {
array_push($data, 'Description');
array_push($data, $request->input('description'));
$campaign->description = $request->input('description');
}
if (isset($start_date)) {
array_push($data, 'Start Date');
array_push($data, $start_date);
$campaign->start_date = $start_date;
}
if (isset($end_date)) {
array_push($data, 'End Date');
array_push($data, $end_date);
$campaign->end_date = $end_date;
}
$audit->store('campaign', $campaign_id, $data, 'bulk_edit', $audit_key);
$campaign->save();
}
}
return Redirect::back()->withErrors(['success' => true, 'msg' => 'Campaigns Edited Successfully']);
}
}
return Redirect::back()->withErrors(['success' => false, 'msg' => $validate->messages()->all()])->withInput();
}
return Redirect::back()->withErrors(['success' => false, 'msg' => 'don\'t have Edit Permission']);
}
return Redirect::to(url('/user/login'));
}
