Greetings y'all!
I'm hoping someone can give me some advice on the best way to do this.
I work at a fence manufacturing company that does custom jobs. A job can be built, but need additional work done by outside companies. So
Company XYZ:
Posts
$x per linier foot if width is xx
$y per linier foot if width is yy
Panel style x
$x per linier foot
Panel style y
$y per linier foot
...etc...
Company ABC:
Posts
$x if width is xx and length is between 3 and 4
$y if width is xx and length is between 4 and 5
Panel style x of width 6'
$x if width between 3 and 4
$y if width is between 4 and 5
...etc...
Its simple enough to convert all charges to a per foot on a stepping basis with a table structure similar to:
charges(_chargeID_, companyID, styleID, sizeMin, sizeMax, chargePerFoot)
What I'm not sure of is if this is the best way to accomplish automating the cost of outside work.
Any help is appreciated!
I'm hoping someone can give me some advice on the best way to do this.
I work at a fence manufacturing company that does custom jobs. A job can be built, but need additional work done by outside companies. So
Company XYZ:
Posts
$x per linier foot if width is xx
$y per linier foot if width is yy
Panel style x
$x per linier foot
Panel style y
$y per linier foot
...etc...
Company ABC:
Posts
$x if width is xx and length is between 3 and 4
$y if width is xx and length is between 4 and 5
Panel style x of width 6'
$x if width between 3 and 4
$y if width is between 4 and 5
...etc...
Its simple enough to convert all charges to a per foot on a stepping basis with a table structure similar to:
charges(_chargeID_, companyID, styleID, sizeMin, sizeMax, chargePerFoot)
What I'm not sure of is if this is the best way to accomplish automating the cost of outside work.
Any help is appreciated!
