PHP实现日历签到,并实现累计积分功能

2022-10-13,,,,

在网站开发过程中我们会经常用到签到功能来奖励用户积分,或者做一些其他活动。这次项目开发过程中做了日历签到,因为没有经验所有走了很多弯路,再次记录过程和步骤。

1.日历签到样式:使用的是calendar日历插件

 

前台代码

 1 <!doctype html>
 2 <html>
 3 <head>
 4 <meta charset="utf-8">
 5 <title>日历签到</title>
 6 <meta name="keywords" content="日历签到"/>
 7 <meta name="description" content="日历签到"/>
 8 <meta content="telephone=no" name="format-detection" />
 9 <meta content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=0;" name="viewport" />
10 <meta content="yes" name="apple-mobile-web-app-capable" />
11 <meta content="black" name="apple-mobile-web-app-status-bar-style" />
12 <link href="__tpl__/css/index.css" rel="stylesheet" type="text/css">
13 <link rel="stylesheet" type="text/css" href="__tpl__/css/main.css">
14 <link rel="stylesheet" type="text/css" href="__tpl__/css/self.css">
15 <link rel="stylesheet" type="text/css" href="__tpl__/css/swiper.min.css">
16 </head>
17 <body style="background:#fff;">
18 <div class="warpper">
19   <div class="sign">
20     <ul>
21       <li><span>本月签到</span><b><?if(is_array($sign)){echo count($sign);}else{echo '0';}?></b></li>
22       <li><span>签到累计</span><b><?php if(is_array($allsign)){echo count($allsign);}else{echo '0';}?></b></li>
23       <li><span>累计积分</span><b><?php if(is_array($allsign)){echo count($allsign)*$config['site_praise'];}else{echo '0';}?></b></li>
24       <li><span>全部积分</span><b><?php echo ceil($user['integral']);?></b></li>
25     </ul>
26   </div>
27   <input type="hidden" name="" value="__url__/checksign.html" id="sign">
28   <div class="singbox" id="calendar"></div>
29   <div class="qdbox"><a href="javascript:;" class="qd_btn" onclick="sign_()" style="background: <?php echo is_sign_now()?'':'rgb(135, 135, 135)'; ?>"  ><?php echo is_sign_now()?'签到':'已签到'; ?></a></div>
30 <script src="__tpl__/js/jquery.min.js"></script> 
31 <script src="__tpl__/js/swiper.min.js"></script>
32 <script src="__tpl__/js/calendar.js"></script>
33 <script src="__tpl__/js/js.js"></script>
34 <script type="text/javascript" src="__tpl__/js/layer/2.1/layer.js"></script>
35 {include file="footer"}
36 
37 <script type="text/javascript">
38 $(function(){
39   var arr='';
40 //var signlist=[{"signday":"09"},{"signday":"11"}];
41   <?php if(is_array($sign)){ foreach($sign as $vo){ ?>
42      arr+="{'signday':'<?php echo $vo['day'];?>'},";
43     <?php }?>
44     arr = arr.substr(0,arr.length-1);
45     arr ="["+arr+"]";
46     var signlist = eval('(' + arr + ')');
47  <?php }else{?>
48       var signlist=[];
49       <?php }?>
50 
51    calutil.init(signlist);
52 });
53 </script>
54 <script type="text/javascript">
55 function sign_(){
56   $.ajax({
57       type:'get',
58       url:"__url__/checksign.html", 
59       datatype:'json',
60       success:function(res){
61           if(res.result==1){
62             window.location.href="__url__/sign.html"
63           }else{
64               alert(res.msg);
65           }
66       }
67   })
68 }
69 </script>
70  

 

