Changes between Version 2 and Version 3 of UseCaseModel/sale

Timestamp:

02/13/25 13:42:33 (9 months ago)

Author:

175012

Comment:

--

UseCaseModel/sale

@@ -12 +12 @@
 
 [[Image(index.png)]]
+
+{{{SELECT p.p_id, 
+       CASE 
+           WHEN v.pol_id IS NOT NULL THEN 'Auto Policy'
+           WHEN t.pol_id IS NOT NULL THEN 'Travel Health'
+           ELSE 'Property Policy'
+       END AS PolicyType,
+       c.name AS CustomerName,
+       p.sdate AS StartDate,
+       p.edate AS EndDate,
+       p.package AS PackageCode,
+       pkg.title AS PackageTitle,
+       pkg.total AS PackageTotal
+FROM project.policy p
+LEFT JOIN project.Auto_pol v ON p.p_id = v.pol_id
+LEFT JOIN project.Travel_pol t ON p.p_id = t.pol_id
+LEFT JOIN project.property_pol pp ON p.p_id = pp.pr_id 
+LEFT JOIN project.pol_dog pd ON p.p_id = pd.policy
+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}}}
 
      ==== Чекор 2.