validations::validNumeric PHPのコード例

コード例 #1

0

ファイルを表示

ファイル: grade_salvar.php プロジェクト: renatomarinho/ASC

// WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A    //
// PARTICULAR PURPOSE.  See the GNU General Public License for more details:          //
//                                                                                    //
//  http://www.gnu.org/copyleft/gpl.html                                              //
//                                                                                    //
////////////////////////////////////////////////////////////////////////////////////////

if (! isset ( $_CONF ['PATH'] )) {
	require "../../config/default.php";
}

$validations = new validations ( );
$db = new db ( );
$db->connect ();

$idgrade = $validations->validNumeric ( $_POST ['idgrade'] );
$descricao = strtoupper ( $validations->validStringForm ( $_POST ['descricao'] ) );
$quantidade = $validations->validNumeric ( $_POST ['quantidade'] );
$totalestoque = $validations->validNumeric ( $_POST ['totalestoque'] );
$vlprodgrade = $_POST ['vlprodgrade'];

$sql = "UPDATE cad_produtos_grade SET descricao='" . $descricao . "', quantidade='" . $quantidade . "', vlprodgrade='" . $vlprodgrade . "' WHERE id=" . $idgrade . "";
$db->query ( $sql );

$sql = "SELECT id_produto FROM cad_produtos_grade WHERE id=" . $idgrade . "";
$query = $db->query ( $sql );
$rowproduto = $db->fetch_assoc ( $query );

$sql = "UPDATE estoque SET nquantidade=" . $totalestoque . " WHERE produto_idproduto=" . $rowproduto ['id_produto'] . "";
$db->query ( $sql );

コード例 #2

0

ファイルを表示

ファイル: chart_venda_lucratividade_vendedor.php プロジェクト: renatomarinho/ASC

//                                                                                    //
////////////////////////////////////////////////////////////////////////////////////////

if (! isset ( $_CONF ['PATH'] )) {
	require "../../config/default.php";
}

require 'library/open-flash-chart.php';

srand((double)microtime()*1000000);

$validations = new validations ( );
$db = new db ( );
$db->connect ();

$dia1 = (isset ( $_GET ['diaescolhido1'] )) ? $validations->validNumeric ( $_GET ['diaescolhido1'] ) : date ( 'd' );
$mes1 = (isset ( $_GET ['mesescolhido1'] )) ? $validations->validNumeric ( $_GET ['mesescolhido1'] ) : date ( 'm' );
$ano1 = (isset ( $_GET ['anoescolhido1'] )) ? $validations->validNumeric ( $_GET ['anoescolhido1'] ) : date ( 'Y' );

$data_dia1 = $dia1;
$data_mes1 = $mes1;
$data_ano1 = $ano1;
$data1 = date ( 'Y-m-d', mktime ( 0, 0, 0, $data_mes1, $data_dia1, $data_ano1 ) );

$dia2 = (isset ( $_GET ['diaescolhido2'] )) ? $validations->validNumeric ( $_GET ['diaescolhido2'] ) : date ( 'd' );
$mes2 = (isset ( $_GET ['mesescolhido2'] )) ? $validations->validNumeric ( $_GET ['mesescolhido2'] ) : date ( 'm' );
$ano2 = (isset ( $_GET ['anoescolhido2'] )) ? $validations->validNumeric ( $_GET ['anoescolhido2'] ) : date ( 'Y' );

$data_dia2 = $dia2;
$data_mes2 = $mes2;
$data_ano2 = $ano2;

コード例 #3

0

ファイルを表示

ファイル: fornecedor_comparar_grafico.php プロジェクト: renatomarinho/ASC

		<td height="5"></td>
	</tr>
	<tr>
		<td height="20"><b>Gráfico comparativo dos fornecedores</b></td>
	</tr>
	<tr>
		<td style="border-top: 2px solid black"></td>
	</tr>
	<tr>
		<td height="5"></td>
	</tr>
	<tr>
		<td>
		<div style="width: 340px;">
					<?
					$total = $validations->validNumeric ( $_GET ['total'] );
					$param = $validations->validNumeric ( $_GET ['param'] );
					$remonta_url = '';
					for($i = 0; $i < $total; $i ++) {
						$remonta_url .= '&idfor' . $i . '=' . $_GET ['idfor' . $i];
					}
					require $_CONF ['PATH'] . 'modulos/charts/library/open_flash_chart_object.php';
					open_flash_chart_object ( 340, 280, $_CONF ['PATH_VIRTUAL'] . 'modulos/charts/chart-comparafornecedor.php?total=' . $total . '&param=' . $param . $remonta_url, false );
					?>
				</div>
		</td>
	</tr>
	<tr>
		<td height="5"></td>
	</tr>
	<tr>

コード例 #4

0

ファイルを表示

ファイル: produtos_vendidosperiodocliente_exibe.php プロジェクト: renatomarinho/ASC

// WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A    //
// PARTICULAR PURPOSE.  See the GNU General Public License for more details:          //
//                                                                                    //
//  http://www.gnu.org/copyleft/gpl.html                                              //
//                                                                                    //
////////////////////////////////////////////////////////////////////////////////////////

if (! isset ( $_CONF ['PATH'] )) {
	require "../../config/default.php";
}

$validations = new validations ( );
$db = new db ( );
$db->connect ();

$data_dia1 = $validations->validNumeric ( $_GET ['dia1'] );
$data_mes1 = $validations->validNumeric ( $_GET ['mes1'] );
$data_ano1 = $validations->validNumeric ( $_GET ['ano1'] );
$data1 = date ( 'Y-m-d', mktime ( 0, 0, 0, $data_mes1, $data_dia1, $data_ano1 ) );

