//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(); $objRssFeed->setTitle($FEED_HEADLINE . " " . $arrAllUsers[$_REQUEST['uid']]);
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']; } else {