<?php
/**
 * @copyright (c) Kufer Software GmbH, Oderstraße 7, D-84453 Mühldorf
 */

namespace Kufer\Web\Classes\dbfilter;

use Kufer\Web\Classes\Dbfilter\AbstractSQLFilter;


class HLMandantenSQLFilter extends AbstractSQLFilter
{
  protected function __construct()
  {
    parent::__construct();

    $this->registerDb('Id', 'id', static::TYPE_INTEGER);
    $this->registerDb('Name', 'name', static::TYPE_STRING);
    $this->registerDb('DvvId', 'dvvnr', static::TYPE_STRING);
    $this->registerDb('LSMDRefIdPrae', 'lsmdrefidprae', static::TYPE_STRING);
    $this->registerDb('LSMDRefIdPost', 'lsmdrefidpost', static::TYPE_STRING);
    $this->registerDb('LSMDRefIdStellen', 'lsmdrefidstellen', static::TYPE_INTEGER);
    $this->registerDb('Kostenstelle', 'kostenst', static::TYPE_STRING);
    $this->registerDb('KennzeichenId', 'kennz', static::TYPE_INTEGER);
    $this->registerDb('AbsenderName', 'absender_name', static::TYPE_STRING);
    $this->registerDb('AbsenderEMail', 'absender_email', static::TYPE_STRING);
  }

  public function getTablePraeffix(): string
  {
    return 'hlmandant';
  }
}