/**
* Gets an activerecord object associated to the table.
* @param iPlugin $plugin
* @param string $sTableName Name of the table.
* @param string $bPluginTable True if the table is plugin specific.
* @return PluginDynamic
*/
public function getTable(iPlugin $plugin, $sTableName, $bPluginTable = true)
{
if ($bPluginTable) {
$table = $this->getTableName($plugin, $sTableName);
} else {
$table = $sTableName;
}
if (isset($table)) {
return PluginDynamic::model($table);
}
}
/**
* Takes a list of tablenames and creates a nice key value array.
* @param type $list
*/
protected function tableList($tables)
{
$list = array();
if (empty($tables)) {
$list['none'] = gT('No old responses found.');
}
foreach ($tables as $table) {
$count = PluginDynamic::model($table)->count();
$timestamp = date_format(new DateTime(substr($table, -14)), 'Y-m-d H:i:s');
$list[$table] = "{$timestamp} ({$count} responses)";
}
return $list;
}
private function countOldAnswers($sField, $sValue = "")
{
$sQuotedField = Yii::app()->db->quoteColumnName($sField);
if (App()->request->getPost('withuncompleted')) {
return PluginDynamic::model($this->sTableName)->count("{$sQuotedField}=:field{$sField}", array(":field{$sField}" => $sValue));
} else {
return PluginDynamic::model($this->sTableName)->count("submitdate IS NOT NULL AND {$sQuotedField}=:field{$sField}", array(":field{$sField}" => $sValue));
}
}
