C:\phpStudy\PHPTutorial\WWW\www.localcx.com\tenghoo\Spec\post.php

case 'delSpecVal':
        $id = intval($_POST['id']);
        if (db()->where('id', $id)->delete('spec_val')) {
            $child = db()->where('pid', $id)->get('spec_val');
            foreach ($child as $v) {
                $sql = "DELETE FROM `".DB_PRE."spec_result_product` WHERE `spec_result_id` REGEXP '^{$v['id']}-' OR `spec_result_id` REGEXP '-{$v['id']}-' OR `spec_result_id` REGEXP '-{$v['id']}$' or `spec_result_id`='{$v['id']}'";
                $item = $db->sql_delete($sql);
            }
            $sql = "DELETE FROM `".DB_PRE."spec_result_product` WHERE `spec_result_id` REGEXP '^{$id}-' OR `spec_result_id` REGEXP '-{$id}-' OR `spec_result_id` REGEXP '-{$id}$' or `spec_result_id`='{$id}'";
            $item = $db->sql_delete($sql);
            showmsg('刪除成功', $_SERVER['HTTP_REFERER']);
        } else {
            showmsg('刪除成功');
        }
        break;

Cate\article_edit.php
    $(".spec-list").each(function (i,n) {
        var flag = true;
        var id  = $(n).attr("data-spec-id");
        $("em[data-spec-id="+id+"]").each(function () {
            if ($(this).hasClass('on')) {

            } else {
                flag = false;
            }
        });
        if (flag) {
            $("#checked-"+id).attr("checked",'true');
        }
    });

function selectAllItem(o,id){
    // alert(o.checked);
    if(o.checked){
        $("em[data-spec-id="+id+"]").each(function () {
            if ($(this).hasClass('on')) {

            } else {
                var data_id = $(this).attr('data-id');
                $("em[data-id="+data_id+"]").click();
            }
        });
    } else {
        $("em[data-spec-id="+id+"]").each(function () {
            var data_id = $(this).attr('data-id');
            if ($(this).hasClass('on')) {
                
                $("em[data-id="+data_id+"]").click();
            } else {

            }
        });
        $("em[data-spec-id="+id+"]").each(function () {
            var data_id = $(this).attr('data-id');
            if ($(this).hasClass('on')) {
                
                $("em[data-id="+data_id+"]").click();
            } else {

            }
        });
    }
}

myphp

<?php
require_once __DIR__.'/../../include/common.inc.php';

echo "<pre>";
// 獲取新增的屬性
$specAddArr = db()->get('spec_add_desc');


$product_id = 31;
$info = db()->where('id', $product_id)->getOne('product');
// 地址屬性  地址性質(zhì)  食品證  配合銀行看場地
$spec = db()->where('category_id', $info['category_id'])->orderBy('id', 'asc')->get('spec');

// 1、獲取當(dāng)前 category_id 下所有的 spec ，包括子類
$ori_arr = [];
$specIdArr = [];
foreach ($spec as $k=>$v) {
    // $val = db()->where('spec_id', $v['id'])->where('pid', 0)->orderBy('id', 'asc')->get('spec_val');
    $val = db()->where('spec_id', $v['id'])->orderBy('id', 'asc')->get('spec_val');
    // if ($level == 1) {
    //  foreach ($val as $k1=>$v1) {
    //      $val[$k1]['val'] = db()->where('spec_id', $v['id'])->where('pid', $v1['id'])->orderBy('id', 'asc')->get('spec_val');
    //  }
    // }
    $ori_arr[] = array_column($val, 'id');
    $specIdArr[] = $v['id'];
}

// print_r($ori_arr);
// print_r($specIdArr);
$ori_arr_bak = $ori_arr;

foreach ($specAddArr as $kkey => $vvalue) {
    $key = array_search($vvalue['spec_id'], $specIdArr);
    $kkey = array_search($vvalue['spec_val_id'], $ori_arr[$key]);
    unset($ori_arr[$key][$kkey]);
}
// print_r($ori_arr);
// die();

