
1
Алексей
no recommendations
no complaints
Project title: Creating a desktop application
Type of cooperation: One-time project
Section: Software development
Prepayment: without prepayment
Payment methods: Electronic money
Acceptance of requests: from 2020-06-08 until 2020-06-18
Type of cooperation: One-time project
Section: Software development
Prepayment: without prepayment
Payment methods: Electronic money
Acceptance of requests: from 2020-06-08 until 2020-06-18
Project description:
Remote work to create a desktop application. You need a desktop application + database on MySql (MS SQL I don't want to use)
There's partial TK
Payment in fact - I do not consider other options
There should be about 20 basic tables.
The application must receive orders from 3 sites and synchronize the balances of goods, order status and prices on these sites, with the database in our database.
I mean. From the sites we get:
- orders and all information contained in the order,
- initial status order
We're sending it to the sites.
- new order status,
- balance of goods
And you can also synchronize the prices of goods from the internal product directory.
You need to receive orders and transfer information with 3 sites:
1. Site on CMS Opencart 1.5.1.3 - the method of linking with the base directly from the mySql site
2. Site on the Prom.ua platform - the method of conecting with the base through the IPA PROM
3. Site on the Zakupka platform - the method of conect or the protocol of conect as with 1C or parsing admin with the necessary data.
Here is a list of the main tables:
Orders
Subordinate table: Goods (order composition: goods from the order)
Product directory (product catalogue, price sheets from the excel are imported here)
Warehouse
Arrivals of goods
Clients.
Expenses
Profits
Marriage.
Order statuses
Write-off
Settlements with partners
Settings
Statistics, reports:
Reports on sales, purchase, marriage, turnover, profit, expenses, etc. And so on, that is. All possible reporting and analytical information for all activities, everything that can be counted, should be displayed in an understandable and accessible form, with the possibility of selecting the display period (quick selection of the period:
Tonight.
Last week.
Last month.
Quarter
6 months
Year
1.5 Years
2 years
3 years
All the time.
And the ability to set any period indicating the beginning and the end.
Accounting (statistics):
profit
- turnover
- expenditure
sales statistics for each product, separately by its article and by the name of the product
- statistics on the marriage of goods separately by article and by name of the goods and by reason of marriage,
- for what amount at the purchase or selling price of the goods in stock in stock.
- selection of the best-selling product for the selected period
- sample of the most unselling goods 1-500 for the selected period
Profit and turnover through sales channels
Profits and turnover by partner
Statistics of unconfiscated parcels (refusals): by the name of the goods, by article, by city, by region.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Login to the application by login and password, there should be a delineation of access rights to tables and columns in tables based on the user group, work both on the local network and through the Internet
What else should the application be able to do:
- the ability to filter any displayed data according to any set of criteria with convenient implementation,
- availability of convenient search on any fields,
- edit any data received from the site (data in the order: goods, quantity, price, data on the method of payment and delivery and the customer, etc.)
- create an order in the application itself
- Sending SMS
And e-mail notifications on predefined templates, with the substitution of the necessary data from the database both manually and automatically when changing the status of the order, as well as sending a separate SMS on the template or arbitrary content.
Automatic change of order status after a specified period of time with sending SMS and e-mail notifications if it is set.
- pre-installed filters for orders on individual program tabs, with the ability to create new and customize existing ones.
- printing with the substitution of data from the database according to the document template (warranty card, commodity check, invoice and any other according to the created template), i.e. With the ability to create any template, specify what data should be inserted there.
Control who and when made changes to the database.
Control and fixing the time of entry and exit to / from the user application.
- manual and automatic creation of backup as a database as a whole, and individual tables, with the ability to perform both the creation of a backup and the deployment of a database or separate tables from a backup.
- interaction on the IPA of New Mail, where you need to realize the maximum, which allows their api,
- visual design (filling and font color) for cells and lines based on data in the cell (such as logical formatting in the pixel)
Remote work to create a desktop application. You need a desktop application + database on MySql (MS SQL I don't want to use)
There's partial TK
Payment in fact - I do not consider other options
There should be about 20 basic tables.
The application must receive orders from 3 sites and synchronize the balances of goods, order status and prices on these sites, with the database in our database.
I mean. From the sites we get:
- orders and all information contained in the order,
- initial status order
We're sending it to the sites.
- new order status,
- balance of goods
And you can also synchronize the prices of goods from the internal product directory.
You need to receive orders and transfer information with 3 sites:
1. Site on CMS Opencart 1.5.1.3 - the method of linking with the base directly from the mySql site
2. Site on the Prom.ua platform - the method of conecting with the base through the IPA PROM
3. Site on the Zakupka platform - the method of conect or the protocol of conect as with 1C or parsing admin with the necessary data.
Here is a list of the main tables:
Orders
Subordinate table: Goods (order composition: goods from the order)
Product directory (product catalogue, price sheets from the excel are imported here)
Warehouse
Arrivals of goods
Clients.
Expenses
Profits
Marriage.
Order statuses
Write-off
Settlements with partners
Settings
Statistics, reports:
Reports on sales, purchase, marriage, turnover, profit, expenses, etc. And so on, that is. All possible reporting and analytical information for all activities, everything that can be counted, should be displayed in an understandable and accessible form, with the possibility of selecting the display period (quick selection of the period:
Tonight.
Last week.
Last month.
Quarter
6 months
Year
1.5 Years
2 years
3 years
All the time.
And the ability to set any period indicating the beginning and the end.
Accounting (statistics):
profit
- turnover
- expenditure
sales statistics for each product, separately by its article and by the name of the product
- statistics on the marriage of goods separately by article and by name of the goods and by reason of marriage,
- for what amount at the purchase or selling price of the goods in stock in stock.
- selection of the best-selling product for the selected period
- sample of the most unselling goods 1-500 for the selected period
Profit and turnover through sales channels
Profits and turnover by partner
Statistics of unconfiscated parcels (refusals): by the name of the goods, by article, by city, by region.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Login to the application by login and password, there should be a delineation of access rights to tables and columns in tables based on the user group, work both on the local network and through the Internet
What else should the application be able to do:
- the ability to filter any displayed data according to any set of criteria with convenient implementation,
- availability of convenient search on any fields,
- edit any data received from the site (data in the order: goods, quantity, price, data on the method of payment and delivery and the customer, etc.)
- create an order in the application itself
- Sending SMS
And e-mail notifications on predefined templates, with the substitution of the necessary data from the database both manually and automatically when changing the status of the order, as well as sending a separate SMS on the template or arbitrary content.
Automatic change of order status after a specified period of time with sending SMS and e-mail notifications if it is set.
- pre-installed filters for orders on individual program tabs, with the ability to create new and customize existing ones.
- printing with the substitution of data from the database according to the document template (warranty card, commodity check, invoice and any other according to the created template), i.e. With the ability to create any template, specify what data should be inserted there.
Control who and when made changes to the database.
Control and fixing the time of entry and exit to / from the user application.
- manual and automatic creation of backup as a database as a whole, and individual tables, with the ability to perform both the creation of a backup and the deployment of a database or separate tables from a backup.
- interaction on the IPA of New Mail, where you need to realize the maximum, which allows their api,
- visual design (filling and font color) for cells and lines based on data in the cell (such as logical formatting in the pixel)