$('#mainTable').dataTable( {
    			//"bJQueryUI": true,
				"sScrollY": 450,
				"sScrollX": "95%",
				//"sScrollXInner": "100%",
        		"bPaginate": true,
	        	"bLengthChange": false,
    	    	"bFilter": false,
	        	"bSort": true,
    			"bInfo": false,
	        	"bAutoWidth": true,
    			"bProcessing": true,
	        	"bServerSide": true,
        		"sAjaxSource": "calc2_data.php<?=$data?>",
        		"aoColumnDefs": [
            		{ "bSortable": true, "aTargets": [ 0 ] }
		        ],
		        "aaSorting": [[ 1, 'asc' ]],

$(document).ready(function() {
$('#mainTable').dataTable( {
//"bJQueryUI": true,
"sScrollY": 450,
"sScrollX": "95%",
//"sScrollXInner": "100%",
"bPaginate": true,
"bLengthChange": false,
"bFilter": false,
"bSort": true,
"bInfo": false,
"bAutoWidth": true,
"bProcessing": true,
"bServerSide": true,
"sAjaxSource": "calc2_data.php?dt1=02.04.2013&dt2=03.04.2013",
"aoColumnDefs": [
{ "bSortable": true, "aTargets": [ 0 ] }
],
"aaSorting": [[ 1, 'asc' ]], 

<script type="text/javascript">
		$(document).ready(function() {
    		$('#mainTable').dataTable( {
    			//"bJQueryUI": true,
				"sScrollY": 450,
				"sScrollX": "95%",
				//"sScrollXInner": "100%",
				
        		"bPaginate": false,
	        	"bLengthChange": false,
    	    	"bFilter": false,
	        	"bSort": true,
    			"bInfo": false,
	        	"bAutoWidth": true,
    			"bProcessing": false,
	        	"bServerSide": true,
        		"sAjaxSource": "calc2_data.php<?=$data?>",
        		"aoColumnDefs": [
          { "asSorting": [ "asc" ], "aTargets": [ 1 ] },
         { "asSorting": [ "desc", "asc", "asc" ], "aTargets": [ 2 ] },
         { "asSorting": [ "desc" ], "aTargets": [ 3 ] },
		  { "asSorting": [ "asc" ], "aTargets": [ 4 ] },
         { "asSorting": [ "desc", "asc", "asc" ], "aTargets": [ 5 ] },
         { "asSorting": [ "desc" ], "aTargets": [ 6 ] }
		 
		        ],
				
     "iDefaultSortIndex": 2, 
	 "sDefaultSortDirection": "asc" ,
    

				"fnRowCallback": function( nRow, aData, iDisplayIndex ) {
		            if ( aData[0] == "G" ) {
	                    var nGroup = document.createElement( 'tr' );
	                    var nCell = document.createElement( 'td' );
	                    nCell.className = "group1 left";
	                    nCell.innerHTML = aData[1];
	                    nCell.colSpan = 8;
	                    nGroup.appendChild( nCell );
	                    nRow = nGroup;
	                } else if ( aData[0] == "A") {
	                    var nGroup = document.createElement( 'tr' );
	                    var nCell = document.createElement( 'td' );
	                    nCell.className = "avg1 right";
	                    nCell.innerHTML = aData[1];
	                    nGroup.appendChild( nCell );

	                	var span = 2;
		                for( var j=2; j<aData.length; j++ ) {
		                	if( aData[j] == "" ) {
		                		span++;
		                	} else {
	                    		var nCell2 = document.createElement( 'td' );
	                    		nCell2.className = "avg1";
	                    		nCell2.innerHTML = aData[j];
	                    		nGroup.appendChild( nCell2 );
		                	}
		                }

	                    nCell.colSpan = span;
	                    nRow = nGroup;
		                //$('td:eq(4)', nRow).html( '<b>A</b>' );
		            }
		            for(var i=4; i<=5; i++) {
	            		if(aData[i] > 0) {
		            		$('td:eq(' + i + ')', nRow).addClass( 'green' );
	            		} else if(aData[i] < 0) {
		            		$('td:eq(' + i + ')', nRow).addClass( 'red' );
	            		}
	            	}
		            return nRow;
		        },
    		} );

            $.datepicker.setDefaults( $.datepicker.regional[ "ru" ] );
            $( "#dt1,#dt2" ).datepicker($.datepicker.regional[ "ru" ]);

            $.getJSON('calc2_idata.php<?= $data ?>', function(data) {
              var items = [];

              prevGrp = -1;
              $.each(data, function(key, val) {
                    if(prevGrp!=val[3]) {
                        prevGrp=val[3];
                        items.push('<dt id="' + key + '"><input type="checkbox" name="grp_' + val[3] + '"/>' + val[4] + '</dt>');
                    }
                    items.push('<dd id="' + key + '"><input type="checkbox" name="code_' + val[2] + '" ' + (val[5] ? 'checked' : '') + '/>' + val[0] + '</dd>');
                    
              });

              $('<dl/>', {
                'class': 'my-new-list',
                html: items.join('')
              }).appendTo('div#setuplist');

              $("dt > :checkbox").click(function() {
                var cbs = $(this).parent().nextUntil("dt").children(":checkbox");
                if($(this).attr('checked')) {
                    cbs.attr('checked', 'checked');
                } else {
                    cbs.removeAttr('checked');
                }
              });
            });

            $("a.setup").fancybox(
            {
                "width": 800,
                "height": 300,
                "overlayShow": false,
            });                
		} );
	</script>