/** * Get additional content data selected * * @param $result = Query result */ public static function post_find($result) { if ($result !== null) { if (is_array($result)) { foreach ($result as $item) { // It will first check if we already have result in temporary result, // and only execute query if we dont. That way we dont have duplicate queries // Get content images $item->get_images = static::lazy_load(function () use($item) { return Model_Infotab_Image::find(array('where' => array('infotab_id' => $item->unique_id), 'order_by' => array('sort' => 'asc'))); }, $item->unique_id, 'images'); // Get content files $item->get_files = static::lazy_load(function () use($item) { return Model_Infotab_File::find(array('where' => array('infotab_id' => $item->id, 'product_id' => $item->product_id), 'order_by' => array('sort' => 'asc'))); }, $item->id, 'files'); } } } // return the result return $result; }
/** * Edit product infotabs * * @param $product_id = Product ID * @param $infotab_id = Infotab ID * @param $hotspot_id = Hotspot ID * */ public function action_infotab_edit($produt_id = false, $infotab_id = false, $hotspot_id = false) { // Check for product if (!is_numeric($produt_id)) { \Response::redirect('admin/product/list'); } // Get news item to edit if (!($product = Model_Product::find_one_by_id($produt_id))) { \Response::redirect('admin/product/list'); } // Check for infotab if (!is_numeric($infotab_id)) { \Response::redirect('admin/product/list'); } // Get news item to edit if (!($item = Model_Product_To_Infotabs::find_by_pk($infotab_id))) { \Response::redirect('admin/product/list'); } // Get hotspot is exist if (is_numeric($hotspot_id)) { if (!($hotspot = Model_Infotab_Image::find_by_pk($hotspot_id))) { unset($hotspot); } } if (\Input::post()) { $val = Model_Product_To_Infotabs::validate('update', $item->type); // Upload image and display errors if there are any $image = $this->upload_infotab_image(); if (!$image['exists'] && \Config::get('infotab.image.required', false) && empty($item->images)) { // No previous images and image is not selected and it is required \Messages::error('<strong>There was an error while trying to upload infotab image</strong>'); \Messages::error('You have to select image'); } elseif ($image['errors']) { \Messages::error('<strong>There was an error while trying to upload infotab image</strong>'); foreach ($image['errors'] as $error) { \Messages::error($error); } } if ($val->run() && $image['is_valid'] && !(!$image['exists'] && \Config::get('infotab.image.required', false) && empty($item->images))) { /** IMAGES **/ // Get all alt texts to update if there is no image change foreach (\Arr::filter_prefixed(\Input::post(), 'alt_text_') as $image_id => $alt_text) { if (strpos($image_id, 'new_') === false) { $item_images[$image_id] = array('id' => $image_id, 'data' => array('alt_text' => \Input::post('alt_text_' . $image_id, ''))); } } // Save images if new files are submitted if (isset($this->_infotab_image_data)) { foreach ($this->_infotab_image_data as $image_data) { $cover_count = count($item->images); if (strpos($image_data['field'], 'new_') === false) { // Update existing image if (str_replace('image_', '', $image_data['field']) != 0) { $image_id = (int) str_replace('image_', '', $image_data['field']); $cover_count--; $item_images[$image_id] = array('id' => $image_id, 'data' => array('infotab_id' => $item->unique_id, 'image' => $image_data['saved_as'], 'alt_text' => \Input::post('alt_text_' . $image_id, ''))); $this->delete_infotab_image(\Input::post('image_db_' . $image_id, '')); } } else { // Save new image $image_tmp = str_replace('image_new_', '', $image_data['field']); $item_images[0] = array('id' => 0, 'data' => array('infotab_id' => $item->unique_id, 'image' => $image_data['saved_as'], 'alt_text' => \Input::post('alt_text_new_' . $image_tmp, ''), 'cover' => $cover_count == 0 ? 1 : 0, 'sort' => $cover_count + 1)); } } } Model_Infotab::bind_images($item_images); /** END OF IMAGES **/ // Get POST values $insert = \Input::post(); // Prep some values $insert['description'] = trim($insert['description']); $insert['active'] = !empty($insert['description']) ? 1 : 0; $item->set($insert); try { $item->save(); \Messages::success('Infotab successfully updated.'); \Response::redirect(\Input::post('exit', false) ? \Uri::create('admin/product/infotab_list/' . $product->id) : \Uri::admin('current')); } catch (\Database_Exception $e) { // show validation errors \Messages::error('<strong>There was an error while trying to update infotab</strong>'); // Uncomment lines below to show database errors //$errors = $e->getMessage(); //\Messages::error($errors); } } else { // Delete uploaded images if there is product saving error if (isset($this->_infotab_image_data)) { foreach ($this->_infotab_image_data as $image_data) { $this->delete_infotab_image($image_data['saved_as']); } } if ($val->error() != array()) { // show validation errors \Messages::error('<strong>There was an error while trying to update infotab</strong>'); foreach ($val->error() as $e) { \Messages::error($e->get_message()); } } } } $item = Model_Product_To_Infotabs::find_by_pk($infotab_id); $theme_partial = \Theme::instance()->set_partial('content', $this->view_dir . 'infotabs_edit_' . strtolower($item->type))->set('product', $product)->set('infotab', $item); if (isset($hotspot)) { $theme_partial->set('hotspot', $hotspot); } }
/** * Edit product hotspot position * * @param $product_id = Product ID * @param $infotab_id = Infotab ID * */ public function action_infotab_hotspot($produt_id = false, $infotab_id = false, $hotspot_id = false) { // Check for product if (!is_numeric($produt_id)) { \Response::redirect('admin/product/list'); } // Get news item to edit if (!($product = Model_Product::find_one_by_id($produt_id))) { \Response::redirect('admin/product/list'); } // Check for infotab if (!is_numeric($infotab_id)) { \Response::redirect('admin/product/list'); } // Get news item to edit if (!($item = Model_Product_To_Infotabs::find_by_pk($infotab_id))) { \Response::redirect('admin/product/list'); } // Get hotspot is exist if (is_numeric($hotspot_id)) { if (!($hotspot = Model_Infotab_Image::find_by_pk($hotspot_id))) { unset($hotspot); } } if (\Input::post()) { $insert = \Input::post(); if (!\Input::is_ajax()) { $val = Model_Infotab_Image::validate('create'); if (!$val->run()) { if ($val->error() != array()) { // show validation errors \Messages::error('<strong>There was an error while trying to create hotspot</strong>'); foreach ($val->error() as $e) { \Messages::error($e->get_message()); } } \Response::redirect(\Uri::create('admin/product/infotab_edit/' . $product->id . '/' . $item->unique_id . (isset($hotspot) ? '/' . $hotspot->id : ''))); } $insert['title'] = trim($insert['title']) != '' ? $insert['title'] : NULL; $insert['description'] = trim($insert['description']) != '' ? $insert['description'] : NULL; } $insert['infotab_id'] = $infotab_id; if (\Input::post('create', false)) { $hotspot = Model_Infotab_Image::forge($insert); try { $hotspot->save(); if (\Input::is_ajax()) { $return['hotspot_id'] = $hotspot->id; echo json_encode($return); exit; } } catch (\Database_Exception $e) { // show validation errors \Messages::error('<strong>There was an error while trying to create hotspot</strong>'); // Uncomment lines below to show database errors $errors = $e->getMessage(); \Messages::error($errors); if (\Input::is_ajax()) { $return['message'] = \Messages::display(); $return['hotspot_id'] = false; echo json_encode($return); exit; } } } if (\Input::post('update', false)) { if (isset($hotspot)) { /** IMAGES **/ // Upload image and display errors if there are any $image = $this->upload_infotab_image(); if (!$image['exists'] && \Config::get('infotab.image.required', false) && empty($hotspot->image)) { // No previous images and image is not selected and it is required \Messages::error('<strong>There was an error while trying to upload hotspot image</strong>'); \Messages::error('You have to select image'); } elseif ($image['errors']) { \Messages::error('<strong>There was an error while trying to upload hotspot image</strong>'); foreach ($image['errors'] as $error) { \Messages::error($error); } } if ($image['is_valid'] && !(!$image['exists'] && \Config::get('infotab.image.required', false) && empty($hotspot->image)) || \Input::post('use_cover_image', false)) { // Clear previous messages if exists \Messages::reset(); $item_image['alt_text'] = \Input::post('alt_text', false) ? \Input::post('alt_text', false) : NULL; // Save images if new files are submitted if (isset($this->_infotab_image_data)) { foreach ($this->_infotab_image_data as $image_data) { $item_image['image'] = $image_data['saved_as']; // Delete old infotab image if (\Input::post('image_db', false)) { $this->delete_infotab_image(\Input::post('image_db', '')); } } } if (isset($item_image)) { $insert['alt_text'] = isset($item_image['alt_text']) ? $item_image['alt_text'] : NULL; $insert['image'] = isset($item_image['image']) ? $item_image['image'] : $hotspot->image; } } else { // Delete uploaded images if there is product saving error if (isset($this->_infotab_image_data)) { foreach ($this->_infotab_image_data as $image_data) { $this->delete_infotab_image($image_data['saved_as']); } } } /** END OF IMAGES **/ /** VIDEOS **/ $item_video['video_title'] = \Input::post('video_title', false) ? \Input::post('video_title', false) : NULL; $item_video['video'] = \Input::post('video_url', false) ? \Input::post('video_url', false) : NULL; if (!is_null($item_video['video'])) { // Check video $youtube = \App\Youtube::forge(); $video = $youtube->parse($item_video['video'])->get(); if (!$video) { \Messages::error('"' . $item_video['video'] . '" is invalid video URL. Video not updated.'); // Revert to old values $item_video['video_title'] = $hotspot->video_title; $item_video['video'] = $hotspot->video; } } if (isset($item_video)) { $insert['video'] = isset($item_video['video']) ? $item_video['video'] : NULL; $insert['video_title'] = isset($item_video['video_title']) ? $item_video['video_title'] : NULL; // Unset video title is there is no video if (is_null($insert['video'])) { $insert['video_title'] = NULL; } } /** END OF: VIDEOS **/ $hotspot->set($insert); try { $hotspot->save(); \Messages::success('Hotspot sucessfully updated.'); } catch (\Database_Exception $e) { // show validation errors \Messages::error('There was an error while trying to update hotspot.'); \Messages::error('Please try again.'); // Uncomment lines below to show database errors $errors = $e->getMessage(); \Messages::error($errors); // Delete uploaded images if there is product saving error if (isset($this->_infotab_image_data)) { foreach ($this->_infotab_image_data as $image_data) { $this->delete_infotab_image($image_data['saved_as']); } } } if (\Input::is_ajax()) { echo \Messages::display(); exit; } } } } \Response::redirect(\Uri::create('admin/product/infotab_edit/' . $product->id . '/' . $item->unique_id . (isset($hotspot) ? '/' . $hotspot->id : ''))); }