Web Connection
Point-of-Sale App Using WWWC
Gravatar is a globally recognized avatar based on your email address. Point-of-Sale App Using WWWC
  Steve
  All
  Jun 24, 2018 @ 01:34pm

Hi All,
Has anyone ever written a Point-of-Sale app with WWWC? I've been trying to do this for years now, but always seem to get side tracked. I have decided that there's no reason to develop a Web Frontend for all of the functions within my VFP Desktop App. However, I think a POS Function along with Adding Customers and Checking Prices is needed. I would love to see some examples of existing projects/sites, and talk to anyone that may be interested in doing this work on a contract basis.

It would need to use the latest version of WWWC with Business Objects.
It needs to support both VFP and SQL on the backend.
It needs to have an attractive and responsive frontend.

Are there specific challenges with creating a web-based POS System? What about: Quickly Printing Invoices that's a VFP Report? Credit Card Processing? Cash Drawer Interface? Utilizing 40 Character Receipt Printers, which some customers prefer? Supporting Barcode Scanners? Importing Line Items from Pick Lists? Fast and Efficient Sales Entry?

Thanks for any feedback,
Steve

Gravatar is a globally recognized avatar based on your email address. re: Point-of-Sale App Using WWWC
  FoxInCloud Support - Thierry N.
  Steve
  Jun 25, 2018 @ 12:50pm

Hi Steve,

You may also want to consider FoxInCloud; based on West-Wind Web Connect, FoxInCloud empowers your desktop application to also run as a Web Application.

FoxInCloud supports any data access strategy, including SQL database, and generates responsive HTML/CSS/JS using Bootstrap automatically from your VFP forms.

We have customers using FoxInCloud to run ERPs involving a lot of interaction with specialized peripherals (data acquisition and output).

In production since 2011, FoxInCloud today reaches over 99.99% availability under production load (30 concurrent users with over 30k requests per day on 50 forms and 35 reports).

You can first adapt some part of your application and later increase the scope covered over time.

For a more detailed overview, please see FoxInCloud Live Tutorial

Gravatar is a globally recognized avatar based on your email address. re: Point-of-Sale App Using WWWC
  Steve
  FoxInCloud Support - Thierry N.
  Jun 25, 2018 @ 04:52pm

Thank you Thierry, I will certainly keep FIC in mind as an option. Currently, I use the MSComm Control to interface with Cash Drawers. Any idea how I might handle this with FIC?

Steve

Gravatar is a globally recognized avatar based on your email address. re: Point-of-Sale App Using WWWC
  FoxInCloud Support - Thierry N.
  Steve
  Jun 25, 2018 @ 06:47pm

Depends on the MSComm Control interface

Currently FoxInCloud supports Treeview MSComm Control by mapping the Bootstrap Treeview PEMs to the MS treeview PEMs.

Basically we need some HTML+CSS+JS component with a behavior similar to what your MSComm Control does; then we implement the hooks to make your VFP code run whenever a matching HTML event occurs.

Gravatar is a globally recognized avatar based on your email address. re: Point-of-Sale App Using WWWC
  Rick Strahl
  FoxInCloud Support - Thierry N.
  Jun 26, 2018 @ 10:40pm

Why would you need that? The MS Comm control is a non-visual component so you can stub it out with a custom control and just forward the calls no?

+++ Rick ---

Gravatar is a globally recognized avatar based on your email address. re: Point-of-Sale App Using WWWC
  FoxInCloud Support - Thierry N.
  Rick Strahl
  Jun 27, 2018 @ 01:39am

Right, ActiveX without a user interface, and API calls, can just be kept as is in FoxInCloud. No adaptation, no rewrite.

You just need to make sure that the dependencies are installed on the production server.

In this case, Steve needs some device to interface his web server with the local peripherals through http.

Gilles should drop in and explain how his FoxInCloud web app remotely controls human bio analyzers.

Gravatar is a globally recognized avatar based on your email address. re: Point-of-Sale App Using WWWC
  Gilles Lajot-Sarthou
  Steve
  Jun 27, 2018 @ 02:45am

Hello, I suppose that the cash drawers are not connected by RS232c to the WEB server, but they are to connect to the remote stations.

1 - Either there is on each PC to which the cash drawers will be attached by the COMM port, a remote office manager or vpn passing through IP the serial port to the WEB server and in this case the VFP application listed server will need to manage the serial port of each cashier through this VPN or TSE Remote Desktop link

2 - Either there is on each PC a local executable which manages the COMM port of the cash drawers and which dialogs by IP with the SQL database of the WEB application

3 - Either there is on each PC a local executable which manages the COMM port of the cash drawers and which dialogue by exchange of files with the WEB server under VPN or by FTP

If the cash drawers are connected directly by RS232c on the WEB server, there is nothing to do in particular, others communicate with them by RS232c ports.

In my applications managing medical analyzers by RS232c, I opted for solution 3 by FTP.

Regards Gilles

PS: My english is so poor that i need to use google translate

© 1996-2024