public function __construct()
{
try {
$this->db = DB::init()->connect();
} catch (Exception $ex) {
$ex->getMessage();
}
}
private function savePsychosocialSupportToDB($request, $benefiterId)
{
if ($request['psychosocial_statuses'] != null) {
$psychosocialStatuses = $request['psychosocial_statuses'];
foreach ($psychosocialStatuses as $psychosocialStatus) {
\DB::table('benefiters_psychosocial_support')->insert($this->getPsychosocialSupportArrayForDBInsert($psychosocialStatus, $benefiterId));
}
}
}
public function __construct()
{
$this->greekStringConversion = new GreekStringConversionHelper();
$this->genders = \DB::table('genders_lookup')->get();
$this->allCountryAbandonReasons = \DB::table('country_abandon_reasons_lookup')->get();
$this->countryList = \DB::table('countries_lookup')->get();
$this->marital_statuses = \DB::table('marital_status_lookup')->get();
$this->educations = \DB::table('education_lookup')->get();
$this->binaryYesNo = \DB::table('binary_lookup')->get();
$this->workTitles = \DB::table('work_title_list_lookup')->get();
return $this->genders;
}
public function update($input)
{
foreach ($input as $id => $value) {
$data['sent_at'] = DB::raw('NOW()');
if ($value == 1) {
$this->invite->update($id, $data);
$invite = $this->inviteService->get($id);
$emaildata['code'] = $invite->code;
$emaildata['email'] = $invite->email;
$this->mailService->sendInvite($emaildata);
}
}
return true;
}
/**
* Create a new user instance after a valid registration.
*
* @param array $data
* @return User
*/
public function create(array $data)
{
$data['email'] = strtolower($data['email']);
$data['name'] = strtolower($data['name']);
$date = new \DateTime();
\DB::insert('insert into users_data (name, email, avatar, gender, full_name, bio, department, created_at, updated_at) values (?, ?, ?, ?, ?, ?, ?, ?, ?)', [$data['name'], $data['email'], '0', $data['gender'], $data['full_name'], '0', $data['department'], $date, $date]);
\Schema::create('notification.inbox_' . $data['name'], function ($table) {
$table->text('n_message', 500);
$table->string('n_link');
$table->string('n_sender');
$table->boolean('n_read');
$table->timestamps();
});
return User::create(['name' => $data['name'], 'email' => $data['email'], 'password' => bcrypt($data['password'])]);
}
protected function checkRolesForAction($action)
{
$reqRoles = $this->requiredRoles();
$alterRegRoles = [];
if ($reqRoles) {
foreach ($reqRoles as $key => $value) {
$alterRegRoles[strtolower($key . 'Action')] = $value;
}
if (array_key_exists($action = strtolower($action), $alterRegRoles)) {
$roles = $alterRegRoles[$action];
if (Session::get('user_id')) {
$user = PrivilegedUser::getUserRoleById(DB::init()->connect(), Session::get('user_id'));
} else {
$user = ['role_id' => 5, 'role_name' => 'Guest'];
}
return in_array($user['role_id'], $roles);
}
}
return TRUE;
}
public function createdb($dbname)
{
$prefix = 'laraapp_';
$dbname = $prefix . $dbname;
DB::statement('CREATE DATABASE IF NOT EXISTS ' . $dbname);
configureConnectionByName($dbname, 'root', 'root');
if (!Schema::hasTable('customer')) {
Schema::create('customer', function ($t) {
// auto increment id (primary key)
$t->increments('id');
$t->string('name');
$t->integer('age')->nullable();
$t->boolean('active')->default(1);
$t->integer('role_id')->unsigned();
$t->text('bio');
// created_at, updated_at DATETIME
$t->timestamps();
});
}
}
/**
* Insert new Match
*
* @param array $data
* @return Participant
*/
public function create_match(array $data)
{
$players = Player::select('player_id', 'first_name', 'last_name', \DB::raw('CONCAT(first_name, " ", last_name) as full_name'))->lists('player_id', 'full_name');
//check to see if players exist in Players table
$err = '';
if (!array_key_exists($data['player1'], $players)) {
$err .= ' Not in Players table: ' . $data['player1'];
}
if (!array_key_exists($data['player2'], $players)) {
$err .= ' Not in Players table: ' . $data['player2'];
}
if ($err == '') {
$player1_id = $players[$data['player1']];
$player2_id = $players[$data['player2']];
$match = \DB::table('matches')->where('tournament_id', '=', $data['tournament_id'])->where('player1_id', '=', $player1_id)->where('player2_id', '=', $player2_id)->first();
if (is_null($match)) {
$match = Match::create(['player1_id' => $player1_id, 'player2_id' => $player2_id, 'winner_id' => $player1_id, 'tournament_id' => $data['tournament_id'], 'match_date' => $data['match_date'], 'match_type' => $data['match_type'], 'match_division' => $data['match_division']]);
}
}
}
public function editUserAction()
{
$fc = FrontController::getInstance();
$model = new AdminModel('Редактирование пользователя');
$userModel = new UserUpdateTableModel();
$userModel->setTable('user');
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$userModel->setData('userUpdate');
$userModel->updateRecord();
header('Location: /admin/profile/id/' . $userModel->getId());
exit;
} else {
$id = filter_var($fc->getParams()['id'], FILTER_SANITIZE_NUMBER_INT);
if (!$id) {
header('Location: /admin/notFound');
exit;
}
$userModel->setId($id);
$user = [];
$db = DB::init()->connect();
$userModel->readRecordsById();
$userModel->readUserAddress();
$userModel->readUserPhones();
$roles = PrivilegedUser::getUserRoleById($db, $id);
$model->setData(['profile' => $userModel->getRecordsById(), 'contacts' => $userModel->getUserContacts(), 'role' => $roles, 'allRoles' => Role::getRoles($db), 'perms' => Role::getRolePerms($db, $roles['role_id'])->getPermissions()]);
}
$output = $model->render('../views/admin/user/editUser.php', 'admin');
$fc->setPage($output);
}
/**
* Determines if we have a DB connection.
*
* @return boolean
*/
public function hasDB()
{
if (!isset($this->db)) {
try {
$this->db = !!\DB::connection()->getDatabaseName();
} catch (\Exception $e) {
$this->db = false;
}
}
return $this->db;
}
function __construct()
{
$this->db = DB::init()->connect();
}
private function getAllBenefitersForCsvFileDownload()
{
$queryString = "select b.*, gl.gender, msl.marital_status_title, el.education_title, wll.description " . "as legal_working_status, wtll.work_title, " . "carl.description as country_abandon_reason from benefiters as b " . "left join benefiters_legal_status as bls on b.id = bls.benefiter_id left join genders_lookup as gl " . "on b.gender_id = gl.id left join marital_status_lookup as msl on b.marital_status_id = msl.id " . "left join education_lookup as el on b.education_id = el.id left join working_legally_lookup as wll " . "on b.working_legally = wll.id left join work_title_list_lookup as wtll on b.work_title_id = wtll.id " . "left join country_abandon_reasons_lookup as carl on b.country_abandon_reason_id = carl.id " . "where deleted_at is null group by b.id";
return \DB::select(\DB::raw($queryString));
}
/**
* To add ticker owener or joinee to push subscribed users
* @param int $userId
* @param int $tickerId
* @param array $pushSubscribers
* @return array $pushSubscribers
*/
public static function getTickerOwnerOrJoinee($userId, $tickerId, $pushSubscribers)
{
$sql = \app\models\TickerInvities::where('ticker_id', '=', $tickerId)->where('status', '=', \DB::Raw(1));
$tickerInvityData = $sql->get()->first();
$id = 0;
if (!empty($tickerInvityData)) {
if ($tickerInvityData->requester_id == $userId) {
$id = $tickerInvityData->invited_user_id;
} else {
$id = $tickerInvityData->requester_id;
}
$pushSubscribers[] = $id;
}
$pushSubscribers = array_unique($pushSubscribers);
return $pushSubscribers;
}
public function getReportDataForRegisteredBenefiters()
{
try {
// get benefiter registration number for any particular month.
$benefitersCount = \DB::select(\DB::raw("select date_format(created_at, '%Y-%m') as created_at, count(id) as idcounter from benefiters group by date_format(created_at, '%Y %m')"));
// $benefitersCount = \DB::select(\DB::raw("select created_at, count(id) as idcounter from benefiters group by year(created_at), month(created_at)"));
} catch (\Exception $e) {
Log::error("A problem occured while trying to count the users based on registration date.\n" . $e);
return null;
}
Log::info("Returning result with users based on their registration date.");
return $benefitersCount;
}
public function createRole(array $data)
{
$getid = \DB::table('users')->where('email', '=', $data['correo_electronico'])->where('user_login', '=', $data['nombre_usuario'])->where('num_identificacion', '=', $data['numero_identificacion'])->first();
return RolesUsers::create(['user_id' => $getid->id, 'role_id' => $data['rol_usuario']]);
}
private function findLegalStatusIdFromName($legal_status)
{
// if $__legalStatuses is empty, then fill it with normalized legal statuses from DB...
if (empty($this->__legalStatuses)) {
$allLegalStatuses = \DB::table('legal_status_lookup')->get();
foreach ($allLegalStatuses as $legalStatus) {
$this->__legalStatuses[$legalStatus->id] = $this->greekStringConversion->grstrtoupper($legalStatus->description);
}
}
// ...else use the existent array
// normalize $legal_status
$tmp = $this->greekStringConversion->grstrtoupper($legal_status);
$id = array_search($tmp, $this->__legalStatuses);
// if legal status was not found in $legalStatuses array
// return null
if (!$id) {
$id = null;
}
return $id;
}
private function getDoctorIdFromName($doctorName)
{
$tmp = \DB::select(\DB::raw('select id from users where (user_role_id = 1 or user_role_id = 2) and (lastname like "%' . $doctorName . '%" or name like "%' . $doctorName . '%")'));
if ($tmp != null) {
Log::info("Returning the doctors ids.");
return $tmp;
} else {
Log::error("Couldn't find the doctor's id");
return null;
}
}
protected function __construct()
{
$this->db = DB::init()->connect();
$this->permissions = array();
}
public function getPermsByRoleIdAction()
{
header('Content-type: application/json; charset=utf-8');
header('Cache-Control: no-store, no-cache');
header('Expires: ' . date('r'));
if (filter_has_var(INPUT_GET, 'id')) {
$id = filter_input(INPUT_GET, 'id', FILTER_SANITIZE_NUMBER_INT);
} else {
throw new Exception('Не удалось получить id роли');
}
$perms = Role::getRolePerms(DB::init()->connect(), $id)->getPermissions();
echo json_encode($perms);
}
private function findLawyerActionsFromLegalSessionId($legalSessionId)
{
return \DB::table('legal_lawyer_action')->where('legal_session_id', '=', $legalSessionId)->get();
}
public function processWorkTime($emp_mx_id, $punch_date)
{
$total_work_time = 0;
$in_times = [];
$out_times = [];
$difference = 0;
$total_out_time = 0;
$total_work_time = \DB::select(" SELECT\n TIMESTAMPDIFF(MINUTE, MIN(punch_trg_datetime), MAX(punch_trg_datetime)) total_time\n FROM tik_tok_attendance\n WHERE emp_mx_id = '{$emp_mx_id}' AND\n punch_trg_date = '{$punch_date}' AND DATE_FORMAT(punch_trg_datetime , '%H') >= 8 ;\n ")[0]->total_time;
//Latha and Alex
if ($emp_mx_id != 'MX057' || $emp_mx_id != 'MX076') {
$all_in_time_array = \DB::select("SELECT punch_trg_datetime FROM tik_tok_attendance WHERE punch_trg_date = '{$punch_date}' AND emp_mx_id = '{$emp_mx_id}' AND punch_type = 'In' AND DATE_FORMAT(punch_trg_datetime , '%H') >= 8 ORDER BY punch_trg_datetime,punch_trg_id ASC ;");
$all_out_time_array = \DB::select("SELECT punch_trg_datetime FROM tik_tok_attendance WHERE punch_trg_date = '{$punch_date}' AND emp_mx_id = '{$emp_mx_id}' AND punch_type = 'Out' AND DATE_FORMAT(punch_trg_datetime , '%H') >= 8 ORDER BY punch_trg_datetime,punch_trg_id ASC ;");
foreach ($all_in_time_array as $all_in_time_array_item) {
$in_times[] = $all_in_time_array_item->punch_trg_datetime;
}
foreach ($all_out_time_array as $all_out_time_array_item) {
$out_times[] = $all_out_time_array_item->punch_trg_datetime;
}
$in_time_count = count($in_times);
$out_time_count = count($out_times);
if ($in_time_count == $out_time_count) {
foreach ($out_times as $key => $out_time_value) {
if (!empty($in_times[$key + 1])) {
$num_temp = $key + 1;
$difference = \DB::connection('mysql_dummy')->select(" SELECT TIMESTAMPDIFF(MINUTE, '{$in_times[$num_temp]}', '{$out_time_value}' ) difference ; ")[0];
$total_work_time += $difference->difference;
$total_out_time += abs($difference->difference);
}
}
} else {
if ($in_time_count > $out_time_count) {
$evaluate_date = new \DateTime($in_times[$in_time_count - 1]);
$num_temp = $in_time_count - 1;
if (intval($evaluate_date->format('H')) < 19) {
}
$difference = \DB::connection('mysql_dummy')->select(" SELECT TIMESTAMPDIFF(MINUTE, '{$in_times[$num_temp]}', '{$punch_date} 19:30:00' ) difference ; ")[0];
$total_work_time += $difference->difference;
}
}
}
return "{$total_work_time},{$total_out_time}";
}
/**
* Create contributor and connect to book.
* @param [int] $book_id Id of book.
* @param [type] $data [description]
* @param [type] $avatar [description]
* @return [type] [description]
*/
public function createContributorAndConnectBook($book_id, $data, $avatar)
{
$user = $this->model->create(['lastname' => $data['name'], 'blurb' => $data['blurb'], 'email' => $data['email'], 'twitter_id' => $data['twitter_id'], 'github' => $data['github'], 'avatar' => $avatar]);
DB::table('book_author')->insert(['author_id' => $user->id, 'book_id' => $book_id, 'is_main' => 2, 'royalty' => 0, 'is_accepted' => 1, 'message' => '']);
}
private function getAllReferrals()
{
return \DB::table('benefiter_referrals_lookup')->get();
}
