shiziyu18/Modules/Home/Controller/CommunityController.class.php

<?php
/**
 * lionfish 商城系统
 *

 *
 * @author    fish
 *
 */
namespace Home\Controller;

class CommunityController extends CommonController {
	
	public function get_member_ziti_order()
	{
		$gpc = I('request.');
		
		
		
		$xq_member_id = $gpc['memberId'];
		
		$token = $gpc['token'];
		
		
		$weprogram_token = M('lionfish_comshop_weprogram_token')->field('member_id')->where( array('token' => $token) )->find();	
		
		$member_id = $weprogram_token['member_id'];
		
	   
					
		$member_info = M('lionfish_comshop_member')->where( array('member_id' => $member_id) )->find();	
		
		if( empty($member_info) )
		{
			echo json_encode( array('code' => 2) );
			die();
		}
		
		$community_info = D('Home/Front')->get_member_community_info($member_id);
		
		
		if( empty($community_info) && $member_info['pickup_id'] > 0  )
		{
			
			$parent_community_info = M('lionfish_comshop_community_pickup_member')->where( array('member_id' =>$member_id ) )->find();
			
			if(!empty($parent_community_info))
			{	
				$community_info = M('lionfish_community_head')->where( array('id' => $parent_community_info['community_id'] ) )->find();		
			}
		}
		
		
		if( empty($community_info) || $community_info['state'] != 1 )
		{
			echo json_encode( array('code' => 2) );
			die();	
		}
		
		$where = ' and o.head_id = '.$community_info['id']." and o.member_id = ".$xq_member_id;
		
		$where .= ' and o.order_status_id = 4 ';
		
		
		$sql = "select o.order_id,o.order_num_alias,o.date_added,o.delivery,o.is_pin,o.is_zhuli,o.shipping_fare,o.voucher_credit,o.store_id,o.total,o.order_status_id,o.lottery_win,o.type,os.name as status_name,o.shipping_name,o.shipping_tel,o.payment_code "
			 . " from ".C('DB_PREFIX')."lionfish_comshop_order as o ,
                ".C('DB_PREFIX')."lionfish_comshop_order_status as os 
	                    where     o.delivery != 'express' and o.delivery != 'hexiao' and o.order_status_id = os.order_status_id {$where}
	                    order by o.date_added desc ";
	  
	    $list =  M()->query($sql);
	   
	    //createTime
	    foreach($list as $key => $val)
	    {
			$val['checked'] = 1;
			if($val['delivery'] == 'pickup')
			{
				//$val['total'] = round($val['total'],2) - round($val['voucher_credit'],2);
			}else{
				//$val['total'] = round($val['total'],2)+round($val['shipping_fare'],2) - round($val['voucher_credit'],2);
			}
	        $val['createTime'] = date('Y-m-d H:i:s', $val['date_added']);
			
			// $val['delivery'] =='pickup'
			
			if($val['shipping_fare']<=0.001 || $val['delivery'] == 'pickup')
			{
				$val['shipping_fare'] = '免运费';
			}else{
				$val['shipping_fare'] = '运费:'.$val['shipping_fare'];
			}
			
			
			if($val['order_status_id'] == 10)
			{
				$val['status_name'] = '等待退款';
			}
			else if($val['order_status_id'] == 4 && $val['delivery'] =='pickup')
			{
				//delivery 6
				$val['status_name'] = '待自提';
				//已自提
			}
			else if($val['order_status_id'] == 6 && $val['delivery'] =='pickup')
			{
				//delivery 6
				$val['status_name'] = '已自提';
				//已自提
			}
			else if($val['order_status_id'] == 1 && $val['type'] == 'lottery')
			{
				//等待开奖
				//一等奖
				if($val['lottery_win'] == 1)
				{
					$val['status_name'] = '一等奖';
				}else {
					$val['status_name'] = '等待开奖';
				}
			}
			else if($val['order_status_id'] == 2 && $val['type'] == 'lottery')
			{
				//等待开奖
				$val['status_name'] = '等待开奖';
			}
			
	        $quantity = 0;
	        $url = D('Home/Front')->get_config_by_name('shop_domain').'/';
			
			
	        $goods_sql = "select order_id,order_goods_id,head_disc,member_disc,level_name,goods_id,is_pin,shipping_fare,name,goods_images,quantity,price,total,rela_goodsoption_valueid,is_refund_state,has_refund_money,has_refund_quantity"
                       . " from ".C('DB_PREFIX')."lionfish_comshop_order_goods where  order_id= ".$val['order_id']."";
	        
	        $goods_list = M()->query($goods_sql); //M()->query($goods_sql);
	        foreach($goods_list as $kk => $vv) 
	        {
	            //commision
				
				if($is_tuanz == 1){
					
					$community_order_info = M('lionfish_community_head_commiss_order')->where( array('head_id' => $community_info['id'],'order_goods_id' => $vv['order_goods_id']) )->find();
					
					
					if(!empty($community_order_info))
					{
						$vv['commision'] = $community_order_info['money'];		
					}else{
						$vv['commision'] = 0;
					}				
							
				}
								
				$order_option_list = M('lionfish_comshop_order_option')->where( array('order_goods_id' => $vv['order_goods_id']) )->select();					
	            
				
				if( !empty($vv['goods_images']))
				{
					
					$goods_images = $url.resize($vv['goods_images'],400,400);
					if(is_array($goods_images))
					{
						$vv['goods_images'] = $vv['goods_images'];
					}else{
						 $vv['goods_images']=  $url.resize($vv['goods_images'],400,400) ; 
					}	
					
				}else{
					 $vv['goods_images']= ''; 
				}
				
 			
				$goods_filed = M('lionfish_comshop_goods')->field('productprice as price')->where( array('id' => $vv['goods_id']) )->find();
			
				$vv['orign_price'] = $goods_filed['price'];
	            $quantity += $vv['quantity'];
	            foreach($order_option_list as $option)
	            {
	                $vv['option_str'][] = $option['value'];
	            }
				if( !isset($vv['option_str']) )
				{
					$vv['option_str'] = '';
				}else{
					$vv['option_str'] = implode(',', $vv['option_str']);
				}
	            $vv['price'] = round($vv['price'],2);
	            $vv['orign_price'] = round($vv['orign_price'],2);
				
	            $vv['checked'] = 1;

                if( $vv['is_refund_state'] == 1 || ($vv['has_refund_money'] > 0 && $vv['has_refund_quantity'] > 0) )
                {
                    $vv['is_refund_state'] = 1;
					$where = " order_id = '".$vv['order_id']."' and order_goods_id = '".$vv['order_goods_id']."' and state in (0,2,3) ";
                    $refund_info = M('lionfish_comshop_order_refund')->field('ref_id,order_id,ref_money,real_refund_quantity,state')->where( $where )->find();
                    if(!empty($refund_info)){
                        $vv['refund_info'] = $refund_info;
                    }else{
                        $refund_info = array();
                        $refund_info['order_id'] = $val['order_id'];
                        $refund_info['ref_money'] = $vv['has_refund_money'];
						$refund_info['real_refund_quantity'] = $vv['has_refund_quantity'];
                        $refund_info['state'] = 3;
                        $vv['refund_info'] = $refund_info;
                    }
                }

	            $goods_list[$kk] = $vv;
	        }
	        $val['quantity'] = $quantity;
	        if( empty($val['store_id']) )
			{
				$val['store_id'] = 1;
			}
			
			
			$store_info	= array('s_true_name' =>'','s_logo' => '');
			
			$store_info['s_true_name'] = D('Home/Front')->get_config_by_name('shoname');
			
			$store_info['s_logo'] = D('Home/Front')->get_config_by_name('shoplogo'); 
			
			
		
			if( !empty($store_info['s_logo']))
			{
				$store_info['s_logo'] = $url .tomedia($store_info['s_logo']);
			}else{
				
				$store_info['s_logo'] = '';
			}
			
			
			$order_goods['store_info'] = $store_info;
			
			
			
			
			$val['store_info'] = $store_info;
			
			
	        $val['goods_list'] = $goods_list;
			
			if($val['type'] == 'integral')
			{
				//暂时屏蔽积分
				//$integral_order = M('integral_order')->field('score')->where( array('order_id' => $val['order_id']) )->find();
				//$val['score'] = intval($integral_order['score']);
			}
			
			$val['total'] = round($val['total'],2);

			//货到付款订单
			if($val['payment_code'] == 'cashon_delivery'){
				$val['cashondelivery_code_img'] = D('Home/Front')->getCashonDeliveryCode();
			}

	        $list[$key] = $val;
	    }
		
		$need_data = array('code' => 0);
		
		if( !empty($list) )
		{
			$need_data['data'] = $list;
			
		}else {
			$need_data = array('code' => 1);
		}
		
		echo json_encode( $need_data );
		die();
		
	}
	
	
	public function get_community_zhitui_qrcode()
	{
		$_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'];
		
	   		
		$member_info = M('lionfish_comshop_member')->where( array('member_id' => $member_id) )->find();	
		
		if( empty($member_info) )
		{
			echo json_encode( array('code' => 1) );
			die();
		}
		
		$community_info = D('Home/Front')->get_member_community_info($member_id);
		
		if( empty($community_info) || $community_info['state'] != 1 )
		{
			echo json_encode( array('code' => 1) );
			die();	
		}
		$head_id = $community_info['id'];
		
		
		$community_zhitui_qrcode_json = D('Home/Front')->get_config_by_name("community_zhitui_qrcode".$head_id);
		
		if( empty($community_zhitui_qrcode_json)  )
		{
			$path = "lionfish_comshop/moduleA/groupCenter/apply";
			$zhitui_qrcod = D('Home/Pingoods')->_get_commmon_wxqrcode($path, $head_id);
			
			if( empty($zhitui_qrcod) )
			{
				$zhitui_qrcod = '';
			}else{
				$zhitui_qrcod = tomedia($zhitui_qrcod);
			
				$arr = array();
				$arr['qrcode'] = $zhitui_qrcod;
				$arr['express_time'] = time() + 600;
				
							
				$hd_key = "community_zhitui_qrcode".$head_id;
				
				D('Seller/Config')->update( array( $hd_key => serialize($arr)) );
			}
			
			
			
			echo json_encode( array('code' => 0, 'qrcode' => $zhitui_qrcod ) );
			die();
			
		}else{
			
			$community_zhitui_qrcode_arr = unserialize($community_zhitui_qrcode_json);
			
			if( $community_zhitui_qrcode_arr['express_time'] < time() )
			{
				
				$path = "lionfish_comshop/moduleA/groupCenter/apply";
				$zhitui_qrcod = D('Home/Pingoods')->_get_commmon_wxqrcode($path, $head_id);
				
				if( empty($zhitui_qrcod) )
				{
					$zhitui_qrcod = '';
				}else{
					$zhitui_qrcod = tomedia($zhitui_qrcod);
					$arr = array();
					$arr['qrcode'] = $zhitui_qrcod;
					$arr['express_time'] = time() + 600;
					
					$ky = "community_zhitui_qrcode".$head_id;
					
					D('Seller/Config')->update( array( $ky => serialize($arr) ) );
				}
			
				echo json_encode( array('code' => 0, 'qrcode' => $zhitui_qrcod ) );
				die();
			}else{
				
				echo json_encode( array('code' => 0, 'qrcode' => $community_zhitui_qrcode_arr['qrcode'] ) );
				die();
				
			}
		}
		
		
		
		
		
		
	}
	
	
	
