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;$iquery("select no,title from ".$table_pre."keyword where cate='arr_select'"); while($m1=$db->fetch_array($r1)){ $arr_group_by_title[$m1["no"]]=$m1["title"]; } $arr_group_by_title["size"]="尺码"; $arr_group_by_title["color"]="颜色"; $arr_group_by_title["ks_size"]="款色深度"; // $s_group_by1=$zd1; $s_group_by2=$zd2; //取得已订总件数和金额 $tmp=get_db_msg("select sum(num) 'num',sum(je) 'je' from ".$table_pre."order where id>0".$con); $total_yd_js=$tmp["num"]; $total_yd_je=$tmp["je"]; //--------------------------------表头start $content_data=""; $content_data.=""; $content_data.=""; $content_data.=""; $content_data.=""; //--------------------------------表头end $q1="select * from ".$table_pre."keyword where cate='".$s_group_by1."' order by ord"; $r1=$db->query($q1); $count=$total_num=0; $l=0; while($m1=$db->fetch_array($r1)){ $tmp=get_db_msg("select size_group from ".$table_pre."kh where ".$s_group_by1."='".$m1["no"]."' limit 0,1"); $q="select * from ".$table_pre."size where iid='".$tmp["size_group"]."' order by iid,no"; $r=$db->query($q); // $tmp=get_db_msg("select sum(num) 'num',sum(je) 'je' from ".$table_pre."order where id>0 and ".$s_group_by1."='".$m1["no"]."'".$con); $xj_yd_js=$tmp["num"]; $xj_yd_je=$tmp["je"]; while($m=$db->fetch_array($r)){ $arr1=get_num_je_size_category($m["no"],$s_group_by1,$m1["no"]); $total_num+=$arr1[0]; $total_money+=$arr1[1]; if($arr1[0]>0){ $content_data.=""; $count++; } } $l++; } $content_data.=""; $content_data.=""; $content_data.=""; $content_data.=""; $content_data.="

".get_main_value($arr_group_by_title,$s_group_by1)."	尺码	已订件数	件数占比	吊牌金额	金额占比
".$m1["title"]."	".$m["title"]."	".$arr1[0]."	".deel_bfb($arr1[0],$xj_yd_js)."	".$arr1[1]."	".deel_bfb($arr1[1],$xj_yd_je)."
合计		".$total_num."		".$total_money."

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