eXpenser | App for managing expenses

I'm still learning and enhancing my XSLT skills. But hope it's okay if i can see from experts regarding my requirement.

For every 3 records xml segment, a new record xml segment will be created position on top which will sum the amount of the 3 records. Then, a new record (PK50) segment will still be produced in excess or the remaining line items. Kindly see the sample data below. There are PK50 records created, where the last one contains the summation of the remaining 2 records.

PostingKey 50 indicates the new record created which contains the amount summation of every 3 records. The Account field will have a value "Summation" as well. Appreciate any inputs from your end. Thank you so much!

Source data:

Need some help getting out of the weeds. I have host a Laravel application that started with 4.2 forever ago, that I upgrade every couple years and hop versions. I am a .NET developer by day but continue to maintenance this application. Anyway...

I upgraded from Laravel 6.x to 8.x, and started using Docker. I deployed everything to my production environment and most things were working. I did some light testing and admittedly I don't have tests for everything but some random parts of code aren't actually saving records to the database. It's SUPER odd. I've been troubleshooting for a few days and this is where I've landed at this point:

1. Laravel 8
2. MariaDB
3. Laravel Sail hosting development environment
4. Tinker lets me created/updated/delete records without issue using Eloquent
5. Some things are saving in the production environment (this is using MySql)

You're probably wondering about the database difference, I am using a M1 Mac and there isn't M1 support for MySql Docker images yet. From my understanding, Mariadb is a drop-in replacement.

Here is the code I wrote tonight trying to simplify some of this really old spaghetti code I wrote like 6-7 years ago... it's not much better right now, but please go easy on me. Ultimately, it's just 4 arrays coming in from an Angular frontend that I'm iterating through and creating/updating records and then passing everything back to the browser.

What I can't figure out is that it all says it saves, it increments the PKs in the tables in the database and I get the fully formed models back with the newly assigned PKs... but it just doesn't save in the database. All of the failure is completely silent, I've found no logs, no issues while debugging with xdebug in vscode, no sql logs, the Eloquent model says it's successful whether it's create/update. Yes, nothing seems to be saving.

But I can take all of the exact same data and run it in tinker and it saves perfectly fine... I'm truly stumped on what I'm missing. And before 400 people respond about the $primaryKey property in my eloquent model class, I've most definitely already checked these a million times (or at least that's what it feels like right now).

I have expenses data. I need a model that includes the total expense amount, total paid expense amount, and expenses list. For this purpose, I wrote a function named createExpenseSummaryReport.

I'm sending a request to a backend THAT IS OFFLINE using axios

I am using Spring data JPA to persist an entity to an H2 database, the get/ post requests always return error "Not Found" with status 404, but the data that I send in post request is reaching the database and is saved!

what I tried: making sure that my controller and the main method are under the same package.

my application.properties:

I have a Spring Boot connected with Oracle Database application. The same version of the application works fine with MySQL, but when I try to do some requests to Oracle Database it throws error:

Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet] with root cause

"status":500,"error":"Internal Server Error","trace":"org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet\r\n\tat org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:281)\r\n\tat org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:255)\r\n\tat org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:528)\r\n\tat org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:61)\r\n\tat org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:242)\r\n\tat org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:154) at com.example.pawel.expense.controller.ExpenseController.createExpense(ExpenseController.java:67) ~[classes/:na] ECT...

So here is my controller method for this function:

I creating an expense tracker app, and I have the user's expense record stored in a table by date, title, amount, and an empty column for an 'x' button to delete that row's expense document. When the user clicks the 'x' button it deletes the document from firestore and removes its data from the row.

Occasionally, when the 'x' button is clicked the document is deleted from firestore but doesn't remove itself from the table unless the page is refreshed which is basically reading the expense documents over again since the document was deleted from firestore.

I’m brand new (4 days old!) at Mendix, and I’m trying to write a very basic expense application where expenses are entered, a receipt image (JPG) is uploaded for the expense, and they are then sent for approval/rejection via another data grid page. The Domain Model looks like this. Domain Model

The problem is, I’m trying to use an image viewer to view the expense’s associated image but no image appears. I’ve created a Microflow to get the image and display it in an ImageViewer. The Microflow looks like this: MicroFlow

(The middle box is just a message used for debug purposes) The properties for Retrieving the ExpenseReceiptsUpload row is as follows: Get Row Properties

When the user clicks the ‘View Receipt’ button, the view image panel appears, but no image is shown. Below are the properties for the ‘View Receipt’ button: View Receipt Button Properties Note that I am calling the correct GetImageMicroflow microflow.

The layout for the Image Viewer Object is as follows: Image Viewer Object

Why are the images not appearing? I assume it has something to do with the association between my Expenses entity and my ExpensesReceiptsUpload entity but I feel like I’ve tried everything I can think of but I cannot get it to work! Any words of wisdom would be greatly appreciated!!!

I am new to Kotlin and Android programming. And I need to get some help with my code. I am trying to perform a SUM query on a column in my room Database and it is giving me trouble so far. I tried to get the value to return as Double and the app would crash every time. The column, expenseAmount is a Double type column.

Here is what I have so far:

DAO: