public function actionAdmin()
{
$sukses = false;
$gagal = false;
$alreadySlip = false;
$slipExists = false;
$loadModelFirstname = $this->loadModelFirstname();
if (isset($_POST['Listgaji'])) {
Yii::import('ext.phpexcelreader.JPhpExcelReader');
$model = new Listgaji();
$model->attributes = $_POST['Listgaji'];
$fileUpload = CUploadedFile::getInstance($model, 'filee');
$path = Yii::getPathOfAlias('webroot') . '/FileExcel/' . $fileUpload;
$fileUpload->saveAs($path);
if (!file_exists($path)) {
die('File could not be found at: ' . $path);
}
$data = new JPhpExcelReader($path);
$baris = $data->rowcount($sheet_index = 0);
$sukses = 0;
$gagal = 0;
$alreadySlip = 0;
for ($i = 2; $i <= $baris; $i++) {
for ($n = 1; $n <= 31; $n++) {
$rowData[$n] = str_replace(",", "", $data->val($i, $n));
if ($rowData[$n] == null or $rowData[$n] == '') {
$rowData[$n] = 0;
}
}
$command = Yii::app()->db->createCommand();
if (Listgaji::model()->findByAttributes(array('noSlipGaji' => $rowData[1] . $rowData[2] . $rowData[3])) != null) {
$alreadySlip++;
$slipExists[$rowData[1] . $rowData[2] . $rowData[3]] = $rowData[1] . $rowData[2] . $rowData[3];
} else {
try {
$command->insert('listgaji', array('noSlipGaji' => $rowData[1] . $rowData[2] . $rowData[3], 'year' => $rowData[1], 'month' => $rowData[2], 'nip' => $rowData[3], 'workdays' => $rowData[4], 'grossSalary' => $rowData[5], 'fixAllowance' => $rowData[6], 'meal' => $rowData[7], 'transport' => $rowData[8], 'pulse' => $rowData[9], 'medicalAllowance' => $rowData[10], 'overtime' => $rowData[11], 'bonus' => $rowData[12], 'thr' => $rowData[13], 'correctionPlus' => $rowData[14], 'incentive' => $rowData[15], 'jobAllowance' => $rowData[16], 'marriageAllowance' => $rowData[17], 'houseAllowance' => $rowData[18], 'taskForceAllowance' => $rowData[19], 'maternityAllowance' => $rowData[20], 'glassesAllowance' => $rowData[21], 'condolanceAllowance' => $rowData[22], 'separationPay' => $rowData[23], 'opex' => $rowData[24], 'coc' => $rowData[25], 'pph21' => $rowData[26], 'bpjs' => $rowData[27], 'jamsostek' => $rowData[28], 'benefitMin' => $rowData[29], 'copAllowanceMin' => $rowData[30], 'loan' => $rowData[31], 'state' => 'Y', 'createdTimeStamp' => date('Y-m-d H:i:s'), 'createdBy' => Yii::app()->user->Id));
$sukses++;
} catch (Exception $e) {
$gagal++;
}
}
}
unlink($path);
}
$date = date('Y-m-d');
$dateStamp = Yii::app()->db->createCommand()->select('count(id)')->from('listgaji')->where('substr(createdTimeStamp,1,10)=:date', array(':date' => $date))->queryRow();
$model = new Listgaji('search');
$model->unsetAttributes();
// clear any default values
if (isset($_GET['Listgaji'])) {
$model->attributes = $_GET['Listgaji'];
}
$this->render('admin', array('model' => $model, 'loadModelFirstname' => $loadModelFirstname, 'sukses' => $sukses, 'gagal' => $gagal, 'alreadySlip' => $alreadySlip, 'slipExists' => $slipExists, 'dateStamp' => $dateStamp));
}
/**
* Manages all models.
*/
public function actionAdmin()
{
if (isset($_GET['updatePassword'])) {
$updatePass = "******" . TbHtml::alert(TbHtml::ALERT_COLOR_SUCCESS, 'Well Done! You Successfully update password user!') . "</div>";
} else {
$updatePass = '';
}
$sukses = false;
$gagal = false;
$alreadyUser = false;
$userExists = false;
if (isset($_POST['User'])) {
Yii::import('ext.phpexcelreader.JPhpExcelReader');
$model = new User();
$model->attributes = $_POST['User'];
$fileUpload = CUploadedFile::getInstance($model, 'filee');
$path = Yii::getPathOfAlias('webroot') . '/FileExcel/' . $fileUpload;
if ($fileUpload == '') {
die('Please Insert File Excel 2003 with format template! ');
}
if (substr($path, -3, 3) != 'xls') {
die('Please Insert File Excel 2003! ');
}
$fileUpload->saveAs($path);
if (!file_exists($path)) {
die('File could not be found at: ' . $path);
}
$data = new JPhpExcelReader($path);
$baris = $data->rowcount($sheet_index = 0);
$sukses = 0;
$gagal = 0;
$alreadyUser = 0;
for ($i = 2; $i <= $baris; $i++) {
for ($n = 1; $n <= 14; $n++) {
$rowData[$n] = str_replace(",", "", $data->val($i, $n));
}
$command = Yii::app()->db->createCommand();
if (User::model()->findByAttributes(array('username' => $rowData[1])) != null) {
$alreadyUser++;
$userExists[$rowData[1]] = $rowData[1];
} else {
try {
$command->insert('users', array('username' => $rowData[1], 'password' => Yii::app()->controller->module->encrypting($rowData[14]), 'email' => $rowData[1] . '@morena.co.id', 'create_at' => date('Y-m-d H:i:s'), 'status' => 1));
$idUsersCreate = User::model()->findByAttributes(array('username' => $rowData[1]));
$command->insert('profiles', array('user_id' => $idUsersCreate->id, 'nip' => $rowData[1], 'firstname' => $rowData[2], 'lastname' => $rowData[3], 'birthdate' => $rowData[4], 'address' => $rowData[5], 'location' => $rowData[6], 'position' => $rowData[7], 'departement' => $rowData[8], 'class' => $rowData[9], 'joinDate' => $rowData[10], 'hireDate' => $rowData[11], 'state' => $rowData[12], 'marriageStatus' => $rowData[13]));
$command->insert('authassignment', array('itemname' => 'employee', 'userid' => $idUsersCreate['id']));
$sukses++;
} catch (Exception $e) {
$gagal++;
}
}
}
unlink($path);
}
$model = new User('search');
$model->unsetAttributes();
// clear any default values
if (isset($_GET['User'])) {
$model->attributes = $_GET['User'];
}
$this->render('index', array('model' => $model, 'sukses' => $sukses, 'gagal' => $gagal, 'alreadyUser' => $alreadyUser, 'userExists' => $userExists, 'updatePass' => $updatePass));
/*$dataProvider=new CActiveDataProvider('User', array(
'pagination'=>array(
'pageSize'=>Yii::app()->controller->module->user_page_size,
),
));
$this->render('index',array(
'dataProvider'=>$dataProvider,
));//*/
}
