# ALRyiadh Report
جدول لعرض بيانات التقارير مع مجموعة من الفلاتر
- Branch: `Demo/Check_AlRiyadh`

## بيانات الجدول
- رقم التقرير (Id)
- حالة التقرير (Status)
- مدخل التقرير
- تاريخ ادخال التقرير
- عنصر التشوه الرئيسي (Form JSON)
- عنصر التشوه الفرعي (From JSON)
- الحملة (Campaign)
- الشارع (Location)
- الحي (Location Parents)
- البلدية (Location Parants)
## فلاتر الجدول
- التاريخ من - إلى (Date Rnage)
- رقم التقرير (TextBox)
- عنصر التشوه البصري (Multi Select DropDown)
- عنصر التشوه الفرعي (Multi Select DropDown)
- الحملة (Multi Select DropDown with search)
- البلدية (Single Select DropDown with search)
- الحي (Single Select DropDown with search)
- الشارع (Single Select DropDown with search)

## Notes

WITH Streets(Id, ShortCode, beaconName, ParentLocation, Name) as 
(
	SELECT 
		Id, ShortCode, beaconName, ParentLocation, Name
    FROM [dbo].[Locations] AS l
    Where l.LocationType = '4'
), 
Zones(Id, ShortCode, beaconName, ParentLocation, Name) as 
(
	SELECT 
		Id, ShortCode, beaconName, ParentLocation, Name
    FROM [dbo].[Locations] AS l
    Where l.LocationType = '3'
), 
Municipalities(Id, ShortCode, beaconName, Name) as 
(
	SELECT 
		Id, ShortCode, beaconName, Name
    FROM [dbo].[Locations] AS l
    Where l.LocationType = '2'
),
FlatStreets([Id], [StreetFlatCode], [StreetFullName], [MunName], [MunCode], [MunBeacon], [ZoneName], [ZoneCode], [ZoneBeacon], [StreetName], [StreetCode], [StreetBeacon]) as 
(
	SELECT 
		s.Id
		, CONCAT(m.beaconName, '-', z.beaconName, '-', s.beaconName) AS [StreetFlatCode]
		, CONCAT(N'شارع ', s.Name) AS [StreetFullName]
		, m.Name AS [MunName]
		, m.ShortCode AS [MunCode]
		, m.beaconName AS [MunBeacon]
		, z.Name AS [ZoneName]
		, z.ShortCode AS [ZoneCode]
		, z.beaconName AS [ZoneBeacon]
		, s.Name AS [StreetName]
		, s.ShortCode AS [StreetCode]
		, s.beaconName AS [StreetBeacon]
	FROM Streets AS s
	INNER JOIN Zones AS z ON s.ParentLocation = z.Id
	INNER JOIN Municipalities AS m ON z.ParentLocation = m.Id
)
select * from FlatStreets