EDT/pc/tmpl/order_tm_export.php

<?php
//-----------------------------------------------------后台->订单条码导出
$s_key=$s_key?$s_key:$_key;
$sql_con.="ka<>'y' and ";
$sql_con.="_key='".$_key."' and ";
//构建店铺条件
$con_u="";
$yh="";
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<count($arr_username);$i++){
		//检查是否存在
		$m_client=get_db_msg("select * from ".$table_pre."client where username='".$arr_username[$i]."'");
		//
		if($m_client["id"]){
			if($m_client["face"]=="4"){
				$con_u.=" (uid='".$m_client["id"]."') or ";
			}else{
				$con_u.=" (upath='".$m_client["path"]."-".$m_client["id"]."' or upath like '".$m_client["path"]."-".$m_client["id"]."-%') or ";
			}
			$yh.=$m_client["username"].",";
		}
	}
}
if($con_u)
	$sql_con.="(".substr($con_u,0,-3).") and ";
if($sql_con)
	$sql_con="where ".substr($sql_con,0,-4);
if($yh)
	$yh=substr($yh,0,-1);
//取得店铺框
$js_function=get_client_autocompelete("","n")."\n";
$js_function.="$(function() { 
						$('#s_username').autocomplete(clients, { 
						max: 100, //列表里的条目数 
						minChars: 0, //自动完成激活之前填入的最小字符 
						width: 300, //提示的宽度，溢出隐藏 
						scrollHeight: 300, //提示的高度，溢出显示滚动条 
						matchContains: true, //包含匹配，就是data参数里的数据，是否只要包含文本框里的数据就显示 
						autoFill: false, //自动填充 
						multiple:true,
						multipleSeparator:',',
						formatItem: function(row, i, max) { 
							return row.t+'('+row.u+')'; 
						}, 
						formatMatch: function(row, i, max) { 
							return row.t + row.u; 
						}, 
						formatResult: function(row) { 
							return row.u; 
						} 
						}).result(function(event, row, formatted) {
							$('#s_username').value=row.u;
						}); 
						});";
$search_content.="店铺:<input type=text name=\"s_username\" id=\"s_username\" style=\"width:300px\" value=\"".$s_username."\">";
$search_content.=" <input type=submit value=\"提交\" class=\"button_act\"> ";
if($con_u){
	//开始导出数据
	$dump="\t\t\t[2]S\t[3]M\t[4]L\t[5]XL\t[6]XXL\t[8]XXXL\r\n";
	$dump.="\t\t\t[7]FF\r\n";
	$dump.="\t\t\t35\t36\t37\t38\t39\t40\t41\t42\t43\t44\r\n";
	$dump.="\t\t\t[1]XS\t[2]S\t[3]M\t[4]L\t[5]XL\t[6]XXL\t[8]XXXL\r\n";
	//$arr_size_merged=get_size_merged();
	//$num_size_total=count($arr_size_merged);
	$query="select iid,no,color,sum(num_1) 'num_1',sum(num_2) 'num_2',sum(num_3) 'num_3',sum(num_4) 'num_4',sum(num_5) 'num_5',sum(num_6) 'num_6' from ".$table_pre."order ".$sql_con." group by no,color order by no";
	//echo $query."<br>";
	$res=$db->query($query);
	while($m=$db->fetch_array($res)){
		//$m_kh=get_db_msg("select * from ".$table_pre."kh where id='".$m["iid"]."'");
		//$tmp=get_db_msg("select * from ".$table_pre."size where iid='".$m_kh["size_group"]."' and no='".$i."'");
		$m_category=get_db_msg("select * from ".$table_pre."keyword where no='".$m["category"]."' and cate='category'");
		//$m_season=get_db_msg("select * from ".$table_pre."keyword where cate='season' and no='".$m_kh["season"]."'");
		$dump.=$m["no"]."\t".$m["color"]."\t".$m_category["title"]."\t".$m["color"]."\t".$m["num_1"]."\t".$m["num_2"]."\t".$m["num_3"]."\t".$m["num_4"]."\t".$m["num_5"]."\t".$m["num_6"]."\r\n";
	}
	//
	$filename="bj_".$m_client["title"].".xls";
	$mime_type=ereg('MSIE ([0-9].[0-9]{1,2})',$_SERVER['HTTP_USER_AGENT'])||ereg('Opera(/| )([0-9].[0-9]{1,2})',$_SERVER['HTTP_USER_AGENT'])?"application/octetstream":"application/octet-stream";
	header("Content-Type:".$mime_type);
	header('Content-Disposition: attachment; filename="'.$filename.'"');
	echo $dump;
//导出BSERP明细
}else if($s_username=="cocoon"){
	//明细表
	$dump="客户\t客户代码\t款号\t颜色代码\t尺码\t数量\t吊牌价\t折扣\t金额\r\n";
	$arr_size_merged=get_size_merged();
	$num_size_total=count($arr_size_merged);
	$query="select * from ".$table_pre."order where ka<>'y'";
	//echo $query."<br>";
	$res=$db->query($query);
	while($m=$db->fetch_array($res)){
		$m_client=get_db_msg("select * from ".$table_pre."client where id='".$m["uid"]."'");
		for($i=1;$i<11;$i++){
			if($m["num_".$i]>0){
				$tmp_size=get_db_msg("select * from web_size where no=".$i." and iid=".$m["size_group_id"]);
				$zk=get_zk($m_client["id"],$m["category"])/100;
				if($zk=="") $zk=1;
				$je=$m["num_".$i]*$m["price"]*$zk;
				$dump.=$m_client["title"]."\t".$m_client["username"]."\t".$m["no"]."\t".$m["color"]."\t".$tmp_size["title"]."\t".$m["num_".$i]."\t".$m["price"]."\t".$zk."\t".$je."\r\n";
			}
		}
	}
	//主表
	//$dump.="CREATE TABLE #EDTORDER(DJBH VARCHAR(25),DJRQ DATE,KHDM VARCHAR(25),DJLX INT);\r\n";
	//$z_query="select uid,sum(num) num,sum(je) bzje,sum(jsje) je from ".$table_pre."order group by uid order by uid";
	//$djbh=100;
	//$z_res=$db->query($z_query);
	//while($z_m=$db->fetch_array($z_res)){
	//	$zm_client=get_db_msg("select * from ".$table_pre."client where id='".$z_m["uid"]."'");
	//	$djbh=$djbh+1;
	//	$dump.="INSERT INTO #EDTORDER(DJBH,KHDM,NUM,JE,BZJE,ZK) VALUES ('DHJedt".$djbh."','".$zm_client["username"]."',".$z_m["num"].",".$z_m["je"].",".$z_m["bzje"].",".($zm_client["zk"]/100).");\r\n";
	//}
	//插入到伯俊ERP表
	//$dump.="INSERT INTO DHJRD(DJBH,RQ,DJXZ,DM1,DM2,DM2_1,DM4,QDDM,YGDM,SL,JE,BZJE,ZDR,BZ,BYZD1,BYZD8,BYZD9,BYZD12)(SELECT DJBH,GETDATE(),'0',KHDM,1,0,201304,0,0,NUM,JE,BZJE,'系统管理员','EDT导入',3,1,0.3,ZK From #EDTORDER);\r\n";
	//$dump.="INSERT INTO DHJRDMX(DJBH,SPDM,GG1DM,GG2DM,SL,CKJ,ZK,DJ,DJ_1,JE)(SELECT B.DJBH,A.KH,A.COLOR,A.SIZE,A.NUM,A.PRICE,A.ZK,A.PRICE*A.ZK,A.PRICE,A.NUM*A.PRICE*A.ZK FROM #EDTORDERMX A INNER JOIN #EDTORDER B ON A.KHDM=B.KHDM);";
	$filename="mxhx_".date("YmdHis").".txt";
	//$mime_type=ereg('MSIE ([0-9].[0-9]{1,2})',$_SERVER['HTTP_USER_AGENT'])||ereg('Opera(/| )([0-9].[0-9]{1,2})',$_SERVER['HTTP_USER_AGENT'])?"application/octetstream":"application/octet-stream";
	header("Content-Type:".$mime_type);
	header('Content-Disposition: attachment; filename="'.$filename.'"');
	echo $dump;
}else{
	include template("report");
}
?>