Collaborate on Software Development Invoice Example for it with Ease Using airSlate SignNow

Software development invoice example for IT

hello explorers and welcome to another video today we are going back to the early beginnings of this channel i think it was around the 10th or 9th video that i did where i did a little bit of a series and i was creating something that was really basic how to write java code by example so java by example and in this series i created an invoice pdf from some raw data i used some json data and i created an invoice and i have got a question for this really old video this is back in 2016. and this video um question was can you help us do this but with an xsl so within excel doc read that data in and use that in the pdf creation what i wanted to do was create an excel sheet sheet and i've done that with some data and the data is in a couple of columns and some different cheats as well so we can look into that first let's jump over here so first off we have some invoice information this is involved date invoice number same as billing if their shipping address should be the same as the bill address some notes some shipping number and so on and then we have the bill 2 which i will handle as well so this is the billing address and shipping address with a couple of fields here and then we have some row data and this is the data of the actual the actual uh invoice so the different rows in the invoice and i'm gonna go through and make something here i'm gonna create the the actual code to read this in and use it so if we switch over to the code editor here you see that i have a little bit of a code in the beginning here that actually does the reading but beforehand i have this json document i read in a few and we can look at a few um that's a very short here we have the same kind of information we had some build to we had some ship to information shipping data nodes and the invoice rows so it's very similar to what we are doing now but we are doing it with an excel sheet instead so let's switch over here and the first piece of code here is actually to parse the xsl and if we switch over to here these are the lines that you need in order to read an excel sheet and i'm using tikka by the apache foundation so i needed to add tikka here the ticket parses and the ticket core so those two dependencies i needed to add to my pom file here and if we switch back to the the code here again i could read a file i create some basic content handle factory for x i will handle it as an xml document and i read it in i do some auto detect parser that will detect data in here and i have a content handler i have metadata and i have parse content so i create a lot of different contexts and things up here to the con context i put in the parser and i create an input stream and then i give the parser all these different um things that it can use while it's parsing this document and then the handler will have a string that we can fetch from it and this will give us a string data of html so if we go back to the code here again we got this xsl html document and i use jsoop to parse this document and we can actually start by looking into the document here so we do an xsl html and print that out if we do that we can see how this html document is structured and we can go from there so let's see here and it takes a while for the code to compile here and when it runs we will have some document here so if we look at this we see that we have some html header here that we don't really care about and then we have in the body divs which has tables with the data so we have one div here with the invoice header we have another div with the bill 2 address and the last div with the row data so let's do those divs handle those so with this parser here the jsoop i can parse the document and then get elements by tag and get all divs and i can print those out so that's the next step that i want to do in order to handle this little document here let's see if we can get that and then i will get each div in turn and they will print those out and i will do as i did before with the invoice i created something that took an invoice and then printed the document using the invoice data and so i want to handle this the same way and use the different classes that i have so i want to take this invoice data and give it a document so that's what i want to implement now let's go into the invoice data here and let's see no that's not what i wanted to do here so let's go back so here i want create a constructor a new constructor that takes document so that's what i want to do so let's create this again create constructor dock get elements by tag let's do div again and element gives so this is the divs that i have here like that and now i want to do the same thing that this does up here but i wanted to handle the different things so i will create an address and and header so let's see again what we had what kind of divs that we had [Music] and print that out so let's see here we want the invoice header we want to build two and i guess that we already have those right um so we have the invoice header which contains a lot of information here so when we have this one get elements by tag h1 and then get the first index there and print that out so let's see here and then we get those headers here and if the first div header here if this is equal to invoice header i will take this header and create a new header with that element so that's what i want to do there then i want to do the same with build 2 and row data and in the build 2 i want to create an address and the row data and we also need to handle a case here this ship to is equal to this so there we need to figure out how to handle that and and i also think that this ship data i think that is in the header here as well like that and see here ship data has its own little thing and down here we want the rows how did i handle rows here rows are invoice rows [Music] so that's handled like that i did did some some handling here that's something that i need to do later on because i don't really have that at the moment and we also need to handle notes and i don't really remember where the notes are placed is that in the header as well yeah so i have the notes in the header as well so you have a lot of information in the header and we also have the bill 2 there same as billing so there is a lot in the header that we need to handle this notes is a string let's just give it an empty string at the moment and then we will handle that later so now we need to figure out how to we need to create constructors for these as well so here i want to read all the uh rows and handle them together with the data in order to create some kind of uh um input like that um so let's see if we can figure that one out we want to have some header information we want to put that into um as a header so here i get all the element tags by id and then do tr and and here we only have the invoice date and the invoice number so um we can have something that takes input inside of this and creates json from it instead that could be a simplified case for us perhaps because we already have handling of json so let's create a private json object from element to json and then elements here and then we create a new json object data new laser object and return that data and we don't know that the first row in this case if we do get elements by tag tr so the first row is the names so elements playable rows we know that the first row here should be all the headers and the second row should be all the data like that get elements by tag tr td um these elements are the headings [Applause] let's see how many there are size perhaps or n pi equals to zero less than size and let's add to that and let's see here what we can do headings get i and then we need to have the data as well datus and here we want to take the data and [Applause] oh it's because this json object we need to give them different names please object put heading and datas get the same there let's see what that gives us if we have it here get element a sound crease on object header and take this header and print that out what does that give us fatal error or actual header information let's see here we have some issues there let's comment that out at the moment see if we can we need to comment that out as well let's see let's see here we go and we get a lot of data and then a null pointer exception um so that didn't give us anything are we still printing the xml xsl here you do so let's do some checks here see what happens we end up there so we do didn't let's see here add a variable that's an element of course it is text there we have it we need to get the text of course of that in order to get the actual data and i'm pretty sure we need to do the same here so let's see if we can get something different here that we actually get a header in some json format [Music] yeah so we have some json format here and then we should be able to create both the header and the shipping data from this format right yeah and we should be able to take this and get the key notes here as well and then create a string from that like that and up here we can take the bill 2 and call it an address [Applause] put that in there should solve that problem and i think that we need to have a boolean here same as bill false so we can set this here equal to header get the same as bill i'll start the name same as billing equals to true if that's true we should do that and we can do that after this loop we don't need to do that in the loop what happens if we run that do we still have a null pointer exception somewhere or do we get a document we don't have a null pointer exception anymore which is a bit interesting and so let's look here this is the actual output that we get we have some nulls here which i didn't really expect but we have created a document from whatever we had before and most of the data actually sent through so uh what is in the address that we get as nulls um [Music] it's the full name right so we can we don't handle the name correctly and that's because the name is within another context here so we have the name that is in a name object so if we go back here and look at the bill to i have put the title first and last inside of the same row so i need to create a name object and put those in there just to have it the same as here so let's go back to the invoice again and then i can take this address that i get here and create another json object and i can call name new json object and then we take the address get a title and we take name put title inside of it we do the same for first and last last quick and dirty and then we take address and put name this name variable here but do that we should have fixed the address part taking something from an excel document reading it in and changing the information over in order to handle our invoice format so now we have the chip to and build to address correctly in this document the last part is to handle the row data and this is a little bit more tricky because now we need to handle the option where we have multiple rows with the same data so let's do this and get elements to json multiple because we know that we need that and in that case we need to have a json array that will handle um new json array and that will be what we want to return here so we take the table rows that the that is the first part and we have the header and then we need to have the table rows size we need to do a for loop 8i [Applause] 1 to i this size and iterate continue to iterate here we create a new json object we will have this headings thing here that will take this first here but we also need to have the actual row of the datas here so we put that in we will change these over i wonder which i think it's easier to change the outermost one because that's fewer like that so now we will read the headings every time don't need to do that the headings can be read outside so we'll create read the table data rows a little bit simpler so we have all the data's here we will go through those we will go through the headings and we will create json objects and these json objects we will put into our json array and the json object [Applause] we did that we can then down here take this element here and put that into this and uh this should be some array data rows like that and this rows is equal to [Applause] add invoice row new invoice row so let's do a for loop here is an object from the data rows and put those in there which means that we can simplify this a bit we create a list instead of json object rows new arraylist and we will return that because then we don't need to handle that the json array contains only objects and need to cast a lot of things so if we do like that we can have a list with the defined object inside of it return that loop over the defined object here down here um list okay some object and then create new invoice rows from that let's see if this works perhaps we have created something that can read an xml document and create an invoice with that data so let's switch over here and reload and we have this and it also handles the subtotals and so on um so that's how you can take something in an excel document and reuse the old code you had in order to get some data from the excel document into and pdf now this is a series that i did a long time ago so this code is not perfect and what we wrote today was just a proof of concept you need to do a lot of work in order to make this a product that you can actually use but still we have looked into how to do this how how can we make this and how how can this be be done within the same framework uh pretty easily in um i will commit this into the github repository so if you want to look at this and want to do your own thing that reads excel documents and perhaps put in some extra error checking and make this more of a product that you can use in your day-to-day work that's fine by me this is a way for me to show how these things can be built in order to streamline any process flow or in order for you to learn more about java i hope you found this interesting i hope that you like this video give it a like share it with your friends and colleagues if you have built similar systems or things in your day-to-day work leave a comment down below and say what you have created that simplifies your workflow um and if you haven't subscribed yet please do that and i really hope to see you in the next [Music] [Music] video [Music] you