public function recordsAction()
{
$this->_helper->layout->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
// $this->getResponse()
// ->setHeader('Content-Type', 'application/json');
// require_once APPLICATION_PATH . '/modules/asset/models/DbTable/Upgrade.php';
$upgrade = new Asset_Model_DbTable_Upgrade();
$sort_column = $this->_getParam('sortname', 'UpgradeID');
# this will default to undefined
$sort_order = $this->_getParam('sortorder', 'desc');
# this will default to undefined
$page = $this->_getParam('page', 1);
$limit = $this->_getParam('rp', 10);
$offset = ($page - 1) * $limit;
$search_column = $this->_getParam('qtype', 'Ten_tai_san');
$search_for = $this->_getParam('query', '');
$uInfo = (array) Zend_Auth::getInstance()->getIdentity();
if ($uInfo['Role'] == 0 || $uInfo['Role'] == 2) {
// SuperAdmin or IT
$select = $upgrade->select(Zend_Db_Table::SELECT_WITH_FROM_PART)->setIntegrityCheck(false)->join(array('u' => 'memberinfor'), 'upgradeinfor.UserID = u.UserID', array('Username' => 'u.Username'))->join(array('m' => 'memberinfor'), 'upgradeinfor.ManagerID = m.UserID', array('Manager' => 'm.Username'))->join(array('i' => 'iteminfor'), 'upgradeinfor.ItemID = i.ItemID', array('TenTS' => 'i.Ten_tai_san', 'MaTS' => 'i.Ma_tai_san'))->order("{$sort_column} {$sort_order}")->limit($limit, $offset);
} else {
$select = $upgrade->select(Zend_Db_Table::SELECT_WITH_FROM_PART)->setIntegrityCheck(false)->join(array('u' => 'memberinfor'), 'upgradeinfor.UserID = u.UserID', array('Username' => 'u.Username'))->join(array('m' => 'memberinfor'), 'upgradeinfor.ManagerID = m.UserID', array('Manager' => 'm.Username'))->join(array('i' => 'iteminfor'), 'upgradeinfor.ItemID = i.ItemID', array('TenTS' => 'i.Ten_tai_san', 'MaTS' => 'i.Ma_tai_san'))->where("u.Username = '******'Username'] . "'")->order("{$sort_column} {$sort_order}")->limit($limit, $offset);
}
if (!empty($search_column) && !empty($search_for)) {
$select->where($search_column . ' LIKE ?', '%' . $search_for . '%');
}
$pager = Zend_Paginator::factory($select);
$pager->setCurrentPageNumber($page);
$pager->setItemCountPerPage($limit);
$records = $pager->getIterator();
$total = $pager->getTotalItemCount();
if ($total == 0) {
echo Zend_Json::encode(array('page' => $page, 'total' => $total, 'rows' => NULL));
exit;
}
foreach ($records as $record) {
//If cell's elements have named keys, they must match column names
//Only cell's with named keys and matching columns are order independent.
$rows[] = array('id' => $record['UpgradeID'], 'cell' => $record->toArray());
}
$jsonData = array('page' => $page, 'total' => $total, 'rows' => $rows);
echo Zend_Json::encode($jsonData);
}
public function successAction()
{
$this->_helper->layout->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
// require_once APPLICATION_PATH . '/modules/asset/models/DbTable/Request.php';
if ($this->getRequest()->getPost()) {
$requestid = $this->getRequest()->getPost('RequestID', -1);
if ($requestid > 0) {
$re = new Asset_Model_DbTable_Request();
$reInfo = $re->getRequestFromID($requestid);
if ($reInfo == NULL) {
$status = 'Error';
$msg = 'Not found request record.';
echo Zend_Json::encode(array('status' => $status, 'msg' => $msg));
exit;
} elseif ($reInfo['Accept'] == 1) {
$upgrade = new Asset_Model_DbTable_Upgrade();
$it = new Asset_Model_DbTable_Item();
$item = $it->getItemFromMa($reInfo['Ma_tai_san']);
$ItemID = $item['ItemID'];
$upgrade->addUpgrade($reInfo['UserID'], Zend_Auth::getInstance()->getIdentity()->UserID, $ItemID, $reInfo['Detail'], date("Y-m-d"));
$re->deleteRequest($requestid);
$status = 'Success';
$msg = 'Update database success';
} else {
$status = 'Error';
$msg = 'Yêu cầu chưa được xử lý.';
}
} else {
$status = 'Error';
$msg = 'Not found request record.';
}
} else {
$status = 'Error';
$msg = 'Not found POST value';
}
echo Zend_Json::encode(array('status' => $status, 'msg' => $msg));
}
