public function indexAction()
{
/*--search---*/
$search = trim($this->_getParam('orgName'));
//$status = trim($this->_getParam('status'));
/*---sorting ----*/
$order = trim($this->_getParam('order', ""));
$col = trim($this->_getParam('col', ""));
if ($order != "" && $col != "") {
if ($col == "city") {
$strOrderBy = "s.city {$order}";
} else {
if ($col == "state") {
$strOrderBy = "s.state {$order}";
} else {
if ($col == "zip") {
$strOrderBy = "s.zip {$order}";
}
}
}
} else {
$strOrderBy = "s.first_name asc";
}
$this->view->sortOptions = array();
/*-----sorting----------*/
$where = "s.id<>'-2147483648'";
$this->view->linkArray = array();
$this->view->search = "";
if ($search != "") {
$where = "(org_name like '%{$search}%')and {$where} ";
$this->view->linkArray = array('search' => $search);
$this->view->search = $search;
$this->view->sortOptions['orgName'] = $search;
}
$page_size = Zend_Registry::get('page_size');
$page = $this->_getParam('page', 1);
$model = new Admin_Model_Supplier();
$table = $model->getMapper()->getDbTable();
$select = $table->select()->setIntegrityCheck(false)->from(array("s" => 'supplier'))->order("{$strOrderBy}")->where($where);
$sql = $select->__toString();
$paginator = Base_Paginator::factory($select);
$paginator->setItemCountPerPage($page_size);
$paginator->setCurrentPageNumber($page);
$this->view->totalItems = $paginator->getTotalItemCount();
$this->view->paginator = $paginator;
}
public function getSupplier($id = null)
{
if ($id) {
$where = "id='{$id}'";
} else {
$where = "id!='-2147483648'";
}
$model = new Admin_Model_Supplier();
$table = $model->getMapper()->getDbTable();
$select = $table->select()->setIntegrityCheck(false)->from(array("s" => 'supplier'))->order("first_name")->where($where);
$sql = $select->__toString($select);
$rows = $model->fetchAll($select);
//print_r($rows);
$arr[''] = "Select";
foreach ($rows as $row) {
$arr[$row->getId()] = $row->getFirstName() . ' ' . $row->getLastName();
}
return $arr;
}
