public function init()
{
//Generate WareHouses Combo
$warehouse = new Model_Warehouses();
$result1 = $warehouse->getSupplierWarehouses();
foreach ($result1 as $wh) {
$this->_list["from_warehouse_id"][$wh['pk_id']] = $wh['warehouse_name'];
}
//Generate Item Combo
$item_pack_size = new Model_ItemPackSizes();
$result = $item_pack_size->getItemsAll();
$this->_childlist["item_pack_size_id"][''] = "Select";
if ($result) {
$item_id = $result[0]->getPkId();
foreach ($result as $row) {
$this->_childlist["item_pack_size_id"][$row->getPkId()] = $row->getItemName();
}
}
//Generate VVM Type Combo
$vvmtypes = new Model_VvmTypes();
$result3 = $vvmtypes->getAll();
$this->_childlist["vvm_type_id"][''] = 'Select';
foreach ($result3 as $vvmtype) {
$this->_childlist["vvm_type_id"][$vvmtype['pk_id']] = $vvmtype['vvm_type_name'];
}
//Generate Purpose(activity_id) combo
$stk_activities = new Model_StakeholderActivities();
$result4 = $stk_activities->getAllStakeholderActivitiesIssues();
if ($result4) {
$stakeholder_id = $result4[0]['pkId'];
foreach ($result4 as $stk_activity) {
$this->_list["stakeholder_activity_id"][$stk_activity['pkId']] = $stk_activity['activity'];
}
}
foreach ($this->_fields as $col => $name) {
switch ($col) {
case "reference_number":
case "description":
$this->addElement("text", $col, array("attribs" => array("class" => "form-control"), "allowEmpty" => false, "filters" => array("StringTrim", "StripTags"), "validators" => array()));
$this->getElement($col)->removeDecorator("Label")->removeDecorator("HtmlTag");
break;
case "expected_arrival_date":
$this->addElement("text", $col, array("attribs" => array("class" => "form-control", 'readonly' => 'true'), "allowEmpty" => false, "filters" => array("StringTrim", "StripTags"), "validators" => array()));
$this->getElement($col)->removeDecorator("Label")->removeDecorator("HtmlTag");
break;
case "transaction_number":
$this->addElement("text", $col, array("attribs" => array("class" => "form-control", 'readonly' => 'true'), "allowEmpty" => false, "filters" => array("StringTrim", "StripTags"), "validators" => array()));
$this->getElement($col)->removeDecorator("Label")->removeDecorator("HtmlTag");
break;
default:
break;
}
if (in_array($col, array_keys($this->_list))) {
$this->addElement("select", $col, array("attribs" => array("class" => "form-control"), "filters" => array("StringTrim", "StripTags"), "allowEmpty" => true, "required" => false, "registerInArrayValidator" => false, "multiOptions" => $this->_list[$col], "validators" => array(array("validator" => "Float", "breakChainOnFailure" => false, "options" => array("messages" => array("notFloat" => $name . " must be a valid option"))))));
$this->getElement($col)->removeDecorator("Label")->removeDecorator("HtmlTag");
}
}
}
/**
* @name $getWarehousesByLevel
* @param int $level
*
* This service will return warehouses by level
*
* @author Ajmal Hussain <*****@*****.**>
*/
public function getWarehousesByLevelAction()
{
$level = $this->_request->getParam('level', '');
if (!empty($level)) {
$wh = new Model_Warehouses();
$result = $wh->getWarehousesByLevel($level);
} else {
$result = array("error" => "Please provide level param. e.g. (?level=2)");
}
echo Zend_Json::encode($result);
}
public function init()
{
//Generate Products(items) Combo
$item_pack_sizes = new Model_ItemPackSizes();
$result2 = $item_pack_sizes->getAllItems();
$this->_list["product"][''] = "Select";
foreach ($result2 as $item) {
$this->_list["product"][$item['pkId']] = $item['itemName'];
}
$warehouses = new Model_Warehouses();
$result3 = $warehouses->getUserReceiveFromWarehouse();
foreach ($result3 as $whs) {
$this->_list["warehouses"][''] = "Select";
$this->_list["warehouses"][$whs['pkId']] = $whs['warehouseName'];
}
$date_from = date('01/m/Y');
$date_to = date('d/m/Y');
foreach ($this->_fields as $col => $name) {
switch ($col) {
case "number":
$this->addElement("text", $col, array("attribs" => array("class" => "form-control"), "allowEmpty" => false, "filters" => array("StringTrim", "StripTags"), "validators" => array()));
$this->getElement($col)->removeDecorator("Label")->removeDecorator("HtmlTag");
break;
case "date_from":
$this->addElement("text", $col, array("attribs" => array("class" => "form-control", 'readonly' => 'true'), "allowEmpty" => false, "filters" => array("StringTrim", "StripTags"), "validators" => array(), "value" => $date_from));
$this->getElement($col)->removeDecorator("Label")->removeDecorator("HtmlTag");
break;
case "date_to":
$this->addElement("text", $col, array("attribs" => array("class" => "form-control", 'readonly' => 'true'), "allowEmpty" => false, "filters" => array("StringTrim", "StripTags"), "validators" => array(), "value" => $date_to));
$this->getElement($col)->removeDecorator("Label")->removeDecorator("HtmlTag");
break;
default:
break;
}
if (in_array($col, array_keys($this->_list))) {
$this->addElement("select", $col, array("attribs" => array("class" => "form-control"), "filters" => array("StringTrim", "StripTags"), "allowEmpty" => true, "required" => false, "registerInArrayValidator" => false, "multiOptions" => $this->_list[$col]));
$this->getElement($col)->removeDecorator("Label")->removeDecorator("HtmlTag");
}
//Generate Purpose(activity_id) combo
$stk_activities = new Model_StakeholderActivities();
$result4 = $stk_activities->getAllStakeholderActivitiesIssues();
if ($result4) {
$stakeholder_id = $result4[0]['pkId'];
foreach ($result4 as $stk_activity) {
$this->_list["activity_id"][''] = "Select";
$this->_list["activity_id"][$stk_activity['pkId']] = $stk_activity['activity'];
}
}
}
}
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 init()
{
//Generate WareHouses Combo
$warehouse = new Model_Warehouses();
$result1 = $warehouse->getSupplierWarehouses();
$this->_list["from_warehouse_id"][""] = 'Select';
foreach ($result1 as $wh) {
$this->_list["from_warehouse_id"][$wh['pk_id']] = $wh['warehouse_name'];
}
//Generate Item Combo
$item_pack_size = new Model_ItemPackSizes();
$result = $item_pack_size->getItemsAll();
$this->_list["item_pack_size_id"][''] = "Select";
if ($result) {
$item_id = $result[0]->getPkId();
foreach ($result as $row) {
$this->_list["item_pack_size_id"][$row->getPkId()] = $row->getItemName();
}
}
$from_date = date('01/m/Y');
$to_date = date('d/m/Y');
foreach ($this->_fields as $col => $name) {
switch ($col) {
case "from_date":
$this->addElement("text", $col, array("attribs" => array("class" => "form-control", 'readonly' => 'true'), "allowEmpty" => false, "filters" => array("StringTrim", "StripTags"), "validators" => array(), "value" => $from_date));
$this->getElement($col)->removeDecorator("Label")->removeDecorator("HtmlTag");
break;
case "to_date":
$this->addElement("text", $col, array("attribs" => array("class" => "form-control", 'readonly' => 'true'), "allowEmpty" => false, "filters" => array("StringTrim", "StripTags"), "validators" => array(), "value" => $to_date));
$this->getElement($col)->removeDecorator("Label")->removeDecorator("HtmlTag");
break;
default:
break;
}
if (in_array($col, array_keys($this->_list))) {
$this->addElement("select", $col, array("attribs" => array("class" => "form-control"), "filters" => array("StringTrim", "StripTags"), "allowEmpty" => true, "required" => false, "registerInArrayValidator" => false, "multiOptions" => $this->_list[$col], "validators" => array(array("validator" => "Float", "breakChainOnFailure" => false, "options" => array("messages" => array("notFloat" => $name . " must be a valid option"))))));
$this->getElement($col)->removeDecorator("Label")->removeDecorator("HtmlTag");
}
}
}
public function targetIssuancePrintAction()
{
$this->_helper->layout->setLayout("print");
$this->view->headTitle("Vaccine Balance");
//$res = $this->_request->getPost();
$stock_master = new Model_StockMaster();
$stock_master->form_values['month'] = $this->_request->m;
$stock_master->form_values['year'] = $this->_request->y;
$stock_master->form_values['warehouse_id'] = $this->_request->w;
$result = $stock_master->targetIssuanceSearch();
$warehouses = new Model_Warehouses();
$issue_warehouse_name = $warehouses->getWarehouseNameByWarehouseId($this->_request->w);
$this->view->i_warehousename = $issue_warehouse_name;
$this->view->m = $this->_request->m;
$this->view->y = $this->_request->y;
// Logged in Warehouse
$this->view->warehousename = $this->_identity->getWarehouseName();
$this->view->result = $result;
}
public function init()
{
//Generate Provinces Combo
$locations = new Model_Locations();
$provinces = $locations->getAllProvinces();
$this->_list["combo1"][''] = "Select";
$this->_list["combo1_add"][''] = "Select";
if ($provinces) {
foreach ($provinces as $row) {
$this->_list["combo1"][$row['pkId']] = $row['locationName'];
$this->_list["combo1_add"][$row['pkId']] = $row['locationName'];
}
}
$this->_list["combo2_add"][''] = "Select Province";
$this->_list["combo2"][''] = "Select Province";
//Generate Facility Type Combo
$warehouse = new Model_Warehouses();
$warehouse->form_values['stakeholder_id'] = 1;
$wh_types = $warehouse->getAllHealthFacilityTypesByStakeholder();
$this->_list["facility_type"][''] = "Select";
if ($wh_types) {
foreach ($wh_types as $row) {
$this->_list["facility_type"][$row['pkId']] = $row['warehouseTypeName'];
}
}
$this->_list["year"][''] = "Select";
$yy = date('Y');
$end_year = 2014;
for ($i = $yy; $i >= $end_year; $i = $i - 1) {
$this->_list["year"][$i] = $i;
}
$campaign = new Model_Campaigns();
$result1 = $campaign->allCampaigns();
$this->_list["campaign_id"][''] = 'Select';
foreach ($result1 as $row) {
$this->_list["campaign_id"][$row['pkId']] = $row['campaignName'];
}
foreach ($this->_fields as $col => $name) {
switch ($col) {
/* case "abc":
$this->addElement("text", $col, array(
"attribs" => array("class" => "form-control"),
"allowEmpty" => true,
"filters" => array("StringTrim", "StripTags"),
"validators" => array()
));
$this->getElement($col)->removeDecorator("Label")->removeDecorator("HtmlTag");
break; */
default:
break;
}
if (in_array($col, array_keys($this->_list))) {
$this->addElement("select", $col, array("attribs" => array("class" => "form-control"), "filters" => array("StringTrim", "StripTags"), "allowEmpty" => true, "required" => false, "registerInArrayValidator" => false, "multiOptions" => $this->_list[$col], "validators" => array(array("validator" => "Float", "breakChainOnFailure" => false, "options" => array("messages" => array("notFloat" => $name . " must be a valid option"))))));
$this->getElement($col)->removeDecorator("Label")->removeDecorator("HtmlTag");
}
}
foreach ($this->_hidden as $col => $name) {
switch ($col) {
case "district_id_hidden":
$this->addElement("hidden", $col);
$this->getElement($col)->removeDecorator("Label")->removeDecorator("HtmlTag");
break;
default:
break;
}
}
}
public function levelCombosFourAction()
{
$this->_helper->layout->disableLayout();
if (isset($this->_request->combo3) && !empty($this->_request->combo3)) {
$tehsil_id = $this->_request->combo3;
$warehouse = new Model_Warehouses();
$warehouse->form_values = array('parent_id' => $tehsil_id, 'geo_level_id' => 6);
//$this->view->result = $location->getLocationsByLevelByTehsil();
$this->view->result = $warehouse->getUCWarehousesofTehsil();
}
}
public function init()
{
//Generate WareHouses Combo
$warehouse = new Model_Warehouses();
$result1 = $warehouse->getSupplierWarehouses();
foreach ($result1 as $wh) {
$this->_list["from_warehouse_id"][$wh['pk_id']] = $wh['warehouse_name'];
}
//Generate Purpose(activity_id) combo
$stk_activities = new Model_StakeholderActivities();
$result4 = $stk_activities->getAllStakeholderActivitiesIssues();
if ($result4) {
$stakeholder_id = $result4[0]['pkId'];
foreach ($result4 as $stk_activity) {
$this->_list["activity_id"][$stk_activity['pkId']] = $stk_activity['activity'];
}
}
// Generate Status Combo
$this->_list["status"]['Received'] = 'Received';
$this->_list["status"]['Pre Shipment Alert'] = 'Pre Shipment Alert';
$this->_list["status"]['PO'] = 'PO';
$this->_list["status"]['Tender'] = 'Tender';
//Generate Products(items) Combo
$sips = new Model_StakeholderItemPackSizes();
$sips->form_values['stakeholder_id'] = $stakeholder_id;
$result2 = $sips->getAllProductsByStakeholderType();
$this->_list["item_id"][""] = "Select";
if ($result2) {
//$item_id = $result2[0]['item_pack_size_id'];
foreach ($result2 as $item) {
$this->_list["item_id"][$item['item_pack_size_id']] = $item['item_name'];
}
}
$this->_list["vvm_stage"][""] = "NA";
$this->_list["manufacturer_id"][""] = "Select";
//Generate manufacturer Combo
/* $stakeholder_items = new Model_Stakeholders();
$stakeholder_items->form_values['item_id'] = $item_id;
$associated = $stakeholder_items->getManufacturerByProduct();
if ($associated) {
foreach ($associated as $row) {
$this->_list["manufacturer_id"][$row['pkId']] = $row['stakeholderName'];
}
} */
//Generate VVM Type Combo
$vvmtypes = new Model_VvmTypes();
$result3 = $vvmtypes->getAll();
$this->_list["vvm_type_id"][''] = 'Select';
foreach ($result3 as $vvmtype) {
$this->_list["vvm_type_id"][$vvmtype['pk_id']] = $vvmtype['vvm_type_name'];
}
//Generate Asset Sub Type Combo
$cold_chain = new Model_ColdChain();
$cold_chain->form_values = array('type_id' => '1,3');
$result3 = $cold_chain->getColdchainByAssetType();
$this->_list["cold_chain"][''] = "Select Cold Chain";
foreach ($result3 as $assetsubtype) {
$this->_list["cold_chain"][$assetsubtype['pk_id']] = $assetsubtype['asset_name'] . " - " . $assetsubtype['make_name'];
}
//Generate Campaigns Combo
/*
$campaigns = new Model_Campaigns();
$result4 = $campaigns->allCampaignsFutureDate();
$this->_list["campaign_id"][''] = "Select";
foreach ($result4 as $campaign_one) {
$this->_list["campaign_id"][$campaign_one['pkId']] = $campaign_one['campaignName'];
} */
foreach ($this->_fields as $col => $name) {
switch ($col) {
case "transaction_reference":
case "number":
case "unit_price":
case "quantity":
$this->addElement("text", $col, array("attribs" => array("class" => "form-control"), "allowEmpty" => false, "filters" => array("StringTrim", "StripTags"), "validators" => array()));
$this->getElement($col)->removeDecorator("Label")->removeDecorator("HtmlTag");
break;
case "comments":
$this->addElement("textarea", $col, array("attribs" => array("class" => "form-control", "rows" => "2"), "allowEmpty" => false, "filters" => array("StringTrim", "StripTags"), "validators" => array()));
$this->getElement($col)->removeDecorator("Label")->removeDecorator("HtmlTag");
break;
case "shipment_date":
case "production_date":
case "expiry_date":
$this->addElement("text", $col, array("attribs" => array("class" => "form-control", 'readonly' => 'true'), "allowEmpty" => false, "filters" => array("StringTrim", "StripTags"), "validators" => array()));
$this->getElement($col)->removeDecorator("Label")->removeDecorator("HtmlTag");
break;
case "transaction_number":
$this->addElement("text", $col, array("attribs" => array("class" => "form-control", 'readonly' => 'true'), "allowEmpty" => false, "filters" => array("StringTrim", "StripTags"), "validators" => array()));
$this->getElement($col)->removeDecorator("Label")->removeDecorator("HtmlTag");
break;
default:
break;
}
//if ($col == "manufacturer_id") {
// $attribute_class = "col-md-2 form-control input-small";
//} else {
$attribute_class = "form-control";
//}
if (in_array($col, array_keys($this->_list))) {
$this->addElement("select", $col, array("attribs" => array("class" => "{$attribute_class}"), "filters" => array("StringTrim", "StripTags"), "allowEmpty" => true, "required" => false, "registerInArrayValidator" => false, "multiOptions" => $this->_list[$col], "validators" => array(array("validator" => "Float", "breakChainOnFailure" => false, "options" => array("messages" => array("notFloat" => $name . " must be a valid option"))))));
$this->getElement($col)->removeDecorator("Label")->removeDecorator("HtmlTag");
}
}
foreach ($this->_hidden as $col => $name) {
switch ($col) {
case "hdn_transaction_date":
$this->addElement("hidden", $col);
$this->getElement($col)->removeDecorator("Label")->removeDecorator("HtmlTag");
break;
default:
break;
}
}
}
public function ajaxGetServicesTypeAction()
{
$this->_helper->layout->disableLayout();
$form_values = $this->_request->wh_id;
$warehouses = new Model_Warehouses();
$warehouses->form_values = $form_values;
$result = $warehouses->getServicesTypes();
$this->view->result = $result;
}
public function getExplorerReport()
{
$warehouse_data = new Model_WarehousesData();
$warehouses = new Model_Warehouses();
$reports = new Model_Reports();
$temp = $this->temp;
$temp = base64_decode(substr($temp, 1, strlen($temp) - 1));
$temp = explode("|", $temp);
$wh_id = $temp[0];
$loc_id = $temp[1];
$report_date = $temp[2];
$is_new_report = $temp[3];
$tt = explode("-", $report_date);
$yy = $tt[0];
$mm = $tt[1];
$dd = $tt[2];
if ($mm == '1') {
$month = "Jan";
}
if ($mm == '2') {
$month = "Feb";
}
if ($mm == '3') {
$month = "Mar";
}
if ($mm == '4') {
$month = "Apr";
}
if ($mm == '5') {
$month = "May";
}
if ($mm == '6') {
$month = "Jun";
}
if ($mm == '7') {
$month = "Jul";
}
if ($mm == '8') {
$month = "Aug";
}
if ($mm == '9') {
$month = "Sep";
}
if ($mm == '10') {
$month = "Oct";
}
if ($mm == '11') {
$month = "Nov";
}
if ($mm == '12') {
$month = "Dec";
}
$warehouses->form_values['pk_id'] = $wh_id;
$stakeholder_id = $warehouses->getStakeholderIdByWarehouseId();
if ($is_new_report == 1) {
$prev_month_date = $reports->getPreviousMonthReportDate($report_date);
} else {
$prev_month_date = $report_date;
}
$warehouses->form_values['location_id'] = $loc_id;
$uc_centers = $warehouses->getAllUCCenters();
$warehouse_data->form_values['warehouse_id'] = $wh_id;
$reports = $warehouse_data->getMonthYearByWarehouseId();
$warehouse_level = $warehouses->getWarehouseLevelById();
$array_data = array('wh_id' => $wh_id, 'loc_id' => $loc_id, 'rpt_date' => $report_date, 'is_new_rpt' => $is_new_report, 'yy' => $yy, 'mm' => $mm, 'dd' => $dd, 'prev_month_date' => $prev_month_date, 'stakeholder_id' => $stakeholder_id, 'month' => $month, 'warehouse_level' => $warehouse_level);
return $array_data;
}
public function printStockReportAction()
{
$this->_helper->layout->setLayout('print');
$wh = new Model_Warehouses();
$stock_master = new Model_StockMaster();
$stock_master->form_values = $this->_request->getParams();
$this->view->headTitle("Stock Balance Report");
$this->view->print_title = "Stock Balance Report";
$this->view->month = $this->_request->getParam('month', date("m"));
$this->view->year = $this->_request->getParam('year', date("Y"));
$this->view->result = $stock_master->getStockReportByDate();
$this->view->username = $this->_identity->getUserName();
$this->view->warehousename = $wh->getWarehouseNameByWarehouseId($this->_request->getParam('warehouse'));
}
public function init()
{
$list_detail = new Model_ListDetail();
$list_detail->form_values['master_id'] = Model_ListMaster::GRID_ELECTRICITY_AVAL;
$result = $list_detail->getListDetailByMasterId();
foreach ($result as $list) {
$this->_list["grid_electricity_availibility"][''] = 'Select';
$this->_list["grid_electricity_availibility"][$list['pkId']] = $list['listValue'];
}
$warehouse = new Model_Warehouses();
$res_warehouse = $warehouse->getHealthFacilityTypes();
foreach ($res_warehouse as $row) {
// $this->_checkbox["vaccine_supply_mode"][$list12['pkId']] = $list12['listValue'];
$this->_list["health_facility_type"][''] = 'Select';
$this->_list["health_facility_type"][$row['pkId']] = $row['warehouseTypeName'];
}
$list_detail->form_values['master_id'] = Model_ListMaster::VACCINATION_STAFF;
$result1 = $list_detail->getListDetailByMasterId();
foreach ($result1 as $list1) {
$this->_checkbox["epi_vaccination_staff"][$list1['pkId']] = $list1['listValue'];
}
$list_detail->form_values['master_id'] = Model_ListMaster::Service_Types;
$result13 = $list_detail->getListDetailByMasterId();
foreach ($result13 as $list13) {
$this->_checkbox["services_type"][$list13['pkId']] = $list13['listValue'];
}
$list_detail->form_values['master_id'] = Model_ListMaster::Vaccine_Supply_Mode;
$result12 = $list_detail->getListDetailByMasterId();
foreach ($result12 as $list12) {
// $this->_checkbox["vaccine_supply_mode"][$list12['pkId']] = $list12['listValue'];
$this->_list["vaccine_supply_mode"][''] = 'Select';
$this->_list["vaccine_supply_mode"][$list12['pkId']] = $list12['listValue'];
}
$list_detail->form_values['master_id'] = Model_ListMaster::SOLAR_ENERGY;
$result2 = $list_detail->getListDetailByMasterId();
foreach ($result2 as $list2) {
$this->_checkbox["solar_energy"][$list2['pkId']] = $list2['listValue'];
}
foreach ($this->_fields as $col => $name) {
switch ($col) {
case "routine_immunization_ice_pack":
case "snid_nid_ice_pack":
case "vaccine_supply_mode":
case "facility_total_population":
case "live_birth_per_year":
case "pregnant_women_per_year":
case "women_of_child_bearing_age":
$this->addElement("text", $col, array("attribs" => array("class" => "form-control"), "allowEmpty" => true, "required" => false, "filters" => array("StringTrim", "StripTags"), "validators" => array()));
$this->getElement($col)->removeDecorator("Label")->removeDecorator("HtmlTag");
break;
case "estimation_year":
$this->addElement("text", $col, array("attribs" => array("class" => "form-control", 'readonly' => 'true'), "allowEmpty" => false, "filters" => array("StringTrim", "StripTags"), "validators" => array()));
$this->getElement($col)->removeDecorator("Label")->removeDecorator("HtmlTag");
break;
default:
break;
}
if (in_array($col, array_keys($this->_list))) {
$this->addElement("select", $col, array("attribs" => array("class" => "form-control"), "filters" => array("StringTrim", "StripTags"), "allowEmpty" => true, "required" => false, "registerInArrayValidator" => false, "multiOptions" => $this->_list[$col]));
$this->getElement($col)->removeDecorator("Label")->removeDecorator("HtmlTag");
}
if (in_array($col, array_keys($this->_checkbox))) {
$this->addElement("checkbox", $col, array("attribs" => array(), "allowEmpty" => true, 'separator' => '', "filters" => array("StringTrim", "StripTags"), "validators" => array(), "multiOptions" => $this->_checkbox[$col]));
$this->getElement($col)->removeDecorator("Label")->removeDecorator("HtmlTag");
}
}
foreach ($this->_hidden as $col => $name) {
switch ($col) {
case "old_warehouse_val":
case "office_level":
$this->addElement("hidden", $col);
$this->getElement($col)->removeDecorator("Label")->removeDecorator("HtmlTag");
break;
default:
break;
}
}
}
public function getTempStock()
{
$str_sql = $this->_em->createQueryBuilder()->select('sm.transactionNumber AS transaction_number,
sm.transactionReference AS transaction_reference,
sm.transactionDate AS transaction_date,
sm.pkId AS pk_id,
ws.pkId AS from_warehouse_id,
ws.warehouseName AS warehouse_name
')->from("StockMaster", "sm")->join("sm.fromWarehouse", "ws")->where("sm.createdBy = " . $this->_user_id)->andWhere("ws.status = 1");
if ($this->form_values['transaction_type_id'] == 1) {
$str_sql->andWhere("sm.toWarehouse = " . $this->_identity->getWarehouseId());
} else {
$str_sql->andWhere("sm.fromWarehouse = " . $this->_identity->getWarehouseId());
}
$str_sql->andWhere("sm.transactionType = " . $this->form_values['transaction_type_id'])->andWhere("sm.draft = 1 ");
//echo $str_sql->getQuery()->getSql();
//exit;
$row = $str_sql->getQuery()->getResult();
if (!empty($row) && count($row) > 0) {
$warehouses = new Model_Warehouses();
$arr_data['warehouse_name'] = $warehouses->getWarehouseNameByWarehouseId($row[0]['from_warehouse_id']);
$arr_data['transaction_date'] = App_Controller_Functions::dateToUserFormat($row[0]['transaction_date']);
$arr_data['transaction_number'] = $row[0]['transaction_number'];
$arr_data['transaction_reference'] = $row[0]['transaction_reference'];
$arr_data['stock_id'] = $row[0]['pk_id'];
return $arr_data;
} else {
return false;
}
}
public function allLevelComboAllColdChainEquipment($office_term = "", $postfix = null, $data_array)
{
$identity = App_Auth::getInstance();
$translate = Zend_Registry::get('Zend_Translate');
$base_url = Zend_Registry::get('baseurl');
$user_lvl = $identity->getUserLevel($identity->getIdentity());
$stakeholder_id = $identity->getStakeholderId();
$warehouse = new Model_Warehouses();
$office = $data_array["level"];
$province = $data_array["province"];
$district = $data_array["district"];
$warehouse_id = $data_array["warehouse"];
if ($office == 1) {
$warehouse->form_values = array('stakeholder_id' => $stakeholder_id);
switch ($office) {
case 1:
$warehouse_array = $warehouse->getFederalWarehouses();
break;
}
}
if (!empty($province)) {
$locations = new Model_Locations();
$locations->form_values = array('parent_id' => 10, 'geo_level_id' => 2);
$provinces_array = $locations->getLocationsByLevel();
if (empty($district)) {
$warehouse->form_values = array('province_id' => $province, 'stakeholder_id' => $stakeholder_id);
switch ($office) {
case 1:
$warehouse_array = $warehouse->getFederalWarehouses();
break;
case 2:
$warehouse_array = $warehouse->getProvincialWarehouses();
break;
case 4:
$warehouse_array = $warehouse->getDistrictWarehousesofProvince();
break;
}
}
}
if (!empty($district)) {
$location = new Model_Locations();
$location->form_values = array('province_id' => $province, 'geo_level_id' => 4);
$districts_array = $location->getLocationsByLevelByProvince();
$warehouse->form_values = array('district_id' => $district, 'stakeholder_id' => $stakeholder_id);
switch ($office) {
case 5:
$warehouse_array = $warehouse->getTehsilWarehousesofDistrict();
break;
case 6:
$warehouse_array = $warehouse->getUCWarehousesofDistrict();
break;
case 8:
$warehouse_array = $warehouse->getTehsilWarehousesofDistrict();
break;
case 9:
$warehouse_array = $warehouse->getUCWarehousesofDistrict();
break;
}
}
switch ($user_lvl) {
case 1:
case 2:
case 3:
$arr_levels = array('1' => $translate->translate('National'), '2' => $translate->translate('Province'), '4' => $translate->translate('District'), '8' => $translate->translate('Tehsil-Taluka'), '9' => $translate->translate('UC'));
break;
case 4:
$arr_levels = array('1' => $translate->translate('National'), '2' => $translate->translate('Province'), '4' => $translate->translate('District'), '8' => $translate->translate('Tehsil-Taluka'), '9' => $translate->translate('UC'));
break;
case 5:
$arr_levels = array('2' => $translate->translate('National'), '4' => $translate->translate('District'));
break;
case 6:
$arr_levels = array('2' => $translate->translate('Province'), '5' => $translate->translate('Tehsil-Taluka'), '6' => $translate->translate('Union Council'));
break;
case 7:
$arr_levels = array('7' => $translate->translate('District'), '6' => $translate->translate('Union Council'));
case 8:
$arr_levels = array('7' => $translate->translate('District'), '5' => $translate->translate('Tehsil-Taluka'), '6' => $translate->translate('Union Council'));
break;
default:
$arr_levels = array('1' => $translate->translate('National'), '2' => $translate->translate('Province'), '4' => $translate->translate('District'), '5' => $translate->translate('Tehsil-Taluka'), '6' => $translate->translate('Union Council'));
break;
}
?>
<div class="row">
<div class="col-md-12" id="all_level_combo">
<div class="col-md-3">
<div class="control-group">
<label class="control-label" for="office" class="col-md-7"><?php
echo $translate->translate("Level");
?>
</label>
<div class="controls">
<select name="office" id="office<?php
echo $postfix;
?>
" class="form-control">
<option value=""><?php
echo $translate->translate("Select");
?>
</option>
<?php
foreach ($arr_levels as $key => $value) {
?>
<option value="<?php
echo $key;
?>
" <?php
if (!empty($office) && $key == $office) {
echo 'selected';
}
?>
><?php
echo $value;
?>
</option>
<?php
}
?>
</select>
</div>
</div>
</div>
<div class="col-md-3" id="div_combo1<?php
echo $postfix;
?>
" <?php
if ($office == 2 || !empty($province)) {
?>
style="display:block;" <?php
} else {
?>
style="display:none;"<?php
}
?>
>
<label class="control-label" id="lblcombo1"><?php
echo $translate->translate("Province");
?>
</label>
<div class="controls">
<select name="combo1" id="combo1<?php
echo $postfix;
?>
" class="form-control">
<?php
if ($provinces_array != false) {
?>
<option value=""><?php
echo $translate->translate("Select");
?>
</option>
<?php
foreach ($provinces_array as $row) {
?>
<option value="<?php
echo $row['key'];
?>
" <?php
if (!empty($province) && $row['key'] == $province) {
echo 'selected';
}
?>
>
<?php
echo $row['value'];
?>
</option>
<?php
}
}
?>
</select>
</div>
</div>
<div class="col-md-3" id="div_combo2<?php
echo $postfix;
?>
" <?php
if ($office == 5 || !empty($district)) {
?>
style="display:block;" <?php
} else {
?>
style="display:none;"<?php
}
?>
>
<label class="control-label" id="lblcombo2"><?php
echo $translate->translate("District");
?>
</label>
<div class="controls">
<select name="combo2" id="combo2<?php
echo $postfix;
?>
" class="form-control">
<?php
if ($districts_array != false) {
?>
<option value=""><?php
echo $translate->translate("Select");
?>
</option>
<?php
foreach ($districts_array as $row) {
?>
<option value="<?php
echo $row['key'];
?>
" <?php
if (!empty($district) && $row['key'] == $district) {
echo 'selected';
}
?>
>
<?php
echo $row['value'];
?>
</option>
<?php
}
}
?>
</select>
</div>
</div>
<div class="col-md-3" id="wh_combo<?php
echo $postfix;
?>
" <?php
/*if (!empty($warehouse_id)) { ?> style="display:block;" <?php } else { ?> style="display:none;"<?php } */
?>
>
<label class="control-label" id="wh_l"><?php
echo $translate->translate("Warehouse");
?>
<span class="red">*</span></label>
<div class="controls">
<select name="warehouse<?php
echo $postfix;
?>
" id="warehouse<?php
echo $postfix;
?>
" class="form-control">
<?php
if ($warehouse_array != false) {
?>
<option value=""><?php
echo $translate->translate("Select");
?>
</option>
<?php
foreach ($warehouse_array as $row) {
?>
<option value="<?php
echo $row['key'];
?>
" <?php
if (!empty($warehouse_id) && $row['key'] == $warehouse_id) {
echo 'selected';
}
?>
>
<?php
echo $row['value'];
?>
</option>
<?php
}
}
?>
</select>
</div>
</div>
<div class="col-md-1" id="loader<?php
echo $postfix;
?>
" style="display:none;"><img src="<?php
echo $base_url;
?>
/images/loader.gif" style="margin-top:8px; float:left" alt="" /></div>
</div>
</div>
<?php
return true;
}
public function getDefaultWarehouseByLevelAction()
{
$this->_helper->layout->disableLayout();
$form_values = $this->_request->getPost();
$warehouse = new Model_Warehouses();
$warehouse->form_values = $form_values;
$result = $warehouse->getDefaultWarehouseByLevel();
$this->view->data = $result;
}
public function distributionRefrigeratorByModelByFTypeAction()
{
ini_set('memory_limit', '128M');
$this->_helper->layout->setLayout('reports');
$header = '';
$header .= 'Model';
//$header1 = '#rspan';
$cspan = '#cspan';
$width = '60';
$ro = 'ro';
$align = "left";
$data_arr = array();
$search_form = new Form_ReportsSearch();
$cold_chain = new Model_ColdChain();
$form_values['facility_type'] = $this->_request->getParam('facility_type', '');
$form_values['office'] = $this->_request->getParam('office', '');
$form_values['combo1'] = $this->_request->getParam('combo1', '');
$form_values['combo2'] = $this->_request->getParam('combo2', '');
if ($this->_request->isPost()) {
if ($search_form->isValid($this->_request->getPost())) {
$form_values = array_merge($form_values, $search_form->getValues());
$cold_chain->form_values = $form_values;
$qry_res = $cold_chain->getColdchainModelsByFacilityType();
$warehouse = new Model_Warehouses();
$warehouse_asset_types = $warehouse->getWarehouseByAssetType();
foreach ($qry_res as $row) {
$data_arr[$row['pk_id']][] = $row['ccm_model_name'];
$count = 1;
foreach ($warehouse_asset_types as $warehouse_asset_type) {
$data_arr[$row['pk_id']][$warehouse_asset_type['warehouse_type_id']] = 0;
}
}
foreach ($warehouse_asset_types as $row2) {
$header .= ',' . $row2['warehouse_type_name'];
//$header1 .= ',#rspan';
$cspan .= ',#cspan';
$width .= ',*';
$ro .= ',ro';
$align .= ',right';
$warehouse_warehouse_types = $cold_chain->getColdChainByWarehouseType($row2['warehouse_type_id']);
$count = 1;
foreach ($warehouse_warehouse_types as $warehouse_warehouse_type) {
if ($data_arr[$warehouse_warehouse_type['pk_id']][0] && $data_arr[$warehouse_warehouse_type['pk_id']][0] != "") {
$data_arr[$warehouse_warehouse_type['pk_id']][$row2['warehouse_type_id']] = $warehouse_warehouse_type['TotalAssets'];
}
}
}
}
}
if ($data_arr && count($data_arr) > 0) {
$xmlstore = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>";
$xmlstore .= "<rows>";
foreach ($data_arr as $item => $sub_arr) {
$xmlstore .= "<row>";
if (array_key_exists('0', $sub_arr)) {
$xmlstore .= "<cell>" . $sub_arr[0] . "</cell>";
} else {
$xmlstore .= "<cell> - </cell>";
}
foreach ($sub_arr as $key => $value) {
if ($key > 0) {
$xmlstore .= "<cell style=\"text-align:right\">" . number_format($value) . "</cell>";
}
}
$xmlstore .= "</row>";
}
$xmlstore .= "</rows>";
} else {
$xmlstore = "";
}
$this->view->main_heading = "CCEM Reports";
$this->view->report_title = "Distribution of Refrigerators/Freezers by Model and Facility Type";
$this->view->data = $data_arr;
$this->view->headers = $header;
$this->view->width = $width;
$this->view->ro = $ro;
$this->view->cspan = $cspan;
$this->view->xmlstore = $xmlstore;
$this->view->search_form = $search_form;
$this->view->form_values = $form_values;
$this->view->inlineScript()->appendFile(Zend_Registry::get('baseurl') . '/js/all_level_area_combo_report_graph.js');
}
public function checkCcmWarehouseUpdateAction()
{
$this->_helper->layout->disableLayout();
$form_values = $this->_request->getPost();
$warehouse = new Model_Warehouses();
$warehouse->form_values = $form_values;
$result = $warehouse->checkCcmWarehouseIdUpdate();
$this->view->result = $result;
}
public function dsStockPlacementComparisonPrintAction()
{
$this->_helper->layout->setLayout('print');
$this->view->headTitle("Dry Store Stock Placement Comparison");
$this->view->print_title = "Dry Store Stock Placement Comparison";
$wh_id = $this->_request->getParam('id');
$stock_batch = new Model_StockBatch();
$stock_batch->form_values['wh_id'] = $wh_id;
$batch_total = $stock_batch->dsBatchProductTotal();
$this->view->batch_total = $batch_total;
$stakeholder_total = $stock_batch->dsStakeholderProductTotal();
$this->view->stakeholder_total = $stakeholder_total;
$priority_total = $stock_batch->dsPlacementProductTotal();
$this->view->priority_total = $priority_total;
$warehouse = new Model_Warehouses();
$wh_name = $warehouse->getWarehouseNameByWarehouseId($wh_id);
$this->view->warehousename = $wh_name;
$this->view->warehouseid = $wh_id;
}
