Nats tour report (NATS3)
From TMM Wiki
Jump to navigationJump to searchnats_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>
