/**
* Parse and compile the template file. Templates generated in protected/viewc folder
* @param string $file Template file name without extension .html
* @param string $vfilename Full path of the template file
* @param string $cfilename Full path of the compiled file to be saved
*/
protected function compile($file, $vfilename, $cfilename)
{
$this->mainRenderFolder = $file;
//--------------------------- Parsing -----------------------------
//if no compiled file exist or compiled file is older, generate new one
$str = $this->compileTags(file_get_contents($vfilename));
Doo::loadHelper('DooFile');
$fileManager = new DooFile(0777);
$fileManager->create($cfilename, $str, 'w+');
}
/**
* Save the uploaded image(s) in HTTP File Upload variables
*
* @param string $filename The file field name in $_FILES HTTP File Upload variables
* @param string $rename Rename the uploaded file (without extension)
* @return string|array The file name of the uploaded image.
*/
public function uploadImage($filename, $rename = '')
{
$img = !empty($_FILES[$filename]) ? $_FILES[$filename] : null;
if ($img == Null) {
return;
}
if (!file_exists($this->uploadPath)) {
Doo::loadHelper('DooFile');
$fileManager = new DooFile(0777);
$fileManager->create($this->uploadPath);
}
if (is_array($img['name']) === False) {
$pic = strrpos($img['name'], '.');
$ext = strtolower(substr($img['name'], $pic + 1));
if ($this->timeAsName) {
$newName = time() . '-' . mt_rand(1000, 9999) . '.' . $ext;
} else {
$newName = $img['name'];
}
if ($rename == '') {
$imgPath = $this->uploadPath . $newName;
} else {
$imgPath = $this->uploadPath . $rename . '.' . $ext;
}
if (move_uploaded_file($img['tmp_name'], $imgPath)) {
return $rename == '' ? $newName : $rename . '.' . $ext;
}
} else {
$uploadImagesPath = array();
foreach ($img['error'] as $k => $error) {
if (empty($img['name'][$k])) {
continue;
}
if ($error == UPLOAD_ERR_OK) {
$pic = strrpos($img['name'][$k], '.');
$ext = strtolower(substr($img['name'][$k], $pic + 1));
if ($this->timeAsName) {
$newName = time() . '-' . mt_rand(1000, 9999) . '_' . $k . '.' . $ext;
} else {
$newName = $img['name'][$k];
}
if ($rename == '') {
$imgPath = $this->uploadPath . $newName;
} else {
$imgPath = $this->uploadPath . $rename . '_' . $k . '.' . $ext;
}
if (move_uploaded_file($img['tmp_name'][$k], $imgPath)) {
$uploadImagesPath[] = $newName;
}
} else {
return false;
}
}
return $uploadImagesPath;
}
}
public static function genPgSQL($path = null)
{
if ($path === null) {
$path = Doo::conf()->SITE_PATH . Doo::conf()->PROTECTED_FOLDER . 'model/';
}
Doo::loadHelper('DooFile');
$fileManager = new DooFile(0777);
$dbconf = Doo::db()->getDefaultDbConfig();
$dbSchema = $dbconf[6];
$dbname = $dbconf[1];
echo "<html><head><title>DooPHP Model Generator - DB: {$dbname}</title></head><body bgcolor=\"#2e3436\">";
$smt = Doo::db()->query("SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = '{$dbSchema}'");
$tables = $smt->fetchAll();
foreach ($tables as $tbl) {
$tblname = $tbl["name"];
//tablename
//Get table description
$smt2 = Doo::db()->query("SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null,\n column_default AS default, ordinal_position AS position, character_maximum_length AS char_length,\n character_octet_length AS oct_length FROM information_schema.columns\n WHERE table_name = '{$tblname}' AND table_schema = '{$dbSchema}' ORDER BY position");
$fields = $smt2->fetchAll();
//Get primary key
$smt3 = Doo::db()->query("SELECT relname, indkey\n FROM pg_class, pg_index\n WHERE pg_class.oid = pg_index.indexrelid\n AND pg_class.oid IN (\n SELECT indexrelid\n FROM pg_index, pg_class\n WHERE pg_class.relname='{$tblname}'\n AND pg_class.oid=pg_index.indrelid\n AND indisprimary = 't')");
//indkey
$fields3 = $smt3->fetchAll();
$smt4 = Doo::db()->query("SELECT t.relname, a.attname, a.attnum\n FROM pg_index c\n LEFT JOIN pg_class t\n ON c.indrelid = t.oid\n LEFT JOIN pg_attribute a\n ON a.attrelid = t.oid\n AND a.attnum = ANY(indkey)\n WHERE t.relname = '{$tblname}'\n AND a.attnum = {$fields3[0]['indkey']}");
$fields4 = $smt4->fetchAll();
$pkey = $fields4[0]['attname'];
//Prepare model class
$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";
$fieldnames = array();
foreach ($fields as $f) {
$filestr .= " public \${$f['name']};\n";
$fieldnames[] = $f['name'];
}
$fieldnames = implode($fieldnames, "','");
$filestr .= " public \$_table = '{$tblname}';\n";
$filestr .= " public \$_primarykey = '{$pkey}';\n";
$filestr .= " public \$_fields = array('{$fieldnames}');\n";
$filestr .= "}\n?>";
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/>";
}
}
$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>";
}
/**
* Write to file.
* If rotate file size is set, logs and profiles are automatically rotate when the file size is reached.
* @param string $data Data string to be logged
* @param string $filename File name for the log/profile
*/
protected function writeToFile($data, $filename)
{
//only write to file if there's a record
if ($data != NULL) {
$mode = 'a+';
if (isset(Doo::conf()->LOG_PATH)) {
$filename = Doo::conf()->LOG_PATH . $filename;
}
if ($this->rotate_size != 0) {
if (file_exists($filename) && filesize($filename) > $this->rotate_size) {
$mode = 'w+';
}
}
Doo::loadHelper('DooFile');
$file = new DooFile(0777);
$file->create($filename, $data, $mode);
}
}
/**
* Write to file.
* If rotate file size is set, logs and profiles are automatically rotate when the file size is reached.
* @param string $data Data string to be logged
* @param string $filename File name for the log/profile
*/
protected function writeToFile($data, $filename)
{
//aising 20151020 logpath addpend category
$subPath = '';
if (isset($this->_logs[0][2])) {
$subPath = $this->_logs[0][2];
}
$filename = $subPath . DIRECTORY_SEPARATOR . $filename;
//only write to file if there's a record
if ($data != NULL) {
$mode = 'a+';
if (isset(Doo::conf()->LOG_PATH)) {
$filename = Doo::conf()->LOG_PATH . $filename;
}
if ($this->rotate_size != 0) {
if (file_exists($filename) && filesize($filename) > $this->rotate_size) {
$mode = 'w+';
}
}
Doo::loadHelper('DooFile');
$file = new DooFile(0777);
$file->create($filename, $data, $mode);
}
}
/**
* Save the result into file system in JSON format. By default, it creates and stores in a folder named 'bdd_result'
* @param string $path Path to store the results.
* @param bool $flatten To flatten the result. If true, everything will be saved in a single file. Else, it will be stored seperately with its section name.
*/
protected function saveResult($path = null, $flatten = true)
{
if ($path === null) {
$path = Doo::conf()->SITE_PATH . Doo::conf()->PROTECTED_FOLDER . 'bdd_result/';
}
if ($flatten) {
$f = new DooFile();
$f->create($path . '/all_results.json', $this->toJSON($this->flattenResult()));
} else {
foreach ($this->result as $section => $rs) {
$f = new DooFile();
$f->create($path . '/' . $section . '.json', $this->toJSON($rs));
}
}
}
private function export()
{
set_time_limit(0);
$id = Lua::get('id');
$id = intval($id);
$db = Lua::get_one("select * from lua_channel where id='{$id}'");
if (empty($db)) {
Lua::admin_msg('错误提示', '所要导出的频道不存在');
}
Doo::loadHelper('DooFile');
$fileManager = new DooFile(0777);
Doo::cache('php')->hashing = false;
$old_dir = LUA_ROOT . ADMIN_ROOT . '/cache/';
// 第一步 频道数据
Doo::cache('php')->set('channel', $db);
// 第二步 模型数据
$list = Lua::get_more("select * from lua_model where cid='{$id}'");
Doo::cache('php')->set('model', $list);
// 第三步 数据表数据
if ($list) {
$dumpsql = '';
Doo::db()->query("SET SQL_QUOTE_SHOW_CREATE=1");
foreach ($list as $v) {
$table = Lua::get_more("select * from lua_model_table where model_id='" . $v['id'] . "'");
Doo::cache('php')->set('model.' . $v['id'], $table);
// 第四步 字段数据
if ($table) {
foreach ($table as $k) {
$field = Lua::get_more("select * from lua_model_field where model_id='" . $v['id'] . "' and table_id='" . $k['id'] . "'");
Doo::cache('php')->set('field.' . $v['id'] . '.' . $k['id'], $field);
// 第五步 创建数据表
$r = Doo::db()->fetchRow("SHOW CREATE TABLE `" . $k['tablename'] . "`;");
$create = str_replace("\"", "\\\"", $r['Create Table']);
$dumpsql .= "\r\nDoo::db()->query(\"" . $create . "\");\r\n";
// 第六步 导出数据
$data = Lua::get_more("select * from " . $k['tablename']);
Doo::cache('php')->set('data.' . $k['id'], $data);
}
}
}
$fileManager->create($old_dir . 'create.php', '<?php' . $dumpsql . '?>');
}
// 第七步 栏目数据
$list = Lua::get_more("select * from lua_category where systemname='" . $db['path'] . "'");
Doo::cache('php')->set('cate', $list);
$list = Lua::get_more("select * from lua_piece where systemname='" . $db['path'] . "'");
Doo::cache('php')->set('piece', $list);
// 第八步 打包数据
$new_dir = LUA_ROOT . $db['path'] . '/cache/update/';
$fileManager->copy($old_dir, $new_dir);
// 第九步 删除数据
$fileManager->delete($old_dir, false);
Lua::admin_msg('提示信息', '导出成功', './channel.htm');
}
public function _doit()
{
$dirs = date('Y-m-d');
$path = $this->cache . $dirs . '/';
$configFile = $path . 'config.php';
Doo::loadHelper('DooFile');
$fileManager = new DooFile(0777);
if (!file_exists($configFile)) {
if (!file_exists($path)) {
$fileManager->create($path);
}
$tables = Doo::db()->fetchAll("SHOW TABLE STATUS");
$b_table = $d_table = '';
foreach ($tables as $row) {
$b_table .= $row['Name'] . ",";
$d_table .= "\$tb['" . $row['Name'] . "']=0;\r\n";
}
$b_table = substr($b_table, 0, strlen($b_table) - 1);
$string = "<?php\r\n\$b_table=\"" . $b_table . "\";\r\n" . $d_table . "?>";
$fileManager->create($configFile, $string);
$this->jsonp('写入配置文件 ...');
} else {
include $configFile;
}
$btb = explode(",", $b_table);
$count = count($btb);
$t = intval(Lua::post('t'));
$s = intval(Lua::post('s'));
$p = intval(Lua::post('p'));
$alltotal = intval(Lua::post('alltotal'));
$fnum = intval(Lua::post('fnum'));
$dumpsql = '';
if ($t >= $count) {
echo 'success';
exit;
}
if (empty($s)) {
$num = Doo::db()->fetchRow("SHOW TABLE STATUS LIKE '" . $btb[$t] . "';");
$num = $num['Rows'];
$dumpsql .= "self::query(\"DROP TABLE IF EXISTS `" . $btb[$t] . "`;\");\r\n";
Doo::db()->query("SET SQL_QUOTE_SHOW_CREATE=1");
$r = Doo::db()->fetchRow("SHOW CREATE TABLE `" . $btb[$t] . "`;");
$create = str_replace("\"", "\\\"", $r['Create Table']);
$dumpsql .= "self::create(\"" . $create . "\");\r\n";
} else {
$num = (int) $alltotal;
}
$fields = Doo::db()->fetchAll("SHOW FIELDS FROM `" . $btb[$t] . "`");
if (empty($fnum)) {
$field_num = count($fields);
} else {
$field_num = $fnum;
}
$b = 0;
$list = Doo::db()->fetchAll("select * from `" . $btb[$t] . "` limit {$s},{$num}");
if ($list) {
foreach ($list as $v) {
$b = 1;
$s++;
$dumpsql .= "self::query(\"replace into `" . $btb[$t] . "` values(";
$first = 1;
for ($i = 0; $i < $field_num; $i++) {
if (empty($first)) {
$dumpsql .= ',';
} else {
$first = 0;
}
$_field_name = $fields[$i]['Field'];
if (!isset($v[$_field_name])) {
$dumpsql .= 'NULL';
} else {
$dumpsql .= '\'' . Lua::clean($v[$_field_name]) . '\'';
}
}
$dumpsql .= ");\");\r\n";
if (strlen($dumpsql) >= 2048 * 1024) {
$p++;
$sfile = $path . "/" . $btb[$t] . "_" . $p . ".php";
$fileManager->create($sfile, "<?php\r\n" . $dumpsql . "?>");
$this->jsonp('Table Name : <b>' . $btb[$t] . '</b><br />Table : <b>' . ($t + 1) . '/' . $count . '</b><br />Record : <b>' . $s . '/' . $num . '</b><br />备份一组数据成功，正在进入下一组．．．．．．', $s, $p, $t, $alltotal, $fnum);
}
}
}
if (empty($p) || $b == 1) {
$p++;
$sfile = $path . "/" . $btb[$t] . "_" . $p . ".php";
$fileManager->create($sfile, "<?php\r\n" . $dumpsql . "?>");
}
if (empty($p)) {
$p = 0;
}
$text = $fileManager->readFileContents($configFile);
$rep1 = "\$tb['" . $btb[$t] . "']=0;";
$rep2 = "\$tb['" . $btb[$t] . "']=" . $p . ";";
$text = str_replace($rep1, $rep2, $text);
$fileManager->create($configFile, $text);
$t++;
$this->jsonp('备份' . $btb[$t - 1] . '表成功，正在进入下一个表备份．．．．．．', 0, 0, $t, 0, 0);
}
