<perl>
###### Utskrift av giro, rev. 1.02 ######
if (!$su){ out "<center>Generering av giro er bare for kasserer!</center>";return} ;

if (!$dbName) {$dbName="veteran";$konv="0-10-4-5-8-15";}
$mdb=$dbName;

$a0="Navn";
$a1="Adresse";
$a2="Poststed";
$a3="Id";


#$mdb="giro";

$filename = $mdb =~ /\// ? substr $mdb, rindex $mdb, '/' : $mdb;
$filename =~ s/\W//g;

$filename=$filename."_blanketter";

# Header-Statements for csv-Files / mime-Type
$_header = "Content-type: text/comma-separatet-values\n\n";
$_header= "Content-disposition: attachment; filename=$filename.rtf\n\n";

&outrtf('{\rtf1\ansi\ansicpg1252\deff0\deflang1033\deflangfe1033\deftab709{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\fswiss\fprq2\fcharset0 Arial;}}
{\*\generator Msftedit 5.41.15.1507;}\paperw11906\paperh16838\margl1418\margr454\margt1984\margb567\viewkind1\uc1');



#nnnnnnnnnnnnnnnnnnnnnnnnn
$lower_case="";

@envList=split('\-',$konv);
foreach (@envList)
{
 get "Id==$_", "$mdb";
 if ($_loop{$a4} eq " ") {$_loop{$a4}="";}

  push @list1,"$_loop{$a0}|$_loop{$a1}|$_loop{$a2}|$_loop{$a3}";

}

@sorted = sort { normalize($a) cmp normalize($b)
          or normalize2($a) cmp normalize2($b)          
          or $a cmp $b 
          } @list1;

foreach $rec(@sorted)
 {
   @list2=split('\|',$rec);

   $Navn=$list2[0];
   $Adresse=$list2[1];
   $Poststed=$list2[2];
   $Id=$list2[3];


#nnnnnnnnnnnnnnnnnnnnnnnnn

$MEDLEMNR=1000 + $Id;
if ($Navn=~ m/†/){goto Dead;}

$ORIENTERING_1="Veteranklubben i Trondhjems Turnforening";
$ORIENTERING_2="Medlemskontingent 2008";
$ORIENTERING_3='Årsmøtet besluttet ingen kontingentendring for 2008.';
$ORIENTERING_4='\b0 Ved bruk av nett-bank \b PÅFØR ALLTID medlemsnr. \b0 i feltet \b Melding til mottaker!';
$TIL_KONTO="xxxx xx xxxxx";
$BELOP="150";
$ORE="00";
$FRA_KONTO="";
$BET_FRIST="2008-05-30";
$FRA_NAVN="$Navn";
$FRA_ADRESSE_1=$Adresse;
$FRA_ADRESSE_2=$Poststed;
$FRA_ADRESSE_3="";
$MELDING_TIL_ADRESSATEN="Fra medlem nr.: $MEDLEMNR<br>$FRA_NAVN";
$TIL_NAVN="Veteranklubben i Trondhjems Turnforening";
$TIL_ADRESSE_1="Arvid Osen";
$TIL_ADRESSE_2="Sigurd Einbusv. 5";
$TIL_ADRESSE_3="7036 Trondheim";



&outrtf('\secd\page\trowd\trgaph108\trleft-709\trrh-6237\trpaddl108\trpaddr108\trpaddfl3\trpaddfr3
\cellx9984\pard\intbl\nowidctlpar\ql\tqr\lang1044\b\f0\fs24\deftab709
\tab '.$FRA_NAVN.'\par
\tab '.$FRA_ADRESSE_1.'\par
\tab '.$FRA_ADRESSE_2.'\par\par\par
\qc\fs48 '.$ORIENTERING_1.'\fs28\par
\par
\fs44 '.$ORIENTERING_2.'\par
\par
\par
\fs24 '.$ORIENTERING_3.'\par
\par
\par
Med vennlig hilsen\par
\par
\b0 '.$TIL_ADRESSE_1.'\par
\b0 Kasserer\par
\pard\intbl\nowidctlpar\tqr\tx9356\tx9639\cell\row\trowd\trgaph108\trleft-709\trrh-1418\trpaddl108\trpaddr108\trpaddfl3\trpaddfr3
\clbrdrl\brdrw10\brdrs\clbrdrt\brdrw10\brdrs\clbrdrr\brdrw10\brdrs\clbrdrb\brdrw10\brdrs \cellx4678\clbrdrl\brdrw10\brdrs \cellx9984\pard\intbl\nowidctlpar\qj\f0\fs18\par
Ved bruk av brevgiro eller postgiro skal bare den nederste delen av blanketten sendes inn.  \'d8nskes kvittering m\'e5 det  krysses av i ruten \rdblquote Kvittering tilbake\rdblquote .  Dette gjelder ogs\'e5 ved bruk av nettbank.  Du f\'e5r da i retur en klebelapp med kvittering som kan festes p\'e5  den delen som beholdes.\par
\pard\intbl\nowidctlpar\sb120\f1\fs24\cell\fs18\par
\fs24 '.$ORIENTERING_4.'\par
\cell\row\trowd\trgaph108\trleft-709\trrh-852\trpaddl108\trpaddr108\trpaddfl3\trpaddfr3
\clbrdrt\brdrw10\brdrs \cellx3261\clbrdrt\brdrw10\brdrs \cellx4678\cellx5832\cellx9984\pard\intbl\nowidctlpar\sb120\cell\pard\intbl\nowidctlpar\ri175\sb120\qr\cell\pard\intbl\nowidctlpar\li-108\sb120\cell\pard\intbl\nowidctlpar\sb120\cell\row\trowd\trgaph108\trleft-709\trrh-703\trpaddl108\trpaddr108\trpaddfl3\trpaddfr3
\cellx3261\cellx4678\cellx5832\cellx9984\pard\intbl\nowidctlpar\sb120 '.$TIL_KONTO.'\cell\pard\intbl\nowidctlpar\ri175\sb120\qr '.$BELOP.'\cell\pard\intbl\nowidctlpar\li-108\sb120 '.$ORE.'\cell\pard\intbl\nowidctlpar\sb120\cell\row\trowd\trgaph108\trleft-709\trrh-360\trpaddl108\trpaddr108\trpaddfl3\trpaddfr3
\cellx8080\cellx9984\pard\intbl\nowidctlpar\cell '.$BET_FRIST.'\cell\row\trowd\trgaph108\trleft-709\trrh-1680\trpaddl108\trpaddr108\trpaddfl3\trpaddfr3
\cellx4290\cellx9984\pard\intbl\nowidctlpar '.$MELDING_TIL_ADRESSATEN.'\cell\cell\row\trowd\trgaph108\trleft-709\trrh-2220\trpaddl108\trpaddr108\trpaddfl3\trpaddfr3
\cellx5266\cellx9984\pard\intbl\nowidctlpar '.$FRA_NAVN.'\par
'.$FRA_ADRESSE_1.'\par
'.$FRA_ADRESSE_2.'\par
'.$FRA_ADRESSE_3.'\par
'.$FRA_ADRESSE_4.'\cell\pard\intbl\nowidctlpar\tx5387 '.$TIL_NAVN.'\par
v/'.$TIL_ADRESSE_1.'\par
'.$TIL_ADRESSE_2.'\par
'.$TIL_ADRESSE_3.'\par
'.$TIL_ADRESSE_4.'\par
\pard\intbl\nowidctlpar\cell\row\trowd\trgaph108\trleft-709\trrh-240\trpaddl108\trpaddr108\trpaddfl3\trpaddfr3
\cellx3000\cellx4621\cellx5812\cellx9984\pard\intbl\nowidctlpar\cell\pard\intbl\nowidctlpar\ri175\qr '.$BELOP.'\cell\pard\intbl\nowidctlpar '.$ORE.'\cell\pard\intbl\nowidctlpar\ri175\ql '.$TIL_KONTO.'\cell\row\pard\nowidctlpar\par
\secd\page
');


#out $_;
Dead:
}
out "}"; #------------- Avsluttende klammeparentes

#############################################################################
sub outrtf
{
$_ = $_[0];
$_ =~ s/<br>/\\line /g; ################ Erstatt <br> med \line #############
$_ =~ s/\'/\\'/g;       ################ Erstatt ' med \' gjelder Unicode####
$_ =~ "s/\\/\\\\/g";    ################ Erstatt (en) \ med (to) \\ #########
out $_; 
}
##########################################################################
sub normalize
{
  my $dslash="//";
  my $in = $_[0];

  if (!@list_lag){
  $in = substr ($in,0,rindex $in,'|');# Remove Id from the sorting string
  $in = substr ($in,0,rindex $in,'|')};# Remove Kontakt from the sorting string
  $in = lc($in);
#  $in =~ s/$dslash/a/g;
  $in =~ s/aa/å/g;
  $in =~ s/ß/ss/g;
  #$in =~ s/AA/£/g;
  #$in =~ s/Aa/£/g;
  #$in =~ s/Å/£/g;
  #$in =~ s/å/£/g;
  $in =~ tr</áéíóúüÁÉÍÓÚÜÆØÅÄäÖö>
           <aaeiouyaeiouyæøåææøø>;
  $in =~ tr<0123456789abcdefghijklmnopqrstuvwxyzæøå>
           <\x01-\x27>;
  # x27 = 39, for the 39 numbers + letters we now have
  
  return $in;
}
################################################################################
sub normalize2
{
  my $in = $_[0];

  $in =~ s/aa/£/g;
  $in =~ s/Aa/§/g;
  $in =~ s/AA/¶/g;
  $in =~ s/å/¤/g;
  $in =~ s/Å/*/g;
  $in =~ s/ä/%/g;
  $in =~ s/Ä/&/g;
  $in =~ s/ö/!/g;
  $in =~ s/Ö/?/g;

 if ($lower_case)
 {
  $in =~tr<aAbBcCdDeEfFgGhHiIjJkKlLmMnNoOpPqQrRsStTuUvVwWxXyYzZ%&æÆ!?øØ£§¶¤*>
          <12121212121212121212121212121212121212121212121212121234123412345>;
 }
else
 {
  $in =~tr<&%Ææ?!Øø¶§£*¤>
          <1234123412345>;
 }
  return $in;
}
##########################################################################

</perl>
