Inserir datas no "insert" do CRUD

lui hurk · Março 29, 2015

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" rel="stylesheet">

    <!-- MetisMenu CSS -->
    <link href="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" rel="stylesheet">

    <!-- Custom CSS -->
    <link href="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" rel="stylesheet">

    <!-- Custom Fonts -->
    <link href="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" rel="stylesheet" type="text/css">

   <link href=" 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">

    <link href="http://netdna.bootstrapcdn.com/twitter-bootstrap/2.2.2/css/bootstrap-combined.min.css" rel="stylesheet">
<link rel="stylesheet" type="text/css" media="screen"
     href="http://tarruda.github.com/bootstrap-datetimepicker/assets/css/bootstrap-datetimepicker.min.css">


    <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
    <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
    <!--[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"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"></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"></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"></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>

<head>

</head>

<body>

<h3>Novo Registro</h3>

</div>

<?php if (!empty($siteError)): ?>

<?php endif; ?>

</div>

<label class="control-label">Data_inicio</label>

<?php if (!empty($inicioError)): ?>

<?php endif; ?>

</div>

<?php if (!empty($fimError)): ?>

<?php endif; ?>

</div>

<label class="control-label">Equipamento</label>

<?php if (!empty($equipamentoError)): ?>

<?php endif;?>

</div>

<label class="control-label">Total</label>

<?php if (!empty($totalError)): ?>

<?php endif;?>

</div>

<label class="control-label">Total_horas</label>

<?php if (!empty($total_horasError)): ?>

<?php endif;?>

</div>

<button type="submit" class="btn btn-success">Novo Registro</button>

<a class="btn" href="../PieChart.php">VOLTAR</a>

</div>

</form>

</div>

</div>

</body>

</html>

<!

Entrar

Arquivado

Inserir datas no "insert" do CRUD

Recommended Posts

lui hurk 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

select com varias categorias por horario

comando like (Mysql) no php

Alguém com pratica em subir site em codeigniter4 na Hostinger? Não consigo acessar o bd. Erro de Autenticação. O mesmo site funciona normal em outro servidor web.

Este projeto é apoiado pelas empresas

Fóruns

Tempo Real

Informação importante