if ($cn->exec_sql($Sql) == false) {
ob_end_clean();
echo "<h2 class=\"error\"> Base de donnée " . domaine . "dossier" . $_POST['FMOD_DBID'] . " " . _("est accèdée, déconnectez-vous en d'abord") . "</h2>";
$Res = $cn->exec_sql("delete from modeledef where mod_id=" . $l_id);
exit;
}
}
}
// if $mod_name != null
$cn_mod = new Database($l_id, 'mod');
// Clean some tables
$Res = $cn_mod->exec_sql("select distinct jr_pj from jrn where jr_pj is not null ");
if (Database::num_row($Res) != 0) {
$a_lob = Database::fetch_all($Res);
for ($i = 0; $i < count($a_lob); $i++) {
$cn_mod->lo_unlink($a_lob[$i]['jr_pj']);
}
}
Extension::clean($cn_mod);
$Res = $cn_mod->exec_sql("truncate table centralized");
$Res = $cn_mod->exec_sql("truncate table jrn cascade");
$Res = $cn_mod->exec_sql("delete from del_jrn");
$Res = $cn_mod->exec_sql("delete from del_jrnx");
$Res = $cn_mod->exec_sql("truncate table jrnx cascade ");
$Res = $cn_mod->exec_sql("truncate table todo_list cascade ");
$Res = $cn_mod->exec_sql("delete from del_action");
$Res = $cn_mod->exec_sql("delete from profile_user");
$Res = $cn_mod->exec_sql("delete from jnt_letter");
$Res = $cn_mod->exec_sql('delete from operation_analytique');
// Reset the closed periode
$Res = $cn_mod->exec_sql("update parm_periode set p_closed='f'");
echo $sp->input();
echo HtmlInput::hidden('act', 'loadfile');
echo dossier::hidden();
echo HtmlInput::hidden('jr_id', $jr_id);
echo HtmlInput::hidden('div', $div);
echo '<INPUT TYPE="FILE" name="pj" onchange="getElementById(\'file' . $div . '\').style.display=\'inline\';submit(this);">';
echo '</FORM>';
$ret = $cn->exec_sql("select jr_pj from jrn where jr_id=\$1", array($jr_id));
if (Database::num_row($ret) != 0) {
$r = Database::fetch_array($ret, 0);
$old_oid = $r['jr_pj'];
if (strlen($old_oid) != 0) {
// check if this pj is used somewhere else
$c = $cn->count_sql("select * from jrn where jr_pj=" . $old_oid);
if ($c == 1) {
$cn->lo_unlink($old_oid);
}
}
$cn->exec_sql("update jrn set jr_pj=null, jr_pj_name=null, " . "jr_pj_type=null where jr_id=\$1", array($jr_id));
}
}
echo '</div>';
exit;
/////////////////////////////////////////////////////////////////////////////
// Save operation detail
/////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////
// Save operation detail
/////////////////////////////////////////////////////////////////////////////
case 'save':
ob_start();