/ClientApp/ReportsTablewise/Sales/categorisesalesreport

Developing

POST

Request

Header Params

Body Params application/json

Example

{
"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"
}

Request samples

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

curl --location --request POST '/ClientApp/ReportsTablewise/Sales/categorisesalesreport' \
--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"
}'

Responses

🟢200Success

application/json

Body

Example

{
    "report_name": "Categorywise Report",
    "from_date": "2024-01-01 00:00",
    "to_date": "2024-01-02 11:59",
    "grandtotal": 134656,
    "offset": 0,
    "limit": 0,
    "shopname": "CAVVIAR",
    "shop_address": "abcd",
    "shop_mobileno": "9847098470",
    "reportgen": "2024-05-08 12:03:55.000+0530",
    "shop_gst": "12.5",
    "totaldiscount": 0,
    "total_count": 0,
    "list_coloumnname": [
        "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_reportdata": [
        {
            "itemid": 7,
            "itemname": "CARROT JUICE",
            "categorisename": "appam",
            "qty": 3,
            "price": 80,
            "itemtotal": 240
        },
        {
            "itemid": 48,
            "itemname": "PARCEL",
            "categorisename": "Coffee",
            "qty": 153,
            "price": 12,
            "itemtotal": 1836
        },
        {
            "itemid": 8,
            "itemname": "PINEAPPLE JUICE",
            "categorisename": "Coffee",
            "qty": 3,
            "price": 70,
            "itemtotal": 210
        },
        {
            "itemid": 69,
            "itemname": "BRIMSTO",
            "categorisename": "Coffee",
            "qty": 2,
            "price": 120,
            "itemtotal": 240
        },
        {
            "itemid": 31,
            "itemname": "CABBAGE VADA",
            "categorisename": "Coffee",
            "qty": 18,
            "price": 20,
            "itemtotal": 360
        },
        {
            "itemid": 25,
            "itemname": "GHEE PODI MASALA DOSA",
            "categorisename": "Coffee",
            "qty": 52,
            "price": 140,
            "itemtotal": 7280
        },
        {
            "itemid": 19,
            "itemname": "THATTU IDLI",
            "categorisename": "Coffee",
            "qty": 28,
            "price": 60,
            "itemtotal": 1680
        },
        {
            "itemid": 9,
            "itemname": "ABC JUICE",
            "categorisename": "Coffee",
            "qty": 4,
            "price": 100,
            "itemtotal": 400
        },
        {
            "itemid": 10,
            "itemname": "FRESH LIME",
            "categorisename": "Coffee",
            "qty": 19,
            "price": 30,
            "itemtotal": 570
        },
        {
            "itemid": 35,
            "itemname": "SAMBAR VADA",
            "categorisename": "Coffee",
            "qty": 2,
            "price": 50,
            "itemtotal": 100
        },
        {
            "itemid": 53,
            "itemname": "UPMA WITH BOILED BANANA",
            "categorisename": "EFG",
            "qty": 3,
            "price": 85,
            "itemtotal": 255
        },
        {
            "itemid": 4,
            "itemname": "WATERMELON JUICE",
            "categorisename": "juices",
            "qty": 11,
            "price": 75,
            "itemtotal": 825
        },
        {
            "itemid": 6,
            "itemname": "MUSAMBI JUICE",
            "categorisename": "juices",
            "qty": 1,
            "price": 70,
            "itemtotal": 70
        },
        {
            "itemid": 32,
            "itemname": "PAZHAM PORI",
            "categorisename": "Meals",
            "qty": 18,
            "price": 15,
            "itemtotal": 270
        },
        {
            "itemid": 20,
            "itemname": "MINI IDLI SAMBHAR",
            "categorisename": "subcategorytest",
            "qty": 44,
            "price": 80,
            "itemtotal": 3520
        },
        {
            "itemid": 23,
            "itemname": "GHEE DOSA",
            "categorisename": "subcategorytest",
            "qty": 119,
            "price": 90,
            "itemtotal": 10710
        },
        {
            "itemid": 17,
            "itemname": "IDLI",
            "categorisename": "subcategorytest",
            "qty": 47,
            "price": 20,
            "itemtotal": 940
        },
        {
            "itemid": 22,
            "itemname": "PLAIN DOSA SET",
            "categorisename": "subcategorytest",
            "qty": 40,
            "price": 60,
            "itemtotal": 2400
        },
        {
            "itemid": 21,
            "itemname": "GHEE PODI THATTU IDLI",
            "categorisename": "subcategorytest",
            "qty": 226,
            "price": 100,
            "itemtotal": 22600
        },
        {
            "itemid": 18,
            "itemname": "SET IDLI 3PCS",
            "categorisename": "subcategorytest",
            "qty": 161,
            "price": 60,
            "itemtotal": 9660
        }
    ]
}

🟠400Bad Request

Modified at 2024-05-15 11:59:17

/ClientApp/ReportsTablewise/Sales/itemsalesreport

/ClientApp/ReportsTablewise/Sales/get_reports_subkitchenwise