<?php defined('BASEPATH') OR exit('No direct script access allowed');?>
<?=link_tag('assets/plugins/magnific-popup/magnific-popup.css');?>
<script type="text/javascript" src="<?=base_url('assets/plugins/magnific-popup/magnific-popup.js')?>"></script>
<?php $this->load->view('backend/grid_index');?>
<script type="text/javascript">
DS.SpecialNeeds = _H.StrToObject('<?=get_options('special_needs')?>');
DS.Religions = _H.StrToObject('<?=get_options('religions')?>');
DS.Residences = _H.StrToObject('<?=get_options('residences')?>');
DS.Transportations = _H.StrToObject('<?=get_options('transportations')?>');
DS.MonthlyIncomes = _H.StrToObject('<?=get_options('monthly_incomes')?>');
DS.StudentStatus = _H.StrToObject('<?=get_options('student_status')?>');
DS.Employments = _H.StrToObject('<?=get_options('employments')?>');
DS.Educations = _H.StrToObject('<?=get_options('educations')?>');
DS.Majors = _H.StrToObject('<?=$major_dropdown;?>');
var _grid = 'STUDENTS', _form = _grid + '_FORM';
new GridBuilder( _grid , {
	controller:'academic/students',
	fields: [
		{
			header: '<input type="checkbox" class="check-all">',
			renderer: function( row ) {
				return CHECKBOX(row.id, 'id');
			},
			exclude_excel: true,
			sorting: false
		},
		{
			header: '<i class="fa fa-edit"></i>',
			renderer: function( row ) {
				return A(_form + '.OnEdit(' + row.id + ')', 'Edit');
			},
			exclude_excel: true,
			sorting: false
		},
		{
			header: '<i class="fa fa-file-image-o"></i>',
			renderer: function( row ) {
				return UPLOAD(_form + '.OnUpload(' + row.id + ')', 'image', 'Upload Photo');
			},
			exclude_excel: true,
			sorting: false
		},
		{
			header: '<i class="fa fa-search-plus"></i>',
			renderer: function( row ) {
				var image = "'" + row.photo + "'";
				return row.photo ?
				'<a title="Preview" onclick="preview(' + image + ')"  href="#"><i class="fa fa-search-plus"></i></a>' : '';
			},
			exclude_excel: true,
			sorting: false
		},
		{
			header: '<i class="fa fa-key"></i>',
			renderer:function( row ) {
				return A('create_account(' + "'" + row.full_name + "'" + ', ' + row.id + ')', 'Aktivasi Akun', '<i class="fa fa-key"></i>');
			},
			exclude_excel: true,
			sorting: false
		},
		{
			header: '<i class="fa fa-search"></i>',
			renderer: function( row ) {
				return Ahref(_BASE_URL + 'academic/students/profile/' + row.id, 'Preview', '<i class="fa fa-search"></i>');
			},
			exclude_excel: true,
			sorting: false
		},
		{ header:_IDENTITY_NUMBER, renderer:'identity_number' },
		{ header:'Nama Lengkap', renderer:'full_name' },
		{
			header:'Status',
			renderer: function( row ) {
				return row.student_status;
			},
			sort_field: 'student_status'
		},
		{ header:'Tempat Lahir', renderer:'birth_place' },
		{
			header:'Tanggal Lahir',
			renderer: function( row ) {
				return row.birth_date && row.birth_date !== '0000-00-00' ? _H.ToIndonesianDate(row.birth_date) : '';
			},
			sort_field: 'birth_date'
		},
		{
			header:'L/P',
			renderer: function( row ) {
				return row.gender == 'M' ? 'L' : 'P';
			},
			sort_field: 'gender'
		}

	],
	resize_column: 7,
	to_excel: false,
	extra_buttons: '<button class="btn btn-default btn-sm add" onclick="student_reports()" data-toggle="tooltip" data-placement="top" title="Export to Excel"><i class="fa fa-file-excel-o"></i></button>' +
	'<button title="Aktivasi Semua Akun ?" onclick="create_accounts()" class="btn btn-default btn-sm" data-toggle="tooltip" data-placement="top"><i class="fa fa-key"></i></button>'
});

