Ændre margin på udskrivning
Jeg har lavet en side, som skal kunne udskrives på en printer.Men jeg har ikke helt forstået hvordan jeg kobler css properties sammen med opsætningen af papiret. F.eks. vil jeg gerne ændre margin på udskriften, men der sker ikke noget når jeg ændrer værdierne.
I øjeblikket ser er min som følger:
<?php
require('system/global_defs.php');
include('system/date.php');
include('static/ordre12.php');
include('static/afsnit6.php');
?>
<html>
<head>
<style type="text/css">
@media print {
@page { size:21.0cm 29.7cm; }
@page { margin-left: 1cm; margin-right:0.8cm; margin-top:0.8cm; margin-bottom:0.8cm; }
@page :header { content: none ;}
@page :footer { content: none ;}
}
body, td {
font-family: Arial;
font-size: 9pt;
}
h1 {
font-size: 12pt;
}
.header {
font-weight: bold;
}
.header2 {
font-size: 9pt;
font-weight: bold;
vertical-align: top;
}
.small {
font-size: 6pt;
border-left: none;
border-right: none;
text-align: center;
}
.noborder {
border:none;
}
.footer {
font-size: 8pt;
border: none;
}
td {
border-collapse: collapse;
border: inset 1px;
}
</style>
<!--table{
border: outset 1px;
}
-->
</head>
<?php
$ua = array();
for ($qe=1;$qe<=count($UNDERAKT);$qe++) {
$ua[] = $UNDERAKT[$qe]['nr'];
}
$nummer = $_GET['forkalk'];
$ordre_id = $_GET['id'];
$lqs = "SELECT DATE_FORMAT(dato, '%d-%m-%Y') AS alm_dato, DATE(dato) AS dato, låst_af FROM kalkulation AS k LEFT JOIN kalkulationskolonner AS kk ON k.id = kk.kalkulations_id WHERE kolonnenr = '$nummer' AND ordre_id = '$ordre_id'";
$forlqs = mysql_query($lqs) or die($lqs);
$fl = mysql_fetch_array($forlqs);
?>
<body>
<table>
<tr>
<td class="noborder" style="font-size:12px;font-weight:bold">
Forkalkulation <?php echo $nummer;?> og kontraktgennemgang
</td>
</tr>
<tr>
<td colspan="4" style="font-size: 6pt;" class="noborder">
110/15-05-2008
</td>
</tr>
<tr>
<td class="noborder"> </td>
</tr>
</table>
<table cellpadding="0" cellspacing="0">
<?php
$sql = "SELECT r1, r9, r18 FROM ordre0 WHERE id = '".$_GET['id']."'";
$kb = mysql_query($sql) or die($sql);
$kuby = mysql_fetch_array($kb);
?>
<tr>
<td colspan="4" class="noborder">
<?php if($fl['dato'] != "0000-00-00") {
echo "Låst: ". $fl['alm_dato']. " af ".$fl['låst_af'];
}?>
</td>
<td colspan="2" class="noborder">
Dato: <?php echo date('d-m-y', time()); ?>
</td>
</tr>
<tr>
<td colspan="4" class="noborder">
Kunde: <?php echo $kuby[r9];?>
</td>
<td colspan="2" class="noborder">
Projektleder: <?php echo $kuby[r1];?>
</td>
</tr>
<tr>
<td colspan="4" class="noborder">
Sagsnavn: <?php echo $kuby[r18];?>
</td>
<td colspan="2" class="noborder">
Projektnr.: <?php echo $_GET['ordrenr']; ?>
</td>
</tr>
<tr>
<td width="10%" class="header2">Hovedakt.</td>
<td width="10%" class="header2">Underakt</td>
<td width="25%" class="header2">Beskrivelse/hovedakt.</td>
<td width="25%" class="header2">Beskrivelse/underakt.</td>
<td width="15%" class="header2">Kostpris</td>
<td width="15%" class="header2">Total/hovedakt.</td>
</tr>
<?php
$forrige_hakt="";
$be_hakt = "";
//$tæl_underakt =1;
for ($j=1;$j<=count($HOVEDAKT);$j++) {
$hov = substr($HOVEDAKT[$j]['nr'], 0, 1);
//echo $hov;
$antal_i_array = preg_grep('/^'.$hov.'.*/', $ua);
$aia = count($antal_i_array);
//echo "<br>";
//echo count($antal_i_array);
$hovedakt_nr = $HOVEDAKT[$j]['nr'];
$hovedakt_be = $HOVEDAKT[$j]['beskrivelse'];
//Total kostpris
$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 = '".$nummer."' AND ordre_id = '".$ordre_id."' AND SUBSTRING(underakt, 1, 1) = '".substr($hovedakt_nr, 0, 1)."' AND type = 0";
$t_kost = mysql_query($total_kostpris) or die($total_kostpris);
$t_k = mysql_fetch_array($t_kost);
if (!isset($t_k['total'])) {
$t_k['total'] = "-";
}
$tæl_underakt=1;//Tæl altid fra 1, når vi er ved en ny hovedakt.
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) {
// echo $tæl_underakt . " - " . $aia;
/*echo $tmp = "SELECT * FROM kalkulation AS k
LEFT JOIN kalkulationskolonner AS kk ON k.id = kk.kalkulations_id
LEFT JOIN kalkulationspriser AS kp ON kk.kostpris_id = kp.id
WHERE ordre_id = '".$ordre_id."' AND kp.kostpris != '0' AND type = '0'
AND kolonnenr = '".$nummer."' AND k.underakt = $underakt_nr";//type = 0 => kostpriser
*/
$tmp = "SELECT SUM(kostpris) AS kostpris FROM kalkulation AS k
LEFT JOIN kalkulationskolonner AS kk ON k.id = kk.kalkulations_id
LEFT JOIN kalkulationspriser AS kp ON kk.kostpris_id = kp.id
WHERE ordre_id = '".$ordre_id."' AND kp.kostpris != '0' AND type = '0'
AND kolonnenr = '".$nummer."' AND k.underakt = $underakt_nr
GROUP BY underakt";//type = 0 => kostpriser
$rtmp = mysql_query($tmp) or die($tmp);
if (!mysql_num_rows($rtmp) || !isset($rtmp)) {//Hvis der ingen kostpris er
echo "<tr>";
if ($forrige_hakt == $hovedakt_nr) {
echo "<td valign=\"top\"> </td>";
} else {
echo "<td valign=\"top\">".$hovedakt_nr."</td>";
}
echo "<td valign=\"top\">".$underakt_nr."</td>";
if ($be_hakt == $hovedakt_be) {
echo "<td valign=\"top\"> </td>";
} else {
echo "<td valign=\"top\">".$hovedakt_be."</td>";
}
echo "<td valign=\"top\">".$underakt_be."</td>";
echo "<td valign=\"top\" style=\"text-align:right\"> </td>";
if ($tæl_underakt == $aia) {
echo "<td style=\"text-align:right\">".number_format($t_k['total'],0,',','.')."</td>";
} else {
echo "<td style=\"text-align:right;\"><input name=\"spacer\" type=\"image\" src=\"/gfx/print_background.jpg\" width=\"97\" height=\"15\"></td>";
}
echo "</tr>\n";
$forrige_hakt = $hovedakt_nr;
$be_hakt = $hovedakt_be;
} else {
while ($rep = mysql_fetch_array($rtmp)){
echo "<tr>";
if ($forrige_hakt == $hovedakt_nr) {
echo "<td valign=\"top\"> </td>";
} else {
echo "<td valign=\"top\">".$hovedakt_nr."</td>";
}
echo "<td valign=\"top\">".$underakt_nr."</td>";
if ($be_hakt == $hovedakt_be) {
echo "<td valign=\"top\"> </td>";
} else {
echo "<td valign=\"top\">".$hovedakt_be."</td>";
}
echo "<td valign=\"top\">".$underakt_be."</td>";
echo "<td valign=\"top\" style=\"text-align:right\">".number_format($rep['kostpris'],0,',','.')."</td>";
if ($tæl_underakt == $aia) {
echo "<td style=\"text-align:right\">".$tæl_underakt . " - ".number_format($t_k['total'],0,',','.')."</td>";
} else {
echo "<td style=\"text-align:right;\"><input name=\"spacer\" type=\"image\" src=\"/gfx/print_background.jpg\" width=\"97\" height=\"14\" padding=\"0px\" margin=\"0px\"></td>";
}
echo "</tr>\n";
$forrige_hakt = $hovedakt_nr;
$be_hakt = $hovedakt_be;
}
}
$tæl_underakt++;
}
}
}
$sql = "SELECT SUM(kp.kostpris) AS kostpris FROM kalkulation AS k
LEFT JOIN kalkulationskolonner AS kk ON k.id = kk.kalkulations_id
LEFT JOIN kalkulationspriser AS kp ON kk.kostpris_id = kp.id
WHERE ordre_id = '".$ordre_id."' AND type = '0' AND kolonnenr = '".$nummer."'
GROUP BY ordre_id";
$res = mysql_query($sql) or die(mysql_error().$sql);
$ksum = mysql_fetch_array($res);
$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 = '".$nummer."' AND ordre_id = '".$ordre_id."' AND type = 1
GROUP BY ordre_id";
$lås_datos = mysql_query($låst_datos) or die(mysql_error);
$ssum = mysql_fetch_array($lås_datos);
?>
<tr>
<td colspan="4" style="text-align:right; vertical-align:top;">I alt kostpris kr.</td>
<td style="text-align:right"><?php echo number_format($ksum['kostpris'],0,',','.'); ?></td>
</tr>
<tr>
<td style="border-bottom: none; border-right: none;" colspan="4">Dækningsbidrag kr.</td>
<td style="border-bottom: none; border-left: none; text-align:right;"><?php echo number_format($ssum['salgspris']- $ksum['kostpris'],0,',','.');?></td>
</tr>
<tr>
<td style="border-bottom: none; border-right: none;" colspan="4">Salgspris kr.</td>
<td style="border-bottom: none; border-left: none; text-align:right;"><?php echo number_format($ssum['salgspris'],0,',','.'); ?></td>
</tr>
<tr>
<td style="border-bottom: none; border-right: none;" colspan="4">Dækningsgrad (% af salgspris)</td>
<td style="border-bottom: none; border-left: none; text-align:right;"><?php echo number_format(($ssum['salgspris'] - $ksum['kostpris'])/$ssum['salgspris']*100,2,',','.');?></td>
</tr>
<tr>
<td style="border-bottom: none; border-right: none;" colspan="5" height="30px;">Kontraktgennemgang udført</td>
</tr>
<tr>
<td style="border-right: none; border-top: none;" colspan="3"> </td>
<td class="small" colspan="1">(Sign. projektleder)</td>
<td class="small" style="border-right: solid 1px;" colspan="1">(Dato)</td>
</tr>
<tr>
<td colspan="6">Eventuelle bemærkninger:</td>
</tr>
</table>
<br>
<script language="JavaScript" type="text/javascript">
<!--
//window.print();
//setTimeout("window.close();",500);
//-->
</script>
</body>
</html>
require('system/global_defs.php');
include('system/date.php');
include('static/ordre12.php');
include('static/afsnit6.php');
?>
<html>
<head>
<style type="text/css">
@media print {
@page { size:21.0cm 29.7cm; }
@page { margin-left: 1cm; margin-right:0.8cm; margin-top:0.8cm; margin-bottom:0.8cm; }
@page :header { content: none ;}
@page :footer { content: none ;}
}
body, td {
font-family: Arial;
font-size: 9pt;
}
h1 {
font-size: 12pt;
}
.header {
font-weight: bold;
}
.header2 {
font-size: 9pt;
font-weight: bold;
vertical-align: top;
}
.small {
font-size: 6pt;
border-left: none;
border-right: none;
text-align: center;
}
.noborder {
border:none;
}
.footer {
font-size: 8pt;
border: none;
}
td {
border-collapse: collapse;
border: inset 1px;
}
</style>
<!--table{
border: outset 1px;
}
-->
</head>
<?php
$ua = array();
for ($qe=1;$qe<=count($UNDERAKT);$qe++) {
$ua[] = $UNDERAKT[$qe]['nr'];
}
$nummer = $_GET['forkalk'];
$ordre_id = $_GET['id'];
$lqs = "SELECT DATE_FORMAT(dato, '%d-%m-%Y') AS alm_dato, DATE(dato) AS dato, låst_af FROM kalkulation AS k LEFT JOIN kalkulationskolonner AS kk ON k.id = kk.kalkulations_id WHERE kolonnenr = '$nummer' AND ordre_id = '$ordre_id'";
$forlqs = mysql_query($lqs) or die($lqs);
$fl = mysql_fetch_array($forlqs);
?>
<body>
<table>
<tr>
<td class="noborder" style="font-size:12px;font-weight:bold">
Forkalkulation <?php echo $nummer;?> og kontraktgennemgang
</td>
</tr>
<tr>
<td colspan="4" style="font-size: 6pt;" class="noborder">
110/15-05-2008
</td>
</tr>
<tr>
<td class="noborder"> </td>
</tr>
</table>
<table cellpadding="0" cellspacing="0">
<?php
$sql = "SELECT r1, r9, r18 FROM ordre0 WHERE id = '".$_GET['id']."'";
$kb = mysql_query($sql) or die($sql);
$kuby = mysql_fetch_array($kb);
?>
<tr>
<td colspan="4" class="noborder">
<?php if($fl['dato'] != "0000-00-00") {
echo "Låst: ". $fl['alm_dato']. " af ".$fl['låst_af'];
}?>
</td>
<td colspan="2" class="noborder">
Dato: <?php echo date('d-m-y', time()); ?>
</td>
</tr>
<tr>
<td colspan="4" class="noborder">
Kunde: <?php echo $kuby[r9];?>
</td>
<td colspan="2" class="noborder">
Projektleder: <?php echo $kuby[r1];?>
</td>
</tr>
<tr>
<td colspan="4" class="noborder">
Sagsnavn: <?php echo $kuby[r18];?>
</td>
<td colspan="2" class="noborder">
Projektnr.: <?php echo $_GET['ordrenr']; ?>
</td>
</tr>
<tr>
<td width="10%" class="header2">Hovedakt.</td>
<td width="10%" class="header2">Underakt</td>
<td width="25%" class="header2">Beskrivelse/hovedakt.</td>
<td width="25%" class="header2">Beskrivelse/underakt.</td>
<td width="15%" class="header2">Kostpris</td>
<td width="15%" class="header2">Total/hovedakt.</td>
</tr>
<?php
$forrige_hakt="";
$be_hakt = "";
//$tæl_underakt =1;
for ($j=1;$j<=count($HOVEDAKT);$j++) {
$hov = substr($HOVEDAKT[$j]['nr'], 0, 1);
//echo $hov;
$antal_i_array = preg_grep('/^'.$hov.'.*/', $ua);
$aia = count($antal_i_array);
//echo "<br>";
//echo count($antal_i_array);
$hovedakt_nr = $HOVEDAKT[$j]['nr'];
$hovedakt_be = $HOVEDAKT[$j]['beskrivelse'];
//Total kostpris
$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 = '".$nummer."' AND ordre_id = '".$ordre_id."' AND SUBSTRING(underakt, 1, 1) = '".substr($hovedakt_nr, 0, 1)."' AND type = 0";
$t_kost = mysql_query($total_kostpris) or die($total_kostpris);
$t_k = mysql_fetch_array($t_kost);
if (!isset($t_k['total'])) {
$t_k['total'] = "-";
}
$tæl_underakt=1;//Tæl altid fra 1, når vi er ved en ny hovedakt.
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) {
// echo $tæl_underakt . " - " . $aia;
/*echo $tmp = "SELECT * FROM kalkulation AS k
LEFT JOIN kalkulationskolonner AS kk ON k.id = kk.kalkulations_id
LEFT JOIN kalkulationspriser AS kp ON kk.kostpris_id = kp.id
WHERE ordre_id = '".$ordre_id."' AND kp.kostpris != '0' AND type = '0'
AND kolonnenr = '".$nummer."' AND k.underakt = $underakt_nr";//type = 0 => kostpriser
*/
$tmp = "SELECT SUM(kostpris) AS kostpris FROM kalkulation AS k
LEFT JOIN kalkulationskolonner AS kk ON k.id = kk.kalkulations_id
LEFT JOIN kalkulationspriser AS kp ON kk.kostpris_id = kp.id
WHERE ordre_id = '".$ordre_id."' AND kp.kostpris != '0' AND type = '0'
AND kolonnenr = '".$nummer."' AND k.underakt = $underakt_nr
GROUP BY underakt";//type = 0 => kostpriser
$rtmp = mysql_query($tmp) or die($tmp);
if (!mysql_num_rows($rtmp) || !isset($rtmp)) {//Hvis der ingen kostpris er
echo "<tr>";
if ($forrige_hakt == $hovedakt_nr) {
echo "<td valign=\"top\"> </td>";
} else {
echo "<td valign=\"top\">".$hovedakt_nr."</td>";
}
echo "<td valign=\"top\">".$underakt_nr."</td>";
if ($be_hakt == $hovedakt_be) {
echo "<td valign=\"top\"> </td>";
} else {
echo "<td valign=\"top\">".$hovedakt_be."</td>";
}
echo "<td valign=\"top\">".$underakt_be."</td>";
echo "<td valign=\"top\" style=\"text-align:right\"> </td>";
if ($tæl_underakt == $aia) {
echo "<td style=\"text-align:right\">".number_format($t_k['total'],0,',','.')."</td>";
} else {
echo "<td style=\"text-align:right;\"><input name=\"spacer\" type=\"image\" src=\"/gfx/print_background.jpg\" width=\"97\" height=\"15\"></td>";
}
echo "</tr>\n";
$forrige_hakt = $hovedakt_nr;
$be_hakt = $hovedakt_be;
} else {
while ($rep = mysql_fetch_array($rtmp)){
echo "<tr>";
if ($forrige_hakt == $hovedakt_nr) {
echo "<td valign=\"top\"> </td>";
} else {
echo "<td valign=\"top\">".$hovedakt_nr."</td>";
}
echo "<td valign=\"top\">".$underakt_nr."</td>";
if ($be_hakt == $hovedakt_be) {
echo "<td valign=\"top\"> </td>";
} else {
echo "<td valign=\"top\">".$hovedakt_be."</td>";
}
echo "<td valign=\"top\">".$underakt_be."</td>";
echo "<td valign=\"top\" style=\"text-align:right\">".number_format($rep['kostpris'],0,',','.')."</td>";
if ($tæl_underakt == $aia) {
echo "<td style=\"text-align:right\">".$tæl_underakt . " - ".number_format($t_k['total'],0,',','.')."</td>";
} else {
echo "<td style=\"text-align:right;\"><input name=\"spacer\" type=\"image\" src=\"/gfx/print_background.jpg\" width=\"97\" height=\"14\" padding=\"0px\" margin=\"0px\"></td>";
}
echo "</tr>\n";
$forrige_hakt = $hovedakt_nr;
$be_hakt = $hovedakt_be;
}
}
$tæl_underakt++;
}
}
}
$sql = "SELECT SUM(kp.kostpris) AS kostpris FROM kalkulation AS k
LEFT JOIN kalkulationskolonner AS kk ON k.id = kk.kalkulations_id
LEFT JOIN kalkulationspriser AS kp ON kk.kostpris_id = kp.id
WHERE ordre_id = '".$ordre_id."' AND type = '0' AND kolonnenr = '".$nummer."'
GROUP BY ordre_id";
$res = mysql_query($sql) or die(mysql_error().$sql);
$ksum = mysql_fetch_array($res);
$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 = '".$nummer."' AND ordre_id = '".$ordre_id."' AND type = 1
GROUP BY ordre_id";
$lås_datos = mysql_query($låst_datos) or die(mysql_error);
$ssum = mysql_fetch_array($lås_datos);
?>
<tr>
<td colspan="4" style="text-align:right; vertical-align:top;">I alt kostpris kr.</td>
<td style="text-align:right"><?php echo number_format($ksum['kostpris'],0,',','.'); ?></td>
</tr>
<tr>
<td style="border-bottom: none; border-right: none;" colspan="4">Dækningsbidrag kr.</td>
<td style="border-bottom: none; border-left: none; text-align:right;"><?php echo number_format($ssum['salgspris']- $ksum['kostpris'],0,',','.');?></td>
</tr>
<tr>
<td style="border-bottom: none; border-right: none;" colspan="4">Salgspris kr.</td>
<td style="border-bottom: none; border-left: none; text-align:right;"><?php echo number_format($ssum['salgspris'],0,',','.'); ?></td>
</tr>
<tr>
<td style="border-bottom: none; border-right: none;" colspan="4">Dækningsgrad (% af salgspris)</td>
<td style="border-bottom: none; border-left: none; text-align:right;"><?php echo number_format(($ssum['salgspris'] - $ksum['kostpris'])/$ssum['salgspris']*100,2,',','.');?></td>
</tr>
<tr>
<td style="border-bottom: none; border-right: none;" colspan="5" height="30px;">Kontraktgennemgang udført</td>
</tr>
<tr>
<td style="border-right: none; border-top: none;" colspan="3"> </td>
<td class="small" colspan="1">(Sign. projektleder)</td>
<td class="small" style="border-right: solid 1px;" colspan="1">(Dato)</td>
</tr>
<tr>
<td colspan="6">Eventuelle bemærkninger:</td>
</tr>
</table>
<br>
<script language="JavaScript" type="text/javascript">
<!--
//window.print();
//setTimeout("window.close();",500);
//-->
</script>
</body>
</html>
Den kommer jeg så til fra en anden side, hvor man kan trykke på en knap:
<input class="submit" name="udskriv" type="button" value="Udskriv" onClick="launchUdskrift(<?php echo $æ;?>)"/>
<script language="javascript">
<!--
function launchUdskrift(nr) {
window.open('/entreprise_ordre12_udskriv_process.php?id=<?php echo $_GET['id']; ?>&ordrenr=<?php echo $nr; ?>&forkalk='+nr, '', '');
}
//-->
</script>
<script language="javascript">
<!--
function launchUdskrift(nr) {
window.open('/entreprise_ordre12_udskriv_process.php?id=<?php echo $_GET['id']; ?>&ordrenr=<?php echo $nr; ?>&forkalk='+nr, '', '');
}
//-->
</script>
Hvor og hvordan skal jeg refererer til stylen, så den træder i effekt?
