Subversion Repositories ALCASAR

<?php
# $Id: autoregistrationinfo.php 2823 2020-05-24 17:38:00Z rexy $
#
# SMS Autoregistration
# By Rexy

define('CONF_FILE', '/usr/local/etc/alcasar.conf');

// Read CONF_FILE
$file_conf = fopen(CONF_FILE, 'r');
if (!$file_conf) {
        exit('Error opening the file '.CONF_FILE);
}
while (!feof($file_conf)) {
        $buffer = fgets($file_conf, 4096);
        if ((strpos($buffer, '=') !== false) && (substr($buffer, 0, 1) !== '#')) {
                $tmp = explode('=', $buffer, 2);
                $conf[trim($tmp[0])] = trim($tmp[1]);
        }
}
fclose($file_conf);

// Check if the SMS service is enable
if ($conf['SMS'] !== 'on') {
        header('Location: /');
        exit();
}
$organisme   = $conf['ORGANISM'];
$current_num = $conf['SMS_NUM'];


// Choice of language
$Language = 'en';
if(isset($_SERVER['HTTP_ACCEPT_LANGUAGE'])) {
        $Langue = explode(',', $_SERVER['HTTP_ACCEPT_LANGUAGE']);
        $Language = strtolower(substr(chop($Langue[0]), 0, 2));
}
if ($Language === 'fr') {       // French
        $l_title                = "Page d'auto enregistrement";
        $l_num_exist            = "Compte actif";
        $l_num_flood            = "Numéro bloqué: nombre d'essai dépassé.";

        $l_num_num              = "Numero de téléphone";
        $l_num_raison           = "Etat de votre numéro";
        $l_num_expiration       = "Expiration du bloquage";

        $l_tuto_1               = "Bienvenue sur la page d'auto enregistrement.";
        $l_tuto_2               = "Ce portail d'accès à Internet vous offre la possibilité de vous inscrire en envoyant le mot de passe de votre choix par SMS au numéro suivant (prix d'un SMS, non surtaxé).";
        $l_tuto_3               = "Votre SMS ne doit contenir qu'un seul mot.";
        $l_tuto_4               = "Votre inscription sera activée lorsque vous retrouverez votre numéro de téléphone dans le tableau ci-dessous. Ce numéro de téléphone constitue votre identifiant de connexion";
        $l_tuto_5               = "Le champ de recherche ci-dessous vous permet de retrouver votre numéro suivant les 5 derniers chiffres.";   

        $l_tab_first            = "premier";
        $l_tab_last             = "dernier";
        $l_tab_next             = "suivant";
        $l_tab_prev             = "précédent";
        $l_tab_search           = "Recherche :";
        $l_tab_pmenu            = "Affiche la page _PAGE_ sur _PAGES_";
        $l_tab_info             = "Montrer _MENU_ résultats par page";
        $l_tab_infoempty        = "Aucun résultat";

        $l_autorefresh          = "Rafraichissement : 10 sec";
} else {                        // English
        $l_title                = "Autoregistration";
        $l_num_exist            = "Account enables";
        $l_num_flood            = "Phone number banned: Number of trial exceeded.";

        $l_num_num              = "Phone number";
        $l_num_raison           = "Status of your phone number";
        $l_num_expiration       = "Expiration";

        $l_tuto_1               = "Welcome to the auto-enrollment page";
        $l_tuto_2               = "This portal allows you to enroll by sending the password of you choice via SMS to the following number (no surcharge) :";
        $l_tuto_3               = "Just send 1 word in your SMS.";
        $l_tuto_4               = "Your registration will be activated when you'll find your phone number in the following table. This phone number is your login name";
        $l_tuto_5               = "You can search your phone number according to the 5 last digits in your phone number.";
        
        $l_tab_first            = "first";
        $l_tab_last             = "last";
        $l_tab_next             = "next";
        $l_tab_prev             = "previous";
        $l_tab_search           = "Search :";
        $l_tab_pmenu            = "Showing _PAGE_ to _PAGE_ of _PAGE_ entries :";
        $l_tab_info             = "Show _MENU_ entries";
        $l_tab_infoempty        = "No matching records found";

        $l_autorefresh          = "Refresh: 10 sec";
}

// Get SMS from database
require('/etc/freeradius-web/config.php');
$img_rep         = '/images/';
$img_sms         = 'sms.png';

$con = mysqli_connect($config['sql_server'], $config['sql_username'], $config['sql_password'], 'gammu');

if (mysqli_connect_errno()) {
        exit('Failed to connect to ' . $config['sql_type']/* . ': ' . mysqli_connect_error()*/);
}

$result = mysqli_query($con, 'SELECT * FROM `SMS_ban_perm` ORDER BY date_add DESC;');

