Bonjour,
Je vais essayer de vous expliquer mon soucis, voici un bout de snippet :
$tbl_shop_orders = $modx->getFullTableName('shop_orders');
$tbl_shop_order_state_lang = $modx->getFullTableName('shop_order_state_lang');
$tbl_shop_order_history = $modx->getFullTableName('shop_order_history');
$tbl_shop_order_history_lang = $modx->getFullTableName('shop_order_history_lang');
function order_state($id) {
global $modx, $tbl_shop_order_history, $tbl_shop_order_state_lang, $lang_default;
$rs = $modx->db->select( "L.name", "$tbl_shop_order_history AS H INNER JOIN $tbl_shop_order_state_lang AS L ON H.id_order_state=L.id_order_state", "H.id_order='$id' AND L.id_lang=1", "H.date_add DESC", 1 );
return $modx->db->getValue($rs);
}
Et voici mon ma requete une fois affichée :
SQL: SELECT L.name FROM AS H INNER JOIN AS L ON H.id_order_state=L.id_order_state WHERE H.id_order='1' AND L.id_lang=1 ORDER BY H.date_add DESC LIMIT 1
Apparement les globales ne fonctionnent plus dans un fonction inclue dans un snippet, pareil avec un fichier externe comportant le bout de code.
Quelqu’un aurait t’il une idée ?
