Spt.php
2.19 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
<?php
/**
* @Author: irul
* @Date: 2019-09-23 13:41:14
* @Last Modified by: irul
* @Last Modified time: 2019-10-01 23:43:21
*/
namespace Integrasi\Reklame\Base\Models;
use \Integrasi\Reklame\Base\Helper;
use \Illuminate\Database\Capsule\Manager as DB;
class Spt extends AbstractModel
{
protected $table = 'pad_spt';
protected $guarded = array();
protected static function boot()
{
parent::boot();
static::creating(function ($model) {
return $model->_onCreating();
});
}
public function _onCreating()
{
// $maxSptno = Spt::select(DB::raw('max(sptno) as nomor'))
$maxSptno = call_user_func($this->getParentNamespace() . '\Spt::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 getSptnoAttribute($value)
{
$qry = "select get_sptno(?) as sptno";
$row = DB::select(DB::raw($qry), array($this->attributes['id']));
return $row[0]->sptno;
}
// == QUERY SCOPES == //
public static function scopeFindBySptno($query, $sptno)
{
return $query->where(DB::raw('get_sptno(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 spt.
*/
public function customer()
{
return $this->belongsTo($this->getParentNamespace() . '\Customer');
}
/**
* Get the kohir record associated with the spt.
*/
public function kohir()
{
if (!Helper::sptpdExist()) {
return $this->hasOne($this->getParentNamespace() . '\Kohir');
}
return null;
}
/**
* Get the valid sspd record associated with the spt.
*/
public function sspd()
{
return $this->hasOne($this->getParentNamespace() . '\Sspd')->where('is_valid','=', 1);
}
/**
* Get the sptpd that owns the spt.
*/
public function sptpd()
{
if (Helper::sptpdExist()) {
return $this->belongsTo($this->getParentNamespace() . '\Sptpd');
}
return null;
}
}