Пример #1
0
 /**
  * 通过分析控制器文件,获取指定模块的控制器信息,并入库
  * @param integer $amcaId
  * @return void
  */
 public function synch($amcaId)
 {
     Log::echoTrace('Synch Begin ...');
     // 从数据库中读取模块数据
     Log::echoTrace('Query mod from table Begin ...');
     $ret = $this->findByPk($amcaId);
     if ($ret['err_no'] !== ErrorNo::SUCCESS_NUM) {
         Log::errExit(__LINE__, 'Query mod from table Failed!');
     }
     $mod = $ret['data'];
     if (!$this->isMod($mod['category'])) {
         Log::errExit(__LINE__, 'Amcas must be "' . DataAmcas::CATEGORY_MOD . '" category!');
     }
     Log::echoTrace('Query mod from table Successfully');
     // 从数据库中读取应用数据
     Log::echoTrace('Query app from table Begin ...');
     $ret = $this->findByPk($mod['amca_pid']);
     if ($ret['err_no'] !== ErrorNo::SUCCESS_NUM) {
         Log::errExit(__LINE__, 'Query app from table Failed!');
     }
     $app = $ret['data'];
     Log::echoTrace('Query app from table Successfully');
     $appName = $app['amca_name'];
     $modName = $mod['amca_name'];
     $modId = $mod['amca_id'];
     // 从数据库中读取控制器数据
     Log::echoTrace('Query ctrls from table Begin ...');
     $ret = $this->findAllByAmcaPid($modId);
     if ($ret['err_no'] !== ErrorNo::SUCCESS_NUM) {
         Log::errExit(__LINE__, 'Query ctrls from table Failed!');
     }
     $dbCtrls = array();
     foreach ($ret['data'] as $rows) {
         $dbCtrls[$rows['amca_name']] = $rows;
     }
     Log::echoTrace('Query ctrls from table Successfully');
     // 从文件中读取控制器数据
     Log::echoTrace('Query ctrls from files Begin ...');
     $fileManager = new FileManager();
     $directory = DIR_ROOT . DS . 'app' . DS . $appName . DS . 'modules' . DS . $modName . DS . 'controller';
     if (!$fileManager->isDir($directory)) {
         Log::errExit(__LINE__, sprintf('Ctrl Path "%s" is not a valid directory.', $directory));
     }
     $ctrls = array();
     $sort = 0;
     $filePaths = $fileManager->scanDir($directory);
     foreach ($filePaths as $filePath) {
         $ctrlName = basename($filePath, '.php');
         if ($ctrlName === 'index.html') {
             continue;
         }
         $clsName = 'modules\\' . $modName . '\\controller\\' . $ctrlName;
         require_once $filePath;
         $reflector = new \ReflectionClass($clsName);
         $amcaName = strtolower(substr($ctrlName, 0, -10));
         $prompt = preg_replace('/.+class\\s+file\\s+\\*\\s+(\\S+)\\s+\\*\\s+\\@author.+/is', '\\1', $reflector->getDocComment());
         $ctrls[$amcaName] = array('amca_pid' => $modId, 'amca_name' => $amcaName, 'prompt' => $prompt, 'sort' => $sort++, 'category' => DataAmcas::CATEGORY_CTRL);
     }
     Log::echoTrace('Query ctrls from files Successfully');
     Log::echoTrace('Analyser db and files Begin ...');
     $amcas = array('insert' => array(), 'update' => array(), 'delete' => array());
     foreach ($ctrls as $amcaName => $rows) {
         if (isset($dbCtrls[$amcaName])) {
             if ($dbCtrls[$amcaName]['prompt'] != $rows['prompt'] || $dbCtrls[$amcaName]['sort'] != $rows['sort']) {
                 $amcas['update'][$dbCtrls[$amcaName]['amca_id']] = $rows;
             }
         } else {
             $amcas['insert'][] = $rows;
         }
     }
     foreach ($dbCtrls as $amcaName => $rows) {
         if (!isset($ctrls[$amcaName])) {
             $amcas['delete'][] = $rows['amca_id'];
         }
     }
     Log::echoTrace('Analyser db and files Successfully');
     $dbAmcas = new DbAmcas();
     Log::echoTrace('Import to db Begin ...');
     foreach ($amcas['insert'] as $attributes) {
         $ret = $dbAmcas->create($attributes);
         if (!$ret) {
             Log::errExit(__LINE__, sprintf('Insert to table "%s" Failed!', $attributes['amca_name']));
         }
         Log::echoTrace(sprintf('Insert into table "%s" Successfully', $attributes['amca_name']));
     }
     foreach ($amcas['update'] as $amcaId => $attributes) {
         $ret = $dbAmcas->modifyByPk($amcaId, $attributes);
         if (!$ret) {
             Log::errExit(__LINE__, sprintf('Update table "%s" Failed!', $attributes['amca_name']));
         }
         Log::echoTrace(sprintf('Update table "%s" Successfully', $attributes['amca_name']));
     }
     foreach ($amcas['delete'] as $amcaId) {
         $ret = $dbAmcas->removeByPk($amcaId);
         if (!$ret) {
             Log::errExit(__LINE__, sprintf('Delete from table "%d" Failed!', $amcaId));
         }
         Log::echoTrace(sprintf('Delete from "%d" Successfully', $amcaId));
     }
     Log::echoTrace('Import to db Successfully');
     Log::echoTrace('Synch Successfully');
 }
