public function addTransport() { date_default_timezone_set('Asia/karachi'); $form_values = $this->form_values; // App_Controller_Functions::pr($form_values); $user_id = $this->_em->getRepository('Users')->find($this->_user_id); $cold_chain = new ColdChain(); //$asset_type = $this->_em->getRepository('CcmAssetTypes')->find(11); $cold_chain->setAssetId($form_values['asset_id']); $cold_chain->setAutoAssetId(App_Controller_Functions::generateCcemUniqueAssetId(Model_CcmAssetTypes::TRANSPORT)); //$status_list = $this->_em->getRepository('CcmStatusList')->find($form_values['ccm_status_list_id']); //$cold_chain->setCcmStatusList($status_list); //$cold_chain->setStakeholderId($stakeholder); $stakeholder = $this->_em->getRepository('Stakeholders')->find($form_values['source_id']); $cold_chain->setSource($stakeholder); if ($form_values['ccm_asset_sub_type_id']) { $asset_type = $this->_em->getRepository('CcmAssetTypes')->find(Model_CcmAssetTypes::TRANSPORT); $cold_chain->setCcmAssetType($asset_type); } $model_id = $this->_em->getRepository('CcmModels')->find($form_values['ccm_model_id']); $cold_chain->setCcmModel($model_id); $cold_chain->setManufactureYear(new \DateTime(App_Controller_Functions::dateToDbFormat($form_values['manufacture_year']))); 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); } $cold_chain->setCreatedBy($user_id); $cold_chain->setCreatedDate(App_Tools_Time::now()); $cold_chain->setModifiedBy($user_id); $cold_chain->setModifiedDate(App_Tools_Time::now()); $this->_em->persist($cold_chain); $this->_em->flush(); $last_ccm_id = $cold_chain->getPkId(); $ccm_vehicles = new CcmVehicles(); $cold_chain_id = $this->_em->getRepository('ColdChain')->find($last_ccm_id); $ccm_vehicles->setCcm($cold_chain_id); $ccm_asset_sub_type = $this->_em->getRepository('CcmAssetTypes')->find($form_values['ccm_asset_sub_type_id']); $ccm_vehicles->setCcmAssetSubType($ccm_asset_sub_type); $ccm_vehicles->setRegistrationNo($form_values['registration_no']); $ccm_vehicles->setUsedForEpi($form_values['used_for_epi']); if ($form_values['fuel_type_id']) { $fuel_type_id = $this->_em->getRepository('ListDetail')->find($form_values['fuel_type_id']); $ccm_vehicles->setFuelType($fuel_type_id); } $ccm_vehicles->setComments($form_values['comments']); $ccm_vehicles->setCreatedBy($user_id); $ccm_vehicles->setCreatedDate(App_Tools_Time::now()); $ccm_vehicles->setModifiedBy($user_id); $ccm_vehicles->setModifiedDate(App_Tools_Time::now()); $this->_em->persist($ccm_vehicles); $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::TRANSPORT); $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['reason'])) { $utilization = $this->_em->getRepository('CcmStatusList')->find($form_values['utilization']); $ccm_status_history->setUtilization($utilization); } $ccm_status_history->setCreatedBy($user_id); $ccm_status_history->setCreatedDate(App_Tools_Time::now()); $ccm_status_history->setModifiedBy($user_id); $ccm_status_history->setModifiedDate(App_Tools_Time::now()); $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::TRANSPORT); // $this->_em->persist($placements_locations); // $this->_em->flush(); }
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 addColdRoom() { // App_Controller_Functions::pr($this->form_values); $form_values = $this->form_values; $ccm_model = $this->_em->getRepository('CcmModels')->find($form_values['ccm_model_id']); $ccm_model->setAssetDimensionLength($form_values['asset_dimension_length']); $ccm_model->setAssetDimensionWidth($form_values['asset_dimension_width']); $ccm_model->setAssetDimensionHeight($form_values['asset_dimension_height']); if ($form_values['ccm_asset_sub_type_id'] == Model_CcmAssetTypes::SUBFREEZERROOM) { //for -20'C Freezer room $ccm_model->setTemperatureType(1); $ccm_model->setNetCapacity20($form_values['net_capacity']); $ccm_model->setGrossCapacity20($form_values['gross_capacity']); } elseif ($form_values['ccm_asset_sub_type_id'] == Model_CcmAssetTypes::SUBCOLDROOM) { //for +4'C Cold room $ccm_model->setTemperatureType(0); $ccm_model->setNetCapacity4($form_values['net_capacity']); $ccm_model->setGrossCapacity4($form_values['gross_capacity']); } $user_id = $this->_em->getRepository('Users')->find($this->_user_id); $ccm_model->setCreatedBy($user_id); $ccm_model->setCreatedDate(App_Tools_Time::now()); $ccm_model->setModifiedBy($user_id); $ccm_model->setModifiedDate(App_Tools_Time::now()); $this->_em->persist($ccm_model); $this->_em->flush(); // $cold_chain = new ColdChain(); // $cold_chain->setAssetId($form_values['asset_id']); // // $cold_chain->setAutoAssetId(App_Controller_Functions::generateCcemUniqueAssetId($form_values['ccm_asset_sub_type_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($form_values['ccm_asset_sub_type_id']); // $cold_chain->setCcmAssetType($asset_type); // $auto_gen_id = App_Controller_Functions::generateCcemUniqueAssetId(Model_CcmAssetTypes::COLDROOM); // $cold_chain->setAutoAssetId($auto_gen_id); // // $cold_chain->setWorkingSince(new \DateTime(App_Controller_Functions::dateToDbFormat($form_values['working_since']))); // $user_id_1 = $this->_em->getRepository('Users')->find($this->_user_id); // $cold_chain->setCreatedBy($user_id_1); // $cold_chain->setCreatedDate(App_Tools_Time::now()); // 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(); $cold_chain = new ColdChain(); $cold_chain->setAssetId($form_values['asset_id']); $model_id = $this->_em->getRepository('CcmModels')->find($form_values['ccm_model_id']); $cold_chain->setCcmModel($model_id); $asset_type = $this->_em->getRepository('CcmAssetTypes')->find($form_values['ccm_asset_sub_type_id']); $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']))); $auto_gen_id = App_Controller_Functions::generateCcemUniqueAssetId(Model_CcmAssetTypes::COLDROOM); $cold_chain->setAutoAssetId($auto_gen_id); $source_id = $this->_em->getRepository('Stakeholders')->find($form_values['source_id']); $cold_chain->setSource($source_id); 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); } $created_by = $this->_em->getRepository('Users')->find($this->_user_id); $cold_chain->setCreatedBy($created_by); $cold_chain->setCreatedDate(App_Tools_Time::now()); $cold_chain->setModifiedBy($created_by); $cold_chain->setModifiedDate(App_Tools_Time::now()); $this->_em->persist($cold_chain); $this->_em->flush(); $last_ccm_id = $cold_chain->getPkId(); // App_Controller_Functions::pr($this->form_values); $cold_rooms = new CcmColdRooms(); $backup_generator = $this->_em->getRepository('ListDetail')->find($form_values['backup_generator']); $cold_rooms->setBackupGenerator($backup_generator); $ccm_id = $this->_em->getRepository('ColdChain')->find($last_ccm_id); $cold_rooms->setCcm($ccm_id); $asset_sub_type_id = $this->_em->getRepository('CcmAssetTypes')->find($form_values['ccm_asset_sub_type_id']); $cold_rooms->setCcmAssetSubType($asset_sub_type_id); $cold_rooms->setCoolingSystem($form_values['cooling_system']); $cold_rooms->setCreatedBy($user_id); $cold_rooms->setCreatedDate(App_Tools_Time::now()); $cold_rooms->setHasVoltage($form_values['has_voltage']); $cold_rooms->setModifiedBy($user_id); $cold_rooms->setModifiedDate(App_Tools_Time::now()); if (!empty($form_values['refrigerator_gas_type'])) { $refrigerator_gas_type = $this->_em->getRepository('ListDetail')->find($form_values['refrigerator_gas_type']); $cold_rooms->setRefrigeratorGasType($refrigerator_gas_type); } if (!empty($form_values['temperature_recording_system'])) { $temperature_recording_system = $this->_em->getRepository('ListDetail')->find($form_values['temperature_recording_system']); $cold_rooms->setTemperatureRecordingSystem($temperature_recording_system); } if (!empty($form_values['type_recording_system'])) { $type_recording_system = $this->_em->getRepository('ListDetail')->find($form_values['type_recording_system']); $cold_rooms->setTypeRecordingSystem($type_recording_system); } $cold_rooms->setCreatedBy($user_id); $cold_rooms->setCreatedDate(App_Tools_Time::now()); $cold_rooms->setModifiedBy($user_id); $cold_rooms->setModifiedDate(App_Tools_Time::now()); $this->_em->persist($cold_rooms); $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::COLDROOM); $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); } $ccm_status_history->setCreatedBy($user_id); $ccm_status_history->setCreatedDate(App_Tools_Time::now()); $ccm_status_history->setModifiedBy($user_id); $ccm_status_history->setModifiedDate(App_Tools_Time::now()); $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(Model_PlacementLocations::LOCATIONTYPE_CCM); $placements_locations->setLocationType($location_type); $placements_locations->setLocationBarcode($auto_gen_id); $placements_locations->setLocationId($last_ccm_id); $placements_locations->setCreatedBy($user_id); $placements_locations->setCreatedDate(App_Tools_Time::now()); $placements_locations->setModifiedBy($user_id); $placements_locations->setModifiedDate(App_Tools_Time::now()); $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(); } }
public function setAutoAssetId($autoAssetId) { $this->__load(); return parent::setAutoAssetId($autoAssetId); }
public function addVaccineCarrier() { //$ccm_model = new CcmModels(); $form_values = $this->form_values; $ccm_model = $this->_em->getRepository('CcmModels')->find($form_values['catalogue_id']); /* $ccm_model->setCatalogueId($form_values['catalogue_id']); $ccm_model->setAssetDimensionLength($form_values['asset_dimension_length']); $ccm_model->setAssetDimensionWidth($form_values['asset_dimension_width']); $ccm_model->setAssetDimensionHeight($form_values['asset_dimension_height']); * */ $asset_id_m = $this->_em->getRepository('CcmAssetTypes')->find(Model_CcmAssetTypes::VACCINECARRIER); $ccm_model->setCcmAssetType($asset_id_m); $created_by = $this->_em->getRepository('Users')->find($this->_user_id); $ccm_model->setCreatedBy($created_by); $ccm_model->setModifiedBy($created_by); $ccm_model->setCreatedDate(new \DateTime(date("Y-m-d"))); $ccm_model->setModifiedDate(new \DateTime(date("Y-m-d"))); $this->_em->persist($ccm_model); $this->_em->flush(); $model_id = $ccm_model->getPkId(); $cold_chain = new ColdChain(); $cold_chain->setAutoAssetId(App_Controller_Functions::generateCcemUniqueAssetId(Model_CcmAssetTypes::VACCINECARRIER)); $cold_chain->setQuantity($form_values['quantity']); $asset_id = $this->_em->getRepository('CcmAssetTypes')->find(Model_CcmAssetTypes::VACCINECARRIER); $cold_chain->setCcmAssetType($asset_id); $m_id = $this->_em->getRepository('CcmModels')->find($model_id); $cold_chain->setCcmModel($m_id); $created_by1 = $this->_em->getRepository('Users')->find($this->_user_id); $cold_chain->setCreatedBy($created_by1); if (!empty($this->form_values['warehouse'])) { $w_id = $this->form_values['warehouse']; $warehouse = $this->_em->getRepository('Warehouses')->find($w_id); $cold_chain->setWarehouse($warehouse); } $cold_chain->setCreatedDate(new \DateTime(date("Y-m-d"))); $this->_em->persist($cold_chain); $this->_em->flush(); $cold_chain_id = $cold_chain->getPkId(); $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($cold_chain_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); } $asset1_id = $this->_em->getRepository('CcmAssetTypes')->find(Model_CcmAssetTypes::VACCINECARRIER); $ccm_status_history->setCcmAssetType($asset1_id); $ccm_status_history->setWorkingQuantity($form_values['quantity']); $this->_em->persist($ccm_status_history); $this->_em->flush(); $cold_chain_model = new Model_ColdChain(); $ccm_history_id = $ccm_status_history->getPkId(); $cold_chain_model->updateCcmStatusHistory($cold_chain_id, $ccm_history_id); if (!empty($form_values['warehouse'])) { $ccm_history = new CcmHistory(); $w_id = $this->form_values['warehouse']; $warehouse_id = $this->_em->getRepository('Warehouses')->find($w_id); $ccm_history->setWarehouse($warehouse_id); $ccm_id = $this->_em->getRepository('ColdChain')->find($cold_chain_id); $ccm_history->setCcm($ccm_id); $action_id = $this->_em->getRepository('ListDetail')->find('10'); $ccm_history->setAction($action_id); $created_by12 = $this->_em->getRepository('Users')->find($this->_user_id); $ccm_history->setCreatedBy($created_by12); $ccm_history->setCreatedDate(new \DateTime(date("Y-m-d"))); $this->_em->persist($ccm_history); $this->_em->flush(); } }
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(); }