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 } }