function load_admin_tab (link,tab){
var statusElem = document.getElementById(tab) ;

$.ajax({

     url: link,             // указываем URL и
    beforeSend: function( xhr ) {
   	statusElem.innerHTML="Please, wait...";
  },
     success: function (data, textStatus) { // вешаем свой обработчик на функцию success
		statusElem.innerHTML=data;
     } 
});

}





function show_admin(admin_type){

		$.ajax({
		     url: "TAB_administration.php",
		     async:false,
		     data: { action: "show_admin_by_type", admin_type: admin_type },
		     type:'post',
		     success: function (data, textStatus) { 
			$("#admin_tab").html(data);
			initialize_admin_datatables(admin_type);

		     } 
		});
}


$.widget( "ui.autocomplete", $.ui.autocomplete, {
   options: {
      renderItem: null,
      renderMenu: null,
      resizeMenu:null,
   },
   _renderItem: function( ul, item ) {
      if ( $.isFunction( this.options.renderItem ) )
         return this.options.renderItem( ul, item );
      else
         return this._super( ul, item );
   },
   _renderMenu: function( ul, items ) {
      if ( $.isFunction( this.options.renderMenu ) ) {
         this.options.renderMenu( ul, items );
      }
      this._super( ul, items );
   },

_resizeMenu: function(){
this.menu.element.outerWidth( 'auto' );
        }, 
});


function initialize_admin_datatables(table){

			if ( $.fn.dataTable.isDataTable( "#"+table+"_table" ) ) {
			    table = $( "#"+table+"_table" ).DataTable();
 			   table.destroy();
			}

			 $("#"+table+"_table").dataTable({
				"displayLength": -1,
				 "lengthMenu": [[15, 25, 50, -1], [15, 25, 50, "All"]],
				"searching": true,
				"ordering": true,
				"info": false,
				"autoWidth": true,

				"columnDefs": [
				    { "width": "20%", "targets": 1 },
				    { "width": "10%", "targets": 2 },
    				    { "width": "2%", "targets": 0 },
       				    { "width": "5%", "targets": 4 },
       				    { "width": "5%", "targets": 5 },
				    { "class": "details-control", "targets": 0 }
				  ],

				"fnDrawCallback":function(){

					row="<tr>";
					row+="	<td></td>";
					row+="	<td><input class='new_feis_name form-control' type=text style='width:100%'></td>";
					row+="	<td><input class='new_feis_city form-control' type=text style='width:100%'></td>";
					row+="	<td style='text-align:center'><input class='new_feis_date form-control'  type=text style='width:100%'></td>";
					row+="	<td style='text-align:center'><input type=button class='user_button blue_button' value='Сохранить' onclick='add_feis($(this))'></td>";
					row+="	<td  style='text-align:center'></td>";
					row+="	</tr>";

					if (table=='feis'){
						$('#feis_table tbody ').prepend(row);
					}


					tds=$("#"+table+"_table tbody").find('td.details-control').not('td.details-control:last');
					tds.off();
					tds.bind('click', function () {
						bind_open_child_admin(table,$(this));
					});

				},

			});


			 $( "#"+table+"_table" ).DataTable().on( 'order.dt search.dt', function () {
			        $( "#"+table+"_table" ).DataTable().column(0, {search:'applied', order:'applied'}).nodes().each( function (cell, i) {
			            cell.innerHTML = i+1;
			        } );
			    } ).draw();

			$('.new_feis_city').autocomplete({
				      minLength: 1,
			 	      autoFocus: true,
				      source: function( request, response ) {
					element=this.element;
				        var term = request.term;
					$.ajax({
					          url: "../teacher/actions.php",
					          dataType: "json",
					          data: {
					            term: request.term,
					            flag:'get_cities',
					          },
					          success: function( data ) {
						          response( data );
					          }
					        });
				      },
						     select: function( event, ui ) {
								$('.new_feis_city').attr('name',ui.item.id);
							}
			});

			$('.new_feis_date').datepicker({
				"dateFormat": "yy-mm-dd" ,
				changeMonth: true,
		   	        changeYear: true,
			});


		bind_org_surname_autocomplete(table);

		if (table=='teachers'){
			 bind_org_school_autocomplete();
		}


		//$(".group_select").chosen({
		//	placeholder_text_multiple: "Выберите группы",
		//})

		 $('.group_select').on('change', function(evt, params) {
			selectlistid=$(this).attr('id');

		    if (params.selected!=undefined){
			    $.ajax({
				     url: "actions.php",
				     async:false,
				     type:"post",
				     data: { 
						action: "add_to_group", 
						group_id:params.selected,
						chosen_ids:selectlistid+"#",
				     },
     				     success: function( data ) { 
				     	console.log(data);
				     }

				});
		    }
   		    if (params.deselected!=undefined){
			    $.ajax({
				     url: "actions.php",
				     async:false,
				     type:"post",
				     data: { 
						action: "remove_from_group", 
						group_id:params.deselected,
						chosen_ids:selectlistid+"#",
				     },
				     success: function( data ) { 
				     	console.log(data);
				     }
				});
		    }

		  });

		 $('#group_select_all').on('change', function(evt, params) {
		    array=$('.teachers_checkbox:checked');
  		    chosen_ids="";
		    for (i=0;i<array.length;i++){
			chosen_ids+=$(array[i]).attr('id')+"#";
		    }

		    if (params.selected!=undefined){
			    $.ajax({
				     url: "actions.php",
				     async:false,
				     type:"post",
				     data: { 
						action: "add_to_group", 
						group_id:params.selected,
						chosen_ids:chosen_ids
				     },
     				     success: function( data ) { 
				     	console.log(data);
				     }

				});
		    }
   		    if (params.deselected!=undefined){
			    $.ajax({
				     url: "actions.php",
				     async:false,
				     type:"post",
				     data: { 
						action: "remove_from_group", 
						group_id:params.deselected,
						chosen_ids:chosen_ids
				     },
				     success: function( data ) { 
				     	console.log(data);
				     }
				});
		    }

		  });

		 $('.chosen-choices ').on('click', function(evt, params) {
			selectlistid=$(this).parent().attr('id').split('_');


	 		$.ajax({
			     url: "actions.php",
			     async:false,
			     data: { user_id: selectlistid[1], action: 'get_groups' },
			     type:'post',
			     success: function (data, textStatus) { 
				$('#select_'+selectlistid[1]+' option').not(':selected').remove();
				 $('#select_'+selectlistid[1]).append(data);
			     } 
			});
			 $('#select_'+selectlistid[1]).trigger("chosen:updated");
		  });
		
}

