Domoticz

Code: Select all

pi@domoticz-pi:~ $ sudo apt update
Get:1 http://repo.mysql.com/apt/debian stretch InRelease [19.2 kB]
Hit:3 http://raspbian.raspberrypi.org/raspbian stretch InRelease
Hit:4 http://archive.raspberrypi.org/debian stretch InRelease
Err:1 http://repo.mysql.com/apt/debian stretch InRelease
  The following signatures were invalid: EXPKEYSIG 8C718D3B5072E1F5 MySQL Release Engineering <[email protected]>
Get:2 https://dl.ubnt.com/unifi/debian stable InRelease [3,024 B]
Reading package lists... Done
W: GPG error: http://repo.mysql.com/apt/debian stretch InRelease: The following signatures were invalid: EXPKEYSIG 8C718D3B5072E1F5 MySQL Release Engineering <[email protected]>
E: The repository 'http://repo.mysql.com/apt/debian stretch InRelease' is not signed.
N: Updating from such a repository can't be done securely, and is therefore disabled by default.
N: See apt-secure(8) manpage for repository creation and user configuration details.

Code: Select all

pi@domoticz-pi:~ $ mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 13
Server version: 10.1.37-MariaDB-0+deb9u1 Raspbian 9.0

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>

Code: Select all

pi@domoticz-pi:~ $ mysql -u root -p
Enter password:
ERROR 1698 (28000): Access denied for user 'root'@'localhost'

Code: Select all

mysql -u domotica -p domotica < 'Create-Update SQL Database.txt'

Code: Select all

mysql -u root -p

Code: Select all

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| domotica           |
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
4 rows in set (0.00 sec)

Code: Select all

function rgb($name,$hue,$level,$check=false)
{
    global $user,$d,$domoticzurl;
    lg(' (RGB) | '.$user.' =>	'.$name.'	'.$level);
    if ($d[$name]['i']>0) {
        if ($check==false) {
            file_get_contents($domoticzurl.'/json.htm?type=command&param=setcolbrightnessvalue&idx='.$d[$name]['i'].'&hue='.$hue.'&brightness='.$level.'&iswhite=false');
        } else {
            if ($d[$name]['s']!=$$level) {
                file_get_contents($domoticzurl.'/json.htm?type=command&param=setcolbrightnessvalue&idx='.$d[$name]['i'].'&hue='.$hue.'&brightness='.$level.'&iswhite=false');
            }
        }
    } else {
        store($name, $level);
    }
}

Code: Select all

function status($name)
{
    global $d;
//    lg('Status requested for: '.$name.' with status: '.$d[$name]['s']);
    $status = $d[$name]['s'];
    if ($status === '100') return 'On';
    elseif ($status === '0') return 'Off';
    elseif (empty($status)) return 'Empty';             // Sometimes no status.... strange..
    else return $d[$name]['s'];
}

Code: Select all

function yeelight($name,$command,$info='')
{    //Available commands: nightlight, fulllight, warmer, cooler, brightnessup, brightnessdown
    $idx=idx($name);
    if($idx>0)
    {
    	$comment='(Pass2PHP Yeelight | '.$name.' => '.$command.' => '.$info;			
	lg($comment);
        sl($name,100); // Switch light on first. Ater that apply the mood command.
        curl(domoticz.'json.htm?type=command&param='.$command.'&idx='.$idx);
    }
}

Code: Select all

yeelight('Lamp LED Study Left',100,'Nightlight');

Code: Select all

yeelight('Lamp LED Study Left','nightlight','Nightlight');

Code: Select all

2019-04-16 14:26:09.537 Status: --->> Starting with: Lamp LED Study Left Received status is: Set Level !

Code: Select all

function cset($key,$value){
    global $d;

	if(cache=='apcu'){
		apcu_store($key,$value);
	}elseif(cache=='apc'){
		apc_store($key,$value);
	}elseif(cache=='memcached'){
		if(!$m=xsMemcached::Connect('127.0.0.1',11211)){return;}$m->Set($key,$value);
	}elseif(cache=='mysql'){
        storemode($key, $value,true);
    }
}

function cget($key){
    global $d;

	if(cache=='apcu'){
		return apcu_fetch($key);
	}elseif(cache=='apc'){
		return apc_fetch($key);
	}elseif(cache=='memcached'){
		if(!$m=xsMemcached::Connect('127.0.0.1',11211)){return 0;}return $m->Get($key);
	}elseif(cache=='mysql'){
        return $d[$key]['m'];
    }
}

Code: Select all

if(in_array($device,array('Lamp (Kastenkamer) (RF)','Lamp (CV Ruimte) (RF)','Lamp (Keukentafel)','Lamp (Keukentafel) (RF)','Lamp (Bank)','Lamp (Bank) (RF)',
							  'Lamp LED TV','Lamp LED Vensterbank','Lamp LED Tafel (Woonkamer)','Lamp LED Trap','Lamp LED Hal','Lamp LED Keukenkast',
							  'Xiaomi RGB Gateway','Xiaomi RGB Gateway (Keuken)','Lamp LED Study Left','Lamp LED Study Right','Lamp (Kastenkamer) (RF)' ))) {
		if($status=='Off'){
			store($device, 0);												// 14-04-2019 Pass2PHP 3.0 If one of the above items (dimmers is updated store different values)
		}elseif($status=='On'){
			store($device, 100);											// 14-04-2019 Pass2PHP 3.0 If one of the above items (dimmers is updated store different values)
		}elseif( $status==='Set Level' || $status==='Set Color' || empty($status) ) {
		 	store($device, nvalue($device,'Level'));						// 14-04-2019 Pass2PHP 3.0 If one of the above items (dimmers is updated store different values)
		}else{
			$status=filter_var($status,FILTER_SANITIZE_NUMBER_INT);
			store($device,$status);											// 14-04-2019 Pass2PHP 3.0 If one of the above items (dimmers is updated store different values, dimmer value)
		}
	}
	else {
			store($device,$status);											// 14-04-2019 Pass2PHP 3.0 If not one of the above items (dimmers is updated store different values)
		}

	//lgsql('Domoticz',$device,$status);
	@include rootdir.'pass2php/'.$device.'.php';
	//lg('Pass2php: Called '.$device.' = Received "'.$status.'" status');
}

Code: Select all

function nvalue($name,$nvalue)				// Added: 06-11-2018
{
    $idx=idx($name);
    $json_string=curl(domoticz.'json.htm?type=devices&rid='.$idx);          // retrieve current level
    $parsed_json = json_decode($json_string, true);
    $parsed_json = $parsed_json['result'][0];

    if(array_key_exists($nvalue, $parsed_json)) {    
    $value=$parsed_json[$nvalue];
    }
    else $value='NA';
    return $value;    
}