'localhost', 'username' => 'root', 'password' => 'Mikronika123', 'db_name' => 'softspm', ); $db_connection_ext = array( 'host' => '172.21.11.101', 'username' => 'slave_user', 'password' => 'slave_user', 'db_name' => 'softspm', ); // funkcja zwraca zaytanie SQL do tablicy // ========================================================== // function sqlGetResAsArray($query) { $res=null; $res = array(); if(!$results = mysql_query($query)){ echo mysql_error(); return false; } for($i=0; $row=mysql_fetch_assoc($results); $i++) $res[$i]=$row; return $res; } // ========================================================== // function getFloatValue($inParam) { unset($outParam); if (!empty($inParam) || strlen($inParam)>0) { $inParam = str_replace(array('\'', '\"'), array('', ''), $inParam); $inParam = (float)str_replace(',', '.', $inParam); $outParam = round($inParam, 2); } else $outParam = null; return $outParam; } // ==================================================================================================================== // // ==================================================================================================================== // $loc = mysql_connect($db_connection['host'], $db_connection['username'], $db_connection['password']) or die ('cannot connect to db'); mysql_select_db($db_connection['db_name']); mysql_query("SET NAMES utf8"); mysql_query("SET CHARACTER_SET utf8_general_ci"); unset($maxRHD_ID); $maxRHD_ID = sqlGetResAsArray("select max(RHD_ID) RHD_ID from rep_his_data_everyday"); echo $maxRHD_ID[0]['RHD_ID']; echo'
'; mysql_close($loc); // ==================================================================================================================== // // naza zewnętrzna // ==================================================================================================================== // $ext = mysql_connect($db_connection_ext['host'], $db_connection_ext['username'], $db_connection_ext['password']) or die ('cannot connect to db'); mysql_select_db($db_connection_ext['db_name']); mysql_query("SET NAMES utf8"); mysql_query("SET CHARACTER_SET utf8_general_ci"); unset($ext_his_data_everyday); $ext_his_data_everyday = sqlGetResAsArray("select * from rep_his_data_everyday where RHD_ID>".$maxRHD_ID[0]['RHD_ID']." limit 10000"); mysql_close($ext); // ==================================================================================================================== // // ==================================================================================================================== // $loc = mysql_connect($db_connection['host'], $db_connection['username'], $db_connection['password']) or die ('cannot connect to db'); mysql_select_db($db_connection['db_name']); mysql_query("SET NAMES utf8"); mysql_query("SET CHARACTER_SET utf8_general_ci"); for($i=0; $i0) $query .= ",RHD_HST0_VAL=".$ext_his_data_everyday[$i]['RHD_HST0_VAL']; if ($ext_his_data_everyday[$i]['RHD_HST_VAL']>0) $query .= ",RHD_HST_VAL=".$ext_his_data_everyday[$i]['RHD_HST_VAL']; if ($ext_his_data_everyday[$i]['RHD_HD_VAL']>0) $query .= ",RHD_HD_VAL=".$ext_his_data_everyday[$i]['RHD_HD_VAL']; if ($ext_his_data_everyday[$i]['RHD_Q_VAL']>0) $query .= ",RHD_Q_VAL=".$ext_his_data_everyday[$i]['RHD_Q_VAL']; if ($ext_his_data_everyday[$i]['RHD_P1_VAL']>0) $query .= ",RHD_P1_VAL=".$ext_his_data_everyday[$i]['RHD_P1_VAL']; if ($ext_his_data_everyday[$i]['RHD_P2_VAL']>0) $query .= ",RHD_P2_VAL=".$ext_his_data_everyday[$i]['RHD_P2_VAL']; if ($ext_his_data_everyday[$i]['RHD_I_VAL']>0) $query .= ",RHD_I_VAL=".$ext_his_data_everyday[$i]['RHD_I_VAL']; if ($ext_his_data_everyday[$i]['RHD_U_VAL']>0) $query .= ",RHD_U_VAL=".$ext_his_data_everyday[$i]['RHD_U_VAL']; if ($ext_his_data_everyday[$i]['RHD_PE_VAL']>0) $query .= ",RHD_PE_VAL=".$ext_his_data_everyday[$i]['RHD_PE_VAL']; if ($ext_his_data_everyday[$i]['RHD_COS_VAL']>0) $query .= ",RHD_COS_VAL=".$ext_his_data_everyday[$i]['RHD_COS_VAL']; if ($ext_his_data_everyday[$i]['RHD_PP_VAL']>0) $query .= ",RHD_PP_VAL=".$ext_his_data_everyday[$i]['RHD_PP_VAL']; if ($ext_his_data_everyday[$i]['RHD_HH_VAL']>0) $query .= ",RHD_HH_VAL=".$ext_his_data_everyday[$i]['RHD_HH_VAL']; if ($ext_his_data_everyday[$i]['RHD_VM3_VAL']>0) $query .= ",RHD_VM3_VAL=".$ext_his_data_everyday[$i]['RHD_VM3_VAL']; if ($ext_his_data_everyday[$i]['RHD_WTEMP_VAL']>0) $query .= ",RHD_WTEMP_VAL=".$ext_his_data_everyday[$i]['RHD_WTEMP_VAL']; if ($ext_his_data_everyday[$i]['RHD_DGN_VAL']>0) $query .= ",RHD_DGN_VAL=".$ext_his_data_everyday[$i]['RHD_DGN_VAL']; if ($ext_his_data_everyday[$i]['RHD_WORK_TIME_VAL']>0) $query .= ",RHD_WORK_TIME_VAL=".$ext_his_data_everyday[$i]['RHD_WORK_TIME_VAL']; if ($ext_his_data_everyday[$i]['RHD_SPM_WT']>0) $query .= ",RHD_SPM_WT=".$ext_his_data_everyday[$i]['RHD_SPM_WT']; if ($ext_his_data_everyday[$i]['RHD_SPM_PW']>0) $query .= ",RHD_SPM_PW=".$ext_his_data_everyday[$i]['RHD_SPM_PW']; echo $query; mysql_query($query); echo'
'; } mysql_close($loc); // ==================================================================================================================== // // ==================================================================================================================== // // ==================================================================================================================== // echo'
'; echo'
'; echo'
'; // dane jakościowe // ==================================================================================================================== // $ext = mysql_connect($db_connection_ext['host'], $db_connection_ext['username'], $db_connection_ext['password']) or die ('cannot connect to db'); mysql_select_db($db_connection_ext['db_name']); mysql_query("SET NAMES utf8"); mysql_query("SET CHARACTER_SET utf8_general_ci"); unset($ext_rep_soap_syndis_quality_data); $ext_rep_soap_syndis_quality_data = sqlGetResAsArray("select * from rep_soap_syndis_quality_data"); mysql_close($ext); // ==================================================================================================================== // // ==================================================================================================================== // $loc = mysql_connect($db_connection['host'], $db_connection['username'], $db_connection['password']) or die ('cannot connect to db'); mysql_select_db($db_connection['db_name']); mysql_query("SET NAMES utf8"); mysql_query("SET CHARACTER_SET utf8_general_ci"); mysql_query("truncate table rep_soap_syndis_quality_data"); for ($i=0; $i0) $query .= ",SQD_VAL_Q='".$ext_rep_soap_syndis_quality_data[$i]['SQD_VAL_Q']."'"; if (strlen($ext_rep_soap_syndis_quality_data[$i]['SQD_FLG_Q'])>0) $query .= ",SQD_FLG_Q='".$ext_rep_soap_syndis_quality_data[$i]['SQD_FLG_Q']."'"; if (strlen($ext_rep_soap_syndis_quality_data[$i]['SQD_VAL_P1'])>0) $query .= ",SQD_VAL_P1='".$ext_rep_soap_syndis_quality_data[$i]['SQD_VAL_P1']."'"; if (strlen($ext_rep_soap_syndis_quality_data[$i]['SQD_FLG_P1'])>0) $query .= ",SQD_FLG_P1='".$ext_rep_soap_syndis_quality_data[$i]['SQD_FLG_P1']."'"; if (strlen($ext_rep_soap_syndis_quality_data[$i]['SQD_VAL_P2'])>0) $query .= ",SQD_VAL_P2='".$ext_rep_soap_syndis_quality_data[$i]['SQD_VAL_P2']."'"; if (strlen($ext_rep_soap_syndis_quality_data[$i]['SQD_FLG_P2'])>0) $query .= ",SQD_FLG_P2='".$ext_rep_soap_syndis_quality_data[$i]['SQD_FLG_P2']."'"; if (strlen($ext_rep_soap_syndis_quality_data[$i]['SQD_VAL_I'])>0) $query .= ",SQD_VAL_I='".$ext_rep_soap_syndis_quality_data[$i]['SQD_VAL_I']."'"; if (strlen($ext_rep_soap_syndis_quality_data[$i]['SQD_FLG_I'])>0) $query .= ",SQD_FLG_I='".$ext_rep_soap_syndis_quality_data[$i]['SQD_FLG_I']."'"; if (strlen($ext_rep_soap_syndis_quality_data[$i]['SQD_VAL_U'])>0) $query .= ",SQD_VAL_U='".$ext_rep_soap_syndis_quality_data[$i]['SQD_VAL_U']."'"; if (strlen($ext_rep_soap_syndis_quality_data[$i]['SQD_FLG_U'])>0) $query .= ",SQD_FLG_U='".$ext_rep_soap_syndis_quality_data[$i]['SQD_FLG_U']."'"; if (strlen($ext_rep_soap_syndis_quality_data[$i]['SQD_VAL_CF'])>0) $query .= ",SQD_VAL_CF='".$ext_rep_soap_syndis_quality_data[$i]['SQD_VAL_CF']."'"; if (strlen($ext_rep_soap_syndis_quality_data[$i]['SQD_FLG_CF'])>0) $query .= ",SQD_FLG_CF='".$ext_rep_soap_syndis_quality_data[$i]['SQD_FLG_CF']."'"; if (strlen($ext_rep_soap_syndis_quality_data[$i]['SQD_VAL_PE'])>0) $query .= ",SQD_VAL_PE='".$ext_rep_soap_syndis_quality_data[$i]['SQD_VAL_PE']."'"; if (strlen($ext_rep_soap_syndis_quality_data[$i]['SQD_FLG_PE'])>0) $query .= ",SQD_FLG_PE='".$ext_rep_soap_syndis_quality_data[$i]['SQD_FLG_PE']."'"; if (strlen($ext_rep_soap_syndis_quality_data[$i]['SQD_VAL_PP'])>0) $query .= ",SQD_VAL_PP='".$ext_rep_soap_syndis_quality_data[$i]['SQD_VAL_PP']."'"; if (strlen($ext_rep_soap_syndis_quality_data[$i]['SQD_FLG_PP'])>0) $query .= ",SQD_FLG_PP='".$ext_rep_soap_syndis_quality_data[$i]['SQD_FLG_PP']."'"; if (strlen($ext_rep_soap_syndis_quality_data[$i]['SQD_VAL_HH'])>0) $query .= ",SQD_VAL_HH='".$ext_rep_soap_syndis_quality_data[$i]['SQD_VAL_HH']."'"; if (strlen($ext_rep_soap_syndis_quality_data[$i]['SQD_FLG_HH'])>0) $query .= ",SQD_FLG_HH='".$ext_rep_soap_syndis_quality_data[$i]['SQD_FLG_HH']."'"; if (strlen($ext_rep_soap_syndis_quality_data[$i]['SQD_VAL_HD'])>0) $query .= ",SQD_VAL_HD='".$ext_rep_soap_syndis_quality_data[$i]['SQD_VAL_HD']."'"; if (strlen($ext_rep_soap_syndis_quality_data[$i]['SQD_FLG_HD'])>0) $query .= ",SQD_FLG_HD='".$ext_rep_soap_syndis_quality_data[$i]['SQD_FLG_HD']."'"; if (strlen($ext_rep_soap_syndis_quality_data[$i]['SQD_VAL_ONOFF'])>0) $query .= ",SQD_VAL_ONOFF='".$ext_rep_soap_syndis_quality_data[$i]['SQD_VAL_ONOFF']."'"; if (strlen($ext_rep_soap_syndis_quality_data[$i]['SQD_FLG_ONOFF'])>0) $query .= ",SQD_FLG_ONOFF='".$ext_rep_soap_syndis_quality_data[$i]['SQD_FLG_ONOFF']."'"; if (strlen($ext_rep_soap_syndis_quality_data[$i]['SQD_AUDIT_CD'])>0) $query .= ",SQD_AUDIT_CD='".$ext_rep_soap_syndis_quality_data[$i]['SQD_AUDIT_CD']."'"; echo $query; mysql_query($query); echo'
'; } mysql_close($loc); // ==================================================================================================================== // ?>