aboutsummaryrefslogtreecommitdiffstats
path: root/admin/cat_modify.php
diff options
context:
space:
mode:
authorplegall <plg@piwigo.org>2006-03-04 23:31:46 +0000
committerplegall <plg@piwigo.org>2006-03-04 23:31:46 +0000
commitc08fa6f67ef5b149fdeb3bcc57045e629df8fff4 (patch)
tree8a0eeb15f6a4989b6691584c9cf5123361be4f1c /admin/cat_modify.php
parentc4874071babe878fcdcda10da1cc34ba5ded6aae (diff)
new feature: source/destination links between categories. Will we keep this
feature? Code is complicated and very few people will understand how it works... modification: #images.storage_category_id replaced by #image_category.is_storage improvement: many code refactoring to improve readibility improvement: virtual category creation code was moved to a dedicated function in order to be called from admin/cat_list.php and admin/cat_modify.php (create a new destination category) git-svn-id: http://piwigo.org/svn/trunk@1064 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to '')
-rw-r--r--admin/cat_modify.php181
1 files changed, 181 insertions, 0 deletions
diff --git a/admin/cat_modify.php b/admin/cat_modify.php
index 309425c91..e06e1a8cb 100644
--- a/admin/cat_modify.php
+++ b/admin/cat_modify.php
@@ -88,6 +88,122 @@ UPDATE '.CATEGORIES_TABLE.'
;';
pwg_query($query);
}
+else if (isset($_POST['submitAdd']))
+{
+ $output_create = create_virtual_category(
+ $_POST['virtual_name'],
+ (0 == $_POST['parent'] ? null : $_POST['parent'])
+ );
+
+ if (isset($output_create['error']))
+ {
+ array_push($page['errors'], $output_create['error']);
+ }
+ else
+ {
+ // Virtual category creation succeeded
+ //
+ // Add the information in the information list
+ array_push($page['infos'], $output_create['info']);
+
+ // Link the new category to the current category
+ $query = '
+INSERT
+ INTO '.CATEGORIES_LINK_TABLE.'
+ (source, destination)
+ VALUES
+ ('.$_GET['cat_id'].', '.$output_create['id'].')
+;';
+ pwg_query($query);
+
+ check_links(array($output_create['id']));
+ update_category(array($output_create['id']));
+ }
+}
+else if (isset($_POST['destination_trueify'])
+ and isset($_POST['destination_false'])
+ and count($_POST['destination_false']))
+{
+ $datas = array();
+
+ foreach ($_POST['destination_false'] as $category_id)
+ {
+ array_push(
+ $datas,
+ array(
+ 'source' => $_GET['cat_id'],
+ 'destination' => $category_id,
+ )
+ );
+ }
+
+ mass_inserts(
+ CATEGORIES_LINK_TABLE,
+ array('source', 'destination'),
+ $datas
+ );
+
+ check_links($_POST['destination_false']);
+ update_category(
+ $_POST['destination_false'],
+ true // recursive update
+ );
+}
+else if (isset($_POST['destination_falsify'])
+ and isset($_POST['destination_true'])
+ and count($_POST['destination_true']))
+{
+ foreach ($_POST['destination_true'] as $destination)
+ {
+ delete_sources($destination, array($_GET['cat_id']));
+ }
+
+ update_category(
+ $_POST['destination_true'],
+ true // recursive update
+ );
+}
+else if (isset($_POST['source_trueify'])
+ and isset($_POST['source_false'])
+ and count($_POST['source_false']))
+{
+ $datas = array();
+
+ foreach ($_POST['source_false'] as $category_id)
+ {
+ array_push(
+ $datas,
+ array(
+ 'source' => $category_id,
+ 'destination' => $_GET['cat_id'],
+ )
+ );
+ }
+
+ mass_inserts(
+ CATEGORIES_LINK_TABLE,
+ array('source', 'destination'),
+ $datas
+ );
+
+ check_links(array($_GET['cat_id']));
+ update_category(
+ array($_GET['cat_id']),
+ true // recursive update
+ );
+}
+else if (isset($_POST['source_falsify'])
+ and isset($_POST['source_true'])
+ and count($_POST['source_true']))
+{
+ delete_sources($_GET['cat_id'], $_POST['source_true']);
+
+ update_category(
+ array($_GET['cat_id']),
+ true // recursive update
+ );
+}
+
$query = '
SELECT *
@@ -316,6 +432,71 @@ if (!$category['is_virtual'] and !url_is_remote($category['cat_dir']) )
$template->assign_block_vars('upload' ,array());
}
+$blockname = 'category_option_parent';
+
+$template->assign_block_vars(
+ $blockname,
+ array(
+ 'VALUE'=> 0,
+ 'OPTION' => '------------'
+ )
+ );
+
+$query = '
+SELECT id,name,uppercats,global_rank
+ FROM '.CATEGORIES_TABLE.'
+;';
+
+display_select_cat_wrapper(
+ $query,
+ array(),
+ $blockname
+ );
+
+// destination categories
+$query = '
+SELECT DISTINCT id, name, uppercats, global_rank
+ FROM '.CATEGORIES_TABLE.'
+ INNER JOIN '.CATEGORIES_LINK_TABLE.' ON destination = id
+ WHERE source = '.$_GET['cat_id'].'
+;';
+display_select_cat_wrapper($query, array(), 'destination_option_true');
+
+// non destination categories
+$destinations = array_merge(
+ array($_GET['cat_id']),
+ array_from_query($query, 'id')
+ );
+
+$query = '
+SELECT DISTINCT id, name, uppercats, global_rank
+ FROM '.CATEGORIES_TABLE.'
+ WHERE id NOT IN ('.implode(',', $destinations).')
+;';
+display_select_cat_wrapper($query, array(), 'destination_option_false');
+
+// source categories
+$query = '
+SELECT DISTINCT id, name, uppercats, global_rank
+ FROM '.CATEGORIES_TABLE.'
+ INNER JOIN '.CATEGORIES_LINK_TABLE.' ON source = id
+ WHERE destination = '.$_GET['cat_id'].'
+;';
+display_select_cat_wrapper($query, array(), 'source_option_true');
+
+// non source categories
+$sources = array_merge(
+ array($_GET['cat_id']),
+ array_from_query($query, 'id')
+ );
+
+$query = '
+SELECT DISTINCT id, name, uppercats, global_rank
+ FROM '.CATEGORIES_TABLE.'
+ WHERE id NOT IN ('.implode(',', $sources).')
+;';
+display_select_cat_wrapper($query, array(), 'source_option_false');
+
//----------------------------------------------------------- sending html code
$template->assign_var_from_handle('ADMIN_CONTENT', 'categories');
?>