price_upp.php | searchcode

/1/search/price_upp.php

https://bitbucket.org/spivovartsev/citrus.ua
PHP | 442 lines | 334 code | 56 blank | 52 comment | 36 complexity | 74c3ce95073f4327e89974746e76d9b6 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'");

//------------------------------------------выборка SAMSUNG, NOKIA, LG, SONY
$sql="SELECT bie.ID, bie.NAME, bcp.PRICE 
FROM b_iblock_element as bie,
b_iblock_section_element as bise,
b_catalog_price as bcp 
WHERE (bie.ID=bise.IBLOCK_ELEMENT_ID
AND bcp.PRODUCT_ID=bie.ID
AND bcp.CATALOG_GROUP_ID=1
AND bie.ACTIVE='Y'
AND bie.WF_PARENT_ELEMENT_ID IS NULL
AND bie.IBLOCK_ID=20
AND (bise.IBLOCK_SECTION_ID=149 OR bise.IBLOCK_SECTION_ID=150 OR bise.IBLOCK_SECTION_ID=151 OR bise.IBLOCK_SECTION_ID=566))";
$result = mysql_query($sql, $db);
while ($r = mysql_fetch_array($result))
{
	$sql2="SELECT * FROM b_catalog_price WHERE (CATALOG_GROUP_ID=4 AND PRODUCT_ID=".$r['ID'].")";
	$result2 = mysql_query($sql2, $db);
	while ($r2 = mysql_fetch_array($result2))
	{
		$pr3=$r2['PRICE'];
	}
	$pr1=$r['PRICE'];
	$pr2=$pr1*1;
	$pr2=round($pr2);
	if ($pr2==$pr3)
	{
		//echo "! ".$r['ID']." - ".$r['NAME']." = ".$r['PRICE']." - ".$pr3."<br />";
	}
	else 
	{
		//echo "? ".$r['ID']." - ".$r['NAME']." = ".$r['PRICE']." - ".$pr3."[*1=".$pr2."]<br />";
		$sql3="UPDATE b_catalog_price set PRICE=".$pr2." WHERE (CATALOG_GROUP_ID=4 AND PRODUCT_ID=".$r['ID'].")";
		mysql_query($sql3, $db);
		//echo $sql3."<br />";
	}
}
//----------------------------------------------------------------------------


//echo "<br /><br />";

//------------------------------------------выборка HTC
$sql="SELECT bie.ID, bie.NAME, bcp.PRICE 
FROM b_iblock_element as bie,
b_iblock_section_element as bise,
b_catalog_price as bcp 
WHERE (bie.ID=bise.IBLOCK_ELEMENT_ID
AND bcp.PRODUCT_ID=bie.ID
AND bcp.CATALOG_GROUP_ID=1
AND bie.ACTIVE='Y'
AND bie.WF_PARENT_ELEMENT_ID IS NULL
AND bie.IBLOCK_ID=20
AND bise.IBLOCK_SECTION_ID=239)";
$result = mysql_query($sql, $db);
while ($r = mysql_fetch_array($result))
{
	$sql2="SELECT * FROM b_catalog_price WHERE (CATALOG_GROUP_ID=4 AND PRODUCT_ID=".$r['ID'].")";
	$result2 = mysql_query($sql2, $db);
	while ($r2 = mysql_fetch_array($result2))
	{
		$pr3=$r2['PRICE'];
	}
	$pr1=$r['PRICE'];
	$pr2=$pr1*1.05;
	$pr2=round($pr2);
	if ($pr2==$pr3)
	{
		//echo "! ".$r['ID']." - ".$r['NAME']." = ".$r['PRICE']." - ".$pr3."<br />";
	}
	else 
	{
		//echo "? ".$r['ID']." - ".$r['NAME']." = ".$r['PRICE']." - ".$pr3."[*1.05=".$pr2."]<br />";
		$sql3="UPDATE b_catalog_price set PRICE=".$pr2." WHERE (CATALOG_GROUP_ID=4 AND PRODUCT_ID=".$r['ID'].")";
		mysql_query($sql3, $db);
		//echo $sql3."<br />";
	}
}
//----------------------------------------------------------------------------


