验证中...
Languages: PHP
Categories: Web开发技术
Latest update 2018-12-09 10:38
要改成TP3的话 , 需要把Db::name 换成M() ,update insert field 换掉, save add getfield
Raw Copy
//签到主页面
public function sign_index(){
// 日历列表
$monthSign = $this->getMonthSign();
$dayList = $this->showDays($monthSign);
// 今天签到
$data = $this->todayData();
if(empty($data)){
$data['is_sign'] =0;
$data['status']=10002;
$data['msg']="今天未签到";
}else{
$data['status']=10001;
$data['msg']="今天已经签到";
}
$this->return_data($data);
}
/**
* 执行当天签到 也就是点击签到调用的接口
* @return json 签到成功返回 {status:1,info:'已签到'}
*/
public function sign(){
$todayData = $this->todayData();
if($todayData['is_sign'] == 1){
$this->return_data('已签到');
}else{
$data = $this->getInsertData($this->user_id);
// 无今天数据
if($todayData == NULL){
$data['uid'] = $this->user_id;
$data['atime'] = time();
$id = Db::name('members_sign')->insertGetId($data);
}else{
$save = Db::name('members_sign')->where("id = {$todayData['id']}")->update($data);
}
if($id or $save){
//积分数
$score = $this->getTodayScores($data['days']);
// 为该用户添加积分
// addScore($this->user_id,$score);
$res['status'] = 10001;
$res['msg'] ="签到成功!";
$res['score']=$score;
$res['days']=$data['days'];
$this->return_data($res);
}else{
$res['status'] = 10002;
$res['msg'] ="签到失败,请刷新后重试!";
$this->return_data($res);
}
}
}
/**
* 返回每次签到要插入的数据
*
* @param int $uid 用户id
* @return array(
* 'days' => '天数',
* 'is_sign' => '是否签到,用1表示已经签到',
* 'stime' => '签到时间',
* );
*/
protected function getInsertData($uid){
// 昨天的连续签到天数
$start_time = strtotime(date('Y-m-d 0:0:0',time()-86400))-1;
$end_time = strtotime(date('Y-m-d 23:59:59',time()-86400))+1;
$days = Db::name('members_sign')->where("uid = $uid and atime > $start_time and atime < $end_time")->value('days');
if($days){
$days++;
if($days > 30){
$days = 1;
}
}else{
$days = 1;
}
return array(
'days' => $days,
'is_sign' => 1,
'stime' => time()
);
}
/**
* 用户当天签到的数据
* @return array 签到信息 is_sign,stime 等
*/
protected function todayData(){
$time = time();
$start_stime = strtotime(date('Y-m-d 0:0:0',$time))-1;
$end_stime = strtotime(date('Y-m-d 23:59:59',$time))+1;
return Db::name('members_sign')->field('atime',true)->where("uid = {$this->user_id} and atime > $start_stime and atime < $end_stime")->find();
}
/**
* 积分规则,返回连续签到的天数对应的积分
*
* @param int $days 当天应该得的分数
* @return int 积分
*/
protected function getTodayScores($days){
if($days == 30){
return 50;
}else if($days > 19){
return 8;
}else if($days > 9){
return 5;
}else{
return 3;
}
}
/**
* 显示签到列表
*
* @param array $signDays 某月签到的日期 array(1,2,3,4,5,12,13)
* @param int $year 可选,年份
* @param int $month 可选,月份
* @return string 日期列表<li>1</li>....
*/
protected function showDays($signDays,$year='',$month=''){
$time = time();
$year = $year ? $year : date('Y',$time);
$month = $month ? $month : date('m',$time);
$daysTotal = date('t', mktime(0, 0, 0, $month, 1, $year));
$now = date('Y-m-d',$time);
$str = '';
// dump($daysTotal);
//exit;
for ($j = 1; $j <= $daysTotal; $j++) {
$i++;
$someDay = date('Y-m-d',strtotime("$year-$month-$j"));
// dump($someDay);exit;
// 小于今天的日期样式
if ($someDay <= $now){
// 当天日期样式 tdc = todayColor
if($someDay == $now){
// 当天签到过的
if(in_array($j,$signDays)){
$str .= '<li class="current fw tdc">'.$j.'</li>';
}else{
$str .= '<li class="today fw tdc">'.$j.'</li>';
}
}else{
// 签到过的日期样式 current bfc = beforeColor , fw = font-weight
if(in_array($j,$signDays)){
$str .= '<li class="current fw bfc">'.$j.'</li>';
}else{
$str .= '<li class="fw bfc">'.$j.'</li>';
}
}
}else{
$str .= '<li>'.$j.'</li>';
}
}
// dump($str);exit;
return $str;
}
/**
* 获取当月签到的天数,与 $this->showDays() 配合使用
* @return 当月签到日期 array(1,2,3,4,5,12,13)
*/
protected function getMonthSign(){
$time = time();
$year = date('Y',$time);
$month = date('m',$time);
$day = date("t",strtotime("$year-$month"));
$start_stime = strtotime("$year-$month-1 0:0:0")-1;
$end_stime = strtotime("$year-$month-$day 23:59:59")+1;
$list = Db::name('members_sign')->field('stime')->where("uid = {$this->user_id} and stime > $start_stime and stime < $end_stime")->order('stime asc')->select();
// dump($list);
// exit;
foreach($list as $key => $value){
// dump($value);exit;
$list[$key] = date("d",$value["stime"]);
}
// dump($list);exit;
return $list;
}
mysql
Raw Copy
CREATE TABLE `members_sign` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(11) unsigned NOT NULL COMMENT '用户id',
`days` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '连续签到的天数',
`is_share` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否分享过',
`is_sign` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否签到过',
`stime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '签到的时间',
`atime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
PRIMARY KEY (`id`),
KEY `index_uid` (`uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=162 DEFAULT CHARSET=utf8 COMMENT='签到分享表';

Comment list( 0 )

You need to Sign in for post a comment

Help Search

183227_9af5e6a8_1826025 111910_4d91f001_1826025