<?php
//-------------------------------拖拽报表
require THIS_FILE_ROOT."/include/edtMdReport.php";
header("Content-type: text/html; charset=utf-8");
if(THIS_IN!="edt_admin")
	exit("错误的访问!");
$msg_login_user=get_db_msg("select * from ".$table_pre."user where id='".$uid."'");
//---------priv
$priv=return_priv($_m,$msg_login_user["priv"]);
$json_data="{";
if($priv[0]=="n"){
	//没有操作权限
	$json_data.="\"error\":\"没有操作权限\",\"code\":0,\"msg\":\"\",\"count\":0,\"data\":[],";
}else{
	$json_data.="\"uid\":".$uid.",";
	//有权限
	switch($_a){
		case "create_data":	
			//$tmp=get_db_msg("SELECT * FROM web_is_create_csv where id='1'");
			//if($tmp["is_create_csv"]!="y"){

			set_time_limit(0);
			
			//mysql可能需要执行以下语句来提高max_allowed_packet的值
			//mysql> set global max_allowed_packet=1024*1024*16;

			$page=$page>0?$page:1;
			$limit=$limit>0?$limit:2000;
			$start=($page-1)*$limit;
			$end=$limit;
			
			$tmp=get_db_msg("select count(*) total from web_order where ka<>'y'");
			$total_num=$tmp["total"];

			$json_data.="\"total_num\":".$total_num.",";
			//已经加载条数
			//$json_data.="\"show_num\":12,";

			$total_page=ceil($total_num/$limit);
			$json_data.="\"total_page\":".$total_page.",";
			$json_data.="\"page\":".$page.",";

			
			//if(!$s_uid){
				//$tmp=get_db_msg("SELECT DISTINCT uid FROM web_order where ka<>'y' GROUP BY uid ORDER BY uid LIMIT 0,1");
				//$s_uid=$tmp["uid"];
				//$ct=1;
			//}
			//echo $page;
			check_table_csv($page);
			//exit;

			$db->query("update web_is_create_csv set is_create_csv='y' where id='1'");
			
			//$tmp=get_db_msg("SELECT count(DISTINCT uid) dps FROM web_order where ka<>'y'");
			//$dpzs=$tmp["dps"];

			//$tmp=get_db_msg("SELECT DISTINCT uid FROM web_order where ka<>'y' and uid>".$s_uid." GROUP BY uid ORDER BY uid LIMIT 0,1");
			//$uid_next=$tmp["uid"];

			//if($s_uid){
				//$q="select * from ".$table_pre."csv_client where id='".$s_uid."' ";
				$q="select * from ".$table_pre."csv_client  ";
				$r=$db->query($q);
				$arr_client=array();
				while($m=$db->fetch_array($r)){
					$arr_client[$m["id"]]["uid"]=$m["id"];
					$arr_client[$m["id"]]["username"]=$m["username"];
					$arr_client[$m["id"]]["utitle"]=$m["title"];
					$arr_client[$m["id"]]["dj"]=$m["dj"];
					$arr_client[$m["id"]]["dpsx"]=$m["dpsx"];
					$arr_client[$m["id"]]["dl"]=$m["dl"];
					$arr_client[$m["id"]]["qy"]=$m["qy"];
					$arr_client[$m["id"]]["is_jd"]=$m["is_jd"];
					$arr_client[$m["id"]]["is_checked"]=$m["is_checked"];
					if(count($sys_client_zd)>0){
						foreach($sys_client_zd as $k => $v){
							$arr_client[$m["id"]]["client_".$k]=$m["client_".$k];
						}
					}
				}

				$q="select * from ".$table_pre."csv_kh";
				$r=$db->query($q);
				$arr_kh=array();
				while($m=$db->fetch_array($r)){
					$arr_kh[$m["id"]]["iid"]=$m["id"];
					$arr_kh[$m["id"]]["no"]=$m["no"];
					$arr_kh[$m["id"]]["ititle"]=$m["title"];
					$arr_kh[$m["id"]]["kh_dj"]=$m["kh_dj"];
					$arr_kh[$m["id"]]["bc"]=$m["bc"];
					$arr_kh[$m["id"]]["gender"]=$m["gender"];
					$arr_kh[$m["id"]]["sxz"]=$m["sxz"];
					$arr_kh[$m["id"]]["category"]=$m["category"];
					$arr_kh[$m["id"]]["series"]=$m["series"];
					$arr_kh[$m["id"]]["designer"]=$m["designer"];
					$arr_kh[$m["id"]]["price"]=$m["price"];
					$arr_kh[$m["id"]]["size_group_id"]=$m["size_group_id"];
					$arr_kh[$m["id"]]["category1"]=$m["category1"];
					$arr_kh[$m["id"]]["jgd"]=$m["jgd"];
					$arr_kh[$m["id"]]["sx"]=$m["sx"];
					$arr_kh[$m["id"]]["season"]=$m["season"];
					$arr_kh[$m["id"]]["theme"]=$m["theme"];
					$arr_kh[$m["id"]]["brand"]=$m["brand"];
				}

				$q="select * from ".$table_pre."size order by iid,no";
				$r=$db->query($q);
				$arr_size=array();
				while($m=$db->fetch_array($r)){
					$arr_size[$m["iid"]][$m["no"]]=$m["title"];
				}
				$q="select * from ".$table_pre."keyword where cate='color'";
				$r=$db->query($q);
				$arr_color=array();
				while($m=$db->fetch_array($r)){
					$arr_color[$m["no"]]=$m["title"];
				}
				
				//$q="select uid,iid,color,bx,sum(num) num,sum(je) je,sum(jsje) jsje from ".$table_pre."order where ka<>'y' and uid='".$s_uid."' group by uid,iid,color,bx order by uid,iid,color,bx";
				$q="select * from ".$table_pre."order where ka<>'y' order by uid,iid,color,bx limit ".$start.",".$end;
				$r=$db->query($q);
				$arr_sql=array();
				$count=1;
				while($m=$db->fetch_array($r)){
					$arr_sql[$count]["uid"]=$m["uid"];
					//$arr_sql[$count]["upath"]=$arr_client[$m["uid"]]["upath"];
					$arr_sql[$count]["username"]=$arr_client[$m["uid"]]["username"];
					$arr_sql[$count]["utitle"]=$arr_client[$m["uid"]]["utitle"];
					$arr_sql[$count]["dj"]=$arr_client[$m["uid"]]["dj"];
					$arr_sql[$count]["dpsx"]=$arr_client[$m["uid"]]["dpsx"];
					$arr_sql[$count]["dl"]=$arr_client[$m["uid"]]["dl"];
					$arr_sql[$count]["qy"]=$arr_client[$m["uid"]]["qy"];
					$arr_sql[$count]["is_jd"]=$arr_client[$m["uid"]]["is_jd"];
					$arr_sql[$count]["is_checked"]=$arr_client[$m["uid"]]["is_checked"];
					if(count($sys_client_zd)>0){
						foreach($sys_client_zd as $k => $v){
							$arr_sql[$count]["client_".$k]=$arr_client[$m["uid"]]["client_".$k];
						}
					}

					$arr_sql[$count]["num"]=$m["num"];
					$arr_sql[$count]["je"]=$m["je"];
					$arr_sql[$count]["jsje"]=$m["jsje"];
					$arr_sql[$count]["mdje"]=$m["mdje"];
					$arr_sql[$count]["color"]=$m["color"];
					$arr_sql[$count]["colort"]=$arr_color[$m["color"]];
					$arr_sql[$count]["bx"]=$m["bx"];

					foreach($arr_size as $k => $v){

						$ct_size=count($v);

						for($s1=1;$s1<=$ct_size;$s1++){
							if($k==$m["size_group_id"]){
								$arr_sql[$count]["num_".$s1."_".$k]=$m["num_".$s1];
							}else{
								$arr_sql[$count]["num_".$s1."_".$k]="";
							}
						}
					}

					$arr_sql[$count]["iid"]=$arr_kh[$m["iid"]]["iid"];
					$arr_sql[$count]["no"]=$arr_kh[$m["iid"]]["no"];
					$arr_sql[$count]["ititle"]=$arr_kh[$m["iid"]]["ititle"];
					$arr_sql[$count]["kh_dj"]=$arr_kh[$m["iid"]]["kh_dj"];
					$arr_sql[$count]["bc"]=$arr_kh[$m["iid"]]["bc"];
					$arr_sql[$count]["gender"]=$arr_kh[$m["iid"]]["gender"];
					$arr_sql[$count]["sxz"]=$arr_kh[$m["iid"]]["sxz"];
					$arr_sql[$count]["category"]=$arr_kh[$m["iid"]]["category"];
					$arr_sql[$count]["series"]=$arr_kh[$m["iid"]]["series"];
					$arr_sql[$count]["designer"]=$arr_kh[$m["iid"]]["designer"];
					$arr_sql[$count]["price"]=$arr_kh[$m["iid"]]["price"];
					$arr_sql[$count]["size_group_id"]=$arr_kh[$m["iid"]]["size_group_id"];
					$arr_sql[$count]["category1"]=$arr_kh[$m["iid"]]["category1"];
					$arr_sql[$count]["jgd"]=$arr_kh[$m["iid"]]["jgd"];
					$arr_sql[$count]["sx"]=$arr_kh[$m["iid"]]["sx"];
					$arr_sql[$count]["season"]=$arr_kh[$m["iid"]]["season"];
					$arr_sql[$count]["theme"]=$arr_kh[$m["iid"]]["theme"];
					$arr_sql[$count]["brand"]=$arr_kh[$m["iid"]]["brand"];
					$count++;
				}
				$str_sql="insert into web_csv_log (";
				$str1=$str2="";
				$cflag=1;
				foreach($arr_sql as $k => $v){
					$str2.="(";
					foreach($v as $k1 => $v1){
						if($cflag==1){
							$str1.=$k1.",";
						}
						$str2.="'".$v1."',";
					}
					$str2=deel_end($str2);
					$str2.="),";
					$cflag++;
				}
				$str2=deel_end($str2);
				$str1=deel_end($str1);
				$str_sql.=$str1.") values ".$str2;
				$db->query($str_sql);
				//if(!$uid_next){
					//$json_data.="\"msg\":\"获取结束，开始生成csv文件\",";
					//$json_data.="\"uid_next\":0,";
				//}else{
					//$json_data.="\"msg\":\"正在获取数据，进度".$ct."/".$dpzs."\",";
					//$json_data.="\"uid_next\":".$uid_next.",";
				//}
			//}
			//$ct++;
			
			if($page==$total_page){
				$json_data.="\"next_page\":0,";
				$json_data.="\"msg\":\"获取结束，开始生成csv文件\",";
			}else{
				$page++;
				$json_data.="\"msg\":\"正在获取数据，进度".$page."/".$total_page."\",";
				$json_data.="\"next_page\":".$page.",";
				
			}
			

			//$json_data.="\"ct\":".$ct.",";
			//}else{
				//$json_data.="\"err\":\"别的用户正在生成中，暂时无法操作\",";
			//}
		break;
		case "create_csv":


			//$str_size="";
			//$sql_size="select * from web_size  order by iid,no";
			//$res_size=$db->query($sql_size);
			//while($msg_size=$db->fetch_array($res_size)){
				//$str_size.=",(case when a.size_group_id='".$msg_size["iid"]."' then a.num_".$msg_size["no"]." else 0 end) 'num_".$msg_size["no"]."_".$msg_size["iid"]."'";
			//}

			//echo $sql="select * from(select b.username,b.title,a.no,a.color".$str_size."
			//from web_order as a left join web_client as b on a.uid=b.id ) as a
			//left join
			//(
			//select a.no,b.title from web_kh as a 
			//left join web_keyword as b on b.cate='brand' and b.no=a.brand
			//left join web_keyword as c on c.cate='category' and c.no=a.category
			//left join web_keyword as d on d.cate='series' and d.no=a.brand
			//left join web_keyword as e on e.cate='season' and e.no=a.season
			//left join web_keyword as f on f.cate='theme' and f.no=a.theme
			//left join web_keyword as g on g.cate='bc' and g.no=a.bc

			//) as b on a.no=b.no
			//";

			//exit;

			$q="select * from ".$table_pre."size order by iid,no";
			$r=$db->query($q);
			$arr_size=array();
			while($m=$db->fetch_array($r)){
				$tmp=get_db_msg("select title from web_keyword where id='".$m["iid"]."'");
				$arr_size[$m["iid"]][$m["no"]]=$tmp["title"].":".$m["title"];
			}

			$arr_csv_title=array();
			//$arr_csv_title["uid"]="店铺ID";
			//$arr_csv_title["upath"]="店铺upath";
			$arr_csv_title["username"]="店铺代码";
			$arr_csv_title["utitle"]="店铺名称";
			$arr_csv_title["dj"]="店铺等级";
			$arr_csv_title["dpsx"]="店铺属性";
			$arr_csv_title["dl"]="上级代理";
			$arr_csv_title["qy"]="上级区域";
			$arr_csv_title["is_jd"]="交单状态";
			$arr_csv_title["is_checked"]="确认状态";
			if(count($sys_client_zd)>0){
				foreach($sys_client_zd as $k => $v){
					$arr_csv_title["client_".$k]=$v;
				}
			}
			//$arr_csv_title["iid"]="款号ID";
			$arr_csv_title["no"]="款号";
			$arr_csv_title["ititle"]="款式名";
			$arr_csv_title["color"]="颜色代码";
			$arr_csv_title["colort"]="颜色名称";
			$arr_csv_title["bx"]="杯型";


			$q="select * from ".$table_pre."keyword where cate='arr_select' and flag_ka='y'";
			$r=$db->query($q);
			while($m=$db->fetch_array($r)){
				if($m["no"]=="zd1" || $m["no"]=="zd2" || $m["no"]=="zd2" ){
				}else{
					$arr_csv_title[$m["no"]]=$m["title"];
				}
			}

			//$arr_csv_title["kh_dj"]=get_cate_title_no("arr_select","kh_dj");
			//$arr_csv_title["bc"]=get_cate_title_no("arr_select","bc");
			//$arr_csv_title["gender"]=get_cate_title_no("arr_select","gender");
			//$arr_csv_title["sxz"]=get_cate_title_no("arr_select","sxz");
			//$arr_csv_title["category"]=get_cate_title_no("arr_select","category");
			//$arr_csv_title["series"]=get_cate_title_no("arr_select","series");
			//$arr_csv_title["designer"]=get_cate_title_no("arr_select","designer");
			//$arr_csv_title["category1"]=get_cate_title_no("arr_select","category1");
			//$arr_csv_title["jgd"]=get_cate_title_no("arr_select","jgd");
			//$arr_csv_title["sx"]=get_cate_title_no("arr_select","sx");
			//$arr_csv_title["season"]=get_cate_title_no("arr_select","season");
			//$arr_csv_title["theme"]=get_cate_title_no("arr_select","theme");
			//$arr_csv_title["brand"]=get_cate_title_no("arr_select","brand");
			$arr_csv_title["size_group_id"]="尺码组";
			foreach($arr_size as $k => $v){
				foreach($v as $k1 => $v1){
					$arr_csv_title["num_".$k1."_".$k]=$v1;
				}
			}
			//$arr_csv_title["num_1"]="尺码1";
			//$arr_csv_title["num_2"]="尺码2";
			//$arr_csv_title["num_3"]="尺码3";
			//$arr_csv_title["num_4"]="尺码4";
			//$arr_csv_title["num_5"]="尺码5";
			//$arr_csv_title["num_6"]="尺码6";
			//$arr_csv_title["num_7"]="尺码7";
			//$arr_csv_title["num_8"]="尺码8";
			//$arr_csv_title["num_9"]="尺码9";
			//$arr_csv_title["num_10"]="尺码10";
			//$arr_csv_title["num_11"]="尺码11";
			//$arr_csv_title["num_12"]="尺码12";
			//$arr_csv_title["num_13"]="尺码13";
			//$arr_csv_title["num_14"]="尺码14";
			//$arr_csv_title["num_15"]="尺码15";
			//$arr_csv_title["num_16"]="尺码16";
			//$arr_csv_title["num_17"]="尺码17";
			//$arr_csv_title["num_18"]="尺码18";
			//$arr_csv_title["num_19"]="尺码19";
			//$arr_csv_title["num_20"]="尺码20";
			$arr_csv_title["num"]="数量";
			$arr_csv_title["je"]="金额";
			$arr_csv_title["jsje"]="结算金额";
			$arr_csv_title["mdje"]="买断金额";

			$q="select * from web_csv_log";
			$r=$db->query($q);
			$arr_csv=array();
			$count=0;
			$stra="";
			$ct=1;
			foreach($arr_csv_title as $k => $v){
				if($ct==1){
					if($k=="color" ){
						$stra.="+".$v;
					}else{
						$stra.=$v;
					}
				}else{
					if($k=="color"){
						$stra.=",+".$v;
					}else{
						$stra.=",".$v;
					}
					
				}
				$ct++;
				
			}
			//print_r($stra);
			$arr_csv[$count]=$stra;
			$count++;
			while($m=$db->fetch_array($r)){
				$stra="";
				$ct=1;
				foreach($arr_csv_title as $k => $v){
					if($ct==1){
						if($k=="color" ){
							$stra.="".$m[$k]."";
							
						}else{
							$stra.=$m[$k];
						}
					}else{
						if($k=="color"){
							$stra.=",".$m[$k];
						}else{
							$stra.=",".$m[$k];
							
						}
					}
					$ct++;
				}
				$arr_csv[$count]=$stra;
				$count++;
			}

			$fname=iconv("utf-8","gbk","cache/".$msg_login_user["username"].".csv");
			$file = fopen($fname,"w");
			foreach ($arr_csv as $line){
				//echo $line."<br>";
				//fputcsv($file,split(',',iconv("utf-8","gbk",$line)));
				fputcsv($file,split(',',$line));
			}
			fclose($file);
			$f=fileatime($fname);
			$updatetime=date("Y-m-d H:i",$f);
			$db->query("update web_is_create_csv set is_create_csv='n',file_time='".$updatetime."' where id='1'");
			$json_data.="\"file_path\":\"cache/".$msg_login_user["username"].".csv\",";
			$json_data.="\"update_time\":\"".$updatetime."\",";
		break;
		case "is_csv_exist":
			$file="cache/admin.csv";
			if(file_exists($file)){
				$tmp=get_db_msg("select * from web_is_create_csv where id='1'");
				$json_data.="\"code\":1,";
				$json_data.="\"update_time\":\"".$tmp["file_time"]."\",";
			}else{
				$json_data.="\"code\":0,";
				$json_data.="\"update_time\":\"\",";
			}
		break;
		case "save_mb":
			$timenow=date("Y-m-d H:i",time());
			$tmp=get_db_msg("select id from web_csv_mb where username='".$msg_login_user["username"]."' and mb_name='".$mb_name."'");
			if($tmp["id"]){
				$json_data.="\"code\":1,";
				$json_data.="\"errmsg\":\"该模板名已存在\",";
			}else{
				$db->query("INSERT INTO `web_csv_mb` (`username`,`add_time`,`mb`,`mb_name`) VALUES ('".$msg_login_user["username"]."', '".$timenow."', '".$mb."', '".$mb_name."');");
				$json_data.="\"code\":0,";
			}
		break;
		case "get_mb":
			$q="select * from web_csv_mb order by add_time desc";
			$r=$db->query($q);
			$tmpstr="";
			$json_data.="\"code\":0,\"data\":[";
			while($m=$db->fetch_array($r)){
				$tmpstr.="{";
				$tmpstr.="\"id\":\"".$m["id"]."\"";
				$tmpstr.=",\"username\":\"".$m["username"]."\"";
				$tmpstr.=",\"add_time\":\"".$m["add_time"]."\"";
				$tmpstr.=",\"mb_name\":\"".$m["mb_name"]."\"";
				//$tmpstr.=",\"mb\":\"".$m["mb"]."\"";
				$tmpstr.="},";
			}
			$json_data.=substr($tmpstr,0,-1)."],";
		break;
		case "get_mb_info":
			$q="select * from web_csv_mb where id='".$mbid."'";
			$r=$db->query($q);
			$tmpstr="";
			$json_data.="\"code\":0,\"data\":[";
			while($m=$db->fetch_array($r)){
				$tmpstr.="{";
				$tmpstr.="\"id\":\"".$m["id"]."\"";
				$tmpstr.=",\"username\":\"".$m["username"]."\"";
				$tmpstr.=",\"add_time\":\"".$m["add_time"]."\"";
				$tmpstr.=",\"mb_name\":\"".$m["mb_name"]."\"";
				$tmpstr.=",\"mb\":[".$m["mb"]."]";
				$tmpstr.="},";
			}
			$json_data.=substr($tmpstr,0,-1)."],";
		break;
		case "save_mb_info":
			$tmp=get_db_msg("select id from web_csv_mb where username='".$msg_login_user["username"]."' and mb_name='".$mb_name."'");
			if($tmp["id"]){
				$json_data.="\"code\":1,";
				$json_data.="\"errmsg\":\"该模板名已存在\",";
			}else{
				$db->query("update web_csv_mb set mb_name='".$mb_name."' where id='".$mbid."';");
				$json_data.="\"code\":0,";
			}
		break;
		case "delete_mb":
			$db->query("delete from web_csv_mb where id='".$mbid."';");
			$json_data.="\"sql\":\"delete from web_csv_mb where id='".$mbid."';\",";
			$json_data.="\"code\":0,";
		break;
		case "getdata":
			//创建文件并写入
			//目录
			$file_dir="cache";
			//文件
			$file_name="mps.json";
			//内容
			$page=0;
			$myReport=new edtMdReport();
			$sys_fields_fy_array=array(
					"qymc"=>"区域",
					"dlmc"=>"代理",
					"title"=>"店铺",
					"dpsx"=>"店铺属性",
					"sxz"=>get_cate_title_no("arr_select","sxz"),
					"brand"=>get_cate_title_no("arr_select","brand"),
					"series"=>get_cate_title_no("arr_select","series"),
					"theme"=>get_cate_title_no("arr_select","theme"),
					"season"=>get_cate_title_no("arr_select","season"),
					"bc"=>get_cate_title_no("arr_select","bc"),
					"gender"=>get_cate_title_no("arr_select","gender"),
					"category"=>get_cate_title_no("arr_select","category"),
					"category1"=>get_cate_title_no("arr_select","category1"),
					"kh_dj"=>get_cate_title_no("arr_select","kh_dj"),
					"designer"=>get_cate_title_no("arr_select","designer"),
					"num"=>"数量",
					"je"=>"金额",
					"no"=>"款号",
					"color"=>"款色");
			$myReport->arrFields=array(
					"web_qy.qymc",
					"web_dl.dlmc",
					"web_client.title",
					"web_client.dpsx",
					"web_order.sxz",
					"web_order.brand",
					"web_order.series",
					"web_order.theme",
					"web_order.season",
					"web_order.bc",
					"web_order.gender",
					"web_order.category",
					"web_order.category1",
					"web_order.kh_dj",
					"web_order.designer",
					"SUM(web_order.num)",
					"SUM(web_order.je)",
					"web_order.no",
					"web_order.color");
			//$myReport->arrFields=$myReport->useableFields;
			//$myReport->condition="where web_order.brand='11' and web_dl.dlmc='云南' and web_order.ka<>'y'";
			$myReport->pageRow=10000000;
			$myReport->page=$page;
			$r=$myReport->getRes();
			$str="";
			for($i=0;$i<count($r);$i++){
				$str2="";
				foreach($r[$i] as $key=>$value){
					if($key=="color"){
						$str2.="\"".$sys_fields_fy_array[$key]."\":\"".$r[$i]["no"]."_".$value."\",";
					}else{
						$str2.="\"".$sys_fields_fy_array[$key]."\":\"".$value."\",";
					}
				}
				$str.="{".substr($str2,0,-1)."},";
			}
			$data_time=date("Y-m-d H:i:s",time());
			$file_content="{\"gettime\":\"".$data_time."\",\"data\":[".substr($str,0,-1)."]}";
			write_file1($file_dir,$file_name,$file_content);

			$json_data.="\"code\":1,\"data_time\":\"".$data_time."\",";
		break;
	}
}
$json_data=substr($json_data,0,-1)."}";
echo $json_data;


