How to create Schedule Calendar Oracle Apex | Oracle apex advance Schedu...

on




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