User:Woozle/blog/2011/01/14/0620/status update

<hide> <let name=data index=Title>status update</let> <let name=data index=User>Woozle</let> <let name=data index=TopicsUser></let> <let name=data index=TopicsGlobal>\progress\coding</let> <let name=data index=TextAbove>I've been mostly pulled off coding for the past month or two due to various crises (all of which have their roots in a family mental healthcare situation, I should mention for those of you who are fans of business yet against universal healthcare) but I managed to get a few more things working: </let> <let name=data index=TextBelow>* catalog bulk entry (so the listings can finally be updated)

restock request entry (so we can keep track of what we order from suppliers)
restock shipment entry (so we can record what items we actually receive and easily move them into stock)

The next major project is the "Topics" listing, which is kind of crucial for keyword advertising and also helps customers to find what they're looking for. Right now, it's sadly out of date -- and very difficult to maintain.

After that, I have some really interesting ideas for new ways to think about how businesses can more efficiently exchange value with customers.</let>

<let name=data index=TimeStamp>2011-01-14 0620</let> </hide><if not flag=including>==GetLinkBrief()== <func GetLinkBrief>

   <let name=links.out>

</let>

   <let name=links.out append copy=data[Date] />
   <let name=links.out append> :[[</let>
   <let name=links.out append copy=pg_title />
   <let name=links.out append>|more]]:[[Talk:</let>
   <let name=links.out append copy=pg_title />
   <let name=links.out append>|talk]]: </let>

   <if flag=data[wpage]>
     <let name=wtLink>[[</let>
     <let name=wtLink append copy=data[wpage] />
     <let name=wtLink append>|</let>
     <let name=wtLink append copy=data[Title] />
     <let name=wtLink append>]] § </let>
   </if><else>
     <let name=wtLink>[</let>
     <let name=wtLink append copy=data[URL] />
     <let name=wtLink append> </let>
     <let name=wtLink append copy=data[Title] />
     <let name=wtLink append>]</let>
   </else>

   <let name=links.out append copy=wtLink />
   <let name=links.out append> § </let>

   <let name=text copy=data[TextShort] />
   <if flag=text></if><else>
     <let name=text copy=data[Text] len=200 />
   </else>

   <let name=links.out append copy=text trim />
   <let name=links.out append> [[</let>
   <let name=links.out append copy=pg_title />
   <let name=links.out append>|more...]]</let>

</func>

1 ShowRecentLinks(max)
2 ShowTopic(iTopic,iMax)
3 GetBlogEntryBrief()
4 GetBlogEntryBriefChrisFormat()
5 GetBlogEntryFull()
6 ShowRecentBlogEntries(max, funcEntry)
7 ShowRecentBlogEntriesFull(max)
8 ShowRecentBlogEntriesByTopic(max,iTopic)
9 MakeBlogCatgs()
10 ShowBlogPostPage()
11 Specs
- 11.1 In Brief
- 11.2 Full Story
12 Specs

ShowRecentLinks(max)

 <let name=idx />
 <let name=including val=1 />
 <for table="qryW3_Titles_Catgs" where="(cl_to='Data/links') AND (page_namespace=0)" sort="page_title DESC" limit=$max name=pg hide>
   <let name=pg_title val="@row.page_title" />
   <let name=idx inc />
   <if not flag=noLoad>
     <load page=$pg_title />
   </if>
   <if flag=data[Title]>
     <call GetLinkBrief />
   </if><else>
     <let name=links.out>

[[</let>

     <let name=links.out append copy=pg_title />
     <let name=links.out append>]]</let>
   </else>
   <let name=links.rtn append copy=links.out />
   <let name=links.out />
   <let name=data />
 </for>

</func>

ShowTopic(iTopic,iMax)

