Gættelege er ellers så sjove, kom nuu :-)
Men her er eksempelvis soegning.php
<?
include("inc_db_connect.php");
if (!isset($_GET['year'])) $_GET['year'] = date("Y")-3;
if (!isset($_GET['month'])) $_GET['month'] = 1;
$_GET['day'] = 1;
if (!isset($_GET['year2'])) $_GET['year2'] = date("Y");
if (!isset($_GET['month2'])) $_GET['month2'] = date("n");
$_GET['day2'] = 1;
if(!$_GET['man_start'] || !$_GET['man_slut2']) {
$_GET['man_start'] = mktime(1, 1, 1, 1, 1, date("Y",time())-3);
$_GET['man_slut2'] = mktime(1, 1, 1, date("m",time()), date("t",time()) , date("Y",time()));
}
if($_GET['soeg']) {
$hentsoegkunder = mysql_query("SELECT
tk.id,
tk.firma,
tk.fornavn,
tk.efternavn,
tk.adresse,
tk.adresse2,
tk.city,
tk.zipcode,
tk.telefon,
tk.mobilnummer,
tk.land,
tk.email,
tk.eannummer
FROM
tblkunder AS tk
WHERE
tk.firma LIKE '%$_GET[soeg]%'
OR tk.fornavn LIKE '%$_GET[soeg]%'
OR tk.efternavn LIKE '%$_GET[soeg]%'
OR tk.telefon LIKE '%$_GET[soeg]%'
OR tk.mobilnummer LIKE '%$_GET[soeg]%'
OR tk.adresse LIKE '%$_GET[soeg]%'
OR tk.zipcode LIKE '%$_GET[soeg]%'
OR tk.eannummer LIKE '%$_GET[soeg]%'
OR tk.email LIKE '%$_GET[soeg]%'
OR tk.land LIKE '%$_GET[soeg]%'
") or die(mysql_error());
}
if($_GET['kundeid']) {
$valgtekunde = mysql_fetch_array(mysql_query("SELECT IF(tk.firma != '',tk.firma,CONCAT(tk.fornavn,' ',tk.efternavn)) AS navn FROM tblkunder AS tk WHERE id = '$_GET[kundeid]' LIMIT 1")) or die(mysql_error());
}
if($_GET['soegeord'] || $_GET['kundeid']) {
$soegopgaver = mysql_query("
SELECT
UNIX_TIMESTAMP(tog.tidligst) AS tidligst,
UNIX_TIMESTAMP(tog.start) AS start,
UNIX_TIMESTAMP(tog.forfald) AS forfald,
UNIX_TIMESTAMP(tog.oprettet) AS oprettet,
UNIX_TIMESTAMP(tog.lukket) AS lukket,
UNIX_TIMESTAMP(tp.lukket) AS projektlukket,
tb.navn AS opretter,
tog.etiket,
tog.prioritet,
tog.beskrivelse,
tog.obs,
tog.emne,
tpr.relid,
tpr.projektid,
tp.projektnavn,
CONCAT(if(tk.firma != '',CONCAT(tk.firma,'<br>'),''),' ',tk.fornavn,' ',tk.efternavn) AS kunden
FROM
tblopgaver AS tog,
tblprojektrel AS tpr,
tblprojekt AS tp,
tblkunder AS tk
LEFT JOIN
tblbruger AS tb ON
tb.id = tog.opretterid
WHERE
tpr.type = 2
AND tpr.projektid = tp.id
AND tpr.relid = tog.id
".((!$_GET[kundeid]) ? "AND tog.emne LIKE '%$_GET[soegeord]%'" : "")."
AND tk.id = tp.kundeid
AND ((
(UNIX_TIMESTAMP(tog.start) BETWEEN ".$_GET['man_start']." AND ".$_GET['man_slut2'].")
OR
(UNIX_TIMESTAMP(tog.forfald) BETWEEN ".$_GET['man_start']." AND ".$_GET['man_slut2'].")
) OR UNIX_TIMESTAMP(tog.oprettet) BETWEEN ".$_GET['man_start']." AND ".$_GET['man_slut2'].")
".(($_GET[kundeid]) ? "AND (tp.kundeid = '$_GET[kundeid]')" : "")."
ORDER BY
tog.start,
tog.forfald
") or die(mysql_error());
//echo(mysql_num_rows($soegopgaver));
$soegordrer = mysql_query("
SELECT
UNIX_TIMESTAMP(tol.oprettet) AS oprettet,
UNIX_TIMESTAMP(tol.lukket) AS lukket,
UNIX_TIMESTAMP(tp.lukket) AS projektlukket,
tb.navn AS opretternavn,
tpr.relid,
tpr.projektid,
tp.projektnavn,
tol.rekvisition,
CONCAT(if(tk.firma != '',CONCAT(tk.firma,'<br>'),''),' ',tk.fornavn,' ',tk.efternavn) AS kunden,
tok.kommentar AS fakturatekst,
tp.projektnavn,
tiok.kommentar
FROM
tblorders AS tol,
tblprojektrel AS tpr,
tblprojekt AS tp,
tblkunder AS tk
LEFT JOIN
tblbruger AS tb ON
tb.id = tol.opretterid
LEFT JOIN
tblordrekommentar AS tok ON
tok.ordreid = tol.id
LEFT JOIN
tblinternordrekommentar AS tiok ON
tiok.ordreid = tol.id
WHERE
tpr.type = 1
AND tpr.projektid = tp.id
AND tpr.relid = tol.id
".((!$_GET[kundeid]) ? "AND tol.rekvisition LIKE '%$_GET[soegeord]%'" : "")."
AND tk.id = tp.kundeid
AND (UNIX_TIMESTAMP(tol.oprettet) BETWEEN ".$_GET['man_start']." AND ".$_GET['man_slut2'].")
AND tol.id NOT IN (SELECT ordreid FROM tblfaktura)
".(($_GET[kundeid]) ? "AND (tp.kundeid = '$_GET[kundeid]')" : "")."
ORDER BY
tol.oprettet
") or die(mysql_error());
$soegfakturaer= mysql_query("
SELECT
UNIX_TIMESTAMP(tol.oprettet) AS oprettet,
UNIX_TIMESTAMP(tol.lukket) AS lukket,
UNIX_TIMESTAMP(tp.lukket) AS projektlukket,
UNIX_TIMESTAMP(tf.dato) AS fakturadato,
tb.navn AS opretternavn,
tpr.relid,
tpr.projektid,
tp.projektnavn,
tol.rekvisition,
CONCAT(if(tf.firma != '',CONCAT(tf.firma,'<br>'),''),' ',tf.fornavn,' ',tf.efternavn) AS kunden,
tok.kommentar AS fakturatekst,
tp.projektnavn,
tiok.kommentar,
tf.id AS fakturanummer
FROM
tblorders AS tol,
tblprojektrel AS tpr,
tblprojekt AS tp,
tblkunder AS tk,
tblfaktura AS tf
LEFT JOIN
tblbruger AS tb ON
tb.id = tol.opretterid
LEFT JOIN
tblordrekommentar AS tok ON
tok.ordreid = tol.id
LEFT JOIN
tblinternordrekommentar AS tiok ON
tiok.ordreid = tol.id
WHERE
tpr.type = 1
AND tpr.projektid = tp.id
AND tpr.relid = tol.id
".((!$_GET[kundeid]) ? "AND tol.rekvisition LIKE '%$_GET[soegeord]%'" : "")."
AND tk.id = tp.kundeid
AND tol.id = tf.ordreid
AND (UNIX_TIMESTAMP(tol.oprettet) BETWEEN ".$_GET['man_start']." AND ".$_GET['man_slut2'].")
AND tf.ordreid = tol.id
".(($_GET[kundeid]) ? "AND (tp.kundeid = '$_GET[kundeid]')" : "")."
ORDER BY
tol.oprettet
") or die(mysql_error());
$soegtilbud = mysql_query("SELECT
UNIX_TIMESTAMP(ttb.oprettet) AS ordreoprettet,
UNIX_TIMESTAMP(tp.lukket) AS projektlukket,
UNIX_TIMESTAMP(ttb.lukket) AS lukket,
tpr.id,
tpr.relid,
tpr.projektid,
tp.projektnavn,
ttb.type,
ttb.sumtimeloen,
tb.navn AS opretternavn,
ttb.emne,
ttb.beskrivelse,
ttb.betingelser
FROM
tbltilbud AS ttb,
tblprojektrel AS tpr,
tblprojekt AS tp,
tblkunder AS tk
LEFT JOIN
tblbruger AS tb ON
tb.id = ttb.opretterid
WHERE
tpr.projektid = tp.id
AND tpr.type = 3
AND ttb.id = tpr.relid
AND tk.id = tp.kundeid
".((!$_GET[kundeid]) ? "AND ttb.emne LIKE '%$_GET[soegeord]%'" : "")."
AND (UNIX_TIMESTAMP(ttb.oprettet) BETWEEN ".$_GET['man_start']." AND ".$_GET['man_slut2'].")
".(($_GET[kundeid]) ? "AND (tp.kundeid = '$_GET[kundeid]')" : "")."
ORDER BY
tpr.relid
") or die(mysql_error());
}
?>
<html>
<head>
<title><? echo$var_setting['titel']; ?></title>
<LINK rel="stylesheet" href="stylesheet.php" >
<meta http-equiv="content-type" content="text/html;charset=iso-8859-1">
</head>
<body background="#FFFFFF" marginheight="0" marginwidth="0" topmargin="0" leftmargin="0" rightmargin="0" onload="formsoegning.soegeord.select();" >
<table border="0" cellspacing="0" cellpadding="0" width="100%">
<tr>
<td class="mainwhiteoverskrift" align="left" bgcolor="<? echo$var_setting['barfarve']; ?>" ><a href="index.php" ><img src="grafik/<? echo$var_setting['barlogo']; ?>" border="0" ></a></td>
<td class="main" width="150" bgcolor="<? echo$var_setting['barfarve']; ?>" >Uge <? echo(date("W",time())); ?><br><? echo$ugen[(date("w",time()))]; ?> <? echo(date("j. M.",time())); ?><br><? echo(date("\k\l. H:i",time())); ?></td>
</tr>
<tr>
<td class="mainsmall" align="left" >
<table border="0" cellspacing="0" cellpadding="0" >
<tr>
<td class="mainsmallblack" width="60" bgcolor="<? echo$var_setting['barknapfarveinaktiv']; ?>" background="grafik/corner.gif" > <a href="kalender.php" >Kalender</a></td>
<td class="mainsmallblack" width="60" bgcolor="<? echo$var_setting['barknapfarveinaktiv']; ?>" background="grafik/corner.gif" > <a href="kunder.php" >Kunder</a></td>
<td class="mainsmallblack" width="60" bgcolor="<? echo$var_setting['barknapfarveinaktiv']; ?>" background="grafik/corner.gif" > <a href="timeseddel.php" >T-seddel</a></td>
<td class="mainsmallblack" width="60" bgcolor="<? echo$var_setting['barknapfarveinaktiv']; ?>" background="grafik/corner.gif" > <a href="oetimer.php" >Ø-timer</a></td>
<td class="mainsmallblack" width="60" bgcolor="<? echo$var_setting['barknapfarveaktiv']; ?>" background="grafik/corner.gif" > <a href="soegning.php" >Søgning</a></td>
<? if($_SESSION['sess_level'] <2) { ?><td class="mainsmallblack" width="60" bgcolor="<? echo$var_setting['barknapfarveinaktiv']; ?>" background="grafik/corner.gif" > <a href="posteringsoversigt.php" >Faktura</a></td>
<td class="mainsmallblack" width="60" bgcolor="<? echo$var_setting['barknapfarveinaktiv']; ?>" background="grafik/corner.gif" > <a href="visordrer.php" >Ordrer</a></td>
<td class="mainsmallblack" width="60" bgcolor="<? echo$var_setting['barknapfarveinaktiv']; ?>" background="grafik/corner.gif" > <a href="filliste.php" >Filer</a></td>
<td class="mainsmallblack" width="60" bgcolor="<? echo$var_setting['barknapfarveinaktiv']; ?>" background="grafik/corner.gif" > <a href="importexport.php" >I/E</a></td>
<td class="mainsmallblack" width="60" bgcolor="<? echo$var_setting['barknapfarveinaktiv']; ?>" background="grafik/corner.gif" > <a href="bruger.php" >Bruger</a></td>
<? } ?>
</tr>
</table>
</td>
<td class="mainsmall" align="right"><? echo$_SESSION['sess_navn']; ?> </td>
</tr>
</table>
<p>
<table border="0" cellspacing="0" cellpadding="0" align="center" >
<tr>
<td class="main3" width="580" style="border-bottom: 2px SOLID #CCCCCC;border-left: 2px SOLID #CCCCCC;" colspan="2" > <b>Søgning i projekter</b></td>
<td class="main" width="200" style="border-bottom: 2px SOLID #CCCCCC;border-left: 2px SOLID #CCCCCC;border-right: 2px SOLID #CCCCCC;" > Kunderesumé</td>
</tr>
<tr>
<td class="main" valign="top" colspan="2" align="center" valign="top" >
<form action="soegning.php" method="get" name="formsoegning" >
<input type="hidden" name="man_slut2" value="<? echo$_GET['man_slut2']; ?>" >
<input type="hidden" name="man_start" value="<? echo$_GET['man_start']; ?>" >
<input type="hidden" name="day" value="<? echo$_GET['day']; ?>" >
<input type="hidden" name="month" value="<? echo$_GET['month']; ?>" >
<input type="hidden" name="year" value="<? echo$_GET['year']; ?>" >
<input type="hidden" name="day2" value="<? echo$_GET['day2']; ?>" >
<input type="hidden" name="month2" value="<? echo$_GET['month2']; ?>" >
<input type="hidden" name="year2" value="<? echo$_GET['year2']; ?>" >
<table cellspacing="0" cellpadding="0" border="0" >
<tr>
<td class="mainsmall" width="270" valign="top" >Søgeord:<br><input type="text" name="soegeord" size="20" value="<? if($_GET['soegeord'] && !$_GET['kundeid']) echo$_GET['soegeord']; ?>" <? if($_GET['kundeid']) echo"disabled"; ?> class="inputbox" > <input type="submit" name="submitsoeg" value=" Søg " class="submit" ></td>
<td class="mainsmall" width="150" valign="top" >Fra:<br><? include("kalenderslutsoegning.php"); ?></td>
<td class="mainsmall" width="150" valign="top" >Til:<br><? include("kalenderstartsoegning.php"); ?></td>
</tr>
</table>
</form>
</td>
<td class="main" valign="top" >
<form action="soegning.php" method="GET" name="formfindkunde">
<input type="hidden" name="man_slut2" value="<? echo$_GET['man_slut2']; ?>" >
<input type="hidden" name="man_start" value="<? echo$_GET['man_start']; ?>" >
<input type="hidden" name="day" value="<? echo$_GET['day']; ?>" >
<input type="hidden" name="month" value="<? echo$_GET['month']; ?>" >
<input type="hidden" name="year" value="<? echo$_GET['year']; ?>" >
<input type="hidden" name="day2" value="<? echo$_GET['day2']; ?>" >
<input type="hidden" name="month2" value="<? echo$_GET['month2']; ?>" >
<input type="hidden" name="year2" value="<? echo$_GET['year2']; ?>" >
<input type="hidden" name="soegeord" value="<? echo$_GET['soegeord']; ?>" >
<table cellspacing="0" cellpadding="0" border="0" >
<tr>
<td class="mainsmall" width="200" > Søg kunde</td>
</tr>
<tr>
<td class="main" align="left"><input type="text" name="soeg" class="inputbox" size="22" value="<? echo$_GET['soeg']; ?>" > <input type="submit" class="submit" value=" Søg " ></td>
</tr>
<? if($_GET['kundeid']) { ?>
<tr>
<td class="mainsmall" align="left">Valgte kunde:</td>
</tr>
<tr>
<td class="main" align="left"><? echo(ucwords($valgtekunde['navn'])); ?></td>
</tr>
<tr>
<td class="mainsmall" align="right"><a href="soegning.php" >[annuller kunderesumé]</a></td>
</tr>
<? } ?>
</table>
</form>
<br>
<table border="0" cellspacing="0" cellpadding="0" >
<? if($_GET['soeg']) {
if(mysql_num_rows($hentsoegkunder)) { ?>
<tr>
<td class="main" width="200" style="border-bottom: 1px SOLID #CCCCCC" >Vælg kunde fra søgning</td>
</tr>
<? while($listkunder = mysql_fetch_array($hentsoegkunder)) { ?>
<tr>
<td class="main" width="200"><br>
<form action="soegning.php" method="get" >
<input type="hidden" name="kundeid" value="<? echo$listkunder['id']; ?>" >
<input type="hidden" name="valgtkunde" value="<? echo$listkunder['firma']; ?><? if($listkunder['firma']) ?><br><? ; echo$listkunder['fornavn']; ?> <? echo$listkunder['efternavn']; ?>" >
<input type="hidden" name="man_slut2" value="<? echo$_GET['man_slut2']; ?>" >
<input type="hidden" name="man_start" value="<? echo$_GET['man_start']; ?>" >
<input type="hidden" name="day" value="<? echo$_GET['day']; ?>" >
<input type="hidden" name="month" value="<? echo$_GET['month']; ?>" >
<input type="hidden" name="year" value="<? echo$_GET['year']; ?>" >
<input type="hidden" name="day2" value="<? echo$_GET['day2']; ?>" >
<input type="hidden" name="month2" value="<? echo$_GET['month2']; ?>" >
<input type="hidden" name="year2" value="<? echo$_GET['year2']; ?>" >
<input type="hidden" name="soegeord" value="<? echo$_GET['soegeord']; ?>" >
<table cellspacing="0" cellpadding="0" border="0" >
<tr>
<td class="main" width="80" >Firma:</td>
<td class="main" width="120"><? echo(ucfirst($listkunder['firma'])); ?> </td>
</tr>
<? if($listkunder['eannummer']) { ?>
<tr>
<td class="main" width="80" >Eannummer:</td>
<td class="main" width="120" ><? echo(ucfirst($listkunder['eannummer'])); ?> </td>
</tr>
<? } ?>
<tr>
<td class="main" >Navn:</td>
<td class="main" width="120" ><? echo(ucfirst($listkunder['fornavn']." ".$listkunder['efternavn'])); ?> </td>
</tr>
<tr>
<td class="main" >Adresse:</td>
<td class="main" ><? echo(ucfirst($listkunder['adresse'])); ?> </td>
</tr>
<? if($listkunder['adressse2']) { ?>
<tr>
<td class="main" >Adresse2:</td>
<td class="main" ><? echo(ucfirst($listkunder['adresse2'])); ?> </td>
</tr>
<? } if($listkunder['zipcode'] || $listkunder['city']) { ?>
<tr>
<td class="main" >Postnr./by:</td>
<td class="main" ><? echo(ucfirst($listkunder['zipcode']." ".$listkunder['city'])); ?> </td>
</tr>
<? } if($listkunder['land']) { ?>
<tr>
<td class="main" >Land:</td>
<td class="main" ><? echo(ucfirst($listkunder['land'])); ?> </td>
</tr>
<? } if($listkunder['telefon']) { ?>
<tr>
<td class="main" >Telefon:</td>
<td class="main" ><? echo(ucfirst($listkunder['telefon'])); ?> </td>
</tr>
<? } if($listkunder['mobilnummer']) { ?>
<tr>
<td class="main" >Mobil:</td>
<td class="main" ><? echo(ucfirst($listkunder['mobilnummer'])); ?> </td>
</tr>
<? } if($listkunder['email']) { ?>
<tr>
<td class="main" >E-mail:</td>
<td class="main" ><? echo(($listkunder['email'])); ?> </td>
</tr>
<? } ?>
</table>
</td>
</tr>
<tr>
<td class="main" align="right"><input type="submit" value=" Vælg " class="submit" ></form> </td>
</tr>
<tr>
<td class="main" style="border-bottom: 1px DOTTED #CCCCCC" > </td>
</tr>
<? } } else { ?>
<tr>
<td class="main" >Der er ingen resultater fra søgning</td>
</tr>
<? } } ?>
</table>
</td>
</tr>
<tr>
<td class="mainsmall" colspan="6" >
<br><p class="mainsmall" >
Der søges i opgavens og tilbuddets emne, samt ordrens/fakturaens reference.<br>
Der søges indenfor opgavens startdato og forfaldsdato.<br>
Der søges i ordrens, fakturaens og tilbuddets dato for oprettelse.<br>
</p>
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<br><br>
<table border="0" cellspacing="0" cellpadding="0" align="center" >
<tr>
<td class="main" colspan="4" > <h4>Opgaver (<? echo($soegopgaver) ? mysql_num_rows($soegopgaver) : 0; ?>)</h4></td>
</tr>
<tr>
<td class="main" width="200" align="left" valign="top" style="border-bottom: 2px SOLID #CCCCCC;border-left: 2px SOLID #CCCCCC;" > Opgave</td>
<td class="main" width="180" align="left" valign="top" style="border-bottom: 2px SOLID #CCCCCC;border-left: 2px SOLID #CCCCCC;"> Kunde</td>
<td class="main" width="200" align="left" valign="top" style="border-bottom: 2px SOLID #CCCCCC;border-left: 2px SOLID #CCCCCC;"> Tider</td>
<td class="main" width="200" align="left" valign="top" style="border-bottom: 2px SOLID #CCCCCC;border-left: 2px SOLID #CCCCCC;border-right: 2px SOLID #CCCCCC"> Diverse</td>
</tr>
<? if($soegopgaver) { if(mysql_num_rows($soegopgaver)) { while($listopgave = mysql_fetch_array($soegopgaver)) { ?>
<tr>
<td class="main" width="200" align="left" valign="top" style="border-bottom: 1px SOLID #CCCCCC;border-right: 1px DOTTED #CCCCCC" title="Oprettet: kl. <? echo(date("H:i \d. d.m.Y",$listopgave['oprettet'])); echo" af "; echo(ucwords($listopgave['opretter'])); ?>" >
<a href="opgave.php?projektid=<? echo$listopgave['projektid']; ?>&opgaveid=<? echo$listopgave['relid']; ?>" >
<table border="0" cellspacing="0" cellpadding="0" align="right" >
<tr>
<td class="main" style="background: <? echo$etiketfarve[($listopgave[etiket])][1]; ?>" width="40" valign="top" ><? echo$etiketfarve[($listopgave[etiket])][2]; ?></td>
</tr>
</table>
<? echo$listopgave['relid']; ?>: <? echo(ucfirst($listopgave['emne'])); ?> <? if($listopgave['lukket']) echo"(L)"; ?> <? if($listopgave['prioritet'] == 1 || $listopgave['prioritet'] == 3) { ?><b><font color="<? echo($listopgave['prioritet'] == 3) ? "red" : "blue"; ?>" ><? echo($listopgave['prioritet'] == 3) ? "!" : "↓"; ?></font><? } ?></b>
<br><span class="mainsmall" >Projekt: <? echo(ucfirst($listopgave['projektnavn'])); ?> <? if($listopgave['projektlukket']) echo"(L)"; ?></span></a>
</td>
<td class="main" width="180" align="left" valign="top" style="border-bottom: 1px SOLID #CCCCCC;border-right: 1px DOTTED #CCCCCC" ><? echo(ucwords($listopgave['kunden'])); ?> </td>
<td class="main" width="200" align="left" valign="top" style="border-bottom: 1px SOLID #CCCCCC;border-right: 1px DOTTED #CCCCCC" >
<table border="0" cellspacing="0" cellpadding="0" >
<tr>
<td class="main" width="40" valign="top" >Tidligst:</td>
<td class="main" width="150" valign="top" align="right" ><? echo($listopgave['tidligst']) ? $ugen[(date("w",$listopgave['tidligst']))] : ""; ?> <? echo($listopgave['tidligst']) ? date("j/n Y \k\l. H:i",$listopgave['tidligst']) : "-- -- --"; ?></td>
</tr>
<tr>
<td class="main" width="40" valign="top" >Start:</td>
<td class="main" width="150" valign="top" align="right" ><? echo($listopgave['start']) ? $ugen[(date("w",$listopgave['start']))] : ""; ?> <? echo($listopgave['start']) ? date("j/n Y \k\l. H:i",$listopgave['start']) : "-- -- --"; ?></td>
</tr>
<tr>
<td class="main" width="40" valign="top" >Forfald:</td>
<td class="main" width="150" valign="top" align="right" ><? echo($listopgave['forfald']) ? $ugen[(date("w",$listopgave['forfald']))] : ""; ?> <? echo($listopgave['forfald']) ? date("j/n Y \k\l. H:i",$listopgave['forfald']) : "-- -- --"; ?></td>
</tr>
</table>
</td>
<td class="main" width="200" align="left" valign="top" style="border-bottom: 1px SOLID #CCCCCC" >Beskrivelse:<br><? echo($listopgave['beskrivelse']) ? ucfirst($listopgave['beskrivelse']) : "<i>Ingen beskrivelse</i>"; ?><br>Obs:<br><? echo($listopgave['obs']) ? ucfirst($listopgave['obs']) : "<i>Ingen obs</i>"; ?></td>
</tr>
<? } } else { ?>
<tr>
<td class="main" width="200" align="left" valign="top" colspan="4" >Der er ingen opgaver i søgningen</td>
</tr>
<? } } else { ?>
<tr>
<td class="main" width="200" align="left" valign="top" colspan="4" >Der er ingen søgning foretaget</td>
</tr>
<? } ?>
</table>
<table border="0" cellspacing="0" cellpadding="0" align="center" >
<tr>
<td class="main" colspan="6" > <h4>Ordrer (<? echo($soegordrer) ? mysql_num_rows($soegordrer) : 0; ?>)</h4></td>
</tr>
<tr>
<td class="main" width="150" style="border-left: 2px SOLID #CCCCCC;border-bottom: 2px SOLID #CCCCCC" valign="top" > Ordre</td>
<td class="main" width="220" align="left" valign="top" style="border-bottom: 2px SOLID #CCCCCC;border-left: 2px SOLID #CCCCCC" > Fakturatekst</td>
<td class="main" width="220" align="left" valign="top" style="border-bottom: 2px SOLID #CCCCCC;border-left: 2px SOLID #CCCCCC" > Kommentar</td>
<td class="main" width="60" align="left" valign="top" style="border-bottom: 2px SOLID #CCCCCC;border-left: 2px SOLID #CCCCCC" > Timer</td>
<td class="main" width="60" align="left" valign="top" style="border-bottom: 2px SOLID #CCCCCC;border-left: 2px SOLID #CCCCCC" > Materi.</td>
<td class="main" width="60" align="left" valign="top" style="border-bottom: 2px SOLID #CCCCCC;border-left: 2px SOLID #CCCCCC;border-right: 2px SOLID #CCCCCC" > Ialt</td>
</tr>
<? if($soegordrer) { if(mysql_num_rows($soegordrer)) { while($listordre = mysql_fetch_array($soegordrer)) {
$summaterialer = mysql_fetch_array(mysql_query("SELECT SUM(toli.antal*(toli.pris+toli.afgift)) AS materialer FROM tblorderlines AS toli WHERE ordreid = '$listordre[relid]' GROUP BY ordreid")) ;
$sumtimer = mysql_fetch_array(mysql_query("SELECT SUM(tt.timer*tt.timepris) AS timer FROM tbltimer AS tt WHERE ordreid = '$listordre[relid]' GROUP BY ordreid")) ;
$ordretimersum += $sumtimer['timer'];
$ordrematerialersum += $summaterialer['materialer'];
?>
<tr>
<td class="main" width="150" valign="top" style="border-bottom: 1px SOLID #CCCCCC" title="Oprettet: <? echo(date("H:i d-m-Y", $listordre['oprettet'])); ?> af <? echo$listordre['opretternavn']."\n"; ?><? if($listordre['lukket']) { echo("Lukket: ".date("H:i d-m-Y",$listordre['lukket'])."\n"); } ?><? if($listordre['fakturadato']) { echo("Faktureret: ".date("d-m-Y",$listordre['fakturadato'])); } ?>" >
<a href="ordreresume.php?projektid=<? echo$listordre['projektid']; ?>&ordreid=<? echo$listordre['relid']; ?>" ><? echo$listordre['relid'].": "; echo($listordre['rekvisition']) ? ucfirst($listordre['rekvisition']) : "<i>Ingen reference</i>"; ?> <? if($listordre['lukket']) echo"(L)"; ?>
<br><span class="mainsmall" >Projekt: <? echo(ucfirst($listordre['projektnavn'])); ?> <? if($listordre['projektlukket']) echo"(L)"; ?></span></a>
</td>
<td class="main" width="220" align="left" valign="top" style="border-bottom: 1px SOLID #CCCCCC;border-left: 1px DOTTED #CCCCCC" >
<? echo(ucfirst($listordre['fakturatekst'])); ?>
</td>
<td class="main" width="220" align="left" valign="top" style="border-bottom: 1px SOLID #CCCCCC;border-left: 1px DOTTED #CCCCCC" >
<? echo(ucfirst($listordre['kommentar'])); ?>
</td>
<td class="main" width="60" align="right" valign="top" style="border-left: 1px DOTTED #CCCCCC;border-bottom: 1px SOLID #CCCCCC"><? echo(number_format($sumtimer['timer'], 2, ',', '.')); ?></td>
<td class="main" width="60" align="right" valign="top" style="border-left: 1px DOTTED #CCCCCC;border-bottom: 1px SOLID #CCCCCC"><? echo(number_format($summaterialer['materialer'], 2, ',', '.')); ?></td>
<td class="main" width="60" align="right" valign="top" style="border-left: 1px DOTTED #CCCCCC;border-bottom: 1px SOLID #CCCCCC"><? echo(number_format($sumtimer['timer']+$summaterialer['materialer'], 2, ',', '.')); ?></td>
</tr>
<? } } else { ?>
<tr>
<td class="main" colspan="6" >Der er ingen ordrer i søgningen</td>
</tr>
<? } } else { ?>
<tr>
<td class="main" colspan="6" >Der er ingen søgning foretaget</td>
</tr>
<? } ?>
</table>
<table border="0" cellspacing="0" cellpadding="0" align="center" >
<tr>
<td class="main" colspan="6" > <h4>Fakturaer (<? echo($soegfakturaer) ? mysql_num_rows($soegfakturaer) : 0; ?>)</h4></td>
</tr>
<tr>
<td class="main" width="150" style="border-left: 2px SOLID #CCCCCC;border-bottom: 2px SOLID #CCCCCC" valign="top" > Ordre / Faktura</td>
<td class="main" width="220" align="left" valign="top" style="border-bottom: 2px SOLID #CCCCCC;border-left: 2px SOLID #CCCCCC" > Fakturatekst</td>
<td class="main" width="220" align="left" valign="top" style="border-bottom: 2px SOLID #CCCCCC;border-left: 2px SOLID #CCCCCC" > Kommentar</td>
<td class="main" width="60" align="left" valign="top" style="border-bottom: 2px SOLID #CCCCCC;border-left: 2px SOLID #CCCCCC" > Timer</td>
<td class="main" width="60" align="left" valign="top" style="border-bottom: 2px SOLID #CCCCCC;border-left: 2px SOLID #CCCCCC" > Materi.</td>
<td class="main" width="60" align="left" valign="top" style="border-bottom: 2px SOLID #CCCCCC;border-left: 2px SOLID #CCCCCC;border-right: 2px SOLID #CCCCCC" > Ialt</td>
</tr>
<? $listordre = NULL; if($soegfakturaer) { if(mysql_num_rows($soegfakturaer)) { while($listordre = mysql_fetch_array($soegfakturaer)) {
$summaterialer = mysql_fetch_array(mysql_query("SELECT SUM(toli.antal*(toli.pris+toli.afgift)) AS materialer FROM tblorderlines AS toli WHERE ordreid = '$listordre[relid]' GROUP BY ordreid")) ;
$sumtimer = mysql_fetch_array(mysql_query("SELECT SUM(tt.timer*tt.timepris) AS timer FROM tbltimer AS tt WHERE ordreid = '$listordre[relid]' GROUP BY ordreid")) ;
$ordretimersum += $sumtimer['timer'];
$ordrematerialersum += $summaterialer['materialer'];
?>
<tr>
<td class="main" width="150" valign="top" style="border-bottom: 1px SOLID #CCCCCC" title="Oprettet: <? echo(date("H:i d-m-Y", $listordre['oprettet'])); ?> af <? echo$listordre['opretternavn']."\n"; ?><? if($listordre['lukket']) { echo("Lukket: ".date("H:i d-m-Y",$listordre['lukket'])."\n"); } ?><? if($listordre['fakturadato']) { echo("Faktureret: ".date("d-m-Y",$listordre['fakturadato'])); } ?>" >
<a href="fakturaresume.php?projektid=<? echo$listordre['projektid']; ?>&ordreid=<? echo$listordre['relid']; ?>" ><? echo$listordre['relid']." / F".$listordre['fakturanummer'].": "; echo($listordre['rekvisition']) ? ucfirst($listordre['rekvisition']) : "<i>Ingen reference</i>"; ?> <? if($listordre['lukket']) echo"(L)"; ?>
<br><span class="mainsmall" >Projekt: <? echo(ucfirst($listordre['projektnavn'])); ?> <? if($listordre['projektlukket']) echo"(L)"; ?></span></a>
</td>
<td class="main" width="220" align="left" valign="top" style="border-bottom: 1px SOLID #CCCCCC;border-left: 1px DOTTED #CCCCCC" >
<? echo(ucfirst($listordre['fakturatekst'])); ?>
</td>
<td class="main" width="220" align="left" valign="top" style="border-bottom: 1px SOLID #CCCCCC;border-left: 1px DOTTED #CCCCCC" >
<? echo(ucfirst($listordre['kommentar'])); ?>
</td>
<td class="main" width="60" align="right" valign="top" style="border-left: 1px DOTTED #CCCCCC;border-bottom: 1px SOLID #CCCCCC"><? echo(number_format($sumtimer['timer'], 2, ',', '.')); ?></td>
<td class="main" width="60" align="right" valign="top" style="border-left: 1px DOTTED #CCCCCC;border-bottom: 1px SOLID #CCCCCC"><? echo(number_format($summaterialer['materialer'], 2, ',', '.')); ?></td>
<td class="main" width="60" align="right" valign="top" style="border-left: 1px DOTTED #CCCCCC;border-bottom: 1px SOLID #CCCCCC"><? echo(number_format($sumtimer['timer']+$summaterialer['materialer'], 2, ',', '.')); ?></td>
</tr>
<? } } else { ?>
<tr>
<td class="main" colspan="6" >Der er ingen fakturaer i søgningen</td>
</tr>
<? } } else { ?>
<tr>
<td class="main" colspan="6" >Der er ingen søgning foretaget</td>
</tr>
<? } ?>
</table>
<table border="0" cellspacing="0" cellpadding="0" align="center" >
<tr>
<td class="main" colspan="6" > <h4>Tilbud (<? echo($soegtilbud) ? mysql_num_rows($soegtilbud) : 0; ?>)</h4></td>
</tr>
<tr>
<td class="main" width="150" style="border-left: 2px SOLID #CCCCCC;border-bottom: 2px SOLID #CCCCCC" valign="top" > Tilbud</td>
<td class="main" width="220" align="left" valign="top" style="border-bottom: 2px SOLID #CCCCCC;border-left: 2px SOLID #CCCCCC" > Beskrivelse</td>
<td class="main" width="220" align="left" valign="top" style="border-bottom: 2px SOLID #CCCCCC;border-left: 2px SOLID #CCCCCC" > Betingelser</td>
<td class="main" width="60" align="left" valign="top" style="border-bottom: 2px SOLID #CCCCCC;border-left: 2px SOLID #CCCCCC" > Timer</td>
<td class="main" width="60" align="left" valign="top" style="border-bottom: 2px SOLID #CCCCCC;border-left: 2px SOLID #CCCCCC" > Materi.</td>
<td class="main" width="60" align="left" valign="top" style="border-bottom: 2px SOLID #CCCCCC;border-left: 2px SOLID #CCCCCC;border-right: 2px SOLID #CCCCCC" > Ialt</td>
</tr>
<? $listordre = NULL; if($soegtilbud) { if(mysql_num_rows($soegtilbud)) { while($listordre = mysql_fetch_array($soegtilbud)) {
$summaterialer = mysql_fetch_array(mysql_query("SELECT SUM(toli.antal*(toli.pris+toli.afgift)) AS materialer FROM tbltilbudlinjer AS toli WHERE tilbudid = '$listordre[relid]' GROUP BY tilbudid "));
$tilbudtimersum += $listordre['sumtimeloen'];
$tilbudmaterialersum += $summaterialer['materialer'];
?>
<tr>
<td class="main" width="150" valign="top" style="border-bottom: 1px SOLID #CCCCCC" title="Oprettet: <? echo(date("H:i d-m-Y", $listordre['ordreoprettet'])); ?> af <? echo$listordre['opretternavn']."\n"; ?><? if($listordre['lukket']) { echo("Lukket: ".date("H:i d-m-Y",$listordre['lukket'])."\n"); } ?><? if($listordre['fakturadato']) { echo("Faktureret: ".date("d-m-Y",$listordre['fakturadato'])); } ?>" ><a href="tilbud.php?projektid=<? echo$listordre['projektid']; ?>&tilbudid=<? echo$listordre['relid']; ?>" ><? echo$listordre['relid'].": "; echo($listordre['emne']) ? ucfirst($listordre['emne']) : "<i>Ingen reference</i>"; ?><? echo($listordre['type'] == 1) ? " (O)" : " (T)"; ?> <? if($listordre['lukket']) echo"(L)"; ?>
<br><span class="mainsmall" >Projekt: <? echo(ucfirst($listordre['projektnavn'])); ?> <? if($listordre['projektlukket']) echo"(L)"; ?></span></a>
</td>
<td class="main" width="220" align="left" valign="top" style="border-bottom: 1px SOLID #CCCCCC;border-left: 1px DOTTED #CCCCCC"><? echo(ucfirst($listordre['beskrivelse'])); ?> </td>
<td class="main" width="220" align="left" valign="top" style="border-bottom: 1px SOLID #CCCCCC;border-left: 1px DOTTED #CCCCCC"><? echo(ucfirst($listordre['betingelser'])); ?> </td>
<td class="main" width="60" align="right" valign="top" style="border-left: 1px DOTTED #CCCCCC;border-bottom: 1px SOLID #CCCCCC"><? echo(number_format($listordre['sumtimeloen'], 2, ',', '.')); ?> </td>
<td class="main" width="60" align="right" valign="top" style="border-left: 1px DOTTED #CCCCCC;border-bottom: 1px SOLID #CCCCCC"><? echo(number_format($summaterialer['materialer'], 2, ',', '.')); ?> </td>
<td class="main" width="60" align="right" valign="top" style="border-left: 1px DOTTED #CCCCCC;border-bottom: 1px SOLID #CCCCCC"><? echo(number_format($summaterialer['materialer']+$listordre['sumtimeloen'], 2, ',', '.')); ?> </td>
</tr>
<? } } else { ?>
<tr>
<td class="main" colspan="6" >Der er ingen tilbud i søgningen</td>
</tr>
<? } } else { ?>
<tr>
<td class="main" colspan="6" >Der er ingen søgning foretaget</td>
</tr>
<? } ?>
</table>
</p>
<br><br>
</body>
</html>
Og her er inc_db_connect.php
<?
mysql_connect("localhost","user","pass") or die("Kan ikke forbinde til mysqlserver");
mysql_select_db("db");
session_start();
mysql_query("INSERT INTO tider (url,tid,brugerid) VALUES ('$_SERVER[REQUEST_URI]',NOW(),'$_SESSION[sess_userid]') ")or die(mysql_error());
?>
kalenderstartsoegning og kalenderslutsoegning.php indeholder ikke en include og der er selvfølgelig heller ikke en INSERT som i include.
