function getAllValuesFromFormx($idformx, $values = '', $ids = '', $options = "")
{
if (!$ids) {
$ids = $this->ids;
}
if ($values) {
if (!is_array($values)) {
$values = array($values);
}
}
$array_oef = array();
if (ereg("idinstance", $options)) {
$res['id_instance'][0] = $idformx;
$nb = 1;
} else {
$base = $this->getSession()->getBase();
$table = $this->getSession()->getTable();
$obReq = $this->getSession()->getObjRequete('', $base, $table);
return $obReq->getGen(" idformx = '{$idformx}' AND ids = '{$ids}' ORDER BY dt_modif DESC ", 'resultquery');
/*
$req = new clResultQuery ;
$param = array();
$param['table']=$this->session->tableInstances;
$param['idformx']=$idformx;
$param['ids']=$ids;
$res = $req -> Execute ( "Fichier", "FX_getValuesInstance", $param, "ResultQuery" ) ;
$nb = $res['INDIC_SVC'][2];
if ( $nb == 0 ) return array("INDIC_SVC" => array( 2 => 0 ) );
* */
}
$ret = array();
for ($i = 0; $i < $nb; $i++) {
$newInstance = new clFoRmX($this->ids, 'NO_POST_THREAT');
$r = $newInstance->loadInstance($res['id_instance'][$i]);
if (!$r) {
return array("INDIC_SVC" => array(2 => 0));
}
if (!$values) {
$values = $newInstance->getAllItems();
//eko("ttval");
} else {
//eko($values);
}
foreach ($values as $val) {
if (!isset($ret[$val])) {
$ret[$val] = array();
}
$ret[$val][$i] = utf8_decode($newInstance->getFormVar($val));
}
if (ereg("moreinfos", $options, $array_oef)) {
$ret["infosmore_auteur"][$i] = $res['author'][$i];
$date_creation = new clDate($res['dt_creation'][$i]);
$ret["infosmore_dt_creation"][$i] = $date_creation->getDateTextFull();
}
}
unset($newInstance);
$ret['INDIC_SVC'][2] = $nb;
return $ret;
}
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;
}
