$new_color_str = str_replace($old_color, $new_color, $color_str);
$productMgr->updateColor($product_id, $new_color_str);
$productMgr->updateColorInOptionalCodeTable($product_id, $new_color, $old_color);
$photoMgr->updateColorInPhotoTable($product_id, $new_color, $old_color);
$return = [];
$return['status'] = 'success';
echo json_encode($return);
} elseif ($operation === "updateColorSymbolCode") {
$product_id = addslashes(filter_input(INPUT_POST, 'product_id'));
$color = addslashes(filter_input(INPUT_POST, 'color'));
$symbol_code = addslashes(filter_input(INPUT_POST, 'symbol_code'));
$productMgr->updateProductColorOptionalCode($product_id, $color, $symbol_code);
$return = [];
$return['status'] = 'success';
echo json_encode($return);
} elseif ($operation === "deleteProduct") {
$productIdList_str = filter_input(INPUT_POST, 'productIdList');
$productIdList = explode(",", $productIdList_str);
foreach ($productIdList as $id) {
$count = $orderMgr->checkProductPendingOrderStatus($id);
if ($count === 0) {
$productMgr->deleteProduct($id);
//delete from product table
$photoMgr->deleteAllPhotosByProduct($id);
//delete from photo table
$productMgr->deleteAllColorOptionalCodeByProduct($id);
//delete from optional_code table
}
}
header("Location: admin.php#viewProduct");
}