<?php

class crm_order_controller extends adminCommon{
	//设置高级搜索功能
	function set_search(){
		$pro=$this->obj->DB_select_all("crm_product","1","`id`,`name`");
		if(!empty($pro)){
			foreach($pro as $k=>$v){
				$carr[$v['id']]=$v['name'];
			}
		}
		$search_list[]=array("param"=>"status","name"=>'审核状态',"value"=>array("1"=>"待审核","2"=>"已付款","3"=>"已完成","4"=>"已退款"));
		$search_list[]=array("param"=>"product","name"=>'产品名称',"value"=>$carr);
		$lo_time=array('1'=>'今天','3'=>'最近三天','7'=>'最近七天','15'=>'最近半月','30'=>'最近一个月');
		$search_list[]=array("param"=>"o_time","name"=>'发布时间',"value"=>$lo_time);
		$this->yunset("pro", $pro);
		$this->yunset("search_list",$search_list);
	}
	function index_action()
	{
		$this->set_search();
		$where.="`nid` in (".$this->config['crmpronid'].")";
		if ($_GET['product']!=""){
			$where.=" and `pid`='".$_GET['product']."'";
			$urlarr['product']=$_GET['product'];
		}
		if($_GET['status'])
		{
			$where.=" and `status`='".$_GET['status']."'";
			$urlarr['status']=$_GET['status'];
		}
		if($_GET['o_time']){
			if($_GET['o_time']=='1'){
				$where.=" and `ctime` >= '".strtotime(date("Y-m-d 00:00:00"))."'";
			}else{
				$where.=" and `ctime` >= '".strtotime('-'.$_GET['o_time'].'day')."'";
			}
			$urlarr['o_time']=$_GET['o_time'];
		}
		if($_GET['news_search']){

			if (trim($_GET['keyword'])!=""){
					if ($_GET['type']=='2'){
				$where.=" and `orderid` like '%".trim($_GET['keyword'])."%'";
			}elseif ($_GET['type']=='1'){
				$orderinfo=$this->obj->DB_select_all("crm_client","`name` like '%".trim($_GET['keyword'])."%'","`id`");
				if (is_array($orderinfo)){
					foreach ($orderinfo as $val){
						$orderuids[]=$val['id'];
					}
					$oruids=@implode(",",$orderuids);
				}
				$where.=" and `client_id` in (".$oruids.")";

			}
			$urlarr['type']=$_GET['type'];
			$urlarr['keyword']=$_GET['keyword'];
			}
			$urlarr['news_search']=$_GET['news_search'];
		}
		if($_GET['order'])
		{
			if($_GET['order']=="desc")
			{
				$order=" order by `".$_GET['t']."` desc";
			}else{
				$order=" order by `".$_GET['t']."` asc";
			}
			$urlarr['order']=$_GET['order'];
			$urlarr['t']=$_GET['t'];
		}else{
			$order=" order by `id` desc";
		}
		$urlarr['page']="{{page}}";
		$pageurl=Url($_GET['m'],$urlarr,'admin');
		$rows=$this->get_page("crm_order",$where.$order,$pageurl,$this->config['sy_listnum']);
		if(is_array($rows))
		{
			foreach($rows as $v)
			{
				$pid[]=$v['pid'];
				$cuid[]=$v['client_id'];
			}
			$plist=$this->obj->DB_select_all("crm_product","`id` in (".@implode(",",$pid).")");
			$clist=$this->obj->DB_select_all("crm_client","`id` in (".@implode(",",$cuid).")");
			foreach($rows as $k=>$v)
			{
				foreach($plist as $val)
				{
					if($v['pid']==$val['id'])
					{
						$rows[$k]['pname']=$val['name'];
					}
				}
				foreach($clist as $val)
				{
					if($v['client_id']==$val['id'])
					{
						$rows[$k]['username']=$val['name'];
					}
				}
			}
		}
		$this->yunset("get_type", $_GET);
		$this->yunset("rows",$rows);
		$this->yuntpl(array('admin/crm_order'));
	}
	function show_action()
	{
		$info=$this->obj->DB_select_once("crm_order","`id`='".$_GET['id']."'");
		$this->yunset("info",$info);
		$product=$this->obj->DB_select_once("crm_product","`id`='".$info['pid']."'");
		$this->yunset("product",$product);
		$this->yuntpl(array('admin/crm_order_show'));
	}
	function status_action()//订单确认完成
	{
		if(is_array($_POST['del']))
		{
			$del=@implode(",",$_POST['del']);
			$layer_type=1;
		}else{
			$del=$_GET['del'];
			$layer_type=0;
		}
		$nid=$this->obj->DB_update_all("crm_order","`status`='3'","`id` in (".$del.")");
		isset($nid)?$this->layer_msg('crm订单(ID:".$del.")确认完成成功！',9,$layer_type,$_SERVER['HTTP_REFERER']):$this->layer_msg('确认完成失败！',8,$layer_type,$_SERVER['HTTP_REFERER']);
	}
}
?>