shiziyu/Modules/Seller/Controller/MarketingController.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 Seller\Controller;

class MarketingController extends CommonController{
	
	protected function _initialize(){
		parent::_initialize();
	}
	
	
	public function index()
	{
		$this->user();
	}
	
	
	public function points()
	{
		$_GPC = I('request.');
		
		
		if (IS_POST) {
			
			$data = ((is_array($_GPC['data']) ? $_GPC['data'] : array()));
			
			D('Seller/Config')->update($data);
			
			show_json(1);
		}
		$data = D('Seller/Config')->get_all_config();
		
		$this->data = $data;
		$this->display();
	}
	
	
	
	public function coupon()
	{
		$_GPC = I('request.');
		
		$this->gpc = $_GPC;
		
		$pindex = max(1, intval($_GPC['page']));
		$psize = 20;
		$condition = ' 1 ';
		$params = array(':uniacid' => $_W['uniacid']);

		if (!empty($_GPC['keyword'])) {
			$_GPC['keyword'] = trim($_GPC['keyword']);
			$condition .= ' AND voucher_title LIKE "%'.$_GPC['keyword'].'%"';
			
		}

		if (!empty($_GPC['catid'])) {
			$_GPC['catid'] = trim($_GPC['catid']);
			$condition .= ' AND catid = '. $_GPC['catid'];
		}

		if (empty($starttime) || empty($endtime)) {
			$starttime = strtotime('-1 month');
			$endtime = time();
		}

		if (!empty($_GPC['time']['start']) && !empty($_GPC['time']['end'])) {
			$starttime = strtotime($_GPC['time']['start']);
			$endtime = strtotime($_GPC['time']['end']);

			$this->starttime = $starttime;
			$this->endtime = $endtime;
			
			if (!empty($starttime)) {
				$condition .= ' AND add_time >= '.$starttime;
			}

			if (!empty($endtime)) {
				$condition .= ' AND add_time <= '.$endtime;
			}
		}

		if ($_GPC['gettype'] != '') {
			$condition .= ' AND is_index_show = '.intval($_GPC['gettype']);
		}

		if ($_GPC['type'] != '') {
		//	$condition .= ' AND coupontype = '.intval($_GPC['type']);
		} 

		
		
		$sql = 'SELECT * FROM ' . C('DB_PREFIX') . 'lionfish_comshop_coupon ' . ' where  1 and ' . $condition . ' ORDER BY displayorder DESC,id DESC LIMIT ' . (($pindex - 1) * $psize) . ',' . $psize;
		$list = M()->query($sql);

		foreach ($list as &$row) {
			
						
			$send_count = M('lionfish_comshop_coupon_list')->where( array('voucher_id' => $row['id'] ) )->count();			
						
			
			$usetotal = M('lionfish_comshop_coupon_list')->where( array('voucher_id' => $row['id'], 'consume' => 'Y') )->count();			
			
			$row['usetotal'] = $usetotal;
			$row['send_count'] = $send_count;
			
			//usetotal
		}

		unset($row);
		$total_arr = M()->query('SELECT COUNT(*) as count FROM ' . C('DB_PREFIX'). 'lionfish_comshop_coupon where 1 and ' . $condition);
		$total = $total_arr[0]['count'];
		
		$pager = pagination2($total, $pindex, $psize);
		$category_arr = M()->query('select * from ' . C('DB_PREFIX') . 'lionfish_comshop_coupon_category   order by id desc');
		
		$category = array();
		foreach($category_arr as $vv)
		{
			$category['id'] = $vv['name'];
		}
		
					
		$this->list = $list;
		$this->pager = $pager;
		$this->category = $category;
		
		
		$this->display();
	}
	
	
	public function couponsend()
	{
		$_GPC = I('request.');
		
		
		$where = "";
		
		$where = " and (total_count=-1 or  total_count>send_count)   and (end_time>".time()." or timelimit =0 ) ";
		
		$quan_list = M()->query("select * from ".C('DB_PREFIX').
						"lionfish_comshop_coupon where 1 {$where} order by displayorder desc ,id asc limit 1000 ");
		
		$membercount = M('lionfish_comshop_member')->where( array('groupid' => 0 ) )->count();
		
		
		$list = array(
			array('id' => 'default', 'groupname' => '默认分组', 'membercount' => $membercount )
		);
		
		$condition = '  ';
		
		$alllist = M()->query('SELECT * FROM ' . C('DB_PREFIX'). 'lionfish_comshop_member_group WHERE 1 ' . $condition . ' ORDER BY id asc' );

		foreach ($alllist as &$row ) {
			$row['membercount'] = M('lionfish_comshop_member')->where("find_in_set(".$row['id'].",groupid)")->count();	
		}

		$list = array_merge($list, $alllist);
		
			
		$this->quan_list = $quan_list;
		$this->list = $list;
		$this->membercount = $membercount;
		
	
		include $this->display();
	}
	
	
	public function couponsend_do()
	{
		$_GPC = I('request.');
		
		
		$voucher_id = $_GPC['voucher_id'];
		$send_count = $_GPC['send_count'];
		$send_person = $_GPC['send_person'];
		
		$member_group_id = $_GPC['member_group_id'];
		
		$limit_user_list = $_GPC['limit_user_list'];
		
		
		$cache_key = md5(time().$voucher_id.$send_person);
		
		$ids_arr = array();
		
		if( $send_person == 1)
		{
			//送给部分人
			$ids_arr = explode(',', $limit_user_list);
		}else if( $send_person == 2 )
		{
			//送给分组 
			$member_group_id = $member_group_id == 'default' ? 0 : $member_group_id;
			
			$mb_list = M('lionfish_comshop_member')->field('member_id')->where( array('groupid' => $member_group_id ) )->select();
			
			foreach( $mb_list as $val )
			{
				$ids_arr[] = $val['member_id'];
			}
			
		}else if( $send_person == 3 ){
			//送给所有人
			$mb_list = M()->query("select member_id from ".C('DB_PREFIX')."lionfish_comshop_member where 1  " );
			
			foreach( $mb_list as $val )
			{
				$ids_arr[] = $val['member_id'];
			}
			
		}
		
		S('_send_quan_'.$cache_key, $ids_arr);
		
		$this->cache_key = $cache_key;
		$this->voucher_id = $voucher_id;
		$this->send_count = $send_count;
		$this->send_person = $send_person;
		$this->member_group_id = $member_group_id;
		$this->limit_user_list = $limit_user_list;
		
		
		include $this->display();
	}
	
