function refresh($path)
{
/* on récupère le contenu du fichier et on range les valeurs dans un array */
$data = explode(",", file_get_contents($path));
/* on garde que les cafés et la force */
$data = array_slice($data, 4);
/* détail du tableau
[0] = préparation d'un café
[1] = préparation d'un ristretto
[2] = préparation d'un expresso
[3] = préparation d'un café long
[4] = préparation d'un thé
[5] = préparation d'un cappuccino
[6] = force de la boisson
*/
foreach ($data as $key => $value) {
/* si la clé est une boisson et s'il a une préparation, on ajoute une ligne dans la bdd*/
if ($key < 6 && $value == 1) {
send_to_db($key, $data[6]);
break;
}
}
/* afficher les données de la bdd */
get_from_db();
}
function check_if_blacklisted($number)
{
$query = "select black_list_numbers_number from black_list_numbers;";
$db_blacklisted_numbers = get_from_db($query);
//usuwanie bialych spacji itp - przydane dla konca linii z listy
$number = str_replace(' ', '', $number);
$found_in_blacklist = 0;
foreach ($db_blacklisted_numbers as $blacklisted_number) {
$blnumber = $blacklisted_number['black_list_numbers_number'];
//echo "<br>$blnumber ? $number<br>";
$number_lenght = strlen($number);
$blacklisted_number_lenght = strlen($blnumber);
$number_arr = str_split($number);
$blnumber_arr = str_split($blnumber);
$index = 0;
if ($number_lenght == $blacklisted_number_lenght) {
$found = 0;
foreach ($blnumber_arr as $char) {
if ($char == $number_arr[$index] || $char == "X") {
//echo $char."=".$number_arr[$index]."<br>";
$found++;
$index++;
} else {
//echo $char."!=".$number_arr[$index]."<br>";
$index++;
break;
}
}
if ($found == $index) {
$found_in_blacklist++;
break;
}
}
unset($index);
}
if ($found_in_blacklist > 0) {
return 1;
} else {
return 0;
}
}
function print_current_tasks()
{
if (isset($_POST['find_user_id']) && !empty($_POST['find_user_id'])) {
switch ($_POST['find_user_id']) {
case '*':
$query = "SELECT id_task, phone_number, message, send_time, selected_by FROM sms.tasks;";
break;
default:
$query = "SELECT id_task, phone_number, message, send_time, selected_by FROM sms.tasks where sender='" . $_POST['find_user_id'] . "';";
break;
}
} else {
$query = "SELECT id_task, phone_number, message, send_time, selected_by FROM sms.tasks where sender='" . $_SESSION['id_user'] . "';";
}
$res = get_from_db($query);
echo '
<h2>Zadania w trakcie realizacji</h2>
<form action="index.php" method="POST">
<table class="content">
<tr>
<td>Numer</td>
<td>Wiadomość</td>
<td>Termin wysłania</td>
<td>Obsługiwane przez</td>
<td>Anuluj</td>
</tr>';
foreach ($res as $single_task) {
echo '
<tr>
<td>' . $single_task["phone_number"] . '</td>
<td>' . $single_task["message"] . '</td>
<td>' . $single_task["send_time"] . '</td>';
if (!empty($single_task["selected_by"])) {
echo '
<td style="background-color: green;">' . $single_task["selected_by"] . '</td>
<td>
<input type="checkbox" disabled="disabled" name="cancel_tasks[]" value="' . $single_task["id_task"] . '"/>
</td>';
} else {
echo '
<td style="background-color: grey;">' . $single_task["selected_by"] . '</td>
<td>
<input type="checkbox" name="cancel_tasks[]" value="' . $single_task["id_task"] . '"/>
</td>';
}
echo '</tr>';
}
echo '
</form>
<tr>
<td colspan="4"></td>
<td>
<input type="hidden" name="kat" value="mytasks"/>
<input style="background-color: red;" type="submit" name="cancel_task_submit" value="Anuluj"/>
</td>
</tr>
</table>';
}
function print_editcontact_page()
{
if (isset($_POST["editContactID"]) && !empty($_POST["editContactID"])) {
echo '<div class="content">
<form action="index.php" method="POST">
<table>
<tr>
<td>Numer</td>
<td>Pseudonim</td>
<td>Imię</td>
<td>Nazwisko</td>
<td>Adres</td>
<td>E-mail</td>
<td>Zapisz zmiany</td>
<td>Usuń kontakt</td>
</tr>';
$editContactID = $_POST["editContactID"];
$query = "SELECT id_contact, contact_number, contact_nickname, contact_name, contact_lastname, contact_address, contact_email FROM sms.contacts WHERE id_contact = " . $editContactID . " ORDER BY id_contact ASC;";
$res = get_from_db($query);
foreach ($res as $row) {
echo '<tr>
<td><input type="text" name="contact_number" value="' . $row["contact_number"] . '"/></td>
<td><input type="text" name="contact_nickname" value="' . $row["contact_nickname"] . '"/></td>
<td><input type="text" name="contact_name" value="' . $row["contact_name"] . '"/></td>
<td><input type="text" name="contact_lastname" value="' . $row["contact_lastname"] . '"/></td>
<td><input type="text" name="contact_address" value="' . $row["contact_address"] . '"/></td>
<td><input type="text" name="contact_email" value="' . $row["contact_email"] . '"/></td>
<td>
<input type="hidden" name="id_contact" value="' . $row["id_contact"] . '" />
<input type="hidden" name="kat" value="addressbook" />
<input type="hidden" name="id" value="editsave" />
<input type="submit" value="Zapisz" />
</form>
</td>
<td>
<form action="index.php" method="POST">
<input type="hidden" name="id_contact" value="' . $row["id_contact"] . '" />
<input type="hidden" name="kat" value="addressbook" />
<input type="hidden" name="id" value="delcontact" />
<input style="background-color: red;" type="submit" value="Usun" />
</form>
</td>
</tr>';
}
echo '
</table>
</div>';
}
}
function print_simple_stats()
{
$calkowita_ilosc_zadan_query = "SELECT count(id_task) as kolejka FROM sms.tasks;";
$ilosc_zadan_uzytkownika_query = "SELECT count(id_task) as kolejka FROM sms.tasks WHERE sender='1" . $_SESSION['id_user'] . "';";
$res1 = get_from_db($calkowita_ilosc_zadan_query);
$res2 = get_from_db($ilosc_zadan_uzytkownika_query);
echo '
<table class="content">
<tr><td colspan="2">Statystyki</td></tr>
<tr>
<td>Aplikacja ONLINE</td>';
if (check_if_server_working()) {
echo '<td style="background-color: green">TAK</td>';
} else {
echo '<td style="background-color: red">NIE</td>';
}
echo ' </td>
</tr>
<tr>
<td>Ilość Twoich zadań w kolejce</td><td>' . $res1[0]['kolejka'] . '</td>
</tr>
<tr>
<td>Ilość wszystkich zadań w kolejce</td><td>' . $res2[0]['kolejka'] . '</td>
</tr>
</table>';
}
function blacklist_management_print()
{
echo '
<table class="content">
<tr>
<td>ID</td>
<td>Numer</td>
<td>Komentarz</td>
<td>Modyfikuj</td>
<td>Usuń</td>
</tr>
';
$query = "SELECT `id_black_list_number`, `black_list_numbers_number`, `black_list_numbers_comment` FROM sms.black_list_numbers";
$blacklisted_numbers = get_from_db($query);
foreach ($blacklisted_numbers as $blnumber) {
echo '<tr>
<td>
<form action="index.php" method="POST">
' . $blnumber['id_black_list_number'] . '
</td>
<td>
<input type="text" name="black_list_numbers_number" value="' . $blnumber['black_list_numbers_number'] . '"/>
</td>
<td>
<input type="text" name="black_list_numbers_comment" value="' . $blnumber['black_list_numbers_comment'] . '"/>
</td>
<td>
<input type="hidden" name="update_blacklist_number_id" value="' . $blnumber['id_black_list_number'] . '"/>
<input type="hidden" name="kat" value="settings"/>
<input type="hidden" name="id" value="updatebln"/>
<input type="submit" name="update_bln_submit" value="Aktualizuj"/>
</form>
</td>
<td>
<form action="index.php" method="POST">
<input type="hidden" name="delete_blacklist_number_id" value="' . $blnumber['id_black_list_number'] . '"/>
<input type="hidden" name="kat" value="settings"/>
<input type="hidden" name="id" value="deletebln"/>
<input type="submit" name="delete_bln_submit" value="Usuń"/>
</form>
</td>
</tr>';
}
echo ' </table>
';
}
?>
</a><img src="<?php
if ($_GET["order_by"] == $value && $_GET["soort_by_order"] == "DESC") {
echo "icon-desc.png";
} else {
echo "icon-asc.png";
}
?>
"></th>
<?php
}
?>
</tr>
</thead>
<?php
foreach (get_from_db($statement) as $key => $value) {
?>
<tr class="<?php
echo ($key + 1) % 2 == 0 ? 'even' : 'onevne';
?>
">
<?php
foreach ($value as $rijen => $inhoud) {
?>
<td>
<?php
echo $inhoud;
?>
</td>
<?php
}
function print_users_view()
{
$query = 'SELECT
id_user,
user_name,
user_imie,
user_nazwisko,
user_dzial,
register_date,
disabled,
access_level
FROM sms.users;';
$res = get_from_db($query);
echo '
<div class="content">
<table>
<tr>
<td>ID</td>
<td>Login</td>
<td>Imię</td>
<td>Nazwisko</td>
<td>Dział</td>
<td>Data rejestracji</td>
<td>Zablokowany</td>
<td>Poziom</td>
<td>Edytuj</td>
</tr>
';
foreach ($res as $row) {
echo '<tr>
<td>' . $row["id_user"] . '</td>
<td>' . $row["user_name"] . '</td>
<td>' . $row["user_imie"] . '</td>
<td>' . $row["user_nazwisko"] . '</td>
<td>' . $row["user_dzial"] . '</td>
<td>' . $row["register_date"] . '</td>
<td>' . $row["disabled"] . '</td>
<td>' . $row["access_level"] . '</td>
<td>
<form action="index.php" method="POST">
<input type="hidden" name="id_user" value="' . $row["id_user"] . '"/>
<input type="hidden" name="kat" value="users" />
<input type="hidden" name="id" value="edituser" />
<input type="submit" value="Edytuj"/>
</form>
</td>
</tr>
';
}
echo '</table>
</div>';
}
