helpers.php 3.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143
  1. <?php
  2. use Barryvdh\DomPDF\Facade\Pdf;
  3. use Illuminate\Support\Facades\Storage;
  4. use Illuminate\Support\Facades\Mail;
  5. function getCards()
  6. {
  7. return \App\Models\Card::where('enabled', true)->orderBy('name')->get();
  8. }
  9. function getCategories()
  10. {
  11. return \App\Models\Category::where('enabled', true)->where('parent_id', null)->orderBy('name')->get();
  12. }
  13. function formatPrice($price)
  14. {
  15. return "€ " . number_format($price, 2, ",", ".");
  16. }
  17. function getVatValue($v, $i)
  18. {
  19. $vat = 0;
  20. //if (env('VAT_MANAGE', 0) == 1)
  21. //{
  22. $vats = \App\Models\Vat::select('id', 'name', 'value')->orderBy('value')->get();
  23. if ($i > 0)
  24. {
  25. $iv = 0;
  26. foreach($vats as $vv)
  27. {
  28. if ($vv->id == $i)
  29. {
  30. $iv = $vv->value;
  31. break;
  32. }
  33. }
  34. if ($iv > 0)
  35. $vat = $v / 100 * $iv;
  36. }
  37. //}
  38. return $vat;
  39. }
  40. function mysqlToDate($dt)
  41. {
  42. list($date, $hour) = explode(" ", $dt);
  43. list($year, $month, $day) = explode("-", $date);
  44. return $day . "/" . $month . "/" . $year;
  45. }
  46. function currencyToDouble($val)
  47. {
  48. $x = str_replace("€", "", $val);
  49. $x = str_replace(".", "", $x);
  50. $x = str_replace(",", ".", $x);
  51. return floatval(trim($x));
  52. }
  53. function getConfiguration($field)
  54. {
  55. $ret = "";
  56. $conf = \App\Models\Configurration::first();
  57. if ($conf)
  58. {
  59. $ret = $conf[$field];
  60. }
  61. return $ret;
  62. }
  63. function sendReceiptEmail($receipt)
  64. {
  65. $pdf = PDF::loadView('receipt', array('receipt' => $receipt));
  66. $pdfName = "Ricevuta_" . $receipt->number . "_" . $receipt->year . ".pdf";
  67. Storage::put('public/pdf/' . $pdfName, $pdf->output());
  68. $email = '';
  69. $member = \App\Models\Member::findOrFail($receipt->member_id);
  70. if ($member->no_send_mail == null || !$member->no_send_mail)
  71. {
  72. if ($member->isAdult())
  73. $email = $member->email;
  74. else
  75. {
  76. $check = explode(" ", $member->father_name);
  77. if (str_contains($receipt->parent, $check[0]))
  78. {
  79. $email = $member->father_email;
  80. }
  81. else
  82. {
  83. $check = explode(" ", $member->mother_name);
  84. if (str_contains($receipt->parent, $check[0]))
  85. $email = $member->mother_email;
  86. }
  87. }
  88. if ($email != '')
  89. {
  90. Mail::to($email)->bcc(env('MAIL_CCN', ''))->send(new \App\Mail\ReceipEmail([
  91. 'pdf' => 'public/pdf/' . $pdfName,
  92. 'number' => $receipt->number . "/" . $receipt->year
  93. ]));
  94. }
  95. }
  96. }
  97. function sendReceiptDeleteEmail($receipt)
  98. {
  99. $pdf = PDF::loadView('receipt', array('receipt' => $receipt));
  100. $pdfName = "Ricevuta_annullata_" . $receipt->number . "_" . $receipt->year . ".pdf";
  101. Storage::put('public/pdf/' . $pdfName, $pdf->output());
  102. $email = '';
  103. $member = \App\Models\Member::findOrFail($receipt->member_id);
  104. if ($member->no_send_mail == null || !$member->no_send_mail)
  105. {
  106. if ($member->isAdult())
  107. $email = $member->email;
  108. else
  109. {
  110. $check = explode(" ", $member->father_name);
  111. if (str_contains($receipt->parent, $check[0]))
  112. {
  113. $email = $member->father_email;
  114. }
  115. else
  116. {
  117. $check = explode(" ", $member->mother_name);
  118. if (str_contains($receipt->parent, $check[0]))
  119. $email = $member->mother_email;
  120. }
  121. }
  122. if ($email != '')
  123. {
  124. Mail::to($email)->bcc(env('MAIL_CCN', ''))->send(new \App\Mail\ReceipDeleteEmail([
  125. 'number' => $receipt->number . "/" . $receipt->year,
  126. 'pdf' => 'public/pdf/' . $pdfName,
  127. 'date' => date("d/m/Y", strtotime($receipt->date))
  128. ]));
  129. }
  130. }
  131. }