dynamic_query.go

func GenerateQuery(params map[string]string) string {
	where := "where 1=1"
	
	if status, ok := params["status"]; ok {
		where += " AND status='" + status + "'"
	}
	
	if phone_number, ok := params["phone_number"]; ok {
		where += " AND phone_number='" + phone_number + "'"
	}
	
	if email, ok := params["email"]; ok {
		where += " AND email='" + email + "'"
	}
	
	if application_start_date, ok := params["application_start_date"]; ok {
		where += " AND created_at >='" + application_start_date + "'"
	}
	
	if application_end_date, ok := params["application_end_date"]; ok {
		where += " AND created_at <='" + application_start_date + "'"
	}

	return "select * from applications " + where +" LIMIT 10 OFFSET 0"
}