//echo "<br /><br />";

//------------------------------------------выборка HUAWEI
$sql="SELECT bie.ID, bie.NAME, bcp.PRICE 
FROM b_iblock_element as bie,
b_iblock_section_element as bise,
b_catalog_price as bcp 
WHERE (bie.ID=bise.IBLOCK_ELEMENT_ID
AND bcp.PRODUCT_ID=bie.ID
AND bcp.CATALOG_GROUP_ID=1
AND bie.ACTIVE='Y'
AND bie.WF_PARENT_ELEMENT_ID IS NULL
AND bie.IBLOCK_ID=20
AND bise.IBLOCK_SECTION_ID=626)";
$result = mysql_query($sql, $db);
while ($r = mysql_fetch_array($result))
{
	$sql2="SELECT * FROM b_catalog_price WHERE (CATALOG_GROUP_ID=4 AND PRODUCT_ID=".$r['ID'].")";
	$result2 = mysql_query($sql2, $db);
	while ($r2 = mysql_fetch_array($result2))
	{
		$pr3=$r2['PRICE'];
	}
	$pr1=$r['PRICE'];
	$pr2=$pr1*1.09;
	$pr2=round($pr2);
	if ($pr2==$pr3)
	{
		//echo "! ".$r['ID']." - ".$r['NAME']." = ".$r['PRICE']." - ".$pr3."<br />";
	}
	else 
	{
		//echo "? ".$r['ID']." - ".$r['NAME']." = ".$r['PRICE']." - ".$pr3."[*1.09=".$pr2."]<br />";
		$sql3="UPDATE b_catalog_price set PRICE=".$pr2." WHERE (CATALOG_GROUP_ID=4 AND PRODUCT_ID=".$r['ID'].")";
		mysql_query($sql3, $db);
		//echo $sql3."<br />";
	}
}
//----------------------------------------------------------------------------






$count=0;
//------------------------------------------------------------iphone
$sql="SELECT bie.ID, bie.NAME FROM b_iblock_element as bie,
b_iblock_section_element as bise WHERE (bie.ID=bise.IBLOCK_ELEMENT_ID
AND bie.ACTIVE='Y'
AND bie.WF_PARENT_ELEMENT_ID IS NULL
AND bie.IBLOCK_ID=20
AND bise.IBLOCK_SECTION_ID=676)";
$result = mysql_query($sql, $db);
while ($r = mysql_fetch_array($result))
{
	$count++;
	$arr_el[$count]=$r['ID'];
}
//-------------------------------------------------------------#iphone

//-------------------------------------------------------------ipad
$sql="SELECT bie.ID, bie.NAME FROM b_iblock_element as bie,
b_iblock_section_element as bise WHERE (bie.ID=bise.IBLOCK_ELEMENT_ID
AND bie.ACTIVE='Y'
AND bie.WF_PARENT_ELEMENT_ID IS NULL
AND bie.IBLOCK_ID=43
AND bise.IBLOCK_SECTION_ID=667)";
$result = mysql_query($sql, $db);
while ($r = mysql_fetch_array($result))
{
	$count++;
	$arr_el[$count]=$r['ID'];
}
//-------------------------------------------------------------#ipad

//-------------------------------------------------------------ipod
$sql="SELECT bie.ID, bie.NAME FROM b_iblock_element as bie,
b_iblock_section_element as bise WHERE (bie.ID=bise.IBLOCK_ELEMENT_ID
AND bie.ACTIVE='Y'
AND bie.WF_PARENT_ELEMENT_ID IS NULL
AND bie.IBLOCK_ID=21
AND bise.IBLOCK_SECTION_ID=152)";
$result = mysql_query($sql, $db);
while ($r = mysql_fetch_array($result))
{
	$count++;
	$arr_el[$count]=$r['ID'];
}
//-------------------------------------------------------------#ipod

