The Kanban Board
This is the table component mode
Allows you to display data in the form of a Kanban Board with a division by status and the ability to transfer the card to another status.
To display the Kanban Board, you must do the following:
-
Create a status table with the columns id (PK),name, and color. These are the statuses of elements displayed at the top of the Kanban Board.
-
In the second GetItems request, select the statuses
CREATE TABLE dbo.#result (id int, name nvarchar(256), color nvarchar(64)) declare @filterName nvarchar(128) select @filterName = Value from @filters where [Key] = 'name' insert into #result SELECT [id], [name], [color] FROM [demo].[dbo].[as_en_statuses] -- take statuses WHERE entityID in (select id from as_en_entities where code='order') ORDER BY ord
-
In the third select in GetItems specify the output type viewType='kanban'
-
In the fourth select, in GetItems (instead of footer data), we output data from Kanban cards (with exactly this data model).
SELECT ord_orders.id, as_en_entityInstances.statusID,-- The status of element is displayed in the middle of the card customerName name, customerContact text, -- If the form code is specified, then 'Comment of the customer: ' + customerComment tooltip, -- it will be a reference to the modal form convert(nvarchar, ord_orders.created, 120) bottomText, '' customClass--css class FROM ord_orders INNER JOIN as_en_entityInstances on as_en_entityInstances.id = ord_orders.instanceID
-
Additionally the following parameters can be configured in the 3 select query:
-
kanbanItemForm-form code. If specified, the form will be called when clicking on the Board card in the modal window
(the form with the specified code will need to be implemented separately, Itemid=ID of the entity from the 4 select
query is passed to it). You can also pass this parameter (kanbanItemForm -) in 4 requests for each card separately,
to output different forms for different cards. -
kanbanItemFormTitle-title of the form dialog box.
-
To change the status, you must implement the updateField update method for the table. The transmitted field is set hard-statusID.
CREATE PROCEDURE [dbo].[crud_kanbanOrders_updateField]
@itemID int,
@field nvarchar(64),
@value nvarchar(max),
@username nvarchar(64)
AS
BEGIN
if(@field = 'statusID') begin
update as_en_entityInstances
set statusID = cast(@value as int)
where id in (select instanceID from ord_orders where id = @itemID)
end else if(@field = 'YYY') begin
update as_trace set code = @value
where id = @itemID
end else begin
select 'Invalid property code' Msg, 0 Result
return
end
select '' Msg, 1 Result
END
Falcon Space is a functional web development platform on a narrow stack MS SQL/Bootstrap. Falcon Space Gettting started
- Management
- Falcon Space Foundation
- Basic components
- Falcon Space Features
- Коммуникация с пользователем
- Дизайн, стилизация
- Integrations
- Каталоги
- Навигация
- Документы
- Additional component Falcon Space. Working with indicators Falcon Space. Panel-hints Falcon Space. The counters component Falcon Space. Business processes Falcon Space. Working with the catalog, shopping cart, and orders Working with HTML blocks Falcon Space. Working with trees (hierarchy) Universal likes, dislikes, ratings, voting for products Interactive tree Gantt Chart The Kanban Board Chartbar diagram Map with markers Cards Progress line Timeline Uploaded files Data output in the form of a graph on the site Output of the request movement by statusbar statuses
- Продвижение, SEO
- Системные моменты
- HOWTO
- HOWTO Tables
- HOWTO Forms
- Working with SQL
- HOWTO JS
- HOWTO Layout
- Solve problems
Falcon Space Platform
This is a reduction in the cost of ownership
at the expense of fewer people to support
This is a quick change
while using the program
This is a modern interface
full adaptation for mobile devices
Note
- Falcon Space Video
- Platform features demo will allow you to understand how this or that component looks and works
- Have a question? Write to the chat at the bottom right