\documentclass[10pt,a4paper]{article}

% Packages
\usepackage{fancyhdr}           % For header and footer
\usepackage{multicol}           % Allows multicols in tables
\usepackage{tabularx}           % Intelligent column widths
\usepackage{tabulary}           % Used in header and footer
\usepackage{hhline}             % Border under tables
\usepackage{graphicx}           % For images
\usepackage{xcolor}             % For hex colours
%\usepackage[utf8x]{inputenc}    % For unicode character support
\usepackage[T1]{fontenc}        % Without this we get weird character replacements
\usepackage{colortbl}           % For coloured tables
\usepackage{setspace}           % For line height
\usepackage{lastpage}           % Needed for total page number
\usepackage{seqsplit}           % Splits long words.
%\usepackage{opensans}          % Can't make this work so far. Shame. Would be lovely.
\usepackage[normalem]{ulem}     % For underlining links
% Most of the following are not required for the majority
% of cheat sheets but are needed for some symbol support.
\usepackage{amsmath}            % Symbols
\usepackage{MnSymbol}           % Symbols
\usepackage{wasysym}            % Symbols
%\usepackage[english,german,french,spanish,italian]{babel}              % Languages

% Document Info
\author{blinkdata}
\pdfinfo{
  /Title (blinkdata-framework.pdf)
  /Creator (Cheatography)
  /Author (blinkdata)
  /Subject (Blinkdata Framework Cheat Sheet)
}

% Lengths and widths
\addtolength{\textwidth}{6cm}
\addtolength{\textheight}{-1cm}
\addtolength{\hoffset}{-3cm}
\addtolength{\voffset}{-2cm}
\setlength{\tabcolsep}{0.2cm} % Space between columns
\setlength{\headsep}{-12pt} % Reduce space between header and content
\setlength{\headheight}{85pt} % If less, LaTeX automatically increases it
\renewcommand{\footrulewidth}{0pt} % Remove footer line
\renewcommand{\headrulewidth}{0pt} % Remove header line
\renewcommand{\seqinsert}{\ifmmode\allowbreak\else\-\fi} % Hyphens in seqsplit
% This two commands together give roughly
% the right line height in the tables
\renewcommand{\arraystretch}{1.3}
\onehalfspacing

