function processTable()
{
$this->srcBase->createAndExecuteQuery($this->selectQuery);
//Create the first entry with no value See Page 85 of standard
$adminDel0 = new AdminDel();
$adminDel0->AI_ID = Constants::ADMININDEL_TOPNIVA;
$adminDel0->AI_ADMBET = 'Ikke angitt';
$this->writeToDestination($adminDel0);
$this->logger->log($this->SRC_TABLE_NAME, "Adding a (AI_ID, AI_ADMBET) = (0, Ikke angitt) ", Constants::LOG_INFO);
$this->infoIssued = true;
while ($result = $this->srcBase->getQueryResult($this->selectQuery)) {
// There is a dummy entry in the table with $result['ORGENHET'] == -1
if ($result['ORGENHET'] >= 0) {
$adminDel = new AdminDel();
$adminDel->AI_ID = $result['ORGENHET'];
$adminDel->AI_ADMBET = $result['NAVN'];
// The very first entry has $result['ORGENHET'] == 1 and only the above should be used
if ($result['ORGENHET'] > 0) {
$adminDel->AI_FORKDN = $result['FULLKODE'];
$adminDel->AI_TYPE = $result['TYPE'];
$adminDel->AI_IDFAR = $result['EIER'];
$adminDel->AI_ADMKORT = $result['FULLKODE'];
$adminDel->AI_FRADATO = Utility::fixDateFormat($result['DATO']);
$adminDel->AI_TILDATO = Utility::fixDateFormat($result['TILDATO']);
}
$this->writeToDestination($adminDel);
}
}
$this->srcBase->endQuery($this->selectQuery);
}
function processTable()
{
$this->srcBase->createAndExecuteQuery($this->selectQuery);
while ($result = $this->srcBase->getQueryResult($this->selectQuery)) {
$tggrp = new Tggrp();
$tggrp->TG_GRUPPNAVN = $result['FULLTNAVN'];
$tggrp->TG_GRUPPEID = $result['GRUPPEID'];
if (is_null($result['OPPRAVID'])) {
$tggrp->TG_OPPRAV = Constants::INGENBRUKER_ID;
$this->logger->log($this->XMLfilename, "TG_OPPRAV is null for TG_GRUPPNAVN (" . $tggrp->TG_GRUPPNAVN . ") setting it to unkown user " . Constants::INGENBRUKER_ID, Constants::LOG_WARNING);
} else {
$tggrp->TG_OPPRAV = $result['OPPRAVID'];
}
if (strcmp($result['CTYPE'], "T") == 0) {
$tggrp->TG_GENERELL = '1';
} else {
$tggrp->TG_GENERELL = '0';
}
$this->logger->log($this->XMLfilename, "TG_GENERELL is missing for TG_GRUPPNAVN (" . $tggrp->TG_GRUPPNAVN . ") assumed a value from CTYPE field (" . $result['CTYPE'] . ") setting TG_GENERELL to " . $tggrp->TG_GENERELL, Constants::LOG_WARNING);
if (is_null($result['FRADATO'])) {
$this->logger->log($this->XMLfilename, "TG_FRADATO is null for TG_GRUPPNAVN (" . $tggrp->TG_GRUPPNAVN . ") setting it to unkown date " . Constants::DATE_AUTO_START, Constants::LOG_WARNING);
$tggrp->TG_FRADATO = Utility::fixDateFormat(Constants::DATE_AUTO_START);
} else {
$tggrp->TG_FRADATO = Utility::fixDateFormat($result['FRADATO']);
}
if (is_null($result['TILDATO'])) {
$this->logger->log($this->XMLfilename, "TG_TILDATO is null for TG_GRUPPNAVN (" . $tggrp->TG_GRUPPNAVN . ") setting it to unkown date " . Constants::DATE_AUTO_END, Constants::LOG_WARNING);
$tggrp->TG_TILDATO = Utility::fixDateFormat(Constants::DATE_AUTO_END);
} else {
$tggrp->TG_TILDATO = Utility::fixDateFormat($result['TILDATO']);
}
$this->writeToDestination($tggrp);
}
$this->srcBase->endQuery($this->selectQuery);
}
function processTable()
{
$tgKode = new Tgkode();
$tgKode->TK_TGKODE = 'F';
$tgKode->TK_BETEGN = 'Ofl. §5a, Beskyttelsesinstruksen';
$tgKode->TK_EPOSTNIV = '4';
$this->writeToDestination($tgKode);
$this->logger->log($this->XMLfilename, "Added missing TGKODE TK_TGKODE(" . $tgKode->TK_TGKODE . ")", Constants::LOG_INFO);
$this->infoIssued = true;
$this->srcBase->createAndExecuteQuery($this->selectQuery);
while ($result = $this->srcBase->getQueryResult($this->selectQuery)) {
$tgKode = new Tgkode();
if (strcmp($result['UNNTOFF'], ' ') != 0) {
$tgKode->TK_TGKODE = $result['UNNTOFF'];
$tgKode->TK_BETEGN = $result['BESKRIVELSE'];
$tgKode->TK_SERIE = $result['SERIE'];
$tgKode->TK_EPOSTNIV = $result['EPOSTNIV'];
$tgKode->TK_FRADATO = Utility::fixDateFormat($result['FRADATO']);
$tgKode->TK_TILDATO = Utility::fixDateFormat($result['TILDATO']);
$this->writeToDestination($tgKode);
} else {
$this->logger->log($this->XMLfilename, "TK.TGKODE value is null. null is used where TGKODE is not set. This value has been ignored.", Constants::LOG_WARNING);
$this->warningIssued = true;
}
}
$this->srcBase->endQuery($this->selectQuery);
}
function processTable()
{
$this->srcBase->createAndExecuteQuery($this->selectQuery);
while ($result = $this->srcBase->getQueryResult($this->selectQuery)) {
$tgInfo = new Tginfo();
$tgInfo->TJ_PEID = $result['PEID'];
$tgInfo->TJ_JENHET = $result['JOURENHET'];
if (isset($result['JOURENHET']) == false) {
$tgInfo->TJ_JENHET = Constants::JOURNENHET_MISSING;
$this->logger->log($this->XMLfilename, "For TJ_PEID (" . $result['PEID'] . ") TJ_JENHET is null. Required value. Setting it to " . Constants::JOURNENHET_MISSING, Constants::LOG_WARNING);
$this->warningIssued = true;
}
if (isset($result['ADMID']) == false) {
$tgInfo->TJ_ADMID = '0';
$this->logger->log($this->XMLfilename, "For TJ_PEID (" . $result['PEID'] . ") assuming NULL value for ADMID represents 0 ", Constants::LOG_WARNING);
$this->warningIssued = true;
} else {
$tgInfo->TJ_ADMID = $result['ADMID'];
}
$tgInfo->TJ_AUTAV = $result['AUTAV'];
if (isset($result['DATO']) == true) {
$tgInfo->TJ_FRADATO = Utility::fixDateFormat($result['DATO']);
} else {
$tgInfo->TJ_FRADATO = "19981201";
$this->logger->log($this->XMLfilename, "For TJ_PEID (" . $result['PEID'] . ") assuming missing value TJ_FRADATO is 19981201", Constants::LOG_WARNING);
$this->warningIssued = true;
}
$tgInfo->TJ_TILDATO = Utility::fixDateFormat($result['TILDATO']);
$tgInfo->TJ_AUTOPPAV = $result['AUTOPPAV'];
$this->writeToDestination($tgInfo);
}
$this->srcBase->endQuery($this->selectQuery);
}
function processTable()
{
$this->srcBase->createAndExecuteQuery($this->selectQuery);
while ($result = $this->srcBase->getQueryResult($this->selectQuery)) {
$arkivper = new ArkivPer();
$arkivper->AP_ARKIV = $result['ARKIV'];
$arkivper->AP_PERIODE = $result['PERIODE'];
if (strcasecmp($result['STATUS'], "A") == 0) {
$arkivper->AP_STATUS = "B";
$this->logger->log($this->XMLfilename, "AP_STATUS is still A for AP_ARKIV(" . $arkivper->AP_ARKIV . "). Setting it to B", Constants::LOG_WARNING);
$this->warningIssued = true;
} else {
$arkivper->AP_STATUS = $result['STATUS'];
}
$arkivper->AP_FRADATO = Utility::fixDateFormat($result['FRADATO']);
if (isset($result['TILDATO']) == false) {
$arkivper->AP_TILDATO = Utility::fixDateFormat(Constants::DATE_AUTO_END);
$this->logger->log($this->XMLfilename, "AP_TILDATO is null for AP_ARKIV(" . $arkivper->AP_ARKIV . "). Setting it to " . Utility::fixDateFormat(Constants::DATE_AUTO_END), Constants::LOG_WARNING);
$this->warningIssued = true;
} else {
$arkivper->AP_TILDATO = Utility::fixDateFormat($result['TILDATO']);
}
$arkivper->AP_MERKNAD = $result['MERKNAD'];
$this->writeToDestination($arkivper);
}
$this->srcBase->endQuery($this->selectQuery);
}
function processTable()
{
$this->srcBase->createAndExecuteQuery($this->selectQuery);
$perNavn = new PerNavn();
$perNavn->PN_ID = Constants::INGENBRUKER_ID;
$perNavn->PN_PEID = Constants::INGENBRUKER_ID;
$perNavn->PN_AKTIV = "1";
$perNavn->PN_INIT = "IBK";
$perNavn->PN_NAVN = "INGEN BRUKER";
$perNavn->PN_ENAVN = "BRUKER";
$perNavn->PN_FORNAVN = "INGEN";
$perNavn->PE_FRADATO = Constants::DATE_AUTO_START;
$perNavn->PE_TILDATO = Constants::DATE_AUTO_END;
$this->logger->log($this->XMLfilename, "Creating a PERNANVN with PN_ID (" . Constants::INGENBRUKER_ID . ") to be used where we need a PERNAVN identifier but it's missing in the database", Constants::LOG_WARNING);
$this->warningIssued = true;
$this->writeToDestination($perNavn);
while ($result = $this->srcBase->getQueryResult($this->selectQuery)) {
$perNavn = new PerNavn();
$perNavn->PN_ID = $result['ID'];
$perNavn->PN_PEID = $result['PEID'];
$perNavn->PN_AKTIV = $result['AKTIV'];
$perNavn->PN_INIT = $result['INITIALER'];
$perNavn->PN_NAVN = $result['FULLTNAVN'];
$perNavn->PN_ENAVN = $result['ETTERNAVN'];
$perNavn->PN_FORNAVN = $result['FORNAVN'];
$perNavn->PN_FRADATO = Utility::fixDateFormat($result['DATO']);
$perNavn->PN_TILDATO = Utility::fixDateFormat($result['TILDATO']);
$this->writeToDestination($perNavn);
}
$this->srcBase->endQuery($this->selectQuery);
}
function processTable()
{
$this->srcBase->createAndExecuteQuery($this->selectQuery);
// This utvalg is created to handle the cases where UTVID is null in DGMAMO
$utvalg = new Utvalg();
$utvalg->UT_ID = '0';
$utvalg->UT_KODE = 'UKT';
$utvalg->UT_NAVN = 'UKJENT UTVALG';
$utvalg->UT_ADMID = '0';
$utvalg->UT_MONUMSER = "0";
$this->logger->log($this->XMLfilename, "UT.ID with value 0 added to handle UTVMOTE where UTVID is null", Constants::LOG_WARNING);
$this->warningIssued = true;
$this->writeToDestination($utvalg);
while ($result = $this->srcBase->getQueryResult($this->selectQuery)) {
$utvalg = new Utvalg();
$utvalg->UT_ID = $result['ID'];
$utvalg->UT_KODE = $result['UTV'];
$utvalg->UT_NAVN = $result['UTVALG'];
$utvalg->UT_ADMID = '0';
$this->logger->log($this->XMLfilename, "For UT.ID (" . $result['ID'] . "), UT_ADMID has no value, not in table. Setting to 0", Constants::LOG_WARNING);
$this->warningIssued = true;
$utvalg->UT_ARKDEL = $result['FYSARK'];
if ($result['FUNKTIL'] != null) {
$utvalg->UT_NEDLAGT = Utility::fixDateFormat($result['FUNKTIL']);
}
$utvalg->UT_MONUMSER = "0";
$this->logger->log($this->XMLfilename, "NUMSER foreign key relationship missing. MONUMSER required value. Added MONUMSER value = 0", Constants::LOG_ERROR);
$this->errorIssued = true;
$this->writeToDestination($utvalg);
}
$this->srcBase->endQuery($this->selectQuery);
}
function processTable()
{
$this->srcBase->createAndExecuteQuery($this->selectQuery);
while ($result = $this->srcBase->getQueryResult($this->selectQuery)) {
$utvMedl = new UtvMedl();
$utvMedl->UM_PNID = $result['PNID'];
$utvMedl->UM_UTVID = $result['UTVID'];
$utvMedl->UM_FRADATO = Utility::fixDateFormat($result['FUNKFRA']);
if (isset($result['FUNKTIL']) == false) {
$this->logger->log($this->XMLfilename, "UM_PNID (" . $result['PNID'] . ") is mising UM_TILDATO. This is fine accodring to DTD but arkn4 seems to require it. Setting UM_TILDATO to " . Utility::fixDateFormat(Constants::DATE_AUTO_END), Constants::LOG_WARNING);
$this->warningIssued = true;
$utvMedl->UM_TILDATO = Utility::fixDateFormat(Constants::DATE_AUTO_END);
} else {
$utvMedl->UM_TILDATO = Utility::fixDateFormat($result['FUNKTIL']);
}
$utvMedl->UM_FUNK = $result['FUNKSJON'];
$utvMedl->UM_RANGERING = '0';
$this->logger->log($this->XMLfilename, "UM.RANGERING has no value, setting to 0 for UM_PNID (" . $utvMedl->UM_PNID . ")", Constants::LOG_WARNING);
$this->warningIssued = true;
$utvMedl->UM_SORT = $result['NR'];
$this->logger->log($this->XMLfilename, "Non mandatory field UM.REPRES is not linked on ADRID for UTVID( " . $utvMedl->UM_UTVID . "), PNID (" . $utvMedl->UM_PNID . "). Value from ESA is " . $result['REPPARTI'], Constants::LOG_WARNING);
$utvMedl->UM_MERKNAD = $result['MERKNAD'];
$utvMedl->UM_VARAFOR = $result['VARAPERSON'];
if (is_null($result['VARAPERSON']) == true) {
$queryGetPNID = "select PNID from dgjhutvmedlem where adrid = '" . $result['ADRID'] . "' AND utvid = '" . $utvMedl->UM_UTVID . "'";
$this->srcBase->createAndExecuteQuery($queryGetPNID);
$pnidResult = $this->srcBase->getQueryResult($queryGetPNID);
$utvMedl->UM_VARAFOR = $pnidResult['PNID'];
$this->srcBase->endQuery($queryGetPNID);
}
$this->writeToDestination($utvMedl);
}
$this->srcBase->endQuery($this->selectQuery);
}
function processTable()
{
$this->srcBase->createAndExecuteQuery($this->selectQuery);
$arkiv = new Arkiv();
$arkiv->AR_ARKIV = "RNG";
$arkiv->AR_BETEGN = "RINGPERM added RINGPERM ARKIVDEL. Added so that structure is correct the extracttion.";
$arkiv->AR_NUMSER = '1';
$arkiv->AR_FRADATO = Utility::fixDateFormat(Constants::DATE_AUTO_START);
$arkiv->AR_TILDATO = Utility::fixDateFormat(Constants::DATE_AUTO_END);
$this->logger->log($this->XMLfilename, "Creating an AR_ARKIV (" . $arkiv->AR_ARKIV . ") to handle an ARKIVDEL called RINGPERM that is missing a reference to ARKIV. Setting AR.FRADATO to Constants::DATE_AUTO_START which has value (" . Utility::fixDateFormat(Constants::DATE_AUTO_START) . ") Setting AR.TILDATO to Constants::DATE_AUTO_END which has value (" . Utility::fixDateFormat(Constants::DATE_AUTO_END) . ")", Constants::LOG_WARNING);
$this->warningIssued = true;
$this->logger->log($this->XMLfilename, "AR_ARKIV (" . $arkiv->AR_ARKIV . ") has null value for AR.TILDATO. Setting AR.TILDATO to Constants::DATE_AUTO_END which has value (" . Constants::DATE_AUTO_END . ")", Constants::LOG_WARNING);
$this->warningIssued = true;
$this->writeToDestination($arkiv);
while ($result = $this->srcBase->getQueryResult($this->selectQuery)) {
$arkiv = new Arkiv();
$arkiv->AR_ARKIV = $result['ARKIV'];
$arkiv->AR_BETEGN = $result['BESKRIVELSE'];
// TODO : VERY IMPORTANT CHECK NUMSER
$arkiv->AR_NUMSER = '1';
$arkiv->AR_FRADATO = Utility::fixDateFormat($result['FRADATO']);
if (isset($result['TILDATO']) == true) {
$arkiv->AR_TILDATO = Utility::fixDateFormat($result['TILDATO']);
} else {
$arkiv->AR_TILDATO = Utility::fixDateFormat(Constants::DATE_AUTO_END);
$this->logger->log($this->XMLfilename, "AR_ARKIV (" . $result['ARKIV'] . ") has null value for AR.TILDATO. Setting AR.TILDATO to Constants::DATE_AUTO_END which has value (" . Constants::DATE_AUTO_END . ")", Constants::LOG_WARNING);
$this->warningIssued = true;
}
$arkiv->AR_MERKNAD = $result['MERKNAD'];
$this->writeToDestination($arkiv);
}
$this->srcBase->endQuery($this->selectQuery);
}
function processTable()
{
$this->srcBase->createAndExecuteQuery($this->selectQuery);
while ($result = $this->srcBase->getQueryResult($this->selectQuery)) {
$polSakG = new Polsakg();
$polSakG->SG_ID = $result['JOURAARNR'];
$polSakG->SG_SAID = $result['JOURAARNR'];
$polSakG->SG_SAKSTYPE = $result['BEHTYPE'];
if (is_null($result['KLAGE'])) {
$polSakG->SG_KLADGANG = '0';
$this->logger->log($this->XMLfilename, "SG_KLADGANG is null, assuming 0 (åpen) for POLSAKG with SAID " . $polSakG->SG_SAID, Constants::LOG_INFO);
} else {
if (strcmp($result['KLAGE'], 'J')) {
$polSakG->SG_KLADGANG = '1';
} else {
if (strcmp($result['KLAGE'], 'N')) {
$polSakG->SG_KLADGANG = '0';
} else {
$polSakG->SG_KLADGANG = '0';
$this->logger->log($this->XMLfilename, "SG_KLADGANG has unknown value, assuming 0 (åpen) for POLSAKG with SAID " . $polSakG->SG_SAID . " Unknown value is " . $result['KLAGE'], Constants::LOG_ERROR);
}
}
}
$polSakG->SG_LUKKET = $result['LUKKET'];
if (is_null($result['LUKKET'])) {
$polSakG->SG_LUKKET = '0';
$this->logger->log($this->XMLfilename, "SG_LUKKET is null, assuming 0 (åpen) for POLSAKG with SAID " . $polSakG->SG_SAID, Constants::LOG_INFO);
if (is_null($result['HJEMMEL'] == false)) {
$polSakG->SG_LUKKET = '1';
$this->logger->log($this->XMLfilename, "SG_LUKKET is null, but has UOFF value, assigning to 1 for POLSAKG with SAID " . $polSakG->SG_SAID, Constants::LOG_INFO);
}
} else {
if (strcmp($result['LUKKET'], 'Å')) {
$polSakG->SG_LUKKET = '0';
} else {
if (strcmp($result['LUKKET'], 'L')) {
$polSakG->SG_LUKKET = '1';
} else {
$polSakG->SG_LUKKET = '0';
$this->logger->log($this->XMLfilename, "SG_LUKKET has unknown value, assuming 0 (åpen) for POLSAKG with SAID " . $polSakG->SG_SAID . " Unknown value is " . $result['LUKKET'], Constants::LOG_ERROR);
}
}
}
$polSakG->SG_UOFF = $result['HJEMMEL'];
$polSakG->SG_STARTDATO = Utility::fixDateFormat($result['AAPNET']);
$polSakG->SG_VEDTDATO = Utility::fixDateFormat($result['AVSLUTTET']);
//$polSakG->SG_SISTEVEDT = Utility::fixDateFormat($result['AVSLUTTET']);
$polSakG->SG_MERKNAD = $result['MERKNAD'];
$this->writeToDestination($polSakG);
}
$this->srcBase->endQuery($this->selectQuery);
}
function processUtvMoteDok($utvID, $moID, $sakID)
{
$selectJPQuery = "SELECT DOKKAT, DOKODE, REGDATO, STATUS, EKODE1, PAPIR, INNH1, U1, ADMID, SBHID, UNNTOFF, GRUPPEID, HJEMMEL FROM DGJMJO WHERE JOURAARNR = '" . $sakID . "'";
$this->srcBase->createAndExecuteQuery($selectJPQuery);
while ($result = $this->srcBase->getQueryResult($selectJPQuery)) {
$utvMoteDok = new UtvMoteDok();
$this->docCounter++;
$utvMoteDok->MD_ID = $this->docCounter;
// auto-increment, starts at 1
$utvMoteDok->MD_UTVID = $utvID;
// dgmamo.utvid
$utvMoteDok->MD_MOID = $moID;
// dgmamo.id
$utvMoteDok->MD_DOKTYPE = $result['DOKODE'];
// dgjmjo.dokkat
$utvMoteDok->MD_REGDATO = Utility::fixDateFormat($result['REGDATO']);
// dgjmjo.regdato
$utvMoteDok->MD_STATUS = $result['STATUS'];
// dgjmjo.status
$utvMoteDok->MD_ARKKODE = $result['EKODE1'];
// dgjmjo.ekode1 / AVGRADER???
$utvMoteDok->MD_PAPIRDOK = $result['PAPIR'];
// dgjmjo.papir checklogic
$utvMoteDok->MD_INNHOLD = $result['INNH1'];
//dgjmjo.innh1
$utvMoteDok->MD_U1 = $result['U1'];
// //dgjmjo.innh1
$utvMoteDok->MD_ADMID = $result['ADMID'];
//dgjmjo.admid
$utvMoteDok->MD_SBHID = $result['SBHID'];
// dgjmjo.sbhid
$utvMoteDok->MD_TGKODE = $result['UNNTOFF'];
// dgjmjo
$utvMoteDok->MD_TGGRUPPE = $result['GRUPPEID'];
// dgjmjo
$utvMoteDok->MD_UOFF = $result['HJEMMEL'];
//
// The follwing could be implemented but will need a call to SAK/DGSMSA
// From what I can tell from inspection, these fields have no value / are null
//$utvMoteDok->MD_AGDATO = $result['']; //
//$utvMoteDok->MD_AGKODE = $result['']; //
//$utvMoteDok->MD_KASSDATO = $result['']; //
//$utvMoteDok->MD_KASSKODE = $result['']; //
// This seems to be missing from the database, but not sure
//$utvMoteDok->MD_BEVTID = $result['']; //
$this->writeToDestination($utvMoteDok);
}
$this->srcBase->endQuery($selectJPQuery);
}
function processTable()
{
$this->srcBase->createAndExecuteQuery($this->selectQuery);
$arkivDel = new ArkivDel();
$arkivDel->AD_ARKDEL = 'GB';
$arkivDel->AD_BETEGN = 'Added because we are missing an arkivdel called GB';
$arkivDel->AD_ARKIV = 'GBKF';
$arkivDel->AD_ASTATUS = 'A';
$arkivDel->AD_PRIMNOK = 'GB';
$arkivDel->AD_PERIODE = null;
$arkivDel->AD_PAPIR = '1';
$arkivDel->AD_ELDOK = '1';
$arkivDel->AD_FRADATO = '19981201';
$arkivDel->AD_TILDATO = '20081219';
//06-JAN-06
$this->writeToDestination($arkivDel);
$this->logger->log($this->XMLfilename, "AD_ARKDEL (" . $arkivDel->AD_ARKDEL . ") is not in ARKIVDEL but has cases in NOARKSAK. Added here ", Constants::LOG_WARNING);
$this->warningIssued = true;
while ($result = $this->srcBase->getQueryResult($this->selectQuery)) {
$arkivDel = new ArkivDel();
$arkivDel->AD_ARKDEL = $result['FYSARK'];
$arkivDel->AD_BETEGN = $result['BESKRIVELSE'];
$arkivDel->AD_ARKIV = $result['ARKIV'];
if ($result['ARKIV'] == null) {
$arkivDel->AD_ARKIV = 'RNG';
$this->logger->log($this->XMLfilename, "AD_ARKDEL (" . $arkivDel->AD_ARKDEL . ") has no link to ARKIV. Adding it to AD_ARKIV(" . $arkivDel->AD_ARKIV . ")", Constants::LOG_WARNING);
$this->warningIssued = true;
}
$arkivDel->AD_PERIODE = $result['PERIODE'];
$arkivDel->AD_ASTATUS = $result['ASTATUS'];
$arkivDel->AD_PRIMNOK = $result['PRIMNOK'];
if ($result['PRIMNOK'] == null) {
$arkivDel->AD_PRIMNOK = 'FE';
$this->logger->log($this->XMLfilename, "PRIMNOK has null value. Setting it to FE " . $arkivDel->AD_ARKDEL, Constants::LOG_WARNING);
$this->warningIssued = true;
}
$arkivDel->AD_BSKODE = $result['BSKODE'];
$arkivDel->AD_FORTS = $result['FORTS'];
$arkivDel->AD_PAPIR = $result['PAPIR'];
$arkivDel->AD_ELDOK = $result['ELDOK'];
$arkivDel->AD_FRADATO = Utility::fixDateFormat($result['FRADATO']);
$arkivDel->AD_TILDATO = Utility::fixDateFormat($result['TILDATO']);
$arkivDel->AD_MERKNAD = $result['MERKNAD'];
$this->writeToDestination($arkivDel);
}
$this->srcBase->endQuery($this->selectQuery);
}
function processTable()
{
$this->srcBase->createAndExecuteQuery($this->selectQuery);
while ($result = $this->srcBase->getQueryResult($this->selectQuery)) {
$perRolle = new PerRolle();
$perRolle->PR_ID = $result['ID'];
$perRolle->PR_PEID = $result['PEID'];
$perRolle->PR_STDROLLE = $result['STDROLLE'];
$perRolle->PR_TITTEL = $result['TITTEL'];
$perRolle->PR_ADMID = $result['ADMID'];
$perRolle->PR_JENHET = $result['JOURENHET'];
$perRolle->PR_ARKDEL = $result['FYSARK'];
$perRolle->PE_FRADATO = Utility::fixDateFormat($result['DATO']);
$perRolle->PE_TILDATO = Utility::fixDateFormat($result['TILDATO']);
$this->writeToDestination($perRolle);
}
$this->srcBase->endQuery($this->selectQuery);
}
function processTable()
{
$this->srcBase->createAndExecuteQuery($this->selectQuery);
while ($result = $this->srcBase->getQueryResult($this->selectQuery)) {
$tillegg = new Tillegg();
$tillegg->TI_ID = $result['ID'];
$tillegg->TI_SAID = $result['JOURAARNR'];
$tillegg->TI_JPID = $result['REFAARNR'];
$tillegg->TI_DOKID = $result['DOKID'];
$tillegg->TI_DOKVER = $result['FILNR'];
$tillegg->TI_VARIANT = $result['VARIANT'];
$tillegg->TI_ITYPE = $result['ITYPE'];
$tillegg->TI_REGDATO = $result['TIDSPKT'];
$tillegg->TI_REGAV = $result['PNID'];
$tillegg->TI_TEKST = mysql_real_escape_string($result['INFO']);
$this->writeToDestination($tillegg);
}
$this->srcBase->endQuery($this->selectQuery);
$dgtilleggsinfoSQL = "select ID, JOURAARNR, REFAARNR, DOKID, FILNR, VARIANT, RNR, ITYPE, UNNTOFF, GRUPPEID, REGDATO, REGAV, PVGAV, TEKST FROM DGTILLEGGSINFO";
// There is a a table called "DGTILLEGGSINFO" that might also contain information to b eextracted
$this->srcBase->createAndExecuteQuery($dgtilleggsinfoSQL);
while ($result = $this->srcBase->getQueryResult($dgtilleggsinfoSQL)) {
$tillegg = new Tillegg();
$tillegg->TI_ID = $result['ID'];
$tillegg->TI_SAID = $result['JOURAARNR'];
$tillegg->TI_JPID = $result['REFAARNR'];
$tillegg->TI_DOKID = $result['DOKID'];
$tillegg->TI_DOKVER = $result['FILNR'];
$tillegg->TI_VARIANT = $result['VARIANT'];
$tillegg->TI_RNR = $result['RNR'];
$tillegg->TI_ITYPE = $result['ITYPE'];
$tillegg->TI_TGKODE = $result['UNNTOFF'];
$tillegg->TI_TGGRUPPE = $result['GRUPPEID'];
$tillegg->TI_REGDATO = Utility::fixDateFormat($result['REGDATO']);
$tillegg->TI_REGAV = $result['REGAV'];
$tillegg->TI_PVGAV = $result['PVGAV'];
$tillegg->TI_TEKST = $result['TEKST'];
$this->writeToDestination($tillegg);
}
$this->srcBase->endQuery($dgtilleggsinfoSQL);
}
function processTable()
{
$this->srcBase->createAndExecuteQuery($this->selectQuery);
// Added 0 user to help process TGGRP where OPPRAV is set to null
$person0 = new Person();
$person0->PE_ID = Constants::INGENBRUKER_ID;
$person0->PE_BRUKERID = 'ikke angitt';
$this->writeToDestination($person0);
/*
COMMENTED THIS OUT BUT MIGHT NEED IT. ADDING USER AS 1 INSTEAD, HARDCODED ELSEWHERE!!
// I want to distingush between a NO USER and UTTREKKSBRUKER that actually has created all the PDF/A files
// When creating DOKVERS we need to identify who created this version and we identify UTTREKKSBRUKER as that person
$sqlMaxPersonID = "select MAX(PEID) TYPE FROM PERSONER";
$result = $this->srcBase->getQueryResult ($sqlMaxPersonID);
if ($result == null) {
echo "Unable to get an answer for select MAX(PEID) TYPE FROM PERSONER \n";
}
$maxPEID = $result['TYPE'];
$maxPEID = $maxPEID + 100;
echo "Setting UTTREKSSBRUKER PEID to " . $maxPEID . "\n";
$this->srcBase->endQuery($sqlMaxPersonID);
$person0 = new Person();
$person0->PE_ID = $maxPEID;
*/
$person0 = new Person();
$person0->PE_ID = Constants::UTTREKSBRUKER_ID;
$person0->PE_BRUKERID = 'UTTREKSBRUKER';
$this->writeToDestination($person0);
while ($result = $this->srcBase->getQueryResult($this->selectQuery)) {
$person = new Person();
$person->PE_ID = $result['PEID'];
$person->PE_BRUKERID = $result['INITIALER'];
$person->PE_FRADATO = Utility::fixDateFormat($result['DATO']);
$person->PE_TILDATO = Utility::fixDateFormat($result['TILDATO']);
$this->writeToDestination($person);
}
$this->srcBase->endQuery($this->selectQuery);
}
function processTable()
{
$ordnpri = new OrdnPri();
$ordnpri->OP_ORDNPRI = 'EM';
$ordnpri->OP_BETEGN = 'Elevmappe';
$ordnpri->OP_LTEKST = 'Added at extraction';
$ordnpri->OP_TYPE = 'UO';
$ordnpri->OP_OVBESK = '0';
$ordnpri->OP_KLFLAGG = '1';
$ordnpri->OP_SIFLAGG = '1';
$ordnpri->OP_EVOK = '1';
$ordnpri->OP_EVAUTO = '0';
$ordnpri->OP_SEKFLAGG = '1';
$this->logger->log($this->XMLfilename, "Mising EM in ORDNPRO. Added here", Constants::LOG_WARNING);
$this->warningIssued = true;
$this->writeToDestination($ordnpri);
$this->srcBase->createAndExecuteQuery($this->selectQuery);
while ($result = $this->srcBase->getQueryResult($this->selectQuery)) {
$ordnpri = new OrdnPri();
$ordnpri->OP_ORDNPRI = $result['OTYPE'];
$ordnpri->OP_BETEGN = $result['OBJKTEXT'];
$ordnpri->OP_LTEKST = $result['LTEKST'];
$ordnpri->OP_TYPE = $result['OPTYPE'];
$ordnpri->OP_OVBESK = $result['OVBESK'];
$ordnpri->OP_KLFLAGG = $result['KLFLAGG'];
// Note this is being set to 1 even though I am not sure it should be
$ordnpri->OP_SIFLAGG = '1';
$ordnpri->OP_EVOK = $result['EVOK'];
$ordnpri->OP_EVAUTO = $result['EVAUTO'];
$ordnpri->OP_SEKFLAGG = $result['SEKFLAGG'];
// $ordnpri->OP_FRADATO = Utility::fixDateFormat($result['FRADATO']);
$ordnpri->OP_TILDATO = Utility::fixDateFormat($result['TILDATO']);
$ordnpri->OP_TGKODE = $result['UNNTOFF'];
$this->logger->log($this->XMLfilename, "SI_FLAGG has no value for " . $ordnpri->OP_ORDNPRI . " setting it to '1'", Constants::LOG_WARNING);
$this->warningIssued = true;
$this->writeToDestination($ordnpri);
}
$this->srcBase->endQuery($this->selectQuery);
}
function processTable()
{
$this->srcBase->createAndExecuteQuery($this->selectQuery);
while ($result = $this->srcBase->getQueryResult($this->selectQuery)) {
$merknad = new Merknad();
$merknad->ME_ID = $result['NOKKEL'] . $result['KOMNR'];
if (!strcmp($result['REGISTER'], "S")) {
$merknad->ME_SAID = $result['NOKKEL'];
} else {
if (!strcmp($result['REGISTER'], "J")) {
$merknad->ME_JPID = $result['NOKKEL'];
} else {
if (!strcmp($result['REGISTER'], "D")) {
$merknad->ME_DOKID = $result['NOKKEL'];
} else {
//die ("Unknown REGISTER value (" . $result['REGISTER'] . ") in " . $SRC_TABLE_NAME);
}
}
}
$merknad->ME_RNR = $result['KOMNR'];
$merknad->ME_ITYPE = $result['ITYPE'];
$merknad->ME_TGKODE = $result['UNNTOFF'];
$merknad->ME_TGGRUPPE = $result['GRUPPEID'];
$merknad->ME_TEKST = $result['KOMMENTAR'];
$merknad->ME_REGAV = $result['SBHID'];
if (isset($result['PVGAV']) == true) {
$merknad->ME_PVGAV = $result['PVGAV'];
} else {
$merknad->ME_PVGAV = '0';
// Not something in ESA, so this should be OK
$this->logger->log($this->XMLfilename, "MERKNAD ME.ID (" . $merknad->ME_ID . ") has null for ME_PVGAV. Setting it to 0", Constants::LOG_WARNING);
$this->warningIssued = true;
}
$merknad->ME_REGDATO = Utility::fixDateFormat($result['ENDRDATO']);
$this->writeToDestination($merknad);
}
$this->srcBase->endQuery($this->selectQuery);
}
function processTable()
{
$this->srcBase->createAndExecuteQuery($this->selectQuery);
while ($result = $this->srcBase->getQueryResult($this->selectQuery)) {
$utvMote = new UtvMote();
$utvMote->MO_ID = $result['ID'];
$utvMote->MO_NR = $result['MOTENR'];
if (isset($result['UTVID']) == false) {
$utvMote->MO_UTVID = '0';
$this->logger->log($this->XMLfilename, "MO.ID (" . $utvMote->MO_ID . ") has null value for MO_UTVID. Setting MO_UTVID to 0" . $utvMote->MO_ID, Constants::LOG_WARNING);
$this->warningIssued = true;
} else {
$utvMote->MO_UTVID = $result['UTVID'];
}
if (strcmp($result['LUKKET'], 'Å') == 0) {
$utvMote->MO_LUKKET = '1';
} else {
if (strcmp($result['LUKKET'], 'L') == 0) {
$utvMote->MO_LUKKET = '0';
} else {
if (strcmp($result['LUKKET'], 'S') == 0) {
$this->logger->log($this->XMLfilename, "MO.LUKKET has unknown value (S), assuming S == 1 for " . $utvMote->MO_ID, Constants::LOG_WARNING);
$this->warningIssued = true;
$utvMote->MO_LUKKET = '1';
} else {
$this->logger->log($this->XMLfilename, "MO.LUKKET has unknown value (" . $result['LUKKET'] . "), setting to 1 for " . $utvMote->MO_ID, Constants::LOG_WARNING);
$this->warningIssued = true;
$utvMote->MO_LUKKET = '1';
}
}
}
$utvMote->MO_DATO = Utility::fixDateFormat($result['MOTEDATO']);
$this->utvMoteDokDAO->processUtvMoteDok($utvMote->MO_UTVID, $utvMote->MO_ID, $result['JOURAARNR']);
$this->writeToDestination($utvMote);
}
$this->srcBase->endQuery($this->selectQuery);
}
function createDokLink($journPst, $rnr, $dlType, $dokDetails)
{
//print_r($dokDetails);
$dokLink = new DokLink();
$dokLink->DL_JPID = $journPst->JP_ID;
$dokLink->DL_RNR = $rnr;
$dokLink->DL_DOKID = $dokDetails['DOKID'];
$dokLink->DL_TYPE = $dlType;
$dokLink->DL_TKDATO = Utility::fixDateFormat($dokDetails['OPPRETTETDATO']);
if (is_null($dokDetails['OPPRETTETAVID'])) {
$dokLink->DL_TKAV = Constants::INGENBRUKER_ID;
$this->logger->log($this->XMLfilename, "DOKLINK DL_JPID(" . $dokLink->DL_JPID . "), DL_DOKID (" . $dokLink->DL_DOKID . ") has no DL_TKAV value. Set to nouser (" . Constants::INGENBRUKER_ID . " however it is likely this is probably the same as NOARKSAK(SA.ANSVID) ", Constants::LOG_WARNING);
$this->warningIssued = true;
} else {
$dokLink->DL_TKAV = $dokDetails['OPPRETTETAVID'];
}
$this->writeToDestination($dokLink);
}
function processTable()
{
// TODO: ER INNH1 = Tittel og INNH2 = offentlig Tittel?
// U1=1 for 5 6 7, U1 = null for 8 9 10 11
$this->srcBase->createAndExecuteQuery($this->selectQuery);
$counter = 1;
while ($result = $this->srcBase->getQueryResult($this->selectQuery)) {
$noarkSak = new NoarkSak();
$noarkSak->SA_ID = $result['JOURAARNR'];
$noarkSak->SA_SAAR = $result['JOURAAR'];
$noarkSak->SA_SEKNR = $result['JOURNR'];
$noarkSak->SA_PAPIR = $result['PAPIR'];
$noarkSak->SA_DATO = Utility::fixDateFormat($result['AAPNET']);
// Here update ORDNVRD table
$noarkSak->SA_TITTEL = addslashes($result['INNH1']);
if ($result['U1'] == null) {
// TODO: srcBasen bruker null der Noark bruker 0
$noarkSak->SA_U1 = 0;
} else {
$noarkSak->SA_U1 = $result['U1'];
}
// TODO: 'A' og 'B' verdier, hvilke verdier kan det være
$noarkSak->SA_STATUS = $result['STATUS'];
// TODO: FRAARKDEL er altid null men skal avleveres, er dette noe som må settes manuelt
// dvs at det er kun en arkivdel i denne basen?
// Tabellen arkivdel og ARKIVDEL.XML DTD må da også lages
//$noarkSak->SA_ARKDEL = $result['FRAARKDEL'];
// TODO: Alle SAKTYPE er == STD,
// SAKART har STD, MOT
// Tabellen Sakstype og SAKTYPE.XML/DTD må lages
// If this is a møtemappe then we create all UTVMOTEDOK from this
if (strcasecmp($result['SAKART'], "MOT") == 0) {
}
$noarkSak->SA_TYPE = substr($result['SAKTYPE'] . $result['SAKART'], 0, 10);
// TODO: Alle JOURENHET == null
// Tabellen Jourenhet og JOURNENH.XML/DTD må lages
$noarkSak->SA_JENHET = $result['JOURENHET'];
// Tror dette er OTYPE
// EM == Emnebasert??
// GB == Grunnbok?
// Navn
// FD
// null ?? Det er 20507 som er == null, 37064 totalt
// $noarkSak->SA_OPSAKSDEL = $result['OTYPE'];
// Verdier 116, 120, 115, 107, 110, 105, 114, 111, 121, 113
// Jeg er sikker på at det er en tabell som matcher disse
// Er dette AVD? Verdier her er KL, NN, FT
if (isset($result['ADMID']) == true) {
$noarkSak->SA_ADMID = $result['ADMID'];
} else {
$this->logger->log($this->XMLfilename, "For SA.ID(" . $result['JOURAARNR'] . ") is null. ADMID is set to " . Constants::ADMININDEL_TOPNIVA . ")", Constants::LOG_WARNING);
$this->warningIssued = true;
$noarkSak->SA_ADMID = Constants::ADMININDEL_TOPNIVA;
}
// SBHID, 19 forskjellige saksbehandlere men også 194 tupler med null
if (strcmp($result['FYSARK'], 'ELEV-GV') == 0) {
$noarkSak->SA_ARKDEL = 'ELEV-GVO';
$this->logger->log($this->XMLfilename, "For SA.ID(" . $result['JOURAARNR'] . ") it is known that 3 SAKER have wrong SA_ARKDEL. Value in src db was ELEV-GV, but is in fact ELEV-GVO. Confirmed by checking JOURENHET and AVD in src db)", Constants::LOG_WARNING);
$this->warningIssued = true;
} else {
$noarkSak->SA_ARKDEL = $result['FYSARK'];
}
if (isset($result['SBHID']) == true) {
$noarkSak->SA_ANSVID = $result['SBHID'];
} else {
$noarkSak->SA_ANSVID = Constants::INGENBRUKER_ID;
$this->logger->log($this->XMLfilename, "SA_ANSVID for SA. ID(" . $result['JOURAARNR'] . ") is null Value mandatory, set to PERSON NOUSER Value (" . Constants::INGENBRUKER_ID . ")", Constants::LOG_WARNING);
$this->warningIssued = true;
}
// TODO: usikker hvor den får verdien, men er heller ikke obligatorisk, spørs om vi har dette i basen. Se også $noarkSak->SA_TGGRUPPE
$noarkSak->SA_TGKODE = $result['UNNTOFF'];
$noarkSak->SA_UOFF = $result['HJEMMEL'];
// TODO: Dette er noe som ikke er i basen tror jeg, se også $noarkSak->SA_TGKODE
//$noarkSak->SA_TGGRUPPE = $result[''];
// Tror vi blir nødt til å slå opp JP tabellen for å hente disse verdiene
// TODO: Er dette det samme som SAK siste endret dato eller er jeg nødt til å sjekke JPOST tabellen?
// VIKTIG å sjekke dette og ikke anta det!!! SISTEDOK, AGDATO, OVDATO
//$noarkSak->SA_SISTEJP = $result[''];
$noarkSak->SA_ANTJP = 0;
//$result[''];
// Usikker på denne men det er Antall år saken skal oppbeprotectedes før kassasjon eller annen aksjon i henhold til kassasjonskoden skal foretas.
// Basen har en BEVTID men de er alle null
// TODO: Se her
$noarkSak->SA_BEVTID = 0;
//$result[''];
// It appears that ESA has some merknad as part of a sak. These have to copied to MERKNAD
$nokkel = $noarkSak->SA_ID;
$untoff = $noarkSak->SA_TGKODE;
$gruppeId = $noarkSak->SA_TGGRUPPE;
$merknad = $result['MERKNAD'];
$sbhId = $noarkSak->SA_ANSVID;
$noarkSak->SA_ANTJP = $this->getNumberJP($noarkSak->SA_ID);
// This is where you are. fixing this->ordVerdDAO->addOrdnVerdi($ordPrinsipp, $ordVerdi, $ordBeskrivelse);
// yo ucn pick up some values OTYPE e.g GB/
// Not all OTYPE are registered. EM/SA e.g so yo will need to manually add these to ORDPRINSIPP
/* $ordPrinsipp = "DUMMY";
$ordVerdi = "DUMMY";
$ordBeskrivelse = "DUMMY";
$this->ordVerdDAO->addOrdnVerdi($ordPrinsipp, $ordVerdi, $ordBeskrivelse);
*/
$this->writeToDestination($noarkSak);
$register = "S";
// echo "NOARKSAK ID is " . $noarkSak->SA_ID . "\n";
if (isset($merknad) == true) {
$this->merknadDAO->processMerknadFromSakOrJP($register, $nokkel, $untoff, $gruppeId, $merknad, $sbhId);
}
if ($counter++ % Constants::DOT_MARKER_COUNT == 0) {
echo ".";
}
}
$this->srcBase->endQuery($this->selectQuery);
}
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);
}
