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); } } }
<?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);
} 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');
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)); }
} 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');