% Commands
\newcommand{\SetRowColor}[1]{\noalign{\gdef\RowColorName{#1}}\rowcolor{\RowColorName}} % Shortcut for row colour
\newcommand{\mymulticolumn}[3]{\multicolumn{#1}{>{\columncolor{\RowColorName}}#2}{#3}} % For coloured multi-cols
\newcolumntype{x}[1]{>{\raggedright}p{#1}} % New column types for ragged-right paragraph columns
\newcommand{\tn}{\tabularnewline} % Required as custom column type in use

% Font and Colours
\definecolor{HeadBackground}{HTML}{333333}
\definecolor{FootBackground}{HTML}{666666}
\definecolor{TextColor}{HTML}{333333}
\definecolor{DarkBackground}{HTML}{000000}
\definecolor{LightBackground}{HTML}{F7F7F7}
\renewcommand{\familydefault}{\sfdefault}
\color{TextColor}

% Header and Footer
\pagestyle{fancy}
\fancyhead{} % Set header to blank
\fancyfoot{} % Set footer to blank
\fancyhead[L]{
\noindent
\begin{multicols}{3}
\begin{tabulary}{5.8cm}{C}
    \SetRowColor{DarkBackground}
    \vspace{-7pt}
    {\parbox{\dimexpr\textwidth-2\fboxsep\relax}{\noindent
        \hspace*{-6pt}\includegraphics[width=5.8cm]{/web/www.cheatography.com/public/images/cheatography_logo.pdf}}
    }
\end{tabulary}
\columnbreak
\begin{tabulary}{11cm}{L}
    \vspace{-2pt}\large{\bf{\textcolor{DarkBackground}{\textrm{Blinkdata Framework Cheat Sheet}}}} \\
    \normalsize{by \textcolor{DarkBackground}{blinkdata} via \textcolor{DarkBackground}{\uline{cheatography.com/7996/cs/2681/}}}
\end{tabulary}
\end{multicols}}

\fancyfoot[L]{ \footnotesize
\noindent
\begin{multicols}{3}
\begin{tabulary}{5.8cm}{LL}
  \SetRowColor{FootBackground}
  \mymulticolumn{2}{p{5.377cm}}{\bf\textcolor{white}{Cheatographer}}  \\
  \vspace{-2pt}blinkdata \\
  \uline{cheatography.com/blinkdata} \\
  \end{tabulary}
\vfill
\columnbreak
\begin{tabulary}{5.8cm}{L}
  \SetRowColor{FootBackground}
  \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Cheat Sheet}}  \\
   \vspace{-2pt}Not Yet Published.\\
   Updated 12th May, 2016.\\
   Page {\thepage} of \pageref{LastPage}.
\end{tabulary}
\vfill
\columnbreak
\begin{tabulary}{5.8cm}{L}
  \SetRowColor{FootBackground}
  \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Sponsor}}  \\
  \SetRowColor{white}
  \vspace{-5pt}
  %\includegraphics[width=48px,height=48px]{dave.jpeg}
  Measure your website readability!\\
  www.readability-score.com
\end{tabulary}
\end{multicols}}




\begin{document}
\raggedright
\raggedcolumns

% Set font size to small. Switch to any value
% from this page to resize cheat sheet text:
% www.emerson.emory.edu/services/latex/latex_169.html
\footnotesize % Small font.

\begin{multicols*}{2}

\begin{tabularx}{8.4cm}{x{2.64 cm} x{5.36 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{mainrules, childRules}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{8.4cm}}{caption} \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
\mymulticolumn{2}{x{8.4cm}}{fieldname} \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
fieldtype & (see section) \tn 
% Row Count 3 (+ 1)
% Row 3
\SetRowColor{white}
formcolumn & left, right, both, same, *auto \tn 
% Row Count 5 (+ 2)
% Row 4
\SetRowColor{LightBackground}
default & Can use "NOW" for dates \tn 
% Row Count 6 (+ 1)
% Row 5
\SetRowColor{white}
inclbutton & true, *false \tn 
% Row Count 7 (+ 1)
% Row 6
\SetRowColor{LightBackground}
incllabel & *true, false \tn 
% Row Count 8 (+ 1)
% Row 7
\SetRowColor{white}
\mymulticolumn{2}{x{8.4cm}}{maxlength} \tn 
% Row Count 9 (+ 1)
% Row 8
\SetRowColor{LightBackground}
noedit & true, *false \tn 
% Row Count 10 (+ 1)
% Row 9
\SetRowColor{white}
nosave & true, *false \tn 
% Row Count 11 (+ 1)
% Row 10
\SetRowColor{LightBackground}
suffix & "html to display after the control" \tn 
% Row Count 13 (+ 2)
% Row 11
\SetRowColor{white}
validation & (see section) \tn 
% Row Count 14 (+ 1)
% Row 12
\SetRowColor{LightBackground}
\seqsplit{validationcaption} & Used instead of caption \tn 
% Row Count 16 (+ 2)
% Row 13
\SetRowColor{white}
visibility & add|edit|delete|display, *all \tn 
% Row Count 18 (+ 2)
% Row 14
\SetRowColor{LightBackground}
\seqsplit{afterchildrows} & true, *false \tn 
% Row Count 20 (+ 2)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{8.4cm}}{See ajax combos section for extra properties.  These are set in the model}  \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{3.6 cm} x{4.4 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{Ajax Combos (for mainrules and childRules)}}  \tn
% Row 0
\SetRowColor{LightBackground}
relatedajaxurl & "/stock/ajaxlookup" \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
relatedajaxmodel & "StockModel" \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{8.4cm}}{\seqsplit{relatedajaxdescriptionurl}} \tn 
% Row Count 3 (+ 1)
% Row 3
\SetRowColor{white}
\seqsplit{relatedentityidfield} & "\#entityid" \tn 
% Row Count 5 (+ 2)
% Row 4
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{8.4cm}}{} \tn 
% Row Count 5 (+ 0)
% Row 5
\SetRowColor{white}
relatedtable & "stock\_master" \tn 
% Row Count 6 (+ 1)
% Row 6
\SetRowColor{LightBackground}
\seqsplit{relateddisplayfield} & "title" \tn 
% Row Count 8 (+ 2)
% Row 7
\SetRowColor{white}
relatedkeyfield & "stockid" \tn 
% Row Count 9 (+ 1)
% Row 8
\SetRowColor{LightBackground}
relatedorderby & "date" \tn 
% Row Count 10 (+ 1)
% Row 9
\SetRowColor{white}
relatedwhere & "recordtype='FT'" \tn 
% Row Count 11 (+ 1)
% Row 10
\SetRowColor{LightBackground}
\{\{nobreak\}\}relatedinclnotrequired & false, *true \tn 
% Row Count 13 (+ 2)
% Row 11
\SetRowColor{white}
relatedvalues & \{\{noshy\}\}array("1"=\textgreater{}"Active", "2"=\textgreater{}"Prospect") \tn 
% Row Count 16 (+ 3)
% Row 12
\SetRowColor{LightBackground}
\seqsplit{relateddefaultflagfield} & "defaultrow" \tn 
% Row Count 18 (+ 2)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{8.4cm}}{These are extra properties for mainrules and childrules.  Set these in the model}  \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{3.76 cm} x{4.24 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{childRowButtons}}  \tn
% Row 0
\SetRowColor{LightBackground}
name & "btn1" \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
caption & "test1" \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
icon & "pencil" \tn 
% Row Count 3 (+ 1)
% Row 3
\SetRowColor{white}
method & "test1" \tn 
% Row Count 4 (+ 1)
% Row 4
\SetRowColor{LightBackground}
color & "blue" \tn 
% Row Count 5 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{2.4 cm} x{5.6 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{listcolumns}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{8.4cm}}{caption} \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
\mymulticolumn{2}{x{8.4cm}}{fieldname} \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
fieldtype & date, email, link, yesno, *text \tn 
% Row Count 4 (+ 2)
% Row 3
\SetRowColor{white}
align & *left, right, center \tn 
% Row Count 5 (+ 1)
% Row 4
\SetRowColor{LightBackground}
\seqsplit{columnpercent} & \#\# (no \%) \tn 
% Row Count 7 (+ 2)
% Row 5
\SetRowColor{white}
\seqsplit{columnpixels} & \#\#\# (no px) \tn 
% Row Count 8 (+ 1)
% Row 6
\SetRowColor{LightBackground}
sortable & true, *false \tn 
% Row Count 9 (+ 1)
% Row 7
\SetRowColor{white}
linkmethod & "/ipaddress/display" \tn 
% Row Count 10 (+ 1)
% Row 8
\SetRowColor{LightBackground}
linkanchor & "?var=value\#anchor" \tn 
% Row Count 11 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{8.4cm}}{These are for the listviews.  Set these in the model}  \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{3.76 cm} x{4.24 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{listHeaderButtons}}  \tn
% Row 0
\SetRowColor{LightBackground}
name & "btn1" \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
caption & "test1" \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
icon & "pencil" \tn 
% Row Count 3 (+ 1)
% Row 3
\SetRowColor{white}
method & "test1" \tn 
% Row Count 4 (+ 1)
% Row 4
\SetRowColor{LightBackground}
color & "blue" \tn 
% Row Count 5 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{3.76 cm} x{4.24 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{listRowButtons}}  \tn
% Row 0
\SetRowColor{LightBackground}
name & "btn1" \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
caption & "test1" \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
icon & "pencil" \tn 
% Row Count 3 (+ 1)
% Row 3
\SetRowColor{white}
method & "test1" \tn 
% Row Count 4 (+ 1)
% Row 4
\SetRowColor{LightBackground}
color & "blue" \tn 
% Row Count 5 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{3.76 cm} x{4.24 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{validation}}  \tn
% Row 0
\SetRowColor{LightBackground}
email & trim \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
ltrim & rtrim \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
strtoupper & strtolower \tn 
% Row Count 3 (+ 1)
% Row 3
\SetRowColor{white}
required & requirednotzero \tn 
% Row Count 4 (+ 1)
% Row 4
\SetRowColor{LightBackground}
date & time \tn 
% Row Count 5 (+ 1)
% Row 5
\SetRowColor{white}
alpha & alphanumeric \tn 
% Row Count 6 (+ 1)
% Row 6
\SetRowColor{LightBackground}
integer & positiveinteger \tn 
% Row Count 7 (+ 1)
% Row 7
\SetRowColor{white}
2decimals & exactlength{[}10{]} \tn 
% Row Count 8 (+ 1)
% Row 8
\SetRowColor{LightBackground}
maxlength{[}10{]} & minlength{[}10{]} \tn 
% Row Count 9 (+ 1)
% Row 9
\SetRowColor{white}
\textgreater{}={[}20{]} & \textless{}={[}20{]} \tn 
% Row Count 10 (+ 1)
% Row 10
\SetRowColor{LightBackground}
intable{[}table.field{]} & notintable{[}table.field{]} \tn 
% Row Count 12 (+ 2)
% Row 11
\SetRowColor{white}
\mymulticolumn{2}{x{8.4cm}}{unique} \tn 
% Row Count 13 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{4.08 cm} x{3.92 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{Fieldtypes}}  \tn
% Row 0
\SetRowColor{LightBackground}
label & textarea \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
textboxsmall & textboxmedium \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
textboxlarge & password \tn 
% Row Count 3 (+ 1)
% Row 3
\SetRowColor{white}
radio & checkbox \tn 
% Row Count 4 (+ 1)
% Row 4
\SetRowColor{LightBackground}
money & percent \tn 
% Row Count 5 (+ 1)
% Row 5
\SetRowColor{white}
date & time \tn 
% Row Count 6 (+ 1)
% Row 6
\SetRowColor{LightBackground}
email & phone \tn 
% Row Count 7 (+ 1)
% Row 7
\SetRowColor{white}
ipaddress & url \tn 
% Row Count 8 (+ 1)
% Row 8
\SetRowColor{LightBackground}
formsection & warningtext \tn 
% Row Count 9 (+ 1)
% Row 9
\SetRowColor{white}
tags & hidden \tn 
% Row Count 10 (+ 1)
% Row 10
\SetRowColor{LightBackground}
droplistsmall & droplistmedium \tn 
% Row Count 11 (+ 1)
% Row 11
\SetRowColor{white}
droplistlarge & droplistarraysmall \tn 
% Row Count 12 (+ 1)
% Row 12
\SetRowColor{LightBackground}
droplistarraymedium & droplistarraylarge \tn 
% Row Count 13 (+ 1)
% Row 13
\SetRowColor{white}
ajaxlistmedium & lookuplabel \tn 
% Row Count 14 (+ 1)
% Row 14
\SetRowColor{LightBackground}
*datelabel & *trimzeros \tn 
% Row Count 15 (+ 1)
% Row 15
\SetRowColor{white}
\mymulticolumn{2}{x{8.4cm}}{*text} \tn 
% Row Count 16 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{8.4cm}}{* = display control only}  \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{col2a}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{1}{x{8.4cm}}{} \tn 
% Row Count 0 (+ 0)
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{3.76 cm} x{4.24 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{mvchtmlhelpers}}  \tn
% Row 0
\SetRowColor{LightBackground}
Trademark & Copyright \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
\mymulticolumn{2}{x{8.4cm}}{Br} \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
TextboxSmall & TextboxMedium \tn 
% Row Count 3 (+ 1)
% Row 3
\SetRowColor{white}
TextboxLarge & Textarea \tn 
% Row Count 4 (+ 1)
% Row 4
\SetRowColor{LightBackground}
Email & Money \tn 
% Row Count 5 (+ 1)
% Row 5
\SetRowColor{white}
Datebox & Timebox \tn 
% Row Count 6 (+ 1)
% Row 6
\SetRowColor{LightBackground}
FormatDate & FormatDateTime \tn 
% Row Count 7 (+ 1)
% Row 7
\SetRowColor{white}
Percent & Password \tn 
% Row Count 8 (+ 1)
% Row 8
\SetRowColor{LightBackground}
Checkbox & Radio \tn 
% Row Count 9 (+ 1)
% Row 9
\SetRowColor{white}
Hidden & Phone \tn 
% Row Count 10 (+ 1)
% Row 10
\SetRowColor{LightBackground}
FormSection & WarningText \tn 
% Row Count 11 (+ 1)
% Row 11
\SetRowColor{white}
Label & RawLabel \tn 
% Row Count 12 (+ 1)
% Row 12
\SetRowColor{LightBackground}
IPV4Address & Url \tn 
% Row Count 13 (+ 1)
% Row 13
\SetRowColor{white}
OKButton & ExitButton \tn 
% Row Count 14 (+ 1)
% Row 14
\SetRowColor{LightBackground}
OKCancelButons & DeleteCancelButtons \tn 
% Row Count 15 (+ 1)
% Row 15
\SetRowColor{white}
UndoCancelButtons & Button \tn 
% Row Count 16 (+ 1)
% Row 16
\SetRowColor{LightBackground}
ButtonsX1 & ButtonsX2 \tn 
% Row Count 17 (+ 1)
% Row 17
\SetRowColor{white}
DropListSmall & DropListMedium \tn 
% Row Count 18 (+ 1)
% Row 18
\SetRowColor{LightBackground}
DropListLarge & DropListSmall2 \tn 
% Row Count 19 (+ 1)
% Row 19
\SetRowColor{white}
DropListMedium2 & DropListLarge2 \tn 
% Row Count 20 (+ 1)
% Row 20
\SetRowColor{LightBackground}
GridButton & ListHeaderButton \tn 
% Row Count 21 (+ 1)
% Row 21
\SetRowColor{white}
MessageWarning & MessageSuccess \tn 
% Row Count 22 (+ 1)
% Row 22
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{8.4cm}}{MessageInfo} \tn 
% Row Count 23 (+ 1)
% Row 23
\SetRowColor{white}
span1colm & span2colm \tn 
% Row Count 24 (+ 1)
% Row 24
\SetRowColor{LightBackground}
span3colm & span4colm \tn 
% Row Count 25 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{3.36 cm} x{4.64 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{mvchtmlhelpers AjaxLookup}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{8.4cm}}{ajaxLookupHeader} \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
\{\{noshy\}\}ajaxLookup & \$name, \$caption, \$value, \$\{\{noshy\}\}modelname, \$incllabel, \$makefit \tn 
% Row Count 4 (+ 3)
% Row 2
\SetRowColor{LightBackground}
\{\{noshy\}\}ajaxLookupJavascript & \$name, \$relatedajaxurl, \$relatedajaxde\{\{noshy\}\}scriptionurl, \$relatedentityidfield \tn 
% Row Count 8 (+ 4)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{p{2.48 cm} x{5.52 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{Colors}}  \tn
% Row 0
\SetRowColor{LightBackground}
blue & light blue \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
red & yellow \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
green & purple \tn 
% Row Count 3 (+ 1)
% Row 3
\SetRowColor{white}
grey & light grey \tn 
% Row Count 4 (+ 1)
% Row 4
\SetRowColor{LightBackground}
black & transparent \tn 
% Row Count 5 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{4.56 cm} x{3.44 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{Session and useful Variables}}  \tn
% Row 0
\SetRowColor{LightBackground}
\$session-\textgreater{}companyID & Active company \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
\$session-\textgreater{}userID & Active user \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
\$current\_user & Enter user record \tn 
% Row Count 3 (+ 1)
% Row 3
\SetRowColor{white}
\$current\_company-\textgreater{}countryid & Country code (eg 64) \tn 
% Row Count 5 (+ 2)
% Row 4
\SetRowColor{LightBackground}
HOMEPAGE & "/dashboard" \tn 
% Row Count 6 (+ 1)
% Row 5
\SetRowColor{white}
SERVER & \seqsplit{"http://localhost"} \tn 
% Row Count 8 (+ 2)
% Row 6
\SetRowColor{LightBackground}
PREPATH & \seqsplit{"http://localost"} \tn 
% Row Count 9 (+ 1)
% Row 7
\SetRowColor{white}
\seqsplit{DEVELOPMENT\_ENVIRONMENT} & false \tn 
% Row Count 11 (+ 2)
% Row 8
\SetRowColor{LightBackground}
IS\_AJAX\_REQUEST & true/false \tn 
% Row Count 12 (+ 1)
% Row 9
\SetRowColor{white}
PRODUCTNAME & "MyPayroll" \tn 
% Row Count 13 (+ 1)
% Row 10
\SetRowColor{LightBackground}
COMPANYNAME & "Blinkdata" \tn 
% Row Count 14 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{4.64 cm} x{3.36 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{ezsql - db}}  \tn
% Row 0
\SetRowColor{LightBackground}
escape(\$value) & \seqsplit{escapelike(\$value)} \tn 
% Row Count 2 (+ 2)
% Row 1
\SetRowColor{white}
query(\$sql) & \seqsplit{get\_scalar(\$sql)} \tn 
% Row Count 3 (+ 1)
% Row 2
\SetRowColor{LightBackground}
get\_row(\$sql) & \seqsplit{get\_results(\$sql)} \tn 
% Row Count 5 (+ 2)
% Row 3
\SetRowColor{white}
column\_exists(\$table,\$field) & \seqsplit{table\_exists(\$table)} \tn 
% Row Count 7 (+ 2)
% Row 4
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{8.4cm}}{index\_exists(\$table,\$idxname)} \tn 
% Row Count 8 (+ 1)
% Row 5
\SetRowColor{white}
\mymulticolumn{2}{x{8.4cm}}{sysdate()} \tn 
% Row Count 9 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{4.4 cm} x{3.6 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{sqlbase}}  \tn
% Row 0
\SetRowColor{LightBackground}
\$sqlbase-\textgreater{}fieldname = \$value & SQLescape() \tn 
% Row Count 2 (+ 2)
% Row 1
\SetRowColor{white}
SQLinsert() & \seqsplit{SQLinsertWithIdentity()} \tn 
% Row Count 4 (+ 2)
% Row 2
\SetRowColor{LightBackground}
SQLupdate() & \seqsplit{SQLupdateNoWhere()} \tn 
% Row Count 5 (+ 1)
% Row 3
\SetRowColor{white}
SQLdelete() & \seqsplit{SQLdeleteNoWhere()} \tn 
% Row Count 6 (+ 1)
% Row 4
\SetRowColor{LightBackground}
SQLclear() & SQLreset() \tn 
% Row Count 7 (+ 1)
% Row 5
\SetRowColor{white}
SQLsetwhere(\$where) & \seqsplit{SQLandwhere(\$where)} \tn 
% Row Count 9 (+ 2)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{2.72 cm} x{5.28 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{listcontroller (add, edit, copy)}}  \tn
% Row 0
\SetRowColor{LightBackground}
add() & Edit\_EditHook\_Clean \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
 & \$listcontroller-\textgreater{}editRecord \tn 
