Bekijk de onderstaande video om te zien hoe je onze site als een web app op je startscherm installeert.
Opmerking: Deze functie is mogelijk niet beschikbaar in sommige browsers.
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());
for ($i = 0, $max = count($_POST['boorwerk_stuks']); $i < $max; $i++) {
mysql_query("
INSERT INTO boorwerk (boorwerk_stuks, boorwerk_cm, boorwerk_wat, werkbon_id) VALUES
(
'". mysql_real_escape_string($_POST['boorwerk_stuks'][$i]) ."',
'". mysql_real_escape_string($_POST['boorwerk_cm'][$i]) ."',
'". mysql_real_escape_string($_POST['boorwerk_wat'][$i]) ."',
'". $swerkbon_id ."'
)") or die (mysql_error());
}
<?php
include 'config.php';
if(!isset($_SESSION['gebruikersnaam'])){
header("Location: login.php");
exit;
}
?>
<?php
$werkbon = htmlspecialchars($_GET[id]);
$werkadres = mysql_query("SELECT * FROM werkbonnen WHERE id=".$werkbon." ") or die (mysql_error());
$boorwerk = mysql_query("SELECT * FROM boorwerk WHERE werkbon_id=".$werkbon." ") or die (mysql_error());
$zaagwerk = mysql_query("SELECT * FROM zaagwerk WHERE werkbon_id=".$werkbon." ") or die (mysql_error());
$sleufwerk = mysql_query("SELECT * FROM sleufwerk WHERE werkbon_id=".$werkbon." ") or die (mysql_error());
$manuren = mysql_query("SELECT * FROM manuren WHERE werkbon_id=".$werkbon." ") or die (mysql_error());
$uren = mysql_query("SELECT * FROM overige_uren WHERE werkbon_id=".$werkbon." ") or die (mysql_error());
$opmerkingen = mysql_query("SELECT * FROM opmerkingen WHERE werkbon_id=".$werkbon." ") or die (mysql_error());
$werknemer = mysql_query("SELECT * FROM gebruikers ") or die (mysql_error());
?>
<!DOCTYPE html>
<head>
<meta charset="UTF-8">
<title>GR-Techniek | Werkbon bekijken</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" />
<!-- 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 class="active"><a href="werkbonnen.php"><i class="fa fa-list-alt"></i> Overzicht</a></li>
<li><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>
Werkbon
<small>Werkbon Bekijken</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">Werkbon bekijken</li>
</ol>
</section>
<!-- Main content -->
<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 role="form">
<div class="box-body">
<div class="form-group">
<h2> Factuuradres </h2>
<br>
<?php
while($rij = mysql_fetch_assoc($werkadres))
{
echo"<label for=werkgever>Opdrachtgever:</label>
<BR><td>".getCompanyById($db, $rij['oid'])."</td>
</div>
<h2> Werkadres </h2>
<br>
<div class=form-group>
<label for=klantaam>Naam:</label>
<BR>".$rij['werk_naam']."
</div>
<div class=form-group>
<label for=adres>Adres:</label>
<BR>
".$rij['werk_adres']."
</div>
<div class=form-group>
<label for=plaats>Plaats:</label>
<BR>".$rij['werk_plaats']."
</div>
<div class=form-group>
<label for=uitvoerder>Uitvoerder:</label>
<BR>".$rij['werk_uitvoerder']."
</div>
<div class=form-group>
<label for=d.d>Datum:</label>
<BR> ".$rij['werk_datum']."
</div>
</div><!-- /.box-body -->
</form>";
} ?>
</div>
<div class="tab-pane" id="boorwerk">
<form role="form">
<div class="box-body">
<h2> Boorwerk </h2>
<table class="table">
<?php
while($rij_boorwerk = mysql_fetch_assoc($boorwerk))
{
echo "<tr>
<th>".$rij_boorwerk['boorwerk_stuks']."</th>
<th>Stuks Ø</th>
<th>".$rij_boorwerk['boorwerk_cm']."</th>
<th>CM</th>
<th>".$rij_boorwerk['boorwerk_wat']."</th>
</tr>";
}
?>
</table>
</div><!-- /.box-body -->
</form>
</div>
<div class="tab-pane" id="zaagwerk">
<form role="form">
<div class="box-body">
<h2> Zaagwerk </h2>
<table class="table">
<?php
while($rij_zaagwerk = mysql_fetch_assoc($zaagwerk))
{
echo "<tr>
<th>".$rij_zaagwerk['diepte']."</th>
<th>M diepte;</th>
<th>".$rij_zaagwerk['cm']."</th>
<th>CM</th> ".$rij_zaagwerk['wat']." </th>
</tr>";
}
?>
</table>
</div><!-- /.box-body -->
</form>
</div>
<div class="tab-pane" id="sleufwerk">
<form role="form">
<div class="box-body">
<h2> Sleufwerk </h2>
<table class="table">
<?php
while($rij_sleufwerk = mysql_fetch_assoc($sleufwerk))
{
echo "<tr>
<th>".$rij_sleufwerk['meters']."</th>
<th>m sleuvenzaagwerk metselwerk </th>
</tr>
<tr>
<th>".$rij_sleufwerk['stuks']."</th>
<th>stuks dozen geboord metselwerk</th>
</tr>";
}
?>
</table>
</div><!-- /.box-body -->
</form>
</div>
<div class="tab-pane" id="overig">
<form role="form">
<div class="box-body">
<h2> Overige uren </h2>
<table class="table">
<tr>
<th>Aantal</th>
<th>Omschrijving </th>
</tr>
<?php
while($rij_uren = mysql_fetch_assoc($uren))
{
echo " <tr> ";
echo " <th>".$rij_uren['uren_hakwerk_kango']."</th>";
echo " <th>Uren hakwerk Kango </th>";
echo " </tr>";
echo " <tr>";
echo " <th>".$rij_uren['uren_hakwerk_compressor']."</th>";
echo " <th>Uren hakwerk compressor </th>";
echo " </tr>";
echo " <tr>";
echo " <th>".$rij_uren['uren_regiewerk']."</th>";
echo " <th>Uren regiewerk</th>";
echo " </tr>";
echo " <tr>";
echo " <th>".$rij_uren['uren_waterzuigen']."</th>";
echo " <th>Uren waterzuigen </th>";
echo " </tr>";
echo "<tr>";
echo " <th>".$rij_uren['uren_wachten']."</th>";
echo " <th>Uren wachten</th>";
echo " </tr>";
echo " <tr>";
echo " <th>".$rij_uren['uren_opruimen']."</th>";
echo " <th>Urenopruimen</th>";
echo " </tr>";
echo " <tr>";
echo " <th>".$rij_uren['uren_diamantschuren']."</th>";
echo " <th>Uren diamantschuren </th>";
echo " </tr> ";
echo " <tr>";
echo " <th>".$rij_uren['terugloopuren']."</th>";
echo " <th>Terugloopuren</th>";
echo " </tr> ";
}
?>
</table>
</div><!-- /.box-body -->
</form>
</div>
<div class="tab-pane" id="manuren">
<form role="form">
<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>
<?php
while($rij_manuren = mysql_fetch_assoc($manuren))
{
echo "".$rij_manuren['werknemer1']."";
}
?>
</th>
<th>BSN</th>
</tr>
<tr>
<th>2.</th>
<th>
<?php
while($rij_manuren = mysql_fetch_assoc($manuren))
{
echo "".$rij_manuren['werknemer2']."";
}
?>
</th>
<th>BSN</th>
</tr>
<tr>
<th>3.</th>
<th>
<?php
while($rij_manuren = mysql_fetch_assoc($manuren))
{
echo "".$rij_manuren['werknemer3']."";
}
?>
</th>
<th>BSN</th>
</tr>
<tr>
<th>4.</th>
<th>
<?php
while($rij_manuren = mysql_fetch_assoc($manuren))
{
echo "".$rij_manuren['werknemer4']."";
}
?>
</th>
<th>BSN</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><!-- /.box-body -->
</form>
// regel 14
$manuren = mysql_query("SELECT * FROM manuren WHERE werkbon_id=".$werkbon." ") or die (mysql_error());
$manuren = mysql_fetch_assoc(mysql_query("SELECT * FROM manuren WHERE werkbon_id=".$werkbon." ")) or die (mysql_error());
<tr>
<th>1.</th>
<th><?= $manuren['werknemer1'] ?></th>
<th>BSN</th>
</tr>
<tr>
<th>2.</th>
<th><?= $manuren['werknemer2'] ?></th>
<th>BSN</th>
</tr>
<?php for ($i = 1; $i <= 4; $i++) { ?>
<tr>
<th><?= $i ?>.</th>
<th><?= $manuren['werknemer'. $i] ?></th>
<th>BSN</th>
</tr>
<?php } ?>
Lege string doorgegeven aan getElementById(). jquery.min.js:4
TypeError: document.getElementById(...) is null zaagwerk.js:6
var num = (document.getElementById('zaagwerk_diepte').value -1)+ 2;
<input type="hidden" name="zaagwerk_diepte" id="zaagwerk_diepte" />
Overigens krijg ik nu de melding in de console:
Dit is nu opgelost, het bovenstaande nog steeds niet... Hoe komt dat?ReferenceError: addElement is not defined
We gebruiken essentiële cookies om deze site te laten werken, en optionele cookies om de ervaring te verbeteren.