public function actionUrls_mass() { if (!Yii::app()->request->isPostRequest) { throw new CHttpException(400, 'Invalid request. Please do not repeat this request again.'); } $action = $_GET['action']; if (isset($_POST['extendedSelect'])) { AdvancedSelectableGridView::mapUrlToGET(); $dataProvider = Url::searchDataProvider(); $criteria = AdvancedSelectableGridView::getExtendedSelectCriteria('Url', $dataProvider); if (!$criteria->condition) { $criteria->condition = "1=1"; } if ($action == 'download') { Url::model()->downloadUrls($criteria->condition, $criteria->params); } elseif ($action == 'delete') { Url::model()->deleteUrls($criteria->condition, $criteria->params); } elseif ($action == 'enable') { Yii::app()->db->createCommand("UPDATE urls_url SET enabled_url=1 WHERE " . $criteria->condition)->execute($criteria->params); } elseif ($action == 'disable') { Yii::app()->db->createCommand("UPDATE urls_url SET enabled_url=0 WHERE " . $criteria->condition)->execute($criteria->params); } } elseif (isset($_POST['selected']) && is_array($_POST['selected']) && count($_POST['selected'])) { foreach ($_POST['selected'] as $k => $v) { // value must be integer $_POST['selected'][$k] = (int) $v; } if (count($_POST['selected']) == 1) { $condition = "id_url=" . $_POST['selected'][0]; } else { $condition = "id_url='" . implode("' OR id_url='", $_POST['selected']) . '\''; } if ($action == 'download') { Url::model()->downloadUrls($condition); } elseif ($action == 'delete') { Url::model()->deleteUrls($condition); } elseif ($action == 'enable') { Yii::app()->db->createCommand("UPDATE urls_url SET enabled_url=1 WHERE " . $condition)->execute(); } elseif ($action == 'disable') { Yii::app()->db->createCommand("UPDATE urls_url SET enabled_url=0 WHERE " . $condition)->execute(); } } else { throw new CHttpException(400, 'Bad request.'); } header("Location: " . $_SERVER['HTTP_REFERER']); die; }
public function actionBogus_mass() { if (!Yii::app()->request->isPostRequest) { throw new CHttpException(400, 'Invalid request. Please do not repeat this request again.'); } $action = $_GET['action']; $message = false; if (isset($_POST['extendedSelect'])) { AdvancedSelectableGridView::mapUrlToGET(); $dataProvider = Url::searchDataProvider(); $criteria = AdvancedSelectableGridView::getExtendedSelectCriteria('Url', $dataProvider); if (!$criteria->condition) { $criteria->condition = "1=1"; } if ($action == 'unpack') { Yii::app()->db->createCommand("UPDATE bogus_archives_bga SET pending_action_bga='Rescan' WHERE {$criteria->condition}")->execute($criteria->params); } elseif ($action == 'delete') { Yii::app()->db->createCommand("UPDATE bogus_archives_bga SET pending_action_bga='Delete' WHERE {$criteria->condition}")->execute($criteria->params); } } elseif (isset($_POST['selected']) && is_array($_POST['selected']) && count($_POST['selected'])) { foreach ($_POST['selected'] as $k => $v) { // value must be integer $_POST['selected'][$k] = (int) $v; } if (count($_POST['selected']) == 1) { $condition = "id_bga=" . $_POST['selected'][0]; } else { $condition = "id_bga='" . implode("' OR id_bga='", $_POST['selected']) . '\''; } $number = Yii::app()->db->createCommand("SELECT count(*) 'nr' FROM bogus_archives_bga WHERE {$condition}")->queryRow(); $number = $number['nr']; if ($action == 'unpack') { Yii::app()->db->createCommand("UPDATE bogus_archives_bga SET pending_action_bga='Rescan' WHERE {$condition}")->execute(); Yii::app()->user->setFlash('_success', $number . ' archives will be reprocessed!'); } elseif ($action == 'delete') { Yii::app()->db->createCommand("UPDATE bogus_archives_bga SET pending_action_bga='Delete' WHERE {$condition}")->execute(); Yii::app()->user->setFlash('_success', $number . ' archives will be deleted!'); } } else { throw new CHttpException(400, 'Bad request.'); } header("Location: " . $_SERVER['HTTP_REFERER']); }