| | |
| | | private ProjectUnitRegistrationInfoVO projectUnitRegistrationInfo; |
| | | private ProjectInvestmentPolicyComplianceVO projectInvestmentPolicyCompliance; |
| | | private Boolean auditRole; |
| | | |
| | | private String projectOwnerUnitName; |
| | | public static ProjectInfoVO getVoByEntity(@NonNull ProjectInfo entity, ProjectInfoVO vo) { |
| | | if(vo == null) { |
| | | vo = new ProjectInfoVO(); |
| | |
| | | private List<String> managementCentralizationList; |
| | | private String remark; |
| | | private Long processId; |
| | | |
| | | private String projectOwnerUnitName; |
| | | /** 是否能审核 */ |
| | | private boolean auditRole; |
| | | } |
| | |
| | | TPURI.contact_address as TPURI_contact_address, |
| | | TPURI.post_code as TPURI_post_code, |
| | | TPURI.email as TPURI_email, |
| | | TPI.coding |
| | | TPI.coding,d.dept_name as project_owner_unit_name |
| | | FROM |
| | | t_project_info TPI |
| | | LEFT JOIN t_project_investment_funding TPIF ON TPI.id = TPIF.project_id and TPIF.deleted = 0 |
| | |
| | | LEFT JOIN t_project_investment_policy_compliance TPIPC ON TPI.id = TPIPC.project_id and TPIPC.deleted = 0 |
| | | LEFT JOIN t_project_unit_registration_info TPURI ON TPI.id = TPURI.project_id and TPURI.deleted = 0 |
| | | LEFT JOIN t_project_process TPP ON TPI.id = TPP.project_id and TPP.deleted = 0 |
| | | -- LEFT JOIN sys_dept d ON d.dept_id = TPI.project_owner_unit |
| | | LEFT JOIN sys_dept d ON d.dept_id = TPI.project_owner_unit |
| | | <where> |
| | | TPI.deleted = 0 |
| | | <if test="query.projectName !=null and query.projectName!=''"> |
| | |
| | | <result column="longitude" property="longitude" /> |
| | | <result column="latitude" property="latitude" /> |
| | | <result column="project_owner_unit" property="projectOwnerUnit" /> |
| | | <result column="project_owner_unit_name" property="projectOwnerUnitName" /> |
| | | <result column="project_contact_person" property="projectContactPerson" /> |
| | | <result column="contact" property="contact" /> |
| | | <result column="gmt_create_time" property="gmtCreateTime" /> |
| | |
| | | SELECT |
| | | PI.*, |
| | | TPP.process_def_id, |
| | | TPP.process_ins_id |
| | | TPP.process_ins_id, |
| | | d.dept_name as project_owner_unit_name |
| | | FROM |
| | | t_project_info PI |
| | | LEFT JOIN t_project_process TPP ON TPP.project_id = PI.id AND TPP.deleted = 0 |