static function saveLocal($request)
{
try {
\DB::beginTransaction();
if ($request->has('rfc_f')) {
$rfc = $request->rfc_f;
}
if ($request->has('rfc_m')) {
$rfc = $request->rfc_m;
}
$usuario = new User();
$usuario->correo = $request->correo;
$usuario->password = \Hash::make($request->password);
$usuario->tipo_usuarios_id = 1;
// usuario tipo empresario
$usuario->save();
$empresario = new Empresario();
$empresario->nombre_completo = $request->nombre_completo;
$empresario->telefono = $request->telefono;
$empresario->celular = $request->celular;
$empresario->usuarios_id = $usuario->id;
$empresario->save();
$local = new Local();
$local->nombre_local = $request->nombre_local;
$local->razon_social = $request->razon_social;
$local->domicilio = $request->domicilio;
$local->codigo_postal = $request->codigo_postal;
$local->descripcion = $request->descripcion;
$local->numero_ext = $request->numero_ext;
$local->numero_int = $request->numero_int;
$local->colonia = $request->colonia;
$local->latitud = $request->latitud;
$local->longitud = $request->longitud;
$local->rfc = $rfc;
$local->estatus_fiscal = $request->estatus_fiscal;
$local->referencia = $request->referencia;
$local->sitio_web = $request->sitio_web;
$local->facebook = $request->facebook;
$local->instagram = $request->instagram;
$local->whatsapp = $request->whatsapp;
$local->municipios_id = $request->municipio_id;
$local->perfil_empresario_id = $empresario->id;
$local->save();
\DB::commit();
return true;
} catch (Exception $ex) {
\DB::rollback();
return false;
}
}
/**
* Deletes a local from the database.
*
* @param $id - Id of the local to be deleted
* @return Response
* @throws ResourceNotFoundException
*/
public function delete($id)
{
$id = $this->filter->sanitize($id, 'int');
try {
$local = Local::findFirstOrFail(['id = ?0', 'bind' => [$id]]);
return $this->response($this->request, $local);
} catch (ResourceNotFoundException $e) {
return $e->returnResponse();
}
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Local::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['idlocal' => $this->idlocal]);
$query->andFilterWhere(['like', 'descricao', $this->descricao])->andFilterWhere(['like', 'latitude', $this->latitude])->andFilterWhere(['like', 'longitude', $this->longitude]);
return $dataProvider;
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
// $url = 'http://map.naver.com/search2/local.nhn?query='. urlencode('서울특별시+중구+애견호텔');
// $job = (new CollectionLocal($url));
// dispatch($job);
// return;
$this->comment("Collector job staring...");
$collect_local_main = '';
$collect_local_sub = '';
$collect_ord = 1;
$collect_url = array();
$collection = Collection::orderby('id', 'desc')->first();
if (empty($collection->id)) {
$local = Local::where('ord', 1)->first();
$collect_local_main = $local->main;
$collect_local_sub = $local->sub;
} else {
$local = Local::where('ord', '>', $collection->ord)->first();
if (empty($local->id)) {
$local = Local::where('ord', 1)->first();
}
$collect_local_main = $local->main;
$collect_local_sub = $local->sub;
$collect_ord = $local->ord;
}
//2분단위로 데이터 가져오기 실행
$keywordSets = Keyword::orderby('ord', 'asc')->get();
foreach ($keywordSets as $k => $value) {
$url = 'http://map.naver.com/search2/local.nhn?query=' . urlencode($collect_local_main . '+' . $collect_local_sub . '+' . $value->keyword);
$job = (new CollectionLocal($url))->delay($k * 120);
dispatch($job);
}
$collection = new Collection();
$collection->local_main = $collect_local_main;
$collection->local_sub = $collect_local_sub;
$collection->ord = $collect_ord;
$collection->save();
$this->comment("Collector : [" . $collect_local_main . "/" . $collect_local_sub . "]");
}
/**
* Updates an existing ItemProgramacao model.
* If update is successful, the browser will be redirected to the 'view' page.
* @param integer $id
* @return mixed
*/
public function actionUpdate($id)
{
$model = $this->findModel($id);
$this->autorizaUsuario($model->evento_idevento);
$arrayPalestrante = ArrayHelper::map(Palestrante::find()->all(), 'idPalestrante', 'nome');
$arrayLocal = ArrayHelper::map(Local::find()->all(), 'idlocal', 'descricao');
if ($model->load(Yii::$app->request->post()) && $model->save()) {
return $this->redirect(['index', 'idevento' => $model->evento_idevento]);
} else {
return $this->render('update', ['model' => $model, 'arrayLocal' => $arrayLocal, 'arrayPalestrante' => $arrayPalestrante]);
}
}
public static function GenerateFake($faker)
{
return ['user_id' => $faker->numberBetween($min = 1, $max = User::count()), 'local_id' => $faker->numberBetween($min = 1, $max = Local::count())];
}
public function getLocalSeatArray(Request $request)
{
$local_id = $request['local_id'];
$local = Local::find($local_id);
if (empty($local) || $local == null) {
return response()->json('invalid local id', 400);
}
$distribution = $local->distribution;
$arreglo = array();
for ($i = 1; $i <= $local->rows; $i++) {
$texto = '';
for ($j = 1; $j <= $local->columns; $j++) {
$dist = Distribution::where('row', $i)->where('column', $j)->where('local_id', $local_id)->get()->first();
if ($dist->seat) {
$texto = $texto . 'a';
} else {
$texto = $texto . '_';
}
}
array_push($arreglo, $texto);
}
return $arreglo;
}
public function nameMustBeUnique(FunctionalTester $I)
{
$this->model->name = Local::findFirst()->name;
$I->assertFalse($this->model->save());
}
public function getLocal()
{
return $this->hasOne(Local::className(), ['idlocal' => 'local_idlocal']);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getLocals()
{
return $this->hasMany(Local::className(), ['city_id' => 'id'])->where('status="ACTIVE"');
}
/**
* Finds the Local model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Local the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Local::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
public static function GenerateFake($faker)
{
return ['name' => $faker->sentence($nbWords = 6), 'desc' => $faker->text($maxNbChars = 200), 'photo_cover' => $faker->imageUrl($width = 640, $height = 480), 'start_date' => $faker->dateTime($min = 'now')->format('Y-m-d h:m:s'), 'end_date' => $faker->dateTime($min = 'now')->format('Y-m-d h:m:s'), 'flyer' => $faker->imageUrl($width = 640, $height = 480), 'local_id' => $faker->numberBetween($min = 1, $max = Local::count()), 'guestList_id' => $faker->optional()->numberBetween($min = 1, $max = GuestList::count()), 'scheduling_id' => $faker->optional()->numberBetween($min = 1, $max = Scheduling::count())];
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Model::unguard();
$lipsum = new LoremIpsumGenerator();
Role::create(['title' => 'Administrator', 'slug' => 'admin']);
Role::create(['title' => 'User', 'slug' => 'user']);
User::create(['username' => 'Master', 'email' => '*****@*****.**', 'password' => bcrypt('master1234'), 'seen' => true, 'role_id' => 1, 'confirmed' => true]);
Version::create(['app' => '0.1.1', 'data' => '0.1.1']);
// collection keyword insert
Keyword::create(['keyword' => '동물병원', 'ord' => 1]);
Keyword::create(['keyword' => '애견용품', 'ord' => 2]);
Keyword::create(['keyword' => '애견카페', 'ord' => 3]);
Keyword::create(['keyword' => '애견펜션', 'ord' => 4]);
Keyword::create(['keyword' => '애견분양', 'ord' => 5]);
Keyword::create(['keyword' => '애견운동장', 'ord' => 6]);
Keyword::create(['keyword' => '애견미용', 'ord' => 7]);
Keyword::create(['keyword' => '애견호텔', 'ord' => 8]);
// collection local insert
// 서울
Local::create(['main' => '서울특별시', 'sub' => '종로구', 'ord' => 1]);
Local::create(['main' => '서울특별시', 'sub' => '중구', 'ord' => 2]);
Local::create(['main' => '서울특별시', 'sub' => '용산구', 'ord' => 3]);
Local::create(['main' => '서울특별시', 'sub' => '성동구', 'ord' => 4]);
Local::create(['main' => '서울특별시', 'sub' => '광진구', 'ord' => 5]);
Local::create(['main' => '서울특별시', 'sub' => '동대문구', 'ord' => 6]);
Local::create(['main' => '서울특별시', 'sub' => '중랑구', 'ord' => 7]);
Local::create(['main' => '서울특별시', 'sub' => '성북구', 'ord' => 8]);
Local::create(['main' => '서울특별시', 'sub' => '강북구', 'ord' => 9]);
Local::create(['main' => '서울특별시', 'sub' => '도봉구', 'ord' => 10]);
Local::create(['main' => '서울특별시', 'sub' => '노원구', 'ord' => 11]);
Local::create(['main' => '서울특별시', 'sub' => '은평구', 'ord' => 12]);
Local::create(['main' => '서울특별시', 'sub' => '서대문구', 'ord' => 13]);
Local::create(['main' => '서울특별시', 'sub' => '마포구', 'ord' => 14]);
Local::create(['main' => '서울특별시', 'sub' => '양천구', 'ord' => 15]);
Local::create(['main' => '서울특별시', 'sub' => '강서구', 'ord' => 16]);
Local::create(['main' => '서울특별시', 'sub' => '구로구', 'ord' => 17]);
Local::create(['main' => '서울특별시', 'sub' => '금천구', 'ord' => 18]);
Local::create(['main' => '서울특별시', 'sub' => '영등포구', 'ord' => 19]);
Local::create(['main' => '서울특별시', 'sub' => '동작구', 'ord' => 20]);
Local::create(['main' => '서울특별시', 'sub' => '관악구', 'ord' => 21]);
Local::create(['main' => '서울특별시', 'sub' => '서초구', 'ord' => 22]);
Local::create(['main' => '서울특별시', 'sub' => '강남구', 'ord' => 23]);
Local::create(['main' => '서울특별시', 'sub' => '송파구', 'ord' => 24]);
Local::create(['main' => '서울특별시', 'sub' => '강동구', 'ord' => 25]);
// 강원
Local::create(['main' => '강원도', 'sub' => '춘천시', 'ord' => 26]);
Local::create(['main' => '강원도', 'sub' => '원주시', 'ord' => 27]);
Local::create(['main' => '강원도', 'sub' => '강릉시', 'ord' => 28]);
Local::create(['main' => '강원도', 'sub' => '동해시', 'ord' => 29]);
Local::create(['main' => '강원도', 'sub' => '태백시', 'ord' => 30]);
Local::create(['main' => '강원도', 'sub' => '속초시', 'ord' => 31]);
Local::create(['main' => '강원도', 'sub' => '삼척시', 'ord' => 32]);
Local::create(['main' => '강원도', 'sub' => '홍천군', 'ord' => 33]);
Local::create(['main' => '강원도', 'sub' => '횡성군', 'ord' => 34]);
Local::create(['main' => '강원도', 'sub' => '영월군', 'ord' => 35]);
Local::create(['main' => '강원도', 'sub' => '평창군', 'ord' => 36]);
Local::create(['main' => '강원도', 'sub' => '정선군', 'ord' => 37]);
Local::create(['main' => '강원도', 'sub' => '철원군', 'ord' => 38]);
Local::create(['main' => '강원도', 'sub' => '화천군', 'ord' => 39]);
Local::create(['main' => '강원도', 'sub' => '양구군', 'ord' => 40]);
Local::create(['main' => '강원도', 'sub' => '인제군', 'ord' => 41]);
Local::create(['main' => '강원도', 'sub' => '고성군', 'ord' => 42]);
Local::create(['main' => '강원도', 'sub' => '양양군', 'ord' => 43]);
// 경기
Local::create(['main' => '경기도', 'sub' => '장안군', 'ord' => 44]);
Local::create(['main' => '경기도', 'sub' => '권선구', 'ord' => 45]);
Local::create(['main' => '경기도', 'sub' => '팔달구', 'ord' => 46]);
Local::create(['main' => '경기도', 'sub' => '영통구', 'ord' => 47]);
Local::create(['main' => '경기도', 'sub' => '수정구', 'ord' => 48]);
Local::create(['main' => '경기도', 'sub' => '중원구', 'ord' => 49]);
Local::create(['main' => '경기도', 'sub' => '분당구', 'ord' => 50]);
Local::create(['main' => '경기도', 'sub' => '의정부시', 'ord' => 51]);
Local::create(['main' => '경기도', 'sub' => '만안구', 'ord' => 52]);
Local::create(['main' => '경기도', 'sub' => '동안구', 'ord' => 53]);
Local::create(['main' => '경기도', 'sub' => '원미구', 'ord' => 54]);
Local::create(['main' => '경기도', 'sub' => '소사구', 'ord' => 55]);
Local::create(['main' => '경기도', 'sub' => '오정구', 'ord' => 56]);
Local::create(['main' => '경기도', 'sub' => '광명시', 'ord' => 57]);
Local::create(['main' => '경기도', 'sub' => '평택시', 'ord' => 58]);
Local::create(['main' => '경기도', 'sub' => '동두천시', 'ord' => 59]);
Local::create(['main' => '경기도', 'sub' => '상록구', 'ord' => 60]);
Local::create(['main' => '경기도', 'sub' => '단원구', 'ord' => 61]);
Local::create(['main' => '경기도', 'sub' => '덕양구', 'ord' => 62]);
Local::create(['main' => '경기도', 'sub' => '일산동구', 'ord' => 63]);
Local::create(['main' => '경기도', 'sub' => '일산서구', 'ord' => 64]);
Local::create(['main' => '경기도', 'sub' => '과천시', 'ord' => 65]);
Local::create(['main' => '경기도', 'sub' => '구리시', 'ord' => 66]);
Local::create(['main' => '경기도', 'sub' => '남양주시', 'ord' => 67]);
Local::create(['main' => '경기도', 'sub' => '오산시', 'ord' => 68]);
Local::create(['main' => '경기도', 'sub' => '시흥시', 'ord' => 69]);
Local::create(['main' => '경기도', 'sub' => '군포시', 'ord' => 70]);
Local::create(['main' => '경기도', 'sub' => '의왕시', 'ord' => 71]);
Local::create(['main' => '경기도', 'sub' => '하남시', 'ord' => 72]);
Local::create(['main' => '경기도', 'sub' => '처인구', 'ord' => 73]);
Local::create(['main' => '경기도', 'sub' => '기흥구', 'ord' => 74]);
Local::create(['main' => '경기도', 'sub' => '수지구', 'ord' => 75]);
Local::create(['main' => '경기도', 'sub' => '파주시', 'ord' => 76]);
Local::create(['main' => '경기도', 'sub' => '이천시', 'ord' => 77]);
Local::create(['main' => '경기도', 'sub' => '안성시', 'ord' => 78]);
Local::create(['main' => '경기도', 'sub' => '김포시', 'ord' => 79]);
Local::create(['main' => '경기도', 'sub' => '화성시', 'ord' => 80]);
Local::create(['main' => '경기도', 'sub' => '광주시', 'ord' => 81]);
Local::create(['main' => '경기도', 'sub' => '양주시', 'ord' => 82]);
Local::create(['main' => '경기도', 'sub' => '포천시', 'ord' => 83]);
Local::create(['main' => '경기도', 'sub' => '여주시', 'ord' => 84]);
Local::create(['main' => '경기도', 'sub' => '연천군', 'ord' => 85]);
Local::create(['main' => '경기도', 'sub' => '가평군', 'ord' => 86]);
Local::create(['main' => '경기도', 'sub' => '양평군', 'ord' => 87]);
Local::create(['main' => '경상북도', 'sub' => '남구', 'ord' => 88]);
Local::create(['main' => '경상북도', 'sub' => '북구', 'ord' => 89]);
Local::create(['main' => '경상북도', 'sub' => '경주시', 'ord' => 90]);
Local::create(['main' => '경상북도', 'sub' => '김천시', 'ord' => 91]);
Local::create(['main' => '경상북도', 'sub' => '안동시', 'ord' => 92]);
Local::create(['main' => '경상북도', 'sub' => '구미시', 'ord' => 93]);
Local::create(['main' => '경상북도', 'sub' => '영주시', 'ord' => 94]);
Local::create(['main' => '경상북도', 'sub' => '영천시', 'ord' => 95]);
Local::create(['main' => '경상북도', 'sub' => '상주시', 'ord' => 96]);
Local::create(['main' => '경상북도', 'sub' => '문경시', 'ord' => 97]);
Local::create(['main' => '경상북도', 'sub' => '경산시', 'ord' => 98]);
Local::create(['main' => '경상북도', 'sub' => '군위군', 'ord' => 99]);
Local::create(['main' => '경상북도', 'sub' => '의성군', 'ord' => 100]);
Local::create(['main' => '경상북도', 'sub' => '청송군', 'ord' => 101]);
Local::create(['main' => '경상북도', 'sub' => '영양군', 'ord' => 102]);
Local::create(['main' => '경상북도', 'sub' => '영덕군', 'ord' => 103]);
Local::create(['main' => '경상북도', 'sub' => '청도군', 'ord' => 104]);
Local::create(['main' => '경상북도', 'sub' => '고령군', 'ord' => 105]);
Local::create(['main' => '경상북도', 'sub' => '성주군', 'ord' => 106]);
Local::create(['main' => '경상북도', 'sub' => '칠곡군', 'ord' => 107]);
Local::create(['main' => '경상북도', 'sub' => '예천군', 'ord' => 108]);
Local::create(['main' => '경상북도', 'sub' => '봉화군', 'ord' => 109]);
Local::create(['main' => '경상북도', 'sub' => '울진군', 'ord' => 110]);
Local::create(['main' => '경상북도', 'sub' => '울릉군', 'ord' => 111]);
Local::create(['main' => '광주광역시', 'sub' => '동구', 'ord' => 112]);
Local::create(['main' => '광주광역시', 'sub' => '서구', 'ord' => 113]);
Local::create(['main' => '광주광역시', 'sub' => '남구', 'ord' => 114]);
Local::create(['main' => '광주광역시', 'sub' => '북구', 'ord' => 115]);
Local::create(['main' => '경상남도', 'sub' => '의창구', 'ord' => 116]);
Local::create(['main' => '경상남도', 'sub' => '성산구', 'ord' => 117]);
Local::create(['main' => '경상남도', 'sub' => '마산합포구', 'ord' => 118]);
Local::create(['main' => '경상남도', 'sub' => '마산회원구', 'ord' => 119]);
Local::create(['main' => '경상남도', 'sub' => '진해구', 'ord' => 120]);
Local::create(['main' => '경상남도', 'sub' => '진주시', 'ord' => 121]);
Local::create(['main' => '경상남도', 'sub' => '통영시', 'ord' => 122]);
Local::create(['main' => '경상남도', 'sub' => '사천시', 'ord' => 123]);
Local::create(['main' => '경상남도', 'sub' => '김해시', 'ord' => 124]);
Local::create(['main' => '경상남도', 'sub' => '밀양시', 'ord' => 125]);
Local::create(['main' => '경상남도', 'sub' => '거제시', 'ord' => 126]);
Local::create(['main' => '경상남도', 'sub' => '양산시', 'ord' => 127]);
Local::create(['main' => '경상남도', 'sub' => '의령군', 'ord' => 128]);
Local::create(['main' => '경상남도', 'sub' => '함안군', 'ord' => 129]);
Local::create(['main' => '경상남도', 'sub' => '창녕군', 'ord' => 130]);
Local::create(['main' => '경상남도', 'sub' => '고성군', 'ord' => 131]);
Local::create(['main' => '경상남도', 'sub' => '남해군', 'ord' => 132]);
Local::create(['main' => '경상남도', 'sub' => '하동군', 'ord' => 133]);
Local::create(['main' => '경상남도', 'sub' => '산청군', 'ord' => 134]);
Local::create(['main' => '경상남도', 'sub' => '함양군', 'ord' => 135]);
Local::create(['main' => '경상남도', 'sub' => '거창군', 'ord' => 136]);
Local::create(['main' => '경상남도', 'sub' => '합천군', 'ord' => 137]);
Local::create(['main' => '대구광역시', 'sub' => '중구', 'ord' => 138]);
Local::create(['main' => '대구광역시', 'sub' => '동구', 'ord' => 139]);
Local::create(['main' => '대구광역시', 'sub' => '서구', 'ord' => 140]);
Local::create(['main' => '대구광역시', 'sub' => '남구', 'ord' => 141]);
Local::create(['main' => '대구광역시', 'sub' => '북구', 'ord' => 142]);
Local::create(['main' => '대구광역시', 'sub' => '수성구', 'ord' => 143]);
Local::create(['main' => '대구광역시', 'sub' => '달서구', 'ord' => 144]);
Local::create(['main' => '대구광역시', 'sub' => '달성군', 'ord' => 145]);
Local::create(['main' => '대전광역시', 'sub' => '동구', 'ord' => 146]);
Local::create(['main' => '대전광역시', 'sub' => '중구', 'ord' => 147]);
Local::create(['main' => '대전광역시', 'sub' => '서구', 'ord' => 148]);
Local::create(['main' => '대전광역시', 'sub' => '유성구', 'ord' => 149]);
Local::create(['main' => '대전광역시', 'sub' => '대덕구', 'ord' => 150]);
Local::create(['main' => '부산광역시', 'sub' => '중구', 'ord' => 151]);
Local::create(['main' => '부산광역시', 'sub' => '서구', 'ord' => 152]);
Local::create(['main' => '부산광역시', 'sub' => '동구', 'ord' => 153]);
Local::create(['main' => '부산광역시', 'sub' => '영도구', 'ord' => 154]);
Local::create(['main' => '부산광역시', 'sub' => '부산진구', 'ord' => 155]);
Local::create(['main' => '부산광역시', 'sub' => '동래구', 'ord' => 156]);
Local::create(['main' => '부산광역시', 'sub' => '남구', 'ord' => 157]);
Local::create(['main' => '부산광역시', 'sub' => '북구', 'ord' => 158]);
Local::create(['main' => '부산광역시', 'sub' => '해운대구', 'ord' => 159]);
Local::create(['main' => '부산광역시', 'sub' => '사하구', 'ord' => 160]);
Local::create(['main' => '부산광역시', 'sub' => '금정구', 'ord' => 161]);
Local::create(['main' => '부산광역시', 'sub' => '강서구', 'ord' => 162]);
Local::create(['main' => '부산광역시', 'sub' => '연제구', 'ord' => 163]);
Local::create(['main' => '부산광역시', 'sub' => '수영구', 'ord' => 164]);
Local::create(['main' => '부산광역시', 'sub' => '사상구', 'ord' => 165]);
Local::create(['main' => '부산광역시', 'sub' => '기장군', 'ord' => 166]);
Local::create(['main' => '울산광역시', 'sub' => '중구', 'ord' => 167]);
Local::create(['main' => '울산광역시', 'sub' => '남구', 'ord' => 168]);
Local::create(['main' => '울산광역시', 'sub' => '동구', 'ord' => 169]);
Local::create(['main' => '울산광역시', 'sub' => '북구', 'ord' => 170]);
Local::create(['main' => '울산광역시', 'sub' => '울주군', 'ord' => 171]);
Local::create(['main' => '인천광역시', 'sub' => '중구', 'ord' => 172]);
Local::create(['main' => '인천광역시', 'sub' => '동구', 'ord' => 173]);
Local::create(['main' => '인천광역시', 'sub' => '남구', 'ord' => 174]);
Local::create(['main' => '인천광역시', 'sub' => '연수구', 'ord' => 175]);
Local::create(['main' => '인천광역시', 'sub' => '남동구', 'ord' => 176]);
Local::create(['main' => '인천광역시', 'sub' => '부평구', 'ord' => 177]);
Local::create(['main' => '인천광역시', 'sub' => '계양구', 'ord' => 178]);
Local::create(['main' => '인천광역시', 'sub' => '서구', 'ord' => 179]);
Local::create(['main' => '인천광역시', 'sub' => '강화군', 'ord' => 180]);
Local::create(['main' => '인천광역시', 'sub' => '옹진군', 'ord' => 181]);
Local::create(['main' => '전라남도', 'sub' => '목포시', 'ord' => 182]);
Local::create(['main' => '전라남도', 'sub' => '여수시', 'ord' => 183]);
Local::create(['main' => '전라남도', 'sub' => '순천시', 'ord' => 184]);
Local::create(['main' => '전라남도', 'sub' => '나주시', 'ord' => 185]);
Local::create(['main' => '전라남도', 'sub' => '광양시', 'ord' => 186]);
Local::create(['main' => '전라남도', 'sub' => '담양군', 'ord' => 187]);
Local::create(['main' => '전라남도', 'sub' => '곡성군', 'ord' => 188]);
Local::create(['main' => '전라남도', 'sub' => '구례군', 'ord' => 189]);
Local::create(['main' => '전라남도', 'sub' => '고흥군', 'ord' => 190]);
Local::create(['main' => '전라남도', 'sub' => '보성군', 'ord' => 191]);
Local::create(['main' => '전라남도', 'sub' => '화순군', 'ord' => 192]);
Local::create(['main' => '전라남도', 'sub' => '장흥군', 'ord' => 193]);
Local::create(['main' => '전라남도', 'sub' => '강진군', 'ord' => 194]);
Local::create(['main' => '전라남도', 'sub' => '해남군', 'ord' => 195]);
Local::create(['main' => '전라남도', 'sub' => '영암군', 'ord' => 196]);
Local::create(['main' => '전라남도', 'sub' => '무안군', 'ord' => 197]);
Local::create(['main' => '전라남도', 'sub' => '함평군', 'ord' => 198]);
Local::create(['main' => '전라남도', 'sub' => '영광군', 'ord' => 199]);
Local::create(['main' => '전라남도', 'sub' => '장성군', 'ord' => 200]);
Local::create(['main' => '전라남도', 'sub' => '완도군', 'ord' => 201]);
Local::create(['main' => '전라남도', 'sub' => '진도군', 'ord' => 202]);
Local::create(['main' => '전라남도', 'sub' => '신안군', 'ord' => 203]);
Local::create(['main' => '전라북도', 'sub' => '완산구', 'ord' => 204]);
Local::create(['main' => '전라북도', 'sub' => '덕진구', 'ord' => 205]);
Local::create(['main' => '전라북도', 'sub' => '군산시', 'ord' => 206]);
Local::create(['main' => '전라북도', 'sub' => '익산시', 'ord' => 207]);
Local::create(['main' => '전라북도', 'sub' => '정읍시', 'ord' => 208]);
Local::create(['main' => '전라북도', 'sub' => '남원시', 'ord' => 209]);
Local::create(['main' => '전라북도', 'sub' => '김제시', 'ord' => 210]);
Local::create(['main' => '전라북도', 'sub' => '완주군', 'ord' => 211]);
Local::create(['main' => '전라북도', 'sub' => '진안군', 'ord' => 212]);
Local::create(['main' => '전라북도', 'sub' => '무주군', 'ord' => 213]);
Local::create(['main' => '전라북도', 'sub' => '장수군', 'ord' => 214]);
Local::create(['main' => '전라북도', 'sub' => '임실군', 'ord' => 215]);
Local::create(['main' => '전라북도', 'sub' => '순창군', 'ord' => 216]);
Local::create(['main' => '전라북도', 'sub' => '고창군', 'ord' => 217]);
Local::create(['main' => '전라북도', 'sub' => '부안군', 'ord' => 218]);
Local::create(['main' => '제주특별자치도', 'sub' => '제주시', 'ord' => 219]);
Local::create(['main' => '제주특별자치도', 'sub' => '서귀포시', 'ord' => 220]);
Local::create(['main' => '충청남도', 'sub' => '동남구', 'ord' => 221]);
Local::create(['main' => '충청남도', 'sub' => '서북구', 'ord' => 222]);
Local::create(['main' => '충청남도', 'sub' => '공주시', 'ord' => 223]);
Local::create(['main' => '충청남도', 'sub' => '보령시', 'ord' => 224]);
Local::create(['main' => '충청남도', 'sub' => '아산시', 'ord' => 225]);
Local::create(['main' => '충청남도', 'sub' => '서산시', 'ord' => 226]);
Local::create(['main' => '충청남도', 'sub' => '논산시', 'ord' => 227]);
Local::create(['main' => '충청남도', 'sub' => '계룡시', 'ord' => 228]);
Local::create(['main' => '충청남도', 'sub' => '당진시', 'ord' => 229]);
Local::create(['main' => '충청남도', 'sub' => '금산군', 'ord' => 230]);
Local::create(['main' => '충청남도', 'sub' => '부여군', 'ord' => 231]);
Local::create(['main' => '충청남도', 'sub' => '서천군', 'ord' => 232]);
Local::create(['main' => '충청남도', 'sub' => '청양군', 'ord' => 233]);
Local::create(['main' => '충청남도', 'sub' => '홍성군', 'ord' => 234]);
Local::create(['main' => '충청남도', 'sub' => '예산군', 'ord' => 235]);
Local::create(['main' => '충청남도', 'sub' => '태안군', 'ord' => 236]);
Local::create(['main' => '충청북도', 'sub' => '상당구', 'ord' => 237]);
Local::create(['main' => '충청북도', 'sub' => '서원구', 'ord' => 238]);
Local::create(['main' => '충청북도', 'sub' => '흥덕구', 'ord' => 239]);
Local::create(['main' => '충청북도', 'sub' => '청원구', 'ord' => 240]);
Local::create(['main' => '충청북도', 'sub' => '충주시', 'ord' => 241]);
Local::create(['main' => '충청북도', 'sub' => '제천시', 'ord' => 242]);
Local::create(['main' => '충청북도', 'sub' => '보은군', 'ord' => 243]);
Local::create(['main' => '충청북도', 'sub' => '옥천군', 'ord' => 244]);
Local::create(['main' => '충청북도', 'sub' => '영동군', 'ord' => 245]);
Local::create(['main' => '충청북도', 'sub' => '증평군', 'ord' => 246]);
Local::create(['main' => '충청북도', 'sub' => '진천군', 'ord' => 247]);
Local::create(['main' => '충청북도', 'sub' => '괴산군', 'ord' => 248]);
Local::create(['main' => '충청북도', 'sub' => '음성군', 'ord' => 249]);
Local::create(['main' => '충청북도', 'sub' => '단양군', 'ord' => 250]);
Local::create(['main' => '세종특별자치시', 'sub' => '나성동', 'ord' => 251]);
Local::create(['main' => '세종특별자치시', 'sub' => '어진동', 'ord' => 252]);
Local::create(['main' => '세종특별자치시', 'sub' => '종촌동', 'ord' => 253]);
Local::create(['main' => '세종특별자치시', 'sub' => '고운동', 'ord' => 254]);
Local::create(['main' => '세종특별자치시', 'sub' => '아름동', 'ord' => 255]);
Local::create(['main' => '세종특별자치시', 'sub' => '도담동', 'ord' => 256]);
Local::create(['main' => '세종특별자치시', 'sub' => '조치원읍', 'ord' => 257]);
Local::create(['main' => '세종특별자치시', 'sub' => '금남면', 'ord' => 258]);
Local::create(['main' => '세종특별자치시', 'sub' => '장군면', 'ord' => 259]);
Local::create(['main' => '세종특별자치시', 'sub' => '전의면', 'ord' => 260]);
Local::create(['main' => '세종특별자치시', 'sub' => '전동면', 'ord' => 261]);
}
public function afterFind()
{
$this->idLocalbkp = $this->idLocal;
return $this->idLocal = Local::findOne($this->idLocal)->Nome;
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Local::insert(['name' => 'Explanada del Jockey', 'capacity' => 400, 'address' => 'Calle uno 862', 'district' => 'San Borja', 'province' => 'Lima', 'state' => 'Lima', 'image' => 'images/examples/map1.PNG', 'rows' => null, 'columns' => null]);
Local::insert(['name' => 'Maria Angola', 'capacity' => 100, 'address' => 'Av. Gregorio Escobedo 450', 'district' => 'Miraflores', 'province' => 'Lima', 'state' => 'Lima', 'image' => 'images/examples/map1.PNG', 'rows' => 10, 'columns' => 10]);
}
/**
* Updates an existing Evento model.
* If update is successful, the browser will be redirected to the 'view' page.
* @param string $id
* @return mixed
*/
public function actionUpdate($id)
{
$this->autorizaUsuario();
$model = $this->findModel($id);
!$model->canAccess() ? $this->redirect(['evento/index']) : ($imagem = $model->imagem2);
$arrayPalestrante = ArrayHelper::map(Palestrante::find()->all(), 'idPalestrante', 'nome');
$arrayLocal = ArrayHelper::map(Local::find()->all(), 'idlocal', 'descricao');
$arrayTipo = ArrayHelper::map(Tipo::find()->all(), 'idtipo', 'titulo');
if ($model->load(Yii::$app->request->post())) {
$model->imagem2 = $model->upload(UploadedFile::getInstance($model, 'imagem2'), 'uploads/identidade/');
if ($model->imagem2 == null) {
$model->imagem2 = $imagem;
}
if (!$model->save(true)) {
return $this->render('update', ['model' => $model, 'arrayTipo' => $arrayTipo, 'arrayLocal' => $arrayLocal, 'arrayPalestrante' => $arrayPalestrante]);
}
$this->mensagens('success', 'Evento Atualizado', 'Evento atualizado com Sucesso');
return $this->redirect(['evento/identidade', 'idevento' => $model->idevento]);
} else {
return $this->render('update', ['model' => $model, 'arrayTipo' => $arrayTipo, 'arrayLocal' => $arrayLocal, 'arrayPalestrante' => $arrayPalestrante]);
}
}
