X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;ds=sidebyside;f=lxo-import%2Fimport_lib.php;h=d8b2259c18a882e3e620f434897b066b0324ba0b;hb=b2c8e6aad4973545057c6529445c0f5f6f2a1cbe;hp=a383e0a56bd38792c8a131f39a1b88a4beaefdb1;hpb=e2903b0d056db3b97b846ddde87a44b4f5a10954;p=kivitendo-erp.git diff --git a/lxo-import/import_lib.php b/lxo-import/import_lib.php index a383e0a56..d8b2259c1 100644 --- a/lxo-import/import_lib.php +++ b/lxo-import/import_lib.php @@ -123,9 +123,7 @@ $contactscrm = array( "cp_privatemail" => "private eMail", "cp_notes" => "Bemerkungen", "cp_stichwort1" => "Stichwort(e)", - "katalog" => "Katalog", - "inhaber" => "Inhaber", - "contact_id" => "Kontakt ID" + "cp_id" => "Kontakt ID" ); $contacts = array( @@ -146,9 +144,7 @@ $contacts = array( "cp_privatphone" => "Privattelefon", "cp_privatemail" => "private eMail", "cp_homepage" => "Homepage", - "katalog" => "Katalog", - "inhaber" => "Inhaber", - "contact_id" => "Kontakt ID" + "cp_id" => "Kontakt ID" ); function checkCRM() { @@ -177,7 +173,7 @@ global $db,$file,$test; if ($test) { return "#####"; } $sql1="select * from defaults"; $sql2="update defaults set ".$file."number = '%s'"; - $db->lock(); + $db->begin(); $rs=$db->getAll($sql1); $nr=$rs[0][$file."number"]; preg_match("/^([^0-9]*)([0-9]+)/",$nr,$hits); @@ -205,7 +201,16 @@ global $db,$file,$test; return $data; } } - +function chkContact($id) { +global $db; + $sql="select * from contact where cp_id = $id"; + $rs=$db->getAll($sql); + if ($rs[0]["cp_id"]==$id) { + return true; + } else { + return false; + } +} function getKdRefId($data) { // gibt es die Nummer schon? global $db,$file,$test; @@ -358,10 +363,14 @@ function authuser($dbhost,$dbport,$dbuser,$dbpasswd,$dbname,$cookie) { $db->query($sql2,"authuser_B"); $sql3="insert into session ";*/ } + $sql="select * from auth.user where id=".$rs[0]["id"]; + $rs1=$db->getAll($sql,"authuser_1"); + if (!$rs1) return false; + $auth=array(); + $auth["login"]=$rs1[0]["login"]; $sql="select * from auth.user_config where user_id=".$rs[0]["id"]; $rs1=$db->getAll($sql,"authuser_2"); - $auth=array(); - $keys=array("login","dbname","dbpasswd","dbhost","dbport","dbuser"); + $keys=array("dbname","dbpasswd","dbhost","dbport","dbuser"); foreach ($rs1 as $row) { if (in_array($row["cfg_key"],$keys)) { $auth[$row["cfg_key"]]=$row["cfg_value"];