nuBuilder Forum

Code: Select all

function addDelCmd(event){
    var id = event.target.parentNode.id;
    var pk = $('#' + String(id)).attr('data-nu-primary-key');

    if (pk == '-1') {
    var r1 = nuCurrentProperties().record_id;
    nuSetProperty('ECHI_COMANDA_ID', r1, 0);
                    nuPopup('617efff03300f00', '', '');   //subform FF6

    //    nuClosePopup();
    
    } else {
        nuSetProperty('deleteRow_record_id', pk);
        nuRunPHPHidden("deleteComanda", 1);
            }
}

function afterDeleteRow() {
    nuSearchAction();
}

Code: Select all

$pk = "#deleteRow_record_id#";

$qry = "UPDATE echiplucrare SET echi_comanda_id = '' WHERE echiplucrare.echiplucrare_id = '$pk';";
nuRunQuery($qry);

// The function afterDeleteRow() must be declared in the form's Custom Code 
$j = "afterDeleteRow();";
nuJavascriptCallback($j);

Code: Select all

$pk1 = "#ECHIPLUCRARE_ID#";
$pk2 = "#ECHI_COMANDA_ID#";
//nuDebug($pk1, $pk2);
nuDebug(nuHash());

$qry = "UPDATE echiplucrare SET echi_comanda_id = '$pk2' WHERE echiplucrare.echiplucrare_id = '$pk1';";
nuRunQuery($qry);

// The function afterDeleteRow() must be declared in the form's Custom Code 
$j = "afterDeleteRow();";
//nuJavascriptCallback($j);

Code: Select all

function nuSelectBrowse(e){ 
        var r = $('#' + e.target.id).attr('data-nu-primary-key');
        nuSetProperty('ECHIPLUCRARE_ID', r);
        nuRunPHPHidden("AddCmd", 0);
        nuRunPHPHidden("AddCmd", 0);
        nuClosePopup();
    }

Code: Select all

[0] : Array
(
    [USER_ID] => globeadmin
    [USER_GROUP_ID] => 
    [HOME_ID] => nuhome
    [GLOBAL_ACCESS] => 1
    [ACCESS_LEVEL_CODE] => 
    [LOGIN_NAME] => globeadmin
    [USER_NAME] => 
    [USER_DEPARTMENT] => 
    [USER_TEAM] => 
    [USER_POSITION] => 
    [USER_ADDITIONAL1] => 
    [USER_ADDITIONAL2] => 
    [LANGUAGE] => Romanian
    [form_id] => 617efff03300f00
    [redirect_form_id] => 617efff03300f00
    [record_id] => 
    [title] => Fast Form 6
    [call_type] => 
    [column_widths] => 
    [filter] => 
    [forms] => 
    [iframe] => 0
    [lookup_id] => 
    [object_id] => 1
    [page_number] => 0
    [password] => 
    [rows] => 8
    [row_height] => 18
    [search] => 
    [session_id] => s16378231202823
    [nosearch_columns] => 
    [sort] => -1
    [sort_direction] => desc
    [subforms] => 0
    [tab_start] => 
    [username] => 
    [user_id] => globeadmin
    [refreshed] => 0
    [CLONED_RECORD] => 0
    [NEW_RECORD] => 0
    [redirect_other_form_id] => 
    [browse_columns] => 
    [browse_sql] => SELECT echiplucrare_id,echi_desc,echi_manifestare,str_1,amb_nr,comp_mic,echi_termen,luc_adresa_nr,luc_adresa_data,com_nr,com_data_start,echi_comanda_id
 FROM     echiplucrare         LEFT JOIN lucrare ON echiplucrare.echi_lucrare_id = lucrare.lucrare_id         LEFT JOIN comanda ON echiplucrare.echi_comanda_id = comanda.comanda_id         LEFT JOIN compartiment ON echiplucrare.echi_compartiment_id = compartiment.compartiment_id         LEFT JOIN ambarcatiune ON echiplucrare.echi_ambarcatiune_id = ambarcatiune.ambarcatiune_id         LEFT JOIN structura ON echiplucrare.echi_structura_id = structura.structura_id
WHERE 1
    [browse_rows] => 
    [browse_table_id] => ___nu1619f32a401ce1___
    [browse_filtered_rows] => 9
    [browse_title_multiline] => 1
    [pages] => 2
    [form_code] => FF6
    [form_description] => Fast Form 6
    [form_type] => browseedit
    [run_code] => 
    [run_description] => 
    [data_mode] => 
    [ECHIPLUCRARE_ID] => 61804cfa2b3e394
    [hash_record_id] => 
    [nuFORMdata] => Array
        (
            [0] => stdClass Object
                (
                    [id] => nuBuilder4EditForm
                    [foreign_key] => 
                    [primary_key] => echiplucrare_id
                    [object_id] => 617efff03300f00
                    [table] => echiplucrare
                    [action] => save
                    [rows] => Array
                        (
                            [0] => Array
                                (
                                    [0] => 
                                    [1] => 0
                                )

                        )

                    [columns] => 
                    [chartData] => 
                    [chartDataPivot] => 
                    [edited] => Array
                        (
                            [0] => Array
                                (
                                    [0] => 0
                                    [1] => 0
                                )

                        )

                    [deleted] => Array
                        (
                            [0] => 0
                        )

                    [fields] => Array
                        (
                            [0] => ID
                            [1] => nuDelete
                        )

                )

        )

    [hash] => 
    [ID] => 
    [nuDelete] => 0
    [PREVIOUS_RECORD_ID] => AddCmd
    [RECORD_ID] => AddCmd
    [FORM_ID] => doesntmatter
    [SUBFORM_ID] => 1
    [CODE] => 
    [TABLE_ID] => ___nu1619f32a622ed4___
    [SESSION_ID] => s16378231202823
)

Code: Select all

  nuSetProperty('ECHI_COMANDA_ID', r1, true);

Code: Select all

nuJavascriptCallback("nuClosePopup();");

Code: Select all

nuJavascriptCallback("parent.nuGetBreadcrumb()");