<?php /**
* File : addon_update_limit_date.php
* Type : Include
* 
* Activated function to update limit_date in Maarch Letter Box
* Compatible > MLB 2.6 
* 
* @package  Maarch LetterBox 2.6
* @version 1.0
* @since 10/2007
* @license GPL
* @author  Loïc Vinet  <dev@maarch.org>
*/

//Use to control value in actual form	
function post_control_update_limit_date($request_new_limit_date)
{
	if ($request_new_limit_date <> "null")
	{
		$func=new functions();
		$new_limit_date = str_replace(' ', '', $request_new_limit_date);
		if( ereg("[0-3][0-9]-[0-1][0-9]-[1-2][0-9][0-9][0-9]",$new_limit_date)==false )
		{
			$_SESSION['error'] .= _WRONG_DATE_FORMAT.' : '.$new_limit_date;
		}
		else
		{
			$new_limit_date = $func->inverse_date($new_limit_date);
			return $new_limit_date;
		}
	}
	else
	{
		return false;
	}
}


//Use to update main file of this folder
function module_update_limit_date($utd_folder_id, $utd_new_limit_date)
{
	if ($utd_new_limit_date <> false)
	{
		$conn = new dbquery();
		$conn->query("SELECT DATEDIFF('".$utd_new_limit_date."',CUSTOM_D2) as HOW_LONG from ".$_SESSION['ressources'][0]['tablename']." WHERE RES_ID = '".$utd_folder_id."'; ");
		$line_new_limit = $conn->fetch_object();
		$interval_new_limit = $line_new_limit->HOW_LONG;
							
		// Mise à jour des dates de relance
		$pos = strpos($line_new_limit->HOW_LONG, "-");
		if ($pos === false) {
			$negative = false;
		} else {
			$negative = true;
		}

		if ($negative == true)
		{
			$interval_new_limit = str_replace('-', '',$line_new_limit->HOW_LONG);
			$insert .= "CUSTOM_D4 = (CUSTOM_D4 - INTERVAL ".$interval_new_limit." DAY) , ";
			$insert .= "CUSTOM_D5 = (CUSTOM_D5 - INTERVAL ".$interval_new_limit." DAY) , ";
		}
		else
		{
			$interval_new_limit = $line_new_limit->HOW_LONG;
			$insert .= "CUSTOM_D4 = (CUSTOM_D4 + INTERVAL ".$interval_new_limit." DAY) ,  ";
			$insert .= "CUSTOM_D5 = (CUSTOM_D5 + INTERVAL ".$interval_new_limit." DAY) ,  ";
		} 
		if($_SESSION['history']['resadd'] == false)
		{
			require_once("class_history.php");
			$users = new history();
			$mes = _NEW_LIMIT_ACTIVATED." : ".$_SESSION['courrier']['new_limit_date'];
			$users->add($_SESSION['tablechoice'], $folder_id ,"ADD", $mes);
		}
		$conn->query("UPDATE ".$_SESSION['tablechoice']." SET ".$insert." CUSTOM_D2 = '".$utd_new_limit_date."' WHERE RES_ID = '".$utd_folder_id."'  ");
	}
}

?>