From 7230aede1ff4b70a9db49f0fe2ad6e5469793c24 Mon Sep 17 00:00:00 2001
From: jack <jack.su@pollex.com.tw>
Date: 星期五, 28 七月 2023 13:57:52 +0800
Subject: [PATCH] [ADD] appointment_customer_consultant_view新增預約單諮詢方式欄位
---
pamapi/src/doc/sql/20230727_j.sql | 38 +++++++++++++++++++++++++++++++++++++-
1 files changed, 37 insertions(+), 1 deletions(-)
diff --git a/pamapi/src/doc/sql/20230727_j.sql b/pamapi/src/doc/sql/20230727_j.sql
index 1f842ad..014c1b6 100644
--- a/pamapi/src/doc/sql/20230727_j.sql
+++ b/pamapi/src/doc/sql/20230727_j.sql
@@ -23,4 +23,40 @@
c.name,
a.consultation_method
FROM appointment a
- LEFT JOIN customer c ON a.customer_id = c.id;
\ No newline at end of file
+ LEFT JOIN customer c ON a.customer_id = c.id;
+
+
+
+
+-- public.appointment_customer_consultant_view source
+
+-- public.appointment_customer_consultant_view source
+
+CREATE OR REPLACE VIEW omo.appointment_customer_consultant_view
+AS SELECT appointment.id AS appointment_id,
+ appointment.phone,
+ appointment.email,
+ appointment.contact_type,
+ appointment.gender,
+ appointment.age,
+ appointment.job,
+ appointment.requirement,
+ appointment.communicate_status,
+ appointment.hope_contact_time,
+ appointment.other_requirement,
+ appointment.appointment_date,
+ appointment.last_modified_date,
+ appointment.agent_no,
+ appointment.consultant_view_time,
+ appointment.consultant_read_time,
+ appointment.contact_time,
+ appointment.status,
+ consultant.name AS consultant_name,
+ consultant.phone_number AS consultant_phone_number,
+ consultant.email AS consultant_email,
+ consultant.role AS consultant_role,
+ customer.name AS customer_name,
+ appointment.consultation_method as consultation_method
+ FROM appointment
+ LEFT JOIN consultant ON appointment.agent_no::text = consultant.agent_no::text
+ LEFT JOIN customer ON appointment.customer_id = customer.id;
\ No newline at end of file
--
Gitblit v1.8.0