ExtJS - Post date values as Unix timestamp

Question

I use an editorgrid to edit elements from a JsonStore. The JsonStore uses a HttpProxy to update the backend database.

My problem is that the backend API expects fromTs and toTs to be Unix timestamps, but when a record is updated, the resulting http post contains a date formatted like this: Wed Oct 20 00:00:00 UTC+0200 2010

I've searched the API documentation for a parameter to control the post format, but I've not been able to find anything. Is there a simple way to do this?

 myJsonStore = new Ext.data.JsonStore({
  autoLoad: true,
  autoSave: true,
  proxy: new Ext.data.HttpProxy({
   api: {
    create: '/create/',
    read: '/read/',
    update: '/update/',
    destroy:'/destroy/'
   }
  }),
  writer: new Ext.data.JsonWriter({
   encode: true,
   writeAllFields: true
  }),
  idProperty: 'id',
  fields: [
   {name: 'id',  type: 'int'},
   {name: 'fromTs', type: 'date', dateFormat:'timestamp'},
   {name: 'toTs',  type: 'date', dateFormat:'timestamp'}
  ]
 });

The editorgrid is configured like this:

 {
  xtype: 'editorgrid',
  clicksToEdit: 1,
  columns: [
         {header: "Id", dataIndex: 'id', editable: false},
   {header: "From", dataIndex: 'fromTs', editor: new Ext.form.DateField({format: 'd.m.Y', startDay: 1}), xtype: 'datecolumn', format: 'd.m.Y'},     
   {header: "To", dataIndex: 'toTs', editor: new Ext.form.DateField({format: 'd.m.Y', startDay: 1}), xtype: 'datecolumn', format: 'd.m.Y'}
  ],
  store: myJsonStore
 }

Answer 1

You might be able to hook into the validateedit event or afteredit event of your EditorGridPanel and convert the user-entered-value back into a timestamp using a Date parsing method. I'm guessing that EditorGridPanel is updating the records in the store verbatim without converting them back into timestamps, so you have to do that manually. So I'm thinking maybe something like:

grid.on('validateedit', function(event) {
  if (isDateColumn(column)) {
    event.record.data[event.field] = dateToTimestamp(event.value);
  }
}