$q .= " LEFT JOIN elements_description ed1 ON ed1.elements_id=e.elements_id AND ed1.languages_id=1";
$q .= " LEFT JOIN elements_description ed2 ON ed2.elements_id=e.elements_id AND ed2.languages_id=2";
$q .= " LEFT JOIN elements_images ei ON ei.elements_id=e.elements_id AND ei.elements_sample_name='EC1'";
$q .= " WHERE e.elements_id IN (" . implode(',', $elements_keep_id) . ")";
$r = tep_db_query($q);
$elements = array();
while ($row = tep_db_fetch_array($r)) {
$elements[] = $row;
}
$count = 0;
$copy_time = date('Y-m-d H:i:s');
foreach ($elements as $e) {
$element = new element($e['elements_id']);
if (is_null($element->id)) {
$element->forceID($e['elements_id']);
$element->create($e['elements_code'], $e['name'], $e['elements_weight'], '', 0, $copy_time, 'auto');
if ($e['elements_image'] != '') {
$image_uploaded = DIR_WS_IMAGES . $e['elements_image'];
$image_filename = basename($image_uploaded);
$element->uploadImage($image_uploaded, $image_filename);
}
$suppliers = $element->getSuppliers();
$sup_name = '';
$sup_name = 0;
foreach ($suppliers as $sup) {
if ($sup['is_default'] == '1') {
$sup_name = $sup['suppliers_name'];
$sup_price = calculateCurrency($sup['elements_price'] / $sup['pieces_per_qty_type'], $sup['price_currency']);
break 1;
}
}
function createElement($e_code, $e_name, $e_weight, $e_supplier, $e_price, $e_add_date, $e_add_by, $status = '1', $e_weight_goldpure = '0', $e_desc = '')
{
global $session_user_info;
use_class('element');
$element = new element(null);
$element->create($e_code, $e_name, $e_weight, $e_supplier, $e_price, $e_add_date, $e_add_by, $e_weight_goldpure, $e_desc);
$sda = array();
$sda['elements_id'] = $element->id;
$sda['drafts_id'] = $this->id;
$sda['designs_id'] = $this->designs_id;
$sda['created_date'] = $e_add_date;
$sda['created_by'] = $e_add_by;
$sda['status'] = $status;
if ($status == '0') {
$sda['need_sourcing'] = 1;
}
tep_db_perform('designs_elements', $sda);
return $element;
}