GAT项目新需求:车辆基本信息查询增加勾选不包含下级

Openwifi 开源项目解读(一) Openwifi wifi 80211 无线网卡 基带 FPGA linux 驱动 开源 阅读详情

代码:


SQL语句:

superuser登录,默认查全部,包含下级:



--[936, 2000, 0, 936, 2000, 0, -1, 2000, 0]
select *
  from (select h.hostid,
               h.hostno,
               e.verify_status as verifyStatus,
               e.host_brand as hostBrand,
               d.full_name as usefullname,
               o.full_name as ownfullname,
               h.displacement,
               e.displacement_type as displacementType,
               e.asset_attribute as assetAttribute,
               e.purchase_type as purchaseType,
               to_char(e.purchase_date, 'yyyy-mm-dd') as purchaseDate,
               e.usage_property as usageProperty,
               e.host_purpose as hostPurpose,
               e.host_veh_type as hostVehType,
               e.host_price_with_tax as hostPriceWithTax,
               e.host_price as hostPrice,
               e.host_tax as hostTax,
               h.original_mile as originalMile,
               e.engine_id as engineId,
               e.host_vin as hostVin,
               h.appsysid,
               h.appdeptid,
               e.allot_type as allotType,
               to_char(e.allot_date, 'yyyy-mm-dd') as allotDate,
               e.service_object as serviceObject,
               e.keeper as kepper,
               e.keeper_phone as kepperPhone,
               e.owner_appsysid as ownerAppSysId,
               e.owner_appdeptid as ownerAppDeptId,
               e.fixed_asset_id as fixedAssetId,
               e.host_tag_flag as hostTagFlag,
               e.process_status as processStatus,
               e.manufacturer,
               e.oil_type as oilType,
               e.xszh,
               h.hostno_color as hostNoColor,
               e.host_color as hostColor,
               e.rated_kg as ratedKg,
               e.CREATE_USER_ID as CREATEUSERID,
               h.UPDATESTATUSTIME as updatetimeorder,
               e.veh_kg as vehKg,
               e.tyre_size as tyreSize,
               e.rated_passenger as ratedPassenger,
               e.remark,
               h.CREATUSERID as basecrtuser,
               e.CREATE_USER_NAME as createUserName,
               e.CREATE_TIME as createTime,
               e.UPDATE_USER_NAME as updateUserName,
               e.UPDATE_TIME as updateTime,
               d.DEPT_HIERARCHY as uselevel,
               d.DEPT_PROPERTY as useprop,
               o.DEPT_HIERARCHY as ownLevel,
               o.DEPT_PROPERTY as ownProp,
               e.DRIVING_LICENSE_DEPTID as drivingLicenseDeptId,
               e.DRIVING_LICENSE_SYSID as drivingLicenseSysId,
               to_char(e.DRIVING_LICENSE_DATE, 'yyyy-mm-dd') as drivingLicenseDate,
               e.STATE_OF_ORIGIN as stateOfOrigin,
               e.HAS_PASSPORT as hasPassport,
               e.HAS_ETC as hasETC,
               to_char(e.ANNUAL_SURVEY_DATE, 'yyyy-mm-dd') as annualSurveyDate,
               e.UPDATE_RECORDS as updateRecords,
               e.VEHICLENO as vehicleNo,
               e.VEHICLE_MODEL as vehicleModel,
               e.VEHICLE_BRAND as vehicleBrand
          from position_host_info h
          left join position_host_info_extend e
            on h.hostid = e.hostid
          left join appdeptinfo d
            on h.appsysid = d.appsysid
           and h.appdeptid = d.appdeptid
          left join appdeptinfo o
            on e.owner_appsysid = o.appsysid
           and e.owner_appdeptid = o.appdeptid
         where exists (select appsysid, appdeptid
                  from table(get_subdept(936, 2000, 0)) f
                 where h.appsysid = f.appsysid
                   and h.appdeptid = f.appdeptid)
        union
        select h.hostid,
               h.hostno,
               e.verify_status as verifyStatus,
               e.host_brand as hostBrand,
               d.full_name as usefullname,
               o.full_name as ownfullname,
               h.displacement,
               e.displacement_type as displacementType,
               e.asset_attribute as assetAttribute,
               e.purchase_type as purchaseType,
               to_char(e.purchase_date, 'yyyy-mm-dd') as purchaseDate,
               e.usage_property as usageProperty,
               e.host_purpose as hostPurpose,
               e.host_veh_type as hostVehType,
               e.host_price_with_tax as hostPriceWithTax,
               e.host_price as hostPrice,
               e.host_tax as hostTax,
               h.original_mile as originalMile,
               e.engine_id as engineId,
               e.host_vin as hostVin,
               h.appsysid,
               h.appdeptid,
               e.allot_type as allotType,
               to_char(e.allot_date, 'yyyy-mm-dd') as allotDate,
               e.service_object as serviceObject,
               e.keeper as kepper,
               e.keeper_phone as kepperPhone,
               e.owner_appsysid as ownerAppSysId,
               e.owner_appdeptid as ownerAppDeptId,
               e.fixed_asset_id as fixedAssetId,
               e.host_tag_flag as hostTagFlag,
               e.process_status as processStatus,
               e.manufacturer,
               e.oil_type as oilType,
               e.xszh,
               h.hostno_color as hostNoColor,
               e.host_color as hostColor,
               e.rated_kg as ratedKg,
               e.CREATE_USER_ID as CREATEUSERID,
               h.UPDATESTATUSTIME as updatetimeorder,
               e.veh_kg as vehKg,
               e.tyre_size as tyreSize,
               e.rated_passenger as ratedPassenger,
               e.remark,
               h.CREATUSERID as basecrtuser,
               e.CREATE_USER_NAME as createUserName,
               e.CREATE_TIME as createTime,
               e.UPDATE_USER_NAME as updateUserName,
               e.UPDATE_TIME as updateTime,
               d.DEPT_HIERARCHY as uselevel,
               d.DEPT_PROPERTY as useprop,
               o.DEPT_HIERARCHY as ownLevel,
               o.DEPT_PROPERTY as ownProp,
               e.DRIVING_LICENSE_DEPTID as drivingLicenseDeptId,
               e.DRIVING_LICENSE_SYSID as drivingLicenseSysId,
               to_char(e.DRIVING_LICENSE_DATE, 'yyyy-mm-dd') as drivingLicenseDate,
               e.STATE_OF_ORIGIN as stateOfOrigin,
               e.HAS_PASSPORT as hasPassport,
               e.HAS_ETC as hasETC,
               to_char(e.ANNUAL_SURVEY_DATE, 'yyyy-mm-dd') as annualSurveyDate,
               e.UPDATE_RECORDS as updateRecords,
               e.VEHICLENO as vehicleNo,
               e.VEHICLE_MODEL as vehicleModel,
               e.VEHICLE_BRAND as vehicleBrand
          from position_host_info h
          left join position_host_info_extend e
            on h.hostid = e.hostid
          left join appdeptinfo d
            on h.appsysid = d.appsysid
           and h.appdeptid = d.appdeptid
          left join appdeptinfo o
            on e.owner_appsysid = o.appsysid
           and e.owner_appdeptid = o.appdeptid
         where exists (select appsysid, appdeptid
                  from table(get_subdept(936, 2000, 0)) g
                 where g.appsysid = e.owner_appsysid
                   and g.appdeptid = e.owner_appdeptid)) t
 where exists (select appsysid, appdeptid
          from table(get_subdept(-1, 2000, 0)) g
         where g.appsysid = t.appsysid
           and g.appdeptid = t.appdeptid)
 order by t.updatetimeorder desc, t.hostno

