Phoca Forum

Code: Select all

<?php

	protected function doExecute(InputInterface $input, OutputInterface $output): int
	{
		$this->loadComponent();
		$this->configureIO($input, $output);
		$db = $this->getDatabase();
		$warnings = [];
		$successCount = 0;
		$itemsCount = 0;

		$query = $db->getQuery(true)
			->select($db->quoteName('p.id'))
			->select($db->quoteName('p.image'))
			->from($db->quoteName('#__phocacart_products') . ' as ' . $db->quoteName('p'))
			->where($db->quoteName('p.image') . ' <> ' . $db->quote(''));

		if ($ids = $input->getOption('id')) {
			$ids = explode(',', $ids);
			$ids = ArrayHelper::toInteger($ids);
			if ($ids)
				$query->where($db->quoteName('p.id') . ' in (' . implode(', ', $ids) . ')');
		}

		if ($categories = $input->getOption('cat')) {
			$categories = explode(',', $categories);
			$categories = ArrayHelper::toInteger($categories);
			if ($categories) {
				$query->join('INNER', $db->quoteName('#__phocacart_product_categories') . ' as ' . $db->quoteName('c'), $db->quoteName('c.product_id') . ' = ' . $db->quoteName('p.id'));
				$query->where($db->quoteName('c.category_id') . ' in (' . implode(', ', $categories) . ')');
			}
		}

		$db->setQuery($query);
		$items = $db->loadObjectList();
		$itemsCount += count($items);
		if ($items) {
			$this->ioStyle->info('Recreating main image thumbnails');
			$this->recreateThumbnails($items, 'productimage', $warnings, $successCount);
		}

		$query = $db->getQuery(true)
			->select($db->quoteName('p.product_id') . ' as ' . $db->quoteName('id'))
			->select($db->quoteName('p.image'))
			->from($db->quoteName('#__phocacart_product_images') . ' as ' . $db->quoteName('p'));

		if ($ids)
			$query->where($db->quoteName('p.product_id') . ' in (' . implode(', ', $ids) . ')');

		if ($categories) {
			$query->join('INNER', $db->quoteName('#__phocacart_product_categories') . ' as ' . $db->quoteName('c'), $db->quoteName('c.product_id') . ' = ' . $db->quoteName('p.product_id'));
			$query->where($db->quoteName('c.category_id') . ' in (' . implode(', ', $categories) . ')');
		}

		$db->setQuery($query);
		$items = $db->loadObjectList();
		$itemsCount += count($items);
		if ($items) {
			$this->ioStyle->info('Recreating additional image thumbnails');
			$this->recreateThumbnails($items, 'productimage', $warnings, $successCount);
		}


		// Recreating thumbs for attribute images
		$query = $db->getQuery(true)
			->select($db->quoteName('p.id'))
			->select($db->quoteName('p.image'))
			->from($db->quoteName('#__phocacart_attribute_values') . ' as ' . $db->quoteName('p'));

			$query->join('INNER', $db->quoteName('#__phocacart_attributes') . ' as ' . $db->quoteName('a'), $db->quoteName('a.id') . ' = ' . $db->quoteName('p.attribute_id'));


			if ($ids) 
				$query->where($db->quoteName('a.product_id') . ' in (' . implode(', ', $ids) . ')');



			if ($categories) {
				$query->join('INNER', $db->quoteName('#__phocacart_product_categories') . ' as ' . $db->quoteName('c'), $db->quoteName('c.product_id') . ' = ' . $db->quoteName('a.product_id'));
				$query->where($db->quoteName('c.category_id') . ' in (' . implode(', ', $categories) . ')');
			}
		
		$db->setQuery($query);
		$items = $db->loadObjectList();
		$itemsCount += count($items);
		if ($items) {
			$this->ioStyle->info('Recreating atribute image thumbnails');
			$this->recreateThumbnails($items, 'productimage', $warnings, $successCount);
		}



		if ($itemsCount == 0) {
			$this->ioStyle->info('Nothing to update');
			return self::RETURN_CODE_SUCCESSFUL;
		}

		if ($warnings) {
			$this->ioStyle->warning('Following errors occured');
			$this->ioStyle->listing($warnings);
		}

		if ($successCount) {
			$this->ioStyle->success($successCount . ' thumbnails recreated successfully');

			if ($warnings)
				return self::RETURN_CODE_PARTIALLY_SUCCESSFUL;
			else
				return self::RETURN_CODE_SUCCESSFUL;
		}

		return self::RETURN_CODE_FAILED;
	}
}

Code: Select all

if (isset($v->id) && (int)$v->id > 0) {
							$query = 'SELECT p.image, p.id'.
									' FROM #__phocacart_attribute_values AS p' .
									' INNER JOIN #__phocacart_attributes as a ON a.id = p.attribute_id' .
									' WHERE a.product_id ='.(int)$v->id;
							$this->_db->setQuery($query);
							$files3 = $this->_db->loadObjectList();
							if (isset($files3) && count($files3)) {
								foreach($files3 as $k3 => $v3) {

									$original3	= PhocacartFile::existsFileOriginal($v3->image, 'productimage');
									if (!$original3) {
										// Original does not exist - cannot generate new thumbnail
										//$message = JText::_('COM_PHOCACART_FILEORIGINAL_NOT_EXISTS');
										//return false;
										continue;
									}

									// Delete old thumbnails
									$deleteThubms3 = PhocacartFileThumbnail::deleteFileThumbnail($v3->image, 1, 1, 1, 'productimage');
									if (!$deleteThubms3) {
										//$message = JText::_('COM_PHOCACART_ERROR_DELETE_THUMBNAIL');
										//return false;
										continue;
									}
									$createThubms3 = PhocacartFileThumbnail::getOrCreateThumbnail($v3->image, 0, 1,1,1,0,'productimage');
									if (!$createThubms3) {
										//$message = JText::_('COM_PHOCACART_ERROR_WHILECREATINGTHUMB');
										//return false;
										continue;
									}

								}
							}
						}