Lost Enable/Disable Option in mng-batch-list.php and mng-batch-enable.php and mng-batch-disable.php files

[momothefox]

Hi i am using a version of daloRADIUS change log file says wip 1.1-3 BETA i cannot find this version on the repo i am putting back files code if you can add it again to daloRADIUS

the thing is. when you disable the batch it changes groupname in usergroupinfo table to daloRADIUS-Disabled-Users which is OK

but in enable file it is supposed to revert back to original Profile name the thing is. how to determine the original batch name? a way out of that is to name the plan name as group name exactly so you can recall $configValues['CONFIG_DB_TBL_DALOUSERBILLINFO'].".planname) ". and assign groupname to it.

Perhaps if could be adding an option to change batch - profile/group assignment this can be very very helpful

mng-batch-disable.php

<?php
/*
 *********************************************************************************************************
 * daloRADIUS - RADIUS Web Platform
 * Copyright (C) 2007 - Liran Tal <liran@enginx.com> All Rights Reserved.
 *
 * This program is free software; you can redistribute it and/or
 * modify it under the terms of the GNU General Public License
 * as published by the Free Software Foundation; either version 2
 * of the License, or (at your option) any later version.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
 *
 *********************************************************************************************************
 *
 * Authors: Liran Tal <liran@enginx.com>
 *
 *********************************************************************************************************
 */

    include ("library/checklogin.php");
    $operator = $_SESSION['operator_user'];

    include('library/check_operator_perm.php');

    isset($_GET['batch_id']) ? $batch_id = $_GET['batch_id'] : $batch_id = "";
    isset($_GET['batch_name']) ? $batch_name = $_GET['batch_name'] : $batch_name = "";

    $logAction = "";
    $logDebugSQL = "";

    $showRemoveDiv = "block";

    if (
        ( (isset($_GET['batch_id'])) && (!empty($batch_id)) )
             ||
        ( (isset($_GET['batch_name'])) && (!empty($batch_name)) )
        )
            {

        include 'library/opendb.php';

        // if batch_name is set then we need to translate that to the batch_id
        if ($batch_name) {

            $sql = "SELECT ".
                    $configValues['CONFIG_DB_TBL_DALOBATCHHISTORY'].".id,".
                    $configValues['CONFIG_DB_TBL_DALOBATCHHISTORY'].".batch_name ".
                    " FROM ".
                    $configValues['CONFIG_DB_TBL_DALOBATCHHISTORY']." ".
                    " WHERE ".
                    $configValues['CONFIG_DB_TBL_DALOBATCHHISTORY'].".batch_name = '$batch_name'";

            $res_q_batch = $dbSocket->query($sql);
            $logDebugSQL .= $sql . "\n";
            $row_q_batch = $res_q_batch->fetchRow();
            $batch_id = array($row_q_batch[0]);

        }

        $allBatches = "";

        /* since the foreach loop will report an error/notice of undefined variable $value because
           it is possible that the $username is not an array, but rather a simple GET request
           with just some value, in this case we check if it's not an array and convert it to one with
           a NULL 2nd element
        */
        if (!is_array($batch_id))
            $batch_id = array($batch_id);

        foreach ($batch_id as $variable=>$value) {

            if (trim($variable) != "") {

                $batch = $value;
                $allBatches .= $batch . ", ";

                // we grab all users which are associated with this batch_id
                $sql = "SELECT ".
                        $configValues['CONFIG_DB_TBL_DALOUSERBILLINFO'].".id,".
                        $configValues['CONFIG_DB_TBL_DALOUSERBILLINFO'].".username ".
                        " FROM ".
                        $configValues['CONFIG_DB_TBL_DALOUSERBILLINFO']." ".
                        " WHERE ".
                        $configValues['CONFIG_DB_TBL_DALOUSERBILLINFO'].".batch_id = $batch ";

                $res = $dbSocket->query($sql);
                $logDebugSQL .= $sql . "\n";

                // setting table-related parameters first               
                switch($configValues['FREERADIUS_VERSION']) {
                    case '1' :
                        $tableSetting['postauth']['user'] = 'user';
                        $tableSetting['postauth']['date'] = 'date';
                        break;
                    case '2' :
                        // down
                    case '3' :
                        // down
                    default  :
                        $tableSetting['postauth']['user'] = 'username';
                        $tableSetting['postauth']['date'] = 'authdate';
                        break;
                }

                // loop through each user and disable it
                while($row = $res->fetchRow()) {

                    $username = $row[1];

                    // Disabled group assigning to a username   
                    $sql = "UPDATE ".$configValues['CONFIG_DB_TBL_RADUSERGROUP']." SET groupname='daloRADIUS-Disabled-Users' WHERE Username='$username'";
                    $res_q = $dbSocket->query($sql);
                    $logDebugSQL .= $sql . "\n";

                }

                $successMsg = "Disabled batch(s): <b> $allBatches </b>";
                $logAction .= "Successfully disabled batch(s) [$allBatches] on page: ";

            }  else { 
                $failureMsg = "no batch was entered, please specify a batch name to disable from database";     
                $logAction .= "Failed disabling batch(s) [$allBatches] on page: ";
            }

        $showRemoveDiv = "none";

        } //foreach

        include 'library/closedb.php';

    } //if

    include_once('library/config_read.php');
    $log = "visited page: ";

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html dir="rtl" lang="<?= $langCode ?>" xml:lang="<?= $langCode ?>"xmlns="http://www.w3.org/1999/xhtml"'>
<head>
<title>WitRADIUS</title>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<link rel="stylesheet" href="css/1.css" type="text/css" media="screen,projection" />

