yuyue/Modules/Home/Controller/GroupdoController.class.php

<?php
/**
 * lionfish 商城系统
 *
 * ==========================================================================
 * @link      http://www.liofis.com/
 * @copyright Copyright (c) 2015 liofis.com. 
 * @license   http://www.liofis.com/license.html License
 * ==========================================================================
 * 拼团模块
 * @author    fish
 *
 */
namespace Home\Controller;

class GroupdoController extends CommonController {
	
	 protected function _initialize()
    {
		
    	parent::_initialize();
       
    }
	
	public function get_goods_detail() {
		
		$_GPC = I('request.');
		
		$id = $_GPC['id'];
		$pin_id = isset($_GPC['pin_id']) ? $_GPC['pin_id'] : 0;
		$token = $_GPC['token'];
		
		$weprogram_token = M('lionfish_comshop_weprogram_token')->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(
            "<br/>"
        );
        $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(
				"<br/>"
			);
			$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();

		}

	}
	
	
}