662 lines
21 KiB
PHP
662 lines
21 KiB
PHP
<?php
|
|
header("Content-type: text/html; charset=utf-8");
|
|
if(THIS_IN!="edt_admin")
|
|
exit("错误的访问!");
|
|
//-------------------------------execute action
|
|
$db=_mysql_connect();
|
|
$msg_login_user=get_db_msg("select * from ".$table_pre."user where id='".$uid."'");
|
|
//权限判断
|
|
$priv=return_priv($_m,$msg_login_user["priv"]);
|
|
|
|
$arr_column_kh_md["dj"]="店铺等级";
|
|
$arr_column_kh_md["kh"]="款号";
|
|
$arr_column_kh_md["price"]="买断价格";
|
|
$arr_column_kh_md["color"]="颜色代码";
|
|
//杯型参数
|
|
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($bx_sizegroup_id>0)
|
|
$arr_column_kh_md["bx"]="杯型";
|
|
if($is_gg=="y")
|
|
$arr_column_kh_md["bx"]="规格";
|
|
$arr_column_kh_md["size"]="尺码";
|
|
|
|
$json_data="{";
|
|
if($priv[0]=="n"){
|
|
//没有操作权限
|
|
$json_data.="\"error\":\"没有操作权限\",\"code\":0,\"msg\":\"\",\"count\":0,\"data\":[],";
|
|
}else{
|
|
$json_data.="\"uid\":".$uid.",";
|
|
switch($_a){
|
|
case "check":
|
|
$str="";
|
|
$tmp="";
|
|
$q="select * from ".$table_pre."kh_md group by kh order by kh";
|
|
$r=$db->query($q);
|
|
$i=0;
|
|
while($m=$db->fetch_array($r)){
|
|
$check=get_db_msg("select * from ".$table_pre."kh where no='".$m["kh"]."'");
|
|
if(!$check["id"]){
|
|
$tmp.="{\"kh\":\"".$m["kh"]."\",\"v\":\"".$m["kh"]."\"},";
|
|
$i++;
|
|
}
|
|
}
|
|
if($i>0){
|
|
$str.="{\"cate\":\"款号有误\",\"data\":[".deel_end($tmp)."]},";
|
|
}
|
|
|
|
|
|
//检查颜色
|
|
$tmp="";
|
|
$q="select * from ".$table_pre."kh_md where color<>'' group by kh,color order by kh,color";
|
|
$r=$db->query($q);
|
|
$i=0;
|
|
while($m=$db->fetch_array($r)){
|
|
$check=get_db_msg("select * from ".$table_pre."kh where no='".$m["kh"]."'");
|
|
if($check["id"]>0){
|
|
//检查颜色
|
|
$check_color=explode(",",$check["color"]);
|
|
$color=trim($m["color"]);
|
|
if(!in_array($color,$check_color)){
|
|
$tmp.="{\"kh\":\"".$m["kh"]."\",\"v\":\"".$m["kh"].",".$m["color"]."\"},";
|
|
$i++;
|
|
}
|
|
|
|
}
|
|
}
|
|
if($i>0){
|
|
$str.="{\"cate\":\"款色有误\",\"data\":[".deel_end($tmp)."]},";
|
|
}
|
|
|
|
//检查尺码
|
|
$tmp="";
|
|
$q="select * from ".$table_pre."kh_md where size<>'' and color<>'' order by kh,color";
|
|
$r=$db->query($q);
|
|
$i=0;
|
|
while($m=$db->fetch_array($r)){
|
|
$check=get_db_msg("select * from ".$table_pre."kh where no='".$m["kh"]."'");
|
|
if($check["id"]>0){
|
|
//检查尺码
|
|
$check_size=explode(",",$check["size"]);
|
|
$arr_size=explode(",",trim($m["size"]));
|
|
for($j=0;$j<count($arr_size);$j++){
|
|
if(!in_array($arr_size[$j],$check_size)){
|
|
$tmp1=get_db_msg("select * from ".$table_pre."size where iid='".$tmp["size_group"]."' and no='".$arr_size[$j]."'");
|
|
$tmp.="{\"kh\":\"".$m["kh"]."\",\"v\":\"".$m["kh"].",".$m["color"].",".$tmp1["title"]."\"},";
|
|
$i++;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
if($i>0){
|
|
$str.="{\"cate\":\"尺码有误\",\"data\":[".deel_end($tmp)."]},";
|
|
}
|
|
|
|
|
|
if(!$str){
|
|
$str.="{\"cate\":\"无误\",\"data\":[]},";
|
|
}
|
|
$json_data.="\"error\":[".deel_end($str)."],";
|
|
break;
|
|
case "get_size":
|
|
if($id){
|
|
$msg=get_db_msg("select * from ".$table_pre."kh where id='".$id."'");
|
|
$is_ggk=is_ggk($msg["id"]);
|
|
$arr=explode(",",$msg["color"]);
|
|
//价格
|
|
$show_price="吊牌价:".$msg["price"]."元/结算价".$msg["price_zk"]."元";
|
|
//取得杯型
|
|
$arrBx=array();
|
|
$r1=$db->query("select * from ".$table_pre."size_bx where no='".$msg["no"]."' order by bx");
|
|
$i1=0;
|
|
while($m1=$db->fetch_array($r1)){
|
|
$arrBx[$i1][]=$m1["bx"];
|
|
$arrBx[$i1][]=$m1["size"];
|
|
$i1++;
|
|
}
|
|
$show_bx=($i1>0)?"y":"n";
|
|
if(count($arrBx)==0){
|
|
$arrBx[0][0]="";
|
|
$arrBx[0][1]=$msg["size"];
|
|
}
|
|
|
|
$str_data="";
|
|
for($i=0;$i<count($arr);$i++){
|
|
if($is_ggk=="y"){
|
|
//有规格
|
|
$q1="select * from ".$table_pre."kh_gg where iid='".$msg["id"]."' and color='".$arr[$i]."'";
|
|
$r1=$db->query($q1);
|
|
$j=0;
|
|
while($m1=$db->fetch_array($r1)){
|
|
//尺码
|
|
$str_size="";
|
|
$arr1=explode(",",$msg["size"]);
|
|
for($k=0;$k<count($arr1);$k++){
|
|
$tmp=get_db_msg("select * from ".$table_pre."size where iid='".$msg["size_group"]."' and no='".$arr1[$k]."'");
|
|
$str_size.=$arr1[$k]."|".$tmp["title"].",";
|
|
}
|
|
if($str_size)
|
|
$str_size=substr($str_size,0,-1);
|
|
$str_data.="{\"is_gg\":\"y\",\"color_bx\":\"".$arr[$i]."_".$m1["gg"]."\",\"color_bx_title\":\"".$arr[$i]."-".get_cate_title_no("color",$arr[$i])."\",\"bx\":\"".get_gg_title($m1["gg"])."\",\"size\":\"".$str_size."\"},";
|
|
$j++;
|
|
}
|
|
}else{
|
|
//无规格
|
|
for($j=0;$j<count($arrBx);$j++){
|
|
|
|
//尺码
|
|
$str_size="";
|
|
$arr1=explode(",",$arrBx[$j][1]);
|
|
for($k=0;$k<count($arr1);$k++){
|
|
$tmp=get_db_msg("select * from ".$table_pre."size where iid='".$msg["size_group"]."' and no='".$arr1[$k]."'");
|
|
$str_size.=$arr1[$k]."|".$tmp["title"].",";
|
|
}
|
|
if($str_size)
|
|
$str_size=substr($str_size,0,-1);
|
|
$str_data.="{\"is_gg\":\"n\",\"color_bx\":\"".$arr[$i]."_".$arrBx[$j][0]."\",\"color_bx_title\":\"".$arr[$i]."-".get_cate_title_no("color",$arr[$i])."\",\"bx\":\"".$arrBx[$j][0]."\",\"size\":\"".$str_size."\"},";
|
|
}
|
|
}
|
|
}
|
|
|
|
if($str_data)
|
|
$str_data=substr($str_data,0,-1);
|
|
|
|
$json_data.="\"price\":\"".$show_price."\",";
|
|
$json_data.="\"data\":[".$str_data."],";
|
|
$json_data.="\"code\":1,";
|
|
}else{
|
|
$json_data.="\"code\":0,";
|
|
}
|
|
break;
|
|
case "add":
|
|
if($id){
|
|
$msg=get_db_msg("select * from ".$table_pre."kh_md where id='".$id."'");
|
|
$msg_kh=get_db_msg("select * from ".$table_pre."kh where no='".$msg["kh"]."'");
|
|
$arrBx=array();
|
|
if($bx_sizegroup_id>0){
|
|
//取得杯型
|
|
$r1=$db->query("select * from ".$table_pre."size_bx where no='".$msg["kh"]."' order by bx");
|
|
$i1=0;
|
|
while($m1=$db->fetch_array($r1)){
|
|
$arrBx[$i1][]=$m1["bx"];
|
|
$arrBx[$i1][]=$m1["size"];
|
|
$i1++;
|
|
}
|
|
}
|
|
if(count($arrBx)==0){
|
|
$arrBx[0][0]="";
|
|
$arrBx[0][1]=$msg_kh["size"];
|
|
}
|
|
$div_price="吊牌价:".$msg_kh["price"]."元/结算价".$msg_kh["price_zk"]."元";
|
|
|
|
//颜色,杯型,尺码
|
|
$arr_color=explode(",",$msg_kh["color"]);
|
|
for($i=0;$i<count($arr_color);$i++){
|
|
if($is_gg=="y"){
|
|
//有规格
|
|
$q1="select * from ".$table_pre."kh_gg where iid='".$msg_kh["id"]."' and color='".$arr_color[$i]."'";
|
|
$r1=$db->query($q1);
|
|
$j=0;
|
|
while($m1=$db->fetch_array($r1)){
|
|
$check=get_db_msg("select count(*) 'num' from ".$table_pre."kh_md where dj='".$msg["dj"]."' and kh='".$kh."' and color='".$arr_color[$i]."' and bx='".$m1["gg"]."'");
|
|
if($check["num"]>0){
|
|
$color_bx_sign="y";
|
|
}else{
|
|
$color_bx_sign="n";
|
|
}
|
|
$str_size="";
|
|
$arr_size=explode(",",$msg_kh["size"]);
|
|
for($j=0;$j<count($arr_size);$j++){
|
|
$check=get_db_msg("select size from ".$table_pre."kh_md where dj='".$msg["dj"]."' and kh='".$kh."' and color='".$arr_color[$i]."' and bx='".$m1["gg"]."'");
|
|
$check=explode(",",$check["size"]);
|
|
if(in_array($arr_size[$j],$check)){
|
|
$size_sign="y";
|
|
}else{
|
|
$size_sign="n";
|
|
}
|
|
$tmp=get_db_msg("select * from ".$table_pre."size where iid='".$msg_kh["size_group"]."' and no='".$arr_size[$j]."'");
|
|
$str_size.=$arr_size[$j]."|".$tmp["title"]."|".$size_sign.",";
|
|
}
|
|
if($str_size)
|
|
$str_size=substr($str_size,0,-1);
|
|
$str_data.="{\"is_gg\":\"n\",\"color_bx\":\"".$arr_color[$i]."_".$m1["gg"]."\",\"color_bx_sign\":\"".$color_bx_sign."\",\"color_bx_title\":\"".$arr_color[$i]."-".get_cate_title_no("color",$arr_color[$i])."\",\"bx\":\"".get_gg_title($m1["gg"])."\",\"size\":\"".$str_size."\"},";
|
|
}
|
|
}else{
|
|
//无规格
|
|
for($k=0;$k<count($arrBx);$k++){
|
|
$check=get_db_msg("select count(*) 'num' from ".$table_pre."kh_md where dj='".$msg["dj"]."' and kh='".$kh."' and color='".$arr_color[$i]."' and bx='".$arrBx[$k][0]."'");
|
|
if($check["num"]>0){
|
|
$color_bx_sign="y";
|
|
}else{
|
|
$color_bx_sign="n";
|
|
}
|
|
$str_size="";
|
|
$arr_size=explode(",",$arrBx[$k][1]);
|
|
for($j=0;$j<count($arr_size);$j++){
|
|
$check=get_db_msg("select size from ".$table_pre."kh_md where dj='".$msg["dj"]."' and kh='".$kh."' and color='".$arr_color[$i]."' and bx='".$arrBx[$k][0]."'");
|
|
$check=explode(",",$check["size"]);
|
|
if(in_array($arr_size[$j],$check)){
|
|
$size_sign="y";
|
|
}else{
|
|
$size_sign="n";
|
|
}
|
|
$tmp=get_db_msg("select * from ".$table_pre."size where iid='".$msg_kh["size_group"]."' and no='".$arr_size[$j]."'");
|
|
$str_size.=$arr_size[$j]."|".$tmp["title"]."|".$size_sign.",";
|
|
}
|
|
if($str_size)
|
|
$str_size=substr($str_size,0,-1);
|
|
$str_data.="{\"is_gg\":\"n\",\"color_bx\":\"".$arr_color[$i]."_".$arrBx[$k][0]."\",\"color_bx_sign\":\"".$color_bx_sign."\",\"color_bx_title\":\"".$arr_color[$i]."-".get_cate_title_no("color",$arr_color[$i])."\",\"bx\":\"".$arrBx[$k][0]."\",\"size\":\"".$str_size."\"},";
|
|
}
|
|
}
|
|
}
|
|
|
|
//
|
|
$price=$msg["price"];
|
|
$s_no=$kh;
|
|
$dj=$msg["dj"];
|
|
}else{
|
|
|
|
}
|
|
|
|
//取得店铺等级
|
|
$ct=0;
|
|
$tmp_dj="";
|
|
$q1="select dj from ".$table_pre."client where dj<>'' group by dj order by dj";
|
|
$r1=$db->query($q1);
|
|
while($m1=$db->fetch_array($r1)){
|
|
$tmp_dj.="{\"no\":\"".$m1["dj"]."\",\"title\":\"".$m1["dj"]."\"},";
|
|
$ct++;
|
|
}
|
|
if($ct>0){
|
|
$json_data.="\"s_show_dj\":\"y\",";
|
|
}else{
|
|
$json_data.="\"s_show_dj\":\"n\",";
|
|
}
|
|
$tmp_dj=deel_end($tmp_dj);
|
|
$json_data.="\"select_dj\":{\"no\":\"dj\",\"title\":\"店铺等级\",\"value\":\"".$dj."\",\"op\":[".$tmp_dj."]},";
|
|
$json_data.="\"price\":\"".$price."\",";
|
|
$json_data.="\"s_no\":\"".$s_no."\",";
|
|
$json_data.="\"dpj\":\"".$div_price."\",";
|
|
if($str_data)
|
|
$str_data=substr($str_data,0,-1);
|
|
$json_data.="\"data\":[".$str_data."],";
|
|
break;
|
|
case "save_add":
|
|
$msg_old=get_db_msg("select * from ".$table_pre."kh_md where id='".$id."'");
|
|
$msg_kh=get_db_msg("select * from ".$table_pre."kh where no='".$s_no."'");
|
|
if(!$msg_kh["id"]){
|
|
$json_data.="\"code\":0,\"msg\":\"款号有误，请检查!\",";
|
|
}else{
|
|
$arr_color_kh=explode(",",$msg_kh["color"]);
|
|
$arr_size_kh=explode(",",$msg_kh["size"]);
|
|
$color_bx=is_array($color_bx)?$color_bx:array($color_bx);
|
|
//print_r($color_bx);
|
|
if($msg_old["dj"]!=$dj){
|
|
$q="delete from ".$table_pre."kh_md where dj='".$msg_old["dj"]."' and kh='".$s_no."'";
|
|
//echo $q."<br>";
|
|
$db->query($q);
|
|
}
|
|
|
|
//删除多余数据
|
|
$q="select * from ".$table_pre."kh_md where dj='".$dj."' and kh='".$s_no."'";
|
|
$r=$db->query($q);
|
|
while($m=$db->fetch_array($r)){
|
|
if(!in_array($m["color"]."_".$m["bx"],$color_bx)){
|
|
$q1="delete from ".$table_pre."kh_md where id='".$m["id"]."'";
|
|
//echo $q1."<br>";
|
|
$db->query($q1);
|
|
}
|
|
}
|
|
|
|
//
|
|
if(count($color_bx)>0){
|
|
for($i=0;$i<count($color_bx);$i++){
|
|
$v1="size_".$color_bx[$i];
|
|
|
|
$r22="";
|
|
if(is_array($$v1)){
|
|
foreach($$v1 as $k22=>$v22){
|
|
$r22.=$v22.",";
|
|
}
|
|
}
|
|
$size1=substr($r22,0,-1);
|
|
|
|
$tmp=explode("_",$color_bx[$i]);
|
|
$check=get_db_msg("select * from ".$table_pre."kh_md where dj='".$dj."' and kh='".$s_no."' and color='".$tmp[0]."' and bx='".$tmp[1]."'");
|
|
if($check["id"]>0){
|
|
$q="update ".$table_pre."kh_md set price='".$price."',size='".$size1."' where id='".$check["id"]."'";
|
|
}else{
|
|
$q="insert into ".$table_pre."kh_md (dj,kh,price,color,bx,size) values ('".$dj."','".$s_no."','".$price."','".$tmp[0]."','".$tmp[1]."','".$size1."')";
|
|
}
|
|
//echo $q."<br>";
|
|
$db->query($q);
|
|
}
|
|
}else{
|
|
//
|
|
$check=get_db_msg("select * from ".$table_pre."kh_md where dj='".$dj."' and kh='".$s_no."'");
|
|
if($check["id"]>0){
|
|
$q="update ".$table_pre."kh_md set price='".$price."' where id='".$check["id"]."'";
|
|
}else{
|
|
$q="insert into ".$table_pre."kh_md (dj,kh,price) values ('".$dj."','".$s_no."','".$price."')";
|
|
}
|
|
//echo $q."<br>";
|
|
$db->query($q);
|
|
}
|
|
|
|
if($id)
|
|
$log_action="更新";
|
|
else
|
|
$log_action="新增";
|
|
set_log($log_action."买断款",$kh);
|
|
|
|
$json_data.="\"code\":1,";
|
|
}
|
|
|
|
break;
|
|
case "del" :
|
|
$id=(is_array($id))?$id:array($id);
|
|
$num=count($id);
|
|
for($i=0;$i<$num;$i++){
|
|
$arr1=explode("|",$id[$i]);
|
|
$q="delete from ".$table_pre."kh_md where dj='".$arr1[0]."' and kh='".$arr1[1]."'";
|
|
$db->query($q);
|
|
$lid.=$arr1[0]."|".$arr1[1].", ";
|
|
}
|
|
$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_md);
|
|
$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_md as $k => $v){
|
|
$column.=$v.",";
|
|
}
|
|
if($column)
|
|
$column=substr($column,0,-1);
|
|
$msg1=array();
|
|
$msg1[0]=array("可导入正确字段",$column);
|
|
//
|
|
$column="";
|
|
for($i=0;$i<count($arr_thead);$i++){
|
|
if(in_array(get_main_key($arr_column_kh_md,$arr_thead[$i]),$arr_column[1])){
|
|
$style=" style='font-weight:bold;color:#0000ff'";
|
|
}else{
|
|
$style=" style='color:#cccccc'";
|
|
}
|
|
$column.="<span".$style.">".$arr_thead[$i]."</span>,";
|
|
}
|
|
if($column)
|
|
$column=substr($column,0,-1);
|
|
//
|
|
$msg1[1]=array("检测到的有效字段",$column);
|
|
//
|
|
$total=count($arr_content)-1;
|
|
$msg1[2]=array("记录条数",$total);
|
|
$m1="";
|
|
for($i=0;$i<count($msg1);$i++){
|
|
$m1.="{\"col1\":\"".$msg1[$i][0]."\",\"col2\":\"".$msg1[$i][1]."\"},";
|
|
}
|
|
if($m1)
|
|
$m1=substr($m1,0,-1);
|
|
$json_data.="\"code\":1,\"tmp_file_name\":\"".$tmp_file_name."\",\"msg\":[".$m1."],";
|
|
$json_data.="\"input\":[{\"type\":\"radio\",\"title\":\"导入方式\",\"name\":\"import_type\",\"op\":\"清空导入|新增导入\",\"value\":\"清空导入\"}],";
|
|
}
|
|
break;
|
|
case "import_do":
|
|
$import_type=($import_type=="清空导入")?"y":"n";
|
|
if($import_type=="y"){
|
|
$db->query("TRUNCATE TABLE web_kh_md;");
|
|
}
|
|
$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_md);
|
|
$insert_column="";
|
|
for($i=0;$i<count($arr_column[1]);$i++){
|
|
$ititle=$arr_column[1][$i];
|
|
$insert_column.=$arr_column[1][$i].",";
|
|
}
|
|
$insert_column=substr($insert_column,0,-1);
|
|
|
|
for($i=1;$i<count($arr_content);$i++){
|
|
$tmp_arr=explode("|^_^|",$arr_content[$i]);
|
|
|
|
//取得款号
|
|
$kh="";
|
|
for($k=0;$k<count($arr_column[0]);$k++){
|
|
$ind=$arr_column[0][$k];
|
|
$ititle=$arr_column[1][$k];
|
|
if($ititle=="kh"){
|
|
$kh=trim($tmp_arr[$ind]);
|
|
}
|
|
}
|
|
|
|
$m_kh=get_db_msg("select * from ".$table_pre."kh where no='".$kh."'");
|
|
$insert_value="";
|
|
for($k=0;$k<count($arr_column[0]);$k++){
|
|
$ind=$arr_column[0][$k];
|
|
$ititle=$arr_column[1][$k];
|
|
if($ititle=="size"){
|
|
$v1="";
|
|
$tmp1=explode(",",trim($tmp_arr[$ind]));
|
|
for($k1=0;$k1<count($tmp1);$k1++){
|
|
$tmp=get_db_msg("select * from ".$table_pre."size where iid='".$m_kh["size_group"]."' and title='".$tmp1[$k1]."'");
|
|
$v1.=$tmp["no"].",";
|
|
}
|
|
if($v1)
|
|
$v1=substr($v1,0,-1);
|
|
$insert_value.="'".mysql_escape_string($v1)."',";
|
|
}else{
|
|
if($is_gg=="y" && $ititle=="bx")
|
|
$insert_value.="'".mysql_escape_string(get_gg_id(trim($tmp_arr[$ind])))."',";
|
|
else
|
|
$insert_value.="'".mysql_escape_string(trim($tmp_arr[$ind]))."',";
|
|
}
|
|
}
|
|
|
|
$insert_value=substr($insert_value,0,-1);
|
|
$q="insert into ".$table_pre."kh_md (".$insert_column.") values (".$insert_value.")";
|
|
//echo $q."<br>";
|
|
$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_md 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_md 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_md,$ex_col[$i]);
|
|
}
|
|
|
|
$query="select * from ".$table_pre."kh_md order by kh";
|
|
$r=$db->query($query);
|
|
$row=0;
|
|
while($m=$db->fetch_array($r)){
|
|
$m_kh=get_db_msg("select * from ".$table_pre."kh where no='".$m["kh"]."'");
|
|
$arr_color=explode(",",$m["color"]);
|
|
for($j=0;$j<count($arr_color);$j++){
|
|
for($i=0;$i<$num;$i++){
|
|
$k=$ex_col[$i];
|
|
if($k=="size"){
|
|
$v1="";
|
|
$tmp1=explode(",",$m[$k]);
|
|
for($k1=0;$k1<count($tmp1);$k1++){
|
|
$tmp=get_db_msg("select * from ".$table_pre."size where iid='".$m_kh["size_group"]."' and no='".$tmp1[$k1]."'");
|
|
$v1.=$tmp["title"].",";
|
|
}
|
|
if($v1)
|
|
$v1=substr($v1,0,-1);
|
|
$data["body"][$row][]=$v1;
|
|
}else if($k=="color"){
|
|
$data["body"][$row][]=$arr_color[$j];
|
|
}else{
|
|
if($is_gg=="y" && $k=="bx")
|
|
$data["body"][$row][]=get_gg_title($m[$k]);
|
|
else
|
|
$data["body"][$row][]=$m[$k];
|
|
}
|
|
}
|
|
$row++;
|
|
}
|
|
}
|
|
|
|
$file_name="kh_md_".date("Y-m-d-H-i");
|
|
output_excel($file_name,$data);
|
|
set_log("导出 买断款信息");
|
|
exit;
|
|
break;
|
|
default:
|
|
$op="";
|
|
$q1="select dj from ".$table_pre."client where dj<>'' group by dj order by dj";
|
|
$r1=$db->query($q1);
|
|
while($m1=$db->fetch_array($r1)){
|
|
$op.="{\"no\":\"".$m1["dj"]."\",\"title\":\"".$m1["dj"]."\"},";
|
|
}
|
|
$op=deel_end($op);
|
|
$json_data.="\"select_dpdj\":{\"no\":\"s_dj\",\"title\":\"店铺等级\",\"value\":\"".$s_dj."\",\"op\":[".$op."]},";
|
|
|
|
//
|
|
$page=$page>0?$page:1;
|
|
$limit=$limit>0?$limit:10;
|
|
$start=($page-1)*$limit;
|
|
$end=$limit;
|
|
|
|
$sql_con="";
|
|
if($s_no)
|
|
$sql_con.="kh like '%".$s_no."%' and ";
|
|
if($s_dj)
|
|
$sql_con.="dj='".$s_dj."' and ";
|
|
if($sql_con)
|
|
$sql_con="where ".substr($sql_con,0,-4);
|
|
|
|
//取得总条数
|
|
$tmp=get_db_msg("select count(distinct kh) 'num' from ".$table_pre."kh_md ".$sql_con);
|
|
$total_num=$tmp["num"];
|
|
|
|
$json_data.="\"code\":0,\"msg\":\"\",\"count\":".$total_num.",\"data\":[";
|
|
$count=1;
|
|
$str_tmp="";
|
|
$sql="select * from ".$table_pre."kh_md ".$sql_con." group by dj,kh order by dj,kh limit ".$start.",".$end;
|
|
$res=$db->query($sql);
|
|
while($msg=$db->fetch_array($res)){
|
|
$msg_kh=get_db_msg("select * from ".$table_pre."kh where no='".$msg["kh"]."'");
|
|
$is_ggk=is_ggk($msg_kh["id"]);
|
|
$p="";
|
|
if($msg_kh["price"]>0){
|
|
$p.=" ￥".$msg_kh["price"]."元 ";
|
|
}
|
|
if($msg_kh["price_zk"]>0){
|
|
$p.=" ￥".$msg_kh["price_zk"]."元 ";
|
|
}
|
|
$this_dpdj=trim($msg["dj"])?trim($msg["dj"]):"所有店铺";
|
|
|
|
//颜色
|
|
$str="";
|
|
$q="select * from ".$table_pre."kh_md where dj='".$msg["dj"]."' and kh='".$msg["kh"]."' order by color";
|
|
$r=$db->query($q);
|
|
while($m=$db->fetch_array($r)){
|
|
if(trim($m["color"])){
|
|
if($is_ggk=="y"){
|
|
$str_bx=get_gg_title($m["bx"]);
|
|
}else{
|
|
$str_bx=$m["bx"];
|
|
}
|
|
|
|
//尺码
|
|
$str_size="";
|
|
if(trim($m["size"])){
|
|
$arr1=explode(",",$m["size"]);
|
|
for($j=0;$j<count($arr1);$j++){
|
|
$tmp=get_db_msg("select * from ".$table_pre."size where iid='".$msg_kh["size_group"]."' and no='".$arr1[$j]."'");
|
|
$str_size.=$tmp["title"].",";
|
|
}
|
|
}
|
|
|
|
$str.="{\"color\":\"".$m["color"]."-".get_cate_title_no("color",$m["color"])."\",\"bx\":\"".$str_bx."\",\"size\":\"".substr($str_size,0,-1)."\"},";
|
|
}
|
|
}
|
|
|
|
$list=$count+$start;
|
|
$str_tmp.="{";
|
|
$str_tmp.="\"ct\":\"".$list."\",";
|
|
$str_tmp.="\"dpdj\":\"".$this_dpdj."\",";
|
|
$str_tmp.="\"dj\":\"".$msg["dj"]."\",";
|
|
$str_tmp.="\"id\":\"".$msg["id"]."\",";
|
|
$str_tmp.="\"kh\":\"".$msg["kh"]."\",";
|
|
$str_tmp.="\"jsj\":\"".$p."\",";
|
|
$str_tmp.="\"mdj\":\"".$msg["price"]."\",";
|
|
$str_tmp.="\"detail\":[".substr($str,0,-1)."]";
|
|
$str_tmp.="},";
|
|
$count++;
|
|
}
|
|
$json_data.=substr($str_tmp,0,-1)."],";
|
|
break;
|
|
}
|
|
}
|
|
$json_data=substr($json_data,0,-1)."}";
|
|
echo $json_data;
|
|
?>
|