/**
* Generates Model class files from a MySQL database
* @param bool $comments Generate comments along with the Model class
* @param bool $vrules Generate validation rules along with the Model class
* @param string $extends make Model class to extend DooModel or DooSmartModel
* @param bool $createBase Generate base model class, will not rewrite/replace model classes if True.
* @param string $baseSuffix Suffix string for the base model.
* @param int $chmod Chmod for file manager
* @param string $path Path to write the model class files
*/
public static function genMySQL($comments = true, $vrules = true, $extends = 'DooModel', $createBase = true, $baseSuffix = 'Base', $chmod = null, $path = null)
{
if ($path === null) {
$path = Doo::conf()->SITE_PATH . Doo::conf()->PROTECTED_FOLDER . 'model/';
}
Doo::loadHelper('DooFile');
if ($chmod === null) {
$fileManager = new DooFile();
} else {
$fileManager = new DooFile($chmod);
}
$dbconf = Doo::db()->getDefaultDbConfig();
if (!isset($dbconf) || empty($dbconf)) {
echo "<html><head><title>DooPHP Model Generator - DB: Error</title></head><body bgcolor=\"#2e3436\"><span style=\"font-size:190%;font-family: 'Courier New', Courier, monospace;\"><span style=\"color:#fff;\">Please setup the DB first in index.php and db.conf.php</span></span>";
exit;
}
$dbname = $dbconf[1];
echo "<html><head><title>DooPHP Model Generator - DB: {$dbname}</title></head><body bgcolor=\"#2e3436\">";
$smt = Doo::db()->query("SHOW TABLES");
$tables = $smt->fetchAll();
$clsExtendedNum = 0;
foreach ($tables as $tbl) {
if (stristr($_SERVER['SERVER_SOFTWARE'], 'Win32')) {
$tblname = $tbl['Tables_in_' . strtolower($dbname)];
} else {
$tblname = $tbl['Tables_in_' . $dbname];
}
$smt2 = null;
unset($smt2);
$smt2 = Doo::db()->query("DESC `{$tblname}`");
$fields = $smt2->fetchAll();
//print_r($fields);
$classname = '';
$temptbl = $tblname;
for ($i = 0; $i < strlen($temptbl); $i++) {
if ($i == 0) {
$classname .= strtoupper($temptbl[0]);
} else {
if ($temptbl[$i] == '_' || $temptbl[$i] == '-' || $temptbl[$i] == '.') {
$classname .= strtoupper($temptbl[$i + 1]);
$arr = str_split($temptbl);
array_splice($arr, $i, 1);
$temptbl = implode('', $arr);
} else {
$classname .= $temptbl[$i];
}
}
}
if (!empty($extends)) {
if ($createBase != True) {
if ($extends == DooModelGen::EXTEND_MODEL || $extends == DooModelGen::EXTEND_SMARTMODEL) {
$filestr = "<?php\nDoo::loadCore('db/{$extends}');\n\nclass {$classname} extends {$extends}{\n";
} else {
$filestr = "<?php\nDoo::loadClass('{$extends}');\n\nclass {$classname} extends {$extends}{\n";
}
} else {
if ($extends == DooModelGen::EXTEND_MODEL || $extends == DooModelGen::EXTEND_SMARTMODEL) {
$filestr = "<?php\nDoo::loadCore('db/{$extends}');\n\nclass {$classname}{$baseSuffix} extends {$extends}{\n";
} else {
$filestr = "<?php\nDoo::loadClass('{$extends}');\n\nclass {$classname}{$baseSuffix} extends {$extends}{\n";
}
}
} else {
if ($createBase != True) {
$filestr = "<?php\nclass {$classname}{\n";
} else {
$filestr = "<?php\nclass {$classname}{$baseSuffix}{\n";
}
}
$pkey = '';
$ftype = '';
$fieldnames = array();
if ($vrules) {
Doo::loadHelper('DooValidator');
}
$rules = array();
foreach ($fields as $f) {
$fstring = '';
if ($comments && isset($f['Type']) && !empty($f['Type'])) {
preg_match('/([^\\(]+)[\\(]?([\\d]*)?[\\)]?(.+)?/', $f['Type'], $ftype);
$length = '';
$more = '';
if (isset($ftype[2]) && !empty($ftype[2])) {
$length = " Max length is {$ftype['2']}.";
}
if (isset($ftype[3]) && !empty($ftype[3])) {
$more = " {$ftype['3']}.";
$ftype[3] = trim($ftype[3]);
}
$fstring = "\n /**\n * @var {$ftype[1]}{$length}{$more}\n */\n";
//-------- generate rules for the setupValidation() in Model ------
if ($vrules) {
$rule = array();
if ($rulename = DooValidator::dbDataTypeToRules(strtolower($ftype[1]))) {
$rule = array(array($rulename));
}
if (isset($ftype[3]) && $ftype[3] == 'unsigned') {
$rule[] = array('min', 0);
}
if (ctype_digit($ftype[2])) {
if ($ftype[1] == 'varchar' || $ftype[1] == 'char') {
$rule[] = array('maxlength', intval($ftype[2]));
} else {
if ($rulename == 'integer') {
$rule[] = array('maxlength', intval($ftype[2]));
}
}
}
if (strtolower($f['Null']) == 'no' && strpos(strtolower($f['Extra']), 'auto_increment') === false) {
$rule[] = array('notnull');
} else {
$rule[] = array('optional');
}
if (isset($rule[0])) {
$rules[$f['Field']] = $rule;
}
}
}
$filestr .= "{$fstring} public \${$f['Field']};\n";
$fieldnames[] = $f['Field'];
if ($f['Key'] == 'PRI') {
$pkey = $f['Field'];
}
}
$fieldnames = implode($fieldnames, "','");
$filestr .= "\n public \$_table = '{$tblname}';\n";
$filestr .= " public \$_primarykey = '{$pkey}';\n";
$filestr .= " public \$_fields = array('{$fieldnames}');\n";
if ($vrules && !empty($rules)) {
$filestr .= "\n public function getVRules() {\n return " . self::exportRules($rules) . "\n }\n\n";
if (empty($extends)) {
$filestr .= " public function validate(\$checkMode='all'){\n\t\t//You do not need this if you extend DooModel or DooSmartModel\n\t\t//MODE: all, all_one, skip\n\t\tDoo::loadHelper('DooValidator');\n\t\t\$v = new DooValidator;\n\t\t\$v->checkMode = \$checkMode;\n\t\treturn \$v->validate(get_object_vars(\$this), \$this->getVRules());\n\t}\n\n";
}
}
$filestr .= "}";
if ($createBase != True) {
if ($fileManager->create($path . "{$classname}.php", $filestr, 'w+')) {
echo "<span style=\"font-size:190%;font-family: 'Courier New', Courier, monospace;\"><span style=\"color:#fff;\">Model for table </span><strong><span style=\"color:#e7c118;\">{$tblname}</span></strong><span style=\"color:#fff;\"> generated. File - </span><strong><span style=\"color:#729fbe;\">{$classname}</span></strong><span style=\"color:#fff;\">.php</span></span><br/><br/>";
} else {
echo "<span style=\"font-size:190%;font-family: 'Courier New', Courier, monospace;\"><span style=\"color:#f00;\">Model for table </span><strong><span style=\"color:#e7c118;\">{$tblname}</span></strong><span style=\"color:#f00;\"> could not be generated. File - </span><strong><span style=\"color:#729fbe;\">{$classname}</span></strong><span style=\"color:#f00;\">.php</span></span><br/><br/>";
}
} else {
if ($fileManager->create($path . "base/{$classname}{$baseSuffix}.php", $filestr, 'w+')) {
echo "<span style=\"font-size:190%;font-family: 'Courier New', Courier, monospace;\"><span style=\"color:#fff;\">Base model for table </span><strong><span style=\"color:#e7c118;\">{$tblname}</span></strong><span style=\"color:#fff;\"> generated. File - </span><strong><span style=\"color:#729fbe;\">{$classname}{$baseSuffix}</span></strong><span style=\"color:#fff;\">.php</span></span><br/><br/>";
$clsfile = $path . "{$classname}.php";
if (!file_exists($clsfile)) {
$filestr = "<?php\nDoo::loadModel('base/{$classname}{$baseSuffix}');\n\nclass {$classname} extends {$classname}{$baseSuffix}{\n}";
if ($fileManager->create($clsfile, $filestr, 'w+')) {
echo "<span style=\"font-size:190%;font-family: 'Courier New', Courier, monospace;\"><span style=\"color:#fff;\">Model for table </span><strong><span style=\"color:#e7c118;\">{$tblname}</span></strong><span style=\"color:#fff;\"> generated. File - </span><strong><span style=\"color:#729fbe;\">{$classname}</span></strong><span style=\"color:#fff;\">.php</span></span><br/><br/>";
$clsExtendedNum++;
} else {
echo "<span style=\"font-size:190%;font-family: 'Courier New', Courier, monospace;\"><span style=\"color:#f00;\">Model for table </span><strong><span style=\"color:#e7c118;\">{$tblname}</span></strong><span style=\"color:#f00;\"> could not be generated. File - </span><strong><span style=\"color:#729fbe;\">{$classname}</span></strong><span style=\"color:#f00;\">.php</span></span><br/><br/>";
}
}
} else {
echo "<span style=\"font-size:190%;font-family: 'Courier New', Courier, monospace;\"><span style=\"color:#f00;\">Base model for table </span><strong><span style=\"color:#e7c118;\">{$tblname}</span></strong><span style=\"color:#f00;\"> could not be generated. File - </span><strong><span style=\"color:#729fbe;\">{$classname}{$baseSuffix}</span></strong><span style=\"color:#f00;\">.php</span></span><br/><br/>";
}
}
}
$total = sizeof($tables) + $clsExtendedNum;
echo "<span style=\"font-size:190%;font-family: 'Courier New', Courier, monospace;color:#fff;\">Total {$total} file(s) generated.</span></body></html>";
}
/**
* Generates Model class files from a MySQL database
* @param bool $comments Generate comments along with the Model class
*/
public static function gen_mysql($comments = true, $vrules = true)
{
$dbconf = Doo::db()->getDefaultDbConfig();
if (!isset($dbconf) || empty($dbconf)) {
echo "<html><head><title>DooPHP Model Generator - DB: Error</title></head><body bgcolor=\"#2e3436\"><span style=\"font-size:190%;font-family: 'Courier New', Courier, monospace;\"><span style=\"color:#fff;\">Please setup the DB first in index.php and db.conf.php</span></span>";
exit;
}
$dbname = $dbconf[1];
echo "<html><head><title>DooPHP Model Generator - DB: {$dbname}</title></head><body bgcolor=\"#2e3436\">";
$smt = Doo::db()->query("SHOW TABLES");
$tables = $smt->fetchAll();
foreach ($tables as $tbl) {
if (stristr($_SERVER['SERVER_SOFTWARE'], 'Win32')) {
$tblname = $tbl['Tables_in_' . strtolower($dbname)];
} else {
$tblname = $tbl['Tables_in_' . $dbname];
}
$smt2 = Doo::db()->query("DESC `{$tblname}`");
$fields = $smt2->fetchAll();
//print_r($fields);
$classname = '';
$temptbl = $tblname;
for ($i = 0; $i < strlen($temptbl); $i++) {
if ($i == 0) {
$classname .= strtoupper($temptbl[0]);
} else {
if ($temptbl[$i] == '_' || $temptbl[$i] == '-' || $temptbl[$i] == '.') {
$classname .= strtoupper($temptbl[$i + 1]);
$arr = str_split($temptbl);
array_splice($arr, $i, 1);
$temptbl = implode('', $arr);
} else {
$classname .= $temptbl[$i];
}
}
}
$filestr = "<?php\nclass {$classname}{\n";
$pkey = '';
$ftype = '';
$fieldnames = array();
if ($vrules) {
Doo::loadHelper('DooValidator');
}
$rules = array();
foreach ($fields as $f) {
$fstring = '';
if ($comments && isset($f['Type']) && !empty($f['Type'])) {
preg_match('/([^\\(]+)[\\(]?([\\d]*)?[\\)]?(.+)?/', $f['Type'], $ftype);
$length = '';
$more = '';
if (isset($ftype[2]) && !empty($ftype[2])) {
$length = " Max length is {$ftype['2']}.";
}
if (isset($ftype[3]) && !empty($ftype[3])) {
$more = " {$ftype['3']}.";
$ftype[3] = trim($ftype[3]);
}
$fstring = "\n /**\n * @var {$ftype[1]}{$length}{$more}\n */\n";
//-------- generate rules for the setupValidation() in Model ------
if ($vrules) {
$rule = array();
if ($rulename = DooValidator::dbDataTypeToRules(strtolower($ftype[1]))) {
$rule = array(array($rulename));
}
if (isset($ftype[3]) && $ftype[3] == 'unsigned') {
$rule[] = array('min', 0);
}
if (ctype_digit($ftype[2])) {
if ($ftype[1] == 'varchar' || $ftype[1] == 'char') {
$rule[] = array('maxlength', intval($ftype[2]));
} else {
if ($rulename == 'integer') {
$rule[] = array('maxlength', intval($ftype[2]));
}
}
}
if (strtolower($f['Null']) == 'no') {
$rule[] = array('notnull');
} else {
$rule[] = array('optional');
}
if (isset($rule[0])) {
$rules[$f['Field']] = $rule;
}
}
}
$filestr .= "{$fstring} public \${$f['Field']};\n";
$fieldnames[] = $f['Field'];
if ($f['Key'] == 'PRI') {
$pkey = $f['Field'];
}
}
$fieldnames = implode($fieldnames, "','");
$filestr .= "\n public \$_table = '{$tblname}';\n";
$filestr .= " public \$_primarykey = '{$pkey}';\n";
$filestr .= " public \$_fields = array('{$fieldnames}');\n";
if ($vrules && isset($rules) && !empty($rules)) {
$filestr .= "\n public function getVRules() {\n return " . self::exportRules($rules) . "\n }\n\n";
$filestr .= " public function validate(\$checkMode='all'){\r\n //You do not need this if you extend DooModel or DooSmartModel\r\n //MODE: all, all_one, skip\r\n Doo::loadHelper('DooValidator');\r\n \$v = new DooValidator;\r\n \$v->checkMode = \$checkMode;\r\n return \$v->validate(get_object_vars(\$this), \$this->getVRules());\r\n }\n\n";
}
$filestr .= "}\n?>";
$handle = fopen(Doo::conf()->SITE_PATH . "/protected/model/{$classname}.php", 'w+');
fwrite($handle, $filestr);
fclose($handle);
echo "<span style=\"font-size:190%;font-family: 'Courier New', Courier, monospace;\"><span style=\"color:#fff;\">Model for table </span><strong><span style=\"color:#e7c118;\">{$tblname}</span></strong><span style=\"color:#fff;\"> generated. File - </span><strong><span style=\"color:#729fbe;\">{$classname}</span></strong><span style=\"color:#fff;\">.php</span></span><br/><br/>";
//print_r($rules);
}
$total = sizeof($tables);
echo "<span style=\"font-size:190%;font-family: 'Courier New', Courier, monospace;color:#fff;\">Total {$total} file(s) generated.</span></body></html>";
}
