HOW To copy - from repetible to non repetible dropdwon element

[javier94]

in one list in a repetible group i have this 2 elements

confirmacio is a radiobutton, yes/no
motiu is a dropdown, 4-5 options
(and both elements you can repeat till 5 times in the repetible)

in other list and table.. i have the same element but in a non repetible group

for confirmacio element I created

and for motiu element



My dubts are ;
1.- is the same code to copy a dropdown or radio button element?

In the code I'm trying as you can see; for a dropdown status 2 copy datas from list candidats_pre_inscripcions --> to --> esmenes_reclamacions
where we have a group with 4 elements inside of repeteable group

titol_requisit_ (field element --> copy working)
descripcio_requisit_ (field element --> copy working)
motiu_requisit_ (dropdown element --> copy not working)
confirmacio_requisit_ (radiobutton element --> copy not working)


Would you help me /show me, how to copy from repetible element to no repetible element
i need only for
motiu_requisit_1
confirmacio_requisit_1



====================
elseif ($status === "2"){ //Reclamacions-lista-50
// Check si existe registro de en 50 Reclamacions-ista-50
$count = 0;
$query = "SELECT COUNT(*) FROM esmenes_reclamacions WHERE codigo_oferta = '" . $codigo_oferta . "' AND CANDIDATE_ID = '" . $CANDIDATE_ID ."'";
$db->setQuery($query);
$count = $db->loadResult();

if(intval($count) == 0){

$InsertQuery ="INSERT INTO esmenes_reclamacions (";

$i = 0;
foreach ($titols as $key => $titol)
{
$i += 1;
$field_titol = "titol_requisit_" . $i;
$InsertQuery.= $field_titol . ", ";
}
$i = 0;
foreach ($descrs as $key => $descr)
{
$i += 1;
$field_descr = 'descripcio_requisit_' . $i;
$InsertQuery.= $field_descr . ", ";
}
//Motiu
$i = 0;
foreach ($motius as $key => $motiu)
{
$i += 1;
$field_motiu = "motiu_requisit_" . $i;
$InsertQuery.= $field_motiu . ", ";
}
//Confirmacions
$i = 0;
foreach ($confirmacions as $key => $confirm)
{
$i += 1;
$field_descr = 'confirmacio_requisit_' . $i;
$InsertQuery.= $field_descr . ", ";
}
$InsertQuery.="CANDIDATE_ID, ";
$InsertQuery.="selec_id, ";
$InsertQuery.="tipus_de_proces, ";
$InsertQuery.="organisme, ";
$InsertQuery.="Grup, ";
$InsertQuery.="nombre_persones, ";
$InsertQuery.="es_necessita, ";
$InsertQuery.="departament, ";
$InsertQuery.="tipus_lloc, ";
$InsertQuery.="tipus_contracte, ";
$InsertQuery.="horari, ";
$InsertQuery.="salari, ";
$InsertQuery.="codigo_oferta, ";
$InsertQuery.="adjuntar_curriculum, ";
$InsertQuery.="tabla_criterios_valoracio, ";
// $InsertQuery.="descripcio_breu, ";
$InsertQuery.="status_requisits, ";
$InsertQuery.="inici_reclamacions, ";
$InsertQuery.="fi_reclamacions, ";
$InsertQuery.="random_number, ";
$InsertQuery.="cuota_reserva_discapacitat, ";
$InsertQuery.="requereix_adapatacio_per, ";
$InsertQuery.="titol_requisit_taxa, ";
$InsertQuery.="descripcio_requisit_taxa, ";
//$InsertQuery.="arxiu_requisit_taxa, ";
$InsertQuery.="confirmacio_taxa, ";
$InsertQuery.="motiu_taxa, ";
$InsertQuery.="titol_requisit_idioma, ";
$InsertQuery.="descripcio_requisit_idioma, ";
//$InsertQuery.="arxiu_requisit_idioma, ";
$InsertQuery.="confirmacio_idioma, ";
$InsertQuery.="motiu_idioma ";
//$InsertQuery.="titol_requisit_1, ";
//$InsertQuery.="descripcio_requisit_1, ";
//$InsertQuery.="arxiu_requisit_1, ";
//$InsertQuery.="confirmacio_requisit_1, ";
//$InsertQuery.="motiu_requisit_1, ";
//$InsertQuery.="titol_requisit_2, ";
//$InsertQuery.="descripcio_requisit_2, ";
//$InsertQuery.="arxiu_requisit_2, ";
//$InsertQuery.="confirmacio_requisit_2, ";
//$InsertQuery.="motiu_requisit_2, ";
//$InsertQuery.="titol_requisit_3, ";
//$InsertQuery.="descripcio_requisit_3, ";
//$InsertQuery.="arxiu_requisit_3, ";
//$InsertQuery.="confirmacio_requisit_3, ";
//$InsertQuery.="motiu_requisit_3, ";
//$InsertQuery.="titol_requisit_4, ";
//$InsertQuery.="descripcio_requisit_4, ";
//$InsertQuery.="arxiu_requisit_4, ";
//$InsertQuery.="confirmacio_requisit_4, ";
//$InsertQuery.="motiu_requisit_4, ";
//$InsertQuery.="titol_requisit_5, ";
//$InsertQuery.="descripcio_requisit_5, ";
//$InsertQuery.="arxiu_requisit_5, ";
//$InsertQuery.="confirmacio_requisit_5, ";
//$InsertQuery.="motiu_requisit_5 ";

//$InsertQuery = substr($InsertQuery, 0, -1); // Eliminamos el último char que en este caso es una ","

$InsertQuery.=") VALUES (";

foreach ($titols as $key => $titol){ $InsertQuery.= $db->quote($titol) . ", "; }
foreach ($descrs as $key => $descr){ $InsertQuery.= $db->quote($descr) . ", "; }
foreach ($motius as $key => $motiu){ $InsertQuery.= $db->quote($motiu) . ", "; }
foreach ($confirmacions as $key => $confirm){ $InsertQuery.= $db->quote($confirm) . ", "; }
// $InsertQuery.="'$ID_current_user', ";
$InsertQuery.="'{candidats_pre_inscripcions___CANDIDATE_ID}', ";
$InsertQuery.="'{candidats_pre_inscripcions___selec_id}', ";
$InsertQuery.="'{candidats_pre_inscripcions___tipus_de_proces}', ";
$InsertQuery.="'{candidats_pre_inscripcions___organisme}', ";
$InsertQuery.="'{candidats_pre_inscripcions___Grup}', ";
$InsertQuery.="'{candidats_pre_inscripcions___nombre_persones}', ";
$InsertQuery.="'{candidats_pre_inscripcions___es_necessita}', ";
$InsertQuery.="'{candidats_pre_inscripcions___departament}', ";
$InsertQuery.="'{candidats_pre_inscripcions___tipus_lloc}', ";
$InsertQuery.="'{candidats_pre_inscripcions___tipus_contracte}', ";
$InsertQuery.="'{candidats_pre_inscripcions___horari}', ";
$InsertQuery.="'{candidats_pre_inscripcions___salari}', ";
$InsertQuery.="'{candidats_pre_inscripcions___codigo_oferta}', ";
$InsertQuery.="'{candidats_pre_inscripcions___adjuntar_curriculum}', ";
$InsertQuery.="'{candidats_pre_inscripcions___tabla_criterios_valoracio}', ";
// $InsertQuery.="'{candidats_pre_inscripcions___descripcio_breu}', ";
$InsertQuery.="'{candidats_pre_inscripcions___status_requisits}', ";
$InsertQuery.="'{candidats_pre_inscripcions___inici_reclamacions}', ";
$InsertQuery.="'{candidats_pre_inscripcions___fi_reclamacions}', ";
$InsertQuery.="'{candidats_pre_inscripcions___random_number}', ";
$InsertQuery.="'{candidats_pre_inscripcions___cuota_reserva_discapacitat}', ";
$InsertQuery.="'{candidats_pre_inscripcions___requereix_adapatacio_per}', ";
$InsertQuery.="'{candidats_pre_inscripcions___titol_requisit_taxa}', ";
$InsertQuery.="'{candidats_pre_inscripcions___descripcio_requisit_taxa}', ";
//$InsertQuery.="'{candidats_pre_inscripcions___arxiu_requisit_taxa}', ";
$InsertQuery.="'{candidats_pre_inscripcions___confirmacio_taxa}', ";
$InsertQuery.="'{candidats_pre_inscripcions___motiu_taxa}', ";
$InsertQuery.="'{candidats_pre_inscripcions___titol_requisit_idioma}', ";
$InsertQuery.="'{candidats_pre_inscripcions___descripcio_requisit_idioma}', ";
//$InsertQuery.="'{candidats_pre_inscripcions___arxiu_requisit_idioma}', ";
$InsertQuery.="'{candidats_pre_inscripcions___confirmacio_idioma}', ";
$InsertQuery.="'{candidats_pre_inscripcions___motiu_idioma}' ";
//$InsertQuery.="'{candidats_pre_inscripcions___titol_requisit_1}', ";
//$InsertQuery.="'{candidats_pre_inscripcions___descripcio_requisit_1}', ";
//$InsertQuery.="'{candidats_pre_inscripcions___arxiu_requisit_1}', ";
//$InsertQuery.="'{candidats_pre_inscripcions___confirmacio_requisit_1}', ";
//$InsertQuery.="'{candidats_pre_inscripcions___motiu_requisit_1}', ";
//$InsertQuery.="'{candidats_pre_inscripcions___titol_requisit_2}', ";
//$InsertQuery.="'{candidats_pre_inscripcions___descripcio_requisit_2}', ";
//$InsertQuery.="'{candidats_pre_inscripcions___arxiu_requisit_2}', ";
//$InsertQuery.="'{candidats_pre_inscripcions___confirmacio_requisit_2}', ";
//$InsertQuery.="'{candidats_pre_inscripcions___motiu_requisit_2}', ";
//$InsertQuery.="'{candidats_pre_inscripcions___titol_requisit_3}', ";
//$InsertQuery.="'{candidats_pre_inscripcions___descripcio_requisit_3}', ";
//$InsertQuery.="'{candidats_pre_inscripcions___arxiu_requisit_3}', ";
//$InsertQuery.="'{candidats_pre_inscripcions___confirmacio_requisit_3}', ";
//$InsertQuery.="'{candidats_pre_inscripcions___motiu_requisit_3}', ";
//$InsertQuery.="'{candidats_pre_inscripcions___titol_requisit_4}', ";
//$InsertQuery.="'{candidats_pre_inscripcions___descripcio_requisit_4}', ";
//$InsertQuery.="'{candidats_pre_inscripcions___arxiu_requisit_4}', ";
//$InsertQuery.="'{candidats_pre_inscripcions___confirmacio_requisit_4}', ";
//$InsertQuery.="'{candidats_pre_inscripcions___motiu_requisit_4}', ";
//$InsertQuery.="'{candidats_pre_inscripcions___titol_requisit_5}', ";
//$InsertQuery.="'{candidats_pre_inscripcions___descripcio_requisit_5}', ";
//$InsertQuery.="'{candidats_pre_inscripcions___arxiu_requisit_5}', ";
//$InsertQuery.="'{candidats_pre_inscripcions___confirmacio_requisit_5}', ";
//$InsertQuery.="'{candidats_pre_inscripcions___motiu_requisit_5}' ";

//foreach ($titols as $key => $titol){ $InsertQuery.= $db->quote($titol) . ", "; }
//foreach ($descrs as $key => $descr){ $InsertQuery.= $db->quote($descr) . ", "; }

//$InsertQuery = substr($InsertQuery, 0, -1); // Eliminamos el último char que en este caso es una ","

$InsertQuery.=")";

var_dump($InsertQuery); exit;

$db->setQuery($InsertQuery);
$db->query();
}
}
//-------

thanks in advance!!

Javier

 

[troester]

Data of repeat groups is stored in additional ...._repeat_.... tables (see your element names) with a column parent_id pointing to the main record.

 

[javier94]

ok.. now i find the code.. thanks!