var form_fields = [];
form_fields.push(
	{ label:'Pindahan ?', name:'is_transfer', type:'select', datasource:DS.TrueFalse },
	{ label:'Tanggal Masuk Sekolah', name:'start_date', type:'date' },
	{ label:_IDENTITY_NUMBER, name:'identity_number' }
);

// khusus untuk SD
if (parseInt(_SCHOOL_LEVEL) == 1) {
	form_fields.push(
		{ label:'Apakah Pernah PAUD ?', name:'paud', type:'select', datasource:DS.TrueFalse },
		{ label:'Apakah Pernah TK ?', name:'tk', type:'select', datasource:DS.TrueFalse }
	);
}

// Jika bukan SD atau SMP
if (_MAJOR_COUNT > 0) {
	form_fields.push(
		{ label: _MAJOR, name:'major_id', type:'select', datasource:DS.Majors }
	);
}

form_fields.push(
	{ label:'Nomor SKHUN Sebelumnya', name:'skhun' },
	{ label:'Nomor Peserta Ujian Sebelumnya', name:'prev_exam_number' },
	{ label:'Nomor Ijazah Sebelumnya', name:'prev_diploma_number' },
	{ label:'Hobi', name:'hobby' },
	{ label:'Cita-cita', name:'ambition' },
	{ label:'Nama Lengkap', name:'full_name' },
	{ label:'Jenis Kelamin', name:'gender', type:'select', datasource:DS.Gender },
	{ label:'NISN', name:'nisn' },
	{ label:'NIK', name:'nik' },
	{ label:'Tempat Lahir', name:'birth_place' },
	{ label:'Tanggal Lahir', name:'birth_date', type:'date' },
	{ label:'Agama', name:'religion_id', type:'select', datasource:DS.Religions },
	{ label:'Berkebutuhan Khusus', name:'special_need_id', type:'select', datasource:DS.SpecialNeeds },
	{ label:'Alamat Jalan', name:'street_address' },
	{ label:'RT', name:'rt' },
	{ label:'RW', name:'rw' },
	{ label:'Nama Dusun', name:'sub_village' },
	{ label:'Nama Kelurahan/ Desa', name:'village' },
	{ label:'Kecamatan', name:'sub_district' },
	{ label:'Kota / Kabupaten', name:'district' },
	{ label:'Kode Pos', name:'postal_code' },
	{ label:'Tempat Tinggal', name:'residence_id', type:'select', datasource:DS.Residences },
	{ label:'Moda Transportasi', name:'transportation_id', type:'select', datasource:DS.Transportations },
	{ label:'Nomor Telepon', name:'phone' },
	{ label:'Nomor HP', name:'mobile_phone' },
	{ label:'Email', name:'email' },
	{ label:'Nomor SKTM', name:'sktm', placeholder:'Surat Keterangan Tidak Mampu' },
	{ label:'Nomor KKS', name:'kks', placeholder:'Kartu Keluarga Sejahtera' },
	{ label:'Nomor KPS', name:'kps', placeholder:'Kartu Pra Sejahtera' },
	{ label:'Nomor KIP', name:'kip', placeholder:'Kartu Indonesia Pintar' },
	{ label:'Nomor KIS', name:'kis', placeholder:'Kartu Indonesia Pintar' },
	{ label:'Kewarganegaraan', name:'citizenship', type:'select', datasource:DS.Citizenship },
	{ label:'Nama Negara', name:'country' },
	{ label:'Nama ayah Kandung', name:'father_name' },
	{ label:'Tahun Lahir Ayah', name:'father_birth_year' },
	{ label:'Pendidikan Ayah', name:'father_education_id', type:'select', datasource:DS.Educations },
	{ label:'Pekerjaan Ayah', name:'father_employment_id', type:'select', datasource:DS.Employments },
	{ label:'Penghasilan  Bulanan Ayah', name:'father_monthly_income_id', type:'select', datasource:DS.MonthlyIncomes },
	{ label:'Kebutuhan Khusus Ayah', name:'father_special_need_id', type:'select', datasource:DS.SpecialNeeds },
	{ label:'Nama Ibu Kandung', name:'mother_name' },
	{ label:'Tahun Lahir Ibu', name:'mother_birth_year' },
	{ label:'Pendidikan Ibu', name:'mother_education_id', type:'select', datasource:DS.Educations },
	{ label:'Pekerjaan Ibu', name:'mother_employment_id', type:'select', datasource:DS.Employments },
	{ label:'Penghasilan  Bulanan Ibu', name:'mother_monthly_income_id', type:'select', datasource:DS.MonthlyIncomes },
	{ label:'Kebutuhan Khusus Ibu', name:'mother_special_need_id', type:'select', datasource:DS.SpecialNeeds },
	{ label:'Nama Wali', name:'guardian_name' },
	{ label:'Tahun Lahir Wali', name:'guardian_birth_year' },
	{ label:'Pendidikan Wali', name:'guardian_education_id', type:'select', datasource:DS.Educations },
	{ label:'Pekerjaan Wali', name:'guardian_employment_id', type:'select', datasource:DS.Employments },
	{ label:'Penghasilan Bulanan Wali', name:'guardian_monthly_income_id', type:'select', datasource:DS.MonthlyIncomes },
	{ label:'Jarak Tempat Tinggal ke Sekolah', name:'mileage', type:'number' },
	{ label:'Waktu Tempuh', name:'traveling_time', type:'number' },
	{ label:'Tinggi Badan', name:'height', type:'number' },
	{ label:'Berat Badan', name:'weight', type:'number' },
	{ label:'Jumlah Saudara Kandung', name:'sibling_number', type:'number' },
	{ label:'Status Peserta Didik', name:'student_status_id', type:'select', datasource:DS.StudentStatus },
	{ label:'Nama Sekolah Sebelumnya', name:'prev_school_name' },
	{ label:'Alamat Sekolah Sebelumnya', name:'prev_school_address' },
	{ label:'Tanggal Keluar', name:'end_date', type:'date' },
	{ label:'Alasan Keluar', name:'reason', type:'textarea' }
);
new FormBuilder( _form , {
	controller:'academic/students',
	fields: form_fields
});

