public function init()
{
$this->addElementPrefixPath('Base_Validate', 'Base/Validate/', 'validate');
$this->setName('frmProduction');
$model = new Base_Security_Privilege();
$arrBreed = $model->getMasterValues('fdAnimal');
$this->addElement('select', 'breed', array('label' => 'Breed:', 'id' => 'breed', 'decorators' => $this->elementDecorators, 'filters' => array('StringTrim'), 'MultiOptions' => $arrBreed));
$arrType = $model->getMasterValues('fdAnimalType');
$this->addElement('select', 'type', array('label' => 'Type:', 'id' => 'type', 'decorators' => $this->elementDecorators, 'filters' => array('StringTrim'), 'MultiOptions' => $arrType));
$arrColor = $model->getMasterValues('fdAnimalColor');
$this->addElement('select', 'color', array('label' => 'Color:', 'id' => 'color', 'decorators' => $this->elementDecorators, 'filters' => array('StringTrim'), 'MultiOptions' => $arrColor));
$this->addElement('text', 'cowid', array('label' => 'Cow ID:', 'class' => 'text-input medium-input', 'decorators' => $this->elementDecorators, 'filters' => array('StringTrim')));
$arrSuplier = $model->getSupplier();
$this->addElement('select', 'supplier', array('label' => 'Select Supplier:', 'id' => 'type', 'decorators' => $this->elementDecorators, 'filters' => array('StringTrim'), 'MultiOptions' => $arrSuplier));
$arrInputs = $model->getCondumnValues('fdCondumnSubStatus');
$this->addElement('multiselect', 'inputs', array('label' => 'Input(s):', 'id' => 'inputs', 'class' => 's1', 'decorators' => $this->elementDecorators, 'filters' => array('StringTrim'), 'MultiOptions' => $arrInputs));
}
public function weighingAction()
{
$model = new Mps_Model_RawProduct();
$Pstatus = "Weighing";
$code = "fdCondumnStatus";
$model2 = new Base_Security_Privilege();
$arrValues = $model2->getCondumnValues($code);
$arrSubcondumn = $model2->getCondumnValues('fdCondumnSubStatus');
$this->view->condumnValue = $arrValues;
$this->view->condumnSubValue = $arrSubcondumn;
$where = "p.id<>'-2147483648' and process_status='{$Pstatus}'";
//Edit cow weight values
$request = $this->getRequest();
$options = $request->getPost();
$cowid = trim($this->_getParam('cowid'));
$weight = trim($this->_getParam("weight"));
$this->view->cowid = $cowid;
if ($request->isPost()) {
if (isset($options['submit'])) {
//Update Cow weight
$isExist = $model->isExist("id='{$cowid}' and process_status='{$Pstatus}'");
if ($isExist) {
$model = $model->fetchRow("id='{$cowid}' and process_status='{$Pstatus}'");
if ($model !== false) {
$model->setWeight($weight);
$model->save();
}
$this->_flashMessenger->addMessage(array('success' => 'Cow weight has been updated successfully!'));
$this->_helper->_redirector->gotoUrl($this->view->seoUrl('/mps/production/weighing/cowid/' . $cowid));
} else {
$this->_flashMessenger->addMessage(array('error' => 'Cow ID does not exist!'));
$this->_helper->_redirector->gotoUrl($this->view->seoUrl('/mps/production/weighing/cowid/' . $cowid));
}
//End Update Cow weight
} else {
//Update condumn status and weight
$condumnStatus = trim($this->_getParam("condumnStatus"));
//get condumn id on the basis of condumn value
while ($value = current($arrValues)) {
if ($value == $condumnStatus) {
$condumnID = key($arrValues);
}
next($arrValues);
}
$model = $model->fetchRow("id='{$cowid}' and process_status='{$Pstatus}'");
if ($model !== false && !empty($condumnID)) {
$model->setWeight($weight);
$model->setStatusOn($condumnID);
$model->save();
$this->_flashMessenger->addMessage(array('success' => 'Condumn status has been updated successfully!'));
$this->_helper->_redirector->gotoUrl($this->view->seoUrl('/mps/production/weighing/cowid/' . $cowid));
} else {
$this->_flashMessenger->addMessage(array('error' => 'Invalid Condumn status'));
$this->_helper->_redirector->gotoUrl($this->view->seoUrl('/mps/production/weighing/'));
}
//End Update condumn status and weight
}
}
//End Edit
/*---sorting ----*/
$order = trim($this->_getParam('order', ""));
$col = trim($this->_getParam('col', ""));
if ($order != "" && $col != "") {
if ($col == "id") {
$strOrderBy = "p.id {$order}";
} else {
if ($col == "knocked_date") {
$strOrderBy = "p.knocked_date {$order}";
} else {
if ($col == "first_name") {
$strOrderBy = array("s.first_name {$order}", "s.last_name {$order}");
}
}
}
} else {
$strOrderBy = "p.knocked_date desc";
//"p.knocked_date desc"
}
$this->view->sortOptions = array();
/*-----sorting----------*/
/*--search---*/
$this->view->linkArray = array();
$page_size = Zend_Registry::get('page_size');
$page = $this->_getParam('page', 1);
$table = $model->getMapper()->getDbTable();
$select = $table->select()->setIntegrityCheck(false)->from(array("s" => 'supplier'), array("first_name", "last_name"))->join(array("p" => "raw_product"), "s.id=p.supplier_id and p.process_status='{$Pstatus}' and s.id!='-2147483648'", array("*"))->order($strOrderBy);
// echo $sql = $select->__toString(); die;
$paginator = Base_Paginator::factory($select);
$paginator->setItemCountPerPage($page_size);
$paginator->setCurrentPageNumber($page);
$this->view->totalItems = $paginator->getTotalItemCount();
$this->view->paginator = $paginator;
}
public function indexAction()
{
$Pstatus = "Knocked";
if ($this->_getParam('inputs')) {
$search_input = trim(implode(',', $this->_getParam('inputs')));
} else {
$search_input = '';
}
$form = new Mps_Form_Compliance();
$elements = $form->getElements();
$form->clearDecorators();
foreach ($elements as $element) {
$element->removeDecorator('data');
$element->removeDecorator('Label');
$element->removeDecorator('row');
}
//Used in listing
$model2 = new Base_Security_Privilege();
$arrCondumnSubValue = $model2->getCondumnValues('fdCondumnSubStatus');
$this->view->condumnSubValue = $arrCondumnSubValue;
//End
/*---sorting ----*/
$order = trim($this->_getParam('order', ""));
$col = trim($this->_getParam('col', ""));
if ($order != "" && $col != "") {
if ($col == "breed") {
$strOrderBy = "s2.master_value {$order}";
} else {
if ($col == "type") {
$strOrderBy = "s.master_value {$order}";
} else {
if ($col == "color") {
$strOrderBy = "s3.master_value {$order}";
} else {
if ($col == "auction_tag") {
$strOrderBy = "p.auction_tag {$order}";
} else {
if ($col == "ear_tag") {
$strOrderBy = "p.ear_tag {$order}";
} else {
if ($col == "trich") {
$strOrderBy = "p.trich {$order}";
} else {
if ($col == "trich") {
$strOrderBy = "p.trich {$order}";
} else {
if ($col == 'id') {
$strOrderBy = "p.id {$order}";
}
}
}
}
}
}
}
}
} else {
$strOrderBy = "p.id";
}
$this->view->sortOptions = array();
/*-----sorting----------*/
/*--search---*/
$search = trim($this->_getParam('search'));
$where = "p.id<>'-2147483648' and p.process_status='{$Pstatus}'";
$this->view->linkArray = array();
if ($search != "") {
$params = $this->_getAllParams();
$breed = trim($this->_getParam('breed'));
$type = trim($this->_getParam('type'));
$color = trim($this->_getParam('color'));
$id = trim($this->_getParam('id'));
$supplier = trim($this->_getParam('supplier'));
if (!empty($breed)) {
$where .= " and breed='{$breed}'";
}
if (!empty($type)) {
$where .= " and type='{$type}'";
}
if (!empty($color)) {
$where .= " and color = '{$color}'";
}
if (!empty($id)) {
$where = " and id = '{$id}' and p.process_status='{$Pstatus}'";
}
if (!empty($supplier)) {
$where .= " and supplier_id = '{$supplier}'";
}
if (!empty($search_input)) {
$where .= " and condumn_sub_status like '%{$search_input}%'";
}
$where = "{$where}";
$this->view->sortOptions['inputs'] = $search_input;
$form->populate($params);
}
$page_size = Zend_Registry::get('page_size');
$page = $this->_getParam('page', 1);
$model = new Mps_Model_RawProduct();
$table = $model->getMapper()->getDbTable();
$select = $table->select()->setIntegrityCheck(false)->from(array("p" => 'raw_product'), array("*"))->join(array("s" => "system_master"), "s.master_code='fdAnimalType' and s.master_id=p.type", array("type" => "master_value"))->join(array("s2" => "system_master"), "s2.master_code='fdAnimal' and s2.master_id=p.breed", array("breed" => "master_value"))->join(array("s3" => "system_master"), "s3.master_code='fdAnimalColor' and s3.master_id=p.color", array("color" => "master_value"))->order("{$strOrderBy}")->where($where);
// echo $sql = $select->__toString(); die;
$paginator = Base_Paginator::factory($select);
$paginator->setItemCountPerPage($page_size);
$paginator->setCurrentPageNumber($page);
$this->view->totalItems = $paginator->getTotalItemCount();
$this->view->paginator = $paginator;
//End Listing
$this->view->form = $form;
}