	//------begin---
	/**
		获取团长绑定核销人员二维码接口
	**/
	public function get_community_bind_member_qrcode()
	{
		$_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'];
			
		$member_info = M('lionfish_comshop_member')->where( array('member_id' => $member_id) )->find();	
		
		if( empty($member_info) )
		{
			echo json_encode( array('code' => 1) );
			die();
		}
		
		$community_info =  D('Home/Front')->get_member_community_info($member_id);
		
		if( empty($community_info) || $community_info['state'] != 1 )
		{
			echo json_encode( array('code' => 1) );
			die();	
		}
		$head_id = $community_info['id'];
		
		$community_memberbind_qrcode = D('Home/Front')->get_config_by_name('community_memberbind_qrcode'.$head_id);
		
		
		if( empty($community_memberbind_qrcode) )
		{
			
			$path = "lionfish_comshop/moduleA/groupCenter/bind_member_hexiao";
			$hexiao_qrcod = D('Home/Pingoods')->_get_commmon_wxqrcode($path, $head_id);
			
			$data = array();
			$data['time'] = time();
			$data['hexiao_qrcod'] = $hexiao_qrcod;
			
			$kd_lcc = 'community_memberbind_qrcode'.$head_id;
			
			D('Seller/Config')->update( array( $kd_lcc => serialize($data) ) );
			
			
			
			echo json_encode( array('code' => 0, 'qrcode' => tomedia($hexiao_qrcod) ) );
			die();
		}else{
			$hexiao_data = unserialize($community_memberbind_qrcode);
			
			if($hexiao_data['time'] + 600 < time() )
			{
				$path = "lionfish_comshop/moduleA/groupCenter/bind_member_hexiao";
				$hexiao_qrcod = D('Home/Pingoods')->_get_commmon_wxqrcode($path, $head_id);
				
				$data = array();
				$data['time'] = time();
				$data['hexiao_qrcod'] = $hexiao_qrcod;
				
				$ky = 'community_memberbind_qrcode'.$head_id;
				
				D('Seller/Config')->update( array( $ky => serialize($data) ) );
				
				echo json_encode( array('code' => 0, 'qrcode' => tomedia($hexiao_qrcod) ) );
				die();
			}else{
				echo json_encode( array('code' => 0, 'qrcode' => tomedia($hexiao_data['hexiao_qrcod']) ) );
				die();
			}
		}
		
	}
	
	
	
	/**
		团长的核销人员列表
	**/
	public function get_community_hexiao_memberlist()
	{
		$_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'];
			
		$member_info = M('lionfish_comshop_member')->where( array('member_id' => $member_id) )->find();	
		
		if( empty($member_info) )
		{
			echo json_encode( array('code' => 1) );
			die();
		}
		
		$community_info = D('Home/Front')->get_member_community_info($member_id);
		
		if( empty($community_info) || $community_info['state'] != 1 )
		{
			echo json_encode( array('code' => 1) );
			die();	
		}
		$head_id = $community_info['id'];
		
		
		$member_list = M()->query("select * from ".C('DB_PREFIX').
							"lionfish_comshop_community_pickup_member where  community_id={$head_id}  and state = 1 order by id desc ");
		
		if( empty($member_list) )
		{
			echo json_encode( array('code' => 1, 'log' => '暂时没有核销人员') );
			die();
		}else{
			
			foreach( $member_list as $key => $val )
			{
				
				$mb_info = M('lionfish_comshop_member')->field('avatar,username')->where( array('member_id' =>$val['member_id'] ) )->find();
				
				$member_record_count_arr = M()->query(" select count(order_id) as count from ".C('DB_PREFIX')
										."lionfish_comshop_community_pickup_member_record where  member_id=".$val['member_id'] );
										
										
				
				$member_record_count = $member_record_count_arr[0]['count'];
				
				$val['avatar'] = $mb_info['avatar'];
				$val['username'] = $mb_info['username'];
				$val['member_record_count'] = $member_record_count;
				
				$member_list[$key] = $val;
				//ims_lionfish_comshop_community_pickup_member_record
			}
			
			echo json_encode( array('code' => 0, 'member_list' => $member_list) );
			die();
		}
		
		
		//ims_lionfish_comshop_community_pickup_member
		
		
		
	}
	
	/**
		绑定
	**/
	
	public function bind_community_member_do()
	{
		$_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'];
			
		$member_info = M('lionfish_comshop_member')->where( array('member_id' => $member_id) )->find();	
		
		if( empty($member_info) )
		{
			echo json_encode( array('code' => 1) );
			die();
		}
		
		$name = $_GPC['name'];
		$mobile = $_GPC['mobile'];
		$community_id = $_GPC['community_id'];
		
		
		$is_in_info = M('lionfish_comshop_community_pickup_member')->where( array('member_id' => $member_id) )->find();
		if( !empty($is_in_info) )
		{
			echo json_encode( array('code' => 0) );
			die();
		}
		
		//pickup_id
		//lionfish_comshop_community_pickup_member
		
		
		$is_in_info = M('lionfish_comshop_community_pickup_member')->where( array('member_id' => $member_id ) )->find();	
		
		if( !empty($is_in_info) )
		{
			echo json_encode( array('code' => 0) );
			die();
		}
		
		
		$ins_data = array();
		$ins_data['community_id'] = $community_id;
		$ins_data['member_id'] = $member_id;
		$ins_data['state'] = 1;
		$ins_data['remark'] = '前台扫码添加,姓名：'.$name.',手机号:'.$mobile;
		$ins_data['addtime'] = time();
		
		$pickup_id = M('lionfish_comshop_community_pickup_member')->add($ins_data);
	
		M('lionfish_comshop_member')->where(  array('member_id' => $member_id) )->save( array('pickup_id' => $pickup_id ));
		
		echo json_encode( array('code' => 0) );
		die();
	}
	
	
	//2、查看会员核销记录的
	
	public function get_member_hexiao_orderlist()
	{
		$_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'];
			
		$member_info = M('lionfish_comshop_member')->where( array('member_id' => $member_id) )->find();	
		
		if( empty($member_info) )
		{
			echo json_encode( array('code' => 1) );
			die();
		}
		
		//lionfish_comshop_community_pickup_member_record
		$page = isset($_GPC['page']) ? $_GPC['page']:'1';
		
		$size = isset($_GPC['size']) ? $_GPC['size']:'20';
		$offset = ($page - 1)* $size;
		
		$where = " and member_id = {$member_id} ";
		
		
		$sql = "select *      
				from ".C('DB_PREFIX')."lionfish_comshop_community_pickup_member_record   
	                    where  1  {$where}  
	                      order by id desc limit {$offset},{$size}";
	  
	    $list =  M()->query($sql);
		if( !empty($list) )
		{
			foreach($list as  $key => $val)
			{
				
				$mb_info = M('lionfish_comshop_member')->field('username,avatar')->where( array('member_id' =>$val['member_id'] ) )->find();
				
				$val['username'] = $mb_info['username'];
				$val['avatar'] = $mb_info['avatar'];
				
				$val['addtime'] = date('Y-m-d H:i:s', $val['addtime']);
				
				$list[$key] = $val;
			}
		}
		
		if( empty($list) )
		{
			echo json_encode(array('code' => 1));
			die();
		}else{
			echo json_encode( array('code' =>0, 'data' => $list) );
			die();
		}
		
	}
	
	
	//------end----
	
	/***
		团长对清单进行收货
	**/
	public function sub_head_delivery()
	{
		
		$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'];
				
		$member_info = M('lionfish_comshop_member')->where( array('member_id' => $member_id) )->find();	
		
		if( empty($member_info) )
		{
			echo json_encode( array('code' => 1) );
			die();
		}
		
		$community_info = D('Home/Front')->get_member_community_info($member_id);
		
		if( empty($community_info) || $community_info['state'] != 1 )
		{
			echo json_encode( array('code' => 1) );
			die();	
		}
		$head_id = $community_info['id'];
		
		$list_id = $gpc['list_id'];
		
					
		$list_info = M('lionfish_comshop_deliverylist')->where( array('id' => $list_id, 'head_id' => $head_id) )->find();

		
		if( !empty($list_info) )
		{
			
			M('lionfish_comshop_deliverylist')->where( array('id' => $list_id ) )->save( array('state' => 2,'head_get_time' => time() ) );
			
			//对订单操作，可以去提货了 load_model_class('frontorder')->send_order_operate($order_id);
			
		
			$order_ids_all = M('lionfish_comshop_deliverylist_order')->where( array('list_id' => $list_id ) )->select();					
								
			if( !empty($order_ids_all) )
			{
				foreach($order_ids_all as $order_val)
				{
					$order_status_id_info = M('lionfish_comshop_order')->field('order_status_id')->where( array('order_id' => $order_val['order_id'] ) )->find();
					
					$order_status_id  = $order_status_id_info['order_status_id'];
					//配送中才能
					if($order_status_id == 14)
					{
						
						$history_data = array();
						$history_data['order_id'] = $order_val['order_id'];
						$history_data['order_status_id'] = 4;
						$history_data['notify'] = 0;
						$history_data['comment'] = '前台团长签收配送清单';
						$history_data['date_added'] = time();
						
						M('lionfish_comshop_order_history')->add( $history_data );
						
						//send_order_operate
						D('Home/Frontorder')->send_order_operate($order_val['order_id']);
					}
					
				}
			}
			echo json_encode( array('code' => 0) );
			die();
		}else{
			echo json_encode( array('code' => 1) );
			die();
		}
		
		
	}
	
