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