| | |
|---|
| | | objType,t.operator_link,t.operator_link operatorLink,ct.type_name contractTypeName,td.`name` |
|---|
| | | stateName,t.state_desc stateDesc,t.contract_parent_id contractParentId,tt.contract_code parentContractCode, |
|---|
| | | tt.contract_name parentContractName,t.obj_name objName, t.obj_person_name objPersonName, t.obj_person_id objPersonId, |
|---|
| | | t.start_user_id startUserId |
|---|
| | | t.start_user_id startUserId,t.create_time createTime |
|---|
| | | 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 |
|---|
