erp/core/CoreApp/controllers/Goodimglibrary.php

<?php defined('BASEPATH') OR exit('No direct script access allowed');
class Goodimglibrary extends Start_Controller {
	public function __construct(){
		parent::__construct();
		$this->load->library('session');
        $this->load->_model('Model_goodimgs','goodimgs');
        $this->load->_model('Model_goods','goods');
        $this->load->_model('Model_logic_order','logic_order');
        $this->load->_model("Model_logic_zhlp","logic_zhlp");
        $this->load->_model("Model_classid","classid");
        $this->load->_model("Model_logic_u9tools","logic_u9tools");
        $this->load->_model("Model_typeclass","typeclass");
        $this->load->_model("Model_settingtest","settingtest");
        $this->load->_model("Model_apiyyv1","apiyyv1");
    }
	private $show_url = "https://lyerposs.wepolicy.cn";	
    public function _remap($arg,$arg_array)
    {
		if($arg=="detail"){
			//$this->_detial($arg_array);
		}elseif($arg=="edit"){
			$this->_editData($arg_array);
		}elseif($arg == "get_info_number"){
            $this->_getInfoNumber();
        }elseif($arg == 'showsku'){
            $this->_showSku($arg_array);
        }elseif($arg == 'bcedit'){
            $this->_bcedit($arg_array);
        }elseif($arg == 'indexnoimg'){
            $this->_indexnoimg();
        }elseif($arg == 'add'){
            $this->_add();
        }elseif($arg == 'selectgood'){
            $this->_selectgood();
        }elseif($arg == 'getgoodbyids'){
            $this->_getgoodbyids();
        }elseif($arg == 'excelgood'){
            $this->_excelgood();
        }else{
			$this->_index();
		}
	}
	private function _index(){
		if($this->input->method() == 'post'){
            $page = $this->input->post('page',true);
		    $perpage = $this->input->post('perpage',true);
			$title = $this->input->post('title',true);
            $zh= $this->input->post('zh',true);
            $sku = $this->input->post('sku',true);
            $category = $this->input->post('category',true);
            $category = trim($category);
            $grade = $this->input->post('grade',true);
            $grade = trim($grade);
            $color = $this->input->post('color',true);
            $color = trim($color);
            $lowe = $this->input->post('lowe',true);
            $lowe =  trim($lowe);
            $lacetype = $this->input->post('lacetype',true);
            $lacetype =  trim($lacetype);
            $lacecolor = $this->input->post('lacecolor',true);
            $lacecolor =  trim($lacecolor);
            $size = $this->input->post('size',true);
            $size = trim($size);
            $density = $this->input->post('density',true);
            $density = trim($density);
            $haircap = $this->input->post('haircap',true);
            $haircap = trim($haircap);
            $hairnumber = $this->input->post('hairnumber',true);
            $hairnumber = trim($hairnumber);
          
            if(empty($page))
		    {
                $start = 0;
		    	$perpage = 1;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }

            $this->db->select('g.id, g.features, g.title, g.sku, g.zh, g.jm,g.has_source,g.update_time, gi.id as img_id, gi.source_cont');
            $this->db->from('crowd_goods as g');
            $this->db->join('crowd_goodimgs as gi', 'g.id = gi.goods_id', 'left');
            if($title){
                $title = trim($title);
                $this->db->like('g.title', $title);
            }
            if($zh){
                $zh = trim($zh);
                $this->db->like('g.zh', $zh);
            }
            if($sku){
                $sku = trim($sku);
                $this->db->like('g.sku', $sku);
            }
            if($category){
                $category = trim($category);
                $this->db->like('g.features', $category);
            }
            if($grade){
                $grade = trim($grade);
                $this->db->like('g.features', $grade);
            }
            if($color){
                $color = trim($color);
                $this->db->like('g.features', $color);
            }
            if($lowe){
                $lowe = trim($lowe);
                $this->db->like('g.features', $lowe);
            }
            if($lacetype){
                $lacetype = trim($lacetype);
                $this->db->like('g.features', $lacetype);
            }
            if($lacecolor){
                $lacecolor = trim($lacecolor);
                $this->db->like('g.features', $lacecolor);
            }
            if($size){
                $size = trim($size);
                $this->db->like('g.features', $size);
            }
            if($density){
                $density = trim($density);
                $this->db->like('g.features', $density);
            }
            if($haircap){
                $haircap = trim($haircap);
                $this->db->like('g.features', $haircap);
            }
            if($hairnumber){
                $hairnumber = trim($hairnumber);
                $this->db->like('g.features', $hairnumber);
            }
            $this->db->order_by('g.has_source', 'desc');
            $this->db->order_by('g.update_time', 'desc');
            $this->db->order_by('g.id', 'asc');
            
            

            // 分页 (limit, offset)
            $this->db->limit($perpage, $start);
    
            $query = $this->db->get();

            $list =  $query->result_array();
            $info_list = [];
            foreach($list as $k => $v){
                $info_list[$k]['id'] = $v['id'];
                $info_list[$k]['sku'] = $v['sku'];
                $info_list[$k]['title'] = $v['title'];
                $info_list[$k]['zh'] = $v['zh'];
                $info_list[$k]['update_time'] = empty($v['update_time'])? '' : date('Y-m-d H:i',$v['update_time']);
                $info_list[$k]['imgs'] = $this->transimg($v['source_cont']);
            }
			$this->db->from('crowd_goods');
            if($title){
                $title = trim($title);
                $this->db->like('title', $title);
            }
            if($zh){
                $zh = trim($zh);
                $this->db->like('zh', $zh);
            }
            if($sku){
                $sku = trim($sku);
                $this->db->like('sku', $sku);
            }
            if($category){
                $category = trim($category);
                $this->db->like('features', $category);
            }
            if($grade){
                $grade = trim($grade);
                $this->db->like('features', $grade);
            }
            if($color){
                $color = trim($color);
                $this->db->like('features', $color);
            }
            if($lowe){
                $lowe = trim($lowe);
                $this->db->like('features', $lowe);
            }
            if($lacetype){
                $lacetype = trim($lacetype);
                $this->db->like('features', $lacetype);
            }
            if($lacecolor){
                $lacecolor = trim($lacecolor);
                $this->db->like('features', $lacecolor);
            }
            if($size){
                $size = trim($size);
                $this->db->like('features', $size);
            }
            if($density){
                $density = trim($density);
                $this->db->like('features', $density);
            }
            if($haircap){
                $haircap = trim($haircap);
                $this->db->like('features', $haircap);
            }
            if($hairnumber){
                $hairnumber = trim($hairnumber);
                $this->db->like('features', $hairnumber);
            }

            $total = $this->db->count_all_results();
			
		    $pagenum = ceil($total/$perpage);
		    $over = $total-($start+$perpage);
		    $rows = array('total'=>$total,'over'=>$over,'pagenum'=>$pagenum,'rows'=>($info_list));
		    echo json_encode($rows);exit;
        }else{
            $this->_Template('goodimglibrary',$this->data);
        }
	}

