So i have been trying to fix some bugs 4 year projects,what i am trying to do is i want show list compliants from march onwards only in this year,the current query is shows about data from 2018 i want show data only this year from march onwards.can anyone help on this
$open_complain = DB::table('customer_complaints')
->join('ssi_tracks', 'customer_complaints.ssi_track_id', '=', 'ssi_tracks.ssi_track_id')
->join('registrations', 'ssi_tracks.registration_id', '=', 'registrations.registration_id')
->select('ssi_tracks.ssi_track_id', 'ssi_tracks.track_first_status', 'registrations.dse','registrations.delivery','registrations.customername', 'registrations.model', 'registrations.chassis', 'registrations.phone', 'registrations.customerid', 'registrations.invoicedate', 'registrations.branch', 'registrations.delivery', 'registrations.dse', 'customer_complaints.complaint_status', 'customer_complaints.updated_at','customer_complaints.status', 'customer_complaints.customer_complaint', 'customer_complaints.compliant_type', 'customer_complaints.customer_complaint_id', 'customer_complaints.complaint_schedule', 'customer_complaints.complaint_type_id', 'customer_complaints.status_remark', 'customer_complaints.id')
->where([["customer_complaints.complaint_schedule", "=", 1],["customer_complaints.status", "=", 0],["customer_complaints.complaint_status",'=', 0]])
->groupBy('registrations.registration_id')
->paginate(10);