<?php
include 'config.php';
if(!isset($_SESSION['gebruikersnaam'])){
header("Location: login.php");
exit;
}
?>
<?php
if(isset($_POST['verzenden']))
{
$sopdrachtgever = mysql_real_escape_string($_POST['oid']);
$swerk_naam = mysql_real_escape_string($_POST['werk_naam']);
$swerk_adres = mysql_real_escape_string($_POST['werk_adres']);
$swerk_plaats = mysql_real_escape_string($_POST['werk_plaats']);
$swerk_uitvoerder = mysql_real_escape_string($_POST['werk_uitvoerder']);
$swerk_datum = mysql_real_escape_string($_POST['werk_datum']);
$sboorwerk_stuks = mysql_real_escape_string($_POST['boorwerk_stuks']);
$sboorwerk_cm = mysql_real_escape_string($_POST['boorwerk_cm']);
$sboorwerk_wat = mysql_real_escape_string($_POST['boorwerk_wat']);
$szaagwerk_diepte = mysql_real_escape_string($_POST['zaagwerk_diepte']);
$szaagwerk_cm = mysql_real_escape_string($_POST['zaagwerk_cm']);
$szaagwerk_wat = mysql_real_escape_string($_POST['zaagwerk_wat']);
$ssleufwerk_m = mysql_real_escape_string($_POST['sleufwerk_meters']);
$ssleufwerk_stuks = mysql_real_escape_string($_POST['sleufwerk_stuks']);
$soverige_kango = mysql_real_escape_string($_POST['kango']);
$soverige_compressor = mysql_real_escape_string($_POST['compressor']);
$soverige_regiewerk = mysql_real_escape_string($_POST['regiewerk']);
$soverige_waterzuigen = mysql_real_escape_string($_POST['waterzuigen']);
$soverige_wachten = mysql_real_escape_string($_POST['wachten']);
$soverige_opruimen = mysql_real_escape_string($_POST['opruimen']);
$soverige_diamantschuren = mysql_real_escape_string($_POST['diamantschuren']);
$soverige_terugloopuren = mysql_real_escape_string($_POST['terugloopuren']);
$smanuren_werknemer1 = mysql_real_escape_string($_POST['werknemer1']);
$smanuren_werknemer2 = mysql_real_escape_string($_POST['werknemer2']);
$smanuren_werknemer3 = mysql_real_escape_string($_POST['werknemer3']);
$smanuren_werknemer4 = mysql_real_escape_string($_POST['werknemer4']);
$smanuren_opmerking = mysql_real_escape_string($_POST['opmerking']);
mysql_query("INSERT INTO werkbonnen (oid, werk_naam, werk_adres, werk_plaats, werk_uitvoerder, werk_datum) VALUES ('".$sopdrachtgever."', '".$swerk_naam."', '".$swerk_adres."', '".$swerk_plaats."', '".$swerk_uitvoerder."', '".$swerk_datum."')") or die (mysql_error());
$swerkbon_id = mysql_insert_id();
mysql_query("INSERT INTO boorwerk (boorwerk_stuks, boorwerk_cm, boorwerk_wat, werkbon_id) VALUES ('".$sboorwerk_stuks."', '".$sboorwerk_cm."', '".$sboorwerk_wat."', '".$swerkbon_id."')") or die (mysql_error());
mysql_query("INSERT INTO zaagwerk (diepte, cm, wat, werkbon_id) VALUES ('".$szaagwerk_diepte."', '".$szaagwerk_cm."', '".$szaagwerk_wat."', '".$swerkbon_id."')") or die (mysql_error());
mysql_query("INSERT INTO sleufwerk (meters, stuks, werkbon_id) VALUES ('".$ssleufwerk_m."', '".$ssleufwerk_stuks."', '".$swerkbon_id."')") or die (mysql_error());
mysql_query("INSERT INTO overige_uren (uren_hakwerk_kango, uren_hakwerk_compressor, uren_regiewerk, uren_waterzuigen, uren_wachten, uren_opruimen, uren_diamantschuren, terugloopuren, werkbon_id) VALUES ('".$soverige_kango ."', '".$soverige_compressor."', '".$soverige_regiewerk."', '".$soverige_waterzuigen."', '".$soverige_wachten."', '".$soverige_opruimen."', '".$soverige_diamantschuren ."', '".$soverige_terugloopuren."', '".$swerkbon_id."')") or die (mysql_error());
mysql_query("INSERT INTO manuren (werknemer1, werknemer2, werknemer3, werknemer4, werkbon_id) VALUES ('".$smanuren_werknemer1."', '".$smanuren_werknemer2."', '".$smanuren_werknemer3."', '".$smanuren_werknemer4."','".$swerkbon_id."')") or die (mysql_error());
echo 'Je gegevens zijn succesvol in de database geplaatst <br>
<a href="bekijk_werkbon.php?id='.$swerkbon_id.'" class="btn btn-primary btn-flat"> Bekijk werkbon </a>
';
}
else
{
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>GR-Techniek | Werkbon indienen</title>
<meta content='width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no' name='viewport'>
<!-- bootstrap 3.0.2 -->
<link href="css/bootstrap.min.css" rel="stylesheet" type="text/css" />
<!-- font Awesome -->
<link href="css/font-awesome.min.css" rel="stylesheet" type="text/css" />
<!-- Ionicons -->
<link href="css/ionicons.min.css" rel="stylesheet" type="text/css" />
<!-- Morris chart -->
<link href="css/morris/morris.css" rel="stylesheet" type="text/css" />
<!-- jvectormap -->
<link href="css/jvectormap/jquery-jvectormap-1.2.2.css" rel="stylesheet" type="text/css" />
<!-- Date Picker -->
<link href="css/datepicker/datepicker3.css" rel="stylesheet" type="text/css" />
<!-- Daterange picker -->
<link href="css/daterangepicker/daterangepicker-bs3.css" rel="stylesheet" type="text/css" />
<!-- bootstrap wysihtml5 - text editor -->
<link href="css/bootstrap-wysihtml5/bootstrap3-wysihtml5.min.css" rel="stylesheet" type="text/css" />
<!-- Theme style -->
<link href="css/AdminLTE.css" rel="stylesheet" type="text/css" />
<link href="css/tabbladen.css" rel="stylesheet">
<link href="css/javascript.css" rel="stylesheet">
<!-- 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.3.0/respond.min.js"></script>
<![endif]-->
</head>
<body class="skin-blue">
<!-- header logo: style can be found in header.less -->
<header class="header">
<a href="index.php" class="logo">
<!-- Add the class icon to your logo image or logo icon to add the margining -->
GR-Techniek <!-- Hier kan evt <img> van logo -->
</a>
<!-- Header Navbar: style can be found in header.less -->
<nav class="navbar navbar-static-top" role="navigation">
<!-- Sidebar toggle button-->
<a href="#" class="navbar-btn sidebar-toggle" data-toggle="offcanvas" role="button">
<span class="sr-only">Toon/Verberg navigatie</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</a>
<div class="navbar-right">
<ul class="nav navbar-nav">
<li class="dropdown user user-menu">
<a href="#" class="dropdown-toggle" data-toggle="dropdown">
<i class="glyphicon glyphicon-user"></i>
<span><?php echo getFullName($userFetch); ?> <i class="caret"></i></span>
</a>
<ul class="dropdown-menu">
<!-- User image -->
<li class="user-header bg-light-blue">
<img src="img/avatar3.png" class="img-circle" alt="User Image" />
<p>
<?php echo getFullName($userFetch); ?>
</p>
</li>
<!-- Menu Footer-->
<li class="user-footer">
<div class="pull-left">
<a href="#" class="btn btn-default btn-flat">Profiel</a>
</div>
<div class="pull-right">
<a href="uitloggen.php" class="btn btn-default btn-flat">Uitloggen</a>
</div>
</li>
</ul>
</li>
</ul>
</div>
</nav>
</header>
<div class="wrapper row-offcanvas row-offcanvas-left">
<!-- Left side column. contains the logo and sidebar -->
<aside class="left-side sidebar-offcanvas">
<!-- sidebar: style can be found in sidebar.less -->
<section class="sidebar">
<!-- Sidebar user panel -->
<div class="user-panel">
<div class="pull-left image">
<img src="img/avatar3.png" class="img-circle" alt="User Image" />
</div>
<div class="pull-left info">
<p>Hallo, <?php echo $userFetch['voornaam']; ?></p>
</div>
</div>
<!-- sidebar menu: : style can be found in sidebar.less -->
<ul class="sidebar-menu">
<li>
<a href="index.php">
<i class="fa fa-dashboard"></i> <span>Dashboard</span>
</a>
</li>
<li class="treeview active">
<a href="#">
<i class="fa fa-list-alt"></i>
<span>Werkbonnen</span>
<i class="fa fa-angle-left pull-right"></i>
</a>
<ul class="treeview-menu">
<li><a href="werkbonnen.php"><i class="fa fa-list-alt"></i> Overzicht</a></li>
<li class="active"><a href="nieuwe_werkbon.php"><i class="fa fa-plus"></i> Nieuwe werkbon indienen</a></li>
</ul>
</li>
<?php
if($userFetch['admin'] == 1){
echo "<li class='treeview'>
<a href='#'>
<i class='fa fa-briefcase'></i>
<span>Administratie</span>
<i class='fa fa-angle-left pull-right'></i>
</a>
<ul class='treeview-menu'>
<li><a href='adm_werknemers.php'><i class='fa fa-envelope'></i> Werknemers</a></li>
<li><a href='adm_klanten.php'><i class='fa fa-building-o'></i> Klanten</a></li>
<li><a href='adm_facturen.php'><i class='fa fa-credit-card'></i> Facturen</a></li>
<li><a href='adm_offerte.php'><i class='fa fa-gear'></i> Offerte</a></li>
</ul>
</li>
";
echo "<li class='treeview'>
<a href='#'>
<i class='fa fa-laptop'></i>
<span>Onderhoud</span>
<i class='fa fa-angle-left pull-right'></i>
</a>
<ul class='treeview-menu'>
<li><a href='ond_inleners.php'><i class='fa fa-cloud'></i>Inleners</a></li>
<li><a href='ond_producten.php'><i class='fa fa-book'></i>Producten</a></li>
<li><a href='ond_prijslijsten.php'><i class='fa fa-euro'></i> Prijslijsten</a></li>
<li><a href='ond_info.php'><i class='fa fa-info-circle'></i> Bedrijfsinformatie</a></li>
</ul>
</li>
";
}?>
</ul>
</section>
<br>
<br>
<br>
<center><p>Gerealiseerd door: <a href="http://www.britdiensten.nl" target="_blank">BR-ITDiensten</a></p></center>
</aside>
<!-- Right side column. Contains the navbar and content of the page -->
<aside class="right-side">
<!-- Content Header (Page header) -->
<section class="content-header">
<h1>
Nieuwe werkbon
<small>Nieuwe werkbonnen indienen.</small>
</h1>
<ol class="breadcrumb">
<li><a href="index.php"><i class="fa fa-dashboard"></i> Home</a></li>
<li><a href="#"> Werkbonnen</a></li>
<li class="active">Nieuwe werkbon</li>
</ol>
</section>
<section class="content">
<div class="row">
<div class="col-md-12">
<div class="box box-primary">
<div class="box-header">
<br>
</div>
<div class="form-signin">
<ul class="nav nav-tabs" data-tabs="tabs">
<li class="active"><a data-toggle="tab" href="#administratie">Administratief</a></li>
<li><a data-toggle="tab" href="#boorwerk">Boorwerk</a></li>
<li><a data-toggle="tab" href="#zaagwerk">Zaagwerk</a></li>
<li><a data-toggle="tab" href="#sleufwerk">Sleufwerk</a></li>
<li><a data-toggle="tab" href="#overig">Overige uren</a></li>
<li><a data-toggle="tab" href="#manuren">Manuren registratie</a></li>
</ul>
<div class="tab-content">
<div class="tab-pane active" id="administratie">
<form action="#" method="POST">
<div class="box-body">
<div class="form-group">
<h2> Factuuradres </h2>
<br>
<label for="werkgever">Opdrachtgever:</label>
<select class="form-control" id="oid" name="oid">
<option>Maak een keuze...</option>
<?php
$klantQuery = $db->query("SELECT * FROM werkgevers");
while($werkgever = $klantQuery->fetch_assoc()){
echo "<option value=".$werkgever['id'].">".$werkgever['naam']."</option>";
} ?>
</select>
</div>
<h2> Werkadres </h2>
<br>
<div class="form-group">
<label for="klantaam">Naam:</label>
<input type="text" class="form-control" name="werk_naam" id="werk_naam" placeholder="BR-ITDiensten">
</div>
<div class="form-group">
<label for="adres">Adres:</label>
<input type="text" class="form-control" name="werk_adres" id="werk_adres" placeholder="Hoogmadepad 15">
</div>
<div class="form-group">
<label for="plaats">Plaats:</label>
<input type="text" class="form-control" name="werk_plaats" id="werk_plaats" placeholder="Arnhem">
</div>
<div class="form-group">
<label for="uitvoerder">Uitvoerder:</label>
<input type="text" class="form-control" name="werk_uitvoerder" id="werk_uitvoerder" placeholder="Jan Bakker">
</div>
<div class="form-group">
<label for="d.d">Datum:</label>
<input type="date" name="werk_datum" class="form-control datepicker" id="werk_datum">
</div>
</div><!-- /.box-body -->
</div>
<div class="tab-pane" id="boorwerk">
<div class="box-body">
<h2> Boorwerk </h2>
<tr>
<script>
function addElement() {
var ni = document.getElementById('Form-Input');
var numi = document.getElementById('Inhoud');
var num = (document.getElementById('Inhoud').value -1)+ 2;
numi.value = num;
var newdiv = document.createElement('div');
var divIdName = 'Form-Input'+num+'';
newdiv.setAttribute('id',divIdName);
newdiv.innerHTML = '<th><input type="INT" name="boorwerk_stuks" id="boorwerk_stuks" placeholder="10" class="form-control_java"></th><th> Stuks Ø </th><th><input type="INT" class="form-control_java" name="boorwerk_cm" id="boorwerk_cm" placeholder="120"></th><th> CM </th><th><select class="form-control_java" name="boorwerk_wat"><option value="betonvloer">Betonvloer</option><option value="betonwand">Betonwand</option><option value="metselwerk">Metselwerk</option><option value="betonsteen">Betonsteen</option><option value="asfalt">Asfalt</option></select></th>';
ni.appendChild(newdiv);
}
</script>
<input type="hidden" id="Inhoud" />
<p><a href="javascript:;" class="fa fa-plus-square-o" onclick="addElement();"></a></p>
<div id="Form-Input"> </div>
</tr>
</div>
</div>
<div class="tab-pane" id="zaagwerk">
<div class="box-body">
<h2> Zaagwerk </h2>
<table class="table">
<tr>
<th><input type="INT" class="form-control" name="zaagwerk_diepte" id="zaagwerk_diepte" placeholder="10" style="width: 40px"></th>
<th>m zaagwerk diep </th>
<th><input type="INT" class="form-control" name="zaagwerk_cm" id="zaagwerk_cm" placeholder="120" style="width: 50px"></th>
<th>CM</th>
<th>
<select class="form-control" name="zaagwerk_wat" id="zaagwerk_wat" >
<option value="betonvloer">Betonvloer</option>
<option value="betonwand">Betonwand</option>
<option value="metselwerk">Metselwerk</option>
<option value="betonsteen">Betonsteen</option>
<option value="asfalt">Asfalt</option>
</select>
</th>
</tr>
</table>
</div><!-- /.box-body -->
</div>
<div class="tab-pane" id="sleufwerk">
<div class="box-body">
<h2> Sleufwerk </h2>
<table class="table">
<tr>
<th>m sleuvenzaagwerk</th>
<th>
<select class="form-control" name="sleufwerk" id="sleufwerk">
<option value="metselwerk">Metselwerk</option>
<option value="betonwand">Beton</option>
<option value="gibo/ytong">gibo / ytong</option>
<option value="betonsteen">Betonsteen</option>
<option value="cementdekvloer">Cementdekvloer</option>
</select>
</th>
</tr>
<tr>
<th>stuks dozen geboord</th>
<th>
<select class="form-control" name="sleufwerk" id="sleufwerk">
<option value="metselwerk">Metselwerk</option>
<option value="betonwand">Beton</option>
<option value="gibo/ytong">gibo / ytong</option>
<option value="betonsteen">Betonsteen</option>
<option value="cementdekvloer">Cementdekvloer</option>
</select>
</th>
</tr>
</table>
<div class="box-footer">
<br>
</div>
</div><!-- /.box-body -->
</div>
<div class="tab-pane" id="overig">
<div class="box-body">
<h2> Overige uren </h2>
<table class="table">
<tr>
<th>Aantal</th>
<th>Omschrijving </th>
</tr>
<tr>
<th><input type="text" class="form-control" name="kango" id="kango" placeholder="10" style="width: 120px"></th>
<th>Uren hakwerk Kango </th>
</tr>
<tr>
<th><input type="text" class="form-control" name="compressor" id="compressor" placeholder="10" style="width: 120px"></th>
<th>Uren hakwerk compressor </th>
</tr>
<tr>
<th><input type="text" class="form-control" name="regiewerk" id="regiewerk" placeholder="10" style="width: 120px"></th>
<th>Uren regiewerk</th>
</tr>
<tr>
<th><input type="text" class="form-control" name="waterzuigen" id="waterzuigen" placeholder="10" style="width: 120px"></th>
<th>Uren waterzuigen </th>
</tr>
<tr>
<th><input type="text" class="form-control" name="wachten" id="wachten" placeholder="10" style="width: 120px"></th>
<th>Uren wachten</th>
</tr>
<tr>
<th><input type="text" class="form-control" name="opruimen" id="opruimen" placeholder="10" style="width: 120px"></th>
<th>Urenopruimen</th>
</tr>
<tr>
<th><input type="INT" class="form-control" name="diamantschuren" id="diamantschuren" placeholder="10" style="width: 120px"></th>
<th>Uren diamantschuren </th>
</tr>
<tr>
<th><input type="INT" class="form-control" name="terugloopuren" id="terugloopuren" placeholder="10" style="width: 120px"></th>
<th>Terugloopuren</th>
</tr>
</table>
</div><!-- /.box-body -->
</div>
<div class="tab-pane" id="manuren">
<div class="box-body">
<h2> Manuren Registratie </h2>
<table class="table">
<tr>
<th style="width:10px">#</th>
<th>Werknemer</th>
<th>BSN - Nummer</th>
</tr>
<tr>
<th>1.</th>
<th>
<select class="form-control" id="werknemer1" name="werknemer1" style="width:170px">
<option>Maak een keuze...</option>
<?php
$klantQuery = $db->query("SELECT * FROM gebruikers");
while($werknemer = $klantQuery->fetch_assoc()){
echo "<option value=".$werknemer['voornaam'].">".$werknemer['voornaam']."</option>";
} ?>
</select>
</th>
<th></th>
</tr>
<tr>
<th>2.</th>
<th>
<select class="form-control" id="werknemer2" name="werknemer2" style="width:170px">
<option>Maak een keuze...</option>
<?php
$klantQuery = $db->query("SELECT * FROM gebruikers");
while($werknemer = $klantQuery->fetch_assoc()){
echo "<option value=".$werknemer['id'].">".$werknemer['voornaam']."</option>";
} ?>
</select>
</th>
<th></th>
</tr>
<tr>
<th>3.</th>
<th>
<select class="form-control" id="werknemer3" name="werknemer3" style="width:170px">
<option>Maak een keuze...</option>
<?php
$klantQuery = $db->query("SELECT * FROM gebruikers");
while($werknemer = $klantQuery->fetch_assoc()){
echo "<option value=".$werknemer['id'].">".$werknemer['voornaam']."</option>";
} ?>
</select>
</th>
<th></th>
</tr>
<tr>
<th>4.</th>
<th>
<select class="form-control" id="werknemer4" name="werknemer4" style="width:170px">
<option>Maak een keuze...</option>
<?php
$klantQuery = $db->query("SELECT * FROM gebruikers");
while($werknemer = $klantQuery->fetch_assoc()){
echo "<option value=".$werknemer['id'].">".$werknemer['voornaam']."</option>";
} ?>
</select>
</th>
<th></th>
</tr>
</table>
<h2> Uren </h2>
Totale gewerkte uren van <input type="text" id="naam" placeholder="07" style="width: 40px"> : <input type="text" id="naam" placeholder="00" style="width: 40px"> t/m <input type="text" id="naam" placeholder="16" style="width: 40px"> : <input type="text" id="naam" placeholder="00" style="width: 40px"> uur
<div class="box-footer">
</div>
</div><!-- /.box-body -->
<input type="submit" name="verzenden" class="btn btn-primary btn-flat" value="verzenden">
</form>
</div>
</div>
</div> <!-- /.box -->
</div>
</div>
</div>
</section><!-- /.content -->
</aside><!-- /.right-side -->
</div><!-- ./wrapper -->
<!-- jQuery 2.0.2 -->
<script src="http://ajax.googleapis.com/ajax/libs/jquery/2.0.2/jquery.min.js"></script>
<!-- Bootstrap -->
<script src="../../js/bootstrap.min.js" type="text/javascript"></script>
<!-- DATA TABES SCRIPT -->
<script src="../../js/plugins/datatables/jquery.dataTables.js" type="text/javascript"></script>
<script src="../../js/plugins/datatables/dataTables.bootstrap.js" type="text/javascript"></script>
<!-- AdminLTE App -->
<script src="../../js/AdminLTE/app.js" type="text/javascript"></script>
<!-- page script -->
<script type="text/javascript">
$(function() {
$("#example1").dataTable();
$('#example2').dataTable({
"bPaginate": true,
"bLengthChange": false,
"bFilter": false,
"bSort": true,
"bInfo": true,
"bAutoWidth": false
});
});
</script>
</body>
</html>
<?
}
?>