<div class="form">
<?php
$form = $this->beginWidget('CActiveForm', array('id' => 'absrule-form', 'enableAjaxValidation' => false));
$this->widget('ToolbarButton', array('isSave' => true, 'UrlSave' => 'absrule/write', 'isCancel' => true, 'UrlCancel' => 'absrule/cancelwrite'));
echo $form->hiddenField($model, 'absruleid');
?>
<div class="row">
<?php
echo $form->labelEx($model, 'absscheduleid');
?>
<?php
echo $form->hiddenField($model, 'absscheduleid');
?>
<input type="text" name="sched_name" id="sched_name" readonly value="<?php
echo Absschedule::model()->findByPk($model->absscheduleid) !== null ? Absschedule::model()->findByPk($model->absscheduleid)->absschedulename : '';
?>
">
<?php
$this->beginWidget('zii.widgets.jui.CJuiDialog', array('id' => 'absschedule_dialog', 'options' => array('title' => Yii::t('app', 'Absence Schedules'), 'width' => 'auto', 'autoOpen' => false, 'modal' => true)));
$this->widget('zii.widgets.grid.CGridView', array('id' => 'absschedule-grid', 'dataProvider' => $absschedule->Searchwstatus(), 'filter' => $absschedule, 'template' => '{summary}{pager}<br>{items}{pager}{summary}', 'columns' => array(array('header' => '', 'type' => 'raw', 'value' => 'CHtml::Button("+",
array("name" => "send_absschedule",
"id" => "send_absschedule",
"onClick" => "$(\\"#absschedule_dialog\\").dialog(\\"close\\"); $(\\"#sched_name\\").val(\\"$data->absschedulename\\"); $(\\"#Absrule_absscheduleid\\").val(\\"$data->absscheduleid\\");
"))'), array('name' => 'absscheduleid', 'visible' => false, 'value' => '$data->absscheduleid', 'htmlOptions' => array('width' => '1%')), 'absschedulename', 'absin', 'absout', array('name' => 'absstatusid', 'header' => 'Status', 'value' => '$data->absstatus->shortstat'), array('class' => 'CCheckBoxColumn', 'name' => 'recordstatus', 'selectableRows' => '0', 'header' => 'Record Status', 'checked' => '$data->recordstatus'))));
$this->endWidget('zii.widgets.jui.CJuiDialog');
echo CHtml::Button('...', array('onclick' => '$("#absschedule_dialog").dialog("open"); return false;'));
?>
<?php
echo $form->error($model, 'absscheduleid');
?>
</div>
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) {
$empid = Employee::model()->findbyattributes(array('oldnik' => $data[0]));
$model = new Employeeschedule();
if ($empid != null) {
$model = Employeeschedule::model()->findByattributes(array('employeeid' => $empid->employeeid, 'month' => $data[2], 'year' => $data[3]));
if ($model == null) {
$model = new Employeeschedule();
}
$model->employeeid = $empid->employeeid;
$model->month = $data[2];
$model->year = $data[3];
$d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[4]));
if ($d != null) {
$model->d1 = $d->absscheduleid;
}
$d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[5]));
if ($d != null) {
$model->d2 = $d->absscheduleid;
}
$d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[6]));
if ($d != null) {
$model->d3 = $d->absscheduleid;
}
$d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[7]));
if ($d != null) {
$model->d4 = $d->absscheduleid;
}
$d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[8]));
if ($d != null) {
$model->d5 = $d->absscheduleid;
}
$d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[9]));
if ($d != null) {
$model->d6 = $d->absscheduleid;
}
$d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[10]));
if ($d != null) {
$model->d7 = $d->absscheduleid;
}
$d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[11]));
if ($d != null) {
$model->d8 = $d->absscheduleid;
}
$d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[12]));
if ($d != null) {
$model->d9 = $d->absscheduleid;
}
$d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[13]));
if ($d != null) {
$model->d10 = $d->absscheduleid;
}
$d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[14]));
if ($d != null) {
$model->d11 = $d->absscheduleid;
}
$d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[15]));
if ($d != null) {
$model->d12 = $d->absscheduleid;
}
$d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[16]));
if ($d != null) {
$model->d13 = $d->absscheduleid;
}
$d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[17]));
if ($d != null) {
$model->d14 = $d->absscheduleid;
}
$d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[18]));
if ($d != null) {
$model->d15 = $d->absscheduleid;
}
$d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[19]));
if ($d != null) {
$model->d16 = $d->absscheduleid;
}
$d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[20]));
if ($d != null) {
$model->d17 = $d->absscheduleid;
}
$d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[21]));
if ($d != null) {
$model->d18 = $d->absscheduleid;
}
$d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[22]));
if ($d != null) {
$model->d19 = $d->absscheduleid;
}
$d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[23]));
if ($d != null) {
$model->d20 = $d->absscheduleid;
}
$d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[24]));
if ($d != null) {
$model->d21 = $d->absscheduleid;
}
$d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[25]));
if ($d != null) {
$model->d22 = $d->absscheduleid;
}
$d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[26]));
if ($d != null) {
$model->d23 = $d->absscheduleid;
}
$d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[27]));
if ($d != null) {
$model->d24 = $d->absscheduleid;
}
$d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[28]));
if ($d != null) {
$model->d25 = $d->absscheduleid;
}
$d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[29]));
if ($d != null) {
$model->d26 = $d->absscheduleid;
}
$d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[30]));
if ($d != null) {
$model->d27 = $d->absscheduleid;
}
$d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[31]));
if ($d != null) {
$model->d28 = $d->absscheduleid;
}
$d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[32]));
if ($d != null) {
$model->d29 = $d->absscheduleid;
}
$d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[33]));
if ($d != null) {
$model->d30 = $d->absscheduleid;
}
$d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[34]));
if ($d != null) {
$model->d31 = $d->absscheduleid;
}
$model->recordstatus = Wfgroup::model()->findstatusbyuser('insempsched');
}
try {
if (!$model->save()) {
$this->messages = $this->messages . Catalogsys::model()->getcatalog(' upload error at ' . $data[0]);
} else {
$a = Yii::app()->user->name;
$connection = Yii::app()->db;
$transaction = $connection->beginTransaction();
try {
$sql = 'call ApproveEmployeeSchedule(:vid, :vlastupdateby)';
$command = $connection->createCommand($sql);
$command->bindvalue(':vid', $model->employeescheduleid, PDO::PARAM_INT);
$command->bindvalue(':vlastupdateby', $a, PDO::PARAM_STR);
$command->execute();
$transaction->commit();
} catch (Exception $e) {
$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;
}
</td>
</tr>
<tr>
<td>
<div class="row">
<?php
echo $form->labelEx($model, 'd31');
echo $form->hiddenField($model, 'd31');
?>
<input type="text" name="d31_name" id="d31_name" readonly value="<?php
echo Absschedule::model()->findByPk($model->d31) !== null ? Absschedule::model()->findByPk($model->d31)->absschedulename : '';
?>
">
<?php
$this->beginWidget('zii.widgets.jui.CJuiDialog', array('id' => 'd31_dialog', 'options' => array('title' => Yii::t('app', 'Schedule'), 'width' => 'auto', 'autoOpen' => false, 'modal' => true)));
$d31 = new Absschedule('searchwstatus');
$d31->unsetAttributes();
// clear any default values
if (isset($_GET['Absschedule'])) {
$d31->attributes = $_GET['Absschedule'];
}
$this->widget('zii.widgets.grid.CGridView', array('id' => 'd31-grid', 'dataProvider' => $d31->Searchwstatus(), 'filter' => $d31, 'template' => '{summary}{pager}<br>{items}{pager}{summary}', 'columns' => array(array('header' => '', 'type' => 'raw', 'value' => 'CHtml::Button("+",
array("name" => "send_d31",
"id" => "send_d31",
"onClick" => "$(\\"#d31_dialog\\").dialog(\\"close\\"); $(\\"#d31_name\\").val(\\"$data->absschedulename\\"); $(\\"#Employeeschedule_d31\\").val(\\"$data->absscheduleid\\");"))'), array('name' => 'absscheduleid', 'visible' => false, 'value' => '$data->absscheduleid', 'htmlOptions' => array('width' => '1%')), 'absschedulename', array('class' => 'CCheckBoxColumn', 'name' => 'recordstatus', 'selectableRows' => '0', 'header' => 'Record Status', 'checked' => '$data->recordstatus'))));
$this->endWidget('zii.widgets.jui.CJuiDialog');
echo CHtml::Button('...', array('onclick' => '$("#d31_dialog").dialog("open"); return false;'));
?>
<?php
echo $form->error($model, 'd31');
?>
public function actionDownload()
{
parent::actionDownload();
$pdf = new PDF();
$pdf->title = 'Absence Schedule List';
$pdf->AddPage('L');
$pdf->setFont('Arial', 'B', 12);
// definisi font
$pdf->setFont('Arial', 'B', 8);
// menuliskan tabel
$header = array('No', 'ID', 'Schedule Name', 'Absence In', 'Absence Out', 'Status', 'Wage Name', 'Currency', 'Insentif');
$model = new Absschedule('searchwstatus');
$dataprovider = $model->searchwstatus();
$dataprovider->pagination = false;
$data = $dataprovider->getData();
$cols = $dataprovider->getKeys();
$dataku = array(count($data));
//var_dump($dataku);
$w = array(20, 25, 30, 30, 30, 30, 30, 30, 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;
foreach ($data as $n => $datas) {
$pdf->Cell($w[0], 6, $n, 'LR', 0, 'C', $fill);
$pdf->Cell($w[1], 6, $datas['absscheduleid'], 'LR', 0, 'C', $fill);
$pdf->Cell($w[2], 6, $datas['absschedulename'], 'LR', 0, 'C', $fill);
$pdf->Cell($w[3], 6, $datas['absin'], 'LR', 0, 'C', $fill);
$pdf->Cell($w[4], 6, $datas['absout'], 'LR', 0, 'C', $fill);
$pdf->Cell($w[5], 6, Absstatus::model()->findByPk($datas['absstatusid'])->shortstat, 'LR', 0, 'C', $fill);
$pdf->Cell($w[6], 6, Wagetype::model()->findByPk($datas['wagetypeid'])->wagename, 'LR', 0, 'C', $fill);
$pdf->Cell($w[7], 6, Currency::model()->findByPk($datas['currencyid'])->currencyname, 'LR', 0, 'C', $fill);
$pdf->Cell($w[8], 6, number_format($datas['insentif']), 'LR', 0, 'C', $fill);
$pdf->Ln();
$fill = !$fill;
}
$pdf->Cell(array_sum($w), 0, '', 'T');
// me-render ke browser
$pdf->Output();
}
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 = Absrule::model()->findByPk((int) $data[0]);
if ($model === null) {
$model = new Absrule();
}
$model->absruleid = (int) $data[0];
$absschedule = Absschedule::model()->findbyattributes(array('absschedulename' => $data[1]));
if ($absschedule != null) {
$model->absscheduleid = $absschedule->absscheduleid;
}
$model->difftimein = $data[2];
$model->difftimeout = $data[3];
$absstatus = Absstatus::model()->findbyattributes(array('shortstat' => $data[4]));
if ($absstatus != null) {
$model->absstatusid = $absstatus->absstatusid;
}
$model->recordstatus = 1;
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;
}
