egg(74)--egg之商品的图库关联颜色表，以及图库的curd

修改图片颜色

model

app/model/goods_image.js

module.exports = app => {
    const mongoose = app.mongoose;
    const Schema = mongoose.Schema;

    var d=new Date();   
    const GoodsImageSchema = new Schema({
      goods_id: {type:Schema.Types.ObjectId },  
      img_url: { type: String  },    
      color_id:{
        type:Schema.Types.Mixed,  //混合类型
        default: ''
      },
      status: { type: Number,default:1  },
      add_time: {           
        type:Number,        
        default: d.getTime()    
      }
     
    });
   
    return mongoose.model('GoodsImage', GoodsImageSchema,'goods_image');
}

app/model/goods_color.js

module.exports = app => {
    const mongoose = app.mongoose;
    const Schema = mongoose.Schema;

    const GoodsColorSchema = new Schema({
      color_name:{ type:String },
      color_value: { type: String  },
      status: { type: Number,default:1  },    
    }); 
    return mongoose.model('GoodsColor', GoodsColorSchema,'goods_color');
  }

router.js

      router.post('/admin/goods/changeGoodsImageColor', controller.admin.goods.changeGoodsImageColor);
      router.post('/admin/goods/goodsImageRemove', controller.admin.goods.goodsImageRemove);

controller

app/controller/admin/goods.js

      async changeGoodsImageColor() {

        var color_id=this.ctx.request.body.color_id;

        var goods_image_id=this.ctx.request.body.goods_image_id;
        console.log(this.ctx.request.body);
        if(color_id){
            color_id=this.app.mongoose.Types.ObjectId(color_id);
        }        

       var result= await this.ctx.model.GoodsImage.updateOne({"_id":goods_image_id},{
          color_id:color_id
        })
        if(result){
        
              this.ctx.body={'success': true,'message':'更新数据成功'};
        }else{

          this.ctx.body={'success': false,'message':'更新数据失败'};
        }
        
    }

view

app/view/admin/goods/edit.html

                        <div role="tabpanel" class="tab-pane" id="photo">


                                <div id="goods_image">    
                                        <ul id="goods_image_list" class="goods_image_list clear">
   
                                               <%for(var i=0;i<goodsImage.length;i++){%>
                                                   <li>
                                                       <img class="pic" src="<%=goodsImage[i].img_url%>" />
   
                                                       <div class="color_list">
   
                                                           <select class="relation_goods_color" goods_image_id="<%=goodsImage[i]._id%>">
                                                               <option value="0">关联颜色</option>

                                                               <%for(var j=0;j<goodsColor.length;j++){%>
   
                                                                    <option value="<%=goodsColor[j]._id%>" <%if(goodsImage[i].color_id.toString()==goodsColor[j]._id){%>selected<%}%>  ><%=goodsColor[j].color_name%></option>
                                                               <%}%>
                                                           </select>                                                        
                                                       </div>

                                                       <div class="goods_image_delete" goods_image_id="<%=goodsImage[i]._id%>"></div>
                                                   </li>
                                               <%}%>
                                        </ul>
                              </div>

                                <div id="photoLib"  class="photoLib"></div>


                                <div id="photoList">


                                </div>
                        </div>

                   $('.relation_goods_color').change(function(){

                     
                       var color_id=$(this).val();
                       var goods_image_id=$(this).attr('goods_image_id');

                       console.log(color_id,goods_image_id);

                        $.post('/admin/goods/changeGoodsImageColor?_csrf=<%=csrf%>',{color_id:color_id,goods_image_id:goods_image_id},function(response){

                                console.log(response);
                        })

                   })

效果

图库的curd

controller

app/controller/admin/goods.js

     async goodsImageRemove() {
        
      var goods_image_id=this.ctx.request.body.goods_image_id;

      //注意  图片要不要删掉   fs模块删除以前当前数据对应的图片
      
      var result= await this.ctx.model.GoodsImage.deleteOne({"_id":goods_image_id});            //注意写法

      if(result){
        
              this.ctx.body={'success': true,'message':'删除数据成功'};
        }else{

          this.ctx.body={'success': false,'message':'删除数据失败'};
        }
      
    } 

view

app/view/admin/goods/edit.html

                   $('.goods_image_delete').click(function(){

                       var _that=this;

                       var flag=confirm('您确定要删除吗?');

                       if(flag){
                            var goods_image_id=$(this).attr('goods_image_id');

                            $.post('/admin/goods/goodsImageRemove?_csrf=<%=csrf%>',{goods_image_id:goods_image_id},function(response){

                                    console.log(response);

                                    if(response.success){

                                        $(_that).parent().remove();

                                    }
                            })
                       }
                   })