Spade
Mini Shell
| Directory:~$ /home/lmsyaran/public_html/j3/administrator/components/com_phocacart/models/ |
| [Home] [System Details] [Kill Me] |
<?php
/* @package Joomla
* @copyright Copyright (C) Open Source Matters. All rights reserved.
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.php
* @extension Phoca Extension
* @copyright Copyright (C) Jan Pavelka www.phoca.cz
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL
*/
defined( '_JEXEC' ) or die();
jimport('joomla.application.component.modeladmin');
use Joomla\String\StringHelper;
class PhocaCartCpModelPhocacartCategory extends JModelAdmin
{
protected $option = 'com_phocacart';
protected $text_prefix = 'com_phocacart';
public $typeAlias =
'com_phocacart.phocacartcategory';
protected $associationsContext =
'com_phocacart.category'; // ASSOCIATION
protected function canDelete($record) {
$user = JFactory::getUser();
if (!empty($record->catid)) {
return $user->authorise('core.delete',
'com_phocacart.phocadownloadcategory.'.(int) $record->catid);
} else {
return parent::canDelete($record);
}
}
protected function canEditState($record){
$user = JFactory::getUser();
if (!empty($record->catid)) {
return $user->authorise('core.edit.state',
'com_phocacart.phocadownloadcategory.'.(int) $record->catid);
} else {
return parent::canEditState($record);
}
}
public function getTable($type = 'PhocacartCategory', $prefix =
'Table', $config = array()){
return JTable::getInstance($type, $prefix, $config);
}
public function getForm($data = array(), $loadData = true) {
$app = JFactory::getApplication();
$form = $this->loadForm('com_phocacart.phocacartcategory',
'phocacartcategory', array('control' =>
'jform', 'load_data' => $loadData));
if (empty($form)) {
return false;
}
return $form;
}
protected function loadFormData() {
// Check the session for previously entered form data.
$data =
JFactory::getApplication()->getUserState('com_phocacart.edit.phocacartcategory.data',
array());
if (empty($data)) {
$data = $this->getItem();
}
return $data;
}
public function getItem($pk = null) {
if ($item = parent::getItem($pk)) {
// Convert the params field to an array.
if (isset($item->metadata)) {
$registry = new JRegistry;
$registry->loadString($item->metadata);
$item->metadata = $registry->toArray();
}
// ASSOCIATION
// Load associated Phoca Cart items
$assoc = JLanguageAssociations::isEnabled();
if ($assoc) {
$item->associations = array();
if ($item->id != null){
$associations =
JLanguageAssociations::getAssociations('com_phocacart',
'#__phocacart_categories', 'com_phocacart.category',
$item->id, 'id', 'alias', false);
foreach ($associations as $tag => $association){
$item->associations[$tag] = $association->id;
}
}
}
}
return $item;
}
protected function prepareTable($table){
jimport('joomla.filter.output');
$date = JFactory::getDate();
$user = JFactory::getUser();
$table->title = htmlspecialchars_decode($table->title,
ENT_QUOTES);
$table->alias = JApplicationHelper::stringURLSafe($table->alias);
if (empty($table->alias)) {
$table->alias = JApplicationHelper::stringURLSafe($table->title);
}
$table->parent_id =
PhocacartUtils::getIntFromString($table->parent_id);
$table->date = PhocacartUtils::getDateFromString($table->date);
if (empty($table->id)) {
// Set the values
//$table->created = $date->toSql();
// Set ordering to the last item if not set
if (empty($table->ordering)) {
$db = JFactory::getDbo();
$db->setQuery('SELECT MAX(ordering) FROM
#__phocacart_categories');
$max = $db->loadResult();
$table->ordering = $max+1;
}
}
else {
// Set the values
//$table->modified = $date->toSql();
//$table->modified_by = $user->get('id');
}
}
protected function getReorderConditions($table = null)
{
$condition = array();
$condition[] = 'parent_id = '. (int) $table->parent_id;
//$condition[] = 'state >= 0';
return $condition;
}
public function save($data) {
$app = JFactory::getApplication();
$input = JFactory::getApplication()->input;
//$dispatcher = JDispatcher::getInstance();
$table = $this->getTable();
// Test thumbnail of category image
if(isset($data['image']) && $data['image'] !=
'') {
$thumb =
PhocacartFileThumbnail::getOrCreateThumbnail($data['image'],
'', 1, 1, 1, 0, 'categoryimage');
}
$user = JFactory::getUser();
// ALIAS
if (in_array($input->get('task'), array('apply',
'save', 'save2new')) &&
(!isset($data['id']) || (int) $data['id'] == 0)) {
if ($data['alias'] == null) {
if (JFactory::getConfig()->get('unicodeslugs') == 1) {
$data['alias'] =
JFilterOutput::stringURLUnicodeSlug($data['title']);
} else {
$data['alias'] =
JFilterOutput::stringURLSafe($data['title']);
}
if ($table->load(array('alias' =>
$data['alias']))){
$msg = JText::_('COM_PHOCACART_SAVE_WARNING');
}
list($title, $alias) = $this->generateNewTitle(0,
$data['alias'], $data['title']);
$data['alias'] = $alias;
if (isset($msg)) {
JFactory::getApplication()->enqueueMessage($msg,
'warning');
}
}
} else if ($table->load(array('alias' =>
$data['alias'])) && ($table->id !=
$data['id'] || $data['id'] == 0)) {
$this->setError(\JText::_('COM_PHOCACART_ERROR_ITEM_UNIQUE_ALIAS'));
return false;
}
// Trigger the before event.
JPluginHelper::importPlugin('pca');
// - START SAVE
// ----------
//$save = parent::save($data);
$key = $table->getKeyName();
$pk = (!empty($data[$key])) ? $data[$key] : (int)
$this->getState($this->getName() . '.id');
$isNew = true;
// Include the plugins for the save events.
\JPluginHelper::importPlugin($this->events_map['save']);
try {
// Load the row if saving an existing record.
if ($pk > 0) {
$table->load($pk);
$isNew = false;
}
// Bind the data.
if (!$table->bind($data)) {
$this->setError($table->getError());
return false;
}
if(intval($table->date) == 0) {
$table->date = JFactory::getDate()->toSql();
}
if ($isNew) {
$table->created = JFactory::getDate()->toSql();
$table->created_by = isset($user->id) ? (int)$user->id: 0;
} else {
$table->modified = JFactory::getDate()->toSql();
$table->modified_by = isset($user->id) ? (int)$user->id: 0;
}
// Prepare the row for saving
$this->prepareTable($table);
// Check the data.
if (!$table->check()) {
$this->setError($table->getError());
return false;
}
// Trigger the before save event.
$result =
\JFactory::getApplication()->triggerEvent('PCAonCategoryBeforeSave',
array('com_phocacart.category', &$table, $isNew, $data));
if (in_array(false, $result, true)) {
$this->setError($table->getError());
return false;
}
if (!$table->store()) {
$this->setError($table->getError());
return false;
}
$this->cleanCache();
// Trigger the after save event.
\JFactory::getApplication()->triggerEvent('PCAonCategoryAfterSave',
array('com_phocacart.category', &$table, $isNew, $data));
} catch (\Exception $e) {
$this->setError($e->getMessage());
return false;
}
if (isset($table->$key)) {
$this->setState($this->getName() . '.id',
$table->$key);
}
$this->setState($this->getName() . '.new', $isNew);
// - END SAVE
// ----------
if (!isset($data['group'])) {
$data['group'] = array();
}
$savedId = $this->getState($this->getName().'.id');
if ((int)$savedId > 0) {
PhocacartGroup::storeGroupsById((int)$savedId, 2,
$data['group']);
PhocacartCount::setProductCount(array(0 => (int)$savedId),
'category', 1);
}
$pkName = $table->getKeyName();
// ASSOCIATION
if ((int)$savedId > 0 && $this->associationsContext
&& \JLanguageAssociations::isEnabled() &&
!empty($data['associations'])) {
$associations = $data['associations'];
// Unset any invalid associations
$associations =
Joomla\Utilities\ArrayHelper::toInteger($associations);
// Unset any invalid associations
foreach ($associations as $tag => $id) {
if (!$id){
unset($associations[$tag]);
}
}
// Show a warning if the item isn't assigned to a language
but we have associations.
if ($associations && $table->language ===
'*') {
\JFactory::getApplication()->enqueueMessage(
\JText::_(strtoupper($this->option) .
'_ERROR_ALL_LANGUAGE_ASSOCIATED'),
'warning'
);
}
// Get associationskey for edited item
$db = $this->getDbo();
$query = $db->getQuery(true)
->select($db->qn('key'))
->from($db->qn('#__associations'))
->where($db->qn('context') . ' =
' . $db->quote($this->associationsContext))
->where($db->qn('id') . ' = ' .
(int) $table->$pkName);
$db->setQuery($query);
$old_key = $db->loadResult();
// Deleting old associations for the associated items
$query = $db->getQuery(true)
->delete($db->qn('#__associations'))
->where($db->qn('context') . ' =
' . $db->quote($this->associationsContext));
if ($associations) {
$query->where('(' . $db->qn('id')
. ' IN (' . implode(',', $associations) . ') OR
'
. $db->qn('key') . ' = ' .
$db->q($old_key) . ')');
} else {
$query->where($db->qn('key') . ' =
' . $db->q($old_key));
}
$db->setQuery($query);
$db->execute();
// Adding self to the association
if ($table->language !== '*') {
$associations[$table->language] = (int)
$table->$pkName;
}
if (count($associations) > 1) {
// Adding new association for these items
$key = md5(json_encode($associations));
$query = $db->getQuery(true)
->insert('#__associations');
foreach ($associations as $id) {
$query->values(((int) $id) . ',' .
$db->quote($this->associationsContext) . ',' .
$db->quote($key));
}
$db->setQuery($query);
$db->execute();
}
}
if ($app->input->get('task') ==
'editAssociations')
{
return $this->redirectToAssociations($data);
}
return true;
}
public function delete(&$cid = array()) {
$app = JFactory::getApplication();
$db = JFactory::getDBO();
$result = false;
if (count( $cid )) {
\Joomla\Utilities\ArrayHelper::toInteger($cid);
$cids = implode( ',', $cid );
$table = $this->getTable();
if (!$this->canDelete($table)){
$error = $this->getError();
if ($error){
JLog::add($error, JLog::WARNING);
return false;
} else {
JLog::add(JText::_('JLIB_APPLICATION_ERROR_DELETE_NOT_PERMITTED'),
JLog::WARNING);
return false;
}
}
// FIRST - if there are subcategories - - - - -
$query = 'SELECT c.id, c.title, COUNT( s.parent_id ) AS
numcat'
. ' FROM #__phocacart_categories AS c'
. ' LEFT JOIN #__phocacart_categories AS s ON s.parent_id =
c.id'
. ' WHERE c.id IN ( '.$cids.' )'
. ' GROUP BY c.id, c.title, s.parent_id'
;
$db->setQuery( $query );
if (!($rows2 = $db->loadObjectList())) {
throw new Exception(
JText::_('COM_PHOCACART_ERROR_PROBLEM_LOADING_DATA'), 500 );
return false;
}
// Add new CID without categories which have subcategories (we
don't delete categories with subcat)
$err_cat = array();
$cid = array();
foreach ($rows2 as $row) {
if ($row->numcat == 0) {
$cid[] = (int) $row->id;
} else {
$err_cat[] = $row->title;
}
}
// - - - - - - - - - - - - - - -
// Product with new cid - - - - -
if (count( $cid )) {
\Joomla\Utilities\ArrayHelper::toInteger($cid);
$cids = implode( ',', $cid );
// Select id's from product table, if there are some items,
don't delete it.
$query = 'SELECT c.id, c.title, COUNT( s.category_id ) AS
numproduct'
. ' FROM #__phocacart_categories AS c'
. ' LEFT JOIN #__phocacart_product_categories AS s ON
s.category_id = c.id'
. ' WHERE c.id IN ( '.$cids.' )'
. ' GROUP BY c.id, c.title, s.category_id';
$db->setQuery( $query );
if (!($rows = $db->loadObjectList())) {
throw new Exception(
JText::_('COM_PHOCACART_ERROR_PROBLEM_LOADING_DATA'), 500 );
return false;
}
$err_img = array();
$cid = array();
foreach ($rows as $row) {
if ($row->numproduct == 0) {
$cid[] = (int) $row->id;
} else {
$err_img[] = $row->title;
}
}
if (count( $cid )) {
$cids = implode( ',', $cid );
$query = 'DELETE FROM #__phocacart_categories'
. ' WHERE id IN ( '.$cids.' )';
$db->setQuery( $query );
if (!$db->execute()) {
$this->setError($db->getErrorMsg());
return false;
}
// 7. DELETE CATEGORY RELATIONSHIP (should not happen as this should
be deleted when products are deleted)
$query = 'DELETE FROM #__phocacart_product_categories'
. ' WHERE category_id IN ( '.$cids.' )';
$db->setQuery( $query );
$db->execute();
// Delete items in phocadownload_user_category
/* $query = 'DELETE FROM #__phocadownload_user_category'
. ' WHERE catid IN ( '.$cids.' )';
$db->setQuery( $query );
if (!$db->query()) {
$this->setError($this->_db->getErrorMsg());
return false;
}*/
// 9. DELETE PRODUCT CUSTOMER GROUPS
$query = 'DELETE FROM #__phocacart_item_groups'
. ' WHERE item_id IN ( '.$cids.' )'
. ' AND type = 2';
$db->setQuery( $query );
$db->execute();
}
}
// There are some images in the category - don't delete it
$msg = '';
if (count( $err_cat ) || count( $err_img )) {
if (count( $err_cat )) {
$cids_cat = implode( ", ", $err_cat );
$msg .= JText::plural(
'COM_PHOCACART_ERROR_DELETE_CONTAIN_CATEGORY', $cids_cat );
}
if (count( $err_img )) {
$cids_img = implode( ", ", $err_img );
$msg .= JText::plural(
'COM_PHOCACART_ERROR_DELETE_CONTAIN_PRODUCT', $cids_img );
}
$link =
'index.php?option=com_phocacart&view=phocacartcategories';
$app->enqueueMessage($msg, 'error');
$app->redirect($link);
}
}
return true;
}
protected function batchCopy($value, $pks, $contexts)
{
$categoryId = (int) $value;
$table = $this->getTable();
$db = $this->getDbo();
// Check that the category exists
if ($categoryId) {
$categoryTable = JTable::getInstance('PhocacartCategory',
'Table');
if (!$categoryTable->load($categoryId)) {
if ($error = $categoryTable->getError()) {
// Fatal error
$this->setError($error);
return false;
}
else {
$this->setError(JText::_('JLIB_APPLICATION_ERROR_BATCH_MOVE_CATEGORY_NOT_FOUND'));
return false;
}
}
}
//if (empty($categoryId)) {
if (!isset($categoryId)) {
$this->setError(JText::_('JLIB_APPLICATION_ERROR_BATCH_MOVE_CATEGORY_NOT_FOUND'));
return false;
}
// Check that the user has create permission for the component
$extension =
JFactory::getApplication()->input->get('option');
$user = JFactory::getUser();
if (!$user->authorise('core.create', $extension)) {
$this->setError(JText::_('JLIB_APPLICATION_ERROR_BATCH_CANNOT_CREATE'));
return false;
}
//$i = 0;
// Parent exists so we let's proceed
while (!empty($pks))
{
// Pop the first ID off the stack
$pk = array_shift($pks);
$table->reset();
// Check that the row actually exists
if (!$table->load($pk)) {
if ($error = $table->getError()) {
// Fatal error
$this->setError($error);
return false;
}
else {
// Not fatal error
$this->setError(JText::sprintf('JLIB_APPLICATION_ERROR_BATCH_MOVE_ROW_NOT_FOUND',
$pk));
continue;
}
}
// Alter the title & alias
$data = $this->generateNewTitle($categoryId, $table->alias,
$table->title);
$table->title = $data['0'];
$table->alias = $data['1'];
$table->published = 0;// As default the copied new category is
unpublished
// Reset the ID because we are making a copy
$table->id = 0;
// New category ID
$table->parent_id = $categoryId;
// Ordering
$table->ordering = $this->increaseOrdering($categoryId);
$table->hits = 0;
// Check the row.
if (!$table->check()) {
$this->setError($table->getError());
return false;
}
// Store the row.
if (!$table->store()) {
$this->setError($table->getError());
return false;
}
// Get the new item ID
$newId = $table->get('id');
// Add the new ID to the array
$newIds[$pk] = $newId;
// Store other new information
PhocacartUtilsBatchhelper::storeCategoryItems($pk, (int)$newId);
//$i++;
}
// Clean the cache
$this->cleanCache();
return $newIds;
}
protected function batchMove($value, $pks, $contexts)
{
$categoryId = (int) $value;
$table = $this->getTable();
//$db = $this->getDbo();
$app = JFactory::getApplication();
// Check that the category exists
if ($categoryId) {
$categoryTable = JTable::getInstance('PhocacartCategory',
'Table');
if (!$categoryTable->load($categoryId)) {
if ($error = $categoryTable->getError()) {
// Fatal error
$this->setError($error);
return false;
}
else {
$this->setError(JText::_('JLIB_APPLICATION_ERROR_BATCH_MOVE_CATEGORY_NOT_FOUND'));
return false;
}
}
}
//if (empty($categoryId)) {
if (!isset($categoryId)) {
$this->setError(JText::_('JLIB_APPLICATION_ERROR_BATCH_MOVE_CATEGORY_NOT_FOUND'));
return false;
}
// Check that user has create and edit permission for the component
$extension =
JFactory::getApplication()->input->get('option');
$user = JFactory::getUser();
if (!$user->authorise('core.create', $extension)) {
$this->setError(JText::_('JLIB_APPLICATION_ERROR_BATCH_CANNOT_CREATE'));
return false;
}
if (!$user->authorise('core.edit', $extension)) {
$this->setError(JText::_('JLIB_APPLICATION_ERROR_BATCH_CANNOT_EDIT'));
return false;
}
// Parent exists so we let's proceed
foreach ($pks as $pk)
{
// Check that the row actually exists
if (!$table->load($pk)) {
if ($error = $table->getError()) {
// Fatal error
$this->setError($error);
return false;
}
else {
// Not fatal error
$this->setError(JText::sprintf('JLIB_APPLICATION_ERROR_BATCH_MOVE_ROW_NOT_FOUND',
$pk));
continue;
}
}
// Set the new category ID
$table->parent_id = $categoryId;
// Cannot move the node to be a child of itself.
if ((int)$table->id == (int)$categoryId) {
$app->enqueueMessage(JText::sprintf('JLIB_DATABASE_ERROR_INVALID_NODE_RECURSION',
get_class($pk)));
return false;
}
// Check the row.
if (!$table->check()) {
$this->setError($table->getError());
return false;
}
// Store the row.
if (!$table->store()) {
$this->setError($table->getError());
return false;
}
}
// Clean the cache
$this->cleanCache();
return true;
}
public function increaseOrdering($categoryId) {
$ordering = 1;
$this->_db->setQuery('SELECT MAX(ordering) FROM
#__phocacart_categories WHERE parent_id='.(int)$categoryId);
$max = $this->_db->loadResult();
$ordering = $max + 1;
return $ordering;
}
public function batch($commands, $pks, $contexts)
{
// Sanitize user ids.
$pks = array_unique($pks);
\Joomla\Utilities\ArrayHelper::toInteger($pks);
// Remove any values of zero.
if (array_search(0, $pks, true)) {
unset($pks[array_search(0, $pks, true)]);
}
if (empty($pks)) {
$this->setError(JText::_('JGLOBAL_NO_ITEM_SELECTED'));
return false;
}
$done = false;
if (!empty($commands['assetgroup_id'])) {
if (!$this->batchAccess($commands['assetgroup_id'], $pks))
{
return false;
}
$done = true;
}
//PHOCAEDIT - Parent is by Phoca 0 not 1 like by Joomla!
$comCat =false;
if ($commands['category_id'] == '') {
$comCat = false;
} else if ( $commands['category_id'] == '0') {
$comCat = true;
} else if ((int)$commands['category_id'] > 0) {
$comCat = true;
}
if ($comCat)
//if (isset($commands['category_id']))
{
$cmd = \Joomla\Utilities\ArrayHelper::getValue($commands,
'move_copy', 'c');
if ($cmd == 'c')
{
$result = $this->batchCopy($commands['category_id'], $pks,
$contexts);
if (is_array($result))
{
$pks = $result;
}
else
{
return false;
}
}
elseif ($cmd == 'm' &&
!$this->batchMove($commands['category_id'], $pks, $contexts))
{
return false;
}
$done = true;
}
if (!empty($commands['language_id']))
{
if (!$this->batchLanguage($commands['language_id'], $pks,
$contexts))
{
return false;
}
$done = true;
}
if (!$done) {
$this->setError(JText::_('JLIB_APPLICATION_ERROR_INSUFFICIENT_BATCH_INFORMATION'));
return false;
}
// Clear the cache
$this->cleanCache();
return true;
}
protected function generateNewTitle($category_id, $alias, $title)
{
// Alter the title & alias
$table = $this->getTable();
while ($table->load(array('alias' => $alias,
'parent_id' => $category_id)))
{
$title = StringHelper::increment($title);
$alias = StringHelper::increment($alias, 'dash');
}
return array($title, $alias);
}
function recreate($cid = array(), &$message = '') {
if (count( $cid )) {
\Joomla\Utilities\ArrayHelper::toInteger($cid);
$cids = implode( ',', $cid );
$query = 'SELECT a.image, a.title'.
' FROM #__phocacart_categories AS a' .
' WHERE a.id IN ( '.$cids.' )';
$this->_db->setQuery($query);
$files = $this->_db->loadObjectList();
if (isset($files) && count($files)) {
$msg = array();
foreach($files as $k => $v) {
$title = isset($v->title) ? $v->title : '';
$title = JText::_('COM_PHOCACART_CATEGORY') . ' '
. $v->title . ': ';
if (isset($v->image) && $v->image != '') {
$original = PhocacartFile::existsFileOriginal($v->image,
'categoryimage');
if (!$original) {
// Original does not exist - cannot generate new thumbnail
$msg[$k] = $title .
JText::_('COM_PHOCACART_FILEORIGINAL_NOT_EXISTS');
//return false;
continue;
}
// Delete old thumbnails
$deleteThubms =
PhocacartFileThumbnail::deleteFileThumbnail($v->image, 1, 1, 1,
'categoryimage');
if (!$deleteThubms) {
$msg[$k] = $title.
JText::_('COM_PHOCACART_ERROR_DELETE_THUMBNAIL');
//return false;
continue;
}
$createThubms =
PhocacartFileThumbnail::getOrCreateThumbnail($v->image, 0,
1,1,1,0,'categoryimage');
if (!$createThubms) {
$msg[$k] = $title .
JText::_('COM_PHOCACART_ERROR_WHILECREATINGTHUMB');
//return false;
continue;
}
} else {
//$msg[$k] = $title .
JText::_('COM_PHOCACART_FILENAME_NOT_EXISTS');
$msg[$k] = $title .
JText::_('COM_PHOCACART_CATEGORY_IMAGE_NOT_EXISTS');
//return false;
continue;
}
}
$message = !empty($msg) ? implode('<br />', $msg) :
'';
} else {
$message = JText::_('COM_PHOCACART_ERROR_LOADING_DATA_DB');
return false;
}
} else {
$message = JText::_('COM_PHOCACART_ERROR_ITEM_NOT_SELECTED');
return false;
}
return true;
}
// ASSOCIATION
protected function preprocessForm(JForm $form, $data, $group =
'content'){
/*if ($this->canCreateCategory())
{
$form->setFieldAttribute('catid',
'allowAdd', 'true');
}*/
// Association Phoca Cart items
if (JLanguageAssociations::isEnabled()){
$languages = JLanguageHelper::getContentLanguages(false, true,
null, 'ordering', 'asc');
if (count($languages) > 1){
$addform = new SimpleXMLElement('<form
/>');
$fields = $addform->addChild('fields');
$fields->addAttribute('name',
'associations');
$fieldset = $fields->addChild('fieldset');
$fieldset->addAttribute('name',
'item_associations');
foreach ($languages as $language)
{
$field = $fieldset->addChild('field');
$field->addAttribute('name',
$language->lang_code);
$field->addAttribute('type',
'Modal_Phocacartcategory');
$field->addAttribute('language',
$language->lang_code);
$field->addAttribute('label',
$language->title);
$field->addAttribute('translate_label',
'false');
$field->addAttribute('select',
'true');
$field->addAttribute('new',
'true');
$field->addAttribute('edit',
'true');
$field->addAttribute('clear',
'true');
$field->addAttribute('propagate',
'true');
}
$form->load($addform, false);
}
}
parent::preprocessForm($form, $data, $group);
}
}
?>