中文内容：

翻译内容：

MES系统功能清单(开源)

文档位置: nagomes.cn/mesdoc/dcc.php?doc=A032
更新时间: 25-11-18 10:50    显示电脑模式
文控编号: uncontrolled management

DBA追溯表维护说明

处理H表数据到时间分区表：

$dbhost="192.168.1.233";
$table="r_sn_detail_h";

require_once("movedb.phar");	
require_once("phar://movedb.phar/movedb.php");

echo version();
$tick=getTickCount();
$sns=get_sn(100000,"","");
if(is_array($sns)){
	if($sns){
		foreach($sns as $sn=>){
			echo move_sn($sn);
			echo "\r\n";
		}
	}else{
		echo "no sn found!\r\n";
	}
}else{
	echo $sns;
}
$tick=getTickCount()-$tick;
echo "[ Execute Time: {$tick} ]\r\n";

select vr_value from sfc.c_parameter_ini
        where prg_name='QUEYR6'
        and vr_name='DETAIL_TABLE'
        order by vr_desc

处理R表到H表：

call sfc.MOVE_DATA_R117('20211101');
call sfc.MOVE_DATA_R117('20211102');
call sfc.MOVE_DATA_R117('20211103');
call sfc.MOVE_DATA_R117('20211104');
call sfc.MOVE_DATA_R117('20211105');
call sfc.MOVE_DATA_R117('20211106');