% Row Count 3 (+ 2)
% Row 2
\SetRowColor{LightBackground}
edit(\$id=0) & testDelegateEdit \tn 
% Row Count 4 (+ 1)
% Row 3
\SetRowColor{white}
 & Edit\_EditHook\_Clean \tn 
% Row Count 5 (+ 1)
% Row 4
\SetRowColor{LightBackground}
 & \$listcontroller-\textgreater{}editRecord \tn 
% Row Count 7 (+ 2)
% Row 5
\SetRowColor{white}
\seqsplit{copyrow(\$id=0)} & testDelegateCopy \tn 
% Row Count 9 (+ 2)
% Row 6
\SetRowColor{LightBackground}
 & Edit\_CopyHook\_Clean \tn 
% Row Count 10 (+ 1)
% Row 7
\SetRowColor{white}
 & \$listcontroller-\textgreater{}editRecord \tn 
% Row Count 12 (+ 2)
% Row 8
\SetRowColor{LightBackground}
\seqsplit{delete(\$id=0)} & testDelegateDelete \tn 
% Row Count 13 (+ 1)
% Row 9
\SetRowColor{white}
 & Delete\_Hook \tn 
% Row Count 14 (+ 1)
% Row 10
\SetRowColor{LightBackground}
 & deleteconfirm \tn 
