256 lines
10 KiB
Smarty
256 lines
10 KiB
Smarty
|
<link rel="stylesheet" type="text/css" href="include/jQuery/jquery-table/jquery.appendGrid-1.3.1.css"/>
|
||
|
|
<link rel="stylesheet" type="text/css" href="include/jQuery/jquery-ui/themes/base/jquery-ui.css"/>
|
||
|
|
<link rel="stylesheet" type="text/css" href="modules/EcmReports/TableSorter/css/theme.blue.css"/>
|
||
|
|
<link rel="stylesheet" type="text/css" href="modules/EcmReports/TableSorter/css/theme.blue2.css"/>
|
||
|
|
<!-- Tablesorter -->
|
||
|
|
<script type="text/javascript" src="modules/EcmReports/TableSorter/js/jquery.min.js"></script>
|
||
|
|
<script type="text/javascript" src="modules/EcmReports/TableSorter/js/jquery.tablesorter.min.js"></script>
|
||
|
|
<script type="text/javascript" src="modules/EcmReports/TableSorter/js/jquery.tablesorter.staticrow.min.js"></script>
|
||
|
|
<script type="text/javascript" src="modules/EcmReports/TableSorter/js/jquery.tablesorter.widgets.js"></script>
|
||
|
|
<script type="text/javascript" src="modules/EcmReports/javascript/jquery.blockUI.js"></script>
|
||
|
|
|
||
|
|
|
||
|
|
<script type="text/javascript" src="modules/EcmReports/javascript/ReportStocks.js"></script>
|
||
|
|
|
||
|
|
<script type="text/javascript">
|
||
|
|
{literal}
|
||
|
|
|
||
|
|
function pdfExport() {
|
||
|
|
var url = $(location).attr('href');
|
||
|
|
url = url + "&toPDF=1&to_pdf=1";
|
||
|
|
|
||
|
|
window.location.href = url;
|
||
|
|
}
|
||
|
|
{/literal}
|
||
|
|
</script>
|
||
|
|
<style type="text/css">
|
||
|
|
{literal}
|
||
|
|
|
||
|
|
thead, tfoot {font-weight: bold;}
|
||
|
|
|
||
|
|
.additionalColumn {
|
||
|
|
background-color: #87CCED;
|
||
|
|
border-top: 1px solid black;
|
||
|
|
}
|
||
|
|
.line {
|
||
|
|
border-top: 1px solid black !important;;
|
||
|
|
}
|
||
|
|
.groupActive {
|
||
|
|
border-top: 1px solid black;
|
||
|
|
border-bottom: 1px solid black;
|
||
|
|
border-left: 1px solid black;
|
||
|
|
background-color: #87CCED;
|
||
|
|
}
|
||
|
|
|
||
|
|
.sumRow {
|
||
|
|
background-color: #BDC7B5;
|
||
|
|
}
|
||
|
|
|
||
|
|
.sumAll td{
|
||
|
|
background-color: #BDC7B5;
|
||
|
|
}
|
||
|
|
|
||
|
|
table.tablesorter tbody tr:hover td {
|
||
|
|
background: #E8E8E8;
|
||
|
|
color: #343432;
|
||
|
|
}
|
||
|
|
|
||
|
|
/* Extra selectors needed to override the default styling */
|
||
|
|
table.tablesorter tbody tr.normal-row td {
|
||
|
|
background: #EFEFF1;
|
||
|
|
color: #343432;
|
||
|
|
|
||
|
|
}
|
||
|
|
table.tablesorter tbody tr.alt-row td {
|
||
|
|
background: #FFF;
|
||
|
|
color: #343432;
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
/* Extra selectors needed to override the default styling */
|
||
|
|
table.tablesorter tbody tr.normal-row:hover td {
|
||
|
|
background: #B8E8E8;
|
||
|
|
color: #343432;
|
||
|
|
font-weight: bold;
|
||
|
|
}
|
||
|
|
table.tablesorter tbody tr.alt-row:hover td {
|
||
|
|
background: #B8E8E8;
|
||
|
|
color: #343432;
|
||
|
|
font-weight: bold;
|
||
|
|
}
|
||
|
|
table.tablesorter tbody tr.sumAll td {
|
||
|
|
background: #EBEBED;
|
||
|
|
color: black;
|
||
|
|
}
|
||
|
|
table.tablesorter tbody tr.sumAll:hover td {
|
||
|
|
background: #E0E0E2;
|
||
|
|
color: black;
|
||
|
|
font-weight: bold;
|
||
|
|
}
|
||
|
|
|
||
|
|
table.tablesorter .sumRow, .oddListRowS1 {
|
||
|
|
text-align: right;
|
||
|
|
}
|
||
|
|
|
||
|
|
table.tablesorter .alignLeft {
|
||
|
|
text-align: left;
|
||
|
|
}
|
||
|
|
|
||
|
|
table.tablesorter .subcategory .alignLeft {
|
||
|
|
padding-left: 20px;
|
||
|
|
}
|
||
|
|
|
||
|
|
table.tablesorter .contractor .alignLeft {
|
||
|
|
padding-left: 40px;
|
||
|
|
}
|
||
|
|
|
||
|
|
.plusStyle {
|
||
|
|
color: #abc3d7;
|
||
|
|
text-decoration: none;
|
||
|
|
cursor: pointer;
|
||
|
|
}
|
||
|
|
|
||
|
|
{/literal}
|
||
|
|
</style>
|
||
|
|
|
||
|
|
|
||
|
|
<table id="tableMenu" cellspacing="0" cellpadding="0" border="0">
|
||
|
|
<tbody>
|
||
|
|
<tr>
|
||
|
|
<td>
|
||
|
|
<img src="themes/Sugar/images/EcmProducts.gif" style="margin-top: 3px; margin-right: 3px;" alt="EcmProducts" width="16" border="0" height="16">
|
||
|
|
</td>
|
||
|
|
<td>
|
||
|
|
<h2>{$MOD.LBL_REPORT_STOCKS} </h2>
|
||
|
|
</td>
|
||
|
|
</tr>
|
||
|
|
</table>
|
||
|
|
|
||
|
|
<br />
|
||
|
|
|
||
|
|
<ul class="tablist" style="width:100%;">
|
||
|
|
<li>
|
||
|
|
<a class="current" href="#">Wyszukiwanie</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
<form action="index.php" method="get" name="searchReportStocks">
|
||
|
|
<input type="hidden" name="module" value="EcmReports" />
|
||
|
|
<input type="hidden" name="action" value="ReportStocksDoc" />
|
||
|
|
<table style="border-top: 0px none; margin-bottom: 4px;width:100%" class="tabForm" border="0" cellpadding="0" cellspacing="0">
|
||
|
|
|
||
|
|
<tr>
|
||
|
|
<td class="dataLabel" width="5%" nowrap="nowrap">{$MOD.LBL_STOCK}</td>
|
||
|
|
<td class="dataField" width="10%" nowrap="nowrap">
|
||
|
|
<select id="stock" name="selectStock">
|
||
|
|
<option value="" { if $selectStock==""} selected="true" {/if} >{$MOD.LBL_ALL_STOCKS}</option>
|
||
|
|
{foreach from=$STOCKS item=STOCK key=count name=loop}
|
||
|
|
<option value="{$STOCK.id}" { if $selectStock==$STOCK.id} selected="true" {/if} >{$STOCK.name}</option>
|
||
|
|
{/foreach}
|
||
|
|
</select>
|
||
|
|
</td>
|
||
|
|
<td class="dataLabel" width="10%" nowrap="nowrap"></td>
|
||
|
|
|
||
|
|
<td class="dataLabel" width="5%" nowrap="nowrap">{$MOD.LBL_PRODUCT_ACTIVE}</td>
|
||
|
|
<td class="dataField" width="10%" nowrap="nowrap">
|
||
|
|
<select id="productActive" name="selectProductActive">
|
||
|
|
<option value="" { if $selectProductActive==""} selected="true" {/if} >{$MOD.LBL_YES}/{$MOD.LBL_NO}</option>
|
||
|
|
<option value="1" { if $selectProductActive=="1"} selected="true" {/if} >{$MOD.LBL_YES}</option>
|
||
|
|
<option value="0" { if $selectProductActive=="0"} selected="true" {/if} >{$MOD.LBL_NO}</option>
|
||
|
|
</select>
|
||
|
|
</td>
|
||
|
|
<td class="dataLabel" width="10%" nowrap="nowrap"></td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
</tbody>
|
||
|
|
</table>
|
||
|
|
|
||
|
|
<input class="button" name="submit" value="{$MOD.LBL_EXECUTE}" type="submit">
|
||
|
|
<input class="button" name="clear" value="{$MOD.LBL_CLEAR}" type="button" onclick="location.href='index.php?module=EcmReports&action=ReportStocksDoc';">
|
||
|
|
<input id="excelEksport" class="button" name="importToExcel" value="Excel" type="button">
|
||
|
|
<input id="pdf" class="button" name="pdf" value="PDF" onClick="pdfExport();" type="button">
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
<br>
|
||
|
|
<br>
|
||
|
|
|
||
|
|
<table id="myTable" class="tablesorter tablesorter-blue" role="grid">
|
||
|
|
<thead>
|
||
|
|
<tr class="tablesorter-headerRow" role="row">
|
||
|
|
|
||
|
|
<th width="8%" class="sorter-text tablesorter-header tablesorter-headerUnSorted" data-column="0" tabindex="0" scope="col" role="columnheader" aria-disabled="false" unselectable="on" style="-moz-user-select: none;" aria-sort="none" aria-label="Name: No sort applied, activate to apply an ascending sort">{$MOD.LBL_INDEX}</th>
|
||
|
|
<th width="15%" class="sorter-text tablesorter-header tablesorter-headerUnSorted" data-column="1" tabindex="0" scope="col" role="columnheader" aria-disabled="false" unselectable="on" style="-moz-user-select: none;" aria-sort="none" aria-label="Name: No sort applied, activate to apply an ascending sort">{$MOD.LBL_NAME}</th>
|
||
|
|
<th width="8%" class="sorter-saas tablesorter-header tablesorter-headerUnSorted" data-column="5" tabindex="0" scope="col" role="columnheader" aria-disabled="false" unselectable="on" style="-moz-user-select: none;" aria-sort="none" aria-label="Name: No sort applied, activate to apply an ascending sort">{$MOD.LBL_DOC_NUMBER}</th>
|
||
|
|
{if $CONSIGNMENTS==TRUE}
|
||
|
|
<th width="8%" class="sorter-saas tablesorter-header tablesorter-headerUnSorted" data-column="5" tabindex="0" scope="col" role="columnheader" aria-disabled="false" unselectable="on" style="-moz-user-select: none;" aria-sort="none" aria-label="Name: No sort applied, activate to apply an ascending sort">{$MOD.LBL_CONSIGNMENTS}</th>
|
||
|
|
{/if}
|
||
|
|
<th width="8%" class="sorter-saas tablesorter-header tablesorter-headerUnSorted" data-column="5" tabindex="0" scope="col" role="columnheader" aria-disabled="false" unselectable="on" style="-moz-user-select: none;" aria-sort="none" aria-label="Name: No sort applied, activate to apply an ascending sort">{$MOD.LBL_QUANTITY}</th>
|
||
|
|
<th width="8%" class="sorter-saas tablesorter-header tablesorter-headerUnSorted" data-column="6" tabindex="0" scope="col" role="columnheader" aria-disabled="false" unselectable="on" style="-moz-user-select: none;" aria-sort="none" aria-label="Name: No sort applied, activate to apply an ascending sort">{$MOD.LBL_PRICE}</th>
|
||
|
|
<th width="8%" class="sorter-saas tablesorter-header tablesorter-headerUnSorted" data-column="6" tabindex="0" scope="col" role="columnheader" aria-disabled="false" unselectable="on" style="-moz-user-select: none;" aria-sort="none" aria-label="Name: No sort applied, activate to apply an ascending sort">{$MOD.LBL_VALUE}</th>
|
||
|
|
</tr>
|
||
|
|
</thead>
|
||
|
|
<tbody aria-live="polite" aria-relevant="all">
|
||
|
|
{foreach from=$DATA key="key" item="item" name=loop}
|
||
|
|
|
||
|
|
<tr>
|
||
|
|
{if $item.add|@count>1}
|
||
|
|
{assign var="rowspan" value=$item.add|@count}
|
||
|
|
{assign var="rowspanadd" value=1}
|
||
|
|
{assign var="currow" value=$rowspan*2+$rowspanadd}
|
||
|
|
{else}
|
||
|
|
{assign var="currow" value=1}
|
||
|
|
{/if}
|
||
|
|
<td class="oddListRowS1 alignLeft" rowspan="{$currow}"><b>{$item.product_code}</b></td>
|
||
|
|
<td class="oddListRowS1" style="text-align:left;" rowspan="{$currow}"><b>{$item.product_name}</b></td>
|
||
|
|
<td class="oddListRowS1 sumRow" ><a href="index.php?module={$item.parent_type2}&action=DetailView&record={$item.parent_id}">{$item.parent_type} {$item.parent_name}</a> {$item.date_entered|date_format:"%d.%m.%Y"}</td>
|
||
|
|
{if $CONSIGNMENTS==TRUE}
|
||
|
|
<td class="oddListRowS1 sumRow" >{$item.part_no}</td>
|
||
|
|
{/if}
|
||
|
|
<td class="oddListRowS1 sumRow" >{$item.total_quantity|number_format:2:",":"." } {$item.unit_id}</td>
|
||
|
|
<td class="oddListRowS1 sumRow" >{$item.price|number_format:2:",":"." }</td>
|
||
|
|
<td class="oddListRowS1 sumRow" >{$item.total_price|number_format:2:",":"." }</td>
|
||
|
|
</tr>
|
||
|
|
{if $item.add|@count>1}
|
||
|
|
{foreach from=$item.add key="kis" item="position" name=loop}
|
||
|
|
<tr>
|
||
|
|
<td class="oddListRowS1 sumRow" ><a href="index.php?module={$position.parent_type2}&action=DetailView&record={$position.parent_id}">{$position.parent_type} {$position.parent_name}</a> {$position.date_entered|date_format:"%d.%m.%Y"}</td>
|
||
|
|
{if $CONSIGNMENTS==TRUE}
|
||
|
|
<td class="oddListRowS1 sumRow" >{$position.part_no}</td>
|
||
|
|
{/if}
|
||
|
|
<td class="oddListRowS1 sumRow" >{$position.quantity|number_format:2:",":"." }</td>
|
||
|
|
<td class="oddListRowS1 sumRow" >{$position.price|number_format:2:",":"." }</td>
|
||
|
|
<td class="oddListRowS1 sumRow" >{$position.position_value|number_format:2:",":"." }</td>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td class='line'></td>
|
||
|
|
<td class='line'></td>
|
||
|
|
<td class='line'></td>
|
||
|
|
{if $CONSIGNMENTS==TRUE}
|
||
|
|
<td class='line'></td>
|
||
|
|
{/if}
|
||
|
|
<td class='line'></td>
|
||
|
|
</tr>
|
||
|
|
{/foreach}
|
||
|
|
|
||
|
|
{/if}
|
||
|
|
<tr>
|
||
|
|
<td class='line'></td>
|
||
|
|
<td class='line'></td>
|
||
|
|
{if $CONSIGNMENTS==TRUE}
|
||
|
|
<td class='line'></td>
|
||
|
|
{/if}
|
||
|
|
<td class='line'></td>
|
||
|
|
|
||
|
|
<td class='line'></td>
|
||
|
|
|
||
|
|
<td class='line'></td>
|
||
|
|
|
||
|
|
<td class='line'></td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
{/foreach}
|
||
|
|
</tbody>
|
||
|
|
<tr><td></td><td></td><td class="oddListRowS1 sumRow"><b>Razem:</b></td>{if $CONSIGNMENTS==TRUE}<td></td>{/if}<td class="oddListRowS1 sumRow"><b>{$TOTAL_QUANTITY|number_format:2:",":"." }</b></td><td></td><td class="oddListRowS1 sumRow"><b>{$TOTAL_VALUE|number_format:2:",":"." }</b></td></tr>
|
||
|
|
</table>
|
||
|
|
|
||
|
|
<br/>
|