    private function _add(){
        if($this->input->method() == 'post'){
            $post = $this->input->post(null,true);
            if(empty($post['category'])){
                echo json_encode(['success' => false,'msg' => '请选择分类']);exit;
            }
            if($post['category'] != '131' &&  empty($post['size'])){
                echo json_encode(['success' => false,'msg' => '请选择尺寸']);exit;
            }
            if(isset($post['size'])){
                $post['size'] = trim($post['size'],",");
            }
            $res = $this->logic_zhlp->sortByName($post);
            if($res['code'] != 1){
                echo json_encode(['success' => false,'msg' => $res['msg']]);exit;
            }
            if(empty($res)){
                echo json_encode(['success' => false,'msg' => '分类异常']);exit;
            }
            $final_list = $res['data'];
            $typeclass = $this->logic_u9tools->getTypeClass();
            
            $classid = $this->logic_u9tools->getClass();
            $scsku = $classid;
            foreach($final_list as $k=>$v){
                if (!empty($v)) {
                    $type_info = $this->typeclass->read($v);
                    $scsku[$type_info['classid']] = $type_info['bqsku'];
                }
            }
            $scsku = implode("-", $scsku);
            $scsku = str_replace('- ', '-', trim($scsku, '-'));
			$scsku = str_replace(array('--------', '-------', '------', '-----', '----', '---', '--'), '-', $scsku);
            

            

            $tmp_arr = array_values($final_list);
            $size = array_pop($tmp_arr);
            $sku_tmp_arr = [];
            foreach($tmp_arr as $k=>$v){
                if($k == 1 && (!isset($final_list['hairtype']))){
                    $sku_tmp_arr[] = $v;
                    $sku_tmp_arr[] = $size;
                }
                elseif($k == 2 && (isset($final_list['hairtype']))){
                    $sku_tmp_arr[] = $v;
                    $sku_tmp_arr[] = $size;
                }else{
                    $sku_tmp_arr[] = $v;
                }
            }

            $en_title = "";
            foreach($final_list as $k=>$v){
                if(in_array($v,[163,164,165,166])){
                    continue;
                }
                if(isset($typeclass[$v])){
                    $en_title.= $typeclass[$v]['title']." ";
                }
            }
            $en_title = trim($en_title);
           
            $sku = "-".implode("-",$sku_tmp_arr)."-";
           
            $org_sku = implode("-",$final_list);
            
            $u9_info = $this->logic_u9tools->getOneU9bmHasGift($org_sku,$classid,$typeclass);
            $u9_info['title'] = $en_title;
            $u9_info['sku'] = $scsku;
            $u9_info['features'] = $sku;
            $u9_info['org_sku'] = $org_sku;
            $r = $this->goods->find("features = '".$u9_info['features']."'");
            if(!empty($r)){
                if($r['u9_check'] != 1){
                    //查询u9是否存在
                    $u9_jm = $this->_getU9GoodInfoByJm($r['jm']);
                    if(empty($u9_jm)){
                        echo json_encode(['success' => false,'msg' => $r['jm'].':未同步到u9系统，请联系管理员同步到u9系统。']);exit;
                    }else{
                        $this->goods->save([
                            'u9_check'=>1,
                            'jm'=>$u9_jm
                        ],$r['id']);
                    }
                }
                echo json_encode(['success' => false,'msg' => '商品已录入']);exit;
            }
            //u9已经创建 但是erp没创建
            $u9_jm = $this->_getU9GoodInfoByJm($u9_info['jm']);
            if(!empty($u9_jm)){
                $rr = $this->goods->insert([
                    'features'=>$u9_info['features'],
                    'title'=>$u9_info['title'],
                    'sku'=>$u9_info['sku'],
                    'zh'=>$u9_info['zh'],
                    'jm'=>$u9_jm,
                    'u9_check'=>1,
                ]);
                if($rr){
                    echo json_encode(['success' => true,'msg' => '商品添加成功']);
                    exit;
                }else{
                    echo json_encode(['success' => false,'msg' => '商品添加失败']);
                    exit;
                }
            }
            $info = [
                'jm'=>$u9_info['jm'],
                'zh'=>$u9_info['zh'],
                'bm'=>$u9_info['bm'],
                'ztcode'=>'001',
                'title'=>$u9_info['title'],
                'owner_code'=>120,
            ];
            //u9没创建 erp也没有创建
            $token = $this->settingtest->get_yytoken_120();
            $res = $this->apiyyv1->cjLpAndtbLp($info,$token);
            if(empty($res[0]['Data'])){
                echo $res[0]['ResMsg'];
                exit;
            }
            if(empty($res[0]['Data'][0])){
                echo $res[0]['ResMsg'];
                exit;
            }
            if(!empty($res[0]['Data'][0]['ResMsg'])){
                echo $res[0]['Data'][0]['ResMsg'];
                exit;
            }
            $token = $this->settingtest->get_yytoken_120();
            $res = $this->apiyyv1->tbLpNew($info,$token);
            
            $rr = $this->goods->insert([
                'features'=>$u9_info['features'],
                'title'=>$u9_info['title'],
                'sku'=>$u9_info['sku'],
                'zh'=>$u9_info['zh'],
                'jm'=>$u9_info['jm'],
                'u9_check'=>1,
            ]);
            if($rr){
                echo json_encode(['success' => true,'msg' => '商品添加成功']);
                exit;
            }else{
                echo json_encode(['success' => false,'msg' => '商品添加失败']);
                exit;
            }
            
           
        }else{
            $this->data['data'] = "";
            $this->_Template('goodimglibrary_add',$this->data);
        }
    }

