-
Notifications
You must be signed in to change notification settings - Fork 0
/
pocket_money.axp
16 lines (16 loc) · 33.7 KB
/
pocket_money.axp
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
<database><databaseName>pocket_money</databaseName><databaseUser></databaseUser><databasePassword></databasePassword><databaseServer>localhost</databaseServer><charEncoding>UTF-8</charEncoding><charEncodingMySQLMB4>False</charEncodingMySQLMB4><noMySQLEncoding>False</noMySQLEncoding><timeFormat>12</timeFormat><rtl>False</rtl><timeZone>Africa/Cairo</timeZone><hideNavMenu>False</hideNavMenu><hideLogin>False</hideLogin><adminServerStatus>True</adminServerStatus><sortTablesAlphabetically>False</sortTablesAlphabetically><styleSheetFile></styleSheetFile><themeFile>bootstrap.css</themeFile><theme3D>False</theme3D><themeCompact>True</themeCompact><scrollStyle>0</scrollStyle><dateFormat>2</dateFormat><dateSeparator>4</dateSeparator><version>23.11</version><lastGenDate>2023-03-25 12:13:11</lastGenDate><outputFolder>C:\xampp\htdocs\pocket-money\app</outputFolder><autoCompleteSize>0</autoCompleteSize><homePageTheme></homePageTheme><filesToKeep><![CDATA[|]]></filesToKeep><filesToOverwrite><![CDATA[|thumbnail.php|link.php|checkMemberID.php|incCommon.php|parent-children.php|ajax_combo.php|ajax_check_unique.php|ajax_check_login.php|ajax_admin_tools.php|ajax-update-calculated-fields.php|login.php|membership_passwordReset.php|membership_profile.php|cli-update-calculated-fields.php|admin\pageAssignOwners.php|admin\pageBackupRestore.php|admin\pageChangeMemberStatus.php|admin\pageDeleteGroup.php|admin\pageDeleteMember.php|admin\pageDeleteRecord.php|admin\pageEditGroup.php|admin\pageEditMember.php|admin\pageEditMemberPermissions.php|admin\pageEditOwnership.php|admin\pageHome.php|admin\pageMail.php|admin\pagePrintRecord.php|admin\pageSender.php|admin\pageSettings.php|admin\pageTransferOwnership.php|admin\pageViewGroups.php|admin\pageViewMembers.php|admin\pageViewRecords.php|admin\pageServerStatus.php|admin\incCommon.php|admin\incFunctions.php|admin\index.php|admin\pageUploadCSV.php|admin\pageRebuildThumbnails.php|admin\pageRebuildFields.php|admin\getUsers.php|admin\ajax-maintenance-mode.php|datalist.php|combo.class.php|date_combo.class.php|data_combo.class.php|defaultFilters.php|lib.php|db.php|setup.php|settings-manager.php|updateDB.php|ci_input.php|kids_view.php|kids_dml.php|kids_autofill.php|templates\kids-ajax-cache.php|transactions_view.php|transactions_dml.php|transactions_autofill.php|templates\transactions-ajax-cache.php|header.php|footer.php|index.html|language.php|language-admin.php|defaultLang.php|index.php|home.php|membership_signup.php|membership_thankyou.php|admin\incFooter.php|admin\incHeader.php|admin\app-documentation.php|templates\kids_templateTV.html|templates\kids_templateTVS.html|templates\kids_templateDV.html|templates\kids_templateDVP.html|templates\children-kids.php|templates\children-kids-printable.php|templates\transactions_templateTV.html|templates\transactions_templateTVS.html|templates\transactions_templateDV.html|templates\transactions_templateDVP.html|templates\children-transactions.php|templates\children-transactions-printable.php|admin\adminStyles.css|admin\toolTipData.js|admin\toolTips.js|common.js.php|dynamic.css.php|blank.gif|table.gif|update.gif|Exit.gif|images\blank.gif|loading.gif|nicEdit.js|nicEditorIcons.gif|photo.gif|handshake.jpg|admin\images\approve_icon.gif|admin\images\data_icon.gif|admin\images\helpBg.gif|admin\images\member_icon.gif|admin\images\members_icon.gif|admin\images\stop_icon.gif|logo.png|hooks\README.html|import-csv.php|common.js|dynamic.css|handshake.svg|shortcuts.js|admin\pageQueryLogs.php|definitions.php|admin\pageSQL.php|admin\pageSQL.js|admin\ajax-sql.php|admin\ajax-saved-sql.php|admin\pageTranslation.php|]]></filesToOverwrite><homepageFirstTableDoubleWidth>True</homepageFirstTableDoubleWidth><homepagePanelHeight>100</homepagePanelHeight><homepageTablesPerRow>4</homepageTablesPerRow><groups><![CDATA[]]></groups><showTechnicalDocumentationAdminArea>False</showTechnicalDocumentationAdminArea><technicalDocumentationApp><![CDATA[]]></technicalDocumentationApp><adminInteractiveSQL>True</adminInteractiveSQL><multipleSuperAdmins>False</multipleSuperAdmins><appUrl><![CDATA[https://gene-eg.com/pocket-money]]></appUrl><table><name>kids</name><allowInsert>False</allowInsert><allowUpdate>False</allowUpdate><allowCSV>True</allowCSV><allowDelete>False</allowDelete><allowDeleteOfParents>False</allowDeleteOfParents><allowFilters>True</allowFilters><filterFirst>False</filterFirst><allowPrint>True</allowPrint><allowMassDelete>False</allowMassDelete><homepageShowCount>True</homepageShowCount><allowDVPrint>True</allowDVPrint><allowSavingFilters>False</allowSavingFilters><allowSelection>True</allowSelection><hideSaveNewWhenEditing>False</hideSaveNewWhenEditing><allowSorting>True</allowSorting><caption><![CDATA[Kids]]></caption><description><![CDATA[]]></description><detailViewLabel><![CDATA[Kid details]]></detailViewLabel><hideTableView>True</hideTableView><quickSearch>1</quickSearch><recordsPerPage>10</recordsPerPage><redirectAfterInsert><![CDATA[kids_view.php?SelectedID=#ID#]]></redirectAfterInsert><filterCount>10</filterCount><lstChildrenLinks>transactions;</lstChildrenLinks><separateDV>True</separateDV><hideLinkHomepage>False</hideLinkHomepage><hideLinkNavMenu>False</hideLinkNavMenu><defaultSortField>2</defaultSortField><defaultSortDirection>asc</defaultSortDirection><childrenLinksTV><![CDATA[]]></childrenLinksTV><parentChildrenSettings><![CDATA[transactions&col;1&col;1&col;Transactions&col;0&col;0&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;]]></parentChildrenSettings><tableIcon>kids.png</tableIcon><tablePaginationAlignment>0</tablePaginationAlignment><enableDVABFloating>True</enableDVABFloating><groupID>0</groupID><allowHomepageAddNew>False</allowHomepageAddNew><TVTemplateID>horizontal</TVTemplateID><TVTemplateHasTitle>False</TVTemplateHasTitle><TVTemplateHideCaptions>False</TVTemplateHideCaptions><TVTemplateImageWidth>25%</TVTemplateImageWidth><TVClasses></TVClasses><DVClasses></DVClasses><technicalDocumentation><![CDATA[]]></technicalDocumentation><autofocusField></autofocusField><field><caption><![CDATA[ID]]></caption><description><![CDATA[]]></description><name>id</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>True</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>True</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>True</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>0</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>right</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Name]]></caption><description><![CDATA[]]></description><name>name</name><dataType>15</dataType><length>40</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>True</notNull><primaryKey>False</primaryKey><unique>True</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>1</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Pocket money]]></caption><description><![CDATA[]]></description><name>pocket_money</name><dataType>8</dataType><length>10</length><precision>2</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>2</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>right</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Photo]]></caption><description><![CDATA[Maximum file size allowed: 2000 KB.<br>Allowed file types: jpg, jpeg, gif, png]]></description><name>photo</name><dataType>15</dataType><length>40</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>True</allowImageUpload><tableImage>True</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>True</thumbTVZoom><thumbTVHeight>50</thumbTVHeight><thumbTVWidth>50</thumbTVWidth><detailImage>True</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>True</thumbDVZoom><thumbDVHeight>250</thumbDVHeight><thumbDVWidth>250</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>2048000</maxUploadSize><allowedFileTypes>jpg|jpeg|gif|png|webp</allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>0</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Last balance]]></caption><description><![CDATA[]]></description><name>last_balance</name><dataType>8</dataType><length>10</length><precision>2</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>True</readOnly><index>3</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>right</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>True</calculatedField><calculatedFieldSQL><![CDATA[SELECT `transactions`.`balance` FROM `kids`
LEFT JOIN `transactions` ON `transactions`.`kid`=`kids`.`id`
WHERE `kids`.`id`='%ID%'
ORDER BY `transactions`.`date` DESC, `transactions`.`id` DESC
LIMIT 1]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field></table><table><name>transactions</name><allowInsert>False</allowInsert><allowUpdate>False</allowUpdate><allowCSV>True</allowCSV><allowDelete>False</allowDelete><allowDeleteOfParents>False</allowDeleteOfParents><allowFilters>True</allowFilters><filterFirst>False</filterFirst><allowPrint>True</allowPrint><allowMassDelete>True</allowMassDelete><homepageShowCount>True</homepageShowCount><allowDVPrint>True</allowDVPrint><allowSavingFilters>False</allowSavingFilters><allowSelection>True</allowSelection><hideSaveNewWhenEditing>False</hideSaveNewWhenEditing><allowSorting>True</allowSorting><caption><![CDATA[Transactions]]></caption><description><![CDATA[]]></description><detailViewLabel><![CDATA[Transaction details]]></detailViewLabel><hideTableView>True</hideTableView><quickSearch>1</quickSearch><recordsPerPage>10</recordsPerPage><redirectAfterInsert><![CDATA[transactions_view.php?SelectedID=#ID#]]></redirectAfterInsert><filterCount>10</filterCount><lstChildrenLinks></lstChildrenLinks><separateDV>False</separateDV><hideLinkHomepage>True</hideLinkHomepage><hideLinkNavMenu>True</hideLinkNavMenu><defaultSortField>3</defaultSortField><defaultSortDirection>desc</defaultSortDirection><childrenLinksTV><![CDATA[]]></childrenLinksTV><parentChildrenSettings><![CDATA[]]></parentChildrenSettings><tableIcon>table_money.png</tableIcon><tablePaginationAlignment>0</tablePaginationAlignment><enableDVABFloating>True</enableDVABFloating><groupID>0</groupID><allowHomepageAddNew>False</allowHomepageAddNew><TVTemplateID>horizontal</TVTemplateID><TVTemplateHasTitle>False</TVTemplateHasTitle><TVTemplateHideCaptions>False</TVTemplateHideCaptions><TVTemplateImageWidth>25%</TVTemplateImageWidth><TVClasses></TVClasses><DVClasses></DVClasses><technicalDocumentation><![CDATA[]]></technicalDocumentation><autofocusField></autofocusField><field><caption><![CDATA[ID]]></caption><description><![CDATA[]]></description><name>id</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>True</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>True</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>True</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>0</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>right</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Kid]]></caption><description><![CDATA[]]></description><name>kid</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField>name</parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField>id</parentIDField><parentTable>kids</parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>1</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Date]]></caption><description><![CDATA[]]></description><name>date</name><dataType>10</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>0</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Amount]]></caption><description><![CDATA[Enter a postive value for deposits, or a negative value for withdrawals/spending.]]></description><name>amount</name><dataType>7</dataType><length>10</length><precision>2</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>2</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>right</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Description]]></caption><description><![CDATA[]]></description><name>description</name><dataType>18</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>0</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Balance]]></caption><description><![CDATA[]]></description><name>balance</name><dataType>7</dataType><length>10</length><precision>2</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>True</readOnly><index>3</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>right</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>True</calculatedField><calculatedFieldSQL><![CDATA[SELECT SUM(`transactions`.`amount`) FROM `transactions`
WHERE
(
`transactions`.`date` < (SELECT `transactions`.`date` FROM `transactions` WHERE `transactions`.`id` = '%ID%')
OR
(
`transactions`.`date` = (SELECT `transactions`.`date` FROM `transactions` WHERE `transactions`.`id` = '%ID%') AND
`transactions`.`id` <= '%ID%'
)
)
AND
`transactions`.`kid` = (SELECT `transactions`.`kid` FROM `transactions` WHERE `transactions`.`id` = '%ID%')]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field></table></database>