iao_team/resources/views/livewire/records_in_out.blade.php

<div class="col">
    <div class="row h-100">


        <div class="col card--ui" id="card--dashboard">


            <header id="title--section" class="d-flex align-items-center justify-content-between">
                <div class="title--section_name d-flex align-items-center justify-content-between">
                    <i class="ico--ui title_section utenti me-2"></i>
                    <h2 class="primary">Entrate/Uscite gestionale</h2>
                </div>



            </header>

            <section id="subheader" class="d-flex align-items-center ">
                <form action="" class=" d-flex align-items-center">

                   <select class="form-select form-select-lg me-1 " id="month"  style="width:150px !important;">
                        <option value="1">Gennaio</option>
                        <option value="2">Febbraio</option>
                        <option value="3">Marzo</option>
                        <option value="4">Aprile</option>
                        <option value="5">Maggio</option>
                        <option value="6">Giugno</option>
                        <option value="7">Luglio</option>
                        <option value="8">Agosto</option>
                        <option value="9">Settembre</option>
                        <option value="10">Ottobre</option>
                        <option value="11">Novembre</option>
                        <option value="12">Dicembre</option>
                    </select>

                    <select class="form-select " style="width:100px !important;" id="year">
                        @for($y=date("Y"); $y>date("Y") - 2; $y--)
                            <option value="{{$y}}">{{$y}}</option>
                        @endfor
                    </select>

                </form>
                @if(sizeof($columns) < 6)
                    <button class="btn--ui show" style="margin-left:5px;">aggiungi</button>
                @endif

                <button class="btn--ui reset" wire:click="clear()" style="margin-left:5px;">reset</button>
                @if($showData)
                    <button class="btn--ui reset" wire:click="export()" style="margin-left:5px;">esporta</button>
                    <button class="btn--ui reset" wire:click="exportYear()" style="margin-left:5px;">esporta anno selezionato</button>
                @endif

            </section>


                <section id="resume-table">

                    <div class="compare--chart_wrapper d-none"></div>

                    <div class="row ">
                        <div class="col-md-12">

                            <h1>Entrate</h1>

                            <table class="table tablesaw tablesaw-stack collaptableIN" >
                                <thead>
                                    <tr>
                                        <th scope="col" style="width:20%;text-align:left"></th>
                                        @foreach($columns as $idx => $column)
                                            <th scope="col cellBorder" style="width:13%;text-align:center">{{$this->getMonth($column)}} <br><a href="#" wire:click="remove({{$idx}})"><i class="fa fa-trash" aria-hidden="true" style="color:red"></i></a></th>
                                        @endforeach
                                        @for($j=sizeof($columns);$j<6;$j++)
                                            <th scope="col cellBorder" style="width:13%;text-align:center">&nbsp;</th>
                                        @endfor
                                    </tr>
                                </thead>
                                <tbody id="checkall-target">

                                    @foreach($rows_in as $in)
                                        <tr data-id="{{$in["id"]}}" data-parent="{{$in["parent_id"]}}">
                                            <td>{!!str_repeat("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;", $in["level"])!!}{{$in["name"]}}</td>
                                            @foreach($columns as $column)
                                                <td class="cellBorder" style="text-align:center">
                                                    @if(isset($records_in[$column][$in["id"]]))
                                                        <span class="tablesaw-cell-content {{$in["level"] == 0 ? 'primary' : ''}}">
                                                        {{formatPrice($records_in[$column][$in["id"]])}}
                                                        </span>
                                                    @else
                                                        &nbsp;
                                                    @endif
                                                </td>
                                            @endforeach
                                            @for($j=sizeof($columns);$j<6;$j++)
                                                <td class="cellBorder">&nbsp;</th>
                                            @endfor
                                        </tr>
                                    @endforeach
                                    <tr>
                                        <td><b>Totale entrate mensili</b></td>
                                        @foreach($columns as $column)
                                            <td class="cellBorder" style="text-align:center">
                                                @php
                                                $total = 0;
                                                @endphp
                                                @foreach($rows_in as $in)
                                                    @if(isset($records_in[$column][$in["id"]]) && $in["level"] == 0)
                                                        @php
                                                        $total += $records_in[$column][$in["id"]];
                                                        @endphp
                                                    @endif
                                                @endforeach
                                                <span class="tablesaw-cell-content primary" style="color:green"><b>{{formatPrice($total)}}</b></span>
                                            </td>
                                        @endforeach
                                        @for($j=sizeof($columns);$j<6;$j++)
                                            <td class="cellBorder">&nbsp;</th>
                                        @endfor
                                    </tr>

                                </tbody>
                                <tfoot>

                                </tfoot>
                            </table>
                        </div>
                    </div>
                    <div class="row ">
                        <div class="col-md-12">

                            <h1>Uscite</h1>

                            <table class="table tablesaw tablesaw-stack collaptableOUT">
                                <thead>
                                    <tr>
                                        <th scope="col" style="width:20%;text-align:left"></th>
                                        @foreach($columns as $idx => $column)
                                            <th scope="col cellBorder" style="width:13%;text-align:center">{{$this->getMonth($column)}} <br><a href="#" wire:click="remove({{$idx}})"><i class="fa fa-trash" aria-hidden="true" style="color:red"></i></a></th>
                                        @endforeach
                                        @for($j=sizeof($columns);$j<6;$j++)
                                            <th scope="col cellBorder" style="width:13%;text-align:center">&nbsp;</th>
                                        @endfor
                                    </tr>
                                </thead>
                                <tbody id="checkall-target">

                                    @foreach($rows_out as $out)
                                        <tr data-id="{{$out["id"] + 1000}}" data-parent="{{$out["parent_id"] != null ? ($out["parent_id"] + 1000) : 0}}">
                                            <td>{!!str_repeat("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;", $out["level"])!!}{{$out["name"]}}</td>
                                            @foreach($columns as $column)
                                                <td class="cellBorder" style="text-align:center">
                                                    @if(isset($records_out[$column][$out["id"]]))
                                                        <span class="tablesaw-cell-content {{$out["level"] == 0 ? 'primary' : ''}}">
                                                        {{formatPrice($records_out[$column][$out["id"]])}}
                                                        </span>
                                                    @else
                                                        &nbsp;
                                                    @endif
                                                </td>
                                            @endforeach
                                            @for($j=sizeof($columns);$j<6;$j++)
                                                <td class="cellBorder">&nbsp;</th>
                                            @endfor
                                        </tr>
                                    @endforeach

                                    <tr>
                                        <td><b>Totale uscite mensili</b></td>
                                        @foreach($columns as $column)
                                            <td class="cellBorder" style="text-align:center">
                                                @php
                                                $total = 0;
                                                @endphp
                                                @foreach($rows_out as $out)
                                                    @if(isset($records_out[$column][$out["id"]]) && $out["level"] == 0)
                                                        @php
                                                        $total += $records_out[$column][$out["id"]];
                                                        @endphp
                                                    @endif
                                                @endforeach
                                                <span class="tablesaw-cell-content primary" style="color:red"><b>{{formatPrice($total)}}</b></span>
                                            </td>
                                        @endforeach
                                        @for($j=sizeof($columns);$j<6;$j++)
                                            <td class="cellBorder">&nbsp;</th>
                                        @endfor
                                    </tr>

                                </tbody>
                                <tfoot>

                                </tfoot>
                            </table>
                        </div>

                    </div>
                </section>



        </div>
    </div>
