Gecko [ 36julay.space ]

Name	Size	Permission	Date
dist	[ DIR ]	drwxr-xr-x	2025-09-13 20:44
js	[ DIR ]	drwxr-xr-x	2025-09-13 23:17
smilies	[ DIR ]	drwxr-xr-x	2025-09-13 20:12
wp	[ DIR ]	drwxr-xr-x	2025-09-13 22:32
37julay_space.zip	2.9 MB	-rw-r--r--	2025-08-27 07:31
all_list.php	2.1 KB	-rw-r--r--	2024-10-25 15:16
bpbluyix.php	0 B	-rw-r--r--	2025-09-13 18:11
cardTokenName-20250913201821.txt	8 B	-rw-r--r--	2025-05-29 16:31
cardTokenName.txt	8 B	-rw-r--r--	2025-05-29 16:31
config.php	392 B	-rw-r--r--	2024-12-04 06:50
delete_data.php	6.51 KB	-rw-r--r--	2025-01-29 08:05
generate_token.php	1.12 KB	-rw-r--r--	2024-11-06 08:08
htaccess-20250913202320.txt	120 B	-rw-r--r--	2025-08-21 08:56
htaccess.txt	120 B	-rw-r--r--	2025-08-21 08:56
index.php	7.03 KB	-rw-r--r--	2025-09-10 08:54
smartRate.txt	2 B	-rw-r--r--	2025-08-20 19:12
smartTokenName.txt	8 B	-rw-r--r--	2025-05-29 16:31
work_history.php	4.6 KB	-rw-r--r--	2024-11-15 10:39
wp-blog-header.php	0 B	-rw-r--r--	2025-09-13 14:51
wp-cron-20250913205049.php	0 B	-rw-r--r--	2025-09-13 16:20
wp-cron.php	0 B	-rw-r--r--	2025-09-13 16:20

Rename

<?php include_once("header.php"); ?>

<div class=" my-2 overflow-auto">
    
    <div class="row mb-4">
        
        <div class="col-md-6">
            <div class="card text-center">
                <div class="card-body">
                    <h5 class="card-title"> Total Work</h5>
                    <p id="totalOrders" class="card-text">0</p>
                </div>
            </div>
        </div>
        
        <div class="col-md-6">
            <div class="card text-center">
                <div class="card-body">
                    <h5 class="card-title"> Work Total Price</h5>
                    <p id="totalPrice" class="card-text">0</p>
                </div>
            </div>
        </div>
    </div>

<label for="dateFilter">Filter by Days:</label>
    <select id="dateFilter" class="form-select mb-3">
        <option value="1">Today</option>
        <option value="3">Last 3 Days</option>
        <option value="7">Last 7 Days</option>
        <option value="10">Last 10 Days</option>
        <option value="15">Last 15 Days</option>
        <option value="20">Last 20 Days</option>
        <option value="25">Last 25 Days</option>
        <option value="30">Last 30 Days</option>
        <option value="all">All Days</option>
    </select>

<table id="myTable" class="table table-striped table-hover">
        <thead>
            <tr>
                <th>#</th>
                <th>ইমেইল</th>
                <th>কাজের ধরন</th>
                <th>পূর্ববর্তী ব্যাল্যন্স</th>
                <th>কাজের রেইট</th>
                <th>পরর্বতী ব্যাল্যন্স</th>
                <th>কাজের সময়</th>
            </tr>
        </thead>
        <tbody></tbody>
    </table>
</div>

<?php include_once("footer.php"); ?>

// Function to update summary cards based on selected days
        function updateSummaryCards(days) {
            $.ajax({
                url: 'get_work_summary.php',  // PHP file for summary values
                method: 'GET',
                data: { days: days },
                dataType: 'json',
                success: function(data) {
                    $('#totalOrders').text(data.totalOrders);
                    $('#totalPrice').text(data.totalPrice);
                },
                error: function(xhr, status, error) {
                    console.error("Error fetching summary data:", error);
                }
            });
        }

// Function to fetch and update table data with filtering option
        function fetchAndUpdateData(days) {
            $.ajax({
                url: 'get_work_history.php',
                method: 'GET',
                data: { days: days },
                dataType: 'json',
                success: function(data) {
                    table.clear();
                    let counter = 1;
                    data.forEach(function(row) {
                        table.row.add([
                            counter++,
                            row.email,
                            row.orderType,
                            row.beforeBalance,
                            row.price,
                            row.afterBalance,
                            row.orderTime
                        ]).draw(false);
                    });
                },
                error: function(xhr, status, error) {
                    console.error("Error fetching data:", error);
                }
            });
        }

// Initial load with today's data
        const initialDays = 1;
        fetchAndUpdateData(initialDays);
        updateSummaryCards(initialDays);

// Update cards and table based on the filter selection
        $('#dateFilter').on('change', function() {
            const selectedDays = $(this).val();
            fetchAndUpdateData(selectedDays);
            updateSummaryCards(selectedDays);
        });
    });
</script>