'y'";//排除条件 $sys_size_num=get_max_size_num(); // $tmp_arr=array(); for($i=0;$iquery($q1); $arr_tmp1=array(); while($m1=$db->fetch_array($r1)){ $arr_tmp1[$m1["no"]]=$m1["title"]; } $$v2=$arr_tmp1; } //店铺查询条件 $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"]."-%')"; } } //----------------构建筛选条件 $q="select * from ".$table_pre."keyword where cate='arr_select' and flag_ka='y'"; $r=$db->query($q); $con_sx=""; while($m=$db->fetch_array($r)){ $var1="s_".$m["no"]; if($$var1) $con_sx.=" and ".$m["no"]."='".$$var1."'"; } if($s_is_sp) $con_sx.=" and is_sp='".$s_is_sp."'"; // //----------------取得款号表数据 $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)){ $arr_kh_data[$m[$zd1]][$m[$zd2]]=array($m["ks"]); } for($i1=0;$i1query($q); while($m=$db->fetch_array($r)){ $arr_size[$m["no"]]=$m["title"]; } if(count($arr_size)>0){ //----------------取得订单表数据 $max_size=get_max_size_num(); $arr_order_data=array(); $q="select ".get_size_sql("sum1").",size_group_id,".$zd1.",".$zd2.",sum(num) 'num' from ".$table_pre."order where size_group_id='".$this_size_group_id."'".$con_other.$con_sx.$con." group by ".$zd1.",".$zd2; //echo $q."
"; $r=$db->query($q); while($m=$db->fetch_array($r)){ $tmp_arr=array(); for($i=1;$i<=$max_size;$i++){ $tmp_arr[$i]=$m["num_".$i]; } $tmp_arr["num"]=$m["num"]; $arr_order_data[$m[$zd1]][$m[$zd2]]=$tmp_arr; } //计算第一维度小计，用于计算占比 $var1=$zd1."_arr"; $var2=$zd2."_arr"; $arr_kh_data_xj=array(); $arr_order_date_xj=array(); $total_yd_sku=$total_yd_js=0; $total_ks=$total_sku=0; for($i=1;$i<=$max_size;$i++){ $var="total_".$i; $$var=0; } foreach($$var1 as $k1=>$v1){ $xj1=0; for($i=1;$i<=$max_size;$i++){ $var="xj1".$i; $$var=0; } $xj_num=0; foreach($$var2 as $k2=>$v2){ $xj1+=$arr_kh_data[$k1][$k2][0]; $total_ks+=$arr_kh_data[$k1][$k2][0]; for($i=1;$i<=$max_size;$i++){ $var="xj1".$i; $$var+=$arr_order_data[$k1][$k2][$i]; $var="total_".$i; $$var+=$arr_order_data[$k1][$k2][$i]; $total_yd_js+=$arr_order_data[$k1][$k2][$i]; } $xj_num+=$arr_order_data[$k1][$k2]["num"]; } $arr_kh_data_xj[$k1]=array($xj1); $arr_tmp=array(); for($i=1;$i<=$max_size;$i++){ $var="xj1".$i; $arr_tmp[$i]=$$var; } $arr_tmp["xj_num"]=$xj_num; $arr_order_data_xj[$k1]=$arr_tmp; } //print_r($arr_order_data); //print_r($arr_order_data_xj); //echo "

"; $content_data.="

".$arr_size_group[$i1]."尺码

"; if($total_yd_js>0){ $content_data.=""; //-----------------------------表头第一行 $var_t1=$zd1."_title"; $var_t2=$zd2."_title"; $content_data.=""; $content_data.=""; foreach($arr_size as $k1 => $v1){ $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){ if($arr_order_data_xj[$k1]["xj_num"]>0){ $content_data.=""; $content_data.=""; foreach($arr_size as $size1 => $s_title1){ $content_data.=""; } $content_data.=""; $count++; } } } if($arr_order_data_xj[$k1]["xj_num"]>0){ //小计 $content_data.=""; foreach($arr_size as $size1 => $s_title1){ $content_data.=""; } $content_data.=""; } } $content_data.=""; foreach($arr_size as $k1 => $v1){ $var="total_".$k1; $content_data.=""; } $content_data.=""; $content_data.=""; $content_data.="

".$$var_t1."	".$$var_t2."	".$v1."占比
".$v1."	".$v2."	".deel_bfb($arr_order_data[$k1][$k2][$size1],$arr_order_data[$k1][$k2]["num"])."
".$v1."小计		".deel_bfb($arr_order_data_xj[$k1][$size1],$arr_order_data_xj[$k1]["xj_num"])."
合计		".deel_bfb($$var,$total_yd_js)."

"; }else{ $content_data.="

无订量!

"; } }else{ $content_data.="

".$arr_size_group[$i1]."，无尺码数据!

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