where('store_id',getAdmStoId())->where('type',4)->find(); if($rs){ if($rs['end_time']redirect(U('Admin/jddj/not_jd')); $this->assign('end_time',$rs['end_time']); }else{ $this->redirect(U('Admin/jddj/not_jd')); } } } //基础信息 public function config() { $getadmstoid=getAdmStoId(); $info=M('jd_store')->where(array('store_id'=>$getadmstoid))->find(); $this->assign("config",$info); return $this->fetch('', getAdmStoId()); } //基础信息 public function handle() { $param = I('post.'); $getadmstoid=getAdmStoId(); $accdb=getERPId(); $venderid=$param['venderid'];//商家编号 $infoexit=M('jd_store')->where(array('venderid'=>$venderid,'store_id'=>array('neq',getAdmStoId())))->find(); if ($infoexit) { $this->error("该商家编号已被使用,请输入其他商家编号", U('Jddj/config')); exit; } $info=M('jd_store')->where(array('store_id'=>$getadmstoid))->find(); $param['store_id']=$getadmstoid; $param['accdb']=$accdb; if ($info) { M('jd_store')->where(array('store_id'=>$getadmstoid))->save($param); } else { M('jd_store')->save($param); } $this->success("操作成功", U('Jddj/config')); exit; } //-------商品管理------------ public function goods_up() { $id = getAdmStoId(); return $this->fetch('', getAdmStoId()); } public function ajax_goods_up() { $id = getAdmStoId(); $p=I("p"); $pagesize=20; $data=["pageSize"=>$pagesize,'pageNo'=>$p,'isFilterDel'=>"0"]; $gname=I("goods_name"); $gsn=I("goods_sn"); $jsku=I("dd_sku"); if(trim($gname)) $data['skuName']=trim($gname); if(trim($gsn)) $data['skuId']=trim($gsn); if(trim($jsku)) $data['upcCode']=trim($jsku); $oldurl = U('Admin/jddj/goods_up', array( "goods_name" => $gname, "goods_sn" => $gsn, "dd_sku" => $jsku, "p" => $p, )); $this->assign('oldurl', urlencode($oldurl)); $rs=jd_api('/pms/querySkuInfos',$data,$id); $rs=json_decode($rs,true); if($rs['code']==0){ $list= json_decode($rs['data'],true); if($list['result']['count']>0){ $city=F('jd_city'); if(empty($city)){ $city=$this->get_jd_city(); Cache::set("jd_city",$city,3600*4); } if($list['result']['result']!=null) { $glist=json_decode($list['result']['result'],true); foreach ($glist as $kl=>$vl){ $str=""; $cell_city=$vl['sellCities']; foreach($cell_city as $kk=>$vv){ if($vv==0) { $str = "全国";break; } else{ foreach ($city as $kc=>$vc){ if($vc['areaCode']==$vv){ $str.=$vc['areaName']." "; } } } } $glist[$kl]['scity']=$str; } Cache::set("ajax_cgoodsList_".$id,$glist,3600*4); $this->assign("goodsList",$glist); } $Page = new AjaxPage($list['result']['count'],$pagesize); $show=$Page->show(); $this->assign('page',$show);// 赋值分页输出 $this->assign('pager',$Page); } } return $this->fetch('', getAdmStoId()); } //---订单管理--- public function orderlist() { $id = getAdmStoId(); $p=I("p/d",1); $pagesize=500; $data=["pageSize"=>$pagesize,'pageNo'=>$p]; $rs=jd_api('/order/es/query',null,$id); $rs=json_decode($rs,true); if($rs['code']==0){ $list= json_decode($rs['data'],true); if($list['result']['count']>0){ if($list['result']['result']!=null) { $glist=json_decode($list['result']['result'],true); $this->assign("goodsList",$glist); } $Page = new AjaxPage($list['result']['count'],$pagesize); $show=$Page->show(); $this->assign('page',$show);// 赋值分页输出 $this->assign('pager',$Page); } } } //--------门店管理------------- function format_time($i){ if($i==48) return "23:59"; $fir = "";$end = ""; if ($i % 2 > 0) { $fir = ($i - 1) / 2;$end = ":30"; } else { $fir = $i / 2;$end = ":00"; } if (strlen($fir) == 1) $fir = "0" . $fir; return $fir . $end; } public function sto_up() { return $this->fetch('', getAdmStoId()); } public function ajax_sto_up() { $id = getAdmStoId(); $p=I("p"); $oldurl = U('Admin/jddj/sto_up', array( "p" => $p, )); $this->assign('oldurl', urlencode($oldurl)); $data=null; $rs=jd_api('/store/getStationsByVenderId ',$data,$id); $rs=json_decode($rs,true); $glist=null; if($rs['code']==0){ $list=json_decode($rs['data'],true); $arr=$list['result']; $count=count($arr); if($count>0){ $fir=($p-1)*20; $end=$p*20; if($fir<$count){ if($end>$count) $end=$count; for($i=$fir;$i<$end;$i++){ $data1['StoreNo']=$arr[$i]; $rss=jd_api('/storeapi/getStoreInfoByStationNo',$data1,$id); $rss=json_decode($rss,true); $md=json_decode($rss['data'],true)['result']; $md['updateTime']=date('Y-m-d H:i:s',$md['updateTime']['time']/1000); $md['createTime']=date('Y-m-d H:i:s',$md['createTime']['time']/1000); $md['serviceTimeStart1']=$this->format_time($md['serviceTimeStart1']); $md['serviceTimeEnd1']=$this->format_time($md['serviceTimeEnd1']); if(empty($md['cityName'])){ $rs=M("jd_sto")->where('store_id',$id) ->where('stationNo', $data1['StoreNo'])->field('cityname,townname')->find(); $md['cityName']=$rs['cityname']; $md['countyName']=$rs['townname']; } $glist[]=$md; } $jj=json_encode($glist); $this->assign("goodsList",$glist); $Page = new AjaxPage(count($list['result']),20); $show=$Page->show(); $this->assign('page',$show);// 赋值分页输出 $this->assign('pager',$Page); } } } return $this->fetch('', getAdmStoId()); } public function search_goods() { $GoodsLogic = new GoodsLogic; $brandList = $GoodsLogic->getSortBrands(); $this->assign('brandList', $brandList); $categoryList = $GoodsLogic->getSortCategory(); $this->assign('categoryList', $categoryList); $type = I('type', ''); $isall = I('isall/d', 0);//是否显示全部 $where=""; $where = "is_jd=0 and weight>0 and is_on_sale = 1 and store_count>0 and store_id=" . getAdmStoId() ;//搜索条件 $this->assign('type', $type); $intro = I('intro'); if (!empty($intro)) { $where = "$where and " . I('intro') . " = 1"; $this->assign('intro', $intro); } if (I('cat_id')) { $this->assign('cat_id', I('cat_id')); $grandson_ids = getCatGrandson(I('cat_id')); $where = " $where and cat_id in(" . implode(',', $grandson_ids) . ") "; // 初始化搜索条件 } if (I('brand_id')) { $this->assign('brand_id', I('brand_id')); $where = "$where and brand_id = " . I('brand_id'); } $kword = urldecode(urldecode(I('keywords/s'))); if (!empty($kword)) { $this->assign('keywords', $kword); $where = "$where and (goods_sn like '%" . $kword . "%' or goods_name like '%" . $kword . "%' or keywords like '%" . $kword . "%' or sku = '" . $kword . "')"; } $t=time(); $where.=" and on_time<".$t." and (down_time>".$t." or down_time=0 or down_time='' or down_time is null)"; $count = M('goods')->where($where)->count(); $Page = new Page($count, 8); $goodsList = M('goods')->where($where)->order('goods_id DESC')->limit($Page->firstRow . ',' . $Page->listRows)->select(); $show = $Page->show();//分页显示输出 $this->assign('page', $show);//赋值分页输出 $this->assign('goodsList', $goodsList); $this->assign('pager', $Page);//赋值分页输出 return $this->fetch("", getAdmStoId()); } //获取京东分类列表 public function jd_categoty(){ $stoid = getAdmStoId(); $p_id=I('pid',0); $data['id']=$p_id; $data['fields']=["ID","CATEGORY_NAME","CATEGORY_LEVEL","CATEGORY_STATUS"]; $rs=jd_api('/api/queryChildCategoriesForOP',$data,$stoid); $rs=json_decode($rs,true); if($rs['code']==0){ $data=json_decode($rs['data'],true); return json(["code"=>0,'data'=>$data['result']]); }else{ return json(['code'=>-1,'msg'=>'获取失败']); } } //---获取商家店内分类列表---- public function sto_categoty(){ $stoid = getAdmStoId(); $data['fields']=["ID","PID","SHOP_CATEGORY_NAME","SORT",]; $rs=jd_api('/pms/queryCategoriesByOrgCode',$data,$stoid); $rs=json_decode($rs,true); if($rs['code']==0){ $data=json_decode($rs['data'],true); return json(["code"=>0,'data'=>$data['result']]); }else{ return json(['code'=>-1,'msg'=>'获取失败']); } } //----------选择品牌-------------- public function search_brand() { $id = getAdmStoId(); $p=I("p",1); $key=I("keywords"); $this->assign('keywords', $key);//赋值分页输出 $pagesize=10; $data=["pageSize"=>$pagesize,'pageNo'=>$p,'fields'=>['BRAND_ID','BRAND_NAME','BRAND_STATUS']]; if($key){ $data['brandName']=urldecode(urldecode($key)); } $rs=jd_api('/pms/queryPageBrandInfo',$data,$id); $rs=json_decode($rs,true); if($rs['code']==0){ $list= json_decode($rs['data'],true); if($list['result']['count']>0){ if($list['result']['result']!=null) { $glist=$list['result']['result']; $this->assign("goodsList",$glist); } $Page = new Page($list['result']['count'], $pagesize); $this->assign('pager',$Page); $show = $Page->show();//分页显示输出 $this->assign('page', $show);//赋值分页输出 } } return $this->fetch('', getAdmStoId()); } //--------插入商品----------- public function insert_goods(){ try { $stoid = getAdmStoId(); $gid = I("gid"); $cat_id=I("cat_id"); $fir_id=I("fir_cat_id"); $sec_id=I("sec_cat_id"); $sto_cate_id=I("sto_cate_id"); $sbrand=I("sbrand"); $upfilepath = ROOT_PATH . "public/upload/jddj/" . $stoid . "/"; //磁盘地址 if (!is_dir($upfilepath)) mkdir($upfilepath, 0777, true); $path = "/public/upload/jddj/" . $stoid . "/"; //目录 //$Host = curHostURL(); //本机地址 $Host = "http://mshop-api.yolipai.net/"; //本机地址 $glist = M("goods")->where("goods_id in(" . $gid . ")") ->where('is_jd',0) ->where('store_id', getAdmStoId())->select(); if ($glist) { foreach ($glist as $k => $v) { $fir = "https://mshopimg.yolipai.net"; $img = $fir . $v['original_img']; $filename = uniqid() . "0.jpg"; $img = file_get_contents($img); file_put_contents($upfilepath . $filename, $img); //强制格式800*800 m_format_img($upfilepath . $filename, 800); $fialename_arr[] = $Host . $path . $filename; $file_path[] = $upfilepath . $filename; $imglist = M("goods_images")->where("goods_id", $v['goods_id']) ->where('store_id', $stoid)->where('ismain', 0) ->field('image_url') ->select(); if ($imglist) { $int = 1; foreach ($imglist as $kk => $vv) { $img = $fir . $vv['image_url']; $filename = uniqid() . $int . ".jpg"; $img = file_get_contents($img); file_put_contents($upfilepath . $filename, $img); //强制格式800*800 m_format_img($upfilepath . $filename, 800); $fialename_arr[] = $Host . $path . $filename; $file_path[] = $upfilepath . $filename; $int++; } } $data['images'] = implode(",", $fialename_arr); if($v['weight']<=0){ return json(['code'=>-1,"msg"=>$v['goods_name']."重量没有设置!!"]); } $data['outSkuId'] = $v['goods_sn']; //商品编号 $data['upcCode'] = $v['sku']; //条码 $data['skuName'] = $v['goods_name']; //商品名称 $data['skuPrice'] = $v['shop_price']*100; //商品价格,要乘以100 $data['fixedStatus'] = 1; //商品上架 $data['weight'] = $v['weight']/1000; //商品重量 $data['images'] = $data['images']; //商品图片 $data['categoryId'] = $cat_id; //商品归类 $data['shopCategories'] = $sto_cate_id; //商品店内归类 $data['brandId'] = $sbrand; //商品导入的品牌ID $data['isSale'] = true; //商品是否可销售 $data['productDesc'] = $v['goods_content']; //商品描述 //$jj=json_encode($data); $rs = jd_api('/pms/sku/addSku', $data, $stoid); mlog($rs."--".json_encode($data),"jddj_insert_goods/".$stoid); $rs_a=json_decode($rs,true)['data']; $rs_a=json_decode($rs_a,true); if($rs_a['code']!=0){ return json(['code'=>-1,"msg"=>$v['goods_name'].$rs_a['msg']]); } mlog("图片--".$data['images'],"jddj_insert_goods/".$stoid); $da['outsku']= $data['outSkuId']; $da['images']= $data['images']; $da['firid']= $fir_id; $da['secid']= $sec_id; $da['store_id']= $stoid; M("jd_sku")->save($da); M("goods")->where('goods_id',$v['goods_id']) ->where("store_id",$stoid)->save(['is_jd'=>1]); } } return json(['code'=>0,"msg"=>"插入成功"]); } catch (\Exception $e){ return json(['code'=>-1,"msg"=>$e->getMessage()]); } } //---搜索分类---- public function search_cate(){ $gcate=M("goods_category")->where('level',1) ->where('store_id',getAdmStoId())->select(); $fir_id=I("fir_id"); $key=I("keywords"); $list=null; $where="1=1"; if($fir_id){ $where.=" and parent_id=".$fir_id; } if($key){$where.=" and name like '%".$key."%'";} if($where!="1=1"){ $gcate2=M("goods_category")->where($where)->where('store_id',getAdmStoId()) ->where('is_jd',0) ->select(); $list=$gcate2; }else{ foreach ($gcate as $k=>$v){ if($v['is_jd']==0) $list[]=$v; } } $this->assign("cateList",$gcate); $this->assign("clist",$list); return $this->fetch('',getAdmStoId()); } //--------插入品类----------- public function insert_cate(){ try { $stoid = getAdmStoId(); $cat_id=I("cid"); $glist = M("goods_category")->where("id in(" . $cat_id . ")") ->where('is_jd',0) ->where('store_id', getAdmStoId())->select(); if ($glist) { foreach ($glist as $k => $v) { $data=null; if($v['parent_id']) { $fc = M("goods_category")->where("id", $v['parent_id']) ->where('is_jd', 1) ->field('jd_id')->find(); if ($fc && $fc['jd_id']) { $data['pid'] = $fc['jd_id']; //京东的父层id } else { return json(['code' => -1, "msg" => $v['name'] . "的父层分类还没导入"]); } } else { $data['pid'] = 0; } $data['shopCategoryName'] = $v['name']; //名称 //$jj=json_encode($data); $rs = jd_api('/pms/addShopCategory', $data, $stoid); $rs_a=json_decode($rs,true)['data']; $rs_a=json_decode($rs_a,true); if($rs_a['code']!=0){ return json(['code'=>-1,"msg"=>$v['goods_name'].$rs_a['msg']]); } $jd_id=$rs_a['result']['id']; M("goods_category")->where('id',$v['id']) ->where("store_id",$stoid)->save(['is_jd'=>1,'jd_id'=>$jd_id]); mlog($rs, "addShopCategory/" . $stoid); } } return json(['code'=>0,"msg"=>"插入成功"]); } catch (\Exception $e){ return json(['code'=>-1,"msg"=>$e->getMessage()]); } } //--------搜索门店------- public function search_mendian(){ $type = I('type', ''); $isall = I('isall/d', 0);//是否显示全部 $where=""; $where = "is_jd=0 and store_id=" . getAdmStoId() ;//搜索条件 $kword = urldecode(urldecode(I('keywords/s'))); if (!empty($kword)) { $this->assign('keywords', $kword); $where = "$where and pickup_name like '%" . $kword . "%'"; } $prov_id=I("prov_id"); if($prov_id) $where.=" and province_id=".$prov_id; $city_id=I("city_id"); if($city_id) $where.=" and city_id=".$city_id; $dis_id=I("dis_id"); if($dis_id) $where.=" and district_id=".$dis_id; $category_id=I("category_id"); if($category_id) $where.=" and category_id=".$category_id; $count = M('pick_up')->where($where)->count(); $Page = new Page($count, 8); $goodsList = M('pick_up')->where($where)->order('pickup_id DESC')->limit($Page->firstRow . ',' . $Page->listRows)->select(); $show = $Page->show();//分页显示输出 $this->assign('page', $show);//赋值分页输出 $this->assign('goodsList', $goodsList); $this->assign('pager', $Page);//赋值分页输出 $this->assign('prov_id', $prov_id);//省 $this->assign('city_id', $city_id);//市 $this->assign('dis_id', $dis_id); //区 $this->assign('category_id', $category_id); //门店分类 $rg=M("region")->where('parent_id',0)->select(); $this->assign('rg', $rg);//赋值分页输出 if($city_id){ $rg=M("region")->where('parent_id',$prov_id)->select(); $this->assign('rg1', $rg);//赋值分页输出 } if($dis_id){ $rg=M("region")->where('parent_id',$city_id)->select(); $this->assign('rg2', $rg);//赋值分页输出 } $sto_c=M("storage_category")->where('store_id',getAdmStoId())->select(); $this->assign('sto_c', $sto_c);//赋值分页输出 return $this->fetch("", getAdmStoId()); } //----------------插入门店------------------ public function insert_mendian(){ $stoid=getAdmStoId(); $mid=I("mid"); $radius=I("radius"); $t_s=I('time_start'); $t_e=I('time_end'); //先缓存京东的城市,如果京东的城市缓存已经过期 $city=F('jd_city'); if(empty($city)){ $city=$this->get_jd_city(); Cache::set("jd_city",$city,3600*4); } $plist = M("pick_up")->where("pickup_id in(" . $mid . ")") ->where('is_jd',0) ->where('store_id',$stoid)->select(); if ($plist) { foreach ($plist as $k => $v) { if(empty($v['pickup_phone'])) { return json(['code' => -1, "msg" => '联系电话不能为空']); } if(empty($v['pickup_contact'])) { return json(['code' => -1, "msg" => '门店管理员不能为空']); } if(empty($v['province_id']) || empty($v['city_id']) || empty($v['district_id']) ) { return json(['code' => -1, "msg" => '门店地区不能为空']); } $data['stationName'] = $v['pickup_name']; //门店名称 $data['outSystemId'] = $v['pickup_no']; //门店编号 $data['phone'] = $v['pickup_phone']; //门店电话 $data['stationName'] = $v['pickup_name']; //门店名称 $data['stationAddress'] = $v['pickup_address']; //门店地址 $data['operator'] = $v['pickup_contact']; //管理员 //-------计算时间-------- /*---- if($t_s=="23:59") $t_s=48; else{ $arr0=explode(":",$t_s); $num0=$arr0[0]*2+($arr0[0]>30?1:0); $t_s=$num0; } if($t_e=="23:59") $t_e=48; else{ $arr=explode(":",$t_e); $num=$arr[0]*2+($arr[0]>30?1:0); $t_e=$num; }---*/ $data['serviceTimeStart1'] = $t_s; //营业开始时间 $data['serviceTimeEnd1'] = $t_e; //营业结束时间 $data['lat'] = $v['lat']; //纬度 $data['lng'] = $v['lon']; //经度 $data['deliveryRangeType'] = 3; //范围类型 $data['coordinateType'] = 4; //腾讯地图 $data['deliveryRangeRadius'] = $radius; //服务半径 $data['standByPhone'] = $v['pickup_phone'];//备联电话 //-----------选找城市------------ $pn=getregion($v['province_id']); $pc=getregion($v['city_id']); $city_no=0; foreach ($city as $kk=>$vv){ if($vv['areaName']==$pn || $vv['areaName']==$pc){ $city_no=$vv['areaCode']; break; } } if($city_no==0) { return json(['code' => -1, "msg" => '未找到京东在' . $pc . '地区的业务城市']); } //------------寻找地区------------ $qname=getregion($v['district_id']); $qu_no=0; $qu_list=$this->get_js_addrnext($city_no); if($qu_list){ foreach ($qu_list as $kt=>$vt){ if($vt['areaName']==$qname){ $qu_no=$vt['areaCode']; break; } } if($qu_no==0) { return json(['code' => -1, "msg" => '未找到京东在' . $qname . '地区的业务城市']); } }else{ return json(['code' => -1, "msg" => '未找到京东在' . $pc . '地区的业务城市']); } $data['city'] = $city_no;//城市 $data['county'] =$qu_no; //区 $jj=json_encode($data); $rs = jd_api('/store/createStore', $data, $stoid); $rs_a=json_decode($rs,true); if($rs_a['code']!=0){ mlog($rs_a['msg'], "createStore /" . $stoid); return json(['code'=>-1,"msg"=>"插入失败"]); } $rs_a=$rs_a['data']; $rs_a=json_decode($rs_a,true); if($rs_a['code']!=0){ return json(['code'=>-1,"msg"=>$v['pickup_name'].$rs_a['msg']]); } //---保存门店---- $da['stationNo']=$rs_a['result']; $da['radius']=$radius; $da['store_id']=$stoid; M("jd_sto")->save($da); M("pick_up")->where('pickup_id',$v['pickup_id']) ->where("store_id",$stoid)->save(['is_jd'=>1]); mlog($rs, "createStore/" . $stoid); } return json(['code'=>0,"msg"=>"插入成功"]); } } //获取京东的业务城市 function get_jd_city(){ $rs = jd_api('/address/allcities', null, getAdmStoId()); $rs_a=json_decode($rs,true)['data']; $rs_a=json_decode($rs_a,true); if($rs_a['code']==0){ return $rs_a['result']; } return null; } //获取京东的业务城市 function get_js_addrnext($code){ $data['areaCode']=$code; $data['pin']='test'; $rs = jd_api('/address/getNextLevelByType ', $data, getAdmStoId()); $rs_a=json_decode($rs,true)['data']; $rs_a=json_decode($rs_a,true); if($rs_a['code']==0){ return $rs_a['result']; } return null; } /*------------批量上架下架------------*/ function up_down(){ $osku=I("oskulist"); $ind=I("ind"); $arr=explode(",",$osku); foreach ($arr as $k=>$v){ $data["outSkuId"]=$v; $data["fixedStatus"]=$ind; $rs = jd_api('/pms/sku/updateSku', $data, getAdmStoId()); } return json(["code"=>0,"msg"=>"操作成功"]); } //----------设置前缀和广告--------- function gd_set(){ $type=I("type"); $this->assign('type', $type); $info['start_time'] = date('Y-m-d H:i:s'); $info['end_time'] = date('Y-m-d 23:59:59', time() + 3600 * 24 * 60); $this->assign('info', $info); return $this->fetch("",getAdmStoId()); } /*------------批量商品设置------------*/ function goods_set(){ $osku=I("oskulist"); $type=I("type"); $val=I("val"); $val2=I("val2"); $start=I("start_time"); $end=I("end_time"); $arr=explode(",",$osku); foreach ($arr as $k=>$v){ $data["outSkuId"]=$v; switch ($type){ case "1"://设置前缀 $data["prefixKeyId"]=$val2; $data["prefixKey"]=$val; $data["preKeyStartTime"]=$start; $data["preKeyEndTime"]=$end; break; case "2"://设置广告词 $data["slogan"]=$val; $data["sloganStartTime"]=$start; $data["sloganEndTime"]=$end; break; case "3"://设置店内分类 $data["shopCategories"]=$val; break; case "4"://批量删除 $data["fixedStatus"]=4; break; } $rs = jd_api('/pms/sku/updateSku', $data, getAdmStoId()); mlog($rs, "updateSku/".getAdmStoId()); } return json(["code"=>0,"msg"=>"操作成功"]); } /*------------获取前缀--------------*/ function qz_set(){ $p=I('p',1); $pz=36; $data=['pageNo'=>$p,'pageSize'=>$pz,'fields'=>["ID","KEYVALUE"]]; $keywords=I("keywords"); if($keywords) $data['keyValue']=$keywords; $rs = jd_api('/pms/queryKeyWordDicInfo', $data, getAdmStoId()); $rs=json_decode($rs,true); $rsa=json_decode($rs['data'],true)['result']; $Page = new Page($rsa['count'], $pz); $this->assign('pager',$Page); $show = $Page->show();//分页显示输出 $this->assign('page', $show);//赋值分页输出 $qzList=$rsa['result']; $this->assign('qzList',$qzList); return $this->fetch("",getAdmStoId()); } /*-----批量门店休息中,营业中-----*/ public function close_status(){ $stoid=getAdmStoId(); $stolist=I("stolist"); $status=I("status"); //1营业 2休息 $arr=explode(",",$stolist); foreach ($arr as $k=>$v){ $data["stationNo"]=$v; $data["operator"]= Cookie::get("newshop_admin_erpuser"); $data["closeStatus"]=$status==1?0:1; $rs = jd_api('/store/updateStoreInfo4Open', $data, getAdmStoId()); mlog($rs, "updateSku/".getAdmStoId()); $rs=json_decode($rs,true); if($rs['code']!=0){ return json(["code"=>-1,"msg"=>"操作失败:".$rs['msg']]); } $rs=json_decode($rs['data'],true); if($rs['success']==false){ return json(["code"=>-1,"msg"=>"门店:".$v.":".$rs['msg']]); } } return json(["code"=>0,"msg"=>"操作成功"]); } //------------编辑商品------------- function editgoods(){ $this->initEditor(); $stoid=getAdmStoId(); $erpid=tpCache("shop_info.ERPId",$stoid); $this->assign('erpid',$erpid); $this->assign('qurl',QCLOUD_IMGURL); $oskiid=I('skuId'); $data['skuId']=$oskiid; $rs = jd_api('/pms/querySkuInfos', $data, getAdmStoId()); $rs=json_decode($rs,true); if($rs['code']==0){ $rs= json_decode($rs['data'],true); if($rs['code']==0){ $res=json_decode($rs['result']['result'],true)[0]; //获取城市 $city=F('jd_city'); if(empty($city)){ $city=$this->get_jd_city(); Cache::set("jd_city",$city,3600*4); } $this->assign('city',$city); $cell_city=$res['sellCities']; $str=""; $cidlist=""; if($res['productDescHtml']) { $html = file_get_contents($res['productDescHtml']); $css_zheng_ze = "/([\s\S]*)<\/body>/Ui"; $arr = array(); preg_match_all($css_zheng_ze, $html, $arr); $ht = $arr[0][0]; $ht = str_replace("", "", $ht); $ht = str_replace("", "", $ht); $res['productDescHtml'] = $ht; } foreach($cell_city as $kk=>$vv){ if($vv==0) { $str = "全国"; $cidlist=0;break; } else{ $cidlist.=$vv.","; foreach ($city as $kc=>$vc){ if($vc['areaCode']==$vv){ $str.=$vc['areaName']." "; } } } } $cidlist = substr($cidlist,0,strlen($cidlist)-1); $res['scity']=$str; $res['cidlist']=$cidlist; if($res['shopCategories']){ $sto_cat_list=""; foreach ($res['shopCategories'] as $kl=>$vl){ $sto_cat_list.=$vl.","; } $sto_cat_list = substr($sto_cat_list,0,strlen($sto_cat_list)-1); $res['sto_cat_list']=$sto_cat_list; } $gdetail=M("jd_sku")->where('store_id',$stoid) ->where('outsku',$res['outSkuId'])->find(); if($gdetail) { //$res['images'] = explode(',',$gdetail['images']); $res['firid'] = $gdetail['firid']; $res['secid'] = $gdetail['secid']; $res['ifViewDesc'] = $gdetail['ifViewDesc']; $res['productDesc'] = $gdetail['productDesc']; $da['fields']=["ID","CATEGORY_NAME","CATEGORY_LEVEL","CATEGORY_STATUS"]; $da['id']=$res['firid']; $rs=jd_api('/api/queryChildCategoriesForOP',$da,$stoid); $rs=json_decode($rs,true); if($rs['code']==0) { $data = json_decode($rs['data'], true); $this->assign('sec_list',$data['result']); } $da['fields']=["ID","CATEGORY_NAME","CATEGORY_LEVEL","CATEGORY_STATUS"]; $da['id']=$res['secid']; $rs=jd_api('/api/queryChildCategoriesForOP',$da,$stoid); $rs=json_decode($rs,true); if($rs['code']==0) { $data = json_decode($rs['data'], true); $this->assign('thi_list',$data['result']); } } $gd=M('goods')->where('sku',$res['upcCode']) ->where('store_id',$stoid)->find(); $images=M("goods_images")->where('goods_id',$gd['goods_id'])->where('store_id',$stoid)->select(); $res['images']=$images; $this->assign('info',$res); } } return $this->fetch("",getAdmStoId()); } //------------编辑门店------------- function editsto(){ $stoid=getAdmStoId(); $oskiid=I('StoreNo'); $data['StoreNo']=$oskiid; $rs = jd_api('/storeapi/getStoreInfoByStationNo', $data, getAdmStoId()); $rs=json_decode($rs,true); if($rs['code']==0){ $rs=json_decode($rs['data'],true); $rs=$rs['result']; $quyu=$this->get_js_addrnext($rs['city']); $this->assign('quyu',$quyu); foreach ($quyu as $kl=>$vl){ if($vl['areaCode']==$rs['county']){ $rs['townname']=$vl['areaName']; break; } } if(empty($rs['operator'])) $rs['operator']=$rs['createPin']; $gdetail=M("jd_sto")->where('store_id',$stoid) ->where('stationNo',$oskiid)->find(); if($gdetail) { $rs['gonggao'] = $gdetail['gonggao']; $rs['radius'] = $gdetail['radius']; if(empty($rs['cityName'])) $rs['cityName']=$gdetail['cityname']; } $this->assign('info',$rs); } return $this->fetch("",getAdmStoId()); } //------------商品资料修改保存------------- function goods_handle(){ $stoid=getAdmStoId(); $fir="http://mshopimg.yolipai.net"; $Goods = I('post.'); //商品保存 $res['firid'] = $Goods['jd_cat_id']; $res['secid'] = $Goods['jd_cat_id_2']; //$js=json_encode($Goods); unset($Goods['jd_cat_id']); unset($Goods['jd_cat_id_2']); unset($Goods['iseditimg']); if($Goods['jd_cat_id_3']) $Goods['categoryId']=(int)$Goods['jd_cat_id_3']; unset($Goods['jd_cat_id_3']); unset($Goods['images']); /*---- if($Goods['images']==[""]) unset($Goods['images']); else{ $imglist=""; foreach ($Goods['images'] as $ky=>$vy){ if(trim($vy)!=""){ if(strpos($vy,'http')!==false){ $imglist.=$vy.","; }else{ $imglist.=$fir.$vy.","; } } } $imglist = substr($imglist,0,strlen($imglist)-1); $Goods['images']=$imglist; $res['images'] = $imglist; }----*/ if(empty($Goods['slogan'])) { unset($Goods['slogan']); unset($Goods['sloganEndTime']); unset($Goods['sloganStartTime']); } //------商品描述------ $Goods['ifViewDesc']=$Goods['ifViewDesc']-1; $res['ifViewDesc'] = $Goods['ifViewDesc']; $prodesc=trim($Goods['productDesc']); if(empty($prodesc)) { unset($Goods['productDesc']); }else{ $res['productDesc'] = $Goods['productDesc']; } if($Goods['upcCode']) { $Goods['upc'] = $Goods['upcCode']; unset($Goods['upcCode']); } $Goods['transportAttribute']=($Goods['transportAttribute']-1).''; $Goods['liquidStatue']=$Goods['liquidStatue'].''; $Goods['prescripition']=$Goods['prescripition'].''; $Goods['traceId']=uuid(); //$rs = jd_api('/pms/sku/updateSku', $Goods, getAdmStoId()); $rs = jd_api('/pms/updateSku', $Goods, getAdmStoId()); $rs=json_decode($rs,true); if($rs['code']==0){ //------存入本地------- $sku=M("jd_sku")->where('outsku',$Goods['outSkuId']) ->where('store_id',$stoid)->find(); if($sku){ M("jd_sku")->where('outsku',$Goods['outSkuId']) ->where('store_id',$stoid)->save($res); }else{ $res['store_id'] = $stoid; $res['outsku'] = $Goods['outSkuId']; M("jd_sku")->save($res); } return json(['code'=>0,'msg'=>"修改成功"]); }else{ return json(['code'=>-1,'msg'=>$rs['msg']]); } } //----------门店资料修改保存----------- function sto_handle(){ $stoid=getAdmStoId(); $Goods = I('post.'); $res=null; $res['gonggao']=$Goods['storeNotice']; $res['cityname']=trim($Goods['cityName']); $res['townname']=trim($Goods['townname']); if(empty($Goods['storeNotice'])) { unset($Goods['storeNotice']); }else{ $res['gonggao']=$Goods['storeNotice']; } if(empty($Goods['deliveryRangeRadius'])){ unset($Goods['deliveryRangeRadius']); }else{ $res['radius']=$Goods['deliveryRangeRadius']; } if(empty($Goods['mobile'])) unset($Goods['mobile']); if(empty($Goods['mobile'])) unset($Goods['mobile']); $rs = jd_api('/store/updateStoreInfo4Open', $Goods, getAdmStoId()); $rs=json_decode($rs,true); if($rs['code']==0){ $rs=json_decode($rs['data'],true); if($rs['success']==false){ return json(['code'=>-1,'msg'=>$rs['msg']]); } //------存入本地------- if($res){ $sku=M("jd_sto")->where('stationNo',$Goods['stationNo']) ->where('store_id',$stoid)->find(); if($sku){ M("jd_sto")->where('stationNo',$Goods['stationNo']) ->where('store_id',$stoid)->save($res); }else{ $res['store_id'] = $stoid; $res['stationNo'] = $Goods['stationNo']; M("jd_sto")->save($res); } } return json(['code'=>0,'msg'=>"修改成功"]); }else{ return json(['code'=>-1,'msg'=>$rs['msg']]); } } //------------导出------------ function good_export(){ $id = getAdmStoId(); $p=I("p"); $pagesize=20; $data=["pageSize"=>$pagesize,'pageNo'=>$p,'isFilterDel'=>"0"]; $gname=I("goods_name"); $gsn=I("goods_sn"); $jsku=I("dd_sku"); if($gname) $data['skuName']=$gname; if($gsn) $data['skuId']=$gsn; if($jsku) $data['upcCode']=$jsku; $oldurl = U('Admin/jddj/goods_up', array( "goods_name" => $gname, "goods_sn" => $gsn, "dd_sku" => $jsku, "p" => $p, )); $this->assign('oldurl', urlencode($oldurl)); $rs=jd_api('/pms/querySkuInfos',$data,$id); $rs=json_decode($rs,true); if($rs['code']==0){ $list= json_decode($rs['data'],true); if($list['result']['count']>0){ $city=F('jd_city'); if(empty($city)){ $city=$this->get_jd_city(); Cache::set("jd_city",$city,3600*4); } if($list['result']['result']!=null) { $glist=json_decode($list['result']['result'],true); foreach ($glist as $kl=>$vl){ $str=""; $cell_city=$vl['sellCities']; foreach($cell_city as $kk=>$vv){ if($vv==0) { $str = "全国";break; } else{ foreach ($city as $kc=>$vc){ if($vc['areaCode']==$vv){ $str.=$vc['areaName']." "; } } } } $glist[$kl]['scity']=$str; } $this->assign("goodsList",$glist); } $Page = new AjaxPage($list['result']['count'],$pagesize); $show=$Page->show(); $this->assign('page',$show);// 赋值分页输出 $this->assign('pager',$Page); } } } //---------店内分类列表--------- public function category_list(){ $stoid = getAdmStoId(); $data['fields']=["ID","PID","SHOP_CATEGORY_NAME","SORT",]; $rs=jd_api('/pms/queryCategoriesByOrgCode',$data,$stoid); $rs=json_decode($rs,true); if($rs['code']==0){ $data=json_decode($rs['data'],true); $catelist=$data['result']; $rslist=[]; if($catelist) { foreach ($catelist as $k => $v) { if ($v['pid'] == 0) { $rslist[] = ["id" => $v['id'], "shopCategoryName" => $v["shopCategoryName"], "ary" => null]; } else { foreach ($rslist as $kv => $vv) { if ($vv['id'] == $v['pid']) { $rslist[$kv]['ary'][] = $v; } } } } $this->assign('s_catelist', $rslist); } } return $this->fetch("",getAdmStoId()); } //----------编辑店内分类----------- public function addEditCategory(){ $stoid = getAdmStoId(); $data['fields']=["ID","PID","SHOP_CATEGORY_NAME","SORT",]; $rs=jd_api('/pms/queryCategoriesByOrgCode',$data,$stoid); $rs=json_decode($rs,true); if($rs['code']==0){ $data=json_decode($rs['data'],true); $catelist=$data['result']; $rslist=[]; if($catelist) { foreach ($catelist as $k => $v) { if ($v['pid'] == 0) { $rslist[] = ["id" => $v['id'], "shopCategoryName" => $v["shopCategoryName"]]; } } $this->assign('s_catelist', $rslist); } } return $this->fetch("_category",getAdmStoId()); } //-------分类保存---------- public function category_handle(){ $stoid = getAdmStoId(); $id=I("id"); $pid=I("pid"); $shopCategoryName=I("shopCategoryName"); mlog("1","category_handle/".$stoid); if($id) { mlog("2","category_handle/".$stoid); mlog("2".$id,"category_handle/".$stoid); $data['id'] = $id; $data['shopCategoryName'] = $shopCategoryName; $rs = jd_api('/pms/updateShopCategory', $data, $stoid); $rs = json_decode($rs, true); if ($rs['code'] == 0) { $rs = json_decode($rs['data'], true); if($rs['success']){ return json(['code' => 0, 'msg' => "保存成功"]); } return json(['code' => -1, 'msg' => $rs['msg']]); }else{ return json(['code' => -1, 'msg' => $rs['msg']]); } }else{ mlog("3","category_handle/".$stoid); mlog("3".$pid,"category_handle/".$stoid); $data['pid'] = $pid; $data['shopCategoryName'] = $shopCategoryName; $rs = jd_api('/pms/addShopCategory', $data, $stoid); $rs = json_decode($rs, true); if ($rs['code'] == 0) { $rs = json_decode($rs['data'], true); if($rs['success']){ return json(['code' => 0, 'msg' => "保存成功"]); } return json(['code' => -1, 'msg' => $rs['msg']]); }else{ return json(['code' => -1, 'msg' => '操作失败']); } } } //----------删除分类---------- public function category_del(){ $stoid = getAdmStoId(); $id=I("id"); $data['id'] = $id; $rs = jd_api('/pms/delShopCategory ', $data, $stoid); $rs = json_decode($rs, true); if ($rs['code'] == 0) { $rs = json_decode($rs['data'], true); if($rs['success']){ return json(['code' => 0, 'msg' => "保存成功"]); } return json(['code' => -1, 'msg' => $rs['msg']]); }else{ return json(['code' => -1, 'msg' => '操作失败']); } } //---------门店商品管理---------- function sto_gd_up(){ $stoid=getAdmStoId(); $rs=jd_api('/store/getStationsByVenderId ',null,$stoid); $rs=json_decode($rs,true); $glist=null; if($rs['code']==0){ $list=json_decode($rs['data'],true); $arr=$list['result']; $count=count($arr); for($i=0;$i<1;$i++){ $data1['StoreNo']=$arr[$i]; $rss=jd_api('/storeapi/getStoreInfoByStationNo',$data1,$stoid); $rss=json_decode($rss,true); $md=json_decode($rss['data'],true)['result']; $md['updateTime']=date('Y-m-d H:i:s',$md['updateTime']['time']/1000); $md['createTime']=date('Y-m-d H:i:s',$md['createTime']['time']/1000); $md['serviceTimeStart1']=$this->format_time($md['serviceTimeStart1']); $md['serviceTimeEnd1']=$this->format_time($md['serviceTimeEnd1']); $glist[]=$md; } //$jj=json_encode($glist); $this->assign("stoList",$glist); } return $this->fetch("",getAdmStoId()); } public function ajax_sto_gd_up() { $id = getAdmStoId(); $stationName=I("stationName"); $outStationNo=I("outStationNo"); $stationNo=I("stationNo"); $p=I("p"); $pagesize=20; $data=["pageSize"=>$pagesize,'pageNo'=>$p,'isFilterDel'=>"0"]; $gname=I("goods_name"); $gsn=I("goods_sn"); $jsku=I("dd_sku"); if(trim($gname)) $data['skuName']=trim($gname); if(trim($gsn)) $data['skuId']=trim($gsn); if(trim($jsku)) $data['upcCode']=trim($jsku); $oldurl = U('Admin/jddj/goods_up', array( "goods_name" => $gname, "goods_sn" => $gsn, "dd_sku" => $jsku, "p" => $p, )); $this->assign('oldurl', urlencode($oldurl)); $rs=jd_api('/pms/querySkuInfos',$data,$id); $rs=json_decode($rs,true); if($rs['code']==0){ $list= json_decode($rs['data'],true); if($list['result']['count']>0){ $city=F('jd_city'); if(empty($city)){ $city=$this->get_jd_city(); Cache::set("jd_city",$city,3600*4); } if($list['result']['result']!=null) { $glist=json_decode($list['result']['result'],true); $outskulist=null; foreach ($glist as $kl=>$vl){ $str=""; $cell_city=$vl['sellCities']; foreach($cell_city as $kk=>$vv){ if($vv==0) { $str = "全国";break; } else{ foreach ($city as $kc=>$vc){ if($vc['areaCode']==$vv){ $str.=$vc['areaName']." "; } } } } $glist[$kl]['scity']=$str; $glist[$kl]['outStationNo']=$outStationNo; $glist[$kl]['stationNo']=$stationNo; $glist[$kl]['stationName']=$stationName; $outskulist[]=['outSkuId'=>$vl['outSkuId']]; } $kdata['outStationNo']=$outStationNo; $kdata['skuIds']=$outskulist; $kdata["userPin"]= Cookie::get("newshop_admin_erpuser"); $rss=jd_api('/stock/queryStockCenter',$kdata,$id); $rss=json_decode($rss,true); if($rss['code']==0){ $rss=json_decode($rss['data'],true); if($rss['code']==0){ foreach ($glist as $ky=>$vy){ if($rss['data']) { foreach ($rss['data'] as $kt => $vt) { if ($vy['outSkuId'] == $vt['outSkuId']) { $glist[$ky]['kcun'] = $vt; } } } } } } $this->assign("goodsList",$glist); } $Page = new AjaxPage($list['result']['count'],$pagesize); $show=$Page->show(); $this->assign('page',$show);// 赋值分页输出 $this->assign('pager',$Page); } } return $this->fetch('', getAdmStoId()); } //-----------修改可售状态------------ function UpdateVendibility(){ $id=getAdmStoId(); $stationNo=I("stationNo"); $osku=I("oskulist"); $doSale=I("doSale");//1可售 2不可售 $kdata["userPin"]= Cookie::get("newshop_admin_erpuser"); $kdata["outStationNo"]=$stationNo; $outSkuId_arr=explode(',',$osku); $stockVendibilityList=null; foreach ($outSkuId_arr as $k=>$v){ $stockVendibilityList[]=["outSkuId"=>$v,"doSale"=>$doSale==1]; } $kdata["stockVendibilityList"]=$stockVendibilityList; $rs=jd_api('/stock/batchUpdateVendibility ',$kdata,$id); $rs=json_decode($rs,true); if($rs['code']==0){ $rs=json_decode($rs['data'],true); if($rs['code']==0){ return json(['code'=>0,'msg'=>'修改成功']); } }else{ return json(['code'=>-1,'msg'=>'修改失败']); } } //-----------修改置顶状态------------ function Update_stick(){ $up=I("up"); //1置顶 2取消置顶 $stationNo=I("stationNo"); $osku=I("oskulist"); $rs=null;$stoid=getAdmStoId(); if($up==1){ $kdata["storeId"]=$stationNo; $kdata["skuIds"]=$osku; $rs=jd_api('/OrgSortService/addByStoreAndSkus',$kdata,$stoid); }else{ $kdata["storeId"]=$stationNo; $kdata["skuIds"]=$osku; $rs=jd_api('/OrgSortService/deleteByIdsWithCheck ',$kdata,$stoid); } $rs=json_decode($rs,true); if($rs['code']==0){ $rs=json_decode($rs['data'],true); if($rs['status']==200){ return json(['code'=>0,'msg'=>'修改成功']); } return json(['code'=>-1,'msg'=>'修改失败']); }else{ return json(['code'=>-1,'msg'=>'修改失败']); } } //-----------搜索门店------------ function search_sto(){ $id = getAdmStoId(); $p=I("p",1); $data=null; $rs=jd_api('/store/getStationsByVenderId',$data,$id); $rs=json_decode($rs,true); $pz=15; $glist=null; if($rs['code']==0){ $list=json_decode($rs['data'],true); $arr=$list['result']; $count=count($arr); if($count>0){ $fir=($p-1)*$pz; $end=$p*$pz; if($fir<$count){ if($end>$count) $end=$count; for($i=$fir;$i<$end;$i++){ $data1['StoreNo']=$arr[$i]; $rss=jd_api('/storeapi/getStoreInfoByStationNo',$data1,$id); $rss=json_decode($rss,true); $md=json_decode($rss['data'],true)['result']; $md['updateTime']=date('Y-m-d H:i:s',$md['updateTime']['time']/1000); $md['createTime']=date('Y-m-d H:i:s',$md['createTime']['time']/1000); $md['serviceTimeStart1']=$this->format_time($md['serviceTimeStart1']); $md['serviceTimeEnd1']=$this->format_time($md['serviceTimeEnd1']); $glist[]=$md; } $this->assign('glist',$glist); $Page = new Page(count($list['result']), $pz); $this->assign('pager',$Page); $show = $Page->show();//分页显示输出 $this->assign('page', $show);//赋值分页输出 } } } return $this->fetch('', getAdmStoId()); } //---------修改商品的现货库存,锁定库存--------- function change_kucun(){ $stoid=getAdmStoId(); $type=I("type"); //1修改现货 2.修改锁定 3俩个都修改 $outStationNo=I("outStationNo"); $stationNo=I("stationNo"); $outSkuId=I("outSkuId"); $skuId=I("skuId"); $outSkuId=explode(',',$outSkuId); $skuId=explode(',',$skuId); switch ($type){ case "1": //现货库存 $qty=I("qty");$lt=null; $data["userPin"]= Cookie::get("newshop_admin_erpuser"); $data['outStationNo']=$outStationNo; foreach ($outSkuId as $kh=>$vh){ $lt[]=['outSkuId'=>$vh,'stockQty'=>(int)$qty]; } $data['skuStockList']=$lt; $rs=jd_api('/stock/batchUpdateCurrentQtys',$data,$stoid); $rs=json_decode($rs,true); $rs=json_decode($rs['data'],true); $rs=$rs['data']; if($rs[0]['code']==0){ return json(['code'=>0,'msg'=>'修改成功']); } return json(['code'=>-1,'msg'=>'修改失败']); break; case "2": //锁定库存 $qty=I("qty");$lt=null; foreach ($skuId as $kh=>$vh){ $lt[]=['skuId'=>$vh,'stockQty'=>$qty,'stationNo'=>$stationNo]; } $data['listBaseStockCenterRequest']=$lt; $rs=jd_api('/stock/updateOpenLockQtys ',$data,$stoid); $rs=json_decode($rs,true); if($rs['code']=="0"){ return json(['code'=>0,'msg'=>'修改成功']); } return json(['code'=>-1,'msg'=>'修改失败']); break; case "3": $qty1=I("qty1");$lt=null; $data["userPin"]= Cookie::get("newshop_admin_erpuser"); $data['stationNo']=$stationNo; foreach ($outSkuId as $kh=>$vh){ $lt[]=['outSkuId'=>$vh,'stockQty'=>$qty1]; } $data['skuStockList']=$lt; $rs=jd_api('/stock/batchUpdateCurrentQtys',$data,$stoid); $rs=json_decode($rs,true); $rs=json_decode($rs['data'],true); $rs=$rs['data']; if($rs[0]['code']!=0){ return json(['code'=>-1,'msg'=>'修改现货库存失败']); } $qty2=I("qty2");$lt=null; foreach ($skuId as $kh=>$vh){ $lt[]=['skuId'=>$vh,'stockQty'=>$qty2,'stationNo'=>$stationNo]; } $data['listBaseStockCenterRequest']=$lt; $rs=jd_api('/stock/updateOpenLockQtys ',$data,$stoid); $rs=json_decode($rs,true); if($rs['code']!="0"){ return json(['code'=>-1,'msg'=>'修改锁定失败']); } return json(['code'=>0,'msg'=>'修改成功']); break; } } //-----导出商品------- function export_goods(){ $glist=F("ajax_cgoodsList_".getAdmStoId()); $strTable = ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; if ($glist) { foreach ($glist as $k=>$val) { $upstr = ""; if ($val['fixedStatus'] == 1) $upstr = "上架"; if ($val['fixedStatus'] == 2) $upstr = "下架"; if ($val['fixedStatus'] == 4) $upstr = "删除"; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ""; } } $strTable .= '
商品信息sku编码商品编码商家商品编码/条码销售城市商家价格商品状态
 ' . $val['skuName'] . ' ' . $val['skuId'] . '  ' . $val['skuId'] . ' ' . $val['outSkuId'] . '
 ' . $val['upcCode'] . '
 ' . $val['scity'] . ' ' . $val['skuPrice']/100 . ' ' . $upstr . '
