PHP Sng\Recordsmanager\Utility Query::setWhere Examples

Example #1

File: Index.php Project: Apen/recordsmanager

 /**
  * Export records if needed
  *
  * @param \Sng\Recordsmanager\Utility\Query $query
  */
 public function exportRecords($query, $mode)
 {
     $pid = \TYPO3\CMS\Core\Utility\GeneralUtility::_GP('pid');
     if (!empty($pid)) {
         $query->setWhere($query->getWhere() . ' AND pid=' . intval($pid));
     }
     $query->execQuery();
     switch ($mode) {
         case 'xml':
             \Sng\Recordsmanager\Controller\ExportController::exportToXML($query, true);
             break;
         case 'csv':
             \Sng\Recordsmanager\Controller\ExportController::exportToCSV($query, true);
             break;
         case 'excel':
             \Sng\Recordsmanager\Controller\ExportController::exportToEXCEL($query);
             break;
         case 'json':
             $this->exportToJson($query);
             header('Content-Type: application/json');
             break;
     }
 }