$strOperator = 'LIKE'; } $arrFILTERCustom[$nFILTERCustomID]['strOperator'] = $strOperator; break; case 'Value': $arrFILTERCustom[$nFILTERCustomID]['strValue'] = unescape($value, $DEFAULT_CHARSET); break; } $nIndexValues++; } } $FILTER_CUSTOM = false; if (sizeof($arrFILTERCustom) > 0 && $arrFILTERCustom[0]['strValue'] != '') { $FILTER_CUSTOM = $arrFILTERCustom; } $arrCirculationOverview = $objCirculation->getCirculationOverview($start, $sortby, $sortDirection, $archivemode, $nShowRows, 1, $_REQUEST['FILTER_Name'], $_REQUEST['FILTER_Sender'], $_REQUEST['FILTER_Mailinglist'], $_REQUEST['FILTER_Station'], $_REQUEST['FILTER_DaysInProgress_Start'], $_REQUEST['FILTER_DaysInProgress_End'], $_REQUEST['FILTER_Date_Start'], $_REQUEST['FILTER_Date_End'], $_REQUEST['FILTER_Template'], $FILTER_CUSTOM); if ($_REQUEST['FILTER_Name'] != '' || $_REQUEST['FILTER_Sender'] != '' || $_REQUEST['FILTER_Mailinglist'] != '' || $_REQUEST['FILTER_Station'] != '' || $_REQUEST['FILTER_DaysInProgress_Start'] != '' || $_REQUEST['FILTER_DaysInProgress_End'] != '' || $_REQUEST['FILTER_Date_Start'] != '' || $_REQUEST['FILTER_Date_End'] != '' || $_REQUEST['FILTER_Template'] != '0' || $FILTER_CUSTOM != false) { // TODO if ($FILTER_CUSTOM != false && sizeof($FILTER_CUSTOM) > 0) { $arrResults = array(); $nMyCounter = 0; $nMax = sizeof($FILTER_CUSTOM); for ($nIndex = 0; $nIndex < $nMax; $nIndex++) { $arrFilter = $FILTER_CUSTOM[$nIndex]; $nInputfieldId = $arrFilter['nInputFieldID']; $strOperator = $arrFilter['strOperator']; $strValue = $arrFilter['strValue']; if ($strValue != '') { $arrResults = array(); $nMyCounter = 0; $nMaxOverview = sizeof($arrCirculationOverview);
include '../classes/RssFeedItem.php'; include '../classes/RssFeed.php'; include '../config/config.inc.php'; include '../config/db_connect.inc.php'; include_once 'CCirculation.inc.php'; include '../language_files/language.inc.php'; $language = $_REQUEST['language']; $archivemode = $_REQUEST['archivemode']; $sortDirection = $_REQUEST['sortDirection']; $sortby = $_REQUEST['sortby']; $start = $_REQUEST['start']; $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'];
*/ require_once '../config/config.inc.php'; $_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'];