erp/core/CoreApp/models/Model_logic_u9tools.php

<?php
/**
 * 封装一些转化为u9数据的操作
 */
class Model_logic_u9tools extends Lin_Model {
    function __construct(){
        parent::__construct();
        $this->load->_model('Model_classid','classid');
        $this->load->_model('Model_typeclass','typeclass');
        $this->load->_model("Model_logic_tools",'logic_tools');
        $this->load->_model("Model_apiyyv1","apiyyv1");
        $this->load->_model("Model_settingtest","settingtest");
       // $this->load->_model("Model_logic_ding","logic_ding");
    }
    //获取u9的料号
    public function getU9bm(array $list,$sku_name){
        if(empty($list)){
            return [];
        }
        $tcjm = [];  $typeclass = [];
        $classid = $this->classid->sku();
       
        $tcall = $this->typeclass->find_all();
        foreach ($tcall as $v)
        {
            //$tcjm[$v['id']] = array($v['jm'],$v['classid']);
            $typeclass[$v['id']] = array('zh'=>$v['zh'],'classid'=>$v['classid'],'bm'=>$v['bm'],'title'=>$v['title'],'jm'=>$v['jm']);
        }
        
        foreach($list as $k=>$v){
            
            $r = $this->getOneU9bm($v[$sku_name],$classid,$typeclass);
            $list[$k]['jm'] =  $r['jm'];
            $list[$k]['zh'] =  $r['zh'];
            $list[$k]['bm'] =  $r['bm'];
        }
        return $list;
    }

    public function getOneU9bm($sku,$classid,$typeclass){
        $bm = '03';
        $ret_arr = [
            'jm'=>"",//料号，SKU
            'zh'=>"",//产品名称
            'bm'=>"",//主分类下的编码
        ];
        if(stripos($sku,'-131-') !== false)
        {
            return $ret_arr;
        }
        $pm = $classid;
        $jm = $classid;
        $ch_bmpx = $bmpx = array(13=>'',16=>'',18=>'',25=>'',26=>'',41=>'');
        $features = str_replace(array('-163-','-164-','-165-','-166-'),'-',$sku);
        $features = explode("-",trim($sku,'-'));
        //先执行一边检测是否含有等级 如果没写等级 就默认为9A  这样可以避免传输u9报错   先不用这个是错误的
        // foreach($features as $k=>$v){
        //     if(isset($typeclass[$v]) && isset($bmpx[$typeclass[$v]['classid']]))
        //     {
        //         if($typeclass[$v]['bm'] != '')
        //         {
        //             $ch_bmpx[$typeclass[$v]['classid']] = $typeclass[$v]['bm'];
                
        //         }
        //     }
        // }
        // if(empty($ch_bmpx[13])){
        //     //让原来的规格码 添加上9A这个规格
        //     $features[] = 80;
        // }
        foreach($features as $k=>$v)
        {
            if(isset($typeclass[$v]) && isset($bmpx[$typeclass[$v]['classid']]))
            {
                if($typeclass[$v]['bm'] != '')
                {
                    $bmpx[$typeclass[$v]['classid']] = $typeclass[$v]['bm'];
                
                }
            }
            if($v != 0)
            {
                // if(!isset($typeclass[$v])){
                //     $this->logic_ding->sendToDing("u9工具同步监听异常数据".json_encode($sku));
                //     $this->logic_ding->sendToDing("u9工具同步监听异常数据".json_encode($typeclass));
                //     $this->logic_ding->sendToDing("u9工具同步监听异常数据".json_encode($classid));
                //     $this->logic_ding->sendToDing("u9工具同步监听异常数据".json_encode($v));
                // }
                if(isset($pm[$typeclass[$v]['classid']]))
                {
                    if($typeclass[$v]['title'] == '9A')
                    {
                        $pm[$typeclass[$v]['classid']] = '9A';
                    }
                    else if($typeclass[$v]['title'] == '10A')
                    {
                        $pm[$typeclass[$v]['classid']] = '10A';
                    }
                    else
                    {
                        $clzh = $typeclass[$v]['zh'];
                        if(stripos($typeclass[$v]['zh'],'|') !== false)
                        {
                            $clzh = explode('|',rtrim($typeclass[$v]['zh'],'|'));
                            $clzh = $clzh[0];
                        }
                        $pm[$typeclass[$v]['classid']] = $clzh;
                    }
                }
                if(isset($jm[$typeclass[$v]['classid']]))
                {
                    if($typeclass[$v]['jm'])
                    {
                        $jm[$typeclass[$v]['classid']] = $typeclass[$v]['jm'];
                    }
                }
            }
        }
        $all_jm = $jm;
        $jm = array_filter($jm);//去除空值
        $jm = implode("-",$jm);
        $pm = array_filter($pm);//去除空值
        $zh = implode(" ",$pm);
        $zh = preg_replace("/\r\n|\r|\n/",'',trim($zh,' '));

        $tmp_all_jm = [];

        foreach($all_jm as $k_tmp=>$tmp_v){
             $tmp_all_jm[] = [
                "classid"=>$k_tmp,
                "title"=>$tmp_v

            ];
        }   

        return [
            'jm'=>$jm,//料号，SKU
            'zh'=>$zh,//产品名称
            'bm'=>$bm.implode("",$bmpx),//主分类下的编码
            'all_jm'=> $tmp_all_jm
        ];
    }


