public function deleteByField($field, $value = null)
{
if (is_array($field)) {
$items = $this->getByField($field, $this->id);
} else {
$items = $this->getByField($field, $value, $this->id);
}
$res = false;
if ($ids = array_keys($items)) {
$res = parent::deleteByField($this->id, $ids);
if ($res) {
$type_upselling_model = new shopTypeUpsellingModel();
$type_upselling_model->deleteByField('feature_id', $ids);
$params_model = new shopProductFeaturesModel();
$params_model->deleteByField('feature_id', $ids);
$types = $this->groupByValueType($items);
foreach ($types as $type => $type_ids) {
if ($model = self::getValuesModel($type)) {
$model->deleteByField('feature_id', $type_ids);
}
}
$this->deleteByField('parent_id', $ids);
}
}
return $res;
}
/**
* @param int $id
* @param array $data
* @param bool $correct
* @param shopProduct $product
* @return array
*/
protected function updateSku($id = 0, $data, $correct = true, shopProduct $product = null)
{
/**
* @var shopProductStocksModel $stocks_model
*/
static $stocks_model;
/**
* @var bool $multi_stock
*/
static $multi_stock = null;
/**
* @var shopFeatureModel $feature_model
*/
static $feature_model;
/**
* @var shopProductFeaturesModel $product_features_model
*/
static $product_features_model;
if (isset($data['price'])) {
$data['price'] = $this->castValue('double', $data['price']);
}
if (isset($data['purchase_price'])) {
$data['purchase_price'] = $this->castValue('double', $data['purchase_price']);
}
if (isset($data['compare_price'])) {
$data['compare_price'] = $this->castValue('double', $data['compare_price']);
}
if ($id > 0) {
if ($product && (!isset($data['virtual']) || !empty($data['virtual']))) {
#check changes for virtual SKU
$virtual_sku_defaults = array('price' => $product->base_price_selectable, 'purchase_price' => $product->purchase_price_selectable, 'compare_price' => $product->compare_price_selectable, 'count' => 0);
$virtual = null;
foreach ($virtual_sku_defaults as $field => $default) {
if (isset($data[$field])) {
$value = $data[$field];
if (is_array($value)) {
$value = max($value);
}
if ($value != $default) {
if ($virtual === null) {
$virtual = isset($product->skus[$id]) && !empty($product->skus[$id]['virtual']);
}
if ($virtual) {
$data['virtual'] = 0;
$virtual = false;
}
if (!$virtual) {
break;
}
}
}
}
}
if (empty($data['eproduct']) && !empty($data['file_name'])) {
$file_path = shopProduct::getPath($data['product_id'], "sku_file/{$id}." . pathinfo($data['file_name'], PATHINFO_EXTENSION));
waFiles::delete($file_path);
$data['file_name'] = '';
$data['file_description'] = '';
} elseif (isset($data['file_name'])) {
unset($data['file_name']);
}
$this->updateById($id, $data);
} else {
if (!isset($data['sku'])) {
$data['sku'] = '';
}
$id = $this->insert($data);
}
$data['id'] = $id;
$sku_count = false;
// if stocking for this sku
if (isset($data['stock']) && count($data['stock'])) {
if ($multi_stock === null) {
$stock_model = new shopStockModel();
$stocks = $stock_model->getAll($stock_model->getTableId());
$multi_stock = $stocks ? array_keys($stocks) : false;
}
// not multistocking
if (!$multi_stock || isset($data['stock'][0])) {
$sku_count = self::castStock($data['stock'][0]);
unset($data['stock']);
$this->logCount($data['product_id'], $id, $sku_count);
// multistocking
} else {
$sku_count = 0;
$missed = array_combine($multi_stock, $multi_stock);
if (!$stocks_model) {
$stocks_model = new shopProductStocksModel();
}
// need for track transition from aggregating mode to multistocking mode
$has_any_stocks = $stocks_model->hasAnyStocks($id);
if (!$has_any_stocks) {
$this->writeOffCount($data['product_id'], $id);
}
foreach ($data['stock'] as $stock_id => $count) {
if ($stock_id > 0 && isset($missed[$stock_id])) {
unset($missed[$stock_id]);
$field = array('sku_id' => $id, 'stock_id' => $stock_id, 'product_id' => $data['product_id']);
$count = self::castStock($count);
$stock = array('count' => $count);
if ($count === null) {
$sku_count = null;
} else {
// Once turned into NULL value is not changed
if ($sku_count !== null) {
$sku_count += $count;
}
}
// there is taking into account stocks log inside this method
$stocks_model->set(array_merge($field, $stock));
$data['stock'][$stock_id] = $count;
}
}
//get stock_count for missed stocks
if ($sku_count !== null && !empty($missed)) {
$search = array('stock_id' => $missed, 'sku_id' => $id, 'product_id' => $data['product_id']);
foreach ($stocks_model->getByField($search, 'stock_id') as $stock_id => $row) {
$count = $row['count'];
$data['stock'][$stock_id] = $count;
if ($count === null) {
$sku_count = null;
} else {
// Once turned into NULL value is not changed
if ($sku_count !== null) {
$sku_count += $count;
}
}
}
}
}
}
if ($sku_count !== false) {
$data['count'] = $sku_count;
$this->updateById($id, array('count' => $sku_count));
}
if (isset($data['features'])) {
if (!$feature_model) {
$feature_model = new shopFeatureModel();
}
if (!$product_features_model) {
$product_features_model = new shopProductFeaturesModel();
}
$features = $data['features'];
$data['features'] = array();
$skip_values = array('', false, null);
foreach ($features as $code => $value) {
if ($feature = $feature_model->getByField('code', $code)) {
$model = shopFeatureModel::getValuesModel($feature['type']);
$field = array('product_id' => $data['product_id'], 'sku_id' => $id, 'feature_id' => $feature['id']);
$product_features_model->deleteByField($field);
if (is_array($value)) {
if (!empty($value['id'])) {
$field['feature_value_id'] = $value['id'];
} elseif (isset($value['value']) && !in_array($value['value'], $skip_values, true)) {
$field['feature_value_id'] = $model->getId($feature['id'], $code == 'weight' ? $value : $value['value'], $feature['type']);
}
} elseif (!in_array($value, $skip_values, true)) {
$field['feature_value_id'] = $model->getId($feature['id'], $value, $feature['type']);
$value = array('value' => $value, 'id' => $field['feature_value_id']);
}
if (!empty($field['feature_value_id'])) {
$product_features_model->insert($field);
$data['features'][$code] = $value;
}
} elseif (is_numeric($code) && is_numeric($value)) {
if ($feature = $feature_model->getById($code)) {
$field = array('product_id' => $data['product_id'], 'sku_id' => $id, 'feature_id' => $code);
$product_features_model->deleteByField($field);
if (empty($value)) {
continue;
}
$field['feature_value_id'] = $value;
$product_features_model->insert($field);
$data['features'][$feature['code']] = $feature_model->getValuesModel($feature['type'])->getFeatureValue($value);
}
}
}
}
if ($correct) {
$product_model = new shopProductModel();
$product_model->correct($data['product_id']);
}
return $data;
}