if ($_GPC['type'] == 'used') { $filter['used'] = '2'; $type = 2; } $coupon = activity_coupon_owned($_W['member']['uid'], $filter, $pindex, $psize); $data = $coupon['data']; $total = $coupon['total']; unset($coupon); $pager = pagination($total, $pindex, $psize); } if ($do == 'use') { $id = intval($_GPC['id']); $data = activity_coupon_owned($_W['member']['uid'], array('couponid' => $id, 'used' => 1)); $data = $data['data'][$id]; 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_coupon_use($_W['member']['uid'], $id, $clerk['name'], $clerk['id']); if (!is_error($status)) { message('折扣券使用成功!', url('activity/coupon/mine', array('type' => 'used')), 'success'); } else { message($status['message'], url('activity/coupon/mine', array('type' => $_GPC['type'])), 'error'); } } message('密码错误!', referer(), 'error'); } } template('activity/coupon');
message('折扣券删除成功!', url('activity/coupon/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_coupon_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 = 1 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 = 1 AND a.granttime>=:starttime AND a.granttime<:endtime"; $params = array(':starttime' => $starttime, ':endtime' => $endtime);