#!/usr/bin/php
SELECT a.* FROM pabxvirtual_queue_table a join users b on a.accountcode = b.id WHERE a.strategy = 'linear' and b.ativo = 'S'
Criando fila: 41
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '41' order by uniqueid
M. Fernanda
Tatiane
Julia
Criando fila: 42
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '42' order by uniqueid
Julia
M. Fernanda
Tatiane
Criando fila: 43
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '43' order by uniqueid
Tatiane
Criando fila: 62
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '62' order by uniqueid
Ramal <1009>
Ramal <1020>
Ramal <1008>
Criando fila: 63
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '63' order by uniqueid
Ramal <1018>
Criando fila: 64
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '64' order by uniqueid
Ramal <1010>
Criando fila: 65
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '65' order by uniqueid
Ramal <1015>
Criando fila: 66
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '66' order by uniqueid
Ramal <1004>
Ramal <1003>
Criando fila: 44
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '44' order by uniqueid
M. Fernanda
Julia
Tatiane
Criando fila: 71
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '71' order by uniqueid
Ramal <1023>
Ramal <1029>
Ramal <1037>
Ramal <1038>
Criando fila: 73
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '73' order by uniqueid
Ramal <1026>
Criando fila: 74
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '74' order by uniqueid
Ramal <1034>
Ramal <1042>
Criando fila: 75
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '75' order by uniqueid
Ramal <1023>
Ramal <1028>
Ramal <1029>
Ramal <1033>
Ramal <1035>
Ramal <1036>
Ramal <1037>
Ramal <1038>
Criando fila: 141
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '141' order by uniqueid
1001 - Comercial São Paulo
1002 - Comercial - 2 - Off-line
Criando fila: 91
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '91' order by uniqueid
Carla
Katiane
Marta
Criando fila: 92
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '92' order by uniqueid
Helen
Gabriele
João
Liliane
Alice
Jéssica
Lo Ruama
Anderson
Barbabra
Criando fila: 93
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '93' order by uniqueid
Silvio
Criando fila: 94
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '94' order by uniqueid
Silvio
Luan
Anderson
Criando fila: 95
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '95' order by uniqueid
Augusto
Cristiano
Wellington
Anderson
Criando fila: 96
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '96' order by uniqueid
Paulo Cesar
Anderson
Criando fila: 97
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '97' order by uniqueid
Patricia
Jeniffer
Criando fila: 98
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '98' order by uniqueid
Thais
Carol
Jeniffer
Criando fila: 99
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '99' order by uniqueid
Thales
Daniela
Jeniffer
Criando fila: 100
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '100' order by uniqueid
Silvio
Luan
Jeniffer
Criando fila: 901
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '901' order by uniqueid
Criando fila: 902
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '902' order by uniqueid
Criando fila: 161
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '161' order by uniqueid
1203 - Tecnica Jeová
1207 - Tecnica João
1205 - Tecnica Fabio
1200 - Carol Home
1208 - João Home
1209 - Fabio Home
1206 - Ademir Home
1204 - Jeova Home
Criando fila: 201
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '201' order by uniqueid
1002 - SAC
1001 - Logística
1003 - Financeiro
Criando fila: 221
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '221' order by uniqueid
1005 - Leonardo bazo – Contabilidade e Fiscal
1006 - Jacqueline Lank – Contabilidade e Fiscal
1007 - Gabriela Souza – Contabilidade e Fiscal
Criando fila: 222
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '222' order by uniqueid
1008 - Jéssica Roxadelll – Folha de Pagamento
1009 - Poliana Rosa - Folha de Pagamento
Criando fila: 223
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '223' order by uniqueid
1004 - Luciane Moro Pessoa – BPO Financeiro
Criando fila: 224
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '224' order by uniqueid
1001 - Jackeline Zarzick – Produtividade e Faturamento
1002 - Ketleen Oliveira – Produtividade e Faturamento
1003 - Gabriela Perasol – Produtividade e Faturamento
1016 - Camila Oliveira - Produtividade e Faturamento
Criando fila: 225
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '225' order by uniqueid
1001 - Jackeline Zarzick – Produtividade e Faturamento
1002 - Ketleen Oliveira – Produtividade e Faturamento
1003 - Gabriela Perasol – Produtividade e Faturamento
Criando fila: 226
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '226' order by uniqueid
1011 - Frantiesco Pessoa
1004 - Luciane Moro Pessoa – BPO Financeiro
Criando fila: 227
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '227' order by uniqueid
1003 - Gabriela Perasol – Produtividade e Faturamento
1010 - Fparida Affonso – Customer Success
1002 - Ketleen Oliveira – Produtividade e Faturamento
1008 - Jéssica Roxadelll – Folha de Pagamento
1000 - Geral
1001 - Jackeline Zarzick – Produtividade e Faturamento
Criando fila: 228
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '228' order by uniqueid
1003 - Gabriela Perasol – Produtividade e Faturamento
1010 - Fparida Affonso – Customer Success
1002 - Ketleen Oliveira – Produtividade e Faturamento
Criando fila: 229
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '229' order by uniqueid
1006 - Jacqueline Lank – Contabilidade e Fiscal
1007 - Gabriela Souza – Contabilidade e Fiscal
1012 - Marcos Claman - Contabilidade e Fiscal
1015 - Milena Kluves - Contabilidade e Fiscal
Criando fila: 2210
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '2210' order by uniqueid
1008 - Jéssica Roxadelll – Folha de Pagamento
1009 - Poliana Rosa - Folha de Pagamento
Criando fila: 2211
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '2211' order by uniqueid
1011 - Frantiesco Pessoa
1004 - Luciane Moro Pessoa – BPO Financeiro
Criando fila: 2212
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '2212' order by uniqueid
1003 - Gabriela Perasol – Produtividade e Faturamento
1010 - Fparida Affonso – Customer Success
1002 - Ketleen Oliveira – Produtividade e Faturamento
1008 - Jéssica Roxadelll – Folha de Pagamento
1000 - Geral
1001 - Jackeline Zarzick – Produtividade e Faturamento
Criando fila: 231
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '231' order by uniqueid
1020 -Recepção
1023
1025
1026
1027
Criando fila: 232
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '232' order by uniqueid
1020 -Recepção
1023
1025
1026
1027
Criando fila: 191
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '191' order by uniqueid
1020 - Recepção
Criando fila: 371
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '371' order by uniqueid
Ramal <1021>
Criando fila: 441
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '441' order by uniqueid
Ramal <1000>
Ramal <1005>
Criando fila: 471
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '471' order by uniqueid
Ramal <1000>
Ramal <1005>
Ramal <1007>
Criando fila: 392
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '392' order by uniqueid
1016 - Reunião 2 - CONNECT
1022 - Operacional CR - CR PERÍCIAS
Criando fila: 393
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '393' order by uniqueid
1016 - Reunião 2 - CONNECT
Criando fila: 394
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '394' order by uniqueid
1016 - Reunião 2 - CONNECT
1022 - Operacional CR - CR PERÍCIAS
Criando fila: 631
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '631' order by uniqueid
1000 - VENDAS 1
1001 - VENDAS 2
Criando fila: 292
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '292' order by uniqueid
Ramal <2000>
Ramal <2001>
Criando fila: 682
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '682' order by uniqueid
Ramal <1001>
Ramal <1002>
Ramal <1003>
Criando fila: 68
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '68' order by uniqueid
Ramal <1014>
Ramal <1000>
Criando fila: 641
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '641' order by uniqueid
1020 - Recepção
Criando fila: 752
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '752' order by uniqueid
1025 Beatriz
1022 Laís
1032 Ana Alice
1027 Natália
1020 Erasmo
1021 Moyses
Criando fila: 753
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '753' order by uniqueid
1024 Evandro
1025 Beatriz
Criando fila: 754
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '754' order by uniqueid
1025 Beatriz
Criando fila: 791
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '791' order by uniqueid
1001 - Comercial
1002 - Comercial
1003 - Comercial
1004 - Comercial
Criando fila: 792
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '792' order by uniqueid
1005 - Logística
Criando fila: 793
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '793' order by uniqueid
1007 - Cobrança
1008 - Financeiro
Criando fila: 794
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '794' order by uniqueid
1005 - Logística
1006 - Faturamento
1007 - Cobrança
1001 - Comercial
1002 - Comercial
1003 - Comercial
1004 - Comercial
Criando fila: 46
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '46' order by uniqueid
M. Fernanda
Tatiane
Criando fila: 873
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '873' order by uniqueid
1010 - Financeiro
Criando fila: 875
SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '875' order by uniqueid
1011 - Comercial