#!/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: 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: 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: 91 SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '91' order by uniqueid Carla Rhana Marta Criando fila: 92 SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '92' order by uniqueid Gabriele João Jéssica Liliane Alice Helen Barbabra Anderson Criando fila: 93 SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '93' order by uniqueid Thales Daniela Criando fila: 94 SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '94' order by uniqueid Silvio Luan Amabily Anderson Criando fila: 95 SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '95' order by uniqueid Wellington Katiane Cristiano Augusto 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 Luiz Jeniffer Criando fila: 98 SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '98' order by uniqueid Thais Carol Aryane 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á 1200 - Carol Home 1207 - Tecnica João 1205 - Tecnica Fabio 1208 - Lucas Home 1204 - Jeova Home 1209 - Fabio Home 1206 - Ademir Home Criando fila: 201 SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '201' order by uniqueid 1002 - SAC 1001 - Faturamento 1003 - Financeiro Criando fila: 221 SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '221' order by uniqueid 1005 - Nathaly Vaz – Fiscal 1006 -Raquel Ramos – Contabilidade 1007 - Gabriela Souza – 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 – Diretoria Criando fila: 224 SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '224' order by uniqueid 1001 - Jackeline Zarzick – BPO Financeiro 1002 - Ketleen Oliveira – Produtividade e Faturamento 1003 - Lucas Nascimento – Produtividade e Faturamento 1016 -Nathália Marino - Produtividade e Faturamento Criando fila: 225 SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '225' order by uniqueid 1001 - Jackeline Zarzick – BPO Financeiro 1002 - Ketleen Oliveira – Produtividade e Faturamento 1003 - Lucas Nascimento – Produtividade e Faturamento Criando fila: 226 SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '226' order by uniqueid 1011 - Frantiesco Pessoa - Diretoria 1004 - Luciane Moro Pessoa – Diretoria Criando fila: 227 SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '227' order by uniqueid 1003 - Lucas Nascimento – Produtividade e Faturamento 1010 - João Jacques – Customer Success 1002 - Ketleen Oliveira – Produtividade e Faturamento 1008 - Jéssica Roxadelll – Folha de Pagamento 1000 - Geral -Geral 1001 - Jackeline Zarzick – BPO Financeiro Criando fila: 228 SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '228' order by uniqueid 1003 - Lucas Nascimento – Produtividade e Faturamento 1010 - João Jacques – 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 -Raquel Ramos – Contabilidade 1007 - Gabriela Souza – Fiscal Disponível -Disponível 1015 - Camila Herzog - Contabilidade 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 - Diretoria 1004 - Luciane Moro Pessoa – Diretoria Criando fila: 2212 SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '2212' order by uniqueid 1003 - Lucas Nascimento – Produtividade e Faturamento 1010 - João Jacques – Customer Success 1002 - Ketleen Oliveira – Produtividade e Faturamento 1008 - Jéssica Roxadelll – Folha de Pagamento 1000 - Geral -Geral 1001 - Jackeline Zarzick – BPO Financeiro 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> Ramal <1020> 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: 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: 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 1039 Rodolfo 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: 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 - Marcelo Criando fila: 1011 SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '1011' order by uniqueid Ramal <1001> Ramal <1002> Ramal <1003> Criando fila: 233 SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '233' order by uniqueid 1020 -Recepção 1023 1025 1026 1027 Criando fila: 1091 SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '1091' order by uniqueid 6720 - Comercial 2 6709 - Comercial 1 6744 - Exportação 6704 - Faturamento 6722 - Administrativo / Exportação Criando fila: 1092 SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '1092' order by uniqueid 6724 - Compras 2 6711 - Compras 1 Criando fila: 1093 SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '1093' order by uniqueid 6707 - Financeiro 1 6714 - Financeiro 2 6718 - Financeiro 3 Criando fila: 1094 SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '1094' order by uniqueid 6717 - Dep. Pessoal 3 6715 - Dep. Pessoal 1 6716 - Dep. Pessoal 2 Criando fila: 1097 SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '1097' order by uniqueid 6712 - Contabilidade 1 6713 - Contabilidade 2 Criando fila: 1098 SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '1098' order by uniqueid 6710 - Controladoria 1 6719 - Controladoria 2 Criando fila: 1099 SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '1099' order by uniqueid 6745 - Escritório Manutenção 1 6746 - Escritório Manutenção 2 6747 - Escritório Manutenção 3 Criando fila: 10910 SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '10910' order by uniqueid 6701 - PCP 1 6702 - PCP 2 Criando fila: 1121 SELECT * FROM pabxvirtual_queue_member_table WHERE queue_name = '1121' order by uniqueid <1000> <1002>