Yarik / artbox-order

  <?php
      
      namespace artbox\order\models;
      
      use artbox\catalog\models\Variant;
      use Yii;

      use yii\db\ActiveRecord;

      use yii\helpers\ArrayHelper;

      
      /**
       * This is the model class for table "order_product".

       *

       * @property integer $id

       * @property integer $order_id
       * @property integer $variant_id
       * @property string  $sku

       * @property float   $price

       * @property integer $count
       * @property Order   $order
       * @property Variant $variant
       */

      class OrderProduct extends ActiveRecord

      {
          /**
           * @inheritdoc
           */
          public static function tableName()
          {
              return 'order_product';
          }
          
          /**
           * @inheritdoc
           */
          public function rules()
          {
              return [
                  [
                      [
                          'order_id',
                          'sku',

                          'variant_id',

                      ],
                      'required',
                  ],
                  [
                      [
                          'order_id',
                          'variant_id',
                          'count',
                      ],
                      'integer',
                  ],
                  [
                      [ 'price' ],
                      'number',
                  ],
                  [
                      [ 'sku' ],
                      'string',
                      'max' => 255,
                  ],
                  [
                      [ 'order_id' ],
                      'exist',
                      'skipOnError'     => true,
                      'targetClass'     => Order::className(),
                      'targetAttribute' => [ 'order_id' => 'id' ],
                  ],
                  [
                      [ 'variant_id' ],
                      'exist',
                      'skipOnError'     => true,
                      'targetClass'     => Variant::className(),
                      'targetAttribute' => [ 'variant_id' => 'id' ],
                  ],
              ];
          }
          
          /**
           * @inheritdoc
           */
          public function attributeLabels()
          {
              return [
                  'id'         => Yii::t('order', 'ID'),
                  'order_id'   => Yii::t('order', 'Order ID'),
                  'variant_id' => Yii::t('order', 'Variant ID'),
                  'sku'        => Yii::t('order', 'Sku'),
                  'price'      => Yii::t('order', 'Price'),
                  'count'      => Yii::t('order', 'Count'),
              ];
          }
          
          /**
           * @return \yii\db\ActiveQuery
           */
          public function getOrder()
          {
              return $this->hasOne(Order::className(), [ 'id' => 'order_id' ]);
          }
          
          /**
           * @return \yii\db\ActiveQuery
           */
          public function getVariant()
          {
              return $this->hasOne(Variant::className(), [ 'id' => 'variant_id' ]);
          }

      
          /**
           * @param array $items
           * @param int   $orderId
           *
           * @return \artbox\order\models\OrderProduct[]
           */
          public static function saveItems(array $items, int $orderId): array
          {
              $variantIds = ArrayHelper::getColumn($items, 'variant_id', false);
              /**
               * @var \artbox\order\models\OrderProduct[] $deletion
               */
              $deletion = self::find()
                              ->where(
                                  [
                                      'not',
                                      [ 'variant_id' => $variantIds ],
                                  ]
                              )
                              ->andWhere([ 'order_id' => $orderId ])
                              ->all();
              foreach ($deletion as $record) {
                  $record->delete();
              }
              /**
               * @var \artbox\order\models\OrderProduct[] $orderProducts
               */
              $orderProducts = self::find()
                                   ->where(
                                       [
                                           'variant_id' => $variantIds,
                                           'order_id'   => $orderId,
                                       ]
                                   )
                                   ->all();

             // print_r($orderProducts); die();

              $newItems = [];
              foreach ($items as $item) {
                  $id = $item[ 'variant_id' ];
                  $count = $item[ 'count' ];
                  foreach ($orderProducts as $orderProduct) {
                      if ($orderProduct->variant_id == $id) {
                          $orderProduct->count = $count;

                          continue 2;

                      }
                  }
                  /**
                   * @var Variant $variant
                   */
                  $variant = Variant::find()
                                    ->where([ 'id' => $id ])
                                    ->one();
                  if ($variant) {
                      $newItems[] = new OrderProduct(
                          [
                              'order_id'   => $orderId,
                              'variant_id' => $id,
                              'sku'        => $variant->sku,
                              'price'      => $variant->price,
                              'count'      => $count,
                          ]
                      );
                  }
              }
              $orderProducts = array_merge($orderProducts, $newItems);

             // print_r($orderProducts); die();

              foreach ($orderProducts as $orderProduct) {

                 var_dump( $orderProduct->save());

              }

             // die();

              return $orderProducts;
          }

      }