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));
 }
示例#3
0
 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));
     }
 }
示例#4
0
 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);
 }