public function init() { //Generate Products(items) Combo $items = new Model_ItemPackSizes(); $result2 = $items->getAllItems(); foreach ($result2 as $item) { $this->_list["item_pack_size_id"][$item['pkId']] = $item['itemName']; } foreach ($this->_fields as $col => $name) { switch ($col) { case "searchinput": $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 "status": $this->addElement("radio", $col, array("attribs" => array(), "allowEmpty" => true, 'separator' => '', "filters" => array("StringTrim", "StripTags"), "validators" => array(), "multiOptions" => array("6" => "All Priorities", "1" => "Priority 1", "2" => "Priority 2", "3" => "Priority 3", "4" => "Finished", "5" => "Expired by date", "7" => "Expired by VVM"), 'options' => array('label' => 'Title', 'labelAttributes' => array('class' => 'radio-inline')))); //$this->getElement($col)->setAttrib("label_class", "radio-inline"); $this->getElement($col)->removeDecorator("Label")->removeDecorator("HtmlTag")->removeDecorator("<br>"); 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())); $this->getElement($col)->removeDecorator("Label")->removeDecorator("HtmlTag"); } } }
public function addReport($stockId, $type, $from = NULL) { $stock_master = new Model_StockMaster(); $stock_master->form_values['pk_id'] = $stockId; $stock_master->form_values['from'] = $from; $result = $stock_master->getItemDetailFromStock(); if ($result != FALSE) { foreach ($result as $stockdata) { $tdate = $stockdata['transaction_date']; $product = $stockdata['item_id']; $month = App_Controller_Functions::dateFormat($tdate, "first day of this month", "m"); $year = App_Controller_Functions::dateFormat($tdate, "first day of this month", "Y"); $wh_id = $this->_identity->getWarehouseId(); if ($month == date("m") && $year == date("Y")) { $item = new Model_ItemPackSizes(); $items = $item->getAllItems(); foreach ($items as $one) { $this->form_values['report_month'] = $month; $this->form_values['report_year'] = $year; $this->form_values['item_id'] = $one['pkId']; $this->form_values['warehouse_id'] = $wh_id; $this->form_values['created_by'] = $this->_user_id; $this->adjustStockReport(); } } else { $this->form_values['report_month'] = $month; $this->form_values['report_year'] = $year; $this->form_values['item_id'] = $product; $this->form_values['warehouse_id'] = $wh_id; $this->form_values['created_by'] = $this->_user_id; $this->adjustStockReport(); } } } }
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 ajaxGetPreMonthReceiveAction() { $this->_helper->layout->disableLayout(); $this->_helper->viewRenderer->setNoRender(TRUE); $params = $this->_request->getParams(); $obj_item = new Model_ItemPackSizes(); $items = $obj_item->getAllItems(); $wh_data = new Model_WarehousesData(); $wh_data->form_values = array('reporting_start_date' => $params['year'] . "-" . $params['month'] . "-01", 'warehouse_id' => $params['wh_id']); $data_rs = $wh_data->isReportExists(); $result = array(); if (!$data_rs) { foreach ($items as $item) { $ips = $this->_em->getRepository("ItemPackSizes")->find($item['pkId']); $str_sql = "SELECT REPgetTransWHData(4,'" . $params['month'] . "','" . $params['year'] . "','" . $item['pkId'] . "','" . $params['wh_id'] . "') from DUAL"; echo $str_sql; exit; $row = $this->_em->getConnection()->executeQuery($str_sql); $rs = $row->fetch(); $result[$item['pkId']] = $rs[0] == NULL ? 0 : $rs[0] * $ips->getNumberOfDoses(); } } echo json_encode($result); }
public function provinceAction() { $auth = App_Auth::getInstance(); $role_id = $auth->getRoleId(); $this->view->level = 2; $this->view->province = $this->_identity->getProvinceId(); $province = $this->_request->getParam("combo1", 1); if (!empty($province) && $province != 'null') { $this->view->province = $province; } $campaign = new Model_Campaigns(); $location = new Model_Locations(); $location->form_values = array("province_id" => $province); $dists = $location->districtLocations(); foreach ($dists as $dist) { $arr_dist[] = $dist['pk_id']; } $campaign->form_values = array("districts" => implode(",", $arr_dist)); $this->view->campaigns = $campaign->getCampaignsByDistrict(); $this->view->provinces = $location->getProvincesName(); $item = new Model_ItemPackSizes(); $this->view->items = $item->getAllItems(); // Default Filters for IM $this->view->item = 6; $this->view->date = Zend_Registry::get('report_month'); // Default Filters for Campaign $this->view->camp = 23; $this->view->user_role = $role_id; $this->view->prov = $this->_identity->getProvinceId(); $r = $this->_request->getParam("ri_btn", ''); if ($r == 'ri') { $this->view->r = $r; $this->view->item = $this->_request->getParam("items", ''); $this->view->date = $this->_request->getParam("date", ''); $this->view->period = $this->_request->getParam("period", ''); } $i = $this->_request->getParam("im_btn", ''); if ($i == 'im') { $this->view->i = $i; $this->view->item = $this->_request->getParam("items", ''); $this->view->date = $this->_request->getParam("date", ''); $this->view->period = $this->_request->getParam("period", ''); } $c = $this->_request->getParam("camp_btn", ''); if ($c == 'camp') { $this->view->c = $c; $this->view->camp = $this->_request->getParam("camp", ''); $this->view->prov = $this->_request->getParam("prov", ''); } $role_resource = new Model_RoleResources(); $role_resource->form_values = array('type_id' => 3, 'role_id' => $role_id); $dashboards = $role_resource->getRoleResourcesByType(); $this->view->dashboards = $dashboards; $this->view->ri = 472; $this->view->im = 330; $this->view->campaign = 333; $period = new Model_Period(); $time_intervals = $period->getTimeIntervals(); $this->view->time_intervals = $time_intervals; $this->view->quarter = Model_Period::QUARTER; $this->view->halfyear = Model_Period::HALFYEAR; $this->view->annual = Model_Period::ANNUAL; $base_url = Zend_Registry::get('baseurl'); $this->view->inlineScript()->appendFile($base_url . '/js/all_level_area_combo.js'); }
public function getItemListAction() { $items = new Model_ItemPackSizes(); $items_list = $items->getAllItems(); echo Zend_Json::encode($items_list); }
/** * Routine Immunization Dashlet Late */ public function wastagesRateAction() { $item = new Model_ItemPackSizes(); $this->view->items = $item->getAllItems(); $wh_data = new Model_WarehousesData(); $params["date"] = "2014-05"; $params["item"] = 6; $wh_data->form_values = $params; $xmlstore = $wh_data->wastagesRate(); $this->view->xmlstore = $xmlstore; $this->view->date = $params["date"]; $this->view->item = $params["item"]; }