public function getCoupon()
{
$CouponRecordTable = new Model_ApplistCouponRecord();
$CouponListTable = new Model_ApplistCouponList();
$cfromuser = $this->fromuser;
$customer_id = $this->customer_id;
//搜索条件
$filter['where'] = " customer_id='{$customer_id}' and state='1' ";
$sql = $CouponListTable->select($filter);
//解析结果集
$couponInfo = $CouponListTable->fetchRow($sql);
$filter['where'] = "fromuser='******' and pid='{$couponInfo['id']}'";
$times = $CouponRecordTable->count($filter);
//如果领取次数未满
if ($couponInfo && $couponInfo['end_date'] > date("Y-m-d") && $times < $couponInfo['times'] && $couponInfo['stock'] > $couponInfo['use_num']) {
//插入领取成功记录
$data['pid'] = (int) $couponInfo['id'];
$data['end_date'] = $couponInfo['end_date'];
$data['state'] = 2;
$data['customer_id'] = $customer_id;
$data['fromuser'] = $cfromuser;
$data['create_date'] = date("Y-m-d H:i:s");
$data['coupon_name'] = str_inmysql($couponInfo['denomination']);
$memberTable = new Model_Member();
$nickname = $memberTable->fetchRow("select nickname from member where fromuser='******' and customer_id='{$customer_id}'");
$data['nickname'] = $nickname['nickname'];
$id = $CouponRecordTable->upsert($data);
$CouponListTable->query("update applist_coupon_list set use_num=use_num+1 where id='{$couponInfo['id']}' and customer_id='{$customer_id}'");
//获取优惠券 规则信息 返回微信单图文格式
$CouponTable = new Model_ApplistCoupon();
$info = $CouponTable->fetchRow("select * from applist_coupon where customer_id='{$customer_id}'");
//返回微信数据
$data['msgtype'] = 'news';
$data['title'] = $info['title'];
$data['description'] = $info['info'];
$data['picurl'] = 'http://' . $_SERVER['HTTP_HOST'] . "/data/image_c/" . $info['pic'];
$data['url'] = 'http://' . $_SERVER['HTTP_HOST'] . "/mobile/coupon/index.php?id=" . $id . "&pid=" . $data['pid'] . "&fromuser="******"&sign=" . $this->timesign;
return $data;
} else {
$data['msgtype'] = "text";
$data['content'] = $couponInfo['cue'];
return $data;
}
}
$y = $_POST['year'];
$today = $_POST['year'] . '-' . $_POST['month'] . '-' . date('j', mktime(0, 0, 1, $m == 12 ? 1 : $m + 1, 1, $m == 12 ? $y + 1 : $y) - 24 * 3600);
//echo $d=die();
$and = " and left(create_date,10)<='{$today}'";
$start_date = $today = $_POST['year'] . '-' . $_POST['month'] . '-01';
$smarty->assign('mon', $m);
$smarty->assign('yea', $y);
} else {
$today = date("Y-m-d");
$start_date = date('Y-m-d', strtotime('-29 day'));
/* $smarty->assign('mon',date('m'));
$smarty->assign('yea',date('Y')); */
}
$and = isset($and) ? $and : '';
$member = new Model_Member();
$data = $member->fetchRow("select * from member where customer_id={$customer_id} and fromuser='******'");
$smarty->assign("list", $data);
$message = new Model_Message();
$result = $message->fetchAll("select msg_content,create_date from message where customer_id='{$customer_id}' and fromuser='******'");
if ($result) {
//互动关键字和日期
$smarty->assign('Interactive_recording', $result);
}
//最近30天互动量
$filter['where'] = "customer_id='{$customer_id}' and fromuser='******' and left(create_date,10)>='{$start_date}'{$and}";
$filter['group'] = " left(create_date,10) ";
$sql = $message->select($filter, 'count(id) as count_num,left(create_date,10) as count_date');
$messagearray = $message->fetchAll($sql);
foreach ($messagearray as $key => $row) {
$countinfoc[$row['count_date']] = $row['count_num'];
if ($row['count_date'] == $today) {
private function getMemDetail()
{
global $_WGT;
$memberModel = new Model_Member();
$rowMem2 = array();
//是否有权限获取信息
//if(in_array($this->customer_id,$_WGT['Authen_customer_id'])){
$sql = "select id,nickname from member where customer_id='" . $this->customer_id . "' and fromuser='******'FromUserName'] . "'";
$meminfo = $memberModel->fetchRow($sql);
if (!$meminfo || $meminfo['nickname'] == '') {
$rowMem2 = $this->getMeminfo($this->post_data['FromUserName']);
}
//}
return $rowMem2;
}
