<?php
//-------------------------------单款订货
/*
店铺和区经角色
*/
header("Content-type: text/html; charset=utf-8");
$json_data="{";
if(THIS_IN!="edt_ipad")
	exit("错误的访问!");

$uid=check_cookie_jxs();
//系统变量
$sys_close=get_set("sys_close");
$sys_close_image=get_set("sys_close_image");
$is_session=get_set("is_session");
$zb_type=get_set("zb_type");
$is_spk=get_set("is_spk");
$zbxf=get_set("zbxf");
$zbxf_type=get_set("zbxf_type");
$sys_ms=get_set("sys_ms");
$is_msg=get_set("is_msg");
$is_ewm=get_set("is_ewm");
$is_window="y";
$zk_type=get_set("zk_type");
$is_hd_log=get_set("is_hd_log");
$xh_ms=get_set("xh_ms");
$order_session=get_set("order_session");
$sys_size_num=get_max_size_num();
$theme_path=get_theme_path();

$is_sy=get_set("is_sy");

$bs_kh_dj=get_set("bs_kh_dj");
$json_data.="\"bs_kh_dj\":\"".$bs_kh_dj."\",";

$tmpl_m3_lie=6;
$tmpl_m3_pic_width=100;
$tmpl_m3_pic_height=100;
$tmpl_m3_cl_pic_width=400;
$tmpl_m3_cl_pic_height=300;
$json_data.="\"sys_ver_hy\":\"".$sys_ver_hy."\",";

