修改2018_07_29_083103_create_admin_table.php 將admin改成Admin

.editorconfig

@@ -0,0 +1,9 @@
+root = true
+
+[*]
+indent_style = space
+indent_size = 4
+end_of_line = lf
+charset = utf-8
+trim_trailing_whitespace = false
+insert_final_newline = false

app/Admin.php

@@ -0,0 +1,42 @@
+<?php
+
+/**
+ * Created by Reliese Model.
+ * Date: Sun, 29 Jul 2018 08:54:26 +0000.
+ */
+
+namespace App;
+
+use Illuminate\Database\Eloquent\Model as Eloquent;
+
+/**
+ * Class Admin
+ * 
+ * @property string $ID
+ * @property string $password
+ * @property string $name
+ * @property string $nick_name
+ * @property string $phone_number
+ * @property \Carbon\Carbon $created_at
+ * @property \Carbon\Carbon $updated_at
+ *
+ * @package App
+ */
+class Admin extends Eloquent
+{
+	protected $connection = 'mysql';
+	protected $table = 'admin';
+	protected $primaryKey = 'ID';
+	public $incrementing = false;
+
+	protected $hidden = [
+		'password'
+	];
+
+	protected $fillable = [
+		'password',
+		'name',
+		'nick_name',
+		'phone_number'
+	];
+}

app/Area.php

@@ -0,0 +1,37 @@
+<?php
+
+/**
+ * Created by Reliese Model.
+ * Date: Sat, 28 Jul 2018 18:02:51 +0000.
+ */
+
+namespace App;
+
+use Illuminate\Database\Eloquent\Model as Eloquent;
+
+/**
+ * Class Area
+ * 
+ * @property int $AID
+ * @property string $name
+ * 
+ * @property \Illuminate\Database\Eloquent\Collection $manages
+ *
+ * @package App
+ */
+class Area extends Eloquent
+{
+	protected $connection = 'mysql';
+	protected $table = 'Area';
+	protected $primaryKey = 'AID';
+	public $timestamps = false;
+
+	protected $fillable = [
+		'name'
+	];
+
+	public function manages()
+	{
+		return $this->hasMany(\App\Manage::class, 'AID');
+	}
+}

app/Bank.php

@@ -0,0 +1,32 @@
+<?php
+
+/**
+ * Created by Reliese Model.
+ * Date: Sat, 28 Jul 2018 18:02:51 +0000.
+ */
+
+namespace App;
+
+use Illuminate\Database\Eloquent\Model as Eloquent;
+
+/**
+ * Class Bank
+ * 
+ * @property int $ID
+ * @property string $BankNum
+ * @property string $BankName
+ *
+ * @package App
+ */
+class Bank extends Eloquent
+{
+	protected $connection = 'mysql';
+	protected $table = 'Bank';
+	protected $primaryKey = 'ID';
+	public $timestamps = false;
+
+	protected $fillable = [
+		'BankNum',
+		'BankName'
+	];
+}

app/BeClassifiedA.php

@@ -0,0 +1,42 @@
+<?php
+
+/**
+ * Created by Reliese Model.
+ * Date: Sat, 28 Jul 2018 18:02:51 +0000.
+ */
+
+namespace App;
+
+use Illuminate\Database\Eloquent\Model as Eloquent;
+
+/**
+ * Class BeClassifiedA
+ * 
+ * @property string $CBID
+ * @property int $CID
+ * 
+ * @property \App\TheClass $the_class
+ * @property \App\CaseBuilder $case_builder
+ *
+ * @package App
+ */
+class BeClassifiedA extends Eloquent
+{
+	protected $connection = 'mysql';
+	public $incrementing = false;
+	public $timestamps = false;
+
+	protected $casts = [
+		'CID' => 'int'
+	];
+
+	public function the_class()
+	{
+		return $this->belongsTo(\App\TheClass::class, 'CID');
+	}
+
+	public function case_builder()
+	{
+		return $this->belongsTo(\App\CaseBuilder::class, 'CBID');
+	}
+}

app/Belong.php

@@ -0,0 +1,55 @@
+<?php
+
+/**
+ * Created by Reliese Model.
+ * Date: Sat, 28 Jul 2018 18:02:51 +0000.
+ */
+
+namespace App;
+
+use Illuminate\Database\Eloquent\Model as Eloquent;
+
+/**
+ * Class Belong
+ * 
+ * @property string $RID
+ * @property int $CID
+ * @property \Carbon\Carbon $startExclussiveDate
+ * @property \Carbon\Carbon $endExclussiveDate
+ * 
+ * @property \App\Receiver $receiver
+ * @property \App\TheClass $the_class
+ *
+ * @package App
+ */
+class Belong extends Eloquent
+{
+	protected $connection = 'mysql';
+	protected $table = 'Belong';
+	public $incrementing = false;
+	public $timestamps = false;
+
+	protected $casts = [
+		'CID' => 'int'
+	];
+
+	protected $dates = [
+		'startExclussiveDate',
+		'endExclussiveDate'
+	];
+
+	protected $fillable = [
+		'startExclussiveDate',
+		'endExclussiveDate'
+	];
+
+	public function receiver()
+	{
+		return $this->belongsTo(\App\Receiver::class, 'RID');
+	}
+
+	public function the_class()
+	{
+		return $this->belongsTo(\App\TheClass::class, 'CID');
+	}
+}

app/CaseBuilder.php

@@ -0,0 +1,89 @@
+<?php
+
+/**
+ * Created by Reliese Model.
+ * Date: Sat, 28 Jul 2018 18:02:51 +0000.
+ */
+
+namespace App;
+
+use Illuminate\Database\Eloquent\Model as Eloquent;
+
+/**
+ * Class CaseBuilder
+ * 
+ * @property string $CBID
+ * @property string $password
+ * @property string $companyName
+ * @property string $companyPhone
+ * @property string $companyAddress
+ * @property string $uniformNumber
+ * @property string $contact
+ * @property string $contactNumber
+ * @property string $contactEmail
+ * @property string $isProxy
+ * @property string $frequency
+ * @property string $payment
+ * @property \Carbon\Carbon $startServiceDate
+ * @property \Carbon\Carbon $endServiceDate
+ * @property int $verifyStatus
+ * 
+ * @property \Illuminate\Database\Eloquent\Collection $be_classified_as
+ * @property \Illuminate\Database\Eloquent\Collection $preferences
+ * @property \Illuminate\Database\Eloquent\Collection $the_cases
+ *
+ * @package App
+ */
+class CaseBuilder extends Eloquent
+{
+	protected $connection = 'mysql';
+	protected $table = 'CaseBuilder';
+	protected $primaryKey = 'CBID';
+	public $incrementing = false;
+	public $timestamps = false;
+
+	protected $casts = [
+		'verifyStatus' => 'int'
+	];
+
+	protected $dates = [
+		'startServiceDate',
+		'endServiceDate'
+	];
+
+	protected $hidden = [
+		'password'
+	];
+
+	protected $fillable = [
+		'password',
+		'companyName',
+		'companyPhone',
+		'companyAddress',
+		'uniformNumber',
+		'contact',
+		'contactNumber',
+		'contactEmail',
+		'isProxy',
+		'frequency',
+		'payment',
+		'startServiceDate',
+		'endServiceDate',
+		'verifyStatus'
+	];
+
+	public function be_classified_as()
+	{
+		return $this->hasMany(\App\BeClassifiedA::class, 'CBID');
+	}
+
+	public function preferences()
+	{
+		return $this->hasMany(\App\Preference::class, 'CBID');
+	}
+
+	public function the_cases()
+	{
+		return $this->hasMany(\App\TheCase::class, 'CBID');
+	}
+}

app/Choose.php

@@ -0,0 +1,26 @@
+<?php
+
+/**
+ * Created by Reliese Model.
+ * Date: Sat, 28 Jul 2018 18:02:51 +0000.
+ */
+
+namespace App;
+
+use Illuminate\Database\Eloquent\Model as Eloquent;
+
+/**
+ * Class Choose
+ * 
+ * @property string $RID
+ * @property string $TCID
+ *
+ * @package App
+ */
+class Choose extends Eloquent
+{
+	protected $connection = 'mysql';
+	protected $table = 'Choose';
+	public $incrementing = false;
+	public $timestamps = false;
+}

app/Commissioned.php

@@ -0,0 +1,126 @@
+<?php
+
+/**
+ * Created by Reliese Model.
+ * Date: Sat, 28 Jul 2018 18:02:51 +0000.
+ */
+
+namespace App;
+
+use Illuminate\Database\Eloquent\Model as Eloquent;
+
+/**
+ * Class Commissioned
+ * 
+ * @property string $ID
+ * @property string $TCID
+ * @property string $RID
+ * @property \Carbon\Carbon $commissionedDate
+ * @property string $pointOfArtical
+ * @property string $amountOfwords
+ * @property string $numOfImgesRequired
+ * @property int $FlightNegotiationStatus
+ * @property int $PriceNegotiationStatus
+ * @property int $caseExecutionStatus
+ * @property string $commentOfReceiver
+ * @property string $commentOfCaseBuilder
+ * @property string $reasonOfTerminate
+ * @property \Carbon\Carbon $terminationDate
+ * @property \Carbon\Carbon $PaymentTime
+ * @property string $paymentMethod
+ * @property string $bankName
+ * @property int $amountOfPay
+ * @property string $AccuountNumber
+ * @property string $MailID
+ * @property int $caseDifficulty
+ * @property int $receiverRating
+ * @property int $casebuilderRating
+ * 
+ * @property \App\TheCase $the_case
+ * @property \App\Receiver $receiver
+ * @property \Illuminate\Database\Eloquent\Collection $flight_negotiations
+ * @property \Illuminate\Database\Eloquent\Collection $price_negotiations
+ * @property \Illuminate\Database\Eloquent\Collection $proof_readings
+ * @property \Illuminate\Database\Eloquent\Collection $release_manuscripts
+ *
+ * @package App
+ */
+class Commissioned extends Eloquent
+{
+	protected $connection = 'mysql';
+	protected $table = 'Commissioned';
+	protected $primaryKey = 'ID';
+	public $incrementing = false;
+	public $timestamps = false;
+
+	protected $casts = [
+		'FlightNegotiationStatus' => 'int',
+		'PriceNegotiationStatus' => 'int',
+		'caseExecutionStatus' => 'int',
+		'amountOfPay' => 'int',
+		'caseDifficulty' => 'int',
+		'receiverRating' => 'int',
+		'casebuilderRating' => 'int'
+	];
+
+	protected $dates = [
+		'commissionedDate',
+		'terminationDate',
+		'PaymentTime'
+	];
+
+	protected $fillable = [
+		'TCID',
+		'RID',
+		'commissionedDate',
+		'pointOfArtical',
+		'amountOfwords',
+		'numOfImgesRequired',
+		'FlightNegotiationStatus',
+		'PriceNegotiationStatus',
+		'caseExecutionStatus',
+		'commentOfReceiver',
+		'commentOfCaseBuilder',
+		'reasonOfTerminate',
+		'terminationDate',
+		'PaymentTime',
+		'paymentMethod',
+		'bankName',
+		'amountOfPay',
+		'AccuountNumber',
+		'MailID',
+		'caseDifficulty',
+		'receiverRating',
+		'casebuilderRating'
+	];
+
+	public function the_case()
+	{
+		return $this->belongsTo(\App\TheCase::class, 'TCID');
+	}
+
+	public function receiver()
+	{
+		return $this->belongsTo(\App\Receiver::class, 'RID');
+	}
+
+	public function flight_negotiations()
+	{
+		return $this->hasMany(\App\FlightNegotiation::class, 'ID');
+	}
+
+	public function price_negotiations()
+	{
+		return $this->hasMany(\App\PriceNegotiation::class, 'ID');
+	}
+
+	public function proof_readings()
+	{
+		return $this->hasMany(\App\ProofReading::class, 'ID');
+	}
+
+	public function release_manuscripts()
+	{
+		return $this->hasMany(\App\ReleaseManuscript::class, 'ID');
+	}
+}

app/Exceptions/UserNotFoundException.php

@@ -0,0 +1,10 @@
+<?php
+
+namespace App\Exceptions;
+
+use Exception;
+
+class UserNotFoundException extends Exception
+{
+    //
+}