/**
* Create Student Account - Single Activation
* @param String
* @param Number
*/
function create_account( full_name, id ) {
	eModal.confirm('Apakah anda yakin akan mengaktifkan akun dengan nama ' + full_name + ' ?', 'Konfirmasi').then(function() {
		$.post(_BASE_URL + 'academic/students/create_account', {'id':id}, function(response) {
			var res = _H.StrToObject( response );
			_H.Notify(res.status, _H.Message(res.message));
		});
	});
}

/**
* Create All Student Account - All Activation
* @param String
* @param Number
*/
function create_accounts() {
	eModal.confirm('Nama Pengguna dan Kata Sandi ' + _STUDENT + ' akan digenerate dengan menggunakan ' + _IDENTITY_NUMBER + '. Apakah anda yakin akan mengaktifkan seluruh akun ' + _STUDENT + ' ?', 'Konfirmasi').then(function() {
		_H.Loading( true );
		$.post(_BASE_URL + 'academic/students/create_accounts', {}, function( response ) {
			_H.Loading( false );
			var res = _H.StrToObject( response );
			_H.Notify(res.status, _H.Message(res.message));
		});
	});
}

function preview(image) {
	$.magnificPopup.open({
		items: {
			src: _BASE_URL + 'media_library/students/' + image
		},
		type: 'image'
	});
}

