rest api битрикс24
1c to b24
обновление данных из 1с в битрикс
<?php session_start();
require_once "../connect3.php";
function p($s){echo"<pre>";print_r($s);echo"</pre>";}
$a=unserialize(file_get_contents('c1_to_b24_get.txt'));
p($a);
foreach($_GET['ID_bitrix24'] as $k=>$v)
{
//$coz="DELETE FROM `huk` WHERE `huk`.`ID_bitrix24` = ".$_GET['ID_bitrix24'][$k].""; mysql_query($coz,$link);
$coz="UPDATE `huk` SET
`ARTICLE` = '".$_GET['ARTICLE'][$k]."',
`NAME` = '".$_GET['NAME'][$k]."',
`CODE` = '".$_GET['CODE'][$k]."',
`ACTIVE` = '".$_GET['ACTIVE'][$k]."',
`PREVIEW_PICTURE` = '".$_GET['PREVIEW_PICTURE'][$k]."',
`DETAL_PICTURE` = '".$_GET['DETAL_PICTURE'][$k]."',
`XML_ID` = '".$_GET['XML_ID'][$k]."',
`CATALOG_ID` = '".$_GET['CATALOG_ID'][$k]."',
`SECTION_ID` = '".$_GET['SECTION_ID'][$k]."',
`DESCRIPTION2` = '".$_GET['DESCRIPTION2'][$k]."',
`PRICE` = '".$_GET['PRICE'][$k]."',
`BREND` = '".$_GET['BREND'][$k]."',
`MATERIAL` = '".$_GET['MATERIAL'][$k]."',
`POL` = '".$_GET['POL'][$k]."',
`PROIZVODITEL` = '".$_GET['PROIZVODITEL'][$k]."'
WHERE `huk`.`ID_bitrix24` = ".$_GET['ID_bitrix24'][$k].";";
mysql_query(iconv('utf-8','cp1251',$coz),$link);
///////////////////////////
$queryUrl = 'https://b24-tsczw2.bitrix24.ru/rest/1/bsu4o4u4uv7fiexe/crm.product.update.json';
$queryData = http_build_query(array(
'ID' => $_GET['ID_bitrix24'][$k] ,
'fields' => array(
'NAME' => $_GET['NAME'][$k],
'CREATED_BY' => '1',
'CATALOG_ID' => $_GET['CATALOG_ID'][$k],
'SECTION_ID' => $_GET['SECTION_ID'][$k],
'CURRENCY_ID' => 'RUB',
'PRICE' => $_GET['PRICE'][$k],
'CODE' => $_GET['ARTICLE'][$k],
'PROPERTY_116' => $_GET['PROIZVODITEL'][$k],
'PROPERTY_114' => $_GET['ARTICLE'][$k],
'DESCRIPTION' => $_GET['DESCRIPTION2'][$k],
'PROPERTY_167' => $_GET['BREND'][$k],
'PROPERTY_118' => $_GET['MATERIAL'][$k],
'PROPERTY_179' => $_GET['POL'][$k],
'SORT' => 500
)));
$curl = curl_init();
curl_setopt_array($curl, array(
CURLOPT_SSL_VERIFYPEER => 0,
CURLOPT_POST => 1,
CURLOPT_HEADER => 0,
CURLOPT_RETURNTRANSFER => 1,
CURLOPT_URL => $queryUrl,
CURLOPT_POSTFIELDS => $queryData,
));
$result = curl_exec($curl);
curl_close($curl);
$result = json_decode($result, 1);
if (array_key_exists('error', $result)) echo "Ошибка при сохранении лида: ".$result['error_description'].
"<br/>";
///////////////////////////
}
echo '<a href="c1_to_b24_get.txt" target="_blanck">GET</a>';
file_put_contents('c1_to_b24_get.txt',serialize($_GET));
mysql_close($link);
?>
****************
вывод данных с параметрами всего товара
<meta charset="utf-8">
<?php
$queryUrl = 'https://b24-tsczw2.bitrix24.ru/rest/1/bsu4o4u4uv7fiexe/crm.product.list.json';
$queryData = http_build_query(array(
'select' => array(
"ID",
"NAME",
"CODE",
"ACTIVE",
"CREATED_BY",
"CATALOG_ID",
"SECTION_ID",
"PRICE",
"DESCRIPTION",
"PROPERTY_167",
"PROPERTY_179",
'PROPERTY_116',
'PROPERTY_114',
'PROPERTY_118'
)
));
//$queryUrl = 'https://b24-tsczw2.bitrix24.ru/rest/1/bsu4o4u4uv7fiexe/crm.product.list.json'; $queryData = http_build_query(); //выгрузка всего товара
$curl = curl_init();
curl_setopt_array($curl, array(
CURLOPT_SSL_VERIFYPEER => 0,
CURLOPT_POST => 1,
CURLOPT_HEADER => 0,
CURLOPT_RETURNTRANSFER => 1,
CURLOPT_URL => $queryUrl,
CURLOPT_POSTFIELDS => $queryData,
));
$result = curl_exec($curl);
curl_close($curl);
$result = json_decode($result, 1);
if (array_key_exists('error', $result)) echo "Ошибка при сохранении лида: ".$result['error_description'].
"<br/>";
echo "<pre>";
print_r($result['result']);
echo "</pre>";
foreach($result['result'] as $k=>$v)
{
echo "#".$k."~".$v[ID]."~".$v[NAME]."~".$v[CODE]."~".$v[ACTIVE]."~".$v[CREATED_BY]."~".$v[CATALOG_ID]."~".$v[SECTION_ID]."~".$v[PRICE]."~".$v[DESCRIPTION]."~".$v[PROPERTY_116][value]."~".$v[PROPERTY_179][value]."~".$v[PROPERTY_118][0][value]."~".$v[PROPERTY_167][0][value]."
";
}
?>
Комментариев нет:
Отправить комментарий