'; echo $strTable; unset($orderList); downloadExcel($strTable, 'goods'); exit(); } //-----导出商品------- function export_sto(){ $id=getAdmStoId(); $data=null; $rs=jd_api('/store/getStationsByVenderId ',$data,$id); $rs=json_decode($rs,true); $glist=null; if($rs['code']==0){ $list=json_decode($rs['data'],true); $arr=$list['result']; $count=count($arr); if($count>0){ for($i=0;$i<$count;$i++){ $data1['StoreNo']=$arr[$i]; $rss=jd_api('/storeapi/getStoreInfoByStationNo',$data1,$id); $rss=json_decode($rss,true); $md=json_decode($rss['data'],true)['result']; $md['updateTime']=date('Y-m-d H:i:s',$md['updateTime']['time']/1000); $md['createTime']=date('Y-m-d H:i:s',$md['createTime']['time']/1000); $md['serviceTimeStart1']=$this->format_time($md['serviceTimeStart1']); $md['serviceTimeEnd1']=$this->format_time($md['serviceTimeEnd1']); $glist[]=$md; } } } $strTable = ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; if ($glist) { foreach ($glist as $k=>$val) { $upstr = ""; if ($val['closeStatus'] == 0) $upstr = "正常营业"; if ($val['closeStatus'] == 1) $upstr = "休息中"; $yn=""; if ($val['yn'] == 0) $yn = "启用"; if ($val['yn'] == 1) $yn = "禁用"; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ""; } } $strTable .= '
门店编号门店名称商家门店编号所在城市所在区县营业时间联系方式备联电话创建时间更新时间最后一次操作人营业状态启用状态
 ' . $val['stationNo'] . ' ' . $val['stationName'] . '  ' . $val['outSystemId'] . ' ' . $val['cityName'] . ' ' . $val['countyName'] . ' ' . $val['serviceTimeStart1'] . '-'.$val['serviceTimeEnd1'].' ' . $val['phone'] . '/'.$val['mobile'].' ' . $val['standByPhone'] . '  ' . $val['createTime'] . '  ' . $val['updateTime'] . '  ' . $val['updatePin'] . '  ' . $upstr . '  ' . $yn . '
