Mudanças entre as edições de "Controllr/API/REST-HTTP/Área Administrativa"

De BrByte Wiki
< Controllr‎ | API‎ | REST-HTTP
(Criou página com '=='''Capturar Informações do Cliente'''== <div> <span class="label label-info">POST</span> <span class="label label-concrete">/site_ctl/config/info</span> </div> <blockquo...')
 
 
(13 revisões intermediárias por um outro usuário não estão sendo mostradas)
Linha 1: Linha 1:
=='''Capturar Informações do Cliente'''==
+
 
 +
==='''Listar os Clientes'''===
  
 
<div>
 
<div>
<span class="label label-info">POST</span> <span class="label label-concrete">/site_ctl/config/info</span>
+
<span class="label label-info">POST</span> <span class="label label-concrete">/controllrctl/client/list</span>
 
</div>
 
</div>
  
Linha 9: Linha 10:
 
   curl -i -X POST \
 
   curl -i -X POST \
 
         -H "Content-Type:application/x-www-form-urlencoded" \
 
         -H "Content-Type:application/x-www-form-urlencoded" \
         -H "Accept:application/json" \
+
         -H "Accept:application/json" \
         -d "username=teste" \
+
         -d "where: [{"field":"client_status","oper":5,"value":0}]" \
         -d "password=12345678" \
+
         -d "start: 0" \
      <nowiki>'http://192.168.142.23/site_ctl/config/info'</nowiki>   
+
        -d "limit: 15" \
 +
        -d "sort: client_complete_name" \
 +
        -d "dir: ASC" \
 +
        <nowiki>'http://192.168.144.10:8080/controllrctl/client/list'</nowiki>   
  
 
</pre></blockquote>
 
</pre></blockquote>
Linha 22: Linha 26:
 
<blockquote class="blockquote-neutral"><pre>
 
<blockquote class="blockquote-neutral"><pre>
 
   
 
   
{
+
{
 
     "success": true,
 
     "success": true,
     "facebook": {
+
     "total": 493,
        "page": <nowiki>"https://www.facebook.com/ispcontrollr"</nowiki>,
+
    "results": [
        "title": "FACEBOOK"
+
        {
    },
+
            "client_pk": 430,
    "anatel": {
+
            "client_status": 3,
        "scm": "00000",
+
            "client_type": 0,
        "title": "Provedor Licenciado"
+
            "client_username": "",
    },
+
            "client_password": "",
    "title": "Meu Provedor",
+
            "client_name": "teste",
    "theme": "brbyte-light",
+
            "client_lastname": "brbyte",
    "support_open_time": 5,
+
            "client_mail": "",
    "print_contract": 1,
+
            "client_doc1": "",
    "change_password": 1
+
            "client_doc2": "",
}
+
            "client_date_cad": "2016-09-20 00:00:00",
 
+
            "client_date_deactivation": null,
 +
            "client_date_birth": "2016-09-20 00:00:00",
 +
            "client_observations": "",
 +
            "offices_pk": 1,
 +
            "offices_identification": "Matriz",
 +
            "client_complete_name": "teste brbyte",
 +
            "client_phones": null,
 +
            "cli_addr_address": "Rua Oscar Ferreira Bugre",
 +
            "cli_addr_number": "88",
 +
            "cli_addr_neighborhood": "Vila Nasser",
 +
            "cli_addr_zipcode": "79.117-101",
 +
            "cli_addr_province": "Campo Grande",
 +
            "cli_addr_state": "MS",
 +
            "cli_addr_completation": ""
 +
        }
 +
    ]
 +
}
 
</pre></blockquote>
 
</pre></blockquote>
  
=='''Alterar senha do Login'''==
+
==='''Listar os Contratos'''===
  
 
<div>
 
<div>
<span class="label label-info">POST</span> <span class="label label-concrete">/session/setpassword</span>
+
<span class="label label-info">POST</span> <span class="label label-concrete">/controllrctl/contract/list</span>
 
</div>
 
</div>
 
 
{| class='table table-responsive table-striped'
 
! PROPRIEDADE
 
! TIPO
 
! TAMANHO
 
! OBRIGATÓRIO
 
! DESCRIÇÃO
 
|-
 
| user_password || Texto || 8~16 || Sim || Senha
 
|-
 
| user_password_repeat || Texto || 8~16 || Sim || Senha de novo
 
|-
 
|}
 
  
 
<blockquote><pre>
 
<blockquote><pre>
  
curl -i -X POST \
+
  curl -i -X POST \
    -H "Content-Type:application/x-www-form-urlencoded" \
+
        -H "Content-Type:application/x-www-form-urlencoded" \
    -H "Accept:application/json" \
+
        -H "Accept:application/json" \
    -d "user_password: Nova senha" \
+
        -d "where: [{"field":"contract_deleted","oper":5,"value":false},{"field":"AND"},{"field":"contract_status","oper":5,"value":0}]" \
    -d "user_password_repeat: Nova senha" \
+
        -d "client_complete_name:" \
    <nowiki>'http://192.168.142.23/session/setpassword'</nowiki>
+
        -d "offices_pk: 0" \
 +
        -d "start: 0" \
 +
        -d "limit: 15" \
 +
        -d "sort: contract_number" \
 +
        -d "dir: ASC" \
 +
        <nowiki>'http://192.168.144.10:8080/controllrctl/contract/list'</nowiki>
  
 
</pre></blockquote>
 
</pre></blockquote>
Linha 83: Linha 94:
 
     "results": [
 
     "results": [
 
         {
 
         {
             "client_username": "teste",
+
            "contract_pk": 466,
             "client_pk": 1
+
            "contract_number": 464,
 +
            "contract_pay_day": 10,
 +
            "contract_free": 0,
 +
            "contract_amount": "45.00",
 +
            "contract_pay_discount": null,
 +
            "contract_date_cad": "2017-02-08 18:30:11",
 +
            "contract_status": 0,
 +
            "contract_deleted": false,
 +
            "contract_observations": "",
 +
            "contract_block_type": 0,
 +
            "contract_date_last_paymentobservation": null,
 +
            "contract_tax_cfop": 5307,
 +
            "contract_tax_icms": "1.25",
 +
            "contract_tax_ibpt": "13.45",
 +
            "contract_block_auto": 1,
 +
            "address_pk": 346,
 +
            "client_pk": 464,
 +
            "client_status": 0,
 +
            "client_type": 0,
 +
             "client_username": "admin",
 +
            "client_password": "admin",
 +
            "client_name": "Teste1",
 +
            "client_lastname": "BrByte",
 +
            "client_mail": "softov@brbyte.com",
 +
            "client_doc1": "69120603070",
 +
            "client_doc2": "",
 +
            "client_date_cad": "2017-02-08 00:00:00",
 +
            "client_date_birth": "2017-02-08 00:00:00",
 +
             "client_complete_name": "Teste1 BrByte",
 +
            "offices_pk": 1,
 +
            "offices_identification": "Matriz",
 +
            "bank_account_pk": 1,
 +
            "bank_account_code": "756",
 +
            "bank_account_identification": "Sicoob Credivale",
 +
            "contract_layouts_pk": 1,
 +
            "client_phones": "Fixo#-#67981234276",
 +
            "cli_addr_address": "",
 +
            "cli_addr_number": "",
 +
            "cli_addr_neighborhood": "",
 +
            "cli_addr_zipcode": "",
 +
            "cli_addr_province": "Grão Pará",
 +
            "cli_addr_state": "SC",
 +
            "cli_addr_completation": "",
 +
            "ctt_addr_address": "",
 +
            "ctt_addr_number": "",
 +
            "ctt_addr_neighborhood": "",
 +
            "ctt_addr_zipcode": "",
 +
            "ctt_addr_province": "Grão Pará",
 +
            "ctt_addr_state": "SC",
 +
            "ctt_addr_completation": ""
 
         }
 
         }
 
     ]
 
     ]
Linha 91: Linha 151:
 
</pre></blockquote>
 
</pre></blockquote>
  
=='''Listagem do Contratos'''==
+
 
 +
==='''Listar Autenticação de CPE'''===
  
 
<div>
 
<div>
<span class="label label-info">POST</span> <span class="label label-concrete">/controllr_client/contract/list</span>
+
<span class="label label-info">POST</span> <span class="label label-concrete">/controllrctl/networkcpe/list</span>
 
</div>
 
</div>
  
Linha 101: Linha 162:
 
   curl -i -X POST \
 
   curl -i -X POST \
 
         -H "Content-Type:application/x-www-form-urlencoded" \
 
         -H "Content-Type:application/x-www-form-urlencoded" \
         -H "Accept:application/json" \
+
         -H "Accept:application/json" \
         -d "limit: 10" \
+
         -d "where: [{"field":"network_cpe_deleted","oper":7,"value":false},{"field":"AND"},{"field":"contract_item_status","oper":6,"value":1}]" \
 +
        -d "offices_pk: 0" \
 
         -d "start: 0" \
 
         -d "start: 0" \
         -d "sort: contract_pk" \
+
        -d "limit: 15" \
 +
         -d "sort: client_complete_name" \
 
         -d "dir: ASC" \
 
         -d "dir: ASC" \
      <nowiki>'http://192.168.142.23/controllr_client/contract/list'</nowiki>
+
        <nowiki>'http://192.168.144.10:8080/controllrctl/networkcpe/list'</nowiki>
  
 
</pre></blockquote>
 
</pre></blockquote>
Linha 116: Linha 179:
 
<blockquote class="blockquote-neutral"><pre>
 
<blockquote class="blockquote-neutral"><pre>
  
{
+
{
 
     "success": true,
 
     "success": true,
 
     "total": 1,
 
     "total": 1,
 
     "results": [
 
     "results": [
 
         {
 
         {
             "contract_pk": 3,
+
            "network_cpe_pk": 1,
             "contract_number": 3,
+
            "network_cpe_circuit_id": "",
 +
            "network_cpe_circuit_id_hex": null,
 +
            "network_cpe_longitude": "0",
 +
            "network_cpe_latitude": "0",
 +
            "network_cpe_automac": false,
 +
            "network_cpe_autoip": false,
 +
            "network_cpe_status": 0,
 +
            "network_cpe_ip": "",
 +
            "network_cpe_mac": "",
 +
            "network_cpe_username": "brbyte123",
 +
            "network_cpe_password": "brbyte123",
 +
            "network_cpe_fiber": 0,
 +
            "network_cpe_fiber_onu_mac": null,
 +
            "network_cpe_fiber_device_pk": null,
 +
            "network_cpe_fiber_old_id": null,
 +
            "network_cpe_authentication_type": 3,
 +
            "network_cpe_date_cad": "2019-05-08 16:23:41",
 +
            "network_cpe_deleted": false,
 +
            "network_cpe_commom_interface": null,
 +
            "network_cpe_commom_device_name": null,
 +
            "network_cpe_commom_lastip": null,
 +
            "network_cpe_commom_rates": null,
 +
            "network_cpe_commom_rx_rate": null,
 +
            "network_cpe_commom_tx_rate": null,
 +
            "network_cpe_commom_distance": null,
 +
            "network_cpe_commom_tx_ccq": null,
 +
            "network_cpe_commom_signal_rx": null,
 +
            "network_cpe_commom_signal_tx": null,
 +
            "network_cpe_commom_noisefloor": null,
 +
            "network_cpe_commom_idle": null,
 +
            "network_cpe_commom_tx_bytes": null,
 +
            "network_cpe_commom_rx_bytes": null,
 +
            "network_cpe_especdata": null,
 +
            "network_cpe_commom_rx_ccq": null,
 +
            "network_cpe_commom_ping": null,
 +
            "network_cpe_commom_uptime": null,
 +
            "network_cpe_lastupdate": null,
 +
            "suppliers_pk": null,
 +
            "network_devices_pk": 1,
 +
            "network_cpe_model_pk": null,
 +
            "radius_plans_pk": 1,
 +
             "contract_pk": 1,
 +
            "network_subnets_pk": 1,
 +
            "client_pk": 1,
 +
            "network_cpe_lending": 0,
 +
            "panel_pk": 1,
 +
            "network_cpe_mac_status": 2,
 +
            "network_cpe_ip_status": 2,
 +
            "network_cpe_reduced_speed": false,
 +
            "network_cpe_reduced_speed_date": null,
 +
            "network_cpe_control_pk": 0,
 +
            "network_cpe_turbo_active": false,
 +
            "network_cpe_ip_text": "",
 +
            "network_cpe_access_login": "",
 +
            "network_cpe_access_password": "",
 +
            "network_cpe_access_port": "22",
 +
            "network_cpe_wifi_encryption_type": 0,
 +
            "network_cpe_wifi_encryption_password": null,
 +
            "radius_plans_name": "Exemplo 10M",
 +
            "panel_name": "Painél Padrão",
 +
            "panel_client_limit": 0,
 +
            "network_devices_name": "Exemplo",
 +
            "network_devices_fiber_name": null,
 +
            "network_devices_vendor": 0,
 +
            "network_subnets_subnet": "10.255.255.0/24",
 +
            "network_subnets_pool_name": "Pool-Exemplo",
 +
            "network_cpe_model_name": null,
 +
            "address_pk": 1,
 +
             "contract_number": 1,
 +
            "contract_amount": "0",
 
             "contract_pay_day": 10,
 
             "contract_pay_day": 10,
             "contract_amount": "1",
+
             "contract_status": 0,
             "contract_date_cad": "2018-05-15 16:19:45"
+
            "contract_deleted": false,
 +
            "offices_pk": 1,
 +
            "client_name": "AAAAAAAA BrByte",
 +
            "client_lastname": "Exemplo",
 +
             "client_mail": null,
 +
            "client_doc2": "",
 +
            "client_doc1": "",
 +
            "client_status": 0,
 +
            "client_complete_name": "AAAAAAAA BrByte Exemplo",
 +
            "client_type": 0,
 +
            "contract_item_status": 0,
 +
            "contract_item_free": 0,
 +
            "contract_item_pk": 1,
 +
            "contract_item_type": 1,
 +
            "contract_item_deleted": false,
 +
            "contract_item_ref_pk": 1,
 +
            "suppliers_name": null,
 +
            "network_cpe_online": null,
 +
            "ctt_addr_address": "BrByte",
 +
            "ctt_addr_number": "",
 +
            "ctt_addr_neighborhood": "",
 +
            "ctt_addr_zipcode": "00000000",
 +
            "ctt_addr_province": "Campo Grande",
 +
            "ctt_addr_state": "MS",
 +
            "ctt_addr_completation": ""
 
         }
 
         }
 
     ]
 
     ]
}
+
}
  
 
</pre></blockquote>
 
</pre></blockquote>
  
=='''Listagem de Cobranças'''==
+
==='''Listar Planos de Acessos'''===
  
 
<div>
 
<div>
<span class="label label-info">POST</span> <span class="label label-concrete">/invoice_ctl/invoice/list</span>
+
<span class="label label-info">POST</span> <span class="label label-concrete">/controllrctl/plan/list</span>
 
</div>
 
</div>
  
Linha 142: Linha 298:
 
   curl -i -X POST \
 
   curl -i -X POST \
 
         -H "Content-Type:application/x-www-form-urlencoded" \
 
         -H "Content-Type:application/x-www-form-urlencoded" \
         -H "Accept:application/json" \
+
         -H "Accept:application/json" \ 
 +
        -d "where: [{"field":"radius_plans_deleted","oper":7,"value":false}]" \
 +
        -d "start: 0" \
 
         -d "limit: 15" \
 
         -d "limit: 15" \
        -d "start: 0" \
+
         -d "sort: radius_plans_name" \
        -d "page: 0" \
+
         -d "dir: ASC" \
         -d "sort: invoice_date_due" \
+
        <nowiki>'http://192.168.144.10:8080/controllrctl/plan/list'</nowiki>
         -d "dir: DESC" \
 
      <nowiki>'http://192.168.142.23/invoice_ctl/invoice/list'</nowiki>
 
  
 
</pre></blockquote>
 
</pre></blockquote>
Linha 158: Linha 314:
 
<blockquote class="blockquote-neutral"><pre>
 
<blockquote class="blockquote-neutral"><pre>
  
{
+
{
 
     "success": true,
 
     "success": true,
     "total": 2,
+
     "total": 1,
 
     "results": [
 
     "results": [
 
         {
 
         {
             "contract_pk": null,
+
             "radius_plans_pk": 1,
             "contract_number": null,
+
             "radius_plans_name": "Exemplo 10M",
             "invoice_pk": 11,
+
             "radius_plans_mikrotik_name": "exemplo-10",
             "bank_account_code": "0",
+
             "radius_plans_download_speed": 10240,
             "invoice_gn_link": null,
+
            "radius_plans_download_burst": 0,
             "invoice_date_due": "2018-05-11",
+
             "radius_plans_download_bursttime": 0,
             "invoice_amount_document": "15",
+
             "radius_plans_upload_speed": 5120,
             "invoice_date_credit": "2018-05-11",
+
            "radius_plans_upload_burst": 0,
             "invoice_amount_paid": "15.00",
+
             "radius_plans_upload_bursttime": 0,
             "invoice_type": 1,
+
            "radius_plans_priority": 8,
             "invoice_state": 0,
+
             "radius_plans_download_burstthreshold": 0,
             "invoice_obs": 4
+
            "radius_plans_upload_burstthreshold": 0,
        },
+
             "radius_plans_upload_limitat": 0,
        {
+
            "radius_plans_download_limitat": 0,
             "contract_pk": null,
+
             "radius_plans_reduction_download_speed": 5120,
             "contract_number": null,
+
             "radius_plans_reduction_upload_speed": 1024,
             "invoice_pk": 2,
+
             "radius_plans_amount": "20",
             "bank_account_code": "0",
+
             "radius_plans_deleted": false,
             "invoice_gn_link": null,
+
             "radius_plans_hotsite_active": 0,
             "invoice_date_due": "2018-05-09",
+
             "radius_plans_hotsite_featured": -1,
             "invoice_amount_document": "123",
+
             "radius_plans_franquia_limit_download": "0",
             "invoice_date_credit": "2018-05-14",
+
             "radius_plans_franquia_limit_type": 0,
             "invoice_amount_paid": "123.00",
+
             "radius_plans_franquia_limit_reduce_download": 0,
             "invoice_type": 1,
+
            "radius_plans_franquia_limit_reduce_upload": 0,
             "invoice_state": 0,
+
             "radius_plans_turbo_active": 0,
             "invoice_obs": 4
+
            "radius_plans_turbo_hour_start": null,
 +
             "radius_plans_turbo_hour_end": null,
 +
            "radius_plans_turbo_upload": -1,
 +
            "radius_plans_turbo_download": -1,
 +
             "radius_plans_hotsite_name": null,
 +
            "radius_plans_hotsite_description": null,
 +
             "radius_plans_addresslist_param": "",
 +
             "offices_pk": 1,
 +
             "total_referenced_cpe": 1
 
         }
 
         }
 
     ]
 
     ]
}
+
}
  
 
</pre></blockquote>
 
</pre></blockquote>
  
=='''Listagem de Conexões'''==
+
==='''Listar Suporte Técnico'''===
  
 
<div>
 
<div>
<span class="label label-info">POST</span> <span class="label label-concrete">/controllr_client/cpe/list</span>
+
<span class="label label-info">POST</span> <span class="label label-concrete">/controllrctl/support/list</span>
 
</div>
 
</div>
  
Linha 205: Linha 369:
 
   curl -i -X POST \
 
   curl -i -X POST \
 
         -H "Content-Type:application/x-www-form-urlencoded" \
 
         -H "Content-Type:application/x-www-form-urlencoded" \
         -H "Accept:application/json" \
+
         -H "Accept:application/json" \ 
 +
        -d "where: [{"field":"support_done","oper":5,"value":0},{"field":"AND"},{"field":"support_deleted","oper":7,"value":false}]" \
 +
        -d "start: 0" \
 
         -d "limit: 15" \
 
         -d "limit: 15" \
        -d "start: 0" \
+
         -d "sort: support_priority" \
        -d "page: 0" \
 
         -d "sort: contract_pk" \
 
 
         -d "dir: DESC" \
 
         -d "dir: DESC" \
      <nowiki>'http://192.168.142.23/controllr_client/cpe/list'</nowiki>
+
        <nowiki>'http://192.168.144.10:8080/controllrctl/support/list'</nowiki>
  
 
</pre></blockquote>
 
</pre></blockquote>
Linha 221: Linha 385:
 
<blockquote class="blockquote-neutral"><pre>
 
<blockquote class="blockquote-neutral"><pre>
  
{
+
{
 
     "success": true,
 
     "success": true,
 
     "total": 1,
 
     "total": 1,
 
     "results": [
 
     "results": [
 
         {
 
         {
             "network_cpe_pk": 2,
+
             "support_pk": 1,
             "network_cpe_automac": false,
+
             "support_protocol": "201905091811259",
            "network_cpe_autoip": false,
+
             "support_phone": null,
             "network_cpe_status": 0,
+
             "support_problem_desc": "",
            "network_cpe_ip": "",
+
             "support_obs": "",
            "network_cpe_mac": "",
+
             "support_date_signup": "2019-05-09 18:11:25.912607",
            "network_cpe_mac_status": 2,
+
             "support_date_done": null,
            "network_cpe_ip_status": 2,
+
             "support_status": null,
             "network_cpe_username": "123",
+
             "support_deleted": false,
             "network_cpe_password": "123",
+
             "staff_pk": 1,
            "network_cpe_authentication_type": 3,
+
             "support_priority": 0,
             "network_cpe_date_cad": "2018-05-15 16:20:34",
+
             "support_amount": null,
            "network_cpe_deleted": false,
+
             "support_created_invoice_date": null,
            "network_cpe_commom_interface": null,
+
             "support_done": 0,
            "network_cpe_commom_device_name": null,
+
             "support_create_type": 0,
            "network_cpe_commom_lastip": null,
 
            "network_cpe_commom_rates": null,
 
            "network_cpe_commom_rx_rate": null,
 
            "network_cpe_commom_tx_rate": null,
 
            "network_cpe_commom_distance": null,
 
            "network_cpe_commom_tx_ccq": null,
 
            "network_cpe_commom_signal_rx": null,
 
            "network_cpe_commom_signal_tx": null,
 
            "network_cpe_commom_noisefloor": null,
 
            "network_cpe_commom_idle": null,
 
            "network_cpe_commom_tx_bytes": null,
 
            "network_cpe_commom_rx_bytes": null,
 
            "network_cpe_especdata": null,
 
            "network_cpe_commom_rx_ccq": null,
 
             "network_cpe_commom_ping": null,
 
             "network_cpe_commom_uptime": null,
 
             "network_cpe_lending": 0,
 
            "network_cpe_lastupdate": null,
 
            "network_cpe_reduced_speed": false,
 
             "network_cpe_reduced_speed_date": null,
 
            "network_cpe_turbo_active": false,
 
             "network_cpe_wifi_encryption_type": 0,
 
             "network_cpe_wifi_encryption_password": null,
 
             "network_cpe_access_login": "",
 
            "network_cpe_access_password": "",
 
            "network_cpe_access_port": "22",
 
            "network_cpe_longitude": "0",
 
            "network_cpe_latitude": "0",
 
            "network_cpe_circuit_id": "",
 
            "network_cpe_circuit_id_hex": null,
 
             "network_cpe_fiber": 0,
 
             "network_cpe_fiber_onu_mac": null,
 
            "network_cpe_fiber_device_pk": null,
 
            "network_cpe_fiber_onu_pppoe_svc_name": null,
 
            "network_cpe_req_origin": 0,
 
            "suppliers_pk": null,
 
            "network_devices_pk": 3,
 
            "network_cpe_model_pk": null,
 
            "radius_plans_pk": 1,
 
            "contract_pk": 3,
 
            "network_subnets_pk": 1,
 
 
             "client_pk": 1,
 
             "client_pk": 1,
             "panel_pk": 1,
+
             "contract_pk": 1,
             "network_cpe_control_pk": 0
+
             "client_status": 0,
 +
            "client_date_cad": "2018-08-01 00:00:00",
 +
            "client_date_birth": "2018-01-01 00:00:00",
 +
            "client_date_deactivation": null,
 +
            "client_name": "AAAAAAAA BrByte",
 +
            "client_lastname": "Exemplo",
 +
            "client_complete_name": "AAAAAAAA BrByte Exemplo",
 +
            "client_observations": "",
 +
            "client_username": "brbyte123",
 +
            "client_password": "brbyte123",
 +
            "client_type": 0,
 +
            "client_doc1": "",
 +
            "client_doc2": "",
 +
            "client_mail": null,
 +
            "client_passtext": null,
 +
            "group_pk": 1,
 +
            "offices_pk": 1,
 +
            "staff_name": "Fulano de Tal",
 +
            "cli_addr_address": "BrByte",
 +
            "cli_addr_number": "",
 +
            "cli_addr_neighborhood": "",
 +
            "cli_addr_zipcode": "00000000",
 +
            "cli_addr_province": "Campo Grande",
 +
            "cli_addr_state": "MS",
 +
            "cli_addr_completation": "",
 +
            "ctt_addr_address": "BrByte",
 +
            "ctt_addr_number": "",
 +
            "ctt_addr_neighborhood": "",
 +
            "ctt_addr_zipcode": "00000000",
 +
            "ctt_addr_province": "Campo Grande",
 +
            "ctt_addr_state": "MS",
 +
            "ctt_addr_completation": "",
 +
            "time_open": "4.40573543333333"
 
         }
 
         }
 
     ]
 
     ]
}
+
}
  
 
</pre></blockquote>
 
</pre></blockquote>
  
=='''Listagem de Suportes'''==
+
==='''Listar Ordem de Serviço'''===
  
 
<div>
 
<div>
<span class="label label-info">POST</span> <span class="label label-concrete">/controllr_client/support/list</span>
+
<span class="label label-info">POST</span> <span class="label label-concrete">/controllrctl/service_order/list</span>
 
</div>
 
</div>
  
Linha 301: Linha 456:
 
   curl -i -X POST \
 
   curl -i -X POST \
 
         -H "Content-Type:application/x-www-form-urlencoded" \
 
         -H "Content-Type:application/x-www-form-urlencoded" \
         -H "Accept:application/json" \
+
         -H "Accept:application/json" \
         -d "limit: 10" \
+
         -d "where: [{"field":"os_done","oper":5,"value":0},{"field":"AND"},{"field":"os_deleted","oper":7,"value":false},{"field":"AND"},{"field":"support_deleted","oper":7,"value":false}]" \
 
         -d "start: 0" \
 
         -d "start: 0" \
         -d "page: 0" \
+
         -d "limit: 15" \
         -d "sort: os_date_entry" \
+
         -d "sort: os_date_sched" \
         -d "dir: ASC" \
+
         -d "dir: DESC" \
      <nowiki>'http://192.168.142.23/controllr_client/support/list'</nowiki>
+
        <nowiki>'http://192.168.144.10:8080/controllrctl/service_order/list'</nowiki>
  
 
</pre></blockquote>
 
</pre></blockquote>
Linha 317: Linha 472:
 
<blockquote class="blockquote-neutral"><pre>
 
<blockquote class="blockquote-neutral"><pre>
  
{
+
{
 
     "success": true,
 
     "success": true,
 
     "total": 1,
 
     "total": 1,
 
     "results": [
 
     "results": [
 
         {
 
         {
             "support_protocol": "2018051515386",
+
             "os_pk": 1,
             "os_obs": "Sua descrição",
+
            "os_obs": "",
             "os_date_entry": "2018-05-15 15:38:45",
+
             "os_desc": "",
 +
             "os_date_entry": "2019-05-09 18:12:32.322203",
 
             "os_date_soluction": null,
 
             "os_date_soluction": null,
             "os_date_sched": "2018-05-15 15:38:45",
+
             "os_date_sched": "2019-05-09 17:12:24",
 
             "os_done": 0,
 
             "os_done": 0,
 +
            "os_deleted": false,
 +
            "os_date_close": null,
 +
            "os_date_last": null,
 
             "os_amount": null,
 
             "os_amount": null,
             "task_name": "Viabilidade",
+
            "staff_pk": 1,
             "task_desc": "Teste de viabilidade técnica para instalação de internet"
+
            "task_pk": 2,
 +
            "os_create_type": 0,
 +
            "support_pk": 1,
 +
            "support_protocol": "201905091811259",
 +
            "support_phone": null,
 +
            "support_problem_desc": "",
 +
            "support_obs": "",
 +
            "support_date_signup": "2019-05-09 18:11:25.912607",
 +
            "support_date_done": null,
 +
            "support_status": null,
 +
            "support_deleted": false,
 +
            "support_priority": 0,
 +
            "support_amount": null,
 +
            "support_created_invoice_date": null,
 +
            "support_done": 0,
 +
            "support_create_type": 0,
 +
            "client_pk": 1,
 +
            "contract_pk": 1,
 +
            "staff_name": "Fulano de Tal",
 +
            "staff_cpf": "",
 +
            "staff_rg": "",
 +
            "staff_rg_orgexp": "",
 +
            "staff_mother_name": "",
 +
            "staff_father_name": "",
 +
            "staff_nationality": "",
 +
            "staff_spouse": null,
 +
            "staff_mail": "",
 +
            "staff_phone": "",
 +
            "staff_mobile": "",
 +
            "staff_cep": "",
 +
            "staff_address": "",
 +
            "staff_number": "",
 +
            "staff_completion": "",
 +
            "staff_neighborhood": "",
 +
            "staff_province": "",
 +
            "staff_state": "",
 +
            "staff_signupdate": null,
 +
            "staff_observations": "",
 +
            "staff_username": null,
 +
            "staff_password": null,
 +
            "staff_type": null,
 +
            "staff_contact": null,
 +
            "staff_maturity": null,
 +
            "staff_birthdate": "2019-05-09",
 +
            "staff_status": null,
 +
            "staff_deleted": false,
 +
            "staff_admission_date": "2019-05-09",
 +
            "staff_number_wallet": "",
 +
            "staff_ocupation": "",
 +
            "staff_income": "-1",
 +
            "staff_mk_access_enabled": 0,
 +
            "staff_mk_access_subnet": null,
 +
            "staff_mk_access_login": null,
 +
            "staff_mk_access_password": null,
 +
            "staff_mk_access_groupname": null,
 +
            "staff_mk_access_ontimes": "",
 +
            "staff_agent_username": null,
 +
            "staff_agent_password": "12345678",
 +
            "staff_agent_enabled": 1,
 +
            "client_status": 0,
 +
            "client_date_cad": "2018-08-01 00:00:00",
 +
            "client_date_birth": "2018-01-01 00:00:00",
 +
            "client_date_deactivation": null,
 +
            "client_name": "AAAAAAAA BrByte",
 +
            "client_lastname": "Exemplo",
 +
            "client_complete_name": "AAAAAAAA BrByte Exemplo",
 +
            "client_observations": "",
 +
            "client_username": "brbyte123",
 +
            "client_password": "brbyte123",
 +
            "client_type": 0,
 +
            "client_doc1": "",
 +
            "client_doc2": "",
 +
            "client_mail": null,
 +
            "client_passtext": null,
 +
            "group_pk": 1,
 +
            "offices_pk": 1,
 +
             "task_name": "Instalação",
 +
             "cli_addr_address": "BrByte",
 +
            "cli_addr_number": "",
 +
            "cli_addr_neighborhood": "",
 +
            "cli_addr_zipcode": "00000000",
 +
            "cli_addr_province": "Campo Grande",
 +
            "cli_addr_state": "MS",
 +
            "cli_addr_completation": "",
 +
            "ctt_addr_address": "BrByte",
 +
            "ctt_addr_number": "",
 +
            "ctt_addr_neighborhood": "",
 +
            "ctt_addr_zipcode": "00000000",
 +
            "ctt_addr_province": "Campo Grande",
 +
            "ctt_addr_state": "MS",
 +
            "ctt_addr_completation": ""
 
         }
 
         }
 
     ]
 
     ]
}
+
}
  
 
</pre></blockquote>
 
</pre></blockquote>
  
=='''Criação de Suporte Técnico'''==
+
==='''Listar Tarefas da Ordem de Serviço'''===
  
 
<div>
 
<div>
<span class="label label-info">POST</span> <span class="label label-concrete">/controllr_client/support/create</span>
+
<span class="label label-info">POST</span> <span class="label label-concrete">/controllrctl/os_task/list</span>
 
</div>
 
</div>
  
Linha 347: Linha 596:
 
   curl -i -X POST \
 
   curl -i -X POST \
 
         -H "Content-Type:application/x-www-form-urlencoded" \
 
         -H "Content-Type:application/x-www-form-urlencoded" \
         -H "Accept:application/json" \
+
         -H "Accept:application/json" \
         -d "priority: 0" \
+
         -d "start: 0" \
         -d "task_pk: 1" \
+
         -d "limit: 15" \
         -d "phone: 67998083499" \
+
         -d "sort: task_name" \
         -d "os_obs: Sua Descrição" \
+
         -d "dir: ASC" \
      <nowiki>'http://192.168.142.23/controllr_client/support/create'</nowiki>
+
        <nowiki>'http://192.168.144.10:8080/controllrctl/os_task/list'</nowiki>
  
 
</pre></blockquote>
 
</pre></blockquote>
Linha 362: Linha 611:
 
<blockquote class="blockquote-neutral"><pre>
 
<blockquote class="blockquote-neutral"><pre>
  
{
+
{
 
     "success": true,
 
     "success": true,
     "total": 1,
+
     "total": 6,
 
     "results": [
 
     "results": [
 
         {
 
         {
             "os_pk": -1,
+
             "task_pk": 1,
             "os_obs": "1.12337081805556",
+
             "task_name": "Viabilidade",
             "os_desc": null,
+
             "task_desc": "Teste de viabilidade técnica para instalação de internet",
            "os_date_entry": null,
+
             "task_text": "<h3 style=\"color: rgb(0, 0, 0); font-family: tahoma, arial, verdana, sans-serif; font-size: 12px;\"> Ordem de Serviço Nº: ....,
             "os_date_soluction": null,
+
             "task_amount": null,
            "os_date_sched": null,
+
             "task_site_active": 1,
            "os_done": null,
+
             "task_ivr_active": 1,
            "os_deleted": null,
+
             "task_active": 1
            "os_amount": null,
 
             "staff_pk": null,
 
             "task_pk": null,
 
             "os_create_type": null,
 
             "support_pk": null
 
 
         }
 
         }
 
     ]
 
     ]
}
+
}
 +
 
  
 
</pre></blockquote>
 
</pre></blockquote>
  
=='''Listagem de Tarefas do Suporte Técnico'''==
+
 
 +
==='''Listar Cobranças'''===
  
 
<div>
 
<div>
<span class="label label-info">POST</span> <span class="label label-concrete">/controllr_client/support/tasklist</span>
+
<span class="label label-info">POST</span> <span class="label label-concrete">/invoice_ctl/invoice/list</span>
 
</div>
 
</div>
  
Linha 396: Linha 642:
 
   curl -i -X POST \
 
   curl -i -X POST \
 
         -H "Content-Type:application/x-www-form-urlencoded" \
 
         -H "Content-Type:application/x-www-form-urlencoded" \
         -H "Accept:application/json" \
+
         -H "Accept:application/json" \ 
         -d "sort: task_name" \
+
        -d "where: [{"field":"invoice_deleted","oper":7,"value":false},{"field":"AND"},{"field":"client.client_pk","oper":5,"value":1},{"field":"AND"},[{"field":"invoice_date_due","oper":4,"value":"2000-01-01T03:00:00.000Z"},{"field":"AND"},{"field":"invoice_date_due","oper":3,"value":"2021-05-31T04:00:00.000Z"}]]" \       
         -d "dir: ASC" \
+
        -d "start: 0" \
    <nowiki>'http://192.168.142.23/controllr_client/support/tasklist'</nowiki>
+
        -d "limit: 15" \
 +
         -d "sort: invoice_date_due" \
 +
         -d "dir: DESC" \
 +
        <nowiki>'http://192.168.144.10:8080/invoice_ctl/invoice/list'</nowiki>
  
 
</pre></blockquote>
 
</pre></blockquote>
Linha 409: Linha 658:
 
<blockquote class="blockquote-neutral"><pre>
 
<blockquote class="blockquote-neutral"><pre>
  
{
+
{
 
     "success": true,
 
     "success": true,
     "total": 6,
+
     "total": 3,
 
     "results": [
 
     "results": [
 
         {
 
         {
             "task_pk": 5,
+
             "contract_pk": 1,
             "task_name": "Desinstalação"
+
            "invoice_pk": 2,
        },
+
            "invoice_document_number": "0000015",
        {
+
            "invoice_amount_document": "20",
             "task_pk": 8,
+
            "invoice_amount_paid": null,
             "task_name": "Desinstalação Equipamento"
+
            "invoice_payment_method": null,
        },
+
            "invoice_payment_cmc7": null,
        {
+
            "invoice_nosso_num": "000000000000001",
             "task_pk": 2,
+
            "invoice_date_due": "2019-05-10",
             "task_name": "Instalação"
+
            "invoice_date_document": "2019-05-10",
        },
+
            "invoice_date_occurrence": null,
        {
+
            "invoice_date_credit": null,
             "task_pk": 3,
+
            "invoice_rate_fine": null,
             "task_name": "Suporte Técnico"
+
            "invoice_rate_interest": null,
        },
+
            "invoice_discount_due_amount": "0",
        {
+
            "invoice_remittance_status": 0,
             "task_pk": 4,
+
            "invoice_msg": null,
             "task_name": "Troca de Equipamento"
+
            "invoice_valid": false,
        },
+
            "invoice_tax": false,
        {
+
            "invoice_nf_emitted": false,
             "task_pk": 1,
+
            "invoice_mail_sent": false,
             "task_name": "Viabilidade"
+
            "invoice_mail_sent_date": null,
 +
            "invoice_type": 0,
 +
             "client_pk": 1,
 +
            "invoice_nf_date_emitted": null,
 +
            "invoice_tax_date": null,
 +
            "invoice_parcel": false,
 +
            "invoice_proportional": false,
 +
            "invoice_deleted": false,
 +
            "invoice_parcel_qntd": null,
 +
            "invoice_client_view": null,
 +
            "invoice_cielo_tid": null,
 +
            "invoice_payment_type": 0,
 +
            "invoice_gn_key": null,
 +
            "invoice_gn_return": null,
 +
            "invoice_gn_link": null,
 +
            "invoice_gn_carne_lote": null,
 +
            "invoice_gn_error": null,
 +
            "invoice_gn_error_description": null,
 +
            "invoice_gn_carne_parcel": null,
 +
            "invoice_schedule_status": 0,
 +
             "invoice_tax_pis_pasep": "0",
 +
             "invoice_tax_cofins": "0",
 +
            "invoice_gn_charge_id": null,
 +
            "invoice_gn_reply_code": 0,
 +
            "invoice_amount_nf": "20",
 +
             "invoice_barcode": "00090.00001 00000.000000 00000.001016 2 78850000002000",
 +
            "invoice_remittance_date_emission": null,
 +
            "invoice_receipt_mail_sent_date": null,
 +
            "bank_account_code": "0",
 +
            "bank_account_pk": 1,
 +
            "client_status": 0,
 +
            "client_date_cad": "2018-08-01 00:00:00",
 +
            "client_date_birth": "2018-01-01 00:00:00",
 +
            "client_date_deactivation": null,
 +
            "client_name": "AAAAAAAA BrByte",
 +
            "client_lastname": "Exemplo",
 +
            "client_complete_name": "AAAAAAAA BrByte Exemplo",
 +
            "client_observations": "",
 +
            "client_username": "brbyte123",
 +
            "client_password": "brbyte123",
 +
            "client_type": 0,
 +
            "client_doc1": "",
 +
            "client_doc2": "",
 +
            "client_mail": null,
 +
            "client_passtext": null,
 +
            "group_pk": 1,
 +
            "offices_pk": 1,
 +
            "contract_number": 1,
 +
            "contract_pay_day": 10,
 +
            "contract_free": 0,
 +
            "contract_amount": "20",
 +
            "contract_pay_discount": "0.00",
 +
            "contract_date_cad": "2018-08-01 00:00:00",
 +
            "contract_status": 0,
 +
            "contract_deleted": false,
 +
            "contract_observations": "",
 +
            "contract_block_type": 1,
 +
            "contract_date_last_paymentobservation": null,
 +
            "contract_tax_cfop": 0,
 +
            "contract_tax_icms": "0.00",
 +
            "contract_tax_ibpt": "0.00",
 +
            "contract_send_invoice_post_office": 0,
 +
            "contract_block_auto": 1,
 +
            "contract_layouts_pk": 1,
 +
            "address_pk": 1,
 +
            "bank_account_identification": "Banco do Provedor",
 +
            "bank_account_transferor": null,
 +
            "bank_account_localpayment": "Pagar apenas no escritório do provedor",
 +
            "bank_account_gateway_username": null,
 +
            "bank_account_gateway_password": null,
 +
            "bank_account_gateway_token": null,
 +
            "bank_account_agency": null,
 +
            "bank_account_layout": null,
 +
            "bank_account_modalidade": null,
 +
            "bank_account_agency_dv": null,
 +
            "bank_account_account": null,
 +
            "bank_account_account_dv": null,
 +
            "bank_account_wallet_sicredi": null,
 +
            "bank_account_wallet_itau": null,
 +
            "bank_account_wallet_ailos": null,
 +
            "bank_account_wallet_caixa": null,
 +
            "bank_account_wallet_sicoob": null,
 +
            "bank_account_wallet_bradesco": null,
 +
            "bank_account_wallet_santander": null,
 +
            "bank_account_wallet_bb": null,
 +
            "bank_account_wallet_1": null,
 +
            "bank_account_wallet_2": null,
 +
            "bank_account_wallet_3": null,
 +
             "bank_account_wallet_variation": "019",
 +
            "bank_account_client_paid_rate": 0,
 +
            "bank_account_aceite": null,
 +
            "bank_account_transferor_code": null,
 +
            "bank_account_especie_doc": null,
 +
            "bank_account_extra_param1": null,
 +
            "bank_account_extra_param2": null,
 +
            "bank_account_extra_param3": null,
 +
            "bank_account_extra_param4": null,
 +
            "bank_account_extra_param5": null,
 +
            "bank_account_num_convenio": null,
 +
            "bank_account_num_convenio_dv": "0",
 +
            "bank_account_instructions1": "Sr. Caixa, cobrar juros de {TAXA_JUROS} ao dia e multa de {TAXA_MULTA} após {DATA_VENCIMENTO}",
 +
            "bank_account_instructions2": "Receber até 30 dias após o vencimento",
 +
            "bank_account_instructions3": "Em caso de duvidas entre em contato conosco: 11 3333-4444",
 +
            "bank_account_instructions4": null,
 +
            "bank_account_demonstrative1": "{DETALHES_TITULO}",
 +
             "bank_account_demonstrative2": "",
 +
            "bank_account_demonstrative3": "",
 +
            "bank_account_deleted": false,
 +
            "bank_account_default": 1,
 +
            "bank_account_active": 1,
 +
            "bank_account_send_invoice_mail": 0,
 +
            "bank_account_batchfile_number": 0,
 +
            "bank_account_registered_billet": 0,
 +
            "bank_account_send_invoice_post_office": false,
 +
            "bank_account_type": 0,
 +
            "bank_account_authenticate": 0,
 +
            "bank_account_capture": 1,
 +
            "bank_account_payment_type": 0,
 +
            "bank_account_cielo_checkout": 0,
 +
            "bank_type": 0,
 +
            "bank_account_notification_url": null,
 +
            "bank_account_nosso_num": 3,
 +
             "address_identification": "BrByte",
 +
            "address": "BrByte",
 +
            "address_number": "",
 +
            "address_neighborhood": "",
 +
            "address_siafi": 9051,
 +
             "address_province": "Campo Grande",
 +
             "address_state": "MS",
 +
            "address_zipcode": "00000000",
 +
            "address_completation": "",
 +
             "address_default": 1,
 +
             "client_phones": "Padrão#-#00000000000",
 +
            "invoice_date_now": "2019-05-10",
 +
            "obs_pk": null,
 +
            "cli_addr_address": "BrByte",
 +
            "cli_addr_number": "",
 +
            "cli_addr_neighborhood": "",
 +
            "cli_addr_zipcode": "00000000",
 +
            "cli_addr_province": "Campo Grande",
 +
            "cli_addr_state": "MS",
 +
            "cli_addr_completation": "",
 +
            "ctt_addr_address": "BrByte",
 +
            "ctt_addr_number": "",
 +
            "ctt_addr_neighborhood": "",
 +
            "ctt_addr_zipcode": "00000000",
 +
            "ctt_addr_province": "Campo Grande",
 +
            "ctt_addr_state": "MS",
 +
            "ctt_addr_completation": "",
 +
            "contract_items": null
 
         }
 
         }
     ]
+
     ],
}
+
    "config": {
 +
        "rate_fine": 0,
 +
        "rate_interest": 0,
 +
        "rate_interest_str": ""
 +
    }
 +
}
 +
 
  
 
</pre></blockquote>
 
</pre></blockquote>
 +
 +
  
  
 
__NOEDITSECTION__
 
__NOEDITSECTION__
 +
[[Category:Controllr]]
 +
[[Category:API]]
 +
[[Category:REST-HTTP]]

Edição atual tal como às 09h49min de 28 de fevereiro de 2023

Listar os Clientes

POST /controllrctl/client/list


  curl -i -X POST \
        -H "Content-Type:application/x-www-form-urlencoded" \
        -H "Accept:application/json" \  
        -d "where: [{"field":"client_status","oper":5,"value":0}]" \
        -d "start: 0" \
        -d "limit: 15" \
        -d "sort: client_complete_name" \
        -d "dir: ASC" \
        'http://192.168.144.10:8080/controllrctl/client/list'  

Resposta JSON

 
{
    "success": true,
    "total": 493,
    "results": [
        {
            "client_pk": 430,
            "client_status": 3,
            "client_type": 0,
            "client_username": "",
            "client_password": "",
            "client_name": "teste",
            "client_lastname": "brbyte",
            "client_mail": "",
            "client_doc1": "",
            "client_doc2": "",
            "client_date_cad": "2016-09-20 00:00:00",
            "client_date_deactivation": null,
            "client_date_birth": "2016-09-20 00:00:00",
            "client_observations": "",
            "offices_pk": 1,
            "offices_identification": "Matriz",
            "client_complete_name": "teste brbyte",
            "client_phones": null,
            "cli_addr_address": "Rua Oscar Ferreira Bugre",
            "cli_addr_number": "88",
            "cli_addr_neighborhood": "Vila Nasser",
            "cli_addr_zipcode": "79.117-101",
            "cli_addr_province": "Campo Grande",
            "cli_addr_state": "MS",
            "cli_addr_completation": ""
        }
    ]
}

Listar os Contratos

POST /controllrctl/contract/list


  curl -i -X POST \
        -H "Content-Type:application/x-www-form-urlencoded" \
        -H "Accept:application/json" \  
        -d "where: [{"field":"contract_deleted","oper":5,"value":false},{"field":"AND"},{"field":"contract_status","oper":5,"value":0}]" \
        -d "client_complete_name:" \
        -d "offices_pk: 0" \
        -d "start: 0" \
        -d "limit: 15" \
        -d "sort: contract_number" \
        -d "dir: ASC" \
        'http://192.168.144.10:8080/controllrctl/contract/list'  

Resposta JSON


{
    "success": true,
    "total": 1,
    "results": [
        {
            "contract_pk": 466,
            "contract_number": 464,
            "contract_pay_day": 10,
            "contract_free": 0,
            "contract_amount": "45.00",
            "contract_pay_discount": null,
            "contract_date_cad": "2017-02-08 18:30:11",
            "contract_status": 0,
            "contract_deleted": false,
            "contract_observations": "",
            "contract_block_type": 0,
            "contract_date_last_paymentobservation": null,
            "contract_tax_cfop": 5307,
            "contract_tax_icms": "1.25",
            "contract_tax_ibpt": "13.45",
            "contract_block_auto": 1,
            "address_pk": 346,
            "client_pk": 464,
            "client_status": 0,
            "client_type": 0,
            "client_username": "admin",
            "client_password": "admin",
            "client_name": "Teste1",
            "client_lastname": "BrByte",
            "client_mail": "softov@brbyte.com",
            "client_doc1": "69120603070",
            "client_doc2": "",
            "client_date_cad": "2017-02-08 00:00:00",
            "client_date_birth": "2017-02-08 00:00:00",
            "client_complete_name": "Teste1 BrByte",
            "offices_pk": 1,
            "offices_identification": "Matriz",
            "bank_account_pk": 1,
            "bank_account_code": "756",
            "bank_account_identification": "Sicoob Credivale",
            "contract_layouts_pk": 1,
            "client_phones": "Fixo#-#67981234276",
            "cli_addr_address": "",
            "cli_addr_number": "",
            "cli_addr_neighborhood": "",
            "cli_addr_zipcode": "",
            "cli_addr_province": "Grão Pará",
            "cli_addr_state": "SC",
            "cli_addr_completation": "",
            "ctt_addr_address": "",
            "ctt_addr_number": "",
            "ctt_addr_neighborhood": "",
            "ctt_addr_zipcode": "",
            "ctt_addr_province": "Grão Pará",
            "ctt_addr_state": "SC",
            "ctt_addr_completation": ""
        }
    ]
}


Listar Autenticação de CPE

POST /controllrctl/networkcpe/list


  curl -i -X POST \
        -H "Content-Type:application/x-www-form-urlencoded" \
        -H "Accept:application/json" \  
        -d "where: [{"field":"network_cpe_deleted","oper":7,"value":false},{"field":"AND"},{"field":"contract_item_status","oper":6,"value":1}]" \
        -d "offices_pk: 0" \
        -d "start: 0" \
        -d "limit: 15" \
        -d "sort: client_complete_name" \
        -d "dir: ASC" \
        'http://192.168.144.10:8080/controllrctl/networkcpe/list'  

Resposta JSON


{
    "success": true,
    "total": 1,
    "results": [
        {
            "network_cpe_pk": 1,
            "network_cpe_circuit_id": "",
            "network_cpe_circuit_id_hex": null,
            "network_cpe_longitude": "0",
            "network_cpe_latitude": "0",
            "network_cpe_automac": false,
            "network_cpe_autoip": false,
            "network_cpe_status": 0,
            "network_cpe_ip": "",
            "network_cpe_mac": "",
            "network_cpe_username": "brbyte123",
            "network_cpe_password": "brbyte123",
            "network_cpe_fiber": 0,
            "network_cpe_fiber_onu_mac": null,
            "network_cpe_fiber_device_pk": null,
            "network_cpe_fiber_old_id": null,
            "network_cpe_authentication_type": 3,
            "network_cpe_date_cad": "2019-05-08 16:23:41",
            "network_cpe_deleted": false,
            "network_cpe_commom_interface": null,
            "network_cpe_commom_device_name": null,
            "network_cpe_commom_lastip": null,
            "network_cpe_commom_rates": null,
            "network_cpe_commom_rx_rate": null,
            "network_cpe_commom_tx_rate": null,
            "network_cpe_commom_distance": null,
            "network_cpe_commom_tx_ccq": null,
            "network_cpe_commom_signal_rx": null,
            "network_cpe_commom_signal_tx": null,
            "network_cpe_commom_noisefloor": null,
            "network_cpe_commom_idle": null,
            "network_cpe_commom_tx_bytes": null,
            "network_cpe_commom_rx_bytes": null,
            "network_cpe_especdata": null,
            "network_cpe_commom_rx_ccq": null,
            "network_cpe_commom_ping": null,
            "network_cpe_commom_uptime": null,
            "network_cpe_lastupdate": null,
            "suppliers_pk": null,
            "network_devices_pk": 1,
            "network_cpe_model_pk": null,
            "radius_plans_pk": 1,
            "contract_pk": 1,
            "network_subnets_pk": 1,
            "client_pk": 1,
            "network_cpe_lending": 0,
            "panel_pk": 1,
            "network_cpe_mac_status": 2,
            "network_cpe_ip_status": 2,
            "network_cpe_reduced_speed": false,
            "network_cpe_reduced_speed_date": null,
            "network_cpe_control_pk": 0,
            "network_cpe_turbo_active": false,
            "network_cpe_ip_text": "",
            "network_cpe_access_login": "",
            "network_cpe_access_password": "",
            "network_cpe_access_port": "22",
            "network_cpe_wifi_encryption_type": 0,
            "network_cpe_wifi_encryption_password": null,
            "radius_plans_name": "Exemplo 10M",
            "panel_name": "Painél Padrão",
            "panel_client_limit": 0,
            "network_devices_name": "Exemplo",
            "network_devices_fiber_name": null,
            "network_devices_vendor": 0,
            "network_subnets_subnet": "10.255.255.0/24",
            "network_subnets_pool_name": "Pool-Exemplo",
            "network_cpe_model_name": null,
            "address_pk": 1,
            "contract_number": 1,
            "contract_amount": "0",
            "contract_pay_day": 10,
            "contract_status": 0,
            "contract_deleted": false,
            "offices_pk": 1,
            "client_name": "AAAAAAAA BrByte",
            "client_lastname": "Exemplo",
            "client_mail": null,
            "client_doc2": "",
            "client_doc1": "",
            "client_status": 0,
            "client_complete_name": "AAAAAAAA BrByte Exemplo",
            "client_type": 0,
            "contract_item_status": 0,
            "contract_item_free": 0,
            "contract_item_pk": 1,
            "contract_item_type": 1,
            "contract_item_deleted": false,
            "contract_item_ref_pk": 1,
            "suppliers_name": null,
            "network_cpe_online": null,
            "ctt_addr_address": "BrByte",
            "ctt_addr_number": "",
            "ctt_addr_neighborhood": "",
            "ctt_addr_zipcode": "00000000",
            "ctt_addr_province": "Campo Grande",
            "ctt_addr_state": "MS",
            "ctt_addr_completation": ""
        }
    ]
}

Listar Planos de Acessos

POST /controllrctl/plan/list


  curl -i -X POST \
        -H "Content-Type:application/x-www-form-urlencoded" \
        -H "Accept:application/json" \  
        -d "where: [{"field":"radius_plans_deleted","oper":7,"value":false}]" \
        -d "start: 0" \
        -d "limit: 15" \
        -d "sort: radius_plans_name" \
        -d "dir: ASC" \
        'http://192.168.144.10:8080/controllrctl/plan/list'  

Resposta JSON


{
    "success": true,
    "total": 1,
    "results": [
        {
            "radius_plans_pk": 1,
            "radius_plans_name": "Exemplo 10M",
            "radius_plans_mikrotik_name": "exemplo-10",
            "radius_plans_download_speed": 10240,
            "radius_plans_download_burst": 0,
            "radius_plans_download_bursttime": 0,
            "radius_plans_upload_speed": 5120,
            "radius_plans_upload_burst": 0,
            "radius_plans_upload_bursttime": 0,
            "radius_plans_priority": 8,
            "radius_plans_download_burstthreshold": 0,
            "radius_plans_upload_burstthreshold": 0,
            "radius_plans_upload_limitat": 0,
            "radius_plans_download_limitat": 0,
            "radius_plans_reduction_download_speed": 5120,
            "radius_plans_reduction_upload_speed": 1024,
            "radius_plans_amount": "20",
            "radius_plans_deleted": false,
            "radius_plans_hotsite_active": 0,
            "radius_plans_hotsite_featured": -1,
            "radius_plans_franquia_limit_download": "0",
            "radius_plans_franquia_limit_type": 0,
            "radius_plans_franquia_limit_reduce_download": 0,
            "radius_plans_franquia_limit_reduce_upload": 0,
            "radius_plans_turbo_active": 0,
            "radius_plans_turbo_hour_start": null,
            "radius_plans_turbo_hour_end": null,
            "radius_plans_turbo_upload": -1,
            "radius_plans_turbo_download": -1,
            "radius_plans_hotsite_name": null,
            "radius_plans_hotsite_description": null,
            "radius_plans_addresslist_param": "",
            "offices_pk": 1,
            "total_referenced_cpe": 1
        }
    ]
}

Listar Suporte Técnico

POST /controllrctl/support/list


  curl -i -X POST \
        -H "Content-Type:application/x-www-form-urlencoded" \
        -H "Accept:application/json" \  
        -d "where: [{"field":"support_done","oper":5,"value":0},{"field":"AND"},{"field":"support_deleted","oper":7,"value":false}]" \
        -d "start: 0" \
        -d "limit: 15" \
        -d "sort: support_priority" \
        -d "dir: DESC" \
        'http://192.168.144.10:8080/controllrctl/support/list'  

Resposta JSON


{
    "success": true,
    "total": 1,
    "results": [
        {
            "support_pk": 1,
            "support_protocol": "201905091811259",
            "support_phone": null,
            "support_problem_desc": "",
            "support_obs": "",
            "support_date_signup": "2019-05-09 18:11:25.912607",
            "support_date_done": null,
            "support_status": null,
            "support_deleted": false,
            "staff_pk": 1,
            "support_priority": 0,
            "support_amount": null,
            "support_created_invoice_date": null,
            "support_done": 0,
            "support_create_type": 0,
            "client_pk": 1,
            "contract_pk": 1,
            "client_status": 0,
            "client_date_cad": "2018-08-01 00:00:00",
            "client_date_birth": "2018-01-01 00:00:00",
            "client_date_deactivation": null,
            "client_name": "AAAAAAAA BrByte",
            "client_lastname": "Exemplo",
            "client_complete_name": "AAAAAAAA BrByte Exemplo",
            "client_observations": "",
            "client_username": "brbyte123",
            "client_password": "brbyte123",
            "client_type": 0,
            "client_doc1": "",
            "client_doc2": "",
            "client_mail": null,
            "client_passtext": null,
            "group_pk": 1,
            "offices_pk": 1,
            "staff_name": "Fulano de Tal",
            "cli_addr_address": "BrByte",
            "cli_addr_number": "",
            "cli_addr_neighborhood": "",
            "cli_addr_zipcode": "00000000",
            "cli_addr_province": "Campo Grande",
            "cli_addr_state": "MS",
            "cli_addr_completation": "",
            "ctt_addr_address": "BrByte",
            "ctt_addr_number": "",
            "ctt_addr_neighborhood": "",
            "ctt_addr_zipcode": "00000000",
            "ctt_addr_province": "Campo Grande",
            "ctt_addr_state": "MS",
            "ctt_addr_completation": "",
            "time_open": "4.40573543333333"
        }
    ]
}

Listar Ordem de Serviço

POST /controllrctl/service_order/list


  curl -i -X POST \
        -H "Content-Type:application/x-www-form-urlencoded" \
        -H "Accept:application/json" \  
        -d "where: [{"field":"os_done","oper":5,"value":0},{"field":"AND"},{"field":"os_deleted","oper":7,"value":false},{"field":"AND"},{"field":"support_deleted","oper":7,"value":false}]" \
        -d "start: 0" \
        -d "limit: 15" \
        -d "sort: os_date_sched" \
        -d "dir: DESC" \
        'http://192.168.144.10:8080/controllrctl/service_order/list'  

Resposta JSON


{
    "success": true,
    "total": 1,
    "results": [
        {
            "os_pk": 1,
            "os_obs": "",
            "os_desc": "",
            "os_date_entry": "2019-05-09 18:12:32.322203",
            "os_date_soluction": null,
            "os_date_sched": "2019-05-09 17:12:24",
            "os_done": 0,
            "os_deleted": false,
            "os_date_close": null,
            "os_date_last": null,
            "os_amount": null,
            "staff_pk": 1,
            "task_pk": 2,
            "os_create_type": 0,
            "support_pk": 1,
            "support_protocol": "201905091811259",
            "support_phone": null,
            "support_problem_desc": "",
            "support_obs": "",
            "support_date_signup": "2019-05-09 18:11:25.912607",
            "support_date_done": null,
            "support_status": null,
            "support_deleted": false,
            "support_priority": 0,
            "support_amount": null,
            "support_created_invoice_date": null,
            "support_done": 0,
            "support_create_type": 0,
            "client_pk": 1,
            "contract_pk": 1,
            "staff_name": "Fulano de Tal",
            "staff_cpf": "",
            "staff_rg": "",
            "staff_rg_orgexp": "",
            "staff_mother_name": "",
            "staff_father_name": "",
            "staff_nationality": "",
            "staff_spouse": null,
            "staff_mail": "",
            "staff_phone": "",
            "staff_mobile": "",
            "staff_cep": "",
            "staff_address": "",
            "staff_number": "",
            "staff_completion": "",
            "staff_neighborhood": "",
            "staff_province": "",
            "staff_state": "",
            "staff_signupdate": null,
            "staff_observations": "",
            "staff_username": null,
            "staff_password": null,
            "staff_type": null,
            "staff_contact": null,
            "staff_maturity": null,
            "staff_birthdate": "2019-05-09",
            "staff_status": null,
            "staff_deleted": false,
            "staff_admission_date": "2019-05-09",
            "staff_number_wallet": "",
            "staff_ocupation": "",
            "staff_income": "-1",
            "staff_mk_access_enabled": 0,
            "staff_mk_access_subnet": null,
            "staff_mk_access_login": null,
            "staff_mk_access_password": null,
            "staff_mk_access_groupname": null,
            "staff_mk_access_ontimes": "",
            "staff_agent_username": null,
            "staff_agent_password": "12345678",
            "staff_agent_enabled": 1,
            "client_status": 0,
            "client_date_cad": "2018-08-01 00:00:00",
            "client_date_birth": "2018-01-01 00:00:00",
            "client_date_deactivation": null,
            "client_name": "AAAAAAAA BrByte",
            "client_lastname": "Exemplo",
            "client_complete_name": "AAAAAAAA BrByte Exemplo",
            "client_observations": "",
            "client_username": "brbyte123",
            "client_password": "brbyte123",
            "client_type": 0,
            "client_doc1": "",
            "client_doc2": "",
            "client_mail": null,
            "client_passtext": null,
            "group_pk": 1,
            "offices_pk": 1,
            "task_name": "Instalação",
            "cli_addr_address": "BrByte",
            "cli_addr_number": "",
            "cli_addr_neighborhood": "",
            "cli_addr_zipcode": "00000000",
            "cli_addr_province": "Campo Grande",
            "cli_addr_state": "MS",
            "cli_addr_completation": "",
            "ctt_addr_address": "BrByte",
            "ctt_addr_number": "",
            "ctt_addr_neighborhood": "",
            "ctt_addr_zipcode": "00000000",
            "ctt_addr_province": "Campo Grande",
            "ctt_addr_state": "MS",
            "ctt_addr_completation": ""
        }
    ]
}

Listar Tarefas da Ordem de Serviço

POST /controllrctl/os_task/list


  curl -i -X POST \
        -H "Content-Type:application/x-www-form-urlencoded" \
        -H "Accept:application/json" \  
        -d "start: 0" \
        -d "limit: 15" \
        -d "sort: task_name" \
        -d "dir: ASC" \
        'http://192.168.144.10:8080/controllrctl/os_task/list'  

Resposta JSON


{
    "success": true,
    "total": 6,
    "results": [
        {
            "task_pk": 1,
            "task_name": "Viabilidade",
            "task_desc": "Teste de viabilidade técnica para instalação de internet",
            "task_text": "<h3 style=\"color: rgb(0, 0, 0); font-family: tahoma, arial, verdana, sans-serif; font-size: 12px;\"> Ordem de Serviço Nº: ....,
            "task_amount": null,
            "task_site_active": 1,
            "task_ivr_active": 1,
            "task_active": 1
        }
    ]
}



Listar Cobranças

POST /invoice_ctl/invoice/list


  curl -i -X POST \
        -H "Content-Type:application/x-www-form-urlencoded" \
        -H "Accept:application/json" \  
        -d "where: [{"field":"invoice_deleted","oper":7,"value":false},{"field":"AND"},{"field":"client.client_pk","oper":5,"value":1},{"field":"AND"},[{"field":"invoice_date_due","oper":4,"value":"2000-01-01T03:00:00.000Z"},{"field":"AND"},{"field":"invoice_date_due","oper":3,"value":"2021-05-31T04:00:00.000Z"}]]" \        
        -d "start: 0" \
        -d "limit: 15" \
        -d "sort: invoice_date_due" \
        -d "dir: DESC" \
        'http://192.168.144.10:8080/invoice_ctl/invoice/list'  

Resposta JSON


{
    "success": true,
    "total": 3,
    "results": [
        {
            "contract_pk": 1,
            "invoice_pk": 2,
            "invoice_document_number": "0000015",
            "invoice_amount_document": "20",
            "invoice_amount_paid": null,
            "invoice_payment_method": null,
            "invoice_payment_cmc7": null,
            "invoice_nosso_num": "000000000000001",
            "invoice_date_due": "2019-05-10",
            "invoice_date_document": "2019-05-10",
            "invoice_date_occurrence": null,
            "invoice_date_credit": null,
            "invoice_rate_fine": null,
            "invoice_rate_interest": null,
            "invoice_discount_due_amount": "0",
            "invoice_remittance_status": 0,
            "invoice_msg": null,
            "invoice_valid": false,
            "invoice_tax": false,
            "invoice_nf_emitted": false,
            "invoice_mail_sent": false,
            "invoice_mail_sent_date": null,
            "invoice_type": 0,
            "client_pk": 1,
            "invoice_nf_date_emitted": null,
            "invoice_tax_date": null,
            "invoice_parcel": false,
            "invoice_proportional": false,
            "invoice_deleted": false,
            "invoice_parcel_qntd": null,
            "invoice_client_view": null,
            "invoice_cielo_tid": null,
            "invoice_payment_type": 0,
            "invoice_gn_key": null,
            "invoice_gn_return": null,
            "invoice_gn_link": null,
            "invoice_gn_carne_lote": null,
            "invoice_gn_error": null,
            "invoice_gn_error_description": null,
            "invoice_gn_carne_parcel": null,
            "invoice_schedule_status": 0,
            "invoice_tax_pis_pasep": "0",
            "invoice_tax_cofins": "0",
            "invoice_gn_charge_id": null,
            "invoice_gn_reply_code": 0,
            "invoice_amount_nf": "20",
            "invoice_barcode": "00090.00001 00000.000000 00000.001016 2 78850000002000",
            "invoice_remittance_date_emission": null,
            "invoice_receipt_mail_sent_date": null,
            "bank_account_code": "0",
            "bank_account_pk": 1,
            "client_status": 0,
            "client_date_cad": "2018-08-01 00:00:00",
            "client_date_birth": "2018-01-01 00:00:00",
            "client_date_deactivation": null,
            "client_name": "AAAAAAAA BrByte",
            "client_lastname": "Exemplo",
            "client_complete_name": "AAAAAAAA BrByte Exemplo",
            "client_observations": "",
            "client_username": "brbyte123",
            "client_password": "brbyte123",
            "client_type": 0,
            "client_doc1": "",
            "client_doc2": "",
            "client_mail": null,
            "client_passtext": null,
            "group_pk": 1,
            "offices_pk": 1,
            "contract_number": 1,
            "contract_pay_day": 10,
            "contract_free": 0,
            "contract_amount": "20",
            "contract_pay_discount": "0.00",
            "contract_date_cad": "2018-08-01 00:00:00",
            "contract_status": 0,
            "contract_deleted": false,
            "contract_observations": "",
            "contract_block_type": 1,
            "contract_date_last_paymentobservation": null,
            "contract_tax_cfop": 0,
            "contract_tax_icms": "0.00",
            "contract_tax_ibpt": "0.00",
            "contract_send_invoice_post_office": 0,
            "contract_block_auto": 1,
            "contract_layouts_pk": 1,
            "address_pk": 1,
            "bank_account_identification": "Banco do Provedor",
            "bank_account_transferor": null,
            "bank_account_localpayment": "Pagar apenas no escritório do provedor",
            "bank_account_gateway_username": null,
            "bank_account_gateway_password": null,
            "bank_account_gateway_token": null,
            "bank_account_agency": null,
            "bank_account_layout": null,
            "bank_account_modalidade": null,
            "bank_account_agency_dv": null,
            "bank_account_account": null,
            "bank_account_account_dv": null,
            "bank_account_wallet_sicredi": null,
            "bank_account_wallet_itau": null,
            "bank_account_wallet_ailos": null,
            "bank_account_wallet_caixa": null,
            "bank_account_wallet_sicoob": null,
            "bank_account_wallet_bradesco": null,
            "bank_account_wallet_santander": null,
            "bank_account_wallet_bb": null,
            "bank_account_wallet_1": null,
            "bank_account_wallet_2": null,
            "bank_account_wallet_3": null,
            "bank_account_wallet_variation": "019",
            "bank_account_client_paid_rate": 0,
            "bank_account_aceite": null,
            "bank_account_transferor_code": null,
            "bank_account_especie_doc": null,
            "bank_account_extra_param1": null,
            "bank_account_extra_param2": null,
            "bank_account_extra_param3": null,
            "bank_account_extra_param4": null,
            "bank_account_extra_param5": null,
            "bank_account_num_convenio": null,
            "bank_account_num_convenio_dv": "0",
            "bank_account_instructions1": "Sr. Caixa, cobrar juros de {TAXA_JUROS} ao dia e multa de {TAXA_MULTA} após {DATA_VENCIMENTO}",
            "bank_account_instructions2": "Receber até 30 dias após o vencimento",
            "bank_account_instructions3": "Em caso de duvidas entre em contato conosco: 11 3333-4444",
            "bank_account_instructions4": null,
            "bank_account_demonstrative1": "{DETALHES_TITULO}",
            "bank_account_demonstrative2": "",
            "bank_account_demonstrative3": "",
            "bank_account_deleted": false,
            "bank_account_default": 1,
            "bank_account_active": 1,
            "bank_account_send_invoice_mail": 0,
            "bank_account_batchfile_number": 0,
            "bank_account_registered_billet": 0,
            "bank_account_send_invoice_post_office": false,
            "bank_account_type": 0,
            "bank_account_authenticate": 0,
            "bank_account_capture": 1,
            "bank_account_payment_type": 0,
            "bank_account_cielo_checkout": 0,
            "bank_type": 0,
            "bank_account_notification_url": null,
            "bank_account_nosso_num": 3,
            "address_identification": "BrByte",
            "address": "BrByte",
            "address_number": "",
            "address_neighborhood": "",
            "address_siafi": 9051,
            "address_province": "Campo Grande",
            "address_state": "MS",
            "address_zipcode": "00000000",
            "address_completation": "",
            "address_default": 1,
            "client_phones": "Padrão#-#00000000000",
            "invoice_date_now": "2019-05-10",
            "obs_pk": null,
            "cli_addr_address": "BrByte",
            "cli_addr_number": "",
            "cli_addr_neighborhood": "",
            "cli_addr_zipcode": "00000000",
            "cli_addr_province": "Campo Grande",
            "cli_addr_state": "MS",
            "cli_addr_completation": "",
            "ctt_addr_address": "BrByte",
            "ctt_addr_number": "",
            "ctt_addr_neighborhood": "",
            "ctt_addr_zipcode": "00000000",
            "ctt_addr_province": "Campo Grande",
            "ctt_addr_state": "MS",
            "ctt_addr_completation": "",
            "contract_items": null
        }
    ],
    "config": {
        "rate_fine": 0,
        "rate_interest": 0,
        "rate_interest_str": ""
    }
}