С магазина Virturmart автоматически выписывается такой счет на оплату... Мне нужно сюда еще добавить НДС и, соответственно...сумма прописью тоже должна отражать уже сумму с НДС
Красным пометил что надо добавить
Покупатель: {RECIEVER}
№ Товар Кол-во Ед. Цена Сумма
Итого: {TOTAL}
НДС 19%
Всего к оплате с НДС {................}
Всего наименований {PRODUCTS_AMOUNT}, на сумму {................}
{............._PROP}
Вот два исходных файла
Сам счет (Отобразить)
<html xmlns:v="urn:schemas-microsoft-com:vml"
<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns
="urn:schemas-microsoft-comfficeffice"
xmlns:x="urn:schemas-microsoft-comffice:excel"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1251">
<link rel=File-List href="schet.files/filelist.xml">
<link rel=Edit-Time-Data href="schet.files/editdata.mso">
<link rel=OLE-Object-Data href="schet.files/oledata.mso">
<!--[if gte mso 9]><xml>
<o
ocumentProperties>
<o:LastAuthor>Alexander.Krylov</o:LastAuthor>
<o:LastPrinted>2010-02-16T09:43:16Z</o:LastPrinted>
<o:Created>2010-02-16T09:47:58Z</o:Created>
<o:LastSaved>2010-02-16T11:12:40Z</o:LastSaved>
<o:Version>11.5606</o:Version>
</oocumentProperties>
</xml><![endif]-->
<style>
<!--table
{mso-displayed-decimal-separator:"\,";
mso-displayed-thousand-separator:" ";}
@page
{margin:.98in .75in .98in .75in;
mso-header-margin:.51in;
mso-footer-margin:.51in;}
tr
{mso-height-source:auto;}
col
{mso-width-source:auto;}
br
{mso-data-placement:same-cell;}
.style0
{mso-number-format:General;
text-align:left;
vertical-align:bottom;
white-space:nowrap;
mso-rotate:0;
mso-background-source:auto;
mso-pattern:auto;
color:windowtext;
font-size:8.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial, sans-serif;
mso-font-charset:204;
border:none;
mso-protection:locked visible;
mso-style-name:Обычный;
mso-style-id:0;}
td
{mso-style-parent:style0;
padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:8.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial, sans-serif;
mso-font-charset:204;
mso-number-format:General;
text-align:left;
vertical-align:bottom;
border:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:locked visible;
white-space:nowrap;
mso-rotate:0;}
.xl24
{mso-style-parent:style0;
text-align:general;}
.xl25
{mso-style-parent:style0;
font-size:10.0pt;
font-weight:700;
text-align:general;}
.xl26
{mso-style-parent:style0;
text-align:general;
border-top:none;
border-right:none;
border-bottom:1.0pt solid black;
border-left:none;}
.xl27
{mso-style-parent:style0;
font-size:10.0pt;
font-weight:700;
text-align:right;
vertical-align:top;}
.xl28
{mso-style-parent:style0;
text-align:center;
vertical-align:middle;
white-space:normal;}
.xl29
{mso-style-parent:style0;
font-size:10.0pt;
font-weight:700;
text-align:center;
vertical-align:top;}
.xl30
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:top;
border-top:.5pt solid black;
border-right:none;
border-bottom:none;
border-left:.5pt solid black;
white-space:normal;}
.xl31
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:top;
border-top:.5pt solid black;
border-right:none;
border-bottom:none;
border-left:none;
white-space:normal;}
.xl32
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:top;
border-top:.5pt solid black;
border-right:.5pt solid black;
border-bottom:none;
border-left:none;
white-space:normal;}
.xl33
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:top;
border-top:none;
border-right:none;
border-bottom:none;
border-left:.5pt solid black;
white-space:normal;}
.xl34
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:top;
white-space:normal;}
.xl35
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:top;
border-top:none;
border-right:.5pt solid black;
border-bottom:none;
border-left:none;
white-space:normal;}
.xl36
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:middle;
border-top:.5pt solid black;
border-right:none;
border-bottom:.5pt solid black;
border-left:none;}
.xl37
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:middle;
border-top:.5pt solid black;
border-right:none;
border-bottom:.5pt solid black;
border-left:.5pt solid black;}
.xl38
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:middle;
border-top:.5pt solid black;
border-right:.5pt solid black;
border-bottom:.5pt solid black;
border-left:none;}
.xl39
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:middle;
border-top:.5pt solid black;
border-right:none;
border-bottom:none;
border-left:none;}
.xl40
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:middle;
border-top:.5pt solid black;
border-right:none;
border-bottom:none;
border-left:.5pt solid black;}
.xl41
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:middle;
border-top:.5pt solid black;
border-right:.5pt solid black;
border-bottom:none;
border-left:none;}
.xl42
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:top;
border-top:.5pt solid black;
border-right:none;
border-bottom:none;
border-left:.5pt solid black;}
.xl43
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:top;
border-top:.5pt solid black;
border-right:none;
border-bottom:none;
border-left:none;}
.xl44
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:top;
border-top:.5pt solid black;
border-right:.5pt solid black;
border-bottom:none;
border-left:none;}
.xl45
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:top;
border-top:none;
border-right:none;
border-bottom:.5pt solid black;
border-left:.5pt solid black;}
.xl46
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:top;
border-top:none;
border-right:none;
border-bottom:.5pt solid black;
border-left:none;}
.xl47
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:top;
border-top:none;
border-right:.5pt solid black;
border-bottom:.5pt solid black;
border-left:none;}
.xl48
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:top;
border-top:none;
border-right:none;
border-bottom:none;
border-left:.5pt solid black;}
.xl49
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:top;}
.xl50
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:top;
border-top:none;
border-right:.5pt solid black;
border-bottom:none;
border-left:none;}
.xl51
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:top;
border-top:none;
border-right:none;
border-bottom:.5pt solid black;
border-left:.5pt solid black;}
.xl52
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:top;
border-top:none;
border-right:none;
border-bottom:.5pt solid black;
border-left:none;}
.xl53
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:top;
border-top:none;
border-right:.5pt solid black;
border-bottom:.5pt solid black;
border-left:none;}
.xl54
{mso-style-parent:style0;
text-align:general;
border-top:none;
border-right:none;
border-bottom:.5pt solid black;
border-left:.5pt solid black;}
.xl55
{mso-style-parent:style0;
text-align:general;
border-top:none;
border-right:none;
border-bottom:.5pt solid black;
border-left:none;}
.xl56
{mso-style-parent:style0;
text-align:general;
border-top:none;
border-right:.5pt solid black;
border-bottom:.5pt solid black;
border-left:none;}
.xl57
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:middle;
border-top:.5pt solid black;
border-right:none;
border-bottom:.5pt solid black;
border-left:.5pt solid black;}
.xl58
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:middle;
border-top:.5pt solid black;
border-right:none;
border-bottom:.5pt solid black;
border-left:none;}
.xl59
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:middle;
border-top:.5pt solid black;
border-right:.5pt solid black;
border-bottom:.5pt solid black;
border-left:none;}
.xl60
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:top;
border-top:none;
border-right:none;
border-bottom:none;
border-left:.5pt solid black;}
.xl61
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:top;}
.xl62
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:top;
border-top:none;
border-right:.5pt solid black;
border-bottom:none;
border-left:none;}
.xl63
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:top;
border-top:.5pt solid black;
border-right:none;
border-bottom:none;
border-left:.5pt solid black;}
.xl64
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:top;
border-top:.5pt solid black;
border-right:none;
border-bottom:none;
border-left:none;}
.xl65
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:top;
border-top:.5pt solid black;
border-right:.5pt solid black;
border-bottom:none;
border-left:none;}
.xl66
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:top;
border-top:.5pt solid black;
border-right:none;
border-bottom:none;
border-left:.5pt solid black;
white-space:normal;}
.xl67
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:top;
border-top:.5pt solid black;
border-right:none;
border-bottom:none;
border-left:none;
white-space:normal;}
.xl68
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:top;
border-top:.5pt solid black;
border-right:.5pt solid black;
border-bottom:none;
border-left:none;
white-space:normal;}
.xl69
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:top;
border-top:none;
border-right:none;
border-bottom:none;
border-left:.5pt solid black;
white-space:normal;}
.xl70
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:top;
white-space:normal;}
.xl71
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:top;
border-top:none;
border-right:.5pt solid black;
border-bottom:none;
border-left:none;
white-space:normal;}
.xl72
{mso-style-parent:style0;
vertical-align:middle;
border-top:none;
border-right:none;
border-bottom:.5pt solid black;
border-left:.5pt solid black;}
.xl73
{mso-style-parent:style0;
vertical-align:middle;
border-top:none;
border-right:none;
border-bottom:.5pt solid black;
border-left:none;}
.xl74
{mso-style-parent:style0;
vertical-align:middle;
border-top:none;
border-right:.5pt solid black;
border-bottom:.5pt solid black;
border-left:none;}
.xl75
{mso-style-parent:style0;
font-size:14.0pt;
font-weight:700;
text-align:general;
vertical-align:middle;}
.xl76
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:middle;}
.xl77
{mso-style-parent:style0;
font-size:10.0pt;
font-weight:700;
text-align:general;
vertical-align:top;
white-space:normal;}
.xl78
{mso-style-parent:style0;
font-size:10.0pt;
font-weight:700;
text-align:center;
vertical-align:middle;
border-top:1.0pt solid black;
border-right:none;
border-bottom:none;
border-left:1.0pt solid black;}
.xl79
{mso-style-parent:style0;
font-size:10.0pt;
font-weight:700;
text-align:center;
vertical-align:middle;
border-top:1.0pt solid black;
border-right:.5pt solid black;
border-bottom:none;
border-left:none;}
.xl80
{mso-style-parent:style0;
font-size:10.0pt;
font-weight:700;
text-align:center;
vertical-align:middle;
border-top:none;
border-right:none;
border-bottom:.5pt solid black;
border-left:1.0pt solid black;}
.xl81
{mso-style-parent:style0;
font-size:10.0pt;
font-weight:700;
text-align:center;
vertical-align:middle;
border-top:none;
border-right:.5pt solid black;
border-bottom:.5pt solid black;
border-left:none;}
.xl82
{mso-style-parent:style0;
font-size:10.0pt;
font-weight:700;
text-align:center;
vertical-align:middle;
border-top:1.0pt solid black;
border-right:none;
border-bottom:none;
border-left:.5pt solid black;}
.xl83
{mso-style-parent:style0;
font-size:10.0pt;
font-weight:700;
text-align:center;
vertical-align:middle;
border-top:1.0pt solid black;
border-right:none;
border-bottom:none;
border-left:none;}
.xl84
{mso-style-parent:style0;
font-size:10.0pt;
font-weight:700;
text-align:center;
vertical-align:middle;
border-top:none;
border-right:none;
border-bottom:.5pt solid black;
border-left:.5pt solid black;}
.xl85
{mso-style-parent:style0;
font-size:10.0pt;
font-weight:700;
text-align:center;
vertical-align:middle;
border-top:none;
border-right:none;
border-bottom:.5pt solid black;
border-left:none;}
.xl86
{mso-style-parent:style0;
font-size:10.0pt;
font-weight:700;
text-align:center;
vertical-align:middle;
border-top:1.0pt solid black;
border-right:1.0pt solid black;
border-bottom:none;
border-left:none;}
.xl87
{mso-style-parent:style0;
font-size:10.0pt;
font-weight:700;
text-align:center;
vertical-align:middle;
border-top:none;
border-right:1.0pt solid black;
border-bottom:.5pt solid black;
border-left:none;}
.xl88
{mso-style-parent:style0;
text-align:center;
vertical-align:top;
border-top:.5pt solid black;
border-right:none;
border-bottom:1.0pt solid black;
border-left:1.0pt solid black;}
.xl89
{mso-style-parent:style0;
text-align:center;
vertical-align:top;
border-top:.5pt solid black;
border-right:none;
border-bottom:1.0pt solid black;
border-left:none;}
.xl90
{mso-style-parent:style0;
text-align:center;
vertical-align:top;
border-top:.5pt solid black;
border-right:1.0pt solid black;
border-bottom:1.0pt solid black;
border-left:none;}
.xl91
{mso-style-parent:style0;
font-size:10.0pt;
font-weight:700;
mso-number-format:Standard;
text-align:right;
vertical-align:top;}
.xl92
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;}
.xl93
{mso-style-parent:style0;
text-align:general;
white-space:normal;}
-->
</style>
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>Sheet1</x:Name>
<x:WorksheetOptions>
<xefaultRowHeight>225</xefaultRowHeight>
<x:Print>
<x:ValidPrinterInfo/>
<x:PaperSizeIndex>9</x:PaperSizeIndex>
<x:HorizontalResolution>300</x:HorizontalResolution>
<x:VerticalResolution>300</x:VerticalResolution>
</x:Print>
<x:Selected/>
<x:Panes>
<x:Pane>
<x:Number>3</x:Number>
<x:ActiveRow>42</x:ActiveRow>
<x:ActiveCol>28</x:ActiveCol>
</x:Pane>
</x:Panes>
<x:ProtectContents>False</x:ProtectContents>
<x:ProtectObjects>False</x:ProtectObjects>
<x:ProtectScenarios>False</x:ProtectScenarios>
<x:EnableSelection>NoSelection</x:EnableSelection>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
<x:HideWorkbookTabs/>
<x:WindowHeight>8190</x:WindowHeight>
<x:WindowWidth>16380</x:WindowWidth>
<x:WindowTopX>0</x:WindowTopX>
<x:WindowTopY>0</x:WindowTopY>
<x:TabRatio>0</x:TabRatio>
<x:ProtectStructure>False</x:ProtectStructure>
<x:ProtectWindows>False</x:ProtectWindows>
</x:ExcelWorkbook>
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1025" fillcolor="none [9]">
<v:fill color="none [9]"/>
</o:shapedefaults></xml><![endif]-->
</head>
<body link=blue vlink=purple class=xl24>
<table x:str border=0 cellpadding=0 cellspacing=0 width=657 style='border-collapse:
collapse;table-layout:fixed;width:501pt'>
<col class=xl24 width=10 style='mso-width-source:userset;mso-width-alt:426;
width:8pt'>
<col class=xl24 width=21 span=27 style='mso-width-source:userset;mso-width-alt:
896;width:16pt'>
<col class=xl24 width=13 style='mso-width-source:userset;mso-width-alt:554;
width:10pt'>
<col class=xl24 width=21 style='mso-width-source:userset;mso-width-alt:896;
width:16pt'>
<col class=xl24 width=38 style='mso-width-source:userset;mso-width-alt:1621;
width:29pt'>
<col class=xl24 width=0 style='display:none;mso-width-source:userset;
mso-width-alt:3968'>
<col class=xl24 width=8 style='mso-width-source:userset;mso-width-alt:341;
width:6pt'>
<col class=xl24 width=21 span=223 style='mso-width-source:userset;mso-width-alt:
896;width:16pt'>
<tr height=15 style='mso-height-source:userset;height:11.25pt'>
<td height=15 class=xl24 width=10 style='height:11.25pt;width:8pt'></td>
<td colspan=32 rowspan=3 class=xl28 width=647 style='width:493pt'
x:str="Внимание! Оплата данного счета означает согласие с условиями поставки товара. Уведомление об оплате
обязательно, в противном случае не гарантируется наличие товара на складе. Товар отпускается по факту
прихода денег на р/с Поставщика, самовывозом, при ">Внимание!
Оплата данного счета означает согласие с условиями поставки товара.
Уведомление об оплате <br>
<span style='mso-spacerun:yes'>В </span>обязательно, в противном случае не
гарантируется наличие товара на складе. Товар отпускается по факту<br>
<span style='mso-spacerun:yes'>В </span>прихода денег на р/с Поставщика,
самовывозом, при<span style='mso-spacerun:yes'>В </span></td>
</tr>
<tr height=15 style='mso-height-source:userset;height:11.25pt'>
<td height=15 class=xl24 style='height:11.25pt'></td>
</tr>
<tr height=15 style='height:11.25pt'>
<td height=15 class=xl24 style='height:11.25pt'></td>
</tr>
<tr height=15 style='height:11.25pt'>
<td height=15 colspan=33 class=xl24 style='height:11.25pt;mso-ignore:colspan'></td>
</tr>
<tr height=18 style='mso-height-source:userset;height:13.5pt'>
<td height=18 class=xl24 style='height:13.5pt'></td>
<td colspan=32 class=xl29>Образец заполнения платежного поручения</td>
</tr>
<tr height=16 style='mso-height-source:userset;height:12.0pt'>
<td height=16 colspan=33 class=xl24 style='height:12.0pt;mso-ignore:colspan'></td>
</tr>
<tr height=23 style='mso-height-source:userset;height:17.25pt'>
<td height=23 class=xl24 style='height:17.25pt'></td>
<td colspan=18 rowspan=2 class=xl30 width=378 style='border-right:.5pt solid black;
width:288pt'>ОАО "НБД-Банк", г.Нижний Новгород"</td>
<td colspan=3 class=xl37 style='border-right:.5pt solid black;border-left:
none'>БИК</td>
<td colspan=11 class=xl40 style='border-right:.5pt solid black;border-left:
none'>042202705</td>
</tr>
<tr height=20 style='mso-height-source:userset;height:15.0pt'>
<td height=20 class=xl24 style='height:15.0pt'></td>
<td colspan=3 rowspan=2 class=xl42 style='border-right:.5pt solid black;
border-bottom:.5pt solid black'>кор. счёт</td>
<td colspan=11 rowspan=2 class=xl48 style='border-right:.5pt solid black;
border-bottom:.5pt solid black'>30101810000000000000</td>
</tr>
<tr height=12 style='mso-height-source:userset;height:9.0pt'>
<td height=12 class=xl24 style='height:9.0pt'></td>
<td colspan=18 class=xl54 style='border-right:.5pt solid black'>Банк
получателя</td>
</tr>
<tr height=17 style='mso-height-source:userset;height:12.75pt'>
<td height=17 class=xl24 style='height:12.75pt'></td>
<td colspan=9 class=xl57 style='border-right:.5pt solid black'>ИНН
5258000000</td>
<td colspan=9 class=xl57 style='border-right:.5pt solid black;border-left:
none' x:str="КПП ">КПП 520000000<span style='mso-spacerun:yes'>В </span></td>
<td colspan=3 rowspan=4 class=xl42 style='border-right:.5pt solid black;
border-bottom:.5pt solid black'>расч. счёт</td>
<td colspan=11 rowspan=4 class=xl63 style='border-right:.5pt solid black;
border-bottom:.5pt solid black'>40702810101020000000</td>
</tr>
<tr height=16 style='mso-height-source:userset;height:12.0pt'>
<td height=16 class=xl24 style='height:12.0pt'></td>
<td colspan=18 rowspan=2 class=xl66 width=378 style='border-right:.5pt solid black;
width:288pt'><span style='mso-spacerun:yes'</span>"ООО "Лог-НН" г. Н.Новгород</td>
</tr>
<tr height=18 style='mso-height-source:userset;height:13.5pt'>
<td height=18 class=xl24 style='height:13.5pt'></td>
</tr>
<tr height=12 style='mso-height-source:userset;height:9.0pt'>
<td height=12 class=xl24 style='height:9.0pt'></td>
<td colspan=18 class=xl72 style='border-right:.5pt solid black'>Получатель</td>
</tr>
<tr height=15 style='height:11.25pt'>
<td height=15 colspan=33 class=xl24 style='height:11.25pt;mso-ignore:colspan'></td>
</tr>
<tr height=15 style='height:11.25pt'>
<td height=15 class=xl24 style='height:11.25pt'></td>
<td colspan=32 rowspan=2 class=xl75>Счет № {ORDER_NUM} РѕС‚ {DATE}</td>
</tr>
<tr height=15 style='height:11.25pt'>
<td height=15 class=xl24 style='height:11.25pt'></td>
</tr>
<tr height=9 style='mso-height-source:userset;height:6.95pt'>
<td height=9 class=xl24 style='height:6.95pt'></td>
<td colspan=32 class=xl26> </td>
</tr>
<tr height=9 style='mso-height-source:userset;height:6.95pt'>
<td height=9 colspan=33 class=xl24 style='height:6.95pt;mso-ignore:colspan'></td>
</tr>
<tr height=40 style='mso-height-source:userset;height:30.0pt'>
<td height=40 class=xl24 style='height:30.0pt'></td>
<td colspan=4 class=xl76>Поставщик:</td>
<td colspan=28 class=xl77 width=563 style='width:429pt'>ИНН 503211638666
КПП<span style='mso-spacerun:yes' </span> ООО "Лог-НН" г. Н.Новгород, 603000, г. Нижний новгород, ул. Московская, дом 12, тел. (831) 200-00-90; 400-00-00</td>
</tr>
<tr height=18 style='mso-height-source:userset;height:13.5pt'>
<td height=18 colspan=33 class=xl24 style='height:13.5pt;mso-ignore:colspan'></td>
</tr>
<tr height=22 style='mso-height-source:userset;height:16.5pt'>
<td height=22 class=xl24 style='height:16.5pt'></td>
<td colspan=4 class=xl76>Покупатель:</td>
<td colspan=28 class=xl77 width=563 style='width:429pt'>{RECIEVER}</td>
</tr>
<tr height=9 style='mso-height-source:userset;height:6.95pt'>
<td height=9 colspan=33 class=xl24 style='height:6.95pt;mso-ignore:colspan'></td>
</tr>
<tr height=15 style='height:11.25pt'>
<td height=15 class=xl24 style='height:11.25pt'></td>
<td colspan=2 rowspan=2 class=xl78 style='border-right:.5pt solid black;
border-bottom:.5pt solid black'>№</td>
<td colspan=17 rowspan=2 class=xl82 style='border-right:.5pt solid black;
border-bottom:.5pt solid black'>Товар</td>
<td colspan=3 rowspan=2 class=xl82 style='border-right:.5pt solid black;
border-bottom:.5pt solid black'>Кол-во</td>
<td colspan=2 rowspan=2 class=xl82 style='border-right:.5pt solid black;
border-bottom:.5pt solid black'>Ед.</td>
<td colspan=4 rowspan=2 class=xl82 style='border-right:.5pt solid black;
border-bottom:.5pt solid black'>Цена</td>
<td colspan=4 rowspan=2 class=xl82 style='border-right:1.0pt solid black;
border-bottom:.5pt solid black'>Сумма</td>
</tr>
<tr height=20 style='mso-height-source:userset;height:15.0pt'>
<td height=20 class=xl24 style='height:15.0pt'></td>
</tr>
{PRODUCTS}
<tr height=9 style='mso-height-source:userset;height:6.95pt'>
<td height=9 colspan=33 class=xl24 style='height:6.95pt;mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=23 class=xl24 style='height:12.75pt;mso-ignore:colspan'></td>
<td class=xl27 colspan=4>Итого:</td>
<td colspan=6 class=xl91>{TOTAL}</td>
</tr>
<tr height=9 style='mso-height-source:userset;height:6.95pt'>
<td height=9 colspan=33 class=xl24 style='height:6.95pt;mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl24 style='height:12.75pt'></td>
<td colspan=32 class=xl92>Всего наименований {PRODUCTS_AMOUNT}, на сумму
{TOTAL}</td>
</tr>
<tr height=16 style='mso-height-source:userset;height:12.0pt'>
<td height=16 class=xl24 style='height:12.0pt'></td>
<td colspan=31 class=xl77 width=639 style='width:487pt'>{TOTAL_PROP}</td>
<td class=xl24></td>
</tr>
<tr height=9 style='mso-height-source:userset;height:6.95pt'>
<td height=9 class=xl24 style='height:6.95pt'></td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
</tr>
<tr height=15 style='height:11.25pt'>
<td height=15 colspan=33 class=xl24 style='height:11.25pt;mso-ignore:colspan'></td>
</tr>
<tr height=31 style='mso-height-source:userset;height:23.25pt'>
<td height=31 class=xl24 style='height:23.25pt'></td>
<td class=xl25 colspan=5 style='mso-ignore:colspan'>Руководитель</td>
<td colspan=4 class=xl24 style='mso-ignore:colspan'></td>
<td colspan=6 class=xl93 width=126 style='width:96pt'>(Соловей Леонид Иванович)</td>
<td class=xl24></td>
<td class=xl25 colspan=4 style='mso-ignore:colspan'>Бухгалтер</td>
<td colspan=5 class=xl24 style='mso-ignore:colspan'></td>
<td colspan=6 class=xl93 width=114 style='width:87pt'>(Петрова Анна Владимировна)</td>
<td class=xl24></td>
</tr>
<![if supportMisalignedColumns]>
<tr height=0 style='display:none'>
<td width=10 style='width:8pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=13 style='width:10pt'></td>
<td width=21 style='width:16pt'></td>
<td width=38 style='width:29pt'></td>
<td width=0></td>
<td width=8 style='width:6pt'></td>
</tr>
<![endif]>
</table>
</body>
</html>
<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns
="urn:schemas-microsoft-comfficeffice"xmlns:x="urn:schemas-microsoft-com
ffice:excel"xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1251">
<link rel=File-List href="schet.files/filelist.xml">
<link rel=Edit-Time-Data href="schet.files/editdata.mso">
<link rel=OLE-Object-Data href="schet.files/oledata.mso">
<!--[if gte mso 9]><xml>
<o
ocumentProperties><o:LastAuthor>Alexander.Krylov</o:LastAuthor>
<o:LastPrinted>2010-02-16T09:43:16Z</o:LastPrinted>
<o:Created>2010-02-16T09:47:58Z</o:Created>
<o:LastSaved>2010-02-16T11:12:40Z</o:LastSaved>
<o:Version>11.5606</o:Version>
</o
ocumentProperties></xml><![endif]-->
<style>
<!--table
{mso-displayed-decimal-separator:"\,";
mso-displayed-thousand-separator:" ";}
@page
{margin:.98in .75in .98in .75in;
mso-header-margin:.51in;
mso-footer-margin:.51in;}
tr
{mso-height-source:auto;}
col
{mso-width-source:auto;}
br
{mso-data-placement:same-cell;}
.style0
{mso-number-format:General;
text-align:left;
vertical-align:bottom;
white-space:nowrap;
mso-rotate:0;
mso-background-source:auto;
mso-pattern:auto;
color:windowtext;
font-size:8.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial, sans-serif;
mso-font-charset:204;
border:none;
mso-protection:locked visible;
mso-style-name:Обычный;
mso-style-id:0;}
td
{mso-style-parent:style0;
padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:8.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial, sans-serif;
mso-font-charset:204;
mso-number-format:General;
text-align:left;
vertical-align:bottom;
border:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:locked visible;
white-space:nowrap;
mso-rotate:0;}
.xl24
{mso-style-parent:style0;
text-align:general;}
.xl25
{mso-style-parent:style0;
font-size:10.0pt;
font-weight:700;
text-align:general;}
.xl26
{mso-style-parent:style0;
text-align:general;
border-top:none;
border-right:none;
border-bottom:1.0pt solid black;
border-left:none;}
.xl27
{mso-style-parent:style0;
font-size:10.0pt;
font-weight:700;
text-align:right;
vertical-align:top;}
.xl28
{mso-style-parent:style0;
text-align:center;
vertical-align:middle;
white-space:normal;}
.xl29
{mso-style-parent:style0;
font-size:10.0pt;
font-weight:700;
text-align:center;
vertical-align:top;}
.xl30
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:top;
border-top:.5pt solid black;
border-right:none;
border-bottom:none;
border-left:.5pt solid black;
white-space:normal;}
.xl31
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:top;
border-top:.5pt solid black;
border-right:none;
border-bottom:none;
border-left:none;
white-space:normal;}
.xl32
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:top;
border-top:.5pt solid black;
border-right:.5pt solid black;
border-bottom:none;
border-left:none;
white-space:normal;}
.xl33
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:top;
border-top:none;
border-right:none;
border-bottom:none;
border-left:.5pt solid black;
white-space:normal;}
.xl34
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:top;
white-space:normal;}
.xl35
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:top;
border-top:none;
border-right:.5pt solid black;
border-bottom:none;
border-left:none;
white-space:normal;}
.xl36
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:middle;
border-top:.5pt solid black;
border-right:none;
border-bottom:.5pt solid black;
border-left:none;}
.xl37
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:middle;
border-top:.5pt solid black;
border-right:none;
border-bottom:.5pt solid black;
border-left:.5pt solid black;}
.xl38
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:middle;
border-top:.5pt solid black;
border-right:.5pt solid black;
border-bottom:.5pt solid black;
border-left:none;}
.xl39
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:middle;
border-top:.5pt solid black;
border-right:none;
border-bottom:none;
border-left:none;}
.xl40
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:middle;
border-top:.5pt solid black;
border-right:none;
border-bottom:none;
border-left:.5pt solid black;}
.xl41
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:middle;
border-top:.5pt solid black;
border-right:.5pt solid black;
border-bottom:none;
border-left:none;}
.xl42
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:top;
border-top:.5pt solid black;
border-right:none;
border-bottom:none;
border-left:.5pt solid black;}
.xl43
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:top;
border-top:.5pt solid black;
border-right:none;
border-bottom:none;
border-left:none;}
.xl44
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:top;
border-top:.5pt solid black;
border-right:.5pt solid black;
border-bottom:none;
border-left:none;}
.xl45
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:top;
border-top:none;
border-right:none;
border-bottom:.5pt solid black;
border-left:.5pt solid black;}
.xl46
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:top;
border-top:none;
border-right:none;
border-bottom:.5pt solid black;
border-left:none;}
.xl47
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:top;
border-top:none;
border-right:.5pt solid black;
border-bottom:.5pt solid black;
border-left:none;}
.xl48
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:top;
border-top:none;
border-right:none;
border-bottom:none;
border-left:.5pt solid black;}
.xl49
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:top;}
.xl50
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:top;
border-top:none;
border-right:.5pt solid black;
border-bottom:none;
border-left:none;}
.xl51
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:top;
border-top:none;
border-right:none;
border-bottom:.5pt solid black;
border-left:.5pt solid black;}
.xl52
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:top;
border-top:none;
border-right:none;
border-bottom:.5pt solid black;
border-left:none;}
.xl53
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:top;
border-top:none;
border-right:.5pt solid black;
border-bottom:.5pt solid black;
border-left:none;}
.xl54
{mso-style-parent:style0;
text-align:general;
border-top:none;
border-right:none;
border-bottom:.5pt solid black;
border-left:.5pt solid black;}
.xl55
{mso-style-parent:style0;
text-align:general;
border-top:none;
border-right:none;
border-bottom:.5pt solid black;
border-left:none;}
.xl56
{mso-style-parent:style0;
text-align:general;
border-top:none;
border-right:.5pt solid black;
border-bottom:.5pt solid black;
border-left:none;}
.xl57
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:middle;
border-top:.5pt solid black;
border-right:none;
border-bottom:.5pt solid black;
border-left:.5pt solid black;}
.xl58
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:middle;
border-top:.5pt solid black;
border-right:none;
border-bottom:.5pt solid black;
border-left:none;}
.xl59
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:middle;
border-top:.5pt solid black;
border-right:.5pt solid black;
border-bottom:.5pt solid black;
border-left:none;}
.xl60
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:top;
border-top:none;
border-right:none;
border-bottom:none;
border-left:.5pt solid black;}
.xl61
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:top;}
.xl62
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:top;
border-top:none;
border-right:.5pt solid black;
border-bottom:none;
border-left:none;}
.xl63
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:top;
border-top:.5pt solid black;
border-right:none;
border-bottom:none;
border-left:.5pt solid black;}
.xl64
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:top;
border-top:.5pt solid black;
border-right:none;
border-bottom:none;
border-left:none;}
.xl65
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:top;
border-top:.5pt solid black;
border-right:.5pt solid black;
border-bottom:none;
border-left:none;}
.xl66
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:top;
border-top:.5pt solid black;
border-right:none;
border-bottom:none;
border-left:.5pt solid black;
white-space:normal;}
.xl67
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:top;
border-top:.5pt solid black;
border-right:none;
border-bottom:none;
border-left:none;
white-space:normal;}
.xl68
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:top;
border-top:.5pt solid black;
border-right:.5pt solid black;
border-bottom:none;
border-left:none;
white-space:normal;}
.xl69
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:top;
border-top:none;
border-right:none;
border-bottom:none;
border-left:.5pt solid black;
white-space:normal;}
.xl70
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:top;
white-space:normal;}
.xl71
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:top;
border-top:none;
border-right:.5pt solid black;
border-bottom:none;
border-left:none;
white-space:normal;}
.xl72
{mso-style-parent:style0;
vertical-align:middle;
border-top:none;
border-right:none;
border-bottom:.5pt solid black;
border-left:.5pt solid black;}
.xl73
{mso-style-parent:style0;
vertical-align:middle;
border-top:none;
border-right:none;
border-bottom:.5pt solid black;
border-left:none;}
.xl74
{mso-style-parent:style0;
vertical-align:middle;
border-top:none;
border-right:.5pt solid black;
border-bottom:.5pt solid black;
border-left:none;}
.xl75
{mso-style-parent:style0;
font-size:14.0pt;
font-weight:700;
text-align:general;
vertical-align:middle;}
.xl76
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;
vertical-align:middle;}
.xl77
{mso-style-parent:style0;
font-size:10.0pt;
font-weight:700;
text-align:general;
vertical-align:top;
white-space:normal;}
.xl78
{mso-style-parent:style0;
font-size:10.0pt;
font-weight:700;
text-align:center;
vertical-align:middle;
border-top:1.0pt solid black;
border-right:none;
border-bottom:none;
border-left:1.0pt solid black;}
.xl79
{mso-style-parent:style0;
font-size:10.0pt;
font-weight:700;
text-align:center;
vertical-align:middle;
border-top:1.0pt solid black;
border-right:.5pt solid black;
border-bottom:none;
border-left:none;}
.xl80
{mso-style-parent:style0;
font-size:10.0pt;
font-weight:700;
text-align:center;
vertical-align:middle;
border-top:none;
border-right:none;
border-bottom:.5pt solid black;
border-left:1.0pt solid black;}
.xl81
{mso-style-parent:style0;
font-size:10.0pt;
font-weight:700;
text-align:center;
vertical-align:middle;
border-top:none;
border-right:.5pt solid black;
border-bottom:.5pt solid black;
border-left:none;}
.xl82
{mso-style-parent:style0;
font-size:10.0pt;
font-weight:700;
text-align:center;
vertical-align:middle;
border-top:1.0pt solid black;
border-right:none;
border-bottom:none;
border-left:.5pt solid black;}
.xl83
{mso-style-parent:style0;
font-size:10.0pt;
font-weight:700;
text-align:center;
vertical-align:middle;
border-top:1.0pt solid black;
border-right:none;
border-bottom:none;
border-left:none;}
.xl84
{mso-style-parent:style0;
font-size:10.0pt;
font-weight:700;
text-align:center;
vertical-align:middle;
border-top:none;
border-right:none;
border-bottom:.5pt solid black;
border-left:.5pt solid black;}
.xl85
{mso-style-parent:style0;
font-size:10.0pt;
font-weight:700;
text-align:center;
vertical-align:middle;
border-top:none;
border-right:none;
border-bottom:.5pt solid black;
border-left:none;}
.xl86
{mso-style-parent:style0;
font-size:10.0pt;
font-weight:700;
text-align:center;
vertical-align:middle;
border-top:1.0pt solid black;
border-right:1.0pt solid black;
border-bottom:none;
border-left:none;}
.xl87
{mso-style-parent:style0;
font-size:10.0pt;
font-weight:700;
text-align:center;
vertical-align:middle;
border-top:none;
border-right:1.0pt solid black;
border-bottom:.5pt solid black;
border-left:none;}
.xl88
{mso-style-parent:style0;
text-align:center;
vertical-align:top;
border-top:.5pt solid black;
border-right:none;
border-bottom:1.0pt solid black;
border-left:1.0pt solid black;}
.xl89
{mso-style-parent:style0;
text-align:center;
vertical-align:top;
border-top:.5pt solid black;
border-right:none;
border-bottom:1.0pt solid black;
border-left:none;}
.xl90
{mso-style-parent:style0;
text-align:center;
vertical-align:top;
border-top:.5pt solid black;
border-right:1.0pt solid black;
border-bottom:1.0pt solid black;
border-left:none;}
.xl91
{mso-style-parent:style0;
font-size:10.0pt;
font-weight:700;
mso-number-format:Standard;
text-align:right;
vertical-align:top;}
.xl92
{mso-style-parent:style0;
font-size:10.0pt;
text-align:general;}
.xl93
{mso-style-parent:style0;
text-align:general;
white-space:normal;}
-->
</style>
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>Sheet1</x:Name>
<x:WorksheetOptions>
<x
efaultRowHeight>225</xefaultRowHeight><x:Print>
<x:ValidPrinterInfo/>
<x:PaperSizeIndex>9</x:PaperSizeIndex>
<x:HorizontalResolution>300</x:HorizontalResolution>
<x:VerticalResolution>300</x:VerticalResolution>
</x:Print>
<x:Selected/>
<x:Panes>
<x:Pane>
<x:Number>3</x:Number>
<x:ActiveRow>42</x:ActiveRow>
<x:ActiveCol>28</x:ActiveCol>
</x:Pane>
</x:Panes>
<x:ProtectContents>False</x:ProtectContents>
<x:ProtectObjects>False</x:ProtectObjects>
<x:ProtectScenarios>False</x:ProtectScenarios>
<x:EnableSelection>NoSelection</x:EnableSelection>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
<x:HideWorkbookTabs/>
<x:WindowHeight>8190</x:WindowHeight>
<x:WindowWidth>16380</x:WindowWidth>
<x:WindowTopX>0</x:WindowTopX>
<x:WindowTopY>0</x:WindowTopY>
<x:TabRatio>0</x:TabRatio>
<x:ProtectStructure>False</x:ProtectStructure>
<x:ProtectWindows>False</x:ProtectWindows>
</x:ExcelWorkbook>
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1025" fillcolor="none [9]">
<v:fill color="none [9]"/>
</o:shapedefaults></xml><![endif]-->
</head>
<body link=blue vlink=purple class=xl24>
<table x:str border=0 cellpadding=0 cellspacing=0 width=657 style='border-collapse:
collapse;table-layout:fixed;width:501pt'>
<col class=xl24 width=10 style='mso-width-source:userset;mso-width-alt:426;
width:8pt'>
<col class=xl24 width=21 span=27 style='mso-width-source:userset;mso-width-alt:
896;width:16pt'>
<col class=xl24 width=13 style='mso-width-source:userset;mso-width-alt:554;
width:10pt'>
<col class=xl24 width=21 style='mso-width-source:userset;mso-width-alt:896;
width:16pt'>
<col class=xl24 width=38 style='mso-width-source:userset;mso-width-alt:1621;
width:29pt'>
<col class=xl24 width=0 style='display:none;mso-width-source:userset;
mso-width-alt:3968'>
<col class=xl24 width=8 style='mso-width-source:userset;mso-width-alt:341;
width:6pt'>
<col class=xl24 width=21 span=223 style='mso-width-source:userset;mso-width-alt:
896;width:16pt'>
<tr height=15 style='mso-height-source:userset;height:11.25pt'>
<td height=15 class=xl24 width=10 style='height:11.25pt;width:8pt'></td>
<td colspan=32 rowspan=3 class=xl28 width=647 style='width:493pt'
x:str="Внимание! Оплата данного счета означает согласие с условиями поставки товара. Уведомление об оплате
обязательно, в противном случае не гарантируется наличие товара на складе. Товар отпускается по факту
прихода денег на р/с Поставщика, самовывозом, при ">Внимание!
Оплата данного счета означает согласие с условиями поставки товара.
Уведомление об оплате <br>
<span style='mso-spacerun:yes'>В </span>обязательно, в противном случае не
гарантируется наличие товара на складе. Товар отпускается по факту<br>
<span style='mso-spacerun:yes'>В </span>прихода денег на р/с Поставщика,
самовывозом, при<span style='mso-spacerun:yes'>В </span></td>
</tr>
<tr height=15 style='mso-height-source:userset;height:11.25pt'>
<td height=15 class=xl24 style='height:11.25pt'></td>
</tr>
<tr height=15 style='height:11.25pt'>
<td height=15 class=xl24 style='height:11.25pt'></td>
</tr>
<tr height=15 style='height:11.25pt'>
<td height=15 colspan=33 class=xl24 style='height:11.25pt;mso-ignore:colspan'></td>
</tr>
<tr height=18 style='mso-height-source:userset;height:13.5pt'>
<td height=18 class=xl24 style='height:13.5pt'></td>
<td colspan=32 class=xl29>Образец заполнения платежного поручения</td>
</tr>
<tr height=16 style='mso-height-source:userset;height:12.0pt'>
<td height=16 colspan=33 class=xl24 style='height:12.0pt;mso-ignore:colspan'></td>
</tr>
<tr height=23 style='mso-height-source:userset;height:17.25pt'>
<td height=23 class=xl24 style='height:17.25pt'></td>
<td colspan=18 rowspan=2 class=xl30 width=378 style='border-right:.5pt solid black;
width:288pt'>ОАО "НБД-Банк", г.Нижний Новгород"</td>
<td colspan=3 class=xl37 style='border-right:.5pt solid black;border-left:
none'>БИК</td>
<td colspan=11 class=xl40 style='border-right:.5pt solid black;border-left:
none'>042202705</td>
</tr>
<tr height=20 style='mso-height-source:userset;height:15.0pt'>
<td height=20 class=xl24 style='height:15.0pt'></td>
<td colspan=3 rowspan=2 class=xl42 style='border-right:.5pt solid black;
border-bottom:.5pt solid black'>кор. счёт</td>
<td colspan=11 rowspan=2 class=xl48 style='border-right:.5pt solid black;
border-bottom:.5pt solid black'>30101810000000000000</td>
</tr>
<tr height=12 style='mso-height-source:userset;height:9.0pt'>
<td height=12 class=xl24 style='height:9.0pt'></td>
<td colspan=18 class=xl54 style='border-right:.5pt solid black'>Банк
получателя</td>
</tr>
<tr height=17 style='mso-height-source:userset;height:12.75pt'>
<td height=17 class=xl24 style='height:12.75pt'></td>
<td colspan=9 class=xl57 style='border-right:.5pt solid black'>ИНН
5258000000</td>
<td colspan=9 class=xl57 style='border-right:.5pt solid black;border-left:
none' x:str="КПП ">КПП 520000000<span style='mso-spacerun:yes'>В </span></td>
<td colspan=3 rowspan=4 class=xl42 style='border-right:.5pt solid black;
border-bottom:.5pt solid black'>расч. счёт</td>
<td colspan=11 rowspan=4 class=xl63 style='border-right:.5pt solid black;
border-bottom:.5pt solid black'>40702810101020000000</td>
</tr>
<tr height=16 style='mso-height-source:userset;height:12.0pt'>
<td height=16 class=xl24 style='height:12.0pt'></td>
<td colspan=18 rowspan=2 class=xl66 width=378 style='border-right:.5pt solid black;
width:288pt'><span style='mso-spacerun:yes'</span>"ООО "Лог-НН" г. Н.Новгород</td>
</tr>
<tr height=18 style='mso-height-source:userset;height:13.5pt'>
<td height=18 class=xl24 style='height:13.5pt'></td>
</tr>
<tr height=12 style='mso-height-source:userset;height:9.0pt'>
<td height=12 class=xl24 style='height:9.0pt'></td>
<td colspan=18 class=xl72 style='border-right:.5pt solid black'>Получатель</td>
</tr>
<tr height=15 style='height:11.25pt'>
<td height=15 colspan=33 class=xl24 style='height:11.25pt;mso-ignore:colspan'></td>
</tr>
<tr height=15 style='height:11.25pt'>
<td height=15 class=xl24 style='height:11.25pt'></td>
<td colspan=32 rowspan=2 class=xl75>Счет № {ORDER_NUM} РѕС‚ {DATE}</td>
</tr>
<tr height=15 style='height:11.25pt'>
<td height=15 class=xl24 style='height:11.25pt'></td>
</tr>
<tr height=9 style='mso-height-source:userset;height:6.95pt'>
<td height=9 class=xl24 style='height:6.95pt'></td>
<td colspan=32 class=xl26> </td>
</tr>
<tr height=9 style='mso-height-source:userset;height:6.95pt'>
<td height=9 colspan=33 class=xl24 style='height:6.95pt;mso-ignore:colspan'></td>
</tr>
<tr height=40 style='mso-height-source:userset;height:30.0pt'>
<td height=40 class=xl24 style='height:30.0pt'></td>
<td colspan=4 class=xl76>Поставщик:</td>
<td colspan=28 class=xl77 width=563 style='width:429pt'>ИНН 503211638666
КПП<span style='mso-spacerun:yes' </span> ООО "Лог-НН" г. Н.Новгород, 603000, г. Нижний новгород, ул. Московская, дом 12, тел. (831) 200-00-90; 400-00-00</td>
</tr>
<tr height=18 style='mso-height-source:userset;height:13.5pt'>
<td height=18 colspan=33 class=xl24 style='height:13.5pt;mso-ignore:colspan'></td>
</tr>
<tr height=22 style='mso-height-source:userset;height:16.5pt'>
<td height=22 class=xl24 style='height:16.5pt'></td>
<td colspan=4 class=xl76>Покупатель:</td>
<td colspan=28 class=xl77 width=563 style='width:429pt'>{RECIEVER}</td>
</tr>
<tr height=9 style='mso-height-source:userset;height:6.95pt'>
<td height=9 colspan=33 class=xl24 style='height:6.95pt;mso-ignore:colspan'></td>
</tr>
<tr height=15 style='height:11.25pt'>
<td height=15 class=xl24 style='height:11.25pt'></td>
<td colspan=2 rowspan=2 class=xl78 style='border-right:.5pt solid black;
border-bottom:.5pt solid black'>№</td>
<td colspan=17 rowspan=2 class=xl82 style='border-right:.5pt solid black;
border-bottom:.5pt solid black'>Товар</td>
<td colspan=3 rowspan=2 class=xl82 style='border-right:.5pt solid black;
border-bottom:.5pt solid black'>Кол-во</td>
<td colspan=2 rowspan=2 class=xl82 style='border-right:.5pt solid black;
border-bottom:.5pt solid black'>Ед.</td>
<td colspan=4 rowspan=2 class=xl82 style='border-right:.5pt solid black;
border-bottom:.5pt solid black'>Цена</td>
<td colspan=4 rowspan=2 class=xl82 style='border-right:1.0pt solid black;
border-bottom:.5pt solid black'>Сумма</td>
</tr>
<tr height=20 style='mso-height-source:userset;height:15.0pt'>
<td height=20 class=xl24 style='height:15.0pt'></td>
</tr>
{PRODUCTS}
<tr height=9 style='mso-height-source:userset;height:6.95pt'>
<td height=9 colspan=33 class=xl24 style='height:6.95pt;mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=23 class=xl24 style='height:12.75pt;mso-ignore:colspan'></td>
<td class=xl27 colspan=4>Итого:</td>
<td colspan=6 class=xl91>{TOTAL}</td>
</tr>
<tr height=9 style='mso-height-source:userset;height:6.95pt'>
<td height=9 colspan=33 class=xl24 style='height:6.95pt;mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl24 style='height:12.75pt'></td>
<td colspan=32 class=xl92>Всего наименований {PRODUCTS_AMOUNT}, на сумму
{TOTAL}</td>
</tr>
<tr height=16 style='mso-height-source:userset;height:12.0pt'>
<td height=16 class=xl24 style='height:12.0pt'></td>
<td colspan=31 class=xl77 width=639 style='width:487pt'>{TOTAL_PROP}</td>
<td class=xl24></td>
</tr>
<tr height=9 style='mso-height-source:userset;height:6.95pt'>
<td height=9 class=xl24 style='height:6.95pt'></td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
<td class=xl26> </td>
</tr>
<tr height=15 style='height:11.25pt'>
<td height=15 colspan=33 class=xl24 style='height:11.25pt;mso-ignore:colspan'></td>
</tr>
<tr height=31 style='mso-height-source:userset;height:23.25pt'>
<td height=31 class=xl24 style='height:23.25pt'></td>
<td class=xl25 colspan=5 style='mso-ignore:colspan'>Руководитель</td>
<td colspan=4 class=xl24 style='mso-ignore:colspan'></td>
<td colspan=6 class=xl93 width=126 style='width:96pt'>(Соловей Леонид Иванович)</td>
<td class=xl24></td>
<td class=xl25 colspan=4 style='mso-ignore:colspan'>Бухгалтер</td>
<td colspan=5 class=xl24 style='mso-ignore:colspan'></td>
<td colspan=6 class=xl93 width=114 style='width:87pt'>(Петрова Анна Владимировна)</td>
<td class=xl24></td>
</tr>
<![if supportMisalignedColumns]>
<tr height=0 style='display:none'>
<td width=10 style='width:8pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=21 style='width:16pt'></td>
<td width=13 style='width:10pt'></td>
<td width=21 style='width:16pt'></td>
<td width=38 style='width:29pt'></td>
<td width=0></td>
<td width=8 style='width:6pt'></td>
</tr>
<![endif]>
</table>
</body>
</html>
файл printdraft.php (Отобразить)
<?php
class Plural {
const MALE = 1;
const FEMALE = 2;
const NEUTRAL = 3;
protected static $_digits = array(
self::MALE => array('ноль', 'один', 'два', 'три', 'четыре','пять', 'шесть', 'семь', 'восемь', 'девять'),
self::FEMALE => array('ноль', 'одна', 'две', 'три', 'четыре','пять', 'шесть', 'семь', 'восемь', 'девять'),
self::NEUTRAL => array('ноль', 'одно', 'два', 'три', 'четыре','пять', 'шесть', 'семь', 'восемь', 'девять')
);
protected static $_ths = array(
0 => array('','',''),
1=> array('тысяча', 'тысячи', 'тысяч'),
2 => array('миллион', 'миллиона', 'миллионов'),
3 => array('миллиард','миллиарда','миллиардов'),
4 => array('триллион','триллиона','триллионов'),
5 => array('квадриллион','квадриллиона','квадриллионов')
);
protected static $_ths_g = array(self::NEUTRAL, self::FEMALE, self::MALE, self::MALE, self::MALE, self::MALE); // hack 4 thsds
protected static $_teens = array(
0=>'десять',
1=>'одиннадцать',
2=>'двенадцать',
3=>'тринадцать',
4=>'четырнадцать',
5=>'пятнадцать',
6=>'шестнадцать',
7=>'семнадцать',
8=>'восемнадцать',
9=>'девятнадцать'
);
protected static $_tens = array(
2=>'двадцать',
3=>'тридцать',
4=>'сорок',
5=>'пятьдесят',
6=>'шестьдесят',
7=>'семьдесят',
8=>'восемьдесят',
9=>'девяносто'
);
protected static $_hundreds = array(
1=>'сто',
2=>'двести',
3=>'триста',
4=>'четыреста',
5=>'пятьсот',
6=>'шестьсот',
7=>'семьсот',
8=>'восемьсот',
9=>'девятьсот'
);
protected function _ending($value, array $endings = array()) {
$result = '';
if ($value < 2) $result = $endings[0];
elseif ($value < 5) $result = $endings[1];
else $result = $endings[2];
return $result;
}
protected function _triade($value, $mode = self::MALE, array $endings = array()) {
$result = '';
if ($value == 0) { return $result; }
$triade = str_split(str_pad($value,3,'0',STR_PAD_LEFT));
if ($triade[0]!=0) { $result.= (self::$_hundreds[$triade[0]].' '); }
if ($triade[1]==1) { $result.= (self::$_teens[$triade[2]].' '); }
elseif(($triade[1]!=0)) { $result.= (self::$_tens[$triade[1]].' '); }
if (($triade[2]!=0)&&($triade[1]!=1)) { $result.= (self::$_digits[$mode][$triade[2]].' '); }
if ($value!=0) { $ends = ($triade[1]==1?'1':'').$triade[2]; $result.= self::_ending($ends,$endings).' '; }
return $result;
}
public function asString($value, $mode = self::MALE, array $endings = array()) {
if (empty($endings)) { $endings = array('','',''); }
$result = '';
$steps = ceil(strlen($value)/3);
$sv = str_pad($value, $steps*3, '0', STR_PAD_LEFT);
for ($i=0; $i<$steps; $i++) {
$triade = substr($sv, $i*3, 3);
$iter = $steps - $i;
$ends = ($iter!=1)?(self::$_ths[$iter-1])
$endings);
$gender = ($iter!=1)?(self::$_ths_g[$iter-1])$mode);
$result.= self::_triade($triade,$gender, $ends);
}
return $result;
}
}
function utf8_substr2($str,$from,$len){
# utf8 substr
# www[dot]yeap[dot]lv
return preg_replace('#^(?:[\x00-\x7F]|[\xC0-\xFF][\x80-\xBF]+){0,'.$from.'}'.
'((?:[\x00-\x7F]|[\xC0-\xFF][\x80-\xBF]+){0,'.$len.'}).*#s',
'$1',$str);
}
?>
<?php
if(!$_POST)
{
?>
<h3>Пожалуйста, укажите Ваши данные</h3>
<form action="index2.php?option=com_printdraft" method="post" id="kdt_printform" name="kdt_printform">
<table style="margin:0; padding:0; ">
<tr>
<td>ИНН</td>
<td style="padding-left:3px"><input name="inn" type="text"/></td>
</tr>
<tr>
<td>КПП</td>
<td style="padding-left:3px"><input name="kpp" type="text"/></td>
</tr>
<tr>
<td style="white-space:nowrap;">Полное название организации</td>
<td style="padding-left:3px"><input name="org" type="text"/></td>
</tr>
<tr>
<td>Контактный телефон</td>
<td style="padding-left:3px"><input name="phone" type="text"/></td>
</tr>
<tr>
<td colspan="2" style="text-align:center;">
<input type="submit" value="Получить счет" class="button" />
</td>
</tr>
</table>
</form>
<?
}
else
{
$handle = fopen('components/com_printdraft/schet.html', "r");
$contents = fread($handle, filesize('components/com_printdraft/schet.html'));
fclose($handle);
$i = 1;
$kdt_cart_ = $_SESSION['kdt_cart'];
$kdt_total_ = $_SESSION['kdt_total'];
if ($_POST['inn']) { $reciever .= 'ИНН '.$_POST['inn'].' '; }
if ($_POST['kpp']) { $reciever .= 'КПП '.$_POST['kpp'].' '; }
if ($_POST['org']) { $reciever .= $_POST['org'].' '; }
if ($_POST['phone']) { $reciever .= $_POST['phone'].' '; }
$reciever = utf8_substr2($reciever, 0, -5);
$blank = str_ireplace('{DATE}', date("d.m.Y") , $contents);
$blank = str_ireplace('{RECIEVER}', $reciever , $blank);
$blank = str_ireplace('{PRODUCTS_AMOUNT}', count($kdt_cart_) , $blank);
$kdt_total_ = utf8_substr2($kdt_total_, 0, strpos($kdt_total_, ' '));
$kdt_shipping_ = utf8_substr2($_SESSION['kdt_shipping'], 0, strpos($_SESSION['kdt_shipping'], ' '));
// $kdt_total_ = ($kdt_total_*1 - $kdt_shipping_*1);
// if($kdt_total_ % 1 == 0) { $kdt_total_ .= '.00'; }
// $kdt_total_ .= ' руб.';
$blank = str_ireplace('{TOTAL}', $kdt_total_ , $blank);
$blank = str_ireplace('{ORDER_NUM}', $_SESSION['order_id'] , $blank);
foreach($kdt_cart_ as $cartrow)
{
$product_table .= '<tr><td></td><td colspan=2 style="border-left:1px solid black; border-bottom:1px solid black; border-right:1px solid black; text-align:left; padding-right:2px;">'.$i.'</td><td colspan=17 style="border-right:1px solid black; border-bottom:1px solid black; text-align:left; padding-right:2px;">'.strip_tags($cartrow['product_name']).'</td>
<td colspan=3 style="border-right:1px solid black; border-bottom:1px solid black;border-left:1px solid black; text-align:right; padding-right:2px;">'.$cartrow['quantity'].'</td><td colspan=2 style=" border-bottom:1px solid black;border-right:1px solid black; text-align:left; padding-right:2px;">шт.</td><td colspan=4 style="border-right:1px solid black; border-bottom:1px solid black; text-align:right; padding-right:2px;">'.$cartrow['product_price'].'</td>
<td colspan=4 style="border-right:1px solid black; border-bottom:1px solid black;text-align:right; padding-right:2px;">'.$cartrow['subtotal'].'</td></tr>';
$i++;
}
// $product_table .= '<tr><td></td><td colspan=2 style="border-left:1px solid black; border-bottom:1px solid black; border-right:1px solid black; text-align:left; padding-right:2px;">'.$i.'</td><td colspan=17 style="border-right:1px solid black; border-bottom:1px solid black; text-align:left; padding-right:2px;">Доставка и отгрузка товара</td>
// <td colspan=3 style="border-right:1px solid black; border-bottom:1px solid black;border-left:1px solid black; text-align:right; padding-right:2px;"></td><td colspan=2 style=" border-bottom:1px solid black;border-right:1px solid black; text-align:left; padding-right:2px;"></td><td colspan=4 style="border-right:1px solid black; border-bottom:1px solid black; text-align:right; padding-right:2px;"></td>
/// <td colspan=4 style="border-right:1px solid black; border-bottom:1px solid black;text-align:right; padding-right:2px;">'.$_SESSION['kdt_shipping'].'</td></tr>';
$kdt_total_ = utf8_substr2($kdt_total_, 0, strpos($kdt_total_, '.'));
$kdt_total_p = plural::asString(str_ireplace('$', '' , $kdt_total_),plural::MALE,array('доллар США','доллара США','долларов США'));
$blank = str_ireplace('{PRODUCTS}', $product_table , $blank);
$blank = str_ireplace('{TOTAL_PROP}', $kdt_total_p , $blank);
echo $blank;
$address="rtm765@mail.ru";
$theme="безнальный счет №".$_SESSION['order_id'];
$autor="a3market безнальный информер";
$format="Content-Type: text/html; charset=utf-8\n";
$format .="Content-Transfer-Encoding: 8bit\n\n";
mail($address,$theme,$blank,"From:".$autor."\nReply-To:$author\n".$format);
?>
<script language="Javascript1.2">
<!--
window.print();
//-->
</script>
<?
}
?>
class Plural {
const MALE = 1;
const FEMALE = 2;
const NEUTRAL = 3;
protected static $_digits = array(
self::MALE => array('ноль', 'один', 'два', 'три', 'четыре','пять', 'шесть', 'семь', 'восемь', 'девять'),
self::FEMALE => array('ноль', 'одна', 'две', 'три', 'четыре','пять', 'шесть', 'семь', 'восемь', 'девять'),
self::NEUTRAL => array('ноль', 'одно', 'два', 'три', 'четыре','пять', 'шесть', 'семь', 'восемь', 'девять')
);
protected static $_ths = array(
0 => array('','',''),
1=> array('тысяча', 'тысячи', 'тысяч'),
2 => array('миллион', 'миллиона', 'миллионов'),
3 => array('миллиард','миллиарда','миллиардов'),
4 => array('триллион','триллиона','триллионов'),
5 => array('квадриллион','квадриллиона','квадриллионов')
);
protected static $_ths_g = array(self::NEUTRAL, self::FEMALE, self::MALE, self::MALE, self::MALE, self::MALE); // hack 4 thsds
protected static $_teens = array(
0=>'десять',
1=>'одиннадцать',
2=>'двенадцать',
3=>'тринадцать',
4=>'четырнадцать',
5=>'пятнадцать',
6=>'шестнадцать',
7=>'семнадцать',
8=>'восемнадцать',
9=>'девятнадцать'
);
protected static $_tens = array(
2=>'двадцать',
3=>'тридцать',
4=>'сорок',
5=>'пятьдесят',
6=>'шестьдесят',
7=>'семьдесят',
8=>'восемьдесят',
9=>'девяносто'
);
protected static $_hundreds = array(
1=>'сто',
2=>'двести',
3=>'триста',
4=>'четыреста',
5=>'пятьсот',
6=>'шестьсот',
7=>'семьсот',
8=>'восемьсот',
9=>'девятьсот'
);
protected function _ending($value, array $endings = array()) {
$result = '';
if ($value < 2) $result = $endings[0];
elseif ($value < 5) $result = $endings[1];
else $result = $endings[2];
return $result;
}
protected function _triade($value, $mode = self::MALE, array $endings = array()) {
$result = '';
if ($value == 0) { return $result; }
$triade = str_split(str_pad($value,3,'0',STR_PAD_LEFT));
if ($triade[0]!=0) { $result.= (self::$_hundreds[$triade[0]].' '); }
if ($triade[1]==1) { $result.= (self::$_teens[$triade[2]].' '); }
elseif(($triade[1]!=0)) { $result.= (self::$_tens[$triade[1]].' '); }
if (($triade[2]!=0)&&($triade[1]!=1)) { $result.= (self::$_digits[$mode][$triade[2]].' '); }
if ($value!=0) { $ends = ($triade[1]==1?'1':'').$triade[2]; $result.= self::_ending($ends,$endings).' '; }
return $result;
}
public function asString($value, $mode = self::MALE, array $endings = array()) {
if (empty($endings)) { $endings = array('','',''); }
$result = '';
$steps = ceil(strlen($value)/3);
$sv = str_pad($value, $steps*3, '0', STR_PAD_LEFT);
for ($i=0; $i<$steps; $i++) {
$triade = substr($sv, $i*3, 3);
$iter = $steps - $i;
$ends = ($iter!=1)?(self::$_ths[$iter-1])
$endings);$gender = ($iter!=1)?(self::$_ths_g[$iter-1])
$mode);$result.= self::_triade($triade,$gender, $ends);
}
return $result;
}
}
function utf8_substr2($str,$from,$len){
# utf8 substr
# www[dot]yeap[dot]lv
return preg_replace('#^(?:[\x00-\x7F]|[\xC0-\xFF][\x80-\xBF]+){0,'.$from.'}'.
'((?:[\x00-\x7F]|[\xC0-\xFF][\x80-\xBF]+){0,'.$len.'}).*#s',
'$1',$str);
}
?>
<?php
if(!$_POST)
{
?>
<h3>Пожалуйста, укажите Ваши данные</h3>
<form action="index2.php?option=com_printdraft" method="post" id="kdt_printform" name="kdt_printform">
<table style="margin:0; padding:0; ">
<tr>
<td>ИНН</td>
<td style="padding-left:3px"><input name="inn" type="text"/></td>
</tr>
<tr>
<td>КПП</td>
<td style="padding-left:3px"><input name="kpp" type="text"/></td>
</tr>
<tr>
<td style="white-space:nowrap;">Полное название организации</td>
<td style="padding-left:3px"><input name="org" type="text"/></td>
</tr>
<tr>
<td>Контактный телефон</td>
<td style="padding-left:3px"><input name="phone" type="text"/></td>
</tr>
<tr>
<td colspan="2" style="text-align:center;">
<input type="submit" value="Получить счет" class="button" />
</td>
</tr>
</table>
</form>
<?
}
else
{
$handle = fopen('components/com_printdraft/schet.html', "r");
$contents = fread($handle, filesize('components/com_printdraft/schet.html'));
fclose($handle);
$i = 1;
$kdt_cart_ = $_SESSION['kdt_cart'];
$kdt_total_ = $_SESSION['kdt_total'];
if ($_POST['inn']) { $reciever .= 'ИНН '.$_POST['inn'].' '; }
if ($_POST['kpp']) { $reciever .= 'КПП '.$_POST['kpp'].' '; }
if ($_POST['org']) { $reciever .= $_POST['org'].' '; }
if ($_POST['phone']) { $reciever .= $_POST['phone'].' '; }
$reciever = utf8_substr2($reciever, 0, -5);
$blank = str_ireplace('{DATE}', date("d.m.Y") , $contents);
$blank = str_ireplace('{RECIEVER}', $reciever , $blank);
$blank = str_ireplace('{PRODUCTS_AMOUNT}', count($kdt_cart_) , $blank);
$kdt_total_ = utf8_substr2($kdt_total_, 0, strpos($kdt_total_, ' '));
$kdt_shipping_ = utf8_substr2($_SESSION['kdt_shipping'], 0, strpos($_SESSION['kdt_shipping'], ' '));
// $kdt_total_ = ($kdt_total_*1 - $kdt_shipping_*1);
// if($kdt_total_ % 1 == 0) { $kdt_total_ .= '.00'; }
// $kdt_total_ .= ' руб.';
$blank = str_ireplace('{TOTAL}', $kdt_total_ , $blank);
$blank = str_ireplace('{ORDER_NUM}', $_SESSION['order_id'] , $blank);
foreach($kdt_cart_ as $cartrow)
{
$product_table .= '<tr><td></td><td colspan=2 style="border-left:1px solid black; border-bottom:1px solid black; border-right:1px solid black; text-align:left; padding-right:2px;">'.$i.'</td><td colspan=17 style="border-right:1px solid black; border-bottom:1px solid black; text-align:left; padding-right:2px;">'.strip_tags($cartrow['product_name']).'</td>
<td colspan=3 style="border-right:1px solid black; border-bottom:1px solid black;border-left:1px solid black; text-align:right; padding-right:2px;">'.$cartrow['quantity'].'</td><td colspan=2 style=" border-bottom:1px solid black;border-right:1px solid black; text-align:left; padding-right:2px;">шт.</td><td colspan=4 style="border-right:1px solid black; border-bottom:1px solid black; text-align:right; padding-right:2px;">'.$cartrow['product_price'].'</td>
<td colspan=4 style="border-right:1px solid black; border-bottom:1px solid black;text-align:right; padding-right:2px;">'.$cartrow['subtotal'].'</td></tr>';
$i++;
}
// $product_table .= '<tr><td></td><td colspan=2 style="border-left:1px solid black; border-bottom:1px solid black; border-right:1px solid black; text-align:left; padding-right:2px;">'.$i.'</td><td colspan=17 style="border-right:1px solid black; border-bottom:1px solid black; text-align:left; padding-right:2px;">Доставка и отгрузка товара</td>
// <td colspan=3 style="border-right:1px solid black; border-bottom:1px solid black;border-left:1px solid black; text-align:right; padding-right:2px;"></td><td colspan=2 style=" border-bottom:1px solid black;border-right:1px solid black; text-align:left; padding-right:2px;"></td><td colspan=4 style="border-right:1px solid black; border-bottom:1px solid black; text-align:right; padding-right:2px;"></td>
/// <td colspan=4 style="border-right:1px solid black; border-bottom:1px solid black;text-align:right; padding-right:2px;">'.$_SESSION['kdt_shipping'].'</td></tr>';
$kdt_total_ = utf8_substr2($kdt_total_, 0, strpos($kdt_total_, '.'));
$kdt_total_p = plural::asString(str_ireplace('$', '' , $kdt_total_),plural::MALE,array('доллар США','доллара США','долларов США'));
$blank = str_ireplace('{PRODUCTS}', $product_table , $blank);
$blank = str_ireplace('{TOTAL_PROP}', $kdt_total_p , $blank);
echo $blank;
$address="rtm765@mail.ru";
$theme="безнальный счет №".$_SESSION['order_id'];
$autor="a3market безнальный информер";
$format="Content-Type: text/html; charset=utf-8\n";
$format .="Content-Transfer-Encoding: 8bit\n\n";
mail($address,$theme,$blank,"From:".$autor."\nReply-To:$author\n".$format);
?>
<script language="Javascript1.2">
<!--
window.print();
//-->
</script>
<?
}
?>
Спасибо.