コード例 #1
0
ファイル: init_backup.php プロジェクト: YocoZhang/OA-SYS
        $message_bool = true;
    } else {
        $message = '无法还原系统,可能是该备份文件损坏了!';
        $message_bool = false;
    }
    //开启平台
    $oaconfig->save('WEB_ON', '1');
}
/**
 * 删除备份
 * @since 1
 */
if (isset($_GET['del']) == true) {
    $backup_filename = $backup_dir . DS . (int) substr($_GET['del'], 0, -4) . '.zip';
    if (corefile::is_file($backup_filename) == true) {
        if (corefile::delete_file($backup_filename) == true) {
            $message = '删除成功!';
            $message_bool = true;
        }
    }
    if (!$message) {
        $message = '无法删除该备份文件!';
        $message_bool = false;
    }
}
/**
 * 获取备份文件列表
 * @since 1
 */
$table_list = corefile::list_dir($backup_dir, '*.zip');
/**
コード例 #2
0
        $message_bool = false;
    }
}
/**
 * 删除文件
 * @since 1
 */
if (isset($_GET['del']) == true) {
    $del_view = $oapost->view($_GET['del']);
    if ($del_view) {
        $del_view_list = $oapost->view_list_row(null, null, null, null, $post_type, $del_view['post_parent']);
        if ($del_view_list < 2) {
            $del_parent = $oapost->view($del_view['post_parent']);
            if ($del_parent) {
                if ($oapost->del($del_parent['id']) == true) {
                    if (!corefile::delete_file($del_parent['post_url'])) {
                        $message = '无法删除该文件。';
                        $message_bool = false;
                    }
                } else {
                    $message = '无法删除该文件。';
                    $message_bool = false;
                }
            }
        }
        //删除引用ID
        if ($oapost->del($_GET['del']) == true && $message == '') {
            $message = '删除成功。';
            $message_bool = true;
        } else {
            $message = '无法删除该文件。';
コード例 #3
0
ファイル: plug-backup.php プロジェクト: YocoZhang/OA-SYS
/**
 * 生成新的备份文件
 * @since 2
 * @param coredb $db 数据库操作句柄
 * @param string $backup_dir 备份到目录
 * @param string $content_dir 文件数据目录
 * @return string 备份文件路径
 */
function plugbackup(&$db, $backup_dir, $content_dir)
{
    $return = '';
    $bool = false;
    $file_type = 'zip';
    $ls_dir = $backup_dir . DS . substr(sha1(rand(1, 99999)), 0, 8);
    if (!corefile::is_dir($ls_dir)) {
        $ls_sql_dir = $ls_dir . DS . 'sql';
        //创建临时目录
        $bool = corefile::new_dir($ls_dir);
        //创建临时SQL目录
        if ($bool == true) {
            $bool = corefile::new_dir($ls_sql_dir);
        }
        //拷贝文件数据
        if ($bool == true) {
            $bool = corefile::copy_dir($content_dir . DS . 'files', $ls_dir . DS . 'content' . DS . 'files');
        }
        if ($bool == true) {
            $bool = corefile::copy_dir($content_dir . DS . 'logs', $ls_dir . DS . 'content' . DS . 'logs');
        }
        //依次遍历所有数据并拷贝到文件内
        foreach ($db->tables as $k => $v) {
            //创建表目录
            $v_table_dir = $ls_sql_dir . DS . $v;
            if ($bool == true) {
                $bool = corefile::new_dir($v_table_dir);
            } else {
                break;
            }
            //计算表内所有字段数据平均长度,得出最终步长
            $max = 50;
            if ($bool == true) {
                $sql = 'SELECT AVG( LENGTH(`' . implode('`))+AVG(LENGTH(`', $db->fields[$k]) . '`)) as al FROM `' . $v . '`';
                $sth = $db->prepare($sql);
                if ($sth->execute() == true) {
                    $res = (int) $sth->fetchColumn();
                    if ($res > 500) {
                        $max = 20;
                    } elseif ($res > 1000) {
                        $max = 10;
                    } elseif ($res > 5000) {
                        $max = 1;
                    }
                } else {
                    $bool = false;
                    break;
                }
            } else {
                break;
            }
            //遍历数据写入文件
            $p = 0;
            $p_bool = true;
            while ($p_bool) {
                $sql = 'SELECT * FROM `' . $v . '` ORDER BY ' . $db->fields[$k][0] . ' ASC LIMIT ' . $p * $max . ',' . $max;
                $sth = $db->prepare($sql);
                if ($sth->execute() == true) {
                    $res = $sth->fetchAll(PDO::FETCH_ASSOC);
                    if ($res) {
                        $file_content = 'INSERT INTO `' . $v . '`(`' . implode('`,`', array_keys($res[0])) . '`) VALUES';
                        foreach ($res as $v_res) {
                            $file_content .= '(';
                            foreach ($v_res as $v_res_v) {
                                if ($v_res_v == null) {
                                    $file_content .= 'NULL,';
                                } elseif (is_int($v_res_v) == true) {
                                    $file_content .= $v_res_v . ',';
                                } else {
                                    $file_content .= '\'' . $v_res_v . '\',';
                                }
                            }
                            $file_content = substr($file_content, 0, -1);
                            $file_content .= '),';
                        }
                        $file_content = substr($file_content, 0, -1) . ';';
                        $file_table_row = $v_table_dir . DS . $v . '_' . $p . '.sql';
                        $p_bool = corefile::edit_file($file_table_row, $file_content);
                        $bool = $p_bool;
                        $file_content = null;
                    } else {
                        $p_bool = false;
                        $bool = true;
                    }
                } else {
                    $p_bool = false;
                    $bool = false;
                }
                $p += 1;
            }
        }
    }
    //将临时文件压缩为压缩包
    $backup_file = $backup_dir . DS . time() . '.' . $file_type;
    if (corefile::is_file($backup_file)) {
        $bool = corefile::delete_file($backup_file);
    }
    if ($bool == true) {
        $bool = corefile::create_zip($backup_file, $ls_dir);
    }
    if ($bool == true) {
        $return = $backup_file;
    } else {
        //失败删除所有临时文件
        corefile::delete_file($backup_file);
    }
    //删除临时文件
    corefile::delete_dir($ls_dir);
    return $return;
}