    private function _getU9GoodInfoByJm($jm){
        $u9_jm = "";
        //查询u9是否存在
        $token = $this->settingtest->get_yytoken_120();
        $res = $this->apiyyv1->cxLpByJm($jm,$token);
        if(!empty($res['Data'])){
            if(!empty($res['Data']['0'])){
                if(!empty($res['Data']['0']['m_code'])){
                    $u9_jm = $res['Data']['0']['m_code'];                        
                }
            }
        }
        return $u9_jm;
    }
    private function _indexnoimg(){
		if($this->input->method() == 'post'){
            $page = $this->input->post('page',true);
		    $perpage = $this->input->post('perpage',true);
			$title = $this->input->post('title',true);
            $zh= $this->input->post('zh',true);
            $sku = $this->input->post('sku',true);
            $category = $this->input->post('category',true);
            $category = trim($category);
            $grade = $this->input->post('grade',true);
            $grade = trim($grade);
            $color = $this->input->post('color',true);
            $color = trim($color);
            $lowe = $this->input->post('lowe',true);
            $lowe =  trim($lowe);
            $lacetype = $this->input->post('lacetype',true);
            $lacetype =  trim($lacetype);
            $lacecolor = $this->input->post('lacecolor',true);
            $lacecolor =  trim($lacecolor);
            $size = $this->input->post('size',true);
            $size = trim($size);
            $density = $this->input->post('density',true);
            $density = trim($density);
            $haircap = $this->input->post('haircap',true);
            $haircap = trim($haircap);
            $hairnumber = $this->input->post('hairnumber',true);
            $hairnumber = trim($hairnumber);
          
            if(empty($page))
		    {
                $start = 0;
		    	$perpage = 1;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }

            $where =  '1 = 1';
            if($title){
                $title = trim($title);
                $where .= ' AND title LIKE "%'.trim($title).'%" ';
               
            }
            if($zh){
                $zh = trim($zh);
                $where .= ' AND zh LIKE "%'.trim($zh).'%" ';
            }
            if($sku){
                $sku = trim($sku);
                $where .= ' AND sku LIKE "%'.trim($sku).'%" ';
            }
            if($category){
                $category = trim($category);
                $where .= ' AND features LIKE "%'.trim($category).'%" ';
            }
            if($grade){
                $grade = trim($grade);
                $where .= ' AND features LIKE "%'.trim($grade).'%" ';
            }
            if($color){
                $color = trim($color);
                $where .= ' AND features LIKE "%'.trim($color).'%" ';
            }
            if($lowe){
                $lowe = trim($lowe);
                $where .= ' AND features LIKE "%'.trim($lowe).'%" ';
            }
            if($lacetype){
                $lacetype = trim($lacetype);
                $where .= ' AND features LIKE "%'.trim($lacetype).'%" ';
            }
            if($lacecolor){
                $lacecolor = trim($lacecolor);
                $where .= ' AND features LIKE "%'.trim($lacecolor).'%" ';
            }
            if($size){
                $size = trim($size);
                $where .= ' AND features LIKE "%'.trim($size).'%" ';
            }
            if($density){
                $density = trim($density);
                $where .= ' AND features LIKE "%'.trim($density).'%" ';
            }
            if($haircap){
                $haircap = trim($haircap);
                $where .= ' AND features LIKE "%'.trim($haircap).'%" ';
            }
            if($hairnumber){
                $hairnumber = trim($hairnumber);
                $where .= ' AND features LIKE "%'.trim($hairnumber).'%" ';
            }

            $list = $this->goods->find_all($where,'id,sku,title,zh,jm,update_time','id DESC',$start,$perpage);
            $info_list = [];
            foreach($list as $k => $v){
                $info_list[$k]['id'] = $v['id'];
                $info_list[$k]['sku'] = $v['sku']."  <i class='fa fa-copy' data-text='".$v['sku']."' onclick='fuzhi(this)' style='background-color:#FFE4C4'></i>";
                $info_list[$k]['title'] = $v['title']."  <i class='fa fa-copy' data-text='".$v['title']."' onclick='fuzhi(this)' style='background-color:#FFE4C4'></i>";
                $info_list[$k]['zh'] = $v['zh']."  <i class='fa fa-copy' data-text='".$v['zh']."' onclick='fuzhi(this)' style='background-color:#FFE4C4'></i>";
                $info_list[$k]['jm'] = $v['jm']."  <i class='fa fa-copy' data-text='".$v['jm']."' onclick='fuzhi(this)' style='background-color:#FFE4C4'></i>";

            }
			
            $total = $this->goods->find_count($where);
			
		    $pagenum = ceil($total/$perpage);
		    $over = $total-($start+$perpage);
		    $rows = array('total'=>$total,'over'=>$over,'pagenum'=>$pagenum,'rows'=>($info_list));
		    echo json_encode($rows);exit;
        }else{
            $user = $this->user->get_api($_SESSION['api']);
            $user_id = $user['id'];
            $this->data['user_id'] = $user_id;
            $this->_Template('goodimglibrary_noimg',$this->data);
        }
	}

