<?php
use yii\helpers\Html;
use yii\widgets\ActiveForm;
/* @var $this yii\web\View */
/* @var $model app\models\DataFisik */
/* @var $form yii\widgets\ActiveForm */
?>
<?php
$sql = 'SELECT a.id, concat(a.id, " - ", a.no_faktur, " - ", date_format(a.tgl, "%d-%m-%Y")) as keterangan
FROM
faktur a
where a.id not in(Select id_faktur FROM data_fisik)';
$faktur = \app\models\Penjualan::findBySql($sql)->all();
$listData = \yii\helpers\ArrayHelper::map($faktur, 'id', 'keterangan');
?>
<div class="data-fisik-form">
<?php
$form = ActiveForm::begin(['options' => ['enctype' => 'multipart/form-data']]);
?>
<?php
echo $form->field($model, 'id_faktur')->dropDownList($listData, ['prompt' => 'PILIH DATA FAKTUR ..']);
?>
<?php
echo $form->field($model, 'foto_ktp')->textInput(['maxlength' => true]);
?>
