/**
* Lists all models.
*/
public function actionIndex()
{
parent::actionIndex();
$deliveryadvicedetail = new Deliveryadvicedetail('search');
$deliveryadvicedetail->unsetAttributes();
// clear any default values
if (isset($_GET['Deliveryadvicedetail'])) {
$deliveryadvicedetail->attributes = $_GET['Deliveryadvicedetail'];
}
$product = new Product('search');
$product->unsetAttributes();
// clear any default values
if (isset($_GET['Product'])) {
$product->attributes = $_GET['Product'];
}
$unitofmeasure = new Unitofmeasure('search');
$unitofmeasure->unsetAttributes();
// clear any default values
if (isset($_GET['Unitofmeasure'])) {
$unitofmeasure->attributes = $_GET['Unitofmeasure'];
}
$sloc = new Sloc('search');
$sloc->unsetAttributes();
// clear any default values
if (isset($_GET['Sloc'])) {
$sloc->attributes = $_GET['Sloc'];
}
$requestedby = new Requestedby('search');
$requestedby->unsetAttributes();
// clear any default values
if (isset($_GET['Requestedby'])) {
$requestedby->attributes = $_GET['Requestedby'];
}
$model = new Deliveryadvice('search');
$model->unsetAttributes();
// clear any default values
if (isset($_GET['Deliveryadvice'])) {
$model->attributes = $_GET['Deliveryadvice'];
}
if (isset($_GET['pageSize'])) {
Yii::app()->user->setState('pageSize', (int) $_GET['pageSize']);
unset($_GET['pageSize']);
// would interfere with pager and repetitive page size change
}
$this->render('index', array('model' => $model, 'deliveryadvicedetail' => $deliveryadvicedetail, 'product' => $product, 'unitofmeasure' => $unitofmeasure, 'sloc' => $sloc, 'requestedby' => $requestedby));
}
public function actionDownload()
{
parent::actionDownload();
$pdf = new PDF();
$pdf->title = 'Material Stock Overview List';
$pdf->AddPage('L');
$pdf->setFont('Arial', 'B', 12);
// definisi font
$pdf->setFont('Arial', 'B', 8);
// menuliskan tabel
$header = array('No', 'ID', 'Material Name', 'Sloc', 'Qty', 'UOM', 'Prod Trans Type', 'Ref Source');
$model = new Productstock('search');
$dataprovider = $model->search();
$dataprovider->pagination = false;
$data = $dataprovider->getData();
$cols = $dataprovider->getKeys();
$dataku = array(count($data));
//var_dump($dataku);
$w = array(10, 15, 70, 30, 30, 30, 40, 30);
$pdf->SetTableHeader();
//Header
for ($i = 0; $i < count($header); $i++) {
$pdf->Cell($w[$i], 7, $header[$i], 1, 0, 'C', true);
}
$pdf->Ln();
$pdf->SetTableData();
//Data
$fill = false;
$i = 0;
foreach ($data as $datas) {
$i = $i + 1;
$pdf->Cell($w[0], 6, $i, 'LR', 0, 'L', $fill);
$pdf->Cell($w[1], 6, $datas['productstockid'], 'LR', 0, 'L', $fill);
$pdf->Cell($w[2], 6, Product::model()->findbypk($datas['productid'])->productname, 'LR', 0, 'L', $fill);
$pdf->Cell($w[3], 6, Sloc::model()->findbypk($datas['slocid'])->sloccode, 'LR', 0, 'L', $fill);
$pdf->Cell($w[4], 6, $datas['qty'], 'LR', 0, 'L', $fill);
$pdf->Cell($w[5], 6, Unitofmeasure::model()->findbypk($datas['unitofmeasureid'])->uomcode, 'LR', 0, 'L', $fill);
$pdf->Cell($w[6], 6, Prodtranstype::model()->findbypk($datas['prodtranstypeid'])->description, 'LR', 0, 'L', $fill);
$pdf->Cell($w[7], 6, $datas['refsource'], 'LR', 0, 'L', $fill);
$pdf->Ln();
$fill = !$fill;
}
$pdf->Cell(array_sum($w), 0, '', 'T');
// me-render ke browser
$pdf->Output('productstock.pdf', 'D');
}
/**
* Lists all models.
*/
public function actionIndex()
{
parent::actionIndex();
$purchasingorg = new Purchasingorg('search');
$purchasingorg->unsetAttributes();
// clear any default values
if (isset($_GET['Purchasingorg'])) {
$purchasingorg->attributes = $_GET['Purchasingorg'];
}
$paymentmethod = new Paymentmethod('search');
$paymentmethod->unsetAttributes();
// clear any default values
if (isset($_GET['Paymentmethod'])) {
$paymentmethod->attributes = $_GET['Paymentmethod'];
}
$purchasinggroup = new Purchasinggroup('search');
$purchasinggroup->unsetAttributes();
// clear any default values
if (isset($_GET['Purchasinggroup'])) {
$purchasinggroup->attributes = $_GET['Purchasinggroup'];
}
$supplier = new Supplier('search');
$supplier->unsetAttributes();
// clear any default values
if (isset($_GET['Supplier'])) {
$supplier->attributes = $_GET['Supplier'];
}
$podetail = new Podetail('search');
$podetail->unsetAttributes();
// clear any default values
if (isset($_GET['Podetail'])) {
$podetail->attributes = $_GET['Podetail'];
}
$product = new Prmaterial('search');
$product->unsetAttributes();
// clear any default values
if (isset($_GET['Prmaterial'])) {
$product->attributes = $_GET['Prmaterial'];
}
$unitofmeasure = new Unitofmeasure('search');
$unitofmeasure->unsetAttributes();
// clear any default values
if (isset($_GET['Unitofmeasure'])) {
$unitofmeasure->attributes = $_GET['Unitofmeasure'];
}
$currency = new Currency('search');
$currency->unsetAttributes();
// clear any default values
if (isset($_GET['Currency'])) {
$currency->attributes = $_GET['Currency'];
}
$sloc = new Sloc('search');
$sloc->unsetAttributes();
// clear any default values
if (isset($_GET['Sloc'])) {
$sloc->attributes = $_GET['Sloc'];
}
$tax = new Tax('search');
$tax->unsetAttributes();
// clear any default values
if (isset($_GET['Tax'])) {
$tax->attributes = $_GET['Tax'];
}
$model = new Poheader('search');
$model->unsetAttributes();
// clear any default values
if (isset($_GET['Poheader'])) {
$model->attributes = $_GET['Poheader'];
}
if (isset($_GET['pageSize'])) {
Yii::app()->user->setState('pageSize', (int) $_GET['pageSize']);
unset($_GET['pageSize']);
// would interfere with pager and repetitive page size change
}
$this->render('index', array('model' => $model, 'purchasingorg' => $purchasingorg, 'purchasinggroup' => $purchasinggroup, 'paymentmethod' => $paymentmethod, 'supplier' => $supplier, 'podetail' => $podetail, 'product' => $product, 'unitofmeasure' => $unitofmeasure, 'currency' => $currency, 'sloc' => $sloc, 'tax' => $tax, 'podetail' => $podetail));
}
echo $form->error($model, 'ratevalue');
?>
</div>
</td>
</tr>
<tr>
<td>
<div class="row">
<?php
echo $form->labelEx($model, 'slocid');
echo $form->hiddenField($model, 'slocid');
?>
<input type="text" name="sloccode" id="sloccode" readonly >
<?php
$this->beginWidget('zii.widgets.jui.CJuiDialog', array('id' => 'sloc_dialog', 'options' => array('title' => Yii::t('app', 'Storage Location'), 'width' => 'auto', 'autoOpen' => false, 'modal' => true)));
$sloc = new Sloc('search');
$sloc->unsetAttributes();
// clear any default values
if (isset($_GET['Sloc'])) {
$sloc->attributes = $_GET['Sloc'];
}
$this->widget('zii.widgets.grid.CGridView', array('id' => 'sloc-grid', 'dataProvider' => $sloc->Searchwstatus(), 'filter' => $sloc, 'template' => '{summary}{pager}<br>{items}{pager}{summary}', 'columns' => array(array('header' => '', 'type' => 'raw', 'value' => 'CHtml::Button("+",
array("name" => "send_absschedule",
"id" => "send_absschedule",
"onClick" => "$(\\"#sloc_dialog\\").dialog(\\"close\\"); $(\\"#sloccode\\").val(\\"$data->sloccode\\"); $(\\"#Podetail_slocid\\").val(\\"$data->slocid\\");
"))'), array('name' => 'slocid', 'visible' => false, 'value' => '$data->slocid'), 'sloccode', 'description')));
$this->endWidget('zii.widgets.jui.CJuiDialog');
echo CHtml::Button('...', array('onclick' => '$.fn.yiiGridView.update("sloc-grid");$("#sloc_dialog").dialog("open"); return false;'));
?>
<?php
echo $form->error($model, 'unitofmeasureid');
/**
* 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 the ID of the model to be loaded
*/
public function loadModel($id)
{
$model = Sloc::model()->findByPk((int) $id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