    private function transimg($source_cont){
        $str = ' ';
        if(!empty($source_cont)){
            $imgs = json_decode($source_cont,true);
          
            foreach($imgs as $k => $v){
                $type = $this->_checkVideo($v);
                $url = $this->_transingurl($v);
                if($type == "video"){
                    $str.= '<video controls="true" width="100" src="'.$url.'" alt="video image" style="margin-right:3px;"></video>';
                }else{
                    $str .= '<img width="100px" src="'.$url.'" alt="image" style="margin-right:3px;" onclick="showBigImg(this)">';
                }
            }
           
        }
       return $str;
    }
	private function _editData($arg_array){
        if($this->input->method() == 'post'){
            $id = $this->input->post('id',true);
            $img = $this->input->post('img',true);
            if(empty($img)){
                $img = [];
            }
            foreach($img as $k => $v){
                $img[$k] = str_replace($this->show_url, '', $v);
            }
            $info  =  $this->db->get_where('crowd_goods',array('id'=>$id))->row_array();    
            $images = $this->goodimgs->find("goods_id = ".$id);
            $has_source = empty($img)?0:5;
            $update_time = time();
            if(empty($images)){
                if($this->goodimgs->insert(array('goods_id'=>$id,'features'=>$info['features'],'source_cont'=>json_encode($img,JSON_UNESCAPED_SLASHES)))){
                    $this->goods->save(array('has_source'=>$has_source,'update_time'=>$update_time),$id);
                    echo json_encode(array('msg'=>'修改成功','success'=>true));exit;
                }else{
                    echo json_encode(array('msg'=>'修改失败，请重试1','success'=>false));exit;
                }

            }else{
                if($this->goodimgs->save(array('features'=>$info['features'],'source_cont'=>json_encode($img,JSON_UNESCAPED_SLASHES)),$images['id'])){
                    $this->goods->save(array('has_source'=>$has_source,'update_time'=>$update_time),$id);
                    echo json_encode(array('msg'=>'修改成功','success'=>true));exit;
                }else{
                    echo json_encode(array('msg'=>'修改失败，请重试2','success'=>false));exit;
                }
            }

        }
        if($this->input->method() == 'get'){
            $id = $arg_array[0];
            $goods = $this->db->get_where('crowd_goods',array('id'=>$id))->row_array();
            $this->db->where('goods_id',$id);
            $images = $this->db->get('crowd_goodimgs')->result_array();
            if(empty($images)){
                $goods['images'] = [];
            }else{
                $imgs = json_decode($images[0]['source_cont'],true);
                $final_imgs = [];
                foreach($imgs as $k => $v){
                    $final_imgs[$k]['url'] = $this->_transingurl($v);
                    $final_imgs[$k]['type'] = $this->_checkVideo($v);
                }
                $goods['images'] = $final_imgs;
            }
           
           
            $this->data['goods'] = $goods;
            $this->_Template('goodimglibrary_edit',$this->data);
            
        }
    }

