public function saverequestmedicineAction()
{
$values = $this->_request->getParams();
// var_dump($values);die;
$array = array();
$MedicineModel = new MedicineModel();
$requestMedicineModel = new RequestmedicineModel();
$supplyStockModel = new SupplystockModel();
$supplyModel = new SupplyModel();
$columns = $requestMedicineModel->info(Zend_Db_Table_Abstract::COLS);
$requestMedicineModel->getAdapter()->beginTransaction();
try {
if ($values['dtrequestmedicine'] != null && $values['hrrequestmedicine'] != null) {
$dtmedicinerequest = new Zend_Date($values['dtrequestmedicine'], 'dd-MM-YYYY');
$dtmedicinerequest = $dtmedicinerequest->toString('YYYY-MM-dd');
$array['dtmedicinerequest'] = $dtmedicinerequest . ' ' . $values['hrrequestmedicine'] . ':00';
}
if ($values['fgstockdiscount'] == '1') {
$cdsupply = $MedicineModel->fetchRow("cdmedicine = " . $values['cdmedicine']);
$qtquantitySupplyStock = $supplyStockModel->fetchRow("cdsupply = " . $cdsupply['cdsupply']);
$qtquantitySupply = $supplyModel->fetchRow("cdsupply = " . $cdsupply['cdsupply']);
// Valida se a quantidade em estoque é maior que a quantidade a ser descontada
if ($qtquantitySupplyStock['qtquantity'] > $values['nrstockdiscount'] && $qtquantitySupply['qtbalance'] > $values['nrstockdiscount']) {
$supplyStockModel->update(array("qtquantity" => $qtquantitySupplyStock['qtquantity'] - $values['nrstockdiscount'], "qtsupplybalance" => $qtquantitySupplyStock['qtsupplybalance'] - $values['nrstockdiscount']), "cdsupply = " . $cdsupply['cdsupply']);
$supplyModel->update(array("qtbalance" => $qtquantitySupply['qtbalance'] - $values['nrstockdiscount']), "cdsupply = " . $cdsupply['cdsupply']);
}
} else {
$values['fgstockdiscount'] = '2';
}
foreach ($values as $id => $value) {
if (isset($value) && $value != '' && $value != '0' && in_array($id, $columns)) {
$array[$id] = addslashes($value);
} else {
if (in_array($id, $columns)) {
$array[$id] = null;
}
}
}
if (empty($array)) {
throw new Exception('Dados Incorretos. Confira seus dados e Tente Novamente.');
} else {
$requestMedicineModel->insert($array);
}
$requestMedicineModel->getAdapter()->commit();
} catch (Exception $e) {
$this->_model->getAdapter()->rollBack();
$this->addMessage($e->getMessage());
}
}
