dhtmlXCalendar as date input and as dhtmlxgrid column type

Suite and Optimus Suite 5
#1

dear friends,

dhtmlXCalendar as date input and as dhtmlxgrid column type is not working together.
plz help me on this.

dhtmlXCalendar as date input is appearing but with java script error that

“addEventListner” is null or not an Object.

when i change the dhtmlx grid column type to “ed” then it’s working fine.

#2

Hello
Could you provide us a code snippets?

#3

Sorry to reply late.

here is the code,

when grid has no dhxCalendar type column then it’s working fine, but if it have any dhxCalendar column then it is giving me the error “addEventListner” is null or not an Object.

on event fires first time, after javascript error when i am trying to change date in input then it is working however the error remains the same, but not at first time.

<HTML>
<BODY>
<table>
           <tbody>						
													<tr>
													  <td class="bg3sf">As On Date :</td>
													  <td class="bg3sf"><input type="text" id="calendar2" name="calendar2" readonly="readonly" style="width: 80px;height: 20px; "> 
				  										<select id="SelectDate" name="AsOnDateSelect"  onchange="fnSelect()">
														<option value="0">--Select--</option>
															<%
															
																if (dynaAsOnDt != null) {
																	while (dynaAsOnDt.next()) {
																		String dt = dynaAsOnDt.getString("as_on_dt");
															%>
														<option value="<%=dt%>"><%=dt%></option>
															<%
																}
																}
															%>
														</select>	
                            </td>
             </tbody>
</table>
</BODY>
</HTML>


var myCalendar2 = new dhtmlXCalendarObject("calendar2");
			arr = new Array();
			var myOpts = document.getElementById('SelectDate').options;
			for (i=0; i<myOpts.length; i++) 
			{
				if(myOpts[i].text!='--Select--')
					arr[i]=myOpts[i].text;
			}
			
			myCalendar2.setDateFormat("%d-%m-%Y");
			myCalendar2.setHolidays(arr);
			myCalendar2.hideTime();
			myCalendar2.attachEvent("onClick",function(date, state){
			
			fnsetcombovalue(); 

                            })

var arr,cnt;
	var asondate,exec;
	Array.prototype.contains = function (element) 
	{
		cnt = 0;
		for (var i = 0; i < this.length; i++) 
		{
			
			if (this[i] == element) 
			{
				cnt = i;
			return true;
			}
		}
		return false;
		}
		
	function fnsetcombovalue()
	{
		var asOnDtVal = document.frmBC.calendar2.value;
		
		arr.contains(asOnDtVal);
		
		asondate=document.frmBC.calendar2.value;
		document.frmBC.AsOnDateSelect.selectedIndex=cnt;
		exec=document.frmBC.AsOnDateSelect.value;
		
		fnSelect();
	}
	


function fnSelect() 
{
	var cmbAsOnDt = document.getElementById('SelectDate').value;
	var cmbRowType= document.getElementById('SelectId').value;
	
	if(cmbAsOnDt!=0 && cmbRowType>-2)
		{
		 mygrid.clearAndLoad(xmlLoadURL+"&dt=" + cmbAsOnDt +"&Id="+cmbRowType,function()
				 {
			 var pageNo='<%=request.getAttribute("page")%>';
			 if(pageNo!='null')
			 mygrid.changePage(pageNo);
			 	}

				 );
		}
}


mygrid = new dhtmlXGridObject('gridbox');
			mygrid.setImagePath("codebase/imgs/");
			mygrid.enablePaging(true, 35, 20, "pagingArea", true);
			mygrid.setPagingSkin("bricks");
			mygrid.setHeader(",File Id,File Name,Location ID,Customer Type,Import/Export Code Description,Importer Invoice Number,Importer Name,Importer Address,Importer License Number,Importer License Date,BEF Default ID,Importer Items,Importer Remitance Date,Importer Remitance Amount Currency ID,Importer Remitance Amount Currency,Rupee Equivalent,Remarks,Row Error ID,Action,Status");
	        mygrid.setInitWidths("20,0,80,120,80,80,80,80,120,80,100,80,100,100,80,80,80,80,100,100,100");
	        mygrid.setColAlign("left,left,left,left,left,left,left,left,left,left,left,left,left,left,left,left,left,left,left,left,left")
	        mygrid.setColTypes("ch,ro,ed,combo,ed,ed,ed,ed,ed,ed,dhxCalendar,ed,ed,dhxCalendar,ed,ed,ed,ed,ed,ro,ro");
	        mygrid.imgURL = "DataModificationScreen/codebase/imgs/";
			mygrid.setSkin("light");
			mygrid.enableUndoRedo();
			mygrid.enableAutoHeight(true, intGridHeight);
			mygrid.preventIECaching(true);
			mygrid.attachEvent("onEditCell",fnEdit);
			mygrid.attachEvent("onPageChanged",fnpage);
			mygrid.init();
			mygrid.setColumnHidden(1,true);
			mygrid.setColumnHidden(19,true);
			mygrid.setColumnHidden(20,true);
			mygrid.setDateFormat("%d-%b-%y");
                           var combo = mygrid.getColumnCombo(3);
			 combo.readonly(true)
			  combo.loadXML("DataModificationScreen/xml-common/Rc_BefPart2.xml");
#4

Please try to update dhtmlxgrid_excell_dhxcalendar.js with the attached one.
dhtmlxgrid_excell_dhxcalendar.zip (1.82 KB)