I have a quick question. Well two actually. 1, I have noticed that in the program for phone numbers for client.phone_cc it will not allow you to use dashes ex. 111-111-1111 and have it save. It will just leave the first 111. The client.phone however will allow the dashes. I went to the database and saw that it was set for only (3) characters however when edited and changed to say (14) it would only save the 3 in the program. Is this an issue somewhere other than the database structure? I tried to add a new database under clients in the structure and I can create the new column in the database itself however if i try to pull from it into the program it does not pull anything. For ex. lets say I add a new column in client called dog. The database info for that column in the program i was assume would be client.dog? But when trying to pull information from that column from the database nothing shows. Am I missing something as to why it is not calling from a new column? Its weird, because like I said I cant pull from the new column and I cant even change the values of an existing column. Any help would be appreciated greatly. Keith T.

For the adding a new database column here the snips.. shows column added to client structure as numberfam 2. this is edited in the insert for the chosen client, shows it should say 3 in the program shows the codeing used to call from database in the mod_client_manage.html.twig file located in the file modules/Client/html_admin folder 4. This is what is shown in the program

Databases

Suckitup11

I have a quick question. Well two actually. 1, I have noticed that in the program for phone numbers for client.phone_cc it will not allow you to use dashes ex. 111-111-1111 and have it save. It will just leave the first 111. The client.phone however will allow the dashes.

I went to the database and saw that it was set for only (3) characters however when edited and changed to say (14) it would only save the 3 in the program. Is this an issue somewhere other than the database structure?

I tried to add a new database under clients in the structure and I can create the new column in the database itself however if i try to pull from it into the program it does not pull anything. For ex. lets say I add a new column in client called dog. The database info for that column in the program i was assume would be client.dog?

But when trying to pull information from that column from the database nothing shows. Am I missing something as to why it is not calling from a new column?

Its weird, because like I said I cant pull from the new column and I cant even change the values of an existing column.

Any help would be appreciated greatly.

Keith T.

BelleNottelling

The phone_cc column is intended to record the country code for that client's phone number, not an entire phone number.

And there shouldn't be any issues with adding in a new column and pulling that data, but without actually seeing how you are attempting to do we can't practically tell you why it isn't working for you.

Under the hood things are going through RedBeanPHP when interacting with the database and you can find all of the functions that are accessible under $di['db'] here:
https://github.com/FOSSBilling/FOSSBilling/blob/main/src/library/Box/Database.php

For the most part, these are direct aliases to RedBeanPHP's functions

Suckitup11

Belle, thank you for your reply. I understand the phone_cc is for the country code. I have changed a bit so it will be a home phone and the .phone as a cell phone. That is why i changed the values from 3 to 14 but still wouldnt work.

I will check out the link you provided. Thank you for your time and your reply.

Suckitup11

For the phone_cc here is a screen shot as to what I have done in the database. As you can see it is set to a value of 14 but yet in the program it will still only show the first 3 characters even though it is set to 14.

Suckitup11

For the adding a new database column here the snips..

shows column added to client structure as numberfam

2. this is edited in the insert for the chosen client, shows it should say 3 in the program

shows the codeing used to call from database in the mod_client_manage.html.twig file located in the file modules/Client/html_admin folder

4. This is what is shown in the program

BelleNottelling

Ah, I see.
You are trying to display the new column in on the front-end and not interact with it on the back-end.

You'll need to update the toApiArray function in the client module to also return the new column as the back-end doesn't make all of the columns available to the database from the get-go.

Also, I'd generally be hesitant to modify default tables in FOSSBilling, especially by changing what you are trying to use already existing columns for & redefining it's structure. Although it's unlikely to get changed at any point in the future, if we push an update that modifies that column / table it may break what you've done.

And in a similar point, I'd generally avoid modifying the source files in FOSSBilling as those changes will be overridden when you update. For front-end work you can use a custom theme and that'll avoid that issue, but for other items the best route to go would be to create custom modules so that you aren't creating modifications that will be reverted after each update

Suckitup11

BelleNottelling

Thank you again for your reply.

Suckitup11

I do have a question if I may. I don't see any coding anywhere that would total up just the unpaid invoices per client. Am I looking over this or is this not coded? Would like to be able to see at a glance what the total of unpaid invoices would be per client as in the invoice tab it does show all the invoices for that client just not the total of all of them?

BelleNottelling

There isn't an API endpoint that returns the count, but you should be able to use the length function that's built into twig.

{% set unpaid = admin.invoice_get_list({ 'per_page': '100', 'client_id': client.id, 'status': 'unpaid' })|length %}
{% set paid = admin.invoice_get_list({ 'per_page': '100', 'client_id': client.id, 'status': 'paid' })|length %}

Suckitup11

BelleNottelling

That is kinda what I have already to show just the unpaids on the profile page.

                    {% set invoices = admin.invoice_get_list({ "status":"unpaid", 'per_page': '100', 'client_id': client.id }) %}
                    {% for invoice in invoices.list %}
                    <tr>
                        <td align="right">
                    <a href="{{ '/invoice/manage'|alink }}/{{ invoice.id }}">{{ invoice.serie_nr }}</a>
                        </td>
                        <td>{{ mf.currency_format( invoice.total, invoice.currency) }}</td>
                        <td>{{ invoice.created_at|format_date }}</td>                            
                        <td> 

                     {% if invoice.status == 'unpaid' %}
                     <span class="badge bg-danger me-1"></span>
                     {% endif %}
                     {{ mf.status_name(invoice.status) }}
                       </td>
                       <td>
                     <a class="btn btn-icon" href="{{ '/invoice/manage'|alink }}/{{ invoice.id }}">
                     <svg class="icon">
                     <use xlink:href="#edit" />
                     </svg>
                     </a>
                       </td>
                       </tr>
                    {% else %}
                       <tr>
                       <td colspan="6">{{ 'The list is empty'|trans }}</td>
                       </tr>
                    {% endfor %}
                       </td>
                       </tr>

What im looking for is something like this. Right under the invoices im looking for something that will total up all the unpaids so it would say 100 where the red 30 is

BelleNottelling

Hi there, since you already have the list of unpaid invoices and are already looping through them, you can simple add up the amounts using some very basic twig code.

https://twig.symfony.com/doc/3.x/templates.html#math

Suckitup11

I need to do more research.. I do have it calling the unpaid invoices only looping but no clue how to make the invoice.total for each to be added together. Not sure of the correct coding.. Ill look around more see what I can figure out.

Suckitup11

Got it thank you for your help. Was a little more than just the twig math but got it all figured out. Thank you again.

BelleNottelling

Happy you were able to figure it out!