Exemple #1
0
        message('更改卡券领取状态成功', referer(), 'success');
    }
    if ($op == 'consume') {
        $id = intval($_GPC['id']);
        $record = pdo_fetch('SELECT code,status FROM ' . tablename('coupon_record') . ' WHERE acid = :acid AND id = :id', array(':acid' => $acid, ':id' => $id));
        if (empty($record)) {
            message('对应code码不存在', referer(), 'error');
        }
        $pwd = trim($_GPC['pdw']);
        if (empty($pwd)) {
            message('请输入店员密码', referer(), 'error');
        }
        $sql = 'SELECT * FROM ' . tablename('activity_coupon_password') . " WHERE `uniacid` = :uniacid AND `password` = :password";
        $clerk = pdo_fetch($sql, array(':uniacid' => $_W['uniacid'], ':password' => $pwd));
        if (empty($clerk)) {
            message('店员密码错误', referer(), 'error');
        }
        if ($record['status'] == 1) {
            load()->classs('coupon');
            $acc = new coupon($acid);
            $status = $acc->ConsumeCode(array('code' => $record['code']));
            if (is_error($status)) {
                message($status['message'], '', 'error');
            } else {
                pdo_update('coupon_record', array('status' => 3, 'clerk_name' => $clerk['name'], 'usetime' => TIMESTAMP), array('acid' => $acid, 'code' => $record['code'], 'id' => $id));
            }
        }
        message('核销卡券成功', referer(), 'success');
    }
    template('wechat/consume');
}
Exemple #2
0
defined('IN_IA') or exit('Access Denied');
if (!empty($_W['uniacid'])) {
    $sql = 'SELECT * FROM ' . tablename('core_queue') . ' WHERE `uniacid`=:uniacid AND type = 2 ORDER BY `qid` ASC LIMIT 15';
    $pars = array();
    $pars[':uniacid'] = $_W['uniacid'];
    $cards = pdo_fetchall($sql, $pars);
    if (!empty($cards)) {
        load()->classs('coupon');
        foreach ($cards as $li) {
            if (!empty($li['acid']) && !empty($li['message'])) {
                $acc = new coupon($li['acid']);
                $code = $acc->DecryptCode(array('encrypt_code' => $li['message']));
                if (is_error($code)) {
                    continue;
                } else {
                    $sumecode = $acc->ConsumeCode(array('code' => $code['code']));
                    if (is_error($sumecode)) {
                        continue;
                    } else {
                        pdo_delete('core_queue', array('uniacid' => $_W['uniacid'], 'id' => $li['id']));
                        pdo_update('coupon_record', array('status' => 3), array('acid' => $li['acid'], 'code' => $code['code'], 'card_id' => $li['params']));
                    }
                }
            }
        }
    }
    $sql = 'SELECT * FROM ' . tablename('core_queue') . ' WHERE `uniacid`=:uniacid AND type = 1 ORDER BY `qid` ASC LIMIT 50';
    $pars = array();
    $pars[':uniacid'] = $_W['uniacid'];
    $messages = pdo_fetchall($sql, $pars);
    if (!empty($messages)) {