    public function getOneU9bmHasGift($sku,$classid,$typeclass){
        $bm = '03';
        
        $pm = $classid;
        $jm = $classid;
        $bmpx = array(13=>'',16=>'',18=>'',25=>'',26=>'',41=>'');
        $features = str_replace(array('-163-','-164-','-165-','-166-'),'-',$sku);
        $features = explode("-",trim($sku,'-'));
        foreach($features as $k=>$v)
        {
            if(isset($typeclass[$v])){
                

                if(isset($typeclass[$v]) && isset($bmpx[$typeclass[$v]['classid']]))
                {
                    if($typeclass[$v]['bm'] != '')
                    {
                        $bmpx[$typeclass[$v]['classid']] = $typeclass[$v]['bm'];
                    
                    }
                }
                if($v != 0)
                {
                    if(isset($pm[$typeclass[$v]['classid']]))
                    {
                        if($typeclass[$v]['title'] == '9A')
                        {
                            $pm[$typeclass[$v]['classid']] = '9A';
                        }
                        else if($typeclass[$v]['title'] == '10A')
                        {
                            $pm[$typeclass[$v]['classid']] = '10A';
                        }
                        else
                        {
                            $clzh = $typeclass[$v]['zh'];
                            if(stripos($typeclass[$v]['zh'],'|') !== false)
                            {
                                $clzh = explode('|',rtrim($typeclass[$v]['zh'],'|'));
                                $clzh = $clzh[0];
                            }
                            $pm[$typeclass[$v]['classid']] = $clzh;
                        }
                    }
                    if(isset($jm[$typeclass[$v]['classid']]))
                    {
                        if($typeclass[$v]['jm'])
                        {
                            $jm[$typeclass[$v]['classid']] = $typeclass[$v]['jm'];
                        }
                    }
                }



            }
            
        }
        $jm = array_filter($jm);//去除空值
        $jm = implode("-",$jm);
        $pm = array_filter($pm);//去除空值
        $zh = implode(" ",$pm);
        $zh = preg_replace("/\r\n|\r|\n/",'',trim($zh,' '));
        return [
            'jm'=>$jm,//料号，SKU
            'zh'=>$zh,//产品名称
            'bm'=>$bm.implode("",$bmpx),//主分类下的编码
        ];
    }
    /**
     * 通过erp的组合出来的sku反推出erp的sku的id组合和u9的编码以及中文名和料品   这种仅限于满足老代码排序的那种 要是不满足 再重新开一个方法吧
     */
    public function getGoodInfoByErpSku($category,$sku,$typeclass,$typeclassid,$classid){
        $sku_arr = explode("-",trim($sku,"-"));
        $sku_list = [];
        $flag = false;
        $err_msg = "";
        foreach($sku_arr as $v){
            if(!isset($typeclass[$v])){
                $err_msg="u9组合的[".$v."]不存在,请核对";
                $flag = true;
            }else{
                $sku_list[$typeclass[$v]['classid']] = $typeclass[$v];
            }
           
        }
        if($flag){
            return $this->logic_tools->ret_arr(-1,$err_msg."异常行的料号为【".$sku."】");
        }
        if($category == "发条"){
            $cate = 126;
        }elseif($category == "发块前头"){
            $cate = 127;
        }elseif($category == "头套"){
            $cate = 128;
        }elseif($category == "接发"){
            $cate = 130;
        }elseif($category == "礼物"){
            $cate = 131;
        }
        elseif($category == "配件"){
            $cate = 133;
        }
        elseif($category == "化纤头套"){
            $cate = 1297;
        }
        elseif($category == "化纤其它"){
            $cate = 1702;
        }
        else{
            return $this->logic_tools->ret_arr(-1,"分类异常请手动输入"."异常行的料号为【".$sku."】");
        }
        $list['category'] = $cate; //类目
        if(isset($sku_list[22])){
            $list['hairtype'] = $sku_list[22]['id']; //真人发类型
        }
        if(isset($sku_list[13])){
            $list['grade'] = $sku_list[13]['id'];//等级
        }
        if(isset($sku_list[14])){
            $list['size'] = $sku_list[14]['id'];//长度
        }
        if(isset($sku_list[43])){
            $list['hairnumber'] =  $sku_list[43]['id'];//人发头套编号
        }
        
        if(isset($sku_list[33])){
            $list['extension'] = $sku_list[33]['id'];//Extension类型
        }

        if( $cate == 1297)
        {   
            if(isset($sku_list[40])){
                $list['sywignumber'] = $sku_list[40]['id'];//化纤头套编号
            }
        }
        if( $cate == 1702)
        {
            if(isset($sku_list[47])){
                $list['syhairnumber'] = $sku_list[47]['id'];//化纤发编号
            }
            if(isset($sku_list[46])){
                $list['syother'] = $sku_list[46]['id'];//化纤其它分类
            }
        }
        if($cate == 133)
        {
            if(isset($sku_list[35])){
                $list['fittype'] = $sku_list[35]['id'];//配件类型
            }
            if(isset($sku_list[45])){
                $list['acother'] = $sku_list[45]['id'];//配件其他
            }
           
        }
        if(isset($sku_list[8])){
            $list['color'] = $sku_list[8]['id'];//头发颜色
        }
        if(isset($sku_list[15])){
            $list['lowe'] = $sku_list[15]['id'];//曲 度
        }
        if($cate == 127)
        {
            if(isset($sku_list[27])){
                $list['type'] = $sku_list[27]['id']; //类 型
            }
            if(isset($sku_list[12])){
                $list['headroad'] = $sku_list[12]['id']; //头路设计
            }
            if(isset($sku_list[10])){
                $list['density'] = $sku_list[10]['id']; //密 度
            }
            if($list['type'] == 195 || $list['type'] == 197 || $list['type'] == 199)
            {
                //蕾丝尺寸
                if(isset($sku_list[25])){
                    $list['lacesize'] = $sku_list[25]['id'];
                }
                if(isset($sku_list[26])){
                    $list['lacesize'] = $sku_list[26]['id'];
                }
                
            }
            if(isset($sku_list[9])){
                $list['lacecolor'] = $sku_list[9]['id'];//蕾丝颜色
            }
            if(isset($sku_list[44])){
                $list['lacetypes'] = $sku_list[44]['id'];//蕾丝类型
            }
        }
        if($cate == 128)
        {
            if(isset($sku_list[18])){
                $list['lacetype'] = $sku_list[18]['id'];//头套种类
            }
            if(isset($sku_list[6])){
                $list['haircap'] = $sku_list[6]['id'];//发帽大小
            }
            if(isset($sku_list[10])){
                $list['density'] = $sku_list[10]['id'];//密 度
            }
            if(isset($sku_list[9])){
                $list['lacecolor'] = $sku_list[9]['id'];//蕾丝颜色
            }
            if(isset($sku_list[44])){
                $list['lacetypes'] = $sku_list[44]['id'];//蕾丝类型
            }
            if(isset($sku_list[39])){
                $list['wigother'] = $sku_list[39]['id'];//头套其它
            }
            if(isset($sku_list[50])){
                $list['wigother1'] = $sku_list[50]['id'];//头套其它
            }
            if(isset($sku_list[51])){
                $list['wigother2'] = $sku_list[51]['id'];//头套其它2
            }
            if(isset($sku_list[53])){
                $list['product_related'] = $sku_list[53]['id'];//头套其它2
            }
        }
        //现在没有129这个分类了
        // if($category == 129)
        // {
        //     if(isset($sku_list[50])){
        //         $list['wide'] = $sku_list[50]['id'];
        //     }
        // }
       
        if($cate == 131)
        {
            if(isset($sku_list[34])){
                $list['gifttype'] = $sku_list[34]['id'];//Gift类型
            }
            if(isset($sku_list[49])){
                $list['giftother'] = $sku_list[49]['id'];//Gift其它
            }
        }
        //没有134这一项了
        // if($category == 134)
        // {
        //     if(isset($sku_list[49])){
        //         $list['giftother'] = $sku_list[49]['id'];
        //     }
        //     $list['pieceweight'] = $this->input->post('pieceweight',true);
        // }
        if($cate == 1297)
        {
            if(isset($sku_list[41])){
                $list['synthetictype'] = $sku_list[41]['id'];//头套类型
            }
            if(isset($sku_list[42])){
                $list['sywigother'] = $sku_list[42]['id'];//化纤头套其它
            }
            
        }
        if($cate == 130 || $cate == 133 || $cate == 1702)
        {
            if(isset($sku_list[38])){
                $list['items'] = $sku_list[38]['id'];//单包片数
            }
            if(isset($sku_list[7])){
                $list['weight'] = $sku_list[7]['id'];//重 量
            }
        }
        if($cate == 130){
            $list['jfother'] = $sku_list[52]['id'];
        }
        if($cate == 1702)
        {
            if(isset($sku_list[48])){
                $list['syhairther'] = $sku_list[48]['id'];//化纤发其它
            }
        }
        $pm = $classid;
        $jm = $classid;
        $sku = [];
        $title = '';$features = '';$cs = array();
        $bmpx = array(13=>'',16=>'',18=>'',25=>'',26=>'',41=>'');
      
        foreach($list as $k=>$v)
        {
            if(isset($typeclassid[$v]) && isset($bmpx[$typeclassid[$v]['classid']]))
            {
                if($typeclassid[$v]['bm'] != '')
                {
                    $bmpx[$typeclassid[$v]['classid']] = $typeclassid[$v]['bm'];
                }
            }
            if($v != 0)
            {
                if($k != 'size')
                {
                    $title .= $typeclassid[$v]['title']." ";
                }
                $features .=$v.'-';
                $sku[$typeclassid[$v]['classid']] = empty($typeclassid[$v]['bqsku'])?"":$typeclassid[$v]['bqsku'];
                if(isset($pm[$typeclassid[$v]['classid']]))
                {
                    if($typeclassid[$v]['title'] == '9A')
                    {
                        $pm[$typeclassid[$v]['classid']] = '9A';
                    }
                    else if($typeclassid[$v]['title'] == '10A')
                    {
                        $pm[$typeclassid[$v]['classid']] = '10A';
                    }
                    else
                    {
                        $clzh = $typeclassid[$v]['zh'];
                        if(stripos($typeclassid[$v]['zh'],'|') !== false)
                        {
                            $clzh = explode('|',rtrim($typeclassid[$v]['zh'],'|'));
                            $clzh = $clzh[0];
                        }
                        $pm[$typeclassid[$v]['classid']] = $clzh;
                    }
                }
                if(isset($jm[$typeclassid[$v]['classid']]))
                {
                    if($typeclassid[$v]['jm'])
                    {
                        $jm[$typeclassid[$v]['classid']] = $typeclassid[$v]['jm'];
                    }
                }
            }
        }
        $jm = array_filter($jm);//去除空值
        $jm = implode("-",$jm);
        $sku = array_filter($sku);//去除空值
        $sku = implode("-",$sku);
        $pm = array_filter($pm);//去除空值
        $pm = implode(" ",$pm);
        $pm = preg_replace("/\r\n|\r|\n/",'',trim($pm,' '));
        if($list['size'])
        {
            $typeclass = $this->typeclass->read($list['size']);
            $title .= $typeclass['title'];
        }
        $title = trim($title,' ');
        
        $post['num'] = $this->input->post('num',true);
        $ztime = $this->input->post('ztime',true);
        $post['ztime'] = strtotime($ztime);
        $post['bm'] = '03'.implode("",$bmpx);
        $post['jm'] = $jm;
        $post['sku'] = $sku;
        $post['pm'] = $pm;
        $post['title'] = $title;
        $post['features'] = '-'.$features;
        $post['number'] = date('YmdHis',time()).rand(100,999);
        if(!$post['num'])
        {
            $post['number'] = date("YmdHis").rand(100,999);
        }
        $time = time();
        $post['time'] = $time;//操作时间
        $post['printnum'] = $time;
        $post['type'] = 0;
        return $this->logic_tools->ret_arr(1,"ok",$post);
    }
    //获取erp转化u9需要classid和typeclassid
    public function getClass(){
        $classid = $this->classid->sku();
        return $classid;
       
    }
    public function getTypeClass(){
        $typeclass = [];
        $tcall = $this->typeclass->find_all();
        foreach ($tcall as $v)
        {
            //$tcjm[$v['id']] = array($v['jm'],$v['classid']);
            $typeclass[$v['id']] = array('zh'=>$v['zh'],'classid'=>$v['classid'],'bm'=>$v['bm'],'title'=>$v['title'],'jm'=>$v['jm']);
        }
        return $typeclass;
    }
    //只针对创建u9料号 不牵扯到erp的sku组合
    public function getU9Lp(){

    }


