field('member_id')->where( array('token' => $token) )->find(); $member_id = $weprogram_token['member_id']; $pintuan_model_buy = D('Home/Front')->get_config_by_name('pintuan_model_buy'); if( empty($pintuan_model_buy) || $pintuan_model_buy ==0 ) { $pintuan_model_buy = 0; } //团长休息 $community_id = $_GPC['community_id']; $is_comunity_rest = D('Seller/Communityhead')->is_community_rest($community_id); $need_data = array(); $sql = "select g.*,gd.content,gd.begin_time,gd.end_time,gd.video,gd.is_take_fullreduction,gd.share_title,gd.quality,gd.pick_up_type,gd.pick_up_modify,gd.one_limit_count,gd.total_limit_count,gd.seven,gd.repair,gd.labelname,gd.share_title,gd.goods_share_image,gd.relative_goods_list,gd.is_show_arrive,gd.diy_arrive_switch,gd.diy_arrive_details from " . C('DB_PREFIX'). "lionfish_comshop_goods as g," . C('DB_PREFIX') . "lionfish_comshop_good_common as gd where g.id=gd.goods_id and g.id=" . $id; $goods_arr = M()->query($sql); $goods = $goods_arr[0]; $goods['goods_id'] = $id; $goods['is_take_fullreduction'] = 0; $goods['is_video'] = 0; $goods['video_size_width'] = 0; $goods['vedio_size_height'] = 0; $goods['video_src'] = ''; if( !empty($goods['goods_share_image']) ) { $goods['goods_share_image'] = tomedia($goods['goods_share_image']); } //video if( !empty($goods['video']) ) { $goods['video'] = tomedia($goods['video']); } $goods['description'] = htmlspecialchars_decode($goods['content']); $qian = array( "\r\n" ); $hou = array( "
" ); $goods['subtitle'] = str_replace($qian, $hou, $goods['subtitle']); $hou = array( "@EOF@" ); $today_time = strtotime( date('Y-m-d').' 00:00:00' ); //pick_up_type //gd.begin_time,gd.end_time, //over_type =0 未开始,over_type =2已结束,over_type =1距结束 $now_time = time(); if($goods['begin_time'] > $now_time) { $goods['over_type'] = 0; }else if( $goods['begin_time'] <= $now_time && $goods['end_time'] > $now_time ){ $goods['over_type'] = 1; }else if($goods['end_time'] < $now_time){ $goods['over_type'] = 2; $goods['end_date'] = date('m/d H:i', $goods['end_time']); } $goods['activity_summary'] = ''; $onegood_image = D('Home/Pingoods')->get_goods_images($id); if( !empty($onegood_image) ) { $goods['image_thumb'] = tomedia($onegood_image['image']); $goods['image'] = tomedia($onegood_image['image']); } $buy_record_arr = D('Home/Frontorder')->get_goods_buy_record($id,9); $goods_image = D('Home/Pingoods')->get_goods_images($id, 10); if (isset($goods_image)) { foreach ($goods_image as $k => $v) { $goods_image[$k]['image'] = tomedia($v['image']); } } $goods['seller_count']+= $goods['sales']; $goods_price_arr = D('Home/Pingoods')->get_goods_price($id, $member_id); $goods['price'] = $goods_price_arr['price']; $goods['danprice'] = $goods_price_arr['danprice']; $price_dol = explode('.', $goods_price_arr['price']); $goods['price_front'] = $price_dol[0]; $goods['price_after'] = $price_dol[1]; $labelname_arr = unserialize( $goods['labelname'] ); $tag_arr = array(); if( !empty($labelname_arr) ) { $goods['tag'] = $labelname_arr; }else{ if( $goods['quality'] == 1) { $tag_arr[] = '正品保证'; } if( $goods['seven'] == 1) { $tag_arr[] = '7天无理由退换'; } if( $goods['repair'] == 1) { $tag_arr[] = '保修'; } $goods['tag'] = $tag_arr; } $goods['fan_image'] = $goods['image']; $one_image = D('Home/Pingoods')->get_goods_images($id, 1); $goods['one_image'] = tomedia($one_image['image']); $pin_info = $goods_price_arr; $pin_goods_info = M('lionfish_comshop_good_pin')->where( array('goods_id' => $id ) )->find(); $user_favgoods = D('Home/Pingoods')->fav_goods_state($id, $member_id); if( !empty($user_favgoods) ) { $goods['favgoods'] = 2; }else{ $goods['favgoods'] = 1; } $price = $goods['danprice']; $lottery_info = array(); $need_data['lottery_info'] = $lottery_info; if(empty($goods['share_title'])) $goods['share_title'] = $pin_info['pin_price'].'元 '.$goods['goodsname']; /** 商品会员折扣begin **/ $is_show_member_disc = 0; $member_disc = 100; /** 商品会员折扣end **/ $goods['memberprice'] = sprintf('%.2f', round( ($goods['danprice'] * $member_disc) / 100 ,2)); $max_get_dan_money = round( ($goods['danprice'] * (100 - $max_member_level['discount']) ) / 100 ,2); $max_get_money = $max_get_dan_money; if(!empty($pin_info)) { $pin_info['member_pin_price'] = sprintf('%.2f',round( ($pin_info['pin_price'] * $member_disc) / 100 ,2)); $max_get_pin_money = round( ($pin_info['pin_price'] * (100 - $max_member_level['discount']) ) / 100 ,2); $max_get_money = $max_get_pin_money; } // 商品角标 $label_id = unserialize($goods['labelname']); if($label_id){ $label_info = D('Home/Pingoods')->get_goods_tags($label_id); if($label_info){ if($label_info['type'] == 1){ $label_info['tagcontent'] = tomedia($label_info['tagcontent']); } else { $label_info['len'] = mb_strlen($label_info['tagcontent'], 'utf-8'); } } $goods['label_info'] = $label_info; } $pintuan_newman_notice = D('Home/Front')->get_config_by_name('pintuan_newman_notice'); if( !empty($pintuan_newman_notice) ) { $pintuan_newman_notice = htmlspecialchars_decode($pintuan_newman_notice); $qian = array( "\r\n" ); $hou = array( "
" ); $pintuan_newman_notice = str_replace($qian, $hou, $pintuan_newman_notice); } $pin_info['is_commiss_tuan'] = $pin_goods_info['is_commiss_tuan']; $pin_info['is_zero_open'] = $pin_goods_info['is_commiss_tuan'] == 1 ? $pin_goods_info['is_zero_open'] : 0; $pin_info['is_newman'] = $pin_goods_info['is_newman']; $pin_info['pintuan_newman_notice'] = $pintuan_newman_notice; $pin_info['commiss_type'] = $pin_goods_info['commiss_type']; $pin_info['commiss_money'] = $pin_goods_info['commiss_money']; //拼团返利开启情况:1、开启,0、关闭 $pin_info['is_pintuan_rebate'] = $pin_goods_info['is_pintuan_rebate']; $need_data['pin_info'] = $pin_info; /** if(!empty($member_id) && $member_id > 0 && $goods[0]['type'] == 'integral') { $member_info = M('member')->field('score')->where( array('member_id' => $member_id) )->find(); if($member_info['score'] < $goods[0]['score']) { $goods[0]['score_enough'] = 0; }else{ $goods[0]['score_enough'] = 1; } } **/ $need_data['member_level_info'] = $member_level_info; $need_data['member_level_list'] = $member_level_list; $need_data['max_member_level'] = $max_member_level; $need_data['max_get_money'] = sprintf('%.2f',$max_get_money); $need_data['max_get_pin_money'] = $max_get_pin_money; $need_data['max_get_dan_money'] = $max_get_dan_money; $need_data['buy_record_arr'] = $buy_record_arr; $need_data['is_show_max_level'] = $is_show_max_level; $goods['actPrice'] = explode('.', $goods['price']); $goods['marketPrice'] = explode('.', $goods['productprice']); ///relative_goods_list member_id $relative_goods_list = array(); unset($goods['relative_goods_list']); $need_data['relative_goods_list'] = $relative_goods_list; $need_data['goods'] = $goods; $need_data['goods_image'] = $goods_image; $need_data['site_name'] = D('Home/Front')->get_config_by_name('shoname'); $need_data['options'] = D('Home/Pingoods')->get_goods_options($id, $member_id); // $goods_model->get_goods_options($id); $order_comment_count = M('lionfish_comshop_order_comment')->where( array('state' => 1, 'goods_id' => $id ) )->count(); $comment_list = array(); if($order_comment_count > 0) { $sql = "select o.*,m.username as name2,m.avatar as avatar2 from ".C('DB_PREFIX')."lionfish_comshop_order_comment as o left join ".C('DB_PREFIX')."lionfish_comshop_member as m on o.member_id=m.member_id where o.state = 1 and o.goods_id = {$id} order by o.add_time desc limit 1"; $comment_list= M()->query($sql); $order_comment_images = array(); foreach($comment_list as $key => $val) { //user_name if( empty($val['user_name']) ) { $val['name'] = $val['name2']; $val['avatar'] = tomedia($val['avatar2']); }else{ $val['name'] = $val['user_name']; $val['avatar'] = tomedia($val['avatar']); } if($val['type'] == 0) { $order_goods_info = M('lionfish_comshop_order_goods')->field('order_goods_id')->where( array('goods_id' => $id,'order_id' => $val['order_id'] ) )->find(); $order_option_info = M('lionfish_comshop_order_option')->field('value')->where( array('order_goods_id' => $order_goods_info['order_goods_id'],'order_id' => $val['order_id'] ) )->select(); $option_arr = array(); foreach($order_option_info as $option) { $option_arr[] = $option['value']; } $option_str = implode(',', $option_arr); }else{ $option_str = ''; } $img_str = unserialize($val['images']); if( !empty($img_str) && $img_str != 'undefined' ) { // $img_str = unserialize($val['images']); $img_list = explode(',', $img_str); $need_img_list = array(); foreach($img_list as $kk => $vv) { if(!empty($vv) ) { $vv = tomedia($vv ); $img_list[$kk] = $vv; $need_img_list[$kk] = $vv; if(count($order_comment_images) <= 4) $order_comment_images[] = $vv; } } $val['images'] = $need_img_list ; } else { $val['images'] = array(); } $val['option_str'] = $option_str; $val['add_time'] = date('Y-m-d', $val['add_time']) ; $comment_list[$key] = $val; } //$this->comment_list = $comment_list; } $need_data['cur_time'] = time(); $need_data['pin_id'] = $pin_id; $need_data['is_show_arrive'] = $goods['is_show_arrive']; $need_data['diy_arrive_switch'] = $goods['diy_arrive_switch']; $need_data['diy_arrive_details'] = $goods['diy_arrive_details']; //团长休息 $goodsdetails_addcart_bg_color = D('Home/Front')->get_config_by_name('goodsdetails_addcart_bg_color'); $goodsdetails_buy_bg_color = D('Home/Front')->get_config_by_name('goodsdetails_buy_bg_color'); $is_close_details_time = D('Home/Front')->get_config_by_name('is_close_details_time'); $pintuan_close_stranger = D('Home/Front')->get_config_by_name('pintuan_close_stranger'); $isopen_community_group_share = D('Home/Front')->get_config_by_name('isopen_community_group_share'); $group_share_info = ''; $is_need_subscript = 0; $need_subscript_template = array(); if( $member_id >0 ) { //'pay_order','send_order','hexiao_success','apply_community','open_tuan','take_tuan','pin_tuansuccess','apply_tixian' $open_tuan_info = M('lionfish_comshop_subscribe')->where( array('member_id' => $member_id, 'type' => 'open_tuan') )->find(); if( empty($open_tuan_info) ) { $weprogram_subtemplate_open_tuan = D('Home/Front')->get_config_by_name('weprogram_subtemplate_open_tuan'); if( !empty($weprogram_subtemplate_open_tuan) ) { $need_subscript_template['open_tuan'] = $weprogram_subtemplate_open_tuan; } } $take_tuan_info = M('lionfish_comshop_subscribe')->where( array('member_id' => $member_id, 'type' => 'take_tuan' ) )->find(); if( empty($take_tuan_info) ) { $weprogram_subtemplate_take_tuan = D('Home/Front')->get_config_by_name('weprogram_subtemplate_take_tuan'); if( !empty($weprogram_subtemplate_take_tuan) ) { $need_subscript_template['take_tuan'] = $weprogram_subtemplate_take_tuan; } } if( !empty($need_subscript_template) ) { $is_need_subscript = 1; } } echo json_encode(array( 'code' => 1, 'comment_list' => $comment_list, 'order_comment_images' => $order_comment_images, 'order_comment_count' => $order_comment_count, 'data' => $need_data, 'is_comunity_rest' => $is_comunity_rest, 'open_man_orderbuy' => $open_man_orderbuy, 'man_orderbuy_money' => $man_orderbuy_money, 'goodsdetails_buy_bg_color' => $goodsdetails_buy_bg_color, 'goodsdetails_addcart_bg_color' => $goodsdetails_addcart_bg_color, 'isopen_community_group_share' => $isopen_community_group_share, 'is_need_subscript' => $is_need_subscript, 'need_subscript_template' => $need_subscript_template, 'group_share_info' => $group_share_info, 'is_close_details_time' => $is_close_details_time, 'pintuan_model_buy' => $pintuan_model_buy, 'pintuan_close_stranger' => $pintuan_close_stranger )); die(); } public function get_goods_fujin_tuan() { $_GPC = I('request.'); $pintuan_model_buy = D('Home/Front')->get_config_by_name('pintuan_model_buy'); if( empty($pintuan_model_buy) ) { $pintuan_model_buy = 0; } $head_id = isset($_GPC['head_id']) ? $_GPC['head_id']:0; $goods_id = $_GPC['goods_id']; $limit = isset($_GPC['limit']) ? $_GPC['limit']:8; $where = ""; if( $pintuan_model_buy == 1 ) { //o.order_id head_id $where .= " and o.head_id = {$head_id} "; } $pintuan_stranger_zero = D('Home/Front')->get_config_by_name('pintuan_stranger_zero'); if( !isset($pintuan_stranger_zero) || $pintuan_stranger_zero == 0 ) { $where .= " and o.type !='ignore' "; } $fujin_sql = "select distinct(p.pin_id) as pin_id,p.need_count,o.order_id,p.end_time,m.username,m.avatar from ".C('DB_PREFIX')."lionfish_comshop_pin as p,".C('DB_PREFIX')."lionfish_comshop_order_goods as og,".C('DB_PREFIX')."lionfish_comshop_pin_order as po, ".C('DB_PREFIX')."lionfish_comshop_order as o,".C('DB_PREFIX')."lionfish_comshop_member as m where p.pin_id = po.pin_id and po.order_id = o.order_id and og.order_id=o.order_id and o.member_id = m.member_id {$where} and o.order_status_id =2 and og.goods_id={$goods_id} and p.end_time>".time()." group by po.pin_id order by p.end_time asc limit {$limit}"; $fujin_countsql = "select distinct(p.pin_id) as pin_id,p.need_count,o.order_id,p.end_time,m.username,m.avatar from ".C('DB_PREFIX')."lionfish_comshop_pin as p,".C('DB_PREFIX')."lionfish_comshop_order_goods as og,".C('DB_PREFIX')."lionfish_comshop_pin_order as po, ".C('DB_PREFIX')."lionfish_comshop_order as o,".C('DB_PREFIX')."lionfish_comshop_member as m where p.pin_id = po.pin_id and po.order_id=o.order_id and og.order_id=o.order_id and o.member_id = m.member_id {$where} and o.order_status_id =2 and og.goods_id={$goods_id} and p.end_time>".time()." group by po.pin_id order by p.end_time asc "; $fujin_tuan_arr_count = M()->query($fujin_countsql ); $fujin_tuan_count = count($fujin_tuan_arr_count); $fujin_tuan = M()->query($fujin_sql); $result = array(); if(!empty($fujin_tuan)) { foreach($fujin_tuan as $pintuan) { $buy_count = $this->get_tuan_buy_count($pintuan['pin_id']); $pintuan['buy_count'] =$buy_count; $pintuan['cur_interface_time'] = time(); $pintuan['re_need_count'] = $pintuan['need_count'] - $buy_count; //shipping_city_id //$pintuan['area_name'] = $area_info['area_name']; $order_id = $pintuan['order_id']; if($buy_count > 0) { //存在进行中的 $result[] = $pintuan; } } } if( empty($result) ) { echo json_encode( array('code' => 1) ); die(); }else{ echo json_encode( array('code' => 0, 'list' => $result, 'count' => $fujin_tuan_count) ); die(); } } /** * 获取拼团已成功购买价数量 */ public function get_tuan_buy_count($pin_id=0) { $buy_count_sql = "select count(o.order_id) as count from ".C('DB_PREFIX')."lionfish_comshop_pin as p,".C('DB_PREFIX')."lionfish_comshop_pin_order as po," .C('DB_PREFIX')."lionfish_comshop_order_goods as og, ".C('DB_PREFIX')."lionfish_comshop_order as o where p.pin_id = po.pin_id and po.order_id=o.order_id and og.order_id = o.order_id and o.order_status_id =2 and p.pin_id={$pin_id} "; $count_tuan_arr = M()->query($buy_count_sql ); return $count_tuan_arr[0]['count']; } function group_info() { $_GPC = I('request.'); $interface_get_time = time(); $token = $_GPC['token']; $order_id = $_GPC['order_id']; $weprogram_token = M('lionfish_comshop_weprogram_token')->field('member_id')->where( array('token' => $token) )->find(); $member_id = $weprogram_token['member_id']; if( empty($member_id) ) { $member_id = 0; } $is_show = 0; //获取拼团商品信息 $order_goods = M('lionfish_comshop_order_goods')->field('name,goods_id,price,total,goods_images,quantity')->where( array('order_id' => $order_id ) )->find(); if(empty($order_goods)) { //未找到 echo json_encode( array('code' =>1) ); die(); } //分享标题为购买价格 //$order_goods['price'] = round($order_goods['price'],2); $order_goods['total'] = round($order_goods['total'],2); $order_info = M('lionfish_comshop_order')->field('member_id,type,head_id')->where( array('order_id' =>$order_id ) )->find(); $good_image = D('Home/Pingoods')->get_goods_images($order_goods['goods_id']); if( !empty($good_image) ) { //$order_goods['goods_images'] = tomedia($good_image['image']); } $goods_info = M('lionfish_comshop_goods')->field('goodsname as name,subtitle,productprice ,seller_count,sales as virtual_count,is_all_sale')->where( array('id' => $order_goods['goods_id'] ) )->find(); $goods_desc = M('lionfish_comshop_good_common')->field('share_title as share_group_title')->where( array('goods_id' => $order_goods['goods_id'] ) )->find(); $goods_info['seller_count'] = $goods_info['seller_count'] + $goods_info['virtual_count']; if( !empty($good_image) ) { $goods_info['goods_images'] = tomedia($good_image['image']); } unset($goods_info['virtual_count']); $pin_order = M('lionfish_comshop_pin_order')->where( array('order_id' => $order_id ) )->find(); //获取拼团信息 $pin_info = M('lionfish_comshop_pin')->where( array('pin_id' =>$pin_order['pin_id'] ) )->find(); $pintuan_isvirs_success = D('Home/Front')->get_config_by_name('pintuan_isvirs_success'); if( !empty($pintuan_isvirs_success) && $pintuan_isvirs_success == 1 && $pin_info['state'] == 0 && $pin_info['end_time'] < time() ) { $res = D('Home/Pin')->jia_over_order( $pin_info['pin_id'] ); $pin_info = M('lionfish_comshop_pin')->where( array('pin_id' =>$pin_order['pin_id'] ) )->find(); } //拼团状态:0进行中, 1成功, 2 已经过期了 if($pin_info['state'] == 0 && $pin_info['end_time'] < time()){ $pin_info['state'] = 2; } if( !empty($pin_info['success_time']) ) { $pin_info['success_time'] = date('Y-m-d H:i:s', $pin_info['success_time']); } $goods_info['pin_count'] = $pin_info['need_count']; $price_arr = D('Home/Pingoods')->get_goods_price($order_goods['goods_id'], $member_id); $goods_info['pinprice'] = $price_arr['price']; //分享标题为规格最低价格 $order_goods['price'] = round($price_arr['price'],2); $goods_info['danprice'] = $price_arr['danprice']; //ims_ $tuanzhang_info = M('lionfish_comshop_member')->field('member_id,username,telephone,avatar')->where( array('member_id' => $pin_info['user_id'] ) )->find(); $pin_order_sql = "select po.add_time,m.member_id,m.username as name,m.telephone,m.avatar from ".C('DB_PREFIX')."lionfish_comshop_pin_order as po,".C('DB_PREFIX')."lionfish_comshop_order as o, ".C('DB_PREFIX')."lionfish_comshop_order_goods as og,".C('DB_PREFIX')."lionfish_comshop_member as m where po.pin_id = ".$pin_info['pin_id']." and o.order_status_id in(1,2,4,6,7,8,9,10,11,14) and og.order_id = po.order_id and o.order_id = po.order_id and o.member_id= m.member_id order by po.add_time asc "; $pin_order_arr = M()->query($pin_order_sql); $me_take_in = 0; foreach($pin_order_arr as $key =>$val) { if($member_id == $val['member_id']) { $me_take_in = 1; } $pin_order_arr[$key] = $val; } //pin_order_arr if( $pin_info['is_jiqi'] == 1 ) { $jiapinorder = M('lionfish_comshop_jiapinorder')->where( array('pin_id' => $pin_info['pin_id'] ) )->order('id asc')->select(); if( !empty($jiapinorder) ) { foreach( $jiapinorder as $vv ) { $tp_arr_info = array(); $tp_arr_info['add_time'] = $vv['addtime']; $tp_arr_info['member_id'] = $vv['id']; $tp_arr_info['name'] = $vv['uname']; $tp_arr_info['telephone'] = $vv['mobile']; $tp_arr_info['avatar'] = tomedia( $vv['avatar']); $pin_order_arr[] = $tp_arr_info ; } } } $is_me = 0; if($order_info['member_id'] == $member_id) { $is_me = 1; } $share_title = "不要错过~我".round($order_goods['price'],2)."元拼了".$goods_info['name']; if(!empty($goods_desc['share_group_title']) ) { $share_title = $goods_desc['share_group_title']; $share_title = str_replace('{pin_price}',round($order_goods['price'],2),$share_title); $share_title = str_replace('{name}',$goods_info['name'],$share_title); } /* 商品规格begin */ /* 商品规格end */ unset( $tuanzhang_info['reg_type'] ); unset( $tuanzhang_info['openid'] ); unset( $tuanzhang_info['we_openid'] ); unset( $tuanzhang_info['bindmobile'] ); unset( $tuanzhang_info['uname'] ); unset( $tuanzhang_info['email'] ); unset( $tuanzhang_info['pwd'] ); unset( $tuanzhang_info['address_id'] ); unset( $tuanzhang_info['share_id'] ); unset( $tuanzhang_info['comsiss_flag'] ); unset( $tuanzhang_info['bind_seller_id'] ); unset( $tuanzhang_info['bind_seller_pickup'] ); unset( $tuanzhang_info['cart'] ); unset( $tuanzhang_info['wishlist'] ); unset( $tuanzhang_info['id_cardreal_name'] ); unset( $tuanzhang_info['id_card'] ); unset( $tuanzhang_info['login_count'] ); unset( $tuanzhang_info['last_login_ip'] ); unset( $tuanzhang_info['last_ip_region'] ); unset( $tuanzhang_info['create_time'] ); unset( $tuanzhang_info['last_login_time'] ); unset( $tuanzhang_info['status'] ); $options = D('Home/Pingoods')->get_goods_options($order_goods['goods_id']); $need_data = array(); $need_data['is_me'] = $is_me; $need_data['goods_info'] = $goods_info; //$need_data['pin_goods'] = $pin_goods; //$need_data['pin_order'] = $pin_order; $need_data['me_take_in'] = $me_take_in; $need_data['share_title'] = $share_title; //$need_data['tuanzhang_info'] = $tuanzhang_info; $need_data['pin_order_arr'] = $pin_order_arr; $need_data['order_goods'] = $order_goods; $need_data['order_id'] = $order_id; $need_data['order_type'] = $order_info['type']; $need_data['community_id'] = $order_info['head_id']; $need_data['group_order_id'] = $group_order_id; $need_data['options'] = $options; $need_data['interface_get_time'] = $interface_get_time; $need_data['member_id'] = $member_id; $need_data['del_count'] = $pin_info['need_count'] - count($pin_order_arr); if( $need_data['del_count'] <= 0 && $pin_info['state'] != 2 ) { $pin_info['state'] = 1; } $need_data['pin_info'] = $pin_info; $pintuan_model_buy = D('Home/Front')->get_config_by_name('pintuan_model_buy'); if( empty($pintuan_model_buy) || $pintuan_model_buy ==0 ) { $pintuan_model_buy = 0; } $need_data['pintuan_model_buy'] = $pintuan_model_buy; $hide_community_change_btn = D('Home/Front')->get_config_by_name('hide_community_change_btn'); $need_data['hide_community_change_btn'] = $hide_community_change_btn; $pintuan_show_community_info = D('Home/Front')->get_config_by_name('pintuan_show_community_info'); $need_data['pintuan_show_community_info'] = $pintuan_show_community_info; $is_need_subscript = 0; $need_subscript_template = array(); if( $member_id >0 ) { $take_tuan_info = M('lionfish_comshop_subscribe')->where( array('member_id' => $member_id, 'type' => 'take_tuan' ) )->find(); if( empty($take_tuan_info) ) { $weprogram_subtemplate_take_tuan = D('Home/Front')->get_config_by_name('weprogram_subtemplate_take_tuan'); if( !empty($weprogram_subtemplate_take_tuan) ) { $need_subscript_template['take_tuan'] = $weprogram_subtemplate_take_tuan; } } if( !empty($need_subscript_template) ) { $is_need_subscript = 1; } } $need_data['is_need_subscript'] = $is_need_subscript; $need_data['need_subscript_template'] = $need_subscript_template; echo json_encode( array('code' =>0, 'data' => $need_data) ); die(); } /*** 获取会员佣金团的收益账户金额 **/ public function get_pincommiss_account_info() { $_GPC = I('request.'); $token = $_GPC['token']; $weprogram_token = M('lionfish_comshop_weprogram_token')->field('member_id')->where( array('token' => $token) )->find(); $member_id = $weprogram_token['member_id']; if( empty($member_id) ) { $member_id = 0; } $member_info = M('lionfish_comshop_member')->where( array('member_id' => $member_id ) )->find(); if( empty($member_info) ) { echo json_encode( array('code' => 1,'msg' => '您未登录') ); die(); } //commission_account($member_id) D('Home/Pin')->commission_account($member_id); $pintuan_commiss = M('lionfish_comshop_pintuan_commiss')->where( array('member_id' => $member_id ) )->find(); //可提现金额 money //待结算金额 ims_lionfish_comshop_pintuan_commiss_order $wait_statements_money = M('lionfish_comshop_pintuan_commiss_order')->where( array('member_id' =>$member_id,'state' => 0 ) )->sum('money'); //已结算金额 has_statements_money $has_statements_money = M('lionfish_comshop_pintuan_commiss_order')->where( array('member_id' =>$member_id,'state' => 1 ) )->sum('money'); //已提现金额 getmoney $pintuan_commiss['wait_statements_money'] = empty($wait_statements_money) ? 0:$wait_statements_money;//待结算金额 $pintuan_commiss['has_statements_money'] = empty($has_statements_money) ? 0 :$has_statements_money;//已结算金额 echo json_encode( array('code' => 0, 'data' => $pintuan_commiss ) ); die(); } /** 获取佣金订单列表 **/ public function listorder_list() { $_GPC = I('request.'); $token = $_GPC['token']; $weprogram_token = M('lionfish_comshop_weprogram_token')->field('member_id')->where( array('token' => $token) )->find(); $member_id = $weprogram_token['member_id']; if( empty($member_id) ) { $member_id = 0; } $member_info = M('lionfish_comshop_member')->where( array('member_id' => $member_id ) )->find(); if( empty($member_info) ) { echo json_encode( array('code' => 1, 'msg' => '会员不存在') ); die(); } $per_page = 6; $page = isset($_GPC['page']) ? $_GPC['page']:1; $offset = ($page - 1) * $per_page; $list = array(); $where = ''; $state = isset($_GPC['state']) ? $_GPC['state']: -1; //state if($state >=0) { $where .= ' and mco.state = '.$state; } $sql = 'select mco.money,mco.addtime,mco.statement_time,mco.state,o.order_id,o.order_num_alias,o.order_status_id, o.order_num_alias,o.total,o.pay_time,o.date_added,og.goods_id,og.quantity,og.name,og.price,og.goods_images,og.order_goods_id,mco.store_id,m.username as uname from ' .C('DB_PREFIX')."lionfish_comshop_pintuan_commiss_order as mco , ".C('DB_PREFIX')."lionfish_comshop_order_goods as og, ".C('DB_PREFIX')."lionfish_comshop_order as o , ".C('DB_PREFIX')."lionfish_comshop_member as m where mco.order_id=og.order_id and mco.order_id = o.order_id and mco.order_goods_id=og.order_goods_id and m.member_id=o.member_id and mco.member_id=".$member_id." {$where} order by mco.id desc limit {$offset},{$per_page}"; $list = M()->query($sql ); $status_arr = D('Seller/Order')->get_order_status_name(); foreach($list as $key =>$val) { $val['total'] = round($val['total'],2); $val['money'] = round($val['money'],2); $val['status_name'] = $status_arr[$val['order_status_id']]; //$val['addtime'] = date('Y-m-d H:i:s', $val['addtime']); unset($val['addtime']); $val['pay_time'] = date('Y-m-d H:i:s', $val['pay_time']); $val['date_added'] = date('Y-m-d H:i:s', $val['date_added']); if( !empty($val['goods_images'])) { if(is_array($goods_images)) { $val['goods_images'] = $val['goods_images']; }else{ $val['goods_images']= tomedia( $val['goods_images'] ); } }else{ $val['goods_images']= ''; } $order_option_list = M('lionfish_comshop_order_option')->where( array('order_goods_id' => $val['order_goods_id'] ) )->select(); foreach($order_option_list as $option) { $val['option_str'][] = $option['value']; } if( !isset($val['option_str']) ) { $val['option_str'] = ''; }else{ $val['option_str'] = implode(',', $val['option_str']); } if( $val['state'] == 1 ) { $val['statement_time'] = date('Y-m-d H:i:s', $val['statement_time']); } $pin_order = M('lionfish_comshop_pin_order')->where( array('order_id' => $val['order_id'] ) )->find(); $pin_info = M('lionfish_comshop_pin')->field('need_count')->where( array('pin_id' => $pin_order['pin_id'] ) )->find(); $val['pin_count'] = $pin_info['need_count']; $list[$key] = $val; } if(empty($list)) { echo json_encode( array('code' => 1) ); die(); }else { echo json_encode( array('code' => 0, 'data' => $list) ); die(); } } /** 获取会员拼团佣金基础数据 **/ public function get_commission_info() { $_GPC = I('request.'); $token = $_GPC['token']; $weprogram_token = M('lionfish_comshop_weprogram_token')->field('member_id')->where( array('token' => $token) )->find(); $member_id = $weprogram_token['member_id']; if( empty($member_id) ) { $member_id = 0; } $member_info = M('lionfish_comshop_member')->where( array('member_id' => $member_id ) )->find(); if( empty($member_info) ) { echo json_encode( array('code' => 1, 'msg' => '会员不存在') ); die(); } //最小提现金额 $commiss_min_tixian_money = D('Home/Front')->get_config_by_name('pintuan_min_tixian_money'); if( empty($commiss_min_tixian_money) ) { $commiss_min_tixian_money = 0; } $commiss_tixian_bili = D('Home/Front')->get_config_by_name('pintuan_tixian_bili'); if( empty($commiss_tixian_bili) ) { $commiss_tixian_bili = 0; } $member_commiss = M('lionfish_comshop_pintuan_commiss')->where( array('member_id' => $member_id ) )->find(); $member_commiss['commiss_min_tixian_money'] = $commiss_min_tixian_money;//最小提现金额, 0标识不限制 $member_commiss['commiss_tixian_bili'] = $commiss_tixian_bili; $member_commiss['total_commiss_money'] = $member_commiss['money'] + $member_commiss['dongmoney'] + $member_commiss['getmoney']; $commiss_tixianway_yuer = D('Home/Front')->get_config_by_name('pintuan_tixianway_yuer'); $commiss_tixianway_weixin = D('Home/Front')->get_config_by_name('pintuan_tixianway_weixin'); $commiss_tixianway_alipay = D('Home/Front')->get_config_by_name('pintuan_tixianway_alipay'); $commiss_tixianway_bank = D('Home/Front')->get_config_by_name('pintuan_tixianway_bank'); $member_commiss['commiss_tixianway_yuer'] = empty($commiss_tixianway_yuer) ? 1 : ($commiss_tixianway_yuer == 2 ? 1:0); $member_commiss['commiss_tixianway_weixin'] = empty($commiss_tixianway_weixin) ? 1 : ($commiss_tixianway_weixin == 2 ? 1:0); $member_commiss['commiss_tixianway_alipay'] = empty($commiss_tixianway_alipay) ? 1 : ($commiss_tixianway_alipay == 2 ? 1:0); $member_commiss['commiss_tixianway_bank'] = empty($commiss_tixianway_bank) ? 1 : ($commiss_tixianway_bank == 2 ? 1:0); //上一微信真实姓名 $last_weixin_realname = ""; $last_weixin_info = M('lionfish_comshop_pintuan_tixian_order')->where( array('member_id' => $member_id, 'type' => 2 ) )->find(); if( !empty($last_weixin_info) ) { $last_weixin_realname = $last_weixin_info['bankusername']; } //上一支付宝账号 $last_alipay_name = ''; $last_alipay_account = ''; $last_alipay_info = M('lionfish_comshop_pintuan_tixian_order')->where( array('member_id' => $member_id, 'type' => 3 ) )->find(); if( !empty($last_alipay_info) ) { $last_alipay_name = $last_alipay_info['bankusername']; $last_alipay_account = $last_alipay_info['bankaccount']; } //上一银行卡信息 $last_bank_bankname = ''; $last_bank_account = ''; $last_bank_name = ''; $last_bank_info = M('lionfish_comshop_pintuan_tixian_order')->where( array('member_id' => $member_id, 'type' => 4 ) )->find(); if( !empty($last_bank_info) ) { $last_bank_bankname = $last_bank_info['bankname']; $last_bank_account = $last_bank_info['bankaccount']; $last_bank_name = $last_bank_info['bankusername']; } $member_commiss['last_weixin_realname'] = $last_weixin_realname; $member_commiss['last_alipay_name'] = $last_alipay_name; $member_commiss['last_alipay_account'] = $last_alipay_account; $member_commiss['last_bank_bankname'] = $last_bank_bankname; $member_commiss['last_bank_account'] = $last_bank_account; $member_commiss['last_bank_name'] = $last_bank_name; $commiss_tixian_publish = D('Home/Front')->get_config_by_name('pintuan_tixian_publish'); $member_commiss['commiss_tixian_publish'] = htmlspecialchars_decode( $commiss_tixian_publish ); $member_commiss['total_money'] = sprintf('%.2f', $member_commiss['money'] + $member_commiss['dongmoney'] + $member_commiss['getmoney']); echo json_encode( array('code' =>0,'data' => $member_commiss) ); die(); } /** 会员拼团佣金提现 提交接口 **/ public function tixian_sub() { $_GPC = I('request.'); $token = $_GPC['token']; $weprogram_token = M('lionfish_comshop_weprogram_token')->field('member_id')->where( array('token' => $token) )->find(); $member_id = $weprogram_token['member_id']; if( empty($member_id) ) { $member_id = 0; } $member_info = M('lionfish_comshop_member')->where( array('member_id' => $member_id ) )->find(); if( empty($member_info) ) { echo json_encode( array('code' => 1, 'msg' => '会员不存在') ); die(); } $result = array('code' => 1,'msg' => '提现失败'); $member_commiss = M('lionfish_comshop_pintuan_commiss')->where( array('member_id' => $member_id ) )->find(); $datas = array(); $datas['money'] = $_GPC['money']; $money = $datas['money'];//I('post.money',0,'floatval'); $type = $_GPC['type'];// 1余额 2 微信 3 支付宝 4 银行 $bankname = isset($_GPC['bankname']) ? $_GPC['bankname'] : ''; //银行名称 $bankaccount = isset($_GPC['bankaccount']) ? $_GPC['bankaccount'] : '';//卡号,支付宝账号 使用该字段 $bankusername = isset($_GPC['bankusername']) ? $_GPC['bankusername'] : '';//持卡人姓名,微信名称,支付宝名称, 使用该字段 $commiss_money_limit = D('Home/Front')->get_config_by_name('pintuan_min_tixian_money'); if(!empty($commiss_money_limit) && $commiss_money_limit >0) { if($member_commiss['money'] < $commiss_money_limit) { $result['msg'] = '佣金满'.$commiss_money_limit.'才能提现'; echo json_encode($result); die(); } } if($money > 0 && $money <= $member_commiss['money']) { //判断提现手续费,+ 判断提现金额免审直接到账 $service_charge = D('Home/Front')->get_config_by_name('pintuan_tixian_bili'); $data = array(); $data['member_id'] = $member_id; $data['money'] = $money; $data['service_charge'] = $service_charge; $data['service_charge_money'] = round( ($money * $service_charge) /100 ,2); $data['state'] = 0; $data['shentime'] = 0; $data['type'] = $type; $data['bankname'] = $bankname; $data['bankaccount'] = $bankaccount; $data['bankusername'] = $bankusername; $data['addtime'] = time(); M('lionfish_comshop_pintuan_tixian_order')->add($data); $com_arr = array(); $com_arr['money'] = $member_commiss['money'] - $money; $com_arr['dongmoney'] = $member_commiss['dongmoney'] + $money; M('lionfish_comshop_pintuan_commiss')->where( array('member_id' => $member_id ) )->setInc('money',-$money); M('lionfish_comshop_pintuan_commiss')->where( array('member_id' => $member_id ) )->setInc('dongmoney',$money); $result['code'] = 0; //commiss_tixian_reviewed 0 , 1 $commiss_tixian_reviewed = D('Home/Front')->get_config_by_name('pintuan_tixian_reviewed'); if(empty($commiss_tixian_reviewed) || $commiss_tixian_reviewed == 0) { //手动 } else if( !empty($commiss_tixian_reviewed) && $commiss_tixian_reviewed == 1 ){ //自动 } } echo json_encode($result); die(); } /** 提现记录 **/ public function tixian_record() { $_GPC = I('request.'); $token = $_GPC['token']; $weprogram_token = M('lionfish_comshop_weprogram_token')->field('member_id')->where( array('token' => $token) )->find(); $member_id = $weprogram_token['member_id']; if( empty($member_id) ) { $member_id = 0; } $member_info = M('lionfish_comshop_member')->where( array('member_id' => $member_id ) )->find(); if( empty($member_info) ) { echo json_encode( array('code' => 1, 'msg' => '会员不存在') ); die(); } $per_page = 10; $page = isset($_GPC['page']) ? $_GPC['page']:1; $offset = ($page - 1) * $per_page; $list = array(); $list = M('lionfish_comshop_pintuan_tixian_order')->where( array('member_id' =>$member_id ) )->order('addtime desc')->limit($offset,$per_page )->select(); foreach($list as $key => $val) { $val['addtime'] = date('Y-m-d H:i', $val['addtime']); $list[$key] = $val; } if( !empty($list) ) { echo json_encode( array('code' =>0, 'data'=>$list) ); die(); }else{ echo json_encode( array('code' => 1) ); die(); } } }