	public function do_coupon_quene()
	{
		$_GPC = I('request.');
		
		$voucher_id = $_GPC['voucher_id'];
		$send_count = $_GPC['send_count'];
		
		$cache_key = $_GPC['cache_key'];
		
		$quene_order_list = S('_send_quan_'.$cache_key);
		
		$member_id = array_shift($quene_order_list);
		
		S('_send_quan_'.$cache_key, $quene_order_list);
		
		
		//send quan 
		for( $i =0; $i< $send_count; $i++ )
		{
			$res =  D('Home/Voucher')->send_user_voucher_byId($voucher_id,$member_id,false);
		}
		
		
		if( empty($quene_order_list) )
		{
			echo json_encode( array('code' => 2) );
			die();
		}
		
		
		echo json_encode( array('code' => 0, 'msg' => '会员id：'.$member_id." 处理成功，还剩余".count($quene_order_list)."个会员未处理") );
		die();
	}
	
	
	 public function change()
    {
		
		$_GPC = I('request.');
        $id = intval($_GPC['id']);

        //ids
        if (empty($id)) {
            $id = ((is_array($_GPC['ids']) ? implode(',', $_GPC['ids']) : 0));
        }

        if (empty($id)) {
            show_json(0, array('message' => '参数错误'));
        }

        $type  = trim($_GPC['type']);
        $value = trim($_GPC['value']);

        if (!(in_array($type, array('is_index_show', 'displayorder')))) {
            show_json(0, array('message' => '参数错误'));
        }

        $items = M()->query('SELECT id FROM ' .  C('DB_PREFIX') . 'lionfish_comshop_coupon WHERE id in( ' . $id . ' ) ' );

        foreach ($items as $item) {
			M('lionfish_comshop_coupon')->where( array('id' => $item['id']) )->save( array($type => $value) );
        }

        show_json(1, array('url' => $_SERVER['HTTP_REFERER']));

    }
	
	
	public function seckill()
	{
		$_GPC = I('request.');
		
		
		if ( IS_POST ) {
			
			$data = ((is_array($_GPC['data']) ? $_GPC['data'] : array()));
			
			$scekill_show_time_arr = $_GPC['scekill_show_time'];
			
			if( !empty($scekill_show_time_arr) )
			{
				$data['scekill_show_time'] = serialize($scekill_show_time_arr);
			}
			
			D('Seller/Config')->update($data);
			
			show_json(1, array('url' => $_SERVER['HTTP_REFERER']));
		}
		
		$data = D('Seller/Config')->get_all_config();
		
		if( isset($data['scekill_show_time']) && !empty($data['scekill_show_time']) )
		{
			$data['scekill_show_time_arr'] = unserialize($data['scekill_show_time']);
		}
		
		$this->data = $data;
		
		$this->display();
	}
	
	

