平台上的商品数据来自于两个互不相干的数据库,事前经过中间表进行统一处理,现在进行商户对挑选加入到自身商户商品表的操作。
直接贴代码,同样有每行解析,重要的是想出来的一种想法。
public function add_ik(){//添加ttp到整合表
$fr_present_id=$this->input->post("fr_present_id");//接收status+goods_id+来源的库ttp还是llf+#号
//echo $fr_present_id;
$goods_id=str_replace(",","",$fr_present_id);//因为是传递多个,用逗号进行分割,所以进行对逗号的取代
$cat=substr($goods_id,-4,3);//判断来源ttp还是llf
//$status=substr($goods_id,-1,1);
//$goods_id=str_replace("$status","",$goods_id);
$hh=explode("#",$goods_id);//#号来做区分划分
$hh=array_filter($hh);//过滤空数组
//print_r($hh);
$lijunsheng=array();//开新数组
//$goods_info = array();
foreach ($hh as $value) {
$status=substr($value,0,1);
if ($status=="2") {//这个是状态,2为没选择过的商品
$cat=substr($value,-3,3);//这个是源自哪个数据库的商品
if ($cat=="llf") {//区分处理,这个是app的数据
$goods_info = array();
$value=str_replace("$cat","",$value);
$value=substr($value,1,5);
$where=array('gallery_id'=>$value);
$llf_info=$this->gallery_model->getone_llf($where);
//print_r($llf_info);
$goods_info['goods_id']=$llf_info['gallery_id']."llf";//有做删减
$goods_info['goods_sn']=$llf_info['present_no'];
$goods_info['goods_name']=$llf_info['name'];
$goods_info['marketPrice']=$llf_info['price'];
$goods_info['costPrice']=$llf_info['sell_price'];
$goods_info['desc']=$llf_info['order_by'];
$goods_info['cat_id']=$llf_info['type_ids'];
$goods_info['original_img']=$llf_info['images'];
//print_r($goods_info);
//die;
$insert_id=$this->gallery_model->shangjia_add_goods($goods_info);
$lijunsheng[]=$insert_id;
//die;
} else {//这个是平台自身的数据
$value=str_replace("$cat","",$value);
$value=substr($value,1,5);
$where=array('goods_id'=>$value);
$goods_info=$this->gallery_model->getone($where);//通过查商品数据库然后将信息带回到商户的商品库中
$goods_info['goods_id']=$goods_info['goods_id']."ttp";
//print_r( $goods_info);
$insert_id=$this->gallery_model->shangjia_add_goods($goods_info);
$lijunsheng[]=$insert_id;
}
}
}
if($lijunsheng != null){
exit("2");
}else{
exit("1");
}
}