|
thecyberzone
|
 |
« Reply #5 on: March 09, 2021, 12:22:18 AM » |
|
Yes, same way it is working fine in different form, but in a particular form this messager window is not closing. I am attaching the entire code, so that you can help me in this regard. // ************** for editable datagrid ****************************
var editIndex = undefined;
$.extend($.fn.datagrid.methods, {
editCell: function(jq,param){
return jq.each(function(){
var opts = $(this).datagrid('options');
var fields = $(this).datagrid('getColumnFields',true).concat($(this).datagrid('getColumnFields'));
for(var i=0; i<fields.length; i++){
var col = $(this).datagrid('getColumnOption', fields[i]);
col.editor1 = col.editor;
if (fields[i] != param.field){
col.editor = null;
}
}
$(this).datagrid('beginEdit', param.index);
for(var i=0; i<fields.length; i++){
var col = $(this).datagrid('getColumnOption', fields[i]);
col.editor = col.editor1;
}
});
}
});
function endEditing(ddv,index){
if (editIndex == undefined){return true}
if (ddv.datagrid('validateRow', editIndex)){
ddv.datagrid('endEdit', editIndex);
editIndex = undefined;
var rec = index;
return true;
} else {
return false;
}
}
function onClickCell(index, field){
if (endEditing($(this),index)){
$(this).datagrid('selectRow', index)
.datagrid('editCell', {index:index,field:field});
editIndex = index;
}
}
$.extend($.fn.combogrid.defaults, {
filter: function(q, row){
var opts = $(this).combogrid('options');
return row[opts.textField].toLowerCase().indexOf(q.toLowerCase()) >= 0;
}
});
$.extend($.fn.datagrid.defaults.editors,{
label:{
init:function(container,options){
return $('<div></div>').appendTo(container);
},
getValue:function(target){
return target.value || $(target).html();
},
setValue:function(target,value){
target.value = value;
$(target).html(value);
},
resize:function(target,width){
$(target)._outerWidth(width);
}
}
});
// ************** for editable datagrid ****************************
function loadNeed() {
v = $('[name=upto]:checked').val();
var moncal = $('#dt').datetimespinner('getValue');
var selmon = moncal.split('-');
var dt1 = new Date(selmon[1],selmon[0],1);
var y = dt1.getFullYear();
var m = dt1.getMonth();
var caldt2 = (new Date(new Date(y,m,1)-1));
var cald2 = caldt2.getFullYear()+'-'+dDigit(caldt2.getMonth()+1)+'-'+caldt2.getDate();
var caldt1 = (new Date(y,m-1,1));
var cald1 = caldt1.getFullYear()+'-'+dDigit(caldt1.getMonth()+1)+'-01';
if(v=='mon'){
if(m<4){
var dt1 = (new Date(y-1,4,1));
var d1 = dt1.getFullYear()+'-'+dDigit(dt1.getMonth())+'-01';
}
else {
var dt1 = (new Date(y,4,1));
var d1 = dt1.getFullYear()+'-'+dDigit(dt1.getMonth())+'-01';
}
var dt2 = (new Date(new Date(y,m,1)-1));
var d2 = dt2.getFullYear()+'-'+dDigit(dt2.getMonth()+1)+'-'+dt2.getDate();
}
else {
if(m<4){
var dt1 = (new Date(y-1,4,1));
var d1 = dt1.getFullYear()+'-'+dDigit(dt1.getMonth())+'-01';
var dt2 = (new Date(y,3,31));
var d2 = dt2.getFullYear()+'-'+dDigit(dt2.getMonth()-1)+'-31';
}
else {
var dt1 = (new Date(y,4,1));
var d1 = dt1.getFullYear()+'-'+dDigit(dt1.getMonth())+'-01';
var dt2 = (new Date(y+1,3,31));
var d2 = dt2.getFullYear()+'-'+dDigit(dt2.getMonth()-1)+'-31';
}
}
if(m<4){
var yr = y-1;
} else {
var yr = y;
}
var sec = $('#cg2').combogrid('getText');
// alert('getDeptNeed.php?dt1='+d1+'&dt2='+d2+'&caldt1='+cald1+'&caldt2='+cald2+'&sec='+sec+'&yr='+yr);
$('#dg1').datagrid({
idField: 'ID',
method: 'get',
url: 'getDeptNeed.php?dt1='+d1+'&dt2='+d2+'&caldt1='+cald1+'&caldt2='+cald2+'&sec='+sec+'&yr='+yr,
onClickCell:onClickCell,
fitColumns:true,
singleSelect:true,
rownumbers:true,
autoRowHeight:true,
editorHeight:24,
loadMsg:'loading...',
height:'auto',
columns:[[
{field:'ID',width:0,hidden:true},
{field:'TNO2',title:'T/No',width:70,align:'center'},
{field:'NAME',title:'Name',width:200,align:'left'},
{field:'MOBILE',title:'Mobile',width:100,align:'left',editor:'textbox'},
{field:'DESCODE',title:'Desig',width:40,align:'center'},
{field:'PROGNAME',title:'Module',width:300,align:'left'},
{field:'PROGCODE',title:'ProgId',width:60,align:'center'},
{field:'DURATION',title:'Days',width:40,align:'center'},
{field:'ASSDATE',title:'Plan Date',width:90,align:'center'},
{field:'STATUS',title:'Status',width:50,align:'center',
editor:{
type:'textbox',
options:{
readonly:true
}
}
},
{field:'OLDDATE',width:0,hidden:true},
{field:'CALDATE',title:'Cal. Date',width:120,align:'center' ,
editor:{
type:'combobox',
options:{
valueField:'ST_DT',
textField:'ST_DT',
panelHeight:100,
required:true
}
}
},
{field:'action',title:'Save',width:40,align:'center',
formatter:function(value,row,index){
if(row.editing) {
return '<a href="javascript:void(0)" onclick="#"><img src="images/checkmark.png" /></a> ';
}
else {
return '<a href="javascript:void(0)" onclick="#"><img src="images/save.png" /></a> ';
}
}
}
]] ,
onBeforeEdit: function(index,row){
row.editing = true;
$(this).datagrid('updateRow',{index:index, row:{}});
var colDate = $(this).datagrid('getColumnOption', 'CALDATE');
if (row.STATUS!='A') {
colDate.editor = {
type:'combobox',
options:{
method: 'get',
valueField:'ST_DT',
textField:'ST_DT',
panelHeight:100,
url: 'getDate.php?dt1='+cald1+'&dt2='+cald2+'&pc='+row.PROGCODE+'&yr='+yr,
onLoadSuccess: function(data){
if (!data.length){
// var ed = $(this).datagrid('getEditor', {index:index,field:'CALDATE'});
// var combo = $(ed.target);
// combo.combobox('disable');
$(this).combobox('disable');
if (row.CALDATE=='--') {
$.messager.alert({title:'Information', msg:'Target is already full for this module; Please try next time.'});
}
}
}
}
};
}
else {
colDate.editor = null;
}
var colMobile = $(this).datagrid('getColumnOption', 'MOBILE');
$(this).datagrid('fixRowHeight');
},
onAfterEdit:function(index,row){
row.editing = false;
$(this).datagrid('fixRowHeight');
if(row.CALDATE!=row.OLDDATE) {
if(row.CALDATE=='--'){
$(this).datagrid('updateRow',{index:index, row: {ID:row.ID,OLDDATE:row.OLDDATE,STATUS:"P"}});
} else {
$(this).datagrid('updateRow',{index:index, row: {ID:row.ID,OLDDATE:row.OLDDATE,STATUS:"N"}});
}
var moncal = $('#dt').datetimespinner('getValue');
//var yr = moncal.substring(3,7);
//var mn = moncal.substring(0,3);
//alert(mn);
//$.messager.alert('Information', 'nomi.Update.php?tno='+row.TNO2+'&pc='+row.PROGCODE+'&cdt='+row.CALDATE+'&mo='+row.MOBILE+'&yr='+yr);
//alert("nomi.Update.php?tno="+row.TNO2+"&pc="+row.PROGCODE+"&cdt="+row.CALDATE+"&mo="+row.MOBILE+'&yr='+yr);
$.get("nomi.Update.php?tno="+row.TNO2+"&pc="+row.PROGCODE+"&cdt="+row.CALDATE+"&mo="+row.MOBILE+'&yr='+yr, function(data, status){
var result = eval('('+data+')');
if(!result.errMsg) {
if(row.CALDATE!=''){
$.messager.show({title:'Information', msg:row.NAME+' has been nominated successfully!',timeout:2000,showType:'slide'});
}
} else {
$.messager.show({title:'Error', msg:result.errMsg,timeout:2000,showType:'slide'});
}
});
}
}
});
}
function getRowIndex(target){
var tr = $(target).closest('tr.datagrid-row');
return parseInt(tr.attr('datagrid-row-index'));
}
document.addEventListener('keydown', function(event) {
const key = event.key; // const {key} = event; ES6+
if (key === "Delete") {
var row = $('#dg1').datagrid('getSelected');
if (row){
$.messager.confirm('Confirm','Are you sure you want to delete record?',function(r){
if (r){
//alert("Deleting T/No. : "+row.ID);
$.get("delNomi.php?ID="+row.ID, function(data, status){
var result = eval('('+data+')');
if(result.errMsg) {
$.messager.show({title:'Message', msg:result.errMsg,timeout:3000,showType:'slide'});
}
$('#dg1').datagrid('reload');
});
}
});
}
}
});
|