app/FlightNegotiation.php

@@ -0,0 +1,50 @@
+<?php
+
+/**
+ * Created by Reliese Model.
+ * Date: Sat, 28 Jul 2018 18:02:51 +0000.
+ */
+
+namespace App;
+
+use Illuminate\Database\Eloquent\Model as Eloquent;
+
+/**
+ * Class FlightNegotiation
+ * 
+ * @property string $ID
+ * @property \Carbon\Carbon $negotiationDate
+ * @property string $negotiator
+ * @property \Carbon\Carbon $deliveryDate
+ * @property \Carbon\Carbon $publishDate
+ * @property string $description
+ * 
+ * @property \App\Commissioned $commissioned
+ *
+ * @package App
+ */
+class FlightNegotiation extends Eloquent
+{
+	protected $connection = 'mysql';
+	protected $table = 'FlightNegotiation';
+	public $incrementing = false;
+	public $timestamps = false;
+
+	protected $dates = [
+		'negotiationDate',
+		'deliveryDate',
+		'publishDate'
+	];
+
+	protected $fillable = [
+		'negotiator',
+		'deliveryDate',
+		'publishDate',
+		'description'
+	];
+
+	public function commissioned()
+	{
+		return $this->belongsTo(\App\Commissioned::class, 'ID');
+	}
+}

app/Http/Controllers/HomeController.php

@@ -0,0 +1,13 @@
+<?php
+
+namespace App\Http\Controllers;
+
+use Illuminate\Http\Request;
+
+class HomeController extends Controller
+{
+    public function index()
+    {
+        return view('home.index');
+    }
+}

app/Http/Controllers/ReceiverController.php

@@ -0,0 +1,65 @@
+<?php
+
+namespace App\Http\Controllers;
+
+use Validator;
+use App\Receiver;
+
+class ReceiverController extends Controller
+{
+    public function loginPage()
+    {
+        return view('receiver.login');
+    }
+
+    public function loginProcess()
+    {
+        $input = request()->all();
+
+        //輸入資料驗證
+        $rules = [
+            'email'=>[
+                'required',
+                'email',
+            ],
+            'password'=>[
+                'required',
+                'min:6'
+            ],
+        ];
+        $validate = Validator::make($input,$rules);
+        if($validate->fails()){
+            return redirect('/receiver/login')
+                ->withErrors($validate)->withInput();
+        }
+        //驗證通過，巷資料庫查詢使用者是否存在
+        $User = Receiver::where('email',$input['email'])->firstOrFail();
+        $isPasswordCorrect = $input['password'] == $User->password;
+        if(!$isPasswordCorrect){ 
+            //failed -> 導向至登入畫面(附帶錯誤訊息)
+            $error_msg = [
+                'msg'=>['密碼錯誤']
+            ];
+            return redirect('/receiver/login')->withErrors($error_msg)
+                    ->withInput();
+        }
+        //Pass->紀錄session
+       /*  $record = [
+            'user_id'=>$User->RID,
+            'role_id'=>'Receiver'
+        ]; */
+        //session()->put($record);
+        // $binds = [
+        //    'name'=>$User->nickname
+        // ];
+       // $name = $User->nickname;
+        session()->put('user_id',$User->RID);
+        return redirect('/');
+    }
+
+    public function logout()
+    {
+        session()->forget('user_id');
+        return redirect('/');
+    }
+}

app/Manage.php

@@ -0,0 +1,75 @@
+<?php
+
+/**
+ * Created by Reliese Model.
+ * Date: Sat, 28 Jul 2018 18:02:51 +0000.
+ */
+
+namespace App;
+
+use Illuminate\Database\Eloquent\Model as Eloquent;
+
+/**
+ * Class Manage
+ * 
+ * @property string $RID
+ * @property int $AID
+ * @property string $URL
+ * @property \Carbon\Carbon $createdDate
+ * @property int $amountOfFans
+ * @property int $avgNumOfVisitorsPerDay
+ * @property int $numOfEntriesPerPage
+ * @property int $startOfCooperationFee
+ * @property int $endOfCooperationFee
+ * @property \Carbon\Carbon $startOfexecutionTime
+ * @property \Carbon\Carbon $endOfexecutionTime
+ * 
+ * @property \App\Receiver $receiver
+ * @property \App\Area $area
+ *
+ * @package App
+ */
+class Manage extends Eloquent
+{
+	protected $connection = 'mysql';
+	protected $table = 'Manage';
+	public $incrementing = false;
+	public $timestamps = false;
+
+	protected $casts = [
+		'AID' => 'int',
+		'amountOfFans' => 'int',
+		'avgNumOfVisitorsPerDay' => 'int',
+		'numOfEntriesPerPage' => 'int',
+		'startOfCooperationFee' => 'int',
+		'endOfCooperationFee' => 'int'
+	];
+
+	protected $dates = [
+		'createdDate',
+		'startOfexecutionTime',
+		'endOfexecutionTime'
+	];
+
+	protected $fillable = [
+		'URL',
+		'createdDate',
+		'amountOfFans',
+		'avgNumOfVisitorsPerDay',
+		'numOfEntriesPerPage',
+		'startOfCooperationFee',
+		'endOfCooperationFee',
+		'startOfexecutionTime',
+		'endOfexecutionTime'
+	];
+
+	public function receiver()
+	{
+		return $this->belongsTo(\App\Receiver::class, 'RID');
+	}
+
+	public function area()
+	{
+		return $this->belongsTo(\App\Area::class, 'AID');
+	}
+}

app/Preference.php

@@ -0,0 +1,44 @@
+<?php
+
+/**
+ * Created by Reliese Model.
+ * Date: Sat, 28 Jul 2018 18:02:51 +0000.
+ */
+
+namespace App;
+
+use Illuminate\Database\Eloquent\Model as Eloquent;
+
+/**
+ * Class Preference
+ * 
+ * @property string $CBID
+ * @property string $RID
+ * @property string $description
+ * 
+ * @property \App\CaseBuilder $case_builder
+ * @property \App\Receiver $receiver
+ *
+ * @package App
+ */
+class Preference extends Eloquent
+{
+	protected $connection = 'mysql';
+	protected $table = 'Preference';
+	public $incrementing = false;
+	public $timestamps = false;
+
+	protected $fillable = [
+		'description'
+	];
+
+	public function case_builder()
+	{
+		return $this->belongsTo(\App\CaseBuilder::class, 'CBID');
+	}
+
+	public function receiver()
+	{
+		return $this->belongsTo(\App\Receiver::class, 'RID');
+	}
+}

app/PriceNegotiation.php

@@ -0,0 +1,55 @@
+<?php
+
+/**
+ * Created by Reliese Model.
+ * Date: Sat, 28 Jul 2018 18:02:51 +0000.
+ */
+
+namespace App;
+
+use Illuminate\Database\Eloquent\Model as Eloquent;
+
+/**
+ * Class PriceNegotiation
+ * 
+ * @property string $ID
+ * @property \Carbon\Carbon $negotiationDate
+ * @property string $negotiator
+ * @property string $itemName
+ * @property int $itemValue
+ * @property int $price
+ * @property string $description
+ * 
+ * @property \App\Commissioned $commissioned
+ *
+ * @package App
+ */
+class PriceNegotiation extends Eloquent
+{
+	protected $connection = 'mysql';
+	protected $table = 'PriceNegotiation';
+	public $incrementing = false;
+	public $timestamps = false;
+
+	protected $casts = [
+		'itemValue' => 'int',
+		'price' => 'int'
+	];
+
+	protected $dates = [
+		'negotiationDate'
+	];
+
+	protected $fillable = [
+		'negotiator',
+		'itemName',
+		'itemValue',
+		'price',
+		'description'
+	];
+
+	public function commissioned()
+	{
+		return $this->belongsTo(\App\Commissioned::class, 'ID');
+	}
+}

app/ProofReading.php

@@ -0,0 +1,49 @@
+<?php
+
+/**
+ * Created by Reliese Model.
+ * Date: Sat, 28 Jul 2018 18:02:51 +0000.
+ */
+
+namespace App;
+
+use Illuminate\Database\Eloquent\Model as Eloquent;
+
+/**
+ * Class ProofReading
+ * 
+ * @property string $ID
+ * @property \Carbon\Carbon $deliveryDate
+ * @property string $manuscriptUrl
+ * @property string $suggestions
+ * @property \Carbon\Carbon $replyTime
+ * @property string $description
+ * 
+ * @property \App\Commissioned $commissioned
+ *
+ * @package App
+ */
+class ProofReading extends Eloquent
+{
+	protected $connection = 'mysql';
+	protected $table = 'ProofReading';
+	public $incrementing = false;
+	public $timestamps = false;
+
+	protected $dates = [
+		'deliveryDate',
+		'replyTime'
+	];
+
+	protected $fillable = [
+		'manuscriptUrl',
+		'suggestions',
+		'replyTime',
+		'description'
+	];
+
+	public function commissioned()
+	{
+		return $this->belongsTo(\App\Commissioned::class, 'ID');
+	}
+}

app/Providers/AppServiceProvider.php

@@ -3,6 +3,7 @@
 namespace App\Providers;
 
 use Illuminate\Support\ServiceProvider;
