EDT/admin/module/size.php

<?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{
	switch($_a){
		//////////////////////////////////尺码组
		case "set_sizegroup":
			$query="select * from ".$table_pre."keyword where cate='size' order by ord";
			//echo $query."<br>";
			$res=$db->query($query);
			while($msg=$db->fetch_array($res)){
				$str.="{\"ord\":\"".$msg["ord"]."\",\"id\":\"".$msg["id"]."\",\"title\":\"".$msg["title"]."\"},";
			}
			$json_data.="\"data\":[".deel_end($str)."],";
		break;
		case "save_sizegroup" :
			for($i=0;$i<$len;$i++){
				$var_id="id_".$i;
				$var_title="title_".$i;
				$ord=$i+1;
				if($$var_title!=""){
					if($$var_id>0){
						$query="update ".$table_pre."keyword set title='".$$var_title."' where id='".$$var_id."'";
					}else{
						$query="insert ".$table_pre."keyword (ord,title,cate) values ('".$ord."','".$$var_title."','size')";
					}
					$db->query($query);
				}
			}
			$json_data.="\"code\":\"1\",";
			set_log("设置尺码组",$title."|".$lid);
		break;
		case "del_sizegroup" :
			if($id>0){
				$m=get_db_msg("select id,title from ".$table_pre."keyword where id='".$id."'");
				//检查是否存在尺码
				$check=get_db_msg("select count(*) 'num' from ".$table_pre."size where iid='".$id."'");
				if($check["num"]>0){
					$json_data.="\"code\":0,\"msg\":\"(".$m["title"].")存在尺码，请先删除尺码再操作\",";
				}else{
					$query="delete from ".$table_pre."keyword where id='".$id."'";
					$db->query($query);
					set_log("删除尺码组",$m["title"]."|".$m["id"]);
					$json_data.="\"code\":1,";
				}
			}else{
				$json_data.="\"code\":0,\"msg\":\"记录不存在\",";
			}
		break;
		//////////////////////////////////尺码
		case "add" :
			$msg_group=get_db_msg("select * from ".$table_pre."keyword where id='".$s_id."'");
			if($id){
				$msg=get_db_msg("select * from ".$table_pre."size where id='".$id."'");
				$no=$msg["no"];
				$title=$msg["title"];
				$no_tm=$msg["no_tm"];
			}else{
				$c=get_db_msg("select max(no) 'num' from ".$table_pre."size where iid='".$s_id."'");
				$no=$c["num"]>0?$c["num"]+1:1;
				$title=$no_tm="";
			}
			//
			$json_data.="\"sizegroup_title\":\"".$msg_group["title"]."\",\"no\":\"".$no."\",\"title\":\"".$title."\",\"no_tm\":\"".$no_tm."\",";
		break;
		case "save_add" :
			//验证
			$c=get_db_msg("select count(*) 'num' from ".$table_pre."size where title='".$title."' and id<>'".$id."' and iid='".$s_id."'");
			if($c["num"]>0){
				$json_data.="\"code\":0,\"msg\":\"该记录已经存在，请重新输入一个\",";
			}else{
				if($id){
					$query="update ".$table_pre."size set no='".$no."',no_tm='".$no_tm."',title='".$title."' where id='".$id."'";
					$db->query($query);
					$log_action="修改";
				}else{
					$query="insert ".$table_pre."size (no,no_tm,title,iid) values ('".$no."','".$no_tm."','".$title."','".$s_id."')";
					$db->query($query);
					$iid=$db->insert_id();
					$log_action="新增";
				}
				$lid=$id?$id:$iid;
				set_log($log_action."尺码",$title."|".$lid);
				$json_data.="\"code\":1,";
			}
		break;
		case "del" :
			$id=(is_array($id))?$id:array($id);
			$num=count($id);
			//判断是否存在订单
			$msg_error="";
			for($i=0;$i<$num;$i++){
				$tmp=get_db_msg("select no,iid,title from ".$table_pre."size where id='".$id[$i]."'");
				$tmp1=get_db_msg("select sum(num_".$tmp["no"].") 'num1' from ".$table_pre."order where size_group_id='".$tmp["iid"]."'");
				if($tmp1["num1"]>0){
					$msg_error.="对不起，尺码（".$tmp["title"]."）存在订单，请先删除订单!";
					break;
				}
				//
			}
			if($msg_error){
				$json_data.="\"code\":0,\"msg\":\"".$msg_error."\",";
			}else{
				for($i=0;$i<$num;$i++){
					$tmp=get_db_msg("select * from ".$table_pre."size where id='".$id[$i]."'");
					$lid.=$tmp["title"]."|".$id[$i].", ";
					$db->query("delete from ".$table_pre."size where id='".$id[$i]."'");
				}
				$lid=substr($lid,0,-2);
				set_log("删除尺码",$lid);
				$json_data.="\"code\":1,";
			}
		break;
		default :
			//取得默认s_cate
			$m=get_db_msg("select * from ".$table_pre."keyword where cate='size' order by ord limit 0,1");
			$s_cate=$s_cate?$s_cate:$m["id"];
			$json_data.="\"s_cate\":\"".$s_cate."\",";
			$sql_con="where iid='".$s_cate."'";
			$tmp=get_db_msg("select count(*) 'total' from ".$table_pre."size ".$sql_con);
			$total_num=$tmp["total"];
			//-----------------------tab
			$str_tab="";
			$q="select id,title from ".$table_pre."keyword where cate='size' order by ord";
			$r=$db->query($q);
			while($m=$db->fetch_array($r)){
				$str_tab.="{\"no\":\"".$m["id"]."\",\"title\":\"".$m["title"]."\"},";
			}
			$str_tab=deel_end($str_tab);
			$json_data.="\"tab\":[".$str_tab."],";
			//-----------------------/tab
			//
			$query="select * from ".$table_pre."size ".$sql_con." order by no";
			//echo $query."<br>";
			$res=$db->query($query);
			$count=0;
			$json_data.="\"code\":0,\"msg\":\"\",\"count\":".$total_num.",\"data\":[";
			$str_tmp="";
			while($msg=$db->fetch_array($res)){
				$str_tmp.="{";
				$str_tmp.="\"id\":\"".$msg["id"]."\",";
				$str_tmp.="\"no\":\"".$msg["no"]."\",";
				$str_tmp.="\"title\":\"".$msg["title"]."\",";
				$str_tmp.="\"no_tm\":\"".$msg["no_tm"]."\"";
				$str_tmp.="},";
				$count++;
			}
			$json_data.=substr($str_tmp,0,-1)."],";
		break;
	}
}
$json_data=substr($json_data,0,-1)."}";
echo $json_data;
?>