"; //print_r($_SERVER["HTTP_REFERER"]); $zd_arr=array("num"=>"订量","je"=>"金额"); if($s_order) $order_by=$s_order." desc"; else $order_by="zsh"; $op=""; foreach($zd_arr as $k => $v){ $op.="{\"no\":\"".$k."\",\"title\":\"".$v."\"},"; //$op.=""; } $select.="{\"name\":\"s_order\",\"title\":\"排序方式\",\"value\":\"".$s_order."\",\"op\":[".deel_end($op)."]},"; //$search_content.=" 默认".$op.""; //取得款色订单数据 $q="select no,color,sum(num) 'num',sum(je) 'je' from ".$table_pre."order group by no,color"; $r=$db->query($q); $arr_order=array(); $total_num=$total_je=0; while($m=$db->fetch_array($r)){ $arr_order[$m["no"]][$m["color"]]=array($m["num"],$m["je"]); $total_num+=$m["num"]; $total_je+=$m["je"]; } //取得数据 $total_cl_num=0; $q1="select zsh,pic,title from ".$table_pre."kh_ty group by zsh order by zsh"; $r1=$db->query($q1); $arr_cl=array(); $i=0; while($m1=$db->fetch_array($r1)){ $arr_cl[$i]["zsh"]=$m1["zsh"]; $arr_cl[$i]["pic"]=$m1["pic"]; $arr_cl[$i]["title"]=$m1["title"]; $tmp_num=$tmp_je=0; //取得搭配 $q2="select kh from ".$table_pre."kh_ty where zsh='".$m1["zsh"]."' order by kh"; $r2=$db->query($q2); $arr_ks_tmp=array(); while($m2=$db->fetch_array($r2)){ //取得款号 $q3="select kh,color from ".$table_pre."kh_dp where title='".$m2["kh"]."'"; $r3=$db->query($q3); while($m3=$db->fetch_array($r3)){ if(!in_array($m3["kh"]."|".$m3["color"],$arr_ks_tmp)) $arr_ks_tmp[]=$m3["kh"]."|".$m3["color"]; } } for($i1=0;$i10?$arr_order[$arr_tmp[0]][$arr_tmp[1]][0]:0; $tmp_num+=$num1; $je1=$arr_order[$arr_tmp[0]][$arr_tmp[1]][1]>0?$arr_order[$arr_tmp[0]][$arr_tmp[1]][1]:0; $tmp_je+=$je1; } $arr_cl[$i]["num"]=$tmp_num; $arr_cl[$i]["je"]=$tmp_je; $total_cl_num++; $i++; } $content.=""; $content.=""; $content.=""; $content.=""; $content.=""; // $list=1; for($i=0;$i"; $content.=""; $list++; } $content.="

序号	陈列号	陈列图	陈列名称	订量	订货金额	款数	款色数
合计	共".$total_cl_num."组			".$total_num."	".$total_je."
".$arr_cl[$i]["zsh"]."		".$arr_cl[$i]["title"]."	".$arr_cl[$i]["num"]."	".$arr_cl[$i]["je"]."	".$tmp_ks["ks"]."	".$tmp_ks["skc"]."

"; $json_data.="\"table_html\":\"".$content."\","; //echo $content; //include template("order_list_js"); //exit; //} function get_kh_ty_mini($clh){ global $order_session; $s_dir=$order_session?$order_session."/":""; $pic="../attachments/ty/mini/".$clh.".jpg"; if(!is_file($pic)){ $pic="images/no_pic.png"; } return $pic; } ?>