"; $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."
"; $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; ?>