public function addQuantity() { $id = $this->input->post('txtItemID'); $stocks = Stocks_model::find($id); $details = array("quantity" => $stocks->quantity + $this->input->post('txtQuantity'), "date_last_restocked" => $this->input->post('txtDateRestock')); $stocks->update_attributes($details); }
public function insertMaterials() { $this->form_validation->set_rules('txtItemID', 'Item ID', 'trim|required'); $this->form_validation->set_rules('txtQuantity', 'Quantity', 'trim|required'); $this->form_validation->set_rules('txtProjectID', 'Project ID', 'trim|required'); $this->form_validation->set_rules('txtDateIssued', 'Date Issued', 'trim|required'); if ($this->form_validation->run()) { $item_id = $this->input->post('txtItemID'); $quantity = $this->input->post('txtQuantity'); $stock = Stock_info_model::find($item_id); //insert into materials table $data = array('item_id' => $item_id, 'quantity' => $quantity, 'price' => $stock->price, 'project_id' => $this->input->post('txtProjectID'), 'date_issued' => $this->input->post('txtDateIssued')); if (Materials_model::create($data)) { $row = Stocks_model::find($item_id); $row->quantity -= $quantity; $row->save(); $this->session->set_userdata('added', 1); redirect('ams/view_all_materials'); } } }