관리-도구

편집 파일: dashboard.php

<?php
$mysqli = $info['mysqli'];
$dbpref = $info['dbpref'];
$load = $data_arr['load'];
$funnel_ob = $load->loadFunnel();
$funnels_data = $funnel_ob->getAllFunnelForView(0, "", 5);
$sales_ob = $load->loadSell();
$sales_data = $sales_ob->visualOptisForSales('all', 0, "", 5);
if (isset($_POST['saveSelectedDays'])) {
    if (isset($_POST['no_of_days']) && $_POST['no_of_days'] != -1) {
        $no_of_days = $_POST['no_of_days'];
    } else if (isset($_POST['cust_def_days'])) {
        $no_of_days = $_POST['cust_def_days'];
    } else {
        $no_of_days = 30;
    }
    update_option("no_of_days", $no_of_days);
?>
    <script>
        $(function() {
            $("#cf-dashboard-index").focus();
        })
    </script>
<?php
} elseif (get_option("no_of_days") === false) {
    $no_of_days = 30;
} else {
    $no_of_days = get_option("no_of_days");
}
$members_ob = $load->loadMember();
$members_data =

//total visitor
    $viewquery = $mysqli->query("select sum(viewcount) as `sumvisits` from `" . $dbpref . "quick_pagefunnel`");

if ($no_of_days == "t") {
    $cfcourse_twentynine_minus = strtotime(date('d-M-Y') . "today");

$cfcourse_thirty = "Today";
    $cfcourse_twentynine = 0;
    $cfcourse_twentynine_minu = $cfcourse_twentynine * (-1);
} else if ($no_of_days == "y") {
    $cfcourse_twentynine_minus = strtotime("yesterday");
    $cfcourse_thirty = "Yesterday";
    $cfcourse_twentynine = 1;
    $cfcourse_twentynine_minu = $cfcourse_twentynine * (-1);
} else {
    $cfcourse_thirty = $no_of_days;
    $cfcourse_twentynine = $cfcourse_thirty - 1;
    $cfcourse_twentynine_minu = $cfcourse_twentynine * (-1);
    $cfcourse_twentynine_minus = strtotime(date('d-M-Y') . $cfcourse_twentynine_minu . "days");
}

$totalviews = 0;
if ($viewquery) {
    $r = $viewquery->fetch_object();
    if ($r->sumvisits > 0) {
        $totalviews = $r->sumvisits;
    }
}
$all_courses = "select count(`id`) as `countid` from `" . $dbpref . "all_products`";
$query_all_courses = $mysqli->query($all_courses);
$course_count = 0;
if ($query_all_courses) {
    $r = $query_all_courses->fetch_object();
    $course_count = $r->countid;
}

$all_funnels = "select count(`id`) as `countid` from `" . $dbpref . "quick_funnels`";
$query_all_funnels = $mysqli->query($all_funnels);
$funnel_count = 0;
if ($query_all_funnels) {
    $r = $query_all_funnels->fetch_object();
    $funnel_count = $r->countid;
}
$viewquery = $mysqli->query("select sum(viewcount) as `sumvisits` from `" . $dbpref . "quick_pagefunnel`");

$totalviews = 0;
if ($viewquery) {
    $r = $viewquery->fetch_object();
    if ($r->sumvisits > 0) {
        $totalviews = $r->sumvisits;
    }
}

$member = "select count(`id`) as `countid` from `" . $dbpref . "quick_member`";
$query = $mysqli->query($member);
$membercount = 0;
if ($query) {
    $r = $query->fetch_object();
    $membercount = $r->countid;
}
$sentmails = "select * from `" . $dbpref . "quick_subscription_mail_schedule` where status=0 or status=1 or status=2";
$query = $mysqli->query($sentmails);
$sentmailscount = $query->num_rows;
$sent = "select count(`id`) as `countid` from `" . $dbpref . "quick_subscription_mail_schedule` where status in ('1','2','3')";
$query = $mysqli->query($sent);
$sentcount = 0;
if ($query) {
    $r = $query->fetch_object();
    $sentcount = $r->countid;
}

