public function actionPilihRak($id)
{
$rak = RakBarang::model()->findByPk($id);
$return = array('id' => $id, 'nama' => $rak->nama);
$this->renderJSON($return);
}
public function getNamaRak()
{
$rak = RakBarang::model()->findByPk($this->rakId);
return is_null($rak) ? NULL : $rak->nama;
}
echo $formInputBaru->error($barang, 'kategori_id', array('class' => 'error'));
?>
</div>
<div class="medium-6 large-4 columns">
<?php
echo $formInputBaru->labelEx($barang, 'satuan_id');
echo $formInputBaru->dropDownList($barang, 'satuan_id', CHtml::listData(SatuanBarang::model()->findAll(array('order' => 'nama')), 'id', 'nama'), array(
'empty' => 'Pilih satu..'
));
echo $formInputBaru->error($barang, 'satuan_id', array('class' => 'error'));
?>
</div>
<div class="medium-6 large-4 columns">
<?php
echo $formInputBaru->labelEx($barang, 'rak_id');
echo $formInputBaru->dropDownList($barang, 'rak_id', CHtml::listData(RakBarang::model()->findAll(array('order' => 'nama')), 'id', 'nama'), array(
'empty' => 'Pilih satu..'
));
echo $formInputBaru->error($barang, 'rak_id', array('class' => 'error'));
?>
</div>
</div>
<div class="row">
<div class="span-12 columns">
<?php
echo CHtml::ajaxLink('Simpan (Alt+m)', $this->createUrl('tambahbarangbaru', array(
'id' => $pembelianModel->id,)), array(
'type' => 'POST',
'success' => "function (data) {
if (data.sukses){
$('#input-barang-baru').slideUp(500);
$.fn.yiiGridView.update("pembelian-detail-grid");
updateTotal();
}
}
});
$(".editable-rak").editable({
mode: "inline",
//inputclass: "input-editable-qty",
success: function (response, newValue) {
if (response.sukses) {
$.fn.yiiGridView.update("pembelian-detail-grid");
}
},
source: [
<?php
$listRak = CHtml::listData(RakBarang::model()->findAll(array('select' => 'id,nama', 'order' => 'nama')), 'id', 'nama');
$firstRow = TRUE;
foreach ($listRak as $key => $value):
?>
<?php
if (!$firstRow) {
echo ',';
}
$firstRow = false;
?>
{value : <?php echo $key; ?>, text : "<?php echo $value; ?>"}
<?php
endforeach;
?>
]
});
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer $id the ID of the model to be loaded
* @return RakBarang the loaded model
* @throws CHttpException
*/
public function loadModel($id)
{
$model = RakBarang::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
public function filterRak()
{
return ['NULL' => '[SEMUA]'] + CHtml::listData(RakBarang::model()->findAll(array('order' => 'nama')), 'id', 'nama');
}
public function listRak()
{
return CMap::mergeArray(array('null' => '-'), CHtml::listData(RakBarang::model()->findAll(array('select' => 'id, nama', 'order' => 'nama')), 'id', 'nama'));
}
public function actionImport()
{
if (isset($_POST['nomor'])) {
$dbAhadPos2 = $_POST['database'];
$nomor = $_POST['nomor'];
$pembelianPos2 = Yii::app()->db->createCommand("\n SELECT tb.tglTransaksiBeli, s.namaSupplier\n FROM {$dbAhadPos2}.transaksibeli tb\n JOIN {$dbAhadPos2}.supplier s on tb.idSupplier = s.idSupplier\n WHERE idTransaksiBeli = :nomor")->bindValue(':nomor', $nomor)->queryRow();
// print_r($pembelianPos2);
$profil = Profil::model()->find('nama=:nama', array('nama' => trim($pembelianPos2['namaSupplier'])));
// print_r($supplier);
if (!is_null($profil)) {
$pembelian = new Pembelian();
$pembelian->profil_id = $profil->id;
$pembelian->referensi = $nomor;
$pembelian->tanggal_referensi = date_format(date_create_from_format('Y-m-d', $pembelianPos2['tglTransaksiBeli']), 'd-m-Y');
//$pembelianPos2['tglTransaksiBeli'].' 00:00:00';
if ($pembelian->save()) {
$pembelianDetailPos2 = Yii::app()->db->createCommand("\n select db.barcode, hargaBeli, gb.hargaJual, RRP, jumBarangAsli, tglExpire, barang.id\n from {$dbAhadPos2}.detail_beli db\n join {$dbAhadPos2}.barang gb on db.barcode = gb.barcode\n left join barang on db.barcode = barang.barcode\n where idTransaksiBeli = :nomor\n ")->bindValue(':nomor', $nomor)->queryAll();
foreach ($pembelianDetailPos2 as $detailPos2) {
// Jika barang.id belum ada, buat data barang baru
$barangId = $detailPos2['id'];
if (is_null($detailPos2['id'])) {
$barangBaru = Yii::app()->db->createCommand("\n select b.barcode, b.namaBarang, k.namaKategoriBarang, s.namaSatuanBarang, r.namaRak\n from {$dbAhadPos2}.barang b\n left join {$dbAhadPos2}.kategori_barang k on b.idKategoriBarang=k.idKategoriBarang\n left join {$dbAhadPos2}.satuan_barang s on b.idSatuanBarang=s.idSatuanBarang\n left join {$dbAhadPos2}.rak r on b.idRak = r.idRak\n where barcode = :barcode\n ")->bindValue(':barcode', $detailPos2['barcode'])->queryRow();
$kategoriBarang = KategoriBarang::model()->find("nama='{$barangBaru['namaKategoriBarang']}'");
if (is_null($kategoriBarang)) {
$kategoriId = 1;
} else {
$kategoriId = $kategoriBarang->id;
}
$satuanBarang = SatuanBarang::model()->find("nama='{$barangBaru['namaSatuanBarang']}'");
if (is_null($satuanBarang)) {
$satuanId = 1;
} else {
$satuanId = $satuanBarang->id;
}
$rakBarang = RakBarang::model()->find("nama='{$barangBaru['namaRak']}'");
if (is_null($rakBarang)) {
$rakId = 1;
} else {
$rakId = $rakBarang->id;
}
$barang = new Barang();
$barang->barcode = $barangBaru['barcode'];
$barang->nama = $barangBaru['namaBarang'];
$barang->kategori_id = $kategoriId;
$barang->satuan_id = $satuanId;
$barang->rak_id = $rakId;
if ($barang->save()) {
$barangId = $barang->id;
$supplierBarang = new SupplierBarang();
$supplierBarang->barang_id = $barangId;
$supplierBarang->supplier_id = $profil->id;
$supplierBarang->save();
}
}
$detail = new PembelianDetail();
$detail->pembelian_id = $pembelian->id;
$detail->barang_id = $barangId;
$detail->qty = $detailPos2['jumBarangAsli'];
$detail->harga_beli = $detailPos2['hargaBeli'];
$detail->harga_jual = $detailPos2['hargaJual'];
$detail->harga_jual_rekomendasi = $detailPos2['RRP'];
$detail->tanggal_kadaluwarsa = $detailPos2['tglExpire'];
$detail->save();
}
$this->redirect('index');
}
}
}
$modelCsvForm = new UploadCsvPembelianForm();
$supplierList = Profil::model()->profilTrx()->tipeSupplier()->orderByNama()->findAll(array('select' => 'id, nama'));
if (isset($_POST['UploadCsvPembelianForm'])) {
$modelCsvForm->attributes = $_POST['UploadCsvPembelianForm'];
if (!empty($_FILES['UploadCsvPembelianForm']['tmp_name']['csvFile'])) {
$modelCsvForm->csvFile = CUploadedFile::getInstance($modelCsvForm, 'csvFile');
$return = $modelCsvForm->simpanCsvKePembelian();
if ($return['sukses']) {
$this->redirect($this->createUrl('ubah', array('id' => $return['pembelianId'], 'pilihb' => FALSE)));
}
}
}
$this->render('import', array('modelCsvForm' => $modelCsvForm, 'supplierList' => $supplierList));
}
