Changeset 32191

Timestamp:

May 9, 2020, 3:57:19 AM (4 years ago)

Author:

ddtddt

Message:

[photos_from_one_year_ago]

Location:

extensions/photos_from_one_year_ago

Files:

• language/en_UK/plugin.lang.php (modified) (1 diff)
• language/fr_FR/plugin.lang.php (modified) (1 diff)
• main.inc.php (modified) (1 diff)
• pfoya.tpl (added)

extensions/photos_from_one_year_ago/language/en_UK/plugin.lang.php

@@ -23 +23 @@
 $lang['more photos'] = 'more photos';
 $lang['Display X photos from one year ago in the gallery or a album'] = 'Display X photos from one year ago in the gallery or a album';
-
+$lang['Photos from %d years ago'] = 'Photos from %d years ago';
+$lang['Photos from %d'] = 'Photos from %d';
+$lang['Photos from'] = 'Photos from';

extensions/photos_from_one_year_ago/language/fr_FR/plugin.lang.php

@@ -24 +24 @@
 $lang['more photos'] = 'plus de photos';
 $lang['Display X photos from one year ago in the gallery or a album'] = 'Afficher les X photos d\'il y a 1 ans de la galerie ou de l\'album';
+$lang['Photos from %d years ago'] = 'Photos d\'il y a %d ans';
+$lang['Photos from %d'] = 'Photos du %d';
+$lang['Photos from'] = 'Photos du';

extensions/photos_from_one_year_ago/main.inc.php

@@ -38 +38 @@
 }
 
+add_event_handler('blockmanager_apply' , 'add_link_pfoya');
+add_event_handler('loc_end_section_init', 'section_init_pfoya');
+  
+function add_link_pfoya($menu_ref_arr){
+  global $conf;
+  $menu = &$menu_ref_arr[0];
+  $position = (isset($conf['pfoya_position']) and is_numeric($conf['pfoya_position'])) ? $conf['pfoya_position'] : 5;
+  if (($block = $menu->get_block('mbSpecials')) != null){
+        array_splice($block->data, $position-1, 0, 
+          array('photos_from_one_year_ago' =>
+                array(
+                  'URL' => make_index_url(array('section' => 'photos_from_one_year_ago')),
+                  'TITLE' => l10n('Displays photos from one year ago'),
+                  'NAME' => l10n('Photos from one year ago')
+                )
+          )
+        );
+  }
+}
 
