public static function generateSourceQuery($source_id)
{
$info = new Model_Sources_Source($source_id);
if (!$info->count()) {
return;
}
if (trim($info['source'])) {
$slug = $uniqueSlug = self::clear($info['source']);
} else {
$slug = $uniqueSlug = 'source';
}
$index = 1;
Helper_Db::delete('url_alias', array('query = ?' => 'source_id=' . $source_id));
while (self::getTotalKey($uniqueSlug)) {
$uniqueSlug = $slug . '-' . $index++;
}
if (Helper_Db::insert('url_alias', array('query' => 'source_id=' . (int) $source_id, 'keyword' => $uniqueSlug, 'path' => $uniqueSlug, 'route' => 'source/index'))) {
return $uniqueSlug;
} else {
return false;
}
}
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;
}
