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();