Subversion Repositories ALCASAR

<?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 2698 2019-02-05 10:25:12Z tom.houdayer $

 */

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 __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 __DIR__ . '/../lib/operators.php';

	$text      = ',op';

	$passwd_op = ",':='";

}

// Get datas from form

if ((!isset($_POST['nbtickets'])) || (!is_numeric($_POST['nbtickets']))){

	header('Location: user_new.php');

	exit();

}

$nbTickets = (int)$_POST['nbtickets'];

// 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];

	}

}

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'];

				}

			}

		}

	}

}

// 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

	$username = generateRandomString(8);

	$password = generateRandomString(12);

	// 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';

	// Add user ticket

	$ticketsGenerator->addTicket([

		'username'        => $username,

		'password'        => $password,

		'maxAllSession'   => $userAttr['Max-All-Session'],

		'sessionTimeout'  => $userAttr['Session-Timeout'],

		'maxDailySession' => $userAttr['Max-Daily-Session'],

		'expiration'      => $userAttr['Expiration']

	]);

}

$content_generation = ob_get_clean();

// Generate the PDF

$ret = $ticketsGenerator->output();

if (!$ret) {

	echo $content_generation;

	echo 'Error during tickets report generation';

}

/**

 * 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); $rest = $time % 86400;

	$hours    = floor($rest /  3600); $rest = $rest %  3600;

	$minutes  = floor($rest /    60);

	$secondes = $rest % 60;

	$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;

}

/**

 * 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;

}