Backups Created:
/home/japatmex/public_html/wp-content/edit-wolf.php

SavvyWolf - MANAGER

Edit File: Dashboard.php

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class Dashboard extends MY_Controller {

public function __construct(){
        parent::__construct();
        $this->load->model('Ecomm_model');
        $this->load->helper('ecomm_helper');
    }

public function index() {
        $this->data['cat_cnt'] = $this->Ecomm_model->getCount('tbl_gf_ecomm_category', array('parent_id' => 0));
        $this->data['sub_cat_cnt'] = $this->Ecomm_model->getCount('tbl_gf_ecomm_category', array('parent_id !=' => 0));
        $this->data['product_cnt'] = $this->Ecomm_model->getCount('tbl_gf_ecomm_product');
        $this->data['user_cnt'] = $this->Ecomm_model->getCount('tbl_gf_users', ['UserArchived' => 0]);
        $this->data['order_cnt'] = $this->Ecomm_model->getCount('tbl_gf_ecomm_order_details');

$this->data['top_selling_products'] = $this->Ecomm_model->top_selling_products();

$this->data['todays_orders'] = $this->Ecomm_model->todays_orders();
        $this->data['total_orders_sales'] = $this->Ecomm_model->total_orders_sales();
        $this->data['total_stock'] = $this->Ecomm_model->total_stock_in_store();

//last_query();
        $currDt = setDtTmWRTYourCountry();
        $rsEcommOrdersM = $this->db->query("SELECT COUNT(id) AS Orders, sum(total_amt-refund_amt) AS paid, MONTH(FROM_UNIXTIME(order_date)) as Month FROM tbl_gf_ecomm_order_details WHERE order_status = '4' AND Year(FROM_UNIXTIME(order_date)) = '".get_dyear($currDt)."' GROUP BY MONTH(FROM_UNIXTIME(order_date))")->result();
        //d($rsEcommOrdersM);

foreach($rsEcommOrdersM as $row)
        {
            //$this->data['arrIMEIMO'] = $row->paid;
            $this->data['arrIMEIMO'][ltrim($row->Month, '0')] = $row->paid;
        }

//d($this->data['arrIMEIMO']);

$DEFAULT_CURR_SYM = '';
        $DEFAULT_CURR_ABB = '';
        $DEFAULT_CURR_ID = '';
        $rwCurrency = $this->Admin_dashboard_model->fetch_currency_data();
        if(isset($rwCurrency->CurrencyId) && $rwCurrency->CurrencyId != '')
        {
            $DEFAULT_CURR_ID = $rwCurrency->CurrencyId;
            $DEFAULT_CURR_SYM = stripslashes($rwCurrency->CurrencySymbol);
            $DEFAULT_CURR_ABB = stripslashes($rwCurrency->CurrencyAbb);
        }
        $this->data['DEFAULT_CURR_SYM'] = $DEFAULT_CURR_SYM;

$this->data['view'] = 'admin/ecomm/dashboard';
        $this->load->view('admin/layouts/default1', $this->data);
    }
}