function check_table_csv($ct){
	global $db,$table_pre;

	if($ct==1){
		//$db->query("set global max_allowed_packet=1024*1024*16;");
		
		$db->query("DROP TABLE IF EXISTS web_csv_log;");
		$db->query("DROP TABLE IF EXISTS web_csv_client;");
		$db->query("DROP TABLE IF EXISTS web_csv_kh;");
	
	$tname="web_is_create_csv";
	$sql_create_table="CREATE TABLE ".$tname." (
	`id` int(10) unsigned NOT NULL auto_increment,
	`is_create_csv` varchar(1) NOT NULL default 'n',
	`file_time` varchar(255) NOT NULL DEFAULT '',
	PRIMARY KEY  (`id`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8;";
	if(check_table_exist($tname)!="y"){
		$db->query($sql_create_table);
		$db->query("INSERT INTO `web_is_create_csv` (`id`, `is_create_csv`) VALUES ('1', 'n');");
	}

	$tname="web_csv_mb";
	$sql_create_table="CREATE TABLE ".$tname." (
	`id` int(10) unsigned NOT NULL auto_increment,
	`username` varchar(255) NOT NULL DEFAULT '',
	`mb_name` varchar(255) NOT NULL DEFAULT '',
	`add_time` varchar(255) NOT NULL DEFAULT '',
	`mb` text  NULL,
	PRIMARY KEY  (`id`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8;";
	if(check_table_exist($tname)!="y"){
		$db->query($sql_create_table);
	}

	$tname="web_csv_client";
	$sql_create_table="CREATE TABLE ".$tname." (
	`id` int(10) unsigned NOT NULL auto_increment,
	`username` varchar(255) NOT NULL DEFAULT '',
	`title` varchar(255) NOT NULL DEFAULT '',
	`qy` varchar(255) NOT NULL DEFAULT '',
	`dl` varchar(255) NOT NULL DEFAULT '',
	`dpsx` varchar(255) NOT NULL DEFAULT '',
	`dj` varchar(255) NOT NULL DEFAULT '',
	`is_jd` varchar(1) NOT NULL DEFAULT 'n',
	`is_checked` varchar(1) NOT NULL DEFAULT 'n',
	`client_zd1` varchar(250) NOT NULL DEFAULT '',
	`client_zd2` varchar(250) NOT NULL DEFAULT '',
	`client_zd3` varchar(250) NOT NULL DEFAULT '',
	`client_zd4` varchar(250) NOT NULL DEFAULT '',
	`client_zd5` varchar(250) NOT NULL DEFAULT '',
	PRIMARY KEY  (`id`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8;";
	//if(check_table_exist($tname)!="y"){
		$db->query($sql_create_table);
	//}

	$tname="web_csv_kh";
	$sql_create_table="CREATE TABLE ".$tname." (
	`id` int(10) unsigned NOT NULL auto_increment,
	`title` varchar(255) NOT NULL DEFAULT '',
	`kh_dj` varchar(255) NOT NULL DEFAULT '',
	`bc` varchar(255) NOT NULL DEFAULT '',
	`no` varchar(50) NOT NULL DEFAULT '',
	`gender` varchar(255) NOT NULL DEFAULT '',
	`sxz` varchar(255) NOT NULL DEFAULT '',
	`category` varchar(255) NOT NULL DEFAULT '',
	`series` varchar(255) NOT NULL DEFAULT '',
	`designer` varchar(255) NOT NULL DEFAULT '',
	`price` smallint(5) unsigned NOT NULL DEFAULT '0',
	`bx` varchar(10) NOT NULL DEFAULT '',
	`size_group_id` varchar(255) NOT NULL DEFAULT '',
	`category1` varchar(255) NOT NULL DEFAULT '',
	`jgd` varchar(255) NOT NULL DEFAULT '',
	`sx` varchar(255) NOT NULL DEFAULT '',
	`season` varchar(255) NOT NULL DEFAULT '',
	`theme` varchar(255) NOT NULL DEFAULT '',
	`brand` varchar(255) NOT NULL DEFAULT '',
	PRIMARY KEY  (`id`),
	KEY `no` (`no`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8;";
	//if(check_table_exist($tname)!="y"){
		$db->query($sql_create_table);
	//}

	$tname="web_csv_log";
	$sql_create_table="CREATE TABLE ".$tname." (
	`id` int(10) unsigned NOT NULL auto_increment,
	`uid` smallint(5) unsigned NOT NULL DEFAULT '0',
	`username` varchar(255) NOT NULL DEFAULT '',
	`utitle` varchar(255) NOT NULL DEFAULT '',
	`qy` varchar(255) NOT NULL DEFAULT '',
	`dl` varchar(255) NOT NULL DEFAULT '',
	`dpsx` varchar(255) NOT NULL DEFAULT '',
	`dj` varchar(255) NOT NULL DEFAULT '',
	`is_jd` varchar(1) NOT NULL DEFAULT 'n',
	`is_checked` varchar(1) NOT NULL DEFAULT 'n',
	`client_zd1` varchar(250) NOT NULL DEFAULT '',
	`client_zd2` varchar(250) NOT NULL DEFAULT '',
	`client_zd3` varchar(250) NOT NULL DEFAULT '',
	`client_zd4` varchar(250) NOT NULL DEFAULT '',
	`client_zd5` varchar(250) NOT NULL DEFAULT '',
	`iid` int(10) unsigned NOT NULL DEFAULT '0',
	`ititle` varchar(255) NOT NULL DEFAULT '',
	`kh_dj` varchar(255) NOT NULL DEFAULT '',
	`bc` varchar(255) NOT NULL DEFAULT '',
	`no` varchar(50) NOT NULL DEFAULT '',
	`gender` varchar(255) NOT NULL DEFAULT '',
	`sxz` varchar(255) NOT NULL DEFAULT '',
	`category` varchar(255) NOT NULL DEFAULT '',
	`series` varchar(255) NOT NULL DEFAULT '',
	`designer` varchar(255) NOT NULL DEFAULT '',
	`price` smallint(5) unsigned NOT NULL DEFAULT '0',
	`color` varchar(20) NOT NULL DEFAULT '',
	`colort` varchar(255) NOT NULL DEFAULT '',
	`bx` varchar(10) NOT NULL DEFAULT '',
	`size_group_id` varchar(255) NOT NULL DEFAULT '',
	`category1` varchar(255) NOT NULL DEFAULT '',
	`jgd` varchar(255) NOT NULL DEFAULT '',
	`sx` varchar(255) NOT NULL DEFAULT '',
	`season` varchar(255) NOT NULL DEFAULT '',
	`theme` varchar(255) NOT NULL DEFAULT '',
	`brand` varchar(255) NOT NULL DEFAULT '',
	`num` int(10) unsigned NOT NULL DEFAULT '0',";

	$q="select * from web_size order by iid,no";
	$r=$db->query($q);
	while($m=$db->fetch_array($r)){
		$sql_create_table.="`num_".$m["no"]."_".$m["iid"]."` int(10) unsigned NOT NULL DEFAULT '0',";
	}

	$sql_create_table.="`je` decimal(10,2) NOT NULL DEFAULT '0.00',
	`jsje` decimal(10,2) NOT NULL DEFAULT '0.00',
	`mdje` decimal(10,2) NOT NULL DEFAULT '0.00',
	`zd1` varchar(255) NOT NULL DEFAULT '',
	`zd2` varchar(255) NOT NULL DEFAULT '',
	`zd3` varchar(255) NOT NULL DEFAULT '',
	`zd4` varchar(255) NOT NULL DEFAULT '',
	`zd5` varchar(255) NOT NULL DEFAULT '',
	PRIMARY KEY  (`id`),
	KEY `iid` (`iid`),
	KEY `uid` (`uid`),
	KEY `no` (`no`),
	KEY `color` (`color`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8;";
	//if(check_table_exist($tname)!="y"){
		$db->query($sql_create_table);
	//}
		//$db->query("set global max_allowed_packet=1024*1024*16;");
		//$db->query("truncate TABLE web_csv_log");
		//$db->query("truncate TABLE web_csv_client");
		//$db->query("truncate TABLE web_csv_kh");

		$q="select * from ".$table_pre."client where face='4'  and available='y'";
		$r=$db->query($q);
		$arr_client=array();
		while($m=$db->fetch_array($r)){
			$arr_client[$m["id"]]["uid"]=$m["id"];
			$upath=$m["path"]."-".$m["id"];
			$arr_client[$m["id"]]["username"]=$m["username"];
			$arr_client[$m["id"]]["title"]=$m["title"];
			$arr_client[$m["id"]]["dj"]=$m["dj"];
			$arr_client[$m["id"]]["dpsx"]=$m["dpsx"];
			$m_qy=get_db_msg("select title from ".$table_pre."client where id='".get_qy_id($upath)."'");
			$m_dl=get_db_msg("select title from ".$table_pre."client where id='".get_dl_id($upath)."'");
			$arr_client[$m["id"]]["dl"]=$m_dl["title"];
			$arr_client[$m["id"]]["qy"]=$m_qy["title"];
			$arr_client[$m["id"]]["is_jd"]=$m["is_jd"];
			$arr_client[$m["id"]]["is_checked"]=$m["is_checked"];
			if(count($sys_client_zd)>0){
				foreach($sys_client_zd as $k => $v){
					$arr_client[$m["id"]]["client_".$k]=$m["client_".$k];
				}
			}
		}

		$str_sql="insert into web_csv_client (id,username,title,dj,dpsx,dl,qy,is_jd,is_checked";
		if(count($sys_client_zd)>0){
			foreach($sys_client_zd as $k => $v){
				$str_sql.=",client_".$k;
			}
		}
		$str_sql.=")";
		$str2="";
		foreach($arr_client as $k => $v){
			$str2.="(";
			foreach($v as $k1 => $v1){
				$str2.="'".$v1."',";
			}
			$str2=deel_end($str2);
			$str2.="),";
		}
		$str2=deel_end($str2);
		$str_sql.=" values ".$str2;
		$db->query($str_sql);

		$q="select * from ".$table_pre."kh";
		$r=$db->query($q);
		$arr_kh=array();
		while($m=$db->fetch_array($r)){
			$arr_kh[$m["id"]]["iid"]=$m["id"];
			$arr_kh[$m["id"]]["no"]=$m["no"];
			$arr_kh[$m["id"]]["ititle"]=$m["title"];
			$arr_kh[$m["id"]]["kh_dj"]=get_cate_title_no("kh_dj",$m["kh_dj"]);
			$arr_kh[$m["id"]]["bc"]=get_cate_title_no("bc",$m["bc"]);
			$arr_kh[$m["id"]]["gender"]=get_cate_title_no("gender",$m["gender"]);
			$arr_kh[$m["id"]]["sxz"]=get_cate_title_no("sxz",$m["sxz"]);
			$arr_kh[$m["id"]]["category"]=get_cate_title_no("category",$m["category"]);
			$arr_kh[$m["id"]]["series"]=get_cate_title_no("series",$m["series"]);
			$arr_kh[$m["id"]]["designer"]=get_cate_title_no("designer",$m["designer"]);
			$arr_kh[$m["id"]]["price"]=$m["price"];
			$tmp=get_db_msg("select title from web_keyword where cate='size' and id='".$m["size_group"]."'");
			$arr_kh[$m["id"]]["size_group_id"]=$tmp["title"];
			$arr_kh[$m["id"]]["category1"]=get_cate_title_no("category1",$m["category1"]);
			$arr_kh[$m["id"]]["jgd"]=get_cate_title_no("jgd",$m["jgd"]);
			$arr_kh[$m["id"]]["sx"]=get_cate_title_no("sx",$m["sx"]);
			$arr_kh[$m["id"]]["season"]=get_cate_title_no("season",$m["season"]);
			$arr_kh[$m["id"]]["theme"]=get_cate_title_no("theme",$m["theme"]);
			$arr_kh[$m["id"]]["brand"]=get_cate_title_no("brand",$m["brand"]);
		}

		$str_sql="insert into web_csv_kh (id,no,title,kh_dj,bc,gender,sxz,category,series,designer,price,size_group_id,category1,jgd,sx,season,theme,brand)";
		$str2="";
		foreach($arr_kh as $k => $v){
			$str2.="(";
			foreach($v as $k1 => $v1){
				$str2.="'".$v1."',";
			}
			$str2=deel_end($str2);
			$str2.="),";
		}
		$str2=deel_end($str2);
		$str_sql.=" values ".$str2;
		$db->query($str_sql);
	}
}
?>