如果您想了解phpdisk_total_space的知识，那么本篇文章将是您的不二之选。同时我们将深入剖析ABAPTEXT_CONVERT_XLS_TO_SAPALSM_EXCEL_TO_INTERN
如果您想了解php disk_total_space的知识，那么本篇文章将是您的不二之选。同时我们将深入剖析ABAP TEXT_CONVERT_XLS_TO_SAP ALSM_EXCEL_TO_INTERNAL_TABLE 读取 EXCEL CSV XML TEXT 等文件内容到 SAP 内表、c# – Task_disconnected_while_still_running、CentOS disk space used for directory、clickhouse distributed_ddl_task_timeout 超时的各个方面，并给出实际的案例分析，希望能帮助到您！
本文目录一览：- php disk_total_space
- ABAP TEXT_CONVERT_XLS_TO_SAP ALSM_EXCEL_TO_INTERNAL_TABLE 读取 EXCEL CSV XML TEXT 等文件内容到 SAP 内表
- c# – Task_disconnected_while_still_running
- CentOS disk space used for directory
- clickhouse distributed_ddl_task_timeout 超时
php disk_total_space
我需要关于disk_total_space函数的帮助.
我在我的代码上有这个
<?PHP
$sql="select * from users order by id";
$result=MysqL_query($sql);
while($row=MysqL_fetch_array($result)) {
?>
Name : <?PHP echo $row['name']; ?>
Email : <?PHP echo $row['email']; ?>
diskspace Available : <?PHP
$dir = "C:/xampp/htdocs/freehosting/".$row['name'];
disk_total_space($dir);
} ?>
但是,这为每个用户返回了相同的磁盘空间.
有人可以给我一些启示吗？
谢谢 ：)
解决方法:
我认为您想要的是这样的：
function foldersize($path) {
$total_size = 0;
$files = scandir($path);
foreach($files as $t) {
if (is_dir(rtrim($path, '/') . '/' . $t)) {
if ($t<>"." && $t<>"..") {
$size = foldersize(rtrim($path, '/') . '/' . $t);
$total_size += $size;
}
} else {
$size = filesize(rtrim($path, '/') . '/' . $t);
$total_size += $size;
}
}
return $total_size;
}
function format_size($size) {
$mod = 1024;
$units = explode(' ','B KB MB GB TB PB');
for ($i = 0; $size > $mod; $i++) {
$size /= $mod;
}
return round($size, 2) . ' ' . $units[$i];
}
$SIZE_LIMIT = 5368709120; // 5 GB
$sql="select * from users order by id";
$result=MysqL_query($sql);
while($row=MysqL_fetch_array($result)) {
$disk_used = foldersize("C:/xampp/htdocs/freehosting/".$row['name']);
$disk_remaining = $SIZE_LIMIT - $disk_used;
print 'Name: ' . $row['name'] . '<br>';
print 'diskspace used: ' . format_size($disk_used) . '<br>';
print 'diskspace left: ' . format_size($disk_remaining) . '<br><hr>';
}
编辑：递归函数最初有一个错误.现在,它还应该读取原始文件夹内的文件夹以及这些文件夹内的文件夹,依此类推.
ABAP TEXT_CONVERT_XLS_TO_SAP ALSM_EXCEL_TO_INTERNAL_TABLE 读取 EXCEL CSV XML TEXT 等文件内容到 SAP 内表
读取外部文件内容到 SAP
1. 获取文件路径
请查看另一篇博客：ABAP 获取文件路径的方法
2. 读入文件
方法一：函数 TEXT_CONVERT_XLS_TO_SAP
TEXT_CONVERT_XLS_TO_SAP 函数属于函数组 TRUX，
其他类似的函数如下
示例：
TYPE-POOLS: TRUXS.
PARAMETERS : P_FILE TYPE string.
AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_FILE.
DATA: lv_rc TYPE i.
DATA: lt_file_table TYPE filetable.
CALL METHOD cl_gui_frontend_services=>file_open_dialog
EXPORTING
window_title = ''打开文件''
CHANGING
file_table = lt_file_table
rc = lv_rc.
IF sy-subrc = 0.
READ TABLE lt_file_table INTO DATA(wa_file_table) INDEX 1.
P_FILE = wa_file_table-filename.
ENDIF.
START-OF-SELECTION.
DATA: lt_raw TYPE truxs_t_text_data.
TYPES: BEGIN OF lty_upload,
col1 TYPE C LENGTH 20,
col2 TYPE C LENGTH 20,
END OF lty_upload.
DATA: lt_upload TYPE TABLE OF lty_upload.
DATA: wa_upload TYPE lty_upload.
DATA: lv_file TYPE RLGRAP-FILENAME.
lv_file = p_file. "I_FILENAME 接受的类型不为string，所以要把P_file赋值到lv_file 若想直接传值,定义屏幕字段使用PARAMETERS : P_FILE TYPE RLGRAP-FILENAME
CALL FUNCTION ''TEXT_CONVERT_XLS_TO_SAP''
EXPORTING
* I_FIELD_SEPERATOR =
I_LINE_HEADER = ''X''
I_TAB_RAW_DATA = lt_raw
I_FILENAME = lv_file
TABLES
I_TAB_CONVERTED_DATA = lt_upload
* EXCEPTIONS
* CONVERSION_FAILED = 1
* OTHERS = 2
.
IF SY-SUBRC <> 0.
* Implement suitable error handling here
ENDIF.
LOOP AT lt_upload INTO wa_upload.
WRITE:/ wa_upload-col1,wa_upload-col2.
ENDLOOP.
EXCEL 内容：
运行结果：
方法二：OLE 函数 ALSM_EXCEL_TO_INTERNAL_TABLE
注意 AT NEW ROW AT END OF ROW 的用法，在判断 ROW 值时，其他值会填充成 *；一般复制一个工作区或者使用 FIELD-SYMBOLS
TYPE-POOLS: TRUXS.
PARAMETERS : P_FILE TYPE RLGRAP-FILENAME.
AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_FILE.
DATA: lv_rc TYPE i.
DATA: lt_file_table TYPE filetable.
CALL METHOD cl_gui_frontend_services=>file_open_dialog
EXPORTING
window_title = ''打开文件''
CHANGING
file_table = lt_file_table
rc = lv_rc.
IF sy-subrc = 0.
READ TABLE lt_file_table INTO DATA(wa_file_table) INDEX 1.
P_FILE = wa_file_table-filename.
ENDIF.
START-OF-SELECTION.
TYPES: BEGIN OF lty_upload,
col1 TYPE C LENGTH 20,
col2 TYPE C LENGTH 20,
col3 TYPE C LENGTH 20,
col4 TYPE C LENGTH 20,
END OF lty_upload.
DATA: lt_upload TYPE TABLE OF lty_upload.
DATA: wa_upload TYPE lty_upload.
DATA: lt_file TYPE TABLE OF alsmex_tabline.
CALL FUNCTION ''ALSM_EXCEL_TO_INTERNAL_TABLE''
EXPORTING
filename = p_file
i_begin_col = 1
i_begin_row = 2
i_end_col = 9
i_end_row = 99999
TABLES
intern = lt_file
EXCEPTIONS
inconsistent_parameters = 1
upload_ole = 2
OTHERS = 3.
IF sy-subrc = 0.
PERFORM frm_move_data.
ELSE.
MESSAGE ''读取数据失败，请检查模板！'' TYPE ''E''.
ENDIF.
LOOP AT lt_upload INTO wa_upload.
WRITE:/ wa_upload-col1,wa_upload-col2,wa_upload-col3,wa_upload-col4.
ENDLOOP.
FORM FRM_MOVE_DATA.
DATA: lv_num TYPE I,
lv_filedname TYPE C LENGTH 20.
FIELD-SYMBOLS <FS_field> TYPE ANY.
DATA: wa_cfile TYPE alsmex_tabline. "AT NEW row AT NEW row 会将除ROW的值全部转换成****，所以新建一个工作区保存
CLEAR: wa_upload,lt_upload,lv_num.
LOOP AT lt_file INTO DATA(wa_file).
lv_num = lv_num + 1.
MOVE-CORRESPONDING wa_file to wa_cfile.
AT NEW row. "ROW值开始
CLEAR:lv_num. "新ROW开始时，清空计数
lv_num = lv_num + 1. "清空了lv_num,重新赋值1
lv_filedname = |wa_upload-col{ lv_num }|.
ASSIGN (lv_filedname) TO <FS_field>.
<FS_field> = wa_cfile-value.
ENDAT.
lv_filedname = |wa_upload-col{ lv_num }|.
ASSIGN (lv_filedname) TO <FS_field>.
<FS_field> = wa_cfile-value.
AT END OF row. "ROW结束
lv_filedname = |wa_upload-col{ lv_num }|.
ASSIGN (lv_filedname) TO <FS_field>.
<FS_field> = wa_cfile-value.
APPEND wa_upload TO lt_upload.
ENDAT.
ENDLOOP.
ENDFORM.
EXCEL 内容：
运行结果：
c# – Task_disconnected_while_still_running
Task_disconnected_while_still_running：_server_task_currentState _ = _隐藏,targetState = _Inactive.
这是我有关崩溃的所有信息.我已经尝试实现日志,包装try catch块中的所有主要函数并限制backgroundUploader类中的项目数,但崩溃只是没有减少.我也没有在开发者论坛上找到任何帮助.
请详细说明导致此类崩溃的原因以及如何处理此问题.
先感谢您.
解决方法
public App()
{
InitializeComponent();
UnhandledException += OnUnhandledException;
}
protected override void OnUnhandledException(object sender,UnhandledExceptionEventArgs e)
{
// Optionally use e.Handled = true;
// Send to Google Ananlytics
}
e.Handled = true行将阻止您的应用程序崩溃,但建议不要使用,因为在发生异常后您的应用程序可能不再处于可用状态.
在我的项目中,我使用Google Analytics记录所有异常.
CentOS disk space used for directory
First step is to find out where the space is being used. To do that, as root, run
du -x -m --max-depth 1 /
Now take the directory listed there with the most space used and repeat the same command but for that directory, not for /. Keep doing that until you find the bottom level directory containing lots of space. Then you can review the files there and decide if they can be safely deleted or not. Do not blindly just remove files at random or you may damage your system.
clickhouse distributed_ddl_task_timeout 超时
程序在执行sql语句时程序控制台报错如下：
Code: 159,e.displayText() = DB::Exception: Watching task /clickhouse/task_queue/ddl/query-0000001991 is executing longer than distributed_ddl_task_timeout (=180) seconds. There are 1 unfinished hosts (0 of them are currently active),they are going to execute the query in background (version 20.3.10.75)
通过clickhouse的系统数据库的查询日志表query_log可以看到查询时间超过了系统默认时间（180s），并且显示了具体异常信息
分布式DDL查询（带有 on cluster XXX）的执行等待时间，系统默认是180s，通过查询系统设置表可以看到，changed=0表示没有被修改过，readonly=0表示可以修改
关于php disk_total_space的介绍现已完结，谢谢您的耐心阅读，如果想了解更多关于ABAP TEXT_CONVERT_XLS_TO_SAP ALSM_EXCEL_TO_INTERNAL_TABLE 读取 EXCEL CSV XML TEXT 等文件内容到 SAP 内表、c# – Task_disconnected_while_still_running、CentOS disk space used for directory、clickhouse distributed_ddl_task_timeout 超时的相关知识，请在本站寻找。
本文标签：
