[pedidos.php]
<?php header("Content-Type: text/html; charset=ISO-8859-1",true);
function datediff($date1, $date2) {
if ($date1 > $date2) {
return 1;
}
else {
return -1;
}
}
function diasdiff($data1) {
$ano1 = substr($data1,0,4);
$mes1 = substr($data1,5,2);
$dia1 = substr($data1,8,2);
$data2 = date("Y-m-d");
$ano2 = substr($data2,0,4);
$mes2 = substr($data2,5,2);
$dia2 = substr($data2,8,2);
$timestamp1 = mktime(0,0,0,$mes1,$dia1,$ano1);
$timestamp2 = mktime(0,0,0,$mes2,$dia2,$ano2);
$segundos_diferenca = $timestamp1 - $timestamp2;
return $segundos_diferenca / (60 * 60 * 24);
}
include "config.inc.php";
$conexao = mysql_connect($sql_servidor,$sql_login,$sql_senha) or die ("(erro ao conectar: ".mysql_error());
mysql_select_db($sql_banco,$conexao) or die(mysql_error());
$query="SELECT title,loja, dt_compra,dt_venda,dt_prv_ent,md5sum FROM encomendas WHERE status <>'CANC' ORDER BY dt_venda,loja";
$resultado = mysql_query($query,$conexao) or die(mysql_error());
echo "<TABLE border=1 width=100%>";
echo "<TR>";
echo "<TD>Título</TD>";
echo "<TD>Loja</TD>";
echo "<TD>Data Compra</TD>";
echo "<TD>Data Envio</TD>";
echo "<TD>Prev. Entrega</TD>";
echo "<TD>x</TD>";
echo "</TR>";
while($linha = mysql_fetch_array($resultado)){
echo "<TR>";
echo "<TD>".$linha['title']."</TD>";
echo "<TD>".$linha['loja']."</TD>";
echo "<TD>".$linha['dt_compra']."</TD>";
echo "<TD";
if (datediff($linha['dt_venda'],date("Y-m-d")) <0) {
echo " bgcolor=darkgreen style='color: rgb(255,255,255);'";
}
echo ">".$linha['dt_venda']."</TD>";
$x="";
echo "<TD";
if (datediff($linha['dt_prv_ent'],date("Y-m-d")) <0) {
echo " bgcolor=darkred style='color: rgb(255,255,255);'";
$x= "(".diasdiff($linha['dt_prv_ent']).")";
}
echo ">".$linha['dt_prv_ent']." ".$x."</TD>";
echo "<TD><IMG SRC=http://m.lins.eti.br/ipod/imagem_enc.php?tam=m&id=".$linha['md5sum']." height='250' width='200'/></TD>";
echo "</TR>";
}/*
*/
echo "</TABLE>";
?>
[config.inc.php]
<?php
$sql_servidor="localhost";
$sql_login="";
$sql_senha="";
$sql_banco="";
$retorno=0;
$titulo="";
?>
[cadastra.php]
<?php
include "config.inc.php";
?>
<html>
<head>
<title>Incluir nova encomenda</title>
</head>
<body bgcolor="#FFFFFF">
<h2> Incluir nova encomenda</h2>
<?
//VERIFICA SE O FORM FOI ENVIADO
if($_POST) {
//CONECTA AO MYSQL
$conexao = mysql_connect($sql_servidor,$sql_login,$sql_senha) or die ("(erro ao conectar: ");
mysql_select_db($sql_banco,$conexao) or die(mysql_error());
//RECEBE DADOS DO FORMULÃRIO
$pFoto = $_FILES["txtFoto"]["tmp_name"];
//MOVE
move_uploaded_file($pFoto, "latest.img");
$pmd5 = md5_file("latest.img");
//ABRE ARQUIVO
$pont = fopen("latest.img", "rb");
//PERCORRE O ARQUIVO
$dados = addslashes(fread($pont, filesize("latest.img")));
//INSERE NA BASE DE DADOS
$query="INSERT INTO encomendas (title, loja, dt_compra, dt_venda, dt_prv_ent, data, md5sum) VALUES(upper('";
$query.=$_POST["title"]."'),upper('".$_POST["loja"]."'),'".$_POST["dt_compra"]."','".$_POST["dt_venda"]."','".$_POST["dt_prv_ent"]."','".$dados."', '".$pmd5."')";
$resultado = mysql_query($query,$conexao) or die(mysql_error());
echo "<table border='0' cellpading='0' cellspacing='0' width='95%'>";
//LINHAS AFETADAS
$row = mysql_affected_rows($conexao);
//TOTAL DE LINHAS AFETADAS PELA INSERÇÃO
if($row) {
echo "<tr>";
echo "<td>Inclusao efetuada com Sucesso!";
echo $row."</td>";
echo "</tr>";
}//FECHA IF ( num_rows )
else {
echo "<tr>";
echo "<td>Erro na inclusão da foto!";
echo "</tr>";
}//FECHA ELSE
echo "</table>";
}//FECHA IF ( post )
//EXIBE O FORMULÃRIO
else { ?>
<form name="frmFoto" method="post" enctype="multipart/form-data">
<table border="0" cellpading="0" cellspacing="0" width="95%">
<tr>
<td height="50">Titulo:</td>
<td><input type="text" name="title" size="35"></td>
</tr>
<tr>
<td height="50">Loja:</td>
<td><input type="text" name="loja" size="35"></td>
</tr>
<tr>
<td height="50">Dt. Compra:</td>
<td><input type="text" name="dt_compra" size="10">aaaa-mm-dd</td>
</tr>
<tr>
<td height="50">Dt. Envio:</td>
<td><input type="text" name="dt_venda" size="10">aaaa-mm-dd</td>
</tr>
<tr>
<td height="50">Dt. Prv. Chegada:</td>
<td><input type="text" name="dt_prv_ent" size="10">aaaa-mm-dd</td>
</tr>
<tr>
<td height="50">Foto:</td>
<td><input type="file" name="txtFoto" size="35"></td>
</tr>
<tr>
<td colspan="2">
<input type="submit" name="Enviar"></td>
</tr>
</table>
</form>
<?
}//FECHA ELSE ?>
</body>
</html>
[create table mysql]
<?php
include "../includes/config.inc.php";
?>
<html>
<head>
<title>Incluir nova encomenda</title>
</head>
<body bgcolor="#FFFFFF">
<h2> Incluir nova encomenda</h2>
<?
//VERIFICA SE O FORM FOI ENVIADO
if($_POST) {
//CONECTA AO MYSQL
$conexao = mysql_connect($sql_servidor,$sql_login,$sql_senha) or die ("(erro ao conectar: ");
mysql_select_db($sql_banco,$conexao) or die(mysql_error());
//RECEBE DADOS DO FORMULÃRIO
$pFoto = $_FILES["txtFoto"]["tmp_name"];
//MOVE
move_uploaded_file($pFoto, "latest.img");
$pmd5 = md5_file("latest.img");
//ABRE ARQUIVO
$pont = fopen("latest.img", "rb");
//PERCORRE O ARQUIVO
$dados = addslashes(fread($pont, filesize("latest.img")));
//INSERE NA BASE DE DADOS
$query="INSERT INTO encomendas (title, loja, dt_compra, dt_venda, dt_prv_ent, data, md5sum) VALUES(upper('";
$query.=$_POST["title"]."'),upper('".$_POST["loja"]."'),'".$_POST["dt_compra"]."','".$_POST["dt_venda"]."','".$_POST["dt_prv_ent"]."','".$dados."', '".$pmd5."')";
$resultado = mysql_query($query,$conexao) or die(mysql_error());
echo "<table border='0' cellpading='0' cellspacing='0' width='95%'>";
//LINHAS AFETADAS
$row = mysql_affected_rows($conexao);
//TOTAL DE LINHAS AFETADAS PELA INSERÇÃO
if($row) {
echo "<tr>";
echo "<td>Inclusao efetuada com Sucesso!";
echo $row."</td>";
echo "</tr>";
}//FECHA IF ( num_rows )
else {
echo "<tr>";
echo "<td>Erro na inclusão da foto!";
echo "</tr>";
}//FECHA ELSE
echo "</table>";
}//FECHA IF ( post )
//EXIBE O FORMULÃRIO
else { ?>
<form name="frmFoto" method="post" enctype="multipart/form-data">
<table border="0" cellpading="0" cellspacing="0" width="95%">
<tr>
<td height="50">Titulo:</td>
<td><input type="text" name="title" size="35"></td>
</tr>
<tr>
<td height="50">Loja:</td>
<td><input type="text" name="loja" size="35"></td>
</tr>
<tr>
<td height="50">Dt. Compra:</td>
<td><input type="text" name="dt_compra" size="10">aaaa-mm-dd</td>
</tr>
<tr>
<td height="50">Dt. Envio:</td>
<td><input type="text" name="dt_venda" size="10">aaaa-mm-dd</td>
</tr>
<tr>
<td height="50">Dt. Prv. Chegada:</td>
<td><input type="text" name="dt_prv_ent" size="10">aaaa-mm-dd</td>
</tr>
<tr>
<td height="50">Foto:</td>
<td><input type="file" name="txtFoto" size="35"></td>
</tr>
<tr>
<td colspan="2">
<input type="submit" name="Enviar"></td>
</tr>
</table>
</form>
<?
}//FECHA ELSE ?>
</body>
</html>