	public function explain()
	{
		$_GPC = I('request.');
		
		if (IS_POST) {
			
			$data = ((is_array($_GPC['data']) ? $_GPC['data'] : array()));
			
			D('Seller/Config')->update($data);
			
			show_json(1, array('url' => $_SERVER['HTTP_REFERER']));
		}
		
		$data = D('Seller/Config')->get_all_config();
		
		$this->data = $data;
		
		$this->display();
	}
	
	//logcoupon&couponid=3
	public function logcoupon()
	{
		$_GPC = I('request.');
		
		$this->gpc = $_GPC;
		$pindex = max(1, intval($_GPC['page']));
		$psize = 20;
		$condition = ' 1 ';
		
		$couponid = intval($_GPC['couponid']);

		if (!empty($couponid)) {
			
			$coupon = M('lionfish_comshop_coupon')->where( array('id' => $couponid ) )->find();		
			
			$this->coupon = $coupon;
			$condition .= ' AND c.voucher_id=' . intval($couponid);
		}

		$searchfield = strtolower(trim($_GPC['searchfield']));
		$keyword = trim($_GPC['keyword']);
		if (!empty($searchfield) && !empty($keyword)) {
			if ($searchfield == 'member') {
				$condition .= ' and ( m.realname like "%'.$keyword.'%" or m.nickname like "%'.$keyword.'%" or m.mobile like "%'.$keyword.'%" )';
			}
			else {
				if ($searchfield == 'coupon') {
					$condition .= ' and c.voucher_title like "%'.$keyword.'%" ';
				}
			}
		}

		if (empty($starttime) || empty($endtime)) {
			$starttime = strtotime('-1 month');
			$endtime = time();
		}

		if (empty($starttime1) || empty($endtime1)) {
			$starttime1 = strtotime('-1 month');
			$endtime1 = time();
		}

		if (!empty($_GPC['time']['start']) && !empty($_GPC['time']['end'])) {
			$starttime = strtotime($_GPC['time']['start']);
			$endtime = strtotime($_GPC['time']['end']);
			
			$this->starttime = $starttime;
			$this->endtime = $endtime;
			
			$condition .= ' AND c.add_time >= '.$starttime.' AND c.add_time <= '.$endtime;
			
		}

		if (!empty($_GPC['time1']['start']) && !empty($_GPC['time1']['end'])) {
			$starttime1 = strtotime($_GPC['time1']['start']);
			$endtime1 = strtotime($_GPC['time1']['end']);
			
			$this->starttime1 = $starttime1;
			$this->endtime1 = $endtime1;
			
			$condition .= ' AND c.usetime >= '.$starttime1.' AND c.add_time <= '.$endtime1;
		}

		if ($_GPC['type'] != '') {
			$condition .= ' AND c.coupontype = '.intval($_GPC['type']);
		}

		if ($_GPC['used'] != '') {
			$condition .= ' AND c.consume = "' . trim($_GPC['used']).'" ';
		}

		if ($_GPC['gettype'] != '') {
			$condition .= ' AND c.gettype ='.intval($_GPC['gettype']);
		}

		$sql = 'SELECT c.*,m.username,m.avatar,m.openid,m.telephone FROM ' . C('DB_PREFIX'). 'lionfish_comshop_coupon_list  c ' . 
				' left join ' . C('DB_PREFIX'). 'lionfish_comshop_member m on m.member_id = c.user_id  ' . ' where  1 and ' . $condition . ' ORDER BY c.add_time DESC';

		if (empty($_GPC['export'])) {
			$sql .= ' LIMIT ' . (($pindex - 1) * $psize) . ',' . $psize;
		}

		$list = M()->query($sql);

		foreach ($list as &$row) {
			$couponstr = '消费';

			
			$row['couponstr'] = $couponstr;

			if ($row['gettype'] == 0) {
				$row['gettypestr'] = '后台发放';
			}
			else if ($row['gettype'] == 1) {
				$row['gettypestr'] = '首页领取';
			}
			else if ($row['gettype'] == 2) {
				$row['gettypestr'] = '积分商城';
			}
			else if ($row['gettype'] == 14) {
				$row['gettypestr'] = '新人领券';
			}
			else {
				if ($row['gettype'] == 15) {
					$row['gettypestr'] = '发券分享';
				}
			}
		}

		unset($row);

		if ($_GPC['export'] == 1) {
			

			foreach ($list as &$row) {
				$row['gettime'] = date('Y-m-d H:i', $row['add_time']);

				if (!empty($row['usetime'])) {
					$row['usetime'] = date('Y-m-d H:i', $row['usetime']);
				}
				else {
					$row['usetime'] = '---';
				}
			}

			$columns = array(
				array('title' => 'ID', 'field' => 'id', 'width' => 12),
				array('title' => '优惠券', 'field' => 'voucher_title', 'width' => 24),
				array('title' => '类型', 'field' => 'couponstr', 'width' => 12),
				array('title' => '会员信息', 'field' => 'username', 'width' => 12),
				array('title' => '姓名', 'field' => 'realname', 'width' => 12),
				array('title' => '手机号', 'field' => 'telephone', 'width' => 12),
				array('title' => 'openid', 'field' => 'openid', 'width' => 24),
				array('title' => '获取方式', 'field' => 'gettypestr', 'width' => 12),
				array('title' => '获取时间', 'field' => 'gettime', 'width' => 12),
				array('title' => '使用时间', 'field' => 'usetime', 'width' => 12),
				array('title' => '使用单号', 'field' => 'ordersn', 'width' => 12)
				);
				
			D('Seller/Excel')->export($list, array('title' => '优惠券数据-' . date('Y-m-d-H-i', time()), 'columns' => $columns));
			//m('excel')->export($list, array('title' => '优惠券数据-' . date('Y-m-d-H-i', time()), 'columns' => $columns));
			//plog('sale.coupon.log.export', '导出优惠券发放记录');
		}

		$total_arr = M()->query('SELECT COUNT(*) as count FROM ' . C('DB_PREFIX'). 'lionfish_comshop_coupon_list c ' . ' left join ' . C('DB_PREFIX') . 'lionfish_comshop_member m on m.member_id = c.user_id  ' . 'where 1 and ' . $condition);
		$total = $total_arr[0]['count'];
		
		$pager = pagination2($total, $pindex, $psize);
		
		$this->list = $list;
		$this->pager = $pager;
		
		$this->display();
	}
	
