1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64
| INSERT OVERWRITE TABLE std_busi_event_zfqlyg SELECT /*+mapjoin(c1,c2,c3,c4,c5,c6)*/ uuid(), a.CASEINFO_ID, '一般案卷', a.CASENUM, NULL , NULL, NULL, a.TYPECODE, a.TYPE1 , tocname(a.TYPE1, c1.TYPENAME), a.TYPE2 , tocname(a.TYPE2, c2.TYPENAME), a.TYPE3 , tocname(a.TYPE3, c3.TYPENAME), a.TYPENAME , a.CURRSTATECODE, NULL, a.SRC_ID, a.SRCNAME, a.SUBSRC1 , a.SUBSRC2, a.SUBSRC3, a.DEPARTMENT, a.PARTY, a.ISSUETIME , a.ADDRESS, a.REGION , CASE a.REGION WHEN 1 THEN '背街小巷' WHEN 2 THEN '次要道路' WHEN 3 THEN '主要道路' ELSE NULL END, a.REGIONLEVEL, a.UNDERTAKEPEOPLE, NULL, a.VIOLATELAW , a.PUNISHLAW, a.PUNISHDESC, a.DESCRIPTION, NULL, NULL , a.RECORDTIME, a.ISNOPUNISH , CASE a.ISNOPUNISH WHEN 0 THEN '处罚' WHEN 1 THEN '不予处罚' ELSE NULL END, a.PENALTYOVERLIMIT , CASE a.PENALTYOVERLIMIT WHEN 0 THEN '否' WHEN 1 THEN '处罚金额低于自由裁量标准' WHEN 2 THEN '处罚金额高于自由裁量标准' WHEN 3 THEN '自由裁量计算值与处罚金额不一致' ELSE NULL END, a.ENTERCURRPROTIME, a.EXPIREDATE, a.QUICKCASE , CASE a.QUICKCASE WHEN 0 THEN '否' WHEN 1 THEN '是' ELSE NULL END, a.ISNATUREPERSON, a.RECORDPEOPLE, a.GISX, a.GISY , a.CASESERIAL, a.PARTYNAME, a.PARTIESID, a.ZJCODE, NULL , tocname(a.caseinfo_id, c4.department) , tocname(a.caseinfo_id, c5.excuteresult) , tocname(a.caseinfo_id, c6.APPROVETIME) , tocname(a.caseinfo_id, c6.EXCUTETIME) , tocname(a.caseinfo_id, c5.CLOSECASEREPORTTIME) , tocname(a.caseinfo_id, c5.CLOSETIME) FROM INFO_ZFQLYG_CASEINFO a LEFT OUTER JOIN INFO_ZFQLYG_CASETYPE c1 ON a.type1 = c1.typecode LEFT OUTER JOIN INFO_ZFQLYG_CASETYPE c2 ON a.type2 = c2.typecode LEFT OUTER JOIN INFO_ZFQLYG_CASETYPE c3 ON a.type3 = c3.typecode LEFT OUTER JOIN INFO_ZFQLYG_CASEUNDERTAKER c4 ON a.caseinfo_id = c4.caseinfo_id LEFT OUTER JOIN INFO_ZFQLYG_CLOSECASE c5 ON a.caseinfo_id = c5.caseinfo_id LEFT OUTER JOIN INFO_ZFQLYG_CLOSECASEREPORT c6 ON a.caseinfo_id = c6.caseinfo_id; insert into table STD_OBJ_OTHER_CURB_AND_GUTTER SELECT uuid(), a.NAME, a.ROAD_NAME, a.ORIGIN_INSERTION, a.LENGTH , a.MATERIAL, a.COUNT_NUM, a.ID, a.STATUS, a.POTENTIAL , a.START_TIME, a.UPDATE_TIME, a.FUNDS_PROVID, a.UPDATE_LIST, a.DEPT , a.PROPERTY, a.ADMINITRATION, a.MANAGEMENT, a.MAINTENANCE_UNIT, a.MANAGEMENT_UNIT_1 , a.TRUSTEESHIP, a.SUPERVISION, a.TELEPHONE, a.CONTACTS, a.MAINTENANCE_CYCLE , a.CLEANING_INTERVAL, a.NOTICE_DEPT, a.COORDINATION_FIRST, a.COORDINATION_SENDCOND, a.REGION_INFO , a.STREET, a.COMMUNITY, a.GRID, a.POSITION_DESC, CAST(getlon(a.shape) AS DOUBLE) , CAST(getlat(a.shape) AS DOUBLE), 'GIS服务中心', '萧山道路平侧石' FROM INFO_GIS_CURB_AND_GUTTER a;
|