'; echo $strTable; unset($orderList); downloadExcel($strTable, 'storage'); exit(); } function getregion(){ $id=I("id"); $rg=M("region")->where("parent_id",$id)->select(); return json(['code'=>"0",'data'=>$rg]); } //-----获取到缴费界面----- public function not_jd(){ //先判断缴费记录是否有该商家的记录 $rss=M('store_module_endtime')->where('store_id='.getAdmStoId())->where('is_sy',0) ->where('type',4)->find(); if($rss){ $this->assign('is_jd_open', 1); $end_time=strtotime('+1 year',$rss['end_time']); $end_time=date("Y-m-d H:i:s",$end_time); $this->assign('end_time', $end_time); }else{ $end_time=strtotime('+1 year',time()); $end_time=date("Y-m-d H:i:s",$end_time); $this->assign('end_time', $end_time); } return $this->fetch('', getAdmStoId()); } /** * 初始化编辑器链接 * 本编辑器参考 地址 http://fex.baidu.com/ueditor/ */ private function initEditor() { $this->assign("URL_upload", U('admin/Ueditor/imageUp', array('savepath' => 'goods', 'savepath1' => getERPId()))); // 图片上传目录 $this->assign("URL_imageUp", U('admin/Ueditor/imageUp', array('savepath' => 'goods', 'savepath1' => getERPId()))); // 不知道啥图片 $this->assign("URL_fileUp", U('admin/Ueditor/fileUp', array('savepath' => 'goods', 'savepath1' => getERPId()))); // 文件上传s $this->assign("URL_scrawlUp", U('admin/Ueditor/scrawlUp', array('savepath' => 'goods', 'savepath1' => getERPId()))); // 图片流 $this->assign("URL_getRemoteImage", U('admin/Ueditor/getRemoteImage', array('savepath' => 'goods', 'savepath1' => getERPId()))); // 远程图片管理 $this->assign("URL_imageManager", U('admin/Ueditor/imageManager', array('savepath' => 'goods', 'savepath1' => getERPId()))); // 图片管理 $this->assign("URL_getMovie", U('admin/Ueditor/getMovie', array('savepath' => 'goods', 'savepath1' => getERPId()))); // 视频上传 $this->assign("URL_Home", ""); } /*** * 商品图片同步处理 */ public function goods_handle_images(){ $gd_sn=I("goods_sn"); $stoid=getAdmStoId(); $gd = M("goods")->where("goods_sn",$gd_sn) ->where('store_id',$stoid) ->field("original_img,goods_id") ->find(); $imglist= M("goods_images")->where("goods_id",$gd['goods_id']) ->where('store_id',$stoid)->where('ismain',0) ->field('image_url') ->select(); $imghost="https://mshopimg.yolipai.net"; //腾讯云图片地址 $upfilepath = ROOT_PATH . "public/upload/jddj/".$stoid."/"; //磁盘地址 if (!is_dir($upfilepath)) mkdir($upfilepath,0777,true); $path="/public/upload/jddj/".$stoid."/"; //目录 //$Host=curHostURL(); //本机地址 $Host = "http://mshop-api.yolipai.net/"; //本机地址 $filename=uniqid()."0.jpg"; $img = file_get_contents($imghost.$gd['original_img']); file_put_contents($upfilepath.$filename,$img); //强制格式800*800 m_format_img($upfilepath.$filename,800); $fialename_arr[]=$Host.$path.$filename; $file_path[]=$upfilepath.$filename; $int=1; foreach ($imglist as $ky=>$vy){ $img = file_get_contents($imghost.$vy['image_url']); $filename=uniqid().$int.".jpg"; file_put_contents($upfilepath.$filename,$img); //强制格式800*800 m_format_img($upfilepath.$filename,800); $fialename_arr[]=$Host.$path.$filename; $file_path[]=$upfilepath.$filename; $int++; } $Goods['outSkuId']=$gd_sn; $Goods['images']=implode(",",$fialename_arr); mlog("tu:".json_encode($fialename_arr),"goods_handle_images/".$stoid); $rs = jd_api('/pms/sku/updateSku', $Goods, getAdmStoId()); mlog("jieguo:".$rs,"goods_handle_images/".$stoid); $rs=json_decode($rs,true); if($rs['code']==0){ return json(['code'=>0,'msg'=>'同步成功,请等5分钟查看图片']); }else{ return json(['code'=>-1,'msg'=>'保存失败']); } } }