<?php

use Illuminate\Database\Seeder;
use Illuminate\Support\Facades\DB;

class ServiceChargesSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        DB::table('academy_purchases')
            ->update([
                'subtotal' => DB::raw('price')
            ]);
        DB::table('orders')
            ->update([
                'subtotal' => DB::raw('total_price - service_charge - cost_delivery')
            ]);
        DB::table('ticket_mains')
            ->update([
                'subtotal' => DB::raw('total')
            ]);
    }
}