$nShowRows = $_REQUEST['nShowRows'];
//http://cuteflowbranch/pages/todo_feed.php?language=de&archivemode=0&start=1&nShowRows=50&sortby=COL_CIRCULATION_PROCESS_DAYS&sortDirection=DESC&uid=1
$objRssFeed = new RssFeed();
$objCirculation = new CCirculation();
$arrCirculationOverview = $objCirculation->getCirculationOverview($start, $sortby, $sortDirection, $archivemode, 50, 0, '', false, false, $_REQUEST['uid']);
foreach ($arrCirculationOverview as $item) {
$feed_item = new RssFeedItem();
$feed_item->setTitle($item['strName']);
$nCirculationFormID = $item['nID'];
$nSenderID = $item['nSenderId'];
$strTitle = $item['strName'];
$nMailingListId = $item['nMailingListId'];
if ($item['strCurStation'] != '') {
$strCurStation = $item['strCurStation'];
}
$arrDecissionState = $objCirculation->getDecissionState($nCirculationFormID);
$strStartDate = $objCirculation->getStartDate($nCirculationFormID);
$strSender = $objCirculation->getSender($nCirculationFormID);
$arrMaillist = $objCirculation->getMailinglist($nMailingListId);
$strMaillist = $arrMaillist['strName'];
$strDesc = '<dl>';
$strDesc .= "<dt><strong>{$CIRCULATION_MNGT_WORK_IN_PROCESS}:</strong> " . $arrDecissionState["nDaysInProgress"] . "</dt>";
$strDesc .= "<dt><strong>{$CIRCULATION_MNGT_SENDING_DATE}:</strong> {$strStartDate}</dt>";
$strDesc .= "<dt><strong>{$CIRCDETAIL_SENDER}:</strong> {$strSender}</dt>";
$strDesc .= "<dt><strong>{$SHOW_CIRCULATION_MAILLIST}</strong> {$strMaillist}</dt>";
$strDesc .= '</dl>';
$feed_item->setDescription($strDesc);
$feed_item->setLink("{$CUTEFLOW_SERVER}/pages/editcirculation.php?circid={$nCirculationFormID}&language={$language}&bRestart=1");
$objRssFeed->addItem($feed_item);
}
$arrAllUsers = $objCirculation->getAllUsers();
$_REQUEST['language'] = $DEFAULT_LANGUAGE;
require_once '../lib/swift/swift_required.php';
require_once '../language_files/language.inc.php';
require_once '../config/db_connect.inc.php';
require_once 'CCirculation.inc.php';
$objCirculation = new CCirculation();
// get all active users
$query = "SELECT * FROM cf_user WHERE bDeleted=0";
$user_result = mysql_query($query, $nConnection);
while ($user = mysql_fetch_array($user_result)) {
// send reminder email to user
// first: getting all open circulations of this user
$circulations_aggregated = array();
$circulations = $objCirculation->getCirculationOverview(1, 'COL_CIRCULATION_PROCESS_DAYS', 'DESC', false, 100, true, '', false, false, $user['nID']);
foreach ($circulations as $circulation) {
$arrDecissionState = $objCirculation->getDecissionState($circulation['nID']);
$strStartDate = $objCirculation->getStartDate($circulation['nID']);
$strSender = $objCirculation->getSender($circulation['nID']);
$single_circulations_aggregated['circulation_name'] = $circulation['strName'];
$single_circulations_aggregated['circulation_start'] = $strStartDate;
$single_circulations_aggregated['circulation_sender'] = $strSender;
$single_circulations_aggregated['circulation_name'] = $circulation['strName'];
$single_circulations_aggregated['circulation_process_time'] = $arrDecissionState["nDaysInProgress"];
$single_circulations_aggregated['circulation_url'] = '';
$circulations_aggregated[] = $single_circulations_aggregated;
}
if (count($circulations_aggregated) > 0) {
// second: create email message body
$useGeneralEmailConfig = $user['bUseGeneralEmailConfig'];
if (!$useGeneralEmailConfig) {
$emailFormat = $user['strEmail_Format'];
