синхронизация с Мой склад

{
return;
}

File::save_file(file_get_contents('php://input'), 'tmp/1c/'.$filename);

$xml = simplexml_load_file(ABSOLUTE_PATH.'tmp/1c/'.$filename);

File::delete_file('tmp/1c/'.$filename);

foreach ($xml->Документ as $xml_order)
{
$id = $xml_order->Номер;
list($y, $m, $d) = explode('-', $xml_order->Дата);
list($h, $i, $s) = explode(':', $xml_order->Время);
$created = mktime($h, $i, $s, $m, $d, $y);

$status_name='';
if(isset($xml_order->ЗначенияРеквизитов->ЗначениеРеквизита))
{
foreach($xml_order->ЗначенияРеквизитов->ЗначениеРеквизита as $r)
{
switch ($r->Наименование)
{
case 'Проведен':
$proveden = ($r->Значение == 'true');
break;

case 'ПометкаУдаления':
$udalen = ($r->Значение == 'true');
break;
case 'Статус заказа':
$status_name = strval($r->Значение) ;
break;
}
}
}

if(! empty($udalen))
{
$status = 2;
}
elseif(! empty($proveden))
{
$status = 3;
}
else
{
$status = 0;
}

if(!empty($status_name))
{
$status_id = DB::query_result("SELECT id FROM {shop_order_status} WHERE name1='%s' AND trash='0' LIMIT 1", $status_name);
}
else
$status_id = DB::query_result("SELECT id FROM {shop_order_status} WHERE status='%d' AND trash='0' LIMIT 1", $status);

if(DB::query_result("SELECT id FROM {shop_order} WHERE id=%d", $id))
{
$status_id_old=DB::query_result("SELECT status_id FROM {shop_order} WHERE id=%d", $id);
if($status == 1)
{
$this->diafan->_shop->order_pay($id);
}
else if($status_id_old!=$status_id)
{
$this->diafan->_shop->order_send_mail_change_status($id, $status_id);
}
DB::query("UPDATE {shop_order} SET status='%d', status_id=%d, created=%d WHERE id=%d", $status, $status_id, $created, $id);
}
else
{
DB::query("INSERT INTO {shop_order} (status, status_id, created".($id ? ", id" : '').") VALUES ('%d', %d, %d".($id ? ", %d" : '').")", $status, $status_id, $created, $id);
if(! $id)
{
$id = DB::insert_id();
}
}

$order_goods = array();
// Товары
foreach ($xml_order->Товары->Товар as $xml_product)
{
$import_good_id = 0;
$import_price_id = '';
$order_goods_id = 0;
$good_id = 0;
if(strstr($xml_product->Ид, '#'))
{
list($import_good_id, $import_price_id) = explode('#', $xml_product->Ид, 2);
}
else
{
$import_good_id = $xml_product->Ид;
}

$article = $xml_product->Артикул;
$name = $xml_product->Наименование;
$count_goods = $xml_product->Количество;
$price = $xml_product->ЦенаЗаЕдиницу;
$discount_id = 0;

if(isset($xml_product->Скидки->Скидка))
{
$discount_id = DB::query_result("SELECT id FROM {shop_discount} WHERE discount=%d", $xml_product->Скидки->Скидка->Процент);
}
$join_params = '';
if($import_good_id)
{
$good_id = DB::query_result("SELECT id FROM {shop} WHERE import_id='%h'".(! preg_match('/[^0-9]+/', $import_good_id) ? " OR id='%s'" : ''), $import_good_id, $import_good_id);
if($good_id && $import_price_id)
{
$price_id = DB::query_result("SELECT price_id FROM {shop_price} WHERE good_id=%d AND import_id='%h'".(! preg_match('/[^0-9]+/', $import_price_id) ? " OR price_id='%s'" : ''), $good_id,$import_price_id, $import_price_id);
if($price_id)
{
$rs = DB::query_fetch_all("SELECT * FROM {shop_price_param} WHERE price_id=%d", $price_id);
foreach ($rs as $r)
{
if($r["param_value"])
{
$i = (empty($i) ? 1 : $i + 1);
$join_params .= " INNER JOIN {shop_order_goods_param} AS p".$i." ON p".$i.".order_goods_id=g.id AND p".$i.".param_id=".$r["param_id"]." AND p".$i.".value=".$r["param_value"];
}
}
}
}
}
if(! $good_id && $article)
{
if(! $good_id = DB::query_result("SELECT id FROM {shop} WHERE article='%h'", $article))
continue;
}
if(! $good_id && $name)
{
if(! $good_id = DB::query_result("SELECT id FROM {shop} WHERE [name]='%h'", $name))
continue;
}

$order_goods_id = DB::query_result("SELECT g.id FROM {shop_order_goods} AS g".$join_params." WHERE g.order_id=%d AND g.good_id=%d AND g.trash='0'", $id, $good_id);

if($order_goods_id)
{
DB::query("UPDATE {shop_order_goods} SET count_goods=%d, price=%f, discount_id=%d WHERE id=%d", $count_goods, $price, $discount_id, $order_goods_id);
}
else
{
$order_goods_id = DB::query("INSERT INTO {shop_order_goods} (order_id, good_id, count_goods, price, discount_id) VALUES (%d, %d, %d, %f, %d)", $id, $good_id, $count_goods, $price, $discount_id);
}
$order_goods[] = $order_goods_id;
}
// удаляет покупки, которых нет в файле
if($order_goods)
{
$del_goods = DB::query_fetch_value("SELECT id FROM {shop_order_goods} WHERE id NOT IN (%s) AND order_id=%d", implode(",", $order_goods), $id, "id");
if($del_goods)
{
DB::query("DELETE FROM {shop_order_goods_param} WHERE order_goods_id IN (%s)", implode(",", $del_goods));
DB::query("DELETE FROM {shop_order_goods} WHERE id IN (%s)", implode(",", $del_goods));
}
}
DB::query("UPDATE {shop_order} SET summ=%f WHERE id=%d", $xml_order->Сумма, $id);
}

echo "success";
}