API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 12th, 2017
74
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 11.52 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. $dbhost = 'localhost'; //tutaj podajemy host bazy danych MySQL
  3. $dbuser = ''; // tutaj podajemy login do bazy
  4. $dbpass = ''; // tutaj podajemy hasło do bazy
  5. $dbname = ''; // nazwa bazy danych
  6. $prefiks = 'ps_';
  7. $dbc = @mysql_connect($dbhost, $dbuser, $dbpass) or die ('Nie moge połaczyc sie z Mysql'); //łaczymy z baza
  8. mysql_select_db ($dbname) or die ('Nie moge wybrać bazy'); //wybieramy baze danych
  9.  
  10. mysql_query('SET CHARACTER SET UTF-8');
  11. mysql_query('SET collation_connection = utf8_polish_ci');
  12. mysql_query("SET NAMES utf8");
  13.  
  14. echo '<meta charset="utf-8" />';
  15. echo '<h3>XPartner - AUTOMATYCZNA aktualizacja cen i stanów produktów</h3>';
  16.  
  17.  
  18.  
  19. ini_set("soap.wsdl_cache_enabled", 0);
  20. $client = new SoapClient('http://xpartner.net.pl/soap2.wsdl',
  21. array('location'=> "http://xpartner.net.pl/wsdlSoapServ2.php","uri"=>""));
  22. try {
  23.  
  24.   /*
  25.   * podajemy dane do logowania
  26.   */
  27.   $obj->login  = '8715_0';
  28.   $obj->pass  = 'syneczek71';
  29.   $logged  = $client->login($obj);
  30.   /*
  31.   * jeśli poprawnie zalogowano przystąp do składania zamówienia
  32.   */
  33.   if($logged->loginResult==true){
  34. /*
  35. * wyświetl produkty
  36. */
  37. $lecim = 99999;
  38. for($i=0; $i<1000; $i++)
  39. {
  40. print '<b>getting page: '.$i.'</b><br/>';
  41. $prods->showNotAvailable = false;
  42. $prods->onlyFix = false;
  43. $prods->showMoreThan4 = false;
  44. $prods->page = $i;
  45. $prods->resultsPerPage = 50;
  46. $prods->sort = 'name';
  47. $prods->sessionId = $logged->sessionId;
  48. $products = $client->productsList($prods);
  49.  
  50. $sort->sessionId = $logged->sessionId;
  51. $orderValues = $client->getPossibleSortValues($sort);
  52. echo'<h1>getPossibleSortValues</h1>';
  53. print '<pre>';
  54. var_dump($orderValues);
  55. print '</pre>';
  56.  
  57. #print '<b>productsList</b><br/>';
  58.  
  59. $produkty = get_object_vars($products);
  60. $produkt = $produkty['products'];
  61. #echo '<pre>'; print_r($produkt); echo '</pre>';
  62.  
  63. $ile = count($produkt);
  64. echo 'Razem pobrałem: '.$ile.'<br><br>';
  65. //Wyświetlamy dane z tablicy w kolumnie jeden pod drugim
  66. for ($l=0; $l <$ile; $l++)
  67.    {
  68.     $kod =  $produkt[$l]->manufacturerCode; echo '<br>$Kod: '.$kod;
  69.     $ilosc = $produkt[$l]->quantity; echo '<br>$Ilosc: '.$ilosc;
  70.     $ean = $produkt[$l]->ean; echo '<br>$EAN: '.$ean;
  71.     $nazwa = $produkt[$l]->name; echo '<br>$Nazwa: '.$nazwa;
  72.     $cena_katalogowa_netto = $produkt[$l]->netListPrice;
  73.     $cena_katalogowa_brutto = $produkt[$l]->grossListPrice;
  74.     $cena_netto = $produkt[$l]->netDiscountPrice; echo '<br>$cena_netto: '.$cena_netto;
  75.     $cena_brutto= $produkt[$l]->grossDiscountPrice; echo '<br>$cena_brutto: '.$cena_brutto;
  76.     $kategoria = $produkt[$l]->attributes[0]->value;
  77.     for($j=0;$j<15;$j++)
  78.     {
  79.         $a="producent";
  80.         $str = strtolower($produkt[$l]->attributes[$j]->name);
  81.         if($str==$a){
  82.             $producent = $produkt[$l]->attributes[$j]->value;
  83.             break;
  84.         }
  85.         else
  86.             $producent = "brak1";
  87.        
  88.     }
  89.     $opis = $produkt[$l]->attributes[0]->name.'<br>';
  90.     $opis .= $produkt[$l]->attributes[0]->value.'<br><br>';
  91.     $opis .= $produkt[$l]->attributes[1]->name.'<br>';
  92.     $opis .= $produkt[$l]->attributes[1]->value.'<br><br>';
  93.     $opis .= $produkt[$l]->attributes[2]->name.'<br>';
  94.     $opis .= $produkt[$l]->attributes[2]->value.'<br><br>';
  95.     $opis .= $produkt[$l]->attributes[3]->name.'<br>';
  96.     $opis .= $produkt[$l]->attributes[3]->value.'<br><br>';
  97.     $opis .= $produkt[$l]->attributes[4]->name.'<br>';
  98.     $opis .= $produkt[$l]->attributes[4]->value.'<br><br>';
  99.     $opis .= $produkt[$l]->attributes[5]->name.'<br>';
  100.     $opis .= $produkt[$l]->attributes[5]->value.'<br><br>';
  101.     $opis .= $produkt[$l]->attributes[6]->name.'<br>';
  102.     $opis .= $produkt[$l]->attributes[6]->value.'<br><br>';
  103.     $opis .= $produkt[$l]->attributes[7]->name.'<br>';
  104.     $opis .= $produkt[$l]->attributes[7]->value.'<br><br>';
  105.     $opis .= $produkt[$l]->attributes[8]->name.'<br>';
  106.     $opis .= $produkt[$l]->attributes[8]->value.'<br><br>';
  107.     $opis .= $produkt[$l]->attributes[9]->name.'<br>';
  108.     $opis .= $produkt[$l]->attributes[9]->value.'<br><br>';
  109.     $opis .= $produkt[$l]->attributes[10]->name.'<br>';
  110.     $opis .= $produkt[$l]->attributes[10]->value.'<br><br>';
  111.     $opis .= $produkt[$l]->attributes[11]->name.'<br>';
  112.     $opis .= $produkt[$l]->attributes[11]->value.'<br><br>';
  113.     $opis .= $produkt[$l]->attributes[12]->name.'<br>';
  114.     $opis .= $produkt[$l]->attributes[12]->value.'<br><br>';
  115.     $opis .= $produkt[$l]->attributes[13]->name.'<br>';
  116.     $opis .= $produkt[$l]->attributes[13]->value.'<br><br>';
  117.     $opis .= $produkt[$l]->attributes[14]->name.'<br>';
  118.     $opis .= $produkt[$l]->attributes[14]->value.'<br><br>';
  119.  
  120.  
  121.  
  122.  
  123.  
  124.     $q = "SELECT * FROM `".$prefiks."product` WHERE `reference`='".$kod."'";
  125.     #echo 'q: '.$q.'<br />';
  126.    $r = mysql_query($q) or die('error: '.mysql_error());
  127.  
  128.  
  129.       if (mysql_num_rows($r) != 0 && !empty($kod)){
  130.  
  131.         $row = mysql_fetch_assoc($r);
  132.  
  133.  
  134.           $query2 = "UPDATE `".$prefiks."product` SET quantity='".$ilosc."', price='".$cena_netto."' WHERE reference='".$kod."'";
  135.           $result2 = mysql_query($query2) or die(mysql_error());
  136.            
  137.            $q9 = "SELECT * FROM `".$prefiks."product` WHERE `reference`='".$kod."'";
  138.            $query9=mysql_query($q9);
  139.            $row9=mysql_fetch_array($query);
  140.            $id_p = $row['id_product'];
  141.  
  142.           $query10 = "UPDATE `".$prefiks."stock_available` SET quantity='".$ilosc."' WHERE id_product='".$id_p."'";
  143.           $result10 = mysql_query($query10) or die(mysql_error());
  144.  
  145.           echo 'Aktualizacja ceny i stanu dla produktu <b>'.$kod.'</b>: '.$cena.' PLN netto / '.(int)$ilosc.' szt<br /><br />';
  146.  
  147.       }else{
  148.  
  149.         echo 'Nie ma w bazie produktu o kodzie: <b>'.$kod.'</b> - dodajemy produkt<br />';
  150. #die;
  151.  
  152. $uchwyt = mysql_query("SELECT `name` FROM `ps_category_lang` WHERE `name` = '{$kategoria}'");
  153.   $szukamy = mysql_num_rows($uchwyt);
  154.  
  155.  
  156.       if ($szukamy != 0)
  157.   {
  158.   $uchwyt2 = mysql_query("SELECT * FROM `ps_category_lang` WHERE `name` = '{$kategoria}'");
  159.   while ($id_ka = mysql_fetch_assoc($uchwyt2)) {
  160.   #echo 'taka kategoria jest juz  w sklepie';
  161.    $id_kategorii = $id_ka['id_category'];
  162.   }
  163.  
  164.   } else {
  165.     #echo 'dodaje kategorie';
  166. $dzis = date('Y-m-d H:i:s');
  167. mysql_query("INSERT INTO `ps_category`(`id_parent`, `id_shop_default`, `level_depth`, `active`, `date_add`, `date_upd`, `position`, `is_root_category`)
  168. VALUES ('2','1','2','1','{$dzis}','{$dzis}','9','0')");
  169.  
  170. $id_kategorii =  mysql_insert_id();
  171.  
  172. $filtr = str_replace(' ','_',$kategoria);
  173. $filtr = str_replace('ż','z',$filtr);
  174. $filtr = str_replace('ź','z',$filtr);
  175. $filtr = str_replace('ó','o',$filtr);
  176. $filtr = str_replace('ę','e',$filtr);
  177. $filtr = str_replace('ą','a',$filtr);
  178. $filtr = str_replace('ł','l',$filtr);
  179. $filtr = str_replace('ć','c',$filtr);
  180. $filtr = str_replace('ń','n',$filtr);
  181. $filtr = str_replace('?','_',$filtr);
  182. $filtr = str_replace('-','_',$filtr);
  183. $filtr = str_replace('/','_',$filtr);
  184. $filtr = str_replace('%','_',$filtr);
  185. $filtr = str_replace(',','_',$filtr);
  186. $filtr = str_replace('.','_',$filtr);
  187. $filtr = str_replace(':','_',$filtr);
  188. $filtr = str_replace(';','_',$filtr);
  189. $url_kategorii = $filtr;
  190.  
  191. $filtr = str_replace(' ','_',$nazwa);
  192. $filtr = str_replace('ż','z',$filtr);
  193. $filtr = str_replace('ź','z',$filtr);
  194. $filtr = str_replace('ó','o',$filtr);
  195. $filtr = str_replace('ę','e',$filtr);
  196. $filtr = str_replace('ą','a',$filtr);
  197. $filtr = str_replace('ł','l',$filtr);
  198. $filtr = str_replace('ć','c',$filtr);
  199. $filtr = str_replace('ń','n',$filtr);
  200. $filtr = str_replace('?','_',$filtr);
  201. $filtr = str_replace('-','_',$filtr);
  202. $filtr = str_replace('/','_',$filtr);
  203. $filtr = str_replace('%','_',$filtr);
  204. $filtr = str_replace(',','_',$filtr);
  205. $filtr = str_replace('.','_',$filtr);
  206. $filtr = str_replace(':','_',$filtr);
  207. $filtr = str_replace(';','_',$filtr);
  208. $url_produktu = $filtr;
  209.  
  210.  
  211. mysql_query("INSERT INTO `ps_category_lang`(`id_category`, `id_shop`, `id_lang`, `name`, `link_rewrite`, `meta_title`, `meta_keywords`, `meta_description`)
  212. VALUES ('{$id_kategorii}','1','1','{$kategoria}','{$url_kategorii}','{$kategoria}','{$kategoria}','{$kategoria}')");
  213.  
  214. mysql_query("INSERT INTO `ps_category_shop`(`id_category`, `id_shop`, `position`) VALUES ('{$id_kategorii}','1','1');");
  215.  
  216.  
  217.  
  218.   }
  219.  
  220.    $uchwyt3 = mysql_query("SELECT `name` FROM `ps_manufacturer` WHERE `name` = '{$producent}'");
  221.    // $uchwyt2 = mysql_query("SELECT COUNT(name) FROM 'ps_manufacturer' WHERE name = $producent");
  222.     $szukamy2 = mysql_num_rows($uchwyt3);
  223.  
  224.  
  225.     if ($szukamy2 != 0  )
  226.     {
  227.     $uchwyt4 = mysql_query("SELECT * FROM `ps_manufacturer` WHERE `name` = '{$producent}'");
  228.     //$uchwyt3 = mysql_query("SELECT * FROM 'ps_manufacturer' WHERE name = $producent");
  229.     while ($id_pr = mysql_fetch_assoc($uchwyt4)) {
  230.       #echo 'taka kategoria jest juz  w sklepie';
  231.      $id_producenta = $id_pr['id_manufacturer'];
  232.     }
  233.  
  234.     } else {
  235.   $dzis = date('Y-m-d H:i:s');
  236.   mysql_query("INSERT INTO `ps_manufacturer`(`name`, `date_add`, `date_upd`, `active`)
  237.  VALUES ('{$producent}','{$dzis}','{$dzis}','1')");
  238.  
  239.   $id_producenta =  mysql_insert_id();
  240.  
  241.  
  242.   mysql_query("INSERT INTO `ps_manufacturer_lang`(`id_manufacturer`, `id_lang`) VALUES ('{$id_producenta}','1')");
  243.  
  244.   mysql_query("INSERT INTO `ps_manufacturer_shop`(`id_manufacturer`, `id_shop`) VALUES ('{$id_producenta}','1')");
  245.  
  246.  
  247.  
  248.     }
  249.  
  250. $date = date('Y-m-d H:i:s');
  251. $query = "INSERT INTO `".$prefiks."product` (`id_tax_rules_group`, `id_manufacturer`, `id_category_default`, `price`, `wholesale_price`, `reference`, `supplier_reference`, `location`, `out_of_stock`, `active`, `available_for_order`, `condition`, `show_price`, `indexed`, `date_add`, `date_upd`, `quantity`)
  252. VALUES ('1', '".$id_producenta."', '".$id_kategorii."', '".$cena_netto."', '".$cena_katalogowa_netto."', '".$kod."', '".$kod."', 'xpartner', '2', '1', '1', 'new', '1', '1', '".$date."', '".$date."', '".$ilosc."')";
  253. #echo "query: ".$query."<br>";
  254.  
  255. $result = mysql_query($query) or die("1: ".mysql_error());
  256.  
  257.   $id_produktu =  mysql_insert_id();
  258.  
  259.   #print_r($row2);
  260.  
  261.   $query10 = "INSERT INTO `".$prefiks."product_shop` (`id_product`, `id_shop`, `id_tax_rules_group`, `id_category_default`, `price`, `wholesale_price`, `active`, `available_for_order`, `condition`, `show_price`, `indexed`, `date_add`, `date_upd`)
  262.  VALUES ('".$id_produktu."', '1', '1', '".$id_kategorii."', '".$cena_netto."', '".$cena_netto."', '1', '1', 'new', '1', '1', '".$date."', '".$date."')";
  263. #echo "query: ".$query."<br>";
  264.  
  265.   $result10 = mysql_query($query10) or die("10: ".mysql_error());
  266.  
  267.  
  268.  
  269.   $query3 = "INSERT INTO `ps_product_lang` (`id_product`, `id_lang`, `description`, `description_short`, `link_rewrite`, `meta_description`, `meta_keywords`, `meta_title`, `name`)
  270.  VALUES ('".$id_produktu."', '1', '".$opis."', '".$nazwa."', '".$url_produktu."', '".$nazwa."', '".$nazwa."', '".$nazwa."', '".$nazwa."')";
  271.   #echo 'q3: '.$query3.'<br />';
  272.  $result3 = mysql_query($query3) or die("3: ".mysql_error());
  273.  
  274.     $query4 = "INSERT INTO `".$prefiks."category_product` (`id_category`, `id_product`, `position`)
  275.    VALUES ('".$id_kategorii."', '".$id_produktu."', '0')";
  276.     $result4 = mysql_query($query4) or die("4: ".mysql_error());
  277.  
  278.    
  279.   $query5 = "INSERT INTO `ps_stock_available` (`id_stock_available`, `id_product`, `id_product_attribute`, `id_shop`, `id_shop_group`, `quantity`, `depends_on_stock`, `out_of_stock`)
  280.  VALUES ('".$id_produktu."','".$id_produktu."', '0', '1', '0' ,'".$ilosc."', '0', '0')";
  281.   #echo 'q3: '.$query3.'<br />';
  282.  $result5 = mysql_query($query5) or die("5: ".mysql_error());
  283.  
  284.  
  285.  
  286.  
  287.  
  288.  
  289.  
  290.  
  291.  
  292.  
  293.  
  294.  
  295. }
  296.  
  297. echo 'Wykonuje kolejny produkt';
  298. }
  299.  
  300.  
  301.  
  302. }
  303. }
  304. }
  305. catch (SoapFault $exception)
  306. {
  307. echo $exception;
  308. }
  309.  
  310.  
  311. die('skrypt wykonany OK');
  312.  
  313.  
  314. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!