Booking Schedule calendar coad:
select a.PID,
b.ENAME ||' Room No: '||a.LOCATION_ROON_NO||' Schedule Date: '||a.SCHEDULE_DATE || ' Start Time: '||to_char(a.START_TIME,'hh24:mi')|| ' End Time: '||to_char(a.END_TIME,'hh24:mi')||'-'||a.STATUS display,
a.SCHEDULE_DATE,
a.LOCATION_ROON_NO,
a.DURATION,
a.PID_ORG,
a.START_TIME,
a.END_TIME,
a.MAXIMUM_PATIENT,
case
when a.STATUS='Confirm' then 'apex-cal-blue'
when a.STATUS='Draft' then 'apex-cal-green'
when a.STATUS='Submit' then 'apex-cal-orange'
end as css_class
from DOCTOR_BOOKING_SCHEDULE a, EMP b
where a.PID_EMP_DOCTOR = b.EMPNO(+)
Drug and Drop Coad:
begin
update "DOCTOR_BOOKING_SCHEDULE"
set "SCHEDULE_DATE" = to_date(:APEX$NEW_START_DATE, 'YYYYMMDDHH24MISS')
where "PID" = :APEX$PK_VALUE;
end;
►►Our Published Video Link : Procedure base Post Method API: https://www.youtube.com/watch?v=wp67G... Collection A to Z: https://www.youtube.com/watch?v=d3GOd... Delete page Recover: https://www.youtube.com/watch?v=ymWu2... Facebook Authentication: https://www.youtube.com/watch?v=n7sTE... Google Authentication: https://www.youtube.com/watch?v=ZqOzQ... Recaptcha: https://www.youtube.com/watch?v=0K0Fn... Notification Menu: https://www.youtube.com/watch?v=6zlaW... Signature Plugin: https://www.youtube.com/watch?v=NpwjR... Web Source Report: https://www.youtube.com/watch?v=AV-zj... Report Download Plugin: https://www.youtube.com/watch?v=5ofWg... ►► For More Videos, Please Subscribe our Channel: https://www.youtube.com/channel/UCwsr... ------------------------------------------ Thank you
Comments
Post a Comment