@extends('layouts.layout')
@section('body_class', 'nav-md')
@section('body_content')
    <div class="container body">
        <div class="main_container">
            @include('includes.sidebar')
            <div class="right_col" role="main">
                <div class="page-title">
                    <div class="title_left">
                        <div class="row">
                            <div class="col-xs-6 col-sm-6 col-md-6">
                                <h2 class="title-dashboard text-left">
                                    <h3>Report Transaksi LM</h3>
                                </h2>
                            </div>
                            @if (!$cmk_lei)
                                <div class="col-xs-6 col-sm-6 col-md-6 text-right">
                                    PPH Config &nbsp;
                                    <button type="button" class="btn btn-secondary" id="show_pph_config"
                                        onclick="openPphConfig()"><i class="fa fa-cog"></i></button>
                                </div>
                            @endif
                        </div>

                    </div>
                    <div class="clearfix"></div>
                </div>

                <div class="row">
                    <div class="col-xs-12 col-sm-6">
                        <div class="x_panel">
                            <div class="x_title">
                                Filter
                            </div>
                            <div class="x_content">
                                <form id="form-search" class="form-horizontal">
                                    <div class="col-xs-12 col-sm-12">
                                        <div class="form-group">
                                            <label class="col-xs-12 col-sm-4 control-label">Brand Emas :</label>
                                            <div class="col-xs-12 col-sm-8">
                                                <select name="brand" id="brand" class="form-control">
                                                    <option value="">-- Pilih Brand --</option>
                                                    <option value="ubs">UBS </option>
                                                    <option value="lm_certieye"> ANTAM </option>
                                                    <option value="lm_certieye_shio"> ANTAM SHIO </option>
                                                    <option value="lm_retro">Retro</option>
                                                    <option value="hartadinata"> Hartadinata </option>
                                                    <option value="idn_spesial"> IDN Spesial     </option>
                                                    <option value="star_gold"> Star Gold </option>
                                                </select>
                                            </div>
                                        </div>
                                        <div class="form-group">
                                            <label class="col-xs-12 col-sm-4 control-label">Type Sales Order:</label>
                                            <div class="col-xs-12 col-sm-8">
                                                <select name="transaction_type" id="transaction_type" class="form-control">
                                                    <option value="">-- Pilih Transaction Type --</option>
                                                    <option value="stock">Stock </option>
                                                    <option value="po"> PO </option>
                                                    <option value="cicil">cicil</option>
                                                </select>
                                                {{-- <select class="js-example-basic-multiple form-control" name="transaction_type[]" id="transaction_type" multiple="multiple">
                                                    <option value="">-- Pilih Transaction Type --</option>
                                                    <option value="stock">Stock</option>
                                                    <option value="po"> PO</option>
                                                    <option value="cicil">Cicil</option>
                                                </select> --}}

                                            </div>
                                        </div>

                                        <div class="form-group">
                                            <label class="col-xs-12 col-sm-4 control-label">Nomor Invoice :</label>
                                            <div class="col-xs-12 col-sm-8">
                                                <input type="text" class="form-control " name="invoice" id="invoice"
                                                    placeholder="Invoice">
                                            </div>
                                        </div>

                                        {{-- <div class="form-group">
                                            <label class="col-xs-12 col-sm-4 control-label">Note :</label>
                                            <div class="col-xs-12 col-sm-8">
                                                <input type="text" class="form-control " name="note" id="note"
                                                    placeholder="Note">
                                            </div>
                                        </div> --}}

                                        <div class="form-group">
                                            <label class="col-xs-12 col-sm-4 control-label">Brand Toko :</label>
                                            <div class="col-xs-12 col-sm-8">
                                                <select name="store" id="store" class="form-control">
                                                    <option value="">-- Pilih brand --</option>
                                                    @foreach ($store as $data)
                                                        <option value="{{ $data->id }}">{{ $data->name }}</option>
                                                    @endforeach
                                                </select>
                                            </div>
                                        </div>

                                        <div class="form-group">
                                            <label class="col-xs-12 col-sm-4 control-label">Nama Toko :</label>
                                            <div class="col-xs-12 col-sm-8">
                                                <select name="toko" id="toko" class="form-control">
                                                    <option value="">-- Pilih Toko --</option>
                                                </select>
                                            </div>
                                        </div>

                                        <div class="form-group">
                                            <label class="col-xs-12 col-sm-4 control-label">Status Transaksi :</label>
                                            <div class="col-xs-12 col-sm-8">
                                                <select name="status" id="status" class="form-control">
                                                    <option value="">-- Pilih Status --</option>
                                                    <option value="sudah" selected>Sudah</option>
                                                    <option value="belum">Belum</option>
                                                    <option value="menunggu_pembayaran">Menunggu Pembayaran</option>
                                                    <option value="menunggu_sm">Menunggu Sm</option>
                                                    <option value="batal">Batal</option>
                                                    <option value="ditolak">Ditolak</option>
                                                    <option value="sedang_berjalan">Sedang berjalan</option>
                                                </select>
                                            </div>
                                        </div>

                                        <div class="form-group">
                                            <label class="col-xs-12 col-sm-4 control-label">Status Barang :</label>
                                            <div class="col-xs-12 col-sm-8">
                                                <select name="status_barang" id="status_barang" class="form-control">
                                                    <option value="">-- Pilih Status --</option>
                                                    <option value="sudah_ada_sertifikat" selected>Sudah Ada Sertifikat</option>
                                                    <option value="belum_ada_sertifikat">Belum Ada Sertifikat</option>
                                                </select>
                                            </div>
                                        </div>

                                        <div class="form-group">
                                            <label class="col-xs-12 col-sm-4 control-label">Payment Method :</label>
                                            <div class="col-xs-12 col-sm-8">
                                                <select name="payment_method" id="payment_method" class="form-control">
                                                    <option value="">-- Pilih Payment Method --</option>
                                                    <option value="cash">Cash</option>
                                                    <option value="transfer">Transfer</option>
                                                    <option value="blibli">Blibli</option>
                                                </select>
                                            </div>
                                        </div>

                                        <div class="form-group">
                                            <label class="col-xs-12 col-sm-4 control-label">Tanggal Transaksi :</label>
                                            <div class="col-xs-4 col-sm-4">
                                                <input type="text" class="form-control date_format" name="from_date"
                                                    id="from_date" placeholder="Tanggal Mulai">
                                            </div>
                                            {{-- <div class="col-xs-4 col-sm-1 text-center" style="line-height: 34px;">-</div> --}}
                                            <div class="col-xs-4 col-sm-4">
                                                <input type="text" class="form-control date_format" name="end_date"
                                                    id="end_date" placeholder="Tanggal Selesai">
                                            </div>
                                        </div>

                                        {{-- <div class="form-group">
                                            <label class="col-xs-12 col-sm-4 control-label">Tanggal Selesai :</label>
                                            <div class="col-xs-12 col-sm-4">
                                                <input type="text" class="form-control date_format" name="end_date"
                                                    id="end_date" placeholder="Tanggal Selesai">
                                            </div>
                                        </div> --}}

                                        <div class="form-group" style="margin-top:20px">
                                            <label class="col-xs-12 col-sm-5 control-label"></label>
                                            <div class="col-xs-12 col-sm-7">
                                                <button type="submit" class="btn btn-primary btn-search"><i
                                                        class="fa fa-search"></i> Search</button>
                                                <button type="button" class="btn btn-warning" id="reset_btn"><i
                                                        class="fa fa-trash"></i> Reset</button>
                                            </div>
                                        </div>
                                    </div>
                                </form>
                            </div>
                        </div>

                        <div class="row">
                            <div class="col-sm-6">
                                <div class="x_panel">
                                    <div class="x_title">
                                        <b>TOTAL PENJUALAN (GROSS)</b>
                                    </div>
                                    <div class="x_content" id="total_rupiah_gross">
                                        <i class="fa fa-spinner fa-pulse fa-2x"></i>
                                    </div>
                                </div>
                                <div class="x_panel">
                                    <div class="x_title">
                                        <b>TOTAL PENJUALAN (PPH)</b>
                                    </div>
                                    <div class="x_content" id="total_rupiah_pph">
                                        <i class="fa fa-spinner fa-pulse fa-2x"></i>
                                    </div>
                                </div>
                                <div class="x_panel">
                                    <div class="x_title">
                                        <b>TOTAL PENJUALAN (NET)</b>
                                    </div>
                                    <div class="x_content" id="total_rupiah_net">
                                        <i class="fa fa-spinner fa-pulse fa-2x"></i>
                                    </div>
                                </div>
                            </div>
                            <div class="col-sm-6">
                                <div class="x_panel">
                                    <div class="x_title">
                                        <b>TOTAL PENJUALAN QTY & GRAMASI</b>
                                    </div>
                                    <div class="x_content" id="total_gramasi">
                                        <i class="fa fa-spinner fa-pulse fa-2x"></i>
                                    </div>
                                </div>
                            </div>
                            <div class="col-sm-6">
                                <div class="x_panel">
                                    <div class="x_title">
                                        <b>TOTAL CUSTOMER</b>
                                    </div>
                                    <div class="x_content" id="total_customer">
                                        <i class="fa fa-spinner fa-pulse fa-2x"></i>
                                    </div>
                                </div>
                            </div>
                            <div class="col-sm-6">
                                <div class="x_panel">
                                    <div class="x_title">
                                        <b>TOTAL STORE</b>
                                    </div>
                                    <div class="x_content" id="total_store">
                                        <i class="fa fa-spinner fa-pulse fa-2x"></i>
                                    </div>
                                </div>
                            </div>
                        </div>

                        <div class="x_panel">
                            <div class="x_title">
                                <div style="font-size: 15px; padding-top: 2px;">
                                    Unsent Transaction : <b>{{ $ttl_unsent_cmk }}</b>
                                    @if ($ttl_unsent_cmk)
                                        <button class="btn btn-sm btn-info" style="font-size: 11px;"
                                            onclick="pushTrxAll()"> <i class="fa fa-upload"></i> Send All to CMK</button>
                                    @endif
                                </div>
                            </div>
                        </div>
                    </div>

                    <div class="col-xs-12 col-sm-6">
                        <div class="row">
                            <div class="col-sm-12">
                                <div class="x_panel">
                                    <div class="x_title" id="summary_pecahan">
                                        <table class="table table-bordered table-striped">
                                            <thead>
                                                <tr>
                                                    <th>Brand</th>
                                                    <th>Item</th>
                                                    <th class="text-right">QTY</th>
                                                    <th class="text-right">Total Nett</th>
                                                </tr>
                                            </thead>
                                            <tbody id="load_summary">
                                                <tr>
                                                    <td colspan="4" class="text-center">
                                                        <h3><i class="fa fa-spinner fa-pulse"></i></h3>
                                                    </td>
                                                </tr>
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

                <div class="row">
                    <div class="col-xs-12">
                        <div class="x_panel">
                            <div class="form-group">
                                <p>
                                    <a class="btn btn-success" data-toggle="collapse" href="#collapseExample" role="button"
                                        aria-expanded="false" aria-controls="collapseExample">
                                        Log Download
                                    </a>
                                </p>
                                <div class="collapse" id="collapseExample">
                                    <div class="card card-body">
                                        <table id="myTable" class="table table-bordered table-striped"
                                            style="zoom: 0.75;">
                                            <thead>
                                                <tr>
                                                    <th class="text-center">Tanggal</th>
                                                    <th class="text-center">Nama</th>
                                                    <th class="text-center">File Name</th>
                                                    <th class="text-center">Status</th>
                                                    <th class="text-center">Action</th>
                                                </tr>
                                            </thead>
                                            <tbody id="load_summary_customer">
                                                @foreach ($download_file as $data)
                                                    <tr>
                                                        <td class="text-left">{{ $data->created_at }}</td>
                                                        <td class="text-left">
                                                            {{ $data->users->name }}
                                                            <div>
                                                                <small>({{ $data->users->username }})</small>
                                                            </div>
                                                        </td>
                                                        <td class="text-left">{{ $data->file_name }}</td>
                                                        <td class="text-left">
                                                            @if ($data->status == '1')
                                                                Berhasil
                                                            @elseif ($data->status == '2')
                                                                <span class="text-danger"><i>Gagal, load data tinggi</i></span>
                                                            @endif
                                                        </td>
                                                        <td class="text-left">
                                                            @if ($data->status == '1')
                                                                @php
                                                                    $hasDownloadReady = true;
                                                                @endphp

                                                                <a href="{{ route('cmk_lei/sell/download_ready_file', [
                                                                    'name' => $data->file_name,
                                                                ]) }}"
                                                                    target="_blank" class="btn btn-success"
                                                                    id="btn_ready_download" onclick="downloadReadyFile()"
                                                                    style="display: ;"><i class="fa fa fa-check"></i>
                                                                    Download File
                                                                </a>
                                                            @endif
                                                        </td>
                                                    </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-xs-12">
                        <div class="x_panel">
                            <div class="x_content">
                                <div class="text-right">
                                    {{-- <button type="button" target="_blank" class="btn btn-success"
                                    id="download_data">Download Log</button> --}}
                                    {{-- <button type="button" target="_blank" class="btn btn-warning"
                                    id="download_data_invoice">Download Invoice</button> --}}
                                    @if ($download_ready)
                                        @if ($download_ready->download_for == 'report_sell_cmk_lei_pdf')
                                            @if ($download_ready->status == '0')
                                                <button class="btn btn-warning" id="prosess" style="display: show;" disabled><i
                                                    class="fa fa fa-pulse fa-clock-o"></i> Sedang mendownload file</button>
                                            @else
                                            <button type="button" id="download_data_invoice" target="_blank" class="btn btn-warning" style="display: ;">
                                                Download Invoice
                                            </button>
                                            @endif
                                        @else
                                        <button type="button" id="download_data_invoice" target="_blank" class="btn btn-warning" style="display: ;">
                                                                        Download Invoice
                                        </button>
                                        @endif
                                    @else
                                            <button type="button" id="download_data_invoice" target="_blank" class="btn btn-warning" style="display: ;">
                                                Download Invoice
                                            </button>
                                    @endif


                                    @if ($download_ready)
                                        @if ($download_ready->download_for == 'report_sell_cmk_lei')
                                            @if ($download_ready->status == '0')
                                                <button class="btn btn-primary" id="prosess" style="display: show;" disabled><i
                                                    class="fa fa fa-pulse fa-clock-o"></i> Sedang mendownload file</button>
                                            @else
                                                <button type="button" target="_blank" class="btn btn-primary"
                                                    id="download_data">Download Report</button>
                                            @endif
                                        @else
                                        <button type="button" target="_blank" class="btn btn-primary"
                                            id="download_data">Download Report</button>
                                        @endif
                                    @else
                                        <button type="button" target="_blank" class="btn btn-primary"
                                                id="download_data">Download Report</button>
                                    @endif
                                    <button type="button" target="_blank" class="btn btn-success"
                                                id="download_data_excel">Download Report Excel</button>
                                    {{-- <button type="button" class="btn btn-success" id="show_data"> Show Data</button> --}}

                                    </div>
                                    <div class="table-responsive">
                                    <table id="table" class="table table-bordered table-striped">
                                        <thead>
                                            <tr>
                                                <th>No.</th>
                                                <th>Transaction Date</th>
                                                <th>Status Transaksi</th>
                                                <th>Type SO</th>
                                                <th>Payment Method</th>
                                                <th>Invoice</th>
                                                <th>Location Transaction</th>
                                                <th>Notes</th>
                                                <th>Customer Name</th>
                                                <th>JR Name</th>
                                                <th>Total Transaksi</th>
                                                @if (!$cmk_lei)
                                                    <th>Action</th>
                                                @endif
                                                <th>#</th>
                                                @if ($cmk_lei)
                                                    <th>#</th>
                                                @endif
                                            </tr>
                                        </thead>
                                        <tbody class="response" id="scroll">
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            @if (!$cmk_lei)
                <div class="modal fade" id="modal_pph_config" data-backdrop="false" tabindex="-1" role="dialog">
                    <div class="modal-dialog" role="document">
                        <div class="modal-content">
                            <div class="modal-header">
                                <h4 class="modal-title">Setting PPH</h4>
                            </div>
                            <div class="modal-body">
                                <label class="label-control">PPH With NPWP %</label>
                                <div class="form-group">
                                    <input type="text" class="form-control pph_npwp decimal" name="pph_npwp"
                                        id="pph_npwp" value="{{ $setting_pph['pph_npwp'] }}">
                                </div>
                                <label class="label-control">PPH With NO NPWP %</label>
                                <div class="form-group">
                                    <input type="text" class="form-control pph_nonpwp decimal" name="pph_nonpwp"
                                        id="pph_nonpwp" value="{{ $setting_pph['pph_nonpwp'] }}">
                                </div>
                            </div>
                            <div class="modal-footer">
                                <button type="button" class="btn btn-sm waves-effect btn-clus"
                                    data-dismiss="modal">Close</button>
                                <button type="button" class="btn btn-sm btn-oke waves-effect btn-primary"
                                    id="pph_config_submit">Save</button>
                            </div>
                        </div>
                    </div>
                </div>
            @endif
            <input type="hidden" id="is_downloaded" value="0">

            @include('includes.footer')
        </div>
    </div>
