<?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"];
Ejemplo n.º 2
0
 * 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';
Ejemplo n.º 3
0
			);
		 }	
		
		
		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':
Ejemplo n.º 6
0
			</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>
Ejemplo n.º 7
0
            $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 
Ejemplo n.º 9
0
<?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);
            }
        }
Ejemplo n.º 10
0
<?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"];
?>
">
Ejemplo n.º 12
0
 * 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;
Ejemplo n.º 14
0
* 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>";
}
Ejemplo n.º 17
0
        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);
Ejemplo n.º 19
0
</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
Ejemplo n.º 21
0
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);
Ejemplo n.º 22
0
 * 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