//Now fill in the data placeholder with data
$data->appendChild($EDD_as_dom_text);
}
}
break;
case 'ACK_STATE':
if (is_null($i)) {
if ($jng_sp_id == '5') {
//AM.VD Auto Cancelation Rule
$ean_pinfo = $class_ean->getProductArticle($ean);
$po_pid_collection = array();
$po_pid_collection[$ean] = $ean_pinfo['products_id'];
if (isset($ean_detail_info_collections[$ean])) {
$ean_detail_info = $ean_detail_info_collections[$ean];
} else {
$ean_detail_info = $class_jo->getAMVD_AutoCancelSupportingData($po_pid_collection);
$ean_detail_info_collections[$ean] = $ean_detail_info;
}
$as_key = $class_jo->checkAMVD_AutoCancelRule($ean, $ean_detail_info, $sp_specsets) ? 'CP' : 'CO';
} else {
$as_key = 'CO';
}
} else {
$as_key = $i['order_quantity'] == 0 ? 'CO' : 'AC';
}
$data = $cell->firstChild;
$data->removeChild($data->firstChild);
$data->appendChild(new DOMText(utf8_encode($ack_state[$as_key])));
break;
case 'PREV_ERROR':
case 'VEN_CODE':
$class_pe = new products_ean();
$class_pm = new products_minierp();
$class_jo = new jng_sp_orders();
$ean_pid = array();
$orders = array();
$products = array();
foreach ($eanlist as $ean) {
$p_info = $class_pe->getProductArticle($ean);
$pid = $p_info['products_id'];
$ean_pid[$ean] = $pid;
if (!isset($products[$pid])) {
$pdata = $class_pm->retrieveDetail($pid, 'sp');
$products[$pid] = $pdata['sp']['5'];
}
}
$ean_detail_info = $class_jo->getAMVD_AutoCancelSupportingData($ean_pid);
echo "<table id='ean_table' border='1'>";
echo "<tr>";
echo "<th>PID</th>";
echo "<th>EAN</th>";
echo "<th>Status</th>";
echo "<th>Age</th>";
echo "<th>Article Sold</th>";
echo "<th>Products Sold</th>";
echo "</tr>";
foreach ($eanlist as $ean) {
echo "<tr>";
$auto_cancel_rule = !in_array($ean_detail_info[$ean]['products_id'], explode(',', $sp_specsets['amvd-autocancel-excludepids'])) && $ean_detail_info[$ean]['active_age'] >= $sp_specsets['amvd-autocancel-productsage'] && $ean_detail_info[$ean]['total_sold'] <= $sp_specsets['amvd-autocancel-articlesold'] ? '1' : '0';
echo "<td>" . $ean_detail_info[$ean]['products_id'] . "</td>";
echo "<td>{$ean}</td>";
echo "<td align='center'>{$auto_cancel_rule}</td>";
//string result means there are parsing problem
$total_files_unprocessed++;
logProcess($orders, true);
$logger->write($orders);
} else {
$total_orders = count($orders);
$total_orders_created = 0;
$total_orders_exists = 0;
$total_orders_auto_cancel = 0;
$total_rows_manual_cancel = 0;
$lastOrderCount = null;
if ($total_orders > 0) {
$total_files_processedok++;
$amazon_lastname = $amazon_id == $amazon_sample_id ? $amazon_sample_lastname : $amazon_refill_lastname;
$import_date = date('Y-m-d H:i:s');
$ean_detail_info = $amazon_id == $amazon_sample_id ? null : $class_jo->getAMVD_AutoCancelSupportingData($po_pid_collection, $sp_specsets);
$line_counter = $items_starting_rows_in_excel;
foreach ($orders as $o) {
$line_counter++;
$logger->write(date("H:i:s") . " Processing Line {$line_counter} PO={$o['order_id']} / EAN={$o['products_ean']} / Qty={$o['order_quantity']}");
$auto_cancel_rule = $amazon_id == $amazon_sample_id ? false : $class_jo->checkAMVD_AutoCancelRule($o['products_ean'], $ean_detail_info, $sp_specsets);
if ($o['order_quantity'] > 0 && !$auto_cancel_rule) {
$dateonly = date('Y-m-d', $o['order_date']);
if (!in_array($o['customer_shipping_id'], $amazon_shipment_id)) {
if (!in_array($o['order_id'], $new_shipping_id_orders)) {
$subjet = 'AM.VD New Shipping ID';
$message = 'We have received a new Shipping ID from AM.VD: ' . $o['customer_shipping_id'] . ' - Please check and update this PO#: ' . $o['order_id'];
tep_mail(EMAIL_NAME_DEBUGR, EMAIL_ADDRESS_DEBUGR, $subjet, $message, FROM_EMAIL_NAME, FROM_EMAIL_ADDRESS, false);
$new_shipping_id_orders[] = $o['order_id'];
}
}
