New write-off method?

Question

MySQL

Good day to all. Now warehouse accounting for public catering works. The nomenclature has technical cards from ingredients or p / f, which can also have their own technical cards. Everything would be fine, but only with two methods of write-off from the warehouse. Or by product (if, for example, there is a p / f in the warehouse, then we write it off, if not, then minus its quantity), according to the technical card (we write off not the p / f, but its composition from the warehouse). But I want to make a write-off method, first by product, then by technical card. That is, if there is a p / f, we write off the p / f, if not, then its ingredients. How to implement it. And then when recalculating some profit, a lot of conditions are obtained due to this method of writing off a new one.