public function get_edit($id)
{
//LOAD FANCYBOX LIBS
Asset::container('header')->add('fancyboxcss', 'bundles/cms/css/fancybox.css', 'main');
Asset::container('footer')->add('fancybox', 'bundles/cms/js/jquery.fancybox.js', 'jquery');
//LOAD JS LIBS
Asset::container('footer')->add('form', 'bundles/cms/js/jquery.form.js', 'jquery');
Asset::container('footer')->add('files', 'bundles/cms/js/sections/files_edit.js', 'cms');
$this->layout->header_data = array('title' => LL('cms::title.file_edit', CMSLANG));
$this->layout->top_data = array('search' => false);
//GET FILE DATA
$file = CmsFile::with(array('pages', 'filetexts' => function ($query) {
$query->where('lang', '=', LANG);
}))->where_id($id)->first();
if (!empty($file->filetexts)) {
foreach ($file->filetexts as $text) {
$filetext_alt = !empty($text) ? $text->alt : '';
$filetext_title = !empty($text) ? $text->title : '';
$filetext_caption = !empty($text) ? $text->caption : '';
$filetext_label = !empty($text) ? $text->label : '';
}
} else {
$filetext_alt = '';
$filetext_title = '';
$filetext_caption = '';
$filetext_label = '';
}
//GET PAGE DATA
$data = CmsPage::with(array('files'))->where_parent_id(0)->order_by('lang', 'asc')->order_by('is_home', 'desc')->order_by('order_id', 'asc')->get();
$banners = CmsBanner::with(array('files'))->order_by('lang', 'asc')->get();
$galleries = CmsGallery::with(array('files'))->get();
$downloads = CmsDownload::with(array('files'))->get();
//GET SITEMAP ORDER
$new_data = array();
foreach ($data as $obj) {
$new_data[$obj->id] = $obj;
$recursive = call_user_func_array('CmsPage::recursive_filespages', array($obj->id));
$new_data = $new_data + $recursive;
}
if (empty($new_data)) {
$new_data = array();
}
$this->layout->content = View::make('cms::interface.pages.file_edit')->with('title', LL('cms::title.file_edit', CMSLANG))->with('file_id', $id)->with('is_image', (bool) $file->is_image)->with('file_path', $file->path)->with('file_name', $file->name)->with('file_thumb', $file->thumb)->with('file_ext', $file->ext)->with('file_pages', $new_data)->with('langs', Config::get('cms::settings.langs'))->with('filetext_title', $filetext_title)->with('filetext_alt', $filetext_alt)->with('filetext_caption', $filetext_caption)->with('filetext_label', $filetext_label)->with('banners', $banners)->with('galleries', $galleries)->with('downloads', $downloads);
}
public function post_delete()
{
if (Input::has('banner_id')) {
$bid = Input::get('banner_id');
$banner = CmsBanner::find($bid);
//CHECK IF BANNER EXISTS
if (!empty($banner)) {
//DELETE FROM DB
$banner->files()->delete();
$banner->delete();
Notification::success(LL('cms::alert.delete_banner_success', CMSLANG, array('banner' => $banner->name)), 1500);
return Redirect::to_action('cms::banner');
} else {
Notification::error(LL('cms::alert.delete_banner_error', CMSLANG), 2500);
return Redirect::to_action('cms::banner');
}
} else {
Notification::error(LL('cms::alert.delete_banner_error', CMSLANG), 1500);
return Redirect::to_action('cms::banner');
}
}
/**
* BANNER Marker - Shows a banner rotator as saved in Services / Banner
*
* [$BANNER[{
* "name":"<banner name>",
* "thumb":"<thumb type>" => (default: none)
* "type":"<slider name>" => (default: none | available: nivo)
* "theme":"<theme>" => (default: default)
* "caption":"false" => (default: false)
* "w":"",
* "h":"",
* "class":"<class>", => OPTIONAL
* "tpl":"<tpl_name>" => OPTIONAL (in /partials/markers)
* }]]
*
* @param array
* @return string
*/
public static function BANNER($vars = array())
{
//Get variables from array $vars
if (!empty($vars)) {
extract($vars);
}
//Bind variables
$_name = '';
if (isset($name) and !empty($name)) {
$_name = $name;
}
$_type = '';
if (isset($type) and !empty($type)) {
$_type = $type;
}
$_thumb = '';
if (isset($thumb) and !empty($thumb)) {
$_thumb = $thumb;
}
$_theme = 'default';
if (isset($theme) and !empty($theme)) {
$_theme = $theme;
}
$_caption = false;
if (isset($caption) and !empty($caption) and $caption == 'true') {
$_caption = true;
}
$_w = null;
if (isset($w) and !empty($w)) {
$_w = $w;
}
$_h = null;
if (isset($h) and !empty($h)) {
$_h = $h;
}
$_class = 'banner';
if (isset($class) and !empty($class)) {
$_class = $class;
}
$_tpl = 'banner';
if (isset($tpl) and !empty($tpl)) {
$_tpl = $tpl;
}
//FORCE NIVO TPL
if (isset($type) and $type == 'nivo') {
$_tpl = 'nivo';
}
if (!empty($_name)) {
if ($_type == 'nivo') {
//LOAD NIVOSLIDER LIBS
Asset::container('header')->add('nivoslidercss', 'bundles/cms/css/nivoslider.css', 'site_css');
Asset::container('header')->add('nivo' . $_theme, 'bundles/cms/nivoslider/themes/' . $_theme . '/' . $_theme . '.css', 'nivoslidercss');
Asset::container('footer')->add('nivosliderjs', 'bundles/cms/js/jquery.nivoslider.js', 'jquery_lib');
Asset::container('footer')->add('banner', 'js/markers/banner.js', 'site_js');
}
//CACHE DATA
if (CACHE) {
$list = Cache::remember('img_banner_' . $_name . '_' . SITE_LANG, function () use($_name) {
return CmsBanner::with(array('files' => function ($query) {
$query->where('files_banners.date_off', '>=', date('Y-m-d H:i:s'));
}, 'files.filetexts' => function ($query) {
$query->where('lang', '=', SITE_LANG);
}))->where_name($_name)->first();
}, 1440);
} else {
$list = CmsBanner::with(array('files' => function ($query) {
$query->where('files_banners.date_off', '>=', date('Y-m-d H:i:s'));
}, 'files.filetexts' => function ($query) {
$query->where('lang', '=', SITE_LANG);
}))->where_name($_name)->first();
}
//Load file lable and title
if (!empty($list->files)) {
$images = $list->files;
$attr = $list->files;
} else {
$images = array();
$attr = '';
}
} else {
$images = array();
$attr = '';
}
$options = array('id' => $_name, 'class' => $_class);
$thumbs = CONF('cms::theme.thumb', $_thumb);
$view = LOAD_VIEW($_tpl);
$view['images'] = $images;
$view['thumb'] = (strlen($_thumb) > 0 and array_key_exists('suffix', $thumbs)) ? $thumbs['suffix'] : '';
$view['theme'] = $_theme;
$view['attr'] = $attr;
$view['caption'] = $_caption;
$view['w'] = $_w;
$view['h'] = $_h;
$view['options'] = HTML::attributes($options);
return $view;
}
public function post_save_banner()
{
$auth = Auth::check();
if ($auth) {
$input = Input::get();
//GRAB DATA
$banner = new CmsBanner();
if (!empty($input['banner_id'])) {
$banner = CmsBanner::find($input['banner_id']);
}
//VALIDATION CHECK
$rules = array('banner_name' => 'required|alpha_dash|between:2,20|unique_lang:' . $input['banner_id'] . ',' . $input['banner_lang'] . ',banners,name');
$messages = array('required' => LL('cms::validation.required', CMSLANG)->get(), 'between' => LL('cms::validation.between.string', CMSLANG)->get(), 'alpha_dash' => LL('cms::validation.alpha_dash', CMSLANG)->get(), 'unique_lang' => LL('cms::validation.unique', CMSLANG)->get());
$validation = Validator::make($input, $rules, $messages);
if ($validation->fails()) {
return json_encode($validation->errors);
}
$banner->name = strtolower($input['banner_name']);
$banner->lang = $input['banner_lang'];
$banner->save();
//DELETE CACHE
if (CACHE) {
Cache::forget('img_banner_' . strtolower($input['banner_name']));
}
$bid = $banner->id;
if (Input::get('file_id') !== '') {
$files = Input::get('file_id');
$url = Input::get('url');
$date_off = Input::get('date_off');
$is_blank = Input::get('is_blank', array());
if (is_array($files)) {
// Empty template
$template = '';
foreach ($files as $key => $fid) {
$check = DB::table('files_banners')->where_cmsfile_id($fid)->where_cmsbanner_id($bid)->first();
$blank = array_key_exists($key, $is_blank) ? 1 : 0;
if (empty($date_off[$key])) {
$off_date = dateTimeFuture(date("Y-m-d H:i:s"), 'P5Y');
} else {
$off_date = date2Db(substr($date_off[$key], 0, 10));
}
if (empty($check)) {
$add_array = array('url' => $url[$key], 'date_off' => $off_date, 'is_blank' => $blank, 'order_id' => 1000000);
$banner->files()->attach($fid, $add_array);
} else {
$update_array = array('url' => $url[$key], 'date_off' => $off_date, 'is_blank' => $blank);
DB::table('files_banners')->where_cmsfile_id($fid)->where_cmsbanner_id($bid)->update($update_array);
}
$img = CmsFile::find($fid);
// Template returned
$template .= '<li id="' . $bid . '_' . $fid . '" class="span1">';
$template .= '<a class="thumbnail fancy" rel="tooltip" data-original-title="' . $img->name . '" href="' . BASE . $img->path . '">';
$template .= '<img src="' . BASE . $img->thumb . '" />';
$template .= '</a>';
$template .= '</li>';
}
//DELETE NOT IN
DB::table('files_banners')->where_cmsbanner_id($bid)->where_not_in('cmsfile_id', $files)->delete();
}
$response = 'success';
$msg = LL('cms::ajax_resp.banner_save_success', CMSLANG)->get();
$backurl = $input['back_url'];
// Inject container
$inject = 'ul.sortable';
$detach = true;
} else {
//DELETE ALL GALLERY_ID
DB::table('files_banners')->where_cmsbanner_id($bid)->delete();
$response = 'success';
$msg = LL('cms::ajax_resp.banner_save_success', CMSLANG)->get();
$backurl = $input['back_url'];
$template = '';
$inject = '';
$detach = true;
}
} else {
$response = 'error';
$msg = LL('cms::ajax_resp.banner_save_error', CMSLANG)->get();
$backurl = '#';
$template = '';
$inject = '';
$detach = true;
}
$data = array('auth' => $auth, 'cls' => 'banner_id', 'id' => $bid, 'response' => $response, 'message' => $msg, 'backurl' => $backurl, 'detach' => $detach, 'inject' => $inject, 'template' => $template);
return json_encode($data);
}
public function post_add_banner()
{
$auth = Auth::check();
if ($auth and is_numeric(AUTHORID)) {
if (Input::get('banner_id') !== '') {
$fid = Input::get('file_id');
$banners = Input::get('banner_id');
if (is_array($banners)) {
foreach ($banners as $key => $bid) {
$check = DB::table('files_banners')->where_cmsfile_id($fid)->where_cmsbanner_id($bid)->count();
if ($check == 0) {
$banner = CmsBanner::find($bid);
$add_array = array('url' => '', 'date_off' => dateTimeFuture(date("Y-m-d H:i:s"), 'P5Y'), 'is_blank' => 0, 'wm' => 0, 'order_id' => Config::get('cms::settings.order'));
$banner->files()->attach($fid, $add_array);
}
}
//DELETE NOT IN
DB::table('files_banners')->where_cmsfile_id($fid)->where_not_in('cmsbanner_id', $banners)->delete();
$response = 'success';
$msg = LL('cms::ajax_resp.banner_save_success', CMSLANG)->get();
$backurl = Input::get('back_url');
} else {
//DELETE ALL
DB::table('files_banners')->where_cmsfile_id($fid)->delete();
$response = 'success';
$msg = LL('cms::ajax_resp.banner_save_success', CMSLANG)->get();
$backurl = Input::get('back_url');
}
} else {
$response = 'error';
$msg = LL('cms::ajax_resp.banner_save_error', CMSLANG)->get();
$backurl = '#';
}
} else {
$response = 'error';
$msg = LL('cms::ajax_resp.banner_save_error', CMSLANG)->get();
$backurl = '#';
}
$data = array('auth' => $auth, 'cls' => 'file_id', 'id' => $fid, 'response' => $response, 'message' => $msg, 'backurl' => $backurl);
return json_encode($data);
}
