<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>