| | |
|---|
| | | //返回数据 |
|---|
| | | Map<String,Object> data = new HashMap<>(); |
|---|
| | | data.put("mjSkinReportId",mjRecordId); |
|---|
| | | data.put("userId",mjSkinReport.getCustomerId()); |
|---|
| | | |
|---|
| | | SqlSentence sqlSentence = new SqlSentence(); |
|---|
| | | Map<String, Object> sqlMap = new HashMap<>(); |
|---|
| | |
|---|
| | | 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 "); |
|---|
