Papi-Online.de

Code: Alles auswählen

# For more options and information see
# http://www.raspberrypi.org/documentation/configuration/config-txt.md
# Some settings may impact device functionality. See link above for details

# uncomment if you get no picture on HDMI for a default "safe" mode
#hdmi_safe=1

# uncomment this if your display has a black border of unused pixels visible
# and your display can output without overscan
disable_overscan=1

# uncomment the following to adjust overscan. Use positive numbers if console
# goes off screen, and negative if there is too much border
#overscan_left=36
#overscan_right=36
#overscan_top=36
#overscan_bottom=36

# uncomment to force a console size. By default it will be display's size minus
# overscan.
#framebuffer_width=800
#framebuffer_height=480

# uncomment if hdmi display is not detected and composite is being output
#hdmi_force_hotplug=1

# uncomment to force a specific HDMI mode (this will force VGA)
hdmi_group=2
hdmi_mode=1
hdmi_mode=87
hdmi_cvt 800 480 60 6 0 0 0

# uncomment to force a HDMI mode rather than DVI. This can make audio work in
# DMT (computer monitor) modes
#hdmi_drive=2

# uncomment to increase signal to HDMI, if you have interference, blanking, or
# no display
#config_hdmi_boost=4

# uncomment for composite PAL
#sdtv_mode=2

#uncomment to overclock the arm. 700 MHz is the default.
#arm_freq=800

# Uncomment some or all of these to enable the optional hardware interfaces
#dtparam=i2c_arm=on
#dtparam=i2s=on
#dtparam=spi=on

# Uncomment this to enable the lirc-rpi module
#dtoverlay=lirc-rpi

# Additional overlays and parameters are documented /boot/overlays/README

# Enable audio (loads snd_bcm2835)
dtparam=audio=on

Code: Alles auswählen

#!/usr/bin/env python

import subprocess
import smtplib
import socket

from email.mime.text import MIMEText

import time
import MySQLdb as mdb
import sys

import RPi.GPIO as GPIO, time, os

from sys import stdout 

from datetime import datetime

GPIO.setmode(GPIO.BCM)
GPIO.setwarnings(False)
GPIO.setup(2, GPIO.IN)

gread = 0
dread = 0
hcount = 0
load = 0 
lch = 0
imp = 0
lcheck = 0
first = 1


now = datetime.now()
last = now
lastlast = last
delta = now - last

pstart = 1

Empf = 'mail'
Abs = 'mail'
Passw = 'passwort'
smtpserv = smtplib.SMTP_SSL('server,com',465)
smtpserv.ehlo()

# In Account einloggen
smtpserv.login(Abs, Passw)

Wtxt = 'Ladestation neu gestartet'
cmsg = MIMEText(Wtxt)
cmsg['Subject'] = 'Ladestation neu gestartet'

cmsg['From'] = 'Ladestation'
cmsg['To'] = Empf

smtpserv.sendmail(Abs, [Empf], cmsg.as_string())
smtpserv.quit()

def RCtime (channel):
#	print(time.strftime("Imp: %d.%m.%Y %H:%M:%S"))  #Zum Debuggen
	global first
	global last
	global lcheck
	global gread
	global dread
	global hcount
	global imp
	imp = 1
	now = datetime.now()
	delta = now - last
	lastlast = last
	last = now
	delta = last - lastlast
	if delta.seconds > 120:		# Neuer Ladevorgang ab 120 sec. Pause 
	    first = 1
	    hcount = 0
	    gread = 0
	    dread = 0
	if delta.seconds < 40:
	    if lcheck == 1:
		first = 0
		hcount += 1
		if hcount > 100:
		    hcount = 1
		gread += 0.00250	# 0.00250 entspricht 400 Impulsen pro kW. 0.00125=800 Imps/kW  Je nachdem was euer Zähler so macht.
		dread += 0.00250
    		writedb(gread,hcount)
	    else:
		setload()
		lcheck = 1
		writerem(1)
		if first == 1:
		    writedb(gread,hcount)
		    postit(1, 0)
		first = 0

def setload ():
    con = None
    try:
        con = mdb.connect('localhost', 'emob', 'DB-Passwort', 'emob');
        cur = con.cursor()
	cur.execute("UPDATE emob.settings SET loading='1'")
    	con.commit()
    except mdb.Error, e:
        print "Error %d: %s" % (e.args[0],e.args[1])
        sys.exit(1)
    finally:        
        if con:    
            con.close()

def unsetload ():
    con = None
    try:
        con = mdb.connect('localhost', 'emob', 'DB-Passwort', 'emob');
        cur = con.cursor()
	cur.execute("UPDATE emob.settings SET loading='0'")
    	con.commit()
    except mdb.Error, e:
        print "Error %d: %s" % (e.args[0],e.args[1])
        sys.exit(1)
    finally:        
        if con:    
            con.close()

def writedb (akw,fcount):
    loading = 0
    con = None
    try:
        con = mdb.connect('localhost', 'emob', 'DB-Passwort', 'DB-Name');
        cur = con.cursor()
	cur.execute("SELECT loading FROM emob.settings")
	ldata = cur.fetchone()
	loading = ldata[0]
	if loading == 1:
	    cur.execute("SELECT total FROM emob.countings")
	    data = cur.fetchone()
	    tkw = data[0]
	    if fcount == 100:    
		tkw += 1
	    sql = "UPDATE emob.countings SET actual=%s, total=%s"
	    cur.execute(sql, (akw,tkw))
    	con.commit()
    except mdb.Error, e:
        print "Error %d: %s" % (e.args[0],e.args[1])
        sys.exit(1)
    finally:        
        if con:    
            con.close()
    return loading

