query($sql_select); while($msg_select=$db->fetch_array($res_select)){ $str_op.="{\"no\":\"".$msg_select["no"]."\",\"title\":\"".$msg_select["title"]."\"},"; } $str_select.="{\"name\":\"".$arr_val."\",\"title\":\"".get_cate_title_no("arr_select",$arr_val)."\",\"value\":\"".$$arr_val."\",\"op\":[".substr($str_op,0,-1)."]},"; } } } $json_data.="\"select_report\":[".substr($str_select,0,-1)."],"; //end //-------------------------条件 //-------con为web_order //-------con1为web_kh $con=$con1=""; if($searh_select1!="s_ka" && $searh_select2!="s_ka" && $searh_select3!="s_ka"){ //没有删除款搜索时 $con.=" and ka<>'y' "; $con1.=" and ka<>'y' "; }else{ if($s_ka){ $con.=" and ka='".$s_ka."' "; $con1.=" and ka='".$s_ka."' "; } } if($searh_select1!="s_spk" && $searh_select2!="s_spk" && $searh_select3!="s_spk"){ //没有饰品款搜索时 $con.=" and is_sp<>'y' "; $con1.=" and is_sp<>'y' "; }else{ if($s_spk){ $con.=" and is_sp='".$s_spk."' "; $con1.=" and is_sp='".$s_spk."' "; } } if($s_key){ if($s_key=="all"){ $con.=""; }else{ $con.=" and _key='".$s_key."'"; } } //其他 for($i=0;$i''".$con1; $r2=$db->query($q2); while($m2=$db->fetch_array($r2)){ $arr1=explode(",",$m2["color"]); $arr2=explode(",",$m2["color_ka"]); for($i1=0;$i1'' ".$con; $tmp=get_db_msg($q); $total_yd_js=$tmp["num"]; $total_yd_je=$tmp["je"]; //取得已订总款色数 $tmp1=get_db_msg("select count(distinct no,color) 'num' from ".$table_pre."order where ".$s_group_by."<>'' ".$con); $total_yd_sku=$tmp1["num"]; // $content_data=""; $content_data.=""; $content_data.=""; $content_data.=""; $content_data.=""; $content_data.=""; // $tb_data_x=""; $tb_data_y=","; // $tbody_str=""; $q="select * from ".$table_pre."keyword where cate='".$s_group_by."' order by no"; $r=$db->query($q); $count=$total_num=$total_money=0; while($m=$db->fetch_array($r)){ $list=$count+1; $gtitle=get_cate_title_no($s_group_by,$m[$s_group_by]); //取得设计款色 $tmp=get_db_msg("select * from ".$table_pre."sx where no='".$m["no"]."'"); $arr_color=explode(",",$tmp["_v"]); $n1=0; for($i1=0;$i10 and ".$s_group_by."='".$m["no"]."'".$con); $tmp_yd_js=$tmp["num"]; $tmp_yd_je=$tmp["je"]; // $content_data.=""; $count++; // $tb_data_x.=$m["title"].","; $tb_data_y.=str_replace("%","",deel_bfb($tmp_yd_js,$total_yd_js)).","; } $content_data.=""; $content_data.=""; $content_data.=""; $content_data.=""; $content_data.="

色系	设计款色		已订款色		已订件数		吊牌金额
	款数	占比	款数	占比	件数	占比	金额	占比
".$m["title"]."	".deel_01($tmp_sku)."	".deel_bfb($tmp_sku,$total_sku)."	".deel_01($tmp_yd_sku)."	".deel_bfb($tmp_yd_sku,$total_yd_sku)."	".deel_01($tmp_yd_js)."	".deel_bfb($tmp_yd_js,$total_yd_js)."	".deel_01($tmp_yd_je)."	".deel_bfb($tmp_yd_je,$total_yd_je)."
合计	".$total_sku."		".$total_yd_sku."		".$total_yd_js."		".$total_yd_je."

"; //图 $tb_data_y=deel_end($tb_data_y); $tb_data_x=deel_end($tb_data_x); $json_data.="\"chart_title\":\"\","; $json_data.="\"chart_type\":\"pie\","; $json_data.="\"chart_data_x\":\"".$tb_data_x."\","; $json_data.="\"chart_data_y\":\"".$tb_data_y."\","; } $json_data.="\"table_html\":\"".$content_data."\","; ?>