Skip to main content

Mencetak SK SKS dengan Spesifikasi Tertentu

SKS Rekap ditambahkan kolom cetak:

/* INI UNTUK MENAMPILKAN CETAK SK SKS */
echo "
<a href=

'excel_sks_x/cetak_sks.php?kd_dosen=" . $row[1]. "
 &FE=" . $row[3]. "&FH=" . $row[4]. "&FTSP=" . $row[5]. "&FTI=" . $row[6]. "&FMIPA=" . $row[7]. "&FIAI=" . $row[8]. "&FPSB=" . $row[9]. "&FK=" . $row[10]. "&D3K=" . $row[11]. "
'


class='btn btn-small btn-lg'>Cetak</a></center></td>";

Sementara cetak_sks, di config ditambah:

//config
$judul='SURAT KEPUTUSAN REKTOR';
$nomor_sk_rektor ='553';
//config
$tahun_semester = '20161';
$kode_dosen = $_GET['kd_dosen'];
$semester = 'GANJIL';
$tahun_akademik = '2016/2017';
$tanggal_rapat_bidang_1 = '2016/08/16';

//membuat SQL nomor surat fakultas
$sks_FE = $_GET['FE'];

if ($_GET['FH'] <= 1) {
  $sql_FH = "";
} else {
  $sql_FH = "AND surat_dekan_fakultas LIKE '%Fakultas Hukum%'";
}

if ($_GET['FK'] <= 1) {
  $sql_FK = "";
} else {
  $sql_FK = "AND surat_dekan_fakultas LIKE '%Fakultas Kedokteran%'";
}

if ($_GET['FIAI'] <= 1) {
  $sql_FIAI = "";
} else {
  $sql_FIAI = "AND surat_dekan_fakultas LIKE '%Fakultas Ilmu Agama Islam%'";
}

if ($_GET['FTI'] <= 1) {
  $sql_FTI = "";
} else {
  $sql_FTI = "AND surat_dekan_fakultas LIKE '%Fakultas Teknologi Industri%'";
}

if ($_GET['FTSP'] <= 1) {
  $sql_FTSP = "";
} else {
  $sql_FTSP = "AND surat_dekan_fakultas LIKE '%Fakultas Teknik Sipil dan Perencanaan%'";
}

if ($_GET['FMIPA'] <= 1) {
  $sql_FMIPA = "";
} else {
  $sql_FMIPA = "AND surat_dekan_fakultas LIKE '%Fakultas MIPA%'";
}

if ($_GET['FPSB'] <= 1) {
  $sql_FPSB = "";
} else {
  $sql_FPSB = "AND surat_dekan_fakultas LIKE '%Fakultas Psikologi dan Ilmu Sosial Budaya%'";
}

if ($_GET['FE'] <= 1) {
  $sql_FE = "";
} else {
  $sql_FE = "AND surat_dekan_fakultas LIKE '%Fakultas Ekonomi%'";
}

if ($_GET['D3K'] <= 1) {
  $sql_FMIPA = "";
} else {
  $sql_FMIPA = "AND surat_dekan_fakultas LIKE '%Fakultas MIPA%'";
}

$query_surat_dekan = "SELECT
surat_dekan_fakultas, surat_dekan_nomor, surat_dekan_tanggal
FROM
surat_dekan
WHERE
surat_dekan_thsms ='".$tahun_semester."'

".$sql_FH ." ".$sql_FK ."  ".$sql_FIAI ." ".$sql_FE ." ".$sql_FMIPA ." ".$sql_FTI ." ".$sql_FTSP ." ".$sql_FPSB ."
";

//merubah nomor surat
//rubah tanggal ke tahun ----

Comments

Post a Comment

Popular posts from this blog

Menggenerate nomor id

<?php //config $database = "dopo"; $tabel = "po"; $kolom_generate ="id"; $kolom_referensi = "id"; /* Database connection start */ $servername = "localhost"; $username = "root"; $password = ""; $dbname = $database; $mysqli = mysqli_connect($servername, $username, $password, $dbname) or die("Connection failed: " . mysqli_connect_error()); $q1 = "select * from $tabel order by $kolom_referensi DESC"; /* Database connection end */ echo '<table>'; // connect to the database // number of results to show per page $per_page = 10000; // figure out the total pages in the database if ($result = $mysqli->query($q1)) { if ($result->num_rows != 0) { $total_results = $result->num_rows; // ceil() returns the next highest integer value by rounding up value if necessary $total_pages = ceil($total_results / $per_page); // check if the 'page' variab...
Post a Comment
Read more

Membuat Codeigniter PDF di CPANEL

1. Download FPDF dan copykan di folder application/thirdparty/pdf/ 2. Buat file Fpdf_gen.php di libraries. <?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); class Fpdf_gen { public function __construct() {  require_once APPPATH.'third_party/fpdf/fpdf-1.8.php'; define('FPDF_FONTPATH', APPPATH.'third_party/fpdf/font/'); $pdf = new FPDF(); $pdf->AddPage(); $CI =& get_instance(); $CI->fpdf = $pdf; } public function Footer() { $this->fpdf->SetY(-15); $this->fpdf->SetFont('Arial','I',8); $this->fpdf->SetTextColor(128); $this->fpdf->Cell(0,10,'Page ',0,0,'C'); } } 3. Buat file pdf.php di controller <?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); defined('BASEPATH') OR exit('No direct script access allowed'); class Pdf extends CI_Controller {   public f...
Post a Comment
Read more