Prev

exports.searchFiltering = async (req, res) => {
  let query = `SELECT DISTINCT case_tasks.case_task_id,case_tasks.case_no,case_tasks.hearing_prev_date,case_tasks.hearing_next_date,case_tasks.court_type_id,case_tasks.court_id,case_tasks.status,case_tasks.against,courts.district_name,case_assign_task_details.assigne_id
    FROM case_tasks
    INNER JOIN courts ON case_tasks.court_id=courts.court_id
    INNER JOIN case_workflows ON case_workflows.case_task_id=case_tasks.case_task_id
    INNER JOIN case_assign_task_details ON case_assign_task_details.case_workflow_id=case_workflows.case_workflow_id
    WHERE ((case_tasks.case_no=:case_no AND case_tasks.is_deleted=0) OR :case_no IS NULL)
    AND
    ((case_tasks.hearing_prev_date>=:from_date AND case_tasks.is_deleted=0) OR :from_date IS NULL)
    AND
    ((case_tasks.hearing_next_date<=:to_date AND case_tasks.is_deleted=0) OR :to_date IS NULL)
    AND
    ((case_tasks.court_type_id=:court_type_id AND case_tasks.is_deleted=0) OR :court_type_id IS NULL)
    AND
    ((case_tasks.court_id=:court_id AND case_tasks.is_deleted=0) OR :court_id IS NULL)
    AND
    ((case_tasks.status=:status AND case_tasks.is_deleted=0) OR :status IS NULL)
    AND
    ((case_tasks.against=:against AND case_tasks.is_deleted=0) OR :against IS NULL)
    AND
    ((courts.district_name=:district_name AND courts.is_deleted=0) OR :district_name IS NULL)
    AND
    ((case_assign_task_details.assigne_id=:assignee_name AND case_assign_task_details.is_deleted=0) OR :assignee_name IS NULL)`;

  const cases = await db.sequelize
    .query(query, {
      replacements: {
        case_no: req.body.case_no,
        from_date: req.body.from_date,
        to_date: req.body.to_date,
        court_type_id: req.body.court_type_id,
        court_id: req.body.court_id,
        status: req.body.status,
        against: req.body.against,
        district_name: req.body.district_name,
        assignee_name: req.body.assignee_id,
      },
      type: QueryTypes.SELECT,
      mapToModel: true,
    })
    .then((cases) => {
      console.log(cases);
      if (cases.length > 0) {
        res.status(200).send({ data: cases });
      } else {
        return res.status(404).send('No case found');
      }
    })
    .catch((err) => {
      res.status(500).send({ message: err.message });
    });
};