插件calendar.js 修改如下:

  1 var calutil = {
  2   //当前日历显示的年份
  3   showyear:2015,
  4   //当前日历显示的月份
  5   showmonth:1,
  6   //当前日历显示的天数
  7   showdays:1,
  8   eventname:"load",
  9   //初始化日历
 10   init:function(signlist,s=''){
 11     calutil.setmonthandday();
 12     if (typeof(s) == 'undefined'){
 13     }else{
 14       signlist.splice('','',s);
 15     }
 16     calutil.draw(signlist);
 17     calutil.bindenvent(signlist);
 18   },
 19   draw:function(signlist){
 20     //绑定日历
 21     //alert(signlist.length);
 22     // console.log(signlist);
 23     if(signlist.length > 21){
 24       //alert(21);
 25       $("#sign_note").empty();
 26       $("#sign_note").html('<button class="sign_contener" type="button"><i class="fa fa-calendar-check-o" aria-hidden="true"></i>&nbsp;已达标,获取1次抽奖</button>');
 27     }
 28     var str = calutil.drawcal(calutil.showyear,calutil.showmonth,signlist);
 29     $("#calendar").html(str);
 30     //绑定日历表头
 31     var calendarname=calutil.showyear+"/"+calutil.showmonth+"";
 32     $(".calendar_month_span").html(calendarname);  
 33   },
 34   //绑定事件
 35   bindenvent:function(signlist){
 36     // //绑定上个月事件
 37     // $(".calendar_month_prev").click(function(){
 38     //   //ajax获取日历json数据
 39     //   //var signlist=[{"signday":"10"},{"signday":"11"},{"signday":"12"},{"signday":"13"}];
 40     //   calutil.eventname="prev";
 41     //   calutil.init(signlist);
 42     // });
 43     // //绑定下个月事件
 44     // $(".calendar_month_next").click(function(){
 45     //   //ajax获取日历json数据
 46     //   //var signlist=[{"signday":"10"},{"signday":"11"},{"signday":"12"},{"signday":"13"}];
 47     //   calutil.eventname="next";
 48     //   calutil.init(signlist);
 49     // });
 50 
 51     $(".calendar_record").click(function(){
 52       //ajax获取日历json数据
 53       // console(typeof(signlist)+"yxy");
 54         //var signlist=[{"signday":"10"},{"signday":"11"},{"signday":"12"},{"signday":"13"}];
 55         //var tmp = {"signday":$(this).html()};
 56       //if (typeof(signlist) == 'undefined'){
 57         //不做处理
 58       //}else{
 59       //  signlist.splice('','',tmp);
 60       //  console.log(signlist);
 61       //  calutil.init(signlist);
 62      // }
 63      //alert($(this).html());
 64     var tmp = {"signday":$(this).html()};
 65     console.log(tmp.signday)
 66 
 67     // if(tmp.signday==11){
 68       //执行签到
 69       $.ajax({
 70           type:'post',
 71           url:"checksign.html", 
 72           data:{day:tmp.signday},
 73           datatype:'json',
 74           success:function(res){
 75               // if(res.result==1){
 76                 // calutil.init(signlist,tmp);
 77               // }else{
 78                   alert(res.msg);
 79                   location.reload(true);
 80               // }
 81 
 82           }
 83       })
 84 
 85     // }else{
 86     //   alert("请签到当天日期")
 87     // }
 88     });
 89   },
 90   //获取当前选择的年月
 91   setmonthandday:function(){
 92     switch(calutil.eventname)
 93     {
 94       case "load":
 95         var current = new date();
 96         calutil.showyear=current.getfullyear();
 97         calutil.showmonth=current.getmonth() + 1;
 98         break;
 99       case "prev":
100         var nowmonth=$(".calendar_month_span").html().split("年")[1].split("月")[0];
101         calutil.showmonth=parseint(nowmonth)-1;
102         if(calutil.showmonth==0)
103         {
104             calutil.showmonth=12;
105             calutil.showyear-=1;
106         }
107         break;
108       case "next":
109         var nowmonth=$(".calendar_month_span").html().split("年")[1].split("月")[0];
110         calutil.showmonth=parseint(nowmonth)+1;
111         if(calutil.showmonth==13)
112         {
113             calutil.showmonth=1;
114             calutil.showyear+=1;
115         }
116         break;
117     }
118   },
119   getdaysinmonth : function(imonth, iyear){
120    var dprevdate = new date(iyear, imonth, 0);
121    return dprevdate.getdate();
122   },
123   bulidcal : function(iyear, imonth) {
124    var amonth = new array();
125    amonth[0] = new array(7);
126    amonth[1] = new array(7);
127    amonth[2] = new array(7);
128    amonth[3] = new array(7);
129    amonth[4] = new array(7);
130    amonth[5] = new array(7);
131    amonth[6] = new array(7);
132    var dcaldate = new date(iyear, imonth - 1, 1);
133    var idayoffirst = dcaldate.getday();
134    var idaysinmonth = calutil.getdaysinmonth(imonth, iyear);
135    var ivardate = 1;
136    var d, w;
137    amonth[0][0] = "日";
138    amonth[0][1] = "一";
139    amonth[0][2] = "二";
140    amonth[0][3] = "三";
141    amonth[0][4] = "四";
142    amonth[0][5] = "五";
143    amonth[0][6] = "六";
144    for (d = idayoffirst; d < 7; d++) {
145     amonth[1][d] = ivardate;
146     ivardate++;
147    }
148    for (w = 2; w < 7; w++) {
149     for (d = 0; d < 7; d++) {
150      if (ivardate <= idaysinmonth) {
151       amonth[w][d] = ivardate;
152       ivardate++;
153      }
154     }
155    }
156    return amonth;
157   },
158   ifhassigned : function(signlist,day){
159    var signed = false;
160    $.each(signlist,function(index,item){
161     if(item.signday == day) {
162      signed = true;
163      return false;
164     }
165    });
166    return signed ;
167   },
168   drawcal : function(iyear, imonth ,signlist) {
169    var mymonth = calutil.bulidcal(iyear, imonth);
170    var htmls = new array();
171    htmls.push("<div class='sign_main' id='sign_layer'>");
172    htmls.push("<div class='sign_succ_calendar_title'>");
173    //htmls.push("<div class='calendar_month_next'>下月</div>");
174    //htmls.push("<div class='calendar_month_prev'>上月</div>");
175    htmls.push("<div class='calendar_month_span'></div>");
176    htmls.push("</div>");
177    htmls.push("<div class='sign_equal' id='sign_cal'>");
178    htmls.push("<div class='sign_row'>");
179    htmls.push("<div class='th_1 bold'>" + mymonth[0][0] + "</div>");
180    htmls.push("<div class='th_2 bold'>" + mymonth[0][1] + "</div>");
181    htmls.push("<div class='th_3 bold'>" + mymonth[0][2] + "</div>");
182    htmls.push("<div class='th_4 bold'>" + mymonth[0][3] + "</div>");
183    htmls.push("<div class='th_5 bold'>" + mymonth[0][4] + "</div>");
184    htmls.push("<div class='th_6 bold'>" + mymonth[0][5] + "</div>");
185    htmls.push("<div class='th_7 bold'>" + mymonth[0][6] + "</div>");
186    htmls.push("</div>");
187    var d, w;
188    for (w = 1; w < 6; w++) {
189     htmls.push("<div class='sign_row'>");
190     for (d = 0; d < 7; d++) {
191 
192      var ifhassigned = calutil.ifhassigned(signlist,mymonth[w][d]);
193      console.log("001:"+ifhassigned);
194      if(ifhassigned && typeof(mymonth[w][d]) != 'undefined'){
195       htmls.push("<div class='td_"+d+" on'>" + (!isnan(mymonth[w][d]) ? mymonth[w][d] : " ") + "</div>");
196      } else {
197       htmls.push("<div class='td_"+d+" calendar_record'>" + (!isnan(mymonth[w][d]) ? mymonth[w][d] : " ") + "</div>");
198      }
199     }
200     htmls.push("</div>");
201    }
202    htmls.push("</div>");
203    htmls.push("</div>");
204    htmls.push("</div>");
205    return htmls.join('');
206   }
207 };
208  

 

