Permalink
Switch branches/tags
Nothing to show
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
36 lines (29 sloc) 1.21 KB
<!--
title: Products
-->
<a id="back" href="javascript:history.back()">&#8592; Back</a>
{{ `select p.Id,
ProductName,
c.CategoryName Category,
s.CompanyName Supplier,
QuantityPerUnit,
${sqlCurrency("UnitPrice")} UnitPrice,
UnitsInStock, UnitsOnOrder, ReorderLevel
from Product p
inner join Category c on p.CategoryId = c.Id
inner join Supplier s on p.SupplierId = s.Id
where Discontinued = 0`
| assignTo: sql }}
{{#if !isEmpty(PathArgs)}}
{{ `${sql} and p.Id = @id` | dbSingle({ id: PathArgs[0] })
| return }}
{{/if}}
{{#if id}} {{ 'p.Id = @id' | addTo: filters }} {{/if}}
{{#if category}} {{ 'c.CategoryName = @category' | addTo: filters }} {{/if}}
{{#if supplier}} {{ 's.CompanyName = @supplier' | addTo: filters }} {{/if}}
{{#if nameContains}} {{ 'ProductName LIKE @name' | addTo: filters }} {{/if}}
{{#if !isEmpty(filters)}}
{{ `${sql} and ${join(filters, ' and ')} ORDER BY CompanyName ${sqlLimit(limit)}` | assignTo: sql }}
{{/if}}
{{ sql | dbSelect({ id, category, supplier, name: `%${nameContains}%` })
| htmlDump({ className: "table table-striped" }) }}