	public function recharge_diary()
	{
		$_GPC = I('request.');
		
		$starttime = isset($_GPC['time']['start']) ? strtotime($_GPC['time']['start']) : strtotime(date('Y-m-d'.' 00:00:00'));
		$endtime = isset($_GPC['time']['end']) ? strtotime($_GPC['time']['end']) : strtotime(date('Y-m-d'.' 23:59:59'));
		
		$keyword = $_GPC['keyword'];
		
		$state = $_GPC['state'];
		
		$this->starttime = $starttime;
		$this->endtime = $endtime;
		$this->keyword = $keyword;
		$this->state = $state;
		
		
		$condition = '   ';
		
		if( !empty($state) && $state > 0 )
		{
			$condition .= " and cf.state ={$state} ";
		}else{
			$condition .= " and cf.state <> 0 ";
		}
		
		if( isset($_GPC['time']) )
		{
			if($_GPC['time']['start'])
			{
				$condition .= " and cf.add_time >= {$starttime} ";
			}
			if($_GPC['time']['end'])
			{
				$condition .= " and cf.add_time <= {$endtime} ";
			}
		}
		
		if( !empty($keyword) )
		{
			$condition .= " and m.username like '%{$keyword}%' ";
		}
		
		$pindex = max(1, intval($_GPC['page']));
		$psize = 20;

		$sql = "select cf.* ,m.username,m.avatar  from ".C('DB_PREFIX')."lionfish_comshop_member_charge_flow as cf , ".C('DB_PREFIX')."lionfish_comshop_member as m 
				where cf.member_id = m.member_id {$condition} order by cf.id desc limit ". (($pindex - 1) * $psize) . ',' . $psize;
		
		$sql_count = "select count(1) as count  from ".C('DB_PREFIX')."lionfish_comshop_member_charge_flow as cf , ".C('DB_PREFIX')."lionfish_comshop_member as m 
				where cf.member_id = m.member_id {$condition} ";
		
		
		$list = M()->query($sql);
		
		$total_arr = M()->query($sql_count );
		
		$total = $total_arr[0]['count'];
		
		
		foreach( $list as $key => $val )
		{
			$val['add_time'] = date('Y-m-d H:i:s',$val['add_time'] );		
		
			if($val['state'] == 3 || $val['state'] == 4)
			{
				$od_info =	M('lionfish_comshop_order')->field('order_num_alias')->where( array('order_id' => $val['trans_id'] ) )->find();		
							
				if( !empty($od_info) )
				{
					$val['trans_id'] = $od_info['order_num_alias'];
				}
			}
			
			$list[$key] = $val;
		}
		
		
		$pager = pagination2($total, $pindex, $psize);
		
					
		$all_count = M('lionfish_comshop_member_charge_flow')->where( "state != 0" )->count();				
						
		$count_status_1 = M('lionfish_comshop_member_charge_flow')->where( array('state' => 1) )->count();
		
		$count_status_3 = M('lionfish_comshop_member_charge_flow')->where( array('state' => 3) )->count();
			
		$count_status_4 = M('lionfish_comshop_member_charge_flow')->where( array('state' => 4) )->count();
		
		$count_status_5 = M('lionfish_comshop_member_charge_flow')->where( array('state' => 5) )->count();
					
		$count_status_8 = M('lionfish_comshop_member_charge_flow')->where( array('state' => 8) )->count();
					
		$count_status_9 = M('lionfish_comshop_member_charge_flow')->where( array('state' => 9) )->count();
		
		$count_status_10 = M('lionfish_comshop_member_charge_flow')->where( array('state' => 10) )->count();
		
		
		$this->list = $list;
		$this->pager = $pager;
		$this->all_count = $all_count;
		$this->count_status_1 = $count_status_1;
		$this->count_status_3 = $count_status_3;
		$this->count_status_4 = $count_status_4;
		$this->count_status_5 = $count_status_5;
		$this->count_status_8 = $count_status_8;
		$this->count_status_9 = $count_status_9;
		$this->count_status_10 = $count_status_10;
		
		$this->display();
	}
	
	
	
	
	public function displayordercoupon()
	{
		$_GPC = I('request.');
		
		$id = intval($_GPC['id']);

		if (empty($id)) {
			$id = (is_array($_GPC['ids']) ? implode(',', $_GPC['ids']) : 0);
		}

		$displayorder = intval($_GPC['value']);
		$items = M()->query('SELECT id FROM ' . C('DB_PREFIX'). 'lionfish_comshop_coupon WHERE id in( ' . $id . ' ) ' );

		foreach ($items as $item) {
			M('lionfish_comshop_coupon')->where( array('id' => $id) )->save( array('displayorder' => $displayorder) );
		}

		show_json(1, array('url' => $_SERVER['HTTP_REFERER']));
	
	}
	
