break;
}
array_push($detail, $status);
array_push($detail, $btn);
array_push($collect, $detail);
unset($detail);
}
}
echo json_encode(array("data" => $collect));
}
break;
case "daftar-detail-po":
if (isset($_POST['idPO'])) {
$idDO = $_POST['idPO'];
$detail = array();
if ($query = $data->getDetailPO($idDO)) {
while ($rs = $query->fetch_array()) {
$tglkirim = $rs["tgl_kirim"] . " <button class='btn btn-sm btn-ubah-tgl-kirim btn-orange' id='btn-ubah-tgl-kirim' data-id='" . $rs[0] . "' data-idpo='" . $rs[1] . "'><i class='fa fa-calendar'></i></button>";
$tglsales = $rs["tgl_kirim_ke_sales"] . " <button class='btn btn-sm btn-ubah-tgl-kirim-sales btn-orange' id='btn-ubah-tgl-kirim-sales' data-id='" . $rs[0] . "' data-idpo='" . $rs[1] . "'><i class='fa fa-calendar'></i></button>";
$btn = "<button class='btn btn-sm btn-danger btn-delete-item-detail' id='btn-delete-item-detail' data-id='" . $rs[0] . "' data-idpo='" . $rs[1] . "'><i class='fa fa-trash'></i></button>";
$luas = $rs["panjang"] * $rs["lebar"] * $rs["jml"];
$detail[] = array("gsm" => $rs["bahan"], "deskripsi" => $rs["deskripsi"], "tema" => $rs["tema"], "ukuran" => $rs["panjang"] . " x " . $rs["lebar"], "jml" => $rs["jml"], "luas" => $luas, "unit" => "Rp " . number_format($rs["harga/m"], 0, ",", "."), "subtotal" => "Rp " . number_format($rs["subtotal"], 0, ",", "."), "tglsales" => $tglsales, "tglkirim" => $tglkirim, "btn" => $btn);
}
}
echo json_encode($detail);
}
break;
case "acc-daftar-detail-po":
if (isset($_POST['idPO'])) {
$idDO = $_POST['idPO'];
$detail = array();
// WRITE REPORT SUMMARY
$objExcel->getActiveSheet()->SetCellValue('A4', $nama);
$objExcel->getActiveSheet()->SetCellValue('A5', $alamat);
$objExcel->getActiveSheet()->SetCellValue('A6', "Tel. " . $telp);
$objExcel->getActiveSheet()->SetCellValue('A7', "Email " . $email);
$objExcel->getActiveSheet()->SetCellValue('A8', "CP. " . $cp);
$objExcel->getActiveSheet()->SetCellValue('G4', $noPO);
$objExcel->getActiveSheet()->SetCellValue('G5', $tglPO);
$objExcel->getActiveSheet()->SetCellValue('G6', $top);
$objExcel->getActiveSheet()->SetCellValue('G7', $tglKirim);
// WRITE DO DETAIL ITEMS
$no = 1;
$startRow = 11;
$summeter = 0;
$total = 0;
if ($query = $data->getDetailPO($id)) {
while ($rs = $query->fetch_array()) {
$meter = $rs['panjang'] * $rs['lebar'] * $rs['jml'];
$objExcel->getActiveSheet()->SetCellValue('A' . $startRow, $no);
$objExcel->getActiveSheet()->SetCellValue('B' . $startRow, $rs['bahan']);
$objExcel->getActiveSheet()->SetCellValue('C' . $startRow, $rs['deskripsi'] . ".ket:" . $rs['ket']);
$objExcel->getActiveSheet()->SetCellValue('D' . $startRow, $rs['tema']);
$objExcel->getActiveSheet()->SetCellValue('E' . $startRow, $rs['panjang'] . " x " . $rs['lebar']);
$objExcel->getActiveSheet()->SetCellValue('F' . $startRow, $rs['jml']);
$objExcel->getActiveSheet()->SetCellValue('G' . $startRow, $meter);
$objExcel->getActiveSheet()->SetCellValue('H' . $startRow, $rs['harga/m']);
$objExcel->getActiveSheet()->SetCellValue('I' . $startRow, $rs['subtotal']);
$objExcel->getActiveSheet()->getStyle('B' . $startRow)->getAlignment()->setWrapText(true);
$objExcel->getActiveSheet()->getStyle('C' . $startRow)->getAlignment()->setWrapText(true);
$objExcel->getActiveSheet()->getStyle('D' . $startRow)->getAlignment()->setWrapText(true);
if ($layout == "full") {