勾选后,只查本部门的:

--[936, 2000, 0, 936, 2000, 0, 2000, 0]
select *
  from (select h.hostid,
               h.hostno,
               e.verify_status as verifyStatus,
               e.host_brand as hostBrand,
               d.full_name as usefullname,
               o.full_name as ownfullname,
               h.displacement,
               e.displacement_type as displacementType,
               e.asset_attribute as assetAttribute,
               e.purchase_type as purchaseType,
               to_char(e.purchase_date, 'yyyy-mm-dd') as purchaseDate,
               e.usage_property as usageProperty,
               e.host_purpose as hostPurpose,
               e.host_veh_type as hostVehType,
               e.host_price_with_tax as hostPriceWithTax,
               e.host_price as hostPrice,
               e.host_tax as hostTax,
               h.original_mile as originalMile,
               e.engine_id as engineId,
               e.host_vin as hostVin,
               h.appsysid,
               h.appdeptid,
               e.allot_type as allotType,
               to_char(e.allot_date, 'yyyy-mm-dd') as allotDate,
               e.service_object as serviceObject,
               e.keeper as kepper,
               e.keeper_phone as kepperPhone,
               e.owner_appsysid as ownerAppSysId,
               e.owner_appdeptid as ownerAppDeptId,
               e.fixed_asset_id as fixedAssetId,
               e.host_tag_flag as hostTagFlag,
               e.process_status as processStatus,
               e.manufacturer,
               e.oil_type as oilType,
               e.xszh,
               h.hostno_color as hostNoColor,
               e.host_color as hostColor,
               e.rated_kg as ratedKg,
               e.CREATE_USER_ID as CREATEUSERID,
               h.UPDATESTATUSTIME as updatetimeorder,
               e.veh_kg as vehKg,
               e.tyre_size as tyreSize,
               e.rated_passenger as ratedPassenger,
               e.remark,
               h.CREATUSERID as basecrtuser,
               e.CREATE_USER_NAME as createUserName,
               e.CREATE_TIME as createTime,
               e.UPDATE_USER_NAME as updateUserName,
               e.UPDATE_TIME as updateTime,
               d.DEPT_HIERARCHY as uselevel,
               d.DEPT_PROPERTY as useprop,
               o.DEPT_HIERARCHY as ownLevel,
               o.DEPT_PROPERTY as ownProp,
               e.DRIVING_LICENSE_DEPTID as drivingLicenseDeptId,
               e.DRIVING_LICENSE_SYSID as drivingLicenseSysId,
               to_char(e.DRIVING_LICENSE_DATE, 'yyyy-mm-dd') as drivingLicenseDate,
               e.STATE_OF_ORIGIN as stateOfOrigin,
               e.HAS_PASSPORT as hasPassport,
               e.HAS_ETC as hasETC,
               to_char(e.ANNUAL_SURVEY_DATE, 'yyyy-mm-dd') as annualSurveyDate,
               e.UPDATE_RECORDS as updateRecords,
               e.VEHICLENO as vehicleNo,
               e.VEHICLE_MODEL as vehicleModel,
               e.VEHICLE_BRAND as vehicleBrand
          from position_host_info h
          left join position_host_info_extend e
            on h.hostid = e.hostid
          left join appdeptinfo d
            on h.appsysid = d.appsysid
           and h.appdeptid = d.appdeptid
          left join appdeptinfo o
            on e.owner_appsysid = o.appsysid
           and e.owner_appdeptid = o.appdeptid
         where exists (select appsysid, appdeptid
                  from table(get_subdept(936, 2000, 0)) f
                 where h.appsysid = f.appsysid
                   and h.appdeptid = f.appdeptid)
        union
        select h.hostid,
               h.hostno,
               e.verify_status as verifyStatus,
               e.host_brand as hostBrand,
               d.full_name as usefullname,
               o.full_name as ownfullname,
               h.displacement,
               e.displacement_type as displacementType,
               e.asset_attribute as assetAttribute,
               e.purchase_type as purchaseType,
               to_char(e.purchase_date, 'yyyy-mm-dd') as purchaseDate,
               e.usage_property as usageProperty,
               e.host_purpose as hostPurpose,
               e.host_veh_type as hostVehType,
               e.host_price_with_tax as hostPriceWithTax,
               e.host_price as hostPrice,
               e.host_tax as hostTax,
               h.original_mile as originalMile,
               e.engine_id as engineId,
               e.host_vin as hostVin,
               h.appsysid,
               h.appdeptid,
               e.allot_type as allotType,
               to_char(e.allot_date, 'yyyy-mm-dd') as allotDate,
               e.service_object as serviceObject,
               e.keeper as kepper,
               e.keeper_phone as kepperPhone,
               e.owner_appsysid as ownerAppSysId,
               e.owner_appdeptid as ownerAppDeptId,
               e.fixed_asset_id as fixedAssetId,
               e.host_tag_flag as hostTagFlag,
               e.process_status as processStatus,
               e.manufacturer,
               e.oil_type as oilType,
               e.xszh,
               h.hostno_color as hostNoColor,
               e.host_color as hostColor,
               e.rated_kg as ratedKg,
               e.CREATE_USER_ID as CREATEUSERID,
               h.UPDATESTATUSTIME as updatetimeorder,
               e.veh_kg as vehKg,
               e.tyre_size as tyreSize,
               e.rated_passenger as ratedPassenger,
               e.remark,
               h.CREATUSERID as basecrtuser,
               e.CREATE_USER_NAME as createUserName,
               e.CREATE_TIME as createTime,
               e.UPDATE_USER_NAME as updateUserName,
               e.UPDATE_TIME as updateTime,
               d.DEPT_HIERARCHY as uselevel,
               d.DEPT_PROPERTY as useprop,
               o.DEPT_HIERARCHY as ownLevel,
               o.DEPT_PROPERTY as ownProp,
               e.DRIVING_LICENSE_DEPTID as drivingLicenseDeptId,
               e.DRIVING_LICENSE_SYSID as drivingLicenseSysId,
               to_char(e.DRIVING_LICENSE_DATE, 'yyyy-mm-dd') as drivingLicenseDate,
               e.STATE_OF_ORIGIN as stateOfOrigin,
               e.HAS_PASSPORT as hasPassport,
               e.HAS_ETC as hasETC,
               to_char(e.ANNUAL_SURVEY_DATE, 'yyyy-mm-dd') as annualSurveyDate,
               e.UPDATE_RECORDS as updateRecords,
               e.VEHICLENO as vehicleNo,
               e.VEHICLE_MODEL as vehicleModel,
               e.VEHICLE_BRAND as vehicleBrand
          from position_host_info h
          left join position_host_info_extend e
            on h.hostid = e.hostid
          left join appdeptinfo d
            on h.appsysid = d.appsysid
           and h.appdeptid = d.appdeptid
          left join appdeptinfo o
            on e.owner_appsysid = o.appsysid
           and e.owner_appdeptid = o.appdeptid
         where exists (select appsysid, appdeptid
                  from table(get_subdept(936, 2000, 0)) g
                 where g.appsysid = e.owner_appsysid
                   and g.appdeptid = e.owner_appdeptid)) t
 where t.appsysid = 2000
   and t.appdeptid = 0
 order by t.updatetimeorder desc, t.hostno

