php mysql ajax日历记事本_php+mysql+jquery日历签到

news/2024/7/5 2:09:45

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

");return htmls.join('');

}

};

复制代码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');

}

复制代码


http://lihuaxi.xjx100.cn/news/241452.html

相关文章

云计算重构渠道商的价值基础,推动渠道商向服务商转型

第九届中国软件渠道大会暨2016中国软件生态大会将于3月29日在武汉开启首站。会议召开在即&#xff0c;中国软件网联合海比研究推出“中国软件渠道商系列访谈”&#xff0c;对转型中的软件渠道商面临的挑战与机遇、心得体会&#xff0c;以及面对来势汹汹生态力量的感受展开探讨。…

数据可视化工具

BDP BDP是一个商业化的可视化Web工具&#xff0c;提供免费的功能试用&#xff0c;有很多产品设计可以借鉴&#xff0c;主要功能有&#xff1a; 可以通过拖拽指标和维度来创建报表支持维度对比支持丰富的图表支持层级的上卷和下钻配置筛选项和数据过滤定制dashboard可以设置预警…

linux resin mysql_Linux下Resin JSP MySQL的安装和配置-2

如果有,陆续(2)编辑httpd.conf# vi /usr/local/apache2/conf/httpd.conf找到ResinConfigServer localhost 6802确信其内容为:LoadModule caucho_module /usr/local/apache2/modules/mod_caucho.soResinConfigServer 192.168.1.109 6802 //即改localhost为你的计算机的实际IPCa…

(C++)1046 Shortest Distance

#include<cstdio> #include<cstring> #include<cmath> #include<algorithm> using namespace std;int friendDis[100010] {0};//邻居节点间的距离 int withStDis[100010] {0};//和第一个结点的距离 --本题的题眼&#xff0c;空间换时间的典例int ma…

elasticsearch-.yml(中文配置详解)

此elasticsearch-.yml配置文件&#xff0c;是在$ES_HOME/config/下 elasticsearch-.yml&#xff08;中文配置详解&#xff09; # Elasticsearch Configuration ## NOTE: Elasticsearch comes with reasonable defaults for most settings.# Before you set out to tweak and t…

操作系统知识点总结

操作系统的基本特征 并发&#xff1a;同一段时间内多个程序执行(注意区别并发和并行&#xff0c;后者者是同一时刻的多个事件&#xff0c;前者是同一时间间隔内的多个事件)共享&#xff1a;系统中的资源可以被内存中多个并发执行的进线程共同使用虚拟&#xff1a;通过时分复用&…

Elasticsearch的前后台运行与停止(rpm包方式)

对应&#xff0c;这es的下载&#xff0c;需要rpm包。 Elasticsearch-2.4.3的下载&#xff08;图文详解&#xff09; 建议用root用户 [rootdjt002 elasticsearch-2.4.3]$ pwd/usr/local/elasticsearch/elasticsearch-2.4.3 [rootdjt002 elasticsearch-2.4.3]$ rpm -ivh elastic…

mysql 自动管理内存_MySQL内存管理,内存分配器和操作系统

导读作者&#xff1a;Sveta Smirnova翻译&#xff1a;郑志江校对&#xff1a;徐晨亮原文 &#xff1a;MySQL Memory Management, Memory Allocators and Operating System本文涉及链接在文末展示当用户使用任何软件(包括MySQL)碰到内存问题时&#xff0c;我们第一反应就是内存泄…