</head>

<?php

    include ("menu-mng-batch.php");

?>

<div id="contentnorightbar">

    <h2 id="Intro"><a href="#" onclick="javascript:toggleShowDiv('helpPage')"><?php echo t('Intro','mngbatchdis.php') ?>
    :: <?php if (isset($username)) { echo $username; } ?><h144>&#x2705;</h144></a></h2>

    <div id="helpPage" style="display:none;visibility:visible" >
        <?php echo t('helpPage','mngbatchdel') ?>
        <br/>
    </div>
    <?php
        include_once('include/management/actionMessages.php');
    ?>

    <div id="removeDiv" style="display:<?php echo $showRemoveDiv ?>;visibility:visible" >
    <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="get">

    <fieldset>

        <h302> <?php echo t('title','BatchRemoval') ?> </h302>
        <br/>

        <label for='batch_name' class='form'><?php echo t('all','BatchName')?></label>
        <input name='batch_name' type='text' id='batch_name' value='' tabindex=100 />

        <br/><br/>
        <hr><br/>
        <input type="submit" name="submit" value="<?php echo t('buttons','apply') ?>" tabindex=1000 
            class='button' />

    </fieldset>

    </form>
    </div>

<?php
        include_once("include/management/autocomplete.php");

        if ($autoComplete) {
                echo "<script type=\"text/javascript\">
                      autoComEdit = new DHTMLSuite.autoComplete();
                      autoComEdit.add('batch_name','include/management/dynamicAutocomplete.php','_small','getAjaxAutocompleteBatchNames');
                      </script>";
        }
?>

<?php
    include('include/config/logging.php');
?>

        </div>

        <div id="footer">

<?php
    include 'page-footer.php';
?>

        </div>

</div>
</div>

</body>
</html>

mng-batch-enable.php

