SQL-MVC Firebird example implementation of todomvc.com


	Must be a valid email address.

 Field Style Debug+ 8048 Bytes

 * root -->
	
 * table -->
	
Title:Make new records
from:TODO_MVC
autoinsert:top
tablestyle:Todo
object_ended_at:71
table:
quickinput:Select
autoinsert_internal:1

 * STATUS -->
	
 * Qualia -->
	
Action:Edit
autosave:yes
onupdate:owner=session.id
object_ended_at:54
name:STATUS
table:TODO_MVC
Default_length:20
length:10
Type:Pick
quickinput:STATUS,
as:ticked
List:Ticked
context:TODO_MVC
indx:0
title:STATUS
pointer:2
to:TODO_MVC
pkname:REF

search:STATUS : Todo..Pick.Field.Edit
 * tried -->
	
 + _Main -->
	
_Main[0]:TodoPickFieldEdit_Main
_Main[1]:PickFieldEdit_Main

 + _Div -->
	
_Div[0]:TodoPickFieldEdit_Div
_Div[1]:PickFieldEdit_Div

 + _Script -->
	
_Script[0]:TodoPickFieldEdit_Script
_Script[1]:PickFieldEdit_Script
_Script[2]:InheritingFrom:PickFieldEdit_Script
_Script[3]:Edit_Script



 * NAME -->
	
 * Qualia -->
	
Action:Edit
placeholder:What needs to be done (tab to save)
autosave:yes
onupdate:owner=session.id
object_ended_at:104
name:NAME
table:TODO_MVC
Default_length:20
length:100
Type:Text
quickinput:NAME,
as:text
size:40
title:todo
context:TODO_MVC
indx:1
pointer:2
to:TODO_MVC
pkname:REF

search:NAME : Todo..Text.Field.Edit
 * tried -->
	
 + _Main -->
	
_Main[0]:TodoTextFieldEdit_Main
_Main[1]:TextFieldEdit_Main
_Main[2]:InheritingFrom:TextFieldEdit_Main
_Main[3]:Edit_Main

 + _Div -->
	
_Div[0]:TodoTextFieldEdit_Div
_Div[1]:TextFieldEdit_Div

 + _Script -->
	
_Script[0]:TodoTextFieldEdit_Script
_Script[1]:TextFieldEdit_Script
_Script[2]:InheritingFrom:TextFieldEdit_Script
_Script[3]:Edit_Script



 * REF -->
	
 * Qualia -->
	
object_ended_at:2
name:REF
table:TODO_MVC
Default_length:20
length:40
Type:Hide
Action:View
quickinput:REF
as:pk
PrimaryKey:true
fb_trigger:true
context:TODO_MVC
indx:2
title:REF
pointer:2
to:TODO_MVC

search:REF : Todo..Hide.Field.View
 * tried -->
	
 + _Main -->
	
_Main[0]:TodoHideFieldView_Main
_Main[1]:HideFieldView_Main
_Main[2]:TodoHideFieldView_Main
_Main[3]:TodoFieldView_Main
_Main[4]:HideFieldView_Main
_Main[5]:HideFieldView_Main
_Main[6]:FieldView_Main
_Main[7]:View_Main

 + _Div -->
	
_Div[0]:TodoHideFieldView_Div
_Div[1]:HideFieldView_Div
_Div[2]:InheritingFrom:HideFieldView_Div
_Div[3]:View_Div

 + _Script -->
	
_Script[0]:TodoHideFieldView_Script
_Script[1]:HideFieldView_Script
_Script[2]:InheritingFrom:HideFieldView_Script
_Script[3]:View_Script



 * table_style -->
	
 * TopTitle -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataTopTitle:

Found:
FoundFrom:firstLook:TodoDataTopTitle:

 * HeadFirstFieldCell -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataHeadFirstFieldCell: undefined 
