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;
 }