@extends('Admin.layout')
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.2/css/all.min.css">
<link rel="stylesheet" href="https://cdn.datatables.net/2.3.4/css/dataTables.bootstrap5.css">

<style>
    .Link {
        text-decoration: underline;
    }
</style>

@section('content')
<div class="row align-items-center justify-content-between mb-3">
    <!-- Heading -->
    <div class="col-auto">
        <h5> <button type="button" class="btn btn-icon bg-white waves-effect me-2"
                style="box-shadow: 0px 9px 12px -2px #66328E1F;">
                <a href="product_info"><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24"
                        viewBox="0 0 24 24" fill="none" stroke="#000" stroke-width="2" stroke-linecap="round"
                        stroke-linejoin="round" class="icon icon-tabler icons-tabler-outline icon-tabler-chevron-left">
                        <path stroke="none" d="M0 0h24v24H0z" fill="none" />
                        <path d="M15 6l-6 6l6 6" />
                    </svg>
                </a></button>View Sales</h5>
    </div>

    <!-- Button -->
    <div class="col-auto">
        <button id="exportviewsalesBtn" class="btn buttons-collection btn-label-secondary dropdown-toggle me-4"
            tabindex="0" aria-controls="DataTables_Table_0" type="button" aria-haspopup="dialog"
            aria-expanded="false"><span><span class="d-flex align-items-center gap-2"><i
                        class="icon-base ti tabler-upload icon-xs me-sm-1"></i>
                    <span class="d-sm-inline-block">Export</span></span></span></button>
    </div>
</div>


<div class="card">

    <div class="card-datatable table-responsive pt-0">
        <table id="salesview" class="table">
            <thead>
                <tr>
                    <th>SNO</th>
                    <th>DATE</th>
                    <th>STAFF NAME</th>
                    <th>CUSTOMER NAME</th>
                    <th>AMOUNT</th>
                    <th>ACTIONS</th>
                </tr>
            </thead>
            <tbody>
                
            </tbody>

        </table>
    </div><!--  -->
</div>


<script src="https://code.jquery.com/jquery-3.7.1.js"></script>
<script src="https://cdn.datatables.net/2.3.4/js/dataTables.js"></script>
<script src="https://cdn.datatables.net/2.3.4/js/dataTables.bootstrap5.js"></script>

<script>
var jq = jQuery.noConflict();

jq(document).ready(function () {
    jq('#salesview').DataTable({
        processing: true,
        serverSide: true,
        ajax: "{{ route('view_sales_table_data') }}",
        columns: [
            { data: 'DT_RowIndex', orderable: false, searchable: false },
            { data: 'created_at', name: 'created_at' },
            { data: 'staff_name', name: 'user.name' },
            { data: 'customer_name', name: 'customer_name' },
            { data: 'total_amount', name: 'total_amount' },
            { data: 'action', orderable: false, searchable: false }
        ],
        order: [[1, 'desc']],
        scrollX: true,
        language: {
            search: "",
            searchPlaceholder: "Search sales",
            lengthMenu: "_MENU_"
        }
    });
});
</script>

<script>
    document.getElementById("exportviewsalesBtn").addEventListener("click", function() {
        let table = document.getElementById("salesview");
        let rows = Array.from(table.querySelectorAll("tr"));

        let csv = rows.map(row => {
            let cells = Array.from(row.querySelectorAll("th, td"));
            return cells.map(cell => `"${cell.innerText}"`).join(",");
        }).join("\n");

        let blob = new Blob([csv], {
            type: "text/csv"
        });
        let url = URL.createObjectURL(blob);

        let a = document.createElement("a");
        a.href = url;
        a.download = "sales_table.csv";
        a.click();

        URL.revokeObjectURL(url);
    });
</script>

@endsection