/** * Сохраняем секции * @param array $aData */ public function saveSectionsWithPrimary($aData = []) { $nCou = Usersection::updateAll(['usec_user_id' => 0, 'usec_section_id' => 0, 'usec_section_primary' => 0], ['usec_user_id' => $this->us_id]); if (count($aData) > 0) { foreach ($aData as $el) { /** @var UsersectionForm $el */ Yii::info('saveAllSections(): ' . print_r($el, true)); $nUpd = Yii::$app->db->createCommand('Update ' . Usersection::tableName() . ' Set usec_user_id = :us_id, usec_section_id = :section_id, usec_section_primary = :prime Where usec_user_id = 0 Limit 1', [':section_id' => $el['sectid'], ':us_id' => $this->us_id, ':prime' => $el['isprime']])->execute(); if ($nUpd == 0) { Yii::$app->db->createCommand('Insert Into ' . Usersection::tableName() . ' (usec_user_id, usec_section_id, usec_section_primary) Values (:us_id, :section_id, :prime)', [':section_id' => $el['sectid'], ':us_id' => $this->us_id, ':prime' => $el['isprime']])->execute(); // Yii::info('Insert relate records : ['.$this->msg_id.', '.$id.']'); } } } }