foreach ($coupon['data'] as &$value) { $value['cototal'] = pdo_fetchcolumn('SELECT COUNT(*) FROM ' . tablename('activity_coupon_record') . ' WHERE uid = :uid AND couponid = :couponid AND status = :status', array(':uid' => $_W['member']['uid'], ':couponid' => $value['couponid'], ':status' => $type)); $value['thumb'] = tomedia($value['thumb']); $value['description'] = htmlspecialchars_decode($value['description']); $data[$value['couponid']] = $value; } } unset($coupon); $pager = pagination(count($total), $pindex, $psize); } if ($do == 'use') { $id = intval($_GPC['id']); $data = activity_token_owned($_W['member']['uid'], array('couponid' => $id, 'used' => 1)); $data = $data['data'][0]; if (checksubmit('submit')) { load()->model('user'); $password = $_GPC['password']; $sql = 'SELECT * FROM ' . tablename('activity_coupon_password') . " WHERE `uniacid` = :uniacid AND `password` = :password"; $clerk = pdo_fetch($sql, array(':uniacid' => $_W['uniacid'], ':password' => $password)); if (!empty($clerk)) { $status = activity_token_use($_W['member']['uid'], $id, $clerk['name']); if (!is_error($status)) { message('代金券使用成功!', url('activity/token/mine', array('type' => $_GPC['type'])), 'success'); } else { message($status['message'], url('activity/token/mine', array('type' => $_GPC['type'])), 'error'); } } message('密码错误!', referer(), 'error'); } } template('activity/token');
message('代金券删除成功!', url('activity/token/display'), 'success'); } if ($do == 'record') { if (checksubmit('submit')) { $password = $_GPC['password']; if (empty($password)) { message('店员密码不能为空'); } $couponid = intval($_GPC['couponid']); $uid = intval($_GPC['uid']); $recid = intval($_GPC['recid']); $sql = 'SELECT * FROM ' . tablename('activity_coupon_password') . " WHERE `uniacid` = :uniacid AND `password` = :password"; $clerk = pdo_fetch($sql, array(':uniacid' => $_W['uniacid'], ':password' => $password)); if (!empty($clerk)) { load()->model('activity'); $status = activity_token_use($uid, $couponid, $clerk['name'], $recid); if (!is_error($status)) { message('折扣券使用成功!', referer(), 'success'); } else { message($status['message'], referer(), 'error'); } } message('店员密码错误!', referer(), 'error'); } load()->func('tpl'); $modules = uni_modules(); $coupons = pdo_fetchall('SELECT couponid, title FROM ' . tablename('activity_coupon') . ' WHERE uniacid = :uniacid AND type = 2 ORDER BY couponid DESC', array(':uniacid' => $_W['uniacid']), 'couponid'); $starttime = empty($_GPC['time']['start']) ? strtotime('-1 month') : strtotime($_GPC['time']['start']); $endtime = empty($_GPC['time']['end']) ? TIMESTAMP : strtotime($_GPC['time']['end']) + 86399; $where = " WHERE a.uniacid = {$_W['uniacid']} AND b.type = 2 AND a.granttime>=:starttime AND a.granttime<:endtime"; $params = array(':starttime' => $starttime, ':endtime' => $endtime);