Пример #2
0
 /**
  * 初始化表单字段数据
  * @return instance of modules\builder\model\gc\Schema
  */
 protected function _initValidators()
 {
     $object = Service::getInstance('Validators', self::SRV_NAME);
     $tableName = $object->getTableName();
     Log::echoTrace('Query from ' . $tableName . ' Begin ...');
     foreach ($this->fields as $key => $fields) {
         $data = $object->findAllByAttributes(array('field_id' => $fields['field_id']), 'sort', 0, 1000);
         if ($data === false) {
             Log::errExit(__LINE__, 'Query from ' . $tableName . ' Failed!');
         }
         $temp = array();
         foreach ($data as $rows) {
             $validatorId = (int) $rows['validator_id'];
             $validatorName = trim($rows['validator_name']);
             $temp[$validatorId] = array('validator_id' => $validatorId, 'validator_name' => $validatorName, 'options' => $rows['options'], 'option_category' => strtolower(trim($rows['option_category'])), 'message' => trim($rows['message']), 'when' => strtolower(trim($rows['when'])), 'lang_key' => 'SRV_FILTER_' . $this->upTblName . '_' . $fields['up_field_name'] . '_' . strtoupper($validatorName));
         }
         $this->fields[$key]['validators'] = $temp;
     }
     Log::echoTrace('Query from ' . $tableName . ' Successfully');
     return $this;
 }
