/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request, $id)
{
$idmotor = $request->input('motor_id');
$motor = Motor::find($idmotor);
$input = $request->all();
$input = ['kode' => $request->input('kode'), 'debitur_id' => $request->input('debitur_id'), 'motor_id' => $request->input('motor_id'), 'uangmuka' => $request->input('uangmuka'), 'tempo' => $request->input('tempo'), 'angsuran' => ($motor->harga - $request->input('uangmuka')) / $request->input('tempo'), 'no_polisi' => $request->input('no_polisi'), 'no_mesin' => $request->input('no_mesin'), 'no_rangka' => $request->input('no_rangka'), 'penyerah' => $request->input('penyerah'), 'penerima' => $request->input('penerima')];
Transaksi::create($input);
return redirect('admin/debitur/' . $id);
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Motor::find();
$query->joinWith(['jenisMotor0']);
$query->JoinWith(['posisiMotor0']);
// add conditions that should always apply here
$dataProvider = new ActiveDataProvider(['query' => $query]);
$dataProvider->sort->attributes['nama'] = ['asc' => ['jenis_motor.nama' => SORT_ASC], 'desc' => ['jenis_motor.nama' => SORT_DESC]];
$dataProvider->sort->attributes['posisi'] = ['asc' => ['posisi_motor.posisi' => SORT_ASC], 'desc' => ['posisi_motor.posisi' => SORT_DESC]];
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
// grid filtering conditions
$query->andFilterWhere(['no_totok' => $this->no_totok]);
$query->andFilterWhere(['like', 'warna', $this->warna])->andFilterWhere(['like', 'no_rangka', $this->no_rangka])->andFilterWhere(['like', 'no_mesin', $this->no_mesin])->andFilterWhere(['like', 'tahun', $this->tahun])->andFilterWhere(['like', 'keterangan', $this->keterangan])->andFilterWhere(['like', 'nama', $this->nama])->andFilterWhere(['like', 'posisi', $this->posisi])->andFilterWhere(['like', 'status', $this->status]);
return $dataProvider;
}
$stok1 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 1 AND status="Belum Terjual" AND posisi = "Kantor Jakarta"')->groupBy(['id_jenis'])->all();
$stok2 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 2 AND status="Belum Terjual" AND posisi = "Kantor Jakarta"')->groupBy(['id_jenis'])->all();
$stok3 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 3 AND status="Belum Terjual" AND posisi = "Kantor Jakarta"')->groupBy(['id_jenis'])->all();
$stok4 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 4 AND status="Belum Terjual" AND posisi = "Kantor Jakarta"')->groupBy(['id_jenis'])->all();
$stok5 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 5 AND status="Belum Terjual" AND posisi = "Kantor Jakarta"')->groupBy(['id_jenis'])->all();
$stok7 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 7 AND status="Belum Terjual" AND posisi = "Kantor Jakarta"')->groupBy(['id_jenis'])->all();
$stok8 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 8 AND status="Belum Terjual" AND posisi = "Kantor Jakarta"')->groupBy(['id_jenis'])->all();
$stok10 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 10 AND status="Belum Terjual" AND posisi = "Kantor Jakarta"')->groupBy(['id_jenis'])->all();
$stok11 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 11 AND status="Belum Terjual" AND posisi = "Kantor Jakarta"')->groupBy(['id_jenis'])->all();
//$stok1_laku = \app\models\Motor::find()
// ->select(['COUNT(motor.id) as id'])
// ->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')
// ->where('id_jenis = 1 AND status="Belum Terjual" AND posisi = "Kantor Surabaya"')
// ->groupBy(['id_jenis'])
// ->all();
$kondisi1 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'kondisi_motor', 'motor.id = kondisi_motor.id_motor')->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('kondisi="Siap Jual" AND posisi = "Kantor Jakarta"')->groupBy(['kondisi'])->all();
?>
<?php
foreach ($stok1 as $data) {
$bravo = $data['id'];
}
foreach ($stok2 as $data) {
$trooper = $data['id'];
}
foreach ($stok3 as $data) {
$maxi = $data['id'];
}
foreach ($stok4 as $data) {
$exo = $data['id'];
}
$stok3 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 3 AND status="Belum Terjual" AND posisi = "Pabrik"')->groupBy(['id_jenis'])->all();
$stok4 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 4 AND status="Belum Terjual" AND posisi = "Pabrik"')->groupBy(['id_jenis'])->all();
$stok5 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 7 AND status="Belum Terjual" AND posisi = "Pabrik"')->groupBy(['id_jenis'])->all();
$stok6 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 16 AND status="Belum Terjual" AND posisi = "Pabrik"')->groupBy(['id_jenis'])->all();
$stok7 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 12 AND status="Belum Terjual" AND posisi = "Pabrik"')->groupBy(['id_jenis'])->all();
$stok8 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 17 AND status="Belum Terjual" AND posisi = "Pabrik"')->groupBy(['id_jenis'])->all();
$stok9 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 14 AND status="Belum Terjual" AND posisi = "Pabrik"')->groupBy(['id_jenis'])->all();
$stok10 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 11 AND status="Belum Terjual" AND posisi = "Pabrik"')->groupBy(['id_jenis'])->all();
$stok11 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 13 AND status="Belum Terjual" AND posisi = "Pabrik"')->groupBy(['id_jenis'])->all();
$stok12 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 18 AND status="Belum Terjual" AND posisi = "Pabrik"')->groupBy(['id_jenis'])->all();
$stok13 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 8 AND status="Belum Terjual" AND posisi = "Pabrik"')->groupBy(['id_jenis'])->all();
$stok14 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 15 AND status="Belum Terjual" AND posisi = "Pabrik"')->groupBy(['id_jenis'])->all();
$kondisi1 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'kondisi_motor', 'motor.id = kondisi_motor.id_motor')->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('kondisi="Siap Jual" AND posisi = "Pabrik"')->groupBy(['kondisi'])->all();
$kondisi2 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'kondisi_motor', 'motor.id = kondisi_motor.id_motor')->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('kondisi="Sedang disiapkan" AND posisi = "Pabrik"')->groupBy(['kondisi'])->all();
$kondisi3 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'kondisi_motor', 'motor.id = kondisi_motor.id_motor')->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('kondisi="Belum Siap" AND posisi = "Pabrik"')->groupBy(['id_jenis'])->all();
$kondisi4 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'kondisi_motor', 'motor.id = kondisi_motor.id_motor')->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('kondisi="Rusak" AND posisi = "Pabrik"')->groupBy(['id_jenis'])->all();
?>
<?php
foreach ($stok1 as $data) {
$bravo = $data['id'];
}
foreach ($stok2 as $data) {
$trooper = $data['id'];
}
foreach ($stok3 as $data) {
$maxi = $data['id'];
}
foreach ($stok4 as $data) {
$exo = $data['id'];
}
<li><a href="chart-pabrik">Pabrik</a></li>-->
</ul>
</div>
</div>
</td>
</tr>
</table><br/>
<!--Html::a('Download Data Motor', ['export'], ['class' => 'btn btn-info'])-->
<?php
$form = \yii\bootstrap\ActiveForm::begin();
/* parameterized initialization */
$form = \yii\bootstrap\ActiveForm::begin(['id' => 'form_id', 'options' => ['class' => 'form_class', 'enctype' => 'multipart/form-data']]);
//render form elements here
\yii\bootstrap\ActiveForm::end();
?>
</div>
<div class="table-responsive">
<?php
echo GridView::widget(['dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'columns' => [['class' => 'yii\\grid\\SerialColumn'], ['attribute' => 'id', 'value' => 'id', 'filter' => false, 'contentOptions' => ['style' => 'width: 75px;']], ['attribute' => 'nama', 'value' => 'jenisMotor0.nama', 'filter' => Html::activeDropDownList($searchModel, 'nama', \yii\helpers\ArrayHelper::map(\app\models\JenisMotor::find()->select('nama')->distinct()->all(), 'nama', 'nama'), ['class' => 'form-control', 'prompt' => 'Semua'])], ['attribute' => 'warna', 'value' => 'warna', 'contentOptions' => ['style' => 'width: 125px;']], ['attribute' => 'no_totok', 'value' => 'no_totok', 'contentOptions' => ['style' => 'width: 75px;']], 'no_rangka', 'no_mesin', ['attribute' => 'posisi', 'value' => 'posisiMotor0.posisi', 'filter' => Html::activeDropDownList($searchModel, 'posisi', \yii\helpers\ArrayHelper::map(\app\models\PosisiMotor::find()->select('posisi')->distinct()->all(), 'posisi', 'posisi'), ['class' => 'form-control', 'prompt' => 'Semua'])], ['attribute' => 'status', 'format' => 'raw', 'filter' => Html::activeDropDownList($searchModel, 'status', \yii\helpers\ArrayHelper::map(\app\models\Motor::find()->select('status')->distinct()->all(), 'status', 'status'), ['class' => 'form-control', 'prompt' => 'Semua']), 'value' => function ($row) {
$values = ['laku' => 'success', 'belum terjual' => 'info'];
return Html::tag('span', $row->status, ['class' => 'label label-' . $values[$row->status] . ''], ['style' => 'text-size:14px']);
}], ['class' => \yii\grid\ActionColumn::className(), 'template' => '{delete} {update}']]]);
?>
</div>
</div>
$stok5 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 5 AND status="Belum Terjual" AND posisi = "Kantor Surabaya"')->groupBy(['id_jenis'])->all();
$stok7 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 7 AND status="Belum Terjual" AND posisi = "Kantor Surabaya"')->groupBy(['id_jenis'])->all();
$stok8 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 8 AND status="Belum Terjual" AND posisi = "Kantor Surabaya"')->groupBy(['id_jenis'])->all();
$stok9 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 9 AND status="Belum Terjual" AND posisi = "Kantor Surabaya"')->groupBy(['id_jenis'])->all();
$stok10 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 10 AND status="Belum Terjual" AND posisi = "Kantor Surabaya"')->groupBy(['id_jenis'])->all();
$stok11 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 11 AND status="Belum Terjual" AND posisi = "Kantor Surabaya"')->groupBy(['id_jenis'])->all();
$stok12 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 12 AND status="Belum Terjual" AND posisi = "Kantor Surabaya"')->groupBy(['id_jenis'])->all();
$stok13 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 13 AND status="Belum Terjual" AND posisi = "Kantor Surabaya"')->groupBy(['id_jenis'])->all();
$stok14 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 14 AND status="Belum Terjual" AND posisi = "Kantor Surabaya"')->groupBy(['id_jenis'])->all();
$stok15 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 15 AND status="Belum Terjual" AND posisi = "Kantor Surabaya"')->groupBy(['id_jenis'])->all();
$stok16 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 16 AND status="Belum Terjual" AND posisi = "Kantor Surabaya"')->groupBy(['id_jenis'])->all();
$stok19 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 19 AND status="Belum Terjual" AND posisi = "Kantor Surabaya"')->groupBy(['id_jenis'])->all();
$stok20 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 20 AND status="Belum Terjual" AND posisi = "Kantor Surabaya"')->groupBy(['id_jenis'])->all();
$stok21 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('id_jenis = 6 AND status="Belum Terjual" AND posisi = "Kantor Surabaya"')->groupBy(['id_jenis'])->all();
$kondisi1 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'kondisi_motor', 'motor.id = kondisi_motor.id_motor')->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('kondisi="Siap Jual" AND posisi = "Kantor Surabaya"')->groupBy(['kondisi'])->all();
$kondisi2 = \app\models\Motor::find()->select(['COUNT(motor.id) as id'])->join('LEFT JOIN', 'kondisi_motor', 'motor.id = kondisi_motor.id_motor')->join('LEFT JOIN', 'posisi_motor', 'motor.id = posisi_motor.id_motor')->where('kondisi="Sedang disiapkan" AND posisi = "Kantor Surabaya"')->groupBy(['kondisi'])->all();
?>
<?php
foreach ($stok1 as $data) {
$bravo = $data['id'];
}
foreach ($stok2 as $data) {
$trooper = $data['id'];
}
foreach ($stok3 as $data) {
$maxi = $data['id'];
}
foreach ($stok4 as $data) {
$exo = $data['id'];
}
<?php
use yii\helpers\Html;
use yii\widgets\ActiveForm;
/* @var $this yii\web\View */
/* @var $model app\models\PosisiMotor */
/* @var $form yii\widgets\ActiveForm */
?>
<?php
//use app\models\Country;
$motor = \app\models\Motor::find()->where(['status' => 'belum terjual'])->all();
$listData = \yii\helpers\ArrayHelper::map($motor, 'id', 'no_rangka', 'no_mesin');
?>
<?php
if ($model->isNewRecord) {
$sql = 'SELECT a.id, concat(a.id, " - ", " TIPE : ", b.nama, " - ", a.warna, " - ", a.no_rangka, " - ", a.no_mesin) as warna from motor a INNER JOIN jenis_motor b ON a.id_jenis=b.id where a.status = "belum terjual" AND a.id not in(SELECT id_motor from posisi_motor) ORDER BY a.id';
} else {
$sql = 'SELECT a.id, concat(a.id, " - ", " TIPE : ", b.nama, " - ", a.warna, " - ", a.no_rangka, " - ", a.no_mesin) as warna from motor a INNER JOIN jenis_motor b ON a.id_jenis=b.id where a.status = "belum terjual" ORDER BY a.id';
}
$motor = \app\models\Motor::findBySql($sql)->all();
$listData = \yii\helpers\ArrayHelper::map($motor, 'id', 'warna');
?>
<div class="alert alert-block" style="background-color : lightgreen;">
<button type="button" class="close" data-dismiss="alert">×</button>
<h4>Info:</h4>
<b>Data Motor</b> yang tersedia adalah <b>Data Motor</b> yang belum pernah diinputkan <b>Data Posisinya</b>.
</div>
<div class="posisi-motor-form">
