nuBuilder Forum

Code: Select all

function nuSubformRefreshSelectObject(prefix, selectId, formId, removeBlank) {

   if (typeof formId === 'undefined') {
      var formId = '';
   }

   nuSetProperty('nurefreshselectobject_prefix',prefix);
   nuSetProperty('nurefreshselectobject_selectid',selectId);
   nuSetProperty('nurefreshselectobject_formid',formId);
   nuSetProperty('nurefreshselectobject_removeblank',removeBlank === true ? '1' : '0');

   nuRunPHPHidden('nurefreshselectobject', 0);

}

function nuSubformPrefix(t, id){
    return  $(t).attr('data-nu-prefix');
}

function pne_marcaOnChanged(t) {
   nuSetProperty('VALUE_SELECT1',nuSubformValue(t, 'pne_marca'));
   nuSubformRefreshSelectObject(nuSubformPrefix(t, 'pne_marca'),  'pne_modello', '64d287f80aea206'); // <---- Replace with the the subform's primary key (15-characters unique id)
 
   let pne_modello = t.id.replace('pne_marca','pne_modello');
   $('#'+ pne_modello).nuEnable();
}

$('[id^=Sf_pneumatici][id$=pne_modello]').each(function(i,v){  // <---- replace 'subform' with the object id of your subform
   $(this).attr('data-value', this.value);
});

$('[id^=Sf_pneumatici][id $=pne_marca]').each(function(i,v){ // <---- replace 'subform' with the object id of your subform
   pne_marcaOnChanged(this)
});

function nuBeforeSave() {
  nuSetProperty('VALUE_SELECT1','##');
  return true;
}

function nuSelectObjectRefreshed(formId, selectId, count) {
   let pne_modello = selectId.replace('pne_marca','pne_modello');
   $('#'+ pne_modello).val($('#' + pne_modello).attr('data-value'));
}

Code: Select all

SELECT
 t_modelli.mod_modello,t_modelli.mod_modello
    

FROM
    t_modelli
        JOIN t_marche ON t_modelli.mod_id_marca = t_marche.mar_id

WHERE
      (t_marche.mar_marca = '#VALUE_SELECT1#' OR '#VALUE_SELECT1#' LIKE '#%' );

Code: Select all

pne_marcaOnChanged(this);