+use Illuminate\Support\Facades\Schema;
 
 class AppServiceProvider extends ServiceProvider
 {
@@ -13,7 +14,7 @@ class AppServiceProvider extends ServiceProvider
      */
     public function boot()
     {
-        //
+        Schema::defaultStringLength(191);
     }
 
     /**
@@ -26,6 +27,7 @@ class AppServiceProvider extends ServiceProvider
         if ($this->app->environment() !== 'production') {
             $this->app->register(\Way\Generators\GeneratorsServiceProvider::class);
             $this->app->register(\Xethron\MigrationsGenerator\MigrationsGeneratorServiceProvider::class);
+            $this->app->register(\Reliese\Coders\CodersServiceProvider::class);
         }
     }
 }

app/Receiver.php

@@ -0,0 +1,86 @@
+<?php
+
+/**
+ * Created by Reliese Model.
+ * Date: Sat, 28 Jul 2018 18:02:51 +0000.
+ */
+
+namespace App;
+
+use Illuminate\Database\Eloquent\Model as Eloquent;
+
+/**
+ * Class Receiver
+ * 
+ * @property string $RID
+ * @property string $password
+ * @property string $name
+ * @property string $nickName
+ * @property string $phone
+ * @property string $email
+ * @property string $address
+ * @property string $indroduction
+ * @property string $photoPath
+ * @property string $bankName
+ * @property string $bankID
+ * @property int $verifyStatus
+ * @property string $bankLocation
+ * 
+ * @property \Illuminate\Database\Eloquent\Collection $belongs
+ * @property \Illuminate\Database\Eloquent\Collection $commissioneds
+ * @property \Illuminate\Database\Eloquent\Collection $manages
+ * @property \Illuminate\Database\Eloquent\Collection $preferences
+ *
+ * @package App
+ */
+class Receiver extends Eloquent
+{
+	protected $connection = 'mysql';
+	protected $table = 'Receiver';
+	protected $primaryKey = 'RID';
+	public $incrementing = false;
+	public $timestamps = false;
+
+	protected $casts = [
+		'verifyStatus' => 'int'
+	];
+
+	protected $hidden = [
+		'password'
+	];
+
+	protected $fillable = [
+		'password',
+		'name',
+		'nickName',
+		'phone',
+		'email',
+		'address',
+		'indroduction',
+		'photoPath',
+		'bankName',
+		'bankID',
+		'verifyStatus',
+		'bankLocation'
+	];
+
+	public function belongs()
+	{
+		return $this->hasMany(\App\Belong::class, 'RID');
+	}
+
+	public function commissioneds()
+	{
+		return $this->hasMany(\App\Commissioned::class, 'RID');
+	}
+
+	public function manages()
+	{
+		return $this->hasMany(\App\Manage::class, 'RID');
+	}
+
+	public function preferences()
+	{
+		return $this->hasMany(\App\Preference::class, 'RID');
+	}
+}

app/ReleaseManuscript.php

@@ -0,0 +1,49 @@
+<?php
+
+/**
+ * Created by Reliese Model.
+ * Date: Sat, 28 Jul 2018 18:02:51 +0000.
+ */
+
+namespace App;
+
+use Illuminate\Database\Eloquent\Model as Eloquent;
+
+/**
+ * Class ReleaseManuscript
+ * 
+ * @property string $ID
+ * @property \Carbon\Carbon $releaseDate
+ * @property string $manuscriptUrl
+ * @property string $suggestions
+ * @property \Carbon\Carbon $replyTime
+ * @property string $description
+ * 
+ * @property \App\Commissioned $commissioned
+ *
+ * @package App
+ */
+class ReleaseManuscript extends Eloquent
+{
+	protected $connection = 'mysql';
+	protected $table = 'ReleaseManuscript';
+	public $incrementing = false;
+	public $timestamps = false;
+
+	protected $dates = [
+		'releaseDate',
+		'replyTime'
+	];
+
+	protected $fillable = [
+		'manuscriptUrl',
+		'suggestions',
+		'replyTime',
+		'description'
+	];
+
+	public function commissioned()
+	{
+		return $this->belongsTo(\App\Commissioned::class, 'ID');
+	}
+}

app/TheCase.php

@@ -0,0 +1,65 @@
+<?php
+
+/**
+ * Created by Reliese Model.
+ * Date: Sat, 28 Jul 2018 18:02:51 +0000.
+ */
+
+namespace App;
+
+use Illuminate\Database\Eloquent\Model as Eloquent;
+
+/**
+ * Class TheCase
+ * 
+ * @property string $TCID
+ * @property string $CBID
+ * @property string $name
+ * @property string $class
+ * @property string $description
+ * @property int $specialPrice
+ * @property int $price
+ * @property string $howToBuy
+ * @property \Carbon\Carbon $releaseDate
+ * 
+ * @property \App\CaseBuilder $case_builder
+ * @property \Illuminate\Database\Eloquent\Collection $commissioneds
+ *
+ * @package App
+ */
+class TheCase extends Eloquent
+{
+	protected $connection = 'mysql';
+	protected $table = 'TheCase';
+	public $incrementing = false;
+	public $timestamps = false;
+
+	protected $casts = [
+		'specialPrice' => 'int',
+		'price' => 'int'
+	];
+
+	protected $dates = [
+		'releaseDate'
+	];
+
+	protected $fillable = [
+		'name',
+		'class',
+		'description',
+		'specialPrice',
+		'price',
+		'howToBuy',
+		'releaseDate'
+	];
+
+	public function case_builder()
+	{
+		return $this->belongsTo(\App\CaseBuilder::class, 'CBID');
+	}
+
+	public function commissioneds()
+	{
+		return $this->hasMany(\App\Commissioned::class, 'TCID');
+	}
+}

app/TheClass.php

@@ -0,0 +1,43 @@
+<?php
+
+/**
+ * Created by Reliese Model.
+ * Date: Sat, 28 Jul 2018 18:02:51 +0000.
+ */
+
+namespace App;
+
+use Illuminate\Database\Eloquent\Model as Eloquent;
+
+/**
+ * Class TheClass
+ * 
+ * @property int $CID
+ * @property string $name
+ * 
+ * @property \Illuminate\Database\Eloquent\Collection $be_classified_as
+ * @property \Illuminate\Database\Eloquent\Collection $belongs
+ *
+ * @package App
+ */
+class TheClass extends Eloquent
+{
+	protected $connection = 'mysql';
+	protected $table = 'TheClass';
+	protected $primaryKey = 'CID';
+	public $timestamps = false;
+
+	protected $fillable = [
+		'name'
+	];
+
+	public function be_classified_as()
+	{
+		return $this->hasMany(\App\BeClassifiedA::class, 'CID');
+	}
+
+	public function belongs()
+	{
+		return $this->hasMany(\App\Belong::class, 'CID');
+	}
+}

composer.json

@@ -8,7 +8,8 @@
         "php": "^7.1.3",
         "fideloper/proxy": "^4.0",
         "laravel/framework": "5.6.*",
-        "laravel/tinker": "^1.0"
+        "laravel/tinker": "^1.0",
+        "reliese/laravel": "^0.0.13"
     },
     "require-dev": {
         "filp/whoops": "^2.0",

composer.lock

@@ -1,10 +1,10 @@
 {
     "_readme": [
         "This file locks the dependencies of your project to a known state",
-        "Read more about it at https://getcomposer.org/doc/01-basic-usage.md#composer-lock-the-lock-file",
+        "Read more about it at https://getcomposer.org/doc/01-basic-usage.md#installing-dependencies",
         "This file is @generated automatically"
     ],
-    "content-hash": "74b545bf3ad701ef07e1d8533bc2936d",
+    "content-hash": "64686d2d4621990c72d0b84f8dce9ec0",
     "packages": [
         {
             "name": "dnoegel/php-xdg-base-dir",
@@ -39,6 +39,233 @@
             "description": "implementation of xdg base directory specification for php",
             "time": "2014-10-24T07:27:01+00:00"
         },
+        {
+            "name": "doctrine/cache",
+            "version": "v1.7.1",
+            "source": {
+                "type": "git",
+                "url": "https://github.com/doctrine/cache.git",
+                "reference": "b3217d58609e9c8e661cd41357a54d926c4a2a1a"
+            },
+            "dist": {
+                "type": "zip",
+                "url": "https://api.github.com/repos/doctrine/cache/zipball/b3217d58609e9c8e661cd41357a54d926c4a2a1a",
+                "reference": "b3217d58609e9c8e661cd41357a54d926c4a2a1a",
+                "shasum": ""
+            },
+            "require": {
+                "php": "~7.1"
+            },
+            "conflict": {
+                "doctrine/common": ">2.2,<2.4"
+            },
+            "require-dev": {
+                "alcaeus/mongo-php-adapter": "^1.1",
+                "mongodb/mongodb": "^1.1",
+                "phpunit/phpunit": "^5.7",
+                "predis/predis": "~1.0"
+            },
+            "suggest": {
+                "alcaeus/mongo-php-adapter": "Required to use legacy MongoDB driver"
+            },
+            "type": "library",
+            "extra": {
+                "branch-alias": {
+                    "dev-master": "1.7.x-dev"
+                }
+            },
+            "autoload": {
+                "psr-4": {
+                    "Doctrine\\Common\\Cache\\": "lib/Doctrine/Common/Cache"
+                }
+            },
+            "notification-url": "https://packagist.org/downloads/",
+            "license": [
+                "MIT"
+            ],
+            "authors": [
+                {
+                    "name": "Roman Borschel",
+                    "email": "roman@code-factory.org"
+                },
+                {
+                    "name": "Benjamin Eberlei",
+                    "email": "kontakt@beberlei.de"
+                },
+                {
+                    "name": "Guilherme Blanco",
+                    "email": "guilhermeblanco@gmail.com"
+                },
+                {
+                    "name": "Jonathan Wage",
+                    "email": "jonwage@gmail.com"
+                },
+                {
+                    "name": "Johannes Schmitt",
+                    "email": "schmittjoh@gmail.com"
+                }
+            ],
+            "description": "Caching library offering an object-oriented API for many cache backends",
+            "homepage": "http://www.doctrine-project.org",
+            "keywords": [
+                "cache",
+                "caching"
+            ],
+            "time": "2017-08-25T07:02:50+00:00"
+        },
+        {
+            "name": "doctrine/dbal",
+            "version": "v2.8.0",
+            "source": {
+                "type": "git",
+                "url": "https://github.com/doctrine/dbal.git",
+                "reference": "5140a64c08b4b607b9bedaae0cedd26f04a0e621"
+            },
+            "dist": {
+                "type": "zip",
+                "url": "https://api.github.com/repos/doctrine/dbal/zipball/5140a64c08b4b607b9bedaae0cedd26f04a0e621",
+                "reference": "5140a64c08b4b607b9bedaae0cedd26f04a0e621",
+                "shasum": ""
+            },
+            "require": {
+                "doctrine/cache": "^1.0",
+                "doctrine/event-manager": "^1.0",
+                "ext-pdo": "*",
+                "php": "^7.1"
+            },
+            "require-dev": {
+                "doctrine/coding-standard": "^4.0",
+                "jetbrains/phpstorm-stubs": "^2018.1.2",
+                "phpstan/phpstan": "^0.10.1",
+                "phpunit/phpunit": "^7.1.2",
+                "phpunit/phpunit-mock-objects": "!=3.2.4,!=3.2.5",
+                "symfony/console": "^2.0.5|^3.0|^4.0",
+                "symfony/phpunit-bridge": "^3.4.5|^4.0.5"
+            },
+            "suggest": {
+                "symfony/console": "For helpful console commands such as SQL execution and import of files."
+            },
+            "bin": [
+                "bin/doctrine-dbal"
+            ],
+            "type": "library",
+            "extra": {
+                "branch-alias": {
+                    "dev-master": "2.8.x-dev",
+                    "dev-develop": "3.0.x-dev"
+                }
+            },
+            "autoload": {
+                "psr-0": {
+                    "Doctrine\\DBAL\\": "lib/"
+                }
+            },
+            "notification-url": "https://packagist.org/downloads/",
+            "license": [
+                "MIT"
+            ],
+            "authors": [
+                {
+                    "name": "Roman Borschel",
+                    "email": "roman@code-factory.org"
+                },
+                {
+                    "name": "Benjamin Eberlei",
+                    "email": "kontakt@beberlei.de"
+                },
+                {
+                    "name": "Guilherme Blanco",
+                    "email": "guilhermeblanco@gmail.com"
+                },
+                {
+                    "name": "Jonathan Wage",
+                    "email": "jonwage@gmail.com"
+                }
+            ],
+            "description": "Database Abstraction Layer",
+            "homepage": "http://www.doctrine-project.org",
+            "keywords": [
+                "database",
+                "dbal",
+                "persistence",
+                "queryobject"
+            ],
+            "time": "2018-07-13T03:16:35+00:00"
+        },
+        {
+            "name": "doctrine/event-manager",
+            "version": "v1.0.0",
+            "source": {
+                "type": "git",
+                "url": "https://github.com/doctrine/event-manager.git",
+                "reference": "a520bc093a0170feeb6b14e9d83f3a14452e64b3"
+            },
+            "dist": {
+                "type": "zip",
+                "url": "https://api.github.com/repos/doctrine/event-manager/zipball/a520bc093a0170feeb6b14e9d83f3a14452e64b3",
+                "reference": "a520bc093a0170feeb6b14e9d83f3a14452e64b3",
+                "shasum": ""
+            },
+            "require": {
+                "php": "^7.1"
+            },
+            "conflict": {
+                "doctrine/common": "<2.9@dev"
+            },
+            "require-dev": {
+                "doctrine/coding-standard": "^4.0",
+                "phpunit/phpunit": "^7.0"
+            },
+            "type": "library",
+            "extra": {
+                "branch-alias": {
+                    "dev-master": "1.0.x-dev"
+                }
+            },
+            "autoload": {
+                "psr-4": {
+                    "Doctrine\\Common\\": "lib/Doctrine/Common"
+                }
+            },
+            "notification-url": "https://packagist.org/downloads/",
+            "license": [
+                "MIT"
+            ],
+            "authors": [
+                {
+                    "name": "Roman Borschel",
+                    "email": "roman@code-factory.org"
+                },
+                {
+                    "name": "Benjamin Eberlei",
+                    "email": "kontakt@beberlei.de"
+                },
+                {
+                    "name": "Guilherme Blanco",
+                    "email": "guilhermeblanco@gmail.com"
+                },
+                {
+                    "name": "Jonathan Wage",
+                    "email": "jonwage@gmail.com"
+                },
+                {
+                    "name": "Johannes Schmitt",
+                    "email": "schmittjoh@gmail.com"
+                },
+                {
+                    "name": "Marco Pivetta",
+                    "email": "ocramius@gmail.com"
+                }
+            ],
+            "description": "Doctrine Event Manager component",
+            "homepage": "https://www.doctrine-project.org/projects/event-manager.html",
+            "keywords": [
+                "event",
+                "eventdispatcher",
+                "eventmanager"
+            ],
+            "time": "2018-06-11T11:59:03+00:00"
+        },
         {
             "name": "doctrine/inflector",
             "version": "v1.3.0",
@@ -455,16 +682,16 @@
         },
         {
             "name": "laravel/framework",
-            "version": "v5.6.28",
+            "version": "v5.6.29",
             "source": {
                 "type": "git",
                 "url": "https://github.com/laravel/framework.git",
-                "reference": "40ba2ee0e61cb4bc3c9f1dab04908e6acf06b86f"
+                "reference": "acc6b5c54ab196d3358f60acc5f55d9ebaaccc02"
             },
             "dist": {
                 "type": "zip",
-                "url": "https://api.github.com/repos/laravel/framework/zipball/40ba2ee0e61cb4bc3c9f1dab04908e6acf06b86f",
-                "reference": "40ba2ee0e61cb4bc3c9f1dab04908e6acf06b86f",
+                "url": "https://api.github.com/repos/laravel/framework/zipball/acc6b5c54ab196d3358f60acc5f55d9ebaaccc02",
+                "reference": "acc6b5c54ab196d3358f60acc5f55d9ebaaccc02",
                 "shasum": ""
             },
             "require": {
@@ -590,7 +817,7 @@
                 "framework",
                 "laravel"
             ],
-            "time": "2018-07-17T14:15:36+00:00"
+            "time": "2018-07-26T16:01:26+00:00"
         },
         {
             "name": "laravel/tinker",
@@ -1264,6 +1491,58 @@
             ],
             "time": "2018-07-19T23:38:55+00:00"
         },
+        {
+            "name": "reliese/laravel",
+            "version": "v0.0.13",
+            "source": {
+                "type": "git",
+                "url": "https://github.com/reliese/laravel.git",
+                "reference": "10075c5f5e67efba18d781216ff5a0ffa3fc2d7f"
+            },
+            "dist": {
+                "type": "zip",
+                "url": "https://api.github.com/repos/reliese/laravel/zipball/10075c5f5e67efba18d781216ff5a0ffa3fc2d7f",
+                "reference": "10075c5f5e67efba18d781216ff5a0ffa3fc2d7f",
+                "shasum": ""
+            },
+            "require": {
+                "doctrine/dbal": "~2.5",
+                "illuminate/console": "~5.1",
+                "illuminate/contracts": "~5.1",
+                "illuminate/database": "~5.1",
+                "illuminate/filesystem": "~5.1",
+                "illuminate/support": "~5.1",
+                "php": ">=5.6.4"
+            },
+            "require-dev": {
+                "fzaninotto/faker": "~1.4",
+                "mockery/mockery": "0.9.*",
+                "phpunit/phpunit": "~5.0"
+            },
+            "type": "library",
+            "autoload": {
+                "psr-4": {
+                    "Reliese\\": "src/"
+                }
+            },
+            "notification-url": "https://packagist.org/downloads/",
+            "license": [
+                "MIT"
+            ],
+            "authors": [
+                {
+                    "name": "Cristian Llanos",
+                    "email": "cristianllanos@outlook.com"
+                }
+            ],
+            "description": "Reliese Components for Laravel Framework code generation.",
+            "homepage": "http://cristianllanos.com",
+            "keywords": [
+                "laravel",
+                "reliese"
+            ],
+            "time": "2017-02-04T15:50:39+00:00"
+        },
         {
             "name": "swiftmailer/swiftmailer",
             "version": "v6.1.2",
@@ -1325,16 +1604,16 @@
         },
         {
             "name": "symfony/console",
-            "version": "v4.1.1",
+            "version": "v4.1.2",
             "source": {
                 "type": "git",
                 "url": "https://github.com/symfony/console.git",
-                "reference": "70591cda56b4b47c55776ac78e157c4bb6c8b43f"
+                "reference": "5c31f6a97c1c240707f6d786e7e59bfacdbc0219"
             },
             "dist": {
                 "type": "zip",
-                "url": "https://api.github.com/repos/symfony/console/zipball/70591cda56b4b47c55776ac78e157c4bb6c8b43f",
-                "reference": "70591cda56b4b47c55776ac78e157c4bb6c8b43f",
+                "url": "https://api.github.com/repos/symfony/console/zipball/5c31f6a97c1c240707f6d786e7e59bfacdbc0219",
+                "reference": "5c31f6a97c1c240707f6d786e7e59bfacdbc0219",
                 "shasum": ""
             },
             "require": {
@@ -1389,11 +1668,11 @@
             ],
             "description": "Symfony Console Component",
             "homepage": "https://symfony.com",
-            "time": "2018-05-31T10:17:53+00:00"
+            "time": "2018-07-16T14:05:40+00:00"
         },
         {
             "name": "symfony/css-selector",
-            "version": "v4.1.1",
+            "version": "v4.1.2",
             "source": {
                 "type": "git",
                 "url": "https://github.com/symfony/css-selector.git",
@@ -1446,16 +1725,16 @@
         },
         {
             "name": "symfony/debug",
-            "version": "v4.1.1",
+            "version": "v4.1.2",
             "source": {
                 "type": "git",
                 "url": "https://github.com/symfony/debug.git",
-                "reference": "dbe0fad88046a755dcf9379f2964c61a02f5ae3d"
+                "reference": "a1f2118cedb8731c45e945cdd2b808ca82abc4b5"
             },
             "dist": {
                 "type": "zip",
-                "url": "https://api.github.com/repos/symfony/debug/zipball/dbe0fad88046a755dcf9379f2964c61a02f5ae3d",
-                "reference": "dbe0fad88046a755dcf9379f2964c61a02f5ae3d",
+                "url": "https://api.github.com/repos/symfony/debug/zipball/a1f2118cedb8731c45e945cdd2b808ca82abc4b5",
+                "reference": "a1f2118cedb8731c45e945cdd2b808ca82abc4b5",
                 "shasum": ""
             },
             "require": {
@@ -1498,20 +1777,20 @@
             ],
             "description": "Symfony Debug Component",
             "homepage": "https://symfony.com",
-            "time": "2018-06-08T09:39:36+00:00"
+            "time": "2018-07-06T14:52:28+00:00"
         },
         {
             "name": "symfony/event-dispatcher",
-            "version": "v4.1.1",
+            "version": "v4.1.2",
             "source": {
                 "type": "git",
                 "url": "https://github.com/symfony/event-dispatcher.git",
-                "reference": "2391ed210a239868e7256eb6921b1bd83f3087b5"
+                "reference": "00d64638e4f0703a00ab7fc2c8ae5f75f3b4020f"
             },
             "dist": {
                 "type": "zip",
-                "url": "https://api.github.com/repos/symfony/event-dispatcher/zipball/2391ed210a239868e7256eb6921b1bd83f3087b5",
-                "reference": "2391ed210a239868e7256eb6921b1bd83f3087b5",
+                "url": "https://api.github.com/repos/symfony/event-dispatcher/zipball/00d64638e4f0703a00ab7fc2c8ae5f75f3b4020f",
+                "reference": "00d64638e4f0703a00ab7fc2c8ae5f75f3b4020f",
                 "shasum": ""
             },
             "require": {
@@ -1561,11 +1840,11 @@
             ],
             "description": "Symfony EventDispatcher Component",
             "homepage": "https://symfony.com",
-            "time": "2018-04-06T07:35:57+00:00"
+            "time": "2018-07-10T11:02:47+00:00"
         },
         {
             "name": "symfony/finder",
-            "version": "v4.1.1",
+            "version": "v4.1.2",
             "source": {
                 "type": "git",
                 "url": "https://github.com/symfony/finder.git",
@@ -1614,16 +1893,16 @@
         },
         {
             "name": "symfony/http-foundation",
-            "version": "v4.1.1",
+            "version": "v4.1.2",
             "source": {
                 "type": "git",
                 "url": "https://github.com/symfony/http-foundation.git",
-                "reference": "4f9c7cf962e635b0b26b14500ac046e07dbef7f3"
+                "reference": "8da9ea68ab2d80dfabd41e0d14b9606bb47a10c0"
             },
             "dist": {
                 "type": "zip",
-                "url": "https://api.github.com/repos/symfony/http-foundation/zipball/4f9c7cf962e635b0b26b14500ac046e07dbef7f3",
-                "reference": "4f9c7cf962e635b0b26b14500ac046e07dbef7f3",
+                "url": "https://api.github.com/repos/symfony/http-foundation/zipball/8da9ea68ab2d80dfabd41e0d14b9606bb47a10c0",
+                "reference": "8da9ea68ab2d80dfabd41e0d14b9606bb47a10c0",
                 "shasum": ""
             },
             "require": {
@@ -1664,20 +1943,20 @@
             ],
             "description": "Symfony HttpFoundation Component",
             "homepage": "https://symfony.com",
-            "time": "2018-06-19T21:38:16+00:00"
+            "time": "2018-07-16T14:05:40+00:00"
         },
         {
             "name": "symfony/http-kernel",
-            "version": "v4.1.1",
+            "version": "v4.1.2",
             "source": {
                 "type": "git",
                 "url": "https://github.com/symfony/http-kernel.git",
-                "reference": "29c094a1c4f8209b7e033f612cbbd69029e38955"
+                "reference": "ebd28f4f88a2ca0a0488882ad73c4004f3afdbe3"
             },
             "dist": {
                 "type": "zip",
-                "url": "https://api.github.com/repos/symfony/http-kernel/zipball/29c094a1c4f8209b7e033f612cbbd69029e38955",
-                "reference": "29c094a1c4f8209b7e033f612cbbd69029e38955",
+                "url": "https://api.github.com/repos/symfony/http-kernel/zipball/ebd28f4f88a2ca0a0488882ad73c4004f3afdbe3",
+                "reference": "ebd28f4f88a2ca0a0488882ad73c4004f3afdbe3",
                 "shasum": ""
             },
             "require": {
@@ -1751,7 +2030,7 @@
             ],
             "description": "Symfony HttpKernel Component",
             "homepage": "https://symfony.com",
-            "time": "2018-06-25T13:06:45+00:00"
+            "time": "2018-07-23T17:16:22+00:00"
         },
         {
             "name": "symfony/polyfill-ctype",
@@ -1924,7 +2203,7 @@
         },
         {
             "name": "symfony/process",
-            "version": "v4.1.1",
+            "version": "v4.1.2",
             "source": {
                 "type": "git",
                 "url": "https://github.com/symfony/process.git",
@@ -1973,16 +2252,16 @@
         },
         {
             "name": "symfony/routing",
-            "version": "v4.1.1",
+            "version": "v4.1.2",
             "source": {
                 "type": "git",
                 "url": "https://github.com/symfony/routing.git",
-                "reference": "b38b9797327b26ea2e4146a40e6e2dc9820a6932"
+                "reference": "73770bf3682b4407b017c2bdcb2b11cdcbce5322"
             },
             "dist": {
                 "type": "zip",
-                "url": "https://api.github.com/repos/symfony/routing/zipball/b38b9797327b26ea2e4146a40e6e2dc9820a6932",
-                "reference": "b38b9797327b26ea2e4146a40e6e2dc9820a6932",
+                "url": "https://api.github.com/repos/symfony/routing/zipball/73770bf3682b4407b017c2bdcb2b11cdcbce5322",
+                "reference": "73770bf3682b4407b017c2bdcb2b11cdcbce5322",
                 "shasum": ""
             },
             "require": {
@@ -2046,20 +2325,20 @@
                 "uri",
                 "url"
             ],
-            "time": "2018-06-19T21:38:16+00:00"
+            "time": "2018-06-28T06:30:33+00:00"
         },
         {
             "name": "symfony/translation",
-            "version": "v4.1.1",
+            "version": "v4.1.2",
             "source": {
                 "type": "git",
                 "url": "https://github.com/symfony/translation.git",
-                "reference": "b6d8164085ee0b6debcd1b7a131fd6f63bb04854"
+                "reference": "2dd74d6b2dcbd46a93971e6ce7d245cf3123e957"
             },
             "dist": {
                 "type": "zip",
-                "url": "https://api.github.com/repos/symfony/translation/zipball/b6d8164085ee0b6debcd1b7a131fd6f63bb04854",
-                "reference": "b6d8164085ee0b6debcd1b7a131fd6f63bb04854",
+                "url": "https://api.github.com/repos/symfony/translation/zipball/2dd74d6b2dcbd46a93971e6ce7d245cf3123e957",
+                "reference": "2dd74d6b2dcbd46a93971e6ce7d245cf3123e957",
                 "shasum": ""
             },
             "require": {
@@ -2115,20 +2394,20 @@
             ],
             "description": "Symfony Translation Component",
             "homepage": "https://symfony.com",
-            "time": "2018-06-22T08:59:39+00:00"
+            "time": "2018-07-23T08:20:20+00:00"
         },
         {
             "name": "symfony/var-dumper",
-            "version": "v4.1.1",
+            "version": "v4.1.2",
             "source": {
                 "type": "git",
                 "url": "https://github.com/symfony/var-dumper.git",
-                "reference": "b2eebaec085d1f2cafbad7644733d494a3bbbc9b"
+                "reference": "9f882aed43f364de1d43038e8fb39703c577afc1"
             },
             "dist": {
                 "type": "zip",
-                "url": "https://api.github.com/repos/symfony/var-dumper/zipball/b2eebaec085d1f2cafbad7644733d494a3bbbc9b",
-                "reference": "b2eebaec085d1f2cafbad7644733d494a3bbbc9b",
+                "url": "https://api.github.com/repos/symfony/var-dumper/zipball/9f882aed43f364de1d43038e8fb39703c577afc1",
+                "reference": "9f882aed43f364de1d43038e8fb39703c577afc1",
                 "shasum": ""
             },
             "require": {
@@ -2190,7 +2469,7 @@
                 "debug",
                 "dump"
             ],
-            "time": "2018-06-23T12:23:56+00:00"
+            "time": "2018-07-05T11:54:23+00:00"
         },
         {
             "name": "tijsverkoyen/css-to-inline-styles",
@@ -2291,233 +2570,6 @@
         }
     ],
     "packages-dev": [
-        {
-            "name": "doctrine/cache",
-            "version": "v1.7.1",
-            "source": {
-                "type": "git",
-                "url": "https://github.com/doctrine/cache.git",
-                "reference": "b3217d58609e9c8e661cd41357a54d926c4a2a1a"
-            },
-            "dist": {
-                "type": "zip",
-                "url": "https://api.github.com/repos/doctrine/cache/zipball/b3217d58609e9c8e661cd41357a54d926c4a2a1a",
-                "reference": "b3217d58609e9c8e661cd41357a54d926c4a2a1a",
-                "shasum": ""
-            },
-            "require": {
-                "php": "~7.1"
-            },
-            "conflict": {
-                "doctrine/common": ">2.2,<2.4"
-            },
-            "require-dev": {
-                "alcaeus/mongo-php-adapter": "^1.1",
-                "mongodb/mongodb": "^1.1",
-                "phpunit/phpunit": "^5.7",
-                "predis/predis": "~1.0"
-            },
-            "suggest": {
-                "alcaeus/mongo-php-adapter": "Required to use legacy MongoDB driver"
-            },
-            "type": "library",
-            "extra": {
-                "branch-alias": {
-                    "dev-master": "1.7.x-dev"
-                }
-            },
-            "autoload": {
-                "psr-4": {
-                    "Doctrine\\Common\\Cache\\": "lib/Doctrine/Common/Cache"
-                }
-            },
-            "notification-url": "https://packagist.org/downloads/",
-            "license": [
-                "MIT"
-            ],
-            "authors": [
-                {
-                    "name": "Roman Borschel",
-                    "email": "roman@code-factory.org"
-                },
-                {
-                    "name": "Benjamin Eberlei",
-                    "email": "kontakt@beberlei.de"
-                },
-                {
-                    "name": "Guilherme Blanco",
-                    "email": "guilhermeblanco@gmail.com"
-                },
-                {
-                    "name": "Jonathan Wage",
-                    "email": "jonwage@gmail.com"
-                },
-                {
-                    "name": "Johannes Schmitt",
-                    "email": "schmittjoh@gmail.com"
-                }
-            ],
-            "description": "Caching library offering an object-oriented API for many cache backends",
-            "homepage": "http://www.doctrine-project.org",
-            "keywords": [
-                "cache",
-                "caching"
-            ],
-            "time": "2017-08-25T07:02:50+00:00"
-        },
-        {
-            "name": "doctrine/dbal",
-            "version": "v2.8.0",
-            "source": {
-                "type": "git",
-                "url": "https://github.com/doctrine/dbal.git",
-                "reference": "5140a64c08b4b607b9bedaae0cedd26f04a0e621"
-            },
-            "dist": {
-                "type": "zip",
-                "url": "https://api.github.com/repos/doctrine/dbal/zipball/5140a64c08b4b607b9bedaae0cedd26f04a0e621",
-                "reference": "5140a64c08b4b607b9bedaae0cedd26f04a0e621",
-                "shasum": ""
-            },
-            "require": {
-                "doctrine/cache": "^1.0",
-                "doctrine/event-manager": "^1.0",
-                "ext-pdo": "*",
-                "php": "^7.1"
-            },
-            "require-dev": {
-                "doctrine/coding-standard": "^4.0",
-                "jetbrains/phpstorm-stubs": "^2018.1.2",
-                "phpstan/phpstan": "^0.10.1",
-                "phpunit/phpunit": "^7.1.2",
-                "phpunit/phpunit-mock-objects": "!=3.2.4,!=3.2.5",
-                "symfony/console": "^2.0.5|^3.0|^4.0",
-                "symfony/phpunit-bridge": "^3.4.5|^4.0.5"
-            },
-            "suggest": {
-                "symfony/console": "For helpful console commands such as SQL execution and import of files."
-            },
-            "bin": [
-                "bin/doctrine-dbal"
-            ],
-            "type": "library",
-            "extra": {
-                "branch-alias": {
-                    "dev-master": "2.8.x-dev",
-                    "dev-develop": "3.0.x-dev"
-                }
-            },
-            "autoload": {
-                "psr-0": {
-                    "Doctrine\\DBAL\\": "lib/"
-                }
-            },
-            "notification-url": "https://packagist.org/downloads/",
-            "license": [
-                "MIT"
-            ],
-            "authors": [
-                {
-                    "name": "Roman Borschel",
-                    "email": "roman@code-factory.org"
-                },
-                {
-                    "name": "Benjamin Eberlei",
-                    "email": "kontakt@beberlei.de"
-                },
-                {
-                    "name": "Guilherme Blanco",
-                    "email": "guilhermeblanco@gmail.com"
-                },
-                {
-                    "name": "Jonathan Wage",
-                    "email": "jonwage@gmail.com"
-                }
-            ],
-            "description": "Database Abstraction Layer",
-            "homepage": "http://www.doctrine-project.org",
-            "keywords": [
-                "database",
-                "dbal",
-                "persistence",
-                "queryobject"
-            ],
-            "time": "2018-07-13T03:16:35+00:00"
-        },
-        {
-            "name": "doctrine/event-manager",
-            "version": "v1.0.0",
-            "source": {
-                "type": "git",
-                "url": "https://github.com/doctrine/event-manager.git",
-                "reference": "a520bc093a0170feeb6b14e9d83f3a14452e64b3"
-            },
-            "dist": {
-                "type": "zip",
-                "url": "https://api.github.com/repos/doctrine/event-manager/zipball/a520bc093a0170feeb6b14e9d83f3a14452e64b3",
-                "reference": "a520bc093a0170feeb6b14e9d83f3a14452e64b3",
-                "shasum": ""
-            },
-            "require": {
-                "php": "^7.1"
-            },
-            "conflict": {
-                "doctrine/common": "<2.9@dev"
-            },
-            "require-dev": {
-                "doctrine/coding-standard": "^4.0",
-                "phpunit/phpunit": "^7.0"
-            },
-            "type": "library",
-            "extra": {
-                "branch-alias": {
-                    "dev-master": "1.0.x-dev"
-                }
-            },
-            "autoload": {
-                "psr-4": {
-                    "Doctrine\\Common\\": "lib/Doctrine/Common"
-                }
-            },
-            "notification-url": "https://packagist.org/downloads/",
-            "license": [
-                "MIT"
-            ],
-            "authors": [
-                {
-                    "name": "Roman Borschel",
-                    "email": "roman@code-factory.org"
-                },
-                {
-                    "name": "Benjamin Eberlei",
-                    "email": "kontakt@beberlei.de"
-                },
-                {
-                    "name": "Guilherme Blanco",
-                    "email": "guilhermeblanco@gmail.com"
-                },
-                {
-                    "name": "Jonathan Wage",
-                    "email": "jonwage@gmail.com"
-                },
-                {
-                    "name": "Johannes Schmitt",
-                    "email": "schmittjoh@gmail.com"
-                },
-                {
-                    "name": "Marco Pivetta",
-                    "email": "ocramius@gmail.com"
-                }
-            ],
-            "description": "Doctrine Event Manager component",
-            "homepage": "https://www.doctrine-project.org/projects/event-manager.html",
-            "keywords": [
-                "event",
-                "eventdispatcher",
-                "eventmanager"
-            ],
-            "time": "2018-06-11T11:59:03+00:00"
-        },
         {
             "name": "doctrine/instantiator",
             "version": "1.1.0",

config/app.php

@@ -153,6 +153,7 @@ return [
 
         Way\Generators\GeneratorsServiceProvider::class,
         Xethron\MigrationsGenerator\MigrationsGeneratorServiceProvider::class,
+        Reliese\Coders\CodersServiceProvider::class,
 
         /*
          * Application Service Providers...

config/models.php

@@ -0,0 +1,420 @@
+<?php
+
+return [
+
+    /*
+    |--------------------------------------------------------------------------
+    | Default Configurations
+    |--------------------------------------------------------------------------
+    |
+    | In this section you may define the default configuration for each model
+    | that will be generated from any database.
+    |
+    */
+
+    '*' => [
+
+        /*
+        |--------------------------------------------------------------------------
+        | Model Files Location
+        |--------------------------------------------------------------------------
+        |
+        | We need a location to store your new generated files. All files will be
+        | placed within this directory. When you turn on base files, they will
+        | be placed within a Base directory inside this location.
+        |
+        */
+
+        'path' => app_path('app'),
+
+        /*
+        |--------------------------------------------------------------------------
+        | Model Namespace
+        |--------------------------------------------------------------------------
+        |
+        | Every generated model will belong to this namespace. It is suggested
+        | that this namespace should follow PSR-4 convention and be very
+        | similar to the path of your models defined above.
+        |
+        */
+
+        'namespace' => 'App',
+
+        /*
+        |--------------------------------------------------------------------------
+        | Parent Class
+        |--------------------------------------------------------------------------
+        |
+        | All Eloquent models should inherit from Eloquent Model class. However,
+        | you can define a custom Eloquent model that suits your needs.
+        | As an example one custom model has been added for you which
+        | will allow you to create custom database castings.
+        |
+        */
+
+        'parent' => Illuminate\Database\Eloquent\Model::class,
+
+        /*
+        |--------------------------------------------------------------------------
+        | Traits
+        |--------------------------------------------------------------------------
+        |
+        | Sometimes you may want to append certain traits to all your models.
+        | If that is what you need, you may list them bellow.
+        | As an example we have a BitBooleans trait which will treat MySQL bit
+        | data type as booleans. You might probably not need it, but it is
+        | an example of how you can customize your models.
+        |
+        */
+
+        'use' => [
+            // Reliese\Database\Eloquent\BitBooleans::class,
+            // Reliese\Database\Eloquent\BlamableBehavior::class,
+        ],
+
+        /*
+        |--------------------------------------------------------------------------
+        | Model Connection
+        |--------------------------------------------------------------------------
+        |
+        | If you wish your models had appended the connection from which they
+        | were generated, you should set this value to true and your
+        | models will have the connection property filled.
+        |
+        */
+
+        'connection' => true,
+
+        /*
+        |--------------------------------------------------------------------------
+        | Timestamps
+        |--------------------------------------------------------------------------
+        |
+        | If your tables have CREATED_AT and UPDATED_AT timestamps you may
+        | enable them and your models will fill their values as needed.
+        | You can also specify which fields should be treated as timestamps
+        | in case you don't follow the naming convention Eloquent uses.
+        | If your table doesn't have these fields, timestamps will be
+        | disabled for your model.
+        |
+        */
+
+        'timestamps' => true,
+
+        'timestamps' => [
+            'enabled' => true,
+            'fields' => [
+                'CREATED_AT' => 'created_at',
+                'UPDATED_AT' => 'updated_at',
+            ]
+        ],
+
+        /*
+        |--------------------------------------------------------------------------
+        | Soft Deletes
+        |--------------------------------------------------------------------------
+        |
+        | If your tables support soft deletes with a DELETED_AT attribute,
+        | you can enable them here. You can also specify which field
+        | should be treated as a soft delete attribute in case you
+        | don't follow the naming convention Eloquent uses.
+        | If your table doesn't have this field, soft deletes will be
+        | disabled for your model.
+        |
+        */
+
+        'soft_deletes' => false,
+
+        // 'soft_deletes' => [
+        //     'enabled' => true,
+        //     'field' => 'deleted_at',
+        // ],
+
+        /*
+        |--------------------------------------------------------------------------
+        | Date Format
+        |--------------------------------------------------------------------------
+        |
+        | Here you may define your models' date format. The following format
+        | is the default format Eloquent uses. You won't see it in your
+        | models unless you change it to a more convenient value.
+        |
+        */
+
+        'date_format' => 'Y-m-d H:i:s',
+
+        /*
+        |--------------------------------------------------------------------------
+        | Pagination
+        |--------------------------------------------------------------------------
+        |
+        | Here you may define how many models Eloquent should display when
+        | paginating them. The default number is 15, so you might not
+        | see this number in your models unless you change it.
+        |
+        */
+
+        'per_page' => 15,
+
+        /*
+        |--------------------------------------------------------------------------
+        | Base Files
+        |--------------------------------------------------------------------------
+        |
+        | By default, your models will be generated in your models path, but
+        | when you generate them again they will be replaced by new ones.
+        | You may want to customize your models and, at the same time, be
+        | able to generate them as your tables change. For that, you
+        | can enable base files. These files will be replaced whenever
+        | you generate them, but your customized files will not be touched.
+        |
+        */
+
+        'base_files' => false,
+
+        /*
+        |--------------------------------------------------------------------------
+        | Snake Attributes
+        |--------------------------------------------------------------------------
+        |
+        | Eloquent treats your model attributes as snake cased attributes, but
+        | if you have camel-cased fields in your database you can disable
+        | that behaviour and use camel case attributes in your models.
+        |
+        */
+
+        'snake_attributes' => true,
+
+        /*
+        |--------------------------------------------------------------------------
+        | Indent options
+        |--------------------------------------------------------------------------
+        |
+        | As default indention is done with tabs, but you can change it by setting
+        | this to the amount of spaces you that you want to use for indentation.
+        | Usually you will use 4 spaces instead of tabs.
+        |
+        */
+
+        'indent_with_space' => 0,
+
+        /*
+        |--------------------------------------------------------------------------
+        | Qualified Table Names
+        |--------------------------------------------------------------------------
+        |
+        | If some of your tables have cross-database relationships (probably in
+        | MySQL), you can make sure your models take into account their
+        | respective database schema.
+        |
+        | Can Either be NULL, FALSE or TRUE
+        | TRUE: Schema name will be prepended on the table
+        | FALSE:Table name will be set without schema name.
+        | NULL: Table name will follow laravel pattern,
+        |   i.e if class name(plural) matches table name, then table name will not be added
+        */
+
+        'qualified_tables' => false,
+
+        /*
+        |--------------------------------------------------------------------------
+        | Hidden Attributes
+        |--------------------------------------------------------------------------
+        |
+        | When casting your models into arrays or json, the need to hide some
+        | attributes sometimes arise. If your tables have some fields you
+        | want to hide, you can define them bellow.
+        | Some fields were defined for you.
+        |
+        */
+
+        'hidden' => [
+            '*secret*', '*password', '*token',
+        ],
+
+        /*
+        |--------------------------------------------------------------------------
+        | Mass Assignment Guarded Attributes
+        |--------------------------------------------------------------------------
+        |
+        | You may want to protect some fields from mass assignment. You can
+        | define them bellow. Some fields were defined for you.
+        | Your fillable attributes will be those which are not in the list
+        | excluding your models' primary keys.
+        |
+        */
+
+        'guarded' => [
+            // 'created_by', 'updated_by'
+        ],
+
+        /*
+        |--------------------------------------------------------------------------
+        | Casts
+        |--------------------------------------------------------------------------
+        |
+        | You may want to specify which of your table fields should be casted as
+        | something different than a string. For instance, you may want a
+        | text field be casted as an array or and object.
+        |
+        | You may define column patterns which will be casted using the value
+        | assigned. We have defined some fields for you. Feel free to
+        | modify them to fit your needs.
+        |
+        */
+
+        'casts' => [
+            '*_json' => 'json',
+        ],
+
+        /*
+        |--------------------------------------------------------------------------
+        | Excluded Tables
+        |--------------------------------------------------------------------------
+        |
+        | When performing the generation of models you may want to skip some of
+        | them, because you don't want a model for them or any other reason.
+        | You can define those tables bellow. The migrations table was
+        | filled for you, since you may not want a model for it.
+        |
+        */
+
+        'except' => [
+            'migrations',
+        ],
+
+        /*
+        |--------------------------------------------------------------------------
+        | Specified Tables
+        |--------------------------------------------------------------------------
+        |
+        | You can specify specific tables. This will generate the models only
+        | for selected tables, ignoring the rest.
+        |
+        */
+
+        'only' => [
+            // 'users',
+        ],
+
+        /*
+        |--------------------------------------------------------------------------
+        | Table Prefix
+        |--------------------------------------------------------------------------
+        |
+        | If you have a prefix on your table names but don't want it in the model
+        | and relation names, specify it here.
+        |
+        */
+
+        'table_prefix' => '',
+
+        /*
+        |--------------------------------------------------------------------------
+        | Lower table name before doing studly
+        |--------------------------------------------------------------------------
+        |
+        | If tables names are capitalised using studly produces incorrect name
+        | this can help fix it ie TABLE_NAME now becomes TableName
+        |
+        */
+
+        'lower_table_name_first' => false,
+
+        /*
+        |--------------------------------------------------------------------------
+        | Relation Name Strategy
+        |--------------------------------------------------------------------------
+        |
+        | How the relations should be named in your models.
+        |
+        | 'related'     Use the related table as the relation name.
+        |               (post.author --> user.id)
+                            generates Post::user() and User::posts()
+        |
+        | 'foreign_key' Use the foreign key as the relation name.
+        |                   (post.author --> user.id)
+        |                       generates Post::author() and User::posts_author()
+        |               Column id's are ignored.
+        |                   (post.author_id --> user.id)
+        |                       generates the same as above.
+        |               When the foreign key is redundant, it is omited.
+        |                   (post.user_id --> user.id)
+        |                       generates User::posts() and not User::posts_user()
+        */
+
+        'relation_name_strategy' => 'related',
+        // 'relation_name_strategy' => 'foreign_key',
+
+        /*
+         |--------------------------------------------------------------------------
+         | Determines need or not to generate constants with properties names like
+         |
+         | ...
+         | const AGE = 'age';
+         | const USER_NAME = 'user_name';
+         | ...
+         |
+         | that later can be used in QueryBuilder like
+         |
+         | ...
+         | $builder->select([User::USER_NAME])->where(User::AGE, '<=', 18);
+         | ...
+         |
+         | that helps to avoid typos in strings when typing field names and allows to use
+         | code competition with available model's field names.
+         */
+        'with_property_constants' => false,
+
+        /*
+        |--------------------------------------------------------------------------
+        | Disable Pluralization Name
+        |--------------------------------------------------------------------------
+        |
+        | You can disable pluralization tables and relations
+        |
+        */
+        'pluralize' => true,
+
+        /*
+        |--------------------------------------------------------------------------
+        | Disable Pluralization Except For Certain Tables
+        |--------------------------------------------------------------------------
+        |
+        | You can enable pluralization for certain tables
+        |
+        */
+        'override_pluralize_for' => [
+
+        ],
+    ],
+
+    /*
+    |--------------------------------------------------------------------------
+    | Database Specifics
+    |--------------------------------------------------------------------------
+    |
+    | In this section you may define the default configuration for each model
+    | that will be generated from a specific database. You can also nest
+    | table specific configurations.
+    | These values will override those defined in the section above.
+    |
+    */
+
+    // 'shop' => [
+    //     'path' => app_path(),
+    //     'namespace' => 'App',
+    //     'snake_attributes' => false,
+    //     'qualified_tables' => true,
+    //     'use' => [
+    //         Reliese\Database\Eloquent\BitBooleans::class,
+    //     ],
+    //     'except' => ['migrations'],
+    //     'only' => ['users'],
+    //      // Table Specifics Bellow:
+    //     'user' => [
+    //      // Don't use any default trait
+    //         'use' => [],
+    //     ]
+    // ],
+];

database/migrations/2014_10_12_000000_create_users_table.php

@@ -1,35 +0,0 @@
-<?php
-
-use Illuminate\Support\Facades\Schema;
-use Illuminate\Database\Schema\Blueprint;
-use Illuminate\Database\Migrations\Migration;
-
-class CreateUsersTable extends Migration
-{
-    /**
-     * Run the migrations.
-     *
-     * @return void
-     */
-    public function up()
-    {
-        Schema::create('users', function (Blueprint $table) {
-            $table->increments('id');
-            $table->string('name');
-            $table->string('email')->unique();
-            $table->string('password');
-            $table->rememberToken();
-            $table->timestamps();
-        });
-    }
-
-    /**
-     * Reverse the migrations.
-     *
-     * @return void
-     */
-    public function down()
-    {
-        Schema::dropIfExists('users');
-    }
-}

database/migrations/2014_10_12_100000_create_password_resets_table.php

@@ -1,32 +0,0 @@
-<?php
-
-use Illuminate\Support\Facades\Schema;
-use Illuminate\Database\Schema\Blueprint;
-use Illuminate\Database\Migrations\Migration;
-
-class CreatePasswordResetsTable extends Migration
-{
-    /**
-     * Run the migrations.
-     *
-     * @return void
-     */
-    public function up()
-    {
-        Schema::create('password_resets', function (Blueprint $table) {
-            $table->string('email')->index();
-            $table->string('token');
-            $table->timestamp('created_at')->nullable();
-        });
-    }
-
-    /**
-     * Reverse the migrations.
-     *
-     * @return void
-     */
-    public function down()
-    {
-        Schema::dropIfExists('password_resets');
-    }
-}

database/migrations/2018_07_22_192736_add_foreign_keys_to_Choose_table.php

@@ -1,37 +0,0 @@
-<?php
-
-use Illuminate\Database\Migrations\Migration;
-use Illuminate\Database\Schema\Blueprint;
-
-class AddForeignKeysToChooseTable extends Migration {
-
-	/**
-	 * Run the migrations.
-	 *
-	 * @return void
-	 */
-	public function up()
-	{
-		Schema::table('Choose', function(Blueprint $table)
-		{
-			$table->foreign('RID', 'choose_ibfk_1')->references('RID')->on('receiver')->onUpdate('RESTRICT')->onDelete('RESTRICT');
-			$table->foreign('TCID', 'choose_ibfk_2')->references('TCID')->on('thecase')->onUpdate('RESTRICT')->onDelete('CASCADE');
-		});
-	}
-
-
-	/**
-	 * Reverse the migrations.
-	 *
-	 * @return void
-	 */
-	public function down()
-	{
-		Schema::table('Choose', function(Blueprint $table)
-		{
-			$table->dropForeign('choose_ibfk_1');
-			$table->dropForeign('choose_ibfk_2');
-		});
-	}
-
-}

database/migrations/2018_07_28_175045_create_Area_table.php

@@ -14,7 +14,7 @@ class CreateAreaTable extends Migration {
 	{
 		Schema::create('Area', function(Blueprint $table)
 		{
-			$table->integer('A_ID', true);
+			$table->integer('AID', true);
 			$table->string('name', 50)->comment('領域名稱');
 		});
 	}

database/migrations/2018_07_28_175045_create_Belong_table.php

@@ -14,11 +14,11 @@ class CreateBelongTable extends Migration {
 	{
 		Schema::create('Belong', function(Blueprint $table)
 		{
-			$table->string('RID', 50);
-			$table->integer('C_ID')->index('C_ID');
+			$table->string('RID', 50)->comment('達人帳號');
+			$table->integer('CID')->index('CID')->comment('類別編號');
 			$table->date('startExclussiveDate')->nullable()->comment('排外起始時間');
 			$table->date('endExclussiveDate')->nullable()->comment('排外終止時間');
-			$table->primary(['RID','C_ID']);
+			$table->primary(['RID','CID']);
 		});
 	}
 

database/migrations/2018_07_28_175045_create_Manage_table.php

@@ -14,8 +14,8 @@ class CreateManageTable extends Migration {
 	{
 		Schema::create('Manage', function(Blueprint $table)
 		{
-			$table->string('RID', 50);
-			$table->integer('A_ID')->index('A_ID');
+			$table->string('RID', 50)->comment('達人帳號');
+			$table->integer('AID')->index('AID')->comment('領域編號');
 			$table->string('URL', 1024)->comment('網址');
 			$table->date('createdDate')->comment('創立時間');
 			$table->integer('amountOfFans')->nullable()->default(0)->comment('粉絲數');
@@ -25,7 +25,7 @@ class CreateManageTable extends Migration {
 			$table->integer('endOfCooperationFee')->comment('合作費用區間終止');
 			$table->date('startOfexecutionTime')->comment('執行時間起始');
 			$table->date('endOfexecutionTime')->comment('執行時間終止');
-			$table->primary(['RID','A_ID']);
+			$table->primary(['RID','AID']);
 		});
 	}
 

database/migrations/2018_07_28_175046_add_foreign_keys_to_BeClassifiedAs_table.php

@@ -14,8 +14,8 @@ class AddForeignKeysToBeClassifiedAsTable extends Migration {
 	{
 		Schema::table('BeClassifiedAs', function(Blueprint $table)
 		{
-			$table->foreign('CID', 'beclassifiedas_ibfk_1')->references('C_ID')->on('theclass')->onUpdate('CASCADE')->onDelete('CASCADE');
-			$table->foreign('CBID', 'beclassifiedas_ibfk_2')->references('CBID')->on('casebuilder')->onUpdate('RESTRICT')->onDelete('RESTRICT');
+			$table->foreign('CID', 'fk_BeClassifiedAs_1')->references('CID')->on('TheClass')->onUpdate('CASCADE')->onDelete('CASCADE');
+			$table->foreign('CBID', 'fk_BeClassifiedAs_2')->references('CBID')->on('CaseBuilder')->onUpdate('NO ACTION')->onDelete('NO ACTION');
 		});
 	}
 
@@ -29,8 +29,8 @@ class AddForeignKeysToBeClassifiedAsTable extends Migration {
 	{
 		Schema::table('BeClassifiedAs', function(Blueprint $table)
 		{
-			$table->dropForeign('beclassifiedas_ibfk_1');
-			$table->dropForeign('beclassifiedas_ibfk_2');
+			$table->dropForeign('fk_BeClassifiedAs_1');
+			$table->dropForeign('fk_BeClassifiedAs_2');
 		});
 	}
 

database/migrations/2018_07_28_175046_add_foreign_keys_to_Belong_table.php

@@ -14,8 +14,8 @@ class AddForeignKeysToBelongTable extends Migration {
 	{
 		Schema::table('Belong', function(Blueprint $table)
 		{
-			$table->foreign('C_ID', 'belong_ibfk_1')->references('C_ID')->on('theclass')->onUpdate('CASCADE')->onDelete('CASCADE');
-			$table->foreign('RID', 'belong_ibfk_2')->references('RID')->on('receiver')->onUpdate('RESTRICT')->onDelete('RESTRICT');
+			$table->foreign('RID', 'fk_Belong_1')->references('RID')->on('Receiver')->onUpdate('NO ACTION')->onDelete('CASCADE');
+			$table->foreign('CID', 'fk_Belong_2')->references('CID')->on('TheClass')->onUpdate('NO ACTION')->onDelete('CASCADE');
 		});
 	}
 
@@ -29,8 +29,8 @@ class AddForeignKeysToBelongTable extends Migration {
 	{
 		Schema::table('Belong', function(Blueprint $table)
 		{
-			$table->dropForeign('belong_ibfk_1');
-			$table->dropForeign('belong_ibfk_2');
+			$table->dropForeign('fk_Belong_1');
+			$table->dropForeign('fk_Belong_2');
 		});
 	}
 

database/migrations/2018_07_28_175046_add_foreign_keys_to_Commissioned_table.php

@@ -14,8 +14,8 @@ class AddForeignKeysToCommissionedTable extends Migration {
 	{
 		Schema::table('Commissioned', function(Blueprint $table)
 		{
-			$table->foreign('TCID', 'commissioned_ibfk_1')->references('TCID')->on('thecase')->onUpdate('RESTRICT')->onDelete('CASCADE');
-			$table->foreign('RID', 'commissioned_ibfk_2')->references('RID')->on('receiver')->onUpdate('RESTRICT')->onDelete('RESTRICT');
+			$table->foreign('TCID', 'fk_Commissioned_1')->references('TCID')->on('TheCase')->onUpdate('NO ACTION')->onDelete('NO ACTION');
+			$table->foreign('RID', 'fk_Commissioned_2')->references('RID')->on('Receiver')->onUpdate('NO ACTION')->onDelete('CASCADE');
 		});
 	}
 
@@ -29,8 +29,8 @@ class AddForeignKeysToCommissionedTable extends Migration {
 	{
 		Schema::table('Commissioned', function(Blueprint $table)
 		{
-			$table->dropForeign('commissioned_ibfk_1');
-			$table->dropForeign('commissioned_ibfk_2');
+			$table->dropForeign('fk_Commissioned_1');
+			$table->dropForeign('fk_Commissioned_2');
 		});
 	}
 

database/migrations/2018_07_28_175046_add_foreign_keys_to_FlightNegotiation_table.php

@@ -14,7 +14,7 @@ class AddForeignKeysToFlightNegotiationTable extends Migration {
 	{
 		Schema::table('FlightNegotiation', function(Blueprint $table)
 		{
-			$table->foreign('ID', 'flightnegotiation_ibfk_1')->references('ID')->on('commissioned')->onUpdate('RESTRICT')->onDelete('RESTRICT');
+			$table->foreign('ID', 'fk_FlightNegotiation_1')->references('ID')->on('Commissioned')->onUpdate('NO ACTION')->onDelete('CASCADE');
 		});
 	}
 
@@ -28,7 +28,7 @@ class AddForeignKeysToFlightNegotiationTable extends Migration {
 	{
 		Schema::table('FlightNegotiation', function(Blueprint $table)
 		{
-			$table->dropForeign('flightnegotiation_ibfk_1');
+			$table->dropForeign('fk_FlightNegotiation_1');
 		});
 	}
 

database/migrations/2018_07_28_175046_add_foreign_keys_to_Manage_table.php

@@ -14,8 +14,8 @@ class AddForeignKeysToManageTable extends Migration {
 	{
 		Schema::table('Manage', function(Blueprint $table)
 		{
-			$table->foreign('A_ID', 'manage_ibfk_1')->references('A_ID')->on('area')->onUpdate('CASCADE')->onDelete('CASCADE');
-			$table->foreign('RID', 'manage_ibfk_2')->references('RID')->on('receiver')->onUpdate('RESTRICT')->onDelete('RESTRICT');
+			$table->foreign('RID', 'fk_Manage_1')->references('RID')->on('Receiver')->onUpdate('NO ACTION')->onDelete('NO ACTION');
+			$table->foreign('AID', 'fk_Manage_2')->references('AID')->on('Area')->onUpdate('NO ACTION')->onDelete('NO ACTION');
 		});
 	}
 
@@ -29,8 +29,8 @@ class AddForeignKeysToManageTable extends Migration {
 	{
 		Schema::table('Manage', function(Blueprint $table)
 		{
-			$table->dropForeign('manage_ibfk_1');
-			$table->dropForeign('manage_ibfk_2');
+			$table->dropForeign('fk_Manage_1');
+			$table->dropForeign('fk_Manage_2');
 		});
 	}
 

database/migrations/2018_07_28_175046_add_foreign_keys_to_Preference_table.php

@@ -14,8 +14,8 @@ class AddForeignKeysToPreferenceTable extends Migration {
 	{
 		Schema::table('Preference', function(Blueprint $table)
 		{
-			$table->foreign('CBID', 'preference_ibfk_1')->references('CBID')->on('casebuilder')->onUpdate('RESTRICT')->onDelete('CASCADE');
-			$table->foreign('RID', 'preference_ibfk_2')->references('RID')->on('receiver')->onUpdate('RESTRICT')->onDelete('CASCADE');
+			$table->foreign('CBID', 'fk_Preference_1')->references('CBID')->on('CaseBuilder')->onUpdate('NO ACTION')->onDelete('NO ACTION');
+			$table->foreign('RID', 'fk_Preference_2')->references('RID')->on('Receiver')->onUpdate('NO ACTION')->onDelete('NO ACTION');
 		});
 	}
 
@@ -29,8 +29,8 @@ class AddForeignKeysToPreferenceTable extends Migration {
 	{
 		Schema::table('Preference', function(Blueprint $table)
 		{
-			$table->dropForeign('preference_ibfk_1');
-			$table->dropForeign('preference_ibfk_2');
+			$table->dropForeign('fk_Preference_1');
+			$table->dropForeign('fk_Preference_2');
 		});
 	}
 

database/migrations/2018_07_28_175046_add_foreign_keys_to_PriceNegotiation_table.php

@@ -14,7 +14,7 @@ class AddForeignKeysToPriceNegotiationTable extends Migration {
 	{
 		Schema::table('PriceNegotiation', function(Blueprint $table)
 		{
-			$table->foreign('ID', 'pricenegotiation_ibfk_1')->references('ID')->on('commissioned')->onUpdate('RESTRICT')->onDelete('RESTRICT');
+			$table->foreign('ID', 'fk_PriceNegotiation_1')->references('ID')->on('Commissioned')->onUpdate('NO ACTION')->onDelete('CASCADE');
 		});
 	}
 
@@ -28,7 +28,7 @@ class AddForeignKeysToPriceNegotiationTable extends Migration {
 	{
 		Schema::table('PriceNegotiation', function(Blueprint $table)
 		{
-			$table->dropForeign('pricenegotiation_ibfk_1');
+			$table->dropForeign('fk_PriceNegotiation_1');
 		});
 	}
 

database/migrations/2018_07_28_175046_add_foreign_keys_to_ProofReading_table.php

@@ -14,7 +14,7 @@ class AddForeignKeysToProofReadingTable extends Migration {
 	{
 		Schema::table('ProofReading', function(Blueprint $table)
 		{
-			$table->foreign('ID', 'proofreading_ibfk_1')->references('ID')->on('commissioned')->onUpdate('RESTRICT')->onDelete('RESTRICT');
+			$table->foreign('ID', 'fk_ProofReading_1')->references('ID')->on('Commissioned')->onUpdate('NO ACTION')->onDelete('CASCADE');
 		});
 	}
 
@@ -28,7 +28,7 @@ class AddForeignKeysToProofReadingTable extends Migration {
 	{
 		Schema::table('ProofReading', function(Blueprint $table)
 		{
-			$table->dropForeign('proofreading_ibfk_1');
+			$table->dropForeign('fk_ProofReading_1');
 		});
 	}
 

database/migrations/2018_07_28_175046_add_foreign_keys_to_ReleaseManuscript_table.php

@@ -14,7 +14,7 @@ class AddForeignKeysToReleaseManuscriptTable extends Migration {
 	{
 		Schema::table('ReleaseManuscript', function(Blueprint $table)
 		{
-			$table->foreign('ID', 'releasemanuscript_ibfk_1')->references('ID')->on('commissioned')->onUpdate('RESTRICT')->onDelete('RESTRICT');
+			$table->foreign('ID', 'fk_ReleaseManuscript_1')->references('ID')->on('Commissioned')->onUpdate('NO ACTION')->onDelete('CASCADE');
 		});
 	}
 
@@ -28,7 +28,7 @@ class AddForeignKeysToReleaseManuscriptTable extends Migration {
 	{
 		Schema::table('ReleaseManuscript', function(Blueprint $table)
 		{
-			$table->dropForeign('releasemanuscript_ibfk_1');
+			$table->dropForeign('fk_ReleaseManuscript_1');
 		});
 	}
 

database/migrations/2018_07_28_175046_add_foreign_keys_to_TheCase_table.php

@@ -14,7 +14,7 @@ class AddForeignKeysToTheCaseTable extends Migration {
 	{
 		Schema::table('TheCase', function(Blueprint $table)
 		{
-			$table->foreign('CBID', 'thecase_ibfk_1')->references('CBID')->on('casebuilder')->onUpdate('RESTRICT')->onDelete('CASCADE');
+			$table->foreign('CBID', 'fk_TheCase_1')->references('CBID')->on('CaseBuilder')->onUpdate('NO ACTION')->onDelete('NO ACTION');
 		});
 	}
 
@@ -28,7 +28,7 @@ class AddForeignKeysToTheCaseTable extends Migration {
 	{
 		Schema::table('TheCase', function(Blueprint $table)
 		{
-			$table->dropForeign('thecase_ibfk_1');
+			$table->dropForeign('fk_TheCase_1');
 		});
 	}
 

database/migrations/2018_07_29_083103_create_admin_table.php

@@ -18,10 +18,9 @@ class CreateAdminTable extends Migration
             $table->string('password');
             $table->string('name');
             $table->string('nick_name');
-            $table->string('email');
             $table->string('phone_number');
-            $table->timestamps();
             $table->primary('ID');
+            $table->timestamps();
         });
     }
 

database/seeds/DatabaseSeeder.php

@@ -11,6 +11,6 @@ class DatabaseSeeder extends Seeder
      */
     public function run()
     {
-        // $this->call(UsersTableSeeder::class);
+       
     }
 }

package.json

@@ -12,11 +12,11 @@
     "devDependencies": {
         "axios": "^0.18",
         "bootstrap": "^4.0.0",
-        "popper.js": "^1.12",
         "cross-env": "^5.1",
         "jquery": "^3.2",
         "laravel-mix": "^2.0",
         "lodash": "^4.17.4",
+        "popper.js": "^1.12",
         "vue": "^2.5.7"
     }
 }

public/mix-manifest.json

@@ -0,0 +1,4 @@
+{
+    "/js/app.js": "/js/app.js",
+    "/css/app.css": "/css/app.css"
+}

readme.md

@@ -1,9 +1,19 @@
 部落客媒合系統
 ===
+## 安裝所需的開發環境
+### Ubuntu 18.04
+        sudo apt install php mysql-server phpmyadmin php-mbstring php-xml php-zip curl wget libpng-dev
+        curl -sS https://getcomposer.org/installer | sudo php -- --install-dir=/usr/local/bin --filename=composer
+        sudo cat /etc/mysql/debian.cnf #查詢系統內定的MySQL預設帳號密碼
+        curl -sS https://dl.yarnpkg.com/debian/pubkey.gpg | sudo apt-key add -
+        echo "deb https://dl.yarnpkg.com/debian/ stable main" | sudo tee /etc/apt/sources.list.d/yarn.list
+        sudo apt update && apt install nodejs yarn
 
 ## 專案參數與環境重建
 當你Clone下來的專案，因為有git採用了 `.gitignore` 機制，比較敏感的參數（像是APP_KEY、資料庫帳密等）與共用的函式庫檔案不會包含進來，必須在自己這邊重建。
 
+重建的步驟如下：
+
 ### 1. 將你的專案下載回來，並進入此專案目錄
     $ git clone <此專案網址>
     $ cd BlogMatch
@@ -22,7 +32,11 @@
     $ php artisan key:generate
 
 ### 6. 重建資料庫
-待補...
+這個專案有包含資料庫遷移(Migration)，所以只要下：
+
+    $ php artisan migrate
+    
+就可以了，資料表都會自動產生
 
 ## 執行此專案
 ### 快速啟動

resources/assets/sass/_variables.scss

@@ -1,6 +1,6 @@
 
 // Body
-$body-bg: #f5f8fa;
+$body-bg: #fff;
 
 // Typography
 $font-family-sans-serif: "Raleway", sans-serif;

resources/views/components/validationErrorMsg.blade.php

@@ -0,0 +1,10 @@
+
+<div class=" alert alert-danger" role="alert">
+    <ul>
+        @if($errors AND count($errors))
+            @foreach($errors->all() as $err)
+                <li>{{$err}}</li>
+            @endForeach
+        @endif
+    </ul>
+</div>

resources/views/home/index.blade.php

@@ -0,0 +1,8 @@
+@extends('layout.app')
+
+@section('title','部落客媒合系統')
+
+@section('content')
+    <button class="btn btn-primary">我想成為KOL</button>
+    <button class="btn btn-primary">我想成為品牌/代理商</button>
+@endsection

resources/views/layout/app.blade.php

@@ -0,0 +1,25 @@
+<!DOCTYPE html>
+<html lang="en">
+<head>
+    <meta charset="UTF-8">
+    <meta name="viewport" content="width=device-width, initial-scale=1.0">
+    <meta http-equiv="X-UA-Compatible" content="ie=edge">
+    <title>@yield('title')</title>
+    <link rel="stylesheet" href="/css/app.css">
+</head>
+<body>
+    <div class="container">
+        <nav class="navbar navbar-expand-lg navbar-light bg-light">
+            <a class="navbar-brand" href="/">部落客媒合系統</a>
+            <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="Toggle navigation">
+                <span class="navbar-toggler-icon"></span>
+            </button>  
+            @include('layout.navbar')
+        </nav>
+        <div class="mt-3">
+                @yield('content')
+        </div>
+    </div>
+    <script src="/js/app.js"></script>
+</body>
+</html>

resources/views/layout/login.blade.php

@@ -0,0 +1,24 @@
+<!DOCTYPE html>
+<html lang="en">
+<head>
+    <meta charset="UTF-8">
+    <meta name="viewport" content="width=device-width, initial-scale=1.0">
+    <meta http-equiv="X-UA-Compatible" content="ie=edge">
+    <title>@yield('title')</title>
+    <link rel="stylesheet" href="/css/app.css">
+</head>
+<body>
+    <div class="container">
+        <nav class="navbar navbar-expand-lg navbar-light bg-light">
+            <a class="navbar-brand" href="/">部落客媒合系統</a>
+            <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="Toggle navigation">
+                <span class="navbar-toggler-icon"></span>
+            </button>
+        </nav>
+        <div class="mt-3">
+                @yield('content')
+        </div>
+    </div>
+    <script src="/js/app.js"></script>
+</body>
+</html>

resources/views/layout/navbar.blade.php

@@ -0,0 +1,22 @@
+<div class="collapse navbar-collapse" id="navbarSupportedContent">
+    <ul class="navbar-nav ml-auto">
+        @if(session()->has('user_id'))
+            <li class="nav-item">
+                <a class="nav-link" href="#">{{session()->get('user_id')}},您好</a>
+            </li>
+            <li class="nav-item">
+                <a class="nav-link" href="/receiver/logout">登出</a>
+            </li>
+        @else
+            <li class="nav-item active">
+                <a class="nav-link" href="/receiver/login">KOL登入<span class="sr-only">(current)</span></a>
+            </li>
+            <li class="nav-item">
+                <a class="nav-link" href="#">品牌/代理商登入</a>
+            </li>
+            <li class="nav-item">
+                <a class="nav-link" href="#">後台登入</a>
+            </li>
+        @endif
+    </ul>
+</div>

resources/views/receiver/login.blade.php

@@ -0,0 +1,21 @@
+@extends('layout.login')
+
+@section('title','KOL登入')
+
+@section('content')
+
+@include('components.validationErrorMsg')
+<form action="" method="POST">
+    <div class="form-group">
+        <label for="InputEmail1">帳號</label>
+    <input type="email" name="email" value="{{old('email')}}" class="form-control" id="InputEmail1" aria-describedby="emailHelp" placeholder="請輸入電子郵件地址">
+    </div>
+    <div class="form-group">
+        <label for="InputPassword1">密碼</label>
+    <input type="password" name="password" value="{{old('password')}}" class="form-control" id="InputPassword1" placeholder="請輸入密碼">
+    </div>
+    <button type="submit" class="btn btn-primary btn-lg">登入</button>
+    <input type="button" class="btn btn-default btn-lg" value="取消">
+    {!! csrf_field() !!}
+</form>
+@endsection

routes/web.php

@@ -10,13 +10,14 @@
 | contains the "web" middleware group. Now create something great!
 |
 */
-Route::get('/', function () {
-    return view('welcome');
-});
 
-// //首頁url
-// Route::get('/', 'HomeController@index');
-//
+/* Route::get('/', function () {
+    return view('welcome');
+}); */
+
+//首頁url
+Route::get('/', 'HomeController@index');
+
 // //管理者相關url
 // Route::group(['prefix' => 'admin'], function () {
 //     Route::get('/login', '');
@@ -24,13 +25,14 @@ Route::get('/', function () {
 //     Route::get('/dashbord', '');
 // });
 //
-// //接案者相關url
-// Route::group(['prefix' => 'receiver'], function () {
-//     Route::get('/login', '');
-//     Route::post('/login', '');
-//     Route::get('/register', '');
-//     Route::post('/register', '');
-// });
+//接案者相關url
+Route::group(['prefix' => 'receiver'], function () {
+    Route::get('/login', 'ReceiverController@loginPage');
+    Route::post('/login', 'ReceiverController@loginProcess');
+    Route::get('/logout','ReceiverController@logout');
+    // Route::get('/register', '');
+    // Route::post('/register', '');
+});
 //
 // //發案者相關url
 // Route::group(['prefix' => 'casebuilder'], function () {

yarn.lock

@@ -3630,9 +3630,9 @@ ip@^1.1.0, ip@^1.1.5:
   version "1.1.5"
   resolved "https://registry.yarnpkg.com/ip/-/ip-1.1.5.tgz#bdded70114290828c0a039e72ef25f5aaec4354a"
 
-ipaddr.js@1.6.0:
-  version "1.6.0"
-  resolved "https://registry.yarnpkg.com/ipaddr.js/-/ipaddr.js-1.6.0.tgz#e3fa357b773da619f26e95f049d055c72796f86b"
+ipaddr.js@1.8.0:
+  version "1.8.0"
+  resolved "https://registry.yarnpkg.com/ipaddr.js/-/ipaddr.js-1.8.0.tgz#eaa33d6ddd7ace8f7f6fe0c9ca0440e706738b1e"
 
 is-absolute-url@^2.0.0:
   version "2.1.0"
@@ -5621,11 +5621,11 @@ proto-list@~1.2.1:
   resolved "https://registry.yarnpkg.com/proto-list/-/proto-list-1.2.4.tgz#212d5bfe1318306a420f6402b8e26ff39647a849"
 
 proxy-addr@~2.0.3:
-  version "2.0.3"
-  resolved "https://registry.yarnpkg.com/proxy-addr/-/proxy-addr-2.0.3.tgz#355f262505a621646b3130a728eb647e22055341"
+  version "2.0.4"
+  resolved "https://registry.yarnpkg.com/proxy-addr/-/proxy-addr-2.0.4.tgz#ecfc733bf22ff8c6f407fa275327b9ab67e48b93"
   dependencies:
     forwarded "~0.1.2"
-    ipaddr.js "1.6.0"
+    ipaddr.js "1.8.0"
 
 prr@~1.0.1:
   version "1.0.1"
@@ -6944,8 +6944,8 @@ uglify-es@^3.3.4:
     source-map "~0.6.1"
 
 uglify-js@3.4.x:
-  version "3.4.5"
-  resolved "https://registry.yarnpkg.com/uglify-js/-/uglify-js-3.4.5.tgz#650889c0766cf0f6fd5346cea09cd212f544be69"
+  version "3.4.6"
+  resolved "https://registry.yarnpkg.com/uglify-js/-/uglify-js-3.4.6.tgz#bc546d53f3e02b05d97d0ca5a7abfe0fb0384ddb"
   dependencies:
     commander "~2.16.0"
     source-map "~0.6.1"