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

FPDF dengan CodeIgniter

Cetak Surat Keputusan Controller: <?php //File in controller named surat_keputusan.php defined('BASEPATH') OR exit('No direct script access allowed'); class Cetak_surat_keputusan extends CI_Controller { public function __construct()     {         parent::__construct();         $this->load->helper('url');         $this->load->database();                $this->db->select();         $this->db->from('surat.config_sk');                $query = $this->db->get();                 return $query->result();             } public function index() {      ...
1 comment
Read more

Token_Model

<?php defined('BASEPATH') OR exit('No direct script access allowed'); class Token_model extends CI_Model { public function __construct() { parent::__construct(); $this->load->library('session'); $this->load->helper('url'); } public function token_feeder() { $username = '*****'; $password = '*****'; $data_sesi=array( 'username'=>$username, 'password'=>$password, 'sudah_login'=>true, ); $this->session->set_userdata($data_sesi); $username=$this->session->userdata('username'); $password=$this->session->userdata('password'); $mytoken = array('act'=>'GetToken', 'username'=>$username, 'password'=>$password); $payload = json_encode($mytoken); $ch = curl_init('http://192.168.30.99:8082/ws/live2.php'); curl_setopt($ch, CURLOPT_RETURNTRANS...
Post a Comment
Read more

Layar Biru versi PHP Bagian 1 (file prefil_dbf.php)

file config.php <?php $db_uname = 'root'; $db_passwd = ''; $db_name = 'layar_biru'; //database yang dipilih $db_host = 'localhost'; $xbase_dir = 'D:\ACADEMIC\htdocs\layar_biru\files'; $die_on_mysql_error = false; // when investigating errors, set this to true $from_encoding=""; //Encoding of database, e.g. CP866 or empty, if convert is not required     file prefil.dbf   <?php include "config.php";            // please copy the config.sample.php and edit the correct fields include "classes/XBase/Table.php"; include "classes/XBase/Column.php"; include "classes/XBase/Record.php"; include "classes/DBFhandler.php"; use XBase\Table;  // Initializing vars ini_set( 'memory_limit', '2048M' ); set_time_limit( 0 ); $time_start = time(); $files = scandir($xbase_dir) or die ("Error! Could not open directory '$xbase_dir'."); $conn = new mysqli($db_host,...
Post a Comment
Read more