This should eventually be able to show data in any format: news links, blog entries... <func ShowTopic iTopic iMax>

 <let name=idx />
 <let name=including val=1 />
 <let name=topic farg=iTopic />
 <if not flag=topic>
   <let name=topic parse>Woozle/blog/2011/01/14/0620/status update</let>
 </if>
 <let name=topic self with="_"> </let>

 <let name=sqlWhere>(page_namespace=0) AND (cl_to='</let>
 <let name=sqlWhere append copy=topic />
 <let name=sqlWhere append>')</let>

 <for table="qryW3_Titles_Catgs" where=$sqlWhere sort="page_title DESC" name=pg empty="no items yet" limit=$iMax hide>
   <let name=pg_title val="@row.page_title" />
   <let name=idx inc />
   <if not flag=noLoad>
     <load page=$pg_title local />
   </if>
   <if flag=data[Title]>
     <call GetBrief />
   </if><else>
     <let name=links.out>

[[</let>

     <let name=links.out append copy=pg_title />
     <let name=links.out append>]]</let>
   </else>
   <let name=exclude val=0 />
   <let name=links.rtn append copy=links.out />
   <let name=data null />
 </for>

</func>

GetBlogEntryBrief()

<func GetBlogEntryBrief> INPUT:

 data[*] - from blog entry page
 pg_name - full name of page being displayed (including namespace)

   <if not flag=$noLoad>
     <load page=$pg_name />
   </if>

   <let name=e.out>

</let>

   <let name=e.out append copy=data[TimeStamp] />
   <let name=e.out append> [[</let>
   <let name=e.out append copy=pg_name />
   <let name=e.out append>|</let>
   <let name=e.out append copy=data[Title] />
   <let name=e.out append>]] § </let>

   <let name=text copy=data[TextAbove] />
   <if flag=$text></if><else>
     <let name=text copy=data[TextBelow] len=200 />
   </else>

   <let name=e.out append copy=text trim />
   <let name=e.out append> [[</let>
   <let name=e.out append copy=pg_name />
   <let name=e.out append>|more...]]</let>

</func>

GetBlogEntryBriefChrisFormat()

<func GetBlogEntryBriefChrisFormat> INPUT:

 data[*] - from blog entry page
 pg_name - full name of page being displayed (including namespace)

   <if not flag=noLoad>
     <load page=$pg_name />
   </if>

   <let name=e.out></let>
   <let name=e.out append>[[</let>
   <let name=e.out append copy=pg_name />
   <let name=e.out append>|</let>
   <let name=e.out append copy=data[Title] />
   <let name=e.out append>]], </let>
   <let name=e.out append copy=data[TimeStamp] />
   <let name=e.out append>

</let>

   <let name=text copy=data[TextAbove] />
   <if flag=text></if><else>
     <let name=text copy=data[TextBelow] len=200 />
   </else>

   <let name=e.out append copy=text trim />
   <let name=e.out append> [[</let>
   <let name=e.out append copy=pg_name />
   <let name=e.out append>|more...]]

</let> </func>

GetBlogEntryFull()

<func GetBlogEntryFull> INPUT:

 data[*] - from blog entry page
 pg_name - full name of page being displayed (including namespace)

   <if not flag=noLoad>
     <load page=$pg_name />
   </if>

   <let name=e.out>

==</let>

   <let name=e.out append copy=data[Title] />
   <let name=e.out append>==

posted at </let>

   <let name=e.out append copy=data[TimeStamp] />
   <let name=e.out append>

</let>

   <let name=e.out append copy=data[TextAbove] />
   <let name=e.out append copy=BlogFoldDivider />
   <let name=e.out append copy=data[TextBelow] />

-- category display

   <let name=e.out append copy=BlogFoldDivider />
   <let name=e.out append>

Categories –</let>

   <let name=noCat val=1 />
   <call MakeBlogCatgs />
   <if flag=wtCatGlob>
     <let name=e.out append> general: </let>
     <let name=e.out append copy=wtCatGlob>
   </if>
   <if flag=wtCatUser>
     <let name=e.out append> user: </let>
     <let name=e.out append copy=wtCatUser>
   </if>
   <let name=e.out append></let>

</let> </func>

ShowRecentBlogEntries(max, funcEntry)

Calls GetBlogEntryBrief() by default; $funcEntry overrides that. <func ShowRecentBlogEntries max funcEntry>

 <let name=idx />
 <if not flag=$funcEntry>
   <let name=funcEntry val="GetBlogEntryBrief" />
 </if>
 <let name=sqlFilt>(cl_to='Data/blog/post') AND (page_id != </let>
 <let name=sqlFilt append val=@title.id />
 <let name=sqlFilt append>)</let>
 <for table="categorylinks AS cl LEFT JOIN page AS p ON cl_from=page_id" where=$sqlFilt sort="page_title DESC" limit=$max name=pg hide>
   <let name=pg_nspace_code>{{ns:</let>
   <let name=pg_nspace_code append val=@row.page_namespace />
   <let name=pg_nspace_code append>}}</let>
   <let name=pg_nspace copy=pg_nspace_code parse />
   <let name=pg_title val="@row.page_title" />
   <let name=pg_name copy=pg_nspace />
   <let name=pg_name append>:</let>
   <let name=pg_name append copy=pg_title />
   <let name=idx inc />
   <call func=$funcEntry />
   <let name=e.rtn append copy=e.out />
   <let name=data />
 </for>

</func>

ShowRecentBlogEntriesFull(max)

 <let name=idx />
 <let name=including val=1 />
 <for table="qryW3_Titles_Catgs" where="(cl_to='Data/blog/post')" sort="page_title DESC" limit=$max name=pg hide>
   <let name=pg_nspace_code>{{ns:</let>
   <let name=pg_nspace_code append val=@row.page_namespace />
   <let name=pg_nspace_code append>}}</let>
   <let name=pg_nspace copy=pg_nspace_code parse />
   <let name=pg_title val="@row.page_title" />
   <let name=pg_name copy=pg_nspace />
   <let name=pg_name append>:</let>
   <let name=pg_name append copy=pg_title />
   <let name=idx inc />
   <call GetBlogEntryFull />
   <let name=e.rtn append copy=e.out />
   <let name=data />
 </for>

</func>

ShowRecentBlogEntriesByTopic(max,iTopic)

 <let name=idx />
 <let name=including val=1 />

 <let name=topic farg=iTopic />
 <let name=topic self with="_"> </let>

 <let name=sqlWhere>(cl_to='</let>
 <let name=sqlWhere append copy=topic />
 <let name=sqlWhere append>')</let>

 <let name=noLoad val=1 />

 <for table="qryW3_Titles_Catgs" where=$sqlWhere sort="page_title DESC" limit=$max hide>
   <let name=pg_nspace_code>{{ns:</let>
   <let name=pg_nspace_code append val=@row.page_namespace />
   <let name=pg_nspace_code append>}}</let>
   <let name=pg_nspace copy=pg_nspace_code parse />
   <let name=pg_title val="@row.page_title" />
   <let name=pg_name copy=pg_nspace />
   <let name=pg_name append>:</let>
   <let name=pg_name append copy=pg_title />
   <let name=idx inc />
   <let name=data[Title] null />
   <load page=$pg_name />
   <if flag=data[Title]>
     <call GetBlogEntryBrief />
     <let name=e.rtn append copy=e.out />
   </if>
   <let name=data />
 </for>

</func>

MakeBlogCatgs()

 <let name=catUser copy=data[TopicsUser] />
 <let name=catGlob copy=data[TopicsGlobal] />
 <let name=wtCatUser null />
 <xploop list=$catUser var=topic>
   <let name=wtCatUser append> [[user:</let>
   <let name=wtCatUser append copy=data[User] />
   <let name=wtCatUser append>/</let>
   <let name=wtCatUser append copy=topic />
   <let name=wtCatUser append>|</let>
   <let name=wtCatUser append copy=topic />
   <let name=wtCatUser append>]]</let>

   <let name=wtCatUser append>_{[[:category:user/</let>
   <let name=wtCatUser append copy=data[User] />
   <let name=wtCatUser append>/</let>
   <let name=wtCatUser append copy=topic />
   <let name=wtCatUser append>|c]]}</let>

   <if not flag=noCat>
     <let name=wtCatUser append> [[category:user/</let>
     <let name=wtCatUser append copy=data[User] />
     <let name=wtCatUser append>/</let>
     <let name=wtCatUser append copy=topic />
     <let name=wtCatUser append>|</let>
     <let name=wtCatUser append copy=topic />
     <let name=wtCatUser append>]]</let>
   </if>
 </xploop>
 <let name=wtCatGlob null />
 <xploop list=$catGlob var=topic>
   <let name=wtCatGlob append> [[</let>
   <let name=wtCatGlob append copy=topic />
   <let name=wtCatGlob append>]]</let>

   <let name=wtCatGlob append>_{[[:category:</let>
   <let name=wtCatGlob append copy=topic />
   <let name=wtCatGlob append>|c]]}</let>

   <if not flag=noCat>
     <let name=wtCatGlob append>[[category:</let>
     <let name=wtCatGlob append copy=topic />
     <let name=wtCatGlob append>]]</let>
   </if>

 </xploop>

</func>

ShowBlogPostPage()

 <let name=PostDate copy=data[TimeStamp] len=10 />
 <let name=wtDate>[[</let>
 <let name=wtDate append copy=PostDate />
 <let name=wtDate append>]] ([[:category:</let>
 <let name=wtDate append copy=PostDate />
 <let name=wtDate append>|category]])</let>

 <let name=wtDate append>[[category:</let>
 <let name=wtDate append copy=PostDate />
 <let name=wtDate append>]]</let>

 <let name=wtTitle>

==</let>

 <let name=wtTitle append copy=data[Title] />
 <let name=wtTitle append>==</let>
 <if flag=data[TextAbove]>
   <let name=wtTextBrief>

In Brief </let>

   <let name=wtTextFull>

The Rest </let>

   <let name=wtTextBrief append copy=data[TextAbove] />
 </if><else>
   <let name=wtTextBrief null />
 </else>
 <let name=wtTextFull append copy=data[TextBelow] />

 <call MakeBlogCatgs />

General categories for blog posts: -- the fact that it's a post:

 <let name=wtCatGlob append></let>

-- date:

 <let name=wtCatGlob append>[[category:</let>
 <let name=wtCatGlob append copy=PostDate len=10 /> -- just the date for the category
 <let name=wtCatGlob append>|]]</let>
 <let name=wtCatGlob append copy=PostDate /> -- full timestamp for sorting
 <let name=wtCatGlob append>]]</let>

 <let name=user copy=data[User] />
 <if flag=user>
   <let name=wtUser>[[user:</let>
   <let name=wtUser append copy=user />
   <let name=wtUser append>|</let>
   <let name=wtUser append copy=user />
   <let name=wtUser append>]]</let>
 </if><else>
   <let name=wtUser>unknown</let>
 </else>
 <echo>