% Row Count 15 (+ 1)
% Row 11
\SetRowColor{white}
\seqsplit{display(\$id=0)} & testDelegateDisplay \tn 
% Row Count 17 (+ 2)
% Row 12
\SetRowColor{LightBackground}
 & Display\_Hook \tn 
% Row Count 18 (+ 1)
% Row 13
\SetRowColor{white}
index(\$id=0) & Index\_Hook\_Before(\$id) \tn 
% Row Count 19 (+ 1)
% Row 14
\SetRowColor{LightBackground}
 & Index\_Hook\_BeforeDisplay \tn 
% Row Count 20 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{2.32 cm} x{5.68 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{listcontroller (editRecord)}}  \tn
% Row 0
\SetRowColor{LightBackground}
editRecord & EditRecord\_Add\_Hook / Edit / Copy \tn 
% Row Count 2 (+ 2)
% Row 1
\SetRowColor{white}
\seqsplit{editconfirm(\$id)} & \seqsplit{EditConfirm\_Hook\_BeforeEverything} \tn 
% Row Count 4 (+ 2)
% Row 2
\SetRowColor{LightBackground}
 & testDelegateEdit / Copy \tn 
% Row Count 5 (+ 1)
% Row 3
\SetRowColor{white}
 & \seqsplit{EditConfirm\_Hook\_GatherAndValidateAllChildren} \tn 
