Subversion Repositories ALCASAR

Compare Revisions

Ignore whitespace Rev 2697 → Rev 2698

/web/acc/manager/htdocs/ticket_voucher.php
9,50 → 9,73
*/
 
require_once __DIR__ . '/../lib/alcasar/TicketsGenerator.php';
$langue_imp = ((isset($_POST['langue_imp'])) ? $_POST['langue_imp'] : 'en');
require_once __DIR__ . '/../lib/langues_imp.php';
require_once __DIR__ . '/../lib/langues.php';
require_once '/etc/freeradius-web/config.php';
require_once '../lib/sql/drivers/'.$config['sql_type'].'/functions.php';;
require_once '../lib/attrshow.php';
require_once '../lib/defaults.php';
require_once '../lib/functions.php';
require_once __DIR__ . '/../lib/sql/drivers/'.$config['sql_type'].'/functions.php';;
require_once __DIR__ . '/../lib/attrshow.php';
require_once __DIR__ . '/../lib/defaults.php';
require_once __DIR__ . '/../lib/functions.php';
if ($config['sql_use_operators'] === 'true') {
require_once '../lib/operators.php';
require_once __DIR__ . '/../lib/operators.php';
$text = ',op';
$passwd_op = ",':='";
}
 
 
// Get datas from form
if ((!isset($_POST['nbtickets'])) || (!is_numeric($_POST['nbtickets']))){
header('Location: voucher_new.php');
header('Location: user_new.php');
exit();
}
$nbTickets = (int)$_POST['nbtickets'];
$langue_imp = ((isset($_POST['langue_imp'])) ? $_POST['langue_imp'] : 'en');
require_once __DIR__ . '/../lib/langues_imp.php';
require_once __DIR__ . '/../lib/langues.php';
$nbTickets = (int)$_POST['nbtickets'];
 
if ($config['sql_use_operators'] === 'true') {
$text = ',op';
$passwd_op = ",':='";
// Get user attributes
$userAttr = [];
foreach (['Max-All-Session', 'Session-Timeout', 'Max-Daily-Session', 'Expiration'] as $attrName) {
if (isset($_POST[$attrName]) && !empty($_POST[$attrName])) {
$userAttr[$attrName] = $_POST[$attrName];
}
}
 
// Connect to database
$link = da_sql_pconnect($config);
if (!$link) {
exit('ERR_DATABASE_CONNECT');
if (count($userAttr) < 4) {
// Get group attributes
$link = da_sql_pconnect($config);
if ($link) {
if (isset($_POST['Fgroup']) && !empty($_POST['Fgroup'])) {
$default_group = 'ldap';
$group_uid = da_sql_escape_string($link, $_POST['Fgroup']);
$sql = "SELECT attribute, value FROM (( SELECT attribute, value FROM radgroupcheck WHERE groupname = '$group_uid' AND (attribute IN ('Max-All-Session', 'Max-Daily-Session', 'Expiration'))) UNION ( SELECT attribute, value FROM radgroupcheck WHERE groupname = '$default_group' AND (attribute IN ('Max-All-Session', 'Max-Daily-Session', 'Expiration'))) UNION ( SELECT attribute, value FROM radgroupreply WHERE groupname = '$group_uid' AND (attribute IN ('Session-Timeout'))) UNION ( SELECT attribute, value FROM radgroupreply WHERE groupname = '$default_group' AND (attribute IN ('Session-Timeout')))) attrs GROUP BY attribute;";
} else {
$default_group = 'ldap';
$sql = "SELECT attribute, value FROM (( SELECT attribute, value FROM radgroupcheck WHERE groupname = '$default_group' AND (attribute IN ('Max-All-Session', 'Max-Daily-Session', 'Expiration'))) UNION ( SELECT attribute, value FROM radgroupreply WHERE groupname = '$default_group' AND (attribute IN ('Session-Timeout')))) attrs GROUP BY attribute;";
}
$res = da_sql_query($link, $config, $sql);
if ($res) {
while ($row = da_sql_fetch_array($res, $config)) {
if (!isset($userAttr[$row['attribute']])) {
$userAttr[$row['attribute']] = $row['value'];
}
}
}
}
}
 
$nbFailUsers = 0;
// Format user attributes
$userAttr['Session-Timeout'] = ((isset($userAttr['Session-Timeout'])) ? formatTime($userAttr['Session-Timeout']) : $l_unlimited);
$userAttr['Max-All-Session'] = ((isset($userAttr['Max-All-Session'])) ? formatTime($userAttr['Max-All-Session']) : $l_unlimited);
$userAttr['Max-Daily-Session'] = ((isset($userAttr['Max-Daily-Session'])) ? formatTime($userAttr['Max-Daily-Session']) : $l_unlimited);
$userAttr['Expiration'] = ((isset($userAttr['Expiration'])) ? date('d - m - Y', strtotime($userAttr['Expiration'])) : $l_without);
 
 
 
// Generate tickets
$ticketsGenerator = new TicketsGenerator(['language' => $langue_imp]);
 
ob_start();
$nbFailUsers = 0;
for ($i = 0; $i < $nbTickets; $i++) {
// Generate username and password
$login = generateRandomString(8);
$passwd = generateRandomString(12);
$password = $passwd;
$username = generateRandomString(8);
$password = generateRandomString(12);
// Check user exist
require '../lib/'.$config['general_lib_type'].'/user_info.php';
64,29 → 87,14
// Create user in database
require '../lib/'.$config['general_lib_type'].'/create_user.php';
 
// Get group infos
if ((isset($group)) && ($group !== '')) {
$loginUser = $login;
$login = $group;
require '../lib/sql/group_info.php';
$login = $loginUser;
}
 
// Format datas
$sto_imp = (($sto_imp === '') ? $l_unlimited : formatTime($sto_imp));
$mas_imp = (($mas_imp === '') ? $l_unlimited : formatTime($mas_imp));
$mds_imp = (($mds_imp === '') ? $l_unlimited : formatTime($mds_imp));
$mms_imp = (($mms_imp === '') ? $l_unlimited : formatTime($mms_imp));
$exp_imp = (($Expiration === '') ? $l_without : date('d - m - Y', strtotime($Expiration)));
 
// Add user
// Add user ticket
$ticketsGenerator->addTicket([
'username' => $login,
'username' => $username,
'password' => $password,
'maxAllSession' => $mas_imp,
'sessionTimeout' => $sto_imp,
'maxDailySession' => $mds_imp,
'expiration' => $exp_imp
'maxAllSession' => $userAttr['Max-All-Session'],
'sessionTimeout' => $userAttr['Session-Timeout'],
'maxDailySession' => $userAttr['Max-Daily-Session'],
'expiration' => $userAttr['Expiration']
]);
}
$content_generation = ob_get_clean();
109,12 → 117,18
*/
function formatTime($time)
{
$days = floor($time / 86400); $reste = $time % 86400;
$hours = floor($reste / 3600); $reste = $reste % 3600;
$minutes = floor($reste / 60);
$secondes = $reste % 60;
$days = floor($time / 86400); $rest = $time % 86400;
$hours = floor($rest / 3600); $rest = $rest % 3600;
$minutes = floor($rest / 60);
$secondes = $rest % 60;
 
return "$days J $hours H $minutes min $secondes s";
$result = '';
if ($days != 0) $result .= $days.' J ';
if ($hours != 0) $result .= $hours.' H ';
if ($minutes != 0) $result .= $minutes.' m ';
if ($secondes != 0) $result .= $secondes.' s ';
 
return $result;
}
 
/**