<?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_fields = User::addition_fields_list(); $user_course_field = $user_fields['course']; $stages = Event::getProposal(); $order_fields = Order::addition_fields_list(); $products = SiteHelper::product_stage_relation(); $courses_id = array(); $order = new Order(); $events = new Course(); $report_type = isset($_GET['report-type']) && !empty($_GET['report-type']) ? $_GET['report-type'] : 'week'; $today = date('F j, Y'); $period = SiteHelper::getConsultantOrders(null, $report_type, 'period'); $form_date = date('F j, Y', strtotime('+1 day', strtotime($period))); foreach ($stages as $obj) { $stage_id = $obj->ID; $course_id = Event::getParentID($stage_id); if (!in_array($course_id, $courses_id)) { array_push($courses_id, $course_id); } } ?>
public static function getConsultantOrders($code, $type, $mode) { $order_fields = Order::addition_fields_list(); $first_day_of_year = split('-', date('Y-m-d', strtotime(date('Y-01-00')))); $first_day_of_month = split('-', date('Y-m-d', strtotime('last day of last month'))); $first_day_of_week = strtotime('last sunday', strtotime('now')); $week_start = split('-', date('Y-m-d', $first_day_of_week)); $dates = array('week' => $week_start, 'month' => $first_day_of_month, 'year' => $first_day_of_year); if ($mode && $mode === 'period') { return implode('-', $dates[$type]); } $args = array('post_type' => 'shop_order', 'post_status' => 'wc-completed', 'meta_query' => array(array('key' => $order_fields['consultant'], 'value' => $code)), 'date_query' => array(array('column' => 'post_date_gmt', 'after' => array('year' => $dates[$type][0], 'month' => $dates[$type][1], 'day' => $dates[$type][2])), 'inclusive' => true)); #$orders = db::getEntries($args); return db::getEntries($args); }