Location: PHPKode > projects > phpMyPrepaid > phpmyprepaid/www/include/display/OtherAccounts.php
<?php
/*     This file is used to display all cards that have been created
	It is expected that in production, this feature will be rather
	useless because of the number of accounts that will build up
	over time.  Some sort of method for clearing old accounts will
	need to be implemented.  For now, AllCards is the first step
	in building a reporting system.

	This file Trappe Vincent 2006 and released under the GPL.
	If you didn't get a copy of the GPL with this, do a search for
	GPL and find it your self.  Remember, I copyrighted this so if
	you are using it you better have a license to use it.  GPl 
	works for me.
//////////////////////////////////////////////////////////
//      THIS SCRIPT DISPLAYS ACCOUNTS FOR A LOCATION    //
//      First we pull the session location ID and then  //
//      use it to pull the correct cards.               //
//      we use the button ID to figure out which type   //
//      of cards we want to pull                        //
//////////////////////////////////////////////////////////
*/
  if (isset ($msg))
  {
    unset ($msg);
  }

if (isset ($_SESSION['locID']))
  {
    $loc = $_SESSION['locID'];
  }
$LocName = $_SESSION['LocName'];

if (!isset ($buttonID))
  {
    $msg = "$msg <p class=\"error\">No button ID was sent</p>";	// this shouldn't happen
  }