//-------------------------------------------------------------macbook
$sql="SELECT bie.ID, bie.NAME FROM b_iblock_element as bie,
b_iblock_section_element as bise WHERE (bie.ID=bise.IBLOCK_ELEMENT_ID
AND bie.ACTIVE='Y'
AND bie.WF_PARENT_ELEMENT_ID IS NULL
AND bie.IBLOCK_ID=22
AND bise.IBLOCK_SECTION_ID=669)";
$result = mysql_query($sql, $db);
while ($r = mysql_fetch_array($result))
{
	$count++;
	$arr_el[$count]=$r['ID'];
}
//-------------------------------------------------------------#macbook

//-------------------------------------------------------------htc
$sql="SELECT bie.ID, bie.NAME FROM b_iblock_element as bie,
b_iblock_section_element as bise WHERE (bie.ID=bise.IBLOCK_ELEMENT_ID
AND bie.ACTIVE='Y'
AND bie.WF_PARENT_ELEMENT_ID IS NULL
AND bie.IBLOCK_ID=20
AND bise.IBLOCK_SECTION_ID=239)";
$result = mysql_query($sql, $db);
while ($r = mysql_fetch_array($result))
{
	$count++;
	$arr_el[$count]=$r['ID'];
}
//-------------------------------------------------------------#htc

//-------------------------------------------------------------планшеты google
$sql="SELECT bie.ID, bie.NAME FROM b_iblock_element as bie,
b_iblock_section_element as bise WHERE (bie.ID=bise.IBLOCK_ELEMENT_ID
AND bie.ACTIVE='Y'
AND bie.WF_PARENT_ELEMENT_ID IS NULL
AND bie.IBLOCK_ID=43
AND bise.IBLOCK_SECTION_ID=677)";
$result = mysql_query($sql, $db);
while ($r = mysql_fetch_array($result))
{
	$count++;
	$arr_el[$count]=$r['ID'];
}
//-------------------------------------------------------------#планшеты google

//-------------------------------------------------------------
/*
$sql="SELECT bie.ID, bie.NAME FROM b_iblock_element as bie,
b_iblock_section_element as bise WHERE (bie.ID=bise.IBLOCK_ELEMENT_ID
AND bie.ACTIVE='Y'
AND bie.WF_PARENT_ELEMENT_ID IS NULL
AND bie.IBLOCK_ID=
AND bise.IBLOCK_SECTION_ID=)";
$result = mysql_query($sql, $db);
while ($r = mysql_fetch_array($result))
{
	$count++;
	$arr_el[$count]=$r['ID'];
}*/
//-------------------------------------------------------------#

// monster beats
$count++; $arr_el[$count]=50278;
$count++; $arr_el[$count]=46736;

$count++; $arr_el[$count]=49807;
$count++; $arr_el[$count]=49808;
$count++; $arr_el[$count]=49805;
$count++; $arr_el[$count]=49806;


$count++; $arr_el[$count]=47072;
$count++; $arr_el[$count]=38122;
$count++; $arr_el[$count]=47073;
$count++; $arr_el[$count]=47074;
$count++; $arr_el[$count]=34257;
$count++; $arr_el[$count]=34258;
$count++; $arr_el[$count]=39240;
$count++; $arr_el[$count]=47087;
$count++; $arr_el[$count]=39241;
$count++; $arr_el[$count]=47089;
$count++; $arr_el[$count]=39254;
$count++; $arr_el[$count]=34254;
$count++; $arr_el[$count]=34949;
$count++; $arr_el[$count]=34255;
$count++; $arr_el[$count]=34260;
$count++; $arr_el[$count]=39268;
$count++; $arr_el[$count]=39271;
$count++; $arr_el[$count]=47080;
$count++; $arr_el[$count]=34256;
$count++; $arr_el[$count]=34259;

