1С-Битрикс Разработчикам

Гууглил много, в форуме копался,но внятного ответа так и не нашел.
по пути /bitrix/modules/sale/ru/reports нашел печатные формы. Начал с бланка заказов.

вот сам код

Код

<?if (!defined("B_PROLOG_INCLUDED") || B_PROLOG_INCLUDED !== true) die();?><!DO CTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<?if (!defined("B_PROLOG_INCLUDED") || B_PROLOG_INCLUDED !== true) die();?><!DO CTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<ht ml xmlns:v="urn:s chemas-microsoft-com:vml"
xmlns:o="urn:s chemas-microsoft-com:office:office"
xmlns:w="urn:s chemas-microsoft-com:office:word"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<met a http-equiv=Content-Type content="text/html; charset=<?=LANG_CHARSET?>">
<title langs="ru">Бланк заказа</title>
<st yle>
<!--
.header{font-size:17px; font-family:Tahoma;padding-left:8px;}
.sub_header{font-size:13px; font-family:Tahoma;padding-left:8px;}
.date{font-style:italic; font-family:Tahoma;padding-left:8px;}
.number{font-size:24px;font-family:Tahoma;font-style:italic;padding-left:8px;}
.user{font-size:12px;font-family:Tahoma;font-weight:bold;padding-left:8px;}
.summa{font-size:12px;font-family:Tahoma;font-weight:bold;padding-left:15px;}

table.blank {
   border-collapse: collapse;
   width: 585px;
}
table.blank td {
   border:0.5pt solid windowtext;
}
-->
</style>
</head>