$smsBanPerms = [];
while ($row = mysqli_fetch_array($result)) {
        $smsBanPerms[] = (object) [
                'numberHidden' => substr($row['SenderNumber'], 0, 3) . '****' . substr($row['SenderNumber'], -5),
                'expiration'   => $row['Expiration'],
                'perm'         => $row['Perm']
        ];
}
mysqli_close($con);

?>
<!DOCTYPE html>
<html><!-- written by Rexy -->
<head>
        <meta charset="utf-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <title>ALCASAR - <?= $l_title ?></title>
        <link rel="stylesheet" type="text/css" href="/css/bootstrap.min.css">
        <link rel="stylesheet" type="text/css" href="/css/index.css">
        <link rel="stylesheet" type="text/css" href="/css/jquery.dataTables.css">
        <link rel="icon" href="/images/favicon-48.ico" type="image/ico">
        <script src="/js/jquery.min.js"></script>
        <script src="/js/jquery.dataTables.js"></script>
        <script>
        function timedRefresh(timeoutPeriod) {
                var interval = setInterval(refreshPage, timeoutPeriod);
        }

        function refreshPage() {
                if ($('input[name=autoRefreshCheckboxes]').is(':checked')) {
                        location.reload(true);
                }
        }

        $(document).ready( function () {
                $('#table_id').DataTable({
                        "language": {
                                "paginate": {
                                        "sFirst":    "<?= $l_tab_first ?>",
                                        "sLast":     "<?= $l_tab_last ?>",
                                        "sPrevious": "<?= $l_tab_prev ?>",
                                        "sNext":     "<?= $l_tab_next ?>"
                                },
                                "lengthMenu":  "<?= $l_tab_info ?>",
                                "zeroRecords": "<?= $l_tab_infoempty ?>",
                                "info":        "<?= $l_tab_pmenu ?>",
                                "infoEmpty":   "<?= $l_tab_infoempty ?>",
                                "sSearch":     "<?= $l_tab_search ?>"
                        }
                });
        });
        </script>
</head>
<body onload="timedRefresh(10000);">
        <div class="col-xs-12 col-md-10 col-md-offset-1"> 
                <!-- HeaderBox -->
                <div class="row banner">
                        <!-- Logo box -->
                        <div class="img_banner hidden-xs col-sm-3 col-md-2 col-lg-2"> 
                                <img class="img-responsive img-organisme" src="images/organisme.png">
                        </div>
                        <!-- Title -->
                        <div id="cadre_titre" class="titre_banner col-xs-12 col-sm-8">
                                        <p id="acces_controle" class="titre_controle"><?= $l_title ?></p>
                        </div>
                        <!-- Logo box -->
                        <div class="img_banner hidden-xs col-sm-3 col-md-2 col-lg-2">
                                <img class="img-responsive img-organisme" src="images/logo-alcasar_70.png">
                        </div>
                </div>
                <!-- Main content box -->
                <div class="row">
                        <div id="contenu_acces" class="col-xs-12 col-lg-offset-1 col-lg-10">
                                <h3><?= $l_tuto_2 ?></h3>
                                <div class="menu-container container col_xs_12 col-sm-7">
                                        <div class="box_menu_right box_menu">
                                                <span><?= $current_num ?></span>
                                                <div class="menu-image">                                                
                                                        <img class="img-responsive" src="<?= $img_rep.$img_sms ?>">
                                                </div>
                                        </div>
                                </div>
                                <div class="info-box-container col-sm-5">
                                        <div id="box_infos">
                                                <p class="box_infos_explanations"><?= $l_tuto_3 ?>
                                        </div>
                                </div>
                        </div>
                </div>
        <p>
                <div class="row">
                        <div id="contenu_acces" class="col-xs-12 col-lg-offset-1 col-lg-10">
                                <h4><?= $l_tuto_4 ?></h4>
                                <h4><?= $l_tuto_5 ?></h4>
                                <label><input type="checkbox" checked="checked" name="autoRefreshCheckboxes"><?= $l_autorefresh ?></label>
                                <table id="table_id" class="display">
                                <thead>
                                        <tr>
                                                <th><b><?= $l_num_num ?></b></th>
                                                <th><b><?= $l_num_raison ?></b></th>
                                                <th><b><?= $l_num_expiration ?></b></th>
                                        </tr>
                                </thead>
                                <tbody>
                                        <?php foreach ($smsBanPerms as $smsBanPerm): ?>
                                                <tr>
                                                        <td><?= $smsBanPerm->numberHidden ?></td>
                                                        <?php if ($smsBanPerm->perm == '0'): ?>
                                                        <td><?= $l_num_exist ?></td>
                                                        <?php elseif ($smsBanPerm->perm == '1'): ?>
                                                        <td><?= $l_num_flood ?></td>
                                                        <?php endif ?>
                                                        <td><?= $smsBanPerm->expiration ?></td>
                                                </tr>
                                        <?php endforeach; ?>
                                </tbody>
                                </table>
                        </div>
                </div>
        </div>
</body>
</html>