public function addRefrigerator() { $form_values = $this->form_values; $cold_chain = new ColdChain(); $cold_chain->setAssetId($form_values['asset_id']); $source_id = $this->_em->getRepository('Stakeholders')->find($form_values['source_id']); $cold_chain->setSource($source_id); $model_id = $this->_em->getRepository('CcmModels')->find($form_values['catalogue_id']); $cold_chain->setCcmModel($model_id); $asset_type = $this->_em->getRepository('CcmAssetTypes')->find($model_id->getCcmAssetType()->getPkId()); $cold_chain->setCcmAssetType($asset_type); if (!empty($form_values['temperature_monitor'])) { $temperature_monitor = $this->_em->getRepository('ListDetail')->find($form_values['temperature_monitor']); $cold_chain->setTemperatureMonitor($temperature_monitor); } $cold_chain->setSerialNumber($form_values['serial_number']); $cold_chain->setWorkingSince(new \DateTime(App_Controller_Functions::dateToDbFormat($form_values['working_since']))); $auto_gen_id = App_Controller_Functions::generateCcemUniqueAssetId(Model_CcmAssetTypes::REFRIGERATOR); $cold_chain->setAutoAssetId($auto_gen_id); $user_id = $this->_em->getRepository('Users')->find($this->_user_id); $cold_chain->setCreatedBy($user_id); $cold_chain->setCreatedDate(new \DateTime(App_Controller_Functions::dateToDbFormat(date("d/m/Y")))); if (!empty($form_values['warehouse']) && $form_values['placed_at'] == 1) { $wh_id = $this->_em->getRepository('Warehouses')->find($form_values['warehouse']); $cold_chain->setWarehouse($wh_id); } $this->_em->persist($cold_chain); $this->_em->flush(); $ccm_id = $cold_chain->getPkId(); // if (!empty($form_values['warehouse']) && $form_values['placed_at'] == 1) { $ccm_status_history = new CcmStatusHistory(); $ccm_status_history->setStatusDate(new \DateTime(date("Y-m-d h:i"))); $cold_chian_id = $this->_em->getRepository('ColdChain')->find($ccm_id); $ccm_status_history->setCcm($cold_chian_id); if (!empty($form_values['warehouse']) && $form_values['placed_at'] == 1) { $warehouse_id = $this->_em->getRepository('Warehouses')->find($form_values['warehouse']); $ccm_status_history->setWarehouse($warehouse_id); } else { $warehouse_id = $this->_em->getRepository('Warehouses')->find($this->_identity->getWarehouseId()); $ccm_status_history->setWarehouse($warehouse_id); } $ccm_status_list_id = $this->_em->getRepository('CcmStatusList')->find($form_values['ccm_status_list_id']); $ccm_status_history->setCcmStatusList($ccm_status_list_id); $asset_id = $this->_em->getRepository('CcmAssetTypes')->find(Model_CcmAssetTypes::REFRIGERATOR); $ccm_status_history->setCcmAssetType($asset_id); if (!empty($form_values['reason'])) { $reason = $this->_em->getRepository('CcmStatusList')->find($form_values['reason']); $ccm_status_history->setReason($reason); } if (!empty($form_values['utilization'])) { $utilization = $this->_em->getRepository('CcmStatusList')->find($form_values['utilization']); $ccm_status_history->setUtilization($utilization); } $this->_em->persist($ccm_status_history); $this->_em->flush(); $ccm_history_id = $ccm_status_history->getPkId(); $this->updateCcmStatusHistory($ccm_id, $ccm_history_id); // } $placements_locations = new PlacementLocations(); $location_type = $this->_em->getRepository('ListDetail')->find(Model_PlacementLocations::LOCATIONTYPE_CCM); $placements_locations->setLocationType($location_type); $placements_locations->setLocationBarcode($auto_gen_id); $placements_locations->setLocationId($ccm_id); $this->_em->persist($placements_locations); $this->_em->flush(); $ware_house = $form_values['warehouse']; if (!empty($ware_house)) { $qry = "SELECT REPUpdateCapacity({$ware_house}) from DUAL"; $row = $this->_em->getConnection()->prepare($qry); $row->execute(); $qry1 = "SELECT REPUpdateRequirement({$ware_house}) from DUAL"; $row1 = $this->_em->getConnection()->prepare($qry1); $row1->execute(); } }