function bind_open_child_admin(table_name,elem,feisid){

rowid=elem.parent().attr('id');
feisid=feisid || "";
if (feisid==""){feisid=elem.attr('name')}

				table = $("#"+table_name+"_table").DataTable();

			        var tr = elem.closest('tr');

			        var row = table.row( tr );

			        if ( tr.hasClass('shown') ) {
			            row.child(false);
			            row.child.hide();
			            tr.removeClass('shown');
			        }
			        else {

			            // Open this row
					$( "#"+table_name+"_table" ).find('tbody tr').each( function () {
					    if($(this).hasClass('shown')){
						 var tr2 = $(this);
				  	         var row2 = table.row( tr2 );
					         row2.child(false);
					         row2.child().hide();
					         tr2.removeClass('shown');
					    }
					} );

		  		        row.child(associated_users(feisid,table_name,rowid)).show();

					row.child().hide();

					if ( $.fn.dataTable.isDataTable( ".associated_users" ) ) {
						dances_table = $( ".associated_users" ).DataTable();
						dances_table.destroy();
					}
					$(".associated_users").DataTable({
						"columnDefs": [
						    { "orderable": false, "targets": [2,3] }
						  ],

						"displayLength": -1,
						"lengthChange": false,
						"searching": true,
						"ordering": true,
						"info": false,
						"responsive": {
							details: false
				
						},
						"fnDrawCallback":function(){

						},
					});

					if ( $.fn.dataTable.isDataTable( ".associated_levels" ) ) {
						levels_table = $( ".associated_levels" ).DataTable();
						levels_table.destroy();
					}
					$(".associated_levels").DataTable({
						"displayLength": -1,
						"lengthChange": false,
						"searching": false,
						"ordering": false,
						"info": false,
						"responsive": {
							details: false
				
						},
					});

			            tr.addClass('shown');



				row.child().fadeIn("slow");
			        };

}

