Publicado em 29 de mar.

Inserir datas no "insert" do CRUD

Olá pessoal estou com dificuldades de inserir datas (diferença entre datas) no INSERT do CRUD e converte -las para nossa ralidade alguem pode analisar o meu projeto.

A principio o INDEX:

<!DOCTYPE html>

<html lang="pt - BR">

<head>

 <meta charset="utf-8">
 <meta http-equiv="X-UA-Compatible" content="IE=edge">
 <meta name="viewport" content="width=device-width, initial-scale=1">
 <meta name="description" content="">
 <meta name="author" content="">

 <title>ARMSTRONGTEC</title>

 <!-- Bootstrap Core CSS -->
 <link href="../bower_components/bootstrap/dist/css/bootstrap.min.css" rel="stylesheet">

 <!-- MetisMenu CSS -->
 <link href="[https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/bootstrap.min.css](https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/bootstrap.min.css)" rel="stylesheet">

 <!-- MetisMenu CSS -->
 <link href="[https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/metisMenu.min.css](https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/metisMenu.min.css)" rel="stylesheet">

 <!-- Timeline CSS -->
 <link href="[https://ia601500.us.archive.org/26/items/www.armstrongtec1.com_937/timeline.css](https://ia601500.us.archive.org/26/items/www.armstrongtec1.com_937/timeline.css)" rel="stylesheet">

 <!-- Custom CSS -->
 <link href="[https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/sb-admin-2.css](https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/sb-admin-2.css)" rel="stylesheet">

 <!-- Morris Charts CSS -->
 <link href="[https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/morris.css](https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/morris.css)" rel="stylesheet">

 <!-- Custom Fonts -->
 <link href="[https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/font-awesome.min.css](https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/font-awesome.min.css)" rel="stylesheet" type="text/css">

 <link href="[https://ia801502.us.archive.org/27/items/www.armstrongtec1.com_215/font-awesome.css](https://ia801502.us.archive.org/27/items/www.armstrongtec1.com_215/font-awesome.css)" rel="stylesheet" type="text/css">

 <link href=" [https://ia801506.us.archive.org/24/items/www.armstrongtec1.com_869/dataTables.responsive.css](https://ia801506.us.archive.org/24/items/www.armstrongtec1.com_869/dataTables.responsive.css)" rel="stylesheet">

 <link rel="shortcut icon" href="[https://ia902607.us.archive.org/18/items/logoCpflRenovaveis/CPFL.jpg](https://ia902607.us.archive.org/18/items/logoCpflRenovaveis/CPFL.jpg)">

 <link href="[http://netdna.bootstrapcdn.com/twitter-bootstrap/2.2.2/css/bootstrap-combined.min.css](http://netdna.bootstrapcdn.com/twitter-bootstrap/2.2.2/css/bootstrap-combined.min.css)" rel="stylesheet">

<!--[if lt IE 9]>

 <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
 <script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
 <![endif]-->

</head>