def writerem (rload):
    con = None
    try:
        con = mdb.connect('DB-Remotedomain', 'DB-Benutzer', 'DB-Passwort', 'DB-Name');
        cur = con.cursor()
	sql = "UPDATE DB-Benutzer.station SET loading=%s"
	cur.execute(sql, (rload))
    	con.commit()
    except mdb.Error, e:
        print "Error %d: %s" % (e.args[0],e.args[1])
        sys.exit(1)
    finally:        
        if con:    
            con.close()

def postit(pload, pkw):
    Empfaenger = 'mail'
    Absender = 'mail'
    Passwort = 'passwort'
    smtpserver = smtplib.SMTP_SSL('server,com',465)
    smtpserver.ehlo()

    # In Account einloggen
    smtpserver.login(Absender, Passwort)

    # Text
    if pload == 1:
	Wert = 'Ladevorgang gestartet'
    if pload == 0:
	Wert = 'Ladevorgang beendet: %s kW' % pkw
    msg = MIMEText(Wert)

    # Betreff + Datum
    msg['Subject'] = 'Nachricht von der Ladestation'

    # Absender
    msg['From'] = 'Ladestation'

    #Empfaenger
    msg['To'] = Empfaenger

    # E-Mail abschicken
    smtpserver.sendmail(Absender, [Empfaenger], msg.as_string())
    smtpserver.quit()

unsetload()
writedb(0,0)

GPIO.add_event_detect(2, GPIO.RISING, callback = RCtime, bouncetime = 200)

try:
    while True:
	imp = 0
	time.sleep(60)	# Muss immer groesser sein als delta.seconds
	if imp == 0 and lcheck == 1:
		unsetload()
		lcheck = 0
		writerem(0)
		if dread > 0.3:
		    postit(0, gread)
		dread = 0

except KeyboardInterrupt:
    GPIO.remove_event_detect(2)

Code: Alles auswählen

#!/usr/bin/env python

import time
import subprocess
import MySQLdb as mdb

from datetime import datetime

try:
        while True:
                con = mdb.connect('localhost', 'emob', 'DB_Passwort', 'emob');
                cur = con.cursor()
                cur.execute("SELECT loading FROM emob.settings")
                ldata = cur.fetchone ()
                if ldata == (1L,):
                        subprocess.call( "vcgencmd display_power 1", shell=True )
                        time.sleep(600)
                else:
                        time.sleep(5)
                        subprocess.call( "vcgencmd display_power 0", shell=True )

        else:
                time.sleep(5)

except mdb.Error, e:
        print "Error %d: %s" % (e.args[0],e.args[1])
        sys.exit(1)
finally:
        if con:
                con.close()

Code: Alles auswählen

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

-- Exportiere Datenbank Struktur für emob
CREATE DATABASE IF NOT EXISTS `emob` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `emob`;


-- Exportiere Struktur von Tabelle emob.countings
CREATE TABLE IF NOT EXISTS `countings` (
  `actual` float DEFAULT NULL,
  `total` int(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Exportiere Daten aus Tabelle emob.countings: ~1 rows (ungefähr)
/*!40000 ALTER TABLE `countings` DISABLE KEYS */;
REPLACE INTO `countings` (`actual`, `total`) VALUES
	(3.55, 141);
/*!40000 ALTER TABLE `countings` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle emob.settings
CREATE TABLE IF NOT EXISTS `settings` (
  `price` float NOT NULL,
  `loading` int(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Exportiere Daten aus Tabelle emob.settings: ~1 rows (ungefähr)
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
REPLACE INTO `settings` (`price`, `loading`) VALUES
	(0.2742, 1);
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

Code: Alles auswählen

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

-- Exportiere Datenbank Struktur für ips
CREATE DATABASE IF NOT EXISTS `ips` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `ips`;

-- Exportiere Struktur von Tabelle ips.station
CREATE TABLE IF NOT EXISTS `station` (
  `loading` int(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Exportiere Daten aus Tabelle ips.station: ~0 rows (ungefähr)
/*!40000 ALTER TABLE `station` DISABLE KEYS */;
REPLACE INTO `station` (`loading`) VALUES
	(1);
/*!40000 ALTER TABLE `station` ENABLE KEYS */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

Code: Alles auswählen

#!/bin/sh
xset -dpms # disable DPMS (Energy Star) features.
xset s off # disable screen saver
xset s noblank # don't blank the video device
unclutter &
matchbox-window-manager &
midori -e Fullscreen -a http://localhost/index.php

Code: Alles auswählen

# By default this script does nothing.

# Print the IP address
_IP=$(hostname -I) || true
if [ "$_IP" ]; then
  printf "My IP address is %s\n" "$_IP"
fi

sudo xinit /home/pi/startMidori.sh &
(/bin/sleep 10 && /usr/local/bin/emob/impsim.py) &
(/bin/sleep 15 && /usr/local/bin/emob/screen.py) &

exit 0

Code: Alles auswählen

<?php
$loading = 0;
$link = mysql_connect('localhost', 'db_user', 'db_pass');
if (!$link) {die('Could not connect: ' . mysql_error());}
mysql_select_db('ips', $link);

$result = mysql_query("SELECT * FROM station", $link);

if (!$result) {
    die('Invalid query: ' . mysql_error());
}

while ($row=mysql_fetch_array($result)){
    $loading = $row['loading'];
}

?>

Code: Alles auswählen

<?php
if ($loading == 1) {
    echo '<div style="padding-top:33px; font-face:Arial; font-size:20px;font-weight:bold; color:green;">Station charging</div>';
    } else {
    echo '<div style="padding-top:33px; font-face:Arial; font-size:20px;font-weight:bold; color:green;">Station available</div>';
    }
?>