/**
* Saves new/existing employee to database and returns status in json response
*
* @param Request $request
* @return array
*/
public function save(Request $request)
{
$id = $request->input('id');
if (null != $id) {
$employee = $this->employee->find($id);
$employee->fill($request->all());
} else {
$employee = $this->employee->create($request->all());
}
if ($employee->save()) {
return ['status' => 200];
}
return ['status' => 500];
}
public function testChildModelDefaultsType()
{
$data = factory(User::class)->make()->toArray();
unset($data['type']);
$employee = Employee::create($data + ['password' => 'testing']);
$this->assertEquals(Employee::class, $employee->type);
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
//
$employee = $request->all();
return Employee::create($employee);
/*$employees = DB::select(DB::raw("select employee.id,employee.name, employee.status, employee.wage, employee.designation, employee.joinedDate from employee "));
$data = json_encode(array('employees'=>$employees));
return $data;*/
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Requests\EmployeeRequest $request)
{
//
$data = $request->except('_token');
$data['user_id'] = \Auth::User()->id;
$employee = new Employee();
$employee->create($data);
return back();
}
/**
* Store a newly created resource in storage.
* We need to import Illuminate\Http\Request classfor the CreateEmployeeRequest
* @param CreateEmployeeRequest|CreatePhonebookContactRequest|Request $request
* @return \Illuminate\Http\Response
*/
public function store(CreatePhonebookContactRequest $request)
{
// if the validation succed, the store() method is executed
// On fail, the store() method never created and we are redirected to the previous route to correct the errors
// Fetch the http post request ($request) from create.blade.php as an array of column and value pairs representing the columns that should be stored to the DB
Employee::create($request->input());
// when the data have been stored into the DB, we are redirected to index
return redirect(route('phonebook.contact.index'));
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(Request $request)
{
$input = $request->all();
$employee = \App\Employee::create($input);
$project_id = $request->input('project');
$date_start = $request->input('starting_date');
$role = $request->input('function');
$employee->projects()->attach($project_id, ['date_start' => $date_start]);
Session::flash('flash_message', 'Employee successfully added!');
return redirect()->back();
}
public function store(Request $request)
{
// return $request->photo;
$this->validate($request, ['name' => 'required', 'present_address' => 'required', 'permanent_address' => 'required', 'mobile' => 'required|numeric', 'national_id' => 'required|numeric', 'designation' => 'required', 'raid' => 'required|numeric', 'status' => 'required|boolean', 'email' => 'email']);
$employee = Employee::create($request->all());
if ($request->photo) {
$employee->photo = $this->upload();
}
$employee->save();
return redirect()->to('/hr/employee');
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(Request $request)
{
// dd($request->all());
if ($this->validator($request->all())->fails()) {
flash()->error("Ooppss! You've got an error. Check the fields below.");
return redirect()->back()->withInput();
} else {
Employee::create($request->all());
flash()->success("Employee successfully added!");
}
return redirect()->back();
}
public function save()
{
$data = Request::input('data');
Candidate::find($data['id'])->update(['status_record_id' => $data['status_record_id'], 'time_interview' => $data['time_interview'], 'time' => $data['time']]);
if ($data['employee_id'] != '') {
Candidate::find($data['id'])->employees()->sync($data['employee_id']);
}
if ($data['status_record_id'] == 2) {
$candidate = Candidate::find($data['id']);
Employee::create(['firstname' => $candidate->first_name, 'lastname' => $candidate->last_name, 'phone' => $candidate->phone, 'email' => $candidate->email, 'position_id' => $data['position'], 'date_of_birth' => $candidate->date_of_birth]);
}
}
public function store(Request $request)
{
// dd($request->all());
$password = $request->input('password');
$card = $request->input('card') == "" ? 0 : $request->input('card');
$name = $request->input('name');
$all_users = Employee::where('device_id', $this->connected_device['device_id'])->orderBy('pin')->get();
$next_pin = $this->unused_id($all_users);
// send the employee to device and store it
$this->tad->set_user_info(["pin" => $next_pin, "password" => $password, 'card' => $card, 'name' => $name, "group" => "1"]);
// store the employee to DB
$employee = Employee::create(['pin' => $next_pin, 'name' => $name, 'device_id' => $this->connected_device['device_id'], 'password' => $password, 'card' => $card]);
$employee->save();
return redirect()->action('EmployeesController@index');
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
//
/*
* $table->string('number')->unique();
$table->string('name');
$table->string('email')->nullable();
$table->integer('company_id')->unsigned();
$table->string('department_name')->nullable();
$table->string('costcent')->nullable();
$table->integer('category_id')->unsigned();
$table->integer('status_id')->unsigned();
*/
$data = $request->except(['_token', 'bankaccount', 'bankinfo', 'attachment', 'level_id']);
//dd($data);
Employee::create($data);
return back();
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
// $this->call(UserTableSeeder::class);
Model::unguard();
DB::table('users')->delete();
DB::table('admins')->delete();
DB::table('employees')->delete();
DB::table('entries')->delete();
$users = array(['name' => 'Ryan Chenkie', 'email' => '*****@*****.**', 'password' => bcrypt('secret'), 'type' => 1], ['name' => 'Chris Sevilleja', 'email' => '*****@*****.**', 'password' => bcrypt('secret'), 'type' => 3], ['name' => 'Holly Lloyd', 'email' => '*****@*****.**', 'password' => bcrypt('secret'), 'type' => 2], ['name' => 'Adnan Kukic', 'email' => '*****@*****.**', 'password' => bcrypt('secret'), 'type' => 2]);
// Loop through each user above and create the record for them in the database
foreach ($users as $user) {
User::create($user);
}
Employee::create(['type' => 1, 'user_id' => 3]);
Employee::create(['type' => 2, 'user_id' => 4]);
Admin::create(['type' => 1, 'user_id' => 1]);
Entry::create(['timeIn' => Carbon::now(), 'user_id' => 2]);
Model::reguard();
}
/**
* Create a new user instance after a valid registration.
*
* @param array $data
* @return User
*/
protected function create(array $data)
{
$newUser = User::create(['username' => $data['username'], 'password' => bcrypt($data['password']), 'created_at' => gmdate('Y-m-d H:i:s'), 'updated_at' => gmdate('Y-m-d H:i:s'), 'userTypeId' => $data['userTypeId']]);
$userTypeId = $newUser->userTypeId;
if ($userTypeId == 1 || $userTypeId == 2) {
$newEmployee = Employee::create(['userId' => $newUser->id, 'firstName' => $data['firstName'], 'lastName' => $data['lastName'], 'email' => $data['email'], 'phone' => $data['phone'], 'streetAddress' => $data['streetAddress'], 'city' => $data['city'], 'state' => $data['state'], 'zipcode' => $data['zipcode'], 'ssn' => $data['ssn'], 'hourlyRate' => $data['hourlyRate'], 'primaryStoreId' => $data['primaryStoreId']]);
}
if ($userTypeId == 3) {
if (array_key_exists('accountId', $data)) {
$newContact = Contact::create(['userId' => $newUser->id, 'accountId' => $data['accountId'], 'firstName' => $data['firstName'], 'lastName' => $data['lastName'], 'email' => $data['email'], 'phone' => $data['phone'], 'contactTypeId' => $data['contactTypeId']]);
} else {
$newAccount = Account::create(['companyName' => $data['companyName'], 'streetAddress' => $data['streetAddress'], 'city' => $data['city'], 'state' => $data['state'], 'zipcode' => $data['zipcode'], 'accountStatus' => $data['accountStatus']]);
$accntId = $newAccount->id;
$newContant = Contact::create(['userId' => $newUser->id, 'accountId' => $accntId, 'firstName' => $data['firstName'], 'lastName' => $data['lastName'], 'email' => $data['email'], 'phone' => $data['phone'], 'contactTypeId' => $data['contactTypeId']]);
$newBalance = Balance::create(['accountId' => $accntId, 'balance' => 0.0]);
}
}
return $newUser;
}
public function import()
{
/************* Base ***********/
Excel::load('data/base_stcs.csv', function ($reader) {
foreach ($reader->get() as $employee) {
Employee::create(["no_emp" => $employee->noemp, "first_name" => ucwords(mb_strtolower($employee->nombre, 'UTF-8')), "last_name" => '', "gender" => "f", "status" => 1, "payrollID" => 3, "syndicateID" => 1]);
}
});
Excel::load('data/base_sthcs.csv', function ($reader) {
foreach ($reader->get() as $employee) {
Employee::create(["no_emp" => $employee->noemp, "first_name" => ucwords(mb_strtolower($employee->nombre, 'UTF-8')), "last_name" => '', "gender" => "f", "status" => 1, "payrollID" => 3, "syndicateID" => 2]);
}
});
Excel::load('data/base_sitcs.csv', function ($reader) {
foreach ($reader->get() as $employee) {
Employee::create(["no_emp" => $employee->noemp, "first_name" => ucwords(mb_strtolower($employee->nombre, 'UTF-8')), "last_name" => '', "gender" => "f", "status" => 1, "payrollID" => 3, "syndicateID" => 3]);
}
});
return Employee::all();
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::table('employees')->delete();
$faker = \Faker\Factory::create();
/**
* this for admin account
*/
$emp = Employee::create(['user_id' => 801, 'name' => 'Robinson L. Legaspi', 'department' => 'quality_assurance', 'station' => 'DCC', 'position' => 'Management System Officer', 'email' => '*****@*****.**', 'status' => 'active']);
User::create(['employee_id' => 801, 'access_level' => 'admin', 'password' => 'admin', 'avatar' => 'default.png']);
Question::create(['user_id' => $emp->user_id, 'question' => 'What are you?', 'answer' => 'user']);
/**
* this for process account
*/
$emp = Employee::create(['user_id' => 802, 'name' => 'Nepthal Dave S. Pakingan', 'department' => 'process_engineering', 'station' => 'Process Engineer', 'position' => 'HR Programmer', 'email' => '*****@*****.**', 'status' => 'active']);
User::create(['employee_id' => 802, 'access_level' => 'signatory', 'password' => 'user', 'avatar' => 'default.png']);
Question::create(['user_id' => $emp->user_id, 'question' => 'What are you?', 'answer' => 'user']);
/**
* this for process account
*/
$emp = Employee::create(['user_id' => 4550, 'name' => 'Pauleen Moya', 'department' => 'production', 'station' => 'PL1', 'position' => 'Supervisor', 'email' => '*****@*****.**', 'status' => 'active']);
User::create(['employee_id' => 4550, 'access_level' => 'signatory', 'password' => 'user', 'avatar' => 'default.png']);
Question::create(['user_id' => $emp->user_id, 'question' => 'What are you?', 'answer' => 'user']);
/**
* this for dummy account
*/
foreach (range(1, 200) as $index) {
$department = $faker->randomElement(['production', 'process_engineering', 'quality_assurance', 'other_department']);
$station['quality_assurance'] = ['quality assurance'];
$station['process_engineering'] = ['process engineering'];
$station['production'] = ['pl1', 'pl2', 'pl3', 'pl4', 'pl7', 'pl9'];
$station['other_department'] = ['equipment engineering', 'facilities', 'mis', 'human resource', 'purchasing and logistics', 'finance', 'utilities'];
$emp = Employee::create(['user_id' => $faker->unique()->randomNumber, 'name' => $faker->name('male' | 'female'), 'department' => $department, 'station' => $faker->randomElement($station[$department]), 'position' => $faker->randomElement(['Supervisor', 'Operator', 'Manager']), 'status' => $faker->randomElement(['active', 'resigned']), 'email' => $faker->email]);
User::create(['employee_id' => $emp->user_id, 'access_level' => $faker->randomElement(['user', 'signatory']), 'password' => '8d', 'avatar' => 'default.png']);
Question::create(['user_id' => $emp->user_id, 'question' => 'What are you?', 'answer' => 'user']);
}
}
/**
* Store a newly created resource in storage.
*
* @param EmployeeRequest $request
* @return \Illuminate\Http\Response
*/
public function store(EmployeeRequest $request)
{
Employee::create($request->all());
session()->flash('flash_message', 'Werknemer toegevoegd!');
return redirect('werknemers');
}
protected function updateDepartmentAndStatus($request)
{
$employee = Employee::create($request->all());
$employee->update(['status' => 'active', 'department' => Station::whereStation($request->station)->first()->department]);
return $employee;
}
/**
* Store newly added employee on database
* @param EmployeeRequest $request
* @return \Illuminate\Http\RedirectResponse|\Illuminate\Routing\Redirector
*/
public function store(EmployeeRequest $request)
{
if ($request->hasFile('image')) {
$image_name = $request->eid . '.' . $request->file('image')->getClientOriginalExtension();
$request->file('image')->move(base_path() . '/resources/assets/images/employee', $image_name);
$data = $request->except(['image']);
$data['image'] = $image_name;
$data['status'] = 'Active';
Employee::create($data);
} else {
$request['status'] = 'Active';
Employee::create($request->all());
}
Session::flash('success_message', 'Employee has been added successfully!');
return redirect('employee');
}
public function importEMP($destfile)
{
/*
*
* $table->string('number')->unique();
$table->integer('category_id')->unsigned();
$table->integer('level_id')->unsigned();
$table->integer('company_id')->unsigned();
$table->integer('status_id')->unsigned();
$table->string('department_name');
$table->string('costcenter');
$table->string('bank_account')->nullable();
$table->string("bank_info")->nullable();
$table->string('name');
*/
Excel::load($destfile, function ($reader) {
$rules = ['number' => 'required|unique:employees', 'company_id' => 'required|exists:companies,id', 'bank_account' => 'required|unique:employees', 'phone_number' => 'required'];
$sheetsCount = $reader->getSheetCount();
for ($i = 0; $i < $sheetsCount; $i++) {
$sheets = $reader->getSheet($i)->toArray();
$company_name = $reader->getSheet($i)->getTitle();
$dept['company_id'] = Company::where('name', $company_name)->value('id');
$sheetCount = count($sheets);
for ($j = 6; $j < $sheetCount; $j++) {
// Get Department ID;
$employee['department_name'] = trim($sheets[$j][1]);
$employee['costcenter'] = trim($sheets[$j][10]);
$employee['company_id'] = $dept['company_id'];
$employee['name'] = trim($sheets[$j][2]);
$employee['number'] = $sheets[$j][3];
$level_credit = trim($sheets[$j][6]);
if ($level_credit == '实报实销') {
$employee['level_id'] = 5;
} elseif (intval($level_credit) < 200) {
$employee['level_id'] = 1;
} elseif (intval($level_credit) > 400) {
$employee['level_id'] = 3;
} else {
$employee['level_id'] = 2;
}
$employee['phone_number'] = trim($sheets[$j][4]);
$employee['category_id'] = 2;
$employee['status_id'] = 1;
$employee['bank_info'] = trim($sheets[$j][9]);
$employee['bank_account'] = str_replace('-', '', trim($sheets[$j][8]));
$emp_v = \Validator::make($employee, $rules);
if ($emp_v->fails()) {
} else {
Employee::create($employee);
}
}
}
//END
});
}
/**
* Persist new employee in the DB
*
* @param SaveEmployeeRequest|Request $request
* @return \Illuminate\Http\RedirectResponse
*/
public function doAddEmployee(SaveEmployeeRequest $request)
{
$employee = Employee::create($request->all());
$name = $employee->firstname . ' ' . $employee->lastname;
return redirect()->back()->with('flash_message', 'Employee: ' . $name . ' created');
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Employee::create(['firstname' => 'John', 'lastname' => 'Doe', 'birthdate' => '1990-01-01', 'job_id' => 1, 'location_id' => 1, 'hired' => '2016-01-05']);
Employee::create(['firstname' => 'Jane', 'lastname' => 'Doe', 'birthdate' => '1991-01-01', 'job_id' => 3, 'location_id' => 1, 'hired' => '2016-01-08']);
Employee::create(['firstname' => 'Foo', 'lastname' => 'Bar', 'birthdate' => '1993-03-01', 'job_id' => 2, 'location_id' => 2, 'hired' => '2015-11-05']);
}
protected function portalCreateEmployee() {
$fName = Input::get('firstName');
$lName = Input::get('lastName');
$email = Input::get('email');
$phone = Input::get('phone');
$streetAddress = Input::get('streetAddress');
$city = Input::get('city');
$state = Input::get('state');
$zipcode = Input::get('zipcode');
$ssn = Input::get('ssn');
$rate = Input::get('hourlyRate');
$store = Input::get('primaryStoreId');
$userType = Input::get('userTypeId');
$username = Input::get('username');
$password = Input::get('password');
$newUser = User::create([
'username' => $username,
'password' => bcrypt($password),
'created_at' => gmdate('Y-m-d H:i:s'),
'updated_at' => gmdate('Y-m-d H:i:s'),
'userTypeId' => $userType
]);
$userTypeId = $newUser->userTypeId;
if ( $userTypeId == 1 || $userTypeId == 2) {
$newEmployee = Employee::create([
'userId' => $newUser->id,
'firstName' => $fName,
'lastName' => $lName,
'email' => $email,
'phone' => $phone,
'streetAddress' => $streetAddress,
'city' => $city,
'state' => $state,
'zipcode' => $zipcode,
'ssn' => $ssn,
'hourlyRate' => $rate,
'primaryStoreId' => $store,
'created_at' => gmdate('Y-m-d H:i:s'),
]);
$newTimesheet = Timesheet::create([
'empId' => $newEmployee->id,
'sunday' => 0,
'monday' => 0,
'tuesday' => 0,
'wednesday' => 0,
'thursday' => 0,
'friday' => 0,
'saturday' => 0,
'total' => 0,
'created_at' => gmdate('Y-m-d H:i:s'),
]);
}
return Redirect::to('/portal-employees');
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store(Request $request)
{
$employee = Employee::create($request->all());
$employee->departments()->sync($request->input('departments') ?: []);
return redirect()->route('employees.index');
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(EmployeeRequest $request)
{
Employee::create($request->all());
return redirect(route('employees.index'))->with('message', 'Empleado creado corectamente');
}
/**
* Store a newly created resource in storage.
*
* @param app\Requests\CreateEmployeeRequest|Requests\CreateEmployeeRequest $request
* @return Response
*/
public function store(Requests\CreateEmployeeRequest $request)
{
$input = $request->all();
$input['created_at'] = Carbon::now();
$input['updated_at'] = Carbon::now();
App\Employee::create($input);
$header = 'Success';
$message = 'You have successfully added a new employee record.';
echo '<script>
alert("You have successfully added a new employee record.");
window.location.replace("../employees/create");
</script>';
//return redirect()->to('/employees/create')->with(compact($header, $message));
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
//$count = 200;
// use the factory to create a Faker\Generator instance
//$faker = Faker::create('es_ES');
/*for($i = 1;$i < $count; $i++)
{
Employee::create([
"no_emp" => $faker->unique()->numberBetween($min = 1000, $max = 9000),
"first_name" => $faker->firstName(),
"last_name" => $faker->lastName().' '.$faker->lastName(),
"gender" => "f",
"status" => 1,
"payrollID" => $faker->numberBetween($min = 1, $max = 5),
"syndicateID" => $faker->numberBetween($min = 1, $max = 3)
]);
}*/
//Confianza
Employee::create(["no_emp" => '398', "first_name" => ucwords(mb_strtolower('EVA DELIA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('LOPEZ SANTOS', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '422', "first_name" => ucwords(mb_strtolower('DANIEL PAUL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('ESTRADA GALEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '450', "first_name" => ucwords(mb_strtolower('CLAUDIA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('JACOBO GARCIA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '610', "first_name" => ucwords(mb_strtolower('MARIA PATRICIA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('JACOBO GARCIA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '611', "first_name" => ucwords(mb_strtolower('LUZ CRISTINA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('PIÑA MUÑOZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '756', "first_name" => ucwords(mb_strtolower('MARIBEL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MENDEZ ANGELES', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '762', "first_name" => ucwords(mb_strtolower('HILDA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('PALMA DURAN', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '836', "first_name" => ucwords(mb_strtolower('RAUL OSCAR', 'UTF-8')), "last_name" => ucwords(mb_strtolower('HERNANDEZ BLANCAS', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '1190', "first_name" => ucwords(mb_strtolower('ELVIA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('ROLDAN NEGRETE', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '1287', "first_name" => ucwords(mb_strtolower('MARIA LIDIA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('PATROCINIO CELAYA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '1482', "first_name" => ucwords(mb_strtolower('FERNANDO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('JIMENEZ BORREGO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '1973', "first_name" => ucwords(mb_strtolower('MARIA DOLORES ENEDINA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('FERRO LOPEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '2107', "first_name" => ucwords(mb_strtolower('AGUSTIN', 'UTF-8')), "last_name" => ucwords(mb_strtolower('SANCHEZ VERTIZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '2142', "first_name" => ucwords(mb_strtolower('ROSA MARIA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('VILLAGORDOA RESA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '2328', "first_name" => ucwords(mb_strtolower('RAYMUNDO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MORALES MARTINEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '2445', "first_name" => ucwords(mb_strtolower('MARTHA ELENA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MIRON SOTO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '2462', "first_name" => ucwords(mb_strtolower('ADRIANA HAYDE', 'UTF-8')), "last_name" => ucwords(mb_strtolower('ACO SEGOVIA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '2822', "first_name" => ucwords(mb_strtolower('AGUSTIN', 'UTF-8')), "last_name" => ucwords(mb_strtolower('PEÑA ACOSTO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '2882', "first_name" => ucwords(mb_strtolower('MARGARITA DIANA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('SANCHEZ HERNANDEZ ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '2986', "first_name" => ucwords(mb_strtolower('DAVID', 'UTF-8')), "last_name" => ucwords(mb_strtolower('ESCOBEDO CASTRO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '3126', "first_name" => ucwords(mb_strtolower('ROBERTO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('ESTRADA SILVA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '3132', "first_name" => ucwords(mb_strtolower('BERTHA ALICIA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('GUERRERO INDA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '3376', "first_name" => ucwords(mb_strtolower('FRANCISCO DANIEL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('CONTRERAS SANCHEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '3391', "first_name" => ucwords(mb_strtolower('MARTA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('ROSAS MARTINEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '3464', "first_name" => ucwords(mb_strtolower('YOLANDA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('LOPEZ MIGUEL', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '3528', "first_name" => ucwords(mb_strtolower('JULIO ABEL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('OLIVAS REYES', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '3583', "first_name" => ucwords(mb_strtolower('MARIA ANTONIA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('GARCIA QUINTERO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '3586', "first_name" => ucwords(mb_strtolower('EMILIANO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('GONZALEZ MARTINEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '4158', "first_name" => ucwords(mb_strtolower('MARIA ELENA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MARTINEZ MUÑOZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '4202', "first_name" => ucwords(mb_strtolower('ANGELICA MARIA TERESA DE JESUS', 'UTF-8')), "last_name" => ucwords(mb_strtolower('SYLVA AGUILAR ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '5866', "first_name" => ucwords(mb_strtolower('ERIC OMAR', 'UTF-8')), "last_name" => ucwords(mb_strtolower('DIAZ FLORES', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '6327', "first_name" => ucwords(mb_strtolower('JUAN RUBEN', 'UTF-8')), "last_name" => ucwords(mb_strtolower('DIAZ RAMOS', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '8655', "first_name" => ucwords(mb_strtolower('ULISES', 'UTF-8')), "last_name" => ucwords(mb_strtolower('SANDOVAL PAREDES', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '8744', "first_name" => ucwords(mb_strtolower('MARIA DEL CARMEN', 'UTF-8')), "last_name" => ucwords(mb_strtolower('PARADA AVALOS', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '10020', "first_name" => ucwords(mb_strtolower('DAVID', 'UTF-8')), "last_name" => ucwords(mb_strtolower('GUERRERO CECILIANO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '10690', "first_name" => ucwords(mb_strtolower('ELIAS ENOC', 'UTF-8')), "last_name" => ucwords(mb_strtolower('GOMEZ ROJAS', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '10999', "first_name" => ucwords(mb_strtolower('FERNANDO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('DEL VALLE FLORES', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 1]);
Employee::create(["no_emp" => '410', "first_name" => ucwords(mb_strtolower('RAFAEL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('ROSSAINZ GARCIA ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 2]);
Employee::create(["no_emp" => '755', "first_name" => ucwords(mb_strtolower('GRACIELA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('GARCIA REBOLLO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 2]);
Employee::create(["no_emp" => '1184', "first_name" => ucwords(mb_strtolower('JESUS ANTONIO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('FERNANDEZ RODRIGUEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 2]);
Employee::create(["no_emp" => '1431', "first_name" => ucwords(mb_strtolower('ROSA MARIA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('RODRIGUEZ RIVERO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 2]);
Employee::create(["no_emp" => '2281', "first_name" => ucwords(mb_strtolower('IRMA AMALIA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('DE LA O ESCALERA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 2]);
Employee::create(["no_emp" => '3390', "first_name" => ucwords(mb_strtolower('ALEJANDRO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('LAZO SERRANO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 2]);
Employee::create(["no_emp" => '3570', "first_name" => ucwords(mb_strtolower('ROSA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('ALVAREZ HILARIO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 2]);
Employee::create(["no_emp" => '3609', "first_name" => ucwords(mb_strtolower('ROCIO DE LOS ANGELES', 'UTF-8')), "last_name" => ucwords(mb_strtolower('DIAZ CASTILLO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 2]);
Employee::create(["no_emp" => '4692', "first_name" => ucwords(mb_strtolower('JUAN', 'UTF-8')), "last_name" => ucwords(mb_strtolower('GONZALEZ RIVAS', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 2]);
Employee::create(["no_emp" => '4862', "first_name" => ucwords(mb_strtolower('JULITA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('DEL ROSAL GARCIA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 2]);
Employee::create(["no_emp" => '5513', "first_name" => ucwords(mb_strtolower('VICTOR MANUEL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('PAEZ MONTOYA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 2]);
Employee::create(["no_emp" => '8221', "first_name" => ucwords(mb_strtolower('SUSANA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('BAUTISTA LARA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 1, "syndicateID" => 2]);
//Honorarios
Employee::create(["no_emp" => '1255', "first_name" => ucwords(mb_strtolower('ALFREDO BERNARDO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('RODRIGUEZ HERNANDEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '5090', "first_name" => ucwords(mb_strtolower('MICHEL MONSERRAT', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MENDOZA HERNANDEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '5230', "first_name" => ucwords(mb_strtolower('JOSE ANTONIO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('GARZON PICHARDO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '5388', "first_name" => ucwords(mb_strtolower('JUAN JOSE', 'UTF-8')), "last_name" => ucwords(mb_strtolower('SANCHEZ NAVARRO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '7027', "first_name" => ucwords(mb_strtolower('CARLOS ARTURO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('ORTEGA CORTES', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '7501', "first_name" => ucwords(mb_strtolower('JOSE FRANCISCO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MARTINEZ GOMEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '7751', "first_name" => ucwords(mb_strtolower('LEONOR ALEJANDRA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('CABRERA DELGADO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '8424', "first_name" => ucwords(mb_strtolower('REBECA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('JATTAR CARREON', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '10044', "first_name" => ucwords(mb_strtolower('PATRICIA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('FLORES VELASCO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '10100', "first_name" => ucwords(mb_strtolower('BRENDA GUADALUPE', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MAGAÑA DOMINGUEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '10368', "first_name" => ucwords(mb_strtolower('EVELYNN', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MORAN PUENTE', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '10450', "first_name" => ucwords(mb_strtolower('JOSE MARTI', 'UTF-8')), "last_name" => ucwords(mb_strtolower('BOETA BARROSO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '10523', "first_name" => ucwords(mb_strtolower('VERONICA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MEZA OJEDA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '10739', "first_name" => ucwords(mb_strtolower('JUAN ALEJANDRO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('HERNANDEZ GARRIDO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '10743', "first_name" => ucwords(mb_strtolower('RAQUEL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('BARRALES GUEVARA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '11244', "first_name" => ucwords(mb_strtolower('ADRIANA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('BUENROSTRO ESPINOZA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '11245', "first_name" => ucwords(mb_strtolower('JIMENA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('GONZALEZ GONZALEZ ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '2279', "first_name" => ucwords(mb_strtolower('MARIA DEL ROCIO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('CAZARES GARCIA ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '2294', "first_name" => ucwords(mb_strtolower('HORTENSIA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('PACHECO NAVARRO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '2692', "first_name" => ucwords(mb_strtolower('IRMA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MOSQUEDA FRAUSTO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '2734', "first_name" => ucwords(mb_strtolower('JAVIER', 'UTF-8')), "last_name" => ucwords(mb_strtolower('ESPINOZA MARTINEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '3617', "first_name" => ucwords(mb_strtolower('FRANCO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('BENITEZ CRUZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '4638', "first_name" => ucwords(mb_strtolower('JAVIER', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MARQUEZ SEPULVEDA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '6515', "first_name" => ucwords(mb_strtolower('ISRAEL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('SANCHEZ ZAMORA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '7098', "first_name" => ucwords(mb_strtolower('MARIA EUGENIA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('RODRIGUEZ CAMACHO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '7421', "first_name" => ucwords(mb_strtolower('JUAN LUIS', 'UTF-8')), "last_name" => ucwords(mb_strtolower('CONTRERAS MENDOZA ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '8225', "first_name" => ucwords(mb_strtolower('RAFAEL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('HERNANDEZ PEREZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '8309', "first_name" => ucwords(mb_strtolower('AURELIO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('GONZALEZ LOZADA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '8591', "first_name" => ucwords(mb_strtolower('ISABEL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('GARDUÑO LIMA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '8593', "first_name" => ucwords(mb_strtolower('JUAN ANTONIO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('CISNEROS HERNANDEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '8608', "first_name" => ucwords(mb_strtolower('WALTER ROMAN', 'UTF-8')), "last_name" => ucwords(mb_strtolower('VAZQUEZ LOPEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '8659', "first_name" => ucwords(mb_strtolower('FELIPE ANGEL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('RODRIGUEZ FLORES', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '8899', "first_name" => ucwords(mb_strtolower('ISABEL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('CRUZ FLORES', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '9003', "first_name" => ucwords(mb_strtolower('RAFAEL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MAQUEDA MEDINA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '9063', "first_name" => ucwords(mb_strtolower('OMAR DAVID', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MENDEZ GARCIA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '9093', "first_name" => ucwords(mb_strtolower('MARTIN HABIB', 'UTF-8')), "last_name" => ucwords(mb_strtolower('GAMA SANDOVAL', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '9104', "first_name" => ucwords(mb_strtolower('VICTOR MANUEL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MARTINEZ JUAREZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '9202', "first_name" => ucwords(mb_strtolower('AZUCENA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('ALARCON CARDENAS', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '9236', "first_name" => ucwords(mb_strtolower('GUSTAVO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('GUADARRAMA GURROLA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '9416', "first_name" => ucwords(mb_strtolower('TANIA MARCELA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('RAMIREZ GARCIA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '9447', "first_name" => ucwords(mb_strtolower('ADRIAN', 'UTF-8')), "last_name" => ucwords(mb_strtolower('ROMERO PLIEGO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '9501', "first_name" => ucwords(mb_strtolower('IVAN ELOY', 'UTF-8')), "last_name" => ucwords(mb_strtolower('GARCIA OLVERA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '9502', "first_name" => ucwords(mb_strtolower('JORGE', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MORENO RANGEL', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '9512', "first_name" => ucwords(mb_strtolower('ANAYAYELI', 'UTF-8')), "last_name" => ucwords(mb_strtolower('REYES QUINTERO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '9513', "first_name" => ucwords(mb_strtolower('CARMEN EUSEBIO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('LOPEZ TOVAR', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '9608', "first_name" => ucwords(mb_strtolower('GAEL MITZEL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('LOPEZ AYALA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '9671', "first_name" => ucwords(mb_strtolower('ORLANDO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('ARVIZU OCHARAN', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '9718', "first_name" => ucwords(mb_strtolower('MARIO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('JUAREZ VILLASEÑOR', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '9719', "first_name" => ucwords(mb_strtolower('AMPARO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MACIAS ARTEAGA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '9742', "first_name" => ucwords(mb_strtolower('ELIZABETH', 'UTF-8')), "last_name" => ucwords(mb_strtolower('AVILA ALFARO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '10578', "first_name" => ucwords(mb_strtolower('ISRAEL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('SANCHEZ VERGARA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '10579', "first_name" => ucwords(mb_strtolower('ALEJANDRO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('RODRIGUEZ TORRES', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '10806', "first_name" => ucwords(mb_strtolower('ALEJANDRO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('ZACARIAS BARROETA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '10861', "first_name" => ucwords(mb_strtolower('ELIZABETH', 'UTF-8')), "last_name" => ucwords(mb_strtolower('RAMIREZ PAZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '10886', "first_name" => ucwords(mb_strtolower('ARMANDO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('ESCAMILLA OLGUIN', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '10897', "first_name" => ucwords(mb_strtolower('LAURA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('GARCIA RODRIGUEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '10907', "first_name" => ucwords(mb_strtolower('DONACIANO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MARTINEZ BUSTAMANTE', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '10927', "first_name" => ucwords(mb_strtolower('ELIZABETH', 'UTF-8')), "last_name" => ucwords(mb_strtolower('CAMACHO JERONIMO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '10933', "first_name" => ucwords(mb_strtolower('ADOLFO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('PINTO SANTIAGO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '10935', "first_name" => ucwords(mb_strtolower('OMAR RAUL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('SOTO SOTO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '11099', "first_name" => ucwords(mb_strtolower('OMAR ANDRES', 'UTF-8')), "last_name" => ucwords(mb_strtolower('QUEZADA SOTELO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '11111', "first_name" => ucwords(mb_strtolower('AYARI', 'UTF-8')), "last_name" => ucwords(mb_strtolower('KURI ROJAS', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '11119', "first_name" => ucwords(mb_strtolower('OMAR', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MENDOZA TORRES', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '11120', "first_name" => ucwords(mb_strtolower('HUGO ALBERTO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('SANCHEZ HERNANDEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '11176', "first_name" => ucwords(mb_strtolower('ROGELIO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('PEREZ ARELLANO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 1]);
Employee::create(["no_emp" => '517', "first_name" => ucwords(mb_strtolower('EDUWIGES', 'UTF-8')), "last_name" => ucwords(mb_strtolower('VALDESPINO CAMACHO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 2]);
Employee::create(["no_emp" => '2058', "first_name" => ucwords(mb_strtolower('MARGARITA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('DELGADILLO VAZQUEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 2]);
Employee::create(["no_emp" => '5224', "first_name" => ucwords(mb_strtolower('ELOY', 'UTF-8')), "last_name" => ucwords(mb_strtolower('CASTILLO HERRERA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 2]);
Employee::create(["no_emp" => '6091', "first_name" => ucwords(mb_strtolower('RAMON GERARDO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('GOMEZ MENDOZA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 2]);
Employee::create(["no_emp" => '8016', "first_name" => ucwords(mb_strtolower('MONICA JACQUELINE', 'UTF-8')), "last_name" => ucwords(mb_strtolower('FERNANDEZ ACEVES', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 5, "syndicateID" => 2]);
//Mandos medios
Employee::create(["no_emp" => '2313', "first_name" => ucwords(mb_strtolower('MARIA ESTHER', 'UTF-8')), "last_name" => ucwords(mb_strtolower('RIOS ROQUE', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 2, "syndicateID" => 2]);
Employee::create(["no_emp" => '5336', "first_name" => ucwords(mb_strtolower('ALDO GAMALIEL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('GONZALEZ MUÑOZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 2, "syndicateID" => 2]);
Employee::create(["no_emp" => '2380', "first_name" => ucwords(mb_strtolower('RAUL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('CARMONA ANGELES', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 2, "syndicateID" => 1]);
Employee::create(["no_emp" => '4371', "first_name" => ucwords(mb_strtolower('SANDRA LUZ', 'UTF-8')), "last_name" => ucwords(mb_strtolower('CORDOVA MORENO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 2, "syndicateID" => 1]);
Employee::create(["no_emp" => '5245', "first_name" => ucwords(mb_strtolower('RAZIEL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MALDONADO VELAZQUEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 2, "syndicateID" => 1]);
Employee::create(["no_emp" => '10514', "first_name" => ucwords(mb_strtolower('MARTHA BEATRIZ', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MEDINA RAMIREZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 2, "syndicateID" => 1]);
//Servicio tecnico de carrera
Employee::create(["no_emp" => '1202', "first_name" => ucwords(mb_strtolower('LUIS', 'UTF-8')), "last_name" => ucwords(mb_strtolower('CRUZ JOSE', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '1204', "first_name" => ucwords(mb_strtolower('TOMAS', 'UTF-8')), "last_name" => ucwords(mb_strtolower('ROJAS GUZMAN', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '1230', "first_name" => ucwords(mb_strtolower('ALFREDO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('PANCARDO HERNANDEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '1354', "first_name" => ucwords(mb_strtolower('MARIA DE LA SALUD', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MORENO GARCIA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '1492', "first_name" => ucwords(mb_strtolower('VALENTINA SILVIA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('RUIZ RODRIGUEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '1505', "first_name" => ucwords(mb_strtolower('MARIA DEL CARMEN', 'UTF-8')), "last_name" => ucwords(mb_strtolower('GARAY TOVAR', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '1512', "first_name" => ucwords(mb_strtolower('MARIA LEONOR', 'UTF-8')), "last_name" => ucwords(mb_strtolower('PEÑA ISLAS', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '1514', "first_name" => ucwords(mb_strtolower('MARIA BEATRIZ', 'UTF-8')), "last_name" => ucwords(mb_strtolower('GARNICA MEJIA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '1517', "first_name" => ucwords(mb_strtolower('GLORIA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('RAMIREZ DE LUNA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '1663', "first_name" => ucwords(mb_strtolower('FRANCISCA MATILDE', 'UTF-8')), "last_name" => ucwords(mb_strtolower('RODRIGUEZ HERNANDEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '1792', "first_name" => ucwords(mb_strtolower('SERGIO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('VAZQUEZ MARTINEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '1842', "first_name" => ucwords(mb_strtolower('MARIO PEDRO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MARTINEZ ROCHA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '1985', "first_name" => ucwords(mb_strtolower('ALBERTO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('IBARRA COLIS', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '2042', "first_name" => ucwords(mb_strtolower('ANTONIO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MENESES GALLARDO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '2146', "first_name" => ucwords(mb_strtolower('ANDREA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('PRADO MONTIEL', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '2435', "first_name" => ucwords(mb_strtolower('ALEJANDRO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('CAMARGO NAVA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '2481', "first_name" => ucwords(mb_strtolower('MARTIN', 'UTF-8')), "last_name" => ucwords(mb_strtolower('HERNANDEZ RESENDIZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '2513', "first_name" => ucwords(mb_strtolower('MARIA DE LOS ANGELES', 'UTF-8')), "last_name" => ucwords(mb_strtolower('RAMIREZ ROMERO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '2559', "first_name" => ucwords(mb_strtolower('LAZARO ALVARO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('VENEGAS LEON', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '2680', "first_name" => ucwords(mb_strtolower('SERGIO ANTONIO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('LUNA TRUJILLO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '2774', "first_name" => ucwords(mb_strtolower('ALFONSO NICOLAS', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MEDINA GARCIA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '2784', "first_name" => ucwords(mb_strtolower('ALFREDO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('GONZALEZ VELEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '2785', "first_name" => ucwords(mb_strtolower('JESUS MANUEL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('GARCIA GALEOTE', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '2787', "first_name" => ucwords(mb_strtolower('ISRAEL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('PALMA AVALOS', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '2789', "first_name" => ucwords(mb_strtolower('JOSE CRUZ', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MAGDALENO OSNAYA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '2847', "first_name" => ucwords(mb_strtolower('JUAN GORGE', 'UTF-8')), "last_name" => ucwords(mb_strtolower('AVIÑA VALDEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '2904', "first_name" => ucwords(mb_strtolower('RAUL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('LOPEZ ORTIZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '2994', "first_name" => ucwords(mb_strtolower('MARTIN', 'UTF-8')), "last_name" => ucwords(mb_strtolower('TINAJERO CHAVEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '3006', "first_name" => ucwords(mb_strtolower('MARITZA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('SANCHEZ JARDINES', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '3011', "first_name" => ucwords(mb_strtolower('ALBERTO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('RUBIO CABELLO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '3091', "first_name" => ucwords(mb_strtolower('OSCAR ENRIQUE', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MENESES SUAREZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '3102', "first_name" => ucwords(mb_strtolower('JOSE GUADALUPE', 'UTF-8')), "last_name" => ucwords(mb_strtolower('CASTRO OLVERA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '3134', "first_name" => ucwords(mb_strtolower('MONICA MARISELA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('LARA PADILLA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '3146', "first_name" => ucwords(mb_strtolower('ROGELIO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('HERNANDEZ LEYVA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '3159', "first_name" => ucwords(mb_strtolower('JULIAN', 'UTF-8')), "last_name" => ucwords(mb_strtolower('HERNANDEZ RUIZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '3167', "first_name" => ucwords(mb_strtolower('DAVID', 'UTF-8')), "last_name" => ucwords(mb_strtolower('GOMEZ AGUILAR', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '3212', "first_name" => ucwords(mb_strtolower('FLORENCIO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('SALAZAR MOCTEZUMA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '3266', "first_name" => ucwords(mb_strtolower('MARIO ALBERTO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('GARCIA PIÑON', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '3320', "first_name" => ucwords(mb_strtolower('ALFONSO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('ZUÑIGA BERNAL', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '3321', "first_name" => ucwords(mb_strtolower('GUILLERMO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('GARCIA AVALOS', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '3387', "first_name" => ucwords(mb_strtolower('OSCAR', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MARTINEZ VELAZQUEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '3407', "first_name" => ucwords(mb_strtolower('RAFAEL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('GARCIA ALVAREZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '3445', "first_name" => ucwords(mb_strtolower('LILIANA PATRICIA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('HUITRON GUDIÑO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '3453', "first_name" => ucwords(mb_strtolower('MIGUEL ANGEL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('SANCHEZ TROCHEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '3568', "first_name" => ucwords(mb_strtolower('JULIO CESAR', 'UTF-8')), "last_name" => ucwords(mb_strtolower('HERNANDEZ GARCIA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '3573', "first_name" => ucwords(mb_strtolower('IVONNE', 'UTF-8')), "last_name" => ucwords(mb_strtolower('RAMIREZ BRAULIO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '3605', "first_name" => ucwords(mb_strtolower('GLORIA SATURNINA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('OSUNA MAYORQUIN', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '3666', "first_name" => ucwords(mb_strtolower('LUZ MARIA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('CANALES MEDELLIN', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '3679', "first_name" => ucwords(mb_strtolower('MARIA ANGELICA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('ALVAREZ CERON', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '3687', "first_name" => ucwords(mb_strtolower('ARTURO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('PEÑA HERNANDEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '3692', "first_name" => ucwords(mb_strtolower('ROCIO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('CONTRERAS SANCHEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '3850', "first_name" => ucwords(mb_strtolower('DENI', 'UTF-8')), "last_name" => ucwords(mb_strtolower('LOPEZ MUÑOZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '3869', "first_name" => ucwords(mb_strtolower('HEIDI', 'UTF-8')), "last_name" => ucwords(mb_strtolower('GUERRA ESPINOSA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '3870', "first_name" => ucwords(mb_strtolower('ISIDRO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('ALVAREZ CERON', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '3875', "first_name" => ucwords(mb_strtolower('MARIO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('ARIZCORRETA COLCHADO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '4291', "first_name" => ucwords(mb_strtolower('EMILIANO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MATEOS HERRERA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '4538', "first_name" => ucwords(mb_strtolower('ARACELI ERICA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MALDONADO PAQUE', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '4575', "first_name" => ucwords(mb_strtolower('NAYELI BERENICE', 'UTF-8')), "last_name" => ucwords(mb_strtolower('LEZAMA POZOS', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '4724', "first_name" => ucwords(mb_strtolower('QUIRINA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('PLASCENCIA GALINDO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '5183', "first_name" => ucwords(mb_strtolower('CARLOS ANTONIO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('RODRIGUEZ PEREZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '5294', "first_name" => ucwords(mb_strtolower('RAFAEL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('OCAÑA VAZQUEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '5373', "first_name" => ucwords(mb_strtolower('BARBARA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('GARCIA JEREZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '5448', "first_name" => ucwords(mb_strtolower('ELSA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('PEREZ ARELLANO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '5496', "first_name" => ucwords(mb_strtolower('VERONICA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('CERVANTES CORREA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '5499', "first_name" => ucwords(mb_strtolower('AURENTINO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('VALENCIA SOTO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '5531', "first_name" => ucwords(mb_strtolower('ANGEL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('ESPARZA URBINA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '5532', "first_name" => ucwords(mb_strtolower('JORGE', 'UTF-8')), "last_name" => ucwords(mb_strtolower('AVALOS FLORES', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '5683', "first_name" => ucwords(mb_strtolower('HECTOR', 'UTF-8')), "last_name" => ucwords(mb_strtolower('RIVERA LOPEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '5688', "first_name" => ucwords(mb_strtolower('MARTHA LUCIA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('ALONSO REYES', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '5788', "first_name" => ucwords(mb_strtolower('LAURA LIZBETH', 'UTF-8')), "last_name" => ucwords(mb_strtolower('JIMENEZ TRUJILLO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '5896', "first_name" => ucwords(mb_strtolower('LLUVIA TALIEZY', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MORALES DOMINGUEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '5898', "first_name" => ucwords(mb_strtolower('FRANCISCO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('FLORES GUTIERREZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '6060', "first_name" => ucwords(mb_strtolower('IVONNE', 'UTF-8')), "last_name" => ucwords(mb_strtolower('CORNEJO PEÑAFORT', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '6100', "first_name" => ucwords(mb_strtolower('GERARDO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('NAVARRO ALFARO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '6345', "first_name" => ucwords(mb_strtolower('ANGEL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('ECHAGARAY CANGAS', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '6697', "first_name" => ucwords(mb_strtolower('ALEJANDRA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('VELEZ OROZCO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '6698', "first_name" => ucwords(mb_strtolower('LIBERTAD AMERICA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('PACHECO CASTILLERO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '6979', "first_name" => ucwords(mb_strtolower('JOSE ALFONSO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('LARA MILLAN', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '6982', "first_name" => ucwords(mb_strtolower('ALMA FABIOLA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('GARCIA FLORES', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '7287', "first_name" => ucwords(mb_strtolower('WENDY', 'UTF-8')), "last_name" => ucwords(mb_strtolower('RODRIGUEZ CONTRERAS', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '7516', "first_name" => ucwords(mb_strtolower('CECILIA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('VARGAS DOMINGUEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '7518', "first_name" => ucwords(mb_strtolower('KARINA OFELIA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MEJIA RAYGOZA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '7741', "first_name" => ucwords(mb_strtolower('JOSE DE JESUS', 'UTF-8')), "last_name" => ucwords(mb_strtolower('ARANDA ONTIVEROS', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '7989', "first_name" => ucwords(mb_strtolower('ALEJANDRO EVARISTO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('CANALES BALTIERRA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '7991', "first_name" => ucwords(mb_strtolower('ANA MARIA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('VIDAL AVALOS', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '8065', "first_name" => ucwords(mb_strtolower('LIZBETH SARAI', 'UTF-8')), "last_name" => ucwords(mb_strtolower('OROZCO NOLASCO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '8277', "first_name" => ucwords(mb_strtolower('ELVIRA ANGELICA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('SOTO AVILA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '8287', "first_name" => ucwords(mb_strtolower('MARIA DE LA LUZ', 'UTF-8')), "last_name" => ucwords(mb_strtolower('OLVERA LOPEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '8358', "first_name" => ucwords(mb_strtolower('CHRISTIAN', 'UTF-8')), "last_name" => ucwords(mb_strtolower('SAAVEDRA CID', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '8527', "first_name" => ucwords(mb_strtolower('JORGE ALBERTO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('PEREZ SAUCEDO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '8574', "first_name" => ucwords(mb_strtolower('NORMA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('FRANCISCO PEREZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '8800', "first_name" => ucwords(mb_strtolower('DIANA CONCEPCION', 'UTF-8')), "last_name" => ucwords(mb_strtolower('TREJO LOPEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '8913', "first_name" => ucwords(mb_strtolower('JOSUE', 'UTF-8')), "last_name" => ucwords(mb_strtolower('ARRONA MARTINEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '9088', "first_name" => ucwords(mb_strtolower('LUIS EDUARDO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('LARA GONZALEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '9098', "first_name" => ucwords(mb_strtolower('FIDELINA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('RAMIREZ AVELINO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '9106', "first_name" => ucwords(mb_strtolower('LILIAN ELIZABETH', 'UTF-8')), "last_name" => ucwords(mb_strtolower('HERNANDEZ LOHSE', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '9111', "first_name" => ucwords(mb_strtolower('EDUARDO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('LEON ZUÑIGA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '9297', "first_name" => ucwords(mb_strtolower('MIGUEL ANGEL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MUÑOZ VILLANUEVA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '9402', "first_name" => ucwords(mb_strtolower('DIANA ERANDI', 'UTF-8')), "last_name" => ucwords(mb_strtolower('ARENAS DIAZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '9403', "first_name" => ucwords(mb_strtolower('FABIOLA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MARTINEZ MOSQUEDA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '9469', "first_name" => ucwords(mb_strtolower('ARTURO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('ALBARRAN CUEVAS', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '9471', "first_name" => ucwords(mb_strtolower('RAUL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('HERNANDEZ GUTIERREZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '9475', "first_name" => ucwords(mb_strtolower('CRISTOPHER ABRAHAM', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MENDOZA ARREOLA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '9487', "first_name" => ucwords(mb_strtolower('DAVID', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MONROY BARRERA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '9546', "first_name" => ucwords(mb_strtolower('BRENDA ESTHER', 'UTF-8')), "last_name" => ucwords(mb_strtolower('RODRIGUEZ PATIÑO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '9642', "first_name" => ucwords(mb_strtolower('CARLOS', 'UTF-8')), "last_name" => ucwords(mb_strtolower('RODRIGUEZ MORENO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '9773', "first_name" => ucwords(mb_strtolower('DOMINGO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('HERNANDEZ BAUTISTA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '10001', "first_name" => ucwords(mb_strtolower('NICACIO GUILLERMO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('REYES JIMENEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '10005', "first_name" => ucwords(mb_strtolower('JOSE ALFREDO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('JIMENEZ JIMENEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '10006', "first_name" => ucwords(mb_strtolower('JUAN ANTONIO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MARTINEZ SAN JUAN', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '10008', "first_name" => ucwords(mb_strtolower('FRANCISCO JORGE', 'UTF-8')), "last_name" => ucwords(mb_strtolower('SANCHEZ PEÑAFLOR', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '10009', "first_name" => ucwords(mb_strtolower('RAMON', 'UTF-8')), "last_name" => ucwords(mb_strtolower('FLORES RANGEL', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '10010', "first_name" => ucwords(mb_strtolower('SALVADOR', 'UTF-8')), "last_name" => ucwords(mb_strtolower('MONTES DOMINGUEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '10274', "first_name" => ucwords(mb_strtolower('RAFAEL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('ALVA NIEVES', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 1]);
Employee::create(["no_emp" => '1084', "first_name" => ucwords(mb_strtolower('JESUS', 'UTF-8')), "last_name" => ucwords(mb_strtolower('OLMEDO SANCHEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 2]);
Employee::create(["no_emp" => '1159', "first_name" => ucwords(mb_strtolower('JUAN MANUEL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('HERNANDEZ ESPINOZA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 2]);
Employee::create(["no_emp" => '1857', "first_name" => ucwords(mb_strtolower('GRACIELA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('LUGO GARCIA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 2]);
Employee::create(["no_emp" => '2480', "first_name" => ucwords(mb_strtolower('ALMA ROSA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('LUNA MARTINEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 2]);
Employee::create(["no_emp" => '2599', "first_name" => ucwords(mb_strtolower('RICARDO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('RICARDO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 2]);
Employee::create(["no_emp" => '2853', "first_name" => ucwords(mb_strtolower('NORMA ANGELICA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('CARDONA HERNANDEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 2]);
Employee::create(["no_emp" => '3156', "first_name" => ucwords(mb_strtolower('MIRIAM', 'UTF-8')), "last_name" => ucwords(mb_strtolower('RIVERA ULLOA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 2]);
Employee::create(["no_emp" => '3157', "first_name" => ucwords(mb_strtolower('SERGIO ENRIQUE', 'UTF-8')), "last_name" => ucwords(mb_strtolower('ALVAREZ NUÑEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 2]);
Employee::create(["no_emp" => '3828', "first_name" => ucwords(mb_strtolower('RICARDO', 'UTF-8')), "last_name" => ucwords(mb_strtolower('ROCHA RODRIGUEZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 2]);
Employee::create(["no_emp" => '4448', "first_name" => ucwords(mb_strtolower('ROSA LAURA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('AQUINO SUMANO', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 2]);
Employee::create(["no_emp" => '5187', "first_name" => ucwords(mb_strtolower('BERNARDO ISRAEL', 'UTF-8')), "last_name" => ucwords(mb_strtolower('GARCIA CASTAÑEDA ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 2]);
Employee::create(["no_emp" => '5414', "first_name" => ucwords(mb_strtolower('PATRICIA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('ROSALES CRUZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 2]);
Employee::create(["no_emp" => '5433', "first_name" => ucwords(mb_strtolower('JEANETTE', 'UTF-8')), "last_name" => ucwords(mb_strtolower('TAVIRA CABRERA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 2]);
Employee::create(["no_emp" => '5709', "first_name" => ucwords(mb_strtolower('IRENE ANA', 'UTF-8')), "last_name" => ucwords(mb_strtolower('LARIS ORTIZ', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 2]);
Employee::create(["no_emp" => '7517', "first_name" => ucwords(mb_strtolower('JOSE LUIS', 'UTF-8')), "last_name" => ucwords(mb_strtolower('LARIOS GALICIA', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 2]);
Employee::create(["no_emp" => '8161', "first_name" => ucwords(mb_strtolower('RUBI', 'UTF-8')), "last_name" => ucwords(mb_strtolower('REYES RIVAS', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 4, "syndicateID" => 2]);
//Base
Employee::create(["no_emp" => '', "first_name" => ucwords(mb_strtolower('', 'UTF-8')), "last_name" => ucwords(mb_strtolower('', 'UTF-8')), "gender" => "f", "status" => 1, "payrollID" => 3, "syndicateID" => 1]);
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(EmployeeRequest $request)
{
Employee::create($request->all());
return redirect('employee');
}
public function importEMP($destfile)
{
Excel::load($destfile, function ($reader) {
$rules = ['number' => 'required|unique:employees', 'company_id' => 'required|exists:companies,id', 'department_id' => 'required|exists:departments,id', 'bank_account' => 'required|unique:employees'];
$sheetsCount = $reader->getSheetCount();
for ($i = 0; $i < $sheetsCount; $i++) {
$sheets = $reader->getSheet($i)->toArray();
$company_name = $reader->getSheet($i)->getTitle();
$dept['company_id'] = Company::where('name', $company_name)->value('id');
$sheetCount = count($sheets);
for ($j = 6; $j < $sheetCount; $j++) {
// Get Department ID;
$dept['name'] = $sheets[$j][1];
$dept['costcenter'] = $sheets[$j][10];
$employee['company_id'] = $dept['company_id'];
$employee['department_id'] = Department::where('name', $dept['name'])->where('company_id', $dept['company_id'])->where('costcenter', $dept['costcenter'])->value('id');
$employee['name'] = $sheets[$j][2];
$employee['number'] = $sheets[$j][3];
$employee['level_id'] = Level::where('credit', 400)->value('id');
$employee['category_id'] = Category::where('code', 1)->value('id');
$employee['status_id'] = Status::where('code', 1)->value('id');
$employee['telephone'] = $sheets[$j][4];
$employee['bank_account'] = $sheets[$j][8];
$emp_v = \Validator::make($employee, $rules);
if ($emp_v->fails()) {
} else {
Employee::create($employee);
}
}
}
//END
});
}
public function store(Request $request)
{
return $employee = Employee::create($request::all());
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store()
{
$employee = Request::all();
Employee::create($employee);
return redirect('employees');
}
