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;
}
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 . "";
}
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, $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('EMNEORD'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
}
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 . "";
}
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 . "";
}
public function __construct($srcBase, $uttrekksBase, $SRC_TABLE_NAME, $kommuneName, $logger)
{
parent::__construct(Constants::getXMLFilename('DOKBESK'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
$this->kommuneName = $kommuneName;
}
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 . "";
}
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 . "";
}
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('ADMINDEL'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
$this->selectQuery = "select ORGENHET, NAVN, EIER, FULLKODE, TYPE, DATO, TILDATO 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('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 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('UTVMOTEDOK'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
$this->docCounter = 0;
}
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;
}
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('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('TILLEGG'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
$this->selectQuery = "select ID, JOURAARNR, REFAARNR, DOKID, FILNR, VARIANT, ITYPE, TIDSPKT, PNID, INFO 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('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('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('UTVBEHDO'), $srcBase, $uttrekksBase, $SRC_TABLE_NAME, $logger);
$this->selectQuery = "select * from " . $SRC_TABLE_NAME . "";
}
function processTable()
{
$this->srcBase->createAndExecuteQuery($this->selectQuery);
$counter = 1;
$dokLinkDAO = new DokLinkDAO($this->srcBase, $this->uttrekksBase, Constants::getXMLFilename('JOURNPST'), $this->kommuneName, $this->logger);
while ($result = $this->srcBase->getQueryResult($this->selectQuery)) {
$journPst = new JournPst();
// TODO : Do I ned this??
// if (substr($noarkJP->JP_ID, 0 , 2) > 30)
// $journPst->JP_ID = "19" . $result['REFAARNR'];
// else
// $journPst->JP_ID = "20" . $result['REFAARNR'];
$journPst->JP_ID = $result['REFAARNR'];
$journPst->JP_JAAR = $result['JOURAAR'];
$journPst->JP_SEKNR = $result['REFNR'];
$journPst->JP_SAID = $result['JOURAARNR'];
// TODO : Do I ned this??
// if (substr($result['JOURAARNR'], 0, 2) > 30)
// $journPst->JP_SAID = "19" . $result['JOURAARNR'];
// else
// $journPst->JP_SAID = "20" . $result['JOURAARNR'];
$journPst->JP_JDATO = Utility::fixDateFormat($result['REGDATO']);
if (isset($result['TYPE']) == true) {
$journPst->JP_NDOKTYPE = $result['TYPE'];
} else {
$journPst->JP_NDOKTYPE = Constants::DOKTYPE_IKKE_ANNGITT;
$this->logger->log($this->XMLfilename, "JOURNALPOST JP_ID (" . $journPst->JP_ID . ") has null for JP.NDOKTYPE. Setting JP.NDOKTYPE to IA which stands for IKKE ANGITT. ", Constants::LOG_WARNING);
$this->warningIssued = true;
}
$journPst->JP_DOKDATO = $result['DATERT'];
$journPst->JP_UDATERT = 0;
// $result['']; // TODO, why 0
if (strcmp($result['STATUS'], '?') == 0) {
$this->logger->log($this->XMLfilename, "JOURNALPOST JP_ID (" . $journPst->JP_ID . ") has status (" . $result['STATUS'] . ") Setting status to AVSLUTTET ", Constants::LOG_WARNING);
$this->warningIssued = true;
$journPst->JP_STATUS = 'A';
} else {
$journPst->JP_STATUS = $result['STATUS'];
}
$journPst->JP_INNHOLD = mysql_real_escape_string($result['INNH1']) . mysql_real_escape_string($result['INNH2']);
if (isset($result['INNH1']) == false && isset($result['INNH2']) == false) {
$journPst->JP_INNHOLD = "Ingen beskrivelse tigjenlig i kilde databasen";
$this->logger->log($this->XMLfilename, "JOURNALPOST JP_ID (" . $journPst->JP_ID . ") is missing JP_INNHOLD. Set to 'Ingen beskrivelse tigjenlig i kilde databasen'", Constants::LOG_WARNING);
$this->warningIssued = true;
}
// Check field isn't just whitespave
if (strlen($journPst->JP_INNHOLD) > 0 && strlen(trim($journPst->JP_INNHOLD)) == 0) {
$journPst->JP_INNHOLD = "Mangler innhold fra ESA. Bare mellomrom var innhold";
$this->logger->log($this->XMLfilename, "JOURNALPOST JP_ID (" . $journPst->JP_ID . ") JP_INNHOLD only contains whitespace. Set to 'Mangler innhold fra ESA. Bare mellomrom var innhold'", Constants::LOG_WARNING);
$this->warningIssued = true;
}
if (isset($result['U1']) == true) {
$journPst->JP_U1 = $result['U1'];
} else {
$journPst->JP_U1 = '0';
}
$journPst->JP_AVSKDATO = Utility::fixDateFormat($result['AVSKRDATO']);
$journPst->JP_FORFDATO = Utility::fixDateFormat($result['SVARFRIST']);
$journPst->JP_UOFF = $result['HJEMMEL'];
$journPst->JP_OVDATO = null;
$journPst->JP_AGDATO = null;
$journPst->JP_AGKODE = "";
$journPst->JP_JPOSTNR = '1';
$journPst->JP_TGKODE = $result['UNNTOFF'];
$journPst->JP_TGGRUPPE = "";
// $journPst->JP_OVDATO = Utility::fixDateFormat($result['']);
// $journPst->JP_AGDATO = Utility::fixDateFormat($result['']);
$journPst->JP_PAPIR = $result['PAPIR'];
if ($result['VEDLEGG'] != null) {
$journPst->JP_ANTVED = $result['VEDLEGG'];
} else {
$journPst->JP_ANTVED = 0;
}
$this->writeToDestination($journPst);
$dokLinkDAO->processDokLinks($journPst, $result['SBHID'], $result['DOKKAT'], $result['PAPIR'], $result['LOKPAPIR'], $result['DOKSTATUS']);
// processDokBeskriv($journPst, $filerInfo);
// processDokVers($journPst, $filerInfo);
$register = "S";
/* $nokkel = $result->SA_ID;
$untoff = $result->SA_TGKODE;
$gruppeId = $result->SA_TGGRUPPE;
$merknad = $result['MERKNAD'];
$sbhId = $noarkSak->SA_ANSVID;
//$this->merknad->processMerknadFromSakOrJP($register, $nokkel, $untoff, $gruppeId, $merknad, $sbhId);
*/
if ($counter++ % Constants::DOT_MARKER_COUNT == 0) {
echo ".";
}
}
$this->srcBase->endQuery($this->selectQuery);
}
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'";
}
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 . "";
}