AKHelper::_('path.setOption', 'com_webgallery');
// Some useful settings
if ($app->isSite()) {
// Include Admin language as global language.
$lang->load('', JPATH_ADMINISTRATOR);
$lang->load('com_webgallery', JPATH_COMPONENT_ADMINISTRATOR);
WebgalleryHelper::_('lang.loadAll', $lang->getTag());
// Include Joomla! admin css
WebgalleryHelper::_('include.sortedStyle', 'includes/css');
// set Base to fix toolbar anchor bug
$doc->setBase(JFactory::getURI()->toString());
} else {
WebgalleryHelper::_('lang.loadAll', $lang->getTag());
WebgalleryHelper::_('include.sortedStyle', 'includes/css');
}
// Include Fields
JForm::addFieldPath(AKPATH_FORM . '/fields');
// Detect version
WebgalleryHelper::_('plugin.attachPlugins');
// Debug
define('AKDEBUG', WebgalleryHelper::_('system.getConfig', 'system.debug', false, 'com_webgallery'));
define('AKDEV', WebgalleryHelper::_('system.getConfig', 'system.development_mode', true, 'com_webgallery'));
/* API Client init
AKHelper::_('api.initClient', null , array(
'username' => 'username' ,
'password' => 'password' ,
'host' => '' ,
'component' => 'com_webgallery'
) );
*/
include_once WEBGALLERY_ADMIN . '/class/thumb.php';
/**
* Build an SQL query to load the list data.
*
* @return JDatabaseQuery
* @since 1.6
*/
protected function getListQuery()
{
// Get some data
// ========================================================================
// Create a new query object.
$db = $this->getDbo();
$q = $db->getQuery(true);
$order = $this->getState('list.ordering', 'a.id');
$dir = $this->getState('list.direction', 'asc');
$prefix = $this->getState('list.orderingPrefix', array());
$orderCol = $this->getState('list.orderCol', 'a.ordering');
// Filter and Search
$filter = $this->getState('filter', array());
$search = $this->getState('search');
$wheres = $this->getState('query.where', array());
$having = $this->getState('query.having', array());
$layout = JRequest::getVar('layout');
$nested = $this->getState('items.nested');
$avoid = JRequest::getVar('avoid');
$show_root = JRequest::getVar('show_root');
// Nested
// ========================================================================
if ($nested && !$show_root) {
$q->where("a.id != 1");
}
if ($avoid) {
$table = $this->getTable();
$table->load($avoid);
$q->where("a.lft < {$table->lft} OR a.rgt > {$table->rgt}");
$q->where("a.id != {$avoid}");
}
// Search
// ========================================================================
$q = $this->searchCondition($search, $q);
// Filter
// ========================================================================
$q = $this->filterCondition($filter, $q);
// published
if (empty($filter['a.published'])) {
$q->where("{$db->qn('a.published')} >= 0");
}
// Ordering
// ========================================================================
if ($orderCol == $order) {
$prefix = count($prefix) ? implode(', ', $prefix) . ', ' : '';
} else {
$prefix = '';
}
$order = $db->qn($order);
// Custom Where
// ========================================================================
foreach ($wheres as $k => $v) {
$q->where($v);
}
// Custom Having
// ========================================================================
foreach ($having as $k => $v) {
$q->having($v);
}
// Build query
// ========================================================================
// get select columns
$select = WebgalleryHelper::_('db.getSelectList', $this->config['tables']);
//build query
$q->select($select)->from('#__webgallery_items AS a')->leftJoin('#__categories AS b ON a.catid = b.id')->leftJoin('#__users AS c ON a.created_by = c.id')->leftJoin('#__viewlevels AS d ON a.access = d.id')->leftJoin('#__languages AS e ON a.language = e.lang_code')->order("{$prefix}{$order} {$dir}");
return $q;
}
$listDirn = $this->state->get('list.direction');
$originalOrders = array();
// For Joomla!3.0
// ================================================================================
if (JVERSION >= 3) {
JHtml::_('bootstrap.tooltip');
JHtml::_('dropdown.init');
JHtml::_('formbehavior.chosen', 'select');
// For Site
if ($app->isSite()) {
WebgalleryHelper::_('include.isis');
}
} else {
// For Site
if ($app->isSite()) {
WebgalleryHelper::_('include.bluestork');
// WebgalleryHelper::_('include.fixBootstrapToJoomla');
}
}
?>
<?php
if (JVERSION >= 3) {
?>
<!-- Sort Table by Filter seletor -->
<script type="text/javascript">
<?php
if ($app->isSite()) {
?>
WindWalker.fixToolbar(40, 300) ;
/**
* Build an SQL query to load the list data.
*
* @return JDatabaseQuery
* @since 1.6
*/
protected function getListQuery()
{
// Create a new query object.
$db = $this->getDbo();
$q = $db->getQuery(true);
$order = $this->getState('list.ordering', 'a.id');
$dir = $this->getState('list.direction', 'asc');
$date = JFactory::getDate('now', JFactory::getConfig()->get('offset'));
$user = JFactory::getUser();
// Filter and Search
$filter = $this->getState('filter', array());
$search = $this->getState('search', array());
$wheres = $this->getState('query.where', array());
$having = $this->getState('query.having', array());
// Category
// =====================================================================================
$category = $this->getCategory();
if (in_array('b.lft', $this->filter_fields) && in_array('b.rgt', $this->filter_fields)) {
$q->where("( b.lft >= {$category->lft} AND b.rgt <= {$category->rgt} )");
}
// Max Level
// =====================================================================================
$maxLevel = $this->getState('filter.max_category_levels', -1);
if ($maxLevel > 0) {
$q->where("b.level <= {$maxLevel}");
}
// Edit Access
// =====================================================================================
if ($this->getState('filter.unpublished')) {
$q->where('a.published >= 0');
} else {
$q->where('a.published > 0');
$nullDate = $db->Quote($db->getNullDate());
$nowDate = $db->Quote($date->toSQL(true));
if (in_array('a.publish_up', $this->filter_fields) && in_array('a.publish_down', $this->filter_fields)) {
// $q->where('(a.publish_up = ' . $nullDate . ' OR a.publish_up <= ' . $nowDate . ')');
// $q->where('(a.publish_down = ' . $nullDate . ' OR a.publish_down >= ' . $nowDate . ')');
}
}
// View Level
// =====================================================================================
if ($access = $this->getState('filter.access') && in_array('a.access', $this->filter_fields)) {
$groups = implode(',', $user->getAuthorisedViewLevels());
$q->where('a.access IN (' . $groups . ')');
}
// Language
// =====================================================================================
if ($this->getState('filter.language') && in_array('a.language', $this->filter_fields)) {
$lang_code = $db->quote(JFactory::getLanguage()->getTag());
$q->where("a.language IN ('{$lang_code}', '*')");
}
// Filter
// ========================================================================
foreach ($filter as $k => $v) {
if ($v !== '' && $v != '*' && in_array($k, $this->filter_fields)) {
$k = $db->qn($k);
$q->where("{$k}='{$v}'");
}
}
// Search
// ========================================================================
$searc_where = array();
foreach ($search as $k => $v) {
if (in_array($k, $this->filter_fields)) {
$k = $db->qn($k);
$searc_where[] = "{$k} LIKE '{$v}'";
}
}
if (count($searc_where)) {
$q->where(' ( ' . implode(' OR ', $searc_where) . ' ) ');
}
// Custom Where
// ========================================================================
foreach ($wheres as $k => $v) {
$q->where($v);
}
// Custom Having
// ========================================================================
foreach ($having as $k => $v) {
$q->having($v);
}
// get select columns
$select = WebgalleryHelper::_('db.getSelectList', $this->config['tables']);
//build query
$q->select($select)->from('#__categories AS a')->leftJoin('#__users AS c ON a.created_user_id = c.id')->leftJoin('#__viewlevels AS d ON a.access = d.id')->leftJoin('#__languages AS e ON a.language = e.lang_code')->where("a.extension = 'com_webgallery'")->order(" {$order} {$dir}");
return $q;
}
<?php
/**
* @package Joomla.Administrator
* @subpackage com_webgallery
*
* @copyright Copyright (C) 2012 Asikart. All rights reserved.
* @license GNU General Public License version 2 or later; see LICENSE.txt
* @author Generated by AKHelper - http://asikart.com
*/
// no direct access
defined('_JEXEC') or die;
if (AKDEBUG) {
WebgalleryHelper::_('include.quickedit');
}
// Init some API objects
// ================================================================================
$app = JFactory::getApplication();
$date = JFactory::getDate('now', JFactory::getConfig()->get('offset'));
$doc = JFactory::getDocument();
$uri = JFactory::getURI();
$user = JFactory::getUser();
$userId = $user->get('id');
// List Control
// ================================================================================
$nested = $this->state->get('items.nested');
$listOrder = $this->state->get('list.ordering');
$listDirn = $this->state->get('list.direction');
$orderCol = $this->state->get('list.orderCol', 'a.ordering');
$canOrder = $user->authorise('core.edit.state', 'com_webgallery');
$saveOrder = $listOrder == $orderCol || $listOrder == 'a.lft' && $listDirn == 'asc';
<?php
/**
* @package Joomla.Administrator
* @subpackage com_webgallery
*
* @copyright Copyright (C) 2012 Asikart. All rights reserved.
* @license GNU General Public License version 2 or later; see LICENSE.txt
* @author Generated by AKHelper - http://asikart.com
*/
// no direct access
defined('_JEXEC') or die;
JHtml::_('behavior.tooltip');
WebgalleryHelper::_('include.bootstrap', true);
$user = JFactory::getUser();
$userId = $user->get('id');
$listOrder = $this->state->get('list.ordering');
$listDirn = $this->state->get('list.direction');
$canOrder = $user->authorise('core.edit.state', 'com_webgallery');
$saveOrder = $listOrder == 'a.ordering';
?>
<form action="<?php
echo JRoute::_('index.php?option=com_webgallery&view=items');
?>
" method="post" name="adminForm" id="adminForm">
<div id="webgallery-wrap" class="windwalker list container-fluid items<?php
echo $this->get('pageclass_sfx');
?>
">
<div id="webgallery-wrap-inner">
?>
<div id="<?php
echo $anchor_id;
?>
" class="categories-item item">
<div class="categories-item-inner">
<?php
if ($canEdit) {
?>
<!-- Edit -->
<!-- ============================================================================= -->
<div class="edit-icon btn-toolbar fltrt">
<div class="btn-group">
<?php
echo JHtml::_('link', JRoute::_('index.php?option=com_webgallery&task=category.edit&id=' . $item->a_id . '&return=' . WebgalleryHelper::_('uri.base64', 'encode', $uri->toString())), JText::_('JTOOLBAR_EDIT'), array('class' => 'btn btn-small'));
?>
<button class="btn btn-small dropdown-toggle" data-toggle="dropdown">
<span class="caret"></span>
</button>
<ul class="dropdown-menu">
<li>
<a class="jgrid" href="javascript:void(0);" onclick="return listItemTask('cb<?php
echo $item->a_id;
?>
','categories.publish')" title="啟用"><?php
echo JText::_('JTOOLBAR_ENABLE');
?>
</a>
</li>
<li>
function webgalleryLoader($uri)
{
return WebgalleryHelper::_('loader.import', $uri);
}
/**
* Build an SQL query to load the list data.
*
* @return JDatabaseQuery
* @since 1.6
*/
protected function getListQuery()
{
// Get some data
// ========================================================================
// Create a new query object.
$db = $this->getDbo();
$q = $db->getQuery(true);
$order = $this->getState('list.ordering', 'a.id');
$dir = $this->getState('list.direction', 'asc');
$prefix = $this->getState('list.orderingPrefix', array());
$orderCol = $this->getState('list.orderCol', 'a.ordering');
// Filter and Search
$filter = $this->getState('filter', array());
$search = $this->getState('search');
$wheres = $this->getState('query.where', array());
$having = $this->getState('query.having', array());
$layout = JRequest::getVar('layout');
$show_root = JRequest::getVar('show_root');
// Search
// ========================================================================
$q = $this->searchCondition($search, $q);
// Filter
// ========================================================================
$q = $this->filterCondition($filter, $q);
// Custom Where
// ========================================================================
foreach ($wheres as $k => $v) {
$q->where($v);
}
// Custom Having
// ========================================================================
foreach ($having as $k => $v) {
$q->having($v);
}
// Build query
// ========================================================================
// get select columns
$select = WebgalleryHelper::_('db.getSelectList', $this->config['tables']);
//build query
$q->select($select)->from('#__webgallery_thumbnails AS a')->leftJoin('#__webgallery_items AS b ON a.item_id = b.id')->order("a.id {$dir}");
return $q;
}
</div>
</div>
<div class="clr"></div>
<?php
echo $tabs ? WebgalleryHelper::_('panel.endPanel', 'itemTab', $group) : null;
?>
<?php
}
?>
<?php
echo $tabs ? WebgalleryHelper::_('panel.endTabs') : null;
?>
<!-- Hidden Inputs -->
<div id="hidden-inputs">
<input type="hidden" name="option" value="com_webgallery" />
<input type="hidden" name="task" value="" />
<?php
echo JHtml::_('form.token');
?>
</div>
<div class="clr"></div>
</form>
</div>
