create or replace procedure bpov3.P_BPO_Rpt_CallIn
(
rCursor OUT sys_refcursor,
iStartDate DATE,
iEndDate DATE,
iTimeUnit INT,
iCCID NUMBER,
iVDN VARCHAR2,
iVDNUserName VARCHAR2,
iFlag VARCHAR2,
iStartRow INT,
iEndRow INT
)
AS
eUser EXCEPTION;
eInPut EXCEPTION;
tStartDate DATE;
tEndDate DATE;
tAdmStartDate DATE;
tAdmEndDate DATE;
tRet INT;
BEGIN
--对用户和输入时间进行判断
IF (iStartDate IS NULL) or (iEndDate IS NULL) or (iStartDate > iEndDate) THEN
RAISE eInPut;
END IF; tAdmStartDate := TO_DATE('2000-01-01', 'YYYY-MM-DD');
tAdmEndDate := TO_DATE('2000-01-01', 'YYYY-MM-DD'); -- 对输入时间进行处
tRet := sp_Utl_PrepareData (iStartDate, iEndDate, tAdmStartDate, tAdmEndDate, iTimeUnit,
tStartDate, tEndDate, tAdmStartDate, tAdmEndDate); --如果时间处理失败,返回
IF tRet <> 0 THEN
RAISE eInPut;
END IF;
(
rCursor OUT sys_refcursor,
iStartDate DATE,
iEndDate DATE,
iTimeUnit INT,
iCCID NUMBER,
iVDN VARCHAR2,
iVDNUserName VARCHAR2,
iFlag VARCHAR2,
iStartRow INT,
iEndRow INT
)
AS
eUser EXCEPTION;
eInPut EXCEPTION;
tStartDate DATE;
tEndDate DATE;
tAdmStartDate DATE;
tAdmEndDate DATE;
tRet INT;
BEGIN
--对用户和输入时间进行判断
IF (iStartDate IS NULL) or (iEndDate IS NULL) or (iStartDate > iEndDate) THEN
RAISE eInPut;
END IF; tAdmStartDate := TO_DATE('2000-01-01', 'YYYY-MM-DD');
tAdmEndDate := TO_DATE('2000-01-01', 'YYYY-MM-DD'); -- 对输入时间进行处
tRet := sp_Utl_PrepareData (iStartDate, iEndDate, tAdmStartDate, tAdmEndDate, iTimeUnit,
tStartDate, tEndDate, tAdmStartDate, tAdmEndDate); --如果时间处理失败,返回
IF tRet <> 0 THEN
RAISE eInPut;
END IF;
优势: *提供了解决方案的Genesys联络中心托管的企业或PREM的控制为基础的环境,通过一个易于使用的商业用户界面
*提供的Genesys语音与路由的无缝管理
*提供安全控制,授权经营单位的住户或个人访问一个多租户共享的基础设施环境
*降低经营成本,更快地提供解决方案的部署
允许企业利用主办未经开发的成本和风险的自助服务解决方案和联络中心的功能和控制,采购和部署他们
提供托管服务能力,与多个业务单位,大型企业,内部的 IT部门必须满足客户的需求独特的内部
*创建可重复的解决方案,而且可以很容易地推广到多个客户或内部业务单位 - 独特的外观和感觉的品牌包的包
var aOpen = this.getCookie('co' + this.obj).split('.');
for (var n=0; n<aOpen.length; n++)
if (aOpen[n] == id) return true;
return false;
};// If Push and pop is not implemented by the browser
if (!Array.prototype.push) {
Array.prototype.push = function array_push() {
for(var i=0;i<arguments.length;i++)
this[this.length]=arguments[i];
return this.length;
}
};
if (!Array.prototype.pop) {
Array.prototype.pop = function array_pop() {
lastElement = this[this.length-1];
this.length = Math.max(this.length-1,0);
return lastElement;
}
};
// Add by xiaosilent.
// Call to show the tree .
dTree.prototype.show = function(){
if(this.config.check==true){
getcheck(this); }
// Renew the two array to save original data.
this.aNodes=new Array();
this.aIndent=new Array();
// Dump original data to aNode array.
for(var i=0 ; i<this.aNodesData.length ; i++){
var oneNode=this.aNodesData[i];
this.aNodes[i]=new Node(oneNode.id,oneNode.pid,oneNode.name,oneNode.url,oneNode.title,oneNode.target,oneNode.icon,oneNode.iconOpen,oneNode.open);
}
if(this.aNodesData.length == 0){
alert_divMsg('请联系系统管理员配置相应的区域','确定');
return;
}
this.rewriteHTML();
}// Outputs the tree to the page , callled by show()
// Changed by xiaosilent.dTree.prototype.rewriteHTML = function() {
var str = '';
// Added by xiaosilent.
var targetDIV;
targetDIV=document.getElementById(this.targetID);
if(!targetDIV){
alert('dTree can\'t find your specified container to show your tree.\n\n Please check your code!');
return;
}
if (this.config.useCookies) this.selectedNode = this.getSelected();
str += this.addNode(this.root);
// Disabled by xiaosilent.
// str += '</div>'; if (!this.selectedFound) this.selectedNode = null; // Disabled and added by xiaosilent.
//return str;
targetDIV.innerHTML=str;
if(this.config.check==true){
checkBack(this);
}
document.getElementById("dTreeNode").style.display="none";
};// Add by xiaosilent .
// get child nodes from web server via AJAX automatically
// pid : parentID.
dTree.prototype.getChildren = function(pid){
var tree=this;
DWREngine.setAsync(false);
ZoneDwr.queryParentZone(pid,function callback(data){
for(var property in data){
var fid = data[property].id;
var flag = true;
if("0" == data[property].leaf){
if(tree.config.check && "0" != fid){
ZoneDwr.queryLeafage(fid,function callback(data){
if(data) flag = false;
});
}
if(flag){
tree.add(fid, pid, data[property].name, "javascript:"+tree.obj+".getChildren("+data[property].id+")", data[property].name,'',tree.icon.folder);
// tree.getChildren(data[property].id);
}
}else if("1" == data[property].leaf){
tree.add(fid, pid, data[property].name, "javascript:"+tree.obj+".showCategory("+data[property].id+")", data[property].name);
}
}
});
tree.show();
tree.openTo(pid);
}
var tree=this;
DWREngine.setAsync(false);
ZoneDwr.loadChildren(id,function callback(data){
for(var property in data){
var dTreeNode = document.getElementById("dTreeNode");
if(null == dTreeNode && typeof(data[property].leaf)!="undefined"){
tree.add(data[property].parentID,-1,'区域信息',"#");
}
if("0" == data[property].leaf){
tree.add(data[property].id, data[property].parentID, data[property].name, "javascript:"+tree.obj+".getChildren("+data[property].id+")", data[property].name,'',tree.icon.folder);
// tree.getChildren(id);
}else if("1" == data[property].leaf){
tree.add(data[property].id, data[property].parentID, data[property].name, "javascript:"+tree.obj+".showCategory("+data[property].id+")", data[property].name);
}
}
});
tree.show();
//tree.openTo(id);
}
dTree.prototype.showCategory = function(){alert("showCategory");
}
var inputCheck = [];
function getcheck(dtree){
inputCheck.length=0;
var input = document.getElementById("dtree").getElementsByTagName("input");
for(var i=0;i<input.length;i++){
if("checkbox" == input[i].type && input[i].checked ){
var idstr = input[i].id;
var sub= idstr.length -2;
str = idstr.substr(2,sub);
inputCheck[inputCheck.length] = dtree.aNodes[str].id;
}
}
}
function checkBack(dtree){
if(0 < inputCheck.length){
for(var i=0;i<inputCheck.length;i++){
for(var j=1;j<dtree.aNodes.length;j++){
if(dtree.aNodes[j].id == inputCheck[i]){
document.getElementById("c"+dtree.obj+j).checked=true;
break;
}
}
}
}
}
function submitConfig(path){
var inputCheckStr = "";
var submitCheck = document.getElementsByTagName("input");
for(var i=0;i<submitCheck.length;i++){
if("checkbox" == submitCheck[i].type && submitCheck[i].checked ){
var idstr = submitCheck[i].id;
var sub= idstr.length -2;
inputCheckStr += idstr.substr(2,sub) + ",";
}
}
if(0 < inputCheckStr.length){
var sublength = inputCheckStr.length-1;
inputCheckStr = inputCheckStr.substr(0,sublength);
document.location.href=encodeURI(path+"/loud/submitConfig.action?fids="+inputCheckStr);
}
}