59 lines
18 KiB
SQL
59 lines
18 KiB
SQL
-- 增加车架号、发动机号、车牌号
|
||
-- insert into `awe_do_library` (`dono`, `colindex`, `sortno`, `isinuse`, `coltablename`, `colactualname`, `colname`, `coltype`, `coldefaultvalue`, `colheader`, `colunit`, `colcolumntype`, `coleditstyle`, `colcheckformat`, `colalign`, `coleditsourcetype`, `coleditsource`, `colhtmlstyle`, `collimit`, `colvisible`, `colreadonly`, `colrequired`, `colsortable`, `isfilter`, `colspan`, `isautocomplete`, `groupid`, `colfilterrefid`, `inputuser`, `inputtime`, `updateuser`, `updatetime`, `isaudit`, `colfilterattrs`, `isupdate`, `parentcolindex`, `tips`, `colinnerbtevent`, `colfilteroptions`) values('LBEquipmentInfoTemp','1330','1102','1','O','FRAME_NUMBER','FRAME_NUMBER','String','','车架号','','1','Text','1','1','','','','100','1','0','1','1','0','0','','0010','','SYS_Designer','2018/02/24 09:26:20','SYS_Designer','2018/02/24 09:32:13','0','','1','','','','');
|
||
-- insert into `awe_do_library` (`dono`, `colindex`, `sortno`, `isinuse`, `coltablename`, `colactualname`, `colname`, `coltype`, `coldefaultvalue`, `colheader`, `colunit`, `colcolumntype`, `coleditstyle`, `colcheckformat`, `colalign`, `coleditsourcetype`, `coleditsource`, `colhtmlstyle`, `collimit`, `colvisible`, `colreadonly`, `colrequired`, `colsortable`, `isfilter`, `colspan`, `isautocomplete`, `groupid`, `colfilterrefid`, `inputuser`, `inputtime`, `updateuser`, `updatetime`, `isaudit`, `colfilterattrs`, `isupdate`, `parentcolindex`, `tips`, `colinnerbtevent`, `colfilteroptions`) values('LBEquipmentInfoTemp','1340','1103','1','O','ENGINE_NUMBER','ENGINE_NUMBER','String','','发动机号','','1','Text','1','1','','','','100','1','0','1','1','0','0','','0010','','SYS_Designer','2018/02/24 09:26:20','SYS_Designer','2018/02/24 09:32:13','','','1','','','','');
|
||
-- insert into `awe_do_library` (`dono`, `colindex`, `sortno`, `isinuse`, `coltablename`, `colactualname`, `colname`, `coltype`, `coldefaultvalue`, `colheader`, `colunit`, `colcolumntype`, `coleditstyle`, `colcheckformat`, `colalign`, `coleditsourcetype`, `coleditsource`, `colhtmlstyle`, `collimit`, `colvisible`, `colreadonly`, `colrequired`, `colsortable`, `isfilter`, `colspan`, `isautocomplete`, `groupid`, `colfilterrefid`, `inputuser`, `inputtime`, `updateuser`, `updatetime`, `isaudit`, `colfilterattrs`, `isupdate`, `parentcolindex`, `tips`, `colinnerbtevent`, `colfilteroptions`) values('LBEquipmentInfoTemp','1350','1104','1','O','PLATE_NUMBER','PLATE_NUMBER','String','','车牌号','','1','Text','1','1','','','','100','1','0','0','1','0','2','','0010','','SYS_Designer','2018/02/24 09:26:20','SYS_Designer','2018/02/24 09:41:52','0','','1','','','','');
|
||
-- 增加车辆颜色
|
||
insert into `awe_do_library` (`dono`, `colindex`, `sortno`, `isinuse`, `coltablename`, `colactualname`, `colname`, `coltype`, `coldefaultvalue`, `colheader`, `colunit`, `colcolumntype`, `coleditstyle`, `colcheckformat`, `colalign`, `coleditsourcetype`, `coleditsource`, `colhtmlstyle`, `collimit`, `colvisible`, `colreadonly`, `colrequired`, `colsortable`, `isfilter`, `colspan`, `isautocomplete`, `groupid`, `colfilterrefid`, `inputuser`, `inputtime`, `updateuser`, `updatetime`, `isaudit`, `colfilterattrs`, `isupdate`, `parentcolindex`, `tips`, `colinnerbtevent`, `colfilteroptions`) values('LBEquipmentInfoTemp_Car','1335','1166','1','O','CAR_COLOUR','CAR_COLOUR','String','','车辆颜色','','1','Text','1','1','','','','32','1','0','0','1','0','0','','','','SYS_Designer','2018/02/24 16:39:56','SYS_Designer','2018/02/24 16:39:56','','','1','','','','');
|
||
|
||
-- 增加 收车授权书代码类型
|
||
insert into `code_library` (`codeno`, `itemno`, `itemname`, `bankno`, `sortno`, `isinuse`, `itemdescribe`, `itemattribute`, `relativecode`, `attribute1`, `attribute2`, `attribute3`, `attribute4`, `attribute5`, `attribute6`, `attribute7`, `attribute8`, `inputuser`, `inputorg`, `inputtime`, `updateuser`, `updatetime`, `remark`, `helptext`) values('ProductContractTemplate','001001008','收车及处置授权书','','001001008','1','','','','','','','','','','','','SYS_Designer',NULL,'2018/02/24 10:12:29','SYS_Designer','2018/02/24 10:12:29','','');
|
||
-- 增加参数配置：业务合同编号bySql
|
||
insert into `BF_PARAMCONFIG` (`ID`, `PARAMID`, `ORDERID`, `PARAMNAME`, `PARAMSTRING`, `PARAMTYPE`, `PARAMSTATEMENT`, `STATUS`, `CENOTE`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `UPDATETIME`, `INPUTTIME`) values('845f75b6384f4e80955bf39181391f01','业务合同编号bySql','001',NULL,'contract_number','param_type2','SELECT contract_number FROM lb_contract_info_temp WHERE flowunid=:{FLOW_UNID}\r\n','valid','','','','','','','');
|
||
-- 增加 租赁物的标签配置
|
||
insert into `BF_LABLECONFIG` (`ID`, `TAGNUMBER`, `TAGNAME`, `TITLE`, `TAGTYPE`, `VALUETYPE`, `VALUEFIELD`, `VALUEMETHOD`, `THOUSANDSFIELD`, `ISSHOEINDEX`, `REMARK`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`, `OPERATORCLASS`) values('ba564b64e8af4aa0adb511da5fb0452d','0007','EquipInfo','租赁物信息','tag_type3','value_type3','BRAND,MODEL,FRAME_NUMBER,PLATE_NUMBER','SELECT BRAND,MODEL,FRAME_NUMBER,PLATE_NUMBER FROM LB_EQUIPMENT_CAR_TEMP WHERE flowunid=:{FLOW_UNID}','','N','用于收车合同、车辆抵押合同','','','','','','','word_default_class');
|
||
-- 增加 收车及处置授权书模板
|
||
insert into `BF_TEMPLATE` (`ID`, `SERIALNO`, `SORTNUMBER`, `TEMPLATENAME`, `TEMPLATESHOWNAME`, `TEMPLATEPATH`, `TEMPLATETYPE`, `OPERATETYPE`, `CALLBACK`, `CREATEMETHOD`, `DOCTYPE`, `ONECLASSIFY`, `TWOCLASSIFY`, `THREECLASSIFY`, `FOURCLASSIFY`, `TEMPLATEVERSION`, `STATUS`, `REMARK`, `INPUTUSERID`, `INPUTORGID`, `INPUTTIME`, `UPDATEUSERID`, `UPDATEORGID`, `UPDATETIME`, `CREATECONDITION`, `CREATESHEETCONDITION`) values('898f37819b414aa79472cad963f88810',NULL,'','收车及处置授权书','收车及处置授权书_{contract_number}.docx','收车授权.docx','word','upload','',NULL,'002','002002','001','001001','001001008','1','','','admin','80009000200010001','2018/02/24 09:48:19','admin','80009000200010001','2018/02/24 11:10:54','','');
|
||
-- 增加 收车及处置授权书模板用到参数配置
|
||
insert into `BF_TEMPLATEPARAM` (`ID`, `PARAMID`, `TEMPLATEID`, `INPUTUSERID`, `INPUTORGID`, `INPUTTIME`, `UPDATEUSERID`, `UPDATEORGID`, `UPDATETIME`) values('b11365ee93cc4f789272e7b6009390f1','845f75b6384f4e80955bf39181391f01','898f37819b414aa79472cad963f88810',NULL,NULL,NULL,NULL,NULL,NULL);
|
||
-- 增加 收车及处置授权书模板用到导出配置
|
||
insert into `BF_TEMPLATELABLE` (`ID`, `LABLEID`, `TEMPLATEID`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('2c4eba58ec2b4f07acb35598a39b3507','ba564b64e8af4aa0adb511da5fb0452d','898f37819b414aa79472cad963f88810',NULL,NULL,NULL,NULL,NULL,NULL);
|
||
insert into `BF_TEMPLATELABLE` (`ID`, `LABLEID`, `TEMPLATEID`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('5444e27a0a4945859724a51fbb11cd05','9fe76b750bdf47dba99e43829a01f865','898f37819b414aa79472cad963f88810',NULL,NULL,NULL,NULL,NULL,NULL);
|
||
insert into `BF_TEMPLATELABLE` (`ID`, `LABLEID`, `TEMPLATEID`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('956ca2760ca741b7bbe4080192dfb9f1','84c52e764739416f8632d5256bad9087','898f37819b414aa79472cad963f88810',NULL,NULL,NULL,NULL,NULL,NULL);
|
||
|
||
|
||
-- 增加 车辆抵押合同代码
|
||
insert into `code_library` (`codeno`, `itemno`, `itemname`, `bankno`, `sortno`, `isinuse`, `itemdescribe`, `itemattribute`, `relativecode`, `attribute1`, `attribute2`, `attribute3`, `attribute4`, `attribute5`, `attribute6`, `attribute7`, `attribute8`, `inputuser`, `inputorg`, `inputtime`, `updateuser`, `updatetime`, `remark`, `helptext`) values('ProductContractTemplate','001001009','车辆抵押合同','','001001009','1','','','','','','','','','','','','SYS_Designer',NULL,'2018/02/24 14:25:04','SYS_Designer','2018/02/24 14:25:04','','');
|
||
-- 增加 车辆抵押合同 模板管理
|
||
insert into `BF_TEMPLATE` (`ID`, `SERIALNO`, `SORTNUMBER`, `TEMPLATENAME`, `TEMPLATESHOWNAME`, `TEMPLATEPATH`, `TEMPLATETYPE`, `OPERATETYPE`, `CALLBACK`, `CREATEMETHOD`, `DOCTYPE`, `ONECLASSIFY`, `TWOCLASSIFY`, `THREECLASSIFY`, `FOURCLASSIFY`, `TEMPLATEVERSION`, `STATUS`, `REMARK`, `INPUTUSERID`, `INPUTORGID`, `INPUTTIME`, `UPDATEUSERID`, `UPDATEORGID`, `UPDATETIME`, `CREATECONDITION`, `CREATESHEETCONDITION`) values('ed23bee1ec1544628d400d47f4fdd6c8',NULL,'','车辆抵押合同','车辆抵押合同_{contract_number}.docx','车辆抵押合同.docx','word','upload','',NULL,'002','002002','001','001001','001001009','1','','','admin','80009000200010001','2018/02/24 14:26:59','admin','80009000200010001','2018/02/24 03:52:27','','');
|
||
-- 增加 车辆抵押合同 参数配置
|
||
insert into `BF_TEMPLATEPARAM` (`ID`, `PARAMID`, `TEMPLATEID`, `INPUTUSERID`, `INPUTORGID`, `INPUTTIME`, `UPDATEUSERID`, `UPDATEORGID`, `UPDATETIME`) values('2bb545e5d9394f3e8534547f1a82af52','845f75b6384f4e80955bf39181391f01','ed23bee1ec1544628d400d47f4fdd6c8',NULL,NULL,NULL,NULL,NULL,NULL);
|
||
-- 增加 车辆抵押合同 导出配置
|
||
insert into `BF_TEMPLATELABLE` (`ID`, `LABLEID`, `TEMPLATEID`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('1d1b786ec52744cebf3aa9d5b63cbda8','ba564b64e8af4aa0adb511da5fb0452d','ed23bee1ec1544628d400d47f4fdd6c8',NULL,NULL,NULL,NULL,NULL,NULL);
|
||
insert into `BF_TEMPLATELABLE` (`ID`, `LABLEID`, `TEMPLATEID`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('241f32f641d84b56b59d7eca2f5d9ab5','ca0b081ccc4940669ab756d19e60dff3','ed23bee1ec1544628d400d47f4fdd6c8',NULL,NULL,NULL,NULL,NULL,NULL);
|
||
insert into `BF_TEMPLATELABLE` (`ID`, `LABLEID`, `TEMPLATEID`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('a659401a0ded41cb9d85e3f2e13e2592','c665abf82aae4fa4a547641a5af8ae46','ed23bee1ec1544628d400d47f4fdd6c8',NULL,NULL,NULL,NULL,NULL,NULL);
|
||
|
||
-- 增加 抵押人的标签配置
|
||
insert into `BF_LABLECONFIG` (`ID`, `TAGNUMBER`, `TAGNAME`, `TITLE`, `TAGTYPE`, `VALUETYPE`, `VALUEFIELD`, `VALUEMETHOD`, `THOUSANDSFIELD`, `ISSHOEINDEX`, `REMARK`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`, `OPERATORCLASS`) values('ca0b081ccc4940669ab756d19e60dff3','0008','mortgager','抵押人信息','tag_type2','value_type3','customername,certid,phone,contract_number','select ci.customername customername,ifnull(cert.certid,\'\') certid,concat(ifnull(tel.area,\'\'),tel.telephone) phone,con.contract_number\r\n from LB_GUARANTY_TEMP O \r\n left join lb_contract_info_temp con on con.FLOWUNID=O.flowunid\r\n left join CUSTOMER_INFO ci on O.GUARANTOR=ci.customerid\r\n left join CUSTOMER_CERT cert on ci.customerid=cert.customerid and cert.certtype=\'Ind01\'\r\n left join (\r\n select telz.customerid customerid,telz.teltype,telz.area area ,telz.telephone telephone,telz.isnew \r\n from CUSTOMER_TEL telz\r\n left join (\r\n SELECT customerid,MIN(teltype) teltype FROM CUSTOMER_TEL WHERE isnew=\'yes\' GROUP BY customerid\r\n ) telz2 on telz2.customerid=telz.customerid where telz2.teltype=telz.teltype and telz.isnew=\'yes\'\r\n )tel on tel.customerid=ci.customerid\r\n where O.flowunid=:{FLOW_UNID}','','N','用于车辆抵押合同','','','','','','','word_default_class');
|
||
|
||
|
||
|
||
-- 增加 回租合同代码
|
||
insert into `code_library` (`codeno`, `itemno`, `itemname`, `bankno`, `sortno`, `isinuse`, `itemdescribe`, `itemattribute`, `relativecode`, `attribute1`, `attribute2`, `attribute3`, `attribute4`, `attribute5`, `attribute6`, `attribute7`, `attribute8`, `inputuser`, `inputorg`, `inputtime`, `updateuser`, `updatetime`, `remark`, `helptext`) values('ProductContractTemplate','001001010','融资租赁回租合同','','001001010','1','','','','','','','','','','','','SYS_Designer',NULL,'2018/02/24 16:29:38','SYS_Designer','2018/02/24 16:29:38','','');
|
||
-- 增加 回租合同模板管理
|
||
insert into `BF_TEMPLATE` (`ID`, `SERIALNO`, `SORTNUMBER`, `TEMPLATENAME`, `TEMPLATESHOWNAME`, `TEMPLATEPATH`, `TEMPLATETYPE`, `OPERATETYPE`, `CALLBACK`, `CREATEMETHOD`, `DOCTYPE`, `ONECLASSIFY`, `TWOCLASSIFY`, `THREECLASSIFY`, `FOURCLASSIFY`, `TEMPLATEVERSION`, `STATUS`, `REMARK`, `INPUTUSERID`, `INPUTORGID`, `INPUTTIME`, `UPDATEUSERID`, `UPDATEORGID`, `UPDATETIME`, `CREATECONDITION`, `CREATESHEETCONDITION`) values('e51c26c957314f928ca810ff9988df76',NULL,'','融资租赁回租合同','融资租赁回租合同_{contract_number}.docx','融资租赁回租合同.docx','word','upload','',NULL,'002','002002','001','001001','001001010','1','','','admin','80009000200010001','2018/02/24 16:29:47','admin','80009000200010001','2018/02/26 11:35:17','','');
|
||
|
||
-- 增加回租合同参数配置
|
||
insert into `BF_TEMPLATEPARAM` (`ID`, `PARAMID`, `TEMPLATEID`, `INPUTUSERID`, `INPUTORGID`, `INPUTTIME`, `UPDATEUSERID`, `UPDATEORGID`, `UPDATETIME`) values('19c5bcf3d1e04cfd8c12c51e635892a1','845f75b6384f4e80955bf39181391f01','e51c26c957314f928ca810ff9988df76',NULL,NULL,NULL,NULL,NULL,NULL);
|
||
-- 增加 回租合同 导出配置
|
||
insert into `BF_TEMPLATELABLE` (`ID`, `LABLEID`, `TEMPLATEID`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('351412eb5d954a15aeb59e581ddf1034','d8fdfbcc16fc44288b10ce310622f088','e51c26c957314f928ca810ff9988df76',NULL,NULL,NULL,NULL,NULL,NULL);
|
||
insert into `BF_TEMPLATELABLE` (`ID`, `LABLEID`, `TEMPLATEID`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('3db2be1300c749c7804f8cc3005eb114','c665abf82aae4fa4a547641a5af8ae46','e51c26c957314f928ca810ff9988df76',NULL,NULL,NULL,NULL,NULL,NULL);
|
||
insert into `BF_TEMPLATELABLE` (`ID`, `LABLEID`, `TEMPLATEID`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('4be56e1349364c15ab127d13a7907e9f','dc60973fa05b447aa825549390a82250','e51c26c957314f928ca810ff9988df76',NULL,NULL,NULL,NULL,NULL,NULL);
|
||
insert into `BF_TEMPLATELABLE` (`ID`, `LABLEID`, `TEMPLATEID`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('718d21459ae4485b8b6673d5ccc186d0','80b6e1e81fa2473396cbe26373cb6acc','e51c26c957314f928ca810ff9988df76',NULL,NULL,NULL,NULL,NULL,NULL);
|
||
insert into `BF_TEMPLATELABLE` (`ID`, `LABLEID`, `TEMPLATEID`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('f6763e0656ac45cf96dfe2daae1fbad9','11e14869e219456cbe1ec4d51635bb42','e51c26c957314f928ca810ff9988df76',NULL,NULL,NULL,NULL,NULL,NULL);
|
||
-- 增加 回租合同 标签配置
|
||
insert into `BF_LABLECONFIG` (`ID`, `TAGNUMBER`, `TAGNAME`, `TITLE`, `TAGTYPE`, `VALUETYPE`, `VALUEFIELD`, `VALUEMETHOD`, `THOUSANDSFIELD`, `ISSHOEINDEX`, `REMARK`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`, `OPERATORCLASS`) values('11e14869e219456cbe1ec4d51635bb42','0011','IndInfo','自然人回租取值','tag_type2','value_type3','certid,WORKCORP,WORKADD,telephone,cudate','SELECT cert.certid,person.WORKCORP,person.WORKADD,tel.telephone,DATE_FORMAT(CURDATE(),\'%Y年%m月%d日\') cudate\r\n FROM LB_UNION_LESSEE_TEMP lessee\r\n LEFT JOIN customer_info cust ON cust.customerid=lessee.customer_id\r\n LEFT JOIN CUSTOMER_PERSON person ON person.customerid=cust.customerid\r\n LEFT JOIN customer_cert cert ON cert.customerid=cust.customerid AND cert.certtype=\'Ind01\' AND cert.status=\'valid\'\r\n LEFT JOIN customer_tel tel ON tel.customerid=lessee.customer_id AND isnew=\'yes\' AND teltype=\'010\'\r\n WHERE lessee.is_main=\'Y\' AND lessee.flowunid=:{FLOW_UNID}','','N','','','','','','','','word_default_class');
|
||
insert into `BF_LABLECONFIG` (`ID`, `TAGNUMBER`, `TAGNAME`, `TITLE`, `TAGTYPE`, `VALUETYPE`, `VALUEFIELD`, `VALUEMETHOD`, `THOUSANDSFIELD`, `ISSHOEINDEX`, `REMARK`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`, `OPERATORCLASS`) values('80b6e1e81fa2473396cbe26373cb6acc','0012','rentInfo','租金列表','tag_type3','value_type3','rentList,plan_date,rent','SELECT CONCAT(\'第\',ArabicToChinese(rent.plan_list),\'期\') rentList,rent.plan_date,rent.rent\r\n FROM LC_RENT_PLAN_TEMP rent \r\n WHERE rent.flowunid=:{FLOW_UNID} ORDER BY rent.plan_list;','','N','','','','','','','','word_default_class');
|
||
insert into `BF_LABLECONFIG` (`ID`, `TAGNUMBER`, `TAGNAME`, `TITLE`, `TAGTYPE`, `VALUETYPE`, `VALUEFIELD`, `VALUEMETHOD`, `THOUSANDSFIELD`, `ISSHOEINDEX`, `REMARK`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`, `OPERATORCLASS`) values('c665abf82aae4fa4a547641a5af8ae46','0094','ContractNumberHeader','业务合同号页眉','tag_type1','value_type3','contract_number','select contract_number from lb_contract_info_temp where flowunid=:{FLOW_UNID}','','N','','','','','','','','word_header_class');
|
||
insert into `BF_LABLECONFIG` (`ID`, `TAGNUMBER`, `TAGNAME`, `TITLE`, `TAGTYPE`, `VALUETYPE`, `VALUEFIELD`, `VALUEMETHOD`, `THOUSANDSFIELD`, `ISSHOEINDEX`, `REMARK`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`, `OPERATORCLASS`) values('d8fdfbcc16fc44288b10ce310622f088','0009','LeasebackEquip','回租合同车辆信息','tag_type2','value_type3','BRAND,MODEL,VNDR_NAME,PLATE_NUMBER,CAR_COLOUR,FRAME_NUMBER','SELECT BRAND,MODEL,VNDR_NAME,PLATE_NUMBER,CAR_COLOUR,FRAME_NUMBER FROM LB_EQUIPMENT_CAR_TEMP WHERE flowunid=:{FLOW_UNID}','','N','','','','','','','','word_default_class');
|
||
insert into `BF_LABLECONFIG` (`ID`, `TAGNUMBER`, `TAGNAME`, `TITLE`, `TAGTYPE`, `VALUETYPE`, `VALUEFIELD`, `VALUEMETHOD`, `THOUSANDSFIELD`, `ISSHOEINDEX`, `REMARK`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`, `OPERATORCLASS`) values('dc60973fa05b447aa825549390a82250','0010','LeasebackCondition','回租合同商务条件','tag_type2','value_type3','LEASE_TERM,EQUIP_AMT,FIRST_PAYMENT,SETTLE_METHOD,PERIOD_TYPE,NOMINALPRICE','SELECT condi.LEASE_TERM,format(condi.EQUIP_AMT,2) EQUIP_AMT,format(condi.FIRST_PAYMENT,2) FIRST_PAYMENT,cod.itemname SETTLE_METHOD,\r\n CASE condi.PERIOD_TYPE WHEN \'period_type_1\' THEN \'月先付\' ELSE \'月后付\' END AS PERIOD_TYPE,\r\n CASE WHEN condi.NOMINAL_PRICE>0 THEN CONCAT(\'支付留购价款【\',condi.NOMINAL_PRICE,\'】元\') ELSE \'0.00\' END AS NOMINALPRICE\r\n FROM LC_CALC_CONDITION_TEMP condi\r\n LEFT JOIN code_library cod ON cod.itemno=condi.SETTLE_METHOD AND cod.codeno=\'settle_method\'\r\n WHERE condi.flowunid=:{FLOW_UNID}','','N','','','','','','','','word_default_class');
|