Vinícius de Sá Souza viniciusss

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 / 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 / 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 / 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 / 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 / requisicao.php

Created April 16, 2014 14:31

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 / envio.php

Created March 6, 2014 14:50

viniciusss / Apagar_movimentos_estoque.php

Created February 28, 2014 10:57

	<?php
	session_start();
	require_once(dirname(__FILE__) . "/../includes/funcoes.inc.php");
	require_once(dirname(__FILE__) . "/../includes/global.php");
	require_once(dirname(__FILE__) . "/../includes/geral.class.php");
	ini_set('display_errors', 1);
	error_reporting(E_ALL);

	set_time_limit(0);
	ini_set('memory_limit', '1024M');

viniciusss / gist:9076849

Created February 18, 2014 18:31

	<?php
	session_start();
	include_once(__DIR__ . '/../includes/global.php');
	include_once(__DIR__ . '/../includes/funcoes.inc.php');
	include_once(__DIR__ . '/../includes/geral.class.php');
	include_once(__DIR__ . '/../includes/head.inc.php');

	try {
	$tabs = new MS_View_Tab();
	$tabs->add([