Skip to content
Snippets Groups Projects
Normal view Permalink
CopyToDb.php 9.07 KiB
Newer Older
Carsten Rose's avatar
Write all modules
Carsten Rose committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 
<?php

require_once(__DIR__ . '/Constants.php');
require_once(__DIR__ . '/Database.php');


class CopyToDb {

    private $db = null;

    public function __construct() {
        $this->db = new Database(DB_INDEX_DEFAULT);

    }

    /**
     * @param $module
     * @return array
     */
    private function cleanModule($module) {
        foreach ($module as $key => $value) {
            $new[$key] = $value[0] ?? null;
        }
        return ($new);
    }
Carsten Rose's avatar
Module, Event & Termine werden nun geschrieben  
Carsten Rose committed
27 28 29 30 31 32 33 34 
    /**
     * Parse and write all MODULES
     *
     * @param $moduleAll
     * @return void
     * @throws Exception
     */
    private function module($moduleAll) {
Carsten Rose's avatar
Write all modules
Carsten Rose committed
35 36 37 

        print "Copy Module to DB.\n";
        $this->db->sql("TRUNCATE module_tab");
Carsten Rose's avatar
Module, Event & Termine werden nun geschrieben  
Carsten Rose committed
38 39 

        foreach ($moduleAll as $module) {
Carsten Rose's avatar
Write all modules
Carsten Rose committed
40 41 

            $module = $this->cleanModule($module);
Carsten Rose's avatar
Module, Event & Termine werden nun geschrieben  
Carsten Rose committed
42 43 44 45 46 47 48 
            $this->db->sql("INSERT INTO module_tab
             
                           (`otype`,`objid`,`langu`,`short`,`stext`,`sm_category`,`buchbar`,`valid_begda`,
                           `valid_endda`,`cancel_begda`,`cancel_endda`,`cpmax`,`vvz_url`,`vb_tab`,`diszip_tab`)
                            
                           VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)", ROW_REGULAR,
Carsten Rose's avatar
Write all modules
Carsten Rose committed
49 50 51 52 53 54 
                [$module['OTYPE'] ?? '', $module['OBJID'] ?? '', $module['LANGU'] ?? '', $module['SHORT'] ?? '',
                    $module['STEXT'] ?? '', $module['SM_CATEGORY'] ?? '', $module['BUCHBAR'] ?? '',
                    $module['VALID_BEGDA'] ?? '', $module['VALID_ENDDA'] ?? '', $module['CANCEL_BEGDA'] ?? '',
                    $module['CANCEL_ENDDA'] ?? '', $module['CPMAX'] ?? '', $module['VVZ_URL'] ?? '', 'vb_tab', 'diszip_tab']);
        }
    }
Carsten Rose's avatar
Module, Event & Termine werden nun geschrieben  
Carsten Rose committed
55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 

    /**
     * @param $eventAll
     * @return void
     * @throws Exception
     */
    private function termin($objid, array $terminEvent) {

//        print "Copy Termin to DB.\n";
        foreach ($terminEvent as $termin) {
            $raum ='';
            if (isset($termin['RAUM_TAB'])) {
                if (is_array($termin['RAUM_TAB']['RAUM']??'')) {
                    $raum = $termin['RAUM_TAB']['RAUM'][0];
                }
            }
            $this->db->sql("INSERT INTO termin_tab (`event_objid`,`evdat`,`beguz`,`enduz`,`raum`) VALUES (?,?,?,?,?)"
                , ROW_REGULAR, [$objid, $termin['EVDAT'][0] ?? '', $termin['BEGUZ'][0] ?? '', $termin['ENDUZ'][0] ?? '', $raum]);
        }
    }
bbaer's avatar
added room  
bbaer committed
76
bbaer's avatar
added booking  
bbaer committed
77
Carsten Rose's avatar
Module, Event & Termine werden nun geschrieben  
Carsten Rose committed
78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 
    /**
     * @param $eventAll
     * @return void
     * @throws Exception
     */
    private function event($eventAll) {

        print "Copy Event/Termin/Raum to DB.\n";
        $this->db->sql("TRUNCATE event_tab");
        $this->db->sql("TRUNCATE termin_tab");

        foreach ($eventAll as $event) {
            $this->db->sql("INSERT INTO event_tab (`objid`,`short`,`stext`,`vvz_url`) VALUES (?,?,?,?)"
                , ROW_REGULAR, [$event['OBJID'][0] ?? '', $event['SHORT'][0] ?? '', $event['STEXT'][0] ?? '', $event['VVZ_URL'][0] ?? '']);

            if (isset($event['TERMIN_TAB'])) {
                $this->termin($event['OBJID'][0] , $event['TERMIN_TAB']);
            }
        }
    }
bbaer's avatar
added booking  
bbaer committed
99 100 101 102 103 
    public function eventSingle($event) {
        $this->db->sql("INSERT INTO event_tab (`objid`,`short`,`stext`,`vvz_url`) VALUES (?,?,?,?)"
                , ROW_REGULAR, [$event->OBJID ?? '', $event->SHORT ?? '', $event->STEXT ?? '', $event->VVZ_URL ?? '']);
    }
