<?
$email = $email;
include("config.inc.php");
include("db_mysql.class.php");

$abfrage = "SELECT * FROM biz_kunden WHERE mail='".$email."'";
$ergebnis = mysql_query($abfrage);
$row = mysql_fetch_object($ergebnis);

$res = $db->query("select rechnungid,datum from biz_rechnungen LEFT JOIN biz_kunden ON biz_rechnungen . kundenid = biz_kunden . mail order by datum DESC");
if($db->num_rows($res)==0) {
    echo "Es sind keine Rechnungen für Sie vorhanden.";

    
    die();
}

// ----------------------
	$PPcurrencySQL = $db->query("select ppwaehrung from biz_settings");
	$PPcurrency = $db->fetch_array($PPcurrencySQL);

?>
<link rel="stylesheet" type="text/css" href="style.css">
<table align="center" width="540" border="0" cellspacing="0" cellpadding="0">
<tr class="tb">
<td>

<table width="100%" border="0" cellspacing="1" cellpadding="3">
<tr class="th">
<td><div align="center">RechnungNr</div></td>
<td><div align="center">Datum</div></td>
<td><div align="center">Status</div></td>
<td><div align="center">Aktion</div></td>

<td><div align="center">moneybookers</div></td>
</tr>

<?
$getpaypalmail = $db->query("select paypalmailaddress from biz_settings");
$paypalmail = $db->fetch_array($getpaypalmail);

$getvorname = $db->query("select vorname from biz_kunden where kundenid=kundenid");
$vorname = $db->fetch_array($getvorname);
$getnachname = $db->query("select nachname from biz_kunden where kundenid=kundenid");
$nachname = $db->fetch_array($getnachname);
$getstrasse = $db->query("select strasse from biz_kunden where kundenid=kundenid");
$strasse = $db->fetch_array($getstrasse);
$getort = $db->query("select ort from biz_kunden where kundenid=kundenid");
$ort = $db->fetch_array($getort);
$getplz = $db->query("select plz from biz_kunden where kundenid=kundenid");
$plz = $db->fetch_array($getplz);

$res = $db->query("select rechnungid,positionen,datum,status from biz_rechnungen LEFT JOIN biz_kunden ON biz_rechnungen . kundenid = biz_kunden . kundenid order by datum DESC");
while($row=$db->fetch_array($res)) {
$_records[] = array("kunde" => explode("|", $row['anschrift']), "positionen" => $row["positionen"]);
$total=getTotalAmount($_records);

?>
<tr class="tr" align="left" valign="top">
<td><?=$row[rechnungid];?> </td>
<?
$t = strtotime($row[datum]);
$datum = date("d.m.Y",$t);
?>
<td><?=$datum?></td>
<td><?
if($row[status]=="bezahlt")   { echo "<font color=\"green\">$row[status]</font>"; }
if($row[status]=="unbezahlt") { echo "<font color=\"orange\">$row[status]</font>"; }
if($row[status]=="gemahnt")   { echo "<font color=\"red\">$row[status]</font>"; }

?></td>
<td>Rechnung ansehen</td>
<?
//Paypal zahlung
//echo'
//<form action="'.CONF_BASEPAYPALURL.'" method="post">
//<input type="hidden" name="cmd" value="_cart">
//<input type="hidden" name="upload" value="1">
//<input type="hidden" name="business" value="'.$paypalmail['paypalmailaddress'].'">
//<input type="hidden" name="currency_code" value="'.$PPcurrency['ppwaehrung'].'">
//<input type="hidden" name="return" value="'.CONF_BASEPAYPAL.'rechnung_paypalsuccess.php">
//<input type="hidden" name="cancel_return" value="'.CONF_BASEPAYPAL.'rechnung_paypalfailed.php?r_nr='.$row[rechnungid].'">
//<input type="hidden" name="rm" value="2">
//<input type="hidden" name="item_name_1" value="Rechnung Nr. '.$row[rechnungid].'">
//<input type="hidden" name="amount_1" value="'.$total.'">
//<input type="hidden" name="custom" value="r_nr='.$row[rechnungid].'">
//<td align="center">';

//if($row[status]=="unbezahlt" || $row[status] =="gemahnt")
//	 echo'<input type="image" src=".../../img/paypalbezahlung.gif" alt="Via Paypal bezahlen">';
//echo'</td></form>';
?>
<?
echo'
<form action="https://www.moneybookers.com/app/payment.pl" method="post" target="_blank">
<input type="hidden" name="pay_to_email" value="email@domain.de">
<input type="hidden" name="status_url" value="email@domain.de">
<input type="hidden" name="language" value="DE">
<input type="hidden" name="amount" value="'.$total.'">
<input type="hidden" name="currency" value="EUR">
<input type="hidden" name="detail1_description" value="KundenNr: '.$row[kundenid].'">
<input type="hidden" name="detail1_text" value="RechnungsNr: '.$row[rechnungid].'">
<input type="hidden" name="detail2_description" value="Kunde: '.$vorname['vorname'] .$nachname['nachname'].'">
<input type="hidden" name="detail2_text" value="Anschrift: '.$strasse['strasse'].'">
<input type="hidden" name="firstname" value="'.$vorname['vorname'].'">
<input type="hidden" name="lastname" value="'.$nachname['nachname'].'">
<input type="hidden" name="address" value="'.$strasse['strasse'].'">
<input type="hidden" name="city" value="'.$ort['ort'].'">
<input type="hidden" name="postal_code" value="'.$plz['plz'].'">
<td align="center">';

if($row[status]=="unbezahlt" || $row[status] =="gemahnt")
	 echo'<input type="image" src="http://www.moneybookers.com/images/banners/88_de_paynow.gif"';
echo'</td></form>';
?>
</tr>
<?
}
?>
</table>
</td>
</tr>
</table>

<?

function getTotalAmount($_records){

	foreach($_records as $_record)
	{
		// Positionen trennen (Array)
		$_positions = explode("
", $_record['positionen']);

		// Positionen durchlaufen
		$ausgabe = array();

		foreach($_positions as $_position)
		{
			// Felder trennen
			$_fields = explode("|", $_position);
			
			// Betrag steht im 3. Feld
			if(isset($_fields[2])) 
            {
                $sum += $_fields[2]*$_fields[0];
                $ausgabe[] = $_fields[2]*$_fields[0];
            }
		}
		implode("", $ausgabe);	
	}
	return array_sum($ausgabe);
}


?>