30 lines
1.3 KiB
PHP
30 lines
1.3 KiB
PHP
<?php ob_start(); ?>
|
|
<?php
|
|
// include"/var/www/dbaccess.php";
|
|
// $polacz = mysql_connect($softspm_host, $demo_softspm_user, $demo_softspm_pass);mysql_select_db($demo_softspm_db);
|
|
|
|
// $polacz = mysql_connect('localhost', 'segap', 'segap');mysql_select_db('segap');
|
|
$polacz = mysql_connect('localhost', 'softspm', 'ff8efe59e7265fe9680b0c325e44cb53');mysql_select_db('softspm');
|
|
mysql_query("SET NAMES utf8");
|
|
mysql_query("SET CHARACTER_SET utf8_general_ci");
|
|
|
|
$wynik = mysql_query("select DRD_DRS_ID,DRD_RESOURCES_DETAIL from seg_dev_resources_det group by DRD_DRS_ID, DRD_RESOURCES_DETAIL having count(DRD_RESOURCES_DETAIL)>20");
|
|
if($wynik)while ($r = mysql_fetch_array($wynik))
|
|
{
|
|
$sql_p1 = $r["DRD_DRS_ID"];
|
|
$sql_p2 = $r["DRD_RESOURCES_DETAIL"];
|
|
|
|
$wynik1 = mysql_query("select DRD_ID from seg_dev_resources_det where DRD_DRS_ID=$sql_p1 and DRD_RESOURCES_DETAIL=$sql_p2 and DRD_AUDIT_DATE < ADDDATE(CURDATE(), INTERVAL -7 DAY)");
|
|
if($wynik1)while ($r1 = mysql_fetch_array($wynik1))
|
|
{
|
|
$sql_drdID = $r1["DRD_ID"];
|
|
mysql_query("insert into seg_dev_resources_det_his select * from seg_dev_resources_det where DRD_ID=$sql_drdID");
|
|
mysql_query("DELETE FROM seg_dev_resources_det WHERE DRD_ID=$sql_drdID");
|
|
}
|
|
|
|
}
|
|
mysql_close($polacz);
|
|
|
|
?>
|
|
<?php ob_end_flush();?>
|