bookkeepingrequest.php

<?php
  /**************************************************************************\
  * PHPAdvocat                                                               *
  * http://phpadvocat.sourceforge.net                                        *
  * By Burkhard Obergoeker <phpadvocat@obergoeker.de>                        *
  * --------------------------------------------                             *
  *  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.                                              *
  \**************************************************************************/

require("./include/phpadvocat.inc.php");

/* Get User Account from Session Vars */ 
$user = $_SESSION["dbuser"];
$passwd = $_SESSION["dbpasswd"];

$changecheck="";

/* initiate database */
$db = new www_db;
$db->connect($user, $passwd);

/*++++++++++++ handle changed data from GET or POST +++++++++*/

/******************   end insert new pfile with known partner **********/

/* add new record from last line form */
if($_POST["accountaddbutton"])
{

  /************ begin insert new account **********/
  $description=$_POST["description"];


  $querystring = sprintf("insert into phpa_accounts (description) ".
    "values ('%s')", $description);
  // echo "<hr>". $querystring . "<hr>";
  if (!$db->query($querystring)) {
      $changecheck="Neues Konto";
  }

/* delete record from clicked link in table*/
} elseif(1 == $_GET["accountdel"])
{
   $number=$_GET["number"];
   /* since all usabel databases are able to keep the referntial*/
   /* integrity, there is no need to delete the details */
	$querystring = sprintf("delete from phpa_accounts where number=%s", 
	  $number);
    // echo "<hr>". $querystring . "<hr>";
  if (!$db->query($querystring)) {
      $changecheck="Konto gel&ouml;scht";
  }
}

/*++++++++++++ end of Data handling +++++++++++++++++++++++++*/


/* Begin HTML page */
echo "<HTML><HEAD>";
echo "<TITLE>PHPAdvocat - Liste Konten</TITLE>";
echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-15\">\n";
echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"include/phpadvocat.css\">";
echo "</HEAD>";

echo "<BODY BGCOLOR=\"#FFFFFF\" TEXT=\"#000000\">\n";

/* create frame; left side for menu */
echo "<TABLE width=100%><TR><TD width=200 valign=\"top\">\n";

/* here comes the navigation menue */

  $phpa_menue->account=$user;
  $phpa_menue->selected=4;
  $phpa_menue->draw_menue();

echo "<hr><a href=categoryrequest.php>&Uuml;bersicht Kategorien</a>";
echo "</TD><TD>\n";

/* display title */
echo "<CENTER><H1>Liste Konten</H1></CENTER>\n";


echo "<table width=100%><tr>\n";
echo "<td>" . date("d.m.Y", time()) . "</td>";
echo "<TD ALIGN=RIGHT>".$changecheck ."</TD>";
print "</tr></table>\n";

print "<hr><center>";

$querystring = 
  "select c.number, c.description, ".
    "(select sum(a.incomingamount)-".
    "sum(a.outgoingamount) ".
    "from phpa_amounts as a ".
    "where a.exp_account = c.number) as sum ".
  "from phpa_accounts as c ";

/* Sort by table header */
switch ($_GET["fsort"]) {

  case "number"  :$querystring .= "order by c.number";
                  break;
  case "description"    :$querystring .= "order by c.description";
                  break;

  default        :$querystring .= "order by c.number";
}               

//  echo "<hr>" . $querystring . "<hr>"; 

$db->query($querystring);

printf("<table  class=listtable>\n");

/* table header */
printf("<th><a href=$PHP_SELF?fsort=number>Nummer</a></th>");
printf("<th><a href=$PHP_SELF?fsort=description>Beschreibung</a></th>");
printf("<th><a href=$PHP_SELF?fsort=value>Wert</a></th>");
printf("<th></th>");

while($db->next_record()) {
   if(0 <= $db->record["sum"] ) {
     printf("<tr>");
   } else {
     /* make row red if account is negative */
     printf("<tr bgcolor=red>");
   }
	/* printf("<td>%s</td>", $db->row); */
	printf("<td><a href=\"bookedit.php?number=%s\">%05.0f</a></td>",
		 $db->record["number"], $db->record["number"]);
	printf("<td>%s</td>", $db->record["description"]);
	printf("<td align=right>%s</td>", tolocalnum($db->record["sum"],$LOCALE));
	
   /* delete this record */
   printf("<td><a href=\"$PHP_SELF?number=%s&accountdel=1\" " .
         "onClick=\"return confirm('Komplettes Konto loeschen?')" .
         "\"><img alt=Del src=\"images/trash-x.png\" border=0>".
         "</a></td></tr>\n", $db->record["number"]);
	printf("</tr>\n");
}



/* last row is an input for new categories */
printf("<tr><FORM METHOD=POST ACTION=\"$PHP_SELF\">");
printf("<td>Neu</td>");
printf("<td><input name=description type=text size=50></td>\n");
printf("<td><input name=accountaddbutton type=submit value=Neu></td>");
printf("</FORM></tr>");

/* end of input row */

printf("</table>\n"); 

printf("</table></form></center>");



$db->close();

/* end of page */
echo "<hr></TD></TR></TABLE></BODY></HTML>";

?>