BOA-Session

Vom Front-End bis SOAP.

Moderator: Moderatoren

Termin/e, an dem/denen ich könnte (jeweils 18.00 Uhr)

Umfrage endete am Mo, 02. Mai 2022 15:54

9. Mai 2022
10
25%
10. Mai 2022
9
23%
11. Mai 2022
11
28%
12. Mai 2022
10
25%
 
Insgesamt abgegebene Stimmen: 40

Benutzeravatar
azzo
Rekursionen-Architekt
Rekursionen-Architekt
Beiträge: 483
Registriert: So, 28. Mär 2010 19:21
Danksagung erhalten: 11 Mal

Re: BOA-Session

Beitrag von azzo »

Hallo Tom, hallo Chris,
ich kann mir nicht vorstellen, wie das mit den PDFs und Bondruckern funktioniert.
Ich meine, wenn du auf "Rechnung abschließen" klickst, dass dann gleich der Bon für die
Speisen in der "Küche", für die "Getränke" an der Bar und die Rechnung am Rechnungsdrucker gedruckt wird?

LG
Otto
Benutzeravatar
Tom
Der Entwickler von "Deep Thought"
Der Entwickler von "Deep Thought"
Beiträge: 9345
Registriert: Do, 22. Sep 2005 23:11
Wohnort: Berlin
Hat sich bedankt: 100 Mal
Danksagung erhalten: 359 Mal
Kontaktdaten:

Re: BOA-Session

Beitrag von Tom »

Hallo, Otto.
Ich meine, wenn du auf "Rechnung abschließen" klickst, dass dann gleich der Bon für die Speisen in der "Küche", für die "Getränke" an der Bar und die Rechnung am Rechnungsdrucker gedruckt wird?
Äh. Hätte ich eine solche Anwendung, würde ich das im Backend machen. Wo es auch hingehört. Also Formular generieren und ohne Umwege (also ohne Export als PDF, HTML oder sonstwas) an die Drucker. Und im Frontend nur aufblippen lassen: "Okay, Bong wurde gedruckt." :wink:

Edit: Ich verstehe, um ehrlich zu sein, nicht, worauf Du überhaupt hinauswillst. Du arbeitest mit "mod harbour", das ist ein Apache-Mod, das es erlaubt, mit harbour-Anwendungen vergleichsweise einfach HTML-Frontends zu erzeugen, wenn ich das richtig verstehe (das zuletzt vor über zwei Jahren gepflegte md ist ein bisschen uneindeutig). Willst Du dafür werben? Also für harbour, das Mod und Apache? Oder für Deine Lösung/Deinen Lösungsweg? Willst Du um Unterstützung werben? Was ist Dein Ziel?
Herzlich,
Tom
skiman
Cut&Paste-Entwickler
Cut&Paste-Entwickler
Beiträge: 34
Registriert: Di, 25. Mai 2010 20:18
Hat sich bedankt: 2 Mal
Danksagung erhalten: 21 Mal

Re: BOA-Session

Beitrag von skiman »

Hi Otto,

Printing on different printers isn't a problem. Directly printing from a webapplication to a printer on a network is not that common. In some cases it will not work because of security settings. However with BOA this isn't a problem. I try to explain below.

In your case I suppose that all these devices are on the same network in a hotel, and all the printers (kitchen, bar, reception, ...) are shared printers or are networkprinters? Correct?

In fact you use again the same code as in your Windows application. I suppose that you have now also a screen for the input, and when this is validated, you process this. In your application a function decides what to print and where to print.

Your iAPI server can do the same thing. Once the order is registered and send to the endpoint, you can process this the same way as you do in your Windows application.

In this case there is also no need to create a PDF but you send it to the printer as you would do in your Windows application.

Hope this makes it clear?

Best regards,
Chris
Best regards,

Chris Andries
skiman
Cut&Paste-Entwickler
Cut&Paste-Entwickler
Beiträge: 34
Registriert: Di, 25. Mai 2010 20:18
Hat sich bedankt: 2 Mal
Danksagung erhalten: 21 Mal

Re: BOA-Session

Beitrag von skiman »

@Otto,

Meanwhile I took the time to visit the modharbour.club.

You can use BOA with Harbour, you can create a http-server with the use of hbhttpd. This way you can use both systems at the same time. You can have your screens with the tables, and meanwhile use the fast way to develop the grids and forms you need for the other tasks.