Пример #3
0
 /**
  * 通过表Metadata生成Builders数据
  * @param string $tblName
  * @return void
  */
 public function gb($tblName)
 {
     Ap::getResponse()->contentType();
     $tableNames = $this->_metadata->getTableNames($tblName);
     if (!in_array($tblName, $tableNames)) {
         Log::errExit(__LINE__, 'Table Name Not Exists!');
     }
     Log::echoTrace('Generate Begin, Table Name "' . $tblName . '"');
     $tableSchema = $this->_metadata->getTableSchema($tblName);
     $comments = $this->_metadata->getComments($tableSchema->name);
     $tblPrefix = $this->getDbProxy()->getTblprefix();
     $tblPreLen = strlen($tblPrefix);
     Log::echoTrace('Import to builders Begin ...');
     $params = array('builder_name' => isset($comments['__table__']) ? $comments['__table__'] : $tableSchema->name, 'tbl_name' => substr($tableSchema->name, $tblPreLen), 'tbl_profile' => DataBuilders::TBL_PROFILE_N, 'tbl_engine' => DataBuilders::TBL_ENGINE_INNODB, 'tbl_charset' => DataBuilders::TBL_CHARSET_UTF8, 'tbl_comment' => isset($comments['__table__']) ? $comments['__table__'] : '', 'srv_type' => DataBuilders::SRV_TYPE_NORMAL, 'srv_name' => 'undefined', 'app_name' => 'administrator', 'mod_name' => 'undefined', 'ctrl_name' => substr($tableSchema->name, strrpos($tableSchema->name, '_') + 1), 'cls_name' => substr($tableSchema->name, strrpos($tableSchema->name, '_') + 1), 'fk_column' => '', 'act_index_name' => 'index', 'act_view_name' => 'view', 'act_create_name' => 'create', 'act_modify_name' => 'modify', 'act_remove_name' => 'remove', 'index_row_btns' => array(DataBuilders::INDEX_ROW_BTNS_PENCIL, DataBuilders::INDEX_ROW_BTNS_REMOVE), 'description' => '', 'author_name' => UserIdentity::getNick(), 'author_mail' => UserIdentity::getName());
     $mod = Service::getInstance('Builders', $this->_srvName);
     $builderId = $mod->create($params);
     if ($builderId > 0) {
         Log::echoTrace('Import to builders Successfully ...');
     } else {
         $errors = $mod->getErrors();
         Log::errExit(__LINE__, 'Import to builders Failed! ' . serialize($errors));
     }
     Log::echoTrace('Import to builder_fields Begin ...');
     $sort = 0;
     foreach ($tableSchema->columns as $columnSchema) {
         $sort++;
         if ($columnSchema->type === 'integer') {
             $columnLength = $columnSchema->size;
         } elseif (stripos($columnSchema->dbType, 'enum') !== false) {
             $columnLength = str_replace(array('\'', ','), array('', '|'), substr(substr($columnSchema->dbType, 5), 0, -1));
         } elseif (stripos($columnSchema->dbType, 'char') !== false) {
             $columnLength = $columnSchema->size;
         } else {
             $columnLength = '';
         }
         if ($columnSchema->isPrimaryKey) {
             $formRequired = DataFields::FORM_REQUIRED_N;
         } elseif (stripos($columnSchema->dbType, 'enum') !== false) {
             $formRequired = DataFields::FORM_REQUIRED_N;
         } else {
             $formRequired = DataFields::FORM_REQUIRED_Y;
         }
         if ($columnLength === 'y|n') {
             $typeId = 4;
         } elseif (stripos($columnSchema->dbType, 'enum') !== false) {
             $typeId = 5;
         } elseif ($columnSchema->isPrimaryKey) {
             $typeId = 9;
         } elseif ($columnSchema->type === 'integer') {
             $typeId = 2;
         } elseif (in_array($columnSchema->dbType, array('text', 'longtext'))) {
             $typeId = 10;
         } else {
             $typeId = 1;
         }
         $params = array('field_name' => $columnSchema->name, 'column_length' => $columnLength, 'column_auto_increment' => $columnSchema->isAutoIncrement ? DataFields::COLUMN_AUTO_INCREMENT_Y : DataFields::COLUMN_AUTO_INCREMENT_N, 'column_unsigned' => stripos($columnSchema->dbType, 'unsigned') !== false ? DataFields::COLUMN_UNSIGNED_Y : DataFields::COLUMN_UNSIGNED_N, 'column_comment' => isset($comments[$columnSchema->name]) ? $comments[$columnSchema->name] : '', 'builder_id' => $builderId, 'group_id' => 1, 'type_id' => $typeId, 'sort' => $sort, 'html_label' => isset($comments[$columnSchema->name]) ? $comments[$columnSchema->name] : $columnSchema->name, 'form_prompt' => '', 'form_required' => $formRequired, 'form_modifiable' => DataFields::FORM_MODIFIABLE_N, 'index_show' => DataFields::INDEX_SHOW_Y, 'index_sort' => $columnSchema->isPrimaryKey ? 1000 : $sort, 'form_create_show' => $columnSchema->isPrimaryKey ? DataFields::FORM_CREATE_SHOW_N : DataFields::FORM_CREATE_SHOW_Y, 'form_create_sort' => $sort, 'form_modify_show' => $columnSchema->isPrimaryKey ? DataFields::FORM_MODIFY_SHOW_N : DataFields::FORM_MODIFY_SHOW_Y, 'form_modify_sort' => $sort, 'form_search_show' => DataFields::FORM_SEARCH_SHOW_Y, 'form_search_sort' => $sort);
         $mod = Service::getInstance('Fields', $this->_srvName);
         $fieldId = $mod->create($params);
         if ($fieldId > 0) {
             Log::echoTrace('Import to builder_fields "' . $columnSchema->name . '" Successfully ...');
         } else {
             $errors = $mod->getErrors();
             Log::errExit(__LINE__, 'Import to builder_fields "' . $columnSchema->name . '" Failed! ' . serialize($errors));
         }
     }
     Log::echoTrace('Import to builder_fields Successfully ...');
     Log::echoTrace('Generate End, Table Name "' . $tblName . '"');
     exit;
 }