Skip to content
Snippets Groups Projects
Select Git revision
  • 91d3b525e85349c73acdbfa3312d07e5ebbf6c4c
  • 3.9 default
  • develop
  • 6.0
  • 5.0
  • 4.0
  • scrutinizer-patch-4
  • scrutinizer-patch-3
  • scrutinizer-patch-2
  • scrutinizer-patch-1
  • 3.7
  • 3.8
  • 3.6
  • 3.9_backported
  • 3.8_backported
  • 3.7_backported
  • 3.5
  • 3.6_backported
  • 3.5_backported
  • 3.4
  • 3.3_backported
  • 6.0.4
  • 6.0.3
  • 5.0.7
  • 6.0.2
  • 6.0.1
  • 5.0.6
  • 6.0.0
  • 5.0.5
  • 6.0.0-rc
  • 5.0.4
  • 6.0.0-beta
  • 5.0.3
  • 4.0.6
  • 5.0.2
  • 5.0.1
  • 4.0.5
  • 5.0.0
  • 4.0.4
  • 5.0.0-rc2
  • 5.0.0-rc1
41 results

actioncomm.class.php

Blame
  • actioncomm.class.php 13.04 KiB
    <?php
    /* Copyright (C) 2002-2004 Rodolphe Quiedeville <rodolphe@quiedeville.org>
     * Copyright (C) 2004-2006 Laurent Destailleur  <eldy@users.sourceforge.net>
     *
     * $Id$
     * $Source$
     *
     * This program is free software; you can redistribute it and/or modify
     * it under the terms of the GNU General Public License as published by
     * the Free Software Foundation; either version 2 of the License, or
     * (at your option) any later version.
     *
     * This program is distributed in the hope that it will be useful,
     * but WITHOUT ANY WARRANTY; without even the implied warranty of
     * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
     * GNU General Public License for more details.
     *
     * You should have received a copy of the GNU General Public License
     * along with this program; if not, write to the Free Software
     * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
     */
    
    /**
            \file       htdocs/actioncomm.class.php
            \ingroup    commercial
            \brief      Fichier de la classe des actions commerciales
            \version    $Revision$
    */
    
    
    /**     \class      ActionComm
    	    \brief      Classe permettant la gestion des actions commerciales
    */
    
    class ActionComm
    {
        var $id;
        var $db;
        
        var $type_id;
        var $type_code;
        var $type;
        var $label;
        var $datec;			// Date creation enregistrement
        var $datep;			// Date action 0%
        var $date;			// Date action 100% (datea)
        var $datem;			// Date modif (tms)
        var $priority;
        var $user;
        var $author;
        var $societe;
        var $contact;
        var $note;
        var $percent;
        var $error;
        
        /**
         *      \brief      Constructeur
         *      \param      db      Handler d'accès base de donnée
         */
        function ActionComm($db)
        {
            $this->db = $db;
            $this->societe = new Societe($db);
            $this->author = new User($db);
            if (class_exists("Contact"))
            {
                $this->contact = new Contact($db);
            }
        }
    
        /**
         *    \brief      Ajout d'une action en base
         *    \param      author      auteur de la creation de l'action
         *    \return     int         id de l'action créée, < 0 si erreur
         */
        function add($author)
        {
            global $langs,$conf;
        
            dolibarr_syslog("ActionComm::add");
    
            if (! $this->percent)  $this->percent = 0;
            if (! $this->priority) $this->priority = 0;
    
            $sql = "INSERT INTO ".MAIN_DB_PREFIX."actioncomm";
            $sql.= "(datec,";
            if ($this->percent < 100) $sql.= "datep,";
            if ($this->percent == 100) $sql.= "datea,";
            $sql.= "fk_action,fk_soc,note,fk_contact,fk_user_author,fk_user_action,label,percent,priority,";
            $sql.= "fk_facture,propalrowid,fk_commande)";
            $sql.= " VALUES (now(),";
            if ($this->percent < 100) $sql.= "'".$this->db->idate($this->date)."',";
            if ($this->percent == 100) $sql.= "'".$this->db->idate($this->date)."',";
            $sql.= "'".$this->type_id."', '".$this->societe->id."' ,'".addslashes($this->note)."',";
            $sql.= ($this->contact->id?$this->contact->id:"null").",";
            $sql.= "'$author->id', '".$this->user->id ."', '".addslashes($this->label)."','".$this->percent."','".$this->priority."',";
            $sql.= ($this->facid?$this->facid:"null").",";
            $sql.= ($this->propalrowid?$this->propalrowid:"null").",";
            $sql.= ($this->orderrowid?$this->orderrowid:"null");
            $sql.= ");";
        
            if ($this->db->query($sql) )
            {
                $this->id = $this->db->last_insert_id(MAIN_DB_PREFIX."actioncomm");
        
               // Appel des triggers
                include_once(DOL_DOCUMENT_ROOT . "/interfaces.class.php");
                $interface=new Interfaces($this->db);
                $interface->run_triggers('ACTION_CREATE',$this,$author,$langs,$conf);
                // Fin appel triggers
        
                return $this->id;
            }
            else
            {
                dolibarr_print_error($this->db);
                return -1;
            }
        
        }
    
      /**
       *    \brief      Charge l'objet action depuis la base
       *    \param      id      id de l'action a récupérer
       */
      function fetch($id)
      {
        global $langs;
        
        $sql = "SELECT ".$this->db->pdate("a.datea")." as datea,";
    	$sql.= " ".$this->db->pdate("a.datep")." as datep,";
    	$sql.= " ".$this->db->pdate("a.datec")." as datec, tms as datem,";
        $sql.= " a.note, a.label, a.fk_action as type_id,";
        $sql.= " c.code, c.libelle, fk_soc, fk_user_author, fk_contact, fk_facture, a.percent, a.fk_commande";
        $sql.= " FROM ".MAIN_DB_PREFIX."actioncomm as a, ".MAIN_DB_PREFIX."c_actioncomm as c";
        $sql.= " WHERE a.id=".$id." AND a.fk_action=c.id";
        
        $resql=$this->db->query($sql);
        if ($resql)
        {
            if ($this->db->num_rows($resql))
            {
                $obj = $this->db->fetch_object($resql);
        
                $this->id = $id;
                $this->type_id = $type_id;
                $this->type_code = $obj->code;
                $transcode=$langs->trans("Action".$obj->code);
                $type_libelle=($transcode!="Action".$obj->code?$transcode:$obj->libelle);
                $this->type = $type_libelle;
                $this->label = $obj->label;
                $this->date = $obj->datea;
                $this->datep = $obj->datep;
                $this->datec = $obj->datec;
                $this->datem = $obj->datem;
                $this->note =$obj->note;
                $this->percent =$obj->percent;
                $this->societe->id = $obj->fk_soc;
                $this->author->id = $obj->fk_user_author;
                $this->contact->id = $obj->fk_contact;
                $this->fk_facture = $obj->fk_facture;
                if ($this->fk_facture)
                {
                    $this->objet_url = img_object($langs->trans("ShowBill"),'bill').' '.'<a href="'. DOL_URL_ROOT . '/compta/facture.php?facid='.$this->fk_facture.'">'.$langs->trans("Bill").'</a>';
                    $this->objet_url_type = 'facture';
                }
                $this->fk_propal = $obj->propalrowid;
                if ($this->fk_propal)
                {
                    $this->objet_url = img_object($langs->trans("ShowPropal"),'propal').' '.'<a href="'. DOL_URL_ROOT . '/propal/fiche.php?rowid='.$this->fk_propal.'">'.$langs->trans("Propal").'</a>';
                    $this->objet_url_type = 'propal';
                }
                $this->fk_commande = $obj->fk_commande;
                if ($this->fk_commande)
                {
                    $this->objet_url = img_object($langs->trans("ShowOrder"),'order').' '.'<a href="'. DOL_URL_ROOT . '/commande/fiche.php?id='.$this->fk_commande.'">'.$langs->trans("Order").'</a>';
                    $this->objet_url_type = 'order';
                }
        
            }
            $this->db->free($resql);
        }
        else
        {
            dolibarr_print_error($this->db);
        }   
      }
    
      /**
       *    \brief      Supprime l'action de la base
       *    \param      id      id de l'action a effacer
       *    \return     int     1 en cas de succès
       */
      function delete($id)
        {      
            $sql = "DELETE FROM ".MAIN_DB_PREFIX."actioncomm WHERE id=$id;";
            
            if ($this->db->query($sql) )
            {
                return 1;
            }
        }
    
    	/**
     	 *    \brief      	Met a jour l'action en base.
     	 *					Si percent = 100, on met a jour date 100%
     	 *    \return     	int     <0 si ko, >0 si ok
    	 */
        function update()
        {
            $this->label=trim($this->label);
            $this->note=trim($this->note);
            if ($this->percent > 100) $this->percent = 100;
        
            $sql = "UPDATE ".MAIN_DB_PREFIX."actioncomm ";
            $sql.= " SET percent='".$this->percent."'";
            if ($this->label) 			$sql.= ", label = '".addslashes($this->label)."'";
            if ($this->percent == 100) 	$sql.= ", datea = now()";
            if ($this->note) 			$sql.= ", note = '".addslashes($this->note)."'";
            if ($this->contact->id) 	$sql.= ", fk_contact =". $this->contact->id;
            $sql.= " WHERE id=".$this->id;
        
            if ($this->db->query($sql))
            {
                return 1;
            }
            else
            {
            	$this->error=$this->db->error();
            	return -1;
        	}
        }
        
        
        /**
         *      \brief        Charge indicateurs this->nbtodo et this->nbtodolate de tableau de bord
         *      \param        user    Objet user
         *      \return       int     <0 si ko, >0 si ok
         */
        function load_board($user)
        {
            global $conf, $user;
            
            $this->nbtodo=$this->nbtodolate=0;
            $sql = "SELECT a.id,".$this->db->pdate("a.datea")." as da";
            if (!$user->rights->commercial->client->voir && !$user->societe_id) $sql .= ", sc.fk_soc, sc.fk_user";
            $sql.= " FROM ".MAIN_DB_PREFIX."actioncomm as a";
            if (!$user->rights->commercial->client->voir && !$user->societe_id) $sql .= ", ".MAIN_DB_PREFIX."societe_commerciaux as sc";
            $sql.= " WHERE a.percent < 100";
            if ($user->societe_id) $sql.=" AND a.fk_soc = ".$user->societe_id;
            if (!$user->rights->commercial->client->voir && !$user->societe_id) $sql .= " AND a.fk_soc = sc.fk_soc AND sc.fk_user = " .$user->id;
            $resql=$this->db->query($sql);
            if ($resql)
            {
                while ($obj=$this->db->fetch_object($resql))
                {
                    $this->nbtodo++;
                    if ($obj->da < (time() - $conf->actions->warning_delay)) $this->nbtodolate++;
                }
                return 1;
            }
            else 
            {
                $this->error=$this->db->error();
                return -1;
            }
        }
    
    
    	/**
    	 *      \brief     Charge les informations d'ordre info dans l'objet facture
    	 *      \param     id       	Id de la facture a charger
    	 */
    	function info($id)
    	{
    		$sql = 'SELECT a.id, '.$this->db->pdate('a.datec').' as datec,';
    		$sql.= ' '.$this->db->pdate('tms').' as datem,';
    		$sql.= ' fk_user_author';
    		$sql.= ' FROM '.MAIN_DB_PREFIX.'actioncomm as a';
    		$sql.= ' WHERE a.id = '.$id;
    
    		$result=$this->db->query($sql);
    		if ($result)
    		{
    			if ($this->db->num_rows($result))
    			{
    				$obj = $this->db->fetch_object($result);
    				$this->id = $obj->id;
    				if ($obj->fk_user_author)
    				{
    					$cuser = new User($this->db, $obj->fk_user_author);
    					$cuser->fetch();
    					$this->user_creation     = $cuser;
    				}
    
    				$this->date_creation     = $obj->datec;
    				$this->date_modification = $obj->datem;
    			}
    			$this->db->free($result);
    		}
    		else
    		{
    			dolibarr_print_error($this->db);
    		}
    	}
    
    
    	/**
    	 *    	\brief      Retourne le libellé du statut de la commande
    	 *    	\param      mode        0=libellé long, 1=libellé court, 2=Picto + Libellé court, 3=Picto, 4=Picto + Libellé long, 5=Libellé court + Picto
    	 *    	\return     string      Libellé
    	 */
    	function getLibStatut($mode)
    	{
    		return $this->LibStatut($this->percent,$mode);
    	}
    
    	/**
    	 *		\brief      Renvoi le libellé d'un statut donné
    	 *    	\param      percent     Pourcentage avancement
    	 *    	\param      mode        0=libellé long, 1=libellé court, 2=Picto + Libellé court, 3=Picto, 4=Picto + Libellé long, 5=Libellé court + Picto
    	 *    	\return     string		Libellé
    	 */
    	function LibStatut($percent,$mode)
    	{
    		global $langs;
    		
            if ($mode == 0)
            {
            	if ($percent==0) return $langs->trans('StatusActionToDo');
            	if ($percent > 0 && $percent < 100) return $langs->trans('StatusActionInProcess').' ('.$percent.'%)';
            	if ($percent >= 100) return $langs->trans('StatusActionDone').' (100%)';
    		}
            if ($mode == 1)
            {
            	if ($percent==0) return $langs->trans('StatusActionToDo');
            	if ($percent > 0 && $percent < 100) return $percent.'%';
            	if ($percent >= 100) return $langs->trans('StatusActionDone');
            }
            if ($mode == 2)
            {
            	if ($percent==0) return img_picto($langs->trans('StatusActionToDo'),'statut1').' '.$langs->trans('StatusActionToDo');
            	if ($percent > 0 && $percent < 100) return img_picto($langs->trans('StatusActionInProcess'),'statut3').' '. $percent.'%';
            	if ($percent >= 100) return img_picto($langs->trans('StatusActionDone'),'statut6').' '.$langs->trans('StatusActionDone');
            }
            if ($mode == 3)
            {
            	if ($percent==0) return img_picto($langs->trans('StatusActionToDo'),'statut1');
            	if ($percent > 0 && $percent < 100) return img_picto($langs->trans('StatusActionInProcess').' ('.$percent.'%)','statut3');
            	if ($percent >= 100) return img_picto($langs->trans('StatusActionDone'),'statut6');
            }
            if ($mode == 4)
            {
            	if ($percent==0) return img_picto($langs->trans('StatusActionToDo'),'statut1').' '.$langs->trans('StatusActionToDo').' (0%)';
            	if ($percent > 0 && $percent < 100) return img_picto($langs->trans('StatusActionInProcess'),'statut3').' '.$langs->trans('StatusActionInProcess').' ('.$percent.'%)';;
            	if ($percent >= 100) return img_picto($langs->trans('StatusActionDone'),'statut6').' '.$langs->trans('StatusActionDone').' (100%)';
            }
            if ($mode == 5)
            {
            	if ($percent==0) return '0% '.img_picto($langs->trans('StatusActionToDo'),'statut1');
            	if ($percent > 0 && $percent < 100) return $percent.'% '.img_picto($langs->trans('StatusActionInProcess'),'statut3');
            	if ($percent >= 100) return $langs->trans('StatusActionDone').' '.img_picto($langs->trans('StatusActionDone'),'statut6');
            }
    	}
    		
    }    
    ?>