query($q1); $arr_tmp=array(); while($m1=$db->fetch_array($r1)){ $arr_tmp[$m1["no"]]=$m1["title"]; } $$v2=$arr_tmp; } $content_data.=""; //第一行 $content_data.=""; $content_data.=""; $content_data.=""; $content_data.=""; //-----------取得款号数据 //订单表数据 $q3="select ".$zd1.",".$zd2.",count(*) 'ks' from ".$table_pre."kh where ka<>'y' group by ".$zd1.",".$zd2; $r3=$db->query($q3); $arr_data_kh=array(); while($m3=$db->fetch_array($r3)){ $arr_data_kh[$m3[$zd1]][$m3[$zd2]]=array($m3["ks"]); } //-----------取得订单数据 $q3="select ".$zd1.",".$zd2.",count(distinct iid) 'ks',sum(num) 'js',sum(jsje) 'je' from ".$table_pre."order where ka<>'y'".$con_other.$con_this." group by ".$zd1.",".$zd2; $r3=$db->query($q3); $arr_data_order=array(); while($m3=$db->fetch_array($r3)){ $arr_data_order[$m3[$zd1]][$m3[$zd2]]=array($m3["je"],$m3["js"],$m3["ks"]); } //--------------------输出报表----------------------------------------------- $content_data.=""; foreach($arr_zd1 as $key1=>$value1){ $xj1=$xj2=$xj3=$xj4=$xj5=$xj6=0; foreach($arr_zd2 as $key2=>$value2){ //取得指标数据 $m_zbxf=get_db_msg("select sum(js) 'js',sum(je) 'je',sum(ks) 'ks' from ".$table_pre."plugin_zbxf2 where key1='".$value1."' and key2='".$value2."'".$con_this); if($arr_data_kh[$key1][$key2][0]>0){ $str_zbje=$str_jewcl=$str_zbjs=$str_jswcl=$str_zbks=$str_kswcl=" "; if($m_zbxf["je"]>0){ $str_zbje=deel_num($m_zbxf["je"]); $str_jewcl=deel_bfb1($arr_data_order[$key1][$key2][0],$m_zbxf["je"],1); } if($m_zbxf["js"]>0){ $str_zbjs=deel_num($m_zbxf["js"]); $str_jswcl=deel_bfb1($arr_data_order[$key1][$key2][1],$m_zbxf["js"],1); } if($m_zbxf["ks"]>0){ $str_zbks=deel_num($m_zbxf["ks"]); $str_kswcl=deel_bfb1($arr_data_order[$key1][$key2][2],$m_zbxf["ks"],1); } $content_data.=""; $content_data.=""; $xj1+=$m_zbxf["je"]; $xj2+=$arr_data_order[$key1][$key2][0]; $xj3+=$m_zbxf["js"]; $xj4+=$arr_data_order[$key1][$key2][1]; $xj5+=$m_zbxf["ks"]; $xj6+=$arr_data_order[$key1][$key2][2]; // $total_1+=$m_zbxf["je"]; $total_2+=$arr_data_order[$key1][$key2][0]; $total_3+=$m_zbxf["js"]; $total_4+=$arr_data_order[$key1][$key2][1]; $total_5+=$m_zbxf["ks"]; $total_6+=$arr_data_order[$key1][$key2][2]; $content_data.=""; } } //小计 $content_data.=""; } $content_data.=""; $content_data.="

".$zd_title1."	".$zd_title2."	指标金额	订货金额	金额完成率	指标数量	订货数量	数量完成率	指标款数	订货款数	款数完成率
".$value1."	".$value2."	".$str_zbje."	".deel_0(deel_num($arr_data_order[$key1][$key2][0]))."	".$str_jewcl."	".$str_zbjs."	".deel_0($arr_data_order[$key1][$key2][1])."	".$str_jswcl."	".$str_zbks."	".deel_0($arr_data_order[$key1][$key2][2])."	".$str_kswcl."
".$value1."小计		".deel_0($xj1)."	".deel_0($xj2)."	".deel_bfb1($xj2,$xj1,1)."	".deel_0($xj3)."	".deel_0($xj4)."	".deel_bfb1($xj4,$xj3,1)."	".deel_0($xj5)."	".deel_0($xj6)."	".deel_bfb1($xj6,$xj5,1)."
合计		".deel_0($total_1)."	".deel_0($total_2)."	".deel_bfb1($total_2,$total_1,1)."	".deel_0($total_3)."	".deel_0($total_4)."	".deel_bfb1($total_4,$total_3,1)."	".deel_0($total_5)."	".deel_0($total_6)."	".deel_bfb1($total_6,$total_5,1)."

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