    private function _bcedit($arg_array){
        if($this->input->method() == 'post'){
            $id = $this->input->post('id',true);
            $img = $this->input->post('img',true);
            if(empty($img)){
                $img = [];
            }
            foreach($img as $k => $v){
                $img[$k] = str_replace($this->show_url, '', $v);
            }
            $info  =  $this->db->get_where('crowd_goods',array('id'=>$id))->row_array();    
            $images = $this->goodimgs->find("goods_id = ".$id);
            $has_source = empty($img)?0:5;
            $update_time = time();
            if(empty($images)){
                if($this->goodimgs->insert(array('goods_id'=>$id,'features'=>$info['features'],'source_cont'=>json_encode($img,JSON_UNESCAPED_SLASHES)))){
                    $this->goods->save(array('has_source'=>$has_source,'update_time'=>$update_time),$id);
                    echo json_encode(array('msg'=>'修改成功','success'=>true));exit;
                }else{
                    echo json_encode(array('msg'=>'修改失败，请重试1','success'=>false));exit;
                }

            }else{
                if($this->goodimgs->save(array('features'=>$info['features'],'source_cont'=>json_encode($img,JSON_UNESCAPED_SLASHES)),$images['id'])){
                    $this->goods->save(array('has_source'=>$has_source,'update_time'=>$update_time),$id);
                    echo json_encode(array('msg'=>'修改成功','success'=>true));exit;
                }else{
                    echo json_encode(array('msg'=>'修改失败，请重试3','success'=>false));exit;
                }
            }

        }
        if($this->input->method() == 'get'){
            $id = $arg_array[0];
            $goods = $this->db->get_where('crowd_goods',array('id'=>$id))->row_array();
            $this->db->where('goods_id',$id);
            $images = $this->db->get('crowd_goodimgs')->result_array();
            if(empty($images)){
                $goods['images'] = [];
            }else{
                $imgs = json_decode($images[0]['source_cont'],true);
                $final_imgs = [];
                foreach($imgs as $k => $v){
                    $final_imgs[$k]['url'] = $this->_transingurl($v);
                    $final_imgs[$k]['type'] = $this->_checkVideo($v);
                }
                $goods['images'] = $final_imgs;
            }
           
           
            $this->data['goods'] = $goods;
            $this->_Template('goodimglibrary_bcedit',$this->data);
            
        }
    }



