94 lines
12 KiB
PHP
94 lines
12 KiB
PHP
<?php
|
|
|
|
use Illuminate\Database\Seeder;
|
|
use Illuminate\Support\Facades\DB;
|
|
use App\Libraries\UuidHelper;
|
|
|
|
class StationTableSeeder extends Seeder
|
|
{
|
|
/**
|
|
* Run the database seeds.
|
|
*
|
|
* @return void
|
|
*/
|
|
public function run()
|
|
{
|
|
|
|
DB::table('station')->truncate();
|
|
|
|
$uuid = new UuidHelper;
|
|
|
|
$data = array(
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1051", 'description' => "UNIOIL A.BONIFACIO NORTH BOUND", 'longitude' => 120.992098, 'latitude' => 14.640393, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1050", 'description' => "UNIOIL MAYON", 'longitude' => 120.9978924, 'latitude' => 14.6230785, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1030", 'description' => "UNIOIL SLEX MAKATI", 'longitude' => 121.0100972, 'latitude' => 14.549909, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1004", 'description' => "UNIOIL NAIA ROAD", 'longitude' => 120.9949992, 'latitude' => 14.5008563, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1033", 'description' => "UNIOIL F BLUMENTRITT SAN JUAN", 'longitude' => 121.026365, 'latitude' => 14.602951, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1013", 'description' => "UNIOIL AIRPORT RD PARANAQUE", 'longitude' => 120.994102, 'latitude' => 14.527216, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1019", 'description' => "UNIOIL SUCAT RD PARANAQUE", 'longitude' => 120.996661, 'latitude' => 14.481546, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1055", 'description' => "UNIOIL GEN TRIAS", 'longitude' => 120.940213, 'latitude' => 14.405903, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1045", 'description' => "UNIOIL BF RESORT DRIVE LPINAS", 'longitude' => 120.992731, 'latitude' => 14.4439, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1054", 'description' => "UNIOIL CARMONA", 'longitude' => 14.288612, 'latitude' => 121.011742, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1023", 'description' => "UNIOIL MAKILING CALAMBA", 'longitude' => 121.138148, 'latitude' => 14.164657, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1027", 'description' => "UNIOIL BALANGA BATAAN", 'longitude' => 0, 'latitude' => 0, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1005", 'description' => "UNIOIL EDSA CALOOCAN", 'longitude' => 120.9904353, 'latitude' => 14.6573851, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1029", 'description' => "UNIOIL CONGRESSIONAL AVENUE", 'longitude' => 121.047271, 'latitude' => 14.672642, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1021", 'description' => "UNIOIL MINDANAO AVENUE 2", 'longitude' => 121.019763, 'latitude' => 14.694977, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1009", 'description' => "UNIOIL REGALADO FAIRVIEW", 'longitude' => 121.0612474, 'latitude' => 14.724898, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1010", 'description' => "UNIOIL FB HARRISON", 'longitude' => 120.991324, 'latitude' => 14.555401, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1040", 'description' => "UNIOIL BUENDIA AVENUE", 'longitude' => 121.002875, 'latitude' => 14.5557, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1024", 'description' => "UNIOIL SAN GUILLERMO", 'longitude' => 121.066386, 'latitude' => 14.554207, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1018", 'description' => "UNIOIL ORTIGAS EXTENSION", 'longitude' => 121.096902, 'latitude' => 14.589869, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1044", 'description' => "UNIOIL SANTA MESA", 'longitude' => 121.0825902, 'latitude' => 14.6344891, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1041", 'description' => "UNIOIL MEXICO PAMPANGA", 'longitude' => 120.702529, 'latitude' => 15.05112, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1068", 'description' => "UNIOIL DOLORES", 'longitude' => 120.674318, 'latitude' => 15.043945, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1003", 'description' => "UNIOIL SINGALONG", 'longitude' => 121.037499, 'latitude' => 14.58962, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1042", 'description' => "UNIOIL NAVOTAS", 'longitude' => 120.957621, 'latitude' => 14.640219, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1015", 'description' => "UNIOIL PANDACAN MANILA", 'longitude' => 121.001881, 'latitude' => 14.583601, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1031", 'description' => "UNIOIL COMMONWEALTH AVENUE", 'longitude' => 121.077101, 'latitude' => 14.704777, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1022", 'description' => "UNIOIL NOVALICHES QC", 'longitude' => 121.077101, 'latitude' => 14.704777, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1049", 'description' => "UNIOIL VALENZUELA", 'longitude' => 120.995159, 'latitude' => 14.704751, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1047", 'description' => "UNIOIL MEYCAUAYAN", 'longitude' => 120.995159, 'latitude' => 14.704751, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1060", 'description' => "UNIOIL MAKATI AVE.", 'longitude' => 121.030479, 'latitude' => 14.567192, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1017", 'description' => "UNIOIL ORTIGAS EXTENSION CAINTA", 'longitude' => 121.125456, 'latitude' => 14.583099, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1052", 'description' => "UNIOIL A.BONIFACIO SOUTH BOUND", 'longitude' => 121.407759, 'latitude' => 14.13275, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1067", 'description' => "UNIOIL SOUTHMALL LAS PINAS", 'longitude' => 121.012161, 'latitude' => 14.434301, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1062", 'description' => "UNIOIL E. RODRIGUEZ", 'longitude' => 121.033821, 'latitude' => 14.624307, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1048", 'description' => "UNIOIL V. LUNA", 'longitude' => 121.049203, 'latitude' => 14.6375, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1056", 'description' => "UNIOIL WEST AVENUE", 'longitude' => 121.02761, 'latitude' => 14.644908, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1028", 'description' => "UNIOIL KALAYAAN QC", 'longitude' => 121.054791, 'latitude' => 14.641948, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "UPPI", 'description' => "UNIOIL PETROLEUM PHILIPPINES INC.", 'longitude' => 0, 'latitude' => 0, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1046", 'description' => "UNIOIL ESR BICUTAN", 'longitude' => 121.045656, 'latitude' => 14.477386, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1020", 'description' => "UNIOIL ANABU 1 IMUS", 'longitude' => 120.939667, 'latitude' => 14.386135, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1032", 'description' => "UNIOIL MINDANAO AVENUE 1", 'longitude' => 121.032384, 'latitude' => 14.675889, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1026", 'description' => "UNIOIL EDSA BANSALANGIN", 'longitude' => 121.033821, 'latitude' => 14.624307, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1014", 'description' => "UNIOIL ANABU 2 IMUS", 'longitude' => 120.939689, 'latitude' => 14.389572, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1057", 'description' => "UNIOIL BARANGKA MARIKINA", 'longitude' => 121.083481, 'latitude' => 14.632964, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1059", 'description' => "UNIOIL SHAW BLVD.", 'longitude' => 121.037499, 'latitude' => 14.58962, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1053", 'description' => "UNIOIL SILANG 2", 'longitude' => 120.956839, 'latitude' => 14.132252, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1061", 'description' => "UNIOIL VITO CRUZ", 'longitude' => 121.037499, 'latitude' => 14.567192, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1016", 'description' => "UNIOIL FLORIDA BLANCA", 'longitude' => 120.504484, 'latitude' => 14.980026, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1006", 'description' => "UNIOIL GAPAN NUEVA ECIJA", 'longitude' => 120.948339, 'latitude' => 15.279713, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1036", 'description' => "UNIOIL CAVINTI LAGUNA", 'longitude' => 121.487034, 'latitude' => 14.233641, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1008", 'description' => "UNIOIL NAGCARLAN LAGUNA", 'longitude' => 0, 'latitude' => 0, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1012", 'description' => "UNIOIL SAN NICOLAS BACOOR", 'longitude' => 120.974799, 'latitude' => 14.429098, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1001", 'description' => "UNIOIL QUEZON AVENUE", 'longitude' => 121.005409, 'latitude' => 14.621561, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1011", 'description' => "UNIOIL SILANG CAVITE", 'longitude' => 120.975415, 'latitude' => 14.24422, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1000", 'description' => "UNIOIL - TESTER", 'longitude' => 0, 'latitude' => 0, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "SMS", 'description' => "SMS", 'longitude' => 0, 'latitude' => 0, 'is_viewable' => 0),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1065", 'description' => "UNIOIL EDSA GUADALUPE", 'longitude' => 121.040712, 'latitude' => 14.559526, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1025", 'description' => "UNIOIL PULILAN", 'longitude' => 120.990427, 'latitude' => 14.657546, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1035", 'description' => "UNIOIL VERMONT", 'longitude' => 121.094831, 'latitude' => 14.6232028, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1038", 'description' => "UNIOIL BUENDIA PASAY", 'longitude' => 120.9912174, 'latitude' => 14.553143, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1007", 'description' => "UNIOIL CONCEPCION MARIKINA", 'longitude' => 121.107028, 'latitude' => 14.650903, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1064", 'description' => "UNIOIL CONGRESSIONAL 2", 'longitude' => 121.0209062, 'latitude' => 14.6299896, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "WEB", 'description' => "WEB", 'longitude' => 0, 'latitude' => 0, 'is_viewable' => 0),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "1058", 'description' => "UNIOIL KATIPUNAN", 'longitude' => 0, 'latitude' => 0, 'is_viewable' => 1),
|
|
array( 'station_uuid' => $uuid->generate_uuid1(), 'code' => "APP", 'description' => "APP", 'longitude' => 0, 'latitude' => 0, 'is_viewable' => 0)
|
|
);
|
|
|
|
DB::table('station')->insert($data);
|
|
}
|
|
}
|
|
|