Flot det var så den forkert kode, jeg fik smidt op... doh
Så vi prøver igen.
<?php
include('static/afsnit6.php');
// include('static/ordre11.php');
include('system/date.php');
include("system/dhtmlgoodies_tree.class.php");
include('static/opsaetning.php');
/* Fetch database values */
$res = array();
for ($i=0;$i<=5;$i++) {
$sql = mysql_query("
SELECT *
FROM ordre".$i."
WHERE tilbudsnummer='".addslashes($_GET['id'])."'
") or die(mysql_error);
if (mysql_num_rows($sql)) $res = array_merge($res, mysql_fetch_assoc($sql));
}
list($comp, $personid) = explode('x', $_COOKIE["PBS"]);
$select = '';
if ($personid == "99998") $select = "ADM";
while (list ($key, $val) = each ($ALLEPROJEKTLEDERE)) {
if ($key == $personid) {
$select = substr($val['navn'], -4, 3);
}
}
$i = 0;
if ($handle = opendir('template')) {
while (false !== ($file = readdir($handle))) {
if ($file != "." && $file != "..") {
if (strpos($file, 'template_ordre') !== false) {
$skabelon[$i] = substr(basename($file, '.rtf'), 15);
$i++;
}
}
}
}
closedir($handle);
$person = mysql_query("SELECT email FROM stamdata WHERE employee ='".$res['r1']."'");
$resu = mysql_fetch_array($person);
?>
<form action="/entreprise_ordre_process.php" method="post" name="ds" id="ds" style="display:inline;" autocomplete="off">
<?php //if ($res['r534'] == 1) echo '<input type="hidden" name="readonly" value="1">'; ?>
<input type="hidden" name="nextpage" value="13">
<input type="hidden" name="thispage" value="12">
<input type="hidden" name="eid" value="<?php echo $_GET['id']; ?>">
<input type="hidden" name="bygherre_hidden" value="<?php echo $res['bygherre_hidden']; ?>">
<input type="hidden" name="låser" value="<?php echo $personid;?>"/>
<input type="hidden" name="låser_ini" value="<?php echo $select;?>"/>
<table width="1080px" border="0" cellspacing="0" cellpadding="0" align="right">
<br />
<input type="submit" name="gem" class="submit" value="Gem" style="position: absolute; left: -200px; top: -200px;"/>
<?php
//Vi skal lige have fundet ud af hvor mange kolonner der er
$mig = "SELECT MAX(kolonnenr) AS kol FROM kalkulation AS k LEFT JOIN kalkulationspriser AS kp ON k.id = kp.kalkulations_id LEFT JOIN kalkulationskolonner AS kk ON kp.id = kk.kostpris_id WHERE ordre_id = ".addslashes($_GET['id'])." GROUP BY ordre_id";
$migg = mysql_query($mig) or die(mysql_error());
$miggi = mysql_fetch_array($migg);
$antal_kol = $miggi['kol'];
?>
<ul>
<ul>
<ul>
<input type="text" class="listformsmallx" name="betegnelser[]" readonly value="Navn" />
<input type="text" class="listformsmallx" name="betegnelser[]" readonly value="Beskrivelse" />
<?php
for ($y=1;$y<=$antal_kol;$y++) {
?>
<input type="textarea" class="listformsmallx" name="betegnelser[]" readonly value="Forkalkulation <?php echo $y;?>" />
<?php }
?>
</ul>
<ul>
<img src="/gfx/transparent.gif" style="width:100px;height:5px;" />
<img src="/gfx/transparent.gif" style="width:100px;height:5px;" />
<?php
$total_kostpris = array();
for ($z=1;$z<=$antal_kol;$z++) {
//Kostpris
$låst_dato = "SELECT låst_af, DATE_FORMAT(dato, '%Y-%m-%d') AS dato, SUM(kostpris) AS kostpris FROM kalkulation AS k
LEFT JOIN kalkulationspriser AS kp ON k.id=kp.kalkulations_id
LEFT JOIN kalkulationskolonner AS kk ON kp.id = kk.kostpris_id
WHERE kolonnenr = '".$z."' AND ordre_id = ".addslashes($_GET['id'])." AND type = 0 GROUP BY ordre_id LIMIT 1";
$lås_dato = mysql_query($låst_dato) or die(mysql_error);
$dato = mysql_fetch_array($lås_dato);
$total_kostpris[] = $dato['kostpris'];
//Salgspris
$låst_datos = "SELECT SUM(kostpris) AS salgspris FROM kalkulation AS k
LEFT JOIN kalkulationspriser AS kp ON k.id=kp.kalkulations_id
LEFT JOIN kalkulationskolonner AS kk ON kp.id = kk.kostpris_id
WHERE kolonnenr = '".$z."' AND ordre_id = ".addslashes($_GET['id'])." AND type = 1 GROUP BY ordre_id LIMIT 1";
$lås_datos = mysql_query($låst_datos) or die(mysql_error);
$datos = mysql_fetch_array($lås_datos);
$total_salgspris[] = $datos['salgspris'];
//echo $dato['låst_af']
?>
<input type="text" class="listformsmally" name="betegnelser[]" readonly value="Låst: <?php echo sqltoalmdatetom($dato['dato']).' ('. $dato['låst_af'].')';?>" />
<?php }?>
</ul>
</ul>
</ul>
<!-- Dækningsbidrag og grad -->
<ul>
<ul>
<ul>
<img src="/gfx/transparent.gif" style="width:100px;height:5px;" />
<input type="text" class="listformsmally" name="betegnelser[]" readonly value="Dækningsbidrag:" style="font-weight:bold"/>
<?php if (count($total_salgspris) > 0 && count($total_kostpris) > 0) {
for ($b=0;$b<count($total_salgspris);$b++) {?><b>Kr.</b>
<input type="text" class="listformsmallz" name="betegnelser[]" readonly value="<?php echo number_format($total_salgspris[$b] - $total_kostpris[$b], 0, ',', '.');?>" style="font-weight:bold;text-align:right;"/>
<?php }
}?>
</ul>
<ul>
<img src="/gfx/transparent.gif" style="width:100px;height:5px;" />
<input type="text" class="listformsmally" name="betegnelser[]" readonly value="Dækningsgrad:" style="font-weight:bold"/>
<?php if (count($total_salgspris) > 0 && count($total_kostpris) > 0) {
for ($b=0;$b<count($total_salgspris);$b++) {
if ($total_salgspris[$b] != 0) {?>
<input type="text" class="listformsmallx" name="betegnelser[]" readonly value="<?php echo number_format(round( ($total_salgspris[$b] - $total_kostpris[$b])/$total_salgspris[$b]*100, 2 ), 2, ',', '.');?>" style="font-weight:bold;text-align:right;"/>
<?php } else { ?>
<input type="text" class="listformsmallx" name="betegnelser[]" readonly value="0" style="font-weight:bold;text-align:right;"/>
<?php }
}
}?>
</ul>
</ul>
</ul>
<a href="#" onclick="showAll();return false">Åbn alle punkter</a><br>
<a href="#" onclick="hideAll();return false">Luk alle punkter</a><br>
<hr />
<!-- Salgspriser -->
<?php
$queryt = "SELECT k.id AS id, k.ordre_id, k.underakt AS underakt, k.navn AS navn, k.beskrivelse AS beskrivelse FROM kalkulation AS k WHERE k.ordre_id = '".addslashes($_GET['id'])."' AND type = 1";
$salgs_tæller = 0;
?>
<!-- Salgspriser -->
<ul>
<ul>
<ul>
<img src="/gfx/transparent.gif" style="width:100px;height:5px;" />
<input type="text" class="listformsmally" name="betegnelser[]" readonly value="I alt salgspris:" style="font-weight:bold"/>
<?php
if (count($total_salgspris) > 0) {
for ($q=0;$q<count($total_salgspris);$q++) {?><b>Kr.</b>
<input type="text" class="listformsmallz" name="betegnelser[]" readonly value="<?php echo number_format($total_salgspris[$q], 0, ',', '.');?>" style="font-weight:bold;text-align:right;"/>
<?php }
}?>
</ul>
</ul>
</ul>
<ul>
<?php
for ($w=1;$w<=count($SALGSPRIS);$w++) {
$salgspris_navn = $SALGSPRIS[$w];?>
<li>
<a href="#" onclick="showhide('id_<?php echo $salgspris_navn;?>');" style="width:288px;">
<!-- <a href="#" onclick="showAll();" style="width:288px;">-->
<?php echo $salgspris_navn;?>
</a>
<!--Total salgspris-->
<?php
for ($d=1;$d<=$antal_kol;$d++) {
$total_kostpris = "SELECT SUM(kostpris) AS total FROM kalkulation AS k
LEFT JOIN kalkulationspriser AS kp ON k.id=kp.kalkulations_id
LEFT JOIN kalkulationskolonner AS kk ON kp.id = kk.kostpris_id
WHERE kolonnenr = '".$d."' AND ordre_id = '".addslashes($_GET['id'])."' AND underakt = '".$salgspris_navn."' AND type = 1";
$total_kost = mysql_query($total_kostpris) or die(mysql_error);
$total = mysql_fetch_array($total_kost);
if (empty($total['total'])) {
$total['total']="0";
}
?>
<b>Kr.</b>
<input type="text" class="listformsmallz" name="total[]" readonly value="<?php echo number_format($total['total'], 0, ',', '.'); ?>" style="font-weight:bold;text-align:right;"/>
<?php } ?>
<div id="id_<?php echo $salgspris_navn;?>" style="display:none;">
<ul>
<?php
$sqlt = mysql_query($queryt) or die(mysql_error);
if (!mysql_num_rows($sqlt) || !isset($sqlt)) {
$salgs_tæller++;?>
<ul>
<!-- Inputfelter til de underakt, der endnu ikke indeholder data-->
<input type="hidden" name="salgs_kalk_id[]" value=""/>
<input type="hidden" name="salgs_underakt[]" value="<?php echo $salgspris_navn;?>"/>
<input type="text" class="inputextrasmall" name="salgs_navn[]">
<input type="text" class="inputextrasmall" name="salgs_beskrivelse[]"/>
</ul>
<? } else {
while ($foot = mysql_fetch_array($sqlt)) {
if ($salgspris_navn == $foot['underakt']) {
?>
<?php
$salgs_tæller++;?>
<ul>
<!-- Inputfelter til de underakt, der indeholder data-->
<input type="hidden" name="salgs_underakt[]" value="<?php echo $salgspris_navn;?>"/>
<input type="hidden" name="salgs_kalk_id[]" value="<?php echo $foot['id']; ?>" />
<input type="text" class="inputextrasmall" name="salgs_navn[]" value="<?php echo $foot['navn']; ?>">
<input type="text" class="inputextrasmall" name="salgs_beskrivelse[]" value="<?php echo $foot['beskrivelse']; ?>"/>
<?php // Her skal der returneres et antal kolonne, som passer til de låste + 1 for sagen
$maxkol = "SELECT MAX(kolonnenr) AS max_kol FROM kalkulation AS k LEFT JOIN kalkulationspriser AS kp ON kp.kalkulations_id = k.id LEFT JOIN kalkulationskolonner AS kk ON kp.id = kk.kostpris_id WHERE k.ordre_id = '".addslashes($_GET['id'])."' AND k.id = '".$foot['id']."' AND type = 1 GROUP BY ordre_id";
$m_kol = mysql_query($maxkol) or die(mysql_error);
$m_k = mysql_fetch_array($m_kol);
$forespøgz = "SELECT *, kp.låst AS kp_låst, k.id AS id, kp.id AS kp_id FROM kalkulation AS k
LEFT JOIN kalkulationspriser AS kp ON kp.kalkulations_id = k.id
LEFT JOIN kalkulationskolonner AS kk ON kp.id = kk.kostpris_id
WHERE k.ordre_id = '".addslashes($_GET['id'])."' AND k.id = '".$foot['id']."' AND type = 1";
$forez = mysql_query($forespøgz) or die(mysql_error);
$counterz=1;
$arz = mysql_num_rows($forez);
while ($foresz = mysql_fetch_array($forez)) {
if ($foresz['kolonnenr'] == 0) {// || !isset($foresz['kolonnenr'])){
$foresz['kolonnenr'] = 1;
}
if ($foresz['kp_id'] == 0 ) {//|| !isset($foresz['kp_id'])){
$foresz['kp_id'] = 0;
}
?>
Kr.
<input type="text" name="salgs_kostpris[<?php echo $foresz['id'];?>][<?php echo $foresz['kolonnenr'];?>][<?php echo $foresz['kp_id'];?>]" value="<?php echo number_format($foresz['kostpris'], 0, ',', '.'); ?>" <?php if ($foresz['kp_låst'] != "1") { echo "class='inputextrasmallx'"; } else { echo "class='listformsmallz' readonly";}?> style="text-align:right;"/>
<!-- name="kostpris[<?php echo $fores['id'];?>][<?php echo $fores['kolonnenr'];?>][<?php echo $fores['kp_id'];?>]"-->
<?php
if ($counterz == $arz && $foresz['låst'] == "1") {
//Skal kun udføres efter sidste celle/kolonne, hvis denne er låst?>
Kr.
<input type="text" class="inputextrasmall" style="text-align:right;" name="salgs_kostpris[<?php echo $foresz['id'];?>][<?php echo $foresz['kolonnenr']+1;?>][]">
<?php }
$counterz+=1;
}?>
</ul>
<?php }
}
$salgs_tæller++;?>
<ul>
<!-- Inputfelter til de underakt, der indeholder data-->
<input type="hidden" name="salgs_kalk_id[]" value=""/>
<input type="hidden" name="salgs_underakt[]" value="<?php echo $salgspris_navn;?>"/>
<input type="text" class="inputextrasmall" name="salgs_navn[]">
<input type="text" class="inputextrasmall" name="salgs_beskrivelse[]"/>
</ul>
<ul>
<input type="submit" name="gem" class="submit" value="Gem" style="position: absolute; left: -200px; top: -200px;"/>
<input name="laas" type="submit" value="Lås forkalkulation" class="submit" style="width:125px;"/>
</ul>
<?php }?>
</ul>
</div>
</li>
<?php }?>
</ul>
<input type="submit" name="gem" class="submit" value="Gem" style="position: absolute; left: -200px; top: -200px;"/>
<hr />
<!-- Kostpriser -->
<ul>
<ul>
<ul>
<img src="/gfx/transparent.gif" style="width:100px;height:5px;" />
<input type="text" class="listformsmally" name="betegnelser[]" readonly value="I alt kostpris:" style="font-weight:bold"/>
<?php
if (count($total_kostpris) > 0) {
for ($q=0;$q<count($total_kostpris);$q++) {?>
<b>Kr.</b>
<input type="text" class="listformsmallz" name="betegnelser[]" readonly value="<?php echo number_format($total_kostpris[$q], 0, ',', '.');?>" style="font-weight:bold;text-align:right;"/>
<?php }
}?>
</ul>
</ul>
</ul>
<ul>
<?php
$tæller = 0;
for ($j=1;$j<=count($HOVEDAKT);$j++) {
$hovedakt_nr = $HOVEDAKT[$j]['nr'];
$hovedakt_be = $HOVEDAKT[$j]['beskrivelse'];?>
<li>
<a href="#" onclick="showhide('id_<?php echo $hovedakt_nr;?>');" style="width:288px;">
<?php echo $hovedakt_nr." - ".$hovedakt_be;?>
</a>
<!--Total kostpris for hovedakt-->
<?php
for ($x=1;$x<=$antal_kol;$x++) {
$total_kostpris = "SELECT SUM(kostpris) AS total FROM kalkulation AS k
LEFT JOIN kalkulationspriser AS kp ON k.id=kp.kalkulations_id
LEFT JOIN kalkulationskolonner AS kk ON kp.id = kk.kostpris_id
WHERE kolonnenr = '".$x."' AND ordre_id = '".addslashes($_GET['id'])."' AND SUBSTRING(underakt, 1, 1) = '".substr($hovedakt_nr, 0, 1)."' AND type = 0";
$total_kost = mysql_query($total_kostpris) or die(mysql_error);
$total = mysql_fetch_array($total_kost);
if (empty($total['total'])) {
$total['total']="0";
}
?>
<b>Kr.</b>
<input type="text" class="listformsmallz" name="total[]" readonly value="<?php echo number_format($total['total'], 0, ',', '.'); ?>" style="font-weight:bold;text-align:right;"/>
<?php } ?>
<div id="id_<?php echo $hovedakt_nr;?>" style="display:none;">
<?
for ($i=1;$i<=count($UNDERAKT);$i++) {
$underakt_nr = $UNDERAKT[$i]['nr'];
$underakt_be = $UNDERAKT[$i]['beskrivelse'];
if (substr($underakt_nr,0,1)."0" == $hovedakt_nr) {?>
<ul>
<?php //$query = "SELECT k.id AS id, k.ordre_id, k.underakt AS underakt, k.navn AS navn, k.beskrivelse AS beskrivelse, k.kostpris_id, kp.kostpris AS kostpris FROM kalkulation AS k LEFT JOIN kalkulationspriser AS kp ON k.kostpris_id = kp.kostpris_id WHERE k.ordre_id = '".addslashes($_GET['id'])."' AND k.underakt = $underakt_nr";
$query = "SELECT k.id AS id, k.ordre_id, k.underakt AS underakt, k.navn AS navn, k.beskrivelse AS beskrivelse FROM kalkulation AS k WHERE k.ordre_id = '".addslashes($_GET['id'])."' AND k.underakt = $underakt_nr AND type = 0";
$sql = mysql_query($query) or die(mysql_error);
if (!mysql_num_rows($sql) || !isset($sql)) {
$tæller++;?>
<li>
<a href="#" onclick="showhide('id_<?php echo $underakt_nr;?>');">
<?php echo $underakt_nr. " - ".$underakt_be;?>
</a>
<div id="id_<?php echo $underakt_nr;?>" style="display:none;">
<ul>
<!-- Inputfelter til de underakt, der endnu ikke indeholder data-->
<input type="hidden" name="kalk_id[]" value=""/>
<input type="hidden" name="underakt[]" value="<?php echo $underakt_nr;?>"/>
<input type="text" class="inputextrasmall" name="navn[]">
<input type="text" class="inputextrasmall" name="beskrivelse[]"/>
</ul>
</div>
<? } else { ?>
<li >
<a href="#" onclick="showhide('id_<?php echo $underakt_nr;?>');" style="width:248px;">
<?php echo $underakt_nr. " - ".$underakt_be;?>
</a>
<!--<img src="/gfx/transparent.gif" style="width:112px;height:10px;"/>-->
<?php
for ($x=1;$x<=$antal_kol;$x++) {
$total_kostpris = "SELECT SUM(kostpris) AS total FROM kalkulation AS k
LEFT JOIN kalkulationspriser AS kp ON k.id=kp.kalkulations_id
LEFT JOIN kalkulationskolonner AS kk ON kp.id = kk.kostpris_id
WHERE kolonnenr = '".$x."' AND ordre_id = '".addslashes($_GET['id'])."' AND underakt = '".$underakt_nr."' AND type = 0";
$total_kost = mysql_query($total_kostpris) or die(mysql_error);
$total = mysql_fetch_array($total_kost);?>
<b>Kr.</b>
<input type="text" class="listformsmallz" name="total[]" readonly value="<?php echo number_format($total['total'], 0, ',', '.'); ?>" style="font-weight:bold;text-align:right;"/>
<?php } ?>
<div id="id_<?php echo $underakt_nr;?>" style="display:none;">
<?php while ($foo = mysql_fetch_array($sql)) {
$tæller++;?>
<ul>
<input type="hidden" name="kalk_id[]" value="<?php echo $foo['id']; ?>" />
<input type="hidden" name="underakt[]" value="<?php echo $underakt_nr;?>"/>
<input type="text" class="inputextrasmall" name="navn[]" value="<?php echo $foo['navn']; ?>" />
<input type="text" class="inputextrasmall" name="beskrivelse[]" value="<?php echo $foo['beskrivelse']; ?>" />
<?php // Her skal der returneres et antal kolonne, som passer til de låste + 1 for sagen
$maxkol = "SELECT MAX(kolonnenr) AS max_kol FROM kalkulation AS k LEFT JOIN kalkulationspriser AS kp ON kp.kalkulations_id = k.id LEFT JOIN kalkulationskolonner AS kk ON kp.id = kk.kostpris_id WHERE k.ordre_id = '".addslashes($_GET['id'])."' AND k.id = '".$foo['id']."' AND type = 0 GROUP BY ordre_id";
$m_kol = mysql_query($maxkol) or die(mysql_error);
$m_k = mysql_fetch_array($m_kol);
$forespøg = "SELECT *, kk.låst AS låst, kp.låst AS kp_låst, k.id AS id, kp.id AS kp_id FROM kalkulation AS k
LEFT JOIN kalkulationspriser AS kp ON kp.kalkulations_id = k.id
LEFT JOIN kalkulationskolonner AS kk ON kp.id = kk.kostpris_id
WHERE k.ordre_id = '".addslashes($_GET['id'])."' AND k.underakt = $underakt_nr AND k.id = '".$foo['id']."' AND type = 0";
$fore = mysql_query($forespøg) or die(mysql_error);
$counter=1;
$ar = mysql_num_rows($fore);
while ($fores = mysql_fetch_array($fore)) {
if ($fores['kolonnenr'] == 0){
$fores['kolonnenr'] = 1;
}
if ($fores['kp_id'] == 0){
$fores['kp_id'] = 0;
}?>
Kr.
<input type="text" style="text-align:right;" name="kostpris[<?php echo $fores['id'];?>][<?php echo $fores['kolonnenr'];?>][<?php echo $fores['kp_id'];?>]" value="<?php echo number_format($fores['kostpris'], 0, ',', '.'); ?>" <?php if ($fores['kp_låst'] != "1") { echo "class='inputextrasmallx'"; } else { echo "class='listformsmallz' readonly";}?> />
<?php
if ($counter == $ar && $fores['låst'] == "1") {
//Skal kun udføres efter sidste celle/kolonne, hvis denne er låst?>
Kr.
<input type="text" class="inputextrasmall" name="kostpris[<?php echo $fores['id'];?>][<?php echo $fores['kolonnenr']+1;?>][]">
<?php }
$counter+=1;
}?>
</ul>
<?php
}
$tæller++;?>
<ul>
<!-- Inputfelter til de underakt, der indeholder data-->
<input type="hidden" name="kalk_id[]" value=""/>
<input type="hidden" name="underakt[]" value="<?php echo $underakt_nr;?>"/>
<input type="text" class="inputextrasmall" name="navn[]">
<input type="text" class="inputextrasmall" name="beskrivelse[]"/>
</ul>
<ul>
<input type="submit" name="gem" class="submit" value="Gem" style="position: absolute; left: -200px; top: -200px;"/>
<input name="laas" type="submit" value="Lås forkalkulation" class="submit" style="width:125px;"/>
</ul>
</div>
<? } ?>
</li>
</ul>
<? }
}?>
</div>
</li>
<? }?>
</li>
</ul>
</li>
<tr>
<td>
<input type="submit" name="submit2" class="submit" value="Fortsæt">
<input type="hidden" name="tæller" value="<?php echo $tæller;?>" />
<input type="hidden" name="salgs_tæller" value="<?php echo $salgs_tæller;?>" />
</td>
</tr>
</table>
</form>
<script language="javascript">
<!--
var state = 'none';
function showAll() {
var divs = document.getElementsByTagName('div');
for (i=0;i<divs.length;i++) {
divs[i].style.display = 'block';
}
}
function hideAll() {
// var ext = new Array();
var ext = "right";
var tex = "left";
var divz = document.getElementsByTagName('div');
for (j=0;j<divz.length;j++) {
divz[j].style.display = 'none';
}
document.getElementById('left').style.display = 'block';
document.getElementById('right').style.display = 'block';
}
function showhide(layer_ref) {
if (state == 'block') {
state = 'none';
} else {
state = 'block';
}
if (document.all) { //IS IE 4 or 5 (or 6 beta)
eval( "document.all." + layer_ref + ".style.display = state");
}
if (document.layers) { //IS NETSCAPE 4 or below
document.layers[layer_ref].display = state;
}
if (document.getElementById &&!document.all) {
hza = document.getElementById(layer_ref);
hza.style.display = state;
}
}
//-->
</script>
