public function index()
{
// run_task();
$this->assign('title', '壹圆购物');
$this->assign('pid', 'home');
//自动登录
//home_is_login();
$sdb = M('slide');
$slides = $sdb->select();
$this->assign('slides', $slides);
// 商品分类
$cdb = M('Category');
$categories = $cdb->page(1, 8)->select();
$this->assign('allCategories', $categories);
add_renci();
$this->display();
}
public function index()
{
// run_task();
$this->assign('title', '壹圆购物');
$sdb = M('slide');
$slides = $sdb->select();
$this->assign('slides', $slides);
// 商品分类
$cdb = D('category');
$categories = $cdb->relation(true)->page(1, 6)->select();
$this->assign('allCategories', $categories);
$data = session('wxUserinfo');
$this->assign('data', $data);
// 最新揭晓
$hdb = M('MiaoshaHistory');
// $filter = 'prizeuid is not null and exists(select 0 from yyg_miaosha b where yyg_miaosha_history.gid = b.gid and (yyg_miaosha_history.qishu = b.qishu or yyg_miaosha_history.qishu = b.qishu - 1))';
$zuixins = $hdb->join('left join yyg_member on yyg_member.uid = yyg_miaosha_history.prizeuid')->where($filter)->order('end_time desc')->field(array('yyg_miaosha_history.gid', 'yyg_miaosha_history.title', 'yyg_miaosha_history.thumb', 'yyg_miaosha_history.money', 'yyg_miaosha_history.danjia', 'yyg_miaosha_history.xiangou', 'yyg_miaosha_history.status', 'yyg_miaosha_history.qishu', 'yyg_miaosha_history.canyurenshu', 'yyg_miaosha_history.zongrenshu', 'yyg_miaosha_history.type', 'yyg_miaosha_history.prizeuid', 'IFNULL(NULLIF(yyg_member.username, \'\'), INSERT(yyg_member.mobile,4,4,\'****\'))' => 'username'))->page(1, 10)->select();
$this->assign('zuixins', $zuixins);
// 推荐商品
$gdb = M('miaosha');
$tuijians = $gdb->where('status < 3 and tuijian = 1')->order('time desc')->field('gid,title,thumb,money,danjia,xiangou,status, qishu, canyurenshu, zongrenshu,type')->page(1, 2)->select();
$this->assign('tuijians', $tuijians);
// // 最新揭晓count
// $hdb = M('MiaoshaHistory');
// $jiexiaocount = $hdb->where('jishijiexiao > 0 and to_days(end_time) = to_days(now())')->count();
// $this->assign('jiexiaocount', $jiexiaocount);
$field = 'gid,title,thumb,money,danjia,xiangou, qishu, canyurenshu, zongrenshu,shengyurenshu,type
, if(status < 2 and shengyurenshu = 0, 2, status) status, unix_timestamp() * 1000 now
, unix_timestamp(date_add(time, interval jishijiexiao hour))*1000 end
,unix_timestamp(date_add(lastTime, interval 3 minute))*1000 lasttime';
$remens = $gdb->where('status < 3 and jishijiexiao=0')->order('time desc')->field($field)->page(1, 8)->select();
$this->assign('remens', $remens);
// 他们购买记录
$mmdb = M('MemberMiaosha');
$records = $mmdb->join('yyg_member on yyg_member.uid = yyg_member_miaosha.uid')->join('yyg_miaosha on yyg_miaosha.gid = yyg_member_miaosha.gid and yyg_miaosha.qishu = yyg_member_miaosha.qishu')->field(array('yyg_member_miaosha.id' => 'mid', 'yyg_member_miaosha.uid', 'yyg_member.img', 'yyg_member_miaosha.count', 'yyg_member_miaosha.time', 'IFNULL(NULLIF(yyg_member.username, \'\'), INSERT(yyg_member.mobile,4,4,\'****\'))' => 'username', 'yyg_miaosha.gid', 'yyg_miaosha.thumb', 'yyg_miaosha.title', 'yyg_miaosha.qishu'))->where($mmmap)->order('yyg_member_miaosha.time desc')->page(1, 7)->select();
if (!empty($records)) {
$this->assign('records', $records);
}
add_renci();
$jijiagns = $gdb->where('status < 3 and jishijiexiao>0')->order('time desc')->field($field)->page(1, 8)->select();
// echo $gdb->getLastSql();
$this->assign('jijiagns', $jijiagns);
$this->display();
}
public function chujia($gid, $money)
{
if (home_is_login()) {
$pdb = M('paimai');
$good = $pdb->field('gid,zuigaojia, qipaijia, jiafujia, chujiacishu, status')->find($gid);
$result = array();
$mpdb = M('MemberPaimai');
if (intval($good['status']) < 2) {
// 如果 商品未结束
$zuigaojia = floatval($good['zuigaojia']);
$qipaijia = floatval($good['qipaijia']);
$jiafujia = floatval($good['jiafujia']);
$chujiacishu = intval($good['chujiacishu']);
$money = floatval($money);
$uid = get_temp_uid();
// 检测是否缴纳保证金
$mpmap['gid'] = $good['gid'];
$mpmap['uid'] = $uid;
$mpmap['flag'] = 0;
$record = $mpdb->where($mpmap)->find();
if (!$record) {
$result['status'] = 2;
$result['message'] = '操作异常，请先缴纳保证金';
} else {
if ($money < $zuigaojia + $jiafujia) {
$result['status'] = 3;
$result['message'] = '出价不能低于当前的最高出价与加价幅度之和';
} else {
if ($money < $qipaijia) {
$result['status'] = 4;
$result['message'] = '出价不能低于起拍价';
} else {
$mpdata['uid'] = $uid;
$mpdata['gid'] = $good['gid'];
$mpdata['flag'] = 1;
$mpdata['money'] = $money;
if ($mpdb->add($mpdata)) {
$good['chujiacishu']++;
$good['zuigaojia'] = $money;
$good['chujiazhe'] = $uid;
if ($pdb->save($good)) {
add_renci(1);
$result['status'] = 0;
$result['message'] = '出价成功';
} else {
$result['status'] = 6;
$result['message'] = '出价失败';
}
} else {
$result['status'] = 5;
$result['message'] = '出价失败';
}
}
}
}
} else {
// 已结束
$result['status'] = 1;
$result['message'] = '拍卖已结束';
}
$this->ajaxReturn($result, 'JSON');
}
}
/**
* 结算保证金
*/
private function doPayBaozhengjin($uid, $gid, $third, $money)
{
// $uid = get_temp_uid();
$pdb = M('paimai');
$adb = M('account');
$udb = M('member');
$pmap['gid'] = $gid;
$pmap['status'] = array('lt', 2);
$good = $pdb->where($pmap)->field('gid,baozhengjin, baomingrenshu')->find();
if ($good) {
// 商品还存在，还没结束
// 保存商品状态
$data['gid'] = $gid;
$data['status'] = 1;
// 增加报名人数
$data['baomingrenshu'] = intval($good['baomingrenshu']) + 1;
if ($pdb->save($data) === FALSE) {
return 401;
// 增加报名人数失败
}
// 增加缴纳保证金记录
$mpdb = M('MemberPaimai');
$mpdata['uid'] = $uid;
$mpdata['gid'] = $good['gid'];
$mpdata['flag'] = 0;
$mpdata['money'] = $good['baozhengjin'];
if ($mpdb->add($mpdata) === FALSE) {
return 402;
// 增加保证金纪录失败
}
} else {
if ($third > 0) {
// 商品已结束
// 第三方支付的钱转到余额
// 增加消费记录
$adata = array('uid' => $uid, 'type' => 1, 'third' => $third, 'content' => '退还商品保证金到余额，商品id[' . $gid . ']');
if ($adb->add($adata) == FALSE) {
return 403;
// 增加消费记录失败
}
// 退还个人账户余额
$member = array('money' => array('exp', '`money` + ' . $third));
if ($udb->where(array('uid' => $uid))->save($member) == FALSE) {
return 404;
// 扣除个人余额失败
}
}
}
add_renci(1);
return 0;
}
