<?php
/***
 *  TABS Asterisk Billing System
 *  Copyright (C) 2008  Thusa Business Support (Pty) Ltd.
 *
 *  This program is free software; you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License as published by
 *  the Free Software Foundation; either version 2 of the License, or
 *  (at your option) any later version.
 *
 *  This program is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.
 *
 *  You should have received a copy of the GNU General Public License
 *  along with this program; if not, write to the Free Software
 *  Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
 * 
 ***/

/**
* Privilege Delete
*
* Display delete confirmation for a liveuser group and do delete 
* operation if no users are in that group
* @version 0.1.0 
*/

//{{{ includes
  require_once 'include/initialisation.inc.php';
//}}}

//{{{ custom initialisation
  $tpl->setTPL("priv_delete.tpl");
  $form = new HTML_QuickForm("NewForm");
//}}}

// --- FUNCTIONS ---    
/**
* process_data
*
* callback function do all the processing for the form
*/ 
function process_data($args)   {
  global $form;
  global $LUA;
      
  if (isset($args['btnDelete'])&&('Confirm Deletion!'==$args['btnDelete']))    {
    $form->addElement('header',"hdrConfirm","Are you sure you want to delete this privilege group?");
    $ele=&$form->getElement('btnDelete');
    $ele->setValue('Delete Privilege!');
  }
  if (isset($args['btnDelete'])&&('Delete Privilege!'==$args['btnDelete']))    {
    $filter = array('group_id' => $args['lu_group_id']);
    $removed = $LUA->perm->removeGroup($filter);
    if (false === $removed) {
      print_r($LUA->getErrors());
      return "Could not delete privilege group!";
    } else {
      return "Privilege Group Deleted successfully";
    }
  }
} // end of function process_data

//{{{ --- MAIN CODE ---
  
  //{{{ do some basic validation on the posted id
  $group_id = $_POST['lu_group_id'];
  if(!is_numeric($group_id))  {
    die('a non-numeric id was posted : '.$group_id);
  } else {
    $tpl->assign('group_id',$group_id);
  }
  if(isset($_POST['lu_group_define_name']))  {
    $tpl->assign('group_define_name',$_POST['lu_group_define_name']);
  }
  //}}}
  
  //{{{ check that no users exist in the specified group and create corresponding QF elements
    $query = "SELECT COUNT(`liveuser_groupusers`.`group_id`) AS `user_count` FROM `liveuser_users`,`liveuser_perm_users`,`liveuser_groupusers` WHERE `liveuser_users`.`authUserId` = `liveuser_perm_users`.`auth_user_id` AND `liveuser_perm_users`.`perm_user_id` = `liveuser_groupusers`.`perm_user_id` AND `liveuser_groupusers`.`group_id`=$group_id GROUP BY `liveuser_groupusers`.`group_id`";
    
    //$query = "SELECT COUNT(`liveuser_users`.`authUserId`) AS `user_count` FROM `liveuser_users`,`liveuser_perm_users`,`liveuser_groupusers` WHERE `liveuser_users`.`authUserId` = `liveuser_perm_users`.`auth_user_id` AND `liveuser_perm_users`.`perm_user_id` = `liveuser_groupusers`.`perm_user_id` AND `liveuser_groupusers`.`group_id`=$group_id GROUP BY `liveuser_users`.`authUserId`";
    $gr_res = $db->query($query);
    if (handleError($gr_res)) {
      if(0!=$gr_res->numRows())  {
        $gr_res->fetchInto($gr_row);
        $count_users = $gr_row['user_count'];
        //{{{ add basic form elements
          $form->addElement('header',"hdrTop","Unable to Delete Privilege!");
          $form->addElement('header','hdrUserCount',"There are still $count_users users associated with this privilege!");
        //}}}
      } else {
        //{{{ add basic form elements
          $form->addElement('header',"hdrTop","Delete Privilege");
          $form->addElement('submit','btnDelete','Confirm Deletion!');
        //}}}
      }
    }
  //}}}

  if ($form->validate())  {
    //$form->freeze();
    $result = $form->process('process_data','false');
    $form->addElement('text','txtResult',$result);
  } else {
  }

  //display form
  $tpl->display(&$form);

    
  //debugging statement to display renderer HTML array
  //echo "<pre>";var_dump($renderer->toArray());echo "</pre>";
  
//}}}
?>