public function goalAmount()
{
$active_flg = 1;
$goal_general = DB::table('goal_general')->where('uid', Auth::user()->id)->where('flg', $active_flg)->select('goal_general.id', 'uid', 'name', 'where', 'mth_saving', 'duration', 'duration_complete', DB::RAW('1 as goal_type'), 'created_at');
$goal_travel = DB::table('goal_travel')->where('uid', Auth::user()->id)->where('flg', $active_flg)->select('goal_travel.id', 'uid', 'goal_travel.where_to', 'goal_travel.where_to', 'mth_saving', 'duration', 'duration_complete', DB::RAW('2 as goal_type'), 'created_at');
$goal_home = DB::table('goal_home')->where('uid', Auth::user()->id)->where('flg', $active_flg)->select('goal_home.id', 'uid', 'name', 'where', 'mth_saving', 'duration', 'duration_complete', DB::RAW('4 as goal_type'), 'created_at');
$goal = DB::table('goal_car')->join('carbrandname', 'goal_car.brand', '=', 'carbrandname.id')->where('uid', Auth::user()->id)->where('goal_car.flg', $active_flg)->select('goal_car.id', 'uid', 'model as name', 'carbrandname.images as ext', 'mth_saving', 'duration', 'duration_complete', DB::RAW('3 as goal_type'), 'goal_car.created_at')->union($goal_travel)->union($goal_home)->union($goal_general)->get();
}
public function Cari()
{
$th = Input::get('tahun');
$data = DB::table('asesment_promosi')->join('lpp_kemenpan_siasik.daf_unit_staf', 'asesment_promosi.unit_staf_id', '=', 'lpp_kemenpan_siasik.daf_unit_staf.unit_staf_id')->select('tgl_selesai', 'asesment_promosi.tgl_selesai', 'lpp_kemenpan_siasik.daf_unit_staf.nama_lengkap', 'asesment_promosi.id', 'asesment_promosi.unit_staf_id', 'asesment_promosi.tgl_awal', 'asesment_promosi.tgl_asesment', 'asesment_promosi.tgl_selesai', 'asesment_promosi.detail')->whereyear('tgl_selesai', '=', $th)->paginate('10');
$tahun = DB::select(DB::RAW(" select year(tgl_selesai) from asesment_promosi\r\n\t\t\t\t\t"));
$breadcrumbs = array(array("Assessment Internal" => "javascript:void(0)"), array("Pengaturan" => ""), array("Jadwal Asessment" => ""));
$this->layout->breadcrumbs = View::make('layouts.breadcrumb', compact('breadcrumbs'));
$this->layout->content = View::make('career::jadwal/indexasessment', compact('data', 'tahun'));
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('sample', function (Blueprint $table) {
$table->string('id', 64)->index();
$table->string("CustomerName", 255);
$table->date("DatePurchase");
$table->double("AmountDue", 8, 2)->default(0);
$table->double("Discount", 8, 2)->default(0);
$table->double("GST", 8, 2)->default(0);
$table->double("TotalPriceBeforeDisc", 8, 2)->default(0);
$table->timestamp("created_at")->default(DB::RAW("now()"));
$table->timestamp("updated_at");
$table->primary('id');
$table->unique('id');
});
}
public function KandidatPromote()
{
$dafunit = DB::table('lpp_kemenpan_siasik.daf_unit_staf')->join('asesment_kelas', 'lpp_kemenpan_siasik.daf_unit_staf.unit_staf_id', '=', 'asesment_kelas.unit_staf_id')->select('asesment_kelas.unit_staf_id', 'lpp_kemenpan_siasik.daf_unit_staf.nama_lengkap', 'lpp_kemenpan_siasik.daf_unit_staf.eselon_id')->get();
$ambil = Input::get('cari');
if (empty($ambil)) {
$comment = "<div class='alert alert-danger'><a class='close' data-dismiss='alert'>×</a>Silahkan Anda Memasukkan Jabatan</div>";
//Session::flash('messagess','Silahkan Anda Memasukkan Jabatan');
} else {
$unit = DB::select(DB::RAW("select count(asesment_prasyarat_jabatan.nilai) as nilai, asesment_kelas.id, asesment_tipe.nama_tipe, prestasi_kerja_rekap_penilaian.nilai_kompetensi, prestasi_kerja_rekap_penilaian.nilai_kinerja, lpp_kemenpan_siasik.daf_unit_staf.nama_lengkap\r\n\t\t\t \t,lpp_kemenpan_siasik.master_pegawai.nama, asesment_eselon.jabatan,asesment_kelas.unit_staf_id,lpp_kemenpan_siasik.daf_gol.pangkat,lpp_kemenpan_siasik.daf_gol.golongan\r\n\t\t\t \tfrom asesment_kelas\r\n\t\t\t \tjoin lpp_kemenpan_siasik.daf_unit_staf on lpp_kemenpan_siasik.daf_unit_staf.unit_staf_id = asesment_kelas.unit_staf_id \r\n\t\t\t \tjoin lpp_kemenpan_siasik.daf_gol on lpp_kemenpan_siasik.daf_gol.gol_id = lpp_kemenpan_siasik.daf_unit_staf.eselon_id\r\n\t\t\t\tjoin asesment_eselon on asesment_eselon.id = asesment_kelas.asesment_eselon_id \r\n\t\t\t\tjoin asesment_tipe on asesment_tipe.parent_id = asesment_eselon.asesment_tipe_id\r\n\t\t\t\tleft join asesment_prasyarat_jabatan on asesment_prasyarat_jabatan.asesment_eselon_id = asesment_kelas.asesment_eselon_id\r\n\t\t\t\tjoin asesment_prasyarat on asesment_prasyarat.id = asesment_prasyarat_jabatan.asesment_prasyarat_id \r\n\t\t\t\tjoin prestasi_kerja_rekap_penilaian on prestasi_kerja_rekap_penilaian.id_jabatan = asesment_kelas.unit_staf_id\r\n\t\t\t\tjoin lpp_kemenpan_siasik.master_pegawai on lpp_kemenpan_siasik.master_pegawai.nip = prestasi_kerja_rekap_penilaian.nip \r\n\t\t\t\twhere asesment_kelas.unit_staf_id = '{$ambil}' and prestasi_kerja_rekap_penilaian.nilai_kinerja >= 76 and \r\n\t\t\t\tprestasi_kerja_rekap_penilaian.nilai_kompetensi >= 60"));
foreach ($unit as $un) {
if (empty($un) && empty($un->jabatan)) {
Session::flash('message', 'Maaf Data Eselon Jabatan Belum Ada di Database');
} elseif (isset($un->parent_id) && $un->parent_id == 0) {
Session::flash('message', 'Maaf Data yang Anda Masukkan Eselon 1');
} elseif ($un->nilai_kinerja <= 76 && $un->nilai_kompetensi <= 60) {
Session::flash('message', 'Maaf Nilai Tidak memenuhi');
}
}
}
//endof if $ambil
$breadcrumbs = array(array("Assessment Internal" => "javascript:void(0)"), array("Pengaturan" => ""), array("Kandidat Promosi Jabatan" => ""));
$this->layout->breadcrumbs = View::make('layouts.breadcrumb', compact('breadcrumbs'));
$this->layout->content = View::make('career::kandidat/kandidatpromote', compact('dafunit', 'unit', 'comment'));
}
public function index()
{
//fungsional
$unit = Input::get('unit');
//manajerial & inti
$unitt = Input::get('unitt');
if (isset($unit)) {
$deputi = DB::table('competency_recap_individuals')->join('competency_dictionaries', 'competency_recap_individuals.competency_dictionary_id', '=', 'competency_dictionaries.id')->join('competency_types', 'competency_dictionaries.type_id', '=', 'competency_types.id')->join('competency_recaps', 'competency_recap_individuals.competency_recap_id', '=', 'competency_recaps.id')->join('asesment_kelas', 'competency_recaps.occupation_id', '=', 'asesment_kelas.unit_staf_id')->select(DB::RAW('round(avg(competency_recap_individuals.gap),2) as gap, count(competency_recaps.user_nip) as nip'), 'competency_dictionaries.type_id', 'competency_types.name', 'competency_dictionaries.title', 'competency_recap_individuals.itj', 'competency_recap_individuals.rcl', 'competency_recap_individuals.ccl', 'competency_dictionaries.id', 'competency_dictionaries.type_id')->where('asesment_kelas.unit', '=', "{$unit}")->orderBy('gap', 'asc')->orderBy('itj', 'desc')->groupBy('competency_dictionaries.id')->paginate(15);
}
if (isset($unit)) {
$deputti = DB::table('competency_recap_individuals')->join('competency_dictionaries', 'competency_recap_individuals.competency_dictionary_id', '=', 'competency_dictionaries.id')->join('competency_types', 'competency_dictionaries.type_id', '=', 'competency_types.id')->join('competency_recaps', 'competency_recap_individuals.competency_recap_id', '=', 'competency_recaps.id')->join('asesment_kelas', 'competency_recaps.occupation_id', '=', 'asesment_kelas.unit_staf_id')->select(DB::RAW('round(avg(competency_recap_individuals.gap),2) as gap, count(competency_recaps.user_nip) as nip'), 'competency_dictionaries.type_id', 'competency_types.name', 'competency_dictionaries.title', 'competency_recap_individuals.itj', 'competency_recap_individuals.rcl', 'competency_recap_individuals.ccl', 'competency_dictionaries.id', 'competency_dictionaries.type_id')->where('asesment_kelas.unit', '=', "{$unitt}")->orderBy('gap', 'asc')->orderBy('itj', 'desc')->groupBy('competency_dictionaries.id')->paginate(15);
}
$kompetensi = DB::table('competency_types')->get();
$diklat = DB::table('diklat_competency')->get();
$combobox = DB::table('diklat_competency')->get();
$rencana = DB::table('diklat_competency')->join('competency_types', 'diklat_competency.id_competency', '=', 'competency_types.id')->get();
//susun perencanaan diklat inti
$agendaf = DB::table('diklat_agenda')->select('diklat_agenda.id', 'competency_types.name', 'diklat_competency.id_competency', 'diklat_competency.nama_kompetensi', 'diklat_agenda.jdwal_mulai', 'diklat_agenda.jdwal_selesai')->join('diklat_competency', 'diklat_agenda.id_diklat_comp', '=', 'diklat_competency.id')->join('competency_types', 'diklat_competency.id_competency', '=', 'competency_types.id')->where('competency_types.id', '=', '1')->paginate(10);
//susun perencanaan diklat fungsional
$agenda = DB::table('diklat_agenda')->select('diklat_agenda.id', 'competency_types.name', 'diklat_competency.id_competency', 'diklat_competency.nama_kompetensi', 'diklat_agenda.jdwal_mulai', 'diklat_agenda.jdwal_selesai')->join('diklat_competency', 'diklat_agenda.id_diklat_comp', '=', 'diklat_competency.id')->join('competency_types', 'diklat_competency.id_competency', '=', 'competency_types.id')->where('competency_types.id', '=', '2')->paginate(10);
$breadcrumbs = array(array('Kompetensi' => ""), array('Perencanaan' => ""));
$this->layout->breadcrumbs = View::make('layouts.breadcrumb', compact('breadcrumbs'));
$this->layout->content = View::make('competency::adminperencanaan.index', compact('tipe', 'rencana', 'kompetensi', 'deputi', 'deputti', 'diklat', 'agenda', 'agendaf'));
}
