Changes between Version 3 and Version 4 of UseCaseModel/sale

Timestamp:

02/13/25 13:46:02 (8 days ago)

Author:

175012

Comment:

--

UseCaseModel/sale

@@ -13 +13 @@
 [[Image(index.png)]]
 
-{{{SELECT p.p_id, 
+{{{
+SELECT p.p_id, 
        CASE 
            WHEN v.pol_id IS NOT NULL THEN 'Auto Policy'
@@ -32 +33 @@
 LEFT JOIN project.customer c ON pd.c_id = c.c_id --OR t.o_embg = c.c_id
 LEFT JOIN project.package pkg ON p.package = pkg.code
-{0} ORDER BY p.p_id DESC}}}
+ ORDER BY p.p_id DESC
+}}}
 
      ==== Чекор 2.
@@ -48 +50 @@
 {{{INSERT INTO project.Pol_osi (o_embg, policy, name, surname, birthdate, kontakt) VALUES (@O_Embg, @Policy, @Name, @Surname, @Birthdate, @Kontakt)}}}
 
-{{{INSERT INTO project.pol_dog (d_embg, c_id, name, policy, birthdate)
-                                                SELECT @tr_id, c_id, name, @Policy, CURRENT_DATE 
-                                                FROM project.Customer 
-                                                WHERE email = @email}}}
+{{{INSERT INTO project.pol_dog (d_embg, c_id, name, policy, birthdate) SELECT @tr_id, c_id, name, @Policy, CURRENT_DATE FROM project.Customer WHERE email = @email}}}
 
      ==== Чекор 3.