Just for fun I added your screen to my demo. You can try it.
Start the demo on http://demo.boa-platform.com
Enter as user 'de' and as password 'de01'. This way you will get German screens. (Translated with Google).
Select the option Kunden and as search key enter 'abo'
A list will appear will all the customers where the name begins with ABO.
Select a customer.
Go to the tabpage 'Verwaltung'.
Now you will see two buttons at the bottom of the screen. Of course, this could be implemented everywhere in the system. The mod_harbour screens could also be shown in a form or in a separate tabpage of the browser.

Now you are in this screen. This is a customer database of more than 30.000 records, with 130.000 contacts.
Try the following search keys:
*service -> will give all the customers where 'service' is somewhere in the database.
*omzet>100 -> will give all the customers where the sales > 100.
*373647 will give one customer. This customer has 1 contact with a phonenumber that is 050/37.36.47. You can check this in the tabpage 'Termine'.

Did you notice the speed? If you can do that with your Bootstrap tables, I would like to see how you do it.

Best regards,
Chris
Best regards,

Chris Andries
Benutzeravatar
Jan
Marvin
Marvin
Beiträge: 14641
Registriert: Fr, 23. Sep 2005 18:23
Wohnort: 49328 Melle
Hat sich bedankt: 21 Mal
Danksagung erhalten: 87 Mal
Kontaktdaten:

Re: BOA-Session

Beitrag von Jan »

skiman hat geschrieben: Di, 17. Mai 2022 16:01 Just for fun I added your screen to my demo. You can try it.
Start the demo on http://demo.boa-platform.com
Enter as user 'de' and as password 'de01'. This way you will get German screens. (Translated with Google).
That gives me an "Error: Http failure response for http://109.237.216.152:8880/v1.0/login: 0 Unknown Error"

Jan
Mitglied der XUG Osnabrück
Mitglied der XUG Berlin/Brandenburg
Mitglied des Deutschsprachige Xbase-Entwickler e. V.
skiman
Cut&Paste-Entwickler
Cut&Paste-Entwickler
Beiträge: 34
Registriert: Di, 25. Mai 2010 20:18
Hat sich bedankt: 2 Mal
Danksagung erhalten: 21 Mal

Re: BOA-Session

Beitrag von skiman »

Hi Jan,

I'm wondering if there is some check on the server for the IP address.

Could you try the following:
Go to https://www.boa-platform.com
Click in the menu on Demo.
Select 'Yes, bring me to the demo'.

In case this isn't working, you can try the following link:
http://eon.aboservice.be, this is another server in Belgium.

Best regards,
Chris
Best regards,

Chris Andries
Benutzeravatar
Jan
Marvin
Marvin
Beiträge: 14641
Registriert: Fr, 23. Sep 2005 18:23
Wohnort: 49328 Melle
Hat sich bedankt: 21 Mal
Danksagung erhalten: 87 Mal
Kontaktdaten:

Re: BOA-Session

Beitrag von Jan »

Chris,

version 1: Http failure response for http://109.237.216.152:8880/v1.0/login: 0 Unknown Error

version 2: Http failure response for http://109.237.216.152:8880/v1.0/login: 0 Unknown Error

Both tested with user de and password de01

Jan
Mitglied der XUG Osnabrück
Mitglied der XUG Berlin/Brandenburg
Mitglied des Deutschsprachige Xbase-Entwickler e. V.
Benutzeravatar
Tom
Der Entwickler von "Deep Thought"
Der Entwickler von "Deep Thought"
Beiträge: 9345
Registriert: Do, 22. Sep 2005 23:11
Wohnort: Berlin
Hat sich bedankt: 100 Mal
Danksagung erhalten: 359 Mal
Kontaktdaten:

Re: BOA-Session

Beitrag von Tom »

Ich habe damit keine Probleme, Jan.
Herzlich,
Tom
skiman
Cut&Paste-Entwickler
Cut&Paste-Entwickler
Beiträge: 34
Registriert: Di, 25. Mai 2010 20:18
Hat sich bedankt: 2 Mal
Danksagung erhalten: 21 Mal

Re: BOA-Session

Beitrag von skiman »

@Jan,

Maybe your firewall doesn't allow the BOA platform to connect to another server. In this case the IP for the iAPI server of the demo?

Regards,
Chris
Best regards,

Chris Andries
Benutzeravatar
Jan
Marvin
Marvin
Beiträge: 14641
Registriert: Fr, 23. Sep 2005 18:23
Wohnort: 49328 Melle
Hat sich bedankt: 21 Mal
Danksagung erhalten: 87 Mal
Kontaktdaten:

Re: BOA-Session

Beitrag von Jan »

Tom,

