SELECT R1.* FROM ( ) R1 LIMIT #{pgtl.startNo}, #{pgtl.listPerPage} and p.seq in ( ${plantSeqs} ) select count(p.seq) as count from t_plant p where 1=1 and p.seq = #{seq} and p.plantStatus = #{plantStatus} and p.plantType = #{plantType} and p.name like concat('%', #{name}, '%') select p.* from t_plant p where 1=1 and p.seq = #{seq} and p.plantStatus = #{plantStatus} and p.plantType = #{plantType} and p.name like concat('%', #{name}, '%') order by p.seq desc select count(plantSeq) count from ( select p.seq as plantSeq, p.name, p.plantType, p.plantStatus, p.supplyPower, p.beginDate, p.omStartDate, p.omEndDate, p.createDatetime, k.customerId, k.aesKey, k.kescoStatus, k.protoVer, k.kepcoId, k.rpsId, k.specialStatus, (select count(d.seq) from t_kesco_data d where d.plantSeq = p.seq and d.inputDate = #{inputDate} and d.inputHour = #{inputHour} ) as count, (select count(d.seq) from t_kesco_data d where d.plantSeq = p.seq and d.inputDate = #{inputDate} and d.sendStatus='01' and d.inputHour = #{inputHour} ) as successCount, (select max(d.createDatetime) from t_kesco_data d where d.plantSeq = p.seq and d.inputDate = #{inputDate} and d.inputHour = #{inputHour} ) as kescodataDatetime from t_plant p left join t_kesco k on p.seq = k.plantSeq where 1=1 and p.seq = #{plantSeq} and p.plantStatus = #{plantStatus} and k.kescoStatus = #{kescoStatus} and p.name like concat('%', #{name}, '%') order by p.seq desc ) d where d.successCount < #{successCount} select * from ( select p.seq as plantSeq, p.name, p.plantType, p.plantStatus, p.supplyPower, p.beginDate, p.omStartDate, p.omEndDate, k.customerId, k.aesKey, k.kescoStatus, k.protoVer, k.kepcoId, k.rpsId, k.specialStatus, k.updateDatetime, k.createDatetime, (select count(d.seq) from t_kesco_data d where d.plantSeq = p.seq and d.inputDate = #{inputDate} and d.inputHour = #{inputHour} ) as count, (select count(d.seq) from t_kesco_data d where d.plantSeq = p.seq and d.inputDate = #{inputDate} and d.sendStatus='01' and d.inputHour = #{inputHour} ) as successCount, (select max(d.createDatetime) from t_kesco_data d where d.plantSeq = p.seq and d.inputDate = #{inputDate} and d.inputHour = #{inputHour} ) as kescodataDatetime from t_plant p left join t_kesco k on p.seq = k.plantSeq where 1=1 and p.seq = #{plantSeq} and p.plantStatus = #{plantStatus} and k.kescoStatus = #{kescoStatus} and p.name like concat('%', #{name}, '%') order by p.beginDate desc, p.seq desc order by p.seq desc ) d where d.successCount < #{successCount} select * from t_kesco_data k where inputDate = #{inputDate} and plantSeq = #{plantSeq} order by inputHour desc select k.*, d.seq as pmsdataSeq, d.pcsIdx, d.inputDate, d.inputHour, d.chargePower, d.dischargePower, d.pvPower, d.data1, d.data2, d.data3, d.data4, d.data5, d.data6, d.data7, d.data8, d.data9, d.data10, d.data11, d.data12, d.data13, d.data14, d.data15, d.data16, d.data17, d.data18, d.data19, d.data20, d.data21, d.data22, d.data23, d.data24, d.data25, d.data26, d.data27, d.data28, d.data29, d.data30, d.data31, d.data32, d.data33, d.data51, d.data52, d.data53, d.data54, d.data55, d.data56, d.data57, d.data58, d.data59, d.data60, d.data61, d.data62, d.data63, d.data64, d.data65, d.data66, d.data67, d.data68, d.data69, d.data70 from ( select k.*, p.pcsMaker, p.batteryMaker from t_kesco_data k, t_pms p where k.inputDate=#{inputDate} and k.plantSeq = p.plantSeq ) k left join t_pmsdata_statistic_hour d on k.plantSeq = d.plantSeq and k.pmsdataSeq = d.seq and d.pcsIdx=0 and d.inputDate=#{inputDate} where k.inputDate = #{inputDate} and k.plantSeq = #{plantSeq} order by d.inputDate desc, d.inputHour desc, k.createDatetime desc select count(p.seq) as count from t_plant p left join t_pms m on p.seq = m.plantSeq where 1=1 and p.seq = #{seq} and p.plantStatus = #{plantStatus} and m.pmsStatus = #{pmsStatus} and m.pmsModel = #{pmsModel} and p.plantType = #{plantType} and m.pcsMaker = #{pcsMaker} and m.batteryMaker = #{batteryMaker} and m.batteryModel = #{batteryModel} and p.name like concat('%', #{name}, '%') and p.clientOrderSeq = #{clientOrderSeq} select p.*, d.createDatetime as pmsdataDatetime, d.count as count, d.timetableSeq from ( select p.*, m.plantSeq, m.ip, m.port, m.pmsStatus, m.startIdx, m.pmsMaker, m.pmsModel, m.pcsMaker, m.pcsVolume, m.pcsQuantity, m.batteryMaker, m.batteryModel, m.batteryVolume, m.batteryQuantity, (m.pcsVolume * m.pcsQuantity) as supplyPcsPower, (m.batteryVolume * m.batteryQuantity) as supplyBatteryPower, ( select name from t_code where groupType='pcs_maker' and code=m.pcsMaker ) as pcsMakerName, ( select name from t_code where groupType='battery_maker' and code=m.batteryMaker ) as batteryMakerName, m.msgGroupPcs, m.msgGroupBattery from t_plant p left join t_pms m on p.seq = m.plantSeq where 1=1 and p.seq = #{seq} and p.plantStatus = #{plantStatus} and m.pmsStatus = #{pmsStatus} and m.pmsModel = #{pmsModel} and p.plantType = #{plantType} and m.pcsMaker = #{pcsMaker} and m.batteryMaker = #{batteryMaker} and m.batteryModel = #{batteryModel} and p.name like concat('%', #{name}, '%') and p.clientOrderSeq = #{clientOrderSeq} ) p left join ( select plantSeq, d.inputDate, d.pcsIdx, max(d.createDatetime) as createDatetime , count(d.seq) as count, max(timetableSeq) as timetableSeq from t_pmsdata_${realtimeYear} d where d.inputDate = #{inputDate} and d.pcsIdx = 0 group by plantSeq ) d on p.plantSeq = d.plantSeq and d.inputDate = #{inputDate} and d.pcsIdx = 0 order by p.beginDate desc, p.seq desc order by p.supplyPower desc, p.seq desc order by p.supplyPcsPower desc, p.seq desc order by p.pcsQuantity desc, p.seq desc order by p.seq desc select p.*, w.* from ( select p.*, d.createDatetime as pmsdataDatetime, d.count as count, d.timetableSeq from ( select p.*, m.plantSeq, m.ip, m.port, m.pmsStatus, m.startIdx, m.pmsMaker, m.pmsModel, m.pcsMaker, m.pcsVolume, m.pcsQuantity, m.batteryMaker, m.batteryModel, m.batteryVolume, m.batteryQuantity, (m.pcsVolume * m.pcsQuantity) as supplyPcsPower, (m.batteryVolume * m.batteryQuantity) as supplyBatteryPower, ( select name from t_code where groupType='pcs_maker' and code=m.pcsMaker ) as pcsMakerName, ( select name from t_code where groupType='battery_maker' and code=m.batteryMaker ) as batteryMakerName, m.msgGroupPcs, m.msgGroupBattery from t_plant p left join t_pms m on p.seq = m.plantSeq where 1=1 and p.seq = #{seq} and p.plantStatus = #{plantStatus} and m.pmsStatus = #{pmsStatus} and m.pmsModel = #{pmsModel} and p.plantType = #{plantType} and m.pcsMaker = #{pcsMaker} and m.batteryMaker = #{batteryMaker} and m.batteryModel = #{batteryModel} and p.name like concat('%', #{name}, '%') and p.clientOrderSeq = #{clientOrderSeq} ) p left join ( select plantSeq, d.inputDate, d.pcsIdx, max(d.createDatetime) as createDatetime , count(d.seq) as count, max(timetableSeq) as timetableSeq from t_pmsdata_${realtimeYear} d where d.inputDate = #{inputDate} and d.pcsIdx = 0 group by plantSeq ) d on p.plantSeq = d.plantSeq and d.inputDate = #{inputDate} and d.pcsIdx = 0 ) p left join t_weather_${realtimeYear} w on p.weatherCode = w.weatherCode and w.inputYmd= #{inputDate} and w.inputHour = (select max(inputHour) from t_weather_${realtimeYear} where inputYmd=#{inputDate}) order by p.beginDate desc, p.seq desc order by p.supplyPower desc, p.seq desc order by p.supplyPcsPower desc, p.seq desc order by p.pcsQuantity desc, p.seq desc order by p.seq desc select k.plantSeq, p.name as plantName, k.inputDate, count(k.seq) as count, sum(k.succCount) as succCount from ( select t1.*, CASE WHEN sendStatus='01' THEN '1' ELSE '0' END AS succCount from t_kesco_data t1 where inputDate like concat(#{inputDate}, '-__') and t1.plantSeq = #{plantSeq} ) k, t_plant p where k.plantSeq = p.seq group by k.plantSeq, k.inputDate order by k.plantSeq, k.inputDate select p.*, p.seq as plantSeq from t_plant p where p.plantType in ('02', '03') and p.seq = #{seq} and p.plantStatus = #{plantStatus} and p.name like concat('%', #{name}, '%') and p.clientOrderSeq = #{clientOrderSeq} order by p.seq desc update t_plant set name = #{name}, plantType = #{plantType}, plantStatus = #{plantStatus}, beginDate = #{beginDate}, omStartDate = #{omStartDate}, omEndDate = #{omEndDate}, supplyPower = #{supplyPower}, address = #{address}, weatherCode = #{weatherCode}, geox = #{geox}, geoy = #{geoy}, weatherx = #{weatherx}, weathery = #{weathery}, memo = #{memo}, clientOrderSeq = #{clientOrderSeq}, ownerName = #{ownerName}, ownerTel = #{ownerTel}, safetyName = #{safetyName}, safetyTel = #{safetyTel}, prate = #{prate}, drate = #{drate}, updateId = #{updateId}, updateDatetime = now() where seq = #{seq} insert into t_plant ( name, plantType, plantStatus, beginDate, omStartDate, omEndDate, supplyPower, address, weatherCode, geox, geoy, weatherx, weathery, memo, clientOrderSeq, ownerName, ownerTel, safetyName, safetyTel, createDateTime, updateDatetime ) values ( #{name}, #{plantType}, #{plantStatus}, #{beginDate}, #{omStartDate}, #{omEndDate}, #{supplyPower}, #{address}, #{weatherCode}, #{geox}, #{geoy}, #{weatherx}, #{weathery}, #{memo}, #{clientOrderSeq}, #{ownerName}, #{ownerTel}, #{safetyName}, #{safetyTel}, now(), now() ) select d.*, (select name from t_code where groupType ='device_etc' and code = d.typeCode) as typeName, c.name as modelName from t_device d, t_code c where d.plantSeq = #{plantSeq} and c.groupType = concat("device_", d.typeCode) and modelCode = c.code