$price = $parameters->getValue('newPrice');
$stock = $parameters->getValue('newStock');
$rows = $pm->updateProduct($sku, $pname, $pdesc, $price, $stock);
echo json_encode($rows);
} else {
if ($action == 'add') {
$pname = $parameters->getValue('productName');
$pdesc = $parameters->getValue('productDesc');
$price = $parameters->getValue('productPrice');
$stock = $parameters->getValue('productStock');
$rows = $pm->addProduct($pname, $pdesc, $price, $stock);
echo json_encode($rows);
} else {
if ($action == 'delete') {
$sku = $parameters->getValue('sku');
$pm->deleteProduct($sku);
echo json_encode(array('deleted item' => $sku));
} else {
if ($action == 'menu') {
$rows = $pm->listProducts();
$html = '';
foreach ($rows as $row) {
$sku = $row['sku'];
$pname = $row['product_name'];
$price = $row['product_price'];
$desc = $row['description'];
$stock = $row['stock'];
// <div class='menu'>
$html .= "\n\n <div class='row'>\n\n <div class='col-sm-8'>\n <p class='menu-title' data-sku-name='{$sku}'>{$pname}</p>\n <div data-sku-desc='{$sku}' class='menu-detail'>{$desc}</div>\n </div>\n <div class='col-sm-4 menu-price-detail'>\n \$<span class='menu-price' data-sku-price='{$sku}'>{$price}</span>\n\n\n <input type='button' h4 class='menu-price add' id='add' data-pname = '{$pname}' data-price = '{$price}' data-sku-add = '{$sku}' data-stock = '{$stock}' value='+ add to cart'/>\n </div>\n </div>\n ";
}
echo $html;
$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");
}