    //根据后缀判断是否是视频
    private function _checkVideo($str){
        $hz_arr = explode(".",$str);
        $hz = end($hz_arr);
        if(in_array($hz,['mp4','flv','rmvb','avi','wmv','mov','rm','mkv'])){
            return "video";
        }
        return "img";

    }


    private function _transingurl($url){
        $url_arr = explode('/', $url);
		$filename = array_pop($url_arr);
		$filename = rawurlencode($filename);
		$url_arr[] = $filename;
		$final_url = implode('/', $url_arr);
        $final_url = $this->show_url.$final_url;
		return $final_url;
    }
	
    public function _getInfoNumber(){
        if($this->input->method() == 'post'){
            $number = $this->input->post('number',true);
            if(empty($number)){
                echo json_encode(['msg'=>'请输入订单编码','success'=>false,'data'=>[]]);exit;
            }
            $info = $this->logic_order->getInfo("number = '$number'");
            if(empty($info)){
                echo json_encode(['msg'=>'订单信息不存在','success'=>false,'data'=>[]]);exit;
            }
                
            $fpdata = $info['fpdata'];
            $tmp_list = explode(';', trim($fpdata,';'));
            $sku_list  = [];
            foreach($tmp_list as $k => $v){
                $tmp_arr = explode('|', $v);
                if(strpos($tmp_arr[0],',') !== false){
                    $tmp_arr[0] =
                    $sku_list[] = $this->logic_u9tools->getGoodFeatureAlone($tmp_arr[0]);
                }else{
                    $sku_list[] = "-".trim($tmp_arr[0],"-")."-";
                }
            }
            $final_list = [];
            $classid = $this->logic_u9tools->getClass();
            $typeclass = $this->logic_u9tools->getTypeClass();
            foreach($sku_list as $k => $v){
                if(strpos($v,'-131-') !== false){
                    continue;
                }
                $r = $this->logic_zhlp->transferSku(explode('-',trim($v,'-')));
                $rr = $this->logic_zhlp->sortByColume($r);
                $rrr = $this->logic_zhlp->featureTransferColumn($rr['data'],$classid);
                $rrrr = $this->logic_u9tools->getOneU9bmHasGift($v,$classid,$typeclass);
                $final_list[] = [
                    'jm'=>$rrrr['jm'],
                    'zh'=>$rrrr['zh'],
                    'sku'=>$rrr['sku'],
                    'title'=>$rrr['title'],
                    'zzh'=>$rrr['zh'],
                    'features'=>$v,
                ];
            }
            foreach($final_list as $k => $v){
                $info = $this->goods->find("features = '$v[features]'");
                if(!empty($info)){
                    $final_list[$k]['s_id'] = $info['id'];
                }else{
                    $id = $this->goods->insert([
                        'features'=>$v['features'],
                        'title'=>$v['title'],
                        'zh'=>$v['zh'],
                        'sku'=>$v['sku'],
                        'jm'=>$v['jm'],
                    ]);
                    $final_list[$k]['s_id'] = $id;
                    $final_list[$k]['has_source'] = 0;
                }
            }
            echo json_encode(['msg'=>'订单信息获取成功','success'=>true,'data'=>$final_list]);exit;
        }else{
            $this->_Template('goodimglibrary_number',$this->data);
        }
    }


