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.=""; //表头第二行 $arr_zd5=array(1=>"订货会款量",2=>"订货款量",3=>"款占比",4=>"订量",5=>"订量占比",6=>"订货额",7=>"订额占比",8=>"均价"); $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.=""; //-----------取得报表数据 $total_js=$msg_login["order_num"]; $total_je=$msg_login["order_money"]; $c1=get_db_msg("select count(distinct no) 'ks' from ".$table_pre."order where _key='".$s_key."'".$con.""); $total_ks=$c1["ks"]; //订货款数，件数，金额 $q1="select ".$zd1.",".$zd2.",".$zd3.",".$zd4.",count(distinct no) 'ks',sum(num) 'js',sum(je) 'je' from ".$table_pre."order where _key='".$s_key."'".$con." group by ".$zd1.",".$zd2.",".$zd3.",".$zd4; $r1=$db->query($q1); $arr_data_ks=$arr_data_js=$arr_data_je=array(); while($m1=$db->fetch_array($r1)){ $arr_data_ks[$m1[$zd1]][$m1[$zd2]][$m1[$zd3]][$m1[$zd4]]=$m1["ks"]; $arr_data_js[$m1[$zd1]][$m1[$zd2]][$m1[$zd3]][$m1[$zd4]]=$m1["js"]; $arr_data_je[$m1[$zd1]][$m1[$zd2]][$m1[$zd3]][$m1[$zd4]]=$m1["je"]; } //订货会款数 $q1="select ".$zd1.",".$zd2.",".$zd3.",".$zd4.",count(*) 'ks' from ".$table_pre."kh where ka<>'y' group by ".$zd1.",".$zd2.",".$zd3.",".$zd4; $r1=$db->query($q1); $arr_data_all_ks=array(); while($m1=$db->fetch_array($r1)){ $arr_data_all_ks[$m1[$zd1]][$m1[$zd2]][$m1[$zd3]][$m1[$zd4]]=$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_data_xj_ks=array(); while($m1=$db->fetch_array($r1)){ $arr_data_xj_ks[$m1[$zd1]][$m1[$zd2]][$m1[$zd3]]=$m1["ks"]; } //小计款数1 $q1="select ".$zd1.",".$zd2.",count(*) 'ks' from ".$table_pre."kh where ka<>'y' group by ".$zd1.",".$zd2; $r1=$db->query($q1); $arr_data_xj_ks1=array(); while($m1=$db->fetch_array($r1)){ $arr_data_xj_ks1[$m1[$zd1]][$m1[$zd2]]=$m1["ks"]; } //均价 $q1="select ".$zd1.",".$zd2.",".$zd3.",".$zd4.",sum(price)/count(*) 'jj' from ".$table_pre."kh where ka<>'y' group by ".$zd1.",".$zd2.",".$zd3.",".$zd4; $r1=$db->query($q1); $arr_data_jj=array(); while($m1=$db->fetch_array($r1)){ $arr_data_jj[$m1[$zd1]][$m1[$zd2]][$m1[$zd3]][$m1[$zd4]]=$m1["jj"]; } //小计均价 $q1="select ".$zd1.",".$zd2.",".$zd3.",sum(price)/count(*) 'jj' from ".$table_pre."kh where ka<>'y' group by ".$zd1.",".$zd2.",".$zd3; $r1=$db->query($q1); $arr_data_xj_jj=array(); while($m1=$db->fetch_array($r1)){ $arr_data_xj_jj[$m1[$zd1]][$m1[$zd2]][$m1[$zd3]]=$m1["jj"]; } //整体均价 $q1="select ".$zd1.",".$zd2.",".$zd4.",sum(price)/count(*) 'jj' from ".$table_pre."kh where ka<>'y' group by ".$zd1.",".$zd2.",".$zd4; $r1=$db->query($q1); $arr_data_zt_jj=array(); while($m1=$db->fetch_array($r1)){ $arr_data_zt_jj[$m1[$zd1]][$m1[$zd2]][$m1[$zd4]]=$m1["jj"]; } //合计均价 $q1="select ".$zd1.",".$zd2.",sum(price)/count(*) 'jj' from ".$table_pre."kh where ka<>'y' group by ".$zd1.",".$zd2; $r1=$db->query($q1); $arr_data_hj_jj=array(); while($m1=$db->fetch_array($r1)){ $arr_data_hj_jj[$m1[$zd1]][$m1[$zd2]]=$m1["jj"]; } //-----------计算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_data_xj_ks[$n1][$n2][$n3]>0){ $xj1++; $xj2++; } } $arr_rowspan_zd2[$i2]=$xj2; if($arr_data_xj_ks1[$n1][$n2]>0){ $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_all_ks="hj_all_ks_".$n1."_".$n2; $var_hj_ks="hj_ks_".$n1."_".$n2; $var_hj_js="hj_js_".$n1."_".$n2; $var_hj_je="hj_je_".$n1."_".$n2; foreach($arr_zd3 as $n3 => $t3){ $var_xj_ks="xj_ks_".$n1."_".$n2."_".$n3; $var_xj_js="xj_js_".$n1."_".$n2."_".$n3; $var_xj_je="xj_je_".$n1."_".$n2."_".$n3; if($arr_data_xj_ks[$n1][$n2][$n3]>0){ $content_data.=""; if($i3==count_arr_num_before($arr_rowspan_zd1,$i1)) $content_data.=""; if($i3==(count_arr_num_before($arr_rowspan_zd2,$i2)+$i2)) $content_data.=""; $content_data.=""; foreach($arr_zd4 as $n4 => $t4){ $var_all_ks="all_ks_".$n1."_".$n2."_".$n4; $var_ks="ks_".$n1."_".$n2."_".$n4; $var_js="js_".$n1."_".$n2."_".$n4; $var_je="je_".$n1."_".$n2."_".$n4; //订货会款数 $content_data.=""; //已订款数 $content_data.=""; //款数占比 $content_data.=""; //已订件数 $content_data.=""; //件数占比 $content_data.=""; //已订金额 $content_data.=""; //金额占比 $content_data.=""; //均价 $content_data.=""; $$var_all_ks+=$arr_data_all_ks[$n1][$n2][$n3][$n4]; $$var_ks+=$arr_data_ks[$n1][$n2][$n3][$n4]; $$var_js+=$arr_data_js[$n1][$n2][$n3][$n4]; $$var_je+=$arr_data_je[$n1][$n2][$n3][$n4]; // $$var_xj_ks+=$arr_data_ks[$n1][$n2][$n3][$n4]; $$var_xj_js+=$arr_data_js[$n1][$n2][$n3][$n4]; $$var_xj_je+=$arr_data_je[$n1][$n2][$n3][$n4]; // $$var_hj_ks+=$arr_data_ks[$n1][$n2][$n3][$n4]; $$var_hj_js+=$arr_data_js[$n1][$n2][$n3][$n4]; $$var_hj_je+=$arr_data_je[$n1][$n2][$n3][$n4]; $$var_hj_all_ks+=$arr_data_all_ks[$n1][$n2][$n3][$n4]; } //------------整体 //订货会款数 $content_data.=""; //已订款数 $content_data.=""; //款数占比 $content_data.=""; //已订件数 $content_data.=""; //件数占比 $content_data.=""; //已订金额 $content_data.=""; //金额占比 $content_data.=""; //均价 $content_data.=""; $content_data.=""; $i3++; } } if($arr_data_xj_ks1[$n1][$n2]>0){ //---------------zd2合计 $content_data.=""; foreach($arr_zd4 as $n4 => $t4){ $var_all_ks="all_ks_".$n1."_".$n2."_".$n4; $var_ks="ks_".$n1."_".$n2."_".$n4; $var_js="js_".$n1."_".$n2."_".$n4; $var_je="je_".$n1."_".$n2."_".$n4; //订货会款数 $content_data.=""; //已订款数 $content_data.=""; //款数占比 $content_data.=""; //已订件数 $content_data.=""; //件数占比 $content_data.=""; //已订金额 $content_data.=""; //金额占比 $content_data.=""; //均价 $content_data.=""; } //------------整体 //订货会款数 $content_data.=""; //已订款数 $content_data.=""; //款数占比 $content_data.=""; //已订件数 $content_data.=""; //件数占比 $content_data.=""; //已订金额 $content_data.=""; //金额占比 $content_data.=""; //均价 $content_data.=""; $content_data.=""; $i3++; $i2++; } } $i1++; } $content_data.="