人事处登录,人事处已经没有下级了,勾选不勾选,结果都一样,只是sql语句不一样而已

默认查全部,包含下级(其实没有下级了):



--[8196, 23551, 3, 8196, 23551, 3, -1, 23551, 3]
select *
  from (select h.hostid,
               h.hostno,
               e.verify_status as verifyStatus,
               e.host_brand as hostBrand,
               d.full_name as usefullname,
               o.full_name as ownfullname,
               h.displacement,
               e.displacement_type as displacementType,
               e.asset_attribute as assetAttribute,
               e.purchase_type as purchaseType,
               to_char(e.purchase_date, 'yyyy-mm-dd') as purchaseDate,
               e.usage_property as usageProperty,
               e.host_purpose as hostPurpose,
               e.host_veh_type as hostVehType,
               e.host_price_with_tax as hostPriceWithTax,
               e.host_price as hostPrice,
               e.host_tax as hostTax,
               h.original_mile as originalMile,
               e.engine_id as engineId,
               e.host_vin as hostVin,
               h.appsysid,
               h.appdeptid,
               e.allot_type as allotType,
               to_char(e.allot_date, 'yyyy-mm-dd') as allotDate,
               e.service_object as serviceObject,
               e.keeper as kepper,
               e.keeper_phone as kepperPhone,
               e.owner_appsysid as ownerAppSysId,
               e.owner_appdeptid as ownerAppDeptId,
               e.fixed_asset_id as fixedAssetId,
               e.host_tag_flag as hostTagFlag,
               e.process_status as processStatus,
               e.manufacturer,
               e.oil_type as oilType,
               e.xszh,
               h.hostno_color as hostNoColor,
               e.host_color as hostColor,
               e.rated_kg as ratedKg,
               e.CREATE_USER_ID as CREATEUSERID,
               h.UPDATESTATUSTIME as updatetimeorder,
               e.veh_kg as vehKg,
               e.tyre_size as tyreSize,
               e.rated_passenger as ratedPassenger,
               e.remark,
               h.CREATUSERID as basecrtuser,
               e.CREATE_USER_NAME as createUserName,
               e.CREATE_TIME as createTime,
               e.UPDATE_USER_NAME as updateUserName,
               e.UPDATE_TIME as updateTime,
               d.DEPT_HIERARCHY as uselevel,
               d.DEPT_PROPERTY as useprop,
               o.DEPT_HIERARCHY as ownLevel,
               o.DEPT_PROPERTY as ownProp,
               e.DRIVING_LICENSE_DEPTID as drivingLicenseDeptId,
               e.DRIVING_LICENSE_SYSID as drivingLicenseSysId,
               to_char(e.DRIVING_LICENSE_DATE, 'yyyy-mm-dd') as drivingLicenseDate,
               e.STATE_OF_ORIGIN as stateOfOrigin,
               e.HAS_PASSPORT as hasPassport,
               e.HAS_ETC as hasETC,
               to_char(e.ANNUAL_SURVEY_DATE, 'yyyy-mm-dd') as annualSurveyDate,
               e.UPDATE_RECORDS as updateRecords,
               e.VEHICLENO as vehicleNo,
               e.VEHICLE_MODEL as vehicleModel,
               e.VEHICLE_BRAND as vehicleBrand
          from position_host_info h
          left join position_host_info_extend e
            on h.hostid = e.hostid
          left join appdeptinfo d
            on h.appsysid = d.appsysid
           and h.appdeptid = d.appdeptid
          left join appdeptinfo o
            on e.owner_appsysid = o.appsysid
           and e.owner_appdeptid = o.appdeptid
         where exists (select appsysid, appdeptid
                  from table(get_subdept(8196, 23551, 3)) f
                 where h.appsysid = f.appsysid
                   and h.appdeptid = f.appdeptid)
        union
        select h.hostid,
               h.hostno,
               e.verify_status as verifyStatus,
               e.host_brand as hostBrand,
               d.full_name as usefullname,
               o.full_name as ownfullname,
               h.displacement,
               e.displacement_type as displacementType,
               e.asset_attribute as assetAttribute,
               e.purchase_type as purchaseType,
               to_char(e.purchase_date, 'yyyy-mm-dd') as purchaseDate,
               e.usage_property as usageProperty,
               e.host_purpose as hostPurpose,
               e.host_veh_type as hostVehType,
               e.host_price_with_tax as hostPriceWithTax,
               e.host_price as hostPrice,
               e.host_tax as hostTax,
               h.original_mile as originalMile,
               e.engine_id as engineId,
               e.host_vin as hostVin,
               h.appsysid,
               h.appdeptid,
               e.allot_type as allotType,
               to_char(e.allot_date, 'yyyy-mm-dd') as allotDate,
               e.service_object as serviceObject,
               e.keeper as kepper,
               e.keeper_phone as kepperPhone,
               e.owner_appsysid as ownerAppSysId,
               e.owner_appdeptid as ownerAppDeptId,
               e.fixed_asset_id as fixedAssetId,
               e.host_tag_flag as hostTagFlag,
               e.process_status as processStatus,
               e.manufacturer,
               e.oil_type as oilType,
               e.xszh,
               h.hostno_color as hostNoColor,
               e.host_color as hostColor,
               e.rated_kg as ratedKg,
               e.CREATE_USER_ID as CREATEUSERID,
               h.UPDATESTATUSTIME as updatetimeorder,
               e.veh_kg as vehKg,
               e.tyre_size as tyreSize,
               e.rated_passenger as ratedPassenger,
               e.remark,
               h.CREATUSERID as basecrtuser,
               e.CREATE_USER_NAME as createUserName,
               e.CREATE_TIME as createTime,
               e.UPDATE_USER_NAME as updateUserName,
               e.UPDATE_TIME as updateTime,
               d.DEPT_HIERARCHY as uselevel,
               d.DEPT_PROPERTY as useprop,
               o.DEPT_HIERARCHY as ownLevel,
               o.DEPT_PROPERTY as ownProp,
               e.DRIVING_LICENSE_DEPTID as drivingLicenseDeptId,
               e.DRIVING_LICENSE_SYSID as drivingLicenseSysId,
               to_char(e.DRIVING_LICENSE_DATE, 'yyyy-mm-dd') as drivingLicenseDate,
               e.STATE_OF_ORIGIN as stateOfOrigin,
               e.HAS_PASSPORT as hasPassport,
               e.HAS_ETC as hasETC,
               to_char(e.ANNUAL_SURVEY_DATE, 'yyyy-mm-dd') as annualSurveyDate,
               e.UPDATE_RECORDS as updateRecords,
               e.VEHICLENO as vehicleNo,
               e.VEHICLE_MODEL as vehicleModel,
               e.VEHICLE_BRAND as vehicleBrand
          from position_host_info h
          left join position_host_info_extend e
            on h.hostid = e.hostid
          left join appdeptinfo d
            on h.appsysid = d.appsysid
           and h.appdeptid = d.appdeptid
          left join appdeptinfo o
            on e.owner_appsysid = o.appsysid
           and e.owner_appdeptid = o.appdeptid
         where exists (select appsysid, appdeptid
                  from table(get_subdept(8196, 23551, 3)) g
                 where g.appsysid = e.owner_appsysid
                   and g.appdeptid = e.owner_appdeptid)) t
 where exists (select appsysid, appdeptid
          from table(get_subdept(-1, 23551, 3)) g
         where g.appsysid = t.appsysid
           and g.appdeptid = t.appdeptid)
 order by t.updatetimeorder desc, t.hostno

