/**
* 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_Image::find(array('where' => array('content_id' => $item->id), 'order_by' => array('sort' => 'asc')));
}, $item->id, 'images');
// Get content files
$item->get_files = static::lazy_load(function () use($item) {
return Model_File::find(array('where' => array('content_id' => $item->id), 'order_by' => array('sort' => 'asc')));
}, $item->id, 'files');
// Get content videos
$item->get_videos = static::lazy_load(function () use($item) {
return Model_Video::find(array('where' => array('content_id' => $item->id), 'order_by' => array('sort' => 'asc')));
}, $item->id, 'videos');
}
}
}
// return the result
return $result;
}
protected function setUp()
{
if (!($this->files = \Model_File::find('all'))) {
\Util_Develop::output_test_info(__FILE__, __LINE__);
$this->markTestSkipped('No data.');
}
$this->is_save_db = conf('upload.storageType') == 'db';
}
public function action_delete($id = null)
{
if ($file = Model_File::find($id)) {
$file->delete();
Session::set_flash('success', e('Deleted file #' . $id));
} else {
Session::set_flash('error', e('Could not delete file #' . $id));
}
Response::redirect('site/files');
}
/**
* 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_Image::find(array('where' => array('content_id' => $item->id), 'order_by' => array('sort' => 'asc')));
}, $item->id, 'images');
// Get content files
$item->get_files = static::lazy_load(function () use($item) {
return Model_File::find(array('where' => array('content_id' => $item->id), 'order_by' => array('sort' => 'asc')));
}, $item->id, 'files');
// Get content videos
$item->get_videos = static::lazy_load(function () use($item) {
return Model_Video::find(array('where' => array('content_id' => $item->id), 'order_by' => array('sort' => 'asc')));
}, $item->id, 'videos');
// Get content children
$item->get_children = static::lazy_load(function () use($item) {
return Model_Casestudy::find(array('where' => array('parent_id' => $item->id), 'order_by' => array('sort' => 'asc')));
}, $item->id, 'children');
// Get content accordions
$item->get_accordions = static::lazy_load(function () use($item) {
return Model_Accordion::find(array('where' => array('parent_id' => $item->id), 'order_by' => array('sort' => 'asc')));
}, $item->id, 'accordions');
// Get content children
$item->get_seo = static::lazy_load(function () use($item) {
return Model_Seo::find_one_by_content_id($item->id);
}, $item->id, 'seo', 'object');
// Get related products
$item->get_related_products = static::lazy_load(function () use($item) {
$related = Model_Application_To_Related::find(function ($query) use($item) {
return $query->where('application_id', $item->id);
}, 'related_id');
if (!empty($related)) {
$related = '(' . implode(',', array_keys($related)) . ')';
return \Product\Model_Product::find(function ($query) use($related, $item) {
$query->where('id', 'IN', \DB::expr($related));
$query->where('id', '<>', $item->id);
$query->order_by('sort', 'asc');
return $query;
}, 'id');
}
return array();
}, $item->id, 'related_products');
// Get hotspot images
$item->get_hotspot = static::lazy_load(function () use($item) {
$return = new \stdClass();
$return->images = Model_Application_Image::find_by_application_id($item->id);
return $return;
}, $item->id, 'hotspot', 'object');
}
}
}
// return the result
return $result;
}
public static function get_timeline_images($type, $foreign_id, $timeline_id = null, $access_from = null, $is_detail = false)
{
// defaults
$images = array();
$images['file_cate'] = 'ai';
$images['size'] = 'N_M';
$images['column_count'] = 3;
switch ($type) {
case \Config::get('timeline.types.album_image_profile'):
$images['list'] = array();
if ($list = \Album\Model_AlbumImage::check_authority($foreign_id)) {
$images['list'][] = $list;
$images['column_count'] = 2;
}
break;
case \Config::get('timeline.types.profile_image'):
$images['list'] = array();
if ($list = \Model_File::find($foreign_id)) {
$images['list'][] = $list;
$images['file_cate'] = 'm';
$images['size'] = 'LL';
$images['column_count'] = 2;
}
break;
case \Config::get('timeline.types.note'):
list($images['list'], $images['count_all']) = \Note\Model_NoteAlbumImage::get_album_image4note_id($foreign_id, $is_detail ? 0 : \Config::get('timeline.articles.thumbnail.limit.default'), array('id' => 'asc'), true);
$images['parent_page_uri'] = 'note/' . $foreign_id;
break;
case \Config::get('timeline.types.thread'):
list($images['list'], $images['count_all']) = \Thread\Model_ThreadImage::get4thread_id($foreign_id, 3, true);
$images['file_cate'] = 't';
$images['size'] = 'M';
$images['column_count'] = 3;
$images['parent_page_uri'] = 'thread/' . $foreign_id;
break;
case \Config::get('timeline.types.album'):
case \Config::get('timeline.types.album_image'):
$images['list'] = array();
$images['count'] = 0;
if ($album_image_ids = Model_TimelineChildData::get_foreign_ids4timeline_id($timeline_id)) {
list($images['list'], $images['count']) = \Album\Model_AlbumImage::get_list_and_count(array('where' => \Site_Model::get_where_public_flag4access_from($access_from, array(array('id', 'in', $album_image_ids))), $is_detail ? 0 : 'limit' => \Config::get('timeline.articles.thumbnail.limit.default'), 'order_by' => array('created_at' => 'asc')));
}
$images['count_all'] = \Album\Model_AlbumImage::get_list_count(array('where' => \Site_Model::get_where_public_flag4access_from($access_from, array(array('album_id', $foreign_id)))));
$images['parent_page_uri'] = 'album/' . $foreign_id;
break;
case \Config::get('timeline.types.album_image_timeline'):
list($images['list'], $images['count']) = \Album\Model_AlbumImage::get_list_and_count(array('where' => \Site_Model::get_where_public_flag4access_from($access_from, array(array('id', 'in', Model_TimelineChildData::get_foreign_ids4timeline_id($timeline_id)))), $is_detail ? 0 : 'limit' => \Config::get('timeline.articles.thumbnail.limit.album_image_timeline'), 'order_by' => array('created_at' => 'asc')));
$images['count_all'] = $images['count'];
$images['parent_page_uri'] = 'timeline/' . $timeline_id;
break;
default:
break;
}
return $images;
}
/**
* Delete content file
*
* @param $file_id = File ID
* @param $content_id = Content ID
*/
public function action_delete_file($file_id = false, $content_id = false)
{
if ($file_id && $content_id) {
$files = Model_File::find(array('where' => array('content_id' => $content_id), 'order_by' => array('sort' => 'asc')), 'id');
if ($files) {
if (isset($files[$file_id])) {
$file = $files[$file_id];
// If there is only one image and image is required
if (count($files) == 1) {
if (\Config::get('details.file.required', false)) {
\Messages::error('You can\'t delete all files. Please add new file in order to delete this one.');
} else {
// Reset sort fields
\DB::update(Model_File::get_protected('_table_name'))->value('sort', \DB::expr('sort - 1'))->where('sort', '>', $file->sort)->execute();
// Delete file
$this->delete_file($file->file);
$file->delete();
\Messages::success('File was successfully deleted.');
}
} else {
// Dont use cover option for files
if (FALSE && $file->cover == 1) {
\Messages::error('You can\'t delete cover file. Set different file as cover in order to delete this one.');
} else {
// Reset sort fields
\DB::update(Model_File::get_protected('_table_name'))->value('sort', \DB::expr('sort - 1'))->where('sort', '>', $file->sort)->execute();
// Delete file
$this->delete_file($file->file);
$file->delete();
// Set another file as cover if cover is deleted
if ($file->cover == 1) {
$files = Model_File::find(array('where' => array('content_id' => $content_id), 'order_by' => array('sort' => 'asc')));
$files[0]->cover = 1;
$files[0]->save();
}
\Messages::success('File was successfully deleted.');
}
}
} else {
\Messages::error('File you are trying to delete don\'t exists. Check your url and try again.');
}
} else {
\Messages::error('File you are trying to delete don\'t exists. Check your url and try again.');
}
}
\Response::redirect(\Input::referrer(\Uri::create('admin/application/list')));
}
public static function get_content_file($content_id)
{
// Get content files
return Model_File::find(array('where' => array('content_id' => $content_id), 'order_by' => array('sort' => 'asc')));
}
public function test_check_type_profile_image()
{
if (!($list = Model_Timeline::get4type_key('profile_image'))) {
\Util_Develop::output_test_info(__FILE__, __LINE__);
$this->markTestSkipped('No record for test.');
}
foreach ($list as $obj) {
// check for reference data.
$this->assertEquals('file', $obj->foreign_table);
$file = \Model_File::find($obj->foreign_id);
$this->assertNotEmpty($file);
$member = \Model_Member::check_authority($obj->member_id);
$this->assertNotEmpty($member);
$this->assertEquals($member->file_name, $obj->foreign_id);
// check for member_id
$this->assertEquals($file->member_id, $obj->member_id);
// check for public_flag.
$this->assertEquals(FBD_PUBLIC_FLAG_ALL, $obj->public_flag);
// 未使用カラムの値が null か
$this->assertEmpty($obj->body);
}
}
