public function getProcurements() { $str_sql = $this->_em->createQueryBuilder()->select("DISTINCT s.referenceNumber, s.pkId, warehouse.warehouseName, " . "s.shipmentDate,s.shipmentQuantity as quantity,sh.status,ips.itemName,sa.activity")->from("ShipmentHistory", "sh")->join("sh.shipment", "s")->join("s.itemPackSize", "ips")->join("s.stakeholderActivity", "sa")->join("s.fundingSource", 'warehouse')->join("s.warehouse", 'w')->andWhere("w.pkId = " . $this->_identity->getWarehouseId()); if (!empty($this->form_values['from_date']) && !empty($this->form_values['to_date'])) { $str_sql->andWhere("DATE_FORMAT(s.shipmentDate,'%Y-%m-%d') BETWEEN '" . App_Controller_Functions::dateToDbFormat($this->form_values['from_date']) . "' AND '" . App_Controller_Functions::dateToDbFormat($this->form_values['to_date']) . "'"); } else { $date_from = date('Y-m' . '-01'); $date_to = date('Y-m-d'); $str_sql->andWhere("DATE_FORMAT(s.shipmentDate,'%Y-%m-%d') BETWEEN '" . $date_from . "' AND '" . $date_to . "'"); } if (!empty($this->form_values['item_pack_size_id'])) { $str_sql->andWhere("ips.pkId = '" . $this->form_values['item_pack_size_id'] . "'"); } if (!empty($this->form_values['from_warehouse_id'])) { $str_sql->andWhere("warehouse.pkId = '" . $this->form_values['from_warehouse_id'] . "'"); } if (!empty($this->form_values['status'])) { $str_sql->andWhere("sh.status = '" . $this->form_values['status'] . "'"); } //else { // $str_sql->andWhere("sh.status = 'Received' "); // } $str_sql->orderBy("s.pkId", "DESC"); $row = $str_sql->getQuery()->getResult(); return $row; }
public function getStartingDate() { $str_sql = $this->_em->createQueryBuilder()->select("w.startingOn as starting_date")->from("Warehouses", "w")->where("w.pkId = " . $this->form_values['wh_id']); //echo $str_sql->getQuery()->getSql(); // ->andWhere("wd.issueBalance > 0"); $row = $str_sql->getQuery()->getResult(); return App_Controller_Functions::dateToDbFormat($row[0]['starting_date']); }
public function addLog() { $data = $this->form_values; // App_Controller_Functions::pr($data); $name = $data['name']; $father_name = $data['father_name']; $age = $data['age']; $contact = $data['contact']; $address = $data['address']; $district = $data['district']; $uc = $data['uc']; $item_id = $data['item_id']; $dose_no = $data['dose_no']; $vaccination_date = $data['vaccination_date']; $reffers_to = $data['reffers_to']; $remarks = $data['remarks']; $user_id = $this->_user_id; $warehouse_id = $this->_identity->getWarehouseId(); $date = date("Y-m-d h:i:s"); foreach ($district as $key => $val) { if ($val != '' && $val >= 0) { $log_book = new LogBook(); $log_book->setName($name[$key]); $log_book->setFatherName($father_name[$key]); $log_book->setAge($age[$key]); $log_book->setContact($contact[$key]); $log_book->setAddress($address[$key]); $districtId = $this->_em->getRepository('Locations')->find($district[$key]); $log_book->setDistrictId($districtId); $ucId = $this->_em->getRepository('Locations')->find($uc[$key]); $log_book->setUnionCouncilId($ucId); $log_book->setVaccinationDate(new \DateTime(App_Controller_Functions::dateToDbFormat($vaccination_date[$key]))); $log_book->setRefferTo($reffers_to[$key]); $log_book->setRemarks($remarks[$key]); // $warehouse = $this->_em->getRepository('Warehouses')->find($warehouse_id); $log_book->setWarehouse($warehouse); $log_book->setCreatedDate(new \DateTime(App_Controller_Functions::dateToDbFormat($date))); $log_book->setCreatedBy($user_id); $this->_em->persist($log_book); $this->_em->flush(); $log_book_id = $log_book->getPkId(); foreach ($item_id as $key => $val) { $log_book_item_doses = new LogBookItemDoses(); $logBook = $this->_em->getRepository('LogBook')->find($log_book_id); $log_book_item_doses->setLogBookId($logBook); $itemPack = $this->_em->getRepository('ItemPackSizes')->find($val); $log_book_item_doses->setItemPackSize($itemPack); $log_book_item_doses->setDoses($dose_no[$key]); $this->_em->persist($log_book_item_doses); $this->_em->flush(); } } } }
public function addReportDatesAction() { $form = new Form_Iadmin_UpdateCluster(); if ($this->_request->isPost()) { $form_values = $this->_request->getPost(); if ($form_values['search'] == 'search') { $warehouses = new Model_Warehouses(); $warehouses->form_values = $form_values; $form->province->setValue($form_values['province']); $form->province_hidden->setValue($form_values['province']); $form->district_hidden->setValue($form_values['district']); $form->user_hidden->setValue($form_values['user']); $warehouse_data = $warehouses->getAllWarehousesReportDate(); $this->view->data = $warehouse_data; } else { $form_values_submit = $this->_request->getPost(); if ($form_values_submit['check'] != "") { foreach ($form_values_submit['check'] as $warehouse_id) { $warehouses_db = $this->_em->getRepository('Warehouses')->find($warehouse_id); if ($form_values_submit['from_edit'] != "") { $warehouses_db->setFromEdit(new \DateTime(App_Controller_Functions::dateToDbFormat($form_values_submit['from_edit']))); } if ($form_values_submit['starting_on'] != "") { $warehouses_db->setStartingOn(new \DateTime(App_Controller_Functions::dateToDbFormat($form_values_submit['starting_on']))); } if ($form_values_submit['working_uptil'] != "") { $warehouses_db->setWorkingUptill(new \DateTime(App_Controller_Functions::dateToDbFormat($form_values_submit['working_uptil']))); } } $created_by = $this->_em->find('Users', $this->_user_id); $warehouses_db->setCreatedBy($created_by); $warehouses_db->setCreatedDate(App_Tools_Time::now()); $warehouses_db->setModifiedBy($created_by); $warehouses_db->setModifiedDate(App_Tools_Time::now()); $this->_em->persist($warehouses_db); $this->_em->flush(); } } } $this->view->form = $form; }
public function addCampaign() { $campaign = new Campaigns(); $campaign->setCampaignName($this->form_values['campaign_name']); $campaign->setDateFrom(new \DateTime(App_Controller_Functions::dateToDbFormat($this->form_values['date_from']))); $campaign->setDateTo(new \DateTime(App_Controller_Functions::dateToDbFormat($this->form_values['date_to']))); $campaign->setCatchUpDays($this->form_values['catch_up_days']); $campaign_type_id = $this->_em->find('CampaignTypes', $this->form_values['campaign_type_id']); $campaign->setCampaignType($campaign_type_id); $created_by = $this->_em->find('Users', $this->_user_id); $campaign->setIsClosed('0'); $campaign->setCreatedBy($created_by); $campaign->setCreatedDate(new \DateTime()); $campaign->setModifiedBy($created_by); $campaign->setModifiedDate(new \DateTime()); $this->_em->persist($campaign); $this->_em->flush(); $last_id = $campaign->getPkId(); $campaign_id = $this->_em->find('Campaigns', $last_id); foreach ($this->form_values['item_id'] as $item_id) { $campaign_ips = new CampaignItemPackSizes(); $campaign_ips->setCampaign($campaign_id); $item_id_ips = $this->_em->find('ItemPackSizes', $item_id); $campaign_ips->setItemPackSize($item_id_ips); $this->_em->persist($campaign_ips); } $this->_em->flush(); //$district_ids = explode(',', $this->form_values['district_ids']); //App_Controller_Functions::pr($this->form_values['districts']); foreach ($this->form_values['districts'] as $district_id) { $campaign_d = new CampaignDistricts(); $campaign_d->setCampaign($campaign_id); $district_location_id = $this->_em->find('Locations', $district_id); $campaign_d->setDistrict($district_location_id); $this->_em->persist($campaign_d); } $this->_em->flush(); return $last_id; }
public function getAllIssueProductsByStakeholder() { $tran_date = $this->form_values['trans_date']; if (empty($tran_date)) { $tran_date = date("d/m/Y h:i:s A"); } $arr_data = array(); $str_sql = $this->_em->createQueryBuilder()->select('DISTINCT ips.pkId')->from('StockBatchWarehouses', 'sbw')->join("sbw.stockBatch", "sb")->join("sb.packInfo", "pi")->join("pi.stakeholderItemPackSize", "sip")->join("sip.itemPackSize", "ips")->where("sbw.warehouse = " . $this->_identity->getWarehouseId())->andWhere("DATE_FORMAT(sb.expiryDate,'%Y-%m-%d') > '" . App_Controller_Functions::dateToDbFormat($tran_date) . "'")->andWhere("sbw.quantity > 0")->orderBy("ips.listRank", "ASC"); //echo $str_sql->getQuery()->getSql(); $rows = $str_sql->getQuery()->getResult(); if (!empty($rows) && count($rows) > 0) { foreach ($rows as $row) { $item_ids[] = $row['pkId']; } $str_sql = $this->_em->createQueryBuilder()->select('DISTINCT ips.itemName as item_name, ips.pkId as item_pack_size_id')->from("ItemActivities", "ia")->join("ia.itemPackSize", "ips")->where("ips.itemCategory !=4")->andWhere("ia.stakeholderActivity = '" . $this->form_values['stakeholder_id'] . "'")->orderBy("ips.listRank", 'ASC'); $rows = $str_sql->getQuery()->getResult(); //echo $str_sql->getQuery()->getSql(); return $rows; } else { return false; } }
public function getShelfLifeMonths24($wh_id, $item_id, $time_period1) { $time_period = App_Controller_Functions::dateToDbFormat($time_period1); if (empty($wh_id)) { $wh_id = '159'; } $str_qry = "SELECT\n sum(stock_batch.quantity * item_pack_sizes.number_of_doses) AS Qty,\n Max(TIMESTAMPDIFF(MONTH, '{$time_period}', stock_batch.expiry_date)) as Max24months,\n Min(TIMESTAMPDIFF(MONTH, '{$time_period}', stock_batch.expiry_date)) as Min24months\n\n FROM\n stock_master\n INNER JOIN stock_detail ON stock_master.pk_id = stock_detail.stock_master_id\n INNER JOIN stock_batch ON stock_batch.pk_id = stock_detail.stock_batch_id\n INNER JOIN item_pack_sizes ON item_pack_sizes.pk_id = stock_batch.item_pack_size_id\n WHERE\n item_pack_sizes.pk_id = {$item_id} and\n stock_batch.warehouse_id = {$wh_id}\n AND stock_batch.expiry_date > CURDATE()\n and TIMESTAMPDIFF(MONTH, '{$time_period}', stock_batch.expiry_date) > 12\n "; $this->_em = Zend_Registry::get('doctrine'); $row = $row = $this->_em->getConnection()->prepare($str_qry); $row->execute(); return $row->fetchAll(); }
public function searchRefrigerator() { $form_values = $this->form_values; if (!empty($form_values['ccm_asset_sub_type_id'])) { $where[] = "cat.pkId = '" . $form_values['ccm_asset_sub_type_id'] . "'"; } if (!empty($form_values['source_id'])) { $where[] = "s.pkId = '" . $form_values['source_id'] . "'"; } if (!empty($form_values['ccm_status_list_id'])) { $where[] = "csl.pkId = '" . $form_values['ccm_status_list_id'] . "'"; } if (!empty($form_values['asset_id'])) { $where[] = "ccm.ccmAssetType = '" . $form_values['asset_id'] . "'"; } if (!empty($form_values['catalogue_id'])) { $where[] = "ccm.catalogueId = '" . $form_values['catalogue_id'] . "'"; } if (!empty($form_values['ccm_make_id'])) { $where[] = "ccmake.pkId = '" . $form_values['ccm_make_id'] . "'"; } if (!empty($form_values['ccm_model_id'])) { $where[] = "ccm.pkId = '" . $form_values['ccm_model_id'] . "'"; } if (!empty($form_values['serial_number'])) { $where[] = "cc.serialNumber = '" . $form_values['serial_number'] . "'"; } if (!empty($form_values['gross_capacity_from'])) { $where[] = "(ccm.grossCapacity20 >= '" . $form_values['gross_capacity_from'] . "' OR ccm.grossCapacity4 >= '" . $form_values['gross_capacity_from'] . "')"; } if (!empty($form_values['gross_capacity_to'])) { $where[] = "(ccm.grossCapacity20 <= '" . $form_values['gross_capacity_to'] . "' OR ccm.grossCapacity4 <= '" . $form_values['gross_capacity_to'] . "' )"; } if (!empty($form_values['working_since_from'])) { $where[] = "cc.workingSince >= '" . App_Controller_Functions::dateToDbFormat($form_values['working_since_from']) . "'"; } if (!empty($form_values['working_since_to'])) { $where[] = "cc.workingSince <= '" . App_Controller_Functions::dateToDbFormat($form_values['working_since_to']) . "'"; } if (!empty($form_values['cfc_free'])) { $where[] = "ccm.cfcFree = '" . $form_values['cfc_free'] . "'"; } if ($form_values['placed_at'] == 1 && !empty($form_values['warehouse'])) { $where[] = "w.pkId = '" . $form_values['warehouse'] . "'"; } if ($this->form_values['placed_at'] == 0) { $where[] = "w.pkId IS NULL "; } $where[] = "cp.pkId = '" . Model_CcmAssetTypes::REFRIGERATOR . "'"; // $where[] = "cc.createdBy = '" . $this->_user_id . "' "; if (is_array($where)) { $where_s = implode(" AND ", $where); } $str_sql = $this->_em->createQueryBuilder()->select("cc.pkId,cc.assetId,cc.quantity," . "ccm.ccmModelName,csl.ccmStatusListName," . "ccmake.ccmMakeName,cc.createdDate,cc.workingSince," . "d.locationName district, w.warehouseName facility," . "ccm.grossCapacity20, ccm.grossCapacity4," . "cat.assetTypeName")->from('ColdChain', 'cc')->leftjoin('cc.source', 's')->leftJoin('cc.ccmModel', 'ccm')->leftJoin('cc.ccmAssetType', 'cat')->leftJoin('cat.parent', 'cp')->leftJoin('ccm.ccmMake', 'ccmake')->leftJoin('cc.ccmStatusHistory', 'csh')->leftJoin('csh.ccmStatusList', 'csl'); if ($this->form_values['placed_at'] == 1) { $str_sql->join('cc.warehouse', 'w'); $str_sql->join('w.district', 'd'); } if ($this->form_values['placed_at'] == 0) { $str_sql->leftjoin('cc.warehouse', 'w'); $str_sql->leftjoin('w.district', 'd'); } $str_sql->where($where_s); // echo $str_sql->getQuery()->getSql(); $row = $str_sql->getQuery()->getResult(); if (!empty($row) && count($row) > 0) { return $row; } else { return false; } }
public function updateCampaignReadinessUcAction() { $this->_helper->layout->disableLayout(); $this->_helper->viewRenderer->setNoRender(TRUE); $form_values = $this->_request->getPost(); $campaign_readiness = $this->_em->find('CampaignReadinessUnionCouncil', $form_values['readiness_uc_id']); $campaign_readiness->setInaccessibleChildren($form_values['inaccessible_children']); $campaign_readiness->setNumberMobileTeams($form_values['no_of_mobile_teams']); $campaign_readiness->setUpecMeetingDate(new \DateTime(App_Controller_Functions::dateToDbFormat($form_values['date_upec_meeting']))); $campaign_readiness->setInaccessibleArea($form_values['inaccessible_area']); $campaign_readiness->setNumberFixedTeams($form_values['no_of_fixed_teams']); $campaign_readiness->setNumberTransitPoints($form_values['no_of_transist_points']); $campaign_readiness->setAicTrained($form_values['aics_trained']); $campaign_readiness->setNumberTeamsTrained($form_values['no_of_teams_trained']); $campaign_readiness->setMobilePopulationAreas($form_values['area_mobile_population']); $created_by = $this->_em->find('Users', $this->_user_id); $campaign_readiness->setCreatedBy($created_by); $campaign_readiness->setCreatedDate(App_Tools_Time::now()); $campaign_readiness->setModifiedBy($created_by); $campaign_readiness->setModifiedDate(App_Tools_Time::now()); $this->_em->persist($campaign_readiness); $this->_em->flush(); $this->_redirect("campaign/manage-campaigns/campaign-readiness-uc"); }
public function addColdRoomAction() { $form_values = array(); $main_form_values = array(); $temp = array(); $arr_data = array('success' => $this->_request->success); $main_form = new Form_AddMain(); $form = new Form_AddColdRoom(); $cold_room = new Model_CcmColdRooms(); $action = 'add-cold-room'; $action_main = 'add'; if ($this->_request->isPost()) { // if ($form->isValid($this->_request->getPost()) && $main_form->isValid($this->_request->getPost())) { //$em = Zend_Registry::get('doctrine'); //$em->getConnection()->beginTransaction(); try { // $form_values = $form->getValues(); // $main_form_values = $main_form->getValues(); // $form_values = array_merge($form_values, $main_form_values); $form_values = $this->_request->getPost(); $cold_room->form_values = $form_values; //$cold_room->form_values['warehouse'] = $this->_request->warehouse; //$cold_room->form_values['reasons'] = $this->_request->reason; //$cold_room->form_values['utilizations'] = $this->_request->utilization; $cold_room->addColdRoom(); //$em->getConnection()->commit(); } catch (Exception $e) { // $em->getConnection()->rollback(); // $em->close(); App_FileLogger::info($e); } $this->redirect("/cold-chain/add-cold-room/success/1"); exit; // } } $id = $this->_request->getParam('id', ''); if (!empty($id)) { $arr = explode('|', App_Controller_Functions::decrypt($id)); $action = $arr[0]; $id = $arr[1]; $cold_chain = $this->_em->getRepository("ColdChain")->find($id); $form->ccm_id->setValue($id); $form->working_since->setValue($cold_chain->getWorkingSince()->format('Y-m-d H:i:s')); // $form->serial_number->setValue($cold_chain->getSerialNumber()); $main_form->asset_id->setValue($cold_chain->getAssetId()); $cold_room = $this->_em->getRepository("CcmColdRooms")->findBy(array('ccm' => $id)); // echo $cold_room['0']->getCcmAssetSubType()->getPkId(); $form->ccm_asset_sub_type_id->setValue($cold_room['0']->getCcmAssetSubType()->getPkId()); $ccm_model = $this->_em->getRepository("CcmModels")->find($cold_chain->getCcmModel()->getPkId()); $form->model_hidden->setValue($cold_chain->getCcmModel()->getPkId()); $form->asset_dimension_length->setValue($ccm_model->getAssetDimensionLength()); $form->asset_dimension_width->setValue($ccm_model->getAssetDimensionWidth()); $form->asset_dimension_height->setValue($ccm_model->getAssetDimensionHeight()); if ($cold_room['0']->getCcmAssetSubType()->getPkId() == 36) { $form->gross_capacity->setValue($ccm_model->getGrossCapacity4()); $form->net_capacity->setValue($ccm_model->getNetCapacity4()); } if ($cold_room['0']->getCcmAssetSubType()->getPkId() == 37) { $form->gross_capacity->setValue($ccm_model->getGrossCapacity20()); $form->net_capacity->setValue($ccm_model->getNetCapacity20()); } $form->cooling_system->setValue($cold_room['0']->getCoolingSystem()); //echo $cold_room['0']->getRefrigeratorGasType()->getPkId(); // exit; if ($cold_room['0']->getRefrigeratorGasType() != "") { $form->refrigerator_gas_type->setValue($cold_room['0']->getRefrigeratorGasType()->getPkId()); } if ($cold_room['0']->getBackupGenerator() != "") { $form->backup_generator->setValue($cold_room['0']->getBackupGenerator()->getPkId()); } if ($cold_room['0']->getTemperatureRecordingSystem() != "") { $form->temperature_recording_system->setValue($cold_room['0']->getTemperatureRecordingSystem()->getPkId()); } if ($cold_room['0']->getTypeRecordingSystem() != "") { $form->type_recording_system->setValue($cold_room['0']->getTypeRecordingSystem()->getPkId()); } $form->has_voltage->setValue($cold_room['0']->getHasVoltage()); $form->make->setValue($ccm_model->getCcmMake()->getPkId()); if ($cold_chain->getSource() != "") { $main_form->source_id->setValue($cold_chain->getSource()->getPkId()); } ////$model_id = $this->_em->getRepository('CcmModels')->find(); //$form->catalogue_id->setValue($cold_chain->getCcmModel()->getPkId()); //$form->campaign_name->setValue($campaign->getCampaignName()); $action = 'update-cold-room'; $action_main = 'update'; $base_url = Zend_Registry::get('baseurl'); $this->view->inlineScript()->appendFile($base_url . '/js/default/cold-chain/update-cold-room.js'); } $this->view->action = $action; $this->view->main_action = $action_main; $this->view->form = $form; $this->view->main_form = $main_form; $this->view->arr_data = $arr_data; $base_url = Zend_Registry::get('baseurl'); $this->view->inlineScript()->appendFile($base_url . '/js/all_level_combos.js'); $this->view->inlineScript()->appendFile($base_url . '/js/default/cold-chain/add-main.js'); }
public function updateGenerator() { //App_Controller_Functions::pr($this->form_values); $form_values = $this->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")))); $this->_em->persist($ccm_model); $this->_em->flush(); $cold_chain = $this->_em->getRepository('ColdChain')->find($form_values['ccm_id']); $cold_chain->setAssetId($form_values['asset_id']); $model_id = $this->_em->getRepository('CcmModels')->find($form_values['ccm_model_id']); $cold_chain->setCcmModel($model_id); $cold_chain->setSerialNumber($form_values['serial_number']); $asset_type = $this->_em->getRepository('CcmAssetTypes')->find(Model_CcmAssetTypes::GENERATOR); $cold_chain->setCcmAssetType($asset_type); $cold_chain->setWorkingSince(new \DateTime(App_Controller_Functions::dateToDbFormat($form_values['working_since']))); $cold_chain->setCreatedBy($user_id); $cold_chain->setCreatedDate(new \DateTime(App_Controller_Functions::dateToDbFormat(date("d/m/Y")))); $gen = $this->_em->getRepository('CcmGenerators')->findBy(array('ccm' => $form_values['ccm_id'])); $generators = $this->_em->getRepository('CcmGenerators')->find($gen[0]->getPkId()); $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']); $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(); }
public function updateTransport() { $form_values = $this->form_values; $user_id = $this->_em->getRepository('Users')->find($this->_user_id); $cold_chain = $this->_em->getRepository('ColdChain')->find($form_values['ccm_id']); $stakeholder = $this->_em->getRepository('Stakeholders')->find($form_values['source_id']); $cold_chain->setSource($stakeholder); $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']))); $cold_chain->setModifiedBy($user_id); $cold_chain->setModifiedDate(App_Tools_Time::now()); $this->_em->persist($cold_chain); $this->_em->flush(); $vechicles = $this->_em->getRepository('CcmVehicles')->findBy(array('ccm' => $form_values['ccm_id'])); $ccm_vehicles = $this->_em->getRepository('CcmVehicles')->find($vechicles[0]->getPkId()); $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->setModifiedBy($user_id); $ccm_vehicles->setModifiedDate(App_Tools_Time::now()); $this->_em->persist($ccm_vehicles); $this->_em->flush(); }
public function getDistinctIssueByVoucherNumber() { $str_sql = $this->_em->createQueryBuilder()->select("DISTINCT fa.voucherNumber, fa.pkId, warehouse.warehouseName,fa.referenceNumber, " . "fa.expectedArrivalDate, fa.quantity, SUM(fa.receivedQuantity) as receivedQuantity, fa.status")->from("PipelineConsignments", "fa")->join("fa.toWarehouse", 'warehouse')->andWhere("fa.fromWarehouse = " . $this->_identity->getWarehouseId()); if (!empty($this->form_values['from_date']) && !empty($this->form_values['to_date'])) { $str_sql->andWhere("DATE_FORMAT(fa.expectedArrivalDate,'%Y-%m-%d') BETWEEN '" . App_Controller_Functions::dateToDbFormat($this->form_values['from_date']) . "' AND '" . App_Controller_Functions::dateToDbFormat($this->form_values['to_date']) . "'"); } else { $date_from = date('Y-m' . '-01'); $date_to = date('Y-m-d'); $str_sql->andWhere("DATE_FORMAT(fa.expectedArrivalDate,'%Y-%m-%d') BETWEEN '" . $date_from . "' AND '" . $date_to . "'"); } if (!empty($this->form_values['item_pack_size_id'])) { $str_sql->andWhere("fa.itemPackSize = '" . $this->form_values['item_pack_size_id'] . "'"); } if (!empty($this->form_values['to_warehouse_id'])) { $str_sql->andWhere("fa.toWarehouse = '" . $this->form_values['to_warehouse_id'] . "'"); } if (!empty($this->form_values['status'])) { $str_sql->andWhere("fa.status = '" . $this->form_values['status'] . "'"); } else { $str_sql->andWhere("fa.status = 'Planned' "); } $str_sql->groupBy("fa.voucherNumber"); $str_sql->orderBy("fa.pkId", "DESC"); // echo $str_sql->getQuery()->getSql(); $row = $str_sql->getQuery()->getResult(); return $row; /* if (!empty($row) && count($row) > 0) { return $row; } else { return false; } */ }
public function ajaxAvailableIssueBatchQuantityAction() { $this->_helper->layout->disableLayout(); $stock_batch = new Model_StockBatch(); $stock_batch->form_values['pk_id'] = $this->_request->batch; $stock_batch->form_values['trans_date'] = App_Controller_Functions::dateToDbFormat($this->_request->tr_date); $batch_expiry = $stock_batch->getBatchAvailableBalanceExpiry(); $type = $this->_request->getParam('type', 0); if ($type === 'json') { $this->_helper->viewRenderer->setNoRender(TRUE); echo json_encode($batch_expiry); } else { $this->view->batch_expiry = $batch_expiry; } }
public function updateStockPlacement($data, $placement_type) { // batch_id|placement_loc_id|vvm_stage_id|qty, batch_id|placement_loc_id|vvm_stage_id|qty,batch_id|placement_loc_id|vvm_stage_id|qty $placement_info = explode(",", $data); App_Controller_Functions::pr($data); // Get each placement batch, location,vvm stage and qty. foreach ($placement_info as $info) { $ids = explode("|", $info); // batch_id|placement_loc_id|vvm_stage_id|qty // get stock batch $stock_batch = $this->_em->getRepository("StockBatchWarehouses")->find($ids['0']); // get placement location $placement_location = $this->_em->getRepository("PlacementLocations")->find($ids['1']); // Get transaction type i.e stock picking. $plc_transaction_type = $this->_em->find("ListDetail", $placement_type); // Get user id. $user_id = $this->_em->find("Users", $this->_user_id); $placement = new Placements(); $placement->setPlacementLocation($placement_location); $placement->setStockBatchWarehouse($stock_batch); $placement->setPlacementTransactionType($plc_transaction_type); $placement->setCreatedBy($user_id); $placement->setCreatedDate(App_Tools_Time::now()); $placement->setModifiedBy($user_id); $placement->setModifiedDate(App_Tools_Time::now()); $vvms = $this->_em->getRepository("VvmStages")->find($ids['2']); $placement->setVvmStage($vvms); // get qty if ($placement_type == Model_PlacementLocations::PLACEMENT_TRANSACTION_TYPE_P) { $qty = $ids['3']; } elseif ($placement_type == Model_PlacementLocations::PLACEMENT_TRANSACTION_TYPE_PICK) { $qty = -1 * $ids['3']; } $placement->setQuantity($qty); $this->_em->persist($placement); } $this->_em->flush(); return true; }
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 updateHfSessions($wh_id, $report_date, $fix_plan_sessions, $fix_actually_held_sessions, $outreach_plan_sessions, $outreach_actually_held_sessions) { $rep_date = explode('-', $report_date); $str_qry_hf = "SELECT hf_sessions.pk_id\n FROM\n hf_sessions\n where\n hf_sessions.warehouse_id ='" . $wh_id . "' \n and DATE_FORMAT(hf_sessions.reporting_start_date, '%Y-%m-%d') = '" . $report_date . "' "; $this->_em = Zend_Registry::get('doctrine'); $row_hf = $this->_em->getConnection()->prepare($str_qry_hf); $row_hf->execute(); $result_hf_edit = $row_hf->fetchAll(); $hf_session_id = $result_hf_edit[0]['pk_id']; if (!empty($hf_session_id)) { $hf_sessions = $this->_em->getRepository('HfSessions')->find($hf_session_id); } else { $hf_sessions = new HfSessions(); } $warehouse_status = $this->_em->getRepository('ListDetail')->find(Model_ListDetail::WAREHOUSE_STATUS_REPORTING); $hf_sessions->setWarehouseStatus($warehouse_status); $hf_sessions->setFixedPlannedSessions($fix_plan_sessions); $hf_sessions->setFixedActuallyHeldSessions($fix_actually_held_sessions); $hf_sessions->setOutreachPlannedSessions($outreach_plan_sessions); $hf_sessions->setOutreachActuallyHeldSessions($outreach_actually_held_sessions); $hf_sessions->setReportingStartDate(new \DateTime(App_Controller_Functions::dateToDbFormat($report_date))); $warehouse_id = $this->_em->getRepository('Warehouses')->find($wh_id); $hf_sessions->setWarehouse($warehouse_id); $user = $this->_em->getRepository('Users')->find($this->_user_id); $hf_sessions->setModifiedBy($user); $hf_sessions->setCreatedBy($user); $hf_sessions->setCreatedDate(App_Tools_Time::now()); $hf_sessions->setModifiedDate(App_Tools_Time::now()); $this->_em->persist($hf_sessions); $this->_em->flush(); }
public function activityLogSearch() { $wh_id = $this->_identity->getWarehouseId(); if (!empty($this->form_values['date_from']) && !empty($this->form_values['date_to'])) { $date_where = "and DATE_FORMAT(stock_master.created_date,'%Y-%m-%d') BETWEEN '" . App_Controller_Functions::dateToDbFormat($this->form_values['date_from']) . "' AND '" . App_Controller_Functions::dateToDbFormat($this->form_values['date_to']) . "'"; } else { $date_from = date('Y-m' . '-01'); $date_to = date('Y-m-d'); $date_where = "and DATE_FORMAT(stock_master.created_date,'%Y-%m-%d') BETWEEN '" . $date_from . "' AND '" . $date_to . "'"; } $querypro = "SELECT\n DISTINCT\n stock_master.pk_id,\n stock_master.transaction_date,\n stock_master.transaction_number,\n stock_master.transaction_type_id,\n stock_master.transaction_reference,\n ABS(stock_detail.quantity) as quantity,\n item_pack_sizes.item_name,\n stock_batch.number,\n item_units.item_unit_name,\n stock_batch.expiry_date,\n stock_master.created_date,\n from_warehouse.warehouse_name as from_warehouse_name,\n to_warehouse.warehouse_name as to_warehouse_name,\n stock_master.action_type,\n users.user_name\n FROM\n stock_master_history as stock_master\n INNER JOIN stock_detail_history as stock_detail ON stock_master.master_id = stock_detail.stock_master_id\n INNER JOIN stock_batch_warehouses ON stock_detail.stock_batch_warehouse_id = stock_batch_warehouses.pk_id\n INNER JOIN stock_batch ON stock_batch.pk_id = stock_batch_warehouses.stock_batch_id\n INNER JOIN pack_info ON stock_batch.pack_info_id = pack_info.pk_id\n INNER JOIN stakeholder_item_pack_sizes ON pack_info.stakeholder_item_pack_size_id = stakeholder_item_pack_sizes.pk_id\n INNER JOIN item_pack_sizes ON stakeholder_item_pack_sizes.item_pack_size_id = item_pack_sizes.pk_id\n INNER JOIN item_units ON item_pack_sizes.item_unit_id = item_units.pk_id\n INNER JOIN warehouses AS `from_warehouse` ON stock_master.from_warehouse_id = from_warehouse.pk_id\n INNER JOIN warehouses AS `to_warehouse` ON stock_master.to_warehouse_id = to_warehouse.pk_id\n INNER JOIN users ON stock_master.created_by = users.pk_id\n WHERE\n stock_master.draft = 0 AND\n stock_detail.temporary = 0 AND\n stock_batch_warehouses.warehouse_id = '{$wh_id}'\n {$date_where}\n ORDER BY transaction_type_id,transaction_date"; $this->_em = Zend_Registry::get('doctrine'); $row = $this->_em->getConnection()->prepare($querypro); $row->execute(); return $row->fetchAll(); }
public function multipleAdjustmentAction() { $stock_master = new Model_StockMaster(); $stock_batch = new Model_StockBatch(); $stock_detail = new Model_StockDetail(); $warehouse_data = new Model_WarehousesData(); $form = new Form_MultipleAdjustment(); $form_values = array(); $temp = array(); $arr_data = array('transaction_number' => "", 'stock_id' => "", 'transaction_date' => date("d/m/Y"), 'warehouse_name' => "", 'success' => $this->_request->success); $form_values['transaction_type_id'] = 2; $form_values['adjustment_type'] = 2; $stock_id = ""; $master_id = ""; if (!empty($this->_request->hdn_stock_id)) { $stock_id = $this->_request->hdn_stock_id; } if (!empty($this->_request->hdn_master_id)) { $master_id = $this->_request->hdn_master_id; } if (!empty($this->_request->warehouse)) { $warehouse_id = $this->_request->warehouse; } if ($this->_request->isPost()) { $em = Zend_Registry::get('doctrine'); $em->getConnection()->beginTransaction(); try { if (!empty($master_id)) { //Start update issue period $array = $this->_request->getParams(); $stock_master->updateStockPeriod($master_id, $array); //End update issue period $transaction_number = $stock_master->updateStockMasterTemp($master_id, $this->_request->comments); $stock_detail->updateStockDetailTemp($master_id); //Save Data in warehouse_data table $warehouse_data->addReport($master_id, 2); /* * Auto Receive for 6th level * $stock_master->autoReceiveData($master_id); */ $this->view->msg = 'Stock has been issued successfully. Your voucher number is '; $this->view->voucher = $transaction_number; $this->view->master_id = $master_id; $em->getConnection()->commit(); } elseif ($form->isValid($this->_request->getPost())) { $editissue = $this->_request->getPost('issueedit'); if ($editissue == "Yes") { $d_id = $this->_request->getPost('detailid'); $obj_stock_detail = $em->getRepository("StockDetail")->find($d_id); $old_batch_id = $obj_stock_detail->getStockBatch()->getPkId(); $data = $form->getValues(); $obj_stock_master = $obj_stock_detail->getStockMaster(); $master_update = false; $arr_date = explode("/", $data['transaction_date']); if (intval($arr_date[1]) . "-" . intval($arr_date[2]) != intval($obj_stock_detail->getStockMaster()->getTransactionDate()->format("m")) . "-" . intval($obj_stock_detail->getStockMaster()->getTransactionDate()->format("Y"))) { $trans = $stock_master->getTransactionNumber(2, $data['transaction_date']); $obj_stock_master->setTransactionNumber($trans['trans_no']); $obj_stock_master->setTransactionCounter($trans['id']); $master_update = true; } $obj_stock_master->setTransactionDate(new \DateTime(App_Controller_Functions::dateToDbFormat($data['transaction_date']))); if (!empty($warehouse_id)) { $to_wh = $em->getRepository("Warehouses")->find($warehouse_id); $obj_stock_master->setToWarehouse($to_wh); $master_update = true; } if ($master_update) { $em->persist($obj_stock_master); $em->flush(); } $qunty = str_replace(",", "", $data['quantity']); $obj_stock_detail->setQuantity("-" . $qunty); $vvms = $this->_em->getRepository("VvmStages")->find($data['vvm_stage']); $obj_stock_detail->setVvmStage($vvms); $stock_b = $em->getRepository("StockBatch")->find($data['number']); $obj_stock_detail->setStockBatch($stock_b); if (!empty($data['item_unit_id'])) { $item_unit = $em->getRepository("ItemUnits")->find($data['item_unit_id']); $obj_stock_detail->setItemUnit($item_unit); } $em->persist($obj_stock_detail); $em->flush(); list($dd, $mm, $yy) = explode("/", $data['transaction_date']); $item_id = $data['item_id']; $wh_id = $this->_identity->getWarehouseId(); $user_id = $this->_userid; $query = "SELECT AdjustQty(" . $data['number'] . "," . $wh_id . ") FROM DUAL"; $str_sql = $em->getConnection()->prepare($query); $str_sql->execute(); $query = "SELECT AdjustQty(" . $old_batch_id . "," . $wh_id . ") FROM DUAL"; $str_sql = $em->getConnection()->prepare($query); $str_sql->execute(); $query = "SELECT REPUpdateData({$mm},{$yy},{$item_id},{$wh_id},{$user_id}) FROM DUAL"; $str_sql = $em->getConnection()->prepare($query); $str_sql->execute(); } else { $temp = $form->getValues(); $data = array_merge($temp, $form_values); $data['warehouse'] = $warehouse_id; if (empty($this->_request->transaction_number)) { $stock_id = $stock_master->addStockMaster($data); } if (isset($data['quantity']) && !empty($data['quantity'])) { $qty = str_replace(",", "", $data['quantity']); } if (isset($data['available_quantity']) && !empty($data['available_quantity'])) { $ava_qty = str_replace(",", "", $data['available_quantity']); } if ((int) $qty > (int) $ava_qty || (int) $qty == (int) $ava_qty) { $data['quantity'] = $ava_qty; $autorun = true; } list($batch_id, $priority) = explode("|", $this->_request->number); $form_values['item_unit_id'] = $this->_request->item_unit_id; $form_values['stock_master_id'] = $stock_id; $form_values['stock_batch_id'] = $batch_id; $data = array_merge($temp, $form_values); $detail_id = $stock_detail->addStockDetail($data); $stock_batch->adjustQuantityByWarehouse($batch_id); if ($autorun == true) { $stock_batch->autoRunningLEFOBatch($form->getValue('item_id')); $stock_batch->form_values['pk_id'] = $batch_id; $stock_batch->form_values['status'] = Model_StockBatch::FINISHED; $stock_batch->changeStatus(); } /* $placement = new Model_Placements(); $placement->form_values['stock_batch_id'] = $batch_id; $placement->form_values['quantity'] = $data['quantity']; $placement->form_values['placement_location_id'] = $data['pick_from']; $placement->form_values['stock_detail_id'] = $detail_id; $placement->addPlacement(); */ } $em->getConnection()->commit(); $this->redirect("/stock/multiple-adjustment"); // For Data Show $temp_stock_list = $stock_master->getTempStocksList(); if ($temp_stock_list != false) { // $form->transaction_number->setValue($temp_stock_list[0]['transaction_number']); $form->transaction_date->setValue(date("d/m/Y h:i A", strtotime($temp_stock_list[0]['transaction_date']))); $form->warehouse_name->setValue($temp_stock_list[0]['to_warehouse']); $form->transaction_reference->setValue($temp_stock_list[0]['transaction_reference']); $form->hdn_to_warehouse_id->setValue($temp_stock_list[0]['to_warehouse_id']); $form->product->setValue($temp_stock_list[0]['to_warehouse_id']); $arr_data['warehouse_name'] = $temp_stock_list[0]['to_warehouse']; // $arr_data['warehouse_name'] = $temp_stock_list[0]['to_warehouse']; $form->activity_id->setValue($temp_stock_list[0]['activity_id']); $arr_data['tempstocks'] = $temp_stock_list; $form->makeFieldReadonly(); } else { $form->transaction_date->setValue(date("d/m/Y h:i A")); } } } catch (Exception $e) { $em->getConnection()->rollback(); $em->close(); App_FileLogger::info($e); switch ($e->getMessage()) { case 'PLCD_QTY_GREATER_THAN_ISSUE_QTY': $this->view->status = false; $this->view->msg = "Issue quantity should not greater than placed quantity!"; break; } } $this->view->form = $form; $this->view->arr_data = $arr_data; if ($this->_request->type == 's') { $this->redirect("/stock/issue-search"); } } $stock_master->form_values = $form_values; $temp_stock = $stock_master->getTempStock(); if ($temp_stock != false) { $arr_data = array_merge($arr_data, $temp_stock); } if (!empty($temp_stock['stock_id'])) { $form->hdn_stock_id->setValue($temp_stock['stock_id']); $form->hdn_master_id->setValue($temp_stock['stock_id']); } elseif (!empty($stockid)) { $form->hdn_stock_id->setValue($stock_id); $form->hdn_master_id->setValue($stock_id); } $this->view->form = $form; $base_url = Zend_Registry::get('baseurl'); switch ($this->_user_level) { case 1: case 2: case 3: $this->view->menu_type = 1; $this->view->inlineScript()->appendFile($base_url . '/js/all_level_combos.js'); break; case 4: case 5: case 6: $this->view->menu_type = 2; $this->view->inlineScript()->appendFile($base_url . '/js/level_combos.js'); break; } // Edit Issue Start if (!empty($this->_request->id)) { $detail_id = $this->_request->id; $issue = $this->_em->getRepository("StockDetail")->find($detail_id); $form->transaction_number->setValue($issue->getStockMaster()->getTransactionNumber()); $form->transaction_date->setValue($issue->getStockMaster()->getTransactionDate()->format("d/m/Y h:i A")); $form->warehouse_name->setValue($issue->getStockMaster()->getToWarehouse()->getWarehouseName()); $form->transaction_reference->setValue($issue->getStockMaster()->getTransactionReference()); //$form->activity_id->setValue($issue->getStockMaster()->getStakeholderActivity()->getPkId()); $arr_data['warehouse_name'] = $issue->getStockMaster()->getToWarehouse()->getWarehouseName(); $form->item_id->setValue($issue->getStockBatch()->getItemPackSize()->getPkId()); $form->fillBatchCombo($issue->getStockBatch()->getItemPackSize()->getPkId()); $form->number->setValue($issue->getStockBatch()->getPkId()); $form->vvm_stage->setValue($issue->getVvmStage()); $form->quantity->setValue($issue->getQuantity()); $av_qty = $issue->getStockBatch()->getQuantity() + ABS($issue->getQuantity()); $form->available_quantity->setValue($av_qty); $form->expiry_date->setValue($issue->getStockBatch()->getExpiryDate()->format("d/m/Y")); $this->view->issueedit = true; $this->view->detail_id = $this->_request->id; } // Edit Issue End $this->view->arr_data = $arr_data; $this->view->type = $this->_request->getParam("t", "issue"); $this->view->wh_id = $this->_identity->getWarehouseId(); $this->view->params = array("province" => $this->_identity->getProvinceId(), "district" => $this->_identity->getDistrictId()); $this->view->role = $this->_identity->getRoleId(); }
/** * Initializes the application with global standards for the view * * @access public * @return void */ public function init() { //$seconds = 60 * 60 * 24 * 1; // 1 day //Zend_Session::RememberMe($seconds); $appName = Zend_Registry::get('appName'); $moduleName = $this->getRequest()->getModuleName(); $controllerName = $this->getRequest()->getControllerName(); $actionName = $this->getRequest()->getActionName(); $controller = $this->getActionController(); $view = new Zend_View(); $auth = App_Auth::getInstance(); if ($auth->hasIdentity()) { $identity = $auth->getIdentity(); Zend_Layout::getMvcInstance()->assign('user_name', $auth->getUserName()); } if ($auth->hasIdentity()) { $identity = $auth->getIdentity(); Zend_Layout::getMvcInstance()->assign('user_role', $auth->getRoleId()); } /* if ($auth->hasIdentity()) { $identity = $auth->getIdentity(); if ($identity->role_id == 2 && $controllerName != 'accounts' && $controllerName != 'error' && $controllerName != 'index') { $accounts = new Application_Model_Accounts(); $select = $accounts->select()->where("user_id=" . $identity->id); $result = $accounts->fetchRow($select); if (count($result) == 0) { $this->getResponse()->setRedirect('/accounts/create'); } } } */ /* if ($_SERVER['REQUEST_URI'] == '/index/login' || $_SERVER['REQUEST_URI'] == '/index/login/') { $this->getResponse()->setRedirect('/login'); } */ $baseUrl = Zend_Registry::get('baseurl'); //echo $_SERVER['REQUEST_URI']; if ($controllerName != 'index' && $moduleName != 'api' && $controllerName != 'error' && !$auth->hasIdentity()) { $this->getResponse()->setRedirect($baseUrl . '/index?referrer=' . base64_encode(str_replace("/vlmisr2/", "", $_SERVER['REQUEST_URI']))); } if ($moduleName == 'cadmin' && !$auth->hasIdentity()) { $this->getResponse()->setRedirect($baseUrl . '/index?referrer=' . base64_encode(str_replace("/vlmisr2/", "", $_SERVER['REQUEST_URI']))); } if ($moduleName == 'iadmin' && !$auth->hasIdentity()) { $this->getResponse()->setRedirect($baseUrl . '/index?referrer=' . base64_encode(str_replace("/vlmisr2/", "", $_SERVER['REQUEST_URI']))); } if ($moduleName == 'campaign' && !$auth->hasIdentity()) { $this->getResponse()->setRedirect($baseUrl . '/campaign/manage-campaigns?referrer=' . base64_encode(str_replace("/vlmisr2/", "", $_SERVER['REQUEST_URI']))); } //$view->headScript()->appendFile($baseUrl . '/js/braintree.js'); //$view->headLink()->appendStylesheet($baseUrl . '/css/main.css'); Zend_Registry::set('controller', $controllerName); Zend_Registry::set('action', $actionName); //Get the scripts and css directories $scripts = empty($moduleName) ? new App_Directory('js/' . $controllerName) : new App_Directory('js/' . $moduleName . '/' . $controllerName); $css = empty($moduleName) ? new App_Directory('css/' . $controllerName) : new App_Directory('css/' . $moduleName . '/' . $controllerName); //Append the scripts (if any) that pertain to this action and controller if ($scripts->exists()) { $scripts = $scripts->getFiles(); foreach ($scripts as $script) { if ($script === $actionName . ".js") { if (empty($moduleName)) { $view->inlineScript()->appendFile($baseUrl . '/js/' . $controllerName . '/' . $script); } else { $view->inlineScript()->appendFile($baseUrl . '/js/' . $moduleName . '/' . $controllerName . '/' . $script); } } } } //Append the stylesheets (if any) that pertain to this action and controller if ($css->exists()) { $css = $css->getFiles(); foreach ($css as $stylesheet) { if ($stylesheet === $actionName . ".css") { if (empty($moduleName)) { $view->headLink()->appendStylesheet($baseUrl . '/css/' . $controllerName . '/' . $stylesheet); } else { $view->headLink()->appendStylesheet($baseUrl . '/css/' . $moduleName . '/' . $controllerName . '/' . $stylesheet); } } } } $appName = Zend_Registry::get('appName'); $view->inlineScript()->prependScript('var appName = "' . $appName . '"'); $view->prefix = $this->getRequest()->isXmlHttpRequest() || $this->getRequest()->getParam('ajax') == 'true' ? 'ajax' : 'page'; $view->action = $actionName; $view->controller = $controllerName; if ($moduleName == 'default') { Zend_Registry::set('resource', $controllerName . "/" . $actionName); } else { Zend_Registry::set('resource', $moduleName . "/" . $controllerName . "/" . $actionName); } $arr_data = App_Controller_Functions::getPageTitleAndMeta(Zend_Registry::get('resource')); Zend_Registry::set('pageTitle', $arr_data['pageTitle']); Zend_Registry::set('metaTitle', $arr_data['metaTitle']); Zend_Registry::set('metaDescription', $arr_data['metaDescription']); }
public function searchColdRooms() { if (!empty($this->form_values['ccm_asset_sub_type_id'])) { $where[] = "ccr.ccmAssetSubType = '" . $this->form_values['ccm_asset_sub_type_id'] . "'"; } if (!empty($this->form_values['ccm_asset_sub_type_id']) && $this->form_values['ccm_asset_sub_type_id'] == Model_CcmAssetTypes::SUBCOLDROOM && !empty($this->form_values['capacity_from']) && !empty($this->form_values['capacity_to'])) { $where[] = "ccm.grossCapacity4 Between '" . $this->form_values['capacity_from'] . "' AND '" . $this->form_values['capacity_to'] . "'"; } if (!empty($this->form_values['ccm_asset_sub_type_id']) && $this->form_values['ccm_asset_sub_type_id'] == Model_CcmAssetTypes::SUBFREEZERROOM && !empty($this->form_values['capacity_from']) && !empty($this->form_values['capacity_to'])) { $where[] = "ccm.grossCapacity20 Between '" . $this->form_values['capacity_from'] . "' AND '" . $this->form_values['capacity_to'] . "'"; } //Working status if (!empty($this->form_values['ccm_status_list_id'])) { $where[] = "csh.ccmStatusList = '" . $this->form_values['ccm_status_list_id'] . "'"; } //Source of Supply if (!empty($this->form_values['source_id'])) { $where[] = "cc.source = '" . $this->form_values['source_id'] . "'"; } // Number of Cooling System if (!empty($this->form_values['cooling_system'])) { $where[] = "ccr.coolingSystem = '" . $this->form_values['cooling_system'] . "'"; } //Asset Equipment Id if (!empty($this->form_values['asset_id'])) { $where[] = "cc.assetId = '" . $this->form_values['asset_id'] . "'"; } // year of supply from and to if (!empty($this->form_values['working_since_from']) && !empty($this->form_values['working_since_to'])) { $where[] = "cc.workingSince Between '" . App_Controller_Functions::dateToDbFormat($this->form_values['working_since_from']) . "' AND '" . App_Controller_Functions::dateToDbFormat($this->form_values['working_since_to']) . "' "; } if (!empty($this->form_values['make'])) { $where[] = "ccmake.pkId = '" . $this->form_values['make'] . "'"; } if (!empty($this->form_values['ccm_model_id'])) { $where[] = "ccm.pkId = '" . $this->form_values['ccm_model_id'] . "'"; } if ($this->form_values['placed_at'] == 1 && !empty($this->form_values['warehouse'])) { $where[] = "w.pkId = '" . $this->form_values['warehouse'] . "'"; } if ($this->form_values['placed_at'] == 0) { $where[] = "w.pkId IS NULL "; } // $where[] = "cp.pkId = '" . Model_CcmAssetTypes::COLDROOM . "' "; // $where[] = "cc.createdBy = '" . $this->_user_id . "' "; if (is_array($where)) { $where_s = implode(" AND ", $where); } $str_sql = $this->_em->createQueryBuilder()->select("cc.pkId,cc.assetId,cat.assetTypeName,ccm.ccmModelName,ccmake.ccmMakeName," . "cc.createdDate,csl.ccmStatusListName,w.warehouseName," . "d.locationName,ccm.grossCapacity20")->from('CcmColdRooms', 'ccr')->join('ccr.ccm', 'cc')->join('cc.ccmModel', 'ccm')->leftjoin('cc.ccmAssetType', 'cat')->leftjoin('cat.parent', 'cp')->leftjoin('cc.ccmStatusHistory', 'csh')->leftjoin('csh.ccmStatusList', 'csl')->leftjoin('ccm.ccmMake', 'ccmake'); if ($this->form_values['placed_at'] == 1) { $str_sql->join('cc.warehouse', 'w'); $str_sql->join('w.district', 'd'); } if ($this->form_values['placed_at'] == 0) { $str_sql->leftjoin('cc.warehouse', 'w'); $str_sql->leftjoin('w.district', 'd'); } $str_sql->where($where_s); // echo $str_sql->getQuery()->getSql(); $row = $str_sql->getQuery()->getResult(); if (!empty($row) && count($row) > 0) { return $row; } else { return false; } }
public function getLogBook() { if (!empty($this->form_values['entry_type'])) { if ($this->form_values['entry_type'] == "1") { // My Entries $where[] = "log_book.created_by = '" . $this->_user_id . "'"; } if ($this->form_values['entry_type'] == "2") { // Referrals $where[] = "log_book.created_by <> '" . $this->_user_id . "'"; } } else { // Default is My Entries $where[] = "log_book.created_by = '" . $this->_user_id . "'"; } if (!empty($this->form_values['district'])) { $where[] = "log_book.district_id = '" . $this->form_values['district'] . "'"; } else { $where[] = "log_book.district_id = 0"; } if (!empty($this->form_values['tehsil'])) { $where[] = "Uc.parent_id = '" . $this->form_values['tehsil'] . "'"; } if (!empty($this->form_values['uc'])) { $where[] = "log_book.union_council_id = '" . $this->form_values['uc'] . "'"; } if (!empty($this->form_values['vaccination_date_from']) && !empty($this->form_values['vaccination_date_to'])) { $where[] = "DATE_FORMAT(log_book.vaccination_date,'%Y-%m-%d') BETWEEN '" . App_Controller_Functions::dateToDbFormat($this->form_values['vaccination_date_from']) . "' AND '" . App_Controller_Functions::dateToDbFormat($this->form_values['vaccination_date_to']) . "' "; } else { $date_from = date('Y-m' . '-01'); $date_to = date('Y-m-d'); $where[] = "DATE_FORMAT(log_book.vaccination_date,'%Y-%m-%d') BETWEEN '" . $date_from . "' AND '" . $date_to . "'"; } if (is_array($where)) { $where_s = implode(" AND ", $where); } $str_qry = "SELECT\n log_book.union_council_id,\n Uc.location_name AS Uc,\n log_book.pk_id,\n log_book.`name`,\n log_book.father_name,\n log_book.gender,\n log_book.age,\n log_book.contact,\n log_book.address,\n log_book.district_id,\n log_book.vaccination_date,\n log_book.refer_to_warehouse_id,\n log_book.remarks,\n log_book.warehouse_id,\n log_book.created_by,\n log_book.created_date,\n log_book.modified_date,\n log_book.reporting_start_date,\n District.location_name AS District,\n Tehsil.location_name AS Tehsil,\n warehouses.warehouse_name AS RefFromEPI,\n ref_from_uc.location_name AS RefFromUc,\n ref_from_dist.location_name AS RefFromDist\n FROM\n log_book\n LEFT JOIN locations AS Uc ON Uc.pk_id = log_book.union_council_id\n INNER JOIN locations AS District ON log_book.district_id = District.pk_id\n INNER JOIN locations AS Tehsil ON Uc.parent_id = Tehsil.pk_id\n INNER JOIN warehouses ON log_book.warehouse_id = warehouses.pk_id\n INNER JOIN locations AS ref_from_uc ON ref_from_uc.pk_id = warehouses.location_id\n INNER JOIN locations AS ref_from_dist ON ref_from_dist.pk_id = warehouses.district_id WHERE \n " . "{$where_s}"; $this->_em = Zend_Registry::get('doctrine'); $row = $row = $this->_em->getConnection()->prepare($str_qry); $row->execute(); return $row->fetchAll(); }
public function getAllIssueRunningBatches() { $batch_no = implode(",", $this->form_values['batch_no']); $str_sql = $this->_em->createQueryBuilder()->select("sb.number,\n\t\t\tsbw.pkId,\n\t\t\tsb.expiryDate,\n\t\t\tsbw.quantity")->from("StockBatchWarehouses", "sbw")->join("sbw.stockBatch", "sb")->join("sb.packInfo", "pi")->join("pi.stakeholderItemPackSize", "sip")->where("sbw.quantity > 0 ")->andWhere("sip.itemPackSize = " . $this->form_values['item_pack_size_id']); if (!empty($this->form_values['transaction_date'])) { $str_sql->andWhere("sb.expiryDate >= '" . App_Controller_Functions::dateToDbFormat($this->form_values['transaction_date']) . "' "); } if (!empty($batch_no)) { $str_sql->andWhere("sbw.pkId NOT IN ({$batch_no})"); } $str_sql->andWhere("sbw.warehouse = " . $this->_identity->getWarehouseId())->orderBy("sbw.quantity", "DESC"); // echo $str_sql->getQuery()->getSql(); // exit; $row = $str_sql->getQuery()->getResult(); if (!empty($row) && count($row) > 0) { return $row; } else { return false; } }