Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?
- include "dblogin.php";
- $huurid=$_GET['huurid'];
- $fietstype=$_GET['fietstype'];
- $subtype=$_GET['subid'];
- $naam=$_GET['naam'];
- $huurdatum=$_GET['huurdatum'];
- $postcodehuisnummer=$_GET['postcodehuisnummer'];
- ?>
- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
- <html xmlns="http://www.w3.org/1999/xhtml">
- <head>
- <SCRIPT language=JavaScript>
- window.print();
- </SCRIPT>
- <style type="text/css" media="all">@import "styleprint.css";</style>
- <BODY TEXT="#336699">
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
- <title>Vriewieler orderbon</title><style type="text/css">
- <!
- .stijl1 {
- font-family: Arial, Helvetica, sans-serif;
- font-size: 12px;
- line-height: 0px;
- align: center;
- }
- >
- </style></head>
- <div id="container">
- <div id="header">
- <body>
- <p><img src="images/kop.png" alt="Kop" class="kop"/></p>
- <p align="center"><strong><span class="stijl1">Fietshuur order, <?echo date("d-m-Y H:i", time());?></span></strong></p>
- <br>
- <table width="80%">
- <?
- $query20="SELECT * FROM huur WHERE ID2 = $huurid";
- $result20=mysql_query($query20) or die ("klantgegevens niet kunnen ophalen. Fout: ".mysql_error());
- while ($row20=mysql_fetch_array($result20))
- {
- $naam=$row20['naam'];
- $postcodehuisnummer=$row20['Postcodehuisnummer'];
- }
- ?>
- <td><strong><span class="stijl1"> Klantnaam: <?echo $naam;?></span></strong><br><tr>
- <td> <span class="stijl1"> Postcode + huisnummer: <?echo $postcodehuisnummer;?></span><br><tr>
- <td> <span class="stijl1"> Huurdatum: <?echo date("d-m-Y", time());?></span>
- </table>
- </div>
- <div id="body">
- <table width="100%" border="0">
- <tr>
- <td valign="top"><b>
- </b>
- <br>
- <table border="0">
- <?
- echo "<td colspan=\"1\"><div class=\"note\">Categorie:</div></td>";
- echo "<td colspan=\"2\"><div class=\"note\">Type:</div></td>";
- echo "<td colspan=\"3\"><div class=\"note\">Einddatum:</div></td>";
- echo "<td colspan=\"1\"><div class=\"note\">Prijs:</div></td>";
- echo "<tr>";
- $result0= mysql_query("SELECT * FROM huur WHERE ID2 = $huurid");
- $count= mysql_num_rows($result0);
- $totaal = $huurid + $count;
- $id1 = $huurid;
- //borg weergeven
- echo "<td>";
- echo " Borg";
- echo "<td>";
- echo " Totaalprijs borg";
- echo "<td>";
- echo "<td>";
- echo "<td><td>";
- echo "<td>";
- //Borgberekening
- $query="SELECT * FROM huur WHERE ID2 = $huurid ORDER BY Borga DESC LIMIT 1";
- $result9=mysql_query($query) or die ("Volgende fout: ".mysql_error());
- while ($row9=mysql_fetch_array($result9))
- {
- $hoogste_borg=$row9['Borga'];
- $vervallen_borg=$row9['Borgb'];
- }
- $query="SELECT ID2, SUM(Borgb) FROM huur WHERE ID2 = $huurid";
- $result3=mysql_query($query) or die ("hoogste borg SUM niet gelukt, door volgende fout: ".mysql_error());
- $row3=mysql_fetch_array($result3);
- $totaleborgb=$row3['SUM(Borgb)'];
- $werkelijkeborg=$hoogste_borg+$totaleborgb-$vervallen_borg;
- echo "€ ".$werkelijkeborg;
- echo "<tr>";
- while($id1 < $totaal )
- {
- $result2 = mysql_query("SELECT * FROM huur WHERE ID = $id1");
- $klant= mysql_fetch_array($result2);
- $cat= $klant["productid"];
- $sub= $klant["subid"];
- $id1 = $id1 + 1;
- switch($cat)
- {
- case "1":
- $result1= mysql_query("SELECT * FROM herenfietsen WHERE ID = $sub");
- $c= 0;
- while($row1= mysql_fetch_array($result1))
- {
- $c++;
- ?> <td>
- <?echo " Herenfiets";?>
- <?echo "<td>";?>
- <?php
- $row1['Type'] = str_replace('+','<br>', $row1['Type']);
- ?>
- <?echo $row1["Type"];?>
- <td><td>
- <?
- $result3= mysql_query("SELECT dagen FROM huur WHERE subid = $sub AND ID = ($id1 - 1)");
- $row3 = mysql_fetch_array($result3);
- $aantaldagen = $row3['dagen'];
- $aantaldagen = $aantaldagen-1;
- $startDate = $huurdatum;
- echo date("d-m-Y", strtotime("$startDate + $aantaldagen days"));
- ?>
- <td>
- <td>
- <td>
- <?
- $result3= mysql_query("SELECT Prijs FROM huur WHERE subid = $sub AND ID = ($id1 - 1)");
- $row3 = mysql_fetch_array($result3);
- echo "€ ".$row3["Prijs"];
- ?>
- <tr>
- <?
- }
- break;
- case "2":
- $result4= mysql_query("SELECT * FROM damesfietsen WHERE ID = $sub");
- $c= 0;
- while($row4= mysql_fetch_array($result4))
- {
- $c++;
- ?> <tr>
- <td>
- <?echo " Damesfiets";?>
- <?echo "<td>";?>
- <?php
- $row4["Naam"] = str_replace('+','<br>', $row4["Naam"]);
- ?>
- <?
- echo $row4["Naam"];?>
- <td><td>
- <?
- $result3= mysql_query("SELECT dagen FROM huur WHERE subid = $sub AND ID = ($id1 - 1)");
- $row3 = mysql_fetch_array($result3);
- $aantaldagen = $row3['dagen'];
- $aantaldagen = $aantaldagen-1;
- $startDate = $huurdatum;
- echo date("d-m-Y", strtotime("$startDate + $aantaldagen days"));
- ?>
- <td><td><td>
- <?
- $result3= mysql_query("SELECT Prijs FROM huur WHERE subid = $sub AND ID = ($id1 - 1)");
- $row3 = mysql_fetch_array($result3);
- echo "€ ".$row3["Prijs"];
- ?>
- <tr>
- <?
- }
- break;
- case "3":
- $result3= mysql_query("SELECT * FROM mtb WHERE ID = $sub");
- $c= 0;
- while($row5= mysql_fetch_array($result3))
- {
- $c++;
- ?> <tr>
- <td>
- <?echo " Mountainbike";?>
- <?echo "<td>";?>
- <?php
- $row5["Naam"] = str_replace('+','<br>', $row5["Naam"]);
- ?>
- <?echo $row5["Naam"];?>
- <td><td>
- <?
- $result3= mysql_query("SELECT dagen FROM huur WHERE subid = $sub AND ID = ($id1 - 1)");
- $row3 = mysql_fetch_array($result3);
- $aantaldagen = $row3['dagen'];
- $aantaldagen = $aantaldagen-1;
- $startDate = $huurdatum;
- echo date("d-m-Y", strtotime("$startDate + $aantaldagen days"));
- ?>
- <td><td><td>
- <?
- $result3= mysql_query("SELECT Prijs FROM huur WHERE subid = $sub AND ID = ($id1 - 1)");
- $row3 = mysql_fetch_array($result3);
- echo "€ ".$row3["Prijs"];
- ?>
- <tr>
- <?
- }
- break;
- case "4":
- $result4= mysql_query("SELECT * FROM mtbkind WHERE ID = $sub");
- $c= 0;
- while($row4= mysql_fetch_array($result4))
- {
- $c++;
- ?> <tr>
- <td>
- <?echo " Kinder-mountainbike";?>
- <?echo "<td>";?>
- <?php
- $row4["Naam"] = str_replace('+','<br>', $row4["Naam"]);
- echo $row4["Naam"];
- ?>
- <?echo $row1["Naam"];?>
- <td><td>
- <?
- $result3= mysql_query("SELECT dagen FROM huur WHERE subid = $sub AND ID = ($id1 - 1)");
- $row3 = mysql_fetch_array($result3);
- $aantaldagen = $row3['dagen'];
- $aantaldagen = $aantaldagen-1;
- $startDate = $huurdatum;
- echo date("d-m-Y", strtotime("$startDate + $aantaldagen days"));
- ?>
- <td><td><td>
- <?
- $result3= mysql_query("SELECT Prijs FROM huur WHERE subid = $sub AND ID = ($id1 - 1)");
- $row3 = mysql_fetch_array($result3);
- echo "€ ".$row3["Prijs"];
- ?>
- <tr>
- <?
- }
- break;
- case "5":
- $result1= mysql_query("SELECT * FROM tandems WHERE ID = $sub");
- $c= 0;
- while($row1= mysql_fetch_array($result1))
- {
- $c++;
- ?> <tr>
- <td>
- <?echo " Tandems";?>
- <?echo "<td>";?>
- <?php
- $row1["Naam"] = str_replace('+','<br>', $row1["Naam"]);
- ?>
- <?echo $row1["Naam"];?>
- <td><td>
- <?
- $result3= mysql_query("SELECT dagen FROM huur WHERE subid = $sub AND ID = ($id1 - 1)");
- $row3 = mysql_fetch_array($result3);
- $aantaldagen = $row3['dagen'];
- $aantaldagen = $aantaldagen-1;
- $startDate = $huurdatum;
- echo date("d-m-Y", strtotime("$startDate + $aantaldagen days"));
- ?>
- <td><td><td>
- <?
- $result3= mysql_query("SELECT Prijs FROM huur WHERE subid = $sub AND ID = ($id1 - 1)");
- $row3 = mysql_fetch_array($result3);
- echo "€ ".$row3["Prijs"];
- ?>
- <tr>
- <?
- }
- break;
- case "6":
- $result1= mysql_query("SELECT * FROM jongensfietsen WHERE ID = $sub");
- $c= 0;
- while($row1= mysql_fetch_array($result1))
- {
- $c++;
- ?> <tr>
- <td>
- <?echo " Kinderfiets jongen";?>
- <?echo "<td>";?>
- <?php
- $row1["Naam"] = str_replace('+','<br>', $row1["Naam"]);
- ?>
- <?echo $row1["Naam"];?>
- <td><td>
- <?
- $result3= mysql_query("SELECT dagen FROM huur WHERE subid = $sub AND ID = ($id1 - 1)");
- $row3 = mysql_fetch_array($result3);
- $aantaldagen = $row3['dagen'];
- $aantaldagen = $aantaldagen-1;
- $startDate = $huurdatum;
- echo date("d-m-Y", strtotime("$startDate + $aantaldagen days"));
- ?>
- <td><td><td>
- <?
- $result3= mysql_query("SELECT Prijs FROM huur WHERE subid = $sub AND ID = ($id1 - 1)");
- $row3 = mysql_fetch_array($result3);
- echo "€ ".$row3["Prijs"];
- ?>
- <tr>
- <?
- }
- break;
- case "7":
- $result1= mysql_query("SELECT * FROM meisjesfietsen WHERE ID = $sub");
- $c= 0;
- while($row1= mysql_fetch_array($result1))
- {
- $c++;
- ?> <tr>
- <td>
- <?echo " Kinderfiets meisje";?>
- <?echo "<td>";?>
- <?php
- $row1["Naam"] = str_replace('+','<br>', $row1["Naam"]);
- ?>
- <?echo $row1["Naam"];?>
- <td><td>
- <?
- $result3= mysql_query("SELECT dagen FROM huur WHERE subid = $sub AND ID = ($id1 - 1)");
- $row3 = mysql_fetch_array($result3);
- $aantaldagen = $row3['dagen'];
- $aantaldagen = $aantaldagen-1;
- $startDate = $huurdatum;
- echo date("d-m-Y", strtotime("$startDate + $aantaldagen days"));
- ?>
- <td><td><td>
- <?
- $result3= mysql_query("SELECT Prijs FROM huur WHERE subid = $sub AND ID = ($id1 - 1)");
- $row3 = mysql_fetch_array($result3);
- echo "€ ".$row3["Prijs"];
- ?>
- <tr>
- <?
- }
- break;
- case "8":
- $result1= mysql_query("SELECT * FROM kind_divers WHERE ID = $sub");
- $c= 0;
- while($row1= mysql_fetch_array($result1))
- {
- $c++;
- ?> <tr>
- <td>
- <?echo " Kind-diversen";?>
- <?echo "<td>";?>
- <?php
- $row1["Naam"] = str_replace('+','<br>', $row1["Naam"]);
- ?>
- <?echo $row1["Naam"];?>
- <td><td>
- <?
- $result3= mysql_query("SELECT dagen FROM huur WHERE subid = $sub AND ID = ($id1 - 1)");
- $row3 = mysql_fetch_array($result3);
- $aantaldagen = $row3['dagen'];
- $aantaldagen = $aantaldagen-1;
- $startDate = $huurdatum;
- echo date("d-m-Y", strtotime("$startDate + $aantaldagen days"));
- ?>
- <td><td><td>
- <?
- $result3= mysql_query("SELECT Prijs FROM huur WHERE subid = $sub AND ID = ($id1 - 1)");
- $row3 = mysql_fetch_array($result3);
- echo "€ ".$row3["Prijs"];
- ?>
- <tr>
- <?
- }
- break;
- case "9":
- $result1= mysql_query("SELECT * FROM accessoires WHERE ID = $sub");
- $c= 0;
- while($row1= mysql_fetch_array($result1))
- {
- $c++;
- ?> <tr>
- <td>
- <?echo " Accessoires";?>
- <?echo "<td>";?>
- <?php
- $row1["Naam"] = str_replace('+','<br>', $row1["Naam"]);
- ?>
- <?echo $row1["Naam"];?>
- <td><td>
- <?
- $result3= mysql_query("SELECT dagen FROM huur WHERE subid = $sub AND ID = ($id1 - 1)");
- $row3 = mysql_fetch_array($result3);
- $aantaldagen = $row3['dagen'];
- $aantaldagen = $aantaldagen-1;
- $startDate = $huurdatum;
- echo date("d-m-Y", strtotime("$startDate + $aantaldagen days"));
- ?>
- <td><td><td>
- <?
- $result3= mysql_query("SELECT Prijs FROM huur WHERE subid = $sub AND ID = ($id1 - 1)");
- $row3 = mysql_fetch_array($result3);
- echo "€ ".$row3["Prijs"];
- ?>
- <tr>
- <?
- }
- break;
- case "10":
- $result1= mysql_query("SELECT * FROM elekrisch WHERE ID = $sub");
- $c= 0;
- while($row1= mysql_fetch_array($result1))
- {
- $c++;
- ?> <tr>
- <td>
- <?echo " Elektrisch";?>
- <?echo "<td>";?>
- <?php
- $row1["Naam"] = str_replace('+','<br>', $row1["Naam"]);
- ?>
- <?echo $row1["Type"];?>
- <td><td>
- <?
- $result3= mysql_query("SELECT dagen FROM huur WHERE subid = $sub AND ID = ($id1 - 1)");
- $row3 = mysql_fetch_array($result3);
- $aantaldagen = $row3['dagen'];
- $aantaldagen = $aantaldagen-1;
- $startDate = $huurdatum;
- echo date("d-m-Y", strtotime("$startDate + $aantaldagen days"));
- ?>
- <td><td><td>
- <?
- $result3= mysql_query("SELECT Prijs FROM huur WHERE subid = $sub AND ID = ($id1 - 1)");
- $row3 = mysql_fetch_array($result3);
- echo "€ ".$row3["Prijs"];
- ?>
- <tr>
- <?
- }
- break;
- }
- }
- ?>
- <td>
- <td>
- <?
- echo "<b>";
- echo "Totaalprijs: ";
- echo "<td>";
- echo "<td><td><td><td>";
- $query="SELECT ID2, SUM(Prijs) FROM huur WHERE ID2 = $huurid";
- $result3=mysql_query($query) or die ("Volgende fout: ".mysql_error());
- $row3=mysql_fetch_array($result3);
- $totalehuur=$row3['SUM(Prijs)'];
- $totaalprijs=$totalehuur+$werkelijkeborg;
- echo "<b>€ ".$totaalprijs."</b>";
- echo "</b>";
- ?>
- </table>
- </td>
- <tr>
- </table>
- </body></div>
- <div id="footer">
- <p><img src="images/voet.png" alt="Kop" class="voet"/></p>
- </div>
- </div>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement