コード例 #1
0
ファイル: ORM.php プロジェクト: veronecrm/veronecrm
 /**
  * @param ServiceContainer $container
  * @param Database         $db
  * @param Routing          $routing
  */
 public function __construct(Container $container, Database $db, Routing $routing)
 {
     $this->connection = $db->connection();
     $this->dbPrefix = $db->prefix();
     $this->module = $routing->getRoute()->getModule();
     $this->repository = new RepositoryManager($this, $container);
     $this->entity = new EntityManager($this);
 }
コード例 #2
0
ファイル: ModuleManager.php プロジェクト: veronecrm/veronecrm
 public function __construct(Container $container, Database $database)
 {
     foreach ($database->query("SELECT * FROM #__package WHERE type = 'module'") as $row) {
         $module = new Module($row['uid'], $row['name']);
         $module->setContainer($container);
         $module->setVersion($row['version']);
         $module->setReleaseDate($row['releaseDate']);
         $module->setAuthorName($row['authorName']);
         $module->setAuthorUrl($row['authorUrl']);
         $module->setLicense($row['license']);
         $this->list[] = $module;
     }
 }
コード例 #3
0
 public function index()
 {
     function convertTableToClass($table)
     {
         $array = explode("_", $table);
         for ($i = 0; isset($array[$i]); $i++) {
             $array[$i] = ucfirst($array[$i]);
         }
         return implode("", $array);
     }
     $DB = empty($_GET['DB']) ? 'DB_MASTER' : $_GET['DB'];
     $conn = \System\database\Database::openConnection($DB);
     $result_table = $conn->query("SHOW TABLES");
     $tables = array();
     while (true) {
         $row = mysqli_fetch_row($result_table);
         if ($row) {
             $tables[] = $row[0];
         } else {
             break;
         }
     }
     mysqli_free_result($result_table);
     foreach ($tables as $table) {
         $result = $conn->query("SHOW COLUMNS FROM {$table}");
         //$className = convertTableToClass($table);
         $className = $table;
         //$string = "<?php class $className extends BaseTable{" . PHP_EOL . "protected function initTable(){ \$this->fields=[" . PHP_EOL;
         $string = "static public function initTable(){ " . PHP_EOL . "\t\treturn [" . PHP_EOL;
         $ai = null;
         if ($result) {
             while ($row = $result->fetch_row()) {
                 $type = 'i';
                 //默认为字符串
                 if (strpos($row[5], "auto_increment") !== false) {
                     $ai = $row[0];
                 }
                 if (strpos($row[1], "int") !== false) {
                     $type = "i";
                 } else {
                     if (strpos($row[1], "char") !== false || strpos($row[1], "date") !== false || strpos($row[1], "text") !== false) {
                         $type = "s";
                     } else {
                         if (strpos($row[1], "decimal") !== false || strpos($row[1], "float") !== false || strpos($row[1], "double") !== false) {
                             $type = "d";
                         }
                     }
                 }
                 $string .= "\t\t\t'{$row['0']}'=> ['type' => '{$type}', 'value' => null]," . PHP_EOL;
             }
             mysqli_free_result($result);
         } else {
             echo $table;
         }
         $string .= "\t\t];" . PHP_EOL . "\t}";
         //"\$this->tableName = '$table';" . PHP_EOL . "\$this->AIField = '$ai';" . PHP_EOL . "}";
         $string2 = "static public function AIField(){ " . PHP_EOL . "\t\treturn '{$ai}';" . PHP_EOL . '	}';
         $filename = "../AppMain/data/{$DB}/{$className}.class.php";
         if (file_exists($filename)) {
             unlink($filename);
         }
         $create = true;
         $source = "<?php" . PHP_EOL . 'namespace AppMain\\data\\' . $DB . ';' . PHP_EOL . "class {$className} {" . PHP_EOL . '	' . $string . PHP_EOL . '	' . $string2 . PHP_EOL . "}" . PHP_EOL;
         if (!dirExists(dirname($filename))) {
             die('创建目录失败!');
         }
         if (file_put_contents($filename, $source)) {
             echo '<p>' . $table . ($create ? '生成类成功' : '修改类成功') . '</p>';
         }
     }
 }