App\Console\Commands\MigrateDatabaseCommand::migrateCustomers()

Complexity

Conditions	10
Paths	512

Size

Total Lines	123
Code Lines	75

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    protected function migrateCustomers()
    {
        $this->info('Migrating Customers');

        //  Migrate the primary customer information
        $customers = DB::select('SELECT * FROM `'.$this->database.'_old`.`customers`');

        //  Temporarily disable all foreign keys
        DB::statement('SET FOREIGN_KEY_CHECKS=0');

        foreach($customers as $cust)
        {
            $this->line('Adding Customer '.$cust->name);
            DB::table('customers')->insert([
                'cust_id'    => $cust->cust_id,
                'parent_id'  => $cust->parent_id,
                'name'       => $cust->name,
                'dba_name'   => $cust->dba_name,
                'slug'       => STR::slug($cust->name),
                'address'    => $cust->address,
                'city'       => $cust->city,
                'state'      => $cust->state,
                'zip'        => $cust->zip,
                'deleted_at' => $cust->deleted_at,
                'created_at' => $cust->created_at,
                'updated_at' => $cust->updated_at,
            ]);
        }

        //  Re-enable all foreign keys
        DB::statement('SET FOREIGN_KEY_CHECKS=1');
        $this->newLine();

        //  Migrate customer equipment
        $this->line('Adding Customer Equipment');
        $oldEquip = DB::select('SELECT * FROM `'.$this->database.'_old`.`customer_systems`');
        foreach($oldEquip as $equip)
        {
            DB::table('customer_equipment')->insert([
                'cust_equip_id' => $equip->cust_sys_id,
                'cust_id'       => $equip->cust_id,
                'equip_id'      => $equip->sys_id,
                'shared'        => $equip->shared,
                'deleted_at'    => $equip->deleted_at,
                'created_at'    => $equip->created_at,
                'updated_at'    => $equip->updated_at,
            ]);
        }

        //  Migrate customer equipment data
        $this->line('Adding Customer Equipment Data');
        $oldData = DB::select('SELECT * FROM `'.$this->database.'_old`.`customer_system_data`');
        foreach($oldData as $data)
        {
            DB::table('customer_equipment_data')->insert([
                'cust_equip_id' => $data->cust_sys_id,
                'field_id'      => $data->field_id,
                'value'         => $data->value,
                'created_at'    => $data->created_at,
                'updated_at'    => $data->updated_at,
            ]);
        }

        //  Migrate Customer Contacts
        $this->line('Adding Customer Contacts');
        $oldCont = DB::select('SELECT * FROM `'.$this->database.'_old`.`customer_contacts`');
        foreach($oldCont as $cont)
        {
            DB::table('customer_contacts')->insert((array) $cont);
        }

        //  Migrate Customer Contact Phone Numbers
        $oldPhone = DB::select('SELECT * FROM `'.$this->database.'_old`.`customer_contact_phones`');
        foreach($oldPhone as $phone)
        {
            DB::table('customer_contact_phones')->insert((array) $phone);
        }

        //  Migrate Customer File Types
        $this->line('Adding Customer Files');
        DB::statement('DELETE FROM `customer_file_types` WHERE `description` IS NOT NULL');
        $fileTypes = DB::select('SELECT * FROM `'.$this->database.'_old`.`customer_file_types`');
        foreach($fileTypes as $type)
        {
            DB::table('customer_file_types')->insert((array) $type);
        }

        //  Migrate Customer Files
        $oldFiles = DB::select('SELECT * FROM `'.$this->database.'_old`.`customer_files`');
        foreach($oldFiles as $file)
        {
            DB::table('customer_files')->insert((array) $file);
        }

        //  Migrate Customer Notes
        $this->line('Adding Customer Notes');
        $oldNotes = DB::select('SELECT * FROM `'.$this->database.'_old`.`customer_notes`');
        foreach($oldNotes as $note)
        {
            DB::table('customer_notes')->insert([
                'note_id'    => $note->note_id,
                'cust_id'    => $note->cust_id,
                'created_by' => $note->user_id,
                'updated_by' => null,
                'urgent'     => $note->urgent,
                'shared'     => $note->shared,
                'subject'    => $note->subject,
                'details'    => $note->description,
                'deleted_at' => null,
                'created_at' => $note->created_at,
                'updated_at' => $note->updated_at,
            ]);
        }

        //  Migrate Customer Bookmarks
        $this->line('Adding Customer Bookmarks');
        $oldBookmarks = DB::select('SELECT * FROM `'.$this->database.'_old`.`customer_favs`');
        foreach($oldBookmarks as $b)
        {
            DB::table('user_customer_bookmarks')->insert((array) $b);
        }

        $this->newLine();
    }