Vinícius de Sá Souza viniciusss

viniciusss / inserir_loja.sql

Last active August 29, 2015 13:58

	INSERT INTO `sqldados`.`store`
	(`zip`, `fax`, `tel`, `bankno`, `ccustono`, `auxLong1`, `auxLong2`, `dateInscJunta`, `no`, `ddd`, `active`, `bits`,
	`metano`, `padbyte`, `auxShort1`, `auxShort2`, `name`, `sname`, `otherName`, `cgc`, `addr`, `nei`, `city`, `state`)
	VALUES ('29980000', '0', '0', '0', '0', '0', '0', '0', '1022', '0', '1', '0', '0', '0', '0', '0', 'START MOVEIS 01', 'ST',
	'STARMOVEIS', '31.743.818/0034-96', LEFT('AV SETEMBRINO PELISSARI', 32), 'CENTRO', 'PINHEIROS', 'ES');

	insert into webpdv.aliquotas_loja
	select null, 1022, txano, valor_aliquota
	from webpdv.aliquotas_loja
	where storeno = 1002;

viniciusss / requisicao.php

Created April 16, 2014 14:31

viniciusss / gist:6772d5717f82e1b4a9c4

Created May 2, 2014 12:33

	SELECT
	SUM(valor_liquido) AS valor_liquido,
	SUM(cmv) AS cmv,
	tipo,
	tipo_nome,
	empno,
	emp.name AS vendedor,
	SUM(trocas_devolucoes) AS devolvida
	FROM (
	SELECT

viniciusss / gist:c74e48faa6a995232db2

Created May 3, 2014 12:48

	SetEnv APP_ENV prod

	FileETag none

	<IfModule mod_expires.c>
	ExpiresActive On
	############################################
	## Add default Expires header
	## http://developer.yahoo.com/performance/rules.html#expires
	<FilesMatch "\.(ico\|pdf\|flv\|jpg\|jpeg\|png\|gif\|js\|css\|swf)$">

viniciusss / ws_client.php

Created May 8, 2014 12:27

	<?php

	$client = new \Zend_Soap_Client('http://127.0.0.1:8080/webpdv/ws/usuarios.php', array('soapVersion' => SOAP_1_2, 'uri' => 'http://127.0.0.1:8080/webpdv/ws/usuarios.php' ));

	$arrUsuario = buscarDadosDoUsuario($idUsuario);

	$client->salvar('viniciusss', 'vinicius de sa', 1, true);

viniciusss / query_cartoes_tipo_parcelamento.sql

Last active August 29, 2015 14:01

	SELECT
	tipo,
	ROUND(SUM(valor) / 100, 2) AS total
	FROM (
	SELECT
	pfp.valor AS valor,
	'2 a 6 Vezes' AS tipo
	FROM sqldados.xalog2
	INNER JOIN webpdv.pedido_forma_pagamento pfp
	ON (pfp.storeno = xalog2.storeno AND pfp.pdvno = xalog2.pdvno AND pfp.xano = xalog2.xano)

viniciusss / gist:362e302578fd530bed6c

Created May 29, 2014 13:07

	#Conexao principal
	- name: default
	host: 192.168.111.5
	user: webpdv
	dbname: webpdv
	password: p@lerm02156
	adapter: doctrine
	driver: pdo_mysql
	options:
	<?php echo \Vs_Db_Abstract::QUERY_CACHE_CONFIG ?>: true

viniciusss / envio_dispositivo.php

Created June 2, 2014 14:06

	<?php

	$sdkKernel = \Simonetti\MsMobile\SDK\Kernel::factory(
	[
	'parameters' => __DIR__ . '/config/parameters.yaml'
	]
	);

	/**
	* @var \Simonetti\MsMobile\SDK\Service\Dispositivos\DispositivosManager $dispositivoManger

viniciusss / response.php

Created June 2, 2014 14:08

	<?php


	namespace Simonetti\MsMobile\SDK\Client;

	use GuzzleHttp\Message\Response;

	/**
	* Resposta do client
	* Interface ResponseInterface

viniciusss / configuracoes.ini

Last active August 29, 2015 14:02

	resources.doctrine.orm.entityManagers.default.DQLFunctions.numeric.LPAD = "DoctrineExtensions\ORM\Query\Functions\Numeric\LpadFunction"
	resources.doctrine.orm.entityManagers.default.DQLFunctions.numeric.NVL = "DoctrineExtensions\ORM\Query\Functions\Numeric\NvlFunction"
	resources.doctrine.orm.entityManagers.default.DQLFunctions.string.TRUNC = "DoctrineExtensions\ORM\Query\Functions\String\TruncFunction"
	resources.doctrine.orm.entityManagers.default.DQLFunctions.string.TO_CHAR = "DoctrineExtensions\ORM\Query\Functions\String\To_charFunction"
	resources.doctrine.dbal.connections.default.eventSubscribers[] = "Doctrine\DBAL\Event\Listeners\OracleSessionInit"