mir war das schon auf einem anderen Rechner bei mir während der Demo aufgefallen. Ich bin hier hinter einer ganz normalen Fritz!Box mit Standard-Einstellungen. Die gibt mir auch keine Warnmeldungen das da irgend was was unerlaubtes tun will.

Ich hatte mich immer gefragt ob da in der Anmeldung irgend was in das Feld für die URL der API gehört. Das ist bei mir immer leer. Aber in Chris Beschreibungen steht nirgends was, was da rein sollte.

Jan
Mitglied der XUG Osnabrück
Mitglied der XUG Berlin/Brandenburg
Mitglied des Deutschsprachige Xbase-Entwickler e. V.
skiman
Cut&Paste-Entwickler
Cut&Paste-Entwickler
Beiträge: 34
Registriert: Di, 25. Mai 2010 20:18
Hat sich bedankt: 2 Mal
Danksagung erhalten: 21 Mal

Re: BOA-Session

Beitrag von skiman »

Hi Jan,

No, you don't need to enter something isn the API/URL. If this is empty, if will use my demo iAPI.

If you have your own iAPI server, you can enter your URL. This can be a http://localhost:8888/....

For the demo you can leave it empty, so my server will be contacted. The IP you have seen in the error message http://109.237.....

Up to now this problem happened one time before. It was a security setting on the system of the user. It didn't allow BOA to make the connexion with the API server. After changing a security setting in the system it was solved.

I was searching if I could find it in my mails, but up to now I had no success.

Regards,
Chris.
Best regards,

Chris Andries
Benutzeravatar
azzo
Rekursionen-Architekt
Rekursionen-Architekt
Beiträge: 483
Registriert: So, 28. Mär 2010 19:21
Danksagung erhalten: 11 Mal

Re: BOA-Session

Beitrag von azzo »

Hello Chris,
Respect and congratulations.
Everything works well and smoothly.

May I ask if this is a test database and if I could download it.
It would be nice if we could do some direct comparisons.
You can learn a lot from each other.

I'll make a short video with an editing question in a moment.
I'll post it then.

Best regards,
Otto
skiman
Cut&Paste-Entwickler
Cut&Paste-Entwickler
Beiträge: 34
Registriert: Di, 25. Mai 2010 20:18
Hat sich bedankt: 2 Mal
Danksagung erhalten: 21 Mal

Re: BOA-Session

Beitrag von skiman »

Hi Otto,

I need to 'hussle' that database to be sure there aren't any real addresses in it. Then I can post a link to it, it is rather big. There are a lot of fields in it.

Regards,
Chris
Best regards,

Chris Andries
skiman
Cut&Paste-Entwickler
Cut&Paste-Entwickler
Beiträge: 34
Registriert: Di, 25. Mai 2010 20:18
Hat sich bedankt: 2 Mal
Danksagung erhalten: 21 Mal

Re: BOA-Session

Beitrag von skiman »

@Otto,

In attachment the demo database.
klant000 has more than 30.000 customers
klext000 has more than 180.000 contacts.

The database is scrambled, all addresses are fictive and email is empty.

Regards,
Chris
Dateianhänge
demodatabase.zip
(4.68 MiB) 86-mal heruntergeladen
Best regards,

Chris Andries
Benutzeravatar
azzo
Rekursionen-Architekt
Rekursionen-Architekt
Beiträge: 483
Registriert: So, 28. Mär 2010 19:21
Danksagung erhalten: 11 Mal

Re: BOA-Session

Beitrag von azzo »

Hi Chris,
thank you.
I try to link in your data.

At the moment I am working on this:

I have 2 more AJAX calls build in.
1) Before I start editing, I check if the data inside the browser is still the same as in the database.
2) Before I save the edited data, I make the same test again. Otherwise, it could be that the record was changed meanwhile and I would overwrite data not knowing it.

I noticed that your demo does none of these checks.
Best regards,
Otto

Bild
skiman
Cut&Paste-Entwickler
Cut&Paste-Entwickler
Beiträge: 34
Registriert: Di, 25. Mai 2010 20:18
Hat sich bedankt: 2 Mal
Danksagung erhalten: 21 Mal

Re: BOA-Session

Beitrag von skiman »

Hi Otto,

I knew there must be something...

Anyway, you are not correct. It is up to you to decide how to do this.
1. Loading: When you select a row in the grid, the data is requested. So you have the data as it is on that moment. It is not the data from the grid, since that data could be updated. Also the content of the grid is quite different according to the form.

