tep_db_query("UPDATE products_configurator SET visible_status='N', allow_modification='0' WHERE products_id={$pid}");
$messagebox->add("This Product is set to not shareable.", 'green');
} elseif ($_POST['me_action'] == 'SETFINISH') {
tep_db_query("UPDATE products_configurator SET is_finish='1' WHERE products_id={$pid}");
$product = $class_pm->retrieveDetail($pid, 'p');
if ($product['p']['products_model'] == '') {
$promod = $class_pm->generateNewCode($product['categories_id']);
tep_db_query("UPDATE products SET products_model='{$promod}' WHERE products_id={$pid}");
}
$messagebox->add("This Product is now set as a finish product.", 'green');
} elseif ($_POST['me_action'] == 'UPDATESPCATALOG') {
//Add product to SP catalog, removing is not possible from this page
if (isset($_POST['sp_catalog']) && is_array($_POST['sp_catalog']) && count($_POST['sp_catalog']) > 0) {
foreach ($_POST['sp_catalog'] as $sp_id) {
$jng_sp_id = tep_db_prepare_input($sp_id);
sp_addProductToCatalog($jng_sp_id, $pid);
}
}
$messagebox->add("Product is added to the selected catalog.", 'green');
} elseif ($_POST['me_action'] == 'MANUALPI') {
$manual_pi = tep_db_prepare_input($_POST['mpi']);
$sda = array('products_instruction' => $manual_pi);
$exist_query = tep_db_query("SELECT pnc.products_id FROM products_non_configurator pnc WHERE pnc.products_id={$pid}");
if (tep_db_num_rows($exist_query) > 0) {
tep_db_perform('products_non_configurator', $sda, 'update', "products_id={$pid}");
} else {
$sda['products_id'] = $pid;
tep_db_perform('products_non_configurator', $sda);
}
$messagebox->add("Manual Production Instruction is udpated.", 'green');
} elseif ($_POST['me_action'] == 'LOADOPTIONSPI') {
function addProduct($jng_sp_id, $product_id)
{
$new_id = sp_addProductToCatalog($jng_sp_id, $product_id);
/*
$product_query = "SELECT p.products_id, p.products_status, p.products_image, p.products_model, products_price";
$product_query .= ", pc.customers_id, pc.is_finish, pc.visible_status";
$product_query .= ", IF(pc.products_length IS NULL, pnc.products_length, pc.products_length) AS products_length";
$product_query .= ", pd.products_name, pd.products_description, pd.products_head_keywords_tag";
$product_query .= " FROM products p";
$product_query .= " LEFT JOIN products_configurator pc ON pc.products_id=p.products_id";
$product_query .= " LEFT JOIN products_non_configurator pnc ON pnc.products_id=p.products_id";
$product_query .= " LEFT JOIN products_description pd ON pd.products_id=p.products_id AND pd.language_id=2";
$product_query .= " LEFT JOIN jng_sp_catalog jc ON jc.jng_sp_id=$jng_sp_id AND jc.products_id=p.products_id";
//$product_query .= " WHERE p.products_id IN ($product_id) AND p.products_status=1 AND p.products_image!=''";
$product_query .= " WHERE p.products_id IN ($product_id)";
$product_query .= " AND jc.products_id IS NULL";
$product_result = tep_db_query($product_query);
$new_id = array();
while($product=tep_db_fetch_array($product_result)) {
$article_number = str_replace('-', '_', $product['products_model']);
if($product['customers_id']!='') {
$product_name = $this->generateProductName('2', $product['products_id']);
$el_query_table = 'products_has_elements';
} else {
$product_name = $product['products_name'];
$el_query_table = 'products_use_elements';
}
$elmax_rd_query = "SELECT pe.products_id, MAX(es.resourcing_day) AS max_res_day";
$elmax_rd_query .= " FROM $el_query_table pe";
$elmax_rd_query .= " LEFT JOIN elements_stock es ON es.elements_id=pe.elements_id";
$elmax_rd_query .= " WHERE pe.products_id=$product[products_id]";
$elmax_rd_query .= " GROUP BY pe.products_id";
$elmax_rd_result = tep_db_query($elmax_rd_query);
$elmax_rd = tep_db_fetch_array($elmax_rd_result);
$product_desc = $product['products_description'];
$keywords = explode('|||', $product['products_head_keywords_tag']);
foreach($keywords as $key=>$kw) {
$keywords[$key] = str_replace(',',', ',$kw);
}
if($product['is_finish']!='') {
$kw_length = $keywords[2];
$kw_color = $keywords[0];
$kw_material = $keywords[1];
} else {
$kw_length = $keywords[1];
$kw_color = '';
$kw_material = $keywords[0];
}
//$product_keywords = implode(', ', $keywords);
$product_keywords = '';
$product_price = $product['products_price'];
if(substr($product['products_model'],0,2)=='ER') $product_price = 2 * $product_price;
$product_price_old = '';
$product_price_new = '';
//$product_length = $kw_length;
$product_length = $product['products_length'];
$product_color = $kw_color;
$product_material = $kw_material;
$date_added = date('Y-m-d H:i:s');
$sda = array('jng_sp_id'=>$jng_sp_id,
'products_id'=>$product['products_id'],
'article_number'=>$article_number,
'price'=>$product_price,
'price_old'=>$product_price_old,
'price_new'=>$product_price_new,
'name'=>$product_name,
'description'=>$product_desc,
'keywords'=>$product_keywords,
'length'=>$product_length,
'color'=>$product_color,
'material'=>$product_material,
'use_logo'=>'1',
'status_image'=>'0',
'date_added'=>$date_added,
'replacement_days'=>$elmax_rd['max_res_day']
);
tep_db_perform('jng_sp_catalog', $sda);
$new_id[] = tep_db_insert_id();
//AUTO ADD PRODUCT STOCK DATA
$default_warehouse = '1';
$check_stock_query = tep_db_query("SELECT jng_sp_catalog_id FROM jng_sp_stocks WHERE jng_warehouses_id=$default_warehouse AND jng_sp_catalog_id=$new_id");
if(tep_db_num_rows($check_stock_query)==0) {
$default_stock_min = '5';
$default_stock_max = '5';
$sda=array( 'jng_warehouses_id'=>$default_warehouse,
'jng_sp_catalog_id'=>$new_id,
'stock_min'=>$default_stock_min,
'stock_max'=>$default_stock_max,
'stock'=>'0'
);
tep_db_perform('jng_sp_stocks', $sda);
}
}
*/
return $new_id;
}
