PHP Utility::fixDateFormat方法代码示例

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