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); }