public function repinAction()
{
$request = $this->getRequest();
$pin_id = $request->getRequest('pin_id');
$pin_info = new Model_Pins_Pin($pin_id);
if (!$pin_info->count()) {
$this->forward('error', 'error404');
}
$pin_info = $pin_info->data;
$model_images = new Helper_Images();
$this->view->title = $pin_info['pin_title'];
$this->view->price = $pin_info['pin_price'];
$pin_info['pin_id'] = $pin_info['pin_pin_id'];
$this->view->images = Helper_Uploadimages::pinThumbs($pin_info);
$this->view->pin_gallery = array();
$gallery = new Model_Pins_Gallery($pin_info['pin_pin_id']);
if ($gallery->count()) {
$this->view->pin_gallery[] = $this->view->images;
foreach ($gallery->data as $gal) {
$this->view->pin_gallery[] = Helper_Uploadimages::pinThumbs(array('pin_pin_id' => $gal['pin_id'], 'pin_store' => $gal['store'], 'gallery_id' => $gal['gallery_id'], 'pin_image' => $gal['image']));
}
}
$this->view->is_video = $pin_info['pin_is_video'] ? 'true' : 'false';
// $this->view->from = $pin_info['pin_from'];
$this->view->from = WM_Router::create($request->getBaseUrl() . '?controller=boards&action=view&user_id=' . $pin_info['board_user_id'] . '&board_id=' . $pin_info['board_board_id']);
$this->view->from_repin = $pin_info['pin_from'];
$this->view->description = $pin_info['pin_description'];
$this->view->via = $pin_info['pin_user_id'];
$this->view->pin_id = $pin_info['pin_pin_id'];
if ($pin_info['pin_gift']) {
$this->view->formated_price = WM_Currency::format($pin_info['pin_price']);
}
//$this->view->from_url = WM_Router::create( $request->getBaseUrl() . '?controller=pin&action=repin&pin_id=' . $pin_id );
$this->view->from_url = WM_Router::create($request->getBaseUrl() . '?controller=pin&action=createpin');
$this->view->createBoard = WM_Router::create($request->getBaseUrl() . '?controller=boards&action=createboardwithoutcategory');
$boards = new Model_Boards_BoardsWithShared(array('filter_user_id' => JO_Session::get('user[user_id]')));
$this->view->boards = array();
if ($boards->count()) {
foreach ($boards as $board) {
$this->view->boards[] = array('board_id' => $board['board_board_id'], 'title' => $board['board_title']);
}
}
///////////////// Extension on create //////////////////
$this->view->form_extensions = array();
$extensions = Model_Extensions::getByMethod('pin_onrepinform');
if ($extensions) {
$front = JO_Front::getInstance();
foreach ($extensions as $id => $ext) {
$this->view->form_extensions[] = array('html' => $this->view->callChildren('modules_' . $ext . '_onrepinform'), 'view' => $this->view->callChildrenView('modules_' . $ext . '_onrepinform'), 'key' => $ext);
}
}
$this->noLayout(true);
}
public function __construct($pin_id)
{
$db = JO_Db::getDefaultAdapter();
try {
$db->beginTransaction();
$pin_info = new Model_Pins_Pin($pin_id);
if (!$pin_info->count()) {
return $this;
}
$pin_info = $pin_info->data;
$result = null;
if ($pin_info['pin_image']) {
$res = Helper_Db::create('pins_images_for_delete', array('pin_id' => $pin_info['pin_pin_id'], 'date_added' => $pin_info['pin_date_added'], 'image' => $pin_info['pin_image'], 'store' => $pin_info['pin_store'], 'gallery_id' => 0));
if (!$result) {
$result = $res;
}
}
$gallery = new Model_Pins_Gallery($pin_info['pin_pin_id']);
if ($gallery->count()) {
foreach ($gallery->data as $gal) {
$res = Helper_Db::create('pins_images_for_delete', array('pin_id' => $gal['pin_id'], 'date_added' => $pin_info['pin_date_added'], 'image' => $gal['image'], 'store' => $gal['store'], 'gallery_id' => $gal['gallery_id']));
if (!$result) {
$result = $res;
}
}
}
if ($pin_info['pin_comments']) {
$comments = Model_Comments::getComments2(array('filter_pin_id' => $pin_id));
foreach ($comments as $comment) {
$del = new Model_Pins_DeleteComment($comment['comment_id']);
if (!$result) {
$result = $del->affected_rows;
}
}
}
$res = Helper_Db::delete('pins', array('pin_id = ?' => $pin_id));
if (!$result) {
$result = $res;
}
$res = Helper_Db::delete('pins_invert', array('pin_id = ?' => $pin_id));
if (!$result) {
$result = $res;
}
if ($pin_info['pin_likes']) {
$res = Helper_Db::delete('pins_likes', array('pin_id = ?' => $pin_id));
if (!$result) {
$result = $res;
}
}
$res = Helper_Db::delete('pins_reports', array('pin_id = ?' => $pin_id));
if (!$result) {
$result = $res;
}
$res = Helper_Db::delete('pins_views', array('pin_id = ?' => $pin_id));
if (!$result) {
$result = $res;
}
$res = Helper_Db::delete('users_history', array('pin_id = ?' => $pin_id));
if (!$result) {
$result = $res;
}
$res = Helper_Db::delete('pins_images', array('pin_id = ?' => $pin_id));
if (!$result) {
$result = $res;
}
$res = Helper_Db::update('users', array('likes' => new JO_Db_Expr('(' . $db->select()->from('pins_likes', 'COUNT(like_id)')->where('pin_id IN (?)', new JO_Db_Expr('(' . $db->select()->from('pins', 'pin_id')->where('user_id = ?', $pin_info['user_user_id']) . ')'))->limit(1) . ')')), array('user_id=?' => $pin_info['user_user_id']));
if (!$result) {
$result = $res;
}
///////////////// update latest pins for user and board /////////////////////
new Model_Users_UpdateLatestPins($pin_info['user_user_id']);
new Model_Boards_UpdateLatestPins($pin_info['board_board_id']);
///////////////// Extension on delete //////////////////
$extensions = Model_Extensions::getByMethod('pin_ondelete');
if ($extensions) {
$front = JO_Front::getInstance();
foreach ($extensions as $id => $ext) {
$res = call_user_func(array($front->formatModuleName('model_' . $ext . '_pin'), 'ondelete'), $pin_id);
if (!$result) {
$result = $res;
}
}
}
$this->affected_rows = $result;
$db->commit();
} catch (JO_Exception $e) {
$db->rollBack();
}
}
public static function formatPinData($pin, $detail = false)
{
static $model_images = null, $request = null;
if ($model_images === null) {
$model_images = new Helper_Images();
}
if ($request === null) {
$request = JO_Request::getInstance();
}
///////////////////////////////////// PIN INFO /////////////////////////////////////
$pin['pin_id'] = $pin['pin_pin_id'];
$pin['image'] = $pin['pin_image'];
//url's
$pin['pin_url_embed'] = WM_Router::pinAction($pin['pin_pin_id'], 'embed');
if (!JO_Session::get('user[user_id]')) {
$login_url = WM_Router::create($request->getBaseUrl() . '?controller=users&action=login');
if (Helper_Config::get('enable_free_registration')) {
//$login_url = WM_Router::create( $request->getBaseUrl() . '?controller=users&action=register' );
}
$pin['pin_url_email'] = $pin['pin_url_report'] = $pin['pin_url_like'] = $pin['pin_url_repin'] = $pin['pin_url_comment'] = $login_url;
$pin['pin_edit'] = false;
} else {
$pin['pin_url_email'] = WM_Router::pinAction($pin['pin_pin_id'], 'email');
$pin['pin_url_report'] = WM_Router::pinAction($pin['pin_pin_id'], 'report');
$pin['pin_url_like'] = WM_Router::pinAction($pin['pin_pin_id'], 'like');
$pin['pin_url_repin'] = WM_Router::pinAction($pin['pin_pin_id'], 'repin');
$pin['pin_url_comment'] = WM_Router::pinAction($pin['pin_pin_id']);
$pin['pin_edit'] = JO_Session::get('user[user_id]') == $pin['pin_user_id'] ? WM_Router::pinAction($pin['pin_pin_id'], 'edit') : false;
}
//$pin['pin_description'] = self::descriptionFix($pin['pin_description']);
$pin['pin_href'] = WM_Router::pinAction($pin['pin_pin_id']);
if ($pin['pin_gift']) {
$pin['pin_price_formated'] = WM_Currency::format($pin['pin_price']);
} else {
$pin['pin_price_formated'] = 0;
}
//return all image sizes
$pin['pin_thumbs'] = Helper_Uploadimages::pinThumbs($pin);
//array_merge($pin, Helper_Uploadimages::pinThumbs($pin));
$date_dif = array_shift(WM_Date::dateDiff($pin['pin_date_added'], time()));
$pin['pin_date_dif'] = $date_dif;
/* URL'S*/
$pin['pin_onto_href'] = WM_Router::create($request->getBaseUrl() . '?controller=boards&action=view&user_id=' . $pin['board_user_id'] . '&board_id=' . $pin['board_board_id']);
////follow urls
$pin['board_follow_href'] = $pin['user_follow_href'] = $pin['via_follow_href'] = false;
if (JO_Session::get('user[user_id]') ? $pin['board_user_id'] != JO_Session::get('user[user_id]') : false) {
$pin['board_follow_href'] = WM_Router::create($request->getBaseUrl() . '?controller=boards&action=follow&user_id=' . $pin['board_user_id'] . '&board_id=' . $pin['board_board_id']);
}
if (JO_Session::get('user[user_id]') ? $pin['user_user_id'] != JO_Session::get('user[user_id]') : false) {
$pin['user_follow_href'] = WM_Router::create($request->getBaseUrl() . '?controller=users&action=follow&user_id=' . $pin['user_user_id']);
}
if ($pin['via_user_id']) {
if (JO_Session::get('user[user_id]') ? $pin['via_user_id'] != JO_Session::get('user[user_id]') : false) {
$pin['via_follow_href'] = WM_Router::create($request->getBaseUrl() . '?controller=users&action=follow&user_id=' . $pin['via_user_id']);
}
} else {
if (JO_Session::get('user[user_id]') ? $pin['user_user_id'] != JO_Session::get('user[user_id]') : false) {
$pin['via_follow_href'] = $pin['user_follow_href'];
}
}
if ($detail) {
$pin['pin_next_href'] = '';
if (isset($pin['pin_next']) && $pin['pin_next']) {
$pin['pin_next_href'] = WM_Router::pinAction($pin['pin_next']);
}
$pin['pin_prev_href'] = '';
if (isset($pin['pin_prev']) && $pin['pin_prev']) {
$pin['pin_prev_href'] = WM_Router::pinAction($pin['pin_prev']);
}
}
if (Helper_Config::get('config_comments_list') && !$detail && $pin['pin_comments']) {
$latest_comments = Model_Comments::getLatestComments2($pin['pin_latest_comments']);
$pin['pin_latest_comments'] = array();
$user_id = JO_Session::get('user[user_id]');
$is_admin = JO_Session::get('user[is_admin]');
$is_developer = JO_Session::get('user[is_developer]');
foreach ($latest_comments as $key => $comment) {
$user_avatars = Helper_Uploadimages::userAvatars(array('avatar' => $comment['avatar'], 'store' => $comment['store'], 'user_id' => $comment['user_id']));
$enable_delete = false;
if ($is_admin) {
$enable_delete = true;
} elseif ($is_developer) {
$enable_delete = true;
} elseif ($user_id == $comment['user_id']) {
$enable_delete = true;
} elseif ($comment['pin_user_id'] == $user_id) {
$enable_delete = true;
}
$delete = false;
if ($enable_delete) {
$delete = WM_Router::create($request->getBaseUrl() . '?controller=pin&action=deleteComment&comment_id=' . $comment['comment_id']);
}
$pin['pin_latest_comments'][] = array('user' => array('profile' => WM_Router::create($request->getBaseUrl() . '?controller=users&action=profile&user_id=' . $comment['user_id']), 'avatars' => $user_avatars, 'fullname' => $comment['fullname']), 'comment' => $comment['comment'], 'delete' => $delete);
}
} else {
$pin['pin_latest_comments'] = array();
}
$pin['pin_video_code'] = false;
if ($detail) {
if ($pin['pin_is_video']) {
$auto = new Helper_AutoEmbed();
if ($pin['pin_repin_from'] && $auto->parseUrl($pin['pin_from_repin'])) {
$auto->setWidth('100%');
$auto->setHeight('350');
$pin['pin_video_code'] = $auto->getEmbedCode();
} else {
if ($auto->parseUrl($pin['pin_from'])) {
$auto->setWidth('100%');
$auto->setHeight('350');
$pin['pin_video_code'] = $auto->getEmbedCode();
} else {
$pin['pin_is_video'] = false;
}
}
} else {
$auto = new Helper_AutoEmbed();
if ($pin['pin_repin_from'] && $auto->parseUrl($pin['pin_from_repin'])) {
$auto->setWidth('100%');
$auto->setHeight('350');
$pin['pin_video_code'] = $auto->getEmbedCode();
$pin['pin_is_video'] = true;
} else {
if ($auto->parseUrl($pin['pin_from'])) {
$auto->setWidth('100%');
$auto->setHeight('350');
$pin['pin_video_code'] = $auto->getEmbedCode();
$pin['pin_is_video'] = true;
} else {
$pin['pin_is_video'] = false;
}
}
}
$pin['pin_gallery'] = array();
$gallery = new Model_Pins_Gallery($pin['pin_pin_id']);
if ($gallery->count()) {
foreach ($gallery->data as $gal) {
$pin['pin_gallery'][] = Helper_Uploadimages::pinThumbs(array('pin_pin_id' => $gal['pin_id'], 'pin_store' => $gal['store'], 'gallery_id' => $gal['gallery_id'], 'pin_image' => $gal['image']));
}
}
}
///////////////////////////////////// AUTHOR INFO /////////////////////////////////////
//return author all images
$user_data = array('avatar' => $pin['user_avatar'], 'store' => $pin['user_store'], 'user_id' => $pin['user_user_id']);
foreach ($pin as $k => $v) {
if (strpos($k, 'user_avatar_') === 0) {
$user_data[$k] = $v;
}
}
$pin['user_avatars'] = Helper_Uploadimages::userAvatars($user_data);
$pin['user_href'] = WM_Router::create($request->getBaseUrl() . '?controller=users&action=profile&user_id=' . $pin['user_user_id']);
///////////////////////////////////// VIA INFO /////////////////////////////////////
$pin['via_profile'] = array();
if ($pin['via_user_id']) {
$via_avatars = Helper_Uploadimages::userAvatars(array('avatar' => $pin['via_avatar'], 'store' => $pin['via_store'], 'user_id' => $pin['via_user_id']));
$pin['via_profile'] = array('avatars' => $via_avatars, 'profile' => WM_Router::create($request->getBaseUrl() . '?controller=users&action=profile&user_id=' . $pin['via_user_id']), 'fullname' => $pin['via_fullname']);
}
///////////////////////////////////// SELF INFO /////////////////////////////////////
$pin['self_profile'] = false;
if (JO_Session::get('user[user_id]')) {
$user_avatars = Helper_Uploadimages::userAvatars(array('avatar' => JO_Session::get('user[avatar]'), 'store' => JO_Session::get('user[store]'), 'user_id' => JO_Session::get('user[user_id]')));
$pin['self_profile']['avatars'] = $user_avatars;
$pin['self_profile']['fullname'] = JO_Session::get('user[fullname]');
$pin['self_profile']['profile'] = WM_Router::create($request->getBaseUrl() . '?controller=users&action=profile&user_id=' . JO_Session::get('user[user_id]'));
}
///////////////////////////////////// SOURCE INFO /////////////////////////////////////
$pin['pin_source'] = array();
$pin['pin_target_repin'] = false;
if ($detail) {
if ($pin['pin_repin_from']) {
$pin_repin = new Model_Pins_Pin($pin['pin_repin_from']);
if ($pin_repin->count()) {
$pin_repin = $pin_repin->data;
$pin['pin_source']['source'] = $pin_repin['board_title'];
$pin['pin_from'] = WM_Router::create($request->getBaseUrl() . '?controller=boards&action=view&user_id=' . $pin_repin['user_user_id'] . '&board_id=' . $pin_repin['board_board_id']);
$pin['pin_target_repin'] = true;
} else {
$source = new Model_Sources_Source($pin['pin_source_id']);
if ($source->count()) {
$pin['pin_source']['source'] = $source['source'];
}
}
} else {
$source = new Model_Sources_Source($pin['pin_source_id']);
if ($source->count()) {
$pin['pin_source']['source'] = $source['source'];
}
}
}
///for mobile
$pin['mobile_upload'] = false;
if ($pin['pin_from'] == 'Mobile') {
$pin['pin_from'] = '';
$pin['mobile_upload'] = true;
}
return $pin;
}
