ECSHOP批量上传二次开发2

继上次批量上传，这次做了一个不需要修改数据库的版本

 

1.languages/zh/admin/goods_batch.php

添加整理属性/根据需要批量上传的属性

//自定义批量上传字段start

$_LANG['upload_goods']['goods_guige']='规格';

$_LANG['upload_goods']['goods_xilie']='系列';

$_LANG['upload_goods']['goods_xinghao']='型号';

$_LANG['upload_goods']['goods_type']='商品类型';

//自定义批量上传字段end

 

 

2.添加电器商品类型的属性

后台添加即可

 

3.批量上传的时候插入到goods_attr

admin/goods_batch.php

395行

/*myself 获取商品类型和商品属性*/

$cat_name=$field_arr['goods_type'];

$cat_id=$db->getOne("select cat_id from ".$ecs->table('goods_type')." where cat_name='".$cat_name."'");

$field_arr['goods_type']=$cat_id;

477行

/*myself自定义属性赋值*/

$attr_xilie_id=$db->getOne("select attr_id from ".$ecs->table('attribute')." where attr_name='系列'");

$attr_xinghao_id=$db->getOne("select attr_id from ".$ecs->table('attribute')." where attr_name='型号'");

$attr_guige_id=$db->getOne("select attr_id from ".$ecs->table('attribute')." where attr_name='规格'");

//插入属性

$sql="insert into ".$ecs->table('goods_attr')." values('',".$insert_id.",".$attr_xilie_id.",'".$field_arr['goods_xilie']."',0)";

$db->query($sql);

$sql="insert into ".$ecs->table('goods_attr')." values('',".$insert_id.",".$attr_xinghao_id.",'".$field_arr['goods_xinghao']."',0)";

$db->query($sql);

$sql="insert into ".$ecs->table('goods_attr')." values('',".$insert_id.",".$attr_guige_id.",'".$field_arr['goods_guige']."',0)";

$db->query($sql);