4.50

Owned by Daniel Olivera (Unlicensed)
Nov 16, 2016
1 min read



Componentes



  • Cambiar IntegraPortalWS.war 

  • Cambiar uContact

  • Cambiar workflowsdesigner

  • Cambiar formsdesigner

  • Cambiar reports



Database



//Agrando configuration para valores de reciclaje ALTER TABLE `ccdata`.`configuration` CHANGE COLUMN `value` `value` TEXT NOT NULL; //Agrando para alternativos ALTER TABLE `ccdata`.`calls_spool` CHANGE COLUMN `alternatives` `alternatives` VARCHAR(500) DEFAULT ''; //agrego ordenes de marcado en dialers ALTER TABLE `ccdata`.`dialer` ADD COLUMN `schedulephones` TEXT NULL AFTER `dncr`; //trigger para fixes de logins DROP TRIGGER `ccrepo`.`tg_queue_log_repo_automaticfix`; delimiter // CREATE TRIGGER `ccrepo`.`tg_queue_log_repo_automaticfix` BEFORE INSERT ON ccrepo.queue_log_repo FOR EACH ROW BEGIN DECLARE datetimeeventstart timestamp; DECLARE datetimeeventend timestamp; IF(new.data4 = 'automatic')then select DATE_ADD(datetime, interval 10 second) into @datetimeeventend from queue_log_repo where agent = new.agent and datetime >= DATE_SUB(curdate(),interval 30 day) and datetime <= now() and event not in ('PAUSEALL','PAUSE','UNPAUSE','UNPAUSEALL') order by datetime desc limit 1; SET new.datetime = @datetimeeventend; IF (new.event= 'UNBREAK')THEN select datetime into @datetimeeventstart from queue_log_repo where agent = new.agent and datetime >= DATE_SUB(curdate(),interval 30 day) and datetime <= now() and event='BREAK' order by datetime desc limit 1; SET new.data3 = TIMESTAMPDIFF(SECOND,@datetimeeventstart,@datetimeeventend); END IF; IF (new.event= 'AGENTLOGOFF')THEN select datetime into @datetimeeventstart from queue_log_repo where agent = new.agent and datetime >= DATE_SUB(curdate(),interval 30 day) and datetime <= now() and event='AGENTLOGIN' order by datetime desc limit 1; SET new.data1 = TIMESTAMPDIFF(SECOND,@datetimeeventstart,@datetimeeventend); END IF; END IF; END//



Otros

  • Update workflows: Powerdialer, Predictive y VoiceBroadcast en caso sea necesario