Location: PHPKode > projects > DaloRADIUS > daloradius-0.9-8/acct-maintenance-delete.php
<?php 
/*
 *********************************************************************************************************
 * daloRADIUS - RADIUS Web Platform
 * Copyright (C) 2007 - Liran Tal <hide@address.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 <hide@address.com>
 *
 *********************************************************************************************************
 */
 
    include ("library/checklogin.php");
    $operator = $_SESSION['operator_user'];

	include('library/check_operator_perm.php');

	isset($_REQUEST['enddate']) ? $enddate = $_REQUEST['enddate'] : $enddate = "";
	isset($_REQUEST['startdate']) ? $startdate = $_REQUEST['startdate'] : $startdate = "";
	isset($_REQUEST['username']) ? $username = $_REQUEST['username'] : $username = "";

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

	if (isset($_POST['submit'])) {

		if ( (trim($startdate) != "") || (trim($enddate) != "") || (trim($username) != "") ) {
			
			include 'library/opendb.php';

			$deleteUsername = "";
			if (trim($username) != "")
				$deleteUsername = " AND Username='$username'";

			$deleteEnddate = "";
			if (trim($enddate) != "")
				$deleteEnddate = " AND AcctStartTime<'".$dbSocket->escapeSimple($enddate)."'";

			$deleteStartdate = "";
			if (trim($startdate) != "")
				$deleteStartdate = " AND AcctStartTime>'".$dbSocket->escapeSimple($startdate)."'";


			$sql = "DELETE FROM ".$configValues['CONFIG_DB_TBL_RADACCT'].
				" WHERE 1=1".
				" $deleteStartdate".
				" $deleteEnddate".
				" $deleteUsername ";
			$res = $dbSocket->query($sql);
			$logDebugSQL .= $sql . "\n";

			$successMsg = "Deleted records between <b>$startdate</b> to <b>$enddate</b> for user <b>$username</b>";
			$logAction .= "Successfully deleted records between [$startdate] and [$enddate] for user [$username] on page: ";

			include 'library/closedb.php';

		}  else { 
			$failureMsg = "no username, ending date or starting date was provided, please at least one of those";
			$logAction .= "Failed deleting records from database, missing fields on page: ";
		}

	}


	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 xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<title>daloRADIUS</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>
 
<?php
	include ("menu-accounting-maintenance.php");	
?>

	<div id="contentnorightbar">
		
		<h2 id="Intro"><a href="#" onclick="javascript:toggleShowDiv('helpPage')"><?php echo $l['Intro']['acctmaintenancedelete.php'] ?>
		<h144>+</h144></a></h2>
		
		<div id="helpPage" style="display:none;visibility:visible" >
			<?php echo $l['helpPage']['acctmaintenancedelete'] ?>
			<br/>
		</div>
		<?php
			include_once('include/management/actionMessages.php');
		?>
		
		<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
        <fieldset>

			<h302> <?php echo $l['title']['DeleteRecords'] ?> </h302>
			<br/>

			<label for='username' class='form'><?php echo $l['all']['Username']?></label>
			<input name='username' type='text' id='username' value='<?php echo $username ?>' tabindex=100 />
			<br />

			<label for='startdate' class='form'><?php echo $l['all']['StartingDate']?></label>
			<input name='startdate' type='text' id='startdate' value='<?php echo $startdate ?>' tabindex=100 />
			<img src="library/js_date/calendar.gif" onclick=
			"showChooser(this, 'startdate', 'chooserSpan', 1950, 2010, 'Y-m-d h:i:s', true);" >
			<br />

			<label for='enddate' class='form'><?php echo $l['all']['EndingDate']?></label>
			<input name='enddate' type='text' id='enddate' value='<?php echo $enddate ?>' tabindex=100 />
			<img src="library/js_date/calendar.gif" onclick=
			"showChooser(this, 'enddate', 'chooserSpan', 1950, 2010, 'Y-m-d h:i:s', true);" >
			<br />

			<br/><br/>
			<hr><br/>
			<input type="submit" name="submit" value="<?php echo $l['buttons']['apply'] ?>" tabindex=1000 class='button' />

	</fieldset>

	<div id="chooserSpan" class="dateChooser select-free" 
		style="display: none; visibility: hidden; width: 160px;">
	</div>

	</form>

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

		</div>

		<div id="footer">

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


		</div>

</div>
</div>


</body>
</html>





Return current item: DaloRADIUS