    //判断长度 需要插到第几位
    public function checkLengthLocal($value){
        if(strpos($value,'-2090-') !== false){
            //网红
            return 3;
        }
        if(strpos($value,'-2469-') !== false){
            //本当
            return 3;
        }
        if(strpos($value,'-1620-') !== false){
            //清仓
            return 3;
        }
        if(strpos($value,'-2480-') !== false){
            //T2
            return 3;
        }
        if(strpos($value,'-2526-') !== false){
            //AMZ
            return 3;
        }
        if(strpos($value,'-2964-') !== false){
            //越南发
            return 3;
        }
        return 2;  
    }

    //转化fpdata的信息
    public function transferFpdata($fpdata_str){
        $ret_arr = [];
        $fpdata = explode(';',rtrim($fpdata_str,';'));
        foreach ($fpdata as $k=>$v) 
        {
            $ret_arr[] = $this->getGoodFeatures($v);
        }
        return $ret_arr;
    }

    public function getGoodFeatures($str){
        $tmp_arr = explode('|',trim($str,'|'));
    
        if(strpos($tmp_arr[0],',') !== false){
            $tmp_arr_one = explode(',',trim($tmp_arr[0],','));
            $tmp_arr_two = explode('-',trim($tmp_arr_one[1],'-'));
            $len_local = $this->checkLengthLocal($tmp_arr[0]);
            $f_arr = [];
            foreach($tmp_arr_two as $kk=>$vv){
                if($kk == 1){
                    if($len_local == 3){
                        $f_arr[] = $vv;
                    }else{
                        $f_arr[] = $vv.'-'.$tmp_arr_one[0];
                    }
                }else if($kk == 2){
                    if($len_local == 3){
                        $f_arr[] = $vv.'-'.$tmp_arr_one[0];
                    }else{
                        $f_arr[] = $vv;
                    }
                }else{
                    $f_arr[] = $vv;
                }
               
            }
            $tmp_arr[0] = "-".implode('-',$f_arr)."-";
        }
        return $tmp_arr;
    }

