/**
* 把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();
}
}
}
