felipefinhane

DELETE FROM AccountingTransactionDescriptionProfile;

INSERT INTO AccountingTransactionDescriptionProfile (id_descricao_transacao_contabil, id_perfil) SELECT 
    id_descricao_transacao_contabil, p.id_perfil
FROM
    AccountingTransactionDescriptionMainData
        LEFT JOIN  ProfileMainData p ON 1 = 1
WHERE
    p.id_perfil IN (62 , 146, 120, 117, 114, 98);
    

felipefinhane

TRUNCATE AccountingBalanceSheetLayoutEnvironment;
INSERT INTO AccountingBalanceSheetLayoutEnvironment(id_balanco_contabil_layout, id_empresa) SELECT
	id_balanco_contabil_layout ,
	c.id_empresa
FROM
	AccountingBalanceSheetLayoutMainData a
LEFT JOIN CorporationMainData c ON c.stat <> 0;

TRUNCATE AccountingBalanceSheetLayoutProfile;

felipefinhane

use INFORMATION_SCHEMA;
SELECT 
    TABLE_NAME,
    COLUMN_NAME,
    CONSTRAINT_NAME,
    REFERENCED_TABLE_NAME,
    REFERENCED_COLUMN_NAME
FROM
    KEY_COLUMN_USAGE
WHERE 

felipefinhane

SELECT 
    nfe.id_nfe,
    nfe.dt_emissao,
    nfe.numero
FROM
    fis_nfe nfe
        LEFT JOIN
    com_projeto_parametros_venda propv ON propv.id_projeto_parametros_venda = nfe.id_projeto_parametros_venda
        AND propv.stat != 0
        LEFT JOIN

felipefinhane

<template>
  <h1>Página secreta!</h1>
</template>

felipefinhane

<?php

public function render()
{

 $builder = new StdClass;
        $pgto1 = new StdClass;
        $pgto1->getIdPagamento = 'pagamentoAutenticacao';
        $pgto2 = new StdClass;
        $pgto2->getIdPagamento = 'pagamentoTributo';

felipefinhane

package main

import (
    "io/ioutil"
    "net/http"
    "log"
    "html/template"
    "regexp"
)

felipefinhane

IRC Reference

Not intended as a guide for newbies, more like a "cheat sheet" for the somewhat experienced IRC user, especially one who wields some power over a channel.

The Basics

• /join #channel
  • Joins the specified channel.
• /part #channel
• Leaves the specified channel.

felipefinhane

GIT

Estados

• Modificado (modified);
• Preparado (staged/index)
• Consolidado (comitted);

Ajuda

felipefinhane

Representantes

Meta	Nome	Função
.	ponto	um caractere qualquer
[]	conjunto	conjunto de caracteres permitidos
[^]	conjunto negado	conjunto de caracteres proibidos

Quantificadores