query($q1); $arr_tmp=array(); while($m1=$db->fetch_array($r1)){ $arr_tmp[$m1["no"]]=$m1["title"]; } $$v2=$arr_tmp; } $content_data=""; //表头第一行 $content_data.=""; foreach($arr_zd4 as $n1 => $t1){ $content_data.=""; } $content_data.=""; $content_data.=""; //表头第二行 $content_data.=""; foreach($arr_zd4 as $n1 => $t1){ foreach($arr_zd5 as $n2 => $t2){ $content_data.=""; } } foreach($arr_zd5 as $n2 => $t2){ $content_data.=""; } $content_data.=""; // $content_data.=""; //-----------取得报表数据 if($tjs=="ks"){ $str1="count(distinct no)"; }else if($tjs=="je"){ $str1="sum(jsje)"; }else{ $str1="sum(num)"; } //订单数据 $q1="select ".$zd1.",".$zd2.",".$zd3.",".$zd4.",".$zd5.",".$str1." 'ks' from ".$table_pre."order where ka<>'y' ".$con." group by ".$zd1.",".$zd2.",".$zd3.",".$zd4.",".$zd5; $r1=$db->query($q1); $arr_data=array(); while($m1=$db->fetch_array($r1)){ $arr_data[$m1[$zd1]][$m1[$zd2]][$m1[$zd3]][$m1[$zd4]][$m1[$zd5]]=$m1["ks"]; } //款号数据 $q1="select ".$zd1.",".$zd2.",".$zd3.",count(*) 'ks' from ".$table_pre."kh where ka<>'y' group by ".$zd1.",".$zd2.",".$zd3; $r1=$db->query($q1); $arr_data1=array(); while($m1=$db->fetch_array($r1)){ $arr_data1[$m1[$zd1]][$m1[$zd2]][$m1[$zd3]]=$m1["ks"]; } //-----------计算rowspan $arr_rowspan_zd1=$arr_rowspan_zd2=array(); $i1=$i2=0; foreach($arr_zd1 as $n1 => $t1){ $xj1=0; foreach($arr_zd2 as $n2 => $t2){ $xj2=0; foreach($arr_zd3 as $n3 => $t3){ if($arr_data1[$n1][$n2][$n3]>0){ $xj1++; $xj2++; } } $arr_rowspan_zd2[$i2]=$xj2; $xj1++; $i2++; } $arr_rowspan_zd1[$i1]=$xj1; $i1++; } //-----------输出报表 $i1=$i2=$i3=0; foreach($arr_zd1 as $n1 => $t1){ foreach($arr_zd2 as $n2 => $t2){ $var_hj_zd2="hj_".$n1."_".$n2; foreach($arr_zd3 as $n3 => $t3){ if($arr_data1[$n1][$n2][$n3]>0){ $content_data.=""; if($i3==count_arr_num_before($arr_rowspan_zd1,$i1)) $content_data.=""; $i3++; } } //---------------zd2合计 $content_data.=""; $i3++; $i2++; } $i1++; } $content_data.="

".$zd_title1."	".$zd_title2."	".$zd_title3."	参与订货 款量	".$t1.$zd_title5."	整体".$zd_title5."
				".$t2."	".$t2."
".$t1.""; if($i3==(count_arr_num_before($arr_rowspan_zd2,$i2)+$i2)) $content_data.="	".$t2.""; $content_data.="	".$t3.""; //小计 $content_data.="	".deel_num($arr_data1[$n1][$n2][$n3]).""; $$var_hj_zd2+=$arr_data1[$n1][$n2][$n3]; foreach($arr_zd4 as $n4 => $t4){ foreach($arr_zd5 as $n5 => $t5){ $var1="zt_".$n1."_".$n2."_".$n3."_".$n5; $var2="zt_".$n1."_".$n2."_".$n5; $var3="zt1_".$n1."_".$n2."_".$n4."_".$n5; $content_data.="	".deel_num($arr_data[$n1][$n2][$n3][$n4][$n5]).""; $$var1+=$arr_data[$n1][$n2][$n3][$n4][$n5]; $$var2+=$arr_data[$n1][$n2][$n3][$n4][$n5]; $$var3+=$arr_data[$n1][$n2][$n3][$n4][$n5]; } } //整体 foreach($arr_zd5 as $n5 => $t5){ $var1="zt_".$n1."_".$n2."_".$n3."_".$n5; $content_data.="	".deel_num($$var1).""; } $content_data.="
".$t2."合计"; //小计 $content_data.="		".deel_num($$var_hj_zd2).""; foreach($arr_zd4 as $n4 => $t4){ foreach($arr_zd5 as $n5 => $t5){ $var1="zt1_".$n1."_".$n2."_".$n4."_".$n5; $content_data.="	".deel_num($$var1).""; } } //整体 foreach($arr_zd5 as $n5 => $t5){ $var1="zt_".$n1."_".$n2."_".$n5; $content_data.="	".deel_num($$var1).""; } $content_data.="

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