<body bgcolor=white lang=RU style='tab-interval:35.4pt'>
<?
$page = IntVal($page);
if ($page<=0) $page = 1;
?>
<table height="920" align="center" border="0" cellpadding="0" cellspacing="0">
   <tr valign="top">
      <td colspan="3">
         <!-- Верхний колонтитул height="109" -->
      </td>
   </tr>
   <tr valign="top">
      <td colspan="3">
         <table cellpadding="0" cellspacing="0" border="0" width="595" align="center">
            <tr><td><br><br></td></tr>
            <tr>
               <td width="180"><font class="header">ТОВАРНЫЙ ЧЕК №</font></td>
               <td style="border-bottom : 1px solid Black;" nowrap>
                  <font class="number"><?echo $arOrder["ACCOUNT_NUMBER"];?></font>
                  <!--- <input size="30" style="border:1px;font-size:24px;font-style:italic;" type="text" value="<?echo $page;?>">-->
               </td>
               <td>
               </td>
            </tr>
            <tr>
               <td width="180"><font class="sub_header">ДАТА:</font></td>
               <td style="border-bottom : 1px solid Black;">
                  <input class="date" size="30" style="border:0px solid #000000;" type="text" value="<?echo $arOrder["DATE_INSERT_FORMAT"];?>">
               </td>
               <td>
               </td>
            </tr>
            <tr>
               <td width="180"><font class="sub_header">КОМУ:</font></td>
               <td style="border-bottom : 1px solid Black;">
                  <?if(empty($arParams))
                  {
                     $userName = $arOrderProps["F_NAME"];
                  }
                  else
                  {
                     if(strlen($arParams["BUYER_COMPANY_NAME"]) > 0)
                        $userName = $arParams["BUYER_COMPANY_NAME"];
                     else
                        $userName = $arParams["BUYER_LAST_NAME"]." ".$arParams["BUYER_FIRST_NAME"]." ".$arParams["BUYER_SECOND_NAME"];
                  }?>
                  <input class="user" size="50" style="border:0px solid #000000;" type="text" value="<?=$userName?>   ">
               </td>
               <td>
               </td>
            </tr>
            <tr><td><br></td></tr>
         </table>

         <br>
         <?
         if (count($arBasketIDs)>0)
         {
            ?>
            <table class="blank">
               <tr>
                  <td align="center">№</td>
                  <td align="center">Наименование</td>
                  <td align="center">Количество</td>
                  <td align="center">Цена, руб</td>
                  <td align="center">Cумма, руб</td>
                  <td align="center">код</td>
               </tr>
               <?
               $priceTotal = 0;
               $bUseVat = false;
               $arBasketOrder = array();
               for ($i = 0; $i < count($arBasketIDs); $i++)
               {
                  $arBasketTmp = CSaleBasket::GetByID($arBasketIDs[$i]);

                  if (floatval($arBasketTmp["VAT_RATE"]) > 0 )
                     $bUseVat = true;

                  $priceTotal += $arBasketTmp["PRICE"]*$arBasketTmp["QUANTITY"];

                  $arBasketTmp["PROPS"] = array();
                  if (isset($_GET["PROPS_ENABLE"]) && $_GET["PROPS_ENABLE"] == "Y")
                  {
                     $dbBasketProps = CSaleBasket::GetPropsList(
                           array("SORT" => "ASC", "NAME" => "ASC"),
                           array("BASKET_ID" => $arBasketTmp["ID"]),
                           false,
                           false,
                           array("ID", "BASKET_ID", "NAME", "VALUE", "CODE", "SORT")
                        );
                     while ($arBasketProps = $dbBasketProps->GetNext())
                        $arBasketTmp["PROPS"][$arBasketProps["ID"]] = $arBasketProps;
                  }

                  $arBasketOrder[] = $arBasketTmp;
               }

               //разбрасываем скидку на заказ по товарам
               if (floatval($arOrder["DISCOUNT_VALUE"]) > 0)
               {
                  $arBasketOrder = GetUniformDestribution($arBasketOrder, $arOrder["DISCOUNT_VALUE"], $priceTotal);
               }

               //налоги
               $arTaxList = array();
               $db_tax_list = CSaleOrderTax::GetList(array("APPLY_ORDER"=>"ASC"), Array("ORDER_ID"=>$ORDER_ID));
               $iNds = -1;
               $i = 0;
               while ($ar_tax_list = $db_tax_list->Fetch())
               {
                  $arTaxList[$i] = $ar_tax_list;
                  // определяем, какой из налогов - НДС
                  // НДС должен иметь код NDS, либо необходимо перенести этот шаблон
                  // в каталог пользовательских шаблонов и исправить
                  if ($arTaxList[$i]["CODE"] == "NDS")
                     $iNds = $i;
                  $i++;
               }


               $i = 0;
               $total_sum = 0;
               foreach ($arBasketOrder as $arBasket):
                  $nds_val = 0;
                  $taxRate = 0;

                  if (floatval($arQuantities[$i]) <= 0)
                     $arQuantities[$i] = DoubleVal($arBasket["QUANTITY"]);

                  $b_AMOUNT = DoubleVal($arBasket["PRICE"]);

                  //определяем начальную цену
                  $item_price = $b_AMOUNT;

                  if(DoubleVal($arBasket["VAT_RATE"]) > 0)
                  {
                     $nds_val = ($b_AMOUNT - DoubleVal($b_AMOUNT/(1+$arBasket["VAT_RATE"])));
                     $item_price = $b_AMOUNT - $nds_val;
                     $taxRate = $arBasket["VAT_RATE"]*100;
                  }
                  elseif(!$bUseVat)
                  {
                     $basket_tax = CSaleOrderTax::CountTaxes($b_AMOUNT*$arQuantities[$i], $arTaxList, $arOrder["CURRENCY"]);

                     for ($mi = 0; $mi < count($arTaxList); $i++)
                     {
                        if ($arTaxList[$mi]["IS_IN_PRICE"] == "Y")
                        {
                           $item_price -= $arTaxList[$mi]["TAX_VAL"];
                        }
                        $nds_val += DoubleVal($arTaxList[$mi]["TAX_VAL"]);
                        $taxRate += ($arTaxList[$mi]["VALUE"]);
                     }
                  }
               ?>
               <tr>
                  <td><?echo $i+1;?></td>
                  <td>
                     <?echo htmlspecialcharsbx($arBasket["NAME"]);?>
                     <?
                     if (is_array($arBasket["PROPS"]) && $_GET["PROPS_ENABLE"] == "Y")
                           {
                              foreach($arBasket["PROPS"] as $vv)
                              {
                                 if(strlen($vv["VALUE"]) > 0 && $vv["CODE"] != "CATALOG.XML_ID" && $vv["CODE"] != "PRODUCT.XML_ID")
                                    echo "<div st yle=\"font-size:8pt\">".$vv["NAME"].": ".$vv["VALUE"]."</div>";
                              }
                           }
                     ?>
                  </td>
                  <td align="center"><?echo $arQuantities[$i] ?></td>
                  <td align="right" nowrap><?echo number_format($arBasket["PRICE"], 2, ',', ' ');?></td>
                  <td align="right" nowrap><?echo number_format($arBasket["PRICE"]*$arQuantities[$i], 2, ',', ' ');?></td>
                  <td></td>
               </tr>
               <?

               $total_sum += $arBasket["PRICE"]*$arQuantities[$i];
               $total_nds += $nds_val*$arQuantities[$i];

               $i++;
               endforeach;
               ?>

               <tr>
                  <td align="right" colspan="4">
                     Сумма:
                  </td>
                  <td align="right" nowrap>
                     <?echo number_format($total_sum, 2, ',', ' ');?>
                  </td>
               </tr>

               <?
               $db_tax_list = CSaleOrderTax::GetList(array("APPLY_ORDER"=>"ASC"), Array("ORDER_ID"=>$ORDER_ID));
               while ($ar_tax_list = $db_tax_list->Fetch())
               {
                  ?>
                  <tr>
                     <td align="right" colspan="4">
                        <?
                        if ($ar_tax_list["IS_IN_PRICE"]=="Y")
                        {
                           echo "В том числе ";
                        }
                        echo htmlspecialcharsbx($ar_tax_list["TAX_NAME"]);
                        if ($ar_tax_list["IS_PERCENT"]=="Y")
                        {
                           echo " (".$ar_tax_list["VALUE"]."%)";
                        }
                        ?>:
                     </td>
                     <td align="right" nowrap>
                        <?=number_format($total_nds, 2, ',', ' ')?>
                     </td>
                  </tr>
                  <?
               }
               ?>

               <tr>
                  <td align="right" colspan="4">
                     Итого (без стоимости доставки):
                  </td>
                  <td align="right" nowrap>
                     <?echo number_format($total_sum, 2, ',', ' ');?>
                  </td>
               </tr>
            </table>
            <?
         }
         ?>
         <br>
      </td>
   </tr>
