/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store()
{
$input = Input::all();
$rules = array('tool_name' => 'required', 'acc_name' => 'required', 'emp_id' => 'required', 'emp_name' => 'required', 'access' => 'required');
$messages = array('tool_name.required' => 'Tool Name is required !', 'emp_id.required' => 'Employee ID is required !', 'emp_name.required' => 'Employee Name is required !', 'access.required' => 'Please select an accesibility !');
$validation = Validator::make($input, $rules, $messages);
if ($validation->passes()) {
$toolname = Accounts::select('account_name')->where('id', '=', Input::get('acc_name'))->get();
foreach ($toolname as $key => $tool) {
$accName = $tool->account_name;
}
//print_r($account_name);
//exit;
$employees = new Employee();
$employees->emp_id = Input::get('emp_id');
$employees->emp_name = Input::get('emp_name');
$employees->acc_id = Input::get('acc_name');
$employees->tool_name = Input::get('tool_name');
$employees->access = Input::get('access');
$employees->save();
return Redirect::to('/employees');
} else {
return Redirect::to('/employees/create')->withErrors($validation);
}
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store()
{
// $validation = Employee::validate(Input::all());
$input = Input::all();
$rules = array('first_name' => 'required|max:20', 'last_name' => 'required|max:20', 'email' => 'required|email|unique:employees,email', 'username' => 'required|unique:employees,username', 'password' => 'required|confirmed', 'password_confirmation' => 'required', 'phone_number' => 'required|numeric');
$validation = Validator::make($input, $rules);
if ($validation->passes()) {
$employee = new Employee();
$employee->first_name = Input::get('first_name');
$employee->last_name = Input::get('last_name');
$employee->email = Input::get('email');
$employee->username = Input::get('username');
$employee->password = Hash::make(Input::get('password'));
$employee->phone_number = Input::get('phone_number');
$employee->address1 = Input::get('address1');
$employee->address2 = Input::get('address2');
$employee->city = Input::get('city');
$employee->state = Input::get('state');
$employee->zip = Input::get('zip');
$employee->country = Input::get('country');
$employee->comment = Input::get('comment');
$employee->save();
// return "Success";
Session::flash('success', 'A new employee has been created');
return Redirect::to('/employees');
} else {
return Redirect::to('/employees/create')->withErrors($validation)->withInput();
}
}
/**
* @desc - สำหรับรับค่าข้อมูล FORM ที่ส่งค่าข้อมูลจาก AJax แบบ Post
* @return json
*/
public function addAction()
{
//ปิดการใช้งานสำหรับการร้องขอ Ajax
$this->view->disable();
//ถ้ากดปุ่มโพสต์
if ($this->request->isPost() == true) {
//ถ้าส่งฝ่าน Ajax
if ($this->request->isAjax() == true) {
////อนุญาตให้ส่งข้อมูลครั้งเดียวโดยใช้เงื่อนไขของ token ตรวจสอบ
if ($this->security->checkToken()) {
// สร้าง Model ข้อมูลตาราง Employee รับค่าข้อมูลจากการส่งข้อมูลภายใต้ FORM ที่มีส่งข้อมูล SSN, FNAME, LNAME, DNO
$employee = new Employee();
$employee->SSN = $this->request->getPost('SSN', array('striptags', 'trim'));
$employee->FNAME = $this->request->getPost('FNAME', array('striptags', 'trim'));
$employee->LNAME = $this->request->getPost('LNAME', array('striptags', 'trim'));
$employee->DNO = $this->request->getPost('DNO', array('striptags', 'trim'));
//รันคำสั่ง SQL insert into employee (SSN, FNAME, LNAME, DNO) value ($_POST['SSN'] ,$_POST['FNAME'] ...)
if ($employee->save()) {
$this->response->setJsonContent(array("res" => "success"));
//ระบุสถานะทำงานเสร็จโดยค่า Code 200 เพื่อส่งข้อมูลการทำงานสำเร็จ
$this->response->setStatusCode(200, "OK");
} else {
$this->response->setJsonContent(array("res" => "error"));
//ระบุสถานะทำงานผิดพลาดโดยค่า Code 500 เพื่อส่งข้อมูลการทำงานผิดพลาด
$this->response->setStatusCode(500, "Internal Server Error");
}
$this->response->send();
}
}
}
}
public function postAddnewemp()
{
$inputs = Input::all();
if (!empty($inputs['fullname'])) {
$photoNewName = null;
// upload photo
if (Input::hasFile('photo')) {
$photo = Input::file('photo');
$photoNewName = date('YmdHis') . '.' . $photo->getClientOriginalExtension();
$photo->move('image/employee', $photoNewName);
}
$employee = new Employee();
$employee->emp_name = $inputs['fullname'];
$employee->emp_idcard = $inputs['cardid'];
$employee->emp_address = $inputs['address'];
$employee->emp_tel = $inputs['tel'];
$employee->emp_lineid = $inputs['lineid'];
$employee->emp_email = $inputs['email'];
$employee->emp_image = $photoNewName;
$employee->emp_username = $inputs['username'];
$employee->emp_password = Hash::Make($inputs['password']);
$employee->save();
return Redirect::to('admin/employee/showallemployee')->with('alert', 'สร้างพนักงานสำเร็จ');
}
return Redirect::back();
}
/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
$model = new Employee();
$user = new RbacUser();
$disabled = "";
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (Yii::app()->user->checkAccess('employee.create')) {
if (isset($_POST['Employee'])) {
$model->attributes = $_POST['Employee'];
$user->attributes = $_POST['RbacUser'];
//$location_id = $_POST['Employee']['location'];
if ($_POST['Employee']['year'] !== "" || $_POST['Employee']['month'] !== "" || $_POST['Employee']['day'] !== "") {
$dob = $_POST['Employee']['year'] . '-' . $_POST['Employee']['month'] . '-' . $_POST['Employee']['day'];
$model->dob = $dob;
}
// validate BOTH $a and $b
$valid = $model->validate();
$valid = $user->validate() && $valid;
if ($valid) {
$transaction = $model->dbConnection->beginTransaction();
try {
if ($model->save()) {
$user->employee_id = $model->id;
if ($user->save()) {
$assignitems = array('items', 'sales', 'employees', 'customers', 'suppliers', 'store', 'receivings', 'reports', 'invoices', 'payments');
foreach ($assignitems as $assignitem) {
if (!empty($_POST['RbacUser'][$assignitem])) {
foreach ($_POST['RbacUser'][$assignitem] as $itemId) {
$authassigment = new Authassignment();
$authassigment->userid = $user->id;
$authassigment->itemname = $itemId;
if (!$authassigment->save()) {
$transaction->rollback();
print_r($authassigment->errors);
}
}
}
}
$transaction->commit();
Yii::app()->user->setFlash('success', '<strong>Well done!</strong> successfully saved.');
//$this->redirect(array('view', 'id' => $model->id));
$this->redirect(array('admin'));
} else {
Yii::app()->user->setFlash('error', '<strong>Oh snap!</strong> Change a few things up and try submitting again.');
}
}
} catch (Exception $e) {
$transaction->rollback();
Yii::app()->user->setFlash('error', '<strong>Oh snap!</strong> Change a few things up and try submitting again.' . $e);
}
}
}
} else {
throw new CHttpException(403, 'You are not authorized to perform this action');
}
$this->render('create', array('model' => $model, 'user' => $user, 'disabled' => $disabled));
}
/**
* Creates a new Employee model.
* If creation is successful, the browser will be redirected to the 'view' page.
* @return mixed
*/
public function actionCreate()
{
$model = new Employee();
if ($model->load(Yii::$app->request->post()) && $model->save()) {
return $this->redirect(['view', 'id' => $model->id]);
} else {
return $this->render('create', ['model' => $model]);
}
}
public static function Create($name, $telephone, $email, $address, $gender, $department, $position, $salary)
{
$type = new PartyType('Employee');
$employee = new Employee($type, $name, $telephone, $email, $address, $gender, $department, $position, $salary, 0);
if ($employee->save()) {
return $employee;
}
return false;
}
public function store()
{
$employee = new Employee();
$employee->employee_id = Input::get('employee_id');
$employee->code = Input::get('code');
$employee->name = Input::get('name');
$employee->contact = Input::get('contact');
$employee->basic_salary = Input::get('basic_salary');
$employee->teach_salary = Input::get('teach_salary');
$employee->save();
Session::flash('message', 'Sukses menambahkan data pegawai!');
}
/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
$model = new Employee();
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['Employee'])) {
$model->attributes = $_POST['Employee'];
if ($model->save()) {
$this->redirect(array('view', 'id' => $model->id));
}
}
$this->render('create', array('model' => $model));
}
protected function createFakerEmployee()
{
$faker = Faker::create();
for ($i = 1; $i < 50; $i++) {
$employee = new Employee();
$employee->first_name = $faker->firstName;
$employee->last_name = $faker->lastName;
$employee->email = $faker->email;
$employee->hire_date = $faker->date($format = 'Y-m-d');
$employee->password = $faker->password;
$employee->save();
}
}
public function run()
{
$employee = new Employee();
$employee->name = 'Ganesh';
$employee->email = '*****@*****.**';
$employee->password = '******';
$employee->password_confirmation = '00d00@ganesh';
$employee->mobile = '9999999999';
$employee->active = 1;
$employee->save();
$employee::$rules = [];
$employee->generateEmployeeId();
}
/**
* Store a newly created resource in storage.
* POST /clinics
*
* @return Response
*/
public function store()
{
$data = Input::all();
$validator = Validator::make($data, array('password' => 'min:6', 'email' => 'unique:employees', 'status' => 'required', 'clinic_name' => 'required', 'clinic_address' => 'required'));
if ($validator->fails()) {
return Redirect::back()->withErrors($validator)->withInput();
}
$clinic = Clinic::create(['name' => $data['clinic_name'], 'address' => $data['clinic_address']]);
$employee = new Employee();
$employee->clinic_id = $clinic->id;
$employee->name = Input::get('name');
$employee->password = Hash::make(Input::get('password'));
$employee->email = Input::get('email');
$employee->gender = Input::get('gender');
$employee->age = Input::get('age');
$employee->city = Input::get('city');
$employee->country = Input::get('country');
$employee->address = Input::get('address');
if (Input::get('phone') == '') {
$employee->phone = 'N/A';
} else {
$employee->phone = Input::get('phone');
}
if (Input::get('cnic') == '') {
$employee->cnic = 'N/A';
} else {
$employee->cnic = Input::get('cnic');
}
if (Input::get('branch') == '') {
$employee->branch = 'N/A';
} else {
$employee->branch = Input::get('branch');
}
if (Input::get('note') == '') {
$employee->note = 'N/A';
} else {
$employee->note = Input::get('note');
}
$employee->status = Input::get('status');
$employee->role = 'Administrator';
$employee->save();
$data = ['link' => URL::to('login'), 'name' => Input::get('name')];
// Send email to employee
Mail::queue('emails.welcome', $data, function ($message) {
$message->to(Input::get('email'), Input::get('name'))->subject('Welcome to EMR!');
});
return Redirect::route('clinics.index');
}
/**
* Performs the work of inserting or updating the row in the database.
*
* If the object is new, it inserts it; otherwise an update is performed.
* All related objects are also updated in this method.
*
* @param PropelPDO $con
* @return int The number of rows affected by this insert/update and any referring fk objects' save() operations.
* @throws PropelException
* @see save()
*/
protected function doSave(PropelPDO $con)
{
$affectedRows = 0;
// initialize var to track total num of affected rows
if (!$this->alreadyInSave) {
$this->alreadyInSave = true;
// We call the save method on the following object(s) if they
// were passed to this object by their coresponding set
// method. This object relates to these object(s) by a
// foreign key reference.
if ($this->aRole !== null) {
if ($this->aRole->isModified() || $this->aRole->isNew()) {
$affectedRows += $this->aRole->save($con);
}
$this->setRole($this->aRole);
}
if ($this->aEmployee !== null) {
if ($this->aEmployee->isModified() || $this->aEmployee->isNew()) {
$affectedRows += $this->aEmployee->save($con);
}
$this->setEmployee($this->aEmployee);
}
if ($this->isNew()) {
$this->modifiedColumns[] = UserPeer::ID;
}
// If this object has been modified, then save it to the database.
if ($this->isModified()) {
if ($this->isNew()) {
$pk = UserPeer::doInsert($this, $con);
$affectedRows += 1;
// we are assuming that there is only 1 row per doInsert() which
// should always be true here (even though technically
// BasePeer::doInsert() can insert multiple rows).
$this->setId($pk);
//[IMV] update autoincrement primary key
$this->setNew(false);
} else {
$affectedRows += UserPeer::doUpdate($this, $con);
}
$this->resetModified();
// [HL] After being saved an object is no longer 'modified'
}
$this->alreadyInSave = false;
}
return $affectedRows;
}
public static function store()
{
$params = $_POST;
$services = Service::all();
$attributes = array('name' => $params['name'], 'special' => $params['special'], 'introduction' => $params['introduction']);
$employee = new Employee($attributes);
$errors = $employee->errors();
if (count($errors) == 0) {
$employee->save();
foreach ($services as $serv) {
if (isset($_POST[$serv->id])) {
OfferedServicesController::create($employee->id, $serv->id);
}
}
Redirect::to('/tyontekijat/' . $employee->id, array('message' => 'Työntekijä lisätty!'));
} else {
View::make('employee/new.html', array('errors' => $errors, 'attributes' => $attributes));
}
}
/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
$model = new Employee();
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['Employee'])) {
$model->attributes = $_POST['Employee'];
if ($model->save()) {
date_default_timezone_set("Asia/Manila");
}
$activity = new Activity();
$activity->act_desc = 'Added Another Employee';
$activity->act_datetime = date('Y-m-d G:i:s');
$activity->act_by = User::model()->findByPK(Yii::app()->user->name)->emp_id;
$activity->save();
$this->redirect(array('view', 'id' => $model->emp_id));
}
$this->render('create', array('model' => $model));
}
public function testUserListView()
{
// new employee
$last_name = 'Test_46473_' . time();
$emp = new Employee();
$emp->last_name = $last_name;
$emp->default_team = 1;
$emp->status = 'Active';
$emp->employee_status = 'Active';
$emp->user_name = 'test_user_name';
$emp->save();
$emp_id = $emp->id;
$this->assertNotNull($emp_id, 'User id should not be null.');
// list view
$view = new UsersViewList();
$view->module = 'Users';
$view->init($emp);
$view->lv = new ListViewSmarty();
$view->display();
// ensure the new employee shows up in the users list view
$this->expectOutputRegex('/.*' . $last_name . '.*/');
}
public function add_employees()
{
foreach ($this->user_data as $key => $ud) {
$this->user_data[$key]["Employee"]["employeerole_id"] = $this->roles_array[$ud["Employee"]["employeerole_id"]];
$user = new User();
if ($user->save($this->user_data[$key]["User"])) {
$employee = new Employee();
$this->user_data[$key]["Employee"]["id"] = $user->id;
$employee->save($this->user_data[$key]["Employee"]);
if (!(key_exists("id", $this->user_data[$key]["User"]) && !empty($this->user_data[$key]["User"]["id"]))) {
$companies_employee = new CompaniesEmployee();
$comp_emp_data = array("CompaniesEmployee" => array("company_id" => $this->company_id, "employee_id" => $employee->id));
$companies_employee->save($comp_emp_data);
}
unset($employee);
unset($user);
unset($companies_employee);
}
}
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store()
{
//
$validator = Validator::make($data = Input::all(), Employee::$rules, Employee::$messages);
if ($validator->fails()) {
return Redirect::back()->withErrors($validator)->withInput();
}
$employee = new Employee();
$employee->personal_file_number = Input::get('personal_file_number');
$employee->first_name = Input::get('fname');
$employee->last_name = Input::get('lname');
$employee->middle_name = Input::get('mname');
$employee->identity_number = Input::get('identity_number');
if (Input::get('passport_number') != null) {
$employee->passport_number = Input::get('passport_number');
} else {
$employee->passport_number = null;
}
if (Input::get('pin') != null) {
$employee->pin = Input::get('pin');
} else {
$employee->pin = null;
}
if (Input::get('social_security_number') != null) {
$employee->social_security_number = Input::get('social_security_number');
} else {
$employee->social_security_number = null;
}
if (Input::get('hospital_insurance_number') != null) {
$employee->hospital_insurance_number = Input::get('hospital_insurance_number');
} else {
$employee->hospital_insurance_number = null;
}
if (Input::get('work_permit_number') != null) {
$employee->work_permit_number = Input::get('work_permit_number');
} else {
$employee->work_permit_number = null;
}
$employee->job_title = Input::get('jtitle');
$employee->basic_pay = Input::get('pay');
$employee->gender = Input::get('gender');
$employee->marital_status = Input::get('status');
$employee->yob = Input::get('dob');
$employee->citizenship = Input::get('citizenship');
$employee->mode_of_payment = Input::get('modep');
if (Input::get('bank_account_number') != null) {
$employee->bank_account_number = Input::get('bank_account_number');
} else {
$employee->bank_account_number = null;
}
if (Input::get('bank_eft_code') != null) {
$employee->bank_eft_code = Input::get('bank_eft_code');
} else {
$employee->bank_eft_code = null;
}
if (Input::get('swift_code') != null) {
$employee->swift_code = Input::get('swift_code');
} else {
$employee->swift_code = null;
}
if (Input::get('email_office') != null) {
$employee->email_office = Input::get('email_office');
} else {
$employee->email_office = null;
}
if (Input::get('email_personal') != null) {
$employee->email_personal = Input::get('email_personal');
} else {
$employee->email_personal = null;
}
if (Input::get('telephone_mobile') != null) {
$employee->telephone_mobile = Input::get('telephone_mobile');
} else {
$employee->telephone_mobile = null;
}
$employee->postal_address = Input::get('address');
$employee->postal_zip = Input::get('zip');
$employee->date_joined = Input::get('djoined');
$employee->bank_id = Input::get('bank_id');
$employee->bank_branch_id = Input::get('bbranch_id');
$employee->branch_id = Input::get('branch_id');
$employee->department_id = Input::get('department_id');
$employee->job_group_id = Input::get('jgroup_id');
$employee->type_id = Input::get('type_id');
if (Input::get('i_tax') != null) {
$employee->income_tax_applicable = '1';
} else {
$employee->income_tax_applicable = '0';
}
if (Input::get('i_tax_relief') != null) {
$employee->income_tax_relief_applicable = '1';
} else {
$employee->income_tax_relief_applicable = '0';
}
if (Input::get('a_nhif') != null) {
$employee->hospital_insurance_applicable = '1';
} else {
$employee->hospital_insurance_applicable = '0';
}
if (Input::get('a_nssf') != null) {
$employee->social_security_applicable = '1';
} else {
$employee->social_security_applicable = '0';
}
$employee->organization_id = '1';
$employee->save();
Audit::logaudit('Employee', 'create', 'created: ' . $employee->personal_file_number . '-' . $employee->first_name . ' ' . $employee->last_name);
return Redirect::route('employees.index');
}
/**
* Save Contact Details
* @param Employee $employee
* @returns boolean
* @throws DaoException
*/
public function saveJobDetails(Employee $employee)
{
try {
$employee->save();
return true;
} catch (Exception $e) {
throw new DaoException($e->getMessage());
}
}
public function actionWrite()
{
if (isset($_POST['Employee'])) {
$messages = $this->ValidateData(array(array($_POST['Employee']['fullname'], 'emptyfullname', 'emptystring'), array($_POST['Employee']['orgstructureid'], 'emptyorgstructure', 'emptystring'), array($_POST['Employee']['positionid'], 'emptyposition', 'emptystring'), array($_POST['Employee']['employeetypeid'], 'emptyemployeetype', 'emptystring'), array($_POST['Employee']['sexid'], 'emptysex', 'emptystring'), array($_POST['Employee']['birthcityid'], 'emptybirthcity', 'emptystring'), array($_POST['Employee']['birthdate'], 'emptybirthdate', 'emptystring'), array($_POST['Employee']['maritalstatusid'], 'emptymaritalstatus', 'emptystring'), array($_POST['Employee']['joindate'], 'emptyjoindate', 'emptystring'), array($_POST['Employee']['employeestatusid'], 'emptyemployeestatus', 'emptystring'), array($_POST['Employee']['levelorgid'], 'emptylevelorg', 'emptystring')));
if ($messages == '') {
if ((int) $_POST['Employee']['employeeid'] > 0) {
$model = $this->loadModel($_POST['Employee']['employeeid']);
$ab = Addressbook::model()->findbypk($model->addressbookid);
$ab->fullname = $_POST['Employee']['fullname'];
$ab->save();
$model->fullname = $_POST['Employee']['fullname'];
$model->oldnik = $_POST['Employee']['oldnik'];
$model->orgstructureid = $_POST['Employee']['orgstructureid'];
$model->positionid = $_POST['Employee']['positionid'];
$model->levelorgid = $_POST['Employee']['levelorgid'];
$model->employeetypeid = $_POST['Employee']['employeetypeid'];
$model->sexid = $_POST['Employee']['sexid'];
$model->birthcityid = $_POST['Employee']['birthcityid'];
$model->birthdate = $_POST['Employee']['birthdate'];
$model->religionid = $_POST['Employee']['religionid'];
$model->maritalstatusid = $_POST['Employee']['maritalstatusid'];
$model->referenceby = $_POST['Employee']['referenceby'];
$model->joindate = $_POST['Employee']['joindate'];
$model->employeestatusid = $_POST['Employee']['employeestatusid'];
$model->istrial = $_POST['Employee']['istrial'];
$model->accountno = $_POST['Employee']['accountno'];
$model->taxno = $_POST['Employee']['taxno'];
} else {
$model = new Employee();
$model->attributes = $_POST['Employee'];
}
try {
if ($model->save()) {
$this->DeleteLock($this->menuname, $_POST['Employee']['fullname']);
$this->GetSMessage('insertsuccess');
} else {
$this->GetMessage($model->getErrors());
}
} catch (Exception $e) {
$this->GetMessage($e->getMessage());
}
}
}
}
public function ajaxProcessHideScreencast()
{
if ($employee = new Employee((int) Tools::getValue('id_employee'))) {
$employee->bo_show_screencast = 0;
if ($employee->save()) {
$this->content = '{"status":"ok"}';
} else {
$this->content = '{"status":"error","msg":"not saved"}';
}
} else {
$this->content = '{"status":"error", "msg":"employee does not exists"}';
}
}
if (isset($_POST[$field])) {
$value = $_POST[$field];
$focus->{$field} = $value;
}
}
foreach ($focus->additional_column_fields as $field) {
if (isset($_POST[$field])) {
$value = $_POST[$field];
$focus->{$field} = $value;
}
}
if (!$focus->verify_data()) {
header("Location: index.php?action=Error&module=Users&error_string=" . urlencode($focus->error_string));
exit;
} else {
$focus->save();
$return_id = $focus->id;
}
if (isset($_POST['return_module']) && $_POST['return_module'] != "") {
$return_module = $_POST['return_module'];
} else {
$return_module = "Users";
}
if (isset($_POST['return_action']) && $_POST['return_action'] != "") {
$return_action = $_POST['return_action'];
} else {
$return_action = "DetailView";
}
if (isset($_POST['return_id']) && $_POST['return_id'] != "") {
$return_id = $_POST['return_id'];
}
//Imports
require_once 'db.php';
require_once 'Employee.php';
if (empty($_POST['name'])) {
header("Location: ../?e=name");
exit;
}
if (empty($_POST['un'])) {
header("Location: ../?e=un");
exit;
}
if (empty($_POST['pw'])) {
header("Location: ../?e=pw");
exit;
}
$name = $_POST['name'];
$un = $_POST['un'];
$pw = md5($_POST['pw']);
$con = connect_db();
$employee = new Employee();
$employee->grp = 2;
$employee->name = $name;
$employee->un = $un;
$employee->pw = $pw;
$employee->lists = explode(',', $_POST['listids']);
$employee->save($con);
foreach ($employee->lists as $listID) {
$employee->addList($con, $listID);
}
$con->close();
header('Location: ../employee?_=' . $employee->id);
/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionImport()
{
$model = new Employee();
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['Employee'])) {
if (!empty($_FILES)) {
$tempFile = $_FILES['Employee']['tmp_name']['fileImport'];
$fileTypes = array('xls', 'xlsx');
// File extensions
$fileParts = pathinfo($_FILES['Employee']['name']['fileImport']);
if (in_array(@$fileParts['extension'], $fileTypes)) {
Yii::import('ext.heart.excel.EHeartExcel', true);
EHeartExcel::init();
$inputFileType = PHPExcel_IOFactory::identify($tempFile);
$objReader = PHPExcel_IOFactory::createReader($inputFileType);
$objPHPExcel = $objReader->load($tempFile);
$sheetData = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true);
$baseRow = 2;
$inserted = 0;
$read_status = false;
while (!empty($sheetData[$baseRow]['A'])) {
$read_status = true;
//$employee_id= $sheetData[$baseRow]['A'];
$name = $sheetData[$baseRow]['B'];
$model2 = new Employee();
//$model2->employee_id= $employee_id;
$model2->name = $name;
try {
if ($model2->save()) {
$inserted++;
}
} catch (Exception $e) {
Yii::app()->user->setFlash('error', "{$e->getMessage()}");
//$this->refresh();
}
$baseRow++;
}
Yii::app()->user->setFlash('success', $inserted . ' row inserted');
} else {
Yii::app()->user->setFlash('warning', 'Wrong file type (xlsx, xls, and ods only)');
}
}
$this->render('admin', array('model' => $model));
} else {
$this->render('admin', array('model' => $model));
}
}
/**
* Performs the work of inserting or updating the row in the database.
*
* If the object is new, it inserts it; otherwise an update is performed.
* All related objects are also updated in this method.
*
* @param PropelPDO $con
* @return int The number of rows affected by this insert/update and any referring fk objects' save() operations.
* @throws PropelException
* @see save()
*/
protected function doSave(PropelPDO $con)
{
$affectedRows = 0;
// initialize var to track total num of affected rows
if (!$this->alreadyInSave) {
$this->alreadyInSave = true;
// We call the save method on the following object(s) if they
// were passed to this object by their coresponding set
// method. This object relates to these object(s) by a
// foreign key reference.
if ($this->aPatient !== null) {
if ($this->aPatient->isModified() || $this->aPatient->isNew()) {
$affectedRows += $this->aPatient->save($con);
}
$this->setPatient($this->aPatient);
}
if ($this->aEmployeeRelatedByDoctorId !== null) {
if ($this->aEmployeeRelatedByDoctorId->isModified() || $this->aEmployeeRelatedByDoctorId->isNew()) {
$affectedRows += $this->aEmployeeRelatedByDoctorId->save($con);
}
$this->setEmployeeRelatedByDoctorId($this->aEmployeeRelatedByDoctorId);
}
if ($this->aWardBed !== null) {
if ($this->aWardBed->isModified() || $this->aWardBed->isNew()) {
$affectedRows += $this->aWardBed->save($con);
}
$this->setWardBed($this->aWardBed);
}
if ($this->aEmployeeRelatedByWardDocId !== null) {
if ($this->aEmployeeRelatedByWardDocId->isModified() || $this->aEmployeeRelatedByWardDocId->isNew()) {
$affectedRows += $this->aEmployeeRelatedByWardDocId->save($con);
}
$this->setEmployeeRelatedByWardDocId($this->aEmployeeRelatedByWardDocId);
}
if ($this->isNew()) {
$this->modifiedColumns[] = VisitPeer::ID;
}
// If this object has been modified, then save it to the database.
if ($this->isModified()) {
if ($this->isNew()) {
$pk = VisitPeer::doInsert($this, $con);
$affectedRows += 1;
// we are assuming that there is only 1 row per doInsert() which
// should always be true here (even though technically
// BasePeer::doInsert() can insert multiple rows).
$this->setId($pk);
//[IMV] update autoincrement primary key
$this->setNew(false);
} else {
$affectedRows += VisitPeer::doUpdate($this, $con);
}
$this->resetModified();
// [HL] After being saved an object is no longer 'modified'
}
if ($this->collLabReports !== null) {
foreach ($this->collLabReports as $referrerFK) {
if (!$referrerFK->isDeleted()) {
$affectedRows += $referrerFK->save($con);
}
}
}
if ($this->collVisitMedicines !== null) {
foreach ($this->collVisitMedicines as $referrerFK) {
if (!$referrerFK->isDeleted()) {
$affectedRows += $referrerFK->save($con);
}
}
}
$this->alreadyInSave = false;
}
return $affectedRows;
}
static function ImportEmployee()
{
// Делаем запись в таблицу отчетов импорта
$logreport = new Logreport();
$logreport->logreport_date = date('Y-m-d');
$logreport->save();
self::$logreport_id = $logreport->logreport_id;
// Идем по файлам импорта из 1С (сотрудники.txt - Сотрудники)
foreach (['сотрудники.txt'] as $filename) {
self::$filename = mb_convert_encoding('imp/' . $filename, 'Windows-1251', 'UTF-8');
if (file_exists(self::$filename)) {
ini_set('max_execution_time', 1000);
// 1000 seconds
ini_set('memory_limit', 1073741824);
// 1Gbyte Max Memory
// Определяем показатели импорта
self::$logreport_errors = 0;
// Не загружено записей из-за ошибок
self::$logreport_additions = 0;
// Записей добавлено
self::$logreport_amount = 0;
// Всего записей
$i = 0;
$handle = @fopen(self::$filename, "r");
if ($handle) {
while (($subject = fgets($handle, 4096)) !== false) {
$i++;
$pattern = '/^(.+?)\\|(Поликлиника №\\s?[1,2,3] )?(.+?)\\|(.+?)\\|/ui';
preg_match($pattern, $subject, $matches);
if ($matches[0] !== NULL) {
$pattern = '/(^Поликлиника №)\\s?([1,2,3])\\s?$/ui';
$matches[2] = preg_replace($pattern, 'Взрослая $1$2', mb_strtolower($matches[2], 'UTF-8'));
if ($matches[3] === 'Поликлиника профилактических осмотров') {
$matches[2] = $matches[3];
}
$pattern = '/^(.+) БУ "Нижневартовская городская поликлиника"$/ui';
$matches[3] = preg_replace($pattern, '$1', $matches[3]);
$employee_fio = $matches[1];
$location = self::AssignLocationForEmployeeImport($matches[3], $matches[2]);
$id_dolzh = self::AssignDolzh($matches[4]);
// На случай если Здание у сотрудника не определено
$buildsql = $location->id_build === null ? 'id_build IS NULL' : 'id_build = :id_build';
// Находим сотрудника в базе, если не находим создаем новую запись
$Employee = Employee::model()->Find('employee_fio LIKE :employee_fio and id_dolzh = :id_dolzh and id_podraz = :id_podraz and ' . $buildsql, array_merge([':employee_fio' => $employee_fio, ':id_dolzh' => $id_dolzh, ':id_podraz' => $location->id_podraz], $location->id_build === null ? [] : [':id_build' => $location->id_build]));
if ($Employee === null) {
$Employee = new Employee();
$Employee->attributes = ['employee_fio' => $employee_fio, 'id_dolzh' => $id_dolzh, 'id_podraz' => $location->id_podraz, 'id_build' => $location->id_build];
$Employeelog = new Employeelog();
$Employeelog->id_logreport = self::$logreport_id;
$Employeelog->employeelog_type = 1;
$Employeelog->employeelog_filename = mb_convert_encoding(self::$filename, 'UTF-8', 'Windows-1251');
$Employeelog->employeelog_rownum = $i;
$Employeelog->employeelog_message = 'Запись добавлена.';
$Employee->scenario = 'import1c';
if ($Employee->validate()) {
self::$logreport_additions++;
$Employee->save(false);
} else {
$Employeelog->employeelog_type = 3;
$Employeelog->employeelog_message = 'Ошибка при добавлении записи: ';
foreach ($Employee->getErrors() as $fields) {
$Employeelog->employeelog_message .= implode(' ', $fields) . ' ';
}
self::$logreport_errors++;
}
$Employeelog->employee_fio = $Employee->employee_fio;
$Employeelog->dolzh_name = Dolzh::model()->findbyPk($Employee->id_dolzh)->dolzh_name;
$Employeelog->podraz_name = Podraz::model()->findbyPk($Employee->id_podraz)->podraz_name;
if ($Employee->id_build !== null) {
$Employeelog->build_name = Build::model()->findbyPk($Employee->id_build)->build_name;
}
$Employeelog->save(false);
}
} elseif (trim($subject) !== '') {
$Employeelog = new Employeelog();
$Employeelog->id_logreport = self::$logreport_id;
$Employeelog->employeelog_type = 3;
$Employeelog->employeelog_filename = mb_convert_encoding(self::$filename, 'UTF-8', 'Windows-1251');
$Employeelog->employeelog_rownum = $i;
$Employeelog->employeelog_message = 'Ошибка при добавлении записи: Не пройдено регулярное выражение /^(.+?)\\|(Поликлиника №\\s?[1,2,3] )?(.+?)\\|(.+?)\\|/ui';
$Employeelog->save(false);
self::$logreport_errors++;
}
}
fclose($handle);
}
$logreport->logreport_additions += self::$logreport_additions;
$logreport->logreport_errors += self::$logreport_errors;
$logreport->logreport_amount = $i;
$logreport->save();
}
}
echo '<BR>Подразделения:<BR>';
ARData::Data(Podraz::model(), Podraz::model()->Test())->PrintData();
echo '<BR>Должности:<BR>';
ARData::Data(Dolzh::model(), Dolzh::model()->Test())->PrintData();
echo '<BR>Сотрудники:<BR>';
ARData::Data(Employee::model(), Employee::model()->Test())->PrintData();
echo '<BR>Лог:<BR>';
ARData::Data(Employeelog::model(), Employeelog::model()->Test())->PrintData();
}
private function processImport($file)
{
if (Session::has('username') && (Session::get('user_type') == "Root" || Session::get('user_type') == "Admin")) {
if (!in_array($file->getClientOriginalExtension(), array("xls", "xlsx", "csv"))) {
Input::flash();
return Redirect::to('employees/import')->with('message', "Invalid file selected.");
} else {
$filename = "upload-" . str_random(9) . "." . $file->getClientOriginalExtension();
$file->move("uploads", $filename);
$readFile = "uploads/" . $filename;
$reader = Excel::selectSheetsByIndex(0)->load($readFile, function ($reader) {
})->get();
/*
* Before validating each rows of the file uploaded, the file itself is checked if it has the valid attributes (columns)
* using the algorithm found below.
*
* 1. File is read.
* 2. Boolean variable $excelIsValid to check if the file is valid. Set to false by default.
*
*/
$excelChecker = Excel::selectSheetsByIndex(0)->load($readFile, function ($reader) {
})->get()->toArray();
$excelIsValid = false;
/*
* 3. Loop through the excel file and check if at least once all the columns have been present.
* 4. If it does, $excelIsValid is set to true.
* 5. If $excelIsValid is still false by end of the loop, it is automatically assumed that the file is:
* A.) Empty
* B.) Does not have the right attributes.
* C.) Has valid columns, but does not have any valid entry.
*
*/
foreach ($excelChecker as $ex) {
if (isset($ex["employeenumber"]) && isset($ex["lastname"]) && isset($ex["firstname"]) && isset($ex["startdate"]) && isset($ex["status"])) {
$excelIsValid = true;
}
}
/* 6. If file is invalid, redirect to import form and return an error. */
if (!$excelIsValid) {
Input::flash();
File::delete($readFile);
return Redirect::to('employees/import')->with('message', "Excel file has invalid attributes. Please download the form.");
}
/*
* CHECKING EXCEL FILE FOR ERRORS WHILE READING THE ROWS
*
* 1. $hasError is a Boolean variable that is simply used to tell if any error has been found.
* This variable is, by default, set to false. If any error has been detected, it is set to true,
* regardless of how many errors has been detected.
*
* 2. $rowIndex indexes which row the reader is currently reading. Default value set to 1 because
* the first row of excel files is automatically set as the attribute row. When the reader reads each row,
* $rowIndex is incremented. For example, reader is currently reading row 2, $rowIndex will then be incremented,
* setting its value to 2, thus the row number.
*
* 3. $rowsWithErrors is the array of the rows with errors. To explain further, let's say excel file has 10 readable (non-attrib)
* rows. No errors were found from rows number 2-8, but errors were found in rows 9, 10, and 11. These 9, 10, and 11
* will then be in the $rowsWithError.
*
* 4. $error array is the variable that will be used to collect all errors found from the excel file.
* This is a two-dimensional array.
*
*
*/
$hasError = false;
//Detects if there are any errors.
$hasCorrectRows = false;
$rowIndex = 1;
//Indexes which row the reader is reading.
$rowsWithErrors = array();
//This is used to contain in an array the row numbers of the rows with error.
$error = array();
//Error details collector.
foreach ($reader as $r) {
/*
* 5. Here, we immediately increment the value of $rowIndex, since the variable will be used in the core logic of this method.
*
* 6. $errorCount variable is a variable used in every loop. Set to 0 when the loop begins, so it always comes back to 0 for every loop.
* $errorCount is used to track the number of errors for the current row. This variable goes hand in hand with the
* $rowsWithError array when publishing the rows with errors, and the error details for each row with error.
*
* This is how $rowsWithError and $rowCount will be used:
*
* for each $rowWithErrors:
* Row $rowWithErrors Index:
* Errors Found :
* $rowCount 1. Foo bar
* $rowCount 2. Jane Doe etc..
*
*
*/
$rowIndex += 1;
$errorCount = 0;
//Counts the number of errors for the currect row.
$rowHasError = false;
//Check if this row has error. I will use this before the reading of the row ends.
// If $rowHasError is still false by end of the reading, then I will write it in the database.
/*
*
*/
$start_date = !empty(trim($r->startdate)) ? trim($r->startdate) : "1994-04-16";
$validator = Validator::make(array("employee number" => trim($r->employeenumber), "last name" => trim($r->lastname), "first name" => trim($r->firstname), "username" => trim($r->username), "start date" => trim($r->startdate), "end date" => trim($r->enddate), "email" => trim($r->email), "status" => trim($r->status)), array("employee number" => "required|numeric|unique:tbl_employees,employee_number", "last name" => "required", "first name" => "required", "username" => "unique:tbl_employees,username", "start date" => "required|date:Y-m-d", "end date" => "date:Y-m-d|after:" . $start_date, "email" => "unique:tbl_employees,email", "status" => "required"), array("after" => "The :attribute must be after the employee start date."));
if ($validator->fails()) {
/* 7. When error has been found, $rowsWithError is immediately updated. Also, $hasError and $rowHasError are set to true.*/
$hasError = true;
$rowHasError = true;
$rowsWithErrors[$rowIndex] = $rowIndex;
/* 8. Then I will check which fields has error.
*
* 9. If an error has been found in a certain field,
* I will loop through the errors found on that field, increment the $errorCount (which, again, tracks
* how many errors has been found on a certain row.), update the two-dimensional $error array.
* Please note that the first array of $error contains the row number which the errors found belong to.
*
*/
if ($validator->messages()->get("employee number")) {
foreach ($validator->messages()->get("employee number") as $e) {
$errorCount += 1;
$error[$rowIndex][$errorCount] = $errorCount . ". " . $e . "<br/>";
}
}
if ($validator->messages()->get("last name")) {
foreach ($validator->messages()->get("last name") as $e) {
$errorCount += 1;
$error[$rowIndex][$errorCount] = $errorCount . ". " . $e . "<br/>";
}
}
if ($validator->messages()->get("first name")) {
foreach ($validator->messages()->get("first name") as $e) {
$errorCount += 1;
$error[$rowIndex][$errorCount] = $errorCount . ". " . $e . "<br/>";
}
}
if ($validator->messages()->get("username")) {
foreach ($validator->messages()->get("username") as $e) {
$errorCount += 1;
$error[$rowIndex][$errorCount] = $errorCount . ". " . $e . "<br/>";
}
}
if ($validator->messages()->get("start date")) {
foreach ($validator->messages()->get("start date") as $e) {
$errorCount += 1;
$error[$rowIndex][$errorCount] = $errorCount . ". " . $e . "<br/>";
}
}
if ($validator->messages()->get("end date")) {
foreach ($validator->messages()->get("end date") as $e) {
$errorCount += 1;
$error[$rowIndex][$errorCount] = $errorCount . ". " . $e . "<br/>";
}
}
if ($validator->messages()->get("email")) {
foreach ($validator->messages()->get("email") as $e) {
$errorCount += 1;
$error[$rowIndex][$errorCount] = $errorCount . ". " . $e . "<br/>";
}
}
if ($validator->messages()->get("status")) {
foreach ($validator->messages()->get("status") as $e) {
$errorCount += 1;
$error[$rowIndex][$errorCount] = $errorCount . ". " . $e . "<br/>";
}
}
}
if (!preg_match('/^[\\pL.-\\s]+$/u', $r->firstname) || !preg_match('/^[\\pL.-\\s]+$/u', $r->lastname)) {
$hasError = true;
//This will only matter if no errors has been found above.
$rowHasError = true;
//This will only matter if no errors has been found above.
$rowsWithErrors[$rowIndex] = $rowIndex;
//This will only matter if no errors has been found above.
$errorCount += 1;
$error[$rowIndex][$errorCount] = $errorCount . ". " . "First name/last name fields must only contain alphabetic characters and whitespaces." . "<br/>";
}
if (!is_numeric($r->manager)) {
$hasError = true;
//This will only matter if no errors has been found above.
$rowHasError = true;
//This will only matter if no errors has been found above.
$rowsWithErrors[$rowIndex] = $rowIndex;
//This will only matter if no errors has been found above.
$errorCount += 1;
$error[$rowIndex][$errorCount] = $errorCount . ". " . "Manager ID should be numeric." . "<br/>";
}
if (is_numeric($r->manager) && !Manager::find($r->manager)) {
$hasError = true;
//This will only matter if no errors has been found above.
$rowHasError = true;
//This will only matter if no errors has been found above.
$rowsWithErrors[$rowIndex] = $rowIndex;
//This will only matter if no errors has been found above.
$errorCount += 1;
$error[$rowIndex][$errorCount] = $errorCount . ". " . "Invalid manager ID." . "<br/>";
}
if (empty(trim($r->nsnid)) && !in_array(strtolower($r->status), array("academy", "ojt", "contractual", "graduate", "obsolete"))) {
$hasError = true;
//This will only matter if no errors has been found above.
$rowHasError = true;
//This will only matter if no errors has been found above.
$rowsWithErrors[$rowIndex] = $rowIndex;
//This will only matter if no errors has been found above.
$errorCount += 1;
$error[$rowIndex][$errorCount] = $errorCount . ". " . "The NSN ID is required." . "<br/>";
}
if (!empty($r->nsnid) && !is_numeric(trim($r->nsnid)) && !in_array($r->status, array("academy", "ojt", "contractual", "graduate", "obsolete"))) {
$hasError = true;
//This will only matter if no errors has been found above.
$rowHasError = true;
//This will only matter if no errors has been found above.
$rowsWithErrors[$rowIndex] = $rowIndex;
//This will only matter if no errors has been found above.
$errorCount += 1;
$error[$rowIndex][$errorCount] = $errorCount . ". " . "The NSN ID should be numeric." . "<br/>";
}
if (!empty($r->nsnid) && Employee::where("nsn_id", "=", $r->nsnid)->first()) {
$hasError = true;
//This will only matter if no errors has been found above.
$rowHasError = true;
//This will only matter if no errors has been found above.
$rowsWithErrors[$rowIndex] = $rowIndex;
//This will only matter if no errors has been found above.
$errorCount += 1;
$error[$rowIndex][$errorCount] = $errorCount . ". " . "NSN ID already exists." . "<br/>";
}
if (!empty($r->email) && !filter_var(trim($r->email), FILTER_VALIDATE_EMAIL)) {
$hasError = true;
//This will only matter if no errors has been found above.
$rowHasError = true;
//This will only matter if no errors has been found above.
$rowsWithErrors[$rowIndex] = $rowIndex;
//This will only matter if no errors has been found above.
$errorCount += 1;
$error[$rowIndex][$errorCount] = $errorCount . ". " . "Invalid e-mail address." . "<br/>";
}
if (is_numeric($r->businessline) && !BusinessLine::find($r->businessline)) {
$hasError = true;
//This will only matter if no errors has been found above.
$rowHasError = true;
//This will only matter if no errors has been found above.
$rowsWithErrors[$rowIndex] = $rowIndex;
//This will only matter if no errors has been found above.
$errorCount += 1;
$error[$rowIndex][$errorCount] = $errorCount . ". " . "Invalid Business Line ID." . "<br/>";
}
if (is_numeric($r->unit) && !Unit::find($r->unit)) {
$hasError = true;
//This will only matter if no errors has been found above.
$rowHasError = true;
//This will only matter if no errors has been found above.
$rowsWithErrors[$rowIndex] = $rowIndex;
//This will only matter if no errors has been found above.
$errorCount += 1;
$error[$rowIndex][$errorCount] = $errorCount . ". " . "Invalid Unit ID." . "<br/>";
}
if (is_numeric($r->unit) && is_numeric($r->businessline) && (Unit::find($r->unit) && !Unit::where("id", "=", $r->unit)->where("businessline_id", "=", $r->businessline)->first())) {
$hasError = true;
//This will only matter if no errors has been found above.
$rowHasError = true;
//This will only matter if no errors has been found above.
$rowsWithErrors[$rowIndex] = $rowIndex;
//This will only matter if no errors has been found above.
$errorCount += 1;
$error[$rowIndex][$errorCount] = $errorCount . ". " . "Selected Unit ID does not belong to the selected Business Line ID." . "<br/>";
}
if (!in_array(strtolower($r->status), array("ojt", "contractual", "nsn guest", "academy", "graduate", "on-board", "resigned", "obsolete"))) {
$hasError = true;
//This will only matter if no errors has been found above.
$rowHasError = true;
//This will only matter if no errors has been found above.
$rowsWithErrors[$rowIndex] = $rowIndex;
//This will only matter if no errors has been found above.
$errorCount += 1;
$error[$rowIndex][$errorCount] = $errorCount . ". " . "Invalid employee status." . "<br/>";
}
if (!$rowHasError) {
$hasCorrectRows = true;
$desc = "(" . Session::get('user_type') . ") " . "<strong>" . Session::get('username') . "</strong> has added employee <strong>" . trim($r->firstname) . " " . trim($r->lastname) . "</strong>, employee number <strong>" . trim($r->employeenumber) . "</strong>, with status <strong>" . trim($r->status) . "</strong>.";
$employee = new Employee();
$employee->employee_number = $r->employeenumber;
$employee->last_name = trim($r->lastname);
$employee->first_name = trim($r->firstname);
$employee->username = trim($r->username) != null ? trim($r->username) : null;
$employee->nickname = trim($r->nickname) != null ? trim($r->nickname) : null;
$employee->manager_id = $r->manager != null ? $r->manager : null;
$employee->start_date = $r->startdate;
$employee->end_date = $r->enddate != null ? $r->enddate : null;
$employee->nsn_id = $r->nsnid != null ? $r->nsnid : null;
$employee->email = trim($r->email) != null ? trim($r->email) : null;
$employee->business_line_id = $r->businessline != null ? $r->businessline : null;
$employee->unit_id = $r->unit != null ? $r->unit : null;
$employee->subunit = trim($r->subunit) != null ? trim($r->subunit) : null;
$employee->cellphone_number = trim($r->cellphonenumber) != null ? trim($r->cellphonenumber) : null;
$employee->status = trim($r->status);
$employee->save();
//Log the changes made
$newLog = new UserLog();
$newLog->description = $desc;
$newLog->user_id = Session::get('user_id');
$newLog->type = "Employees";
$newLog->save();
}
}
File::delete($readFile);
if ($hasCorrectRows) {
//Log the changes made
$desc = "(" . Session::get("user_type") . ") <b>" . Session::get("username") . "</b> has imported data to the employees database. ";
$newLog = new UserLog();
$newLog->description = $desc;
$newLog->user_id = Session::get('user_id');
$newLog->type = "Employees";
$newLog->save();
}
return $this->importResult($hasError, $hasCorrectRows, $rowsWithErrors, $error);
}
} else {
return Redirect::to('/');
}
}
} elseif ($isEmployeeType === 'is_supervisor') {
//Supervisor:2
$employee->employee_type = 2;
$employee->manager_id = $data["department_head"];
$employee->supervisor_id = 0;
} elseif ($isEmployeeType === 'is_employee') {
//Employee:0
$employee->employee_type = 0;
$employee->manager_id = $data["department_head"];
$employee->supervisor_id = $data["supervisor_id"];
}
$employee->company_id = $data["company_id"];
$employee->department_id = $data["department_id"];
$employee->position_id = $data["position_id"];
$email = !empty($data['email']) ? $data['email'] : strtolower($employeeUpdate->firstname) . '.' . strtolower($employeeUpdate->lastname) . '@backofficeph.com';
if ($employee->save()) {
try {
// Create the user
$SentryUser = Sentry::createUser(array('email' => trim($email), 'employee_id' => $employee->id, 'employee_number' => trim(ucwords($data["employee_number"])), 'password' => $data['password'], 'first_name' => trim(ucwords($data['firstname'])), 'last_name' => trim(ucwords($data['lastname'])), 'activated' => true));
if ($SentryUser) {
$userId = $SentryUser->id;
DB::table('employee_setting')->insert(array('employee_id' => $employee->id, 'has_overtime' => 1, 'has_break' => 1, 'break_time' => '01:00:00', 'hours_per_day' => number_format(8, 2)));
if (isset($userId)) {
DB::table('users_groups')->insert(array('user_id' => $userId, 'group_id' => $data["role_id"]));
}
Session::put('newEmployeeId', $employee->id);
//return Redirect::route('adminDashboard');
return Redirect::route('adminUserNewSchedule', array('newEmployeeId' => $employee->id));
}
} catch (Cartalyst\Sentry\Users\LoginRequiredException $e) {
echo 'Login field is required.';
$file = $filename . '.' . $ext;
Input::file('employees')->move($destination, $file);
Excel::selectSheetsByIndex(0)->load(public_path() . '/migrations/' . $file, function ($reader) {
$results = $reader->get();
foreach ($results as $result) {
$employee = new Employee();
$employee->personal_file_number = $result->employment_number;
$employee->first_name = $result->first_name;
$employee->last_name = $result->surname;
$employee->middle_name = $result->other_names;
$employee->identity_number = $result->id_number;
$employee->pin = $result->kra_pin;
$employee->social_security_number = $result->nssf_number;
$employee->hospital_insurance_number = $result->nhif_number;
$employee->email_office = $result->email_address;
$employee->save();
}
});
}
return Redirect::back()->with('notice', 'Employees have been succeffully imported');
});
/* #################### IMPORT EARNINGS ################################## */
Route::post('import/earnings', function () {
if (Input::hasFile('earnings')) {
$destination = public_path() . '/migrations/';
$filename = str_random(12);
$ext = Input::file('earnings')->getClientOriginalExtension();
$file = $filename . '.' . $ext;
Input::file('earnings')->move($destination, $file);
Excel::selectSheetsByIndex(0)->load(public_path() . '/migrations/' . $file, function ($reader) {
$results = $reader->get();
public function executeAddStaff(sfWebRequest $request)
{
if ($request->isMethod('Post')) {
/*Varialbes for Redirecting
$user_name = $this->getRequestParameter('user_name');
$password = $this->getRequestParameter('password');
if (strlen($password) != 0)
{
$password = md5($password);
}
else $password = '';*/
// Setting Department from Selected Designation
$a = new Criteria();
$a->add(DesignationPeer::ID, $this->getRequestParameter('designation_id'));
$designation_record = DesignationPeer::DoSelectOne($a);
$department_id = $designation_record->getDepartmentId();
// Checking if Entered Username already exist
/*if($user_name != NULL)
{
$c = new Criteria ( );
$c->add(UserPeer::STATUS, Constant::RECORD_STATUS_DELETED, Criteria::NOT_EQUAL );
$c->add(UserPeer::USER, $user_name);
$check_username = UserPeer::doSelectOne($c);
if ($check_username)
{
$this->getUser ()->setFlash ( 'ERROR_MESSAGE', 'Username Already exist. Please Choose Different Username.' );
$this->redirect ('Register/add');
}
}*/
$employee = new Employee();
$employee->setRoleId($this->getRequestParameter('role_id'));
$employee->setName($this->getRequestParameter('name'));
$employee->setCnic($this->getRequestParameter('cnic'));
$employee->setDob($this->getRequestParameter('dob'));
$employee->setGender($this->getRequestParameter('gender[0]'));
$employee->setContactCell($this->getRequestParameter('contact_cell'));
$employee->setContactRes($this->getRequestParameter('contact_res'));
$employee->setContactOff($this->getRequestParameter('contact_off'));
$employee->setEmergencyContact($this->getRequestParameter('emergency_contact'));
$employee->setMailAddress($this->getRequestParameter('mail_address'));
$employee->setDesignationId($this->getRequestParameter('designation_id'));
$employee->setDepartmentId($department_id);
//$employee->setRoleId(2);
$employee->setEmploymentDate($this->getRequestParameter('employment_date'));
$employee->setLocalResident($this->getRequestParameter('local[0]'));
$employee->setQualification($this->getRequestParameter('qualification'));
$employee->setEmpCategory('staff');
$employee->setStatus(Constant::RECORD_STATUS_ACTIVE);
$employee->save();
$this->getUser()->setFlash('SUCCESS_MESSAGE', Constant::REGISTRATION_ACCOUNT_APPROVAL);
$this->redirect('Employee/list');
/*if($user_name != NULL)
{
$user = new User();
$user->setEmployeeId($employee_id);
$user->setUser($user_name);
$user->setPassword($password);
$user->setStatus(Constant::RECORD_STATUS_ACTIVE);
$user->save();
// TODO: Default Rights here
}// END if
$this->getUser ()->setFlash ( 'SUCCESS_MESSAGE', Constant::REGISTRATION_ACCOUNT_APPROVAL );
$this->redirect('Register/list');
*/
}
// end IF
}
