quinta-feira, 2 de junho de 2016

HTML 5 - POP UP



<!DOCTYPE html>
<head>
    <title>Creating a modal window with HTML5 &amp; CSS3</title>
   
    <style>
     #openModal {
    position:relative;
    z-index:1;
   
    }
    #popup
{
    position:absolute;
    z-index:2;
    left:300px;
    top:35px;
    display:none;
    width:500px;
   
        padding: 5px 20px 13px 20px;
        border-radius: 10px;
        background: -moz-linear-gradient(#fff, #999);
        background: -webkit-linear-gradient(#fff, #999);
        background: -o-linear-gradient(#fff, #999);
}


    .close {
        background: #606061;
        color: #FFFFFF;
        line-height: 25px;
        position: absolute;
        right: -12px;
        text-align: center;
        top: -10px;
        width: 24px;
        text-decoration: none;
        font-weight: bold;
        -webkit-border-radius: 12px;
        -moz-border-radius: 12px;
        border-radius: 12px;
        -moz-box-shadow: 1px 1px 3px #000;
        -webkit-box-shadow: 1px 1px 3px #000;
        box-shadow: 1px 1px 3px #000;
    }

    .close:hover { background: #00d9ff; }
  
    </style>
   
</head>

<body>

<div id="popup">
        <div>
        <a href="#close" onclick="hide('closer'); hide('popup')" id="closer" title="Close" class="close">X</a>
        <h2>Modal Box</h2>
        <p>This is a sample modal box that can be created using the powers of CSS3.</p>
        <p>You could do a lot of things here like have a pop-up ad that shows when your website loads, or create a login/register form for users.</p>
    </div>
</div>   

<div id="openModal" class="modalDialog">
   
        <h2>TESTE</h2>
        <p>POP UP CSS3.</p>
        <p>You could do a lot of things here like have a pop-up ad that shows when your website loads, or create a login/register form for users.</p>

</div>


<script>
    document.getElementById('popup').style.display = 'block';
   
    function hide(id)
    {
    document.getElementById(id).style.display = "none";
    }
   
    </script>
</body>
</html>

MySQL How to fill a Google Drive Spread Sheet - Como preencher o Planilhas do Google Drive



 // This app is made in JDBC

// Replace the variables in this block with real values.
var address = 'localhost:3306';
var user = 'USER';
var userPwd = 'PWD';
var db = 'DATABASE';

var dbUrl = 'jdbc:mysql://' + address + '/' + db;

//Gets and Sets the Current Spreadsheet as Active
var doc = SpreadsheetApp.getActiveSpreadsheet();
doc.setActiveSheet(doc.getSheetByName('Sheet1')); // nome da sheet
//No meu caso tenho a nome da coluna na linha 1: [E-mail] na coluna A1 e [Contato] na coluna B1
var lastRow = doc.getLastRow();
var lastRow_plus = lastRow + 1; // pula uma linha
var cell = doc.getRange('A'+lastRow_plus); // acha a ultima linha preenchida da coluna A

// Read up to 1000 rows of data from the table and log them.
function readFromTable() {
  var conn = Jdbc.getConnection(dbUrl, user, userPwd);

  var start = new Date();
 
  var stmt = conn.createStatement();
  stmt.setMaxRows(1000);
  var results = stmt.executeQuery('SELECT DISTINCT email, contato FROM `SUA-TABELA` WHERE status_envio=0 order by email');
  var numCols = results.getMetaData().getColumnCount();
  var row = 0;
  while (results.next()) {
    var rowString = '';
    for (var col = 0; col < numCols; col++) {
      cell.offset(row, col).setValue(results.getString(col+1));
    }
    row++;
    Logger.log(rowString);
  }
  var stmt1 = conn.prepareStatement('update SUA-TABELA set status_envio=1');
  stmt1.addBatch();
  var batch = stmt1.executeBatch();
 
  results.close();
  stmt.close();

  var end = new Date();
  Logger.log('Time elapsed: %sms', end - start);
}