public function index() { $category = Category::get(); $advertCountImoveis = AdvertImovel::count(); $advertCountVeiculos = AdvertImovel::count(); $advertCountTotal = Advert::count(); $imageCount = AdvertImage::count(); $userCount = User::count(); return view('site.pages.home', ['categories' => $category, 'advertCountImoveis' => $advertCountImoveis, 'advertCountTotal' => $advertCountTotal, 'advertCountVeiculos' => $advertCountVeiculos, 'imageCount' => $imageCount, 'userCount' => $userCount]); }
public function lerXML() { $user = Auth::user(); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $user->url_ValueGaia); curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); $content = curl_exec($ch); curl_close($ch); $xml = simplexml_load_string($content); if (!$xml) { //$request->session()->flash('alert-error', 'Anúncio editado com sucesso!'); return view('admin.principal.integracao', ['user' => $user, 'valida' => true]); } foreach ($xml->Imoveis->Imovel as $value) { $anuncio = Advert::where('origem_identificacao', '=', $value->CodigoCliente . $value->CodigoImovel . $value->CodigoImovelAuxiliar)->get(); if ($anuncio->count() > 0) { foreach ($anuncio as $anu) { //echo $anu->id."<br>".$anu->tipo_anuncio."<br>"; $anu->anuncio_titulo = $value->TituloImovel; $anu->anuncio_descricao = $value->Observacao; if ($anu->tipo_anuncio === "aluga") { $anu->preco = $value->PrecoLocacao; } else { $anu->preco = $value->PrecoVenda; } $anu->estado = $value->Estado; $anu->cidade = $value->Cidade; $anu->bairro = $value->Bairro; if (!empty($value->Endereco)) { $anu->active = 1; $anu->rua = $value->Endereco; $anu->numero = $value->Numero; } else { $anu->active = 0; } //$destaque, - verificar com o mauricio $subcategories_id = "20"; $tipo = (string) $value->TipoImovel; $tipo = trim($tipo); if ($tipo === 'Apartamento' || $tipo === 'Loft') { $subcategories_id = "10"; } else { if ($tipo === 'Área' || $tipo === 'Terreno' || $tipo === 'Galpão') { $subcategories_id = "30"; } else { if ($tipo === 'Casa' || $tipo === 'Sobrado' || $tipo === 'Barracão' || $tipo === 'Conjunto' || $tipo === 'Village' || $tipo === 'Laje') { $subcategories_id = "20"; } else { if ($tipo === 'Chácara' || $tipo === 'Fazenda' || $tipo === 'Fazenda Rural' || $tipo === 'Sítio' || $tipo === 'Bangalô' || $tipo === 'Rancho' || $tipo === 'Haras') { $subcategories_id = "60"; } else { if ($tipo === 'Ponto' || $tipo === 'Prédio' || $tipo === 'Sala' || $tipo === 'Salão' || $tipo === 'Loja' || $tipo === 'Studio') { $subcategories_id = "70"; } else { if ($tipo === 'Kitnet') { $subcategories_id = "107"; } else { if ($tipo === 'Flat') { $subcategories_id = "113"; } else { if ($tipo === 'Cobertura' || $tipo === 'Apartamento Duplex' || $tipo === 'Apartamento Triplex' || $tipo === 'Penthouse') { $subcategories_id = "101"; } else { if ($tipo === 'Pousada' || $tipo === 'Resort' || $tipo === 'Hotel' || $tipo === 'Ilha') { $subcategories_id = "90"; } } } } } } } } } $anu->subcategories_id = $subcategories_id; $anu->save(); $anu->advertImovel->numero_quarto = $value->QtdDormitorios; $anu->advertImovel->numero_garagem = $value->QtdVagas; $anu->advertImovel->numero_banheiro = $value->QtdBanheiros; $anu->advertImovel->area_construida = $value->AreaUtil; $anu->advertImovel->valor_iptu = $value->PrecoIptu; $anu->advertImovel->acomodacoes = $value->QtdDormitorios; $anu->advertImovel->save(); if (isset($value->Fotos)) { foreach ($anu->images as $img) { $img->delete(); } foreach ($value->Fotos->Foto as $va) { $extension = $va->URLArquivo; AdvertImage::create(['advert_id' => $anu->id, 'extension' => $extension]); } } $feature = array(); //DormitorioEmpregada - 8/10, 25/20, 102/80, 151/101 $Caracteristica = (string) $value->DormitorioEmpregada; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "10") { $feature[] = 8; } if ($subcategories_id === "20") { $feature[] = 25; } if ($subcategories_id === "80") { $feature[] = 102; } if ($subcategories_id === "101") { $feature[] = 151; } } //Sacada - 12/10, 29/20, 106/80, 155/101, 183/113 $Caracteristica = (string) $value->Sacada; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "10") { $feature[] = 12; } if ($subcategories_id === "20") { $feature[] = 29; } if ($subcategories_id === "80") { $feature[] = 106; } if ($subcategories_id === "101") { $feature[] = 155; } if ($subcategories_id === "113") { $feature[] = 183; } } //ArmarioDormitorio - 5/10, 22/20, 42/40, 62/50, 80/60, 99/80, 128/90, 148/101, 160/107, 179/113 $Caracteristica = (string) $value->ArmarioDormitorio; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "10") { $feature[] = 5; } if ($subcategories_id === "20") { $feature[] = 22; } if ($subcategories_id === "40") { $feature[] = 42; } if ($subcategories_id === "50") { $feature[] = 62; } if ($subcategories_id === "60") { $feature[] = 80; } if ($subcategories_id === "80") { $feature[] = 99; } if ($subcategories_id === "90") { $feature[] = 128; } if ($subcategories_id === "101") { $feature[] = 148; } if ($subcategories_id === "107") { $feature[] = 160; } if ($subcategories_id === "113") { $feature[] = 179; } } //Churrasqueira - 10/10, 27/20, 50/50, 74/60, 104/80, 121/90, 153/101 $Caracteristica = (string) $value->Churrasqueira; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "10") { $feature[] = 10; } if ($subcategories_id === "20") { $feature[] = 27; } if ($subcategories_id === "50") { $feature[] = 50; } if ($subcategories_id === "60") { $feature[] = 74; } if ($subcategories_id === "80") { $feature[] = 104; } if ($subcategories_id === "90") { $feature[] = 121; } if ($subcategories_id === "101") { $feature[] = 153; } } //Piscina - 7/10, 24/20, 44/40, 49/50, 73/60, 101/80, 123/90, 150/101, 169/108, 176/113 $Caracteristica = (string) $value->Piscina; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "10") { $feature[] = 7; } if ($subcategories_id === "20") { $feature[] = 24; } if ($subcategories_id === "40") { $feature[] = 44; } if ($subcategories_id === "50") { $feature[] = 49; } if ($subcategories_id === "60") { $feature[] = 73; } if ($subcategories_id === "80") { $feature[] = 101; } if ($subcategories_id === "90") { $feature[] = 123; } if ($subcategories_id === "101") { $feature[] = 150; } if ($subcategories_id === "108") { $feature[] = 169; } if ($subcategories_id === "113") { $feature[] = 176; } } //TVCabo - 41/40, 61/50, 79/60, 93/70, 127/90 $Caracteristica = (string) $value->TVCabo; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "40") { $feature[] = 41; } if ($subcategories_id === "50") { $feature[] = 61; } if ($subcategories_id === "60") { $feature[] = 79; } if ($subcategories_id === "70") { $feature[] = 93; } if ($subcategories_id === "90") { $feature[] = 127; } } //Varanda - 12/10, 29/20, 106/80, 155/101, 183/113 $Caracteristica = (string) $value->Varanda; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "10") { $feature[] = 12; } if ($subcategories_id === "20") { $feature[] = 29; } if ($subcategories_id === "80") { $feature[] = 106; } if ($subcategories_id === "101") { $feature[] = 155; } if ($subcategories_id === "113") { $feature[] = 183; } } //AreaServico - 6/10, 23/20, 43/40, 63/50, 81/60, 100/80, 149/101, 184/113 $Caracteristica = (string) $value->AreaServico; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "10") { $feature[] = 6; } if ($subcategories_id === "20") { $feature[] = 23; } if ($subcategories_id === "40") { $feature[] = 43; } if ($subcategories_id === "50") { $feature[] = 63; } if ($subcategories_id === "60") { $feature[] = 81; } if ($subcategories_id === "80") { $feature[] = 100; } if ($subcategories_id === "101") { $feature[] = 149; } if ($subcategories_id === "113") { $feature[] = 184; } } //CampoFutebol - 16/10, 110/80, 171/108 $Caracteristica = (string) $value->CampoFutebol; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "10") { $feature[] = 16; } if ($subcategories_id === "80") { $feature[] = 110; } if ($subcategories_id === "108") { $feature[] = 171; } } //Mobiliado - 48/50, 71/60, 91/70, 161/107, 180,113 $Caracteristica = (string) $value->Mobiliado; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "50") { $feature[] = 48; } if ($subcategories_id === "60") { $feature[] = 71; } if ($subcategories_id === "70") { $feature[] = 91; } if ($subcategories_id === "107") { $feature[] = 161; } if ($subcategories_id === "113") { $feature[] = 180; } } //Lareira - 138/90 $Caracteristica = (string) $value->Mobiliado; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "90") { $feature[] = 138; } } DB::delete('delete from advert_feature where advert_id = ' . $anu->id); if (!empty($feature)) { $anu->features()->sync($feature); } } } else { if (!empty($value->PrecoLocacao)) { //aluga $tipo_anuncio = "aluga"; $origem = "ValueGaia"; $origem_identificacao = $value->CodigoCliente . $value->CodigoImovel . $value->CodigoImovelAuxiliar; $anuncio_titulo = $value->TituloImovel; $anuncio_descricao = $value->Observacao; $preco = $value->PrecoLocacao; $url_anuncio = str_slug($value->TituloImovel); $estado = $value->Estado; $cidade = $value->Cidade; $bairro = $value->Bairro; if (!empty($value->Endereco)) { $active = 1; $rua = $value->Endereco; $numero = $value->Numero; } else { $active = 0; } //$destaque, - verificar com o mauricio $user_id = $user->id; $subcategories_id = "20"; $tipo = (string) $value->TipoImovel; $tipo = trim($tipo); if ($tipo === 'Apartamento' || $tipo === 'Loft') { $subcategories_id = "10"; } else { if ($tipo === 'Área' || $tipo === 'Terreno' || $tipo === 'Galpão') { $subcategories_id = "30"; } else { if ($tipo === 'Casa' || $tipo === 'Sobrado' || $tipo === 'Barracão' || $tipo === 'Conjunto' || $tipo === 'Village' || $tipo === 'Laje') { $subcategories_id = "20"; } else { if ($tipo === 'Chácara' || $tipo === 'Fazenda' || $tipo === 'Fazenda Rural' || $tipo === 'Sítio' || $tipo === 'Bangalô' || $tipo === 'Rancho' || $tipo === 'Haras') { $subcategories_id = "60"; } else { if ($tipo === 'Ponto' || $tipo === 'Prédio' || $tipo === 'Sala' || $tipo === 'Salão' || $tipo === 'Loja' || $tipo === 'Studio') { $subcategories_id = "70"; } else { if ($tipo === 'Kitnet') { $subcategories_id = "107"; } else { if ($tipo === 'Flat') { $subcategories_id = "113"; } else { if ($tipo === 'Cobertura' || $tipo === 'Apartamento Duplex' || $tipo === 'Apartamento Triplex' || $tipo === 'Penthouse') { $subcategories_id = "101"; } else { if ($tipo === 'Pousada' || $tipo === 'Resort' || $tipo === 'Hotel' || $tipo === 'Ilha') { $subcategories_id = "90"; } } } } } } } } } $advert = Advert::create(['user_id' => $user_id, 'subcategories_id' => $subcategories_id, 'tipo_anuncio' => $tipo_anuncio, 'origem' => $origem, 'origem_identificacao' => $origem_identificacao, 'estado' => $estado, 'cidade' => $cidade, 'bairro' => $bairro, 'rua' => $rua, 'numero' => $numero, 'anuncio_titulo' => $anuncio_titulo, 'anuncio_descricao' => $anuncio_descricao, 'preco' => $preco, 'url_anuncio' => $url_anuncio, 'active' => $active]); $numero_quarto = $value->QtdDormitorios; $numero_garagem = $value->QtdVagas; $numero_banheiro = $value->QtdBanheiros; $area_construida = $value->AreaUtil; $valor_iptu = $value->PrecoIptu; $acomodacoes = $value->QtdDormitorios; $category_id = "1"; AdvertImovel::create(['numero_quarto' => $numero_quarto, 'numero_garagem' => $numero_garagem, 'numero_banheiro' => $numero_banheiro, 'area_construida' => $area_construida, 'valor_iptu' => $valor_iptu, 'acomodacoes' => $acomodacoes, 'advert_id' => $advert->id, 'category_id' => $category_id]); if (isset($value->Fotos)) { foreach ($value->Fotos->Foto as $va) { $extension = $va->URLArquivo; AdvertImage::create(['advert_id' => $advert->id, 'extension' => $extension]); } } $feature = array(); //DormitorioEmpregada - 8/10, 25/20, 102/80, 151/101 $Caracteristica = (string) $value->DormitorioEmpregada; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "10") { $feature[] = 8; } if ($subcategories_id === "20") { $feature[] = 25; } if ($subcategories_id === "80") { $feature[] = 102; } if ($subcategories_id === "101") { $feature[] = 151; } } //Sacada - 12/10, 29/20, 106/80, 155/101, 183/113 $Caracteristica = (string) $value->Sacada; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "10") { $feature[] = 12; } if ($subcategories_id === "20") { $feature[] = 29; } if ($subcategories_id === "80") { $feature[] = 106; } if ($subcategories_id === "101") { $feature[] = 155; } if ($subcategories_id === "113") { $feature[] = 183; } } //ArmarioDormitorio - 5/10, 22/20, 42/40, 62/50, 80/60, 99/80, 128/90, 148/101, 160/107, 179/113 $Caracteristica = (string) $value->ArmarioDormitorio; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "10") { $feature[] = 5; } if ($subcategories_id === "20") { $feature[] = 22; } if ($subcategories_id === "40") { $feature[] = 42; } if ($subcategories_id === "50") { $feature[] = 62; } if ($subcategories_id === "60") { $feature[] = 80; } if ($subcategories_id === "80") { $feature[] = 99; } if ($subcategories_id === "90") { $feature[] = 128; } if ($subcategories_id === "101") { $feature[] = 148; } if ($subcategories_id === "107") { $feature[] = 160; } if ($subcategories_id === "113") { $feature[] = 179; } } //Churrasqueira - 10/10, 27/20, 50/50, 74/60, 104/80, 121/90, 153/101 $Caracteristica = (string) $value->Churrasqueira; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "10") { $feature[] = 10; } if ($subcategories_id === "20") { $feature[] = 27; } if ($subcategories_id === "50") { $feature[] = 50; } if ($subcategories_id === "60") { $feature[] = 74; } if ($subcategories_id === "80") { $feature[] = 104; } if ($subcategories_id === "90") { $feature[] = 121; } if ($subcategories_id === "101") { $feature[] = 153; } } //Piscina - 7/10, 24/20, 44/40, 49/50, 73/60, 101/80, 123/90, 150/101, 169/108, 176/113 $Caracteristica = (string) $value->Piscina; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "10") { $feature[] = 7; } if ($subcategories_id === "20") { $feature[] = 24; } if ($subcategories_id === "40") { $feature[] = 44; } if ($subcategories_id === "50") { $feature[] = 49; } if ($subcategories_id === "60") { $feature[] = 73; } if ($subcategories_id === "80") { $feature[] = 101; } if ($subcategories_id === "90") { $feature[] = 123; } if ($subcategories_id === "101") { $feature[] = 150; } if ($subcategories_id === "108") { $feature[] = 169; } if ($subcategories_id === "113") { $feature[] = 176; } } //TVCabo - 41/40, 61/50, 79/60, 93/70, 127/90 $Caracteristica = (string) $value->TVCabo; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "40") { $feature[] = 41; } if ($subcategories_id === "50") { $feature[] = 61; } if ($subcategories_id === "60") { $feature[] = 79; } if ($subcategories_id === "70") { $feature[] = 93; } if ($subcategories_id === "90") { $feature[] = 127; } } //Varanda - 12/10, 29/20, 106/80, 155/101, 183/113 $Caracteristica = (string) $value->Varanda; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "10") { $feature[] = 12; } if ($subcategories_id === "20") { $feature[] = 29; } if ($subcategories_id === "80") { $feature[] = 106; } if ($subcategories_id === "101") { $feature[] = 155; } if ($subcategories_id === "113") { $feature[] = 183; } } //AreaServico - 6/10, 23/20, 43/40, 63/50, 81/60, 100/80, 149/101, 184/113 $Caracteristica = (string) $value->AreaServico; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "10") { $feature[] = 6; } if ($subcategories_id === "20") { $feature[] = 23; } if ($subcategories_id === "40") { $feature[] = 43; } if ($subcategories_id === "50") { $feature[] = 63; } if ($subcategories_id === "60") { $feature[] = 81; } if ($subcategories_id === "80") { $feature[] = 100; } if ($subcategories_id === "101") { $feature[] = 149; } if ($subcategories_id === "113") { $feature[] = 184; } } //CampoFutebol - 16/10, 110/80, 171/108 $Caracteristica = (string) $value->CampoFutebol; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "10") { $feature[] = 16; } if ($subcategories_id === "80") { $feature[] = 110; } if ($subcategories_id === "108") { $feature[] = 171; } } //Mobiliado - 48/50, 71/60, 91/70, 161/107, 180,113 $Caracteristica = (string) $value->Mobiliado; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "50") { $feature[] = 48; } if ($subcategories_id === "60") { $feature[] = 71; } if ($subcategories_id === "70") { $feature[] = 91; } if ($subcategories_id === "107") { $feature[] = 161; } if ($subcategories_id === "113") { $feature[] = 180; } } //Lareira - 138/90 $Caracteristica = (string) $value->Mobiliado; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "90") { $feature[] = 138; } } if (!empty($feature)) { $advert->features()->sync($feature); } } if (!empty($value->PrecoVenda)) { //venda @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ $tipo_anuncio = "venda"; $origem = "ValueGaia"; $origem_identificacao = $value->CodigoCliente . $value->CodigoImovel . $value->CodigoImovelAuxiliar; $anuncio_titulo = $value->TituloImovel; $anuncio_descricao = $value->Observacao; $preco = $value->PrecoVenda; $url_anuncio = str_slug($value->TituloImovel); $estado = $value->Estado; $cidade = $value->Cidade; $bairro = $value->Bairro; if (!empty($value->Endereco)) { $active = 1; $rua = $value->Endereco; $numero = $value->Numero; } else { $active = 0; } //$destaque, - verificar com o mauricio $user_id = $user->id; $subcategories_id = "20"; $tipo = (string) $value->TipoImovel; $tipo = trim($tipo); if ($tipo === 'Apartamento' || $tipo === 'Loft') { $subcategories_id = "10"; } else { if ($tipo === 'Área' || $tipo === 'Terreno' || $tipo === 'Galpão') { $subcategories_id = "30"; } else { if ($tipo === 'Casa' || $tipo === 'Sobrado' || $tipo === 'Barracão' || $tipo === 'Conjunto' || $tipo === 'Village' || $tipo === 'Laje') { $subcategories_id = "20"; } else { if ($tipo === 'Chácara' || $tipo === 'Fazenda' || $tipo === 'Fazenda Rural' || $tipo === 'Sítio' || $tipo === 'Bangalô' || $tipo === 'Rancho' || $tipo === 'Haras') { $subcategories_id = "60"; } else { if ($tipo === 'Ponto' || $tipo === 'Prédio' || $tipo === 'Sala' || $tipo === 'Salão' || $tipo === 'Loja' || $tipo === 'Studio') { $subcategories_id = "70"; } else { if ($tipo === 'Kitnet') { $subcategories_id = "107"; } else { if ($tipo === 'Flat') { $subcategories_id = "113"; } else { if ($tipo === 'Cobertura' || $tipo === 'Apartamento Duplex' || $tipo === 'Apartamento Triplex' || $tipo === 'Penthouse') { $subcategories_id = "101"; } else { if ($tipo === 'Pousada' || $tipo === 'Resort' || $tipo === 'Hotel' || $tipo === 'Ilha') { $subcategories_id = "90"; } } } } } } } } } $advert = Advert::create(['user_id' => $user_id, 'subcategories_id' => $subcategories_id, 'tipo_anuncio' => $tipo_anuncio, 'origem' => $origem, 'origem_identificacao' => $origem_identificacao, 'estado' => $estado, 'cidade' => $cidade, 'bairro' => $bairro, 'rua' => $rua, 'numero' => $numero, 'anuncio_titulo' => $anuncio_titulo, 'anuncio_descricao' => $anuncio_descricao, 'preco' => $preco, 'url_anuncio' => $url_anuncio, 'active' => $active]); $numero_quarto = $value->QtdDormitorios; $numero_garagem = $value->QtdVagas; $numero_banheiro = $value->QtdBanheiros; $area_construida = $value->AreaUtil; $valor_iptu = $value->PrecoIptu; $acomodacoes = $value->QtdDormitorios; $category_id = "1"; AdvertImovel::create(['numero_quarto' => $numero_quarto, 'numero_garagem' => $numero_garagem, 'numero_banheiro' => $numero_banheiro, 'area_construida' => $area_construida, 'valor_iptu' => $valor_iptu, 'acomodacoes' => $acomodacoes, 'advert_id' => $advert->id, 'category_id' => $category_id]); if (isset($value->Fotos)) { foreach ($value->Fotos->Foto as $va) { $extension = $va->URLArquivo; AdvertImage::create(['advert_id' => $advert->id, 'extension' => $extension]); } } $feature = array(); //DormitorioEmpregada - 8/10, 25/20, 102/80, 151/101 $Caracteristica = (string) $value->DormitorioEmpregada; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "10") { $feature[] = 8; } if ($subcategories_id === "20") { $feature[] = 25; } if ($subcategories_id === "80") { $feature[] = 102; } if ($subcategories_id === "101") { $feature[] = 151; } } //Sacada - 12/10, 29/20, 106/80, 155/101, 183/113 $Caracteristica = (string) $value->Sacada; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "10") { $feature[] = 12; } if ($subcategories_id === "20") { $feature[] = 29; } if ($subcategories_id === "80") { $feature[] = 106; } if ($subcategories_id === "101") { $feature[] = 155; } if ($subcategories_id === "113") { $feature[] = 183; } } //ArmarioDormitorio - 5/10, 22/20, 42/40, 62/50, 80/60, 99/80, 128/90, 148/101, 160/107, 179/113 $Caracteristica = (string) $value->ArmarioDormitorio; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "10") { $feature[] = 5; } if ($subcategories_id === "20") { $feature[] = 22; } if ($subcategories_id === "40") { $feature[] = 42; } if ($subcategories_id === "50") { $feature[] = 62; } if ($subcategories_id === "60") { $feature[] = 80; } if ($subcategories_id === "80") { $feature[] = 99; } if ($subcategories_id === "90") { $feature[] = 128; } if ($subcategories_id === "101") { $feature[] = 148; } if ($subcategories_id === "107") { $feature[] = 160; } if ($subcategories_id === "113") { $feature[] = 179; } } //Churrasqueira - 10/10, 27/20, 50/50, 74/60, 104/80, 121/90, 153/101 $Caracteristica = (string) $value->Churrasqueira; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "10") { $feature[] = 10; } if ($subcategories_id === "20") { $feature[] = 27; } if ($subcategories_id === "50") { $feature[] = 50; } if ($subcategories_id === "60") { $feature[] = 74; } if ($subcategories_id === "80") { $feature[] = 104; } if ($subcategories_id === "90") { $feature[] = 121; } if ($subcategories_id === "101") { $feature[] = 153; } } //Piscina - 7/10, 24/20, 44/40, 49/50, 73/60, 101/80, 123/90, 150/101, 169/108, 176/113 $Caracteristica = (string) $value->Piscina; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "10") { $feature[] = 7; } if ($subcategories_id === "20") { $feature[] = 24; } if ($subcategories_id === "40") { $feature[] = 44; } if ($subcategories_id === "50") { $feature[] = 49; } if ($subcategories_id === "60") { $feature[] = 73; } if ($subcategories_id === "80") { $feature[] = 101; } if ($subcategories_id === "90") { $feature[] = 123; } if ($subcategories_id === "101") { $feature[] = 150; } if ($subcategories_id === "108") { $feature[] = 169; } if ($subcategories_id === "113") { $feature[] = 176; } } //TVCabo - 41/40, 61/50, 79/60, 93/70, 127/90 $Caracteristica = (string) $value->TVCabo; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "40") { $feature[] = 41; } if ($subcategories_id === "50") { $feature[] = 61; } if ($subcategories_id === "60") { $feature[] = 79; } if ($subcategories_id === "70") { $feature[] = 93; } if ($subcategories_id === "90") { $feature[] = 127; } } //Varanda - 12/10, 29/20, 106/80, 155/101, 183/113 $Caracteristica = (string) $value->Varanda; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "10") { $feature[] = 12; } if ($subcategories_id === "20") { $feature[] = 29; } if ($subcategories_id === "80") { $feature[] = 106; } if ($subcategories_id === "101") { $feature[] = 155; } if ($subcategories_id === "113") { $feature[] = 183; } } //AreaServico - 6/10, 23/20, 43/40, 63/50, 81/60, 100/80, 149/101, 184/113 $Caracteristica = (string) $value->AreaServico; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "10") { $feature[] = 6; } if ($subcategories_id === "20") { $feature[] = 23; } if ($subcategories_id === "40") { $feature[] = 43; } if ($subcategories_id === "50") { $feature[] = 63; } if ($subcategories_id === "60") { $feature[] = 81; } if ($subcategories_id === "80") { $feature[] = 100; } if ($subcategories_id === "101") { $feature[] = 149; } if ($subcategories_id === "113") { $feature[] = 184; } } //CampoFutebol - 16/10, 110/80, 171/108 $Caracteristica = (string) $value->CampoFutebol; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "10") { $feature[] = 16; } if ($subcategories_id === "80") { $feature[] = 110; } if ($subcategories_id === "108") { $feature[] = 171; } } //Mobiliado - 48/50, 71/60, 91/70, 161/107, 180,113 $Caracteristica = (string) $value->Mobiliado; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "50") { $feature[] = 48; } if ($subcategories_id === "60") { $feature[] = 71; } if ($subcategories_id === "70") { $feature[] = 91; } if ($subcategories_id === "107") { $feature[] = 161; } if ($subcategories_id === "113") { $feature[] = 180; } } //Lareira - 138/90 $Caracteristica = (string) $value->Mobiliado; $Caracteristica = trim($Caracteristica); if ($Caracteristica === "1") { if ($subcategories_id === "90") { $feature[] = 138; } } if (!empty($feature)) { $advert->features()->sync($feature); } } } } return view('admin.principal.integracao', ['user' => $user, 'valida' => false]); }