// GNU General Public Licensen for flere detaljer.
//
// En dansk oversaettelse af licensen kan laeses her:
// http://www.fundanemt.com/gpl_da.html
//
// Copyright (c) 2004-2008 DANOSOFT ApS
// ----------------------------------------------------------------------
# SKAL OMSKRIVES TIL IMPORT AF SKABELONER og ikke overskrivning med standardskabeloner
include "../includes/connect.php";
include "../includes/online.php";
include "../includes/db_query.php";
include "../includes/formularimport.php";
if ($_POST) {
if ($_POST['ok']) {
db_modify("delete from formularer");
formularimport("../importfiler/formular.txt");
db_modify("update formularer set sprog = 'Dansk'");
print "<div style=\"text-align: center;\">{$font}<small>Import succesfuld - vindue lukkes</small></font><br></div>";
print "<meta http-equiv=\"refresh\" content=\"3;URL=../includes/luk.php\">";
exit;
} else {
print "<meta http-equiv=\"refresh\" content=\"0;URL=../includes/luk.php\">";
exit;
}
} else {
print "<form name=formularimport action={$_SERVER['PHP_SELF']} method=\"post\">";
print "<div style=\"text-align: center;\">{$font}<small>Dette vil overskrive alle eksisterende formularer med standardopsætningen<br>";
print "<div style=\"text-align: center;\">{$font} og slette formularer med andet sprog end dansk<br>";
print "Klik på [OK] for at fortsætte<br><br>";
print "<input type=submit value=\"Afbryd\" name=\"afbryd\"> <input type=submit value=\"OK\" name=\"ok\">";
print "</small></font></div></form>";
} elseif ($valg == 'Pos') {
$art = 10;
} elseif ($valg == 'Kontokort') {
$art = 11;
} elseif ($valg == 'Indkøbsforslag') {
$art = 12;
} elseif ($valg == 'Rekvisition') {
$art = 13;
} elseif ($valg == 'Købsfaktura') {
$art = 14;
} else {
$art = NULL;
}
if ($art) {
db_modify("delete from formularer where art = '{$art}'");
formularimport("../importfiler/formular.txt", $art);
db_modify("update formularer set sprog = 'Dansk' where art = '{$art}'");
}
}
print "<div style=\"text-align: center;\">{$font}<small>Overskrivning med standardformularer succesfuld - vinduet lukkes</small></font><br></div>";
print "<meta http-equiv=\"refresh\" content=\"3;URL=../systemdata/formularkort.php\">";
exit;
} elseif ($_POST['afbryd']) {
print "<meta http-equiv=\"refresh\" content=\"3;URL=../systemdata/formularkort.php\">";
exit;
} else {
print "<form name=formularimport action={$_SERVER['PHP_SELF']} method=\"post\">";
print "<div style=\"text-align: center;\">{$font}<small>Dette vil overskrive den valgte danske formular med standardopsætningen<br>";
print "<div style=\"text-align: center;\">{$font}<small>\"Alle\" overskriver alle formularer og sletter formularer på andre sprog end dansk<br>";
print "<div style=\"text-align: center;\">{$font} og slette formularer på andre sprog end dansk.<br>";
print "<input type=\"submit\" style=\"width:150px\" value=\"Afbryd\" name=\"afbryd\"><br><br>\n\t\t<input type=\"submit\" style=\"width:150px\" value=\"Tilbud\" name=\"valg\"><br><br>\n\t\t<input type=\"submit\" style=\"width:150px\" value=\"Ordrebekræftelse\" name=\"valg\"><br><br>\n\t\t<input type=\"submit\" style=\"width:150px\" value=\"Følgeseddel\" name=\"valg\"><br><br>\n\t\t<input type=\"submit\" style=\"width:150px\" value=\"Faktura\" name=\"valg\"><br><br>\n\t<input type=\"submit\" style=\"width:150px\" value=\"Kreditnota\" name=\"valg\"><br><br>\n\t<input type=\"submit\" style=\"width:150px\" value=\"Rykker_1\" name=\"valg\"><br><br>\n\t<input type=\"submit\" style=\"width:150px\" value=\"Rykker_2\" name=\"valg\"><br><br>\n\t<input type=\"submit\" style=\"width:150px\" value=\"Rykker_3\" name=\"valg\"><br><br>\n\t<input type=\"submit\" style=\"width:150px\" value=\"Plukliste\" name=\"valg\"><br><br>\n\t<input type=\"submit\" style=\"width:150px\" value=\"Kontokort\" name=\"valg\"><br><br>\n\t<input type=\"submit\" style=\"width:150px\" value=\"Indkøbsforslag\" name=\"valg\"><br><br>\n\t<input type=\"submit\" style=\"width:150px\" value=\"Rekvisition\" name=\"valg\"><br><br>\n\t<input type=\"submit\" style=\"width:150px\" value=\"Købsfaktura\" name=\"valg\"><br><br>\n\t<input type=\"submit\" style=\"width:150px\" value=\"Alle\" name=\"valg\"><br><br>";
print "<tr><td height = \"25\" align=\"center\" valign=\"top\">";
print "<table width=\"100%\" align=\"center\" border=\"0\" cellspacing=\"2\" cellpadding=\"0\"><tbody>";
#if ($popup) print "<td width=\"10%\" $top_bund><a href=../includes/luk.php accesskey=L>Luk</a></td>";
# else
print "<td width=\"10%\" {$top_bund}><a href=diverse.php?sektion=div_io accesskey=L>Luk</a></td>";
print "<td width=\"80%\" {$top_bund}>{$title}</td>";
print "<td width=\"10%\" {$top_bund}><br></td>";
print "</tbody></table>";
print "</td></tr>";
if ($_POST) {
$submit = $_POST['submit'];
$filnavn = $_POST['filnavn'];
if (basename($_FILES['uploadedfile']['name'])) {
$filnavn = "../temp/" . $db . "_" . str_replace(" ", "_", $brugernavn) . ".csv";
if (move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $filnavn)) {
formularimport("{$filnavn}");
} else {
echo "Der er sket en fejl under hentningen, prøv venligst igen";
}
# db_modify("update formularer set sprog = 'Dansk'");
if ($popup) {
print "<div style=\"text-align: center;\">Formularimport succesfuld - vinduet lukkes<br></div>";
print "<meta http-equiv=\"refresh\" content=\"3;URL=../includes/luk.php\">";
exit;
} else {
print "<BODY onLoad=\"JavaScript:alert('Formularimport succesfuld')\">";
}
} else {
print "<meta http-equiv=\"refresh\" content=\"0;URL=../includes/luk.php\">";
exit;
}
$dato_til = if_isset($_GET['dato_til']);
$kontoart = if_isset($_GET['kontoart']);
$dato_fra ? $dato_fra = usdate($dato_fra) : ($dato_fra = "1970-01-01");
$dato_til = usdate($dato_til);
$formular = 11;
$fsize = filesize("../includes/faktinit.ps");
$fp = fopen("../includes/faktinit.ps", "r");
$initext = fread($fp, $fsize);
fclose($fp);
if (!$formularsprog) {
$formularsprog = 'dansk';
}
$r = db_fetch_array(db_select("select count(id) as antal from formularer where formular = '{$formular}' and lower(sprog)='{$formularsprog}'", __FILE__ . " linje " . __LINE__));
if ($r['antal'] < 5) {
include "../includes/formularimport.php";
formularimport("../importfiler/formular.txt", '11');
}
print "<!-- kommentar for at skjule uddata til siden \n";
if (!file_exists("../logolib/{$db_id}")) {
mkdir("../logolib/{$db_id}");
}
if (file_exists("../logolib/{$db_id}/bg.pdf")) {
if (system("which pdftk")) {
$logoart = 'PDF';
} else {
print "<BODY onLoad=\"JavaScript:alert('pdftk ikke fundet, PDF kan ikke anvendes som baggrund');\">";
}
} elseif (file_exists("../logolib/{$db_id}/{$formular}.ps")) {
$logo = "../logolib/{$db_id}/{$formular}.ps";
$logoart = 'PS';
} elseif (file_exists("../logolib/{$db_id}/bg.ps")) {
function opret($sqhost, $squser, $sqpass, $db, $brugernavn, $passwd, $std_kto_plan)
{
global $connection;
global $version;
global $db_id;
global $regnskab;
global $fra_formular;
global $db_encode;
global $db_type;
global $sqdb;
if ($fra_formular) {
global $kontakt;
global $firmanavn;
global $addr1;
global $addr2;
global $postnr;
global $bynavn;
global $tlf;
global $email;
global $cvrnr;
}
if ($db_type == "mysql") {
db_modify("CREATE DATABASE {$db}", __FILE__ . " linje " . __LINE__);
mysql_select_db("{$db}");
if ($db_encode == "UTF8") {
db_modify("SET character_set_client = 'UTF8'", __FILE__ . " linje " . __LINE__);
} else {
db_modify("SET character_set_client = 'LATIN1'", __FILE__ . " linje " . __LINE__);
}
} else {
if ($db_encode == "UTF8") {
db_modify("CREATE DATABASE {$db} with encoding = 'UTF8'", __FILE__ . " linje " . __LINE__);
} else {
db_modify("CREATE DATABASE {$db} with encoding = 'LATIN9'", __FILE__ . " linje " . __LINE__);
}
db_close($connection);
$connection = db_connect("{$sqhost}", "{$squser}", "{$sqpass}", "{$db}", __FILE__ . " linje " . __LINE__);
}
transaktion("begin");
# db_modify("CREATE SEQUENCE id START 1 INCREMENT 1 MAXVALUE 9223372036854775807 MINVALUE 1 CACHE 1",__FILE__ . " linje " . __LINE__);
######## Adresser ##########
db_modify("CREATE TABLE adresser (id serial NOT NULL,firmanavn text,addr1 text,addr2 text,postnr text,bynavn text,land text,kontakt text,tlf text,fax text,email text,web text,bank_navn text,bank_reg text,bank_konto text,bank_fi text,erh text,swift text,notes text,rabat numeric(15,3),momskonto integer,kreditmax numeric(15,3),betalingsbet text,betalingsdage integer DEFAULT 0,kontonr text,cvrnr text,ean text,institution text,art varchar(2),gruppe integer,rabatgruppe integer,kontoansvarlig integer,oprettet date,kontaktet date,kontaktes date,pbs varchar(2),pbs_nr text,pbs_date date,mailfakt varchar(2),udskriv_til varchar(10),felt_1 text,felt_2 text,felt_3 text,felt_4 text,felt_5 text,vis_lev_addr varchar(2),kontotype text,fornavn text,efternavn text,lev_firmanavn text,lev_fornavn text,lev_efternavn text,lev_addr1 text,lev_addr2 text,lev_postnr text,lev_bynavn text,lev_land text,lev_kontakt text,lev_tlf text,lev_email text,status text,lukket varchar(2),kategori text,saldo numeric(15,3),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE ansatte (id serial NOT NULL,konto_id integer,navn text,addr1 text,addr2 text,postnr text,bynavn text,tlf text,fax text,mobil text,privattlf text,initialer text,email text,notes text,cprnr text,posnr integer,afd integer,provision numeric(15,3),nummer integer,loen numeric(15,3),hold integer,lukket varchar(2),bank text,startdate date,slutdate date,gruppe numeric(15,3),extraloen numeric(15,3),trainee text,password text,overtid numeric(1,0),sag_id integer,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE crm (id serial NOT NULL,konto_id int,kontakt_id int,ansat_id int,notat text,notedate date,spor text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE brugere(id serial NOT NULL,brugernavn text,kode text,tmp_kode text,status boolean,regnskabsaar integer,rettigheder text,ansat_id integer,sprog_id integer,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE grupper (id serial NOT NULL,beskrivelse text,kode text,kodenr text,art text,box1 text,box2 text,box3 text,box4 text,box5 text,box6 text,box7 text,box8 text,box9 text,box10 text,box11 text,box12 text,box13 text,box14 text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
######## Kassekladde ########
db_modify("CREATE TABLE kassekladde (id serial NOT NULL,bilag integer,transdate date,beskrivelse text,d_type varchar(1),debet numeric(15,0),k_type varchar(1),kredit numeric(15,0),faktura text,amount numeric(15,3),kladde_id integer,momsfri varchar(2),medarb integer,ansat text,afd integer,projekt text,valuta integer,valutakurs numeric(15,3),ordre_id integer,forfaldsdate date,betal_id text,dokument text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE tmpkassekl (id integer,lobenr integer,bilag text,transdate text,beskrivelse text,d_type text,debet text,k_type text,kredit text,faktura text,amount text,kladde_id integer,momsfri text,afd text,projekt text,ansat text,valuta text,valutakurs text,forfaldsdate text,betal_id text,dokument text)", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE kladdeliste (id serial NOT NULL,kladdedate date,bogforingsdate date,kladdenote text,bogfort varchar(2),oprettet_af text,bogfort_af text,hvem text,tidspkt text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE kontoplan (id serial NOT NULL,kontonr numeric(15,0),beskrivelse text,kontotype varchar(1),moms text,fra_kto numeric(15,0),til_kto numeric(15,0),lukket varchar(2),primo numeric(15,3),saldo numeric(15,3),regnskabsaar integer,genvej varchar(2),overfor_til numeric(15,0),anvendelse text,modkonto numeric(15,0),valuta integer,valutakurs numeric(15,4),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE kontokort (id serial NOT NULL,ref_id integer,faktnr integer,refnr integer,beskrivelse text,kredit numeric(15,0),debet numeric(15,0),transdate date,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE ordrer (id serial NOT NULL,konto_id integer,firmanavn text,addr1 text,addr2 text,postnr text,bynavn text,land text,kontakt text,email text,mail_fakt varchar(2),udskriv_til varchar(10),kundeordnr text,lev_navn text,lev_addr1 text,\tlev_addr2 text,lev_postnr text,lev_bynavn text,lev_kontakt text,ean text,institution text,betalingsbet text,betalingsdage integer,kontonr text,cvrnr text,art varchar(2),valuta text,valutakurs numeric(15,3),sprog text,projekt text,ordredate date,levdate date,fakturadate date,notes text,ordrenr integer,sum numeric(15,3),momssats numeric(15,3),status integer,ref text,fakturanr text,modtagelse integer,kred_ord_id integer,lev_adr text,kostpris numeric(15,3),moms numeric(15,3),hvem text,tidspkt text,betalt text,nextfakt date,pbs varchar(2),mail varchar(2),mail_cc text,mail_bcc text,mail_subj text,mail_text text,felt_1 text,felt_2 text,felt_3 text,felt_4 text,felt_5 text,vis_lev_addr varchar(2),restordre numeric(2,0),betalings_id text,sag_id integer,tilbudnr numeric(15,0),datotid text,nr numeric(15,0),returside text,sagsnr numeric(15,0),dokument text,procenttillag numeric(15,3),mail_bilag varchar(2),omvbet varchar(2),afd integer,kontakt_tlf text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE ordrelinjer (id serial NOT NULL,varenr text,beskrivelse text,enhed text,posnr integer,pris numeric(15,3),rabat numeric(15,3),lev_varenr text,ordre_id integer,serienr text,vare_id integer,antal numeric(15,3),leveres numeric(15,3),leveret numeric(15,3),bogf_konto integer,oprettet_af text,bogfort_af text,hvem text,tidspkt text,kred_linje_id integer,momsfri varchar(2),momssats numeric(15,3),kostpris numeric(15,3),samlevare varchar(2),projekt text,m_rabat numeric(15,3),rabatgruppe integer,folgevare integer,kdo varchar(2),rabatart varchar(10),variant_id text,procent numeric(15,3),omvbet varchar(2),saet integer,fast_db numeric(15,3),afd integer,lager integer,tilfravalg text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE ordretekster (id serial NOT NULL,tekst text,sort numeric(15,0),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE openpost (id serial NOT NULL,konto_id integer,konto_nr text,faktnr text,amount numeric(15,3),refnr integer,beskrivelse text,udlignet varchar(2),transdate date,uxtid text,kladde_id integer,bilag_id integer,udlign_id integer,udlign_date date,valuta text,projekt text,valutakurs numeric(15,3),forfaldsdate date,betal_id text,betalings_id text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE transaktioner (id serial NOT NULL,kontonr numeric(15,0),bilag numeric(15,0),transdate date,logtime time,beskrivelse text,debet numeric(15,3),kredit numeric(15,3),faktura text,kladde_id integer,projekt text,ansat numeric(15,0),logdate date,afd integer,ordre_id integer,valuta text,valutakurs numeric(15,3),moms numeric(15,3),adresser_id int4,kasse_nr numeric(15,0),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE simulering (id serial NOT NULL,kontonr numeric(15,0),bilag numeric(15,0),transdate date,beskrivelse text,debet numeric(15,3),kredit numeric(15,3),faktura text,kladde_id int4,projekt text,ansat numeric(15,0),logdate date,logtime time,afd int4,ordre_id int4,valuta text,valutakurs numeric(15,3),moms numeric(15,3),adresser_id int4,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE varer (id serial NOT NULL,varenr text,stregkode text,beskrivelse text,enhed text,enhed2 text,indhold numeric(15,3),forhold numeric(15,3),gruppe text,salgspris numeric(15,3),kostpris numeric(15,3),provisionsfri varchar(2),notes text,lukket varchar(2),serienr text,beholdning numeric(15,3),samlevare varchar(2),delvare varchar(2),min_lager numeric(15,3),max_lager numeric(15,3), trademark text,location text,retail_price numeric(15,3),special_price numeric(15,3),campaign_cost numeric(15,3),tier_price numeric(15,3),open_colli_price numeric(15,3),colli numeric(15,3),outer_colli numeric(15,3),outer_colli_price numeric(15,3),special_from_date date,special_to_date date,special_from_time time,special_to_time time,komplementaer text,circulate integer,operation integer,prisgruppe integer,tilbudgruppe integer,rabatgruppe integer,dvrg integer,m_type varchar(10),m_rabat text,m_antal text,folgevare text,kategori text,varianter text,publiceret varchar(2),fotonavn text,tilbudsdage text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE lagerstatus (id serial NOT NULL,lager integer,vare_id integer,beholdning numeric(15,3),lok1 text,lok2 text,lok3 text,lok4 text,lok5 text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE batch_kob (id serial NOT NULL,kobsdate date,fakturadate date,vare_id integer,linje_id integer,ordre_id integer,pris numeric(15,3),antal numeric(15,3),rest numeric(15,3),lager integer,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE batch_salg (id serial NOT NULL,salgsdate date,fakturadate date,batch_kob_id integer,vare_id integer,linje_id integer,ordre_id integer,pris numeric(15,3),antal numeric(15,3),lev_nr integer,lager integer,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE serienr (id serial NOT NULL,vare_id integer,kobslinje_id integer,salgslinje_id integer,batch_kob_id integer,batch_salg_id integer,serienr text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE styklister (id serial NOT NULL,vare_id integer,indgaar_i integer,antal numeric(15,3),posnr integer,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE enheder (id serial NOT NULL,betegnelse text,beskrivelse text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE materialer (id serial NOT NULL,beskrivelse text,densitet numeric(15,3),materialenr text,tykkelse numeric(15,3),kgpris numeric(15,3),avance numeric(15,3),enhed text,opdat_date date,opdat_time time,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE vare_lev (id serial NOT NULL,posnr integer,lev_id integer,vare_id integer,lev_varenr text,kostpris numeric(15,3),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE reservation (linje_id integer,batch_kob_id integer,batch_salg_id integer,vare_id integer,antal numeric(15,3),lager integer)", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE formularer (id serial NOT NULL,formular integer,art integer,beskrivelse text,justering text,xa numeric(15,3),ya numeric(15,3),xb numeric(15,3),yb numeric(15,3),str numeric(15,3),color integer,font text,fed varchar(2),kursiv varchar(2),side varchar(2),sprog text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE provision (id serial NOT NULL,gruppe_id integer,ansat_id integer,provision numeric(15,3),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE historik (id serial NOT NULL,konto_id int,kontakt_id int,ansat_id int,notat text,notedate date,kontaktet date,kontaktes date,dokument text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE valuta (id serial NOT NULL,gruppe integer,valdate date,kurs numeric(15,3),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE betalingsliste (id serial NOT NULL,listedate date,udskriftsdate date,listenote text,bogfort varchar(2),oprettet_af text,bogfort_af text,hvem text,tidspkt text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE betalinger (id serial NOT NULL,bet_type text,fra_kto text,egen_ref text,til_kto text,modt_navn text,belob text,betalingsdato text,valuta text,kort_ref text,kvittering text,ordre_id integer,bilag_id integer,liste_id integer,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE tidsreg (id serial NOT NULL,person integer,ordre integer,pnummer integer,operation integer,materiale integer,tykkelse numeric(15,3),laengde numeric(15,3),bredde numeric(15,3),antal_plader numeric(15,3), gaa_hjem integer,tid integer,forbrugt_tid integer,opsummeret_tid integer,beregnet integer,pause integer,antal numeric(15,3), faerdig integer,circ_time integer,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE tabeller (id serial NOT NULL,person integer,ordre integer,pnummer integer,\toperation integer,materiale integer,tykkelse numeric(15,3),laengde numeric(15,3),bredde numeric(15,3),antal_plader numeric(15,3), gaa_hjem integer,tid integer,forbrugt_tid integer,opsummeret_tid integer,beregnet integer,pause integer,antal numeric(15,3), faerdig integer,circ_time integer,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE tekster (id serial NOT NULL,sprog_id integer,tekst_id integer,tekst text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE varetekster (id serial NOT NULL,sprog_id integer,vare_id integer,tekst text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE jobkort (id serial NOT NULL,konto_id integer,ordre_id integer,kontonr text,firmanavn text,addr1 text,addr2 text,postnr text,bynavn text,kontakt text,tlf text,initdate date,oprettet_af text,startdate date,slutdate date,hvem text,tidspkt text,felt_1 text,felt_2 text,felt_3 text,felt_4 text,felt_5 text,felt_6 text,felt_7 text,felt_8 text,felt_9 text,felt_10 text,felt_11 text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE jobkort_felter (id serial NOT NULL,job_id integer,art text,feltnr integer,subnr integer,feltnavn text,indhold text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE modtageliste (id serial NOT NULL,initdate date,modtagdate date,modtagnote text,modtaget text,init_af text,modtaget_af text,hvem text,tidspkt text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE modtagelser (id serial NOT NULL,varenr text,beskrivelse text,leveres numeric(15,3),liste_id integer,lager numeric(15,3),ordre_id integer,vare_id integer,antal numeric(15,3),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE pbs_kunder(id serial NOT NULL,konto_id integer,kontonr varchar(20),pbs_nr text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE pbs_liste(id serial NOT NULL,liste_date date,afsendt varchar(8),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE pbs_ordrer(id serial NOT NULL,liste_id integer,ordre_id integer,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE pos_betalinger (id serial NOT NULL,ordre_id integer,betalingstype text,amount numeric(15,3),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE pbs_linjer(id serial NOT NULL,liste_id integer,linje text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE budget (id serial NOT NULL,regnaar integer,md integer, kontonr numeric(15,0),amount numeric(15,0),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE rabat(id serial NOT NULL,rabat numeric(6,2),debitorart varchar(2),debitor int,vareart varchar(2),vare int,rabatart varchar(6),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE pos_buttons (id serial NOT NULL,menu_id integer,col numeric(2,0),row numeric(2,0),colspan numeric(1,0),rowspan numeric(1,0),beskrivelse text,vare_id numeric(10,0),funktion numeric(1,0),color varchar(6),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE regulering (id serial NOT NULL,vare_id integer, variant_id integer,lager integer,beholdning numeric(15,3),optalt numeric(15,3),tidspkt text,bogfort bool,transdate date,logtime time,bogfort_af text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE navigator (bruger_id integer,session_id text,side text,returside text,konto_id integer,ordre_id integer,vare_id integer)", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE kostpriser (id serial NOT NULL,vare_id integer,transdate date,kostpris numeric(15,3),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE sager (id serial NOT NULL,konto_id integer,firmanavn text,addr1 text,addr2 text,postnr text,bynavn text,land text,kontakt text,email text,beskrivelse text,omfang text,ref text,udf_firmanavn text,udf_addr1 text,udf_addr2 text,udf_postnr text,udf_bynavn text,udf_kontakt text,status text,tidspkt text,hvem text,oprettet_af text,kunde_ref text,planfraop text,plantilop text,planfraned text,plantilned text,beregn_opret text,beregn_tilbud text,beregner text,beregn_beskrivelse text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE bilag (id serial NOT NULL,navn text,beskrivelse text,datotid text,hvem text,assign_to text,assign_id int,fase numeric(15,3),kategori text,filtype text,bilag_fase text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE noter (id serial NOT NULL,notat text,beskrivelse text,datotid text,hvem text,besked_til text,assign_to text,assign_id integer,status integer,fase numeric(15,3),notat_fase text,kategori text,nr numeric(15,0),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE tjekliste (id serial NOT NULL,tjekpunkt text,fase numeric(15,3),assign_to text,assign_id integer,sagsnr text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE tjekpunkter (id serial NOT NULL,tjekliste_id integer,assign_id integer,status integer,status_tekst text,tjekskema_id integer,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE sagstekster (id serial NOT NULL,tekstnr numeric(15,0),beskrivelse text,tekst text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE loen (id serial NOT NULL,nummer numeric(15,0),kategori integer,loendate date,sag_id integer, sag_nr numeric(15,0),tekst text,ansatte text,fordeling text,timer text,t50pct text,t100pct text,hvem text,oprettet text,afsluttet text,godkendt text,sum numeric(15,3),oprettet_af text,afsluttet_af text,godkendt_af text,master_id integer,loen text,afvist text,afvist_af text,udbetalt text,art text,skur text,datoer text,afregnet text,afregnet_af text,korsel text,opg_id integer,opg_nr integer,afvist_pga text,sag_ref text,feriefra text,ferietil text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE loen_enheder (id serial NOT NULL,loen_id integer,vare_id integer,op numeric(15,3),ned numeric(15,3),tekst text,pris_op numeric(15,3),pris_ned numeric(15,3),op_25 numeric(15,3),ned_25 numeric(15,3),op_30m numeric(15,3),ned_30m numeric(15,3),op_40 numeric(15,3),ned_40 numeric(15,3),op_60 numeric(15,3),ned_60 numeric(15,3),op_tag numeric(15,3),ned_tag numeric(15,3),varenr text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE opgaver (id serial NOT NULL,assign_id integer,assign_to text,nr numeric(15,0),beskrivelse text,omfang text,ref text,status text,tidspkt text,hvem text,oprettet_af text,kunde_ref text,opg_planfra text,opg_plantil text,opg_tilknyttil text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE tjekskema (id serial NOT NULL,tjekliste_id integer,datotid text,opg_art text,sjak text,sag_id integer,hvem text,man_trans text,stillads_til text,opg_navn text,opg_beskrivelse text,sjakid text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE mappe (id serial NOT NULL,beskrivelse text,sort numeric(15,0),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE mappebilag (id serial NOT NULL,navn text,beskrivelse text,datotid text,hvem text,assign_to text,assign_id int4,filtype text,sort numeric(15,0),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE ansatmappe (id serial NOT NULL,beskrivelse text,ans_id int4,sort numeric(15,0),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE ansatmappebilag (id serial NOT NULL,navn text,beskrivelse text,datotid text,hvem text,assign_to text,assign_id int4,filtype text,sort numeric(15,0),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE shop_adresser (id serial NOT NULL,saldi_id integer,shop_id integer,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE shop_varer (id serial NOT NULL,saldi_id integer,shop_id integer,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE shop_ordrer (id serial NOT NULL,saldi_id integer,shop_id integer,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE varianter (id serial NOT NULL,beskrivelse text,shop_id integer,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE variant_typer (id serial NOT NULL,variant_id integer,shop_id integer,beskrivelse text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE variant_varer (id serial NOT NULL,vare_id integer,variant_type text,variant_beholdning numeric(15,3),variant_stregkode text,lager integer,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE varetilbud (id serial NOT NULL,vare_id integer,startdag numeric(15,0),slutdag numeric(15,0),starttid time,sluttid time,ugedag integer,salgspris numeric(15,2),kostpris numeric(15,2),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
# db_modify("CREATE TABLE osc_adresser (id serial NOT NULL,saldi_id integer,osc_id integer,PRIMARY KEY (id))",__FILE__ . " linje " . __LINE__);
# db_modify("CREATE TABLE osc_ordrer (id serial NOT NULL,saldi_id integer,osc_id integer,PRIMARY KEY (id))",__FILE__ . " linje " . __LINE__);
# db_modify("CREATE TABLE osc_varer (id serial NOT NULL,saldi_id integer,osc_id integer,PRIMARY KEY (id))",__FILE__ . " linje " . __LINE__);
db_modify("CREATE INDEX ordrelinjer_ordreid_idx ON ordrelinjer (ordre_id)", __FILE__ . " linje " . __LINE__);
db_modify("CREATE INDEX transaktioner_id_idx ON transaktioner (id)", __FILE__ . " linje " . __LINE__);
db_modify("CREATE INDEX ordrelinjer_vare_id_idx ON ordrelinjer (vare_id)", __FILE__ . " linje " . __LINE__);
db_modify("CREATE INDEX batch_kob_kobsdate_idx ON batch_kob (kobsdate)", __FILE__ . " linje " . __LINE__);
db_modify("CREATE INDEX batch_kob_antal_idx ON batch_kob (antal)", __FILE__ . " linje " . __LINE__);
db_modify("CREATE INDEX batch_kob_vare_id_idx ON batch_kob (vare_id)", __FILE__ . " linje " . __LINE__);
db_modify("CREATE INDEX batch_salg_salgsdate_idx ON batch_salg (salgsdate)", __FILE__ . " linje " . __LINE__);
db_modify("CREATE INDEX batch_salg_antal_idx ON batch_salg (antal)", __FILE__ . " linje " . __LINE__);
db_modify("CREATE INDEX batch_salg_vare_id_idx ON batch_salg (vare_id)", __FILE__ . " linje " . __LINE__);
db_modify("CREATE INDEX transaktioner_transdate_idx ON transaktioner (transdate)", __FILE__ . " linje " . __LINE__);
db_modify("CREATE INDEX transaktioner_kontonr_idx ON transaktioner (kontonr)", __FILE__ . " linje " . __LINE__);
db_modify("CREATE INDEX pos_betalinger_ordre_id_idx ON pos_betalinger (ordre_id)", __FILE__ . " linje " . __LINE__);
db_modify("CREATE INDEX pos_betalinger_betalingstype_idx ON pos_betalinger (betalingstype)", __FILE__ . " linje " . __LINE__);
db_modify("CREATE INDEX openpost_id_idx ON openpost (id)", __FILE__ . " linje " . __LINE__);
db_modify("CREATE INDEX openpost_konto_id_idx ON openpost (konto_id)", __FILE__ . " linje " . __LINE__);
db_modify("CREATE INDEX openpost_udlign_id_idx ON openpost (udlign_id)", __FILE__ . " linje " . __LINE__);
db_modify("CREATE INDEX ordrer_art_idx ON ordrer (art)", __FILE__ . " linje " . __LINE__);
db_modify("CREATE INDEX ordrer_ordrenr_idx ON ordrer (ordrenr)", __FILE__ . " linje " . __LINE__);
db_modify("CREATE INDEX ordrer_betalt_idx ON ordrer (betalt)", __FILE__ . " linje " . __LINE__);
$pw = md5($passwd);
db_modify("INSERT INTO brugere (brugernavn,kode,rettigheder,regnskabsaar) values ('{$brugernavn}' ,'{$pw}','11111111111111111111',1)", __FILE__ . " linje " . __LINE__);
db_modify("insert into grupper (beskrivelse,art,box1) values ('Version','VE','{$version}')", __FILE__ . " linje " . __LINE__);
db_modify("insert into grupper (beskrivelse,kodenr,art,box4,box5) values ('Div_valg','2','DIV','','')", __FILE__ . " linje " . __LINE__);
db_modify("insert into grupper (beskrivelse,kodenr,art,box1,box2,box3,box4,box5,box6,box7,box8,box9,box10) values ('Div_valg','3','DIV','','','','on','on','on','','','','')", __FILE__ . " linje " . __LINE__);
db_modify("insert into grupper (beskrivelse,kode,kodenr,art) values ('Dansk','DA','1','SPROG')", __FILE__ . " linje " . __LINE__);
db_modify("insert into enheder (betegnelse,beskrivelse) values ('stk','styk')", __FILE__ . " linje " . __LINE__);
db_modify("insert into grupper (beskrivelse,kode,kodenr,art,box1,box2) values ('Administratorer','','0','brgrp','','11111111')", __FILE__ . " linje " . __LINE__);
# $r=db_fetch_array(db_select("select id from grupper where (beskrivelse,kode,kodenr,art,box1,box2) values ('Administratorer','','0','brgrp','','11111111')'",__FILE__ . " linje " . __LINE__));
if ($std_kto_plan) {
# include("../includes/kontoplan.php");
if (file_exists("../importfiler/egen_kontoplan.txt")) {
$fp = fopen("../importfiler/egen_kontoplan.txt", "r");
} else {
$fp = fopen("../importfiler/kontoplan.txt", "r");
}
if ($fp) {
$x = 0;
while (!feof($fp)) {
$x++;
list($kontonr[$x], $beskrivelse[$x], $kontotype[$x], $moms[$x], $fra_kto[$x], $valuta[$x], $valutakurs[$x]) = explode(chr(9), fgets($fp));
if (!$kontonr[$x]) {
$x--;
}
}
$kontoantal = $x;
for ($x = 1; $x <= $kontoantal; $x++) {
$beskrivelse[$x] = db_escape_string(trim(str_replace('"', '', $beskrivelse[$x])));
if ($db_encode == "UTF8") {
$beskrivelse[$x] = utf8_encode($beskrivelse[$x]);
}
$kontotype[$x] = trim(str_replace('"', '', $kontotype[$x]));
$moms[$x] = trim(str_replace('"', '', $moms[$x]));
$fra_kto[$x] = $fra_kto[$x] * 1;
if (!$valuta[$x]) {
$valuta[$x] = '0';
}
if (!$valutakurs[$x]) {
$valutakurs[$x] = '100';
}
db_modify("INSERT INTO kontoplan (kontonr,beskrivelse,kontotype,fra_kto,moms,regnskabsaar,lukket,valuta,valutakurs) values ('{$kontonr[$x]}','{$beskrivelse[$x]}','{$kontotype[$x]}','{$fra_kto[$x]}','{$moms[$x]}','1','','{$valuta[$x]}','{$valutakurs[$x]}')", __FILE__ . " linje " . __LINE__);
}
fclose($fp);
}
if (file_exists("../importfiler/egne_grupper.txt")) {
$fp = fopen("../importfiler/egne_grupper.txt", "r");
} else {
$fp = fopen("../importfiler/grupper.txt", "r");
}
if ($fp) {
while (!feof($fp)) {
$x++;
$linje = fgets($fp);
if ($linje && substr($linje, 0, 1) != "#") {
$linje = trim($linje);
if ($db_encode != "UTF8") {
$linje = utf8_decode($linje);
}
# if (strstr($linje,"'")>=28 && strstr($linje,",")>=13)zz
db_modify("insert into grupper (beskrivelse,kode,kodenr,art,box1,box2,box3,box4,box5,box6,box7,box8,box9,box10,box11,box12,box13,box14) values ({$linje})", __FILE__ . " linje " . __LINE__);
# else print "<BODY onLoad=\"javascript:alert('Fejl i gruppefil, regnskab ikke oprettet korrekt')\">";
}
}
fclose($fp);
if ($sqdb == 'rotary') {
$startmd = '07';
$slutmd = '06';
date('m') >= 7 ? $startaar = date("Y") : ($startaar = date("Y") - 1);
$slutaar = $startaar + 1;
$ra_besk = $startaar . "/" . $slutaar;
} else {
$startmd = '01';
$slutmd = '12';
$startaar = date("Y");
$slutaar = date("Y");
$ra_besk = $startaar;
}
db_modify("insert into grupper (beskrivelse,kode,kodenr,art,box1,box2,box3,box4,box5,box6,box7,box8,box9,box10,box11,box12,box13,box14) values ('{$ra_besk}','','1','RA','{$startmd}','{$startaar}','{$slutmd}','{$slutaar}','on','0','','','','','','','','')", __FILE__ . " linje " . __LINE__);
}
if (file_exists("../importfiler/egne_varer.txt")) {
$fp = fopen("../importfiler/egne_varer.txt", "r");
if ($fp) {
while (!feof($fp)) {
$x++;
$linje = fgets($fp);
if ($linje && substr($linje, 0, 1) != "#") {
$linje = trim($linje);
if ($db_encode != "UTF8") {
$linje = utf8_decode($linje);
}
db_modify("insert into varer (varenr,beskrivelse,gruppe,salgspris,kostpris,lukket) values ({$linje})", __FILE__ . " linje " . __LINE__);
}
}
fclose($fp);
}
}
include "../includes/formularimport.php";
formularimport("../importfiler/formular.txt");
db_modify("update formularer set sprog = 'Dansk'", __FILE__ . " linje " . __LINE__);
if ($fra_formular) {
db_modify("insert into adresser (firmanavn,addr1,addr2,postnr,bynavn,kontakt,tlf,email,cvrnr,art)values('{$firmanavn}','{$addr1}','{$addr2}','{$postnr}','{$bynavn}','{$kontakt}','{$tlf}','{$email}','{$cvrnr}','S')", __FILE__ . " linje " . __LINE__);
}
}
transaktion("commit");
print "<BODY onLoad=\"javascript:alert('Regnskab {$regnskab} er oprettet og aktiveret')\">";
if ($fra_formular) {
$regnskab = urlencode($regnskab);
$brugernavn = urlencode($brugernavn);
print "<meta http-equiv=\"refresh\" content=\"1;URL=../index/index.php?regnskab={$regnskab}&navn={$brugernavn}&tlf={$tlf}\">";
} else {
include "../includes/connect.php";
print "<meta http-equiv=\"refresh\" content=\"1;URL=../index/admin_menu.php\">";
}
}