Closed

PHP Point of Sale modification (add multi store/locations)

Looking for someone to do modification of php point of sale ([url removed, login to view])

The modification needed is central management of multiple stores/locations in the same database. Will need one extra column in the tables to record the store/location id.

employees, customers, stock, orders to be assigned to store/location by adding additional column with the store/location id.

example:

CREATE TABLE IF NOT EXISTS `phppos_customers` (

`person_id` int(10) NOT NULL,

`account_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

`company_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,

`taxable` int(1) NOT NULL DEFAULT '1',

`deleted` int(1) NOT NULL DEFAULT '0',

UNIQUE KEY `account_number` (`account_number`),

KEY `person_id` (`person_id`),

KEY `deleted` (`deleted`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

This is the original customers table, we'll need new column 'location_id' (ABC01 for example)

employees table structure is similar, so it will be the same.

orders/sales table

CREATE TABLE IF NOT EXISTS `phppos_sales` (

`sale_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

`customer_id` int(10) DEFAULT NULL,

`employee_id` int(10) NOT NULL DEFAULT '0',

`comment` text COLLATE utf8_unicode_ci NOT NULL,

`show_comment_on_receipt` int(1) NOT NULL DEFAULT '0',

`sale_id` int(10) NOT NULL AUTO_INCREMENT,

`payment_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

`cc_ref_no` varchar(255) COLLATE utf8_unicode_ci NOT NULL,

`deleted` int(1) NOT NULL DEFAULT '0',

`suspended` int(1) NOT NULL DEFAULT '0',

PRIMARY KEY (`sale_id`),

KEY `customer_id` (`customer_id`),

KEY `employee_id` (`employee_id`),

KEY `deleted` (`deleted`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

Plus 'location_id' will assign the sale to the store/customer/employee where the sale was made.

The php part will need to be changed, to reflect the new store/location setting. When employee is logged in he/she should be restricted to items/customers/sales that are assigned to this location/store.

Skills: MySQL, PHP

See more: point sale, php point sale modification, structure stores, php create table, create table php, the sale, sale point, point of, phppointofsale, multi store, locations, mysql create database engine, multi part php, php multi part, mysql add record, add stock, employee mysql, point modification, add record, php mysql customer management, php point sales, mysql php demo, mysql php example, add key, employee management php mysql

About the Employer:
( 15 reviews ) WATFORD, United Kingdom

Project ID: #4304740

10 freelancers are bidding on average $191 for this job

toinnisfree

pls chk pmb

$220 USD in 3 days
(526 Reviews)
7.9
linuxfreak1985

Hi there, We are experts in PHP Open Source (any kind of PHP/MySQL work),wordpress and Ajax/Web 2.0 technology. Some of the projects we completed for php are mentioned below https://www.freelancer.com/projects/ More

$250 USD in 15 days
(67 Reviews)
5.8
csajit

LETS GET IT DONE!

$200 USD in 7 days
(119 Reviews)
5.5
sunlark

Hello, I'm ready to do such modifications to your php point of sale script.

$150 USD in 10 days
(6 Reviews)
5.1
muhammadghasan

hi, Please Check your PMb, Thanks

$230 USD in 4 days
(21 Reviews)
4.9
Butterfly718

Hello,sir. I have gone through your requirement. I can help you. Let's start.

$150 USD in 3 days
(35 Reviews)
4.6
kchg

Dear. I'm interested with your project. I'll do it. Regards.

$250 USD in 5 days
(9 Reviews)
4.3
codehard

We are PHP Experts and are in business since 2006 and have developed more then 300+ PHP Projects . Lets get this PHP project done and you will not be disappointed . Please check your PMB

$199 USD in 7 days
(3 Reviews)
2.7
iceman8080

3 years exp MySQL, PHP5. Can do this for you by the end of the week.

$140 USD in 4 days
(1 Review)
2.0
florinalex24

Hi there, i would like to help you with the project

$125 USD in 7 days
(0 Reviews)
0.0