<?php
include_once "../config/config.inc.php";
include_once "../language_files/language.inc.php";
include_once '../pages/CCirculation.inc.php';
include_once "../pages/version.inc.php";
$objMyCirculation = new CCirculation();
//--- open database
$nConnection = mysql_connect($DATABASE_HOST, $DATABASE_UID, $DATABASE_PWD);
if ($nConnection) {
if (mysql_select_db($DATABASE_DB, $nConnection)) {
//-----------------------------------------------
//--- get the senders userid
//-----------------------------------------------
$strQuery = "SELECT nSenderId FROM `cf_circulationform` WHERE nID={$nCirculationId}";
$nResult = mysql_query($strQuery, $nConnection);
if ($nResult) {
if (mysql_num_rows($nResult) > 0) {
$arrSenderID = mysql_fetch_array($nResult);
$nSenderID = $arrSenderID["nSenderId"];
}
}
//-----------------------------------------------
//--- get sender details
//-----------------------------------------------
$strQuery = "SELECT strLastName, strFirstName FROM `cf_user` WHERE nID={$nSenderID}";
$nResult = mysql_query($strQuery, $nConnection);
if ($nResult) {
while ($row = mysql_fetch_array($nResult)) {
$arrSenderDetails[] = $row["strLastName"];
$arrSenderDetails[] = $row["strFirstName"];
* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
* AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO,
* THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
* PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR
* CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
* EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
* PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS;
* OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY,
* WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR
* OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE,
* EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*/
require_once '../config/config.inc.php';
require_once '../language_files/language.inc.php';
require_once 'CCirculation.inc.php';
$objCirculation = new CCirculation();
$nShowRows = 50;
if ($_REQUEST['sortby'] == '') {
$_REQUEST['sortby'] = 'strLastName';
}
if ($_REQUEST['sortdir'] == '') {
$_REQUEST['sortdir'] = 'ASC';
}
function getSortDirection($strColumn)
{
global $_REQUEST;
if ($strColumn == $_REQUEST['sortby']) {
if ($_REQUEST['sortdir'] == 'ASC') {
return 'DESC';
} else {
return 'ASC';
);
}
function editCurCirculation(strAction)
{
if (document.getElementById('bFilterOn').checked)
{
alert('ok');
}
}
//-->
</script>
<?php
$objCirculation = new CCirculation();
$arrAllUsers = $objCirculation->getAllUsers();
$arrActiveUsers = $objCirculation->getAllUsers(false);
$arrAllMailingLists = $objCirculation->getAllMailingLists();
$arrAllInputFields = $objCirculation->getMyInputFields();
$arrAllTemplates = $objCirculation->getAllTemplates();
if ($_REQUEST["archivemode"] == 0 && !$_REQUEST['bOwnCirculations']) {
?>
<table width="90%" cellspacing="0" cellpadding="0">
<tr>
<?php
if ($_SESSION["SESSION_CUTEFLOW_ACCESSLEVEL"] == 2 || $_SESSION["SESSION_CUTEFLOW_ACCESSLEVEL"] == 8) {
// check if an extension exists
$extensions = $objCirculation->getExtensionsByHookId('CF_ADD_CIRCULATION');
if ($extensions) {
$extension = $extensions[0];
?>
<script src="../lib/RPL/Encryption/aamcrypt.js" type="text/javascript" language="JavaScript"></script>
<script src="../lib/RPL/Encryption/boxes.js?<?php
echo time();
?>
" type="text/javascript" language="JavaScript"></script>
<?php
$language = $_REQUEST['language'];
$nCirculationFormID = $_REQUEST['nCURCirculationFormID'];
$nCURCirculationProcessID = $_REQUEST['nCURCirculationProcessID'];
$nCURMailinglistID = $_REQUEST['nCURMailinglistID'];
$nMySlotID = $_REQUEST['nSlotID'];
$nMyUserID = $_REQUEST['nUserID'];
$nMyPosition = $_REQUEST['nPosition'];
$nUserID = $_REQUEST['nUserID'];
$objMyCirculation = new CCirculation();
$nCirculationHistoryID = $objMyCirculation->getCirculationHistoryID($nCURCirculationProcessID);
$arrCirculationProcess = $objMyCirculation->getCirculationProcess($nCirculationFormID, $nCirculationHistoryID);
$nMyIndex = $_REQUEST['nMyIndex'];
if ($arrCirculationProcess[$nMyIndex] != '') {
$arrMyCirculationProcess = $arrCirculationProcess[$nMyIndex];
$nMyCirculationProcessID = $arrMyCirculationProcess['nID'];
$tsMyDateInProcessSince = $arrMyCirculationProcess['dateInProcessSince'];
if ($nMyCirculationProcessID != $nCURCirculationProcessID) {
$arrLaterEntries = $objMyCirculation->getLaterEntries($nCirculationFormID, $nCirculationHistoryID, $tsMyDateInProcessSince);
$nMax = sizeof($arrLaterEntries);
for ($nIndex = 0; $nIndex < $nMax; $nIndex++) {
$arrCurLaterEntry = $arrLaterEntries[$nIndex];
$nDELCirculationProcessID = $arrCurLaterEntry['nID'];
$objMyCirculation->deleteMyCirculationProcess($nDELCirculationProcessID);
}
return $decodedStr;
}
include '../language_files/language.inc.php';
header("Content-Type: text/xml; charset={$DEFAULT_CHARSET}");
echo '<?xml version="1.0" encoding="' . $DEFAULT_CHARSET . '"?>';
include '../config/config.inc.php';
include '../config/db_connect.inc.php';
include_once 'CCirculation.inc.php';
$language = $_REQUEST['language'];
$archivemode = $_REQUEST['archivemode'];
$sortDirection = $_REQUEST['sortDirection'];
$sortby = $_REQUEST['sortby'];
$start = $_REQUEST['start'];
$nShowRows = $_REQUEST['nShowRows'];
$_SESSION['SESSION_CUTEFLOW_ACCESSLEVEL'] = $_REQUEST['nAccessLevel'];
$objCirculation = new CCirculation();
if ($_REQUEST['bFilterOn']) {
// extended filter has been activated
$_REQUEST['FILTER_Name'] = unescape($_REQUEST['FILTER_Name'], $DEFAULT_CHARSET);
$nIndexValues = 0;
while (list($key, $value) = each($_REQUEST)) {
$arrCurKey = split('_', $key);
if ($arrCurKey[0] == 'FILTERCustom') {
$arrPart2 = split('--', $arrCurKey[1]);
$strType = $arrPart2[0];
$nFILTERCustomID = $arrPart2[1];
switch ($strType) {
case 'Field':
$arrFILTERCustom[$nFILTERCustomID]['nInputFieldID'] = $value;
break;
case 'Operator':
</td>
<td align="left" valign="top">
<?php
echo $LOADING_DATA;
?>
</td>
</tr>
</table>
</div>
</td>
</tr>
</table>
<br>
<?php
$language = $_REQUEST['language'];
$objCirculation = new CCirculation();
$arrAllUsers = $objCirculation->getAllUsers();
$arrAllMailingLists = $objCirculation->getAllMailingLists();
$arrAllTemplates = $objCirculation->getAllTemplates();
?>
<table width="90%" cellspacing="0" cellpadding="0">
<tr>
<td align="left">
<form action="showstatistic.php" id="filter-form" method="post">
<table style="border: 1px solid #aaa; width: 400px;" cellspacing="0" cellpadding="0">
<tr>
<td style="padding: 1px; background: #ccc;" align="left" valign="middle">
<?php
echo $CIRCULATION_MNGT_FILTER;
?>
</td>
$pos++;
}
}
if ($iconv_to != "UTF-8") {
$decodedStr = iconv("UTF-8", $iconv_to, $decodedStr);
}
return $decodedStr;
}
require_once '../../config/config.inc.php';
require_once '../../config/db_connect.inc.php';
require_once '../../language_files/language.inc.php';
require_once '../../pages/CCirculation.inc.php';
header("Content-Type: text/xml; charset={$DEFAULT_CHARSET}");
$strFiter = strip_tags($_REQUEST['strFilter']);
$strFiter = ltrim(unescape($strFiter, $DEFAULT_CHARSET));
$objCirculation = new CCirculation();
$arrIndex = $objCirculation->filterUsers($strFiter);
?>
<table cellpadding="2" cellspacing="0" style="background-color:white;" width="100%">
<tbody id="AvailableUsers">
<?php
$nMax = sizeof($arrIndex);
for ($nIndex = 0; $nIndex < $nMax; $nIndex++) {
$arrCurIndex = $arrIndex[$nIndex];
$nUserId = $arrCurIndex['user_id'];
$arrUser = $objCirculation->getUserById($nUserId);
$sid = $nUserId;
?>
<tr onMouseOver="this.style.background = '#ddd;'" onMouseOut="this.style.background = '#fff;'" onClick="document.getElementById('receiver_<?php
echo $sid;
?>
<?php
include '../language_files/language.inc.php';
include '../config/config.inc.php';
include '../config/db_connect.inc.php';
include_once 'CCirculation.inc.php';
$nCurInputFieldID = $_REQUEST['nCurInputFieldID'];
$nCurRunningID = $_REQUEST['nCurRunningID'];
$objCCirculation = new CCirculation();
$nCurType = $objCCirculation->getFieldType($nCurInputFieldID);
if ($nCurType == '6' || $nCurType == '8') {
$strQuery = "SELECT * FROM cf_inputfield WHERE nID = '{$nCurInputFieldID}'";
$nResult = @mysql_query($strQuery);
$arrCurInputField = mysql_fetch_array($nResult, MYSQL_ASSOC);
$strCurStdValue = $arrCurInputField['strStandardValue'];
switch ($nCurType) {
case '6':
$arrSplit = split('---', $strCurStdValue);
$nSplitRunningNumber = 0;
$nMax = sizeof($arrSplit);
for ($nIndex = 2; $nIndex < $nMax; $nIndex += 2) {
$arrGroup[$nSplitRunningNumber] = $arrSplit[$nIndex + 1];
$arrRBGroup[$nSplitRunningNumber] = $arrSplit[$nIndex];
$nSplitRunningNumber++;
}
?>
<select name="FILTERCustom_Value--<?php
echo $nCurRunningID;
?>
" id="FILTERCustom_Value--<?php
<?php
require_once '../config/config.inc.php';
require_once '../language_files/language.inc.php';
require_once '../lib/datetime.inc.php';
require_once '../lib/viewutils.inc.php';
require_once '../pages/CCirculation.inc.php';
if (!$ALLOW_UNENCRYPTED_REQUEST) {
// clear $_REQUEST to ensure that only the encryptet "key" is used
foreach ($_GET as $key => $value) {
if ($key != 'key') {
$_REQUEST[$key] = '';
}
}
}
$objMyCirculation = new CCirculation();
//--- open database
$nConnection = mysql_connect($DATABASE_HOST, $DATABASE_UID, $DATABASE_PWD);
if ($nConnection) {
if (mysql_select_db($DATABASE_DB, $nConnection)) {
//-----------------------------------------------
//--- get the user information from
//--- cf_circulationprocess
//-----------------------------------------------
$strQuery = "SELECT * FROM cf_circulationprocess WHERE nID=" . $_REQUEST["cpid"];
$nResult = mysql_query($strQuery, $nConnection);
if ($nResult) {
if (mysql_num_rows($nResult) > 0) {
$arrCirculationProcess = mysql_fetch_array($nResult);
}
}
<?php
include '../language_files/language.inc.php';
header("Content-Type: text/xml; charset={$DEFAULT_CHARSET}");
$nMailinglistID = $_REQUEST["nMailinglistID"];
echo '<?xml version="1.0" encoding="' . $DEFAULT_CHARSET . '"?>';
include '../config/config.inc.php';
include '../config/db_connect.inc.php';
include_once 'CCirculation.inc.php';
$objMyCirculation = new CCirculation();
$arrMailinglist = $objMyCirculation->getMailinglist($nMailinglistID);
// corresponding mailinglist
$nFormTemplateID = $arrMailinglist['nTemplateId'];
// FormTemplate ID
$arrSlots = $objMyCirculation->getFormslots($nFormTemplateID);
// corresponding formslots
// ??
$strQuery = "SELECT MAX(nID) FROM cf_circulationform WHERE bDeleted = 0";
$nResult = @mysql_query($strQuery);
$arrRow = @mysql_fetch_array($nResult);
$nCirculationFormID = (int) ($arrRow[0] + 1);
// ??
if (sizeof($arrSlots) != 0) {
$strResult_Top = '
<table width="100%" style="border: 1px solid #c8c8c8; background: #efefef;" cellspacing="0" cellpadding="3">
<tr>
<td colspan="4" class="table_header" style="border-bottom: 3px solid #ffa000;">
' . $INSTALL_STEP . ' 3/3: ' . $EDIT_CIRCULATION_EDIT_VALUES_HEAD . '
</td>
</tr>
<tr>
<?php
include '../language_files/language.inc.php';
header("Content-Type: text/xml; charset={$DEFAULT_CHARSET}");
echo '<?xml version="1.0" encoding="' . $DEFAULT_CHARSET . '"?>';
include '../config/config.inc.php';
include '../config/db_connect.inc.php';
include_once 'CCirculation.inc.php';
$nCurFilterID = $_REQUEST['nFilterID'];
$objCirculation = new CCirculation();
$arrFilter = $objCirculation->getFilter($nCurFilterID);
$objCirculation = new CCirculation();
$arrAllUsers = $objCirculation->getAllUsers();
$arrAllMailingLists = $objCirculation->getAllMailingLists();
$arrAllInputFields = $objCirculation->getMyInputFields();
$arrAllTemplates = $objCirculation->getAllTemplates();
?>
<table cellspacing="2" cellpadding="2" width="100%">
<tr height="26">
<td width="200" valign="top">
<?php
echo $CIRCULATION_MNGT_NAME;
?>
</td>
<td valign="top" colspan="2">
<table width="100%" cellspacing="0" cellpadding="0">
<tr><td align="left">
<input type="text" style="border: 1px solid #999; width: 150px; padding: 1px; font-family: arial; font-size: 12px;" name="FILTER_Name" id="FILTER_Name" value="<?php
echo $arrFilter["strName"];
?>
">
* THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
* PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR
* CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
* EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
* PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS;
* OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY,
* WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR
* OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE,
* EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*/
session_start();
require_once '../config/config.inc.php';
require_once '../language_files/language.inc.php';
require_once 'CCirculation.inc.php';
require_once '../pages/version.inc.php';
$Circulation = new CCirculation();
$extensions = $Circulation->getExtensionsByHookId('CF_MENU');
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=<?php
echo $DEFAULT_CHARSET;
?>
">
<title></title>
<link rel="stylesheet" href="format.css" type="text/css">
<style>
#menu
{
margin-top: 10px;
* PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR
* CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
* EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
* PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS;
* OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY,
* WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR
* OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE,
* EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*/
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;
* EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
* PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS;
* OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY,
* WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR
* OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE,
* EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*/
session_start();
require_once '../config/config.inc.php';
// checking user credentials
if ($_SESSION['SESSION_CUTEFLOW_USERID'] == '' || $_SESSION['SESSION_CUTEFLOW_ACCESSLEVEL'] != 2) {
header('location: missing_credentials.php?language=' . $_REQUEST['language']);
}
require_once '../language_files/language.inc.php';
require_once 'CCirculation.inc.php';
$objCirculation = new CCirculation();
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=<?php
echo $DEFAULT_CHARSET;
?>
">
<title></title>
<link rel="stylesheet" href="format.css" type="text/css">
<script language="JavaScript">
<!--
var arrSubstitutes;
function changeSubstitute(strAction)
$SuccessMail |= $type;
}
}
$SuccessArchive = $_REQUEST['SuccessArchive'];
$SuccessDelete = $_REQUEST['SuccessDelete'];
$bAnonymize = $_REQUEST['Anonymize'] == 1 ? 1 : 0;
$nSenderID = $_SESSION['SESSION_CUTEFLOW_USERID'];
$objCirculation = new CCirculation();
$nMax = sizeof($arrPlaceholdersAddText);
for ($nIndex = 0; $nIndex < $nMax; $nIndex++) {
$strPlaceholderAT = $arrPlaceholdersAddText[$nIndex];
$arrSplit = split('%', $strPlaceholderAT);
$strReplace = getPlaceholderContent($arrSplit[1]);
$strAdditionalText = str_replace($strPlaceholderAT, $strReplace, $strAdditionalText);
}
$objMyCirculation = new CCirculation();
$arrMailinglist = $objMyCirculation->getMailinglist($nMailinglistID);
// corresponding mailinglist
$nFormTemplateID = $arrMailinglist['nTemplateId'];
if ($_REQUEST['bRestart']) {
$nCirculationFormID = $_REQUEST['cfid'];
//-----------------------------------------
//--- Write next history
//-----------------------------------------
$strQuery = "SELECT MAX(nRevisionNumber) FROM cf_circulationhistory WHERE nCirculationFormId=" . $nCirculationFormID;
$nResult = mysql_query($strQuery, $nConnection);
if ($nResult) {
if (mysql_num_rows($nResult) > 0) {
$arrRow = mysql_fetch_array($nResult);
$nRevisionNumber = $arrRow[0] + 1;
}
<body topmargin="0" leftmargin="0" style="margin-top: 5px;">
<table height="100%"><tr><td valign="middle">
<div align="center">
<form action="" id="BrowseMailingList">
<table style="background: #efefef; border: 1px solid #c8c8c8;" cellspacing="0" cellpadding="3" align="center">
<tr>
<td colspan="2" class="table_header" style="border-bottom: 3px solid #ffa000;">
<?php
echo $FILTER_LOAD_FILTER;
?>
</td>
</tr>
<tr>
<td style="padding: 8px 4px 8px 4px;">
<?php
$objMyCirculation = new CCirculation();
$arrFilters = $objMyCirculation->getMyFilters($nCurUserID);
// corresponding mailinglist
?>
<select id="IN_nFilterID" class="FormInput" size="10" style="width:250px;">
<?php
$nMax = sizeof($arrFilters);
for ($nIndex = 0; $nIndex < $nMax; $nIndex++) {
$arrCurFilter = $arrFilters[$nIndex];
$nCurFilterID = $arrCurFilter['nID'];
$strCurLabel = $arrCurFilter['strLabel'];
if ($nIndex == 0) {
echo "<option value=\"0\" selected>- - - {$FILTER_CHOOSE_FILTER} - - -</option>";
}
echo "<option value=\"{$nCurFilterID}\">{$strCurLabel}</option>";
}
if (($nEndAction & 8) == 8) {
sendMessageToSender($nSenderId, $arrProcessInfo["nUserId"], "done", $strCircName, "ENDSLOT", $_REQUEST["cpid"], $slotname);
}
}
} else {
//--- send done email to sender if wanted
$strQuery = "SELECT * FROM cf_circulationform WHERE nID=" . $arrCirculationProcesses["nCirculationFormId"];
$nResult = mysql_query($strQuery, $nConnection);
if ($nResult) {
if (mysql_num_rows($nResult) > 0) {
$arrRow = mysql_fetch_array($nResult);
$nEndAction = $arrRow["nEndAction"];
$nSenderId = $arrRow["nSenderId"];
$strCircName = $arrRow["strName"];
// check the hook CF_ENDACTION
$circulation = new CCirculation();
$endActions = $circulation->getExtensionsByHookId('CF_ENDACTION');
if ($endActions) {
foreach ($endActions as $endAction) {
$params = $circulation->getEndActionParams($endAction);
$hookValue = (int) $params['hookValue'];
if (($nEndAction & $hookValue) == $hookValue) {
require_once $params['filename'];
}
}
}
$nShouldArchived = $nEndAction & 2;
$nShouldMailed = $nEndAction & 1;
$nShouldDeleted = 4;
if ($nShouldMailed == 1) {
sendMessageToSender($nSenderId, $arrProcessInfo["nUserId"], "done", $strCircName, "SUCCESS", $_REQUEST["cpid"]);
<?php
require_once '../language_files/language.inc.php';
require_once '../config/config.inc.php';
require_once '../config/db_connect.inc.php';
require_once '../lib/datetime.inc.php';
require_once 'send_circulation.php';
require_once 'CCirculation.inc.php';
$language = $_REQUEST['language'];
$nCirculationFormID = $_REQUEST['nCURCirculationFormID'];
$nCURCirculationProcessID = $_REQUEST['nCURCirculationProcessID'];
$nCURMailinglistID = $_REQUEST['nCURMailinglistID'];
$nUserID = $_REQUEST['nUserID'];
// Id of selected User
$objMyCirculation = new CCirculation();
$nCirculationHistoryID = $objMyCirculation->getCirculationHistoryID($nCURCirculationProcessID);
//-----------------------------------------------
//--- set user state to "skipped"
//-----------------------------------------------
$strQuery = "UPDATE cf_circulationprocess set nDecissionState = 8, dateDecission = '{$TStoday}' WHERE nID = '{$nCURCirculationProcessID}'";
mysql_query($strQuery, $nConnection);
// - get the UserId of the current Station
$arrCURCirculationProcess = $objMyCirculation->getMyCirculationProcess($nCURCirculationProcessID);
$nCURStation_UserID = $arrCURCirculationProcess['nUserId'];
$nSlotID = $arrCURCirculationProcess['nSlotId'];
// send
sendToUser($nUserID, $nCirculationFormID, $nSlotID, $nCURCirculationProcessID, $nCirculationHistoryID);
//?
//$strQuery = "INSERT INTO cf_circulationprocess VALUES(null, '$nCirculationFormID', '$nSlotID', '$nUserID', time(), 0, '$nCURStation_UserID', '$nCirculationHistoryID')";
//echo "Query: ".$strQuery."<br>";
//mysql_query($strQuery, $nConnection);
</head>
<body topmargin="0" leftmargin="0" style="margin-top: 5px;">
<div align="center">
<form action="" id="BrowseMailingList">
<table style="background: #efefef; border: 1px solid #c8c8c8;" cellspacing="0" cellpadding="3" align="center">
<tr>
<td colspan="2" class="table_header" style="border-bottom: 3px solid #ffa000;">
<?php
echo $CHOOSE_STATION;
?>
</td>
</tr>
<tr>
<td style="padding: 8px 4px 8px 4px;">
<?php
$objMyCirculation = new CCirculation();
$arrMailinglist = $objMyCirculation->getMailinglist($nMailinglistID);
// corresponding mailinglist
$nFormTemplateID = $arrMailinglist['nTemplateId'];
// FormTemplate ID
$arrUsers = $objMyCirculation->getUsers();
$arrSlots = $objMyCirculation->getFormslots($nFormTemplateID);
// corresponding formslots
?>
<select id="MailingList" class="FormInput" size="10" style="width:250px;">
<?php
$nMyIndex = 0;
$nMy2Index = 0;
foreach ($arrSlots as $arrSlot) {
if ($nMyIndex == 0) {
echo "<option value=\"0\" selected>- - - " . $arrSlot["strName"] . " - - -</option>";
* PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR
* CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
* EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
* PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS;
* OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY,
* WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR
* OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE,
* EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*/
require_once '../config/config.inc.php';
$_REQUEST['language'] = $DEFAULT_LANGUAGE;
require_once '../language_files/language.inc.php';
require_once '../config/db_connect.inc.php';
require_once 'CCirculation.inc.php';
require_once 'send_circulation.php';
$objCirculation = new CCirculation();
$nMinMinutes = $SUBSTITUTE_PERSON_MINUTES;
// get the max time period
$strQuery = "SELECT MIN(nSubstituteTimeValue) as nMinSubstituteTimeValue FROM cf_user WHERE bUseGeneralSubstituteConfig = 0 AND strSubstituteTimeUnit = 'DAYS' and bDeleted = 0 LIMIT 1;";
$result = mysql_query($strQuery, $nConnection);
$arrResult = mysql_fetch_array($result, MYSQL_ASSOC);
if ($arrResult['nMinSubstituteTimeValue'] != '') {
// found an entry
$nMaxDays = $arrResult['nMinSubstituteTimeValue'];
$nMaxHours = $nMaxDays * 24;
$nMinMinutes = $nMaxHours * 60;
$strQuery = "SELECT MIN(nSubstituteTimeValue) as nMinSubstituteTimeValue FROM cf_user WHERE bUseGeneralSubstituteConfig = 0 AND strSubstituteTimeUnit = 'HOURS' AND nSubstituteTimeValue < {$nMaxHours} and bDeleted = 0 LIMIT 1;";
$result = mysql_query($strQuery, $nConnection);
$arrResult = mysql_fetch_array($result, MYSQL_ASSOC);
if ($arrResult['nMinSubstituteTimeValue'] != '') {
// found an entry
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);
* PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR
* CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
* EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
* PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS;
* OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY,
* WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR
* OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE,
* EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*/
require_once '../config/config.inc.php';
require_once '../language_files/language.inc.php';
require_once '../config/db_connect.inc.php';
require_once 'CCirculation.inc.php';
$_REQUEST['listid'] = strip_tags($_REQUEST['nMailinglistID']);
$listid = $_REQUEST['listid'];
$objCirculation = new CCirculation();
$arrMailinglist = $objCirculation->getMailinglist($listid);
// corresponding mailinglist
$_REQUEST['templateid'] = $arrMailinglist['nTemplateId'];
// get all users
$arrUsers = array();
$strQuery = "SELECT * FROM cf_user WHERE bDeleted <> 1 ORDER BY strLastName ASC";
$nResult = mysql_query($strQuery, $nConnection);
if ($nResult) {
if (mysql_num_rows($nResult) > 0) {
while ($arrRow = mysql_fetch_array($nResult)) {
$arrUsers[$arrRow["nID"]] = $arrRow;
}
}
}
// get all slots for the given template