/** * 把country跑到mv_basic_country */ public function actionFixcountry() { $mvBasic = MvBasic::find()->where('id>=12313')->orderBy('id asc'); $total = $mvBasic->count(); $page = 1; $pageSize = 40; $totalPage = ceil($total / $pageSize); $mvBasic->limit($pageSize)->asArray(); for ($page = 1; $page <= $totalPage; $page++) { $offset = ($page - 1) * $pageSize; $data = $mvBasic->offset($offset)->all(); foreach ($data as $v) { $basic_id = $v['id']; $movieCountry = explode(',', $v['countries']); echo $basic_id, "\n"; foreach ($movieCountry as $t) { echo $t, "\n"; // mv_basic_condition country $cond = models\MvBasicCondition::find()->where(['name' => $t, 'status' => 1, 'cond_type' => 2])->asArray()->one(); if (empty($cond)) { $MvBasicType = new models\MvBasicCondition(); $MvBasicType->cond_type = 2; $MvBasicType->name = $t; $MvBasicType->update_time = time(); $MvBasicType->save(); $cond_id = $MvBasicType->primaryKey; } else { $cond_id = $cond['id']; } // mv_basic_country if (!models\MvBasicCountry::findOne(['basic_id' => $basic_id, 'country_id' => $cond_id])) { $MvBasicCountry = new models\MvBasicCountry(); $MvBasicCountry->basic_id = $basic_id; $MvBasicCountry->country_id = $cond_id; $MvBasicCountry->save(); } } echo "\n\n"; } } return $ret; }
/** * 更新电影国家地区 * mv_basic_ , mv_basic_condition 入库 */ public function updateMovieCountry($basic_id, $movieCountry) { if (empty($basic_id) || !is_numeric($basic_id) || empty($movieCountry) || !is_array($movieCountry)) { return false; } foreach ($movieCountry as $t) { // mv_basic_condition country $cond = models\MvBasicCondition::find()->where(['name' => $t, 'cond_type' => 2])->asArray()->one(); if (empty($cond)) { $MvBasicType = new models\MvBasicCondition(); $MvBasicType->cond_type = 2; $MvBasicType->name = $t; $MvBasicType->update_time = time(); $MvBasicType->save(); $cond_id = $MvBasicType->primaryKey; } else { $cond_id = $cond['id']; } // mv_basic_country if (!models\MvBasicCountry::findOne(['basic_id' => $basic_id, 'country_id' => $cond_id])) { $MvBasicCountry = new models\MvBasicCountry(); $MvBasicCountry->basic_id = $basic_id; $MvBasicCountry->country_id = $cond_id; $MvBasicCountry->save(); } } }