0x1998 - MANAGER
Edit File: remositoryClassification.php
<?php /************************************************************** * This file is part of Remository * Copyright (c) 2006-17 Martin Brampton * * License: GNU General Public License version 2 or later; see LICENSE.txt * * For support and other information, visit http://remository.com * To contact Martin Brampton, write to martin@remository.com * * Remository started life as the psx-dude script by psx-dude@psx-dude.net * It was enhanced by Matt Smith up to version 2.10 * Since then development has been primarily by Martin Brampton, * with contributions from other people gratefully accepted */ defined('_JEXEC') or die; class remositoryClassification extends remositoryAbstract { public $name = ''; public $type = ''; public $published = 0; public $hidden = 0; public $frequency = 0; public $description = ''; public function __construct ($id=0) { if ($id) { $this->id = $id; $this->getValues(); } } protected function tableName () { return '#__downloads_classify'; } public function getValues () { $sql = "SELECT * FROM #__downloads_classify WHERE id = $this->id"; $this->readDataBase($sql); } public function saveValues () { $interface = remositoryInterface::getInstance(); $database = $interface->getDB(); if ($this->id == 0) { $sql = $this->insertSQL(); remositoryRepository::doSQL ($sql); $this->id = $database->insertid(); } else { $sql = $this->updateSQL(); remositoryRepository::doSQL ($sql); } } public static function classfnList ($fileid) { $fileid = intval($fileid); $html = array(); $interface = remositoryInterface::getInstance(); $database = $interface->getDB(); $sql = "SELECT c.id, c.name, c.type, fc.file_id FROM #__downloads_classify AS c " ." LEFT JOIN #__downloads_file_classify AS fc ON c.id = fc.classify_id AND fc.file_id = $fileid " ." WHERE c.published = 1 ORDER BY c.type, c.name"; $database->setQuery($sql); $objectlist = $database->loadObjectList(); if ($objectlist) foreach ($objectlist as $object) $linker[$object->type][] = $object; $nulloption = new stdClass(); $nulloption->id = 0; $nulloption->name = _DOWN_ROLE_NONE_THESE; $nulloption->selected = false; if (isset($linker)) foreach ($linker as $type=>$sublist) { foreach ($sublist as $object) if (!is_null($object->file_id) AND $object->file_id == $fileid) $selected[] = $object->id; if (!isset($selected)) $selected = array(0); $sublist[] = $nulloption; $html[$type] = remositoryRepository::getInstance()->selectList($sublist, "classification[]", 'multiple="multiple"', $selected, 'id', 'name'); unset($selected); } return $html; } }