micwallace / wallacepos Goto Github PK
View Code? Open in Web Editor NEWWallacePOS uses the power of the modern web to provide an easy to use & extensible POS system.
License: GNU Lesser General Public License v3.0
WallacePOS uses the power of the modern web to provide an easy to use & extensible POS system.
License: GNU Lesser General Public License v3.0
I'm interested in using this POS, might be adding features to it. Any plan to add a feature for profit calculation?
Feature overview:
To acces admin account display this message:
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'wallacepos.i.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
It allows changes to the settings but does not add Locations & Devices.
Run new version wallacepos in:
Lubuntu 16.04 LTS
Kernel Linux 4.4.0-21-generic (i686)
Apache/2.4.18 (Ubuntu)
MySQL 5.7.12-0ubuntu1
PHP: 7.0.4-7ubuntu2
Excuse me work that I am generating ;-)
Thanks.
It seems from the test installation's admin console that there is no multilingual support. This was my query. You should probably make that explicit somewhere to save others time.
Friends starting bar in China; need Chinese support on printed receipts (interface not important).
i18n support explained.
No mention of i18n.
Add question to FAQ.
This Issue is to keep track of getting WallacePOS to work on Windows XAMPP.
1.a. is_writable(...) does not work well with Windows. Used OS selection & win_is_writable( ... ) from Wordpress to help fix this.
PHP has issues with Windows ACL's for determine if a directory is writable or not, this works around them by checking the ability to open files rather than relying upon PHP to interprate the OS ACL.
However, I run into the problem 1.b. which makes solution to 1.a. pretty much useless.
1.b. RecursiveDirectoryIterator does not seem to work well with windows, breaks after the first .XXXX file (i.e. a file that starts with dot '.').
When installing wallapop in step 2 configuration database displays this error: Warning: file_put_contents(/var/www/html/tpv_restaurante//library/wpos/.dbconfig.json): failed to open stream: Permission denied in /var/www/html/tpv_restaurante/installer/index.php on line 159.
Everything looks correct first step
Thanks
What does Cash Reconciliation means in POS?
Sincerely
I think this is saying it can't access the mysql database. Does the database need a user www-data with no password?
[Thu Apr 30 08:59:22.715398 2015] [:error] [pid 2737] [client 192.168.2.145:53860] PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[28000] [1045] Access denied for user 'www-data'@'localhost' (using password: NO)' in /usr/share/wallacepos-master/library/wpos/models/db/DbConfig.php:79\nStack trace:\n#0 /usr/share/wallacepos-master/library/wpos/models/db/DbConfig.php(79): PDO->__construct('mysql:host=loca...', '', '')\n#1 /usr/share/wallacepos-master/library/wpos/models/DbUpdater.php(28): DbConfig->__construct()\n#2 /usr/share/wallacepos-master/library/installer/index.php(33): DbUpdater->DbUpdater()\n#3 {main}\n\nNext exception 'PDOException' with message 'Failed to connect to database.' in /usr/share/wallacepos-master/library/wpos/models/db/DbConfig.php:89\nStack trace:\n#0 /usr/share/wallacepos-master/library/wpos/models/DbUpdater.php(28): DbConfig->__construct()\n#1 /usr/share/wallacepos-master/library/installer/index.php(33): DbUpdater->DbUpdater()\n#2 {main}\n thrown in /usr/share/wallacepos-master/library/wpos/models/db/DbConfig.php on line 89
Staff logins is not working because of app cache manifest errors.
I've updated the .htaccess file with the appropriate rules.
AddType application/x-httpd-php .appcache
<Files *.appcache>
ExpiresActive On
ExpiresDefault "access plus 0 seconds"
This is the link to my appcache https://pos.westcoast-india.co.in/wpos.appcache
Below is the screenshot of the errors in web console.
Reinstalled mysql, reinitialized.
Try to login as admin/admin and it gives a message box saying it "couldn't connect to host"
no weirdness in the console or network tools. If I try logging in with the wrong password it fails properly, so it is actually getting past the login before failing. :(
hi, the API calling for offline mode is given errors on demo site, is this project still maintained as we are trying to support you by merging it with a known ERP System for both benefits...
if the project is not maintained is it ok to take over ?!
The feed server goes offline automatically and if switched on manually it turns off automatically.
The server config:(Removed SSL didn't want it)
<VirtualHost 10.20.0.2:80>
DocumentRoot /var/www/html/
ServerName 10.20.0.2
ErrorLog ${APACHE_LOG_DIR}/error.log
CustomLog ${APACHE_LOG_DIR}/access.log combined
<Directory /var/www/html>
AllowOverride all
</Directory>
# WSPROXY CONF
ProxyRequests Off
ProxyPreserveHost On
<Proxy 10.20.0.2>
Order deny,allow
Allow from all
</Proxy>
ProxyPass /socket.io/1/websocket/ ws://localhost:8080/socket.io/1/websocket/
ProxyPassReverse /socket.io/1/websocket/ ws://localhost:8080/socket.io/1/websocket
ProxyPass /socket.io/ http://localhost:8080/socket.io/
ProxyPassReverse /socket.io/ http://localhost:8080/socket.io/
<Location /socket.io>
Order allow,deny
Allow from all
</Location>
</VirtualHost>
I continue to have printing issues, I have tried changing all sorts of printer settings on the UI but nothing helps.
Printer: Epson TM-T20II
PC: Windows 7 Professional
Server: Ubuntu Server 14.04 LTS
Google Chrome:
It prints fine if after I select to cancel the print after selecting to print, it leaves a small window with the receipt image & details. If I do a print from that window The receipt prints fine like shown in picture. If I print directly from the print request I get a small cutout as shown in the picture (the last picture at the bottom of the post...), almost as if receipt info is not in place before the actual print job is requested.
** Update ** I was able to take screenshots, and it looks like my suspicion is true, it looks like for chrome the print job is created before any actually data is set to be printed, you can also see that one is printing 1 sheet and the second is printing 2. Check out the images below...
IE:
I get that long ugly receipt on the picture with no logos
Firefox:
Same Ugly receipt with no logos.
When I changed the staff privilege, changes are not reflected on the UI. User still can access reports and settings
Would like to make a minor change to assets/js/print.js
So that receipt can also an option to print customer name (which is the table/buzzer number). Will send in a PR for review.
As the customer search on POS is via email, we will also type table number in the email...
From:
if (invoice){
// business
temp_data.payment_instructions = config.invoice.payinst;
temp_data.logo_url = document.location.protocol+"//"+document.location.host+config.pos.recemaillogo;
temp_data.business_name = config.general.bizname;
temp_data.business_address = config.general.bizaddress;
temp_data.business_suburb = config.general.bizsuburb;
temp_data.business_state = config.general.bizstate;
temp_data.business_postcode = config.general.bizpostcode;
temp_data.business_country = config.general.bizcountry;
temp_data.business_number = config.general.biznumber;
// customer
if (record.custid>0) {
var customer = WPOS.getCustTable()[record.custid];
if (customer) {
temp_data.customer_name = customer.name;
temp_data.customer_address = customer.address;
temp_data.customer_suburb = customer.suburb;
temp_data.customer_state = customer.state;
temp_data.customer_postcode = customer.postcode;
temp_data.customer_country = customer.country;
}
}
....
To:
// customer
if (record.custid>0) {
var customer = WPOS.getCustTable()[record.custid];
if (customer) {
temp_data.customer_name = customer.name;
temp_data.customer_address = customer.address;
temp_data.customer_suburb = customer.suburb;
temp_data.customer_state = customer.state;
temp_data.customer_postcode = customer.postcode;
temp_data.customer_country = customer.country;
}
}
if (invoice){
// business
temp_data.payment_instructions = config.invoice.payinst;
temp_data.logo_url = document.location.protocol+"//"+document.location.host+config.pos.recemaillogo;
temp_data.business_name = config.general.bizname;
temp_data.business_address = config.general.bizaddress;
temp_data.business_suburb = config.general.bizsuburb;
temp_data.business_state = config.general.bizstate;
temp_data.business_postcode = config.general.bizpostcode;
temp_data.business_country = config.general.bizcountry;
temp_data.business_number = config.general.biznumber;
....
[Wed Apr 29 21:27:12 2015] [error] [client 192.168.2.238] PHP Parse error: syntax error, unexpected '[' in /usr/share/wallacepos-master/library/wpos/models/DbUpdater.php on line 105
Running ubuntu 12.04 in a VM (but I can run whatever you recommend)
Also, how do I install mod_wstunnel. I installed mod_proxy and that let apache start after adding the lines to /etc/apache2/apache.conf
Thanks!
Line 1 is
<?
Line 1 should be:
<?php
if the number of items is a lot and causes data field to exceed 4096 bytes, there will be a problem when accessing transactions, javascript will crash.
We need to:
increase the size of the sales.data field
do an error when there is too many items
Will help look into this
Thanks.
root@kss:/var/www/api# nodejs server.js
info - socket.io started
warn - error raised: Error: listen EADDRINUSE
root@kss:/var/www/api#
what hppen ? im unable to see other device conected in realtime menu (admin panel). can u give me a hints ?
thanks for your time
Got everything up and running.
Noticed the following warning in the apache error.log:
[Sat May 02 14:28:52.946893 2015] [proxy:warn] [pid 15457] [client 192.168.2.145:49641] AH01144: No protocol handler was valid for the URL /socket.io/1/. If you are using a DSO version of mod_proxy, make sure the proxy submodules are included in the configuration using LoadModule., referer: https://pos/
I've tried altering or creating a new tax rule of 8% and it doesn't apply it to items. If i enter an item for $1.25 it calculates the tax but instead of incrementing to the total it subtracts from the item price so it equals the item price of $1.25
Fatal error: Call to undefined function apache_get_modules() in /home/c6mucr2h/public_html/wallace/installer/index.php on line 74 and apache version error too please help me I can't install wallace
This may be an improvement in future to handle large datasets (.e.g > 50000 items in a select).
Instead of select2(...), the library below can be used, each time a key is typed, a list will be fetched, limited to X rows (X can be configurable).
im interested with this POS system but i have situation :
pt 1 :
i follow your installation and no error issue , after login as admin and run the feed server the status became online but after i change the setting to my situation and i double check the status feed server became offline what is hppen? i logout admin dashboard and login again it happen again the feed server status became offline. do i have to click start manually over and over ?
pt 2:
when succesfully registered device via admin ( eg : https://ksslite.co.id) and login it says : your device has removed from the server contact your administrator. so i login in the admin dashbord to make sure that i was registered at the unique UUID (see attch) . but i cant see the pos terminal . did i missing something ?
Sorry my english is not verywell
thanks
So I have another error that continues to happen randomly, I get the "please balance the sale before continuing" prompt after trying to process a transactions that is balanced out.
Process > Cash > Complete and the error comes out, any ideas on how to fix this as it becomes a pain when we have clients in line.
Hi micwallace,
Installation went fine. Read through all issues and was able to get it working. All good, thanks...
However, when I login on POS or admin/#!realtime, the browser throws an error "Could not connect to update feed"
IN the logs, I see this request being sent
https:// www.domainname.com /socket.io/1/?t=1452453610089
Browser Console Log: Shows a status of "400: Bad Request" as response. I think its a JSON parse error( as shown in firefox browser console.
If I open the link directly in browser, in return I get "{"code":0,"message":"Transport unknown"}"
Any help appreciated ..
Regards,
Akhil
Installed Wallacepos in Debian 8.5
Unfortunately not install all SQL tables.
Tax data could not be retrieved: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wallacepos.tax_items' doesn't exist
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wallacepos.sale_items' doesn't exist
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wallacepos.devices' doesn't exist
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wallacepos.stored_categories' doesn't exist
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wallacepos.stock_levels' doesn't exist
Another way to install db sql???
Thanks.
I got an error on console: VM26939:2 GET https://localhost/socket.io/1/?t=1472386247234 503 (Service Unavailable)
on /admin/#!realtime when start socket.io.
Notes:
I use Apache server listens to port 80 AND Nodejs listens to port 8085.
Sincerely
Hi Michael,
First of all, thanks a lot for your effort for WallacePos. I'm currently evaluating this.
I'm currently evaluating wallacepos and I have been stuck for a day trying to figure out what is missing. I already follow the guide that you provided for installation but for the first time login at admin page, there is nothing came out. I'm attaching a screenshot of firefox console so that you can take a look at it.
Thanks again
Ive been trying to install but keep getting this error on admin login
There was an error connection to the server: OK
The customer data is not loaded when invoice is clicked.
Need to click on customer first then click on invoice, this should not be the case.
I will try and add the code to load customer data when invoice is selected.
working on the issue, on very first load, confirm customer data although loaded when invoices in clicked, but customer dropdown in add invoice, does not populate
[FIXED]
Missing...
/assets/libs/datatables/datatables.min.js
/assets/js/wpos/eftpos.js
/assets/libs/datatables/datatables.min.css
After putting them in, can proceed, but then log in correctly (if wrong password get access denied)...
now checking on this...
Hi friends,
I got "insertion of new location failed" when i tried to register new device at the first setup.
Can you help me to solve this?
apt-get install php5-curl
service apache2 restart
I've checked my mysql settings over and over and am not sure what would cause this issue. I see the login screen for admin and am able to type in credentials, but during "initializing" I get this pop up error.
I do not get access wallacepos new version Pos Terminal from Android devices. It freezes in initializing, Updating application... I tried with multiple devices and multiple browsers and same result.
From pc localhost access without problems to Pos Terminal and Admin Dashboard.
It is related to permissions???
Thanks.
Already run node server.js
on the api
directory, but it keeps failing to authenticate.
How do I fix this?
These are the logs:
info - socket.io started
debug - client authorized
info - handshake authorized P0O4a4j4WCclmfYUl7h8
debug - setting request GET /socket.io/1/websocket/P0O4a4j4WCclmfYUl7h8
debug - set heartbeat interval for client P0O4a4j4WCclmfYUl7h8
debug - client authorized for
debug - websocket writing 1::
debug - websocket writing 5:::{"name":"updates","args":[{"a":"error","data":"Socket authentication failed!"}]}
info - booting client
info - transport end by forced client disconnection
debug - websocket writing 0::
info - transport end (booted)
debug - set close timeout for client P0O4a4j4WCclmfYUl7h8
debug - cleared close timeout for client P0O4a4j4WCclmfYUl7h8
debug - cleared heartbeat interval for client P0O4a4j4WCclmfYUl7h8
debug - discarding transport
Ok, not sure what we will actually need, but I think I'll need support for multiple taxing authorities. I.e. state sales tax and municipal sales tax. IMO, there may be places that have federal, state, county, and municipality sales taxes.
The Sale Graph on the dashboard and Graph page aren't showing any results. Dug deeper and noticed the date ranges for the Graph page are going from Thu, 01 Sep 2016 04:00:00 GMT (1472702400000) to Sun, 20 Oct 1957 04:24:32 GMT('-384982528) when I was expecting ranges between Sept 13 to Sept 20 2016. The Sale Stats on the Dashboard are updating properly though.
DB query log. Note the processdt ranges
551 Connect systempos@localhost on posdb
551 Query SET time_zone = '+00:00'
550 Query SELECT *, d.id as groupid, d.name as name, SUM(s.total) as stotal, COUNT(s.id) as snum, COALESCE(GROUP_CONCAT(s.ref SEPARATOR ','),'') as refs FROM sales as s LEFT JOIN locations as d ON s.locationid=d.id WHERE (s.processdt>= '1472702400000' AND s.processdt<= '-384982528') AND status!= '3' GROUP BY s.locationid
550 Query SELECT *, d.id as groupid, d.name as name, SUM(s.total) as stotal, COUNT(s.id) as snum, COALESCE(GROUP_CONCAT(s.ref SEPARATOR ','),'') as refs FROM sales as s LEFT JOIN locations as d ON s.locationid=d.id WHERE (s.processdt>= '1472702400000' AND s.processdt<= '-384982528') AND status= '3' GROUP BY s.locationid
551 Query SELECT *, d.id as groupid, d.name as name, SUM(v.amount) as stotal, COUNT(v.id) as snum, GROUP_CONCAT(s.ref SEPARATOR ',') as refs FROM sale_voids as v LEFT JOIN sales as s ON v.saleid=s.id LEFT JOIN locations as d ON v.locationid=d.id WHERE (v.processdt>= '1472702400000' AND v.processdt<= '-384982528') AND v.void= '0' GROUP BY v.locationid
550 Quit
Expected Sale Graph on the dashboard and Graph page to update with data.
Sale Graph on the dashboard and Graph page don't update with data.
Not sure yet still looking into it.
n/a
So after spending a few hours going over your software I was able to get it installed, once installed It can't connect to site?
Then the page gets stuck initializing...
all packages, file permissions are correctly installed and configured, I have checked it over 10 times. I get to the admin login page but this prevents it from even working or accepting posts.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.