/**
* возвращает специльный товар для суммвового учета
*
*/
public static function getSumItem()
{
$item = Item::getFirst('item_type=' . Item::ITEM_TYPE_RETSUM);
if ($item instanceof Item) {
return $item;
} else {
throw new \ZippyERP\System\Exception("Не найдет товар для суммового учета");
}
}
/**
* Импорт из ГНАУ формат XML...
*
* @param mixed $data
* @return {mixed|TaxInvoiceIncome} Документ или строку с ошибкой
*/
public static function import($data)
{
if (strpos($data, "<DECLARHEAD>") == false) {
return "Неверный формат";
}
$data = iconv("WINDOWS-1251", "UTF-8", $data);
$data = str_replace("windows-1251", "utf-8", $data);
$xml = @simplexml_load_string($data);
if ($xml instanceof \SimpleXMLElement) {
} else {
return "Неверный формат";
}
$type = (string) $xml->DECLARHEAD->C_DOC . (string) $xml->DECLARHEAD->C_DOC_SUB;
if ($type != "J12010" && $type != "F12010") {
return "Тип документа не Налоговая накладная";
}
$doc = new TaxInvoiceIncome();
$date = (string) $xml->DECLARBODY->HFILL;
$date = substr($date, 4, 4) . '-' . substr($date, 2, 2) . '-' . substr($date, 0, 2);
$doc->document_date = strtotime($date);
$doc->document_number = (string) $xml->DECLARBODY->HNUM;
$doc->headerdata['based'] = (string) $xml->DECLARBODY->H01G1S;
$inn = (string) $xml->DECLARBODY->HKSEL;
$customer = \ZippyERP\ERP\Entity\Customer::loadByInn($inn);
if ($customer == null) {
return "Не найден контрагент с ИНН " . $inn;
}
$doc->headerdata['customer'] = $customer->customer_id;
$ernn = (string) $xml->DECLARBODY->HERPN;
if ($ernn == true) {
$doc->headerdata['ernn'] = true;
}
$details = array();
foreach ($xml->xpath('//RXXXXG3S') as $node) {
$details[(string) $node->attributes()->ROWNUM]['name'] = (string) $node;
}
foreach ($xml->xpath('//RXXXXG5') as $node) {
$details[(string) $node->attributes()->ROWNUM]['qty'] = (string) $node;
}
foreach ($xml->xpath('//RXXXXG6') as $node) {
$details[(string) $node->attributes()->ROWNUM]['price'] = (string) $node;
}
foreach ($xml->xpath('//RXXXXG105_2S') as $node) {
$details[(string) $node->attributes()->ROWNUM]['mcode'] = (string) $node;
}
foreach ($xml->xpath('//RXXXXG4') as $node) {
$details[(string) $node->attributes()->ROWNUM]['code'] = (string) $node;
}
foreach ($xml->xpath('//RXXXXG4S') as $node) {
$details[(string) $node->attributes()->ROWNUM]['mname'] = (string) $node;
}
$nds = H::nds();
$doc->detaildata = array();
foreach ($details as $row) {
if ($row['code'] > 0) {
$item = \ZippyERP\ERP\Entity\Item::loadByUktzed($row['code']);
if ($item == null) {
return "Не найден ТМЦ с кодом УКТ ЗЕД: " . $row['code'];
}
$item->price = $row['price'] * 100;
$item->pricends = $item->price + $item->price * $nds;
$item->quantity = $row['qty'];
$doc->detaildata[] = $item;
continue;
}
// Пытаемся найти по имени
$item = \ZippyERP\ERP\Entity\Item::getFirst("itemname='" . trim($row['price']) . "'");
if ($item != null) {
$item->price = $row['price'] * 100;
$item->quantity = $row['qty'];
$doc->detaildata[] = $item;
continue;
}
}
if (count($details) > count($doc->detaildata)) {
return "Не найдены все записи таблицы";
}
return $doc;
}