Accepted
Director of Medipresa Gedeminas Vildauskas 
The Technical task for making a Program for labeling books
The Technical task for making the Program for labeling books (Program) made UŽDAROJI AKCINĖ BENDROVĖ „MEDIPRESA“ (MediPresa) for A.V.S. SIA (AVS). The Program must include:
Introduction
The Mediapresa  is a company which sale a lot of goods (mainly books) throughout Lithuanian sales networks (nets). It is big problem to put on books price label manually because on slow manual process and big chance to make mistakes. Therefore the MediPresa buy Avery-Dennison Pathfinder 6057 Portable Printers (Printer) which allows the Program operator to automate the price labels printout. The AVS it is asked to develop The Program that prompts the Printer to print the price label after a bar code of the book is scanned. The AVS must  make file  exchanging system with the WEB server. The second and next price labels for same examples of book is printed by pressing a special button on the Printer screen. 
1. The technical scheme:
Pic.1 




The technical scheme above show that all Printers  are equipped with a WiFi (wireless) connection to the WEB server. Its gives possibilities to take files from the MediPresa WEB server when the operator of Printer is in the Medipresa office room with Internet Wifi coverage. It gives possibilities to receive needed information if WiFi connection to Internet in other book sales outlets (net) is possible.
The Program must have the possibilities to input in set file and automated use follow communication information:
address of WEM server = http://www.medipresa.lt/Prices
User:
Password
MediPresa Upload new price lists (see next point of the task) and file with the list of the nets (see bellow point 3) and download to the Printer this information using special PHP scripts what is installed on  MediPresa WEB server.
A workstations prepare price lists and upload it in internet address shown bellow 
2. The price lists
The MediPresa prepare following price lists what is text, coma delimited files. Maxima.csv, Rimi.csv, IKI.csv, Norfa.csv
In first step this texts have only 2 colons:
The structure of price lists
[Name].csv
Barcode, N (13)
Price N(7.2)
Example [Name].csv (unreal bar codes and prices)
9786094750489, 9.12
9786094198571, 5.12
9786094662584, 4.56
9786098214000, 3.67
9786094401275, 12.56
9786094662614, 16.56
The decimal point divisor is a point.
A new files what Printer receive from the Medipresa WB server replace (delete) the previous version of files.
3. The price lists selection. 
This files describes different text files for choosing for special net (Maxima.csv, Rimi.csv, IKI.csv, Norfa.csv) prices  
The structure 
PriceLists.csv
NetName, Char(20)
FileName, Ckar(20)
BarCode, N(13)

The contents of fileRimi”, “Rimi.csv”, 1000000000016Maxima”, “Maxima.csv”, 1000000000023IKI”,”IKI.csv”, 1000000000030Norfa”, “Norfa.csv”, 1000000000047

The PriceLists Coded for printing out using Code EAN13 fonts in Microsoft Word -  Pricelists.doc
Table 1

Nets

Bar code

Rimi

1AAKAKK*aaaabg+

Maxima

1AAKAKK*aaaacd+

IKI

1AAKAKK*aaaada+

Norfa

1AAKAKK*aaaaeh+
For prining out out with CodeEAN13 
Table 2

Nets

Bar code

Rimi

1AAKAKK*aaaabg+

Maxima

1AAKAKK*aaaacd+

IKI

1AAKAKK*aaaada+

Norfa

1AAKAKK*aaaaeh+
    
If the MediPresa have no EAN13 fonts in the first time Program operator can use Pricelists.pdf what can be called form http://www.avs.lv/mp/pricelists.pdf  
When the Program run Operator see on the desktop of Printer the name of the net. If operator wants to print prices from another net he must scan needed bar code shown in table 2. This bar code started with “1”. No any MediPresa goods with such bar code. After this scanning Program “knows” that the operator wanted to change work to hew price list. The Printer will open another price list ad print label according it.  The Pricelist is active till the next Pricelist barcode is scanned.  
If the MediPresa will want to add new net price list operator of Program must prepare file file with unique file name, put this information in the PriceLists.csv. Than operator must prepare a [NewName].csv according the regulations shown in p.2.    
The technical task is for the printing  1 size and same contents price label. Other size and content price labels are ordered in addition.
3. Programming  terms and prices
The Avs makes Program within 2 weeks of signing the contract with MediPresa. Program price is 2 300 EUR what MediPresa pay AVS according conditions of contract. 
Prepared Procurist of AVS  Andis Belavskis
Riga, 11.11.2018
 

SIA A.V.S., reģ.Nr LV40002023879,   Dārzauagļu ielā 1-212, Rīga, LV-1012, .  +37167842222, +37167292037, +37129557989,   citi – kontakti

 WhatsApp +37129557989,   alfreds@avs.lvavs@avs.lv  alfreds_avs  LV44UNLA0002050469627, UNLALV2X