public static function deleteUser($user_id)
{
$db = JO_Db::getDefaultAdapter();
$user_info = self::getUser($user_id);
if (!$user_info) {
return;
}
if ($user_info['store'] == 's3') {
self::deleteImagesAmazon($user_info['avatar']);
} else {
if ($user_info['avatar']) {
$model_image = new Helper_Images();
$model_image->deleteImages($user_info['avatar']);
}
}
$query = $db->select()->from('boards')->where('user_id = ?', (string) $user_id);
$rows = $db->fetchAll($query);
if ($rows) {
foreach ($rows as $row) {
Model_Boards::delete($row['board_id']);
}
}
$db->query("DELETE FROM url_alias WHERE query = 'user_id=" . (string) $user_id . "'");
$db->delete('users_boards', array('user_id = ?' => (string) $user_id));
$db->delete('shared_content', array('user_id = ?' => (string) $user_id));
$db->delete('users_following', array('user_id = ?' => (string) $user_id));
$db->delete('users_following', array('following_id = ?' => (string) $user_id));
$db->delete('users_following_ignore', array('user_id = ?' => (string) $user_id));
$db->delete('users_following_ignore', array('following_id = ?' => (string) $user_id));
$db->delete('users_following_user', array('user_id = ?' => (string) $user_id));
$db->delete('users_following_user', array('following_id = ?' => (string) $user_id));
$db->delete('users_history', array('from_user_id = ?' => (string) $user_id));
$db->delete('users_history', array('to_user_id = ?' => (string) $user_id));
$db->delete('users_agenda', array('user_id = ?' => (string) $user_id));
$db->delete('users_activate', array('user_id = ?' => (string) $user_id));
$db->delete('users_location', array('user_id = ?' => (string) $user_id));
$db->delete('users_sports', array('user_id = ?' => (string) $user_id));
$db->delete('users_messages', array('from_user_id = ?' => (string) $user_id));
$db->delete('users_messages', array('to_user_id = ?' => (string) $user_id));
$db->delete('users_mails', array('from_user_id = ?' => (string) $user_id));
$db->delete('users_mails_to', array('user_id = ?' => (string) $user_id));
$db->delete('users_likes', array('user_id = ?' => (string) $user_id));
$db->delete('users', array('user_id = ?' => (string) $user_id));
}
public function deleteMultiAction()
{
$this->noViewRenderer(true);
if (!WM_Users::allow('delete', $this->getRequest()->getController())) {
$this->session->set('error_permision', $this->translate('You do not have permission to this action'));
$this->redirect($this->getRequest()->getBaseUrl() . $this->getRequest()->getModule() . '/boards/');
}
$action_check = $this->getRequest()->getPost('action_check');
if ($action_check && is_array($action_check)) {
foreach ($action_check as $record_id) {
Model_Boards::delete($record_id);
}
}
}
public static function deleteUser($user_id)
{
$db = JO_Db::getDefaultAdapter();
$user_info = self::getUser($user_id);
if (!$user_info) {
return;
}
/*if($user_info['store'] == 's3') {
self::deleteImagesAmazon($user_info['avatar']);
} else {
if($user_info['avatar']) {
$model_image = new Helper_Images();
$model_image->deleteImages($user_info['avatar']);
}
}*/
$query = $db->select()->from('boards')->where('user_id = ?', (string) $user_id);
$rows = $db->fetchAll($query);
if ($rows) {
foreach ($rows as $row) {
Model_Boards::delete($row['board_id']);
}
}
$ext = Model_Extensions_Install::getByMethod('user_login');
$front = JO_Front::getInstance();
foreach ($ext as $login) {
$model = $front->formatModuleName('model_' . $login . '_users');
$instance = new $model();
$instance->deleteByUserId($user_id);
}
$db->query("DELETE FROM url_alias WHERE query = 'user_id=" . (string) $user_id . "'");
$db->delete('users_boards', array('user_id = ?' => (string) $user_id));
$db->delete('shared_content', array('user_id = ?' => (string) $user_id));
$db->delete('users_following', array('user_id = ?' => (string) $user_id));
$db->delete('users_following', array('following_id = ?' => (string) $user_id));
$db->delete('users_following_ignore', array('user_id = ?' => (string) $user_id));
$db->delete('users_following_ignore', array('following_id = ?' => (string) $user_id));
$db->delete('users_following_user', array('user_id = ?' => (string) $user_id));
$db->delete('users_following_user', array('following_id = ?' => (string) $user_id));
$db->delete('users_history', array('from_user_id = ?' => (string) $user_id));
$db->delete('users_history', array('to_user_id = ?' => (string) $user_id));
$db->delete('users', array('user_id = ?' => (string) $user_id));
}
public function deleteAction()
{
$request = $this->getRequest();
$board_id = $request->getRequest('board_id');
$board_info = Model_Boards::getBoard($board_id);
if (!$board_info) {
$this->forward('error', 'error404');
}
if ($board_info['user_id'] != JO_Session::get('user[user_id]')) {
$this->redirect(WM_Router::create($request->getBaseUrl() . '?controller=boards&user_id=' . $board_info['user_id'] . '&board_id=' . $board_info['board_id']));
} else {
if (Model_Boards::delete($board_id)) {
$this->redirect(WM_Router::create($request->getBaseUrl() . '?controller=users&action=profile&user_id=' . $board_info['user_id']));
} else {
$this->redirect(WM_Router::create($request->getBaseUrl() . '?controller=boards&action=edit&user_id=' . $board_info['user_id'] . '&board_id=' . $board_info['board_id']));
}
}
}
