Skip to content

Instantly share code, notes, and snippets.

@intari

intari/gist:f13369a2bd6970aba856db4baa2326a7

Created June 14, 2018 16:39
Show Gist options
  • Save intari/f13369a2bd6970aba856db4baa2326a7 to your computer and use it in GitHub Desktop.
Save intari/f13369a2bd6970aba856db4baa2326a7 to your computer and use it in GitHub Desktop.
Download ZIP
март - http://37.29.76.15:8080/Data.svc/SalesByDate?$filter=PERNR eq '99000005' and Period eq '201804'
Raw
gistfile1.txt
{
"odata.metadata": "http://37.29.76.15:8080/Data.svc/$metadata#SalesByDate",
"value": [
{
"Period": "201804",
"PERNR": "99000005",
"Date": "2018-03-24T00:00:00",
"StoreID": "K393",
"PeriodDesc": "апрель 2018",
"PersonalHours": 0,
"CommonHours": 34,
"PersonalSales": "0.00",
"CommonSales": "0.00",
"Total": "12612.35"
},
{
"Period": "201804",
"PERNR": "99000005",
"Date": "2018-03-26T00:00:00",
"StoreID": "K393",
"PeriodDesc": "апрель 2018",
"PersonalHours": 8,
"CommonHours": 31,
"PersonalSales": "125.00",
"CommonSales": "32.26",
"Total": "12612.35"
},
{
"Period": "201804",
"PERNR": "99000005",
"Date": "2018-03-27T00:00:00",
"StoreID": "K393",
"PeriodDesc": "апрель 2018",
"PersonalHours": 11,
"CommonHours": 22,
"PersonalSales": "125.00",
"CommonSales": "62.50",
"Total": "12612.35"
},
{
"Period": "201804",
"PERNR": "99000005",
"Date": "2018-03-28T00:00:00",
"StoreID": "K393",
"PeriodDesc": "апрель 2018",
"PersonalHours": 11,
"CommonHours": 22,
"PersonalSales": "125.00",
"CommonSales": "62.50",
"Total": "12612.35"
},
{
"Period": "201804",
"PERNR": "99000005",
"Date": "2018-03-29T00:00:00",
"StoreID": "K393",
"PeriodDesc": "апрель 2018",
"PersonalHours": 7,
"CommonHours": 27,
"PersonalSales": "125.00",
"CommonSales": "32.41",
"Total": "12612.35"
},
{
"Period": "201804",
"PERNR": "99000005",
"Date": "2018-03-31T00:00:00",
"StoreID": "K393",
"PeriodDesc": "апрель 2018",
"PersonalHours": 0,
"CommonHours": 25,
"PersonalSales": "0.00",
"CommonSales": "0.00",
"Total": "12612.35"
},
{
"Period": "201804",
"PERNR": "99000005",
"Date": "2018-04-04T00:00:00",
"StoreID": "K393",
"PeriodDesc": "апрель 2018",
"PersonalHours": 11,
"CommonHours": 22,
"PersonalSales": "155.00",
"CommonSales": "222.45",
"Total": "12612.35"
},
{
"Period": "201804",
"PERNR": "99000005",
"Date": "2018-04-05T00:00:00",
"StoreID": "K393",
"PeriodDesc": "апрель 2018",
"PersonalHours": 11,
"CommonHours": 22,
"PersonalSales": "654.85",
"CommonSales": "383.05",
"Total": "12612.35"
},
{
"Period": "201804",
"PERNR": "99000005",
"Date": "2018-04-06T00:00:00",
"StoreID": "K393",
"PeriodDesc": "апрель 2018",
"PersonalHours": 11,
"CommonHours": 22,
"PersonalSales": "835.86",
"CommonSales": "786.67",
"Total": "12612.35"
},
{
"Period": "201804",
"PERNR": "99000005",
"Date": "2018-04-17T00:00:00",
"StoreID": "K393",
"PeriodDesc": "апрель 2018",
"PersonalHours": 7,
"CommonHours": 27,
"PersonalSales": "50.60",
"CommonSales": "344.84",
"Total": "12612.35"
},
{
"Period": "201804",
"PERNR": "99000005",
"Date": "2018-04-18T00:00:00",
"StoreID": "K393",
"PeriodDesc": "апрель 2018",
"PersonalHours": 7,
"CommonHours": 27,
"PersonalSales": "203.04",
"CommonSales": "170.18",
"Total": "12612.35"
},
{
"Period": "201804",
"PERNR": "99000005",
"Date": "2018-04-19T00:00:00",
"StoreID": "K393",
"PeriodDesc": "апрель 2018",
"PersonalHours": 11,
"CommonHours": 27,
"PersonalSales": "1044.73",
"CommonSales": "571.39",
"Total": "12612.35"
},
{
"Period": "201804",
"PERNR": "99000005",
"Date": "2018-04-21T00:00:00",
"StoreID": "K393",
"PeriodDesc": "апрель 2018",
"PersonalHours": 9,
"CommonHours": 34,
"PersonalSales": "196.40",
"CommonSales": "423.39",
"Total": "12612.35"
},
{
"Period": "201804",
"PERNR": "99000005",
"Date": "2018-04-22T00:00:00",
"StoreID": "K393",
"PeriodDesc": "апрель 2018",
"PersonalHours": 9,
"CommonHours": 38,
"PersonalSales": "1050.59",
"CommonSales": "549.05",
"Total": "12612.35"
},
{
"Period": "201804",
"PERNR": "99000005",
"Date": "2018-04-23T00:00:00",
"StoreID": "K393",
"PeriodDesc": "апрель 2018",
"PersonalHours": 7,
"CommonHours": 27,
"PersonalSales": "1217.99",
"CommonSales": "667.20",
"Total": "12612.35"
},
{
"Period": "201804",
"PERNR": "99000005",
"Date": "2018-04-24T00:00:00",
"StoreID": "K393",
"PeriodDesc": "апрель 2018",
"PersonalHours": 0,
"CommonHours": 26,
"PersonalSales": null,
"CommonSales": "0.00",
"Total": "12612.35"
},
{
"Period": "201804",
"PERNR": "99000005",
"Date": "2018-04-26T00:00:00",
"StoreID": "K393",
"PeriodDesc": "апрель 2018",
"PersonalHours": 11,
"CommonHours": 27,
"PersonalSales": "1329.44",
"CommonSales": "853.24",
"Total": "12612.35"
},
{
"Period": "201804",
"PERNR": "99000005",
"Date": "2018-04-27T00:00:00",
"StoreID": "K393",
"PeriodDesc": "апрель 2018",
"PersonalHours": 7,
"CommonHours": 27,
"PersonalSales": "3.00",
"CommonSales": "209.72",
"Total": "12612.35"
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment