$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; }