<?php require_once('../Connections/wp_sql.php');
// Relative path
$path = "C:\Inetpub\ftproot\IsolatedUser\LocalUser\****/response";
// Open Directory
$dir_handle = @opendir($path) or die("Unable to open $path");
// Run loops for each file in DIR
$row = array();
while ($file = readdir($dir_handle))
{
if($file!="." && $file!="..")
foreach(file('C:\Inetpub\ftproot\IsolatedUser\LocalUser\****/response/'.$file) as $line)
{
$row[] = explode(',', $line);
}
$OrderID = substr_replace($file,"",-5);
mssql_select_db('****', $conn);
$sql = "SELECT * FROM dbo.Orders where OrderID = '$OrderID'";
$result = mssql_query($sql);
while($row2 = mssql_fetch_array($result)){
$OrderID = $row2['OrderID'];
$Ordernotes = $row2['Ordernotes'];
$date_stamp = date('Y-m-d H:i:s');
$order_notes = $Ordernotes."\r\n";
$order_notes .= "**** AUTOMATED MESSAGE - ".$date_stamp." ****\r\n";
$order_notes .= "The following repsonses have been received from ****:\r\n";
}
foreach($row as $data) {
echo $data[0].'<br/>';
echo $data[1].'<br/>';
echo $data[2].'<br/>';
echo $data[3].'<br/>';
echo $data[4].'<br/>';
// Start order_notes /
if ($data[3] == '0') {
$order_notes .= "Item Code: ".$data[1]." Status: OK. Delivery Quantity: ".$data[4]."\r\n";
echo "ok";}
if ($data[3] == '1') {
$order_notes .= "Item Code: ".$data[1]." Status: REJECTED (Invalid Product) - Attention required\r\n";
echo "invalid product";}
if ($data[3] == '2') {
$order_notes .= "Item Code: ".$data[1]." Status: REJECTED (Invalid Price) - Attention required\r\n";
echo "invalid price";}
if ($data[3] == '3') {
$order_notes .= "Item Code: ".$data[1]." Status: OK - Backordered. Delivery Quantity: ".$data[4]." Consult BM for ETA \r\n";}
}
$order_notes .= "**** END ****\r\n";
mssql_select_db('****', $conn);
$updatequery = "UPDATE dbo.Orders SET Ordernotes = '$order_notes' WHERE OrderID = '$OrderID'";
$result = mssql_query($updatequery)or (mssql_error());
$order_notes = '';
}
//close the directory
closedir($dir_handle);
?>
