Models Remember Vars? - Printable Version

Code:
//Update All Product Tables so they have new pricing of raw material

        $this->load->model('mdl_product_parts');

        

        $this->mdl_product_parts->type = "raw_material";

        $this->mdl_product_parts->id_of_selected_type = $_POST['raw_materials_id'];

        $this->mdl_product_parts->price = $_POST['raw_materials_unit_price'];

        

        $this->mdl_product_parts->updateNewPrices();

        

        $ids = $this->mdl_product_parts->get();

        

        foreach($ids as $row)

        {

            $this->load->model("mdl_product_parts"); //Load product parts model

            $this->mdl_product_parts->product_id = $row->product_id; //set the product ID so we know what product parts to fetch    

            $this->load->model("mdl_products");

            $this->mdl_products->product_id = $row->product_id;

            $percentageID = 0;

            //find percentage ID

            $result = $this->mdl_products->get();

            foreach($result as $r)

            {

                $percentageID = $r->product_percentage_id;

            }

        

            //Find Percentage

            $this->load->model("mdl_percentage");

            $this->mdl_percentage->percentage_id = $percentageID; //Set percentage ID to what was set on the edit products page

            $percentage = 0;

            

            $result = $this->mdl_percentage->get(); 

            foreach($result as $row)

            {

                $percentage = $row->percentage_value; //Set the percentage Varible to the percetnage value so we know how much markup.

            }

        

            $result = $this->mdl_product_parts->get();

            print_r($result);

            $total = 0;

            $laborHours = 0;

            $laborCost = 0;

            $materialCost = 0;

            $markup = $percentage;

            foreach($result as $row)

            {

                

                $temp = $row->price * $row->qty_of_selected_type;

                $total += $temp;

                

                //work out labor hours and cost

                if($row->type == "labor")

                {

                    $laborHours += $row->qty_of_selected_type;

                    $laborCost += ($row->qty_of_selected_type * $row->price);

                }

                

                if($row->type == "raw_material")

                {

                    $materialCost += ($row->qty_of_selected_type * $row->price);

                }

                

            }

            

            $sellingPrice = $total * $markup / 100;

            $sellingPrice += $total;

            

            

        

        $this->mdl_products->manual = "0"; //Manual is false becuase percentage method has been used

        $this->mdl_products->product_material_cost = $materialCost;

        $this->mdl_products->product_labor_cost = $laborCost;

        $this->mdl_products->product_labor_time = $laborHours;

        $this->mdl_products->product_selling_price = $sellingPrice;

        

        $this->mdl_products->product_percentage_id = $percentageID;





        $this->mdl_products->updateCalc();

        

        }