public static function generate($puskesmas_id)
{
$obats = Obat::model()->findAll();
foreach ($obats as $obat) {
$o = new ObatStokHistory();
$o->bulan = date("m", strtotime(date("Y-m-d") . " -1 month"));
$o->tahun = date("Y", strtotime(date("Y-m-d") . " -1 month"));
$o->puskesmas_id = $puskesmas_id;
$o->obat_id = $obat->id;
$o->jumlah = $obat->getStokTotal($puskesmas_id);
$o->save();
}
}
private function process($_tanggal, $_tanggal2, $tujuan_id)
{
$reportName = "laporan_obat";
$objPHPExcel = $this->loadPHPExcelLib($reportName);
$objPHPExcel->setActiveSheetIndex(0);
$activeSheet = $objPHPExcel->getActiveSheet();
$tanggal = $this->reverseDate($_tanggal);
$tanggal2 = $this->reverseDate($_tanggal2);
$puskesmas_id = Yii::app()->user->puskesmas_id;
$puskesmas = Puskesmas::model()->findByPk($puskesmas_id);
$departemen_id = Departemen::model()->findByAttributes(array("puskesmas_id" => $puskesmas_id, "departemen_jenis_id" => "1"))->id;
$tujuan = DistribusiObatTujuan::model()->findByPk($tujuan_id);
$activeSheet->getCell("A8")->setValue(strtoupper($tujuan->nama . " - PUSKESMAS " . $puskesmas->nama));
$activeSheet->getCell("A5")->setValue("PEMAKAIAN TANGGAL " . $_tanggal . " S/D " . $_tanggal2);
//echo "$tujuan_id, $departemen_id, $puskesmas_id";
$no = 1;
$baris = 12;
$obatArr = Obat::model()->findAll();
foreach ($obatArr as $obat) {
$data = KartuStok::kalkulasiStokObat($obat->id, $tujuan_id, $departemen_id, $puskesmas_id, FALSE);
$masuk = 0;
$keluar = 0;
foreach ($data as $d) {
//echo "Perbandingan : ".strtotime($tanggal)." > ".strtotime($d["date"])." > ".strtotime($tanggal2);
//echo "<br>";
if (strtotime($tanggal) <= strtotime($d["date"]) && strtotime($d["date"]) < strtotime($tanggal2) + 86400) {
$masuk += $d["masuk"];
$keluar += $d["keluar"];
} else {
continue;
}
}
$activeSheet->setCellValue("A" . $baris, $no);
$activeSheet->setCellValue("B" . $baris, $obat->nama);
$activeSheet->setCellValue("C" . $baris, ObatSatuan::model()->findByPk($obat->kemasan_id)->nama);
$activeSheet->setCellValue("D" . $baris, $masuk);
$activeSheet->setCellValue("E" . $baris, $keluar);
$no++;
$baris++;
}
$activeSheet->getStyle("A12:E" . ($baris - 1))->applyFromArray(array('borders' => array('allborders' => array('style' => PHPExcel_Style_Border::BORDER_THIN))));
return array("phpexcel" => $objPHPExcel, "name" => $reportName . "_" . $_tanggal . "_" . $_tanggal2);
}
public static function adjustStokObat($tujuan_id, $departemen_id, $puskesmas_id)
{
foreach (Obat::model()->findAll() as $obat) {
$dataTransaksi = KartuStok::kalkulasiStokObat($obat->id, $tujuan_id, $departemen_id, $puskesmas_id);
$saldo = 0;
foreach ($dataTransaksi as $key => $trans) {
$saldo = $saldo + $trans["masuk"] - $trans["keluar"];
}
$obatDept = ObatDepartemen::model()->findByAttributes(array("puskesmas_id" => $puskesmas_id, "departemen_id" => $departemen_id, "distribusi_obat_tujuan_id" => $tujuan_id, "obat_id" => $obat->id));
if ($obatDept == NULL) {
$obatDept = new ObatDepartemen();
$obatDept->puskesmas_id = $puskesmas_id;
$obatDept->departemen_id = $departemen_id;
$obatDept->distribusi_obat_tujuan_id = $tujuan_id;
$obatDept->obat_id = $obat->id;
}
$obatDept->stok = $saldo;
$obatDept->save();
}
}
<?php
$form = $this->beginWidget('booster.widgets.TbActiveForm', array('id' => 'verticalForm', 'htmlOptions' => array('class' => 'well')));
?>
<table WIDTH="100%" >
<TR>
<TD width="45%" valign="center">
<font size="4"><b>Nama Obat </b></font>
<?php
echo $form->errorSummary($model);
?>
<?php
$nama = CHtml::listData(Obat::model()->findAll(), 'id_obat', 'nama');
//var_dump($nama);
?>
<?php
$this->widget('ext.select2.ESelect2', array('model' => $model2, 'attribute' => 'id_obat', 'data' => $nama, 'htmlOptions' => array('style' => 'width:330px', 'prompt' => '-- Pilih Obat --', 'ajax' => array('type' => 'POST', 'url' => CController::createUrl('Beli/SelectKetersedian'), 'class' => 'span5', 'update' => '#' . CHtml::activeId($model2, 'jumlah'), 'beforeSend' => 'function() {$("#Beli_jumlah").find("option").remove();}'))));
?>
<br>
<font size="4"><b>Banyak Obat   </b><br></font>
<?php
echo $form->dropDownList($model2, 'jumlah', !$model->isNewRecord ? $model2->jumlah() : array(), array('style' => 'width:55px', 'prompt' => '0', 'ajax' => array('type' => 'POST', 'url' => CController::createUrl('Beli/SelectHarga'), 'class' => 'span5', 'update' => "#kode")));
?>
</TD>
<td width="" rowspan="2" bgcolor="#eee" >
</td>
<td rowspan="2" width="65%">
<div id="kode" class="alert alert-info"></div>
</td>
</TR>
public function loadModelUpdate($id)
{
$model = Obat::model()->findByPk($id);
$model->jumlah = 0;
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
//echo "Pembelian sukses";
//var_dump($result);
$counter = 0;
$arr_idObat = array();
$arr_qty = array();
$arr_sisa = array();
$arr_untung = array();
$arr_keterangan = array();
//$model = new Obat;
foreach ($result as $xyz) {
//echo $xyz['id_obat']."<br>";
$arr_idObat[$counter] = $xyz['id_obat'];
$arr_qty[$counter] = $xyz['qty'];
$arr_keterangan[$counter] = $xyz['keterangan'];
$model = Obat::model()->findByPk($xyz['id_obat']);
$model->jumlah = $model->jumlah - $xyz['qty'];
$model->save();
$sisa_result = Yii::app()->db->createCommand("SELECT jumlah FROM obat WHERE `id_obat`= '{$arr_idObat[$counter]}'")->queryAll();
foreach ($sisa_result as $zz) {
$sisa = $zz['jumlah'];
}
$arr_sisa[$counter] = $sisa;
$hargabeli_result = Yii::app()->db->createCommand("SELECT hargabeli FROM obat WHERE `id_obat`= '{$arr_idObat[$counter]}'")->queryAll();
foreach ($hargabeli_result as $xx) {
$hargabeli = $xx['hargabeli'];
}
foreach ($hargabeli_result as $xx) {
$hargabeli = $xx['hargabeli'];
}
$arr_untung[$counter] = 0;
<?php
include "config/koneksi.php";
include "src/Obat.php";
$error = "";
$edit_obat = new Obat($dbh);
if (isset($_POST['submit'])) {
if (empty($_POST['namaobat'])) {
$error .= "<p>Nama obat harus diisi</p>";
}
if (empty($_POST['jenis'])) {
$error .= "<p>jenis obat harus diisi</p>";
}
if (empty($_POST['harga'])) {
$error .= "<p>harga harus diisi</p>";
}
if (empty($_POST['stock'])) {
$error .= "<p>stok harus diisi</p>";
}
if (empty($error)) {
$idobat = $_GET['id_edit'];
$namaobat = $_POST['namaobat'];
$jenis = $_POST['jenis'];
$harga = $_POST['harga'];
$stock = $_POST['stock'];
$edit_obat->updateDataObat($idobat, $namaobat, $jenis, $harga, $stock);
header("Location: index.php?update");
}
}
if (isset($_GET['id_edit'])) {
$idobat = $_GET['id_edit'];
echo $form->textFieldGroup($model, 'hargabeli', array('widgetOptions' => array('htmlOptions' => array('class' => 'span5', 'maxlength' => 10))));
?>
<?php
echo $form->textFieldGroup($model, 'hargajual', array('widgetOptions' => array('htmlOptions' => array('class' => 'span5', 'maxlength' => 10))));
?>
<?php
echo $form->datePickerGroup($model, 'tgl_kadaluarsa', array('widgetOptions' => array('options' => array('showButtonPanel' => true, 'format' => 'yyyy-mm-dd', 'viewformat' => 'yyyy-mm-dd', 'todayHighlight' => true, 'todayBtn' => "linked"), 'htmlOptions' => array('class' => 'span5')), 'prepend' => '<i class="glyphicon glyphicon-calendar"></i>', 'append' => 'Pilih Tanggal'));
?>
<?php
echo $form->textFieldGroup($model, 'satuan_brg', array('widgetOptions' => array('htmlOptions' => array('class' => 'span5', 'maxlength' => 10))));
?>
<?php
echo $form->textFieldGroup($model2, 'no_faktur', array('widgetOptions' => array('htmlOptions' => array('class' => 'span5', 'maxlength' => 10))));
$nama = CHtml::listData(Obat::model()->findAll(), 'nama_supplier', 'nama_supplier');
?>
<?php
$this->widget('ext.select2.ESelect2', array('model' => $model2, 'attribute' => 'distributor', 'data' => $nama, 'htmlOptions' => array('style' => 'width:330px', 'prompt' => '-- Pilih Distributor --')));
?>
<div class="form-actions">
<?php
$this->widget('booster.widgets.TbButton', array('buttonType' => 'submit', 'context' => 'primary', 'label' => $model->isNewRecord ? 'Create' : 'Save'));
?>
</div>
<?php
$this->endWidget();
<?php
include "config/koneksi.php";
include "src/Obat.php";
$hapus_obat = new Obat($dbh);
$hasil = $hapus_obat->getDataObat();
if (isset($_GET['delete'])) {
$hapus_obat->deleteObat($_GET['delete']);
}
include "view/header.php";
?>
<?php
if (isset($_GET['inserted'])) {
?>
<div class="container">
<div class="alert alert-info">
Selamat Data Telah Tersimpan...!
</div>
</div>
<?php
}
if (isset($_GET['update'])) {
?>
<div class="container">
<div class="alert alert-info">
Selamat Data Telah diubah...!
</div>
</div>
<?php
}
<?php
$records = Obat::model()->findAll();
$list = CHtml::listData($records, 'id_obat', 'nama');
echo CHtml::dropDownList('names', null, $list);
?>
<?php
$form = $this->beginWidget('booster.widgets.TbActiveForm', array('id' => 'jual-beli-form', 'enableAjaxValidation' => false));
?>
<p class="help-block">Fields with <span class="required">*</span> are required.</p>
<?php
echo $form->errorSummary($model);
?>
<?php
public function actionAdmin()
{
$model = new Obat('search');
$model->unsetAttributes();
// clear any default values
if (isset($_GET['Obat'])) {
$model->attributes = $_GET['Obat'];
}
$this->render('admin', array('model' => $model));
}
