<?php
	$sql = "SELECT *
			FROM bahan a, kategori_bahan b, satuan c
			WHERE a.id_kategori_bahan=b.id_kategori_bahan AND a.id_satuan = c.id_satuan
			ORDER BY nm_bahan ASC";
	$result = mysqli_query($koneksi, $sql);
?>

<table class="table-bordered table item" id="t1">
	<thead>
		<tr>
			<th width="35%" class="text-center">Nama Barang</th>
			<th width="19%" class="text-center">Harga</th>
			<th width="12%" class="text-center">Qty</th>
			<th width="14%" class="text-center">Satuan</th>
			<th width="20%" class="text-center">Total Harga</th>
			<th><button type="button" class="btn btn-success btn-sm addRow">+</button></th>
		</tr>
	</thead>
	<tbody>
		<tr class="item">
			<td>
				<select onchange="changeValue(this)" class="selectReason" id="reason" name="reasontxt[]" required>
					<option value=""  selected="" disabled="">-- Silahkan Pilih --</option>
					<optgroup label="Nama Bahan Baku">
						<?php
							while ($row = mysqli_fetch_array($result)) {
								echo '<option value="' . $row['nm_bahan'] . '">' . $row['nm_bahan'] . '</option>';
							}
						?>
					</optgroup>
				</select>
			</td>

			<td>
				<input type="text" name="harga[]" placeholder="Harga" class="harga form-control price amount" onkeypress="return hanyaAngka(event)" autocomplete="off" required />
			</td>
			<td>
				<input type="text" name="qty[]" placeholder="Qty" class="form-control qnty amount" value="0" onkeypress="return hanyaAngka(event)" autocomplete="off" required />
			</td>
			<td>
				<input type="text" name="satuan[]" placeholder="Satuan" class="satuan form-control" onkeypress="return hanyaAngka(event)" readonly>
			</td>
			<td>
				<input type="text" name="harga_total[]" placeholder="Total Harga" class="form-control totalharga" onkeypress="return hanyaAngka(event)" autocomplete="off" readonly />
			</td>
		</tr>
	</tbody>
</table>

<script type="text/javascript">

	<?php
		$jsArray = "var prdName = new Array();\n";

		mysqli_data_seek($result, 0);

		while ($row = mysqli_fetch_array($result)) {
			$jsArray .= "prdName['" . $row['nm_bahan'] . "'] = {id_satuan:'" . addslashes($row['nm_satuan']) . "', harga:'".addslashes($row['harga'])."'};\n";
		}

		echo $jsArray;
	?>

    function changeValue(selection){
		var id = selection.value;
		var row = $(selection).closest(".item");

		row.find(".harga").value = prdName[id].harga;
		row.find(".satuan").value = prdName[id].id_satuan;
	}

    function calcAll() {

        $(".item").each(function () {
            var qnty = 0;
            var price = 0;
            var totalharga = 0;
            var diskon = 0;
            var uangmuka = 0;

            if (!isNaN(parseInt($(this).find(".qnty").val()))) {
                qnty = parseInt($(this).find(".qnty").val());
            }
            if (!isNaN(parseInt($(this).find(".price").val()))) {
                price = parseInt($(this).find(".price").val());
            }
            if (!isNaN(parseInt($(this).find(".uangmuka").val()))) {
                uangmuka = parseInt($(this).find(".uangmuka").val());
            }
            if (!isNaN(parseInt($(this).find(".diskon").val()))) {
                diskon = parseInt($(this).find(".diskon").val());
            }


            totalharga = qnty * price;
            $(this).find(".totalharga").val(totalharga.toFixed());
        });

        var sum = 0;
        $(".totalharga").each(function () {
            if (!isNaN(this.value) && this.value.length != 0) {
                sum += parseInt(this.value);
            }
        });
        $("#subtotal").val(sum.toFixed());


        var diskon = 0;
        if (!isNaN(parseInt($("#diskon").val()))) {
            diskon = parseInt($("#diskon").val());
            }


        var total = 0;
        if (!isNaN(parseInt($("#total").val()))) {
            total = parseInt($("#total").val());
            }
        total = sum - (sum*(diskon/100));
        $("#total").val(total.toFixed());
    }

    window.onload=function(){

        $(document).ready(function () {

            var r = 1;
            $('.addRow').click(function () {
                r++;
                $('#t1').append('<tr id="row' + r + '" class="item"><td><select onchange="changeValue(this)" class="selectReason" id="reason" name="reasontxt[]" required><option value=""  selected="" disabled="">-- Silahkan Pilih --</option><optgroup label="Nama Bahan Baku"><?php mysqli_data_seek($result, 0); while ($row = mysqli_fetch_array($result)) { echo '<option value="' . $row['nm_bahan'] . '">' . $row['nm_bahan'] . '</option>'; }?></optgroup></select></td><td><input type="text" name="harga[]" placeholder="Harga" class="harga form-control price amount" onkeypress="return hanyaAngka(event)" autocomplete="off" required /></td><td><input type="text" name="qty[]" placeholder="Qty" class="form-control qnty amount" value="0" onkeypress="return hanyaAngka(event)" autocomplete="off" required /></td><td><input type="text" name="satuan[]" placeholder="Satuan" class="satuan form-control" onkeypress="return hanyaAngka(event)" readonly/></td><td><input type="text" name="harga_total[]" placeholder="Total Harga" class="form-control totalharga" onkeypress="return hanyaAngka(event)" autocomplete="off" readonly /></td><td><button type="button" name="remove" id="' + r + '" class="btn btn-danger btn-sm btn_remove">x</button></td></tr>');
                $(".selectReason").select2({dropdownParent: $('#TambahData .modal-content'),width:'100%'});
            });

            $(document).on('click', '.btn_remove', function () {
                var button_id = $(this).attr("id");
                $('#row' + button_id + '').remove();
                calcAll();
            });

            $(document).on("keyup", ".amount", calcAll);
        });

    }
</script>