function wppa_admin_albums_collapsable()
{
global $wpdb;
// Read the albums
$albums = $wpdb->get_results("SELECT * FROM `" . WPPA_ALBUMS . "` ORDER BY `id`", ARRAY_A);
// Find the ordering method
$reverse = false;
if (isset($_REQUEST['order_by'])) {
$order = $_REQUEST['order_by'];
} else {
$order = '';
}
if (!$order) {
$order = get_option('wppa_album_order_' . wppa_get_user(), 'id');
$reverse = get_option('wppa_album_order_' . wppa_get_user() . '_reverse') == 'yes';
} else {
$old_order = get_option('wppa_album_order_' . wppa_get_user(), 'id');
$reverse = get_option('wppa_album_order_' . wppa_get_user() . '_reverse') == 'yes';
if ($old_order == $order) {
$reverse = !$reverse;
} else {
$reverse = false;
}
update_option('wppa_album_order_' . wppa_get_user(), $order);
if ($reverse) {
update_option('wppa_album_order_' . wppa_get_user() . '_reverse', 'yes');
} else {
update_option('wppa_album_order_' . wppa_get_user() . '_reverse', 'no');
}
}
if (!empty($albums)) {
// Setup the sequence array
$seq = false;
$num = false;
foreach ($albums as $album) {
switch ($order) {
case 'name':
$seq[] = strtolower(__(stripslashes($album['name'])));
break;
case 'description':
$seq[] = strtolower(__(stripslashes($album['description'])));
break;
case 'owner':
$seq[] = strtolower($album['owner']);
break;
case 'a_order':
$seq[] = $album['a_order'];
$num = true;
break;
case 'a_parent':
$seq[] = strtolower(wppa_get_album_name($album['a_parent']), 'extended');
break;
default:
$seq[] = $album['id'];
$num = true;
break;
}
}
// Sort the seq array
if ($num) {
asort($seq, SORT_NUMERIC);
} else {
asort($seq, SORT_REGULAR);
}
// Reverse ?
if ($reverse) {
$t = $seq;
$c = count($t);
$tmp = array_keys($t);
$seq = false;
for ($i = $c - 1; $i >= 0; $i--) {
$seq[$tmp[$i]] = '0';
}
}
$downimg = '<img src="' . wppa_get_imgdir() . 'down.png" alt="down" style=" height:12px; position:relative; top:2px; " />';
$upimg = '<img src="' . wppa_get_imgdir() . 'up.png" alt="up" style=" height:12px; position:relative; top:2px; " />';
?>
<!-- <div class="table_wrapper"> -->
<table class="widefat wppa-table wppa-setting-table" style="margin-top:12px;" >
<thead>
<tr>
<td style="min-width:20px;" >
<img src="<?php
echo wppa_get_imgdir() . 'backarrow.gif';
?>
" style="height:16px;" title="<?php
_e('Collapse subalbums', 'wp-photo-album-plus');
?>
" />
<img src="<?php
echo wppa_get_imgdir() . 'arrow.gif';
?>
" style="height:16px;" title="<?php
_e('Expand subalbums', 'wp-photo-album-plus');
?>
" />
</td>
<?php
$url = get_admin_url() . 'admin.php?page=wppa_admin_menu&order_by=';
?>
<td colspan="6" style="min-width: 50px;" >
<a href="<?php
echo wppa_dbg_url($url . 'id');
?>
">
<?php
_e('ID', 'wp-photo-album-plus');
if ($order == 'id') {
if ($reverse) {
echo $upimg;
} else {
echo $downimg;
}
}
?>
</a>
</td>
<td style="min-width: 120px;">
<a href="<?php
echo wppa_dbg_url($url . 'name');
?>
">
<?php
_e('Name', 'wp-photo-album-plus');
if ($order == 'name') {
if ($reverse) {
echo $upimg;
} else {
echo $downimg;
}
}
?>
</a>
</td>
<td >
<a href="<?php
echo wppa_dbg_url($url . 'description');
?>
">
<?php
_e('Description', 'wp-photo-album-plus');
if ($order == 'description') {
if ($reverse) {
echo $upimg;
} else {
echo $downimg;
}
}
?>
</a>
</td>
<?php
if (current_user_can('administrator')) {
?>
<td style="min-width: 100px;">
<a href="<?php
echo wppa_dbg_url($url . 'owner');
?>
">
<?php
_e('Owner', 'wp-photo-album-plus');
if ($order == 'owner') {
if ($reverse) {
echo $upimg;
} else {
echo $downimg;
}
}
?>
</a>
</td>
<?php
}
?>
<td style="min-width: 100px;" >
<a href="<?php
echo wppa_dbg_url($url . 'a_order');
?>
">
<?php
_e('Order', 'wp-photo-album-plus');
if ($order == 'a_order') {
if ($reverse) {
echo $upimg;
} else {
echo $downimg;
}
}
?>
</a>
</td>
<td style="width: 120px;">
<a href="<?php
echo wppa_dbg_url($url . 'a_parent');
?>
">
<?php
_e('Parent', 'wp-photo-album-plus');
if ($order == 'a_parent') {
if ($reverse) {
echo $upimg;
} else {
echo $downimg;
}
}
?>
</a>
</td>
<td title="<?php
_e('Albums/Photos/Moderation required/Scheduled', 'wp-photo-album-plus');
?>
" >
<?php
_e('A/P/PM/S', 'wp-photo-album-plus');
?>
</td>
<td ><?php
_e('Edit', 'wp-photo-album-plus');
?>
</td>
<td ><?php
_e('Quick', 'wp-photo-album-plus');
?>
</td>
<td ><?php
_e('Bulk', 'wp-photo-album-plus');
?>
</td>
<td ><?php
_e('Seq', 'wp-photo-album-plus');
?>
</td>
<td ><?php
_e('Delete', 'wp-photo-album-plus');
?>
</td>
<?php
if (wppa_can_create_album()) {
echo '<td >' . __('Create', 'wp-photo-album-plus') . '</td>';
}
?>
</tr>
</thead>
<tbody>
<?php
wppa_do_albumlist('0', '0', $albums, $seq);
?>
<?php
if ($wpdb->get_var("SELECT COUNT(*) FROM `" . WPPA_ALBUMS . "` WHERE `a_parent` = '-1'") > 0) {
?>
<tr>
<td colspan="19" ><em><?php
_e('The following albums are ---separate--- and do not show up in the generic album display', 'wp-photo-album-plus');
?>
</em></td>
</tr>
<?php
wppa_do_albumlist('-1', '0', $albums, $seq);
?>
<?php
}
wppa_search_edit(true);
?>
</tbody>
<tfoot>
<tr>
<td>
<img src="<?php
echo wppa_get_imgdir() . 'backarrow.gif';
?>
" style="height:16px;" />
<img src="<?php
echo wppa_get_imgdir() . 'arrow.gif';
?>
" style="height:16px;" />
</td>
<?php
$url = get_admin_url() . 'admin.php?page=wppa_admin_menu&order_by=';
?>
<td colspan="6" >
<a href="<?php
echo wppa_dbg_url($url . 'id');
?>
">
<?php
_e('ID', 'wp-photo-album-plus');
if ($order == 'id') {
if ($reverse) {
echo $upimg;
} else {
echo $downimg;
}
}
?>
</a>
</td>
<td style="width: 120px;">
<a href="<?php
echo wppa_dbg_url($url . 'name');
?>
">
<?php
_e('Name', 'wp-photo-album-plus');
if ($order == 'name') {
if ($reverse) {
echo $upimg;
} else {
echo $downimg;
}
}
?>
</a>
</td>
<td >
<a href="<?php
echo wppa_dbg_url($url . 'description');
?>
">
<?php
_e('Description', 'wp-photo-album-plus');
if ($order == 'description') {
if ($reverse) {
echo $upimg;
} else {
echo $downimg;
}
}
?>
</a>
</td>
<?php
if (current_user_can('administrator')) {
?>
<td style="width: 100px;">
<a href="<?php
echo wppa_dbg_url($url . 'owner');
?>
">
<?php
_e('Owner', 'wp-photo-album-plus');
if ($order == 'owner') {
if ($reverse) {
echo $upimg;
} else {
echo $downimg;
}
}
?>
</a>
</td>
<?php
}
?>
<td >
<a href="<?php
echo wppa_dbg_url($url . 'a_order');
?>
">
<?php
_e('Order', 'wp-photo-album-plus');
if ($order == 'a_order') {
if ($reverse) {
echo $upimg;
} else {
echo $downimg;
}
}
?>
</a>
</td>
<td style="width: 120px;">
<a href="<?php
echo wppa_dbg_url($url . 'a_parent');
?>
">
<?php
_e('Parent', 'wp-photo-album-plus');
if ($order == 'a_parent') {
if ($reverse) {
echo $upimg;
} else {
echo $downimg;
}
}
?>
</a>
</td>
<td title="<?php
_e('Albums/Photos/Moderation required/Scheduled', 'wp-photo-album-plus');
?>
" >
<?php
_e('A/P/PM/S', 'wp-photo-album-plus');
?>
</td>
<td ><?php
_e('Edit', 'wp-photo-album-plus');
?>
</td>
<td ><?php
_e('Quick', 'wp-photo-album-plus');
?>
</td>
<td ><?php
_e('Bulk', 'wp-photo-album-plus');
?>
</td>
<td ><?php
_e('Seq', 'wp-photo-album-plus');
?>
</td>
<td ><?php
_e('Delete', 'wp-photo-album-plus');
?>
</td>
<?php
if (wppa_can_create_album()) {
echo '<td >' . __('Create', 'wp-photo-album-plus') . '</td>';
}
?>
</tr>
</tfoot>
</table>
<script type="text/javascript" >
function checkArrows() {
elms = jQuery('.alb-arrow-off');
for(i=0;i<elms.length;i++) {
elm = elms[i];
if ( elm.parentNode.parentNode.style.display == 'none' ) elm.style.display = 'none';
}
elms = jQuery('.alb-arrow-on');
for(i=0;i<elms.length;i++) {
elm = elms[i];
if ( elm.parentNode.parentNode.style.display == 'none' ) elm.style.display = '';
}
}
</script>
<!-- </div> -->
<?php
wppa_album_admin_footer();
} else {
?>
<p><?php
_e('No albums yet.', 'wp-photo-album-plus');
?>
</p>
<?php
}
}
function wppa_admin_albums_collapsable()
{
global $wpdb;
// Init
$pagesize = wppa_opt('album_admin_pagesize');
$page = '1';
$skips = '0';
$pages = '1';
// Find out what page to show
if ($pagesize) {
if (isset($_REQUEST['album-page-no'])) {
$page = strval(intval($_REQUEST['album-page-no']));
$page = max($page, '1');
$skips = ($page - 1) * $pagesize;
}
}
// Read all albums, pre-ordered
$albums = $wpdb->get_results("SELECT * FROM `" . WPPA_ALBUMS . "` ORDER BY " . get_option('wppa_album_order_' . wppa_get_user(), 'id') . (get_option('wppa_album_order_' . wppa_get_user() . '_reverse') == 'yes' ? " DESC" : ""), ARRAY_A);
// Remove non accessable albums
$temp = $albums;
$albums = array();
foreach (array_keys($temp) as $idx) {
if (wppa_have_access($temp[$idx]['id'])) {
$albums[] = $temp[$idx];
}
}
$count = count($albums);
// If pagination: Make new array with selected albums only
if ($pagesize) {
$temp = $albums;
$albums = array();
$i = 0;
foreach ($temp as $item) {
if ($i < $skips) {
} elseif ($i >= $skips + $pagesize) {
} else {
$albums[] = $item;
}
$i++;
}
}
// Make sure all (grand)parents are in
$done = false;
while (!$done) {
$done = true;
foreach ($albums as $a) {
$parent = $a['a_parent'];
if ($parent > '0') {
$found = false;
foreach ($albums as $p) {
if ($p['id'] == $parent) {
$found = true;
}
}
if (!$found) {
$done = false;
// Add missing parent
$albums[] = $wpdb->get_row($wpdb->prepare("SELECT * FROM `" . WPPA_ALBUMS . "` WHERE `id` = %d", $parent), ARRAY_A);
}
}
}
}
// Find the ordering method
$reverse = false;
if (isset($_REQUEST['order_by'])) {
$order = $_REQUEST['order_by'];
} else {
$order = '';
}
if (!$order) {
$order = get_option('wppa_album_order_' . wppa_get_user(), 'id');
$reverse = get_option('wppa_album_order_' . wppa_get_user() . '_reverse') == 'yes';
} else {
$old_order = get_option('wppa_album_order_' . wppa_get_user(), 'id');
$reverse = get_option('wppa_album_order_' . wppa_get_user() . '_reverse') == 'yes';
if ($old_order == $order) {
$reverse = !$reverse;
} else {
$reverse = false;
}
update_option('wppa_album_order_' . wppa_get_user(), $order);
if ($reverse) {
update_option('wppa_album_order_' . wppa_get_user() . '_reverse', 'yes');
} else {
update_option('wppa_album_order_' . wppa_get_user() . '_reverse', 'no');
}
}
if (!empty($albums)) {
// Setup the sequence array
$seq = false;
$num = false;
foreach ($albums as $album) {
switch ($order) {
case 'name':
$seq[] = strtolower(__(stripslashes($album['name'])));
break;
case 'description':
$seq[] = strtolower(__(stripslashes($album['description'])));
break;
case 'owner':
$seq[] = strtolower($album['owner']);
break;
case 'a_order':
$seq[] = $album['a_order'];
$num = true;
break;
case 'a_parent':
$seq[] = strtolower(wppa_get_album_name($album['a_parent']), 'extended');
break;
default:
$seq[] = $album['id'];
$num = true;
break;
}
}
// Sort the seq array
if ($num) {
asort($seq, SORT_NUMERIC);
} else {
asort($seq, SORT_REGULAR);
}
// Reverse ?
if ($reverse) {
$t = $seq;
$c = count($t);
$tmp = array_keys($t);
$seq = false;
for ($i = $c - 1; $i >= 0; $i--) {
$seq[$tmp[$i]] = '0';
}
}
$downimg = '<img src="' . wppa_get_imgdir() . 'down.png" alt="down" style=" height:12px; position:relative; top:2px; " />';
$upimg = '<img src="' . wppa_get_imgdir() . 'up.png" alt="up" style=" height:12px; position:relative; top:2px; " />';
wppa_album_table_pagination($page, $count);
?>
<table class="widefat wppa-table wppa-setting-table" style="margin-top:12px;" >
<thead>
<tr>
<td style="min-width:20px;" >
<img src="<?php
echo wppa_get_imgdir() . 'backarrow.gif';
?>
" style="height:16px;" title="<?php
_e('Collapse subalbums', 'wp-photo-album-plus');
?>
" />
<img src="<?php
echo wppa_get_imgdir() . 'arrow.gif';
?>
" style="height:16px;" title="<?php
_e('Expand subalbums', 'wp-photo-album-plus');
?>
" />
</td>
<?php
$url = get_admin_url() . 'admin.php?page=wppa_admin_menu&order_by=';
?>
<td colspan="6" style="min-width: 50px;" >
<a href="<?php
echo wppa_dbg_url($url . 'id');
?>
">
<?php
_e('ID', 'wp-photo-album-plus');
if ($order == 'id') {
if ($reverse) {
echo $upimg;
} else {
echo $downimg;
}
}
?>
</a>
</td>
<td style="min-width: 120px;">
<a href="<?php
echo wppa_dbg_url($url . 'name');
?>
">
<?php
_e('Name', 'wp-photo-album-plus');
if ($order == 'name') {
if ($reverse) {
echo $upimg;
} else {
echo $downimg;
}
}
?>
</a>
</td>
<td >
<a href="<?php
echo wppa_dbg_url($url . 'description');
?>
">
<?php
_e('Description', 'wp-photo-album-plus');
if ($order == 'description') {
if ($reverse) {
echo $upimg;
} else {
echo $downimg;
}
}
?>
</a>
</td>
<?php
if (current_user_can('administrator')) {
?>
<td style="min-width: 100px;">
<a href="<?php
echo wppa_dbg_url($url . 'owner');
?>
">
<?php
_e('Owner', 'wp-photo-album-plus');
if ($order == 'owner') {
if ($reverse) {
echo $upimg;
} else {
echo $downimg;
}
}
?>
</a>
</td>
<?php
}
?>
<td style="min-width: 100px;" >
<a href="<?php
echo wppa_dbg_url($url . 'a_order');
?>
">
<?php
_e('Order', 'wp-photo-album-plus');
if ($order == 'a_order') {
if ($reverse) {
echo $upimg;
} else {
echo $downimg;
}
}
?>
</a>
</td>
<td style="width: 120px;">
<a href="<?php
echo wppa_dbg_url($url . 'a_parent');
?>
">
<?php
_e('Parent', 'wp-photo-album-plus');
if ($order == 'a_parent') {
if ($reverse) {
echo $upimg;
} else {
echo $downimg;
}
}
?>
</a>
</td>
<td title="<?php
_e('Albums/Photos/Moderation required/Scheduled', 'wp-photo-album-plus');
?>
" >
<?php
_e('A/P/PM/S', 'wp-photo-album-plus');
?>
</td>
<td ><?php
_e('Edit', 'wp-photo-album-plus');
?>
</td>
<td ><?php
_e('Quick', 'wp-photo-album-plus');
?>
</td>
<td ><?php
_e('Bulk', 'wp-photo-album-plus');
?>
</td>
<td ><?php
_e('Seq', 'wp-photo-album-plus');
?>
</td>
<td ><?php
_e('Delete', 'wp-photo-album-plus');
?>
</td>
<?php
if (wppa_can_create_album()) {
echo '<td >' . __('Create', 'wp-photo-album-plus') . '</td>';
}
?>
</tr>
</thead>
<tbody>
<?php
wppa_do_albumlist('0', '0', $albums, $seq);
?>
<?php
if ($wpdb->get_var("SELECT COUNT(*) FROM `" . WPPA_ALBUMS . "` WHERE `a_parent` = '-1'") > 0) {
?>
<tr>
<td colspan="19" ><em><?php
_e('The following albums are ---separate--- and do not show up in the generic album display', 'wp-photo-album-plus');
?>
</em></td>
</tr>
<?php
wppa_do_albumlist('-1', '0', $albums, $seq);
?>
<?php
}
wppa_search_edit(true);
?>
</tbody>
<tfoot>
<tr>
<td>
<img src="<?php
echo wppa_get_imgdir() . 'backarrow.gif';
?>
" style="height:16px;" />
<img src="<?php
echo wppa_get_imgdir() . 'arrow.gif';
?>
" style="height:16px;" />
</td>
<?php
$url = get_admin_url() . 'admin.php?page=wppa_admin_menu&order_by=';
?>
<td colspan="6" >
<a href="<?php
echo wppa_dbg_url($url . 'id');
?>
">
<?php
_e('ID', 'wp-photo-album-plus');
if ($order == 'id') {
if ($reverse) {
echo $upimg;
} else {
echo $downimg;
}
}
?>
</a>
</td>
<td style="width: 120px;">
<a href="<?php
echo wppa_dbg_url($url . 'name');
?>
">
<?php
_e('Name', 'wp-photo-album-plus');
if ($order == 'name') {
if ($reverse) {
echo $upimg;
} else {
echo $downimg;
}
}
?>
</a>
</td>
<td >
<a href="<?php
echo wppa_dbg_url($url . 'description');
?>
">
<?php
_e('Description', 'wp-photo-album-plus');
if ($order == 'description') {
if ($reverse) {
echo $upimg;
} else {
echo $downimg;
}
}
?>
</a>
</td>
<?php
if (current_user_can('administrator')) {
?>
<td style="width: 100px;">
<a href="<?php
echo wppa_dbg_url($url . 'owner');
?>
">
<?php
_e('Owner', 'wp-photo-album-plus');
if ($order == 'owner') {
if ($reverse) {
echo $upimg;
} else {
echo $downimg;
}
}
?>
</a>
</td>
<?php
}
?>
<td >
<a href="<?php
echo wppa_dbg_url($url . 'a_order');
?>
">
<?php
_e('Order', 'wp-photo-album-plus');
if ($order == 'a_order') {
if ($reverse) {
echo $upimg;
} else {
echo $downimg;
}
}
?>
</a>
</td>
<td style="width: 120px;">
<a href="<?php
echo wppa_dbg_url($url . 'a_parent');
?>
">
<?php
_e('Parent', 'wp-photo-album-plus');
if ($order == 'a_parent') {
if ($reverse) {
echo $upimg;
} else {
echo $downimg;
}
}
?>
</a>
</td>
<td title="<?php
_e('Albums/Photos/Moderation required/Scheduled', 'wp-photo-album-plus');
?>
" >
<?php
_e('A/P/PM/S', 'wp-photo-album-plus');
?>
</td>
<td ><?php
_e('Edit', 'wp-photo-album-plus');
?>
</td>
<td ><?php
_e('Quick', 'wp-photo-album-plus');
?>
</td>
<td ><?php
_e('Bulk', 'wp-photo-album-plus');
?>
</td>
<td ><?php
_e('Seq', 'wp-photo-album-plus');
?>
</td>
<td ><?php
_e('Delete', 'wp-photo-album-plus');
?>
</td>
<?php
if (wppa_can_create_album()) {
echo '<td >' . __('Create', 'wp-photo-album-plus') . '</td>';
}
?>
</tr>
</tfoot>
</table>
<script type="text/javascript" >
function checkArrows() {
elms = jQuery('.alb-arrow-off');
for(i=0;i<elms.length;i++) {
elm = elms[i];
if ( elm.parentNode.parentNode.style.display == 'none' ) elm.style.display = 'none';
}
elms = jQuery('.alb-arrow-on');
for(i=0;i<elms.length;i++) {
elm = elms[i];
if ( elm.parentNode.parentNode.style.display == 'none' ) elm.style.display = '';
}
}
</script>
<?php
wppa_album_table_pagination($page, $count);
wppa_album_admin_footer();
} else {
?>
<p><?php
_e('No albums yet.', 'wp-photo-album-plus');
?>
</p>
<?php
}
}
