I looked into the connector log and I am getting weird date format from FORM object data processor.
Here’s my code:
/*
* Creates a popup window for adding Area Statistics
*/
function createAreaStatWindow(rID, cInd){
//open popup window
var winAreaStatistics = layout.dhxWins.createWindow("winAreaStatistics", 0, 0, 270, 475);
winAreaStatistics.center();
winAreaStatistics.setText("Area Statistic");
winAreaStatistics.denyResize();
winAreaStatistics.setModal(1);
winAreaStatistics.centerOnScreen();
winAreaStatistics.button('park').hide();
winAreaStatistics.button('minmax1').hide();
winAreaStatistics.button('close').hide();
//add form
var frmAreaStatistics = winAreaStatistics.attachForm();
frmAreaStatistics.loadStruct("xml/frmAreaStatistic.xml?i=2345678");
var dpFrm = new dataProcessor("common/frmConnectorStatistics.php");
dpFrm.init(frmAreaStatistics);
if (rID!=0) frmAreaStatistics.load("common/frmConnectorStatistics.php?id="+rID);
frmAreaStatistics.attachEvent("onButtonClick", function(name, command){
if (name=="submit"){
// FORM SUBMISSION
dpFrm.sendData();
} else {
// USER CANCELLED
winAreaStatistics.close();
}
});
dpFrm.attachEvent("onBeforeUpdate",function(id,status){
frmAreaStatistics.setItemValue("stat_date","1999-12-31");
return true;
});
dpFrm.attachEvent("onAfterUpdate",function(sid,action,tid,xml_node){
if(action=="inserted"){
dpGrid.ignore(function(){
gridStats.addRow(tid,[
frmAreaStatistics.getItemValue("stat_date"),
frmAreaStatistics.getItemValue("area"),
frmAreaStatistics.getItemValue("arrests"),
frmAreaStatistics.getItemValue("psp_pals"),
frmAreaStatistics.getItemValue("pals"),
frmAreaStatistics.getItemValue("fir"),
frmAreaStatistics.getItemValue("comp_chk_attempt"),
frmAreaStatistics.getItemValue("comp_chk_completed"),
frmAreaStatistics.getItemValue("no_show"),
frmAreaStatistics.getItemValue("addr_vrfy")
],0)
});
gridStats.selectRowById(tid,false,false,true);
} // endif
if(action=="updated"){
dpGrid.ignore(function(){
gridStats.cells(sid,0).setValue(frmAreaStatistics.getItemValue("stat_date"));
gridStats.cells(sid,1).setValue(frmAreaStatistics.getItemValue("area"));
gridStats.cells(sid,2).setValue(frmAreaStatistics.getItemValue("arrests"));
gridStats.cells(sid,3).setValue(frmAreaStatistics.getItemValue("psp_pals"));
gridStats.cells(sid,4).setValue(frmAreaStatistics.getItemValue("pals"));
gridStats.cells(sid,5).setValue(frmAreaStatistics.getItemValue("fir"));
gridStats.cells(sid,6).setValue(frmAreaStatistics.getItemValue("comp_chk_attempt"));
gridStats.cells(sid,7).setValue(frmAreaStatistics.getItemValue("comp_chk_completed"));
gridStats.cells(sid,8).setValue(frmAreaStatistics.getItemValue("no_show"));
gridStats.cells(sid,9).setValue(frmAreaStatistics.getItemValue("addr_vrfy"));
});
} // endif
winAreaStatistics.close();
})
} // function: addAreaStatistic(rID, cInd);
}) // attachEvent(window,load)
url = "common/gridConnectorStatistics.php?connector=true&dhx_filter[1]="+area;
dpGrid = new dataProcessor(url);
dpGrid.init(gridStats);