//print_r($arr_el);

$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." нова€ цена - ".$c_pr."</p>";
		}
	}
	
	
}
//---------------------------------------------- #ѕ–ќ¬≈– ј Ќј ѕ–»—”“—“¬»≈ ¬—≈’ ЁЋ≈ћ≈Ќ“ќ¬







echo "<p>DONE!</p>";
//echo $upp;

if (strlen($upp)>0)
{

//echo "len=".strlen($upp);
$text="<p>»зменение цен на ".$cur_date."</p>";
$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);

$mail = new PHPMailer();
$mail->From = $from;      // от кого
$mail->FromName = $fio;   // от кого
$mail->AddAddress('bushuev@citrus.com.ua', ''); // кому - адрес, »м€
$mail->IsHTML(true);        // выставл€ем формат письма HTML
$mail->Subject = $theme;  // тема письма
$mail->Body = $text.$mess;
if (!$mail->Send()) die ('Mailer Error: '.$mail->ErrorInfo);



$mail = new PHPMailer();
$mail->From = $from;      // от кого
$mail->FromName = $fio;   // от кого
$mail->AddAddress('i.ostapov@citrus.com.ua', ''); // кому - адрес, »м€
$mail->IsHTML(true);        // выставл€ем формат письма HTML
$mail->Subject = $theme;  // тема письма
$mail->Body = $text.$mess;
if (!$mail->Send()) die ('Mailer Error: '.$mail->ErrorInfo);
$mail = new PHPMailer();
$mail->From = $from;      // от кого
$mail->FromName = $fio;   // от кого
$mail->AddAddress('gorovaya@citrus.com.ua', ''); // кому - адрес, »м€
$mail->IsHTML(true);        // выставл€ем формат письма HTML
$mail->Subject = $theme;  // тема письма
$mail->Body = $text.$mess;
if (!$mail->Send()) die ('Mailer Error: '.$mail->ErrorInfo);



$mail = new PHPMailer();
$mail->From = $from;      // от кого
$mail->FromName = $fio;   // от кого
$mail->AddAddress('o.chuprun.netpeak@gmail.com', ''); // кому - адрес, »м€
$mail->IsHTML(true);        // выставл€ем формат письма HTML
$mail->Subject = $theme;  // тема письма
$mail->Body = $text.$mess;
if (!$mail->Send()) die ('Mailer Error: '.$mail->ErrorInfo);

$mail = new PHPMailer();
$mail->From = $from;      // от кого
$mail->FromName = $fio;   // от кого
$mail->AddAddress('e.reizina@yandex-team.com.ua', ''); // кому - адрес, »м€
$mail->IsHTML(true);        // выставл€ем формат письма HTML
$mail->Subject = $theme;  // тема письма
$mail->Body = $text.$mess;
if (!$mail->Send()) die ('Mailer Error: '.$mail->ErrorInfo);

$mail = new PHPMailer();
$mail->From = $from;      // от кого
$mail->FromName = $fio;   // от кого
$mail->AddAddress('ivanova_e@citrus.com.ua', ''); // кому - адрес, »м€
$mail->IsHTML(true);        // выставл€ем формат письма HTML
$mail->Subject = $theme;  // тема письма
$mail->Body = $text.$mess;
if (!$mail->Send()) die ('Mailer Error: '.$mail->ErrorInfo);

$mail = new PHPMailer();
$mail->From = $from;      // от кого
$mail->FromName = $fio;   // от кого
$mail->AddAddress('tochkavidachiodessa@citrus.com.ua', ''); // кому - адрес, »м€
$mail->IsHTML(true);        // выставл€ем формат письма HTML
$mail->Subject = $theme;  // тема письма
$mail->Body = $text.$mess;
if (!$mail->Send()) die ('Mailer Error: '.$mail->ErrorInfo);



exit;


}
?>