1 | <?php |
---|
2 | if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!'); |
---|
3 | /** |
---|
4 | * Add the SmartAlbums configuration tool to virtual cats' configuration page |
---|
5 | */ |
---|
6 | |
---|
7 | function smart_cat_modify() |
---|
8 | { |
---|
9 | global $template, $page; |
---|
10 | |
---|
11 | $cat_id = $_GET['cat_id']; |
---|
12 | list($cat_dir) = pwg_db_fetch_row(pwg_query('SELECT dir FROM '.CATEGORIES_TABLE.' WHERE id = '.$cat_id.';')); |
---|
13 | |
---|
14 | // category must be virtual |
---|
15 | if ($cat_dir != NULL) |
---|
16 | { |
---|
17 | return; |
---|
18 | } |
---|
19 | |
---|
20 | /* SAVE FILTERS */ |
---|
21 | if (isset($_POST['submitFilters'])) |
---|
22 | { |
---|
23 | // test if it was a Smart Album |
---|
24 | $result = pwg_query('SELECT DISTINCT category_id FROM '.CATEGORY_FILTERS_TABLE.' WHERE category_id = '.$cat_id.';'); |
---|
25 | $was_smart = pwg_db_num_rows($result); |
---|
26 | |
---|
27 | /* this album is no longer a SmartAlbum */ |
---|
28 | if ($was_smart AND !isset($_POST['is_smart'])) |
---|
29 | { |
---|
30 | pwg_query('DELETE FROM '.IMAGE_CATEGORY_TABLE.' WHERE category_id = '.$cat_id.' AND smart = true;'); |
---|
31 | pwg_query('DELETE FROM '.CATEGORY_FILTERS_TABLE.' WHERE category_id = '.$cat_id.';'); |
---|
32 | set_random_representant(array($cat_id)); |
---|
33 | } |
---|
34 | /* no filter selected */ |
---|
35 | else if (isset($_POST['is_smart']) AND !isset($_POST['filters'])) |
---|
36 | { |
---|
37 | array_push($page['errors'], l10n('No filter selected')); |
---|
38 | } |
---|
39 | /* everything is fine */ |
---|
40 | else if (isset($_POST['is_smart']) AND count($_POST['filters']) > 0) |
---|
41 | { |
---|
42 | pwg_query('DELETE FROM '.CATEGORY_FILTERS_TABLE.' WHERE category_id = '.$cat_id.';'); |
---|
43 | |
---|
44 | $limit_is_set = false; |
---|
45 | foreach ($_POST['filters'] as $filter) |
---|
46 | { |
---|
47 | if (($filter = smart_check_filter($filter)) != false) |
---|
48 | { |
---|
49 | $query = ' |
---|
50 | INSERT INTO '.CATEGORY_FILTERS_TABLE.' |
---|
51 | VALUES( |
---|
52 | '.$cat_id.', |
---|
53 | "'.$filter['type'].'", |
---|
54 | "'.$filter['cond'].'", |
---|
55 | "'.$filter['value'].'" |
---|
56 | ) |
---|
57 | ;'; |
---|
58 | pwg_query($query); |
---|
59 | } |
---|
60 | } |
---|
61 | |
---|
62 | $associated_images = smart_make_associations($cat_id); |
---|
63 | $template->assign('IMAGE_COUNT', l10n_dec('%d photo', '%d photos', count($associated_images))); |
---|
64 | |
---|
65 | define('SMART_NOT_UPDATE', 1); |
---|
66 | invalidate_user_cache(); |
---|
67 | } |
---|
68 | } |
---|
69 | |
---|
70 | /* select options, for html_options */ |
---|
71 | $template->assign( |
---|
72 | 'options', |
---|
73 | array( |
---|
74 | 'tags' => array( |
---|
75 | 'all' => l10n('All these tags'), |
---|
76 | 'one' => l10n('One of these tags'), |
---|
77 | 'none' => l10n('None of these tags'), |
---|
78 | 'only' => l10n('Only these tags'), |
---|
79 | ), |
---|
80 | 'date' => array( |
---|
81 | 'the' => l10n('Added on'), |
---|
82 | 'before' => l10n('Added before'), |
---|
83 | 'after' => l10n('Added after'), |
---|
84 | 'the_crea' => l10n('Created on'), |
---|
85 | 'before_crea' => l10n('Created before'), |
---|
86 | 'after_crea' => l10n('Created after'), |
---|
87 | ), |
---|
88 | 'limit' => array('limit' => 'limit'), // second filter not used |
---|
89 | // TODO : new filter by album |
---|
90 | ) |
---|
91 | ); |
---|
92 | |
---|
93 | /* get filters for this album */ |
---|
94 | $filters = pwg_query('SELECT * FROM '.CATEGORY_FILTERS_TABLE.' WHERE category_id = '.$cat_id.' ORDER BY type ASC, cond ASC;'); |
---|
95 | while ($filter = pwg_db_fetch_assoc($filters)) |
---|
96 | { |
---|
97 | // get tags name and id |
---|
98 | if ($filter['type'] == 'tags') |
---|
99 | { |
---|
100 | $query = ' |
---|
101 | SELECT |
---|
102 | id AS tag_id, |
---|
103 | name AS tag_name |
---|
104 | FROM '.TAGS_TABLE.' |
---|
105 | WHERE id IN('.$filter['value'].') |
---|
106 | '; |
---|
107 | $filter['value'] = get_taglist($query); |
---|
108 | } |
---|
109 | |
---|
110 | $template->append('filters', array( |
---|
111 | 'TYPE' => $filter['type'], |
---|
112 | 'COND' => $filter['cond'], |
---|
113 | 'VALUE' => $filter['value'], |
---|
114 | )); |
---|
115 | } |
---|
116 | |
---|
117 | /* all tags */ |
---|
118 | $query = ' |
---|
119 | SELECT |
---|
120 | id AS tag_id, |
---|
121 | name AS tag_name |
---|
122 | FROM '.TAGS_TABLE.' |
---|
123 | ;'; |
---|
124 | $tags = get_taglist($query); |
---|
125 | |
---|
126 | /* get image number */ |
---|
127 | if ($template->get_template_vars('IMAGE_COUNT') == null) |
---|
128 | { |
---|
129 | list($image_num) = pwg_db_fetch_row(pwg_query('SELECT count(*) FROM '.IMAGE_CATEGORY_TABLE.' WHERE category_id = '.$cat_id.' AND smart = true;')); |
---|
130 | $template->assign('IMAGE_COUNT', l10n_dec('%d photo', '%d photos', $image_num)); |
---|
131 | } |
---|
132 | |
---|
133 | if (isset($_GET['new_smart'])) |
---|
134 | { |
---|
135 | $template->assign('new_smart', true); |
---|
136 | } |
---|
137 | |
---|
138 | $template->assign(array( |
---|
139 | 'SMART_PATH' => SMART_PATH, |
---|
140 | 'COUNT_SCRIPT_URL' => SMART_PATH.'include/count_images.php', |
---|
141 | 'tags' => $tags, |
---|
142 | )); |
---|
143 | $template->set_prefilter('categories', 'smart_cat_modify_prefilter'); |
---|
144 | } |
---|
145 | |
---|
146 | |
---|
147 | function smart_cat_modify_prefilter($content, &$smarty) |
---|
148 | { |
---|
149 | $search = '<form action="{$F_ACTION}" method="POST" id="catModify">'; |
---|
150 | $replacement = file_get_contents(SMART_PATH.'template/cat_modify.tpl')."\n".$search; |
---|
151 | return str_replace($search, $replacement, $content); |
---|
152 | } |
---|
153 | |
---|
154 | ?> |
---|