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');
}
}
