SELECT R1.* FROM ( ) R1 LIMIT #{pgtl.startNo}, #{pgtl.listPerPage} 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 is not null 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, 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 is not null and k.kescoStatus = #{kescoStatus} and p.name like concat('%', #{name}, '%') 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 p.plantType = #{plantType} and m.pcsMaker = #{pcsMaker} and m.batteryMaker = #{batteryMaker} and p.name like concat('%', #{name}, '%') select p.*, d.createDatetime, d.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 pcsPower, (m.batteryVolume * m.batteryQuantity) as batteryPower from t_plant p left join t_pms m on p.seq = m.plantSeq where m.pmsStatus = '01' and p.seq = #{seq} and p.plantStatus = #{plantStatus} and m.pmsStatus = #{pmsStatus} and p.plantType = #{plantType} and m.pcsMaker = #{pcsMaker} and m.batteryMaker = #{batteryMaker} and p.name like concat('%', #{name}, '%') ) 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.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 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}, updateDatetime = now() where seq = #{seq} insert into t_plant ( name, plantType, plantStatus, beginDate, omStartDate, omEndDate, supplyPower, address, weatherCode, geox, geoy, weatherx, weathery, memo, createDateTime, updateDatetime ) values ( #{name}, #{plantType}, #{plantStatus}, #{beginDate}, #{omStartDate}, #{omEndDate}, #{supplyPower}, #{address}, #{weatherCode}, #{geox}, #{geoy}, #{weatherx}, #{weathery}, #{memo}, now(), now() )