public function run () { DB::table('districts')->delete(); District::create([ 'cname' => '黄浦区', 'ename' => 'HuangPu District', 'code' => 1, 'city_id' => 1, 'active' => 1 ]); District::create([ 'cname' => '浦东新区', 'ename' => 'HuangPu District', 'code' => 2, 'city_id' => 1, 'active' => 1 ]); }
/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function postStore(Request $request) { if (District::create($request->all())) { return $this->getIndex(); } else { return $this->errorCreated(); } }
/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { District::create($request->all()); }
/** * static function to read the xls and store * * @param int $id * @return Response*/ public static function import_xls($pathname, $state_id) { Excel::load($pathname, function ($reader) { // Getting all results $results = $reader->get(); foreach ($results as $result) { //checking existing Ditrict in db if ($result->district != '') { $state = State::where('state', $result->state)->first(); $statesave['state'] = $result->state; if ($state) { $state->fill($statesave); $state->save(); $stateid = $state->id; } else { $state = State::create($statesave); $stateid = $state->id; } // $save['district'] = $result->district; $save[$state_id] = $stateid; $district = District::where($state_id, $stateid)->where('district', $result->district)->first(); if ($district) { $district->fill($save); $district->save(); $districtid = $district->id; } else { $district = District::create($save); $districtid = $district->id; } $taluk = Taluk::where('district_id', $districtid)->where('taluk', $result->taluk)->first(); // $savet['taluk'] = $result->taluk; $savet['district_id'] = $districtid; $savevillage['district_id'] = $districtid; if ($taluk) { $taluk->fill($savet); $taluk->save(); $lastid = $taluk->id; } else { $taluk = Taluk::create($savet); $lastid = $taluk->id; } $village = Village::where('district_id', $districtid)->where('taluk_id', $lastid)->where('village', $result->village)->first(); $savevillage['taluk_id'] = $lastid; $savevillage['village'] = $result->village; $savevillage['stcode'] = $result->stcode; $savevillage['dtcode'] = $result->dtcode; $savevillage['sector_id'] = $result->sector_id; $savevillage['sdtcode'] = $result->sdtcode; $savevillage['tvcode'] = $result->tvcode; $savevillage['population'] = $result->population; $savevillage['malepopulation'] = $result->malepopulation; $savevillage['femalepopulation'] = $result->femalepopulation; $latlong = static::geotag($result); if (!empty(@$latlong->results[0]->geometry->location->lat)) { $lat = $latlong->results[0]->geometry->location->lat; $lng = $latlong->results[0]->geometry->location->lng; $savevillage['geoPoint'] = DB::raw("GeomFromText('POINT({$lat} {$lng})' )"); } if ($village) { $village->fill($savevillage); $village->save(); } else { $village = Village::create($savevillage); } static::map_sector($result, $village); } unset($savevillage); unset($latlong); } }); }