//$db=_mysql_connect();
$msg_login=get_db_msg("select * from ".$table_pre."client where id='".$uid."'");
if($msg_login["available"]!="y"){
	$json_data.="\"error\":\"用户已被禁用\",\"code\":0,\"msg\":\"\",\"count\":0,\"data\":[],";
}else{
	$json_data.="\"face\":\"".$msg_login["face"]."\",";
	$json_data.="\"uid\":\"".$msg_login["id"]."\",";
	$json_data.="\"username\":\"".$msg_login["username"]."\",";
	$json_data.="\"is_sy\":\"".$is_sy."\",";

	$s_key=$s_key?$s_key:$_key;
	$rurl=$rurl?$rurl:get_this_url();
	$check_md=get_db_msg("select count(*) 'num' from ".$table_pre."kh_md");
	$zb_client_show=get_set("zb_client_show");
	if($zb_client_show=="y")
		$arr_zb_type=explode(",",$zb_type);
	else
		$arr_zb_type=array();
	$is_brand=is_brand();
	$show_jd=get_set("show_jd");
	$is_dkds=get_set("is_dkds");
	$is_multi_price=get_set("is_multi_price");
	$order_close=get_set("order_close");
	$search_type=get_set("search_type");


	$json_data.="\"show_jd\":\"".$show_jd."\",";
	$json_data.="\"is_dkds\":\"".$is_dkds."\",";
	$json_data.="\"is_brand\":\"".$is_brand."\",";
	$json_data.="\"is_multi_price\":\"".$is_multi_price."\",";


	if($is_brand=="y")
		$link_var_brand="&s_brand=".$s_brand;
	else
		$link_var_brand="";
	$title_brand=$con_brand="";
	if($s_brand){
		$arr_s_brand=explode(",",$s_brand);
		for($i=0;$i<count($arr_s_brand);$i++){
			$con_brand.="brand='".$arr_s_brand[$i]."' or ";
			$title_brand.=get_cate_title_no("brand",$arr_s_brand[$i]).",";
		}
		if($title_brand)
			$title_brand=substr($title_brand,0,-1);
		if($con_brand)
			$con_brand=" and (".substr($con_brand,0,-3).")";
	}
	//取得选项
	$arr_select_no=array();
	$arr_select_title=array();
	$q="select no,title from ".$table_pre."keyword where cate='arr_select' and flag_ka='y' and flag_bd='n' and no<>'sx' and no<>'zd1' and no<>'zd2' and no<>'zd3' order by ord";
	$r=$db->query($q);
	while($m=$db->fetch_array($r)){
		$arr_select_no[]=$m["no"];
		$arr_select_title[]=$m["title"];
	}
	//文胸
	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;
	}
	//童装
	if($child_sizegroup_title){
		$tmp=get_db_msg("select id from ".$table_pre."keyword where cate='size' and title='".$child_sizegroup_title."' limit 0,1");
		$child_sizegroup_id=$tmp["id"];
	}else{
		$child_sizegroup_id=0;
	}
	$con_spk=($is_spk=="y")?" and is_sp<>'y'":"";
	$flag_spk=($is_spk=="y")?"1":"";
	//------------------------------------包含定制模块,店铺界面，顶部已订数和完成率的显示
	//include_once $path_dz."/dp/wcl.php";
	//
	//--------------交单按钮
	$jd_password=get_set("jd_password");
	if($is_brand<>"y"){
		$tmp=$msg_login;
		$is_jd=$msg_login["is_jd"];
		$is_checked=$msg_login["is_checked"];
	}else{
		$tmp=get_db_msg("select is_jd from ".$table_pre."client_brand where cid='".$uid."'".$con_brand." order by is_jd limit 0,1");
		$is_jd=$tmp["is_jd"];
		$tmp=get_db_msg("select is_checked from ".$table_pre."client_brand where cid='".$uid."'".$con_brand." order by is_checked limit 0,1");
		$is_checked=$tmp["is_checked"];
	}
	if($show_jd=="y"){
		if($is_jd=="y")
			$jd_button="已交单|";
		if($is_checked=="y")
			$jd_button="已确认|";
		if($is_brand=="y"){
			$jd_button="交单|go_url('".$_SERVER[PHP_SELF]."?_m=".$_m."&_a=o&s_tab=wcl')";
		}else{
			if($is_jd!="y" && $is_checked!="y")
				$jd_button="交单|do_jd('".$jd_password."','".$_SERVER[PHP_SELF]."?_m=".$_m."&_a=jd".$link_var_brand."')";
		}
	}else{

		$jd_button="|";
	}
	//计算订货规则按钮
	$tmp=get_db_msg("select count(*) 'num' from ".$table_pre."gz where dj='' or dj='".$msg_login["dj"]."'");
	if($tmp["num"]>0)
		$menu_dhgz="订货规则";
	else
		$menu_dhgz="";


	switch($_a){
		case "single":
			$w2=$tmpl_m3_pic_width;
			$h2=$tmpl_m3_pic_height;
			$cl_lie=$tmpl_m3_lie;
			$s_con=$s_con?$s_con:$s_con_default;
			$rurl=$rurl?$rurl:get_this_url();
			$json_data.="\"w2\":\"".$w2."\",";
			$json_data.="\"h2\":\"".$h2."\",";
			$json_data.="\"cl_lie\":\"".$cl_lie."\",";
			//$json_data.="\"rurl\":\"".$rurl."\",";
			if($zsh){
				$s_zsh=$zsh;
			}
			$msg_err="";
			$kl=strlen($s_title);
			if($kl<=3 && $s_title && is_numeric($s_title)){
				$sql_con="where xh='".$s_title."'";
			}
			if($kl>=3){
				if(is_numeric($s_title)){
					$sql_con="where xh='".$s_title."' or no like '%".$s_title."%'";
				}else{
					$sql_con="where  no like '%".$s_title."%'";
				}
			}
			if($s_title){
				$msg=get_db_msg("select * from ".$table_pre."kh ".$sql_con);
				$m1=get_db_msg("select count(*) 'num' from ".$table_pre."kh ".$sql_con);
				$json_data.="\"khid\":\"".$msg["id"]."\",";
				$json_data.="\"s_title\":\"".$s_title."\",";
				$id=$msg["id"];
				$str_title="";
				if($m1["num"]>1){
					$q2="select * from ".$table_pre."kh ".$sql_con;
					$r2=$db->query($q2);
					while($m2=$db->fetch_array($r2)){
						$str_title.="{\"khid\":\"".$m2["id"]."\",\"title\":\"".$m2["xh"]."#".$m2["no"]."\"},";
					}
					if($msg_err){
						$str_title=deel_end($str_title);
						$msg_err="存在以下符合条件的多个款:".$msg_err;
					}
				}
				//
				if(!$id){
					$msg_err="记录不存在";
				}
			}
			if($msg_err){
				if($str_title){
					$json_data.="\"code\":101,";
					$json_data.="\"msg\":[".$str_title."],";
				}else{
					$json_data.="\"code\":102,";
					$json_data.="\"msg\":\"".$msg_err."\",";
				}
			}else{
				$json_data.="\"code\":100,";
				if($s_zsh){
					$sql_con.=" where zsh='".$s_zsh."' and ";
					$s_no="";
				}
				$sql_con=substr($sql_con,0,-4);
				//取得总设计款数
				$tmp=get_db_msg("select count(*) 'num' from ".$table_pre."kh where ka<>'y'");
				$total_ks=$tmp["num"];
				//取得已订总款数
				if($msg_login["face"]=="4"){
					$tmp=get_db_msg("select count(distinct(iid)) 'num' from ".$table_pre."order where uid='".$uid."' and _key='".$_key."'");
				}
				if($msg_login["face"]=="2"){
					$tmp=get_db_msg("select count(distinct(iid)) 'num' from ".$table_pre."order where ka<>'y' and _key='".$_key."' ".get_qj_ucon_all_dpid($msg_login["charge_uid"],""));
				}
				$total_yd_ks=$tmp["num"];
				//定制条件
				$query="select * from ".$table_pre."kh_cl where zsh='".$s_zsh."' group by kh,color order by ord";
				//echo $query."<br>";
				$res=$db->query($query);
				$style_title_color=get_set("style_title_color");
				$ka_color=get_set("ka_color");
				$pic_background=get_set("pic_background");
				$pic_background=$pic_background?$pic_background:"#ffffff";
				$content_set="[\"".$pic_background."\"]";

				$json_data.="\"content_set\":\"".$pic_background."\",";
				$json_data.="\"style_title_color\":\"".$style_title_color."\",";
				$json_data.="\"ka_color\":\"".$ka_color."\",";
				$num_arr="";
				$strarr="";

				$count=0;
				$rnum=0;
				$zks=$ydjs=$ydks=0;
				$content_list="";
				$title=$cljs="";
				$clp="";
				while($msg1=$db->fetch_array($res)){
					$clp=$msg1["pic"];
					$title=$msg1["title"];
					$cljs=htmlspecialchars($msg1["remark"]);
					$msg=get_db_msg("select * from ".$table_pre."kh where no='".$msg1["kh"]."'");
					if($msg["id"]>0){
						if($msg["ka"]=="y"){
							$c=get_set("ka_color");
						}else{
							$c=get_set_value_dote($style_title_color,$msg["kh_dj"]);
						}
						//图片获取规则
						$pic=get_kh_color_picture($msg["no"],$msg1["color"],$flag_pad_offline);
						if($msg_login["face"]=="4"){
							$n1=deel_num(get_order_num_kh_color($msg["id"],$msg1["color"]));
						}
						if($msg_login["face"]=="2"){
							$tmp=get_db_msg("select sum(num) 'num' from ".$table_pre."order where ka<>'y' and _key='".$_key."' and iid='".$msg["id"]."' and color='".$msg1["color"]."' ".get_qj_ucon_all_dpid($msg_login["charge_uid"],""));
							$n1=deel_num($tmp["num"]);
						}
						//$content_list.="".$msg["id"].",".$msg1["ord"].",\"".get_kh_xh($msg,$msg1["color"])."\",\"".$msg["no"]."\",\"".$msg1["color"]."\",\"".get_cate_title_no("color",$msg1["color"])."\",".deel_num(get_price_dp($uid,$msg["id"])).",\"".$pic."\",\"".str_replace("\"","'",out_good_pic_set($pic,$w2,$h2))."\",".$n1.",\"".$c."\",";
						$tmppic=out_good_pic_set_arr($pic,$w2,$h2);
						$content_list.="{\"id\":\"".$msg["id"]."\",\"kh_dj\":\"".get_cate_title_no("kh_dj",$msg["kh_dj"])."\",\"ord\":\"".$msg1["ord"]."\",\"yph\":\"".get_kh_xh($msg,$msg1["color"])."\",\"kh\":\"".$msg["no"]."\",\"color\":\"".$msg1["color"]."\",\"color_title\":\"".get_cate_title_no("color",$msg1["color"])."\",\"price\":\"".deel_num(get_price_dp($uid,$msg["id"]))."\",\"pic\":\"".$pic."\",\"pic_w\":".$tmppic[0].",\"pic_h\":".$tmppic[1].",\"ydj\":".$n1.",\"c\":\"".$c."\"},";
						$rnum++;
						$count++;
						//计算已订款数
						if($msg_login["face"]=="4"){
							$tmp=get_db_msg("select count(*) 'num' from ".$table_pre."order where uid='".$uid."' and iid='".$msg["id"]."' and color='".$msg1["color"]."' and ka<>'y' and _key='".$_key."'");
							if($tmp["num"]>0)
								$ydks++;
						}
						if($msg_login["face"]=="2"){
							if($n1>0)
								$ydks++;
						}

						//计算总款数
						$zks++;
						//计算已订件数
						if($msg_login["face"]=="4"){
							$tmp=get_db_msg("select sum(".get_size_sql("sum").") 'num' from ".$table_pre."order where uid='".$uid."' and iid='".$msg["id"]."' and color='".$msg1["color"]."' and ka<>'y' and _key='".$_key."'");
							$ydjs+=$tmp["num"];
						}
						if($msg_login["face"]=="2"){
							$ydjs+=$n1;
						}
					}
				}
				$content_list=substr($content_list,0,-1);
				$json_data.="\"cls\":[".$content_list."],";
				$json_data.="\"title\":\"".$title."\",";
				$json_data.="\"cljs\":\"".$cljs."\",";
				$json_data.="\"zk\":\"".$total_ks."\",";
				$json_data.="\"zydk\":\"".$total_yd_ks."\",";
				$json_data.="\"bzk\":\"".$zks."\",";
				$json_data.="\"bzydk\":\"".$ydks."\",";
				$json_data.="\"bzydj\":\"".$ydjs."\",";
				$json_data.="\"total\":\"".add_0($count)."\",";
				//上一组、下一组
				$pre_xh=get_db_msg("select zsh from ".$table_pre."kh_cl where zsh<'".$s_zsh."' order by zsh desc limit 0,1");
				$next_xh=get_db_msg("select zsh from ".$table_pre."kh_cl where zsh>'".$s_zsh."' order by zsh limit 0,1");
				$str_sxk="[\"".$pre_xh["zsh"]."\",\"".$next_xh["zsh"]."\"]";
				$json_data.="\"prev\":\"".$pre_xh["zsh"]."\",";
				$json_data.="\"next\":\"".$next_xh["zsh"]."\",";

				$clpic=get_kh_cl_big($clp,$flag_pad_offline);
				$tmppic=out_good_pic_set_arr($clpic,$tmpl_m3_cl_pic_width,$tmpl_m3_cl_pic_height);
				$json_data.="\"pic_big\":\"".$clpic."\",";
				$json_data.="\"pic_big_w\":\"".$tmppic[0]."\",";
				$json_data.="\"pic_big_h\":\"".$tmppic[1]."\",";
			}
		break;
		default:
			//----------------------------------------------陈列模式
			if($sys_zycl=="y"){
				$s_type=$s_type?$s_type:"1";
			}
			$num_cl_zd=0;
			if(is_array($sys_cl_zd)){
				$num=count($sys_cl_zd);
				$num_cl_zd=($num<5)?$num:5;
			}
			$json_data.="\"sys_zycl\":\"".$sys_zycl."\",";
			//require THIS_FILE_ROOT."/include/page_js.class.php";
			$w2=$tmpl_m3_cl_pic_width;
			$h2=$tmpl_m3_cl_pic_height;
			$page_size=$tmpl_m1_page_size;
			$page_size=$tmpl_m1_page_size;

			$page=$page>0?$page:1;
			$limit=$limit>0?$limit:6;
			$start=($page-1)*$limit;
			$end=$limit;

			//

			$sql_con=" where zsh>0 and ";
			if($s_type){
				$sql_con.=get_sql_client_type($s_type);
			}
			/*if($s_no){
				$sql_con.="kh like '%".$s_no."%' and ";
				$s_zsh="";
			}*/
			$kl=strlen($s_keyword);
			if($kl<=3 && $s_keyword && is_numeric($s_keyword)){
				if($xh_ms=="2"){
					$tmp=get_db_msg("select kh as no from web_kh_xh where xh='".$s_keyword."'");
				}else{
					$tmp=get_db_msg("select no from web_kh where xh='".$s_keyword."'");
				}
				$sql_con.=" kh='".$tmp["no"]."' and";
				for($i=0;$i<$num_dp_zd;$i++){
					$v1="s_zd".($i+1);
					$$v="";
				}
				$s_zsh="";
				$s_title="";
			}
			if($kl>=3){
				if(is_numeric($s_keyword)){
					if($xh_ms=="2"){
						$tmp=get_db_msg("select kh as no from web_kh_xh where xh='".$s_keyword."'");
					}else{
						$tmp=get_db_msg("select no from web_kh where xh='".$s_keyword."'");
					}
					$sql_con.=" (kh='".$tmp["no"]."' or kh like '%".$s_keyword."%') and";
				}else{
					$sql_con.=" (kh like '%".$s_keyword."%') and";
				}
				for($i=0;$i<$num_dp_zd;$i++){
					$v1="s_zd".($i+1);
					$$v="";
				}
				$s_zsh="";
				$s_title="";
			}
			if($s_title){
				$sql_con.="title like '%".$s_title."%' and ";
				$s_keyword="";
				$s_zsh="";
			}
			for($i=0;$i<$num_cl_zd;$i++){
				$v1="s_zd".($i+1);
				if($$v1)
					$sql_con.="zd".($i+1)."='".$$v1."' and ";
			}
			if($sql_con)
				$sql_con=substr($sql_con,0,-4);
			//$sql_order=str_replace("!"," desc",$order);

			$json_data.="\"s_keyword\":\"".$s_keyword."\",";
			$json_data.="\"s_zsh\":\"".$s_zsh."\",";
			$json_data.="\"s_title\":\"".$s_title."\",";


			$query="select count(distinct zsh) 'total' from ".$table_pre."kh_cl ".$sql_con;
			$res=$db->query($query);
			$msg=$db->fetch_array($res);
			$total=$msg["total"];


			//定制条件
			$query="select * from ".$table_pre."kh_cl ".$sql_con." group by zsh order by zsh limit ".$start.",".$end;
			//echo $query."<br>";
			$res=$db->query($query);
			$count=0;
			$rnum=0;
			$style_title_color=get_set("style_title_color");
			$ka_color=get_set("ka_color");
			$pic_background=get_set("pic_background");
			$pic_background=$pic_background?$pic_background:"#ffffff";
			$content_set="[\"".$pic_background."\"]";

			$json_data.="\"style_title_color\":\"".$style_title_color."\",";
			$json_data.="\"ka_color\":\"".$ka_color."\",";
			$json_data.="\"content_set\":\"".$pic_background."\",";

			$json_data.="\"count\":".$total.",\"content_list\":[";
			$data_str="";

			$content_list="[";
			for($count=0;$count<$end;$count++){
				$msg=$db->fetch_array($res);
				if($msg["id"]>0){
					//图片获取规则
					$pic=get_kh_cl_mini($msg["pic"],$flag_pad_offline);
					if(($msg_login["path"]."-".$msg_login["id"])==$msg["upath"])
						$is_my_cl="y";
					else
						$is_my_cl="n";
					$content_list.=$msg["zsh"].",\"".$pic."\",\"".str_replace("\"","'",out_good_pic_set($pic,$w2,$h2))."\",\"".$msg["title"]."\",\"".$is_my_cl."\",";
					$ck=out_good_pic_set_arr($pic,$w2,$h2);
					$data_str.="{\"zsh\":".$msg["zsh"].",\"title\":\"".$msg["title"]."\",\"is_my_cl\":\"".$is_my_cl."\",\"pic\":\"".$pic."\",\"pic_w\":".$ck[0].",\"pic_h\":".$ck[1]."},";
					//
					$rnum++;
				}
			}
			$json_data.=substr($data_str,0,-1)."],";
			$content_list.="]";

			//自定义筛选条件
			$str_arr_zy="";
			$select_dz="";
			if($sys_zycl=="y"){
				$tmp1=explode(",",$sys_zycl_client_type);
				foreach($tmp1 as $k1 => $v1){
					$tmp2=explode("|",$v1);
					$str_arr_zy.="{\"no\":\"".$tmp2[0]."\",\"title\":\"".$tmp2[1]."\"},";
					/*foreach($tmp2 as $k2 => $v2){
						$str_arr_zy.="{\"no\":\"".$k2."\",\"title\":\"".$v2."\"},";
					}*/
				}
				$str_arr_zy=deel_end($str_arr_zy);
				$select_dz.="{\"no\":\"s_type\",\"title\":\"陈列类型\",\"value\":\"".$s_type."\",\"op\":[".$str_arr_zy."]},";
			}

			$str_arr_select="";

			for($i=0;$i<$num_cl_zd;$i++){
				$v1="s_zd".($i+1);
				$str_arr_select.="\"".$v1."\",\"".$sys_cl_zd[$i]."\",\"".$$v1."\",";
				$r=$db->query("select zd".($i+1)." from ".$table_pre."kh_cl group by zd".($i+1)." order by zd".($i+1));
				$op="[";
				$tmp="";
				while($m=$db->fetch_array($r)){
					$op.="\"".$m["zd".($i+1)]."|".$m["zd".($i+1)]."\",";
					$tmp.="{\"no\":\"".$m["zd".($i+1)]."\",\"title\":\"".$m["zd".($i+1)]."\"},";
				}
				$tmp=deel_end($tmp);
				$select_dz.="{\"no\":\"".$v1."\",\"title\":\"".$sys_cl_zd[$i]."\",\"value\":\"".$$v1."\",\"op\":[".$tmp."]},";
				$op.="],";
				$str_arr_select.=$op;
			}
			$select_dz=deel_end($select_dz);
			$json_data.="\"select_dz\":[".$select_dz."],";

			$total_page=ceil($total/$limit);
			$json_data.="\"total_page\":".$total_page.",";
			$json_data.="\"page\":".$page.",";
		break;
	}
}
$json_data=substr($json_data,0,-1)."}";
echo $json_data;
?>