/**
* @param string|object $object
* @return multitype:
*/
public static function getControllerResources($controller)
{
$front = JO_Front::getInstance();
$controller_name = $front->formatControllerName($controller);
if ($front->isDispatchable($controller)) {
JO_Loader::setIncludePaths(array($front->getDispatchDirectory()));
JO_Loader::loadFile($front->classToFilename($controller_name), null, true);
if (version_compare(PHP_VERSION, '5.2.6') === -1) {
$class = new ReflectionObject(new $controller_name());
$classMethods = $class->getMethods();
$methodNames = array();
foreach ($classMethods as $method) {
$methodNames[] = $method->getName();
}
} else {
$methodNames = get_class_methods(new $controller_name());
}
$_classResources = array();
foreach ($methodNames as $method) {
if (6 < strlen($method) && 'Action' === substr($method, -6)) {
$_classResources[substr($method, 0, -6)] = substr($method, 0, -6);
}
}
return $_classResources;
}
return array();
}
/**
* @return JO_Front
*/
public function getFrontController()
{
if ($this->front == null) {
$this->setFrontController(JO_Front::getInstance());
}
return $this->front;
}
/**
* @param array $options
* @return JO_Front
*/
public static function getInstance($options = array())
{
if (self::$_instance == null) {
self::$_instance = new self($options);
}
return self::$_instance;
}
public function __construct()
{
$request = JO_Request::getInstance();
parent::__construct();
if (Model_Allowips::getTotalWords()) {
if (!Model_Allowips::getTotalWords(array('filete_ip' => $request->getClientIp()))) {
if (!in_array($request->getController(), array('login', 'error'))) {
$this->forward('error', 'noPermission');
}
}
}
//set default timezone if is not set
if (!ini_get('date.timezone')) {
ini_set('date.timezone', 'UTC');
}
WM_Users::initSession(JO_Session::get('user[user_id]'));
if (!JO_Session::get('user[user_id]')) {
JO_Session::set('user', array('user_id' => 0));
}
//admin check login
$login_page = $request->getController() != 'login';
if (JO_Session::get('user[is_developer]')) {
$login_page = false;
} else {
if (JO_Session::get('user[is_admin]')) {
$login_page = false;
}
}
if (in_array($request->getController(), array('login', 'error'))) {
$login_page = false;
}
if ($login_page) {
$this->forward('login', 'index');
}
//admin top menu
Helper_Config::set('adminmenupermisions', WM_Users::initPermision());
//no permisions
$controller_name = JO_Front::getInstance()->formatControllerName($request->getController());
if (!class_exists($controller_name, false)) {
JO_Loader::loadFile(APPLICATION_PATH . '/modules/' . $request->getModule() . '/controllers/' . JO_Front::getInstance()->classToFilename($controller_name));
}
if (method_exists($controller_name, 'config')) {
$data = call_user_func(array($controller_name, 'config'));
if (isset($data['has_permision']) && $data['has_permision'] && !WM_Users::allow('read', $request->getController())) {
$this->forward('error', 'noPermission');
}
}
WM_Rebuild::getInformation();
WM_Licensecheck::checkIt();
}
private function getReserved()
{
$array = array();
$array['admin'] = 'admin';
$array['default'] = 'default';
$front = JO_Front::getInstance()->getModuleDirectoryWithDefault('default/controllers');
foreach (WM_Modules::getControllersWithFolders($front) as $controller) {
$controllerName = JO_Front::getInstance()->formatControllerName($controller);
$array[$controller] = $controller;
$array = array_merge($array, WM_Modules::getControllerActions($controllerName, $front));
}
$array = JO_Utf8::array_change_key_case_unicode($array);
return $array;
}
public function renameIfExist($uniqueSlug)
{
$db = JO_Db::getDefaultAdapter();
$query = $db->select()->from('url_alias', array('keyword', 'keyword'))->where('keyword = ?', $uniqueSlug)->orWhere('keyword LIKE ?', $uniqueSlug . '-%');
$array = $db->fetchPairs($query);
foreach (WM_Modules::getControllersWithFolders() as $controller) {
$controllerName = JO_Front::getInstance()->formatControllerName($controller);
$array[$controller] = $controller;
$array = array_merge($array, WM_Modules::getControllerActions($controllerName));
}
$array['admin'] = 'admin';
$array['default'] = 'default';
$array['board'] = 'board';
$array = JO_Utf8::array_change_key_case_unicode($array);
return $this->rename_if_exists($array, mb_strtolower($uniqueSlug, 'utf-8'));
}
public static function getConfig()
{
$modules_path = rtrim(JO_Front::getInstance()->getModuleDirectory(), '/');
$list = glob($modules_path . '/*');
$modules = array();
if ($list) {
foreach ($list as $dir) {
if (!in_array(basename($dir), array('admin', 'update', 'install'))) {
if (file_exists($dir . '/config.ini')) {
$config = new JO_Config_Ini($dir . '/config.ini');
$modules[basename($dir)] = $config->toArray();
}
}
}
}
return $modules;
}
public function getTotalKey($keyword)
{
$db = JO_Db::getDefaultAdapter();
$array = array();
$array['admin'] = 'admin';
$array['default'] = 'default';
$front = JO_Front::getInstance()->getModuleDirectoryWithDefault('default/controllers');
foreach (WM_Modules::getControllersWithFolders($front) as $controller) {
$controllerName = JO_Front::getInstance()->formatControllerName($controller);
$array[$controller] = $controller;
$array = array_merge($array, WM_Modules::getControllerActions($controllerName, $front));
}
$array = JO_Utf8::array_change_key_case_unicode($array);
if (isset($array[mb_strtolower($keyword, 'utf-8')])) {
return 1;
}
$query = $db->select()->from('url_alias', new JO_Db_Expr('COUNT(url_alias_id)'))->where("LOWER(keyword) = ?", (string) mb_strtolower($keyword, 'utf-8'));
return $db->fetchOne($query);
}
public function noPermissionAction()
{
$request = JO_Request::getInstance();
$forwarded = $request->getParam('forwarded');
if (!$forwarded) {
$forwarded = $request->getController();
}
$controller_name = JO_Front::getInstance()->formatControllerName($forwarded);
if (!class_exists($controller_name, false)) {
JO_Loader::loadFile(APPLICATION_PATH . '/modules/' . $request->getModule() . '/controllers/' . JO_Front::getInstance()->classToFilename($controller_name));
}
if (method_exists($controller_name, 'config')) {
$data = call_user_func(array($controller_name, 'config'));
if (isset($data['name']) && $data['name']) {
$controller_name = $data['name'];
}
}
$this->view->moduleName = $controller_name;
$this->view->fullUrl = $request->getFullUrl();
}
public function steptwoAction()
{
$this->noLayout(true);
$request = $this->getRequest();
if (JO_Session::get('user[user_id]')) {
if (JO_Session::get('upload_from_file') && file_exists(BASE_PATH . JO_Session::get('upload_from_file'))) {
///////////////// Extension on create //////////////////
$this->view->form_extensions = array();
$extensions = Model_Extensions::getByMethod('pin_oncreateform');
if ($extensions) {
$front = JO_Front::getInstance();
foreach ($extensions as $id => $ext) {
$this->view->form_extensions[] = array('html' => $this->view->callChildren('modules_' . $ext . '_oncreateform'), 'view' => $this->view->callChildrenView('modules_' . $ext . '_oncreateform'), 'key' => $ext);
}
}
$this->view->createBoard = WM_Router::create($request->getBaseUrl() . '?controller=boards&action=createboardwithoutcategory');
$temporary = '/cache/review/';
$upload_folder = BASE_PATH . $temporary;
$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']);
}
}
$this->view->form_action = WM_Router::create($request->getBaseUrl() . '?controller=addpin_fromfile&action=upload_images');
$this->view->upload_action = WM_Router::create($request->getBaseUrl() . '?controller=addpin_fromfile&action=steptwo');
$this->view->from_url = WM_Router::create($request->getBaseUrl() . '?controller=pin&action=createpin');
$this->view->file = JO_Session::get('upload_from_file_name');
$this->view->full_path = $request->getBaseUrl() . JO_Session::get('upload_from_file');
} else {
$this->forward('addpin_fromfile', 'stepone', $this->translate('We couldn\'t find any images'));
}
} else {
$this->redirect(WM_Router::create($request->getBaseUrl() . '?controller=users&action=login'));
// $this->view->redirect = WM_Router::create( $request->getBaseUrl() . '?controller=users&action=login' );
}
}
public function checkJsCss($part)
{
static $front = null;
if ($front === null) {
$front = JO_Front::getInstance();
}
if (preg_match('/^(.*).(js|css)$/i', $part, $match)) {
if ($front->isDispatchable($match[2]) && in_array($match[1], WM_Modules::getControllerResources($match[2]))) {
JO_Request::getInstance()->setController($match[2])->setAction($match[1]);
return true;
} else {
return false;
}
} elseif (preg_match('/^(.*).(json)$/i', $part, $match)) {
if ($front->isDispatchable($match[2])) {
JO_Request::getInstance()->setController($match[2])->setAction($match[1]);
return true;
} else {
return false;
}
}
return false;
}
public function steptwoAction()
{
$request = $this->getRequest();
$this->noLayout(true);
if (JO_Session::get('user[user_id]')) {
$files = JO_Session::get('gallery_upload_images');
if ($files) {
$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']);
}
}
$imageObject = new Helper_Images();
$this->view->images = array();
foreach ($files as $file) {
$this->view->images[] = array('src' => $request->getBaseUrl() . $file['path'] . $file['tmp_name'], 'thumb' => $imageObject->resize('/../' . $file['path'] . $file['tmp_name'], 75, 75, true));
}
///////////////// Extension on create //////////////////
$this->view->form_extensions = array();
$extensions = Model_Extensions::getByMethod('pin_oncreateform');
if ($extensions) {
$front = JO_Front::getInstance();
foreach ($extensions as $id => $ext) {
$this->view->form_extensions[] = array('html' => $this->view->callChildren('modules_' . $ext . '_oncreateform'), 'view' => $this->view->callChildrenView('modules_' . $ext . '_oncreateform'), 'key' => $ext);
}
}
} else {
$this->forward('addpin_gallery', 'stepone', true);
}
} else {
$this->redirect(WM_Router::create($request->getBaseUrl() . '?controller=users&action=login'));
}
}
public function __construct($pin_id, $data = array())
{
$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;
if (isset($data['board_id'])) {
$board_info = new Model_Boards_Board($data['board_id']);
if ($board_info->count()) {
$data['board_id'] = $board_info['board_board_id'];
$data['category_id'] = $board_info['board_category_id'];
$data['public'] = $board_info['board_public'];
} else {
$data['board_id'] = 0;
}
}
$data['likes'] = new JO_Db_Expr('(SELECT COUNT(DISTINCT user_id) FROM pins_likes WHERE pin_id = pins.pin_id)');
$data['comments'] = new JO_Db_Expr('(SELECT COUNT(DISTINCT comment_id) FROM pins_comments WHERE pin_id = pins.pin_id)');
$data['date_modified'] = WM_Date::format(time(), 'yy-mm-dd H:i:s');
$data['source_id'] = 0;
//sorce
if (isset($data['from']) && $data['from']) {
$source = new Model_Sources_GetSourceByUrl($data['from']);
if ($source->source_id) {
$data['source_id'] = $source->source_id;
}
}
$data['from_md5'] = md5(isset($data['from']) ? $data['from'] : time());
/* price */
//$data['price'] = 0;
if (isset($data['price']) && $data['price']) {
$currencies = WM_Currency::getCurrencies();
$price_left = array();
$price_right = array();
if ($currencies) {
foreach ($currencies as $currency) {
if (trim($currency['symbol_left'])) {
$price_left[] = preg_quote(trim($currency['symbol_left']));
}
if (trim($currency['symbol_right'])) {
$price_right[] = preg_quote(trim($currency['symbol_right']));
}
}
if ($price_left) {
if (preg_match('/(' . implode('|', $price_left) . ')([\\s]{0,2})?(?:(?:\\d{1,5}(?:\\,\\d{3})+)|(?:\\d+))(?:\\.\\d{2})?/', $data['price'], $match)) {
$price_tmp = trim(str_replace(trim($match[1]), '', $match[0]));
$currency = self::getCurrencyBySimbol(trim($match[1]));
if ($currency) {
$data['price'] = round($price_tmp / $currency, 4);
}
}
}
if (!$data['price'] && $price_right) {
if (preg_match('/(?:(?:\\d{1,5}(?:\\,\\d{3})+)|(?:\\d+))(?:\\.\\d{2})?([\\s]{0,2})?(' . implode('|', $price_right) . ')/', $data['price'], $match)) {
$price_tmp = trim(str_replace(trim($match[2]), '', $match[0]));
$currency = self::getCurrencyBySimbol(trim($match[2]));
if ($currency) {
$data['price'] = round($price_tmp / $currency, 4);
}
}
}
}
}
/* end price */
$from = isset($data['from']) ? $data['from'] : time();
$data['is_video'] = isset($data['is_video']) && $data['is_video'] == 'true' ? 1 : 0;
if (!$data['is_video']) {
$auto = new Helper_AutoEmbed();
if ($auto->parseUrl($from)) {
$data['is_video'] = 1;
}
}
/* is video */
///////////////// Event onComplete /////////////////////
$on_add_call = Helper_Config::get('pin_onbefore_edit');
if ($on_add_call) {
foreach ($on_add_call as $call) {
call_user_func($call, $data);
}
}
//edit pin
$result = Helper_Db::update('pins', $data, array('pin_id = ?' => $pin_id));
///////////////// update latest pins for board /////////////////////
if (isset($data['board_id']) && $data['board_id'] && $pin_info['pin_board_id'] != $data['board_id']) {
new Model_Boards_UpdateLatestPins($data['board_id']);
new Model_Boards_UpdateLatestPins($pin_info['pin_board_id']);
$board_info = new Model_Boards_Board($data['board_id']);
if ($board_info->count()) {
if ($board_info['board_cover'] == $pin_id) {
$res = Helper_Db::update('boards', array('cover' => 0), array('board_id = >' => $pin_info['pin_board_id']));
if (!$result && $res) {
$result = $res;
}
}
}
}
///////////////// update latest pins for user /////////////////////
new Model_Users_UpdateLatestPins($pin_info['pin_user_id']);
///////////////// Word for search index's /////////////////////
$spl = JO_Utf8::str_word_split(strip_tags(html_entity_decode($data['description'], ENT_QUOTES, 'utf-8')), self::$searchWordLenght);
$words = array();
foreach ($spl as $word) {
$word = mb_strtolower($word, 'utf-8');
if (!in_array($word, self::blackWordsDictionary()) && $word[0] . $word[1] != '&#') {
$words[$word] = $word;
}
}
///////////////// Word for search index's insert /////////////////////
Helper_Db::delete('pins_invert', array('pin_id = ?' => $pin_id));
foreach ($words as $word => $data1) {
$dic_id = $db->fetchOne($db->select()->from('pins_dictionary', 'dic_id')->where('word = ?', $word));
if (!$dic_id) {
$dic_id = Helper_Db::insert('pins_dictionary', array('word' => $word));
}
if ($dic_id) {
$res = Helper_Db::insert('pins_invert', array('pin_id' => $pin_id, 'dic_id' => $dic_id));
if (!$result && $res) {
$result = $res;
}
}
}
///////////////// Extension on edit //////////////////
$extensions = Model_Extensions::getByMethod('pin_onedit');
if ($extensions) {
$front = JO_Front::getInstance();
foreach ($extensions as $id => $ext) {
$pin_data_ext = call_user_func(array($front->formatModuleName('model_' . $ext . '_pin'), 'onedit'), $pin_id, $data);
if ($pin_data_ext && is_array($pin_data_ext)) {
$data = array_merge(data, $pin_data_ext);
}
}
}
///////////////// Event onComplete /////////////////////
$trigger = new Helper_Triggers_PinOnEdit();
$trigger->bind($pin_id);
$this->affected_rows = $result;
$db->commit();
} catch (JO_Exception $e) {
echo $e;
exit;
$db->rollBack();
}
}
public function uninstallAction()
{
$request = $this->getRequest();
$extensions = array();
$files = glob(dirname(__FILE__) . '/Extensions/*.php');
if ($files) {
foreach ($files as $file) {
if (preg_match('/^([\\w]{1,})Controller$/i', basename($file, '.php'), $match)) {
$extensions[] = mb_strtolower($match[1], 'utf-8');
}
}
}
$extension = $request->getQuery('extension');
if (in_array($extension, $extensions)) {
$res = Model_Extensions::uninstall($extension);
if ($res) {
$module_name = JO_Front::getInstance()->formatModuleName('model_extensions_' . $extension);
$file_model = APPLICATION_PATH . '/modules/' . $request->getModule() . '/' . JO_Front::getInstance()->classToFilename($module_name);
if (file_exists($file_model)) {
if (!class_exists($module_name, false)) {
JO_Loader::loadFile($file_model);
}
if (method_exists($module_name, 'uninstall')) {
call_user_func(array($module_name, 'uninstall'));
}
} else {
$module_name = JO_Front::getInstance()->formatControllerName('extensions_' . $extension);
$file_model = APPLICATION_PATH . '/modules/' . $request->getModule() . '/controllers/' . JO_Front::getInstance()->classToFilename($module_name);
if (file_exists($file_model)) {
if (!class_exists($module_name, false)) {
JO_Loader::loadFile($file_model);
}
if (method_exists($module_name, 'uninstall')) {
call_user_func(array($module_name, 'uninstall'));
}
}
}
$this->session->set('successfu_edite', true);
}
}
$this->redirect($this->getRequest()->getBaseUrl() . $this->getRequest()->getModule() . '/extensions/');
}
private function uploadsMethods()
{
$front = JO_Front::getInstance();
$modules_path = rtrim($front->getDispatchDirectory(), '/');
$list = glob($modules_path . '/Upload/*Controller.php');
$methods = array();
if ($list) {
foreach ($list as $controller) {
$methods[] = strtolower(basename($controller, 'Controller.php'));
}
}
return $methods;
}
/**
* Retrieve the module name
*
* @return string
*/
public function getModule()
{
return $this->getRequest('module', JO_Front::getInstance()->getDefaultModule());
}
public function _initNoPermision()
{
$request = JO_Request::getInstance();
if ($request->getModule() == 'install') {
return '';
}
if ($request->getModule() == 'admin') {
$controller_name = JO_Front::getInstance()->formatControllerName($request->getController());
if (!class_exists($controller_name, false)) {
JO_Loader::loadFile(APPLICATION_PATH . '/modules/' . $request->getModule() . '/controllers/' . JO_Front::getInstance()->classToFilename($controller_name));
}
if (method_exists($controller_name, 'config')) {
$data = call_user_func(array($controller_name, 'config'));
if ($data['has_permision'] && !WM_Users::allow('read', $request->getController())) {
JO_Action::getInstance()->forward('error', 'noPermission');
}
}
}
}
public function __construct($data = array())
{
$db = JO_Db::getDefaultAdapter();
$data['category_id'] = 0;
$data['public'] = 1;
if (isset($data['board_id'])) {
$board_info = new Model_Boards_Board($data['board_id']);
if ($board_info->count()) {
$data['board_id'] = $board_info['board_board_id'];
$data['category_id'] = $board_info['board_category_id'];
$data['public'] = $board_info['board_public'];
} else {
$data['board_id'] = 0;
}
} else {
$data['board_id'] = 0;
}
$data['date_added'] = WM_Date::format(time(), 'yy-mm-dd H:i:s');
$data['date_modified'] = $data['date_added'];
$data['user_id'] = isset($data['user_id']) ? $data['user_id'] : (string) JO_Session::get('user[user_id]');
$data['store'] = Helper_Config::get('file_upload_method') ? Helper_Config::get('file_upload_method') : 'Model_Upload_Locale';
$data['source_id'] = 0;
//sorce
if (isset($data['from']) && $data['from']) {
$source = new Model_Sources_GetSourceByUrl($data['from']);
if ($source->source_id) {
$data['source_id'] = $source->source_id;
}
}
$data['from_md5'] = md5(isset($data['from']) ? $data['from'] : time());
/* price */
//$data['price'] = 0;
if (isset($data['price']) && $data['price']) {
$currencies = WM_Currency::getCurrencies();
$price_left = array();
$price_right = array();
if ($currencies) {
foreach ($currencies as $currency) {
if (trim($currency['symbol_left'])) {
$price_left[] = preg_quote(trim($currency['symbol_left']));
}
if (trim($currency['symbol_right'])) {
$price_right[] = preg_quote(trim($currency['symbol_right']));
}
}
if ($price_left) {
if (preg_match('/(' . implode('|', $price_left) . ')([\\s]{0,2})?(?:(?:\\d{1,5}(?:\\,\\d{3})+)|(?:\\d+))(?:\\.\\d{2})?/', $data['price'], $match)) {
$price_tmp = trim(str_replace(trim($match[1]), '', $match[0]));
$currency = self::getCurrencyBySimbol(trim($match[1]));
if ($currency) {
$data['price'] = round($price_tmp / $currency, 4);
}
}
}
if (!$data['price'] && $price_right) {
if (preg_match('/(?:(?:\\d{1,5}(?:\\,\\d{3})+)|(?:\\d+))(?:\\.\\d{2})?([\\s]{0,2})?(' . implode('|', $price_right) . ')/', $data['price'], $match)) {
$price_tmp = trim(str_replace(trim($match[2]), '', $match[0]));
$currency = self::getCurrencyBySimbol(trim($match[2]));
if ($currency) {
$data['price'] = round($price_tmp / $currency, 4);
}
}
}
}
}
/* end price */
$from = isset($data['from']) ? $data['from'] : time();
$data['is_video'] = isset($data['is_video']) && $data['is_video'] == 'true' ? 1 : 0;
if (!$data['is_video']) {
$auto = new Helper_AutoEmbed();
if ($auto->parseUrl($from)) {
$data['is_video'] = 1;
}
}
/* is video */
///////////////// Event onComplete /////////////////////
$on_add_call = Helper_Config::get('pin_onbefore_create');
if ($on_add_call) {
foreach ($on_add_call as $call) {
call_user_func($call, $data);
}
}
///////////////// upload image /////////////////////
$image = false;
if (isset($data['media']) && !isset($data['image'])) {
$image = $data['media'];
} else {
if (isset($data['image'])) {
$image = $data['image'];
}
}
if (!isset($data['gallery']) && !$image) {
return $this;
}
$data['image'] = '';
//create pin
$data['pin_id'] = Helper_Db::insert('pins', $data);
if (!$data['pin_id']) {
return $this;
}
if (isset($data['gallery'])) {
if (is_array($data['gallery']) && count($data['gallery']) > 0) {
$method_for_upload = Helper_Config::get('file_upload_method');
if ($method_for_upload) {
foreach ($data['gallery'] as $row => $image_get) {
if ($this->error) {
return $this;
}
$image = call_user_func(array($method_for_upload, 'uploadPin'), $image_get, isset($data['title']) && $data['title'] ? $data['title'] : $data['description'], $data['pin_id']);
$this->error = call_user_func(array($method_for_upload, 'getError'));
if ($image && isset($image['image'])) {
if ($row == 0) {
Helper_Db::update('pins', array('image' => $image['image'], 'store' => $image['store'], 'height' => $image['height'], 'width' => $image['width']), array('pin_id = ?' => (string) $data['pin_id']));
} else {
$gal_id = Helper_Db::insert('pins_gallery', array('image' => $image['image'], 'store' => $image['store'], 'pin_id' => $data['pin_id'], 'sort_order' => $row));
if (!$gal_id) {
return $this;
}
}
} else {
return $this;
}
}
} else {
Helper_Db::delete('pins', array('pin_id = ?' => (string) $data['pin_id']));
return $this;
}
} else {
Helper_Db::delete('pins', array('pin_id = ?' => (string) $data['pin_id']));
return $this;
}
} else {
$method_for_upload = Helper_Config::get('file_upload_method');
if ($method_for_upload && $image) {
$image = call_user_func(array($method_for_upload, 'uploadPin'), $image, isset($data['title']) && $data['title'] ? $data['title'] : $data['description'], $data['pin_id']);
$this->error = call_user_func(array($method_for_upload, 'getError'));
if ($image && isset($image['image'])) {
Helper_Db::update('pins', array('image' => $image['image'], 'store' => $image['store'], 'height' => $image['height'], 'width' => $image['width']), array('pin_id = ?' => (string) $data['pin_id']));
} else {
Helper_Db::delete('pins', array('pin_id = ?' => (string) $data['pin_id']));
return $this;
}
} else {
Helper_Db::delete('pins', array('pin_id = ?' => (string) $data['pin_id']));
return $this;
}
}
///////////////// update latest pins for board /////////////////////
if (isset($data['board_id']) && $data['board_id']) {
new Model_Boards_UpdateLatestPins($data['board_id']);
}
///////////////// update latest pins for user /////////////////////
new Model_Users_UpdateLatestPins($data['user_id']);
///////////////// Pin total repins /////////////////////
if (isset($data['repin_from']) && $data['repin_from']) {
$pin_repin = new Model_Pins_Pin($data['repin_from']);
if ($pin_repin->count()) {
Helper_Db::update('pins', array('repins' => $db->fetchOne($db->select()->from('pins', 'COUNT(pin_id)')->where('repin_from = ?', $data['repin_from'])->limit(1))), array('pin_id = ?' => $data['repin_from']));
}
}
///////////////// Word for search index's /////////////////////
$spl = JO_Utf8::str_word_split(strip_tags(html_entity_decode($data['description'], ENT_QUOTES, 'utf-8')), self::$searchWordLenght);
$words = array();
foreach ($spl as $word) {
$word = mb_strtolower($word, 'utf-8');
if (!in_array($word, self::blackWordsDictionary()) && $word[0] . $word[1] != '&#') {
$words[$word] = $word;
}
}
///////////////// Word for search index's insert /////////////////////
foreach ($words as $word => $data1) {
$dic_id = $db->fetchOne($db->select()->from('pins_dictionary', 'dic_id')->where('word = ?', $word));
if (!$dic_id) {
$db->insert('pins_dictionary', array('word' => $word));
$dic_id = $db->lastInsertId();
}
if ($dic_id) {
$db->insert('pins_invert', array('pin_id' => $data['pin_id'], 'dic_id' => $dic_id));
}
}
Helper_Db::delete('pins_images', array('pin_id = ?' => $data['pin_id']));
///////////////// Extension on create //////////////////
$extensions = Model_Extensions::getByMethod('pin_oncreate');
if ($extensions) {
$front = JO_Front::getInstance();
foreach ($extensions as $id => $ext) {
$pin_data_ext = call_user_func(array($front->formatModuleName('model_' . $ext . '_pin'), 'oncreate'), $data['pin_id'], $data);
if ($pin_data_ext && is_array($pin_data_ext)) {
$data = array_merge(data, $pin_data_ext);
}
}
}
///////////////// Event onComplete /////////////////////
$trigger = new Helper_Triggers_PinOnCreate();
$trigger->bind($data['pin_id']);
$this->data = $data;
// parent::__construct($data);
}
public function steptwoAction()
{
$this->noLayout(true);
$request = $this->getRequest();
if (JO_Session::get('user[user_id]')) {
$this->view->images = array();
if ($request->isGet() && $request->getQuery('url')) {
$cleared = preg_replace('/^www./i', '', JO_Validate::validateHost($request->getQuery('url')));
$cleared = mb_strtolower($cleared, 'utf-8');
if (Model_Blacksources::is_exists($cleared)) {
$this->view->error = sprintf($this->translate('Source %s is blocked!'), $cleared);
$this->setViewChange('stepone');
} else {
$video_url = $request->getQuery('url');
$video_url = trim($video_url);
if (strpos($video_url, 'http') === false) {
$video_url = 'http://' . $video_url;
}
$http = new JO_Http();
$http->setUseragent('Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.9) Gecko/20071025 Firefox/2.0.0.9');
$http->setReferrer($video_url);
$http->useCurl(true);
$http->execute($video_url, $request->getBaseUrl(), 'GET');
$http->setMaxredirect(5);
/*if(isset($http->headers['location']) && $http->headers['location']) {
$new_url = $http->headers['location'];
$http = new JO_Http();
$http->setUseragent('Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.9) Gecko/20071025 Firefox/2.0.0.9');
$http->setReferrer($video_url);
$http->useCurl(true);
$http->execute($new_url, $request->getBaseUrl(), 'GET');
if(is_array($new_url)) {
$video_url = array_shift($new_url);
} else if($new_url) {
$video_url = $new_url;
}
}*/
$videoObject = new Helper_AutoEmbed();
$parsedVideo = $videoObject->parseUrl($video_url);
$video_image = false;
if ($parsedVideo) {
$video_image = $videoObject->getImageURL();
}
$config_image_minimum_size = (int) Helper_Config::get('config_image_minimum_size');
if (!$config_image_minimum_size) {
$config_image_minimum_size = 80;
}
if ($http->error) {
$this->view->error = str_replace("'", "\\'", $http->error);
} elseif ($video_url && ($imagesize = @getimagesize($video_url)) !== false) {
if ($imagesize && $imagesize[0] >= $config_image_minimum_size && $imagesize[1] >= $config_image_minimum_size) {
$this->view->images[] = array('src' => $video_url, 'width' => $imagesize[0], 'height' => $imagesize[1]);
}
} elseif ($video_image && ($imagesize = @getimagesize($video_image)) !== false) {
if ($imagesize && $imagesize[0] >= $config_image_minimum_size && $imagesize[1] >= $config_image_minimum_size) {
$this->view->images[] = array('src' => $video_image, 'width' => $imagesize[0], 'height' => $imagesize[1]);
}
} else {
$html = $http->result;
$dom = new JO_Dom_Query($html);
$meta = $dom->query('meta');
$charset = false;
if ($meta->count()) {
for ($i = 0; $i < $meta->count(); $i++) {
$content = $meta->getItem($i)->getAttribute('content');
if (preg_match('/charset=([^\\"\']+)/', $content, $match)) {
$charset = trim($match[1]);
}
}
}
if ($charset) {
$html = iconv($charset, "UTF-8", $html);
} else {
$html = JO_Utf8::convertToUtf8($http->result);
}
$this->view->title = '';
if (preg_match('/<title>(.*)<\\/title>/sim', $html, $match)) {
$this->view->title = $match[1];
}
$meta_image = $dom->query('meta[property="og:image"]');
$meta_image_src = null;
if ($meta_image->count()) {
$meta_image_src = $meta_image->rewind()->getAttribute('content');
}
if ($meta_image_src) {
if (($imagesize = @getimagesize($meta_image_src)) !== false) {
if ($imagesize && $imagesize[0] >= $config_image_minimum_size && $imagesize[1] >= $config_image_minimum_size) {
$this->view->images[] = array('src' => $meta_image_src, 'width' => $imagesize[0], 'height' => $imagesize[1]);
}
}
}
$images = $dom->query('img');
if ($images->count() > 0) {
$images_array = array();
for ($i = 0; $i < $images->count(); $i++) {
$src = $images->getItem($i)->getAttribute('src');
$image_full = JO_Url_Relativetoabsolute::toAbsolute($request->getQuery('url'), $src);
$images_array[$image_full] = $image_full;
}
foreach ($images_array as $image_full) {
$imagesize = @getimagesize($image_full);
if ($imagesize && $imagesize[0] >= $config_image_minimum_size && $imagesize[1] >= $config_image_minimum_size) {
$this->view->images[] = array('src' => $image_full, 'width' => $imagesize[0], 'height' => $imagesize[1]);
}
}
}
}
$this->view->from = $video_url;
}
}
$this->view->total_images = count($this->view->images);
if ($this->view->total_images < 1) {
$this->view->form_action = WM_Router::create($request->getBaseUrl() . '?controller=addpin_fromurl&action=steptwo');
$this->view->error_total_images = true;
$this->setViewChange('stepone');
} else {
$this->view->createBoard = WM_Router::create($request->getBaseUrl() . '?controller=boards&action=createboardwithoutcategory');
$this->view->from_url = WM_Router::create($request->getBaseUrl() . '?controller=pin&action=createpin');
$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_oncreateform');
if ($extensions) {
$front = JO_Front::getInstance();
foreach ($extensions as $id => $ext) {
$this->view->form_extensions[] = array('html' => $this->view->callChildren('modules_' . $ext . '_oncreateform'), 'view' => $this->view->callChildrenView('modules_' . $ext . '_oncreateform'), 'key' => $ext);
}
}
}
} else {
// $this->view->redirect = WM_Router::create( $request->getBaseUrl() . '?controller=users&action=login' );
$this->redirect(WM_Router::create($request->getBaseUrl() . '?controller=users&action=login'));
}
}
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 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 = 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_oncreateform');
if ($extensions) {
$front = JO_Front::getInstance();
foreach ($extensions as $id => $ext) {
$this->view->form_extensions[] = array('html' => $this->view->callChildren('modules_' . $ext . '_oncreateform'), 'view' => $this->view->callChildrenView('modules_' . $ext . '_oncreateform'), 'key' => $ext);
}
}
$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 (is_array($request->getPost())) {
foreach ($request->getPost() as $k => $v) {
$this->view->{$k} = $v;
}
}
if (!trim($this->view->description)) {
$this->view->description = $this->view->title;
}
if (JO_Session::get('success_added')) {
return $this->success();
} else {
if ($request->isPost()) {
$validate = new Helper_Validate();
$validate->_set_rules($request->getPost('description'), $this->translate('Description'), 'not_empty;min_length[1];max_length[500]');
$validate->_set_rules($request->getPost('board_id'), $this->translate('Board'), 'not_empty;');
if ($validate->_valid_form()) {
$result = new Model_Pins_Create($request->getPost());
if ($result->count()) {
$result = $result->data;
///add history
new Model_History_AddHistory(JO_Session::get('user[user_id]'), Model_History_Abstract::ADDPIN, $result['pin_id']);
//send notification
$users = new Model_Users_GroupBoardUsers($request->getPost('board_id'));
if ($users->count()) {
$template = Model_Notification::getTemplate('group_board');
if ($template) {
$pin_info = new Model_Pins_Pin($result['pin_id']);
if ($pin_info->count()) {
$mail_footer = html_entity_decode(Helper_Config::get('mail_footer'), ENT_QUOTES, 'utf-8');
foreach ($users as $user) {
if ($user['email_interval'] == 1 && $user['groups_pin_email']) {
$template_data = array('user_id' => $user['user_id'], 'user_firstname' => $user['firstname'], 'user_lastname' => $user['lastname'], 'user_fullname' => $user['fullname'], 'user_username' => $user['username'], 'author_url' => WM_Router::create($request->getBaseUrl() . '?controller=users&action=profile&user_id=' . $pin_info['user_user_id']), 'author_fullname' => $pin_info['user_fullname'], 'board_url' => WM_Router::create($request->getBaseUrl() . '?controller=boards&action=view&user_id=' . $pin_info['user_user_id'] . '&board_id=' . $pin_info['board_board_id']), 'board_name' => $pin_info['board_title'], 'pin_url' => WM_Router::pinAction($result['pin_id']), 'mail_footer' => $mail_footer);
if (!$template['title']) {
$template['title'] = '${author_fullname} ' . $this->translate('added new pin to a group board');
}
$title = Model_Notification::parseTemplate(html_entity_decode($template['title'], ENT_QUOTES, 'utf-8'), $template_data);
$body = Model_Notification::parseTemplate(html_entity_decode($template['template'], ENT_QUOTES, 'utf-8'), $template_data);
Model_Email::send($user['email'], Helper_Config::get('noreply_mail'), $title, $body);
}
}
}
}
}
JO_Session::set('success_added', $result['pin_id']);
$this->redirect($request->getBaseUrl() . '?controller=bookmarklet');
} else {
if ($result->error) {
$this->view->error = $result->error;
} else {
$this->view->error = $this->translate('There was a problem with the record. Please try again!');
}
}
} else {
$this->view->error = $validate->_get_error_messages();
}
}
}
}
public function fromatList($pin)
{
static $extensions = null;
if ($extensions === null) {
$extensions = Model_Extensions::getByMethod('pin_list');
}
$pin = array_merge($pin, Helper_Pin::formatPinData($pin));
$pin_data = array('template' => 'pins', 'pin_id' => $pin['pin_id'], 'pin_row' => $pin['pin_pin_row'], 'category_id' => $pin['board_category_id'], 'loged' => JO_Session::get('user[user_id]') ? true : false, 'is_liked' => $pin['pin_is_liked'], 'from' => $pin['pin_from'], 'vip' => $pin['pin_vip'], 'gift' => $pin['pin_gift'], 'price' => $pin['pin_price_formated'], 'date_added' => $pin['pin_date_added'], 'is_video' => $pin['pin_is_video'], 'description' => str_replace('&', '&', $pin['pin_description']), 'likes' => $pin['pin_likes'], 'comments' => $pin['pin_comments'], 'repins' => $pin['pin_repins'], 'set_activity_title' => isset($pin['set_activity_title']) ? $pin['set_activity_title'] : false, 'via_profile' => $pin['via_profile'] ? $pin['via_profile'] : false, 'self_profile' => $pin['self_profile'], 'author_profile' => array('avatars' => $pin['user_avatars'], 'fullname' => $pin['user_fullname'], 'user_id' => $pin['user_user_id'], 'href' => $pin['user_href']), 'url_repin' => $pin['pin_url_repin'], 'url_edit' => $pin['pin_edit'], 'url_like' => $pin['pin_url_like'], 'url_comment' => $pin['pin_url_comment'], 'pin_url' => $pin['pin_href'], 'board_url' => $pin['pin_onto_href'], 'pin_comments_data' => $pin['pin_latest_comments'] ? $pin['pin_latest_comments'] : false, 'images' => $pin['pin_thumbs'], 'text_vip' => $this->translate('VIP'), 'text_add_comment' => $this->translate('Add a comment...'), 'text_delete_comment' => $this->translate('Delete Comment'), 'text_via' => $pin['via_profile'] ? $this->translate('via') : '', 'text_onto' => $this->translate('onto'), 'text_repin' => $this->translate('Repin'), 'text_edit' => $this->translate('Edit'), 'text_like_unlike' => $pin['pin_is_liked'] ? $this->translate('Unlike') : $this->translate('Like'), 'text_comment' => $this->translate('Comment'), 'text_total_likes' => sprintf($this->translate('%d like' . ($pin['pin_likes'] == 1 ? '' : 's')), $pin['pin_likes']), 'text_total_comments' => sprintf($this->translate('%d comment' . ($pin['pin_comments'] == 1 ? '' : 's')), $pin['pin_comments']), 'text_total_repins' => sprintf($this->translate('%d repin' . ($pin['pin_repins'] == 1 ? '' : 's')), $pin['pin_repins']), 'text_date_dif' => sprintf($this->translate('%d %s ago'), $pin['pin_date_dif']['value'], $this->translate($pin['pin_date_dif']['key'])), 'text_board' => $pin['board_title'], 'text_all_comments' => $pin['pin_comments'] && $pin['pin_comments'] > (int) Helper_Config::get('config_comments_list') ? sprintf($this->translate('All %d comments...'), $pin['pin_comments']) : false);
if ($extensions) {
$front = JO_Front::getInstance();
foreach ($extensions as $id => $ext) {
$pin_data_ext = call_user_func(array($front->formatModuleName('model_' . $ext . '_pin'), 'listing'), $pin, $pin_data);
if ($pin_data_ext && is_array($pin_data_ext)) {
$pin_data = array_merge($pin_data, $pin_data_ext);
}
}
}
return $pin_data;
}
/**
* Run the application
*
* @return void
*/
public function dispatch()
{
$router = $this->getRouter();
$request = JO_Request::getInstance();
$matched = $router->match($request->getRequest('uri'), false);
JO_Registry::set('router', $router);
if ($matched) {
foreach ($matched as $key => $value) {
$request->setParams($key, $value);
}
} else {
$router->addRoute('default', new JO_Router_Regex('([^\\/]+)?/?([^\\/]+)?/?', array('controller' => 'index', 'action' => 'index'), array(1 => 'controller', 2 => 'action')));
$matched = $router->match($request->getRequest('uri'), true);
if ($matched) {
foreach ($matched as $key => $value) {
$request->setParams($key, $value);
}
}
}
$this->getBootstrap()->run();
$front = JO_Front::getInstance();
try {
$front->dispatch();
} catch (JO_Exception $e) {
throw new JO_Exception($e);
}
}
public function editAction()
{
// var_dump( htmlspecialchars('⚐') );exit;
$request = $this->getRequest();
$pin_id = $request->getRequest('pin_id');
// $pin_info = Model_Pins::getPin($pin_id);
$pin_info = new Model_Pins_Pin($pin_id);
if (!$pin_info->count() || $pin_info->data['pin_user_id'] != JO_Session::get('user[user_id]')) {
$this->forward('error', 'error404');
}
$pin_info = $pin_info->data;
if ($request->isPost()) {
$validate = new Helper_Validate();
if ($pin_info['pin_from']) {
$validate->_set_rules($request->getPost('from'), $this->translate('Link'), 'not_empty;min_length[3];domain');
} else {
if (trim($request->getPost('from'))) {
$validate->_set_rules($request->getPost('from'), $this->translate('Link'), 'not_empty;min_length[3];domain');
}
}
$data = $request->getPost();
if ($validate->_valid_form()) {
$edit = new Model_Pins_Edit($pin_id, $request->getPost());
$this->redirect(WM_Router::pinAction($pin_info['pin_pin_id']));
} else {
$this->view->error = $validate->_get_error_messages();
}
foreach ($data as $k => $v) {
if (isset($pin_info['pin_' . $k])) {
$pin_info['pin_' . $k] = $v;
}
}
}
$pin_info['images'] = Helper_Uploadimages::pinThumbs($pin_info);
if ($pin_info['pin_gift']) {
$pin_info['price_formated'] = WM_Currency::format($pin_info['pin_price']);
} else {
$pin_info['price_formated'] = '';
$pin_info['pin_price'] = 0;
}
$pin_info['href'] = WM_Router::pinAction($pin_info['pin_pin_id']);
$this->view->pin_info = $pin_info;
$view->get_user_friends = WM_Router::create($request->getBaseUrl() . '?controller=users&action=friends');
$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 edit //////////////////
$this->view->form_extensions = array();
$extensions = Model_Extensions::getByMethod('pin_oneditform');
if ($extensions) {
$front = JO_Front::getInstance();
foreach ($extensions as $id => $ext) {
$this->view->form_extensions[] = array('html' => $this->view->callChildren('modules_' . $ext . '_oneditform'), 'view' => $this->view->callChildrenView('modules_' . $ext . '_oneditform'), 'key' => $ext);
}
}
$this->view->pin_delete = WM_Router::pinAction($pin_id, 'delete');
$this->view->children = array('header_part' => 'layout/header_part', 'footer_part' => 'layout/footer_part');
}
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 create($data)
{
$board_info = Model_Boards::getBoard($data['board_id']);
$db = JO_Db::getDefaultAdapter();
$date_added = WM_Date::format(time(), 'yy-mm-dd H:i:s');
$image = '';
$price = '';
$source_id = Model_Source::getSourceByUrl($data['from']);
/* price */
$currencies = WM_Currency::getCurrencies();
$price_left = '';
$price_right = '';
if ($currencies) {
foreach ($currencies as $currency) {
if (trim($currency['symbol_left'])) {
$price_left[] = preg_quote(trim($currency['symbol_left']));
}
if (trim($currency['symbol_right'])) {
$price_right[] = preg_quote(trim($currency['symbol_right']));
}
}
if ($price_left) {
if (preg_match('/(' . implode('|', $price_left) . ')([\\s]{0,2})?(?:(?:\\d{1,5}(?:\\,\\d{3})+)|(?:\\d+))(?:\\.\\d{2})?/', $data['price'], $match)) {
$price_tmp = trim(str_replace(trim($match[1]), '', $match[0]));
$currency = self::getCurrencyBySimbol(trim($match[1]));
if ($currency) {
$price = round($price_tmp / $currency, 4);
}
}
}
if (!$price && $price_right) {
if (preg_match('/(?:(?:\\d{1,5}(?:\\,\\d{3})+)|(?:\\d+))(?:\\.\\d{2})?([\\s]{0,2})?(' . implode('|', $price_right) . ')/', $data['price'], $match)) {
$price_tmp = trim(str_replace(trim($match[2]), '', $match[0]));
$currency = self::getCurrencyBySimbol(trim($match[2]));
if ($currency) {
$price = round($price_tmp / $currency, 4);
}
}
}
}
/* end price */
$from = isset($data['from']) ? $data['from'] : time();
$is_video = isset($data['is_video']) && $data['is_video'] == 'true' ? 1 : 0;
if (!$is_video) {
$auto = new Helper_AutoEmbed();
if ($auto->parseUrl($from)) {
$is_video = 1;
}
}
/* add to db */
$db->insert('pins', array('category_id' => (string) $board_info['category_id'], 'board_id' => (string) $data['board_id'], 'user_id' => (string) JO_Session::get('user[user_id]'), 'date_added' => $date_added, 'date_modified' => $date_added, 'description' => $data['description'], 'title' => isset($data['title']) ? $data['title'] : '', 'price' => $price, 'from' => $from, 'from_md5' => md5($from), 'is_video' => $is_video, 'source_id' => isset($data['source_id']) ? $data['source_id'] : $source_id, 'via' => isset($data['via']) ? $data['via'] : '', 'repin_from' => isset($data['repin_from']) ? $data['repin_from'] : '', 'public' => (int) $board_info['public'], 'pinmarklet' => isset($data['pinmarklet']) ? 1 : 0, 'from_repin' => isset($data['from_repin']) ? $data['from_repin'] : '', 'store' => JO_Registry::get('default_upload_method') ? JO_Registry::get('default_upload_method') : 'locale'));
$pin_id = $db->lastInsertId();
if (!$pin_id) {
return false;
}
///// upload images
$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)) {
$image = call_user_func(array($upload_model, 'uploadPin'), $data['image'], isset($data['title']) && $data['title'] ? $data['title'] : null, $pin_id);
}
// if(!$image && $upload_model != $front->formatModuleName('model_upload_locale')) {
// $image = call_user_func(array($upload_model, 'uploadPin'), $data['image'], (isset($data['title']) && $data['title'] ? $data['title'] : null), $pin_id );
// }
if (!$image) {
$db->delete('pins', array('pin_id = ?' => (string) $pin_id));
return false;
} else {
$db->update('pins', array('image' => $image['image'], 'store' => $image['store'], 'height' => $image['height'], 'width' => $image['width']), array('pin_id = ?' => (string) $pin_id));
}
//if($board_info['user_id'] == JO_Session::get('user[user_id]')) {
Model_Boards::updateLatestPins($data['board_id'], $pin_id);
//}
Model_Users::updateLatestPins($pin_id);
if (isset($data['repin_from']) && $data['repin_from']) {
$pin_repin = self::getPin($data['repin_from']);
if ($pin_repin) {
$db->update('pins', array('repins' => $pin_repin['repins'] + 1), array('pin_id = ?' => $data['repin_from']));
}
}
$spl = JO_Utf8::str_word_split(strip_tags(html_entity_decode($data['description'], ENT_QUOTES, 'utf-8')), self::$searchWordLenght);
$words = array();
foreach ($spl as $word) {
$word = mb_strtolower($word, 'utf-8');
if (!in_array($word, self::common()) && $word[0] . $word[1] != '&#') {
$words[$word] = $word;
}
}
foreach ($words as $word => $data1) {
$dic_id = $db->fetchOne($db->select()->from('pins_dictionary', 'dic_id')->where('word = ?', $word));
if (!$dic_id) {
$db->insert('pins_dictionary', array('word' => $word));
$dic_id = $db->lastInsertId();
}
if ($dic_id) {
$db->insert('pins_invert', array('pin_id' => $pin_id, 'dic_id' => $dic_id));
}
}
if (JO_Session::get('user[facebook_connect]') && JO_Session::get('user[facebook_timeline]')) {
try {
$session = JO_Registry::get('facebookapi')->getUser();
JO_Registry::get('facebookapi')->setExtendedAccessToken();
if (JO_Registry::get('facebookapi')->api('/me')) {
$access_token = JO_Registry::get('facebookapi')->getAccessToken();
$pin_url = WM_Router::create(JO_Request::getInstance()->getBaseUrl() . '?controller=pin&pin_id=' . $pin_id);
$statusUpdate = JO_Registry::get('facebookapi')->api('/me/feed', 'post', array('link' => $pin_url, 'cb' => ''));
$og_namespace = trim(JO_Registry::get('og_namespace'));
$og_recipe = trim(JO_Registry::get('og_recipe'));
if (!$og_recipe) {
$og_namespace = '';
}
if ($og_namespace) {
$params = array($og_recipe => $pin_url, 'access_token' => $access_token);
$response = JO_Registry::get('facebookapi')->api('/me/' . $og_namespace . ':' . $og_recipe, 'post', $params);
}
}
} catch (JO_Exception $e) {
}
}
self::rebuildCache(array($pin_id));
if (isset($data['repin_from'])) {
self::rebuildCache($data['repin_from']);
}
return $pin_id;
}
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;
}
/**
* @param string $action
*/
public function dispatch($controller, $action, $param = '')
{
$request = $this->getRequest();
if ($action == 'error404') {
$request->setParams(array('controller' => 'error', 'action' => 'error404'));
}
$name = $controller;
$view = $this->initView();
$this->preDispatch();
if (null === $this->_classMethods) {
$this->_classMethods = get_class_methods($this);
}
$script = $action;
$action = $action . 'Action';
$throw = '';
if (in_array($action, $this->_classMethods)) {
// ob_start(array(new JO_Error, 'error_handler'));
ob_start(array(new JO_Error(), 'fatal_error_handler'));
$this->{$action}($param);
} else {
$displayExceptions = JO_Front::getInstance()->getParam('displayExceptions');
if ($displayExceptions) {
$throw = $this->call_error($action);
$layout = JO_Layout::getInstance();
$layout->content = '<pre>' . $throw . '<pre>';
$response = $layout->response();
return $this->getResponse()->appendBody($response);
} else {
if ($this->getRequest()->getForwarded() != 'error') {
$this->forward('error', 'error404');
} else {
$this->forward('JO_Action', 'error404');
}
}
}
$this->postDispatch();
if (!$this->getInvokeArg('noViewRenderer')) {
$layout = JO_Layout::getInstance();
if ($this->view_change) {
$script = $this->view_change;
}
$layout->content = $view->render($script, $script == 'error404' ? 'error' : $name);
if (JO_Registry::forceGet('viewSetCallback')) {
$layout->content = call_user_func(JO_Registry::forceGet('viewSetCallback'), $layout->content);
} elseif ($this->response_callback) {
$layout->content = call_user_func($this->response_callback, $layout->content);
}
if ($this->isChildren) {
return $layout->content;
} elseif ($this->noLayout) {
return $this->getResponse()->appendBody($layout->content);
} else {
$response = $layout->response();
if ($this->response_callback) {
$response = call_user_func($this->response_callback, $response);
}
if (JO_Registry::isRegistered('static_cache_options') && JO_Registry::forceGet('static_cache_enable')) {
$options = (array) unserialize(JO_Registry::get('static_cache_options'));
$cache_object = new JO_Cache_Static($options);
$cache_object->add(false, $response);
}
return $this->getResponse()->appendBody($response);
}
}
}
public static function formatUploadModule($store)
{
static $front = null, $request = null, $upload_store = array();
if ($request === null) {
$request = JO_Request::getInstance();
}
if ($front === null) {
$front = JO_Front::getInstance();
}
if ($store == 'local' || $store == '') {
$store = 'locale';
}
if (isset($upload_store[$store])) {
return $upload_store[$store];
} else {
$upload_model = 'model_upload_' . $store;
$upload_model = $front->formatModuleName($upload_model);
$upload_store[$store] = $upload_model;
return $upload_model;
}
}
public static function edit($user_id, $data)
{
$db = JO_Db::getDefaultAdapter();
$rows = self::describeTable('users');
$user_info_get = self::getUser($user_id);
$date_added = WM_Date::format($user_info_get['date_added'], 'yy-mm-dd H:i:s');
$update = array();
$avatar = '';
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];
}
} elseif ($row == 'password' || $row == 'new_password') {
$update[$row] = md5($data[$row]);
} elseif ($row == 'location') {
if ($data[$row] != "Introduce tu ubicación") {
$update[$row] = $data[$row];
}
} elseif ($row == 'firstname') {
$update[$row] = self::quotesFix($data[$row]);
} elseif ($row == 'description') {
$update[$row] = self::quotesFix($data[$row]);
} else {
$update[$row] = $data[$row];
}
}
}
if (!$update) {
if (!$avatar) {
return false;
}
}
$rebuild = $result = $db->update('users', $update, array('user_id = ?' => (string) $user_id));
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, 'uploadUserAvatar'), $avatar, $user_id);
}
if ($image) {
//error_log("EXISTE FILE");
$result = $db->update('users', 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));
if ($user_info_get && $user_info_get['avatar']) {
if ($user_info_get['avatar'] != $image['image']) {
call_user_func(array(Helper_Pin::formatUploadModule($user_info_get['store']), 'deleteUserImage'), $user_info_get);
}
}
if (!$rebuild) {
$rebuild = $result;
}
}
}
if (isset($data['username'])) {
$db->query("DELETE FROM url_alias WHERE query = 'user_id=" . (string) $user_id . "'");
$db->insert('url_alias', array('query' => 'user_id=' . (string) $user_id, 'keyword' => $data['username'], 'path' => $data['username'], 'route' => 'users/profile'));
}
if ($rebuild) {
$total = $db->update('pins', array('date_modified' => WM_Date::format(time(), 'yy-mm-dd H:i:s')), array('user_id = ? OR (pin_id IN (SELECT DISTINCT pin_id FROM pins_comments WHERE user_id = ?))' => (string) $user_id));
}
$db->update('users', array('pins' => new JO_Db_Expr('(SELECT COUNT(DISTINCT pin_id) FROM pins WHERE user_id = users.user_id)'), 'boards' => new JO_Db_Expr('(SELECT COUNT(DISTINCT board_id) FROM boards WHERE user_id = users.user_id)'), 'likes' => new JO_Db_Expr('(SELECT COUNT(DISTINCT pin_id) FROM pins_likes WHERE user_id = users.user_id)'), 'following' => new JO_Db_Expr('(SELECT COUNT(DISTINCT following_id) FROM users_following_user WHERE user_id = users.user_id AND following_id != users.user_id)'), 'followers' => new JO_Db_Expr('(SELECT COUNT(DISTINCT user_id) FROM users_following_user WHERE following_id = users.user_id AND user_id != users.user_id)'), 'liking' => new JO_Db_Expr('(SELECT COUNT(DISTINCT user_like_id) FROM users_likes WHERE user_id = users.user_id AND user_like_id != users.user_id)'), 'likers' => new JO_Db_Expr('(SELECT COUNT(DISTINCT user_id) FROM users_likes WHERE user_like_id = users.user_id AND user_id != users.user_id)')), array('user_id = ?' => (string) $user_id));
return true;
}
