projekt kivitendo

            $this->db->rollback();

            return false;

        } else {

            return $rs['id'];

        }

    }

        return true;

    }

    function insCustomer($data) {

        if ($this->docustnr == 1) {

            $data['customernumber'] = $this->getNewNr('customer');

        } else {

                $sql = "SELECT id FROM customer WHERE customernumber = '".$data['customernumber']."'";

                $rs = $this->db->getOne($sql);

                $rc = $rs['id'];

            } else {

                $this->error->write('erplib','Kunde anlegen: '.$data["name"]);

                $this->db->rollback();

            $sql = "SELECT * FROM customer WHERE id = ".$data['customer_id'];

            $rs = $this->db->getOne($sql);

            if ($rs['id'] == $data['customer_id']) {

                 $sql  = "UPDATE customer SET greeting = :greeting,name = :name,street = :street,city = :city,country = :country,";

                 $sql .= "zipcode = :zipcode,contact = :contact,phone = :phone,email = :email WHERE id = :customer_id";

                 $rc =  $this->db->update($sql,$data);

            $this->error->write('erplib','Auftrag anlegen');

            return -1;

        }

        $rc = $this->db->Commit();

        return $data["customer_id"];

    }

           } else {

               return $rs['id'];

           }

           $data['id'] = $this->mkNewPart($data);

           if ($long) {

               return $data;

       $sql .= ":image,:buchungsgruppen_id,1,1,1)";

       $rc = $this->db->insert($sql,$data);

       $x =  $this->chkPartnumber($data,False);

       $this->error->write('erplib','Artikel neu: '.$data['partnumber']);

       return $x;

    }