    public function getGoodFeatureAlone($str){
        $str = str_replace(array('-163-','-164-','-165-','-166-'),'-',$str);
        if(strpos($str,',') !== false){
            $tmp_arr_one = explode(',',trim($str,','));
            $tmp_arr_two = explode('-',trim($tmp_arr_one[1],'-'));
            $len_local = $this->checkLengthLocal($str);
            $f_arr = [];
            foreach($tmp_arr_two as $kk=>$vv){
                if($kk == 1){
                    if($len_local == 3){
                        $f_arr[] = $vv;
                    }else{
                        $f_arr[] = $vv.'-'.$tmp_arr_one[0];
                    }
                }else if($kk == 2){
                    if($len_local == 3){
                        $f_arr[] = $vv.'-'.$tmp_arr_one[0];
                    }else{
                        $f_arr[] = $vv;
                    }
                }else{
                    $f_arr[] = $vv;
                }
               
            }
            return  "-".implode('-',$f_arr)."-";
        }else{
            return $str;
        }
    }

    //通过U9料号 获取ERP的sku
    public function getErpSkuByU9Lp($lp){
        $u9_list = $this->typeclass->find_all(" classid != 36 AND jm IS NOT NULL AND jm != '' ");
       
        $token = $this->settingtest->get_yytoken_130();
		$r = $this->apiyyv1->cxLpByJm($lp,$token);
        if(empty($r['Data'])){
            return [
                "code"=>-1,
                "msg"=>"U9查询不到此料号-1",
                "data"=>""
            ];
        }
        if(empty($r['Data'][0])){
            return [
                "code"=>-1,
                "msg"=>"U9查询不到此料号-2",
                "data"=>""
            ];
        }
        if(empty($r['Data'][0]['m_stockCategory'])){
            return [
                "code"=>-1,
                "msg"=>"U9查询不到此料号-3",
                "data"=>""
            ];
        }
        if(empty($r['Data'][0]['m_stockCategory']['m_code'])){
            return [
                "code"=>-1,
                "msg"=>"U9查询不到此料号-4",
                "data"=>""
            ];
        }
        $cate_code = $r['Data'][0]['m_stockCategory']['m_code'];
        $r = $this->transferU9Cate($cate_code);
        if($r['code'] == -1){
            return $r;
        }
        $fianl_list = [];
        foreach($u9_list as $k=>$v){
            $tmp_jm = strtolower($v['jm']);
            $fianl_list[$tmp_jm] = $v;
        }

        $lp = strtolower($lp);
        
        $lp_arr = explode('-',trim($lp,'-'));

        $ff_arr = [];
        $ff_arr[] = $this->typeclass->read($r["cate"]);
        
        foreach($lp_arr as $k=>$v){
            if(isset($fianl_list[$v])){
                $ff_arr[] = $fianl_list[$v];
            }
        }
        $tmp_arr = array_column($ff_arr,'id');
        return [
            "code"=>1,
            "msg"=>"success",
            "data"=>"-".implode('-',$tmp_arr)."-"
        ];
    }


