WebSVN – ALCASAR – Diff – /web/acc/manager/htdocs/ticket_voucher.php


<?php
/**
 * Print tickets of new users
 *
 * @author    Tom Houdayer
 * @copyright Copyright (C) ALCASAR (http://www.alcasar.net)
 * @license   GPL-3.0
 * @version   $Id: ticket_voucher.php 2311 2017-06-26 15:04:47Z tom.houdayer $
 */
 
require_once __DIR__ . '/../lib/alcasar/TicketsGenerator.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';
if ($config['sql_use_operators'] === 'true') {
	require_once '../lib/operators.php';
}
 
 
// Get datas from form
if ((!isset($_POST['nbtickets'])) || (!is_numeric($_POST['nbtickets']))){
	header('Location: voucher_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';
 
 
 
 
 
 
 
 
if ($config['sql_use_operators'] === 'true') {
	$text      = ',op';
	$passwd_op = ",':='";
}
 
// Connect to database
$link = da_sql_pconnect($config);
if (!$link) {
	exit('ERR_DATABASE_CONNECT');
}
 
$nbFailUsers = 0;
 
 
 
// Generate tickets
$ticketsGenerator = new TicketsGenerator(['language' => $langue_imp]);
 
 
for ($i = 0; $i < $nbTickets; $i++) {
	// Generate username and password
	$login  = generateRandomString(8);
	$passwd = generateRandomString(12);
	$password = $passwd;
	
	// Check user exist
	require '../lib/'.$config['general_lib_type'].'/user_info.php';
	if ($user_exists === 'yes') {
		$nbFailUsers++;
		continue;
	}
 
	// 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
	$ticketsGenerator->addTicket([
		'username'        => $login,
		'password'        => $password,
		'maxAllSession'   => $mas_imp,
		'sessionTimeout'  => $sto_imp,
		'maxDailySession' => $mds_imp,
		'expiration'      => $exp_imp
	]);
}
 
 
// Generate the PDF
$ticketsGenerator->output();
 
 
/**
 * Format time in seconds to days/hours/minutes/secondes.
 *
 * @param int $time Time in seconds.
 *
 * @return string Formated time.
 */
function formatTime($time)
{
	$days     = floor($time / 86400); $reste = $time  % 86400;
	$hours    = floor($reste / 3600); $reste = $reste % 3600;
	$minutes  = floor($reste / 60);
	$secondes = $reste % 60;
 
	return "$days J $hours H $minutes min $secondes s";
}
 
/**
 * Generate a random string.
 *
 * @param int $length Length of the string.
 *
 * @return string Random string.
 */
function generateRandomString($length = 8)
{
	$string  = '';
	$chars   = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
	$randoms = openssl_random_pseudo_bytes($length);
	for ($i = 0; $i < $length; $i++) {
		$string .= $chars[ord($randoms[$i]) % 62];
	}
	return $string;
}
 

Rev 2285	Rev 2311
1	`<?php`	1	`<?php`
2	`/**`	2	`/**`
3	`* Print tickets of new users`	3	`* Print tickets of new users`
4	`*`	4	`*`
5	`* @author Tom Houdayer`	5	`* @author Tom Houdayer`
6	`* @copyright Copyright (C) ALCASAR (http://www.alcasar.net)`	6	`* @copyright Copyright (C) ALCASAR (http://www.alcasar.net)`
7	`* @license GPL-3.0`	7	`* @license GPL-3.0`
8	`* @version $Id: ticket_voucher.php 2285 2017-06-20 08:15:55Z tom.houdayer $`	8	`* @version $Id: ticket_voucher.php 2311 2017-06-26 15:04:47Z tom.houdayer $`
9	`*/`	9	`*/`
10		10
11	`require_once __DIR__ . '/../lib/alcasar/TicketsGenerator.php';`	11	`require_once __DIR__ . '/../lib/alcasar/TicketsGenerator.php';`
12	`require_once '/etc/freeradius-web/config.php';`	12	`require_once '/etc/freeradius-web/config.php';`
13	`require_once '../lib/sql/drivers/'.$config['sql_type'].'/functions.php';;`	13	`require_once '../lib/sql/drivers/'.$config['sql_type'].'/functions.php';;`
14	`require_once '../lib/attrshow.php';`	14	`require_once '../lib/attrshow.php';`
15	`require_once '../lib/defaults.php';`	15	`require_once '../lib/defaults.php';`
16	`require_once '../lib/functions.php';`	16	`require_once '../lib/functions.php';`
17	`if ($config['sql_use_operators'] === 'true') {`	17	`if ($config['sql_use_operators'] === 'true') {`
18	`require_once '../lib/operators.php';`	18	`require_once '../lib/operators.php';`
19	`}`	19	`}`
20		20
21		21
22	`// Get datas from form`	22	`// Get datas from form`
23	`if ((!isset($_POST['nbtickets'])) \|\| (!is_numeric($_POST['nbtickets']))){`	23	`if ((!isset($_POST['nbtickets'])) \|\| (!is_numeric($_POST['nbtickets']))){`
24	`header('Location: voucher_new.php');`	24	`header('Location: voucher_new.php');`
25	`exit();`	25	`exit();`
26	`}`	26	`}`
27	`$nbTickets = (int)$_POST['nbtickets'];`	27	`$nbTickets = (int)$_POST['nbtickets'];`
28	`$langue_imp = ((isset($_POST['langue_imp'])) ? $_POST['langue_imp'] : 'en');`	28	`$langue_imp = ((isset($_POST['langue_imp'])) ? $_POST['langue_imp'] : 'en');`
29	`require_once __DIR__ . '/../lib/langues_imp.php';`	29	`require_once __DIR__ . '/../lib/langues_imp.php';`
30	`require_once __DIR__ . '/../lib/langues.php';`	30	`require_once __DIR__ . '/../lib/langues.php';`
31		31
32	`if ($config['general_lib_type'] === 'sql' && $config['sql_use_operators'] === 'true') {`	-
33	`$show_ops = 1;`	-
34	`$colspan = 2;`	-
35	`} else {`	-
36	`$show_ops = 0;`	-
37	`$colspan = 1;`	-
38	`}`	-
39	`if ($config['sql_use_operators'] === 'true') {`	32	`if ($config['sql_use_operators'] === 'true') {`
40	`$text = ',op';`	33	`$text = ',op';`
41	`$passwd_op = ",':='";`	34	`$passwd_op = ",':='";`
42	`}`	35	`}`
43		36
44	`// Connect to database`	37	`// Connect to database`
45	`$link = da_sql_pconnect($config);`	38	`$link = da_sql_pconnect($config);`
46	`if (!$link) {`	39	`if (!$link) {`
47	`exit('ERR_DATABASE_CONNECT');`	40	`exit('ERR_DATABASE_CONNECT');`
48	`}`	41	`}`
49		42
50	`$nbFailUsers = 0;`	43	`$nbFailUsers = 0;`
51		44
52		45
53		46
54	`// Generate tickets`	47	`// Generate tickets`
55	`$ticketsGenerator = new TicketsGenerator(['language' => $langue_imp]);`	48	`$ticketsGenerator = new TicketsGenerator(['language' => $langue_imp]);`
56		49
57		50
58	`for ($i = 0; $i < $nbTickets; $i++) {`	51	`for ($i = 0; $i < $nbTickets; $i++) {`
59	`// Generate username and password`	52	`// Generate username and password`
60	`$login = generateRandomString(8);`	53	`$login = generateRandomString(8);`
61	`$passwd = generateRandomString(12);`	54	`$passwd = generateRandomString(12);`
62	`$password = $passwd;`	55	`$password = $passwd;`
63		56
64	`// Check user exist`	57	`// Check user exist`
65	`require '../lib/'.$config['general_lib_type'].'/user_info.php';`	58	`require '../lib/'.$config['general_lib_type'].'/user_info.php';`
66	`if ($user_exists === 'yes') {`	59	`if ($user_exists === 'yes') {`
67	`$nbFailUsers++;`	60	`$nbFailUsers++;`
68	`continue;`	61	`continue;`
69	`}`	62	`}`
70		63
71	`// Create user in database`	64	`// Create user in database`
72	`require '../lib/'.$config['general_lib_type'].'/create_user.php';`	65	`require '../lib/'.$config['general_lib_type'].'/create_user.php';`
73		66
74	`// Get group infos`	67	`// Get group infos`
75	`if ((isset($group)) && ($group !== '')) {`	68	`if ((isset($group)) && ($group !== '')) {`
76	`$loginUser = $login;`	69	`$loginUser = $login;`
77	`$login = $group;`	70	`$login = $group;`
78	`require '../lib/sql/group_info.php';`	71	`require '../lib/sql/group_info.php';`
79	`$login = $loginUser;`	72	`$login = $loginUser;`
80	`}`	73	`}`
81		74
82	`// Format datas`	75	`// Format datas`
83	`$sto_imp = (($sto_imp === '') ? $l_unlimited : formatTime($sto_imp));`	76	`$sto_imp = (($sto_imp === '') ? $l_unlimited : formatTime($sto_imp));`
84	`$mas_imp = (($mas_imp === '') ? $l_unlimited : formatTime($mas_imp));`	77	`$mas_imp = (($mas_imp === '') ? $l_unlimited : formatTime($mas_imp));`
85	`$mds_imp = (($mds_imp === '') ? $l_unlimited : formatTime($mds_imp));`	78	`$mds_imp = (($mds_imp === '') ? $l_unlimited : formatTime($mds_imp));`
86	`$mms_imp = (($mms_imp === '') ? $l_unlimited : formatTime($mms_imp));`	79	`$mms_imp = (($mms_imp === '') ? $l_unlimited : formatTime($mms_imp));`
87	`$exp_imp = (($Expiration === '') ? $l_without : date('d - m - Y', strtotime($Expiration)));`	80	`$exp_imp = (($Expiration === '') ? $l_without : date('d - m - Y', strtotime($Expiration)));`
88		81
89	`// Add user`	82	`// Add user`
90	`$ticketsGenerator->addTicket([`	83	`$ticketsGenerator->addTicket([`
91	`'username' => $login,`	84	`'username' => $login,`
92	`'password' => $password,`	85	`'password' => $password,`
93	`'maxAllSession' => $mas_imp,`	86	`'maxAllSession' => $mas_imp,`
94	`'sessionTimeout' => $sto_imp,`	87	`'sessionTimeout' => $sto_imp,`
95	`'maxDailySession' => $mds_imp,`	88	`'maxDailySession' => $mds_imp,`
96	`'expiration' => $exp_imp`	89	`'expiration' => $exp_imp`
97	`]);`	90	`]);`
98	`}`	91	`}`
99		92
100		93
101	`// Generate the PDF`	94	`// Generate the PDF`
102	`$ticketsGenerator->output();`	95	`$ticketsGenerator->output();`
103		96
104		97
105	`/**`	98	`/**`
106	`* Format time in seconds to days/hours/minutes/secondes.`	99	`* Format time in seconds to days/hours/minutes/secondes.`
107	`*`	100	`*`
108	`* @param int $time Time in seconds.`	101	`* @param int $time Time in seconds.`
109	`*`	102	`*`
110	`* @return string Formated time.`	103	`* @return string Formated time.`
111	`*/`	104	`*/`
112	`function formatTime($time)`	105	`function formatTime($time)`
113	`{`	106	`{`
114	`$days = floor($time / 86400); $reste = $time % 86400;`	107	`$days = floor($time / 86400); $reste = $time % 86400;`
115	`$hours = floor($reste / 3600); $reste = $reste % 3600;`	108	`$hours = floor($reste / 3600); $reste = $reste % 3600;`
116	`$minutes = floor($reste / 60);`	109	`$minutes = floor($reste / 60);`
117	`$secondes = $reste % 60;`	110	`$secondes = $reste % 60;`
118		111
119	`return "$days J $hours H $minutes min $secondes s";`	112	`return "$days J $hours H $minutes min $secondes s";`
120	`}`	113	`}`
121		114
122	`/**`	115	`/**`
123	`* Generate a random string.`	116	`* Generate a random string.`
124	`*`	117	`*`
125	`* @param int $length Length of the string.`	118	`* @param int $length Length of the string.`
126	`*`	119	`*`
127	`* @return string Random string.`	120	`* @return string Random string.`
128	`*/`	121	`*/`
129	`function generateRandomString($length = 8)`	122	`function generateRandomString($length = 8)`
130	`{`	123	`{`
131	`$string = '';`	124	`$string = '';`
132	`$chars = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';`	125	`$chars = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';`
133	`$randoms = openssl_random_pseudo_bytes($length);`	126	`$randoms = openssl_random_pseudo_bytes($length);`
134	`for ($i = 0; $i < $length; $i++) {`	127	`for ($i = 0; $i < $length; $i++) {`
135	`$string .= $chars[ord($randoms[$i]) % 62];`	128	`$string .= $chars[ord($randoms[$i]) % 62];`
136	`}`	129	`}`
137	`return $string;`	130	`return $string;`
138	`}`	131	`}`
139		132

Subversion Repositories ALCASAR

(root)/web/acc/manager/htdocs/ticket_voucher.php @ 2388 – Rev 2285 → 2311