public function action_index()
{
$language_id = Model_Languages::getLangIdByAbbr($this->current_lang);
$catalogs = Model_Catalogs::listAll(2, $language_id);
$view = $this->template->content = View::factory('songs')->set('lang', $this->current_lang)->set('catalogs', $catalogs);
$this->response->body($view);
}
public static function selectLanguages($language_id = false, $is_public = 1)
{
$languages = Model_Languages::listAll($is_public);
//
foreach ($languages as $lang) {
if ($language_id == $lang['language_id']) {
?>
<option value="<?php
echo $lang['language_id'];
?>
" selected><?php
echo $lang['name'];
?>
</option>
<?php
} else {
?>
<option value="<?php
echo $lang['language_id'];
?>
"><?php
echo $lang['name'];
?>
</option>
<?php
}
}
}
public function before()
{
parent::before();
$this->languages = array();
$languages = Model_Languages::listAll();
foreach ($languages as $l) {
$this->languages[] = $l['abbr'];
}
}
public static function getAllLinks($category_id, $source_id = false, $catalog_id = false, $language_id = false)
{
$links = DB::select('links.link_id', 'links.url', 'links.source_id', 'links.title', 'links.catalog_id', 'links.image_name', 'links.language_id', 'links.agegroup_id', 'links.date_added', 'links.is_public')->from('links')->join('catalogs', 'left')->on('links.catalog_id', '=', 'catalogs.catalog_id')->join('categories', 'left')->on('categories.category_id', '=', 'catalogs.category_id')->where('categories.category_id', '=', $category_id);
//
if ($source_id) {
$links = $links->and_where_open();
$links = $links->where('source_id', '=', $source_id);
$links = $links->or_where_close();
}
if ($catalog_id) {
$links = $links->and_where_open();
$links = $links->where('catalog_id', '=', $catalog_id);
$links = $links->or_where_close();
}
//
if ($language_id) {
$links = $links->and_where_open();
$links = $links->where('language_id', '=', $language_id);
$links = $links->or_where_close();
}
$links = $links->order_by('links.date_added', 'DESC');
$links = $links->execute();
$categoryName = Model_Categories::getNameById($category_id);
$final = array();
foreach ($links as $key => $val) {
$final[$key] = $val;
$source = Model_Sources::getProvider($val['source_id']);
$final[$key]['source_id'] = $source['name'];
$catalog = Model_Catalogs::getCatalogById($val['catalog_id']);
$final[$key]['catalog'] = $catalog[0]['name'];
$final[$key]['language_id'] = Model_Languages::getLangIconById($val['language_id']);
if (!empty($val['date_added'])) {
$final[$key]['date_added'] = date('d.m.Y', $val['date_added']);
}
$final[$key]['actions'] = '<a href="' . URL::base() . 'dashboard/edit' . $categoryName . '/' . $val['link_id'] . '" class="btn btn-primary btn-circle Edit' . $categoryName . '" type="button"><i class="fa fa-edit"></i></a> <button data-id="' . $val['link_id'] . '" class="btn btn-danger btn-circle Delete' . $categoryName . '" type="button"><i class="fa fa-remove"></i></button>';
}
return $final;
}
foreach ($catalogs as $catalog) {
?>
<li>
<div class="frame">
<a title="<?php
echo $catalog['name'];
?>
" href="<?php
echo URL::base();
?>
songs/view/<?php
echo $catalog['catalog_id'];
?>
/<?php
echo Model_Languages::getLangIdByAbbr($lang);
?>
">
<img alt="<?php
echo $catalog['name'];
?>
" src="<?php
echo URL::base();
?>
assets/images/catalogs/<?php
echo $catalog['image_name'];
?>
" class="cover-image">
</a>
</div>
</li>
public static function getAll($limit = 0, $offset = 0, $orderby = 'catalog_id', $ordertype = 'ASC')
{
$legsVar = DB::select_array(array('catalog_id', 'category_id', 'name', 'image_name', 'language_id', 'user_id', 'agegroup_id', 'date_added', 'is_public'))->from('catalogs');
// Limit
if ($limit != '' and $limit > 0) {
$legsVar = $legsVar->limit($limit);
}
// Offset
if ($offset != '' and $offset > 0) {
$legsVar = $legsVar->offset($offset);
}
$legsVar = $legsVar->execute();
// print '<pre>'; print_r($legsVar);exit;
//
$final = array();
$i = 0;
foreach ($legsVar as $key => $val) {
$final[$key] = $val;
$final[$key]['category_id'] = Model_Categories::getNameById($val['category_id']);
$final[$key]['language_id'] = Model_Languages::getLangIconById($val['language_id']);
if (!empty($val['date_added'])) {
$final[$key]['date_added'] = date('d.m.Y', $val['date_added']);
}
$final[$key]['actions'] = '<a href="' . URL::base() . 'catalog/edit/' . $val['catalog_id'] . '" class="btn btn-primary btn-circle EditCatalog" type="button"><i class="fa fa-edit"></i></a> <button data-id="' . $val['catalog_id'] . '" class="btn btn-danger btn-circle DeleteCatalog" type="button"><i class="fa fa-remove"></i></button>';
}
return $final;
}
