hi,
I have to use drag and drop in grids, I am keeping the code here:- . Let rows with id’s 1,2,3 are dragged, and I am creating report from it. For the second time when i am dragging the same with id’s 1,2,3… reports are not creating. But if we drag rows with id’s 4,5,6… it will work. If any of the rows which dragged once is drag again it is not giving correct output… Please help me…
function buildGrid(){
dhtmlx.image_path = "./images/";
mygrid2 = new dhtmlXGridObject('gridbox1');
mygrid2.setHeader("Sl No,Display Name,Field Name,Table Name,FieldType,FieldSize,FieldDesc,GridFilterDflt,DisplaySizeDflt,FieldDesc,GridFilterDflt,DisplaySizeDflt");
mygrid2.setInitWidths("50,200,50,200,75,75,75,75,75,75,75,75")
mygrid2.setColTypes("ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro");
mygrid2.setColSorting("int,str,str,str,str,str,str,str,str,str,str,str");
mygrid2.setColAlign("left,leftt,leftt,leftt,leftt,leftt,leftt,leftt,leftt,leftt,leftt,leftt")
mygrid2.setColumnHidden(0,true);
mygrid2.setColumnHidden(2,true);
mygrid2.setColumnHidden(4,true);
mygrid2.setColumnHidden(5,true);
mygrid2.setColumnHidden(6,true);
mygrid2.setColumnHidden(7,true);
mygrid2.setColumnHidden(8,true);
mygrid2.setColumnHidden(9,true);
mygrid2.setColumnHidden(10,true);
mygrid2.setColumnHidden(11,true);
mygrid2.enableMercyDrag(false);
mygrid2.enableDragAndDrop(true);
mygrid2.enableMultiselect(true);
mygrid2.setSkin("dhx_skyblue");
mygrid2.init();
mygrid2.clearAndLoad("./TableFieldData.php");
mygrid = new dhtmlXGridObject('gridbox');
mygrid.setHeader("Sl No,Table Name,Field Name,DisplayName,FieldType,FieldSize,FieldDesc");
mygrid.setInitWidths("50,100,100,100,75,75,75")
mygrid.setColAlign("left,leftt,leftt,leftt,leftt,leftt,leftt")
mygrid.setColTypes("ro,ro,ro,ro,ro,ro,ro,ro,ro,ro");
mygrid.setColSorting("int,str,str,str,str,str,str")
mygrid.enableMercyDrag(true);
mygrid.setColumnHidden(0,true);
mygrid.setColumnHidden(2,true);
mygrid.setColumnHidden(4,true);
mygrid.setColumnHidden(5,true);
mygrid.setColumnHidden(6,true);
mygrid.setColumnHidden(7,true);
mygrid.setColumnHidden(8,true);
mygrid.setColumnHidden(9,true);
mygrid.setColumnHidden(10,true);
mygrid.setColumnHidden(11,true);
mygrid.enableDragAndDrop(true);
mygrid.enableMultiselect(true);
mygrid.setSkin("dhx_skyblue");
mygrid.init();
mygrid.clearAndLoad("./selectedfields.xml");
mygridReport = new dhtmlXGridObject('mygridReportDiv');
mygridReport.setHeader("Report ID,Report Title,Report Link,Created By,Created On,link");
mygridReport.setInitWidths("75,300,100,200,200,200")
mygridReport.attachHeader("#text_filter,#text_filter,,#text_filter,#text_filter,");
mygridReport.setColAlign("left,leftt,leftt,leftt,leftt,leftt")
mygridReport.setColTypes("ro,ed,link,ro,ro,ro");
mygridReport.setColSorting("int,str,str,str,str,str");
mygridReport.setSkin("dhx_skyblue");
mygridReport.setColumnHidden(5,true);
mygridReport.init();
mygridReport.clearAndLoad("./selectreports.php");
myDataReportProcessor = new dataProcessor("update_report.php");
myDataReportProcessor.init(mygridReport);
myDataProcessor = new dataProcessor("./update_all.php");
myDataProcessor.setTransactionMode("POST", true);
myDataProcessor.setUpdateMode("off");
myDataProcessor.init(mygrid);
}