function __construct()
{
parent::__construct();
// Load Base CodeIgniter files
$this->load->database();
$this->load->library('session');
$this->load->helper('url');
$this->load->helper('html');
$this->load->library('form_validation');
//Load models
$this->load->model('base_model');
$this->load->model('preferences/preference_model','preference');
// Load site wide modules
$this->load->library('status/status');
$this->load->library('site/bep_site');
$this->load->library('site/bep_assets');
$this->load->library('page/Page');
$this->load->library('auth/userlib');
// Load the SITE asset group
$this->bep_assets->load_asset_group('SITE');
// Get list parent categories
$model=new CI_Model();
$this->data['parents']=$model->getListByColumn('tn_categories','category_parent_id',0);
//set lang (auto)
$this->setLang();
// tuyet get facebook, twitter info,content tel
//$this->data['$cateProduct']=$model->getRowByColumn('tn_contact','category_name','')
$this->data['faceInfo']=$model->getRowByColumn('tn_info', 'info_name', 'facebook');
$this->data['twitterInfo']=$model->getRowByColumn('tn_info', 'info_name', 'twitter');
$this->data['movilInfo']=$model->getRowByColumn('tn_info', 'info_name', 'movil');
$this->data['telefonoInfo']=$model->getRowByColumn('tn_info', 'info_name', 'telefono');
// end tuyet
}
function getCounting()
{
$today=date('Y-m-d',time()+7*3600);
$model=new CI_Model();
$today_counting=$model->getRowByColumn('thongke','ngaythang',$today)->soluong;
$data['today']=$today_counting;
$segments=explode('-', $today);
$current_month= $segments[0].'-'.$segments[1];
$listByMonth=$model->getListByColumnLikeText('thongke','ngaythang',$current_month);
$month_count=0;
foreach ($listByMonth as $item)
{
$month_count+=$item->soluong;
}
$data['month']=$month_count;
$listAll=$model->getListFull('thongke');
$total_count=0;
foreach ($listAll as $item)
{
$total_count+=$item->soluong;
}
$data['total']=$total_count;
return $data;
}
