/1/price_upp.php
PHP | 118 lines | 91 code | 22 blank | 5 comment | 11 complexity | 7d2538c86de36d8795309006a66f0b5f MD5 | raw file
Possible License(s): BSD-3-Clause
- <?php
- require 'class.phpmailer.php';
- $db = mysql_connect('localhost', 'citrus_store', 'vSpYAxRujDfNtneX11a');
- mysql_select_db('citrus_store', $db);
- mysql_query ("set character_set_client='cp1251'");
- mysql_query ("set character_set_results='cp1251'");
- mysql_query ("set collation_connection='cp1251_general_ci'");
- $arr_el[1]=45042;
- $arr_el[2]=45014;
- $arr_el[3]=45029;
- $arr_el[4]=45026;
- $arr_el[5]=45035;
- $arr_el[6]=45033;
- $count=6;
- $cur_date=date("Y-n-d");
- $upp="";
- //---------------------------------------------- ѕ–ќ¬≈– ј Ќј ѕ–»—”“—“¬»≈ ¬—≈’ ЁЋ≈ћ≈Ќ“ќ¬
- for ($ii=1; $ii<=$count; $ii++)
- {
- $fl=0;
- $sql="SELECT ID FROM price_upp WHERE (ID=".$arr_el[$ii].")";
- $result = mysql_query($sql, $db);
- while ($r = mysql_fetch_array($result))
- {
- if ($r['ID']>0){$fl=1;}
- }
- if ($fl==0)
- {
- $sql="SELECT bie.ID, bie.NAME, bcp.PRICE
- FROM b_iblock_element as bie, b_catalog_price as bcp
- WHERE (bie.ID=bcp.PRODUCT_ID
- AND bcp.CATALOG_GROUP_ID=3
- AND bie.ID=".$arr_el[$ii].")";
- $result = mysql_query($sql, $db);
- while ($r = mysql_fetch_array($result))
- {
- $n=$r['NAME'];
- $c_pr=$r['PRICE'];
- $o_pr=$r['PRICE'];
- }
- $sql="INSERT INTO price_upp (ID, NAME, CUR_PRICE, OLD_PRICE, DATA) values (".$arr_el[$ii].", '".$n."', ".$c_pr.", ".$o_pr.", '".$cur_date."')";
- mysql_query($sql, $db);
- //echo $sql."<br />";
- }
- else
- {
-
- $sql="SELECT bie.ID, bie.NAME, bcp.PRICE
- FROM b_iblock_element as bie, b_catalog_price as bcp
- WHERE (bie.ID=bcp.PRODUCT_ID
- AND bcp.CATALOG_GROUP_ID=3
- AND bie.ID=".$arr_el[$ii].")";
- $result = mysql_query($sql, $db);
- while ($r = mysql_fetch_array($result))
- {
- $c_pr=$r['PRICE'];
- $n=$r['NAME'];
- }
- $sql="SELECT * FROM price_upp WHERE (ID=".$arr_el[$ii].")";
- $result = mysql_query($sql, $db);
- while ($r = mysql_fetch_array($result))
- {
- $o_pr=$r['CUR_PRICE'];
- }
- $sql="UPDATE price_upp set CUR_PRICE=".$c_pr." WHERE (ID=".$arr_el[$ii].")";
- mysql_query($sql, $db);
- $sql="UPDATE price_upp set OLD_PRICE=".$o_pr." WHERE (ID=".$arr_el[$ii].")";
- mysql_query($sql, $db);
-
- //echo $o_pr." = ".$c_pr."<br />";
- if ($o_pr!=$c_pr)
- {
- $upp.="<p>[".$arr_el[$ii]."] ".$n." изменение цены с ".$o_pr." на ".$c_pr."</p>";
- }
- }
-
-
- }
- //---------------------------------------------- #ѕ–ќ¬≈– ј Ќј ѕ–»—”“—“¬»≈ ¬—≈’ ЁЋ≈ћ≈Ќ“ќ¬
- echo "<p>DONE!</p>";
- echo $upp;
- echo "len=".strlen($upp);
- if (strlen($upp)>0)
- {
- $text=$upp;
- $from="admin@citrus.com.ua";
- $fio="Citrus Admin";
- $theme = "»зменени€ цен на сайте CITRUS.UA";
-
- $mail = new PHPMailer();
- $mail->From = $from; // от кого
- $mail->FromName = $fio; // от кого
- $mail->AddAddress('darda@citrus.com.ua', ''); // кому - адрес, »м€
- $mail->IsHTML(true); // выставл€ем формат письма HTML
- $mail->Subject = $theme; // тема письма
- $mail->Body = $text.$mess;
- if (!$mail->Send()) die ('Mailer Error: '.$mail->ErrorInfo);
- //echo "<p>ѕисьмо отправлено!</p>";
- exit;
- }
- ?>