<?php
class ControllerExtensionDashboardChart extends Controller {
    private $error = [];

    public function index() {
        $this->load->language('extension/dashboard/chart');

        $this->document->setTitle($this->language->get('heading_title'));

        $this->load->model('setting/setting');

        if (($this->request->server['REQUEST_METHOD'] == 'POST') && $this->validate()) {
            $this->model_setting_setting->editSetting('dashboard_chart', $this->request->post);

            $this->session->data['success'] = $this->language->get('text_success');

            $this->response->redirect($this->url->link('extension/extension', 'token=' . $this->session->data['token'] . '&type=dashboard', true));
        }

        $data['heading_title'] = $this->language->get('heading_title');

        $data['text_edit'] = $this->language->get('text_edit');
        $data['text_enabled'] = $this->language->get('text_enabled');
        $data['text_disabled'] = $this->language->get('text_disabled');

        $data['entry_width'] = $this->language->get('entry_width');
        $data['entry_status'] = $this->language->get('entry_status');
        $data['entry_sort_order'] = $this->language->get('entry_sort_order');

        $data['button_save'] = $this->language->get('button_save');
        $data['button_cancel'] = $this->language->get('button_cancel');

        if (isset($this->error['warning'])) {
            $data['error_warning'] = $this->error['warning'];
        } else {
            $data['error_warning'] = '';
        }

        $data['breadcrumbs'] = [];

        $data['breadcrumbs'][] = array(
          'text' => $this->language->get('text_home'),
          'href' => $this->url->link('common/dashboard', 'token=' . $this->session->data['token'], true)
        );

        $data['breadcrumbs'][] = array(
          'text' => $this->language->get('text_extension'),
          'href' => $this->url->link('extension/extension', 'token=' . $this->session->data['token'] . '&type=dashboard', true)
        );

        $data['breadcrumbs'][] = array(
          'text' => $this->language->get('heading_title'),
          'href' => $this->url->link('extension/dashboard/chart', 'token=' . $this->session->data['token'], true)
        );

        $data['action'] = $this->url->link('extension/dashboard/chart', 'token=' . $this->session->data['token'], true);

        $data['cancel'] = $this->url->link('extension/extension', 'token=' . $this->session->data['token'] . '&type=dashboard', true);

        if (isset($this->request->post['dashboard_chart_width'])) {
            $data['dashboard_chart_width'] = $this->request->post['dashboard_chart_width'];
        } else {
            $data['dashboard_chart_width'] = $this->config->get('dashboardchart_width');
        }

        $data['columns'] = [];

        for ($i = 3; $i <= 12; $i++) {
            $data['columns'][] = $i;
        }

        if (isset($this->request->post['dashboard_chart_status'])) {
            $data['dashboard_chart_status'] = $this->request->post['dashboard_chart_status'];
        } else {
            $data['dashboard_chart_status'] = $this->config->get('dashboard_chart_status');
        }

        if (isset($this->request->post['dashboard_chart_sort_order'])) {
            $data['dashboard_chart_sort_order'] = $this->request->post['dashboard_chart_sort_order'];
        } else {
            $data['dashboard_chart_sort_order'] = $this->config->get('dashboard_chart_sort_order');
        }

        $data['header'] = $this->load->controller('common/header');
        $data['column_left'] = $this->load->controller('common/column_left');
        $data['footer'] = $this->load->controller('common/footer');

        $this->response->setOutput($this->load->view('extension/dashboard/chart_form', $data));
    }

    protected function validate() {
        if (!$this->user->hasPermission('modify', 'extension/dashboard/chart')) {
            $this->error['warning'] = $this->language->get('error_permission');
        }

        return !$this->error;
    }

    public function dashboard() {
        $this->load->language('extension/dashboard/chart');

        $data['heading_title'] = $this->language->get('heading_title');

        $data['text_day'] = $this->language->get('text_day');
        $data['text_week'] = $this->language->get('text_week');
        $data['text_month'] = $this->language->get('text_month');
        $data['text_year'] = $this->language->get('text_year');
        $data['text_view'] = $this->language->get('text_view');

        $data['token'] = $this->session->data['token'];

        return $this->load->view('extension/dashboard/chart_info', $data);
    }

    public function chart() {
        $this->load->language('extension/dashboard/chart');

        $json = [];

        $this->load->model('report/sale');
        $this->load->model('report/customer');

        $json['order'] = [];
        $json['customer'] = [];
        $json['xaxis'] = [];
        $json['sales'] = [];

        $json['order']['label'] = $this->language->get('text_order');
        $json['customer']['label'] = $this->language->get('text_customer');
        $json['sales']['label'] = "turnover";
        $json['order']['data'] = [];
        $json['customer']['data'] = [];
        $json['sales']['data'] = [];

        if (isset($this->request->get['range'])) {
            $range = $this->request->get['range'];
        } else {
            $range = 'day';
        }

        switch ($range) {
            default:
            case 'day':
                $results = $this->model_report_sale->getTotalOrdersByDay();

                foreach ($results as $key => $value) {
                    $json['order']['data'][] = array($key, $value['total']);
                }

                $results = $this->model_report_customer->getTotalCustomersByDay();

                foreach ($results as $key => $value) {
                    $json['customer']['data'][] = array($key, $value['total']);
                }

                for ($i = 0; $i < 24; $i++) {
                    $json['xaxis'][] = array($i, $i);
                }
                break;
            case 'week':
                $results = $this->model_report_sale->getTotalOrdersByWeek();

                foreach ($results as $key => $value) {
                    $json['order']['data'][] = array($key, $value['total']);
                }

                $results = $this->model_report_customer->getTotalCustomersByWeek();

                foreach ($results as $key => $value) {
                    $json['customer']['data'][] = array($key, $value['total']);
                }

                $date_start = strtotime('-' . date('w') . ' days');

                for ($i = 0; $i < 7; $i++) {
                    $date = date('Y-m-d', $date_start + ($i * 86400));

                    $json['xaxis'][] = array(date('w', strtotime($date)), date('D', strtotime($date)));
                }
                break;
            case 'month':
                $results = $this->model_report_sale->getTotalOrdersByMonth();

                foreach ($results as $key => $value) {
                    $json['order']['data'][] = array($key, $value['total']);
                }

                $results = $this->model_report_customer->getTotalCustomersByMonth();

                foreach ($results as $key => $value) {
                    $json['customer']['data'][] = array($key, $value['total']);
                }



                for ($i = 1; $i <= date('t'); $i++) {
                    $date = date('Y') . '-' . date('m') . '-' . $i;

                    $json['xaxis'][] = array(date('j', strtotime($date)), date('d', strtotime($date)));
                    $json['sales']['data'][] = [$i, $this->currency->format(round($this->model_report_sale->getTotalSales(['filter_date_added' => $date])), '', '', 0)];
                }
                break;
            case 'year':
                $results = $this->model_report_sale->getTotalOrdersByYear();

                foreach ($results as $key => $value) {
                    $json['order']['data'][] = array($key, $value['total']);
                }

                $results = $this->model_report_customer->getTotalCustomersByYear();

                foreach ($results as $key => $value) {
                    $json['customer']['data'][] = array($key, $value['total']);
                }

                for ($i = 1; $i <= 12; $i++) {
                    $json['xaxis'][] = array($i, date('M', mktime(0, 0, 0, $i)));
                }
                break;
        }

        $this->response->addHeader('Content-Type: application/json');
        $this->response->setOutput(json_encode($json));
    }
}