	/**
		获取团长清单的商品列表
	**/
	public function get_head_deliverygoods()
	{
		$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'];
				
		$member_info = M('lionfish_comshop_member')->where( array('member_id' => $member_id) )->find();	
		
		if( empty($member_info) )
		{
			echo json_encode( array('code' => 1) );
			die();
		}
		
		
		$community_info = D('Home/Front')->get_member_community_info($member_id);
		
		if( empty($community_info) || $community_info['state'] != 1 )
		{
			echo json_encode( array('code' => 1) );
			die();	
		}
		$head_id = $community_info['id'];
		
		//lionfish_comshop_deliverylist_goods 
		
		$list_id = $gpc['list_id'];
		
		$page = isset($gpc['page']) ? $gpc['page']:'1';
		
		$size = isset($gpc['size']) ? $gpc['size']:'20';
		$offset = ($page - 1)* $size;
		
		$where = " and list_id = {$list_id} ";
		
		
		$sql = "select *      
				from ".C('DB_PREFIX')."lionfish_comshop_deliverylist_goods   
	                    where  1  {$where}  
	                      order by id desc limit {$offset},{$size}";
	  
	    $list =  M()->query($sql);
		if( !empty($list) )
		{
			foreach($list as  $key => $val)
			{
				$val['goods_image'] = tomedia($val['goods_image']);
				$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_head_deliverylist()
	{
		$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'];
				
		$member_info = M('lionfish_comshop_member')->where( array('member_id' => $member_id) )->find();	
		
		if( empty($member_info) )
		{
			echo json_encode( array('code' => 1) );
			die();
		}
		
		$community_info = D('Home/Front')->get_member_community_info($member_id);
		
		if( empty($community_info) || $community_info['state'] != 1 )
		{
			echo json_encode( array('code' => 1) );
			die();	
		}
		$head_id = $community_info['id'];
		
		$page = isset($gpc['page']) ? $gpc['page']:'1';
		
		$size = isset($gpc['size']) ? $gpc['size']:'6';
		$offset = ($page - 1)* $size;
		
		$where = " and head_id = {$head_id} ";
		
		$status = isset( $gpc['status'] ) ? $gpc['status']: -1;
		$kyw = isset( $gpc['keywords'] ) ? $gpc['keywords']: '';
		
		if($status >= 0)
		{
			$where .= " and state = {$status} ";
		} else {
			
		}
		if(!empty($kyw))
		{
			$where .= ' and (head_name like "%'.$kyw.'%" or head_mobile like "%'.$kyw.'%" or line_name like "%'.$kyw.'%" or clerk_name like "%'.$kyw.'%" or clerk_mobile like "%'.$kyw.'%" )';
            
		}
		
		
		$sql = "select *      
				from ".C('DB_PREFIX')."lionfish_comshop_deliverylist   
	                    where  1  {$where}  
	                      order by id desc limit {$offset},{$size}";
		$list = M()->query($sql);
		
	   
		if( !empty($list) )
		{
			foreach ($list as $key => &$val) {
				$val['express_time'] = $val['express_time'] ? date('Y-m-d H:i', $val['express_time']) :  '';
				$val['head_get_time'] = $val['head_get_time'] ? date('Y-m-d H:i', $val['head_get_time']) : '';
				$val['create_time'] = $val['create_time'] ? date('Y-m-d H:i',$val['create_time']) : '';
			}
		}
		
		if( empty($list) )
		{
			echo json_encode(array('code' => 1));
			die();
		}else{
			echo json_encode( array('code' =>0, 'data' => $list) );
			die();
		}
		
	}
	
	//--
	public function headorderlist()
	{
		$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'];
	    		
		$member_info = M('lionfish_comshop_member')->where( array('member_id' => $member_id ) )->find();
		
		if( empty($member_info) )
		{
			echo json_encode( array('code' => 1) );
			die();
		}
		
		$community_info = D('Home/Front')->get_member_community_info($member_id);
		
		if( empty($community_info) || $community_info['state'] != 1 )
		{
			echo json_encode( array('code' => 1) );
			die();	
		}
		$head_id = $community_info['id'];
		
		$page = isset($gpc['page']) ? $gpc['page']:'1';
		
		$size = isset($gpc['size']) ? $gpc['size']:'6';
		$offset = ($page - 1)* $size;
		
		$where = " and co.head_id = {$head_id} ";
		
		$order_status = $gpc['order_status'];
		
		if($order_status == 1)
		{
			$where .= " and co.state = 0 ";
		} else if($order_status == 2){
			$where .= " and co.state = 1 ";
		}
		
		
		/*$sql = "select co.order_id,co.state,co.money,co.addtime ,og.total,og.name
				from ".C('DB_PREFIX')."lionfish_community_head_commiss_order as co ,  
                ".C('DB_PREFIX')."lionfish_comshop_order_goods as og  
	                    where  co.order_goods_id = og.order_goods_id {$where}  
	                      order by co.id desc limit {$offset},{$size}";*/

		$sql = "select co.order_id,co.state,co.money,co.addtime ,og.total,og.name,co.type
				from ".C('DB_PREFIX')."lionfish_community_head_commiss_order as co left join
                ".C('DB_PREFIX')."lionfish_comshop_order_goods as og on co.order_goods_id = og.order_goods_id
	                    where 1=1  {$where}
	                      order by co.id desc limit {$offset},{$size}";
	  
	    $list =  M()->query($sql);
		
		if( !empty($list) )
		{
			foreach($list as $key => $val)
			{
				$val['total'] = sprintf("%.2f",$val['total']);
				$val['money'] = sprintf("%.2f",$val['money']);
				
				$val['addtime'] = date('Y-m-d H:i:s',$val['addtime']);
				
				$order_info= M('lionfish_comshop_order')->field('order_num_alias')->where( array('order_id' => $val['order_id']) )->find();			
							
				$val['order_num_alias'] = $order_info['order_num_alias'];

				if($val['type'] == 'tuijian'){
					$val['name'] = "推荐团长现金奖励";
				}
				$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 cashlist()
	{
		$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'];
	  
		$member_info = M('lionfish_comshop_member')->where( array('member_id' => $member_id) )->find();
		
		if( empty($member_info) )
		{
			echo json_encode( array('code' => 1) );
			die();
		}
		
		$community_info = D('Home/Front')->get_member_community_info($member_id);
		
		if( empty($community_info) || $community_info['state'] != 1 )
		{
			echo json_encode( array('code' => 1) );
			die();	
		}
		
		$page = isset($gpc['page']) ? $gpc['page']:'1';
		
		$size = isset($gpc['size']) ? $gpc['size']:'6';
		$offset = ($page - 1)* $size;
		
		//begin select 
		
		$sql = "select *      
				from ".C('DB_PREFIX')."lionfish_community_head_tixian_order  
	                    where  head_id =".$community_info['id']." and member_id={$member_id}   order by id desc limit {$offset},{$size}";
	  
	    $list =  M()->query($sql);
		
		foreach($list as $key => $val)
		{
			$val['addtime'] = date('Y-m-d H:i:s', $val['addtime']);
			$val['id'] = sprintf("%04d", $val['id']);
			
			$list[$key] = $val;
		}
		
		if( empty($list) )
		{
			echo json_encode( array('code' => 1) );
			die();
		} else{
			echo json_encode( array('code' => 0, 'data' => $list) );
			die();
		}
		//ims_ 
		
	}
	
	public function get_community_member_orderlist()
	{
		$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'];
	    
					
		$member_info =  M('lionfish_comshop_member')->where( array('member_id' => $member_id) )->find();			
		
		if( empty($member_info) )
		{
			echo json_encode( array('code' => 1) );
			die();
		}
		
		$community_info = D('Home/Front')->get_member_community_info($member_id);
		
		if( empty($community_info) && $member_info['pickup_id'] > 0  )
		{
			
			$parent_community_info = M('lionfish_comshop_community_pickup_member')->where( array('member_id' => $member_id ) )->find();			
									
			if(!empty($parent_community_info))
			{	
				$community_info = M('lionfish_community_head')->where( array('id' => $parent_community_info['community_id'] ) )->find();	
			}
			
			
		}
		
		
		
		if( empty($community_info) || $community_info['state'] != 1 )
		{
			echo json_encode( array('code' => 1) );
			die();	
		}
		
		$page = isset($gpc['page']) ? $gpc['page']:'1';
		
		$size = isset($gpc['size']) ? $gpc['size']:'20';
		$offset = ($page - 1)* $size;
		
		//begin select 
		$where = ' and h.head_id = '.$community_info['id'];
		
		 //date: that.data.date,
		//searchKey: that.data.searchKey,
		if( isset($gpc['date']) && !empty($gpc['date']) )
		{
			
		}
		
		if( isset($gpc['searchKey']) && !empty($gpc['searchKey']) )
		{
			$keywords = $gpc['searchKey'];
			
			$mb_order_list = M()->query( "select member_id from ". C('DB_PREFIX')."lionfish_comshop_order  
							where head_id=".$community_info['id']." and (shipping_tel like '%{$keywords}%' or shipping_name like '%{$keywords}%' ) " );
			
			$member_id_ids = array();
			if( !empty($mb_order_list) ){
				foreach($mb_order_list as $val)
				{
					$member_id_ids[] = 	$val['member_id'];
				}
			}
			
			
			if( !empty($member_id_ids) )
			{
				$member_id_ids_str = implode(',', $member_id_ids);
				$where .=" and (m.username like '%{$keywords}%' or h.member_id in({$member_id_ids_str}) ) ";
			}else{
				$where .=" and (m.username like '%{$keywords}%'  ) ";
			}
			
		}
		
		 $sql = "select h.member_id,h.id ,m.avatar, m.username ,("."select count(order_id) from ".C('DB_PREFIX')."lionfish_comshop_order  
								where  order_status_id =4 and delivery!='express' and delivery!='hexiao' and member_id=m.member_id and head_id= ".$community_info['id'].") as m_count
				from ".C('DB_PREFIX')."lionfish_community_history as h left join ".C('DB_PREFIX')."lionfish_comshop_member as m on h.member_id = m.member_id 
	                    where  1   {$where}  
	                     group by h.member_id order by m_count desc, h.id desc limit {$offset},{$size}";
	 
	   
	    $list =  M()->query($sql);
		
		
		//ims_lionfish_comshop_order
		$need_list = array();
		
		foreach($list as $key => $val)
		{
			$mb_info_ck = M('lionfish_comshop_member')->where( array('member_id' => $val['member_id'] ) )->find();
			if( empty($mb_info_ck) )
			{
				continue;
			}	
			
			$last_order_info = M('lionfish_comshop_order')->field('shipping_tel,shipping_name')->where( array('head_id' => $community_info['id'],'member_id' =>$val['member_id'] ) )->order('order_id desc')->find();
			
			if( empty($last_order_info) )
			{
				$val['mobile'] = '未下单';
			}else{
				$val['mobile'] = $last_order_info['shipping_tel'];
			}
			$val['shipping_name'] = $last_order_info['shipping_name'];
			
			$order_count = M('lionfish_comshop_order')->where( array('head_id' => $community_info['id'],'member_id' => $val['member_id'],'order_status_id' => 4) )->where("delivery!='express' and delivery!='hexiao'")->count();
								
								
			//$val['username'] = $member_info['username'];
			//$val['avatar'] = $member_info['avatar'];
			$val['order_count'] = $order_count;
			
			$list[$key] = $val;
			$need_list[$key] = $val;
		}
		
		
		$close_community_delivery_orders = D('Home/Front')->get_config_by_name('close_community_delivery_orders');
	
	
		if( !empty($need_list) )
		{
			$list = array();
			$i =0;
			foreach($need_list as $key => $val)
			{
				$list[$i] = $val;
				$i ++;			
			}
			
			echo json_encode( array('code' => 0, 'data' => $list , 'close_community_delivery_orders'=>$close_community_delivery_orders ) );
			die();
		}else {
			echo json_encode( array('code' => 1) );
			die();
		}
		
	}
	
	
	public function bind_community_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'];
	    
		
		$member_info = M('lionfish_comshop_member')->where( array('member_id' => $member_id) )->find();				
						
		
		if( empty($member_info) )
		{
			echo json_encode( array('code' => 1) );
			die();
		}
		
		$community_info = D('Home/Front')->get_member_community_info($member_id);
		
		if( empty($community_info) || $community_info['state'] != 1 )
		{
			echo json_encode( array('code' => 1) );
			die();	
		}
		
		$cardname = $gpc['cardname'];
		$cardaccount = $gpc['cardaccount'];
		$cardno = $gpc['cardno'];
		
		//ims_ 
		//pdo_update('lionfish_community_head', $data, array('id' => $head_info['id']));
		
		$data = array();
		$data['bankname'] = $cardname;
		$data['bankaccount'] = $cardaccount;
		$data['bankusername'] = $cardno;
		
		
		M('lionfish_community_head_commiss')->where( array('head_id' => $community_info['id']) )->save( $data );
		
		echo json_encode( array('code' => 0) );
		die();
		
	}
	
	public function get_community_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'];
	    
		$member_info = M('lionfish_comshop_member')->where( array('member_id' => $member_id) )->find();
		
		
		if( empty($member_info) )
		{
			echo json_encode( array('code' => 1) );
			die();
		}
		
		$community_info = D('Home/Front')->get_member_community_info($member_id);
		
		if( empty($community_info) || $community_info['state'] != 1 )
		{
			echo json_encode( array('code' => 1) );
			die();	
		}
		
		$community_info['re_id'] = sprintf("%05d", $community_info['id']);
		
		$head_id = $community_info['id'];
		//已获佣金情况
		$commission_info = D('Seller/Community')->get_head_commission_info($member_id, $head_id);
		
		//总订单数量
		$total_order_count =  D('Home/Frontorder')->get_community_head_order_count($head_id);
		
		//待配送 1  1   
		$wait_send_count =  M('lionfish_comshop_order')->where( array('order_status_id' => 1, 'head_id' => $head_id)  )->where(" type != 'ignore' ")->count();
		
		//待签收 14 14
	
		$wait_qianshou_count = M('lionfish_comshop_order')->where( array('order_status_id' => 14, 'head_id' => $head_id)  )->count();
		
		//待提货  4 4 
		$wait_tihuo_count = M('lionfish_comshop_order')->where( array('order_status_id' => 4, 'head_id' => $head_id)  )->count();
		
		//完成6-》  (6,11)
		$has_success_count = M('lionfish_comshop_order')->where( array('order_status_id' => array('in','6,11'), 'head_id' => $head_id)  )->count();
		
		
		
		//会员数量
		$total_member_count = D('Seller/Community')->get_community_head_member_count($head_id);
		
		//预计佣金 state=0
		$pre_total_money = M('lionfish_community_head_commiss_order')->where( array('state' => 0,'head_id' => $head_id) )->sum('money');
		
		if( empty($pre_total_money) )
		{
			$pre_total_money = 0;
		}


		//退配送费
		$refund_shipping_fare = 0;
		$refund_shipping_sql = "SELECT SUM( refund_shipping_fare ) as refund_shipping_fare "
							 . " FROM ".C('DB_PREFIX')."lionfish_comshop_order_goods_refund ogf, ".C('DB_PREFIX')."lionfish_community_head_commiss_order oco "
							 . " WHERE ogf.order_id = oco.order_id "
							 . " AND oco.head_id = ".$head_id
							 . " AND oco.state = 0 "
							 . " AND oco.add_shipping_fare > 0 ";
		$refund_shippings = M()->query($refund_shipping_sql);
		if(!empty($refund_shippings)){
			$refund_shipping_fare = $refund_shippings[0]['refund_shipping_fare'];
		}
		$pre_total_money = $pre_total_money - $refund_shipping_fare;
		$commission_info['mix_total_money'] = $pre_total_money + $commission_info['money'] + $commission_info['dongmoney'] + $commission_info['getmoney'];
		
		
		
		$today_time = strtotime( date('Y-m-d').' 00:00:00' );
		//今日订单总数 
		
		$today_order_count = M('lionfish_comshop_order')->where("head_id={$head_id} and date_added>={$today_time}")->count();
		
		
		//今日有效订单
		
		$today_effect_order_count = M('lionfish_comshop_order')->where( "order_status_id not in(3,5,7,12) and head_id={$head_id} and date_added>={$today_time} " )->count();
		
		
		//1、销售额：团长下面今日订单额度的总和，当日订单总数页面的总和  TODO..
		$seven_pay_where = " and head_id ={$head_id} and pay_time >= {$today_time} and order_status_id in (1,4,6,11,14) ";
				
		$seven_pay_money_info = D('Seller/Order')->get_order_sum(' sum(total+shipping_fare-voucher_credit-fullreduction_money) as total ' , $seven_pay_where);
		
		$head_today_pay_money = empty($seven_pay_money_info['total']) ? 0:$seven_pay_money_info['total'];
	
		$head_today_pay_money = sprintf("%.2f",$head_today_pay_money);
		
		//2、新增会员数：团长新增的用户统计  TODO..
		
		$sql_count = "select count(h.id) as count from ".C('DB_PREFIX').
					"lionfish_community_history as h, ".C('DB_PREFIX')."lionfish_comshop_member as m where m.member_id=h.member_id and h.head_id={$head_id} and m.create_time>={$today_time} ";
		
		$today_add_head_member_arr = M()->query($sql_count);
		
		$today_add_head_member = $today_add_head_member_arr[0]['count'];
		
		//3.售后订单（笔）:今日团长下面，申请售后的订单
		$sql_count = "select count(ref_id) as count from ".C('DB_PREFIX').
					"lionfish_comshop_order_refund where  head_id={$head_id} and addtime>={$today_time} ";
		
		$today_after_sale_order_count_arr = M()->query($sql_count);
		
		$today_after_sale_order_count = $today_after_sale_order_count_arr[0]['count'];
		
		//4、今日访客：统计今日浏览团长商城的用户数量  TODO..
		$sql_count = "select count(id) as count from ".C('DB_PREFIX').
					"lionfish_community_history where  head_id={$head_id} and addtime>={$today_time} ";
					
		$today_invite_head_member_arr = M()->query($sql_count);
		
		$today_invite_head_member = $today_invite_head_member_arr[0]['count'];
		
		
		//今日付款人数 
		$sql_count = "select order_id from ".C('DB_PREFIX')."lionfish_comshop_order where  head_id={$head_id} and pay_time>={$today_time} group by member_id  ";
		$today_pay_order_list = M()->query($sql_count);
		
		$today_pay_order_count = count($today_pay_order_list);
		
		
		
		//今日预计佣金
		//$today_pre_total_money = M('lionfish_community_head_commiss_order')->where( " state=0 and head_id={$head_id} and addtime>={$today_time}" )->sum('money');
		$pre_sql = "SELECT SUM( co.money ) as money "
				    . "FROM ".C('DB_PREFIX')."lionfish_community_head_commiss_order AS co "
					. "LEFT JOIN ".C('DB_PREFIX')."lionfish_comshop_order AS o ON co.order_id = o.order_id"
					. " WHERE co.head_id = ".$head_id
					. " AND co.addtime >= ".$today_time
					. " AND o.order_status_id not in (3,5,7,12) and co.state != 2 ";
		$today_pre_total_moneys = M()->query($pre_sql);
		if(!empty($today_pre_total_moneys)){
			$today_pre_total_money = $today_pre_total_moneys[0]['money'];
		}
		if(empty($today_pre_total_money))
		{
			$today_pre_total_money = 0;
		}
		//退配送费
		$today_refund_shipping_fare = 0;
		$today_refund_shipping_sql = "SELECT SUM( refund_shipping_fare ) as refund_shipping_fare "
				. " FROM ".C('DB_PREFIX')."lionfish_comshop_order_goods_refund ogf, ".C('DB_PREFIX')."lionfish_community_head_commiss_order oco "
				. " WHERE ogf.order_id = oco.order_id "
				. " AND oco.head_id = ".$head_id
				. " AND oco.state = 0 "
				. " AND oco.addtime >= '".$today_time."'"
				. " AND oco.add_shipping_fare > 0 ";
		$today_refund_shippings = M()->query($today_refund_shipping_sql);
		if(!empty($today_refund_shippings)){
			$today_refund_shipping_fare = $today_refund_shippings[0]['refund_shipping_fare'];
		}
		$today_pre_total_money = $today_pre_total_money - $today_refund_shipping_fare;
		
		
		//今日预计佣金+得到佣金
		$today_all_total_money = M('lionfish_community_head_commiss_order')->where( "(state=0 or state =1) and head_id={$head_id} and addtime>={$today_time}" )->sum('money');
		
		if(empty($today_all_total_money))
		{
			$today_all_total_money = 0;
		}

		$today_all_total_money = sprintf("%.2f", $today_all_total_money);
		
		
		$month_day = date('Y-m').'-01 00:00:00';
		$month_time = strtotime($month_day);
		
		//本月收入  and (state=0 or state =1)
		$month_pre_total_money = M('lionfish_community_head_commiss_order')->where( "head_id={$head_id} and (state=0 or state =1) and addtime>={$month_time}" )->sum('money');
		
		if(empty($month_pre_total_money))
		{
			$month_pre_total_money = 0;
		}
		
		/**待确认佣金*/
		
		//$wait_sub_total_money = M('lionfish_community_head_commiss_order')->where( "head_id={$head_id} and state=0" )->sum('money');
		$sql = "select sum( co.money ) as money from ".C('DB_PREFIX')."lionfish_community_head_commiss_order as co ,  
                ".C('DB_PREFIX')."lionfish_comshop_order_goods as og  
	                    where  co.order_goods_id = og.order_goods_id and  og.is_refund_state = 0 and co.state = 0 and co.head_id = ".$head_id." order by co.id desc ";
		
		$pre_total_money_list = M()->query($sql);

		$wait_sub_total_money = $pre_total_money_list[0]['money'];
		if( empty($wait_sub_total_money) )
		{
			$wait_sub_total_money = 0;
		}	

		
		//提现中
		$dongmoney = M('lionfish_community_head_tixian_order')->where( array('head_id' => $head_id, 'state' => 0) )->sum('money');
		if( empty($dongmoney) )
		{
			$dongmoney =  0 ;
		}
		

		
		/**已成功提现金额**/
		
		$tixian_sucess_money = M('lionfish_community_head_tixian_order')->where( array('head_id' => $head_id, 'state' => 1) )->sum('money');
		
		if( empty($tixian_sucess_money) )
		{
			$tixian_sucess_money = 0;
		}
		
		
		$head_commiss_tixianway_yuer  = D('Home/Front')->get_config_by_name('head_commiss_tixianway_yuer'); 
		$head_commiss_tixianway_weixin  = D('Home/Front')->get_config_by_name('head_commiss_tixianway_weixin'); 
		$head_commiss_tixianway_alipay  = D('Home/Front')->get_config_by_name('head_commiss_tixianway_alipay'); 
		$head_commiss_tixianway_bank  = D('Home/Front')->get_config_by_name('head_commiss_tixianway_bank');  
		
		$community_info['head_commiss_tixianway_yuer'] = empty($head_commiss_tixianway_yuer) ? 1 : ($head_commiss_tixianway_yuer == 2 ? 1:0);
		$community_info['head_commiss_tixianway_weixin'] = empty($head_commiss_tixianway_weixin) ? 1 : ($head_commiss_tixianway_weixin == 2 ? 1:0);
		$community_info['head_commiss_tixianway_alipay'] = empty($head_commiss_tixianway_alipay) ? 1 : ($head_commiss_tixianway_alipay == 2 ? 1:0);
		$community_info['head_commiss_tixianway_bank'] = empty($head_commiss_tixianway_bank) ? 1 : ($head_commiss_tixianway_bank == 2 ? 1:0);
		
		
		//上一微信真实姓名 lionfish_community_head_tixian_order
		$last_weixin_realname = "";
		
		//C('DB_PREFIX')
		$last_weixin_info = M('lionfish_community_head_tixian_order')->where( array("member_id={$member_id} and head_id={$head_id} and 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_community_head_tixian_order')->where("member_id={$member_id} and head_id={$head_id} and 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_community_head_tixian_order')->where( "member_id={$member_id} and head_id={$head_id} and 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'];
		}
		
		$community_info['last_weixin_realname'] = $last_weixin_realname;
		$community_info['last_alipay_name'] = $last_alipay_name;
		$community_info['last_alipay_account'] = $last_alipay_account;
		
		$community_info['last_bank_bankname'] = $last_bank_bankname;
		$community_info['last_bank_account'] = $last_bank_account;
		$community_info['last_bank_name'] = $last_bank_name;
		
		
		$head_commission_levelname 	= D('Home/Front')->get_config_by_name('head_commission_levelname');
		$default_comunity_money 	= D('Home/Front')->get_config_by_name('default_comunity_money');
		
		$level_list = array(
			0	=> array('levelname' => empty($head_commission_levelname) ? '默认等级' : $head_commission_levelname, 'commission' => $default_comunity_money )
		);
		
		
		$hd_level_list = M('lionfish_comshop_community_head_level')->where(1)->select();
		
		if( !empty($hd_level_list) )
		{
			foreach( $hd_level_list as $val )
			{
				$tmp = array();
				$tmp['levelname'] = $val['levelname'];//等级名称
				$tmp['commission'] = $val['commission'];//分佣比例
				
				$level_list[$val['id']] = $tmp;
			}
		}	
		$is_show_head_level = D('Home/Front')->get_config_by_name('is_show_head_level');
		
		$community_info['is_show_head_level'] = $is_show_head_level;
		$community_info['head_level_info'] = $level_list[ $community_info['level_id'] ];
		
		// 接龙开关
		$is_open_solitaire = D('Home/Front')->get_config_by_name('is_open_solitaire');

		$is_show_community_ranking = D('Home/Front')->get_config_by_name('is_show_community_ranking');

		//是否显示团长排行， 0不显示，1显示
        $is_show_community_ranking = empty($is_show_community_ranking) ? 0 : $is_show_community_ranking;

		$result = array();
		$result['code'] = 0;
		$result['member_info'] = $member_info;
		$result['community_info'] = $community_info;
		$result['commission_info'] = $commission_info;
		$result['total_order_count'] = $total_order_count;
		$result['total_member_count'] = $total_member_count;
		$result['today_order_count'] = $today_order_count;
		$result['today_effect_order_count'] = $today_effect_order_count;
		$result['today_all_total_money'] = $today_all_total_money;
		$result['today_pay_order_count'] = $today_pay_order_count;
		$result['today_pre_total_money'] = $today_pre_total_money;
		$result['month_pre_total_money'] = $month_pre_total_money;
		$result['pre_total_money'] = $pre_total_money;
		$result['wait_sub_total_money'] = $wait_sub_total_money;
		$result['dongmoney'] = $dongmoney;
		$result['tixian_sucess_money'] = $tixian_sucess_money;
		
		$result['wait_send_count'] = $wait_send_count;
		$result['wait_qianshou_count'] = $wait_qianshou_count;
		$result['wait_tihuo_count'] = $wait_tihuo_count;
		$result['has_success_count'] = $has_success_count;
		
		$result['head_today_pay_money'] = $head_today_pay_money;//今日销售额
		$result['today_add_head_member'] = $today_add_head_member;//今日新增会员数
		$result['today_after_sale_order_count'] = $today_after_sale_order_count;//今日售后订单
		$result['today_invite_head_member'] = $today_invite_head_member;//今日访客
		$result['is_show_community_ranking'] = $is_show_community_ranking;//团长排行

		$result['is_open_solitaire'] = $is_open_solitaire;
		
		
		$community_tixian_fee = D('Home/Front')->get_config_by_name('community_tixian_fee'); 
		
		$community_min_money = D('Home/Front')->get_config_by_name('community_min_money'); 
		
		if( empty($community_min_money) )
		{
			$community_min_money = 0;
		}
		
		if( empty($community_tixian_fee) )
		{
			$community_tixian_fee = 0;
		}
		$result['community_tixian_fee'] = $community_tixian_fee;
		$result['community_min_money'] = $community_min_money;
		

		
		$open_community_addhexiaomember = D('Home/Front')->get_config_by_name('open_community_addhexiaomember');
		
		if( empty($open_community_addhexiaomember) )
		{
			$open_community_addhexiaomember = 0;
		}
		
		$result['open_community_addhexiaomember'] = $open_community_addhexiaomember;
		
		//团长等级
		$open_community_head_leve = D('Home/Front')->get_config_by_name('open_community_head_leve');
		
		if( empty($open_community_head_leve) )
		{
			$open_community_head_leve = 0;
		}
		
		$result['open_community_head_leve'] = $open_community_head_leve;	
				
		$head_commiss_tixian_publish = D('Home/Front')->get_config_by_name('head_commiss_tixian_publish'); 
		
		$result['head_commiss_tixian_publish'] = htmlspecialchars_decode( $head_commiss_tixian_publish );		
		
		
		$is_need_subscript = 0;
		$need_subscript_template = array();
		
								
			$apply_tixian_info = M('lionfish_comshop_subscribe')->where( array('member_id' => $member_id , 'type' => 'apply_tixian') )->find();						
			
			if( empty($apply_tixian_info) )
			{
				$weprogram_subtemplate_apply_tixian = D('Home/Front')->get_config_by_name('weprogram_subtemplate_apply_tixian');
				
				if( !empty($weprogram_subtemplate_apply_tixian) )
				{
					$need_subscript_template['apply_tixian'] = $weprogram_subtemplate_apply_tixian;
				}
			}
			
			if( !empty($need_subscript_template) )
			{
				$is_need_subscript = 1;
			}
		
		
		$result['is_need_subscript'] = $is_need_subscript;
		$result['need_subscript_template'] = $need_subscript_template;

		// 分享信息
		$result['shop_index_share_title'] = D('Home/Front')->get_config_by_name('shop_index_share_title');
		$shop_index_share_image = D('Home/Front')->get_config_by_name('shop_index_share_image');
		$result['shop_index_share_image'] = "";
		if($shop_index_share_image) {
			$result['shop_index_share_image'] = tomedia($shop_index_share_image);
		}

		echo json_encode(  $result );
		die();
	}
	//begin 
	/**
		获取团长的下级列表接口
	**/
	public function get_head_child_headlist()
	{
		$gpc = I('request.');
		$_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'];
	    
		$member_info = M('lionfish_comshop_member')->where( array('member_id' => $member_id) )->find();
		
		if( empty($member_info) )
		{
			echo json_encode( array('code' => 1) );
			die();
		}
		
		$community_info = D('Home/Front')->get_member_community_info($member_id);
		
		if( empty($community_info) || $community_info['state'] != 1 )
		{
			echo json_encode( array('code' => 1) );
			die();	
		}
		
		$head_id = $community_info['id'];
		
		
		//...
		
		$page = isset($_GPC['page']) ? $_GPC['page']:'1';
		
		$size = isset($_GPC['size']) ? $_GPC['size']:'20';
		$offset = ($page - 1)* $size;
		
		//begin select 
		//$where = ' and head_id = '.$head_id;
		
		$level = isset($_GPC['level']) ? $_GPC['level']: 1;
		
		$level_1_ids = array();
		$level_2_ids = array();
		$level_3_ids = array();
		
		$head_id_arr = array($head_id);
		
		if( $level == 1 )
		{
			$list = array();
			
			$sql = "select * from ".C('DB_PREFIX')."lionfish_community_head  
	                    where  agent_id in (".implode(',', $head_id_arr).")   order by id desc limit {$offset},{$size}";
	 
			$list =  M()->query($sql);
			
			foreach( $list as $vv )
			{
				$level_1_ids[] = $vv['id'];
			}
			
		}else if( $level == 2 )
		{
			$list = array();
			
			$sql = "select * from ".C('DB_PREFIX')."lionfish_community_head  
	                    where  agent_id in (".implode(',', $head_id_arr).")   order by id desc limit {$offset},{$size}";
	 
			$list1 =  M()->query($sql);
			
			if( !empty($list1) )
			{
				foreach( $list1 as $vv )
				{
					$level_1_ids[] = $vv['id'];
				}
				
				$level_sql2 =" select * from ".C('DB_PREFIX').
							"lionfish_community_head  where  
								agent_id in (select id from ".C('DB_PREFIX')."lionfish_community_head 
								where agent_id ={$head_id}  order by id desc )  order by id desc ";
				
				$list2 =  M()->query($level_sql2);
				
				if( !empty($list2) ||   !empty($level_1_ids))
				{
					foreach( $list2 as $vv )
					{
						$level_2_ids[] = $vv['id'];
					}
					
					$need_ids = empty($level_1_ids) ? array() : $level_1_ids;
					if(!empty($level_2_ids))
					{
						foreach($level_2_ids as $vv)
						{
							$need_ids[] = $vv;
						}
					}
					
					$sql =" select * from ".C('DB_PREFIX').
								"lionfish_community_head  where  
									id in (".implode(',', $need_ids ).")  order by id desc limit {$offset},{$size}";
					
					$list =  M()->query($sql);
				}
			}
			
		}else if( $level == 3 ){
			$sql = "select * from ".C('DB_PREFIX')."lionfish_community_head  
	                    where   agent_id in (".implode(',', $head_id_arr).")   order by id desc limit {$offset},{$size}";
	 
			$list1 =  M()->query($sql);
			
			if( !empty($list1) )
			{
				foreach( $list1 as $vv )
				{
					$level_1_ids[] = $vv['id'];
				}
				$need_ids = empty($level_1_ids) ? array() : $level_1_ids;
				
				$level_sql2 =" select * from ".C('DB_PREFIX').
							"lionfish_community_head  where  
								agent_id in (select id from ".C('DB_PREFIX')."lionfish_community_head 
								where agent_id ={$head_id}  order by id desc )  order by id desc ";
				
				$list2 =  M()->query($level_sql2);
				
				if( !empty($list2) ||   !empty($level_1_ids))
				{
					foreach( $list2 as $vv )
					{
						$level_2_ids[] = $vv['id'];
					}
					
					if(!empty($level_2_ids))
					{
						foreach($level_2_ids as $vv)
						{
							$need_ids[] = $vv;
						}
					}
				}
				
				
				$level_sql3 =" select * from ".C('DB_PREFIX').
							"lionfish_community_head  where  
								agent_id in (".implode(',', $need_ids).")  order by id desc ";
				
				$list3 =  M()->query($level_sql3);
				
				if( !empty($list3) )
				{
					foreach( $list3 as $vv )
					{
						$level_3_ids[] = $vv['id'];
					}
					
					if(!empty($level_3_ids))
					{
						foreach($level_3_ids as $vv)
						{
							$need_ids[] = $vv;
						}
					}
				}
				
				$level_sql3 =" select * from ".C('DB_PREFIX').
						"lionfish_community_head where  id in (".implode(',',$need_ids).") order by id desc limit {$offset},{$size}";
		
				$list =  M()->query($level_sql3);
				
			}
				
				
			
		}
		
		//---------等级
		
		$community_head_level = M('lionfish_comshop_community_head_level')->order('id asc')->select();
		
		$head_commission_levelname = D('Home/Front')->get_config_by_name('head_commission_levelname');
		$default_comunity_money = D('Home/Front')->get_config_by_name('default_comunity_money');
		
		$list_default = array(
			array('id' => '0','level'=>0,'levelname' => empty($head_commission_levelname) ? '默认等级' : $head_commission_levelname, 'commission' => $default_comunity_money, )
		);
		
		$community_head_level = array_merge($list_default, $community_head_level);
		
		$level_id_to_name = array( 0=> empty($head_commission_levelname) ? '默认等级' : $head_commission_levelname );
		
		
		foreach($community_head_level as $kk => $vv)
		{
			$level_id_to_name[$vv['id']] = $vv['levelname'];
		}
		//---------等级
		
		$level_list = array();
		$need_list = array();
		
		if( !empty($list) ){
			foreach($list as $key => $val)
			{
				$mb_info = M('lionfish_comshop_member')->field('avatar,username')->where( array('member_id' => $val['member_id'] ) )->find();
				
				$val['level_name'] = $level_id_to_name[ $val['level_id'] ];
				
				$val['avatar'] = $mb_info['avatar'];
				$val['username'] = $mb_info['username'];
				$val['apptime'] = date('Y-m-d H:i:s', $val['apptime']);
				
				$need_list[$key] = $val;
			}
		}
	
		if( !empty($need_list) )
		{
			echo json_encode( array('code' => 0, 'data' => $need_list) );
			die();
		}else {
			echo json_encode( array('code' => 1) );
			die();
		}
		
	}
	
	/**
		获取团长分销账户信息情况
	**/
	public function get_head_distribute_info()
	{
		$gpc = I('request.');
		$_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'];
	    
		$member_info = M('lionfish_comshop_member')->where( array('member_id' => $member_id ) )->find();
		
		if( empty($member_info) )
		{
			echo json_encode( array('code' => 1) );
			die();
		}
		
		$community_info = D('Home/Front')->get_member_community_info($member_id);
		
		if( empty($community_info) || $community_info['state'] != 1 )
		{
			echo json_encode( array('code' => 1) );
			die();	
		}
		
		$head_id = $community_info['id'];
		
		$open_community_head_leve  = D('Home/Front')->get_config_by_name('open_community_head_leve');
		if( empty($open_community_head_leve) )
		{
			$open_community_head_leve = 0;
		}
		//总收入 wait_money
		//lionfish_community_head_commiss_order
		
		/**总收入 0 1 **/
		
		$total_money =  M('lionfish_community_head_commiss_order')->where( "(type='tuijian' or type ='commiss') and head_id={$head_id} and state=1" )->sum('money');
		
		if( empty($total_money) )
		{
			$total_money = 0;
		}
		//tuijian commiss
		
		
		//待确认
		
		$tixian_wait_money =  M('lionfish_community_head_commiss_order')->where( "(type='tuijian' or type ='commiss') and head_id={$head_id} and state=0" )->sum('money');
		
		if( empty($tixian_wait_money) )
		{
			$tixian_wait_money = 0;
		}
		
		//已确认
		$tixian_success_money = M('lionfish_community_head_commiss_order')->where( "(type='tuijian' or type ='commiss') and head_id={$head_id} and state=1" )->sum('money');
		
		if( empty($tixian_success_money) )
		{
			$tixian_success_money = 0;
		}
		
		//下级团长数量
		$level_count1 = 0;
		$level_count2 = 0;
		$level_count3 = 0;
		$level_count1 = M('lionfish_community_head')->where( array('agent_id' => $head_id ) )->count();
		
		if( empty($level_count1) || $level_count1 == 0 )
		{
			$level_count1 = 0;
		}else{
			
			$level_sql2 =" select count(1) as count from ".C('DB_PREFIX').
						"lionfish_community_head  where  
							agent_id in (select id from ".C('DB_PREFIX')."lionfish_community_head  
							where agent_id ={$head_id}  )  ";

			$level_count2_arr = M()->query($level_sql2);

			$level_count2 = $level_count2_arr[0]['count'];
		
			if( empty($level_count2) || $level_count2 == 0 )
			{
				$level_count2 = 0;
			}else{
				
				$level_sqllist2 =" select id from ".C('DB_PREFIX').
						"lionfish_community_head  where  
							agent_id in (select id from ".C('DB_PREFIX')."lionfish_community_head 
							where agent_id ={$head_id} )  ";
		
				$level_list2 =   M()->query($level_sqllist2);

				if( !empty($level_list2) )
				{
					$level_arr2 = array();
					
					foreach( $level_list2 as $vvv )
					{
						$level_arr2[] = $vvv['id'];
					}
					
					$level_sql3 =" select count(1) as count from ".C('DB_PREFIX').
						"lionfish_community_head where  agent_id in (".implode(',',$level_arr2).") ";

					$level_count3_arr = M()->query( $level_sql3 ); 

					$level_count3 = $level_count3_arr[0]['count'];
					
					if( empty($level_count3) || $level_count3 == 0 )
					{
						$level_count3 = 0;
					}
				}
			}
		}
		
		$need_data = array();
		$need_data['open_community_head_leve'] = $open_community_head_leve;
		$need_data['total_money'] = $total_money;
		$need_data['wait_money'] =  sprintf("%.2f",$tixian_wait_money);
		$need_data['success_money'] = sprintf("%.2f",$tixian_success_money);
		$need_data['level_count1'] = $level_count1;
		$need_data['level_count2'] = $level_count1 + $level_count2 ;
		$need_data['level_count3'] = $level_count1 + $level_count2 + $level_count3;
		echo json_encode( array('code' => 0, 'data' => $need_data ) );
		die();
	}
	
	/**
		获取团长分销明细
	**/
	
	public function get_head_distribute_order()
	{
		$gpc = I('request.');
		$_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'];
	    
		$member_info = M('lionfish_comshop_member')->where( array('member_id' => $member_id ) )->find();
		
		
		if( empty($member_info) )
		{
			echo json_encode( array('code' => 1) );
			die();
		}
		
		$community_info = D('Home/Front')->get_member_community_info($member_id);
		
		if( empty($community_info) || $community_info['state'] != 1 )
		{
			echo json_encode( array('code' => 1) );
			die();	
		}
		
		$head_id = $community_info['id'];
		
		
		$page = isset($_GPC['page']) ? $_GPC['page']:'1';
		
		$size = isset($_GPC['size']) ? $_GPC['size']:'20';
		$offset = ($page - 1)* $size;
		 
		$where = ' and head_id = '.$head_id;
		
		
		$type = isset($_GPC['type']) ? $_GPC['type']: '';
		$level = isset($_GPC['level']) ? $_GPC['level']: 0;
		
		if( empty($type) )
		{
			$where .= " and type in ('commiss','tuijian')";
		}
		
		if( $level > 0 )
		{
			//level
			$where .= " and level=".$level;
		}
		//commiss
		
		$sql = "select * from ".C('DB_PREFIX')."lionfish_community_head_commiss_order   
	                    where  1  {$where}   order by id desc limit {$offset},{$size}";
	 
	    $list = M()->query($sql);
		
		$status_list = M('lionfish_comshop_order_status')->select();
		
		$status_arr = array();
		foreach($status_list as $vv)
		{
			$status_arr[ $vv['order_status_id'] ] = $vv['name'];
		}
		
		$need_list = array();
		foreach($list as $key => $val)
		{
			$val['addtime'] = date('Y-m-d H:i:s', $val['addtime']);
			
			$child_head = M('lionfish_community_head')->where( array('id' => $val['child_head_id'] ) )->find();
				
			$val['child_head_name'] = $child_head['head_name'];
			$val['community_name'] = $child_head['community_name'];
				
			if( $val['type'] == 'commiss')
			{
				$order_info = M('lionfish_comshop_order')->field('order_num_alias,order_status_id')
							  ->where( array('order_id' => $val['order_id'] ) )->find();
				
				$val['order_num_alias'] = $order_info['order_num_alias'];
				$val['order_status'] = $status_arr[ $order_info['order_status_id'] ];
			}
			
			$need_list[$key] = $val;
		}
	
		if( !empty($need_list) )
		{
			echo json_encode( array('code' => 0, 'data' => $need_list) );
			die();
		}else {
			echo json_encode( array('code' => 1) );
			die();
		}
	}
	
	//end
	
	public function tixian_community_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'];
		
		
		$member_info = M('lionfish_comshop_member')->where( array('member_id' => $member_id) )->find();
		
		 
		if( empty($member_info) )
		{
			echo json_encode( array('code' => 1) );
			die();
		}
		
		$community_info = D('Home/Front')->get_member_community_info($member_id);
		
		if( empty($community_info) || $community_info['state'] != 1 )
		{
			echo json_encode( array('code' => 1) );
			die();	
		}
		$head_id = $community_info['id'];
		$commission_info = D('Seller/Community')->get_head_commission_info($member_id, $head_id);
		
		$tixian_money = $gpc['tixian_money'];
		
		
		$type = isset($gpc['type']) ? $gpc['type'] : 0;//0 沿用原来的逻辑 1余额 2 微信 3 支付宝 4 银行
		
		$bankname = isset($gpc['bankname']) ? $gpc['bankname'] : ''; //银行名称
		
		$bankaccount = isset($gpc['bankaccount']) ? $gpc['bankaccount'] : '';//卡号，支付宝账号 使用该字段
		
		$bankusername = isset($gpc['bankusername']) ? $gpc['bankusername'] : '';//持卡人姓名，微信名称，支付宝名称， 使用该字段
		
		$service_charge = D('Home/Front')->get_config_by_name('community_tixian_fee');
		
		if($commission_info['money'] >= $tixian_money )
		{
			$data = array();
			$data['member_id'] = $member_id;
			$data['head_id'] = $head_id;
			$data['money'] = floatval($tixian_money);
			$data['state'] = 0;
			
			$data['type'] = $type;
			$data['bankname'] = $bankname;
			$data['bankaccount'] = $bankaccount;
			$data['bankusername'] = $bankusername;
			$data['service_charge'] = round( ($tixian_money * $service_charge) /100,2);
			
			$data['shentime'] = 0;
			$data['addtime'] = time();
			
			M('lionfish_community_head_tixian_order')->add($data);
			
			M()->execute("update ".C('DB_PREFIX')."lionfish_community_head_commiss set money=money - {$tixian_money},dongmoney=dongmoney+{$tixian_money} 
						where  head_id={$head_id} ");
			
			echo json_encode( array('code' => 0) );
			die();
		}else{
			
			echo json_encode( array('code'=>1) );
			die();
		}
		
		
	}
	
	
	public function sub_community_head()
	{
		$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'];
		
		
		$member_info = M('lionfish_comshop_member')->where( array('member_id' => $member_id) )->find();
		
		
		
		if( empty($member_info) )
		{
			echo json_encode( array('code' => 1) );
			die();
		}
		
		$province_name = $gpc['province_name'];
		$city_name = $gpc['city_name'];
		$area_name = $gpc['area_name'];
		$country_name = $gpc['country_name'];
		
		$lon_lat = $gpc['lon_lat'];
		
		$lon_lat_arr = explode(',', $lon_lat);
		$wechat = $gpc['wechat'];
		
		
		
		$province_info = D('Home/Front')->get_area_ninfo_by_name($province_name);
		$province_id = $province_info['id'];
		
		$city_info = D('Home/Front')->get_area_ninfo_by_name($city_name);
		$city_id = $city_info['id'];
		
		$area_info = D('Home/Front')->get_area_ninfo_by_name($area_name);
		$area_id = $area_info['id'];
		
		$country_info = D('Home/Front')->get_area_ninfo_by_name($country_name);
		$country_id = $country_info['id'];
		
		
		$addr_detail = $gpc['addr_detail'];
		$community_name = $gpc['community_name'];
		$mobile = $gpc['mobile'];
		$head_name = $gpc['head_name'];
		
		$community_id = isset($gpc['community_id']) && intval($gpc['community_id']) > 0 ?  $gpc['community_id'] : 0;
		
		
		$data = array();
		$data['member_id'] = $member_id;
		$data['community_name'] = $community_name;
		$data['head_name'] = $head_name;
		$data['head_mobile'] = $mobile;
		$data['province_id'] = $province_id;
		$data['city_id'] = $city_id;
		$data['country_id'] = $country_id;
		$data['area_id'] = $area_id;
		$data['address'] = $addr_detail;
		$data['lon'] = $lon_lat_arr[0];
		$data['lat'] = $lon_lat_arr[1];
		$data['state'] = 0;
		$data['apptime'] = time();
		$data['addtime'] = time();
		$data['wechat'] = $wechat;
		
		$head_info = D('Home/Front')->get_member_community_info($member_id);
		
		$parent_head_id = 0;
		
		if( $member_info['share_id'] > 0 )
		{
			$parent_head_info = D('Home/Front')->get_member_community_info($member_info['share_id']);
			if( !empty($parent_head_info) )
			{
				$parent_head_id = $parent_head_info['id'];
			}
		}
		
		$data['agent_id'] = $parent_head_id;
		
		if( $community_id > 0 )
		{
			$data['agent_id'] = $community_id;
		}
		
		
		
		if( empty($head_info) )
		{
			$head_id =  M('lionfish_community_head')->add($data);
			
		}else{
			unset($data['uniacid']);
			unset($data['addtime']);
			
			M('lionfish_community_head')->where( array('id' => $head_info['id']) )->save($data);
			$head_id = $head_info['id'];
		}
		
		
		$head_commiss_info = M('lionfish_community_head_commiss')->where( array('member_id' =>$member_id,'head_id' => $head_id ) )->find();
		
		if( empty($head_commiss_info) )
		{
			$datas = array();
			$datas['member_id'] = $member_id;
			
			$datas['head_id'] = $head_id;
			$datas['money'] = 0;
			$datas['dongmoney'] = 0;
			$datas['getmoney'] = 0;
			$datas['bankname'] = '';
			$datas['bankaccount'] = '';
			$datas['bankusername'] = '';
			$datas['share_avatar'] = '';
			$datas['share_wxcode'] = '';
			$datas['share_title'] = '';
			$datas['share_desc'] = '';
			
			M('lionfish_community_head_commiss')->add( $datas );
			
		}			
		
		echo json_encode( array('code' => 0) );
		die();

	}

	/**
	 * 获取城市列表
	 */
	public function get_city_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'];
		
		
		$member_info = M('lionfish_comshop_member')->where( array('member_id' => $member_id) )->find();
		
		
		if( empty($member_info) )
		{
			//echo json_encode( array('code' => 1) );
			//die();
		}

		
		$city_ids_Arr = M('lionfish_community_head')->field('city_id')->order('city_id asc')->select();
		
		
		
		
		$city_ids = array();
		foreach ($city_ids_Arr as $k => $val) {
			$city_ids[] = $val['city_id'];
		}

		$city_ids_str = implode(',', $city_ids);

		$city_list = M('lionfish_comshop_area')->where( array('id' => array('in', $city_ids_str) ) )->select();
		
		
		// {
		 //        "districtCode": "152900",
		 //        "districtLevel": "CITY",
		 //        "parentDistrictCode": "150000",
		 //        "districtName": "阿拉善盟",
		 //        "firstLetter": "A",
		 //        "serviceStatus": "N"
		 //    }
		
		$city_arr = array();
		foreach ($city_list as $key => $value) {
			$city_arr[$key]["city_id"] = $value["id"];
			$city_arr[$key]["districtCode"] = $value["code"];
			$city_arr[$key]["districtLevel"] = "CITY";
			$city_arr[$key]["parentDistrictCode"] = $value["code"];
			$city_arr[$key]["districtName"] = $value["name"];
			$city_arr[$key]["firstLetter"] = $this->getFirstCharter($value["name"]);
			$city_arr[$key]["serviceStatus"] = "N";
		}

		echo json_encode( array('code' => 0, 'data' => $city_arr) );
		die();

	}

	/**
	 * 获取首字母
	 * @param  [type] $str [description]
	 * @return [type]      [description]
	 */
	function getFirstCharter($str)
	{
	    if (empty($str)) {
	        return '';
	    }
	    $fchar = ord($str{0});
	    if ($fchar >= ord('A') && $fchar <= ord('z'))
	        return strtoupper($str{0});
	    $s1 = iconv('UTF-8', 'gb2312', $str);
	    $s2 = iconv('gb2312', 'UTF-8', $s1);
	    $s = $s2 == $str ? $s1 : $str;
	    $asc = ord($s{0}) * 256 + ord($s{1}) - 65536;
	    
	    if ($asc >= -20319 && $asc <= -20284)
	        return 'A';
	    
	    if ($asc >= -20283 && $asc <= -19776)
	        return 'B';
	    
	    if ($asc >= -19775 && $asc <= -19219)
	        return 'C';
	    
	    if ($asc >= -19218 && $asc <= -18711)
	        return 'D';
	    
	    if ($asc >= -18710 && $asc <= -18527)
	        return 'E';
	    
	    if ($asc >= -18526 && $asc <= -18240)
	        return 'F';
	    
	    if ($asc >= -18239 && $asc <= -17923)
	        return 'G';
	    
	    if ($asc >= -17922 && $asc <= -17418)
	        return 'H';
	    
	    if ($asc >= -17417 && $asc <= -16475)
	        return 'J';
	    
	    if ($asc >= -16474 && $asc <= -16213)
	        return 'K';
	    
	    if ($asc >= -16212 && $asc <= -15641)
	        return 'L';
	    
	    if ($asc >= -15640 && $asc <= -15166)
	        return 'M';
	    
	    if ($asc >= -15165 && $asc <= -14923)
	        return 'N';
	    
	    if ($asc >= -14922 && $asc <= -14915)
	        return 'O';
	    
	    if ($asc >= -14914 && $asc <= -14631)
	        return 'P';
	    
	    if ($asc >= -14630 && $asc <= -14150)
	        return 'Q';
	    
	    if ($asc >= -14149 && $asc <= -14091)
	        return 'R';
	    
	    if ($asc >= -14090 && $asc <= -13319)
	        return 'S';
	    
	    if ($asc >= -13318 && $asc <= -12839)
	        return 'T';
	    
	    if ($asc >= -12838 && $asc <= -12557)
	        return 'W';
	    
	    if ($asc >= -12556 && $asc <= -11848)
	        return 'X';
	    
	    if ($asc >= -11847 && $asc <= -11056)
	        return 'Y';
	    
	    if ($asc >= -11055 && $asc <= -10247)
	        return 'Z';
	    
	    return null;
	    
	}

	/**
	 * 获取申请页面
	 */
	public function get_apply_page()
	{
		
		$info = M('lionfish_comshop_config')->field( 'value' )->where( array('name' => 'communityhead_apply_page') )->find();
		

	    if(!empty($info['value'])){
	    	echo json_encode( array('code' => 0, 'data' => htmlspecialchars_decode(htmlspecialchars_decode($info['value']))) );
			die();
	    }else{
	    	echo json_encode( array('code' => 1 ));
			die();
	    }
	}
	
	
	public function check_head_subscriptapply()
	{
		$_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'];
		
		$is_need_subscript = 0;
		$need_subscript_template = array();
		
		//'pay_order','send_order','hexiao_success','apply_community','open_tuan','take_tuan','pin_tuansuccess','apply_tixian'
		
							
			$apply_community_info = M('lionfish_comshop_subscribe')->where( array('member_id' => $member_id, 'type' => 'apply_community' ) )->find();						
			
			if( empty($apply_community_info) )
			{
				$weprogram_subtemplate_apply_community = D('Home/Front')->get_config_by_name('weprogram_subtemplate_apply_community');
				
				if( !empty($weprogram_subtemplate_apply_community) )
				{
					$need_subscript_template['apply_community'] = $weprogram_subtemplate_apply_community;
				}
			}
								
			$apply_tixian_info = M('lionfish_comshop_subscribe')->where( array('member_id' => $member_id, 'type' => 'apply_tixian' ) )->find();
			
			if( empty($apply_tixian_info) )
			{
				$weprogram_subtemplate_apply_tixian = D('Home/Front')->get_config_by_name('weprogram_subtemplate_apply_tixian');
				
				if( !empty($weprogram_subtemplate_apply_tixian) )
				{
					$need_subscript_template['apply_tixian'] = $weprogram_subtemplate_apply_tixian;
				}
			}
			
			if( !empty($need_subscript_template) )
			{
				$is_need_subscript = 1;
			}
			
		
		
		echo json_encode( array('code' => 0, 'is_need_subscript' => $is_need_subscript,'need_subscript_template' => $need_subscript_template ) );
		die();
		
	}
	
	
	//----------begin ----------------
	
	/**
	 * 团长设置页面团长资料
	 */
	public function get_head_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'];
		
		
		$member_info = M('lionfish_comshop_member')->where( array('member_id' => $member_id) )->find();
		
		
		if( empty($member_info) )
		{
			echo json_encode( array('code' => 1) );
			die();
		}
		
		

		$id = $_GPC['id'];

		if($id > 0)
		{ 
				
			$item = M('lionfish_community_head')->where( array('id' => $id ) )->find();	
		    
		    $item['province_name'] = D('Seller/Area')->get_area_info($item['province_id']);
		    $item['city_name'] = D('Seller/Area')->get_area_info($item['city_id']);
		    $item['area_name'] = D('Seller/Area')->get_area_info($item['area_id']);
		    $item['country_name'] = D('Seller/Area')->get_area_info($item['country_id']);
		    
			if( $item['member_id'] > 0)
			{
				$head_commiss_info = M('lionfish_community_head_commiss')->where( array('head_id' => $item['id'],'member_id' =>$item['member_id'] ) )->find();
				
				if( !empty($head_commiss_info) )
				{
					$item['bankname'] = $head_commiss_info['bankname'];
					$item['bankaccount'] = $head_commiss_info['bankaccount'];
					$item['bankusername'] = $head_commiss_info['bankusername'];
					$item['share_wxcode'] = tomedia($head_commiss_info['share_wxcode']);
				}
			}
			$item['member_info'] = $member_info;
			$item['rest'] = D('Seller/Communityhead')->is_community_rest($id);
			$item['re_id'] = sprintf("%05d", $item['id']);

			
			$delivery_type_tuanz  = D('Home/Front')->get_config_by_name('delivery_type_tuanz');
			
			$close_community_reset_btn  = D('Home/Front')->get_config_by_name('close_community_reset_btn');
			
			
			if(empty($delivery_type_tuanz))
			{
				$delivery_type_tuanz = 2;
			}
			$item['delivery_type_tuanz'] = $delivery_type_tuanz;
			$item['close_reset_btn'] = $close_community_reset_btn;
			
			if(!empty($item)){
		    	echo json_encode( array('code' => 0, 'data' => $item) );
				die();
		    }else{
		    	// 无数据
		    	echo json_encode( array('code' => 2 ));
				die();
		    }
		}
	}

	/**
	 * 团长设置休息状态
	 */
	public function set_head_rest()
	{
		$_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'];
		
		
		$member_info = M('lionfish_comshop_member')->where( array('member_id' => $member_id) )->find();
		
		
		if( empty($member_info) )
		{
			echo json_encode( array('code' => 1) );
			die();
		}
		

		$head_id = $_GPC['id'];
		$rest = $_GPC['rest'];

		if($head_id > 0){
			
			$result = M('lionfish_community_head')->where( array('id' => $head_id) )->save( array('rest' => $rest) );
			if(!empty($result)){
				echo json_encode( array('code' => 0, 'data' => '修改成功'));
				die();
			}else{
				echo json_encode( array('code' => 2, 'data' => '修改失败'));
				die();
			}
		}else{
	    	// id不存在
	    	echo json_encode( array('code' => 2, 'data' => 'id不存在' ));
			die();
	    }
	}

	/**
	 * 团长信息修改
	 */
	public function modify_head_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'];
		
		$member_info = M('lionfish_comshop_member')->where( array('member_id' => $member_id) )->find();
		
		if( empty($member_info) )
		{
			echo json_encode( array('code' => 1) );
			die();
		}
		
		$head_id = isset($_GPC['id']) ? $_GPC['id'] : 0;

	    $data = array();
	    $data['head_name'] = $_GPC['head_name'];
	    $data['head_mobile'] = $_GPC['head_mobile'];
		$data['is_modify_shipping_method'] = $_GPC['is_modify_shipping_method'];//是否自定义配送开关。0跟随系统，1开启，2关闭
	    $data['is_modify_shipping_fare'] = $_GPC['is_modify_shipping_fare'];//是否自定义配送费，0跟随系统，1自定义
	    $data['shipping_fare'] = $_GPC['shipping_fare'];// 自定义配送费
		
	
	    if($head_id > 0){
			
			
			
			$rs = M('lionfish_community_head')->where( array('id' => $head_id, 'member_id' => $member_id) )->save( $data );
			
			
			$commiss_data = array();
	    	$commiss_data['share_wxcode'] = $_GPC['share_wxcode'];
	    	if($commiss_data['share_wxcode']){
	    	
				$rs = M('lionfish_community_head_commiss')->where( array('head_id' => $head_id, 'member_id' => $member_id) )->save( $commiss_data );
    		}
			
			if(!empty($rs)){
				echo json_encode( array('code' => 0, 'data' => '修改成功'));
				die();
			}else{
				echo json_encode( array('code' => 2, 'data' => '修改失败'));
				die();
			}
		}else{
	    	// id不存在
	    	echo json_encode( array('code' => 2, 'data' => 'id不存在' ));
			die();
	    }
	}

	/**
	 * 团长信息修改
	 */
	public function modify_head_commiss()
	{
		$_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'];
		
		$member_info = M('lionfish_comshop_member')->where( array('member_id' => $member_id) )->find();
		
		if( empty($member_info) )
		{
			echo json_encode( array('code' => 1) );
			die();
		}
		
		$head_id = isset($_GPC['id']) ? $_GPC['id'] : 0;

	    $data = array();
	    $data['bankname'] = $_GPC['bankname'];
	    $data['bankaccount'] = $_GPC['bankaccount'];
	    $data['bankusername'] = $_GPC['bankusername'];
	    // $data['address'] = $_GPC['address'];
	    // $data['lon'] = $_GPC['lon'];
	    // $data['lat'] = $_GPC['lat'];
	    // $data['state'] = $_GPC['state'];
	    if($head_id > 0){
			
			$rs = M('lionfish_community_head_commiss')->where( array('head_id' => $head_id, 'member_id' => $member_id) )->save( $data );
			
			if(!empty($rs)){
				echo json_encode( array('code' => 0, 'data' => '修改成功'));
				die();
			}else{
				echo json_encode( array('code' => 2, 'data' => '修改失败'));
				die();
			}
		}else{
	    	// id不存在
	    	echo json_encode( array('code' => 2, 'data' => 'id不存在' ));
			die();
	    }
	}


	public function community_index_shareqrcode()
	{
		$_GPC = I('request.');
		
		$token =  $_GPC['token'];
		
		$weprogram_token = M('lionfish_comshop_weprogram_token')->field('member_id')->where( array('token' => $token) )->find();
			
		if(  empty($weprogram_token) ||  empty($weprogram_token['member_id']) )
		{
			$member_id = 0;
		}else{
			$member_id = $weprogram_token['member_id'];
		}
		
		$member_info = M('lionfish_comshop_member')->where( array('member_id' => $member_id) )->find();	
		
		if( empty($member_info) )
		{
			echo json_encode( array('code' => 1) );
			die();
		}
		
		$community_info = D('Home/Front')->get_member_community_info($member_id);
		if( empty($community_info) || $community_info['state'] != 1 )
		{
			echo json_encode( array('code' => 1) );
			die();	
		}
		$community_id = $community_info['id'];

		$community_index_shareqrcode_json = D('Home/Front')->get_config_by_name('community_index_shareqrcode_'.$community_id );
		$community_index_shareqrcode_arr = unserialize($community_index_shareqrcode_json);
		
		$load_new = false;
		if( empty($community_index_shareqrcode_arr) )
		{
			$load_new = true;
		}else {
			if( $community_index_shareqrcode_arr['endtime'] < time() )
			{
				$load_new = true;
			}
		}
		
		if( $load_new || true )
		{
			$goods_model = D('Home/Pingoods');
			$qrcode_image = $goods_model->_get_index_wxqrcode($member_id,$community_id,'jpg');
			
			$data = array();
			$data['image_path']  = '/'.$qrcode_image;
			$ed_time = time() + 300;
			$js_arr = array('endtime' => $ed_time,'image_path' => $data['image_path'] );
			
			$cd_key = 'community_index_shareqrcode_'.$community_id;
			D('Seller/Config')->update( array( $cd_key => serialize($js_arr) ) );
		}else{
			$data = array();
			$data['image_path']  ='/'.$community_index_shareqrcode_arr['image_path'];
		}
		
		$shop_domain = D('Home/Front')->get_config_by_name('shop_domain');
		
		$data['image_path'] = $shop_domain.$data['image_path'];
		$result = array('code' => 0, 'qrcode' => $data['image_path'] );
		echo json_encode($result);
		die();
		
	}

	/**
	 * 团长排行榜
	 */
	public function community_ranking_list(){
		$_GPC = I('request.');
		$token =  $_GPC['token'];
		$type = $_GPC['type'];
		$weprogram_token = M('lionfish_comshop_weprogram_token')->field('member_id')->where( array('token' => $token) )->find();
		if(  empty($weprogram_token) ||  empty($weprogram_token['member_id']) )
		{
			$member_id = 0;
		}else{
			$member_id = $weprogram_token['member_id'];
		}
		$member_info = M('lionfish_comshop_member')->where( array('member_id' => $member_id) )->find();
		if( empty($member_info) )
		{
			echo json_encode( array('code' => 1, 'mgs'=> '请登录') );
			die();
		}
		$community_info = D('Home/Front')->get_member_community_info($member_id);
		if( empty($community_info) || $community_info['state'] != 1 )
		{
			echo json_encode( array('code' => 1, 'mgs'=> '您不是团长，无法查看') );
			die();
		}
		$begin_time = 0;
		$end_time = 0;
		if($type == 1){//今日
			$begin_time = strtotime(date('Y-m-d'.'00:00:00',time()));
			$end_time = strtotime(date('Y-m-d'.'00:00:00',time()+3600*24));
		}else if($type == 2){//昨日
			$begin_time = strtotime(date('Y-m-d'.'00:00:00',time()-3600*24));
			$end_time = strtotime(date('Y-m-d'.'00:00:00',time()));
		}else if($type == 3){//上周
			$begin_time = strtotime(date("Y-m-d H:i:s",mktime(0,0,0,date('m'),date('d')-date('w')+1-7,date('Y'))));
			$end_time = strtotime(date("Y-m-d H:i:s",mktime(23,59,59,date('m'),date('d')-date('w')+7-7,date('Y'))));
		}else if($type == 4){//上月
			//上月开始时间
			$begin_time = strtotime(date("Y-m-d H:i:s",mktime(0, 0 , 0,date("m")-1,1,date("Y"))));
			//上月结束时间
			$end_time = strtotime(date("Y-m-d H:i:s",mktime(23,59,59,date("m") ,0,date("Y"))));
		}
		$list = array();
		$sql = " select * from ( "
			 . " select co.head_id,count(distinct(co.order_id)) as order_count, "
			 . " sum(co.money) as money "
			 . " from ".C('DB_PREFIX')."lionfish_community_head_commiss_order as co "
			 . " left join ".C('DB_PREFIX')."lionfish_comshop_order as o "
			 . " on co.order_id = o.order_id "
			 . " left join ".C('DB_PREFIX')."lionfish_community_head as h "
			 . " on co.head_id = h.id "
			 . " where co.addtime >= ".$begin_time." and co.addtime <= ".$end_time
			 . " and o.order_status_id not in (3,5,7,12) and co.state != 2 and h.state = 1 and h.enable = 1 "
			 . " group by co.head_id) t "
			 . " order by money desc "
			 . " limit 20 ";
		//echo $sql;
		$list = M()->query($sql);
		foreach($list as $k=>$v){
			$community_head = M('lionfish_community_head')->where( array('id' => $v['head_id']) )->find();

			$list[$k]['community_name'] = $community_head['community_name'];

			$member_info = M('lionfish_comshop_member')->field('avatar')->where( array('member_id' => $community_head['member_id']) )->find();

			$list[$k]['avatar'] = $member_info['avatar'];
		}

        $is_show_community_ranking = D('Home/Front')->get_config_by_name('is_show_community_ranking');
        //是否显示团长排行， 0不显示，1显示
        $is_show_community_ranking = empty($is_show_community_ranking) ? 0 : $is_show_community_ranking;


		echo json_encode(array('code' => 0,'data'=>$list , 'is_show_community_ranking' => $is_show_community_ranking ));
		die();
	}
    //----------end----------------------
}