require_once "../inc/PHPExcel.php";
// DEFINE ALL CLASSES
$data = new do_do();
$objExcel = PHPExcel_IOFactory::load("../template-report/each-do.xls");
$objWriter = new PHPExcel_Writer_Excel5($objExcel);
$objOrderedSign = new PHPExcel_Worksheet_Drawing();
$objApprovedSign = new PHPExcel_Worksheet_Drawing();
$id = $_GET['id'];
$layout = $_GET['layout'];
$objExcel->setActiveSheetIndex(0);
// DEFINE STYLES MAY NEED IN EXCEL DOCUMENT
$styleBorder = array('borders' => array('allborders' => array('style' => PHPExcel_Style_Border::BORDER_THIN)));
$styleCenter = array('alignment' => array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER));
// RETRIEVE DATA AND BIND IN VARIABLES
$q = "SELECT `do`.*, `pelanggan`.`noreg`, `pelanggan`.`nama`,`pelanggan`.`alamat`,`karyawan`.`nama` as `nama_karyawan`, `level`.`jabatan`, `area`.`area` AS nama_area FROM `do` \n\t\t\tINNER JOIN `pelanggan` ON `pelanggan`.`id` = `do`.`id_pelanggan`\n\t\t\tINNER JOIN `karyawan` ON `karyawan`.`id` = `do`.`id_karyawan`\n\t\t\tINNER JOIN `level` ON `karyawan`.`level` = `level`.`id` \n\t\t\tINNER JOIN `area` ON `area`.`id` = `do`.`area`\n\t\t\tWHERE `do`.`id` = '{$id}' ";
if ($query = $data->runQuery($q)) {
while ($rs = $query->fetch_array()) {
$noDO = $rs['no'];
$tglDO = $rs['tgl_do'];
$noreg = $rs['noreg'];
$nama = $rs['nama'];
$alamat = $rs['alamat'];
$area = $rs['nama_area'];
$acc = $rs['acc'];
}
}
$q = "SELECT `do`.*, `karyawan`.`nama` AS `nama_karyawan`, `karyawan`.`ttd` AS `ttd`, `level`.`jabatan` FROM `do` \n\t\t\tINNER JOIN `karyawan` ON `karyawan`.`id` = `do`.`id_karyawan`\n\t\t\tINNER JOIN `level` ON `karyawan`.`level` = `level`.`id` \n\t\t\tWHERE `do`.`id` = '{$id}'";
if ($query = $data->runQuery($q)) {
while ($rs = $query->fetch_array()) {
$orderedBy = $rs['nama_karyawan'];
$ttdOrderedBy = $rs['ttd'] != null ? $rs['ttd'] : "-";
case "10":
$namaBulan = "Oktober";
break;
case "11":
$namaBulan = "November";
break;
case "12":
$namaBulan = "Desember";
break;
}
$banyakHari = cal_days_in_month(CAL_GREGORIAN, $bulan, $tahun);
for ($i = 1; $i <= $banyakHari; $i++) {
$hari[] = "[{$i}]";
$x = strlen($i) == 1 ? "0" . $i : $i;
$tgl = $tahun . "-" . $bulan . "-" . $x;
if ($q = $data->runQuery("SELECT COUNT(id) AS jumlah FROM do WHERE tgl_do = '{$tgl}'")) {
$rs = $q->fetch_array();
$jumlahDO[] = $rs['jumlah'];
}
}
?>
<div class="container">
<div class="row">
<div class="col-md-12">
<script type="text/javascript">
$(function () {
$('#container2').highcharts({
title: {
text: 'Data Order',
x: -20 //center
},
<?php
include './do/class.do.php';
$data = new do_do();
$data->runQuery("TRUNCATE TABLE `do_help`");
?>
<div class="container">
<div class="row">
<div class="col-md-3"></div>
<div class="col-md-6">
<center>
<h4>Input D.O.</h4>
</center>
</div>
<div class="col-md-3">
</div>
</div>
<hr>
<form action="#" method="POST" id="form-do" name="form-do" >
<div class="row">
<div class="col-xs-12">
<div class="form-group">
<label class="col-sm-9"></label>
<div class="col-sm-3">
Search :
<select class="form-control" id="cmb-area">
<?php
if ($_SESSION['media-status'] == e_code("2") || $_SESSION['media-status'] == e_code("9")) {
<?php
if (isset($_POST['apa']) && $_POST['apa'] != "") {
// include '../inc/tes.php';
// include 'class.do.php';
include 'do/class.do.php';
$data = new do_do();
switch ($_POST['apa']) {
case 'help':
if (isset($_POST['deskripsi']) && isset($_POST['tema']) && isset($_POST['ukuran']) && isset($_POST['jumlah']) && isset($_POST['ket'])) {
if ($help = $data->runQuery("INSERT INTO `do_help`(`deskripsi`,`id_tema_layar`,`id_ukuran`, `jumlah`,`ket`) VALUES ('" . $_POST['deskripsi'] . "', '" . $_POST['tema'] . "', '" . $_POST['ukuran'] . "', '" . $_POST['jumlah'] . "', '" . $_POST['ket'] . "' ) ")) {
$id = $data->lastInsertID();
if ($cek = $data->runQuery("SELECT `do_help`.* , `tema_layar`.`tema`,`ukuran`.`pre`,`ukuran`.`panjang`,`ukuran`.`lebar` FROm `do_help` INNER JOIN `tema_layar` ON `tema_layar`.`id`=`do_help`.`id_tema_layar` INNER JOIN `ukuran` ON `ukuran`.`id` = `do_help`.`id_ukuran` WHERE `id` = '" . $id . "'")) {
if ($cek->num_rows > 0) {
$rs = $cek->fetch_array();
echo "<tr>\n\t\t\t\t\t\t\t\t<td>" . $rs['deskripsi'] . "</td>\n\t\t\t\t\t\t\t\t<td>" . $rs['tema'] . "</td>\n\t\t\t\t\t\t\t\t<td>" . $rs['pre'] . " " . $rs['panjang'] . " x " . $rs['lebar'] . "</td>\n\t\t\t\t\t\t\t\t<td>" . $rs['jumlah'] . "</td>\n\t\t\t\t\t\t\t\t<td>" . $rs['ket'] . "</td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t</tr>";
} else {
echo "<script>alert('Gagal menyimpan detail..');</script>";
}
} else {
echo "<script>alert('Gagal menyimpan detail..');</script>";
}
} else {
echo "<script>alert('Gagal menyimpan detail..');</script>";
}
}
break;
case "simpan":
$arr = array();
if (isset($_POST['data-detail']) && $_POST['data-detail'] != "" && isset($_POST['idPelanggan']) && $_POST['idPelanggan'] != "" && isset($_POST['tglDO']) && $_POST['tglDO'] != "") {
$idPelanggan = $_POST['idPelanggan'];
<h4>ACC D.O.</h4>
</center>
</div>
</div>
<hr>
<div class="row">
<div class="col-md-12">
<label for="cariTanggal" class="col-sm-2 control-label">Periode DO</label>
<div class="col-sm-10">
<div class="col-sm-3"><input type="text" name="tglAwal" id="tglAwal" class="form-control " placeholder="Tanggal Awal"></div>
<div class="col-sm-3"><input type="text" name="tglAkhir" id="tglAkhir" class="form-control " placeholder="Tanggal Akhir"></div>
<div class="col-sm-3">
<select id="cmbArea" class="form-control">
<?php
if ($_SESSION['media-status'] == e_code("2") || $_SESSION['media-status'] == e_code("9")) {
if ($result = $data->runQuery("SELECT `id`, `area` FROM `area` WHERE `hapus` = '0'")) {
while ($rs = $result->fetch_array()) {
echo "<option value='" . $rs['id'] . "'>" . $rs['area'] . "</option>";
}
}
} else {
echo "<option value='" . $_SESSION['media-area'] . "'>" . $_SESSION['media-namaarea'] . "</option>";
}
?>
</select>
</div>
<div class="col-sm-3"><button type="button" class="btn btn-normal btn-orange" id="btn-refresh-table"><i class="fa fa-refresh"></i></button></div>
</div>
</div>
</div>
<hr>
