1 <?php
2 use Illuminate\Support\Facades\Schema;
3 use Illuminate\Database\Schema\Blueprint;
4 use Illuminate\Database\Migrations\Migration;
5  
6 class Migrations20190306091702 extends Migration
7 {
8   /**
9    * Run the migrations.
10    *
11    * @return void
12   */
13   public function up()
14   {
15     Schema::create('ecommerce_orders', function (Blueprint $table) {
16       $table->integer('id')->autoIncrement()->nullable(true);
17       $table->integer('ecommerce_order_state_id')->nullable(true);
18       $table->integer('contact_id')->nullable(true);
19       $table->integer('delivery_address_id')->nullable(true);
20       $table->integer('billing_address_id')->nullable(true)->unique();
21       $table->timestamp('ordered_at')->nullable(true);
22       $table->string('customer_note')->nullable(true);
23       $table->string('internal_note')->nullable(true);
24     });
25     Schema::create('ecommerce_order_simple_items', function (Blueprint $table) {
26       $table->integer('id')->autoIncrement()->nullable(true);
27       $table->integer('ecommerce_order_id');
28       $table->string('name',255);
29       $table->float('quantity')->nullable(true);
30     });
31     Schema::create('ecommerce_order_items', function (Blueprint $table) {
32       $table->integer('id')->autoIncrement()->nullable(true);
33       $table->integer('ecommerce_order_id');
34       $table->integer('product_id');
35       $table->float('quantity')->nullable(true);
36     });
37     Schema::table('ecommerce_order_items', function (Blueprint $table) {
38       $table->foreign('ecommerce_order_id')->references('id')->on('ecommerce_orders');
39     });
40     Schema::table('ecommerce_order_simple_items', function (Blueprint $table) {
41       $table->foreign('ecommerce_order_id')->references('id')->on('ecommerce_orders');
42     });
43   }
44   /**
45    * Reverse the migrations.
46    *
47    * @return void
48   */
49   public function down()
50   {
51     Schema::table('ecommerce_order_simple_items', function (Blueprint $table) {
52       $table->dropForeign(['ecommerce_order_id']);
53     });
54     Schema::table('ecommerce_order_items', function (Blueprint $table) {
55       $table->dropForeign(['ecommerce_order_id']);
56     });
57     Schema::dropIfExists('ecommerce_orders');
58     Schema::dropIfExists('ecommerce_order_simple_items');
59     Schema::dropIfExists('ecommerce_order_items');
60   }
61 }
62 

1 <?php
2 namespace App\Models\Base;
3 use Illuminate\Database\Eloquent\Model;
4  
5 class EcommerceOrder extends Model
6 {
7   /**  
8   * Do not automatically manage timestamps by Eloquent
9   * 
10   * @var bool
11   */
12   protected $timestamps=false;
13   /**  
14   * The attributes that should be cast to native types.
15   * 
16   * @var array
17   */
18   protected $casts=[
19     'id'=>'integer',
20     'ecommerce_order_state_id'=>'integer',
21     'contact_id'=>'integer',
22     'delivery_address_id'=>'integer',
23     'billing_address_id'=>'integer',
24     'ordered_at'=>'datetime',
25     'customer_note'=>'string',
26     'internal_note'=>'string'
27   ];
28   /**  
29   * The guarded property should contain an array of attributes that you do not want to be mass assignable.
30   * 
31   * @var array
32   */
33   protected $is_guarded=['internal_note'];
34   /**  
35   * The attributes that are mass assignable.
36   * 
37   * @var array
38   */
39   protected $is_fillable=[
40     'id',
41     'ecommerce_order_state_id',
42     'contact_id',
43     'delivery_address_id',
44     'billing_address_id',
45     'ordered_at',
46     'customer_note'
47   ];
48   public function Contact()
49   {
50     return $this->belongsTo('\App\Models\Contact','contact_id','id');
51   }
52   public function DeliveryAddress()
53   {
54     return $this->belongsTo('\App\Models\Address','delivery_address_id','id');
55   }
56   public function BillingAddress()
57   {
58     return $this->belongsTo('\App\Models\Address','billing_address_id','id');
59   }
60   public function OrderItem()
61   {
62     return $this->hasMany('\App\Models\EcommerceOrderItem','ecommerce_order_id','id');
63   }
64   public function OrderSimpleItem()
65   {
66     return $this->hasMany('\App\Models\EcommerceOrderSimpleItem','ecommerce_order_id','id');
67   }
68 }
69 

1 <?php
2 namespace App\Models;
3  
4 class EcommerceOrder extends \App\Models\Base\EcommerceOrder
5 {
6 }
7