public function import_from_perch_gallery()
{
$sql = 'SELECT COUNT(*) FROM ' . PERCH_DB_PREFIX . 'gallery_images';
$count = $this->db->get_count($sql);
if ($count) {
$Resources = new PerchResources();
$sql = "SELECT i.imageID, i.imageBucket AS bucket, i.albumID, iv.versionPath AS file, i.imageAlt AS title, iv.versionWidth AS width, iv.versionHeight AS height\n FROM `" . PERCH_DB_PREFIX . "gallery_image_versions` iv, `" . PERCH_DB_PREFIX . "gallery_images` i\n WHERE iv.imageID=i.imageID AND iv.versionKey='original' AND i.imageStatus='active'";
$originals = $this->db->get_rows($sql);
if (PerchUtil::count($originals)) {
foreach ($originals as $orig) {
$sql = 'SELECT COUNT(*) FROM ' . PERCH_DB_PREFIX . 'resources WHERE resourceFile=' . $this->db->pdb($orig['file']) . ' AND resourceBucket=' . $this->db->pdb($orig['bucket']) . ' AND resourceKey=' . $this->db->pdb('orig');
if ($this->db->get_count($sql)) {
continue;
}
$parentID = $Resources->log('perch_gallery', $orig['bucket'], $orig['file'], 0, 'orig', false, array('w' => $orig['width'], 'h' => $orig['height'], 'title' => $orig['title']));
if ($parentID) {
$this->db->insert(PERCH_DB_PREFIX . 'resource_log', array('appID' => 'perch_gallery', 'itemFK' => 'albumID', 'itemRowID' => $orig['albumID'], 'resourceID' => $parentID), true);
$sql = "SELECT i.imageID, i.imageBucket AS bucket, i.albumID, iv.versionPath AS file, i.imageAlt AS title, iv.versionWidth AS width, iv.versionHeight AS height\n FROM `" . PERCH_DB_PREFIX . "gallery_image_versions` iv, `" . PERCH_DB_PREFIX . "gallery_images` i\n WHERE iv.imageID=i.imageID AND iv.versionKey='admin_thumb' AND i.imageStatus='active' AND i.imageID=" . $this->db->pdb($orig['imageID']) . ' LIMIT 1';
$thumb = $this->db->get_row($sql);
if ($thumb) {
$thumbID = $Resources->log('perch_gallery', $thumb['bucket'], $thumb['file'], $parentID, 'thumb', false, array('w' => $thumb['width'], 'h' => $thumb['height'], 'target_w' => '150', 'target_h' => '150', 'title' => $thumb['title']));
}
}
}
}
}
}
public function get_raw($post = false, $Item = false)
{
$store = array();
$Perch = Perch::fetch();
$Bucket = PerchResourceBuckets::get($this->Tag->bucket());
$image_folder_writable = $Bucket->ready_to_write();
$item_id = $this->Tag->input_id();
$asset_reference_used = false;
$target = false;
$filesize = false;
if (!class_exists('PerchAssets_Assets', false)) {
include_once PERCH_CORE . '/apps/assets/PerchAssets_Assets.class.php';
include_once PERCH_CORE . '/apps/assets/PerchAssets_Asset.class.php';
}
$Assets = new PerchAssets_Assets();
$AssetMeta = false;
// Asset ID?
if (isset($post[$this->Tag->id() . '_assetID']) && $post[$this->Tag->id() . '_assetID'] != '') {
$new_assetID = $post[$this->Tag->id() . '_assetID'];
$Asset = $Assets->find($new_assetID);
if (is_object($Asset)) {
$target = $Asset->file_path();
$filename = $Asset->resourceFile();
$store['assetID'] = $Asset->id();
$store['title'] = $Asset->resourceTitle();
$store['_default'] = $Asset->web_path();
$store['bucket'] = $Asset->resourceBucket();
if ($store['bucket'] != $Bucket->get_name()) {
$Bucket = PerchResourceBuckets::get($store['bucket']);
}
$asset_reference_used = true;
}
}
if ($image_folder_writable && isset($_FILES[$item_id]) && (int) $_FILES[$item_id]['size'] > 0) {
if (!isset(self::$file_paths[$this->Tag->id()])) {
// We do this before writing to the bucket, as it performs better for remote buckets.
$AssetMeta = $Assets->get_meta_data($_FILES[$item_id]['tmp_name'], $_FILES[$item_id]['name']);
$result = $Bucket->write_file($_FILES[$item_id]['tmp_name'], $_FILES[$item_id]['name']);
$target = $result['path'];
$filename = $result['name'];
$filesize = (int) $_FILES[$item_id]['size'];
$store['_default'] = rtrim($Bucket->get_web_path(), '/') . '/' . $filename;
// fire events
if ($this->Tag->type() == 'image') {
$PerchImage = new PerchImage();
$profile = $PerchImage->get_resize_profile($target);
$profile['original'] = true;
$Perch->event('assets.upload_image', new PerchAssetFile($profile));
}
}
}
if ($target && $filename && is_file($target)) {
self::$file_paths[$this->Tag->id()] = $target;
$store['path'] = $filename;
$store['size'] = $filesize ?: filesize($target);
$store['bucket'] = $Bucket->get_name();
// Is this an SVG?
$svg = false;
$size = getimagesize($target);
if (PerchUtil::count($size)) {
$store['w'] = $size[0];
$store['h'] = $size[1];
if (isset($size['mime'])) {
$store['mime'] = $size['mime'];
}
} else {
$PerchImage = new PerchImage();
if ($PerchImage->is_webp($target)) {
$store['mime'] = 'image/webp';
} elseif ($PerchImage->is_svg($target)) {
$svg = true;
$size = $PerchImage->get_svg_size($target);
if (PerchUtil::count($size)) {
$store['w'] = $size['w'];
$store['h'] = $size['h'];
if (isset($size['mime'])) {
$store['mime'] = $size['mime'];
}
}
} else {
// It's not an image (according to getimagesize) and not an SVG.
if ($this->Tag->detect_type()) {
// if we have permission to guess, our guess is that it's a file.
PerchUtil::debug('Guessing file', 'error');
$this->Tag->set('type', 'file');
}
$store['mime'] = PerchUtil::get_mime_type($target);
}
}
// thumbnail
if ($this->Tag->type() == 'image') {
$PerchImage = new PerchImage();
$PerchImage->set_density(2);
$result = false;
if ($asset_reference_used) {
$result = $Assets->get_resize_profile($store['assetID'], 150, 150, false, 'thumb', $PerchImage->get_density());
}
if (!$result) {
$result = $PerchImage->resize_image($target, 150, 150, false, 'thumb');
}
if (is_array($result)) {
//PerchUtil::debug($result, 'notice');
if (!isset($store['sizes'])) {
$store['sizes'] = array();
}
$variant_key = 'thumb';
$tmp = array();
$tmp['w'] = $result['w'];
$tmp['h'] = $result['h'];
$tmp['target_w'] = 150;
$tmp['target_h'] = 150;
$tmp['density'] = 2;
$tmp['path'] = $result['file_name'];
$tmp['size'] = filesize($result['file_path']);
$tmp['mime'] = isset($result['mime']) ? $result['mime'] : '';
if ($result && isset($result['_resourceID'])) {
$tmp['assetID'] = $result['_resourceID'];
}
$store['sizes'][$variant_key] = $tmp;
}
unset($result);
unset($PerchImage);
}
if ($this->Tag->type() == 'file') {
$PerchImage = new PerchImage();
$PerchImage->set_density(2);
$result = $PerchImage->thumbnail_file($target, 150, 150, false);
if (is_array($result)) {
if (!isset($store['sizes'])) {
$store['sizes'] = array();
}
$variant_key = 'thumb';
$tmp = array();
$tmp['w'] = $result['w'];
$tmp['h'] = $result['h'];
$tmp['target_w'] = 150;
$tmp['target_h'] = 150;
$tmp['density'] = 2;
$tmp['path'] = $result['file_name'];
$tmp['size'] = filesize($result['file_path']);
$tmp['mime'] = isset($result['mime']) ? $result['mime'] : '';
if ($result && isset($result['_resourceID'])) {
$tmp['assetID'] = $result['_resourceID'];
}
$store['sizes'][$variant_key] = $tmp;
}
unset($result);
unset($PerchImage);
}
}
// Loop through all tags with this ID, get their dimensions and resize the images.
$all_tags = $this->get_sibling_tags();
if (PerchUtil::count($all_tags)) {
foreach ($all_tags as $Tag) {
if ($Tag->id() == $this->Tag->id()) {
// This is either this tag, or another tag in the template with the same ID.
if ($Tag->type() == 'image' && ($Tag->width() || $Tag->height()) && isset(self::$file_paths[$Tag->id()])) {
$variant_key = 'w' . $Tag->width() . 'h' . $Tag->height() . 'c' . ($Tag->crop() ? '1' : '0') . ($Tag->density() ? '@' . $Tag->density() . 'x' : '');
if (!isset($store['sizes'][$variant_key])) {
$PerchImage = new PerchImage();
if ($Tag->quality()) {
$PerchImage->set_quality($Tag->quality());
}
if ($Tag->is_set('sharpen')) {
$PerchImage->set_sharpening($Tag->sharpen());
}
if ($Tag->density()) {
$PerchImage->set_density($Tag->density());
}
$result = false;
if ($asset_reference_used) {
$result = $Assets->get_resize_profile($store['assetID'], $Tag->width(), $Tag->height(), $Tag->crop(), false, $PerchImage->get_density());
}
if (!$result) {
$result = $PerchImage->resize_image(self::$file_paths[$Tag->id()], $Tag->width(), $Tag->height(), $Tag->crop());
}
if (is_array($result)) {
if (!isset($store['sizes'])) {
$store['sizes'] = array();
}
$tmp = array();
$tmp['w'] = $result['w'];
$tmp['h'] = $result['h'];
$tmp['target_w'] = $Tag->width();
$tmp['target_h'] = $Tag->height();
$tmp['crop'] = $Tag->crop();
$tmp['density'] = $Tag->density() ? $Tag->density() : '1';
$tmp['path'] = $result['file_name'];
$tmp['size'] = filesize($result['file_path']);
$tmp['mime'] = isset($result['mime']) ? $result['mime'] : '';
if ($result && isset($result['_resourceID'])) {
$tmp['assetID'] = $result['_resourceID'];
}
$store['sizes'][$variant_key] = $tmp;
unset($tmp);
}
unset($result);
unset($PerchImage);
}
}
}
}
}
if (isset($_POST[$item_id . '_remove'])) {
$store = array();
}
// If a file isn't uploaded...
if (!$asset_reference_used && (!isset($_FILES[$item_id]) || (int) $_FILES[$item_id]['size'] == 0)) {
// If remove is checked, remove it.
if (isset($_POST[$item_id . '_remove'])) {
$store = array();
} else {
// Else get the previous data and reuse it.
if (is_object($Item)) {
$json = PerchUtil::json_safe_decode($Item->itemJSON(), true);
if (PerchUtil::count($json) && $this->Tag->in_repeater() && $this->Tag->tag_context()) {
$waypoints = preg_split('/_([0-9]+)_/', $this->Tag->tag_context(), null, PREG_SPLIT_DELIM_CAPTURE);
if (PerchUtil::count($waypoints) > 0) {
$subject = $json;
foreach ($waypoints as $waypoint) {
if (isset($subject[$waypoint])) {
$subject = $subject[$waypoint];
} else {
$subject = false;
}
$store = $subject;
}
}
}
if (PerchUtil::count($json) && isset($json[$this->Tag->id()])) {
$store = $json[$this->Tag->id()];
}
} else {
if (is_array($Item)) {
$json = $Item;
if (PerchUtil::count($json) && isset($json[$this->Tag->id()])) {
$store = $json[$this->Tag->id()];
}
}
}
}
}
// log resources
if (PerchUtil::count($store) && isset($store['path'])) {
$Resources = new PerchResources();
// Main image
$parentID = $Resources->log($this->app_id, $store['bucket'], $store['path'], 0, 'orig', false, $store, $AssetMeta);
// variants
if (isset($store['sizes']) && PerchUtil::count($store['sizes'])) {
foreach ($store['sizes'] as $key => $size) {
$Resources->log($this->app_id, $store['bucket'], $size['path'], $parentID, $key, false, $size, $AssetMeta);
}
}
// Additional IDs from the session
if (PerchSession::is_set('resourceIDs')) {
$ids = PerchSession::get('resourceIDs');
if (is_array($ids) && PerchUtil::count($ids)) {
$Resources->log_extra_ids($ids);
}
PerchSession::delete('resourceIDs');
}
}
self::$file_paths = array();
// Check it's not an empty array
if (is_array($store) && count($store) === 0) {
return null;
}
return $store;
}