tries[1]:InheritLook:TodoData_Inherit:
tries[2]:first Inherit:DataHeadFirstFieldCell: < th scope="col" > { { #proper } }{ { field.f.title } }{ { /proper } }{ { { pop } } } < /th > 

Found: < th scope="col" > { { #proper } }{ { field.f.title } }{ { /proper } }{ { { pop } } } < /th > 
FoundFrom:first Inherit:DataHeadFirstFieldCell: < th scope="col" > { { #proper } }{ { field.f.title } }{ { /proper } }{ { { pop } } } < /th > 

 * HeadFieldCell -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataHeadFieldCell: undefined 
tries[1]:InheritLook:TodoData_Inherit:
tries[2]:first Inherit:DataHeadFieldCell: < td > { { #proper } }{ { field.f.title } }{ { /proper } }{ { { pop } } } < /td > 

Found: < td > { { #proper } }{ { field.f.title } }{ { /proper } }{ { { pop } } } < /td > 
FoundFrom:first Inherit:DataHeadFieldCell: < td > { { #proper } }{ { field.f.title } }{ { /proper } }{ { { pop } } } < /td > 

 * HeadRecordWrap -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataHeadRecordWrap:

Found:
FoundFrom:firstLook:TodoDataHeadRecordWrap:

 * HeadRow -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataHeadRow: undefined 
tries[1]:InheritLook:TodoData_Inherit:
tries[2]:first Inherit:DataHeadRow: < tr > { { { pop } } } < /tr > 

Found: < tr > { { { pop } } } < /tr > 
FoundFrom:first Inherit:DataHeadRow: < tr > { { { pop } } } < /tr > 

 * Head -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataHead: undefined 
tries[1]:InheritLook:TodoData_Inherit:
tries[2]:first Inherit:DataHead:$CRLF$ < thead > { { { pop } } } < /thead > 

Found:$CRLF$ < thead > { { { pop } } } < /thead > 
FoundFrom:first Inherit:DataHead:$CRLF$ < thead > { { { pop } } } < /thead > 

 * BodyFirstFieldCell -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataBodyFirstFieldCell: undefined 
tries[1]:InheritLook:TodoData_Inherit:
tries[2]:first Inherit:DataBodyFirstFieldCell: < th scope="row" > { { { pop } } } < /th > 

Found: < th scope="row" > { { { pop } } } < /th > 
FoundFrom:first Inherit:DataBodyFirstFieldCell: < th scope="row" > { { { pop } } } < /th > 

 * BodyFieldCell -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataBodyFieldCell: undefined 
tries[1]:InheritLook:TodoData_Inherit:
tries[2]:first Inherit:DataBodyFieldCell: < td > { { { pop } } } < /td > 

Found: < td > { { { pop } } } < /td > 
FoundFrom:first Inherit:DataBodyFieldCell: < td > { { { pop } } } < /td > 

 * BodyRecordWrap -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataBodyRecordWrap: undefined 
tries[1]:InheritLook:TodoData_Inherit:
tries[2]:first Inherit:DataBodyRecordWrap:{ { { pop } } }

Found:{ { { pop } } }
FoundFrom:first Inherit:DataBodyRecordWrap:{ { { pop } } }

 * BodyRow -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataBodyRow: undefined 
tries[1]:InheritLook:TodoData_Inherit:
tries[2]:first Inherit:DataBodyRow: < tr > { { { pop } } } < /tr > 

Found: < tr > { { { pop } } } < /tr > 
FoundFrom:first Inherit:DataBodyRow: < tr > { { { pop } } } < /tr > 

 * BodyArray -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataBodyArray: undefined 
tries[1]:InheritLook:TodoData_Inherit:
tries[2]:first Inherit:DataBodyArray:}

Found:}
FoundFrom:first Inherit:DataBodyArray:}

 * Body -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataBody: undefined 
tries[1]:InheritLook:TodoData_Inherit:
tries[2]:first Inherit:DataBody:$CRLF$ < tbody > { { { pop } } } < /tbody > 

Found:$CRLF$ < tbody > { { { pop } } } < /tbody > 
FoundFrom:first Inherit:DataBody:$CRLF$ < tbody > { { { pop } } } < /tbody > 

 * FootFirstFieldCell -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataFootFirstFieldCell: undefined 
tries[1]:InheritLook:TodoData_Inherit:
tries[2]:first Inherit:DataFootFirstFieldCell: < th scope="col" > { { { pop } } } < /th > 

Found: < th scope="col" > { { { pop } } } < /th > 
FoundFrom:first Inherit:DataFootFirstFieldCell: < th scope="col" > { { { pop } } } < /th > 

 * FootFieldCell -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataFootFieldCell: undefined 
tries[1]:InheritLook:TodoData_Inherit:
tries[2]:first Inherit:DataFootFieldCell: < td > { { { pop } } } < /td > 

Found: < td > { { { pop } } } < /td > 
FoundFrom:first Inherit:DataFootFieldCell: < td > { { { pop } } } < /td > 

 * FootRecordWrap -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataFootRecordWrap:

Found:
FoundFrom:firstLook:TodoDataFootRecordWrap:

 * FootRow -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataFootRow: undefined 
tries[1]:InheritLook:TodoData_Inherit:
tries[2]:first Inherit:DataFootRow: < tr > { { { pop } } } < /tr > 

Found: < tr > { { { pop } } } < /tr > 
FoundFrom:first Inherit:DataFootRow: < tr > { { { pop } } } < /tr > 

 * Foot -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataFoot: undefined 
tries[1]:InheritLook:TodoData_Inherit:
tries[2]:first Inherit:DataFoot:$CRLF$

Found:$CRLF$
FoundFrom:first Inherit:DataFoot:$CRLF$

 * Wrap -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataWrap: undefined 
tries[1]:InheritLook:TodoData_Inherit:
tries[2]:first Inherit:DataWrap: < div  >   < form autocomplete="off" >  < table class="full" id="{ { tid } }" > { { { head_html } } }{ { { body_html } } }{ { { foot_html } } } < /table >  < /form >  < /div > 

Found: < div  >   < form autocomplete="off" >  < table class="full" id="{ { tid } }" > { { { head_html } } }{ { { body_html } } }{ { { foot_html } } } < /table >  < /form >  < /div > 
FoundFrom:first Inherit:DataWrap: < div  >   < form autocomplete="off" >  < table class="full" id="{ { tid } }" > { { { head_html } } }{ { { body_html } } }{ { { foot_html } } } < /table >  < /form >  < /div >

 Field Style Debug+ 8048 Bytes

 * root -->
	
 * table -->
	
Title:Make new records
from:TODO_MVC
autoinsert:top
tablestyle:Todo
object_ended_at:71
table:
quickinput:Select
autoinsert_internal:0

 * STATUS -->
	
 * Qualia -->
	
Action:Edit
autosave:yes
onupdate:owner=session.id
object_ended_at:54
name:STATUS
table:TODO_MVC
Default_length:20
length:10
Type:Pick
quickinput:STATUS,
as:ticked
List:Ticked
context:TODO_MVC
indx:0
title:STATUS
pointer:2
to:TODO_MVC
pkname:REF

search:STATUS : Todo..Pick.Field.Edit
 * tried -->
	
 + _Main -->
	
_Main[0]:TodoPickFieldEdit_Main
_Main[1]:PickFieldEdit_Main

 + _Div -->
	
_Div[0]:TodoPickFieldEdit_Div
_Div[1]:PickFieldEdit_Div

 + _Script -->
	
_Script[0]:TodoPickFieldEdit_Script
_Script[1]:PickFieldEdit_Script
_Script[2]:InheritingFrom:PickFieldEdit_Script
_Script[3]:Edit_Script



 * NAME -->
	
 * Qualia -->
	
Action:Edit
placeholder:What needs to be done (tab to save)
autosave:yes
onupdate:owner=session.id
object_ended_at:104
name:NAME
table:TODO_MVC
Default_length:20
length:100
Type:Text
quickinput:NAME,
as:text
size:40
title:todo
context:TODO_MVC
indx:1
pointer:2
to:TODO_MVC
pkname:REF

search:NAME : Todo..Text.Field.Edit
 * tried -->
	
 + _Main -->
	
_Main[0]:TodoTextFieldEdit_Main
_Main[1]:TextFieldEdit_Main
_Main[2]:InheritingFrom:TextFieldEdit_Main
_Main[3]:Edit_Main

 + _Div -->
	
_Div[0]:TodoTextFieldEdit_Div
_Div[1]:TextFieldEdit_Div

 + _Script -->
	
_Script[0]:TodoTextFieldEdit_Script
_Script[1]:TextFieldEdit_Script
_Script[2]:InheritingFrom:TextFieldEdit_Script
_Script[3]:Edit_Script



 * REF -->
	
 * Qualia -->
	
object_ended_at:2
name:REF
table:TODO_MVC
Default_length:20
length:40
Type:Hide
Action:View
quickinput:REF
as:pk
PrimaryKey:true
fb_trigger:true
context:TODO_MVC
indx:2
title:REF
pointer:2
to:TODO_MVC

search:REF : Todo..Hide.Field.View
 * tried -->
	
 + _Main -->
	
_Main[0]:TodoHideFieldView_Main
_Main[1]:HideFieldView_Main
_Main[2]:TodoHideFieldView_Main
_Main[3]:TodoFieldView_Main
_Main[4]:HideFieldView_Main
_Main[5]:HideFieldView_Main
_Main[6]:FieldView_Main
_Main[7]:View_Main

 + _Div -->
	
_Div[0]:TodoHideFieldView_Div
_Div[1]:HideFieldView_Div
_Div[2]:InheritingFrom:HideFieldView_Div
_Div[3]:View_Div

 + _Script -->
	
_Script[0]:TodoHideFieldView_Script
_Script[1]:HideFieldView_Script
_Script[2]:InheritingFrom:HideFieldView_Script
_Script[3]:View_Script



 * table_style -->
	
 * TopTitle -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataTopTitle:

Found:
FoundFrom:firstLook:TodoDataTopTitle:

 * HeadFirstFieldCell -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataHeadFirstFieldCell: undefined 
tries[1]:InheritLook:TodoData_Inherit:
tries[2]:first Inherit:DataHeadFirstFieldCell: < th scope="col" > { { #proper } }{ { field.f.title } }{ { /proper } }{ { { pop } } } < /th > 

Found: < th scope="col" > { { #proper } }{ { field.f.title } }{ { /proper } }{ { { pop } } } < /th > 
FoundFrom:first Inherit:DataHeadFirstFieldCell: < th scope="col" > { { #proper } }{ { field.f.title } }{ { /proper } }{ { { pop } } } < /th > 

 * HeadFieldCell -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataHeadFieldCell: undefined 
tries[1]:InheritLook:TodoData_Inherit:
tries[2]:first Inherit:DataHeadFieldCell: < td > { { #proper } }{ { field.f.title } }{ { /proper } }{ { { pop } } } < /td > 

Found: < td > { { #proper } }{ { field.f.title } }{ { /proper } }{ { { pop } } } < /td > 
FoundFrom:first Inherit:DataHeadFieldCell: < td > { { #proper } }{ { field.f.title } }{ { /proper } }{ { { pop } } } < /td > 

 * HeadRecordWrap -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataHeadRecordWrap:

Found:
FoundFrom:firstLook:TodoDataHeadRecordWrap:

 * HeadRow -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataHeadRow: undefined 
tries[1]:InheritLook:TodoData_Inherit:
tries[2]:first Inherit:DataHeadRow: < tr > { { { pop } } } < /tr > 

Found: < tr > { { { pop } } } < /tr > 
FoundFrom:first Inherit:DataHeadRow: < tr > { { { pop } } } < /tr > 

 * Head -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataHead: undefined 
tries[1]:InheritLook:TodoData_Inherit:
tries[2]:first Inherit:DataHead:$CRLF$ < thead > { { { pop } } } < /thead > 

Found:$CRLF$ < thead > { { { pop } } } < /thead > 
FoundFrom:first Inherit:DataHead:$CRLF$ < thead > { { { pop } } } < /thead > 

 * BodyFirstFieldCell -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataBodyFirstFieldCell: undefined 
tries[1]:InheritLook:TodoData_Inherit:
tries[2]:first Inherit:DataBodyFirstFieldCell: < th scope="row" > { { { pop } } } < /th > 

Found: < th scope="row" > { { { pop } } } < /th > 
FoundFrom:first Inherit:DataBodyFirstFieldCell: < th scope="row" > { { { pop } } } < /th > 

 * BodyFieldCell -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataBodyFieldCell: undefined 
tries[1]:InheritLook:TodoData_Inherit:
tries[2]:first Inherit:DataBodyFieldCell: < td > { { { pop } } } < /td > 

Found: < td > { { { pop } } } < /td > 
FoundFrom:first Inherit:DataBodyFieldCell: < td > { { { pop } } } < /td > 

 * BodyRecordWrap -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataBodyRecordWrap: undefined 
tries[1]:InheritLook:TodoData_Inherit:
tries[2]:first Inherit:DataBodyRecordWrap:{ { { pop } } }

Found:{ { { pop } } }
FoundFrom:first Inherit:DataBodyRecordWrap:{ { { pop } } }

 * BodyRow -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataBodyRow: undefined 
tries[1]:InheritLook:TodoData_Inherit:
tries[2]:first Inherit:DataBodyRow: < tr > { { { pop } } } < /tr > 

Found: < tr > { { { pop } } } < /tr > 
FoundFrom:first Inherit:DataBodyRow: < tr > { { { pop } } } < /tr > 

 * BodyArray -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataBodyArray: undefined 
tries[1]:InheritLook:TodoData_Inherit:
tries[2]:first Inherit:DataBodyArray:}

Found:}
FoundFrom:first Inherit:DataBodyArray:}

 * Body -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataBody: undefined 
tries[1]:InheritLook:TodoData_Inherit:
tries[2]:first Inherit:DataBody:$CRLF$ < tbody > { { { pop } } } < /tbody > 

Found:$CRLF$ < tbody > { { { pop } } } < /tbody > 
FoundFrom:first Inherit:DataBody:$CRLF$ < tbody > { { { pop } } } < /tbody > 

 * FootFirstFieldCell -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataFootFirstFieldCell: undefined 
tries[1]:InheritLook:TodoData_Inherit:
tries[2]:first Inherit:DataFootFirstFieldCell: < th scope="col" > { { { pop } } } < /th > 

Found: < th scope="col" > { { { pop } } } < /th > 
FoundFrom:first Inherit:DataFootFirstFieldCell: < th scope="col" > { { { pop } } } < /th > 

 * FootFieldCell -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataFootFieldCell: undefined 
tries[1]:InheritLook:TodoData_Inherit:
tries[2]:first Inherit:DataFootFieldCell: < td > { { { pop } } } < /td > 

Found: < td > { { { pop } } } < /td > 
FoundFrom:first Inherit:DataFootFieldCell: < td > { { { pop } } } < /td > 

 * FootRecordWrap -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataFootRecordWrap:

Found:
FoundFrom:firstLook:TodoDataFootRecordWrap:

 * FootRow -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataFootRow: undefined 
tries[1]:InheritLook:TodoData_Inherit:
tries[2]:first Inherit:DataFootRow: < tr > { { { pop } } } < /tr > 

Found: < tr > { { { pop } } } < /tr > 
FoundFrom:first Inherit:DataFootRow: < tr > { { { pop } } } < /tr > 

 * Foot -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataFoot: undefined 
tries[1]:InheritLook:TodoData_Inherit:
tries[2]:first Inherit:DataFoot:$CRLF$

Found:$CRLF$
FoundFrom:first Inherit:DataFoot:$CRLF$

 * Wrap -->
	
 + tries -->
	
tries[0]:firstLook:TodoDataWrap: undefined 
tries[1]:InheritLook:TodoData_Inherit:
tries[2]:first Inherit:DataWrap: < div  >   < form autocomplete="off" >  < table class="full" id="{ { tid } }" > { { { head_html } } }{ { { body_html } } }{ { { foot_html } } } < /table >  < /form >  < /div > 

Found: < div  >   < form autocomplete="off" >  < table class="full" id="{ { tid } }" > { { { head_html } } }{ { { body_html } } }{ { { foot_html } } } < /table >  < /form >  < /div > 
FoundFrom:first Inherit:DataWrap: < div  >   < form autocomplete="off" >  < table class="full" id="{ { tid } }" > { { { head_html } } }{ { { body_html } } }{ { { foot_html } } } < /table >  < /form >  < /div >

0 items left View all Active Completed

Info

0 actions from you and 0 actions total (in this session).

View

This source file is //Home/Guest/Index:


<#script()

sqlcomment Index.quicc;

dialect(fb)


UPDATE OR INSERT INTO MAIL (FROM_USER, STAMP,SUBJECT)
VALUES (
    session.id, 
    'now',
    'last contact'
) matching (FROM_USER,SUBJECT) ;

dialect()

INSERT INTO MAIL (FROM_USER, STAMP,SUBJECT)
VALUES (
    session.id, 
    'now',
    'login log'
) ;

#>

<#view
Container(style=Center)


dialect(fb)

notify(style=Heading) 
<a href="https://github.com/quale-quest/sql-mvc">SQL-MVC</a> Firebird example implementation of <a href="http://todomvc.com">todomvc.com</a>


dialect(mysql57)

notify(style=Heading) 
<a href="https://github.com/quale-quest/sql-mvc">SQL-MVC</a> MYSQL example implementation of <a href="http://todomvc.com">todomvc.com</a>

dialect(mssql)

notify(style=Heading) 
<a href="https://github.com/quale-quest/sql-mvc">SQL-MVC</a> MSSQL example implementation of <a href="http://todomvc.com">todomvc.com</a>

dialect()


ifquery (not key.admin)
ifquery (once.session_showmessageatstartX) 
notify (style=Brief title="Built with SQL-MVC") This entire web application, with layout, menu's, user administration, demo's and documentation is build with SQL-MVC.
endquery
endquery

table()
	Select  --:{Title:"Make new records",from:TODO_MVC,autoinsert:top,tablestyle:Todo}
	first 10
	STATUS, --:{Action:Edit,autosave:yes,onupdate:"owner=session.id"}
	NAME,   --:{Action:Edit,placeholder:"What needs to be done (tab to save)",autosave:yes,onupdate:"owner=session.id"}
	REF	    --:{}
	From TODO_MVC 
	where (owner=session.id and ( (here.todo_type='' and (status!='3' or status is null)) 
	or( (status='' or status is null) and here.todo_type='1')or(status='1' and here.todo_type='2')))
	

use("todo.itemcount",max=600000)

button (title:"View all")
    set here.todo_type='';

button {title:"Active"}
	set here.todo_type='1';

button {title:"Completed"}
	set here.todo_type='2';

use(todo.clear.button)

CloseContainer

use(todo.source_files)
                                                                         
#>

Model

This source file is Models/TodoModel :



<#model

CREATE TABLE TODO_MVC				--:{as:"Table"} 
(
  REF VARCHAR(40),					--:{as:pk}
  NAME VARCHAR(100),				--:{as:text,size:40,title:"todo"}  
  PROGRESS VARCHAR(100),			--:{as:text,size:40,title:"Progress"}  
  OWNER VARCHAR(40),				--:{as:hidden}
  STATUS VARCHAR(10) default ''    	--:{as:ticked}  
);

CREATE INDEX IDX_TODO_MVC1 ON TODO_MVC (REF);
CREATE INDEX IDX_TODO_MVC2 ON TODO_MVC (OWNER,STATUS);

#>

Controller

This source file is Controllers/TodoController :

<#controller(todo.clear.button)
button()
--{title:"Clear Completed",if:"(select count(ref) from TODO_MVC where owner=session.id and status='1')!=0" }
sql update TODO_MVC set status='3' where owner=session.id and (status='1');
#>

<#controller(todo.items) 
($select count(*) from TODO_MVC where owner=session.id and (status='' or status is null) $)
#>

<#controller(todo.itemcountsub)
ifquery (controller.todo.items!=1)
print () controller.todo.items items left
elsequery
print () 1 item left
endquery
#>


<#controller(todo.itemcount,max=5)
ifquery (controller.todo.items>parameter.max)
print () To many items left
elsequery
use(todo.itemcountsub)
endquery
#>


<#controller(todo.source_files)	
html <div align="center"><br><br><br><br></div></div>	

Container( style=Tab                                                                                tab=Info)
rem -------------------------------------------------------------------------------------------------------
notify(style=Heading) Info

rem here should not be used in guest user
rem print() you were here last at here.this_page_info
rem script() set here.this_page_info=cast('now' as timestamp);
html() <br>

print() ($select count(*) from MAIL where FROM_USER=session.id and SUBJECT='login log' $) actions from you 
	and ($select count(*) from MAIL where SUBJECT='login log' $) actions total (in this session).

NextContainer                                                                   (tab=Source_Code)
Container (style=Accordion                                                title=View)
print <b>This source file is <u>here.thisfile</u>:</b>
include (type="pre" file="this" )
NextContainer                                                           (title=Model)
print This source file is Models/TodoModel :
include (type="pre" file="Models/TodoModel" )
NextContainer                                                      (title=Controller)
print This source file is Controllers/TodoController :
include (type="pre" file="Controllers/TodoController" )

CloseContainer                                                                     

CloseContainer                                                                                 
#>

#{title}

#{title}

#{title}

#{title}

Loading...

SQL-MVC Firebird example implementation of todomvc.com

Info