";
$sql_con="iid='".$khid."' and _key='".$sys_this_order_flag."' and ";
if($color)
$sql_con.="color='".$color."' and ";
$sql_con=substr($sql_con,0,-4);
$size=explode(",",$m_kh["size"]);
if($s_group_by=="1"){
//------------------------明细
$con_dp_o="";
if($dpid){
$m1=get_db_msg("select id,path,title,username from ".$table_pre."client where id='".$dpid."'");
$p1=$m1["path"]."-".$m1["id"];
$con_dp_o.=" and uid='".$m1["id"]."'";
$content.="
";
$q="select * from ".$table_pre."order where ".$sql_con.$con_dp_o." order by uid,color,add_date";
$r=$db->query($q);
$hj=$count=0;
while($m=$db->fetch_array($r)){
$tmp=get_db_msg("select username,title from ".$table_pre."client where id='".$m["uid"]."'");
$m_kh=get_db_msg("select no,color,color_ka from ".$table_pre."kh where id='".$m["iid"]."'");
$arr_color_ka=explode(",",$m_kh["color_ka"]);
$flag_ka=(in_array($m["color"],$arr_color_ka))?"(已删除)":"";
$content.="
";
}else{
//------------------------店铺、代理、区域
$con_dp=$con_dp_o="";
if($s_group_by=="4"){
if($s_sj){
$m1=get_db_msg("select id,path,title,username from ".$table_pre."client where id='".$s_sj."'");
$p1=$m1["path"]."-".$m1["id"];
$con_dp.=" and (path='".$p1."' or path like '".$p1."-%')";
$con_dp_o.=" and (upath='".$p1."' or upath like '".$p1."-%')";
$content.="
".$m1["title"]."(".$m1["username"].")
";
}
}
//取得数组
$arr1=array();
$q="select * from ".$table_pre."client where face='".$s_group_by."'".$con_dp;
$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.$con_dp_o);
//if($tmp["num"]>0)
$arr1[$m["id"]]=$tmp["num"];
}
arsort($arr1);
$content.="