$msgs[] = "Total Deleted Products: {$total_products_deleted} Products";
foreach ($msgs as $msg) {
logProcess($msg, '- ', false);
}
} else {
logProcess('JMS Upload FAILED', '- ', true);
//REMOVE ALL PREPARED FILES (XML AND IMAGES)
$shell = array();
$shell[] = 'cd ' . SP_OTTODE_PATH . 'jms';
$shell[] = 'rm -rf prod-styles';
$shell[] = 'mkdir prod-styles';
$output = shell_exec(implode("\n", $shell));
logProcess('Upload is canceled, all files are deleted', '- ', true);
}
} else {
logProcess('Can not save CAT/Media File to server', '- ', true);
}
echo '+ ';
//templine
//Delete Media files when necessary
$rule1 = $create_image_zip && isset($temp_images);
$rule2 = !$success && !$create_image_zip && isset($temp_images);
if ($rule1 || $rule2) {
foreach ($temp_images as $ti) {
if (file_exists($ti)) {
unlink($ti);
}
}
}
//OTTO.DE UPLOAD PROCESS END
}
/**
* Retrieve table contents Flat
*
* This function, much similar to the eF_getTableData(), retrieves data from the designated
* database table. The main difference lies at the result array format: This time, each
* field in the result set corresponds to an array in the result array.
* <br/>Example:
* <code>
* $result = eF_getTableDataFlat("users", "name, surname");
* print_r($result);
* </code>
* Returns:
* <code>
* Array
* (
* [name] => Array
* (
* [0] => 'john',
* [1] => 'joe',
* [2] => 'mary'
* )
* [surname] => Array
* (
* [0] => 'white',
* [1] => 'black',
* [2] => 'green'
* )
* )
* </code>
*
* @param string $table The database table name.
* @param string $fields Comma separated list of the fields to retrieve, defaults to *.
* @param string $where The where clause of the SQL query.
* @return array The query result table.
* @version 2.0
* @see eF_getTableData()
* Changes from 1.0 to 2.0:
* - Rewritten function in order to accelerate execution. It now uses eF_getTableData()
*/
function eF_getTableDataFlat($table, $fields = "*", $where = "", $order = "", $group = "")
{
$thisQuery = microtime(true);
$sql = "SELECT " . $fields . " FROM " . $table;
if ($where != "") {
$sql .= " WHERE " . $where;
}
if ($order != "") {
$sql .= " ORDER BY " . $order;
}
if ($group != "") {
$sql .= " GROUP BY " . $group;
}
$result = eF_getTableData($table, $fields, $where, $order, $group);
$temp = array();
for ($i = 0; $i < sizeof($result); $i++) {
foreach ($result[$i] as $key => $value) {
$temp[$key][] = $value;
}
}
logProcess($thisQuery, $sql);
return $temp;
}
}
unlink($buyvip_po_filepath);
$logger->write("DONE, FILE DELETED");
logProcess('Process result of ' . $file['filename'] . ':<br />' . "- {$total_orders_created} orders created<br />" . "- {$total_orders_exists} orders alread exists<br />" . "- No auto-cancelation for BuyVIP<br />" . "- {$total_rows_manual_cancel} rows with 0 qty", false);
}
#END foreach $files
}
if ($total_files_processedok > 0) {
$msg = "{$total_files_processedok} Files processed";
$logger->write($msg);
logProcess($msg, false);
}
if ($total_files_unprocessed > 0) {
$msg = "{$total_files_unprocessed} Files FAILED";
$logger->write($msg);
logProcess($msg, true);
}
#END count($files)
}
$total_files_processed += $files_total;
if ($total_files_processed > 0) {
//SEND PROCESS LOG AS EMAIL
$email_msg = '<h3>AMAZON Orders Generator Log (' . $timestamp . ')</h3>';
$has_error = false;
foreach ($process_logs as $pl) {
if ($pl['is_error']) {
$has_error = true;
$color = 'red';
} else {
$color = 'green';
}