monthly orders report not showing units sold and income

[twister]

Hi,

 

i have 2 billing, an old 5 version and latest  stable version. neither show monthly orders report correctly -> reports.php?report=monthly_orders 

neitehr the units sold are correct nor the the value, shows 0 $ value. 

[brian!]

looking at the report code (either v5 or v7), it's only going to return results for new active services/addons for the given month - with that condition applied, are the results you're seeing still wrong ?

[twister]

i don't have a first payment amount, so changed it to amount so the amount is fixed. 

next i need to have those who have only one existing invoice paid using the predefined interval, as opposed to reg date that is used now in report. 

[twister]

On 8/17/2020 at 4:22 PM, brian! said:

looking at the report code (either v5 or v7), it's only going to return results for new active services/addons for the given month - with that condition applied, are the results you're seeing still wrong ?

I have a variable $data with a select query where i extract datepaid, total and amount and i get 18 records.

now i need to extract total amount of total and amount from previous query . how can i have another variable like $data2 where i could include smth like this

 

$data2 = Capsule::table($data1) 
->select(
            [
                Capsule::raw('COUNT(tblhosting.id) as total'),
                Capsule::raw('SUM(tblhosting.amount) as amount'),
                Capsule::raw('COUNT(tblinvoices.datepaid) as oncepaid'),
                Capsule::raw('tblinvoices.datepaid')
            ]
        )
->first();