public static function createEvent($user_id, $event_id, $data)
{
$db = JO_Db::getDefaultAdapter();
$rows = self::describeTable('events');
//$user_info_get = self::getUser($user_id);
//$created = WM_Date::format($user_info_get['created'], 'yy-mm-dd H:i:s');
$update = array();
$avatar = '';
$followers = false;
foreach ($rows as $row) {
if (array_key_exists($row, $data)) {
if ($row == 'avatar') {
if ($data[$row]) {
JO_Session::clear('upload_avatar');
$avatar = $data[$row];
} else {
//$update[$row] = $data[$row];
}
} else {
$update[$row] = $data[$row];
if ($row == 'compartir' && $data[$row] == 'followers') {
$followers = true;
}
if ($row == 'date_event') {
$fecha = str_replace("/", "-", $data[$row]);
$update[$row] = WM_Date::format($fecha, 'yy-mm-dd H:i:s');
}
}
}
}
if (!$update) {
if (!$avatar) {
return false;
}
}
$user_data = "";
if ($event_id) {
$user_data = Model_Events::getEventUser((string) $user_id, $event_id);
if (!$user_data) {
$db->insert('events', $update);
$event_id = $db->lastInsertId();
if ($followers) {
$users = Model_Users::getUsers(array('filter_following_user_id' => (string) $user_id));
if ($users) {
foreach ($users as $key => $user) {
Model_History::addHistory($user['user_id'], Model_History::CREATE_EVENT, $event_id);
//self::FollowEvent($event_id, $user['user_id']);
}
}
}
if (!$event_id) {
return false;
}
} else {
$result = $db->update('events', $update, array('user_id = ' . (string) $user_id . ' AND event_id = ' . (string) $event_id));
if ($followers) {
$users = Model_Users::getUsers(array('filter_following_user_id' => (string) $user_id));
if ($users) {
foreach ($users as $key => $user) {
Model_History::addHistory($user['user_id'], Model_History::CREATE_EVENT, $event_id);
//self::FollowEvent($event_id, $user['user_id']);
}
}
}
if (!$result) {
return false;
}
}
} else {
$db->insert('events', $update);
$event_id = $db->lastInsertId();
if ($followers) {
$users = Model_Users::getUsers(array('filter_following_user_id' => (string) $user_id));
if ($users) {
foreach ($users as $key => $user) {
Model_History::addHistory($user['user_id'], Model_History::CREATE_EVENT, $event_id);
//self::FollowEvent($event_id, $user['user_id']);
}
}
}
if (!$event_id) {
return false;
}
}
if ($avatar) {
///// upload images
//error_log("Vamos a subir la imagen");
$front = JO_Front::getInstance();
$request = JO_Request::getInstance();
$upload_model = Helper_Pin::formatUploadModule(JO_Registry::get('default_upload_method'));
$upload_model_file = $front->getModuleDirectoryWithDefault($request->getModule()) . '/' . $front->classToFilename($upload_model);
if (!file_exists($upload_model_file)) {
$upload_model = Helper_Pin::formatUploadModule('locale');
$upload_model_file = $front->getModuleDirectoryWithDefault($request->getModule()) . '/' . $front->classToFilename($upload_model);
}
$image = false;
if (file_exists($upload_model_file)) {
//error_log("EXISTE FILE");
$image = call_user_func(array($upload_model, 'uploadEventImage'), $avatar, $event_id);
}
if ($image) {
//error_log("EXISTE FILE");
$result = $db->update('events', array('avatar' => $image['image'], 'store' => $image['store'], 'height' => $image['height'], 'width' => $image['width'], 'last_action_datetime' => new JO_Db_Expr('NOW()')), array('user_id = ' . (string) $user_id . ' AND event_id = ' . (string) $event_id));
if ($user_data) {
if ($user_data['avatar']) {
if ($user_data['avatar'] != $image['image']) {
call_user_func(array(Helper_Pin::formatUploadModule($user_data['store']), 'deleteEventImage'), $user_data);
}
}
}
}
}
return true;
}
public function fromfileAction()
{
$request = $this->getRequest();
$this->view->form_action = WM_Router::create($request->getBaseUrl() . '?controller=addpin&action=upload_images');
$this->view->upload_action = WM_Router::create($request->getBaseUrl() . '?controller=addpin&action=upload_imagesView');
$this->view->popup_main_box = $this->view->render('fromfile', 'addpin');
if ($request->isPost()) {
$result = Model_Pins::create(array('title' => $request->getPost('title'), 'from' => '', 'image' => BASE_PATH . JO_Session::get('upload_from_file'), 'is_video' => $request->getPost('is_video'), 'is_article' => $request->getPost('is_article'), 'description' => $request->getPost('message'), 'price' => $request->getPost('price'), 'board_id' => $request->getPost('board_id')));
if ($result) {
Model_History::addHistory(0, Model_History::ADDPIN, $result);
if (JO_Registry::get('isMobile')) {
$this->redirect('/');
}
$session_user = JO_Session::get('user[user_id]');
$group = Model_Boards::isGroupBoard($request->getPost('board_id'));
if ($group) {
$users = explode(',', $group);
foreach ($users as $user_id) {
if ($user_id != $session_user) {
$user_data = Model_Users::getUser($user_id);
if ($user_data && $user_data['email_interval'] == 1 && $user_data['groups_pin_email']) {
$this->view->user_info = $user_data;
$this->view->profile_href = WM_Router::create($request->getBaseUrl() . '?controller=users&action=profile&user_id=' . JO_Session::get('user[user_id]'));
$this->view->full_name = JO_Session::get('user[firstname]') . ' ' . JO_Session::get('user[lastname]');
$this->view->pin_href = WM_Router::create($request->getBaseUrl() . '?controller=pin&pin_id=' . $result);
$board_info = Model_Boards::getBoard($request->getPost('board_id'));
if ($board_info) {
$this->view->board_title = $board_info['title'];
$this->view->board_href = WM_Router::create($request->getBaseUrl() . '?controller=boards&action=view&user_id=' . $board_info['user_id'] . '&board_id=' . $board_info['board_id']);
}
Model_Email::send($user_data['email'], JO_Registry::get('noreply_mail'), JO_Session::get('user[firstname]') . ' ' . JO_Session::get('user[lastname]') . ' ' . $this->translate('added new pin to a group board'), $this->view->render('group_board', 'mail'));
}
}
}
}
$this->view->pin_url = WM_Router::create($request->getBaseUrl() . '?controller=pin&pin_id=' . $result);
$this->view->popup_main_box = $this->view->render('success', 'addpin');
if (JO_Session::get('upload_from_file')) {
@unlink(BASE_PATH . JO_Session::get('upload_from_file'));
JO_Session::clear('upload_from_file');
JO_Session::clear('upload_from_file_name');
}
}
}
$this->setViewChange('index');
if ($request->isXmlHttpRequest()) {
$this->view->popup = true;
echo $this->view->popup_main_box;
$this->noViewRenderer(true);
} else {
$this->view->children = array('header_part' => 'layout/header_part', 'footer_part' => 'layout/footer_part', 'left_part' => 'layout/left_part');
}
}
public function indexAction()
{
$request = $this->getRequest();
if (!JO_Session::get('user[user_id]')) {
$this->redirect(WM_Router::create($request->getBaseUrl() . '?controller=users&action=login&popup=true&next=' . urlencode($request->getFullUrl())));
}
$this->view->createBoard = WM_Router::create($request->getBaseUrl() . '?controller=boards&action=create');
$boards = Model_Boards::getBoards(array('filter_user_id' => JO_Session::get('user[user_id]'), 'order' => 'boards.sort_order', 'sort' => 'ASC', 'friendly' => JO_Session::get('user[user_id]')));
$this->view->boards = array();
if ($boards) {
foreach ($boards as $board) {
$this->view->boards[] = array('board_id' => $board['board_id'], 'title' => $board['title']);
}
}
//////////// Categories ////////////
$this->view->categories = array();
$categories = Model_Categories::getCategories(array('filter_status' => 1));
foreach ($categories as $category) {
$category['subcategories'] = Model_Categories::getSubcategories($category['category_id']);
$this->view->categories[] = $category;
}
$this->view->title = JO_Utf8::convertToUtf8($request->getQuery('title'));
$this->view->url = JO_Utf8::convertToUtf8(urldecode($request->getQuery('url')));
$this->view->media = JO_Utf8::convertToUtf8($request->getQuery('media'));
$this->view->is_video = JO_Utf8::convertToUtf8($request->getQuery('is_video'));
$this->view->description = JO_Utf8::convertToUtf8($request->getQuery('description'));
$this->view->charset = JO_Utf8::convertToUtf8($request->getQuery('charset'));
if (!trim($this->view->description)) {
$this->view->description = $this->view->title;
}
if (JO_Session::get('success_added')) {
$this->view->pin_url = WM_Router::create($request->getBaseUrl() . '?controller=pin&pin_id=' . JO_Session::get('success_added'));
$this->setViewChange('success');
JO_Session::clear('success_added');
} else {
if ($request->isPost()) {
$result = Model_Pins::create(array('title' => $this->view->title, 'from' => $this->view->url, 'image' => $this->view->media, 'is_video' => $this->view->is_video, 'description' => $request->getPost('message'), 'price' => $request->getPost('price'), 'board_id' => $request->getPost('board_id'), 'pinmarklet' => 1));
if ($result) {
Model_History::addHistory(0, Model_History::ADDPIN, $result);
$session_user = JO_Session::get('user[user_id]');
$group = Model_Boards::isGroupBoard($request->getPost('board_id'));
if ($group) {
$users = explode(',', $group);
foreach ($users as $user_id) {
if ($user_id != $session_user) {
$user_data = Model_Users::getUser($user_id);
if ($user_data && $user_data['email_interval'] == 1 && $user_data['groups_pin_email']) {
$this->view->user_info = $user_data;
$this->view->profile_href = WM_Router::create($request->getBaseUrl() . '?controller=users&action=profile&user_id=' . JO_Session::get('user[user_id]'));
$this->view->full_name = JO_Session::get('user[firstname]') . ' ' . JO_Session::get('user[lastname]');
$this->view->pin_href = WM_Router::create($request->getBaseUrl() . '?controller=pin&pin_id=' . $result);
$board_info = Model_Boards::getBoard($request->getPost('board_id'));
if ($board_info) {
$this->view->board_title = $board_info['title'];
$this->view->board_href = WM_Router::create($request->getBaseUrl() . '?controller=boards&action=view&user_id=' . $board_info['user_id'] . '&board_id=' . $board_info['board_id']);
}
Model_Email::send($user_data['email'], JO_Registry::get('noreply_mail'), JO_Session::get('user[firstname]') . ' ' . JO_Session::get('user[lastname]') . ' ' . $this->translate('added new pin to a group board'), $this->view->render('group_board', 'mail'));
}
}
}
}
JO_Session::set('success_added', $result);
$this->redirect($request->getBaseUrl() . '?controller=bookmarklet');
}
}
}
}
public function repinAction()
{
$request = $this->getRequest();
$pin_id = $request->getRequest('pin_id');
$pin_info = Model_Pins::getPin($pin_id);
if (!$pin_info) {
$this->forward('error', 'error404');
}
$model_images = new Helper_Images();
$this->view->title = $pin_info['title'];
$this->view->price = $pin_info['price'];
$image = Helper_Uploadimages::pin($pin_info, '_B');
if ($image) {
$this->view->media = $image['original'];
} else {
$this->view->media = false;
}
$this->view->is_video = $pin_info['is_video'] ? 'true' : 'false';
$this->view->is_article = $pin_info['is_article'] ? 'true' : 'false';
$this->view->from = $pin_info['from'];
$this->view->description = $pin_info['description'];
$this->view->from_url = WM_Router::create($request->getBaseUrl() . '?controller=pin&action=repin&pin_id=' . $pin_id);
$this->view->createBoard = WM_Router::create($request->getBaseUrl() . '?controller=boards&action=create');
$boards = Model_Boards::getBoards(array('filter_user_id' => JO_Session::get('user[user_id]'), 'order' => 'boards.sort_order', 'sort' => 'ASC', 'friendly' => JO_Session::get('user[user_id]')));
$this->view->boards = array();
if ($boards) {
foreach ($boards as $board) {
$this->view->boards[] = array('board_id' => $board['board_id'], 'title' => $board['title']);
}
}
//////////// Categories ////////////
$this->view->categories = array();
$categories = Model_Categories::getCategories(array('filter_status' => 1));
foreach ($categories as $category) {
$category['subcategories'] = Model_Categories::getSubcategories($category['category_id']);
$this->view->categories[] = $category;
}
$this->view->popup_main_box = $this->view->render('repin', 'pin');
$this->view->is_article = $pin_info['is_article'] ? 'true' : 'false';
if ($request->isPost()) {
$result = Model_Pins::create(array('title' => $pin_info['title'], 'from' => $pin_info['from'], 'image' => $this->view->media, 'is_video' => $pin_info['is_video'] ? 'true' : 'false', 'is_article' => $pin_info['is_article'] ? 'true' : 'false', 'description' => $request->getPost('message'), 'price' => $request->getPost('price'), 'board_id' => $request->getPost('board_id'), 'via' => $pin_info['user_id'], 'repin_from' => $pin_info['pin_id'], 'from_repin' => $pin_info['from']));
if ($result) {
$this->view->pin_url = WM_Router::create($request->getBaseUrl() . '?controller=pin&pin_id=' . $result);
$this->view->popup_main_box = $this->view->render('success', 'addpin');
//add history
Model_History::addHistory($pin_info['user_id'], Model_History::REPIN, $result);
if ($pin_info['user']['email_interval'] == 1 && $pin_info['user']['repins_email']) {
$this->view->user_info = $pin_info['user'];
$this->view->profile_href = WM_Router::create($request->getBaseUrl() . '?controller=users&action=profile&user_id=' . JO_Session::get('user[user_id]'));
$this->view->full_name = JO_Session::get('user[firstname]') . ' ' . JO_Session::get('user[lastname]');
$this->view->text_email = $this->translate('repin your');
$this->view->pin_href = WM_Router::create($request->getBaseUrl() . '?controller=pin&pin_id=' . $pin_id);
Model_Email::send($pin_info['user']['email'], JO_Registry::get('noreply_mail'), JO_Session::get('user[firstname]') . ' ' . JO_Session::get('user[lastname]') . ' ' . $this->translate('repin your pin'), $this->view->render('repin_pin', 'mail'));
}
}
}
$this->setViewChange('index');
if ($request->isXmlHttpRequest()) {
$this->noViewRenderer(true);
echo $this->view->popup_main_box;
$this->view->is_popup = true;
} else {
$this->view->pins_details = $this->view->popup_main_box;
$this->view->is_popup = false;
$this->view->children = array('header_part' => 'layout/header_part', 'footer_part' => 'layout/footer_part', 'left_part' => 'pin/left_part');
}
}
public function likeAction()
{
$this->noViewRenderer(true);
$request = $this->getRequest();
if ((int) JO_Session::get('user[user_id]')) {
$history_user_id = $request->getRequest('userio_id');
$user_id = JO_Session::get('user[user_id]');
$event_id = $request->getRequest('event_id');
if ($user_id) {
if (Model_Events::isLikeEvent($event_id, $user_id)) {
$result = Model_Events::UnLikeEvent($event_id, $user_id);
if ($result) {
$this->view->ok = $this->translate('Me gusta');
$this->view->classs = 'add';
Model_History::addHistory($history_user_id, Model_History::UNLIKE_EVENT, $event_id);
} else {
$this->view->error = true;
}
} else {
$result = Model_Events::LikeEvent($event_id, $user_id);
if ($result) {
$this->view->ok = $this->translate('No me gusta');
$this->view->classs = 'remove';
Model_History::addHistory($history_user_id, Model_History::LIKE_EVENT, $event_id);
/*
if ($board_info['email_interval'] == 1 && $board_info['follows_email'])
{
$this->view->user_info = $board_info;
$this->view->profile_href = WM_Router::create($request->getBaseUrl() . '?controller=users&action=profile&user_id=' . JO_Session::get('user[user_id]'));
$this->view->full_name = JO_Session::get('user[firstname]') . ' ' . JO_Session::get('user[lastname]');
$this->view->text_email = $this->translate('now follow you');
Model_Email::send(
$board_info['email'], JO_Registry::get('noreply_mail'), JO_Session::get('user[firstname]') . ' ' . JO_Session::get('user[lastname]') . ' ' . $this->translate('follow your'), $this->view->render('follow_user', 'mail')
);
}
*
*/
} else {
$this->view->error = true;
}
}
} else {
$this->view->error = true;
}
} else {
$this->view->location = WM_Router::create($request->getBaseUrl() . '?controller=landing');
}
if ($request->isXmlHttpRequest()) {
echo $this->renderScript('json');
} else {
$this->redirect($request->getServer('HTTP_REFERER'));
}
}
public function pinMediaCallbackAction()
{
$request = $this->getRequest();
if (JO_Session::get('user[user_id]')) {
$media = Model_Instagram::getMedia($request->getPost('media_id'));
if ($media) {
if ($media['user_id'] == JO_Session::get('user[user_id]')) {
$result = Model_Pins::create(array('title' => $media['title'], 'from' => $media['from'], 'image' => $media['media'], 'description' => $media['title'], 'board_id' => JO_Session::get('instagram_media[board_id]')));
if ($result) {
Model_Instagram::setPinMedia($media['media_id'], $result);
Model_History::addHistory(JO_Session::get('user[user_id]'), Model_History::ADDPIN, $result);
$session_user = JO_Session::get('user[user_id]');
$group = Model_Boards::isGroupBoard($request->getPost('board_id'));
if ($group) {
$users = explode(',', $group);
foreach ($users as $user_id) {
if ($user_id != $session_user) {
$user_data = Model_Users::getUser($user_id);
if ($user_data && $user_data['email_interval'] == 1 && $user_data['groups_pin_email']) {
$this->view->user_info = $user_data;
$this->view->profile_href = WM_Router::create($request->getBaseUrl() . '?controller=users&action=profile&user_id=' . JO_Session::get('user[user_id]'));
$this->view->full_name = JO_Session::get('user[firstname]') . ' ' . JO_Session::get('user[lastname]');
$this->view->pin_href = WM_Router::create($request->getBaseUrl() . '?controller=pin&pin_id=' . $result);
$board_info = Model_Boards::getBoard($request->getPost('board_id'));
if ($board_info) {
$this->view->board_title = $board_info['title'];
$this->view->board_href = WM_Router::create($request->getBaseUrl() . '?controller=boards&action=view&user_id=' . $board_info['user_id'] . '&board_id=' . $board_info['board_id']);
}
Model_Email::send($user_data['email'], JO_Registry::get('noreply_mail'), JO_Session::get('user[firstname]') . ' ' . JO_Session::get('user[lastname]') . ' ' . $this->translate('added new pin to a group board'), $this->view->render('group_board', 'mail'));
}
}
}
}
$this->view->ok = true;
} else {
$this->view->error = $this->translate('There was a problem with the record. Please try again!');
}
} else {
$this->view->error = $this->translate('Private media!');
}
} else {
$this->view->error = $this->translate('Media not found!');
}
} else {
$this->view->location = WM_Router::create($request->getBaseUrl() . '?controller=users&action=login');
}
echo $this->renderScript('json');
}
public function agendaAction()
{
$this->noViewRenderer(true);
$request = $this->getRequest();
$response = $this->getResponse();
$page = (int) $request->getRequest('page');
if ($page < 1) {
$page = 1;
}
$callback = $request->getRequest('callback');
if (!preg_match('/^([a-z0-9_.]{1,})$/', $callback)) {
$callback = false;
}
if (isset($_POST['token']) && $_POST['token'] == md5($_POST['userId'])) {
$_SESSION['token'] = $_POST['token'];
JO_Session::set('token', $_POST['token']);
Model_Users::editAgenda($request->getPost('agenda'));
$data = Model_Users::followersUsers($_POST['userId']);
if ($data) {
foreach ($data as $key => $user) {
//add history
Model_History::addHistory($user["user_id"], Model_History::COMMENTUSER, $request->getPost('agenda'));
}
}
$return = array('agenda' => $request->getPost('agenda'));
} else {
//no existe la sesión / no existe el dato recibido por post / el token no es igual.
$return = array('error' => 401, 'description' => $this->translate('wrong token'));
}
if ($callback) {
$return = $callback . '(' . JO_Json::encode($return) . ')';
} else {
$response->addHeader('Cache-Control: no-cache, must-revalidate');
$response->addHeader('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
$response->addHeader('Content-type: application/json');
$return = JO_Json::encode($return);
}
$response->appendBody($return);
}
public function createAction()
{
$request = $this->getRequest();
// if(!$request->isXmlHttpRequest()) {
// $this->forward('error', 'error404');
// }
if ($request->isPost()) {
if (JO_Session::get('user[user_id]')) {
if (trim($request->getPost('newboard'))) {
if (trim($request->getPost('newboard')) != $this->translate('Nombre de la carpeta') && trim($request->getPost('newboard')) != $this->translate('Create New Board')) {
if (trim($request->getPost('category_id'))) {
$data = Model_Boards::createBoard(array('title' => trim($request->getPost('newboard')), 'category_id' => $request->getPost('category_id'), 'friends' => $request->getPost('friends')));
if ($data) {
if (is_array($request->getPost('friends'))) {
foreach ($request->getPost('friends') as $fr) {
$this->view->uinfo = Model_Users::getUser($fr);
$this->view->board_href = $data['href'] = WM_Router::create($request->getBaseUrl() . '?controller=boards&action=view&user_id=' . JO_Session::get('user[user_id]') . '&board_id=' . $data['board_id']);
$this->view->board_name = trim($request->getPost('newboard'));
$this->view->author_href = $data['href'] = WM_Router::create($request->getBaseUrl() . '?controller=users&action=profile&user_id=' . JO_Session::get('user[user_id]'));
$this->view->author_name = JO_Session::get('firstname') . ' ' . JO_Session::get('lastname');
// print_R(JO_Session::getAll());
$result = Model_Email::send($this->view->uinfo['email'], JO_Registry::get('noreply_mail'), $this->translate('You have been invited to pin on ' . trim($request->getPost('newboard'))), $this->view->render('board_invite', 'mail'));
}
}
Model_History::addHistory(0, Model_History::ADDBOARD, 0, $data['board_id']);
$data['href'] = WM_Router::create($request->getBaseUrl() . '?controller=boards&action=view&user_id=' . JO_Session::get('user[user_id]') . '&board_id=' . $data['board_id']);
$this->view->data = $data;
} else {
$this->view->error = $this->translate('There was a problem with the record. Please try again!');
}
} else {
$this->view->error = $this->translate('Debe seleccionar una categoría para la carpeta');
}
} else {
$this->view->error = $this->translate('Board name must not be empty!');
}
} else {
$this->view->error = $this->translate('Board name must not be empty!');
}
} else {
$this->view->error = 'error login';
}
echo $this->renderScript('json');
} else {
$avatar = Helper_Uploadimages::avatar(JO_Session::get('user'), '_A');
$this->view->avatar = $avatar['image'];
$this->view->fullname = JO_Session::get('user[fullname]');
$this->view->userhref = WM_Router::create($request->getBaseUrl() . '?controller=users&action=profile&user_id=' . JO_Session::get('user[user_id]'));
$this->view->friends_href = WM_Router::create($request->getBaseUrl() . '?controller=users&action=friends');
$this->view->form_action = WM_Router::create($request->getBaseUrl() . '?controller=boards&action=create');
//////////// Categories ////////////
$this->view->categories = array();
$categories = Model_Categories::getCategories(array('filter_status' => 1));
foreach ($categories as $category) {
$category['subcategories'] = Model_Categories::getSubcategories($category['category_id']);
$this->view->categories[] = $category;
}
$this->view->popup_main_box = $this->view->render('popup_form', 'boards');
$this->setViewChange('form');
if ($request->isXmlHttpRequest()) {
$this->view->popup = true;
echo $this->view->popup_main_box;
$this->noViewRenderer(true);
} else {
$this->view->children = array('header_part' => 'layout/header_part', 'footer_part' => 'layout/footer_part', 'left_part' => 'layout/left_part');
}
}
}
