and p.seq in ( ${plantSeqs} )
t_weather_2021
insert into t_ivtdata_${realtimeYear} (
oseq, plantSeq, ivtIdx, acPower, acFreq, apparentPower, reactivePower, dcCurr, dcVolt, dcPower, temp, powerFactor, todayEnergy, lifetimeEnergy, ivtStatus, createDatetime
) values (
#{oseq},
#{plantSeq},
#{ivtIdx},
#{acPower},
#{acFreq},
#{apparentPower},
#{reactivePower},
#{dcCurr},
#{dcVolt},
#{dcPower},
#{temp},
#{powerFactor},
#{todayEnergy},
#{lifetimeEnergy},
#{ivtStatus},
now()
)
insert into t_ivtoverview (
plantSeq, inputDate, inputHour, inputMinute, currPower, todayEnergy, todayHours, lifetimeEnergy, ovStatus, createDatetime
) values (
#{plantSeq},
#{inputDate},
#{inputHour},
#{inputMinute},
#{currPower},
#{todayEnergy},
#{todayHours},
#{lifetimeEnergy},
#{ovStatus},
now()
)
insert into t_weather_sensor (
inputDate, plantSeq, oseq, temp1, temp2, solarRadiation1, solarRadiation2, windSpeed, windDirection, createDatetime
) values (
#{inputDate},
#{plantSeq},
#{oseq},
#{temp1},
#{temp2},
#{solarRadiation1},
#{solarRadiation2},
#{windSpeed},
#{windDirection},
now()
)
update t_ivtjunc set
url1 = #{url1},
url2 = #{url2},
port = #{port},
ivtStatus = #{ivtStatus},
ivtMaker = #{ivtMaker},
ivtQuantity = #{ivtQuantity},
link = #{link},
key1 = #{key1},
key2 = #{key2},
ivtType = #{ivtType},
syncType = #{syncType},
updateId = #{updateId},
updateDatetime = now()
where plantSeq = #{plantSeq}
insert into t_ivtjunc (
plantSeq, url1, url2, port, ivtStatus, ivtMaker, ivtQuantity, link, key1, key2, ivtType, syncType, updateId, updateDatetime, createDateTime
) values (
#{plantSeq},
#{url1},
#{url2},
#{port},
#{ivtStatus},
#{ivtMaker},
#{ivtQuantity},
#{link},
#{key1},
#{key2},
#{ivtType},
#{syncType},
#{updateId},
now(),
now()
)
delete from t_ivtjunc where plantSeq = #{plantSeq}
update t_ivtinfo set
ivtMaker = #{ivtMaker},
ivtModel = #{ivtModel},
ivtVolume = #{ivtVolume},
serialNumber = #{serialNumber},
ivtMemo = #{ivtMemo}
where plantSeq = #{plantSeq} and ivtIdx = #{ivtIdx}
insert into t_ivtinfo (
plantSeq, ivtIdx, ivtMaker, ivtModel, ivtVolume, serialNumber, ivtMemo
) values (
#{plantSeq},
#{ivtIdx},
#{ivtMaker},
#{ivtModel},
#{ivtVolume},
#{serialNumber},
#{ivtMemo}
)
delete from t_ivtinfo where plantSeq = #{plantSeq} and ivtIdx = #{ivtIdx}
insert into t_ivterror (
plantSeq, ivtIdx, inputDate, inputHour, inputMinute, warn1, warn2, fault1, fault2, fault3, fault4, fault5, msg, memo, createDatetime
) values (
#{plantSeq},
#{ivtIdx},
#{inputDate},
#{inputHour},
#{inputMinute},
#{warn1},
#{warn2},
#{fault1},
#{fault2},
#{fault3},
#{fault4},
#{fault5},
#{msg},
#{memo},
now()
)
update t_ivtoverview_hour set todayEnergy=#{todayEnergy} todayHours=#{todayHours} where plantSeq = #{plantSeq} and inputDate=#{inputDate} and inputHour=#{inputHour}
update t_ivtoverview_day set todayEnergy=#{todayEnergy} todayHours=#{todayHours} where plantSeq = #{plantSeq} and inputDate=#{inputDate}
update t_ivtoverview_month set monthEnergy=#{todayEnergy} monthHours=#{todayHours} where plantSeq = #{plantSeq} and inputYear=#{inputYear} and inputMonth=#{inputMonth}