public function loadLastReportedDate($wh_id) { $reports = new Model_Reports(); $reports->form_values = array("wh_id" => $wh_id); $max_date = $reports->getLastCreatedDate(); //echo $max_date; if (!empty($max_date)) { return date("d/m/Y", strtotime($max_date)); } else { return '-'; } }
public function ajaxExplorer2Action() { $this->_helper->layout->setLayout('ajax'); $warehouse_data = new Model_WarehousesData(); if (isset($this->_request->do) && !empty($this->_request->do)) { $base_url = Zend_Registry::get('baseurl'); $this->view->headLink()->appendStylesheet($base_url . '/common/assets/global/plugins/datatables/plugins/bootstrap/dataTables.bootstrap.css'); $this->view->headLink()->appendStylesheet($base_url . '/common/assets/global/plugins/datatables/media/css/jquery.dataTables.css'); $this->view->inlineScript()->appendFile($base_url . '/common/theme/scripts/plugins/tables/DataTables/media/js/jquery.dataTables_1.js'); $this->view->inlineScript()->appendFile($base_url . '/common/theme/scripts/plugins/tables/DataTables/extras/TableTools/media/js/TableTools.js'); $this->view->inlineScript()->appendFile($base_url . '/common/theme/scripts/demo/tables.js'); $temp = $this->_request->do; $warehouse_data->temp = $temp; $arr_temp = $warehouse_data->getExplorerReport(); $this->view->month = $arr_temp['month']; $this->view->wh_id = $arr_temp['wh_id']; $this->view->loc_id = $arr_temp['loc_id']; $this->view->rpt_date = $arr_temp['rpt_date']; $this->view->yy = $arr_temp['yy']; $this->view->mm = $arr_temp['mm']; $this->view->dd = $arr_temp['dd']; $this->view->is_new_report = $arr_temp['is_new_rpt']; $this->view->prev_month_date = $arr_temp['prev_month_date']; $this->view->stakeholder_id = $arr_temp['stakeholder_id']; $this->view->warehouse_level = $arr_temp['warehouse_level']; $reports = new Model_Reports(); $reports->form_values = array("wh_id" => $arr_temp['wh_id']); $max_date = $reports->getLastCreatedDate(); $this->view->created_date = date("d/m/Y", strtotime($max_date)); } }