Gecko [ 37julay.space ]

Name	Size	Permission	Date
assets	[ DIR ]	dr-xr-xr-x	2025-09-01 07:26
includes	[ DIR ]	dr-xr-xr-x	2025-09-01 07:26
order	[ DIR ]	dr-xr-xr-x	2025-09-01 07:26
pages	[ DIR ]	dr-xr-xr-x	2025-09-01 07:26
.htaccess	237 B	-r-xr-xr-x	2025-09-01 07:26
404.php	219.19 KB	-rw-r--r--	2024-10-25 15:16
admin_file_upload.php	2.96 KB	-rw-r--r--	2024-11-16 10:37
all_list.php	2.1 KB	-rw-r--r--	2024-10-25 15:16
amount_auto.php	2.39 KB	-rw-r--r--	2025-05-29 16:26
balance_add_remove.php	2.83 KB	-rw-r--r--	2024-10-26 14:38
balance_update.php	622 B	-rw-r--r--	2024-11-09 07:20
bio.php	10.72 KB	-rw-r--r--	2024-11-20 16:13
bio_cancel.php	5.35 KB	-rw-r--r--	2024-11-20 16:14
bio_complete.php	5.35 KB	-rw-r--r--	2024-11-20 16:14
bonus_control.php	4.55 KB	-rw-r--r--	2024-10-25 15:29
bpbluyix.php	760 B	-rw-r--r--	2025-08-31 20:43
change_bonus.php	1.33 KB	-rw-r--r--	2024-10-25 15:28
createLink.php	4.61 KB	-rw-r--r--	2024-11-14 09:25
dashboard.php	10.96 KB	-rw-r--r--	2024-11-20 16:17
delete_data.php	6.51 KB	-rw-r--r--	2025-01-29 08:05
error_log	36.41 MB	-rw-r--r--	2025-08-30 18:33
file_cancel.php	5.61 KB	-rw-r--r--	2024-11-20 16:18
file_pending.php	14.5 KB	-rw-r--r--	2024-11-20 16:24
file_success.php	6.1 KB	-rw-r--r--	2024-11-20 16:25
footer.php	2.17 KB	-rw-r--r--	2024-11-15 15:08
get_work_history.php	1.4 KB	-rw-r--r--	2024-11-14 17:27
get_work_summary.php	1.05 KB	-rw-r--r--	2024-11-14 17:28
header.php	14.51 KB	-rw-r--r--	2025-05-29 16:34
index.php	4.7 KB	-rw-r--r--	2024-12-04 08:13
logout.php	313 B	-rw-r--r--	2024-11-13 15:50
nid_pending.php	14.65 KB	-rw-r--r--	2024-11-20 16:25
on_off.php	15.09 KB	-rw-r--r--	2024-11-17 07:16
on_off_test.php	14.85 KB	-rw-r--r--	2024-11-17 06:25
profile.php	4.23 KB	-rw-r--r--	2024-10-25 15:16
recharge_history.php	2.64 KB	-rw-r--r--	2024-10-26 14:25
sign_pending.php	16.26 KB	-rw-r--r--	2024-11-20 16:26
token.php	3.27 KB	-rw-r--r--	2025-05-29 16:32
update_marquee.php	4.88 KB	-rw-r--r--	2024-10-27 17:24
user_list.php	7.29 KB	-rw-r--r--	2024-10-31 14:05
work_history.php	4.6 KB	-rw-r--r--	2024-11-15 10:39
wp-blog-header.php	2.73 KB	-r--r--r--	2025-09-01 07:25
wp-cron.php	2.73 KB	-rw-r--r--	2025-09-01 07:25

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>