<body>

 <div id="wrapper">

 <!-- Navigation -->
 <nav class="navbar navbar-default navbar-static-top" role="navigation" style="margin-bottom: 0">
 <div class="navbar-header">
 <a href="index.php"><img src="[https://ia902607.us.archive.org/18/items/logoCpflRenovaveis/CPFL.jpg](https://ia902607.us.archive.org/18/items/logoCpflRenovaveis/CPFL.jpg)"width="60" height="60"></a>

 <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
 <span class="sr-only">Toggle navigation</span>
 <span class="icon-bar"></span>
 <span class="icon-bar"></span>
 <span class="icon-bar"></span>
 </button>
 <a class="navbar-brand" href="index.php"></a>
 <!-- <img src="LINK DA IMAGEM" border=0">-->
 </div>
 <!-- /.navbar-header -->

 <ul class="nav navbar-top-links navbar-right">
 <li class="dropdown">
 <!-- <a class="dropdown-toggle" data-toggle="dropdown" href="#"> -->
 <!-- <i class="fa fa-envelope fa-fw"></i> <i class="fa fa-caret-down"></i> -->
 </a>

 <!-- /.dropdown-messages -->
 </li>
 <!-- /.dropdown -->
 <li class="dropdown">
 <!-- <a class="dropdown-toggle" data-toggle="dropdown" href="#"> -->
 <!-- <i class="fa fa-tasks fa-fw"></i> <i class="fa fa-caret-down"></i> -->
 </a>

 <!-- /.dropdown-tasks -->
 </li>
 <!-- /.dropdown -->
 <li class="dropdown">
 <!-- <a class="dropdown-toggle" data-toggle="dropdown" href="#"> -->
 <!-- <i class="fa fa-bell fa-fw"></i> <i class="fa fa-caret-down"></i> -->
 </a>

 <!-- /.dropdown-alerts -->
 </li>
 <!-- /.dropdown -->
 <li class="dropdown">
 <a class="dropdown-toggle" data-toggle="dropdown" href="#">
 <i class="fa fa-user fa-fw"></i> <i class="fa fa-caret-down"></i>
 </a>
 <ul class="dropdown-menu dropdown-user">
 <li><a href="#"><i class="fa fa-user fa-fw"></i> User Profile</a>
 </li>
 <li><a href="#"><i class="fa fa-gear fa-fw"></i> Settings</a>
 </li>
 <li class="divider"></li>
 <li><a href="login.php"><i class="fa fa-sign-out fa-fw"></i> Logout</a>
 </li>
 </ul>
 <!-- /.dropdown-user -->
 </li>
 <!-- /.dropdown -->
 </ul>
 <!-- /.navbar-top-links -->

 <div class="navbar-default sidebar" role="navigation">
 <div class="sidebar-nav navbar-collapse">
 <ul class="nav" id="side-menu">
 <!-- <li class="sidebar-search">
 <div class="input-group custom-search-form">
 <input type="text" class="form-control" placeholder="Search...">
 <span class="input-group-btn">
 <button class="btn btn-default" type="button">
 <i class="fa fa-search"></i>
 </button>
 </span>
 </div> -->
 <!-- /input-group -->

 <li>
 <a href="index.php"><i class="fa fa-dashboard fa-fw"></i> Relatórios<span class="fa arrow"></span></a>
 <ul class="nav nav-second-level">
 <li>
 <a href="#"><i class="fa fa-wrench"></i> Manutenções</a>
 </li>
 <li>
 <a href="#"><i class="fa fa-flash"></i> Ocorrencias</a>
 </li>
 <li>
 <a href="#"><i class="fa fa-gavel"></i> Intervenções</a>
 </li>
 </ul>
 </li>
 <li>
 <a href="#"><i class="fa fa-bar-chart-o fa-fw"></i> Índices<span class="fa arrow"></span></a>
 <ul class="nav nav-second-level">
 <li>
 <a href="PieChart.php"><i class="fa fa-bar-chart-o fa-fw"></i> Manutenções</a>
 </li>
 <li>
 <a href="AreChart.php"><i class="fa fa-bar-chart-o fa-fw"></i> Ocorrências</a>
 </li>
 <li>
 <a href="ColumnChart.php"><i class="fa fa-bar-chart-o fa-fw"></i> Intervenções</a>
 </li>
 </ul>
 <!-- /.nav-second-level -->
 </li>
 <li>
 <a href="registroManutencao.php"><i class="fa fa-table fa-fw"></i> Registro<span class="fa arrow"></span></a>
 <ul class="nav nav-second-level">
 <li>
 <a href="registroManutencao.php"><i class="fa fa-wrench"></i> Manutenções</a>
 </li>
 <li>
 <a href="registroOcorrencia.php"><i class="fa fa-flash"></i> Ocorrências</a>
 </li>
 <li>
 <a href="registroIntervencao.php"><i class="fa fa-gavel"></i> Intervenções</a>
 </li>
 </ul>
 </li>
 <li>
 <a href="forms.php"><i class="fa fa-edit fa-fw"></i> Formulários <span class="fa arrow"></span></a>
 <ul class="nav nav-second-level">
 <li>
 <a href="flot.php"><i class="fa fa-wrench"></i> Manutenções</a>
 </li>
 <li>
 <a href="registroIntervencao"><i class="fa fa-flash"></i> Ocorrencias</a>
 </li>
 <li>
 <a href="registroIntervencao"><i class="fa fa-gavel"></i> Intervenções</a>
 </li>
 </ul>
 </li>
 <li>
 <a href="#"><i class="fa fa-wrench fa-fw"></i> Manutenções pendentes<span class="fa arrow"></span></a>
 <ul class="nav nav-second-level">
 <!-- <li>
 <a href="panels-wells.php">Panels and Wells</a>
 </li>
 <li>
 <a href="buttons.php">Buttons</a>
 </li>
 <li>
 <a href="notifications.php">Notifications</a>
 </li>
 <li>
 <a href="typography.php">Typography</a>
 </li>
 <li>
 <a href="icons.php"> Icons</a>
 </li>
 <li>
 <a href="grid.php">Grid</a>
 </li>
 </ul> -->
 <!-- /.nav-second-level -->
 </li>
 <li>
 <a href="#"><i class="fa fa-sitemap fa-fw"></i> Consulta<span class="fa arrow"></span></a>
 <ul class="nav nav-second-level">
 <li>
 <a href="consulta.php"><i class="fa fa-database"></i> Consultas</a>
 </li>
 <li>

 <a href="#"><i class="fa fa-flash"></i> Gerar O.S</a>
 </li>
 <li>

 <a href="#"><i class="fa fa-tasks"></i> Gerar Programações<span class="fa arrow"></span></a>

 <ul class="nav nav-third-level">
 <li>
 <a href="flot.php"><i class="fa fa-wrench"></i> Manutenções</a>
 </li>
 <li>
 <a href="registroIntervencao"><i class="fa fa-flash"></i> Ocorrencias</a>
 </li>
 <li>
 <a href="registroIntervencao"><i class="fa fa-gavel"></i> Intervenções</a>
 </li>
 </ul>
 <!-- /.nav-third-level -->
 </li>
 </ul>
 <!-- /.nav-second-level -->
 </li>
 <li>
 <a href="#"><i class="fa fa-sitemap fa-fw"></i> Operação<span class="fa arrow"></span></a>
 <ul class="nav nav-second-level">
 <li>

 <a href="chart.php"><i class="fa fa-tasks"></i> Programação</a>
 </li>
 <li>

 <a href="login.php"><i class="fa fa-user"></i> Login</a>
 </li>
 </ul>
 <!-- /.nav-second-level -->
 </li>
 </ul>
 </div>
 <!-- /.sidebar-collapse -->
 </div>
 <!-- /.navbar-static-side -->
 </nav>

 <!-- Page Content -->
 <div id="page-wrapper">
 <div class="container-fluid">
 <div class="row">
 <div class="col-lg-12">
 <div class="container">

 <div class="row">
 <div class="well">
 <div id="datetimepicker" class="input-append date">
 <input type="text"></input>
 <span class="add-on">
 <i data-time-icon="icon-time" data-date-icon="icon-calendar"></i>
 </span>
 </div>
 <script type="text/javascript"
 src="http://cdnjs.cloudflare.com/ajax/libs/jquery/1.8.3/jquery.min.js">
 </script>
 <!-- <script type="text/javascript"
 src="http://netdna.bootstrapcdn.com/twitter-bootstrap/2.2.2/js/bootstrap.min.js">
 </script>-->
 <script type="text/javascript"
 src="http://tarruda.github.com/bootstrap-datetimepicker/assets/js/bootstrap-datetimepicker.min.js">
 </script>

 <script type="text/javascript">
 $('#datetimepicker').datetimepicker({
 format: 'dd/MM/yyyy hh:mm:ss',
 language: 'pt-BR'
 });
 </script>
