<?php
//-------------------------------设计师-界面
header("Content-type: text/html; charset=utf-8");
$json_data="{";
if(THIS_IN!="edt_ipad")
	exit("错误的访问!");

$uid=check_cookie_jxs();
$msg_login=get_db_msg("select * from ".$table_pre."client where id='".$uid."'");

$arr_report=array("ph"=>"我的排行榜","ks_qs"=>"款式趋势报表");

$_a=$_a?$_a:"ph";

if($_a=="ph" || $_a=="ks_qs"){
	$json_data.="\"s_a\":\"".$_a."\",";
	$str_tab="";
	foreach($arr_report as $k1=>$v1){
		$str_tab.="{\"_a\":\"".$k1."\",\"title\":\"".$v1."\"},";
	}
	$str_tab=deel_end($str_tab);
	$json_data.="\"tab\":[".$str_tab."],";
}
$arr_zd=array("1"=>"订单量");
$json_data.="\"uid\":\"".$uid."\",";
switch($_a){
	case "ph":
		$s_ms=$s_ms?$s_ms:"1";
		if($s_ms=="2"){
			$con_group_by="no,color";
		}else{
			$con_group_by="no";
		}
		//取得选项
		$arr_select_no=array();
		$arr_select_title=array();
		$q="select no,title from ".$table_pre."keyword where cate='arr_select' and flag_ka='y' and no<>'jgd' and no<>'sx' and no<>'zd1' and no<>'zd2' and no<>'zd3' order by ord";
		$r=$db->query($q);
		while($m=$db->fetch_array($r)){
			$arr_select_no[]=$m["no"];
			$arr_select_title[]=$m["title"];
		}
		//
		$arr_ms=array("1"=>"到款","2"=>"到色");
		$tmp_ms="";
		foreach($arr_ms as $k => $v){
			$tmp_ms.="{\"no\":\"".$k."\",\"title\":\"".$v."\"},";
		}
		$tmp_ms=deel_end($tmp_ms);
		$json_data.="\"select_ms\":{\"no\":\"s_ms\",\"title\":\"排行模式\",\"value\":\"".$s_ms."\",\"op\":[".$tmp_ms."]},";

		//
		$s_order=$s_order?$s_order:"num";
		$arr_order=array("num"=>"数量排序","je"=>"金额排序");
		$tmp_order="";
		foreach($arr_order as $k => $v){
			$tmp_order.="{\"no\":\"".$k."\",\"title\":\"".$v."\"},";
		}
		$tmp_order=deel_end($tmp_order);
		$json_data.="\"select_order\":{\"no\":\"s_order\",\"title\":\"排序\",\"value\":\"".$s_order."\",\"op\":[".$tmp_order."]},";


		//取得定制选项
		$select_dz="";
		for($i=0;$i<count($arr_select_no);$i++){
			//取得选项
			$tmp="";
			$r1=$db->query("select no,title from ".$table_pre."keyword where cate='".$arr_select_no[$i]."' order by no");
			while($m1=$db->fetch_array($r1)){
				$tmp.="{\"no\":\"".$m1["no"]."\",\"title\":\"".$m1["title"]."\"},";
			}
			$tmp=deel_end($tmp);
			$var="s_".$arr_select_no[$i];
			$select_dz.="{\"no\":\"".$arr_select_no[$i]."\",\"title\":\"".$arr_select_title[$i]."\",\"value\":\"".$$var."\",\"op\":[".$tmp."]},";
		}
		$select_dz=deel_end($select_dz);
		$json_data.="\"select_dz\":[".$select_dz."],";
		$json_data.="\"s_no\":\"".$s_no."\",";

		$thead_str="";
		$thead_str.="{\"zd\":\"zpm\",\"title\":\"全国排名\"},";
		$thead_str.="{\"zd\":\"kh\",\"title\":\"款号\"},";
		$thead_str.="{\"zd\":\"pic\",\"title\":\"图片\"},";
		if($s_ms=="2"){
			$thead_str.="{\"zd\":\"color\",\"title\":\"颜色\"},";
		}
		$thead_str.="{\"zd\":\"wpm\",\"title\":\"我的排名\"},";
		$thead_str.="{\"zd\":\"dpj\",\"title\":\"吊牌价\"},";
		$thead_str.="{\"zd\":\"sl\",\"title\":\"件数\"},";
		$thead_str.="{\"zd\":\"je\",\"title\":\"吊牌金额\"}";
		$json_data.="\"thead_str\":[".$thead_str."],";

		$con1="";
		//取得设计师条件
		$con_designer="where id>0 ";
		$tmp=get_db_msg("select no from ".$table_pre."keyword where title='".$msg_login["title"]."' and cate='designer'");
		if($tmp["no"]){
			$con1.="designer='".$tmp["no"]."' and ";
			$con_designer=" and designer='".$tmp["no"]."'";
		}
		if($s_no)
			$con1.="no like '%".$s_no."%' and ";
		for($i=0;$i<count($arr_select_no);$i++){
			if($arr_select_no!="designer"){
				$v="s_".$arr_select_no[$i];
				if($$v)
					$con1.=$arr_select_no[$i]."='".$$v."' and ";
			}
		}
		if($con1){
			$con1="where ".substr($con1,0,-4);
		}else{
			$con1="where id>0 ";
		}

		//取得总排名数据
		$arr_je_zpm=$arr_num_zpm=array();
		$q1="select sum(num) 'num',sum(je) 'je' from ".$table_pre."order where _key='".$_key."' group by ".$con_group_by." order by ".$s_order." desc";
		$r1=$db->query($q1);
		while($m1=$db->fetch_array($r1)){
			$arr_je_zpm[]=$m1["je"];
			$arr_num_zpm[]=$m1["num"];
		}
		//取得我的排名数据
		$arr_je_wpm=$arr_num_wpm=array();
		$q1="select sum(num) 'num',sum(je) 'je' from ".$table_pre."order ".$con_designer." and _key='".$_key."' group by ".$con_group_by." order by ".$s_order." desc";
		$r1=$db->query($q1);
		while($m1=$db->fetch_array($r1)){
			$arr_je_wpm[]=$m1["je"];
			$arr_num_wpm[]=$m1["num"];
		}
		//默认每页显示20
		$page=$page?$page:"1";
		$ord_num=20;
		$start=($page-1)*$ord_num;
		$end=$ord_num;
		$tmp_tal=get_db_msg("select count(distinct ".$con_group_by.") 'num' from ".$table_pre."order ".$con1." and _key='".$_key."'");
		$pages=ceil($tmp_tal["num"]/$ord_num);
		$json_data.="\"pages\":\"".$pages."\",";

		$q="select sum(num) 'num',sum(je) 'je',iid,color from ".$table_pre."order ".$con1." and _key='".$_key."' group by ".$con_group_by." order by ".$s_order." desc limit ".$start.",".$end;
		$r=$db->query($q);
		while($m=$db->fetch_array($r)){
			$m1=get_db_msg("select * from ".$table_pre."kh where id='".$m["iid"]."'");
			$v1="arr_".$s_order."_zpm";
			$v2="arr_".$s_order."_wpm";
			$num=$m["num"];
			$money=$m["je"];
			$tbody_str.="{";
			$tbody_str.="\"zpm\":\"".(get_main_key1($$v1,$$s_order)+1)."\",";
			$tbody_str.="\"kh\":\"".$m1["no"]."\",";
			$tbody_str.="\"yph\":\"".get_kh_xh($m1)."\",";
			if($s_ms=="2"){
				$tbody_str.="\"color\":\"".$m["color"]."-".get_cate_title_no("color",$m["color"])."\",";
				$pic=get_kh_color_picture($m1["no"],$m["color"],$flag_pad_offline);
			}else{
				$pic=get_kh_picture($m1["no"],$m1["main_pic"],$m1["color"],$flag_pad_offline);
			}
			$arr_pic_set=out_good_pic_set_arr($pic,100,100);
			$tbody_str.="\"pic_src\":\"".$pic."\",";
			$tbody_str.="\"pic_w\":\"".$arr_pic_set[0]."\",";
			$tbody_str.="\"pic_h\":\"".$arr_pic_set[1]."\",";
			$tbody_str.="\"wpm\":\"".(get_main_key1($$v2,$$s_order)+1)."\",";
			$tbody_str.="\"dpj\":\"".$m1["price"]."\",";
			$tbody_str.="\"sl\":\"".$num."\",";
			$tbody_str.="\"je\":\"".deel_num($money)."\"";
			$tbody_str.="},";
		}
		$json_data.="\"tbody_str\":[".substr($tbody_str,0,-1)."],";

	break;
	case "ks_qs":
		$s_con_time=$s_con_time?$s_con_time:"day";
		//
		$s_zd="";
		foreach($arr_zd as $k => $v){
			$var="zd_".$k;
			if($$var=="on")
				$s_zd.=$k.",";
		}
		$s_zd=deel_end($s_zd);
		$s_zd=$s_zd?$s_zd:"1";
		$arr_s_zd=explode(",",$s_zd);
		$json_data.="\"s_zd\":\"".$s_zd."\",";
		//组合条件
		if($s_con_time=="day"){
			$sql_time="substring(add_date,1,11)";
			$con_hour=" where action>20 and action<25";
		}else if($s_con_time=="half_day"){
			$sql_time="concat(substring(add_date,1,11),' ',case when substring(add_date,12,2)<13 then '1' when substring(add_date,12,2)<19 then '2' else '3' end)";
			$con_hour=" where action>20 and action<25";
		}else{
			$sql_time="concat(substring(add_date,1,11),'',substring(add_date,12,2))";
			$con_hour=" where action>20 and action<25 and substring(add_date,1,11)='".$s_day."'";
		}
		//取得时间段数据
		$q="select ".$sql_time." as '_t' from ".$table_pre."log_hd".$con_hour." group by _t order by _t";
		$r=$db->query($q);
		$arr_sjd=array();
		$tb_data_x="";
		while($m=$db->fetch_array($r)){
			$arr_sjd[]=$m["_t"];
			$tb_data_x.=deel_date_format($s_con_time,$m["_t"]).",";
		}
		$tb_data_x=deel_end($tb_data_x);
		//取得数据
		$q="select b.iid 'iid',sum(case when b.action in (21,23) then b.num when b.action in (22,24) then -b.num else 0 end) 'num_1',count(distinct b.uid) 'num_2' from ".$table_pre."log_hd b where b.action>20 and b.action<25 group by b.iid order by num_1 desc";
		$r=$db->query($q);
		$i=0;
		$total_num=0;
		$arr_data_js=$arr_data_khs=array();
		while($m=$db->fetch_array($r)){
			//
			$data_tb_v1=$data_tb_v2="";
			for($i1=0;$i1<count($arr_sjd);$i1++){
				$m1=get_db_msg("select sum(case when action in (21,23) then num when action in (22,24) then -num else 0 end) 'num_1',count(distinct uid) 'num_2' from ".$table_pre."log_hd where iid='".$m["iid"]."' and ".$sql_time."<='".$arr_sjd[$i1]."'");
				$data_tb_v1.=add_0($m1["num_1"]).",";
				$data_tb_v2.=add_0($m1["num_2"]).",";
			}
			$arr_data_js[$m["iid"]]=deel_end($data_tb_v1);
			$arr_data_khs[$m["iid"]]=deel_end($data_tb_v2);
			$i++;
		}
		//-----------------------输出数据
		//表头
		$thead="";
		//第一行
		$tr="{\"title\":\"圆牌号\",\"width\":80,\"align\":\"center\",\"rowspan\":2},{\"title\":\"款号\",\"width\":80,\"align\":\"center\",\"rowspan\":2},{\"title\":\"总订量\",\"width\":70,\"align\":\"center\",\"rowspan\":2},";
		for($i=0;$i<count($arr_sjd);$i++){
			$tr.="{\"title\":\"".deel_date_format($s_con_time,$arr_sjd[$i])."\"";
			if(count($arr_s_zd)>1)
				$tr.=",\"colspan\":".count($arr_s_zd).",\"align\":\"center\"";
			$tr.="},";
		}
		$thead.="{\"row\":0,\"tr\":[".deel_end($tr)."]},";
		//第二行
		$tr="";
		for($i=0;$i<count($arr_sjd);$i++){
			for($j=0;$j<count($arr_s_zd);$j++){
				$tr.="{\"title\":\"".get_main_value($arr_zd,$arr_s_zd[$j])."\",\"align\":\"center\"},";
			}
		}
		$thead.="{\"row\":1,\"tr\":[".deel_end($tr)."]}";
		$json_data.="\"thead\":[".$thead."],";
		//计算标准差
		$arr_pc=array();
		$i=0;
		foreach($arr_data_js as $iid => $str_data_js){
			$arr_pc[$iid]=get_pc(explode(",",$str_data_js));
			$i++;
		}
		arsort($arr_pc);
		//内容
		$i=0;
		$hj_total_num=0;
		$data="";
		foreach($arr_pc as $iid => $pc){
			$m_kh=get_db_msg("select no,id,main_pic,color,xh from ".$table_pre."kh where id='".$iid."'");
			if(!$s_no || ($s_no && (strpos(" ".$m_kh["no"],$s_no)!=false))){
				$tmp=get_db_msg("select sum(num) 'num' from ".$table_pre."order where ka<>'y' and iid='".$iid."' and _key='".$_key."'");
				$tmp_total_num=$tmp["num"];
				$hj_total_num+=$tmp_total_num;
				//
				$content1="";
				$arr_tmp_js=explode(",",$arr_data_js[$iid]);
				$arr_tmp_khs=explode(",",$arr_data_khs[$iid]);
				for($i1=0;$i1<count($arr_tmp_js);$i1++){
					$num_1=$arr_tmp_js[$i1];
					$num_2=$arr_tmp_khs[$i1];
					for($j=0;$j<count($arr_s_zd);$j++){
						$var="num_".$arr_s_zd[$j];
						$content1.=",\"num_".$i1."_".$j."\":\"".add_0($$var)."\"";
					}
					$v="hj_".$i1;
					$$v+=$num_1;
				}
				$list=$i+1;
				$tb_data_y="";
				if(in_array("1",$arr_s_zd))
					$tb_data_y.=get_main_value($arr_zd,"1").",".$arr_data_js[$iid]."|";
				if(in_array("2",$arr_s_zd))
					$tb_data_y.=get_main_value($arr_zd,"2").",".$arr_data_khs[$iid]."|";
				$tb_data_y=deel_end($tb_data_y);
				$pic=get_kh_picture($m_kh["no"],$m_kh["main_pic"],$m_kh["color"]);
				$data.="{\"xh\":\"".get_kh_xh($m_kh)."\",\"id\":\"".$m_kh["id"]."\",\"pic\":\"".$pic."\",\"tb_data_y\":\"".$tb_data_y."\",\"kh\":\"".$m_kh["no"]."\",\"total_num\":\"".$tmp_total_num."\"".$content1."},";
				$i++;
			}
		}
		//合计
		$data_tb_v1="";
		$data_tb_v2="";
		$content1="";
		for($i1=0;$i1<count($arr_sjd);$i1++){
			$var="hj_".$i1;
			for($j1=0;$j1<count($arr_s_zd);$j1++){
				if($arr_s_zd[$j1]==1){
					if($i1==0)
						$data_tb_v1.=get_main_value($arr_zd,"1").",";
					$content1.=",\"num_".$i1."_".$j1."\":\"".add_0($$var)."\"";
					$data_tb_v1.=add_0($$var).",";
				}else if($arr_s_zd[$j1]==2){
					if($i1==0)
						$data_tb_v2.=get_main_value($arr_zd,"2").",";
					$m1=get_db_msg("select count(distinct uid) 'num_2' from ".$table_pre."log_hd where action>20 and action<25 and ".$sql_time."<='".$arr_sjd[$i1]."'");
					$content1.=",\"num_".$i1."_".$j1."\":\"".add_0($m1["num_2"])."\"";
					$data_tb_v2.=add_0($m1["num_2"]).",";
				}
			}
		}
		//合计
		$data.="{\"xh\":\"合计\",\"id\":\"0\",\"kh\":\"\",\"total_num\":\"".$hj_total_num."\"".$content1."},";
		//输出表格数据
		$json_data.="\"code\":0,\"msg\":\"\",\"count\":".$i.",\"data\":[".deel_end($data)."],";
		//输出图表数据
		$data_tb_v1=deel_end($data_tb_v1);
		$data_tb_v2=deel_end($data_tb_v2);
		$tb_data_y="";
		if($data_tb_v1)
			$tb_data_y.=$data_tb_v1."|";
		if($data_tb_v2)
			$tb_data_y.=$data_tb_v2."|";
		$tb_data_y=deel_end($tb_data_y);
		$json_data.="\"chart_title\":\"订单趋势图\",";
		$json_data.="\"chart_type\":\"line\",";
		$json_data.="\"chart_data_x\":\"".$tb_data_x."\",";
		$json_data.="\"chart_data_y\":\"".$tb_data_y."\",";
	break;

}
$json_data=substr($json_data,0,-1)."}";
echo $json_data;
?>