#!/bin/sh
d=`date +"%d"`
d1=`expr ${d} - 1`
d2=`expr ${d} - 0`
M=`date +"%m"`
A=`date +"%Y"`
MM=`expr ${M} - 1`
daterec=`date --date='1 days ago' +%Y%m%d`
datehier=`date --date='1 days ago' +%Y-%m-%d`
datedujour=`date +"%Y%m${d2}"`
#daterec=`date +"%Y%m${d1}"`
#datehier=`expr ${A}-${M}-${d1}` 
SERVER="192.168.230.80"
LOGIN="x"
PASSWORD="x"
echo 'Connexion en cours'
ftp -v -n $SERVER<<EOF
user $LOGIN $PASSWORD 
pwd
cd /opt/oss/server/var/fileint/pm/pmexport_$daterec
bin
prompt
lcd /home/eni/
mget pmresult_838883c14_60_$daterec*.xml
EOF
?>
cat '/home/eni/pmresult_83888314_60_'$daterec'0000_'$daterec'0100.xml' >> /home/eni/trunkinterco.xml
cat '/home/eni/pmresult_83888314_60_'$daterec'0100_'$daterec'0200.xml' >> /home/eni/trunkinterco.xml
cat '/home/eni/pmresult_83888314_60_'$daterec'0200_'$daterec'0300.xml' >> /home/eni/trunkinterco.xml
cat '/home/eni/pmresult_83888314_60_'$daterec'0300_'$daterec'0400.xml' >> /home/eni/trunkinterco.xml
cat '/home/eni/pmresult_83888314_60_'$daterec'0400_'$daterec'0500.xml' >> /home/eni/trunkinterco.xml
cat '/home/eni/pmresult_83888314_60_'$daterec'0500_'$daterec'0600.xml' >> /home/eni/trunkinterco.xml
cat '/home/eni/pmresult_83888314_60_'$daterec'0600_'$daterec'0700.xml' >> /home/eni/trunkinterco.xml
cat '/home/eni/pmresult_83888314_60_'$daterec'0700_'$daterec'0800.xml' >> /home/eni/trunkinterco.xml
cat '/home/eni/pmresult_83888314_60_'$daterec'0800_'$daterec'0900.xml' >> /home/eni/trunkinterco.xml
cat '/home/eni/pmresult_83888314_60_'$daterec'0900_'$daterec'1000.xml' >> /home/eni/trunkinterco.xml
cat '/home/eni/pmresult_83888314_60_'$daterec'1000_'$daterec'1100.xml' >> /home/eni/trunkinterco.xml
cat '/home/eni/pmresult_83888314_60_'$daterec'1100_'$daterec'1200.xml' >> /home/eni/trunkinterco.xml
cat '/home/eni/pmresult_83888314_60_'$daterec'1200_'$daterec'1300.xml' >> /home/eni/trunkinterco.xml
cat '/home/eni/pmresult_83888314_60_'$daterec'1300_'$daterec'1400.xml' >> /home/eni/trunkinterco.xml
cat '/home/eni/pmresult_83888314_60_'$daterec'1400_'$daterec'1500.xml' >> /home/eni/trunkinterco.xml
cat '/home/eni/pmresult_83888314_60_'$daterec'1500_'$daterec'1600.xml' >> /home/eni/trunkinterco.xml
cat '/home/eni/pmresult_83888314_60_'$daterec'1600_'$daterec'1700.xml' >> /home/eni/trunkinterco.xml
cat '/home/eni/pmresult_83888314_60_'$daterec'1700_'$daterec'1800.xml' >> /home/eni/trunkinterco.xml
cat '/home/eni/pmresult_83888314_60_'$daterec'1800_'$daterec'1900.xml' >> /home/eni/trunkinterco.xml
cat '/home/eni/pmresult_83888314_60_'$daterec'1900_'$daterec'2000.xml' >> /home/eni/trunkinterco.xml
cat '/home/eni/pmresult_83888314_60_'$daterec'2000_'$daterec'2100.xml' >> /home/eni/trunkinterco.xml
cat '/home/eni/pmresult_83888314_60_'$daterec'2100_'$daterec'2200.xml' >> /home/eni/trunkinterco.xml
cat '/home/eni/pmresult_83888314_60_'$daterec'2200_'$daterec'2300.xml' >> /home/eni/trunkinterco.xml
cat '/home/eni/pmresult_83888314_60_'$daterec'2300_'$datedujour'0000.xml' >> /home/eni/trunkinterco.xml


<?php
   
$filexml1='trunkinterco.xml';


$info1= pathinfo($filexml1);
$file_name1= basename($filexml1,'.'.$info1['extension']);   
nk
$filexml2='interco.xml';


$info2= pathinfo($filexml2);
$file_name2= basename($filexml2,'.'.$info2['extension']);   

$filexml3='interco1.xml';


$info3= pathinfo($filexml3);
$file_name3= basename($filexml3,'.'.$info3['extension']);   


    if (file_exists($filexml1)) 
           {
       $xml = simplexml_load_file($filexml1);
       $f = fopen($file_name1.'.csv', 'w');
       createCsv($xml, $f);
       fclose($f);
    }

   
    if (file_exists($filexml2)) 
           {
       $xml = simplexml_load_file($filexml2);
       $f = fopen($file_name2.'.csv', 'w');
       createCsv($xml, $f);
       fclose($f);
    }
    if (file_exists($filexml3)) 
           {
       $xml = simplexml_load_file($filexml3);
       $f = fopen($file_name3.'.csv', 'w');
       createCsv($xml, $f);
       fclose($f);
    }

    function createCsv($xml,$f)
    {

        foreach ($xml->children() as $item) 
        {

           $hasChild = (count($item->children()) > 0)?true:false;

        if( ! $hasChild)
        {
           $put_arr = array($item->getName(),$item); 
           fputcsv($f, $put_arr ,',','"');

        }
        else
        {
         createCsv($item, $f);
        }
     }

    }	

?>