public function getAudit($id, $entity_id = null) { if (Auth::check()) { $query = '1'; switch ($id) { case 'user': if (!is_null($entity_id)) { $query .= " and (entity_type = 'user' and entity_id = '" . $entity_id . "')"; } else { $query .= " and (entity_type = 'user')"; } break; case 'company': if (!is_null($entity_id)) { $query .= " and (entity_type = 'company' and entity_id = '" . $entity_id . "')"; } else { $query .= " and (entity_type = 'company')"; } break; case 'inventory': if (!is_null($entity_id)) { $query .= " and (entity_type = 'inventory' and entity_id = '" . $entity_id . "')"; } else { $query .= " and (entity_type = 'inventory')"; } break; case 'client': if (!is_null($entity_id)) { $query .= " and (entity_type = 'client' and entity_id = '" . $entity_id . "')"; } else { $query .= " and (entity_type = 'client')"; } break; case 'advertiser': if (!is_null($entity_id)) { $query .= " and ((entity_type = 'advertiser' and entity_id = '" . $entity_id . "') or (entity_type = 'advertiser_model_map' and after_value = '" . $entity_id . "')) "; } else { $query .= " and (entity_type = 'advertiser' or entity_type = 'advertiser_model_map')"; } break; case 'campaign': if (!is_null($entity_id)) { $query .= " and (entity_type = 'campaign' and entity_id = '" . $entity_id . "')"; } else { $query .= " and (entity_type = 'campaign')"; } break; case 'creative': if (!is_null($entity_id)) { $query .= " and (entity_type = 'creative' and entity_id = '" . $entity_id . "')"; } else { $query .= " and (entity_type = 'creative')"; } break; case 'offer': if (!is_null($entity_id)) { $query .= " and ((entity_type = 'offer' and entity_id = '" . $entity_id . "') or (entity_type = 'offer_pixel_map' and after_value = '" . $entity_id . "')) "; } else { $query .= " and (entity_type = 'offer' or entity_type = 'offer_pixel_map')"; } break; case 'pixel': if (!is_null($entity_id)) { $query .= " and (entity_type = 'pixel' and entity_id = '" . $entity_id . "')"; } else { $query .= " and (entity_type = 'pixel')"; } break; case 'targetgroup': if (!is_null($entity_id)) { $query .= " and ((entity_type = 'targetgroup' and entity_id = '" . $entity_id . "')\n or (entity_type = 'targetgroup_creative_map' and after_value='" . $entity_id . "' )\n or (entity_type = 'targetgroup_geolocation_map' and after_value='" . $entity_id . "' )\n or (entity_type = 'targetgroup_segment_map' and after_value='" . $entity_id . "' )\n or (entity_type = 'targetgroup_geosegment_map' and after_value='" . $entity_id . "' )\n or (entity_type = 'targetgroup_bwlist_map' and after_value='" . $entity_id . "' )\n or (entity_type = 'targetgroup_bidprofile_map' and after_value='" . $entity_id . "' ))"; } else { $query .= " and (entity_type = 'targetgroup')"; } break; case 'geosegment': if (!is_null($entity_id)) { $query .= " and ((entity_type = 'geosegment' and entity_id = '" . $entity_id . "') or (entity_type = 'geosegmententrie' and after_value ='" . $entity_id . "') )"; } else { $query .= " and (entity_type = 'geosegment')"; } break; case 'bwlist': if (!is_null($entity_id)) { $query .= " and ((entity_type = 'bwlist' and entity_id = '" . $entity_id . "') or (entity_type = 'bwlistentrie' and after_value = '" . $entity_id . "')) "; } else { $query .= " and (entity_type = 'bwlist' or entity_type = 'bwlistentrie')"; } break; case 'bid_profile': if (!is_null($entity_id)) { $query .= " and ((entity_type = 'bid_profile' and entity_id = '" . $entity_id . "') or (entity_type = 'bid_profile_entry' and after_value = '" . $entity_id . "')) "; } else { $query .= " and (entity_type = 'bid_profile' or entity_type = 'bid_profile_entry')"; } break; case 'model': if (!is_null($entity_id)) { $query .= " and ((entity_type = 'modelTable' and entity_id = '" . $entity_id . "') or (entity_type = 'negative_offer_model' and after_value = '" . $entity_id . "') or (entity_type = 'positive_offer_model' and after_value = '" . $entity_id . "')) "; } else { $query .= " and (entity_type = 'modelTable' or entity_type = 'negative_offer_model' or entity_type = 'positive_offer_model')"; } break; case 'user_id': $user_id = Auth::user()->id; $query .= " and (user_id = '" . $user_id . "')"; break; } if (User::isSuperAdmin()) { $audit = Audits::with('getUser')->whereRaw($query)->orderBy('created_at', 'DESC')->get(); } else { $usr_comp = $this->user_company(); $audit = Audits::with('getUser')->whereIn('user_id', $usr_comp)->whereRaw($query)->whereIn('user_id', $usr_comp)->orderBy('created_at', 'DESC')->get(); } $audit_obj = array(); if ($audit) { $sub = new AuditsController(); $audit_obj = $sub->SubAudit($audit); } return view('audit.template.all_audits')->with('audit_obj', $audit_obj); } return 'check ur login'; }