whitestarrr

Untitled

Mar 17th, 2017
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.80 KB | None | 0 0
  1. <?php
  2. $todayInput = $_GET['today'];
  3. $today = new DateTime(str_replace("/", "-", $todayInput));
  4. $input = $_GET['invoices'];
  5. $fiveYearsAgo = new DateTime(str_replace("/", "-", $todayInput));
  6. $fiveYearsAgo->modify("-5 years");
  7. $costSum = 0;
  8. $dates = [];
  9.  
  10. foreach ($input as $token) {
  11. $invoice = explode("|", $token);
  12. $company = trim($invoice[1]);
  13. $drug = trim($invoice[2]);
  14. $cost = (double)trim($invoice[3]);
  15. $date = new DateTime(str_replace("/", "-", trim($invoice[0])));
  16.  
  17. if ($date >= $fiveYearsAgo && $date <= $today) {
  18.  
  19. $date = $date->format('d-m-Y');
  20.  
  21. if (!array_key_exists($date, $dates)) {
  22. $dates[$date] = [];
  23. }
  24.  
  25. if (!array_key_exists($company, $dates[$date])) {
  26. $dates[$date][$company] = [];
  27. }
  28.  
  29. if (!array_key_exists($drug, $dates[$date][$company])) {
  30. $dates[$date][$company][$drug] = 0;
  31. }
  32.  
  33. $dates[$date][$company][$drug] += $cost;
  34. }
  35. }
  36.  
  37. uksort($dates, function($d1, $d2) {
  38. $d1 = new DateTime($d1);
  39. $d2 = new DateTime($d2);
  40. return $d1 > $d2;
  41. });
  42.  
  43. echo "<ul>";
  44. foreach ($dates as $date => $companies) {
  45. echo '<li><p>' . date('d/m/Y', strtotime($date)) . '</p>';
  46. ksort($companies);
  47. foreach ($companies as $company => $drugs) {
  48. echo "<ul><li><p>" . $company . "</p>";
  49. ksort($drugs);
  50. $numDrugs = count($drugs);
  51. $i = 0;
  52. echo "<ul><li><p>";
  53. foreach ($drugs as $drug => $cost) {
  54. echo $drug;
  55. $costSum += $cost;
  56. if(++$i != $numDrugs) {
  57. echo ",";
  58. }
  59. }
  60. echo "-".$costSum."lv";
  61. $costSum = 0;
  62. echo "</p></li></ul>";
  63.  
  64.  
  65.  
  66. echo "</li></ul>";
  67. }
  68. echo "</li>";
  69. }
  70. echo "</ul>";
Advertisement
Add Comment
Please, Sign In to add comment