$res = db()->where('product_id', $info['id'])->getValue('spec_result_product', 'spec_result_id', null);
foreach ($res as $key => $value) {
    $res[$key] = explode('-', $value);
}
$currentProduct = [];
for ($i=0; $i < count($res[0]); $i++) {
    $curArr = array_unique(array_column($res, $i));
    sort($curArr);
    $currentProduct[] = $curArr;
}
// print_r($currentProduct);
foreach ($currentProduct as $_k => $_v) {
    if (count($currentProduct[$_k]) == count($ori_arr[$_k])) {
        $currentProduct[$_k] = $ori_arr_bak[$_k];
    }
}

// print_r($currentProduct);


$currentProduct = fun($currentProduct);
// print_r($currentProduct);

// 先刪除所有的舊的數(shù)據(jù)，再重新插入
db()->where('product_id', $id)->delete('spec_result_product');
foreach ($currentProduct as $vv) {
    db()->insert('spec_result_product', ['spec_result_id'=>implode('-', $vv), 'product_id'=>$info['id'], 'category_id'=>$info['category_id']]);
}

db()->delete('spec_add_desc');
die();


die();
$resId = [];
foreach ($res as $k=>$v) {
    $item = explode('-', $v);
    foreach ($item as $i) {
        //判斷是否有子類
        if (!db()->where('pid', $i)->getValue('spec_val', 'id')) {
            if (!in_array($i, $resId)) {
                $resId[] = $i;
            }
        }
    }
}

print_r(array_unique($resId));

<?php
require_once __DIR__.'/../../include/common.inc.php';

// 獲取新增的屬性
$specAddArr = db()->get('spec_add_desc');


$product_id = 31;
// 1、獲取當(dāng)前商品的信息
$info = db()->where('id', $product_id)->getOne('product');
// 2、獲取該商品所屬類目的產(chǎn)品規(guī)格（格地址屬性、地址性質(zhì)、食品證、配合銀行看場地）
$spec = db()->where('category_id', $info['category_id'])->orderBy('id', 'asc')->get('spec');

// 3、獲取當(dāng)前 類目 下所有的 spec ，包括子類
$ori_arr = [];
$specIdArr = [];
foreach ($spec as $k=>$v) {
    $val = db()->where('spec_id', $v['id'])->orderBy('id', 'asc')->get('spec_val');
    $ori_arr[] = array_column($val, 'id');
    $specIdArr[] = $v['id'];
}

// 4、備份所有spec
$ori_arr_bak = $ori_arr;

// 5、剔除新增的產(chǎn)品規(guī)格屬性，作為判斷在產(chǎn)品規(guī)格新增前該商品是否有全選的產(chǎn)品規(guī)格
foreach ($specAddArr as $kkey => $vvalue) {
    $key = array_search($vvalue['spec_id'], $specIdArr);
    $kkey = array_search($vvalue['spec_val_id'], $ori_arr[$key]);
    unset($ori_arr[$key][$kkey]);
}

// 6、獲取當(dāng)前商品所有的產(chǎn)品規(guī)格屬性
$res = db()->where('product_id', $info['id'])->getValue('spec_result_product', 'spec_result_id', null);
foreach ($res as $key => $value) {
    $res[$key] = explode('-', $value);
}
// 7、當(dāng)前商品所有的產(chǎn)品規(guī)格屬性數(shù)據(jù)格式化
$currentProduct = [];
for ($i=0; $i < count($res[0]); $i++) {
    $curArr = array_unique(array_column($res, $i));
    sort($curArr);
    $currentProduct[] = $curArr;
}

// 8、判斷該商品下哪些產(chǎn)品規(guī)格是“全選的”，將新增的產(chǎn)品規(guī)格也添加進去
foreach ($currentProduct as $_k => $_v) {
    if (count($currentProduct[$_k]) == count($ori_arr[$_k])) {
        $currentProduct[$_k] = $ori_arr_bak[$_k];
    }
}

