Exemple #1
0
 /**
  *  Сохраняем секции
  * @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.']');
             }
         }
     }
 }