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堂竟、獲取當前 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跃捣、獲取當前商品的信息
$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刁赦、獲取當前 類目 下所有的 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、獲取當前商品所有的產(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牺氨、當前商品所有的產(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土至、獲取當前 類目 下所有的 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毡庆、獲取當前商品所有的產(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坑赡、當前商品所有的產(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();
