function GetLanguageSelect($FolderName, &$WarningCollector, $SelectedLanguage)
{
    $Select = false;
    $FolderHandle = @opendir($FolderName);
    if (!$FolderHandle) {
        $WarningCollector->Add("We had a problem opening the languages folder");
    } else {
        $Languages = array();
        $Key = 0;
        // Loop through each file
        while (false !== ($Item = readdir($FolderHandle))) {
            $RecordItem = true;
            if ($Item == "." || $Item == ".." || is_dir($FolderName . $Item)) {
                // do nothing
            } else {
                // Retrieve languages names
                $FileParts = explode(".", $Item);
                $Languages[] = $FileParts[0];
                if ($FileParts[0] == $SelectedLanguage) {
                    $Key = count($Languages);
                }
            }
        }
        $Select = new Select();
        $Select->Name = "Language";
        for ($i = 0; $i < count($Languages); $i++) {
            $Select->AddOption($Languages[$i], $Languages[$i]);
        }
        $Select->SelectedIndex = $Key;
    }
    return $Select;
}

 public function loadRandom()
 {
     $select = new Select(self::$db);
     $select->from(self::$table, "*")->where("`state` =" . self::$db->getSQ(), array(1))->rand()->limit(1);
     $row = self::$db->selectRow($select);
     return $this->init($row);
 }

 protected static function getAllOnID($table, $id)
 {
     $select = new Select(self::$db);
     $select->from($table, "*")->where("`id` = ?", array($id));
     $data = self::$db->select($select);
     return $data;
 }

 public function getPerfil()
 {
     $element = new Select('perfil');
     $element->setLabel('Perfil');
     $element->setAttributes(array('id' => 'perfil', 'class' => 'form-control'));
     return $element;
 }

 /**
  * @covers Select::newSelect
  * @uses   Select::__construct
  * @uses   Select::getQuery
  */
 public function testConstructorTableNameSelect()
 {
     $select = new Select('TableName');
     $assertSql = 'SELECT * FROM TableName';
     // Assert
     $this->assertEquals($select->getQuery(), $assertSql);
 }

 public function loadRandom()
 {
     $select = new Select(self::$db);
     $select->from(self::$table, "*")->rand()->limit(1);
     $row = self::$db->selectRow($select);
     return $this->init($row);
 }

	function doLogin() {
		$this->save("login");
		if (empty($this->messages)) {
			$select = new Select("users");
			$select->add(Exp::eq("username", $this->login["username"]));
			$user = DB::unique($select);
			if (empty($user)) {
				$this->addMsgMessage("error.fieldNotFound", "login.username");
				Msg::save($this->messages);
				Apu::redirect("login");
			}
			if ($user["password"] != $this->login["password"]) {
				$this->addMsgMessage("error.fieldNotFound", "login.password");
				Msg::save($this->messages);
				Apu::redirect("login");
			}	
			$date = new Date();
			Session::save(LOGIN_SCOPE, $user, "user");
			Session::save(LOGIN_SCOPE, $date, "last_access");
			$this->remove();
			Apu::redirect("frame");
		} else {
			Msg::save($this->messages);
			Apu::redirect("login");
		}
	}

 /**
  * __construct
  *
  * @param string  $caption  caption
  * @param string  $name     name
  * @param integer $size     size
  * @param integer $value    value unix timestamp
  * @param boolean $showtime true to show time, false for date only
  */
 public function __construct($caption, $name, $size = 2, $value = 0, $showtime = true)
 {
     parent::__construct($caption, '');
     $value = (int) $value;
     $value = $value > 0 ? $value : time();
     $datetime = getdate($value);
     $date = new DateSelect('', $name . '[date]', $size, $value);
     $date->setAttribute('id', $name . '-date');
     $this->addElement($date);
     if ($showtime) {
         $timearray = array();
         for ($i = 0; $i < 24; ++$i) {
             for ($j = 0; $j < 60; $j = $j + 10) {
                 $key = $i * 3600 + $j * 60;
                 $timearray[$key] = $j != 0 ? $i . ':' . $j : $i . ':0' . $j;
             }
         }
         ksort($timearray);
         $timeselect = new Select('', $name . '[time]', $datetime['hours'] * 3600 + 600 * ceil($datetime['minutes'] / 10));
         $timeselect->setAttribute('id', $name . '-time');
         $timeselect->addOptionArray($timearray);
         $timeselect->setClass('span2');
         $this->addElement($timeselect);
     } else {
         $this->addElement(new Hidden($name . '[time]', 0));
     }
 }

 public function testCompileWithNumericValue()
 {
     $field = new Select("test", "Test", array("test", "blue"), array("useNumericValue" => true));
     $expected = "<label for=\"test\">Test</label><select name=\"test\" ><option value=\"0\" selected=\"selected\">test</option><option value=\"1\">blue</option></select>";
     $value = $field->compile(0);
     $this->assertEquals($expected, $value);
 }

 public static function getImgOnID($id)
 {
     $select = new Select(self::$db);
     $select->from(self::$table, "*")->where("`product_id` = " . self::$db->getSQ(), array($id));
     $data = self::$db->select($select);
     $images = ObjectDB::buildMultiple(__CLASS__, $data);
     return $images;
 }

 /** @test */
 public function it_renders_with_options_the_full_html()
 {
     $field = new Select('test', 'Test', ['values' => ['miro' => 'test']]);
     $field->render();
     $options = $field->options();
     $this->assertCount(1, $options);
     $this->assertInstanceOf(Option::class, $options[0]);
 }

 /**
  * @param Select $select
  * @return array
  */
 public function getElementsCount(Select $select)
 {
     $select->setLimit(null);
     $select->setOffset(null);
     $select->setColumns(array('COUNT(*)'));
     $db = new DbGateway();
     return $db->execute($select, \PDO::FETCH_COLUMN);
 }

 protected function __listTables($cache = TRUE)
 {
     if ($cache && sizeof($this->tables)) {
         return $this->tables;
     }
     $select = new Select('information_schema.TABLES');
     $select->where(array(array('field' => 'TABLE_SCHEMA', 'value' => $this->params['name'])));
     return $this->tables = $select->execute('\\apf\\db\\mysql5\\Table', $smart = FALSE);
 }

 public static function getStudentsOnGroupID($group_id)
 {
     $select = new Select(self::$db);
     $select->from(self::$table, "*")->where("`group_id` = ?", array($group_id));
     $data = self::$db->select($select);
     $students = ObjectDB::buildMultiple(__CLASS__, $data);
     //foreach ($groups as $g) $g->postHandling();
     return $students;
 }

 /**
  * render
  *
  * @return string
  */
 public function render()
 {
     $editor_handler = \XoopsEditorHandler::getInstance();
     $editor_handler->allowed_editors = $this->allowed_editors;
     $option_select = new Select("", $this->name, $this->value);
     $onchangeCode = '"if(this.options[this.selectedIndex].value.length > 0 ){window.document.forms.' . $this->form->getName() . '.submit();}"';
     $option_select->set('onchange', $onchangeCode);
     $option_select->addOptionArray($editor_handler->getList($this->nohtml));
     $this->addElement($option_select);
     return parent::render();
 }

 public static function getItemsOnView($view)
 {
     $select = new Select(self::$db);
     $select->from(self::$table, "*")->where("`view_id` = ?", array($view));
     $data = self::$db->select($select);
     $items = ObjectDB::buildMultiple(__CLASS__, $data);
     foreach ($items as $item) {
         $item->postHandling();
     }
     return $items;
 }

 public static function getGroupsOnTeacherID($id)
 {
     $select = new Select(self::$db);
     $select->from(self::$table, "*")->where("`teacher_id` = ?", array($id));
     $data = self::$db->select($select);
     $groups = ObjectDB::buildMultiple(__CLASS__, $data);
     foreach ($groups as $g) {
         $g->postHandling();
     }
     return $groups;
 }

 public static function getItems()
 {
     $select = new Select(self::$db);
     $select->from(self::$table, array("s.*", "p.img"), "s")->join("INNER", "product", "p", "s.product_id = p.id");
     $data = self::$db->select($select);
     $slider = ObjectDB::buildMultiple(__CLASS__, $data);
     foreach ($slider as $slide) {
         $slide->postHandling();
     }
     return $slider;
 }

 public function clearSelect()
 {
     $this->last_select_user_id = $this->select_user_id;
     $select = new Select();
     $select->day = $this->room->day;
     $select->state = $this->state;
     $select->selected_mate_id = $this->select_user_id;
     $select->save();
     $this->select_user_id = null;
     $this->save();
 }

 public function testOffset()
 {
     $offset = 123;
     $table = $this->getMockBuilder(\Sharkodlak\FluentDb\Table::class)->disableOriginalConstructor()->getMock();
     $factory = $this->getMockBuilder(\Sharkodlak\FluentDb\Factory\Factory::class)->getMock();
     $queryBuilder = $this->getMockBuilder(\Sharkodlak\FluentDb\Query\Builder::class)->setConstructorArgs(['SELECT', 'FROM'])->setMethods(['offset'])->getMock();
     $queryBuilder->expects($this->once())->method('offset')->with($this->equalTo($offset));
     $factory->expects($this->once())->method('getQueryBuilder')->will($this->returnValue($queryBuilder));
     $table->expects($this->once())->method('getFactory')->will($this->returnValue($factory));
     $query = new Select($table);
     $this->assertInstanceOf(Select::class, $query->offset($offset));
 }