	public function addcoupon()
	{
		$_GPC = I('request.');
		
		$id = intval($_GPC['id']);
		
		if (IS_POST) {
			
			$data = array();
			$data['catid'] = $_GPC['catid'];
			$data['voucher_title'] = $_GPC['voucher_title'];
			$data['thumb'] = $_GPC['thumb'];
			$data['credit'] = $_GPC['credit'];
			$data['type'] = 1;
			$data['is_index_show'] = $_GPC['is_index_show']; 
			$data['is_index_alert'] = $_GPC['is_index_alert']; 
			$data['is_share_doubling'] = 0; 
			$data['get_over_hour'] = $_GPC['get_over_hour'] * 24; 
			$data['is_limit_goods_buy'] = $_GPC['is_limit_goodsbuy'];
			$data['is_new_man'] = $_GPC['is_new_man'];
			$data['share_title'] = ''; 
			$data['share_desc'] = ''; 
			$data['share_logo'] = ''; 
			$data['timelimit'] = $_GPC['timelimit'];
			$data['person_limit_count'] = $_GPC['person_limit_count']; 
			$data['limit_goods_list'] = $_GPC['limit_goods_list']; 
			$data['goodscates'] = $_GPC['goodscates']; 
			$data['limit_money'] = $_GPC['limit_money']; 
			$data['total_count'] = $_GPC['total_count']; 
			$data['send_count'] = $_GPC['send_count']; 
			$data['add_time'] = time(); 
			$data['displayorder'] = $_GPC['displayorder']; 
			$data['begin_time'] = strtotime($_GPC['time']['start']); 
			$data['end_time'] = strtotime($_GPC['time']['end']) + 86399; 
			
			if($id > 0)
			{
				M('lionfish_comshop_coupon')->where( array('id' => $id) )->save( $data );
			}else{
				M('lionfish_comshop_coupon')->add($data);
			}
			
			show_json(1, array('url' => $_SERVER['HTTP_REFERER']));
		}
		$category = M()->query('select * from ' . C('DB_PREFIX'). 'lionfish_comshop_coupon_category where  merchid=0 order by id desc');
		
		$goods_category = D('Seller/GoodsCategory')->getFullCategory(true, true);
		
		$this->goods_category = $goods_category;
		
		$new_category = array();
		foreach($category as $key =>$val)
		{
			$new_category[$val['id']] = $val;
		}
		
		$this->category = $category;
		
		if (empty($id)) {
			$starttime = time();
			$endtime = strtotime(date('Y-m-d H:i:s', $starttime) . '+7 days');
		}else{
			
			$item = M('lionfish_comshop_coupon')->where( array('id' => $id) )->find();
			
			$item['get_over_hour'] = $item['get_over_hour'] / 24; 
			$starttime = $item['begin_time'];
			$endtime = $item['end_time'];
			
			$limit_goods = array();
			
			if( !empty($item['limit_goods_list']) )
			{
				$limit_goods = M('lionfish_comshop_goods')->field('id as gid,goodsname,subtitle')->where('id in('.$item['limit_goods_list'].')')->order('id desc')->select();
				
				foreach($limit_goods as $kk => $vv)
				{
					$thumb = M('lionfish_comshop_goods_images')->where( array('goods_id' => $vv['gid'] ) )->order('id asc')->find();
					
					$vv['image'] =  tomedia($thumb['image']);
					
					$limit_goods[$kk] = $vv;
				}	
			}
			
			$this->limit_goods = $limit_goods;
			
			$this->item = $item;
			
		}
		$this->starttime = $starttime;
		$this->endtime = $endtime;
		
		
		$this->display();
	}
	
