function dde_show($form_name)
{
global $l, $protectedPost, $protectedGet, $pages_refs;
//suppression d'une demande
if (isset($protectedPost['SUP_PROF']) and is_numeric($protectedPost['SUP_PROF'])) {
//on récupère l'id du champ status
$item_id_STATUS = find_id_field();
$sql = "UPDATE downloadwk_pack \n\t\t\t\t\t\t\t\t\t\tset FIELDS_%s='1'\n\t\t\t\t\t\t\t\t\t\twhere ID='%s'";
$arg = array($item_id_STATUS['STATUS']->id, $protectedPost['SUP_PROF']);
mysql2_query_secure($sql, $_SESSION['OCS']["writeServer"], $arg);
$tab_options['CACHE'] = 'RESET';
}
$table_name = 'LIST_DDE';
//recherche des champs qui ont été créés
$sql_fields = "select lbl,id,type,field from downloadwk_fields ";
$resultfields = mysql2_query_secure($sql_fields, $_SESSION['OCS']["readServer"]);
//$resultfields = mysql_query($sql_fields, $_SESSION['OCS']["readServer"]) or mysql_error($_SESSION['OCS']["readServer"]);
$id_field1 = 0;
$id_field2 = 0;
$default_fields = array();
while ($item = mysql_fetch_object($resultfields)) {
$name_field[$item->id] = $item->field;
$field = 'fields_' . $item->id;
if ($item->field == "STATUS") {
$id_status = $field;
}
if (($item->type == '2' or $item->type == '5') and $item->field != "STATUS") {
$array_value_fields[$id_field1] = $field . ".VALUE as " . $field;
$array_fields[$id_field1] = $field;
$id_field1++;
} else {
$else_fields[$id_field2] = "downloadwk_pack." . $field;
$id_field2++;
}
if (count($default_fields) < 5) {
$default_fields[$field] = $field;
}
if ($l->g($item->lbl)) {
$tab_options['LBL'][$field] = $l->g($item->lbl);
} else {
$tab_options['LBL'][$field] = $item->lbl;
}
$list_fields[$field] = $field;
}
// print_r($tab_options['LBL']);
//recherche des valeurs des différents statuts
$sql_statut = "select id,lbl from downloadwk_statut_request";
$resultfields = mysql2_query_secure($sql_statut, $_SESSION['OCS']["readServer"]);
while ($item = mysql_fetch_object($resultfields)) {
$statut[$item->id] = $item->lbl;
}
$tab_options['REPLACE_VALUE'][$id_status] = $statut;
$list_col_cant_del[$id_status] = $id_status;
$default_fields[$id_status] = $id_status;
$list_fields[$id_status] = $id_status;
$list_col_cant_del['Q_DATE'] = 'Q_DATE';
$default_fields['Q_DATE'] = 'Q_DATE';
$list_fields['Q_DATE'] = 'Q_DATE';
$list_col_cant_del['SUP'] = 'SUP';
$default_fields['SUP'] = 'SUP';
$list_fields['SUP'] = 'ID';
$list_fields['MODIF'] = 'ID';
$default_fields['MODIF'] = 'MODIF';
$list_col_cant_del['MODIF'] = 'MODIF';
$tab_options['LBL']['Q_DATE'] = "Date dde";
$sql = "select downloadwk_pack.ID,FROM_UNIXTIME(Q_DATE) as Q_DATE,";
if (isset($array_value_fields)) {
$sql .= implode(', ', $array_value_fields);
$bool_select = true;
}
// print_r($else_fields);
if (isset($else_fields)) {
if ($bool_select) {
$sql .= ", ";
}
$sql .= implode(', ', $else_fields);
$bool_normal = true;
}
if (!$bool_normal and !$bool_select) {
$sql .= " * ";
}
$sql .= " from downloadwk_pack ";
$i = 0;
while ($array_fields[$i]) {
$sql .= " left join downloadwk_conf_values " . $array_fields[$i] . " on downloadwk_pack." . $array_fields[$i] . "=" . $array_fields[$i] . ".ID ";
$i++;
}
$sql .= " WHERE " . $id_status . "!= (Select id from downloadwk_statut_request where name='NIV0')";
if ($_SESSION['OCS']['RESTRICTION']['TELEDIFF_WK'] == 'LOGIN') {
$sql .= " and LOGIN_USER='******'OCS']['loggeduser'] . "' ";
} elseif ($_SESSION['OCS']['RESTRICTION']['TELEDIFF_WK'] == 'USER_GROUP') {
$sql .= " and GROUP_USER='******'OCS']['user_group'] . "' ";
}
tab_req($table_name, $list_fields, $default_fields, $list_col_cant_del, $sql, $form_name, 100, $tab_options);
}
if ($protectedPost['valid']) {
echo " style='display:none;'";
}
echo ">";
printEnTete($l->g(434));
echo "<br>";
$activate = option_conf_activate('TELEDIFF_WK');
//If workflow for teledeploy is activated
//We show only the package we can create
if ($activate) {
msg_info($l->g(1105) . "<br>" . $l->g(1106) . "<br>" . $l->g(1107));
//get all request with the status "Create a Package"
$conf_creat_Wk = look_config_default_values(array('IT_SET_NIV_CREAT'));
$info_dde_statut_creat = info_dde(find_dde_by_status($conf_creat_Wk['tvalue']['IT_SET_NIV_CREAT']));
if ($info_dde_statut_creat != '') {
$array_id_fields = find_id_field(array('NAME_TELEDEPLOY', 'PRIORITY', 'NOTIF_USER', 'REPORT_USER', 'INFO_PACK'));
//build the seach
$id_name = "fields_" . $array_id_fields['NAME_TELEDEPLOY']->id;
$id_description = "fields_" . $array_id_fields['INFO_PACK']->id;
$id_priority = "fields_" . $array_id_fields['PRIORITY']->id;
$id_notify_user = "******" . $array_id_fields['NOTIF_USER']->id;
foreach ($info_dde_statut_creat as $id => $tab_value) {
$list_dde_creat[$tab_value->ID] = $tab_value->{$id_name};
}
echo "<br><b>" . $l->g(1183) . ":</b>" . show_modif($list_dde_creat, 'LIST_DDE_CREAT', 2, $form_name);
if (!$protectedPost['LIST_DDE_CREAT'] or $protectedPost['LIST_DDE_CREAT'] == "") {
echo close_form();
require_once FOOTER_HTML;
die;
} else {
$protectedPost['NAME'] = $info_dde_statut_creat[$protectedPost['LIST_DDE_CREAT']]->{$id_name};