<?php
/*
 *********************************************************************************************************
 * daloRADIUS - RADIUS Web Platform
 * Copyright (C) 2007 - Liran Tal <liran@enginx.com> All Rights Reserved.
 *
 * This program is free software; you can redistribute it and/or
 * modify it under the terms of the GNU General Public License
 * as published by the Free Software Foundation; either version 2
 * of the License, or (at your option) any later version.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
 *
 *********************************************************************************************************
 *
 * Authors: Liran Tal <liran@enginx.com>
 *
 *********************************************************************************************************
 */

    include ("library/checklogin.php");
    $operator = $_SESSION['operator_user'];

    include('library/check_operator_perm.php');

    isset($_GET['batch_id']) ? $batch_id = $_GET['batch_id'] : $batch_id = "";
    isset($_GET['batch_name']) ? $batch_name = $_GET['batch_name'] : $batch_name = "";

    $logAction = "";
    $logDebugSQL = "";

    $showRemoveDiv = "block";

    if (
        ( (isset($_GET['batch_id'])) && (!empty($batch_id)) )
             ||
        ( (isset($_GET['batch_name'])) && (!empty($batch_name)) )
        )
            {

        include 'library/opendb.php';

        // if batch_name is set then we need to translate that to the batch_id
        if ($batch_name) {

            $sql = "SELECT ".
                    $configValues['CONFIG_DB_TBL_DALOBATCHHISTORY'].".id,".
                    $configValues['CONFIG_DB_TBL_DALOBATCHHISTORY'].".batch_name ".
                    " FROM ".
                    $configValues['CONFIG_DB_TBL_DALOBATCHHISTORY']." ".
                    " WHERE ".
                    $configValues['CONFIG_DB_TBL_DALOBATCHHISTORY'].".batch_name = '$batch_name'";

            $res_q_batch = $dbSocket->query($sql);
            $logDebugSQL .= $sql . "\n";
            $row_q_batch = $res_q_batch->fetchRow();
            $batch_id = array($row_q_batch[0]);

        }

        $allBatches = "";

        /* since the foreach loop will report an error/notice of undefined variable $value because
           it is possible that the $username is not an array, but rather a simple GET request
           with just some value, in this case we check if it's not an array and convert it to one with
           a NULL 2nd element
        */
        if (!is_array($batch_id))
            $batch_id = array($batch_id);

        foreach ($batch_id as $variable=>$value) {

            if (trim($variable) != "") {

                $batch = $value;
                $allBatches .= $batch . ", ";

                // we grab all users which are associated with this batch_id
                $sql = "SELECT ".
                        $configValues['CONFIG_DB_TBL_DALOUSERBILLINFO'].".id,".
                        $configValues['CONFIG_DB_TBL_DALOUSERBILLINFO'].".username ".
                        " FROM ".
                        $configValues['CONFIG_DB_TBL_DALOUSERBILLINFO']." ".
                        " WHERE ".
                        $configValues['CONFIG_DB_TBL_DALOUSERBILLINFO'].".batch_id = $batch ";

                $res = $dbSocket->query($sql);
                $logDebugSQL .= $sql . "\n";

                // setting table-related parameters first               
                switch($configValues['FREERADIUS_VERSION']) {
                    case '1' :
                        $tableSetting['postauth']['user'] = 'user';
                        $tableSetting['postauth']['date'] = 'date';
                        break;
                    case '2' :
                        // down
                    case '3' :
                        // down
                    default  :
                        $tableSetting['postauth']['user'] = 'username';
                        $tableSetting['postauth']['date'] = 'authdate';
                        break;
                }

                // loop through each user and disable it
                while($row = $res->fetchRow()) {

                    $username = $row[1];

                    // Disabled group assigning to a username   
                    $sql = "UPDATE ".$configValues['CONFIG_DB_TBL_RADUSERGROUP']." SET groupname='daloRADIUS-Disabled-Users' WHERE Username='$username'";
                    $res_q = $dbSocket->query($sql);
                    $logDebugSQL .= $sql . "\n";

                }

                $successMsg = "Disabled batch(s): <b> $allBatches </b>";
                $logAction .= "Successfully disabled batch(s) [$allBatches] on page: ";

            }  else { 
                $failureMsg = "no batch was entered, please specify a batch name to disable from database";     
                $logAction .= "Failed disabling batch(s) [$allBatches] on page: ";
            }

        $showRemoveDiv = "none";

        } //foreach

        include 'library/closedb.php';

    } //if

    include_once('library/config_read.php');
    $log = "visited page: ";

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html dir="rtl" lang="<?= $langCode ?>" xml:lang="<?= $langCode ?>"xmlns="http://www.w3.org/1999/xhtml"'>
<head>
<title>WitRADIUS</title>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<link rel="stylesheet" href="css/1.css" type="text/css" media="screen,projection" />

