| | |
| | | private String contractTypeName; |
| | | private String stateName; |
| | | |
| | | private String parentContractCode; |
| | | private String parentContractName; |
| | | |
| | | private List<ContractAttrDto> attrs; |
| | | |
| | | public String getaLink() { |
| | |
| | | public void setContractParentId(String contractParentId) { |
| | | this.contractParentId = contractParentId; |
| | | } |
| | | |
| | | public String getParentContractCode() { |
| | | return parentContractCode; |
| | | } |
| | | |
| | | public void setParentContractCode(String parentContractCode) { |
| | | this.parentContractCode = parentContractCode; |
| | | } |
| | | |
| | | public String getParentContractName() { |
| | | return parentContractName; |
| | | } |
| | | |
| | | public void setParentContractName(String parentContractName) { |
| | | this.parentContractName = parentContractName; |
| | | } |
| | | } |
| | |
| | | public void setContractParentId(String contractParentId) { |
| | | this.contractParentId = contractParentId; |
| | | } |
| | | |
| | | |
| | | } |
| | |
| | | contractName,t.start_time,t.start_time startTime,t.end_time,t.end_time |
| | | endTime,t.state,t.contract_code,t.contract_code contractCode,t.obj_type,t.obj_type |
| | | objType,t.operator_link,t.operator_link operatorLink,ct.type_name contractTypeName,td.`name` |
| | | stateName,t.state_desc stateDesc,t.contract_parent_id contractParentId |
| | | stateName,t.state_desc stateDesc,t.contract_parent_id contractParentId,tt.contract_code parentContractCode, |
| | | tt.contract_name parentContractName |
| | | from contract t |
| | | LEFT JOIN contract_type ct on t.contract_type = ct.contract_type_id and ct.status_cd = '0' and ct.store_id = |
| | | t.store_id |
| | | LEFT JOIN t_dict td on td.status_cd = t.state and td.table_name = 'contract' and td.table_columns = 'state' |
| | | left join contract tt on t.contract_parent_id = tt.contract_id and tt.status_cd = '0' and tt.store_id = t.store_id |
| | | where 1 =1 |
| | | <if test="aLink !=null and aLink != ''"> |
| | | and t.a_link= #{aLink} |