</div>

 </div>
 <h1 class="page-header"><i class="fa fa-bar-chart-o fa-fw"></i> Sistema Geral de Manutenção</a></h1>
 <title>Diário de Manutenção</title>
 <meta charset="UTF-8">
 <meta name="viewport" content="width=device-width, initial-scale=1.0">
 <script type="text/javascript" src="https://www.google.com/jsapi"></script>
 <script type="text/javascript">

 google.load("visualization", "1", {packages:["corechart"]});
 google.setOnLoadCallback(drawChart);
 function drawChart() {
 var data = google.visualization.arrayToDataTable([
 [ 'equipamento', 'total'],

<?php
$link = mysqli_connect('localhost', 'root', 'STRONG', 'gestao');
$sth = mysqli_query($link, "SELECT equipamento, sum(total) from progarmacao group by equipamento");

while ($r = mysqli_fetch_array($sth)) {

 echo "['$r[0]', $r[1]],\n";
}
?>
 ]);

 var options = {
 title: 'Programação',
 is3D: true,
 };

 var chart = new google.visualization.PieChart(document.getElementById('piechart_3d'));
 chart.draw(data, options);
 }
 </script>
 </head>
 <body>
 <div id="piechart_3d" style="width: 600px; height: 400px;"></div>
 </body>

</div>
 <!-- Page Content -->
