<?php
//-----------------------------------------------------后台->订单打印->明细单

//--------------条件定制
/*
$arr_zd=array(
	"xh",//圆牌号
	"kh",//款号
	"title",//款式名称
	"brand",
	"series",
	"theme",
	"season",
	"bc",
	"sxz",
	"category",
	"category1",
	"kh_dj",
	"designer",
	"zd1",
	"zd2",
	"zd3",
	"remark",//备注
	"color",//颜色代码
	"color_title",//颜色名称
	"bx",
	"size",//尺码
	"num",//数量
	"dpj",//吊牌价
	"je",//吊牌金额
	"zk",//折扣
	"jsj",//结算价
	"jsje"//结算金额
);
*/
//显示字段
$arr_zd=array("xh","kh","brand","bc","color","color_title","size","xs","num");
//排序
$con_order="no";
//可筛选字段
//$search_zd="brand";
$search_zd="";
//语言翻译
$arr_lang=array(
	"title"=>"款式名",
	"color"=>"颜色代码",
	"color_title"=>"颜色",
	"remark"=>"备注",
	"size"=>"尺码明细",
	"dpj"=>"吊牌价",
	"num"=>"小计",
	"xs"=>"箱数",
	"je"=>"吊牌金额",
	"zk"=>"折扣",
	"bx"=>"版型",
	"jsj"=>"结算价",
	"jsje"=>"结算金额"
);
//--------------
$print_not_qr=get_set("print_not_qr");
$is_brand=get_set("is_brand");
//查询条件定制
$s_ka="n";
$s_key=$_key;
$con=" and ka<> 'y'";
$var="s_".$search_zd;
if($$var){
	$con.=" and ".$search_zd."='".$$var."'";
	$con_select=" and ".$search_zd."='".$$var."'";
}else{
	$con_select="";
}
if($search_zd=="brand"){
	$con_brand=" and ".$search_zd."='".$$var."'";
}else{
	$con_brand="";
}
//杯型参数
if($bx_sizegroup_title){
	$tmp=get_db_msg("select id from ".$table_pre."keyword where cate='size' and title='".$bx_sizegroup_title."' limit 0,1");
	$bx_sizegroup_id=$tmp["id"];
}else{
	$bx_sizegroup_id=0;
}
$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);
	$confirm_str=$confirm_str1=$p_title=$error="";
	for($i=0;$i<count($arr_username);$i++){
		//检查是否存在
		$m_client=get_db_msg("select * from ".$table_pre."client where username='".$arr_username[$i]."'");
		if($is_brand=="y"){
			$m_client_brand=get_db_msg("select is_checked from ".$table_pre."client_brand where cid='".$m_client["id"]."'".$con_brand." order by is_checked limit 0,1");
			$is_checked=$m_client_brand["is_checked"];
		}else{
			$is_checked=$m_client["is_checked"];
		}
		//
		if($m_client["id"]){
			if($m_client["face"]=="4"){
				$con_u.=" (uid='".$m_client["id"]."') or ";
				if($is_checked!="y"){
					$confirm_str.=$arr_username[$i]."(未确认),";
					$confirm_str1.=$arr_username[$i].",";
				}else{
					$confirm_str.=$arr_username[$i]."(已确认),";
				}
			}else{
				$con_u.=" (upath='".$m_client["path"]."-".$m_client["id"]."' or upath like '".$m_client["path"]."-".$m_client["id"]."-%') or ";
			}
			$p_title.=$m_client["title"]."(".$m_client["username"]."),";
		}else{
			$error.=$arr_username[$i].",";
		}
	}
}
//
$con_u_exp="";
if($s_username_exp){
	$s_username_exp=str_replace("，",",",$s_username_exp);
	//去掉最后一个逗号
	if(substr($s_username_exp,strlen($s_username_exp)-1,1)==",")
		$s_username_exp1=substr($s_username_exp,0,-1);
	else
		$s_username_exp1=$s_username_exp;
	$arr_username_exp=explode(",",$s_username_exp1);
	//去掉重复值
	$arr_username_exp=array_unique($arr_username_exp);
	$title_exp="";
	for($i=0;$i<count($arr_username_exp);$i++){
		//检查是否存在
		$m_client_exp=get_db_msg("select id,title from ".$table_pre."client where username='".$arr_username_exp[$i]."'");
		//
		if($m_client_exp["id"]){
			$con_u_exp.=" (uid<>'".$m_client_exp["id"]."') and ";
			$title_exp.=$m_client_exp["title"].",";
		}
	}
}
if($con_u)
	$con.=" and (".substr($con_u,0,-3).") ";
