RelocateSystemFilesToTechTips

Complexity

Total Complexity

4

Size/Duplication

Total Lines	50
Duplicated Lines	0 %

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	up()	0	29	3
A	down()	0	2	1

<?php

use App\TechTips;
use App\SystemFiles;
use App\TechTipFiles;
use App\TechTipSystems;
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class RelocateSystemFilesToTechTips extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    //  Relocate any system files into the Tech Tips knowledge base
    public function up()
    {
//        Schema::table('tech_tips', function (Blueprint $table) {
//            //
//        });
        
        
        $sysFiles = SystemFiles::all();
        
        foreach($sysFiles as $sysFile)
        {
            $newTip = TechTips::create([
                'user_id'       => $sysFile->user_id,

The property user_id does not exist on App\SystemFiles. Did you mean user?

                'public'        => 0,
                'documentation' => 1,
                'subject'       => $sysFile->name,
                'description'   => empty($sysFile->description) ? $sysFile->name : $sysFile->description,
                'created_at'    => $sysFile->created_at,
                'updated_at'    => $sysFile->updated_at
            ]);
            
            $tipId = $newTip->tip_id;
            TechTipFiles::create([
                'tip_id'  => $tipId,
                'file_id' => $sysFile->file_id
            ]);
            TechTipSystems::create([
                'tip_id' => $tipId,
                'sys_id' => $sysFile->sys_id
            ]);
        }
        
        
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
//        Schema::table('tech_tips', function (Blueprint $table) {
//            //
//        });
    }
}