Skip to content

Instantly share code, notes, and snippets.

View jbbn's full-sized avatar
🌮
Typing as fast as I can

João Bueno jbbn

🌮
Typing as fast as I can
View GitHub Profile
@jbbn
jbbn / estados_brasil_UF_Nome.html
Last active August 29, 2015 14:17
Estados Brasileiros - HTML
<select>
<option value="" selected="true" disabled="disabled">-- Estado --</option>
<option value="AC">Acre</option>
<option value="AL">Alagoas</option>
<option value="AP">Amapá</option>
<option value="AM">Amazonas</option>
<option value="BA">Bahia</option>
<option value="CE">Ceará</option>
<option value="DF">Distrito Federal</option>
<option value="ES">Espirito Santo</option>
@jbbn
jbbn / total_current_month_days.sql
Last active May 10, 2022 00:38
MYSQL: Total day by day of the current month
SELECT
DATE(`created_at`) created_at,
COUNT(`created_at`) total
FROM TABLENAME
WHERE
YEAR(`created_at`) = YEAR(NOW())
AND MONTH(`created_at`) = MONTH(NOW())
GROUP BY
DAY(`created_at`)
@jbbn
jbbn / total_current_month.sql
Last active May 10, 2022 00:38
MYSQL: Total current month
SELECT
YEAR(`created_at`) year,
MONTH(`created_at`) month,
COUNT(`created_at`) total
FROM TABLENAME
WHERE
YEAR(`created_at`) = YEAR(NOW())
AND MONTH(`created_at`) = MONTH(NOW())
@jbbn
jbbn / last7days.sql
Last active May 10, 2022 00:38
MYSQL: Last 7 days count
SELECT
DATE(`created_at`) created_at,
COUNT(`created_at`) total
FROM TABLENAME
WHERE
DATE(`created_at`) > DATE_SUB(CURDATE(), INTERVAL 7 DAY)
GROUP BY
DATE(`created_at`)
@jbbn
jbbn / consultaCepCC.js
Created June 11, 2014 01:24
Consulta de CEP do serviço gratuito "Correio Control" - http://cep.correiocontrol.com.br/
var consultaCep = function () {
var factory = {};
factory.cep = {};
factory.get = function (cep) {
var cep = cep = cep.replace(/\D/g,'');
if (cep.length === 8) {
$.ajax({