Windev21 Aulas,Estudos e Desenvolvimento: 08/07/20

https://youtu.be/Y_boh8KJqy0

Bom Dia/Boa Tarde/Boa Noite

Esse Ao Vivo vai estrear as 09:00 do dia 20/08/2020
DICAS 3002 - WINDEV TUTORIAL 25 - PROJETO E ANALISE - LINK - PARTE 6
tutoriel WINDEV : Leçon 3.3.f. Projet et analyse - Liaisons et génération
https://windevdesenvolvimento.blogspot.com/2020/08/dicas-3002-windev-tutorial-25-projeto-e.html
https://youtu.be/Y_boh8KJqy0

ASSUNTOS

1. fazendo o link do cliente com pedido
2. fazendo o link tipo de pagamento pedido
3. fazendo o link produto com pedido
4. criando arquivo intermediario por causa link
5. criado Linha_pedido
6. mostrando como gera os arquivos

https://doc.pcsoft.fr/fr-FR/?1410087521&name=lecon_33_projet_analyse

Video original da Franca

https://youtu.be/M7F_DGIGbdM

Playlist Windev TUTORIAL
https://www.youtube.com/playlist?list=PLwJwZaqiZW-lxU1XF0M0htb5S5f8pavuE

Creating links

All data file descriptions required by the account management application have been created.

We are now going to create the links between data files. A link is used to define the integrity constraints (cardinalities) between two data files.

First, let's create the link between the "Customer" and "Orders" data files: a customer can have one or more orders and each order is linked to a customer.
1. On the "Analysis" pane (in the ribbon), in the "Creation" group, click "New link". The mouse cursor turns into a pen.
2. Click the "Customer" data file, then the "Orders" data file.
3. The link creation wizard starts.
4. Answer the questions asked by the wizard:
  - Each Customer has at least one Order: No
  - Each Customer can have several Orders: Yes
  - Each Order has at least one Customer: Yes
  - Each Order can have several Customers: No
    
    Remark
    You can also specify the link cardinalities directly in the wizard.
5. Go to the next step. The wizard automatically proposes the key used by the link (CustomerID).
6. Go to the next step of the wizard. The wizard offers to create the "CustomerID" key in the Orders data file to store the customer corresponding to the order.
7. Accept this option by going to the next step.
8. This step defines the integrity rules that will be automatically applied. In our case, you can set the behavior when deleting a customer and when modifying the customer identifier.
9. Validate the integrity rules by going to the next step of the wizard.
10. Click "Finish". The link is automatically created in the data model editor.

Likewise, create a link between the PaymentMode and Orders data files. These two data files are linked as follows:
- An order must have a payment mode.
- A payment mode can be used in several orders.
In the wizard:
- The cardinalities are as follows: PaymentMode (0,n), Orders (1,1)
- The link key corresponds to the "Code" item.

We are now going to create a link between the "Product" and "Orders" data files. This link will be used to create a link file, the file of order lines.
1. Likewise, create the link between the data files.
2. Answer the questions asked by the wizard:
  - Each Product has at least one Order: No
  - Each Product can have several Orders: Yes
  - Each Order has at least one Product: No
  - Each Order can have several Products: Yes
3. Go to the next step. The wizard proposes to create a relation file. Keep "Create the relation file automatically" and go to the next step.
4. The wizard proposes the unique key of the Product data file. Select "Reference". Go to the next step.
5. Validate the key creation by going to the next step.
6. Keep the default options regarding the integrity rules and go to the next step.
7. The wizard proposes the unique key of the Orders data file to use: "OrdersID". Go to the next step.
8. Validate the key creation by going to the next step.
9. Keep the default options regarding the integrity rules and go to the next step.
10. Click "Finish". The relation file is automatically created in the data model editor.

We are now going to modify the relation file that was created by WINDEV. Indeed, this relation file will contain the order lines. We are going to:

Modify the name of the data file.
Modify the name of its items.
Add items to find out the quantity of products ordered and the total of order line.

First, we are going to rename the data file. We already did something similar when we changed the caption of the imported data file. However, in this case, not only the caption will be modified: we will also rename the physical file linked to the data file description.
1. Select the "Product_Orders" data file.
2. In the popup menu (right mouse click), select "Description of data file".
3. In the window that is displayed, modify:
  - the name of data file: "OrderLine".
  - the name on disk: "OrderLine".

We are now going to modify the items of this relation file.

Click to display the description of data file items.

This relation file has 3 items. Position the selection bar on the item "Reference_OrdersID". This item is a composite key.


	Remark	A composite key is a set of items that constitute an index. This type of key is used to browse the data file according to complex criteria or to perform specific searches on several items at the same time.

To rename this item:
- Click the "Name" column.
- Replace "Reference_OrdersID" by "OrderLineID".
- Click the "Caption" column.
- Replace the current caption by "Identifier of OrderLine".

We are now going to add 3 new items into this relation file: Quantity, TotalIOT and TotalBT.
1. Position the cursor on a new row and create the item "Quantity". This item is a "Numeric" item.
2. Position the cursor on a new row and create the item "Total IOT". This item is a "Currency" item.
3. A window is displayed, indicating that the item already exists in the analysis and proposing to re-use its characteristics:
  
  Keep the selected options and validate ("OK").
4. Position the cursor on a new row and create the item "Total BT". This item is a "Currency" item. Once again, use the existing description.
5. The description of the "OrderLine" data file items is as follows.
6. Validate the description of the items ("OK") as well as the data file description.

The analysis is as follows:

Generating the analysis

Generating the analysis consists in validating the modifications performed in the analysis (create data files, add or delete items, etc.) and in applying them to the entire project (pages, linked controls, reports, etc.). The project will thus "know" all the data files, items and links defined in the analysis. It will be very easy to handle these elements in the different editors of WINDEV.

The generation is automatically proposed when closing the data model editor while modifications have been performed.

You also have the ability to generate the analysis manually. That's what we are going to do.

To generate the analysis:
1. In the ribbon of the analysis editor, on the "Analysis" pane, in the "Analysis" group, click "Generation".
2. The analysis generation is automatically started.

The descriptions of data files found in the analysis have been modified.

To update the data files of the application, WINDEV automatically starts the procedure for modifying the data files. This operation is used to update the data files (".fic" files) according to their description in the analysis.

The automatic modification wizard starts. Validate the different steps until you reach the screen that lists the data files to take into account.
- WINDEV detects that the PaymentMode data file must be updated. Keep this data file selected.
- WINDEV detects that the Product data file is out of sync. Select this data file.
- Go to the next step.
- The wizard proposes to make a back up copy of the existing data files, don't change anything and go to the next step.
- The wizard proposes to type the passwords for protecting the data files modified by the automatic modification. Keep the default options and go to the next step.
- The list of data files to modify is displayed. Validate the wizard.
- The data files are updated.