nats_tour_report
Get tour statistics.
Alias: tour_report
Parameters
(Required parameters in bold)
Parameter
|
Description
|
Possible Values
|
Default Value
|
Example
|
siteid
|
The site number
|
Any valid site number.
|
The default site ID number
|
siteid="123"
|
tourid
|
The tour number
|
Any valid site number
|
No tour number
|
tourid="123"
|
period
|
Display stats for this period
|
Any valid period number
|
None.
|
period="1"
|
period_start
|
Start of the period
|
Any date
|
Beginning of current period
|
period_start="26 August 2008"
|
period_end
|
End of the period
|
Any date
|
End of current period
|
period_end="10 September 2008"
|
Output
Puts tour statistics in the {$tour_data} Smarty variable.
Example
You may need to modify this to produce the exact results you are looking for.
Make this your members_tour_report template.
Reference the page at yoursite.com/internal.php?page=tour_report
<table width="100%" border=0 cellpadding=5 cellspacing=0>
<form action="internal.php" method="get">
<input type="hidden" name="page" value="tour_report">
<tr valign="top" bgcolor="#4776A4">
<td ><font size=2 face="verdana,arial" color="#FFFFFF"><B>
<b>Date Range:</b> <select name="period" onchange="period_start.value='';period_end.value='';"><option label="This Period" value="0" {if $smarty.request.period==0}selected{/if}>This Period</option>
<option label="Last Period" value="1" {if $smarty.request.period==1}selected{/if}>Last Period</option>
<option label="This Week" value="2" {if $smarty.request.period==2}selected{/if}>This Week</option>
<option label="This Month" value="3" {if $smarty.request.period==3}selected{/if}>This Month</option>
<option label="This Year" value="4" {if $smarty.request.period==4}selected{/if}>This Year</option>
<option label="Today" value="5" {if $smarty.request.period==5}selected{/if}>Today</option>
<option label="Yesterday" value="6" {if $smarty.request.period==6}selected{/if}>Yesterday</option>
<option label="All Time" value="7" {if $smarty.request.period==7}selected{/if}>All Time</option>
<option label="Freeform:" value="8" {if $smarty.request.period==8}selected{/if}>Freeform:</option>
</select> :
<input type="text" size=10 value="{$smarty.request.period_start|date_format:"%D"}" name="period_start" onChange="period.value=8;"> - <input type="text" size=10 value="{$smarty.request.period_end|date_format:"%D"}" name="period_end" onChange="period.value=8;">
</td>
{list_sites}
<td><B>Site:</b> <select name="siteid">
{foreach from=$sites item=item}
<option label="{$item.name}" value="{$item.id}" {if $smarty.request.siteid==$item.id}selected{/if}>{$item.name}</option>
{/foreach}
</selecT></td>
<td><input type="submit"></td>
</tr>
</table>
{tour_report siteid=$smarty.request.siteid period=$smarty.request.period period_start=$smarty.request.period_start period_end=$smarty.request.period_end}
<table>
<tr>
<td> Tour </td>
<td> Raw </td>
<td> Qualified </td>
<td> Unique </td>
<td> Signup </td>
<td> Initial </td>
<td> Conversion </td>
<td> Rebill </td>
<td> Active </td>
<td> Credit </td>
<td> Chargeback </td>
<td> Raw Ratio </td>
<td> Unique Ratio </td>
</tr>
{foreach from=$tour_data item=data}
<tr>
<td> {if $data.tourid==0}Default{else}{$sites[$smarty.request.siteid].tours[$data.tourid].name}
{foreach from=$sites item=site}
{if $site.id==$data.siteid}
{foreach from=$site.tours item=tour}
{ if $tour.tourid == $data.tourid} {$tour.name} {/if}
{/foreach}
{/if}
{/foreach}
{/if}</td>
<td> {$data.raw} </td>
<td> {$data.qualified} </td>
<td> {$data.unq} </td>
<td> {$data.signup} </td>
<td> {$data.initial} </td>
<td> {$data.conversion} </td>
<td> {$data.rebill} </td>
<td> {$data.active} </td>
<td> {$data.credit} </td>
<td> {$data.chargeback} </td>
<td> {$data.ratio_raw} </td>
<td> {$data.ratio_unq} </td>
</tr>
{foreachelse}
<tr>
<td colspan="13"> Sorry there is no matching data</td>
</tr>
{/foreach}
</table>