$data_dia2 = $validations->validNumeric ( $_GET ['dia2'] );
$data_mes2 = $validations->validNumeric ( $_GET ['mes2'] );
$data_ano2 = $validations->validNumeric ( $_GET ['ano2'] );
$data2 = date ( 'Y-m-d', mktime ( 0, 0, 0, $data_mes2, $data_dia2, $data_ano2 ) );

if ($data1 == '1999-11-30') {
	$data1 = date ( 'Y-m-d', mktime ( 0, 0, 0, date ( 'm' ) - 1, date ( 'd' ), date ( 'Y' ) ) );
	$data2 = date ( 'Y-m-d', mktime ( 0, 0, 0, date ( 'm' ), date ( 'd' ), date ( 'Y' ) ) );
}

if ($data1 > $data2) {

コード例 #5

0

ファイルを表示

ファイル: estornar_venda_exibedados.php プロジェクト: renatomarinho/ASC

// WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A    //
// PARTICULAR PURPOSE.  See the GNU General Public License for more details:          //
//                                                                                    //
//  http://www.gnu.org/copyleft/gpl.html                                              //
//                                                                                    //
////////////////////////////////////////////////////////////////////////////////////////

if (! isset ( $_CONF ['PATH'] )) {
	require "../../config/default.php";
}

$validations = new validations ( );
$db = new db ( );
$db->connect ();

$controle = $validations->validNumeric ( $_GET ['c'] );

$sql = "SELECT l.nome AS vendedor, c.txtnome AS txtnomecliente, mvm.estornado AS estorno, SUM(mvm.quant) AS quantidade, SUM(mvm.vr_total) as valortotal, mvv.vr_totalvenda FROM mv_vendas_movimento AS mvm JOIN mv_vendas AS mvv ON (mvm.controle = mvv.controle)  LEFT JOIN cliente AS c ON mvm.id_cliente=c.idcliente LEFT JOIN cad_login AS l ON mvm.id_login=l.id WHERE mvm.controle='" . $controle . "' GROUP BY mvm.controle";

$query = $db->query ( $sql );

if ($db->num_rows ( $query )) {
	
	$row = $db->fetch_assoc ( $query );
	
	$datacontrole = timestamp_converte ( $controle, 0 );
	
	$confere_diferenca = dateDiff ( date ( 'd-m-Y', $controle ), date ( 'd-m-Y' ) );
	
	$estornados = 0;
	$quantidade_produtos = ( int ) $row ['quantidade'];

コード例 #6

0

ファイルを表示

ファイル: lista_grade_edicao.php プロジェクト: renatomarinho/ASC

}

$validations = new validations ( );
$db = new db ( );
$db->connect ();

/*
 * FIXME Change cad_empresa_id to dinamic id
 */

$sql = "SELECT reducao_estoque AS auth FROM configuracao WHERE cad_empresa_id=1";
$query = $db->query($sql);
$row = $db->fetch_assoc($query);
$auth = $row['auth'];

$idproduto = $validations->validNumeric ( $_GET ['id'] );

if (isset ( $_GET ['add_nomegrade'] ) && isset ( $_GET ['add_qtdgrade'] )) {
	
	$add_nomegrade = $validations->validStringForm ( $_GET ['add_nomegrade'] );
	$add_qtdgrade = $validations->validNumeric ( $_GET ['add_qtdgrade'] );
	$add_precounico = $validations->validStringForm ( $_GET ['add_precounico'] );
	
	$sql = "INSERT INTO cad_produtos_grade ( id_produto, descricao, quantidade, vlprodgrade ) VALUES ( " . $idproduto . ", '" . strtoupper ( $add_nomegrade ) . "', " . $add_qtdgrade . ", '" . $add_precounico . "' )";
	$db->query ( $sql );
	
	$sql = "UPDATE estoque SET nquantidade=nquantidade+" . $add_qtdgrade . " WHERE produto_idproduto=" . $idproduto . "";
	$db->query ( $sql );

}

コード例 #7

0

ファイルを表示

ファイル: produtos_vendidosperiodo_exibe.php プロジェクト: renatomarinho/ASC

// WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A    //
// PARTICULAR PURPOSE.  See the GNU General Public License for more details:          //
//                                                                                    //
//  http://www.gnu.org/copyleft/gpl.html                                              //
//                                                                                    //
////////////////////////////////////////////////////////////////////////////////////////

if (! isset ( $_CONF ['PATH'] )) {
	require "../../config/default.php";
}

$validations = new validations ( );
$db = new db ( );
$db->connect ();

$dia1 = (isset ( $_GET ['dia1'] )) ? $validations->validNumeric ( $_GET ['dia1'] ) : date ( 'd' );
$mes1 = (isset ( $_GET ['mes1'] )) ? $validations->validNumeric ( $_GET ['mes1'] ) : date ( 'm' );
$ano1 = (isset ( $_GET ['ano1'] )) ? $validations->validNumeric ( $_GET ['ano1'] ) : date ( 'Y' );

$data_dia1 = $dia1;
$data_mes1 = $mes1;
$data_ano1 = $ano1;
$data1 = date ( 'Y-m-d', mktime ( 0, 0, 0, $data_mes1, $data_dia1, $data_ano1 ) );

$dia2 = (isset ( $_GET ['dia2'] )) ? $validations->validNumeric ( $_GET ['dia2'] ) : date ( 'd' );
$mes2 = (isset ( $_GET ['mes2'] )) ? $validations->validNumeric ( $_GET ['mes2'] ) : date ( 'm' );
$ano2 = (isset ( $_GET ['ano2'] )) ? $validations->validNumeric ( $_GET ['ano2'] ) : date ( 'Y' );

$data_dia2 = $dia2;
$data_mes2 = $mes2;
$data_ano2 = $ano2;

コード例 #8

0

ファイルを表示

ファイル: admdados_adicionar_salvar.php プロジェクト: renatomarinho/ASC

//                                                                                    //
////////////////////////////////////////////////////////////////////////////////////////

if (! isset ( $_CONF ['PATH'] )) {
	require "../../config/default.php";
}

$validations = new validations ( );
$db = new db ( );
$db->connect ();

$login = strtoupper ( $validations->validStringForm ( $_POST ['login'] ) );

$sql = "SELECT id FROM cad_login WHERE login='******'";
$query = $db->query ( $sql );

if (! $db->num_rows ( $query )) {
	
	$nome = strtoupper ( $validations->validStringForm ( $_POST ['nome'] ) );
	$senha = md5 ( $_POST ['senha'] );
	$permissao = $validations->validNumeric ( $_POST ['permissao'] );
	
	$sql = "INSERT INTO cad_login ( login, senha, autoriza, ativo, nome ) VALUES ( '" . $login . "', '" . $senha . "', " . $permissao . ", 'ativo', '" . $nome . "' )";
	$db->query ( $sql );
	echo $db->insert_id ();

} else {
	echo '-';
}

?>

コード例 #9

0

ファイルを表示

ファイル: exibe_produto_selecionado_codbarra.php プロジェクト: renatomarinho/ASC

// WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A    //
// PARTICULAR PURPOSE.  See the GNU General Public License for more details:          //
//                                                                                    //
//  http://www.gnu.org/copyleft/gpl.html                                              //
//                                                                                    //
////////////////////////////////////////////////////////////////////////////////////////

if (! isset ( $_CONF ['PATH'] )) {
	require "../../config/default.php";
}

$validations = new validations ( );
$db = new db ( );
$db->connect ();

$codbarra = $validations->validNumeric ( $_GET ['cb'] );

$sql = 'SELECT p.idproduto, p.txtproduto, p.vlvarejo, p.vlatacado, p.vlprontaentrega, c.txtnome AS colecao, pt.txtnome AS tipo, f.nome AS fornecedor FROM produto AS p LEFT JOIN fornecedor AS f ON f.idfornecedor=p.fornecedor_idfornecedor LEFT JOIN produtotipo AS pt ON pt.idprodutotipo=p.produtotipo_idprodutotipo LEFT JOIN colecao AS c ON c.idcolecao=p.colecao_idcolecao WHERE p.cod_barra=' . $codbarra;
$query = $db->query ( $sql );

if ($db->num_rows ( $query )) {
	
	$row = $db->fetch_assoc ( $query );
	
	$idproduto = $row ['idproduto'];
	
	if ($row ['colecao']) {
		$colecao = $row ['colecao'];
	} else {
		$colecao = 'N�o atribu�da';
	}

コード例 #10

0

ファイルを表示

ファイル: produto_cadastrar_salvar.php プロジェクト: renatomarinho/ASC

// Foundation; either version 3 of the License, or (at your option) any later         //
// version.                                                                           //
//                                                                                    //
// This program is distributed in the hope that it will be useful, but WITHOUT ANY    // 
// WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A    //
// PARTICULAR PURPOSE.  See the GNU General Public License for more details:          //
//                                                                                    //
//  http://www.gnu.org/copyleft/gpl.html                                              //
//                                                                                    //
////////////////////////////////////////////////////////////////////////////////////////

if (! isset ( $_CONF ['PATH'] )) {
	require "../../config/default.php";
}
$validations = new validations ( );
$db = new db ( );
$db->connect ();

$_SESSION ['produto']['nome'] = strtoupper($validations->validStringForm($_POST['nome']));
$_SESSION ['produto']['codigo'] = strtoupper($validations->validStringForm($_POST['codigo']));
$_SESSION ['produto']['vlcusto'] = $validations->validStringForm($_POST['vlcusto']);
$_SESSION ['produto']['vlpentrega'] = $validations->validStringForm($_POST['vlpentrega']);
$_SESSION ['produto']['vlatacado'] = $validations->validStringForm($_POST['vlatacado']);
$_SESSION ['produto']['vlvarejo'] = $validations->validStringForm($_POST['vlvarejo']);
$_SESSION ['produto']['qtdestoque'] = $validations->validStringForm($_POST['qtdestoque']);
$_SESSION ['produto']['categoria'] = $validations->validNumeric($_POST['categoria']);
$_SESSION ['produto']['fornecedor'] = $validations->validNumeric($_POST['fornecedor']);
$_SESSION ['produto']['colecao'] = $validations->validNumeric($_POST['colecao']);
$_SESSION ['produto']['codbarra'] = $validations->validNumeric($_POST['codbarra']);

?>

コード例 #11

0

ファイルを表示

ファイル: grade_diminuiestoque_confirma.php プロジェクト: renatomarinho/ASC

// WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A    //
// PARTICULAR PURPOSE.  See the GNU General Public License for more details:          //
//                                                                                    //
//  http://www.gnu.org/copyleft/gpl.html                                              //
//                                                                                    //
////////////////////////////////////////////////////////////////////////////////////////

if (! isset ( $_CONF ['PATH'] )) {
	require "../../config/default.php";
}

$validations = new validations ( );
$db = new db ( );
$db->connect ();

$retirados = $validations->validNumeric ( $_GET ['retirados'] );

$id = $validations->validStringForm ( $_GET ['id'] );
$idgrade = $validations->validStringForm ( $_GET ['idgrade'] );
$total = $validations->validStringForm ( $_GET ['total'] );

?>
<table>
	<tr>
		<td><b style="color: blue">Para retirar "<?php 
echo $retirados;
?>
 ite<?php 
echo $retirados > 1 ? 'ns' : 'm';
?>
" do estoque, confirme os dados :</b></td>

コード例 #12

0

ファイルを表示

ファイル: efetuar_pagamento.php プロジェクト: renatomarinho/ASC

if (! isset ( $_CONF ['PATH'] )) {
	require "../../config/default.php";
}

$_POST['credit_id'] = 0;
$_POST['debit_id']  = 0;


$validations = new validations ( );
$db = new db ( );
$db->connect ();

$dados_cheque = array ();
$dados_credito = array ();

$idcliente = $validations->validNumeric($_POST['cliente']);
$idlogin = $validations->validNumeric($_POST['usuario']);
$vr_totalvenda = $validations->validNumeric($_POST['totalvenda']);
$vr_opcionalvenda = $validations->validNumeric($_POST['opcvenda']);
$vr_opcionalvenda_final = $validations->validNumeric($_POST['opcvenda_final']);
$parcelas = $validations->validNumeric($_POST['parcelas']);
$vr_dinheiro = $validations->validNumeric($_POST['dinheiro']);

if (! $vr_dinheiro || $vr_dinheiro < 0) {
	$vr_dinheiro = 0;
}

$vr_cheque = $validations->validNumeric($_POST['cheque']);
$vr_credito = $validations->validNumeric($_POST['credito']);
$vr_debito = $validations->validNumeric($_POST['debito']);
$vr_outro = $validations->validNumeric($_POST['outro']);

コード例 #13

0

ファイルを表示

ファイル: produto_cadastrar_salvar_final.php プロジェクト: renatomarinho/ASC

$db = new db ( );
$db->connect ();

$nome = $_SESSION ['produto'] ['nome'];
$codigo = $_SESSION ['produto'] ['codigo'];
$vlcusto = $_SESSION ['produto'] ['vlcusto'];
$vlpentrega = $_SESSION ['produto'] ['vlpentrega'];
$vlatacado = $_SESSION ['produto'] ['vlatacado'];
$vlvarejo = $_SESSION ['produto'] ['vlvarejo'];
$qtdestoque = $_SESSION ['produto'] ['qtdestoque'];
$categoria = $_SESSION ['produto'] ['categoria'];
$fornecedor = $_SESSION ['produto'] ['fornecedor'];
$colecao = $_SESSION ['produto'] ['colecao'];
$codbarra = $_SESSION ['produto'] ['codbarra'];

$nnota = ($_POST ['nnota']) ? $validations->validNumeric ( $_POST ['nnota'] ) : 0;
$icms = ($_POST ['icms']) ? $validations->validStringForm ( $_POST ['icms'] ) : 0;
$frete = ($_POST ['frete']) ? $validations->validStringForm ( $_POST ['frete'] ) : 0;
$vldesc = ($_POST ['vldesc']) ? $validations->validStringForm ( $_POST ['vldesc'] ) : 0;
$icmssub = ($_POST ['icmssub']) ? $validations->validStringForm ( $_POST ['icmssub'] ) : 0;
$ipi = ($_POST ['ipi']) ? $validations->validStringForm ( $_POST ['ipi'] ) : 0;
$vltotal = ($_POST ['vltotal']) ? $validations->validStringForm ( $_POST ['vltotal'] ) : 0;
$dtnota = $validations->validNumeric ( $_POST ['anonota'] ) . '-' . $validations->validNumeric ( $_POST ['mesnota'] ) . '-' . $validations->validNumeric ( $_POST ['dianota'] );

if ($fornecedor == 0)
	$fornecedor = $validations->validNumeric ( $_POST ['fornecedor'] );

if (isset ( $_SESSION ['gradeproduto'] ))
	$grade = 1;
else
	$grade = 0;

コード例 #14

0

ファイルを表示

ファイル: cancelamento_venda_salvarmotivo.php プロジェクト: renatomarinho/ASC

// version.                                                                           //
//                                                                                    //
// This program is distributed in the hope that it will be useful, but WITHOUT ANY    // 
// WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A    //
// PARTICULAR PURPOSE.  See the GNU General Public License for more details:          //
//                                                                                    //
//  http://www.gnu.org/copyleft/gpl.html                                              //
//                                                                                    //
////////////////////////////////////////////////////////////////////////////////////////

if (! isset ( $_CONF ['PATH'] )) {
	require "../../config/default.php";
}

$validations = new validations ( );
$db = new db ( );
$db->connect ();

$cliente = $validations->validNumeric ( $_POST ['cliente'] );
$usuario = $validations->validNumeric ( $_POST ['usuario'] );
$controle = $validations->validNumeric ( $_POST ['controle'] );
$valortotal = $validations->validStringForm ( $_POST ['valortotal'] );
$statusmotivo = $validations->validNumeric ( $_POST ['statusmotivo'] );
$textomotivo = $validations->validStringForm ( $_POST ['textomotivo'] );

$produtos_carrinho = print_r ( $_SESSION ['carrinho_venda'], true );

$sql = "INSERT INTO motivocancelamentovenda ( id_login, controle, vr_total, txtmotivo, idcliente, stmotivo, produtoscarrinho ) VALUES ( " . $usuario . ", '" . $controle . "', '" . $valortotal . "', '" . $textomotivo . "', " . $cliente . ", " . $statusmotivo . ", '" . $produtos_carrinho . "' )";
$db->query ( $sql );

?>

コード例 #15

0

ファイルを表示

ファイル: turno_fechar_dados_salvar.php プロジェクト: renatomarinho/ASC

// This program is free software; you can redistribute it and/or modify it under      //
// the terms of the GNU General Public License as published by the Free Software      //
// Foundation; either version 3 of the License, or (at your option) any later         //
// version.                                                                           //
//                                                                                    //
// This program is distributed in the hope that it will be useful, but WITHOUT ANY    // 
// WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A    //
// PARTICULAR PURPOSE.  See the GNU General Public License for more details:          //
//                                                                                    //
//  http://www.gnu.org/copyleft/gpl.html                                              //
//                                                                                    //
////////////////////////////////////////////////////////////////////////////////////////


if (! isset ( $_CONF ['PATH'] )) {
	require "../../config/default.php";
}

$db = new db ( );
$db->connect ();

$validations = new validations ( );

$fechamento = $validations->validNumeric ( $_POST ['f'] );
$valor_caixa = $validations->validStringForm ( $_POST ['v'] );

$sql = "UPDATE mv_caixa SET fechamento=" . $fechamento . ", vr_fechamento='" . $valor_caixa . "' ORDER BY id DESC LIMIT 1";
$db->query ( $sql );

?>

コード例 #16

0

ファイルを表示

ファイル: eventos.php プロジェクト: renatomarinho/ASC

// PARTICULAR PURPOSE.  See the GNU General Public License for more details:          //
//                                                                                    //
//  http://www.gnu.org/copyleft/gpl.html                                              //
//                                                                                    //
////////////////////////////////////////////////////////////////////////////////////////

if (! isset ( $_CONF ['PATH'] )) {
	require "../../config/default.php";
}

$validations = new validations ( );
$db = new db ( );
$db->connect ();

if (! isset ( $_GET ['id_agenda'] )) {
	$dinicio = $validations->validNumeric ( $_GET ['d1'] );
	$minicio = $validations->validNumeric ( $_GET ['m1'] );
	$ainicio = $validations->validNumeric ( $_GET ['a1'] );
	
	$diainicio = mktime ( 0, 0, 0, $minicio, $dinicio, $ainicio );
	$diafinal = mktime ( 23, 59, 59, $minicio, $dinicio, $ainicio );
	
	$sql = "SELECT idagendaeventos, inicio, final, tarefa, status FROM rvs_agendaeventos WHERE inicio>" . $diainicio . " AND final<" . $diafinal . "";
} else {
	$sql = "SELECT idagendaeventos, inicio, final, tarefa, status FROM rvs_agendaeventos WHERE idagendaeventos = " . $_GET ['id_agenda'];
}

$query = $db->query ( $sql );
$total = $db->num_rows ( $query );

$retorno = $total . "|*|";

コード例 #17

0

ファイルを表示

ファイル: fornecedor_dados.php プロジェクト: renatomarinho/ASC

// WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A    //
// PARTICULAR PURPOSE.  See the GNU General Public License for more details:          //
//                                                                                    //
//  http://www.gnu.org/copyleft/gpl.html                                              //
//                                                                                    //
////////////////////////////////////////////////////////////////////////////////////////

if (! isset ( $_CONF ['PATH'] )) {
	require "../../config/default.php";
}

$validations = new validations ( );
$db = new db ( );
$db->connect ();

$idfornecedor = $validations->validNumeric ( $_GET ['id'] );

$sql = "SELECT f.nome, f.cnpj, f.uf, f.cidade, f.endereco, f.contato, f.email, f.telefone, f.telefone2, f.fax, f.ie, f.cep, f.bairro, f.idpais, p.nome AS nomepais FROM fornecedor AS f INNER JOIN paises AS p ON f.idpais=p.numcode WHERE f.idfornecedor=" . $idfornecedor . "";
$query = $db->query ( $sql );
$rowfornecedor = $db->fetch_assoc ( $query );

$nome = $rowfornecedor ['nome'];
$cnpj = ($rowfornecedor ['cnpj']) ? $rowfornecedor ['cnpj'] : 'Não informado';
$uf = ($rowfornecedor ['uf']) ? $rowfornecedor ['uf'] : 'Não informado';
if ($uf == 'OU') {
	$uf = 'Exterior';
}

$cidade = ($rowfornecedor ['cidade']) ? $rowfornecedor ['cidade'] : 'Não informado';
$endereco = ($rowfornecedor ['endereco']) ? $rowfornecedor ['endereco'] : 'Não informado';
$contato = ($rowfornecedor ['contato']) ? $rowfornecedor ['contato'] : 'Não informado';

コード例 #18

0

ファイルを表示

ファイル: seleciona_produto.php プロジェクト: renatomarinho/ASC

if (! isset ( $_CONF ['PATH'] )) {
	require "../../config/default.php";
}
$validations = new validations ( );
$db = new db ( );
$db->connect ();

/*
 * FIXME Change cad_empresa_id to dinamic id
 */

if (! isset ( $_GET ['u'] )) {
	$_SESSION ['controlevenda'] = strtotime ( 'now' );
	unset ( $_SESSION ['carrinho_venda'] );
} else {
	$usuario = $validations->validNumeric($_GET ['u']);
	$cliente = $validations->validNumeric($_GET ['c']);
}

// Distinguindo tipo de venda
$txt_tipo_venda = "";
$key_tipo_venda = null;

switch (strtolower ( $_REQUEST['tipo_venda'] )) {
	case "vip" :
		$sql = "SELECT vendavip AS auth FROM configuracao WHERE cad_empresa_id=1";
		$txtTipoVenda = "VIP";
		$key_tipo_venda = "vip";
		break;
	
	case "normal" :

コード例 #19

0

ファイルを表示

ファイル: produto_mostradados.php プロジェクト: renatomarinho/ASC

// WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A    //
// PARTICULAR PURPOSE.  See the GNU General Public License for more details:          //
//                                                                                    //
//  http://www.gnu.org/copyleft/gpl.html                                              //
//                                                                                    //
////////////////////////////////////////////////////////////////////////////////////////

if (! isset ( $_CONF ['PATH'] )) {
	require "../../config/default.php";
}

$validations = new validations ( );
$db = new db ( );
$db->connect ();

$_GET ['id'] = $validations->validNumeric ( $_GET ['id'] );

$sql = "SELECT * FROM produto WHERE idproduto = " . $_GET ['id'];
$query = $db->query ( $sql );
$row = $db->fetch_assoc ( $query );
$sql = "SELECT nquantidade FROM estoque WHERE produto_idproduto = " . $_GET ['id'];
$query = $db->query ( $sql );
$rowestoque = $db->fetch_assoc ( $query );
$quantidade = $rowestoque ['nquantidade'];

?>

<fieldset id="m"><legend>Dados do Produto</legend>

<div class="linha_separador ls_conf_M">
<table width="100%">

コード例 #20

0

ファイルを表示

ファイル: efetuar_pagamento_vip.php プロジェクト: renatomarinho/ASC

//                                                                                    //
////////////////////////////////////////////////////////////////////////////////////////


if (! isset ( $_CONF ['PATH'] )) {
	require "../../config/default.php";
}

$validations = new validations ( );
$db = new db ( );
$db->connect ();

$dados_cheque = array ();
$dados_credito = array ();

$idcliente = $validations->validNumeric ( $_POST ['cliente'] );
$idlogin = $validations->validNumeric ( $_POST ['usuario'] );
$vr_totalvenda = $validations->validNumeric ( $_POST ['totalvenda'] );

$terminal = $validations->validNumeric ( $_POST ['terminal'] );

if (! isset ( $_SESSION ['turno'] )) {
	$turno = 0;
} else {
	$turno = $_SESSION ['turno'];
}

$sync_timestamp = strtotime ( 'now' );

$estornado = 0;

コード例 #21

0

ファイルを表示

ファイル: cliente_salvar.php プロジェクト: renatomarinho/ASC

//                                                                                    //
//  http://www.gnu.org/copyleft/gpl.html                                              //
//                                                                                    //
////////////////////////////////////////////////////////////////////////////////////////

if (! isset ( $_CONF ['PATH'] )) {
	require "../../config/default.php";
}

$validations = new validations ( );
$db = new db ( );
$db->connect ();

if (isset ( $_POST ['idcliente'] )) {
	
	$idcliente = $validations->validNumeric ( $_POST ['idcliente'] );
	
	$nome = strtoupper ( $validations->validStringForm ( $_POST ['nome'] ) );
	$endereco = strtoupper ( $validations->validStringForm ( $_POST ['endereco'] ) );
	$bairro = strtoupper ( $validations->validStringForm ( $_POST ['bairro'] ) );
	$cidade = strtoupper ( $validations->validStringForm ( $_POST ['cidade'] ) );
	$estado = strtoupper ( $validations->validStringForm ( $_POST ['estado'] ) );
	$dddtel = $validations->validNumeric ( $_POST ['dddtel'] );
	$tel1 = $validations->validNumeric ( $_POST ['tel1'] );
	$tel2 = $validations->validNumeric ( $_POST ['tel2'] );
	$dddcel = $validations->validNumeric ( $_POST ['dddcel'] );
	$cel1 = $validations->validNumeric ( $_POST ['cel1'] );
	$cel2 = $validations->validNumeric ( $_POST ['cel2'] );
	$cep = $validations->validNumeric ( $_POST ['cep'] . $_POST ['cepdv'] );
	$email = strtolower ( $validations->validStringForm ( $_POST ['email'] ) );
	$cpf = $validations->validStringForm ( $_POST ['cpf'] );

コード例 #22

0

ファイルを表示

ファイル: turno_abrir_dados_salvar.php プロジェクト: renatomarinho/ASC

// This program is distributed in the hope that it will be useful, but WITHOUT ANY    // 
// WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A    //
// PARTICULAR PURPOSE.  See the GNU General Public License for more details:          //
//                                                                                    //
//  http://www.gnu.org/copyleft/gpl.html                                              //
//                                                                                    //
////////////////////////////////////////////////////////////////////////////////////////


if (! isset ( $_CONF ['PATH'] )) {
	require "../../config/default.php";
}

$db = new db ( );
$db->connect ();

$validations = new validations ( );

$abertura = $validations->validNumeric ( $_POST ['ab'] );
$turno = $validations->validNumeric ( $_POST ['tu'] );
$terminal = $validations->validNumeric ( $_POST ['te'] );
$idusuario = $validations->validNumeric ( $_POST ['i'] );
$valor_caixa = $validations->validStringForm ( $_POST ['v'] );

$_SESSION ['turno'] = $turno;

$sql = "INSERT INTO mv_caixa ( abertura, vr_abertura, cad_login_id, turno, terminal, sync_timestamp ) VALUES ( " . $abertura . ", '" . $valor_caixa . "', " . $idusuario . ", '" . $turno . "', '" . $terminal . "', " . strtotime ( 'now' ) . " )";
$db->query ( $sql );

?>

コード例 #23

0

ファイルを表示

ファイル: admdados_editar_permisoes.php プロジェクト: renatomarinho/ASC

// Copyright (C) 2008 onwards Renato Marinho ( renato.marinho@greyland.com.br )         //
//                                                                                    //
// This program is free software; you can redistribute it and/or modify it under      //
// the terms of the GNU General Public License as published by the Free Software      //
// Foundation; either version 3 of the License, or (at your option) any later         //
// version.                                                                           //
//                                                                                    //
// This program is distributed in the hope that it will be useful, but WITHOUT ANY    // 
// WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A    //
// PARTICULAR PURPOSE.  See the GNU General Public License for more details:          //
//                                                                                    //
//  http://www.gnu.org/copyleft/gpl.html                                              //
//                                                                                    //
////////////////////////////////////////////////////////////////////////////////////////


if (! isset ( $_CONF ['PATH'] )) {
	require "../../config/default.php";
}

$validations = new validations ( );
$db = new db ( );
$db->connect ();

$idusuario = $validations->validNumeric ( $_GET ['i'] );
$permissoes = $validations->validStringForm ( $_GET ['p'] );

$sql = "UPDATE cad_login SET autoriza='" . $permissoes . "' WHERE id=" . $idusuario . "";
$db->query ( $sql );

?>

コード例 #24

0

ファイルを表示

ファイル: colecao_dados.php プロジェクト: renatomarinho/ASC

// WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A    //
// PARTICULAR PURPOSE.  See the GNU General Public License for more details:          //
//                                                                                    //
//  http://www.gnu.org/copyleft/gpl.html                                              //
//                                                                                    //
////////////////////////////////////////////////////////////////////////////////////////

if (! isset ( $_CONF ['PATH'] )) {
	require "../../config/default.php";
}

$validations = new validations ( );
$db = new db ( );
$db->connect ();

$idcolecao = $validations->validNumeric ( $_GET ['id'] );

$sql = "SELECT txtnome, txtperiodo, txtdescricao FROM colecao WHERE idcolecao=" . $idcolecao . "";
$query = $db->query ( $sql );
$rowcolecao = $db->fetch_assoc ( $query );
$txtnome = $rowcolecao ['txtnome'];
$txtperiodo = $rowcolecao ['txtperiodo'];
$txtdescricao = $rowcolecao ['txtdescricao'];

if (strlen ( $txtperiodo ) > 8) {
	$periodo_explode = explode ( ' até ', $txtperiodo );
	$periodo_1 = explode ( '/', $periodo_explode [0] );
	$periodo_2 = explode ( '/', $periodo_explode [1] );
	if ($periodo_1 [0] < 10)
		$periodo_1 [0] = str_replace ( '0', '', $periodo_1 [0] );
	if ($periodo_2 [0] < 10)

コード例 #25

0

ファイルを表示

ファイル: editar_OLD.php プロジェクト: renatomarinho/ASC

//  http://www.gnu.org/copyleft/gpl.html                                              //
//                                                                                    //
////////////////////////////////////////////////////////////////////////////////////////

if (! isset ( $_CONF ['PATH'] )) {
	require "../../config/default.php";
}

$validations = new validations ( );
$db = new db ( );
$db->connect ();

if (! isset ( $_GET ['id'] )) {
	$sql = " ORDER BY idcliente DESC";
} else {
	$idcliente = $validations->validNumeric ( $_GET ['id'] );
	$sql = "WHERE idcliente=" . $idcliente;
}

if (isset ( $_GET ['refer'] )) {
	$refer = $_GET ['refer'];
} else {
	$refer = '';
}

$sql = "SELECT idcliente, txtnome, txtendereco, txtcep, txtbairro, txtcidade, txtuf, txttelefone, txtcelular, txtemail, txtcpf, dtaniversario, txtrg, txtinf_adicional, dtcadastro FROM cliente " . $sql;

$query = $db->query ( $sql );

$row = $db->fetch_assoc ( $query );

コード例 #26

0

ファイルを表示

ファイル: grade_diminuiestoque_autentica.php プロジェクト: renatomarinho/ASC

// WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A    //
// PARTICULAR PURPOSE.  See the GNU General Public License for more details:          //
//                                                                                    //
//  http://www.gnu.org/copyleft/gpl.html                                              //
//                                                                                    //
////////////////////////////////////////////////////////////////////////////////////////

if (! isset ( $_CONF ['PATH'] )) {
	require "../../config/default.php";
}

$validations = new validations ( );
$db = new db ( );
$db->connect ();

$i = $validations->validNumeric($_GET ['i']);
$p = $_GET['p'];

$sql = "SELECT login FROM cad_login WHERE id=".$i." AND senha='".md5($p)."' AND ativo='ativo'";
$query = $db->query ( $sql );
if ($db->num_rows ( $query )) {
	$row = $db->fetch_assoc ( $query );
	if (permite ( $row ['login'], 4 ) == 1) {
		echo 'ok';
	} else {
		echo 'no';
	}
} else {
	echo 'erro';
}

コード例 #27

0

ファイルを表示

ファイル: exibe_produto_selecionado.php プロジェクト: renatomarinho/ASC

// WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A    //
// PARTICULAR PURPOSE.  See the GNU General Public License for more details:          //
//                                                                                    //
//  http://www.gnu.org/copyleft/gpl.html                                              //
//                                                                                    //
////////////////////////////////////////////////////////////////////////////////////////

if (! isset ( $_CONF ['PATH'] )) {
	require "../../config/default.php";
}

$validations = new validations ( );
$db = new db ( );
$db->connect ();

$idproduto = $validations->validNumeric ( $_GET ['p'] );

$sql = 'SELECT p.idproduto, p.txtproduto, p.vlvarejo, p.vlatacado, p.vlprontaentrega, c.txtnome AS colecao, pt.txtnome AS tipo, f.nome AS fornecedor FROM produto AS p LEFT JOIN fornecedor AS f ON f.idfornecedor=p.fornecedor_idfornecedor LEFT JOIN produtotipo AS pt ON pt.idprodutotipo=p.produtotipo_idprodutotipo LEFT JOIN colecao AS c ON c.idcolecao=p.colecao_idcolecao WHERE idproduto=' . $idproduto;
$query = $db->query ( $sql );
$row = $db->fetch_assoc ( $query );

if ($row ['colecao']) {
	$colecao = $row ['colecao'];
} else {
	$colecao = 'N�o atribu�da';
}

if ($row ['fornecedor']) {
	$fornecedor = $row ['fornecedor'];
} else {
	$fornecedor = 'N�o atribu�do';

コード例 #28

0

ファイルを表示

ファイル: fornecedor_salvar.php プロジェクト: renatomarinho/ASC

//  http://www.gnu.org/copyleft/gpl.html                                              //
//                                                                                    //
////////////////////////////////////////////////////////////////////////////////////////

if (! isset ( $_CONF ['PATH'] )) {
	require "../../config/default.php";
}

$validations = new validations ( );
$db = new db ( );
$db->connect ();

if (isset ( $_POST ['nomefornec'] ))
	$txtnome = strtoupper ( $validations->validStringForm ( $_POST ['nomefornec'] ) );
if (isset ( $_POST ['cpf'] ))
	$cnpj = $validations->validNumeric ( $_POST ['cpf'] );
if (isset ( $_POST ['estado'] ))
	$txtuf = $validations->validStringForm ( $_POST ['estado'] );
if (isset ( $_POST ['cidade'] ))
	$txtcidade = strtoupper ( $validations->validStringForm ( $_POST ['cidade'] ) );
if (isset ( $_POST ['endereco'] ))
	$txtendereco = strtoupper ( $validations->validStringForm ( $_POST ['endereco'] ) );
if (isset ( $_POST ['contato'] ))
	$txtcontato = strtoupper ( $validations->validStringForm ( $_POST ['contato'] ) );
if (isset ( $_POST ['email'] ))
	$txtemail = strtolower ( $validations->validStringForm ( $_POST ['email'] ) );
if (isset ( $_POST ['telefone'] ))
	$txttelefone = $validations->validNumeric ( $_POST ['telefone'] );
if (isset ( $_POST ['fax'] ))
	$txtfax = $validations->validNumeric ( $_POST ['fax'] );
if (isset ( $_POST ['idenest'] ))

コード例 #29

0

ファイルを表示

ファイル: empresa_salvar.php プロジェクト: renatomarinho/ASC

require "_language.php";

if (! isset ( $_CONF ['PATH'] )) {
	require "../../config/default.php";
}

$validations = new validations ( );
$db = new db ( );
$db->connect ();

$cnpj = $validations->validStringForm ( $_POST ['cnpj'] );
$ie = $validations->validStringForm ( $_POST ['ie'] );
$endereco = $validations->validStringForm ( $_POST ['endereco'] );
$bairro = $validations->validStringForm ( $_POST ['bairro'] );
$cidade = $validations->validStringForm ( $_POST ['cidade'] );
$estado = $validations->validStringForm ( $_POST ['estado'] );
$cep = $validations->validStringForm ( $_POST ['cep'] );
$tel = $validations->validStringForm ( $_POST ['tel'] );
$fax = $validations->validStringForm ( $_POST ['fax'] );
$email = $validations->validStringForm ( $_POST ['email'] );
$site = $validations->validStringForm ( $_POST ['site'] );
$filiais = ($validations->validNumeric ( $_POST ['filiais'] ) < 1) ? 1 : $validations->validNumeric ( $_POST ['filiais'] );
$qtdturnos = ($validations->validNumeric ( $_POST ['qtdturnos'] ) < 1) ? 1 : $validations->validNumeric ( $_POST ['qtdturnos'] );
$qtdterminais = ($validations->validNumeric ( $_POST ['qtdterminais'] ) < 1) ? 1 : $validations->validNumeric ( $_POST ['qtdterminais'] );

$sql = "UPDATE cad_empresa SET cnpj = '$cnpj', ie = '$ie', endereco = '$endereco', bairro = '$bairro', cidade = '$cidade', uf = '$estado', cep  = '$cep', telefone = '$tel', fax = '$fax', email = '$email', site = '$site', qtd_turnos = '$qtdturnos', qtd_terminal = '$qtdterminais', filiais=" . $filiais . " WHERE id = 1 LIMIT 1 ;";
$db->query ( $sql );

echo $_CONF['lang']['empresa_salvar'][0];

?>

コード例 #30

0

ファイルを表示

ファイル: buscaprodutos_refinado.php プロジェクト: renatomarinho/ASC

// WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A    //
// PARTICULAR PURPOSE.  See the GNU General Public License for more details:          //
//                                                                                    //
//  http://www.gnu.org/copyleft/gpl.html                                              //
//                                                                                    //
////////////////////////////////////////////////////////////////////////////////////////

if (! isset ( $_CONF ['PATH'] )) {
	require "../../config/default.php";
}

$validations = new validations ( );
$db = new db ( );
$db->connect ();

$fornecedor = $validations->validNumeric ( $_GET ['f'] );

if ($fornecedor != 0) {
	$sqlfor = " AND f.idfornecedor=" . $fornecedor . " ";
} else {
	$sqlfor = " ";
}

$tipo = $validations->validNumeric ( $_GET ['t'] );

if ($tipo != 0) {
	$sqltipo = " AND pt.idprodutotipo=" . $tipo . " ";
} else {
	$sqltipo = " ";
}

PHP validations::validNumericの例