<perl>

############################################ export_excel.htx ###############################################
#out "DB=$dbName";

$_fn = substr $_link,0, (rindex $_link, '/');                #  Finn arbeidsmappe
$link="<a href=$_fn/download_script&mdb=$_link>download</a>";#  Link til nedlastingsscript
$ver="<font size='1'>TT (exporter_excel) ver. 2.01 $link, 2012-02-27, hbj</font>";

if($ex1)
{
get "Id==1", "export_excel";
$diff=$end-$start;
$start=$end+1;
$end=$end+$diff+1;
$pid=$valg
}

$start="0" if !$start;
$end="5999" if !$end;

if ($ex)
{
mod "Id==1",[start,$xStart,end,$xEnd,valg,$D1], "export_excel";
&export();
}
 
else
{

#$dbName=$mdb;
$pid="styret1";
$slected="<option value=log selected>Transaksjonslogg</option>";
get "Id=0", "semester";

if (!$D1)
{
get "Database==$pid", $Partier, "temp1";
$D2=$Parti;
$D1=$Database;
}

$D1=$pid if $pid;

$pid=$D1 if $D1;
#$pid="styret1";#################################

#get "Database==$pid sort=Postert", $Partier;
get "Database==$valg", $Partier;
$VALG=$Parti;

out <<EOF;
<style>
body { font-family:Arial,Helvetica,sans-serif; background-color:#CCFFFF; font-size:10px; color:#000000; }
.Titel { font-size:20px; color:#000000; }
.Text { font-family:Arial,Helvetica,sans-serif; font-size:10px; color:#000000; }
.Einleitung { font-family:Arial,Helvetica,sans-serif; font-size:10px; color:#000000; }
</style>

<head><title>TT - Last ned til Excel</title></head>
<!body bgcolor=ffffff>
<body bgcolor=ccffff link="blue" vlink="blue">
<div style="border-style: solid; border-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px">
$ver
<font face=arial,helvetica>
<font size=1><span class="Einleitung"></span></font>
<p align="center"><font size="5" face="Arial"><b>Trondhjems Turnforenings p&aring;meldings- og betalingssystem</b></font><br><br>
<h3>$heading</h3>
<font size="3">
<center><font size="4"><b>Last ned til Excel</b></font></center><p>

<p>
<!--font size="2" face="arial,helvetica">
<a onclick="history.go(-1)" href="#">Tilbake</a></font-->

EOF

get "Id==* sort=Parti", $Partier;
while (get_next $Partier)
{
if ($Aktiv)
{
$partinavn[$h]=$Parti;
$parti[$h]=$Database;
$opt=$opt."<option value=$parti[$h]>$partinavn[$h]</option>";
$h++;


}}


out<<EOF;
<center>
<form method="POST" action=$_link&ex=ex&su=1 enctype="multipart/form-data">
	<p><select size="1" name="D1" size="30">
	$opt
	<option value=log>Transaksjonslogg</option>
	<option value=$valg selected>$VALG</option>
	<option value=giro_log>Girologg</option>
	</select></p>

	Fra Id-nr.: <input type="text" name="xStart" value="$start" size="4">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
	Til Id-nr.: <input type="text" name="xEnd" value="$end" size="4">
	<p><input type="submit" value="Last ned">
	<!input type="reset" value="   Reset   ">
	<input type="button" value=" Fortsett " onClick="window.location='http://baseportal.de/cgi-bin/baseportal.pl?htx=/turn/pm/export_excel&ex1=1'"></p>

</form>
</center>
EOF
}
##########################################################################
sub export
{
if ($su)
{
$xStart--;
$xEnd++;
$dbName=$D1;
init $dbName;
$mdb=$dbName;

$sep="\t" if $sep eq "";
$sep="\t" if $sep eq "tab";
$sep=";";



$filename = $mdb =~ /\// ? substr $mdb, rindex $mdb, '/' : $mdb;
$filename =~ s/\W//g;
# Header-Statements for csv-Files / mime-Type
$_header = "Content-type: text/comma-separatet-values\n";
$_header= "Content-disposition: attachment;filename=$filename.csv\n\n";

$x1='"';

 get "Id=*", "$mdb.fields", "fields";

 while (get_next("fields"))
 {
 push @f, $Field;
 }
 #shift @f; # Removes Id from listing
# pop @f;   # Removes Photo from listing
# pop @f;   # Removes Password from listing
 foreach $x (@f)
 {

  out $x1,$x,$x1,$sep;
 }

 out "\n";

 get "Id>$xStart && Id<$xEnd","$mdb";
 while(get_next($mdb)) 
 {

foreach (@f)
  {
   #${$_} = convert_html(${$_});
   $_loop{$_} = convert_br($_loop{$_});# Same as: $_loop{$_} =~ s/\n/<br>/g;
   out $x1,$_loop{$_},$x1,$sep;
  } 
  out "\n";
 }

}
else {
out "<center><b>Ikke tillatt for denne bruker!</b></center>";
}
}
##########################################################################
</perl>