</div>

 <a href="PieChart/create.php" class="btn btn-primary">Novo Registro</a>
 <br>
 <br>
 <div>

 </div>
 <div class="container">
 </div>
 <!-- /.panel-heading -->

 <table class="table table-striped table-hover" id="dataTables-example">
 <thead>
 <tr>
 <th>Site</th>
 <th>Data_inicio</th>
 <th>Data_fim</th>
 <th>Equipamento</th>
 <th>Total</th>
 <th>total_horas</th>
 <th>Ação</th>
 </tr>
 </thead>
 <tbody>

 <?php

 include 'PieChart/basedados.php';

 $pdo = Database::connect();
 $sql = 'SELECT * FROM progarmacao ORDER BY id DESC';

 foreach ($pdo->query($sql) as $row) {
 echo '<tr>';
 echo '<td>'. $row['site'] . '</td>';
 echo '<td>'. $row['inicio'] . '</td>';
 echo '<td>'. $row['fim'] . '</td>';
 echo '<td>'. $row['equipamento'] . '</td>';
 echo '<td>'. $row['total'] . '</td>';
 echo '<td>'. $row['total_horas'] . '</td>';

 echo '<td width=250>';
 echo '<a class="btn btn-warning" href="PieChart/read.php?id='.$row['id'].'">Ler</a>';
 echo ' ';
 echo '<a class="btn btn-success" href="PieChart/update.php?id='.$row['id'].'">Atualizar</a>';
 echo ' ';
 echo '<a class="btn btn-danger" href="PieChart/delete.php?id='.$row['id'].'">Excluir</a>';
 echo '</td>';
 echo '</tr>';

 }
 Database::disconnect();
 ?>

 </tbody>
 </table>
 </div>
 </div> <!-- /container -->
 <!-- /.col-lg-12 -->
 </div>
 <!-- /.row -->
 </div>
 <!-- /.container-fluid -->
 </div>
 <!-- /#page-wrapper -->

 </div>
 <!-- /#wrapper -->

 <!-- jQuery -->
 <!-- jQuery -->

 <!-- Bootstrap Core JavaScript -->
 <script src="https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/bootstrap.min.js"></script>

 <!-- Metis Menu Plugin JavaScript -->
 <script src="[https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/metisMenu.min.css](https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/metisMenu.min.css)"></script>

 <!-- DataTables JavaScript -->
 <script src="https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/jquery.dataTables.min.js"></script>
 <script src="https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/dataTables.bootstrap.min.js"></script>

 <!-- Custom Theme JavaScript -->
 <script src="https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/sb-admin-2.js"></script>

 <!-- Page-Level Demo Scripts - Tables - Use for reference -->
 <script>
 <script src="https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/jquery.min.js"></script>

 <!-- Bootstrap Core JavaScript -->
 <script src="https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/bootstrap.min.js"></script>

 <!-- Metis Menu Plugin JavaScript -->
 <script src="[https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/metisMenu.min.css](https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/metisMenu.min.css)"></script>

 <!-- Morris Charts JavaScript -->
 <script src="https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/raphael-min.js"></script>

 <script src="https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/morris.min.js"></script>

 <script src="https://ia601500.us.archive.org/26/items/www.armstrongtec1.com_937/morris-data.js"></script>

 <!-- Custom Theme JavaScript -->
 <script src="https://ia801506.us.archive.org/6/items/www.armstrongtec1.com/sb-admin-2.js"></script>

 <script src="https://ia801506.us.archive.org/24/items/www.armstrongtec1.com_869/metisMenu.js"></script>

 <script src="https://ia801506.us.archive.org/24/items/www.armstrongtec1.com_869/select.js"></script>

 <script src="https://ia801506.us.archive.org/24/items/www.armstrongtec1.com_869/flot-data.js"></script>

 <script src=" [https://ia801506.us.archive.org/24/items/www.armstrongtec1.com_869/dataTables.jPaginator.js](https://ia801506.us.archive.org/24/items/www.armstrongtec1.com_869/dataTables.jPaginator.js)"></script>

 <!-- Page-Level Demo Scripts - Tables - Use for reference -->
 <script>

 $(document).ready(function() {
 $('#dataTables-example').DataTable({
 responsive: true
 });
 });
 </script>

</body>

</html>

Agora o INSERT:

<?php

require '../basedado.php';

if ( !empty($_POST)) {

// keep track validation errors

$siteError = null;
$inicio = null;
$fim = null;
$equipamentoError = null;
$totalError = null;
//$total_horasError = null;
//$dataError = null;

// keep track post values

$site = $_POST['site'];
$inicio = $_POST['inicio'];
$fim = $_POST['fim'];
$equipamento = $_POST['equipamento'];
$total = $_POST['total'];
 //$total_horas = $_POST['total_horas'];

// validate input

$valid = true;
if (empty($site)) {

$siteError = 'Entre com Site';
$valid = false;
}

if (empty($inicio)) {

$inicioError = 'Entre com Data_inicio';
$valid = false;
}

if (empty($fim)) {

$fimError = 'Entre com Data_fim';
$valid = false;
}

if (empty($equipamento)) {

$equipamentoError = 'Entre com Equipamento';
$valid = false;

}

if (empty($total)) {

$totalError = 'Entre com Total';
$valid = false;
}

//if (empty($total_hora)) {

// $total_horaError = 'Entre com Total';
// $valid = false;

//}

$inicio = DateTime::createFromFormat('d-m-Y H:i:s', $inicio));

