public function __construct($srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger, $ordVerdDAO, $merknadDAO)
 {
     parent::__construct(Constants::getXMLFilename('NOARKSAK'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
     $this->ordVerdDAO = $ordVerdDAO;
     $this->merknadDAO = $merknadDAO;
     $this->selectQuery = "select JOURAARNR, JOURAAR, JOURNR, PAPIR, AAPNET, INNH1, INNH2, MERKNAD, U1, STATUS, FYSARK, FRAARKDEL, SAKTYPE, SAKART, JOURENHET, OTYPE, OKODE1, UNAVN, ADMID, SBHID, UNNTOFF, HJEMMEL from " . $SRC_TABLE_NAME . "";
 }
Пример #2
0
 public function __construct($srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger, $utvSakDAO, $utvBehDoDAO)
 {
     parent::__construct(Constants::getXMLFilename('UTVBEH'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
     $this->selectQuery = "select UTVID, BEHID, JOURAARNR, BEHNR, MOTEID, SAKSNR, SAKSAAR, STATUS, PROTOKOLL from " . $SRC_TABLE_NAME . "";
     $this->utvSakDAO = $utvSakDAO;
     $this->utvBehDoDAO = $utvBehDoDAO;
 }
Пример #3
0
 public function __construct($srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger)
 {
     parent::__construct(Constants::getXMLFilename('TLKODE'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
     $this->selectQuery = "select TILLEGSK, EKODE3, ETEXT3  from " . $SRC_TABLE_NAME . " group by TILLEGSK, EKODE3, ETEXT3 ORDER BY TILLEGSK";
     $this->logger->log($this->XMLfilename, "Created based on following query. select TILLEGSK, EKODE3, ETEXT3  from dgjmjo group by TILLEGSK, EKODE3, ETEXT3 ORDER BY TILLEGSK", Constants::LOG_INFO);
     $this->logger->log($this->XMLfilename, "This will not be correct if tilleggskoder are used that are not part of K-Koder. Manual check in DGJMJO.TILLEGSK advised.", Constants::LOG_TODO);
 }
 public function __construct($srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger)
 {
     parent::__construct(Constants::getXMLFilename('UTVMOTE'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
     $this->selectQuery = "select ID, MOTENR, UTVID, LUKKET, MOTEDATO, MOTETID, FRIST, SAKSKART, PROTOKOLL, JOURAARNR FROM " . $SRC_TABLE_NAME . "";
     // Yes $SRC_TABLE_NAME is wrong but I need to finish this!!!
     $this->utvMoteDokDAO = new UtvMoteDokDAO($srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
 }
 public function __construct($srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger, $merknadDao, $kommuneName)
 {
     parent::__construct(Constants::getXMLFilename('JOURNPST'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
     $this->merknadDao = $merknadDao;
     //10003633  10004929
     $this->selectQuery = "select * from " . $SRC_TABLE_NAME . "";
     //" where refaarnr = '10004929'";
     $this->kommuneName = $kommuneName;
 }
 public function __construct($srcBase, $uttrekksBase, $SRC_TABLE_NAME, $kommuneName, $logger)
 {
     parent::__construct(Constants::getXMLFilename('DOKLINK'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
     $this->selectFromFilerQuery = "select REFAARNR, DOKID, FILNOKKEL, OPPRETTETDATO, OPPRETTETAVID, FILNR, AKTIV from FILER WHERE REFAARNR = '";
     $this->selectFromVedleggQuery = "select REFAARNR, VEDLNR, BESKRIVELSE, DOKID, DOKNAVN, DOKODE, TKDATO, TKAV, PAPIR, LOKPAPIR, DOKSTATUS, DOKKAT, PNID, GRUPPE, GRUPPEID, UNNTOFF, HJEMMEL, AVGRADER, AGDATO from DGJMVEDLEGG WHERE REFAARNR = '";
     $this->kommuneName = $kommuneName;
     $this->dokVersDAO = new DokVersDAO($this->srcBase, $this->uttrekksBase, "", $kommuneName, $logger);
     $this->dokBeskDAO = new DokBeskDAO($this->srcBase, $this->uttrekksBase, "", $kommuneName, $logger);
 }
 public function __construct($srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger)
 {
     parent::__construct(Constants::getXMLFilename('ADRADMENH'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
     $this->selectQuery = "SELECT ADRID, ORGENHET FROM " . $SRC_TABLE_NAME . "";
     $this->logger = $logger;
 }
 public function __construct($srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger)
 {
     parent::__construct(Constants::getXMLFilename('POLSAKG'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
     $this->selectQuery = "select JOURAARNR, BEHTYPE, KLAGE, LUKKET, HJEMMEL, AAPNET, AVSLUTTET, MERKNAD FROM " . $SRC_TABLE_NAME . " WHERE BEHTYPE = 'PS'";
 }
 public function __construct($srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger)
 {
     parent::__construct(Constants::getXMLFilename('UTVMOTEDOK'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
     $this->docCounter = 0;
 }
Пример #10
0
 public function DokVersDAO($srcBase, $uttrekksBase, $SRC_TABLE_NAME, $kommuneName, $logger)
 {
     parent::__construct(Constants::getXMLFilename('DOKVERS'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
 }
 public function __construct($srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger)
 {
     parent::__construct(Constants::getXMLFilename('INFOTYPE'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
     $this->selectQuery = "select KODE, BESKRIVELSE, LTEKST1, AUTOLOG, OPPBETID, MERKNAD from " . $SRC_TABLE_NAME . "";
 }
 public function __construct($srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger)
 {
     parent::__construct(Constants::getXMLFilename('ALIASADM'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
     $this->selectQuery = "select FRAORGENHET, TILORGENHET, MERKNAD FROM " . $SRC_TABLE_NAME . "";
 }
Пример #13
0
 public function __construct($srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger)
 {
     parent::__construct(Constants::getXMLFilename('UTVMEDL'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
     $this->selectQuery = "select PNID, UTVID, FUNKFRA, FUNKTIL, FUNKSJON, NR, REPPARTI, VARAPERSON, ADRID, MERKNAD from " . $SRC_TABLE_NAME . "";
 }
 public function __construct($srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger)
 {
     parent::__construct(Constants::getXMLFilename('TGMEDLEM'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
     $this->selectQuery = "select PEID, GRUPPEID, KLAVID from " . $SRC_TABLE_NAME . "";
 }
 public function __construct($srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger)
 {
     parent::__construct(Constants::getXMLFilename('UTVBEHSTAT'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
     $this->selectQuery = "select STATUS, BESKRIVELSE, KOLISTE, SAKSKART, BSTATUS from " . $SRC_TABLE_NAME . "";
 }
 public function __construct($srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger)
 {
     parent::__construct(Constants::getXMLFilename('AVGRKODE'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
     $this->selectQuery = "select AVGRADER, BESKRIVELSE from " . $SRC_TABLE_NAME . "";
     $this->logger = $logger;
 }
Пример #17
0
 public function __construct($srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger)
 {
     parent::__construct(Constants::getXMLFilename('ARKIV'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
     $this->selectQuery = "select ARKIV, BESKRIVELSE, FRADATO, TILDATO, MERKNAD from " . $SRC_TABLE_NAME . "";
 }
Пример #18
0
 public function __construct($srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger)
 {
     parent::__construct(Constants::getXMLFilename('TGKODE'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
     $this->selectQuery = "select UNNTOFF, BESKRIVELSE, SERIE, EPOSTNIV, FRADATO, TILDATO from " . $SRC_TABLE_NAME . "";
 }
Пример #19
0
 public function __construct($srcBase, $uttrekksBase, $SRC_TABLE_NAME, $kommuneName, $logger)
 {
     parent::__construct(Constants::getXMLFilename('DOKBESK'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
     $this->kommuneName = $kommuneName;
 }
Пример #20
0
 public function __construct($srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger)
 {
     parent::__construct(Constants::getXMLFilename('TGGRP'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
     $this->selectQuery = "select FULLTNAVN, GRUPPEID, OPPRAVID, FRADATO, TILDATO, CTYPE from " . $SRC_TABLE_NAME . "";
 }
Пример #21
0
 public function __construct($srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger)
 {
     parent::__construct(Constants::getXMLFilename('TILLEGG'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
     $this->selectQuery = "select ID, JOURAARNR, REFAARNR, DOKID, FILNR, VARIANT, ITYPE, TIDSPKT, PNID, INFO FROM " . $SRC_TABLE_NAME . "";
 }
Пример #22
0
 public function __construct($srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger)
 {
     parent::__construct(Constants::getXMLFilename('EMNEORD'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
 }
Пример #23
0
 public function __construct($srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger)
 {
     parent::__construct(Constants::getXMLFilename('DOKTYPE'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
     $this->selectQuery = "select TYPE, TITTEL, EKSTPROD, INTMOT, EKSTMOT, OPPF from " . $SRC_TABLE_NAME . "";
 }
 public function __construct($srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger)
 {
     parent::__construct(Constants::getXMLFilename('EARKKODE'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
     $this->selectQuery = "select EKODE, STIKKORD FROM " . $SRC_TABLE_NAME . "";
     $this->emneOrd = new EmneOrdDAO($srcBase, $uttrekksBase, "UNKNOWN", $logger);
 }
 public function __construct($srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger)
 {
     parent::__construct(Constants::getXMLFilename('UTVBEHDO'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
     $this->selectQuery = "select * from " . $SRC_TABLE_NAME . "";
 }
 public function __construct($srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger)
 {
     parent::__construct(Constants::getXMLFilename('ADMINDEL'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
     $this->selectQuery = "select ORGENHET, NAVN, EIER, FULLKODE, TYPE, DATO, TILDATO FROM " . $SRC_TABLE_NAME . "";
 }
Пример #27
0
 public function __construct($srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger)
 {
     parent::__construct(Constants::getXMLFilename('SAKPART'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
     $this->selectQuery = "select REFAARNR, U1, NAVN, NAVNKODE, ADRESSE, ADRESSE2, POSTNR, POSTSTED, EPOSTADR, KONTAKT, ADRGRUPPE, FAX, TELEFON, LAND FROM " . $SRC_TABLE_NAME . " WHERE REGISTER = 'S'";
 }
Пример #28
0
 public function __construct($srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger)
 {
     parent::__construct(Constants::getXMLFilename('UTVALG'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
     $this->selectQuery = "select ID, UTV, UTVALG, AVD, FYSARK, FUNKTIL from " . $SRC_TABLE_NAME . "";
 }
 public function __construct($srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger)
 {
     parent::__construct(Constants::getXMLFilename('ARSTATUS'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
     $this->selectQuery = "select STATUS, BESKRIVELSE, SPEFSAK, SPEFDOK, LUKKET from " . $SRC_TABLE_NAME . "";
 }
 public function __construct($srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger)
 {
     parent::__construct(Constants::getXMLFilename('JOURNENH'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
     $this->selectQuery = "select JOURENHET, BESKRIVELSE from " . $SRC_TABLE_NAME . "";
 }