tt_address Modification

Modify the following in tt_address > ext_typoscript_setup.txt

This is an example of how to alter the tt_address extension to output another database table and associated fields, for example tx_memberprofile_publications

These tables were created using the kickstarter.

It also takes the value from the url query and inserts it into the sql
query. So

# index.php?id=48&showitem=1&tx_memberprofile[showUid]=22
# index.php?id=48&tx_memberprofile[showUid]=48&&tx_svdgbseminar_pi1[theme]=1

Here is the code and the txt file with the code to download.

Database df_dev - Table tx_memberprofile_publications

# index.php?id=48&showitem=1&tx_memberprofile[showUid]=22

   #index.php?id=48&tx_memberprofile[showUid]=48&&tx_svdgbseminar_pi1[theme]=1

temp.linkparams = COA

temp.linkparams {

#create sub COAs for every possible piVar

10 = COA

10 {

#replace tx_svdgbseminar with the name of the extension you would like to get the
piVars from

10 = TEXT

 10.value = &tx_memberprofile[showUid]=

   #receive the value of the piVar with GPvar as describe in the datatype reference of the
  TS-Ref

   20 = TEXT

   20.data = GPvar : tx_memberprofile | showUid

   #only add the sub COA if the piVar contains something

   if {

   isTrue.data = GPvar : tx_memberprofile | showUid

   }

   }

 #here comes the next sub COA for just another piVar. Add as many sub COAs as required

   20 = COA

   20 {

   10 = TEXT

   10.value = &showitem=

   20 = TEXT

   20.data = GPvar : showitem |

   if {

   isTrue.data = GPvar : showitem |

   }

   }

   }

# temp.PRINT.field = uid

## Transfering to the tt_content.list object:

tt_content.list.20.0 >

tt_content.list.20.0 = CASE

tt_content.list.20.0.key.field = layout

# tt_content.list.20.0.if.isTrue.data = GPvar : tx_svdgbseminar_pi1 | theme

tt_content.list.20.0.if.isTrue.data = GPvar : tx_memberprofile | showUid

tt_content.list.20.0.0 = CONTENT

tt_content.list.20.0.0 {

   table = tx_memberprofile_member

   select.orderBy = first_name

   select.pidInList.field = pages

   select.andWhere.data = GPvar : tx_memberprofile | showUid

   select.andWhere.wrap = member_id='|'

   select.max = 1

   # value = 48

   # select.orderBy = first_name

   # select.pidInList.field = pages

   # select.where = first_name='FIRST NAME'

   # select.where = member_id='48'

   # select.orderBy = {$content.tx_memberprofile_member.orderBy}

    {$content.tx_memberprofile_member.desc}

   # select.where = uid=12 AND something='asdf'
}

[globalVar = GP:showitem = 1 ]

## Introducing rendering information for tx_memberprofile_member:

   tx_memberprofile_member = COA

   tx_memberprofile_member {

   wrap = <table border="0" cellpadding="0" width="200" cellspacing="0">

   <tr><td valign="top"> | </tr></table><br />

   10 = TEXT

   10.field = suffix

   10.case = {$content.tx_memberprofile_member.name.case}

   10.wrap = <h1>|&nbsp;

#Suffix

   11 = TEXT

   11.if.isTrue.field = first_name

   11.dataWrap = {field:first_name}&nbsp;

#Middle Name

   12 = TEXT

   12.if.isTrue.field = middle

   12.dataWrap = {field:middle}&nbsp;

   13 = TEXT

   13.if.isTrue.field = last_name

   13.dataWrap = {field:last_name},&nbsp;

#Degrees

   14 = TEXT

   14.if.isTrue.field = degrees

   14.dataWrap = {field:degrees}&nbsp;</h1>

   20 = COA

   20.wrap = {$content.tx_memberprofile_member.info.wrap}

   20 {

   20 = TEXT

   20.if.isTrue.field = harvard_roles

   20.dataWrap = <hr>{field:harvard_roles}<br />

   21 = TEXT

   21.if.isTrue.field = designated_institution

   21.dataWrap = <br /><b>{field:designated_institution}</b><br />

   22 = TEXT

   22.if.isTrue.field = address

   22.dataWrap = {field:address}<br />

   23 = TEXT

   23.if.isTrue.field = phone

   23.dataWrap = {field:phone}<br />

   24 = TEXT

   24.if.isTrue.field = fax

   24.dataWrap = {field:fax}<br />


   #Address

   25 = TEXT

   25.if.isTrue.field = email

   25.dataWrap = Email: <a href="mailto:{field:email}">{field:email}</a><br /><br />

}

   30 = COA

   30.wrap = {$content.tx_memberprofile_member.info.wrap}

   30 {

   30 = TEXT

   30.if.isTrue.field = assistant

   30.dataWrap = <b>Assistant</b><br />{field:assistant}<br />

}

# DF/HCC Program Affiliation

   40 = COA

   40.wrap = {$content.tx_memberprofile_member.info.wrap}

   40 {

   40 = TEXT

   40.if.isTrue.field = dfhcc_program_roles

   40.dataWrap = <br /><b>dfhcc Program Roles</b><br />
   {field:dfhcc_program_roles}<br />

   41 = TEXT

   41.if.isTrue.field = dfhcc_non_program_roles

   41.dataWrap = <br /><b>dfhcc Non Program Roles</b><br />

    {field:dfhcc_non_program_roles}<br />

   }

   50 = COA

   50.wrap = {$content.tx_memberprofile_member.info.wrap}

   50 {

   table = tx_memberprofile_abstracts

   select.orderBy = researchid

   select.pidInList.field = pages

   select.andWhere.data = {field:abstract_relation}

   select.andWhere.wrap = researchid='|'

   select.max = 1

   50 = TEXT

   # 50.if.isTrue.field = abstract

   50.dataWrap = <br><b>Research Abstract</b><br />

   {field:abstract_relation}<br />

}

   60 = COA

   60.wrap = {$content.tx_memberprofile_member.info.wrap}

   60 {

   50 = TEXT

   50.if.isTrue.field = pubs_relation

   50.dataWrap = <br><b>Publications</b><br />{field:pubs_relation}<br />

}


   70 = TEXT

   80.value = <br /><img src="clear.gif" width="

   {$content.tx_memberprofile_member.info.width}" height="1" alt="" />

   </td><td>&nbsp;</td>

 90 = IMAGE

   90.file.import = uploads/pics/

   90.file.import.field = image

   90.file.import.listNum = 0

   90.file.width = {$content.tx_memberprofile_member.image.width}

   90.wrap = <td valign="top">|</td>

   }