php代码的实现

 1 //签到(status=1)
 2 public function sign(){
 3     //当月累计签到
 4     $sign = $this->model->table('praise')->where('uid='.$_session['user']['uid'].' and time>'.strtotime(date("y-m-01",time())))->select();
 5     if($sign){
 6         foreach($sign as $k=>$v){
 7             $sign[$k]['day']=date('d',$v['time']);
 8         }
 9     }
10     //所有签到
11     $allsign = $this->model->table('praise')->where('uid='.$_session['user']['uid'].' and status=1')->select();
12     $this->assign('allsign', $allsign);
13     $this->assign('sign', $sign);
14     $this->assign('user', $_session['user']);
15     $this->display('member_sign');
16 }   
17 //点击签到 
18 public function checksign(){
19     if($_post['day']){
20         $day=intval($_post['day']);
21     }else{
22         $day=date("d",time());
23     }
24     if($day!=date("d",time())){
25         $data['msg']="请在当前日期点击签到";
26         echo json_encode($data);
27         return;
28     }
29     $condition2  = 'uid='.$_session['user']['uid'];
30     $condition2 .= " and date_format(from_unixtime(time),'%y-%m-%d') = '".date("y-m-d",time())."'";
31     $sign = $this->model->table('praise')->where($condition2)->find();
32     //判断是否已经签到
33     if (empty($sign)) {
34         //新增积分
35         $this->model->table('member')->data('integral=integral+'.$this->config['site_praise'].',allintegral=allintegral+'.$this->config['site_praise'])->where('uid='.$_session['user']['uid'])->update();//增加积分
36         $arr['subject']="签到赠送积分";
37         $arr['uid'] = $_session['user']['uid'];
38         $arr['integral'] = $this->config['site_praise'];
39         $arr['time']=time();
40         $this->model->table('member_integral')->data($arr)->insert();
41 
42         $updateuser = $this->model->table('member')->where('uid='.$_session['user']['uid'])->find();//购物后更新session积分
43         $_session['user']['integral'] = $updateuser['integral'];
44         $_session['user']['allintegral'] = $updateuser['allintegral'];
45 
46 
47         $data['uid'] = $_session['user']['uid'];
48         //$data['pid'] = $item;
49         $data['status'] = 1;
50         $data['time'] = time();
51         $this->model->table('praise')->data($data)->insert();
52         //$this->model->table('post')->data("digg=digg+1")->where('id='.$id)->update();
53         //$this->model->table('member_comment')->data("praise=praise+1")->where('id='.$item)->update();
54         $this->jssuccess('签到成功!');
55     } else {
56         $this->jserror('已经签过到了。');
57     }
58 }
59 
60 
61 //判断是否已经签到
62 function is_sign_now(){
63     $condition2  = 'uid='.$_session['user']['uid'];
64     $condition2 .= " and date_format(from_unixtime(time),'%y-%m-%d') = '".date("y-m-d",time())."'";
65     $sign = module('common')->model->table('praise')->where($condition2)->find();
66     //判断是否已经签到
67     if (empty($sign)) {
68         return true;
69     }else{
70         return false;
71     }
72 }

 

 

《PHP实现日历签到,并实现累计积分功能.doc》

下载本文的Word格式文档,以方便收藏与打印。