"; print_r($ret);die();
		return $ret;
	}
	static function save($data) {
		$pdo = database::pdo();
		
		/* set a flag if this is a newly created extension */
		if ($data['pk_extension'] == "") {
			$create_new = true;
		}
		
		/* force type to grouppickup */
		$data['type'] = 'grouppickup';

		/* triger a save on the extensions tables */
		$data['pk_extension'] = extensions::save($data);
		
		/* create a record in the ext_grouppickup table if this is a newly created extension */
		if ($create_new) {
			$query = $pdo->prepare("INSERT INTO ext_grouppickup(pk_extension) VALUES(:pk_extension)");
			$query->bindParam(':pk_extension', $data['pk_extension'], PDO::PARAM_INT);
			$query->execute();
			if ($query->errorCode() != '00000') {
				$error = $query->errorInfo();
				throw new Exception($error[2]);
			}
		}
		
		/* update the group pickup options */
		$query = $pdo->prepare("
			UPDATE
				ext_grouppickup
			SET
				use_members_byaccount = :use_members_byaccount,
				use_admins_byaccount  = :use_admins_byaccount
			WHERE
				pk_extension = :pk_extension
		");
		$query->bindValue(':use_members_byaccount', $data['use_members_byaccount']=='1'?1:0, PDO::PARAM_INT);
		$query->bindValue(':use_admins_byaccount' , $data['use_admins_byaccount']=='1'?1:0 , PDO::PARAM_INT);
		$query->bindValue(':pk_extension'         , $data['pk_extension']                  , PDO::PARAM_INT);
		$query->execute();
		if ($query->errorCode() != '00000') {
			$error = $query->errorInfo();
			throw new Exception($error[2]);
		}
		
		
		/* update group pickup members(picked-up) */
		/* note : we updat by doing a delete all then insert new */
		$query = $pdo->prepare("DELETE FROM ext_grouppickup_members WHERE fk_extension = :pk_extension");
		$query->bindValue(':pk_extension', $data['pk_extension']);
		$query->execute();
		if ($query->errorCode() != '00000') {
			$error = $query->errorInfo();
			throw new Exception($error[2]);
		}
		
		if (is_array($data['members'])) {
			foreach ((array)($data['members']['extensions']) as $fk_extension_member) {
				$query = $pdo->prepare("INSERT INTO ext_grouppickup_members (fk_extension, fk_extension_member, fk_group_member) VALUES (:pk_extension, :fk_extension_member, 0)");
				$query->bindValue(':pk_extension'       , $data['pk_extension'], PDO::PARAM_INT);
				$query->bindValue(':fk_extension_member', $fk_extension_member , PDO::PARAM_INT);
				$query->execute();
				if ($query->errorCode() != '00000') {
					$error = $query->errorInfo();
					throw new Exception($error[2]);
				}
			}
			
			if ($data['members']['group']){
			    $fk_group_member = $data['members']['group'];
			    
				$query = $pdo->prepare("INSERT INTO ext_grouppickup_members (fk_extension, fk_extension_member, fk_group_member) VALUES (:pk_extension, 0, :fk_group_member)");
				$query->bindValue(':pk_extension'   , $data['pk_extension'], PDO::PARAM_INT);
				$query->bindValue(':fk_group_member', $fk_group_member     , PDO::PARAM_INT);
				$query->execute();
				if ($query->errorCode() != '00000') {
					$error = $query->errorInfo();
					throw new Exception($error[2]);
				}
			}
		}
		
		/* update group pickup admins(pickup-ers) */
		/* note : we updat by doing a delete all then insert new */
		$query = $pdo->prepare("DELETE FROM ext_grouppickup_admins WHERE fk_extension = :pk_extension");
		$query->bindValue(':pk_extension', $data['pk_extension']);
		$query->execute();
		if ($query->errorCode() != '00000') {
			$error = $query->errorInfo();
			throw new Exception($error[2]);
		}
		
		if (is_array($data['admins'])) {
			foreach ((array)($data['admins']['extensions']) as $fk_extension_admin) {
				$query = $pdo->prepare("INSERT INTO ext_grouppickup_admins (fk_extension, fk_extension_admin, fk_group_admin) VALUES (:pk_extension, :fk_extension_admin, 0)");
				$query->bindValue(':pk_extension'      , $data['pk_extension'], PDO::PARAM_INT);
				$query->bindValue(':fk_extension_admin', $fk_extension_admin  , PDO::PARAM_INT);
				$query->execute();
				if ($query->errorCode() != '00000') {
					$error = $query->errorInfo();
					throw new Exception($error[2]);
				}
			}
			
			if ($data['admins']['group']){
			    $fk_group_admin = $data['admins']['group'];
			    
				$query = $pdo->prepare("INSERT INTO ext_grouppickup_admins (fk_extension, fk_extension_admin, fk_group_admin) VALUES (:pk_extension, 0, :fk_group_admin)");
				$query->bindValue(':pk_extension'  , $data['pk_extension'], PDO::PARAM_INT);
				$query->bindValue(':fk_group_admin', $fk_group_admin      , PDO::PARAM_INT);
				$query->execute();
				if ($query->errorCode() != '00000') {
					$error = $query->errorInfo();
					throw new Exception($error[2]);
				}
			}
		}

		return $data['pk_extension'];
	}
	static function validate($data) {
		$errors = array();
		
		/* validate first against the extensions table */
		$errors = extensions::validate($data);

		return $errors;
	}
	static function generate() {
		$ret = extensions::generate();
		
		return $ret;
	}
	static function delete($pk_extension) {
		$pdo = database::pdo();
		
		/* Delete from the extensions table */
		extensions::delete($pk_extension);

		/* Delete entry from the group pickup extensions table */
		$query = $pdo->prepare("DELETE FROM ext_grouppickup WHERE pk_extension = :pk_extension");
		$query->bindParam(':pk_extension', $pk_extension, PDO::PARAM_INT);
		$query->execute();
		if ($query->errorCode() != '00000') {
			$error = $query->errorInfo();
			throw new Exception($error[2]);
		}
		
		/* delete the members from this call pickup extension */
		$query = $pdo->prepare("DELETE FROM ext_grouppickup_members WHERE fk_extension = :pk_extension");
		$query->bindParam(':pk_extension', $pk_extension, PDO::PARAM_INT);
		$query->execute();
		if ($query->errorCode() != '00000') {
			$error = $query->errorInfo();
			throw new Exception($error[2]);
		}
		
		/* delete the admins from this call pickup extension */
		$query = $pdo->prepare("DELETE FROM ext_grouppickup_admins WHERE fk_extension = :pk_extension");
		$query->bindParam(':pk_extension', $pk_extension, PDO::PARAM_INT);
		$query->execute();
		if ($query->errorCode() != '00000') {
			$error = $query->errorInfo();
			throw new Exception($error[2]);
		}
	}
}