Specs
Timestamp:	<get name=PostDate />
Author:	<get name=wtUser />
User topics:	<get name=wtCatUser />
Global topics:	<get name=wtCatGlob />

</echo>

</func> <func ShowBlogPostPage_v1>

 <let name=PostDate copy=data[TimeStamp] len=10 />
 <let name=wtDate>[[</let>
 <let name=wtDate append copy=PostDate />
 <let name=wtDate append>]] ([[:category:</let>
 <let name=wtDate append copy=PostDate />
 <let name=wtDate append>|category]])</let>

 <let name=wtDate append>[[category:</let>
 <let name=wtDate append copy=PostDate />
 <let name=wtDate append>]]</let>

 <let name=wtTitle>

==</let>

 <let name=wtTitle append copy=data[Title] />
 <let name=wtTitle append>==</let>
 <if flag=data[TextAbove]>
   <let name=wtTextBrief>

In Brief

</let>

   <let name=wtTextFull>

Full Story

</let>

   <let name=wtTextBrief append copy=data[TextAbove] />
 </if><else>
   <let name=wtTextBrief null />
 </else>
 <let name=wtTextFull append copy=data[TextBelow] />

 <call MakeBlogCatgs />

General categories for blog posts: -- the fact that it's a post:

 <let name=wtCatGlob append></let>

