Sptpd.php
2.59 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
<?php
/**
* @Author: irul
* @Date: 2019-09-23 15:28:04
* @Last Modified by: irul
* @Last Modified time: 2019-10-01 23:43:21
*/
namespace Integrasi\Reklame\Base\Models;
use \Illuminate\Database\Capsule\Manager as DB;
class Sptpd extends AbstractModel
{
protected $table = 'pad_sptpd';
// protected $visible = array(
// 'id',
// 'sptno',
// 'customer_id',
// 'customer_usaha_id',
// 'pajak_id',
// 'tahun',
// 'terimatgl',
// 'type_id',
// 'so',
// 'jatuhtempotgl',
// 'masadari',
// 'masasd',
// 'minomset',
// 'dasar',
// 'tarif',
// 'denda',
// 'bunga',
// 'setoran',
// 'kenaikan',
// 'kompensasi',
// 'lain2',
// 'pajak_terhutang',
// 'r_bayarid',
// 'rekening_id',
// 'create_date',
// 'create_uid',
// 'enabled',
// 'spt',
// 'customer',
// 'kohir',
// 'rincianReklame',
// );
protected $guarded = array();
protected static function boot()
{
parent::boot();
static::creating(function ($model) {
return $model->_onCreating();
});
}
public function _onCreating()
{
$maxSptno = call_user_func($this->getParentNamespace() . '\Sptpd::select',
DB::raw('max(sptno) as nomor'))
->where(DB::raw('tahun'), date('Y', strtotime($this->attributes['terimatgl'])))
->first();
$sptno = ($maxSptno->nomor ?: 0) + 1;
$this->attributes['sptno'] = $sptno;
$this->attributes['create_uid'] = \Api\AuthBasic::getUid();
return true;
}
// == ACCESSORS == //
public function getSptpdnoAttribute($value)
{
$qry = "select get_sptpdno(?) as sptno";
$row = DB::select(DB::raw($qry), array($this->attributes['id']));
return $row[0]->sptno;
}
// == QUERY SCOPES == //
public static function scopeFindBySptpdno($query, $sptno)
{
return $query->where(DB::raw('get_sptpdno(id)'), array($sptno));
}
public static function scopeFindByKohirno($query, $kohirno)
{
return $query->where(DB::raw('get_kohirno(id)'), array($kohirno));
}
// == RELATIONSHIPS == //
/**
* Get the customer that owns the sptpd.
*/
public function customer()
{
return $this->belongsTo($this->getParentNamespace() . '\Customer');
}
/**
* Get the spt record associated with the sptpd.
*/
public function spt()
{
return $this->hasOne($this->getParentNamespace() . '\Spt');
}
/**
* Get the kohir record associated with the sptpd.
*/
public function kohir()
{
return $this->hasOne($this->getParentNamespace() . '\Kohir');
}
/**
* Get the rincian reklame record associated with the sptpd.
*/
public function rincianReklame()
{
return $this->hasMany($this->getParentNamespace() . '\SptpdRincianReklame', 'sptpd_id', 'id');
}
}