<?php

session_start();


include "../config.php";
include "../header.php";
include "../style.php";

$userid = $_POST['userid'];

if( session_is_registered("alogin") ) {

    	?><table>
      	<tr>
        <td width="15%" valign=top><br>
        <? include("adminnavigation.php"); ?>
        </td>
        <td valign="top" align="center"><br><br> <?
    	echo "<font size=2 face='$fonttype' color='$fontcolour'><p><b><center>";
        echo "<H2>Commission currently owed.</H2>";
		

		
		$query = "select SUM(commission) from members WHERE commission > 0 and deleted=''";
		$result = mysql_result(mysql_query($query),0);
		echo "Total Commissions Owed: ".number_format($result,2)."\$<br><br>";
		
		if(count($pay_with) == 1) {

if($pay_with['paypal'] == 1) $gateway = 'paypal';
if($pay_with['alertpay'] == 1) $gateway = 'alertpay';

		if($_GET['clear']) {		
			mysql_query("UPDATE members SET commission=0 WHERE ".$gateway."_email != '' and deleted=''");
			mysql_query("UPDATE transactions SET paid=1, date_paid='".time()."' WHERE paid=0");
		}
		

	
		echo "<a href=\"masspay.php\">Download mass payment csv</a><br><br>";
		
		?>
		
		<form method="get" action="commission.php">
		<input type="hidden" name="clear" value="1">
		<input type="submit" value="Clear Downloaded Commissions">
		</form>
		<br>
		
		<?

		}
		
		
		
		if($_GET['cleartransaction']) {
			mysql_query("UPDATE transactions SET viewed=1 WHERE 1");
		}
		
		echo "<a href=\"transaction.php\">Download transaction log</a><br>";
		
		?>
		
		<form method="get" action="commission.php">
		<input type="hidden" name="cleartransaction" value="1">
		<input type="submit" value="Clear Transaction Log">
		</form>
		<br>
		
		<?
		
		
        $query = "select * from members where commission>0 and deleted=''";
		$result = mysql_query ($query)
	     	or die ("Query failed");
        $numrows = @ mysql_num_rows($result);
        if ($numrows == 0) {
        	echo "<p><center>No commission payments pending.</p></center>";

        }
        ?>
            <table width=70% border=0 cellpadding=2 cellspacing=2>
        	<tr>
	          <td bgcolor="<? echo $contrastcolour; ?>"><center><font size=2 face="<? echo $fonttype; ?>" color="<? echo $fontcolour; ?>">Userid</font></center></td>
              <? if ($pay_with['paypal']) { ?>
                <td bgcolor="<? echo $contrastcolour; ?>"><center><font size=2 face="<? echo $fonttype; ?>" color="<? echo $fontcolour; ?>">Paypal email</font></center></td>
              <? } ?>
              <? if ($pay_with['alertpay']) { ?>
                <td bgcolor="<? echo $contrastcolour; ?>"><center><font size=2 face="<? echo $fonttype; ?>" color="<? echo $fontcolour; ?>">Alertpay email</font></center></td>
              <? } ?>
	          <td bgcolor="<? echo $contrastcolour; ?>"><center><font size=2 face="<? echo $fonttype; ?>" color="<? echo $fontcolour; ?>">Amount</font></center></td>

	        </tr>
        <?
    	while ($line = mysql_fetch_array($result)) {
			$id = $line["id"];
            $userid = $line["userid"];
            $commission = $line["commission"];
            $paypal_email = $line["paypal_email"];
            $alertpay_email = $line["alertpay_email"];

        ?><tr>
          <td bgcolor="<? echo $basecolour; ?>"><center><font size=2 face="<? echo $fonttype; ?>" color="<? echo $fontcolour; ?>"><? echo $userid; ?></font></center></td>
          <? if ($pay_with['paypal']) { ?>
          	  <td bgcolor="<? echo $basecolour; ?>"><center><font size=2 face="<? echo $fonttype; ?>" color="<? echo $fontcolour; ?>"><? echo $paypal_email; ?></font></center></td>
          <? } ?>
          <? if ($pay_with['alertpay']) { ?>
          	  <td bgcolor="<? echo $basecolour; ?>"><center><font size=2 face="<? echo $fonttype; ?>" color="<? echo $fontcolour; ?>"><? echo $alertpay_email; ?></font></center></td>
          <? } ?>
          <td bgcolor="<? echo $basecolour; ?>"><center><font size=2 face="<? echo $fonttype; ?>" color="<? echo $fontcolour; ?>"><? echo $commission; ?></font></center></td>
         </tr> <?
        }
        echo "</table></center>" ;
        echo "</td></tr></table>";

  }
else
	echo "Unauthorised Access!";

include "../footer.php";

?>