<?php

use Nerds\Base\Util\Helpers\SiteHelper;
use Nerds\Base\Util\Helpers\DatabaseAccessWrapper as db;
use Nerds\Bsalted\Entity\UserEntity\User;
use Nerds\Bsalted\Entity\EventEntity\Event;
use Nerds\Bsalted\Entity\CourseEntity\Course;
use Nerds\Bsalted\Entity\OrderEntity\Order;
$users = User::getByRole('adventure_consultant');
$user_id = User::getID();
$user_name = User::getFullName($user_id);
$user_capitan_id = SiteHelper::getConsultantCapitan($user_id);
$user_capitan_name = User::getFullName($user_capitan_id);
$user_code = User::getCode($user_id);
$date_type = isset($_GET['report-type']) && !empty($_GET['report-type']) ? $_GET['report-type'] : 'week';
$period = SiteHelper::getConsultantOrders($user_code, 'week', 'period');
#$user_orders      = SiteHelper::getConsultantOrders($user_code, 'week', 'period');
$user_protege = SiteHelper::getConsultantProteges($user_id);
$date_range = date('F j, Y', strtotime('+1 day', strtotime($period)));
$user_account = 0;
$user_amount = db::get_option('bsalted_cosultant_amount');
$user_bonus5 = db::get_option('bsalted_cosultant_bonus5');
$user_bonus10 = db::get_option('bsalted_cosultant_bonus10');
$user_fields = User::addition_fields_list();
$stage_type_fields = Event::types_fields_list();
$user_ordrs = User::getOrdersByDate(21, 'week');
#var_dump($user_amount);
?>


<div class="bsalted-consultant-top">
		<th scope="col" id="title" class="manage-column column-title sortable desc" style="">ID</th>
		<th scope="col" id="author" class="manage-column column-author" style="">Adventure Consultant name</th>
		<th scope="col" id="categories" class="manage-column column-categories" style="">Introspective Sales</th>
		<th scope="col" id="tags" class="manage-column column-tags" style="">Course Sales</th>
		<th scope="col" id="date" class="manage-column column-date sortable asc" style="">
			-
		</th>
	</tr>
	</thead>

	<tbody id="the-list">
			<?php 
foreach ($users as $user_obj) {
    $user_id = $user_obj->ID;
    $user_code = User::getCode($user_id);
    $user_orders = SiteHelper::getConsultantOrders($user_code, $report_type);
    $user_sales = array();
    $user_course_sales = 0;
    $user_int_sales = 0;
    #$from_date = date('F j, Y', strtotime('+1 day', strtotime($user_data['period'])));
    foreach ($user_orders as $order) {
        $order_id = $order->ID;
        $order_course_id = db::getEntryMeta($order_id, $user_course_field)[0];
        $user_sales[$order_id][$order_course_id] = array();
        $order_obj = new \WC_Order($order_id);
        $order_items = $order_obj->get_items();
        foreach ($order_items as $item) {
            #array_push($user_sales[$order_id][$order_course_id], $item['product_id']);
            $product_name = array_search($item['product_id'], $products);
            if ($product_name === 'PRE') {
                $user_course_sales++;