forked from VovaGurovskiy/EnergoRemote
-
Notifications
You must be signed in to change notification settings - Fork 0
/
getgroup.php
102 lines (94 loc) · 2.91 KB
/
getgroup.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
<?
include("bd.php");
$login = trim(htmlspecialchars(stripslashes($_GET['log'])));
$pass = trim(htmlspecialchars(stripslashes($_GET['pass'])));
$typedata = trim(htmlspecialchars(stripslashes($_GET['typedata'])));
$id_group = trim(htmlspecialchars(stripslashes($_GET['id_group'])));
if (($login!='') and ($pass!='') and ($typedata!=''))
{
include("support.php");
$id_user_group = loginform($login,$pass);
if ($id_user_group !='')
{
switch ($typedata)
{
case 'all': //get all user group
$sql = "SELECT * FROM groupdevice WHERE id_user_group='$id_user_group'";
$result = mysql_query($sql,$db);
while($myrow = mysql_fetch_array($result))
{
echo $myrow['id_group'].'<br>';
echo $myrow['id_user_group'].'<br>';
echo $myrow['name_group'].'<br>';
echo $myrow['azimut'].'<br>';
echo $myrow['is_color'].'<br>';
echo $myrow['photosensor'].'<br>';
echo $myrow['bright_white'].'<br>';
echo $myrow['bright_red'].'<br>';
echo $myrow['bright_green'].'<br>';
echo $myrow['bright_blue'].'<br>';
echo $myrow['koef_white'].'<br>';
echo $myrow['koef_rgb'].'<br>';
echo $myrow['human_timer'].'<br>';
echo $myrow['use_photosensor'].'<br>';
echo $myrow['is_white'].'<br>';
echo $myrow['OnOff'].'<br>';
}
break;
case 'one': //get user group by id
if ($id_group!='')
{
$sql = "SELECT * FROM groupdevice WHERE id_user_group='$id_user_group' and id_group='$id_group'";
$result = mysql_query($sql,$db);
//echo $sql.'<br>';
while($myrow = mysql_fetch_array($result))
{
echo $myrow['id_group'].'<br>';
echo $myrow['id_user_group'].'<br>';
echo $myrow['name_group'].'<br>';
echo $myrow['azimut'].'<br>';
echo $myrow['is_color'].'<br>';
echo $myrow['photosensor'].'<br>';
echo $myrow['bright_white'].'<br>';
echo $myrow['bright_red'].'<br>';
echo $myrow['bright_green'].'<br>';
echo $myrow['bright_blue'].'<br>';
echo $myrow['koef_white'].'<br>';
echo $myrow['koef_rgb'].'<br>';
echo $myrow['human_timer'].'<br>';
echo $myrow['use_photosensor'].'<br>';
echo $myrow['is_white'].'<br>';
echo $myrow['OnOff'].'<br>';
}
}
break;
}
}
}
function getgroupdevice($login,$pass,$typedata)
{
if (($login!='') and ($pass!='') and ($typedata!=''))
{
include("support.php");
$id_user = loginform($login,$pass);
if ($id_user!='')
{
switch ($typedata)
{
case 'all': //get all user group
$sql = "SELECT * FROM groupdevice WHERE id_user_group='$id_user_group'";
$result = mysql_query($sql,$db);
break;
case 'one': //get user group by id
if ($id_group!='')
{
$sql = "SELECT * FROM groupdevice WHERE id_user_group='$id_user_group' and id_group='$id_group'";
$result = mysql_query($sql,$db);
}
break;
}
}
}
return $result;
}
?>