<?php 
// //////////////////////////////////////////////////
// Linea 21 - PHP news class
// Class pour gerer les actualites
// create : 01/09/03
// last_modify	: 25/03/04
// creative commons 2007 
//http://creativecommons.org/licenses/by-nc-sa/2.0/fr/legalcode
// //////////////////////////////////////////////////
/**
* news
* 
* @package linea21
* @author simon 
* @copyright Copyright (c) green-box 2003
* @version 1.0
* @access public 
*/

class newsletter {
    /* @param
	* */
    var $TDB_NEWSLETTER= T_NEWSLETTER; // nom de la table.
	var $TDB_COLLECTOR = T_EMAIL_COL; // nom de la table.
    var $URI_TEMPLATE = "newsletter/input/template"; // chemin du template de mail
	var $URI_ELEMENTS = "newsletter/elements/"; // repertoire stockage élements newsletter
    var $DATE_FORMAT = "%d-%m-%Y";
    var $ID;
    var $TITLE;
    var $BODY;
    var $POSTED_BY;
    var $DATE_CREA;
	var $LAST_MODIFY;
    var $PUBLISHED_DATE;
    var $STATUT;
	
	var $E_ID;
    var $E_EMAIL;
    var $E_STATUT;
    var $E_DATE_CREA;
    var $E_LAST_MODIFY;

    /**
    * news::CheckDataIntegrity()
    * Vérification intégrité des données
    * 
    * @access public 
    * @param array $table : contient les composants Nécessaires d'une newsletter
    * @return boolean true
    * si verifié, sinon string 'message d'erreur'
    */

    function CheckDataIntegrity($table)
    {
        if (strlen($table[0]) < 3) return $GLOBALS['lang']['newsletter']['no_title'];
        if (strlen($table[1]) < 3) return $GLOBALS['lang']['newsletter']['no_body'];

        return true;
    }
	
	/**
    * newsletter::_checkEmailValidity()
    * Vérification de la validité d'un email
    * 
    * @access private 
    * @param string $email
    * @return bool true ou string ( erreur )
    */
	function _checkEmailValidity($email)
    {
        $email = strtolower($email);
        $emailinvalide = $GLOBALS['lang']['newsletter']['invalid_mail'] . " :'" . $email . "'";
        if (strlen($email) < 6 || !ereg("@", $email) || preg_match_all("/([^a-zA-Z0-9_\@\.\-])/i", $email, $trouve) || !preg_match("/^([a-z0-9_]|\\-|\\.)+@(([a-z0-9_]|\\-)+\\.)+[a-z]{2,4}\$/i", $email)) {
            return $emailinvalide;
        }
		return true;
    } 

    /**
    * newsletter::AddNewsletter()
    * Ajout d'une newsletter
    * 
    * @access public 
    * @param array $table_newsletter : contient les composants d'une newsletter
    * @param object $sql_object 
    * @return integer $last_id
    */
    function AddNewsletter($table_newsletter, $sql_object)
    {
        if ($table_newsletter[0] != '') {
            $this->TITLE = strip_tags(trim($table_newsletter[0]));
        } 
        if ($table_newsletter[1] != '') {
            $this->BODY = strip_tags(trim($table_newsletter[1]), ALLOWABLE_TAGS);
        }
		if (is_numeric($table_newsletter[2])) {
            $this->POSTED_BY = $table_newsletter[2];
        }
        $this->STATUT = $table_newsletter[3];
         
        $requete = "INSERT INTO " . $this->TDB_NEWSLETTER . "(newsletter_title, newsletter_body, newsletter_posted_by, newsletter_date_crea , newsletter_last_modify, newsletter_statut) VALUES('" . $this->TITLE . "', '" . $this->BODY . "', '" . $this->POSTED_BY . "', NOW() , NOW(), '" . $this->STATUT . "');"; 
        // echo $requete;
        $last_id = $sql_object->DBInsert ($requete, 1);
        return $last_id;
    } 

    /**
    * newsletter::DeleteNewsletter()
    * suppression d'une newsletter
    * 
    * @access public 
    * @param int $ID : identifiant de la newsletter
    * @param object $sql_object 
    * @return bool $result
    */

    function DeleteNewsletter($ID, $sql_object)
    {
        $this->ID = $ID;
        $requete = "UPDATE  " . $this->TDB_NEWSLETTER . " set newsletter_statut='E' WHERE newsletter_id='" . $this->ID . "' LIMIT 1;";
        $result = $sql_object->DBQuery($requete);
        return $result;
    }
	
    /**
    * newsletter::SetNewsletterPublished()
    * rend une newsletter publié
    * 
    * @access public 
    * @param int $ID : identifiant de la newsletter
    * @param object $sql_object 
    * @return bool $result
    */