function associated_users(feis_id, table_name){

 		$.ajax({
		     url: "actions.php",
		     async:false,
		     data: { table_name: table_name, feis_id:feis_id, rowid:rowid, action: 'show_associated_users' },
		     type:'post',
		     success: function (data, textStatus) { 
			result=data
		     } 
		});


return result;

}

function set_access(user_id, permission, feis_id, elem){
		status=0;
		if (elem.prop('checked')){status=1;}
		if (permission==0){
			$(".set_access_checkbox_"+user_id).prop('checked','');
			elem.prop('checked','checked');
		}
		else {

			$("#set_access_0_"+user_id).prop('checked','');
		}

 		$.ajax({
		     url: "actions.php",
		     async:false,
		     data: { feis_id: feis_id, user_id:user_id, permission:permission, action: 'set_access' ,status:status},
		     type:'post',
		     success: function (data, textStatus) { 

		     } 
		});


return result;

}

function assoc_selected(user_id,role_id,feis_id,elem){

 		$.ajax({
		     url: "actions.php",
		     async:false,
		     data: { user_id: user_id,role_id: role_id,feis_id: feis_id, checked: elem.prop('checked'), action: 'assoc_selected_users' },
		     type:'post',
		});

}

function assoc_selected_lvl(lvl_id,feis_id,elem){

 		$.ajax({
		     url: "actions.php",
		     async:false,
		     data: { lvl_id: lvl_id,feis_id: feis_id, checked: elem.prop('checked'), action: 'assoc_selected_levels' },
		     type:'post',
		});

}



function assoc_all_users(role_id,feis_id,elem){
	if (elem.prop('checked')){
		$(".checkbox_"+role_id).prop('checked',true);
	}else{
		$(".checkbox_"+role_id).prop('checked',false);
	}
 		$.ajax({
		     url: "actions.php",
		     async:false,
		     data: { role_id:role_id,feis_id: feis_id, checked: elem.prop('checked'), action: 'assoc_all_users' },
		     type:'post',
		});

}


function bind_org_surname_autocomplete(type){

	$('.new_'+type+'_surname').autocomplete({
	      minLength: 2,
 	      autoFocus: true,
	      source: function( request, response ) {
		element=this.element;
	        var term = request.term;
		$.ajax({
		          url: "search_users.php",
		          dataType: "json",
		          data: {
		            term: request.term,
			    type: type,
		          },
		          success: function( data ) {
			          response( data );
		          }
		        });

	      },

		select: function( event, ui ) {

			$.ajax({
				     url: "actions.php",
				     async:false,
				     type:"post",
				     data: { 
			         	   action: "add_"+type,
				    	   id: ui.item.id,
			              },
	        	     success: function( data ) { 

					thistd=element.parent();
					element.parent().html(ui.item.surname);
					thistd.nextAll().eq(0).html(ui.item.name);
					thistd.nextAll().eq(1).html(ui.item.email);

					thistd.nextAll().eq(2).html("<input type=button value='Выслать' onclick=\"new_password($(this),"+ui.item.id+")\">");
					thistd.nextAll().eq(3).html("<input type=button class='user_button delete_button'  onclick=\"delete_"+type+"($(this),"+ui.item.id+")\">");

					row=thistd.parent();
					thistable=row.parents('table').DataTable();
					var rowdata=new Array();
					rowdata[0]="";
					rowdata[1]="<input class='new_"+type+"_surname' type=text style='width:100%'>";
					rowdata[2]="<input class='new_"+type+"_name' type=text style='width:100%'>";
					rowdata[3]="<input class='new_"+type+"_email' type=text style='width:100%'>";
					rowdata[4]="";
					rowdata[5]="";
					rowdata[6]="";					
					newrow=thistable.row.add(rowdata).draw().nodes().to$();
					newrow.children('td:eq(4)').css('text-align','center');
					newrow.children('td:eq(5)').css('text-align','center');

					bind_org_surname_autocomplete(type);

			          }
			        });


				
		},
			
	
	
			    })

}