$seen = "select count(`id`) as `countid` from `" . $dbpref . "quick_subscription_mail_schedule` where status in ('2','3')";
$query = $mysqli->query($seen);
$seencount = 0;
if ($query) {
    $r = $query->fetch_object();
    $seencount = $r->countid;
}
$comments = "SELECT COUNT(`id`) as `countid` from `" . $dbpref . "option_comment`";
$query1 = $mysqli->query($comments);
$commentscount = 0;
if ($query1) {
    $r = $query1->fetch_object();
    $commentscount = $r->countid;
}
$reviews = "SELECT COUNT(`id`) as `countid` from `" . $dbpref . "course_review`";
$query2 = $mysqli->query($reviews);
$reviewsscount = 0;
if ($query2) {
    $r = $query2->fetch_object();
    $reviewsscount = $r->countid;
}

$query5 = $mysqli->query("SELECT SUM(`total_watched`) AS 'total_watched' FROM `" . $dbpref . "all_products`");
$total_hours = 0;
if ($query5) {
    $r = $query5->fetch_object();
    $seconds = $r->total_watched;
    $hour = floor($seconds / 3600);
    $minutes =  floor(intval(($seconds / 60)) % 60);;
    $seconds = $seconds % 60;
    if ($hour > 0) {
        if ($total_hours == 1) {
            $total_hours = $hour . t(" Hour");
        } else {
            $total_hours = $hour . t(" Hours");
        }
    } else if ($minutes > 0) {
        if ($minutes == 1) {
            $total_hours = $minutes . t(" Minute");
        } else {
            $total_hours = $minutes . t(" Minutes");
        }
    } else if ($seconds > 0) {
        if ($seconds == 1) {
            $total_hours = $seconds . t(" Second");
        } else {
            $total_hours = $seconds . t(" Seconds");
        }
    }
}

$totalmembers_qry = $mysqli->query("select count(distinct(concat(`email`,`funnelid`,`pageid`))) as `countid` from `" . $dbpref . "quick_member` where `email` not in ('', ' ')");
$totalmembers = 0;
if ($totalmembers_qry) {
    $tatalmemberob = $totalmembers_qry->fetch_object();
    $totalmembers = $tatalmemberob->countid;
}
?>
<style>
    html,
    body,
    #qfnlsaleschart #qfnlmembershipchart {
        width: 100%;
        height: 100%;
        margin: 0;
        padding: 0;
    }

.anychart-credits {
        display: none;
    }

.letestsales_table {
        max-width: 300px;
    }
