private function addItem($goods_id, $code, $item_sxe) { $item = ShItems::findOne(['code' => $code]); if (!$item) { $item = new ShItems(); $item->goods_id = $goods_id; $item->code = $code; } $item->state = 1; $item->save(); foreach (ShItemCharacteristics::findAll(['items_id' => $item->id]) as $item_characteristic) { $item_characteristic->state = 0; $item_characteristic->save(); } foreach ($item_sxe->{'ХарактеристикиТовара'}->{'ХарактеристикаТовара'} as $characteristic_sxe) { $characteristic = ShCharacteristics::findOne(['characteristic' => strval($characteristic_sxe->{'Наименование'})]); if (!$characteristic) { $characteristic = new ShCharacteristics(); $characteristic->characteristic = strval($characteristic_sxe->{'Наименование'}); $characteristic->save(); } $item_characteristic = ShItemCharacteristics::findOne(['items_id' => $item->id, 'characteristics_id' => $characteristic->id]); if (!$item_characteristic) { $item_characteristic = new ShItemCharacteristics(); $item_characteristic->items_id = $item->id; $item_characteristic->characteristics_id = $characteristic->id; } $item_characteristic->value = strval($characteristic_sxe->{'Значение'}); $item_characteristic->state = 1; $item_characteristic->save(); } return ['id' => $item->id]; }
private function parserOffers($offers_sxe) { /* Поиск и удаление цен для товара и его характеристик */ foreach ($offers_sxe as $item_sxe) { if (preg_match('/(.+)#(.+)/', $item_sxe->{'Ид'}, $matches)) { $good_code = strval($matches[1]); $item_code = strval($matches[2]); $prices_item = ShPriceItem::find()->innerJoinWith('item')->where(['mod_sh_items.code' => $item_code])->all(); if ($prices_item) { ShPriceItem::deleteAll(['id' => ArrayHelper::getColumn($prices_item, 'id')]); } } else { $good_code = strval($item_sxe->{'Ид'}); } $price_good = ShPriceGood::find()->innerJoinWith('good')->where(['mod_sh_goods.code' => $good_code])->all(); if ($price_good) { ShPriceGood::deleteAll(['id' => ArrayHelper::getColumn($price_good, 'id')]); } } $price_types = ArrayHelper::map(ShPriceTypes::find()->all(), 'code', 'id'); $good_min_price = array(); foreach ($offers_sxe as $item_sxe) { $item_code = false; if (preg_match('/(.+)#(.+)/', $item_sxe->{'Ид'}, $matches)) { $good_code = strval($matches[1]); $item_code = strval($matches[2]); } else { $good_code = strval($item_sxe->{'Ид'}); } if (!isset($good_min_price[$good_code])) { $good_min_price[$good_code] = array(); } foreach ($item_sxe->{'Цены'}->{'Цена'} as $item_price) { $code = strval($item_price->{'ИдТипаЦены'}); if (!isset($good_min_price[$good_code][$price_types[$code]])) { $good_min_price[$good_code][$price_types[$code]] = floatval($item_price->{'ЦенаЗаЕдиницу'}); } else { if ($good_min_price[$good_code][$price_types[$code]] > floatval($item_price->{'ЦенаЗаЕдиницу'})) { $good_min_price[$good_code][$price_types[$code]] = floatval($item_price->{'ЦенаЗаЕдиницу'}); } } if ($item_code) { $item = ShItems::findOne(['code' => $item_code]); if ($item) { $price_item = new ShPriceItem(); $price_item->items_id = $item->id; $price_item->price_types_id = $price_types[$code]; $price_item->price = floatval($item_price->{'ЦенаЗаЕдиницу'}); $price_item->save(); } } } } foreach ($good_min_price as $good_code => $good_prices) { $good = ShGoods::findOne(['code' => $good_code]); if ($good) { foreach ($good_prices as $price_types_id => $good_price) { $price_good = new ShPriceGood(); $price_good->goods_id = $good->id; $price_good->price_types_id = $price_types_id; $price_good->price = $good_price; $price_good->save(); } } } }