|
Server : nginx/1.22.1 System : Linux iZwz9daxib3w3i063fw434Z 3.10.0-1127.19.1.el7.x86_64 #1 SMP Tue Aug 25 17:23:54 UTC 2020 x86_64 User : www ( 1000) PHP Version : 5.6.40 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv Directory : /www/wwwroot/www.jkmold.com/phpcms/model/ |
<?php
defined('IN_PHPCMS') or exit('No permission resources.');
pc_base::load_sys_class('model', '', 0);
class poster_stat_model extends model {
function __construct() {
$this->db_config = pc_base::load_config('database');
$this->db_setting = 'default';
$this->table_name = 'poster_'.date('Ym');
parent::__construct();
if(!$this->db->table_exists($this->table_name)) {
$this->create_table();
}
}
/**
* 按月份创建表
*/
private function create_table() {
$data_info = pc_base::load_config('database', $this->db_setting);
$charset = $data_info['charset'];
$sql = "CREATE TABLE IF NOT EXISTS `".$this->table_name."` (
`id` int(10) unsigned NOT NULL auto_increment,
`pid` smallint(5) unsigned NOT NULL default '0',
`siteid` smallint(5) unsigned NOT NULL default '0',
`spaceid` smallint(5) unsigned NOT NULL default '0',
`username` char(20) NOT NULL,
`area` char(40) NOT NULL,
`ip` char(15) NOT NULL,
`referer` char(120) NOT NULL,
`clicktime` int(10) unsigned NOT NULL default '0',
`type` tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (`id`),
KEY `pid` (`pid`,`type`,`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=".$charset." ;";
$this->db->query($sql);
}
/**
* 根据查询的日期，改变查询的表
* @param string $tablename 表名
*/
private function change_table($tablename = '') {
if ($tablename) $this->table_name = $this->db_tablepre.'poster_'.$tablename;
}
/**
* 获取所有广告统计表，并形成下来框
* @param string $year 查询的月份
* @return boolen/string
*/
public function get_list($year = '') {
$year = isset($year) ? $year : '';
if($year) {
$this->change_table($year);
}
$this->change_table($year);
$diff1 = date('Y', SYS_TIME); //当前年份
$diff2 = date('m', SYS_TIME); //当前月份
$diff = ($diff1-2010)*12+$diff2;
$selectstr = '';
for($y=$diff;$y>0;$y--) {
$value = date('Ym', mktime(0, 0, 0, $y, 1, 2010));
if($value<'201006' || !$this->db->table_exists($this->db_tablepre.'poster_'.$value)) break;
$selected = $year==$value ? 'selected' : '';
$selectstr .= "<option value='$value' $selected>".date("Y-m", mktime(0, 0, 0, $y, 1, 2010));
}
return $selectstr;
}
}
?>