Merge branch '2023_CR2' of https://dev.pollex.com.tw:8443/r/pcalife/PAM int...

Tomas

2023-08-01 07705371d024073fb4347ed1548d5554da7df8ac

Merge branch '2023_CR2' of https://dev.pollex.com.tw:8443/r/pcalife/PAM into 2023_CR2

 pamapi/src/doc/sql/20230727_j.sql

@@ -27,9 +27,6 @@
     
     
     
     
-- public.appointment_customer_consultant_view source

-- public.appointment_customer_consultant_view source

CREATE OR REPLACE VIEW omo.appointment_customer_consultant_view
@@ -59,4 +56,40 @@
    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;
     
     
     
     
-- public.appointment_customer_consultant_view source , 新增consultant_gender和consultant_entry_date欄位

CREATE OR REPLACE VIEW public.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,
    consultant.gender as consultant_gender,
    consultant.entry_date as consultant_entry_date
   FROM appointment
     LEFT JOIN consultant ON appointment.agent_no::text = consultant.agent_no::text
     LEFT JOIN customer ON appointment.customer_id = customer.id;