@endsection
<link rel="stylesheet" href="https://cdn.datatables.net/1.13.7/css/jquery.dataTables.css" />
    <script src="https://cdn.datatables.net/1.13.7/js/jquery.dataTables.js"></script>
@section('scripts')
    @include('includes.helper_js')
    {{-- <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script> --}}
    <script>
        $(document).ready(function() {
            $('.js-example-basic-multiple').select2();
        });
        $(document).ready(function() {
            $('#myTable').DataTable({
                searching: false,
                lengthChange: false,
                pageLength: 5,
                order: [
                    [0, 'desc']
                ]
            });
        });
        $(document).ready(function() {
            @if ($download_ready)
                @if ($download_ready->status == '0')
                    setInterval(() => {
                        var is_downloaded = $('#is_downloaded').val();
                        if (is_downloaded == '0') {
                            check_download_proceess({{ $download_ready->id }});
                        }
                    }, 5000);
                @endif
            @endif
        });

        function check_download_proceess(id) {
            $.ajax({
                url: "{{ url('/cmk_lei/sell/check_download_process') }}/" + id,
                method: "GET",
                headers: {
                    'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                },
            }).done(function(response) {
                if (response.status == "completed") {
                    $('#is_downloaded').val(1);
                    $('#file_download').show();
                    $('#prosess').hide();

                    alert("Proses Download Anda Selesai")
                    location.reload();
                }
                
                if (response.status == "failed") {
                    alert("Proses Download Anda Gagal, load download data Anda tinggi !")
                    location.reload();
                }
            });
            return false;
        }

        $(document).ready(function() {
			$('#status_barang').val('').attr('disabled', true);
            $('#store').on('change', function() {
                var IdToko = $(this).val();

                // Reset the #toko dropdown
                $('#toko').empty();
                $('#toko').append('<option value="">-- Pilih Toko --</option>');

                if (IdToko) {
                    $.ajax({
                        url: '/getToko/' + IdToko,
                        type: "GET",
                        data: {
                            "_token": "{{ csrf_token() }}"
                        },
                        dataType: "json",
                        success: function(data) {
                            if (data) {
                                $.each(data, function(key, toko) {
                                    $('select[name="toko"]').append('<option value="' +
                                        toko.id + '">' + toko.cmk_code + " - " +
                                        toko.name +
                                        '</option>');
                                });
                            }
                        }
                    });
                }
            });
        });
        $(document).ready(function() {
            setTimeout(function() {
                getTotalSum();
            }, 1000);
        });
		
		$('#status').change(function() {
			let trx_type = $('#transaction_type').val();
			$('#status_barang').val('').attr('disabled', true);
			if($(this).val() == 'sudah' && trx_type == 'po') {
				$('#status_barang').attr('disabled', false);
			}
		});

		$('#transaction_type').change(function() {
			let status = $('#status').val();
			$('#status_barang').val('').attr('disabled', true);
			if($(this).val() == 'po' && status == 'sudah') {
				$('#status_barang').attr('disabled', false);
			}
		});

        function getTotalSum() {
            var fromDate = $('input[name="from_date"]').val();
            var toDate = $('input[name="end_date"]').val();

            Axios.post('/butik/sell/get_total_sum', {
                    cmk_lei: {{ $cmk_lei }},
                    from: fromDate,
                    to: toDate,
                    brand: $('#brand').val(),
                    transaction_type: $('#transaction_type').val(),
                    invoice: $('input[name="invoice"]').val(),
                    store: $('#store').val(),
                    toko: $('#toko').val(),
                    status: $('#status').val(),
                    status_barang: $('#status_barang').val(),
                    payment_method: $('#payment_method').val(),
                    ajax_initial: firstLoad ? 1 : 0, // 🔹 tambahkan flag load pertama
                })
                .then(function(response) {
                    $('#total_rupiah_gross').html('Rp. ' + response.data.data['rupiah_gross']);
                    $('#total_rupiah_pph').html('Rp. ' + response.data.data['rupiah_pph']);
                    $('#total_rupiah_net').html('Rp. ' + response.data.data['rupiah_net']);
                    
                    let html_grammasi_qty = response.data.data['qty'] + ' Keping | ' + response.data.data['gramasi'] + ' Gram';
                    $('#total_gramasi').html(html_grammasi_qty);
                    $('#total_customer').html('<i class="fa fa-users"></i> ' + response.data.data['ttl_customer']);
                    $('#total_store').html('<i class="fa fa-shopping-basket"></i> ' + response.data.data['ttl_store']);

                    
                    get_summary_pecahan();
                    // Setelah selesai, ubah flag supaya request berikutnya dianggap bukan pertama
                    firstLoad = false;
                })
                .catch(function(error) {
                    Helper.handleErrorResponse(error);
                });
        }


        $('.btn-search').click(function() {
            $('#total_rupiah').html('<i class="fa fa-spinner fa-pulse fa-2x"></i>');
            $('#total_gramasi').html('<i class="fa fa-spinner fa-pulse fa-2x"></i>');
            $('#load_summary').html(
                '<tr><td colspan="4" class="text-center"><h3><i class="fa fa-spinner fa-pulse"></i></h3></td></tr>'
            );
            setTimeout(function() {
                getTotalSum();
            }, 1000);
        });

        let firstLoad = true;

        function get_summary_pecahan() {
            Axios.post('/butik/sell/get_summary_pecahan', {
                cmk_lei: {{ $cmk_lei }},
                from: $('input[name="from_date"]').val(),
                to: $('input[name="end_date"]').val(),
                brand: $('#brand').val(),
                transaction_type: $('#transaction_type').val(),
                invoice: $('input[name="invoice"]').val(),
                store: $('#store').val(),
                toko: $('#toko').val(),
                status: $('#status').val(),
                payment_method: $('#payment_method').val(),
                status_barang: $('#status_barang').val(),
                ajax_initial: firstLoad ? 1 : 0, // 🔹 kirim flag juga
            })
            .then(function(response) {
                $('#summary_pecahan').html(response.data);
                firstLoad = false;
            })
            .catch(function(error) {
                Helper.handleErrorResponse(error)
            });
        }

        $(function() {
            var d = new Date();
            var startDate = d.setMonth(d.getMonth() - 1);
            var e = new Date();
            var endDate = e.setDate(e.getDate());
            Helper.datePicker('date_format', null, endDate);
            // $('input[name="from_date"]').val(moment().format('DD-MM-YYYY'));
            $('input[name="from_date"]').val('{{ '01' . date('-m-Y') }}');
            
            $('input[name="end_date"]').val(moment(endDate).format('DD-MM-YYYY'));
            Helper.decimalInput('.decimal');

        });

        function openPphConfig() {
            $('#modal_pph_config').modal('show');
        }

        @if ($cmk_lei)
            //route
            var url_datatables = '/cmk_lei/sell/transaction/report/datatables_cmk_lei';
        @else
            var url_datatables = '/butik/sell/transaction/report/datatables';
        @endif
		
        // jalankan datatable hanya sekali
        tbl = globalCRUD.datatables({
            url: url_datatables,
            selector: '#table',
            columnsField: [
                'DT_RowIndex',
                {
                    data: 'transaction_date',
                    name: 'transaction_date',
                    render: function(data) {
                        return data ? moment(data).format("DD MMMM YYYY") : '-';
                    }
                },
                {
                    data: 'payment_status',
                    name: 'payment_status',
                    render: function(data) {
                        return data === 'sudah' ? 'completed' : data;
                    }
                },
                {
                    data: 'type_so',
                    name: 'type_so',
                },
                'payment_method',
                {
                    data: 'invoice_sell',
                    name: 'invoice_sell',
                    render: function(data, type, full) {
                        // Jika type_so == 'cicil', maka tampilkan potongan saja
                        if (full.type_so != 'cicil') {
                            return data.substr(12, 30); // misalnya hanya sebagian
                            // atau bisa return '-' jika ingin disembunyikan
                            // return '-';
                        }

                        // Jika bukan 'cicil', tampilkan seluruh data
                        return data;
                    }
                },
                {
                    data: 'loc_store',
                    name: 'loc_store',
                    render: function(data, type, full) {
                        if (full.store_id != {{ env('STORE_PUSAT_LAKUEMAS') }}) {
                            if ((full.created_at).substr(0, 10).replaceAll('-', '') > 20230530) {
                                return (full.store && full.store.cmk_code && full.store.name)
                                    ? full.store.cmk_code + ' - ' + full.store.name
                                    : full.customer_address;
                            }
                        }
                        return data;
                    }
                },
                {
                    data: 'notes',
                    name: 'notes',
                    render: function(data, type, full) {
                        if (full.store_id == {{ env('STORE_PUSAT_LAKUEMAS') }}) {
                            if ((full.created_at).substr(0, 10).replaceAll('-', '') > 20230530) {
                                return full.notes_store_po.cmk_store ? full.notes_store_po.cmk_store.m_nama : '~';
                            }
                        }
                        return data;
                    }
                },
                'customer_name',
                {
                    data: 'item',
                    name: 'item',
                    render: function(data, type, full) {
                        if (full.store_id == {{ env('STORE_PUSAT_LAKUEMAS') }}) {
                            return full.notes_jrname + ' (' + full.notes_jrnik + ')';
                        }
                        return (full.created_by?.name || '-') + ' (' + (full.created_by?.username || '-') + ')';
                    }
                },
                {
                    data: 'grand_total',
                    name: 'grand_total',
                    render: function(data) {
                        return data ? 'Rp. ' + Helper.toCurrencyVal(data) : '-';
                    }
                },
                @if (!$cmk_lei)
                {
                    data: 'payment',
                    name: 'payment',
                    render: function(data, type, full) {
                        if (data && data.invoice_photo) {
                            return '<a href="{{ env('ALIYUN_OSS_IMAGE_URL_BUTIK') }}/sell/invoice/' +
                                data.invoice_photo +
                                '"><b style="color: #EC407A; font-size: 15px;"><i class="fa fa-download"></i></b></a>';
                        }
                        return '<i class="fa fa-download" style="cursor: not-allowed"></i>';
                    }
                },
                @endif
                {
                    data: 'id',
                    name: 'id',
                    render: function(data) {
                        return '<a href="{{ url('butik/sell/transaction/detail') }}/' + data +
                            '"><b style="color: #EC407A; font-size: 15px;"><i class="fa fa-file"></i></b></a>';
                    }
                },
                @if ($cmk_lei)
                {
                    data: 'response_cmk_api',
                    name: 'response_cmk_api',
                    render: function(data, type, full) {
                        if (full.response_status == '200') {
                            return '<i class="fa fa-handshake-o" style="cursor: not-allowed"></i>';
                        } else {
                            return '<a href="#" onclick="pushTrx(' + full.id +
                                ')"><b style="color: #EC407A; font-size: 15px;"><i class="fa fa-upload"></i></b></a>';
                        }
                    }
                }
                @endif
            ],
            actionLink: ""
        });
        // search datatables;
        $("#form-search").submit(function(e) {
            e.preventDefault();
            tbl.datatablesSearch($(this), tbl, url_datatables);
        });
        //reset field pencarian
        $("#reset_btn").click(function(e) {
            e.preventDefault();
            $('input[name="from_date"]').val('');
            $('input[name="end_date"]').val('');
            $('#brand').val('');
            $('input[name="invoice"]').val('');
            $('#toko').val('');
            $('#status').val('');
        });

        $("#download_data").click(function(e) {
            var name = $('input[name="from_date"]').val();
            var phone = $('input[name="end_date"]').val();
            var brand = $('#brand').val();
            var invoice = $('input[name="invoice"]').val();
            var transaction_type = $('#transaction_type').val();
            var payment_method = $('#payment_method').val();
            var store = $('#store').val();
            var toko = $('#toko').val();
            var status = $('#status').val();
            var status_barang = $('#status_barang').val();

            var url = '/butik/sell/transaction/report/download';
            // Log the value of the 'store' variable
            console.log("Store value:", store);

            url = url + '?from_date=' + name + '&end_date=' + phone + '&brand=' + brand + '&invoice=' + invoice +
                '&store=' + store + '&toko=' + toko + '&transaction_type=' + transaction_type + '&status_barang=' + status_barang + '&payment_method=' + payment_method + '&status=' + status + '&cmk_lei={{ $cmk_lei }}';
				
            Helper.redirectTo(url);
            // console.log(url);
            e.preventDefault();
        });

        $("#download_data_excel").click(function(e) {
            var name = $('input[name="from_date"]').val();
            var phone = $('input[name="end_date"]').val();
            var brand = $('#brand').val();
            var invoice = $('input[name="invoice"]').val();
            var transaction_type = $('#transaction_type').val();
            var payment_method = $('#payment_method').val();
            var store = $('#store').val();
            var toko = $('#toko').val();
            var status = $('#status').val();
            var status_barang = $('#status_barang').val();

            var url = '/butik/sell/transaction/excel/download';
            // Log the value of the 'store' variable
            console.log("Store value:", store);

            url = url + '?from_date=' + name + '&end_date=' + phone + '&brand=' + brand + '&invoice=' + invoice +
                '&store=' + store + '&toko=' + toko + '&transaction_type=' + transaction_type + '&status_barang=' + status_barang + '&payment_method=' + payment_method + '&status=' + status + '&cmk_lei={{ $cmk_lei }}';
				
            Helper.redirectTo(url);
            // console.log(url);
            e.preventDefault();
        });

         $("#download_data_invoice").click(function(e) {
            var name = $('input[name="from_date"]').val();
            var phone = $('input[name="end_date"]').val();
            var brand = $('#brand').val();
            var invoice = $('input[name="invoice"]').val();
            var transaction_type = $('#transaction_type').val();
            var payment_method = $('#payment_method').val();
            var store = $('#store').val();
            var toko = $('#toko').val();
            var status = $('#status').val();
            var status_barang = $('#status_barang').val();

            var url = '/cmk_lei/sell/pdf_general';
            // Log the value of the 'store' variable
            console.log("Store value:", store);

            url = url + '?from_date=' + name + '&end_date=' + phone + '&brand=' + brand + '&invoice=' + invoice +
                '&store=' + store + '&toko=' + toko + '&transaction_type=' + transaction_type + '&status_barang=' + status_barang + '&payment_method=' + payment_method + '&status=' + status  + '&cmk_lei={{ $cmk_lei }}';
				
            Helper.redirectTo(url);
            // console.log(url);
            e.preventDefault();
        });

        $('#pph_config_submit').click(function() {
            Axios.post('/butik/sell/update_config_pph/', {
                    pph_npwp: $('#pph_npwp').val(),
                    pph_nonpwp: $('#pph_nonpwp').val()
                })
                .then(function(response) {
                    Helper.successNotif('Update pph config has been succeed !');
                    $('#modal_pph_config').modal('hide');
                    location.reload();
                })
                .catch(function(error) {
                    Helper.handleErrorResponse(error)
                });
        });

        function pushTrx(id) {
            if (confirm("Apakah Anda yakin ingin mengirim transaksi ini ke CMK ?") == true) {
                if (confirm("Anda bener - benar yakin kan ?") == true) {
                    location.href = '{{ url('cmk_lei/sell/push_to_cmk') }}/' + id;
                }
            }
        }

        function pushTrxAll() {
            if (confirm("Apakah Anda yakin ingin mengirim semua transaksi ini ke CMK ?") == true) {
                if (confirm("Anda bener - benar yakin kan ?") == true) {
                    location.href = '{{ url('cmk_lei/sell/push_all_to_cmk') }}';
                }
            }
        }
    </script>
@endsection