function bind_org_school_autocomplete(){

	$('.new_teachers_school').autocomplete({
	      minLength: 2,
 	      autoFocus: true,
	      source: function( request, response ) {
		element=this.element;
	        var term = request.term;
		$.ajax({
		          url: "search_schools.php",
		          dataType: "json",
		          data: {
		            term: request.term,

		          },
		          success: function( data ) {
			          response( data );
						
		          }
		        });

	      },

		select: function( event, ui ) {
			element.attr('id',ui.item.id);
				
		},
			
	
	
			    })

}

function save_new_teacher(element){
			surname=$(".new_teachers_surname").val();
			name=$(".new_teachers_name").val();
			email=$(".new_teachers_email").val();
			school_id=$(".new_teachers_school").attr('id');

			$.ajax({
				     url: "actions.php",
				     async:false,
				     type:"post",
				     data: { 
			         	   action: "add_new_teacher",
								surname:surname,
								name:name,
								email:email,
								school_id:school_id,
	
			              },
	        	     success: function( data ) { 
								id=data;
								thistd=element.parents('tr');
								$(".new_teachers_surname").parent().html(surname);
								$(".new_teachers_name").parent().html(name);
								$(".new_teachers_email").parent().html(email);
								$(".new_teachers_school").parent().css('text-align','center');
								$(".new_teachers_school").parent().html("<input type=button class='user_button blue_button' value='Выслать' onclick=\"new_password($(this),"+id+")\">");


								element.parent().html("<input type=button class='user_button delete_button'  onclick=\"delete_teachers($(this),"+id+")\">");
			
								row=thistd.parent();
								thistable=row.parents('table').DataTable();
								var rowdata=new Array();
								rowdata[0]="";
								rowdata[1]="<input class='new_teacher_surname' type=text style='width:100%' placeholder='Last name'>";
								rowdata[2]="<input class='new_teacher_name' type=text style='width:100%' placeholder='Name'>";
								rowdata[3]="<input class='new_teacher_email' type=text style='width:100%' placeholder='Email'>";
								rowdata[4]="<td><input class='new_teachers_school' type=text style='width:250px' placeholder='Start typing school'></td>";
								rowdata[5]="<td style='text-align:center'><input type=button class='user_button blue_button' value='Сохранить' onclick=\"save_new_teacher($(this),"+id+")\"></td>";
								rowdata[6]="";					
								newrow=thistable.row.add(rowdata).draw().nodes().to$();
								newrow.children('td:eq(4)').css('text-align','center');
								newrow.children('td:eq(5)').css('text-align','center');
			
								bind_org_surname_autocomplete('teachers');
								bind_org_school_autocomplete();
			          }
			        });


}


function delete_orgs(elem,org_id){

if (confirm("Вы уверены?")){
		row=elem.parents('tr');
		table=row.parents('table').DataTable();
		table.row(row).remove().draw();
		$.ajax({
			     url: "actions.php",
			     async:false,
			     type:"post",
			     data: { 
					action: "delete_orgs", 
					id:org_id,
			     },
			});
	}

}

function delete_teachers(elem,teacher_id){

if (confirm("Вы уверены?")){
		row=elem.parents('tr');
		table=row.parents('table').DataTable();
		table.row(row).remove().draw();
		$.ajax({
			     url: "actions.php",
			     async:false,
			     type:"post",
			     data: { 
					action: "delete_teachers", 
					id:teacher_id,
			     },
			});
	}

}

