<th class="grandtotal" style="text-align:left;">Grand Total</th> <th class="grandtotal" style="text-align:left;"><?php echo app\components\NumericLib::indoStyle($grandtotal, 2, ',', '.'); ?> </th> <th class="grandtotal" style="text-align:left;"><?php echo app\components\NumericLib::indoStyle($totalbulan1, 2, ',', '.'); ?> </th> <th class="grandtotal" style="text-align:left;"><?php echo app\components\NumericLib::indoStyle($totalbulan2, 2, ',', '.'); ?> </th> <th class="grandtotal" style="text-align:left;"><?php echo app\components\NumericLib::indoStyle($totalbulan3, 2, ',', '.'); ?> </th> <th class="grandtotal" style="text-align:left;"><?php echo app\components\NumericLib::indoStyle($totalbulan4, 2, ',', '.'); ?> </th> </tr> </table> </td> </tr> </tbody> </table> </div>
echo '<tr class="bgdark">
<td class="bgdark"></td>
<td class="bgdark"></td>
<td class="bgdark"></td>
<td class="bgdark"></td>
<td class="bgdark"></td>
<td class="bgdark"><div class="price">' . app\components\NumericLib::indoStyle($debit, 0, ',', '.') . '</div></td>
<td class="bgdark"><div class="price">' . app\components\NumericLib::indoStyle($credit, 0, ',', '.') . '</div></td>
<td class="bgdark"></td>
</tr>';
$debittotal = $debittotal + $debit;
$kredittotal = $kredittotal + $credit;
}
?>
<tr class="grandtotal">
<th colspan="2" class="grandtotal"></th>
<th colspan="3" class="grandtotal" style="text-align:left;">Grand Total</th>
<th style="text-align:right;" class="grandtotal"><?php
echo app\components\NumericLib::indoStyle($debittotal, 0, ',', '.');
?>
</th>
<th style="text-align:right;" class="grandtotal"><?php
echo app\components\NumericLib::indoStyle($kredittotal, 0, ',', '.');
?>
</th>
<th></th>
</tr>
</table>
</div>
} else {
/* ============================= Print out Untuk Incoming Shipment & Internal Move =========================================== */
$judul = "<div class='judul'>Report Incoming Shipment & Internal Move</div> <br/><div class='periode'> " . Yii::$app->formatter->asDatetime($from, "php:d-m-Y") . " s/d " . Yii::$app->formatter->asDatetime($to, "php:d-m-Y") . "</div>";
$headTable = "\r\n\t\t\t<tr>\r\n\t\t\t\t<td>Type</td>\r\n\t\t\t\t<td>Date</td>\r\n\t\t\t\t<td>LBM No</td>\r\n\t\t\t\t<td>Part Number</td>\r\n\t\t\t\t<td>Product Name</td>\r\n\t\t\t\t<td>Product Desc</td>\r\n\t\t\t\t<td>Qty</td>\r\n\t\t\t\t<td>UOM</td>\r\n\t\t\t\t<td>Batch</td>\r\n\t\t\t\t<td>Price</td>\r\n\t\t\t\t<td>Currency</td>\r\n\t\t\t\t<td>Location</td>\r\n\t\t\t\t<td>Dest Location</td>\r\n\t\t\t\t<td>Partner</td>\r\n\t\t\t\t<td>Type</td>\r\n\t\t\t\t<td>NO PO</td>\r\n\t\t\t\t<td>Origin</td>\r\n\t\t\t\t<td>Status</td>\r\n\t\t\t</tr>\r\n\t\t\t";
foreach ($data as $value) {
$body[] = '<tr>
<td>' . $value['jenis'] . '</td>
<td>' . Yii::$app->formatter->asDatetime($value['date_done'], "php:d-m-Y") . '</td>
<td>' . $value['lbm'] . '</td>
<td>' . $value['part_number'] . '</td>
<td>' . $value['name_template'] . '</td>
<td>' . $value['name_input'] . '</td>
<td>' . $value['qty'] . '</td>
<td>' . $value['uom'] . '</td>
<td>' . $value['batch'] . '</td>
<td>' . app\components\NumericLib::indoStyle($value['price'], 2, ',', '.') . '</td>
<td>' . $value['pricelist'] . '</td>
<td>' . $value['location'] . '</td>
<td>' . $value['desc_location'] . '</td>
<td>' . $value['partner'] . '</td>
<td>' . $value['type'] . '</td>
<td>' . $value['po'] . '</td>
<td>' . $value['origin'] . '</td>
<td>' . $value['state'] . '</td>
</tr>';
}
}
echo $judul;
echo "<table class='ReportTable'>";
echo $headTable;
foreach ($body as $val) {
var cektable=jQuery(\'#lines\'+currPage).height();
var SetHeight=(HeightTable-cektable)-23;
var MinHeight=(HeightTable-cektable)-23;
if(currPage){
if (cektable < HeightTable){
var footer =' . $footer . ';
var footertotal = "<tr class=lineTable><td colspan=3></td><td colspan=3>TOTAL AMOUNT</td><td align=right>' . app\components\NumericLib::indoStyle($subtotal, 2, ',', '.') . '</td></tr><tr class=lineTable><td colspan=3></td><td colspan=3>Discount</td><td align=right>' . app\components\NumericLib::indoStyle($diskon, 2, ',', '.') . '</td></tr class=lineTable><tr><td colspan=3></td><td colspan=3>PPN 10%</td><td align=right>' . app\components\NumericLib::indoStyle($model->amount_tax, 2, ',', '.') . '</td></tr><tr class=lineTable><td colspan=3></td><td colspan=3>GRAND TOTAL</td><td align=right>' . app\components\NumericLib::indoStyle($model->amount_total, 2, ',', '.') . '</td></tr>";
var res1 = "<tr><th width=30px height=25px>No.</th><th width=265px>DESCRIPTION</th><th width=89px>PART NO</th><th width=60px>QTY</th><th width=50px>UNIT</th><th width=80px>HARGA<br/>' . $pricelist . '</th><th width=107px>TOTAL<br/>' . $pricelist . '</th></tr>";
var res = "<tr><td style=\\"width:30px; height:"+SetHeight+"px; text-align:center;\\"></td><td style=\\"width:265px; text-align:center;\\"></td><td style=\\"width:89px; text-align:center;\\"><div class=\\"leftdata\\"></div><div class=\\"rightdata\\"></div></td><td style=\\"width:60px; text-align:right;\\"><div class=\\"leftdata\\"></div><div class=\\"rightdata\\"></div></td><td style=\\"width:50px; text-align:center;\\"><div class=\\"leftdata\\"></div><div class=\\"rightdata\\"></div></td><td style=\\"width:80px; text-align:center;\\"><div class=\\"leftdata\\"></div><div class=\\"rightdata\\"></div></td><td style=\\"width:107px; text-align:center;\\"><div class=\\"leftdata\\"></div><div class=\\"rightdata\\"></div></td></tr>";
jQuery(\'#lines\'+currPage+\' tr:first\').before(res1);
jQuery(\'#lines\'+currPage+\' tr:last\').after(res);
jQuery(\'#lines\'+currPage+\' tr:last\').after(footertotal);
jQuery(\'#lines\'+currPage+\' tr:last\').after(footer);
jQuery(\'#page\'+currPage+\' .hideprint\').show();
}else{
var footer =' . $footer . ';
var footertotal = "<tr class=lineTable><td colspan=3></td><td colspan=3>TOTAL AMOUNT</td><td align=right>' . app\components\NumericLib::indoStyle($subtotal, 2, ',', '.') . '</td></tr><tr class=lineTable><td colspan=3></td><td colspan=3>Discount</td><td align=right>' . app\components\NumericLib::indoStyle($diskon, 2, ',', '.') . '</td></tr class=lineTable><tr><td colspan=3></td><td colspan=3>PPN 10%</td><td align=right>' . app\components\NumericLib::indoStyle($model->amount_tax, 2, ',', '.') . '</td></tr><tr class=lineTable><td colspan=3></td><td colspan=3>GRAND TOTAL</td><td align=right>' . app\components\NumericLib::indoStyle($model->amount_total, 2, ',', '.') . '</td></tr>";
var res1 = "<tr><th width=30px height=25px>No.</th><th width=265px>DESCRIPTION</th><th width=89px>PART NO</th><th width=60px>QTY</th><th width=50px>UNIT</th><th width=80px>HARGA<br/>' . $pricelist . '</th><th width=107px>TOTAL<br/>' . $pricelist . '</th></tr>";
var res = "<tr><td style=\\"width:30px; height:"+SetHeight+"px; text-align:center;\\"></td><td style=\\"width:265px; text-align:center;\\"></td><td style=\\"width:89px; text-align:center;\\"><div class=\\"leftdata\\"></div><div class=\\"rightdata\\"></div></td><td style=\\"width:60px; text-align:right;\\"><div class=\\"leftdata\\"></div><div class=\\"rightdata\\"></div></td><td style=\\"width:50px; text-align:center;\\"><div class=\\"leftdata\\"></div><div class=\\"rightdata\\"></div></td><td style=\\"width:80px; text-align:center;\\"><div class=\\"leftdata\\"></div><div class=\\"rightdata\\"></div></td><td style=\\"width:107px; text-align:center;\\"><div class=\\"leftdata\\"></div><div class=\\"rightdata\\"></div></td></tr>";
jQuery(\'#lines\'+currPage+\' tr:first\').before(res1);
jQuery(\'#lines\'+currPage+\' tr:last\').after(res);
jQuery(\'#lines\'+currPage+\' tr:last\').after(footertotal);
jQuery(\'#lines\'+currPage+\' tr:last\').after(footer);
jQuery(\'#page\'+currPage+\' .hideprint\').show();
}
}
// end loop
');
echo '<td></td>';
echo '<td>' . $value['name'] . '</td>';
echo '<td>' . Yii::$app->formatter->asDatetime($value['date'], "php:d-m-Y") . '</td>';
echo '<td>' . $value['ref'] . '</td>';
echo '<td><div class="price">' . app\components\NumericLib::indoStyle($value['debit'], 0, ',', '.') . '</div></td>';
echo '<td><div class="price">' . app\components\NumericLib::indoStyle($value['credit'], 0, ',', '.') . '</div></td>';
echo '<td></td>';
echo '</tr>';
$debit = $debit + $value['debit'];
$credit = $credit + $value['credit'];
}
}
echo '<tr class="bgdark">
<td class="bgdark"></td>
<td class="bgdark"></td>
<td class="bgdark"></td>
<td class="bgdark"></td>
<td class="bgdark"><div class="price">' . app\components\NumericLib::indoStyle($debit, 0, ',', '.') . '</div></td>
<td class="bgdark"><div class="price">' . app\components\NumericLib::indoStyle($credit, 0, ',', '.') . '</div></td>
<td class="bgdark"></td>
</tr>';
}
?>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</td> </tr> <tr style="margin-top:-3px;"> <td> <table class="foodtablepages" style="width:186mm; border:1px solid black; border-collapse: collapse; margin-top:-11px;"> <tr> <th width="505px" >Jumlah Harga BKP yang dikembalikan</th> <th style="text-align:right;"><?php echo app\components\NumericLib::indoStyle($model->amount_untaxed, 2, ',', '.'); ?> </th> </tr> <tr> <th>Pajak Pertambahan Nilai yang dikembalikan</th> <th style="text-align:right;"><?php echo app\components\NumericLib::indoStyle($model->amount_tax, 2, ',', '.'); ?> </th> </tr> <tr> <th></th> <th style="text-align:right;">-</th> </tr> </table> </td> </tr> </table> <div style="float:right; display:block; width:200px;"> Jakarta,<br/> PT.XXXXXXX <br/>
}], ['attribute' => 'price_unit', 'header' => 'Price Unit', 'value' => function ($model, $key, $index, $grid) {
return app\components\NumericLib::indoStyle($model['price_unit'], 2, ',', '.');
}], ['attribute' => 'pricelist', 'header' => 'Currency'], ['attribute' => 'cout', 'header' => 'Total', 'value' => function ($model, $key, $index, $grid) {
return app\components\NumericLib::indoStyle($model['total'], 2, ',', '.');
}], ['attribute' => 'state', 'header' => 'Satatus']]]);
?>
<?php
} else {
?>
<?php
echo GridView::widget(['id' => 'prospectGrid', 'dataProvider' => $dataProvider, 'showPageSummary' => true, 'columns' => [['class' => 'kartik\\grid\\ExpandRowColumn', 'width' => '50px', 'value' => function ($model, $key, $index, $column) {
return GridView::ROW_COLLAPSED;
}, 'detailUrl' => \yii\helpers\Url::to(['sale-order/detail-grid']), 'headerOptions' => ['class' => 'kartik-sheet-style']], 'category', 'pricelist', ['attribute' => 'cout', 'header' => 'Count', 'value' => function ($model, $key, $index, $grid) {
return app\components\NumericLib::indoStyle($model['total'], 2, ',', '.');
}]]]);
?>
<?php
}
?>
</div>
</div>
<?php
}
}
?>
</div>
</div>
<td>31-60</td>
<td>61-90</td>
<td>90+</td>
</tr>
<?php
foreach ($data as $value) {
$debit = new Query();
$debit->select('sum(aml.debit)')->from('account_move_line as aml')->join('LEFT JOIN', 'account_move as am', 'am.id=aml.move_id')->where(['>=', 'aml.date', $date])->where(['aml.partner_id' => $value['partner_id']])->andWhere(['aml.account_id' => 56])->andWhere(['am.state' => 'posted']);
$debit = $debit->scalar();
$credit = new Query();
$credit->select('sum(aml.credit)')->from('account_move_line as aml')->join('LEFT JOIN', 'account_move as am', 'am.id=aml.move_id')->where(['>=', 'aml.date', $date])->where(['aml.partner_id' => $value['partner_id']])->andWhere(['aml.account_id' => 56])->andWhere(['am.state' => 'posted']);
$credit = $credit->scalar();
$hasil = $debit - $credit;
if ($hasil == 0 || $debit == 0) {
} else {
echo '<tr>';
echo '<td>' . $value['name'] . '--' . $value['partner_id'] . '</td>';
echo '<td>' . app\components\NumericLib::indoStyle($hasil, 2, ',', '.') . '</td>';
echo '<td>' . app\components\NumericLib::indoStyle($debit, 2, ',', '.') . '</td>';
echo '<td>' . app\components\NumericLib::indoStyle($credit, 2, ',', '.') . '</td>';
$tglharuskembali = '2013-1-30';
$tglkembali = '2013-2-3';
$selisih = strtotime($tglkembali) - strtotime($tglharuskembali);
echo "<td>Jadi selisih tanggalnya:" . $selisih . "</td>";
echo '</tr>';
}
}
?>
</table>
</div>