勾选后,只查本部门的:

--[8196, 23551, 3, 8196, 23551, 3, 23551, 3]
--bao1人事处登录
select *
  from (select h.hostid,
               h.hostno,
               e.verify_status as verifyStatus,
               e.host_brand as hostBrand,
               d.full_name as usefullname,
               o.full_name as ownfullname,
               h.displacement,
               e.displacement_type as displacementType,
               e.asset_attribute as assetAttribute,
               e.purchase_type as purchaseType,
               to_char(e.purchase_date, 'yyyy-mm-dd') as purchaseDate,
               e.usage_property as usageProperty,
               e.host_purpose as hostPurpose,
               e.host_veh_type as hostVehType,
               e.host_price_with_tax as hostPriceWithTax,
               e.host_price as hostPrice,
               e.host_tax as hostTax,
               h.original_mile as originalMile,
               e.engine_id as engineId,
               e.host_vin as hostVin,
               h.appsysid,
               h.appdeptid,
               e.allot_type as allotType,
               to_char(e.allot_date, 'yyyy-mm-dd') as allotDate,
               e.service_object as serviceObject,
               e.keeper as kepper,
               e.keeper_phone as kepperPhone,
               e.owner_appsysid as ownerAppSysId,
               e.owner_appdeptid as ownerAppDeptId,
               e.fixed_asset_id as fixedAssetId,
               e.host_tag_flag as hostTagFlag,
               e.process_status as processStatus,
               e.manufacturer,
               e.oil_type as oilType,
               e.xszh,
               h.hostno_color as hostNoColor,
               e.host_color as hostColor,
               e.rated_kg as ratedKg,
               e.CREATE_USER_ID as CREATEUSERID,
               h.UPDATESTATUSTIME as updatetimeorder,
               e.veh_kg as vehKg,
               e.tyre_size as tyreSize,
               e.rated_passenger as ratedPassenger,
               e.remark,
               h.CREATUSERID as basecrtuser,
               e.CREATE_USER_NAME as createUserName,
               e.CREATE_TIME as createTime,
               e.UPDATE_USER_NAME as updateUserName,
               e.UPDATE_TIME as updateTime,
               d.DEPT_HIERARCHY as uselevel,
               d.DEPT_PROPERTY as useprop,
               o.DEPT_HIERARCHY as ownLevel,
               o.DEPT_PROPERTY as ownProp,
               e.DRIVING_LICENSE_DEPTID as drivingLicenseDeptId,
               e.DRIVING_LICENSE_SYSID as drivingLicenseSysId,
               to_char(e.DRIVING_LICENSE_DATE, 'yyyy-mm-dd') as drivingLicenseDate,
               e.STATE_OF_ORIGIN as stateOfOrigin,
               e.HAS_PASSPORT as hasPassport,
               e.HAS_ETC as hasETC,
               to_char(e.ANNUAL_SURVEY_DATE, 'yyyy-mm-dd') as annualSurveyDate,
               e.UPDATE_RECORDS as updateRecords,
               e.VEHICLENO as vehicleNo,
               e.VEHICLE_MODEL as vehicleModel,
               e.VEHICLE_BRAND as vehicleBrand
          from position_host_info h
          left join position_host_info_extend e
            on h.hostid = e.hostid
          left join appdeptinfo d
            on h.appsysid = d.appsysid
           and h.appdeptid = d.appdeptid
          left join appdeptinfo o
            on e.owner_appsysid = o.appsysid
           and e.owner_appdeptid = o.appdeptid
         where exists (select appsysid, appdeptid
                  from table(get_subdept(8196, 23551, 3)) f
                 where h.appsysid = f.appsysid
                   and h.appdeptid = f.appdeptid)
        union
        select h.hostid,
               h.hostno,
               e.verify_status as verifyStatus,
               e.host_brand as hostBrand,
               d.full_name as usefullname,
               o.full_name as ownfullname,
               h.displacement,
               e.displacement_type as displacementType,
               e.asset_attribute as assetAttribute,
               e.purchase_type as purchaseType,
               to_char(e.purchase_date, 'yyyy-mm-dd') as purchaseDate,
               e.usage_property as usageProperty,
               e.host_purpose as hostPurpose,
               e.host_veh_type as hostVehType,
               e.host_price_with_tax as hostPriceWithTax,
               e.host_price as hostPrice,
               e.host_tax as hostTax,
               h.original_mile as originalMile,
               e.engine_id as engineId,
               e.host_vin as hostVin,
               h.appsysid,
               h.appdeptid,
               e.allot_type as allotType,
               to_char(e.allot_date, 'yyyy-mm-dd') as allotDate,
               e.service_object as serviceObject,
               e.keeper as kepper,
               e.keeper_phone as kepperPhone,
               e.owner_appsysid as ownerAppSysId,
               e.owner_appdeptid as ownerAppDeptId,
               e.fixed_asset_id as fixedAssetId,
               e.host_tag_flag as hostTagFlag,
               e.process_status as processStatus,
               e.manufacturer,
               e.oil_type as oilType,
               e.xszh,
               h.hostno_color as hostNoColor,
               e.host_color as hostColor,
               e.rated_kg as ratedKg,
               e.CREATE_USER_ID as CREATEUSERID,
               h.UPDATESTATUSTIME as updatetimeorder,
               e.veh_kg as vehKg,
               e.tyre_size as tyreSize,
               e.rated_passenger as ratedPassenger,
               e.remark,
               h.CREATUSERID as basecrtuser,
               e.CREATE_USER_NAME as createUserName,
               e.CREATE_TIME as createTime,
               e.UPDATE_USER_NAME as updateUserName,
               e.UPDATE_TIME as updateTime,
               d.DEPT_HIERARCHY as uselevel,
               d.DEPT_PROPERTY as useprop,
               o.DEPT_HIERARCHY as ownLevel,
               o.DEPT_PROPERTY as ownProp,
               e.DRIVING_LICENSE_DEPTID as drivingLicenseDeptId,
               e.DRIVING_LICENSE_SYSID as drivingLicenseSysId,
               to_char(e.DRIVING_LICENSE_DATE, 'yyyy-mm-dd') as drivingLicenseDate,
               e.STATE_OF_ORIGIN as stateOfOrigin,
               e.HAS_PASSPORT as hasPassport,
               e.HAS_ETC as hasETC,
               to_char(e.ANNUAL_SURVEY_DATE, 'yyyy-mm-dd') as annualSurveyDate,
               e.UPDATE_RECORDS as updateRecords,
               e.VEHICLENO as vehicleNo,
               e.VEHICLE_MODEL as vehicleModel,
               e.VEHICLE_BRAND as vehicleBrand
          from position_host_info h
          left join position_host_info_extend e
            on h.hostid = e.hostid
          left join appdeptinfo d
            on h.appsysid = d.appsysid
           and h.appdeptid = d.appdeptid
          left join appdeptinfo o
            on e.owner_appsysid = o.appsysid
           and e.owner_appdeptid = o.appdeptid
         where exists (select appsysid, appdeptid
                  from table(get_subdept(8196, 23551, 3)) g
                 where g.appsysid = e.owner_appsysid
                   and g.appdeptid = e.owner_appdeptid)) t
 where t.appsysid = 23551
   and t.appdeptid = 3
 order by t.updatetimeorder desc, t.hostno


