/** * Run the database seeds. * * @return void */ public function run() { DB::table('employees')->delete(); $db = App::make('AccessDB'); $query = new Query('USERINFO', $db->get_dbh()); $query->order('USERID'); $result = $query->get('USERID,SSN,Name,Gender,BIRTHDAY,street,DEFAULTDEPTID'); $result_array = []; foreach ($result as $row) { $result_array[] = ['id' => $row['USERID'], 'ssn' => $row['SSN'], 'name' => $row['Name'], 'is_male' => $row['Gender'] == 'Male' ? 1 : 0, 'birthday' => $row['BIRTHDAY'], 'street' => $row['street'], 'department_id' => $row['DEFAULTDEPTID']]; } $employee = array_chunk($result_array, 1000); foreach ($employee as $value) { Employee::insert($value); } $convert_file = public_path() . '\\Last Convert.txt'; $record = explode(';', file_get_contents($convert_file)); $record[7] = $result[count($result) - 1]['USERID']; $file = fopen($convert_file, 'w'); fwrite($file, implode(';', $record)); fclose($file); }
include 'templates/header.php'; include 'templates/navbar.php'; // FORM SUBMISSION $alert = array(); if (isset($_POST['submit'])) { $new_user = new User(); $_POST['password'] = md5($_POST['password']); $new_user->instantiate($_POST); if (!$new_user->insert()) { $alert['error'] = '<b>Sorry!</b> New user could not be added because the <b>username/email</b> has already been used!'; } else { if (strtolower($new_user->permission) == 'employee') { $employee = new Employee(); $employee->user_id = $new_user->id; $employee->validity = $_POST['validity']; $employee->insert(); } $alert['success'] = '<b>Okay!</b> The new user has been successfully added!'; } } ?> <?php // SETTING PARAMETERS FOR SIDEBAR $header = 'accounts'; $page = 'add'; include 'templates/sidebar.php'; ?> <div class="row" style="margin-right: 0"> <div class="col-md-6 col-md-offset-3 page-wrapper"> <h2>Add New Account</h2>
if (isset($_GET['page'])) { switch ($_GET['page']) { case 'list': $employees = $class_employee->getAll(); include 'views/list.php'; break; case 'view': $id = $_GET['id']; $employee = $class_employee->getOne($id); include 'views/view.php'; break; case 'parse': $files = glob('uploads/*.pdf', GLOB_NOSORT); array_multisort(array_map('filemtime', $files), SORT_NUMERIC, SORT_DESC, $files); $file = array_shift($files); $names = get_names_from_pdf($file); echo count($names); foreach ($names as $name => $point) { $class_employee->insert($name); } break; case 'upload': include 'up1.php'; break; default: include 'home.php'; } } else { include 'home.php'; } include 'footer.php';
public function create() { Employee::insert(); require_once 'views/home_view.php'; }