function add_feis(elem){

	row=elem.parents('tr');

	table=row.parents('table').DataTable();
	feisname=row.children('td:eq(1)');
	city=row.children('td:eq(2)');
	date=row.children('td:eq(3)');


	if ((feisname.children('input').val()!="") && (city.children('input').val()!="") && (date.children('input').val()!="")){
		$.ajax({
			     url: "actions.php",
			     async:false,
			     type:"post",
			     data: { 
					action: "add_feis", 
					name: feisname.children('input').val(),
					city: city.children('input').attr('name'),
					date: date.children('input').val(),
			     },
	        	     success: function( data ) {
				if (data!=""){
					table=$("#feis_table").DataTable();	

					var rowdata=new Array();
					rowdata[0]="";
					rowdata[1]=feisname.children('input').val();
					rowdata[2]=city.children('input').val();
					rowdata[3]=date.children('input').val();
					rowdata[4]="<input type=button class='user_button blue_button' class='user_button blue_button' value='Править' onclick=\"edit_feis($(this),"+data+")\">";
					rowdata[5]="<input type=button class='user_button delete_button'  onclick='remove_feis($(this),"+data+")'>";
					rowdata[6]="";

/*
					rowdata[1]="<input class='new_feis_name form-control' type=text style='width:100%'>";
					rowdata[2]="<input class='new_feis_city form-control' type=text style='width:100%'>";
					rowdata[3]="<input class='new_feis_date form-control' type=text style='width:100%'>";
					rowdata[4]="<input type=button class='user_button blue_button' value='Сохранить' onclick='add_feis($(this))'>";
					rowdata[5]="";
					rowdata[6]="";
*/				
//					feisname.html(feisname.children('input').val());
//					city.html(city.children('input').val());
//					date.html(date.children('input').val());
//					elem.attr('value',"Править");
//					elem.off();
//					elem.on('click', function(event) { edit_feis($(this),data) });
//					row.children('td:eq(5)').html("<input type=button class='user_button delete_button'  onclick='remove_feis($(this),"+data+")'>");
					/*
					var rowdata=new Array();
					rowdata[0]="";
					rowdata[1]="<input class='new_feis_name form-control' type=text style='width:100%'>";
					rowdata[2]="<input class='new_feis_city form-control' type=text style='width:100%'>";
					rowdata[3]="<input class='new_feis_date form-control' type=text style='width:100%'>";
					rowdata[4]="<input type=button class='user_button blue_button' value='Сохранить' onclick='add_feis($(this))'>";
					rowdata[5]="";
					rowdata[6]="";
					*/
				
					newrow=table.row.add(rowdata).order([[3, 'desc']]).draw().nodes().to$();
					newrow.children('td:eq(0)').addClass('details-control').attr('name',data);
					newrow.children('td:eq(3)').css('text-align','center');

					newrow.children('td:eq(4)').css('text-align','center');
					newrow.children('td:eq(5)').css('text-align','center');

					$('.new_feis_date').datepicker({
						"dateFormat": "yy-mm-dd" ,
						changeMonth: true,
				   	        changeYear: true,
					});
					$('.new_feis_city').autocomplete({
						      minLength: 1,
					 	      autoFocus: true,
						      source: function( request, response ) {
							element=this.element;
						        var term = request.term;
							$.ajax({
							          url: "../teacher/actions.php",
							          dataType: "json",
							          data: {
							            term: request.term,
							            flag:'get_cities',
							          },
							          success: function( data ) {
								          response( data );
									  
							          }
							});
						      },

					});		
				}
			     }
			});
		}


}

function add_city(elem){
	
	row=elem.parents('tr');
	table=row.parents('table').DataTable();
	cityname=row.children('td:eq(1)');
	if ((cityname.children('input').val()!="")){
		$.ajax({
			     url: "actions.php",
			     async:false,
			     type:"post",
			     data: { 
					action: "add_city", 
					name: cityname.children('input').val(),
			     },
	        	     success: function( data ) {
				if (data!=""){
					cityname.html(cityname.children('input').val());
//					elem.attr('value',"Править");
//					elem.off();
//					elem.on('click', function(event) { edit_city($(this),data) });
					row.children('td:eq(3)').html("<input type=button class='user_button blue_button' value='Править' onclick=\"edit_city($(this),"+data+")\">");
					row.children('td:eq(4)').html("<input type=button class='user_button delete_button'  onclick=\"delete_city($(this),"+data+")\">");
				
					var rowdata=new Array();
					rowdata[0]="";
					rowdata[1]="<input class='new_city_name' type=text style='width:100%'>";
					rowdata[2]="";
					rowdata[3]="<input type=button value='Сохранить' onclick=\"add_city($(this))\">";
					rowdata[4]="";
					rowdata[5]="";					
					newrow=table.row.add(rowdata).draw().nodes().to$();
					newrow.children('td:eq(3)').css('text-align','center');
					newrow.children('td:eq(4)').css('text-align','center');


	
				}
			     }
			});
		}
	

}
function add_country(elem){
	
	row=elem.parents('tr');
	table=row.parents('table').DataTable();
	countryname=row.children('td:eq(1)');
	if ((countryname.children('input').val()!="")){
		$.ajax({
			     url: "actions.php",
			     async:false,
			     type:"post",
			     data: { 
					action: "add_country", 
					name: countryname.children('input').val(),
			     },
	        	     success: function( data ) {
				if (data!=""){
					countryname.html(countryname.children('input').val());
//					elem.attr('value',"Править");
//					elem.off();
//					elem.on('click', function(event) { edit_country($(this),data) });
					row.children('td:eq(3)').html("<input type=button class='user_button blue_button' value='Править' onclick=\"edit_country($(this),"+data+")\">");
					row.children('td:eq(4)').html("<input type=button class='user_button delete_button'  onclick=\"delete_country($(this),"+data+")\">");
				
					var rowdata=new Array();
					rowdata[0]="";
					rowdata[1]="<input class='new_country_name' type=text style='width:100%'>";
					rowdata[2]="";
					rowdata[3]="<input type=button value='Сохранить' onclick=\"add_country($(this))\">";
					rowdata[4]="";
					rowdata[5]="";					
					newrow=table.row.add(rowdata).draw().nodes().to$();
					newrow.children('td:eq(3)').css('text-align','center');
					newrow.children('td:eq(4)').css('text-align','center');


	
				}
			     }
			});
		}
	

}

