<?php

define_class(__FILE__, 'ContactGroupObj');

require_once('class/DB/DBObj.php');

class ContactGroupObj extends DBObj
{
	var $tableName = 'ContactGroup';
	var $itemName = 'Group';
	var $itemsName = 'Groups';
	
	function _getWhat4Grid($opt = array())
	{
		$sql = '`' . $this->tableName . '`.*, '
			 . '('
			 . 'SELECT COUNT(*) FROM `' . $this->db->tblContactPerson2Group. '` AS `ContactPerson2Group` '
			 . 'JOIN `' . $this->db->tblContactPerson . '` AS `ContactPerson` '
			 . 'ON `ContactPerson`.`id` = `ContactPerson2Group`.`id_person` '
			 . 'WHERE `ContactPerson2Group`.`id_group` = `' . $this->tableName . '`.`id`'
			 . ') as person_count ';
		return $sql;
	}
    
    function delete()
    {
        $this->deleteIds($this->db->tblContactPerson2Group, 'id_group');
        parent::delete();
    }
}