// 9、笛卡爾積
$currentProduct = fun($currentProduct);

// 10、先刪除所有的舊的數(shù)據(jù)，再重新插入
db()->where('product_id', $id)->delete('spec_result_product');
foreach ($currentProduct as $vv) {
    db()->insert('spec_result_product', ['spec_result_id'=>implode('-', $vv), 'product_id'=>$info['id'], 'category_id'=>$info['category_id']]);
}

db()->delete('spec_add_desc');
die();

<?php
require_once __DIR__.'/../../include/common.inc.php';
echo "<pre>";
// 獲取新增的屬性
$specAddArr = db()->orderBy('id', 'asc')->getOne('spec_add_desc');
if (empty($specAddArr)) {
    echo "沒有新增數(shù)據(jù)";die();
}


// 1、遍歷所有商品的信息
$infoArr = db()->get('product');

foreach ($infoArr as $info) {
    // 2、獲取該商品所屬類目的產(chǎn)品規(guī)格（格地址屬性、地址性質(zhì)、食品證、配合銀行看場地）
    $spec = db()->where('category_id', $info['category_id'])->orderBy('id', 'asc')->get('spec');
    // 3、獲取當(dāng)前 類目 下所有的 spec ，包括子類
    $ori_arr = [];
    $specIdArr = [];
    foreach ($spec as $k=>$v) {
        $val = db()->where('spec_id', $v['id'])->orderBy('id', 'asc')->get('spec_val');
        $ori_arr[] = array_column($val, 'id');
        $specIdArr[] = $v['id'];
    }

    // 4、備份所有spec
    $ori_arr_bak = $ori_arr;

    // 5、剔除新增的產(chǎn)品規(guī)格屬性，作為判斷在產(chǎn)品規(guī)格新增前該商品是否有全選的產(chǎn)品規(guī)格
    $key = array_search($specAddArr['spec_id'], $specIdArr);
    $kkey = array_search($specAddArr['spec_val_id'], $ori_arr[$key]);
    unset($ori_arr[$key][$kkey]);


    // 6、獲取當(dāng)前商品所有的產(chǎn)品規(guī)格屬性
    $res = db()->where('product_id', $info['id'])->getValue('spec_result_product', 'spec_result_id', null);
    foreach ($res as $key => $value) {
        $res[$key] = explode('-', $value);
    }
    // 7、當(dāng)前商品所有的產(chǎn)品規(guī)格屬性數(shù)據(jù)格式化
    $currentProduct = [];
    for ($i=0; $i < count($res[0]); $i++) {
        $curArr = array_unique(array_column($res, $i));
        sort($curArr);
        $currentProduct[] = $curArr;
    }
    // 8、判斷該商品下哪些產(chǎn)品規(guī)格是“全選的”，將新增的產(chǎn)品規(guī)格也添加進去
    $flag = false;
    foreach ($currentProduct as $_k => $_v) {
        if (count($currentProduct[$_k]) == count($ori_arr[$_k])) {
            $flag = true;
            $currentProduct[$_k] = $ori_arr_bak[$_k];
        }
    }

    
    if ($flag) {
        // 9、笛卡爾積
        $currentProduct = fun($currentProduct);

        // 10、先刪除所有的舊的數(shù)據(jù)，再重新插入
        db()->where('product_id', $id)->delete('spec_result_product');
        foreach ($currentProduct as $vv) {
            db()->insert('spec_result_product', ['spec_result_id'=>implode('-', $vv), 'product_id'=>$info['id'], 'category_id'=>$info['category_id']]);
        }
        echo "修改了".var_export($info,true);
    } else {
        echo "沒有需要更改的內(nèi)容<br/>";
    }

    db()->where('id', $specAddArr['id'])->delete('spec_add_desc');
    
}

die();