一维光子晶体态密度计算与应用解析 态密度(DOS)是凝聚态物理和光子学中的核心概念,描述了量子态在能量空间的分布规律。基于麦克斯韦方程组的周期性介电结构分析表明,一维光子晶体通过布拉格散射形成光子带隙,其态密度曲线呈现典型的范霍夫奇点和禁带特征。这种特性使光子晶体在光学工程中具有重要价值,特别是在滤波器设计和传感器开发领域。通过转移矩阵法等数值计算手段,可以精确预测带隙位置和宽度,其中折射率对比度与周期数是关键设计参数。实际应用中,1550nm通信波段滤波器常采用Si/SiO2交替结构,而引入缺陷层则能产生高Q值缺陷模。计算优化时需注意数值 阅读详情

相关推荐

信捷 XDH Ethercat 正负极限配置详解与实战技巧

本文详细解析了信捷XDH系列PLC通过EtherCAT总线配置伺服电机正负硬极限的完整流程与实战技巧。内容涵盖硬件开关选型安装、EtherCAT IO信号映射、软件参数设置(包括关键的极性配置)、调试验证方法,以及硬极限与软极限的协同策略。重点阐述了如何避免常见配置错误,确保运动控制系统的最后一道物理安全防线可靠有效,为工程师提供从理论到实践的全面指导。

