phpDocumentor VFront
Administration
[ class tree: VFront ] [ index: VFront ] [ all elements ]
VFront
Packages:
VFront

Source for file gestione_tabelle_gruppi.php

Documentation is available at gestione_tabelle_gruppi.php

  1. <?php
  2. /**
  3.  * Sono qui presenti le procedure fondamentali per la gestione del registro di VFront.
  4.  * Il file è organizzato per aree e svolge numerose funzioni
  5.  * 
  6.  * @desc File per la gestione del registro di VFront
  7.  * @package VFront
  8.  * @subpackage Administration
  9.  * @author M.Marcello Verona
  10.  * @copyright 2007 M.Marcello Verona
  11.  * @version 0.90
  12.  * @see gestione_registro.inc.php
  13.  * @license http://www.gnu.org/licenses/gpl.html GNU Public License
  14.  */
  15.  
  16.  
  17.  
  18. include("../inc/conn.php");
  19. include("../inc/layouts.php");
  20. include("../inc/func.comuni.php");
  21. include("../inc/func.tratta_campo.php");
  22. include("../inc/func.frontend.php");
  23.  
  24. proteggi(3);
  25.  
  26. if(isset($_GET['conf_sub'])){
  27.     
  28.     include("../inc/func.tratta_campo_submask.php");
  29. }
  30.  
  31.  
  32.  
  33. if(!isset($GLOBALS['_VARIABILI'])){
  34.     
  35.     
  36.     include("../inc/func.var_frontend.php");
  37.     
  38.     var_frontend();
  39. }
  40.  
  41. ###############################################################################################
  42. #
  43. #        Da qui mostra le impostazioni della tabella
  44. #        Con richiamo di funzione esterna per ogna campo.
  45. #
  46. ###############################################################################################
  47.  
  48.  
  49.  
  50.  
  51.  
  52.  
  53.  
  54.  
  55.  
  56.  
  57.  
  58. /**
  59.  * Da qui è possibile accedere alle impostazioni delle tabelle e eseguire operazioni rapide
  60.  * sulla loro configurazione
  61.  * 
  62.  * @desc Genera il menu delle tabelle
  63.  * @param unknown_type $gid 
  64.  * @param unknown_type $order 
  65.  */
  66. function tab_menu($gid=0,$order='table_name'){
  67.     
  68.     global $link,$db1;
  69.     
  70.     
  71.     switch($order){
  72.         case 0: $order = "table_name"; break;
  73.         case 1: $order = "data_modifica"; break;
  74.         case 2: $order = "visibile"; break;
  75.         case 3: $order = "id_table"; break;
  76.         case 4: $order = "commento"; break;
  77.         case 5: $order = "in_insert"; break;
  78.         case 6: $order = "in_update"; break;
  79.         case 7: $order = "in_delete"; break;
  80.         case 8: $order = "n_sottomaschere"; break;
  81.         default: $order = 'table_name'; 
  82.     }
  83.     
  84.     if(isset($_GET['sort'])){
  85.         
  86.         $sort = ($_GET['sort']=="d") ?  "DESC" : "ASC";
  87.     }
  88.     else{
  89.         $sort = "ASC";
  90.     }
  91.     
  92.     // Richiama tutte le tabelle dati
  93.     $sql_tab = "SELECT t.table_name,  t.visibile,  t.in_insert,  t.in_update, 
  94.                  t.in_delete,  t.data_modifica,   t.id_table,  t.commento , t.table_type
  95.                 , (SELECT count(*) FROM {$db1['frontend']}.registro_submask s WHERE s.id_table=t.id_table) as n_sottomaschere
  96.                 FROM {$db1['frontend']}.registro_tab t
  97.                 WHERE gid=$gid
  98.                 ORDER BY t.table_type,  $order $sort ";
  99.     $q_tab= vmsql_query($sql_tab,$link);
  100.     $matrice_tab = vmsql_fetch_assoc_all($q_tab);
  101.  
  102.  
  103.     echo openLayout1("Amministrazione Tabelle",array("sty/admin.css","js/mostra_nascondi_id.js"));
  104.  
  105.     
  106.     
  107.     echo "<div id=\"briciole\"><a href=\"index.php\">home amministrazione</a> &raquo; <a href=\"menu_registri.php\">menu gruppi/registri</a> &raquo; </div>";
  108.     
  109.     echo "<h1>Regole Tabelle gruppo <span class=\"var\">$gid::".gid2nome_gruppo($gid)."</span></h1>\n";
  110.     
  111.  
  112.     #############################################
  113.     #
  114.     #
  115.     #    FUNZIONI RAPIDE
  116.     #
  117.     #
  118.     
  119.     echo "<div style=\"padding:5px 0 20px 0;\"><a href=\"javascript:;\" onclick=\"mostra_nascondi('tab-menu-rapide');\">Funzioni rapide</a></div>\n";
  120.     
  121.     echo "
  122.     
  123.         <div id=\"tab-menu-rapide\"  style=\"display:none\">
  124.             <fieldset style=\"padding:10px;margin:10px;width:85%;\">
  125.                 <legend>Impostazioni rapide</legend>
  126.                 <p><strong>Visibilit&agrave; (SELECT)</strong>
  127.                     <a href=\"?gid=$gid&amp;mass=visibile_all\">Permetti a tutte le tabelle</a> | 
  128.                     <a href=\"?gid=$gid&amp;mass=visibile_none\">Nega a tutte le tabelle</a></p>
  129.                 <p><strong>Inserimento (INSERT)</strong>
  130.                 <a href=\"?gid=$gid&amp;mass=insert_all\">Permetti in tutte le tabelle</a> | 
  131.                     <a href=\"?gid=$gid&amp;mass=insert_none\">Nega in tutte le tabelle</a></p>
  132.                 <p><strong>Modifica (UPDATE)</strong>
  133.                 <a href=\"?gid=$gid&amp;mass=update_all\">Permetti in tutte le tabelle</a> | 
  134.                     <a href=\"?gid=$gid&amp;mass=update_none\">Nega in tutte le tabelle</a></p>
  135.                 <p><strong>Elimina (DELETE)</strong>
  136.                 <a href=\"?gid=$gid&amp;mass=delete_all\">Permetti in tutte le tabelle</a> | 
  137.                     <a href=\"?gid=$gid&amp;mass=delete_none\">Nega in tutte le tabelle</a>
  138.                 </p>
  139.             </fieldset>
  140.             <br/>
  141.             <br/>
  142.         </div>
  143.         ";
  144.     
  145.     
  146.     
  147.     
  148.     echo "<table summary=\"tabelle db per utenti\" id=\"tab-tabelle\" >\n";
  149.     
  150.     $c=0;
  151.     
  152.     
  153.     echo "\t<tr>\n";
  154.     
  155.     echo "\t\t<th>".table_sort('visibile',2,'Impostazione di visibili&agrave; della tabella')."</th>\n";
  156.     echo "\t\t<th>".table_sort('tabella',0,'Nome della tabella')."</th>\n";
  157.     echo "\t\t<th>".table_sort('ultimo settaggio',1,'Data dell\'ultima impostazione per questa tabella')."</th>\n";
  158.     echo "\t\t<th>".table_sort('sottomaschere',8,'numero di sottomaschere impostate per la tabella')."</th>\n";
  159.     echo "\t\t<th>".table_sort('commento',4,'Commento di tabella')."</th>\n";
  160.     echo "\t\t<th>".table_sort('insert',5,'Possibilit&agrave; di inserimento dati per questa tabella da parte di questo gruppo')."</th>\n";
  161.     echo "\t\t<th>".table_sort('update',6,'Possibilit&agrave; di modifica dei dati per questa tabella da parte di questo gruppo')."</th>\n";
  162.     echo "\t\t<th>".table_sort('delete',7,'Possibilit&agrave; di cancellazione dei dati per questa tabella da parte di questo gruppo')."</th>\n";
  163.     
  164.     
  165.     echo "\t</tr>\n";
  166.     
  167.     $inizia_vista=true;
  168.     
  169.     foreach($matrice_tab as $tab){
  170.         
  171.         $colore=(($c%2)==0) ? "c1":"c2";
  172.         $c++;
  173.         
  174.         if($tab['data_modifica']>0) {
  175.             $data_mod = date("Y-m-d H:i",$tab['data_modifica']);
  176.             $color_href="";
  177.             $title_href='';
  178.         }
  179.         else{
  180.             $data_mod = "-";
  181.             $color_href=" class=\"dafare\"";
  182.             $title_href='title="Questa tabella non &egrave; stata ancora configurata"';
  183.         }
  184.         
  185.          $n_sottomaschere = ($tab['n_sottomaschere']>0) ? "<strong>".$tab['n_sottomaschere']."</strong>" : "<span class=\"grigio\">".$tab['n_sottomaschere']."</span>";
  186.         
  187.          
  188.          // SEPARATORE PER LE VISTE
  189.          
  190.          if($tab['table_type']=='VIEW' && $inizia_vista==true){
  191.              
  192.              echo "\t\t<tr class=\"separatore\" style=\"padding-top:50px;margin-top:10px;\">
  193.                  <td colspan=\"7\"><hr /><h2>Viste sulle tabelle</h2></td>
  194.                  </tr>\n";
  195.              
  196.              $inizia_vista=false;
  197.          }
  198.          
  199.          
  200.          
  201.         echo "\t\t<tr class=\"$colore\">
  202.                 <td>".high_si_no($tab['visibile'])."</td>
  203.                 
  204.                 <td><a $title_href $color_href href=\"".$_SERVER['PHP_SELF']."?det=".$tab['id_table']."&amp;gid=$gid\">".$tab['table_name']."</a></td>
  205.                 <td>".$data_mod."</td>
  206.                 <td>".$n_sottomaschere."</td>
  207.                 <td>".htmlentities($tab['commento'],ENT_QUOTES)."</td>
  208.                 <td>".high_si_no($tab['in_insert'])."</td>
  209.                 <td>".high_si_no($tab['in_update'])."</td>
  210.                 <td>".high_si_no($tab['in_delete'])."</td>
  211.             </tr>\n";
  212.     }
  213.     
  214.     echo "</table>\n";
  215.  
  216.     echo closeLayout1();
  217.  
  218. }
  219.  
  220.  
  221.  
  222.  
  223.  
  224.  
  225. /**
  226.  * Genera il menu delle sottomaschere
  227.  *
  228.  * @param int $oid 
  229.  * @param int $order 
  230.  */
  231. function submask_menu($oid=0,$order='nome_tabella'){
  232.     
  233.     global $link,$db1;
  234.     
  235.     
  236.     switch($order){
  237.         case 0: $order = "nome_tabella"; break;
  238.         case 1: $order = "data_modifica"; break;
  239.         case 2: $order = "sub_select"; break;
  240.         case 3: $order = "sub_insert"; break;
  241.         case 4: $order = "sub_update"; break;
  242.         case 5: $order = "sub_delete"; break;
  243.         default: $order = 'nome_tabella'; 
  244.     }
  245.     
  246.     if(isset($_GET['sort'])){
  247.         
  248.         $sort = ($_GET['sort']=="d") ?  "DESC" : "ASC";
  249.     }
  250.     else{
  251.         $sort = "ASC";
  252.     }
  253.     
  254.     // Richiama tutte le tabelle dati
  255.     $sql_tab = "SELECT id_submask,sub_select,sub_insert,sub_update,sub_delete,nome_tabella,
  256.                     campo_pk_parent,campo_fk_sub,orderby_sub,orderby_sub_sort,data_modifica
  257.                 FROM {$db1['frontend']}.registro_submask
  258.                 WHERE id_table=$oid
  259.                 ORDER BY $order $sort ";
  260.     $q_tab= vmsql_query($sql_tab,$link);
  261.     $matrice_tab = vmsql_fetch_assoc_all($q_tab);
  262.  
  263.  
  264.         
  265.     echo "<h2>Regole sottomaschere della tabella <span class=\"var\">".oid2name($oid)."</span></h2>\n";
  266.     
  267.  
  268.     echo "<table summary=\"sottomaschere tabelle\" id=\"tab-sub-tabelle\" >\n";
  269.     
  270.     $c=0;
  271.     
  272.     
  273.     echo "\t<tr>\n";
  274.     
  275.     echo "\t\t<th height=\"20\"><span class=\"help\" title=\"Impostazione di visibili&agrave; della tabella\">visibile</span></th>\n";
  276.     echo "\t\t<th><span class=\"help\" title=\"Nome della tabella\">tabella</span></th>\n";
  277.     echo "\t\t<th><span class=\"help\" title=\"Data dell'ultima impostazione per questa sottomaschera\">ultimo settaggio</span></th>\n";
  278.     echo "\t\t<th><span class=\"help\" title=\"Possibilit&agrave; di inserimento dati da questa sottomaschera da parte di questo gruppo\">insert</span></th>\n";
  279.     echo "\t\t<th><span class=\"help\" title=\"Possibilit&agrave; di modifica dei dati da questa sottomaschera da parte di questo gruppo\">update</span></th>\n";
  280.     echo "\t\t<th><span class=\"help\" title=\"Possibilit&agrave; di cancellazione dei dati da questa sottomaschera da parte di questo gruppo\">delete</span></th>\n";
  281.     echo "\t\t<th>&nbsp;</th>\n";
  282.     
  283.     echo "\t</tr>\n";
  284.     
  285.     
  286.     foreach($matrice_tab as $tab){
  287.         
  288.         $colore=(($c%2)==0) ? "c1":"c2";
  289.         $c++;
  290.         
  291.         if($tab['data_modifica']>0) {
  292.             $data_mod = date("Y-m-d H:i",$tab['data_modifica']);
  293.             $color_href="";
  294.             $title_href='';
  295.         }
  296.         else{
  297.             $data_mod = "-";
  298.             $color_href=" class=\"dafare\"";
  299.             $title_href='title="Questa sottomaschera non &egrave; stata ancora configurata"';
  300.         }
  301.         
  302.         echo "\t\t<tr class=\"$colore\">
  303.                 <td>".high_si_no($tab['sub_select'])."</td>
  304.                 
  305.                 <td><a $title_href $color_href href=\"".$_SERVER['PHP_SELF']."?det=$oid&amp;conf_sub=".$tab['id_submask']."&amp;a=3&amp;gid=".$_GET['gid']."\">".$tab['nome_tabella']."</a></td>
  306.                 <td>".$data_mod."</td>
  307.                 <td>".high_si_no($tab['sub_insert'])."</td>
  308.                 <td>".high_si_no($tab['sub_update'])."</td>
  309.                 <td>".high_si_no($tab['sub_delete'])."</td>
  310.                 <td><a href=\"javascript:;\" onclick=\"if(confirm('Sei sicuro di eliminare questa sottomaschera e le sue impostazioni?\\nL\'operazione non pu� essere annullata')){document.getElementById('id_submask').value='".$tab['id_submask']."';document.forms.elimina_submask.submit();}\">Elimina</a></td>
  311.             </tr>\n";
  312.     }
  313.     
  314.     echo "</table>\n";
  315.     
  316.     echo "<form method=\"post\" action=\"".$_SERVER['PHP_SELF']."?elimina_submask\" id=\"elimina_submask\" name=\"elimina_submask\" style=\"display:none;\">
  317.     
  318.         <input type=\"hidden\" name=\"id_del_submask\" id=\"id_submask\" value=\"0\" />
  319.         <input type=\"hidden\" name=\"oid\" value=\"$oid\" />
  320.         <input type=\"hidden\" name=\"gid\" value=\"$gid\" />
  321.         
  322.         </form>
  323.         ";
  324.  
  325.     
  326. }
  327.  
  328.  
  329.  
  330.  
  331.  
  332. /**
  333.  * Mostra la linguetta di dettaglio dei campi per l'amministrazione delle tabelle
  334.  * 
  335.  * @desc Dettaglio per le tabelle
  336.  * @param int $oid 
  337.  * @param int $gid 
  338.  */
  339. function tab_dett($oid,$gid=0){
  340.     
  341.     global $link,$db1;
  342.     
  343.     
  344.     $oid= (int) $oid;
  345.     
  346.     $gid= (int) $gid;
  347.     
  348.     
  349.     # Vedi se è tabella o vista
  350.     $q_tipo=vmsql_query("SELECT table_type FROM {$db1['frontend']}.registro_tab WHERE id_table=$oid",$link);
  351.     list($tipo_tab) = vmsql_fetch_row($q_tipo);
  352.     
  353.     
  354.     # Info tabella e PK
  355.     
  356.     if($tipo_tab=='VIEW'){
  357.         
  358.         $sql_tab = "SELECT rb.*, view_pk as campo_pk 
  359.                     FROM {$db1['frontend']}.registro_tab rb 
  360.                     WHERE rb.id_table=$oid
  361.                     ";
  362.         
  363.     }else{
  364.     
  365.         $sql_tab = "SELECT rb.*, i.column_name as campo_pk 
  366.                     FROM {$db1['frontend']}.registro_tab rb 
  367.                     LEFT JOIN information_schema.key_column_usage i ON (i.table_name=rb.table_name AND i.table_schema='{$db1['dbname']}')
  368.                     
  369.                     WHERE rb.id_table=$oid
  370.                     ";
  371.     }
  372.     
  373.     
  374.     $q_tab=vmsql_query($sql_tab,$link);
  375.     
  376.     $info=vmsql_fetch_assoc($q_tab);
  377.     
  378.     $info['campo_pk']=str_replace(array("(",")"),"",$info['campo_pk']);
  379.     
  380.     $array_pk=explode(",",$info['campo_pk']);
  381.     foreach ($array_pk as $k=>$val){
  382.         $array_pk[$k]=trim($val);
  383.     }
  384.     
  385.  
  386.     
  387.     # Prende le FK
  388.     # Individua i campi coinvolti in una relazione esterna e tabella.campo a cui ï¿½ legato
  389.  
  390.  
  391.     list($array_fk,$colref_fk)=prendi_FK($oid);
  392.     
  393.     
  394.     # Inizia a prendere i campi
  395.     
  396.     
  397.     $sql_cols = "SELECT  id_reg,
  398.                         id_table,
  399.                         column_name,
  400.                         column_default,
  401.                         is_nullable,
  402.                         data_type,
  403.                         character_maximum_length,
  404.                         column_type,
  405.                         extra,
  406.                         in_tipo,
  407.                         in_default,
  408.                         in_visibile,
  409.                         in_richiesto,
  410.                         in_search,
  411.                         in_suggest,
  412.                         in_table,
  413.                         jstest,
  414.                         commento
  415.                         
  416.                         
  417.                         FROM {$db1['frontend']}.registro_col 
  418.                         WHERE id_table=$oid 
  419.                         ORDER BY ordinal_position";
  420.     
  421.     $q_cols=vmsql_query($sql_cols,$link);
  422.     
  423.     $matrice_col=vmsql_fetch_assoc_all($q_cols);
  424.     
  425.     $matrice_rev=vmsql_reverse_matrix($matrice_col);
  426.     
  427.     
  428.     // INFO GENERALI PER LA TABELLA
  429.     
  430.     $def['visibile']= ($info['visibile']=="1" || $info['visibile']=="t") ? "checked=\"checked\" " : "";
  431.     $def['in_insert']= ($info['in_insert']=="1" || $info['in_insert']=="t") ? "checked=\"checked\" " : "";
  432.     $def['in_duplica']= ($info['in_duplica']=="1" || $info['in_duplica']=="t") ? "checked=\"checked\" " : "";
  433.     $def['in_update']= ($info['in_update']=="1" || $info['in_update']=="t") ? "checked=\"checked\" " : "";
  434.     $def['in_delete']= ($info['in_delete']=="1" || $info['in_delete']=="t") ? "checked=\"checked\" " : "";
  435.     $def['in_export']= ($info['in_export']=="1" || $info['in_delete']=="t") ? "checked=\"checked\" " : "";
  436.     $def['permetti_allegati']= ($info['permetti_allegati']=="1" || $info['permetti_allegati']=="t" ) ? "checked=\"checked\" " : "";
  437.     $def['permetti_allegati_display']= ($info['permetti_allegati']=="1" || $info['permetti_allegati']=="t") ? "" : "none";
  438.     
  439.     $def['permetti_link']= ($info['permetti_link']=="1" || $info['permetti_link']=="t") ? "checked=\"checked\" " : "";
  440.     $def['permetti_link_display']= ($info['permetti_link']=="1" || $info['permetti_link']=="t") ? "" : "none";
  441.     
  442.     $def['permetti_allegati_ins']= ($info['permetti_allegati_ins']=="1" || $info['permetti_allegati_ins']=="t") ? "checked=\"checked\" " : "";
  443.     $def['permetti_allegati_del']= ($info['permetti_allegati_del']=="1" || $info['permetti_allegati_del']=="t") ? "checked=\"checked\" " : "";
  444.         
  445.     $def['permetti_link_ins']= ($info['permetti_link_ins']=="1" || $info['permetti_link_ins']=="t") ? "checked=\"checked\" " : "";
  446.     $def['permetti_link_del']= ($info['permetti_link_del']=="1" || $info['permetti_link_del']=="t") ? "checked=\"checked\" " : "";
  447.     
  448.     
  449.     
  450.     
  451.     
  452.     ###############################################
  453.     #
  454.     #    Inizia a stampare
  455.     #
  456.     
  457.     $files= array("sty/admin.css","js/mostra_hid.js","js/mostra_nascondi_id.js", 
  458.                     "js/test_query.js","sty/linguette.css","js/open_window.js"); //,"js/test_campi.js"); 
  459.     
  460.     $files[]="js/scriptaculous/lib/prototype.js";
  461. //    $files[]="js/prototype-1.4.0.js";
  462.     $files[]="js/scriptaculous/src/scriptaculous.js";
  463.     
  464.     echo openLayout1("Amministrazione tabella",$files);
  465.     
  466.  
  467.     
  468.     echo "<div id=\"briciole\"><a href=\"index.php\">home amministrazione</a> &raquo; <a href=\"menu_registri.php\">menu gruppi/registri</a> &raquo; <a href=\"gestione_tabelle_gruppi.php?gid=$gid\">impostazioni registro id $gid</a> &raquo; </div>";
  469.     
  470.     if($info['table_type']=='VIEW'){
  471.         echo "<h1>Impostazioni vista <span class=\"verde\">".$info['table_name']."</span> per <span class=\"verde\">".$gid."</span><span class=\"grigio\">::</span><span class=\"verde\">".gid2nome_gruppo($gid)."</span></h1>\n";
  472.     }
  473.     else{
  474.         echo "<h1>Impostazioni tabella <span class=\"var\">".$info['table_name']."</span> per <span class=\"var\">".$gid."</span><span class=\"grigio\">::</span><span class=\"var\">".gid2nome_gruppo($gid)."</span></h1>\n";
  475.     }
  476.     
  477.     
  478.     // Feedback
  479.     if(isset($_GET['feed'])){
  480.         switch($_GET['feed']){
  481.             
  482.             case 'ok_gen': $feed_str="<p class=\"feed-mod-ok\">Impostazioni generali modificate correttamente</p>\n";
  483.             break;
  484.             
  485.             case 'ok_gen_trasversale': $feed_str="<p class=\"feed-mod-ok\">Impostazioni generali per tutti i gruppi modificate correttamente</p>\n";
  486.             break;
  487.             
  488.             case 'ko_gen': $feed_str="<p class=\"feed-mod-ko\">Errore nella modifica delle impostazioni generali</p>\n";
  489.             break;            
  490.             
  491.             case 'ok_campi': $feed_str="<p class=\"feed-mod-ok\">Impostazioni dei campi modificate correttamente</p>\n";
  492.             break;
  493.             
  494.             case 'ko_campi': $feed_str="<p class=\"feed-mod-ko\">Nessuna modifica delle impostazioni dei campi</p>\n";
  495.             break;    
  496.                     
  497.             case 'ok_sub_upd': $feed_str="<p class=\"feed-mod-ok\">Impostazioni della sottomaschera modificate correttamente</p>\n";
  498.             break;
  499.             
  500.             case 'ko_sub_upd': $feed_str="<p class=\"feed-mod-ko\">Nessuna modifica delle impostazioni della sottomaschera</p>\n";
  501.             break;
  502.             
  503.             default: $feed_str="";
  504.         }
  505.         
  506.         echo $feed_str;
  507.     }
  508.     
  509.     
  510.     
  511.     if(!isset($_GET['a']) || $_GET['a']=='1'){
  512.         
  513.         $attiva = 'tabella-gen';
  514.         
  515.         $classe_eti['gen']='attiva';
  516.         $classe_eti['campi']='disattiva';
  517.         $classe_eti['mask']='disattiva';
  518.         $classe_eti['campisort']='disattiva';
  519.             
  520.         
  521.     }
  522.     else if($_GET['a']=='2'){
  523.         
  524.         $attiva = 'tabella-campi';
  525.         
  526.         $classe_eti['gen']='disattiva';
  527.         $classe_eti['campi']='attiva';
  528.         $classe_eti['mask']='disattiva';
  529.         $classe_eti['campisort']='disattiva';
  530.         
  531.         
  532.     }else if($_GET['a']=='3'){
  533.         
  534.         $attiva = 'tabella-sottomaschere';
  535.         
  536.         $classe_eti['gen']='disattiva';
  537.         $classe_eti['campi']='disattiva';
  538.         $classe_eti['mask']='attiva';
  539.         $classe_eti['campisort']='disattiva';
  540.     }
  541.     else if($_GET['a']=='4'){
  542.         
  543.         $attiva = 'campi-sort';
  544.         
  545.         $classe_eti['gen']='disattiva';
  546.         $classe_eti['campi']='disattiva';
  547.         $classe_eti['mask']='disattiva';
  548.         $classe_eti['campisort']='attiva';
  549.     }
  550.     
  551.     
  552.     ?>
  553.     
  554.     
  555.     <script type="text/javascript">
  556.         // <!-- 
  557.     
  558.         var divs = new Array('tabella-gen','tabella-campi','campi-sort','tabella-sottomaschere');
  559.     
  560.         var attiva = '<?php echo $attiva;?>';
  561.         
  562.         function eti(ido){
  563.             
  564.             for (i=0;i<divs.length;i++){
  565.                 document.getElementById(divs[i]).style.display='none';
  566.                 document.getElementById('li-'+divs[i]).className='disattiva';
  567.             }
  568.             
  569.             // attiva il selezionato
  570.             document.getElementById(ido).style.display='';
  571.             document.getElementById('li-'+ido).className='attiva';
  572.             
  573.         }
  574.     
  575.         // -->
  576.     </script>
  577.     
  578.     <?php
  579.     
  580.     
  581.     
  582.     // Apre il box etichette
  583.     
  584.     // attiva disattiva
  585.     
  586.     
  587.     
  588.     echo 
  589.     "<div id=\"box-etichette\">
  590.         
  591.         <ul class=\"eti-var-gr\">
  592.             <li onclick=\"eti('tabella-gen');\" id=\"li-tabella-gen\" class=\"{$classe_eti['gen']}\" >Impostazioni generali</li>
  593.             <li onclick=\"eti('tabella-campi');\" id=\"li-tabella-campi\" class=\"{$classe_eti['campi']}\" >Impostazioni campi</li>
  594.             <li onclick=\"eti('campi-sort');\" id=\"li-campi-sort\" class=\"{$classe_eti['campisort']}\" >Ordine campi</li>
  595.             <li onclick=\"eti('tabella-sottomaschere');\" id=\"li-tabella-sottomaschere\" class=\"{$classe_eti['mask']}\" >Impostazioni sottomaschere</li>
  596.         </ul>
  597.     </div>
  598.         ";
  599.     
  600.     
  601.     
  602.     // CAMPI TABELLA:
  603.     list($campi_tabella) = prendi_colonne_frontend($oid,"column_name",false);
  604.     
  605.     
  606.     ##############################################################
  607.     #
  608.     #     FORM IMPOSTAZIONI GENERALI
  609.     #
  610.     #
  611.     #
  612.     
  613.     
  614.     
  615.     $st_gen = (!isset($_GET['a']) || $_GET['a']==1) ? "" : "display:none;"; 
  616.     
  617.     echo "
  618.     
  619.     <div class=\"tabella-gen\" id=\"tabella-gen\" style=\"$st_gen\" >
  620.     
  621.     <form action=\"".$_SERVER['PHP_SELF']."\" method=\"post\">
  622.     
  623.     
  624.     
  625.         <label for=\"orderby\">Ordina per:</label>
  626.         <select name=\"orderby\" id=\"orderby\" >
  627.         ";
  628.     
  629.         while(list(,$name) = each($matrice_rev['column_name'])){
  630.             
  631.             $sel = ($name==$info['orderby']) ? "selected=\"selected\"" : "";
  632.             
  633.             // se ï¿½ anche chiave primaria, scrivilo
  634.             $pk = ($name==$info['campo_pk'])? " (chiave primaria)" : "";
  635.             
  636.             echo "\t\t<option value=\"$name\" $sel >$name $pk</option>\n";        
  637.         }
  638.         
  639.     echo "
  640.         </select>
  641.         ";
  642.     
  643.     $sel_sort['ASC'] = ($info['orderby_sort']=='ASC') ? "selected=\"selected\"" : "";
  644.     $sel_sort['DESC'] = ($info['orderby_sort']=='DESC') ? "selected=\"selected\"" : "";
  645.         
  646.         echo "
  647.         <select name=\"orderby_sort\" id=\"orderby_sort\" >
  648.             <option value=\"ASC\" ".$sel_sort['ASC'].">Ascendente</option>
  649.             <option value=\"DESC\" ".$sel_sort['DESC'].">Discendente</option>
  650.         </select>
  651.         
  652.         <div class=\"info-campo\">Campo secondo il quale saranno ordinati per default i dati della tabella</div>
  653.         
  654.         <input type=\"hidden\" name=\"visibile\" id=\"visibile-hid\" value=\"0\" />
  655.         <input type=\"checkbox\" name=\"visibile\" id=\"visibile\" value=\"1\" ".$def['visibile']."/>
  656.         <label for=\"visibile\">Tabella visibile</label>
  657.         <div class=\"info-campo\">Imposta se la tabella deve essere visibile per questo gruppo</div>
  658.         
  659.         ";
  660.         
  661.         if($info['table_type']=='VIEW'){
  662.             
  663.             
  664.             /*echo "
  665.             <input type=\"hidden\" name=\"in_insert\" id=\"in_insert-hid\" value=\"0\" />
  666.             <input type=\"checkbox\" name=\"in_insert\" id=\"in_insert\" value=\"0\"  disabled=\"disabled\" />
  667.             <label for=\"in_insert\">Inserisci record (INSERT)</label>
  668.             <div class=\"info-campo\">Disabilitato in quanto vista</div>
  669.             ";*/
  670.             echo "
  671.             <input type=\"hidden\" name=\"in_insert\" id=\"in_insert-hid\" value=\"0\" />
  672.             <input type=\"checkbox\" name=\"in_insert\" id=\"in_insert\" value=\"1\"  ".$def['in_insert']." />
  673.             <label for=\"in_insert\">Inserisci record (INSERT)</label>
  674.             <div class=\"info-campo\">Permetti a questo gruppo di inserire nuovi record</div>
  675.             ";
  676.             
  677.             // IMPOSTAZIONI PER LA MODIFICABILTA' DEI DATI NELLA VISTA (prese dalla definizione della vista stessa)
  678.             $view_up=prendi_info_view($info['table_name'],'IS_UPDATABLE');
  679.             
  680.             if($view_up['IS_UPDATABLE']=='YES'){
  681.                 
  682.                 echo "
  683.             
  684.             <input type=\"hidden\" name=\"in_update\" id=\"in_update-hid\" value=\"0\" />
  685.             <input type=\"checkbox\" name=\"in_update\" id=\"in_update\"  value=\"1\" ".$def['in_update']." />
  686.             <label for=\"in_update\">Modifica i record (UPDATE)</label>
  687.             <div class=\"info-campo\">Permetti a questo gruppo di modificare record esistenti</div>
  688.             
  689.                 ";
  690.             }
  691.             else{
  692.                 echo "
  693.                 
  694.                 <input type=\"hidden\" name=\"in_update\" id=\"in_update-hid\" value=\"0\" />
  695.                 <input type=\"checkbox\" name=\"in_update\" id=\"in_update\" value=\"0\"  disabled=\"disabled\" />
  696.                 <label for=\"in_update\">Modifica i record (UPDATE)</label>
  697.                 <div class=\"info-campo\">Disabilitato in quanto vista</div>
  698.                 
  699.                 ";
  700.             }
  701.             
  702.             
  703.             // PRENDE LA DEFINIZIONE VISTA E CERACA JOIN PER IMPOSTARE IL DELETE SI|NO
  704.             if($db1['dbtype']=='mysql'){
  705.                 
  706.                 $q_join=vmsql_query("SHOW CREATE VIEW ".$info['table_name'],$link);
  707.                 list($trash,$show_create)=vmsql_fetch_row($q_join);
  708.             }
  709.             
  710.             else if ($db1['dbtype']=='postgres'){
  711.                 
  712.                 $q_join=vmsql_query("SELECT view_definition 
  713.                                     FROM information_schema.views
  714.                                     WHERE table_name='".$info['table_name']."'
  715.                                     AND table_catalog='".$db1['postgres_dbname']."'
  716.                                     AND table_schema='".$db1['dbname']."'",$link);
  717.                 list($show_create)=vmsql_fetch_row($q_join);
  718.                 
  719.             }
  720.             
  721.             $JOIN=(eregi(' JOIN ',$show_create)) ? true:false;
  722.                 
  723.                 
  724.             if($JOIN){
  725.                 echo "
  726.                 
  727.                 <input type=\"hidden\" name=\"in_delete\" id=\"in_delete-hid\" value=\"0\" />
  728.                 <input type=\"checkbox\" name=\"in_delete\" id=\"in_delete\" value=\"0\"  disabled=\"disabled\" />
  729.                 <label for=\"in_delete\">Elimina i record (DELETE)</label>
  730.                 <div class=\"info-campo\">Disabilitato in quanto vista con JOIN</div>
  731.                 ";
  732.             }
  733.             else{
  734.                 
  735.                 echo "
  736.                 
  737.                 <input type=\"hidden\" name=\"in_delete\" id=\"in_delete-hid\" value=\"0\" />
  738.                 <input type=\"checkbox\" name=\"in_delete\" id=\"in_delete\" value=\"1\" ".$def['in_delete']." />
  739.                 <label for=\"in_delete\">Elimina i record (DELETE)</label>
  740.                 <div class=\"info-campo\">Permetti a questo gruppo di eliminare record</div>
  741.                 ";
  742.             }
  743.         
  744.         
  745.         }
  746.         // SE invece la tabella ï¿½ una normale BASE TABLE
  747.         else{
  748.             
  749.                 echo "
  750.             <input type=\"hidden\" name=\"in_insert\" id=\"in_insert-hid\" value=\"0\" />
  751.             <input type=\"checkbox\" name=\"in_insert\" id=\"in_insert\" value=\"1\" ".$def['in_insert']." onclick=\"if(this.checked){\$('cont-duplica').style.display='';} else {\$('cont-duplica').style.display='none';}\" />
  752.             <label for=\"in_insert\">Inserisci record (INSERT)</label>
  753.             <div class=\"info-campo\">Permetti a questo gruppo di inserire nuovi record</div>
  754.             ";
  755.                 
  756.             if($def['in_insert']=='') $style_duplica="display:none;";
  757.                 
  758.             echo "
  759.             <div id=\"cont-duplica\" style=\"margin-left:40px;$style_duplica\">
  760.                 <input type=\"hidden\" name=\"in_duplica\" id=\"in_duplica-hid\" value=\"0\" />
  761.                 <input type=\"checkbox\" name=\"in_duplica\" id=\"in_duplica\" value=\"1\" ".$def['in_duplica']."/>
  762.                 <label for=\"in_duplica\">Duplica record (dipende da INSERT)</label>
  763.                 <div class=\"info-campo\">Permetti a questo gruppo di creare nuovi record duplicando un record esistente</div>
  764.             </div>
  765.             ";
  766.             
  767.             echo "
  768.             <input type=\"hidden\" name=\"in_update\" id=\"in_update-hid\" value=\"0\" />
  769.             <input type=\"checkbox\" name=\"in_update\" id=\"in_update\" value=\"1\" ".$def['in_update']."/>
  770.             <label for=\"in_update\">Modifica i record (UPDATE)</label>
  771.             <div class=\"info-campo\">Permetti a questo gruppo di modificare record esistenti</div>
  772.             
  773.             <input type=\"hidden\" name=\"in_delete\" id=\"in_delete-hid\" value=\"0\" />
  774.             <input type=\"checkbox\" name=\"in_delete\" id=\"in_delete\" value=\"1\" ".$def['in_delete']."/>
  775.             <label for=\"in_delete\">Elimina i record (DELETE)</label>
  776.             <div class=\"info-campo\">Permetti a questo gruppo di eliminare i record</div>
  777.             
  778.             
  779.             ";
  780.         }
  781.         
  782.         echo "
  783.         
  784.         <input type=\"hidden\" name=\"in_export\" id=\"in_export-hid\" value=\"0\" />
  785.         <input type=\"checkbox\" name=\"in_export\" id=\"in_export\" value=\"1\" ".$def['in_export']."/>
  786.         <label for=\"in_export\">Permetti esportazione</label>
  787.         <div class=\"info-campo\">Permetti a questo l'esportazione dei dati in tabella</div>
  788.         
  789.         ";
  790.         
  791.         
  792.         
  793.         // IN CASO DI VISTA IMPOSTA ESPLICITAMENTE LA CHIAVE PRIMARIA DELLA TABELLA
  794.         
  795.         if($info['table_type']=='VIEW'){
  796.             
  797.             echo "<label for=\"view_pk\">Imposta la chiave primaria</label> ";
  798.             echo "<select id=\"view_pk\" name=\"view_pk\">\n";
  799.     
  800.     
  801.             foreach($campi_tabella as $k=>$campo){
  802.                 
  803.                 $view_pk_sel = ($info['view_pk']==$campo)? "selected=\"selected\"": "";
  804.                 
  805.                 echo "<option value=\"$campo\" $view_pk_sel>".$campo."</option>\n";
  806.                 
  807.             }
  808.             
  809.             echo "</select>
  810.             <div class=\"info-campo\">In quanto vista si rende necessario dichiarare espliticamente la chiave primaria</div>\n";
  811.         }
  812.         
  813.         
  814.         
  815.         echo "
  816.         
  817.         <fieldset style=\"width:60%;margin-bottom:20px; padding:15px;\">
  818.             <legend>Allegati e link</legend>
  819.         ";
  820.         
  821.         
  822.         // IN CASO DI VISTA IMPOSTA ESPLICITAMENTE LA FONTE PER ALLEGATI E LINK
  823.         
  824.         if($info['table_type']=='VIEW'){
  825.             
  826.             $tabelle_db=prendi_tabelle($_GET['gid']);
  827.             echo "<select id=\"fonte_al\" name=\"fonte_al\">\n";
  828.     
  829.     
  830.             foreach($tabelle_db as $k=>$tab){
  831.                 
  832.                 $view_fonte_sel = ($info['fonte_al']==$tab['table_name'])? "selected=\"selected\"": "";
  833.                 
  834.                 echo "<option value=\"{$tab['table_name']}\" $view_fonte_sel>".$tab['table_name']."</option>\n";
  835.                 
  836.             }
  837.             
  838.             echo "</select>
  839.             <div class=\"info-campo\">In quanto vista si rende necessario dichiarare da quale tabella debbano essere letti/inseriti gli allegati e i link</div>\n";
  840.         
  841.         }
  842.         
  843.             
  844.         echo "
  845.             <input type=\"hidden\" name=\"permetti_allegati\" id=\"permetti_allegati-hid\" value=\"0\" />
  846.             <input type=\"checkbox\" name=\"permetti_allegati\" id=\"permetti_allegati\" value=\"1\" ".$def['permetti_allegati']." onclick=\";if(this.checked){document.getElementById('opzioni_allegati').style.display='';}else{document.getElementById('opzioni_allegati').style.display='none';}\" />
  847.             <label for=\"permetti_allegati\">Tabella con allegati</label>
  848.             <div class=\"info-campo\">Permette di allegare dei file (documenti o immagini) ai record di questa tabella</div>
  849.             
  850.             
  851.                 <div id=\"opzioni_allegati\" style=\"display:{$def['permetti_allegati_display']}\">
  852.                     <input type=\"hidden\" name=\"permetti_allegati_ins\" id=\"permetti_allegati_ins-hid\" value=\"0\" />
  853.                     <input type=\"checkbox\" name=\"permetti_allegati_ins\" id=\"permetti_allegati_ins\" value=\"1\" ".$def['permetti_allegati_ins']."/>
  854.                     <label for=\"permetti_allegati_ins\">Permetti inserimento nuovi allegati</label>
  855.                     
  856.                     <br />
  857.                     
  858.                     
  859.                     <input type=\"hidden\" name=\"permetti_allegati_del\" id=\"permetti_allegati_del-hid\" value=\"0\" />
  860.                     <input type=\"checkbox\" name=\"permetti_allegati_del\" id=\"permetti_allegati_del\" value=\"1\" ".$def['permetti_allegati_del']."/>
  861.                     <label for=\"permetti_allegati_del\">Permetti eliminazione allegati</label>
  862.                     
  863.                 </div>
  864.             
  865.             
  866.             
  867.             <input type=\"hidden\" name=\"permetti_link\" id=\"permetti_link-hid\" value=\"0\" />
  868.             <input type=\"checkbox\" name=\"permetti_link\" id=\"permetti_link\" value=\"1\" ".$def['permetti_link']." onclick=\";if(this.checked){document.getElementById('opzioni_link').style.display='';}else{document.getElementById('opzioni_link').style.display='none';}\"  />
  869.             <label for=\"permetti_link\">Tabella con link</label>
  870.             <div class=\"info-campo\">Permette di collegare dei link ai record di questa tabella</div>
  871.             
  872.                 <div id=\"opzioni_link\" style=\"display:{$def['permetti_link_display']}\">
  873.                     <input type=\"hidden\" name=\"permetti_link_ins\" id=\"permetti_link_ins-hid\" value=\"0\" />
  874.                     <input type=\"checkbox\" name=\"permetti_link_ins\" id=\"permetti_link_ins\" value=\"1\" ".$def['permetti_link_ins']."/>
  875.                     <label for=\"permetti_link_ins\">Permetti inserimento nuovi link</label>
  876.                     
  877.                     <br />
  878.                     
  879.                     
  880.                     <input type=\"hidden\" name=\"permetti_link_del\" id=\"permetti_link_del-hid\" value=\"0\" />
  881.                     <input type=\"checkbox\" name=\"permetti_link_del\" id=\"permetti_link_del\" value=\"1\" ".$def['permetti_link_del']."/>
  882.                     <label for=\"permetti_link_del\">Permetti eliminazione link</label>
  883.                     
  884.                 </div>
  885.             
  886.         </fieldset>
  887.         <br /><br />
  888.         <input type=\"hidden\" name=\"oid\" value=\"$oid\" />
  889.         <input type=\"hidden\" name=\"gid\" value=\"$gid\" />
  890.         <input id=\"trasversale\" type=\"hidden\" name=\"trasversale_gen\" value=\"0\" />
  891.         
  892.         <input type=\"submit\" name=\"invia_gen\" value=\"Salva impostazione generale\" />
  893.         
  894.         &nbsp;&nbsp;&nbsp;
  895.         
  896.         <input type=\"button\" onclick=\"if(confirm('Attenzione!\\nSi vuole veramente modificare in questo modo le impostazioni per tutti i gruppi?')){ document.getElementById('trasversale').value='1';submit();}\" name=\"invia_gen_trasversale\" value=\"Salva impostazione generale per tutti i gruppi\" />
  897.     
  898.     </form>
  899.     
  900.     </div>\n";
  901.         
  902.     //-- fine impostazioni generali
  903.     
  904.     
  905.     
  906.     
  907.     ######################################################################################
  908.     #
  909.     #    IMPOSTAZIONI CAMPI SORT
  910.     #
  911.     #
  912.     
  913.     
  914.     $st_sub = (isset($_GET['a']) && $_GET['a']==4) ? "" : "display:none;"; 
  915.     
  916.     echo "<div class=\"campi-sort\" id=\"campi-sort\" style=\"$st_sub\">\n";
  917.     
  918.     
  919.     echo "<h3>Ordinamento dei campi</h3>\n";
  920.     
  921.     echo "<p>Attraverso questa funzione &egrave; possibile cambiare l'ordine di presentazione dei campi della tabella
  922.      nella vista a scheda. I campi in grigio sono quelli al momento impostati come invisibili.<br />
  923.      Per modificare l'ordine dei campi prendere le etichette e trascinarle nella posizione desiderata</p>
  924.      <form name=\"ripristina\" method=\"post\" action=\"rpc.sortcampi.php?ripristina\" >
  925.      
  926.      <input type=\"hidden\" name=\"url\" value=\"".htmlentities($_SERVER['QUERY_STRING'])."\" />
  927.      <input type=\"hidden\" name=\"oid\" value=\"$oid\" />
  928.      <input type=\"button\" onclick=\"submit()\" value=\"Ripristina ordinamento di default\" name=\"ripristina1\" />
  929.      
  930.      </form>\n";
  931.     
  932.     
  933.     list($id_reg_sort,$campi_tabella_sort,$in_visibile_sort) = prendi_colonne_frontend($oid,"id_reg,column_name,in_visibile",false);
  934.     
  935.     
  936.     echo "<p id=\"list-info\" >&nbsp;</p>";
  937.     
  938.     echo "<div><ul id=\"firstlist\" style=\"width:200px;\">\n";
  939.     
  940.     
  941.     
  942.     foreach($campi_tabella_sort as $k=>$campo){
  943.         
  944.         $classe_sort = ($in_visibile_sort[$k]=='1') ? "campi-float-blu":"campi-float-grigio";
  945.         
  946.         echo "<li id=\"item_{$id_reg_sort[$k]}\" class=\"$classe_sort\">".$campo."</li>\n";
  947.         
  948.     }
  949.     
  950.     echo "</ul></div>";
  951.     
  952.     
  953. //    echo "<script type=\"text/javascript\" src=\"../js/scriptaculous/scriptaculous.js?load=dragdrop\" ></script>\n";
  954.     
  955.     echo "<script type=\"text/javascript\">
  956.  // <![CDATA[
  957.             Sortable.create('firstlist', 
  958.                             {onUpdate:function()
  959.                                 {new Ajax.Updater('list-info', '".dirname($_SERVER['PHP_SELF'])."/rpc.sortcampi.php?det=$oid&gid=$gid', 
  960.                                     {onComplete:function(request){ /*new Effect.Highlight('firstlist',{}); */}, 
  961.                                     parameters:Sortable.serialize('firstlist'), 
  962.                                     evalScripts:true, 
  963.                                     asynchronous:true});
  964.                                     setTimeout(\"$('list-info').innerHTML = '&nbsp;'; \", 3000 );
  965.                                 }
  966.                             })
  967.  // ]]>
  968.     </script>";
  969.  
  970. /* echo '<script type="text/javascript">
  971.  // <![CDATA[
  972.    Sortable.create("firstlist",
  973.      {dropOnEmpty:true,containment:["firstlist","secondlist"],constraint:false});
  974.    
  975.  // ]]>
  976.  </script>';*/
  977.     
  978.     
  979.     echo "</div>\n";
  980.     
  981.     
  982.     
  983.     //-- fine campi-sort
  984.     
  985.     
  986.     ##############################################################
  987.     #
  988.     #     FORM IMPOSTAZIONI SOTTOMASCHERE
  989.     #
  990.     #
  991.     #
  992.     
  993.     
  994.     
  995.     $sottomaschere = prendi_sottomaschere($oid,true);
  996.     
  997.  
  998.     
  999.     
  1000.     
  1001.     $st_sub = (isset($_GET['a']) && $_GET['a']==3) ? "" : "display:none;"; 
  1002.     
  1003.     echo "<div class=\"tabella-sottomaschere\" id=\"tabella-sottomaschere\" style=\"$st_sub\">\n";
  1004.     
  1005.     echo "<p><a href=\"javascript:;\" onclick=\"mostra_nascondi('nuova-sottomaschera');\">Nuove sottomaschere</a></p>\n";
  1006.     
  1007.         echo "<div id=\"nuova-sottomaschera\" style=\"display:none;\">\n";
  1008.         
  1009.             echo "<form action=\"".$_SERVER['PHP_SELF']."\" method=\"post\">
  1010.             
  1011.             
  1012.                  <select size=\"13\" multiple=\"multiple\" name=\"new_submask[]\">
  1013.                  ";
  1014.             
  1015.             $tabelle = prendi_tabelle($gid);
  1016.             
  1017.             for($i=0;$i<count($tabelle);$i++){
  1018.                 
  1019.                 // test sull'esuistanza delle sottomaschere
  1020.                 $SUB_esiste = (isset($sottomaschere['nome_tabella']) && in_array($tabelle[$i]['table_name'],$sottomaschere['nome_tabella'])) ? true:false;
  1021.                     
  1022.                 if($tabelle[$i]['id_table']!=$oid && !$SUB_esiste)
  1023.                     echo "\t\t\t<option value=\"".$tabelle[$i]['id_table']."\">".$tabelle[$i]['table_name']."</option>\n";
  1024.                 
  1025.             }
  1026.             
  1027.             echo "
  1028.                  </select>
  1029.                 
  1030.                  <input type=\"hidden\" name=\"oid\" value=\"$oid\" />
  1031.                  
  1032.                 <br /><br />
  1033.                 <input type=\"submit\" name=\"sottomaschere\" value=\"Crea nuove sottomaschere\" />
  1034.             </form>\n";
  1035.         
  1036.  
  1037.     
  1038.         echo "</div>\n";
  1039.         
  1040.         
  1041.         ## COPIA LE SOTTOMASCHERE
  1042.         
  1043.         $mat_gruppi_sub = prendi_gruppi($_GET['gid']);
  1044.     
  1045.         if(count($mat_gruppi_sub)>0){
  1046.         
  1047.             echo "<form name=\"copia_sottomaschere\" action=\"".$_SERVER['PHP_SELF']."\" method=\"post\">\n";
  1048.         
  1049.             $sel_gruppi_sub="\t<select name=\"copia_sub_gid\" id=\"copia_sub_gid\" >\n";
  1050.             
  1051.             
  1052.             foreach ($mat_gruppi_sub as $k=>$ar){
  1053.                 
  1054.                 $sel_gruppi_sub.="\t\t<option value=\"".$ar['gid']."\">".$ar['gid']. " - ". $ar['nome_gruppo']."</option>\n";
  1055.             }
  1056.             
  1057.             $sel_gruppi_sub.="</select>";
  1058.             
  1059.             $confirm_cp_sub ="if(confirm('Se si copiano le impostazioni delle sottomaschere da un altro gruppo le attuali verranno completamente sovrascritte. \\nL\'operazione non ï¿½ ripristinabile. \\nSi vuole procedere?')){submit();}";
  1060.             echo "<input type=\"hidden\" name=\"copia_sottomaschere\" value=\"1\" />\n";
  1061.             echo "<input type=\"hidden\" name=\"det\" value=\"".$_GET['det']."\" />\n";
  1062.             echo "<input type=\"hidden\" name=\"gid\" value=\"".$_GET['gid']."\" />\n";
  1063.             echo "Applica le impostazioni sottomaschere del gruppo: $sel_gruppi_sub  <input type=\"button\" onclick=\"$confirm_cp_sub\" name=\"copia\" value=\" Applica \" />\n";
  1064.             
  1065.             echo "</form>\n";
  1066.             
  1067.             unset($mat_gruppi_sub);
  1068.             unset($confirm_cp_sub);
  1069.         }
  1070.         
  1071.         
  1072.     // sottomaschere esistenti:
  1073.     
  1074.     if(count($sottomaschere)==0){
  1075.         
  1076.         echo "<p><strong>Non esistono sottomaschere per questa tabella/gruppo</strong></p>\n";
  1077.         
  1078.         
  1079.         
  1080.         if($info['table_type']=='VIEW'){
  1081.         
  1082.                 
  1083.                 $tabelle_elenco=prendi_tabelle(intval($_GET['gid']));
  1084.                 
  1085.                 
  1086.                 
  1087.                 echo "<form action=\"".$_SERVER['PHP_SELF']."?det=".$_GET['det']."&amp;gid=".$_GET['gid']."\" method=\"post\" >\n";
  1088.                 
  1089.                 echo "Clona da tabella: <select name=\"id_tabella\">\n";
  1090.                 
  1091.                 for($i=0;$i<count($tabelle_elenco);$i++){
  1092.                     
  1093.                     echo "<option value=\"".$tabelle_elenco[$i]['id_table']."\">".$tabelle_elenco[$i]['table_name']."</option>\n";
  1094.                 }
  1095.                 
  1096.                 echo "</select>\n";
  1097.                 echo " <input type=\"hidden\" name=\"clona_sottomaschere_vista\" value=\"1\" />\n";
  1098.                 echo " <input type=\"hidden\" name=\"id_vista\" value=\"".$_GET['det']."\" />\n";
  1099.                 echo " <input type=\"button\" onclick=\"submit();\" name=\"clona_impostazioni\" value=\" clona impostazioni \" />\n";
  1100.                 
  1101.                 echo "</form>\n";
  1102.         }
  1103.         
  1104.         
  1105.     }
  1106.     else{
  1107.         
  1108.         submask_menu($oid);
  1109.         
  1110.     }
  1111.         
  1112.     
  1113.     // Dettagli sottomaschera
  1114.     
  1115.     if(isset($_GET['conf_sub'])){
  1116.         
  1117.         // creca l'id della submaschera nei risultati
  1118.         $k_sub= array_search($_GET['conf_sub'],$sottomaschere['id_submask']);
  1119.         
  1120.         
  1121.         
  1122.         echo "<h3 style=\"margin-top:60px;border-bottom:1px solid #CCC;width:75%;\">Impostazioni generali sottomaschera <span class=\"var\">".$sottomaschere['nome_tabella'][$k_sub]."</span></h3>\n";
  1123.         
  1124.         echo "<strong>Collegamento tra le tabelle</strong>: \n";
  1125.         
  1126.         
  1127.         
  1128.         
  1129.         echo "<form name=\"sub_gen\" action=\"".$_SERVER['PHP_SELF']."?mod_sub_gen\" method=\"post\">\n";
  1130.         
  1131.         
  1132.         #######################################################################
  1133.         #
  1134.         #
  1135.         #     riferimenti e FK
  1136.         
  1137.         // prendo le FK
  1138.         $rif_sub = prendi_FK($sottomaschere['nome_tabella'][$k_sub],intval($_GET['gid']));
  1139.         
  1140.         $rif_sub_k=null;
  1141.         
  1142.         // ce ne sono riferite alla tabella in oggetto?
  1143.         for($i=0;$i<count($rif_sub[1]);$i++){
  1144.             
  1145.             if(preg_match("/^{$info['table_name']}\.[\w]+/",$rif_sub[1][$i])){
  1146.                 
  1147.                 $rif_sub_k = $i;
  1148.             }
  1149.         }
  1150.         
  1151.         if(!is_null($rif_sub_k)){
  1152.             
  1153.             $parent_consigliata = substr( $rif_sub[1][$rif_sub_k] ,  strpos($rif_sub[1][$rif_sub_k],".")+1  );
  1154.             $this_consigliata = $rif_sub[0][$rif_sub_k];
  1155.         }
  1156.         
  1157.         
  1158.         
  1159.         echo $info['table_name'].".";
  1160.         
  1161.         echo "<select name=\"sub_gen[sub_pk_parent]\">\n";
  1162.         
  1163.         // PRENDI LE COLONNE
  1164.         
  1165.         list($colonne_parent) = prendi_colonne_frontend($oid,'column_name',false);
  1166.         
  1167.         list($colonne_this) = prendi_colonne_frontend($sottomaschere['nome_tabella'][$k_sub],'column_name',false,0);
  1168.         
  1169.         
  1170.         
  1171.         
  1172.         // TESTA LA VISIBILITA' DEL CAMPO
  1173.         
  1174.         $campo_attuale_fk= $sottomaschere['campo_pk_parent'][$k_sub];
  1175.         
  1176.         $PK_fk= prendi_PK_oid($oid);
  1177.         
  1178.         /*var_dump($PK_fk);
  1179.         var_dump($sottomaschere);*/
  1180.         
  1181.         if($campo_attuale_fk!=$PK_fk[0] && $campo_attuale_fk!=''){
  1182.             
  1183.             $sql_vis_fk="SELECT in_visibile FROM {$db1['frontend']}.registro_col 
  1184.                         WHERE id_table='$oid' AND column_name='$campo_attuale_fk'";
  1185.             $q_vis_fk=vmsql_query($sql_vis_fk,$link);
  1186.             
  1187.             list($in_visibile_fk)=vmsql_fetch_row($q_vis_fk);
  1188.             
  1189.             $campo_fk_visibile = ($in_visibile_fk) ? true:false;
  1190.             
  1191.         }
  1192.         else{
  1193.             $campo_fk_visibile=true;
  1194.         }
  1195.         
  1196.         
  1197.         
  1198.  
  1199.         for($i=0;$i<count($colonne_parent);$i++){
  1200.             
  1201.             $aggiunta_sub_parent = ($parent_consigliata==$colonne_parent[$i]) ?     " (consigliata)" : "";
  1202.             
  1203.             $sel_sub_parent = ($colonne_parent[$i]==$sottomaschere['campo_pk_parent'][$k_sub]) ? "selected=\"selected\"" :"";
  1204.             
  1205.             echo "\t\t<option value=\"".$colonne_parent[$i]."\" $sel_sub_parent>".$colonne_parent[$i].$aggiunta_sub_parent."</option>\n";
  1206.         }
  1207.         
  1208.         echo "</select>\n";
  1209.         
  1210.         
  1211.         
  1212.         echo " ---<strong>&gt;</strong> ".$sottomaschere['nome_tabella'][$k_sub].".";
  1213.         
  1214.         echo "<select name=\"sub_gen[sub_fk_this]\">\n";
  1215.         
  1216.         $OPT_SUB_THIS="";
  1217.         $OPT_SUB_THIS_ORDER="";
  1218.         
  1219.         for($j=0;$j<count($colonne_this);$j++){
  1220.             
  1221.             $aggiunta_sub_this = ($this_consigliata==$colonne_this[$j]) ?     " (consigliata)" : "";
  1222.             
  1223.             $sel_sub_this = ($colonne_this[$j]==$sottomaschere['campo_fk_sub'][$k_sub]) ? "selected=\"selected\"" :"";
  1224.             
  1225.             $sel_sub_this_ord = ($colonne_this[$j]==$sottomaschere['orderby_sub'][$k_sub]) ? "selected=\"selected\"" :"";
  1226.  
  1227.             
  1228.             $OPT_SUB_THIS.= "\t\t<option value=\"".$colonne_this[$j]."\" $sel_sub_this>".$colonne_this[$j].$aggiunta_sub_this."</option>\n";
  1229.             $OPT_SUB_THIS_ORDER.= "\t\t<option value=\"".$colonne_this[$j]."\" $sel_sub_this_ord>".$colonne_this[$j]."</option>\n";
  1230.         }
  1231.         
  1232.         echo $OPT_SUB_THIS;
  1233.         
  1234.         echo "</select><div class=\"info-campo\">Imposta il collegamento tra i record della tabella e i record della sottomaschera</div>\n";
  1235.         
  1236.         
  1237.         
  1238.         
  1239.         
  1240.         // MOSTRA AVVISO IN CASO DI CAMPO NON VISIBILE
  1241.         
  1242.         if(!$campo_fk_visibile){
  1243.             
  1244.             echo "<span style=\"color:red;font-weight:bold;\">
  1245.                 ATTENZIONE! Il campo della tabella padre non &egrave; chiave primaria e non &egrave; impostato come visibile!
  1246.                  Quando si imposta un campo che non sia la chiave primaria questo deve essere visibile.
  1247.                  In questo caso il collegamento con la tabella non funzioner&agrave;<br />
  1248.                 Impostare il campo come visibile (pu&ograve essere anche un campo nascosto) dalle Impostazioni Campi</span><br /><br />\n";
  1249.         }
  1250.         //---------------------------------------------
  1251.         
  1252.         
  1253.         
  1254.         
  1255.         
  1256.         
  1257.         $sub_select_check= ($sottomaschere['sub_select'][$k_sub]=='1') ? "checked=\"checked\"" : "";
  1258.         $sub_insert_check= ($sottomaschere['sub_insert'][$k_sub]=='1') ? "checked=\"checked\"" : "";
  1259.         $sub_update_check= ($sottomaschere['sub_update'][$k_sub]=='1') ? "checked=\"checked\"" : "";
  1260.         $sub_delete_check= ($sottomaschere['sub_delete'][$k_sub]=='1') ? "checked=\"checked\"" : "";
  1261.         $tipo_vista_check1= ($sottomaschere['tipo_vista'][$k_sub]=='tabella') ? "checked=\"checked\"" : "";
  1262.         $tipo_vista_check2= ($sottomaschere['tipo_vista'][$k_sub]=='scheda') ? "checked=\"checked\"" : "";
  1263.         
  1264.         $sel_orderby_sub_sort_ASC = ($sottomaschere['orderby_sub_sort'][$k_sub]=="ASC") ? "selected=\"selected\"" : "";
  1265.         $sel_orderby_sub_sort_DESC = ($sottomaschere['orderby_sub_sort'][$k_sub]=="DESC") ? "selected=\"selected\"" : "";
  1266.         
  1267.         // imposta un default su SCHEDA
  1268.         if($tipo_vista_check1=='' && $tipo_vista_check2=='') 
  1269.             $tipo_vista_check2="checked=\"checked\"";
  1270.         
  1271.         
  1272.         echo "
  1273.         
  1274.         <label for=\"nome_frontend\">Nome della sottomaschera</label><br/> 
  1275.         <input type=\"text\" name=\"sub_gen[nome_frontend]\"  id=\"nome_frontend\" value=\"".$sottomaschere['nome_frontend'][$k_sub]."\" maxlength=\"240\" size=\"35\" />
  1276.         <div class=\"info-campo\">Nome della sottomaschera che apparir&agrave; all'utente</div>
  1277.         
  1278.         <label for=\"tipo_vista_1\">Modalit&agrave; di visualizzazione dei dati</label><br/> 
  1279.         <input type=\"radio\" name=\"sub_gen[tipo_vista]\"  id=\"tipo_vista_1\"  value=\"scheda\" $tipo_vista_check2 /> Schede
  1280.         <input type=\"radio\" name=\"sub_gen[tipo_vista]\"  id=\"tipo_vista_2\" value=\"tabella\" $tipo_vista_check1 /> Tabella
  1281.         <div class=\"info-campo\">Come mostrare i dati. La vista tabella si consiglia per sottomaschere con uno o massimo due campo di piccola dimensione</div>
  1282.         
  1283.         <input type=\"hidden\" name=\"sub_gen[sub_select]\" value=\"0\" />
  1284.         <input type=\"checkbox\" name=\"sub_gen[sub_select]\" id=\"sub_select\" value=\"1\" $sub_select_check/>
  1285.         <label for=\"sub_select\">Maschera visibile (SELECT)</label>
  1286.         <div class=\"info-campo\">Imposta se la sottomaschera deve essere visibile per questo gruppo</div>
  1287.         
  1288.         <input type=\"hidden\" name=\"sub_gen[sub_insert]\" value=\"0\" />
  1289.         <input type=\"checkbox\" name=\"sub_gen[sub_insert]\" id=\"sub_insert\" value=\"1\" $sub_insert_check/>
  1290.         <label for=\"sub_insert\">Diritti scrittura (INSERT)</label>
  1291.         <div class=\"info-campo\">Imposta se &egrave; possibile inserire record attraverso la sottomaschera</div>
  1292.         
  1293.         <input type=\"hidden\" name=\"sub_gen[sub_update]\" value=\"0\" />
  1294.         <input type=\"checkbox\" name=\"sub_gen[sub_update]\" id=\"sub_update\" value=\"1\" $sub_update_check/>
  1295.         <label for=\"sub_update\">Diritti modifica (UPDATE)</label>
  1296.         <div class=\"info-campo\">Imposta se &egrave; possibile modificare record attraverso la sottomaschera</div>
  1297.         
  1298.         <input type=\"hidden\" name=\"sub_gen[sub_delete]\" value=\"0\" />
  1299.         <input type=\"checkbox\" name=\"sub_gen[sub_delete]\" id=\"sub_delete\" value=\"1\" $sub_delete_check/>
  1300.         <label for=\"sub_delete\">Diritti eliminazione (DELETE)</label>
  1301.         <div class=\"info-campo\">Imposta se &egrave; possibile cancellare record attraverso la sottomaschera</div>
  1302.         
  1303.         <label for=\"orderby_sub\">Ordina record sottomaschera per:</label>
  1304.         <select id=\"orderby_sub\" name=\"sub_gen[orderby_sub]\">
  1305.             $OPT_SUB_THIS_ORDER
  1306.         </select>
  1307.         
  1308.         <select id=\"orderby_sub_sort\" name=\"sub_gen[orderby_sub_sort]\">
  1309.             <option value=\"ASC\" $sel_orderby_sub_sort_ASC>Ascendente</option>
  1310.             <option value=\"DESC\" $sel_orderby_sub_sort_DESC>Discendente</option>
  1311.         </select>        
  1312.         <div class=\"info-campo\">Imposta l'ordinamento dei record della sottomaschera</div>
  1313.         
  1314.         
  1315.         
  1316.         <label for=\"max_records\">Numero di record max per la sottomaschera</label><br/> 
  1317.         <input type=\"text\" name=\"sub_gen[max_records]\"  id=\"max_records\" value=\"".$sottomaschere['max_records'][$k_sub]."\" maxlength=\"3\" size=\"5\" />
  1318.         <div class=\"info-campo\">Numero massimo di record per la sottomaschera. Si sconsiglia di tenere questo numero molto alto in quanto potrebbe causare un rallentamento nel caricamento della sottomaschera.</div>
  1319.         
  1320.         <input type=\"hidden\" name=\"sub_gen[id_submask]\" value=\"".$sottomaschere['id_submask'][$k_sub]."\" />
  1321.         <input type=\"hidden\" name=\"sub_gen[oid]\" value=\"".intval($_GET['det'])."\" />
  1322.         
  1323.         <input type=\"submit\" name=\"invia_sub_generali\" value=\"Salva impostazioni generali sottomaschera\" />
  1324.         
  1325.         ";
  1326.         
  1327.         echo "</form>\n";
  1328.         
  1329.         
  1330.         
  1331.         
  1332.         
  1333.         
  1334.         
  1335.         ###############################################################################################################
  1336.         #
  1337.         #    IMPOSTAZIONE CAMPI PER LA SOTTOMASCHERA
  1338.         #
  1339.         #
  1340.         #
  1341.         
  1342.         
  1343.         
  1344.         echo "<h3 style=\"margin-top:60px;border-bottom:1px solid #CCC;width:75%;\">Impostazioni per i campi della sottomaschera <span class=\"var\">".$sottomaschere['nome_tabella'][$k_sub]."</span></h3>\n";
  1345.         
  1346.         
  1347.             echo "\t<form method=\"post\" action=\"".$_SERVER['PHP_SELF']."?gid=".$_GET['gid']."&amp;mod_sub_campi\">\n";
  1348.     
  1349.         
  1350.         
  1351.             # Inizia a prendere i campi
  1352.             
  1353.             
  1354.             $sql_sub_cols = "SELECT  c.*
  1355.                                 
  1356.                                 FROM {$db1['frontend']}.registro_submask_col c, {$db1['frontend']}.registro_submask t
  1357.                                 WHERE t.nome_tabella='".$sottomaschere['nome_tabella'][$k_sub]."'
  1358.                                 AND t.id_table=$oid
  1359.                                 AND t.id_submask = c.id_submask
  1360.                                 ORDER BY c.ordinal_position";
  1361.             
  1362.             $q_sub_cols=vmsql_query($sql_sub_cols,$link);
  1363.             
  1364.             $matrice_sub_col=vmsql_fetch_assoc_all($q_sub_cols);
  1365.             
  1366.             $matrice_sub_rev=vmsql_reverse_matrix($matrice_sub_col);
  1367.             
  1368.             $array_sub_pk=prendi_all_PK($sottomaschere['nome_tabella'][$k_sub],0);
  1369.                        
  1370.             while(list($k,$array_sub_val)=each($matrice_sub_col)){
  1371.                 
  1372.                 
  1373.                 if($array_sub_val['column_name']==$sottomaschere['campo_fk_sub'][$k_sub]){
  1374.                     
  1375.                     
  1376.                     echo tratta_campo_submask($array_sub_val, $array_sub_pk, $rif_sub[0], $rif_sub[1],$sottomaschere['campo_pk_parent'][$k_sub],$oid);
  1377.                     
  1378.             /*        echo "
  1379.                     <div class=\"campo\">
  1380.                         <div class=\"campo-head\">
  1381.                             <strong class=\"var\">".$array_sub_val['column_name']."</strong> - ".$array_sub_val['data_type']." ".$array_sub_val['max_length']." ".$array_sub_val['info_fk']."
  1382.                             ".$array_sub_val['commento']."
  1383.                         
  1384.                         </div>
  1385.                         
  1386.                         <div class=\"grigio\">
  1387.                         <br />Questo campo non &egrave; soggetto ad impostazioni in quanto si &egrave; impostato come collegamento tra i record della tabella e i record della sottomaschera.
  1388.                         Pertanto il valore che assumer&agrave; sar&agrave; quello della chiave esterna relativa alla tabella genitore.
  1389.                         </div>
  1390.                     </div>
  1391.                     
  1392.                     ";*/
  1393.                 }
  1394.                 else{
  1395.                     echo tratta_campo_submask($array_sub_val, $array_sub_pk, $rif_sub[0], $rif_sub[1]);
  1396.                 }
  1397.             }
  1398.             
  1399.             echo "\t\t<input type=\"hidden\" name=\"oid\" value=\"".intval($_GET['det'])."\" />\n";
  1400.             
  1401.             echo "\t\t<input type=\"hidden\" name=\"id_submask\" value=\"".intval($_GET['conf_sub'])."\" />\n";
  1402.             
  1403.             echo "\t\t<input type=\"button\" name=\"invia_campi\" value=\"Salva impostazioni campi\" onclick=\"submit()\" />\n";
  1404.             
  1405.             echo "\t</form>\n";
  1406.         
  1407.         
  1408.     }
  1409.     
  1410.     
  1411.     echo "</div>\n";
  1412.     
  1413.         
  1414.     //-- fine impostazioni sottomaschere
  1415.     
  1416.     
  1417.     
  1418.     
  1419.     
  1420.     
  1421.     
  1422.     
  1423.     
  1424.     
  1425.     
  1426.     
  1427.     
  1428.     
  1429.     
  1430.     
  1431.     
  1432.     
  1433.     
  1434.     ###############################################################################
  1435.     #
  1436.     # FORM campi
  1437.     #
  1438.     
  1439.     $st_campi = (isset($_GET['a']) && $_GET['a']==2) ? "" : "display:none;"; 
  1440.     
  1441.     echo "<div id=\"tabella-campi\" class=\"tabella-campi\" style=\"$st_campi\">\n";
  1442.     
  1443.     
  1444.     if(isset($_GET['feed']) && $_GET['feed']=='copia_ok'){
  1445.         
  1446.         echo "<p class=\"feed-mod-ok\">Impostazioni campi copiate correttamente</p>\n";
  1447.         
  1448.     }
  1449.     
  1450.     // COPIA IMPOSTAZIONI DA ALTRO GRUPPO
  1451.     
  1452.     $mat_gruppi = prendi_gruppi($_GET['gid']);
  1453.     
  1454.         if(count($mat_gruppi)>0){
  1455.         
  1456.         echo "\t<form method=\"post\" action=\"".$_SERVER['PHP_SELF']."\" id=\"form_copia_campi\">\n"; 
  1457.         
  1458.         
  1459.         
  1460.         $sel_gruppi="\t<select name=\"copia_campi_gid\" id=\"copia_campi_gid\" >\n";
  1461.         
  1462.         
  1463.         foreach ($mat_gruppi as $k=>$ar){
  1464.             
  1465.             $sel_gruppi.="\t\t<option value=\"".$ar['gid']."\">".$ar['gid']. " - ". $ar['nome_gruppo']."</option>\n";
  1466.         }
  1467.         
  1468.         $sel_gruppi.="</select>";
  1469.         
  1470.         $confirm_cp ="if(confirm('Se si copiano le impostazioni da un altro gruppo le attuali verranno completamente sovrascritte. \\nL\'operazione non è ripristinabile. \\nSi vuole procedere?')){submit();}";
  1471.         echo "<input type=\"hidden\" name=\"copia_campi\" value=\"1\" />\n";
  1472.         echo "<input type=\"hidden\" name=\"det\" value=\"".$_GET['det']."\" />\n";
  1473.         echo "<input type=\"hidden\" name=\"gid\" value=\"".$_GET['gid']."\" />\n";
  1474.         echo "Applica le impostazioni campi dal gruppo: $sel_gruppi  <input type=\"button\" onclick=\"$confirm_cp\" name=\"copia\" value=\" Applica \" />\n";
  1475.         
  1476.         echo "</form>\n";
  1477.         
  1478.         unset($mat_gruppi);
  1479.     }
  1480.     
  1481.     //------------------------------------
  1482.     
  1483.     
  1484.     echo "\t<form method=\"post\" action=\"".$_SERVER['PHP_SELF']."\">\n";
  1485.     
  1486.     
  1487.                        
  1488.     while(list($k,$array_val)=each($matrice_col)){
  1489.         
  1490.         echo tratta_campo($array_val, $array_pk, $array_fk, $colref_fk);
  1491.     }
  1492.     
  1493.     echo "\t\t<input type=\"hidden\" name=\"oid\" value=\"$oid\" />\n";
  1494.     
  1495.     echo "\t\t<input type=\"hidden\" name=\"gid\" value=\"$gid\" />\n";
  1496.     
  1497.     echo "\t\t<input id=\"trasversale_campi\" type=\"hidden\" name=\"trasversale_campi\" value=\"0\" />\n";
  1498.     
  1499.     
  1500.     echo "\t\t<input type=\"hidden\" name=\"risposta_sql_all\" id=\"risposta_sql_all\" value=\"\" />\n";
  1501.  
  1502.     
  1503.     
  1504.     echo "\t\t<input type=\"button\" name=\"invia_campi\" value=\"Salva impostazioni campi\" onclick=\"submit();\" />\n "; //onclick=\"if(test_campi()=='1'){submit();}else{alert('Alcune impostazioni SQL sembrano errate, oppure si ï¿½ lasciato vuoto un campo SQL. Prego verificare');}\" />
  1505.     
  1506.     
  1507.     echo "\t\t<input type=\"button\" onclick=\"if(confirm('Attenzione!\\nSi vuole veramente modificare in questo modo le impostazioni per tutti i gruppi?')){ document.getElementById('trasversale').value='1';submit();}\" name=\"invia_gen_trasversale\" value=\"Salva impostazione dei campi per tutti i gruppi\" />\n";
  1508.     
  1509.     
  1510.     
  1511.     echo "\t</form>\n";
  1512.     
  1513.     echo "</div>\n";
  1514.     
  1515.     
  1516.     echo closeLayout1();
  1517. }
  1518.  
  1519.  
  1520.  
  1521.  
  1522. // ----------------------------------  FINE FUNZIONI  -----------------------------------------
  1523.  
  1524.  
  1525.  
  1526.  
  1527.  
  1528.  
  1529.  
  1530.  
  1531.  
  1532.  
  1533.  
  1534.  
  1535.  
  1536.  
  1537.  
  1538.  
  1539.  
  1540.  
  1541.  
  1542.  
  1543. // --------------------------------- AZIONI ---------------------------------------------------
  1544.  
  1545.  
  1546.  
  1547.  
  1548.  
  1549.  
  1550.  
  1551.  
  1552.  
  1553.  
  1554.  
  1555.  
  1556. ###################################################################################################
  1557. #
  1558. ## INSERIMENTO INFO GENERALI DI TABELLA
  1559. #
  1560. if(isset($_POST['invia_gen']) || isset($_POST['trasversale_gen'])){
  1561.     
  1562.     
  1563.     $_dati_gen=pulisci_dom($_POST);
  1564.     
  1565.     $clausola_view_pk = (isset($_dati_gen['view_pk'])) ? "view_pk='".$_dati_gen['view_pk']."'," : "";
  1566.     $clausola_view_fonte_al = (isset($_dati_gen['fonte_al'])) ? "fonte_al='".$_dati_gen['fonte_al']."'," : "";
  1567.     
  1568.     
  1569.     $sql_gen="UPDATE {$db1['frontend']}.registro_tab 
  1570.                 SET orderby='".$_dati_gen['orderby']."', 
  1571.                     orderby_sort='".$_dati_gen['orderby_sort']."', 
  1572.                     visibile='".$_dati_gen['visibile']."',
  1573.                     in_insert='".$_dati_gen['in_insert']."',
  1574.                     in_duplica='".$_dati_gen['in_duplica']."',
  1575.                     in_update='".$_dati_gen['in_update']."',
  1576.                     in_delete='".$_dati_gen['in_delete']."',
  1577.                     in_export='".$_dati_gen['in_export']."',
  1578.                     permetti_allegati='".$_dati_gen['permetti_allegati']."',
  1579.                     permetti_allegati_ins='".$_dati_gen['permetti_allegati_ins']."',
  1580.                     permetti_allegati_del='".$_dati_gen['permetti_allegati_del']."',
  1581.                     permetti_link='".$_dati_gen['permetti_link']."',
  1582.                     permetti_link_ins='".$_dati_gen['permetti_link_ins']."',
  1583.                     permetti_link_del='".$_dati_gen['permetti_link_del']."',
  1584.                     $clausola_view_pk
  1585.                     $clausola_view_fonte_al
  1586.                     data_modifica=".time()."
  1587.                 WHERE id_table=".intval($_dati_gen['oid']);
  1588.     
  1589.     if($_dati_gen['trasversale_gen']=='1'){
  1590.         
  1591.         $q_sub_trasv=vmsql_query("SELECT table_name FROM {$db1['frontend']}.registro_tab WHERE id_table=".intval($_dati_gen['oid']),$link);
  1592.         
  1593.         list($table_name)=vmsql_fetch_row($q_sub_trasv);
  1594.         
  1595.         $sql_gen.=" OR table_name='$table_name'";
  1596.     }
  1597.     
  1598.  
  1599.     
  1600.     $q_gen=vmsql_query($sql_gen,$link);
  1601.     
  1602.     if(vmsql_affected_rows($link,$q_gen)>0){
  1603.         if($_dati_gen['trasversale_gen']=='1'){
  1604.             
  1605.             header("Location: ".$_SERVER['PHP_SELF']."?gid=".$_dati_gen['gid']."&feed=ok_gen_trasversale&det=".$_dati_gen['oid']."&a=1");
  1606.         }
  1607.         else{
  1608.             
  1609.             header("Location: ".$_SERVER['PHP_SELF']."?gid=".$_dati_gen['gid']."&feed=ok_gen&det=".$_dati_gen['oid']."&a=1");
  1610.         }
  1611.     }
  1612.     else{
  1613.         header("Location: ".$_SERVER['PHP_SELF']."?gid=".$_dati_gen['gid']."&feed=ko_gen&det=".$_dati_gen['oid']."&a=1");
  1614.     }
  1615.     
  1616.     exit;
  1617. }
  1618.  
  1619.  
  1620.  
  1621. ###################################################################################################
  1622. #
  1623. ## COPIA IMPOSTAZIONI DEI CAMPI DA UN GUPPO AD UN ALTRO
  1624. #
  1625. if(isset($_POST['copia_campi'])){
  1626.     
  1627.     require_once("./gestione_registro.inc.php");
  1628.     
  1629.     // prendi id_tabella di destinazione
  1630.     $nome_tabella_fonte = oid2name($_POST['det']);
  1631.     $oid_tabella_fonte= name2oid($nome_tabella_fonte,$_POST['copia_campi_gid']);
  1632.     
  1633.     $esito_copia= copia_impostazione_campi($oid_tabella_fonte,$_POST['det']);
  1634.     
  1635.     if($esito_copia)
  1636.         header("Location: ".$_SERVER['PHP_SELF']."?det=".$_POST['det']."&gid=".$_POST['gid']."&a=2&feed=copia_ok");
  1637.     exit;
  1638.     
  1639. }
  1640.  
  1641.  
  1642.  
  1643.  
  1644. ###################################################################################################
  1645. #
  1646. ## COPIA IMPOSTAZIONI DELLE SOTTOMASCHERE DA UN GUPPO AD UN ALTRO
  1647. #
  1648. if(isset($_POST['copia_sottomaschere'])){
  1649.     
  1650.     require_once("./gestione_registro.inc.php");
  1651.     
  1652.     // prendi id_tabella di destinazione
  1653.     $nome_tabella_fonte = oid2name($_POST['det']);
  1654.     $oid_tabella_fonte= name2oid($nome_tabella_fonte,$_POST['copia_sub_gid']);
  1655.     
  1656.     copia_impostazione_sottomaschere($_POST['gid'],$_POST['copia_sub_gid'],$oid_tabella_fonte,$_POST['det']);
  1657.     
  1658.     header("Location: ".$_SERVER['PHP_SELF']."?det=".$_POST['det']."&gid=".$_POST['gid']."&a=3&feed=copia_ok");
  1659.     exit;
  1660.     
  1661. }
  1662.  
  1663.  
  1664.  
  1665.  
  1666.  
  1667. ###################################################################################################
  1668. #
  1669. ## CLONAZIONE IMPOSTAZIONI SOTTOMASCHERE DA TABELLA A VISTA AD ESSA RELATIVA
  1670. #
  1671. if(isset($_POST['clona_sottomaschere_vista'])){
  1672.     
  1673.     require_once("./gestione_registro.inc.php");
  1674.     
  1675.     $ID_TABELLA_ORIGINE= (int) $_POST['id_tabella'];
  1676.     $ID_VISTA_DESTINAZIONE= (int) $_POST['id_vista'];
  1677.     
  1678.     copia_sottomaschere_viste($ID_VISTA_DESTINAZIONE,$ID_TABELLA_ORIGINE);
  1679.     
  1680.     header("Location: ".$_SERVER['PHP_SELF']."?det=".$ID_VISTA_DESTINAZIONE."&gid=".$_GET['gid']."&a=3");
  1681.     exit;
  1682.     
  1683. }
  1684.  
  1685.  
  1686.  
  1687. ###################################################################################################
  1688. #
  1689. ## INSERIMENTO INFO SOTTOMASCHERE DI TABELLA
  1690. #
  1691. if(isset($_POST['sottomaschere'])){
  1692.     
  1693.     require_once("./gestione_registro.inc.php");
  1694.     
  1695.     
  1696.     $_dati_gen=pulisci_dom($_POST);
  1697.     
  1698.     $aff=0;
  1699.     
  1700.     for($i=0;$i<count($_dati_gen['new_submask']);$i++){
  1701.         
  1702.         $esito_inizializzazione_sub = inizializza_sottomaschera($_dati_gen['oid'], oid2name($_dati_gen['new_submask'][$i]));
  1703.     }
  1704.     
  1705.     
  1706.     
  1707.     if($esito_inizializzazione_sub){
  1708.         header("Location: ".$_SERVER['PHP_SELF']."?feed=ok_new_sub&det=".$_dati_gen['oid']."&a=3");
  1709.     }
  1710.     else{
  1711.         header("Location: ".$_SERVER['PHP_SELF']."?feed=ko_new_sub&det=".$_dati_gen['oid']."&a=3");
  1712.     }
  1713.     
  1714.     
  1715.     exit;
  1716. }
  1717.  
  1718.  
  1719. ###################################################################################################
  1720. #
  1721. ## INSERIMENTO INFO CAMPI DELLA  TABELLA
  1722. #
  1723.  
  1724. if(isset($_POST['campo'])){
  1725.     
  1726.     $gid=(int) $_POST['gid'];
  1727.     
  1728.     $campo=pulisci_dom($_POST['campo']);
  1729.     
  1730.     # contatore per le righe coinvolte
  1731.     $affected=0;
  1732.     
  1733.     foreach($campo as $k=>$val){
  1734.         $sql="UPDATE {$db1['frontend']}.registro_col 
  1735.               SET in_visibile='".$val['in_visibile']."',
  1736.               in_richiesto='".$val['in_richiesto']."',
  1737.               in_search='".$val['in_search']."',
  1738.               in_suggest='".$val['in_suggest']."',
  1739.               in_tipo='".$val['in_tipo']."',
  1740.               in_table='".$val['in_table']."'
  1741.                 ";
  1742.                 
  1743.             if(isset($val['tipo_altro'])){
  1744.                 
  1745.                 // Caso selezione tra valori indicati
  1746.                 if($val['in_tipo']=="select"){
  1747.                     $val['tipo_altro']=preg_replace("'\r'","",$val['tipo_altro']);
  1748.                     $val['tipo_altro']=preg_replace("'\n'","[|]",$val['tipo_altro']);
  1749.                 }
  1750.                 
  1751.                 $altro=addslashes(stripslashes($val['tipo_altro']));
  1752.             }
  1753.             else{
  1754.                 $altro="";
  1755.             }
  1756.             
  1757.             if($altro!=""){
  1758.             $sql.=", in_default='".$altro."'
  1759.             ";
  1760.             }
  1761.             
  1762.             if(isset($val['extra']) && $val['in_tipo']=="hidden"){
  1763.                 
  1764.                 $sql.=", extra='".$val['extra']."' ";
  1765.             }
  1766.             
  1767.             
  1768.             $sql.=" WHERE id_reg=".intval($k);
  1769.         
  1770. //            echo $sql;
  1771.             
  1772.             $q_campi=vmsql_query($sql,$link,true);
  1773.             
  1774.             $affected+= vmsql_affected_rows($link,$q_campi);
  1775.             
  1776.         }
  1777.         
  1778.         
  1779.     
  1780.     
  1781.     if($affected>0){
  1782.         header("Location: ".$_SERVER['PHP_SELF']."?gid=$gid&feed=ok_campi&det=".intval($_POST['oid'])."&a=2");
  1783.     }
  1784.     else{
  1785.         header("Location: ".$_SERVER['PHP_SELF']."?gid=$gid&feed=ko_campi&det=".intval($_POST['oid'])."&a=2");
  1786.     }
  1787.         
  1788.     
  1789.     exit;
  1790. }
  1791.  
  1792. ###############################################################################################
  1793. #
  1794. #        MODIFICA IMPOSTAZIONI GENERALI DELLA SOTTOMASCHERA
  1795. #
  1796. #
  1797.  
  1798. if(isset($_GET['mod_sub_gen']) && isset($_POST['sub_gen'])){
  1799.     
  1800.     
  1801.     $dati_gen_sub =    pulisci_dom($_POST['sub_gen']);
  1802.     
  1803.     $sql_update_sub = sprintf("UPDATE ".$db1['frontend'].".registro_submask 
  1804.                        SET sub_select=%d,
  1805.                         sub_insert=%d,
  1806.                         sub_update=%d,
  1807.                         sub_delete=%d,
  1808.                         nome_frontend='%s',
  1809.                         campo_pk_parent='%s',
  1810.                         campo_fk_sub='%s',
  1811.                         orderby_sub='%s',
  1812.                         orderby_sub_sort='%s',
  1813.                         max_records=%d,
  1814.                         data_modifica='%d',
  1815.                         tipo_vista='%s'
  1816.                        
  1817.                        WHERE id_submask=%d
  1818.                                            
  1819.                        ",
  1820.                         $dati_gen_sub['sub_select'],
  1821.                         $dati_gen_sub['sub_insert'],
  1822.                         $dati_gen_sub['sub_update'],
  1823.                         $dati_gen_sub['sub_delete'],
  1824.                         $dati_gen_sub['nome_frontend'],
  1825.                         $dati_gen_sub['sub_pk_parent'],
  1826.                         $dati_gen_sub['sub_fk_this'],
  1827.                         $dati_gen_sub['orderby_sub'],
  1828.                         $dati_gen_sub['orderby_sub_sort'],
  1829.                         $dati_gen_sub['max_records'],
  1830.                         time(),
  1831.                         $dati_gen_sub['tipo_vista'],
  1832.                         $dati_gen_sub['id_submask']);
  1833.                         
  1834.     $q_sub_up=vmsql_query($sql_update_sub,$link);
  1835.     
  1836.     $aff_sub_upd=vmsql_affected_rows($link,$q_sub_up);
  1837.     
  1838.     if($aff_sub_upd>0){
  1839.         header("Location: ".$_SERVER['PHP_SELF']."?gid=$gid&feed=ok_sub_upd&det=".intval($dati_gen_sub['oid'])."&conf_sub=".intval($dati_gen_sub['id_submask'])."&a=3");
  1840.     }
  1841.     else{
  1842.         header("Location: ".$_SERVER['PHP_SELF']."?gid=$gid&feed=ko_sub_upd&det=".intval($dati_gen_sub['oid'])."&conf_sub=".intval($dati_gen_sub['id_submask'])."&a=3");
  1843.     }
  1844.     
  1845.     
  1846.     
  1847.     exit;
  1848. }
  1849.  
  1850.  
  1851. #############################################################
  1852. #
  1853. #    MODIFICA CAMPI DELLA SOTTOMASCHERA
  1854. #
  1855. #
  1856.  
  1857. if(isset($_GET['mod_sub_campi'])){
  1858.     
  1859.     
  1860.     $campo_sub=pulisci_dom($_POST['campo_sub']);
  1861.     
  1862.     
  1863.     $gid=(int) $_GET['gid'];
  1864.     
  1865.     $ID_SUBMASK = (int) $_POST['id_submask'];
  1866.     
  1867.     
  1868.     
  1869.     # contatore per le righe coinvolte
  1870.     $affected=0;
  1871.     
  1872.     vmsql_begin($link);
  1873.     
  1874.     foreach($campo_sub as $k=>$val){
  1875.         $sql="UPDATE {$db1['frontend']}.registro_submask_col
  1876.               SET in_visibile='".$val['in_visibile']."',
  1877.               in_richiesto='".$val['in_richiesto']."',
  1878.               in_tipo='".$val['in_tipo']."'
  1879.                 ";
  1880.                 
  1881.             if(isset($val['tipo_altro'])){
  1882.                 
  1883.                 // Caso selezione tra valori indicati
  1884.                 if($val['in_tipo']=="select"){
  1885.                     $val['tipo_altro']=preg_replace("'\r'","",$val['tipo_altro']);
  1886.                     $val['tipo_altro']=preg_replace("'\n'","[|]",$val['tipo_altro']);
  1887.                 }
  1888.                 
  1889.                 $altro=addslashes(stripslashes($val['tipo_altro']));
  1890.             }
  1891.             elseif(isset($val['in_default'])){
  1892.                 
  1893.                 $altro=$val['in_default'];
  1894.             }
  1895.             else{
  1896.                 $altro="";
  1897.             }
  1898.             
  1899.             if($altro!="")
  1900.             $sql.=", in_default='".$altro."'
  1901.             ";
  1902.             
  1903.             $sql.=" WHERE id_reg_sub=".intval($k);
  1904.         
  1905. //            echo "\n\n$sql\n\n";
  1906.             
  1907.             $q_campi=vmsql_query($sql,$link,true);
  1908.             
  1909.             $affected+= vmsql_affected_rows($link,$q_campi);
  1910.         }
  1911.         
  1912.         
  1913.         
  1914.         
  1915.         if($affected>0){
  1916.             vmsql_commit($link);
  1917.             header("Location: ".$_SERVER['PHP_SELF']."?gid=$gid&feed=ok_sub_upd&det=".intval($_POST['oid'])."&conf_sub=".intval($_POST['id_submask'])."&a=3");
  1918.         }
  1919.         else{
  1920.             
  1921.             vmsql_rollback($link);
  1922.             header("Location: ".$_SERVER['PHP_SELF']."?gid=$gid&feed=ko_sub_upd&det=".intval($_POST['oid'])."&conf_sub=".intval($_POST['id_submask'])."&a=3");
  1923.         }
  1924.         
  1925.     
  1926.     exit;
  1927.     
  1928.     
  1929. }
  1930.  
  1931.  
  1932.  
  1933. # Funzioni di modifica di massa
  1934. if(isset($_GET['mass']) && is_numeric($_GET['gid'])){
  1935.     
  1936.     
  1937.     
  1938.     switch($_GET['mass']){
  1939.     
  1940.         case 'visibile_all': 
  1941.             $q_mass=vmsql_query("UPDATE {$db1['frontend']}.registro_tab SET visibile=1 WHERE gid=".intval($_GET['gid']),$link);
  1942.             $esito=vmsql_affected_rows($link,$q_mass);
  1943.         break;
  1944.     
  1945.         case 'visibile_none': 
  1946.             $q_mass=vmsql_query("UPDATE {$db1['frontend']}.registro_tab SET visibile=0 WHERE gid=".intval($_GET['gid']),$link);
  1947.             $esito=vmsql_affected_rows($link,$q_mass);
  1948.         break;
  1949.     
  1950.         case 'insert_all': 
  1951.             $q_mass=vmsql_query("UPDATE {$db1['frontend']}.registro_tab SET in_insert=1 WHERE gid=".intval($_GET['gid']),$link);
  1952.             $esito=vmsql_affected_rows($link,$q_mass);
  1953.         break;
  1954.     
  1955.         case 'insert_none': 
  1956.             $q_mass=vmsql_query("UPDATE {$db1['frontend']}.registro_tab SET in_insert=0 WHERE gid=".intval($_GET['gid']),$link);
  1957.             $esito=vmsql_affected_rows($link,$q_mass);
  1958.         break;
  1959.     
  1960.         case 'update_all': 
  1961.             $q_mass=vmsql_query("UPDATE {$db1['frontend']}.registro_tab SET in_update=1 WHERE gid=".intval($_GET['gid']),$link);
  1962.             $esito=vmsql_affected_rows($link,$q_mass);
  1963.         break;
  1964.     
  1965.         case 'update_none': 
  1966.             $q_mass=vmsql_query("UPDATE {$db1['frontend']}.registro_tab SET in_update=0 WHERE gid=".intval($_GET['gid']),$link);
  1967.             $esito=vmsql_affected_rows($link,$q_mass);
  1968.         break;
  1969.     
  1970.         case 'delete_all': 
  1971.             $q_mass=vmsql_query("UPDATE {$db1['frontend']}.registro_tab SET in_delete=1 WHERE gid=".intval($_GET['gid']),$link);
  1972.             $esito=vmsql_affected_rows($link,$q_mass);
  1973.         break;
  1974.     
  1975.         case 'delete_none': 
  1976.             $q_mass=vmsql_query("UPDATE {$db1['frontend']}.registro_tab SET in_delete=0 WHERE gid=".intval($_GET['gid']),$link);
  1977.             $esito=vmsql_affected_rows($link,$q_mass);
  1978.         break;
  1979.     
  1980.     }
  1981.     
  1982.     if(isset($esito) && $esito>0){
  1983.         
  1984.         header("Location: ".$_SERVER['PHP_SELF']."?gid=".intval($_GET['gid'])."&feed=ok_mass");
  1985.         exit;
  1986.     }
  1987.     
  1988. }
  1989.  
  1990. // -- Fine funzioni modifica di massa
  1991.  
  1992. if(isset($_POST['id_del_submask'])){
  1993.     
  1994.     // elimina la sottomaschera
  1995.     
  1996.     $q=vmsql_query("DELETE FROM ".$db1['frontend'].".registro_submask WHERE id_submask=".intval($_POST['id_del_submask']),$link);
  1997.     
  1998.     header("Location: ".$_SERVER['PHP_SELF']."?det=".intval($_POST['oid'])."&gid=".intval($_POST['gid'])."&a=3");
  1999.     exit;
  2000. }
  2001.  
  2002.  
  2003.  
  2004.  
  2005.  
  2006. if(isset($_GET['det']) && (int) $_GET['det']>0){
  2007.     
  2008.     // mostra i dettagli della tabella
  2009.     $oid= (int) $_GET['det'];
  2010.     tab_dett($oid,$_GET['gid']);
  2011. }
  2012. else{
  2013.     
  2014.     $gid= (int) $_GET['gid'];
  2015.     
  2016.     // se è selezionato l'ordine
  2017.     if(isset($_GET['ord'])) {
  2018.         
  2019.         tab_menu($gid,intval($_GET['ord']));  
  2020.     }
  2021.     else{
  2022.         
  2023.         tab_menu($gid);  
  2024.     }
  2025.     
  2026.     // mostra la lista tabelle
  2027.     
  2028. }
  2029.  
  2030.  
  2031. ?>
Documentation generated on Sat, 22 Sep 2007 11:50:39 +0200 by phpDocumentor 1.4.0a2