Currently, I’m building an app (API) for employee management with Laravel! I will try and explain the process step by step so you can understand what I want much easier! When you create/register an Employee you have to assign how many hours will work during the week. Example: After the employee is created he can start writing the hours he
Tag: algorithm
Query Search Algorithm using priority array and ignoring conditions
I am facing this problem at my companies logistics: Given array of mixed values ordered by priority ASC (v1 is more important than v2, … etc) I need to search values in a table t like this: The 3 dots in query are the fixed conditions If I cant find any value from query, perform same query ignoring the least
Implementation of QueryCache
Aside from doing a direct match on something like a whitespace normalized hash of a query, what might be a useful (but-not-necessarily-perfect) way to handle query cache in a partial manner? For example, let’s take the following basic case: This potentially could be used as a ‘base-cache’ upon which a further query could be executed to potentially improve performance: So,
Get items that have less available quantity then needed
I have a list of order items and a list of inventory quantity per item I want to get the first of each item that I will not have enough inventory This is the list of order items OrderId Item …
parse string containing comma in csv using mysql? (or maybe pandas?)
（I’m using mysql v５.7） I have a csv file that has something like mytable1 note that ‘aaa,bbb,ccc’ is one string and ‘8,3,5’ is one string.. I know it’s not a good practice putting data like this but this is what I have given from other department… so my first task was to extract number matched with ccc. like this: mytable2 for
Grouping the rows by similarities
I am working on SQL server. I have the following table: For each BIGroup I have a multiple VarianceName. For each VarianceName I have multiple PartNumbers. I am comparing every partnumber with the …