{
"storelist":{
"storeinfo": {
"parentid": 239,
"shopname": "NAHDI PMNA",
"shoplogo": "",
"sts": true,
"store_list": [
{
"child_rowid": 19,
"shopname": "CAVVIAR",
"shopaddress": "abcd",
"shopmobile": "9847098470",
"shopemail": "abcd@gmail.com",
"shopgst": "12.5",
"shoplogo": "logo_cavviar.png",
"opentime": "00:00",
"closetime": "11:59",
"closetime_isnextday": true,
"isFranchiseoutlet": true,
"price_decimal_fraction": 2,
"quantity_decimal_fraction": 2,
"billtotal_roundoff": false,
"currency_symbol": "INR",
"shopdatabase": "javaserver",
"sts": true,
"isSelected": false,
"countryid": 1,
"countryname": "INDIA",
"last_synctime": "2024-01-27 09:52:40"
}
]
}
},
"offset":0,
"opendate":"2024-01-01",
"closedate":"2024-01-01"
}
curl --location --request POST '/ClientApp/ReportsTablewise/Sales/itemsalesreport' \
--header 'Authorization;' \
--header 'Content-Type: application/json' \
--data-raw '{
"storelist":{
"storeinfo": {
"parentid": 239,
"shopname": "NAHDI PMNA",
"shoplogo": "",
"sts": true,
"store_list": [
{
"child_rowid": 19,
"shopname": "CAVVIAR",
"shopaddress": "abcd",
"shopmobile": "9847098470",
"shopemail": "abcd@gmail.com",
"shopgst": "12.5",
"shoplogo": "logo_cavviar.png",
"opentime": "00:00",
"closetime": "11:59",
"closetime_isnextday": true,
"isFranchiseoutlet": true,
"price_decimal_fraction": 2,
"quantity_decimal_fraction": 2,
"billtotal_roundoff": false,
"currency_symbol": "INR",
"shopdatabase": "javaserver",
"sts": true,
"isSelected": false,
"countryid": 1,
"countryname": "INDIA",
"last_synctime": "2024-01-27 09:52:40"
}
]
}
},
"offset":0,
"opendate":"2024-01-01",
"closedate":"2024-01-01"
}'
{
"shopname": "CAVVIAR",
"shopmobile": "9847098470",
"shopaddress": "abcd",
"shopgst": "12.5",
"from_date": "2024-01-01 00:00",
"to_date": "2024-01-02 11:59",
"totaldiscount": 0,
"reportgen": "2024-05-08 10:25:26.000+0530",
"offset": 0,
"limit": 0,
"totalrecords": 50,
"nettotal": 134656,
"list_columname": [
"SlNo",
"Itemname",
"Categoryname",
"Quantity",
"Price",
"Total"
],
"list_columnproperty": [
{
"coloumName": "SlNo",
"coloumwidth": 10,
"coloumheight": 30,
"fontsize": 12,
"bold": false,
"alignment": "C"
},
{
"coloumName": "Itemname",
"coloumwidth": 10,
"coloumheight": 30,
"fontsize": 12,
"bold": false,
"alignment": "L"
},
{
"coloumName": "Categoryname",
"coloumwidth": 10,
"coloumheight": 30,
"fontsize": 12,
"bold": true,
"alignment": "L"
},
{
"coloumName": "Quantity",
"coloumwidth": 10,
"coloumheight": 30,
"fontsize": 12,
"bold": true,
"alignment": "R"
},
{
"coloumName": "Price",
"coloumwidth": 10,
"coloumheight": 30,
"fontsize": 12,
"bold": true,
"alignment": "R"
},
{
"coloumName": "Total",
"coloumwidth": 10,
"coloumheight": 30,
"fontsize": 12,
"bold": true,
"alignment": "R"
}
],
"list_data": [
{
"itemid": 9,
"itemname": "ABC JUICE",
"categoryname": "Coffee",
"qty": 4,
"rate": 100,
"total": 400
},
{
"itemid": 69,
"itemname": "BRIMSTO",
"categoryname": "Coffee",
"qty": 2,
"rate": 120,
"total": 240
},
{
"itemid": 31,
"itemname": "CABBAGE VADA",
"categoryname": "Coffee",
"qty": 18,
"rate": 20,
"total": 360
},
{
"itemid": 7,
"itemname": "CARROT JUICE",
"categoryname": "appam",
"qty": 3,
"rate": 80,
"total": 240
},
{
"itemid": 10,
"itemname": "FRESH LIME",
"categoryname": "Coffee",
"qty": 19,
"rate": 30,
"total": 570
},
{
"itemid": 23,
"itemname": "GHEE DOSA",
"categoryname": "subcategorytest",
"qty": 119,
"rate": 90,
"total": 10710
},
{
"itemid": 25,
"itemname": "GHEE PODI MASALA DOSA",
"categoryname": "Coffee",
"qty": 52,
"rate": 140,
"total": 7280
},
{
"itemid": 21,
"itemname": "GHEE PODI THATTU IDLI",
"categoryname": "subcategorytest",
"qty": 226,
"rate": 100,
"total": 22600
},
{
"itemid": 17,
"itemname": "IDLI",
"categoryname": "subcategorytest",
"qty": 47,
"rate": 20,
"total": 940
},
{
"itemid": 20,
"itemname": "MINI IDLI SAMBHAR",
"categoryname": "subcategorytest",
"qty": 44,
"rate": 80,
"total": 3520
},
{
"itemid": 6,
"itemname": "MUSAMBI JUICE",
"categoryname": "juices",
"qty": 1,
"rate": 70,
"total": 70
},
{
"itemid": 48,
"itemname": "PARCEL",
"categoryname": "Coffee",
"qty": 153,
"rate": 12,
"total": 1836
},
{
"itemid": 32,
"itemname": "PAZHAM PORI",
"categoryname": "Meals",
"qty": 18,
"rate": 15,
"total": 270
},
{
"itemid": 8,
"itemname": "PINEAPPLE JUICE",
"categoryname": "Coffee",
"qty": 3,
"rate": 70,
"total": 210
},
{
"itemid": 22,
"itemname": "PLAIN DOSA SET",
"categoryname": "subcategorytest",
"qty": 40,
"rate": 60,
"total": 2400
},
{
"itemid": 35,
"itemname": "SAMBAR VADA",
"categoryname": "Coffee",
"qty": 2,
"rate": 50,
"total": 100
},
{
"itemid": 18,
"itemname": "SET IDLI 3PCS",
"categoryname": "subcategorytest",
"qty": 161,
"rate": 60,
"total": 9660
},
{
"itemid": 19,
"itemname": "THATTU IDLI",
"categoryname": "Coffee",
"qty": 28,
"rate": 60,
"total": 1680
},
{
"itemid": 53,
"itemname": "UPMA WITH BOILED BANANA",
"categoryname": "EFG",
"qty": 3,
"rate": 85,
"total": 255
},
{
"itemid": 4,
"itemname": "WATERMELON JUICE",
"categoryname": "juices",
"qty": 11,
"rate": 75,
"total": 825
}
]
}