reportiteminventory.php
The reportiteminventory.php service provides information about the reserved quantity. We have information about item_quantity and item_quantity_with_orders, and the difference between them represents the reserved quantity.
Method of sending data: POST
Requirements fields are :
| Name | Type | Decription |
|---|---|---|
| cmd | string | actualquantity |
Example of request
{
"body": [
{
"cmd": "actualquantity"
}
],
"IsEncrypted": false,
"ServerConfig": " objekti ServerConfig"
}ServerConfig: string object json
"IsEncrypted": false,
"ServerConfig": "{\"Url_API\":\"https://2rmlab.com/live/api\",\"DB_Config\":\"elif_config\",\"Company_DB_Name\":\"klient_2020_236\",\"HardwareId\":\"ab922b78eecb147f81bb3f10e615be62\",\"UserInfo\":{\"user_id\":212,\"username\":\"prove18\",\"password\":null,\"token\":\"cab642167044cacab140ee917fcd86252f778e7ffe44145bb5b36811dda1d13e99f0b082165f8833fbbdddfeb597492627321cd0ef628ccab8fe639043a9bf8e\"}}",
"Language": "sq-AL"
}TIP
CAREFUL!Clarification on ServerConfig (data that completes the request) while consuming the services.IsEncrypted: the attribute that calls the decryption function if it is true.
In this case ServerConfig is incomprehensible to read.
IsEncrypted: in case it is false, the ServerConfig attribute (property) which is a string which will be deserialized to return to the json object, must have the following fields required:
DB_Config and Company_DB_Name: The first represents the database in which the part of the configurations related to users and companies is located. If not completed it will take the value predefined by the backend. The second represents the database in which all other actions related to the user will be performed (not necessary for the login).If not completed it does not allow any kind of action in db and generates an error.
Database: object within the object which should have the following fields: Host_IP: database ip (can be local or remote) .e.g: 88.108.108.88. If not completed it will take the default value from the backend.
Port: the port at which the request is received according to the IP specified above. If not met it will receive the default value from the backend.
Password: the user password associated with the database. If not completed it will take the default value from the backend.
Password1: the use of password1 and password2 has not yet been verified. The purpose of use was to divide the password into two parts in such a way that one user does not have full control without cooperating with the other user.
Password2: the use of password1 and password2 has not yet been verified. The purpose of use was to divide the password into two parts in such a way that one user does not have full control without cooperating with the other user.
In each case there are 2 connections with 2 different databases which have in common IP, username, password and port.
If the app is in the same location as the database, then the Host_IP value is localhost, otherwise if the app and database are on different hosts, the value of the Host_IP in the request must be as real as the ip of the database location. psh: 88.108.108.88.
CAREFUL! When you get the ServerConfig copy paste do not leave spaces between objects as it will not be deserialized.
Example of reponse
{
"length": null,
"body": [
{
"item_id": 87,
"item_quantity": -7,
"item_quantity_with_orders": "-7"
},
{
"item_id": 184,
"item_quantity": 110,
"item_quantity_with_orders": "105"
},
{
"item_id": 71,
"item_quantity": 8,
"item_quantity_with_orders": "8"
},
{
"item_id": 68,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 51,
"item_quantity": 19,
"item_quantity_with_orders": "19"
},
{
"item_id": 304,
"item_quantity": -2,
"item_quantity_with_orders": "-3"
},
{
"item_id": 146,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 70,
"item_quantity": 10.6,
"item_quantity_with_orders": "10.6"
},
{
"item_id": 52,
"item_quantity": 12,
"item_quantity_with_orders": "12"
},
{
"item_id": 190,
"item_quantity": 1,
"item_quantity_with_orders": "1"
},
{
"item_id": 258,
"item_quantity": 2,
"item_quantity_with_orders": "2"
},
{
"item_id": 132,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 278,
"item_quantity": 1,
"item_quantity_with_orders": "1"
},
{
"item_id": 84,
"item_quantity": 7,
"item_quantity_with_orders": "7"
},
{
"item_id": 170,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 176,
"item_quantity": 16,
"item_quantity_with_orders": "16"
},
{
"item_id": 330,
"item_quantity": 5,
"item_quantity_with_orders": "5"
},
{
"item_id": 101,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 69,
"item_quantity": -1,
"item_quantity_with_orders": "-1"
},
{
"item_id": 262,
"item_quantity": 6,
"item_quantity_with_orders": "6"
},
{
"item_id": 292,
"item_quantity": 24,
"item_quantity_with_orders": "24"
},
{
"item_id": 323,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 114,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 112,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 108,
"item_quantity": -14,
"item_quantity_with_orders": "-15"
},
{
"item_id": 271,
"item_quantity": 1,
"item_quantity_with_orders": "1"
},
{
"item_id": 22,
"item_quantity": 3,
"item_quantity_with_orders": "2"
},
{
"item_id": 59,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 197,
"item_quantity": 1,
"item_quantity_with_orders": "1"
},
{
"item_id": 65,
"item_quantity": 2,
"item_quantity_with_orders": "2"
},
{
"item_id": 127,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 149,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 173,
"item_quantity": 148,
"item_quantity_with_orders": "148"
},
{
"item_id": 73,
"item_quantity": 3,
"item_quantity_with_orders": "3"
},
{
"item_id": 200,
"item_quantity": 16,
"item_quantity_with_orders": "16"
},
{
"item_id": 329,
"item_quantity": 1,
"item_quantity_with_orders": "1"
},
{
"item_id": 311,
"item_quantity": 7,
"item_quantity_with_orders": "7"
},
{
"item_id": 11,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 44,
"item_quantity": 29,
"item_quantity_with_orders": "29"
},
{
"item_id": 261,
"item_quantity": 2,
"item_quantity_with_orders": "2"
},
{
"item_id": 280,
"item_quantity": 160,
"item_quantity_with_orders": "160"
},
{
"item_id": 42,
"item_quantity": 2,
"item_quantity_with_orders": "2"
},
{
"item_id": 189,
"item_quantity": 1,
"item_quantity_with_orders": "1"
},
{
"item_id": 117,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 88,
"item_quantity": 12,
"item_quantity_with_orders": "12"
},
{
"item_id": 82,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 40,
"item_quantity": 9,
"item_quantity_with_orders": "9"
},
{
"item_id": 286,
"item_quantity": -1,
"item_quantity_with_orders": "-1"
},
{
"item_id": 306,
"item_quantity": 0,
"item_quantity_with_orders": "-2"
},
{
"item_id": 43,
"item_quantity": -50,
"item_quantity_with_orders": "-50"
},
{
"item_id": 153,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 328,
"item_quantity": 2,
"item_quantity_with_orders": "2"
},
{
"item_id": 147,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 279,
"item_quantity": 1,
"item_quantity_with_orders": "1"
},
{
"item_id": 9,
"item_quantity": 3,
"item_quantity_with_orders": "3"
},
{
"item_id": 120,
"item_quantity": -1,
"item_quantity_with_orders": "-1"
},
{
"item_id": 291,
"item_quantity": 5,
"item_quantity_with_orders": "5"
},
{
"item_id": 48,
"item_quantity": 30,
"item_quantity_with_orders": "30"
},
{
"item_id": 85,
"item_quantity": -5,
"item_quantity_with_orders": "-5"
},
{
"item_id": 187,
"item_quantity": 4,
"item_quantity_with_orders": "4"
},
{
"item_id": 72,
"item_quantity": 6,
"item_quantity_with_orders": "6"
},
{
"item_id": 281,
"item_quantity": 79,
"item_quantity_with_orders": "79"
},
{
"item_id": 57,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 19,
"item_quantity": 2,
"item_quantity_with_orders": "2"
},
{
"item_id": 81,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 244,
"item_quantity": 250,
"item_quantity_with_orders": "250"
},
{
"item_id": 77,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 259,
"item_quantity": 2,
"item_quantity_with_orders": "2"
},
{
"item_id": 172,
"item_quantity": -2,
"item_quantity_with_orders": "-2"
},
{
"item_id": 302,
"item_quantity": 75,
"item_quantity_with_orders": "73"
},
{
"item_id": 30,
"item_quantity": 4,
"item_quantity_with_orders": "4"
},
{
"item_id": 131,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 3,
"item_quantity": 37,
"item_quantity_with_orders": "32"
},
{
"item_id": 17,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 324,
"item_quantity": 152,
"item_quantity_with_orders": "152"
},
{
"item_id": 28,
"item_quantity": 3,
"item_quantity_with_orders": "3"
},
{
"item_id": 251,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 266,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 5,
"item_quantity": -1,
"item_quantity_with_orders": "-2"
},
{
"item_id": 249,
"item_quantity": 10,
"item_quantity_with_orders": "10"
},
{
"item_id": 315,
"item_quantity": 2,
"item_quantity_with_orders": "2"
},
{
"item_id": 255,
"item_quantity": 20,
"item_quantity_with_orders": "20"
},
{
"item_id": 307,
"item_quantity": 0,
"item_quantity_with_orders": "-1"
},
{
"item_id": 56,
"item_quantity": 3,
"item_quantity_with_orders": "3"
},
{
"item_id": 91,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 151,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 54,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 29,
"item_quantity": 0.15,
"item_quantity_with_orders": "0.15"
},
{
"item_id": 305,
"item_quantity": -1,
"item_quantity_with_orders": "-2"
},
{
"item_id": 4,
"item_quantity": 12.2846154,
"item_quantity_with_orders": "12.284615384615"
},
{
"item_id": 34,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 96,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 67,
"item_quantity": 1,
"item_quantity_with_orders": "1"
},
{
"item_id": 83,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 303,
"item_quantity": 176,
"item_quantity_with_orders": "176"
},
{
"item_id": 63,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 90,
"item_quantity": -17,
"item_quantity_with_orders": "-17"
},
{
"item_id": 10,
"item_quantity": 1.3,
"item_quantity_with_orders": "1.3"
},
{
"item_id": 325,
"item_quantity": 1,
"item_quantity_with_orders": "1"
},
{
"item_id": 105,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 35,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 45,
"item_quantity": 25,
"item_quantity_with_orders": "25"
},
{
"item_id": 174,
"item_quantity": 1813,
"item_quantity_with_orders": "1813"
},
{
"item_id": 295,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 107,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 6,
"item_quantity": 0.71,
"item_quantity_with_orders": "-48.29"
},
{
"item_id": 274,
"item_quantity": 1,
"item_quantity_with_orders": "1"
},
{
"item_id": 86,
"item_quantity": -15,
"item_quantity_with_orders": "-16"
},
{
"item_id": 144,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 39,
"item_quantity": 23,
"item_quantity_with_orders": "23"
},
{
"item_id": 93,
"item_quantity": -14,
"item_quantity_with_orders": "-14"
},
{
"item_id": 89,
"item_quantity": 2,
"item_quantity_with_orders": "2"
},
{
"item_id": 36,
"item_quantity": 2,
"item_quantity_with_orders": "2"
},
{
"item_id": 252,
"item_quantity": 12,
"item_quantity_with_orders": "12"
},
{
"item_id": 327,
"item_quantity": 1,
"item_quantity_with_orders": "1"
},
{
"item_id": 50,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 253,
"item_quantity": 20,
"item_quantity_with_orders": "20"
},
{
"item_id": 102,
"item_quantity": 98,
"item_quantity_with_orders": "98"
},
{
"item_id": 14,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 312,
"item_quantity": 11,
"item_quantity_with_orders": "11"
},
{
"item_id": 66,
"item_quantity": 2,
"item_quantity_with_orders": "2"
},
{
"item_id": 290,
"item_quantity": 0,
"item_quantity_with_orders": "-2"
},
{
"item_id": 118,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 111,
"item_quantity": 10,
"item_quantity_with_orders": "10"
},
{
"item_id": 195,
"item_quantity": 5,
"item_quantity_with_orders": "5"
},
{
"item_id": 2,
"item_quantity": 57.4,
"item_quantity_with_orders": "57.4"
},
{
"item_id": 16,
"item_quantity": 6,
"item_quantity_with_orders": "6"
},
{
"item_id": 62,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 166,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 243,
"item_quantity": 6,
"item_quantity_with_orders": "6"
},
{
"item_id": 326,
"item_quantity": 1,
"item_quantity_with_orders": "1"
},
{
"item_id": 99,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 142,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 41,
"item_quantity": 3,
"item_quantity_with_orders": "3"
},
{
"item_id": 152,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 32,
"item_quantity": 12,
"item_quantity_with_orders": "12"
},
{
"item_id": 53,
"item_quantity": 17,
"item_quantity_with_orders": "17"
},
{
"item_id": 301,
"item_quantity": -229,
"item_quantity_with_orders": "-229"
},
{
"item_id": 7,
"item_quantity": 1,
"item_quantity_with_orders": "0"
},
{
"item_id": 275,
"item_quantity": 4,
"item_quantity_with_orders": "4"
},
{
"item_id": 260,
"item_quantity": 7,
"item_quantity_with_orders": "7"
},
{
"item_id": 308,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 100,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 183,
"item_quantity": -5814,
"item_quantity_with_orders": "-5814"
},
{
"item_id": 38,
"item_quantity": 0,
"item_quantity_with_orders": "-2"
},
{
"item_id": 150,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 193,
"item_quantity": 6,
"item_quantity_with_orders": "6"
},
{
"item_id": 12,
"item_quantity": 0.14,
"item_quantity_with_orders": "-0.86"
},
{
"item_id": 254,
"item_quantity": 20,
"item_quantity_with_orders": "20"
},
{
"item_id": 293,
"item_quantity": 2,
"item_quantity_with_orders": "2"
},
{
"item_id": 78,
"item_quantity": 17,
"item_quantity_with_orders": "17"
},
{
"item_id": 24,
"item_quantity": 3,
"item_quantity_with_orders": "3"
},
{
"item_id": 191,
"item_quantity": 1.85,
"item_quantity_with_orders": "1.85"
},
{
"item_id": 25,
"item_quantity": 3,
"item_quantity_with_orders": "3"
},
{
"item_id": 94,
"item_quantity": 5,
"item_quantity_with_orders": "5"
},
{
"item_id": 186,
"item_quantity": -82,
"item_quantity_with_orders": "-82"
},
{
"item_id": 250,
"item_quantity": 1,
"item_quantity_with_orders": "1"
},
{
"item_id": 49,
"item_quantity": 40,
"item_quantity_with_orders": "40"
},
{
"item_id": 316,
"item_quantity": -1,
"item_quantity_with_orders": "-1"
},
{
"item_id": 47,
"item_quantity": 110,
"item_quantity_with_orders": "110"
},
{
"item_id": 256,
"item_quantity": 2,
"item_quantity_with_orders": "2"
},
{
"item_id": 182,
"item_quantity": 5,
"item_quantity_with_orders": "5"
},
{
"item_id": 33,
"item_quantity": 0,
"item_quantity_with_orders": "-1"
},
{
"item_id": 1,
"item_quantity": 2989583.16,
"item_quantity_with_orders": "2989581.16"
},
{
"item_id": 76,
"item_quantity": 3,
"item_quantity_with_orders": "3"
},
{
"item_id": 18,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 185,
"item_quantity": -98,
"item_quantity_with_orders": "-98"
},
{
"item_id": 264,
"item_quantity": 5,
"item_quantity_with_orders": "5"
},
{
"item_id": 64,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 110,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 55,
"item_quantity": -3,
"item_quantity_with_orders": "-3"
},
{
"item_id": 145,
"item_quantity": 1,
"item_quantity_with_orders": "1"
},
{
"item_id": 130,
"item_quantity": -2,
"item_quantity_with_orders": "-2"
},
{
"item_id": 148,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 27,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 129,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 143,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 23,
"item_quantity": 0,
"item_quantity_with_orders": "0"
},
{
"item_id": 270,
"item_quantity": 3,
"item_quantity_with_orders": "3"
},
{
"item_id": 8,
"item_quantity": 1,
"item_quantity_with_orders": "0"
}
],
"status": {
"code": 600,
"message": "Success!"
},
"response_sent_time": "2024-02-02 14:23:44"
}