public function detailAction()
{
$this->_helper->layout->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
// require_once APPLICATION_PATH . '/modules/asset/models/DbTable/Upgrade.php';
if ($this->getRequest()->getPost()) {
$upgradeid = $this->getRequest()->getPost('UpgradeID', -1);
if ($upgradeid > 0) {
$up = new Asset_Model_DbTable_Upgrade();
$select = $up->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("UpgradeID = '{$upgradeid}'");
$data = $up->fetchRow($select);
if ($data == NULL) {
$status = 'Error';
$msg = 'Not found upgrade record.';
echo Zend_Json::encode(array('status' => $status, 'msg' => $msg));
exit;
} else {
$status = 'success';
echo Zend_Json::encode(array('status' => $status, 'data' => $data->toArray()));
}
} else {
$status = 'Error';
$msg = 'Not found detail upgrade';
echo Zend_Json::encode(array('status' => $status, 'msg' => $msg));
}
} else {
$status = 'Error';
$msg = 'Not found POST value';
echo Zend_Json::encode(array('status' => $status, 'msg' => $msg));
}
}
