public function setSerialNumber($serialNumber) { $this->__load(); return parent::setSerialNumber($serialNumber); }
public function transferColdChainAsset() { $form_values = $this->form_values; if ($form_values['transfer'] == 1) { $cold_chain_update = $this->_table->find($form_values['coldchain_id']); $to_warehouse = $this->_em->getRepository('Warehouses')->find($form_values['to_warehouse']); $cold_chain_update->setWarehouse($to_warehouse); $this->_em->persist($cold_chain_update); $this->_em->flush(); } elseif ($form_values['quantity_issue'] > 0) { if ($form_values['quantity_issue'] < $form_values['quantity_available']) { $sub_sql = $this->_em->createQueryBuilder()->select("" . "cc.assetId, cc.quantity, cc.autoAssetId, cc.serialNumber," . "cc.estimateLife, cc.workingSince, cc.manufactureYear, cc.status," . "cc.approvedBy, cc.approvedOn, cc.createdDate," . "csh.pkId AS ccmStatusHistoryId," . "cat.pkId AS ccmAssetTypeId," . "cmod.pkId AS ccmModelId," . "cu.pkId AS createdById," . "sh.pkId AS sourceId")->from("ColdChain", "cc")->leftJoin('cc.ccmStatusHistory', 'csh')->leftjoin('cc.ccmAssetType', 'cat')->leftjoin('cc.ccmModel', 'cmod')->leftjoin('cc.createdBy', 'cu')->leftJoin('cc.source', 'sh')->where("cc.pkId = " . $this->form_values['coldchain_id']); $one_row = $sub_sql->getQuery()->getResult(); $one_row = $one_row[0]; $cold_chain = new ColdChain(); $cold_chain->setAssetId($one_row['assetId']); $cold_chain->setQuantity($form_values['quantity_issue']); $cold_chain->setAutoAssetId($one_row['autoAssetId']); $cold_chain->setSerialNumber($one_row['serialNumber']); $cold_chain->setEstimateLife($one_row['estimateLife']); $cold_chain->setWorkingSince(new \DateTime(App_Controller_Functions::dateToDbFormat($one_row['workingSince']))); $cold_chain->setManufactureYear(new \DateTime(App_Controller_Functions::dateToDbFormat($one_row['manufactureYear']))); $cold_chain->setStatus($one_row['status']); $cold_chain->setApprovedBy($one_row['approvedBy']); $cold_chain->setApprovedOn(new \DateTime(App_Controller_Functions::dateToDbFormat($one_row['approvedOn']))); $cold_chain->setCreatedDate(new \DateTime(App_Controller_Functions::dateToDbFormat(date("d/m/Y")))); if ($one_row['ccmStatusHistoryId']) { $status_history_id = $this->_em->getRepository('CcmStatusHistory')->find($one_row['ccmStatusHistoryId']); $cold_chain->setCcmStatusHistory($status_history_id); } $asset_type = $this->_em->getRepository('CcmAssetTypes')->find($one_row['ccmAssetTypeId']); $cold_chain->setCcmAssetType($asset_type); $model_id = $this->_em->getRepository('CcmModels')->find($one_row['ccmModelId']); $cold_chain->setCcmModel($model_id); $created_by_id = $this->_em->getRepository('Users')->find($one_row['createdById']); $cold_chain->setCreatedBy($created_by_id); $cold_chain->setCreatedDate(new \DateTime(App_Controller_Functions::dateToDbFormat(date("d/m/Y")))); if ($one_row['sourceId']) { $source_id = $this->_em->getRepository('Stakeholders')->find($one_row['sourceId']); $cold_chain->setSource($source_id); } if ($form_values['to_warehouse']) { $frm_warehouse_id = $this->_em->getRepository('Warehouses')->find($form_values['to_warehouse']); $cold_chain->setWarehouse($frm_warehouse_id); } $this->_em->persist($cold_chain); $this->_em->flush(); /* * Adjust Quantity */ $adjusted_quantity = $form_values['quantity_available'] - $form_values['quantity_issue']; $cold_chain_adjust_quantity = $this->_table->find($form_values['coldchain_id']); $cold_chain_adjust_quantity->setQuantity($adjusted_quantity); $this->_em->persist($cold_chain_adjust_quantity); $this->_em->flush(); } /* elseif ($form_values['quantity_issue'] >= $form_values['quantity_available']) { $cold_chain_update = $this->_table->find($form_values['coldchain_id']); $cold_chain_update->setWarehouse($form_values['to_warehouse']); $this->_em->persist($cold_chain_update); $this->_em->flush(); } */ } //enter in clod chain history if ($form_values['transfer'] == 1 || $form_values['quantity_issue'] > 0) { $ccm_transfer = new CcmTransferHistory(); if ($form_values['quantity_issue']) { $ccm_transfer->setQuantity($form_values['quantity_issue']); } $ccm_transfer->setTransferDate(new \DateTime(App_Controller_Functions::dateToDbFormat(date("d/m/Y")))); $transferBy = $this->_em->getRepository('Users')->find($this->_user_id); $ccm_transfer->setTransferBy($transferBy); $ccm_id = $this->_em->getRepository('ColdChain')->find($form_values['coldchain_id']); $ccm_transfer->setCcm($ccm_id); $ccm_status_list_id = $this->_em->getRepository('CcmStatusList')->find('1'); //Temporarily hard code as this filed not found in coldchain table $ccm_transfer->setCcmStatusList($ccm_status_list_id); $from_warehouse = $this->_em->getRepository('Warehouses')->find($form_values['from_warehouse']); $ccm_transfer->setFromWarehouse($from_warehouse); $to_warehouse = $this->_em->getRepository('Warehouses')->find($form_values['to_warehouse']); $ccm_transfer->setToWarehouse($to_warehouse); $this->_em->persist($ccm_transfer); $this->_em->flush(); } if (!empty($form_values['to_warehouse'])) { $to_warehouse = $form_values['to_warehouse']; $qry = "SELECT REPUpdateCapacity({$to_warehouse}) from DUAL"; $row = $this->_em->getConnection()->prepare($qry); $row->execute(); $qry1 = "SELECT REPUpdateRequirement({$to_warehouse}) from DUAL"; $row1 = $this->_em->getConnection()->prepare($qry1); $row1->execute(); } if (!empty($form_values['from_warehouse'])) { $from_warehouse = $form_values['from_warehouse']; $qry = "SELECT REPUpdateCapacity({$from_warehouse}) from DUAL"; $row = $this->_em->getConnection()->prepare($qry); $row->execute(); $qry1 = "SELECT REPUpdateRequirement({$from_warehouse}) from DUAL"; $row1 = $this->_em->getConnection()->prepare($qry1); $row1->execute(); } }
public function addGenerator() { $form_values = $this->form_values; // App_Controller_Functions::pr($form_values); $ccm_model = $this->_em->getRepository('CcmModels')->find($form_values['ccm_model_id']); $user_id = $this->_em->getRepository('Users')->find($this->_user_id); $ccm_model->setModifiedBy($user_id); $ccm_model->setModifiedDate(new \DateTime(App_Controller_Functions::dateToDbFormat(date("d/m/Y")))); $ccm_model->setNoOfPhases($form_values['no_of_phases']); $this->_em->persist($ccm_model); $this->_em->flush(); $cold_chain = new ColdChain(); $cold_chain->setAssetId($form_values['asset_id']); //$status_list = $this->_em->getRepository('CcmStatusList')->find($form_values['ccm_status_list_id']); //$cold_chain->setCcmStatusList($status_list); $model_id = $this->_em->getRepository('CcmModels')->find($form_values['ccm_model_id']); $cold_chain->setCcmModel($model_id); $asset_type = $this->_em->getRepository('CcmAssetTypes')->find(Model_CcmAssetTypes::GENERATOR); $cold_chain->setCcmAssetType($asset_type); $cold_chain->setSerialNumber($form_values['serial_number']); $cold_chain->setWorkingSince(new \DateTime(App_Controller_Functions::dateToDbFormat($form_values['working_since']))); $cold_chain->setCreatedBy($user_id); $source_id = $this->_em->getRepository('Stakeholders')->find($form_values['source_id']); $cold_chain->setSource($source_id); $auto_gen_id = App_Controller_Functions::generateCcemUniqueAssetId(Model_CcmAssetTypes::GENERATOR); $cold_chain->setAutoAssetId($auto_gen_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(); $last_ccm_id = $cold_chain->getPkId(); $generators = new CcmGenerators(); $power_source = $this->_em->getRepository('ListDetail')->find($form_values['power_source']); $generators->setPowerSource($power_source); $generators->setPowerRating($form_values['power_rating']); $generators->setUseFor($form_values['use_for']); $generators->setAutomaticStartMechanism($form_values['automatic_start']); $ccm_id = $this->_em->getRepository('ColdChain')->find($last_ccm_id); $generators->setCcm($ccm_id); $generators->setCreatedBy($user_id); $generators->setCreatedDate(new \DateTime(App_Controller_Functions::dateToDbFormat(date("d/m/Y")))); $generators->setModifiedBy($user_id); $generators->setModifiedDate(new \DateTime(App_Controller_Functions::dateToDbFormat(date("d/m/Y")))); $this->_em->persist($generators); $this->_em->flush(); $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($last_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::GENERATOR); $ccm_status_history->setCcmAssetType($asset_id); if (!empty($form_values['reasons'])) { $reason = $this->_em->getRepository('CcmStatusList')->find($form_values['reasons']); $ccm_status_history->setReason($reason); } if (!empty($form_values['utilizations'])) { $utilization = $this->_em->getRepository('CcmStatusList')->find($form_values['utilizations']); $ccm_status_history->setUtilization($utilization); } $this->_em->persist($ccm_status_history); $this->_em->flush(); $ccm_history_id = $ccm_status_history->getPkId(); $cold_chain_model = new Model_ColdChain(); $cold_chain_model->updateCcmStatusHistory($last_ccm_id, $ccm_history_id); // $placements_locations = new PlacementLocations(); // $location_type = $this->_em->getRepository('ListDetail')->find(30); // $placements_locations->setLocationType($location_type); // $placements_locations->setLocationId(Model_CcmAssetTypes::GENERATOR); // $this->_em->persist($placements_locations); // $this->_em->flush(); }