| | |
|---|
| | | |
|---|
| | | StringBuffer sql = new StringBuffer(); |
|---|
| | | sql.append(" select ts.id, ts.treatSingleNo, ts.shopName, ts.operatorName, ts.userConsultantName ") |
|---|
| | | .append(" , ts.drugStatus, ts.isUserSigns, ts.isWillPhoto, ts.isRd, ts.isFirstFm ") |
|---|
| | | .append(" , ts.drugStatus, ts.isUserSign, ts.isWillPhoto, ts.isRd, ts.isFirstFm ") |
|---|
| | | .append(" , ts.aDoctorName as doctorName, ts.aNurseName as nurseName, ts.anStatus, ts.orderClassify ") |
|---|
| | | .append(" , ts.remarkInfo, ts.allergyInfo, ts.aRemark, ts.roomName ") |
|---|
| | | .append(" , DATE_FORMAT(ts.createTime, '%H:%i %m/%d') AS createTime ") |
|---|
| | | .append(" , o.userId, u.name as userName, u.CIQ, u.userLevel ") |
|---|
| | | .append(" , ts.treatEndTime ") |
|---|
| | | .append(" , t.treatEndTime ") |
|---|
| | | .append(" from treat_single ts ") |
|---|
| | | .append(" left join v_visit_order o on o.id = ts.visitOrderId ") |
|---|
| | | .append(" left join v_visit_order_time t on ts.visitOrderId = o.id ") |
|---|
| | | .append(" left join v_visit_order_time t on t.visitOrderId = o.id ") |
|---|
| | | .append(" left join shop s on s.id = o.shopId ") |
|---|
| | | .append(" left join user u on u.id = o.userId ") |
|---|
| | | .append(" where ts.isDel = 0 and ts.id = #{m.id} "); |
|---|
