";
$sql_con="iid='".$id."' and ";
if($color)
$sql_con.="color='".$color."' and ";
$sql_con=substr($sql_con,0,-4);
$json_data1=$json_data2=$json_data3="";
if($s_group_by=="1"){
//------------------------明细
//表头
$content.="| 客户 | 颜色 | ";
$json_data1.="\"客户\",\"颜色\",";
if($is_gg=="y")
$content.="".d_translate("gg")." | ";
if($bx_sizegroup_id==$msg["size_group"]){
$content.="杯型 | ";
$json_data1.="\"杯型\",";
//
$size_str="";
$r1=$db->query("select * from ".$table_pre."size where iid='".$msg["size_group"]."' order by no");
while($m1=$db->fetch_array($r1)){
$size_str.=$m1["no"].",";
}
if($size_str)
$size_str=substr($size_str,0,-1);
$size=explode(",",$size_str);
}else{
$size=explode(",",$msg["size"]);
}
$tmp1=explode(",",$msg["color"]);
for($l=0;$l".$tmp3["title"]."";
$json_data1.="\"".$tmp3["title"]."\",";
}
$content.="小计 | 订单时间 | ";
$json_data1.="\"小计\",\"订单时间\"";
$q="select * from ".$table_pre."order where ".$sql_con." and _key='".$_key."' order by uid,add_date";
$r=$db->query($q);
$hj=0;
while($m=$db->fetch_array($r)){
$tmp=get_db_msg("select * from ".$table_pre."client where id='".$m["uid"]."'");
$content.="| ".$tmp["title"]."(".$tmp["username"].") | ";
$json_data2.="\"".$tmp["title"]."(".$tmp["username"].")\",";
$content.="".$m["color"]."-".get_cate_title_no("color",$m["color"])." | ";
$json_data2.="\"".$m["color"]."-".get_cate_title_no("color",$m["color"])."\",";
if($bx_sizegroup_id==$msg["size_group"]){
$content.="".$m["bx"]." | ";
$json_data2.="\"".$m["bx"]."\",";
}
if($is_gg=="y"){
$content.="".get_gg_title($m["bx"])." | ";
$json_data2.="\"".get_gg_title($m["bx"])."\",";
}
//尺码列表
$xj=0;
for($l=0;$l".$m["num_".$size[$l]]."";
$json_data2.="\"".$m["num_".$size[$l]]."\",";
}
$content.="".$xj." | ".date("d日 H点i分",$m["add_date"])." | ";
$json_data2.="\"".date("d日 H点i分",$m["add_date"])."\"";
}
//合计
$hj_colspan=($bx_sizegroup_id==$msg["size_group"])?3:2;
if($is_gg=="y")
$hj_colspan++;
$content.="| 合计 | ";
for($l=0;$l".$$v1."";
$json_data3.="\"".$$v1."\",";
}
$json_data3.="\"".$hj."\",\"\"";
$content.="".$hj." | | ";
}else{
//------------------------客户、代理、区域
$arr_show_log_hd=array("23"=>"加量","22"=>"减量","24"=>"删单");
//取得数组
$arr1=array();
$q="select * from ".$table_pre."client where face='".$s_group_by."'";
$r=$db->query($q);
while($m=$db->fetch_array($r)){
if($s_group_by=="4"){
$tmp_sql=" and uid='".$m["id"]."'";
}else{
$p=$m["path"]."-".$m["id"];
$tmp_sql=" and upath like '".$p."-%'";
}
$tmp=get_db_msg("select sum(".get_size_sql("sum").") 'num' from ".$table_pre."order where ".$sql_con.$tmp_sql);
if($tmp["num"]>0)
$arr1[$m["id"]]=$tmp["num"];
}
arsort($arr1);
if($bx_sizegroup_id==$msg["size_group"]){
//
$size_str="";
$r1=$db->query("select * from ".$table_pre."size where iid='".$msg["size_group"]."' order by no");
while($m1=$db->fetch_array($r1)){
$size_str.=$m1["no"].",";
}
if($size_str)
$size_str=substr($size_str,0,-1);
$size=explode(",",$size_str);
}else{
$size=explode(",",$msg["size"]);
}
//表头
$content.="| 序号 | 客户 | ";
if($s_group_by=="4"){
//
foreach($arr_show_log_hd as $k1 => $v1){
$content.="".$v1."
次数 | ";
}
}
for($l=0;$l".$tmp3["title"]."";
}
$content.="小计 | ";
//
$hj=0;
$list=1;
foreach($arr1 as $id1 => $num1){
$hj+=$num1;
$m=get_db_msg("select * from ".$table_pre."client where id='".$id1."'");
if($s_group_by=="4"){
$tmp_sql=" and uid='".$m["id"]."'";
}else{
$p=$m["path"]."-".$m["id"];
$tmp_sql=" and (upath='".$p."' or upath like '".$p."-%')";
}
$tmp=get_db_msg("select ".get_size_sql("sum1")." from ".$table_pre."order where ".$sql_con.$tmp_sql." and _key='".$_key."'");
$content.="| ".$list." | ".$m["title"]."(".$m["username"].") | ";
if($s_group_by=="4"){
foreach($arr_show_log_hd as $k1 => $v1){
//加单次数
$t1=get_db_msg("select count(*) 'num' from ".$table_pre."log_hd where uid='".$m["id"]."' and action='".$k1."'");
$content.="".$t1["num"]." | ";
}
}
for($l=0;$l".$tmp["num_".$size[$l]]."";
//尺码合计
$v1="hj_".$size[$l];
$$v1+=$tmp["num_".$size[$l]];
}
$content.="".$num1." | ";
$list++;
}
//合计
$hj_colspan=($s_group_by=="4")?5:2;
$content.="| 合计 | ";
for($l=0;$l".$$v1."";
}
$content.="".$hj." | ";
}
$json_data.="\"hj_cos\":\"".$hj_colspan."\",\"size\":[".$json_data1."],\"mx\":[".$json_data2."],\"hj\":[".$json_data3."],";
$content.=" |