| | |
| | | if (indicationList != null && indicationList.size() > 0) { |
| | | sqlMap.put("typeStr", TreatPlan.TYPE_STR_INDICATION); |
| | | sql.delete(0, sql.length()); |
| | | sql.append(" SELECT i.*,d.name AS commonName FROM treat_plan_item AS i "); |
| | | sql.append(" SELECT i.commonId,d.name AS commonName FROM treat_plan_item AS i "); |
| | | sql.append(" JOIN treat_plan AS t ON t.id = i.treatPlanId "); |
| | | sql.append(" JOIN treat_plan_indication AS p ON p.treatPlanId = i.treatPlanId "); |
| | | sql.append(" JOIN indication AS d ON d.id = p.indicationId "); |