True
qualiex_audit_queries
9NbR68RN84FsW7X05+xpHsT0U2BNVlG8a0zV9GMc5T+L8tHLx07DxOlcvdRNRGAqkEZPKElRqc3tW/E0YQCgI5BY/4hFXXvNaVLZ9Mp4oCqJdMHCTV3TmWtBTdhKdCRjxBj7KMVoc83iRKG9ei2lP9HywYJLVtP4YU1NmMTYbT+QesmKzQNDvGsVpaVjKHcnwtI=
fb76c22faa6c4dd6a3708afed6fc3ae4
qualiex_audit_queries
PARAMS
logo_img,System.Drawing.Image
logo_footer_img,System.Drawing.Image
be1d4a82ab5547fca9ec96bad8c9fa52
PARAMS
PARAMS
params_values
OffsetMinutes,System.Int32
date_from,System.String
date_until,System.String
30
d0e7fb11869d41569eed748df6d941cb
params_values
qualiex_audit_queries
OffsetMinutes,OffsetMinutes,8,0
DateFrom,DateFrom,31,0
DateUntil,DateUntil,31,0
SELECT
Format(@DateFrom, 'dd/MM/yyyy') AS date_from
,Format(@DateUntil, 'dd/MM/yyyy') AS date_until
,OffsetMinutes
FROM
(
VALUES
(@OffsetMinutes)
) AS x (OffsetMinutes)
company
ORIGINAL,name,name,name,System.String,_x0031_61fa7d5e7b24f6ca677774b2457c9f2
30
7a4a72c06a87439796704c58a54d28ac
company
qualiex_audit_queries
CompanyId,CompanyId,3,8
select name from companies where id = @CompanyId
answer_options
ORIGINAL,name_item,name_item,name_item,System.String,bfcf6cac1aea4d83862a07a54b65a45e
ORIGINAL,count_item,count_item,count_item,System.String,a3c884b5c836497d94ef1875e805f9e2
ORIGINAL,id_item,id_item,id_item,System.String,_x0034_1ef77644702412089518a6dafe0fa6c
30
6c0e57b835694b0d9c2db635af8f4370
answer_options
qualiex_audit_queries
Auditings,,22,1000
CompanyId,CompanyId,3,8
StandardId,StandardId,3,8
PlanningPlaceId,PlanningPlaceId,3,8
DateFrom,DateFrom,31,0
DateUntil,DateUntil,31,0
WITH
cte_auditings_plans
AS
(
SELECT sr.id_standard
,ap.id AS id_auditing_plan
FROM auditings a
INNER JOIN auditings_plans ap ON (ap.id_auditing = a.id AND a.id_company=@CompanyId AND a.removed=0 AND ap.removed=0)
INNER JOIN auditings_plans_standards aps ON (aps.id_auditing_plan = ap.id)
INNER JOIN standards_revisions sr ON (sr.id = aps.id_revision AND sr.removed=0 AND sr.id_standard=@StandardId)
WHERE a.id IN (SELECT value
FROM string_split(@Auditings,','))
AND (@PlanningPlaceId IS NULL OR ap.id_place=@PlanningPlaceId)
AND (
(CONVERT(DATE, a.start_date) BETWEEN ISNULL(@DateFrom, '19000101') AND ISNULL(@DateUntil, '99991231'))
OR (@DateFrom IS NULL AND @DateUntil IS NULL)
)
)
,cte_plans_items
AS
(
SELECT
ap.id_standard
,api.title_pt_br AS name
,COUNT(api.id_answered_item) AS value
,api.id_answered_item
,api.id_answer
FROM cte_auditings_plans ap
INNER JOIN auditings_plans_items api ON (api.id_auditing_plan = ap.id_auditing_plan AND api.removed=0)
INNER JOIN standards_items si ON (si.id = api.id_standard_item AND si.removed=0)
INNER JOIN standards_revisions sr ON (sr.id = si.id_revision AND sr.removed=0 AND sr.id_standard=@StandardId)
WHERE si.id_answer IS NOT NULL
GROUP BY api.title_pt_br, api.id_answer, api.id_answered_item, ap.id_standard, api.id_answered_item
)
,cte_items
AS
(
SELECT
ani.id AS id_item
,CONCAT(ani.name_pt_br, ' - ', an.name_pt_br) AS name_item
,an.id AS id_answer
FROM cte_plans_items si
INNER JOIN answers an ON (an.id = si.id_answer)
INNER JOIN answers_items ani ON (ani.id_answer = an.id)
GROUP BY ani.id, an.id, ani.name_pt_br, an.name_pt_br
)
SELECT
i.name_item
,ISNULL(SUM(ci.value),0) AS count_item
FROM cte_items i
LEFT JOIN cte_plans_items ci ON (ci.id_answered_item = i.id_item)
GROUP BY i.name_item, i.id_item, i.id_answer
ORDER BY i.id_answer, i.id_item
pie_chart
ORIGINAL,name,name,name,System.String,_x0035_76057f97d7444b383c1724e672b3ab1
ORIGINAL,value,value,value,System.Int32,_x0038_a518e00002645e5baefae30ce8d2082
ORIGINAL,color,color,color,System.String,_x0033_f286320598043ccb540bdb7dfb090ad
30
742ffded4c6543af90bf0d4ccb2b8a08
pie_chart
qualiex_audit_queries
StandardId,StandardId,3,8
Auditings,Auditings,22,1000
CompanyId,CompanyId,3,8
PlanningPlaceId,PlanningPlaceId,3,8
DateFrom,DateFrom,31,0
DateUntil,DateUntil,31,0
WITH
cte_auditings_plans
AS
(
SELECT sr.id_standard
,ap.id AS id_auditing_plan
FROM auditings a
INNER JOIN auditings_plans ap ON (ap.id_auditing = a.id AND a.id_company=@CompanyId AND a.removed=0 AND ap.removed=0)
INNER JOIN auditings_plans_standards aps ON (aps.id_auditing_plan = ap.id)
INNER JOIN standards_revisions sr ON (sr.id = aps.id_revision AND sr.removed=0 AND sr.id_standard=@StandardId)
WHERE a.id IN (SELECT value
FROM string_split(@Auditings,','))
AND (@PlanningPlaceId IS NULL OR ap.id_place=@PlanningPlaceId)
AND (
(CONVERT(DATE, a.start_date) BETWEEN ISNULL(@DateFrom, '19000101') AND ISNULL(@DateUntil, '99991231'))
OR (@DateFrom IS NULL AND @DateUntil IS NULL)
)
)
,cte_plans_items
AS
(
SELECT
ap.id_standard
,api.title_pt_br AS name
,COUNT(api.id_answered_item) AS value
,api.id_answered_item
,api.id_answer
FROM cte_auditings_plans ap
INNER JOIN auditings_plans_items api ON (api.id_auditing_plan = ap.id_auditing_plan AND api.removed=0)
INNER JOIN standards_items si ON (si.id = api.id_standard_item AND si.removed=0)
INNER JOIN standards_revisions sr ON (sr.id = si.id_revision AND sr.removed=0 AND sr.id_standard=@StandardId)
INNER JOIN answers_items ani ON (ani.id = api.id_answered_item)
WHERE si.id_answer IS NOT NULL
GROUP BY api.title_pt_br, api.id_answer, api.id_answered_item, ap.id_standard, api.id_answered_item
)
,cte_items
AS
(
SELECT
an.id
,si.id_standard
,ani.id AS id_item
,CONCAT(ani.name_pt_br, ' - ', an.name_pt_br) AS name_item
,LEFT(ani.color + '000000', 7) AS color
FROM cte_plans_items si
INNER JOIN answers an ON (an.id = si.id_answer )
INNER JOIN answers_items ani ON (ani.id_answer = an.id)
GROUP BY ani.id, an.id, si.id_standard, ani.color, ani.name_pt_br, an.name_pt_br
)
,cte_standards
AS
(
SELECT
i.name
,i.id_standard
FROM cte_plans_items i
GROUP BY name, i.id_standard
)
SELECT
CONCAT(i.name_item, ': ', SUM(ci.value), ' (', CAST(CAST(SUM(ci.value) AS DECIMAL(15,2)) / (SELECT SUM(value)
FROM cte_plans_items) * 100 AS DECIMAL(15,2)),'%)') AS name
,SUM(ci.value) AS value
,i.color
FROM cte_items i
INNER JOIN cte_plans_items ci ON (ci.id_answered_item = i.id_item)
GROUP BY i.name_item, i.color
adherence
name,System.String
percentage,System.String
30
4e6dd3d8be2e4cb18a9b5f17236aa0a2
adherence
qualiex_audit_queries
StandardId,StandardId,3,8
AnswerId,AnswerId,3,8
CompanyId,CompanyId,3,8
Auditings,Auditings,22,1000
Lang,,3,8
PlanningPlaceId,PlanningPlaceId,3,8
DateFrom,DateFrom,31,0
DateUntil,DateUntil,31,0
WITH cte_auditings_plans as (
SELECT sr.id_standard,
ap.id as id_auditing_plan
FROM auditings a
INNER JOIN auditings_plans ap on (ap.id_auditing = a.id and a.id_company=@CompanyId and a.removed=0 and ap.removed=0)
INNER JOIN auditings_plans_standards aps on (aps.id_auditing_plan = ap.id)
INNER JOIN standards_revisions sr ON (sr.id = aps.id_revision and sr.removed=0 and sr.id_standard=@StandardId)
WHERE a.id in (SELECT value FROM string_split(@Auditings,','))
AND (@PlanningPlaceId is null or ap.id_place=@PlanningPlaceId)
AND (
(CONVERT(DATE, a.start_date) BETWEEN ISNULL(@DateFrom, '19000101') AND ISNULL(@DateUntil, '99991231'))
OR (@DateFrom IS NULL AND @DateUntil IS NULL)
)
),
cte_plans_items as (
SELECT
ap.id_standard,
api.title_pt_br as name,
COUNT(api.id_answered_item) as value,
api.id_answered_item,
api.id_answer
FROM cte_auditings_plans ap
INNER JOIN auditings_plans_items api on (api.id_auditing_plan = ap.id_auditing_plan and api.removed=0)
INNER JOIN standards_items si ON (si.id = api.id_standard_item and si.removed=0)
INNER JOIN standards_revisions sr on (sr.id = si.id_revision and sr.removed=0 and sr.id_standard=@StandardId)
INNER JOIN answers_items ani on (ani.id = api.id_answered_item and ani.not_computable=0)
WHERE si.id_answer is not null
GROUP BY api.title_pt_br, api.id_answer, api.id_answered_item, ap.id_standard, api.id_answered_item
),
cte_items as (
SELECT
ani.id as id_item,
CONCAT(ani.name_pt_br, ' - ', an.name_pt_br) as name_item
FROM cte_plans_items si
INNER JOIN answers an on (an.id = si.id_answer )
INNER JOIN answers_items ani on (ani.id_answer = an.id and ani.not_computable=0)
WHERE ani.id=@AnswerId
GROUP BY ani.id, ani.name_pt_br, an.name_pt_br
)
SELECT
CASE WHEN @Lang='pt-br'
THEN CONCAT('Aderência: ',i.name_item)
WHEN @Lang='es'
THEN CONCAT('Adherencia: ',i.name_item)
ELSE
CONCAT('Adherence: ',i.name_item)
END as name,
CONCAT(ISNULL(CAST(CAST(SUM(ci.value) AS decimal(15,2)) / (SELECT SUM(value) FROM cte_plans_items) * 100 AS decimal(15,2)), '0.00'),'%') as percentage
FROM cte_items i
LEFT JOIN cte_plans_items ci on (ci.id_answered_item = i.id_item)
GROUP BY i.name_item
item_name
value_calc,System.String
name,System.String
30
5c6ae7faf97643a1b9b89a4fbb7e72b4
item_name
qualiex_audit_queries
StandardId,StandardId,3,8
Auditings,Auditings,22,1000
AnswerId,AnswerId,3,8
CompanyId,CompanyId,3,8
PlanningPlaceId,PlanningPlaceId,3,8
DateFrom,DateFrom,31,0
DateUntil,DateUntil,31,0
WITH cte_auditings_plans as (
SELECT sr.id_standard,
ap.id as id_auditing_plan
FROM auditings a
INNER JOIN auditings_plans ap on (a.id_company=@CompanyId and ap.id_auditing = a.id and a.removed=0 and ap.removed=0)
INNER JOIN auditings_plans_standards aps on (aps.id_auditing_plan = ap.id)
INNER JOIN standards_revisions sr ON (sr.id = aps.id_revision and sr.removed=0 and sr.id_standard=@StandardId)
WHERE a.id in (SELECT value FROM string_split(@Auditings,','))
AND (@PlanningPlaceId is null or ap.id_place=@PlanningPlaceId)
AND (
(CONVERT(DATE, a.start_date) BETWEEN ISNULL(@DateFrom, '19000101') AND ISNULL(@DateUntil, '99991231'))
OR (@DateFrom IS NULL AND @DateUntil IS NULL)
)
GROUP BY sr.id_standard, ap.id
),
cte_plans_items as (
SELECT
ap.id_standard,
api.title_pt_br as name,
COUNT(api.id_answered_item) as value,
api.id_answered_item,
api.id_answer
FROM cte_auditings_plans ap
INNER JOIN auditings_plans_items api on (api.id_auditing_plan = ap.id_auditing_plan and api.removed=0)
INNER JOIN standards_items si ON (si.id = api.id_standard_item and si.removed=0)
INNER JOIN standards_revisions sr on (sr.id = si.id_revision and sr.removed=0 and sr.id_standard=@StandardId)
WHERE si.id_answer is not null
GROUP BY api.title_pt_br, api.id_answer, api.id_answered_item, ap.id_standard, api.id_answered_item
),
cte_items as (
SELECT
an.id,
si.id_standard,
ani.id as id_item
FROM cte_plans_items si
INNER JOIN answers an on (an.id = si.id_answer )
INNER JOIN answers_items ani on (ani.id_answer = an.id and ani.not_computable=0)
GROUP BY ani.id, an.id, si.id_standard
),
cte_standards as (
SELECT
i.name,
i.id_standard
FROM cte_plans_items i
GROUP BY name, i.id_standard
),
cte as (
SELECT
s.name,
i.id_item,
ISNULL(ci.value,0) AS value
FROM cte_standards s
LEFT JOIN cte_items i on (s.id_standard = i.id_standard)
LEFT JOIN cte_plans_items ci on (ci.name = s.name and ci.id_answered_item=i.id_item)
GROUP BY s.name, i.id_item, i.id, ci.value
),
cte_aderencia as (
SELECT
c.name,
SUM(c.value) as value
FROM cte c
WHERE c.id_item=@AnswerId
GROUP By c.name
),
cte_tot as (
SELECT
c.name,
SUM(c.value) as value
FROM cte c
GROUP BY c.name
)
SELECT
t.name,
case when t.value = 0
then '0,00%'
else CONCAT(CAST(CAST(a.value as decimal(15,2)) / cast(t.value as decimal(15,2)) * 100 AS decimal(15,2)), '%')
end as value_calc
FROM cte_tot t
LEFT JOIN cte_aderencia a on (t.name = a.name)
ORDER BY CAST(SUBSTRING(t.name, 1, PATINDEX('%[^0-9]%', t.name + ' ') - 1) AS INT), t.name
item_value
name,System.String
id_item,System.String
value,System.Int32
30
9216a8a2f1774b9d9d0951c976174a50
item_value
qualiex_audit_queries
StandardId,StandardId,3,8
Auditings,Auditings,22,1000
CompanyId,CompanyId,3,8
PlanningPlaceId,PlanningPlaceId,3,8
DateFrom,DateFrom,31,0
DateUntil,DateUntil,31,0
WITH
cte_auditings_plans
AS
(
SELECT sr.id_standard
,ap.id AS id_auditing_plan
FROM auditings a
INNER JOIN auditings_plans ap ON (a.id_company=@CompanyId AND ap.id_auditing = a.id AND a.removed=0 AND ap.removed=0)
INNER JOIN auditings_plans_standards aps ON (aps.id_auditing_plan = ap.id)
INNER JOIN standards_revisions sr ON (sr.id = aps.id_revision AND sr.removed=0 AND sr.id_standard=@StandardId)
WHERE a.id IN (SELECT value
FROM string_split(@Auditings,','))
AND (@PlanningPlaceId IS NULL OR ap.id_place=@PlanningPlaceId)
AND (
(CONVERT(DATE, a.start_date) BETWEEN ISNULL(@DateFrom, '19000101') AND ISNULL(@DateUntil, '99991231'))
OR (@DateFrom IS NULL AND @DateUntil IS NULL)
)
)
,cte_plans_items
AS
(
SELECT
ap.id_standard
,api.title_pt_br AS name
,COUNT(api.id_answered_item) AS value
,api.id_answered_item
,api.id_answer
FROM cte_auditings_plans ap
INNER JOIN auditings_plans_items api ON (api.id_auditing_plan = ap.id_auditing_plan AND api.removed=0)
INNER JOIN standards_items si ON (si.id = api.id_standard_item AND si.removed=0)
INNER JOIN standards_revisions sr ON (sr.id = si.id_revision AND sr.removed=0 AND sr.id_standard=@StandardId)
WHERE si.id_answer IS NOT NULL
GROUP BY api.title_pt_br, api.id_answer, api.id_answered_item, ap.id_standard, api.id_answered_item
)
,cte_items
AS
(
SELECT
an.id
,si.id_standard
,ani.id AS id_item
FROM cte_plans_items si
INNER JOIN answers an ON (an.id = si.id_answer )
INNER JOIN answers_items ani ON (ani.id_answer = an.id)
GROUP BY ani.id, an.id, si.id_standard
)
,cte_standards
AS
(
SELECT
i.name
,i.id_standard
FROM cte_plans_items i
GROUP BY name, i.id_standard
)
SELECT
s.name
,i.id_item
,ISNULL(ci.value,0) AS value
FROM cte_standards s
LEFT JOIN cte_items i ON (s.id_standard = i.id_standard)
LEFT JOIN cte_plans_items ci ON (ci.name = s.name AND ci.id_answered_item=i.id_item)
GROUP BY s.name, i.id_item, i.id, ci.value
ORDER BY s.name, i.id, i.id_item
filter_place
audit_place,System.String
planning_place,System.String
30
8c6d9846cc5f49d0917c7f6ee81021d3
filter_place
qualiex_audit_queries
AuditPlaceId,AuditPlaceId,3,8
PlanningPlaceId,PlanningPlaceId,3,8
SELECT
(SELECT p.name FROM places p WHERE p.id=@AuditPlaceId) as audit_place,
(SELECT p.name FROM places p WHERE p.id=@PlanningPlaceId) as planning_place
report_language
Lang,System.String
30
9040a50fb63641d78333c96e6414a1c4
report_language
qualiex_audit_queries
UserId,UserId,3,8
select case when id_language = 1 then 'en-US'
when id_language = 2 then 'pt-BR' else 'es-ES' end as Lang
from dbo.users
where id=@UserId
nome
name
144a2904f8a84ecd9ff9c9821ab6d817
nome
Relação
name
,OffsetMinutes,OffsetMinutes,,System.Int32,_x0039_0,False,False,False,False
,CompanyId,CompanyId,,System.String,,False,False,False,False
,StandardId,StandardId,,System.String,,False,False,False,False
,AuditPlaceId,AuditPlaceId,,System.String,,False,False,False,False,,d53a63d390e74ed6b612f9bc2377af37
,Auditings,Auditings,,System.String,,False,False,False,False
,PlanningPlaceId,PlanningPlaceId,,System.String,,False,False,False,False,,_x0038_776230732ff42a6bff96655815e3912
,AnswerId,AnswerId,,System.String,,False,False,False,False
,UserId,UserId,,System.String,,False,False,False,False
,Lang,Lang,,System.String,,False,False,False,False
,DateFrom,DateFrom,,System.DateTime,_x0039__x002F_13_x002F_2023_x0020_1:23:41_x0020_PM,False,False,False,False
,DateUntil,DateUntil,,System.DateTime,_x0039__x002F_13_x002F_2023_x0020_1:24:06_x0020_PM,False,False,False,False
EngineV2
pt-BR
Text3.Text,Página_x0020__x007B_PageNumber_x007D__x0020_de_x0020__x007B_TotalPageCount_x007D_._x000D__x000A_Visualizado_x0020_em_x0020__x007B_GetDateTimeOffset_x0028_DateTimeOffset.Now_x0029_.ToString_x0028__x0022_dd_x002F_MM_x002F_yyyy_x0022__x0029__x007D__x0020_às_x0020__x007B_GetDateTimeOffset_x0028_DateTimeOffset.Now_x0029_.ToString_x0028__x0022_HH:mm_x0022__x0029__x007D__x0020_-_x0020_www.qualiex.com
en-US
Text15.Text,_x003C_b_x003E_Item_x0020_adherence_x0020_report_x003C__x002F_b_x003E_
Text6.Text,Items:_x0020_Standard_x0020_Visit_x0020_Report_x0020_-_x0020_1st_x0020_Version
Text9.Text,Planning_x0020_place:_x0020__x007B_Get_x0028_filter_place.planning_place_x0029__x007D_
Text14.Text,General:_x0020_Standard_x0020_Visit_x0020_Report_x0020_-_x0020_1st_x0020_Version
Text3.Text,Page_x0020__x007B_PageNumber_x007D__x0020_of_x0020__x007B_TotalPageCount_x007D_._x000D__x000A_Viewed_x0020_in_x0020__x007B_GetDateTimeOffset_x0028_DateTimeOffset.Now_x0029_.ToString_x0028__x0022_MM_x002F_d_x002F_yyyy_x0022__x0029__x007D__x0020_at_x0020__x007B_GetDateTimeOffset_x0028_DateTimeOffset.Now_x0029_.ToString_x0028__x0022_hh:mm_x0020_tt_x0022__x0029__x007D__x0020_-_x0020_www.qualiex.com
Text8.Text,Audit_x0020_location:_x0020__x007B_Get_x0028_filter_place.audit_place_x0029__x007D_
Text17.Text,_x003C_b_x003E_Audit_x0020_Period_x0028_s_x0029_:_x003C__x002F_b_x003E__x0020__x007B_GetInterval_x0028_params_values.date_from_x002C__x0020_params_values.date_until_x0029__x007D_
Text_Footer.Text,Page_x0020__x007B_PageNumber_x007D__x0020_of_x0020__x007B_TotalPageCount_x007D_._x000D__x000A_Viewed_x0020_in_x0020__x007B_GetDateTimeOffset_x0028_DateTimeOffset.Now_x0029_.ToString_x0028__x0022_MM_x002F_d_x002F_yyyy_x0022__x0029__x007D__x0020_at_x0020__x007B_GetDateTimeOffset_x0028_DateTimeOffset.Now_x0029_.ToString_x0028__x0022_hh:mm_x0020_tt_x0022__x0029__x007D__x0020_-_x0020_www.qualiex.com
es-ES
Text15.Text,_x003C_b_x003E_Informe_x0020_de_x0020_cumplimiento_x0020_de_x0020_artículos_x003C__x002F_b_x003E_
Text6.Text,Artículos:_x0020_Informe_x0020_de_x0020_Visita_x0020_Estándar_x0020_-_x0020_1ra_x0020_Versión
Text9.Text,Ubificación_x0020_de_x0020_planificación:_x0020__x007B_Get_x0028_filter_place.planning_place_x0029__x007D_
Text14.Text,General:_x0020_Informe_x0020_de_x0020_visita_x0020_estándar_x0020_-_x0020_1._x00AA__x0020_versión
Text3.Text,Página_x0020__x007B_PageNumber_x007D__x0020_de_x0020__x007B_TotalPageCount_x007D_._x000D__x000A_Visto_x0020_en_x0020__x007B_GetDateTimeOffset_x0028_DateTimeOffset.Now_x0029_.ToString_x0028__x0022_dd_x002F_MM_x002F_yyyy_x0022__x0029__x007D__x0020_en_x0020__x007B_GetDateTimeOffset_x0028_DateTimeOffset.Now_x0029_.ToString_x0028__x0022_HH:mm_x0022__x0029__x007D__x0020_-_x0020_www.qualiex.com
Text8.Text,Ubificación_x0020_de_x0020_auditoría:_x0020__x007B_Get_x0028_filter_place.audit_place_x0029__x007D_
Text7.Text,Artículo
Text17.Text,_x003C_b_x003E_Período_x0028_s_x0029__x0020_de_x0020_la_x0020_Auditoría:_x003C__x002F_b_x003E__x0020__x007B_GetInterval_x0028_params_values.date_from_x002C__x0020_params_values.date_until_x0029__x007D_
Text_Footer.Text,Página_x0020__x007B_PageNumber_x007D__x0020_de_x0020__x007B_TotalPageCount_x007D_._x000D__x000A_Visto_x0020_en_x0020__x007B_GetDateTimeOffset_x0028_DateTimeOffset.Now_x0029_.ToString_x0028__x0022_dd_x002F_MM_x002F_yyyy_x0022__x0029__x007D__x0020_en_x0020__x007B_GetDateTimeOffset_x0028_DateTimeOffset.Now_x0029_.ToString_x0028__x0022_HH:mm_x0022__x0029__x007D__x0020_-_x0020_www.qualiex.com
f48a595e95ce4158a0755d47ce7fd0bd
None;[216:216:216];2;Solid;False;4;Black
[255:255:255]
Transparent
0,0.4,19,2.4
True
setImageResize();
Transparent
0,0,7.5,2.3
68, 114, 196
{PARAMS.logo_img}
0,0,0,0
Image1
True
Center
True
Transparent
7.6,0,11.4,0.4
Arial,10
Right
0,0,0,0
Text15
<b>Relatório de aderência dos itens</b>
Black
Wysiwyg
Expression
True
Transparent
True
True
7.6,0.4,11.4,0.4
Arial,8
Right
0,0,0,0
Text8
<b>Local da auditoria: </b> {Get(filter_place.audit_place)}
Black
Wysiwyg
Expression
Center
True
Transparent
True
True
7.6,0.8,11.4,0.4
Arial,8
Right
0,0,0,0
Text9
<b>Local do planejamento: </b> {Get(filter_place.planning_place)}
Black
,,,,WordWrap=True,A=0
Wysiwyg
Expression
True
Transparent
True
True
7.6,1.2,11.4,0.4
Arial,8
Right
0,0,0,0
Text17
<b>Período das Auditoria(s):</b> {GetInterval(params_values.date_from, params_values.date_until)}
Black
Wysiwyg
Expression
PageHeaderBand1
Transparent
0,31.24,19,2
Transparent
0,0.6,14.4,0.8
Arial,8
True
4b48d28c94a84b21a656a0e884bd5255
0,0,0,0
Text_Footer
Página {PageNumber} de {TotalPageCount}.
Visualizado em {GetDateTimeOffset(DateTimeOffset.Now).ToString("dd/MM/yyyy")} às {GetDateTimeOffset(DateTimeOffset.Now).ToString("HH:mm")} - www.qualiex.com
Black
Expression
Transparent
0,1.6,3,0.4
Arial,8
0,0,0,0
Text278
©ForLogic
[165:165:165]
Wysiwyg
Expression
setImageFooterResize()
Transparent
15.2,0.6,3.8,1.4
Right
68, 114, 196
{PARAMS.logo_footer_img}
5,5,5,5
Image3
0,0.2,19,0.0254
Black
Black
HorizontalLinePrimitive1
Black
PageFooter
Transparent
0,3.6,19,0.8
Bottom;[187:182:174];1;Solid;False;4;Black
Transparent
0,0.1,19,0.6
Arial,12,Bold| Italic
4c6a8e53e3b34b1f9b65cac3c2a624dc
0,0,0,0
Text34
{GetEmptyDb()}
[14:118:188]
Expression
_x007B_Count_x0028_DataBand3_x0029__x0020__x003D__x003D__x0020_0_x007D_,Red,Transparent,Arial_x002C_8,True,False,,,None
1
False
d423a8f5122a41e291a5c05c1443868b
dbNoFile
Transparent
0,5.2,19,0.7
Bottom;[14:118:188];1;Solid;False;4;Black
Transparent
0,0,18.9,0.6
Arial,10,Bold| Italic
0,0,0,0
Text14
Geral: Norma Relatório de Visita – 1ª Versão
[14:118:188]
Expression
Bottom
HeaderBand1
[219:238:243]
0,6.7,19,0.6
Transparent
0,0,0,0.6
CrossHeaderBand1
Bottom;[216:216:216];1;Solid;False;4;Black
Transparent
True
0,0,3.8,0.6
Left, Right;[242:242:242];1;Solid;False;4;Black
[219:238:243]
True
True
0,0,3.78,0.6
Arial,8,Bold
5,5,5,5
Text1
{answer_options.name_item}
Black
,,,,WordWrap=True,A=0
Expression
Center
answer_options
CrossDataBand2
Right;[242:242:242];1;Solid;False;4;Black
Transparent
3.8,0,4.2,0.6
Bottom;[216:216:216];1;Solid;False;4;Black
[219:238:243]
True
True
0,0,4.18,0.6
Arial,8,Bold
5,5,5,5
Text4
{adherence.name}
[0:0:0]
,,,,WordWrap=True,A=0
Expression
Center
CrossFooterBand1
HeaderBand2
Transparent
0,8.1,19,0.6
None;[242:242:242];1;Solid;False;4;Black
Transparent
0,0,0,0.6
CrossHeaderBand2
Transparent
0,0,3.8,0.6
Left, Right, Bottom;[242:242:242];1;Solid;False;4;Black
Transparent
True
0,0,3.78,0.6
Arial,7
True
Center
5,5,5,5
Text2
{answer_options.count_item}
Black
Expression
Center
answer_options
CrossDataBand1
Right;[242:242:242];1;Solid;False;4;Black
Transparent
3.8,0,4.2,0.6
Right, Bottom;[242:242:242];1;Solid;False;4;Black
Transparent
True
True
0,0,4.18,0.6
Arial,7
True
Center
5,5,5,5
Text5
{adherence.percentage}
Black
Expression
Center
CrossFooterBand2
answer_options
DataBand1
Transparent
0,9.5,19,7.4
171, 172, 173
1
White
[255:255:255]
0,0.3,19,7
pie_chart.value,IsNull,,,String,Red,Transparent,Arial_x002C_8,False,False,,,None
Simple
Chart1
pie_chart.name
pie_chart.color
pie_chart.name
255, 255, 255
1
[91:155:213]
140, 140, 140
[255:255:255]
Arial,7
90, 90, 90
105, 105, 105
8, 6
-
0
True
False
Séries 1
pie_chart.value
140, 140, 140
[255:255:255]
Arial,7
90, 90, 90
Argument
105, 105, 105
8, 6
False
Argument
-
0
True
DataBand2
Transparent
0,17.7,19,0.8
Bottom;[14:118:188];1;Solid;False;4;Black
Transparent
0,0.1,18.9,0.6
Arial,10,Bold| Italic
0,0,0,0
Text6
Itens: Norma Relatório de Visita – 1ª Versão
[14:118:188]
Expression
Bottom
HeaderBand3
None;[216:216:216];1;Solid;False;4;Black
[219:238:243]
0,19.3,19,0.6
Transparent
0,0,5.4,0.6
Left, Right;[242:242:242];1;Solid;False;4;Black
[219:238:243]
True
True
0,0,5.4,0.6
Arial,8,Bold
5,5,5,5
Text7
Item
Black
,,,,WordWrap=True,A=0
Expression
Center
CrossHeaderBand3
Transparent
5.4,0,3.4,0.6
Left, Right;[242:242:242];1;Solid;False;4;Black
[219:238:243]
True
True
0,0,3.38,0.6
Arial,8,Bold
5,5,5,5
Text11
{answer_options.name_item}
Black
,,,,WordWrap=True,A=0
Expression
Center
answer_options
CrossDataBand3
ASC
id_item
Transparent
8.8,0,3.4,0.6
Top;[242:242:242];1;Solid;False;4;Black
[219:238:243]
True
True
0,0,3.38,0.6
Arial,8,Bold
5,5,5,5
Text12
{adherence.name}
[0:0:0]
,,,,WordWrap=True,A=0
Expression
Center
CrossFooterBand3
HeaderBand4
None;[216:216:216];1;Solid;False;4;Black
Transparent
0,20.7,19,0.6
Transparent
0,0,5.4,0.6
Left, Right, Bottom;[242:242:242];1;Solid;False;4;Black
Transparent
True
True
0,0,5.38,0.6
Arial,7
True
5,5,5,5
Text10
{item_name.name}
Black
,,,,WordWrap=True,A=0
DataColumn
Center
CrossHeaderBand4
Transparent
5.4,0,3.4,0.6
Left, Right, Bottom;[242:242:242];1;Solid;False;4;Black
Transparent
0,0,3.38,0.6
Arial,7
True
Center
5,5,5,5
Text13
{item_value.value}
Black
Expression
Center
Relação
item_value
CrossDataBand4
Transparent
8.8,0,3.4,0.6
Bottom;[242:242:242];1;Solid;False;4;Black
Transparent
0,0,3.38,0.6
Arial,7
True
Center
5,5,5,5
Text16
{item_name.value_calc}
Black
DataColumn
Center
CrossFooterBand4
item_name
Estilo1
DataBand3
58d11d3b8a18486f99fc4276dd409ebc
1,1,1,1
Page1
29.7
21
System.Dll
System.Drawing.Dll
System.Windows.Forms.Dll
System.Data.Dll
System.Xml.Dll
Stimulsoft.Controls.Dll
Stimulsoft.Base.Dll
Stimulsoft.Report.Dll
Report
1/8/2024 8:52:15 AM
6/27/2023 3:12:34 PM
C:\Users\lucas.rinaldi\Lucas Rinaldi\Repos\api-v4\src\Reports\Reports.API\bin\Debug\net7.0\ReportTemplates\Audit\adherenceItems.mrt
210eb2dbebe54191a258ed16cd5d01e6
Report
Centimeters
2024.1.2.0
CSharp
WhiteSmoke
Arial,8
Estilo1
Red
Black