How to move Insert,delete,update from the left to the right column in editable grid.

Scriptcase 8 Discussion
#1

After much searching I could not find a solution to position the insert,update,delete column that is by default on the left 1st column. so after solving I thought I would share how to do.

you will have to make a virtual field mark as label and position far right.

put this code in OnScriptini.

echo "
<script>
$(document).ready( function() {

$(’[id^=“hidden_field_data_sc_actions”]’).each(function(){

var id = $(this).attr(‘id’).replace(/[^0-9]+/i,’’);

$(this).parent().children().last().remove();
$(this).parent().prepend(’<td></td>’);
$(this).appendTo($(this).parent());
});

var timer = 0;
$(’#sc_b_new_t’).click(function() {

do_ajax_form_your_form_name();

timer = setInterval( function() {

$(’[id^=“sc_ins_line_”]’).each(function(){

var id = $(this).attr(‘id’).replace(/[^0-9]+/i,’’);

var td =$(this).parent();

td.parent().children().last().remove();
td.parent().prepend(’<td></td>’);
td.appendTo(td.parent());
clearInterval(timer);
});

}, 5);

});

});

</script>
";

Then in Onafterinsert

sc_commit_trans()

sc_redir(your_form_here);

hope this may be of use to someone.

#2

Good post, i think some times is neccesary do it changes. (i posted with same problem some time ago but now i can see you solve it).

#3

Hello Naresh,

I have made some improvements after writing this. new script is this

echo "
<script>
$(document).ready( function() {

var fcremoved = false;
$('[id^="hidden_field_data_sc_actions"]').each(function(){

    if (!fcremoved) {
        $(this).parent().parent().children().first().children().first().remove();
        $(this).parent().parent().children().first().children().first().remove();
        $(this).parent().parent().children().first().children().first().remove();

        fcremoved = true;
    }

    var id = $(this).attr('id').replace(/[^0-9]+/i,'');    

            $(this).parent().children().last().remove();

// $(this).parent().prepend(’<td></td>’);
$(this).appendTo($(this).parent());

            /*td.parent().parent().children().children().first().remove();
            td.parent().children().first().attr('moved',1);*/


});

var timer = 0;
$('#sc_b_new_t').click(function() {




        timer = setInterval( function() {
            
            $('[id^="sc_ins_line_"]').each(function(){
                

                var id = $(this).attr('id').replace(/[^0-9]+/i,'');             

                var td =$(this).parent();

                if (td.parent().children().first().attr('moved') != 1) {
                    td.parent().parent().children().first().after(td.parent());

                    $('[id^="sc_canceli_line_"]').each(function(){

                        $(this).parent()[0].onclick = null;
                        $(this)[0].onclick = null;
                        $(this).click(function() { 
                            
                            iSeqVert = $(this).attr('id').replace(/[^0-9]+/i,'');             
                            var oTBodyOld = document.getElementById("hidden_bloco_0").tBodies[0];
                            var oTROldLine = oTBodyOld.rows[1];
                            oTBodyOld.removeChild(oTROldLine);
                            ajax_destroy_tables(iSeqVert);
                            scEnableNavigation();
                            "."sc"."_insert"."_open = false;
                            scAjaxHideErrorDisplay("table");                            
                        });

                    });

                    

                    td.parent().children().first().attr('moved', 1);
                    td.parent().children().last().remove();
                    //td.parent().prepend('&lt;td id="empty"&gt;&lt;/td&gt;');
                    td.appendTo(td.parent());
                    clearInterval(timer);
                }
            });
            

        }, 5); 

    
});

});

</script>
";

it also moves the “Add New” to the top.

one other thing to note is this, you have to reload the page after adding a new line, so will have to use this in onafterinsert

sc_commit_trans()

sc_redir(your_form);

#4

@scottypaul
After using your code i have some error i.e.

             Parse error: syntax error, unexpected 'hidden_field_data_sc_actions' (T_STRING), expecting ',' or ';'

please help

#5

Can you post full code here for me to see ?

#6

@scottypaul

Thanks for the reply.

Same code which you posted in the forum. if i need to do any changes in this please let me know.

long with this i can attached the screenshot of my form.

echo "
<script>
$(document).ready( function() {

var fcremoved = false;
$(’[id^=“hidden_field_data_sc_actions”]’).each(function(){

if (!fcremoved) {
$(this).parent().parent().children().first().child ren().first().remove();
$(this).parent().parent().children().first().child ren().first().remove();
$(this).parent().parent().children().first().child ren().first().remove();

fcremoved = true;
}

var id = $(this).attr(‘id’).replace(/[^0-9]+/i,’’);

$(this).parent().children().last().remove();
// $(this).parent().prepend(’<td></td>’);
$(this).appendTo($(this).parent());

/td.parent().parent().children().children().first( ).remove();
td.parent().children().first().attr(‘moved’,1);/

});

var timer = 0;
$(’#sc_b_new_t’).click(function() {

timer = setInterval( function() {

$(’[id^=“sc_ins_line_”]’).each(function(){

var id = $(this).attr(‘id’).replace(/[^0-9]+/i,’’);

var td =$(this).parent();

if (td.parent().children().first().attr(‘moved’) != 1) {
td.parent().parent().children().first().after(td.p arent());

$(’[id^=“sc_canceli_line_”]’).each(function(){

$(this).parent()[0].onclick = null;
$(this)[0].onclick = null;
$(this).click(function() {

iSeqVert = $(this).attr(‘id’).replace(/[^0-9]+/i,’’);
var oTBodyOld = document.getElementById(“hidden_bloco_0”).tBodies[0];
var oTROldLine = oTBodyOld.rows[1];
oTBodyOld.removeChild(oTROldLine);
ajax_destroy_tables(iSeqVert);
scEnableNavigation();
“.“sc”.”_insert"."_open = false;
scAjaxHideErrorDisplay(“table”);
});

});

td.parent().children().first().attr(‘moved’, 1);
td.parent().children().last().remove();
//td.parent().prepend(’<td id=“empty”></td>’);
td.appendTo(td.parent());
clearInterval(timer);
}
});

}, 5);

});

});

</script>
";
[ATTACH=CONFIG]n73390[/ATTACH]

Destination.PNG

#7

Please help me to use above mentioned code for “how to move insert,delete, update from the left to the right column in editable grid.mn in editable grid”