Share My Creation Invoicer WebApp using BVAD3 - Generate PDF Invoices for your businesses [NOW FREE]

Mashiane

Expert
Licensed User
Longtime User
james_sgp said:
Hi, I`ve added a dropdown showing a list of items from an SQL table. When I select one how do I get it to update the text in the 'Description' filed under Add Line? I tried everything i can think of, but nothing happens.
Click to expand...

1. When a user clicks the edit button on the line items, a map of that item is passed to EditLineItem sub.

B4X: 
Private Sub dtLineItems_edit (LineItemM As Map)                'ignoredeadcode 
    EditLineItem(LineItemM) 
End Sub

This updates the state variable called "lineitem", meaning that anything that is linked to this state will be updated. Now

2. The description field is coded like this.

B4X: 
Dim description As VueElement = vuetify.AddTextField1(Me, licont.MatrixID(1, 1), "description", "lineitem.description", "Description", Null)

With a v-model of lineitem.description, so the description field will be updated with whatever is on the lineitem.get("description")

What you need to do in your case is fire a change event when an item changes. An example of this is here

B4X: 
Sub cboBusiness_change(item As String)
    ChangeBusiness(item)
End Sub

Your change item however should update the lineitem map with the new values, along the lines of what EditLineItem is doing.
 

james_sgp

Active Member
Licensed User
Longtime User
Thanks for the explanation, it does help with some overall understanding but not sure if it's useful for my workflow...

1. Click [New Invoice]
2. Select Company
3. Select Client
4. Select Product (if you want to)
5. Click [+] button on the right drawer, if nothing selected in 'cboproducts' skip steps 6 & 7
6. Put 'cboproducts' selected item text into the 'description' field of the right drawer
7. From products map, find product price; and place into 'price' field of the right drawer
8. From productsA map, find product item; and place into 'item' field of the right drawer

Hope my workflow makes sense, and I`m not being stupid?

James
 

Mashiane

Expert
Licensed User
Longtime User
I get you, from the look of this, your work flow is like a wizard approach. Actually I like it. I'm sure we can add it to the list if feature requests.

The second part is then on the drawer itself. Where one can change line items by selecting a product from the combo. Great stuff.

Thanks a lot. These are brilliant ideas.
 

Mashiane

Expert
Licensed User
Longtime User
medifor said:
Hello mashiane,
I'm trying the project you sent me, but it gives me this error.
Click to expand...
Hi, it seems you have not set up connections to your db correctly. In the first post there is a connection test exercise that you have to undertake, have you done that to see if that works first?

You can PM me if you experience further issues.
 
M

medifor

Member
Licensed User
Mashiane said:
Hi, it seems you have not set up connections to your db correctly. In the first post there is a connection test exercise that you have to undertake, have you done that to see if that works first?

You can PM me if you experience further issues.
Click to expand...
OK thanks;
i upgraded php to 7.4 in my laragon and now it works
 

microbox

Active Member
Licensed User
Longtime User
Mashiane said:
This is looking very good...

One can create an invoice for any company and any client based on already defined settings. For example, we have a prefix and a starting number for invoices.

View attachment 110371

Watch this space!!!!
Click to expand...
Good day Mashiane, I made my payment with Transaction ID: 3AN30117MV897690B.
Thank you so much for sharing your talent specially to newbie like me in B4J.
 

Mashiane

Expert
Licensed User
Longtime User
microbox said:
Good day Mashiane, I made my payment with Transaction ID: 3AN30117MV897690B.
Thank you so much for sharing your talent specially to newbie like me in B4J.
Click to expand...
Please note that if you join our Telegram Channel, you are eligible to receive our ICT Asset Manager Source code for free. The only thing we kindly request you to do is just test it.

ICT Asset Manager [FREE] Source Code

Ola Download IMPORTANT: Please run the MySQL Connection Tester Excercise First THIS IS A LEGACY PROJECT AND WORKS WITH BVAD3 VERSION 604 AVAILABLE IN THE DOWNLOAD Join our Telegram Channel here. Keep Track of your ICT Assets.. Sneek Peek... 1. As an ICT Manager of your company, who did...
www.b4x.com

You can join here: https://t.me/bananovuematerial
 

Mashiane

Expert
Licensed User
Longtime User
IMPORTANT BREAKING CHANGE

Please note that with BANanoVuetifyAD3 Version 5.73+ you need to add this line before vuetify.Serve.

This was an automated process before.

B4X: 
    vuetify.UseJsPDF

Add it before vuetify.Serve on pgIndex

Thank you

PS

You can download the latest library source code here: https://github.com/Mashiane/BANanoVuetifyAD3/tree/main/Library

Run the project (DO NOT COMPILE TO LIBRARY) to generate your own b4xlib.
 
M

medifor

Member
Licensed User
hello Mashiane,
hello, I bought the source, because every time I run the program the "reference invoice" always starts from "invoice start"?
 
You must log in or register to reply here.

Similar Threads

  • Article
B4J Tutorial [BANanoVuetifyAD3] Converting your DB to a WebApp using VFlexDialog + MySQL CRUD PHP (Abstract Designer)
Replies
5
Views
7K
Mashiane
  • Article
Share My Creation [BANanoVuetifyAD3] Package Manager
Replies
6
Views
3K
Mashiane
  • Question
B4J Question [B4XPages] jRDC2 + MySql CRUD + Login (HELP)
Replies
4
Views
944
juangtju
  • Article
Share My Creation Ultimate Invoice System B4J Web App : Source Code
2
Replies
38
Views
9K
sfsameer
  • Article
B4J Tutorial [BANano] MySQL CRUD with PHP - Part 1
Replies
14
Views
7K
Mashiane
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…