function add_school(elem){
	
	row=elem.parents('tr');
	table=row.parents('table').DataTable();
	schoolname=row.children('td:eq(1)');
	org=row.children('td:eq(2)');
	org_cell=org.html();
	if ((schoolname.children('input').val()!="")){
		$.ajax({
			     url: "actions.php",
			     async:false,
			     type:"post",
			     data: { 
					action: "add_school", 
					name: schoolname.children('input').val(),
					organization_id: org.children('select').val(),
			     },
	        	     success: function( data ) {
				if (data!=""){
					schoolname.html(schoolname.children('input').val());

					row.children('td:eq(2)').html("0");
					row.children('td:eq(2)').css('text-align','left');
					row.children('td:eq(4)').html('');
					row.children('td:eq(4)').html("<input type=button class='user_button blue_button' value='Править' onclick=\"edit_school($(this),"+data+")\">");
					row.children('td:eq(4)').css('text-align','center');
					row.children('td:eq(5)').html("<input type=button class='user_button delete_button'  onclick=\"delete_school($(this),"+data+")\">");
					row.children('td:eq(5)').css('text-align','center');

					var rowdata=new Array();
					rowdata[0]="";
					rowdata[1]="<input class='new_school_name' type=text style='width:100%'>";
					rowdata[2]=org_cell;
					rowdata[3]="";
					rowdata[4]="<input type=button class='user_button blue_button' value='Сохранить' onclick=\"add_school($(this))\">";
					rowdata[5]="";
					newrow=table.row.add(rowdata).draw().nodes().to$();
					newrow.children('td:eq(2)').css('text-align','left');
					newrow.children('td:eq(3)').css('text-align','center');
					newrow.children('td:eq(4)').css('text-align','center');


	
				}
			     }
			});
		}
	

}

