PHP products_minierp::retrieveDetail方法代碼示例

 function updateProductStatus($items_id, $new_status, $updater = '', $cancelby = 'J', $add_to_prod_target = true)
 {
     /*==============================================================
       * PURPOSE  :   TO CHANGE PROCESS STATUS ORDER OF PRODUCTS
       * PARAMS   :   $items_id (NUMBER) >> e.g: 1234
       *              $new_status (NUMBER) >> e.g: 1
       *              $updater (STRING) "OPTIONAL" >> e.g: 'mbosse'
       *              $cancelby (STRING) "OPTIONAL" >> e.g: 'S'
       ===============================================================*/
     use_class('production_target');
     $pt = new production_target();
     list($new_status, $sub_status) = explode('-', $new_status);
     $item = $this->retrieveProductDetail($items_id);
     $itemMode = modeName($item['mode']);
     $timestamp = date('Y-m-d H:i:s');
     $is_reviving = statusIsCancelled($item['status']) && !statusIsCancelled($new_status);
     //Revive Item should move to in HH directly if other items are already in HH
     if ($is_reviving) {
         $item_others = $this->retrieveProducts($item['orders_id']);
         $others_in_hh = false;
         //If there's other items are already in HH set new status directly to HH
         foreach ($item_others as $io) {
             if ($io['status'] == '8') {
                 $new_status = '8';
                 $others_in_hh = true;
                 break;
             }
         }
         //If there's no items are already in HH (Full MTO)
         if (!$others_in_hh) {
             use_class('depot_orders');
             $class_do = new depot_orders();
             $item_do = $class_do->retrieveDetailTransmigran('JG', $items_id);
             if (!is_null($item_do)) {
                 if ($item_do['status'] < 6) {
                     /*  Order status is before in Package, do below steps:
                            1) Set real status same with last status of DP
                            2) Consider also set sub production status "only" when main status is in production
                            3) Cancel "directly" DP order, means we not use doCancelOrder
                         */
                     $new_status = $item_do['status'];
                     $sub_status = $new_status == '4' ? $item_do['prod_status'] : '';
                     $class_do->updateStatus($item_do['depot_orders_id'], '12', 'auto-set');
                     $reviving_need_next_update = true;
                     $revived_stock_status = $item_do['stock_status'];
                     $revived_mode = 'MTO';
                 } else {
                     /* Order status is >= "in Package"
                           1) Set real status to New
                        */
                     $new_status = '1';
                 }
             }
         }
     }
     //Only "Sent" and "Complete" status can be updated to "Returned"
     if ($new_status == '14' && !($item['status'] == '9' || $item['status'] == '11')) {
         return false;
     }
     //KPI Logging
     if ($add_to_prod_target) {
         if ($new_status == '5') {
             $pt->addDataToField($timestamp, 'finish', $item['products_quantity']);
         }
         if ($new_status == '6') {
             $pt->addDataToField($timestamp, 'package', $item['products_quantity']);
         }
         if ($new_status == '7') {
             $pt->addDataToField($timestamp, 'sent', $item['products_quantity']);
         }
         if ($new_status == '16') {
             $pt->addDataToField($timestamp, 'log_return_to_bali', $item['products_quantity']);
         }
         if ($new_status == '19') {
             $pt->addDataToField($timestamp, 'log_return_missing', $item['products_quantity']);
         }
         if ($new_status == '20') {
             $pt->addDataToField($timestamp, 'log_return_to_bin_in', $item['products_quantity']);
         }
         if ($new_status == '9') {
             $pt->addDataToField($timestamp, 'log_products_sent_b2c', $item['products_quantity']);
             if ($itemMode == 'DSO') {
                 $pt->addDataToField($timestamp, 'log_products_sent_full_dso', $item['products_quantity']);
             } elseif ($itemMode == 'MTO') {
                 $pt->addDataToField($timestamp, 'log_products_sent_full_mto', $item['products_quantity']);
             } elseif ($itemMode == 'WMO' || $itemMode == 'MMO') {
                 $pt->addDataToField($timestamp, 'log_products_sent_mo', $item['products_quantity']);
             }
         }
     }
     //Update Status and create Status History
     $sda_op = array('status' => $new_status);
     $sda_op['status'] = $new_status;
     if ($new_status == '10') {
         $sda_op['products_problem'] = $cancelby;
     } elseif ($this->productStatusIsCancelled($item['status']) && !$this->productStatusIsCancelled($new_status)) {
         $sda_op['products_problem'] = '0';
     }
     $sub_status = trim(strtoupper($sub_status));
     if ($new_status == '4' && $sub_status != '') {
//.........這裏部分代碼省略.........

 */
global $db;
require_once '../confy.php';
require_once '../functions.php';
require_once '../functions-2.php';
tep_db_connect();
use_class('ProductCOGS');
use_class('products_minierp');
$class_pm = new products_minierp();
$year = '2014';
$date_ranges = array();
$date_ranges['Jan'] = "'{$year}-01-01 00:00:00' AND '{$year}-01-31 23:59:59'";
$date_ranges['Feb'] = "'{$year}-02-01 00:00:00' AND '{$year}-02-28 23:59:59'";
$date_ranges['Mar'] = "'{$year}-03-01 00:00:00' AND '{$year}-03-31 23:59:59'";
$bgst = $class_pm->retrieveBestGoodSettings();
echo "<h3>Total COGS Products Sent to HH {$year}</h3>";
foreach ($date_ranges as $m => $date_range) {
    echo "{$m}: ";
    $q = "SELECT op.products_id, opsh.status_quantity qty FROM orders_products op\r\n    INNER JOIN `orders_products_status_history` opsh ON opsh.orders_products_id = op.orders_products_id\r\n    WHERE opsh.status = 7 AND opsh.status_date BETWEEN {$date_range}\r\n    UNION ALL\r\n    SELECT joi.products_id, status_quantity qty FROM jng_sp_orders_items joi\r\n    INNER JOIN `jng_sp_orders_items_status_history` joish ON joish.jng_sp_orders_items_id = joi.jng_sp_orders_items_id\r\n    WHERE joish.status = 7 AND joish.status_date BETWEEN {$date_range}\r\n    UNION ALL\r\n    SELECT do.products_id, quantity qty FROM depot_orders do\r\n    INNER JOIN depot_orders_status_history dosh ON dosh.depot_orders_id = do.depot_orders_id AND dosh.status = 7\r\n    WHERE dosh.update_time BETWEEN {$date_range}\r\n    ";
    $dbq = tep_db_query($q);
    $total_cogs = 0;
    while ($r = tep_db_fetch_array($dbq)) {
        $pid = $r['products_id'];
        $qty = $r['qty'];
        $products = $class_pm->retrieveDetail($pid, 'p');
        $cogs = new ProductCOGS($products['p']['material_expenses'], $products['p']['complexity']);
        $total_cogs += $cogs->value * $qty;
    }
    echo number_format($total_cogs, 2) . "<br/>";
}
tep_db_close();

        ajaxReturn($result);
        exit;
    } elseif ($_POST['me_action'] == 'COPYELEMENTS') {
        $pid_to_applied = tep_db_prepare_input($_POST['pid']);
        $pid_to_copied = tep_db_prepare_input($_POST['pidcopy']);
        $el_id_excluded = tep_db_prepare_input($_POST['elidexcluded']);
        $elidcopy = tep_db_prepare_input($_POST['elidcopy']);
        $qtycopy = tep_db_prepare_input($_POST['qtycopy']);
        //        $el_added = $class_pm->addElementToProducts($pid_to_applied, $elidcopy, $qtycopy);
        $class_pm->copyFromProducts($pid_to_copied, $pid_to_applied, 'eu', $el_id_excluded);
        echo utf8_encode("{$pid_to_copied}-{$pid_to_applied}");
        exit;
    }
}
//TEMPLATE
$eu_p = $class_pm->retrieveDetail($products_id, 'p,pd,pei');
$content .= '<div class="ui-corner-all" style="text-align:center;position:fixed;left:10px;width:212px;padding:5px;">';
if ($is_accessed_from_design_mgmt) {
    use_class('design_draft');
    $draft = new design_draft(null, $products_id);
    $content .= webImageWithDetailLink($draft->image_1, IMAGE_SIZE_THUMBNAIL_3, IMAGE_SIZE_THUMBNAIL_3, 'Product ' . $products_id, 'img-border');
} else {
    $content .= webImageWithDetailLink($eu_p['p']['products_image'], IMAGE_SIZE_THUMBNAIL_3, IMAGE_SIZE_THUMBNAIL_3, 'Product ' . $products_id, 'img-border');
    $content .= '<div style="width:100%;float:left;">';
    foreach ($eu_p['pei'] as $peid => $products_extra_images) {
        $content .= '<div style="float:left;margin:10px 0 10px 10px;">' . webImageWithDetailLink($products_extra_images, IMAGE_SIZE_THUMBNAIL_1, IMAGE_SIZE_THUMBNAIL_1, 'Product ' . $products_id . ' Additional Image', 'img-border') . '</div>';
    }
    $content .= '</div>';
}
$content .= '<div>' . $eu_p['p']['products_model'] . ' / ' . $eu_p['pd'][2]['products_name'] . '</div>';
$content .= '</div>';

 function isPhotoProductComplete($products = array())
 {
     use_class('products_minierp');
     $class_pm = new products_minierp();
     if (count($products) == 0) {
         $products = $this->retrieveProducts();
     }
     $photos_is_complete = count($products) > 0 ? true : false;
     foreach ($products as $p) {
         $dt_p = $class_pm->retrieveDetail($p['products_id'], 'p');
         if ($dt_p['p']['products_image'] == '') {
             $photos_is_complete = false;
             break;
         }
     }
     return $photos_is_complete;
 }

    $class_pa->processAction();
    $class_jc->processCommentAction();
}
//CHECK WHETHER PRODUCTS IS REMOVED OR NOT
$loadform = '<div style="margin-bottom:20px;"><form name="open_product" action="?open=sp-product" method="post">';
$loadform .= 'Product ID <input type="text" name="product_id" value="" /><input type="submit" name="submit" value="Load Product" />';
$loadform .= '</form></div>';
$products_removed = productIsRemoved($product_id);
if ($products_removed['is_removed']) {
    $content .= $loadform;
    $content .= $products_removed['msg_removed'];
} else {
    //START TEMPLATE
    $show_product_status_box = true;
    if (isset($product_id) && intval($product_id > 0)) {
        $product = $class_pm->retrieveDetail($product_id, 'p,pc');
        $spinfo = $class_jc->retrieveDetail(null, $jng_sp_id, $product_id);
        if (is_array($product) || is_array($spinfo)) {
            $show_product_status_box = false;
        }
    }
    $content = '';
    if ($show_product_status_box) {
        $content .= $loadform;
    }
    if (isset($product) && is_array($product)) {
        $image = webImage($product['p']['products_image'], '500', '', '', 'img-border img-padding');
        if (!is_array($spinfo)) {
            $article_number = $product['p']['products_model'];
            $suppliers_products_id = '';
            $content .= '<div style="float:left;margin: 0px 10px 20px 0px;">' . $image . '</div>';

             $header = str_replace("|n|", "\n", $ch);
             $colsize += $colwidth;
         } else {
             $colsize = 0;
         }
         $pdf->setXY($margin + $colsize, $pdf->ypos);
         $pdf->MultiCell($colwidth, $lineheight_header, $header, 1, 'C', true);
     }
 } else {
     $pdf->ypos += $key == 1 ? $lineheight_header + 5.2 : $lineheight;
     $pdf->setXY($margin, $pdf->ypos);
     foreach ($cols_value as $rkey => $cr) {
         if ($rkey == $col_image - 1) {
             $pdf->Cell($colwidth, $lineheight, '', 1, 0, 'C');
             //                die($cols_value[0]);
             $items = $class_pm->retrieveDetail($cols_value[0], 'p');
             $img_path = DIR_WS_IMAGES . 'imagecache/';
             $img_file = basename(webImageSource($items['p']['products_image'], IMAGE_SIZE_THUMBNAIL_1, IMAGE_SIZE_THUMBNAIL_1));
             $img = $img_path . $img_file;
             $x_col = $margin + ($col_image - 1) * $colwidth;
             $posx_image = $x_col + 3;
             $pdf->Image($img, $posx_image, $pdf->ypos + 4, 20);
             //PRINT TEXT BELOW IMAGE
             $pdf->setXY($x_col, $pdf->ypos + $lineheight - ($lineheight / 2 + 2));
             $text_under_image_height = $lineheight;
             if ($pdf->PageNo() > 1) {
                 $text_under_image_height -= 3.1;
             } else {
                 $text_under_image_height -= 2;
             }
             $pdf->Cell($colwidth, $text_under_image_height, $cr, 0, 0, 'C');

$content .= '<th rowspan="2">No</th>';
$content .= '<th rowspan="2">Product</th>';
$content .= '<th rowspan="2">Articles</th>';
$content .= '<th rowspan="2">Stock</th>';
$content .= '<th colspan="2">Acive Booking</th>';
$content .= '<th rowspan="2">Cache<br />Status</th>';
$content .= '</tr><tr>';
$content .= '<th>Query</th>';
$content .= '<th>Cache</th>';
$content .= '</tr></thead>';
$content .= '<tbody>';
$rowcount = 0;
foreach ($articles_result as $pid => $articles) {
    $rowcount++;
    $rowclass = $rowcount % 2 == 0 ? 'e' : 'o';
    $pdata = $class_pm->retrieveDetail($pid, 'p,pnc');
    $alist = $class_pa->retrieveList($pid);
    $adata = array();
    foreach ($alist as $al) {
        $adata[$al['products_articles_id']] = $al;
    }
    $content .= '<tr class="' . $rowclass . '">';
    $content .= '<td class="id">' . $rowcount . '</td>';
    $content .= '<td>';
    $content .= webImage($pdata['p']['products_image'], IMAGE_SIZE_THUMBNAIL_1, IMAGE_SIZE_THUMBNAIL_1, 'Product ' . $pid);
    $content .= '<br /><a href="?open=product-detail&amp;products_id=' . $pid . '">' . $pid . '</a>';
    $content .= '</td>';
    $col_ean = '';
    $col_stock = '';
    $col_booked_query = '';
    $col_booked_cache = '';

 $total_products_canceled = 0;
 $worst_status = 12;
 $worst_status_date = 0;
 $tables = array();
 $tables[] = $header;
 foreach ($items as $ikey => $i) {
     $total_products++;
     $item_object = $order_object->getItem($i[$items_colname_id]);
     if (statusIsCancelled($i['status'])) {
         $total_products_canceled++;
     } else {
         if ($i['status'] > 8) {
             $total_products_sent++;
         }
     }
     $product = $class_pm->retrieveDetail($i['products_id'], 'p,pnc');
     $article = $i['products_articles_id'] > 0 ? $class_pa->retrieveDetail($i['products_articles_id']) : null;
     $ordered_qty = intval($i[$items_colname_qty]);
     if ($i['status'] == 8) {
         if ($i['stock_status'] == 'D') {
             $total_products_depot_ready++;
             if ($i['print_count'] == '1') {
                 $total_products_depot_ready_printed++;
             }
         }
         if ($i['mode'] == modeKey('MMO')) {
             $do = $class_do->retrieveDetailTransmigran($source, $i[$items_colname_id]);
             if ($i['stock_status'] != 'D' || $i['stock_status'] == 'D' && $do['status'] == 8) {
                 $i['status'] = $do['status'];
                 $i['status_date'] = $do['status_date'];
             }

 function deleteProduct($products_id, $username)
 {
     use_class('products_minierp');
     use_class('minierp_users');
     $class_pm = new products_minierp();
     $class_mu = new minierp_users();
     $p = $class_pm->retrieveDetail($products_id, 'pd');
     $class_pm->deleteNewProduct($products_id);
     tep_db_query("DELETE FROM designs_products WHERE products_id={$products_id}");
     $class_mu->removeFromWatchlist('*', $products_id);
     if ($username != 'draft-deletion') {
         $comment = 'I delete Product ID ' . $products_id . ' (' . $p['pd']['2']['products_name'] . ')';
         $this->comments->addComment($username, $comment);
     }
 }

 $lineheight = 5;
 $pdf->setXY($colpos, $pdf->ypos);
 $pdf->setFont('Arial', 'B', $fontsize_med);
 $pdf->SetFillColor(191, 191, 191);
 $pdf->Cell($col_subcol_width[1], $lineheight, 'Pos.', 1, 0, 'C', true);
 $pdf->Cell($col_subcol_width[2], $lineheight, 'Bild', 1, 0, 'C', true);
 $pdf->Cell($col_subcol_width[3], $lineheight, 'Größe', 1, 0, 'C', true);
 $pdf->Cell($col_subcol_width[4], $lineheight, 'Produktkategorie', 1, 0, 'C', true);
 $pdf->Cell($col_subcol_width[5], $lineheight, 'Article', 1, 0, 'C', true);
 $pdf->Cell($col_subcol_width[6], $lineheight, 'EAN', 1, 0, 'C', true);
 $pdf->Cell($col_subcol_width[7], $lineheight, 'Preis', 1, 0, 'C', true);
 $pdf->Cell($col_subcol_width[8], $lineheight, 'Menge', 1, 0, 'C', true);
 $pdf->ypos += $lineheight;
 $item_counter = 0;
 foreach ($items as $item) {
     $product = $class_pm->retrieveDetail($item['products_id'], 'p,pd,pnc,cat');
     if ($item['products_articles_id'] == 0) {
         $size = $product['pnc']['products_length'] > 0 ? textLength($product['pnc']['products_length']) : '-';
     } else {
         $article = $class_pa->retrieveDetail($item['products_articles_id']);
         $size = textLength($article['length']);
     }
     //            echo '<pre>';
     //            var_dump($product);
     //            echo '</pre>';
     $item_counter++;
     $img_pdf = '';
     $img_path = DIR_WS_IMAGES . 'imagecache/';
     $img_file = basename(webImageSource($product['p']['products_image'], IMAGE_SIZE_THUMBNAIL_2, IMAGE_SIZE_THUMBNAIL_2));
     $img = $img_path . $img_file;
     if ($img != $img_path) {

 /**
  * Generate family match key
  * @param Int $products_id
  * @param Int $articles_id
  * @return String
  */
 function refreshFamilyMatchKey($products_id, $articles_id = null)
 {
     //$group_ref_el_cat = array('casting', 'findings', 'handmade', 'chains', 'pearl');
     $group_ref_el_cat = $this->el_cat_searchkey;
     //Old Key formula : brand_id-categories_id-[el_id-qty] >> 13.12.10 changed to exclude brand_id
     //New Key formula : categories_id-[el_id-qty]
     use_class('element');
     use_class('products_minierp');
     use_class('products_articles');
     $class_pa = new products_articles();
     $class_pm = new products_minierp();
     if (is_null($products_id)) {
         $articles = $class_pa->retrieveDetail($articles_id);
         $products_id = $articles['products_id'];
     }
     $family_searchkey = '';
     $key1 = array();
     $key2 = array();
     $el_used = $class_pm->retrieveElementsUsage($products_id, $articles_id);
     if (count($el_used) > 0) {
         //$p_data = $class_pm->retrieveDetail($products_id, 'p,cat');
         $p_data = $class_pm->retrieveDetail($products_id, 'cat');
         //$key1[] = $p_data['p']['products_brand_id'];
         $key1[] = $p_data['categories_id'];
         foreach ($el_used as $dt) {
             $elid = $dt['elements_id'];
             $el = new element($elid);
             if (in_array($el->attributes['category']['id'], $group_ref_el_cat)) {
                 $key2[] = $elid;
                 $key2[] = $dt['quantity'];
             }
         }
         if (count($key2) > 0) {
             $family_searchkey = implode('-', array_merge($key1, $key2));
             if (is_null($articles_id)) {
                 tep_db_perform('products', array('family_searchkey' => $family_searchkey), 'update', "products_id={$products_id}");
                 //update also articles if exist
                 $articles = $class_pa->retrieveList($products_id);
                 foreach ($articles as $article) {
                     $articles_id = $article['products_articles_id'];
                     $this->refreshFamilyMatchKey($products_id, $articles_id);
                 }
             } else {
                 tep_db_perform('products_articles', array('family_searchkey' => $family_searchkey), 'update', "products_articles_id={$articles_id}");
             }
         }
     }
     return $family_searchkey;
 }

     $result = false;
     $q_pnc = "SELECT * FROM products_non_configurator WHERE products_id = {$pid}";
     $r_pnc = tep_db_query($q_pnc);
     $pnc = tep_db_fetch_array($r_pnc);
     $production_instruction_id = explode(",", $pnc['production_instruction_id']);
     $key = array_search($piid, $production_instruction_id);
     unset($production_instruction_id[$key]);
     $data['production_instruction_id'] = implode(",", $production_instruction_id);
     tep_db_perform('products_non_configurator', $data, 'update', "products_id={$pid}");
     $result['piid'] = $piid;
     ajaxReturn($result);
     exit;
 } elseif ($_POST['me_action'] == 'DETAILCOMPLETE') {
     $products_id = tep_db_prepare_input($_POST['products_id']);
     $make_template = tep_db_prepare_input($_POST['make_template']);
     $product = $class_pm->retrieveDetail($products_id, 'p,pd,pnc');
     $articles = $class_pa->retrieveList($products_id);
     if ($make_template == 'true') {
         use_class('products_linking');
         use_class('products_articles');
         $class_pl = new products_linking();
         $class_pa = new products_articles();
         $products_to_update = array();
         $draft = new design_draft(null, $products_id);
         $ucd_products = $draft->retrieveProducts("detailed_time IS NULL AND detailed_by IS NULL");
         //uncomplete detail products
         foreach ($ucd_products as $ucdp) {
             if ($ucdp['products_id'] != $products_id) {
                 $products_to_update[] = $ucdp['products_id'];
             }
         }

 $maxkeywords = 94 - (strlen($brand_id) + strlen($properName));
 if ($maxkeywords > 64) {
     $maxkeywords = 64;
 }
 //don't send manual keywords to otto.de
 //$keywords = $p['keywords'];
 $keywords = '';
 $keywords_name = $properName == '' ? $p['name'] : '';
 $keywords = addAutoKeywords($keywords, $maxkeywords, $keywords_name, '', ', ');
 if ($keywords == '') {
     $keywords = $product_categories_name[$p['categories_id']];
 }
 $xml_content .= writeXMLline('KeyWord', $keywords, 2);
 //Product description
 $p['description'] .= str_replace("\n", '<br>', categoryExtraDescription($p['categories_id'], $sp_detail['languages_id']));
 $pd2data = $class_pm->retrieveDetail($p['products_id'], 'pd2');
 $desc2_label = $class_pm->description2_label($pd2data['pd2']);
 $proddesc2 = array();
 foreach ($desc2_label as $label => $value) {
     $proddesc2[] = $label . ': ' . $value;
 }
 $p['description'] .= '<br><br>Produktdetails:<br><ul><li>' . implode('</li><li>', $proddesc2) . '</li></ul>';
 $html_long_desc = $p['description'];
 $long_desc = strip_tags(str_replace('<li>', ' ', $html_long_desc));
 $xml_content .= writeXMLline('LongDesc', $long_desc, 2);
 $xml_content .= writeXMLline('HTMLLongDesc', $html_long_desc, 2);
 //Warengruppe / Class of Goods
 $warengruppe = translateOttoCategory($p['categories_id']);
 $xml_content .= writeXMLline('ClassOfGoods', $warengruppe, 2);
 //Product Navigatins (nav ids) / Cluster
 $sp_navid = $navids[$p['navigation']];

     $label_image = tep_db_prepare_input($_POST['type']);
     $key_id = tep_db_prepare_input($_POST['keyid']);
     $img_name = tep_db_prepare_input($_POST['img_name']);
     $pid = tep_db_prepare_input($_GET['products_id']);
     if ($label_image == 'mi2') {
         $check_ci_exists = tep_db_query("SELECT products_clear_image FROM products_clear_images WHERE products_id={$pid}");
         if (tep_db_num_rows($check_ci_exists) > 0) {
             $ci_rem = tep_db_fetch_array($check_ci_exists);
             $delete_file = $uploaddir . $ci_rem['products_clear_image'];
             if (file_exists($delete_file)) {
                 unlink($delete_file);
                 tep_db_query("DELETE FROM products_clear_images WHERE products_id={$pid}");
             }
         }
     } elseif ($label_image == 'mi3') {
         $p_data = $class_pm->retrieveDetail($pid, 'p');
         $delete_file = $uploaddir . $p_data['p']['products_pure_image'];
         if (file_exists($delete_file)) {
             unlink($delete_file);
             tep_db_perform('products', array('products_pure_image' => ''), 'update', 'products_id=' . $pid);
         }
     } elseif ($label_image == 'pei') {
         if (delete_extra_image($key_id)) {
             tep_db_query("DELETE FROM products_extra_images WHERE products_extra_images_id={$key_id}");
         }
         $label_image = 'Additional Image ' . str_replace('products_extra_image_', '', $img_name);
     }
     $class_pm->autoUpdateSalesPartnerCatalog($pid);
     echo "OK";
     exit;
 }

        if ($stock == 0) {
            //KILL PRODUCT AND REMOVE IT FROM DTK COLLECTION
            $username = 'auto-set';
            $class_pm->killProduct($pid, $username);
            $class_s->remProduct($style_id, $pid, $username);
            $killed[] = $pid;
        }
    }
    $killed_total = count($killed);
    //Notify Design and IT Team
    if ($killed_total > 0 || date('N') == 7) {
        $subject = 'Auto Kill DTK Collection (' . $killed_total . ')';
        $send_message = '<div>' . $killed_total . ' Product' . ($killed_total > 1 ? 's are' : ' is') . ' auto killed today from DTK collection</div>';
        if ($killed_total > 0) {
            foreach ($killed as $pid_killed) {
                $product = $class_pm->retrieveDetail($pid_killed, 'p');
                $image = webImage($product['p']['products_image'], IMAGE_SIZE_THUMBNAIL_1, IMAGE_SIZE_THUMBNAIL_1);
                $send_message .= '<div style="float:left;margin-right:15px;">' . '<div>' . $image . '</div><div style="text-align:center;">' . $pid_killed . '</div></div>';
            }
            //$send_message .= ':<br />' . implode(', ', $killed);
        }
        tep_mail(EMAIL_DESIGNTEAM_NAME, EMAIL_DESIGNTEAM_ADDRESS, $subject, $send_message, FROM_EMAIL_NAME, FROM_EMAIL_ADDRESS, false);
        tep_mail(EMAIL_SALESMARKETINGTEAM_NAME, EMAIL_SALESMARKETINGTEAM_ADDRESS, $subject, $send_message, FROM_EMAIL_NAME, FROM_EMAIL_ADDRESS, false);
    }
}
$logger->write("Task 6 - End");
$logger->write("Task 7 (AMAZON ORDER MISSED SHIPPING WINDOW) - Start");
/////////////////////////////////////////
// AMAZON ORDER MISSED SHIPPING WINDOW //
/////////////////////////////////////////
$today = date('Y-m-d');