/
main_functions.php
77 lines (66 loc) · 2.22 KB
/
main_functions.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
<?php
require_once('config.php');
$cat = $_POST['cat'];
switch($cat){
case "validation":
$count = 0;
$count += getinfo("SELECT * FROM `factures_cantine` WHERE `validation` = '0'");
$count += getinfo("SELECT * FROM `factures_etal` WHERE `validation` = '0'");
$count += getinfo("SELECT * FROM `factures_amarrage` WHERE `validation` = '0'");
print "{\"num\":\"$count\"}";
break;
case "facture":
$count = 0;
$count += getinfo("SELECT * FROM `factures_cantine` WHERE `reglement` = '0' AND `acceptation` = '1'");
$count += getinfo("SELECT * FROM `factures_etal` WHERE `reglement` = '0' AND `acceptation` = '1'");
$count += getinfo("SELECT * FROM `factures_amarrage` WHERE `reglement` = '0' AND `acceptation` = '1'");
print "{\"num\":\"$count\"}";
break;
case "client":
$count = 0;
$count += getinfo("SELECT * FROM `clients` WHERE `clientstatus` = '1'");
print "{\"num\":\"$count\"}";
break;
case "enfant":
$count = 0;
$count += getinfo("SELECT * FROM `enfants` WHERE `active` = '1'");
print "{\"num\":\"$count\"}";
break;
case "saint":
print getsaint("01/01");
break;
case "rolmre_cantine":
print getrol("rolmre_cantine");
break;
}
function getinfo($query){
$mysqli = new mysqli(DBSERVER, DBUSER, DBPWD, DB);
$result = $mysqli->query($query);
$num_rows = mysqli_num_rows($result);
$mysqli->close();
return $num_rows;
}
function getsaint(){
$mysqli = new mysqli(DBSERVER, DBUSER, DBPWD, DB);
$today = date("d/m");
$query = "SELECT `Fete` FROM `saint` WHERE `JourMois`='$today'";
$result = $mysqli->query($query);
$result_array = array();
while($row = $result->fetch_array(MYSQLI_ASSOC)){
$result_array[] = $row;
}
$mysqli->close();
return json_encode($result_array);
}
function getrol($type){
$mysqli = new mysqli(DBSERVER, DBUSER, DBPWD, DB);
$query = "SELECT `from`,`to`,`filename` FROM `rol` WHERE `type`='$type' ORDER BY `idrol` DESC LIMIT 10";
$result = $mysqli->query($query);
$result_array = array();
while($row = $result->fetch_array(MYSQLI_ASSOC)){
$result_array[] = $row;
}
$mysqli->close();
return json_encode($result_array);
}
?>