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');
// 地址属性 地址性质 食品证 配合银行看场地
$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);
// 先删除所有的旧的数据，再重新插入
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、获取该商品所属类目的产品规格（格地址属性、地址性质、食品证、配合银行看场地）
$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、剔除新增的产品规格属性，作为判断在产品规格新增前该商品是否有全选的产品规格
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、获取当前商品所有的产品规格属性
$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、当前商品所有的产品规格属性数据格式化
$currentProduct = [];
for ($i=0; $i < count($res[0]); $i++) {
$curArr = array_unique(array_column($res, $i));
sort($curArr);
$currentProduct[] = $curArr;
}
// 8、判断该商品下哪些产品规格是“全选的”，将新增的产品规格也添加进去
foreach ($currentProduct as $_k => $_v) {
if (count($currentProduct[$_k]) == count($ori_arr[$_k])) {
$currentProduct[$_k] = $ori_arr_bak[$_k];
}
}
// 9、笛卡尔积
$currentProduct = fun($currentProduct);
// 10、先删除所有的旧的数据，再重新插入
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 "没有新增数据";die();
}
// 1、遍历所有商品的信息
$infoArr = db()->get('product');
foreach ($infoArr as $info) {
// 2、获取该商品所属类目的产品规格（格地址属性、地址性质、食品证、配合银行看场地）
$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、剔除新增的产品规格属性，作为判断在产品规格新增前该商品是否有全选的产品规格
$key = array_search($specAddArr['spec_id'], $specIdArr);
$kkey = array_search($specAddArr['spec_val_id'], $ori_arr[$key]);
unset($ori_arr[$key][$kkey]);
// 6、获取当前商品所有的产品规格属性
$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、当前商品所有的产品规格属性数据格式化
$currentProduct = [];
for ($i=0; $i < count($res[0]); $i++) {
$curArr = array_unique(array_column($res, $i));
sort($curArr);
$currentProduct[] = $curArr;
}
// 8、判断该商品下哪些产品规格是“全选的”，将新增的产品规格也添加进去
$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、先删除所有的旧的数据，再重新插入
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 "没有需要更改的内容<br/>";
}
db()->where('id', $specAddArr['id'])->delete('spec_add_desc');
}
die();