wdx012345的博客 605

Gat 开源项目教程

Gat 开源项目教程 项目介绍 Gat 是一个基于 Go 语言的命令行工具,旨在简化生成和操作文本文件的过程。它提供了一系列的命令和选项,使得用户可以快速地生成各种格式的文本文件,如 CSV、JSON 等。Gat 的设计理念是简洁高效,通过简单的命令即可完成复杂的文本处理任务。 项目快速启动 安装 Gat 首先,确保你已经安装了 Go 语言环境。然后,使用以下命令安装 Gat: go instal...

gitblog_00247的博客 531

经典烧脑算法逻辑题--高楼扔鸡蛋:最少次数测出鸡蛋摔碎临界点。

如果在第2层没碎,换到第3层扔.......如果第59层没碎,换到第60层扔;有2个鸡蛋,从100层楼上往下扔,以此来测试鸡蛋的硬度。比如鸡蛋在第9层没有摔碎,在第10层摔碎了,那么鸡蛋不会摔碎的临界点就是9层。因此,我们尝试每10层扔一次,第一次从10层扔,第二次从20层扔,第三次从30层......一直扔到100层。如果第一枚鸡蛋,在50层碎了,第二枚鸡蛋,就从第1层开始扔,一层一层增长,一直扔到第49层。如果第一枚鸡蛋在50层没碎了,则继续使用二分法,在剩余楼层的一半(75层)往下扔。

