public function table_debet()
{
$param = $this->input->post();
$data = $this->mr->getDataDebet($param);
$table = '';
$i = 1;
foreach ($data->result() as $key => $value) {
if ($value->claimed == 'no') {
$claimed = '<span class="label label-sm label-danger">Unclaimed</span>';
} else {
$claimed = '<span class="label label-sm label-success">Claimed</span>';
}
$table .= '
<tr>
<td width="50px">' . $i . '</td>
<td>' . $value->bank . '</td>
<td style="text-align:right;">' . format_rupiah($value->jumlah) . '</td>
<td>' . $claimed . '</td>
</tr>
';
$i++;
}
$table_null = '
<tr>
<td colspan="10">Tidak ada data.</td>
</tr>
';
echo isset($value) ? $table : $table_null;
}
function get_list_cashdraw($param = '')
{
$sql = "SELECT * FROM view_selling_cashdraw WHERE `date` = ? AND user_id = ?";
$hasil = $this->db->query($sql, array($param['tgl_awal'], $param['pegawai']));
$data = $hasil->result();
$list = "";
if ($data != null) {
foreach ($data as $das => $value) {
$selisih = $value->total_cash - $value->end_cash;
$list .= '
<tr>
<td class="text-center">' . $value->cashdraw_no . '</td>
<td>' . format_rupiah($value->start_cash) . '</td>
<td>' . format_rupiah($value->omset) . '</td>
<td>' . format_rupiah($value->total_cash) . '</td>
<td>' . format_rupiah($value->end_cash) . '</td>
<td>' . format_rupiah($selisih) . '</td>
<td>' . $value->nama . '</td>
<td>' . $value->status . '</td>
<td class="text-center">
<a onclick="print(this.id)" id="' . $value->id . '" data-toggle="modal" href = "#modal-note" title="Print" class="btn btn-xs btn-default"><i class="icon-print"></i> Print</a>
</td>
</tr>
';
}
} else {
$list .= '
<tr>
<td colspan="6">No data to view...</td>
</tr>
';
}
return $list;
}
public function product_detail()
{
$product = $this->product->get_product($_GET['id']);
$product_related = $this->product->get_all_product('related', 'published', 'all_records', $product['id_product_category']);
$total_product_related = $this->product->get_all_product('related', 'published', 'total_data', $product['id_product_category']);
$brand = $this->brand->get_brand($product['id']);
if (isset($_SESSION['user_type']) && isset($_SESSION[''])) {
$user_name = '';
} else {
$user_name = '';
}
if ($product['status'] == 0) {
$status = 'Belum Tersedia';
} else {
$status = 'Tersedia';
}
$this->view->assign('captcha_src', SITE_CAPTCHA_SRC);
$this->view->assign('product_brand', $brand['name']);
$this->view->assign('product_status', $status);
$this->view->assign('product_name', $product['name']);
$this->view->assign('product_price', format_rupiah($product['price']));
$this->view->assign('product_description', $product['description']);
$this->view->assign('product_img_thumb', $this->img_dir . 'thumb_' . $product['image']);
$this->view->assign('product_img', $this->img_dir . $product['image']);
$this->view->assign('total_product_related', $total_product_related);
$this->view->assign('product_related', $product_related);
parent::fetch('product/product_detail', 'module');
}
function FancyTable($header, $data)
{
// Colors, line width and bold font
$this->SetFillColor(255, 165, 74);
$this->SetTextColor(255);
$this->SetDrawColor(128, 0, 0);
$this->SetLineWidth(0.2);
$this->SetFont('', 'B');
// Header
$w = array(10, 10, 35, 70, 30, 20, 10);
for ($i = 0; $i < count($header); $i++) {
$this->Cell($w[$i], 7, $header[$i], 1, 0, 'C', true);
}
$this->Ln();
// Color and font restoration
$this->SetFillColor(224, 235, 255);
$this->SetTextColor(0);
$this->SetFont('');
// Data
$fill = false;
foreach ($data as $row) {
$this->Cell($w[0], 6, $row[0], 'LR', 0, 'L', $fill);
$this->Cell($w[1], 6, $row[1], 'LR', 0, 'L', $fill);
$this->Cell($w[2], 6, $row[2], 'LR', 0, 'L', $fill);
$this->Cell($w[3], 6, $row[3], 'LR', 0, 'L', $fill);
$this->Cell($w[4], 6, $row[4], 'LR', 0, 'L', $fill);
$this->Cell($w[5], 6, format_rupiah($row[5]), 'LR', 0, 'R', $fill);
$this->Cell($w[6], 6, $row[6], 'LR', 0, 'L', $fill);
$this->Ln();
$fill = !$fill;
}
// Closing line
$this->Cell(array_sum($w), 0, '', 'T');
}
function get_list_produk($reference)
{
$sql = "SELECT * FROM atombizz_retur_internal_tmp WHERE reference='{$reference}' order by id asc";
$data = $this->db->query($sql);
$list = '';
$i = 1;
foreach ($data->result() as $das) {
$list .= '
<tr>
<td class="text-center">' . $i . '</td>
<td>' . $das->product_name . '</td>
<td>' . $das->quantity . '</td>
<td>' . format_rupiah($das->hpp) . '</td>
<td class="text-right">' . format_rupiah($das->sub_total) . '</td>
<td class="text-center">
<a onclick="actEdit(' . $das->id . ')" data-toggle="tooltip" title="Edit" class="btn btn-xs btn-default"><i class="icon-pencil"></i></a>
<a onclick="actDel(' . $das->id . ')" data-toggle="tooltip" title="Delete" class="btn btn-xs btn-default"><i class="icon-remove"></i></a>
</td>
</tr>
';
$i++;
}
$list_null = '
<tr>
<td colspan="6">No data to view...</td>
</tr>
';
return $list != '' ? $list : $list_null;
}
public function saldo()
{
$param = $this->input->post();
$data = $this->mp->saldo($param);
if ($data) {
$data->saldo_show = format_rupiah($data->saldo);
echo json_encode($data);
} else {
echo FALSE;
}
}
function diskon()
{
// diskon
$harga = format_rupiah($r[harga]);
$disc = $r[diskon] / 100 * $r[harga];
$hargadisc = number_format($r[harga] - $disc, 0, ",", ".");
$d = $r['diskon'];
$hargatetap = "<span class='price'> <br /></span> \n <span style=\"color:#ff6600;font-size:14px;\"> Rp. <b>{$hargadisc},-</b></span>";
$hargadiskon = "<span style='text-decoration:line-through;font-size:14px;' class='price'>Rp. {$harga} <br /></span>\n\t\t\t\t\t<div style='text-align=center;font-size:14px;'> diskon {$d}%</div> \n <span style=\"color:#ff6600;font-size:14px;\"> Rp. <b>{$hargadisc},-</b></span>";
if ($d != 0) {
$divharga = $hargadiskon;
} else {
$divharga = $hargatetap;
}
}
public function get_all_product($view = '', $attr = '', $mode = '', $id_pcategory = '')
{
parent::model('select');
$this->db->select();
$this->db->table($this->db_table);
if ($attr == 'published') {
$this->db->where('publish = "Y"');
} else {
if ($attr == 'unpublished') {
$this->db->where('publish = "N"');
}
}
if ($view == 'featured') {
$this->db->where_and('featured = "Y"');
} else {
if ($view == 'latest') {
$this->db->order('created');
$this->db->sort('DESC');
$this->db->limit('5');
} else {
if ($view == 'related') {
$this->db->where_and('id_product_category = "' . $id_pcategory . '"');
$this->db->limit('5');
}
}
}
$query = $this->db->build();
if ($mode == 'total_data') {
return $this->db->num_rows($query);
} else {
if ($mode == 'all_records') {
$no = 0;
while ($product = $this->db->fetch_array($query)) {
$data[] = array('no' => $no, 'id' => $product['id'], 'id_user' => $product['id_user'], 'id_product_category' => $product['id_product_category'], 'id_product_brand' => $product['id_product_brand'], 'name' => $product['name'], 'image' => $product['image'], 'price' => format_rupiah($product['price']), 'stock' => $product['stock'], 'status' => $product['status'], 'description' => $product['description'], 'featured' => $product['featured'], 'meta_desc' => $product['meta_desc'], 'meta_key' => $product['meta_key'], 'publish' => $product['publish'], 'created' => $product['created'], 'updated' => $product['updated']);
$no++;
}
return $data;
}
}
}
public function view_cart($mode = '')
{
parent::model('custom');
$this->db->custom(' SELECT * FROM order_temp, product
WHERE session_id = "' . session_id() . '"
AND order_temp.id_product=product.id');
$query = $this->db->build();
$total = 0;
$data = '';
while ($cart = $this->db->fetch_array($query)) {
$subtotal = $cart['price'] * $cart['qty'];
$total = $total + $subtotal;
$data[] = array('id' => $cart['id'], 'session_id' => $cart['session_id'], 'id_product' => $cart['id_product'], 'product_name' => $cart['name'], 'product_price' => format_rupiah($cart['price']), 'qty' => $cart['qty'], 'subtotal' => format_rupiah($subtotal));
}
if ($mode == 'totalbuy') {
return format_rupiah($total);
} else {
if ($mode == 'totaldata') {
return $this->db->num_rows($query);
} else {
return $data;
}
}
}
public function saldo()
{
$param = $this->input->post();
$data = $this->mp->get_saldo($param['faktur']);
echo format_rupiah($data);
}
</td>
<td><?php
echo $analisis->lab;
?>
</td>
<td><?php
echo $analisis->jenis_conto;
?>
</td>
<td><?php
echo $analisis->nama_pemohon;
?>
</td>
<td><?php
echo tanggal_format_indonesia($analisis->tanggal_terima);
?>
</td>
<td><?php
echo format_rupiah($analisis->biaya);
?>
</td>
<td><?php
echo !$analisis->is_cancel ? 'PROSES' : 'CANCEL';
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
<th>Gaji</th>
<th>TMT</th>
<th></th>
</tr>
</thead>
<tbody>
<?php
if (count($daftar_gaji) > 0) {
foreach ($daftar_gaji as $d) {
?>
<tr id="t_<?php
echo $d['id_gaji'];
?>
">
<td align="right">Rp <?php
echo format_rupiah($d['gaji']);
?>
</td>
<td><?php
echo format_tanggal_tampilan($d['TMT']);
?>
</td>
<td>
<a onclick="hapus(<?php
echo $d['id_gaji'];
?>
); return false;" href="#">Hapus</a>
</td>
</tr>
<?php
}
function get_list_produk_retur_out($reference)
{
$sql = "SELECT * FROM atombizz_retur_out_detail WHERE reference='{$reference}' order by id asc";
$data = $this->db->query($sql);
$list = '';
$i = 1;
foreach ($data->result() as $das) {
// $hpp = ($das->unit_price - ($das->unit_price*$das->disc_reg/100) + ($das->unit_price*$das->tax_amount/100));
$subtotal = $das->hpp * $das->quantity;
$list .= '
<tr>
<td class="text-center">' . $i . '</td>
<td>' . $das->product_name . '</td>
<td class="money">' . $das->quantity . '</td>
<td>' . format_rupiah($das->hpp) . '</td>
<td>' . format_rupiah($subtotal) . '</td>
<td class="text-center">
<a onclick="actEdit(' . $das->id . ')" data-toggle="tooltip" title="Edit" class="btn btn-xs btn-default"><i class="icon-pencil"></i></a>
</td>
</tr>
';
$i++;
}
$list_null = '
<tr>
<td colspan="6">No data to view...</td>
</tr>
';
return $list != '' ? $list : $list_null;
}
echo $rows->nama;
?>
</td>
<td><a href='index.php?mod=invoice&pg=invoice_detail&id=<?php
echo $rows->noinvoice;
?>
'><?php
echo $rows->noinvoice;
?>
</a></td>
<td><?php
echo $rows->tanggal;
?>
</td>
<td><?php
echo format_rupiah($rows->totalbayar);
?>
</td>
<td><?php
echo get_status_invoice($rows->transfer);
?>
</td>
<td><?php
echo tglkirim($rows->tglkirim);
?>
</td>
<td>
<th>Jumlah</th>
<th>Pilih</th>
</tr>
</thead>
<tbody>
<?php
$qpembayaran = mysql_query("SELECT * FROM pembayaran WHERE nama!='Topup' ORDER BY created_at DESC");
while ($pembayaran = mysql_fetch_object($qpembayaran)) {
?>
<tr>
<td><?php
echo $pembayaran->nama;
?>
</td>
<td><?php
echo format_rupiah($pembayaran->jumlah);
?>
</td>
<td>
<form action="transaksi_create.php" method="post">
<button class="btn btn-warning" name="id" value="<?php
echo $pembayaran->id;
?>
">Pilih</button>
<input type="hidden" name="submit_type" value="add_session_id_pembayaran">
<input type="hidden" name="key" value="bulbasaur">
</form>
</td>
</tr>
<?php
}
?>
</td>
<td><?php
echo strtoupper($row->id_type_analisis);
?>
</td>
<td><?php
echo $row->nama;
?>
</td>
<td><?php
echo $row->id_lab;
?>
</td>
<td><?php
echo format_rupiah($row->harga);
?>
</td>
<td><a href="<?php
echo base_url('type_analisis/detail/' . $row->id_type_analisis);
?>
" class="btn btn-info">Detail</a> </td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
</div>
</tr>
<tr>
<td><?php
echo $r->kode;
?>
</td>
<td><?php
echo $r->nama_pembayaran;
?>
</td>
<td><?php
echo tanggal_format_indonesia($r->tanggal, TRUE);
?>
</td>
<td><?php
echo format_rupiah($r->jumlah);
?>
</td>
</tr>
</table>
</div>
<div class="footer">
<div class="tandatangan">
Petugas Tata Usaha,
<br>
<br>
<br>
<br>
<br>
<br>
$this->thoni_fpdf->SetAligns(array('C', 'C', 'C', 'C', 'C', 'C', 'C', 'C'));
$this->thoni_fpdf->Row(array('No.', 'Tanggal', 'Referensi', 'Kode Produk', 'Nama Produk', 'Qty', 'Price', 'Subtotal'));
$no = 1;
$i = 0;
$total = 0;
$this->thoni_fpdf->SetFont('helvetica', '', 9);
foreach ($retur->result() as $key => $value) {
$this->thoni_fpdf->SetAligns(array('C', 'C', 'L', 'C', 'C', 'C', 'C', 'R'));
$this->thoni_fpdf->Row(array($no, $value->tgl, $value->referensi, $value->code_produk, $value->code_name, $value->qty, format_rupiah($value->price), format_rupiah($value->tot)));
$total += $value->tot;
$no++;
}
// $status = ($total < 0) ? '(Kurang)' : '(Kelebihan)';
$this->thoni_fpdf->SetWidths(array(21, 6));
$this->thoni_fpdf->SetAligns(array('C', 'R'));
$this->thoni_fpdf->Row(array('TOTAL ', format_rupiah(abs($total))));
//The first param should be the width of text area
//0 value will make the FPDF automate the width
//The second param is the line spacing for this paragraph
//The third param is the text
// $this->thoni_fpdf->WriteTag(19,0.7, $text, 1, "J", 0, 7);
/* setting posisi footer 3 cm dari bawah */
$this->thoni_fpdf->SetY(-3);
/* setting font untuk footer */
$this->thoni_fpdf->SetFont('helvetica', '', 9);
/* setting cell untuk waktu pencetakan */
$this->thoni_fpdf->Cell(19, 0.5, 'Printed on : ' . tanggalIndo(date('Y-m-d')) . ' | ' . date('H:i:s'), 0, 'LR', 'L');
// $this->thoni_fpdf->Cell(-5);
$this->thoni_fpdf->Cell(28, 0.5, 'Created by : Atombizz.', 0, 'LR', 'L');
/* setting cell untuk page number */
// $this->thoni_fpdf->Cell(24.5, 0.5, 'Page '.$this->thoni_fpdf->PageNo().'/{nb}',0,0,'R');
$id_book = $_POST['id_book'];
$total = 0;
$count = "select sum(harga_sparepart) as total from detail_book where id_book='" . $id_book . "'";
$sql = "select detail_book.id_book, detail_book.id_sparepart, sparepart.nama_sparepart, detail_book.harga_sparepart from detail_book right join sparepart on detail_book.id_sparepart = sparepart.id_sparepart where detail_book.id_book = '" . $id_book . "'";
// $sql = " select detail_book.id_book,user.nama,kendaraan.nama_kendaraan,booking.tanggal,servis.jenis_servis,servis.harga_servis,sparepart.nama_sparepart,sparepart.harga_sparepart,booking.status from detail_book natural join booking natural join servis natural join sparepart natural join user natural join kendaraan where detail_book.id_book='".$id_book."'";
$result = mysqli_query($db, $sql);
if (mysqli_num_rows($result) > 0) {
// output data of each row
while ($row = mysqli_fetch_assoc($result)) {
$total = $total + $row['harga_sparepart'];
echo "<tr>\n <td>" . @$row['id_book'] . "</td> \n <td>" . @$row['id_sparepart'] . "</td> \n <td>" . @$row['nama_sparepart'] . "</td> \n <td>" . format_rupiah(@$row['harga_sparepart']) . "</td>\n </tr>\n ";
}
} else {
echo "0 results";
}
echo "<tr>\n <td>SubTotal</td>\n <td></td>\n <td></td>\n <td>" . format_rupiah($total) . "</td>\n </tr>";
$query = "select detail_book.id_servis, servis.jenis_servis, detail_book.harga_servis from detail_book inner join servis on detail_book.id_servis = servis.id_servis where detail_book.id_book='" . $id_book . "'";
$koneksi = mysql_connect('localhost', 'root', '');
mysql_select_db('suzuki');
$ambildata = mysql_query($query, $koneksi);
if (!$ambildata) {
die('Gagal ambil data: ' . mysql_error());
}
$row = mysql_fetch_assoc($ambildata);
echo "ID servis :{$row['id_servis']} <br> " . "jenis_servis : {$row['jenis_servis']} <br> " . "harga_servis : {$row['harga_servis']} <br> " . "Total Servis dan Sparepart =" . ($total1 = $row['harga_servis'] + $total . "<br>" . "--------------------------------<br>");
mysql_close($koneksi);
?>
</tbody>
</table>
?>
</td>
<td><?php
echo format_rupiah($transaksi->jumlah);
?>
</td>
<td><?php
echo tanggal_format_indonesia($transaksi->tanggal);
?>
</td>
<td><?php
echo $transaksi->nama_pembayaran;
?>
</td>
<td><?php
echo format_rupiah($transaksi->saldo);
?>
</td>
</tr>
</tbody>
</table>
</div><!-- /.Left col -->
</div><!-- /.row (main row) -->
</section><!-- /.content -->
<?php
include 'inc/footer.php';
?>
<script type="text/javascript">
// Your application has indicated there's an error
<label class="control-label col-md-3">Gaji Pokok:</label>
<div class="col-md-9">
<p class="form-control-static"><?php
echo format_rupiah(@$paramedik->gaji);
?>
</p>
</div>
</div>
</div>
<!--/span-->
<!-- <div class="col-md-6">
<div class="form-group">
<label class="control-label col-md-3">Bonus:</label>
<div class="col-md-9">
<p class="form-control-static"><?php
echo format_rupiah(@$paramedik->bonus);
?>
</p>
</div>
</div>
</div> -->
<!--/span-->
</div>
</div>
<div class="form-actions fluid">
<div class="row">
<div class="col-md-6">
<div class="col-md-offset-3 col-md-9">
<button onclick="actEdit()" type="button" class="btn green"><i class="icon-pencil"></i> Edit</button>
<button onclick="actCancel()" type="button" class="btn default">Cancel</button>
</div>
function showchart()
{
$chart = $_SESSION['chart'];
// print_r($chart);
if ($chart) {
$items = explode(',', $chart);
$contents = array();
foreach ($items as $item) {
$contents[$item] = isset($contents[$item]) ? $contents[$item] + 1 : 1;
}
$output[] = "<table class=\"table table-striped \">";
$output[] = "<th><td>Nama</td><td> Harga</td><td>jumlah</td><td>subtotal</td><td>Aksi</td></th>";
$output[] = '<form action="index.php?mod=chart&pg=chart&action=update" method="post" id="chart">';
$no = 1;
foreach ($contents as $id => $qty) {
$sql = "SELECT produk.*,stok.harga_jual from produk,stok WHERE produk.idproduk = '{$id}' and stok.idproduk = '{$id}'";
$result = mysql_query($sql);
$row = mysql_fetch_object($result);
$output[] = '<tr><td>' . $no . '</td>';
$output[] = '<td><img src=\'upload/produk/' . $row->foto;
$output[] = '\' width=\'128px\' height=\'128px\'><br> ' . $row->nama_produk . '</td><td>' . format_rupiah($row->harga_jual) . '</td>';
$output[] = '<td><input type="text" class="input-mini" name="qty' . $id . '" value="' . $qty . '" /></td>';
$output[] = '<td>' . format_rupiah($row->harga_jual * $qty) . '</td>';
$total += $row->harga_jual * $qty;
$output[] = '<td><a href="index.php?mod=chart&pg=chart&action=delete&id=' . $id . '" class="btn btn-danger">Hapus</a></td></tr>';
$no++;
}
$output[] = "</table>";
$qty = getQty();
$output[] = '<h3>Total Transaksi : ' . format_rupiah($total) . '</h3>';
$_SESSION['totalbayar'] = $total;
$output[] = '<button type="submit" class=\'btn btn-primary\'>Update cart</button>';
$output[] = '</form>';
$output[] = '<a href=\'chart/chart_action.php\' class=\'btn btn-primary\'>Check out</a>';
} else {
$output[] = '<p>Keranjang belanja masih kosong.</p>';
}
return join('', $output);
}
public function detail_retur_out()
{
$uri = $this->input->post('id');
$data = $this->mp->detail_retur_out($uri);
$data['nominal'] = format_rupiah($data['sub_total']);
echo json_encode($data);
// $data['id'].'|'.$data['product_id'].'|'.$data['product_code'].'|'.$data['product_name'].'|'.$data['quantity'].'|'.$data['unit_price'].'|'.$data['tax_amount'].'|'.$data['disc_reg'];
}
echo $posisi + $no;
?>
</td>
<td>
<?php
echo $rows->nama_produk;
?>
</td>
<td align='right'>
<?php
echo format_rupiah($rows->harga_beli);
?>
</td>
<td align='right'>
<?php
echo format_rupiah($rows->harga_jual);
?>
</td>
<td align='right'>
<?php
echo $rows->jumlah;
?>
</td>
<td>
<a href="index.php?mod=stok&pg=stok_form&id=<?php
echo $rows->supplier_id;
?>
" class='btn btn-xs btn-info'>
<i class="icon-pencil"></i>
</a>
<a href="index.php?mod=stok&pg=stok_view&act=del&id=<?php
$xls->getActiveSheet()->getRowDimension('14')->setRowHeight(20);
$j = $this->pegawai->get_jabatan_terakhir($pegawai['id_pegawai']);
$xls->getActiveSheet()->setCellValue('A15', "10");
$xls->getActiveSheet()->setCellValue('B15', "J a b a t a n");
$xls->getActiveSheet()->setCellValue('C15', " : " . $j['jabatan']);
$xls->getActiveSheet()->getStyle('B15:C15')->getFont()->setSize(10);
$xls->getActiveSheet()->getRowDimension('15')->setRowHeight(20);
$xls->getActiveSheet()->setCellValue('A16', "11");
$xls->getActiveSheet()->setCellValue('B16', "Unit Kerja");
$xls->getActiveSheet()->setCellValue('C16', " : DINAS KESEHATAN KOTA BOGOR");
$xls->getActiveSheet()->getStyle('B16:C16')->getFont()->setSize(10);
$xls->getActiveSheet()->getRowDimension('16')->setRowHeight(20);
$k = $this->pegawai->get_gaji_terakhir($pegawai['id_pegawai']);
$xls->getActiveSheet()->setCellValue('A17', "12");
$xls->getActiveSheet()->setCellValue('B17', "Gaji Pokok / PP");
$xls->getActiveSheet()->setCellValue('C17', " : Peraturan Pemerintah Nomor 25 Tahun 2010 Rp." . format_rupiah($k['gaji']));
$xls->getActiveSheet()->getStyle('B17:C17')->getFont()->setSize(10);
$xls->getActiveSheet()->getRowDimension('17')->setRowHeight(20);
$mkg = $this->pegawai->get_masa_kerja_golongan($pegawai['id_pegawai']);
$mks = $this->pegawai->get_masa_kerja_keseluruhan($pegawai['id_pegawai']);
$xls->getActiveSheet()->setCellValue('A18', "13");
$xls->getActiveSheet()->setCellValue('B18', "Masa kerja golongan");
$xls->getActiveSheet()->setCellValue('C18', " : " . $mkg['masa_kerja_tahun'] . " Tahun " . $mkg['masa_kerja_bulan'] . " Bulan");
$xls->getActiveSheet()->getStyle('B18:C18')->getFont()->setSize(10);
$xls->getActiveSheet()->getRowDimension('18')->setRowHeight(20);
$xls->getActiveSheet()->setCellValue('A19', "14");
$xls->getActiveSheet()->setCellValue('B19', "Masa kerja keseluruhan");
$xls->getActiveSheet()->setCellValue('C19', " : " . $mks['masa_kerja_tahun'] . " Tahun " . $mks['masa_kerja_bulan'] . " Bulan");
$xls->getActiveSheet()->getStyle('B19:C19')->getFont()->setSize(10);
$xls->getActiveSheet()->getRowDimension('19')->setRowHeight(20);
$xls->getActiveSheet()->setCellValue('A20', "15");
<th data-field="jenis_servis" rowspan="2">Jenis Servis</th>
<th data-field="harga_servis" rowspan="2">Harga Servis</th>
<th data-field="id_sparepart" rowspan="2">Id Sparepart</th>
<th data-field="nama_sparepart" rowspan="2">Sparepart</th>
<th data-field="harga_sparepart" rowspan="2">Harga Sparepart</th>
</tr>
</thead>
<tbody>
<?php
$sql = "SELECT user.nama,booking.nopol,kendaraan.nama_kendaraan,booking.tanggal,detail_book.id_servis,servis.jenis_servis,servis.harga_servis,detail_book.id_sparepart,sparepart.nama_sparepart,sparepart.harga_sparepart from booking natural join detail_book natural join servis natural join sparepart natural join kendaraan natural join user where booking.nopol='" . $nopol . "'";
$result = mysqli_query($db, $sql);
if (mysqli_num_rows($result) > 0) {
// output data of each row
while ($row = mysqli_fetch_assoc($result)) {
echo "<tr>\n <td>" . @$row['nama'] . "</td> \n <td>" . @$row['nama_kendaraan'] . "</td> \n <td>" . @$row['tanggal'] . "</td>\n <td>" . @$row['id_servis'] . "</td>\n <td>" . @$row['jenis_servis'] . "</td> \n <td>" . format_rupiah(@$row['harga_servis']) . "</td>\n <td>" . @$row['id_sparepart'] . "</td>\n <td>" . @$row['nama_sparepart'] . "</td>\n <td>" . format_rupiah(@$row['harga_sparepart']) . "</td>\n </tr>";
}
} else {
echo "0 results";
}
?>
</tbody>
</table>
</div>
</div>
<a class="btn btn-flat waves-effect" href="index.php">Kembali</a>
</form>
</div>
</body>
</html>
<?php
// diskon
$harga = format_rupiah($r[harga]);
$disc = $r[diskon] / 100 * $r[harga];
$hargadisc = number_format($r[harga] - $disc, 0, ",", ".");
$d = $r['diskon'];
$hargatetap = "<span class='price'> <br /></span> \r\n <span style=\"color:#ff6600;font-size:14px;\"> Rp. <b>{$hargadisc},-</b></span>";
$hargadiskon = "<span style='text-decoration:line-through;' class='price'>Rp. {$harga} <br /></span> diskon {$d}% \r\n <span style=\"color:#ff6600;font-size:14px;\"> Rp. <b>{$hargadisc},-</b></span>";
if ($d != 0) {
$divharga = $hargadiskon;
} else {
$divharga = $hargatetap;
}
// tombol stok habis kalau stoknya 0
$stok = $r['stok'];
$tombolbeli = "<a class='prod_cart' href=\"aksi.php?module=keranjang&act=tambah&id={$r['id_produk']}\">beli</a>";
$tombolhabis = "<span class='prod_cart_habis'>habis</span>";
if ($stok != 0) {
$tombol = $tombolbeli;
} else {
$tombol = $tombolhabis;
}
<tr> <td align="right">Total Kas : </td><td align="right"><?php echo format_rupiah($cashdraw->total_cash); ?> </td> </tr> <tr> <td align="right">Kas Akhir : </td><td align="right"><?php echo format_rupiah($cashdraw->end_cash); ?> </td> </tr> <?php $selisih = $cashdraw->total_cash - $cashdraw->end_cash; $status = $selisih < 0 ? 'Lebih' : 'Kurang'; ?> <tr> <td align="right"><?php echo $status; ?> : </td><td align="right"><?php echo format_rupiah(abs($selisih)); ?> </td> </tr> </tbody> </table> </div> </body> </html>
</div>
<div class="desc">Kas Non-tunai</div>
</div>
<!-- <a class="more" href="#">
View more <i class="m-icon-swapright m-icon-white"></i>
</a> -->
</div>
</div>
<div class="col-lg-3 col-md-3 col-sm-6 col-xs-12">
<div style="margin-bottom:0px;" class="dashboard-stat purple">
<div class="visual">
<!-- <i class="icon-bar-chart"></i> -->
</div>
<div class="details">
<div class="number"><?php
echo format_rupiah($stats->omset);
?>
</div>
<div class="desc">Total Omset</div>
</div>
<!-- <a class="more" href="#">
View more <i class="m-icon-swapright m-icon-white"></i>
</a> -->
</div>
</div>
</div>
<!-- END DASHBOARD STATS -->
<ul style="width:64%;" class="col-md-9 page-breadcrumb breadcrumb">
<li>
<i class="icon-home"></i>
<a href="<?php
$pilihan_order = '';
foreach ($pilihan_status as $status) {
$pilihan_order .= "<option value={$status}";
if ($status == $r[status_order]) {
$pilihan_order .= " selected";
}
$pilihan_order .= ">{$status}</option>\r\n";
}
echo "<div class='top_admin_box'><h2>Detail Order</h2></div>\r\n <form method=POST action={$aksi}?module=order&act=update>\r\n <input type=hidden name=id value={$r['id_orders']}>\r\n <table>\r\n <tr><td>No. Order</td> <td> : {$r['id_orders']}</td></tr>\r\n <tr><td>Tgl. & Jam Order</td> <td> : {$tanggal} & {$r['jam_order']}</td></tr>\r\n <tr><td>Status Order </td><td>: <select name=status_order>{$pilihan_order}</select> \r\n <input type=submit value='Ubah Status'></td></tr>\r\n </table></form>";
// tampilkan rincian produk yang di order
$sql2 = mysql_query("SELECT * FROM orders_detail, produk \r\n WHERE orders_detail.id_produk=produk.id_produk \r\n AND orders_detail.id_orders='{$_GET['id']}'");
echo "<table border=0 width=500>\r\n <tr><th>Nama Produk</th><th>Jumlah</th><th>Harga Satuan</th><th>Sub Total</th></tr>";
while ($s = mysql_fetch_array($sql2)) {
// rumus untuk menghitung subtotal dan total
$subtotal = $s[harga] * $s[jumlah];
$total = $total + $subtotal;
$subtotal_rp = format_rupiah($subtotal);
$total_rp = format_rupiah($total);
$harga = format_rupiah($s[harga]);
echo "<tr><td>{$s['nama_produk']}</td><td>{$s['jumlah']}</td><td>Rp. {$harga}</td><td>Rp. {$subtotal_rp}</td></tr>";
}
$ongkos = mysql_fetch_array(mysql_query("SELECT * FROM kota,orders WHERE orders.id_kota=kota.id_kota AND id_orders='{$_GET['id']}'"));
$ongkoskirim = $ongkos[ongkos_kirim];
$grandtotal = $total + $ongkoskirim;
$ongkoskirim_rp = format_rupiah($ongkoskirim);
$grandtotal_rp = format_rupiah($grandtotal);
echo "<tr><td colspan=3 align=right>Total : </td><td>Rp. <b>{$total_rp}</b></td></tr>\r\n <tr><td colspan=3 align=right>Ongkos Kirim : </td><td>Rp. <b>{$ongkoskirim_rp}</b></td></tr> \r\n <tr><td colspan=3 align=right>Grand Total : </td><td>Rp. <b>{$grandtotal_rp}</b></td></tr>\r\n </table>";
// tampilkan data kustomer
echo "<table border=0 width=500>\r\n <tr><th colspan=2>Data Kustomer</th></tr>\r\n <tr><td>Nama Pembeli</td><td> : {$r['nama_customer']}</td></tr>\r\n <tr><td>Alamat Pengiriman</td><td> : {$r['alamat']}</td></tr>\r\n <tr><td>No. Telpon/HP</td><td> : {$r['telpon']}</td></tr>\r\n <tr><td>Email</td><td> : {$r['email']}</td></tr>\r\n </table>";
break;
}
