$(function () {
	DataGridTest.init();
});		

DataGridTest = {
    divGrid: '#divDC',
    hdnSort: '#hdnSort',
    hdnSortDir: '#hdnSortDir',
    hdnPage: '#hdnPage',
    hdnPageSize: '#hdnPageSize',
    datagrid: null,
    init: function () {
        var self = this;
        $(self.divGrid).datagrid({ 
            // Default params
            sort: self.hdnSort,
            sortDir: self.hdnSortDir,
            page: self.hdnPage,
            pageSize: self.hdnPageSize,
            searchBox: '#search_text',
            btnSearch: '#btn_search',
            btnSearchClear: '#btn_clear',
			resize: false,

            // Web method params
            //reloadUrl: 'DotNet.aspx/GetTable', 
			reloadUrl: 'data/GetJSONFromMySQL.php?', 

            // Header params  
            headers: new Array(
                //new Array([DB_COLUMN_NAME], [HEADER_TEXT], [SORTABLE])
                new Array('CreateDate', "Date Entered at(UTC)", true),
                new Array('City', "City", true),
                new Array('State', "State", true),
                new Array('CarYear', "Vehicle Year", true),
                new Array('MakeName', "Make", true),
                new Array('ModelName', "Model", true),
                new Array('CashBonus', "Cash Bonus", true),
                new Array('LeaseEnd', "Lease End Date(Y-M-D)", true),
                new Array("Details")
            ),

            // Column params
            cols: new Array(
                //new Array([SEARCHED], [WRAPPED])
                new Array(false, false),
                new Array(true, false),
                new Array(false, false),
                new Array(false, false),
                new Array(true, false),
                new Array(true, false),
                new Array(false, false),
                'templateLeaseEnd',
                'templateAction'
            ),

            // Localization
            txt: {
                'SearchField': 'Enter a partial or a full first name',
                'Loading': 'Loading...',
                'NoData': 'There is no data.',
                'ItemsPerPage': 'Show {0} items per page.',
                'Paging': 'Page {0} of {1}',
                'UnknownErr': 'There was an unknown error. Please try again.',
                'EnterTxt': 'Please type in a part or all of the first name you want to search.',
				'RowsFound': '<b>{0}</b> found.'
            }
        });
    }
};

/* Data grid templates */
function templateAction(c, dr) {
	var link = String.format('<a href="/{0}-{1}-{2}">{3}</a>', dr[c['MakeName']].replace(" ", "-"), dr[c['ModelName']].replace(" ", "-"), dr[c['LeaseID']], 'View Details')
    return link;
}
function templateLeaseEnd(c, dr) {
	var le = (dr[c['LeaseEnd']]=='0000-00-00') ? 'N/A' : dr[c['LeaseEnd']];
    return le;
}
/* End data grid templates */