".$zd_title1."	".$zd_title2."	".$zd_title3."	".$t1."								总计
			".$t2."	".$t2."
".$t1."	".$t2."	".$t3."	".deel_0($arr_data_all_ks[$n1][$n2][$n3][$n4])."	".deel_0($arr_data_ks[$n1][$n2][$n3][$n4])."	".deel_bfb($arr_data_ks[$n1][$n2][$n3][$n4],$total_ks)."	".deel_0($arr_data_js[$n1][$n2][$n3][$n4])."	".deel_bfb($arr_data_js[$n1][$n2][$n3][$n4],$total_js)."	".deel_0(deel_num($arr_data_je[$n1][$n2][$n3][$n4]))."	".deel_bfb($arr_data_je[$n1][$n2][$n3][$n4],$total_money)."	".keep_float($arr_data_jj[$n1][$n2][$n3][$n4],1)."	".deel_0($arr_data_xj_ks[$n1][$n2][$n3])."	".deel_0($$var_xj_ks)."	".deel_bfb($$var_xj_ks,$total_ks)."	".deel_0($$var_xj_js)."	".deel_bfb($$var_xj_js,$total_js)."	".deel_0(deel_num($$var_xj_je))."	".deel_bfb($$var_xj_je,$total_money)."	".keep_float($arr_data_xj_jj[$n1][$n2][$n3],1)."
".$t2."合计		".deel_0($$var_all_ks)."	".deel_0($$var_ks)."	".deel_bfb($$var_ks,$total_ks)."	".deel_0($$var_js)."	".deel_bfb($$var_js,$total_js)."	".deel_0(deel_num($$var_je))."	".deel_bfb($$var_je,$total_money)."	".keep_float($arr_data_zt_jj[$n1][$n2][$n4],1)."	".deel_0($$var_hj_all_ks)."	".deel_0($$var_hj_ks)."	".deel_bfb($$var_hj_ks,$total_ks)."	".deel_0($$var_hj_js)."	".deel_bfb($$var_hj_js,$total_js)."	".deel_0(deel_num($$var_hj_je))."	".deel_bfb($$var_hj_je,$total_money)."	".keep_float($arr_data_hj_jj[$n1][$n2],1)."

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