\Statistics_model

<?php
if (!defined('BASEPATH'))
    exit('No direct script access allowed');
class Statistics_model extends CI_Model
{
    private $table ='viewstatistics';
    public function __construct()
    {
        parent::__construct();

    }

    /**
     * 数据统计
     * */
    public function getStatisticsCount($type=0,$stime,$etime)
    {
        
        $this->db->where('typeFlag',$type);
        $this->db->where('viewTime',$stime);
       
        $result = $this->db->get('viewstatistics');
        return $result->row_array();
    }
    
    public function insertData($data=array())
    {
        $res = $this->db->insert('viewstatistics', $data);
        return $res;
    }
    
    public function updateNum($data,$time=0,$type=0)
	{
	    foreach ($data as $k => $v)
	    {
	        $this->db->set($k, $v, FALSE);
	    }
	    $this->db->where('typeFlag', $type);
	    $this->db->where('viewTime', $time)->update('viewstatistics');
	    return $this->db->affected_rows();
	}
	
	public function getViewStatisticsRow($time=0,$type=0)
	{
	    $this->db->where('typeFlag', $type);
	    $this->db->where('viewTime', $time);
	    $result = $this->db->get('viewstatistics');
	    return $result->row_array();
	}
	
	public function getStatisticsYearCount($type=0,$stime=0,$etime=0)
	{
	    $this->db->select_sum('viewNum');
	    $this->db->select('typeFlag,viewTime');
	    //$this->db->where('typeFlag',$type);
	  
	    if($stime>0)
	    {
	        $this->db->where('viewTime >=',$stime);
	    }
	    if($etime>0)
	    {
	        $this->db->where('viewTime <=',$etime);
	    }
	    $this->db->group_by('typeFlag');
	    $result = $this->db->get('viewstatistics');
	    return $result->result_array();
	}
}