2. Saving: You can send to BOA what you want. So if you have a field 'name', you can also send the field 'original_name'. This can be a hidden field and contain the same value. You can do this for every field. At the moment you want to save, you can verify easily if the original_name is still the same as in the database. If not, you know there was a change by someone else. At that moment it is up to you to decide what to do with it.

In your iAPI you can do what you want. You can build a system to verify if data was changed since it was loaded. When you have a GET request, you could add it to an array, and when you have a PUT request, you could verify it first.

An online application is stateless, a user can open a customer entry screen and after hours he can modify and save something. You could also add a time stamp when loading a record, and change it in the database at saving. If at the moment of saving the timestamp is different, the data is changed by someone else.

It is up to you to create the behaviour you want, you could even do server-side validations at the moment of editing. Send the timestamp to an endpoint to verify if it is the same as in the database. If not, immediately inform the user about it, so he can reload it.

For the last years I have been working with a lot of rest-API's to connect to different systems as Mailchimp, Woocommerce, Prestashop, Magento, ... None of them has such a control in it. If you send to the API that you want a product with ID xxx changed, it will change it. It is up to the developer to verify if you have the most recent data or not.

Regards,
Chris
Best regards,

Chris Andries
skiman
Cut&Paste-Entwickler
Cut&Paste-Entwickler
Beiträge: 34
Registriert: Di, 25. Mai 2010 20:18
Hat sich bedankt: 2 Mal
Danksagung erhalten: 21 Mal

Re: BOA-Session

Beitrag von skiman »

Hi Otto,

After checking one of your demo's, I can say that my customers wouldn't be pleased with the way it works.
- Clicking to select a row.
- Click on the edit button to start editing.

If you have to enter hundreds of order lines a day, you won't be happy with this kind of behaviour.

Just my two cents,

Regards,
Chris
Best regards,

Chris Andries
Benutzeravatar
azzo
Rekursionen-Architekt
Rekursionen-Architekt
Beiträge: 483
Registriert: So, 28. Mär 2010 19:21
Danksagung erhalten: 11 Mal

Re: BOA-Session

Beitrag von azzo »

Hi Chris,
Thanks for the test file.
Here is a small first test run.
I am glad. Speed is not an issue.
I read all 30800 records and you in my comparison 659 at letter A.

It seems to me that both are similarly fast.

Also a quick search example.

How does full text search work for you?



Best regards,
Otto

Bild
skiman
Cut&Paste-Entwickler
Cut&Paste-Entwickler
Beiträge: 34
Registriert: Di, 25. Mai 2010 20:18
Hat sich bedankt: 2 Mal
Danksagung erhalten: 21 Mal

Re: BOA-Session

Beitrag von skiman »

Hi Otto,

If you would have read one of my previous posts, and executed my sample, you should know that with '*klein' you would get the results. In EON the result is 132 records. A customer as nummer 757 should also appear in the list, since there is a contact for this customer with the word 'klein' in his details.

How about your search for the phone number 373647? It is in one of the contact addresses which are related to the customers.

The '*'+'key' is used the same way as in my windows application, my customers likes it. But that is just the iAPI that defines this. You can develop it without the *.

With the * we also have the possibility to enter queries as *omzet>100. How would you do that?

Anyway, it seems as you try to 'prove' that BOA isn't a good solution. I don't know why, but the only comment you have is negative. You are obviously looking for a way to promote mod_harbour.

With mod_harbour you need an Apache server, work with Harbour, use html and css, use Bootstrap. Xbase++ developers don't like that idea, they don't want to move to Harbour. Why should they? BOA exists because a lot of developers want to use their own tools. They aren't looking for a solution where they need to install an Apache server at the customers side. Installing it is also maintaining it. Can be a nightmare if you ask me.

Besides that, waiting to see a real working version of that demo. Wondering how fast that loading of 30.000 records is. And how you will load the 180.000 customer contacts and do a full text search at the same moment. Just curious about that. And how about the bandwidth, how much datatransfert you have with this if you load the complete database?

I can't wait to see the demo tomorrow.

Have a nice evening,

Regards,
Chris.
Best regards,

Chris Andries
Benutzeravatar
azzo
Rekursionen-Architekt
Rekursionen-Architekt
Beiträge: 483
Registriert: So, 28. Mär 2010 19:21
Danksagung erhalten: 11 Mal

Re: BOA-Session

Beitrag von azzo »

Hi Chris,
I'm sorry, but I have nothing to sell that would be interesting here.
I am here because this is the only German-speaking group that deals with CLIPPER.

I like to exchange ideas.

By the way, I've been here since 2010.
Joined: Sun, 28 Mar 2010 19:21

