public function run() { DB::table('karyawans')->delete(); Rekanan::create(array('kdrek' => 'RK01', 'cp' => 'Ali', 'jabatan' => 'Direktur', 'namarek' => 'Ali Sadikin', 'telpon1' => '4234234', 'alamat' => 'Jl. Galunggung', 'hp' => '08623423442', 'kodepos' => '62834', 'email' => '*****@*****.**', 'kota' => 'Kendari', 'propinsi' => 'Sulawesi utara', 'negara' => 'Indonesia', 'jbayar' => 'Cek', 'bank' => 'BCA', 'npwp' => '234982985792754', 'norek' => '342342', 'telpon2' => '0341-4245235', 'girocek' => 'werweiurho', 'fax' => '72658745', 'emailgiro' => '*****@*****.**', 'web' => 'domain.com', 'prodjasa' => 'Alat berat', 'created_at' => new DateTime(), 'updated_at' => new DateTime())); Rekanan::create(array('kdrek' => 'RK02', 'cp' => 'Ainur', 'jabatan' => 'Manajer Marketing', 'namarek' => 'Ainur Rohmah', 'telpon1' => '0234-435765', 'alamat' => 'Komplek Perumahan Green Hills', 'hp' => '08123346546', 'kodepos' => '79893', 'email' => '*****@*****.**', 'kota' => 'Jakarta', 'propinsi' => 'Jawa Barat', 'negara' => 'Indonesia', 'jbayar' => 'Tunai', 'bank' => 'BNI Syariah', 'npwp' => '8743654985823', 'norek' => '8723644982', 'telpon2' => '021-45634520', 'girocek' => 'wlkjhfsdf', 'fax' => '546457342', 'emailgiro' => '*****@*****.**', 'web' => '-', 'prodjasa' => 'Jasa maintenance alat berat', 'created_at' => new DateTime(), 'updated_at' => new DateTime())); Rekanan::create(array('kdrek' => 'RK03', 'cp' => 'Budi', 'jabatan' => 'Marketing', 'namarek' => 'Khairunisa', 'telpon1' => '023452834982', 'alamat' => 'Jl. Panglima Sudirman', 'hp' => '09823423998', 'kodepos' => '62800', 'email' => '*****@*****.**', 'kota' => 'Malang', 'propinsi' => 'Jawa Timur', 'negara' => 'Indonesia', 'jbayar' => 'Giro', 'bank' => 'Mandiri', 'npwp' => '9236498234792374', 'norek' => '4356346435', 'telpon2' => '0341-4245235', 'girocek' => 'ini giro_cek', 'fax' => '0341-8345980', 'emailgiro' => '*****@*****.**', 'web' => 'ini_domain.com', 'prodjasa' => 'Perlengkapan bangunan', 'created_at' => new DateTime(), 'updated_at' => new DateTime())); }
public function run() { DB::table('rekanan')->truncate(); $rekanan = new Rekanan(); $rekanan->NamaPerusahaan = 'Bendahara Rutin DPU Kab.Kutai Timur'; $rekanan->NPWP = '00.313.178.6-724.000'; $rekanan->NamaDirektur = 'SUFRANSYAH, SE'; $rekanan->Alamat = 'Kawasan Pusat Pemerintahan Bukit Pelangi Sangatta'; $rekanan->save(); $rekanan2 = new Rekanan(); $rekanan2->NamaPerusahaan = 'PT.Wahyu Perdana'; $rekanan2->NPWP = '01.233.123.4-124.046'; $rekanan2->NamaDirektur = 'Randa Wahyu Pradhana S.Kom'; $rekanan2->Alamat = 'Jln.Delima Gg.Delima II Sangatta'; $rekanan2->save(); }
/** Show the form for creating a new resource. @return Response */ public function getCreate() { // Title $title = Lang::get('admin/mats/title.buat_mat_baru'); $jenismats = ['' => ''] + Jmat::lists('keterangan', 'kdjmat'); $nreks = ['' => ''] + Rekanan::lists('namarek', 'kdrek'); // Show the page return View::make('admin/mats/create_edit', compact('title', 'jenismats', 'nreks')); }
public function SPTMasa4($id, $masa_pajak) { $id_rekanan = $id; $masapajak = explode('-', $masa_pajak); $data['masa_bulan'] = str_split($masapajak[0]); $data['masa_tahun'] = str_split($masapajak[1]); $Rekanan = Rekanan::where('id_rekanan', $id_rekanan)->first(); $data['NPWP'] = str_split($Rekanan->NPWP); $data['NamaPerusahaan'] = str_split($Rekanan->NamaPerusahaan); $data['Alamat'] = str_split($Rekanan->Alamat); $tanggal = '01-' . $masapajak[0] . '-' . $masapajak[1]; $tanggal1 = new \DateTime($tanggal); $tanggal2 = clone $tanggal1; $tanggal2->add(DateInterval::createFromDateString('1 month')); $tanggal2->add(DateInterval::createFromDateString('-1 day')); $data1 = DB::table('Pembayaran')->join('Pekerjaan', 'Pembayaran.id_pekerjaan', '=', 'pekerjaan.id_pekerjaan')->join('Rekanan', 'Rekanan.id_rekanan', '=', 'Pekerjaan.id_rekanan')->join('Jenissetoran', 'Jenissetoran.id_JenisSetoran', '=', 'Pekerjaan.id_JenisSetoran')->where('Rekanan.id_rekanan', $id_rekanan)->where('Pekerjaan.KategoriPelaksana', '1')->whereBetween('Pembayaran.TanggalPembayaran', array($tanggal1, $tanggal2))->get(); $data2 = DB::table('Pembayaran')->join('Pekerjaan', 'Pembayaran.id_pekerjaan', '=', 'pekerjaan.id_pekerjaan')->join('Rekanan', 'Rekanan.id_rekanan', '=', 'Pekerjaan.id_rekanan')->join('Jenissetoran', 'Jenissetoran.id_JenisSetoran', '=', 'Pekerjaan.id_JenisSetoran')->where('Rekanan.id_rekanan', $id_rekanan)->where('Pekerjaan.KategoriPelaksana', '2')->whereBetween('Pembayaran.TanggalPembayaran', array($tanggal1, $tanggal2))->get(); $data3 = DB::table('Pembayaran')->join('Pekerjaan', 'Pembayaran.id_pekerjaan', '=', 'pekerjaan.id_pekerjaan')->join('Rekanan', 'Rekanan.id_rekanan', '=', 'Pekerjaan.id_rekanan')->join('Jenissetoran', 'Jenissetoran.id_JenisSetoran', '=', 'Pekerjaan.id_JenisSetoran')->where('Rekanan.id_rekanan', $id_rekanan)->where('Pekerjaan.KategoriPelaksana', '3')->whereBetween('Pembayaran.TanggalPembayaran', array($tanggal1, $tanggal2))->get(); if (count($data1)) { $PerencanaNOP = 0; $PerencanaPPh = 0; foreach ($data1 as $item) { $PerencanaNOP += $item->NilaiPembayaran; $PerencanaPPh += $item->NilaiPPh; $data['PerencanaTarif'] = $item->Tarif * 100; } $data['PerencanaNOP'] = number_format($PerencanaNOP, 0, ',', '.'); $data['PerencanaPPh'] = number_format($PerencanaPPh, 0, ',', '.'); $data['PerencanaTarif'] .= '%'; } else { $data['PerencanaNOP'] = ''; $data['PerencanaPPh'] = ''; $data['PerencanaTarif'] = ''; $PerencanaNOP = NULL; $PerencanaPPh = NULL; } if (count($data2)) { $PelaksanaNOP = 0; $PelaksanaPPh = 0; foreach ($data2 as $item) { $PelaksanaNOP += $item->NilaiPembayaran; $PelaksanaPPh += $item->NilaiPPh; $data['PelaksanaTarif'] = $item->Tarif * 100; } $data['PelaksanaNOP'] = number_format($PelaksanaNOP, 0, ',', '.'); $data['PelaksanaPPh'] = number_format($PelaksanaPPh, 0, ',', '.'); $data['PelaksanaTarif'] .= '%'; } else { $data['PelaksanaNOP'] = ''; $data['PelaksanaPPh'] = ''; $data['PelaksanaTarif'] = ''; $PelaksanaNOP = NULL; $PelaksanaPPh = NULL; } if (count($data3)) { $PengawasNOP = 0; $PengawasPPh = 0; foreach ($data3 as $item) { $PengawasNOP += $item->NilaiPembayaran; $PengawasPPh += $item->NilaiPPh; $data['PengawasTarif'] = $item->Tarif * 100; } $data['PengawasNOP'] = number_format($PengawasNOP, 0, ',', '.'); $data['PengawasPPh'] = number_format($PengawasPPh, 0, ',', '.'); $data['PengawasTarif'] .= '%'; } else { $data['PengawasNOP'] = ''; $data['PengawasPPh'] = ''; $data['PengawasTarif'] = ''; $PengawasNOP = NULL; $PengawasPPh = NULL; } $data['JumlahNOP'] = $PerencanaNOP + $PelaksanaNOP + $PengawasNOP; $data['JumlahPPh'] = $PerencanaPPh + $PelaksanaPPh + $PengawasPPh; $nominal_pph = BaseController::terbilang($data['JumlahPPh']); $data['terbilang'] = preg_replace('~((?:\\S*?\\s){7})~', "\$1\n", $nominal_pph); $data['JumlahNOP'] = number_format($data['JumlahNOP'], 0, ',', '.'); $data['JumlahPPh'] = number_format($data['JumlahPPh'], 0, ',', '.'); $bendahara = Pegawai::where('id_pegawai', 1)->first(); $data['NamaBendahara'] = str_split($bendahara->Nama); $data['NpwpBendahara'] = str_split($bendahara->Npwp); // echo $id.' dan '.$masa_pajak.' dan '.$tanggal.' dan '.$data['PerencanaTarif']; return View::make('cetak.SPTMasa4', $data); }
public function HapusRekanan($id) { Rekanan::where('id_rekanan', $id)->delete(); $result['success'] = Redirect::to('/profil/rekanan')->with('success', 'Data Rekanan Berhasil Dihapus.'); return $result; }
function cek_sampul_penawaran($id) { if (Request::ajax()) { $pengadaan = $this->get_pengadaan($id); $rekanan = Rekanan::where('id_rkn', $pengadaan->id_rekanan)->first(); if (null == $pengadaan->id_rekanan) { echo "Rekanan Belum dipilih"; } else { echo "ok"; } } }
function cetakPengalaman_rekanan($id) { $data = new stdclass(); $pengadaan = $this->get_pengadaan($id); $data = Rekanan::where('id_rkn', $pengadaan->id_rekanan)->first(); $data->tanggal = date("d F Y", strtotime($this->get_jadwal($id)->thp2_dari)); $pengurus = $this->get_pengurus($pengadaan->id_rekanan); $data->pemilik = $pengurus->nama_pengurus; $data->jabatan = $pengurus->jabatan; $html = View::make('admin.report.data_pengalaman_rekanan')->with('data', $data); return PDF::loadHTML($html)->setPaper('legal')->setOrientation('landscape')->stream('pengalaman_perusahaan.pdf'); }
public function index($id_rkn) { $data = new stdclass(); $data = Rekanan::where('id_rkn', '=', $id_rkn)->first(); return View::make('master', array('menu' => 'admin.admin_menu', 'page' => 'admin.rekanan.form_pengurus'))->with('data', $data); }
public function getData() { $rekanans = Rekanan::select(array('rekanans.kdrek', 'rekanans.cp', 'rekanans.namarek', 'rekanans.jabatan', 'rekanans.telpon1', 'rekanans.alamat', 'rekanans.hp', 'rekanans.kodepos', 'rekanans.email', 'rekanans.kota', 'rekanans.propinsi', 'rekanans.negara', 'rekanans.jbayar', 'rekanans.bank', 'rekanans.npwp', 'rekanans.norek', 'rekanans.telpon2', 'rekanans.girocek', 'rekanans.fax', 'rekanans.emailgiro', 'rekanans.web', 'rekanans.prodjasa')); return Datatables::of($rekanans)->add_column('actions', ' <div> <a href="{{{ URL::to(\'admin/rekanans/\' . $kdrek . \'/edit\' ) }}}" class="btn btn-primary btn-xs iframe" ><i class="fa fa-pencil"></i></a> <a href="{{{ URL::to(\'admin/rekanans/\' . $kdrek . \'/delete\' ) }}}" class="btn btn-xs btn-danger iframe"><i class="fa fa-trash-o"></i></a> </div> ')->remove_column('rn')->make(); }
function cekemail() { $email = Input::get('email'); $data = Rekanan::where('email_rkn', '=', $email)->first(); if (count($data) > 0) { echo "false"; } else { echo "true"; } }