The followings are the available columns in table 'geo_zone':
public function run()
{
$this->trancate();
$geoZoneWithFPA23 = GeoZone::whereName("Geo Zone with FPA 23%")->first();
$geoZoneWithFPA8 = GeoZone::whereName("Geo Zone with FPA 8%")->first();
DB::table('tax_rates')->insert(array('name' => 'FPA 23%', 'geo_zone_id' => $geoZoneWithFPA23->id, 'rate' => 23));
DB::table('tax_rates')->insert(array('name' => 'FPA 8%', 'geo_zone_id' => $geoZoneWithFPA8->id, 'rate' => 8));
}
public function run()
{
$this->trancate();
$country = Country::whereName("Greece")->first();
$zoneAttica = Zone::whereName("Attica")->first();
$zoneIslands = Zone::whereName("Islands")->first();
$geoZoneWithFPA23 = GeoZone::whereName("Geo Zone with FPA 23%")->first();
$geoZoneWithFPA8 = GeoZone::whereName("Geo Zone with FPA 8%")->first();
DB::table('zones_to_geo_zones')->insert(array('zone_id' => $zoneAttica->id, 'geo_zone_id' => $geoZoneWithFPA23->id));
DB::table('zones_to_geo_zones')->insert(array('zone_id' => $zoneIslands->id, 'geo_zone_id' => $geoZoneWithFPA8->id));
}
public function actionIndex()
{
$geoZones = GeoZone::model()->findAll();
$this->render('index', array('geoZones' => $geoZones));
}