% Row Count 7 (+ 2)
% Row 4
\SetRowColor{LightBackground}
 & \seqsplit{EditConfirm\_Hook\_GatherAndValidateChildRow} \tn 
% Row Count 9 (+ 2)
% Row 5
\SetRowColor{white}
 & \seqsplit{EditConfirm\_Hook\_GatherAndValidateAllChildren} \tn 
% Row Count 11 (+ 2)
% Row 6
\SetRowColor{LightBackground}
 & \seqsplit{EditConfirm\_Hook\_RemapPostValues} \tn 
% Row Count 13 (+ 2)
% Row 7
\SetRowColor{white}
 & \seqsplit{EditConfirm\_Hook\_Validate} \tn 
% Row Count 14 (+ 1)
% Row 8
\SetRowColor{LightBackground}
 & \seqsplit{EditConfirm\_Hook\_BeforeUpdate} \tn 
% Row Count 16 (+ 2)
% Row 9
\SetRowColor{white}
 & \seqsplit{EditConfirm\_Hook\_AfterUpdate} \tn 
% Row Count 17 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{2.4 cm} x{5.6 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{model}}  \tn
% Row 0
\SetRowColor{LightBackground}
AddRecord & AddRecord\_Hook\_Before \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
 & \seqsplit{AddRecord\_Hook\_SqlHandler} \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
 & AddRecord\_Hook\_After \tn 
