Advertisement
Guest User

ModelAssetReceived

a guest
Jan 26th, 2020
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.30 KB | None | 0 0
  1. <?php
  2.  
  3. namespace app\models;
  4.  
  5. /**
  6. * This is the model class for table "asset_received".
  7. *
  8. * @property int $id_asset_received
  9. * @property int $id_asset_master
  10. * @property string $number1
  11. * @property string $number2
  12. * @property string $number3
  13. * @property string $received_date
  14. * @property int $received_year
  15. * @property double $price_received
  16. * @property int $quantity
  17. * @property int $id_status_received
  18. */
  19. class AssetReceived extends \yii\db\ActiveRecord
  20. {
  21.  
  22. /**
  23. * {@inheritdoc}
  24. */
  25. public static function tableName()
  26. {
  27. return 'asset_received';
  28. }
  29.  
  30. /**
  31. * {@inheritdoc}
  32. */
  33. public function rules()
  34. {
  35. return [
  36. [['id_asset_master', 'received_year', 'price_received', 'id_status_received'], 'required'],
  37. [['id_asset_master', 'received_year', 'quantity', 'id_status_received'], 'integer'],
  38. [['received_date'], 'safe'],
  39. [['price_received'], 'number'],
  40. [['number1', 'number2', 'number3'], 'string', 'max' => 150],
  41. [['notes1', 'notes2', 'notes3'], 'string', 'max' => 150],
  42. ];
  43. }
  44.  
  45. /**
  46. * {@inheritdoc}
  47. */
  48. public function attributeLabels()
  49. {
  50. return [
  51. 'id_asset_received' => 'Id Asset Received',
  52. 'id_asset_master' => 'Asset Master',
  53. 'number1' => 'Number 1',
  54. 'number2' => 'Number 2',
  55. 'number3' => 'Number 3',
  56. 'received_date' => 'Received Date',
  57. 'received_year' => 'Tahun Perolehan',
  58. 'price_received' => 'Harga Perolehan',
  59. 'quantity' => 'Quantity',
  60. 'id_status_received' => 'Kondisi Barang',
  61. 'notes1' => 'Penggunaan',
  62. ];
  63. }
  64.  
  65. public function getAssetMaster()
  66. {
  67. return $this->hasOne(AssetMaster::className(), ['id_asset_master' => 'id_asset_master']);
  68. }
  69.  
  70. public function getStatusReceived()
  71. {
  72. return $this->hasOne(MstStatusReceived::className(), ['id_status_received' => 'id_status_received']);
  73. }
  74. public function getJumlah()
  75. {
  76. return $this->hasMany(AssetMaster::className(), ['received_year' => 'received_year'])
  77. ->from('asset_received')
  78. // ->groupBy('received_year')
  79. ->count();
  80. }
  81. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement