<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); class Report_views_daily_model extends CI_Model { protected $_table='report_views_daily'; public function __construct(){ parent::__construct(); date_default_timezone_set("Asia/Ho_Chi_Minh"); } public function cmsCountAll($name = null) { $this->db->select('COUNT(*) AS totalResults'); $this->db->from($this->_table); if ($name != null) { $this->db->where('date', date('Y-m-d', strtotime($name))); } $query = $this->db->get(); $result = $query->result_array(); if ($result) { return $result[0]['totalResults']; } else { return 0; } } /** * Hàm lấy dữ liệu phân trang * * @param $record * @param $start * @param null $name * * @return mixed */ public function cmsGetPagination($record, $start, $name = null) { $this->db->select($this->_table . '.*, tracks.title AS name_song, tracks.art AS art'); $this->db->from($this->_table); $this->db->join('tracks', 'tracks.id = report_views_daily.track_id', 'left'); if ($name != null) { $this->db->where('date', date('Y-m-d', strtotime($name))); } $this->db->group_by('report_views_daily.id'); $this->db->order_by($this->_table . '.total_point', 'desc'); $this->db->limit($record); $query = $this->db->get(); return $query->result_array(); } }