function bannerSil($sil)
{
$bannerSil = DB::delete("delete from banner where id = ?", array($sil));
if ($bannerSil) {
return Redirect::to('admin/bannerListele');
}
}
function mesajSil($sil)
{
$mesajSil = DB::delete("delete from mesajlar where id = ?", array($sil));
if ($mesajSil > 0) {
return Redirect::to('admin/mesajlar');
}
}
public function store(SetupRequest $request)
{
DB::delete('delete from settings');
DB::table('settings')->insert([['name' => 'name', 'value' => e($request->input('name'))], ['name' => 'cover', 'value' => 'images/cover.jpg'], ['name' => 'avatar', 'value' => 'images/avatar.png'], ['name' => 'bio', 'value' => e($request->input('bio'))], ['name' => 'email', 'value' => '*****@*****.**'], ['name' => 'title', 'value' => e($request->input('title'))], ['name' => 'subtitle', 'value' => e($request->input('subtitle'))], ['name' => 'keywords', 'value' => e($request->input('keywords'))], ['name' => 'description', 'value' => e($request->input('description'))], ['name' => 'paginate_size', 'value' => 5]]);
event(new \App\Events\DoneSetupEvent());
return redirect('/');
}
function urunSil($urunsil)
{
$urunsil = DB::delete("delete from urunler where id = ?", array($urunsil));
if ($urunsil > 0) {
return Redirect::to('admin/urun');
}
}
function yorumSil($sil)
{
$yorumSil = DB::delete("delete from yorumlar where id = ?", array($sil));
if ($yorumSil > 0) {
return Redirect::to('admin/urunYorum');
}
}
function icerikSil($iceriksil)
{
$iceriksil = DB::delete("delete from icerikler where id = ?", array($iceriksil));
if ($iceriksil > 0) {
return Redirect::to('admin/icerik');
}
}
function videoSil($videoSil)
{
$videoSil = DB::delete("delete from videolar where id = ?", array($videoSil));
if ($videoSil > 0) {
return Redirect::to('admin/video');
}
}
public function sil($sil)
{
$data = DB::delete("delete from linkler where id=?", array($sil));
if ($data > 0) {
return Redirect::to('admin/linkler');
}
}
function haberSil($habersil)
{
$habersil = DB::delete("delete from haberler where id = ?", array($habersil));
if ($habersil > 0) {
return Redirect::to('admin/haberler');
}
}
public function sil($id)
{
$silIslem = DB::delete("delete from kullanicilar where id = ?", array($id));
//echo "<script>alert('".$silIslem."');</script>";
if ($silIslem > 0) {
return Redirect::to('admin/kullanicilar');
}
}
public function silData($sil)
{
// data silme işlemi
$silIslem = DB::delete("delete from kullanicilar where id = ?", array($sil));
//echo "<script>alert('".$silIslem."');</script>";
if ($silIslem > 0) {
return Redirect::to('veritabani');
}
}
static function delete($id, $pass)
{
$entry = DB::select("SELECT password FROM Entries WHERE rowid=?", [$id]);
if (Hash::check($pass, $entry[0]->password)) {
DB::delete('DELETE FROM Entries WHERE rowid=?', [$id]);
DB::delete('DELETE FROM Entries WHERE id_team=?', [$id]);
return 1;
}
return 0;
}
function sliderSil($sil)
{
$silenecek = DB::select("select yol from slider where id = ?", array($sil));
$fileName = $silenecek[0]->yol;
File::delete("slider/" . $fileName);
$sliderSil = DB::delete("delete from slider where id = ?", array($sil));
if ($sliderSil > 0) {
return Redirect::to('admin/sliderYonetimi');
}
}
public function olay()
{
$durum = Input::all();
if (isset($durum["sil"])) {
// silme işlemi
$sil_id = $durum["topCategory"];
$silIslem = DB::delete("delete from kategoriler where id = ?", array($sil_id));
}
return Redirect::to('admin/kategori');
}
/**
* Kullanıcı silme işlemi.
* @param $kul_id
* @return redirect
*/
public function silForm($kul_id)
{
// Kullanıcı silme işlemi.
$q = "DELETE FROM kullanicilar WHERE id = ?";
$islem = DB::delete($q, array($kul_id));
if ($islem) {
$mesaj = "basarili";
} else {
$mesaj = "basarisiz";
}
return redirect("kullanicilar/liste")->with("mesaj", $mesaj);
}
public function clear()
{
DB::delete('DELETE FROM tags WHERE id > 0');
DB::delete('DELETE FROM lead_user WHERE user_id > 0;');
DB::delete('DELETE FROM activities WHERE id > 0;');
DB::delete('DELETE FROM entity_data WHERE id > 0;');
DB::delete('DELETE FROM phones WHERE id > 0;');
DB::delete('DELETE FROM addresses WHERE id > 0;');
DB::delete('DELETE FROM contacts WHERE id > 0;');
DB::delete('DELETE FROM entities WHERE id > 0;');
DB::delete('DELETE FROM leads WHERE id > 0;');
DB::delete('DELETE FROM users WHERE id > 0;');
DB::delete('DELETE FROM accounts WHERE id > 0;');
return 'Successfully cleared';
}
public function sil($id)
{
$resim = DB::select('select yol from gal_resim where id = ?', array($id));
$defaultSizePath = "/galeriResimler/defaultSize/";
$path600x450 = "/galeriResimler/600x450/";
$fullPathDefaultSize = base_path($defaultSizePath . $resim[0]->yol);
$fullPath600x450 = base_path($path600x450 . $resim[0]->yol);
if (File::exists($fullPathDefaultSize) && File::exists($fullPath600x450)) {
File::delete($fullPathDefaultSize);
File::delete($fullPath600x450);
}
$query = DB::delete('delete from gal_resim where id = ?', array($id));
if ($query > 0) {
return Redirect::back();
}
}
public function sil($id)
{
$resimler = DB::select('select id,yol from gal_resim where gal_kat_id = ?', array($id));
foreach ($resimler as $resim) {
$defaultSizePath = "/galeriResimler/defaultSize/";
$path600x450 = "/galeriResimler/600x450/";
$fullPathDefaultSize = base_path($defaultSizePath . $resim->yol);
$fullPath600x450 = base_path($path600x450 . $resim->yol);
if (File::exists($fullPathDefaultSize) && File::exists($fullPath600x450)) {
File::delete($fullPathDefaultSize);
File::delete($fullPath600x450);
}
$query = DB::delete("delete from gal_resim where gal_kat_id = ?", array($id));
if ($query > !0) {
break;
}
}
$silIslem = DB::delete("delete from gal_kategori where id = ?", array($id));
if ($silIslem > 0) {
return Redirect::to('admin/galerikategori');
}
}
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]);
}
public function deleteData()
{
$sql = "DELETE FROM table_name WHERE some_column = some_value";
return DB::delete(DB::raw($sql));
}
public function deleteCategory()
{
if (func_num_args() > 0) {
$categoryid = func_get_arg(0);
try {
$result = DB::delete("DELETE a.*, b.* FROM category a LEFT JOIN subcategory b ON b.category_id = a.category_id WHERE a.category_id = " . $categoryid);
// $result = DB::table("category")
// ->leftjoin('subcategory', 'category.category_id', '=', 'subcategory.category_id')
// ->where('category.category_id', $categoryid)
// ->delete();
} catch (QueryException $e) {
echo $e;
}
if ($result) {
return $result;
} else {
return 0;
}
} else {
return 0;
}
}
public function expertDenyAssignment($assignmentId)
{
DB::delete('delete from bidder_assignment where assignment_id = ? and bidder_id = ?', [$assignmentId, Authorizer::getResourceOwnerId()]);
return $this->respondWithItem($this->model()->findorFail($assignmentId));
}
public function DeleteCall($callModel)
{
$response = new ServiceResponse();
try {
DB::delete("delete from usercalls where CallID = " . $callModel->scalar);
DB::delete("delete from calls where CallID = " . $callModel->scalar);
$response->IsSuccess = TRUE;
$response->Message = trans("messages.CallDeletedSuccessfully");
} catch (Exception $e) {
$response->Message = trans("messages.ErrorOccured");
}
return $response;
}
function removeFromQueue($qid)
{
return DB::delete('DELETE PatientQueue FROM PatientQueue WHERE id=?', [$qid]);
}
public function sil($id)
{
DB::delete("delete from kullanicilar WHERE id = ?", array($id));
return Redirect::to('uyeler');
}
public function sil($silId)
{
$silme = DB::delete("delete from anket where id=?", array($silId));
return Redirect::to('admin/anket');
}
/**
* Update the specified resource in storage.
*
* @param int $id
* @return Response
*/
public function update($id)
{
$user = AdminUser::findOrFail($id);
$data = array("first_name" => Input::get("first_name"), "last_name" => Input::get("last_name"), "groups" => Input::get("groups") == null ? array() : Input::get("groups"));
$rules = array("first_name" => "required", "last_name" => "required");
$validator = Validator::make($data, $rules);
if ($validator->fails()) {
return Redirect::route('admin.users.edit', $id)->withErrors($validator)->withInput();
} else {
$user->first_name = $data['first_name'];
$user->last_name = $data['last_name'];
DB::delete('delete from users_groups where user_id=' . $id);
foreach ($data['groups'] as $group) {
DB::statement("INSERT IGNORE INTO users_groups (user_id,group_id) VALUES(?,?)", array($id, $group));
}
if ($user->save()) {
Session::flash('success', "Đã cập nhật user" . $user->email . " thành công");
return Redirect::route('admin.users.edit', $id);
} else {
Session::flash('error', "Xảy ra lỗi trong khi cập nhật user " . $user->email);
return Redirect::route('admin.users.edit', $id);
}
}
}
public function deleplan(Request $request)
{
$sql = "DELETE FROM TBL_USER_SAVING_RATE WHERE EMP_ID = '" . get_userID() . "' AND MONTH(CHANGE_SAVING_RATE_DATE) = MONTH(GETDATE())\nAND YEAR(CHANGE_SAVING_RATE_DATE) = YEAR(GETDATE())";
$ret = DB::delete(DB::raw($sql));
if ($ret) {
Logprocess(3);
}
return redirect()->to('/cumulative')->with('del2', 'ok');
}
static function purge($id)
{
return DB::delete('DELETE FROM Entries WHERE id_game=?', [$id]);
}
public function volunteering(Request $request)
{
if ($request->delete) {
DB::delete('delete from volun where id=?', [$request->delete]);
}
$user = $request->user();
$data['volun_list'] = DB::select('select * from volun where user_id=?', [$user->id]);
$profiledata['profile_list'] = DB::select('select * from profile where user_id=?', [$user->id]);
return view('volunteering', $data, $profiledata);
}
