public function delete_redistribution($id) { $redistribution_data = redistribution_data::get_one($id); foreach ($redistribution_data as $key => $value) { $quantity_sent = intval($value['quantity_sent']); $stock_id = $value['stock_id']; $stock_data = facility_stocks::get_facilty_stock_id($stock_id); foreach ($stock_data as $keys => $values) { $current_balance = intval($values['current_balance']); $new_balance = $current_balance + $quantity_sent; $update_array = array('id' => $stock_id, 'current_balance' => $new_balance); $inserttransaction = Doctrine_Manager::getInstance()->getCurrentConnection(); $inserttransaction->execute("UPDATE `facility_stocks` SET `current_balance` = '{$new_balance}' WHERE id= '{$stock_id}'"); $inserttransaction->execute("UPDATE `redistribution_data` SET `status` = '5' WHERE id= '{$id}'"); $this->session->set_flashdata('system_success_message', "The Issue has been Deleted"); redirect('issues/confirm_external_issue_edit'); } } }
public function update_stock_level_external_edit() { // echo "<pre>"; // print_r($_POST);die; if ($this->input->post('facility_stock_id')) { $redistribution_id = $this->input->post('redistribution_id'); $facility_stock_id = $this->input->post('facility_stock_id'); $facility_code = $this->session->userdata('facility_id'); $receiving_facility = array_values($this->input->post('facility_name')); $commodity_initial_quantity = array_values($this->input->post('old_quantity')); $commodity_total_units = array_values($this->input->post('commodity_total_units')); // $source_of_item = array_values($this -> input -> post('source_of_item')); $count = count($facility_stock_id); $date_of_entry = date('y-m-d H:i:s'); //collect n set the data in the array for ($i = 0; $i < $count; $i++) { $redistribution_id = $redistribution_id[$i]; $receive_facility_id = $receiving_facility[$i]; $stock_id = $facility_stock_id[$i]; $quantity_sent = $commodity_total_units[$i]; $old_quantity = $commodity_initial_quantity[$i]; $stock_data = facility_stocks::get_facilty_stock_id($stock_id); foreach ($stock_data as $key => $value) { $current_balance = intval($value['current_balance']); $new_balance = $current_balance - $quantity_sent; $new_quantity = 0; if ($quantity_sent > 0) { $new_quantity = $quantity_sent; } else { $new_quantity = $old_quantity; } $update_array = array('id' => $stock_id, 'current_balance' => $new_balance); $inserttransaction = Doctrine_Manager::getInstance()->getCurrentConnection(); $inserttransaction->execute("UPDATE `facility_stocks` SET `current_balance` = '{$new_balance}' WHERE id= '{$stock_id}'"); $inserttransaction->execute("UPDATE `redistribution_data` SET `receive_facility_code` = '{$receive_facility_id}', `quantity_sent` = '{$new_quantity}' WHERE id= '{$redistribution_id}'"); } } //set the notifications //$this->hcmp_functions->send_stock_update_sms(); $this->session->set_flashdata('system_success_message', "Redistribution Data Has Been Updated"); redirect('issues/confirm_external_issue'); } }