/**
* export Comments for a specified page
*
* @param IExporter $exporter exporter to be used
* @param String fields to be exported separated by comma
* @param String orderClause to be used in selecting records
*/
function export($exporter, $fields = null, $orderClause = null)
{
$whereClause = "";
$whereFromFilter = $exporter->getFilter()->getSqlFilterClause();
if ($whereFromFilter != null) {
$whereClause = "WHERE " . $whereFromFilter;
}
$db = new RecordSet($this->dbConnectionInfo);
$select = "*";
if ($fields != null) {
//$select=Utils::arrayToString($fields,",");
$select = $fields;
}
$sql = "SELECT " . $select . " FROM " . $this->tableName . " " . $whereClause;
if ($orderClause != null) {
$sql .= " " . $orderClause;
}
$sql .= ";";
if ($db->Open($sql)) {
$rowArray = $db->getAssoc();
while ($rowArray) {
if (is_array($rowArray)) {
$exporter->exportRow($rowArray);
}
$rowArray = $db->getAssoc();
}
}
$db->Close();
}
/**
* export Comments for a specified page
* @param array $info exporting information
* @param IExporter $exporter exporter to be used
*/
function exportForPage($info, $exporter, $fields = null)
{
$toReturn = "";
$whereClause = " WHERE ";
if ($info["filter_version"] != "" && $info["filter_product"] != "") {
$whereClause .= " version='" . $info["filter_version"] . "' AND product='" . $info["filter_product"] . "'";
} else {
$whereClause = "";
}
if ($this->isLoggedModerator()) {
$db = new RecordSet($this->dbConnectionInfo);
$select = "*";
if ($fields != null) {
$select = Utils::arrayToString($fields, ",");
}
$sql = "SELECT " . $select . " FROM comments " . $whereClause . " ORDER BY date DESC";
if ($db->Open($sql)) {
$rowArray = $db->getAssoc();
while ($rowArray) {
if (is_array($rowArray)) {
$exporter->exportRow($rowArray);
}
$rowArray = $db->getAssoc();
}
}
$db->Close();
} else {
$exporter->exportRow(array('ERROR' => 'Your user rights does not permit this opperation!'));
}
}
