Author Topic: Tree Batch Editing - Doesn't Work  (Read 566 times)

STEVE

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 47
    • View Profile
Tree Batch Editing - Doesn't Work
« on: July 10, 2022, 07:08:55 am »
Dear paramvir,

I was tring to make a tree grid from the demo with modifying some code related to the datamodel.
 
I have done everything I can do for fixing the problem of the empty page without error messages.

Error log show me that parameter wrong ie, VirtualProtect() failed [87]

Please help me to reslove this problem.


I have some sample data as below.  It is from the remote database with the php.   
And I am going to attach the source codes.  Please check it.

For your Information about parent-child relationship : fid is child, fidp is parent.

Best Regards,
Steve.

Quote
{"fnm":"\uc804\uc790\ubc14\uc6b0\ucc98","seq":"S0001","ocd":"SPO","scd":"BA1","lvl":"1","fid":"PXXX","ep":"","fidp":"","id":"ID0000000001"},{"fnm":"\uc804\uc790\ubc14\uc6b0\ucc98 \uacb0\uc81c\ub0b4\uc5ed \uc2e4\uc2dc\uac04 \uc54c\ub9bc\uccb4\uacc4","seq":"S0002","ocd":"SPO","scd":"BA1","lvl":"2","fid":"PXXX01","ep":"","fidp":"PXXX","id":"ID0000000002"},{"fnm":"\uc804\uc790\ubc14\uc6b0\ucc98 \uc54c\ub9bc \uc11c\ube44\uc2a4","seq":"S0003","ocd":"SPO","scd":"BA1","lvl":"3","fid":"PXXX0101","ep":"","fidp":"PXXX01","id":"ID0000000003"},{"fnm":"\uc804\uc790\ubc14\uc6b0\ucc98 \uc2e0\uccad \uc548\ub0b4","seq":"S0004","ocd":"SPO","scd":"BA1","lvl":"4","fid":"PXXX010101","ep":"","fidp":"PXXX0101","id":"ID0000000004"},{"fnm":"\uc804\uc790\ubc14\uc6b0\ucc98 \uc2e0\uccad \uc548\ub0b4 \ub4f1\ub85d","seq":"S0005","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX01010101","ep":"Y","fidp":"PXXX010101","id":"ID0000000005"},{"fnm":"\uc804\uc790\ubc14\uc6b0\ucc98 \uc2e0\uccad \uc548\ub0b4 \uc218\uc815","seq":"S0006","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX01010102","ep":"Y","fidp":"PXXX010101","id":"ID0000000006"},{"fnm":"\uc804\uc790\ubc14\uc6b0\ucc98 \uc2e0\uccad \uc548\ub0b4 \uc870\ud68c","seq":"S0007","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX01010103","ep":"Y","fidp":"PXXX010101","id":"ID0000000007"},{"fnm":"\uc804\uc790\ubc14\uc6b0\ucc98 \uc2e0\uccad \uc548\ub0b4 \uc0ad\uc81c","seq":"S0008","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX01010104","ep":"Y","fidp":"PXXX010101","id":"ID0000000008"},{"fnm":"\uc804\uc790\ubc14\uc6b0\ucc98 \uc218\uae09\uc790\uaca9 \ud655\uc815","seq":"S0009","ocd":"SPO","scd":"BA1","lvl":"4","fid":"PXXX010102","ep":"","fidp":"PXXX0101","id":"ID0000000009"},{"fnm":"\uc804\uc790\ubc14\uc6b0\ucc98 \uc218\uae09\uc790\uaca9 \uc870\ud68c","seq":"S0010","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX01010201","ep":"Y","fidp":"PXXX010102","id":"ID0000000010"},{"fnm":"\uc804\uc790\ubc14\uc6b0\ucc98 \uc218\uae09\uc790\uaca9 \ud655\uc815","seq":"S0011","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX01010202","ep":"Y","fidp":"PXXX010102","id":"ID0000000011"},{"fnm":"\uc804\uc790\ubc14\uc6b0\ucc98 \uc218\uae09\uc790\uaca9 \ucde8\uc18c","seq":"S0012","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX01010203","ep":"Y","fidp":"PXXX010102","id":"ID0000000012"},{"fnm":"\uba54\uc2dc\uc9c0 \uc11c\ubc84 \uc5f0\uacc4","seq":"S0013","ocd":"SPO","scd":"BA1","lvl":"3","fid":"PXXX0102","ep":"","fidp":"PXXX01","id":"ID0000000013"},{"fnm":"\ubaa8\ubc14\uc77c \uc54c\ub9bc \uc11c\ube44\uc2a4 \uad00\ub9ac","seq":"S0014","ocd":"SPO","scd":"BA1","lvl":"4","fid":"PXXX010201","ep":"","fidp":"PXXX0102","id":"ID0000000014"},{"fnm":"\ubaa8\ubc14\uc77c \uc54c\ub9bc \uc11c\ube44\uc2a4 \ub4f1\ub85d","seq":"S0015","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX01020101","ep":"Y","fidp":"PXXX010201","id":"ID0000000015"},{"fnm":"\ubaa8\ubc14\uc77c \uc54c\ub9bc \uc11c\ube44\uc2a4 \uc870\ud68c","seq":"S0016","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX01020102","ep":"Y","fidp":"PXXX010201","id":"ID0000000016"},{"fnm":"\ubaa8\ubc14\uc77c \uc54c\ub9bc \uc11c\ube44\uc2a4 \uc218\uc815","seq":"S0017","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX01020103","ep":"Y","fidp":"PXXX010201","id":"ID0000000017"},{"fnm":"\ubaa8\ubc14\uc77c \uc54c\ub9bc \uc11c\ube44\uc2a4 \uc0ad\uc81c","seq":"S0018","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX01020104","ep":"Y","fidp":"PXXX010201","id":"ID0000000018"},{"fnm":"\ubaa8\ubc14\uc77c \uc54c\ub9bc \uc11c\ube44\uc2a4 \ubc1c\uc1a1\uc11c\ubc84 \uc5f0\uacc4","seq":"S0019","ocd":"SPO","scd":"BA1","lvl":"4","fid":"PXXX010202","ep":"","fidp":"PXXX0102","id":"ID0000000019"},{"fnm":"\ubaa8\ubc14\uc77c \uc54c\ub9bc \uc11c\ube44\uc2a4 \uc1a1\uc2e0","seq":"S0020","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX01020201","ep":"Y","fidp":"PXXX010202","id":"ID0000000020"},{"fnm":"\ubaa8\ubc14\uc77c \uc54c\ub9bc \uc11c\ube44\uc2a4 \uc218\uc2e0","seq":"S0021","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX01020202","ep":"Y","fidp":"PXXX010202","id":"ID0000000021"},{"fnm":"\uc54c\ub9bc \uba54\uc2dc\uc9c0 \ubc1c\uc1a1","seq":"S0022","ocd":"SPO","scd":"BA1","lvl":"3","fid":"PXXX0103","ep":"","fidp":"PXXX01","id":"ID0000000022"},{"fnm":"\uc54c\ub9bc\uba54\uc2dc\uc9c0 \ud1b5\ud569\ubc1c\uc1a1 \uad00\ub9ac","seq":"S0023","ocd":"SPO","scd":"BA1","lvl":"4","fid":"PXXX010301","ep":"","fidp":"PXXX0103","id":"ID0000000023"},{"fnm":"\uc54c\ub9bc\uba54\uc2dc\uc9c0 \ub2e8\uac74\ubc1c\uc1a1","seq":"S0024","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX01030101","ep":"Y","fidp":"PXXX010301","id":"ID0000000024"},{"fnm":"\uc54c\ub9bc\uba54\uc2dc\uc9c0 \ub300\ub7c9\ubc1c\uc1a1","seq":"S0025","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX01030102","ep":"Y","fidp":"PXXX010301","id":"ID0000000025"},{"fnm":"\uc54c\ub9bc\uba54\uc9c0\uc2dc \uc7ac\ubc1c\uc1a1","seq":"S0026","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX01030103","ep":"Y","fidp":"PXXX010301","id":"ID0000000026"},{"fnm":"\ubc1c\uc1a1 \uc815\uc0b0 \uc2b9\uc778","seq":"S0027","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX01030104","ep":"Y","fidp":"PXXX010301","id":"ID0000000027"},{"fnm":"\ubc1c\uc1a1 \uc815\uc0b0 \ub8f0 \uc801\uc6a9","seq":"S0028","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX01030105","ep":"Y","fidp":"PXXX010301","id":"ID0000000028"},{"fnm":"\uc54c\ub9bc\uba54\uc2dc\uc9c0 \uc7ac\ubc1c\uc1a1","seq":"S0029","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX01030106","ep":"Y","fidp":"PXXX010301","id":"ID0000000029"},{"fnm":"\uc804\uc790\ubc14\uc6b0\ucc98 \uc6b4\uc601\uad00\ub9ac","seq":"S0030","ocd":"SPO","scd":"BA1","lvl":"2","fid":"PXXX02","ep":"","fidp":"PXXX","id":"ID0000000030"},{"fnm":"\ubc14\uc6b0\ucc98\uad00\ub9ac","seq":"S0031","ocd":"SPO","scd":"BA1","lvl":"3","fid":"PXXX0201","ep":"","fidp":"PXXX02","id":"ID0000000031"},{"fnm":"\ubc14\uc6b0\ucc98\uc0dd\uc131\uad00\ub9ac","seq":"S0032","ocd":"SPO","scd":"BA1","lvl":"4","fid":"PXXX020101","ep":"","fidp":"PXXX0201","id":"ID0000000032"},{"fnm":"\ubc14\uc6b0\ucc98 \ub4f1\ub85d","seq":"S0033","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX02010101","ep":"Y","fidp":"PXXX020101","id":"ID0000000033"},{"fnm":"\ubc14\uc6b0\ucc98 \uc218\uc815","seq":"S0034","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX02010102","ep":"Y","fidp":"PXXX020101","id":"ID0000000034"},{"fnm":"\ubc14\uc6b0\ucc98 \uc870\ud68c","seq":"S0035","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX02010103","ep":"Y","fidp":"PXXX020101","id":"ID0000000035"},{"fnm":"\ubc14\uc6b0\ucc98 \uc0ad\uc81c","seq":"S0036","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX02010104","ep":"Y","fidp":"PXXX020101","id":"ID0000000036"},{"fnm":"\ubd80\uc815\uc0ac\uc6a9\uad00\ub9ac","seq":"S0037","ocd":"SPO","scd":"BA1","lvl":"4","fid":"PXXX020102","ep":"","fidp":"PXXX0201","id":"ID0000000037"},{"fnm":"\ubd80\uc815\uc0ac\uc6a9\uc0ac\ub840 \uc870\ud68c","seq":"S0038","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX02010201","ep":"Y","fidp":"PXXX020102","id":"ID0000000038"},{"fnm":"\ubd80\uc815\uc0ac\uc6a9\uc0ac\uc6a9\uc790 \ub4f1\ub85d","seq":"S0039","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX02010202","ep":"Y","fidp":"PXXX020102","id":"ID0000000039"},{"fnm":"\ubd80\uc815\uc0ac\uc6a9\uc0ac\uc6a9\uc790 \uc870\ud68c","seq":"S0040","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX02010203","ep":"Y","fidp":"PXXX020102","id":"ID0000000040"},{"fnm":"\ubd80\uc815\uc0ac\uc6a9\uc0ac\uc6a9\uc790 \ucde8\uc18c","seq":"S0041","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX02010204","ep":"Y","fidp":"PXXX020102","id":"ID0000000041"},{"fnm":"\ub9e4\ucd9c \ubc0f \uc815\uc0b0","seq":"S0042","ocd":"SPO","scd":"BA1","lvl":"3","fid":"PXXX0202","ep":"","fidp":"PXXX02","id":"ID0000000042"},{"fnm":"\uacb0\uc81c\ub0b4\uc5ed\uad00\ub9ac","seq":"S0043","ocd":"SPO","scd":"BA1","lvl":"4","fid":"PXXX020201","ep":"","fidp":"PXXX0202","id":"ID0000000043"},{"fnm":"\uacb0\uc81c\ub0b4\uc5ed \uc870\ud68c","seq":"S0044","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX02020101","ep":"Y","fidp":"PXXX020201","id":"ID0000000044"},{"fnm":"\uacb0\uc81c\ub0b4\uc5ed \uc218\uc815","seq":"S0045","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX02020102","ep":"Y","fidp":"PXXX020201","id":"ID0000000045"},{"fnm":"\uacb0\uc81c\ub0b4\uc5ed \uc0ad\uc81c","seq":"S0046","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX02020103","ep":"Y","fidp":"PXXX020201","id":"ID0000000046"},{"fnm":"\uacb0\uc81c\ub0b4\uc5ed \ubd84\uc11d TEST","seq":"S0047","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX02020104","ep":"Y","fidp":"PXXX020201","id":"ID0000000047"},{"fnm":"\uacb0\uc81c\ub0b4\uc5ed \ubd84\uc11d TEST2","seq":"S0048","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX02020105","ep":"Y","fidp":"PXXX020201","id":"ID0000000048"},{"fnm":"\uacb0\uc81c\ub0b4\uc5ed \ubd84\uc11d TEST3","seq":"S0049","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX02020106","ep":"Y","fidp":"PXXX020201","id":"ID0000000049"},{"fnm":"\uacb0\uc81c\ub0b4\uc5ed \ubd84\uc11d TEST4","seq":"S0050","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX02020107","ep":"Y","fidp":"PXXX020201","id":"ID0000000050"},{"fnm":"\uacb0\uc81c\ub0b4\uc5ed \ubd84\uc11d TEST5","seq":"S0051","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX02020108","ep":"Y","fidp":"PXXX020201","id":"ID0000000051"},{"fnm":"\uacb0\uc81c\ub0b4\uc5ed \ubd84\uc11d TEST6","seq":"S0052","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX02020109","ep":"Y","fidp":"PXXX020201","id":"ID0000000052"},{"fnm":"\uacb0\uc81c\ub0b4\uc5ed \ubd84\uc11d TEST7","seq":"S0053","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX02020110","ep":"Y","fidp":"PXXX020201","id":"ID0000000053"},{"fnm":"\uacb0\uc81c\ub0b4\uc5ed \ubd84\uc11d TEST8","seq":"S0054","ocd":"SPO","scd":"BA1","lvl":"5","fid":"PXXX02020111","ep":"Y","fidp":"PXXX020201","id":"ID0000000054"}]}



paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 5637
    • View Profile
Re: Tree Batch Editing - Doesn't Work
« Reply #1 on: July 11, 2022, 10:17:19 am »
[ Only Pro members may read this post. ]

STEVE

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 47
    • View Profile
Re: Tree Batch Editing - Doesn't Work
« Reply #2 on: July 11, 2022, 07:41:20 pm »
Dear paramvir,

I am using PHP debuger.  But There is no error.  Only I can the error in the error.log file from apache.

I am going to ask you about what childstr is and parentId is. I can't understand how treegrid works from your demos. 

Quote
Example of flat data: Flat data is just like normal data format of the grid; children nodes specify the parent as parentId property.

var data = [
    { id: 1, name: "C", size: "", date: "05/13/2008" },
    { id: 2, name: "Program Files", size: "9047", date: "03/26/2015", parentId: 1 },
    { id: 21, name: "Apache", size: "", date: "01/16/2010", parentId: 2 }
];


I think two nodes of child and parent should be coded in the treeModel. But there is only one node for the treegrid.
i.e,  dataIndx: 'fnm', 

I think it is for the nested datamodel.  I need the flat data model for the treegrid. 

 
Code: [Select]
    treeModel: {
        dataIndx: 'fnm',                       
        checkbox: false,
        cascade: true,             
        icons: false,
        summary: false,
        historyMove: true, //7.4
        leafIfEmpty: true  //7.4

Would you post the example for the flat data example php file?

Best regards,
Steve

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 5637
    • View Profile
Re: Tree Batch Editing - Doesn't Work
« Reply #3 on: July 12, 2022, 06:43:59 pm »
[ Only Pro members may read this post. ]

STEVE

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 47
    • View Profile
Re: Tree Batch Editing - Doesn't Work
« Reply #4 on: July 12, 2022, 07:44:25 pm »
Thank you for your kindness.  It works.

It works now after changing other codes like below.  But Is not understandable.
As far as I know, To do batch editing, the codes are needed.

Code: [Select]
    dataModel: {
        dataType: "JSON",             
        location: 'remote',
        // getData: function(response){           <--- I commented these lines   
        //     return {data: response};              <---
        // },                                                    <---   
        url: "treedb.php",
        recIndx: 'id'

STEVE

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 47
    • View Profile
Re: Tree Batch Editing - Doesn't Work
« Reply #5 on: July 12, 2022, 08:04:26 pm »
I found that it couldn't update the database at all.

only retrieve again. 

STEVE

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 47
    • View Profile
Re: Tree Batch Editing - Doesn't Work
« Reply #6 on: July 12, 2022, 08:07:46 pm »
I am uploading the problem files.   Please check it.

STEVE

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 47
    • View Profile
Re: Tree Batch Editing - Doesn't Work
« Reply #7 on: July 21, 2022, 07:41:03 pm »
Please help me to resolve this problem. It can't update the database.
 
Code: [Select]
dataModel: {
        dataType: "JSON",             
        location: "remote",
        recIndx: "id",
        url: "treedb.php"
        //,
        //getData: function(response){        '''' if I uncomment these lines, Nothing shown on the page.           
        //    return {data: response};
        }   
    },

STEVE

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 47
    • View Profile
Re: Tree Batch Editing - Doesn't Work
« Reply #8 on: July 21, 2022, 08:35:06 pm »
Would you give me the best example of the tree grid batch editing?

STEVE

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 47
    • View Profile
Re: Tree Batch Editing - Doesn't Work
« Reply #9 on: July 26, 2022, 08:06:10 pm »
Hello ~ paramvir ~

Please help me...

I can't fix this problem. 

Please....

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 5637
    • View Profile
Re: Tree Batch Editing - Doesn't Work
« Reply #10 on: July 26, 2022, 11:10:07 pm »
[ Only Pro members may read this post. ]

STEVE

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 47
    • View Profile
Re: Tree Batch Editing - Doesn't Work
« Reply #11 on: August 04, 2022, 06:37:52 pm »
Dear paramvir

I have been waiting for your solution to my question every day.

STEVE

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 47
    • View Profile
Re: Tree Batch Editing - Doesn't Work
« Reply #12 on: August 05, 2022, 10:04:31 pm »
Dear paramvir

Please Help me.

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 5637
    • View Profile
Re: Tree Batch Editing - Doesn't Work
« Reply #13 on: August 08, 2022, 10:11:55 am »
[ Only Pro members may read this post. ]

STEVE

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 47
    • View Profile
Re: Tree Batch Editing - Doesn't Work
« Reply #14 on: August 09, 2022, 09:04:06 pm »
Dear paramvir

Would you guide me on how to use it?  Probably, there are some rules to keep. 
It is supposed to work.  It must be my fault.