FORUM.M.NU

Kod: Markera allt

       <Source Name="Actual electricity consumption" ChartType="SplineArea">
        <SourceAppearance Color="120,0,0,238" BorderWidth="1" /> 

          <Legend>Nuvarande %LASTVALUE('Actual electricity consumption') Watt</Legend>

<Query>
	<DatabaseTable Name="varmvatten">
		<TableDefinition>
			<Column Name="Hour" Type="DateTime"/>
			<Column Name="kWhDiff" Type="Double"/>
		</TableDefinition>
	</DatabaseTable>
	<Statement>
		<Custom>
		<![CDATA[					
			SELECT
				energy.timegroup as "Hour",
				round( sum( energy.countdiff ) ) as "kWhDiff"
			FROM
			(
				SELECT
					(i.counter_C - c.counter_C)*(3600/TIMESTAMPDIFF(SECOND,c.timestamp,i.timestamp))  as "countdiff",
					c.counter_C as "startcounter",
					date_format( c.timestamp,'%Y-%m-%d %T' ) as "timegroup"
				FROM varmvatten c
				join (select * FROM varmvatten) i on c.index=i.index-1 and c.timestamp between timestampadd( hour, -24, Now() ) and Now()
				) energy,
				(
					SELECT min(s.counter_C) as "countstart"
					FROM varmvatten s
					join (select * FROM varmvatten) t on s.index=t.index and s.timestamp between timestampadd(hour,-24, Now()) and Now()
				) input
				group by energy.timegroup				
		]]>				
		</Custom>
	</Statement>
	<ValueMapping>
		<X SourceColumn="Hour" />
		<Y SourceColumn="kWhDiff" />
	</ValueMapping>
</Query>

</Source>



        <Source Name="Accumulated electricity consumption" ChartType="Spline" YAxisType="Secondary">
          <SourceAppearance Color="255,238,0,0" BorderWidth="3" /> 
          <Legend>Ackumulerade %LASTVALUE('Accumulated electricity consumption') KWh</Legend>

<Query>
	<DatabaseTable Name="varmvatten">
		<TableDefinition>
			<Column Name="Hour" Type="DateTime"/>
			<Column Name="kWhSum" Type="Double"/>
		</TableDefinition>
	</DatabaseTable>
        <Statement>
		<Custom>
		<![CDATA[					
		SELECT
			energy.timegroup as "Hour",
			round( ( ( sum( energy.countdiff ) ) + ( energy.startcounter - input.countstart ) ) / 1000, 1 ) as "kWhSum"
  
			FROM
			(
				SELECT
					i.counter_C - c.counter_C as "countdiff",
					c.counter_C as "startcounter",
					date_format( c.timestamp,'%Y-%m-%d %T' ) as "timegroup"
				FROM varmvatten c
					join (select * FROM varmvatten) i on c.index=i.index-1 and c.timestamp between timestampadd(hour, -24, Now() ) and Now()
				) energy,
				(
				SELECT
					min(s.counter_C) as "countstart"
				FROM
					varmvatten s
					join (select * FROM varmvatten ) t on s.index=t.index and s.timestamp between timestampadd(hour,-24, Now()) and Now()
					) input
					group by energy.timegroup				
		]]>				
		</Custom>
	</Statement>
        <ValueMapping>
        	<X SourceColumn="Hour" />
		<Y SourceColumn="kWhSum" />
	</ValueMapping>
</Query>
</Source>

Kod: Markera allt

root@TemperaturMonitor:/mnt/scripts# nano power_calc.sh

LAST_COUNTER2=`echo $SECOND_LAST|sed -e s/,/" "/g|awk '$0=$3'`
TS1=`echo $LAST|sed -e s/,/" "/g|awk '$0=$4'`
TS2=`echo $SECOND_LAST|sed -e s/,/" "/g|awk '$0=$4'`
echo "SL: $SECOND_LAST LC: $LAST_COUNTER - LC2_ $LAST_COUNTER2"
COUNT_DIFF=`expr $LAST_COUNTER - $LAST_COUNTER2`
echo "COUNT_DIFF=$COUNT_DIFF"
TIME_DIFF=`expr $TS1 - $TS2`
echo "TIME_DIFF = $TIME_DIFF"
CURR_POWER=`echo "$COUNT_DIFF $TIME_DIFF $ENERGI_PULSE"|awk '{$1=$1 / $2 * 1000 / $3 * 3600; printf "%.0f", $1}'`
echo "Nuvarande effektuttag är: $CURR_POWER W"

echo "MATARSTALLNING=$MATARSTALLNING" > /tmp/power.txt
echo "NUVARANDE_EFFEKT=$CURR_POWER" >> /tmp/power.txt