function slet_bilag($bilag_id, $filnavn, $kilde_id, $kilde)
{
@session_start();
$s_id = session_id();
$css = "../css/standard.css";
# Flyttet
# include("../includes/connect.php");
# include("../includes/online.php");
# include("../includes/std_func.php");
$r = db_fetch_array(db_select("select * from grupper where art='FTP'", __FILE__ . " linje " . __LINE__));
$box1 = $r['box1'];
$box2 = $r['box2'];
$box3 = $r['box3'];
if ($kilde == "kassekladde") {
$mappe = $r['box4'];
$undermappe = "kladde_{$kilde_id}";
$ftpfilnavn = "bilag_" . $bilag_id;
} else {
$mappe = $r['box5'];
$undermappe = "debitor_{$kilde_id}";
$ftpfilnavn = "doc_" . $bilag_id;
}
$fp = fopen("../temp/{$db}/ftpscript.{$bruger_id}", "w");
if ($fp) {
fwrite($fp, "cd {$mappe}\ncd {$undermappe}\nrm {$ftpfilnavn}\nbye\n");
}
fclose($fp);
if (!isset($exec_path)) {
$exec_path = "/usr/bin";
}
$kommando = "cd ../temp/{$db}\n{$exec_path}/ncftp ftp://" . $box2 . ":" . $box3 . "@" . $box1 . " < ftpscript.{$bruger_id} > ftplog\n";
system($kommando);
db_modify("update {$kilde} set dokument='' where id='{$bilag_id}'", __FILE__ . " linje " . __LINE__);
}
function singleupdate($string)
{
$webservice = '1';
list($s_id, $tmp) = explode(chr(9), $string);
if (!$s_id) {
return '1' . chr(9) . "Missing session ID";
}
# include("../includes/select.php");
include "../includes/connect.php";
include "../includes/online.php";
$linje = NULL;
$tabels = array('grupper', 'varianter', 'variant_typer', 'shop_ordrer', 'shop_varer', 'adresser', 'shop_adresser');
$singleupdate = str_replace($s_id, "", $string);
$singleupdate = str_replace(chr(9), "", $singleupdate);
$singleupdate = str_replace(chr(10), "", $singleupdate);
$singleupdate = str_replace(chr(13), "", $singleupdate);
# $singleupdate=str_replace(" ","",$singleupdate);
$singleupdate = strtolower($singleupdate);
list($table, $tmp) = explode("set", $singleupdate, 2);
$table = trim($table);
#if ($table!='adresser') return('1'.chr(9).$table);
if (!in_array($table, $tabels)) {
return '1' . chr(9) . 'Updating ' . $table . ' is not accepted';
}
#if ($table!='adresser') return('1'.chr(9).$svar.":".$singleupdate);
transaktion('begin');
$svar = db_modify("update {$table} {$singleupdate}", __FILE__ . " linje " . __LINE__);
list($fejl, $svar) = explode(chr(9), $svar);
if ($fejl) {
return $fejl . chr(9) . $svar;
} else {
transaktion('commit');
return '0' . chr(9) . $id;
}
}
function logoff($s_id)
{
$modulnr = 1;
include "../includes/connect.php";
if ($r = db_fetch_array(db_select("select * from online where session_id='{$s_id}'", __FILE__ . " linje " . __LINE__))) {
db_modify("delete from online where session_id='{$s_id}'", __FILE__ . " linje " . __LINE__);
return '0' . chr(9) . 'GoodBye';
} else {
return '1' . chr(9) . 'No active session';
}
}
function logon($string)
{
@session_start();
$s_id = session_id();
list($regnskab, $brugernavn, $password) = explode(chr(9), $string);
$password = md5($password);
$unixtime = date("U");
include "../includes/db_query.php";
include "../includes/connect.php";
db_modify("delete from online where session_id = '{$s_id}'", __FILE__ . " linje " . __LINE__);
if ($r = db_fetch_array(db_select("select * from regnskab where regnskab = '{$regnskab}'", __FILE__ . " linje " . __LINE__))) {
if ($db = trim($r['db'])) {
$connection = db_connect($sqhost, $squser, $sqpass, $sqdb);
if ($connection) {
db_modify("insert into online (session_id, brugernavn, db, dbuser) values ('{$s_id}', '{$brugernavn}', '{$db}', '{$squser}')", __FILE__ . " linje " . __LINE__);
include "../includes/online.php";
if ($r = db_fetch_array(db_select("select * from brugere where brugernavn = '{$brugernavn}' and kode='{$password}'", __FILE__ . " linje " . __LINE__))) {
$rettigheder = trim($r['rettigheder']);
$regnskabsaar = $r['regnskabsaar'] * 1;
include "../includes/connect.php";
$fp = fopen("../temp/.ht_{$db}.log", "a");
fwrite($fp, "-- " . $brugernavn . " " . date("Y-m-d H:i:s") . ": OK jeg er inde " . $s_id . "\n");
fclose($fp);
db_modify("update online set regnskabsaar='{$regnskabsaar}', rettigheder='{$rettigheder}' where session_id='{$s_id}'", __FILE__ . " linje " . __LINE__);
$return = '0' . chr(9) . $s_id;
} else {
db_modify("delete from online where session_id = '{$s_id}'", __FILE__ . " linje " . __LINE__);
$return = "1" . chr(9) . "Username or password error";
}
} else {
$return = "1" . chr(9) . "Connection to database failed";
}
} else {
$return = "1" . chr(9) . "Unknown finacial report";
}
} else {
return $return = "1" . chr(9) . "Unknown finacial report";
}
return $return;
}
function pbsfakt($id)
{
if ($id && $id > 0) {
if ($r = db_fetch_array(db_select("select id from pbs_liste where afsendt = ''", __FILE__ . " linje " . __LINE__))) {
$liste_id = $r['id'];
} else {
$liste_date = date("Y-m-d");
$afsendt = NULL;
db_modify("insert into pbs_liste (liste_date,afsendt) values ('{$liste_date}','{$afsendt}')", __FILE__ . " linje " . __LINE__);
$r = db_fetch_array(db_select("select id from pbs_liste where afsendt = ''", __FILE__ . " linje " . __LINE__));
$liste_id = $r['id'];
}
if (db_fetch_array(db_select("select id from pbs_ordrer where ordre_id = '{$id}'", __FILE__ . " linje " . __LINE__))) {
echo "Faktura nr {$r['fakturanr']} findes allerede i PBS liste<br>";
} else {
$r = db_fetch_array(db_select("select fakturanr, konto_id from ordrer where id = '{$id}'", __FILE__ . " linje " . __LINE__));
$konto_id = $r['konto_id'];
db_modify("insert into pbs_ordrer (liste_id,ordre_id) values ('{$liste_id}','{$id}')", __FILE__ . " linje " . __LINE__);
echo "Faktura nr {$r['fakturanr']} tilføjet til PBS liste<br>";
}
}
}
function opdat_0($version, $dbver)
{
global $db_id;
global $s_id;
global $backup;
include "../includes/connect.php";
include "../includes/online.php";
include "../includes/db_query.php";
$returside = "../index/logud.php";
$db = trim($db);
if (!$backup) {
system("pg_dump -h {$sqhost} -U {$squser} -W {$sqpass} -f '../temp/{$db}.sql' {$db}");
print "<table align=center valign=center cellpadding=1 cellspacing=1 border=0\theight=100% width=100%><tbody>";
print "<tr><td>";
print "<table align=center valign=center cellpadding=1 cellspacing=1 border=0\theight=25% width=50%><tbody>";
print "<tr><td align=center>{$font} Systemet opdateres . . . . . .<br></td></tr>";
print "<tr><td align=center>{$font} Backup foretages . . . . . .<br></td></tr>";
print "<tr><td align=center><br></td></tr>";
print "<tr><td align=center>{$font} Højreklik her: <a href='../temp/{$db}.sql'>{$db}.sql</a></td></tr>";
print "<tr><td align=center>{$font} Vælg \"gem link som\" (eller \"save link as\")</td></tr>";
print "<tr><td align=center>{$font} og gem backup'en et passende sted</td></tr>";
print "<tr><td><br></td></tr>";
print "<tr><td align=center><a href=../includes/opdat_0.php?version={$version}&dbver={$dbver}&backup=OK accesskey=F>{$font} Fortsæt</a><br></td></tr>";
print "</tbody></table>";
print "</td></tr>";
print "</tbody></table>";
print "<br>";
}
if (!$dbver) {
echo "Variablen dbver ikke sat - kontakt systemansvarlig!!";
exit;
}
if ($dbver < 0.23) {
transaktion("begin");
db_modify("ALTER TABLE kladdeliste add bogforingsdate date");
db_modify("UPDATE grupper set box1 = '0.23' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.24) {
transaktion("begin");
$x = 0;
$maxval = 0;
$query = db_select("SELECT * FROM ordrelinjer");
while ($row = db_fetch_array($query)) {
$x++;
$id[$x] = $row[id];
$varenr[$x] = $row['varenr'];
$text[$x] = $row['text'];
$posnr[$x] = $row['posnr'] * 1;
$pris[$x] = $row['pris'] * 1;
$rabat[$x] = $row['rabat'] * 1;
$lev_varenr[$x] = $row['lev_varenr'];
$ordre_id[$x] = $row['ordre_id'] * 1;
$serienr[$x] = $row['serienr'];
$antal[$x] = $row['antal'] * 1;
$bogf_konto[$x] = $row['bogf_konto'] * 1;
if ($maxval < $id[$x]) {
$maxval = $id[$x];
}
}
$linjeantal = $x;
db_modify("DROP TABLE ordrelinjer");
db_modify("CREATE TABLE ordrelinjer (id serial NOT NULL, varenr varchar, text r varchar, posnr smallint, pris numeric, rabat numeric, lev_varenr varchar, ordre_id integer, serienr varchar, antal numeric, bogf_konto integer, PRIMARY KEY (id))");
for ($x = 1; $x <= $linjeantal; $x++) {
db_modify("INSERT INTO ordrelinjer (id, varenr, text, posnr, pris, rabat, lev_varenr, ordre_id, serienr, antal, bogf_konto) values ({$id[$x]}, '{$varenr[$x]}', '{$text[$x]}', '{$posnr[$x]}', '{$pris[$x]}', '{$rabat[$x]}', '{$lev_varenr[$x]}', '{$ordre_id[$x]}', '{$serienr[$x]}', '{$antal[$x]}', '{$bogf_konto[$x]}')");
}
if ($maxval >= 1) {
db_modify("select pg_catalog.setval('ordrelinjer_id_seq', {$maxval}, true)");
}
db_modify("CREATE TABLE batch_kob (id serial NOT NULL, kobsdate date, vare_id integer, ordre_id integer, pris numeric, antal integer, rest integer, PRIMARY KEY (id))");
db_modify("CREATE TABLE batch_salg (id serial NOT NULL, salgsdate date, batch_kob_id integer, vare_id integer, ordre_id integer, pris numeric, antal integer, PRIMARY KEY (id))");
db_modify("CREATE TABLE serienr (id serial NOT NULL, vare_id integer, kobsordre_id integer, salgsordre_id integer, serienr varchar, PRIMARY KEY (id))");
db_modify("UPDATE grupper set box1 = '0.24' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.26) {
transaktion("begin");
db_modify("ALTER TABLE ordrelinjer ADD vare_id integer");
db_modify("ALTER TABLE ordrer ADD kred_ord_id integer");
db_modify("UPDATE grupper set box1 = '0.26' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.27) {
transaktion("begin");
print "Opdaterer til ver. 0.27<br>";
db_modify("ALTER TABLE varer ADD samlevare varchar");
db_modify("ALTER TABLE varer ADD delvare varchar");
db_modify("ALTER TABLE ordrer ADD lev_adr text");
db_modify("CREATE TABLE styklister (id serial NOT NULL, vare_id integer, indgaar_i integer, antal integer, PRIMARY KEY (id))");
db_modify("UPDATE grupper set box1 = '0.27' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.29) {
transaktion("begin");
print "Opdaterer til ver. 0.29<br>";
db_modify("ALTER TABLE brugere ADD rettigheder varchar");
db_modify("UPDATE brugere set rettigheder='1111111111'");
db_modify("ALTER TABLE styklister ADD posnr integer");
transaktion("commit");
include "../includes/connect.php";
$query = db_select("SELECT * FROM online");
$row = db_fetch_array($query);
if (!$row[rettigheder]) {
db_modify("ALTER TABLE online ADD rettigheder varchar");
}
include "../includes/online.php";
transaktion("begin");
db_modify("UPDATE grupper set box1 = '0.29' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.31) {
transaktion("begin");
print "Opdaterer til ver. 0.31<br>";
db_modify("ALTER TABLE varer ADD enhed varchar");
db_modify("ALTER TABLE varer ADD enhed2 varchar");
db_modify("ALTER TABLE varer ADD forhold numeric");
db_modify("ALTER TABLE ordrelinjer ADD enhed varchar");
db_modify("CREATE TABLE enheder (id serial NOT NULL, betegnelse varchar, beskrivelse varchar, PRIMARY KEY (id))");
db_modify("INSERT into enheder (betegnelse, beskrivelse) values ('m', 'meter')");
db_modify("INSERT into enheder (betegnelse, beskrivelse) values ('m2', 'kvadratmeter')");
db_modify("INSERT into enheder (betegnelse, beskrivelse) values ('m3', 'kubikmeter')");
db_modify("INSERT into enheder (betegnelse, beskrivelse) values ('l', 'liter')");
db_modify("INSERT into enheder (betegnelse, beskrivelse) values ('kg', 'kilogram')");
db_modify("INSERT into enheder (betegnelse, beskrivelse) values ('stk', 'styk')");
db_modify("CREATE TABLE materialer (id serial NOT NULL, beskrivelse varchar, densitet numeric, PRIMARY KEY (id))");
db_modify("CREATE TABLE vare_lev (id serial NOT NULL, posnr integer, lev_id integer, vare_id integer, lev_varenr varchar, kostpris numeric, PRIMARY KEY (id))");
$x = 0;
$query = db_select("SELECT * FROM varer where leverandor > 0");
while ($row = db_fetch_array($query)) {
$x++;
$id[$x] = $row[id];
$leverandor[$x] = $row[leverandor];
$lev_varenr[$x] = $row['lev_varenr'];
$kostpris[$x] = $row['kostpris'];
}
$linjeantal = $x;
for ($x = 1; $x <= $linjeantal; $x++) {
db_modify("INSERT into vare_lev (lev_id, vare_id, lev_varenr, kostpris) values ({$leverandor[$x]}, {$id[$x]}, '{$lev_varenr[$x]}', '{$kostpris[$x]}')");
}
db_modify("UPDATE grupper set box1 = '0.31' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.33) {
transaktion("begin");
print "Opdaterer til ver. 0.33<br>";
db_modify("CREATE TABLE ansatte (id serial NOT NULL, adr_id integer, navn varchar, addr1 varchar, addr2 varchar, postnr varchar, bynavn varchar, tlf varchar, fax varchar, mobil varchar, email varchar, notes text, cprnr varchar, posnr integer, PRIMARY KEY (id))");
$x = 0;
$query = db_select("SELECT * FROM adresser order by id");
while ($row = db_fetch_array($query)) {
if ($row[kontakt]) {
$x++;
$adr_id[$x] = $row[id];
$navn[$x] = $row['kontakt'];
}
}
$linjeantal = $x;
for ($x = 1; $x <= $linjeantal; $x++) {
db_modify("INSERT into ansatte (adr_id, navn) values ({$adr_id[$x]}, '{$navn[$x]}')");
}
db_modify("UPDATE grupper set box1 = '0.33' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.35) {
transaktion("begin");
print "Opdaterer til ver. 0.35<br>";
db_modify("ALTER TABLE ordrer DROP ordrenr");
db_modify("ALTER TABLE ordrer ADD ordrenr integer");
$x = 0;
$maxval = 0;
$query = db_select("SELECT id FROM ordrer order by id");
while ($row = db_fetch_array($query)) {
$x++;
$id[$x] = $row[id];
if ($maxval < $id[$x]) {
$maxval = $id[$x];
}
}
$linjeantal = $x;
for ($x = 1; $x <= $linjeantal; $x++) {
db_modify("UPDATE ordrer set ordrenr = '{$id[$x]}' where id = {$id[$x]}");
}
if ($maxval >= 1) {
db_modify("select pg_catalog.setval ('ordrer_id_seq', {$maxval}, true)");
}
db_modify("ALTER TABLE ordrelinjer ADD leveret integer");
db_modify("ALTER TABLE batch_kob ADD linje_id integer");
db_modify("ALTER TABLE batch_salg ADD linje_id integer");
db_modify("UPDATE grupper set box1 = '0.35' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.39) {
transaktion("begin");
print "Opdaterer til ver. 0.39<br>";
$x = 0;
$maxval = 0;
$query = db_select("SELECT * FROM ordrelinjer");
while ($row = db_fetch_array($query)) {
$x++;
$id[$x] = $row[id];
$antal[$x] = $row['antal'] * 1;
$leveres[$x] = $row['leveret'] * 1;
if ($maxval < $id[$x]) {
$maxval = $id[$x];
}
}
$linjeantal = $x;
db_modify("ALTER TABLE ordrelinjer DROP antal");
db_modify("ALTER TABLE ordrelinjer DROP leveret");
db_modify("ALTER TABLE ordrelinjer ADD antal numeric");
db_modify("ALTER TABLE ordrelinjer ADD leveres numeric");
for ($x = 1; $x <= $linjeantal; $x++) {
db_modify("UPDATE ordrelinjer set antal='{$antal[$x]}', leveres='{$leveres[$x]}' where id={$id[$x]}");
}
if ($maxval >= 1) {
db_modify("select pg_catalog.setval ('ordrelinjer_id_seq', {$maxval}, true)");
}
$x = 0;
$maxval = 0;
$query = db_select("SELECT * FROM batch_kob");
while ($row = db_fetch_array($query)) {
$x++;
$id[$x] = $row[id];
$antal[$x] = $row['antal'] * 1;
$rest[$x] = $row['rest'] * 1;
if ($maxval < $id[$x]) {
$maxval = $id[$x];
}
}
$linjeantal = $x;
db_modify("ALTER TABLE batch_kob DROP antal");
db_modify("ALTER TABLE batch_kob DROP rest");
db_modify("ALTER TABLE batch_kob ADD antal numeric");
db_modify("ALTER TABLE batch_kob ADD rest numeric");
for ($x = 1; $x <= $linjeantal; $x++) {
db_modify("UPDATE batch_kob set antal='{$antal[$x]}', rest='{$rest[$x]}' where id={$id[$x]}");
}
if ($maxval >= 1) {
db_modify("select pg_catalog.setval ('batch_kob_id_seq', {$maxval}, true)");
}
$x = 0;
$maxval = 0;
$query = db_select("SELECT * FROM batch_salg");
while ($row = db_fetch_array($query)) {
$x++;
$id[$x] = $row[id];
$antal[$x] = $row['antal'] * 1;
if ($maxval < $id[$x]) {
$maxval = $id[$x];
}
}
$linjeantal = $x;
db_modify("ALTER TABLE batch_salg DROP antal");
db_modify("ALTER TABLE batch_salg ADD antal numeric");
for ($x = 1; $x <= $linjeantal; $x++) {
db_modify("UPDATE batch_salg set antal='{$antal[$x]}' where id={$id[$x]}");
}
if ($maxval >= 1) {
db_modify("select pg_catalog.setval ('batch_salg_id_seq', {$maxval}, true)");
}
$x = 0;
$maxval = 0;
$query = db_select("SELECT * FROM varer");
while ($row = db_fetch_array($query)) {
$x++;
$id[$x] = $row[id];
$beholdning[$x] = $row['beholdning'] * 1;
if ($maxval < $id[$x]) {
$maxval = $id[$x];
}
}
$linjeantal = $x;
db_modify("ALTER TABLE varer DROP beholdning");
db_modify("ALTER TABLE varer ADD beholdning numeric");
for ($x = 1; $x <= $linjeantal; $x++) {
db_modify("UPDATE varer set beholdning='{$beholdning[$x]}' where id={$id[$x]}");
}
if ($maxval >= 1) {
db_modify("select pg_catalog.setval ('varer_id_seq', {$maxval}, true)");
}
$x = 0;
$maxval = 0;
$query = db_select("SELECT * FROM styklister");
while ($row = db_fetch_array($query)) {
$x++;
$id[$x] = $row[id];
$antal[$x] = $row['antal'] * 1;
if ($maxval < $id[$x]) {
$maxval = $id[$x];
}
}
$linjeantal = $x;
db_modify("ALTER TABLE styklister DROP antal");
db_modify("ALTER TABLE styklister ADD antal numeric");
for ($x = 1; $x <= $linjeantal; $x++) {
db_modify("UPDATE styklister set antal='{$antal[$x]}' where id={$id[$x]}");
}
if ($maxval >= 1) {
db_modify("select pg_catalog.setval ('styklister_id_seq', {$maxval}, true)");
}
db_modify("DROP TABLE serienr");
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 varchar, PRIMARY KEY (id))");
db_modify("UPDATE grupper set box1 = '0.39' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.41) {
transaktion("begin");
print "Opdaterer til ver. 0.41<br>";
db_modify("ALTER TABLE adresser ADD bank_navn varchar");
db_modify("ALTER TABLE adresser ADD bank_reg varchar");
db_modify("ALTER TABLE adresser ADD bank_konto varchar");
db_modify("ALTER TABLE ordrer ADD kundeordnr varchar");
db_modify("ALTER TABLE ordrer ADD\tlev_navn varchar");
db_modify("ALTER TABLE ordrer ADD\tlev_addr1 varchar");
db_modify("ALTER TABLE ordrer ADD\tlev_addr2 varchar");
db_modify("ALTER TABLE ordrer ADD\tlev_postnr varchar");
db_modify("ALTER TABLE ordrer ADD\tlev_bynavn varchar");
db_modify("ALTER TABLE ordrer ADD lev_kontakt varchar");
db_modify("ALTER TABLE batch_salg ADD lev_nr integer");
$x = 0;
$maxval = 0;
$query = db_select("SELECT * FROM grupper");
while ($row = db_fetch_array($query)) {
$x++;
$id[$x] = $row[id];
$beskrivelse[$x] = $row['beskrivelse'];
$kode[$x] = $row['kode'];
$kodenr[$x] = $row['kodenr'];
$art[$x] = $row['art'];
$box1[$x] = $row['box1'];
$box2[$x] = $row['box2'];
$box3[$x] = $row['box3'];
$box4[$x] = $row['box4'];
$box5[$x] = $row['box5'];
$box6[$x] = $row['box6'];
$box7[$x] = $row['box7'];
$box8[$x] = $row['box8'];
if ($maxval < $id[$x]) {
$maxval = $id[$x];
}
}
$linjeantal = $x;
db_modify("DROP TABLE grupper");
db_modify("CREATE TABLE grupper (id serial NOT NULL, beskrivelse varchar, kode varchar,\tkodenr varchar, art varchar, box1 varchar, box2 varchar, box3 varchar, box4 varchar, box5 varchar, box6 varchar, box7 varchar, box8 varchar, PRIMARY KEY (id))");
for ($x = 1; $x <= $linjeantal; $x++) {
db_modify("INSERT INTO grupper (id, beskrivelse, kode, kodenr , art, box1, box2, box3, box4, box5, box6, box7, box8) values ({$id[$x]}, '{$beskrivelse[$x]}', '{$kode[$x]}', '{$kodenr[$x]}' ,'{$art[$x]}', '{$box1[$x]}', '{$box2[$x]}', '{$box3[$x]}', '{$box4[$x]}','{$box5[$x]}', '{$box6[$x]}', '{$box7[$x]}', '{$box8[$x]}')");
}
if ($maxval >= 1) {
db_modify("select pg_catalog.setval ('grupper_id_seq', {$maxval}, true)");
}
db_modify("INSERT INTO grupper (beskrivelse, kodenr , art, box1,\tbox3) values ('Tilbud','1' ,'PV', 'lpr', 'on')");
db_modify("INSERT INTO grupper (beskrivelse, kodenr , art, box1,\tbox3) values ('Ordrebekr�telse','2' ,'PV', 'lpr', 'on')");
db_modify("INSERT INTO grupper (beskrivelse, kodenr , art, box1,\tbox3) values ('Flgeseddel','3' ,'PV', 'lpr', 'on')");
db_modify("INSERT INTO grupper (beskrivelse, kodenr , art, box1,\tbox3) values ('Faktura', '4' ,'PV', 'lpr', 'on')");
db_modify("UPDATE grupper set box1 = '0.41' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.42) {
transaktion("begin");
print "Opdaterer til ver. 0.42<br>";
$x = 0;
$query = db_select("SELECT id, kontonr FROM adresser");
while ($row = db_fetch_array($query)) {
$x++;
$id[$x] = $row[id];
$kontonr[$x] = $row[kontonr];
}
$linjeantal = $x;
db_modify("ALTER TABLE adresser DROP kontonr");
db_modify("ALTER TABLE adresser ADD kontonr varchar");
for ($x = 1; $x <= $linjeantal; $x++) {
db_modify("UPDATE adresser set kontonr = '{$kontonr[$x]}' where id = {$id[$x]}");
}
db_modify("ALTER TABLE ansatte RENAME COLUMN adr_id TO konto_id");
db_modify("UPDATE grupper set box1 = '0.42' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.421) {
transaktion("begin");
db_modify("ALTER TABLE adresser ADD ean varchar");
db_modify("ALTER TABLE adresser ADD institution varchar");
db_modify("UPDATE grupper set box1 = '0.421' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.422) {
transaktion("begin");
db_modify("ALTER TABLE ordrer ADD ean varchar");
db_modify("ALTER TABLE ordrer ADD institution varchar");
db_modify("UPDATE grupper set box1 = '0.422' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.431) {
transaktion("begin");
db_modify("ALTER TABLE adresser ADD land varchar");
db_modify("ALTER TABLE ordrer ADD land varchar");
db_modify("UPDATE grupper set box1 = '0.431' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.432) {
transaktion("begin");
db_modify("ALTER TABLE adresser ADD web varchar");
db_modify("UPDATE grupper set box1 = '0.432' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.433) {
transaktion("begin");
db_modify("ALTER TABLE varer ADD min_lager numeric");
db_modify("UPDATE grupper set box1 = '0.433' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.434) {
transaktion("begin");
db_modify("ALTER TABLE varer ADD max_lager numeric");
$x = 0;
$query = db_select("SELECT * FROM brugere");
while ($row = db_fetch_array($query)) {
$x++;
$id[$x] = $row[id];
$kode[$x] = md5(trim($row['kode']));
}
$linjeantal = $x;
db_modify("ALTER TABLE brugere DROP kode");
db_modify("ALTER TABLE brugere ADD kode varchar");
for ($x = 1; $x <= $linjeantal; $x++) {
db_modify("UPDATE brugere set kode = '{$kode[$x]}' where id = {$id[$x]}");
}
db_modify("UPDATE grupper set box1 = '0.434' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.435) {
transaktion("begin");
$x = 0;
$query = db_select("SELECT id, text FROM ordrelinjer");
while ($row = db_fetch_array($query)) {
$x++;
$id[$x] = $row[id];
$text[$x] = $row[text];
}
$linjeantal = $x;
db_modify("ALTER TABLE ordrelinjer DROP text");
db_modify("ALTER TABLE ordrelinjer ADD text text");
for ($x = 1; $x <= $linjeantal; $x++) {
db_modify("UPDATE ordrelinjer set text = '{$text[$x]}' where id = {$id[$x]}");
}
db_modify("UPDATE grupper set box1 = '0.435' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.436) {
transaktion("begin");
db_modify("ALTER TABLE kontoplan DROP jan");
db_modify("ALTER TABLE kontoplan DROP feb");
db_modify("ALTER TABLE kontoplan DROP mar");
db_modify("ALTER TABLE kontoplan DROP apr");
db_modify("ALTER TABLE kontoplan DROP jun");
db_modify("ALTER TABLE kontoplan DROP jul");
db_modify("ALTER TABLE kontoplan DROP aug");
db_modify("ALTER TABLE kontoplan DROP sep");
db_modify("ALTER TABLE kontoplan DROP okt");
db_modify("ALTER TABLE kontoplan DROP nov");
db_modify("ALTER TABLE kontoplan DROP dec");
db_modify("ALTER TABLE kontoplan ADD md01 numeric");
db_modify("ALTER TABLE kontoplan ADD md02 numeric");
db_modify("ALTER TABLE kontoplan ADD md03 numeric");
db_modify("ALTER TABLE kontoplan ADD md04 numeric");
db_modify("ALTER TABLE kontoplan ADD md05 numeric");
db_modify("ALTER TABLE kontoplan ADD md06 numeric");
db_modify("ALTER TABLE kontoplan ADD md07 numeric");
db_modify("ALTER TABLE kontoplan ADD md08 numeric");
db_modify("ALTER TABLE kontoplan ADD md09 numeric");
db_modify("ALTER TABLE kontoplan ADD md10 numeric");
db_modify("ALTER TABLE kontoplan ADD md11 numeric");
db_modify("ALTER TABLE kontoplan ADD md12 numeric");
transaktion("commit");
db_modify("UPDATE grupper set box1 = '0.436' where art = 'VE'");
}
if ($dbver < 0.501) {
transaktion("begin");
$x = 0;
$query = db_select("SELECT id, debet, kredit FROM kassekladde");
while ($row = db_fetch_array($query)) {
$x++;
$id[$x] = $row[id];
$debet[$x] = $row[debet];
$kredit[$x] = $row[kredit];
if (!$debet[$x]) {
$debet[$x] = '0';
}
if (!$kredit[$x]) {
$kredit[$x] = '0';
}
}
$linjeantal = $x;
db_modify("ALTER TABLE kassekladde DROP debet");
db_modify("ALTER TABLE kassekladde DROP kredit");
db_modify("ALTER TABLE kassekladde ADD debet numeric");
db_modify("ALTER TABLE kassekladde ADD kredit numeric");
for ($x = 1; $x <= $linjeantal; $x++) {
db_modify("UPDATE kassekladde set debet = '{$debet[$x]}', kredit = '{$kredit[$x]}' where id = {$id[$x]}");
}
db_modify("UPDATE grupper set box1 = '0.501' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.502) {
transaktion("begin");
db_modify("ALTER TABLE ordrer ADD modtagelse integer");
# include("../includes/genberegn.php");
$query = db_select("SELECT * FROM grupper where art='RA' order by kodenr");
# while($row = db_fetch_array($query)) {genberegn($row[kodenr]);}
db_modify("UPDATE grupper set box1 = '0.502' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.601) {
transaktion("begin");
db_modify("ALTER TABLE kladdeliste ADD oprettet_af varchar");
db_modify("ALTER TABLE kladdeliste ADD bogfort_af varchar");
db_modify("ALTER TABLE kladdeliste ADD hvem varchar");
db_modify("ALTER TABLE kladdeliste ADD tidspkt varchar");
db_modify("UPDATE grupper set box1 = '0.601' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.602) {
transaktion("begin");
db_modify("ALTER TABLE ordrer ADD oprettet_af varchar");
db_modify("ALTER TABLE ordrer ADD bogfort_af varchar");
db_modify("ALTER TABLE ordrer ADD hvem varchar");
db_modify("ALTER TABLE ordrer ADD tidspkt varchar");
db_modify("UPDATE grupper set box1 = '0.602' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.603) {
transaktion("begin");
$x = 0;
$query = db_select("SELECT * FROM adresser");
while ($row = db_fetch_array($query)) {
$x++;
$id[$x] = $row[id];
$firmanavn[$x] = addslashes(trim($row['firmanavn']));
$addr1[$x] = addslashes(trim($row['addr1']));
$addr2[$x] = addslashes(trim($row['addr2']));
$postnr[$x] = addslashes(trim($row['postnr']));
$bynavn[$x] = addslashes(trim($row['bynavn']));
$kontakt[$x] = addslashes(trim($row['kontakt']));
$tlf[$x] = addslashes(trim($row['tlf']));
$fax[$x] = addslashes(trim($row['fax']));
$email[$x] = addslashes(trim($row['email']));
$notes[$x] = addslashes(trim($row['notes']));
$cvrnr[$x] = addslashes(trim($row['cvrnr']));
$art[$x] = addslashes(trim($row['art']));
$bank_navn[$x] = addslashes(trim($row['bank_navn']));
$bank_reg[$x] = addslashes(trim($row['bank_reg']));
$bank_konto[$x] = addslashes(trim($row['bank_konto']));
$kontonr[$x] = addslashes(trim($row['kontonr']));
$ean[$x] = addslashes(trim($row['ean']));
$institution[$x] = addslashes(trim($row['institution']));
$land[$x] = addslashes(trim($row['land']));
$web[$x] = addslashes(trim($row['web']));
}
$linjeantal = $x;
db_modify("ALTER TABLE adresser DROP firmanavn");
db_modify("ALTER TABLE adresser DROP addr1");
db_modify("ALTER TABLE adresser DROP addr2");
db_modify("ALTER TABLE adresser DROP postnr");
db_modify("ALTER TABLE adresser DROP bynavn");
db_modify("ALTER TABLE adresser DROP kontakt");
db_modify("ALTER TABLE adresser DROP tlf");
db_modify("ALTER TABLE adresser DROP fax");
db_modify("ALTER TABLE adresser DROP email");
db_modify("ALTER TABLE adresser DROP notes");
db_modify("ALTER TABLE adresser DROP cvrnr");
db_modify("ALTER TABLE adresser DROP art");
db_modify("ALTER TABLE adresser DROP bank_navn");
db_modify("ALTER TABLE adresser DROP bank_reg");
db_modify("ALTER TABLE adresser DROP bank_konto");
db_modify("ALTER TABLE adresser DROP kontonr");
db_modify("ALTER TABLE adresser DROP ean");
db_modify("ALTER TABLE adresser DROP institution");
db_modify("ALTER TABLE adresser DROP land");
db_modify("ALTER TABLE adresser DROP web");
db_modify("ALTER TABLE adresser ADD firmanavn varchar");
db_modify("ALTER TABLE adresser ADD addr1 varchar");
db_modify("ALTER TABLE adresser ADD addr2 varchar");
db_modify("ALTER TABLE adresser ADD postnr varchar");
db_modify("ALTER TABLE adresser ADD bynavn varchar");
db_modify("ALTER TABLE adresser ADD kontakt varchar");
db_modify("ALTER TABLE adresser ADD tlf varchar");
db_modify("ALTER TABLE adresser ADD fax varchar");
db_modify("ALTER TABLE adresser ADD email varchar");
db_modify("ALTER TABLE adresser ADD notes varchar");
db_modify("ALTER TABLE adresser ADD cvrnr varchar");
db_modify("ALTER TABLE adresser ADD art varchar");
db_modify("ALTER TABLE adresser ADD bank_navn varchar");
db_modify("ALTER TABLE adresser ADD bank_reg varchar");
db_modify("ALTER TABLE adresser ADD bank_konto varchar");
db_modify("ALTER TABLE adresser ADD kontonr varchar");
db_modify("ALTER TABLE adresser ADD ean varchar");
db_modify("ALTER TABLE adresser ADD institution varchar");
db_modify("ALTER TABLE adresser ADD land varchar");
db_modify("ALTER TABLE adresser ADD web varchar");
for ($x = 1; $x <= $linjeantal; $x++) {
db_modify("UPDATE adresser set firmanavn = '{$firmanavn[$x]}',\taddr1 = '{$addr1[$x]}',\taddr2 = '{$addr2[$x]}', postnr = '{$postnr[$x]}', bynavn = '{$bynavn[$x]}', kontakt = '{$kontakt[$x]}', tlf = '{$tlf[$x]}', fax = '{$fax[$x]}', email = '{$email[$x]}', notes = '{$notes[$x]}', cvrnr = '{$cvrnr[$x]}', art = '{$art[$x]}', bank_navn = '{$bank_navn[$x]}', bank_reg = '{$bank_reg[$x]}', bank_konto = '{$bank_konto[$x]}', kontonr = '{$kontonr[$x]}', ean = '{$ean[$x]}', institution = '{$institution[$x]}', land = '{$land[$x]}', web = '{$web[$x]}' where id ={$id[$x]}");
}
db_modify("UPDATE grupper set box1 = '0.603' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.604) {
transaktion("begin");
$x = 0;
$query = db_select("SELECT * FROM ansatte");
while ($row = db_fetch_array($query)) {
$x++;
$id[$x] = $row[id];
$navn[$x] = addslashes(trim($row['navn']));
$addr1[$x] = addslashes(trim($row['addr1']));
$addr2[$x] = addslashes(trim($row['addr2']));
$postnr[$x] = addslashes(trim($row['postnr']));
$bynavn[$x] = addslashes(trim($row['bynavn']));
$tlf[$x] = addslashes(trim($row['tlf']));
$fax[$x] = addslashes(trim($row['fax']));
$mobil[$x] = addslashes(trim($row['mobil']));
$email[$x] = addslashes(trim($row['email']));
$notes[$x] = addslashes(trim($row['notes']));
$cprnr[$x] = addslashes(trim($row['cprnr']));
}
$linjeantal = $x;
db_modify("ALTER TABLE ansatte DROP navn");
db_modify("ALTER TABLE ansatte DROP addr1");
db_modify("ALTER TABLE ansatte DROP addr2");
db_modify("ALTER TABLE ansatte DROP postnr");
db_modify("ALTER TABLE ansatte DROP bynavn");
db_modify("ALTER TABLE ansatte DROP tlf");
db_modify("ALTER TABLE ansatte DROP fax");
db_modify("ALTER TABLE ansatte DROP mobil");
db_modify("ALTER TABLE ansatte DROP email");
db_modify("ALTER TABLE ansatte DROP notes");
db_modify("ALTER TABLE ansatte DROP cprnr");
db_modify("ALTER TABLE ansatte ADD navn varchar");
db_modify("ALTER TABLE ansatte ADD addr1 varchar");
db_modify("ALTER TABLE ansatte ADD addr2 varchar");
db_modify("ALTER TABLE ansatte ADD postnr varchar");
db_modify("ALTER TABLE ansatte ADD bynavn varchar");
db_modify("ALTER TABLE ansatte ADD tlf varchar");
db_modify("ALTER TABLE ansatte ADD fax varchar");
db_modify("ALTER TABLE ansatte ADD mobil varchar");
db_modify("ALTER TABLE ansatte ADD email varchar");
db_modify("ALTER TABLE ansatte ADD notes varchar");
db_modify("ALTER TABLE ansatte ADD cprnr varchar");
for ($x = 1; $x <= $linjeantal; $x++) {
db_modify("UPDATE ansatte set navn = '{$navn[$x]}', addr1 = '{$addr1[$x]}',\taddr2 = '{$addr2[$x]}', postnr = '{$postnr[$x]}', bynavn = '{$bynavn[$x]}', tlf = '{$tlf[$x]}', fax = '{$fax[$x]}', mobil = '{$mobil[$x]}', email = '{$email[$x]}', notes = '{$notes[$x]}', cprnr = '{$cprnr[$x]}' where id ={$id[$x]}");
}
db_modify("UPDATE grupper set box1 = '0.604' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.605) {
$id = array();
$brugernavn = array();
$status = array();
$rettigheder = array();
$kode = array();
transaktion("begin");
$x = 0;
$query = db_select("SELECT * FROM brugere");
while ($row = db_fetch_array($query)) {
$x++;
$id[$x] = $row[id];
$brugernavn[$x] = addslashes(trim($row['brugernavn']));
$status[$x] = addslashes(trim($row['status']));
$rettigheder[$x] = addslashes(trim($row['rettigheder']));
$kode[$x] = addslashes(trim($row['kode']));
}
$linjeantal = $x;
db_modify("ALTER TABLE brugere DROP brugernavn");
db_modify("ALTER TABLE brugere DROP status");
db_modify("ALTER TABLE brugere DROP rettigheder");
db_modify("ALTER TABLE brugere DROP kode");
db_modify("ALTER TABLE brugere ADD brugernavn varchar");
db_modify("ALTER TABLE brugere ADD status varchar");
db_modify("ALTER TABLE brugere ADD rettigheder varchar");
db_modify("ALTER TABLE brugere ADD kode varchar");
for ($x = 1; $x <= $linjeantal; $x++) {
db_modify("UPDATE brugere set brugernavn = '{$brugernavn[$x]}', status = '{$status[$x]}',\trettigheder = '{$rettigheder[$x]}', kode = '{$kode[$x]}' where id ={$id[$x]}");
}
db_modify("UPDATE grupper set box1 = '0.605' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.606) {
transaktion("begin");
$x = 0;
$query = db_select("SELECT * FROM enheder");
while ($row = db_fetch_array($query)) {
$x++;
$id[$x] = $row[id];
$betegnelse[$x] = addslashes(trim($row['betegnelse']));
$beskrivelse[$x] = addslashes(trim($row['beskrivelse']));
}
$linjeantal = $x;
db_modify("ALTER TABLE enheder DROP betegnelse");
db_modify("ALTER TABLE enheder DROP beskrivelse");
db_modify("ALTER TABLE enheder ADD betegnelse varchar");
db_modify("ALTER TABLE enheder ADD beskrivelse varchar");
for ($x = 1; $x <= $linjeantal; $x++) {
db_modify("UPDATE enheder set betegnelse = '{$betegnelse[$x]}', beskrivelse = '{$beskrivelse[$x]}' where id ={$id[$x]}");
}
db_modify("UPDATE grupper set box1 = '0.606' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.607) {
transaktion("begin");
$x = 0;
$query = db_select("SELECT * FROM grupper");
while ($row = db_fetch_array($query)) {
$x++;
$id[$x] = $row[id];
$beskrivelse[$x] = addslashes(trim($row['beskrivelse']));
$kode[$x] = addslashes(trim($row['kode']));
$kodenr[$x] = addslashes(trim($row['kodenr']));
$art[$x] = addslashes(trim($row['art']));
$box1[$x] = addslashes(trim($row['box1']));
$box2[$x] = addslashes(trim($row['box2']));
$box3[$x] = addslashes(trim($row['box3']));
$box4[$x] = addslashes(trim($row['box4']));
$box5[$x] = addslashes(trim($row['box5']));
$box6[$x] = addslashes(trim($row['box6']));
$box7[$x] = addslashes(trim($row['box7']));
$box8[$x] = addslashes(trim($row['box8']));
}
$linjeantal = $x;
db_modify("ALTER TABLE grupper DROP beskrivelse");
db_modify("ALTER TABLE grupper DROP kode");
db_modify("ALTER TABLE grupper DROP kodenr");
db_modify("ALTER TABLE grupper DROP art");
db_modify("ALTER TABLE grupper DROP box1");
db_modify("ALTER TABLE grupper DROP box2");
db_modify("ALTER TABLE grupper DROP box3");
db_modify("ALTER TABLE grupper DROP box4");
db_modify("ALTER TABLE grupper DROP box5");
db_modify("ALTER TABLE grupper DROP box6");
db_modify("ALTER TABLE grupper DROP box7");
db_modify("ALTER TABLE grupper DROP box8");
db_modify("ALTER TABLE grupper ADD beskrivelse varchar");
db_modify("ALTER TABLE grupper ADD kode varchar");
db_modify("ALTER TABLE grupper ADD kodenr varchar");
db_modify("ALTER TABLE grupper ADD art varchar");
db_modify("ALTER TABLE grupper ADD box1 varchar");
db_modify("ALTER TABLE grupper ADD box2 varchar");
db_modify("ALTER TABLE grupper ADD box3 varchar");
db_modify("ALTER TABLE grupper ADD box4 varchar");
db_modify("ALTER TABLE grupper ADD box5 varchar");
db_modify("ALTER TABLE grupper ADD box6 varchar");
db_modify("ALTER TABLE grupper ADD box7 varchar");
db_modify("ALTER TABLE grupper ADD box8 varchar");
for ($x = 1; $x <= $linjeantal; $x++) {
db_modify("UPDATE grupper set beskrivelse = '{$beskrivelse[$x]}', kode = '{$kode[$x]}', kodenr = '{$kodenr[$x]}', art = '{$art[$x]}', box1 = '{$box1[$x]}', box2 = '{$box2[$x]}', box3 = '{$box3[$x]}', box4 = '{$box4[$x]}', box5 = '{$box5[$x]}', box6 = '{$box6[$x]}', box7 = '{$box7[$x]}', box8 = '{$box8[$x]}' where id ={$id[$x]}");
}
db_modify("UPDATE grupper set box1 = '0.607' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.608) {
transaktion("begin");
$x = 0;
$query = db_select("SELECT * FROM kassekladde");
while ($row = db_fetch_array($query)) {
$x++;
$id[$x] = $row[id];
$beskrivelse[$x] = addslashes(trim($row['text']));
$d_type[$x] = addslashes(trim($row['d_type']));
$k_type[$x] = addslashes(trim($row['k_type']));
$momsfri[$x] = addslashes(trim($row['momsfri']));
}
$linjeantal = $x;
db_modify("ALTER TABLE kassekladde DROP text");
db_modify("ALTER TABLE kassekladde DROP d_type");
db_modify("ALTER TABLE kassekladde DROP k_type");
db_modify("ALTER TABLE kassekladde DROP momsfri");
db_modify("ALTER TABLE kassekladde ADD beskrivelse varchar");
db_modify("ALTER TABLE kassekladde ADD d_type varchar");
db_modify("ALTER TABLE kassekladde ADD k_type varchar");
db_modify("ALTER TABLE kassekladde ADD momsfri varchar");
for ($x = 1; $x <= $linjeantal; $x++) {
db_modify("UPDATE kassekladde set beskrivelse = '{$beskrivelse[$x]}', d_type = '{$d_type[$x]}', k_type = '{$k_type[$x]}', momsfri = '{$momsfri[$x]}' where id ={$id[$x]}");
}
db_modify("UPDATE grupper set box1 = '0.608' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.609) {
transaktion("begin");
$x = 0;
$query = db_select("SELECT * FROM kontoplan");
while ($row = db_fetch_array($query)) {
$x++;
$id[$x] = $row[id];
$beskrivelse[$x] = addslashes(trim($row['beskrivelse']));
$kontotype[$x] = addslashes(trim($row['kontotype']));
$kontonr[$x] = addslashes(trim($row['kontonr']));
$moms[$x] = addslashes(trim($row['moms']));
$fra_kto[$x] = addslashes(trim($row['fra_kto']));
$til_kto[$x] = addslashes(trim($row['til_kto']));
$lukket[$x] = addslashes(trim($row['lukket']));
}
$linjeantal = $x;
db_modify("ALTER TABLE kontoplan DROP beskrivelse");
db_modify("ALTER TABLE kontoplan DROP kontotype");
db_modify("ALTER TABLE kontoplan DROP kontonr");
db_modify("ALTER TABLE kontoplan DROP moms");
db_modify("ALTER TABLE kontoplan DROP fra_kto");
db_modify("ALTER TABLE kontoplan DROP til_kto");
db_modify("ALTER TABLE kontoplan DROP lukket");
db_modify("ALTER TABLE kontoplan ADD beskrivelse varchar");
db_modify("ALTER TABLE kontoplan ADD kontotype varchar");
db_modify("ALTER TABLE kontoplan ADD kontonr varchar");
db_modify("ALTER TABLE kontoplan ADD moms varchar");
db_modify("ALTER TABLE kontoplan ADD fra_kto varchar");
db_modify("ALTER TABLE kontoplan ADD til_kto varchar");
db_modify("ALTER TABLE kontoplan ADD lukket varchar");
for ($x = 1; $x <= $linjeantal; $x++) {
db_modify("UPDATE kontoplan set beskrivelse = '{$beskrivelse[$x]}', kontotype = '{$kontotype[$x]}',\tkontonr = '{$kontonr[$x]}', moms = '{$moms[$x]}', fra_kto = '{$fra_kto[$x]}', til_kto = '{$til_kto[$x]}', lukket = '{$lukket[$x]}' where id ={$id[$x]}");
}
db_modify("UPDATE grupper set box1 = '0.609' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.61) {
transaktion("begin");
$x = 0;
$query = db_select("SELECT * FROM materialer");
while ($row = db_fetch_array($query)) {
$x++;
$id[$x] = $row[id];
$beskrivelse[$x] = addslashes(trim($row['beskrivelse']));
}
$linjeantal = $x;
db_modify("ALTER TABLE materialer DROP beskrivelse");
db_modify("ALTER TABLE materialer ADD beskrivelse varchar");
for ($x = 1; $x <= $linjeantal; $x++) {
db_modify("UPDATE materialer set beskrivelse = '{$beskrivelse[$x]}' where id ={$id[$x]}");
}
db_modify("UPDATE grupper set box1 = '0.610' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.611) {
transaktion("begin");
$x = 0;
$query = db_select("SELECT * FROM openpost");
while ($row = db_fetch_array($query)) {
$x++;
$id[$x] = $row[id];
$beskrivelse[$x] = addslashes(trim($row['text']));
$konto_nr[$x] = addslashes(trim($row['konto_nr']));
$faktnr[$x] = addslashes(trim($row['faktnr']));
$udlignet[$x] = addslashes(trim($row['udlignet']));
}
$linjeantal = $x;
db_modify("ALTER TABLE openpost DROP text");
db_modify("ALTER TABLE openpost DROP konto_nr");
db_modify("ALTER TABLE openpost DROP faktnr");
db_modify("ALTER TABLE openpost DROP udlignet");
db_modify("ALTER TABLE openpost ADD beskrivelse varchar");
db_modify("ALTER TABLE openpost ADD konto_nr varchar");
db_modify("ALTER TABLE openpost ADD faktnr varchar");
db_modify("ALTER TABLE openpost ADD udlignet varchar");
for ($x = 1; $x <= $linjeantal; $x++) {
db_modify("UPDATE openpost set beskrivelse = '{$beskrivelse[$x]}', konto_nr = '{$konto_nr[$x]}', faktnr = '{$faktnr[$x]}', udlignet = '{$udlignet[$x]}' where id ={$id[$x]}");
}
db_modify("UPDATE grupper set box1 = '0.611' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.612) {
transaktion("begin");
$x = 0;
$query = db_select("SELECT * FROM ordrelinjer");
while ($row = db_fetch_array($query)) {
$x++;
$id[$x] = $row[id];
$beskrivelse[$x] = addslashes(trim($row['text']));
$varenr[$x] = addslashes(trim($row['varenr']));
$enhed[$x] = addslashes(trim($row['enhed']));
$lev_varenr[$x] = addslashes(trim($row['lev_varenr']));
$serienr[$x] = addslashes(trim($row['serienr']));
}
$linjeantal = $x;
db_modify("ALTER TABLE ordrelinjer DROP text");
db_modify("ALTER TABLE ordrelinjer DROP varenr");
db_modify("ALTER TABLE ordrelinjer DROP enhed");
db_modify("ALTER TABLE ordrelinjer DROP lev_varenr");
db_modify("ALTER TABLE ordrelinjer DROP serienr");
db_modify("ALTER TABLE ordrelinjer ADD beskrivelse varchar");
db_modify("ALTER TABLE ordrelinjer ADD varenr varchar");
db_modify("ALTER TABLE ordrelinjer ADD enhed varchar");
db_modify("ALTER TABLE ordrelinjer ADD lev_varenr varchar");
db_modify("ALTER TABLE ordrelinjer ADD serienr varchar");
for ($x = 1; $x <= $linjeantal; $x++) {
db_modify("UPDATE ordrelinjer set beskrivelse = '{$beskrivelse[$x]}', varenr = '{$varenr[$x]}', enhed = '{$enhed[$x]}', lev_varenr = '{$lev_varenr[$x]}', serienr = '{$serienr[$x]}' where id ={$id[$x]}");
}
db_modify("UPDATE grupper set box1 = '0.612' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.613) {
transaktion("begin");
$x = 0;
$query = db_select("SELECT * FROM ordrer");
while ($row = db_fetch_array($query)) {
$x++;
$id[$x] = $row[id];
$firmanavn[$x] = addslashes(trim($row['firmanavn']));
$addr1[$x] = addslashes(trim($row['addr1']));
$addr2[$x] = addslashes(trim($row['addr2']));
$postnr[$x] = addslashes(trim($row['postnr']));
$bynavn[$x] = addslashes(trim($row['bynavn']));
$kontakt[$x] = addslashes(trim($row['kontakt']));
$cvrnr[$x] = addslashes(trim($row['cvrnr']));
$art[$x] = addslashes(trim($row['art']));
$kontonr[$x] = addslashes(trim($row['kontonr']));
$ean[$x] = addslashes(trim($row['ean']));
$institution[$x] = addslashes(trim($row['institution']));
$land[$x] = addslashes(trim($row['land']));
$ref[$x] = addslashes(trim($row['ref']));
$fakturanr[$x] = addslashes(trim($row['fakturanr']));
$kundeordnr[$x] = addslashes(trim($row['kundeordnr']));
$lev_navn[$x] = addslashes(trim($row['lev_navn']));
$lev_addr1[$x] = addslashes(trim($row['lev_addr1']));
$lev_addr2[$x] = addslashes(trim($row['lev_addr2']));
$lev_postnr[$x] = addslashes(trim($row['lev_postnr']));
$lev_bynavn[$x] = addslashes(trim($row['lev_bynavn']));
$lev_kontakt[$x] = addslashes(trim($row['lev_kontakt']));
}
$linjeantal = $x;
db_modify("ALTER TABLE ordrer DROP firmanavn");
db_modify("ALTER TABLE ordrer DROP addr1");
db_modify("ALTER TABLE ordrer DROP addr2");
db_modify("ALTER TABLE ordrer DROP postnr");
db_modify("ALTER TABLE ordrer DROP bynavn");
db_modify("ALTER TABLE ordrer DROP kontakt");
db_modify("ALTER TABLE ordrer DROP cvrnr");
db_modify("ALTER TABLE ordrer DROP art");
db_modify("ALTER TABLE ordrer DROP kontonr");
db_modify("ALTER TABLE ordrer DROP ean");
db_modify("ALTER TABLE ordrer DROP institution");
db_modify("ALTER TABLE ordrer DROP land");
db_modify("ALTER TABLE ordrer DROP ref");
db_modify("ALTER TABLE ordrer DROP fakturanr");
db_modify("ALTER TABLE ordrer DROP kundeordnr");
db_modify("ALTER TABLE ordrer DROP lev_navn");
db_modify("ALTER TABLE ordrer DROP lev_addr1");
db_modify("ALTER TABLE ordrer DROP lev_addr2");
db_modify("ALTER TABLE ordrer DROP lev_postnr");
db_modify("ALTER TABLE ordrer DROP lev_bynavn");
db_modify("ALTER TABLE ordrer DROP lev_kontakt");
db_modify("ALTER TABLE ordrer ADD firmanavn varchar");
db_modify("ALTER TABLE ordrer ADD addr1 varchar");
db_modify("ALTER TABLE ordrer ADD addr2 varchar");
db_modify("ALTER TABLE ordrer ADD postnr varchar");
db_modify("ALTER TABLE ordrer ADD bynavn varchar");
db_modify("ALTER TABLE ordrer ADD kontakt varchar");
db_modify("ALTER TABLE ordrer ADD cvrnr varchar");
db_modify("ALTER TABLE ordrer ADD art varchar");
db_modify("ALTER TABLE ordrer ADD kontonr varchar");
db_modify("ALTER TABLE ordrer ADD ean varchar");
db_modify("ALTER TABLE ordrer ADD institution varchar");
db_modify("ALTER TABLE ordrer ADD land varchar");
db_modify("ALTER TABLE ordrer ADD ref varchar");
db_modify("ALTER TABLE ordrer ADD fakturanr varchar");
db_modify("ALTER TABLE ordrer ADD kundeordnr varchar");
db_modify("ALTER TABLE ordrer ADD lev_navn varchar");
db_modify("ALTER TABLE ordrer ADD lev_addr1 varchar");
db_modify("ALTER TABLE ordrer ADD lev_addr2 varchar");
db_modify("ALTER TABLE ordrer ADD lev_postnr varchar");
db_modify("ALTER TABLE ordrer ADD lev_bynavn varchar");
db_modify("ALTER TABLE ordrer ADD lev_kontakt varchar");
for ($x = 1; $x <= $linjeantal; $x++) {
db_modify("UPDATE ordrer set firmanavn = '{$firmanavn[$x]}', addr1 = '{$addr1[$x]}',\taddr2 = '{$addr2[$x]}', postnr = '{$postnr[$x]}', bynavn = '{$bynavn[$x]}', kontakt = '{$kontakt[$x]}', cvrnr = '{$cvrnr[$x]}', art = '{$art[$x]}', kontonr = '{$kontonr[$x]}', ean = '{$ean[$x]}', institution = '{$institution[$x]}', land = '{$land[$x]}', ref = '{$ref[$x]}', fakturanr = '{$fakturanr[$x]}', kundeordnr = '{$kundeordnr[$x]}', lev_navn = '{$lev_navn[$x]}',\tlev_addr1 = '{$lev_addr1[$x]}',\tlev_addr2 = '{$lev_addr2[$x]}', lev_postnr = '{$lev_postnr[$x]}', lev_bynavn = '{$lev_bynavn[$x]}', lev_kontakt = '{$lev_kontakt[$x]}' where id ={$id[$x]}");
}
db_modify("UPDATE grupper set box1 = '0.613' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.614) {
transaktion("begin");
$x = 0;
$query = db_select("SELECT * FROM serienr");
while ($row = db_fetch_array($query)) {
$x++;
$id[$x] = $row[id];
$serienr[$x] = addslashes(trim($row['serienr']));
}
$linjeantal = $x;
db_modify("ALTER TABLE serienr DROP serienr");
db_modify("ALTER TABLE serienr ADD serienr varchar");
for ($x = 1; $x <= $linjeantal; $x++) {
db_modify("UPDATE serienr set serienr = '{$serienr[$x]}' where id ={$id[$x]}");
}
db_modify("UPDATE grupper set box1 = '0.614' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.615) {
transaktion("begin");
$x = 0;
$query = db_select("SELECT * FROM transaktioner");
while ($row = db_fetch_array($query)) {
$x++;
$id[$x] = $row[id];
$beskrivelse[$x] = addslashes(trim($row['text']));
$faktura[$x] = addslashes(trim($row['faktura']));
}
$linjeantal = $x;
db_modify("ALTER TABLE transaktioner DROP text");
db_modify("ALTER TABLE transaktioner DROP faktura");
db_modify("ALTER TABLE transaktioner ADD beskrivelse varchar");
db_modify("ALTER TABLE transaktioner ADD faktura varchar");
for ($x = 1; $x <= $linjeantal; $x++) {
db_modify("UPDATE transaktioner set beskrivelse = '{$beskrivelse[$x]}', faktura = '{$faktura[$x]}' where id ={$id[$x]}");
}
db_modify("UPDATE grupper set box1 = '0.615' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.616) {
transaktion("begin");
$x = 0;
$query = db_select("SELECT * FROM vare_lev");
while ($row = db_fetch_array($query)) {
$x++;
$id[$x] = $row[id];
$lev_varenr[$x] = addslashes(trim($row['lev_varenr']));
}
$linjeantal = $x;
db_modify("ALTER TABLE vare_lev DROP lev_varenr");
db_modify("ALTER TABLE vare_lev ADD lev_varenr varchar");
for ($x = 1; $x <= $linjeantal; $x++) {
db_modify("UPDATE vare_lev set lev_varenr = '{$lev_varenr[$x]}' where id ={$id[$x]}");
}
db_modify("UPDATE grupper set box1 = '0.616' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.617) {
transaktion("begin");
$x = 0;
$query = db_select("SELECT * FROM varer");
while ($row = db_fetch_array($query)) {
$x++;
$id[$x] = $row[id];
$beskrivelse[$x] = addslashes(trim($row['text']));
$varenr[$x] = addslashes(trim($row['varenr']));
$enhed[$x] = addslashes(trim($row['enhed']));
$enhed2[$x] = addslashes(trim($row['enhed2']));
$gruppe[$x] = addslashes(trim($row['gruppe']));
$lukket[$x] = addslashes(trim($row['lukket']));
$serienr[$x] = addslashes(trim($row['serienr']));
$samlevare[$x] = addslashes(trim($row['samlevare']));
$delvare[$x] = addslashes(trim($row['delvare']));
}
$linjeantal = $x;
db_modify("ALTER TABLE varer DROP text");
db_modify("ALTER TABLE varer DROP varenr");
db_modify("ALTER TABLE varer DROP enhed");
db_modify("ALTER TABLE varer DROP enhed2");
db_modify("ALTER TABLE varer DROP gruppe");
db_modify("ALTER TABLE varer DROP lukket");
db_modify("ALTER TABLE varer DROP serienr");
db_modify("ALTER TABLE varer DROP samlevare");
db_modify("ALTER TABLE varer DROP delvare");
db_modify("ALTER TABLE varer ADD beskrivelse varchar");
db_modify("ALTER TABLE varer ADD varenr varchar");
db_modify("ALTER TABLE varer ADD enhed varchar");
db_modify("ALTER TABLE varer ADD enhed2 varchar");
db_modify("ALTER TABLE varer ADD gruppe varchar");
db_modify("ALTER TABLE varer ADD lukket varchar");
db_modify("ALTER TABLE varer ADD serienr varchar");
db_modify("ALTER TABLE varer ADD samlevare varchar");
db_modify("ALTER TABLE varer ADD delvare varchar");
for ($x = 1; $x <= $linjeantal; $x++) {
db_modify("UPDATE varer set beskrivelse = '{$beskrivelse[$x]}',\tvarenr = '{$varenr[$x]}',\tenhed = '{$enhed[$x]}', enhed2 = '{$enhed2[$x]}', gruppe = '{$gruppe[$x]}', lukket = '{$lukket[$x]}', serienr = '{$serienr[$x]}', samlevare = '{$samlevare[$x]}', delvare = '{$delvare[$x]}' where id ={$id[$x]}");
}
db_modify("UPDATE grupper set box1 = '0.617' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.618) {
transaktion("begin");
db_modify("delete FROM grupper where kodenr!='1' and art='PV' and box1='lpr' and box3='on'");
db_modify("update grupper set beskrivelse='Output', box1='/usr/bin/lpr', box2='/usr/bin/ps2pdf' where kodenr='1' and art='PV' and box1='lpr' and box3='on'");
transaktion("commit");
db_modify("UPDATE grupper set box1 = '0.618' where art = 'VE'");
}
if ($dbver < 0.73) {
transaktion("begin");
db_modify("update kontoplan set primo = 0 where regnskabsaar > 1 and kontotype != 'S'");
transaktion("commit");
db_modify("UPDATE grupper set box1 = '0.73' where art = 'VE'");
}
if ($dbver < 0.82) {
transaktion("begin");
db_modify("ALTER TABLE ordrer ADD kostpris numeric");
transaktion("commit");
db_modify("UPDATE grupper set box1 = '0.82' where art = 'VE'");
}
if ($dbver < 0.83) {
transaktion("begin");
db_modify("CREATE TABLE reservation (linje_id integer, batch_kob_id integer, batch_salg_id integer, vare_id integer, antal numeric)");
# db_modify("ALTER TABLE batch_kob ADD reserveret numeric");
db_modify("UPDATE grupper set box1 = '0.83' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.91) {
transaktion("begin");
db_modify("CREATE TABLE formularer (id serial NOT NULL, formular integer, art integer, beskrivelse varchar, justering varchar, xa numeric, ya numeric, xb numeric, yb numeric, str numeric, color integer, font varchar, fed varchar, kursiv varchar, side varchar, PRIMARY KEY (id))");
$fp = fopen("../importfiler/formular.txt", "r");
if ($fp) {
while (!feof($fp)) {
list($formular, $art, $beskrivelse, $xa, $ya, $xb, $yb, $justering, $str, $color, $font, $fed, $kursiv, $side) = split(chr(9), fgets($fp));
if ($xa > 0) {
$justering = trim($justering);
$form = trim($font);
$fed = trim($fed);
$kursiv = trim($kursiv);
$side = trim($side);
$xa = $xa * 1;
$ya = $ya * 1;
$xb = $xb * 1;
$yb = $yb * 1;
$str = $str * 1;
$color = $color * 1;
db_modify("insert into formularer (formular, art, beskrivelse, xa, ya, xb, yb, justering, str, color, font, fed, kursiv, side) values\t('{$formular}', '{$art}', '{$beskrivelse}', '{$xa}', '{$ya}', '{$xb}', '{$yb}', '{$justering}', '{$str}', '{$color}', '{$font}', '{$fed}', '{$kursiv}', '{$side}')");
}
}
fclose($fp);
}
db_modify("ALTER TABLE brugere ADD ansat_id integer");
db_modify("UPDATE grupper set box1 = '0.91' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.92) {
transaktion("begin");
db_modify("ALTER TABLE batch_kob ADD fakturadate date");
$x = 0;
$query = db_select("SELECT id, ordre_id FROM batch_kob order by id");
while ($row = db_fetch_array($query)) {
$x++;
$id[$x] = $row[id];
$ordre_id[$x] = $row[ordre_id];
}
$linjeantal = $x;
for ($x = 1; $x <= $linjeantal; $x++) {
if ($ordre_id[$x]) {
$query = db_select("SELECT id, fakturadate FROM ordrer where id = {$ordre_id[$x]}");
$row = db_fetch_array($query);
if ($row[fakturadate]) {
db_modify("UPDATE batch_kob set fakturadate = '{$row['fakturadate']}' where id = {$id[$x]}");
}
}
}
db_modify("ALTER TABLE batch_salg ADD fakturadate date");
$x = 0;
$query = db_select("SELECT id, ordre_id FROM batch_salg order by id");
while ($row = db_fetch_array($query)) {
$x++;
$id[$x] = $row[id];
$ordre_id[$x] = $row[ordre_id];
}
$linjeantal = $x;
for ($x = 1; $x <= $linjeantal; $x++) {
if ($ordre_id[$x]) {
$query = db_select("SELECT id, fakturadate FROM ordrer where id = {$ordre_id[$x]}");
$row = db_fetch_array($query);
if ($row[fakturadate]) {
db_modify("UPDATE batch_salg set fakturadate = '{$row['fakturadate']}' where id = {$id[$x]}");
}
} else {
db_modify("delete FROM batch_salg where id={$id[$x]}");
}
}
db_modify("UPDATE grupper set box1 = '0.920' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.921) {
transaktion("begin");
db_modify("ALTER TABLE ordrelinjer ADD kred_linje_id integer");
$x = 0;
$query = db_select("SELECT id FROM ordrer where art='DK' or art='KK'");
while ($row = db_fetch_array($query)) {
$x++;
$ordre_id[$x] = $row[id];
}
$ordreantal = $x;
for ($x = 1; $x <= $ordreantal; $x++) {
$query = db_select("SELECT id, antal FROM ordrelinjer where ordre_id={$ordre_id[$x]}");
while ($row = db_fetch_array($query)) {
if ($row[antal]) {
db_modify("UPDATE ordrelinjer set antal={$row['antal']}*-1 where id = {$row['id']}");
}
}
}
db_modify("UPDATE grupper set box1 = '0.921' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.9340000000000001) {
transaktion("begin");
# db_modify("CREATE TABLE lagerlog (id serial NOT NULL, lagernr integer, date date, antal numeric, pris numeric, PRIMARY KEY (id))");
db_modify("CREATE TABLE lagerstatus (id serial NOT NULL, lager integer, vare_id integer, beholdning numeric, PRIMARY KEY (id))");
db_modify("ALTER TABLE ansatte ADD afd integer");
db_modify("ALTER TABLE ansatte ADD privattlf varchar");
db_modify("ALTER TABLE ansatte ADD initialer varchar");
db_modify("ALTER TABLE kassekladde ADD afd integer");
db_modify("ALTER TABLE transaktioner ADD afd integer");
db_modify("ALTER TABLE reservation ADD lager integer");
db_modify("ALTER TABLE batch_kob ADD lager integer");
db_modify("UPDATE grupper set box1 = '0.934' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.9350000000000001) {
transaktion("begin");
$x = 0;
$query = db_select("SELECT id, kontonr FROM kontoplan order by id");
while ($row = db_fetch_array($query)) {
$x++;
$id[$x] = $row[id];
$kontonr[$x] = $row[kontonr] * 1;
}
$linjeantal = $x;
db_modify("ALTER TABLE kontoplan DROP kontonr");
db_modify("ALTER TABLE kontoplan ADD kontonr integer");
for ($x = 1; $x <= $linjeantal; $x++) {
db_modify("UPDATE kontoplan set kontonr = {$kontonr[$x]} where id = {$id[$x]}");
}
db_modify("UPDATE grupper set box1 = '0.935' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.9360000000000001) {
transaktion("begin");
$x = 0;
$query = db_select("SELECT vare_id, rest, lager FROM batch_kob where rest != 0 order by vare_id");
while ($row = db_fetch_array($query)) {
$x++;
$vare_id[$x] = $row[vare_id];
$lager[$x] = $row[lager] * 1;
$antal[$x] = $row[rest] * 1;
}
$linjeantal = $x;
db_modify("UPDATE lagerstatus set beholdning = 0 where beholdning != 0");
for ($x = 1; $x <= $linjeantal; $x++) {
if ($row = db_fetch_array(db_select("SELECT gruppe FROM varer where id = {$vare_id[$x]}"))) {
if ($row = db_fetch_array(db_select("SELECT id FROM grupper where art = 'VG' and kodenr = '{$row['gruppe']}' and box8 = 'on'"))) {
if ($row = db_fetch_array(db_select("SELECT id, beholdning FROM lagerstatus where vare_id = {$vare_id[$x]} and lager = {$lager[$x]}"))) {
db_modify("UPDATE lagerstatus set beholdning = {$antal[$x]}+{$row['beholdning']} where id = {$row['id']}");
} else {
db_modify("insert into lagerstatus (lager, vare_id, beholdning) values\t('{$lager[$x]}', '{$vare_id[$x]}', '{$antal[$x]}')");
}
}
} else {
db_modify("delete FROM lagerstatus where vare_id={$vare_id[$x]}");
}
}
db_modify("UPDATE batch_kob set lager = 0 where lager\t!= 0");
db_modify("UPDATE grupper set box1 = '0.936' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.9370000000000001) {
transaktion("begin");
db_modify("ALTER TABLE ordrelinjer ADD momsfri varchar");
db_modify("ALTER TABLE ordrer ADD moms numeric");
db_modify("UPDATE grupper set box7 = 'on' where art = 'VG' and box5 = ''");
db_modify("UPDATE grupper set box5 = '', box6 = '' where art = 'VG' and box7 != 'on'");
db_modify("UPDATE grupper set box1 = '0.937' where art = 'VE'");
transaktion("commit");
}
if ($dbver < 0.956) {
transaktion("begin");
db_modify("ALTER TABLE varer ADD provisionsfri VARCHAR");
db_modify("UPDATE grupper set box1 = '0.956' where art = 'VE'");
transaktion("commit");
}
db_modify("UPDATE grupper set box1 = '1.0.0' where art = 'VE'");
}
function flet($id, $varenr, $flet_id, $flet_vnr)
{
if ($r = db_fetch_array(db_select("select id,shop_id from shop_varer where saldi_id = '{$id}'", __FILE__ . " linje " . __LINE__))) {
$shop_id = $r['shop_id'];
$r = db_fetch_array(db_select("select samlevare from varer where id = '{$flet_id}'", __FILE__ . " linje " . __LINE__));
$fletsamlevare = $r['samlevare'];
if ($r = db_fetch_array(db_select("select id,shop_id from shop_varer where saldi_id = '{$flet_id}'", __FILE__ . " linje " . __LINE__))) {
if ($shop_id != $r['shop_id']) {
print tekstboks("Varenummer: {$varenr} har en shop_relation til shop vare med id: {$shop_id} og {$fletvnr} relaterer til shop vare {$r['shop_id']}<br> Sammenlægning kan ikke gennemføres");
print "<meta http-equiv=\"refresh\" content=\"2;URL=varekort.php?id={$id}\">";
exit;
}
}
}
transaktion('begin');
print tekstboks("Varenummer: {$varenr} sammenlægges med {$fletvnr}");
$r = db_fetch_array(db_select("select beholdning from varer where id = '{$id}'", __FILE__ . " linje " . __LINE__));
if ($r['beholdning']) {
$fletbeholdning = $r['beholdning'];
if ($fletsamlevare) {
$x = 0;
$q = db_select("select * from styklister where indgaar_i='{$flet_id}'");
while ($r = db_fetch_array($q)) {
$vare_id[$x] = $r['vare_id'];
$antal[$x] = $r['antal'];
$x++;
}
for ($x = 0; $x < count($vare_id); $x++) {
$r = db_fetch_array(db_select("select gruppe,beholdning from varer where id='{$vare_id[$x]}'", __FILE__ . " linje " . __LINE__));
$r2 = db_fetch_array(db_select("select box8 from grupper where art='VG' and kodenr='{$r['gruppe']}'", __FILE__ . " linje " . __LINE__));
if ($r2['box8'] == 'on') {
$ny_beholdning = $r['beholdning'] + $antal[$x] * $fletbeholdning;
db_modify("update varer set beholdning = '{$ny_beholdning}' where id ='{$vare_id[$x]}'", __FILE__ . " linje " . __LINE__);
}
}
} else {
db_modify("update varer set beholdning=beholdning+{$r['beholdning']} where id = '{$flet_id}'", __FILE__ . " linje " . __LINE__);
}
}
db_modify("update batch_salg set vare_id = '{$flet_id}' where vare_id = '{$id}'", __FILE__ . " linje " . __LINE__);
db_modify("update batch_kob set vare_id = '{$flet_id}' where vare_id = '{$id}'", __FILE__ . " linje " . __LINE__);
db_modify("update ordrelinjer set vare_id = '{$flet_id}', varenr = '{$flet_vnr}' where vare_id = '{$id}'", __FILE__ . " linje " . __LINE__);
db_modify("update vare_lev set vare_id = '{$flet_id}' where vare_id = '{$id}'", __FILE__ . " linje " . __LINE__);
$r = db_fetch_array(db_select("select id from shop_varer where saldi_id = '{$flet_id}'", __FILE__ . " linje " . __LINE__));
if (!$r['saldi_id']) {
db_modify("update shop_varer set saldi_id = '{$flet_id}' where saldi_id = '{$id}'", __FILE__ . " linje " . __LINE__);
}
db_modify("delete from varer where id = '{$id}'", __FILE__ . " linje " . __LINE__);
transaktion('commit');
print "<meta http-equiv=\"refresh\" content=\"0;URL=varekort.php?id={$flet_id}\">";
}
}
$query = db_select("select id from kontoplan where kontonr = {$kontonr} and regnskabsaar = '{$regnaar}'", __FILE__ . " linje " . __LINE__);
$row = db_fetch_array($query);
$id = $row['id'];
}
} elseif ($id > 0) {
if (!$fra_kto) {
$fra_kto = 0;
}
if (!$til_kto) {
$til_kto = 0;
}
if ($r = db_fetch_array(db_select("select id from kontoplan where kontonr = {$kontonr} and regnskabsaar = '{$regnaar}' and id!='{$id}'", __FILE__ . " linje " . __LINE__))) {
print "<BODY onLoad=\"javascript:alert('Der findes allerede en konto med nr: {$kontonr}')\">";
} else {
db_modify("update kontoplan set kontonr = {$kontonr}, beskrivelse = '{$beskrivelse}', kontotype = '{$kontotype}', moms = '{$moms}', fra_kto = '{$fra_kto}', til_kto = '{$til_kto}', genvej='{$genvej}', lukket = '{$lukket}' where id = '{$id}'", __FILE__ . " linje " . __LINE__);
}
}
genberegn($regnaar);
}
if ($id > 0) {
$query = db_select("select * from kontoplan where id = '{$id}'", __FILE__ . " linje " . __LINE__);
if ($row = db_fetch_array($query)) {
$id = $row['id'];
$kontonr = $row['kontonr'] * 1;
$beskrivelse = htmlentities(stripslashes($row['beskrivelse']), ENT_COMPAT, $charset);
$kontotype = $row['kontotype'];
# $katagori=$row['katagori'];
$moms = $row['moms'];
$fra_kto = $row['fra_kto'];
# $til_kto=$row['til_kto'];
function posbogfor($kasse, $regnstart)
{
global $afd;
global $brugernavn;
#cho $_POST['udtages']."<br>";
$udtages = if_isset($_POST['udtages']);
if ($udtages) {
$udtages = usdecimal($udtages) * 1;
}
#cho "select ansat_id from brugere where brugernavn = '$brugernavn'<br>";
$r = db_fetch_array(db_select("select ansat_id from brugere where brugernavn = '{$brugernavn}'", __FILE__ . " linje " . __LINE__));
$ansat_id = $r['ansat_id'];
$r = db_fetch_array(db_select("select box2,box3 from grupper where art = 'POS' and kodenr = '1'", __FILE__ . " linje " . __LINE__));
$kassekonti = explode(chr(9), $r['box2']);
$kassekonto = $kassekonti[$kasse - 1];
$afdelinger = explode(chr(9), $r['box3']);
$afd = $afdelinger[$kasse - 1] * 1;
$r = db_fetch_array(db_select("select box8 from grupper where art = 'POS' and kodenr = '2'", __FILE__ . " linje " . __LINE__));
$mellemkonti = explode(chr(9), $r['box8']);
$mellemkonto = $mellemkonti[$kasse - 1];
$x = 0;
#cho "select distinct(fakturadate) as fakturadate from ordrer where felt_5='$kasse' and konto_id= '0' and art = 'PO' and status='3' and fakturadate >= '$regnstart' order by fakturadate<br>\n";
$q = db_select("select distinct(fakturadate) as fakturadate from ordrer where felt_5='{$kasse}' and (konto_id='0' or betalingsbet='Kontant') and art = 'PO' and status='3' and fakturadate >= '{$regnstart}' order by fakturadate", __FILE__ . " linje " . __LINE__);
while ($r = db_fetch_array($q)) {
if ($r['fakturadate']) {
$x++;
$fakturadate[$x] = $r['fakturadate'];
#cho "$fakturadate[$x]<br>\n";
}
}
$x = 0;
#cho "select distinct(felt_1) as betaling from ordrer where felt_5='$kasse' and konto_id= '0' and art = 'PO' and status='3' and fakturadate >= '$regnstart' order by felt_1<br>\n";
$q = db_select("select distinct(felt_1) as betaling from ordrer where felt_5='{$kasse}' and (konto_id='0' or betalingsbet='Kontant') and art = 'PO' and status='3' and fakturadate >= '{$regnstart}' order by felt_1", __FILE__ . " linje " . __LINE__);
while ($r = db_fetch_array($q)) {
if ($r['betaling']) {
$x++;
$betaling[$x] = $r['betaling'];
#cho "$betaling[$x]<br>\n";
}
}
$x = 0;
#cho "select distinct(felt_3) as betaling2 from ordrer where felt_5='$kasse' and konto_id= '0' and art = 'PO' and status='3' and fakturadate >= '$regnstart' order by felt_3<br>\n";
$q = db_select("select distinct(felt_3) as betaling2 from ordrer where felt_5='{$kasse}' and (konto_id='0' or betalingsbet='Kontant') and art = 'PO' and status='3' and fakturadate >= '{$regnstart}' order by felt_3", __FILE__ . " linje " . __LINE__);
while ($r = db_fetch_array($q)) {
if ($r['betaling2']) {
$x++;
$betaling2[$x] = $r['betaling2'];
}
}
for ($x = 1; $x <= count($fakturadate); $x++) {
for ($y = 0; $y <= count($betaling); $y++) {
for ($z = 0; $z <= count($betaling2); $z++) {
$id = NULL;
$q = db_select("select id from ordrer where felt_5='{$kasse}' and fakturadate='{$fakturadate[$x]}' and felt_1='{$betaling[$y]}' and felt_3='{$betaling2[$z]}' and (konto_id='0' or betalingsbet='Kontant') and art = 'PO' and status='3'", __FILE__ . " linje " . __LINE__);
while ($r = db_fetch_array($q)) {
if ($id) {
$id .= "," . $r['id'];
} else {
$id = $r['id'];
}
}
$r = db_fetch_array(db_select("select box9 from grupper where art='POS' and kodenr='1'", __FILE__ . " linje " . __LINE__));
if ($id) {
transaktion('begin');
$svar = bogfor_nu("{$id}", "Dagsafslutning");
if ($svar && $svar != 'OK') {
#cho "$svar<br>";
print "<BODY onLoad=\"javascript:alert('Der er konstateret en uoverenstemmelse i posteringssummen. \\nKontakt Danosoft på telefon 4690 2208 eller 2066 9820')\">\n";
print "<meta http-equiv=\"refresh\" content=\"0;URL=pos_ordre.php?id={$id}\">\n";
} else {
transaktion('commit');
}
}
}
}
}
if ($kassekonto && $mellemkonto && $udtages) {
$dd = date("Y-m-d");
$logtime = date("H:i");
if ($udtages > 0) {
$debet = 0;
$kredit = $udtages;
} else {
$debet = $udtages;
$kredit = 0;
}
db_modify("insert into transaktioner (bilag,transdate,beskrivelse,kontonr,faktura,debet,kredit,kladde_id,afd,logdate,logtime,projekt,ansat,ordre_id) values ('0','{$dd}','Overført til mellemkonto fra kasse {$kasse}','{$kassekonto}','0','{$debet}','{$kredit}',0,'{$afd}','{$dd}','{$logtime}','','{$ansat_id}','0')", __FILE__ . " linje " . __LINE__);
db_modify("insert into transaktioner (bilag,transdate,beskrivelse,kontonr,faktura,debet,kredit,kladde_id,afd,logdate,logtime,projekt,ansat,ordre_id) values ('0','{$dd}','Overført til mellemkonto fra kasse {$kasse}','{$mellemkonto}','0','{$kredit}','{$debet}',0,'{$afd}','{$dd}','{$logtime}','','{$ansat_id}','0')", __FILE__ . " linje " . __LINE__);
}
}
$vis_liste = $vis_liste . '0';
}
}
# brugernavn i box1 er en pre 2.0.7 ting - fremover skal der identificeres paa kodenr / bruger_id.
db_modify("update grupper set {$box}='{$vis_liste}', kodenr = '{$bruger_id}', kode = '{$brugernavn}' where art = 'DGV' and (box1 = '{$brugernavn}' or kodenr = '{$bruger_id}')", __FILE__ . " linje " . __LINE__);
if ($popup) {
print "<BODY onLoad=\"javascript=opener.location.reload();\">";
}
print "<meta http-equiv=\"refresh\" content=\"0;URL={$returside}\">";
}
print "<div align=\"center\">\n<table width=\"100%\" height=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"><tbody>\n\t<tr><td height = \"25\" align=\"center\" valign=\"top\">\n\t\t<table width=\"100%\" align=\"center\" border=\"0\" cellspacing=\"4\" cellpadding=\"0\"><tbody>\n\t\t\t<td width=\"10%\" align=center><div class=\"top_bund\"><a href={$returside} accesskey=L>Luk</a></div></td>\n\t\t\t<td width=\"80%\" align=center><div class=\"top_bund\">{$title}</a></div></td>\n\t\t\t<td width=\"10%\" align=center><div class=\"top_bund\"><br></div></td>\n\t\t\t </tr>\n\t\t\t</tbody></table>\n\t</td></tr>\n <tr><td valign=\"top\">\n<table cellpadding=\"1\" cellspacing=\"1\" border=\"0\" width=\"100%\" valign = \"top\">\n<tbody>";
print "<form name=grpvisning action=grpvisning.php?sort={$sort}&side={$side} method=post>";
if ($r = db_fetch_array(db_select("select * from grupper where art = 'DGV' and (box1 = '{$brugernavn}' or kodenr = '{$bruger_id}')", __FILE__ . " linje " . __LINE__))) {
$vis_liste = $r[$box];
} else {
db_modify("insert into grupper(beskrivelse, art, kode, kodenr, {$box})values('historikvisning', 'HV','{$brugernavn}', '{$bruger_id}', '1')", __FILE__ . " linje " . __LINE__);
$vis_liste = '0';
}
print "<tr><td colspan=3>Vælg hvilke kundegrupper der skal være synlige på oversigten</td></tr>";
print "<tr><td colspan=3>Hvis intet er valgt, vil alt blive vist!</td></tr>";
print "<tr><td colspan=3><hr></td></tr>";
$q = db_select("select * from grupper where art = 'DG' order by beskrivelse", __FILE__ . " linje " . __LINE__);
$x = -1;
while ($r = db_fetch_array($q)) {
$x++;
if (substr($vis_liste, $x, 1) == '1') {
$tmp = 'checked';
} else {
$tmp = '';
}
print "<tr><td><input name= box{$x} type=checkbox {$tmp}> {$r['beskrivelse']}</td></tr>";
function invoice($string)
{
$webservice = '1';
$fp = fopen("../temp/invoice.log", "w");
list($s_id, $tmp) = explode(chr(9), $string);
if (!$s_id) {
return '1' . chr(9) . "Missing session ID";
}
# include("../includes/select.php");
include "../includes/connect.php";
include "../includes/online.php";
include "../includes/std_func.php";
include "../includes/ordrefunc.php";
include "../includes/formfunk.php";
$linje = NULL;
$ordre_id = str_replace($s_id, "", $string);
$ordre_id = str_replace(chr(9), "", $ordre_id);
$ordre_id = str_replace(chr(10), "", $ordre_id);
$ordre_id = str_replace(chr(13), "", $ordre_id);
# $ordre_id=str_replace(" ","",$ordre_id);
$ordre_id = strtolower($ordre_id);
list($table, $tmp) = explode("set", $ordre_id, 2);
$table = trim($table);
$r = db_fetch_array(db_select("select momssats from ordrer where id = '{$ordre_id}'", __FILE__ . " linje " . __LINE__));
$momssats = $r['momssats'] * 1;
$x = 0;
$ordresum = 0;
$momssum = 0;
$kostsum = 0;
$momsdiff = 0;
$q = db_select("select * from ordrelinjer where ordre_id = '{$ordre_id}'", __FILE__ . " linje " . __LINE__);
while ($r = db_fetch_array($q)) {
if ($r['vare_id']) {
$linjesum = $r['pris'] * $r['antal'] - $r['pris'] * $r['antal'] * $r['rabat'] / 100;
$ordresum += $linjesum;
$linjemoms = $linjesum * $r['momssats'] / 100;
$momssum += $linjemoms;
if ($r['momssats'] != $momssats || $r['momsfri']) {
$momsdiff = 1;
}
$kostsum += $r['kostpris'] * $r['antal'];
}
$ordresum = afrund($ordresum, 2);
if (!$momsdiff) {
$momssum = $ordresum * $momssats / 100;
}
$momssum = afrund($momssum, 2);
}
transaktion('begin');
$linje = "update ordrer set status = '2',levdate = ordredate,fakturadate = ordredate,sum='{$ordresum}',moms='{$momssum}',udskriv_til='email',mail_fakt='on',momssats='{$momssats}',kostpris='{$kostsum}',projekt='' where id = '{$ordre_id}'";
fwrite($fp, $linje . "\n");
$svar = db_modify($linje, __FILE__ . " linje " . __LINE__);
list($fejl, $svar) = explode(chr(9), $svar);
if ($fejl) {
return $fejl . chr(9) . $svar;
}
$linje = "update ordrelinjer set projekt = '' where ordre_id = '{$ordre_id}'";
fwrite($fp, $linje . "\n");
$svar = db_modify($linje, __FILE__ . " linje " . __LINE__);
list($fejl, $svar) = explode(chr(9), $svar);
if ($fejl) {
return $fejl . chr(9) . $svar;
}
$linje = "update ordrelinjer set leveres = antal where ordre_id = '{$ordre_id}' and vare_id>'0'";
fwrite($fp, $linje . "\n");
$svar = db_modify($linje, __FILE__ . " linje " . __LINE__);
list($fejl, $svar) = explode(chr(9), $svar);
if ($fejl) {
return $fejl . chr(9) . $svar;
}
$linje = "levering({$ordre_id},'on','','on')";
fwrite($fp, $linje . "\n");
$svar = levering($ordre_id, 'on', '', 'on');
if ($svar != 'OK') {
return '1' . chr(9) . $svar;
}
$linje = "update ordrelinjer set leveret = antal,leveres='0' where ordre_id = '{$ordre_id}' and vare_id>'0'";
fwrite($fp, $linje . "\n");
$svar = db_modify($linje, __FILE__ . " linje " . __LINE__);
$linje = "bogfor({$ordre_id},'on')";
fwrite($fp, $linje . "\n");
$svar = bogfor($ordre_id, 'on');
list($fejl, $svar) = explode(chr(9), $svar);
fwrite($fp, $fejl . " " . $svar . "\n");
if ($fejl != 'OK') {
$linje = "{$fejl}";
# fwrite($fp,$linje."\n");
return '1' . chr(9) . $fejl;
} else {
transaktion('commit');
}
$linje = "formularprint({$ordre_id},'4','1',{$charset},'email')";
fwrite($fp, $linje . "\n");
$svar = formularprint($ordre_id, '4', '1', $charset, 'email');
fwrite($fp, $linje . "Svar " . $svar . "\n");
if ($svar && $svar != 'OK') {
return '1' . chr(9) . $svar;
} else {
fclose($fp);
return '0' . chr(9) . $ordre_id;
}
}
isset($_GET['start']) ? $start = $_GET['start'] : ($start = 1);
$s**t = $start + 999;
$x = 0;
$r = db_fetch_array(db_select("SELECT relfilenode FROM pg_class WHERE relname = 'variant_varer'", __FILE__ . " linje " . __LINE__));
$relfilenode = $r['relfilenode'] * 1;
$r = db_fetch_array(db_select("SELECT * FROM pg_attribute WHERE attrelid= '{$relfilenode}' and attname = 'variant_salgspris'", __FILE__ . " linje " . __LINE__));
if ($r['attisdropped'] != 'f' || !$r['attname']) {
db_modify("alter TABLE variant_varer ADD variant_salgspris numeric(15,3)", __FILE__ . " linje " . __LINE__);
}
$r = db_fetch_array(db_select("SELECT * FROM pg_attribute WHERE attrelid= '{$relfilenode}' and attname = 'variant_kostpris'", __FILE__ . " linje " . __LINE__));
if ($r['attisdropped'] != 'f' || !$r['attname']) {
db_modify("alter TABLE variant_varer ADD variant_kostpris numeric(15,3)", __FILE__ . " linje " . __LINE__);
}
$r = db_fetch_array(db_select("SELECT * FROM pg_attribute WHERE attrelid= '{$relfilenode}' and attname = 'variant_vejlpris'", __FILE__ . " linje " . __LINE__));
if ($r['attisdropped'] != 'f' || !$r['attname']) {
db_modify("alter TABLE variant_varer ADD variant_vejlpris numeric(15,3)", __FILE__ . " linje " . __LINE__);
}
$q = db_select("select * from varianter", __FILE__ . " linje " . __LINE__);
while ($r = db_fetch_array($q)) {
$varianter_id[$x] = $r['id'];
$varianter_beskrivelse[$x] = $r['beskrivelse'];
$varianter_shop_id[$x] = $r['shop_id'];
$x++;
}
$x = 0;
$q = db_select("select * from variant_typer", __FILE__ . " linje " . __LINE__);
while ($r = db_fetch_array($q)) {
$varianttyper_id[$x] = $r['id'];
$varianttyper_beskrivelse[$x] = $r['beskrivelse'];
$varianttyper_shop_id[$x] = $r['shop_id'];
#echo "$varianttyper_id[$x] $varianttyper_beskrivelse[$x]<br>";
$id = $_GET['id'];
}
if ($id && $id >= 1) {
$modulnr = 5;
include "../includes/connect.php";
include "../includes/online.php";
include "../includes/std_func.php";
include "../includes/ordrefunc.php";
include "../includes/fuld_stykliste.php";
$hurtigfakt = if_isset($_GET['hurtigfakt']);
$genfakt = if_isset($_GET['genfakt']);
$pbs = if_isset($_GET['pbs']);
$mail_fakt = if_isset($_GET['mail_fakt']);
transaktion("begin");
$svar = levering($id, $hurtigfakt, $genfakt, 0);
if ($svar == 'OK') {
transaktion("commit");
if ($hurtigfakt == 'on') {
db_modify("update ordrer set status=2 where id='{$id}' and status<2", __FILE__ . " linje " . __LINE__);
print "<meta http-equiv=\"refresh\" content=\"0;URL=bogfor.php?id={$id}&genfakt={$genfakt}&mail_fakt={$mail_fakt}&pbs={$pbs}\">";
exit;
} else {
print "<meta http-equiv=\"refresh\" content=\"0;URL=ordre.php?id={$id}\">";
}
} else {
print "<BODY onLoad=\"javascript:alert('{$svar}')\">";
}
}
?>
</body></html>
function overfoer_data($filnavn, $splitter, $feltnavn, $feltantal)
{
global $charset;
global $kontotype;
global $art;
$x = 0;
$fp = fopen("../importfiler/postnr.csv", "r");
if ($fp) {
while (!feof($fp)) {
$x++;
$linje = trim(fgets($fp));
list($postnr[$x], $bynavn[$x]) = explode(chr(9), $linje);
}
}
fclose($fp);
$postnr_antal = $x;
$fp = fopen("{$filnavn}", "r");
if ($fp) {
for ($y = 1; $y < 4; $y++) {
$linje = fgets($fp);
}
$tmp = $linje;
while ($tmp = substr(strstr($tmp, ";"), 1)) {
$semikolon++;
}
$tmp = $linje;
while ($tmp = substr(strstr($tmp, ","), 1)) {
$komma++;
}
$tmp = $linje;
while ($tmp = substr(strstr($tmp, chr(9)), 1)) {
$tabulator++;
}
$tmp = '';
if ($komma > $semikolon && $komma > $tabulator) {
$tmp = 'Komma';
$feltantal = $komma;
} elseif ($semikolon > $tabulator && $semikolon > $komma) {
$tmp = 'Semikolon';
$feltantal = $semikolon;
} elseif ($tabulator > $semikolon && $tabulator > $komma) {
$tmp = 'Tabulator';
$feltantal = $tabulator;
}
if (!$splitter) {
$splitter = $tmp;
}
$cols = $feltantal + 1;
}
fclose($fp);
for ($y = 0; $y <= $feltantal; $y++) {
for ($x = 0; $x <= $felt_antal; $x++) {
if ($felt_navn[$x] && $feltnavn[$y] == $felt_navn[$x] && $felt_aktiv[$x] == 1) {
print "<BODY onLoad=\"javascript:alert('Der kan kun være 1 kolonne med {$felt_navn[$x]}')\">";
$feltnavn[$y] = '';
} elseif ($felt_navn[$x] && $feltnavn[$y] == $felt_navn[$x]) {
$felt_aktiv[$x] = 1;
}
}
}
print "<tr><td colspan={$cols}><hr></td></tr>\n";
if (!$splitter || $splitter == 'Semikolon') {
$splitter = ';';
} elseif ($splitter == 'Komma') {
$splitter = ',';
} elseif ($splitter == 'Tabulator') {
$splitter = chr(9);
}
transaktion('begin');
#$felt_antal=$feltantal;
$ryd_firmanavn = 0;
$fp = fopen("{$filnavn}", "r");
if ($fp) {
$kontonumre = array();
$x = 0;
$imp_antal = 0;
while (!feof($fp)) {
# $feltantal=$felt_antal;
$skriv_linje = 0;
if ($linje = trim(fgets($fp))) {
$x++;
$skriv_linje = 1;
if ($charset == 'UTF-8') {
$linje = utf8_encode($linje);
}
$felt = array();
$felt = opdel($splitter, $linje);
# if ($ryd_firmanavn) $felt[$ryd_firmanavn]='';
if (in_array('pbs_nr', $feltnavn) && !in_array('pbs', $feltnavn)) {
$feltantal++;
$pbs = $feltantal;
$feltnavn[$feltantal] = 'pbs';
$felt[$feltantal] = '';
}
if (in_array('husnr', $feltnavn)) {
$felt = add2felt($feltantal, 'husnr', 'addr1', $feltnavn, $felt);
}
if (in_array('etage', $feltnavn)) {
$felt = add2felt($feltantal, 'etage', 'addr1', $feltnavn, $felt);
}
if (in_array('fornavn', $feltnavn) && !in_array('firmanavn', $feltnavn)) {
$feltantal++;
$ryd_firmanavn = $feltantal;
$feltnavn[$feltantal] = 'firmanavn';
$felt[$feltantal] = '';
}
if (in_array('efternavn', $feltnavn) && !in_array('firmanavn', $feltnavn)) {
$feltantal++;
$ryd_firmanavn = $feltantal;
$feltnavn[$feltantal] = 'firmanavn';
$felt[$feltantal] = '';
}
if (in_array('fornavn', $feltnavn)) {
$felt = add2felt($feltantal, 'fornavn', 'firmanavn', $feltnavn, $felt);
}
if (in_array('efternavn', $feltnavn)) {
$felt = add2felt($feltantal, 'efternavn', 'firmanavn', $feltnavn, $felt);
}
for ($y = 0; $y <= $feltantal; $y++) {
$felt[$y] = trim($felt[$y]);
$feltnavn[$y] = strtolower($feltnavn[$y]);
if (substr($felt[$y], 0, 1) == '"' && substr($felt[$y], -1) == '"') {
$felt[$y] = substr($felt[$y], 1, strlen($felt[$y]) - 2);
}
if ($feltnavn[$y] == 'kontonr' && !is_numeric($felt[$y])) {
$kontonr = 0;
$skriv_linje = 2;
} elseif ($feltnavn[$y] == 'kontonr') {
$kontonr = $felt[$y];
}
if ($feltnavn[$y] == 'pbs_nr' && $felt[$y]) {
$felt[$pbs] = 'on';
}
if ($feltnavn[$y] == "postnr") {
list($felt[$y], $bynavn[$y]) = explode(" ", $felt[$y], 2);
}
if ($feltnavn[$y] == 'kontoansvarlig' && $felt[$y] && $kontonr) {
$r = db_fetch_array(db_select("select id from adresser where kontonr='{$kontonr}'", __FILE__ . " linje " . __LINE__));
$konto_id = $r['id'] * 1;
$r = db_fetch_array(db_select("select id from ansatte where initialer='{$felt[$y]}' and konto_id={$konto_id}", __FILE__ . " linje " . __LINE__));
$felt[$y] = $r['id'] * 1;
} elseif ($feltnavn[$y] == 'kontoansvarlig') {
$felt[$y] = '0';
}
if ($feltnavn[$y] == 'oprettet' && $felt[$y] && $kontonr) {
$felt[$y] = usdate($felt[$y]);
} elseif ($feltnavn[$y] == 'oprettet') {
$felt[$y] = date("Y-m-d");
}
if ($feltnavn[$y] == 'kreditmax') {
$felt[$y] = usdecimal($felt[$y]);
}
if ($feltnavn[$y] == 'betalingsdage') {
$felt[$y] = $felt[$y] * 1;
}
}
}
if ($skriv_linje == 1) {
$addr_a = '';
$addr_b = '';
$upd = '';
$kontakt_a = '';
$kontakt_b = '';
for ($y = 0; $y <= $feltantal; $y++) {
if ($feltnavn[$y] && $feltnavn[$y] != 'husnr' && $feltnavn[$y] != 'etage') {
$felt[$y] = trim(addslashes($felt[$y]));
if (!strstr($feltnavn[$y], "kontakt_")) {
if ($y > 0) {
$addr_a = $addr_a . ",";
$addr_b = $addr_b . ",";
$upd = $upd . ",";
}
$addr_a = $addr_a . $feltnavn[$y];
$addr_b = $addr_b . "'" . $felt[$y] . "'";
$upd = $upd . $feltnavn[$y] . "='" . $felt[$y] . "'";
} else {
if ($kontakt_a) {
$kontakt_a = $kontakt_a . ",";
$kontakt_b = $kontakt_b . ",";
}
$tmp = substr($feltnavn[$y], 8);
$kontakt_a = $kontakt_a . $tmp;
$kontakt_b = $kontakt_b . "'" . $felt[$y] . "'";
}
}
}
if (!strpos($addr_a, 'lukket')) {
$addr_a = $addr_a . ",lukket";
$addr_b = $addr_b . ",''";
}
if (!strpos($addr_a, 'gruppe')) {
$addr_a = $addr_a . ",gruppe";
$addr_b = $addr_b . ",'1'";
$upd = $upd . ",gruppe='1'";
}
if (!strpos($addr_a, 'art')) {
$addr_a = $addr_a . ",art";
$addr_b = $addr_b . ",'{$art}'";
$upd = $upd . ",art='{$art}'";
} else {
for ($y = 0; $y <= $feltantal; $y++) {
if ($feltnavn[$y] == 'art') {
$art = $felt[$y];
}
}
}
if ($r = db_fetch_array(db_select("select id from adresser where kontonr='{$kontonr}' and art='{$art}'", __FILE__ . " linje " . __LINE__))) {
$konto_id = $r['id'];
$imp_antal++;
# echo "update adresser set $upd where id='$konto_id'<br>";
db_modify("update adresser set {$upd} where id='{$konto_id}'", __FILE__ . " linje " . __LINE__);
} else {
$imp_antal++;
db_modify("insert into adresser({$addr_a},kontotype) values ({$addr_b},'{$kontotype}')", __FILE__ . " linje " . __LINE__);
$r = db_fetch_array(db_select("select id from adresser where kontonr='{$kontonr}' and art = 'D'", __FILE__ . " linje " . __LINE__));
$konto_id = $r['id'];
}
if ($kontakt_a && !($r = db_fetch_array(db_select("select id from ansatte where konto_id='{$konto_id}'", __FILE__ . " linje " . __LINE__)))) {
db_modify("insert into ansatte({$kontakt_a},konto_id) values ({$kontakt_b},'{$konto_id}')", __FILE__ . " linje " . __LINE__);
}
}
}
}
fclose($fp);
transaktion('commit');
print "</tbody></table>";
print "</td></tr>";
print "<BODY onLoad=\"javascript:alert('{$imp_antal} adresser importeret')\">";
if ($popup) {
print "<meta http-equiv=\"refresh\" content=\"0;URL=../includes/luk.php\">";
} else {
print "<meta http-equiv=\"refresh\" content=\"0;URL=../systemdata/diverse.php\">";
}
#exit;
}
function vareopslag($sort, $fokus, $id, $vis_kost, $ref, $find, $retur)
{
global $bgcolor;
global $bgcolor5;
if ($find) {
$find = str_replace("*", "%", $find);
$find = " and {$fokus} like {$find} and id!='{$id}'";
} else {
$find = " and id!='{$id}'";
}
# sidehoved($id, "$retur", "../lager/$retur", $fokus, "Kundeordre $id - vareopslag");
# print"<table width=\"100%\" height=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"><tbody>";
# print"<tr><td valign=\"top\">";
print "<table cellpadding=\"1\" cellspacing=\"1\" border=\"0\t\" width=\"100%\" valign = \"top\">";
print "<tbody><tr>";
print "<td><a href=\"{$retur}?fokus={$fokus}&id={$id}\">Luk</a></td>";
if ($vis_kost) {
print "<td colspan=7 align=center><a href={$retur}?sort=varenr&funktion=vareopslag&x={$x}&fokus={$fokus}&id={$id}&find={$find}>Udelad kostpriser</a></td></tr>";
} else {
print "<td colspan=3 align=center><a href={$retur}?sort=varenr&funktion=vareopslag&x={$x}&fokus={$fokus}&id={$id}&vis_kost=on&find={$find}>Vis kostpriser</a></td></tr>";
}
print "<td><b><a href={$retur}?sort=varenr&funktion=vareopslag&x={$x}&fokus={$fokus}&id={$id}&vis_kost={$vis_kost}&find={$find}>Varenr</a></b></td>";
print "<td><b> Enhed</b></td>";
print "<td><b><a href={$retur}?sort=beskrivelse&funktion=vareopslag&x={$x}&fokus={$fokus}&id={$id}&vis_kost={$vis_kost}&find={$find}>Beskrivelse</a></b></td>";
print "<td align=right><b><a href={$retur}?sort=salgspris&funktion=vareopslag&x={$x}&fokus={$fokus}&id={$id}&find={$find}>Salgspris</a></b></td>";
if ($vis_kost) {
print "<td align=right><b> Kostpris</b></td>";
}
print "<td align=right><b><a href={$retur}?sort=beholdning&funktion=vareopslag&x={$x}&fokus={$fokus}&id={$id}&vis_kost={$vis_kost}&find={$find}>Beh.</a></b></td>";
print "<td><br></td>";
# print"<td><br></td><td><b>Kunde</b></td>";
print " </tr>\n";
print "<tr><td colspan=\"6\"><hr></td></tr>";
if ($ref) {
if ($row = db_fetch_array(db_select("select afd from ansatte where navn = '{$ref}'"))) {
if ($row = db_fetch_array(db_select("select kodenr from grupper where box1='{$row['afd']}' and art='LG'"))) {
$lager = $row['kodenr'];
}
}
}
$lager = $lager * 1;
if (!$sort) {
$sort = varenr;
}
if ($find) {
$query = db_select("select * from varer where lukket != '1' {$find} order by {$sort}");
} else {
$query = db_select("select * from varer where lukket != '1' order by {$sort}");
}
while ($row = db_fetch_array($query)) {
$query2 = db_select("select box8 from grupper where art='VG' and kodenr='{$row['gruppe']}'");
$row2 = db_fetch_array($query2);
if ($row2[box8] == 'on' || $row[samlevare] == 'on') {
if ($row[beholdning] != '0' and !$row[beholdning]) {
db_modify("update varer set beholdning='0' where id={$row['id']}");
}
} elseif ($row[beholdning]) {
db_modify("update varer set beholdning='0' where id={$row['id']}");
}
if ($linjebg != $bgcolor) {
$linjebg = $bgcolor;
$color = '#000000';
} else {
$linjebg = $bgcolor5;
$color = '#000000';
}
print "<tr bgcolor=\"{$linjebg}\">";
print "<td><a href=\"{$retur}?vare_id={$row['id']}&fokus={$fokus}&id={$id}\">{$row['varenr']}</a></td>";
print "<td>{$row['enhed']}<br></td>";
print "<td>{$row['beskrivelse']}<br></td>";
$salgspris = dkdecimal($row[salgspris]);
print "<td align=right>{$salgspris}<br></td>";
if ($vis_kost == 'on') {
$query2 = db_select("select kostpris from vare_lev where vare_id = {$row['id']} order by posnr");
$row2 = db_fetch_array($query2);
$kostpris = dkdecimal($row2[kostpris]);
print "<td align=right>{$kostpris}<br></td>";
}
$reserveret = 0;
# $linjetext="<span title= 'Der er $y i tilbud og $z i ordre '>";
if ($lager >= 1) {
$q2 = db_select("select * from batch_kob where vare_id={$row['id']} and rest>0 and lager={$lager}");
while ($r2 = db_fetch_array($q2)) {
$q3 = db_select("select * from reservation where batch_kob_id={$r2['id']}");
while ($r3 = db_fetch_array($q3)) {
$reserveret = $reserveret + $r3[antal];
}
}
$linjetext = "<span title= 'Reserveret: {$reserveret}'>";
if ($r2 = db_fetch_array(db_select("select beholdning from lagerstatus where vare_id={$row['id']} and lager={$lager}"))) {
print "<td align=right>{$linjetext} {$r2['beholdning']}</span></td>";
}
} else {
$q2 = db_select("select * from batch_kob where vare_id={$row['id']} and rest > 0");
while ($r2 = db_fetch_array($q2)) {
$q3 = db_select("select * from reservation where batch_kob_id={$r2['id']}");
while ($r3 = db_fetch_array($q3)) {
$reserveret = $reserveret + $r3[antal];
}
}
$linjetext = "<span title= 'Reserveret: {$reserveret}'>";
print "<td align=right>{$linjetext} {$row['beholdning']}</span></td>";
}
print "</tr>\n";
}
print "</tbody></table></td></tr></tbody></table>";
exit;
}
if (strstr($submit, 'Tilf') && $brugernavn) {
$query = db_select("select id from brugere where brugernavn = '{$brugernavn}'", __FILE__ . " linje " . __LINE__);
if ($row = db_fetch_array($query)) {
$alerttext = "Der findes allerede en bruger med brugenavn: {$brugernavn}!";
print "<BODY onLoad=\"javascript:alert('{$alerttext}')\">";
# print "<tr><td align=center>Der findes allerede en bruger med brugenavn: $brugernavn!</td></tr>";
} else {
if (!$regnaar) {
$regnaar = 1;
}
db_modify("insert into brugere (brugernavn,kode,rettigheder,regnskabsaar,ansat_id) values ('{$brugernavn}','{$kode}','{$rettigheder}','{$regnaar}',{$ansat_id['0']})", __FILE__ . " linje " . __LINE__);
}
} elseif (strstr($submit, 'Opdat') && $brugernavn) {
db_modify("update brugere set brugernavn='{$brugernavn}', kode='{$kode}', rettigheder='{$rettigheder}', ansat_id={$ansat_id['0']} where id={$id}", __FILE__ . " linje " . __LINE__);
} elseif ($id && !$kode) {
db_modify("delete from brugere where id = {$id}", __FILE__ . " linje " . __LINE__);
}
}
print "<tr><td valign = top align=center>";
#print "<table border=><tbody>";
print "<form name=bruger action=brugere.php method=post>";
print "<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"70%\"><tbody>";
#B
print "<tr><td colspan=2></td>";
print str_repeat("<td align=center width=1% style=\"color: {$bgcolor};\">_</td>", 25);
print "</tr>";
print "<tr><td colspan = 14 align=right> Sikkerhedskopi </td><td colspan = 13 align=left> Debitorrapport</td></tr>";
print "<tr><td colspan = 13 align=right> Varemodtagelse </td>";
print str_repeat("<td align=center> |</td>", 2);
print "<td colspan=12> Kreditorrapport</td></tr>";
print "<tr><td colspan = 12 align=right> Varelager </td>";
$x = 0;
if ($kopier) {
$q = db_select("select * from tekster where sprog_id={$kopier} order by tekst", __FILE__ . " linje " . __LINE__);
while ($r = db_fetch_array($q)) {
$x++;
$id[$x] = $r['id'];
$tekst_id[$x] = $r['tekst_id'];
$tekst[$x] = $r['tekst'];
}
}
$tekstantal = $x;
for ($x = 1; $x <= $tekstantal; $x++) {
if (!($r = db_fetch_array(db_select("select id from tekster where sprog_id={$sprog_id} and tekst_id={$tekst_id[$x]} order by {$sort}", __FILE__ . " linje " . __LINE__)))) {
db_modify("insert into tekster (sprog_id,tekst_id,tekst)values('{$sprog_id}','{$tekst_id[$x]}','{$tekst[$x]}')");
} else {
db_modify("update tekster set tekst='{$tekst[$x]}' where id='{$r['id']}'", __FILE__ . " linje " . __LINE__);
}
}
$x = 0;
$q = db_select("select * from tekster where sprog_id={$sprog_id} order by {$sort}", __FILE__ . " linje " . __LINE__);
while ($r = db_fetch_array($q)) {
$x++;
$id[$x] = $r['id'];
$tekst_id[$x] = $r['tekst_id'];
$tekst[$x] = $r['tekst'];
}
$tekstantal = $x;
print "<form name=\"tekster\" action=\"tekster.php?sprog_id={$sprog_id}&sort={$sort}\" method=\"post\">";
print "<input type=hidden name=tekstantal value=\"{$tekstantal}\">";
print "<table border=1><tbody>";
print "<tr><td><a href=tekster.php?sprog_id={$sprog}&sort=tekst_id>Id</a></td>";
if (!$ny_id) {
$alerttekst = "Der findes ikke andre debotirer med kontonr: {$kontonr}";
# $alerttekst=findtekst(345,$sprog_id);
print "<BODY onLoad=\"javascript:alert('{$alerttekst}')\"><!--tekst 345-->";
print "<meta http-equiv=\"refresh\" content=\"0;URL=debitorkort.php?returside={$returside}&ordre_id={$ordre_id}&id={$id}&fokus={$fokus}\">\n";
}
if ($id && $kontonr && $fusion == 'OK') {
transaktion('begin');
db_modify("update historik set konto_id='{$ny_id}' where konto_id='{$id}'", __FILE__ . " linje " . __LINE__);
db_modify("update ansatte set konto_id='{$ny_id}' where konto_id='{$id}'", __FILE__ . " linje " . __LINE__);
db_modify("update ordrer set konto_id='{$ny_id}' where konto_id='{$id}'", __FILE__ . " linje " . __LINE__);
db_modify("update openpost set konto_id='{$ny_id}' where konto_id='{$id}'", __FILE__ . " linje " . __LINE__);
db_modify("update jobkort set konto_id='{$ny_id}' where konto_id='{$id}'", __FILE__ . " linje " . __LINE__);
db_modify("update pbs_kunder set konto_id='{$ny_id}' where konto_id='{$id}'", __FILE__ . " linje " . __LINE__);
db_modify("update shop_adresser set saldi_id='{$ny_id}' where saldi_id='{$id}'", __FILE__ . " linje " . __LINE__);
db_modify("delete from adresser where id='{$id}'", __FILE__ . " linje " . __LINE__);
transaktion('commit');
print "<meta http-equiv=\"refresh\" content=\"0;URL=debitorkort.php?returside={$returside}&ordre_id={$ordre_id}&id={$ny_id}&fokus={$fokus}\">\n";
} else {
$r = db_fetch_array(db_select("select * from adresser where id = '{$id}'", __FILE__ . " linje " . __LINE__));
$gl_firmanavn = $r['firmanavn'];
$gl_addr1 = $r['addr1'];
$gl_addr2 = $r['addr2'];
$gl_postnr = $r['postnr'];
$gl_bynavn = $r['bynavn'];
$gl_cvrnr = $r['cvrnr'];
$gl_tlf = $r['tlf'];
$r = db_fetch_array(db_select("select * from adresser where id = '{$ny_id}'", __FILE__ . " linje " . __LINE__));
$ny_firmanavn = $r['firmanavn'];
$ny_addr1 = $r['addr1'];
$ny_addr2 = $r['addr2'];
function opdat_3_5($under_nr, $lap_nr)
{
global $version;
global $db;
global $db_id;
global $regnskab;
global $regnaar;
global $db_type;
$s_id = session_id();
$nextver = '3.5.1';
if ($lap_nr < "1") {
include "../includes/connect.php";
$r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__));
$tmp = $r['version'];
if ($tmp < $nextver) {
echo "opdaterer hovedregnskab til ver {$nextver}<br />";
db_modify("UPDATE regnskab set version = '{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__);
}
include "../includes/online.php";
if ($db != $sqdb) {
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("ALTER TABLE regulering add column lager integer", __FILE__ . " linje " . __LINE__);
db_modify("ALTER TABLE ordrelinjer add column fast_db numeric(15,2)", __FILE__ . " linje " . __LINE__);
db_modify("UPDATE grupper set box1='{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__);
}
include "../includes/connect.php";
db_modify("UPDATE regnskab set version = '{$nextver}' where db = '{$db}'", __FILE__ . " linje " . __LINE__);
}
$nextver = '3.5.2';
if ($lap_nr < "2") {
include "../includes/connect.php";
$r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__));
$tmp = $r['version'];
if ($tmp < $nextver) {
echo "opdaterer hovedregnskab til ver {$nextver}<br />";
db_modify("UPDATE regnskab set version = '{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__);
}
include "../includes/online.php";
if ($db != $sqdb) {
db_modify("ALTER TABLE ordrer add column afd integer", __FILE__ . " linje " . __LINE__);
db_modify("ALTER TABLE ordrelinjer add column afd integer", __FILE__ . " linje " . __LINE__);
db_modify("ALTER TABLE ordrelinjer add column lager integer", __FILE__ . " linje " . __LINE__);
db_modify("DELETE FROM tekster where tekst_id = '677'", __FILE__ . " linje " . __LINE__);
db_modify("UPDATE grupper set box1='{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__);
}
include "../includes/connect.php";
db_modify("UPDATE regnskab set version = '{$nextver}' where db = '{$db}'", __FILE__ . " linje " . __LINE__);
}
$nextver = '3.5.3';
if ($lap_nr < "3") {
include "../includes/connect.php";
$r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__));
$tmp = $r['version'];
if ($tmp < $nextver) {
echo "opdaterer hovedregnskab til ver {$nextver}<br />";
db_modify("UPDATE regnskab set version = '{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__);
}
include "../includes/online.php";
if ($db != $sqdb) {
db_modify("UPDATE grupper set box1='{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__);
}
include "../includes/connect.php";
db_modify("UPDATE regnskab set version = '{$nextver}' where db = '{$db}'", __FILE__ . " linje " . __LINE__);
}
$nextver = '3.5.4';
if ($lap_nr < "4") {
include "../includes/connect.php";
$r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__));
$tmp = $r['version'];
if ($tmp < $nextver) {
echo "opdaterer hovedregnskab til ver {$nextver}<br />";
db_modify("UPDATE regnskab set version = '{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__);
}
include "../includes/online.php";
if ($db != $sqdb) {
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__);
db_modify("UPDATE grupper set box1='{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__);
}
include "../includes/connect.php";
db_modify("UPDATE regnskab set version = '{$nextver}' where db = '{$db}'", __FILE__ . " linje " . __LINE__);
}
$nextver = '3.5.5';
if ($lap_nr < "5") {
include "../includes/connect.php";
$r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__));
$tmp = $r['version'];
if ($tmp < $nextver) {
echo "opdaterer hovedregnskab til ver {$nextver}<br />";
db_modify("UPDATE regnskab set version = '{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__);
}
include "../includes/online.php";
if ($db != $sqdb) {
db_modify("delete from tekster where id = '731'", __FILE__ . " linje " . __LINE__);
db_modify("delete from tekster where id = '732'", __FILE__ . " linje " . __LINE__);
$r = db_fetch_array(db_select("select box6 from grupper where art = 'DIV' and kodenr = '3'", __FILE__ . " linje " . __LINE__));
$fifo = $r['box6'];
if ($fifo) {
if ($r = db_fetch_array(db_select("select id from grupper where art = 'DIV' and kodenr='5'", __FILE__ . " linje " . __LINE__))) {
$id = $r['id'];
db_modify("update grupper set box6='1' where id = '{$id}'", __FILE__ . " linje " . __LINE__);
} else {
db_modify("insert into grupper (beskrivelse,kodenr,art,box1,box2,box3,box4,box5,box6,box7,box8,box9,box10,box11,box12,box13) values ('Div_valg','5','DIV','','','','','','1','','','','','','','')", __FILE__ . " linje " . __LINE__);
}
}
db_modify("UPDATE grupper set box1='{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__);
}
include "../includes/connect.php";
db_modify("UPDATE regnskab set version = '{$nextver}' where db = '{$db}'", __FILE__ . " linje " . __LINE__);
}
$nextver = '3.5.6';
if ($lap_nr < "6") {
include "../includes/connect.php";
$r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__));
$tmp = $r['version'];
if ($tmp < $nextver) {
echo "opdaterer hovedregnskab til ver {$nextver}<br />";
db_modify("UPDATE regnskab set version = '{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__);
}
include "../includes/online.php";
if ($db != $sqdb) {
db_modify("ALTER TABLE ordrelinjer add column tilfravalg text", __FILE__ . " linje " . __LINE__);
db_modify("UPDATE grupper set box1='{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__);
}
include "../includes/connect.php";
db_modify("UPDATE regnskab set version = '{$nextver}' where db = '{$db}'", __FILE__ . " linje " . __LINE__);
}
$nextver = '3.5.7';
if ($lap_nr < "7") {
include "../includes/connect.php";
$r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__));
$tmp = $r['version'];
if ($tmp < $nextver) {
echo "opdaterer hovedregnskab til ver {$nextver}<br />";
db_modify("UPDATE regnskab set version = '{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__);
}
include "../includes/online.php";
if ($db != $sqdb) {
db_modify("ALTER TABLE sager add column planfraop text", __FILE__ . " linje " . __LINE__);
db_modify("ALTER TABLE sager add column plantilop text", __FILE__ . " linje " . __LINE__);
db_modify("ALTER TABLE sager add column planfraned text", __FILE__ . " linje " . __LINE__);
db_modify("ALTER TABLE sager add column plantilned text", __FILE__ . " linje " . __LINE__);
db_modify("ALTER TABLE opgaver add column opg_planfra text", __FILE__ . " linje " . __LINE__);
db_modify("ALTER TABLE opgaver add column opg_plantil text", __FILE__ . " linje " . __LINE__);
$i = 0;
$feltnavne = array();
$q = db_select("select * from ordrelinjer", __FILE__ . " linje " . __LINE__);
while ($i < db_num_fields($q)) {
$feltnavne[$i] = db_field_name($q, $i);
$i++;
}
if (!in_array('tilfravalg', $feltnavne)) {
db_modify("ALTER TABLE ordrelinjer ADD tilfravalg text", __FILE__ . " linje " . __LINE__);
}
db_modify("UPDATE grupper set box1='{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__);
}
include "../includes/connect.php";
db_modify("UPDATE regnskab set version = '{$nextver}' where db = '{$db}'", __FILE__ . " linje " . __LINE__);
}
$nextver = '3.5.8';
if ($lap_nr < "8") {
include "../includes/connect.php";
$r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__));
$tmp = $r['version'];
if ($tmp < $nextver) {
echo "opdaterer hovedregnskab til ver {$nextver}<br />";
db_modify("UPDATE regnskab set version = '{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__);
}
include "../includes/online.php";
if ($db != $sqdb) {
db_modify("ALTER TABLE varer add column special_from_time time", __FILE__ . " linje " . __LINE__);
db_modify("ALTER TABLE varer add column special_to_time time", __FILE__ . " linje " . __LINE__);
$i = 0;
$feltnavne = array();
$q = db_select("select * from ordrelinjer", __FILE__ . " linje " . __LINE__);
while ($i < db_num_fields($q)) {
$feltnavne[$i] = db_field_name($q, $i);
$i++;
}
if (!in_array('tilfravalg', $feltnavne)) {
db_modify("ALTER TABLE ordrelinjer ADD tilfravalg text", __FILE__ . " linje " . __LINE__);
}
db_modify("UPDATE grupper set box1='{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__);
}
include "../includes/connect.php";
db_modify("UPDATE regnskab set version = '{$nextver}' where db = '{$db}'", __FILE__ . " linje " . __LINE__);
}
}
function flyt_data($filnavn, $splitter, $feltnavn, $feltantal, $leverandor, $varegrp, $rabat)
{
global $font;
list($kontonr, $tmp) = split(" : ", $leverandor);
if (!$feltnavn) {
$feltnavn = array();
}
list($lev_id, $tmp) = split(":", $leverandor);
list($gruppe, $tmp) = split(":", $varegrp);
$x = 0;
$q = db_select("select varenr from varer");
while ($r = db_fetch_array($q)) {
$x++;
$exist_vnr[$x] = $r['varenr'];
}
if (!$splitter || $splitter == 'Semikolon') {
$splitter = ';';
} elseif ($splitter == 'Komma') {
$splitter = ',';
} elseif ($splitter == 'Tabulator') {
$splitter = chr(9);
} elseif ($splitter == 'Brdr. Dahl') {
$feltantal = 7;
}
#for ($y=0; $y<$feltantal; $y++) {
$fp = fopen("../temp/" . $filnavn, "r");
if ($fp) {
transaktion('begin');
$x = 0;
while (!feof($fp)) {
$x++;
$linje = fgets($fp);
$felt = array();
if ($splitter == 'Brdr. Dahl') {
$felt[0] = substr($linje, 1, 10);
$felt[1] = substr($linje, 12, 35);
$felt[2] = substr($linje, 47, 10);
$felt[3] = substr($linje, 58, 3);
$felt[4] = substr($linje, 61, 3);
$felt[5] = substr($linje, 64, 1);
$felt[6] = substr($linje, 65, 3);
$felt[1] = str_replace(chr(145), "æ", $felt[1]);
$felt[1] = str_replace(chr(155), "ø", $felt[1]);
$felt[1] = str_replace(chr(134), "å", $felt[1]);
$felt[1] = str_replace(chr(146), "Æ", $felt[1]);
$felt[1] = str_replace(chr(157), "Ø", $felt[1]);
$felt[1] = str_replace(chr(143), "Å", $felt[1]);
} else {
$felt = split($splitter, $linje);
}
for ($y = 0; $y < $feltantal; $y++) {
if ($feltnavn[$y] == 'Varegrp.' && !in_array($felt[$y], $feltnavn)) {
$linjefarve[$x] = 'red';
}
}
for ($y = 0; $y < $feltantal; $y++) {
if (substr($felt[$y], 0, 1) == '"' && substr($felt[$y], -1) == '"') {
$felt[$y] = substr($felt[$y], 1, strlen($felt[$y]) - 2);
}
if ($linjefarve[$x] != 'red' && $feltnavn[$y]) {
if ($feltnavn[$y] == 'Eget varenr.') {
$varenr = trim($felt[$y]);
} elseif ($feltnavn[$y] == 'Lev. varenr.') {
$lev_varenr = trim($felt[$y]);
} elseif ($feltnavn[$y] == 'Begge varenr.') {
$varenr = trim($felt[$y]);
$lev_varenr = trim($felt[$y]);
} elseif ($feltnavn[$y] == 'Beskrivelse') {
$beskrivelse = addslashes($felt[$y]);
} elseif ($feltnavn[$y] == 'Enhed') {
$enhed = $felt[$y];
} elseif ($feltnavn[$y] == 'Salgspris') {
$salgspris = $felt[$y] / 100;
if ($rabat) {
$kostpris = $felt[$y] / 100 - $felt[$y] / 10000 * $rabat;
}
} elseif ($feltnavn[$y] == 'Kostpris') {
$kostpris = $felt[$y];
}
}
}
if (in_array($varenr[$y], $exist_vnr)) {
db_modify("update varer set beskrivelse='{$beskrivelse}', salgspris='{$salgspris}', kostpris={$kostpris}, enhed={$enhed}, gruppe={$gruppe} where varenr='{$varenr}'");
$r = db_fetch_array(db_select("select id from varer where varenr='{$varenr}'"));
$r2 = db_fetch_array(db_select("select id from vare_lev where vare_id='{$r['id']}' and lev_id='{$lev_id}'"));
if ($r2[id]) {
db_modify("update vare_lev set kostpris={$kostpris[$y]}, lev_varenr={$lev_varenr[$y]} where id='{$r2['id']}'");
} else {
db_modify("insert into vare_lev(vare_id, lev_id, lev_varenr, kostpris) values ('{$r['id']}', '{$lev_id}', '{$lev_varenr}', '{$kostpris}')");
}
} else {
db_modify("insert into varer (varenr, beskrivelse, salgspris, kostpris, enhed, gruppe) values ('{$varenr}', '{$beskrivelse}', '{$salgspris}', '{$kostpris}', '{$enhed}', '{$gruppe}')");
$r = db_fetch_array(db_select("select id from varer where varenr='{$varenr}'"));
db_modify("insert into vare_lev(vare_id, lev_id, lev_varenr, kostpris) values ('{$r['id']}', '{$lev_id}', '{$lev_varenr}', '{$kostpris}')");
}
}
transaktion('commit');
}
fclose($fp);
print "</tbody></table>";
print "</td></tr>";
}
function opdat_3_6($under_nr, $lap_nr)
{
global $version;
global $db;
global $db_id;
global $regnskab;
global $regnaar;
global $db_type;
$s_id = session_id();
$nextver = '3.6.1';
if ($lap_nr < "1") {
include "../includes/connect.php";
$r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__));
$tmp = $r['version'];
if ($tmp < $nextver) {
echo "opdaterer hovedregnskab til ver {$nextver}<br />";
db_modify("UPDATE regnskab set version = '{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__);
}
include "../includes/online.php";
if ($db != $sqdb) {
db_modify("ALTER TABLE kontoplan add column valuta integer", __FILE__ . " linje " . __LINE__);
db_modify("ALTER TABLE kontoplan add column valutakurs numeric(15,4)", __FILE__ . " linje " . __LINE__);
db_modify("UPDATE kontoplan set valuta = '0', valutakurs ='100'", __FILE__ . " linje " . __LINE__);
db_modify("UPDATE grupper set box1='{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__);
}
include "../includes/connect.php";
db_modify("UPDATE regnskab set version = '{$nextver}' where db = '{$db}'", __FILE__ . " linje " . __LINE__);
}
$nextver = '3.6.2';
if ($lap_nr < "2") {
include "../includes/connect.php";
$r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__));
$tmp = $r['version'];
if ($tmp < $nextver) {
echo "opdaterer hovedregnskab til ver {$nextver}<br />";
db_modify("UPDATE regnskab set version = '{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__);
}
include "../includes/online.php";
if ($db != $sqdb) {
db_modify("ALTER TABLE varer add column fotonavn text", __FILE__ . " linje " . __LINE__);
db_modify("UPDATE grupper set box1='{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__);
}
include "../includes/connect.php";
db_modify("UPDATE regnskab set version = '{$nextver}' where db = '{$db}'", __FILE__ . " linje " . __LINE__);
}
$nextver = '3.6.3';
if ($lap_nr < "3") {
include "../includes/connect.php";
$r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__));
$tmp = $r['version'];
if ($tmp < $nextver) {
echo "opdaterer hovedregnskab til ver {$nextver}<br />";
db_modify("UPDATE regnskab set version = '{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__);
}
include "../includes/online.php";
if ($db != $sqdb) {
db_modify("ALTER TABLE ordrer add column kontakt_tlf text", __FILE__ . " linje " . __LINE__);
db_modify("ALTER TABLE varer add column tilbudsdage text", __FILE__ . " linje " . __LINE__);
# db_modify("update varer set tilbudsdage='1,2,3,4,5,6,7' where special_price > '0'",__FILE__ . " linje " . __LINE__);
db_modify("ALTER TABLE adresser add column saldo numeric(15,3)", __FILE__ . " linje " . __LINE__);
db_modify("ALTER TABLE openpost add uxtid text", __FILE__ . " linje " . __LINE__);
$q = db_select("select id,transdate from openpost", __FILE__ . " linje " . __LINE__);
while ($r = db_fetch_array($q)) {
db_modify("update openpost set uxtid='" . strtotime($r['transdate']) . "' where id = '{$r['id']}'", __FILE__ . " linje " . __LINE__);
}
db_modify("UPDATE grupper set box1='{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__);
}
}
$nextver = '3.6.4';
if ($lap_nr < "4") {
include "../includes/connect.php";
$r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__));
$tmp = $r['version'];
if ($tmp < $nextver) {
echo "opdaterer hovedregnskab til ver {$nextver}<br />";
db_modify("UPDATE regnskab set version = '{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__);
}
include "../includes/online.php";
if ($db != $sqdb) {
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("UPDATE grupper set box1='{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__);
}
include "../includes/connect.php";
db_modify("UPDATE regnskab set version = '{$nextver}' where db = '{$db}'", __FILE__ . " linje " . __LINE__);
}
}
db_modify("update varer set beholdning='{$ny_beholdning[$x]}' where id='{$id[$x]}'", __FILE__ . " linje " . __LINE__);
}
}
}
$tjeksum = 0;
if (!$aut_lager) {
for ($x = 0; $x < count($kontonr); $x++) {
db_modify("insert into transaktioner (kontonr,bilag,transdate,logdate,logtime,beskrivelse,debet,kredit,faktura,kladde_id,afd,ansat,projekt,valuta,valutakurs,ordre_id)\n\t\t\t\t\tvalues\n\t\t\t\t\t({$kontonr[$x]},'{$bilag}','{$transdate}','{$transdate}','{$logtime}','Produktionsordre: {$varenr['0']} ({$brugernavn})','0','{$amount[$x]}','','0','0','0','0','1','100','0')", __FILE__ . " linje " . __LINE__);
$tjeksum += $amount[$x];
}
if (abs($tjeksum - $afgangsum) > 0.01) {
print "<BODY onLoad=\"javascript:alert('Ubalance i posteringssum -kontakt Saldi teamet på tlf. 4690 2208')\">";
print "<meta http-equiv=\"refresh\" content=\"0;URL=varekort.php?id={$id['0']}\">";
exit;
}
db_modify("insert into transaktioner (kontonr,bilag,transdate,logdate,logtime,beskrivelse,debet,kredit,faktura,kladde_id,afd,ansat,projekt,valuta,valutakurs,ordre_id)\n\t\t\t\tvalues\n\t\t\t('{$tilgang}','{$bilag}','{$transdate}','{$transdate}','{$logtime}','Produktionsordre: {$varenr['0']} ({$brugernavn})','{$afgangsum}','0','','0','0','0','0','1','100','0')", __FILE__ . " linje " . __LINE__);
}
$diff = transtjek();
if ($diff > 1) {
print "<BODY onLoad=\"javascript:alert('Ubalance i transaktioner -kontakt Saldi teamet på tlf. 4690 2208')\">";
} else {
transaktion('commit');
}
print "<meta http-equiv=\"refresh\" content=\"0;URL=varekort.php?id={$id['0']}\">";
} else {
print "<table><tbody>";
print "<form name=\"vareproduktion\" action=\"vareproduktion.php?antal={$antal}&samlevare={$samlevare}\" method=\"post\">";
for ($x = 0; $x < $antal; $x++) {
print "<tr><td><input type = \"hidden\" name=\"id[{$x}]\" value = {$id[$x]}>";
print "<tr><td><input type = \"hidden\" name=\"ny_beholdning[{$x}]\" value = {$ny_beholdning[$x]}>";
}
db_modify("update ansatte set posnr = '{$posnr[$x]}' where id = '{$ans_id[$x]}'", __FILE__ . " linje " . __LINE__);
} elseif ($ans_id[$x]) {
db_modify("delete from ansatte where id = '{$ans_id[$x]}'", __FILE__ . " linje " . __LINE__);
}
}
for ($x = 1; $x <= $lukket_ant; $x++) {
if ($posnr[$x] && $ans_id[$x]) {
db_modify("update ansatte set posnr = '{$posnr[$x]}' where id = '{$ans_id[$x]}'", __FILE__ . " linje " . __LINE__);
} elseif ($ans_id[$x]) {
db_modify("delete from ansatte where id = '{$ans_id[$x]}'", __FILE__ . " linje " . __LINE__);
}
}
}
if ($email != $ny_email) {
include "../includes/connect.php";
db_modify("update regnskab set email='{$ny_email}' where db='{$db}'", __FILE__ . " linje " . __LINE__);
include "../includes/online.php";
}
}
$query = db_select("select * from adresser where art = 'S'", __FILE__ . " linje " . __LINE__);
$row = db_fetch_array($query);
$id = $row['id'] * 1;
$kontonr = $row['kontonr'];
$firmanavn = $row['firmanavn'];
$addr1 = $row['addr1'];
$addr2 = $row['addr2'];
$postnr = $row['postnr'];
$bynavn = $row['bynavn'];
#$kontakt=$row['kontakt'];
$tlf = $row['tlf'];
$fax = $row['fax'];
db_modify("CREATE DATABASE {$db_navn} with encoding = 'UTF8'", __FILE__ . " linje " . __LINE__);
} else {
db_modify("CREATE DATABASE {$db_navn} with encoding = 'LATIN9'", __FILE__ . " linje " . __LINE__);
}
db_close($connection);
$connection = db_connect("{$host}", "{$db_bruger}", "{$db_password}", "{$db_navn}");
}
transaktion("begin");
db_modify("CREATE TABLE brugere(id serial NOT NULL, brugernavn text, kode text, status boolean, regnskabsaar integer, rettigheder text, PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("INSERT INTO brugere (brugernavn, kode, rettigheder) values ('{$adm_navn}' ,'{$adm_password}', '11111111111111111111')", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE regnskab (id serial NOT NULL,\tregnskab text, dbhost text, dbuser text, db text, version text, sidst text, brugerantal numeric, posteringer numeric, posteret numeric, lukket text,administrator text,lukkes date, betalt_til date,logintekst text,email text,bilag numeric(1,0), PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
db_modify("INSERT INTO regnskab (regnskab, dbhost, dbuser, db, version,bilag) values ('{$db_navn}' ,'{$host}', '{$db_bruger}', '{$db_navn}', '{$version}','0')", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE online (session_id text, brugernavn text, db text, dbuser text, rettigheder text, regnskabsaar integer, logtime text, revisor boolean)", __FILE__ . " linje " . __LINE__);
db_modify("CREATE TABLE kundedata (id serial NOT NULL, firmanavn text, addr1 text, addr2 text, postnr varchar(10), bynavn text, kontakt text, email text, cvrnr text, regnskab text, regnskab_id integer,brugernavn text, kodeord text, kontrol_id text, aktiv int, logtime text,slettet varchar(2),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 revisor(id serial NOT NULL,regnskabsaar integer,bruger_id integer,brugernavn text,db_id integer,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__);
transaktion("commit");
# rename("../includes/connect", "../includes/connect.php");
if ($fp = fopen("../includes/connect.php", "w")) {
skriv_connect($fp, $host, $db_bruger, $db_password, $db_navn, $db_encode, $db_type);
fclose($fp);
print "<table width=\"75%\"><tr><td style=\"text-align:center\">\n\n";
print "\n\n<h1>SALDI er installeret</h1>\n\n";
print "<p>Dit SALDI-system er nu oprettet. Og det første, du skal gøre, er at oprette et regnskab.</p>\n\n";
print "<p>Dette gøres ved at loggge ind med <b>{$db_navn}</b> som regnskab, <b>{$adm_navn}</b> \n";
print "som brugernavn og den valgte adgangskode</p>\n\n";
print "<p>Tegn en hotline-aftale for kun, så kan du ringe eller sende en e-mail \n";
print "og få hurtigt svar på spørgsmål om brugen af SALDI<!-- samt sikret dig adgang til automatiske opdateringer -->.</p>\n\n";
print "<p>Se mere på <a href=\"http://saldi.dk/hotline\" target=\"_blank\">http://saldi.dk/hotline</a></p>\n\n";
print "<p> </p>\n\n";
# print "<p><a href=../index/index.php>Fortsæt</a></p>\n\n";
if ($antal[$x] <= $max_antal[$x] && $antal[$x] > 0 && $submit == 'Gem') {
if ($row = db_fetch_array(db_select("select * from batch_kob where id = {$batch_kob_id[$x]}", __FILE__ . " linje " . __LINE__))) {
db_modify("update batch_kob set antal = {$row['antal']}-{$antal[$x]}, rest = {$row['rest']}-{$antal[$x]} where id={$batch_kob_id[$x]}", __FILE__ . " linje " . __LINE__);
if ($r2 = db_fetch_array(db_select("select * from batch_kob where linje_id = {$row['linje_id']} and lager={$nyt_lager[$x]}", __FILE__ . " linje " . __LINE__))) {
db_modify("update batch_kob set antal = {$r2['antal']}+{$antal[$x]}, rest = {$r2['rest']}+{$antal[$x]} where id={$r2['id']}", __FILE__ . " linje " . __LINE__);
} else {
db_modify("insert into batch_kob (kobsdate, fakturadate, vare_id, linje_id, ordre_id, pris, antal, rest, lager) values ('{$row['kobsdate']}', '{$row['fakturadate']}', '{$row['vare_id']}', '{$row['linje_id']}', '{$row['ordre_id']}', '{$row['pris']}', {$antal[$x]}, {$antal[$x]}, {$nyt_lager[$x]})", __FILE__ . " linje " . __LINE__);
}
}
$row = db_fetch_array(db_select("select beholdning from lagerstatus where vare_id={$vare_id} and lager={$lager}", __FILE__ . " linje " . __LINE__));
db_modify("update lagerstatus set beholdning = {$row['beholdning']}-{$antal[$x]} where vare_id={$vare_id} and lager={$lager}", __FILE__ . " linje " . __LINE__);
$query = db_select("select beholdning from lagerstatus where vare_id={$vare_id} and lager={$nyt_lager[$x]}", __FILE__ . " linje " . __LINE__);
if ($row = db_fetch_array($query)) {
db_modify("update lagerstatus set beholdning = {$row['beholdning']}+{$antal[$x]} where vare_id={$vare_id} and lager={$nyt_lager[$x]}", __FILE__ . " linje " . __LINE__);
} else {
db_modify("insert into lagerstatus (vare_id, beholdning, lager) values ({$vare_id}, {$antal[$x]}, {$nyt_lager[$x]})", __FILE__ . " linje " . __LINE__);
}
}
}
}
transaktion("commit");
if ($submit == "Luk") {
print "<body onload=\"javascript:window.close();window.opener.focus();\">";
}
$antal[$x] = 0;
$x = 0;
$tmp = "'" . $lager . "'";
if ($lager <= 1) {
$qtxt = "select * from batch_kob where vare_id='{$vare_id}' and (lager<='1' or lager is NULL) and rest > '0'";
} else {
$qtxt = "select * from batch_kob where vare_id='{$vare_id}' and lager='{$lager}' and rest > '0'";
$std_varegruppe = trim(if_isset($_POST['std_varegruppe']));
$ny_gruppe = if_isset($_POST['ny_gruppe']);
for ($x = 1; $x <= $prisgruppeantal; $x++) {
$ny_rabat[$x] *= 1;
if ($ny_rabat[$x] != $std_rabat) {
$rabat ? $rabat .= chr(9) . $prisgruppe[$x] . "|" . $ny_rabat[$x] : ($rabat = chr(9) . $prisgruppe[$x] . "|" . $ny_rabat[$x]);
}
}
# db_modify("update grupper set box5='$rabat' where id='$id'",__FILE__ . " linje " . __LINE__);
for ($x = 1; $x <= $prisgruppeantal; $x++) {
$ny_gruppe[$x] = trim($ny_gruppe[$x]);
if ($ny_gruppe[$x] && $ny_gruppe[$x] != $std_varegruppe) {
$varegruppe ? $varegruppe .= chr(9) . $prisgruppe[$x] . "|" . $ny_gruppe[$x] : ($varegruppe = chr(9) . $prisgruppe[$x] . "|" . $ny_gruppe[$x]);
}
}
db_modify("update grupper set box5='{$rabat}',box7='{$varegruppe}' where id='{$id}'", __FILE__ . " linje " . __LINE__);
}
}
print "<table><tbody>";
if (!$lev_id && $prisliste) {
print "<form name=\"diverse\" action=\"lev_rabat.php?id={$id}&prisliste={$prisliste}\" method=\"post\">";
print "<tr><td>Skriv kontonummer for {$prisliste}</td>";
print "<td><INPUT CLASS=\"inputbox\" TYPE=text style=\"text-align:right;width:100px\" name=kontonr value=\"{$kontonr}\"></td></tr>";
print "<tr><td colspan=\"2\"><input type=submit accesskey=\"g\" value=\"Gem/opdatér\" name=\"gem\"></td></tr>";
print "</form>";
} elseif ($lev_id) {
$rabatter = array();
$rabat = array();
$r = db_fetch_array(db_select("select * from grupper where art = 'PL' and beskrivelse = '{$prisliste}'", __FILE__ . " linje " . __LINE__));
$prisfil = trim($r['box2']);
$rabatter = explode(chr(9), $r['box5']);
print "<td><select name=\"saldi_id\">";
for ($x = 0; $x < count($forslag_id); $x++) {
print "<option value=\"{$forslag_id[$x]}\">{$forslag_vnr[$x]},{$forslag_besk[$x]}</option>";
}
print "</select></td></tr>";
print "<tr><td colspan=\"2\" align=\"center\"><input type=\"submit\"name=\"tilknyt\" value=\"Tilknyt\"> <a href={$url}&next_id={$shop_id}><input type=\"button\" value=\"Spring over\"></td></tr>";
print "</form>";
if (count($forslag_vnr) == 1 && $forslag_vnr[0] == $shop_id) {
$qtxt = "select id from shop_varer where saldi_id='{$forslag_id['0']}'";
$r = db_fetch_array(db_select($qtxt, __FILE__ . " linje " . __LINE__));
if ($r['id']) {
$qtxt = "update shop_varer set shop_id='{$shop_id}' where id ='{$r['id']}'";
} else {
$qtxt = "insert into shop_varer(saldi_id,shop_id) values ('{$forslag_id['0']}','{$shop_id}')";
}
db_modify($qtxt, __FILE__ . " linje " . __LINE__);
$next_id = $shop_id;
$fp = fopen("log.txt", "a");
fwrite($fp, __LINE__ . " " . date("H:i:s") . "next id {$next_id}\n");
fclose($fp);
print "<meta http-equiv=\"refresh\" content=\"0;URL={$url}&id=0&next_id={$next_id}\">";
exit;
}
} else {
$tekst = "Der er ikke fundet noget match i Saldi";
tilfoj($tekst, $shop_id, $shop_vnr, $beskrivelse, $pris, $specialpris, $saldi_grp);
}
} else {
print "<meta http-equiv=\"refresh\" content=\"0;URL={$url}&next_id={$shop_id}&linje={$linje}\">";
}
} else {
function genberegn($id)
{
$kostpris = 0;
$q0 = db_select("select id,vare_id,antal,pris,kostpris,saet,samlevare from ordrelinjer where ordre_id = {$id} and posnr>0 and vare_id > 0", __FILE__ . " linje " . __LINE__);
while ($r0 = db_fetch_array($q0)) {
if ($r1 = db_fetch_array(db_select("select provisionsfri, gruppe from varer where id = '{$r0['vare_id']}'", __FILE__ . " linje " . __LINE__))) {
if (!$r1[provisionsfri] && ($r1 = db_fetch_array(db_select("select box9 from grupper where art = 'VG' and " . nr_cast(kodenr) . "='{$r1['gruppe']}' and box9 = 'on' ", __FILE__ . " linje " . __LINE__)))) {
/*
$batch_tjek='0';
$q1 = db_select("select antal, batch_kob_id from batch_salg where linje_id = '$r0[id]' and batch_kob_id != 0",__FILE__ . " linje " . __LINE__);
while ($r1=db_fetch_array($q1)) {
if ($r2=db_fetch_array(db_select("select pris, fakturadate, linje_id from batch_kob where id = '$r1[batch_kob_id]'",__FILE__ . " linje " . __LINE__))) {
if ($r2['fakturadate']<'2000-01-01') $r2=db_fetch_array(db_select("select pris from ordrelinjer where id = '$r2[linje_id]'",__FILE__ . " linje " . __LINE__));
$batch_tjek=1;
$tmpp=$r2['pris']*$r1['antal'];
$kostpris=$kostpris+$r2['pris']*$r1['antal'];
}
}
if ($batch_tjek<1) {
$r2=db_fetch_array(db_select("select kostpris from varer where id = $r0[vare_id]",__FILE__ . " linje " . __LINE__));
$kostpris=$kostpris+$r2['kostpris']*$r0['antal'];
}
*/
$kostpris += $r0['kostpris'] * $r0['antal'];
} elseif ($r1['provisionsfri']) {
$kostpris += $r0['pris'] * $r0['antal'];
} else {
if ($r0['saet'] && $r0['samlevare'] && $r0['kostpris']) {
$r0['kostpris'] = 0;
db_modify("update ordrelinjer set kostpris='0' where id = '{$r0['id']}'");
}
$kostpris += $r0['kostpris'] * $r0['antal'];
# $r2=db_fetch_array(db_select("select kostpris from varer where id = $r0[vare_id]",__FILE__ . " linje " . __LINE__));
# $kostpris=$kostpris+$r2['kostpris']*$r0['antal'];
}
}
}
db_modify("update ordrer set kostpris={$kostpris} where id = {$id}", __FILE__ . " linje " . __LINE__);
#xit;
return $kostpris;
}
function bogfor($id)
{
global $regnaar;
global $valuta;
global $valutakurs;
global $difkto;
global $sprog_id;
$d_kontrol = 0;
$k_kontrol = 0;
$linjesum = 0;
$fakturasum = 0;
$momssum = 0;
$logdate = date("Y-m-d");
$logtime = date("H:i");
$q = db_select("select box1, box2, box4, box5 from grupper where art='RB'", __FILE__ . " linje " . __LINE__);
if ($r = db_fetch_array($q)) {
if (trim($r['box4']) == "on") {
$modtbill = 1;
} else {
$modtbill = 0;
}
if (trim($r['box5']) == "on") {
$no_faktbill = 1;
$faktbill = 0;
} else {
$no_faktbill = 0;
}
}
$x = 0;
$q = db_select("select * from ordrer where id='{$id}'", __FILE__ . " linje " . __LINE__);
if ($r = db_fetch_array($q)) {
$art = $r['art'];
$konto_id = $r['konto_id'];
$lev_kontonr = str_replace(" ", "", $r['kontonr']);
$firmanavn = addslashes(trim($r['firmanavn']));
$modtagelse = $r['modtagelse'];
$transdate = $r['fakturadate'];
$fakturanr = addslashes($r['fakturanr']);
$ordrenr = $r['ordrenr'];
$projekt[0] = $r['projekt'];
$valuta = $r['valuta'];
$valutakurs = $r['valutakurs'] * 1;
$moms = $r['moms'] * 1;
$momssats = $r['momssats'] * 1;
$sum = $r['sum'];
$omlev = $r['omvbet'];
$ordreantal = $x;
if ($r = db_fetch_array(db_select("select afd from ansatte where navn = '{$r['ref']}'", __FILE__ . " linje " . __LINE__))) {
$afd = $r['afd'];
}
$afd = $afd * 1;
#sikkerhed for at 'afd' har en vaerdi
$ansat = $r['id'] * 1;
if ($no_faktbill == 1) {
$bilag = '0';
} else {
$bilag = trim($fakturanr);
}
$r = db_fetch_array(db_select("select gruppe from adresser where id='{$konto_id}'", __FILE__ . " linje " . __LINE__));
$r = db_fetch_array(db_select("select box1,box2 from grupper where art = 'KG' and kodenr='{$r['gruppe']}'", __FILE__ . " linje " . __LINE__));
$kontonr = $r['box2'];
$box1 = substr(trim($r['box1']), 0, 1);
if ($box1 && ($box1 != 'E' || $box1 != 'Y')) {
$sum = $sum + $moms;
}
#moms tillaegges summen der ikke er eu moms.
########### OPENPOST ->
if (substr($art, 1, 1) == 'K') {
$beskrivelse = "Lev. kn.nr: " . $fakturanr . ", modt. nr " . $modtagelse;
} else {
$beskrivelse = "Lev. fakt.nr:" . $fakturanr . ", modt.nr: " . $modtagelse;
}
#cho "insert into openpost (konto_id, konto_nr, faktnr, amount, beskrivelse, udlignet, transdate, kladde_id, refnr, valuta, valutakurs,projekt) values ('$konto_id', '$lev_kontonr', '$fakturanr', $sum*-1, '$beskrivelse', '0', '$transdate', '0', '$id', '$valuta', '$valutakurs','$projekt[0]')<br>";
db_modify("insert into openpost (konto_id, konto_nr, faktnr, amount, beskrivelse, udlignet, transdate, kladde_id, refnr, valuta, valutakurs,projekt) values ('{$konto_id}', '{$lev_kontonr}', '{$fakturanr}', {$sum}*-1, '{$beskrivelse}', '0', '{$transdate}', '0', '{$id}', '{$valuta}', '{$valutakurs}','{$projekt['0']}')", __FILE__ . " linje " . __LINE__);
$r = db_fetch_array(db_select("select max(id) as id from openpost where konto_id = '{$konto_id}' and faktnr = '{$fakturanr}' and refnr='{$id}'", __FILE__ . " linje " . __LINE__));
$openpost_id = $r['id'];
########### <- OPENPOST
$tekst = findtekst(157, $sprog_id);
if ($kontonr) {
$r = db_fetch_array(db_select("select id from kontoplan where kontonr='{$kontonr}' and regnskabsaar = '{$regnaar}' and lukket!='on'", __FILE__ . " linje " . __LINE__));
if (!$r['id']) {
print "<BODY onLoad=\"javascript:alert('{$tekst}')\">";
exit;
print "<meta http-equiv=\"refresh\" content=\"0;URL=ordre.php?id={$id}\">";
exit;
}
} else {
print "<BODY onLoad=\"javascript:alert('{$tekst}')\">";
print "<meta http-equiv=\"refresh\" content=\"0;URL=ordre.php?id={$id}\">";
exit;
}
if ($sum > 0) {
$kredit = $sum;
$debet = '0';
} else {
$kredit = '0';
$debet = $sum * -1;
}
if ($valutakurs) {
$kredit = afrund($kredit * $valutakurs / 100, 3);
$debet = afrund($debet * $valutakurs / 100, 3);
}
# Omregning til DKK.
$debet = afrund($debet, 2);
$kredit = afrund($kredit, 2);
$d_kontrol = $d_kontrol + $debet;
$k_kontrol = $k_kontrol + $kredit;
$fakturasum += $debet - $kredit;
if ($modtbill) {
$bilag = $modtagelse * 1;
} else {
$bilag = '0';
}
if ($sum) {
#cho "insert into transaktioner (bilag,transdate,beskrivelse,kontonr,faktura,debet,kredit,kladde_id,afd,logdate,logtime,projekt,ansat,ordre_id) values ('$bilag','$transdate','$beskrivelse','$kontonr','$fakturanr','$debet','$kredit','0',$afd,'$logdate','$logtime','$projekt[0]','$ansat','$id')<br>";
db_modify("insert into transaktioner (bilag,transdate,beskrivelse,kontonr,faktura,debet,kredit,kladde_id,afd,logdate,logtime,projekt,ansat,ordre_id) values ('{$bilag}','{$transdate}','{$beskrivelse}','{$kontonr}','{$fakturanr}','{$debet}','{$kredit}','0',{$afd},'{$logdate}','{$logtime}','{$projekt['0']}','{$ansat}','{$id}')", __FILE__ . " linje " . __LINE__);
}
if ($valutakurs) {
$maxdif = 2;
}
#Der tillades 2 oeres afrundingsdiff
$p = 0;
$projektliste = '';
$q = db_select("select distinct(projekt) from ordrelinjer where ordre_id={$id} and vare_id >\t'0'", __FILE__ . " linje " . __LINE__);
while ($r = db_fetch_array($q)) {
$p++;
$projekt[$p] = $r['projekt'];
$projektliste ? $projektliste .= "<br>" . $projekt[$p] : ($projektliste = $projekt[$p]);
}
$projektantal = $p;
if ($projektantal) {
db_modify("update openpost set projekt='{$projektliste}' where id='{$openpost_id}'", __FILE__ . " linje " . __LINE__);
}
for ($t = 1; $t <= 2; $t++) {
for ($p = 1; $p <= $projektantal; $p++) {
$y = 0;
$bogf_konto = array();
if ($t == 1) {
$q = db_select("select * from ordrelinjer where ordre_id={$id} and posnr>=0 and projekt='{$projekt[$p]}'", __FILE__ . " linje " . __LINE__);
} else {
$q = db_select("select * from ordrelinjer where ordre_id={$id} and posnr<0 and projekt='{$projekt[$p]}'", __FILE__ . " linje " . __LINE__);
}
while ($r = db_fetch_array($q)) {
if ($valutakurs) {
$maxdif = $maxdif + 2;
}
#Og yderligere 2 pr ordrelinje.
if (!in_array($r['bogf_konto'], $bogf_konto)) {
$y++;
$bogf_konto[$y] = $r['bogf_konto'];
$pos[$y] = $r['posnr'];
$pris[$y] = afrund($r['pris'] * $r['antal'] - $r['pris'] * $r['antal'] * $r['rabat'] / 100, 2);
#20110124 afrund dec aendret fra 3 til 2 saldi_205 ordre_id 997
} else {
for ($a = 1; $a <= $y; $a++) {
if ($bogf_konto[$a] == $r['bogf_konto']) {
$tmp = afrund($r['pris'] * $r['antal'] - $r['pris'] * $r['antal'] * $r['rabat'] / 100, 2);
#20110124 afrund dec aendret fra 3 til 2 saldi_205 ordre_id 997
$pris[$a] += $tmp;
}
}
}
}
if ($projekt[0] && !$projekt[$p]) {
$projekt[$p] = $projekt[0];
}
$ordrelinjer = $y;
for ($y = 1; $y <= $ordrelinjer; $y++) {
if ($bogf_konto[$y]) {
if ($pris[$y] > 0) {
$debet = $pris[$y];
$kredit = 0;
} else {
$debet = 0;
$kredit = $pris[$y] * -1;
}
$tmp1 = $kredit * $valutakurs / 100;
$tmp2 = $debet * $valutakurs / 100;
if ($t == 1 && $valutakurs) {
$kredit = afrund($kredit * $valutakurs / 100, 3);
$debet = afrund($debet * $valutakurs / 100, 3);
}
# Omregning til DKK.
$debet = afrund($debet, 2);
$kredit = afrund($kredit, 2);
$d_kontrol = $d_kontrol + $debet;
$k_kontrol = $k_kontrol + $kredit;
$linjesum += $debet - $kredit;
if ($pris[$y]) {
db_modify("insert into transaktioner (bilag,transdate,beskrivelse,kontonr,faktura,debet,kredit,kladde_id,afd,logdate,logtime,projekt,ansat,ordre_id) values ('{$bilag}','{$transdate}','{$beskrivelse}','{$bogf_konto[$y]}','{$fakturanr}','{$debet}','{$kredit}','0','{$afd}','{$logdate}','{$logtime}','{$projekt[$p]}','{$ansat}','{$id}')", __FILE__ . " linje " . __LINE__);
}
}
}
}
}
$r = db_fetch_array(db_select("select gruppe from adresser where id='{$konto_id}'", __FILE__ . " linje " . __LINE__));
$r = db_fetch_array(db_select("select box1,box6 from grupper where art='KG' and kodenr='{$r['gruppe']}'", __FILE__ . " linje " . __LINE__));
$box1 = substr(trim($r['box1']), 1, 1);
$smomsnr = substr(trim($r['box6']), 1, 1);
if (!$box1) {
$moms = 0;
}
#################### EU varekoeb moms ################
if (substr(trim($r['box1']), 0, 1) == 'E') {
$r = db_fetch_array(db_select("select box1,box2,box3 from grupper where art='EM' and kodenr='{$box1}'", __FILE__ . " linje " . __LINE__));
$kmomskto = trim($r['box3']);
# Ser lidt forvirrende ud,men den er go nok - fordi koebsmomsen ligger i box 3 v. udenlandsmoms.
$emomskto = $r['box1'];
$moms = $sum / 100 * $r['box2'];
#moms af varekoeb i udland beregnes
if ($moms > 0) {
$kredit = $moms;
$debet = '0';
} else {
$kredit = '0';
$debet = $moms * -1;
}
if ($valutakurs) {
$kredit = afrund($kredit * $valutakurs / 100, 3);
$debet = afrund($debet * $valutakurs / 100, 3);
}
# Omregning til DKK.
$momssum += $debet - $kredit;
$d_kontrol = $d_kontrol + $debet;
$k_kontrol = $k_kontrol + $kredit;
if ($moms) {
db_modify("insert into transaktioner (bilag,transdate,beskrivelse,kontonr,faktura,debet,kredit,kladde_id,afd,logdate,logtime,projekt,ansat,ordre_id) values ('{$bilag}','{$transdate}','{$beskrivelse}','{$emomskto}','{$fakturanr}','{$debet}','{$kredit}','0','{$afd}','{$logdate}','{$logtime}','{$projekt[$p]}','{$ansat}','{$id}')", __FILE__ . " linje " . __LINE__);
}
#################### EU ydelseskoeb moms ################
} elseif (substr(trim($r['box1']), 0, 1) == 'Y') {
$r = db_fetch_array(db_select("select box1,box2,box3 from grupper where art='YM' and kodenr='{$box1}'", __FILE__ . " linje " . __LINE__));
$kmomskto = trim($r['box3']);
# Ser lidt forvirrende ud,men den er go nok - fordi koebsmomsen ligger i box 3 v. udenlandsmoms.
$emomskto = $r['box1'];
$moms = $sum / 100 * $r['box2'];
#moms af varekoeb i udland beregnes
if ($moms > 0) {
$kredit = $moms;
$debet = '0';
} else {
$kredit = '0';
$debet = $moms * -1;
}
if ($valutakurs) {
$kredit = afrund($kredit * $valutakurs / 100, 3);
$debet = afrund($debet * $valutakurs / 100, 3);
}
# Omregning til DKK.
$momssum += $debet - $kredit;
$d_kontrol = $d_kontrol + $debet;
$k_kontrol = $k_kontrol + $kredit;
if ($moms) {
db_modify("insert into transaktioner (bilag,transdate,beskrivelse,kontonr,faktura,debet,kredit,kladde_id,afd,logdate,logtime,projekt,ansat,ordre_id) values ('{$bilag}','{$transdate}','{$beskrivelse}','{$emomskto}','{$fakturanr}','{$debet}','{$kredit}','0','{$afd}','{$logdate}','{$logtime}','{$projekt[$p]}','{$ansat}','{$id}')", __FILE__ . " linje " . __LINE__);
}
####################
} else {
#cho "$omlev && $smomsnr<br>";
if ($omlev && $smomsnr) {
#cho "select box1,box2,box3 from grupper where art='SM' and kodenr='$smomsnr'<br>";
$r = db_fetch_array(db_select("select box1,box2,box3 from grupper where art='SM' and kodenr='{$smomsnr}'", __FILE__ . " linje " . __LINE__));
$smomskto = $r['box1'];
#cho "SM $smomskto<br>";
$smoms = 0;
#cho "select * from ordrelinjer where ordre_id='$id' and omvbet='on' and momsfri!='on'<br>";
$q = db_select("select * from ordrelinjer where ordre_id='{$id}' and omvbet='on' and momsfri!='on'", __FILE__ . " linje " . __LINE__);
while ($r = db_fetch_array($q)) {
$linjesum = afrund($r['pris'] * $r['antal'] - $r['pris'] * $r['antal'] * $r['rabat'] / 100, 2);
#cho "LS $linjesum<br>";
$smoms += afrund($linjesum * $momssats / 100, 2);
#cho "MS $smoms<br>";
}
}
$moms += $smoms;
#cho "Moms $moms<br>";
if ($smoms > 0) {
$kredit = $smoms;
$debet = '0';
} else {
$kredit = '0';
$debet = $smoms * -1;
}
if ($valutakurs) {
$kredit = afrund($kredit * $valutakurs / 100, 3);
$debet = afrund($debet * $valutakurs / 100, 3);
}
# Omregning til DKK.
$kredit = afrund($kredit, 3);
$debet = afrund($debet, 3);
$d_kontrol = $d_kontrol + $debet;
$k_kontrol = $k_kontrol + $kredit;
if ($smoms) {
#cho "SM $smoms D $debet K $kredit<br>";
$tmp = $beskrivelse . " (Omvendt betaling)";
#cho "insert into transaktioner (bilag,transdate,beskrivelse,kontonr,faktura,debet,kredit,kladde_id,afd,logdate,logtime,projekt,ansat,ordre_id) values ('$bilag','$transdate','$tmp','$smomskto','$fakturanr','$debet','$kredit','0','$afd','$logdate','$logtime','$projekt[0]','$ansat','$id')<br>";
db_modify("insert into transaktioner (bilag,transdate,beskrivelse,kontonr,faktura,debet,kredit,kladde_id,afd,logdate,logtime,projekt,ansat,ordre_id) values ('{$bilag}','{$transdate}','{$tmp}','{$smomskto}','{$fakturanr}','{$debet}','{$kredit}','0','{$afd}','{$logdate}','{$logtime}','{$projekt['0']}','{$ansat}','{$id}')", __FILE__ . " linje " . __LINE__);
}
$r = db_fetch_array(db_select("select box1 from grupper where art='KM' and kodenr='{$box1}'", __FILE__ . " linje " . __LINE__));
$kmomskto = trim($r['box1']);
}
if ($moms > 0) {
$debet = $moms;
$kredit = '0';
} else {
$debet = '0';
$kredit = $moms * -1;
}
if ($valutakurs) {
$kredit = afrund($kredit * $valutakurs / 100, 3);
$debet = afrund($debet * $valutakurs / 100, 3);
}
# Omregning til DKK.
$kredit = afrund($kredit, 3);
$debet = afrund($debet, 3);
$d_kontrol = $d_kontrol + $debet;
$k_kontrol = $k_kontrol + $kredit;
$momssum += $debet - $kredit;
$moms = afrund($moms, 2);
if ($moms) {
#cho "insert into transaktioner (bilag,transdate,beskrivelse,kontonr,faktura,debet,kredit,kladde_id,afd,logdate,logtime,projekt,ansat,ordre_id) values ('$bilag','$transdate','$beskrivelse','$kmomskto','$fakturanr','$debet','$kredit','0','$afd','$logdate','$logtime','$projekt[0]','$ansat','$id')<br>";
db_modify("insert into transaktioner (bilag,transdate,beskrivelse,kontonr,faktura,debet,kredit,kladde_id,afd,logdate,logtime,projekt,ansat,ordre_id) values ('{$bilag}','{$transdate}','{$beskrivelse}','{$kmomskto}','{$fakturanr}','{$debet}','{$kredit}','0','{$afd}','{$logdate}','{$logtime}','{$projekt['0']}','{$ansat}','{$id}')", __FILE__ . " linje " . __LINE__);
}
db_modify("update ordrer set status=4,valutakurs={$valutakurs} where id={$id}", __FILE__ . " linje " . __LINE__);
db_modify("delete from ordrelinjer where ordre_id={$id} and posnr < 0", __FILE__ . " linje " . __LINE__);
}
$d_kontrol = afrund($d_kontrol, 2);
$k_kontrol = afrund($k_kontrol, 2);
if ($diff = afrund($d_kontrol - $k_kontrol, 2)) {
if ($valuta != 'DKK' && abs($diff) <= $maxdif) {
#Der maa max vaere en afvigelse paa 1 oere pr ordrelinje m fremmed valuta;
$debet = 0;
$kredit = 0;
if ($diff < 0) {
$debet = $diff * -1;
} else {
$kredit = $diff;
}
$debet = afrund($debet, 2);
$kredit = afrund($kredit, 2);
db_modify("insert into transaktioner (bilag,transdate,beskrivelse,kontonr,faktura,debet,kredit,kladde_id,afd,logdate,logtime,projekt,ansat,ordre_id) values ('{$bilag}','{$transdate}','{$beskrivelse}','{$difkto}','{$fakturanr}','{$debet}','{$kredit}','0','{$afd}','{$logdate}','{$logtime}','{$projekt['0']}','{$ansat}','{$id}')", __FILE__ . " linje " . __LINE__);
} else {
print "<BODY onLoad=\"javascript:alert('Der er konstateret en uoverensstemmelse i posteringssummen, kontakt DANOSOFT på telefon 4690 2208')\">";
print "<meta http-equiv=\"refresh\" content=\"0;URL=ordre.php?id={$id}\">";
exit;
}
}
#print "<BODY onLoad=\"javascript:alert('xxxxxxxxxxxxxxxxxxxx')\">";
#xit;
# genberegn($regnaar);
}
if ($lukket[$x]) {
$lukket[$x] = "checked";
}
print "<td align=center><input type=checkbox name=lukket[{$x}] {$lukket[$x]}></td>";
if ($saldiregnskab) {
print "<td><input type=text size='8' style=\"text-align:right\" name=\"lukkes[{$x}]\" value=\"{$lukkes[$x]}\"</td>";
print "<td><input type=text size='8' style=\"text-align:right\" name=\"betalt_til[{$x}]\" value=\"{$betalt_til[$x]}\"</td>";
print "<td><input type=text size='25' style=\"text-align:right\" name=\"logintekst[{$x}]\" value=\"{$logintekst[$x]}\"</td>";
}
print "</tr>";
} else {
# if ($admin || in_array($r['id'],$adgang_til)) {
# if ($beregn) echo "update regnskab set posteret='$posteringer[$x]' sidst='$sidst[$x]' where id='$id[$x]'<br>";
#cho "update regnskab set posteret='$posteringer[$x]',sidst='$sidst[$x]' where id='$id[$x]'<br>";
if ($beregn) {
db_modify("update regnskab set posteret='{$posteringer[$x]}',sidst='{$sidst[$x]}' where id='{$id[$x]}'", __FILE__ . " linje " . __LINE__);
}
print "<tr><td align=\"right\"> {$id[$x]}</td><td><a href=aaben_regnskab.php?db_id={$id[$x]}>{$regnskab[$x]}</a></td>";
print "<td>{$brugerantal[$x]}<br></td>";
print "<td>{$posteringer[$x]}<br></td>";
print "<td align=\"right\">{$posteret[$x]}<br></td>";
print "<td align=\"right\">" . date("d-m-Y", $sidst[$x]) . "<br></td>";
if ($lukket[$x]) {
$lukket[$x] = "✔";
}
print "<td align=center>{$lukket[$x]}<br></td>";
if ($saldiregnskab) {
print "<td align=\"right\">{$betalt_til[$x]}<br></td>";
// print "<td align=\"right\">$lukkes[$x]<br></td>";
print "<td align=\"right\">{$logintekst[$x]}<br></td>";
}
