To start I must point out my programming skills are virtually zero.
I started playing with OSR backoffice yesterday, it has a lot of potential it looks pretty good.
The first and most important problem I find is that anyone on the network can access it without a username and pass, which is extremely bad.
with regards to usage I found my first problem (not in a bad way), I figured out a solution and want to share it.
when adding a new item, after it saves the initial page it goes to edit.php page where one can update the QTY and pricing. I found that the first time a new item is displayed in the edit page, the only field which is posted on submit is the QTY, to edit/update the pricing fields you need to visit the item in the edit page again, to me it looks like the mysql function in edit.php can do with some tweakings to make this work properly, I wouldn't know how to do that.
However what I did was: in pserv/invqty/ dir in add.php I added in the top section "$supprice=$_POST['supprice'];" then in the mysql_query in the line under '$name' I replaced the '0' with "$supprice", save the file, in search.php file roughly half way through the file (in ON THE FLY PRODUCT ENTRY section) I added the following between Name & Price rows http://pastebin.com/ZRADmHne.
The result is that you will have the Supplier Price field in the initial new item entry form before you reach the edit.php page.
I would also like to add some other fields to the form (such as "Receipt required for warranty)" but do not have a clue how to do that (to create either dropdown (yes/no) or checkbox where the php/mysql query will translate that into a 0/1 and post it to the correct field in the table.
Another important point, if you can add customer transaction (see customer purchases) and customer balances to it, it will be amazing
Best of luck
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
NICE JOB SIR!!!! I have already been working on basic security and actually if you look at the index files, you will see the login but I have to add my sessions and of course the varibles for admins only so that ANYONE simply cant login. Reason it's like that on the first pass is because there is technically no items in the stockcurrent so you have to make a second pass eithier way. (FOR NOW as I have been using different methods to solve that issue with the supplier cost and all to put under one pass). The "Employee Information" button actually overrides the passwords that unicenta uses with a simple sha1 for the time being allowing users to utilize the passwords for both back ffice and unicenta(until we get the rest of the securitys done to determine who is an admin and whos not)... STAY TUNED FOR THAT!!!
We have already updated with having the supplier cost under adding new items and even allowed to update code too as times change, the product code change too(Rare but does). We are already in the Process of that as is though but I can really really use the help on your customer transactions for warranty though.
Yes dont worry because that's one of the things we are trying to knock out is that as that inventory screen is all over the place lol. It's taking a bit longer than expected because whoever created the structure of this database has tables and relations spreaded out over the world like the stockcurrent... WHY DIDNT YOU SIMPLY ADD A QTY COLUMN IN THE PRODUCTS PAGE?????? LOL. and dont quite know what on earth the stock diary is for other than the ietms you sell for what I see
KEEP UP THE GOOD WORK AND THANKS FOR POSTING SIR!!! Are you enjoying the back office otherwise?
Last edit: Anthony Porter 2014-06-19
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am using Unicenta Opos since 1 year. I came across this app a while back and downloaded. Now i am confused how to run it. Should i upload all the files unzipped to my web space?
Please guide me how to go a head as i am running Unicenta in Client/Server mode using MySql.
Appreciable if a installation guide is available for this.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi all,
To start I must point out my programming skills are virtually zero.
I started playing with OSR backoffice yesterday, it has a lot of potential it looks pretty good.
The first and most important problem I find is that anyone on the network can access it without a username and pass, which is extremely bad.
with regards to usage I found my first problem (not in a bad way), I figured out a solution and want to share it.
when adding a new item, after it saves the initial page it goes to edit.php page where one can update the QTY and pricing. I found that the first time a new item is displayed in the edit page, the only field which is posted on submit is the QTY, to edit/update the pricing fields you need to visit the item in the edit page again, to me it looks like the mysql function in edit.php can do with some tweakings to make this work properly, I wouldn't know how to do that.
However what I did was: in pserv/invqty/ dir in add.php I added in the top section "$supprice=$_POST['supprice'];" then in the mysql_query in the line under '$name' I replaced the '0' with "$supprice", save the file, in search.php file roughly half way through the file (in ON THE FLY PRODUCT ENTRY section) I added the following between Name & Price rows http://pastebin.com/ZRADmHne.
The result is that you will have the Supplier Price field in the initial new item entry form before you reach the edit.php page.
I would also like to add some other fields to the form (such as "Receipt required for warranty)" but do not have a clue how to do that (to create either dropdown (yes/no) or checkbox where the php/mysql query will translate that into a 0/1 and post it to the correct field in the table.
Another important point, if you can add customer transaction (see customer purchases) and customer balances to it, it will be amazing
Best of luck
NICE JOB SIR!!!! I have already been working on basic security and actually if you look at the index files, you will see the login but I have to add my sessions and of course the varibles for admins only so that ANYONE simply cant login. Reason it's like that on the first pass is because there is technically no items in the stockcurrent so you have to make a second pass eithier way. (FOR NOW as I have been using different methods to solve that issue with the supplier cost and all to put under one pass). The "Employee Information" button actually overrides the passwords that unicenta uses with a simple sha1 for the time being allowing users to utilize the passwords for both back ffice and unicenta(until we get the rest of the securitys done to determine who is an admin and whos not)... STAY TUNED FOR THAT!!!
We have already updated with having the supplier cost under adding new items and even allowed to update code too as times change, the product code change too(Rare but does). We are already in the Process of that as is though but I can really really use the help on your customer transactions for warranty though.
Yes dont worry because that's one of the things we are trying to knock out is that as that inventory screen is all over the place lol. It's taking a bit longer than expected because whoever created the structure of this database has tables and relations spreaded out over the world like the stockcurrent... WHY DIDNT YOU SIMPLY ADD A QTY COLUMN IN THE PRODUCTS PAGE?????? LOL. and dont quite know what on earth the stock diary is for other than the ietms you sell for what I see
KEEP UP THE GOOD WORK AND THANKS FOR POSTING SIR!!! Are you enjoying the back office otherwise?
Last edit: Anthony Porter 2014-06-19
Hi,
I am using Unicenta Opos since 1 year. I came across this app a while back and downloaded. Now i am confused how to run it. Should i upload all the files unzipped to my web space?
Please guide me how to go a head as i am running Unicenta in Client/Server mode using MySql.
Appreciable if a installation guide is available for this.
Yes download the web app directly onto your xampp or wam server
...\htdocs\pserv
...\www\pserv
Open up the conn file and change the name to your database name. Refresh and its good. There will be a big update to be ready to re-download soon.