| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617 |
- <?php
- namespace App\Http\Livewire;
- use Livewire\Component;
- use Livewire\WithPagination;
- use Barryvdh\DomPDF\Facade\Pdf;
- use Illuminate\Support\Facades\Storage;
- use Illuminate\Support\Facades\Mail;
- use Illuminate\Contracts\Validation\Validator;
- use Illuminate\Support\Facades\Log;
- use App\Http\Middleware\TenantMiddleware;
- use Illuminate\Support\Carbon;
- class RecordIN extends Component
- {
- use WithPagination;
- protected $paginationTheme = 'bootstrap';
- protected $listeners = ['setCausal' => 'setCausal', 'refreshMembers' => 'refreshMembers', 'scontoChanged' => 'updateSconto'];
- public $sortField = 'date';
- public $sortAsc = false;
- public $typeIN = "IN";
- public $fromPage = '';
- public $isDuplicate = false;
- public $multiP = false;
- public $from, $to;
- public $multiMonthTo = 0;
- public $multiYearTo = 0;
- public $multiMonthFrom = 0;
- public $multiYearFrom = 0;
- public $createSubscription = 0;
- public $corrispettivo_causal_id = 0;
- public function sortBy($field)
- {
- if ($this->sortField === $field) {
- $this->sortAsc = ! $this->sortAsc;
- } else {
- $this->sortAsc = true;
- }
- $this->sortField = $field;
- }
- public $courseId = 0;
- public $subscriptionId = 0;
- public $course = null;
- public $subscription = null;
- public $rateId = 0;
- public $months = array();
- public $records, $dataId, $member_id, $supplier_id,
- $causal_id,
- $payment_method_id,
- $destination_id,
- $date,
- $month,
- $year,
- $type,
- $deleted,
- $financial_movement,
- $amount,
- $vat,
- $virtual,
- $note,
- $parent,
- $corrispettivo_fiscale,
- $commercial, $update = false, $add = false;
- public $corrispettivo = [];
- public $currentReceip;
- public $filterMember = 0, $filterPaymentMethod = 0, $filterCausals = 0, $filterCourses = 0, $filterFrom = '', $filterTo = '', $filterCommercial = 0;
- public $hasFilter = false;
- public $total = 0;
- public $selectedFilter = '';
- public $multipleIds = [];
- public $multipleAction = '';
- public $first = true;
- public $selectId = 0;
- public $refreshAfter = 0;
- public $sconto = 0;
- public $canSave = true;
- public $newMemberFirstName = '';
- public $newMemberLastName = '';
- public $newMemberEmail = '';
- public $newMemberToComplete = false;
- public $newMemberFiscalCode = '';
- public $newMemberFiscalCodeExist = false;
- public $causals = array();
- public $courses = array();
- public $subscriptions = array();
- public $payments = array();
- public $banks = array();
- public $members = array();
- public $vats = array();
- public $rows = array();
- public $fromCourse = false;
- public $backToRates = false;
- protected $rules = [
- 'member_id' => 'required',
- 'payment_method_id' => 'required',
- 'rows.*.causal_id' => 'required',
- 'rows.*.amount' => 'required'
- ];
- protected $messages = [
- 'member_id.required' => 'La persona è obbligatorio',
- 'payment_method_id.required' => 'Il metodo di pagamento è obbligatorio',
- 'rows.*.causal_id.required' => 'La causale è obbligatoria',
- 'rows.*.amount.required' => 'L\'importo è obbligatorio',
- ];
- public function boot()
- {
- app(TenantMiddleware::class)->setupTenantConnection();
- }
- public function updatedMemberId()
- {
- $this->emit('refresh');
- if ($this->member_id > 0) {
- $member = \App\Models\Member::findOrFail($this->member_id);
- if (!$member->isAdult()) {
- if ($member->father_name != '')
- $this->parent = $member->father_name . " (C.F. " . $member->father_fiscal_code . ")";
- else if ($member->mother_name != '')
- $this->parent = $member->mother_name . " (C.F. " . $member->mother_fiscal_code . ")";
- else
- $this->parent = '';
- }
- $this->virtual = $member->getMoney();
- $this->newMemberFirstName = '';
- $this->newMemberLastName = '';
- $this->newMemberEmail = '';
- $this->newMemberToComplete = false;
- $this->newMemberFiscalCode = '';
- $this->newMemberFiscalCodeExist = false;
- }
- }
- public function updatedCausalId()
- {
- //$this->emit('refresh');
- }
- public function updatedDate()
- {
- //$this->emit('refresh');
- }
- public function hydrate()
- {
- $this->emit('load-select');
- foreach ($this->rows as $i => $row) {
- if (isset($row['course']) && is_array($row['course']) && isset($row['course']['id'])) {
- $this->rows[$i]['course'] = \App\Models\Course::find($row['course']['id']);
- }
- if (isset($row['subscription']) && is_array($row['subscription']) && isset($row['subscription']['id'])) {
- $this->rows[$i]['subscription'] = \App\Models\Subscription::find($row['subscription']['id']);
- }
- }
- }
- /*public function updated() {
- $this->emit('refresh');
- }*/
- public function updatedPaymentMethodId()
- {
- //$this->emit('refresh');
- $this->canSave = $this->checkCanSave();
- }
- public function updatedAmount()
- {
- // $this->emit('refresh');
- $this->canSave = $this->checkCanSave();
- }
- public function updatedCommercial($value)
- {
- $this->emitSelf('refreshMembers');
- }
- public function updateSconto()
- {
- $totalSconto = 0;
- foreach ($this->rows as $row) {
- if (isset($row['sconto']) && $row['sconto'] != null && $row['sconto'] != "") {
- $totalSconto += $this->currencyToDouble($row['sconto']);
- }
- }
- $this->sconto = formatPrice($totalSconto);
- Log::info("Total sconto updated to: " . $this->sconto);
- }
- public function checkCanSave()
- {
- $ret = true;
- if ($this->payment_method_id != null) {
- $payment_method = \App\Models\PaymentMethod::findOrFail($this->payment_method_id);
- if ($payment_method->money) {
- $from = str_replace(".", "", str_replace(",", "", number_format($this->virtual, 2)));
- $this->from = $this->virtual;
- $from = $this->from;
- $to = str_replace(".", "", str_replace(",", "", $this->currencyToDouble($this->amount)));
- $this->to = $this->amount;
- $to = $this->to;
- $ret = $from >= $to;
- }
- }
- return $ret;
- }
- public function refreshMembers()
- {
- if ($this->add || $this->update) {
- if ($this->commercial) {
- $this->members = \App\Models\Member::select(['id', 'first_name', 'last_name', 'fiscal_code'])->orderBy('last_name')->orderBy('first_name')->get();
- } else {
- $this->members = \App\Models\Member::select(['id', 'first_name', 'last_name', 'fiscal_code'])->where('current_status', 2)->orWhere('current_status', 1)->orderBy('last_name')->orderBy('first_name')->get();
- }
- } else
- $this->members = \App\Models\Member::select(['id', 'first_name', 'last_name', 'fiscal_code'])->orderBy('last_name')->orderBy('first_name')->get();
- }
- public function setAmount()
- {
- $tot = 0;
- foreach ($this->rows as $r) {
- $tot += $this->currencyToDouble($r["amount"]);
- }
- $this->amount = $tot;
- $this->canSave = $this->checkCanSave();
- }
- public function resetFields()
- {
- $this->member_id = null;
- $this->supplier_id = null;
- $this->payment_method_id = null;
- $this->destination_id = null;
- $this->commercial = 0;
- $this->corrispettivo_fiscale = false;
- $this->date = date("Y-m-d");
- $this->type = 'IN';
- $this->deleted = false;
- $this->financial_movement = false;
- $this->newMemberFirstName = '';
- $this->newMemberLastName = '';
- $this->newMemberEmail = '';
- $this->newMemberToComplete = false;
- $this->newMemberFiscalCode = '';
- $this->newMemberFiscalCodeExist = false;
- $this->currentReceip = null;
- $this->parent = '';
- $this->courseId = 0;
- $this->subscriptionId = 0;
- $this->rateId = 0;
- $this->backToRates = false;
- $this->months = array();
- $this->rows = array();
- $this->rows[] = array('causal_id' => isset($_GET["causalId"]) ? $_GET["causalId"] : null, 'course_id' => null, 'course' => null, 'subscription_id' => null, 'subscription' => null, 'when' => array(array('month' => date("n"), 'year' => date("Y"), 'period' => '')), 'amount' => null, 'vat_id' => null, 'note' => '', 'commercial' => 0, 'sconto' => 0);
- $this->corrispettivo = [];
- $this->emit('load-data-table');
- }
- public function getMemberProperty()
- {
- $ret = null;
- if ($this->member_id > 0) {
- $ret = \App\Models\Member::findOrFail($this->member_id);
- }
- return $ret;
- }
- public function getCausalProperty()
- {
- $ret = null;
- if ($this->causal_id > 0) {
- $ret = \App\Models\Causal::findOrFail($this->causal_id);
- }
- return $ret;
- }
- public function getCausal($causal)
- {
- $ret = '';
- if ($causal > 0) {
- $ret = \App\Models\Causal::findOrFail($causal)->getTree();
- }
- return $ret;
- }
- public function getPaymentMethod($payment)
- {
- $ret = '';
- if ($payment > 0) {
- $ret = \App\Models\PaymentMethod::findOrFail($payment)->name;
- }
- return $ret;
- }
- function buildTree($records, $parentId = 0)
- {
- $this->causals = array();
- foreach ($records as $record) {
- if ($record->parent_id == $parentId) {
- $children = $this->buildTree($record, $record->id);
- if ($children) {
- $record->children = $children;
- }
- $this->causals[] = $record;
- }
- }
- return $this->causals;
- }
- public function getCausale($records, $indentation)
- {
- foreach ($records as $record) {
- $this->causals[] = array('id' => $record->id, 'name' => $record->getTree(), 'text' => $record->getTree(), 'level' => $indentation);
- if (count($record->childs))
- $this->getCausale($record->childs, $indentation + 1);
- }
- }
- public function getCourses($records, $indentation)
- {
- foreach ($records as $record) {
- $this->courses[] = array('id' => $record->id, 'name' => $record->getDetailsName(), 'text' => $record->getDetailsName(), 'level' => $indentation);
- if (count($record->childs))
- $this->getCourses($record->childs, $indentation + 1);
- }
- }
- public function getSubscriptions($records, $indentation)
- {
- foreach ($records as $record) {
- $this->subscriptions[] = array('id' => $record->id, 'name' => $record->name, 'text' => $record->name, 'level' => $indentation);
- }
- }
- public function mount()
- {
- if (isset($_GET["from"])) {
- $this->fromPage = $_GET["from"];
- }
- $this->causals = array();
- $this->courses = array();
- $this->subscriptions = array();
- $this->multiMonthFrom = date("n");
- $this->multiYearFrom = date("Y");
- $this->multiMonthTo = date("n");
- $this->multiYearTo = date("Y");
- $fisc = \App\Models\Causal::where('corrispettivo_fiscale', true)->first();
- if ($fisc)
- $this->corrispettivo_causal_id = $fisc->id;
- $this->getCausale(\App\Models\Causal::select('id', 'name')->where('parent_id', null)->where('type', 'IN')->get(), 0);
- $this->getCourses(\App\Models\Course::where('parent_id', null)->get(), 0);
- $this->getSubscriptions(\App\Models\Subscription::get(), 0);
- //$this->buildTree(\App\Models\Causal::all(), null);
- $this->refreshMembers();
- $this->payments = \App\Models\PaymentMethod::select('id', 'name')->where('enabled', true)->whereIn('type', array('ALL', 'IN'))->orderBy('name')->get();
- $this->banks = \App\Models\Bank::select('id', 'name')->where('enabled', true)->whereIn('visibility', array('ALL', 'IN'))->orderBy('name')->get();
- $this->vats = \App\Models\Vat::select('id', 'name', 'value')->orderBy('value')->get();
- if ($this->first) {
- if (isset($_GET["new"])) {
- $this->refreshAfter = 1;
- $this->add();
- }
- if (isset($_GET["memberId"])) {
- $this->refreshAfter = 1;
- $this->member_id = $_GET["memberId"];
- $member = \App\Models\Member::findOrFail($this->member_id);
- if (!$member->isAdult()) {
- if ($member->father_name != '')
- $this->parent = $member->father_name . " (C.F. " . $member->father_fiscal_code . ")";
- else if ($member->mother_name != '')
- $this->parent = $member->mother_name . " (C.F. " . $member->mother_fiscal_code . ")";
- else
- $this->parent = '';
- }
- }
- if (isset($_GET["causalId"])) {
- $this->refreshAfter = 1;
- $this->causal_id = $_GET["causalId"];
- }
- if (isset($_GET["id"])) {
- $this->refreshAfter = 1;
- $this->edit($_GET["id"]);
- }
- $count = 0;
- if (isset($_GET["courseId"]) && $_GET["courseId"] > 0) {
- $this->fromCourse = true;
- $this->courseId = $_GET["courseId"];
- $mc = \App\Models\MemberCourse::findOrFail($this->courseId);
- $this->course = \App\Models\Course::findOrFail($mc->course_id);
- $this->rows[0]['course_id'] = $this->course->id;
- $this->rows[0]['course'] = $this->course;
- }
- if (isset($_GET["subscriptionId"]) && $_GET["subscriptionId"] > 0) {
- $this->fromCourse = true;
- $this->subscriptionId = $_GET["subscriptionId"];
- $ms = \App\Models\MemberSubscription::findOrFail($this->subscriptionId);
- $this->subscription = \App\Models\Subscription::findOrFail($ms->subscription_id);
- $this->rows[0]['subscription_id'] = $this->subscription->id;
- $this->rows[0]['subscription'] = $this->subscription;
- }
- if (isset($_GET["rateId"])) {
- $this->rateId = $_GET["rateId"];
- }
- if (isset($_GET["backToRates"])) {
- $this->backToRates = true;
- }
- if (isset($_GET["months"]) && $_GET["months"] != '') {
- $this->fromCourse = true;
- $price = $_GET["price"] / 100 * 100;
- $this->refreshAfter = 1;
- $desc = "Pagamento";
- $months = explode("|", $_GET["months"]);
- $this->months = $months;
- //$this->rows[0]["amount"] = formatPrice($price * sizeof($months));
- $this->rows[0]["amount"] = formatPrice($price);
- $rates = [];
- if (isset($_GET["rateId"])) {
- try {
- $rateIds = explode(",", $_GET["rateId"]);
- $rates = \App\Models\Rate::whereIn('id', $rateIds)->orderBy('date', 'asc')->get();
- } catch (\Throwable $e) {
- }
- $order = [9, 10, 11, 12, 1, 2, 3, 4, 5, 6, 7, 8];
- $index = 0;
- foreach ($rates as $rate) {
- $rate_date = Carbon::createFromFormat("Y-m-d H:i:s", $rate->date);
- $rate_months = json_decode($rate->months, true);
- usort($rate_months, function ($a, $b) use ($order) {
- $posA = array_search($a, $order);
- $posB = array_search($b, $order);
- return $posA <=> $posB;
- });
- foreach ($rate_months as $month) {
- $rate_year = $rate_date->year;
- $rate_month = $rate_date->month;
- if ($rate_month < 9 && $rate_month >= 1) {
- $rate_year -= 1;
- }
- if ($month >= 9 && $month <= 12) {
- } elseif ($month < 9 && $month >= 1) {
- $rate_year += 1;
- }
- $this->rows[0]["when"][$index]["month"] = $month;
- $this->rows[0]["when"][$index]["year"] = $rate_year;
- $index++;
- $desc .= " " . $this->getMonth($month) . " " . $rate_year;
- }
- }
- }
- // foreach ($months as $idx => $m) {
- // $this->rows[0]["when"][$idx]["month"] = $m;
- // if ($m >= date("m"))
- // $this->rows[0]["when"][$idx]["year"] = date("Y");
- // else
- // $this->rows[0]["when"][$idx]["year"] = date("Y") + 1;
- // if ($idx > 0) {
- // if ($this->rows[0]["when"][$idx - 1]["year"] != $this->rows[0]["when"][$idx]["year"])
- // $desc .= " " . $this->rows[0]["when"][$idx - 1]["year"] . " ";
- // }
- // $desc .= " " . $this->getMonth($m); // . " " . $this->rows[0]["when"][$idx]["year"];
- // }
- // $desc .= " " . $this->rows[0]["when"][$idx]["year"];
- $this->rows[0]["note"] = $desc;
- $count += 1;
- }
- if (isset($_GET["createSubscription"]) && $_GET["createSubscription"] == 1) {
- $this->createSubscription = 1;
- if (isset($_GET["courseId"]) && $_GET["courseId"] > 0) {
- $this->courseId = $_GET["courseId"];
- }
- if (isset($_GET["subscriptionId"]) && $_GET["subscriptionId"] > 0) {
- $this->subscriptionId = $_GET["subscriptionId"];
- }
- if ($this->courseId && $this->courseId > 0) {
- $mc = \App\Models\MemberCourse::findOrFail($this->courseId);
- $this->course = \App\Models\Course::findOrFail($mc->course_id);
- }
- if ($this->subscriptionId && $this->subscriptionId > 0) {
- $ms = \App\Models\MemberSubscription::findOrFail($this->subscriptionId);
- $this->subscription = \App\Models\Subscription::findOrFail($ms->subscription_id);
- }
- $this->rateId = $_GET["rateId"];
- $price = $_GET["subscription_price"] / 100 * 100;
- $this->refreshAfter = 1;
- if ($count == 1)
- $this->rows[] = array('causal_id' => null, 'course_id' => null, 'course' => null, 'subscription_id' => null, 'subscription' => null, 'when' => array(array('month' => date("n"), 'year' => date("Y"), 'period' => '')), 'amount' => null, 'vat_id' => null, 'note' => '', 'commercial' => 0);
- $this->rows[$count]["causal_id"] = null;
- $this->rows[$count]["course_id"] = $this->course->id ?? null;
- $this->rows[$count]["course"] = $this->course ?? null;
- $this->rows[$count]["subscription_id"] = $this->subscription->id ?? null;
- $this->rows[$count]["subscription"] = $this->subscription ?? null;
- $this->rows[$count]["amount"] = formatPrice($price);
- $note = implode(", ", array_filter([
- $this->course ? $this->course->name : "",
- $this->subscription ? $this->subscription->name : ""
- ]));
- $this->rows[$count]["note"] = "Pagamento iscrizione " . $note;
- if (isset($_GET["subCausalId"])) {
- $this->refreshAfter = 1;
- $this->rows[$count]["causal_id"] = $_GET["subCausalId"];
- }
- }
- }
- $this->first = false;
- }
- public function search()
- {
- $this->hasFilter = true;
- }
- public function disableSearch()
- {
- $this->filterMember = 0;
- $this->filterPaymentMethod = 0;
- $this->filterCausals = 0;
- $this->filterCourses = 0;
- $this->filterSubscriptions = 0;
- $this->filterTo = '';
- $this->filterFrom = '';
- $this->filterCommercial = 0;
- $this->hasFilter = false;
- $this->total = 0;
- }
- public function render()
- {
- $datas = [];
- return view('livewire.records_in', ['datas' => $datas]);
- }
- public function executeMultipleAction()
- {
- if ($this->multipleAction == 'delete')
- $this->multipleDelete();
- }
- public function add()
- {
- $this->emit('load-select');
- //if ($this->hasFilter)
- $this->emit('hide-search');
- $this->resetFields();
- $this->dataId = 0;
- $this->add = true;
- $this->update = false;
- $this->emit('setEdit', true);
- }
- public function storeCorrispettivo()
- {
- $this->emit('refresh');
- $rules = [
- 'member_id' => 'required'
- ];
- $this->validate($rules);
- foreach ($this->payments as $p) {
- if ($p->corrispettivo_fiscale) {
- $price = isset($this->corrispettivo[$p->id]) ? $this->currencyToDouble($this->corrispettivo[$p->id]) : 0;
- if ($price > 0) {
- $record = \App\Models\Record::create([
- 'member_id' => $this->member_id,
- 'supplier_id' => null,
- 'payment_method_id' => $p->id,
- 'destination_id' => $this->destination_id,
- 'commercial' => $this->commercial,
- 'corrispettivo_fiscale' => $this->corrispettivo_fiscale,
- 'date' => $this->date,
- 'type' => $this->type,
- 'amount' => $price,
- 'financial_movement' => $this->financial_movement,
- 'deleted' => $this->deleted
- ]);
-
- if ($this->courseId && $this->courseId > 0) {
- $mc = \App\Models\MemberCourse::findOrFail($this->courseId);
- $this->course = \App\Models\Course::findOrFail($mc->course_id);
- }
- if ($this->subscriptionId && $this->subscriptionId > 0) {
- $ms = \App\Models\MemberSubscription::findOrFail($this->subscriptionId);
- $this->subscription = \App\Models\Subscription::findOrFail($ms->subscription_id);
- }
- \App\Models\RecordRow::create([
- 'record_id' => $record->id,
- 'causal_id' => $this->corrispettivo_causal_id,
- 'course_id' => $this->course->id ?? null,
- 'subscription_id' => $this->subscription->id ?? null,
- 'note' => '',
- 'amount' => $price,
- 'vat_id' => null,
- 'commercial' => $this->commercial,
- 'when' => json_encode([])
- ]);
- }
- }
- }
- $this->resetFields();
- $this->add = false;
- $this->isDuplicate = false;
- $this->emit('setEdit', false);
- }
- public function store($generate)
- {
- Log::info("Starting store method");
- $this->emit('refresh');
- $rules = [
- 'payment_method_id' => 'required',
- 'rows.*.causal_id' => 'required',
- 'rows.*.amount' => 'required'
- ];
- if (!$this->commercial)
- $rules["member_id"] = 'required';
- $this->validate($rules);
- /* Validazione campi azienda per generazione ricevuta */
- try {
- if (!$this->financial_movement && !$this->commercial) {
- $no_receipt_causal_azienda = false;
- foreach ($this->rows as $row) {
- $no_receipt_causal_azienda = false;
- $cau = \App\Models\Causal::findOrFail($row["causal_id"]);
- if ($cau->no_receipt)
- $no_receipt_causal_azienda = true;
- }
- $azienda = \App\Models\Azienda::first();
- $payment_method = \App\Models\PaymentMethod::findOrFail($this->payment_method_id);
- if (!$payment_method->money) {
- if (!$no_receipt_causal_azienda) {
- if (!$azienda->isValid()) {
- session()->flash('error_ricevuta', implode("", array_map(function ($item) {
- return "<li>$item</li>";
- }, $azienda->validate())));
- return false;
- }
- }
- }
- }
- } catch (\Exception $ex) {
- Log::error("Error in store method: " . $ex->getMessage());
- Log::error("Stack trace: " . $ex->getTraceAsString());
- session()->flash('error', 'Errore (' . $ex->getMessage() . ')');
- }
- /* END - Validazione campi azienda per generazione ricevuta */
- try {
- $totalGross = 0;
- $totalSconto = 0;
- $totalNet = 0;
- foreach ($this->rows as $row) {
- $rowAmount = $this->currencyToDouble($row["amount"]);
- $rowSconto = isset($row['sconto']) ? $this->currencyToDouble($row['sconto']) : 0;
- $rowNet = max(0, $rowAmount - $rowSconto);
- $totalGross += $rowAmount;
- $totalSconto += $rowSconto;
- $totalNet += $rowNet;
- }
- Log::info("Total gross: " . $totalGross . ", Total sconto: " . $totalSconto . ", Total net: " . $totalNet);
- $record = \App\Models\Record::create([
- 'member_id' => $this->member_id,
- 'supplier_id' => $this->supplier_id,
- 'payment_method_id' => $this->payment_method_id,
- 'destination_id' => $this->destination_id,
- 'commercial' => $this->commercial,
- 'corrispettivo_fiscale' => $this->corrispettivo_fiscale,
- 'date' => $this->date,
- 'type' => $this->type,
- 'amount' => $totalNet,
- 'prediscount_amount' => $totalGross,
- 'financial_movement' => $this->financial_movement,
- 'deleted' => $this->deleted,
- 'numero_fattura' => '',
- ]);
- $this->dataId = $record->id;
- $no_receipt_causal = false;
- $vat = 0;
- foreach ($this->rows as $row) {
- foreach ($row["when"] as $x => $y) {
- $row["when"][$x]['period'] = $row["when"][$x]['month'] . "-" . $row["when"][$x]['year'];
- }
- $rowAmount = $this->currencyToDouble($row["amount"]);
- $rowSconto = isset($row['sconto']) ? $this->currencyToDouble($row['sconto']) : 0;
- $rowNet = max(0, $rowAmount - $rowSconto);
- Log::info("Row - Gross: " . $rowAmount . ", Sconto: " . $rowSconto . ", Net: " . $rowNet);
- \App\Models\RecordRow::create([
- 'record_id' => $this->dataId,
- 'causal_id' => $row["causal_id"],
- 'course_id' => $row["course_id"],
- 'subscription_id' => $row["subscription_id"],
- 'note' => $row["note"],
- 'amount' => $rowNet,
- 'prediscount_amount' => $rowAmount,
- 'sconto' => $rowSconto,
- 'vat_id' => $row["vat_id"],
- 'commercial' => $this->commercial,
- 'when' => json_encode($row["when"])
- ]);
- $vat += getVatValue($rowNet, $row["vat_id"]);
- $cau = \App\Models\Causal::findOrFail($row["causal_id"]);
- if ($cau->no_receipt)
- $no_receipt_causal = true;
- if ($cau->money) {
- if ($rowNet >= env('MIN_MONEY', 100)) {
- $money = new \App\Models\Money();
- $money->member_id = $this->member_id;
- $money->record_id = $this->dataId;
- $money->amount = env('EXTRA_MONEY', 10);
- $money->date = date("Y-m-d");
- $money->note = env('EXTRA_MONEY', 10) . ' in più per aver caricato ' . $rowNet;
- $money->save();
- }
- }
- }
- Log::info("Final amount saved to record: " . $totalNet);
- if (!$this->financial_movement) {
- $payment_method = \App\Models\PaymentMethod::findOrFail($this->payment_method_id);
- if (!$payment_method->money) {
- if ($generate && !$no_receipt_causal)
- $this->createReceipt();
- }
- }
- if ($this->rateId > 0) {
- $rates = explode(",", $this->rateId);
- foreach ($rates as $rid) {
- $rate = \App\Models\Rate::findOrFail($rid);
- $rate->status = 1;
- $rate->record_id = $record->id;
- $rate->save();
- }
- }
- if ($this->backToRates) {
- if ($this->courseId > 0)
- return redirect()->to("/rates?member_id={$this->member_id}&member_course_id={$this->courseId}");
- if ($this->subscriptionId > 0)
- return redirect()->to("/rates?member_id={$this->member_id}&member_subscription_id={$this->subscriptionId}");
- }
- session()->flash('success', 'Movimento creato');
- $this->resetFields();
- $this->add = false;
- $this->isDuplicate = false;
- $this->emit('setEdit', false);
- } catch (\Exception $ex) {
- Log::error("Error in store method: " . $ex->getMessage());
- Log::error("Stack trace: " . $ex->getTraceAsString());
- session()->flash('error', 'Errore (' . $ex->getMessage() . ')');
- }
- }
- public function duplicate($id)
- {
- $record = \App\Models\Record::findOrFail($id);
- $newRecord = $record->replicate();
- $newRecord->save();
- $rows = \App\Models\RecordRow::where('record_id', $id)->get();
- foreach ($rows as $r) {
- $newRow = $r->replicate();
- $newRow->record_id = $newRecord->id;
- $newRow->save();
- }
- $this->edit($newRecord->id);
- $this->isDuplicate = true;
- }
- public function edit($id)
- {
- if (!isset($_GET["from"]) && $this->fromPage == '')
- $this->fromPage = 'in';
- $this->emit('setEdit', true);
- //if ($this->hasFilter)
- $this->emit('hide-search');
- $this->emit('load-select');
- try {
- $record = \App\Models\Record::findOrFail($id);
- if (!$record) {
- session()->flash('error', 'Movimento non trovato');
- } else {
- if ($record->member_id) {
- $member = \App\Models\Member::find($record->member_id);
- if (!$member || $member->status == 'archived') {
- $this->member_id = null;
- } else {
- $this->member_id = $record->member_id;
- }
- } else {
- $this->member_id = $record->member_id;
- }
- if ($record->payment_method_id) {
- $paymentMethod = \App\Models\PaymentMethod::find($record->payment_method_id);
- if (!$paymentMethod || (isset($paymentMethod->hidden) && $paymentMethod->hidden)) {
- $this->payment_method_id = null;
- } else {
- $this->payment_method_id = $record->payment_method_id;
- }
- } else {
- $this->payment_method_id = $record->payment_method_id;
- }
- $this->destination_id = $record->destination_id;
- $this->supplier_id = $record->supplier_id;
- $this->amount = $record->amount;
- $this->commercial = $record->commercial;
- $this->corrispettivo_fiscale = $record->corrispettivo_fiscale;
- $this->date = date("Y-m-d", strtotime($record->date));
- $this->type = $record->type;
- $this->deleted = $record->deleted;
- $this->financial_movement = $record->financial_movement;
- $this->dataId = $record->id;
- $this->update = true;
- $this->add = false;
- $rows = \App\Models\RecordRow::where('record_id', $this->dataId)
- ->select('causal_id', 'course_id', 'subscription_id', 'note', 'commercial', 'when', 'amount', 'prediscount_amount', 'sconto', 'vat_id')
- ->get();
- $this->rows = [];
- foreach ($rows as $i => $r) {
- $grossAmount = $r->prediscount_amount ?? ($r->amount + $r->sconto);
- $causalId = $r->causal_id;
- if ($causalId) {
- $causal = \App\Models\Causal::find($causalId);
- if (!$causal || (isset($causal->hidden) && $causal->hidden)) {
- $causalId = null;
- }
- }
- $course = null;
- if ($r->course_id) {
- try {
- $course = \App\Models\Course::findOrFail($r->course_id);
- } catch (\Throwable $th) {
- }
- }
- $subscription = null;
- if ($r->subscription_id) {
- try {
- $subscription = \App\Models\Subscription::findOrFail($r->subscription_id);
- } catch (\Throwable $th) {
- }
- }
- $this->rows[] = [
- 'causal_id' => $causalId,
- 'course_id' => $r->course_id,
- 'course' => $course,
- 'subscription_id' => $r->subscription_id,
- 'subscription' => $subscription,
- 'note' => $r->note,
- 'commercial' => $r->commercial,
- 'when' => json_decode($r->when),
- 'amount' => formatPrice($grossAmount),
- 'sconto' => formatPrice($r->sconto),
- 'vat_id' => $r->vat_id
- ];
- }
- $exist = \App\Models\Receipt::where('record_id', $id)->orderBy('id', 'DESC')->first();
- if ($exist != null) {
- $this->currentReceip = $exist;
- $this->parent = $this->currentReceip->parent;
- }
- $this->refreshEditOptions();
- }
- } catch (\Exception $ex) {
- Log::error("Error in edit method: " . $ex->getMessage());
- session()->flash('error', 'Errore (' . $ex->getMessage() . ')');
- }
- }
- private function refreshEditOptions()
- {
- $this->causals = array();
- $visibleCausals = \App\Models\Causal::select('id', 'name')
- ->where('parent_id', null)
- ->where('type', 'IN')
- ->where(function ($query) {
- $query->where('hidden', false)->orWhereNull('hidden');
- })
- ->get();
- $this->getCausale($visibleCausals, 0);
- $this->payments = \App\Models\PaymentMethod::select('id', 'name')
- ->where('enabled', true)
- ->whereIn('type', array('ALL', 'IN'))
- ->where(function ($query) {
- $query->where('hidden', false)->orWhereNull('hidden');
- })
- ->orderBy('name')
- ->get();
- if ($this->commercial) {
- $this->members = \App\Models\Member::select(['id', 'first_name', 'last_name', 'fiscal_code'])
- ->where(function ($query) {
- $query->where('status', '!=', 'archived');
- })
- ->orderBy('last_name')
- ->orderBy('first_name')
- ->get();
- } else {
- $this->members = \App\Models\Member::select(['id', 'first_name', 'last_name', 'fiscal_code'])
- ->where(function ($query) {
- $query->where('current_status', 2)->orWhere('current_status', 1);
- })
- ->where(function ($query) {
- $query->where('status', '!=', 'archived');
- })
- ->orderBy('last_name')
- ->orderBy('first_name')
- ->get();
- }
- }
- public function update($generate = false)
- {
- Log::info("Starting update method");
- $this->emit('refresh');
- $rules = [
- 'payment_method_id' => 'required',
- 'rows.*.causal_id' => 'required',
- 'rows.*.amount' => 'required'
- ];
- if (!$this->commercial)
- $rules["member_id"] = 'required';
- $this->validate($rules);
- /* Validazione campi azienda per generazione ricevuta */
- try {
- if (!$this->financial_movement && !$this->commercial) {
- $no_receipt_causal_azienda = false;
- foreach ($this->rows as $row) {
- $no_receipt_causal_azienda = false;
- $cau = \App\Models\Causal::findOrFail($row["causal_id"]);
- if ($cau->no_receipt)
- $no_receipt_causal_azienda = true;
- }
- $azienda = \App\Models\Azienda::first();
- $payment_method = \App\Models\PaymentMethod::findOrFail($this->payment_method_id);
- if (!$payment_method->money) {
- if (!$no_receipt_causal_azienda) {
- if (!$azienda->isValid()) {
- session()->flash('error_ricevuta', implode("", array_map(function ($item) {
- return "<li>$item</li>";
- }, $azienda->validate())));
- return false;
- }
- }
- }
- }
- } catch (\Exception $ex) {
- Log::error("Error in store method: " . $ex->getMessage());
- Log::error("Stack trace: " . $ex->getTraceAsString());
- session()->flash('error', 'Errore (' . $ex->getMessage() . ')');
- }
- /* END - Validazione campi azienda per generazione ricevuta */
- try {
- $totalGross = 0;
- $totalSconto = 0;
- $totalNet = 0;
- foreach ($this->rows as $row) {
- $rowAmount = $this->currencyToDouble($row["amount"]);
- $rowSconto = isset($row['sconto']) ? $this->currencyToDouble($row['sconto']) : 0;
- $rowNet = max(0, $rowAmount - $rowSconto);
- $totalGross += $rowAmount;
- $totalSconto += $rowSconto;
- $totalNet += $rowNet;
- }
- Log::info("Total gross: " . $totalGross . ", Total sconto: " . $totalSconto . ", Total net: " . $totalNet);
- \App\Models\Record::whereId($this->dataId)->update([
- 'member_id' => $this->member_id,
- 'supplier_id' => $this->supplier_id,
- 'payment_method_id' => $this->payment_method_id,
- 'destination_id' => $this->destination_id,
- 'commercial' => $this->commercial,
- 'corrispettivo_fiscale' => $this->corrispettivo_fiscale,
- 'date' => date("Y-m-d", strtotime($this->date)),
- 'type' => $this->type,
- 'financial_movement' => $this->financial_movement,
- 'deleted' => $this->deleted,
- 'amount' => $totalNet,
- 'prediscount_amount' => $totalGross,
- ]);
- $no_receipt_causal = false;
- $vat = 0;
- \App\Models\RecordRow::where('record_id', $this->dataId)->delete();
- foreach ($this->rows as $row) {
- foreach ($row["when"] as $x => $y) {
- $row["when"][$x]['period'] = $row["when"][$x]['month'] . "-" . $row["when"][$x]['year'];
- }
- $rowAmount = $this->currencyToDouble($row["amount"]);
- $rowSconto = isset($row['sconto']) ? $this->currencyToDouble($row['sconto']) : 0;
- $rowNet = max(0, $rowAmount - $rowSconto);
- Log::info("Row - Gross: " . $rowAmount . ", Sconto: " . $rowSconto . ", Net: " . $rowNet);
- \App\Models\RecordRow::create([
- 'record_id' => $this->dataId,
- 'causal_id' => $row["causal_id"],
- 'course_id' => $row["course_id"],
- 'subscription_id' => $row["subscription_id"],
- 'note' => $row["note"],
- 'vat_id' => $row["vat_id"],
- 'amount' => $rowNet,
- 'prediscount_amount' => $rowAmount,
- 'sconto' => $rowSconto,
- 'commercial' => $this->commercial,
- 'when' => json_encode($row["when"])
- ]);
- $vat += getVatValue($rowNet, $row["vat_id"]);
- $cau = \App\Models\Causal::findOrFail($row["causal_id"]);
- if ($cau->no_receipt)
- $no_receipt_causal = true;
- }
- Log::info("Final amount saved to record: " . $totalNet);
- if (!$this->financial_movement) {
- $payment_method = \App\Models\PaymentMethod::findOrFail($this->payment_method_id);
- if (!$payment_method->money) {
- if ($generate && !$no_receipt_causal)
- $this->createReceipt();
- }
- }
- session()->flash('success', 'Movimento aggiornato');
- if ($this->backToRates) {
- if ($this->courseId > 0)
- return redirect()->to("/rates?member_id={$this->member_id}&member_course_id={$this->courseId}");
- if ($this->subscriptionId > 0)
- return redirect()->to("/rates?member_id={$this->member_id}&member_subscription_id={$this->subscriptionId}");
- }
- $this->resetFields();
- $this->update = false;
- $this->isDuplicate = false;
- $this->emit('setEdit', false);
- } catch (\Exception $ex) {
- Log::error("Error in update method: " . $ex->getMessage());
- Log::error("Stack trace: " . $ex->getTraceAsString());
- session()->flash('error', 'Errore (' . $ex->getMessage() . ')');
- }
- }
- public function rigenerate()
- {
- $this->emit('refresh');
- try {
- $record = \App\Models\Record::findOrFail($this->dataId);
- $newRecord = $record->replicate();
- $newRecord->date = date("Y-m-d");
- $newRecord->save();
- $recordRows = \App\Models\RecordRow::where('record_id', $this->dataId)->get();
- // Inserisco le righe
- foreach ($recordRows as $row) {
- $newRow = $row->replicate();
- $newRow->record_id = $newRecord->id;
- $newRow->save();
- }
- $this->dataId = $newRecord->id;
- $this->createReceipt();
- session()->flash('success', 'Movimento aggiornato');
- $this->resetFields();
- $this->update = false;
- $this->isDuplicate = false;
- $this->emit('setEdit', false);
- } catch (\Exception $ex) {
- session()->flash('error', 'Errore (' . $ex->getMessage() . ')');
- }
- }
- public function cancel()
- {
- // Se arrivo da duplica elimino
- if ($this->isDuplicate) {
- try {
- \App\Models\Record::find($this->dataId)->delete();
- session()->flash('success', "Movimento eliminato");
- } catch (\Exception $e) {
- session()->flash('error', 'Errore (' . $e->getMessage() . ')');
- }
- }
- $this->isDuplicate = false;
- $this->add = false;
- $this->update = false;
- $this->resetFields();
- $this->emit('setEdit', false);
- return redirect()->to('/in');
- }
- public function delete($id)
- {
- try {
- $r = \App\Models\Record::find($id);
- // Annullo la ricevuta
- $receipt = \App\Models\Receipt::where('record_id', $r->id)->first();
- if ($receipt) {
- $receipt->status = 99;
- sendReceiptDeleteEmail($receipt);
- $receipt->save();
- }
- if ($r->member_course_id > 0) {
- $months = json_decode($r->months);
- $c = \App\Models\MemberCourse::findOrFail($r->member_course_id);
- $xxx = json_decode($c->months);
- foreach ($xxx as $idx => $mm) {
- if (in_array($mm->m, $months)) {
- $xxx[$idx]->status = "";
- }
- }
- $c->months = json_encode($xxx);
- $c->save();
- }
- if ($r->member_subscription_id > 0) {
- $months = json_decode($r->months);
- $s = \App\Models\MemberSubscription::findOrFail($r->member_subscription_id);
- $xxx = json_decode($s->months);
- foreach ($xxx as $idx => $mm) {
- if (in_array($mm->m, $months)) {
- $xxx[$idx]->status = "";
- }
- }
- $s->months = json_encode($xxx);
- $s->save();
- }
- $r->deleted = true;
- $r->save();
- session()->flash('success', 'Movimento aggiornato');
- $this->resetFields();
- $this->update = false;
- $this->isDuplicate = false;
- $this->emit('setEdit', false);
- $this->emit('reload');
- //$this->emit('load-data-table');
- } catch (\Exception $ex) {
- session()->flash('error', 'Errore (' . $ex->getMessage() . ')');
- }
- }
- public function multipleDelete()
- {
- try {
- foreach ($this->multipleIds as $id) {
- \App\Models\Record::find($id)->delete();
- }
- } catch (\Exception $e) {
- session()->flash('error', 'Errore (' . $e->getMessage() . ')');
- }
- $this->multipleAction = '';
- }
- public function createMember()
- {
- $this->newMemberFiscalCodeExist = false;
- $this->validate([
- // 'newMemberFiscalCode'=>'required|max:16',
- 'newMemberFirstName' => 'required',
- 'newMemberLastName' => 'required',
- //'newMemberEmail'=>'required',
- ]);
- // Check fiscal code exist
- $exist = false;
- if ($this->newMemberFiscalCode != '') {
- $check = \App\Models\Member::where('fiscal_code', $this->newMemberFiscalCode)->get();
- $exist = $check->count() > 0;
- }
- if (!$exist) {
- $member = \App\Models\Member::create([
- 'first_name' => strtoupper($this->newMemberFirstName),
- 'last_name' => strtoupper($this->newMemberLastName),
- 'email' => strtoupper($this->newMemberEmail),
- 'to_complete' => $this->newMemberToComplete,
- 'fiscal_code' => $this->newMemberFiscalCode,
- 'status' => true
- ]);
- $this->member_id = $member->id;
- $this->members = \App\Models\Member::select(['id', 'first_name', 'last_name', 'fiscal_code'])->get();
- // $this->emit('reloadMembers');
- $this->emit('refresh');
- $this->newMemberFirstName = '';
- $this->newMemberLastName = '';
- $this->newMemberEmail = '';
- $this->newMemberToComplete = false;
- $this->newMemberFiscalCode = '';
- $this->emit('saved');
- //$this->validate();
- $this->selectId++;
- } else {
- $this->newMemberFiscalCodeExist = true;
- }
- }
- public function createReceipt()
- {
- // Ulteriore controllo commerciale/non commerciale
- if (!$this->commercial) {
- $create = false;
- $receipt = \App\Models\Receipt::where('record_id', $this->dataId)->orderBy('id', 'DESC')->first();
- if ($receipt != null) {
- // Controllo lo stato, se 99 ne genero una nuova
- if ($receipt->status == 99) {
- $create = true;
- }
- } else {
- $create = true;
- }
- if ($create) {
- $number = 1;
- $exist = \App\Models\Receipt::where('year', date("Y"))->orderBy('number', 'DESC')->first();
- if ($exist != null)
- $number = $exist->number + 1;
- // Calculate totals for the receipt
- $totalGross = 0;
- $totalNet = 0;
- foreach ($this->rows as $row) {
- $rowAmount = $this->currencyToDouble($row["amount"]);
- $rowSconto = isset($row['sconto']) ? $this->currencyToDouble($row['sconto']) : 0;
- $rowNet = max(0, $rowAmount - $rowSconto);
- $totalGross += $rowAmount;
- $totalNet += $rowNet;
- }
- $receipt = \App\Models\Receipt::create([
- 'record_id' => $this->dataId,
- 'member_id' => $this->member_id,
- 'supplier_id' => $this->supplier_id,
- 'payment_method_id' => $this->payment_method_id,
- 'number' => $number,
- 'date' => $this->date,
- 'year' => date("Y"),
- 'type' => $this->type,
- 'parent' => $this->parent,
- 'status' => 1,
- ]);
- foreach ($this->rows as $row) {
- $rowAmount = $this->currencyToDouble($row["amount"]);
- $rowSconto = isset($row['sconto']) ? $this->currencyToDouble($row['sconto']) : 0;
- $rowNet = max(0, $rowAmount - $rowSconto);
- Log::info("Receipt Row - Gross: " . $rowAmount . ", Sconto: " . $rowSconto . ", Net: " . $rowNet);
- \App\Models\ReceiptRow::create([
- 'receip_id' => $receipt->id,
- 'causal_id' => $row["causal_id"],
- 'course_id' => $row["course_id"],
- 'subscription_id' => $row["subscription_id"],
- 'note' => $row["note"],
- 'vat_id' => $row["vat_id"],
- 'amount' => $rowNet,
- 'prediscount_amount' => $rowAmount,
- 'sconto' => $rowSconto,
- 'commercial' => $row["commercial"],
- 'when' => json_encode($row["when"])
- ]);
- }
- $this->currentReceip = $receipt;
- sendReceiptEmail($receipt);
- session()->flash('receipt', "Ricevuta " . $number . "/" . date("Y") . " creata correttamente");
- $this->emit('showReceipt', $this->currentReceip->id);
- }
- }
- }
- public function removeReceipt()
- {
- $receipt = \App\Models\Receipt::findOrFail($this->currentReceip->id);
- $receipt->status = 99;
- $receipt->save();
- sendReceiptDeleteEmail($receipt);
- $this->currentReceip = $receipt;
- }
- function currencyToDouble($val)
- {
- $x = str_replace("€", "", $val);
- $x = str_replace(".", "", $x);
- $x = str_replace(",", ".", $x);
- return floatval(trim($x));
- }
- public function addRow()
- {
- $this->rows[] = array('causal_id' => null, 'course_id' => null, 'course' => null, 'subscription_id' => null, 'subscription' => null, 'when' => array(array('month' => date("n"), 'year' => date("Y"), 'period' => '')), 'amount' => null, 'vat_id' => null, 'note' => '', 'commercial' => 0);
- $this->emit('load-select');
- }
- public function delRow($idx)
- {
- unset($this->rows[$idx]);
- // $this->emit('load-select');
- }
- public function addPeriod($idx)
- {
- $x = sizeof($this->rows[$idx]['when']) - 1;
- $newDate = \Carbon\Carbon::create($this->rows[$idx]['when'][$x]["year"] . "-" . $this->rows[$idx]['when'][$x]["month"] . '-01')->addMonth();
- $this->rows[$idx]['when'][] = array('month' => $newDate->format("n"), 'year' => $newDate->format("Y"), 'period' => '');
- }
- public function delPeriod($idx, $xxx)
- {
- array_splice($this->rows[$idx]['when'], $xxx, $xxx);
- //unset($this->rows[$idx]['when'][$xxx]);
- // $this->emit('load-select');
- }
- public function getTotal()
- {
- $total = 0.00;
- foreach ($this->rows as $r) {
- if ($r["amount"] != null && $r["amount"] != "") {
- $rowAmount = $this->currencyToDouble($r["amount"]);
- $rowSconto = isset($r['sconto']) ? $this->currencyToDouble($r['sconto']) : 0;
- $netAmount = max(0, $rowAmount - $rowSconto);
- $total += $netAmount;
- if ($r["vat_id"] > 0)
- $total += getVatValue($netAmount, $r["vat_id"]);
- }
- }
- return formatPrice($total);
- }
- public function getTotalCorrispettivo()
- {
- $total = 0.00;
- foreach ($this->corrispettivo as $r) {
- $total += $this->currencyToDouble($r);
- }
- return formatPrice($total);
- // $this->emit('load-select');
- }
- public function getPrice()
- {
- $total = 0.00;
- foreach ($this->rows as $r) {
- if ($r["amount"] != null && $r["amount"] != "")
- $total += $this->currencyToDouble($r["amount"]);
- }
- return formatPrice($total);
- // $this->emit('load-select');
- }
- public function getVat()
- {
- $total = 0.00;
- foreach ($this->rows as $r) {
- if ($r["amount"] != null && $r["amount"] != "" && $r["vat_id"] > 0)
- $total += getVatValue($this->currencyToDouble($r["amount"]), $r["vat_id"]);
- }
- return formatPrice($total);
- // $this->emit('load-select');
- }
- public function getVats()
- {
- $vats = array();
- foreach ($this->rows as $r) {
- if ($r["amount"] != null && $r["amount"] != "" && $r["vat_id"] > 0) {
- $vat = getVatValue($this->currencyToDouble($r["amount"]), $r["vat_id"]);
- $vatName = "";
- foreach ($this->vats as $v) {
- if ($v->id == $r["vat_id"])
- $vatName = $v->name;
- }
- if (isset($vats[$vatName]))
- $vats[$vatName] += $vat;
- else
- $vats[$vatName] = $vat;
- }
- }
- return $vats;
- // $this->emit('load-select');
- }
- public function setCausal($id, $idx)
- {
- $this->rows[$idx]["causal_id"] = $id;
- }
- public function printReceipt()
- {
- //$pdf = PDF::loadView('pdf/receipt', array('datas' => $datas, 'from' => $x, 'to' => $y, 'who' => '', 'matricola' => $matricola));
- $pdf = PDF::loadView('receipt', array('receipt' => $this->currentReceip)); //->output();
- $pdfName = "Ricevuta_" . $this->currentReceip->member->last_name . "_" . $this->currentReceip->number . "_" . $this->currentReceip->year . ".pdf";
- return $pdf->stream();
- /*return response()->streamDownload(
- fn () => print($pdf),
- "ricevuta_" . $this->currentReceip->number . "_" . $this->currentReceip->year . ".pdf"
- );*/
- /*return response()->streamDownload(function () {
- echo $pdf->stream();
- }, 'test.pdf');*/
- }
- public function multiPeriod()
- {
- $this->multiP = true;
- }
- public function multiPeriodCreate($idx)
- {
- $period = \Carbon\CarbonPeriod::create($this->multiYearFrom . '-' . $this->multiMonthFrom . '-01', '1 month', $this->multiYearTo . '-' . $this->multiMonthTo . '-01');
- $this->rows[$idx]['when'] = [];
- foreach ($period as $dt) {
- if (!in_array(array('month' => $dt->format("n"), 'year' => $dt->format("Y"), 'period' => ''), $this->rows[$idx]['when']))
- $this->rows[$idx]['when'][] = array('month' => $dt->format("n"), 'year' => $dt->format("Y"), 'period' => '');
- }
- $this->multiP = false;
- }
- public function multiPeriodCancel()
- {
- $this->multiP = false;
- }
- public function getMonth($m)
- {
- $ret = '';
- switch ($m) {
- case 1:
- $ret = 'Gennaio';
- break;
- case 2:
- $ret = 'Febbraio';
- break;
- case 3:
- $ret = 'Marzo';
- break;
- case 4:
- $ret = 'Aprile';
- break;
- case 5:
- $ret = 'Maggio';
- break;
- case 6:
- $ret = 'Giugno';
- break;
- case 7:
- $ret = 'Luglio';
- break;
- case 8:
- $ret = 'Agosto';
- break;
- case 9:
- $ret = 'Settembre';
- break;
- case 10:
- $ret = 'Ottobre';
- break;
- case 11:
- $ret = 'Novembre';
- break;
- case 12:
- $ret = 'Dicembre';
- break;
- default:
- $ret = '';
- break;
- }
- return $ret;
- }
- public function setYear($idx, $xxx)
- {
- $m = $this->rows[$idx]["when"][$xxx]["month"];
- $this->rows[$idx]["when"][$xxx]["year"] = $m < env('FISCAL_YEAR_MONTH_FROM', 1) ? (date("Y") + 1) : date("Y");
- }
- }
|