$fim = DateTime::createFromFormat('d-m-Y H:i:s', $fim));

$diff = $inicio->diff($fim);

$dias = $diff->format('%d');
$horas = $diff->format('%h');
$minutos = $diff->format('%i');
$segundos = $diff->format('%s');

$total_horas = ($dias * 24) + $horas;

$total_horas . ':' . $minutos . ':' . $segundos;

// insert data

if ($valid) {
$pdo = Database::connect();
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = "INSERT INTO progarmacao (site,inicio,fim,equipamento,total) values(?, ?, ?, ?, ?)";
$q = $pdo->prepare($sql);
$q->execute(array($site,$inicio,$fim$equipamento,$total);
Database::disconnect();
header("Location: ../PieChart.php");
}
}
?>

<!DOCTYPE html>

<html lang="pt - BR">
<head>
 <meta charset="utf-8">
 <link href="../css/bootstrap.min.css" rel="stylesheet">
 <script src="js/bootstrap.min.js"></script>
</head>

<body>
 <div class="container">

 <div class="span10 offset1">
 <div class="row">
 <h3>Novo Registro</h3>
 </div>

 <form class="form-horizontal" action="create.php" method="post">
 <div class="control-group <?php echo !empty($siteError)?'error':'';?>">
 <label class="control-label">Site</label>
 <div class="controls">
 <input name="site" type="text" placeholder="Site" value="<?php echo !empty($site)?$site:'';?>">
 <?php if (!empty($siteError)): ?>
 <span class="help-inline"><?php echo $siteError;?></span>
 <?php endif; ?>
 </div>
 </div>
 <div class="control-group <?php echo !empty($inicioError)?'error':'';?>">
 <label class="control-label">Data_inicio</label>
 <div class="controls">
 <input name="inicio" type="DateTime" placeholder="Data_inicio" value="<?php echo !empty($inicioError)?$inicio:'';?>">
 <?php if (!empty($inicioError)): ?>
 <span class="help-inline"><?php echo $inicioError;?></span>
 <?php endif; ?>
 </div>
 </div>
 <div class="control-group <?php echo !empty($fimError)?'error':'';?>">
 <label class="control-label">Data_fim</label>
 <div class="controls">
 <input name="fim" type="DateTime" placeholder="Data_fim" value="<?php echo !empty($fimError)?$fim:'';?>">
 <?php if (!empty($fimError)): ?>
 <span class="help-inline"><?php echo $fimError;?></span>
 <?php endif; ?>
 </div>
 </div>
 <div class="control-group <?php echo !empty($equipamentoError)?'error':'';?>">
 <label class="control-label">Equipamento</label>
 <div class="controls">
 <input name="equipamento" type="text" placeholder="Equipamento" value="<?php echo !empty($equipamento)?$equipamento:'';?>">
 <?php if (!empty($equipamentoError)): ?>
 <span class="help-inline"><?php echo $equipamentoError;?></span>
 <?php endif;?>
 </div>
 </div>

 <div class="control-group <?php echo !empty($totalError)?'error':'';?>">
 <label class="control-label">Total</label>
 <div class="controls">
 <input name="total" type="DateTime" placeholder="Total" value="<?php echo !empty($total)?$total:'';?>">
 <?php if (!empty($totalError)): ?>
 <span class="help-inline"><?php echo $totalError;?></span>
 <?php endif;?>
 </div>
 </div>

 <div class="control-group <?php echo !empty($total_horasError)?'error':'';?>">
 <label class="control-label">Total_horas</label>
 <div class="controls">
 <input class="form-control" type="text" placeholder="Readonly input here…" readonly>
 <?php if (!empty($total_horasError)): ?>
 <span class="help-inline"><?php echo $total_horasError;?></span>
 <?php endif;?>
 </div>
 </div>

<div class="form-actions">
 <button type="submit" class="btn btn-success">Novo Registro</button>
 <a class="btn" href="../PieChart.php">VOLTAR</a>
</div>
</form>
</div>
</div>
</div>
</div>
 </div> <!-- /container -->
 </body>
</html>

Discussão (0)

Entre ou cadastre-se para participar da discussão

Entrar Criar conta

Carregando comentários...