<?php /** * Created by PhpStorm. * User: jianlinz * Date: 2015/7/3 * Time: 11:33 */ include_once "config.php"; include_once "wechat.class.php"; include_once "wx_iot.class.php"; header("Content-type:text/html;charset=utf-8"); $db = new class_mysql_db(); $result = $db->db_EmcAccumulationInfo_save("aaa", "bbb"); ?> $a = '2015-05-19'; $b = strtotime($a); $c = date("ymd", $b); $tmp = 1455629400; $res = $db->db_EmcDataInfo_save("aaa", "bbb", $tmp, 155, 42433); $tmp = 1435629400; $res = $db->db_EmcDataInfo_save("aaa", "bbb", $tmp, 155, 42433); $res = $db->db_EmcDataInfo_delete_3monold("aaa", "bbb", 80); $t1 = date("ymd"); $t2 = date_create('2009-10-13');
public function L3_device_text_process($content, $fromuser, $deviceid) { //反系列化处理 $rev = $this->L3_msgParse($content); //进入不同数据内容处理阶段 $cmdid = ""; $resp = $rev["body"]; switch ($rev["head"]["head_cmdid"]) { case "CMDID_EMC_DATA_REQ": //取得数据结构体 $emc_value = hexdec(substr($rev["body"], 0, 4)) & 0xffff; $emc_time = hexdec(substr($rev["body"], 0, 4)) & 0xffff; //存入数据库中 $wxDbObj = new class_mysql_db(); $wxDbObj->db_EmcDataInfo_save($fromuser, $deviceid, $emc_time, $emc_value, 0); //GPS not yet exist today, could be add in future. $wxDbObj->db_EmcDataInfo_delete_3monold($fromuser, $deviceid, 90); //remove 90 days old data. $wxDbObj->db_EmcAccumulationInfo_save($fromuser, $deviceid); //累计值计算,如果不是初次接收数据,而且日期没有改变,则该过程将非常快 $cmdid = CMDID_EMC_DATA_RESP; $resp = ""; break; case "CMDID_EMC_DATA_REV": //不需要再回复消息,再考虑设计下这个工作流程设计 $cmdid = CMDID_SEND_TEXT_RESP; break; case "CMDID_OCH_DATA_REQ": $cmdid = CMDID_OCH_DATA_RESP; break; default: $cmdid = CMDID_SEND_TEXT_RESP; break; } //再进入真正的处理阶段, 系列化 $result = $this->L3_msgBuild($cmdid, $resp, $rev["head"]["head_seq"]); return $result; }