Beispiel #1
0
 public function setOrderCredit($openid, $id, $minus = true, $remark = '')
 {
     $order = mysqld_select("SELECT * FROM " . table('shop_order') . " WHERE id=:id", array(":id" => $id));
     if (!empty($order['credit'])) {
         if ($minus) {
             member_credit($openid, $order['credit'], 'addcredit', $remark);
         } else {
             member_credit($openid, $order['credit'], 'usecredit', $remark);
         }
     }
 }
Beispiel #2
0
<?php

$op = $_GP['op'];
if ($op == 'credit') {
    $condition = "  (`type`='usecredit' or `type`='addcredit')";
}
if ($op == 'gold') {
    $condition = " (`type`='usegold' or `type`='addgold')";
}
$member = mysqld_select("SELECT * FROM " . table('member') . " where openid=:openid ", array(':openid' => $_GP['openid']));
$list = mysqld_selectall("SELECT * FROM " . table('member_paylog') . " where openid=:openid  and {$condition} order by createtime desc", array(':openid' => $_GP['openid']));
if (checksubmit('submit')) {
    if (!is_numeric($_GP['fee']) || $_GP['fee'] < 0) {
        message("输入的数字非法请重新输入");
    }
    if (!empty($member['openid'])) {
        if ($op == 'credit') {
            member_credit($_GP['openid'], $_GP['fee'], 'addcredit', $_GP['remark']);
            message('积分充值成功', 'refresh', 'success');
        }
        if ($op == 'gold') {
            member_gold($_GP['openid'], $_GP['fee'], 'addgold', $_GP['remark']);
            message('余额充值成功', 'refresh', 'success');
        }
    }
}
include page($op);
Beispiel #3
0
    }
    if (empty($_GP['third_login'])) {
        if (empty($_GP['pwd'])) {
            message("请输入密码!");
        }
        $pwd = md5($_GP['pwd']);
    } else {
        $pwd = '';
    }
    $shop_regcredit = intval($cfg['shop_regcredit']);
    $openid = date("YmdH", time()) . rand(100, 999);
    $hasmember = mysqld_select("SELECT * FROM " . table('member') . " WHERE openid = :openid ", array(':openid' => $openid));
    if (!empty($hasmember['openid'])) {
        $openid = date("YmdH", time()) . rand(100, 999);
    }
    $data = array('mobile' => $_GP['mobile'], 'pwd' => $pwd, 'createtime' => time(), 'status' => 1, 'istemplate' => 0, 'experience' => 0, 'openid' => $openid);
    mysqld_insert('member', $data);
    if (!empty($shop_regcredit)) {
        member_credit($openid, $shop_regcredit, "addcredit", "注册系统赠送积分");
    }
    $member = get_session_account();
    $oldsessionid = $member['openid'];
    $loginid = save_member_login('', $openid);
    integration_session_account($loginid, $oldsessionid);
    message('注册成功!', to_member_loginfromurl(), 'success');
}
$qqlogin = mysqld_select("SELECT * FROM " . table('thirdlogin') . " WHERE enabled=1 and `code`='qq'");
if (!empty($qqlogin) && !empty($qqlogin['id'])) {
    $showqqlogin = true;
}
include themePage('regedit');
Beispiel #4
0
 public function do_getaward()
 {
     $xc_zjp = mysqld_select("SELECT * FROM " . table('xc_zjp_reply'));
     $member = get_member_account(true, intval($xc_zjp['needreg']) == 1);
     $openid = $member['openid'];
     if (empty($openid)) {
         message('非法访问,请重新发送消息进入抽奖页面!');
     }
     $member = member_get($openid);
     if (empty($xc_zjp)) {
         message('非法访问,请重新发送消息进入抽奖页面!');
     }
     $result = array('status' => -1, 'message' => '');
     $total = mysqld_selectcolumn("SELECT COUNT(*) FROM " . table('xc_zjp_winner') . " WHERE  open_id = '{$openid}' and TO_DAYS(NOW())-TO_DAYS(FROM_UNIXTIME(createtime))<= " . $xc_zjp["periodlottery"]);
     $myuser = mysqld_select("SELECT * FROM " . table('xc_zjp_user') . " WHERE  open_id = '{$openid}' ");
     $friendcount = 0;
     $arr_times = $this->get_today_times($total, $xc_zjp['maxlottery'], $friendcount);
     $result['useCount'] = false;
     $useCredit = false;
     if ($arr_times['today_has'] <= 0) {
         if (!empty($xc_zjp['basenum']) && $xc_zjp['basenum'] < $member['credit']) {
             $useCredit = true;
         }
     }
     if ($arr_times['today_has'] <= 0) {
         if (empty($xc_zjp['basenum']) || !empty($xc_zjp['basenum']) && $xc_zjp['basenum'] > $member['credit']) {
             $result['nochance'] = $arr_times['today_has'];
             $result['message'] = '抽奖机会已用完!';
             $vars = array();
             $vars['message'] = $result;
             $vars['redirect'] = refresh();
             $vars['type'] = 'ajax';
             exit(json_encode($vars));
         }
     }
     $result['surplusCount'] = $arr_times['today_has'] - 1 < 0 ? -1 : $arr_times['today_has'] - 1;
     if (!empty($xc_zjp['basenum'])) {
         $result['useCredit1'] = $xc_zjp['basenum'];
         $result['surplusCredit1'] = $member['credit'] - $xc_zjp['basenum'] < 0 ? 0 : $member['credit'] - $xc_zjp['basenum'];
     } else {
         $result['useCredit1'] = 0;
         $result['surplusCredit1'] = 0;
     }
     $result['useCount'] = true;
     $gifts = mysqld_selectall("SELECT * FROM " . table('xc_zjp_award') . " WHERE  total>0 ORDER BY probalilty ASC");
     //计算每个礼物的概率
     $probability = 0;
     $rate = 1;
     $award = array();
     foreach ($gifts as $name => $gift) {
         if (empty($gift['probalilty'])) {
             continue;
         }
         if ($gift['probalilty'] < 1) {
             $temp = explode('.', $gift['probalilty']);
             $temp = pow(10, strlen($temp[1]));
             $rate = $temp < $rate ? $rate : $temp;
         }
         $probability = $probability + $gift['probalilty'] * $rate;
         $award[] = array('id' => $gift['id'], 'probalilty' => $probability);
     }
     $all = 100 * $rate;
     if ($probability < $all) {
         $award[] = array('title' => '', 'probalilty' => $all);
     }
     mt_srand((double) microtime() * 1000000);
     $rand = mt_rand(1, $all);
     foreach ($award as $key => $gift) {
         if (isset($award[$key - 1])) {
             if ($rand > $award[$key - 1]['probalilty'] && $rand <= $gift['probalilty']) {
                 $awardid = $gift['id'];
                 break;
             }
         } else {
             if ($rand > 0 && $rand <= $gift['probalilty']) {
                 $awardid = $gift['id'];
                 break;
             }
         }
     }
     $title = '';
     $result['hasPrize'] = false;
     $result['message'] = '很遗憾,您没能中奖!';
     $data = array('open_id' => $openid, 'status' => 0, 'createtime' => TIMESTAMP);
     $credit = array('award' => (empty($awardid) ? '未' : '') . '中奖', 'open_id' => $openid, 'status' => 3, 'description' => empty($awardid) ? $xc_zjp['misscredit'] : $xc_zjp['hitcredit'], 'createtime' => TIMESTAMP);
     if (!empty($awardid)) {
         $gift = mysqld_select("SELECT * FROM " . table('xc_zjp_award') . " WHERE id = '{$awardid}'");
         if ($gift['total'] > 0) {
             $data['award'] = $gift['title'];
             $result['gift'] = $gift['title'];
             $result['giftimg'] = $gift['description'];
             $result['hasPrize'] = true;
             mysqld_query("UPDATE " . table('xc_zjp_award') . " SET total = total - 1 WHERE  id = '{$awardid}'");
             $data['description'] = '';
             $result['message'] = '恭喜您,得到“' . $data['award'] . '”!' . $desss;
             $result['status'] = 0;
         } else {
             $credit['description'] = $xc_zjp['misscredit'];
         }
         $data['gifturl'] = $gift['description'];
         $data['description'] = $gift['title'];
     }
     if ($useCredit) {
         member_credit($openid, intval($xc_zjp['basenum']), 'usecredit', '抓奖品消费积分');
     }
     if (empty($_SESSION['cachetime']) || $_SESSION['cachetime'] < time()) {
         $_SESSION['cachetime'] = time() + 3;
         mysqld_insert('xc_zjp_winner', $data);
     }
     $result['myaward'] = mysqld_selectall("SELECT * FROM " . table('xc_zjp_winner') . " WHERE open_id = '{$openid}'   AND award <> '' ORDER BY createtime DESC");
     $mycredit = mysqld_selectcolumn("SELECT SUM(description) FROM " . table('xc_zjp_winner') . " WHERE open_id = '{$openid}'   AND award <> '' ");
     $result['credit'] = $mycredit;
     $result['credit'] = !empty($result['credit']) ? $result['credit'] : '0';
     $vars = array();
     $vars['message'] = $result;
     $vars['redirect'] = refresh();
     $vars['type'] = 'ajax';
     exit(json_encode($vars));
 }
