Finished the functions with a query that will update the blue yonder when there are updates made in the web application.
Created the delete function for blue yonder, this function will not delete the data from blue yonder directly but only update the action field into D, meaning the blue yonder will delete the location with a D action.
Tested the add and edit location again in the web application as there are added fields in MySQL database and in the add and edit query in the web application, the action, process tag, date created and time created.
As per checking of adding, an error is encountered, check the cause of the error, as per checking, the cause of the error is the data created value, the set data type is int(6), the value to be inserted should be 211014 but as per checking of the data using dd(), it is inserting 20211014, it is too long for the set length for the field, modified the date format to change the value passed into parameter and save into MySQL, tested the adding of location again, as per testing, it is now OK.
Tested the editing of the location to check if no error will be encountered when the data is edited, as per checking, there are no errors encountered, but the data for store type and costing method is not selected based on the added data, modified the condition in the editing blade to select the data of what is saved, test the modified web application, as per checking, it is now selected the data.
Added update query in add function for updating the process tag from null into Y, it is placed after the saving of data to blue yonder.
Tested the adding of location, this time the saving of data in blue yonder is not commented thus it will execute, as per testing, an error is encountered, some fields are not accepting NULL value but this fields is not required, meaning I shouldn't encounter this error, reported this to blue yonder team.
Tested the web application again this time inputted and selected data for all the input and dropdown f