if($con_u_exp)
	$con.=" and (".substr($con_u_exp,0,-4).") ";
if($confirm_str)
	$confirm_str=substr($confirm_str,0,-1);
$json_code.="\"code\":1,";
$json_data.="\"s_username\":\"".$s_username."\",";
$json_data.="\"s_username_exp\":\"".$s_username_exp."\",";
$data_tmp="";
if($search_zd){
	$json_data.="\"search_zd\":\"".$search_zd."\",";
	$var="s_".$search_zd;
	$json_data.="\"search_zd_value\":\"".$$var."\",";
	//取得选项
	$q="select no,title from ".$table_pre."keyword where cate='".$search_zd."' order by no";
	$r=$db->query($q);
	$op="";
	while($m=$db->fetch_array($r)){
		$op.="{\"no\":\"".$m["no"]."\",\"title\":\"".$m["title"]."\"},";
	}
	$json_data.="\"search_zd_op\":[".deel_end($op)."],";
}
if($confirm_str)
	$json_data.="\"confirm_str\":\"".$confirm_str."\",";//订单确认提示
if($sub=="yes"){
	$sys_client_title=get_set("sys_client_title");
	$dl=get_dl_title($m_client["path"]);
	$title_dl=$dl?$dl."-":"";
	if($title_exp)
		$title_exp="，不含".substr($title_exp,0,-1);
	$title_sub=$title_dl.substr($p_title,0,-1).$title_exp."明细单 ".date("Y年m月d日 H点i分");
	//
	$json_data.="\"print_not_qr\":\"".$print_not_qr."\",";
	$json_data.="\"not_confirm_username\":\"".$confirm_str1."\",";
	//头部信息
	$html_print_top="<div style='font-size:20px;font-weight:bold;line-height:30px;'>".$sys_client_title."</div>";
	$html_print_top.="<div style='font-size:16px;font-weight:bold;line-height:30px;'>".$title_sub."</div>";
	$json_data.="\"print_top\":\"".$html_print_top."\",";
	//-------------------处理尺码表头
	//取得合并尺码
	$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"]:"&nbsp;";
			$size_tr[$num_size_group].="{\"title\":\"".$t."\",\"align\":\"center\",\"width\":30},";
			$thead_tmp.="";
		}
		$arr_size_merged[]=$m1["no"];
		$num_size_group++;
	}
	//----输出表头
	$thead="";
	$thead_tmp="";
	for($i=0;$i<count($arr_zd);$i++){
		if($arr_zd[$i]=="kh"){
			$thead_tmp.="{\"title\":\"款号\",\"rowspan\":\"".$num_size_group."\"},";
		}else if($arr_zd[$i]=="xh"){
			$thead_tmp.="{\"title\":\"".d_translate($arr_zd[$i])."\",\"rowspan\":\"".$num_size_group."\",\"width\":50},";
		}else if($arr_zd[$i]=="xs"){
			$thead_tmp.="{\"title\":\"箱数\",\"rowspan\":\"".$num_size_group."\",\"width\":40},";
		}else if($arr_zd[$i]=="num"){
			$thead_tmp.="{\"title\":\"数量\",\"rowspan\":\"".$num_size_group."\",\"width\":40},";
		}else if($arr_zd[$i]=="title" || $arr_zd[$i]=="remark" || $arr_zd[$i]=="color" || $arr_zd[$i]=="color_title" || $arr_zd[$i]=="dpj" || $arr_zd[$i]=="je" || $arr_zd[$i]=="zk" || $arr_zd[$i]=="bx" || $arr_zd[$i]=="jsj" || $arr_zd[$i]=="jsje"){
			$w=($arr_zd[$i]=="jsj" || $arr_zd[$i]=="jsje" || $arr_zd[$i]=="dpj" || $arr_zd[$i]=="je" || $arr_zd[$i]=="zk")?",\"width\":50":"";
			$thead_tmp.="{\"title\":\"".get_main_value($arr_lang,$arr_zd[$i])."\",\"rowspan\":\"".$num_size_group."\"".$w."},";
		}else if($arr_zd[$i]=="size"){
			//尺码明细
			$thead_tmp.=$size_tr[0];
		}else{
			//keyword表
			$thead_tmp.="{\"title\":\"".get_cate_title_no("arr_select",$arr_zd[$i])."\",\"rowspan\":\"".$num_size_group."\"},";
		}
	}
	$thead.="{\"ind\":0,\"content\":[".deel_end($thead_tmp)."]},";
	for($i=1;$i<$num_size_group;$i++){
		$thead.="{\"ind\":".$i.",\"content\":[".deel_end($size_tr[$i])."]},";
	}
	$json_data.="\"thead\":[".deel_end($thead)."],";
	//----------------------------------------------取得订单记录
	$sys_size_num=get_max_size_num();
	$q="select iid,color,bx,uid,upath,dl,qy,sum(num) 'num',sum(je) 'je',sum(jsje) 'jsje',".get_size_sql("sum1")." from ".$table_pre."order where _key='".$s_key."'".$con." group by iid,color,bx order by ".$con_order;
	//echo $q."<br>";
	$r=$db->query($q);
	$total_xs=$total_num=$total_je=$total_jsje=0;
	$total_record=0;
	while($m=$db->fetch_array($r)){
		if($m["num"]>0){
			$m_kh=get_db_msg("select * from ".$table_pre."kh where id='".$m["iid"]."'");
			$arr_kh_size=explode(",",$m_kh["size"]);
			$q4="select * from ".$table_pre."order_pm where uid='".$m["uid"]."' and iid='".$m["iid"]."' and color='".$m["color"]."' and bx='".$m["bx"]."' order by color";
			//echo $q4."<br>";
			$r4=$db->query($q4);
			while($m4=$db->fetch_array($r4)){
				$m_pm=get_db_msg("select * from ".$table_pre."size_pm where id='".$m4["pmid"]."'");
				$arr_pm=explode(":",$m_pm["gz"]);
				$arr_pm1=tz_pm($arr_kh_size,$arr_pm);
				$str_tmp="";
				for($i=0;$i<count($arr_zd);$i++){
					if($arr_zd[$i]=="title" || $arr_zd[$i]=="remark" || $arr_zd[$i]=="zd1" || $arr_zd[$i]=="zd2" || $arr_zd[$i]=="zd3"){
						$str_tmp.="{\"title\":\"".$m_kh[$arr_zd[$i]]."\"},";
					}else if($arr_zd[$i]=="dpj"){
						$str_tmp.="{\"title\":\"".$m_kh["price"]."\"},";
					}else if($arr_zd[$i]=="kh"){
						$str_tmp.="{\"title\":\"".$m_kh["no"]."\"},";
					}else if($arr_zd[$i]=="xh"){
						$xh=get_kh_xh($m_kh,$m["color"]);
						$str_tmp.="{\"title\":\"".$xh."\"},";
					}else if($arr_zd[$i]=="xs"){
						$str_tmp.="{\"title\":\"".$m4["xs"]."\",\"align\":\"right\"},";
						$total_xs+=$m4["xs"];
					}else if($arr_zd[$i]=="num"){
						$str_tmp.="{\"title\":\"".($m_pm["num"]*$m4["xs"])."\",\"align\":\"right\"},";
						$total_num+=$m_pm["num"]*$m4["xs"];
					}else if($arr_zd[$i]=="color_title"){
						$str_tmp.="{\"title\":\"".get_cate_title_no("color",$m["color"])."\"},";
					}else if($arr_zd[$i]=="bx" || $arr_zd[$i]=="color"){
						$str_tmp.="{\"title\":\"".$m[$arr_zd[$i]]."\"},";
					}else if($arr_zd[$i]=="je" || $arr_zd[$i]=="jsje"){
						$str_tmp.="{\"title\":\"".deel_0(deel_num($m[$arr_zd[$i]]))."\",\"align\":\"right\"},";
					}else if($arr_zd[$i]=="jsj"){
						//结算价
						$jsj=0;
						if($m["num"]>0){
							$jsj=deel_num(keep_float($m["jsje"]/$m["num"],1));
						}
						$str_tmp.="{\"title\":\"".$jsj."\"},";
					}else if($arr_zd[$i]=="zk"){
						$zk=deel_num(keep_float($m["jsje"]/$m["je"],2));
						$str_tmp.="{\"".$arr_zd[$i]."\":\"".$zk."\"},";
					}else if($arr_zd[$i]=="size"){
						//尺码明细
						for($k=1;$k<=$num_size_total;$k++){
							$v1="hj_num_".$k;
							$tmp_num=$arr_pm1[$k];
							$str_tmp.="{\"title\":\"".deel_0($tmp_num)."\"},";
							$$v1+=$tmp_num;
						}
					}else{
						//keyword表
						$str_tmp.="{\"title\":\"".get_cate_title_no($arr_zd[$i],$m_kh[$arr_zd[$i]])."\"},";
					}
				}
				
				//$total_je+=$m["je"];
				//$total_jsje+=$m["jsje"];
				$data_tmp.="{\"ind\":".$total_record.",\"content\":[".deel_end($str_tmp)."]},";
				$total_record++;
			}
		}
	}
	//-----------合计行
	//计算尺码所在index
	$size_index=0;
	for($i=0;$i<count($arr_zd);$i++){
		if($arr_zd[$i]=="size")
			$size_index=$i;
	}
	if($size_index==0){
		//计算num所在index
		$num_index=0;
		for($i=0;$i<count($arr_zd);$i++){
			if($arr_zd[$i]=="num")
				$num_index=$i;
		}
		if($num_index>0){
			//没有尺码，但是有小计
			$colspan=$num_index;
			//
			$str_tmp="{\"title\":\"合计\",\"colspan\":".$colspan.",\"align\":\"right\"},";
			$str_tmp.="{\"title\":\"".$total_num."\",\"align\":\"right\"},";
			for($i=$num_index+1;$i<count($arr_zd);$i++){
				if($arr_zd[$i]=="jsje" || $arr_zd[$i]=="je" || $arr_zd[$i]=="num" || $arr_zd[$i]=="xs"){
					$var="total_".$arr_zd[$i];
					$str_tmp.="{\"title\":\"".$$var."\",\"align\":\"right\"},";
				}else{
					$str_tmp.="{\"title\":\"&nbsp;\"},";
				}
			}
			$data_tmp.="{\"ind\":".$total_record.",\"content\":[".deel_end($str_tmp)."]},";
		}
	}else{
		$colspan=$size_index;
		//
		$str_tmp="{\"title\":\"合计\",\"colspan\":".$colspan.",\"align\":\"right\"},";
		for($k1=1;$k1<=$num_size_total;$k1++){
			$v1="hj_num_".$k1;
			$str_tmp.="{\"title\":\"".deel_0($$v1)."\"},";
		}
		for($i=$size_index+1;$i<count($arr_zd);$i++){
			if($arr_zd[$i]=="jsje" || $arr_zd[$i]=="je" || $arr_zd[$i]=="num" || $arr_zd[$i]=="xs"){
				$var="total_".$arr_zd[$i];
				$str_tmp.="{\"title\":\"".$$var."\",\"align\":\"right\"},";
			}else{
				$str_tmp.="{\"title\":\"&nbsp;\"},";
			}
		}
		$data_tmp.="{\"ind\":".$total_record.",\"content\":[".deel_end($str_tmp)."]},";
	}
	$json_data.="\"tbody\":[".deel_end($data_tmp)."],";
	$json_data.="\"tbody_num\":".$total_record.",";
}

?>