static function getinstances($idformx, $values = '', $filtre = "FX_getInstances", $date1 = "", $date2 = "")
{
formxSession::getInstance()->addErreur("getinstances est une fonction obsolette");
if ($date1) {
$date1 = clFoRmXtOoLs::anydate2datetime($date1);
}
if ($date2) {
$date2 = clFoRmXtOoLs::anydate2datetime($date2);
}
if (!$filtre) {
$filtre = "FX_getInstances";
}
$param = array();
if ($date1 && $date2) {
$param['cwdate'] = " AND dt_modif >= '{$date1}' and dt_creation <= '{$date2}' ";
} elseif ($date1) {
$param['cwdate'] = " AND dt_modif >= '{$date1}' ";
} elseif ($date2) {
$param['cwdate'] = " AND dt_modif <= '{$date2}' ";
} else {
$param['cwdate'] = " AND 1=1 ";
}
if ($values) {
if (!is_array($values)) {
$values = array($values);
}
}
if (is_array($idformx)) {
$param['listeidformx'] = "'" . implode("','", $idformx) . "' AND";
// $param['cwdate'] = " AND " . $para['cwdate'];
} else {
$param['listeidformx'] = "'" . $idformx . "' AND";
// $param['cwdate'] = " AND " . $para['cwdate'];
}
//print affTab ( $param ) ; return ;
$req = new clResultQuery();
if (defined('FX_INSTANCES')) {
$param['table'] = FX_INSTANCES;
} else {
$param['table'] = TABLEFORMX;
}
$res = $req->Execute("Fichier", $filtre, $param, "ResultQuery");
$nb = $res['INDIC_SVC'][2];
//print affTab ( $res['INDIC_SVC'] ) ;
if ($nb == 0) {
return array();
}
$ret = array();
$ret['ids'] = array();
$ret['id_instance'] = array();
$ret['dt_creation'] = array();
$ret['dt_modif'] = array();
$ret['idformx'] = array();
$ret['libelle'] = array();
$ret['status'] = array();
$ret['author'] = array();
for ($i = 0; $i < $nb; $i++) {
$ret['ids'][$i] = $res['ids'][$i];
$ret['id_instance'][$i] = $res['id_instance'][$i];
$ret['dt_creation'][$i] = $res['dt_creation'][$i];
$ret['dt_modif'][$i] = $res['dt_modif'][$i];
$ret['idformx'][$i] = $res['idformx'][$i];
$ret['libelle'][$i] = $res['libelle'][$i];
$ret['status'][$i] = $res['status'][$i];
$ret['author'][$i] = $res['author'][$i];
$newInstance = new clFoRmX($res['ids'][$i], 'NO_POST_THREAT');
$newInstance->loadInstance($res['id_instance'][$i]);
if (!$values) {
$values = $newInstance->getAllItems();
}
foreach ($values as $val) {
if (!isset($ret[$val])) {
$ret[$val] = array();
}
$ret[$val][$i] = utf8_decode($newInstance->getFormVar($val));
}
unset($newInstance);
}
$ret['INDIC_SVC'][2] = $nb;
return $ret;
}