function edit_feis(elem,feis_id){
elem.removeAttr('onclick');
elem.off();
	elem.attr('value',"Сохранить");

	row=elem.parents('tr');

	feisname=row.children('td:eq(1)');
	feisname.html("<input style='width:100%' type=text value='"+row.children('td:eq(1)').html()+"'>");

	city=row.children('td:eq(2)');
	city.html("<input style='width:100%' type=text value='"+row.children('td:eq(2)').html()+"'>").children('input').autocomplete({
		      minLength: 1,
	 	      autoFocus: true,
		      source: function( request, response ) {
			element=this.element;
		        var term = request.term;
			$.ajax({
			          url: "../teacher/actions.php",
			          dataType: "json",
			          data: {
			            term: request.term,
			            flag:'get_cities',
			          },
			          success: function( data ) {
				          response( data );
			          }
			});
		      },
	});
	date=row.children('td:eq(3)');
	date.html("<input style='width:100%' type=text value='"+row.children('td:eq(3)').html()+"'>").children('input').datepicker({
			"dateFormat": "yy-mm-dd" ,
			changeMonth: true,
	   	        changeYear: true,
	});


	elem.attr('value',"Сохранить").on( "click", function(event) { 
		$.ajax({
		     url: "actions.php",
		     async:false,
		     type:"post",
		     data: { 
				action: "save_feis_edit", 
				name: feisname.children('input').val(),
				city: city.children('input').val(),
				date: date.children('input').val(),
				feis_id:feis_id,
		     },
		     success: function (data, textStatus) { 
				elem.attr('value',"Править");
				feisname.html(feisname.children('input').val());
				city.html(city.children('input').val());
				date.html(date.children('input').val());
				elem.on('click', function(event) { edit_feis($(this),feis_id) });
		     } 
		});
	});
}
function edit_school(elem,school_id){

elem.removeAttr('onclick');
elem.off();
	elem.attr('value',"Сохранить");

	row=elem.parents('tr');

	schoolname=row.children('td:eq(1)');
	schoolname.html("<input style='width:100%' type=text value='"+row.children('td:eq(1)').html()+"'>");

	code=row.children('td:eq(3)');
	code.html("<input style='width:100%' type=text value='"+row.children('td:eq(3)').html()+"'>");



	elem.attr('value',"Сохранить").on( "click", function(event) { 
		$.ajax({
		     url: "actions.php",
		     async:false,
		     type:"post",
		     data: { 
				action: "save_school_edit", 
				schoolname: schoolname.children('input').val(),
				code: code.children('input').val(),
				school_id:school_id,
		     },
		     success: function (data, textStatus) { 
				elem.attr('value',"Править");
				schoolname.html(schoolname.children('input').val());
				code.html(code.children('input').val());
				elem.on('click', function(event) { edit_school($(this),feis_id) });
		     } 
		});
	});
}
function edit_city(elem,city_id){
elem.removeAttr('onclick');
elem.off();
	elem.attr('value',"Сохранить");

	row=elem.parents('tr');

	cityname=row.children('td:eq(1)');
	cityname.html("<input style='width:100%' type=text value='"+row.children('td:eq(1)').html()+"'>");

	elem.attr('value',"Сохранить").on( "click", function(event) { 
		$.ajax({
		     url: "actions.php",
		     async:false,
		     type:"post",
		     data: { 
				action: "save_city_edit", 
				name: name.children('input').val(),
				city_id: city_id,
		     },
		     success: function (data, textStatus) { 
				elem.attr('value',"Править");
				name.html(name.children('input').val());
				elem.on('click', function(event) { edit_city($(this),city_id) });
		     } 
		});
	});
}

function edit_country(elem,country_id){
elem.removeAttr('onclick');
elem.off();
	elem.attr('value',"Сохранить");

	row=elem.parents('tr');

	countryname=row.children('td:eq(1)');
	cuntryname.html("<input style='width:100%' type=text value='"+row.children('td:eq(1)').html()+"'>");

	elem.attr('value',"Сохранить").on( "click", function(event) { 
		$.ajax({
		     url: "actions.php",
		     async:false,
		     type:"post",
		     data: { 
				action: "save_country_edit", 
				countryname: name.children('input').val(),
				country_id: country_id,
		     },
		     success: function (data, textStatus) { 
				elem.attr('value',"Править");
				countryname.html(countryname.children('input').val());
				elem.on('click', function(event) { edit_country($(this),country_id) });
		     } 
		});
	});
}

function remove_feis(elem,feis_id){

	if (confirm("Вы уверены?")){
		row=elem.parents('tr');
		table=row.parents('table').DataTable();
		table.row(row).remove().draw();
		$.ajax({
			     url: "actions.php",
			     async:false,
			     type:"post",
			     data: { 
					action: "remove_feis", 
					feis_id:feis_id,
			     },
			});
	}
}

function delete_city(elem,city_id){

	if (confirm("Вы уверены?")){
		row=elem.parents('tr');
		table=row.parents('table').DataTable();
		table.row(row).remove().draw();
		$.ajax({
			     url: "actions.php",
			     async:false,
			     type:"post",
			     data: { 
					action: "delete_city", 
					city_id:city_id,
			     },
			});
	}
}

