Php array

Variantions is een array, dus je zult wel moeten aangeven welke serienummer voor de variation je moet hebben. Of als je ze allemaal wilt gebruiken, dan moet je met foreach() de boel doorlopen.

<?php
// single item:
echo $data['variations']['0401103078-5001-2XL']['eancode'];
?>

<?php
// foreach om alles door te lo(o)pen.
foreach($data['variations'] as $variation) {
	echo "<pre>".print_r($variation)."</pre>"; // ter debugging om te kijken wat er in de array zit.
	echo $variation['eancode'];
}
?>

Hier kan ik inderdaad een stuk mee verder, helaas krijg ik het nog niet helemaal lekker werkend met wat het moet doen.
ik ga nog even stoeien bedankt in ieder geval

[size=xsmall]Toevoeging op 17/05/2020 18:06:49:[/size]

ik heb een stukje class

 
public function update() {
		$this->client = new SoapClient('http://cp.hv-polo.com/api/soap/?wsdl');
		$this->session_id = $this->client->login($this->user, $this->key);
		try {
			$products = $this->client->call($this->session_id, 'ipad_api.customerproducts', [null, $this->DefaultCategoryID, $this->storeID]);
			if ($products) {
				$this->load->model('api/hvpolo');
					$counter = 0;
					$new = '';
					$duration = 0;
					$i=0;
					$max_aantal_producten_toevoegen = 1;
					$max_products = $max_aantal_producten_toevoegen;

				foreach ($products as $product) if ($i < $max_products) {
				if (!$this->model_api_hvpolo->checkProduct2($product)) {
					$details = $this->client->call($this->session_id, 'ipad_api.customerproduct', [$product['product_id'], $this->storeID]);
					
				if ($details) {
				if (isset($details['customer_group_price']['special_price'])) {
				}
									
							$starttime = microtime(true);
							$this->model_api_hvpolo->updateProduct($details);							
							$endtime = microtime(true);							
							$duration += ($endtime - $starttime);
							$counter++;
						//	echo "<pre>";
	 					//	print_r($product);
	 					//	print_r($details);
				 		//	echo "</pre>";
							$new .= ''. $details['name']. '\r\n';
							$new .= '<br />';
							$i+=1;
						}
					}
				}
					if ($new) {
			//echo "dit is gedaan?";
				if ($counter > 0) {
							$this->db->query("INSERT INTO " . DB_PREFIX . "api_log SET type = 'update', aantal_producten = '". $new ."',  duration = '" . $duration . "', datetime = NOW(), site = 'Hv Polo'");
							}
								
								// Duration to DB table
								$this->db->query("INSERT INTO " . DB_PREFIX . "api_log SET type = 'update', aantal_producten = '". $new ."',  duration = '" . $duration . "', datetime = NOW(), site = 'Hv Polo'");
							}
				}
				echo "dit is 2x";
		} catch(Exception $e) {
			foreach ($this->emails as $email) {
				mail($email, 'HV Polo API error', $e->getMessage());
			}
		}
	}

die maakt gebruik van deze twee classes

 public function checkProduct2($data) {
		$search = '';
		if ($data['sku']) {
			$search .= "pwr_sku = '" . $this->db->escape($data['sku']) . "'";
			//print_r($search);
		}
		if ($search) {
			$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "power_options_data WHERE " . $search . " LIMIT 1");
			if ($query->num_rows) {
				return $query->row['pwr_id'];
				print ("<pre>");
				print ("power id ".$pwr_id."");
				print ("</pre>");
			}
		}
		$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "product_description WHERE name = '" . $this->db->escape(trim($data['name'])) ."' LIMIT 1");

		if ($query->num_rows) {
			return $query->row['product_id'];
		}
		return false;
	}

Nou wil ik dus een class hebben dat hij de quantity update bij de variaties

