public function inputBarangKeCetak()
{
if (!empty($this->barcode)) {
$barang = Barang::model()->find('barcode=:barcode', array(':barcode' => $this->barcode));
if (!is_null($barang)) {
$label = new LabelRakCetak();
$label->barang_id = $barang->id;
try {
$label->save();
return 1;
} catch (Exception $exc) {
return 0;
}
}
}
if (!empty($this->profilId || !empty($this->rakId) || !empty($this->dari))) {
$sqlProfil = '';
$sqlRak = '';
$sqlDari = '';
if (!empty($this->profilId)) {
$sqlProfil = "JOIN supplier_barang sp ON barang.id = sp.barang_id AND sp.supplier_id = :supplierId";
}
if (!empty($this->rakId)) {
$sqlRak = "WHERE rak_id = :rakId";
}
if (!empty($this->dari)) {
$sqlDari = "JOIN\n barang_harga_jual bhj ON barang.id = bhj.barang_id\n AND bhj.updated_at >= :dari";
}
/* Menambahkan barang yang belum ada di tabel label_rak_cetak */
$tabelCetak = LabelRakCetak::model()->tableName();
$userId = Yii::app()->user->id;
$sql = "INSERT IGNORE INTO {$tabelCetak} (barang_id, updated_by)\n SELECT \n barang.id, {$userId}\n FROM\n barang\n {$sqlDari}\n {$sqlProfil}\n {$sqlRak}";
$command = Yii::app()->db->createCommand($sql);
if (!empty($this->profilId)) {
$command->bindValue(':supplierId', $this->profilId);
}
if (!empty($this->rakId)) {
$command->bindValue(':rakId', $this->rakId);
}
if (!empty($this->dari)) {
$command->bindValue(':dari', date_format(date_create_from_format('d-m-Y H:i', $this->dari), 'Y-m-d H:i:s'));
}
return $command->execute();
}
}
public function actionHapusSemua()
{
LabelRakCetak::model()->deleteAll();
}
'filter' => $model,
'columns' => array(
array(
'name' => 'barcode',
'value' => '$data->barang->barcode',
'filter' => false,
),
array(
'name' => 'namaBarang',
'value' => '$data->barang->nama',
'filter' => false,
),
array(
'name' => 'kategoriId',
'value' => '$data->barang->kategori->nama',
'filter' => LabelRakCetak::model()->filterKategori()
),
array(
'header' => 'Satuan',
'value' => '$data->barang->satuan->nama'
),
array(
'header' => 'Harga Jual',
'value' => '$data->barang->hargajual'
),
array(
'class' => 'BButtonColumn',
'header' => '<a id="tombol-hapus-semua" href="'.$this->createUrl('hapussemua').'"><i class="fa fa-times"></i></a>'
),
),
));
