query($q); $i=0; while($m=$db->fetch_array($r)){ $check=get_db_msg("select * from ".$table_pre."kh where no='".$m["kh"]."'"); $arr_color=explode(",",$check["color"]); if(!in_array($m["color"],$arr_color)){ $tmp.="{\"kh\":\"".$m["kh"]."\",\"v\":\"".$m["kh"].",".$m["color"]."\"},"; $i++; } } if($i>0){ $str.="{\"cate\":\"数据有误\",\"data\":[".deel_end($tmp)."]},"; }else{ $str.="{\"cate\":\"数据无误\",\"data\":[]},"; } $json_data.="\"error\":[".deel_end($str)."],"; break; //删除 case "del" : $id=(is_array($id))?$id:array($id); $num=count($id); for($i=0;$i<$num;$i++){ $q="delete from web_kh_cl_pic where id='".$id[$i]."'"; $db->query($q); $lid.=$id[$i].", "; } $lid=substr($lid,0,-2); set_log("删除自由陈列",$lid); $json_data.="\"code\":1,"; break; //----------------------------------------------------------------------导入EXCEL case "import": //目录权限 $arr_path=array( "cache"=>"admin/cache" ); $json_data.="\"path_priv\":["; $tmp=""; foreach($arr_path as $path_real => $path_title){ $tmp.="{\"title\":\"".$path_title."\",\"priv\":"; if(new_is_writeable($path_real)==1){ $tmp.="\"y\""; }else{ $tmp.="\"n\""; } $tmp.="},"; } $json_data.=substr($tmp,0,-1)."],"; break; case "import_check": $file1=$_FILES["up_file"]; $tmp_file_name=save_tmp_file($file1); $tmp_content=get_tmp_content($tmp_file_name); $arr_content=explode("\n",$tmp_content); $arr_thead=get_table_thead($tmp_content); $arr_column=check_table_thead($arr_thead,$arr_column_kh_cl); $msg=""; if(count($arr_column[0])==0){ $msg.="未检测到可导入字段，请返回检查EXCEL文件!"; del_tmp_file($tmp_file_name); $json_data.="\"code\":0,\"msg\":\"".$msg."\","; }else{ // $column=""; foreach($arr_column_kh_cl as $k => $v){ $column.=$v.","; } if($column) $column=substr($column,0,-1); $msg1=array(); $msg1[0]=array("可导入正确字段",$column); // $column=""; for($i=0;$i".$arr_thead[$i].","; } if($column) $column=substr($column,0,-1); // $msg1[1]=array("检测到的有效字段",$column); // $total=count($arr_content)-1; $msg1[2]=array("记录条数",$total); $m1=""; for($i=0;$iquery("TRUNCATE TABLE web_kh_cl_pic;"); } $json_data.="\"code\":1,\"reload_type\":\"1\","; //-------------------------------------------导入数据 $tmp_content=get_tmp_content($tmp_file_name); $arr_content=explode("\n",$tmp_content); $arr_thead=get_table_thead($tmp_content); $arr_column=check_table_thead($arr_thead,$arr_column_kh_cl); $insert_column=""; for($i=0;$i"; $db->query($q); } del_tmp_file($tmp_file_name); $log_remark=$import_flag; set_log("导入 自由陈列图片数据",$log_remark); break; //----------------------------------------------------------------------导出数据 case "export": $column=""; foreach($arr_column_kh_cl as $k => $v){ $column.="{\"k\":\"".$k."\",\"t\":\"".$v."\"},"; } if($column) $column=substr($column,0,-1); $json_data.="\"col\":[".$column."],"; break; case "export_do": //取得字段选择的值 foreach($arr_column_kh_cl as $k => $v){ $var="col_".$k; if($$var=="on"){ $ex_col[]=$k; } } $num=count($ex_col); if($num==0) alert_and_back("请至少选择一个要导出的字段"); for($i=0;$i<$num;$i++){ $data["col"][]='str'; $data["header"][0][]=get_main_value($arr_column_kh_cl,$ex_col[$i]); } $query="select * from web_kh_cl_pic order by kh,color"; $r=$db->query($query); $row=0; while($m=$db->fetch_array($r)){ for($i=0;$i<$num;$i++){ $k=$ex_col[$i]; $data["body"][$row][]=$m[$k]; } $row++; } $file_name="kh_cl_pic_".date("Y-m-d-H-i"); output_excel($file_name,$data); set_log("导出 自由陈列图片信息"); exit; break; default: $json_data.="\"lang_kh\":\"款号\","; // $page=$page>0?$page:1; $limit=$limit>0?$limit:10; $start=($page-1)*$limit; $end=$limit; //条件 $sql_con=""; if($s_kh){ $sql_con.="kh like '%".$s_kh."%' and "; } if($sql_con) $sql_con="where ".substr($sql_con,0,-4); //取得总条数 $tmp=get_db_msg("select count(*) 'num' from web_kh_cl_pic ".$sql_con); $total_num=$tmp["num"]; // $json_data.="\"code\":0,\"msg\":\"\",\"count\":".$total_num.",\"data\":["; $count=1; $str_tmp=""; $sql="select * from web_kh_cl_pic ".$sql_con." order by kh,color limit ".$start.",".$end; $res=$db->query($sql); while($msg=$db->fetch_array($res)){ //图片 $pic=get_zycl_pic($msg["pic"],"mini"); $arr_pic_set=out_good_pic_set_arr($pic,120,120); $list=$count+$start; $str_tmp.="{"; $str_tmp.="\"ct\":\"".$list."\","; $str_tmp.="\"id\":\"".$msg["id"]."\","; $str_tmp.="\"kh\":\"".$msg["kh"]."\","; $str_tmp.="\"color\":\"".$msg["color"]."-".get_cate_title_no("color",$msg["color"])."\","; $str_tmp.="\"pic_src\":\"".$pic."\","; $str_tmp.="\"pic_w\":\"".$arr_pic_set[0]."\","; $str_tmp.="\"pic_h\":\"".$arr_pic_set[1]."\","; $str_tmp.="\"picname\":\"".$msg["pic"]."\""; $str_tmp.="},"; $count++; } $json_data.=substr($str_tmp,0,-1)."],"; break; } } $json_data=substr($json_data,0,-1)."}"; echo $json_data; ?>