/** * 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()); }