public static function IncidentStatus($status, $area, $from_date, $to_date, $from, $to) { if (!is_null($status)) { if (!is_null($area)) { $tickets = Incident::whereIn('status_id', $status)->whereBetween('created_at', [$from_date, $to_date])->whereIn('area', $area)->get(); $ticket = Incident::whereIn('status_id', $status)->whereBetween('created_at', [$from_date, $to_date])->whereIn('area', $area)->select('id', 'ticket_no', 'name', 'mobile', 'address', 'area', 'requirement')->orderBy('id', 'desc'); } else { $tickets = Incident::whereIn('status_id', $status)->whereBetween('created_at', [$from_date, $to_date])->get(); $ticket = Incident::whereIn('status_id', $status)->whereBetween('created_at', [$from_date, $to_date])->select('id', 'ticket_no', 'name', 'mobile', 'address', 'area', 'requirement')->orderBy('id', 'desc'); } if (count(Incident::whereIn('status_id', $status)->get()) == 0 && count(Incident::whereIn('ticket_type_id', $status)->get()) != 0) { if (!is_null($area)) { $tickets = Incident::whereIn('ticket_type_id', $status)->whereBetween('created_at', [$from_date, $to_date])->whereIn('area', $area)->get(); $ticket = Incident::whereIn('ticket_type_id', $status)->whereBetween('created_at', [$from_date, $to_date])->whereIn('area', $area)->select('id', 'ticket_no', 'name', 'mobile', 'address', 'area', 'requirement')->orderBy('id', 'desc'); } else { $tickets = Incident::whereIn('ticket_type_id', $status)->whereBetween('created_at', [$from_date, $to_date])->get(); $ticket = Incident::whereIn('ticket_type_id', $status)->whereBetween('created_at', [$from_date, $to_date])->select('id', 'ticket_no', 'name', 'mobile', 'address', 'area', 'requirement')->orderBy('id', 'desc'); } } if (count(Incident::whereIn('status_id', $status)->get()) != 0 && count(Incident::whereIn('ticket_type_id', $status)->get()) != 0) { if (!is_null($area)) { $tickets = Incident::whereIn('status_id', $status)->whereBetween('created_at', [$from_date, $to_date])->whereIn('area', $area)->whereIn('ticket_type_id', $status)->get(); $ticket = Incident::whereIn('status_id', $status)->whereBetween('created_at', [$from_date, $to_date])->whereIn('area', $area)->whereIn('ticket_type_id', $status)->select('id', 'ticket_no', 'name', 'mobile', 'address', 'area', 'requirement')->orderBy('id', 'desc'); } else { $tickets = Incident::whereIn('status_id', $status)->whereBetween('created_at', [$from_date, $to_date])->whereIn('ticket_type_id', $status)->get(); $ticket = Incident::whereIn('status_id', $status)->whereBetween('created_at', [$from_date, $to_date])->whereIn('ticket_type_id', $status)->select('id', 'ticket_no', 'name', 'mobile', 'address', 'area', 'requirement')->orderBy('id', 'desc'); } } } else { if (is_null($status) && !is_null($area)) { $tickets = Incident::whereBetween('created_at', [$from_date, $to_date])->whereIn('area', $area)->get(); $ticket = Incident::whereBetween('created_at', [$from_date, $to_date])->whereIn('area', $area)->select('id', 'ticket_no', 'name', 'mobile', 'address', 'area', 'requirement')->orderBy('id', 'desc'); } else { if (is_null($status) && is_null($area) && $from && $to && ($from != "undefined" && $to != "undefined")) { $tickets = Incident::whereBetween('created_at', [$from_date, $to_date])->get(); $ticket = Incident::whereBetween('created_at', [$from_date, $to_date])->select('id', 'ticket_no', 'name', 'mobile', 'address', 'area', 'requirement')->orderBy('id', 'desc'); } else { $ticket = DB::table('incident')->select('id', 'ticket_no', 'name', 'mobile', 'address', 'area', 'requirement')->orderBy('id', 'desc'); $tickets = DB::table('incident')->get(); } } } return array('ticket' => $ticket, 'tickets' => $tickets); }