public function addAction() { $this->_helper->layout->disableLayout(); $this->_helper->viewRenderer->setNoRender(true); // require_once APPLICATION_PATH . '/modules/asset/forms/Upgrade.php'; // require_once APPLICATION_PATH . '/modules/asset/models/DbTable/Upgrade.php'; // require_once APPLICATION_PATH . '/modules/asset/models/DbTable/Item.php'; // require_once APPLICATION_PATH . '/modules/user/models/DbTable/Member.php'; $form = new Asset_Form_Upgrade(); if ($this->getRequest()->isPost()) { $formData = $this->getRequest()->getPost(); if ($form->isValid($formData)) { $UpgradeID = $form->getValue('UpgradeID'); $MaTS = $form->getValue('MaTS'); $Username = $form->getValue('Username'); $Manager = $form->getValue('Manager'); $Date = $form->getValue('Date'); $Detail = $form->getValue('Detail'); $upgrade = new Asset_Model_DbTable_Upgrade(); $item = new Asset_Model_DbTable_Item(); $user = new User_Model_DbTable_Member(); $itemInfo = $item->getItemFromMa($MaTS); if ($itemInfo != NULL) { $uname = $user->getMemberFromUsername($Username); if ($uname == NULL) { $status = 'Error'; $msg = 'Not found Username.'; echo Zend_Json::encode(array('status' => $status, 'msg' => $msg)); exit; } $umana = $user->getMemberFromUsername($Manager); if ($umana == NULL) { $status = 'Error'; $msg = 'Not found Manager.'; echo Zend_Json::encode(array('status' => $status, 'msg' => $msg)); exit; } $upgrade->addUpgrade($uname['UserID'], $umana['UserID'], $itemInfo['ItemID'], $Detail, $Date); $status = 'Success'; $msg = 'Upgrade success'; } else { $status = 'Error'; $msg = 'Not found item.'; } } else { $status = 'Error'; $msg = 'POST value format inaild.'; } } else { $status = 'Error'; $msg = 'Not found POST value.'; } echo Zend_Json::encode(array('status' => $status, 'msg' => $msg)); }
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)); }
public function detailAction() { $this->_helper->layout->disableLayout(); $this->_helper->viewRenderer->setNoRender(true); if ($this->getRequest()->isPost()) { $MaTS = $this->getRequest()->getPost('MaTS', -1); // $MaTS = $this->getRequest()->getParam('MaTS',-1); if ($MaTS != -1) { // require_once APPLICATION_PATH . '/modules/asset/models/DbTable/Item.php'; $loan = new Asset_Model_DbTable_Loan(); $ts = new Asset_Model_DbTable_Item(); $usi = new User_Model_DbTable_Member(); $status = 'success'; $data1 = (array) $loan->getLoanFromMa($MaTS); $data2 = (array) $ts->getItemFromMa($MaTS); $data3 = (array) $usi->getMember($data1['UserID']); $data = array('MaTS' => $MaTS, 'TenTS' => $data2['Ten_tai_san'], 'Nguoi_muon' => $data3['FullName'], 'Username' => $data3['Username'], 'Ngay_muon' => $data1['Date'], 'Chi_tiet' => $data1['Detail']); echo Zend_Json::encode(array('status' => $status, 'data' => $data)); } else { $status = 'error'; $msg = 'Not found this item.'; 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)); } }
public function recordsAction() { $this->_helper->layout->disableLayout(); $this->_helper->viewRenderer->setNoRender(true); $this->getResponse()->setHeader('Content-Type', 'application/json'); // require_once APPLICATCION_PATH . '/modules/asset/models/DbTable/Item.php'; $items = new Asset_Model_DbTable_Item(); $sort_column = $this->_getParam('sortname', 'ItemID'); # 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', 'Ma_tai_san'); $search_for = $this->_getParam('query', ''); $mode = (int) $this->_getParam('mode', 1); switch ($mode) { case 1: // list all item $select = $items->select()->order("{$sort_column} {$sort_order}")->limit($limit, $offset); break; case 2: // list all item free $select = $items->select()->where("Status = '0'")->order("{$sort_column} {$sort_order}")->limit($limit, $offset); break; case 3: // list all item busy $select = $items->select()->where("Status = '1'")->order("{$sort_column} {$sort_order}")->limit($limit, $offset); break; case 4: // list all item corrupt $select = $items->select()->where("Status = '2'")->order("{$sort_column} {$sort_order}")->limit($limit, $offset); break; default: $select = $items->select()->order("{$sort_column} {$sort_order}")->limit($limit, $offset); break; } 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. switch ($record['Type']) { case 0: $record['Type'] = 'Bảo mật cao'; break; case 1: $record['Type'] = 'Bảo mật thấp'; break; default: $record['Type'] = '-'; break; } switch ($record['Status']) { case 0: $record['Status'] = 'Có thể mượn'; break; case 1: $record['Status'] = 'Đang cho mượn'; break; case 2: $record['Status'] = 'Hỏng'; break; default: $record['Status'] = '-'; break; } $rows[] = array('id' => $record['ItemID'], 'cell' => $record->toArray()); } $jsonData = array('page' => $page, 'total' => $total, 'rows' => $rows); echo Zend_Json::encode($jsonData); }