bbaer's avatar
added person  
bbaer committed
104 105 106 107 108 
    /**
     * @param $personAll
     * @return void
     * @throws Exception
     */
bbaer's avatar
both functions  
bbaer committed
109 
    private function person($personAll) {
bbaer's avatar
added in process  
bbaer committed
110
bbaer's avatar
added person  
bbaer committed
111 
        print "Copy Person to DB." . PHP_EOL;
bbaer's avatar
both functions  
bbaer committed
112 
        $this->db->sql("TRUNCATE person_tab");
bbaer's avatar
added more columns  
bbaer committed
113
bbaer's avatar
both functions  
bbaer committed
114 
        foreach ($personAll as $person) {
bbaer's avatar
typo  
bbaer committed
115 116 
            $this->db->sql("INSERT INTO person_tab (`pernr`, `vname`, `name1`, `itim_short`, `itim_mail`, `email`, `gesch`, `pub_titel`, `titel`, `persk`, `sprsl`, `funktionscode`, `fachrunicode`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)"
                , ROW_REGULAR, [$person['PERNR'][0] ?? '', $person['VNAME'][0] ?? '', $person['NAME1'][0] ?? '', $person['ITIM_SHORT'][0] ?? '', $person['ITIM_MAIL'][0] ?? '', $person['EMAIL'][0] ?? '', $person['GESCH'][0] ?? '', $person['PUB_TITEL'][0] ?? '', $person['TITEL'][0] ?? '', $person['PERSK'][0] ?? '', $person['SPRSL'][0] ?? '', $person['FUNKTIONSCODE'][0] ?? '', $person['FACHRUNICODE'][0] ?? '']);
bbaer's avatar
both functions  
bbaer committed
117 118 119 120 
        }
    }

    public function personSingle($person) {
bbaer's avatar
typo  
bbaer committed
121 
        $this->db->sql("INSERT INTO person_tab (`pernr`, `vname`, `name1`, `itim_short`, `itim_mail`, `email`, `gesch`, `pub_titel`, `titel`, `persk`, `sprsl`, `funktionscode`, `fachrunicode`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)"
bbaer's avatar
proper variables  
bbaer committed
122 
            , ROW_REGULAR, [$person->PERNR ?? '', $person->VNAME ?? '', $person->NAME1 ?? '', $person->ITIM_SHORT ?? '', $person->ITIM_MAIL ?? '', $person->EMAIL ?? '', $person->GESCH ?? 0, $person->PUB_TITEL ?? '', $person->TITEL ?? '', $person->PERSK ?? '', $person->SPRSL ?? '', $person->FUNKTIONSCODE ?? '', $person->FACHRUNICODE ?? '']);
bbaer's avatar
added person  
bbaer committed
123 124 
    }
bbaer's avatar
added eventtype  
bbaer committed
125 126 127 128 129 
    private function eventType($eventTypeAll) {
        print "Copy Event Types to DB." . PHP_EOL;
        $this->db->sql("TRUNCATE eventtype_tab");

        foreach ($eventTypeAll as $eventType) {
bbaer's avatar
fixed typo  
bbaer committed
130 
            $this->db->sql("INSERT INTO eventtype_tab (`otype`, `objid`, `langu`, `short`, `stext`, `d_category`, `method`) VALUES (?,?,?,?,?,?,?)"
bbaer's avatar
added eventtype  
bbaer committed
131 132 133 134 135 
                , ROW_REGULAR, [$eventType['OTYPE'][0] ?? '', $eventType['OBJID'][0] ?? '',$eventType['LANGU'][0] ?? '', $eventType['SHORT'][0] ?? '', $eventType['STEXT'][0] ?? '',$eventType['D_CATEGORY'][0] ?? '', $eventType['METHOD'][0] ?? '']);
        }
    }

    public function eventTypeSingle($eventType) {
bbaer's avatar
fixed typo  
bbaer committed
136 
        $this->db->sql("INSERT INTO eventtype_tab (`otype`, `objid`, `langu`, `short`, `stext`, `d_category`, `method`) VALUES (?,?,?,?,?,?,?)"
bbaer's avatar
added eventtype  
bbaer committed
137 138 139 
                , ROW_REGULAR, [$eventType->OTYPE ?? '', $eventType->OBJID ?? '',$eventType['LANGU'][0] ?? '', $eventType->SHORT ?? '', $eventType->STEXT ?? '',$eventType['D_CATEGORY'][0] ?? '', $eventType->METHOD ?? '']);
    }
bbaer's avatar
added relation  
bbaer committed
140 141 142 143 144 145 146 147 148 149 
    private function relation($relationAll) {
        print "Copy Relations to DB." . PHP_EOL;
        $this->db->sql("TRUNCATE relation_tab");

        foreach ($relationAll as $relation) {
            $this->db->sql("INSERT INTO relation_tab (`otype`, `objid`, `relat`, `sclas`, `sobid`, `aw_based`) VALUES (?,?,?,?,?,?)"
                , ROW_REGULAR, [$relation['OTYPE'][0] ?? '', $relation['OBJID'][0] ?? '', $relation['RELAT'][0] ?? '', $relation['SCLAS'][0] ?? '', $relation['SOBID'][0] ?? '', $relation['AW_BASED'][0] ?? NULL]);
        }
    }
