?HAMA

Edit File Size: 4.54 KB

//home/nshryvcy/blissfulnepal.com/wp-content/plugins/newsletter/users/statistics-time.php

Text Base64

<?php
global $wpdb;

defined('ABSPATH') || exit;
?>

<?php
        $dt = new DateTime();
        $dt->setTime(12, 0, 0)->setDate((int) date('Y'), (int) date('m'), 1);
        $i = new DateInterval('P1M');
        $months = [];
        for ($x = 1; $x <= 24; $x++) {
            $months[] = $dt->format('Y-m');
            $dt->sub($i);
        }
        $months = array_reverse($months);
        $list = $wpdb->get_results("select  concat(year(created), '-', date_format(created, '%m')) as d, count(*) as c from " . NEWSLETTER_USERS_TABLE . " where status='C' group by concat(year(created), '-', date_format(created, '%m')) order by d desc limit 24", OBJECT_K);

$dataMonths = [];
        foreach ($months as $month) {
            $dataMonths[] = isset($list[$month]) ? $list[$month]->c : 0;
        }
        ?>

<?php /*
        <table class="widefat">
            <thead>
                <tr>
                    <th><?php _e('Year and month', 'newsletter') ?></th>
                    <th><?php _e('Total', 'newsletter') ?></th>
                </tr>
            </thead>
            <?php foreach ($months as $month) { ?>
                <tr>
                    <td><?php echo $month; ?></td>
                    <td><?php echo isset($list[$month]) ? $list[$month]->c : 0; ?></td>
                </tr>
            <?php } ?>
        </table>
        */?>
    </div>

<?php
        $dt = new DateTime();
        $dt->setTime(12, 0, 0);
        $i = new DateInterval('P1D');
        $days = [];
        for ($x = 1; $x <= 90; $x++) {
            $days[] = $dt->format('Y-m-d');
            $dt->sub($i);
        }
        $days = array_reverse($days);

$list = $wpdb->get_results("select date(created) as d, count(*) as c from " . NEWSLETTER_USERS_TABLE . " where status='C' group by date(created) order by d desc limit 90", OBJECT_K);

$dataDays = [];
        foreach ($days as $day) {
            $dataDays[] = isset($list[$day]) ? $list[$day]->c : 0;
        }
        ?>
        <?php /*
        <table class="widefat">
            <thead>
                <tr>
                    <th><?php _e('Date', 'newsletter') ?></th>
                    <th><?php _e('Total', 'newsletter') ?></th>
                </tr>
            </thead>
            <?php for ($i = 0; $i < count($days); $i++) { ?>
                <tr>
                    <td><?php echo $days[$i]; ?></td>
                    <td><?php echo $dataDays[$i] ?></td>
                </tr>
            <?php } ?>
        </table>
*/?>
    </div>

</div>

const dataMonths = {
        labels: <?php echo wp_json_encode($months) ?>,
        datasets: [{
                label: 'By month',
                borderColor: '#3498DB',
                borderWidth: 1,
                data: <?php echo wp_json_encode($dataMonths) ?>,
            }]
    };

jQuery(function () {
        const myChart = new Chart(
                document.getElementById('tnp-users-chart-days'),
                {
                    type: 'line',
                    data: dataDays,
                   options: {
                       maintainAspectRatio: false,
                        scales: {
                            yAxes: [{
                                    ticks: {
                                        beginAtZero: true
                                    }
                                }]
                        }
                    }
                }
        );
        const myChartMonths = new Chart(
                document.getElementById('tnp-users-chart-months'),
                {
                    type: 'line',
                    data: dataMonths,
                    options: {
                        maintainAspectRatio: false,
                        scales: {
                            yAxes: [{
                                    ticks: {
                                        beginAtZero: true
                                    }
                                }]
                        }
                    }
                }
        );
    });
</script>

Exit & Reset Text mode: syntax highlighting auto-detects file type.

Name	Size	Perms	Modified	Actions
css DIR	-	drwxr-xr-x	2026-06-03 14:57:28	Edit Download recursive recursive
autoresponders.php	1.21 KB	lrw-r--r--	2026-06-03 14:57:28	Edit Download recursive recursive
edit-nav.php	1019 B	lrw-r--r--	2026-06-03 14:57:28	Edit Download recursive recursive
edit.php	14.96 KB	lrw-r--r--	2026-06-03 14:57:28	Edit Download recursive recursive
export.php	36 B	lrw-r--r--	2026-06-03 14:57:28	Edit Download recursive recursive
import.php	1.39 KB	lrw-r--r--	2026-06-03 14:57:28	Edit Download recursive recursive
index.php	10.28 KB	lrw-r--r--	2026-06-03 14:57:28	Edit Download recursive recursive
logs.php	3.49 KB	lrw-r--r--	2026-06-03 14:57:28	Edit Download recursive recursive
massive.php	15.18 KB	lrw-r--r--	2026-06-03 14:57:28	Edit Download recursive recursive
nav.php	1.51 KB	lrw-r--r--	2026-06-03 14:57:28	Edit Download recursive recursive
new.php	1.56 KB	lrw-r--r--	2026-06-03 14:57:28	Edit Download recursive recursive
newsletters.php	1.66 KB	lrw-r--r--	2026-06-03 14:57:28	Edit Download recursive recursive
statistics-countries.php	79 B	lrw-r--r--	2026-06-03 14:57:28	Edit Download recursive recursive
statistics-time.php	4.54 KB	lrw-r--r--	2026-06-03 14:57:28	Edit Download recursive recursive
statistics.php	21.36 KB	lrw-r--r--	2026-06-03 14:57:28	Edit Download recursive recursive
users-admin.php	1.31 KB	lrw-r--r--	2026-06-03 14:57:28	Edit Download recursive recursive
users.php	519 B	lrw-r--r--	2026-06-03 14:57:28	Edit Download recursive recursive

Directory Contents