function delete_country(elem,country_id){

	if (confirm("Вы уверены?")){
		row=elem.parents('tr');
		table=row.parents('table').DataTable();
		table.row(row).remove().draw();
		$.ajax({
			     url: "actions.php",
			     async:false,
			     type:"post",
			     data: { 
					action: "delete_country", 
					country_id:country_id,
			     },
			});
	}
}

function delete_school(elem,school_id){

	if (confirm("Вы уверены?")){
		row=elem.parents('tr');
		table=row.parents('table').DataTable();
		table.row(row).remove().draw();
		$.ajax({
			     url: "actions.php",
			     async:false,
			     type:"post",
			     data: { 
					action: "delete_school", 
					school_id:school_id,
			     },
			});
	}
}

function add_users(elem){     // ДОДЕЛАТЬ

	row=elem.parents('tr');
	table=row.parents('table').DataTable();
	surname=row.children('td:eq(1)');
	name=row.children('td:eq(2)');
	email=row.children('td:eq(3)');

		$.ajax({
		     url: "actions.php",
		     async:false,
		     type:"post",
		     data: { 
	         	   action: "add_new_org",
		    	   surname: surname.children('input').val(),
		    	   name: name.children('input').val(),
		    	   email: email.children('input').val(),
	              },
		     success: function( data ) { 
	
			surname.html(surname.children('input').val());
			name.html(name.children('input').val());
			email.html(email.children('input').val());
	
	
			row.children('td:eq(4)').html("<input type=button value='Выслать' onclick=\"new_password($(this),"+data+")\">");
			row.children('td:eq(5)').html("<input type=button class='user_button delete_button'  onclick=\"delete_org($(this),"+data+")\">");
	
			var rowdata=new Array();
			rowdata[0]="";
			rowdata[1]="<input class='new_orgs_surname' type=text style='width:100%'>";
			rowdata[2]="<input class='new_orgs_name' type=text style='width:100%'>";
			rowdata[3]="<input class='new_orgs_email' type=text style='width:100%'>";
			rowdata[4]="";
			rowdata[5]="";
			newrow=table.row.add(rowdata).draw().nodes().to$();
			newrow.children('td:eq(4)').css('text-align','center');
			
			newrow.children('td:eq(5)').css('text-align','center');
			bind_org_surname_autocomplete();
		}
	});
}


function new_password(elem,user_id){

	elem.attr("value","Выслано");
	$.ajax({ 
	     url: "actions.php",
	     async:false,
	     type:"post",
	     data: { 
         	   action: "send_new_password",
		   user_id:user_id,
              },
	});
}


function add_group(elem){
	
	row=elem.parents('tr');
	table=row.parents('table').DataTable();
	groupname=row.children('td:eq(1)');
	if ((groupname.children('input').val()!="")){
		$.ajax({
			     url: "actions.php",
			     async:false,
			     type:"post",
			     data: { 
					action: "add_group", 
					name: groupname.children('input').val(),
			     },
	        	     success: function( data ) {
				if (data!=""){
					groupname.html(groupname.children('input').val());

					row.children('td:eq(3)').html("<input type=button class='user_button blue_button' value='Править' onclick=\"edit_group($(this),"+data+")\">");
					row.children('td:eq(4)').html("<input type=button class='user_button delete_button'  onclick=\"delete_group($(this),"+data+")\">");
				
					var rowdata=new Array();
					rowdata[0]="";
					rowdata[1]="<input class='new_group_name' type=text style='width:100%'>";
					rowdata[2]="";
					rowdata[3]="<input type=button value='Сохранить' onclick=\"add_group($(this))\">";
					rowdata[4]="";
					rowdata[5]="";
					newrow=table.row.add(rowdata).draw().nodes().to$();
					newrow.children('td:eq(3)').css('text-align','center');
					newrow.children('td:eq(4)').css('text-align','center');


	
				}
			     }
			});
		}

}

function delete_group(elem,group_id){

	if (confirm("Вы уверены?")){
		row=elem.parents('tr');
		table=row.parents('table').DataTable();
		table.row(row).remove().draw();
		$.ajax({
			     url: "actions.php",
			     async:false,
			     type:"post",
			     data: { 
					action: "delete_group", 
					group_id:group_id,
			     },
			});
	}
}

function populate_select(){
alert();

}