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 getWarehouse()
{
$this->__load();
return parent::getWarehouse();
}
public function addIcePack()
{
// App_Controller_Functions::pr($this->form_values);
$ccm_model_id = $this->form_values['ccm_model_id'];
foreach ($ccm_model_id as $index => $model_id) {
$form_values = $this->form_values;
$quantity = $this->form_values['quantity'];
$cold_chain = new ColdChain();
$cold_chain->setQuantity($quantity[$index]);
$asset_id = $this->_em->getRepository('CcmAssetTypes')->find(Model_CcmAssetTypes::ICEPACKS);
$cold_chain->setCcmAssetType($asset_id);
$m_id = $this->_em->getRepository('CcmModels')->find($model_id);
$cold_chain->setCcmModel($m_id);
$created_by = $this->_em->getRepository('Users')->find($this->_user_id);
$cold_chain->setCreatedBy($created_by);
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::ICEPACKS);
$ccm_status_history->setCcmAssetType($asset1_id);
$ccm_status_history->setWorkingQuantity($quantity[$index]);
$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);
}
// $placements_locations = new PlacementLocations();
// $location_type = $this->_em->getRepository('ListDetail')->find(30);
// $placements_locations->setLocationType($location_type);
// $placements_locations->setLocationId(Model_CcmAssetTypes::ICEPACKS);
// $this->_em->persist($placements_locations);
// $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();
}
