Visualizza post
Questa sezione ti permette di visualizzare tutti i post inviati da questo utente. N.B: puoi vedere solo i post relativi alle aree dove hai l'accesso.
<div class="form_item">
<div class="form_element cf_text"> <span class="cf_text">FORM PER RICHIESTA PREVENTIVO/OFFERTA/INCONTRO</span> <>
<div class="clear"> <>
<>
<div class="form_item">
<div class="form_element cf_textbox">
<label class="cf_label">Nome</label>
<input class="cf_inputbox" maxlength="150" size="30" id="text_3" name="nome" type="text" />
<>
<div class="clear"> <>
<>
<div class="form_item">
<div class="form_element cf_textbox">
<label class="cf_label">Cognome</label>
<input class="cf_inputbox" maxlength="150" size="30" id="text_4" name="cognome" type="text" />
<>
<div class="clear"> <>
<>
<div class="form_item">
<div class="form_element cf_textbox">
<label class="cf_label">Azienda</label>
<input class="cf_inputbox" maxlength="150" size="30" id="text_5" name="azienda" type="text" />
<>
<div class="clear"> <>
<>
<?php
$db =& JFactory::getDBO();
$query = "
SELECT `id`, `regione`
FROM `#__regioni` ORDER BY `regione`";
$db->setQuery($query);
$nomes = $db->loadAssocList();
$option_reg="";
foreach ( $nomes as $v ) {
$selected="";
$id = $v['id'];
$regione = $v['regione'];
if ($id==JRequest::getVar('regione',0,'GET','INT')) {
$selected="selected=\"selected\"";
}
$option_reg.="<option value=\"$id\" $selected>$regione</option>\n";
}
$query = "
SELECT `id`, `provincia`
FROM `#__province` WHERE `id_regione`=".JRequest::getVar('regione',0,'GET','INT')." ORDER BY `provincia`";
$db->setQuery($query);
$nomes = $db->loadAssocList();
$option_pro="";
foreach ( $nomes as $v ) {
$selected="";
$id = $v['id'];
$province = $v['provincia'];
if ($id==JRequest::getVar('provincia',0,'GET','INT')) {
$selected="selected='selected'";
}
$option_pro.="<option value=\"$id\" $selected>$province</option>\n";
}
$query = "
SELECT `id`, `comune`
FROM `#__comuni` WHERE `id_provincia`=".JRequest::getVar('provincia',0,'GET','INT')." ORDER BY `comune`";
$db->setQuery($query);
$nomes = $db->loadAssocList();
$option_com="";
foreach ( $nomes as $v ) {
$id = $v['id'];
$comune = $v['comune'];
$option_com.="<option value=\"$id\" $selected>$comune</option>\n";
}
$query = "
SELECT `id`, `mailre`
FROM `#__mailre` WHERE `id_regione`=".JRequest::getVar('regione',0,'GET','INT')." ORDER BY `mailre`";
$db->setQuery($query);
$nomes = $db->loadAssocList();
$option_ma="";
foreach ( $nomes as $v ) {
$selected="";
$id = $v['id'];
$mailre = $v['mailre'];
if ($id==JRequest::getVar('mailre',0,'GET','INT')) {
}
$option_ma.="<option value=\"$id\" $selected>$mailre</option>\n";
}
?>
<div class="form_item">
<div class="form_element cf_dropdown">
<div style="clear:both;"><label class="cf_label">Regioni</label>
<select id="regione" name="regione" onchange="province(this.form);" class="cf_inputbox validate-selection" ><option value="" selected="selected">Seleziona</option>
<?php echo $option_reg; ?>
</select>
<>
<>
<div class="cfclear"> <>
<>
<div class="form_item">
<div class="form_element cf_dropdown">
<div style="clear:both;"><label class="cf_label">Provincie</label>
<select id="provincia" name="provincia" onChange="reload(this.form);" class="cf_inputbox validate-selection" ><option value="" selected="selected">Seleziona</option>
<?php echo $option_pro; ?>
</select>
<>
<>
<div class="cfclear"> <>
<>
<div class="form_item">
<div class="form_element cf_dropdown">
<div style="clear:both;"><label class="cf_label">Comuni</label>
<select id="comune" name="comune" class="cf_inputbox validate-selection" ><option value="" selected="selected">Seleziona</option>
<?php echo $option_com; ?>
</select>
<>
<>
<div class="cfclear"> <>
<>
<div class="form_item">
<div class="form_element cf_textbox">
<label class="cf_label">mailre</label>
<select id="mailre" name="mailre" class="cf_inputbox validate-selection" >
<?php echo $option_ma; ?>
</select>
<>
<>
<div class="cfclear"> <>
<>
<div class="clear"> <>
<>
<div class="form_element cf_textbox">
<label class="cf_label">Telefono</label>
<input class="cf_inputbox validate-number" maxlength="150" size="30" id="text_10" name="telefono" type="text" />
<>
<div class="clear"> <>
<>function province(form)
{
var reg=form.regione.options[form.regione.options.selectedIndex].value;
self.location='index.php?option=com_chronocontact&chronoformname=offerte_reg_prov_com®ione=' + reg ;
}
function reload(form)
{
var prov=form.provincia.options[form.provincia.options.selectedIndex].value;
var reg=form.regione.options[form.regione.options.selectedIndex].value;
self.location='index.php?option=com_chronocontact&chronoformname=offerte_reg_prov_com&provincia=' + prov + '®ione=' + reg;}
Il campo va letto dal database dopo la scelta della regione e poi assegnato ad un campo nascosto.
Nel dinamic to userai il nome del campo nascosto.
Si è possibile associando nella tabella province ad ogni provincia un'email, ed utilizzando poi tale valore nel campo Dynamic to.Scusami ma non sono un fenomeno. La cosa dovrei farla associata alla Regione e non più alla provincia.
|
|