	public function fullreduction()
	{
		$_GPC = I('request.');
		
		$this->gpc = $_GPC;
		if (IS_POST) {
			
			$data = ((is_array($_GPC['parameter']) ? $_GPC['parameter'] : array()));
			
			
			$data['is_open_fullreduction'] = intval($data['is_open_fullreduction']);
			
			
			$data['full_money'] = floatval($data['full_money']);
			$data['full_reducemoney'] = floatval($data['full_reducemoney']);
			
			D('Seller/Config')->update($data);
			
			show_json(1, array('url' => $_SERVER['HTTP_REFERER']));
		}
		$data = D('Seller/Config')->get_all_config();
		
		$this->data = $data;
		
		$this->display();
	}
	
	public function deletecategory()
	{
		$_GPC = I('request.');
		$id = intval($_GPC['id']);

		M('lionfish_comshop_coupon_category')->where( array('id' => $id) )->delete();
		
		show_json(1, array('url' => $_SERVER['HTTP_REFERER']));
	}
	
	public function deletecoupon()
	{
		$_GPC = I('request.');
		$id = intval($_GPC['id']);

		if (empty($id)) {
			$id = ((is_array($_GPC['ids']) ? implode(',', $_GPC['ids']) : 0));
		}

		$items = M('lionfish_comshop_coupon')->field('id')->where( 'id in( ' . $id . ' )' )->select();

		foreach ($items as $item ) {
			M('lionfish_comshop_coupon')->where( array('id' => $item['id']) )->delete();
		}

		show_json(1, array('url' => $_SERVER['HTTP_REFERER']));
		
	}
	
	public function category()
	{
		$_GPC = I('request.');
		
		if (!empty($_GPC['catid'])) {
			foreach ($_GPC['catid'] as $k => $v) {
				$data = array('name' => trim($_GPC['catname'][$k]), 'displayorder' => $k, 'status' => intval($_GPC['status'][$k]));

				if (empty($v)) {
					M('lionfish_comshop_coupon_category')->add($data);
				}
				else {
					M('lionfish_comshop_coupon_category')->where( array('id' => $v) )->save( $data );
				}
			}

			show_json(1, array('url' => $_SERVER['HTTP_REFERER']));
		}
		$list = M()->query('SELECT * FROM ' . C('DB_PREFIX'). 'lionfish_comshop_coupon_category WHERE  merchid=0 ORDER BY displayorder asc');
		
		$this->list = $list;
		
		$this->display();
	}
	
