Receipt.php 3.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125
  1. <?php
  2. namespace App\Http\Livewire;
  3. use Livewire\Component;
  4. use Barryvdh\DomPDF\Facade\Pdf;
  5. use Illuminate\Support\Facades\Log;
  6. use SimpleXMLElement;
  7. use App\Models\Member;
  8. class Receipt extends Component
  9. {
  10. public $records;
  11. public $filterStatus = '';
  12. public $hasFilter = false;
  13. public $filterFrom = '', $filterTo = '';
  14. public $filteredMemberId = '';
  15. public $members = [];
  16. public function mount()
  17. {
  18. // Load members for the dropdown
  19. $this->members = Member::orderBy('last_name')->orderBy('first_name')->get();
  20. }
  21. public function updatedFilterFrom()
  22. {
  23. $this->emit('destroy-data-table');
  24. }
  25. public function updatedFilterTo()
  26. {
  27. $this->emit('destroy-data-table');
  28. }
  29. public function render()
  30. {
  31. if ($this->hasFilter)
  32. {
  33. $r = \App\Models\Receipt::with('member');
  34. if ($this->filterStatus != '')
  35. $r = $r->where('status', $this->filterStatus);
  36. if ($this->filterFrom != '')
  37. $r = $r->where('date', '>=', $this->filterFrom);
  38. if ($this->filterTo != '')
  39. $r = $r->where('date', '<=', $this->filterTo);
  40. if ($this->filteredMemberId != '')
  41. $r = $r->where('member_id', $this->filteredMemberId);
  42. $this->records = $r->get();
  43. }
  44. else
  45. {
  46. $this->records = \App\Models\Receipt::with('member')->get();
  47. }
  48. $this->emit('load-data-table');
  49. return view('livewire.receipt');
  50. }
  51. public function printReceipt($id)
  52. {
  53. $this->emit('load-data-table');
  54. $receipt = \App\Models\Receipt::findOrFail($id);
  55. //$pdf = PDF::loadView('pdf/receipt', array('datas' => $datas, 'from' => $x, 'to' => $y, 'who' => '', 'matricola' => $matricola));
  56. $pdf = PDF::loadView('receipt', array('receipt' => $receipt));//->output();
  57. return $pdf->stream('aaa.pdf');
  58. }
  59. public function importReceipts()
  60. {
  61. $this->validate([
  62. 'receiptFile' => 'required|mimes:xml|max:2048',
  63. ]);
  64. try {
  65. $xmlString = file_get_contents($this->receiptFile->getRealPath());
  66. $xml = new SimpleXMLElement($xmlString);
  67. Log::info('XML Data: ' . print_r($xml, true));
  68. // Extract data from XML and create receipts
  69. foreach ($xml->receipt as $receiptData) {
  70. Log::info('Receipt Data: ' . print_r($receiptData, true));
  71. $member = Member::where('fiscal_code', (string)$receiptData->fiscal_code)->first();
  72. if ($member) {
  73. $receipt = new \App\Models\Receipt();
  74. $receipt->member_id = $member->id;
  75. $receipt->date = (string)$receiptData->date;
  76. $receipt->amount = (float)$receiptData->amount;
  77. $receipt->number = (string)$receiptData->number;
  78. $receipt->year = (int)$receiptData->year;
  79. $receipt->save();
  80. }
  81. }
  82. session()->flash('message', 'Ricevute importate con successo.');
  83. } catch (\Exception $e) {
  84. session()->flash('error', 'Errore durante l\'importazione del file XML: ' . $e->getMessage());
  85. }
  86. $this->reset('receiptFile');
  87. $this->emit('load-data-table');
  88. }
  89. public function search()
  90. {
  91. $this->hasFilter = true;
  92. }
  93. public function disableSearch()
  94. {
  95. $this->filterStatus = "";
  96. $this->filterTo = '';
  97. $this->filterFrom = '';
  98. $this->filteredMemberId = '';
  99. $this->hasFilter = false;
  100. }
  101. }