rogeriolino

(function($) {
            
    $.winscroll = function(fn, restrictions) {
        restrictions = $.extend({ minY: 0, minX: 0, maxY: Infinity, maxX: Infinity }, restrictions);
        
        $(window).on('scroll', function() {
            var y = $(document).scrollTop(),
                x = $(document).scrollLeft();
                
            if (y >= restrictions.minY && y <= restrictions.maxY && x >= restrictions.minX && x <= restrictions.maxX) 

rogeriolino

-- procedures
DROP PROCEDURE sp_acumular_atendimentos;
DROP PROCEDURE sp_acumular_atendimentos_unidade;

-- drop views
DROP VIEW view_historico_atend_codif;
DROP VIEW view_historico_atendimentos;
 
-- atend_codif

rogeriolino

-- drop views
DROP VIEW view_historico_atend_codif;
DROP VIEW view_historico_atendimentos;

-- atend_codif
ALTER TABLE atend_codif RENAME id_atend TO atendimento_id;
ALTER TABLE atend_codif RENAME id_serv TO servico_id;

DROP TABLE atend_status CASCADE;

rogeriolino

CREATE FUNCTION fixUtf8(str VARCHAR(255)) RETURNS VARCHAR(255)
  RETURN CONVERT(CAST(CONVERT(str USING latin1) AS BINARY) USING utf8);

rogeriolino

-- fixUtf8 function required https://gist.github.com/rogeriolino/22d911fbe25538838bb3
-- IMPORTANT: don't run more than 1 time!

UPDATE unidades SET nome = fixUtf8(nome);
UPDATE prioridades SET nome = fixUtf8(nome), descricao = fixUtf8(descricao);
UPDATE grupos SET nome = fixUtf8(nome), descricao = fixUtf8(descricao);
UPDATE cargos SET nome = fixUtf8(nome), descricao = fixUtf8(descricao);
UPDATE locais SET nome = fixUtf8(nome);
UPDATE atendimentos SET nm_cli = fixUtf8(nm_cli), ident_cli = fixUtf8(ident_cli);
UPDATE historico_atendimentos SET nm_cli = fixUtf8(nm_cli), ident_cli = fixUtf8(ident_cli);

rogeriolino

/*
Workaround to fix error on arcgis4.4 view click
*/

// XXX: TypeError: Cannot read property 'position' of undefined
view.originalHitTest = view.hitTest;

view.hitTest = function (evt) {
  try {
    return view.originalHitTest(evt);

rogeriolino

version: '2'

services:
  novosga:
    image: novosga/novosga:latest
    restart: always
    depends_on:
      - mysqldb
    ports:
      - "80:80"

rogeriolino

#
# Video Scaler
# https://gist.github.com/rogeriolino/b2abcbbc0f7bd8ebc18b4cd0975f5a3b
#
# Place the MP4 files in the same video-scaler.sh script directory.
# Finished (done) files will placed in $FINISHED_DIR directory.
# New resized files will placed in $OUTPUT_DIR directory.
#
SCALE=320
OUTPUT_DIR=output

rogeriolino

<?php

$url = isset($_GET['url']) ? $_GET['url'] : '';

if (filter_var($url, FILTER_VALIDATE_URL) === false || strtolower(substr($url, 0, 4)) !== 'http') {
    echo("URL inválida: $url");
    exit();
} 

$proxy = null; // "http://192.168.0.10:3128"

rogeriolino

<?php

$url = isset($_GET['url']) ? $_GET['url'] : '';

if (filter_var($url, FILTER_VALIDATE_URL) === false || strtolower(substr($url, 0, 4)) !== 'http') {
    echo("URL inválida: $url");
    exit();
}

$proxy = null; // "http://192.168.0.10:3128"