";
//-------------------处理尺码表头
//取得合并尺码
$arr_size_merged=get_size_merged();
$num_size_total=count($arr_size_merged);
//取得尺码合计sql
$sql_sum_num="";
for($k=0;$k<$num_size_total;$k++){
$sql_sum_num.="sum(num_".$arr_size_merged[$k].") 'num_".$arr_size_merged[$k]."',";
}
//取得尺码表头内容
$num_size_group=0;
$size_tr=array();
$r1=$db->query("select * from ".$table_pre."keyword where cate='size' order by ord");
while($m1=$db->fetch_array($r1)){
$size_tr[$num_size_group]="";
for($i=1;$i<=$num_size_total;$i++){
$tmp=get_db_msg("select title from ".$table_pre."size where iid='".$m1["id"]."' and no='".$i."'");
$t=$tmp["title"]?$tmp["title"]:" ";
$size_tr[$num_size_group].="| ".$t." | ";
}
$num_size_group++;
}
//-------------------/处理尺码表头结束
$_tbody.="| 区域 | 代理 | 客户名称 | 客户代码 | 款号 | ";
//取得定制选项
$q="select * from ".$table_pre."keyword where cate='arr_select' and flag_ka='y' and no<>'jgd' and no<>'sx' order by ord";
$r=$db->query($q);
$num_dz=0;
while($m=$db->fetch_array($r)){
$_tbody.="".get_cate_title_no("arr_select",$m["no"])." | ";
$num_dz++;
}
$_tbody.="单价 | 颜色 | 颜色代码 | ".$size_tr[0]."小计 | 金额（元） |
";
for($i=1;$i<$num_size_group;$i++){
$_tbody.="".$size_tr[$i]."
";
}
$sql_con="where ka<>'y'".$u_sql;
$q="select * from ".$table_pre."order ".$sql_con." order by uid,no,color";
//echo $q."
";
$r=$db->query($q);
$count=0;
while($m=$db->fetch_array($r)){
$m1=get_db_msg("select * from ".$table_pre."kh where id='".$m["iid"]."'");
$m3=get_db_msg("select * from ".$table_pre."client where id='".$m["uid"]."'");
$arr_p=explode("-",$m3["path"]);
//取得区域
$tmp=get_db_msg("select title from ".$table_pre."client where id='".$arr_p[1]."'");
$qy=$tmp["title"];
//取得代理
$tmp=get_db_msg("select title from ".$table_pre."client where id='".$arr_p[count($arr_p)-1]."'");
$dl=$tmp["title"];
$num=0;
$td_size1="";
for($k=0;$k<$num_size_total;$k++){
$num+=$m["num_".$arr_size_merged[$k]];
$td_size1.="".$m["num_".$arr_size_merged[$k]]." | ";
}
if($num>0){
$money=$num*$m1["price"];
$total_num+=$num;
$total_money+=$money;
$_tbody.="| ".$qy." | ".$dl." | ".$m3["title"]." | ".$m3["username"]." | ".$m1["no"]." | ";
//取得定制选项
$q4="select * from ".$table_pre."keyword where cate='arr_select' and flag_ka='y' and no<>'jgd' and no<>'sx' order by ord";
$r4=$db->query($q4);
while($m4=$db->fetch_array($r4)){
if($m4["no"]=="zd1" || $m4["no"]=="zd2" || $m4["no"]=="zd3")
$_tbody.="".$m1[$m4["no"]]." | ";
else
$_tbody.="".get_cate_title_no($m4["no"],$m1[$m4["no"]])." | ";
}
$_tbody.="".$m1["price"]." | ".get_cate_title_no("color",$m["color"])." | ".$m["color"]." | ".$td_size1."".$num." | ".$money." |
";
$count++;
}
}
$_tbody.="| 合计 | ".deel_td($total_num)." | ".deel_td($total_money)." |
";
$_tbody.="
";
return $_tbody;
}
//-------------------------------mysql connect
//导出数据
$con_u="";
if($s_username){
$s_username=str_replace("，",",",$s_username);
//去掉最后一个逗号
if(substr($s_username,strlen($s_username)-1,1)==",")
$s_username1=substr($s_username,0,-1);
else
$s_username1=$s_username;
$arr_username=explode(",",$s_username1);
//去掉重复值
$arr_username=array_unique($arr_username);
for($i=0;$i