    private function _showSku($arg_array){
        echo "<pre>";
        print_r($arg_array);
        die;
    }

    private function _selectgood(){
        if($this->input->method() == 'post'){
            
            $params = $this->input->post(null,true);
            
            $this->db->select('id,features, title, sku, zh, jm');
            $this->db->from('crowd_goods');
            $category = $params['category'];
            $this->db->like('features',$category);
            if(!empty($params['color'])){
                $this->db->like('features',$params['color']);
            }
            if(!empty($params['density'])){
                $this->db->like('features',$params['density']);
            }
            if(!empty($params['grade'])){
                $this->db->like('features',$params['grade']);
            }
            if(!empty($params['haircap'])){
                $this->db->like('features',$params['haircap']);
            }
            if(!empty($params['hairnumber'])){
                $this->db->like('features',$params['hairnumber']);
            }
            if(!empty($params['lacecolor'])){
                $this->db->like('features',$params['lacecolor']);
            }
            if(!empty($params['lacetype'])){
                $this->db->like('features',$params['lacetype']);
            }
            if(!empty($params['lowe'])){
                $this->db->like('features',$params['lowe']);
            }
            if(!empty($params['size'])){
                $this->db->like('features',$params['size']);
            }
            if(!empty($params['zh'])){
                $this->db->like('zh',$params['zh']);
            }
        
            $this->db->order_by('id', 'asc');
            // 分页 (limit, offset)
            $this->db->limit(20, 0);
    
            $query = $this->db->get();

            $list =  $query->result_array();


            if(empty($list)){
                echo json_encode(['success'=>false,'msg'=>'查询失败']);exit;
            }else{
                echo json_encode(['success'=>true,'msg'=>'查询成功','data'=>$list]);exit;
            }
        }else{
            $this->_Template('goodimglibrary_selectgood',$this->data);
        }
    }
    private function _getgoodbyids(){
        if($this->input->method() == 'post'){
            $ids = $this->input->post('ids',true);
            $this->db->select('id,features, title, sku, zh, jm');
            $this->db->from('crowd_goods');
            $this->db->where_in('id',$ids);
            $query = $this->db->get();
            $list =  $query->result_array();
            echo json_encode(['success'=>true,'msg'=>'查询成功','data'=>$list]);exit;
        }else{
            echo json_encode(['success'=>false,'msg'=>'查询失败']);exit;
        }
    }
    private function _excelgood(){
        if($this->input->method() == 'post'){
            $params = $this->input->post(null,true);
            $this->db->select('features, title, sku, zh, jm');
            $this->db->from('crowd_goods');
            if(!empty($params['category'])){
                $this->db->like('features',$params['category']);
            }
            if(!empty($params['color'])){
                $this->db->like('features',$params['color']);
            }
            if(!empty($params['density'])){
                $this->db->like('features',$params['density']);
            }
            if(!empty($params['grade'])){
                $this->db->like('features',$params['grade']);
            }
            if(!empty($params['haircap'])){
                $this->db->like('features',$params['haircap']);
            }
            if(!empty($params['lacecolor'])){
                $this->db->like('features',$params['lacecolor']);
            }
            if(!empty($params['lacetype'])){
                $this->db->like('features',$params['lacetype']);
            }
            if(!empty($params['lowe'])){
                $this->db->like('features',$params['lowe']);
            }
            if(!empty($params['size'])){
                $this->db->like('features',$params['size']);
            }
            if(!empty($params['zh'])){
                $this->db->like('zh',$params['zh']);
            }
            if(!empty($params['sku'])){
                $this->db->like('sku',$params['sku']);
            }
            if(!empty($params['title'])){
                $this->db->like('title',$params['title']);
            }
    
            $query = $this->db->get();
            $list =  $query->result_array();
            if(empty($list)){
                echo json_encode(['success'=>false,'msg'=>'没有数据']);exit;
            }else{
                $final_list = [];
                foreach($list as $k => $v){
                    $final_list[] = [
                        'u9料号'=>$v['jm'],
                        '仓库品名'=>$v['zh'],
                        '英文名字'=>$v['title'],
                        'SKU'=>$v['sku'],
                    ];
                }
                echo json_encode(['success'=>true,'msg'=>'查询成功','data'=>$final_list]);exit;
            }
        }else{
            echo json_encode(['success'=>false,'msg'=>'请求不合法']);exit;
        }
    }
}