<?php

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

class ServientregaServiceFixPrices extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        // Nacional 15000
        DB::table('servientrega_cities')->update(['price' => 15000]);

        // Zonal 13000
        DB::table('servientrega_cities')
            ->where('administrative_area_level_1', 'like', '%cundinamarca%')
            ->update(['price' => 13000]);

        DB::table('servientrega_cities')
            ->where('administrative_area_level_1', 'like', '%meta%')
            ->update(['price' => 13000]);

        // Urbano Bogotá 12000
        DB::table('servientrega_cities')
            ->where('administrative_area_level_2', 'like', '%bogota%')
            ->update(['price' => 12000]);

        // Trayecto Especial 30000
        $departments = ['amazonas', 'choco', 'guainia', 'guaviare', 'guajira', 'andres'];
        foreach ($departments as $department) {
            DB::table('servientrega_cities')
                ->where('administrative_area_level_1', 'like', '%' . $department . '%')
                ->update(['price' => 30000]);
        }
    }
}