Replies: 1 comment 7 replies
-
|
Olá de Portugal! Não sei muito bem o que queres dizer. A sua captura de ecrã mostra o número total de itens, o número de itens que foram recolhidos e a diferença entre os dois (que é o que tem disponível). Pode explicar um pouco melhor o que está a tentar descobrir? |
Beta Was this translation helpful? Give feedback.
-
|
Ah, não - esses dados não são armazenados nas tabelas, são calculados pelo código com base nos valores da base de dados de quantos eram no início e quantos foram atribuídos. No entanto, pode obtê-los a partir da API. Por exemplo, se consultar a API de acessórios, {
"total": 4,
"rows": [
{
"id": 4,
"name": "Sculpt Comfort Mouse",
"image": "https://snipe-it.local:8890/uploads/accessories/comfort-mouse.jpg",
"company": null,
"manufacturer": {
"id": 2,
"name": "Microsoft"
},
"supplier": {
"id": 3,
"name": "Streich Ltd"
},
"model_number": "21405150",
"category": {
"id": 9,
"name": "Mouse"
},
"location": {
"id": 8,
"name": "Deontestad"
},
"notes": null,
"qty": 13,
"purchase_date": null,
"purchase_cost": null,
"order_number": null,
"min_qty": 2,
"remaining_qty": 13,
"users_count": 0,
"created_at": {
"datetime": "2023-12-13 05:55:52",
"formatted": "Wed Dec 13, 2023 5:55AM"
},
"updated_at": {
"datetime": "2023-12-13 05:55:52",
"formatted": "Wed Dec 13, 2023 5:55AM"
},
"available_actions": {
"checkout": true,
"checkin": false,
"update": true,
"delete": true,
"clone": true
},
"user_can_checkout": true
},
{
"id": 1,
"name": "USB Keyboard",
"image": "https://snipe-it.local:8890/uploads/accessories/usb-keyboard.jpg",
"company": null,
"manufacturer": {
"id": 1,
"name": "Apple"
},
"supplier": {
"id": 5,
"name": "Beatty-Schumm"
},
"model_number": "19488985",
"category": {
"id": 8,
"name": "Keyboards"
},
"location": {
"id": 9,
"name": "Corkerymouth"
},
"notes": null,
"qty": 15,
"purchase_date": null,
"purchase_cost": null,
"order_number": null,
"min_qty": 2,
"remaining_qty": 15,
"users_count": 0,
"created_at": {
"datetime": "2023-12-13 05:55:51",
"formatted": "Wed Dec 13, 2023 5:55AM"
},
"updated_at": {
"datetime": "2023-12-13 05:55:51",
"formatted": "Wed Dec 13, 2023 5:55AM"
},
"available_actions": {
"checkout": true,
"checkin": false,
"update": true,
"delete": true,
"clone": true
},
"user_can_checkout": true
},
{
"id": 2,
"name": "Bluetooth Keyboard",
"image": "https://snipe-it.local:8890/uploads/accessories/bluetooth.jpg",
"company": null,
"manufacturer": {
"id": 1,
"name": "Apple"
},
"supplier": {
"id": 4,
"name": "Lebsack, Thompson and Koelpin"
},
"model_number": "27672671",
"category": {
"id": 8,
"name": "Keyboards"
},
"location": {
"id": 4,
"name": "West Ofelia"
},
"notes": null,
"qty": 10,
"purchase_date": null,
"purchase_cost": null,
"order_number": null,
"min_qty": 2,
"remaining_qty": 10,
"users_count": 0,
"created_at": {
"datetime": "2023-12-13 05:55:51",
"formatted": "Wed Dec 13, 2023 5:55AM"
},
"updated_at": {
"datetime": "2023-12-13 05:55:51",
"formatted": "Wed Dec 13, 2023 5:55AM"
},
"available_actions": {
"checkout": true,
"checkin": false,
"update": true,
"delete": true,
"clone": true
},
"user_can_checkout": true
},
{
"id": 3,
"name": "Magic Mouse",
"image": "https://snipe-it.local:8890/uploads/accessories/magic-mouse.jpg",
"company": null,
"manufacturer": {
"id": 1,
"name": "Apple"
},
"supplier": {
"id": 3,
"name": "Streich Ltd"
},
"model_number": "40984097",
"category": {
"id": 9,
"name": "Mouse"
},
"location": {
"id": 4,
"name": "West Ofelia"
},
"notes": null,
"qty": 13,
"purchase_date": null,
"purchase_cost": null,
"order_number": null,
"min_qty": 2,
"remaining_qty": 13,
"users_count": 0,
"created_at": {
"datetime": "2023-12-13 05:55:51",
"formatted": "Wed Dec 13, 2023 5:55AM"
},
"updated_at": {
"datetime": "2023-12-13 05:55:51",
"formatted": "Wed Dec 13, 2023 5:55AM"
},
"available_actions": {
"checkout": true,
"checkin": false,
"update": true,
"delete": true,
"clone": true
},
"user_can_checkout": true
}
]
} |
Beta Was this translation helpful? Give feedback.
-
|
Obrigado! sobre API onde eu posso consultar? |
Beta Was this translation helpful? Give feedback.
-
|
Na documentação, claro :) Infelizmente, só está disponível em inglês :( API: https://snipe-it.readme.io/reference |
Beta Was this translation helpful? Give feedback.
-
|
Muito Obrigado! |
Beta Was this translation helpful? Give feedback.
-
|
De nada :) |
Beta Was this translation helpful? Give feedback.
-
Preciso de uma ajuda para saber onde localizo a quantidade de item disponível para a tabela de Acessórios e Periféricos.
conforme imagem em anexo:
Me ajudem!
Um Sniper do Brasil agradece! 😊
Beta Was this translation helpful? Give feedback.
All reactions