Leaderboard

Hi, As Cody suggested in my previous post about MySQL queries that might give you some insights about critical situations, now I'm making custom report to make it easy to use and export from Blesta admin interface. Output Preview (CSV data): Setup 1. Create a new custom report 2. Put the name you want to the report 3. Paste the following code in Query: SELECT DATE(invoices.date_closed) Day, count(*) "Paid invoices", GROUP_CONCAT(invoices.id SEPARATOR ', ') "Invoices ID", SUM(invoices.paid) "Total Paid" from invoices where invoices.date_closed IS NOT NULL AND MONTH(invoices.date_closed) = MONTH(:chosen_date) AND YEAR(invoices.date_closed) = YEAR(:chosen_date) AND currency = ":currency" GROUP BY DAY(invoices.date_closed); 4. Add the following fields: --- Label: Month Name: chosen_date Type: Date Required: Yes --- Label: Currency Name: currency Type: Text Required: Yes --- 5. Click on Save and now it's ready to be used You can also put the currency field as a Select field with the currency codes you use instead of having to write "USD" (or whatever you use) every time. I'm using this query to get the invoices ID to look and generate e-invoices with a 3rd party API, which is required in my country.

This days i way discovering how the order forms / cart work . and i have discovered (at least for me and my staff and my clients testers) a big problem in the cart system . so if we have 3 order forms let say 1 for vps 2 for dedicated 3 for hosting . the client has make a order of 1 vps, and has not completed the checkout ; then he ordered 1 dedicated and hosting , no checkout at here . when he decide to complete the order , here we have the problem , the cart is not containing the 3 order services . and to complete the order he need to go to order form link and make checkout for every service . that for us/him is a huge and buggy work . so we decided to make our own call to the cart basket to see what are in it . and we have surprised , what blesta do is storing the cart item in the sessions, and every item with their ids and some more data . at here all thing is fine . but the surprise for us was that blesta disting with every order form cart . what we suggest is that the cart/basket should be for all order forms . the solution for us was use 1 order form for all . but we prefer use some list or ajaxed order form for a specific needs, and use styled order form for other services . at the end , for me, it has no sense to have 3 carts sessions in one system for the same place !!!! either the other ecommerce platform use 1 cart like magento/open cart/prestashop ..ect ... i don't want to nominate competitors ... licencecart , Relax is just a discussion .

yes , that what we are looking . i hope we can get it nearly .

Client area will have a dropdown box in CORE-1320 and a staff area improvement to allow staff to set a language for themselves in CORE-1750 if that helps.

Report Bug in license manager It appears license manager doesn't return status back when key is suspended or other status then "active" and therefore that makes it very hard for the client side system to determine the status and therefore returns the status of "unknown" when that isn't correct especially when the key is suspended or not in active status I ask please fix this and get the license manager plugin to return the correct license status instead of just "unknown" like that helps either the user or me the developer. as to be honest if it doesn't return the correct status what good is the switch statement that goes through and determines which status it is like suspended as the only two statuses that actually work and are useful currently are status:valid and status:unknown please fix this as it appears to be a issue with the license plugin not returning any data with the status when that is the case which leads the clientside to instead return status of "unknown" instead of its real status. as to be honest right now with that bug it makes me want to instead go back to whmcs licensing addon that actually does return the status regardless of if it is suspended or not and actually can be useful to say in the script "sorry license suspended please contact support" instead of "unknown" <--- do I really want that when I can see multiple tickets already for that and me pulling my hair out over it figuratively. as to be honest I like blesta I really do but you got to make the license manager actually work like it is supposed to otherwise I would rather move back to whmcs & their licensing addon and avoid trying to pull my hair out any longer figuratively for something that doesn't work like it should.

It's a third party based on the portal made by Blesta, it has a Blog feature and allows you to make custom pages and your own custom menu, we've got a lot to add but it does the main things we need. 1.2.0 will allow the menu items to be re-sorted, and multi-language. But we need to hire Mujahed full time before we can do that and we need a bit more income to cover the full time wage for our own developer. More information in my signature. Glad you like it mate.

Now you're assuming every host has a backup service... you'll find 70% of hosts don't have it.

These can also be added to Blesta as Custom Reports, which is super cool, and would even allow you to customize them across dates or status values, etc.

Thanks for the mention mate. I do agree with this but more of a universal cart so you can order more than one product type in the cart. Hosting package - $3 VPS package - $10 ---------------------------- Total: - $13