Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var dateCriteriaChange = function (startDate, endDate) {
- var dataManager = ej.DataManager({ url: "/LoanApplicationQuery/List", adaptor: new ej.UrlAdaptor() });
- var rangeQuery = ej.Query()
- .where("ProviderId", ej.FilterOperators.equal, 62)
- .where("FundingDate", ej.FilterOperators.greaterThanOrEqual, startDate)
- .where("FundingDate", ej.FilterOperators.lessThan, endDate);
- $("#grid").ejGrid({
- dataSource: dataManager,
- query: rangeQuery,
- allowResizing: true,
- allowPaging: true,
- allowSorting: true,
- allowReordering: true,
- allowSelection: false,
- enablePersistence: false,
- allowTextWrap: true,
- pageSettings: { pageSize: 10, pageCount: 10 },
- sortSettings: { sortedColumns: [{ field: "FundingDate", direction: "descending" }] },
- toolbarSettings: { showToolbar: true, toolbarItems: [ej.Grid.ToolBarItems.ExcelExport] },
- columns: [
- { field: "LoanTransactionNumber", type: "string", headerText: "Loan Number" },
- { field: "FundingDate", type: "date", format: "{0:MM/dd/yyyy}", headerText: "Funding Date" },
- { field: "Office", type: "string", headerText: "Location" },
- { field: "FirstName", type: "string", headerText: "First Name" },
- { field: "LastName", type: "string", headerText: "Last Name" },
- { field: "SaleAmount", type: "number", format: "{0:c}", headerText: "Amount Financed", textAlign: "right" },
- { field: "MDF", type: "number", format: "{0:p}", headerText: "Discount Rate", textAlign: "right" },
- { field: "DiscountFee", type: "number", format: "{0:c}", headerText: "Discount Amount", textAlign: "right" },
- { field: "NetFunded", type: "number", format: "{0:c}", headerText: "Net Funded Amount", textAlign: "right" }
- ],
- toolbarClick: function (e) {
- this.exportGrid = this["export"];
- if (e.itemName == "Excel Export") {
- this.exportGrid('/LoanApplicationQuery/Export')
- e.cancel = true;
- }
- }
- });
- };
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement