/**
* 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;
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id, $idtransaksi)
{
$debitur = Debitur::findOrFail($id);
$transaksi = Transaksi::findOrFail($idtransaksi);
$idmotor = $request->input('motor_id');
$motor = Motor::findOrFail($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->update($input);
return redirect('admin/debitur/' . $id);
}
use yii\helpers\Html;
use yii\widgets\ActiveForm;
use dosamigos\datepicker\DatePicker;
/* @var $this yii\web\View */
/* @var $model app\models\Penjualan */
/* @var $form yii\widgets\ActiveForm */
?>
<?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 INNER JOIN kondisi_motor c ON a.id = c.id_motor where a.status = "belum terjual" AND c.kondisi = "siap jual" 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 INNER JOIN kondisi_motor c ON a.id = c.id_motor ORDER by a.id';
}
$motor = \app\models\Motor::findBySql($sql)->all();
$listData = \yii\helpers\ArrayHelper::map($motor, 'id', 'warna');
$sql2 = 'SELECT id, concat(id, " - ", nama_lengkap, " - ", alamat, " - ", kota) as nama_lengkap from pembeli';
$pembeli = \app\models\Pembeli::findBySql($sql2)->all();
$listData3 = \yii\helpers\ArrayHelper::map($pembeli, 'id', 'nama_lengkap');
?>
<!--<div class="jumbotron" style="background-color : lightgreen;"><b>Info :</b> Data Motor yang tersedia adalah Data Motor dengan kondisi <b>'siap jual'</b> saja.</div>-->
<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> dengan kondisi <b>'siap jual'</b> saja.
</div>
<div class="penjualan-form">
$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'];
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
Motor::findOrFail($id)->delete();
return Redirect::route('admin.motor.index');
}
$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'];
}
/**
* Finds the Motor model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Motor the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Motor::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
<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'];
}
public function getMotor0()
{
return $this->hasOne(Motor::className(), ['id' => 'id_motor'])->from(Motor::tableName());
}
