$result = array();
$result['eladded'] = $el_added;
ajaxReturn($result);
exit;
} elseif ($_POST['me_action'] == 'ELEMENTSUSEDADDDIRECT') {
$pid = tep_db_prepare_input($_POST['pid']);
$elid = tep_db_prepare_input($_POST['elid']);
$elqty = tep_db_prepare_input($_POST['elqty']);
$el_added = $class_pm->addElementToProducts($pid, $elid, $elqty);
$result = array();
$result['eladded'] = $el_added;
ajaxReturn($result);
exit;
} elseif ($_POST['me_action'] == 'SEARCHUSEDELEMENTS') {
$products_id_copy = tep_db_prepare_input($_POST['pid_c']);
$el_used = $class_pm->retrieveElementsUsage($products_id_copy);
$loe = '';
if (count($el_used) > 0) {
$htable = array();
$ht = array();
$ht['sp'] = 'Image';
$ht['q'] = 'ID';
$ht['r'] = 'Name';
$ht['s'] = 'Qty';
$htable[] = $ht;
$el_used_lists = array();
foreach ($el_used as $el_id => $data) {
$e = new element($el_id);
$el_image = '';
if ($e->id != null) {
$el_used_lists[] = $el_id;
function cancelOrderStockHandler($type, $oiid, $stock_status, $status, $print_count, $print_confirmed, $products_id, $articles_id, $quantity, $is_promotion_order = false)
{
global $STOCKLESS_ELEMENTS_CATEGORY;
use_class('products_minierp');
use_class('elements_stock');
use_class('element');
$class_pm = new products_minierp();
$class_es = new elements_stock();
$timestamp = date('Y-m-d H:i:s');
if (in_array($status, array('1', '2', '3')) && $print_confirmed == 0 || $status == '8' && $print_count == 0) {
switch ($stock_status) {
case 'D':
//DEPOT STOCK
$class_pm->stockAdd(WAREHOUSE_ID_FOR_HANDLING_ORDERS, $products_id, $articles_id, $quantity, 'ADD CANCEL ' . $type . '-' . $oiid);
break;
case 'P':
//FG STOCK
$class_pm->stockAdd(WAREHOUSE_ID_PRODUCTS_BALI, $products_id, $articles_id, $quantity, 'ADD CANCEL ' . $type . '-' . $oiid);
break;
case 'R':
//ELEMENTS STOCK
$elements_used = array();
$el_usage = $class_pm->retrieveElementsUsage($products_id, $articles_id);
foreach ($el_usage as $e) {
$elements_used[$e['elements_id']] = $e['quantity'];
}
foreach ($elements_used as $eid => $el_qty) {
$el = new element($eid);
$el_cat_id = !is_null($el->attributes['category']['id']) ? $el->attributes['category']['id'] : '';
if (!in_array($el_cat_id, $STOCKLESS_ELEMENTS_CATEGORY)) {
$stock_qty = $quantity * $el_qty;
$current_stock = $class_es->addStockByPieces(WAREHOUSE_ID_ELEMENTS, $eid, $stock_qty, 'ADD CANCEL ' . $type . '-' . $oiid, $is_promotion_order);
}
}
break;
}
}
}
$q .= " WHERE do.leadtime_start_date IS NOT NULL AND do.trans_type != 'SP' AND do.trans_type != 'JG' ";
$q .= " AND do.leadtime_start_date < '{$day_filter}' AND do.status = 2";
$q .= ") a";
$q .= " ORDER BY a.leadtime_start_date DESC";
$result = tep_db_query($q);
$el_id = array();
$el = array();
$element_name_max_chars = 30;
while ($row = tep_db_fetch_array($result)) {
$products_id = $row['products_id'];
$articles_id = $row['articles_id'];
$status = $row['stock_status'];
$qty = $row['quantity'];
if ($products_id != '') {
$product = $class_pm->retrieveDetail($products_id);
$elements = $class_pm->retrieveElementsUsage($products_id, $articles_id);
}
if (is_array($elements) && count($elements) > 0) {
$elements_stock = $class_es->retrieveAll($whid);
foreach ($elements as $eid => $usage) {
$e = new element($eid);
$stock = $elements_stock[$eid];
$elusage = $qty * $usage['quantity'];
if (isset($status) && $status == 'S') {
if ($stock < $elusage && !in_array($e->attributes['category']['id'], $STOCKLESS_ELEMENTS_CATEGORY)) {
$el['id1'] = $eid;
$el['tar q'] = $elusage;
$el_id[] = $el;
break;
}
}
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'] . '|';
}
$mepa = count($tpdbq_products_use_elements);
if ($mepa > $max_el_per_article) {
$max_el_per_article = $mepa;
}
$tpdbq_products_articles = $class_pa->retrieveList($p[products_id], "active_status='1'");
foreach ($tpdbq_products_articles as $row_pa) {
$ean_eu_collection[$p['products_id'] . '-' . $row_pa['products_articles_id']] = '';
$tpdbq_products_articles_use_elements = $class_pm->retrieveElementsUsage($p[products_id], $row_pa['products_articles_id']);
foreach ($tpdbq_products_articles_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'] . '-' . $row_pa['products_articles_id']] .= $row_pue['elements_id'] . ' x ' . $row_pue['quantity'] . '|';
$extra_images = array();
$add_have_set_to_default = false;
$alternate_main_image_key = null;
$x = 0;
while ($row = tep_db_fetch_array($extra_images_query)) {
$extra_images[$x] = $row;
if ($row['alternate_main_image'] == 1) {
$add_have_set_to_default = true;
$alternate_main_image_key = $x;
}
$x++;
}
$depot_stock = $class_pm->stockRetrieve(WAREHOUSE_ID_FOR_HANDLING_ORDERS, $products_id, '*');
$depot_refill = $class_do->refillOpenOrdersQuantity(SEGMENT_ID_DEFAULT, $products_id, '*');
$elements_status_raw = true;
$elements_usage = $class_pm->retrieveElementsUsage($products_id);
if (count($elements_usage) > 0) {
$elements_stock = $class_es->retrieveList(WAREHOUSE_ID_ELEMENTS, 'elements_id IN (' . implode(',', array_keys($elements_usage)) . ')');
foreach ($elements_usage as $eid => $eu) {
if ($eu['quantity'] > $elements_stock[$eid]) {
$elements_status_raw = false;
break;
}
}
} else {
$elements_status_raw = '<span class="green" title="No Element used Found for this product">NEF</span>';
}
$elements_status = is_bool($elements_status_raw) ? '<span class="' . ($elements_status_raw ? 'green">OK</span>' : 'red">NS') . '</span>' : $elements_status_raw;
$products_agegroup_options = $class_pm->productAgeGroupName();
$products_brand = $products['products_brand_id'] > 0 ? $class_pb->retrieveDetail($products['products_brand_id']) : '';
$date_added = date('Y-m-d', strtotime($products['products_date_added']));
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;
}
private function getElementsNeeded($colname)
{
use_class('products_minierp');
$class_pm = new products_minierp();
$elements_needed = array();
foreach ($this->items as $i) {
$eus = $class_pm->retrieveElementsUsage($i['products_id'], $i['articles_id']);
foreach ($eus as $eu) {
if (!isset($elements_needed[$eu['elements_id']])) {
$elements_needed[$eu['elements_id']] = 0;
}
$elements_needed[$eu['elements_id']] += $i[$colname] * $eu['quantity'];
}
}
return $elements_needed;
}
$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];
}
$elements_datas[] = $element['elements_id'] . "-" . $element['quantity'] . "-" . $el_stock;
}
$result['products_id'] = $product_data['p']['products_id'];
$result['products_length'] = $product_info['length'] > 0 ? textLength($product_info['length']) : textLength("-");
$result['products_ean'] = $ean;
/**
* 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;
}
function countElementsUsage($products_id, $articles_id = null)
{
$euid = $products_id . (is_null($articles_id) ? '' : '-' . $articles_id);
if (isset($this->elements_usage[$euid]) && is_array($this->elements_usage[$euid])) {
$eu = $this->elements_usage[$euid];
} else {
$eu = array();
if (!is_null($products_id) && $products_id != '') {
//lets use function from class products_minierp
use_class('products_minierp');
$class_pm = new products_minierp();
$el_usage = $class_pm->retrieveElementsUsage($products_id, $articles_id);
foreach ($el_usage as $e) {
$eu[$e['elements_id']] = $e['quantity'];
}
}
$this->elements_usage[$euid] = $eu;
}
return $eu;
}
use_class('element');
$class_pm = new products_minierp();
$pids = array(15058, 15255, 15257, 15269, 15271, 15275, 15411, 15996, 16101, 16103, 16284, 16574, 16575, 16576, 16577, 16578, 16579, 16580, 16581, 16583, 16584, 16585, 16586, 16587, 16589, 16591, 16592, 16593, 16600, 16606, 17541, 17835, 18028, 18029, 18030, 21114, 22498, 23189, 24293, 24925, 24934, 25018, 25043, 25204, 25459, 25461, 25899, 26384, 26546, 26582, 26669, 27017, 27025, 27271, 27277, 27634, 28731, 29819, 30328, 30627, 31280, 31289, 31299, 31308, 31316, 31416, 31429, 31440, 31545, 31857, 31865, 31880, 32064, 32360, 33045, 33053, 33063, 33074, 33296, 33884, 34352, 34357, 35605, 38834, 38130, 43468, 43470, 43476, 43491, 43495, 43580, 43783, 43795, 43875, 44119, 44120, 43128, 44596, 45182, 45163, 44886, 45745, 43702, 43705, 46488, 46493, 46494, 46495, 46751, 47223, 47469, 47477, 47478, 47480, 47481, 47484, 47488, 47490, 47489, 47491, 47556, 47558, 47560, 47564, 47563, 47567, 47568, 47569, 47570, 47571, 47714, 47716, 47718, 47720, 47972, 48127, 48792, 48941, 48944, 49230, 32336, 50293, 50300, 50308, 50309, 50313, 50314, 50323, 50324, 50327, 50328, 50329, 50346, 50449, 50450, 50455, 50558, 50559, 50562, 50565, 50650, 50913, 51016, 51093, 51218, 51216, 51396, 51430, 51553, 51557, 51559, 51560, 51572, 51585, 51590, 51640, 51645, 51821, 51825, 51847, 53322, 53330, 53459, 53472, 53610, 53763, 53846, 53847, 53963, 53962, 53961, 53960, 53958, 53957, 54119, 54126, 54197, 54210, 54301, 54307, 54314, 54317, 54321, 54365, 54369, 54370, 54371, 54413, 54414, 54420, 54534, 54696, 54706, 54799, 54847, 54869, 54919, 54920, 54921, 54985, 54978, 55005, 55019, 55027, 55035, 55249, 55248, 55247, 55261, 55262, 55286, 55294, 55295, 55298, 55426, 55428, 55429, 55430, 55489, 55493, 55515, 55539, 55567, 55571, 55582, 55635, 55720, 55752, 55762, 55813, 55871, 55978, 56013, 56014, 56066, 56077, 56078, 56079, 56080, 56156, 33227, 56287, 56308, 56315, 56329, 56502, 56522, 56592, 56643, 56837, 57337, 57840, 57847, 57854, 58498, 58587, 58589, 58590, 58591, 58588, 58593, 58595, 58596, 58597, 58599, 58502, 58973, 58721, 58722, 58724, 58994, 59000, 59075, 58916, 58915, 59153, 58926, 58928, 58929, 58930, 58938, 59236, 59235, 59238, 59347, 59351, 59352, 59353, 59451, 59396, 59397, 59194, 59579, 59560, 59562, 59565, 59566, 59359, 59626, 59512, 59699, 59671, 59517, 59720, 59718, 59448, 59574, 59817, 59819, 59835, 59805, 60299, 60179, 60451, 60575, 60350, 60351, 60356, 60357, 60601, 60602, 60562, 60563, 60564, 60624, 60608, 60633, 60634, 60635, 60636, 60655, 60656, 60657, 60658, 60659, 60672, 60674, 60528, 60529, 60530, 60531, 60629, 60763, 60764, 60765, 60766, 60768, 60670, 60594, 60595, 60782, 60771, 60772, 60773, 60774, 60775, 60776, 60777, 60850, 60884, 60887, 60949, 60950, 60960, 60961, 60955, 60957, 60668, 60975, 60976, 60983, 60934, 61004, 61005, 61006, 60886, 61030, 61031, 61032, 61033, 61137, 61138, 61139, 61148, 61167, 61196, 61264, 61288, 61289, 61290, 61472, 61474, 61475, 61476, 61478, 61636, 61637, 61639, 61664, 61665, 61666, 61667, 61669, 61792, 61874, 61876, 61814, 61815, 61965, 61890, 61891, 61988, 61910, 61915, 61971, 62029, 62019, 62050, 62041, 62042, 62043, 62044, 61899, 62061, 62053, 62063, 62023, 62081, 62057, 62126, 62122, 62124, 62131, 62140, 62148, 62119, 62176, 62186, 62187, 62188, 62189, 62174, 62221, 62254, 62224, 62261, 62274, 62275, 62276, 62277, 62287, 62271, 62272, 62305, 62259, 62299, 62263, 62300, 62301, 62293, 62304, 62292, 62267, 62357, 62358, 62359, 62388, 62382, 62383, 62416);
$h = "<table border=\"1\" cellpadding=\"0\" cellspacing=\"0\"><tr>\n <td><div><b>Image</b></div></td>\n <td><div><b>Products<br/>ID</b></div></td>\n <td><div><b>Products<br/>Code</b></div></td>\n <td><div><b>Length</b></div></td>\n <td><div><b>EAN</b></div></td>\n <td><div><b>Elements<br/>Image</b></div></td>\n <td><div><b>Elements<br/>ID</b></div></td>\n <td><div><b>Elements<br/>Qty</b></div></td>\n </tr>";
echo $h;
foreach ($pids as $pid) {
$q = "SELECT jc.*,p.products_ean FROM jng_sp_catalog jc";
$q .= " INNER JOIN products p ON p.products_id = jc.products_id";
$q .= " WHERE jc.jng_sp_id = 5 AND jc.products_id = {$pid}";
$h = '';
$dbq = tep_db_query($q);
$r = tep_db_fetch_array($dbq);
$article_number = $r['article_number'];
$p = $class_pm->retrieveDetail($pid, 'p');
$p = $p['p'];
$pue = $class_pm->retrieveElementsUsage($pid);
$heu = '';
$heu1 = '';
$counter = 0;
foreach ($pue as $elid => $dt) {
$class_e = new element($elid);
$eimg = webImage($class_e->image, '80', '80');
if (count($pue) == 1) {
$heu = "<td><div>{$eimg}</div></td><td><div>{$elid}</div></td><td><div>{$dt['quantity']}</div></td>";
} else {
$counter++;
if ($heu == '') {
$heu = "<td><div>{$eimg}</div></td><td><div>{$elid}</div></td><td><div>{$dt['quantity']}</div></td>";
} else {
$heu1 .= "<tr><td><div>{$eimg}</div></td><td><div>{$elid}</div></td><td><div>{$dt['quantity']}</div></td></tr>";
}
$colors = $class_pm->loadColorPatternNames($pid, '2');
$colors_main = '';
if (is_array($colors)) {
foreach ($colors as $c) {
$colors_main = $c;
break;
}
} else {
$colors = array();
}
$materials_ids = $class_pm->loadProductMaterials($pid);
$materials = array();
foreach ($materials_ids as $mid) {
$materials[] = $materials_name[$mid];
}
$pues = $class_pm->retrieveElementsUsage($pid, 0);
$materials_stone = '';
$materials_stone_size = '';
$stones_mats = array();
$stones_sizes = array();
foreach ($pues as $pue) {
$e = new element($pue['elements_id']);
if ($e->attributes['category']['id'] == '5') {
$matname = explode(', ', $e->attributes['material']['name']);
$stones_mats[$matname[0]] += $pue['quantity'];
$stones_sizes[$e->attributes['size']['name']] += $pue['quantity'];
}
}
if (count($stones_mats) > 0) {
$stones_bq = max($stones_mats);
$materials_stone = array_search($stones_bq, $stones_mats);
$htp['date_add'] = date('d.m.y H:i:s', $tsproductionstatus);
$htp['status'] = 'Production: ' . statusNameProduction($hp['status']);
$htp['login'] = $hp['update_by'];
$htable[] = $htp;
unset($history_prod[$hpk]);
}
}
}
}
if ($do['status'] == '2') {
use_class('element');
use_class('elements_stock');
$class_es = new elements_stock();
$estock = $class_es->retrieveAll($whid_material);
$sourcing_table = array();
$eused = $class_pm->retrieveElementsUsage($do['products_id'], $do['articles_id']);
$sourcing_info = '<div style="margin-top:20px;">';
$sourcing_info .= '<h3>Sourcing Information</h3>';
if (count($eused) > 0) {
$sourcing_table = array();
$st = array();
$st['d'] = 'Image';
$st['id1'] = 'Element ID';
$st['a'] = 'Qty Required';
$st['o'] = 'Stock Available';
$sourcing_table[] = $st;
foreach ($eused as $eid => $eu) {
$colclass = '';
if ($eu['quantity'] > $estock[$eid]) {
$colclass = ' bold red';
}