% Row Count 3 (+ 1)
% Row 3
\SetRowColor{white}
\seqsplit{UpdateRecord} & (also used for copy) \tn 
% Row Count 4 (+ 1)
% Row 4
\SetRowColor{LightBackground}
 & UpdateRecord\_Hook\_Before \tn 
% Row Count 5 (+ 1)
% Row 5
\SetRowColor{white}
 & \seqsplit{UpdateRecord\_Hook\_SqlHandler} \tn 
% Row Count 6 (+ 1)
% Row 6
\SetRowColor{LightBackground}
 & \seqsplit{UpdateChildRecord\_Hook\_SqlHandler} \tn 
% Row Count 8 (+ 2)
% Row 7
\SetRowColor{white}
 & CopyRecord\_Hook (copy only) \tn 
% Row Count 9 (+ 1)
% Row 8
\SetRowColor{LightBackground}
 & UpdateRecord\_Hook\_After \tn 
% Row Count 10 (+ 1)
% Row 9
\SetRowColor{white}
delete & Delete\_Hook\_Before \tn 
% Row Count 11 (+ 1)
% Row 10
\SetRowColor{LightBackground}
 & Delete\_Hook\_After \tn 
% Row Count 12 (+ 1)
% Row 11
\SetRowColor{white}
validate & Validate\_Hook\_Before \tn 
% Row Count 13 (+ 1)
% Row 12
\SetRowColor{LightBackground}
 & Validate\_Hook\_After \tn 
% Row Count 14 (+ 1)
% Row 13
\SetRowColor{white}
\seqsplit{getEmptyRecord} & GetEmptyRecord\_Hook \tn 
% Row Count 16 (+ 2)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}


% That's all folks
\end{multicols*}

\end{document}