bank.php

Ga naar de documentatie van deze file.

<?php
/***************************************************************************
 *   Copyright (C) 2007 by Damian Bodde and Peter Wessels                  *
 *   damian@elsw.de  peter1wessels@gmail.com                               *
 *                                                                         *
 *   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.                                   *
 *                                                                         *
 *   This program is distributed in the hope that it will be useful,       *
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of        *
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the         *
 *   GNU General Public License for more details.                          *
 *                                                                         *
 *   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.             *
 ***************************************************************************/
?>
<?php
if(isset($_GET['action']))
{
                $action = $_GET['action'];
}
else
{
                $action = "main";
}

$userid = $_SESSION['userid'];

if($action == "main")
{
                ?>
                                <a href=index.php?menu=bank&action=show&type=normal>Normale Rekening</a><br>
                                <a href=index.php?menu=bank&action=show&type=spaar>Spaar Rekening</a><br>
                <?php
}

if($action == "show")
{
                $type = $_GET['type'];
                
                $sql = ("SELECT id FROM rekening WHERE userid='$userid'");
                $result = mysql_query($sql) or die(mysql_error());
                $aantal = mysql_num_rows($result);
                                
                $sql = ("SELECT COUNT(id) AS getal FROM rekening WHERE userid='$userid' AND art='rekening'");
                $result = mysql_query($sql) or die(mysql_error());
                $row = mysql_fetch_array($result);
                $normalrekening = $row['getal'];
                
                $sql = ("SELECT COUNT(id) AS getal FROM rekening WHERE userid='$userid' AND art='spaar'");
                $result = mysql_query($sql) or die(mysql_error());
                $row = mysql_fetch_array($result);
                $spaarrekening = $row['getal'];
                
                echo "Je hebt $aantal Rekeningen.<br>Daarvan <b>$normalrekening</b> Normale rekeningen<br>
                                <b>$spaarrekening</b> Spaarrekeningen<br>\n";

                switch($type)
                {
                                case "normal":
                                                echo "Normaal rekening<br>";
                                                $sql = ("SELECT rekeningnummer, geld, bankid FROM rekening WHERE userid='$userid' AND art='rekening' ORDER BY geld DESC");
                                                $result = mysql_query($sql) or die(mysql_error());
                                                echo "<table border=1><tr><td>Rekeningnummer</td><td>Banknaam</td><td>Kapital</td></tr>\n";
                                                while($row = mysql_fetch_array($result))
                                                {
                                                                $bankid         = $row['bankid'];
                                                                $rekeningnummer = $row['rekeningnummer'];
                                                                $geld           = $row['geld'];
                                                                
                                                                $sql1 = ("SELECT banknaam FROM bank WHERE bankid='$bankid'");
                                                                $resolt = mysql_query($sql1) or die(mysql_error());
                                                                $raw = mysql_fetch_array($resolt);
                                                                $banknaam = $raw['banknaam'];
                                                                
                                                                echo "<tr><td><a href=index.php?menu=bank&action=rekening&rekeningnummer=$rekeningnummer>$rekeningnummer</a></td><td>$banknaam</td><td>$geld</td></tr>\n";
                                                }
                                                echo "</table>\n";
                                break;
                                
                                case "spaar":
                                                echo "Spaar rekening<br>";
                                                $sql = ("SELECT rekeningnummer, geld, bankid FROM rekening WHERE userid='$userid' AND art='spaar' ORDER BY geld DESC");
                                                $result = mysql_query($sql) or die(mysql_error());
                                                echo "<table border=1><tr><td>Rekeningnummer</td><td>Banknaam</td><td>Kapital</td></tr>\n";
                                                while($row = mysql_fetch_array($result))
                                                {
                                                                $bankid         = $row['bankid'];
                                                                $rekeningnummer = $row['rekeningnummer'];
                                                                $geld           = $row['geld'];
                                                                
                                                                $sql1 = ("SELECT banknaam FROM bank WHERE bankid='$bankid'");
                                                                $resolt = mysql_query($sql1) or die(mysql_error());
                                                                $raw = mysql_fetch_array($resolt);
                                                                $banknaam = $raw['banknaam'];
                                                                
                                                                echo "<tr><td>$rekeningnummer</td><td>$banknaam</td><td>$geld</td></tr>\n";
                                                }
                                                echo "</table>\n";
                                break;
                }
}

if($action == "rekening")
{
                $ktonummer = mysql_real_escape_string($_GET['rekeningnummer']);
                $sql = ("SELECT geld FROM rekening WHERE userid='$userid' AND rekeningnummer='$ktonummer'");
                $result = mysql_query($sql) or die(mysql_error());
                $row = mysql_fetch_array($result);
                $owner = mysql_num_rows($result);

                $geld  = $row['geld'];
                
                if($owner == 0)
                {
                                die("Jij bent niet de eigenaar van deze rekening");
                }
}

if($action == "beleg")
{
                $ktonummer = mysql_real_escape_string($_GET['rekeningnummer']);
                
                // Geld affragen
                $sql = ("SELECT geld FROM rekening WHERE userid='$userid' AND rekeningnummer='$ktonummer'");
                $result = mysql_query($sql) or die(mysql_error());
                $row = mysql_fetch_array($result);
                $owner = mysql_num_rows($result);
                
                $geld = $row['geld'];
                
                if($owner == 0)
                {
                                die("Jij bent niet de eigenaar van deze rekening");
                }
                
                // Nu hebben wij het bedrag van de Rekening. Nu moeten we alles tracen.
                
                // Uitgaves
                $sql = ("SELECT bedrag FROM transfers WHERE sourcekto='$ktonummer'");
                $result = mysql_query($sql) or die(mysql_error());
                while($row = mysql_fetch_array($result))
                {
                                $uitgave += $row['bedrag'];
                }
                $countuitgave = mysql_num_rows($result);

                $sql = ("SELECT bedrag FROM transfers WHERE destkto='$ktonummer'");
                $result = mysql_query($sql) or die(mysql_error());
                while($row = mysql_fetch_array($result))
                {
                                $inname += $row['bedrag'];
                }
                $countinname = mysql_num_rows($result);
}

---