[ADD] appointment_customer_consultant_view新增預約單諮詢方式欄位

jack

2023-07-28 7230aede1ff4b70a9db49f0fe2ad6e5469793c24

 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;
     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;