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.=""; $content_data.=""; $content_data.=""; //-----------取得报表数据 $total_yd_je=$total_yd_js=$total_yd_ks=0; //订单表数据 $q3="select ".$zd1.",count(distinct iid) 'ks',sum(num) 'js',sum(jsje) 'je' from ".$table_pre."order where ka<>'y'".$con_other.$con_this." group by ".$zd1; $r3=$db->query($q3); $arr_data_je=$arr_data_js=$arr_data_ks=array(); while($m3=$db->fetch_array($r3)){ $arr_data_je[$m3[$zd1]]=deel_num($m3["je"]); $arr_data_js[$m3[$zd1]]=$m3["js"]; $arr_data_ks[$m3[$zd1]]=$m3["ks"]; $total_yd_je+=$m3["je"]; $total_yd_js+=$m3["js"]; $total_yd_ks+=$m3["ks"]; } //sku $q3="select ".$zd1.",color,color_ka from ".$table_pre."kh where ka<>'y'"; $r3=$db->query($q3); $arr_data_sku=array(); while($m3=$db->fetch_array($r3)){ if(trim($m3["color_ka"])) $num1=count(explode(",",$m3["color_ka"])); else $num1=0; $arr_data_sku[$m3[$zd1]]+=count(explode(",",$m3["color"]))-$num1; } //总历史数据 $tmp=get_db_msg("select sum(js) 'js',sum(je) 'je',sum(ks) 'ks' from ".$table_pre."plugin_ls1 where c1<>''".$con_this); $total_ls_je=$tmp["je"]; $total_ls_js=$tmp["js"]; $total_ls_ks=$tmp["ks"]; //--------------------输出报表----------------------------------------------- $content_data.=""; foreach($arr_zd1 as $key1=>$value1){ //取得指标数据 $m_ls=get_db_msg("select sum(js) 'js',sum(je) 'je',sum(ks) 'ks' from ".$table_pre."plugin_ls1 where c1='".$value1."'".$con_this); if($arr_data_sku[$key1]>0){ $content_data.=""; $content_data.=""; $total_1+=$m_ls["ks"]; $total_2+=$m_ls["js"]; $total_3+=$m_ls["je"]; $total_4+=$arr_data_ks[$key1]; $total_5+=$arr_data_js[$key1]; $total_6+=$arr_data_je[$key1]; $content_data.=""; $count++; } } $content_data.=""; $content_data.="

".$zd_title1."	往年销售			实际订单				差异
	销售款数	销售件数	销售金额	订单款数	订单件数	订单金额	金额占%	款数差异	件数差异	金额差异
".$value1."	".deel_0($m_ls["ks"])."	".deel_0($m_ls["js"])."	".deel_0($m_ls["je"])."	".deel_0($arr_data_ks[$key1])."	".deel_0($arr_data_js[$key1])."	".deel_0($arr_data_je[$key1])."	".deel_bfb($arr_data_je[$key1],$total_yd_je)."	".deel_0($m_ls["ks"]-$arr_data_ks[$key1])."	".deel_0($m_ls["js"]-$arr_data_js[$key1])."	".deel_0($m_ls["je"]-$arr_data_je[$key1])."
合计	".deel_0($total_1)."	".deel_0($total_2)."	".deel_0($total_3)."	".deel_0($total_4)."	".deel_0($total_5)."	".deel_0($total_6)."	100%	".deel_0($total_1-$total_4)."	".deel_0($total_2-$total_5)."	".deel_0($total_3-$total_6)."

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