$form = $this->beginWidget('CActiveForm', array('id' => 'snrodet-form', 'enableAjaxValidation' => false));
?>
<div id="toolbarform">
<?php
$this->widget('ToolbarButton', array('isSave' => true, 'UrlSave' => 'snro/write', 'isCancel' => true, 'UrlCancel' => 'snro/cancelwrite'));
?>
</div>
<?php
echo $form->hiddenField($model, 'snrodid');
?>
<div class="row">
<?php
echo $form->labelEx($model, 'snroid');
?>
<?php
echo $form->dropDownList($model, 'snroid', CHtml::listData(Snro::model()->findAll(), 'snroid', 'description'), array('prompt' => 'Select a Specific Number Range Object'));
?>
<?php
echo $form->error($model, 'snroid');
?>
</div>
<div class="row">
<?php
echo $form->labelEx($model, 'curdd');
?>
<?php
echo $form->textField($model, 'curdd');
?>
<?php
echo $form->error($model, 'curdd');
?>
<?php
echo $form->error($model, 'permitinname');
?>
</div>
<div class="row">
<?php
echo $form->labelEx($model, 'snroid');
?>
<?php
echo $form->hiddenField($model, 'snroid');
?>
<input type="text" name="stat_name" id="description" readonly style="width:80%"
value="<?php
echo Snro::model()->findByPk($model->snroid) !== null ? Snro::model()->findByPk($model->snroid)->description : '';
?>
">
<?php
$this->beginWidget('zii.widgets.jui.CJuiDialog', array('id' => 'snro_dialog', 'options' => array('title' => Yii::t('app', 'Absence Status'), 'width' => 'auto', 'autoOpen' => false, 'modal' => true)));
$this->widget('zii.widgets.grid.CGridView', array('id' => 'absstatus-grid', 'dataProvider' => $snro->searchwstatus(), 'filter' => $snro, 'template' => '{summary}{pager}<br>{items}{pager}{summary}', 'columns' => array(array('header' => '', 'type' => 'raw', 'value' => 'CHtml::Button("+",
array("name" => "send_absstatus",
"id" => "send_absstatus",
"onClick" => "$(\\"#snro_dialog\\").dialog(\\"close\\"); $(\\"#description\\").val(\\"$data->description\\"); $(\\"#Permitin_snroid\\").val(\\"$data->snroid\\");"))'), array('name' => 'snroid', 'visible' => false, 'value' => '$data->snroid', 'htmlOptions' => array('width' => '1%')), 'description', 'formatdoc', array('class' => 'CCheckBoxColumn', 'name' => 'recordstatus', 'selectableRows' => '0', 'header' => 'Record Status', 'checked' => '$data->recordstatus'))));
$this->endWidget('zii.widgets.jui.CJuiDialog');
echo CHtml::Button('...', array('onclick' => '$("#snro_dialog").dialog("open"); return false;'));
?>
</div>
<div class="row">
<?php
/**
* 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 = Snro::model()->findByPk((int) $id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
<?php
echo $form->error($model, 'sled');
?>
</div>
<div class="row">
<?php
echo $form->labelEx($model, 'snroid');
?>
<?php
echo $form->hiddenField($model, 'snroid');
?>
<input type="text" name="description" id="description" readonly >
<?php
$this->beginWidget('zii.widgets.jui.CJuiDialog', array('id' => 'snro_dialog', 'options' => array('title' => Yii::t('app', 'Specific Number Range Object'), 'width' => 'auto', 'autoOpen' => false, 'modal' => true)));
$snro = new Snro('searchwstatus');
$snro->unsetAttributes();
// clear any default values
if (isset($_GET['Snro'])) {
$snro->attributes = $_GET['Snro'];
}
$this->widget('zii.widgets.grid.CGridView', array('id' => 'snro-grid', 'dataProvider' => $snro->Searchwstatus(), 'filter' => $snro, 'template' => '{summary}{pager}<br>{items}{pager}{summary}', 'columns' => array(array('header' => '', 'type' => 'raw', 'value' => 'CHtml::Button("V",
array("name" => "send_city",
"id" => "send_city",
"onClick" => "$(\\"#snro_dialog\\").dialog(\\"close\\");
$(\\"#description\\").val(\\"$data->description\\");
$(\\"#Productplant_snroid\\").val(\\"$data->snroid\\");"))'), array('name' => 'snroid', 'visible' => false, 'value' => '$data->snroid', 'htmlOptions' => array('width' => '1%')), 'description')));
$this->endWidget('zii.widgets.jui.CJuiDialog');
echo CHtml::Button('...', array('onclick' => '$("#snro_dialog").dialog("open"); return false;'));
?>
<?php
public function actionDownload()
{
parent::actionDownload();
$pdf = new PDF();
$pdf->title = 'Permit In List';
$pdf->AddPage('P');
$pdf->setFont('Arial', 'B', 12);
// definisi font
$pdf->setFont('Arial', 'B', 8);
// menuliskan tabel
$header = array('No', 'Permit In Name', 'SNRO');
$model = new Permitin('searchwstatus');
$dataprovider = $model->searchwstatus();
$dataprovider->pagination = false;
$data = $dataprovider->getData();
$cols = $dataprovider->getKeys();
$dataku = array(count($data));
//var_dump($dataku);
$w = array(20, 70, 50);
$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['permitinname'], 'LR', 0, 'L', $fill);
$pdf->Cell($w[2], 6, Snro::model()->findbypk($datas['snroid'])->formatdoc, 'LR', 0, 'L', $fill);
$pdf->Ln();
$fill = !$fill;
}
$pdf->Cell(array_sum($w), 0, '', 'T');
// me-render ke browser
$pdf->Output('permitin.pdf', 'D');
}
public function actionUpload()
{
parent::actionUpload();
$folder = $_SERVER['DOCUMENT_ROOT'] . Yii::app()->request->baseUrl . '/upload/';
// folder for uploaded files
$file = $folder . basename($_FILES['uploadfile']['name']);
if (move_uploaded_file($_FILES['uploadfile']['tmp_name'], $file)) {
$row = 0;
if (($handle = fopen($file, "r")) !== FALSE) {
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
if ($row > 0) {
$model = Employeetype::model()->findByPk((int) $data[0]);
if ($model === null) {
$model = new Employeetype();
}
$model->employeetypeid = (int) $data[0];
$model->employeetypename = $data[1];
$snro = Snro::model()->findbyattributes(array('description' => $data[2]));
if ($snro != null) {
$model->snroid = $snro->snroid;
}
$snro = Snro::model()->findbyattributes(array('description' => $data[3]));
if ($snro != null) {
$model->sicksnroid = $snro->snroid;
}
$snro = Absstatus::model()->findbyattributes(array('shortstat' => $data[4]));
if ($snro != null) {
$model->sickstatusid = $snro->absstatusid;
}
$model->recordstatus = (int) $data[5];
try {
if (!$model->save()) {
$this->messages = $this->messages . Catalogsys::model()->getcatalog(' upload error at ' . $data[0]);
}
} catch (Exception $e) {
$this->messages = $this->messages . $e->getMessage();
}
}
$row++;
}
} else {
$this->messages = $this->messages . ' memory or harddisk full';
}
fclose($handle);
} else {
$this->messages = $this->messages . ' check your directory permission';
}
if ($this->messages == '') {
$this->messages = 'success';
}
echo $this->messages;
}
/**
* Lists all models.
*/
public function actionIndex()
{
parent::actionIndex();
$snro = new Snro('searchwstatus');
$snro->unsetAttributes();
// clear any default values
if (isset($_GET['Snro'])) {
$snro->attributes = $_GET['Snro'];
}
$model = new Permitexit('search');
$model->unsetAttributes();
// clear any default values
if (isset($_GET['Permitexit'])) {
$model->attributes = $_GET['Permitexit'];
}
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, 'snro' => $snro));
}
