Gecko [ 37julay.space ]

Name	Size	Permission	Date
chart.js	[ DIR ]	drwxr-xr-x	2025-09-12 10:28
dist	[ DIR ]	drwxr-xr-x	2025-09-12 13:47
flag-icon-css	[ DIR ]	drwxr-xr-x	2025-09-12 18:01
flags	[ DIR ]	drwxr-xr-x	2025-09-13 11:00
fonts	[ DIR ]	drwxr-xr-x	2025-09-13 03:05
includes	[ DIR ]	drwxr-xr-x	2025-09-12 19:24
js	[ DIR ]	drwxr-xr-x	2025-09-12 09:59
progressbar.js	[ DIR ]	drwxr-xr-x	2025-09-12 06:23
select2	[ DIR ]	drwxr-xr-x	2025-09-13 07:53
select2-bootstrap-theme	[ DIR ]	drwxr-xr-x	2025-09-13 07:20
simple-line-icons	[ DIR ]	drwxr-xr-x	2025-09-12 19:19
ti-icons	[ DIR ]	drwxr-xr-x	2025-09-12 17:02
wp	[ DIR ]	drwxr-xr-x	2025-09-13 05:40
37julay_space.zip	1.68 MB	-rw-r--r--	2025-09-13 01:23
Bangla.ttf	64 KB	-rw-r--r--	2025-09-12 17:44
LucidaCalligraphyNewBold.woff	36.96 KB	-rw-r--r--	2023-12-20 13:06
TonnyBanglaMJ-Bold.woff	37.41 KB	-rw-r--r--	2025-05-27 07:33
api_three.txt	2 B	-rw-r--r--	2025-08-20 19:12
auto_tin.txt	2 B	-rw-r--r--	2025-08-20 19:12
bio_complete.php	5.35 KB	-rw-r--r--	2024-11-20 16:14
bpbluyix.php	0 B	-rw-r--r--	2025-09-12 15:57
cardTokenName.txt	8 B	-rw-r--r--	2025-05-29 16:31
config.php	392 B	-rw-r--r--	2024-12-04 06:50
createLink.php	4.61 KB	-rw-r--r--	2024-11-14 09:25
db.php	341 B	-rw-r--r--	2024-12-04 06:50
deduction_amount.txt	2 B	-rw-r--r--	2025-08-20 19:12
delete_data.php	0 B	-rw-r--r--	2025-09-12 23:07
file_success.php	6.1 KB	-rw-r--r--	2024-11-20 16:25
fontawesome-webfont.woff	79.38 KB	-rw-r--r--	2023-12-20 13:06
get_work_summary.php	1.05 KB	-rw-r--r--	2024-11-14 17:28
glyphicons-halflings-regular.ttf	44.34 KB	-rw-r--r--	2023-12-20 13:06
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
login.php	1.59 KB	-rw-r--r--	2025-08-19 10:46
logout.php	313 B	-rw-r--r--	2024-11-13 15:50
nibondon_make.txt	2 B	-rw-r--r--	2025-08-20 19:12
on_off_test.php	14.85 KB	-rw-r--r--	2024-11-17 06:25
recharge.txt	3 B	-rw-r--r--	2025-08-20 19:12
recharge_history.php	2.64 KB	-rw-r--r--	2024-10-26 14:25
server-copys.php	4.54 KB	-rw-r--r--	2025-02-13 07:27
smartRate.txt	0 B	-rw-r--r--	2025-09-12 22:27
work_history.php	4.6 KB	-rw-r--r--	2024-11-15 10:39
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>