public function updateProduct($data) {
		$option = $this->db->query("SELECT * FROM " . DB_PREFIX . "power_options_data WHERE pwr_sku = '" . $this->db->escape($data['sku']) . "' LIMIT 1");

		//print $data;
	//	print "<br />data sku ".$data['sku']."<br />";
		//print "data sku ".$data['eancode']."<br />";
		//print "".$data['variations']['eancode']."<br />";
//echo "data variations ". $data['variations']['0401103078-5001-2XL']['eancode'] ."";
				//	foreach om alles door te lo(o)pen.
					foreach($data['variations'] as $variation) {
						$this->db->query("UPDATE " . DB_PREFIX . "power_options_data SET pwr_quantity = '" . (int)$variation['stock'] . "' WHERE pwr_product_code = '" . (int)$variation['eancode'] . "'");
						print "<br />data sku ".$data['sku']."<br />";

						echo "<pre>variation stock " . (int)$variation['stock'] . "</pre>";
					    //echo "<pre>".print_r($variation)."</pre>"; // ter debugging om te kijken wat er in de array zit.
					    echo "<pre>variation eancode ". $variation['eancode']."";
					}

		if ($option->num_rows) {
			$pwr_id = $option->row['pwr_id'];

			$this->db->query("UPDATE " . DB_PREFIX . "power_options_data SET pwr_quantity = '" . (int)$variation['stock'] . "' WHERE pwr_product_code = '" . (int)$variation['eancode'] . "'");
			//print_r(" . (int)$variation['stock'] . ")
		}
		
	
		
	}

[code]
CREATE TABLE `power_options_data` (
`pwr_id` int(11) NOT NULL,
`pwr_product_id` int(11) NOT NULL,
`pwr_model` varchar(128) NOT NULL,
`pwr_sku` varchar(128) NOT NULL,
`pwr_product_code` varchar(128) NOT NULL,
`pwr_quantity` int(11) NOT NULL,
`pwr_points` int(11) NOT NULL,
`pwr_weight` decimal(15,3) NOT NULL,
`pwr_length` decimal(15,3) NOT NULL,
`pwr_width` decimal(15,3) NOT NULL,
`pwr_height` decimal(15,3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `power_options` (
`pwr_product_id` int(11) NOT NULL,
`pwr_level` int(2) NOT NULL,
`pwr_option_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `product` (
`product_id` int(11) NOT NULL,
`model` varchar(64) NOT NULL,
`sku` varchar(64) NOT NULL,
`upc` varchar(12) NOT NULL,
`ean` varchar(14) NOT NULL,
`jan` varchar(13) NOT NULL,
`isbn` varchar(17) NOT NULL,
`mpn` varchar(64) NOT NULL,
`location` varchar(128) NOT NULL,
`quantity` int(4) NOT NULL DEFAULT '0',
`stock_status_id` int(11) NOT NULL,
`image` varchar(255) DEFAULT NULL,
`manufacturer_id` int(11) NOT NULL,
`shipping` tinyint(1) NOT NULL DEFAULT '1',
`price` decimal(15,4) NOT NULL DEFAULT '0.0000',
`points` int(8) NOT NULL DEFAULT '0',
`tax_class_id` int(11) NOT NULL,
`date_available` date NOT NULL DEFAULT '0000-00-00',
`weight` decimal(15,8) NOT NULL DEFAULT '0.00000000',
`weight_class_id` int(11) NOT NULL DEFAULT '0',
`length` decimal(15,8) NOT NULL DEFAULT '0.00000000',
`width` decimal(15,8) NOT NULL DEFAULT '0.00000000',
`height` decimal(15,8) NOT NULL DEFAULT '0.00000000',
`length_class_id` int(11) NOT NULL DEFAULT '0',
`subtract` tinyint(1) NOT NULL DEFAULT '1',
`minimum` int(11) NOT NULL DEFAULT '1',
`sort_order` int(11) NOT NULL DEFAULT '0',
`status` tinyint(1) NOT NULL DEFAULT '0',
`viewed` int(5) NOT NULL DEFAULT '0',
`date_added` datetime NOT NULL,
`date_modified` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Waarom ga je voor de eigenschappen en nieuw veld aanmaken? Persoonlijk zou ik deze liever onderbrengen in een aparte tabel met eigenschappen, waaraan je die koppelt aan je product via een koppeltabel. Nu gaat het nog om gewichten, en dimensies, maar wat als er nog kleuren, en maten bij komen? Een mooi punt om te normaliseren.

Dat is al gedaan. Heb niet heel de database neergezet.

Alleen die van toepassing zijn op deze classes.

[size=xsmall]Toevoeging op 17/05/2020 19:26:28:[/size]

Probleem is dus dat hij niet de update wilt uitvoeren in de tabel. Hij moet quantity updaten met de nieuwe gegevens.