| | |
|---|
| | | select report_progress from ass_project |
|---|
| | | where id=#{projectId} |
|---|
| | | </select> |
|---|
| | | |
|---|
| | | <!--a.id as plan_person_id, sql字段无用 增加后组件分页查询数量有问题--> |
|---|
| | | <select id="getMemberProjectByUserId" resultMap="projectResult"> |
|---|
| | | select distinct p.id,p.name,p.report_progress,p.code,p.client,p.province,p.city,p.district,p.business,p.create_time,a.id as plan_person_id, |
|---|
| | | select distinct p.id,p.name,p.report_progress,p.code,p.client,p.province,p.city,p.district,p.business,p.create_time, |
|---|
| | | e.leader_id,u.name as leader_name |
|---|
| | | from ass_project p |
|---|
| | | left join ass_plan_person a on a.project_id=p.id |
|---|
