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";
}
}
