Forum Replies Created
-
Posts
-
It has been a while since I coded an extension. So this was a great refresher course. Download the attached zip file and extract it into the
extensionsdirectory. Then in SI, select the Settings tab and the Customize Settings menu option. Next select the Extensions button.This will display a list of extensions among which the new customerList name will appear. In the Actions column select the green Register icon. This will bring up the About to register: customerList screen. All you do here is select the Save button.
Note the new Toggle status icon in the Actions column. Note also that the light bulb in the Status column is grey. Click on the Toggle status icon and the light bulb will be yellow. This means the extension is enabled.
Now when you go to the Customer page, the phone number will be displayed in what was the department column. Note that this logic will prefer the mobile phone for the customer over the phone number if both set. If only one is set, that number will be displayed.
You can use the search field to search for a particular phone number.
Let me know host this works out.
OK. Found the problem. The setting is correct but what shows on the manage screen is not correct. I just uploaded a fix for this. Update files and you should be good to go.
Yes, that is what the extensions directory is for. It’s been awhile since I’ve created an extension. Basically your folder name is the name of the extension and you create files in directory paths within it that are used instead of the standard file. For class files in the Inc/Claz folder, there is a trick to only add the class code that is specific for your need so you don’t have to copy the entire class and thereby put general maintenance of all the class code on you. Otherwise, you might miss some needed changes that future updates provide.
Maybe if you can explain what you want to do, I can see what it takes to set it up.
You would have to create an extension with logic to do this.
Currently users with a biller role are restricted to accessing things that are related to that biller. So the biller record and the invoices for that biller. Products are universal, not related to any biller, so they can only be modified by and administrator.
Glad that worked for you. Sounds like an upgrade issue that you were able to resolve. From this point forward, you can maintain this information via the Inv Prefs screen.
So you are saying the on the new invoice screen that no matter what you select in the Invoice Preference field, the invoice shows Quote in the preference column? Please get a screen shot of the si_invoices database table showing the setting in the preference_id field, and a screen shot of the content of the si_preferences table.
The processing time is likely the time to transfer the data from the server. Data for all invoices is transferred in a minimized json file in the
public/data.jsonfile. The client (your browser) is set to display data after rendering the 15 rows on the first screen (this is the deferRender option in the Datatables module). Bottom line, the current logic is as efficient as per my understanding, as it can be.If you have additional thoughts, please let me know.
The error is objecting to the Currency code that you have set in the si_preferences file. You can look in the database si_preferences table and near the end of each record, see what you have in the currency_code field. They should all be alpha values and each 3-characters long. This link, IBAN Currency Codes shows the list of valid codes for each country. Make sure all the currency_code values in the si_preferences table have valid alpha codes from this table.
The error you are getting is:
[14-Apr-2021 14:02:04 Europe/Paris] SqlPatchManager::runSqlPatch() - PdoDb - query(): Execute error. See error_log. [16-Apr-2021 17:05:34 Europe/Paris] PdoDb - debugger(): ALTER TABLE <code>si_invoices</code> ADD UNIQUE INDEX <code>UniqDIB</code> (<code>index_id</code>, <code>preference_id</code>, <code>biller_id</code>, <code>domain_id</code>), ADD INDEX <code>IdxDI</code> (<code>index_id</code>, <code>preference_id</code>, <code>domain_id</code>); [16-Apr-2021 17:05:34 Europe/Paris] PdoDb - query(): Execute error.Array ( [0] => 42000 [1] => 1067 [2] => Invalid default value for 'date' )If you look at the si_invoices structure, you should see that the date column is set to NULL = NO and Default of 0000-00-00 00:00:00. You need to make sure that zero dates are allowed in your database. Do this by commenting out the “sql_mode=” in the my.ini file.
For reference, make the current setting for this value into a comment by adding a # at the front of the line. An example of what this line might be set to is, sql_mode=NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION.
After you make this change, restart your mysql server and access SI again.
Check the content of your si_index table. There is probably only one record in it but could be more. Make sure each record contains a numeric 0 in the sub_node_2 column. It is probably blank but should be 0.
Not sure what you mean by the “second” feature request. If you mean to have it all displayed on one line with description first, I’m less inclined to do that as it impacts the space available for people the have multiple taxes. The line currently handles up to three taxes per item. Also, I don’t see the benefit of such a change given the complexity of template changes to maintain it.
Recent Comments