API Plataforma de rastreabilidade e investimento circular. API Reference
Plataforma de rastreabilidade e investimento circular, requer autenticação via auth0.
API Endpoints
Desenvolvimento:
https://api-ancat.us1-newyork-03.hallentech.com/
Produção:
https://api-ancat.us1-newyork-03.hallentech.com/
Version: 1.0.0
Cooperativas Localização
Localizações das cooperativas com base na latitude e longitude
Sincronizar Localizações
Sincronizar as localizações das novas cooperativas ou cooperativas no qual ainda não tem latitude e longitude preenchidas no banco de dados
Example
Request Content-Types:
application/json
Query
query organizationsLocationSync{
organizationsLocationSync
}
Try it now
query organizationsLocationSync{
organizationsLocationSync
}
Successful operation
Response Content-Types: application/json
Response Example (200 OK)
{
"data": {
"organizationsLocationSync": "boolean"
}
}
Listar Cooperativas com Localizações
Lista todas as cooperativas com localizações(latitude e longitude), podendo filtrar de acordo com a categoria e volume mínimo dessa categoria informada. Obs. O filtro é baseado na última apuração da cooperativa
(no description)
(no description)
(no description)
(no description)
Example
Request Content-Types:
application/json
Query
query organizationsLocations($Pagination: PaginationInputType, $OrderBy: OrderByInputType, $amount: Float, $category: Float){
organizationsLocations(Pagination: $Pagination, OrderBy: $OrderBy, amount: $amount, category: $category){
id
name
national_id
web
phone
email
owner
address{
city
state
street
zipcode
neighborhood
complementary
street_number
}
state
city
type
nucleus
nucleus_name
nucleus_code
nucleus_owner
owner_name
member_male
member_female
projects
latitude
longitude
}
}
Variables
{
"Pagination": {
"take": "number",
"skip": "number"
},
"OrderBy": {
"fieldName": "string",
"direction": "string"
},
"amount": "number",
"category": "number"
}
Try it now
query organizationsLocations($Pagination: PaginationInputType, $OrderBy: OrderByInputType, $amount: Float, $category: Float){
organizationsLocations(Pagination: $Pagination, OrderBy: $OrderBy, amount: $amount, category: $category){
id
name
national_id
web
phone
email
owner
address{
city
state
street
zipcode
neighborhood
complementary
street_number
}
state
city
type
nucleus
nucleus_name
nucleus_code
nucleus_owner
owner_name
member_male
member_female
projects
latitude
longitude
}
}
{
"Pagination": {
"take": "number",
"skip": "number"
},
"OrderBy": {
"fieldName": "string",
"direction": "string"
},
"amount": "number",
"category": "number"
}
Successful operation
Response Content-Types: application/json
Response Example (200 OK)
{
"data": {
"organizationsLocations": [
{
"id": "string",
"name": "string",
"national_id": "string",
"web": "string",
"phone": "string",
"email": "string",
"owner": "string",
"address": {
"city": "string",
"state": "string",
"street": "string",
"zipcode": "string",
"neighborhood": "string",
"complementary": "string",
"street_number": "string"
},
"state": "string",
"city": "string",
"type": "number",
"nucleus": "number",
"nucleus_name": "string",
"nucleus_code": "number",
"nucleus_owner": "number",
"owner_name": "string",
"member_male": "number",
"member_female": "number",
"projects": "string",
"latitude": "number",
"longitude": "number"
}
]
}
}
Cooperativas
Referente aos dados das cooperativas cadastradas
Listar cooperativas
Lista todas as cooperativas
(no description)
(no description)
Example
Request Content-Types:
application/json
Query
query organizations($Pagination: PaginationInputType, $OrderBy: OrderByInputType){
organizations(Pagination: $Pagination, OrderBy: $OrderBy){
id
name
national_id
web
phone
email
owner
address{
city
state
street
zipcode
neighborhood
complementary
street_number
}
state
city
type
nucleus
nucleus_name
nucleus_code
nucleus_owner
owner_name
member_male
member_female
projects
latitude
longitude
}
}
Variables
{
"Pagination": {
"take": "number",
"skip": "number"
},
"OrderBy": {
"fieldName": "string",
"direction": "string"
}
}
Try it now
query organizations($Pagination: PaginationInputType, $OrderBy: OrderByInputType){
organizations(Pagination: $Pagination, OrderBy: $OrderBy){
id
name
national_id
web
phone
email
owner
address{
city
state
street
zipcode
neighborhood
complementary
street_number
}
state
city
type
nucleus
nucleus_name
nucleus_code
nucleus_owner
owner_name
member_male
member_female
projects
latitude
longitude
}
}
{
"Pagination": {
"take": "number",
"skip": "number"
},
"OrderBy": {
"fieldName": "string",
"direction": "string"
}
}
Successful operation
Response Content-Types: application/json
Response Example (200 OK)
{
"data": {
"organizations": [
{
"id": "string",
"name": "string",
"national_id": "string",
"web": "string",
"phone": "string",
"email": "string",
"owner": "string",
"address": {
"city": "string",
"state": "string",
"street": "string",
"zipcode": "string",
"neighborhood": "string",
"complementary": "string",
"street_number": "string"
},
"state": "string",
"city": "string",
"type": "number",
"nucleus": "number",
"nucleus_name": "string",
"nucleus_code": "number",
"nucleus_owner": "number",
"owner_name": "string",
"member_male": "number",
"member_female": "number",
"projects": "string",
"latitude": "number",
"longitude": "number"
}
]
}
}
Listar Cooperativa por ID
Busca a cooperativa pelo Id informado
(no description)
Example
Request Content-Types:
application/json
Query
query organizationById($id: Float!){
organizationById(id: $id){
id
name
national_id
web
phone
email
owner
address{
city
state
street
zipcode
neighborhood
complementary
street_number
}
state
city
type
nucleus
nucleus_name
nucleus_code
nucleus_owner
owner_name
member_male
member_female
projects
latitude
longitude
}
}
Variables
{
"id": "number"
}
Try it now
query organizationById($id: Float!){
organizationById(id: $id){
id
name
national_id
web
phone
email
owner
address{
city
state
street
zipcode
neighborhood
complementary
street_number
}
state
city
type
nucleus
nucleus_name
nucleus_code
nucleus_owner
owner_name
member_male
member_female
projects
latitude
longitude
}
}
{
"id": "number"
}
Successful operation
Response Content-Types: application/json
Response Example (200 OK)
{
"data": {
"organizationById": {
"id": "string",
"name": "string",
"national_id": "string",
"web": "string",
"phone": "string",
"email": "string",
"owner": "string",
"address": {
"city": "string",
"state": "string",
"street": "string",
"zipcode": "string",
"neighborhood": "string",
"complementary": "string",
"street_number": "string"
},
"state": "string",
"city": "string",
"type": "number",
"nucleus": "number",
"nucleus_name": "string",
"nucleus_code": "number",
"nucleus_owner": "number",
"owner_name": "string",
"member_male": "number",
"member_female": "number",
"projects": "string",
"latitude": "number",
"longitude": "number"
}
}
}
Listar Cooperativa por Estado e Cidade
Lista todas as cooperativas de um determinado estado ou cidade.
(no description)
(no description)
(no description)
(no description)
Example
Request Content-Types:
application/json
Query
query organizationByCityOrState($Pagination: PaginationInputType, $OrderBy: OrderByInputType, $city: String, $state: String!){
organizationByCityOrState(Pagination: $Pagination, OrderBy: $OrderBy, city: $city, state: $state){
id
name
national_id
web
phone
email
owner
address{
city
state
street
zipcode
neighborhood
complementary
street_number
}
state
city
type
nucleus
nucleus_name
nucleus_code
nucleus_owner
owner_name
member_male
member_female
projects
latitude
longitude
}
}
Variables
{
"Pagination": {
"take": "number",
"skip": "number"
},
"OrderBy": {
"fieldName": "string",
"direction": "string"
},
"city": "string",
"state": "string"
}
Try it now
query organizationByCityOrState($Pagination: PaginationInputType, $OrderBy: OrderByInputType, $city: String, $state: String!){
organizationByCityOrState(Pagination: $Pagination, OrderBy: $OrderBy, city: $city, state: $state){
id
name
national_id
web
phone
email
owner
address{
city
state
street
zipcode
neighborhood
complementary
street_number
}
state
city
type
nucleus
nucleus_name
nucleus_code
nucleus_owner
owner_name
member_male
member_female
projects
latitude
longitude
}
}
{
"Pagination": {
"take": "number",
"skip": "number"
},
"OrderBy": {
"fieldName": "string",
"direction": "string"
},
"city": "string",
"state": "string"
}
Successful operation
Response Content-Types: application/json
Response Example (200 OK)
{
"data": {
"organizationByCityOrState": [
{
"id": "string",
"name": "string",
"national_id": "string",
"web": "string",
"phone": "string",
"email": "string",
"owner": "string",
"address": {
"city": "string",
"state": "string",
"street": "string",
"zipcode": "string",
"neighborhood": "string",
"complementary": "string",
"street_number": "string"
},
"state": "string",
"city": "string",
"type": "number",
"nucleus": "number",
"nucleus_name": "string",
"nucleus_code": "number",
"nucleus_owner": "number",
"owner_name": "string",
"member_male": "number",
"member_female": "number",
"projects": "string",
"latitude": "number",
"longitude": "number"
}
]
}
}
Categorias
Categorias
Listar Categorias
Listar todas as categorias
(no description)
(no description)
Example
Request Content-Types:
application/json
Query
query categories($Pagination: PaginationInputType, $OrderBy: OrderByInputType){
categories(Pagination: $Pagination, OrderBy: $OrderBy){
id
name
color
lock
}
}
Variables
{
"Pagination": {
"take": "number",
"skip": "number"
},
"OrderBy": {
"fieldName": "string",
"direction": "string"
}
}
Try it now
query categories($Pagination: PaginationInputType, $OrderBy: OrderByInputType){
categories(Pagination: $Pagination, OrderBy: $OrderBy){
id
name
color
lock
}
}
{
"Pagination": {
"take": "number",
"skip": "number"
},
"OrderBy": {
"fieldName": "string",
"direction": "string"
}
}
Successful operation
Response Content-Types: application/json
Response Example (200 OK)
{
"data": {
"categories": [
{
"id": "string",
"name": "string",
"color": "string",
"lock": "boolean"
}
]
}
}
Listar Categoria por ID
Listar Categoria Po ID
(no description)
Example
Request Content-Types:
application/json
Query
query categoryById($id: Float!){
categoryById(id: $id){
id
name
color
lock
}
}
Variables
{
"id": "number"
}
Try it now
query categoryById($id: Float!){
categoryById(id: $id){
id
name
color
lock
}
}
{
"id": "number"
}
Successful operation
Response Content-Types: application/json
Response Example (200 OK)
{
"data": {
"categoryById": {
"id": "string",
"name": "string",
"color": "string",
"lock": "boolean"
}
}
}
Cookies
Listar Cookies
Materiais
Materiais
Listar Materiais
Listar todos os materiais
(no description)
(no description)
Example
Request Content-Types:
application/json
Query
query materials($Pagination: PaginationInputType, $OrderBy: OrderByInputType){
materials(Pagination: $Pagination, OrderBy: $OrderBy){
id
name
category
category_name
min
max
unit
ckv
}
}
Variables
{
"Pagination": {
"take": "number",
"skip": "number"
},
"OrderBy": {
"fieldName": "string",
"direction": "string"
}
}
Try it now
query materials($Pagination: PaginationInputType, $OrderBy: OrderByInputType){
materials(Pagination: $Pagination, OrderBy: $OrderBy){
id
name
category
category_name
min
max
unit
ckv
}
}
{
"Pagination": {
"take": "number",
"skip": "number"
},
"OrderBy": {
"fieldName": "string",
"direction": "string"
}
}
Successful operation
Response Content-Types: application/json
Response Example (200 OK)
{
"data": {
"materials": [
{
"id": "string",
"name": "string",
"category": "number",
"category_name": "string",
"min": "number",
"max": "number",
"unit": "boolean",
"ckv": "number"
}
]
}
}
Material por ID
Listar material por ID
(no description)
Example
Request Content-Types:
application/json
Query
query materialById($id: Float!){
materialById(id: $id){
id
name
category
category_name
min
max
unit
ckv
}
}
Variables
{
"id": "number"
}
Try it now
query materialById($id: Float!){
materialById(id: $id){
id
name
category
category_name
min
max
unit
ckv
}
}
{
"id": "number"
}
Successful operation
Response Content-Types: application/json
Response Example (200 OK)
{
"data": {
"materialById": {
"id": "string",
"name": "string",
"category": "number",
"category_name": "string",
"min": "number",
"max": "number",
"unit": "boolean",
"ckv": "number"
}
}
}
Materiais Por Categoria
Listar todos os materiais de determinada categoria
(no description)
Example
Request Content-Types:
application/json
Query
query materialByCategoryId($categoryId: Float!){
materialByCategoryId(categoryId: $categoryId){
id
name
category
category_name
min
max
unit
ckv
}
}
Variables
{
"categoryId": "number"
}
Try it now
query materialByCategoryId($categoryId: Float!){
materialByCategoryId(categoryId: $categoryId){
id
name
category
category_name
min
max
unit
ckv
}
}
{
"categoryId": "number"
}
Successful operation
Response Content-Types: application/json
Response Example (200 OK)
{
"data": {
"materialByCategoryId": [
{
"id": "string",
"name": "string",
"category": "number",
"category_name": "string",
"min": "number",
"max": "number",
"unit": "boolean",
"ckv": "number"
}
]
}
}
Apurações das saídas
Informações sobre as apurações feita nas cooperativas. Ex. Faturamento, Quantidade de total, preços e etc.
Apuração por cooperativa
Lista todas as informações de saída de uma cooperativa em um determinado mês do ano.
(no description)
(no description)
(no description)
Example
Request Content-Types:
application/json
Query
query outingsByOrgId($month: Float!, $year: Float!, $orgId: Float!){
outingsByOrgId(month: $month, year: $year, orgId: $orgId){
id
qty
ckv
value
total
attachment
buyer
buyer_name
report
material
material_name
category
category_name
unit
project
project_name
month
year
org_id
org_national_id
org_name
org_city
org_state
org_address
org_web
org_phone
org_email
nucleus_name
submission_date
status
reference_date
}
}
Variables
{
"month": "number",
"year": "number",
"orgId": "number"
}
Try it now
query outingsByOrgId($month: Float!, $year: Float!, $orgId: Float!){
outingsByOrgId(month: $month, year: $year, orgId: $orgId){
id
qty
ckv
value
total
attachment
buyer
buyer_name
report
material
material_name
category
category_name
unit
project
project_name
month
year
org_id
org_national_id
org_name
org_city
org_state
org_address
org_web
org_phone
org_email
nucleus_name
submission_date
status
reference_date
}
}
{
"month": "number",
"year": "number",
"orgId": "number"
}
Successful operation
Response Content-Types: application/json
Response Example (200 OK)
{
"data": {
"outingsByOrgId": [
{
"id": "string",
"qty": "number",
"ckv": "number",
"value": "number",
"total": "number",
"attachment": "string",
"buyer": "number",
"buyer_name": "string",
"report": "number",
"material": "number",
"material_name": "string",
"category": "number",
"category_name": "string",
"unit": "boolean",
"project": "string",
"project_name": "string",
"month": "number",
"year": "number",
"org_id": "number",
"org_national_id": "string",
"org_name": "string",
"org_city": "string",
"org_state": "string",
"org_address": "string",
"org_web": "string",
"org_phone": "string",
"org_email": "string",
"nucleus_name": "string",
"status": "boolean"
}
]
}
}
Apuração com valor total por cooperativas
Listar o valor total do faturamento e da quantidade de determina cooperativa no mês especificado
(no description)
(no description)
Example
Request Content-Types:
application/json
Query
query outingsTotalMonthWithOrg($month: Float!, $year: Float!){
outingsTotalMonthWithOrg(month: $month, year: $year){
org_id
org_name
org_city
org_state
org_owner_name
nucleus_name
total_qty
total_value
}
}
Variables
{
"month": "number",
"year": "number"
}
Try it now
query outingsTotalMonthWithOrg($month: Float!, $year: Float!){
outingsTotalMonthWithOrg(month: $month, year: $year){
org_id
org_name
org_city
org_state
org_owner_name
nucleus_name
total_qty
total_value
}
}
{
"month": "number",
"year": "number"
}
Successful operation
Response Content-Types: application/json
Response Example (200 OK)
{
"data": {
"outingsTotalMonthWithOrg": [
{
"org_id": "number",
"org_name": "string",
"org_city": "string",
"org_state": "string",
"org_owner_name": "string",
"nucleus_name": "string",
"total_qty": "number",
"total_value": "number"
}
]
}
}
Top cooperativas com maior quantidade por estado
Listar as 5 cooperativas que teve os maiores volumes de saídas de materiais em determinado mês do ano.
(no description)
(no description)
(no description)
Example
Request Content-Types:
application/json
Query
query outingsTopOrgByStateWithMostQty($state: String!, $month: Float!, $year: Float!){
outingsTopOrgByStateWithMostQty(state: $state, month: $month, year: $year){
org_id
org_name
org_city
org_state
org_email
total_qty
total_value
}
}
Variables
{
"state": "string",
"month": "number",
"year": "number"
}
Try it now
query outingsTopOrgByStateWithMostQty($state: String!, $month: Float!, $year: Float!){
outingsTopOrgByStateWithMostQty(state: $state, month: $month, year: $year){
org_id
org_name
org_city
org_state
org_email
total_qty
total_value
}
}
{
"state": "string",
"month": "number",
"year": "number"
}
Successful operation
Response Content-Types: application/json
Response Example (200 OK)
{
"data": {
"outingsTopOrgByStateWithMostQty": [
{
"org_id": "number",
"org_name": "string",
"org_city": "string",
"org_state": "string",
"org_email": "string",
"total_qty": "number",
"total_value": "number"
}
]
}
}
Top cooperativas com maior faturamento por estado
Listar as 5 cooperativas que teve os maiores faturamentos de saída de materiais em determinado mês do ano.
(no description)
(no description)
(no description)
Example
Request Content-Types:
application/json
Query
query outingsTopOrgByStateWithMostValue($state: String!, $month: Float!, $year: Float!){
outingsTopOrgByStateWithMostValue(state: $state, month: $month, year: $year){
org_id
org_name
org_city
org_state
org_email
total_qty
total_value
}
}
Variables
{
"state": "string",
"month": "number",
"year": "number"
}
Try it now
query outingsTopOrgByStateWithMostValue($state: String!, $month: Float!, $year: Float!){
outingsTopOrgByStateWithMostValue(state: $state, month: $month, year: $year){
org_id
org_name
org_city
org_state
org_email
total_qty
total_value
}
}
{
"state": "string",
"month": "number",
"year": "number"
}
Successful operation
Response Content-Types: application/json
Response Example (200 OK)
{
"data": {
"outingsTopOrgByStateWithMostValue": [
{
"org_id": "number",
"org_name": "string",
"org_city": "string",
"org_state": "string",
"org_email": "string",
"total_qty": "number",
"total_value": "number"
}
]
}
}
Últimas apurações por cooperativas
Listar as 5 últimas apurações de uma determinada cooperativa, sendo que somente a primeira delas trás os valores com o percentual da diferença total e faturamento com o mês anterior
(no description)
Example
Request Content-Types:
application/json
Query
query outingsLastValueByOrg($orgId: Float!){
outingsLastValueByOrg(orgId: $orgId){
org_id
org_name
org_phone
org_email
total_value
diff_value
total_qty
diff_qty
month
year
reference_date
}
}
Variables
{
"orgId": "number"
}
Try it now
query outingsLastValueByOrg($orgId: Float!){
outingsLastValueByOrg(orgId: $orgId){
org_id
org_name
org_phone
org_email
total_value
diff_value
total_qty
diff_qty
month
year
reference_date
}
}
{
"orgId": "number"
}
Successful operation
Response Content-Types: application/json
Response Example (200 OK)
{
"data": {
"outingsLastValueByOrg": [
{
"org_id": "number",
"org_name": "string",
"org_phone": "string",
"org_email": "string",
"total_value": "number",
"diff_value": "number",
"total_qty": "number",
"diff_qty": "number",
"month": "number",
"year": "number"
}
]
}
}
Apuração da categoria por cooperativa
Listar a apuração de cada categoria de acordo com a cooperativa selecionada em determinado mês e ano, informando também o percentual da diferença sobre o mês anterior
(no description)
(no description)
(no description)
Example
Request Content-Types:
application/json
Query
query outingsCategoryTotalizerByMonthAndOrg($year: Float!, $month: Float!, $orgId: Float!){
outingsCategoryTotalizerByMonthAndOrg(year: $year, month: $month, orgId: $orgId){
category_name
category_id
org_id
org_name
org_phone
org_email
total_value
diff_value
total_qty
diff_qty
month
year
reference_date
}
}
Variables
{
"year": "number",
"month": "number",
"orgId": "number"
}
Try it now
query outingsCategoryTotalizerByMonthAndOrg($year: Float!, $month: Float!, $orgId: Float!){
outingsCategoryTotalizerByMonthAndOrg(year: $year, month: $month, orgId: $orgId){
category_name
category_id
org_id
org_name
org_phone
org_email
total_value
diff_value
total_qty
diff_qty
month
year
reference_date
}
}
{
"year": "number",
"month": "number",
"orgId": "number"
}
Successful operation
Response Content-Types: application/json
Response Example (200 OK)
{
"data": {
"outingsCategoryTotalizerByMonthAndOrg": [
{
"category_name": "string",
"category_id": "string",
"org_id": "number",
"org_name": "string",
"org_phone": "string",
"org_email": "string",
"total_value": "number",
"diff_value": "number",
"total_qty": "number",
"diff_qty": "number",
"month": "number",
"year": "number"
}
]
}
}
Apuração da categoria por estado
Listar a apuração de cada categoria de acordo com o estado selecionada em determinado mês e ano, informando também o percentual da diferença sobre o mês anterior.
(no description)
(no description)
(no description)
Example
Request Content-Types:
application/json
Query
query outingsCategoryTotalizerByMonthAndState($states: [String!]!, $year: Float!, $month: Float!){
outingsCategoryTotalizerByMonthAndState(states: $states, year: $year, month: $month){
category_name
category_id
state
total_value
diff_value
total_qty
diff_qty
month
year
reference_date
}
}
Variables
{
"states": [
"string"
],
"year": "number",
"month": "number"
}
Try it now
query outingsCategoryTotalizerByMonthAndState($states: [String!]!, $year: Float!, $month: Float!){
outingsCategoryTotalizerByMonthAndState(states: $states, year: $year, month: $month){
category_name
category_id
state
total_value
diff_value
total_qty
diff_qty
month
year
reference_date
}
}
{
"states": [
"string"
],
"year": "number",
"month": "number"
}
Successful operation
Response Content-Types: application/json
Response Example (200 OK)
{
"data": {
"outingsCategoryTotalizerByMonthAndState": [
{
"category_name": "string",
"category_id": "string",
"state": "string",
"total_value": "number",
"diff_value": "number",
"total_qty": "number",
"diff_qty": "number",
"month": "number",
"year": "number"
}
]
}
}
Apuração total da categoria
Listar o total da apuração por categoria de todos os anos
Example
Request Content-Types:
application/json
Query
query outingsCategoryTotalizer{
outingsCategoryTotalizer{
category_name
category_id
total_value
total_qty
}
}
Try it now
query outingsCategoryTotalizer{
outingsCategoryTotalizer{
category_name
category_id
total_value
total_qty
}
}
Successful operation
Response Content-Types: application/json
Response Example (200 OK)
{
"data": {
"outingsCategoryTotalizer": [
{
"category_name": "string",
"category_id": "string",
"total_value": "number",
"total_qty": "number"
}
]
}
}
Apuração total da categoria por ano
Listar o total da apuração por categoria para o ano informado
(no description)
Example
Request Content-Types:
application/json
Query
query outingsCategoryTotalizerYearly($year: Float){
outingsCategoryTotalizerYearly(year: $year){
category_name
category_id
year
total_value
total_qty
}
}
Variables
{
"year": "number"
}
Try it now
query outingsCategoryTotalizerYearly($year: Float){
outingsCategoryTotalizerYearly(year: $year){
category_name
category_id
year
total_value
total_qty
}
}
{
"year": "number"
}
Successful operation
Response Content-Types: application/json
Response Example (200 OK)
{
"data": {
"outingsCategoryTotalizerYearly": [
{
"category_name": "string",
"category_id": "string",
"year": "string",
"total_value": "number",
"total_qty": "number"
}
]
}
}
Apuração total dos materiais por cooperativa
Listar o total dos materiais por cooperativa de um determinado mês e ano
(no description)
(no description)
(no description)
Example
Request Content-Types:
application/json
Query
query outingsMaterialTotalizerByOrg($year: Float!, $month: Float!, $orgId: Float!){
outingsMaterialTotalizerByOrg(year: $year, month: $month, orgId: $orgId){
category_name
category_id
material_name
material_id
org_id
total_value
total_qty
month
year
reference_date
}
}
Variables
{
"year": "number",
"month": "number",
"orgId": "number"
}
Try it now
query outingsMaterialTotalizerByOrg($year: Float!, $month: Float!, $orgId: Float!){
outingsMaterialTotalizerByOrg(year: $year, month: $month, orgId: $orgId){
category_name
category_id
material_name
material_id
org_id
total_value
total_qty
month
year
reference_date
}
}
{
"year": "number",
"month": "number",
"orgId": "number"
}
Successful operation
Response Content-Types: application/json
Response Example (200 OK)
{
"data": {
"outingsMaterialTotalizerByOrg": [
{
"category_name": "string",
"category_id": "string",
"material_name": "string",
"material_id": "string",
"org_id": "number",
"total_value": "number",
"total_qty": "number",
"month": "number",
"year": "number"
}
]
}
}
Apuração total do alumínio
Listar o total do alumínio do ano desejado, quando não informado o ano, retorna o total de todos os anos
(no description)
Example
Request Content-Types:
application/json
Query
query outingsTotalizerAluminum($year: Float){
outingsTotalizerAluminum(year: $year){
total_value
total_qty
}
}
Variables
{
"year": "number"
}
Try it now
query outingsTotalizerAluminum($year: Float){
outingsTotalizerAluminum(year: $year){
total_value
total_qty
}
}
{
"year": "number"
}
Successful operation
Response Content-Types: application/json
Response Example (200 OK)
{
"data": {
"outingsTotalizerAluminum": [
{
"total_value": "number",
"total_qty": "number"
}
]
}
}
Top cidades com maior quantidade por estado
Listar as 5 cidades que teve os maiores volumes de saídas por estado em determinado mês do ano.
(no description)
(no description)
(no description)
Example
Request Content-Types:
application/json
Query
query outingsTopCityByStateWithMostQty($state: String!, $month: Float!, $year: Float!){
outingsTopCityByStateWithMostQty(state: $state, month: $month, year: $year){
city
state
total_qty
total_value
}
}
Variables
{
"state": "string",
"month": "number",
"year": "number"
}
Try it now
query outingsTopCityByStateWithMostQty($state: String!, $month: Float!, $year: Float!){
outingsTopCityByStateWithMostQty(state: $state, month: $month, year: $year){
city
state
total_qty
total_value
}
}
{
"state": "string",
"month": "number",
"year": "number"
}
Successful operation
Response Content-Types: application/json
Response Example (200 OK)
{
"data": {
"outingsTopCityByStateWithMostQty": [
{
"city": "string",
"state": "string",
"total_qty": "number",
"total_value": "number"
}
]
}
}
Top cidades com maior faturamento por estado
Listar as 5 cidades que teve os maiores volumes de saídas por estado em determinado mês do ano.
(no description)
(no description)
(no description)
Example
Request Content-Types:
application/json
Query
query outingsTopCityByStateWithMostValue($state: String!, $month: Float!, $year: Float!){
outingsTopCityByStateWithMostValue(state: $state, month: $month, year: $year){
city
state
total_qty
total_value
}
}
Variables
{
"state": "string",
"month": "number",
"year": "number"
}
Try it now
query outingsTopCityByStateWithMostValue($state: String!, $month: Float!, $year: Float!){
outingsTopCityByStateWithMostValue(state: $state, month: $month, year: $year){
city
state
total_qty
total_value
}
}
{
"state": "string",
"month": "number",
"year": "number"
}
Successful operation
Response Content-Types: application/json
Response Example (200 OK)
{
"data": {
"outingsTopCityByStateWithMostValue": [
{
"city": "string",
"state": "string",
"total_qty": "number",
"total_value": "number"
}
]
}
}
Preço dos materiais por cooperativas
Listar o preço mínimo e máximo de cada material negociado no mês informado por cooperativa.
(no description)
(no description)
(no description)
Example
Request Content-Types:
application/json
Query
query outingsMaterialTPriceByOrg($year: Float!, $month: Float!, $orgId: Float!){
outingsMaterialTPriceByOrg(year: $year, month: $month, orgId: $orgId){
category_name
category_id
material_name
material_id
min_unitary_value
max_unitary_value
}
}
Variables
{
"year": "number",
"month": "number",
"orgId": "number"
}
Try it now
query outingsMaterialTPriceByOrg($year: Float!, $month: Float!, $orgId: Float!){
outingsMaterialTPriceByOrg(year: $year, month: $month, orgId: $orgId){
category_name
category_id
material_name
material_id
min_unitary_value
max_unitary_value
}
}
{
"year": "number",
"month": "number",
"orgId": "number"
}
Successful operation
Response Content-Types: application/json
Response Example (200 OK)
{
"data": {
"outingsMaterialTPriceByOrg": [
{
"category_name": "string",
"category_id": "string",
"material_name": "string",
"material_id": "string",
"min_unitary_value": "number",
"max_unitary_value": "number"
}
]
}
}
Data da última apuração por cooperativa
Lista a data da última apuração feita na cooperativa desejada.
(no description)
Example
Request Content-Types:
application/json
Query
query outingsLastInspectionByOrg($orgId: Float!){
outingsLastInspectionByOrg(orgId: $orgId){
org_id
month
year
last_date
}
}
Variables
{
"orgId": "number"
}
Try it now
query outingsLastInspectionByOrg($orgId: Float!){
outingsLastInspectionByOrg(orgId: $orgId){
org_id
month
year
last_date
}
}
{
"orgId": "number"
}
Successful operation
Response Content-Types: application/json
Response Example (200 OK)
{
"data": {
"outingsLastInspectionByOrg": {
"org_id": "number",
"month": "number",
"year": "number"
}
}
}
Número de membros por gênero
Lista o número de membros feminino e masculino de uma determinada cooperativa.
(no description)
Example
Request Content-Types:
application/json
Query
query reportsActsNumberOfMemberByOrg($orgId: Float!){
reportsActsNumberOfMemberByOrg(orgId: $orgId){
year
month
org
member_male
member_female
}
}
Variables
{
"orgId": "number"
}
Try it now
query reportsActsNumberOfMemberByOrg($orgId: Float!){
reportsActsNumberOfMemberByOrg(orgId: $orgId){
year
month
org
member_male
member_female
}
}
{
"orgId": "number"
}
Successful operation
Response Content-Types: application/json
Response Example (200 OK)
{
"data": {
"reportsActsNumberOfMemberByOrg": {
"year": "number",
"month": "number",
"org": "number",
"member_male": "number",
"member_female": "number"
}
}
}
Schema Definitions
AddressJsonType: object
Endereço
-
city:
object
-
Cidade
-
- return:
-
arguments:
object
-
-
state:
object
-
Estado
-
- return:
-
arguments:
object
-
-
street:
object
-
Rua
-
- return:
-
arguments:
object
-
-
zipcode:
object
-
CEP
-
- return:
-
arguments:
object
-
-
neighborhood:
object
-
Bairro
-
- return:
-
arguments:
object
-
-
complementary:
object
-
Complemento
-
- return:
-
arguments:
object
-
-
street_number:
object
-
Número da rua
-
- return:
-
arguments:
object
-
Example
{
"city": {
"return": "string",
"arguments": {}
},
"state": {
"return": "string",
"arguments": {}
},
"street": {
"return": "string",
"arguments": {}
},
"zipcode": {
"return": "string",
"arguments": {}
},
"neighborhood": {
"return": "string",
"arguments": {}
},
"complementary": {
"return": "string",
"arguments": {}
},
"street_number": {
"return": "string",
"arguments": {}
}
}
Category: object
-
id:
object
-
ID da categoria
-
- return:
-
arguments:
object
-
-
name:
object
-
Nome da categoria
-
- return:
-
arguments:
object
-
-
color:
object
-
Cor da categoria
-
- return:
-
arguments:
object
-
-
lock:
object
-
- return:
-
arguments:
object
-
Example
{
"id": {
"return": "object",
"arguments": {}
},
"name": {
"return": "string",
"arguments": {}
},
"color": {
"return": "string",
"arguments": {}
},
"lock": {
"return": "boolean",
"arguments": {}
}
}
CategoryTotalizerByMonthAndOrgType: object
Total da categoria por cooperativa no mês
-
category_name:
object
-
Nome da categoria
-
- return:
-
arguments:
object
-
-
category_id:
object
-
ID da categoria
-
- return:
-
arguments:
object
-
-
org_id:
object
-
ID da cooperativa
-
- return:
-
arguments:
object
-
-
org_name:
object
-
Nome da cooperativa
-
- return:
-
arguments:
object
-
-
org_phone:
object
-
Telefone da cooperativa
-
- return:
-
arguments:
object
-
-
org_email:
object
-
E-mail da cooperativa
-
- return:
-
arguments:
object
-
-
total_value:
object
-
Total do faturamento em reais
-
- return:
-
arguments:
object
-
-
diff_value:
object
-
Percentual da diferença do faturamento referente ao mês anterior
-
- return:
-
arguments:
object
-
-
total_qty:
object
-
Total de quantidade em kg
-
- return:
-
arguments:
object
-
-
diff_qty:
object
-
Percentual da diferença da quantidade referente ao mês anterior
-
- return:
-
arguments:
object
-
-
month:
object
-
Mês de referência
-
- return:
-
arguments:
object
-
-
year:
object
-
Ano de referência
-
- return:
-
arguments:
object
-
-
reference_date:
object
-
Data de referência
-
- return:
-
arguments:
object
-
Example
{
"category_name": {
"return": "string",
"arguments": {}
},
"category_id": {
"return": "string",
"arguments": {}
},
"org_id": {
"return": "number",
"arguments": {}
},
"org_name": {
"return": "string",
"arguments": {}
},
"org_phone": {
"return": "string",
"arguments": {}
},
"org_email": {
"return": "string",
"arguments": {}
},
"total_value": {
"return": "number",
"arguments": {}
},
"diff_value": {
"return": "number",
"arguments": {}
},
"total_qty": {
"return": "number",
"arguments": {}
},
"diff_qty": {
"return": "number",
"arguments": {}
},
"month": {
"return": "number",
"arguments": {}
},
"year": {
"return": "number",
"arguments": {}
},
"reference_date": {
"return": "object",
"arguments": {}
}
}
CategoryTotalizerByMonthAndStateType: object
Total da categoria por estado no mês
-
category_name:
object
-
Nome da categoria
-
- return:
-
arguments:
object
-
-
category_id:
object
-
ID da categoria
-
- return:
-
arguments:
object
-
-
state:
object
-
Estado
-
- return:
-
arguments:
object
-
-
total_value:
object
-
Total do faturamento em reais
-
- return:
-
arguments:
object
-
-
diff_value:
object
-
Percentual da diferença do faturamento referente ao mês anterior
-
- return:
-
arguments:
object
-
-
total_qty:
object
-
Total de quantidade em kg
-
- return:
-
arguments:
object
-
-
diff_qty:
object
-
Percentual da diferença da quantidade referente ao mês anterior
-
- return:
-
arguments:
object
-
-
month:
object
-
Mês de referência
-
- return:
-
arguments:
object
-
-
year:
object
-
Ano de referência
-
- return:
-
arguments:
object
-
-
reference_date:
object
-
Data de referência
-
- return:
-
arguments:
object
-
Example
{
"category_name": {
"return": "string",
"arguments": {}
},
"category_id": {
"return": "string",
"arguments": {}
},
"state": {
"return": "string",
"arguments": {}
},
"total_value": {
"return": "number",
"arguments": {}
},
"diff_value": {
"return": "number",
"arguments": {}
},
"total_qty": {
"return": "number",
"arguments": {}
},
"diff_qty": {
"return": "number",
"arguments": {}
},
"month": {
"return": "number",
"arguments": {}
},
"year": {
"return": "number",
"arguments": {}
},
"reference_date": {
"return": "object",
"arguments": {}
}
}
CategoryTotalizerType: object
Total da categoria
-
category_name:
object
-
Nome da categoria
-
- return:
-
arguments:
object
-
-
category_id:
object
-
ID da categoria
-
- return:
-
arguments:
object
-
-
total_value:
object
-
Total do faturamento em reais
-
- return:
-
arguments:
object
-
-
total_qty:
object
-
total da quantidade em kg
-
- return:
-
arguments:
object
-
Example
{
"category_name": {
"return": "string",
"arguments": {}
},
"category_id": {
"return": "string",
"arguments": {}
},
"total_value": {
"return": "number",
"arguments": {}
},
"total_qty": {
"return": "number",
"arguments": {}
}
}
CategoryTotalizerYearlyType: object
Total da categoria por ano
-
category_name:
object
-
Nome da categoria
-
- return:
-
arguments:
object
-
-
category_id:
object
-
ID da categoria
-
- return:
-
arguments:
object
-
-
year:
object
-
Ano da referência
-
- return:
-
arguments:
object
-
-
total_value:
object
-
Total do faturamento em reais
-
- return:
-
arguments:
object
-
-
total_qty:
object
-
total da quantidade em kg
-
- return:
-
arguments:
object
-
Example
{
"category_name": {
"return": "string",
"arguments": {}
},
"category_id": {
"return": "string",
"arguments": {}
},
"year": {
"return": "string",
"arguments": {}
},
"total_value": {
"return": "number",
"arguments": {}
},
"total_qty": {
"return": "number",
"arguments": {}
}
}
Cookies: object
-
id:
object
-
ID
-
- return:
-
arguments:
object
-
-
createdAt:
object
-
Data da criação
-
- return:
-
arguments:
object
-
-
body:
object
-
Mensagem
-
- return:
-
arguments:
object
-
Example
{
"id": {
"return": "object",
"arguments": {}
},
"createdAt": {
"return": "string",
"arguments": {}
},
"body": {
"return": "string",
"arguments": {}
}
}
DateTime: object
The javascript Date as string. Type represents date and time as the ISO Date string.
Example
object
Float: number
The Float scalar type represents signed double-precision fractional values as specified by
IEEE 754.
Example
number
ID: object
The ID scalar type represents a unique identifier, often used to refetch an object or as key for a cache. The ID type appears in a JSON response as a String; however, it is not intended to be human-readable. When expected as an input type, any string (such as "4") or integer (such as 4) input value will be accepted as an ID.
Example
object
Int: number
The Int scalar type represents non-fractional signed whole numeric values. Int can represent values between -(2^31) and 2^31 - 1.
Example
number
MaterialPriceByMonthAndOrgType: object
Preços do material no mês
-
category_name:
object
-
Nome da categoria
-
- return:
-
arguments:
object
-
-
category_id:
object
-
ID da categoria
-
- return:
-
arguments:
object
-
-
material_name:
object
-
ID do material
-
- return:
-
arguments:
object
-
-
material_id:
object
-
ID do material
-
- return:
-
arguments:
object
-
-
min_unitary_value:
object
-
Valor do preço unitário mínimo
-
- return:
-
arguments:
object
-
-
max_unitary_value:
object
-
Valor do preço unitário máximo
-
- return:
-
arguments:
object
-
Example
{
"category_name": {
"return": "string",
"arguments": {}
},
"category_id": {
"return": "string",
"arguments": {}
},
"material_name": {
"return": "string",
"arguments": {}
},
"material_id": {
"return": "string",
"arguments": {}
},
"min_unitary_value": {
"return": "number",
"arguments": {}
},
"max_unitary_value": {
"return": "number",
"arguments": {}
}
}
MaterialTotalizerByMonthAndOrgType: object
Total do material por cooperativa no mês
-
category_name:
object
-
Nome da categoria
-
- return:
-
arguments:
object
-
-
category_id:
object
-
ID da categoria
-
- return:
-
arguments:
object
-
-
material_name:
object
-
ID do material
-
- return:
-
arguments:
object
-
-
material_id:
object
-
ID do material
-
- return:
-
arguments:
object
-
-
org_id:
object
-
ID da cooperativa
-
- return:
-
arguments:
object
-
-
total_value:
object
-
Valor total do faturamento em reais
-
- return:
-
arguments:
object
-
-
total_qty:
object
-
Valor total da quantidade em kg
-
- return:
-
arguments:
object
-
-
month:
object
-
Mês da referência
-
- return:
-
arguments:
object
-
-
year:
object
-
Ano da referência
-
- return:
-
arguments:
object
-
-
reference_date:
object
-
Data da referência
-
- return:
-
arguments:
object
-
Example
{
"category_name": {
"return": "string",
"arguments": {}
},
"category_id": {
"return": "string",
"arguments": {}
},
"material_name": {
"return": "string",
"arguments": {}
},
"material_id": {
"return": "string",
"arguments": {}
},
"org_id": {
"return": "number",
"arguments": {}
},
"total_value": {
"return": "number",
"arguments": {}
},
"total_qty": {
"return": "number",
"arguments": {}
},
"month": {
"return": "number",
"arguments": {}
},
"year": {
"return": "number",
"arguments": {}
},
"reference_date": {
"return": "object",
"arguments": {}
}
}
Materials: object
-
id:
object
-
ID do material
-
- return:
-
arguments:
object
-
-
name:
object
-
Nome do material
-
- return:
-
arguments:
object
-
-
category:
object
-
ID da categoria
-
- return:
-
arguments:
object
-
-
category_name:
object
-
Nome da categoria
-
- return:
-
arguments:
object
-
-
min:
object
-
- return:
-
arguments:
object
-
-
max:
object
-
- return:
-
arguments:
object
-
-
unit:
object
-
- return:
-
arguments:
object
-
-
ckv:
object
-
- return:
-
arguments:
object
-
Example
{
"id": {
"return": "object",
"arguments": {}
},
"name": {
"return": "string",
"arguments": {}
},
"category": {
"return": "number",
"arguments": {}
},
"category_name": {
"return": "string",
"arguments": {}
},
"min": {
"return": "number",
"arguments": {}
},
"max": {
"return": "number",
"arguments": {}
},
"unit": {
"return": "boolean",
"arguments": {}
},
"ckv": {
"return": "number",
"arguments": {}
}
}
MediaJsonType: object
-
date:
object
-
- return:
-
arguments:
object
-
-
name:
object
-
- return:
-
arguments:
object
-
-
path:
object
-
- return:
-
arguments:
object
-
-
size:
object
-
- return:
-
arguments:
object
-
-
type:
object
-
- return:
-
arguments:
object
-
-
user:
object
-
- return:
-
arguments:
object
-
-
base_name:
object
-
- return:
-
arguments:
object
-
Example
{
"date": {
"return": "string",
"arguments": {}
},
"name": {
"return": "string",
"arguments": {}
},
"path": {
"return": "string",
"arguments": {}
},
"size": {
"return": "string",
"arguments": {}
},
"type": {
"return": "string",
"arguments": {}
},
"user": {
"return": "string",
"arguments": {}
},
"base_name": {
"return": "string",
"arguments": {}
}
}
Organizations: object
Cooperativas
-
id:
object
-
ID
-
- return:
-
arguments:
object
-
-
name:
object
-
Nome
-
- return:
-
arguments:
object
-
-
national_id:
object
-
CNPJ
-
- return:
-
arguments:
object
-
-
web:
object
-
Website
-
- return:
-
arguments:
object
-
-
phone:
object
-
Telefone
-
- return:
-
arguments:
object
-
-
email:
object
-
E-mail
-
- return:
-
arguments:
object
-
-
owner:
object
-
Proprietário
-
- return:
-
arguments:
object
-
-
address:
object
-
Endereço
-
- return:
-
arguments:
object
-
-
state:
object
-
Estado
-
- return:
-
arguments:
object
-
-
city:
object
-
Cidade
-
- return:
-
arguments:
object
-
-
type:
object
-
Tipo
-
- return:
-
arguments:
object
-
-
nucleus:
object
-
ID do núcleo
-
- return:
-
arguments:
object
-
-
nucleus_name:
object
-
Nome do núcleo
-
- return:
-
arguments:
object
-
-
nucleus_code:
object
-
- return:
-
arguments:
object
-
-
nucleus_owner:
object
-
- return:
-
arguments:
object
-
-
owner_name:
object
-
- return:
-
arguments:
object
-
-
member_male:
object
-
- return:
-
arguments:
object
-
-
member_female:
object
-
- return:
-
arguments:
object
-
-
projects:
object
-
- return:
-
arguments:
object
-
-
latitude:
object
-
Latitude referente a localização da cooperativa
-
- return:
-
arguments:
object
-
-
longitude:
object
-
Longitude referente a localização da cooperativa
-
- return:
-
arguments:
object
-
Example
{
"id": {
"return": "object",
"arguments": {}
},
"name": {
"return": "string",
"arguments": {}
},
"national_id": {
"return": "string",
"arguments": {}
},
"web": {
"return": "string",
"arguments": {}
},
"phone": {
"return": "string",
"arguments": {}
},
"email": {
"return": "string",
"arguments": {}
},
"owner": {
"return": "string",
"arguments": {}
},
"address": {
"return": {
"city": {
"return": "string",
"arguments": {}
},
"state": {
"return": "string",
"arguments": {}
},
"street": {
"return": "string",
"arguments": {}
},
"zipcode": {
"return": "string",
"arguments": {}
},
"neighborhood": {
"return": "string",
"arguments": {}
},
"complementary": {
"return": "string",
"arguments": {}
},
"street_number": {
"return": "string",
"arguments": {}
}
},
"arguments": {}
},
"state": {
"return": "string",
"arguments": {}
},
"city": {
"return": "string",
"arguments": {}
},
"type": {
"return": "number",
"arguments": {}
},
"nucleus": {
"return": "number",
"arguments": {}
},
"nucleus_name": {
"return": "string",
"arguments": {}
},
"nucleus_code": {
"return": "number",
"arguments": {}
},
"nucleus_owner": {
"return": "number",
"arguments": {}
},
"owner_name": {
"return": "string",
"arguments": {}
},
"member_male": {
"return": "number",
"arguments": {}
},
"member_female": {
"return": "number"
}
}
Outings: object
Saídas/Vendas
-
id:
object
-
ID
-
- return:
-
arguments:
object
-
-
qty:
object
-
Quantidade do material
-
- return:
-
arguments:
object
-
-
ckv:
object
-
- return:
-
arguments:
object
-
-
value:
object
-
Valor unitário do materal
-
- return:
-
arguments:
object
-
-
total:
object
-
Valor total do material vendido
-
- return:
-
arguments:
object
-
-
attachment:
object
-
- return:
-
arguments:
object
-
-
buyer:
object
-
- return:
-
arguments:
object
-
-
buyer_name:
object
-
- return:
-
arguments:
object
-
-
report:
object
-
- return:
-
arguments:
object
-
-
material:
object
-
ID do material
-
- return:
-
arguments:
object
-
-
material_name:
object
-
Nome do material
-
- return:
-
arguments:
object
-
-
category:
object
-
ID da categoria
-
- return:
-
arguments:
object
-
-
category_name:
object
-
Nome da categoria
-
- return:
-
arguments:
object
-
-
unit:
object
-
- return:
-
arguments:
object
-
-
project:
object
-
- return:
-
arguments:
object
-
-
project_name:
object
-
- return:
-
arguments:
object
-
-
month:
object
-
Mês
-
- return:
-
arguments:
object
-
-
year:
object
-
Ano
-
- return:
-
arguments:
object
-
-
org_id:
object
-
ID da cooperativa fornecedora
-
- return:
-
arguments:
object
-
-
org_national_id:
object
-
CNPJ da cooperativa fornecedora
-
- return:
-
arguments:
object
-
-
org_name:
object
-
Nome da cooperativa fornecedora
-
- return:
-
arguments:
object
-
-
org_city:
object
-
Cidade da cooperativa fornecedora
-
- return:
-
arguments:
object
-
-
org_state:
object
-
Estado da cooperativa fornecedora
-
- return:
-
arguments:
object
-
-
org_address:
object
-
Endereço da cooperativa fornecedora
-
- return:
-
arguments:
object
-
-
org_web:
object
-
Website da cooperativa fornecedora
-
- return:
-
arguments:
object
-
-
org_phone:
object
-
Telefone da cooperativa fornecedora
-
- return:
-
arguments:
object
-
-
org_email:
object
-
E-mail da cooperativa fornecedora
-
- return:
-
arguments:
object
-
-
nucleus_name:
object
-
Nome do núcleo que a cooperativa fornecedora pertence
-
- return:
-
arguments:
object
-
-
submission_date:
object
-
- return:
-
arguments:
object
-
-
status:
object
-
- return:
-
arguments:
object
-
-
reference_date:
object
-
Data referência da negociação (sendo considerado apenas o mês e ano)
-
- return:
-
arguments:
object
-
-
file:
object
-
- return:
-
arguments:
object
-
Example
{
"id": {
"return": "object",
"arguments": {}
},
"qty": {
"return": "number",
"arguments": {}
},
"ckv": {
"return": "number",
"arguments": {}
},
"value": {
"return": "number",
"arguments": {}
},
"total": {
"return": "number",
"arguments": {}
},
"attachment": {
"return": "string",
"arguments": {}
},
"buyer": {
"return": "number",
"arguments": {}
},
"buyer_name": {
"return": "string",
"arguments": {}
},
"report": {
"return": "number",
"arguments": {}
},
"material": {
"return": "number",
"arguments": {}
},
"material_name": {
"return": "string",
"arguments": {}
},
"category": {
"return": "number",
"arguments": {}
},
"category_name": {
"return": "string",
"arguments": {}
},
"unit": {
"return": "boolean",
"arguments": {}
},
"project": {
"return": "string",
"arguments": {}
},
"project_name": {
"return": "string",
"arguments": {}
},
"month": {
"return": "number",
"arguments": {}
},
"year": {
"return": "number",
"arguments": {}
},
"org_id": {
"return": "number",
"arguments": {}
},
"org_national_id": {
"return": "string",
"arguments": {}
},
"org_name": {
"return": "string",
"arguments": {}
},
"org_city": {
"return": "string",
"arguments": {}
},
"org_state": {
"return": "string",
"arguments": {}
},
"org_address": {
"return": "string",
"arguments": {}
},
"org_web": {
"return": "string"
}
}
OutingsLastInspectionByOrgType: object
Data da última apuração registrada para a cooperativa
-
org_id:
object
-
ID da cooperativa
-
- return:
-
arguments:
object
-
-
month:
object
-
Mês da última apuração
-
- return:
-
arguments:
object
-
-
year:
object
-
Ano da última apuração
-
- return:
-
arguments:
object
-
-
last_date:
object
-
Data da última apuração
-
- return:
-
arguments:
object
-
Example
{
"org_id": {
"return": "number",
"arguments": {}
},
"month": {
"return": "number",
"arguments": {}
},
"year": {
"return": "number",
"arguments": {}
},
"last_date": {
"return": "object",
"arguments": {}
}
}
OutingsLastValueByOrgType: object
Dados da cooperativa referente a apuração com totalizadores
-
org_id:
object
-
ID da cooperativa
-
- return:
-
arguments:
object
-
-
org_name:
object
-
Nome da cooperativa
-
- return:
-
arguments:
object
-
-
org_phone:
object
-
Telefone da cooperativa
-
- return:
-
arguments:
object
-
-
org_email:
object
-
E-mail da cooperativa
-
- return:
-
arguments:
object
-
-
total_value:
object
-
Total do faturamento em reais
-
- return:
-
arguments:
object
-
-
diff_value:
object
-
Percentual da diferença do faturamento referente ao mês anterior
-
- return:
-
arguments:
object
-
-
total_qty:
object
-
Total de quantidade em kg
-
- return:
-
arguments:
object
-
-
diff_qty:
object
-
Percentual da diferença da quantidade referente ao mês anterior
-
- return:
-
arguments:
object
-
-
month:
object
-
Mês de referência
-
- return:
-
arguments:
object
-
-
year:
object
-
Ano de referência
-
- return:
-
arguments:
object
-
-
reference_date:
object
-
Data de referência
-
- return:
-
arguments:
object
-
Example
{
"org_id": {
"return": "number",
"arguments": {}
},
"org_name": {
"return": "string",
"arguments": {}
},
"org_phone": {
"return": "string",
"arguments": {}
},
"org_email": {
"return": "string",
"arguments": {}
},
"total_value": {
"return": "number",
"arguments": {}
},
"diff_value": {
"return": "number",
"arguments": {}
},
"total_qty": {
"return": "number",
"arguments": {}
},
"diff_qty": {
"return": "number",
"arguments": {}
},
"month": {
"return": "number",
"arguments": {}
},
"year": {
"return": "number",
"arguments": {}
},
"reference_date": {
"return": "object",
"arguments": {}
}
}
OutingsTopCityStateType: object
Dados da apuração com totalizador por cidade
-
city:
object
-
Nome da cidade
-
- return:
-
arguments:
object
-
-
state:
object
-
Nome do estado
-
- return:
-
arguments:
object
-
-
total_qty:
object
-
Total da quantidade em kg
-
- return:
-
arguments:
object
-
-
total_value:
object
-
Total do faturamento em reais
-
- return:
-
arguments:
object
-
Example
{
"city": {
"return": "string",
"arguments": {}
},
"state": {
"return": "string",
"arguments": {}
},
"total_qty": {
"return": "number",
"arguments": {}
},
"total_value": {
"return": "number",
"arguments": {}
}
}
OutingsTopOrgStateType: object
Dados da apuração da cooperativa com cidade e totalizador
-
org_id:
object
-
ID da cooperativa
-
- return:
-
arguments:
object
-
-
org_name:
object
-
Nome da cooperativa
-
- return:
-
arguments:
object
-
-
org_city:
object
-
Nome da cidade
-
- return:
-
arguments:
object
-
-
org_state:
object
-
Nome do estado
-
- return:
-
arguments:
object
-
-
org_email:
object
-
E-mail da cooperativa
-
- return:
-
arguments:
object
-
-
total_qty:
object
-
Total da quantidade em kg
-
- return:
-
arguments:
object
-
-
total_value:
object
-
Total do faturamento em reais
-
- return:
-
arguments:
object
-
Example
{
"org_id": {
"return": "number",
"arguments": {}
},
"org_name": {
"return": "string",
"arguments": {}
},
"org_city": {
"return": "string",
"arguments": {}
},
"org_state": {
"return": "string",
"arguments": {}
},
"org_email": {
"return": "string",
"arguments": {}
},
"total_qty": {
"return": "number",
"arguments": {}
},
"total_value": {
"return": "number",
"arguments": {}
}
}
OutingsTotalMonthWithOrgType: object
Dados da apuração da cooperativa com totalizador
-
org_id:
object
-
ID da cooperativa
-
- return:
-
arguments:
object
-
-
org_name:
object
-
Nome da cooperativa
-
- return:
-
arguments:
object
-
-
org_city:
object
-
Nome da cidade
-
- return:
-
arguments:
object
-
-
org_state:
object
-
Nome do estado
-
- return:
-
arguments:
object
-
-
org_owner_name:
object
-
Nome do proprietário da cooperativa
-
- return:
-
arguments:
object
-
-
nucleus_name:
object
-
Nome do núcleo que a cooperativa pertence
-
- return:
-
arguments:
object
-
-
total_qty:
object
-
Total da quantidade em kg
-
- return:
-
arguments:
object
-
-
total_value:
object
-
Total do faturamento em reais
-
- return:
-
arguments:
object
-
Example
{
"org_id": {
"return": "number",
"arguments": {}
},
"org_name": {
"return": "string",
"arguments": {}
},
"org_city": {
"return": "string",
"arguments": {}
},
"org_state": {
"return": "string",
"arguments": {}
},
"org_owner_name": {
"return": "string",
"arguments": {}
},
"nucleus_name": {
"return": "string",
"arguments": {}
},
"total_qty": {
"return": "number",
"arguments": {}
},
"total_value": {
"return": "number",
"arguments": {}
}
}
ReportActs: object
Relatório de atos
-
id:
object
-
- return:
-
arguments:
object
-
-
year:
object
-
Ano de referência
-
- return:
-
arguments:
object
-
-
month:
object
-
Mês de referência
-
- return:
-
arguments:
object
-
-
org:
object
-
ID da cooperativa
-
- return:
-
arguments:
object
-
-
org_name:
object
-
Nome da cooperativa
-
- return:
-
arguments:
object
-
-
org_owner:
object
-
Proprietário da cooperativa
-
- return:
-
arguments:
object
-
-
org_state:
object
-
Estado da cooperativa
-
- return:
-
arguments:
object
-
-
org_city:
object
-
Cidade da cooperativa
-
- return:
-
arguments:
object
-
-
owner:
object
-
- return:
-
arguments:
object
-
-
nucleus:
object
-
- return:
-
arguments:
object
-
-
nucleus_name:
object
-
- return:
-
arguments:
object
-
-
q1:
object
-
- return:
-
arguments:
object
-
-
q2:
object
-
- return:
-
arguments:
object
-
-
q3:
object
-
- return:
-
arguments:
object
-
-
q4:
object
-
- return:
-
arguments:
object
-
-
q5:
object
-
- return:
-
arguments:
object
-
-
q6:
object
-
- return:
-
arguments:
object
-
-
q7:
object
-
- return:
-
arguments:
object
-
-
q8:
object
-
- return:
-
arguments:
object
-
-
q9:
object
-
- return:
-
arguments:
object
-
-
q10:
object
-
- return:
-
arguments:
object
-
-
create_date:
object
-
- return:
-
arguments:
object
-
-
status:
object
-
- return:
-
arguments:
object
-
-
member_male:
object
-
Número de membros do sexo masculino
-
- return:
-
arguments:
object
-
-
member_female:
object
-
Número de membros do sexo feminino
-
- return:
-
arguments:
object
-
-
submission_init:
object
-
- return:
-
arguments:
object
-
-
submission_limit:
object
-
- return:
-
arguments:
object
-
-
submission_date:
object
-
- return:
-
arguments:
object
-
-
reference_date:
object
-
Data da referência (sendo considerado apenas o mês e ano)
-
- return:
-
arguments:
object
-
-
media:
object
-
- return:
-
arguments:
object
-
-
project:
object
-
- return:
-
arguments:
object
-
-
project_name:
object
-
- return:
-
arguments:
object
-
Example
{
"id": {
"return": "object",
"arguments": {}
},
"year": {
"return": "number",
"arguments": {}
},
"month": {
"return": "number",
"arguments": {}
},
"org": {
"return": "number",
"arguments": {}
},
"org_name": {
"return": "string",
"arguments": {}
},
"org_owner": {
"return": "string",
"arguments": {}
},
"org_state": {
"return": "string",
"arguments": {}
},
"org_city": {
"return": "string",
"arguments": {}
},
"owner": {
"return": "number",
"arguments": {}
},
"nucleus": {
"return": "number",
"arguments": {}
},
"nucleus_name": {
"return": "string",
"arguments": {}
},
"q1": {
"return": "string",
"arguments": {}
},
"q2": {
"return": "string",
"arguments": {}
},
"q3": {
"return": "string",
"arguments": {}
},
"q4": {
"return": "string",
"arguments": {}
},
"q5": {
"return": "string",
"arguments": {}
},
"q6": {
"return": "string",
"arguments": {}
},
"q7": {
"return": "string",
"arguments": {}
},
"q8": {
"return": "string",
"arguments": {}
},
"q9": {
"return": "string",
"arguments": {}
},
"q10": {
"return": "string",
"arguments": {}
},
"create_date": {
"return": "object",
"arguments": {}
},
"status": {
"return": "boolean",
"arguments": {}
},
"member_male": {
"return": "number",
"arguments": {}
},
"member_female": {
"return": "number"
}
}
String: string
The String scalar type represents textual data, represented as UTF-8 character sequences. The String type is most often used by GraphQL to represent free-form human-readable text.
TotalizerAluminumType: object
Dados da apuração com totalizadores
-
total_value:
object
-
Total do faturamento em reais
-
- return:
-
arguments:
object
-
-
total_qty:
object
-
Total da quantidade em kg
-
- return:
-
arguments:
object
-
Example
{
"total_value": {
"return": "number",
"arguments": {}
},
"total_qty": {
"return": "number",
"arguments": {}
}
}