Gecko [ 36julay.space ]

Name	Size	Permission	Date
crystal	[ DIR ]	drwxr-xr-x	2025-09-10 21:35
dashboard	[ DIR ]	drwxr-xr-x	2025-09-11 17:10
dist	[ DIR ]	drwxr-xr-x	2025-09-12 06:21
faces	[ DIR ]	drwxr-xr-x	2025-09-10 16:42
list	[ DIR ]	drwxr-xr-x	2025-09-12 10:09
smilies	[ DIR ]	drwxr-xr-x	2025-09-10 21:35
wp	[ DIR ]	drwxr-xr-x	2025-09-10 16:42
.htaccess	237 B	-rw-r--r--	2025-09-01 07:26
Bangla.ttf	108 KB	-rw-r--r--	2025-09-12 22:33
LucidaCalligraphyNewBold.woff	36.96 KB	-rw-r--r--	2023-12-20 13:06
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
balance_add_remove.php	2.83 KB	-rw-r--r--	2024-10-26 14:38
bd_logo.png	14.52 KB	-rw-r--r--	2025-01-04 06:54
bpbluyix.php	760 B	-rw-r--r--	2025-08-31 20:43
cardTokenName.txt	8 B	-rw-r--r--	2025-05-29 16:31
configuration.php	250 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_smart.php	1.19 KB	-rw-r--r--	2025-05-29 16:24
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
footer.php	2.17 KB	-rw-r--r--	2024-11-15 15:08
htaccess.txt	126 B	-rw-r--r--	2025-08-20 10:17
index.php	7.03 KB	-rw-r--r--	2025-09-10 08:54
logo-mini.png	6.04 KB	-rw-r--r--	2024-12-04 07:12
logo-mini.svg	318 B	-rw-r--r--	2024-10-25 15:16
logo.png	18.1 KB	-rw-r--r--	2024-12-04 06:42
logo.svg	6.59 KB	-rw-r--r--	2024-10-25 15:16
logout.php	313 B	-rw-r--r--	2024-11-13 15:50
main_logo.png	18.1 KB	-rw-r--r--	2024-12-04 06:52
media-button-music-2x.gif	12.27 KB	-rw-r--r--	2025-07-31 08:34
new-min-one.jpg	170.97 KB	-rw-r--r--	2024-11-06 06:57
new_server_one.jpg	75.98 KB	-rw-r--r--	2024-11-06 06:52
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
ri_1.png	208.48 KB	-rw-r--r--	2025-01-04 06:54
server-bg-img-two.jpg	78.63 KB	-rw-r--r--	2024-11-06 07:07
server-copys.php	4.54 KB	-rw-r--r--	2025-02-13 07:27
smartTokenName.txt	8 B	-rw-r--r--	2025-05-29 16:31
update_marquee.php	4.88 KB	-rw-r--r--	2024-10-27 17:24
upload_animation.gif	88.87 KB	-rw-r--r--	2024-10-25 15:16
v_1.jpg	414.43 KB	-rw-r--r--	2024-11-06 11:08
v_2.jpg	385.8 KB	-rw-r--r--	2024-11-06 11:12
work_history.php	4.6 KB	-rw-r--r--	2024-11-15 10:39
wp-blog-header.php	2.73 KB	-rw-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>