// Export All Field to Excel
function student_reports() {
	var fields = {
		full_name: 'Nama Lengkap',
		gender: 'L/P',
		birth_place: 'Tempat Lahir',
		birth_date: 'Tanggal Lahir',
		major_name: _MAJOR,
		is_transfer: 'Pindahan ?',
		achievement: 'Prestasi',
		re_registration: 'Daftar Ulang ?',
		identity_number: _IDENTITY_NUMBER,
		nisn: 'NISN',
		nik: 'NIK',
		prev_diploma_number: 'Nomor Ijazah Sebelumnya',
		paud: 'PAUD',
		tk: 'TK',
		skhun: 'SKHUN',
		prev_school_name: 'Nama Sekolah Sebelumnya',
		prev_school_address: 'Alamat Sekolah Sebelumnya',
		hobby: 'Hobi',
		ambition: 'Cita-Cita',
		religion: 'Agama',
		special_need: 'Kebutuhan Khusus',
		street_address: 'Alamat Jalan',
		rt: 'RT',
		rw: 'RW',
		sub_village: 'Dusun',
		village: 'Kelurahan',
		sub_district: 'Kecamatan',
		district: 'Kota / Kabupaten',
		postal_code: 'Kode Pos',
		residence: 'Tempat Tinggal',
		transportation: 'Alat Transportasi',
		phone: 'Telepon',
		mobile_phone: 'Handphone',
		email: 'Email',
		sktm: 'SKTM',
		kks: 'KKS',
		kps: 'KPS',
		kip: 'KIP',
		kis: 'KIS',
		citizenship: 'Kewarganegaraan',
		country: 'Nama Negara',
		father_name: 'Nama Ayah',
		father_birth_year: 'Tahun Lahir Ayah',
		father_education: 'Pendidikan Ayah',
		father_employment: 'Pekerjaan Ayah',
		father_monthly_income: 'Penghasilan Ayah',
		father_special_need: 'Kebutuhan Khusus Ayah',
		mother_name: 'Nama Ibu',
		mother_birth_year: 'Tahun Lahir Ibu',
		mother_education: 'Pendidikan Ibu',
		mother_employment: 'Pekerjaan Ibu',
		mother_monthly_income: 'Penghasilan Ibu',
		mother_special_need: 'Kebutuhan Khusus Ibu',
		guardian_name: 'Nama Wali',
		guardian_birth_year: 'Tahun Lahir Wali',
		guardian_education: 'Pendidikan Wali',
		guardian_employment: 'Pekerjaan Wali',
		guardian_monthly_income: 'Penghasilan Wali',
		mileage: 'Jarak Tempat Tinggal',
		traveling_time: 'Waktu Tempuh',
		height: 'Tinggi Badan',
		weight: 'Berat Badan',
		sibling_number: 'Jumlah Saudara Kandung',
		student_status: 'Status ' + _STUDENT,
		start_date: 'Tanggal Masuk',
		end_date: 'Tanggal Keluar',
		reason: 'Alasan Keluar'
	};
	$.post(_BASE_URL + 'academic/students/student_reports', {}, function(response) {
		var results = _H.StrToObject( response );
		var table = '<table>';
		table += '<tr>';
		for (var key in fields) {
			if ( _MAJOR_COUNT == 0 && key == 'major_name') continue;
			table += '<th>' + fields[ key ] + '</th>';
		}
		table += '</tr>'
		for (var x in results) {
			var res = results[ x ];
			table += '</tr>';
			for (var y in fields) {
				table += '<td>' + (res[ y ] ? res[ y ] : '-') + '</td>';
			}
			table += '</tr>';
		}
		table += '</table>';
		var elementId = 'excel-report';
		var div = '<div id="' + elementId + '" style="display: none;"></div>';
		$( div ).appendTo( document.body );
		$( '#' + elementId ).html( table );
		var fileName = 'LAPORAN-DATA-' + _STUDENT.toUpperCase();
		ExportToExcel( elementId, fileName ); // Export to Excel
	}).fail(function(xhr) {
		console.log(xhr);
	});
}
</script>
