/**
* Constructor
*/
function __construct($file_id, Assets_ee_source $source, $prefetched_row = null)
{
parent::__construct($file_id, $source, $prefetched_row);
$cache =& $this->EE->session->cache['assets'];
$upload_filedir_id = $this->folder_row->filedir_id;
if (!isset($cache['filedir_prefs'][$upload_filedir_id])) {
$cache['filedir_prefs'][$upload_filedir_id] = $this->source->get_filedir($upload_filedir_id);
}
if (empty($cache['filedir_prefs'][$upload_filedir_id])) {
throw new Exception(lang('exception_error'));
}
$this->filedir = $cache['filedir_prefs'][$upload_filedir_id];
$this->subpath = $this->folder_row->full_path . $this->row_field('file_name');
$this->path = $this->filedir->name . '/' . $this->subpath;
$this->server_path = str_replace('//', '/', Assets_ee_source::resolve_server_path($this->filedir->server_path) . $this->subpath);
}
/**
* Migrate data according to a scenario
* @param $scenario
*/
private function _migrate_data($scenario)
{
$this->EE = get_instance();
$db = $this->EE->db;
$this->EE->load->library('assets_lib');
clearstatcache();
switch ($scenario) {
case '<2 -> 2.0':
require_once PATH_THIRD . 'assets/sources/ee/source.ee.php';
$filedirs = array();
$folder_list = array();
// load upload preferences and store them in table for Assets
$rows = $db->get('upload_prefs')->result();
foreach ($rows as $filedir) {
$filedirs[$filedir->id] = Assets_ee_source::apply_filedir_overrides($filedir);
}
// load physical folder structure
foreach ($filedirs as $id => $filedir) {
$filedir->server_path = Assets_ee_source::resolve_server_path($filedir->server_path);
$folder_list[$id][] = $filedir->server_path;
$this->_load_folder_structure($filedir->server_path, $folder_list[$id]);
}
// store the folder structure in database
$subfolders = array();
foreach ($folder_list as $filedir_id => $folders) {
$filedir = $filedirs[$filedir_id];
foreach ($folders as $folder) {
$subpath = substr($folder, strlen($filedir->server_path));
if (empty($subpath)) {
$folder_name = $filedir->name;
$parent_id = NULL;
} else {
$path_parts = explode('/', $subpath);
$folder_name = array_pop($path_parts);
$parent_key = $filedir_id . ':' . rtrim(join('/', $path_parts), '/');
$parent_id = isset($subfolders[$parent_key]) ? $subfolders[$parent_key] : 0;
}
// in case false was returned earlier
$subpath = $subpath ? rtrim($subpath, '/') . '/' : '';
$folder_entry = array('source_type' => 'ee', 'filedir_id' => $filedir_id, 'folder_name' => $folder_name, 'full_path' => $subpath);
if (!is_null($parent_id)) {
$folder_entry['parent_id'] = $parent_id;
}
$this->EE->db->insert('assets_folders', $folder_entry);
$subfolders[$filedir_id . ':' . rtrim($subpath, '/')] = $this->EE->db->insert_id();
}
}
// bring up the list of existing assets and update the entries
$rows = $db->get('assets_files')->result();
$pattern = '/\\{filedir_(?P<filedir_id>[0-9]+)\\}(?P<path>.*)/';
foreach ($rows as $asset) {
$asset->connector = 'ee';
if (preg_match($pattern, $asset->file_name, $matches)) {
if (isset($filedirs[$matches['filedir_id']])) {
$filedir = $filedirs[$matches['filedir_id']];
$full_path = str_replace('{filedir_' . $filedir->id . '}', $filedir->server_path, $asset->file_name);
$subpath = substr($full_path, strlen($filedir->server_path));
$path_parts = explode('/', $subpath);
$file = array_pop($path_parts);
$subpath = join('/', $path_parts);
$folder_key = $matches['filedir_id'] . ':' . $subpath;
if (isset($subfolders[$folder_key])) {
$folder_id = $subfolders[$folder_key];
} else {
$folder_id = 0;
}
$kind = Assets_helper::get_kind($full_path);
$data = array('source_type' => 'ee', 'filedir_id' => $filedir->id, 'folder_id' => $folder_id, 'file_name' => $file, 'kind' => $kind);
if (file_exists($full_path)) {
$data['size'] = filesize($full_path);
$data['date_modified'] = filemtime($full_path);
if ($kind == 'image') {
list($width, $height) = getimagesize($full_path);
$data['width'] = $width;
$data['height'] = $height;
}
}
$this->EE->db->update('assets_files', $data, array('file_id' => $asset->file_id));
$this->EE->assets_lib->update_file_search_keywords($asset->file_id);
}
}
}
// celebrate
break;
case '2.0b1 -> 2.0b2':
// get S3 credentials if any
$query = $this->EE->db->select('settings')->where('name', 'assets')->get('fieldtypes');
$settings = unserialize(base64_decode($query->row('settings')));
$settings = array_merge(array('license_key' => '', 's3_access_key_id' => '', 's3_secret_access_key' => ''), $settings);
//if we have s3 settings, let's convert the "folder_prefs" way to "sources" way
if (!empty($settings['s3_access_key_id']) && !empty($settings['s3_secret_access_key'])) {
$old_sources = $this->EE->db->get('assets_sources')->result();
foreach ($old_sources as $source) {
$previous_settings = json_decode($source->settings);
$new_settings = (object) array('access_key_id' => $settings['s3_access_key_id'], 'secret_access_key' => $settings['s3_secret_access_key'], 'bucket' => $previous_settings->name, 'url_prefix' => $previous_settings->url_prefix, 'location' => $previous_settings->location);
$data = array('name' => $previous_settings->name, 'settings' => Assets_helper::get_json($new_settings));
$this->EE->db->update('assets_sources', $data, array('source_id' => $source->source_id));
}
}
// modify folder data and also keep a list of who's who
$folders = $this->EE->db->get('assets_folders')->result();
$folder_sources = array();
foreach ($folders as $row) {
if ($row->source_type == 'ee') {
$row->filedir_id = $row->source_id;
$row->source_id = NULL;
$this->EE->db->update('assets_folders', $row, array('folder_id' => $row->folder_id));
$folder_sources[$row->folder_id] = $row->filedir_id;
} else {
$folder_sources[$row->folder_id] = $row->source_id;
}
}
// add some data for file entries and we're done!
$files = $this->EE->db->get('assets_files')->result();
foreach ($files as $row) {
if ($row->source_type == 'ee' && isset($folder_sources[$row->folder_id])) {
$row->source_id = NULL;
$row->filedir_id = $folder_sources[$row->folder_id];
$this->EE->db->update('assets_files', $row, array('file_id' => $row->file_id));
} else {
if (isset($folder_sources[$row->folder_id])) {
$row->source_id = $folder_sources[$row->folder_id];
$row->filedir_id = NULL;
$this->EE->db->update('assets_files', $row, array('file_id' => $row->file_id));
}
}
}
// party!
break;
}
}
/**
* Create EE thumbnails.
*
* @param $image_path
* @param $upload_folder_id
* @return mixed
*/
public static function create_ee_thumbnails($image_path, $upload_folder_id)
{
if (!class_exists('Assets_ee_source')) {
require_once PATH_THIRD . 'assets/sources/ee/source.ee.php';
}
$preferences = self::_get_EE()->filemanager->fetch_upload_dir_prefs($upload_folder_id);
$preferences['file_name'] = pathinfo($image_path, PATHINFO_BASENAME);
$preferences['server_path'] = Assets_ee_source::resolve_server_path(Assets_helper::normalize_path($preferences['server_path']));
// Trick Filemanager into creating the thumbnail where WE need it
$preferences['server_path'] .= str_replace($preferences['server_path'], '', str_replace(pathinfo($image_path, PATHINFO_BASENAME), '', $image_path));
// On Windows machines CI's Image_lib gets all sorts of confused, so have to make sure our paths use the DIRECTORY_SEPARATOR separator
if (DIRECTORY_SEPARATOR === "\\") {
$preferences['server_path'] = str_replace('/', '\\', $preferences['server_path']);
$image_path = str_replace('/', '\\', $image_path);
}
return self::_get_EE()->filemanager->create_thumb($image_path, $preferences);
}
/**
* Return an array of all available sources
* @return array
*/
public function get_all_sources()
{
require_once PATH_THIRD . 'assets/sources/ee/source.ee.php';
$ee_filedirs = Assets_ee_source::get_all_filedirs();
$other_sources = $this->EE->db->order_by('name')->get('assets_sources')->result();
$output = array();
foreach ($ee_filedirs as $row) {
$output[$row->name . '_ee_' . $row->site_id] = (object) array('type' => 'ee', 'id' => $row->id, 'name' => $row->name, 'site_id' => $row->site_id);
}
foreach ($other_sources as $row) {
$output[$row->name . '_' . $row->name] = (object) array('type' => $row->source_type, 'id' => $row->source_id, 'name' => $row->name);
}
ksort($output);
return $output;
}