-- date:

 <let name=wtCatGlob append>[[category:</let>
 <let name=wtCatGlob append copy=PostDate len=10 /> -- just the date for the category
 <let name=wtCatGlob append>|]]</let>
 <let name=wtCatGlob append copy=PostDate /> -- full timestamp for sorting
 <let name=wtCatGlob append>]]</let>

 <let name=user copy=data[User] />
 <if flag=user>
   <let name=wtUser>[[user:</let>
   <let name=wtUser append copy=user />
   <let name=wtUser append>|</let>
   <let name=wtUser append copy=user />
   <let name=wtUser append>]]</let>
 </if><else>
   <let name=wtUser>unknown</let>
 </else>
 <echo>

Specs

Timestamp:	<get name=PostDate />
Author:	<get name=wtUser />
User topics:	<get name=wtCatUser />
Global topics:	<get name=wtCatGlob />

User:Woozle/blog/2011/01/14/0620/status update

Contents

ShowRecentLinks(max)

ShowTopic(iTopic,iMax)

GetBlogEntryBrief()

GetBlogEntryBriefChrisFormat()

GetBlogEntryFull()

ShowRecentBlogEntries(max, funcEntry)

ShowRecentBlogEntriesFull(max)

ShowRecentBlogEntriesByTopic(max,iTopic)

MakeBlogCatgs()

ShowBlogPostPage()

Specs

In Brief

Full Story

Specs

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Wiki Search

wiki links

store links

Tools