[Dolibarr-dev] correction requête sql expéditi on Dolibarr 3.0

[address@hidden]

Salut à tous,

La requête de la méthode nb_expéditions() de 
commande/class/commande.class.php provoque une erreur SQL    "query SQL 
error: SELECT count(*) FROM llx_expedition as e WHERE e.fk_commande = 30 
DB_ERROR_NOSUCHFIELD"

Correction:

remplacer la requête
       $sql = 'SELECT count(*) FROM '.MAIN_DB_PREFIX.'expedition as e';
       $sql .=" WHERE e.fk_commande = ".$this->id;

par
       $sql = 'SELECT count(*) FROM '.MAIN_DB_PREFIX.'expedition as e';
       $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."element_element as el ON 
el.fk_target = e.rowid AND el.targettype = 'shipping' ";
       $sql .=" WHERE el.fk_source = ".$this->id;

@+

Jean