I have 3 tables: SALES Sale ID Provider Sell Count ID Client Provider Commission COMMISSION PAYMENTS Sales Range Provider Amount Payed COMMISSION AGENTS Client Agent Name Commission % I need to calculate the amount that corresponds to each Commission Agent only from commissions that were already paid. To do so […]
Yearly Archives: 2020
2145 posts
I want to block traffic that contain specific string "anypattern". I know that the right iptables rule for that is: iptables -m string --algo bm --string "anypattern" -j DROP The problem that the data could be split to many TCP sequences. And there is a risk that the string "anypattern" […]
I have a list of customers and lat/long coordinates (3 columns:c,u,v respectively) I want to create 5 columns to resolve as the closest 5 customers. So far I’m using min(sqrt(([lat1]-[lat_array])^2+([long1]-[long_array])^2)) To minimize the distance but I’m running into a problem where lat1 is a member of lat_array and likewise with […]
I am not sure if this is possible, but I have created a spreadsheet with numerous sheets upon it, with the first sheet acting as a landing page which draws information from the other sheets. My question is I want the landing page to display information drawn from one sheet […]
I have set up my VM with pci passthrough and now I am trying to set up cpupinning. How do I verify that it does in fact work? My config regarding cpu parameters: ... 4 ... lscpu -e CPU NODE SOCKET CORE L1d:L1i:L2:L3 ONLINE MAXMHZ MINMHZ 0 0 0 0 […]
NoSQL databases are rather popular among Node developers, with MongoDB (the “M” in the MEAN stack) leading the pack. When starting a new Node project, however, you shouldn’t just accept Mongo as the default choice. Rather, the type of database you choose should depend on your project’s requirements. If, for […]
Sitemaps are the most important part to boost your app’s SEO. Here, I’ll try to explain the easiest way to implement a dynamic sitemap in your Laravel app.