<?php

	require_once "dev_dbconnect.php";

	if(isset($_POST["xml"]) != "")
	{ 
		mysqli_autocommit($connection, FALSE);
		$sqli_error=0;

		$sync_ip = $_SERVER["REMOTE_ADDR"];	

		//Convert xml header from UTF-16 to UTF-8
		//$string = str_replace("encoding=\"utf-16\"", "encoding=\"utf-8\"", $_POST["xml"]);

		$string = $_POST["xml"];

		//mysqli_query($connection, "INSERT INTO xml (xml) VALUES ('" . $string . "');");


		$xml = simplexml_load_string($string);	
		
		//Certificates
		foreach ($xml->certificate as $children)
		{  
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->serviceorderid . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
	  			if(!mysqli_query($connection, "INSERT INTO test_certificates (id, service_order, test_id, attempts, result, comments, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $children->id . "','" . $children->serviceorderid . "','" . $children->testid . "','" . $children->attempts . "','" . $children->result . "','" . $children->comments . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
	  			{
	  				$sqli_error++;
	  			}
	  		}
	   	}

		//Modules
		foreach ($xml->module as $children)
		{     
		    $serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
			    $get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_modules (certificate_id, identification, serialnumber, model, manufacturer, type, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . $children->identification . "','" . $children->serialnumber . "','" . $children->model . "','" . $children->manufacturer . "','" . $children->type . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //Instruments	
		foreach ($xml->instrument as $children)
		{
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{   
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_instruments (certificate_id, identification, certificate_number, serial_number, next_calibration_date, manual_collection, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . $children->identification . "','" . $children->certificatenumber. "','" . $children->serialnumber . "', '" . $children->nextcalibrationdate . "','" . $children->manualcollection . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

		//Standards
		foreach ($xml->standard as $children)
		{   
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");
				//$get_standard_certificate = mysqli_query($connection, "SELECT certificate_number FROM standards WHERE batch='" . $children->batchnumber . "';");

				$certificate = mysqli_fetch_array($get_certificate_id);
				//$standard_certificate = mysqli_fetch_array($get_standard_certificate);

			    if(!mysqli_query($connection, "INSERT INTO test_standards (certificate_id, identification, certificate_number, batch_number, expiration_date, value, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . $children->identification . "', '" . $children->certificatenumber . "', '" . $children->batchnumber . "','" . $children->expirationdate . "','" . str_replace(",", ".", $children->value) . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {					
			    	$sqli_error++;
			    }
			}
	    }

	    //PEF data
		foreach ($xml->pefdata as $children)
		{  
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{   
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_flbo_data (certificate_id, flow1, flow2, flow3, flow4, flow5, flow6, flow7, flow8, flow9, flow10, flow_test, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->flow1) . "','" . str_replace(",", ".", $children->flow2) . "','" . str_replace(",", ".", $children->flow3) . "','" . str_replace(",", ".", $children->flow4) . "','" . str_replace(",", ".", $children->flow5) . "','" . str_replace(",", ".", $children->flow6) . "','" . str_replace(",", ".", $children->flow7) . "','" . str_replace(",", ".", $children->flow8) . "','" . str_replace(",", ".", $children->flow9) . "','" . str_replace(",", ".", $children->flow10) . "','" . $children->flowtest . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //PEF params
		foreach ($xml->pefparams as $children)
		{   
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);  

			    if(!mysqli_query($connection, "INSERT INTO test_flbo_params (certificate_id, deviation, cv, flow_limit1, flow_limit2, flow_limit3, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->deviation) . "','" . str_replace(",", ".", $children->cv) . "','" . str_replace(",", ".", $children->flowlimit1) . "','" . str_replace(",", ".", $children->flowlimit2) . "','" . str_replace(",", ".", $children->flowlimit3) . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //PEF results
		foreach ($xml->pefresults as $children)
		{   
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{  
			    $get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_flbo_results (certificate_id, deviation, cv, result, flow_test, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->deviation) . "','" . str_replace(",", ".", $children->cv) . "','" . $children->result . "','" . $children->flowtest . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //ETF data
		foreach ($xml->etfdata as $children)
		{      
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_etf_data (certificate_id, temp1_1, temp2_1, temp3_1, temp4_1, temp5_1, temp6_1, temp7_1, temp8_1, temp9_1, temp10_1, temp1_2, temp2_2, temp3_2, temp4_2, temp5_2, temp6_2, temp7_2, temp8_2, temp9_2, temp10_2, temp_test, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->temp1_1) . "','" . str_replace(",", ".", $children->temp2_1) . "','" . str_replace(",", ".", $children->temp3_1) . "','" . str_replace(",", ".", $children->temp4_1) . "','" . str_replace(",", ".", $children->temp5_1) . "','" . str_replace(",", ".", $children->temp6_1) . "','" . str_replace(",", ".", $children->temp7_1) . "','" . str_replace(",", ".", $children->temp8_1) . "','" . str_replace(",", ".", $children->temp9_1) . "','" . str_replace(",", ".", $children->temp10_1) . "','" . str_replace(",", ".", $children->temp1_2) . "','" . str_replace(",", ".", $children->temp2_2) . "','" . str_replace(",", ".", $children->temp3_2) . "','" . str_replace(",", ".", $children->temp4_2) . "','" . str_replace(",", ".", $children->temp5_2) . "','" . str_replace(",", ".", $children->temp6_2) . "','" . str_replace(",", ".", $children->temp7_2) . "','" . str_replace(",", ".", $children->temp8_2) . "','" . str_replace(",", ".", $children->temp9_2) . "','" . str_replace(",", ".", $children->temp10_2) . "','" . $children->temptest . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //ETF params
		foreach ($xml->etfparams as $children)
		{   
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{  
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_etf_params (certificate_id, position1, position2, deviation, cv, temp1, temp2enabled, temp2, temp3enabled, temp3, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . $children->position1 . "','" . $children->position2 . "','" . str_replace(",", ".", $children->deviation) . "','" . str_replace(",", ".", $children->cv) . "','" . str_replace(",", ".", $children->temp1) . "','" . $children->temp2enabled . "','" . str_replace(",", ".", $children->temp2) . "','" . $children->temp3enabled . "','" . str_replace(",", ".", $children->temp3) . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //ETF results
		foreach ($xml->etfresults as $children)
		{ 
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{    
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_etf_results (certificate_id, temp1_deviation_result, temp1_cv_result, temp2_deviation_result, temp2_cv_result, result, temp_test, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->temp1deviationresult) . "','" . str_replace(",", ".", $children->temp1cvresult) . "','" . str_replace(",", ".", $children->temp2deviationresult) . "','" . str_replace(",", ".", $children->temp2cvresult) . "','" . $children->result . "','" . $children->temptest . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //EDUVA data
		foreach ($xml->ecouvmdata as $children)
		{
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_eduva_data (certificate_id, absorbance1, absorbance2, absorbance3, absorbance4, absorbance5, absorbance6, absorbance7, absorbance8, absorbance9, absorbance10, absorbance11, wavelength_test, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->absorbance1) . "','" . str_replace(",", ".", $children->absorbance2) . "','" . str_replace(",", ".", $children->absorbance3) . "','" . str_replace(",", ".", $children->absorbance4) . "','" . str_replace(",", ".", $children->absorbance5) . "','" . str_replace(",", ".", $children->absorbance6) . "','" . str_replace(",", ".", $children->absorbance7) . "','" . str_replace(",", ".", $children->absorbance8) . "','" . str_replace(",", ".", $children->absorbance9) . "','" . str_replace(",", ".", $children->absorbance10) . "','" . str_replace(",", ".", $children->absorbance11) . "','" . $children->wavelengthtest . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //EDUVA params
		foreach ($xml->ecouvmparams as $children)
		{  
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{   
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_eduva_params (certificate_id, deviation, wavelength1, wavelength2, wavelength3, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->deviation) . "','" . str_replace(",", ".", $children->wavelength1) . "','" . str_replace(",", ".", $children->wavelength2) . "','" . str_replace(",", ".", $children->wavelength3) . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //EDUVA results
		foreach ($xml->ecouvmresults as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_eduva_results (certificate_id, wavelength, result, wavelength_test, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . $children->wavelength . "','" . $children->result . "','" . $children->wavelengthtest . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //EDUVB data
		foreach ($xml->ecouvsdata as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_eduvb_data (certificate_id, wavelength_found1, wavelength_found2, wavelength_found3, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->wavelengthfound1) . "','" . str_replace(",", ".", $children->wavelengthfound2) . "','" . str_replace(",", ".", $children->wavelengthfound3) . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //EDUVB params
		foreach ($xml->ecouvsparams as $children)
		{   
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{  
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_eduvb_params (certificate_id, deviation, wavelength1, wavelength2, wavelength3, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . $children->deviation . "','" . $children->wavelength1 . "','" . $children->wavelength2 . "','" . $children->wavelength3 . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
				{
					$sqli_error++;
				}
			}
	    }

	    //EDUVB results
		foreach ($xml->ecouvsresults as $children)
		{   
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{  
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_eduvb_results (certificate_id, wavelength1, result1, wavelength2, result2, wavelength3, result3, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->wavelength1) . "','" . $children->result1 . "','" . str_replace(",", ".", $children->wavelength2) . "','" . $children->result2 . "','" . str_replace(",", ".", $children->wavelength3) . "','" . $children->result3 . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //ECOUVExtM data
		foreach ($xml->ecouvextmdata as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_edvia_data (certificate_id, absorbance1, absorbance2, absorbance3, absorbance4, absorbance5, absorbance6, absorbance7, absorbance8, absorbance9, absorbance10, absorbance11, wavelength_test, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->absorbance1) . "','" . str_replace(",", ".", $children->absorbance2) . "','" . str_replace(",", ".", $children->absorbance3) . "','" . str_replace(",", ".", $children->absorbance4) . "','" . str_replace(",", ".", $children->absorbance5) . "','" . str_replace(",", ".", $children->absorbance6) . "','" . str_replace(",", ".", $children->absorbance7) . "','" . str_replace(",", ".", $children->absorbance8) . "','" . str_replace(",", ".", $children->absorbance9) . "','" . str_replace(",", ".", $children->absorbance10) . "','" . str_replace(",", ".", $children->absorbance11) . "','" . $children->wavelengthtest . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //ECOUVExtM params
		foreach ($xml->ecouvextmparams as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{		
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_edvia_params (certificate_id, deviation, wavelength1, wavelength2, wavelength3, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->deviation) . "','" . str_replace(",", ".", $children->wavelength1) . "','" . str_replace(",", ".", $children->wavelength2) . "','" . str_replace(",", ".", $children->wavelength3) . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //ECOUVExtM results
		foreach ($xml->ecouvextmresults as $children)
		{   
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{  
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_edvia_results (certificate_id, wavelength, result, wavelength_test, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . $children->wavelength . "','" . $children->result . "','" . $children->wavelengthtest . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }
		
		//ECOUVExtS data
		foreach ($xml->ecouvextsdata as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_edvib_data (certificate_id, wavelength_found1, wavelength_found2, wavelength_found3, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->wavelengthfound1) . "','" . str_replace(",", ".", $children->wavelengthfound2) . "','" . str_replace(",", ".", $children->wavelengthfound3) . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //ECOUVExtS params
		foreach ($xml->ecouvextsparams as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_edvib_params (certificate_id, deviation, wavelength1, wavelength2, wavelength3, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . $children->deviation . "','" . $children->wavelength1 . "','" . $children->wavelength2 . "','" . $children->wavelength3 . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //ECOUVExtS results
		foreach ($xml->ecouvextsresults as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_edvib_results (certificate_id, wavelength1, result1, wavelength2, result2, wavelength3, result3, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->wavelength1) . "','" . $children->result1 . "','" . str_replace(",", ".", $children->wavelength2) . "','" . $children->result2 . "','" . str_replace(",", ".", $children->wavelength3) . "','" . $children->result3 . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //ECOFLM data
		foreach ($xml->ecoflmdata as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{			
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_edfla_data (certificate_id, absorbance1, absorbance2, absorbance3, absorbance4, absorbance5, absorbance6, absorbance7, absorbance8, absorbance9, absorbance10, absorbance11, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->absorbance1) . "','" . str_replace(",", ".", $children->absorbance2) . "','" . str_replace(",", ".", $children->absorbance3) . "','" . str_replace(",", ".", $children->absorbance4) . "','" . str_replace(",", ".", $children->absorbance5) . "','" . str_replace(",", ".", $children->absorbance6) . "','" . str_replace(",", ".", $children->absorbance7) . "','" . str_replace(",", ".", $children->absorbance8) . "','" . str_replace(",", ".", $children->absorbance9) . "','" . str_replace(",", ".", $children->absorbance10) . "','" . str_replace(",", ".", $children->absorbance11) . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //ECOFLM params
		foreach ($xml->ecoflmparams as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_edfla_params (certificate_id, deviation, wavelength, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . $children->deviation . "','" . $children->wavelength . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //ECOFLM results
		foreach ($xml->ecoflmresults as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_edfla_results (certificate_id, wavelength_result, result, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . $children->wavelengthresult . "','" . $children->result . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //ECOFLS data
		foreach ($xml->ecoflsdata as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_edflb_data (certificate_id, wavelength_found, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->wavelengthfound) . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //ECOFLS params
		foreach ($xml->ecoflsparams as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_edflb_params (certificate_id, deviation, wavelength, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . $children->deviation . "','" . $children->wavelength . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //ECOFLS results
		foreach ($xml->ecoflsresults as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_edflb_results (certificate_id, wavelength_result, result, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->wavelengthresult) . "','" . $children->result . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //PCIN data
		foreach ($xml->pidata as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_pcin_data (certificate_id, blank1, standard1, standard2, standard3, blank2, standard4, standard5, standard6, blank3, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->blank1) . "','" . str_replace(",", ".", $children->standard1) . "','" . str_replace(",", ".", $children->standard2) . "','" . str_replace(",", ".", $children->standard3) . "','" . str_replace(",", ".", $children->blank2) . "','" . str_replace(",", ".", $children->standard4) . "','" . str_replace(",", ".", $children->standard5) . "','" . str_replace(",", ".", $children->standard6) . "','" . str_replace(",", ".", $children->blank3) . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //PCIN params
		foreach ($xml->piparams as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_pcin_params (certificate_id, dpr, contamination, injected_volume, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->dpr) . "','" . str_replace(",", ".", $children->contamination) . "','" . str_replace(",", ".", $children->injectedvolume) . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //PCIN results
		foreach ($xml->piresults as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_pcin_results (certificate_id, dpr, dpr_result, contamination, contamination_result, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->dpr) . "','" . $children->dprresult . "','" . str_replace(",", ".", $children->contamination) . "','" . $children->contaminationresult . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //LDUV data
		foreach ($xml->lduvdata as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_lduv_data (certificate_id, standard1, standard2, standard3, standard4, standard5, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->standard1) . "','" . str_replace(",", ".", $children->standard2) . "','" . str_replace(",", ".", $children->standard3) . "','" . str_replace(",", ".", $children->standard4) . "','" . str_replace(",", ".", $children->standard5) . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //LDUV params
		foreach ($xml->lduvparams as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_lduv_params (certificate_id, deviation, r2, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->deviation) . "','" . str_replace(",", ".", $children->r2) . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //LDUV results
		foreach ($xml->lduvresults as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_lduv_results (certificate_id, deviation1, deviation1_result, deviation2, deviation2_result, deviation3, deviation3_result, r2, r2_result, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->deviation1) . "','" . $children->deviation1result . "','" . str_replace(",", ".", $children->deviation2) . "','" . $children->deviation2result . "','" . str_replace(",", ".", $children->deviation3) . "','" . $children->deviation3result . "','" . str_replace(",", ".", $children->r2) . "','" . $children->r2result . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //LDFL data
		foreach ($xml->ldfldata as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{			
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_ldfl_data (certificate_id, standard1, standard2, standard3, standard4, standard5, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->standard1) . "','" . str_replace(",", ".", $children->standard2) . "','" . str_replace(",", ".", $children->standard3) . "','" . str_replace(",", ".", $children->standard4) . "','" . str_replace(",", ".", $children->standard5) . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //LDFL params
		foreach ($xml->ldflparams as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{			
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_ldfl_params (certificate_id, deviation, r2, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->deviation) . "','" . str_replace(",", ".", $children->r2) . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //LDFL results
		foreach ($xml->ldflresults as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_ldfl_results (certificate_id, deviation1, deviation1_result, deviation2, deviation2_result, deviation3, deviation3_result, r2, r2_result, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->deviation1) . "','" . $children->deviation1result . "','" . str_replace(",", ".", $children->deviation2) . "','" . $children->deviation2result . "','" . str_replace(",", ".", $children->deviation3) . "','" . $children->deviation3result . "','" . str_replace(",", ".", $children->r2) . "','" . $children->r2result . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //LDIR data
		foreach ($xml->ldridata as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_ldir_data (certificate_id, standard1, standard2, standard3, standard4, standard5, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->standard1) . "','" . str_replace(",", ".", $children->standard2) . "','" . str_replace(",", ".", $children->standard3) . "','" . str_replace(",", ".", $children->standard4) . "','" . str_replace(",", ".", $children->standard5) . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //LDIR params
		foreach ($xml->ldriparams as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_ldir_params (certificate_id, deviation, r2, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->deviation) . "','" . str_replace(",", ".", $children->r2) . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //LDIR results
		foreach ($xml->ldriresults as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_ldir_results (certificate_id, deviation1, deviation1_result, deviation2, deviation2_result, deviation3, deviation3_result, r2, r2_result, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->deviation1) . "','" . $children->deviation1result . "','" . str_replace(",", ".", $children->deviation2) . "','" . $children->deviation2result . "','" . str_replace(",", ".", $children->deviation3) . "','" . $children->deviation3result . "','" . str_replace(",", ".", $children->r2) . "','" . $children->r2result . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }
	/*
	    //LDELS data	
		foreach ($xml->ldelsdata as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_ldels_data (certificate_id, standard1, standard2, standard3, standard4, standard5, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . $children->standard1 . "','" . $children->standard2 . "','" . $children->standard3 . "','" . $children->standard4 . "','" . $children->standard5 . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
					$sqli_error++;
			    }
	    	}
	    }

	    //LDELS params
		foreach ($xml->ldelsparams as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_ldels_params (certificate_id, deviation, r2, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . $children->deviation . "','" . $children->r2 . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
					$sqli_error++;
			    }
		    }
	    }

	    //LDELS results
		foreach ($xml->ldelsresults as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_ldels_results (certificate_id, deviation1, deviation1_result, deviation2, deviation2_result, deviation3, deviation3_result, r2, r2_result, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . $children->deviation1 . "','" . $children->deviation1result . "','" . $children->deviation2 . "','" . $children->deviation2result . "','" . $children->deviation3 . "','" . $children->deviation3result . "','" . $children->r2 . "','" . $children->r2result . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
					$sqli_error++;
			    }
		    }
	    }
	*/
	    //LIIN data
		foreach ($xml->lidata as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_liin_data (certificate_id, standard1, standard2, standard3, standard4, standard5, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->standard1) . "','" . str_replace(",", ".", $children->standard2) . "','" . str_replace(",", ".", $children->standard3) . "','" . str_replace(",", ".", $children->standard4) . "','" . str_replace(",", ".", $children->standard5) . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //LIIN params
		foreach ($xml->liparams as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_liin_params (certificate_id, r2, injected_volume1, injected_volume2, injected_volume3, injected_volume4, injected_volume5, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->r2) . "','" . str_replace(",", ".", $children->injectedvolume1) . "','" . str_replace(",", ".", $children->injectedvolume2) . "','" . str_replace(",", ".", $children->injectedvolume3) . "','" . str_replace(",", ".", $children->injectedvolume4) . "','" . str_replace(",", ".", $children->injectedvolume5) . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //LIIN results
		foreach ($xml->liresults as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_liin_results (certificate_id, r2, r2_result, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->r2) . "','" . $children->r2result . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //GRBO data
		foreach ($xml->egdata as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_grbo_data (certificate_id, proportion1, proportion2, proportion3, proportion4, proportion5, proportion6, proportion7, proportion8, proportion9, proportion10, proportion11, pair, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->proportion1) . "','" . str_replace(",", ".", $children->proportion2) . "','" . str_replace(",", ".", $children->proportion3) . "','" . str_replace(",", ".", $children->proportion4) . "','" . str_replace(",", ".", $children->proportion5) . "','" . str_replace(",", ".", $children->proportion6) . "','" . str_replace(",", ".", $children->proportion7) . "','" . str_replace(",", ".", $children->proportion8) . "','" . str_replace(",", ".", $children->proportion9) . "','" . str_replace(",", ".", $children->proportion10) . "','" . str_replace(",", ".", $children->proportion11) . "','" . $children->pair . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //GRBO params
		foreach ($xml->egparams as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_grbo_params (certificate_id, r2, deviation, steps, channel1_1, channel2_1, channel1_2, channel2_2, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->r2) . "','" . str_replace(",", ".", $children->deviation) . "','" . $children->steps . "','" . $children->channel1_1 . "','" . $children->channel2_1 . "','" . $children->channel1_2 . "','" . $children->channel2_2 . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //GRBO results
		foreach ($xml->egresults as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_grbo_results (certificate_id, proportion1, proportion1_deviation, proportion1_result, proportion2, proportion2_deviation, proportion2_result, proportion3, proportion3_deviation, proportion3_result, proportion4, proportion4_deviation, proportion4_result, proportion5, proportion5_deviation, proportion5_result, proportion6, proportion6_deviation, proportion6_result, proportion7, proportion7_deviation, proportion7_result, proportion8, proportion8_deviation, proportion8_result, proportion9, proportion9_deviation, proportion9_result, proportion10, proportion10_deviation, proportion10_result, proportion11, proportion11_deviation, proportion11_result, r2, r2_result, pair, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . $children->proportion1 . "','" . str_replace(",", ".", $children->proportion1deviation) . "','" . $children->proportion1result . "','" . $children->proportion2 . "','" . str_replace(",", ".", $children->proportion2deviation) . "','" . $children->proportion2result . "','" . $children->proportion3 . "','" . str_replace(",", ".", $children->proportion3deviation) . "','" . $children->proportion3result . "','" . $children->proportion4 . "','" . str_replace(",", ".", $children->proportion4deviation) . "','" . $children->proportion4result . "','" . $children->proportion5 . "','" . str_replace(",", ".", $children->proportion5deviation) . "','" . $children->proportion5result . "','" . $children->proportion6 . "','" . str_replace(",", ".", $children->proportion6deviation) . "','" . $children->proportion6result . "','" . $children->proportion7 . "','" . str_replace(",", ".", $children->proportion7deviation) . "','" . $children->proportion7result . "','" . $children->proportion8 . "','" . str_replace(",", ".", $children->proportion8deviation) . "','" . $children->proportion8result . "','" . $children->proportion9 . "','" . str_replace(",", ".", $children->proportion9deviation) . "','" . $children->proportion9result . "','" . $children->proportion10 . "','" . str_replace(",", ".", $children->proportion10deviation) . "','" . $children->proportion10result . "','" . $children->proportion11 . "','" . str_replace(",", ".", $children->proportion11deviation) . "','" . $children->proportion11result . "','" . str_replace(",", ".", $children->r2) . "','" . $children->r2result . "','" . $children->pair . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
		}

		//SRELB data
		foreach ($xml->relbdata as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_srelb_data (certificate_id, noise_found, baseline_found, peakheight_found, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->noisefound) . "','" . str_replace(",", ".", $children->baselinefound) . "','" . str_replace(",", ".", $children->peakheightfound) . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //SRELB params
		foreach ($xml->relbparams as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_srelb_params (certificate_id, noise, baseline, noisesignal, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->noise) . "','" . str_replace(",", ".", $children->baseline) . "','" . $children->noisesignal . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //SRELB results
		foreach ($xml->relbresults as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_srelb_results (certificate_id, noise, noise_result, baseline, baseline_result, noisesignal, noisesignal_result, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->noise) . "','" . $children->noiseresult . "','" . str_replace(",", ".", $children->baseline) . "','" . $children->baselineresult . "','" . str_replace(",", ".", $children->noisesignal) . "','" . $children->noisesignalresult . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
		}

		//PDFL data
		foreach ($xml->pdfldata as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_pdfl_data (certificate_id, injection1, injection2, injection3, injection4, injection5, injection6, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->injection1) . "','" . str_replace(",", ".", $children->injection2) . "','" . str_replace(",", ".", $children->injection3) . "','" . str_replace(",", ".", $children->injection4) . "','" . str_replace(",", ".", $children->injection5) . "','" . str_replace(",", ".", $children->injection6) . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //PDFL params
		foreach ($xml->pdflparams as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_pdfl_params (certificate_id, dpr, injected_volume, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->dpr) . "','" . str_replace(",", ".", $children->injectedvolume) . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

	    //PDFL results
		foreach ($xml->pdflresults as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

			    $certificate = mysqli_fetch_array($get_certificate_id);

			    if(!mysqli_query($connection, "INSERT INTO test_pdfl_results (certificate_id, dpr, dpr_result, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->dpr) . "','" . $children->dprresult . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
			    {
			    	$sqli_error++;
			    }
			}
	    }

		//PDELS data
		foreach ($xml->pdelsdata as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

				$certificate = mysqli_fetch_array($get_certificate_id);

				if(!mysqli_query($connection, "INSERT INTO test_pdels_data (certificate_id, injection1, injection2, injection3, injection4, injection5, injection6, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->injection1) . "','" . str_replace(",", ".", $children->injection2) . "','" . str_replace(",", ".", $children->injection3) . "','" . str_replace(",", ".", $children->injection4) . "','" . str_replace(",", ".", $children->injection5) . "','" . str_replace(",", ".", $children->injection6) . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
				{
					$sqli_error++;
				}
			}
		}

		//PDELS params
		foreach ($xml->pdelsparams as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

				$certificate = mysqli_fetch_array($get_certificate_id);

				if(!mysqli_query($connection, "INSERT INTO test_pdels_params (certificate_id, dpr, injected_volume, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->dpr) . "','" . str_replace(",", ".", $children->injectedvolume) . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
				{
					$sqli_error++;
				}
			}
		}

		//PDELS results
		foreach ($xml->pdelsresults as $children)
		{     
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $children->socode . "' AND sync_datetime='0000-00-00 00:00:00';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				$get_certificate_id = mysqli_query($connection, "SELECT idtest_certificates FROM test_certificates WHERE service_order='" . $children->socode . "' AND id='" . $children->certificateid . "';");

				$certificate = mysqli_fetch_array($get_certificate_id);

				if(!mysqli_query($connection, "INSERT INTO test_pdels_results (certificate_id, dpr, dpr_result, create_user_id, create_date, last_modify_user_id, last_modify_date, sync_ip) VALUES ('" . $certificate["idtest_certificates"] . "','" . str_replace(",", ".", $children->dpr) . "','" . $children->dprresult . "','" . $children->createuserid . "','" . $children->createdate . "','" . $children->lastmodifyuserid . "','" . $children->lastmodifydate . "','" . $sync_ip . "');"))
				{
					$sqli_error++;
				}
			}
		}



	    //ServiceOrder (ever last)
		foreach ($xml->serviceorder as $children)
		{   
		    if(!mysqli_query($connection, "UPDATE service_orders SET service_date='" . $children->dateservice . "', sponsor='" . $children->sponsor . "',  customer_contact_department='" . $children->department . "', customer_contact_name='" . $children->contactname . "', equipment_tag='" . $children->equipmenttag . "', equipment_location='" . $children->equipmentlocation . "', attachment_checksum='" . $children->attachmentchecksum . "', status='3', sync_ip='" . $sync_ip . "', sync_datetime=NOW(), attachment_upload_datetime=NOW() WHERE os_code='" . $children->code . "' AND status='2';"))
		    {
		    	$sqli_error++;
		    }
	    }

	    if($sqli_error==0)
	    {
	    	mysqli_commit($connection);
	    	echo "1"; 
	    }
	    else
	    {
	    	echo "0";
	    }
	}
	else 
	{
		if(isset($_POST["o"]) != "")
		{ 
			$serviceorder_verify = mysqli_query($connection, "SELECT id FROM service_orders WHERE os_code='" . $_POST["o"] . "' AND status='3';");

			if(mysqli_fetch_array($serviceorder_verify) > 0)
			{
				echo "1";
			}
			else			
			{
				echo "0";
			}
		}
	}

?>