php 实现店铺装修8
- /**
- * @title 店铺装修--根据分类获取商品列表
- * @param source 是 int 来源(1--h5、2--app)
- * @param type 是 string 店铺类型--首页进去(other)、我的蜂店进去(me)
- * @param store_id 是 string 店铺id
- * @param type_id 是 int 分类类型(0-全部、1-平台、2-特色)
- * @param sort 否 int 排序字段(1销量由高到低、2价格由低到高、3价格由高到低)--不传默认1
- * @param keywords 否 string 搜索字段(商品名称)
- * @param cate_type 是 string 商品所属分类id--格式:13,20,24,16
- * @param brand_id 否 string 品牌id--格式:3,4,5,6
- * @param page 否 int 页码(不传默认1)
- * @param pagesize 否 int 每页显示条数(不传默认10)
- * @example FlagShipShopDecorate.getGoodsListByCate? 调用参数说明:{"method":"FlagShipShopDecorate.getGoodsListByCate","username":"17721355485","check_code":"123456","type_id":"0","sort":"1","keywords":"","cate_type":"1","brand_id":"","page":"1","pagesize":"10","store_id":"115075399495199"}
- * @return_param_explain 分类入口搜索返回字段说明: select_status:选中状态(1是、2否) img:宫格图片 seascapes:海景图 sell_nums:已卖数量 sku_id:商品属性id sku_no:商品属性编号 title:商品标题 sell_price:零售价 store_id:店铺id is_zero_goods:是否为0元购(1:0元购,0:不是0元购) restriction:限购数量 yuding:是否可预定 market_price:市场价 cost_price:成本价 profit:利润 spec_name:规格名称 activity_info--- activityId:活动编码 activityType:活动类型 productPrice:活动售价 costPrice:成本价 title:活动标题 isAct:是否是活动(true:是、false:不是) >>>foot: current_page:当前页 pagesize:每页显示条数 total_page:总页数 >>>cate_info: id:分类id name:分类名称 list_status:1选中、2未选中 >>>brand_info: id:品牌id brand_name:品牌名称 list_status:1选中、2未选中
- * @method POST
- * @author 邹柯
- */
- public function getGoodsListByCate($res){
- $userId=session(\'user.user_id\');
- //商品类型
- $type_id=$res[\'type_id\'];
- if(empty($type_id)){
- $type_id=0;
- }
- if($type_id !=0 && $type_id !=1 && $type_id !=2){
- E(\'700416\');
- }
- $store_id=$res[\'store_id\'];
- //品牌id
- $brand_id=$res[\'brand_id\'];
- //搜索--宝贝名称
- $keywords=$res[\'keywords\'];
- //排序字段(1销量由高到低、2价格由低到高、3价格由高到低)
- $sort=$res[\'sort\'];
- if(empty($sort)){
- $sort=1;
- }
- if(!empty($sort)){
- if($sort !=1 && $sort !=2 && $sort !=3){
- E(\'700410\');
- }
- }
- //商品所属分类
- $cate_type=$res[\'cate_type\'];
- if(empty($cate_type)){
- $cate_type=0;
- }
- //页码
- $page = $res[\'page\'];
- if(empty($page)){
- $page=1;
- }
- //每页显示条数
- $pageSize = $res[\'pagesize\'];
- if(empty($pageSize)){
- $pageSize=10;
- }
- $proStoreGoods = new FlagShopCategoryModel();
- $list=$proStoreGoods->getGoodsListByCate($userId,$sort,$cate_type,$brand_id,$page,$pageSize,$keywords,$type_id,$store_id);
- return $list;
- }
返回结果
- {
- "status":"0",
- "errorCode":"0",
- "msg":"成功",
- "result":{
- "goods_info":[
- {
- "product_id":"P000873",
- "brand_id":"3",
- "search_name":null,
- "seascapes":[
- ],
- "img":"",
- "sell_nums":"1",
- "title":"【0元购返399元】斐讯K2 1200M智能双频无线路由器 WIFI穿墙 PSG1218",
- "sku_id":"8032715893",
- "soft_text":null,
- "is_zero_goods":"0",
- "restriction":null,
- "yuding":"1",
- "sku_no":"P0028792",
- "market_price":null,
- "sell_price":"0.01",
- "cost_price":"0.01",
- "product_num":"1",
- "profit":"0.00",
- "spec_name":": : ",
- "store_id":"115075399495199",
- "activity_info":{
- "productPrice":"00.00",
- "costPrice":"00.00",
- "activityId":null,
- "activityType":null,
- "title":null,
- "isAct":false
- },
- "select_status":2
- }
- ],
- "foot":{
- "current_page":"1",
- "pagesize":"10",
- "total_page":1
- },
- "brand_info":[
- {
- "id":"3",
- "brand_name":"斐讯",
- "list_status":1
- },
- {
- "id":"6",
- "brand_name":"迅捷",
- "list_status":2
- }
- ],
- "cate_info":[
- {
- "id":"109",
- "name":"斐讯K3C+E1组合套装",
- "list_status":2
- },
- {
- "id":"108",
- "name":"斐讯N1预售",
- "list_status":2
- }
- ]
- }
- }
- //根据分类获取商品列表
- public function getGoodsListByCate($userId,$sort,$cate_type,$brand_id,$page,$pageSize,$keywords,$type_id,$store_id){
- $store=M(\'store\');
- $s_where[\'id\']=$store_id;
- $store_user_id=$store->field(\'id\')->where($s_where)->getField(\'user_id\');
- //排序
- switch ($sort) {
- case 1:
- //销量由高到低排序
- $order = \'sell_nums desc\';
- break;
- case 2:
- //价格从低到高
- $order = \'sell_price asc\';
- break;
- default:
- //价格从高到低
- $order = \'sell_price desc\';
- break;
- }
- $origin=1; //1搜索、2店铺首页或商品管理
- $res2=$this->getGoodsInfoNew($keywords,$cate_type,$page,$pageSize,$order,$brand_id,$store_id,\'me\',2,$origin,$type_id,$userId,$store_user_id);
- if(empty($res2[\'goods_info\'])){
- $res2=null;
- }
- foreach($res2[\'goods_info\'] as $k=>$v){
- $arrs[]=array(
- \'productId\'=>$v[\'product_id\'],
- \'skuNo\'=>$v[\'sku_no\']
- );
- }
- $home_special_session=new HomeSpecialSessionModel();
- $res_info=$home_special_session->getGoodsActInfo($arrs);
- foreach($res_info as $k=>$v){
- unset($res_info[$k][\'productId\']);
- unset($res_info[$k][\'skuNo\']);
- unset($res_info[$k][\'status\']);
- }
- foreach($res2[\'goods_info\'] as $k=>$v){
- $res2[\'goods_info\'][$k][\'activity_info\']=$res_info[$v[\'sku_no\']];
- }
- $search_info= $res2;
- $ob=new FlagShipShopDecorateModel();
- $sku_ids=array_column($res2[\'goods_info\'],\'sku_id\');
- $tt=$ob->getSelectStatus($userId,$type_id);
- foreach($sku_ids as $k=>$v){
- if(in_array($v,$tt)){
- $atr=1;
- }else{
- $atr=2;
- }
- $search_info[\'goods_info\'][$k][\'select_status\']=$atr;
- }
- return $search_info;
- }
- //组装商品信息--新(修改商品列表sku显示为商品显示)
- private function getGoodsInfoNew($keywords,$cate_type,$page,$pageSize,$order,$brand_id,$store_id,$store_type,$source,$origin,$type_id,$user_id,$store_user_id){
- $img_base=C(\'img_base\');
- //获取平台商品的ID
- $pingtai_goods=C(\'pingtai_goods\');
- //获取特色商品的ID
- $tese_goods=C(\'tese_goods\');
- $store_goods=M(\'store_goods sg\');
- $ob=new FlagShipShopDecorateModel();
- $res=$ob->isParentUserId($user_id,$store_user_id);
- if($type_id==1){ //平台商品
- $where2 ="gs.goods_type=$pingtai_goods";
- }elseif($type_id==2){//特色商品
- $where2 ="gs.goods_type=$tese_goods";
- }else{
- $where2 ="1=1";
- if($res===false){
- $where2 .=" and goods_type=2";
- }
- }
- if(!empty($keywords)){
- $where2 .=" and (gs.title like \'%$keywords%\' or gd.search_name like \'%$keywords%\')";
- }
- $where3=$where2;
- //品牌
- if(!empty($brand_id)){
- $where2 .=" and gd.brand_id in ($brand_id)";
- }
- if(!empty($cate_type)){
- $where ="sgc.id in ($cate_type)";
- }else{
- $where ="1=1";
- }
- if($type_id==1){ //平台商品
- $where .=" and type_id=$pingtai_goods";
- }elseif($type_id==2){ //特色商品
- $where .=" and sg.store_id=\'".$store_id."\' and type_id=$tese_goods";
- }else{
- if($res===false){
- $where .=" and (sg.store_id=\'".$store_id."\' and type_id=$tese_goods)";
- }else{
- $where .=" and ((sg.store_id=\'".$store_id."\' and type_id=$tese_goods) or type_id=$pingtai_goods)";
- }
- }
- $where .=" and sg.is_deleted=1 and sg.is_open=1 ";
- $store_goods_info=$store_goods->field(\'sg.sku_id,sg.g_cats,sgc.id\')
- ->join(\'left join lc_store_goods_category sgc on sg.g_cats=sgc.path\')
- ->where($where)
- ->select();
- $sku_ids =implode(",",array_column($store_goods_info,\'sku_id\'));
- $goods_sku_m = M(\'goods_sku gs\');
- if(!empty($store_goods_info)){
- //根据sku_id查找对应的商品
- $sku_ids = "\'".str_replace(",","\',\'",$sku_ids)."\'";
- $where2 .=\' and gs.sku_id in (\'.$sku_ids.\') and gs.status=1 and gs.is_deleted=0 and gd.is_deleted =0 and gd.is_online =1 and gs.is_show=0\';
- $where4=$where3;
- $where4 .=\' and gs.status=1 and gs.is_deleted=0 and gd.is_deleted =0 and gd.is_online =1 and gs.is_show=0\';
- $gd_info = $goods_sku_m
- ->join(\'left join __GOODS__ gd on gd.product_id=gs.product_id\')
- ->field("gd.brand_id,gs.sku_id")
- ->where($where4)
- ->select();
- //选中品牌,品牌分类不变
- $where3 .=\' and gs.sku_id in (\'.$sku_ids.\') and gs.status=1 and gs.is_deleted=0 and gd.is_deleted =0 and gd.is_online =1 and gs.is_show=0\';
- $gd_info2 = $goods_sku_m
- ->join(\'left join __GOODS__ gd on gd.product_id=gs.product_id\')
- ->field("gd.brand_id,gs.sku_id")
- ->where($where3)
- ->select();
- if(!empty($gd_info2)){
- $brand_ids2=array_unique(array_column($gd_info2,\'brand_id\'));
- }else{
- $brand_ids2=null;
- }
- if(!empty($brand_ids2)){
- $brands=implode(\',\',$brand_ids2);
- }else{
- $brands=null;
- }
- $brand_info=$this->getBrandInfo($brands,$brand_id);
- if(!empty($gd_info2)){
- $sku_ids2 =implode(",",array_unique(array_column($gd_info,\'sku_id\')));
- $sku_ids2 = "\'".str_replace(",","\',\'",$sku_ids2)."\'";
- $where5 ="sg.sku_id in ($sku_ids2) and concat(sg.g_cats,\'/\') like \'".$pingtai_goods."/%\' and sg.is_deleted=1 and sg.is_open=1";
- $store_goods_info5=$store_goods->field(\'sgc.id,sg.g_cats\')
- ->join(\'left join lc_store_goods_category sgc on sg.g_cats=sgc.path\')
- ->where($where5)
- ->select();
- $cate_infos=array_unique(array_column($store_goods_info5,\'id\'));
- if(!empty($cate_infos)){
- foreach($cate_infos as $k=>$v){
- if(empty($v)){
- unset($cate_infos[$k]);
- }
- }
- $cate_infos=array_merge($cate_infos);
- }else{
- $cate_infos=null;
- }
- if(!empty($cate_infos)){
- $cate_infos=implode(\',\',$cate_infos);
- $cate_info=$this->getCateInfo($cate_type,$cate_infos);
- }
- }else{
- $cate_info=null;
- }
- $count=$goods_sku_m->join(\'left join __GOODS__ gd on gd.product_id=gs.product_id\')->where($where2)->count(\'DISTINCT gs.product_id\');
- //组装分页信息
- $total_page=ceil($count/$pageSize);
- if($page > $total_page){
- $page=1;
- }
- $goods_info = $goods_sku_m
- ->join(\'left join __GOODS__ gd on gd.product_id=gs.product_id\')
- ->field("gd.product_id,gd.brand_id,gd.search_name,gd.seascapes,gs.img,sum(gs.sell_nums) as sell_nums,gs.title")
- ->where($where2)
- ->group(\'gs.product_id\')
- ->order($order)
- ->page($page,$pageSize)
- ->select();
- $product_ids=implode(",",array_unique(array_column($goods_info,\'product_id\')));
- $product_ids = "\'".str_replace(",","\',\'",$product_ids)."\'";
- $sku_where="product_id in ($product_ids) and gs.status=1 and gs.is_deleted=0 and gs.is_show=0";
- $sku_info = $goods_sku_m
- ->field("gs.product_id,gs.properties,gs.sku_id,gs.soft_text,gs.is_zero_goods,gs.restriction,gs.yuding,gs.img,gs.sku_no,gs.market_price,gs.sell_price,gs.cost_price")
- ->where($sku_where)
- ->order(\'sell_price asc,gs.sell_nums desc\')
- ->select();
- $sku_info=$this->remove_duplicate($sku_info);
- foreach($sku_info as $k=>$v){
- $sku[$v[\'product_id\']][\'properties\']=$v[\'properties\'];
- $sku[$v[\'product_id\']][\'sku_id\']=$v[\'sku_id\'];
- $sku[$v[\'product_id\']][\'soft_text\']=$v[\'soft_text\'];
- $sku[$v[\'product_id\']][\'is_zero_goods\']=$v[\'is_zero_goods\'];
- $sku[$v[\'product_id\']][\'restriction\']=$v[\'restriction\'];
- $sku[$v[\'product_id\']][\'yuding\']=$v[\'yuding\'];
- $sku[$v[\'product_id\']][\'img\']=$v[\'img\'];
- $sku[$v[\'product_id\']][\'sku_no\']=$v[\'sku_no\'];
- $sku[$v[\'product_id\']][\'market_price\']=$v[\'market_price\'];
- $sku[$v[\'product_id\']][\'sell_price\']=$v[\'sell_price\'];
- $sku[$v[\'product_id\']][\'cost_price\']=$v[\'cost_price\'];
- }
- foreach($goods_info as $k=>$v){
- $goods_info[$k][\'properties\']= $sku[$v[\'product_id\']][\'properties\'];
- $goods_info[$k][\'sku_id\']= $sku[$v[\'product_id\']][\'sku_id\'];
- $goods_info[$k][\'soft_text\']= $sku[$v[\'product_id\']][\'soft_text\'];
- $goods_info[$k][\'is_zero_goods\']= $sku[$v[\'product_id\']][\'is_zero_goods\'];
- $goods_info[$k][\'restriction\']= $sku[$v[\'product_id\']][\'restriction\'];
- $goods_info[$k][\'yuding\']= $sku[$v[\'product_id\']][\'yuding\'];
- $goods_info[$k][\'img\']= $sku[$v[\'product_id\']][\'img\'];
- $goods_info[$k][\'sku_no\']= $sku[$v[\'product_id\']][\'sku_no\'];
- $goods_info[$k][\'market_price\']= $sku[$v[\'product_id\']][\'market_price\'];
- $goods_info[$k][\'sell_price\']= $sku[$v[\'product_id\']][\'sell_price\'];
- $goods_info[$k][\'cost_price\']= $sku[$v[\'product_id\']][\'cost_price\'];
- }
- $public = new PublicModel();
- //查询商品是否有多个sku
- if(empty($goods_info)){
- foreach ($goods_info as $key=>$value){
- $goods_info[$key][\'product_num\']=\'\';
- }
- }else{
- $product_info=$public->isMoreSku(array_column($goods_info,\'product_id\'));
- $new_data=[];
- foreach ($product_info as $key=>$value){
- $new_data[$value[\'product_id\']]=$value[\'num\'];
- }
- foreach ($goods_info as $key=>$value){
- $goods_info[$key][\'product_num\']=empty($new_data[$value[\'product_id\']])?\'\':$new_data[$value[\'product_id\']];
- }
- }
- if(!empty($goods_info)){
- foreach ($goods_info as $k =>$v) {
- //利润:
- $profit=$v[\'sell_price\']-$v[\'cost_price\'];
- $goods_info[$k][\'profit\']=$profit?number_format($profit, 2, \'.\', \',\'):\'0.00\';
- $seascapes=explode(\',\',$v[\'seascapes\']);
- if(!empty($seascapes)){
- $seascapes_t= array();
- foreach($seascapes as $v1){
- if(!empty($v1)){
- $seascapes_t[]=$img_base.$v1;
- }
- }
- }
- $goods_info[$k][\'seascapes\']=$seascapes_t;
- $goods_info[$k][\'img\']=empty($v[\'img\'])?\'\':$img_base.$v[\'img\'];
- //单个产品相关的规格
- $spec = $public->getSkuPropName(\'\',$v[\'properties\']);
- $goods_info[$k][\'spec_name\'] = $spec;
- //app
- if($source==2){
- $inf2=$public->shopDeal($store_id);
- }else{ //h5
- $inf2=$public->shopDealH5($store_id,$store_type);
- }
- $inf=$public->getTeSeGoods($v[\'sku_id\']);
- if(empty($inf)){//平台商品
- $store_id=$inf2;
- }else{
- $store_id=$inf[\'store_id\'];
- }
- $goods_info[$k][\'store_id\']=$store_id;
- unset($goods_info[$k][\'properties\']);
- }
- }
- }else{
- $goods_info=null;
- if($origin==1){
- $brand_info=null;
- $cate_info=null;
- }
- }
- $foot=array(\'current_page\'=>$page,\'pagesize\'=>$pageSize,\'total_page\'=>$total_page);
- $data[\'goods_info\']=$goods_info;
- $data[\'foot\']=$foot;
- if($origin==1){
- //组装品牌信息
- $data[\'brand_info\']=$brand_info;
- //组装分类信息
- $data[\'cate_info\']=$cate_info;
- }
- return $data;
- }
- //二维数组去重
- public function remove_duplicate($array){
- $result=array();
- foreach ($array as $key => $value) {
- $has = false;
- foreach($result as $val){
- if($val[\'product_id\']==$value[\'product_id\']){
- $has = true;
- break;
- }
- }
- if(!$has)
- $result[]=$value;
- }
- return $result;
- }
- //获取品牌列表
- //$brand_ids为搜索后产品所对应的品牌 $brand_id为选中的品牌列表
- public function getBrandInfo($brand_ids,$brand_id){
- if(!empty($brand_ids)){
- $where="id in ($brand_ids)";
- }else{
- $where="1=1";
- }
- $brand_info=M(\'brand\')->field(\'id,brand_name\')->where($where)->select();
- foreach($brand_info as $k=>$v){
- if(empty($brand_id)){
- $brand_info[$k][\'list_status\']=2; //未选中
- }else{
- if(in_array($v[\'id\'],explode(\',\',$brand_id))){
- $brand_info[$k][\'list_status\']=1; //选中
- }else{
- $brand_info[$k][\'list_status\']=2; //未选中
- }
- }
- }
- return $brand_info;
- }
- //获取分类列表
- //$cate_type选中的分类 $cate_infos搜索出的分类
- public function getCateInfo($cate_type,$cate_infos){
- //获取平台商品的id
- $pingtai_goods=C(\'pingtai_goods\');
- $where ="id in ($cate_infos)";
- $cate_info=M(\'store_goods_category\')->field(\'id,name,path\')->where($where)->order(\'sort desc\')->select();
- if(!empty($cate_info)){
- foreach($cate_info as $k=>$v){
- if(empty($cate_type)){
- $cate_info[$k][\'list_status\']=2; //未选中
- }else{
- if(in_array($v[\'id\'],explode(\',\',$cate_type))){
- $cate_info[$k][\'list_status\']=1; //选中
- }else{
- $cate_info[$k][\'list_status\']=2; //未选中
- }
- }
- unset($cate_info[$k][\'path\']);
- }
- $cate_info=array_merge($cate_info);
- }else{
- $cate_info=null;
- }
- return $cate_info;
- }
- //根据sku_ids获取分类选中状态
- public function getSelectStatus($userId,$type_id){
- $user_shop_decorate=M(\'user_shop_decorate\');
- $usd_where[\'flagship_shop\']=1;
- $usd_where[\'create_id\']=$userId;
- if($type_id==1){
- $usd_info=$user_shop_decorate->field(\'plate_id,plate_content_draft\')->where($usd_where)->order(\'create_time desc\')->find();
- }else{
- $usd_info=$user_shop_decorate->field(\'plate_id_features plate_id,plate_content_draft_features plate_content_draft\')->where($usd_where)->order(\'create_time desc\')->find();
- }
- $shop_decorate_template=M(\'shop_decorate_template\');
- $us_where[\'is_deleted\']=0;
- $us_where[\'id\']=$usd_info[\'plate_id\'];
- $us_info=$shop_decorate_template->field(\'goods_nums\')->where($usd_where)->find();
- if(empty($usd_info)){
- $goods_info=$this->getDefaultGoodsInfo($us_info[\'goods_nums\'],"sell_nums desc");
- foreach($goods_info as $k=>$v){
- $arr[]=$v[\'sku_id\'];
- }
- }else{
- $plate_content=json_decode($usd_info[\'plate_content_draft\'],true);
- foreach($plate_content as $k=>$v){
- foreach($v[\'goods\'] as $k2=>$v2){
- if($v2[\'operate_type\']==1){
- $arr[]=$v2[\'sku_id\'];
- }
- }
- }
- }
- return $arr;
- }