借雨醉东风的博客 1820

解决GAT项目Bug:轨迹分析查询不到数据

问题描述:左边没数据,地图上也没轨迹 控制台信息:没有该方法 搜索该类: 发现类存在于两个项目中,GAT已经引用了公司通用的jar包,而GAT代码中依然写了重复的代码,造成了冲突 解决办法:把这两个包下的代码删了,提交即可

兴趣是最好的老师 923

软考中级信息系统监理师(第二版)-第21章基础设施工程监理

由于网络信息技术的飞速发展,变化日新月异,网络设计不但要保证目前网络传输容量的要求,也要考虑今后网络的发展,满足当前以及今后相当一段时间内的网络需求,便于向新技术的升级和衔接,同时又需要保护原有的投资。通用布缆系统工程中,承建单位的竣工文档主要包括以下内容:承建合同,招标文件,投标文件,设计方案,工程实施组织设计方案,工程施工报告,隐蔽工程记录,变更记录,自测报告,信息点分布图(表),园区、楼宇、水平配线表,楼层平面图及无线设备点位图,无线设备信息表,竣工图纸等。多排安装时,列间距不应小于1200mm。

2301_78583973的博客 1404

高分系列卫星轨道、传感器参数等信息

遥感卫星数据简介-高分系列

中遥科 3310

GAT项目新需求:加油管理修改

新需求:加油管理列表要带付费方式,如果是加油卡,则显示卡号,类似江苏电力这样的页面 开发: 1.先增加数据库CAR_OIL表字段和注释 alter table CAR_OIL ADD  OILCARD_NO VARCHAR2(100); alter table CAR_OIL ADD  PAYTYPE NUMBER(2);  comment on column

兴趣是最好的老师 1415

从ABS到EBS再到AEBS:商用车制动安全系统的“三代同堂”与技术演进史

本文详细解析了商用车制动安全系统从ABS到EBS再到AEBS的技术演进历程。通过对比三代系统的性能差异和应用效果,揭示了电子控制单元(ECU)在提升制动精度和安全性的核心作用,并展望了智能制动技术的未来发展趋势。

weixin_42651748的博客 331

GAT项目前台到后台

1.将前台代码放到 2.修改IP地址,设置为自己本地的IP地址 3.测试库配置 4.浏览器访问地址:http://localhost:8080/sgat/login.action superuser jsecode@123

兴趣是最好的老师 640

SAP-ABAP:字符与数值类型转换详细指南

SAP-ABAP:字符与数值类型转换详细指南

baidu_35680696的博客 1489

[个人自用,全网最优]EDEM-FLUENT个人自学教程,拒绝手忙脚乱无用功!

[个人自用,全网最优]EDEM-FLUENT个人自学教程,拒绝手忙脚乱无用功!

zheaa的博客 4831

BIT-Vehicle Dataset - 车辆车型识别数据集

BIT-Vehicle Dataset - 车辆车型识别数据集 http://iitlab.bit.edu.cn/mcislab/vehicledb/ Dataset info The BIT-Vehicle dataset contains 9,850 vehicle images. There are images with sizes of 1600*1200 and 1920*1080 ...

程永强 2万+

【DRAM存储器六十七】DDR5介绍--训练相关之write leveling

