Jump to content

Chris van der Westhuizen

Members
  • Content count

    39
  • Joined

  • Last visited

  • Days Won

    3

Chris van der Westhuizen last won the day on July 2

Chris van der Westhuizen had the most liked content!

About Chris van der Westhuizen

  • Rank
    Advanced Member

Recent Profile Visitors

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

  1. Chris van der Westhuizen

    Adding Client Account Number to Invoice Customization Notes

    Thank you
  2. Chris van der Westhuizen

    Adding Client Account Number to Invoice Customization Notes

    Hi All. Under Invoice Customization in the Notes field our financial department would like to have the client's account number to appear in one of the sentences. I would have thought that {client_ID} would work, but cannot get documentation in this regards. Maybe I am just overlooking something in the documentation. Does the Notes box makes provision for tags?
  3. Chris van der Westhuizen

    Invoice Date and Due Date missing on invoices and views

    and or maybe give an example code next to the textbox
  4. Chris van der Westhuizen

    Blesta Have Option To Create Quote/estimates ?

    Hi All. I see the first post was in October 2013 in this regards with good suggestions from Paul and others. Since I am the new developer at our company and I need to be paid each month 🙂 , my boss is expecting of me to develop a quoting plugin that we can sell. The plugin must make provision for prospects (not only clients as for the existing plugin by Blesta Addons) and once quote gets accepted the prospect will become a client. see explanation in earlier post above. I assume I will have to manually edit the Blesta source code for adding a menu item? or can it be done all from the developed plugin?
  5. Chris van der Westhuizen

    Invoice Date and Due Date missing on invoices and views

    Hi All We managed to pull magician on ourselves in regards to the dates having them disappeared for a short time. There's the trick... someone in our department removed the Date Format and Date Time format under settings's Localization. After changing it back to Date Format: d M Y and Date Time Format: d M Y G:i:s we had the dates in the invoices and everywhere again 🙂
  6. Chris van der Westhuizen

    Blesta Have Option To Create Quote/estimates ?

    Thank you GosuHost and Blesta Addons. I really appreciate your replies. I did look at the quote plugin as possible solution from Blesta Addons. The problem is that we are doing a huge lot of quotes, but a few signups. We do not want to create those prospect as customers on our system. Only when they accept a quote then we want them on our system as customers. It would be great if you could amend your plugin to do so. Time is of essence as I explained I made the mistake. How long will it take, and what will it cost? Maybe for a learning curve I should write a plugin? because there is a huge load of stuff/functions we would like in Blesta that is not currently available as in FreeSide, and it is expected from our programming department, in this case me (.net, U2 Universe, Oracle and so on developer who has some PHP experience) to do the development. And I have more hope for me with Blesta and minPHP as with FreeSide and Perl 🙂
  7. Chris van der Westhuizen

    Blesta Have Option To Create Quote/estimates ?

    We did away with whmcs and are using Blesta, but now we have to create quotes on a separate system (because I did not pay attention). Our directors want us to move away from Blesta for the lack of features like this, and they showed me FreeSide. That is written in Perl, and currently have NO support or developers at all that comes back to us. I see they are hiring. Thus that will be the worse route to take now. And I have to fix this. 😞 What we need in Blesta is menu items called Prospects and Quotes with sub-menus to create/edit/delete or list prospects or quotes, and where a quote gets generated and emailed in either html or pdf. A quote should be generated for existing clients as well and not only prospects. Sales agent should also be assigned in the form. If a client/prospect accept a quite once clicked on quote accepted button, if prospect a client should be created and then the services from the quote added to the new or existing client and invoiced. I believe one will only need 3 extra tables namely prospects (based on contacts) and quotation and quotation_lines (based on invoice and invoice_lines table). How difficult would it be to develop this for Blesta? Can it be done as a plugin or module or does one have to modify the base source? My mother-tongue is unfortunately not PHP, but I am an eager/fast learner on foreign languages 🙂 ...and a perfectionist when it comes to coding and security. Any suggestions going forward from here?
  8. Chris van der Westhuizen

    [Merge Clients] - How It Should Work ;)

    Hi All, I hope the following can help you. What I do in the meantime is moving the services etc over to the new client and close the old client. In my case we don't need to move everything. The services are important for us to be on the new client. Thus I used the code below, although it is not a complete script moving everything you might want to move, it did it for us, and can maybe help others. I commented the update queries with -- for me not to run it by accident 🙂 . find below: --blesta move services from one client to another. (the values entered was for my testing) /*Step 01*/ use billing; set @var_id_value_from=1195; /*from client code, not id*/ set @var_id_value_to=1205; /*to client code, not id*/ set @var_id_from=0; SELECT `id` into @var_id_from FROM `clients` where `id_value` = @var_id_value_from limit 1; set @var_id_to=0; SELECT `id` into @var_id_to FROM `clients` where `id_value` = @var_id_value_to limit 1; select @var_id_value_from, @var_id_value_to, @var_id_from, @var_id_to; SELECT * FROM `clients` where `id` = @var_id_from; SELECT * FROM `clients` where `id` = @var_id_to; SELECT * FROM `services` where `client_id` = @var_id_from; SELECT * FROM `services` where `client_id` = @var_id_to; --update services set `client_id` = @var_id_to where client_id = @var_id_from; /*skip this only for testing*/ select * from service_fields where service_id in(324); /* no action needed */ select * from service_changes where service_id in(324); /* no action needed */ select * from service_options where service_id in(324); /* no action needed */ select * from log_services where service_id in(324); /* no action needed */ select * from package_pricing where pricing_id in(33); /* no action needed */ select * from packages where id in(26); /* no action needed */ select * from pricings where id in(33); /* no action needed */ /*Step 02*/ select * from client_packages where client_id = @var_id_from; /*change client_id from to */ --update client_packages set `client_id` = @var_id_to where client_id = @var_id_from; /* assuming that the clients's currency, and tax status is the same, and you want to move all services from one client to another then you can do the invoices and transactions as well */ /*Step 03*/ select * from support_tickets where client_id = @var_id_from; /* service_id in(324); *//*code = 9462313;*/ /* change client_id from old client id to new client id (not client_id_value) */ /* the support_tickets are linked to support_replies which are linked to contacts that are linked to the current client. if you want to move the support tickets related to the service_id, I will suggest moving the contact first to the new client. but the contact is linked to a lot of tables. For my purpose I deside to leave the support_tickets at the old client and just make the support_tickets.service_id = null */ --update support_tickets set client_id = @var_id_to where client_id = @var_id_from; /* should I or not, in regards to the comment above? */ select * from support_replies where ticket_id in(select ticket_id from support_tickets where service_id in(324)); /* no action needed if not moving the tickets with services to new client*/ /*Step 04*/ select * from service_invoices where service_id in(324); /* no action needed */ select * from invoices where client_id = @var_id_from; /* id in (37106,38781);*/ /* change client_id from old client id to new client id (not client_id_value) */ -- update invoices set client_id = @var_id_to where client_id = @var_id_from; select * from invoice_lines where invoice_id in(37106,38781); /* no action needed */ select * from invoices_recur where `client_id` = @var_id_from; /* change cleint_id fom old client to new client */ --update invoices_recur set client_id = @var_id_to where client_id = @var_id_from; /*Step 05*/ select * from transaction_applied where transaction_id in(select id from transactions where client_id = @var_id_from); /* no action needed */ select * from transactions where client_id = @var_id_from; /* change old client_id to new client_id. make transactions.account_id = null if account not account will not also be moved to new client, like in my case */ --update transactions set transactions.account_id = null, client_id = @var_id_to where client_id = @var_id_from; Then I closed the old duplicated client in Blesta. have fun! 🙂
  9. Chris van der Westhuizen

    adding pages to plugin with own module, view and controller and actions

    Thank you Tyson. I'll go with the docs option. thus will use admin/settings/company/plugins/manage/PLUGIN_ID/?action=refreshmappings or addmappings etc.
  10. Hi all. I am trying to add a page to the Feed reader plugin I called Mapping. The functionality of the current feed reader plugin default page and add url sub page is what I am trying to use with a custom table for mapping purposes with another application. I cannot seem to get the basics working. And that is to have a mappings controller, module and view, and language file, with a button on the main form next to the + icon for adding a new feed. I did work through the documentation but for a .net developer I am a little dumbstruck with the PHP. I do believe I have the potential to manage once I can get the above mentioned to work. I am a person whom is eager to help. Currently I am in need of help. 🙂 What I did so far: I use the debugger plugin for debugging. plugins/feed_reader/controllers/admin_manage_plugin.php I copied to admin_manage_plugin_mappings.php and change all naming to the appropriate mappings naming. e.g. the word feed to mapping etc. plugins/feed_reader/language/en_us/feed_reader_feeds.php I copied to feed_reader_mappings.php and change all the naming to the appropriate mappings naming. plugins/feed_reader/language/en_us/feed_reader_manage_plugin.php I copied to feed_reader_manage_plugin_mappings.php and change all the naming to the appropriate mappings naming plugins/feed_reader/models/feed_reader_feeds.php I copied to feed_reader_mappings.php and change all teh naming to appropriate mappings naming. plugins/feed_reader/views/default/admin_manage_plugin.pdt to admin_manage_plugin_mappings.pdt and change the naming inside accordingly. plugins/feed_reader/views/default/admin_manage_plugin_add.pdt to admin_manage_plugin_mappings_add.pdt and change the naming inside accordingly e.g. in the admin_manage_plugin_mappings.php file the "class AdminManagePlugin extends AppController" becomes "class AdminManagePluginMappings extends AppController" and "FeedReaderFeeds" becomes "FeedReaderMappings" etc. I am trying to manually change the url to maybe show something by changing in the browser the "http://localhost/blesta/index.php/admin/settings/company/plugins/manage/10/" to "http://localhost/blesta/index.php/admin/settings/company/plugins/manage/10/mappings/" or "http://localhost/blesta/index.php/admin/settings/company/plugins/manage/10/mappings/?action=add" and some other combinations. Maybe I don't understand how it work 🙂 I will change the the queries and so on, but will do so once I manage to at lease see the Mappings button and the content of the new mappings view. I unfortunately cannot find an appropriate example through all the other plugin sources. I am wondering what I am missing? accept for my brain at this stage hahahahahaha. Kind Regards Chris
  11. Chris van der Westhuizen

    [Plugin] The Debugger

    Thank you Blesta Addons. I've received you email, logged in, and found the link now. 🙂
  12. Chris van der Westhuizen

    [Plugin] The Debugger

    Hi Blesta Addons. I registered for the free stuff on your site but can still not download the debugger. I log on to https://blesta-addons.com/ Then click on store tab / store / Plugins / The debugger Tools , thus https://blesta-addons.com/plugin/store/main/item/16/ ...and that is that. There is no option to download it. I logged a ticket 16 days ago in this regards at blesta-addons with no anwer yet. thus in the meentime worked on the Blesta EER Diagram. How do I go about?
  13. Hi Blesta Addons. I registered for the free stuff on your site but can still not download the debugger.

    I log on to https://blesta-addons.com/
    Then click on store tab / store / Plugins / The debugger Tools , and that is that.  There is no option to download it.

    How do I go about?

  14. Chris van der Westhuizen

    database diagram

    Thank you Paul for the quick response. Okey. The semi-good news is, I sent the semi-final version by email to you. I have a few more questions there, and as soon as we can have that sorted then newbies on Blesta, like me, can advance fast 🙂
  15. Chris van der Westhuizen

    database diagram

    Hi Paul, files left the building 🙂 See your email box. I hope you will like my spiderweb compilation 🙂
×