	public function querycoupon() 
	{
		$_GPC = I('request.');
		$this->gpc = $_GPC;
		
		$kwd = trim($_GPC['keyword']);
		$diy = intval($_GPC['diy']);
		$live = intval($_GPC['live']);
		
		$condition = ' and ( (timelimit = 1 and end_time > '.time().' ) or timelimit =0 )';
		if (!(empty($kwd))) 
		{
			$condition .= ' AND voucher_title like "%'.$kwd.'%"';
		}
		$time = time();
		$ds = M()->query('SELECT * FROM ' . C('DB_PREFIX'). 
				'lionfish_comshop_coupon  WHERE 1 ' . $condition . ' ORDER BY id asc');
		
		$this->ds = $ds;
		$this->time = $time;
		
		include $this->display();
	}
	
	
	/**
		签到奖励
	**/
	public function signinreward()
	{
		$_GPC = I('request.');
		
		if (IS_POST) {
			
			$data = ((is_array($_GPC['data']) ? $_GPC['data'] : array()));
			
			D('Seller/Config')->update($data);
			
			show_json(1, array('url' => $_SERVER['HTTP_REFERER']));
		}
		$data = D('Seller/Config')->get_all_config();
		
		$this->data = $data;
		
		include $this->display();
	}
	
	
	
	public function delrecharge()
	{
		$id = I('request.id');
		
		M('lionfish_comshop_chargetype')->where( array('id' => $id ) )->delete();
		
		show_json(1, array('url' => $_SERVER['HTTP_REFERER']));
	}
	/**
	 * 充值设置
	 * @return [type] [description]
	 */
	public function recharge ()
	{
		$_GPC = I('request.');
		
		if (IS_POST) {
			
			$catid = $_GPC['catid'];
			$money = $_GPC['money'];
			$give = $_GPC['give'];
			
			$need_ids = array();
			
			foreach( $catid as $id )
			{
				if( $id > 0 )
				{
					$need_ids[] = $id;
				}
			}
			
			$list = M('lionfish_comshop_chargetype')->field('id')->order('id asc')->select();
			
			foreach($list as $vv )
			{
				if( empty($need_ids) || !in_array($vv['id'], $need_ids) )
				{
					M('lionfish_comshop_chargetype')->where( array('id' => $vv['id']) )->delete();
				}
			}
			//以上清理历史数据
			
			foreach( $catid as $key => $id )
			{
				if( $id > 0 )
				{
					M('lionfish_comshop_chargetype')->where( array('id' => $id) )->save( array('money' => $money[$key], 'send_money' => $give[$key]) );
				}else{
					$data = array();
					$data['money'] = $money[$key];
					$data['send_money'] = $give[$key];
					$data['addtime'] = time();
					$data['uniacid'] = $_W['uniacid'];
					
					M('lionfish_comshop_chargetype')->add($data);
				}
			}
			show_json(1, array('url' => $_SERVER['HTTP_REFERER']));
		}

		$list = M('lionfish_comshop_chargetype')->order( 'id asc' )->select();
		
		$this->list = $list;
		
		$this->display();
	}
	
	
	public function special ()
	{
		$_GPC = I('request.');

		$starttime = isset($_GPC['time']['start']) ? strtotime($_GPC['time']['start']) : strtotime(date('Y-m-d'.' 00:00:00'));
		$endtime = isset($_GPC['time']['end']) ? strtotime($_GPC['time']['end']) : strtotime(date('Y-m-d'.' 23:59:59'));
		$searchtime = isset($_GPC['searchtime']) && !empty($_GPC['searchtime']) ? $_GPC['searchtime'] : '';

		$this->starttime = $starttime;
		$this->endtime = $endtime;
		
		
		$pindex = max(1, intval($_GPC['page']));
		$psize = 20;
		$condition = ' 1 ';
		
		if (!empty($_GPC['keyword'])) {
			$_GPC['keyword'] = trim($_GPC['keyword']);
			$condition .= ' AND name LIKE "%'.trim($_GPC['keyword']).'%" ';
		}

		if (empty($starttime) || empty($endtime)) {
			$starttime = strtotime('-1 month');
			$endtime = time();
		}

		if (!empty($_GPC['time']['start']) && !empty($_GPC['time']['end'])) {
			$starttime = strtotime($_GPC['time']['start']);
			$endtime = strtotime($_GPC['time']['end']);

			if (!empty($starttime)) {
				$condition .= ' AND addtime >= '.$starttime;
			}

			if (!empty($endtime)) {
				$condition .= ' AND addtime <= '.$endtime;
			}
		}

		if ($_GPC['gettype'] != '') {
			$condition .= ' AND enabled = '.intval($_GPC['gettype']);
		}
		
		$sql = 'SELECT * FROM ' . C('DB_PREFIX'). 'lionfish_comshop_special ' . ' where 1 and ' . $condition . ' ORDER BY displayorder DESC,id DESC LIMIT ' . (($pindex - 1) * $psize) . ',' . $psize;
		
		$list = M()->query($sql);
		

		$total_arr = M()->query('SELECT COUNT(*) as count FROM ' . C('DB_PREFIX'). 'lionfish_comshop_special where 1 and ' . $condition );
		
		$total = $total_arr[0]['count'];
		
		$pager = pagination2($total, $pindex, $psize);
		
		
		$this->list = $list;
		$this->pager = $pager;
		
		$this->_GPC = $_GPC;
		
		$this->display();
	}

	public function addspecial ()
	{
		$_GPC = I('request.');

		$id = intval($_GPC['id']);
		
		if (IS_POST) {
			
			$data = array();
			
			$data['name'] = $_GPC['name'];
			$data['cover'] = $_GPC['cover'];
			$data['type'] = intval($_GPC['type']);
			$data['enabled'] = intval($_GPC['enabled']);
			
			$data['is_index'] = intval($_GPC['is_index']);
			$data['show_type'] = intval($_GPC['show_type']);
			
			$data['special_title'] = $_GPC['special_title'];
			$data['special_cover'] = $_GPC['special_cover'];
			$data['displayorder'] = $_GPC['displayorder'];
			$data['goodsids'] = $_GPC['limit_goods_list'];
			$data['bg_color'] = trim($_GPC['bg_color']);
			$data['begin_time'] = strtotime($_GPC['time']['start']);
			$data['end_time'] = strtotime($_GPC['time']['end']) ;
			$data['addtime'] = time();
			
			if($id > 0)
			{
				M('lionfish_comshop_special')->where( array('id' => $id) )->save( $data );
			}else{
				$id = M('lionfish_comshop_special')->add($data);
			}
			
			show_json(1, array('url' => $_SERVER['HTTP_REFERER']));
		}
		
				
		$item = M('lionfish_comshop_special')->where( array('id' => $id ) )->find();		
		
		if (empty($item)) {
			$starttime = time();
			$endtime = strtotime(date('Y-m-d H:i:s', $starttime) . '+7 days');
		}else{
			$item['get_over_hour'] = $item['get_over_hour'] / 24; 
			$starttime = $item['begin_time'];
			$endtime = $item['end_time'];
			
			$limit_goods = array();
			
			//goodsids
			if( !empty($item['goodsids']) )
			{
				
				 $goodsids_arr = explode(',',  $item['goodsids'] );
              
             
				$limit_goods = M('lionfish_comshop_goods')->field('id as gid,goodsname,subtitle')->where(  array('id' => array('in', $goodsids_arr )  ) )->order('id desc')->select();
				
				
				foreach($limit_goods as $kk => $vv)
				{
					$thumb = M('lionfish_comshop_goods_images')->where( array('goods_id' => $vv['gid'] ) )->order('id asc')->find();
					
					$vv['image'] =  tomedia($thumb['image']);
					
					$limit_goods[$kk] = $vv;
				}	
			}
			$this->limit_goods = $limit_goods;
		}
		
		$this->starttime = $starttime;
		$this->endtime = $endtime;
		
		$this->item = $item;
		$this->_GPC = $_GPC;
		$this->display();
	}

	public function changespecial()
    {
		
		$_GPC = I('request.');
        $id = intval($_GPC['id']);

        //ids
        if (empty($id)) {
            $id = ((is_array($_GPC['ids']) ? implode(',', $_GPC['ids']) : 0));
        }

        if (empty($id)) {
            show_json(0, array('message' => '参数错误'));
        }

        $type  = trim($_GPC['type']);
        $value = trim($_GPC['value']);

        if (!(in_array($type, array('enabled', 'displayorder' , 'is_index')))) {
            show_json(0, array('message' => '参数错误'));
        }

        $items = M()->query('SELECT id FROM ' . C('DB_PREFIX'). 'lionfish_comshop_special WHERE id in( ' . $id . ' ) ' );
		
        foreach ($items as $item) {
            
			M('lionfish_comshop_special')->where( array('id' => $item['id']) )->save( array($type => $value) );
        }

        show_json(1, array('url' => $_SERVER['HTTP_REFERER']));

    }

    public function deletespecial()
	{
		$_GPC = I('request.');
		$id = intval($_GPC['id']);

		if (empty($id)) {
			$id = ((is_array($_GPC['ids']) ? implode(',', $_GPC['ids']) : 0));
		}


		$items = M()->query('SELECT id FROM ' . C('DB_PREFIX'). 'lionfish_comshop_special WHERE id in( ' . $id . ' ) ');

		foreach ($items as $item ) {
			M('lionfish_comshop_special')->where( array('id' => $item['id']) )->delete();
		}

		show_json(1, array('url' => $_SERVER['HTTP_REFERER']));
	}
	
	
	
}
?>