This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<html ng-app="fiapIoT"> | |
<head> | |
<meta charset="UTF-8"> | |
<script src="https://ajax.googleapis.com/ajax/libs/angularjs/1.4.9/angular.min.js"></script> | |
<script src="main.js"></script> | |
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap.min.css"> | |
<title>FIAP - IoT</title> | |
</head> | |
<body ng-controller="MainCtrl"> |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
var express = require('express'); | |
var five = require('johnny-five'); | |
var app = express(); | |
var board = new five.Board({port:"COM3"}); | |
var relay; | |
board.on("ready", function(){ | |
console.log("Arduino conectado"); | |
relay = new five.Relay(13); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import UIKit | |
@IBDesignable class ProfileImageView: UIImageView { | |
@IBInspectable var cornerRadius: CGFloat = 0 { | |
didSet{ | |
self.layer.cornerRadius = cornerRadius | |
} | |
} | |
@IBInspectable var borderWidth: CGFloat = 0 { |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
//URL | |
/usuarios/rafa@gmail | |
// JAVA CLASS | |
public class Usuario{ | |
String nome | |
String email | |
// TODOS OS ATRIBUTOS QUE VEM NO JSON | |
} |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<html> | |
<head> | |
<title>Armando Gay</title> | |
<link rel="stylesheet" type="text/css" href="style.css"> | |
</head> | |
<body> | |
<div id="guardaProjetos"> | |
<ul id="projetos"> | |
<!-- PROJETO --> |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
OBJECT_NAME(id) AS Tabela, | |
Name AS Coluna | |
FROM | |
sys.syscolumns | |
WHERE | |
name = 'campo_desejado' |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$exec = $this->_conn->prepare('INSERT INTO usuarios(nome_usuario, email_usuario, senha_usuario) VALUES (":nome_usuario", ":email_usuario", ":senha_usuario")'); | |
$exec->bindValue(":nome_usuario", $dados['nome_usuario'], PDO::PARAM_STR); | |
$exec->bindValue(":email_usuario", $dados['email_usuario'], PDO::PARAM_STR); | |
$exec->bindValue(":senha_usuario", $dados['senha_usuario'], PDO::PARAM_STR); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- PRINCIPAIS | |
CREATE TABLE vagas( | |
id_vaga INT NOT NULL AUTO_INCREMENT | |
,cargo_vaga VARCHAR(100) | |
,descricao_vaga TEXT | |
,requisitos_vaga TEXT | |
,diferenciais_vaga TEXT | |
,local_vaga VARCHAR(100) | |
,id_faixa_salarial_vaga INT NOT NULL | |
,info_remun_vaga TEXT |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
+----+------------+-------------------+ | |
| id | produto_id | picture_file_name | | |
+----+------------+-------------------+ | |
| 1 | 1 | K185A2617.jpg | | |
| 2 | NULL | K185A0001.jpg | | |
| 3 | NULL | K185A0002.jpg | | |
| 4 | NULL | K185A0003.jpg | | |
| 5 | NULL | K185A0004.jpg | | |
| 6 | NULL | K185A0005.jpg | | |
| 8 | NULL | K185A0006.jpg | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT a.idanuncio, | |
a.titulo, | |
a.estado, | |
(CASE WHEN a.preco_machos = 0 AND a.preco_femeas != 0 THEN a.preco_femeas WHEN a.preco_femeas = 0 && a.preco_machos != 0 THEN a.preco_machos WHEN a.preco_machos <= a.preco_femeas THEN a.preco_machos ELSE a.preco_femeas END) as preco, | |
ga.titulo AS imagem, | |
a.identificacao | |
FROM anuncio AS a | |
INNER JOIN galeria_anuncio AS ga ON a.idanuncio = ga.idanuncio | |
WHERE ga.posicao = 0 | |
GROUP BY a.idanuncio |