1.功能商品名称不能重复，包含excel里面不能重复，同时也不能和已经导入的商品名字重复。（没有通过数据库唯一约束实现）

2.循环里面一条一条处理，一旦有一条数据处理失败则回滚，都成功才会最终提交。（mysql数据库引擎需要是innodb）

3.如果多行数据有问题，失败问题原因都会展示。（错误累计展示，方便对excel修改，再次导入）

代码如下：

private function save_import_new($data) {

	$basekeynum = $_SESSION["accountinfo"]["basekeynum"];

	if (empty($data)) {

		$rt["sta"] = 0;

		$rt["msg"] = "导入为空";

		echo json_encode($rt);

		die;

	}

	$error_flag="0";

	$error_msg="";

	foreach ($data as $key => $value) {

		$goods_id =$value["A"];

		$goods_name =trim($value["B"]);

		$cate_name =trim($value["C"]);

		$goods_img = $value["D"];

		$goods_des = $value["E"];

		$goods_sort = $value["F"];

		$goods_money = $value["G"];

		$is_show = $value["H"];

		if($goods_name=='') {

			$error_flag=1;

			$error_msg.= "第" . $key . "行商品名称为空！<br/>";

		}

		if($cate_name=='') {

			$error_flag=1;

			$error_msg.= "第" . $key . "行分类名称为空！<br/>";

		}

		$goodsinfo = M("goods")->where("goods_name='$goods_name' and basekeynum='$basekeynum' ")->find();

		if (!empty($goodsinfo)) {

			$error_flag=1;

			$error_msg.= "第" . $key . "行商品名称和系统里面重复<br/>";

		}

	}

	if($error_flag=='1') {

		$rt["sta"] = 0;

		$rt["msg"] = $error_msg;

		echo json_encode($rt);

		die;

	}

	//开启事务处理机制

	$flag = true;

	$Model = M();

	$Model->startTrans();

	foreach ($data as $key => $value) {

		$goods_id =$value["A"];

		$goods_name =trim($value["B"]);

		$cate_name =trim($value["C"]);

		$goods_img = $value["D"];

		$goods_des = $value["E"];

		$goods_sort = $value["F"];

		$goods_money = $value["G"];

		$is_show = $value["H"];

		$goodsinfo = $Model->table('zs_goods')->where("goods_name='$goods_name' and basekeynum='$basekeynum' ")->find();

		if (!empty($goodsinfo)) {

			$flag = false;

			$error_msg.= "第" . $key . "行商品名称（".$goods_name."）和excel里面其他行重复<br/>";

		}

		//先查询分类是否存在，不存在则新增

		$cate_info =$Model->table('zs_goods_cate')->where("cate_name='$cate_name' and basekeynum='$basekeynum' ")->find();

		if (!empty($cate_info)) {

			$cate_id=$cate_info['cate_id'];

		} else {

			//新增

			$addcate['cate_name']=$cate_name;

			$addcate['cate_sort']=0;

			$addcate['add_time']=time();

			$addcate['status']=1;

			$addcate['basekeynum']=$basekeynum;

			$cate_id=$Model->table('zs_goods_cate')->add( $addcate);

			if(!$cate_id) {

				$flag = false;

				$error_msg.= "第" . $key . "行分类名称".$cate_name."新增失败<br/>";

			}

		}

		//新增商品

		$add["goods_name"] = $goods_name;

		$add["cate_id"] = $cate_id;

		$add["goods_img"] = $goods_img;

		$add["goods_des"] = $goods_des;

		$add["goods_sort"] = $goods_sort;

		$add["goods_money"] = $goods_money;

		$add["is_show"] = $is_show;

		$add["goods_add_time"] = time();

		$add["basekeynum"] = $basekeynum;

		$goods_id=$Model->table('zs_goods')->add($add);

		if(!$goods_id) {

			$flag = false;

			$error_msg.= "第" . $key . "行商品名称".$goods_name."新增失败<br/>";

		}

	}

	if($flag==true) {

		$Model->commit();

		$rt["sta"] = 1;

		$rt["msg"] = "导入成功";

		echo json_encode($rt);

		die;

	} else {

		$Model->rollback();

		$rt["sta"] = 0;

		$rt["msg"] = "导入失败,失败原因".$error_msg;

		echo json_encode($rt);

		die;

	}

}