bbaer's avatar
added relation  
bbaer committed
150 151 152 153 154 
    public function relationSingle($relation) {
        $this->db->sql("INSERT INTO relation_tab (`otype`, `objid`, `relat`, `sclas`, `sobid`, `aw_based`) VALUES (?,?,?,?,?,?)"
                , ROW_REGULAR, [$relation->OTYPE ?? '', $relation->OBJID ?? '', $relation->RELAT ?? '', $relation->SCLAS ?? '', $relation->SOBID ?? '', $relation->AW_BASED ?? NULL]);
    }
bbaer's avatar
added booking  
bbaer committed
155 156 157 158 159 160 
    private function booking($bookingAll) {
        $this->db->sql("TRUNCATE booking_tab");
        $this->db->sql("INSERT INTO room_tab (`otype`, `objid`, `langu`, `short`, `stext`, `kapz1`, `ort01`, `build`, `room1`"
            , ROW_REGULAR, [$room->OTYPE ?? '', $room['OBJID'][0], $room['LANGU'][0] ?? '', $room['SHORT'][0] ?? '', $room['STEXT'][0] ?? '', $room['KAPZ1'][0] ?? 0, $room['ORT01'][0] ?? '', $room['BUILD'][0] ?? '', $room['ROOM1'][0] ?? '']);
    }
bbaer's avatar
added booking  
bbaer committed
161 162 
    public function bookingSingle($booking) {
        $this->db->sql("INSERT INTO booking_tab (`adatanr`, `smstatus`, `cpattemp`, `norm_val`, `bookdate`, `booktime`, `packnumber`, `alt_scaleid`, `id`, `bookreason`, `lockflag`, `cobok`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
bbaer's avatar
defaults for date/time  
bbaer committed
163 
            , ROW_REGULAR, [$booking->ADATANR ?? '', $booking->SMSTATUS ?? '', $booking->CPATTEMP ?? '', $booking->NORM_VAL ?? '', $booking->BOOKDATE ?? '1901-01-01', $booking->BOOKTIME ?? '00:00:00', $booking->PACKNUMBER, $booking->ALT_SCALEID ?? '', $booking->ID ?? '', $booking->BOOKREASON ?? '', $booking->LOCKFLAG ?? '', $booking->COBOK ?? '']);
bbaer's avatar
added booking  
bbaer committed
164 
    }
bbaer's avatar
typo  
bbaer committed
165
bbaer's avatar
added booking  
bbaer committed
166
bbaer's avatar
added room  
bbaer committed
167 168 169 170 171 
    public function roomSingle($room) {
        $this->db->sql("INSERT INTO room_tab (`otype`, `objid`, `langu`, `short`, `stext`, `kapz1`, `ort01`, `build`, `room1`"
            , ROW_REGULAR, [$room->OTYPE ?? '', $room->OBJID, $room->LANGU ?? '', $room->SHORT ?? '', $room->STEXT ?? '', $room->KAPZ1 ?? 0, $room->ORT01 ?? '', $room->BUILD ?? '', $room->ROOM1 ?? '']);
    }
bbaer's avatar
truncate divided, since relation is seperate. bigger chunk size  
bbaer committed
172 173 174 
    public function truncate($target) {
        if ($target == "master") {
            $this->db->sql("TRUNCATE person_tab");
bbaer's avatar
added booking  
bbaer committed
175 
            $this->db->sql("TRUNCATE booking_tab");
bbaer's avatar
added eventtype  
bbaer committed
176 177 
            #$this->db->sql("TRUNCATE room_tab");
            $this->db->sql("TRUNCATE eventtype_tab");
bbaer's avatar
truncate divided, since relation is seperate. bigger chunk size  
bbaer committed
178 179 180 181 
        } else {
            $this->db->sql("TRUNCATE relation_tab");
        }
bbaer's avatar
added relation  
bbaer committed
182 183 
    }
bbaer's avatar
added person  
bbaer committed
184 185 186
Carsten Rose's avatar
Module, Event & Termine werden nun geschrieben  
Carsten Rose committed
187 188 189 190 191 192 193 194 195 
    /**
     * Write Data
     *
     * @param array $fullData
     * @return void
     * @throws Exception
     */
    public function process(array $fullData) {
bbaer's avatar
fixed typo  
bbaer committed
196 197 198 199 200 
        //$this->module($fullData['DATA'][0]['MASTERDATA']['MODULE_TAB']);
        //$this->event($fullData['DATA'][0]['MASTERDATA']['EVENT_TAB']);
        //$this->person($fullData['DATA'][0]['MASTERDATA']['PERSON_TAB']);
        $this->eventType($fullData['DATA'][0]['MASTERDATA']['EVENTTYPE_TAB']);
        //$this->relation($fullData['DATA'][0]['RELATION_TAB']);
Carsten Rose's avatar
Module, Event & Termine werden nun geschrieben  
Carsten Rose committed
201 202 

    }
Carsten Rose's avatar
Write all modules
Carsten Rose committed
203 
}