Автоматический ввод артикула при добавлении товара - страница 2 - [VM2&3] Управление товарами, атрибутами, типами, ценами

<?php
	echo '<input type="text" class="inputbox" name="product_sku" id="product_sku" value="';
		if ($this->product->product_sku) {
			$val_sku = $this->product->product_sku; //Esli artikul ustanovlen, vyvodim ego
		}else{
			//Poluchaem segodniashniuiu datu
				$now_date = date_create('now');

			$db_sku = JFactory::getDBO();

			//Zapros krainego ID tovara
				$q_sku = 'SELECT `virtuemart_product_id` FROM #__virtuemart_products ORDER BY `virtuemart_product_id` DESC LIMIT 1';

			//Poluchaem posledniy ispol`zovanniy ID tovara, dlya formirovaniya artikula
				$db_sku->setQuery($q_sku);
				$data = $db_sku->loadAssoc();

			//Pribavlyaem k poluchennomu ID edinitcu, dlya polucheniia nyneshnego ID tovara
				$data = intval($data['virtuemart_product_id'])+1;

			//Formatim datu (privodim ee k formatu: den, mesyac, god. Naprimer: 271013).
				$a =  date_format($now_date, 'dmy');
			//Esli hotite, chtoby data, byla v formate: 27.10.13, to, 'dmy', razdelyaete tochkami
			
			//Pribavlyaem k poluchennoi date ID tovara
				$val_sku .= $a.'-'.$data; //togda, artikul, budet imet vid: 271013-9.
			/* Esli nuzhno, chtoby pered "9", byl kakoi-libo simvol, to, etu stroku, formatiruem tak:
				$val_sku .= $a.'-'.'kakoi-libo simvol. Naprimer nol'.$data;
			togda, artikul, budet imet vid: 271013-09. */
    }
    echo $val_sku.'" size="32" maxlength="64" />'; //Vyvodim znachenie v formu
?>

<?php
	echo '<input type="text" class="inputbox" name="product_sku" id="product_sku" value="';
		if ($this->product->product_sku) {
			// Esli artikul ustanovlen, vyvodim ego
				$val_sku = $this->product->product_sku;
		} else {
			$db_sku = JFactory::getDBO();

			// Zapros kraynego ID tovara
				$q_sku = 'SELECT `virtuemart_product_id` FROM #__virtuemart_products ORDER BY `virtuemart_product_id` DESC LIMIT 1';

			// Poluchaem posledniy ispolzovanniy ID tovara, dlya formirovaniya artikula
				$db_sku->setQuery($q_sku);
				$data = $db_sku->loadAssoc();

			// Pribavliaem k poluchennomu ID edinitcu, dlya polucheniya nyneshnego ID tovara
				$data = intval($data['virtuemart_product_id'])+1;

			// Poluchaem dlinu znacheniya ID tovara
				$a = strlen($data);

			// Ustanavlivaem kolichestvo cifr v formiruemom artikule
				if ($data <= 9999) {
					$a = 5 - $a; // 5 cifr
				} elseif ($data <= 99999) {
					$a = 6 - $a; // 6 cifr
				} elseif ($data <= 999999) {
					$a = 7 - $a; // 7 cifr
				} elseif ($data <= 9999999) {
					$a = 8 - $a; // 8 cifr
				} elseif ($data <= 99999999) {
					$a = 9 - $a; // 9 cifr
				} elseif ($data <= 999999999) {
					$a = 10 - $a; // 10 cifr
				}

			// Prefiks artikula
				$val_sku= "KF-";

			if ($data <= 999999999) {
				// Esli ID tovara, menshe ili raven 999999999, to ciklom zapolniaem artikul nedostayushchimi nulyami pered ID tovara
					for($i=1; $i<=$a; $i++){
						$val_sku .= "0";
					}
			} else {
				// Pribavlyaem k poluchennomu ID tovara
					$val_sku .= $data;
			}
		}

		// Esli ID tovara, menshe ili raven 999999999, to v forme, otobrazhaem nol(nuli), pered ID tovara
			if ($data <= 999999999) {
				echo $val_sku.$data.'" size="32" maxlength="64" />';
			} else {	 
				// Esli ID tovara, bolshe 999999999, to v forme, otobrazhaem chistiy ID tovara
					echo $val_sku.'" size="32" maxlength="64" />';
			}
?>

$data = $db_sku->setQuery('SELECT MAX(`virtuemart_product_id`)+1 FROM #__virtuemart_products')->loadResult();

public function createClone ($id) {
...
$this->_db = JFactory::getDBO ();  //добавить
$data = $this->_db->setQuery('SELECT MAX(`virtuemart_product_id`)+1 FROM #__virtuemart_products')->loadResult();   //добавить
$product->product_sku = $data;    //добавить

$product->save_customfields = 1;
$this->store ($product);
return $this->_id;
}

UPDATE u5klt_virtuemart_products tt
set tt.product_sku = LPAD(IFNULL(( SELECT NULLIF((kod+1),1) from (SELECT max(tp.product_sku) as kod FROM `u5klt_virtuemart_products` as tp, `u5klt_virtuemart_product_manufacturers` AS tpm 
where tp.virtuemart_product_id = tpm.virtuemart_product_id
and tpm.virtuemart_manufacturer_id = NEW.virtuemart_manufacturer_id
) as tmp1 ), (SELECT concat(LPAD( tm.mf_prefix, 2, '0' ), '001')
FROM `u5klt_virtuemart_manufacturers_ru_ru` AS tm
WHERE tm.virtuemart_manufacturer_id = NEW.virtuemart_manufacturer_id
)), 5, '0')



where tt.virtuemart_product_id = NEW.virtuemart_product_id