| | |
|---|
| | | <select id="organ" parameterType="com.ruoyi.project.domain.ServiceTotals" |
|---|
| | | resultType="ServiceTotalsOrgan"> |
|---|
| | | SELECT DATE_FORMAT(a.organ_start_time, '%Y-%m') donateTime,a.OrganName organName, COUNT(*) getCount,c.RegisterCountyName area, |
|---|
| | | COUNT(IF(b.transplantstate=3, true, NULL)) useCount ,COUNT(IF(d.complete_state=4, true, NULL)) deprecateCount |
|---|
| | | COUNT(IF(b.transplantstate=3, true, NULL)) useCount ,COUNT(IF(b.transplantstate=4, true, NULL)) deprecateCount |
|---|
| | | FROM service_donationwitnessorgan a |
|---|
| | | LEFT JOIN service_donatecomporgan b ON a.InfoID=b.InfoID AND a.OrganName=b.OrganName |
|---|
| | | LEFT JOIN service_donatebaseinfo c ON a.InfoID=c.ID |
|---|
| | | LEFT JOIN service_donatecompletioninfo d ON d.InfoID=a.InfoID |
|---|
| | | <where> |
|---|
| | | a.del_flag=0 and b.del_flag=0 and c.del_flag=0 and d.del_flag=0 |
|---|
| | | a.del_flag=0 and b.del_flag=0 and c.del_flag=0 |
|---|
| | | <if test="area != null and area != ''"> |
|---|
| | | and a.InfoID in (select id FROM service_donatecompletioninfo where RegisterCountyName>=#{area} ) |
|---|
| | | </if> |
|---|
