[Home] [Help]
211:
212: /* get talking agents for graph */
213: select count(distinct I1.resource_id) into talk_graph
214: from IEU_SH_SESSIONS I1,
215: IEU_SH_ACTIVITIES I2,
216: CCT_media_items M,
217: JTF_RS_GROUP_MEMBERS J4,
218: CCT_AGENT_RT_STATS C1
219: where I1.session_id = I2.session_id
237: /* get wrapping agents for graph */
238: /* removed
239: Select count(distinct I1.resource_id) into wrap_graph
240: from IEU_SH_SESSIONS I1,
241: IEU_SH_ACTIVITIES I2,
242: CCT_AGENT_RT_STATS C1,
243: CCT_media_items M,
244: JTF_RS_GROUP_MEMBERS J4
245: where I1.session_id = I2.session_id
517: available:
518: ----------*/
519: select sum(decode(I1.deliver_date_time,null,l_date_high-I1.begin_date_time,
520: I1.deliver_date_time-I1.begin_date_time))*3600*24 into available
521: from ieu_sh_activities I1,
522: ieu_sh_sessions I2
523: where I1.session_id = I2.session_id
524: and I2.resource_id = v_agent_id
525: and I2.begin_date_time between l_date_low and l_date_high
545: and J3.media_id = J1.media_id
546: and J3.media_item_type = 'TELEPHONE';
547:
548: select sum(l_date_high-I2.deliver_date_time)*3600*24 into talk_now
549: from ieu_sh_activities I2,
550: ieu_sh_sessions I1
551: where I1.session_id = I2.session_id
552: and I1.resource_id = v_agent_id
553: and I1.application_id = 696
566: --------------------------*/
567:
568: Select sum(l_date_high - C1.last_update_date)*24*3600 into wrap_now
569: from IEU_SH_SESSIONS I1,
570: IEU_SH_ACTIVITIES I2,
571: CCT_AGENT_RT_STATS C1
572: where I1.session_id = I2.session_id
573: and I1.application_id = 696
574: and I2.active_flag ='T'
702: Cursor getAvailableAgentList is
703: Select
704: (l_date_high - I2.begin_date_time)*24*3600 duration
705: from IEU_SH_SESSIONS I1,
706: IEU_SH_ACTIVITIES I2
707: where I1.session_id = I2.session_id
708: and I1.application_id = 696
709: and I1.active_flag ='T'
710: and I1.end_date_time is NULL
730: (l_date_high - C1.last_update_date)*24*3600 duration
731: from CCT_AGENT_RT_STATS C1,
732: /* CCT_MEDIA_ITEMS C2,*/
733: IEU_SH_SESSIONS I1,
734: IEU_SH_ACTIVITIES I2
735: where C1.has_call = 'F'
736: and C1.agent_id = v_resource_id
737: /*and C2.media_item_id = I2.media_id*/
738: and I1.session_id = I2.session_id
775: /* today: does not make sense
776: Cursor getTodayLoginTime is
777: select l_date_high-I1.begin_date_time loginTime
778: from IEU_SH_SESSIONS I1,
779: IEU_SH_ACTIVITIES I2
780: where I1.session_id = I2.session_id
781: and I1.application_id = 696
782: and I1.begin_date_time between l_date_low and l_date_high
783: and I1.resource_id = v_resource_id
786:
787: Cursor getLoginTime is
788: select min(l_date_high-I1.begin_date_time)*24*3600 loginTime
789: from IEU_SH_SESSIONS I1,
790: IEU_SH_ACTIVITIES I2
791: where I1.session_id = I2.session_id
792: and I1.application_id = 696
793: and I1.resource_id = v_resource_id
794: and I1.active_flag = 'T';
905: end if;
906:
907: select count(I2.media_id) into CallsHandled
908: from IEU_SH_SESSIONS I1,
909: IEU_SH_ACTIVITIES I2
910: where I1.session_id = I2.session_id
911: and I1.application_id = 696
912: and I1.begin_date_time between l_date_low and l_date_high
913: and I1.resource_id = v_resource_id;
1083: (l_date_high - I2.begin_date_time)*24*3600 availTime,
1084: /* J1.group_name groupName,*/
1085: I1.extension extension
1086: from IEU_SH_SESSIONS I1,
1087: IEU_SH_ACTIVITIES I2,
1088: JTF_RS_RESOURCE_EXTNS_VL J,
1089: JTF_RS_GROUPS_VL J1,
1090: JTF_RS_GROUP_MEMBERS J2
1091: where I1.session_id = I2.session_id
1118: JTF_RS_RESOURCE_EXTNS_VL J,
1119: JTF_RS_GROUPS_VL J3,
1120: JTF_RS_GROUP_MEMBERS J4,
1121: IEU_SH_SESSIONS I1,
1122: IEU_SH_ACTIVITIES I2
1123: where C1.has_call = 'T'
1124: and C1.agent_id = J.resource_id
1125: and C2.media_item_id = I2.media_id
1126: and I1.session_id = I2.session_id
1144: JTF_RS_RESOURCE_EXTNS_VL J,
1145: JTF_RS_GROUPS_VL J3,
1146: JTF_RS_GROUP_MEMBERS J4,
1147: IEU_SH_SESSIONS I1,
1148: IEU_SH_ACTIVITIES I2
1149: where C1.has_call = 'F'
1150: and C1.agent_id = J.resource_id
1151: /* and C2.media_item_id = I2.media_id */
1152: and I1.session_id = I2.session_id