product_list.php 3.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117
  1. <?php
  2. include("session_check.php");
  3. include("header.php");
  4. include("menu.php");
  5. require_once("util.php");
  6. require_once("DataBase/Product.php");
  7. require_once("DataBase/Customer.php");
  8. require_once("DataBase/Price.php");
  9. require_once("DataBase/Priceset.php");
  10. /* TODO: check if valid $priceset_id and what if no $customer_data found? */
  11. $customer = new Customer();
  12. $customer_data = $customer->get($_SESSION["username"]);
  13. $priceset_id = 0;
  14. if(count($customer_data) > 0)
  15. $priceset_id = $customer_data[0][11];
  16. $priceset = new Priceset();
  17. $product= new Product();
  18. $price = new Price();
  19. $tmp_priceset = $priceset->get($priceset_id);
  20. $netto = 0;
  21. if(count($tmp_priceset) > 0)
  22. $netto = $tmp_priceset[0][2];
  23. ?>
  24. <div width="100%" align="center">
  25. <?php
  26. // prepare search/filter params
  27. $search_product = var_get_post("search_product", "");
  28. $search_category = var_get_post("search_category", "");
  29. $item_offset = var_get_post("item_offset", 0);
  30. $item_count = var_get_post("item_count", 40);
  31. if($search_category != "")
  32. {
  33. require_once("DataBase/Category.php");
  34. $category= new Category();
  35. $tmp = $category->get($search_category);
  36. if(count($tmp) > 0)
  37. {
  38. echo "<small>Kategorie:</small> ".$tmp[0][1]."";
  39. }
  40. }
  41. ?>
  42. <table border="0" width="80%">
  43. <tr class="table_header">
  44. <td>ProduktNr.</td>
  45. <td>Bezeichnung</td>
  46. <td>Anmerkung</td>
  47. <td>Preis</td>
  48. </tr>
  49. <?php
  50. $list = $product->getByFilter($search_product, $search_category, $item_offset, $item_count);
  51. $count = $product->getCountByFilter($search_product, $search_category);
  52. for($i = 0; $i < count($list); $i++)
  53. {
  54. if($list[$i][0] == "")
  55. continue;
  56. echo "\t<tr class=\"list_normal\" onclick=\"javascript: window.location.href = 'product_details.php?product_id=".$list[$i][0]."';\" onmouseover=\"javascript: this.className='list_hover';\" onmouseout=\"javascript: this.className='list_normal';\">\n";
  57. echo "\t\t<td>".$list[$i][0]."</td>\n";
  58. echo "\t\t<td>".$list[$i][1]."</td>\n";
  59. echo "\t\t<td>".$list[$i][2]."</td>\n";
  60. echo "\t\t<td align=\"right\">".number_format($price->getPriceTax($priceset_id, $list[$i][0], $netto, $list[$i][4]), 2)."</td>\n";
  61. echo "\t</tr></a>\n";
  62. }
  63. ?>
  64. </table>
  65. </div>
  66. <div width="90%" align="right">
  67. <?php
  68. if($item_offset != 0)
  69. echo "<a href=\"product_list.php?search_product=".$search_product."&search_category=".$search_category."&item_offset=".($item_offset-$item_count)."&item_count=".$item_count."\">zur&uuml;ck</a>&nbsp;";
  70. $page_count = $count[0][0]/$item_count;
  71. $start = ($item_offset/$item_count) - 2;
  72. if($start < 0)
  73. $start = 0;
  74. for($i = $start; $i < $start+5; $i++)
  75. {
  76. if($i * $item_count > $count[0][0])
  77. break;
  78. if($item_offset == $i * $item_count)
  79. echo "&nbsp;".$i;
  80. else
  81. echo "&nbsp;<a href=\"product_list.php?search_product=".$search_product."&search_category=".$search_category."&item_offset=".($i*$item_count)."&item_count=".$item_count."\">".$i."</a>";
  82. }
  83. if($item_offset < $count[0][0]-$item_count)
  84. echo "&nbsp;&nbsp;<a href=\"product_list.php?search_product=".$search_product."&search_category=".$search_category."&item_offset=".($item_offset+$item_count)."&item_count=".$item_count."\">vor</a>";
  85. ?>
  86. </div>
  87. <?php
  88. include("footer.php");
  89. ?>