";
    echo "rows";
    //print_r($rows);
    //exit;
    if(!empty($rows)){
        foreach ($rows as $k=>$row){
            checkhs($row);
            //exit;
        }
    }
}
/**
 * is_check 为2表示不存在编码可以直接假如，
 * is_check 为8表示经过法一，法二以及海关编码校验
 *
 */
function checkproductandbill(){
    $sql = "SELECT * FROM `hs_2023up` where ( (uom1_msg!='1') or (uom2_msg!='1') or (hselement_msg!='2')) ;";
    echo $sql;
    //exit;
    $db = Common_Common::getAdapter();
    $rows = $db->fetchAll($sql);
    echo "
";
    echo "rows";
    //print_r($rows);
    //exit;
    if(!empty($rows)){
        foreach ($rows as $k=>$row){
            checkproductbill($row);
            //exit;
        }
    }
}

//execheck();
//checkproductandbill();

//更新uom
function upHsuom($row){
    try {
        $db = Common_Common::getAdapter();
        $db->beginTransaction();

        $hs_code = $row['hs_code'];
        $hs_name = $row['hs_name'];
        $first_uom = $row['first_uom'];
        $second_uom = $row['second_uom'];
        $sbys = $row['sbys'];

        $first_uom_code = '';
        $second_uom_code = '';

        $uom1_msg = ""; //法一消息
        $uom2_msg = ""; //法二消息
        $hs_name_msg = ""; //海关名称
        $hselement_msg = ""; //申报要素名称校验消息


        $error=[];
        $firuomRow = Service_ProductUom::getByField($first_uom,'pu_name');
        if(!empty($firuomRow)){
            $first_uom_code = $firuomRow['pu_code'];
        }
        if($second_uom=='无'){
            $second_uom_code = "";
        }else {
            $secondRow = Service_ProductUom::getByField($second_uom, 'pu_name');
            if(!empty($secondRow)){
                $second_uom_code = $secondRow['pu_code'];
            }
        }
        //没有商品备案
        if($row['product_msg']=='1'){
            $uomRow = array(
                'pu_code_law'=>$first_uom_code,
                'pu_code_second'=>$second_uom_code,
                'hu_update_time'=>date("Y-m-d H:i:s",time())
            );
            if(!Service_HsUom::update($uomRow,$hs_code,'hs_code')){
                throw new Exception("更新编码法一法二失败".$hs_code);
            }else{
                $db->update("hs_2023up",['deal_msg'=>'uomsuccess'],"id={$row['id']}");
            }
        }else{
            //有商品备案
            if($row['bill_msg']=='1'){
                //无账册情况下直接改

            }else{

            }
            $db->update("hs_2023up",['deal_msg'=>'uomfaise,有商品备案请打回草稿重新备案'],"id={$row['id']}");
        }
        //print_r($row);
        //$db->rollBack();
        //echo "0000";

        $db->commit();
    }catch (Exception $e){
        $r = $e->getMessage();
        $db->rollBack();
        echo $r;
        $sql = "update hs_2023up set deal_msg='{$r}' where id={$row['id']};";
        //echo $sql;
        $db->query($sql);
    }
}

//更新申报要素
function upHselement($row){
    try {
        $db = Common_Common::getAdapter();
        $db->beginTransaction();

        $hs_code = $row['hs_code'];
        $hs_name = $row['hs_name'];
        $first_uom = $row['first_uom'];
        $second_uom = $row['second_uom'];
        $sbys = $row['sbys'];

        $error = [];

        $updateRow = [];

        $sbysArr = explode(";",$sbys);
        if(count($sbysArr)>1){
            $hsArr = [];
            foreach ($sbysArr as $k=>$ge){
                $geArr = explode(":",$ge);
                $index = $geArr[0]-1;
                $hsname = $geArr[1];
                if(count($geArr)!=2){
                    $error[] = "申报要素{$ge}不对";
                    $hselement_msg.="申报要素{$ge}不对|";
                }
                $hsArr[] = array(
                    'index'=>$index,
                    'name'=>$hsname
                );
            }
        }
        if (empty($error)){
            //没有备案商品
            if($row['product_msg']=='1'){
                //申报要素不一样，删除重建
                if($row['hselement_msg']!='2'){
                    //删除重建
                    if(!Service_HsElement::delete($hs_code,"hs_code")){
                        throw new Exception("删除编码申报要素错误：".$hs_code);
                    }else{
                        if(!updetail($hs_code,$hsArr)){
                            throw new Exception("添加编码申报要素错误：".$hs_code);
                        }else{
                            $updateRow['deal_msg'] = "success";
                        }
                    }
                }
            }else{
                //有备案商品
                $updateRow['deal_msg'] = "需人工核查";
            }
        }
        if(!empty($updateRow)){
            $db->update("hs_2023up",$updateRow,"id={$row['id']}");
            $db->commit();
        }else{
            throw new Exception("未发现更新".$hs_code);
        }

        print_r($updateRow);
        //SELECT * FROM `hs_2023up` where ( (uom1_msg='1') and (uom2_msg='1') )  and hselement_msg!='2' and deal_msg is null
        //$db->rollBack();

        echo "999";

    }catch (Exception $e){
        $r = $e->getMessage();
        $db->rollBack();

        $sql = "update hs_2023up set deal_msg='{$r}' where id={$row['id']};";
        //echo $sql;
        $db->query($sql);
    }
}

function fixhscode1(){
    //SELECT * FROM `hs_2023up` where ( (uom1_msg!='1') or (uom2_msg!='1') or (hselement_msg!='2')) and product_msg!='1'
    //1）法一 法二不一样情况下（申报要素一样） 1-3）无商品备案（更改法一 法二数据，写日志）
    $sqlsamefayifaer = "SELECT * FROM `hs_2023up` where ( (uom1_msg!='1') or (uom2_msg!='1') ) and  product_msg='1' and hselement_msg='2' and deal_msg is null";
    $db = Common_Common::getAdapter();
    $rows = $db->fetchAll($sqlsamefayifaer);
    if(!empty($rows)){
        foreach ($rows as $k=>$row){
            //upHsuom($row);
        }
    }

    //法一 法二不一样情况下（申报要素也不一样）
    $sqlsamefayifaer_elementnoteq = "SELECT * FROM `hs_2023up` where ( (uom1_msg!='1') or (uom2_msg!='1') ) and  product_msg='1' and hselement_msg!='2' and deal_msg is null";
    $rows = $db->fetchAll($sqlsamefayifaer_elementnoteq);
    //echo count($rows);
    if(!empty($rows)){
        foreach ($rows as $k=>$row){
           /* upHsuom($row); //更新法一
            upHselement($row);//更新申报要素*/
        }
    }
    //法一法二一样，申报要素不一样。
    $sqlelementNoteq = "SELECT * FROM `hs_2023up` where ( (uom1_msg='1') and (uom2_msg='1') )  and hselement_msg!='2' and deal_msg is null";
    $rows = $db->fetchAll($sqlelementNoteq);
    echo count($rows);
    //exit;
    if(!empty($rows)){
        foreach ($rows as $k=>$row){
            print_r($row);
            upHselement($row); //更新申报要素
            //exit;
        }
    }
    exit;
    //旧编码不存在的，直接增加
    $sqlhsnotexist = "SELECT * FROM `hs_2023up` where 1  and is_check='2' and  deal_msg is null;";
    $rows = $db->fetchAll($sqlhsnotexist);
    if(!empty($rows)){
        foreach ($rows as $k=>$row){
            //print_r($row);
            //upHsuom($row); //更新法一
            addhs2023($row);
            //exit;
        }
    }
}

fixhscode1();