Author: danydb Date: 2011-11-11 23:44:31 +0100 (Fri, 11 Nov 2011) New Revision: 4343
Modified: phpcompta/trunk/include/modele.inc.php Log: reformatting Modified: phpcompta/trunk/include/modele.inc.php =================================================================== --- phpcompta/trunk/include/modele.inc.php 2011-11-11 15:50:35 UTC (rev 4342) +++ phpcompta/trunk/include/modele.inc.php 2011-11-11 22:44:31 UTC (rev 4343) @@ -15,12 +15,12 @@ * You should have received a copy of the GNU General Public License * along with PhpCompta; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA -*/ + */ /* $Revision$ */ // Copyright Author Dany De Bontridder [email protected] -/*!\file +/* !\file * * * \brief concerne only the template @@ -28,376 +28,372 @@ */ require_once("class_itext.php"); require_once("class_icheckbox.php"); -$sa=(isset ( $_REQUEST['sa']))?$_REQUEST['sa']:'list'; -if ( isset ($_POST['upd']) && - isset($_POST['m'])) +$sa = (isset($_REQUEST['sa'])) ? $_REQUEST['sa'] : 'list'; +if (isset($_POST['upd']) && + isset($_POST['m'])) { - if ( isset($_POST['name']) && isset($_POST['desc'])) - { - extract($_POST); - $cn=new Database(); - if ( strlen(trim($name)) !=0 - && $cn->get_value('select count(*) from modeledef where '. - 'mod_name=$1 and mod_id !=$2', - array(trim($name),$m)) == 0 - ) - { + if (isset($_POST['name']) && isset($_POST['desc'])) + { + extract($_POST); + $cn = new Database(); + if (strlen(trim($name)) != 0 + && $cn->get_value('select count(*) from modeledef where ' . + 'mod_name=$1 and mod_id !=$2', array(trim($name), $m)) == 0 + ) + { - $cn->exec_sql("update modeledef set mod_name=$1, ". - " mod_desc=$2 where mod_id=$3 ", - array(trim($name),trim($desc),$m)); - - - } - } - $sa="list"; + $cn->exec_sql("update modeledef set mod_name=$1, " . + " mod_desc=$2 where mod_id=$3 ", array(trim($name), trim($desc), $m)); + } + } + $sa = "list"; } -$cn=new Database(); +$cn = new Database(); // IF FMOD_NAME is posted then must add a template -if ( isset ($_POST["FMOD_NAME"]) ) +if (isset($_POST["FMOD_NAME"])) { - $encoding=$cn->get_value("select encoding from pg_database where ". - " datname='".domaine.'dossier'.sql_string($_POST["FMOD_DBID"])."'"); + $encoding = $cn->get_value("select encoding from pg_database where " . + " datname='" . domaine . 'dossier' . sql_string($_POST["FMOD_DBID"]) . "'"); - if ( $encoding != 6 ) - { - alert('Désolé vous devez migrer ce modèle en unicode'); - echo '<span class="error">la base de donnée '. - domaine.'mod'.$_POST["FMOD_DBID"]." doit être migrée en unicode</span>"; - echo '<span class="error"> Pour le passer en unicode, faites-en un backup puis restaurez le fichier reçu</span>'; + if ($encoding != 6) + { + alert('Désolé vous devez migrer ce modèle en unicode'); + echo '<span class="error">la base de donnée ' . + domaine . 'mod' . $_POST["FMOD_DBID"] . " doit être migrée en unicode</span>"; + echo '<span class="error"> Pour le passer en unicode, faites-en un backup puis restaurez le fichier reçu</span>'; - echo HtmlInput::button_anchor('Retour','admin_repo.php?action=dossier_mgt'); - exit(); - } + echo HtmlInput::button_anchor('Retour', 'admin_repo.php?action=dossier_mgt'); + exit(); + } - $mod_name=sql_string($_POST["FMOD_NAME"]); - $mod_desc=sql_string($_POST["FMOD_DESC"]); - if ( $mod_name != null) - { - $Res=$cn->exec_sql("insert into modeledef(mod_name,mod_desc) - values ('".$mod_name."',". - "'".$mod_desc."')"); + $mod_name = sql_string($_POST["FMOD_NAME"]); + $mod_desc = sql_string($_POST["FMOD_DESC"]); + if ($mod_name != null) + { + $Res = $cn->exec_sql("insert into modeledef(mod_name,mod_desc) + values ('" . $mod_name . "'," . + "'" . $mod_desc . "')"); - // get the mod_id - $l_id=$cn->get_current_seq('s_modid'); - if ( $l_id != 0 ) - { - $Sql=sprintf("CREATE DATABASE %sMOD%d encoding='UTF8' TEMPLATE %sDOSSIER%s",domaine,$l_id,domaine,$_POST["FMOD_DBID"]); - ob_start(); - 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); + // get the mod_id + $l_id = $cn->get_current_seq('s_modid'); + if ($l_id != 0) + { + $Sql = sprintf("CREATE DATABASE %sMOD%d encoding='UTF8' TEMPLATE %sDOSSIER%s", domaine, $l_id, domaine, $_POST["FMOD_DBID"]); + ob_start(); + 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 + exit; + } + } + }// if $mod_name != null - $cn_mod=new Database($l_id,'mod'); + $cn_mod = new Database($l_id, 'mod'); - // Clean some tables + // 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']); - } + $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']); + } - $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("delete from del_action"); + $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("delete from del_action"); - $Res=$cn_mod->exec_sql('delete from operation_analytique'); + $Res = $cn_mod->exec_sql('delete from operation_analytique'); - $Res=$cn_mod->exec_sql("truncate table import_tmp"); - // Reset the closed periode - $Res=$cn_mod->exec_sql("update parm_periode set p_closed='f'"); - $Res=$cn_mod->exec_sql('delete from jrn_periode'); - $Res=$cn_mod->exec_sql(' insert into jrn_periode(p_id,jrn_def_id,status) '. - ' select p_id,jrn_def_id,\'OP\' '. - ' from '. - ' parm_periode cross join jrn_def'); + $Res = $cn_mod->exec_sql("truncate table import_tmp"); + // Reset the closed periode + $Res = $cn_mod->exec_sql("update parm_periode set p_closed='f'"); + $Res = $cn_mod->exec_sql('delete from jrn_periode'); + $Res = $cn_mod->exec_sql(' insert into jrn_periode(p_id,jrn_def_id,status) ' . + ' select p_id,jrn_def_id,\'OP\' ' . + ' from ' . + ' parm_periode cross join jrn_def'); - // Reset Sequence - $a_seq=array('s_jrn','s_jrn_op','s_centralized','s_stock_goods','s_internal'); - foreach ($a_seq as $seq ) - { - $sql=sprintf("select setval('%s',1,false)",$seq); - $Res=$cn_mod->exec_sql($sql); - } - $sql="select jrn_def_id from jrn_def "; - $Res=$cn_mod->exec_sql($sql); - $Max=Database::num_row($Res); - for ($seq=0;$seq<$Max;$seq++) - { - $row=Database::fetch_array($Res,$seq); - /* if seq doesn't exist create it */ - if ( $cn_mod->exist_sequence('s_jrn_'.$row['jrn_def_id']) == false ) - { - $cn_mod->create_sequence('s_jrn_'.$row['jrn_def_id']); - } + // Reset Sequence + $a_seq = array('s_jrn', 's_jrn_op', 's_centralized', 's_stock_goods', 's_internal'); + foreach ($a_seq as $seq) + { + $sql = sprintf("select setval('%s',1,false)", $seq); + $Res = $cn_mod->exec_sql($sql); + } + $sql = "select jrn_def_id from jrn_def "; + $Res = $cn_mod->exec_sql($sql); + $Max = Database::num_row($Res); + for ($seq = 0; $seq < $Max; $seq++) + { + $row = Database::fetch_array($Res, $seq); + /* if seq doesn't exist create it */ + if ($cn_mod->exist_sequence('s_jrn_' . $row['jrn_def_id']) == false) + { + $cn_mod->create_sequence('s_jrn_' . $row['jrn_def_id']); + } - $sql=sprintf ("select setval('s_jrn_%d',1,false)",$row['jrn_def_id']); - $cn_mod->exec_sql($sql); + $sql = sprintf("select setval('s_jrn_%d',1,false)", $row['jrn_def_id']); + $cn_mod->exec_sql($sql); - $sql=sprintf ("select setval('s_jrn_pj%d',1,false)",$row['jrn_def_id']); - $cn_mod->exec_sql($sql); - $sql=sprintf ("select setval('jnt_letter_jl_id_seq',1,false)"); - $cn_mod->exec_sql($sql); + $sql = sprintf("select setval('s_jrn_pj%d',1,false)", $row['jrn_def_id']); + $cn_mod->exec_sql($sql); + $sql = sprintf("select setval('jnt_letter_jl_id_seq',1,false)"); + $cn_mod->exec_sql($sql); + } + //--- + // Cleaning Follow_Up + //-- + if (isset($_POST['DOC'])) + { + $Res = $cn_mod->exec_sql("delete from action_gestion"); + $Res = $cn_mod->exec_sql("delete from document"); - } - //--- - // Cleaning Follow_Up - //-- - if ( isset($_POST['DOC'] )) - { - $Res=$cn_mod->exec_sql("delete from action_gestion"); - $Res=$cn_mod->exec_sql("delete from document"); + // Remove lob file + $Res = $cn_mod->exec_sql("select distinct loid from pg_largeobject except select md_lob from document_modele"); + if (Database::num_row($Res) != 0) + { + $a_lob = Database::fetch_all($Res); + //var_dump($a_lob); + foreach ($a_lob as $lob) + { + $cn_mod->lo_unlink($lob['loid']); + } + } + } + if (isset($_POST['CARD'])) + { + $Res = $cn_mod->exec_sql("delete from fiche_detail"); + $Res = $cn_mod->exec_sql("delete from fiche"); + $Res = $cn_mod->exec_sql("delete from action_gestion"); + $Res = $cn_mod->exec_sql("delete from document"); + $Res = $cn_mod->exec_sql("delete from document_modele"); + $Res = $cn_mod->exec_sql("delete from op_predef"); - // Remove lob file - $Res=$cn_mod->exec_sql("select distinct loid from pg_largeobject except select md_lob from document_modele"); - if ( Database::num_row($Res) != 0 ) - { - $a_lob=Database::fetch_all($Res); - //var_dump($a_lob); - foreach ($a_lob as $lob) - { - $cn_mod->lo_unlink($lob['loid']); - } - } - } - if ( isset($_POST['CARD'])) - { - $Res=$cn_mod->exec_sql("delete from fiche_detail"); - $Res=$cn_mod->exec_sql("delete from fiche"); - $Res=$cn_mod->exec_sql("delete from action_gestion"); - $Res=$cn_mod->exec_sql("delete from document"); - $Res=$cn_mod->exec_sql("delete from document_modele"); - $Res=$cn_mod->exec_sql("delete from op_predef"); - - // Remove lob file - $Res=$cn_mod->exec_sql("select distinct loid from pg_largeobject"); - if ( Database::num_row($Res) != 0 ) - { - $a_lob=Database::fetch_all($Res); - foreach ($a_lob as $lob) - $cn_mod->lo_unlink($lob['loid']); - } - - - } - if ( isset($_POST['CANAL'])) - { - $Res=$cn_mod->exec_sql('delete from poste_analytique'); - $Res=$cn_mod->exec_sql('delete from plan_analytique'); - } - + // Remove lob file + $Res = $cn_mod->exec_sql("select distinct loid from pg_largeobject"); + if (Database::num_row($Res) != 0) + { + $a_lob = Database::fetch_all($Res); + foreach ($a_lob as $lob) + $cn_mod->lo_unlink($lob['loid']); + } + } + if (isset($_POST['CANAL'])) + { + $Res = $cn_mod->exec_sql('delete from poste_analytique'); + $Res = $cn_mod->exec_sql('delete from plan_analytique'); + } } // Show all available templates -$Res=$cn->exec_sql("select mod_id,mod_name,mod_desc from +$Res = $cn->exec_sql("select mod_id,mod_name,mod_desc from modeledef order by mod_name"); -$count=Database::num_row($Res); +$count = Database::num_row($Res); echo '<div class="content" style="width:80%;margin-left:10%">'; echo "<H2>Modèles</H2>"; -if ( $sa=='list') +if ($sa == 'list') { - if ( $count == 0 ) - { - echo "No template available"; - } - else - { + if ($count == 0) + { + echo "No template available"; + } + else + { - echo HtmlInput::button_anchor('Rafraîchir','admin_repo.php?action=modele_mgt'); - echo HtmlInput::button_anchor('Ajouter','admin_repo.php?action=modele_mgt&sa=add'); + echo HtmlInput::button_anchor('Rafraîchir', 'admin_repo.php?action=modele_mgt'); + echo HtmlInput::button_anchor('Ajouter', 'admin_repo.php?action=modele_mgt&sa=add'); - echo '<table class="result" style="border-spacing:5;border-collapse:separate" >'; - echo "<TR><TH>Nom</TH>". - "<TH>Description</TH>". - "<th> </th>". - "<th> </th>". - "<th> </th>". + echo '<table class="result" style="border-spacing:10;border-collapse:separate" >'; + echo "<TR><TH>Nom</TH>" . + "<TH>Description</TH>" . + "<th> </th>" . + "<th> </th>" . + "<th> </th>" . + "</TR>"; - "</TR>"; - - for ($i=0;$i<$count;$i++) - { - $mod=Database::fetch_array($Res,$i); - printf('<TR>'. - '<TD>%d <b> %s</b> </TD>'. - '<TD><I> %s </I></TD>'. - '<td> '. - HtmlInput::button_anchor('Effacer','?action=modele_mgt&sa=del&m='.$mod['mod_id']).'</td>'. - '</td>'. - '<td>'.HtmlInput::button_anchor('Modifie','?action=modele_mgt&sa=mod&m='.$mod['mod_id']).'</td>'. - '</td>'. - '<td>'.HtmlInput::button_anchor('Backup','backup.php?action=backup&sa=b&t=m&d=' - .$mod['mod_id']).'</td>'. - '</TR>', - $mod['mod_id'], - $mod['mod_name'], - $mod['mod_desc']); - - }// for - echo "</table>"; - }// if count = 0 - echo "<p class=\"notice\">Si vous voulez récupérer toutes les adaptations d'un dossier ". - " dans un autre dossier, vous pouvez en faire un modèle.". - " Seules les fiches, la structure des journaux, les périodes,... seront reprises ". - "et aucune donnée du dossier sur lequel le dossier est basé. Les données contenues dans les extensions ne sont pas effacées</p>"; + for ($i = 0; $i < $count; $i++) + { + $mod = Database::fetch_array($Res, $i); + $class = ($i % 2 == 0) ? "odd" : "even"; + printf('<TR class="' . $class . '" style="vertical-align:top">' . + '<TD>%d <b> %s</b> </TD>' . + '<TD><I> %s </I></TD>' . + '<td> ' . + HtmlInput::button_anchor('Effacer', '?action=modele_mgt&sa=del&m=' . $mod['mod_id']) . '</td>' . + '</td>' . + '<td>' . HtmlInput::button_anchor('Modifie', '?action=modele_mgt&sa=mod&m=' . $mod['mod_id']) . '</td>' . + '</td>' . + '<td>' . HtmlInput::button_anchor('Backup', 'backup.php?action=backup&sa=b&t=m&d=' + . $mod['mod_id']) . '</td>' . + '</TR>', $mod['mod_id'], $mod['mod_name'], $mod['mod_desc']); + }// for + echo "</table>"; + }// if count = 0 + echo "<p class=\"notice\">Si vous voulez récupérer toutes les adaptations d'un dossier " . + " dans un autre dossier, vous pouvez en faire un modèle." . + " Seules les fiches, la structure des journaux, les périodes,... seront reprises " . + "et aucune donnée du dossier sur lequel le dossier est basé. Les données contenues dans les extensions ne sont pas effacées</p>"; } //--------------------------------------------------------------------------- // Add a template //--------------------------------------------------------------------------- -if ( $sa == 'add') +if ($sa == 'add') { // Show All available folder - $Res=$cn->exec_sql("select dos_id, dos_name,dos_description from ac_dossier + $Res = $cn->exec_sql("select dos_id, dos_name,dos_description from ac_dossier order by dos_name"); - $count=Database::num_row($Res); - $available=""; - if ( $count != 0 ) - { - $available='<SELECT NAME="FMOD_DBID">'; - for ($i=0;$i<$count;$i++) - { - $db=Database::fetch_array($Res,$i); - $available.='<OPTION VALUE="'.$db['dos_id'].'">'.$db['dos_name'].':'.$db['dos_description']; - }//for i - $available.='</SELECT>'; - }//if count !=0 - ?> - <form action="admin_repo.php?action=modele_mgt" METHOD="post"> - <TABLE> - <tr> - <td>Nom </TD> - <TD><INPUT TYPE="TEXT" VALUE="" NAME="FMOD_NAME"></TD> - </TR> - <TR> - <TD>Description</TD> - <TD><TEXTAREA ROWS="2" COLS="60" NAME="FMOD_DESC"></Textarea></TD> - </TR> - <TR> - <TD> Basé - sur </TD> - <TD> <?php echo $available ?></TD> - </TR> - <TR><TD>Nettoyage des Documents et courriers (ce qui n'effacera pas les modèles de documents)</TD><TD> <input type="checkbox" name="DOC"></TD></TR> - <TR><TD>Nettoyage de toutes les fiches (ce qui effacera client, opérations prédéfinies fournisseurs modèles de documents et documents)</TD><TD> <input type="checkbox" name="CARD"></TD></TR> + $count = Database::num_row($Res); + $available = ""; + if ($count != 0) + { + $available = '<SELECT NAME="FMOD_DBID">'; + for ($i = 0; $i < $count; $i++) + { + $db = Database::fetch_array($Res, $i); + $available.='<OPTION VALUE="' . $db['dos_id'] . '">' . $db['dos_name'] . ':' . $db['dos_description']; + }//for i + $available.='</SELECT>'; + }//if count !=0 + ?> + <form action="admin_repo.php?action=modele_mgt" METHOD="post"> + <TABLE> + <tr> + <td>Nom </TD> + <TD><INPUT TYPE="TEXT" VALUE="" NAME="FMOD_NAME"></TD> + </TR> + <TR> + <TD>Description</TD> + <TD><TEXTAREA ROWS="2" COLS="60" NAME="FMOD_DESC"></Textarea></TD> + </TR> + <TR> + <TD> Basé + sur </TD> + <TD> <?php echo $available?></TD> + </TR> + <TR> + <TD>Nettoyage des Documents et courriers (ce qui n'effacera pas les modèles de documents)</TD> + <TD> <input type="checkbox" name="DOC"></TD></TR> + <TR> + <TD>Nettoyage de toutes les fiches (ce qui effacera client, + opérations prédéfinies fournisseurs modèles de documents et documents)</TD> + <TD> <input type="checkbox" name="CARD"></TD> + </TR> - <TR><TD>Nettoyage de la comptabilité analytique : effacement des plans et des postes, les opérations sont de toute façon effacées </TD><TD> <input type="checkbox" name="CANAL"></TD></TR> - </TABLE> + <TR> + <TD>Nettoyage de la comptabilité analytique : effacement des plans et des postes, les opérations + sont de toute façon effacées </TD> + <TD> <input type="checkbox" name="CANAL"></TD> + </TR> + </TABLE> - ' + ' - <INPUT TYPE="SUBMIT" class="button" VALUE="Ajout d'un modele"> - <?php - echo HtmlInput::button_anchor('Retour','?action=modele_mgt'); - ?> + <INPUT TYPE="SUBMIT" class="button" VALUE="Ajout d'un modele"> + <?php + echo HtmlInput::button_anchor('Retour', '?action=modele_mgt'); + ?> - </form> - <?php - } - //--------------------------------------------------------------------------- - // Modify - if ( $sa == 'mod' && isset($_GET['m']) ) - { - $cn=new Database(); + </form> + <?php + } + //--------------------------------------------------------------------------- + // Modify + if ($sa == 'mod' && isset($_GET['m'])) + { + $cn = new Database(); - echo '<form method="post">'; - $name=$cn->get_value( - "select mod_name from modeledef where ". - " mod_id=$1", - array($_GET['m'])); + echo '<form method="post">'; + $name = $cn->get_value( + "select mod_name from modeledef where " . + " mod_id=$1", array($_GET['m'])); - $desc=$cn->get_value( - "select mod_desc from modeledef where ". - " mod_id=$1", - array($_GET['m'])); - $wText=new IText(); - echo 'Nom : '.$wText->input('name',$name); - $wDesc=new ITextArea(); - $wDesc->heigh=5; - echo '<br>Description :<br>'; - echo $wDesc->input('desc',$desc); - echo HtmlInput::hidden('m',$_GET['m']); - echo HtmlInput::hidden('action','modele_mgt'); - echo '<br>'; - echo HtmlInput::button_anchor('Retour','?action=modele_mgt'); - echo HtmlInput::submit('upd','Modifie'); - echo '</form>'; - } + $desc = $cn->get_value( + "select mod_desc from modeledef where " . + " mod_id=$1", array($_GET['m'])); + $wText = new IText(); + echo 'Nom : ' . $wText->input('name', $name); + $wDesc = new ITextArea(); + $wDesc->heigh = 5; + echo '<br>Description :<br>'; + echo $wDesc->input('desc', $desc); + echo HtmlInput::hidden('m', $_GET['m']); + echo HtmlInput::hidden('action', 'modele_mgt'); + echo '<br>'; + echo HtmlInput::button_anchor('Retour', '?action=modele_mgt'); + echo HtmlInput::submit('upd', 'Modifie'); + echo '</form>'; + } - //--------------------------------------------------------------------------- - // action = del - //--------------------------------------------------------------------------- - if ( $sa == 'del' ) - { - $cn=new Database(); - $name=$cn->get_value('select mod_name from modeledef where mod_id=$1',array($_REQUEST['m'])); - echo '<form method="post">'; - echo HtmlInput::hidden('d',$_REQUEST['m']); - echo HtmlInput::hidden('sa','remove'); - echo '<h2 class="error">Etes vous sure et certain de vouloir effacer '.$name.' ???</h2>'; - $confirm=new ICheckBox(); - $confirm->name="p_confirm"; - echo 'Cochez la case si vous êtes sûr de vouloir effacer ce modèle'; - echo $confirm->input(); - echo HtmlInput::submit('remove','Effacer'); - echo HtmlInput::button_anchor('Retour','?action=modele_mgt'); - echo '</form>'; - } - //--------------------------------------------------------------------------- - // action = del - //--------------------------------------------------------------------------- - if ( $sa == 'remove' ) - { - if ( ! isset ($_REQUEST['p_confirm'])) - { - echo('Désolé, vous n\'avez pas coché la case'); - echo HtmlInput::button_anchor('Retour','?action=modele_mgt'); - exit(); - } + //--------------------------------------------------------------------------- + // action = del + //--------------------------------------------------------------------------- + if ($sa == 'del') + { + $cn = new Database(); + $name = $cn->get_value('select mod_name from modeledef where mod_id=$1', array($_REQUEST['m'])); + echo '<form method="post">'; + echo HtmlInput::hidden('d', $_REQUEST['m']); + echo HtmlInput::hidden('sa', 'remove'); + echo '<h2 class="error">Etes vous sure et certain de vouloir effacer ' . $name . ' ???</h2>'; + $confirm = new ICheckBox(); + $confirm->name = "p_confirm"; + echo 'Cochez la case si vous êtes sûr de vouloir effacer ce modèle'; + echo $confirm->input(); + echo HtmlInput::submit('remove', 'Effacer'); + echo HtmlInput::button_anchor('Retour', '?action=modele_mgt'); + echo '</form>'; + } + //--------------------------------------------------------------------------- + // action = del + //--------------------------------------------------------------------------- + if ($sa == 'remove') + { + if (!isset($_REQUEST['p_confirm'])) + { + echo('Désolé, vous n\'avez pas coché la case'); + echo HtmlInput::button_anchor('Retour', '?action=modele_mgt'); + exit(); + } - $cn=new Database(); - $msg="dossier"; - $name=$cn->get_value("select mod_name from modeledef where mod_id=$1",array($_REQUEST['m'])); - if ( strlen(trim($name)) == 0 ) - { - echo "<h2 class=\"error\"> $msg inexistant</h2>"; - exit(); - } - $sql="drop database ".domaine."mod".sql_string($_REQUEST['m']); - ob_start(); - if ( $cn->exec_sql($sql)==false) - { - ob_end_clean(); + $cn = new Database(); + $msg = "dossier"; + $name = $cn->get_value("select mod_name from modeledef where mod_id=$1", array($_REQUEST['m'])); + if (strlen(trim($name)) == 0) + { + echo "<h2 class=\"error\"> $msg inexistant</h2>"; + exit(); + } + $sql = "drop database " . domaine . "mod" . sql_string($_REQUEST['m']); + ob_start(); + if ($cn->exec_sql($sql) == false) + { + ob_end_clean(); - echo "<h2 class=\"error\"> - Base de donnée ".domaine."mod".$_REQUEST['m']." est accèdée, déconnectez-vous d'abord</h2>"; - exit; - } - ob_flush(); - $sql="delete from modeledef where mod_id=$1"; - $cn->exec_sql($sql,array($_REQUEST['m'])); - print '<h2 class="info">'; - print "Voilà le modèle $name est effacé</H2>"; - echo HtmlInput::button_anchor('Retour','?action=modele_mgt'); - } - echo '</div>'; -?> + echo "<h2 class=\"error\"> + Base de donnée " . domaine . "mod" . $_REQUEST['m'] . " est accèdée, déconnectez-vous d'abord</h2>"; + exit; + } + ob_flush(); + $sql = "delete from modeledef where mod_id=$1"; + $cn->exec_sql($sql, array($_REQUEST['m'])); + print '<h2 class="info">'; + print "Voilà le modèle $name est effacé</H2>"; + echo HtmlInput::button_anchor('Retour', '?action=modele_mgt'); + } + echo '</div>'; + ?> _______________________________________________ Phpcompta-dev mailing list [email protected] https://lists.nongnu.org/mailman/listinfo/phpcompta-dev
