$td[$k] = $value;
}
$table_data[] = $td;
}
$result .= tep_draw_table('', $table_data);
$result .= '<h3 style="margin:10px 0 20px 0">';
$result .= '<a href="?open=products-stock-booking-active&hidemenu=true" class="view_webpage">» Click here to see overview of all Active Bookings</a>';
$result .= '</h3>';
$overlap_products = stock_booking::getBookedQuantityOverlap(WAREHOUSE_ID_PRODUCTS_HAMBURG);
if (count($overlap_products) == 0) {
$result .= '<h3>No Overlap Products found in Active Booking Order';
} else {
use_class('products_minierp');
use_class('products_articles');
$class_pm = new products_minierp();
$class_pa = new products_articles();
$hn_no = 'No';
$hn_prod = 'Product';
$hn_arts = 'Articles';
$hn_name = 'Overlapping Orders';
$hn_book = 'Total<br />Booked';
$hn_stock = 'Stock';
$header = array();
$header['0 id'] = $hn_no;
$header['1 date'] = $hn_prod;
$header['2 date'] = $hn_arts;
$header['3 desc'] = $hn_name;
$header['4 countpro'] = $hn_stock;
$header['5 countpro'] = $hn_book;
$result .= '<h2>Overlap Products in Active Booking Order</h2>';
$table_data = array();
function isReadyForGraphics()
{
use_class('products_articles');
$class_pa = new products_articles();
use_class('products_minierp');
$class_pm = new products_minierp();
$drafts = $this->retrieveDrafts("approve_status!='R'");
if (count($drafts) > 0) {
$products = $this->retrieveProducts();
$drafts_products = array();
foreach ($products as $p) {
if (!in_array($p['drafts_id'], $drafts_products)) {
$drafts_products[] = $p['drafts_id'];
}
}
} else {
return false;
}
$rule1 = count($drafts_products) >= count($drafts);
if (!$rule1) {
return $rule1;
}
foreach ($products as $p) {
$el_usage = $class_pm->retrieveElementsUsage($p['products_id']);
$rule2 = count($el_usage) > 0;
if (!$rule2) {
return $rule2;
}
}
foreach ($products as $p) {
$pa = $class_pa->retrieveList($p['products_id']);
foreach ($pa as $val) {
$rule3 = $class_pa->haveOverridedElement($val['products_articles_id']);
if (!$rule3) {
return $rule3;
}
}
}
foreach ($products as $p) {
$qm = "SELECT is_main FROM products_use_elements WHERE is_main = '1'" . " AND products_id = '" . $p['products_id'] . "'";
$qm_r = tep_db_query($qm);
$rule4 = tep_db_num_rows($qm_r);
if ($rule4 == 0) {
return $rule4;
}
}
return true;
}
<?php
use_class('jng_sp');
$class_sp = new jng_sp();
use_class('jng_sp_catalog');
$class_jc = new jng_sp_catalog();
use_class('products_minierp');
$class_pm = new products_minierp();
use_class('products_brand');
$class_pb = new products_brand();
use_class('products_articles');
$class_pa = new products_articles();
//SP SETTING
salesPartnerCombo();
$url_link_path = "http://" . $_SERVER['SERVER_NAME'] . $_SERVER['REQUEST_URI'];
if (isset($_GET['id'])) {
$product_id = tep_db_prepare_input($_GET['id']);
} elseif (isset($_POST['product_id'])) {
$product_id = tep_db_prepare_input($_POST['product_id']);
}
//SUBMIT ACTION
if (isset($_POST['me_action'])) {
if ($_POST['me_action'] == 'ADDTOCATALOGUE') {
$suppliers_products_id = tep_db_prepare_input($_POST['suppliers_products_id']);
//sp_addProductToCatalog($jng_sp_id, $product_id, $suppliers_products_id);
$class_jc->addProduct($jng_sp_id, $product_id, $suppliers_products_id);
header("Location: ?open=sp-product&id={$product_id}");
exit;
} elseif ($_POST['me_action'] == 'UPDATECATALOG') {
$field_id = null;
$catalog_id = tep_db_prepare_input($_POST['jng_sp_catalog_id']);
$q = tep_db_query("SELECT invoice_id FROM `payone_invoice` WHERE invoice_date < '{$date_tolerance}' AND invoice_complete_status = '0'");
while ($row = tep_db_fetch_array($q)) {
$invoice = new payone_invoice('invoice_id', $row['invoice_id']);
$invoice->recalculate();
}
$logger->write("Task 5 - End");
$logger->write("Task 6 (DOOM TO KILL CHECKER) - Start");
if (SERVER_IS_LOCAL) {
$logger->write("Skipped! Not to be run in Manobo Local");
} else {
use_class('styles');
use_class('products_minierp');
use_class('products_articles');
$class_s = new styles();
$class_pm = new products_minierp();
$class_pa = new products_articles();
$style_id = 680;
//COLLECTION: DOOMED TO BE KILLED
$products = $class_s->retrieveProducts($style_id, false);
$killed = array();
$logger->write('Total products to check: ' . count($products));
foreach ($products as $pid => $date_added) {
//SET INACTIVE FOR DTK ARTICLES WHICH HAVE NO DEPOT STOCK
$products_articles = $class_pa->retrieveList($pid);
foreach ($products_articles as $pa) {
$stock_article = $class_pm->stockRetrieve(WAREHOUSE_ID_PRODUCTS_HAMBURG, $pid, $pa['products_articles_id']);
if ($stock_article == 0) {
$class_pa->setActiveStatus($pa['products_articles_id'], 0);
}
}
$stock = $class_pm->stockRetrieve(WAREHOUSE_ID_PRODUCTS_HAMBURG, $pid, '*');
<?php
/**
* THIS MODULE IS CALLED FROM PRODUCTS ANALYSIS
*
* @author IT TEAM BONOFACTUM
* @created Feb 28, 2013 4:14:49 PM
*/
use_class('stock_booking');
use_class('products_minierp');
use_class('products_articles');
$class_pm = new products_minierp();
$class_pa = new products_articles();
$hn_product = 'Product';
$hn_article = 'Articles';
$hn_custock = 'Current<br />Stock';
$hn_cbooked = 'Total Booked<br />in Active Orders';
$hn_cbohere = 'Booked in<br />This Order';
$product_table_header = array();
$product_table_header['0 long_id'] = $hn_product;
$product_table_header['1 source'] = $hn_article;
$product_table_header['2 source'] = $hn_custock;
$product_table_header['3 source'] = $hn_cbooked;
$product_table_header['4 source'] = $hn_cbohere;
$id = tep_db_prepare_input($_GET['id']);
$booking = new stock_booking($id);
if (isset($_POST['me_action'])) {
if ($_POST['me_action'] == 'UPDATENAME') {
$new_name = tep_db_prepare_input($_POST['name']);
$booking->update(null, $new_name);
echo utf8_encode($booking->name);
<?php
use_class('products_articles');
use_class('products_ean');
use_class('products_minierp');
$class_ean = new products_ean();
$class_pm = new products_minierp();
$class_pa = new products_articles();
if (isset($_POST['me_action'])) {
if ($_POST['me_action'] == 'GETPRODUCTDETAIL') {
$product_input = tep_db_prepare_input($_POST['product_input']);
$result = false;
$elements_datas = array();
$jng_warehouses_id = 1;
if (strlen($product_input) == 13) {
$ean = $product_input;
$product_info = $class_ean->getProductArticle($ean);
if (!empty($product_info['products_id']) && !is_null($product_info['products_id'])) {
$products_id = $product_info['products_id'];
$articles_id = $product_info['products_articles_id'];
$product_data = $class_pm->retrieveDetail($products_id, 'p');
$elements_used = $class_pm->retrieveElementsUsage($products_id, $articles_id);
foreach ($elements_used as $element) {
$element_stock_query = "SELECT es.stock";
$element_stock_query .= " FROM elements_stock es";
$element_stock_query .= " WHERE es.jng_warehouses_id={$jng_warehouses_id}";
$element_stock_query .= " AND es.elements_id=" . $element['elements_id'];
$element_stock_result = tep_db_query($element_stock_query);
if (tep_db_num_rows($element_stock_result) > 0) {
$element_stock = tep_db_fetch_array($element_stock_result);
$el_stock = $element_stock[stock];
<?php
use_class('jng_sp');
$class_sp = new jng_sp();
use_class('jng_sp_catalog');
$class_jc = new jng_sp_catalog();
use_class('products_minierp');
$class_pm = new products_minierp();
use_class('products_articles');
$class_pa = new products_articles();
//SUBMIT ACTION
if (isset($_POST['me_action'])) {
if ($_POST['me_action'] == 'UPDATECATALOG') {
$catalog_id = tep_db_prepare_input($_POST['id']);
$fieldName = tep_db_prepare_input($_POST['field_name']);
$fieldValue = tep_db_prepare_input($_POST['field_value']);
if (strpos($fieldName, '-') === false) {
$dataArray = array($fieldName => $fieldValue);
if ($fieldName == 'price') {
$dataArray['status_price'] = '1';
}
$class_jc->updateField($catalog_id, $dataArray);
} else {
$data = explode('-', $fieldName);
if ($data[0] == 'pa') {
$products_articles_id = $data[2];
switch ($data[1]) {
case 'price':
$price = $fieldValue;
$price_old = null;
break;
<?php
/**
* Description of sp-preorder
*
* @author IT TEAM BONOFACTUM
* @created Apr 2, 2013 12:23:40 PM
*/
use_class('jng_sp');
use_class('jng_sp_preorders');
use_class('products_minierp');
use_class('products_articles');
$class_sp = new jng_sp();
$class_pm = new products_minierp();
$class_pa = new products_articles();
$id = isset($_GET['id']) ? tep_db_prepare_input($_GET['id']) : null;
$preorder = new jng_sp_preorders($id);
$is_confirmed = $preorder->status != '1';
function drawArticleLine($pid, $aid, $active, $ean, $length, $item_id = null, $last_update = null, $stock = null, $reported = '0', $booked = '0', $preproduce = '0', $ondemand = '0', $realtotal = null, $realondemand = null, $locked = false)
{
global $class_pm, $tabindex;
if (!isset($tabindex)) {
$tabindex = 1;
}
$disabled = $locked ? ' disabled="disabled"' : '';
$inactive = $active == '1' ? '' : ' notice" title="Inactive Article';
$result = array();
$result['ao'] = '<div id="' . $pid . '-' . $aid . '-' . $ean . '" class="article aid' . $inactive . '">' . 'EAN ' . $ean . ($length > 0 ? ' ⋅ ' . textLength($length) : '') . '</div>';
$stock_current = $class_pm->stockRetrieve(WAREHOUSE_ID_PRODUCTS_HAMBURG, $pid, $aid);
if (!is_null($item_id)) {
$result['as'] = '<div class="article"><span id="stsaved-' . $pid . '-' . $aid . '" title="Saved on ' . date('d.m', strtotime($last_update)) . '">' . $stock . '</span> (<span id="st-' . $pid . '-' . $aid . '">' . $stock_current . '</span>)</div>';
<?php
//*SPECIAL NOTE: THIS MODULE IS CALLED FROM PRODUCTS ANALYSIS
use_class('jng_sp');
use_class('jng_sp_customers');
use_class('jng_sp_orders');
use_class('products_minierp');
use_class('products_articles');
$class_sp = new jng_sp();
$class_jc = new jng_sp_customers();
$class_jo = new jng_sp_orders();
$class_pm = new products_minierp();
$class_pa = new products_articles();
$jng_sp_id = '6';
$sp_detail = $class_sp->retrieveDetail($jng_sp_id);
$class_col_pimg = 'img';
$class_col_desc = 'product tac';
$class_col_articles = 'name tac';
$clist_headers = array();
$clist_headers['customers'] = 'Store Owner / Name';
$clist_headers['task'] = 'Store / Shipping Address';
$clist_headers['input2'] = 'Billing Address';
$clist_headers['countpro'] = 'Qty per Article';
$clist_headers['act'] = ' ';
$clist_template = '<tr class="customer">';
foreach ($clist_headers as $k => $v) {
switch ($k) {
case 'countpro':
$value = '<input type="text" name="qty_per_article" value="1" class="tac" style="width:30px;" />';
break;
case 'act':
/**
* Template for managing override elements used
*/
function templateOverrideElementsUsed()
{
/*===========================================================
* ADD.INFO : o >> override
* or >> override reset
* rd >> replace default
=============================================================*/
use_class("element");
use_class("products_articles");
$class_pa = new products_articles();
$ovr_data = array();
$ovr_def_data = array();
$ovr_type = isset($_POST['ovr_type']) && $_POST['ovr_type'] != '' ? $_POST['ovr_type'] : 'o';
$pid = $_POST['products_id'];
$pean = $_POST['ovr_pean'];
$paid = $_POST['ovr_paid'];
$pueid = $_POST['ovr_pueid'];
$elid_def = $_POST['ovr_elid_def'];
$qty_def = $_POST['ovr_qty_def'];
$elid_old = $_POST['ovr_elid_old'];
$qty_old = $_POST['ovr_qty_old'];
$elid_ovr = $_POST['ovr_id'];
$qty_ovr = $_POST['ovr_qty'];
$ovr_el_article = $_POST['ovr_el_article'];
//PREPARE OVERRIDE DATA
$ovr_data['products_articles_id'] = $paid;
$ovr_data['products_use_elements_id'] = $pueid;
$ovr_data['elements_id'] = '0';
$ovr_data['quantity'] = '';
$changes = 'elid';
$ovr_def_data['elements_id'] = '0';
$ovr_def_data['quantity'] = '';
$is_override = true;
$el_ovr_found = false;
if ($ovr_type == 'o') {
if ($elid_ovr == $elid_def) {
//NO ELEMENT CHANGES
$el_ovr_found = true;
if ($qty_ovr == $qty_def) {
//NO QTY CHANGES
$is_override = false;
} else {
$changes = 'qty';
$ovr_data['quantity'] = $qty_ovr;
$ovr_msg = "Quantity of Article {$pean} Element ID <strong>{$elid_def}</strong> is overrided become {$qty_ovr}.";
}
} else {
//ELEMENT CHANGES
$e = new element($elid_ovr);
if (!is_null($e->id)) {
$el_ovr_found = true;
$ovr_data['elements_id'] = $elid_ovr;
$ovr_data['quantity'] = $qty_ovr;
$ovr_msg = "Article {$pean} Element ID Default <strong>{$elid_def}</strong> is overrided become {$elid_ovr} with quantity {$qty_ovr}.";
} else {
$is_override = false;
}
}
}
if ($ovr_type == 'rd') {
if ($elid_ovr == $elid_def) {
//NO ELEMENT CHANGES
$el_ovr_found = true;
if ($qty_ovr == $qty_def) {
//NO QTY CHANGES
$is_override = false;
} else {
$changes = 'qty';
$ovr_def_data['quantity'] = $qty_ovr;
$ovr_msg = "Quantity Element ID <strong>{$elid_def}</strong> is overrided become {$qty_ovr}.";
}
} else {
//ELEMENT CHANGES
$e = new element($elid_ovr);
if (!is_null($e->id)) {
$el_ovr_found = true;
$ovr_def_data['elements_id'] = $elid_ovr;
$ovr_def_data['quantity'] = $qty_ovr;
$ovr_msg = "Element ID Default <strong>{$elid_def}</strong> is overrided become {$elid_ovr} with quantity {$qty_ovr}.";
} else {
$is_override = false;
}
}
}
if ($is_override) {
if ($ovr_type == 'or') {
$class_pa->overrideReset($paid, $pueid);
$changes = 'reset';
$elid = $elid_def;
$qty = $qty_def;
} else {
if ($ovr_type == 'rd') {
$ovr_def_data['elements_id'] = $ovr_def_data['elements_id'] == '0' ? $elid_def : $ovr_def_data['elements_id'];
if (!is_null($ovr_def_data)) {
tep_db_perform('products_use_elements', $ovr_def_data, 'update', "products_use_elements_id={$pueid}");
$dbc = tep_db_query("SELECT * FROM products_articles_use_elements WHERE products_use_elements_id = {$pueid}");
if (tep_db_num_rows($dbc) > 0 && $ovr_el_article == "true") {
while ($row = tep_db_fetch_array($dbc)) {
if ($row['quantity'] != $qty_def) {
$ovr_def_data['quantity'] = $row['quantity'];
} else {
$ovr_def_data['quantity'] = $ovr_def_data['quantity'];
}
$id = $row['id'];
tep_db_perform('products_articles_use_elements', $ovr_def_data, 'update', "id={$id}");
}
}
$this->setProductDescription2($pid, 'c,s,ch');
$e_def = new element($elid_def);
//removed replaced element default from product materials
$this->unsetProductMaterials($pid, $e_def->attributes['material']['id']);
$e_rd = new element($ovr_def_data['elements_id']);
//add to product materials for new element replacing the default ones
$this->setProductMaterials($pid, $e_rd->attributes['material']['id']);
$contain_stones = $e_def->attributes['category']['id'] == 5 || $e_rd->attributes['category']['id'] == 5 ? true : false;
if ($contain_stones) {
$this->setProductDescription2($pid, 'st');
}
//Manage this as a function, there some functions need to called this
$this->refreshProductDataSupport(array('pid' => $pid, 'contain_stones' => $contain_stones));
}
} else {
$elid = $ovr_data['elements_id'] == '0' ? $elid_def : $ovr_data['elements_id'];
$qty = $ovr_data['quantity'];
$id = $class_pa->overrideElement($paid, $pueid, $ovr_data);
// if(!is_null($id)&&$id>0) $messagebox->add($ovr_msg, 'green');
// else $messagebox->add("Failed overriding Article $pean !", 'red');
}
}
$e = new element($elid);
$result = array();
$result['rowid'] = $paid . $elid_def;
$result['paid'] = $paid;
$result['pueid'] = $pueid;
$result['imgdef'] = webImage($e->image, '80', '80');
$result['elid'] = $changes == 'elid' ? '<a href="?open=element&id=' . $elid . '&hidemenu=true" class="view_webpage">' . $elid . '</a>' : $elid;
$result['qty'] = $qty;
$result['changes'] = $changes;
$result['type'] = $ovr_type;
$result['ovr_el_article'] = $ovr_el_article;
ajaxReturn($result);
} else {
$result = array();
$e = new element($elid_old);
$result['imgdef'] = webImage($e->image, '80', '80');
$result['rowid'] = $paid . $elid_def;
$result['paid'] = $paid;
$result['pueid'] = $pueid;
$result['elid'] = $elid_old;
$result['qty'] = $qty_old;
$result['changes'] = '';
$result['type'] = $ovr_type;
if (!$el_ovr_found) {
$result['elidnotfound'] = $elid_ovr;
$result['msg'] = 'elementnotfound';
$result['changes'] = 'nochanges';
}
ajaxReturn($result);
}
}
<?php
/**
* Description of productdetaildescription2
*
* @author IT TEAM BONOFACTUM
* @created May 29, 2013 5:11:23 PM
*/
use_class('Product');
use_class('products_articles');
use_class('products_brand');
use_class('ProductMeasurement');
use_class('products_minierp');
use_class('elements_attributes');
$class_pa = new products_articles();
$class_pb = new products_brand();
$class_pmr = new ProductMeasurement();
$class_pm = new products_minierp();
$class_ea = new elements_attributes();
$products_id = tep_db_prepare_input($_GET['id']);
$product = new Product($products_id);
/* TODO: @deprecated Remove this because products description not use this.
$clasp_type = array();
$clasp_type[] = '';
$clasp_type[] = 'Agraffe';
$clasp_type[] = 'Bajonette Clasp';
$clasp_type[] = 'Clasp With Safety';
$clasp_type[] = 'Collier Clasp';
$clasp_type[] = 'Cross Clasp';
$clasp_type[] = 'Fold over clasp';
$clasp_type[] = 'Jewellery box clasp';
set_time_limit(0);
ini_set('memory_limit', '512M');
global $db;
require_once '../confy.php';
require_once '../functions.php';
require_once '../functions-2.php';
require_once DIR_WS_FUNCTIONS . 'html_output.php';
tep_db_connect();
use_class('jng_sp');
use_class('products_minierp');
use_class('products_articles');
use_class('stock_booking');
use_class('ReportCOGS');
$class_sp = new jng_sp();
$class_pm = new products_minierp();
$class_pa = new products_articles();
$amazon = $class_sp->retrieveDetail('5');
//ACTIVATE BELOW LINES FOR AMAZON, COMMENT TO GRAB ALL ARTICLES
//$category_ignore_articles = array('2', '3', '30');
$show_image = isset($_POST['show_image']) && $_POST['show_image'] == '1';
$this_year = date('Y');
$this_year_start = $this_year . '-01-01';
$this_year_end = $this_year . '-12-31';
$last_year_spid = '5';
$last_year_sp = $class_sp->retrieveDetail($last_year_spid);
$last_year = date('Y', strtotime('last year'));
$last_year_start = $last_year . '-01-01';
$last_year_end = $last_year . '-12-31';
$hn = array();
if ($show_image) {
$hn['image'] = 'Product Image';
<?php
global $db;
require_once '../confy.php';
require_once '../functions.php';
require_once '../functions-2.php';
tep_db_connect();
use_class('jng_sp_preorders');
use_class('products_minierp');
use_class('products_articles');
use_class('products_materials');
use_class('element');
use_class('elements_attributes');
use_class('Product');
$class_pm = new products_minierp();
$class_pa = new products_articles();
$class_pmat = new products_materials();
$class_ea = new elements_attributes();
function displayMeasurementRule($measurement, $use_decimal = true)
{
if ($measurement == 0) {
$result = '';
} else {
//change to german regional settings
$result = $use_decimal ? number_format($measurement, 2, ',', '') : intval($measurement);
}
return $result;
}
//RETRIEVE PRODUCT MATERIALS
$materials_name_raw = $class_pmat->retrieveList('', 'material_name');
$materials_name = array();
function getEANReturnResult($partner_type, $products_data, $sp_id = '0')
{
use_class('jng_sp');
use_class('orders');
use_class('jng_sp_orders');
use_class('Product');
use_class('products_ean');
use_class('products_minierp');
use_class('products_articles');
use_class('products_brand');
$class_sp = new jng_sp();
$class_orders = new orders();
$class_jo = new jng_sp_orders();
$class_pean = new products_ean();
$class_pm = new products_minierp();
$class_pa = new products_articles();
$class_pb = new products_brand();
$result = "no data";
$product_id = $products_data["products_id"];
$product_article_id = $products_data["products_articles_id"];
if ($product_article_id > 0) {
$articles_data = $class_pa->retrieveDetail($product_article_id);
}
$p_ean = $class_pean->getEAN($product_id, $product_article_id);
$p = $class_pm->retrieveDetail($product_id, 'p,pd,cat,pnc');
//GETTING BRAND NAME
$p_brand_id = $p['p']['products_brand_id'];
$brand_data = $class_pb->retrieveDetail($p_brand_id);
$brand_name = strtoupper(trim($brand_data['brand_name']));
$p_brand = $brand_name == '' ? 'JULIE & GRACE' : $brand_name;
$p_code = $p['p']['products_model'];
$p_category = mb_strtoupper($class_pm->retrieveCategoryName($p['categories_id'], 2));
//$p_shortname = "925 SILBER"; //it was $label_material
//$p_shortname = ($sp_id=='5') ? strtoupper($p['pd']['2']['products_short_name']) : "925 SILBER";
$sp_used_am_logistic = array_keys(getSalesPartnerUseAmazonLogistic());
if (in_array($sp_id, $sp_used_am_logistic)) {
$p_shortname = strtoupper($p['pd']['2']['products_short_name']);
} else {
$obj_product = new product($product_id);
$metal_stamp_code = $obj_product->metal_stamp_code;
$metal_stamp_info = $metal_stamp_code == 925 ? 'SILBER' : $obj_product->metal_stamp_info;
$metal_stamp_info = $this->convertToGermanHex($metal_stamp_info);
$p_shortname = strtoupper("{$metal_stamp_code} {$metal_stamp_info}");
}
$p_length = $product_article_id > 0 ? $articles_data['length'] : $p['pnc']['products_length'];
$p_length = $p_length > 0 ? strtoupper(str_replace(' ', '', textLength($p_length))) : '';
$p_targetaudience = strtoupper(LABEL_TARGET_AUDIENCE);
//FOR TEMPORARY WE USING ONLY DAMEN
if ($partner_type == 'sp') {
$order_qty = intval($products_data["order_quantity"]);
$p_price = $products_data['price'];
} elseif ($partner_type == 'jg') {
$order_qty = $products_data["products_quantity"];
$p_price = $products_data['final_price'];
} elseif ($partner_type == 'dp') {
$order_qty = $products_data["quantity"];
$p_price = '0';
} else {
$order_qty = '';
$p_price = '';
}
if ($p_ean != '') {
$return_label = $p_ean . ";" . $p_category . ";" . $p_shortname . ";" . $p_price . " EUR;{$order_qty};{$sp_id};{$p_code};{$p_brand};{$p_length};{$p_targetaudience};{$p_brand_id}";
$result = $return_label;
}
return $result;
}
<?php
global $db;
require_once '../confy.php';
require_once '../functions.php';
require_once '../functions-2.php';
tep_db_connect();
use_class('archive', DIR_WS_CLASSES);
use_class('jng_sp_preorders');
use_class('products_ean');
use_class('products_minierp');
use_class('products_articles');
$class_ean = new products_ean();
$class_pm = new products_minierp();
$class_pa = new products_articles();
$preorder_id = tep_db_prepare_input($_GET['id']);
$preorder = new jng_sp_preorders($preorder_id);
$ean_collection = array();
foreach ($preorder->items as $i) {
$ean_collection[] = $i['products_ean'];
}
$dest_path = 'BuyVIP-' . date('ymd') . '/';
if (!is_dir($dest_path)) {
mkdir($dest_path, 0750);
}
foreach ($ean_collection as $ean) {
$pdata = $class_ean->getProductArticle($ean);
$pid = $pdata['products_id'];
$p = $class_pm->retrieveDetail($pid, 'p,pci,pei,pnc,cat');
$product_images = array();
if ($p['p']['products_image'] != '' || $p['pci']['products_clear_image'] != '') {
require_once '../functions-2.php';
require_once '../functions-xml.php';
require_once DIR_WS_FUNCTIONS . 'html_output.php';
tep_db_connect();
use_class('logger');
$logger = new logger('cron', 'sp-2-catalog-uploader');
use_class('jng_sp_catalog');
use_class('jng_sp_upload');
use_class('products_minierp');
use_class('products_articles');
use_class('jng_sp');
$sp_specsets = load_config('sp-specific-settings');
$class_jc = new jng_sp_catalog();
$class_ju = new jng_sp_upload();
$class_pm = new products_minierp();
$class_pa = new products_articles();
$class_sp = new jng_sp();
$deleted_eans_reported = null;
$jng_sp_id = 2;
$sp_detail = $class_sp->retrieveDetail($jng_sp_id);
//echo something after every $echo_steps in the loop
$echo_steps = 100;
//RETRIEVE PRODUCT CATEGORIES
$product_categories_name = array();
$catq = tep_db_query("SELECT c.categories_id, cd.categories_name" . " FROM categories c" . " INNER JOIN categories_description cd" . " ON cd.categories_id=c.categories_id" . " AND cd.language_id={$sp_detail['languages_id']}" . " WHERE c.parent_id=0");
while ($row = tep_db_fetch_array($catq)) {
$product_categories_name[$row['categories_id']] = $row['categories_name'];
}
function translateOttoCategory($category_id)
{
//OTTO Warengruppe / ClassOfGoods
<?php
$product_input = tep_db_prepare_input($_POST['product_input']);
$counter_on = !isset($_POST['counter_on']) ? true : tep_db_prepare_input($_POST['counter_on']) == 'true';
use_class('products_minierp');
use_class('products_articles');
use_class('products_ean');
use_class('logger');
$class_ean = new products_ean();
$class_pm = new products_minierp();
$class_pa = new products_articles();
$logger = new logger('mc_functions', 'mod05_get_product_detail');
$logger->write("POST product_input = {$product_input}");
function cleanOiidFromPrefix($oiid)
{
/* Sometimes when user scan so fast, id scanned would be like this SP-12345SP-12345
* So this makes oiid taken is 12345SP, this function to clean it from unwanted prefix */
$oiid = strtoupper($oiid);
$oiid = str_replace('SP', '', $oiid);
$oiid = str_replace('JG', '', $oiid);
$oiid = str_replace('DP', '', $oiid);
return $oiid;
}
$barcode_id = '';
$spid = '';
$pid = 0;
$aid = '-';
$ean = '';
$qty = 1;
$cancel = false;
$result = array();
require_once DIR_WS_FUNCTIONS . 'html_output.php';
tep_db_connect();
$time = microtime();
$time = explode(' ', $time);
$time = $time[1] + $time[0];
$start = $time;
use_class('jng_sp_catalog');
use_class('jng_sp_upload');
use_class('products_minierp');
use_class('products_articles');
use_class('products_linking');
use_class('jng_sp');
$class_jc = new jng_sp_catalog();
$class_ju = new jng_sp_upload();
$class_pm = new products_minierp();
$class_pa = new products_articles();
$class_pl = new products_linking();
$class_sp = new jng_sp();
$jng_sp_id = '1';
$sp_detail = $class_sp->retrieveDetail($jng_sp_id);
$jng_sp_name = $sp_detail["name"];
$timestamp = date('d.m.Y H:i:s');
$datenow = date('ymd');
$HOURSTART = SP_NECKERMANN_CATUPLOAD_HOURSTART;
$HOUREND = SP_NECKERMANN_CATUPLOAD_HOUREND;
$hour_now = date('H');
//$hour_now = 04;
$max_pid_processed_per_run = 2000;
$total_pids_taken_per_run = 0;
$process_runned = 0;
$products_stock = array();
require_once '../functions-xml.php';
require_once DIR_WS_FUNCTIONS . 'html_output.php';
tep_db_connect();
use_class('logger');
$logger = new logger('cron', 'tradebyte-catalog-uploader');
use_class('xml_tools');
use_class('ProductAttribute');
use_class('Category');
use_class('products_minierp');
use_class('products_articles');
use_class('products_materials');
use_class('products_family');
use_class('jng_sp_catalog');
use_class('styles');
$class_pm = new products_minierp();
$class_pa = new products_articles();
$class_pmat = new products_materials();
$class_jc = new jng_sp_catalog();
$class_s = new styles();
$lid = '2';
$materials_name = array();
$materials_list = $class_pmat->retrieveList();
foreach ($materials_list as $mat) {
//take only materials in german language
$tmp_mat_name = explode(',', $mat['material_name']);
$mat_name = trim($tmp_mat_name[0]);
$materials_name[$mat['products_materials_id']] = $mat_name;
}
/**
* Function to send message to responsible PIC
* @global type $TB_CATUPLOAD_ADD_SUPERVISORS
<?php
//*SPECIAL NOTE: THIS MODULE IS CALLED FROM PRODUCTS ANALYSIS
use_class('jng_sp');
use_class('products_articles');
use_class('ReportCOGS');
$class_sp = new jng_sp();
$class_pa = new products_articles();
$total_periods = 10;
$class_col_product = 'w150 tac';
$class_col_periods = 'w150 tac';
if (isset($_POST['me_action'])) {
if ($_POST['me_action'] == 'LOADPRODUCT') {
use_class('products_minierp');
$class_pm = new products_minierp();
$pid = tep_db_prepare_input($_POST['pid']);
$rowclass = $_POST['rowclass'];
$product = $class_pm->retrieveDetail($pid, 'p');
$product_image = webImage($product['p']['products_image'], IMAGE_SIZE_THUMBNAIL_1, IMAGE_SIZE_THUMBNAIL_1, 'Product ' . $pid, '');
$ajaxResult = array();
$ajaxResult['pid'] = $pid;
$ajaxResult['image'] = $product_image;
$ajaxResult['info'] = $pid;
//$ajaxResult['info'] = $pid.' / '.$product['p']['products_model'];
echo ajaxReturn($ajaxResult);
exit;
} elseif ($_POST['me_action'] == 'LOADPERIOD') {
$spid = tep_db_prepare_input($_POST['spid']);
$products = tep_db_prepare_input($_POST['products']);
$period = tep_db_prepare_input($_POST['period']);
$period_start_raw = tep_db_prepare_input($_POST['period_start']);
<?php
global $db;
require_once '../confy.php';
require_once '../functions.php';
tep_db_connect();
use_class('jng_sp_catalog');
$class_jc = new jng_sp_catalog();
use_class('products_articles');
$class_pa = new products_articles();
use_class('products_ean');
$class_ean = new products_ean();
$jng_sp_id = '1';
$products = $class_jc->retrieveCatalogForUpload($jng_sp_id);
$counter_p = 0;
$counter_a = 0;
foreach ($products as $p) {
if ($p['products_ean'] == '') {
$class_ean->attachToProduct($p['products_id']);
$counter_p++;
}
$articles = $class_pa->retrieveList($p['products_id']);
foreach ($articles as $a) {
if ($a['length'] != $p['length']) {
if ($a['products_ean'] == '') {
$class_ean->attactToArticle($a['products_articles_id']);
$counter_a++;
}
}
}
echo '.';
<?php
use_class('ProductAttribute');
use_class('design_draft');
use_class('products_minierp');
use_class('products_articles');
use_class('products_brand');
use_class('element');
use_class('jng_sp');
use_class('jng_sp_catalog');
use_service('color_pattern');
use_class('production_instruction_manual');
use_class('styles');
use_class('design');
$class_pm = new products_minierp();
$class_pa = new products_articles();
$class_pb = new products_brand();
$class_sp = new jng_sp();
$class_jc = new jng_sp_catalog();
$class_cp = new color_pattern();
$class_s = new styles();
$class_d = new design();
$default_SP = array('1', '2', '3');
$target_group['1'] = $NAV_TARGET_GROUP_NMDE;
$target_group['2'] = $NAV_TARGET_GROUP_OTDE;
$colpaterns = $class_cp->retrieveListGrid(SERVICECLIENTCODE, null, LANGUAGEID);
$colpats = $colpaterns['Data'];
function getDetailData($products_id, $type)
{
global $class_pm, $class_pa, $class_pb, $class_sp, $target_group, $colpats, $class_s;
$result = array();
//global $db;
//require_once('../confy.php');
//require_once('../functions.php');
//require_once('../functions-2.php');
//require_once('../functions-xml.php');
//require_once(DIR_WS_FUNCTIONS.'html_output.php');
//tep_db_connect();
require_once DIR_WS_CLASSES . 'archive.php';
use_class('products_minierp');
use_class('products_materials');
use_class('products_family');
use_class('products_articles');
$class_pm = new products_minierp();
$class_pmat = new products_materials();
$class_pa = new products_articles();
function tep_create_csv_for_LAID($data, $separator = ',', $qualifier = '"')
{
$result = '';
if (is_array($data)) {
foreach ($data as $num => $row) {
foreach ($row as $key => $value) {
$row[$key] = $qualifier . $value . $qualifier;
}
$result .= implode($separator, $row);
$result .= "\n";
}
}
return $result;
}
function lazadaIDWriteToFile($filename, $content, $writemode)
define('FPDF_FONTPATH', FPDF_IMGPATH . 'fonts/');
require_once DIR_WS_CLASSES . 'fpdf.php';
//RETRIEVE PRODUCT CATEGORIES
$product_categories_name = array();
$catq = tep_db_query("SELECT c.categories_id, cd.categories_name FROM categories c INNER JOIN categories_description cd ON cd.categories_id=c.categories_id AND cd.language_id=1 WHERE c.parent_id=0");
while ($row = tep_db_fetch_array($catq)) {
$product_categories_name[$row['categories_id']] = $row['categories_name'];
}
use_class('jng_sp');
use_class('jng_sp_orders');
use_class('products_minierp');
use_class('products_articles');
$class_sp = new jng_sp();
$class_jo = new jng_sp_orders();
$class_pm = new products_minierp();
$class_pa = new products_articles();
if (isset($_GET['id'])) {
$order_id = tep_db_prepare_input($_GET['id']);
}
class PDF extends FPDF
{
var $ypos = 0;
var $margin = 10;
var $order_barcode = '';
function initPDF()
{
}
//Page header
function Header()
{
}
<?php
/**
* This module is used to display all current active booking
*
* @author IT TEAM BONOFACTUM
* @created Jun 18, 2013 3:45:28 PM
*/
use_class('stock_booking');
use_class('products_minierp');
use_class('products_articles');
$class_pm = new products_minierp();
$class_pa = new products_articles();
$articles_booked = stock_booking::getBookedQuantityAll(WAREHOUSE_ID_PRODUCTS_HAMBURG);
$articles_stock = $class_pm->stockRetrieveDetailAll(WAREHOUSE_ID_PRODUCTS_HAMBURG, 'booking_active>0');
$ttl_products = 0;
$ttl_articles = 0;
$ttl_qty_booked = 0;
$ttl_cache_error = 0;
$articles_result = array();
foreach ($articles_booked as $id => $book_qty) {
$id_temp = explode('-', $id);
$pid = $id_temp[0];
$aid = $id_temp[1];
if (!isset($articles_result[$pid])) {
$articles_result[$pid] = array();
$ttl_products++;
}
if (!isset($articles_result[$pid][$aid])) {
$articles_result[$pid][$aid] = array();
$ttl_articles++;
/**
* 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;
}
require_once '../confy.php';
require_once '../functions.php';
require_once '../functions-2.php';
require_once DIR_WS_FUNCTIONS . 'html_output.php';
tep_db_connect();
$eao = 2;
//element adjust order
use_class('design');
use_class('elements_preorder');
use_class('elements_order');
use_class('elements_stock');
use_class('products_articles');
use_class('products_minierp');
$class_es = new elements_stock();
$class_pm = new products_minierp();
$class_pa = new products_articles();
$ean_eu_collection = array();
$max_el_per_article = 0;
$use_elements = array();
$class_d = new design($_GET['d']);
$products = $class_d->retrieveProducts();
foreach ($products as $p) {
$query_products_categories = "SELECT * FROM products_to_categories ptc WHERE products_id={$p['products_id']}";
$tpdbq_products_categories = tep_db_query($query_products_categories);
$products_categories = tep_db_fetch_array($tpdbq_products_categories);
// find what use element in this product
$ean_eu_collection[$p['products_id'] . '-0'] = '';
$tpdbq_products_use_elements = $class_pm->retrieveElementsUsage($p[products_id]);
foreach ($tpdbq_products_use_elements as $row_pue) {
$use_elements[] = array('elements_id' => $row_pue['elements_id'], 'quantity' => (int) $row_pue['quantity'] * $eao);
$ean_eu_collection[$p['products_id'] . '-0'] .= $row_pue['elements_id'] . ' x ' . $row_pue['quantity'] . '|';
<?php
use_class('Order');
use_class('orders');
use_class('jng_sp_orders');
use_class('depot_orders');
use_class('products_minierp');
use_class('products_articles');
use_class('products_ean');
$class_o = new orders();
$class_do = new depot_orders();
$class_jo = new jng_sp_orders();
$class_pm = new products_minierp();
$class_pa = new products_articles();
$class_ean = new products_ean();
$source = strtoupper(tep_db_prepare_input($_GET['source']));
$order_id = tep_db_prepare_input($_GET['id']);
if (!isset($_GET['id']) && isset($_GET['item_id']) && $_GET['item_id'] != '') {
$item_id = tep_db_prepare_input($_GET['item_id']);
if ($source == Order::ORDER_TYPE_JULIE_GRACE) {
$item = $class_o->retrieveProductDetail($item_id);
$order_id = $item['orders_id'];
} elseif ($source == Order::ORDER_TYPE_SALES_PARTNER) {
$item = $class_jo->retrieveItemDetail($item_id);
$order_id = $item['jng_sp_orders_id'];
}
}
if ($order_id == '' || $order_id == 'undefined') {
$content .= '<h2 class="red">Manobo can not find related order for this customer</h2>';
$title .= 'No Order';
} else {
/**
* This module will replace 2 previous modules:
* - products-stock-update.php
* - bin-info.php
*
* @author IT TEAM BONOFACTUM
* @created Apr 12, 2013 6:20:18 PM
*/
use_class('products_minierp');
use_class('products_articles');
use_class('products_ean');
use_class("bins");
use_class("stock_booking");
$class_bin = new bins();
$class_pm = new products_minierp();
$class_pa = new products_articles();
$class_ean = new products_ean();
//GET PAGE & WAREHOUSE OPTIONS
warehouseFGCombo();
$psid = null;
$bin_id = null;
$pid = null;
$aid = null;
$history_options = array();
$history_options[0] = '2 Weeks';
$history_options[1] = '4 Weeks';
$history_options[2] = '1 Month';
$history_options[3] = '2 Months';
$history_options[4] = '3 Months';
$history_options[5] = '6 Months';
$history_options[6] = '1 Year';
<?php
use_class('depot_orders');
$class_do = new depot_orders();
use_class('products_minierp');
$class_pm = new products_minierp();
use_class('products_articles');
$class_pa = new products_articles();
$whid_material = '1';
//1 is default warehuse for elements
$whid_fg_hh = '5';
//5 is default warehouse for depot in HH
$order_id = tep_db_prepare_input($_GET['id']);
if (isset($_POST['me_action'])) {
if ($_POST['me_action'] == 'SETSTATUS') {
$newstatus = tep_db_prepare_input($_POST['newstatus']);
$class_do->updateStatus($order_id, $newstatus, $session_userinfo['username']);
if ($newstatus == '1') {
$class_do->updateStockStatus($order_id, '0');
}
$newstatus_msg['1'] = 'Order is set back as <strong>' . statusName('1') . '<strong>!';
$newstatus_msg['8'] = 'Order is set as <strong>' . statusName('8') . '<strong>!';
$newstatus_msg['10'] = 'Order is <strong>Canceled<strong>!';
$messagebox->add($newstatus_msg[$newstatus], 'green');
if ($newstatus == '1' || $newstatus == '10') {
$subject = 'MISSING PRODUCT!';
$message = 'A Product from Depot Order has been reported missing (sent to HH but never receive): ';
$message .= '<a href="http://manobo.de/?open=depot-order&id=' . $order_id . '">DP-' . $order_id . '</a>';
} elseif ($newstatus == '8') {
$subject = 'MANUAL SET STATUS!';
$message = 'A Product from Depot Order has been set manually as received in HH by ' . $session_userinfo['username'] . ': ';
