$(document).ready(function() {
    $('#navbarDashboardMenuLink').addClass('active');

    /****************/
	/* URL Variable */
	/****************/
	function query_string(variable) {
		var query = window.location.search.substring(1);
		var vars = query.split("&");
		for (var i=0;i<vars.length;i++) {
			var pair = vars[i].split("=");
			if(pair[0] == variable){return pair[1];}
		}
		return(false);
	}

	smonth = query_string('month');
	sstatus = query_string('status');
    $('.navbar-brand').text('Service Jobs ('+smonth+' - '+decodeURIComponent(sstatus)+')');

    var table = $('#orderTable').DataTable( {
		"dom": '<f<t><"col-6"><"row"<"col-6"i><"col-6"p>>>',
        "ajax": {
            "url": "data/reports/service-status.php",
            "type": "POST",
			"data": function ( d ) {
				d.smonth = smonth;
				d.sstatus = sstatus;
            }
        },
		"deferRender": true,
		"pageLength": 25,
		"responsive": true,
		"stateSave": false,
        "pagingType": "first_last_numbers",
		"order": [ 0, 'asc' ],
		"language": {
			"info": "Showing _START_ to _END_ of _TOTAL_ entries",
            "infoFiltered": ""
		},
		"columns": [
			{
				"data": "Date",
				"sWidth": "7%"
			},
			{
				"data": "Ref",
				"sWidth": "7%"
			},
			{
				"data": "company_name",
				"sWidth": "12%"
			},
			{
				"data": "site_address_1",
				"sWidth": "22%"
			},
			{
				"data": "resource_name",
				"sWidth": "6%"
			},
			{
				"data": "Chase",
				"sWidth": "6%"
			},
			{
				"data": "Return",
				"sWidth": "6%"
			},
			{
				"data": "Sent",
				"sWidth": "6%"
			},
            {
				"data": "Status",
				"sWidth": "6%"
			},
            {
				"data": "Value",
				"sWidth": "6%"
			},
            {
				"data": "%",
				"sWidth": "6%"
			},
            {
				"data": "Days",
				"sWidth": "6%"
			}
		],
		"initComplete": function(settings, json) {
	    },
		"columnDefs": [
			/*{
				"targets": 1,
				"render": function ( data, type, row ) {
                    return '<a href="service-summary.php?id=' + row.service_id + '">' + data + '</a>';

				}
			},
			{
				"targets": 2,
				"render": function ( data, type, row ) {
					return '<a href="client-summary.php?id=' + row.company_id + '">' + data + '</a>';
				}
			},
			{
				"targets": 3,
				"render": function ( data, type, row ) {
					siteAddress = data;
					if (row.site_address_2) {
						siteAddress += ', ' + row.site_address_2;
					}
					if (row.site_address_3) {
						siteAddress += ', ' + row.site_address_3;
					}
					siteAddress += ', ' + row.site_town;
					siteAddress += ', ' + row.site_postcode;
					return siteAddress;
				}
			},
			{
				"targets": 6,
				"render": function ( data, type, row ) {
					if (data) {
						return data;
					} else {
						return '0.00';
					}
				}
			}*/
		]
	});
})