Beispiel #5
0
}
if ($award_info['amount'] <= 0) {
    message("该商品已兑换完。");
}
$setting = mysqld_select("SELECT * FROM " . table('addon7_config'));
$request_info = mysqld_select("SELECT * FROM " . table('addon7_request') . " where openid=:openid order by id desc limit 1", array(":openid" => $openid));
$address = $request_info['address'];
$mobile = $request_info['mobile'];
$realname = $request_info['realname'];
if (empty($realname)) {
    $realname = $member['realname'];
}
if (empty($mobile)) {
    $mobile = $member['mobile'];
}
if (checksubmit("submit")) {
    $award_info = mysqld_select("SELECT * FROM " . table('addon7_award') . " where id=:id", array(":id" => intval($_GP['award_id'])));
    if (!empty($award_info['id'])) {
        if ($award_info['awardtype'] == 1) {
            member_credit($openid, $award_info['credit_cost'], 'usecredit', '积分兑换消费积分,兑换id:' . intval($_GP['award_id']));
            member_gold($openid, $award_info['gold'], 'addgold', $award_info['credit_cost'] . '积分兑换' . $award_info['gold'] . '余额,兑换id:' . intval($_GP['award_id']));
            message('提交成功', mobile_url('index'), 'success');
        } else {
            $insert = array('openid' => $openid, 'realname' => $_GP['realname'], 'mobile' => $_GP['mobile'], 'status' => 0, 'address' => $_GP['address'], 'createtime' => time(), "award_id" => intval($_GP['award_id']));
            member_credit($openid, $award_info['credit_cost'], 'usecredit', '积分兑换消费积分,兑换id:' . intval($_GP['award_id']));
            mysqld_insert('addon7_request', $insert);
            message('提交成功', mobile_url('index'), 'success');
        }
    }
}
include addons_page('useaward');