-  add_event_handler('blockmanager_apply' , 'add_link_pfoya');
-  add_event_handler('loc_end_section_init', 'section_init_pfoya');
-  
-  function add_link_pfoya($menu_ref_arr){
-    global $conf;
-    $menu = &$menu_ref_arr[0];
-    $position = (isset($conf['pfoya_position']) and is_numeric($conf['pfoya_position'])) ? $conf['pfoya_position'] : 5;
-    if (($block = $menu->get_block('mbSpecials')) != null){
-     array_splice($block->data, $position-1, 0, array('photos_from_one_year_ago' =>
-      array(
-        'URL' => make_index_url(array('section' => 'photos_from_one_year_ago')),
-        'TITLE' => l10n('Displays photos from one year ago'),
-        'NAME' => l10n('Photos from one year ago')
-        )
-      )
-    );
-   }
-  }
+function section_init_pfoya(){
+  global $tokens, $page, $conf, $template;
+  $testurl = explode('photos_from_', $_SERVER['REQUEST_URI']);
+  if(!empty($testurl[1])){
 
-function section_init_pfoya()
-{
-  global $tokens, $page, $conf,$template;
-  $template->assign('PFOAYALINK',make_index_url(array('section' => 'photos_from_one_year_ago')));
-  
-  $datepfoya = (isset($conf['pfoya_dateb'])) ? $conf['pfoya_dateb'] : "date_available";
-  $daydate= (isset($conf['pfoya_date'])) ? $conf['pfoya_date'] : date("Y-m-d", strtotime('-1 year'));
-  
-  if (!in_array('photos_from_one_year_ago', $tokens))
-  {
-    return;
-  }
-  
-  
-  $page['section'] = 'photos_from_one_year_ago';
-  $page['title'] = '<a href="' . duplicate_index_url() . '">' . l10n('Photos from one year ago') . '</a>';
-  $page['section_title'] = '<a href="'.get_gallery_home_url().'">' . l10n('Home') . '</a>'
-    . $conf['level_separator'] . $page['title'];
+    $datepfoya = (isset($conf['pfoya_dateb'])) ? $conf['pfoya_dateb'] : "date_available";
+        $daydatemax= (isset($conf['pfoya_datemax'])) ? $conf['pfoya_datemax'] : 5;
 
-  $query = '
-SELECT DISTINCT(i.id)
-  FROM '.IMAGES_TABLE.' AS i
-    INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON i.id = ic.image_id
-    INNER JOIN '.CATEGORIES_TABLE.' AS c ON ic.category_id = c.id 
-    WHERE ' .  
-      get_sql_condition_FandF(
-        array(
-          'forbidden_categories' => 'category_id',
-          'visible_categories' => 'category_id',
-          'visible_images' => 'image_id',
-          ),
-        '', true
-        );
-  $query .= '
-       and DATE ('.$datepfoya.') ="'.$daydate.'";';
-  
-    $page['items'] = query2array($query, null, 'id');
-  
+        if($daydatemax>1)$template->assign('pfoya','a');
+        
+        for ($i = 1; $i <= $daydatemax; $i++) {
+        $daydate=date("Y-m-d", strtotime('-'.$i.' year'));
+          $query = '
+                SELECT COUNT(DISTINCT(i.id)) as count 
+                FROM '.IMAGES_TABLE.' AS i
+                INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON i.id = ic.image_id
+                INNER JOIN '.CATEGORIES_TABLE.' AS c ON ic.category_id = c.id 
+                WHERE ' .  
+                  get_sql_condition_FandF(
+                        array(
+                          'forbidden_categories' => 'category_id',
+                          'visible_categories' => 'category_id',
+                          'visible_images' => 'image_id',
+                          ),
+                        '', true
+                        );
+          $query .= '
+                and DATE ('.$datepfoya.') ="'.$daydate.'";';
+
+                $row = pwg_db_fetch_assoc(pwg_query($query));
+                
+          if ($i == 1){
+            $items = array(
+                  'NB_IMAGES' => $row['count'],
+                  'URL' => make_index_url(array('section' => 'photos_from_one_year_ago')),
+                  'LABEL' => l10n('Photos from one year ago'),
+                );
+            $template->append('pfoyas', $items);
+          }else{
+                $items = array(
+                  'NB_IMAGES' => $row['count'],
+                  'URL' => make_index_url(array('section' => 'photos_from_'.$i.'_year_ago')),
+                  'LABEL' => l10n('Photos from %d years ago',$i),
+                );
+            $template->append('pfoyas', $items);
+          }
+        }
+          if($testurl[1]=='one_year_ago'){
+                if (!in_array('photos_from_one_year_ago', $tokens)){return;}
+                        $daydate=date("Y-m-d", strtotime('-1 year'));
+                    $query = '
+                          SELECT DISTINCT(i.id)
+                          FROM '.IMAGES_TABLE.' AS i
+                                INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON i.id = ic.image_id
+                                INNER JOIN '.CATEGORIES_TABLE.' AS c ON ic.category_id = c.id 
+                                WHERE ' .  
+                                  get_sql_condition_FandF(
+                                        array(
+                                          'forbidden_categories' => 'category_id',
+                                          'visible_categories' => 'category_id',
+                                          'visible_images' => 'image_id',
+                                          ),
+                                        '', true
+                                        );
+                          $query .= '
+                                   and DATE ('.$datepfoya.') ="'.$daydate.'";';
+                $page['section'] = 'photos_from_one_year_ago';
+            $page['title'] = '<a href="' . duplicate_index_url() . '">' . l10n('Photos from one year ago') . '</a>';
+            $page['section_title'] = '<a href="'.get_gallery_home_url().'">' . l10n('Home') . '</a>'
+                  . $conf['level_separator'] . $page['title'];
+            $page['items'] = query2array($query, null, 'id');
+                $template->assign('pfoyadata',l10n('Photos from').' '.format_date($daydate));
+
+          }else{
+                $yurl=explode('_year_ago', $testurl[1]);
+                $yurl=$yurl[0];
+                if (!in_array('photos_from_'.$yurl.'_year_ago', $tokens)){return;}
+                $daydate=date("Y-m-d", strtotime('-'.$yurl.' year'));
+                  $query = '
+                  SELECT DISTINCT(i.id)
+                  FROM '.IMAGES_TABLE.' AS i
+                        INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON i.id = ic.image_id
+                        INNER JOIN '.CATEGORIES_TABLE.' AS c ON ic.category_id = c.id 
+                        WHERE ' .  
+                          get_sql_condition_FandF(
+                                array(
+                                  'forbidden_categories' => 'category_id',
+                                  'visible_categories' => 'category_id',
+                                  'visible_images' => 'image_id',
+                                  ),
+                                '', true
+                                );
+                  $query .= '
+                           and DATE ('.$datepfoya.') ="'.$daydate.'";';
+                $page['section'] = 'photos_from_'.$yurl.'_year_ago';
+            $page['title'] = '<a href="' . duplicate_index_url() . '">' . l10n('Photos from %d years ago',$yurl) . '</a>';
+            $page['section_title'] = '<a href="'.get_gallery_home_url().'">' . l10n('Home') . '</a>'
+                  . $conf['level_separator'] . $page['title'];
+            $page['items'] =query2array($query, null, 'id'); 
+                $template->assign('pfoyadata',l10n('Photos from').' '.format_date($daydate));
+          }
+          
+        
+  }     
+        
+  $template->set_filename('PFOYA', realpath(PFOYA_PATH . 'pfoya.tpl'));
+  $template->assign_var_from_handle('CONTENT', 'PFOYA');
+        
 }