$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)); }