</style>
<div class="container-fluid  no-padding">
    <?php if ($funnels_data['total_rows'] > 0) { ?>
        <div class="row">
            <div class="col-sm-12" id="crdcontainer">
                <div class="col-md-12 nopadding ">
                    <div class="row">
                        <div class="col-md-12 dashboard-nav d-flex">
                            <ul class="dashboard-topnav">
                                <a href="index.php?page=create_funnel">
                                    <li><i class="fas fa-funnel-dollar"></i>&nbsp;<?php w('Create&nbsp;Funnel'); ?></li>
                                </a>
                                <a href="index.php?page=cfcourse_all_course">
                                    <li><i class="fas fa-book"></i>&nbsp;<?php w('Create Course'); ?></li>
                                </a>
                                <a href="index.php?page=createlist">
                                    <li><i class="fas fa-clipboard-list"></i>&nbsp;<?php w('Create&nbsp;List'); ?></li>
                                </a>
                                <a href="index.php?page=compose_mail">
                                    <li><i class="fas fa-paper-plane"></i>&nbsp;<?php w('Send&nbsp;A&nbsp;Mailer'); ?></li>
                                </a>
                                <a href="index.php?page=sales">
                                    <li><i class="fas fa-hand-holding-usd"></i>&nbsp;<?php w('See&nbsp;Sales'); ?></li>
                                </a>
                                <a href="index.php?page=multiuser_table">
                                    <li><i class="fas fa-users-cog"></i>&nbsp;<?php w('See&nbsp;Users'); ?></li>
                                </a>
                            </ul>
                        </div>
                    </div>
                    <div class="row">
                        <div class="col-md-12">
                            <div class="row">
                                <div class="col-md-6 position-relative col-xl-3">
                                    <div class="card wqmlrdashboard">
                                        <div class="card-body">
                                            <div class="row">
                                                <div class="col-md-4">
                                                    <div class="card-body-inner">
                                                        <span class="text-primary"><i class="fas fa-book"></i></span>
                                                    </div>
                                                </div>
                                                <div class="col-md-8">
                                                    <h3 class="blocknumber"><?php w(number_format($course_count)); ?></h3>
                                                    <h6 class="subtitle"><?php w('Total Courses'); ?></h6>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-md-6 position-relative col-xl-3">
                                    <div class="card wqmlrdashboard">
                                        <div class="card-body">
                                            <div class="row">
                                                <div class="col-md-4">
                                                    <div class="card-body-inner">
                                                        <span class="text-primary"><i class="fas fa-hand-holding-usd"></i></span>
                                                    </div>
                                                </div>
                                                <div class="col-md-8">
                                                    <h3 class="blocknumber"><?php w(number_format($sales_data['total'])); ?></h3>
                                                    <h6 class="subtitle"><?php w('Total Sales'); ?></h6>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-md-6 position-relative col-xl-3">
                                    <div class="card wqmlrdashboard">
                                        <div class="card-body">
                                            <div class="row">
                                                <div class="col-md-4">
                                                    <div class="card-body-inner">
                                                        <span class="text-primary "><i class="fas fa-users"></i></span>
                                                    </div>
                                                </div>
                                                <div class="col-md-8">
                                                    <h3 class="blocknumber"><?php w(number_format($totalmembers)); ?></h3>
                                                    <h6 class="subtitle"><?php w('Students'); ?></h6>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-md-6 position-relative col-xl-3">
                                    <div class="card wqmlrdashboard">
                                        <div class="card-body">
                                            <div class="row">
                                                <div class="col-md-4">
                                                    <div class="card-body-inner">
                                                        <span class="text-primary"><i class="fas fa-comments"></i></span>
                                                    </div>
                                                </div>
                                                <div class="col-md-8">
                                                    <h3 class="blocknumber"><?php w(number_format($commentscount)); ?></h3>
                                                    <h6 class="subtitle"><?php w('Total Comments'); ?></h6>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-md-6 position-relative col-xl-3">
                                    <div class="card wqmlrdashboard">
                                        <div class="card-body">
                                            <div class="row">
                                                <div class="col-md-4">
                                                    <div class="card-body-inner">
                                                        <span class="text-primary"><i class="fas fa-star"></i></span>
                                                    </div>
                                                </div>
                                                <div class="col-md-8">
                                                    <h3 class="blocknumber"><?php w(number_format($reviewsscount)); ?></h3>
                                                    <h6 class="subtitle"><?php w('Total Reviews'); ?></h6>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-md-6 position-relative col-xl-3">
                                    <div class="card wqmlrdashboard">
                                        <div class="card-body">
                                            <div class="row">
                                                <div class="col-md-4">
                                                    <div class="card-body-inner">
                                                        <span class="text-primary"><i class="fas fa-funnel-dollar"></i></span>
                                                    </div>
                                                </div>
                                                <div class="col-md-8">
                                                    <h3 class="blocknumber"><?php w(number_format($funnel_count)); ?></h3>
                                                    <h6 class="subtitle"><?php w('Total Funnels'); ?></h6>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-md-6 position-relative col-xl-3">
                                    <div class="card wqmlrdashboard">
                                        <div class="card-body">
                                            <div class="row">
                                                <div class="col-md-4">
                                                    <div class="card-body-inner">
                                                        <span class="text-primary"><i class="fas fa-eye"></i></span>
                                                    </div>
                                                </div>
                                                <div class="col-md-8">
                                                    <h3 class="blocknumber"><?php w(number_format($totalviews)); ?></h3>
                                                    <h6 class="subtitle"><?php w('Total Visits'); ?></h6>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-md-6 position-relative col-xl-3">
                                    <div class="card wqmlrdashboard">
                                        <div class="card-body">
                                            <div class="row">
                                                <div class="col-md-4">
                                                    <div class="card-body-inner">
                                                        <span class="text-primary"><i class="fas fa-eye"></i></span>
                                                    </div>
                                                </div>
                                                <div class="col-md-8">
                                                    <h3 class="blocknumber"><?= $total_hours ?></h3>
                                                    <h6 class="subtitle"><?php w('Total Watch Time'); ?></h6>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <br>

<?php
                        $lastthirtydays = array();
                        $lastthirtydayviews = array();
                        $lastthirtdayconverts = array();
                        $lastthirtydaysmembers = array();
                        $lastthirtdaymails = array();
                        $lastthirtdayopens = array();
                        $lastthirtdayunsubs = array();
                        $lastthirtydaylinksvisits = array();

for ($i = 0; $i <= $cfcourse_twentynine; $i++) {
                            $temponeofthirtydays = date('d-M-Y', strtotime(date('d-M-Y') . "-" . $i . "days"));
                            $lastthirtydays[$temponeofthirtydays] = 0;
                            $lastthirtydayviews[$temponeofthirtydays] = 0;
                            $lastthirtdayconverts[$temponeofthirtydays] = 0;
                            $lastthirtydaysmembers[$temponeofthirtydays] = 0;
                            $lastthirtdaymails[$temponeofthirtydays] = 0;
                            $lastthirtdayopens[$temponeofthirtydays] = 0;
                            $lastthirtdayunsubs[$temponeofthirtydays] = 0;
                            $lastthirtydaylinksvisits[$temponeofthirtydays] = 0;
                        }
                        //members
                        $hold_mdates = array();
                        $lastthirtymembershipquery = $mysqli->query("select `date_created`, `email`, `funnelid` from `" . $dbpref . "quick_member` where `date_created`>='" . $cfcourse_twentynine_minus . "' and email not in('',' ')");

if ($lastthirtymembershipquery->num_rows) {
                            while ($r = $lastthirtymembershipquery->fetch_object()) {
                                if (array_search($r->email . '-' . $r->funnelid, $hold_mdates) !== false) {
                                    continue;
                                }

++$lastthirtydaysmembers[date('d-M-Y', $r->date_created)];

array_push($hold_mdates, $r->email . '-' . $r->funnelid);
                            }
                        }

//visits
                        $visitsviewlastthirtyquery = $mysqli->query("select `visitedon` from `" . $dbpref . "site_visit_record` where `visitedon`>='" . $cfcourse_twentynine_minus . "' ");
                        if ($visitsviewlastthirtyquery->num_rows) {
                            while ($r = $visitsviewlastthirtyquery->fetch_object()) {
                                ++$lastthirtydayviews[date('d-M-Y', $r->visitedon)];
                            }
                        }
                        //convertedon
                        $convertlastthirtyquery = $mysqli->query("select `convertedon` from `" . $dbpref . "site_visit_record` where `convertedon`>='" . $cfcourse_twentynine_minus . "' and `convert_optinid` not in('0')");
                        if ($convertlastthirtyquery->num_rows) {
                            while ($r = $convertlastthirtyquery->fetch_object()) {
                                ++$lastthirtdayconverts[date('d-M-Y', $r->convertedon)];
                            }
                        }
                        //sales
                        $saleslastthirtyquery = $mysqli->query("select `addedon` from `" . $dbpref . "all_sales` where `addedon`>='" . $cfcourse_twentynine_minus . "' ");

if ($saleslastthirtyquery->num_rows) {
                            while ($r = $saleslastthirtyquery->fetch_object()) {
                                ++$lastthirtydays[date('d-M-Y', $r->addedon)];
                            }
                        }
                        //sent mails
                        $totalsentlastthirtyquery = $mysqli->query("select `time` from `" . $dbpref . "quick_subscription_mail_schedule` where `time`>='" . $cfcourse_twentynine_minus . "' and `status` in ('1','2','3')");
                        if ($totalsentlastthirtyquery->num_rows) {
                            while ($r = $totalsentlastthirtyquery->fetch_object()) {
                                ++$lastthirtdaymails[date('d-M-Y', $r->time)];
                            }
                        }
                        //opened
                        $openedlastthirtyquery = $mysqli->query("select `time` from `" . $dbpref . "quick_subscription_mail_schedule` where `time`>='" . $cfcourse_twentynine_minus . "' and `status` in ('2','3')");

if ($openedlastthirtyquery->num_rows) {
                            while ($r = $openedlastthirtyquery->fetch_object()) {
                                ++$lastthirtdayopens[date('d-M-Y', $r->time)];
                            }
                        }

//unsubs
                        $unsubslastthirtyquery = $mysqli->query("select `time` from `" . $dbpref . "quick_subscription_mail_schedule` where `time`>='" . $cfcourse_twentynine_minus . "' and `status` in ('3')");
                        if ($unsubslastthirtyquery->num_rows) {
                            while ($r = $unsubslastthirtyquery->fetch_object()) {
                                ++$lastthirtdayunsubs[date('d-M-Y', $r->time)];
                            }
                        }
                        //links visits
                        $linksvisitsthirtyquery = $mysqli->query("select `createdon` from `" . $dbpref . "email_links_visits` where `visited`='1' and `createdon`>='" . $cfcourse_twentynine_minus . "' ");
                        if ($linksvisitsthirtyquery->num_rows) {
                            while ($r = $linksvisitsthirtyquery->fetch_object()) {
                                ++$lastthirtydaylinksvisits[date('d-M-Y', $r->createdon)];
                            }
                        }

$saleslastthirtydatearr = array();
                        $saleslastthirtysalesarr = array();
                        $lastthirtydays = array_reverse($lastthirtydays);
                        foreach ($lastthirtydays as $lastthirtydaysindex => $lastthirtydaysdata) {
                            array_push($saleslastthirtydatearr, "'" . date('d-M', strtotime($lastthirtydaysindex)) . "'");
                            array_push($saleslastthirtysalesarr, $lastthirtydaysdata);
                        }

$lastthirtydayviews = array_reverse($lastthirtydayviews);
                        $viewslastthirtydatearr = array();
                        $viewslastthirtyviewsarr = array();
                        foreach ($lastthirtydayviews as $lastthirtydayviewsindex => $lastthirtydayviewsdata) {
                            array_push($viewslastthirtydatearr, "'" . date('d-M', strtotime($lastthirtydayviewsindex)) . "'");
                            array_push($viewslastthirtyviewsarr, $lastthirtydayviewsdata);
                        }
                        $lastthirtdayconverts = array_reverse($lastthirtdayconverts);
                        $convertslastthirtydatearr = array();
                        $convertslastthirtyconvertsarr = array();
                        foreach ($lastthirtdayconverts as $lastthirtydayconvertsindex => $lastthirtydayconvertsdata) {
                            array_push($convertslastthirtydatearr, "'" . date('d-M', strtotime($lastthirtydayconvertsindex)) . "'");
                            array_push($convertslastthirtyconvertsarr, $lastthirtydayconvertsdata);
                        }

$lastthirtydaysmembers = array_reverse($lastthirtydaysmembers);
                        $lastthirtydaysmembersdatearr = array();
                        $lastthirtydaysmemberscountarr = array();

foreach ($lastthirtydaysmembers as $lastthirtydaysmembersindex => $lastthirtydaysmembersvalue) {
                            array_push($lastthirtydaysmembersdatearr, "'" . date('d-M', strtotime($lastthirtydaysmembersindex)) . "'");
                            array_push($lastthirtydaysmemberscountarr, $lastthirtydaysmembersvalue);
                        }

$lastthirtdaymails = array_reverse($lastthirtdaymails);
                        $sentmailslastthirtydatearr = array();
                        $totalmailslastthirtytotalarr = array();
                        foreach ($lastthirtdaymails as $lastthirtydaytotalindex => $lastthirtydaytotalsentdata) {
                            array_push($sentmailslastthirtydatearr, "'" . date('d-M', strtotime($lastthirtydaytotalindex)) . "'");
                            array_push($totalmailslastthirtytotalarr, $lastthirtydaytotalsentdata);
                        }
                        $lastthirtdayopens = array_reverse($lastthirtdayopens);
                        $openslastthirtydatearr = array();
                        $opensmailslastthirtyopensarr = array();
                        foreach ($lastthirtdayopens as $lastthirtydayopensindex => $lastthirtydayopensdata) {
                            array_push($openslastthirtydatearr, "'" . date('d-M', strtotime($lastthirtydayopensindex)) . "'");
                            array_push($opensmailslastthirtyopensarr, $lastthirtydayopensdata);
                        }

$lastthirtdayunsubs = array_reverse($lastthirtdayunsubs);
                        $unsubslastthirtydatearr = array();
                        $unsubsmailslastthirtyunsubsarr = array();
                        foreach ($lastthirtdayunsubs as $lastthirtydayunsubsindex => $lastthirtydayunsubsdata) {
                            array_push($unsubslastthirtydatearr, "'" . date('d-M', strtotime($lastthirtydayunsubsindex)) . "'");
                            array_push($unsubsmailslastthirtyunsubsarr, $lastthirtydayunsubsdata);
                        }

$lastthirtydaylinksvisits = array_reverse($lastthirtydaylinksvisits);
                        $linksvisirsdatesarr = array();
                        $linksvisitsthirdaysarr = array();
                        foreach ($lastthirtydaylinksvisits as $lastthirtydaylinksvisitsindex => $lastthirtydaylinksvisitsval) {
                            array_push($linksvisirsdatesarr, date('d-M', strtotime($lastthirtydaylinksvisitsindex)));
                            array_push($linksvisitsthirdaysarr, $lastthirtydaylinksvisitsval);
                        }
                        ?>

<div class="col-md-12 my-5">
                            <div class="row pb-3">
                                <div class="col-sm-9">
                                    <h3 class="text-black op-6"><?= t("Showing record for last \${1} day(s)", array($cfcourse_thirty)); ?></h3>
                                </div>
                                <div class="col-sm-3">
                                    <div class="dropdown">
                                        <button class="btn btn-warning setup-button dropdown-toggle btn-block" type="button" id="dropdownMenuButton" data-bs-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
                                            <i class="fas fa-calendar-alt"></i>&nbsp;<?= t('Select Days'); ?>
                                        </button>
                                        <div class="dropdown-menu w-100" aria-labelledby="dropdownMenuButton">
                                            <div class="container">
                                                <div class="row">
                                                    <div class="col-sm-12">
                                                        <form class="daysSelection" action="" method="POST">
                                                            <label class="form-control"><input type="radio" name="no_of_days" value="t">&nbsp;<?= t('Today'); ?></label>
                                                            <label class="form-control"><input type="radio" name="no_of_days" value="y">&nbsp;<?= t('Yesterday'); ?></label>
                                                            <label class="form-control"><input type="radio" name="no_of_days" value="7">&nbsp;<?= t('Last 7 days'); ?></label>
                                                            <label class="form-control"><input type="radio" name="no_of_days" value="15">&nbsp;<?= t('Last 15 days'); ?></label>
                                                            <label class="form-control"><input type="radio" name="no_of_days" value="30">&nbsp;<?= t('Last 30 days'); ?></label>
                                                            <label class="form-control">
                                                                <input type="radio" name="no_of_days" id="custom-days" value="-1">&nbsp; <?= t('Enter custom days'); ?>
                                                            </label>
                                                            <input class="form-control cust-no_of_days" id="cf-custom-days" type="number" placeholder="<?= t('Enter days'); ?>" min="0" value="0" name="cust_def_days" style="display: none;">
                                                            <button name="saveSelectedDays" class="btn btn-warning btn-block mt-2 theme-button"><i class="fas fa-check"></i>&nbsp;<?= t('Save'); ?></button>
                                                        </form>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="graph-class  justify-content-center" id="cf-dashboard-index" tabindex="-1">
                                <div class="row justify-content-center">
                                    <div class="col-md-6">
                                        <div class="card pnl">
                                            <div class="card-header"><?= $cfcourse_thirty . " "; ?><?= w("Day's Sales"); ?>
                                            </div>
                                            <div class="card-body qfnldashboardgraph" id="qfnlsaleschart" style="height: 350px;"></div>
                                        </div>
                                    </div>
                                    <div class="col-md-6">
                                        <div class="card pnl">
                                            <div class="card-header"><?= $cfcourse_thirty . " "; ?><?= w("Day's Students Report"); ?></div>
                                            <div class="card-body qfnldashboardgraph" id="qfnlmembershipchart" style="height: 350px;"></div>

</div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

var lastthirtydaysmembersdatearr = "<?php echo implode(',', $lastthirtydaysmembersdatearr); ?>";
                    var lastthirtydaysmemberscountarr = "<?php echo implode(',', $lastthirtydaysmemberscountarr); ?>";

create_new_membership(lastthirtydaysmembersdatearr, lastthirtydaysmemberscountarr, 'qfnlmembershipchart');
                </script>
                
                <div class="row justify-content-center">
                    <div class="col-md-12 col-sm-11">
                        <div class="card pnl">
                            <div class="card-header"><?php w('Latest Courses'); ?></div>
                            <div class="card-body">
                                <div class="table-responsive">
                                    <table class="table table-striped text-start">
                                        <thead>
                                            <th>#</th>
                                            <th><?php w('Course'); ?></th>
                                            <th><?php w('Shortcode'); ?></th>
                                            <th><?php w('Time Watched'); ?></th>
                                            <th><?php w('Course Settings'); ?></th>
                                            <th><?php w('Created&nbsp;On') ?></th>
                                        </thead>
                                        <tbody>
                                            <?php
                                            function ConvertSectoDay($n)
                                            {
                                                $day = $n / (24 * 3600);

$n = $n % (24 * 3600);
                                                $hour = $n / 3600;

$n %= 3600;
                                                $minutes = $n / 60;

$n %= 60;
                                                $seconds = $n;

echo floor($day) . "d " . floor($hour) . "h " . floor($minutes) . "m " . $seconds . "s ";
                                            }
                                            $count = 1;
                                            $table = $dbpref . "all_products";
                                            $qry = $mysqli->query("select * from `" . $table . "` limit 5");

if ($qry->num_rows > 0) {
                                                while ($data = $qry->fetch_assoc()) {
                                            ?> <tr class="text-start cf-course-chbtn">
                                                        <td width="5%"><?php echo $count; ?></td>
                                                        <td width="20%"><?php echo $data['title']; ?></td>
                                                        <td width="20%"><strong class="text-info" onclick="copyText(`[cfcourse_shortcode id=<?= $data['id']; ?>]`)" data-bs-toggle="tooltip" title="Copy to clipboard" style="cursor:pointer;">[cfcourse_shortcode id=<?= $data['id']; ?>]</strong></td>
                                                        <td width="20%" class='text-end'><?php ConvertSectoDay($data['total_watched']); ?></td>
                                                        <td width="15%">
                                                            <a class="btn btn-primary" data-bs-toggle="tooltip" title="<?= t('Edit Course'); ?>" href="index.php?page=cfcourse_popup_course&cfcourse_id=<?= $data['id'] ?>">
                                                                <i class="fas fa-edit text-white"></i>

</a>&nbsp;
                                                            <a class="btn btn-success" data-bs-toggle="tooltip" title="<?= t('Edit Course Content'); ?>" href="index.php?page=cfcourse_manage_course&cfcourse_id=<?= $data['id'] ?>">
                                                                <i class="fas fa-tasks text-white"></i>
                                                            </a>
                                                        </td>
                                                        <td width="20%" class='text-end'>
                                                            <?php echo date('d-M-Y', $data['createdon']); ?>
                                                        </td>
                                                    </tr>
                                            <?php
                                                    $count++;
                                                }
                                            }
                                            ?>
                                        </tbody>
                                    </table>
                                </div>
                                <div class="text-end"><a href="index.php?page=cfcourse_all_course"><button class="btn theme-button mt-2"><?php w('All Courses') ?></button></a></div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row justify-content-center">
                    <div class="col-md-12 col-sm-11 sortable">
                        <div class="card pnl">
                            <div class="card-header"><?php w('Latest Sales'); ?></div>
                            <div class="card-body">
                                <div class="table-responsive">

<table class="table table-striped">
                                        <thead>
                                            <th>#</th>
                                            <th><?php w('Payment&nbsp;Id') ?></th>
                                            <th><?php w('Student&nbsp;Name'); ?></th>
                                            <th><?php w('Student&nbsp;Email') ?></th>
                                            <th><?php w('Date'); ?></th>
                                            <th><?php w('Action'); ?></th>
                                        </thead>
                                        <tbody id="srchmember">
                                            
                                            <?php
                                            $hashcount = 0;

while ($r = $sales_data['sales']->fetch_object()) {
                                                ++$hashcount;

$shippedclass = "btn-warning";
                                                if ($r->shipped == "1") {
                                                    $shippedclass = "btn-success";
                                                }
                                                $date = date('d-M-Y', $r->addedon);

$product = "";

$productdata = $sales_ob->getProduct($r->productid);

if ($productdata) {
                                                    $product = "(#" . $productdata->productid . ") " . $productdata->title . "";

$product = "<a href='index.php?page=products&product_id=" . $r->productid . "' target='_BLANK'>" . $product . "</a>";
                                                }

$parent_product = "N/A";
                                                $mysqli = $info['mysqli'];
                                                $dbpref = $info['dbpref'];
                                                $checkotherproducts_query = $mysqli->query("select `id`,`productid`,`title` from `" . $dbpref . "all_products` where id in(select `productid` from `" . $dbpref . "all_sales` where `parent` in('" . $r->productid . "') and `payment_id`='" . $r->payment_id . "')");

if ($checkotherproducts_query->num_rows > 0) {
                                                    $parent_product = "";
                                                    while ($tempr = $checkotherproducts_query->fetch_object()) {
                                                        $parent_product .= "<a href='index.php?page=products&product_id=" . $tempr->id . "'>(#" . $tempr->productid . ") " . $tempr->title . "</a> ,";
                                                    }
                                                    $parent_product = rtrim($parent_product, " ,");
                                                }

echo "<tr><td>" . t($hashcount) . "</td><td class='letestsales_table'>" . $r->payment_id . "</td><td class='letestsales_table'>" . $r->purchase_name . "</td><td class='letestsales_table'>" . $r->purchase_email . "</td><td>" . $date . "</td><td onclick='viewPurchaseDetail(" . $r->id . ")' style='cursor:pointer;'><i class='fas fa-eye' style='margin-right:4px;'></i></td></tr>";
                                            }
                                            ?>
                                            
                                        </tbody>

</table>
                                </div>
                                <div class="text-end"><a href="index.php?page=sales"><button class="btn theme-button mt-2"><?php w('All Sales'); ?></button></a></div>
                            </div>
                        </div>
                    </div>
                </div>

</div>
        </div>
    <?php } else { ?>
        <div class="row ">
            <div class="col-lg-5 dash-init mx-auto align-self-center">
                <div class="card">
                    <div class="card-header bg-white theme-text"><?php w('Welcome To CourseFunnels'); ?></div>
                    <div class="card-body text-center">

<div class="p-3">
                            <h3 class="theme-text card-text"><?php w('Start off something awesome'); ?></h3>
                        </div>
                        <div class="p-3"> <a href="index.php?page=create_funnel" class="btn btn-app theme-button" role="button"><i class="fas fa-funnel-dollar"></i><?php w('Create a funnel now'); ?></a></div>
                    </div>
                </div>
            </div>
        </div>
    <?php } ?>
</div>
<script>
    var globdiv;

var steppayment = arr[3];
                shippingtable = steppayment + shippingtable;

shippingtable += "</tbody><thead ><th colspan=2>Payment Method</th></thead><tbody>";
                try {
                    shippingtable += "<tr><td colspan=2>" + arr[1] + "</td></tr>";
                } catch (err) {
                    console.log(err.message);
                }
                shippingtable += "</tbody></table></div>";

}
            document.getElementsByClassName("purchasedetailqmlr")[0].innerHTML = shippingtable;
        });
    }
    authPurchaseData();
</script>
<script>
    function dropdown_days() {
        document.getElementById("set_my_days").submit();
    }
    $(function() {

$("#custom-days").on("click", function() {
            $("#cf-custom-days").toggle();
        });
    });
</script>