292 lines
10 KiB
JavaScript
292 lines
10 KiB
JavaScript
/**
|
|
* Created by Pensare Software.
|
|
* User: Theo Weijmer
|
|
* Date: 02/03/2018
|
|
* Time: 11:43
|
|
*/
|
|
|
|
dbo.invoicereportInit = function () {
|
|
|
|
if (dbo.invoicereport !== undefined) {
|
|
|
|
dbo.invoicereport.initModule()
|
|
|
|
} else {
|
|
dbo.invoicereport = {
|
|
|
|
years : ko.observableArray([]),
|
|
selectedYear : ko.observable(),
|
|
invoiceOverview : ko.observableArray([]),
|
|
forecasts : ko.observableArray([]),
|
|
monthForecasts : ko.observableArray([]),
|
|
monthPayments : ko.observableArray([]),
|
|
months : ko.observableArray([]),
|
|
monthTotals : ko.observableArray([]),
|
|
monthPaymentTotals : ko.observableArray([]),
|
|
validYear : ko.observable(),
|
|
invoiceTab : ko.observable(),
|
|
totalToInvoicingExcl : ko.observable(),
|
|
totalToInvoicingIncl : ko.observable(),
|
|
totalInvoicedOtherYears: ko.observable(),
|
|
totalInvoicedThisYear : ko.observable(),
|
|
totalPayment : ko.observable(),
|
|
totalToPay : ko.observable(),
|
|
invoicesTotal : ko.observable(),
|
|
needInvoice : ko.observable(),
|
|
forecastThisYear : ko.observable(),
|
|
forecastOtherYears : ko.observable(),
|
|
forecastRemaining : ko.observable(),
|
|
totalProjectPayments : ko.observable(),
|
|
orderType : 'projectnumber',
|
|
orderDirection : false,
|
|
archive : ko.observable(false),
|
|
recievedInvoices : ko.observableArray([]),
|
|
invoiced : ko.observableArray([]),
|
|
totalInvoiced : ko.observable(),
|
|
totalVat : ko.observable(),
|
|
totalInclVat : ko.observable(),
|
|
|
|
init: function () {
|
|
var vm = dbo.invoicereport
|
|
|
|
vm.selectedYear((new Date()).getFullYear())
|
|
vm.invoiceTab('invoice')
|
|
vm.validYear(true)
|
|
vm.months(dbo.monthArray)
|
|
|
|
vm.initModule()
|
|
},
|
|
|
|
initModule: function () {
|
|
var vm = dbo.invoicereport
|
|
|
|
vm.resetTotals()
|
|
|
|
var orderDirection = vm.orderDirection ? 'ASC' : 'DESC'
|
|
var archive = vm.archive() ? 'T' : 'F'
|
|
|
|
dbo.invoiceDataService.getInvoiceOverview(vm.selectedYear(), vm.orderType, orderDirection, archive, function (data) {
|
|
vm.invoiceOverview(data.invoiceOverview)
|
|
vm.setInvoiceOverviewTotals(data.invoiceOverview)
|
|
|
|
vm.forecasts(data.forecasts)
|
|
vm.setForecastsTotals(data.forecasts)
|
|
|
|
vm.monthForecasts.removeAll()
|
|
_.each(data.monthForecasts, function (p) {
|
|
vm.monthForecasts.push(new vm.Monthforecast(p))
|
|
})
|
|
_.each(vm.monthTotals(), function (p) {
|
|
p.forecastamount(dbo.helpers.thousandSeparator(p.forecastamount()))
|
|
})
|
|
|
|
vm.monthPayments.removeAll()
|
|
_.each(data.monthPayments, function (p) {
|
|
vm.monthPayments.push(new vm.Monthpayment(p))
|
|
vm.totalProjectPayments(Number(vm.totalProjectPayments()) + Number(p.totalProjectPayments.replace('.', '')))
|
|
})
|
|
vm.totalProjectPayments(dbo.helpers.thousandSeparator(vm.totalProjectPayments()))
|
|
_.each(vm.monthPaymentTotals(), function (p) {
|
|
p.paymentamount(dbo.helpers.thousandSeparator(p.paymentamount()))
|
|
})
|
|
|
|
vm.years(data.invoicedYears)
|
|
|
|
vm.invoiced.removeAll()
|
|
vm.totalInvoiced(0)
|
|
vm.totalVat(0)
|
|
vm.totalInclVat(0)
|
|
_.each(data.invoiced, function (p) {
|
|
vm.invoiced.push(new vm.Invoice(p))
|
|
})
|
|
vm.totalInvoiced(dbo.helpers.thousandSeparator(vm.totalInvoiced()))
|
|
vm.totalVat(dbo.helpers.thousandSeparator(vm.totalVat()))
|
|
vm.totalInclVat(dbo.helpers.thousandSeparator(vm.totalInclVat()))
|
|
})
|
|
},
|
|
|
|
toggleArchive: function () {
|
|
var vm = dbo.invoicereport
|
|
vm.archive(!vm.archive())
|
|
|
|
vm.initModule()
|
|
},
|
|
|
|
sortList: function (orderType) {
|
|
var vm = dbo.invoicereport
|
|
|
|
vm.orderType = orderType
|
|
vm.orderDirection = !vm.orderDirection
|
|
|
|
vm.initModule()
|
|
},
|
|
|
|
resetTotals: function () {
|
|
var vm = dbo.invoicereport
|
|
|
|
vm.totalToInvoicingExcl(0)
|
|
vm.totalToInvoicingIncl(0)
|
|
vm.totalInvoicedOtherYears(0)
|
|
vm.totalInvoicedThisYear(0)
|
|
vm.invoicesTotal(0)
|
|
vm.totalPayment(0)
|
|
vm.totalToPay(0)
|
|
vm.needInvoice(Number(0))
|
|
vm.forecastThisYear(0)
|
|
vm.forecastOtherYears(0)
|
|
vm.forecastRemaining(0)
|
|
vm.totalProjectPayments(0)
|
|
|
|
vm.monthTotals.removeAll()
|
|
vm.monthPaymentTotals.removeAll()
|
|
for (var i = 1; i <= 12; i++) {
|
|
vm.monthTotals.push({ monthID: i, forecastamount: ko.observable(0) })
|
|
vm.monthPaymentTotals.push({ monthID: i, paymentamount: ko.observable(0) })
|
|
}
|
|
},
|
|
|
|
setInvoiceOverviewTotals: function (data) {
|
|
var vm = dbo.invoicereport
|
|
|
|
_.each(data, function (p) {
|
|
vm.totalToInvoicingExcl(vm.totalToInvoicingExcl() + Number(p.totalToInvoicingExcl.replace('.', '')))
|
|
vm.totalToInvoicingIncl(vm.totalToInvoicingIncl() + Number(p.totalToInvoicingIncl.replace('.', '')))
|
|
vm.totalInvoicedOtherYears(vm.totalInvoicedOtherYears() + Number(p.totalInvoicedOtherYears.replace('.', '')))
|
|
vm.totalInvoicedThisYear(vm.totalInvoicedThisYear() + Number(p.totalInvoicedThisYear.replace('.', '')))
|
|
vm.invoicesTotal(vm.invoicesTotal() + Number(p.invoicesTotal.replace('.', '')))
|
|
vm.totalPayment(vm.totalPayment() + Number(p.projectPayment.replace('.', '')))
|
|
vm.totalToPay(vm.totalToPay() + Number(p.invoiceToPay.replace('.', '')))
|
|
vm.needInvoice(Number(vm.needInvoice()) + Number(p.needInvoice.replace('.', '')))
|
|
})
|
|
|
|
vm.totalToInvoicingExcl(dbo.helpers.thousandSeparator(vm.totalToInvoicingExcl()))
|
|
vm.totalToInvoicingIncl(dbo.helpers.thousandSeparator(vm.totalToInvoicingIncl()))
|
|
vm.totalInvoicedOtherYears(dbo.helpers.thousandSeparator(vm.totalInvoicedOtherYears()))
|
|
vm.totalInvoicedThisYear(dbo.helpers.thousandSeparator(vm.totalInvoicedThisYear()))
|
|
vm.invoicesTotal(dbo.helpers.thousandSeparator(vm.invoicesTotal()))
|
|
vm.totalPayment(dbo.helpers.thousandSeparator(vm.totalPayment()))
|
|
vm.totalToPay(dbo.helpers.thousandSeparator(vm.totalToPay()))
|
|
vm.needInvoice(dbo.helpers.thousandSeparator(vm.needInvoice()))
|
|
},
|
|
|
|
setForecastsTotals: function (data) {
|
|
var vm = dbo.invoicereport
|
|
|
|
_.each(data, function (p) {
|
|
vm.forecastThisYear(vm.forecastThisYear() + Number(p.forecastThisYear.replace('.', '')))
|
|
vm.forecastOtherYears(vm.forecastOtherYears() + Number(p.forecastOtherYears.replace('.', '')))
|
|
vm.forecastRemaining(vm.forecastRemaining() + Number(p.forecastRemaining.replace('.', '')))
|
|
})
|
|
vm.forecastThisYear(dbo.helpers.thousandSeparator(vm.forecastThisYear()))
|
|
vm.forecastOtherYears(dbo.helpers.thousandSeparator(vm.forecastOtherYears()))
|
|
vm.forecastRemaining(dbo.helpers.thousandSeparator(vm.forecastRemaining()))
|
|
},
|
|
|
|
setForecastMonthsTotals: function (data) {
|
|
console.log(data)
|
|
var vm = dbo.invoicereport
|
|
|
|
_.each(data, function (p) {
|
|
_.each(p.forecastMonths(), function (q) {
|
|
vm.forecastMonths(vm.forecastMonths() + q)
|
|
})
|
|
})
|
|
},
|
|
|
|
checkYear: function () {
|
|
var vm = dbo.invoicereport
|
|
if (!Number.isInteger(Number(vm.selectedYear()))) return vm.validYear(false)
|
|
if (Number(vm.selectedYear()) > 2100) return vm.validYear(false)
|
|
if (Number(vm.selectedYear()) < 2000) return vm.validYear(false)
|
|
vm.validYear(true)
|
|
|
|
vm.initModule()
|
|
},
|
|
|
|
setActivetab: function (page) {
|
|
var vm = dbo.invoicereport
|
|
|
|
vm.invoiceTab(page)
|
|
},
|
|
|
|
Monthforecast: function (data) {
|
|
var vm = dbo.invoicereport
|
|
var self = this
|
|
self.projectnumber = data.projectnumber
|
|
self.projectname = data.projectname
|
|
self.customer = data.customer
|
|
self.needInvoice = data.needInvoice
|
|
self.forecastOtherYears = data.forecastOtherYears
|
|
self.forecastRemaining = data.forecastRemaining
|
|
|
|
self.forecastMonths = ko.observableArray([])
|
|
_.each(data.forecastMonths, function (p, i) {
|
|
self.forecastMonths.push(new vm.ForecastMonth(p))
|
|
_.each(vm.monthTotals(), function (q) {
|
|
if (q.monthID == (i + 1)) q.forecastamount(Math.round(Number(q.forecastamount())) + Math.round(Number(p.forecastamount)))
|
|
})
|
|
})
|
|
},
|
|
|
|
ForecastMonth: function (data) {
|
|
this.forecastamount = dbo.helpers.thousandSeparator(Math.round(data.forecastamount))
|
|
},
|
|
|
|
Monthpayment: function (data) {
|
|
var vm = dbo.invoicereport
|
|
var self = this
|
|
self.projectnumber = data.projectnumber
|
|
self.projectname = data.projectname
|
|
self.customer = data.customer
|
|
self.totalProjectPayments = data.totalProjectPayments
|
|
|
|
self.paymentMonths = ko.observableArray([])
|
|
_.each(data.monthPayments, function (p, i) {
|
|
self.paymentMonths.push(new vm.PaymentMonth(p))
|
|
_.each(vm.monthPaymentTotals(), function (q) {
|
|
if (q.monthID == i) q.paymentamount(Math.round(Number(q.paymentamount())) + Math.round(Number(p.paymentamount)))
|
|
})
|
|
})
|
|
},
|
|
|
|
PaymentMonth: function (data) {
|
|
this.paymentamount = dbo.helpers.thousandSeparator(Math.round(data.paymentamount))
|
|
},
|
|
|
|
Invoice: function (data) {
|
|
var vm = dbo.invoicereport
|
|
var vat = Math.round((data.invoiceamount * 21) / 100)
|
|
var inclVat = vat + Number(data.invoiceamount)
|
|
this.invoiceamount = dbo.helpers.thousandSeparator(data.invoiceamount)
|
|
this.vat = dbo.helpers.thousandSeparator(vat)
|
|
this.inclVat = dbo.helpers.thousandSeparator(inclVat)
|
|
this.projectnumber = data.projectnumber
|
|
this.project = data.projectnumber + ' ' + data.projectname
|
|
this.invoicedate = data.invoicedate
|
|
this.name = data.name
|
|
this.invoicenumber = ko.observable(data.invoicenumber)
|
|
vm.totalInvoiced(Number(vm.totalInvoiced()) + Number(data.invoiceamount))
|
|
vm.totalVat(Number(vm.totalVat()) + Number(vat))
|
|
vm.totalInclVat(Number(vm.totalInclVat()) + Number(inclVat))
|
|
},
|
|
|
|
createSpreadsheet: function () {
|
|
var vm = dbo.invoicereport
|
|
|
|
var orderDirection = vm.orderDirection ? 'ASC' : 'DESC'
|
|
var archive = vm.archive() ? 'T' : 'F'
|
|
|
|
var url = 'index.php/reports/reportsController/createInvoicesSpreadsheet/' + vm.selectedYear() + '/' + vm.orderType + '/' + orderDirection + '/' + archive
|
|
window.open(url, '_blank')
|
|
}
|
|
}
|
|
|
|
dbo.invoicereport.init()
|
|
|
|
ko.applyBindings(
|
|
dbo.invoicereport, document.getElementById('INVOICEREPORT'))
|
|
|
|
}
|
|
|
|
}
|