PHP实现日历签到，并实现累计积分功能
程序员文章站
2022-05-07 21:11:45
在网站开发过程中我们会经常用到签到功能来奖励用户积分，或者做一些其他活动。这次项目开发过程中做了日历签到，因为没有经验所有走了很多弯路，再次记录过程和步骤。 1.日历签到样式：使用的是calendar日历插件 前台代码 1 2 3 4
在网站开发过程中我们会经常用到签到功能来奖励用户积分，或者做一些其他活动。这次项目开发过程中做了日历签到，因为没有经验所有走了很多弯路，再次记录过程和步骤。
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> 已达标，获取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 }
上一篇： HTML5 Web Workers