</div>


@push('scripts')
    <link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
    <style>
        .select2-container--default .select2-selection--single{
            background-color: #E9F0F5;
            border: 0.0625rem solid #DFE5EB;
            font-size: 0.75rem;
        }
        .select2-selection
        {
            height: 38px !important;
        }
        .select2-selection__rendered
        {
            padding-top:3px;
        }
        .select2 {
            width:100% !important;
        }
        .i{
            font-size:16px;
            font-weight:bold;
        }
        .cellBorder
        {
            border-left: 1px solid grey;
        }
    </style>
    <script src="https://code.jquery.com/jquery-2.2.4.min.js" integrity="sha256-BbhdlvQf/xTY9gja0Dq3HiwQF8LaCRTXxZKRutelT44=" crossorigin="anonymous"></script>
    <script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
    <script src="/assets/js/aCollapTable.js"></script>
@endpush

@push('scripts')
    <script>

        Livewire.on('load-table', () => {
            load();
        });


        function load()
        {
            $(document).ready(function(){
                $('.collaptableIN').aCollapTable({
                    startCollapsed: true,
                    addColumn: false,
                    plusButton: '<span class="i"> + </span>',
                    minusButton: '<span class="i"> - </span>'
                });
                $('.collaptableOUT').aCollapTable({
                    startCollapsed: true,
                    addColumn: false,
                    plusButton: '<span class="i"> + </span>',
                    minusButton: '<span class="i"> - </span>'
                });
                $(".act-button-collapse-all").trigger('click');
            });
        }

        load();

        $(document).on("click", ".show", function () {
            var m = $('#month').val();
            var y = $('#year').val();
            @this.show(m, y);
        });

    </script>

@endpush