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); }