Best regards,
Otto
skiman
Cut&Paste-Entwickler
Cut&Paste-Entwickler
Beiträge: 34
Registriert: Di, 25. Mai 2010 20:18
Hat sich bedankt: 2 Mal
Danksagung erhalten: 21 Mal

Re: BOA-Session

Beitrag von skiman »

Jan hat geschrieben: Di, 17. Mai 2022 16:49 Chris,

version 1: Http failure response for http://109.237.216.152:8880/v1.0/login: 0 Unknown Error

version 2: Http failure response for http://109.237.216.152:8880/v1.0/login: 0 Unknown Error

Both tested with user de and password de01

Jan
Hi Jan,

I succeeded to get the same error.
If I start httpS://demo.boa-platform.com I have the same error.

If I start http://demo.boa-platform.com is works.

This is depending on the API server you build. If your API is protected with SSL, then you can use httpS. If not, you need to start it with the http.

My demo API server is without SSL, so you need to start it with http://... I suppose when you don't add http in front of it, your Fritz router is adding https by itself.

The cause of this is when a secure website (https) tries to get a response of a non-secure (http) you get a CORS Error.

When you create an API, you need to set the CORS headers, see the documentation at https://boa-platform.com/manual/cors_pr ... eaders.htm.

I hope this is the solution for you.

Best regards,
Chris
Best regards,

Chris Andries
Benutzeravatar
Jan
Marvin
Marvin
Beiträge: 14641
Registriert: Fr, 23. Sep 2005 18:23
Wohnort: 49328 Melle
Hat sich bedankt: 21 Mal
Danksagung erhalten: 87 Mal
Kontaktdaten:

Re: BOA-Session

Beitrag von Jan »

Hi Chris,

my standard browser is Firefox. And he is automaticly switching to https. No chance to do a simple http. Or I don't knwo how to.

I now tested it with Edge. And that did work. So it is not my Fritz!box. Would have surprised me.

Thanks for the hint.

Jan
Mitglied der XUG Osnabrück
Mitglied der XUG Berlin/Brandenburg
Mitglied des Deutschsprachige Xbase-Entwickler e. V.
Benutzeravatar
BJelinek
Rekursionen-Architekt
Rekursionen-Architekt
Beiträge: 218
Registriert: Sa, 02. Jun 2012 20:57
Wohnort: 73257 Köngen
Hat sich bedankt: 9 Mal
Danksagung erhalten: 3 Mal

Re: BOA-Session

Beitrag von BJelinek »

Hallo Jan
Firefox
Einstellungen
Datenschutz und Sicherheit ganz unten
Nur-HTTPS-Modus
HTTPS bietet eine sichere, verschlüsselte Verbindung zwischen Firefox und den von Ihnen besuchten Websites. Die meisten Websites unterstützen HTTPS und wenn der Nur-HTTPS-Modus aktiviert ist, wird Firefox alle Verbindungen zu HTTPS aufrüsten.Weitere Informationen
Nur-HTTPS-Modus in allen Fenstern aktivieren
Nur-HTTPS-Modus nur in privaten Fenstern aktivieren
Nur-HTTPS-Modus nicht aktivieren

kann man hier beeinflussen.
Grüße
Bernd

Mitglied des Deutschsprachige Xbase-Entwickler e. V.
Benutzeravatar
Jan
Marvin
Marvin
Beiträge: 14641
Registriert: Fr, 23. Sep 2005 18:23
Wohnort: 49328 Melle
Hat sich bedankt: 21 Mal
Danksagung erhalten: 87 Mal
Kontaktdaten:

Re: BOA-Session

Beitrag von Jan »

Hallo Bernd,

ist bei mir genau so eingestellt. Baut der aber trotzdem automatisch um.

Jan
Mitglied der XUG Osnabrück
Mitglied der XUG Berlin/Brandenburg
Mitglied des Deutschsprachige Xbase-Entwickler e. V.
Benutzeravatar
BJelinek
Rekursionen-Architekt
Rekursionen-Architekt
Beiträge: 218
Registriert: Sa, 02. Jun 2012 20:57
Wohnort: 73257 Köngen
Hat sich bedankt: 9 Mal
Danksagung erhalten: 3 Mal

Re: BOA-Session

Beitrag von BJelinek »

Hallo Jan,

hast Du "Nur-HTTPS-Modus nicht aktivieren" ausgewählt?

Dann wird bei mir kein HTTP in HTTPS umgewandelt.
Grüße
Bernd

Mitglied des Deutschsprachige Xbase-Entwickler e. V.
Antworten