    function SetNewsletterPublished($ID, $sql_object)
    {
        $this->ID = $ID;
        $requete = "UPDATE " . $this->TDB_NEWSLETTER . " set newsletter_statut='P', newsletter_published_date=NOW() WHERE newsletter_id='" . $this->ID . "' LIMIT 1;";
        $result = $sql_object->DBQuery($requete);
        return $result;
    }

    /**
    * newsletter::ModifyNewsletter()
    * modification d'une newsletter
    * 
    * @access public 
    * @param integer $ID : identifiant de la news
    * @param object $sql_object 
    * @param array $table_newsletter : contient les composants d'une newsletter
    * @return boolean $result
    */
    function ModifyNewsletter($ID, $table_newsletter, $sql_object)
    {
        if (is_numeric($ID)) {
            $this->ID = $ID;
        } 
        if ($table_newsletter[0] != '') {
            $this->TITLE = strip_tags(trim($table_newsletter[0]));
        } 
        if ($table_newsletter[1] != '') {
            $this->BODY = strip_tags(trim($table_newsletter[1]), ALLOWABLE_TAGS);
        } 
        $this->STATUT = $table_newsletter[2];

        $requete = "UPDATE  " . $this->TDB_NEWSLETTER . " set newsletter_title='" . $this->TITLE . "', newsletter_body='" . $this->BODY . "' , newsletter_statut='" . $this->STATUT . "' WHERE newsletter_id='" . $this->ID . "';";
        $result = $sql_object->DBQuery($requete);
        return $result;
    }
	
	
	  /**
     * newsletter::AddEmail()
     * Ajout d'un email dans le collecteur
	 * @access public
     * @param  string $email email a ajouter
     * @param object $sql_object
     * @return string $result
     **/
    function AddEmail($email, $sql_object)
    {
        $result = $this -> _checkEmailValidity($email);
        if (is_string($result)) return  array('code' => 'error', 'string' => $result);
        $this -> E_EMAIL = strtolower($email);
        $requete = "SELECT emailcol_id, emailcol_validity FROM " . $this -> TDB_COLLECTOR . " WHERE emailcol_email='" . $this -> E_EMAIL . "';";
        $data = $sql_object -> DBSelect($requete);
        if ($data!=0 && count($data) == 1) {
            $this -> E_ID = $data[0]['emailcol_id'];
            if ($data[0]['emailcol_validity']== "Y") {
				return array('code' => 'info', 'string' => $GLOBALS['lang']['newsletter']['subscribe_yet']);
            } else {
                $requete = "UPDATE " . $this -> TDB_COLLECTOR . " SET emailcol_validity='Y' WHERE emailcol_id=" . $this -> E_ID . ";";
                if ($sql_object -> DBQuery($requete)) return array('code' => 'confirm', 'string' => $GLOBALS['lang']['newsletter']['confirm_subscribe']);
            } 
        } else {
            $requete = "INSERT INTO " . $this -> TDB_COLLECTOR . "(emailcol_email,  emailcol_validity, emailcol_date_crea) " . "VALUES('" . $this -> E_EMAIL . "', 'Y', CURRENT_TIMESTAMP());";
            $last_id = $sql_object -> DBInsert ($requete, 1);
            if (is_numeric($last_id)) return array('code' => 'confirm', 'string' => $GLOBALS['lang']['newsletter']['confirm_subscribe']);
        }
	} 
	
	
	  /**
     * newsletter::DeleteEmail()
     * Suppression d'un email du collecteur
	 * @access public
     * @param  string $email email a supprimer
     * @param object $sql_object
     * @return string $result
     **/
    function DeleteEmail($email, $sql_object)
    {
        $result = $this -> _checkEmailValidity($email);
        if (is_string($result)) return  array('code' => 'error', 'string' => $result);
        $this -> E_EMAIL = strtolower($email);
        $requete = "SELECT emailcol_id FROM " . $this -> TDB_COLLECTOR . " WHERE emailcol_email='" . $this -> E_EMAIL . "' AND emailcol_validity='Y';";
        $data= $sql_object -> DBSelect($requete);
        if ($data!=0 && count($data) == 1) {
            $this -> E_ID = $data[0]['emailcol_id'];
            $requete = "UPDATE " . $this -> TDB_COLLECTOR . " SET emailcol_validity='N' WHERE emailcol_id=" . $this -> E_ID . ";";
            if ($sql_object -> DBQuery($requete)) return array('code' => 'confirm', 'string' => $GLOBALS['lang']['newsletter']['confirm_del']);
        } else {
            return array( 'code' => 'info', 'string' => $GLOBALS['lang']['newsletter']['no_suscribe']);
        } 
    } 

} 

?>