[globalVar = GP:showitem = 2 ]

## Introducing rendering information for tx_memberprofile_member:

   tx_memberprofile_member = COA

   tx_memberprofile_member {

   wrap = Second Wrap <br><table border="0" cellpadding="0" width="200" 

   cellspacing="0"><tr><td valign="top"> | </tr></table><br />

 10 = TEXT

   10.field = suffix

   10.case = {$content.tx_memberprofile_member.name.case}

   10.wrap = <h1>|&nbsp;

#Suffix

   11 = TEXT

   11.if.isTrue.field = first_name

   11.dataWrap = {field:first_name}&nbsp;

#Middle Name

   12 = TEXT

   12.if.isTrue.field = middle

   12.dataWrap = {field:middle}&nbsp;

   13 = TEXT

   13.if.isTrue.field = last_name

   13.dataWrap = {field:last_name},&nbsp;

#Degrees

   14 = TEXT

   14.if.isTrue.field = degrees

   14.dataWrap = {field:degrees}&nbsp;</h1>

   20 = COA

   20.wrap = {$content.tx_memberprofile_member.info.wrap}

   20 {

   20 = TEXT

   20.if.isTrue.field = harvard_roles

   20.dataWrap = <hr>{field:harvard_roles}<br />

   21 = TEXT

   21.if.isTrue.field = designated_institution

   21.dataWrap = <br /><b>{field:designated_institution}</b><br />

   22 = TEXT

   22.if.isTrue.field = address

   22.dataWrap = {field:address}<br />

   23 = TEXT

   23.if.isTrue.field = phone

   23.dataWrap = {field:phone}<br />

   24 = TEXT

   24.if.isTrue.field = fax

   24.dataWrap = {field:fax}<br />

   #Address

   25 = TEXT

   25.if.isTrue.field = email

   25.dataWrap = Email: <a href="mailto:{field:email}">

   {field:email}</a><br /><br />

}

   30 = COA

   30.wrap = {$content.tx_memberprofile_member.info.wrap}

   30 {

   30 = TEXT

   30.if.isTrue.field = assistant

   30.dataWrap = <b>Assistant</b><br />{field:assistant}<br />

}

# DF/HCC Program Affiliation

   40 = COA

   40.wrap = {$content.tx_memberprofile_member.info.wrap}

   40 {

   40 = TEXT

   40.if.isTrue.field = dfhcc_program_roles

   40.dataWrap = <br /><b>dfhcc Program Roles</b><br />

   {field:dfhcc_program_roles}<br />

   41 = TEXT

   41.if.isTrue.field = dfhcc_non_program_roles

   41.dataWrap = <br /><b>dfhcc Non Program Roles</b><br />

   {field:dfhcc_non_program_roles}<br />

   }

   50 = COA

   50.wrap = {$content.tx_memberprofile_member.info.wrap}

   50 {

   table = tx_memberprofile_abstracts

   select.orderBy = researchid

   select.pidInList.field = pages

   select.andWhere.data = {field:abstract_relation}

   select.andWhere.wrap = researchid='|'

   select.max = 1

   50 = TEXT

   # 50.if.isTrue.field = abstract

   50.dataWrap = <br><b>Research Abstract</b><br />

   {field:abstract_relation}<br />

}

   60 = COA

   60.wrap = {$content.tx_memberprofile_member.info.wrap}

   60 {

   50 = TEXT

   50.if.isTrue.field = pubs_relation

   50.dataWrap = <br><b>Publications</b><br />{field:pubs_relation}<br />

}

   70 = TEXT

   80.value = <br /><img src="clear.gif" width="

   {$content.tx_memberprofile_member.info.width}" height="1" alt="" />

   </td><td>&nbsp;</td>

   90 = IMAGE

   90.file.import = uploads/pics/

   90.file.import.field = image

   90.file.import.listNum = 0

   90.file.width = {$content.tx_memberprofile_member.image.width}

   90.wrap = <td valign="top">|</td>

}

Our Specialties

tt_address Modification