if (!isset ($msg))
  {				// no errors? ...  hit it.  Need to reset button id

?><script type="text/javascript" > 
function sendButton(button)
{
      var j=0;
      var tab=new Array();
      var form=document.getElementById('event_id');
      var str='';
      var str2='';
      var strf='';
      for (var i = 0; i < form.length; i++) {
	      if (form[i].checked) {
		      tab[j]=form[i].value;
		      str+=form[i].value+',';
		      j++;

	      }
      }
      strf=str.substring(0,str.length-1);
     if (button.name=='print_html')
     {
	     formau=document.getElementById('print_form_html');
	     str2='<input type="hidden" name="id" value="'+strf+'">';

	     document.getElementById('tab_acct_html').innerHTML=str2;
	     formau.submit();
     }
     if (button.name=='print_pdf')
     {
	     formau=document.getElementById('print_form_pdf');
	     str2='<input type="hidden" name="id" value="'+strf+'">';
	     document.getElementById('tab_acct_pdf').innerHTML=str2;
	     formau.submit();
     }

     if (button.name=='print_cards')
     {
	     formau=document.getElementById('print_form_cards');
	     str2='<input type="hidden" name="id" value="'+strf+'">';
	     document.getElementById('tab_acct_cards').innerHTML=str2;
	     formau.submit();
     }

     if (button.name=='add_unit')
     {
	     formau=document.getElementById('add_unit_form');
	     str2='<input type="hidden" name="id" value="'+strf+'">';
	     document.getElementById('tab_acct').innerHTML=str2;
	     formau.submit();
     }

     if (button.name=='delete_btn')
	{
     	var text=file('include/divers/delete_accts.php?id='+strf); 
     	alert(text);
	form.submit();	
	}
}

function toggleCheck (element, name)
    {
      var form = document.getElementById('event_id');
      //var form = element.form;
      var checked = element.checked;
      for (var i = 0; i < form.length; i++)
	if (form[i].name.indexOf (name) == 0)
	  form[i].checked = !form[i].checked;
      //form.delete_btn.disabled = !checked;
     document.getElementById('delete_btn').disabled = !checked;
     document.getElementById('add_unit').disabled = !checked;
     document.getElementById('print_pdf').disabled = !checked;
     document.getElementById('print_html').disabled = !checked;
     document.getElementById('print_cards').disabled = !checked;

    }

function configureButton (element, name)
    {
      var form = document.getElementById('event_id');
      var checked = element.checked;
      if (!checked)
      {
	  for (var i = 0; i < form.length; i++)
	    {
	      if (form.elements[i].name.indexOf (name) == 0)
		{
		  if (form.elements[i].checked)
		    {
		      checked = true;
		      break;
		    }
		}
	    }
	}
      if (!element.checked) {
	      tc=document.getElementById('toggle_check');

	      tc.checked = false;
      }
     document.getElementById('delete_btn').disabled = !checked;
     document.getElementById('print_pdf').disabled = !checked;
     document.getElementById('print_html').disabled = !checked;
     document.getElementById('print_cards').disabled = !checked;
     document.getElementById('add_unit').disabled = !checked;
    }
    </script> 
    <? 
    if (isset ($_POST['userdelete']))
      delete_user ($_POST['userdelete']);

    if (isset ($_POST['limit_view']))
      $limit = $limit_view = $_POST['limit_view'];
    else if (isset ($_GET['limit_view']))
      $limit = $limit_view = $_GET['limit_view'];
    else
      {
	$limit = $limit_view = 10;
      }				// <-- Hook for later feature
    if (isset ($_GET['bpcname']))
      $bpname = $_GET['bpcname'];

    // Moving through pages now works even when sorted. FIXED - SWong
    // Retrieve GET data from next/previous buttons
    if (isset ($_GET['s']))
      {
	$s = $_GET['s'];
      }
    if (isset ($_GET['so']))
      {
	$so = $_GET['so'];
      }

    // Default to sorting by UserName else set to previous
    if (!isset ($so))
      {
	$sort = "UserName";
      }
    else
      {
	$sort = $so;
      }

    // Change the sort order if the user selected a column heading
    if (isset ($_POST['FirstName']))
      {
	$sort = 'FirstName';
      }
    if (isset ($_POST['LastName']))
      {
	$sort = 'LastName';
      }
    if (isset ($_POST['used']))
      {
	$sort = 'TotalSessionTime';
      }
    if (isset ($_POST['CrDate']))
      {
	$sort = 'CrDate';
      }
    if (isset ($_POST['UserName']))
      {
	$sort = 'UserName';
      }				// all this needs to be fixed
    if (isset ($_POST['AcctStartTime']))
      {
          $sort = 'AcctStartTime';
      }
    if (isset ($_POST['FramedIPAddress']))
      {
          $sort = 'FramedIPAddress';
      }
    if (isset ($_POST['NASIPAddress']))
      {
          $sort = 'NASIPAddress';
      }

    // Update current sort order
    $so = $sort;


    if (isset ($_POST['findAccountName']))
    {
        $username = $_POST['findAccountName'];
        if ($username!='')
        $usrn="AND userinfo.Username  REGEXP ('$username') ";
    }
    if (isset ($_POST['billing_plan_select']))
      $bpname = $_POST['billing_plan_select'];

    if (isset ($_POST['activate']))
      $activate = $_POST['activate'];

    if (isset ($_GET['radiusprofile'])) {
        $radiusprofile = $_GET['radiusprofile'];
        if ($radiusprofile != 'All' and $radiusprofile!='')
        $radiusprofileq = " AND RadiusProfile='".get_radiusprofile_id($radiusprofile)."'";
    }

    if (isset ($_GET['group'])) {
         $group = $_GET['group'];
         $groupdb='';
         $groupq='';
         $groupj='';
         if ($group != 'All' and $group!='') {
                   $groupdb="usergroup,";
                   $groupq = " AND usergroup.GroupName='".$_GET['group']."' ";
                   $groupj = " AND usergroup.UserName=userinfo.UserName ";

           }

   }

    if (isset ($_POST['radiusprofile_select'])) {
        $radiusprofile = $_POST['radiusprofile_select'];
        if ($radiusprofile != 'All')
        $radiusprofileq = " AND RadiusProfile='".get_radiusprofile_id($radiusprofile)."'";
    }

    if (isset ($_POST['group_select'])) {
         $group = $_POST['group_select'];
         $groupdb='';
         $groupq='';
         $groupj='';
         if ($group != 'All') {
                   $groupdb="usergroup,";
                   $groupq = " AND usergroup.GroupName='".$_POST['group_select']."' ";
                   $groupj = " AND usergroup.UserName=userinfo.UserName ";

           }

   }

    if (isset ($_POST['crdate_select']))
      {
	$crdate = $_POST['crdate_select'];
	if ($crdate == 'All')
	  $crdatedata = "";
	else
	  $crdatedata = " AND CrDate='$crdate'";
      } 
    else if ($_GET['crdate_select'])
          {
          $crdate = $_GET['crdate_select'];
          if ($crdate == 'All')
            $crdatedata = "";
          else
           $crdatedata = " AND CrDate='$crdate'";
	  }



//////////////////////////////////////////////////////////////////
//USEFUL BUTTON 
//////////////////////////////////////////////////////////////////
if ($buttonID=='unused_account') 
    echo "All unused Accounts listed for $LocName <br><br> ";
if ($buttonID=='partialy_account') 
    echo "All partialy Accounts listed for $LocName <br><br> ";
if ($buttonID=='week_users') 
    echo "All accounts connected this week for $LocName <br><br> ";
if ($buttonID=='today_users') 
    echo "All accounts connected today for $LocName <br><br> ";
if ($buttonID=='month_users') 
    echo "All accounts connected this month for $LocName <br><br> ";

    echo "<table width=100%>";
    echo ('<tr >');
    echo ('<form name="cfbp" action="phpmyprepaid.php" method="post">');
    echo ("<input type=\"hidden\" name=\"buttonID\" value='$buttonID'>");
    echo ("<input type=\"hidden\" name=\"actionf\" value=\"billing_plan\">");
    echo ('<td width="100" style="text-align: left">');
    if (isset ($username))
      echo
	"<input type=text size=17 class=text value=\"$username\" name=\"findAccountName\">";
    else
      echo
	"<input type=text size=17 class=text value=\"\" name=\"findAccountName\">";
    echo ('</td>');
    echo (' <td style="height: 33px; width: 33px; text-align: left;">
	  <input class="image" name="FindAccount" alt="Find account" title="Find account" src="images/search.png" value="" height="25" type="image">');
    echo ("<input type=\"hidden\" name=\"buttonID\" value='$buttonID'>");
    echo '</td><td  style="width=100px; text-align: right">Display view :';
    echo ('</td>');
    echo ('<td style="text-align: left">');
    $tab = array ('10', '20', '30', '50', '100', '150', '300', 'All');
    echo '<select name="limit_view" onChange="document.cfbp.submit();">';
    for ($i = 0; $i < sizeof ($tab); $i++)
      if ($limit_view == $tab[$i])
	echo '<option "selected" value="'.$tab[$i].'">'.$tab[$i].'</option>';
      else
	echo '<option value="'.$tab[$i].'">'.$tab[$i].'</option>';
    echo ('</select>');
    echo ('</td></tr></table><br>');
    echo ('<table><tr><td width="170">');
    echo ' Choose Billing plan :';
    echo ('</td>');

    echo ('<td width="200" style="align: left;">');
    echo
      '<select name="billing_plan_select" onChange="document.cfbp.submit();">';
    $q1 = "select Id,NameBp,TimeBp,PriceBp,TypeBp,CurrencyBp From BillingPlan WHERE LocationID='".$_SESSION['locID']."' ORDER BY NameBp";	// get all the timed cards
    $result = $oreon->database->database->query ($q1);
    if ($bpname == '' or $bpname == 'All')
      echo '<option "selected" value="All">All';
    else
      echo '<option  value="All">All';
    echo '</option>';

    while ($row = $oreon->database->database->fetch_object ($result))
      {
	if ($row->NameBp == $bpname)
	  echo '<option "selected" value="'.$row->NameBp.'">'.$row->NameBp;
	else
	  echo '<option value="'.$row->NameBp.'">'.$row->NameBp;
	echo '</option>';
      }
    echo ('</select>');
    echo ('</td>');
    echo ('<td>');
    echo ('<td >');
    echo 'Creation date :';
    echo ('</td>');
    echo ('<td style="text-align: left;">');
    $result2 =
      $oreon->database->database->
      query ("SELECT CrDate From userinfo Where LocationID='".
	     $_SESSION['locID']."' GROUP BY CrDate ORDER BY CrDate");
    echo '<select name="crdate_select" onChange="document.cfbp.submit();">';
    if ($crdate == '' or $crdate == 'All')
      echo '<option "selected" value="All">All</option>';
    else
      echo '<option  value="All">All</option>';
    while ($row = $oreon->database->database->fetch_object ($result2))
      {
	if ($row->CrDate == $crdate)
	  echo '<option "selected" value="'.$row->CrDate.'">'.$row->CrDate.
	    '</option>';
	else
	  echo '<option value="'.$row->CrDate.'">'.$row->CrDate.'</option>';
      }
   echo ('</select>');
    echo ('</td></tr></table>');
    echo ('<table><tr><td width="170">');
    echo ' Radius Profile :';
    echo ('</td>');

    echo ('<td width="200" style="align: left;">');
    echo '<select name="radiusprofile_select" onChange="document.cfbp.submit();">';
    $q1 = "select id,RadiusProfileName  From radiusprofile WHERE location_id='".$_SESSION['locID']."' GROUP BY RadiusProfileName ORDER BY RadiusProfileName";	// get all the timed cards
    $result = $oreon->database->database->query ($q1);
    if ($radiusprofile == '' or $radiusprofile == 'All')
      echo '<option "selected" value="All">All';
    else
      echo '<option  value="All">All';
    echo '</option>';

    while ($row = $oreon->database->database->fetch_object ($result))
      {
	if ($row->RadiusProfileName == $radiusprofile)
	  echo '<option "selected" value="'.$row->RadiusProfileName.'">'.$row->RadiusProfileName;
	else
	  echo '<option value="'.$row->RadiusProfileName.'">'.$row->RadiusProfileName;
	echo '</option>';
      }
    echo ('</select>');
    echo ('</td>');
    echo ('<td >');
    echo 'Group :';
    echo ('</td>');
    echo ('<td style="text-align: left;">');
     $result2=$oreon->database->database->query("SELECT ID,gp_name FROM group_template WHERE location_id='".$_SESSION['locID']."'");
    echo '<select name="group_select" onChange="document.cfbp.submit();">';
    if ($group == '' or $group == 'All')
      echo '<option "selected" value="All">All</option>';
    else
      echo '<option  value="All">All</option>';
    while ($row = $oreon->database->database->fetch_object ($result2))
      {
	if ($row->gp_name == $group)
	  echo '<option "selected" value="'.$row->gp_name.'">'.$row->gp_name.
	    '</option>';
	else
		echo '<option value="'.$row->gp_name.'">'.$row->gp_name.'</option>';
      }
    echo ('</select>');
    echo ('</td></tr></table>');
    echo ('<table width=100%><tr><td width="170">');
    echo ('</td></tr></table><br><table><tr><td>');
    if ($activate == '-1')
      {
	$activatedata = "";
	echo
	  '<input type="radio" checked name="activate" value="-1" onChange="document.cfbp.submit();"> All ';
      }
    else
      echo
	'<input type="radio" checked name="activate" value="-1" onChange="document.cfbp.submit();"> All ';

    if ($activate == '1')
      {

	$activatedata = " AND activated='1' ";
	echo
	  '<input checked type="radio" name="activate" value="1" onChange="document.cfbp.submit();"> Activate';
      }
    else
      echo
	'<input type="radio" name="activate" value="1" onChange="document.cfbp.submit();"> Activate';

    if ($activate == '0')
      {
	$activatedata = " AND activated='0' ";
	echo
	  ' <input type="radio" checked name="activate" value="0" onChange="document.cfbp.submit();"> Not activate';
      }
    else
      echo
	' <input type="radio" name="activate" value="0" onChange="document.cfbp.submit();"> Not activate';

    echo ("</table></td></tr>");
    echo "</table>";
    echo '</form>';


   //////////////////////////////////////////////////////////////////
   // USED FOR SET THE SORT VALUE
   //////////////////////////////////////////////////////////////////
    if (!isset ($so))
      {
	$sort = "UserName";
      }
    if (isset ($_POST['UserName']))
      {
	$sort = 'UserName';
      }				// all this needs to be fixed
    if (isset ($_POST['BillingPlan']))
      {
	$sort = 'BillingPlan';
      }
    if (isset ($_POST['SessionTime']))
      {
	$sort = 'AcctSessionTime';
      }
    //if(isset($_POST['LastName'])) { $sort = 'LastName';} NOT USED ONLY IN SUBSCR
    if (isset ($_POST['CrDate']))
      {
	$sort = 'CrDate';
      }
    if (isset ($_POST['activeDate']))
      {
	$sort = 'activeDate';
      }
    if (isset ($_POST['Value']))
      {
	$sort = 'Value';
      }
    if (isset ($_POST['TotalSessionTime']))
      {
	$sort = 'TotalSessionTime';
      }
    //    if(!isset($so)) { $sort = "UserName"; }
    $order = 'ORDER by ';
    $groupby = ' GROUP BY userinfo.UserName';


    //    if(isset($addcr)) { $cr = ', CrDate'; }else{ $cr = NULL; }
    if ($bpname != 'All' and $bpname != '')
      $bpnamevalue = "AND BillingPlan='".get_plan_Id ($bpname)."'";
    else
      $bpnamevalue = "";


//////////////////////////////////////////////////////////////
//WE ARE QUERYING THE DATABASE
    //////////////////////////////////////////////////////////////
$y=date('Y');
$m=date('m');
$d=date('d');

if ($buttonID=='unused_account') {
 $q1= "SELECT userinfo.* FROM ".$groupdb."userinfo LEFT JOIN radacct ON userinfo.UserName=radacct.UserName WHERE radacct.Username IS NULL $usrn $groupj AND  LocationID='$loc' $groupq $radiusprofileq $crdatedata $activatedata $bpnamevalue $groupby ORDER BY $sort ";
}
else if  ($buttonID=='partialy_account') {
	$q1 = "SELECT SUM(AcctSessionTime) as TotalSessionTime,SUM(AcctOutputOctets) AS sum_output,activeDate,BillingPlan,userinfo.* FROM ".$groupdb."radacct,userinfo WHERE (radacct.UserName=userinfo.UserName) $usrn $groupj AND LocationID='$loc' $groupq $radiusprofileq $crdatedata $activatedata $bpnamevalue GROUP By userinfo.UserName $order $sort";

}
else if ($buttonID=='week_users') {
    $q1 = "SELECT DISTINCT(radacct.Username), AcctStartTime, NASIPAddress, FramedIPAddress,userinfo.CrDate,userinfo.Type,userinfo.CrDate,userinfo.activeDate,userinfo.BillingPlan  FROM ".$groupdb."radacct,userinfo WHERE radacct.UserName=userinfo.UserName AND (DATE_SUB(CURDATE(),INTERVAL 7 DAY) <= AcctStartTime OR DATE_SUB(CURDATE(),INTERVAL 7 DAY) <= AcctStopTime) AND LocationID='$loc' $groupq $radiusprofileq $crdatedata $activatedata $bpnamevalue  GROUP BY radacct.UserName ORDER BY $sort";

}
else if ($buttonID=="today_users") {
    if ((!isset($fromdate)) or ($fromdate==''))
         $start=$y."-".$m."-$d 00:00:00";

    if ((!isset($todate)) or ($todate==''))
                $stop=date("Y-m-d")." 23:59:59";


    $q1 = "SELECT DISTINCT(radacct.Username),AcctStartTime, NASIPAddress, FramedIPAddress,userinfo.CrDate,userinfo.Type,userinfo.CrDate,userinfo.BillingPlan FROM ".$groupdb."radacct,userinfo WHERE  radacct.UserName=userinfo.UserName AND LocationID='$loc' AND AcctStopTime>='$start' AND AcctStopTime<='$stop' $groupq  $radiusprofileq $crdatedata $activatedata $bpnamevalue GROUP BY radacct.UserName ORDER BY $sort";

}
else if ($buttonID=="month_users") {
    if ((!isset($fromdate)) or ($fromdate==''))
         $start=$y."-".$m."-01 00:00:00";

    if ((!isset($todate)) or ($todate==''))
         $stop=date("Y-m-d")." 23:59:59";


    $q1 = "SELECT DISTINCT(radacct.Username),AcctStartTime, NASIPAddress, FramedIPAddress,userinfo.CrDate,userinfo.Type,userinfo.CrDate,userinfo.BillingPlan  FROM ".$groupdb."radacct,userinfo WHERE  radacct.UserName=userinfo.UserName AND LocationID='$loc' AND AcctStopTime>='$start' AND AcctStopTime<='$stop' $groupq  $radiusprofileq $crdatedata $activatedata $bpnamevalue  GROUP BY radacct.UserName ORDER BY $sort";

}

    if ($debug)
      echo " DISPLAY ".$q1;
    if (empty ($s))
      {				// <---- Requires the weird non functional echo above FIXME
	$s = 0;			// <---- I think an if(!isset($s) might work if we pull the GET
      }

//////////////////////////////////////////////////////////////
//DELETE USER AND ADD UNIT 
//////////////////////////////////////////////////////////////
	echo "<table width=100%><tr><td style=\"text-align: right;\">";
	echo "<form  method=\"post\" action=\"include/display/add_unit.php\" id=\"add_unit_form\"  target=\"addunit\" onsubmit=\"window.open('', 'addunit', 'width=400,height=100,status=yes,resizable=yes,scrollbars=yes')\">";
	echo ("<input type=\"hidden\" name=\"phpmyprepaid\" value=\"".session_id ()."\">");
        echo("<input type=\"hidden\" name=\"type\" value=\"$type\">");
	echo("<input type=\"hidden\" name=\"attr\" value=\"$attrr\">");
	echo("<input type=\"hidden\" name=\"dbname\" value=\"$db\">");
	echo ('<div id="tab_acct"></div>');
	printf ('<input class="image" type="image" value="submit" name="add_unit" id="add_unit" disabled alt="Add unit to user" title="Add unit to user" src="images/insertf.png" onClick="sendButton(this)">');
	printf ('</form>');
	echo "</td>";
    	echo "<td style=\"text-align: right; width: 24px\">";
    	echo '<script type="text/javascript">  
			function confirmDelete( btn) { 
	        if(confirm("Are you sure, you want to delete this user ?" )) sendButton(btn);
	          return false; //pour ne pas revenir au début de la page
          	}  
    </script>';

    printf ("<input type=\"hidden\" name=\"buttonID\" value=\"$buttonID\">");
    printf ("<input type=\"hidden\" name=\"userdelete\" value=\"$usernametmp\">");
    printf ('<input class="image" type="image" class="tdimage" value="submit" name="delete_btn" disabled  id="delete_btn" alt="Delete user" title="Delete user" onClick="confirmDelete(this)" src="images/deletef.png" >');
    echo "</td>";
    echo '</tr></table>';

    //////////////////////////////////////////////////////////////////
    /////DISPLAY ACCOUNT BEGIN
    //////////////////////////////////////////////////////////////////
    $result1=$oreon->database->database->query ($q1) or die ("Query database error !");
    $numrows=$oreon->database->database->result_num_rows ($result1);
    if ($limit!='All')
    $q1.=" LIMIT $s,$limit";
    echo "<table border=\"1\" width=\"100%\" >";
    echo "<tr>";
?>
<td width=2% class="text" align="center"><input type="checkbox" name="toggle_check" id="toggle_check" value="1" onClick="toggleCheck( this, 'mark_eids' )";></td > 
<?php 
    echo "<td width=20%>";
    printf ('<form action="phpmyprepaid.php "method="post">');
    printf ("<input type=\"hidden\" name=\"buttonID\" value=\"$buttonID\">");
    printf ("<input type=\"hidden\" name=\"so\" value=\"$so\">");
    printf ("<input type=\"hidden\" name=\"s\" value=\"$s\">");
    printf ("<input type=\"hidden\" name=\"limit\" value=\"$limit\">");
    printf ('<input type="submit" name="UserName" class="smallButton" value=" Username "/>');
    printf ('</form>');
    echo "</td>";
    echo "<td width=\"40\">";
    printf ('<form action="phpmyprepaid.php "method="post">');
    printf ("<input type=\"hidden\" name=\"buttonID\" value=\"$buttonID\">");
    printf ("<input type=\"hidden\" name=\"so\" value=\"$so\">");
    printf ("<input type=\"hidden\" name=\"s\" value=\"$s\">");
    printf ("<input type=\"hidden\" name=\"limit\" value=\"$limit\">");
    printf
      ('<input type="submit" name="BillingPlan" class="smallButton" value="Billing Plan"/>');
    printf ('</form>');
    echo "</td>";
    // echo "<td width=40>";
    //REMOVED NOT USEFUL
    // printf('<form action="phpmyprepaid.php "method="post">');
    // printf("<input type=\"hidden\" name=\"buttonID\" value=\"$buttonID\">");
    // printf("<input type=\"hidden\" name=\"so\" value=\"$so\">");
    // printf("<input type=\"hidden\" name=\"s\" value=\"$s\">");
    // printf('<input type="submit" name="LastName" class="button" value="Last Name"/>');
    // printf('</form>');
    // echo "</td>";

if ($buttonID=='today_users' or $buttonID=='week_users' or $buttonID=='month_users') {
    echo "<td width=\"150\">";
    printf('<form action="phpmyprepaid.php "method="post">');
    printf ("<input type=\"hidden\" name=\"buttonID\" value=\"$buttonID\">");
    printf ("<input type=\"hidden\" name=\"so\" value=\"AcctStartTime\">");
    printf ("<input type=\"hidden\" name=\"s\" value=\"$s\">");
    printf ("<input type=\"hidden\" name=\"limit\" value=\"$limit\">");
    printf ('<input type="submit" name="Connected" class="smallButton" value="Connected"/>');
    printf('</form>');
    echo "</td>";


    echo "<td width=\"150\">";
    printf('<form action="phpmyprepaid.php "method="post">');
    printf ("<input type=\"hidden\" name=\"buttonID\" value=\"$buttonID\">");
    printf ("<input type=\"hidden\" name=\"so\" value=\"FramedIPAddress\">");
    printf ("<input type=\"hidden\" name=\"s\" value=\"$s\">");
    printf ("<input type=\"hidden\" name=\"limit\" value=\"$limit\">");
    printf ('<input type="submit" name="UserIp" class="smallButton" value="User ip"/>');
    printf('</form>');
    echo "</td>";

    echo "<td width=\"150\">";
    printf('<form action="phpmyprepaid.php "method="post">');
    printf ("<input type=\"hidden\" name=\"buttonID\" value=\"$buttonID\">");
    printf ("<input type=\"hidden\" name=\"so\" value=\"NASIPAddress\">");
    printf ("<input type=\"hidden\" name=\"s\" value=\"$s\">");
    printf ("<input type=\"hidden\" name=\"limit\" value=\"$limit\">");
    printf ('<input type="submit" name="NasIp" class="smallButton" value="Nas ip"/>');
    printf('</form>');
    echo "</td>";
}



if ($buttonID=='partialy_account' or $buttonID=='unused_account') {
	echo "<td width=\"150\">";
	printf ('<form action="phpmyprepaid.php "method="post">');
	printf ("<input type=\"hidden\" name=\"buttonID\" value=\"$buttonID\">");
	printf ("<input type=\"hidden\" name=\"so\" value=\"Value\">");
	printf ("<input type=\"hidden\" name=\"s\" value=\"$s\">");
        printf ("<input type=\"hidden\" name=\"limit\" value=\"$limit\">");
	printf ('<input type="submit" name="Value" class="smallButton" value="Value"/>');
	printf ('</form>');
    echo "</td>";
}

if ($buttonID=='partialy_account') {
    echo "<td width=\"150\">";
    //printf('<form action="phpmyprepaid.php "method="post">');
    printf ("<input type=\"hidden\" name=\"buttonID\" value=\"$buttonID\">");
    printf ("<input type=\"hidden\" name=\"so\" value=\"TotalSessionTime\">");
    printf ("<input type=\"hidden\" name=\"s\" value=\"$s\">");
    printf ("<input type=\"hidden\" name=\"limit\" value=\"$limit\">");
    printf ('<input type="submit" name="TotalSessionTime" class="smallButton" value="Used"/>');
    //printf('</form>');
    echo "</td>";
}
else if ($buttonID=='unused_account') {
    echo "<td width=\"150\">";
    printf('<form action="phpmyprepaid.php "method="post">');
    printf ("<input type=\"hidden\" name=\"buttonID\" value=\"$buttonID\">");
    printf ("<input type=\"hidden\" name=\"so\" value=\"TotalSessionTime\">");
    printf ("<input type=\"hidden\" name=\"s\" value=\"$s\">");
    printf ("<input type=\"hidden\" name=\"limit\" value=\"$limit\">");
    printf ('<input type="submit" name="CrDate" class="smallButton" value="Creation date"/>');
    printf('</form>');
    echo "</td>";
}  
if ($buttonID=='partialy_account') {
    echo "<td width=\"40\">";
    printf ('<form action="phpmyprepaid.php "method="post">');
    printf ("<input type=\"hidden\" name=\"buttonID\" value=\"$buttonID\">");
    printf ("<input type=\"hidden\" name=\"so\" value=\"activateDate\">");
    printf ("<input type=\"hidden\" name=\"s\" value=\"$s\">");
    printf ("<input type=\"hidden\" name=\"limit\" value=\"$limit\">");
    printf ('<input type="submit" name="activeDate" class="smallButton" value="Activate Date    "/>');
    printf ('</form>');
    echo "</td>";
}
    echo "</tr>";

    $result1 =
      $oreon->database->database->query ($q1) or die ("Query database error !");
    $count = 1 + $s;		// <-- sets the page number
    if (isset ($_POST['ID']))
      {
	$pullUser = $_POST['ID'];
	unset ($_POST['ID']);
      }

    while ($row = $oreon->database->database->fetch_object ($result1))
    {
 	$BillingPlan=get_plan_name(($row->BillingPlan));
     	$LastName=($row->Lastname);
     	$CrDate=($row->CrDate);
	$ID = ($row->ID);
        $Type=($row->Type);
        $usernametmp = ($row->Username);
	$shade=1;
	$crdate=get_user_crdate($usernametmp);
    	$tab = getaccountvalueType($Type, $octet_type);
    	$db = $tab['db'];
    	$type = $tab['type'];
    	$attr = $tab['attr'];
   	$attrr = $tab['attrr'];


	if (!isset ($shade))
	  {
	    $shade = 2;
	  }
	$array[] = $row;


	if ($type !="Subscription Mac")
	  $Value = round (($row->Value));
	  $activeDate = ($row->activeDate);
	//  $sec = $row->Value;
	//  if($addcr == 1) { $date = ($row->CrDate); } // <--See conf file
	echo ("<tr>");

	$q2 ="SELECT SUM(AcctSessionTime) as TotalSessionTime,SUM($acctoutputoctetsattr) AS sum_output FROM radacct WHERE UserName='$usernametmp'";
	$numresults2 = $oreon->database->database->query ($q2);	// <------ FIGURE OUT HOW MANY RESULTS WE ARE PULLING
	$numrows2 = $oreon->database->database->result_num_rows ($numresults2);
	$res2 = $oreon->database->database->query ($q2) or die ("Query database error !");
	$r2 = $oreon->database->database->fetch_object ($res2);
    $startTime = ($row->AcctStartTime);
    $nasIP = ($row->NASIPAddress);
    $userIP = ($row->FramedIPAddress);

	if ($buttonID!='unused_account') {
	if ($type == "Octets" or $type == "Subscription Octets")
	  $used = round ($r2->sum_output );
	else
		$used = round ($r2->TotalSessionTime );
	if ($used == '')
		$used = '0';
	}
	?><form name="event_form" id="event_id" method="post" action="<?= $PHP_SELF ?>"><?
	?><td align="center" class="text" ><input type="checkbox" name="mark_eids[]" id="mark_eids_tab[]" value="<?print $usernametmp?>" onClick="configureButton( this, 'mark_eids' );" ></td> 
<? 
	if ($shade == 1)
	  {
	    echo ('<td STYLE="background-color: #F2F7FB">');
	  }
	else
	  {
	    echo ('<td STYLE="background-color: #cde5f4">');
	  }

echo ('<input type="button" class="smallButton" name="UserSelected" value="'.$usernametmp.'" onClick="window.open(\'include/divers/sexyTabs.php?phpmyprepaid='.session_id.'&usr='.$usernametmp.'\',\'User informations\',\'width=800,height=600,status=yes,resizable=yes,menubar=yes,scrollbars=yes\');" >');
	echo ("</td><small>");


	if ($shade == 1)
	  {
	    echo ('<td STYLE="background-color: #F2F7FB"><small>');
	  }
	else
	  {
	    echo ('<td STYLE="background-color: #cde5f4"><small>');
	  }
	echo ($BillingPlan);
	echo ("</td>");

	//if($shade == 1) { echo('<td STYLE="background-color: #F2F7FB"><small>'); }
	//else{ echo('<td STYLE="background-color: #cde5f4"><small>'); }
	//echo($LastName);
	//echo("</td>");
    if ($buttonID=='today_users' or $buttonID=='week_users' or $buttonID=='month_users') {
		if ($shade == 1)
		  {
		    echo ('<td STYLE="background-color: #F2F7FB"><small>');
		  }
		else
		  {
		    echo ('<td STYLE="background-color: #cde5f4"><small>');
		  }
	    echo ("<small>".date($dateFormat,strtotime($startTime))."</small>");
        echo ("</td>");

		if ($shade == 1)
		  {
		    echo ('<td STYLE="background-color: #F2F7FB"><small>');
		  }
		else
		  {
		    echo ('<td STYLE="background-color: #cde5f4"><small>');
		  }
	    echo ("<small>".$userIP."</small>");
        echo ("</td>");
        
        if ($shade == 1)
		  {
		    echo ('<td STYLE="background-color: #F2F7FB"><small>');
		  }
		else
		  {
		    echo ('<td STYLE="background-color: #cde5f4"><small>');
		  }
	    echo ("<small>".$nasIP."</small>");
        echo ("</td>");


    }
    else {
		if ($shade == 1)
		  {
		    echo ('<td STYLE="background-color: #F2F7FB"><small>');
		  }
		else
		  {
		    echo ('<td STYLE="background-color: #cde5f4"><small>');
		  }
	    if ($type == "Subscription Expiration" or $type == "Expiration")
	      {
		    $Value = date_from_attribute ($row->Value, $dateFormat);
	      }
	    else if ($type == "Hourly" or $type == "Subscription Time")
        {
            $Value=get_user_value($usernametmp,$type);
           $Value = time2str ($Value );
        }
	    else if ($type == "Octets" or $type == "Subscription Octets")
        {
            $Value=get_user_value($usernametmp,$type);
            $Value = octets2str ($Value );
        }
	    echo ("<small>".$Value."</small>");
	    echo ("</td>");

	if ($buttonID=='partialy_account') { 
	if ($shade == 1)
	  {
	    echo ('<td STYLE="background-color: #F2F7FB"><small>');
	  }
	else
	  {
	    echo ('<td STYLE="background-color: #cde5f4" ><small>');
	  }
	if ($type == "Hourly" or $type == "Subscription Time")
	  $used = time2str ($used );
	else if ($type == "Octets" or $type == "Subscription Octets")
	  $used = octets2str ($used );
	else
		$used = time2str ($used);
	}
	else if ($buttonID=='unused_account') {
	$used=$CrDate;
	}
	echo "<small>";
    	echo ($used);
	echo "</small>";
	echo ("</td>");
	if ($shade == 1)
	  {
	    echo ('<td STYLE="background-color: #F2F7FB"><small>');
	  }
	else
	  {
	    echo ('<td STYLE="background-color: #cde5f4"><small>');
	  }
	//echo($activeDate);
    echo "<small>";
    if ($buttonID=='unused_account' or $buttonID=='partialy_account')
	echo date_from_attribute ($activeDate, $dateFormat);
	echo "</small>";
	echo ("</td>");
    }

	echo ("</tr>");
	if (isset ($pullUser) && $pullUser == $usernametmp)
	  {
	    //        pullUser($pulluser);
	    include ('include/divers/pullUser.php');
	    include ('include/divers/include/divers/sexyTabs.php');
	    echo ('<tr>');
	    echo ('<td colspan = 5>');
	    echo ('</td>');
	    echo ('</tr>');
	    unset ($pullUser);
	  }
	$count++;		// <--- adds 0ne to the page number
	if ($shade == 2)
	  {
	    $shade = 1;
	  }
	else
	  {
	    $shade = 2;
	  }


      }
    if ($limit!='All')
    $currPage = (($s / $limit) + 1);

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


    //////////////////////////////////////////////////////////////////
    //      SET UP THE REST OF THE RESULTS PAGES                    //
    //   Some of this code once came from an online tutorial        //
    //   I used when I was building a website.  I will find         //
    //   The author later or re-write.  CP                          //
    //////////////////////////////////////////////////////////////////
    if ($limit!='All') {
    if ($s >= 1)
      {				// <---- Don't need a back button if this is the first page
	$prevs = ($s - $limit);
	print
	  "&nbsp;<a href=\"phpmyprepaid.php?&so=$sort&limit_view=$limit&s=$prevs&buttonID=$buttonID&crdate=$crdate&group=$group&radiusprofile=$radiusprofile&bpcname=$bpname&actionf=$actionf&username=$username\"><img src=\"images/leftarrow.png\" title=\"Previous $limit\"></a>";

      }

    $pages = intval ($numrows / $limit);	// <--This figures out how many pages we have
    // $pages now contains int of pages needed unless there is a remainder from ivision
    if ($numrows % $limit)
      {
	// has remainder so add one page
	$pages++;
      }
    // check to see if last pagea
    if (($pages != 0) && !((($s + $limit) / $limit) == $pages) && $pages != 1)
      {

	// not last page so give NEXT link
	$next = $s + $limit;

	echo
	  "&nbsp;<a href=\"phpmyprepaid.php?&so=$sort&s=$next&limit_view=$limit&crdate=$crdate&group=$group&radiusprofile=$radiusprofile&buttonID=$buttonID&bpcname=$bpname&actionf=$actionf&username=$username\"><img src=\"images/rightarrow.png\" title=\"Next $limit\"></a>";

    $a = $s + ($limit);
    }
    if ($a > $numrows)
      {
	$a = $numrows;
      }
     }
    if ($numrows == 0)
      {
	$b = 0;
	echo "<br><br><p> No result to display.</p>";
      }
    else
      {
	$b = $s + 1;
	echo "<br><br><p>Showing results $b to $a of $numrows</p>";
	echo "<table width=100%><tr><td width=13% style=\"text-align: left;\">";
	echo "<b> Print html : ";
	echo "</td>";
	echo "<td>";
	echo "<form  method=\"post\" action=\"include/display/printListUserHTML.php\" id=\"print_form_html\"  target=\"Print html\" >";
	echo ("<input type=\"hidden\" name=\"phpmyprepaid\" value=\"".session_id ()."\">");
        echo("<input type=\"hidden\" name=\"type\" value=\"$type\">");
	echo("<input type=\"hidden\" name=\"attr\" value=\"$attrr\">");
	echo("<input type=\"hidden\" name=\"db\" value=\"$db\">");
	echo ('<div id="tab_acct_html"></div>');
	printf ('<input class="image" type="image" value="submit" name="print_html" id="print_html" disabled alt="Print html" title="Print html" src="images/html.png" onClick="sendButton(this)">');
	printf ('</form>');
	echo "</td>";


	echo "<td width=13% style=\"text-align: left;\"><b> Print PDF: ";
	echo "</td>";
	echo "<td>";
	echo "<form  method=\"post\" action=\"include/display/printListUserPDF.php\" id=\"print_form_pdf\"  target=\"Print pdf\" >";
	echo ("<input type=\"hidden\" name=\"phpmyprepaid\" value=\"".session_id ()."\">");
        echo("<input type=\"hidden\" name=\"type\" value=\"$type\">");
	echo("<input type=\"hidden\" name=\"attr\" value=\"$attrr\">");
	echo("<input type=\"hidden\" name=\"db\" value=\"$db\">");
	echo ('<div id="tab_acct_pdf"></div>');
	printf ('<input class="image" type="image" value="submit" name="print_pdf" id="print_pdf" disabled alt="Print pdf" title="Print pdf" src="images/pdf.png" onClick="sendButton(this)">');
	printf ('</form>');
	echo "</td>";


	echo "<td width=14% style=\"text-align: left;\"><b> Print Cards : ";
	echo "</td>";
	echo "<td width=5% style=\"text-align: left;\">";
	echo "<form  method=\"post\" action=\"include/display/printListUserCards.php\" id=\"print_form_cards\"  target=\"Print cards\" >";
	echo ("<input type=\"hidden\" name=\"phpmyprepaid\" value=\"".session_id ()."\">");
        echo("<input type=\"hidden\" name=\"type\" value=\"$type\">");
	echo("<input type=\"hidden\" name=\"attr\" value=\"$attrr\">");
	echo("<input type=\"hidden\" name=\"db\" value=\"$db\">");
	echo ('<div id="tab_acct_cards"></div>');
	printf ('<input class="image" type="image" value="submit" name="print_cards" id="print_cards" disabled alt="Print cards" title="Print cards" src="images/tpl.png" onClick="sendButton(this)">');
	echo "</td>";
	echo "<td style=\"text-align: left;\">";
	get_template_html($default_tpl,$loc);
	echo "</td>";
	printf ('</form>');
	echo "</tr>";
	echo "</table>";
	//printfckhref ("", $buttonID, $sort, $loc, $username, 'all', $bpname,$crdate, $activate);
      }
  }
else
  {
    echo ($msg);
  }

?>
Return current item: phpMyPrepaid