在网站开发过程中我们会经常用到签到功能来奖励用户积分,或者做一些其他活动。这次项目开发过程中做了日历签到,因为没有经验所有走了很多弯路,再次记录过程和步骤。1.日历签到样式:2.本次签到只记录本月签到数,想要查询可以写其他页面,查询所有签到记录。(功能有,非常麻烦,古没有做。)3.前台代码
复制代码
*{margin:0;padding:0;font:14px/1.8 "Helvetica Neue","microsoft yahei";}
签到记录
$(".ser_mbx").click(function(){
$.ajax({
url:"{:U('Index/Checkin')}",type:'POST',datatype:"json",success:function(msg){
$(".already").show();
$(".ser_mbx").hide();
MonthSign();
}
});
});
});
MonthSign();
});functionMonthSign(){//ajax获取日历json数据
$.ajax({
url:"{:U('Index/MonthSign')}",type:'POST',datatype:"json",success:function(msg){//alert(msg);
/*var signList=[{"signDay":"10"},{"signDay":"11"},{"signDay":"12"},{"signDay":"13"}];*/calUtil.init(JSON.parse(msg));
}
});
}
var calUtil ={//当前日历显示的年份
showYear:2015,
//当前日历显示的月份
showMonth:1,
//当前日历显示的天数
showDays:1,eventName:"load",
//初始化日历
init:function(signList){
calUtil.setMonthAndDay();
calUtil.draw(signList);
calUtil.bindEnvent();
},draw:function(signList){//绑定日历
var str = calUtil.drawCal(calUtil.showYear,calUtil.showMonth,signList);
$("#calendar").html(str);//绑定日历表头
var calendarName=calUtil.showYear+"年"+calUtil.showMonth+"月";
$(".calendar_month_span").html(calendarName);
},
//绑定事件
bindEnvent:function(){//绑定上个月事件
$(".calendar_month_prev").click(function(){//ajax获取日历json数据
/*var signList=[{"signDay":"10"},{"signDay":"11"},{"signDay":"12"},{"signDay":"13"}];
calUtil.eventName="prev";
calUtil.init(signList);*/});//绑定下个月事件
$(".calendar_month_next").click(function(){//ajax获取日历json数据
/*var signList=[{"signDay":"10"},{"signDay":"11"},{"signDay":"12"},{"signDay":"13"}];
calUtil.eventName="next";
calUtil.init(signList);*/});
},
//获取当前选择的年月
setMonthAndDay:function(){switch(calUtil.eventName)
{case "load":
var current = new Date();
calUtil.showYear=current.getFullYear();
calUtil.showMonth=current.getMonth() + 1;break;case "prev":
var nowMonth=$(".calendar_month_span").html().split("年")[1].split("月")[0];
calUtil.showMonth=parseInt(nowMonth)-1;if(calUtil.showMonth==0)
{
calUtil.showMonth=12;
calUtil.showYear-=1;
}break;case "next":
var nowMonth=$(".calendar_month_span").html().split("年")[1].split("月")[0];
calUtil.showMonth=parseInt(nowMonth)+1;if(calUtil.showMonth==13)
{
calUtil.showMonth=1;
calUtil.showYear+=1;
}break;
}
},getDaysInmonth: function(iMonth,iYear){var dPrevDate = new Date(iYear, iMonth, 0);return dPrevDate.getDate();
},bulidCal: function(iYear,iMonth) {var aMonth = new Array();
aMonth[0] = new Array(7);
aMonth[1] = new Array(7);
aMonth[2] = new Array(7);
aMonth[3] = new Array(7);
aMonth[4] = new Array(7);
aMonth[5] = new Array(7);
aMonth[6] = new Array(7);var dCalDate = new Date(iYear, iMonth - 1, 1);var iDayOfFirst = dCalDate.getDay();var iDaysInMonth = calUtil.getDaysInmonth(iMonth,iYear);var iVarDate = 1;var d,w;
aMonth[0][0] = "日";
aMonth[0][1] = "一";
aMonth[0][2] = "二";
aMonth[0][3] = "三";
aMonth[0][4] = "四";
aMonth[0][5] = "五";
aMonth[0][6] = "六";for (d = iDayOfFirst; d < 7; d++) {
aMonth[1][d] =iVarDate;
iVarDate++;
}for (w = 2; w < 7; w++) {for (d = 0; d < 7; d++) {if (iVarDate <=iDaysInMonth) {
aMonth[w][d]=iVarDate;
iVarDate++;
}
}
}returnaMonth;
},ifHasSigned: function(signList,day){var signed = false;
$.each(signList,function(index,item){if(item.signDay ==day) {
signed= true;return false;
}
});returnsigned ;
},drawCal: function(iYear, iMonth ,signList) {var myMonth = calUtil.bulidCal(iYear,iMonth);var htmls = new Array();
htmls.push("
htmls.push("
htmls.push("
htmls.push("
htmls.push("
htmls.push("
htmls.push("
");htmls.push("
" + myMonth[0][0] + "");htmls.push("
" + myMonth[0][1] + "");htmls.push("
" + myMonth[0][2] + "");htmls.push("
" + myMonth[0][3] + "");htmls.push("
" + myMonth[0][4] + "");htmls.push("
" + myMonth[0][5] + "");htmls.push("
" + myMonth[0][6] + "");htmls.push("
");var d,w;for (w = 1; w < 7; w++) {htmls.push("
");for (d = 0; d < 7; d++) {var ifHasSigned = calUtil.ifHasSigned(signList,myMonth[w][d]);console.log(ifHasSigned);if(ifHasSigned){
htmls.push("
" + (!isNaN(myMonth[w][d]) ? myMonth[w][d] : " ") + "");}else{
htmls.push("
" + (!isNaN(myMonth[w][d]) ? myMonth[w][d] : " ") + "");}
}
htmls.push("
");}
htmls.push("
");htmls.push("
htmls.push("
}
};
复制代码4.后台代码:查询今天是否签到:
复制代码$points = M('points_log');$userid=session('user.id');$begintime=date("Y-m-d H:i:s",mktime(0,0,0,date('m'),date('d'),date('Y')));$endtime=date("Y-m-d H:i:s",mktime(0,0,0,date('m'),date('d')+1,date('Y'))-1);$where=array('points'=>'5',
'user_id'=>$userid,
'createtime' => array(array('gt',$begintime),array('lt',$endtime)),);$res=$points->where($where)->order("createtime desc")->select();//var_dump($res['0']['points']);
$this->assign('res',$res);
复制代码5.查询积分:
复制代码/*查询积分*/
$jfen=M(cuser);$list=$jfen->where(array('id'=>$userid))->field('points')->find();$preg = '/[0]*/';$poin = preg_replace($preg, '', $list, 1);$this->assign('poin',$poin);
复制代码6.签到写入数据库:
复制代码/*签到*/
if(IS_AJAX){$userid=session('user.id');$type='签到';$typename='checkin';$id_status='up';$date=Date('Y-m-d H:i:s');$dataList=array('user_id'=>$userid,
'type'=>$type,
'typename'=>$typename,
'id_status'=>$id_status,
'points'=>'5',
'createtime'=>$date,
'remark'=>'奖励5积分');$points = M('points_log');if($points->add($dataList)){$log=session('user.id');$user=M('cuser');$user->where(array('id'=>$log))->setInc('points',5);
}$this->ajaxReturn($status);
}
复制代码7. /*查询本月签到天数,并以json格式返回*/复制代码public functionMonthSign(){$userid=session('user.id');$points = M('points_log');$res=$points->where(array('user_id'=>$userid))->select();$sign='[';foreach($res as $key=>$value){$first=explode(' ', $value['createtime']);$second=explode('-', $first['0'])['2'];if($key==0){$sign .= '{"signDay":"'.$second.'"}';
}else{$sign .= ',{"signDay":"'.$second.'"}';
}
}$sign .=']';$this->ajaxReturn($sign,'json');
}
复制代码