$strQuery = "SELECT MAX(nID) FROM cf_circulationhistory"; $nResult = mysql_query($strQuery, $nConnection); if ($nResult) { if (mysql_num_rows($nResult) > 0) { $arrRow = mysql_fetch_array($nResult); $nCirculationHistoryID = $arrRow[0]; } } // - - - - - - - - - - - - START RESTART OPTIONS - - - - - - - - - - - - if ($_REQUEST['MailingList'][0] != 0) { // User has decided to start the circulation from a chosen Station - and not from beginning $arrSplit = split('---', $_REQUEST['MailingList']); $nChoosenSlotId = $arrSplit[1]; $nChoosenUserId = $arrSplit[2]; $nChoosenPosition = $arrSplit[3]; $arrSender = $objCirculation->getSenderDetails($nCirculationFormID); $arrMailinglist = $objCirculation->getMailinglist($nMailinglistID); $nFormTemplateID = $arrMailinglist['nTemplateId']; $arrUsers = $objCirculation->getUsers(); $arrSlots = $objCirculation->getFormslots($nFormTemplateID); $tsNow = time(); $tsDelayed = mktime(date("H") - 2, date("i"), date("s"), date("m"), date("d"), date("Y")); $nMax = sizeof($arrSlots); for ($nIndex = 0; $nIndex < $nMax; $nIndex++) { $arrSlot = $arrSlots[$nIndex]; $nSlotID = $arrSlot['nID']; $strSlot = $arrSlot['strName']; $strQuery = "SELECT * FROM cf_slottouser WHERE nMailingListId = '{$nMailinglistID}' AND nSlotId = '{$nSlotID}' ORDER BY nPosition ASC"; $nResult = mysql_query($strQuery, $nConnection); if ($nResult) { if (mysql_num_rows($nResult) > 0) {
$SP_MINUTES = $SP_VALUE * 24 * 60; break; case 'HOURS': $SP_MINUTES = $SP_VALUE * 60; break; case 'MINUTES': $SP_MINUTES = $SP_VALUE; break; } $tsCurrentSendSP = mktime(date("H"), date("i") - $SP_MINUTES, date("s"), date("m"), date("d"), date("Y")); } if ($dateInProcessSince < $tsCurrentSendSP) { $nSubstituteId = $arrSubstitutes[0]['substitute_id']; if ($nSubstituteId == -3) { // in this case the substitute is the sender of the circulation - let's find his user_id $arrSenderDetails = $objCirculation->getSenderDetails($nCirculationFormId); $nSubstituteId = $arrSenderDetails['nID']; } //--- change decission state $strQuery = "UPDATE cf_circulationprocess SET nDecissionState = '8', dateDecission = '{$TStoday}' WHERE nID = '{$nCirculationProcessId}'"; mysql_query($strQuery, $nConnection); //--- send substitute mail sendToUser($nSubstituteId, $nCirculationFormId, $nSlotId, $nCirculationProcessId, $nCirculationHistoryId); } } } else { // user is a substitute // let's see who this substitute belongs to // it's NOT saved in "nIsSubstituteOf" -.- $strQuery = "SELECT MAX(dateInProcessSince) as nMaxDateInProcessSince FROM cf_circulationprocess WHERE nCirculationFormId = '{$nCirculationFormId}' AND nIsSubstitiuteOf = '0' AND dateInProcessSince < '{$TSsendSP}' LIMIT 1;"; $result = mysql_query($strQuery, $nConnection);