</head>

<?php

    include ("menu-mng-batch.php");

?>

<div id="contentnorightbar">

    <h2 id="Intro"><a href="#" onclick="javascript:toggleShowDiv('helpPage')"><?php echo t('Intro','mngbatchena.php') ?>
    :: <?php if (isset($username)) { echo $username; } ?><h144>&#x2705;</h144></a></h2>

    <div id="helpPage" style="display:none;visibility:visible" >
        <?php echo t('helpPage','mngbatchdel') ?>
        <br/>
    </div>
    <?php
        include_once('include/management/actionMessages.php');
    ?>

    <div id="removeDiv" style="display:<?php echo $showRemoveDiv ?>;visibility:visible" >
    <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="get">

    <fieldset>

        <h302> <?php echo t('title','BatchRemoval') ?> </h302>
        <br/>

        <label for='batch_name' class='form'><?php echo t('all','BatchName')?></label>
        <input name='batch_name' type='text' id='batch_name' value='' tabindex=100 />

        <br/><br/>
        <hr><br/>
        <input type="submit" name="submit" value="<?php echo t('buttons','apply') ?>" tabindex=1000 
            class='button' />

    </fieldset>

    </form>
    </div>

<?php
        include_once("include/management/autocomplete.php");

        if ($autoComplete) {
                echo "<script type=\"text/javascript\">
                      autoComEdit = new DHTMLSuite.autoComplete();
                      autoComEdit.add('batch_name','include/management/dynamicAutocomplete.php','_small','getAjaxAutocompleteBatchNames');
                      </script>";
        }
?>

<?php
    include('include/config/logging.php');
?>

        </div>

        <div id="footer">

<?php
    include 'page-footer.php';
?>

        </div>

</div>
</div>

</body>
</html>

mng-batch-list.php

<?php
/*
 *********************************************************************************************************
 * daloRADIUS - RADIUS Web Platform
 * Copyright (C) 2007 - Liran Tal <liran@enginx.com> All Rights Reserved.
 *
 * This program is free software; you can redistribute it and/or
 * modify it under the terms of the GNU General Public License
 * as published by the Free Software Foundation; either version 2
 * of the License, or (at your option) any later version.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
 *
 *********************************************************************************************************
 *
 * Authors: Liran Tal <liran@enginx.com>
 *
 *********************************************************************************************************
 */

    include ("library/checklogin.php");
    $operator = $_SESSION['operator_user'];

    //include('library/check_operator_perm.php');

    //setting values for the order by and order type variables
    isset($_REQUEST['orderBy']) ? $orderBy = $_REQUEST['orderBy'] : $orderBy = "id";
    isset($_REQUEST['orderType']) ? $orderType = $_REQUEST['orderType'] : $orderType = "desc";

    include_once('library/config_read.php');
    $log = "visited page: ";
    $logQuery = "performed query on page: ";
    $logDebugSQL = "";

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html dir="rtl" lang="<?= $langCode ?>" xml:lang="<?= $langCode ?>"xmlns="http://www.w3.org/1999/xhtml"'>
<head>
<title>WitRADIUS</title>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<link rel="stylesheet" href="css/1.css" type="text/css" media="screen,projection" />
<link rel="stylesheet" type="text/css" href="library/js_date/datechooser.css">
<!--[if lte IE 6.5]>
<link rel="stylesheet" type="text/css" href="library/js_date/select-free.css"/>
<![endif]-->

</head>

<script src="library/js_date/date-functions.js" type="text/javascript"></script>
<script src="library/js_date/datechooser.js" type="text/javascript"></script>
<script src="library/javascript/pages_common.js" type="text/javascript"></script>

<script type="text/javascript" src="library/javascript/ajax.js"></script>
<script type="text/javascript" src="library/javascript/dynamic_attributes.js"></script>

<?php

    include ("menu-mng-batch.php");

