Updated

exports.searchFiltering = (req, res) => {
  const case_no2 = req.body.case_no;
  var case_no_condition = case_no2 ? { case_no: case_no2 } : null;
  const court_id2 = req.body.court_id;
  var court_id_condition = court_id2 ? { court_id: court_id2 } : null;
  const court_type_id2 = req.body.court_type_id;
  var court_type_id_condition = court_type_id2
    ? { court_type_id: court_type_id2 }
    : null;
  const client_id2 = req.body.client_id;
  var client_id_condition = client_id2 ? { client_id: client_id2 } : null;
  const against2 = req.body.against;
  var against_condition = against2 ? { against: against2 } : null;
  const status2 = req.body.status;
  var status_condition = status2 ? { status: status2 } : null;

  const district_name2 = req.body.district_name;
  var district_name_condition = district_name2
    ? { '$Court.district_name': district_name2 }
    : null;

  const assigne_id2 = req.body.assigne_id;
  var assigne_id_condition = assigne_id2
    ? { '$CaseAssign.assigne_id': assigne_id2 }
    : null;
  console.log(CaseAssign);
  const from2 = req.body.from;
  const to2 = req.body.to;
  var from_to_condition = from2 && to2 ? { [Op.between]: [from2, to2] } : null;

  CaseTask.findAll({
    where: {
      ...case_no_condition,
      ...court_id_condition,
      ...court_type_id_condition,
      ...client_id_condition,
      ...against_condition,
      ...district_name_condition,
      ...status_condition,
      ...assigne_id_condition,
      ...from_to_condition,
    },
    include: {
      model: CaseWorkflow,
      required: false,
      where: { is_deleted: 0 },
      include: {
        model: CaseAssign,
        required: false,
        where: { is_deleted: 0 },
      },
    },
    include: {
      model: Court,
    },
  })
    .then((case_tasks) => {
      if (case_tasks) {
        res.status(200).send({ data: case_tasks });
      } else {
        return res.status(404).send({ message: 'No case task found' });
      }
    })
    .catch((err) => {
      res.status(500).send({ message: err.message });
    });
};