| | |
|---|
| | | select a.dept_name deptName,c.name expertName,b.tax_expert_fee expertFee,a.create_time createTime,a.project_name projectName, |
|---|
| | | b.major_dangers majorDangers,b.general_hazards generalHazards,b.travel_expenses travelExpenses,b.accommodation_fee accommodationFee |
|---|
| | | from project_management a |
|---|
| | | left join project_expert b on a.id = b.project_id and b.del_flag = 0 and b.evaluation_state = 1 |
|---|
| | | left join sys_expert_info c on b.expert_id = c.id |
|---|
| | | inner join project_expert b on a.id = b.project_id and b.del_flag = 0 and b.evaluation_state = 1 |
|---|
| | | inner join sys_expert_info c on b.expert_id = c.id |
|---|
| | | where a.del_flag = 0 and a.state = 4 and a.evaluation_state = 1 |
|---|
| | | <if test="projectName != null and projectName != ''"> and a.project_name like concat('%', #{projectName}, '%')</if> |
|---|
| | | <if test="projectCode != null and projectCode != ''"> and a.project_code like concat('%', #{projectCode}, '%')</if> |
|---|
| | |
|---|
| | | select a.dept_name deptName,b.name expertName,b.tax_expert_fee expertFee,a.create_time createTime,a.project_name projectName, |
|---|
| | | b.major_dangers majorDangers,b.general_hazards generalHazards,b.travel_expenses travelExpenses,b.accommodation_fee accommodationFee |
|---|
| | | from project_management a |
|---|
| | | left join out_project_expert b on a.id = b.project_id and b.del_flag = 0 and b.evaluation_state = 1 |
|---|
| | | inner join out_project_expert b on a.id = b.project_id and b.del_flag = 0 and b.evaluation_state = 1 |
|---|
| | | where a.del_flag = 0 and a.state = 4 and a.evaluation_state = 1 |
|---|
| | | <if test="projectName != null and projectName != ''"> and a.project_name like concat('%', #{projectName}, '%')</if> |
|---|
| | | <if test="projectCode != null and projectCode != ''"> and a.project_code like concat('%', #{projectCode}, '%')</if> |
|---|