</table>

</body>
</html>

в код где идут строки

Код

<table class="blank">
               <tr>
                  <td align="center">№</td>
                  <td align="center">Наименование</td>
                  <td align="center">Количество</td>
                  <td align="center">Цена, руб</td>
                  <td align="center">Cумма, руб</td>
                  <td align="center">код</td>
               </tr>

я добавил <td align="center">код</td>. В в строках где идет

Код

<tr>
                  <td><?echo $i+1;?></td>
                  <td>
                     <?echo htmlspecialcharsbx($arBasket["NAME"]);?>
                     <?
                     if (is_array($arBasket["PROPS"]) && $_GET["PROPS_ENABLE"] == "Y")
                           {
                              foreach($arBasket["PROPS"] as $vv)
                              {
                                 if(strlen($vv["VALUE"]) > 0 && $vv["CODE"] != "CATALOG.XML_ID" && $vv["CODE"] != "PRODUCT.XML_ID")
                                    echo "<div st yle=\"font-size:8pt\">".$vv["NAME"].": ".$vv["VALUE"]."</div>";
                              }
                           }
                     ?>
                  </td>
                  <td align="center"><?echo $arQuantities[$i] ?></td>
                  <td align="right" nowrap><?echo number_format($arBasket["PRICE"], 2, ',', ' ');?></td>
                  <td align="right" nowrap><?echo number_format($arBasket["PRICE"]*$arQuantities[$i], 2, ',', ' ');?></td>
                  <td></td>

добавил <td></td> где нужно написать вывод артикула товара.

Основываясь на описании http://dev.1c-bitrix.ru/community/forums/forum6/topic68261/ вывод кода товара происходит

Код

$arElement = CIBlockElement::GetList(array(), array('IBLOCK_ID' => 3, 'ID' => $arBasket['PRODUCT_ID']), false, false, array('*', 'PROPERTY_ARTNUMBER'))->GetNext();
echo ",".htmlspecialchars($arElement["ARTNUMBER"]);

но не работает. Подскажите пожалуйста, как вывести его. Или как правильно вставить этот код, чтобы вывести код товара.

Форум

Центр поддержки

Продукты

Управление сайтом

Битрикс24

Интернет-магазин + CRM

Решения

Для интернет-магазинов

Каталог готовых решений

Внедрение

Выбрать партнера

Проверить партнера

Стать партнером

Пользователь 394534 Посетитель Сообщений: 61 Баллов: 4 Регистрация: 15.10.2015	#2 0 08.05.2016 12:20:39 Присоединяюсь к вопросу. И еще как сделать что бы сортировка была именно под коду товара в документе?