详述DDR5 write leveling细节

highman110的博客 297

GAT项目新需求:保险管理修改

1.需求: 2.原表 3.现表 4.SQL语句: --删除字段 ALTER TABLE CAR_SECURE DROP COLUMN SECURE_ACC_NO ALTER TABLE CAR_SECURE DROP COLUMN SECURE_ACC_PAY ALTER TABLE CAR_SECURE DROP COLUMN SECURE_NUM

兴趣是最好的老师 1150

jdk-8u144-linux-x64.tar.gz.

该资源为搭建Linux系统Java环境用,资源的后缀为tar.gz格式的压缩包

Devexpress16.2.6破解工具

Devexpress16.2.6破解工具Devexpress16.2.6破解工具Devexpress16.2.6破解工具Devexpress16.2.6破解工具

T-SQL语句之Select(一)

Operator Description != Tests two expressions not being equal to each other. !> Tests that the left condition is not greater than the expression to the right. ...

iteye_8029的博客 301

SAP B1中文培訓教材_SDK

公司内部培训资料,对开发工具 ,DIAPI, UIAPI,Add-ON有详细解说

GAT项目新需求:保险管理增加查询统计-传日期参数问题

需求:不分页,默认合计今年的签单保费和车船费 1.CarSecureController 2.查询条件 3.接口 4.接口的实现 5.Dao接口 6.Dao实现 查询条件:generateConditionTotal private void generateConditionTotal(CarSecureListRe

兴趣是最好的老师 672

保留两位小数:数据库字段类型NUMBER,Java字段类型Double类型

1.数据库字段类型 查出的数据小数点后带两位小数 2.后台查出的json却没有两位小数 [{ recordId : 20170320142740038015948, appSysId : 23551, appDeptId : 3, orgDeptName : null, carHostNO : 1019, secureNo : 111, sec

兴趣是最好的老师 4453

sum over partition by函数的用法-但是查出来的数据格式不好给前台用,废弃

要求:按车牌号HOST_NO分组,合计CAR_PAY金额,最后合计所有金额,还要过滤出本月的时间 参考: http://blog.youkuaiyun.com/wawmg/article/details/40840093

兴趣是最好的老师 2492

解决GAT项目Bug: 用车审批中审批人登录系统后,看不到申请人提交的单子

描述:警保部下面的部门的人申请的单子,警保部的负责审批的人看不到 解决: 1.点击页面找到请求url 2.运用阿楠给我的工具,可以获取后台的url 双击testFrom0(),得到 3.找到代码 修改代码: 修改好代码: 断点打印正确的sql: 断点打印的错误的sql: select create_

兴趣是最好的老师 1311

WF公务车新需求:申请单和派车单编号修改

1.需求:申请单改成YCSQD_日期_1 2 3累加,跨年后重新从1开始累加,派车单改成申请单编号_CCD 2.找到相关代码 原申请单编号生成代码:YCSQD_20170410_1、YCSQD_20170410_2、YCSQD_20170411_1、YCSQD_20170411_2 @Override public synchronized String get

兴趣是最好的老师 1072

GAT-解决用车审批中,如果调度车辆是通过Excel导入的车辆,会有错误提示Bug

proxool.xml config.properties webgps.db.default.schema=STCS -----------------------------------------------------------------------------------------------------------------------------------

兴趣是最好的老师 1049

解决GAT项目Bug:导入Excel的时候没有对日期格式进行验证

问题描述:导入Excel的时候没有对日期格式进行验证 修改代码:增加对日期的验证 使用的代码: import java.text.DateFormat; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.Date; pub

兴趣是最好的老师 1037

GAT保险模块的修改

1.示意图 . 2.数据库的修改 drop table CAR_SECURE; -- Create table create table CAR_SECURE ( record_id VARCHAR2(32) not null, host_no VARCHAR2(32), secure_no

兴趣是最好的老师 975

惠安惠达新需求:增加起始里程和结束里程

代码:主要要传hosti和查询的时间范围

兴趣是最好的老师 964

GWC和GAT项目搭建过程

1.说明: 公安厅项目有两个模块是依赖电力项目或者公务车项目的 公务车: 公安厅: 所以,如果单独部署公安厅项目,需要去电力或者公务车中下载上面两个包 -----------------------------------------------------------------------------------------------------------

兴趣是最好的老师 923

代码:用车申请-列表查询

/*我的用车申请列表查询接口*/ @RequestMapping(value = "/apply/myList", method = RequestMethod.POST, produces = "application/json") @ResponseBody public BaseResp applyList(@RequestBody VehUseApplyInfoListReq biz

兴趣是最好的老师 898

Jsecode maven仓库地址

公司maven仓库地址:http://artifactory.jsecode.com/artifactory/libs-release/

兴趣是最好的老师 860
上一篇: 将List中的数据组成用逗号分隔的字符串,如'a','b','c'
下一篇: 惠安惠达新需求:增加起始里程和结束里程
ZHOU_VIP
博客等级 码龄11年 1万+粉丝 1779原创
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付:10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

ZHOU_VIP

您的鼓励将是我创作最大的动力!

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值