Jump to content

vpshove

Member
  • Content Count

    22
  • Joined

  • Last visited

Community Reputation

1 Neutral

About vpshove

  • Rank
    Junior Member

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Yes that's right, its a third party gateway (Local country online merchant), they've developed one for WHMCS on 2017 as requested, which has not been updated could be the issue for this matter.
  2. Hello, currently we're using WHMCS 7.10.2 We've received a complaints for: - 2 Customers who has paid monthly recurring amount, but then getting suspended - This is because "next due date" not getting updated. (We've double-checked on payment portal, indeed the customer has paid) May I know what is the root cause behind this bug? Thanks!
  3. Guess what, you need to get your free coffee from me, I did double checking, but is done in phpmyadmin for the number of the total terminate services (based on next due date). It do make sense to me now (which I hardly get to know the reasoning) However (again), the number of terminate, are grouped in month and will be totalled (which is what we see now). I'll update this to another version, which can be seen in daily mode.
  4. Hi, this is the latest code that I'm using. Here's the result so far. This is when plus minus, for when only "Active" product vs "Terminate" products, I would ended up getting a large number of negative (Post Deduction). When I remove the active as filter for $products['active']['currentYear'], then the percentage of churn could be shown.
  5. Do you mind explain on the column for getting the number of termination? It was quite an interesting number figures from time to time after the updates from your output. Here I wanna share some research i've gotten recently from how some determine churn rate.
  6. On my end, using the latest code you've updated. I changed the following line (49) $products['active']['currentYear'] = Capsule::table('tblhosting')->whereYear('regdate', '=', $year)->where('domainstatus', 'Active')->whereNotIn('billingcycle', ['One Time', 'Completed', 'Free Account'])->groupBy($groupBy)->pluck(Capsule::raw('count(id) as total'), Capsule::raw('date_format(`regdate`, "%c") as month')); TO $products['active']['currentYear'] = Capsule::table('tblhosting')->whereYear('regdate', '=', $year)->whereNotIn('billingcycle', ['One Time', 'Completed', 'Free Account'])->groupBy($groupBy)->pluck(Capsule::raw('count(id) as total'), Capsule::raw('date_format(`regdate`, "%c") as month')); Without "->where('domainstatus', 'Active')". From here I was able to get the churn rate percentage already for all row. Reason for why i remove it, it is because we want to also know how many actual number of Service hosted (Even it is not active anymore). Then perform some kind of plus minus. Extra situation/use case we're trying to achieve: At the end of the day, say that the latest one is August 2020 in Churn_Rate Report, I should be able to tally the latest number of Products with the total Active Products/Services in WHMCS->Clients->Products/Services->Filter Status to Active. Hopefully this is clear
  7. Yes the number in my case was correct for the year when it was started, (2012), March up until August, but then there is no terminated value anymore after august 2012. This leads to only an increment of products without termination after august just like i mentioned above just to recap. I can only confirm the value for when it is started is correct until august. I am looking at the code too and tested on WHMCS.
  8. Update: I do notice that, the amount of product do not start with small number when this hosting company just started, where the report generated was showing a large number (thousands) of active product. For example, Started on March 2012 (8 years back where this hosting was started) has only few customer use our services maybe like less than hundreds but the report showing thousands of active services instead. Another case is that, in 2020, the reports surely will generate until this August. However, for the past year, it stops calculating churn on august as well
  9. You're really a gearhead. After taking a look and using this to view on my end. I would like to know for the total [At the end of the month] Such that as in the picture above, On January, 23 total at the end of the month On Feb, 24 at the end of the month, - There is no plus minus on Feb, since 1 new and 1 terminate, how does it being 24. Maybe there is a reason for it which I was left out. - The same goes for March as well however. Next one would be, - I think the active service for Jan, isn't supposed to be 1, or could be more (which has been terminated) - I'm guessing that this has filtered the actual number of active service on Jan. I am thinking of (actual number of service activated) should be representing it there? Instead of (Current status of the service) that particular month. Psst. Correct me if I am wrong. 😄
  10. Here is the case study which I hope may be clearer to picture it out.
  11. Following terminated on (respectively): Product A Feb Product B Feb Product C Mar But the queries record/count the terminated services on January itself (From the month where it began to Active), Supposedly, it should record/count the terminated services on respective month (For the month when it was terminated on)
  12. Seems good in which comes close to what i've did previously. However, it comes to a part where -> Product A was subscribed on January 2020, but was terminated on March 2020 do not count in. Which means, if it was terminated on March 2020, it should be counted in March 2020. This got my nerves impulse wrecking
  13. Has anyone able to get an insights for acknowledging their hosting churn rate? I have been appointed to fetch and output daily/month/yearly churn-rate for hosting services. I do take a look and queries WHMCS's database 'tblhosting', count number of services and count a services that has been terminated. But I am stuck to the fact that i have no idea joining same table. Basically, Services Churn Rate (daily/monthly/yearly) = Total of terminated services in (any daily/monthly/yearly) / Total of active services in (any daily/monthly/yearly) I hope this also become a feature to give more insights within WHMCS. I will easily get to know what action should be taken to retain active services.
  14. Hello, We are attempting to switch our long run php version 5.6 used for few years. recently opted to switch it to php 7.3. Current WHMCS version -> 7.10.1 We checked PHP Version Compatibility There are like 190+ of encoded files that is incompatible with 7.0, 7.1, 7.2, 7.3 Checked ioncube loader was on version 10.3.9 We tried to switch the php version, what happened next was error and blank page. Had to roll back to php 5.6. In what way & measure that we should take note to switch properly?
  15. I don't have much of saying, but it was due to port 3306 not enabled for public remote access. Have it turned on and now it is accessible.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated