SQL wninternet.com.br

INSERT INTO `ipbx_cadastro` ( `id` , `nome` , `cpf` , `rg` , `rua` , `numero_end` , `bairro` , `cidade` , `fixo1` , `fixo2` , `cel1` , `cel2` , `cel3` , `tipo_end` , `status` , `tel_id` , `data_venc` , `plano` , `tipo_pagamento` , `arquivo` , `email` , `sms` , `end_comp` , `cep` , `pagamento_roteador` ) VALUES ( 1 , 'Daniela Cavaglieri Vidotti.' , '17590755826' , '' , 'Rua Palmeira Imperial' , '11' , 'Jardim Conceição' , 'Hortolândia' , '19978200746' , '1978200746' , '1978200746' , '' , '' , '' , 'agendado_web' , '' , 25 , 'Radio 5MB' , '' , '' , ' flavioalmeida1985@gmail.com ' , '' , '' , '13185745' , NULL ), ( 2 , 'Flavio Alouysio de Almeida.' , '33094755810' , '' , 'Rua Dois' , '11' , 'Jardim Francisca' , 'Campinas' , '19987411001' , '' , '' , '' , '' , '' , 'agendado_web' , '' , 25 , 'Fibra 10MB' , '' , '' , ' flavioalmeida1985@gmail.com ' , '' , '54564564654654' , '13067812' , NULL ), ( 3 , 'Francisca Saraiva de Jesus' , '40355985349' , '' , 'Rua Anair Caetano Gonçalves' , '544' , 'Jardim Nova América' , 'Campinas' , '1982405025' , '1981192958' , '88988874463' , '' , '' , 'confirmar' , 'agendado-2017-04-07' , '1932250325' , 10 , '8 Megas radio' , 'avista' , '/var/www/gravacoes/assinatura/40355985349/09-33-07' , '' , '' , '' , '13053032' , '' ), ( 4 , 'Genivaldo de Souza' , '86211439172' , '' , 'Rua Um' , '195' , 'Cidade Singer' , 'Campinas' , '' , '' , '19983059210' , '19999299275' , '' , 'confirmar' , 'agendado-2017-04-05' , '1998305921' , 10 , '8 Megas radio' , 'avista' , '/var/www/gravacoes/assinatura/86211439172/13-41-55' , '' , '' , '' , '13053105' , 'avista' ), ( 5 , 'Nilza Nogueira' , '25369676895' , '' , 'Rua Arthur de Almeida Monteiro' , '412' , 'Vila Palmeiras II' , 'Campinas' , '' , '' , '19988367436' , '' , '' , 'confirmar' , 'agendar' , '1998836743' , 25 , '8 Megas radio' , 'avista' , '/var/www/gravacoes/assinatura/25369676895/17-04-51' , '' , '' , '' , '13053251' , '' ), ( 6 , 'Guilherme Lima dos Santos' , '06745234408' , '' , 'Rua Natividade Máxima de Jesus' , '44' , 'Jardim Puccamp' , 'Campinas' , '' , '' , '19994758686' , '' , '' , 'confirmar' , 'agendar' , '1998836989' , 10 , '8 Megas radio' , 'cartao' , '/var/www/gravacoes/assinatura/06745234408/14-50-26' , '' , '' , '' , '13053275' , '' ), ( 7 , 'Maria Ayris Carvalho da Silva' , '09968069469' , '' , 'Rua Auta Rosa Vieira Silva' , '432' , 'Jardim Itaguaçu I' , 'Campinas' , '' , '' , '19997365919' , '' , '' , 'confirmar' , 'agendado-2017-04-27' , '1933243418' , 10 , '8 Megas radio' , 'cartao' , '/var/www/gravacoes/assinatura/09968069469/15-03-55' , '' , '' , '' , '13053177' , '' ), ( 8 , 'Rodrigo Luis de Oliveira' , '41103145851' , '' , 'Rua Benedito Alves Ferreira' , '05' , 'Residencial da Paz' , 'Campinas' , '' , '' , '19983890949' , '' , '' , 'confirmar' , 'agendado-2017-05-11' , '1932651759' , 25 , '8 Megas radio' , 'avista' , '/var/www/gravacoes/assinatura/41103145851/18-07-32' , '' , '' , '' , '13053085' , '' ), ( 9 , 'Nilza Chaves Amaral' , '15033980807' , '' , 'Rua Mário Shimabukuro' , '35' , 'Residencial da Paz' , 'Campinas' , '' , '' , '19199860185' , '' , '' , 'confirmar' , 'agendado-2017-05-17' , '1999794601' , 25 , '8 Megas radio' , 'cartao' , '/var/www/gravacoes/assinatura/15033980807/09-27-06' , '' , '' , '' , '13053081' , 'cartao' ), ( 10 , 'Humberto Agostinho dos Santos' , '36549160820' , '' , 'Rua Agnaldo da Silva Filho' , '778' , 'Jardim Puccamp' , 'Campinas' , '' , '' , '19991023078' , '' , '' , 'confirmar' , 'agendado-2017-05-19' , '1998190946' , 25 , '8 Megas radio' , 'cartao' , '/var/www/gravacoes/assinatura/36549160820/14-33-52' , '' , '' , '' , '13053280' , '' ), INSERT INTO `ipbx_cadastro_token` ( `id` , `cadastro_id` , `token` , `expiration` ) VALUES ( 1 , 988 , 'c35335af015fc6e44e5d65d5affe3835' , '2016-08-26 22:55:11' ), ( 2 , 989 , '4bde5315021c548f720503d98a02e191' , '2016-08-26 23:56:14' ), ( 3 , 990 , '73f157dc70ca23cce3c5d281fd824e93' , '2016-08-27 00:15:07' ), ( 4 , 991 , '68b0000cb7d319b2f55e4e5192407aeb' , '2016-08-27 00:21:25' ), ( 5 , 992 , '3c9f0007111c07e44656b5a689e966e2' , '2016-08-27 14:19:45' ), ( 6 , 993 , 'ce1bb9ec7ef37ecc1bfeb24ea4d54882' , '2016-08-27 14:24:55' ), ( 7 , 994 , '140fd3acdb15762fd7f252c418885cdd' , '2016-08-27 14:35:09' ), INSERT INTO `ipbx_calendario` ( `id` , `hora_ini` , `hora_fim` , `data_ini` , `data_fim` , `nome` , `cpf` , `id_cliente` , `error_code` , `bairro` , `tipo` , `protocolo_num` , `protocolo_status` , `protocolo_motivo` , `protocolo_data` , `resposta` , `observacao` , `periodo` ) VALUES ( 16 , '09:00:00' , '13:00:00' , '2016-02-20' , '2016-02-20' , 'Horario Ocupado' , '' , '' , '' , '' , '' , 0 , 'aberto' , 'baixado cliente' , '0000-00-00' , '' , '' , 'manha' ), ( 17 , '13:00:00' , '18:00:00' , '2016-02-22' , '2016-02-22' , 'Horario Ocupado' , '' , '' , '' , '' , '' , 0 , 'aberto' , 'baixado cliente' , '0000-00-00' , '' , '' , 'tarde' ), ( 18 , '13:00:00' , '18:00:00' , '2016-02-23' , '2016-02-23' , 'Horario Ocupado' , '' , '' , '' , '' , '' , 0 , 'aberto' , 'baixado cliente' , '0000-00-00' , '' , '' , 'tarde' ), ( 19 , '13:00:00' , '18:00:00' , '2016-02-24' , '2016-02-24' , 'Horario Ocupado' , '' , '' , '' , '' , '' , 0 , 'aberto' , 'baixado cliente' , '0000-00-00' , '' , '' , 'tarde' ), ( 22 , '09:00:00' , '13:00:00' , '2016-02-22' , '2016-02-22' , 'Horario Ocupado' , '' , '' , '' , '' , '' , 0 , 'aberto' , 'baixado cliente' , '0000-00-00' , '' , '' , 'manha' ), ( 23 , '09:00:00' , '13:00:00' , '2016-02-23' , '2016-02-23' , 'Horario Ocupado' , '' , '' , '' , '' , '' , 0 , 'aberto' , 'baixado cliente' , INSERT INTO `ipbx_calendario` ( `id` , `hora_ini` , `hora_fim` , `data_ini` , `data_fim` , `nome` , `cpf` , `id_cliente` , `error_code` , `bairro` , `tipo` , `protocolo_num` , `protocolo_status` , `protocolo_motivo` , `protocolo_data` , `resposta` , `observacao` , `periodo` ) VALUES ( 627 , '14:31:00' , '16:00:00' , '2016-04-29' , '2016-04-29' , 'POP Sta Monica' , '' , '' , '' , 'Sta Monica' , 'instalacao' , 0 , 'fechado' , '' , '0000-00-00' , '' , '' , 'tarde' ), ( 631 , '09:00:00' , '10:30:00' , '2016-05-05' , '2016-05-05' , 'Israel Ramos de Oliveira Junior' , '46561529863' , '' , '999' , 'Conjunto Habitacional Residencial Olímpia' , 'instalacao' , 0 , 'aberto' , 'baixado cliente' , '0000-00-00' , '' , '' , 'manha' ), ( 634 , '16:00:00' , '17:30:00' , '2016-05-02' , '2016-05-02' , 'Osvaldo Andre Guartieri' , '21248241800' , '' , '999' , 'Conjunto Habitacional Vila Réggio' , 'instalacao' , 0 , 'fechado' , 'baixado ADM' , '0000-00-00' , '' , '' , 'tarde' ), ( 636 , '09:00:00' , '10:30:00' , '2016-05-06' , '2016-05-06' , 'Daniela Patricia Orlandini' , '36163041801' , '139' , '404' , 'Vila Renascença' , 'manutencao' , 0 , 'fechado' , 'baixado ADM' , '0000-00-00' , '' , '' , 'manha' ), ( 639 , '15:30:00' , '17:00:00' , '2016-05-03' , '2016-05-03' , 'Rosete Isidio de Almeida' , '02187885844' , '' , '999' , 'Jardim Conceição' , 'instalacao' , 0 , 'fechado' , 'baixado ADM' , '0000-00-00' , '' , '' , 'tarde' ), ( 640 , '16:00:00' , '17:30:00' , '2016-05-04' , '2016-05-04' , 'Carlos Eduardo Lima Ponce' , '30381523829' , '' , '999' , 'Conjunto Habitacional Vila Réggio' , 'instalacao' , 0 , 'fechado' , '' , '0000-00-00' , '' , '' , 'tarde' ), ( 152476 , '2023-01-21 09:00:46' , 'HttpService' , 'INFO' , 'stopped execution' , 2797 , '131.100.205.125' , '4276722463c' , '/wn/api/services/agenda/getByRange.php' , '/var/www/html/wn/api/app/Services/Handlers/StopHandler.php' , '9' ), ( 152477 , '2023-01-21 09:00:46' , 'HttpService' , 'INFO' , 'starting service:/wn/api/services/agenda/getByRange.php?startDate=2022-12-25&endDate=2023-01-01\nGET/ (startDate=2022-12-25&endDate=2023-01-01)\nUser-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36\nRequired-Permission-Id: 1' , 2797 , '131.100.205.125' , '20509370636' , '/wn/api/services/agenda/getByRange.php' , '/var/www/html/wn/api/app/Services/Handlers/StartHandler.php' , '13' ), ( 152478 , '2023-01-21 09:00:46' , 'HttpService' , 'INFO' , 'obtaining token' , 2797 , '131.100.205.125' , '20509370636' , '/wn/api/services/agenda/getByRange.php' , '/var/www/html/wn/api/app/Services/Handlers/Rest/AuthorizationHandler.php' , '11' ), ( 152479 , '2023-01-21 09:00:46' , 'HttpService' , 'INFO' , '815a2504-698a-498c-b0cf-9383ce06d507' , 2797 , '131.100.205.125' , '20509370636' , '/wn/api/services/agenda/getByRange.php' , '/var/www/html/wn/api/app/Services/Handlers/Rest/AuthorizationHandler.php' , '15' ), ( 152480 , '2023-01-21 09:00:46' , 'HttpService' , 'INFO' , 'authorization given' , 2797 , '131.100.205.125' , '20509370636' , '/wn/api/services/agenda/getByRange.php' , '/var/www/html/wn/api/app/Services/Handlers/Rest/AuthorizationHandler.php' , '19' ), ( 152481 , '2023-01-21 09:00:46' , 'HttpService' , 'INFO' , 'executing service' , 2797 , '131.100.205.125' , '20509370636' , '/wn/api/services/agenda/getByRange.php' , '/var/www/html/wn/api/app/Services/Handlers/Rest/ExecutionHandler.php' , '18' ), INSERT INTO `ipbx_log` ( `id` , `timestamp` , `logger` , `level` , `message` , `thread` , `ip` , `requestId` , `main` , `file` , `line` ) VALUES ( 4363 , '2017-02-06 13:28:50' , 'HttpService' , 'INFO' , 'exception ''InvalidUsernameOrPasswordException'' with message ''Invalid username or password'' in /var/www/mva/api/src/business/GetAuthorizationTokenBO.inc.php:19\nStack trace:\n#0 /var/www/mva/api/src/service/authenticate.php(11): GetAuthorizationTokenBO->execute()\n#1 /var/www/mva/api/src/util/HttpService.inc.php(46): {closure}()\n#2 /var/www/mva/api/src/util/HttpService.inc.php(20): HttpService->processService(Object(Closure))\n#3 /var/www/mva/api/src/util/Service.inc.php(22): HttpService->execute(Object(Closure))\n#4 /var/www/mva/api/src/service/authenticate.php(12): Service->execute(Object(Closure))\n#5 {main}' , 32070 , '131.100.206.0' , '13428034458' , '/mva/api/src/service/authenticate.php' , '/var/www/mva/api/src/util/HttpService.inc.php' , '54' ), ( 4364 , '2017-02-06 13:28:50' , 'HttpService' , 'INFO' , 'done' , 32070 , '131.100.206.0' , '13428034458' , '/mva/api/src/service/authenticate.php' , '/var/www/mva/api/src/util/HttpService.inc.php' , '21' ), ( 4365 , '2017-02-06 13:28:50' , 'HttpService' , 'INFO' , 'stopping service' , 32070 , '131.100.206.0' , '13428034458' , '/mva/api/src/service/authenticate.php' , '/var/www/mva/api/src/util/HttpService.inc.php' , '28' ), ( 4366 , '2017-02-06 13:29:11' , 'AuthService' , 'INFO' , 'requesting following auth service\nX-Auth-Token:ae84e9fce2d233c1d73779c64159ea28\nRequired-Role-Id:*\n/mva/api/service/dashboard/getPartialActiveHosts.php\nGET/ ()\nUser-Agent:Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36\ncontent:\n' , 1857 , '10.11.14.255' , '16423023105' , '/mva/api/src/service/dashboard/getPartialActiveHosts.php' , '/var/www/mva/api/src/util/AuthService.inc.php' , '28' ),