    public function transferU9Cate($cate_code){
        $one_str = substr($cate_code,0,2);
        $two_str = substr($cate_code,2,2);
        $three_str = substr($cate_code,4,2);
        $four_str = substr($cate_code,6,2);
        if($one_str != '03'){
            return [
                "code"=>-1,
                "msg"=>"此方法只支持u9成品分类"
            ];
        }
        if(!in_array($two_str,['01','02','03','04','05','06','07','08','09','10','11','12'])){
            return [
                "code"=>-1,
                "msg"=>$cate_code."的分类不在配置中,请联系技术"
            ];
        }
        if($three_str == '01'){
            //真人发
            if($four_str == '01'){
                //发条
                return [
                    "code"=>1,
                    "msg"=>"success",
                    "cate"=>"126",
                    'title'=>"发条"    
                ];
            }elseif($four_str == '02'){
                //发块
                return [
                    "code"=>1,
                    "msg"=>"success",
                    "cate"=>"127",
                    "title"=>"发块"
                ];

            }elseif($four_str == '03'){
                //头套
                return [
                    "code"=>1,
                    "msg"=>"success",
                    "cate"=>"128",
                    "title"=>"头套"
                ];
            }elseif($four_str == '04'){
                //接发
                return [
                    "code"=>1,
                    "msg"=>"success",
                    "cate"=>"130",
                    "title"=>"接发"
                ];
            }else{
                //配件
                return [
                    "code"=>1,
                    "msg"=>"success",
                    "cate"=>"133",
                    "title"=>"配件"
                ];
            }
           
        }else if($three_str == '02'){
            //化纤发
            if($four_str == '01'){
                return [
                    "code"=>1,
                    "msg"=>"success",
                    'cate'=>'1297',
                    "title"=>"化纤头套"
                ];
            }else{
                return [
                    "code"=>1,
                    "msg"=>"success",
                    'cate'=>'1702',
                    "title"=>"化纤其它"
                ];
            }
        }
        return [
            "code"=>-1,
            "msg"=>"数据异常，联系技术"
        ];

    }
}