?>  

    <div id="contentnorightbar">

        <h2 id="Intro"><a href="#"  onclick="javascript:toggleShowDiv('helpPage')"><?php echo t('Intro','mngbatchlist.php'); ?>
        <h144>&#x2705;</h144></a></h2>

        <div id="helpPage" style="display:none;visibility:visible" >
            <?php echo t('helpPage','mngbatchlist') ?>
            <br/>
        </div>

<?php

    include 'include/management/pages_common.php';
    include 'library/opendb.php';
    include 'include/management/pages_numbering.php';       // must be included after opendb because it needs to read the CONFIG_IFACE_TABLES_LISTING variable from the config file

    // setup php session variables for exporting
    $_SESSION['reportTable'] = "";
    //reportQuery is assigned below to the SQL statement  in $sql
    $_SESSION['reportQuery'] = "";
    $_SESSION['reportType'] = "reportsBatchList";

    //orig: used as maethod to get total rows - this is required for the pages_numbering.php page
    $sql = "SELECT ".
            $configValues['CONFIG_DB_TBL_DALOBATCHHISTORY'].".id,".
            $configValues['CONFIG_DB_TBL_DALOBATCHHISTORY'].".batch_name,".
            $configValues['CONFIG_DB_TBL_DALOBATCHHISTORY'].".batch_description,".
            $configValues['CONFIG_DB_TBL_DALOBATCHHISTORY'].".batch_status,".

            "COUNT(DISTINCT(".$configValues['CONFIG_DB_TBL_DALOUSERBILLINFO'].".id)) as total_users,".
            $configValues['CONFIG_DB_TBL_DALOUSERBILLINFO'].".planname,".
            $configValues['CONFIG_DB_TBL_DALOBILLINGPLANS'].".plancost,".
            $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'].".name as HotspotName,".

            $configValues['CONFIG_DB_TBL_DALOBATCHHISTORY'].".creationdate,".
            $configValues['CONFIG_DB_TBL_DALOBATCHHISTORY'].".creationby,".
            $configValues['CONFIG_DB_TBL_DALOBATCHHISTORY'].".updatedate,".
            $configValues['CONFIG_DB_TBL_DALOBATCHHISTORY'].".updateby ".
            " FROM ".$configValues['CONFIG_DB_TBL_DALOBATCHHISTORY'].
            " LEFT JOIN ".$configValues['CONFIG_DB_TBL_DALOUSERBILLINFO'].
            " ON ".
            "(".$configValues['CONFIG_DB_TBL_DALOBATCHHISTORY'].".id = ".
            $configValues['CONFIG_DB_TBL_DALOUSERBILLINFO'].".batch_id) ".

            " LEFT JOIN ".$configValues['CONFIG_DB_TBL_DALOBILLINGPLANS'].
            " ON ".
            "(".$configValues['CONFIG_DB_TBL_DALOBILLINGPLANS'].".planname = ".
            $configValues['CONFIG_DB_TBL_DALOUSERBILLINFO'].".planname) ".

            " LEFT JOIN ".$configValues['CONFIG_DB_TBL_DALOHOTSPOTS'].
            " ON ".
            "(".$configValues['CONFIG_DB_TBL_DALOBATCHHISTORY'].".hotspot_id = ".
            $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'].".id) ".

            " GROUP by ".$configValues['CONFIG_DB_TBL_DALOBATCHHISTORY'].".batch_name ";

    // set the session variable for report query (export)
    $_SESSION['reportQuery'] = $sql;

    $res = $dbSocket->query($sql);
    $numrows = $res->numRows();
    $logDebugSQL .= $sql . "\n";

    $sql = "SELECT ".
            $configValues['CONFIG_DB_TBL_DALOBATCHHISTORY'].".id,".
            $configValues['CONFIG_DB_TBL_DALOBATCHHISTORY'].".batch_name,".
            $configValues['CONFIG_DB_TBL_DALOBATCHHISTORY'].".batch_description,".
            $configValues['CONFIG_DB_TBL_DALOBATCHHISTORY'].".batch_status,".

            "COUNT(DISTINCT(".$configValues['CONFIG_DB_TBL_DALOUSERBILLINFO'].".id)) as total_users,".
            $configValues['CONFIG_DB_TBL_DALOUSERBILLINFO'].".planname,".
            $configValues['CONFIG_DB_TBL_DALOBILLINGPLANS'].".plancost,".
            $configValues['CONFIG_DB_TBL_DALOBILLINGPLANS'].".plancurrency,".
            $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'].".name as HotspotName,".

            $configValues['CONFIG_DB_TBL_DALOBATCHHISTORY'].".creationdate,".
            $configValues['CONFIG_DB_TBL_DALOBATCHHISTORY'].".creationby,".
            $configValues['CONFIG_DB_TBL_DALOBATCHHISTORY'].".updatedate,".
            $configValues['CONFIG_DB_TBL_DALOBATCHHISTORY'].".updateby ".
            " FROM ".$configValues['CONFIG_DB_TBL_DALOBATCHHISTORY'].
            " LEFT JOIN ".$configValues['CONFIG_DB_TBL_DALOUSERBILLINFO'].
            " ON ".
            "(".$configValues['CONFIG_DB_TBL_DALOBATCHHISTORY'].".id = ".
            $configValues['CONFIG_DB_TBL_DALOUSERBILLINFO'].".batch_id) ".

            " LEFT JOIN ".$configValues['CONFIG_DB_TBL_DALOBILLINGPLANS'].
            " ON ".
            "(".$configValues['CONFIG_DB_TBL_DALOBILLINGPLANS'].".planname = ".
            $configValues['CONFIG_DB_TBL_DALOUSERBILLINFO'].".planname) ".

            " LEFT JOIN ".$configValues['CONFIG_DB_TBL_DALOHOTSPOTS'].
            " ON ".
            "(".$configValues['CONFIG_DB_TBL_DALOBATCHHISTORY'].".hotspot_id = ".
            $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'].".id) ".

            " GROUP by ".$configValues['CONFIG_DB_TBL_DALOBATCHHISTORY'].".batch_name ".
            " ORDER BY $orderBy $orderType ".
            " LIMIT $offset, $rowsPerPage;";
    $res = $dbSocket->query($sql);
    $logDebugSQL .= $sql . "\n";

    /* START - Related to pages_numbering.php */
    $maxPage = ceil($numrows/$rowsPerPage);
    /* END */

    echo "<form name='listbatches' method='get' action='mng-del.php' >";

    echo "<table border='0' class='table1'>\n";
    echo "
                    <thead>
                            <tr>
                            <th colspan='10' align='left'> 

                Select:
                <a class=\"table\" href=\"javascript:SetChecked(1,'batch_id[]','listbatches')\">All</a> 
                <a class=\"table\" href=\"javascript:SetChecked(0,'batch_id[]','listbatches')\">None</a>
                <br/>
                <input class='button' type='button' value='Delete' onClick='javascript:removeCheckbox(\"listbatches\",\"mng-batch-del.php\")' />
                <br/>
                <input class='button' type='button' value='Disable' onClick='javascript:disCheckbox(\"listbatches\",\"mng-batch-disable.php\")' />
                <br/>
                <input class='button' type='button' value='Enable' onClick='javascript:enaCheckbox(\"listbatches\",\"mng-batch-enable.php\")' />
                <br/>

                <input class='button' type='button' value='CSV Export'
                    onClick=\"javascript:window.location.href='include/management/fileExport.php?reportFormat=csv'\"
                    />
                <br/><br/>
        ";

    /* drawing the number links */
    if ($configValues['CONFIG_IFACE_TABLES_LISTING_NUM'] == "yes")
        setupNumbering($numrows, $rowsPerPage, $pageNum, $orderBy, $orderType);

    echo "
            </th>
            </tr>
            </thead>
            ";
      $curOrderType = $orderType;
        if ($orderType == "asc") {
                $orderType = "desc";
        } else  if ($orderType == "desc") {
                $orderType = "asc";
        }

    echo "<thread> <tr>
        <th scope='col'> 
        <a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=id&orderType=$orderType\">
        ".t('all','BatchName')."</a>
        </th>

        <th scope='col'> 
        ".t('all','HotSpot')."
        </th>

        <th scope='col'> 
        ".t('all','BatchStatus')."
        </th>

        <th scope='col'> 
        ".t('all','TotalUsers')."
        </th>

        <th scope='col'> 
        ".t('all','PlanName')."
        </th>

        <th scope='col'> 
        ".t('all','PlanCost')."
        </th>

        <th scope='col'> 
        ".t('all','BatchCost')."
        </th>

        <th scope='col'> 
        <a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=creationdate&orderType=$orderType\">
        ".t('all','CreationDate')."</a>
        </th>

        <th scope='col'> 
        <a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=creationby&orderType=$orderType\">
        ".t('all','CreationBy')."</a>
        </th>

        </tr> </thread>";

    $active_users_per = 0;
    $total_users = 0;
    $active_users = 0;
    $batch_cost = 0;
    while($row = $res->fetchRow(DB_FETCHMODE_ASSOC)) {

        $hotspot_name = $row['HotspotName'];
        $batch_status = $row['batch_status'];
        $plancost = $row['plancost'];
        $total_users = $row['total_users'];
        $batch_cost = ($active_users * $plancost);
        $plan_currency = $row['plancurrency'];

        printqn("
                <tr>

                <td>
                <input type='checkbox' name='batch_id[]' value='{$row['id']}'>
                <a class='tablenovisit' href='#'
                    onclick='javascript:return false;'
                    tooltipText='
                    <a class=\"toolTip\" href=\"rep-batch-details.php?batch_name={$row['batch_name']}\">
                        ".t('Tooltip','BatchDetails')."</a>
                        <br/><br/>
                                <div id=\"divContainerUserInfo\">
                                    <b>".t('all','batchDescription')."</b>:<br/><br/>
                                    {$row['batch_description']}
                                </div>
                                <br/>
                                '
            >{$row['batch_name']}</a>
            </td>
        ");

        echo "

                <td>".$hotspot_name."

                </td>

                <td>".$batch_status."

                </td>

                <td>".$total_users."

                </td>

                <td>".
                    $row['planname']."
                </td>

                <td>".$plancost."
                </td>

                <td>".$batch_cost."
                </td>

                <td>".
                    $row['creationdate']."
                </td>

                <td>".
                    $row['creationby']."
                </td>

            </tr>
        ";

        /*
        printqn("
            <td> <input type='checkbox' name='username[]' value='$row[0]'>$row[2]</td>
            <td> 
        ");
        */

    }

    echo "
                    <tfoot>
                            <tr>
                            <th colspan='10' align='left'> 
    ";
    setupLinks($pageNum, $maxPage, $orderBy, $curOrderType);
    echo "                          </th>
                            </tr>
                    </tfoot>
        ";

    echo "</table>";
    echo "</form>";

    include 'library/closedb.php';

?>

<?php
    include('include/config/logging.php');
?>

</div>

    <div id="footer">

<?php
    include 'page-footer.php';
?>

    </div>

</div>
</div>

<script type="text/javascript">
        var tooltipObj = new DHTMLgoodies_formTooltip();
        tooltipObj.setTooltipPosition('right');
        tooltipObj.setPageBgColor('#EEEEEE');
        tooltipObj.setTooltipCornerSize(15);
        tooltipObj.initFormFieldTooltip();
</script>

</body>
</html>

[momothefox]

any update? @filippolauria

[momothefox]

Hi @filippolauria i have tested the new option of enable disable users in a batch but enabling/disabling user by user or page by page in a 1000 user batch is something awful
is there is a way to disable entire batch?

maybe in the future can edit batch to change group - plan for entire batch after creating it would be a big addition for daloRADIUS .. note that changing group - plan assignment would not do any harm for accounting records related to users in a batch

one thing is very important. we want to make sure deleting a batch would remove all corresponding data for users in the batch in all tables especially radacct table to avoid generating a user that have been deleted before, while having accounting record for it. so it would be a none usable user.

[momothefox]

@filippolauria I am sorry i did not notice you have already done it last week thank you very much