'y'";//排除条件 //店铺查询条件 $con=""; if($msg_client["face"]=="4"){ $s_username=$msg_client["username"]; $con=" and uid='".$msg_client["id"]."'"; }else{ if($s_username){ $m2=get_db_msg("select id,face,path from ".$table_pre."client where username='".$s_username."'"); if($m2["face"]=="4"){ $con=" and uid='".$m2["id"]."'"; }else{ $con=" and (upath='".$m2["path"]."-".$m2["id"]."' or upath like '".$m2["path"]."-".$m2["id"]."-%')"; } }else{ if($msg_client["face"]=="2"){ //区经角色所有客户 $con=get_qj_ucon_all($msg_client["charge_path_real"]); }else{ //代理角色所有客户 $con=" and (upath='".$msg_client["path"]."-".$msg_client["id"]."' or upath like '".$msg_client["path"]."-".$msg_client["id"]."-%')"; } } } //取得选项的值 $tmp_arr=array($zd1,$zd2); for($i=0;$iquery($q1); $arr_tmp1=array(); while($m1=$db->fetch_array($r1)){ $arr_tmp1[$m1["no"]]=$m1["title"]; } $$v2=$arr_tmp1; } // $content_data.=""; //----------------取得款号表数据 $arr_kh_data=array(); $q="select ".$zd1.",".$zd2.",count(*) 'ks',sum(price)/count(*) 'jj' from ".$table_pre."kh where ka<>'y'".$con_other.$con_sx." group by ".$zd1.",".$zd2; //echo $q."
"; $r=$db->query($q); while($m=$db->fetch_array($r)){ //取得sku $q1="select color,color_ka from ".$table_pre."kh where ka<>'y'".$con_other.$con_sx." and ".$zd1."='".$m[$zd1]."' and ".$zd2."='".$m[$zd2]."'"; //echo $q1."
"; $r1=$db->query($q1); $tmp_sku=0; while($m1=$db->fetch_array($r1)){ if(trim($m1["color_ka"])) $num1=count(explode(",",$m1["color_ka"])); else $num1=0; $tmp_sku+=count(explode(",",$m1["color"]))-$num1; } // $arr_kh_data[$m[$zd1]][$m[$zd2]]=array($m["ks"],$tmp_sku,$m["jj"]); } //----------------取得订单表数据 $arr_order_data=array(); $q="select ".$zd1.",".$zd2.",count(distinct iid,color) 'sku',max(num) 'num_max',min(num) 'num_min',sum(num)/count(distinct iid,color) 'num_pj' from ".$table_pre."order where id<>'0'".$con_other.$con_sx.$con." group by ".$zd1.",".$zd2; //echo $q."
"; $r=$db->query($q); while($m=$db->fetch_array($r)){ $arr_order_data[$m[$zd1]][$m[$zd2]]=array($m["sku"],deel_num(keep_float($m["num_pj"],1)),deel_num($m["num_max"]),deel_num($m["num_min"])); } //计算第一维度小计，用于计算占比 $var1=$zd1."_arr"; $var2=$zd2."_arr"; $arr_kh_data_xj=array(); $arr_order_date_xj=array(); $total_yd_sku=0; $total_ks=$total_sku=0; foreach($$var1 as $k1=>$v1){ $xj1=$xj2=0; $xj11=$xj12=$xj13=$xj14=$xj15=0; foreach($$var2 as $k2=>$v2){ $xj1+=$arr_kh_data[$k1][$k2][0]; $xj2+=$arr_kh_data[$k1][$k2][1]; $total_ks+=$arr_kh_data[$k1][$k2][0]; $total_sku+=$arr_kh_data[$k1][$k2][1]; $xj11+=$arr_order_data[$k1][$k2][0]; $total_yd_sku+=$arr_order_data[$k1][$k2][0]; } $arr_kh_data_xj[$k1]=array($xj1,$xj2); $arr_order_data_xj[$k1]=array($xj11); } //-----------------------------表头第一行 $var_t1=$zd1."_title"; $var_t2=$zd2."_title"; $content_data.=""; $content_data.=""; $content_data.=""; $content_data.=""; //--------------------输出报表----------------------------------------------- $content_data.=""; $var1=$zd1."_arr"; $var2=$zd2."_arr"; $count=0; foreach($$var1 as $k1 => $v1){ foreach($$var2 as $k2 => $v2){ if($arr_kh_data[$k1][$k2][0]>0){ $content_data.=""; $content_data.=""; $content_data.=""; $count++; } } } $content_data.=""; $content_data.="

".$$var_t1."	".$$var_t2."	开发SKU	开发SKU占比	订货SKU	平均值	最大值	最小值
".$v1."	".$v2."	".deel_0($arr_kh_data[$k1][$k2][1])."	".deel_bfb($arr_kh_data[$k1][$k2][1],$total_sku)."	".deel_0($arr_order_data[$k1][$k2][0])."	".deel_0($arr_order_data[$k1][$k2][1])."	".deel_0($arr_order_data[$k1][$k2][2])."	".deel_0($arr_order_data[$k1][$k2][3])."

"; $json_data.="\"table_html\":\"".$content_data."\","; ?>