PageRenderTime 52ms CodeModel.GetById 19ms RepoModel.GetById 0ms app.codeStats 0ms

/1/price_upp.php

https://bitbucket.org/spivovartsev/citrus.ua
PHP | 118 lines | 91 code | 22 blank | 5 comment | 11 complexity | 7d2538c86de36d8795309006a66f0b5f MD5 | raw file
Possible License(s): BSD-3-Clause
  1. <?php
  2. require 'class.phpmailer.php';
  3. $db = mysql_connect('localhost', 'citrus_store', 'vSpYAxRujDfNtneX11a');
  4. mysql_select_db('citrus_store', $db);
  5. mysql_query ("set character_set_client='cp1251'");
  6. mysql_query ("set character_set_results='cp1251'");
  7. mysql_query ("set collation_connection='cp1251_general_ci'");
  8. $arr_el[1]=45042;
  9. $arr_el[2]=45014;
  10. $arr_el[3]=45029;
  11. $arr_el[4]=45026;
  12. $arr_el[5]=45035;
  13. $arr_el[6]=45033;
  14. $count=6;
  15. $cur_date=date("Y-n-d");
  16. $upp="";
  17. //---------------------------------------------- ѕ–ќ¬≈– ј Ќј ѕ–»—”“—“¬»≈ ¬—≈’ ЁЋ≈ћ≈Ќ“ќ¬
  18. for ($ii=1; $ii<=$count; $ii++)
  19. {
  20. $fl=0;
  21. $sql="SELECT ID FROM price_upp WHERE (ID=".$arr_el[$ii].")";
  22. $result = mysql_query($sql, $db);
  23. while ($r = mysql_fetch_array($result))
  24. {
  25. if ($r['ID']>0){$fl=1;}
  26. }
  27. if ($fl==0)
  28. {
  29. $sql="SELECT bie.ID, bie.NAME, bcp.PRICE
  30. FROM b_iblock_element as bie, b_catalog_price as bcp
  31. WHERE (bie.ID=bcp.PRODUCT_ID
  32. AND bcp.CATALOG_GROUP_ID=3
  33. AND bie.ID=".$arr_el[$ii].")";
  34. $result = mysql_query($sql, $db);
  35. while ($r = mysql_fetch_array($result))
  36. {
  37. $n=$r['NAME'];
  38. $c_pr=$r['PRICE'];
  39. $o_pr=$r['PRICE'];
  40. }
  41. $sql="INSERT INTO price_upp (ID, NAME, CUR_PRICE, OLD_PRICE, DATA) values (".$arr_el[$ii].", '".$n."', ".$c_pr.", ".$o_pr.", '".$cur_date."')";
  42. mysql_query($sql, $db);
  43. //echo $sql."<br />";
  44. }
  45. else
  46. {
  47. $sql="SELECT bie.ID, bie.NAME, bcp.PRICE
  48. FROM b_iblock_element as bie, b_catalog_price as bcp
  49. WHERE (bie.ID=bcp.PRODUCT_ID
  50. AND bcp.CATALOG_GROUP_ID=3
  51. AND bie.ID=".$arr_el[$ii].")";
  52. $result = mysql_query($sql, $db);
  53. while ($r = mysql_fetch_array($result))
  54. {
  55. $c_pr=$r['PRICE'];
  56. $n=$r['NAME'];
  57. }
  58. $sql="SELECT * FROM price_upp WHERE (ID=".$arr_el[$ii].")";
  59. $result = mysql_query($sql, $db);
  60. while ($r = mysql_fetch_array($result))
  61. {
  62. $o_pr=$r['CUR_PRICE'];
  63. }
  64. $sql="UPDATE price_upp set CUR_PRICE=".$c_pr." WHERE (ID=".$arr_el[$ii].")";
  65. mysql_query($sql, $db);
  66. $sql="UPDATE price_upp set OLD_PRICE=".$o_pr." WHERE (ID=".$arr_el[$ii].")";
  67. mysql_query($sql, $db);
  68. //echo $o_pr." = ".$c_pr."<br />";
  69. if ($o_pr!=$c_pr)
  70. {
  71. $upp.="<p>[".$arr_el[$ii]."] ".$n." изменение цены с ".$o_pr." на ".$c_pr."</p>";
  72. }
  73. }
  74. }
  75. //---------------------------------------------- #ѕ–ќ¬≈– ј Ќј ѕ–»—”“—“¬»≈ ¬—≈’ ЁЋ≈ћ≈Ќ“ќ¬
  76. echo "<p>DONE!</p>";
  77. echo $upp;
  78. echo "len=".strlen($upp);
  79. if (strlen($upp)>0)
  80. {
  81. $text=$upp;
  82. $from="admin@citrus.com.ua";
  83. $fio="Citrus Admin";
  84. $theme = "»зменени€ цен на сайте CITRUS.UA";
  85. $mail = new PHPMailer();
  86. $mail->From = $from; // от кого
  87. $mail->FromName = $fio; // от кого
  88. $mail->AddAddress('darda@citrus.com.ua', ''); // кому - адрес, »м€
  89. $mail->IsHTML(true); // выставл€ем формат письма HTML
  90. $mail->Subject = $theme; // тема письма
  91. $mail->Body = $text.$mess;
  92. if (!$mail->Send()) die ('Mailer Error: '.$mail->ErrorInfo);
  93. //echo "<p>ѕисьмо отправлено!</p>";
  94. exit;
  95. }
  96. ?>