Analiza danych - POMPY...
0)
{
echo 'Brakuje pompy na stanie - dodaje nową';
mysql_query("INSERT INTO seg_dev_resources SET DRS_DEV_ID='".$pupArray[0]['PUP_ID']."',DRS_DEV_TYPE=10,DRS_SN_NUMBER='".$lostAggArray[$i]['PUP_SN_NO']."',DRS_STATUS_DIC_ID=1,DRS_RESOURCES_DIC_ID=1,DRS_DEPARTMENT='".$lostAggArray[$i]['PUP_DEPARTMENT']."',DRS_AUDIT_DATE=now()");
unset($devArray);
$devArray = sqlGetResAsArray("select * from seg_dev_resources where DRS_SN_NUMBER='".$lostAggArray[$i]['PUP_SN_NO']."'");
}
// istnieje agregat - aktualizauje dane
elseif ($devArray[0]['DRS_ID']>0 && $pupArray[0]['PUP_ID']>0)
{
echo 'Aktualizuje dane o pompie';
mysql_query("UPDATE seg_dev_resources SET DRS_DEV_ID='".$pupArray[0]['PUP_ID']."',DRS_DEV_TYPE=10,DRS_STATUS_DIC_ID=1,DRS_RESOURCES_DIC_ID=1,DRS_DEPARTMENT='".$lostAggArray[$i]['PUP_DEPARTMENT']."',DRS_AUDIT_DATE=now() WHERE DRS_ID=".$devArray[0]['DRS_ID']);
}
// aktualizauje wpisy w tabeli rep_aggregate_departments
if ($devArray[0]['DRS_ID']>0 && $pupArray[0]['PUP_ID']>0)
{
mysql_query("UPDATE rep_aggregate_departments SET PUP_ID='".$pupArray[0]['PUP_ID']."',PUP_DRS_ID='".$devArray[0]['DRS_ID']."',PUP_Q_N='".$pupArray[0]['PUP_Q_N']."',PUP_H_P='".$pupArray[0]['PUP_H_P']."' WHERE RAD_ID=".$lostAggArray[$i]['RAD_ID']);
}
echo'
';
}
?>
Analiza danych - SILNIKI...
0)
{
echo 'Brakuje silnika na stanie - dodaje nowy';
mysql_query("INSERT INTO seg_dev_resources SET DRS_DEV_ID='".$engArray[0]['ENG_ID']."',DRS_DEV_TYPE=11,DRS_SN_NUMBER='".$lostAggArray[$i]['ENG_SN_NO']."',DRS_STATUS_DIC_ID=1,DRS_RESOURCES_DIC_ID=1,DRS_DEPARTMENT='".$lostAggArray[$i]['PUP_DEPARTMENT']."',DRS_AUDIT_DATE=now()");
unset($devArray);
$devArray = sqlGetResAsArray("select * from seg_dev_resources where DRS_SN_NUMBER='".$lostAggArray[$i]['ENG_SN_NO']."'");
}
// istnieje agregat - aktualizauje dane
elseif ($devArray[0]['DRS_ID']>0 && $engArray[0]['ENG_ID']>0)
{
echo 'Aktualizuje dane o silniku';
mysql_query("UPDATE seg_dev_resources SET DRS_DEV_ID='".$engArray[0]['ENG_ID']."',DRS_DEV_TYPE=11,DRS_STATUS_DIC_ID=1,DRS_RESOURCES_DIC_ID=1,DRS_DEPARTMENT='".$lostAggArray[$i]['PUP_DEPARTMENT']."',DRS_AUDIT_DATE=now() WHERE DRS_ID=".$devArray[0]['DRS_ID']);
}
// aktualizauje wpisy w tabeli rep_aggregate_departments
if ($devArray[0]['DRS_ID']>0 && $engArray[0]['ENG_ID']>0)
{
mysql_query("UPDATE rep_aggregate_departments SET ENG_ID='".$engArray[0]['ENG_ID']."',ENG_DRS_ID='".$devArray[0]['DRS_ID']."' WHERE RAD_ID=".$lostAggArray[$i]['RAD_ID']);
}
echo'
';
}
?>
Popmy - dodatek...
0)
{
unset($dep);
if ($lostAggArray[$i]['stp_stapo_user_id']==1) $dep = 'P/Bełchatów';
elseif ($lostAggArray[$i]['stp_stapo_user_id']==2) $dep = 'Dębina';
elseif ($lostAggArray[$i]['stp_stapo_user_id']==3) $dep = 'P/Szczerców';
mysql_query("INSERT INTO seg_dev_resources SET DRS_DEV_ID='".$pupArray[0]['PUP_ID']."',DRS_DEV_TYPE=10,DRS_SN_NUMBER='".$lostAggArray[$i]['stp_stapo_nr_p']."',DRS_STATUS_DIC_ID=7,DRS_RESOURCES_DIC_ID='".$lostAggArray[$i]['DEV_STATUS']."',DRS_DEPARTMENT='".$dep."',DRS_AUDIT_USR='manual',DRS_AUDIT_DATE=now()");
echo'Dodano: '.$pupArray[0]['PUP_ID'].'
';
}
}
?>
Silniki - dodatek...
0)
{
unset($dep);
if ($lostAggArray[$i]['stp_stamot_user_id']==1) $dep = 'P/Bełchatów';
elseif ($lostAggArray[$i]['stp_stamot_user_id']==2) $dep = 'Dębina';
elseif ($lostAggArray[$i]['stp_stamot_user_id']==3) $dep = 'P/Szczerców';
mysql_query("INSERT INTO seg_dev_resources SET DRS_DEV_ID='".$engArray[0]['ENG_ID']."',DRS_DEV_TYPE=11,DRS_SN_NUMBER='".$lostAggArray[$i]['stp_stamot_nr_m']."',DRS_STATUS_DIC_ID=7,DRS_RESOURCES_DIC_ID='".$lostAggArray[$i]['DEV_STATUS']."',DRS_DEPARTMENT='".$dep."',DRS_AUDIT_USR='manual',DRS_AUDIT_DATE=now()");
echo'Dodano: '.$engArray[0]['ENG_ID'].'
';
}
}
?>