Example #1
0
        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');
Example #2
0
    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);