source: extensions/delete_rate/admin/admin.php @ 16448

<?php
if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');
global $template, $conf, $user;
include_once(PHPWG_ROOT_PATH .'admin/include/tabsheet.class.php');
load_language('plugin.lang', RATE_PATH);
$my_base_url = get_admin_plugin_menu_link(__FILE__);

// +-----------------------------------------------------------------------+
// | Check Access and exit when user status is not ok                      |
// +-----------------------------------------------------------------------+
check_status(ACCESS_ADMINISTRATOR);

//-------------------------------------------------------- sections definitions



// Gestion des onglets
if (!isset($_GET['tab']))
    $page['tab'] = 'rateall';
else
    $page['tab'] = $_GET['tab'];

$tabsheet = new tabsheet();
$tabsheet->add('rateall',
               l10n('rate_onglet_all'),
               $my_base_url.'&amp;tab=rateall');
$tabsheet->add('ratephoto',
               l10n('rate_onglet_photo'),
               $my_base_url.'&amp;tab=ratephoto');
$tabsheet->add('ratealbum',
               l10n('rate_onglet_album'),
               $my_base_url.'&amp;tab=ratealbum');
                           
$tabsheet->select($page['tab']);
$tabsheet->assign();

// Onglet gestion par photo
switch ($page['tab'])
{
 case 'rateall':

  $template->assign(
    'gestion',
    array(

      ));

//purge photo
if (isset($_POST['submitchoixall']) and !is_adviser())
        {
        $query = '
UPDATE ' . IMAGES_TABLE . '
  SET average_rate= \'NULL\'
    ;';
$result = pwg_query($query);

        $query = '
TRUNCATE ' . RATE_TABLE . '
    ;';
$result = pwg_query($query);

        array_push( $page['infos'], l10n('rate_totalok') );
        }
          
    break;
        
  case 'ratephoto':

//charge la liste des photos
$groups = array();
$query = '
SELECT id,name
  FROM ' . IMAGES_TABLE . '
  ORDER BY id ASC;';
$result = pwg_query($query);

while ($row = mysql_fetch_array($result))
        {
  $groups[$row['id']] = $row['id'].' : '.$row['name'];
        }
        
        $selected = 0;
        $options[] = l10n('rate_select_photo');
        $options['a'] = '----------------------';
        
foreach($groups as $listid => $listid2)
        {
    $options[$listid] = $listid2;
        }
  $template->assign(
    'gestionA',
    array(
          'OPTIONS' => $options,
      'SELECTED' => $selected
      ));

//purge photo
if (isset($_POST['submitchoixphoto']) and is_numeric($_POST['delratephoto'])and (!$_POST['delratephoto'])==0 and !is_adviser())
        {
        $lire=$_POST['delratephoto'];
        $query = '
UPDATE ' . IMAGES_TABLE . '
  SET average_rate = \'NULL\'
  WHERE id = \''.$lire.'\'
    ;';
$result = pwg_query($query);

        $query = '
  DELETE FROM ' . RATE_TABLE . '
  WHERE element_id = \''.$lire.'\'
    ;';
$result = pwg_query($query);
        
        array_push( $page['infos'], l10n('rate_photook') );
        }
          
    break;
        
        case 'ratealbum':

//charge la liste des catégories
$groups = array();
$query = '
select id,name
  FROM ' . CATEGORIES_TABLE . '
  ORDER BY id ASC;';
$result = pwg_query($query);

while ($row = mysql_fetch_array($result))
        {
  $groups[$row['id']] = $row['id'].' : '.$row['name'];
        }
        
        $selected = 0;
        $options[] = l10n('rate_select_cat');
        $options['a'] = '----------------------';
        
foreach($groups as $listid => $listid2)
        {
    $options[$listid] = $listid2;
        }
  $template->assign(
    'gestionB',
    array(
          'OPTIONS' => $options,
      'SELECTED' => $selected
      ));
        
        

//purge toutes les photos d'un album
if (isset($_POST['submitchoixcat']) and is_numeric($_POST['delratecat'])and (!$_POST['delratecat'])==0 and !is_adviser())
        {
        $lire=$_POST['delratecat'];

        $query = '
select image_id
  FROM ' . IMAGE_CATEGORY_TABLE . '
  WHERE category_id = \''.$lire.'\'
  ;';
$result = pwg_query($query);

$delval = array();
while($row = mysql_fetch_array($result))
        {
    array_push($delval, $row['image_id']);
        }

foreach ($delval as $delrate)
        {
                $query = '
                UPDATE ' . IMAGES_TABLE . '
                SET average_rate = \'NULL\'
                WHERE id = \''.$delrate.'\'
    ;';
$result = pwg_query($query);
        
                $query = '
                DELETE FROM ' . RATE_TABLE . '
                WHERE element_id = \''.$delrate.'\'
                ;';
                $result = pwg_query($query);
        }
        array_push( $page['infos'], l10n('rate_albumok') );       
    break;
        }
} 

$template->set_filenames(array('plugin_admin_content' => dirname(__FILE__) . '/admin.tpl')); 
$template->assign_var_from_handle('ADMIN_CONTENT', 'plugin_admin_content');
?>