public static function selectID($workerId, $expoId, $day = NULL)
{
try {
// Create the query
$select_query = "SELECT DISTINCT workerid, expoid, day,";
for ($i = 1; $i <= NUMBER_HOURS; $i++) {
$select_query .= " hour" . $i . ",";
}
$select_query = rtrim($select_query, ',');
$select_query .= " FROM newtimepreference WHERE workerid = ? AND expoid = ?";
if (!is_null($day)) {
$select_query .= " AND day = ?";
}
// Create the input array
$select_array = array($workerId, $expoId);
if (!is_null($day)) {
array_push($select_array, $day);
}
// Execute the query
$rows = simpleSelect("NewTimePreference", $select_query, $select_array);
return $rows;
} catch (PDOException $pe) {
logMessage('NewTimePreference::selectID(' . $workerId . ', ' . $expoId . ')', $pe->getMessage());
}
}
public static function selectWorker($expoId, $workerId)
{
try {
return simpleSelect("ShiftPreference", SHIFTPREF_SELECT_WORKER, array($expoId, $workerId));
} catch (PDOException $pe) {
logMessage('ShiftPreference::selectWorker(' . $expoId . ', ' . $workerId . ')', $pe->getMessage());
}
}
public static function selectWorker($expoId, $workerId)
{
try {
$rows = simpleSelect("ShiftAssignment", SHIFTASSIGNMENT_SELECT_WORKER, array($expoId, $workerId));
return $rows;
} catch (PDOException $pe) {
logMessage('ShiftAssignment::selectWorker(' . $expoId . ' ' . $workerId . ')', $pe->getMessage());
}
}
public function templates($departments)
{
foreach ($departments as $department) {
if (!isset($this->data['templates'][$department->id])) {
$this->data['templates'][$department->id] = simpleSelect(EmailTemplate::where('system', 1)->where('department_id', $department->id)->get(), true);
}
}
return $this->data['templates'];
}
public static function selectExpo($expoId)
{
try {
$rows = simpleSelect("JobTitle", JOBTITLE_SELECT_EXPO, array($expoId));
return $rows;
} catch (PDOException $pe) {
logMessage('JobTitle::selectExpo(' . $expoId . ')', $pe->getMessage());
}
return array();
}
private static function select($sql, $params)
{
try {
$rows = simpleSelect("ShiftAssignmentView", $sql, $params);
foreach ($rows as $row) {
$row->fixDates();
}
return $rows;
} catch (PDOException $pe) {
logMessage('ShiftAssignmentView::select(' . $sql . ', ' . var_export($params, true) . ')', $pe->getMessage());
}
}
public static function selectID($workerId)
{
try {
$rows = simpleSelect("TimePreference", SHIFT_SELECT, array($workerId));
if (1 != count($rows)) {
return NULL;
}
return $rows[0];
} catch (PDOException $pe) {
logMessage('TimePreference::selectID(' . $workerId . ')', $pe->getMessage());
}
}
public function __construct()
{
$this->middleware('departmentAccess:5');
$this->middleware('adminDepartmentObject:User', ['only' => ['edit', 'update', 'delete']]);
$departments = [];
$this->systemAdmin = false;
if (systemAccess(100)) {
$this->systemAdmin = true;
$departments = getNomenclatureSelect($this->getDepartmentsAdmin(), true);
}
view()->share(['systemAdmin' => $this->systemAdmin, 'departments' => $departments, 'types' => simpleSelect($this->getUserTypes(true), true, 'title')]);
}
public static function selectWorker($workerId)
{
try {
$rows = simpleSelect("Expo", EXPO_SELECT_WORKER, array($workerId));
for ($k = 0; $k < count($rows); $k++) {
$rows[$k]->fixDates();
}
// $k
return $rows;
} catch (PDOException $pe) {
logMessage('Expo::selectWorker(' . $workerId . ')', $pe->getMessage());
}
}
public static function selectDate($date)
{
try {
$rows = simpleSelect("ReminderSent", REMINDERSEND_SELECT, array($date));
if (0 < count($rows)) {
return true;
} else {
return false;
}
} catch (PDOException $pe) {
logMessage('ReminderSent::selectID(' . $date . ')', $pe->getMessage());
}
}
public static function selectWorker($workerId)
{
self::deleteBulk(NULL, NULL);
// clear garbage
try {
$rows = simpleSelect("Invitation", INVITATION_SELECT_WORKER, array($workerId, $workerId));
for ($k = 0; $k < count($rows); $k++) {
$rows[$k]->fixDates();
}
// $k
return $rows;
} catch (PDOException $pe) {
logMessage("Invitation::selectWorker({$workerId})", $pe->getMessage());
}
}
function getCat($where)
{
$result = simpleSelect($GLOBALS['select'], $GLOBALS['tableName'], NULL, NULL, $where, NULL, NULL, $GLOBALS['conn']);
$data = array();
if (is_null($result)) {
return NULL;
} else {
while ($row = $result->fetch_assoc()) {
$subCats = getCat("parentid = '" . $row['id'] . "'");
if ($subCats) {
$data[] = array_merge($row, array("subCategories" => $subCats));
} else {
$data[] = $row;
}
}
return $data;
}
}
public static function selectID($workerId, $expoId)
{
try {
// Create the query
$select_query = "SELECT DISTINCT workerid, expoid, ";
for ($i = 1; $i <= NUMBER_JOBS; $i++) {
$select_query .= " job" . $i . ",";
}
$select_query = rtrim($select_query, ",");
$select_query .= " FROM jobpreference WHERE workerid = ? AND expoid = ?";
// Execute the query
$rows = simpleSelect("JobPreference", $select_query, array($workerId, $expoId));
if (1 != count($rows)) {
return NULL;
}
return $rows[0];
} catch (PDOException $pe) {
logMessage('JobPreference::selectID(' . $workerId . ', ' . $expoId . ')', $pe->getMessage());
}
}
if (!isset($_POST["email"])) {
$statusMessage = makeStatusMessage(2, "error", "Incomplete query request...");
return;
}
$conn = sqlConnectDefault();
if (is_null($conn)) {
$statusMessage = makeStatusMessage(6, "error", "Could not connect to database!");
return;
}
$select = "u.id as uid, i.id as iid";
$tableName = array("user_info as i", "users as u");
$joinTypes = array("RIGHT OUTER JOIN");
$joins = array("u.id = i.userid");
$where = "u.email='" . $_POST["email"] . "'";
$result = simpleSelect($select, $tableName, $joinTypes, $joins, $where, NULL, NULL, $conn);
if (is_null($result)) {
$statusMessage = makeStatusMessage(14, "error", "Error getting data from database...");
mysql_close($conn);
return;
}
if ($result->num_rows > 1) {
$statusMessage = makeStatusMessage(13, "error", "Multiple results for this user...");
mysql_close($conn);
return;
}
$row = $result->fetch_assoc();
if (is_null($row['iid'])) {
$cols = "userid";
$data = "'" . $row['uid'] . "'";
$columns = array("fname", "lname", "firm", "address", "city", "country", "phone");
/**
* Show the form for editing the specified resource.
*
* @param Paper $paper
* @return \Illuminate\Http\Response
*/
public function edit(Paper $paper)
{
return view('admin.paper.edit', ['paper' => $paper, 'force' => true, 'authors' => simpleSelect(User::getAuthors($paper->department_id), true), 'reviewers' => simpleSelect(User::getReviewers($paper->department_id, $paper->category_id), true), 'categories' => getNomenclatureSelect($this->getCategories($paper->department_id), true)]);
}
$joinTypes = array("JOIN", "JOIN");
$joins = array("userid = u.id", "categoryid = c.id");
$where = "categoryid != 0";
$result = simpleSelect($select, $tableNames, $joinTypes, $joins, $where, NULL, NULL, $conn);
if (is_null($result)) {
$statusMessage = makeStatusMessage(1234, "error", "No discounts.");
mysqli_close($conn);
return;
}
$select = array("name" . $language . " as product");
//MUST FIX
while ($row = $result->fetch_assoc()) {
if ($row['productid'] != 0) {
$tableNames = array("products");
$where = "id = '" . $row['productid'] . "'";
$res = simpleSelect($select, $tableNames, NULL, NULL, $where, NULL, NULL, $conn);
echo mysqli_error($conn);
if (is_null($res)) {
$statusMessage = makeStatusMessage(345, "error", "Error with getting information on product.");
mysqli_close($conn);
return;
}
$tmparr = $res->fetch_assoc();
$discounts[] = array_merge($row, $tmparr);
} else {
$discounts[] = array_merge($row, array("product" => "*"));
}
}
$data = $discounts;
$statusMessage = makeStatusMessage(234, "succes", "Information gathered");
} else {
public static function WorkerStationHours($workerid, $stationid, $expoid)
{
try {
$rows = simpleSelect("ShiftStatus", SHIFTSTATUS_SELECT_STATUS_ASC, array($workerid, $stationid, $expoid));
if (!count($rows) == 0) {
$hours = 0;
for ($k = 0; $k < count($rows); $k++) {
if ($rows[$k]->statusType == 'CHECK_OUT') {
if (isset($rows[$k - 1]) && $rows[$k - 1]->statusType == 'CHECK_IN') {
$start = swwat_parse_datetime($rows[$k - 1]->statusTime);
$stop = swwat_parse_datetime($rows[$k]->statusTime);
$diff = $start->diff($stop);
$hours += $diff->d * 24 + $diff->h + $diff->i / 60 + $diff->s / 360;
}
}
}
return $hours;
} else {
return 0;
}
} catch (PDOException $pe) {
logMessage('ShiftStatus::WorkerStationHours(' . $workerid . ', ' . $stationid . ', ' . $expoid . ')', $pe->getMessage());
}
}
<?php
$conn = sqlConnectDefault();
if (is_null($conn)) {
$statusMessage = makeStatusMessage(6, "error", "Could not connect to database!");
return;
}
$result = getLanguages($conn);
if (is_null($result)) {
$statusMessage = makeStatusMessage(324, "error", "Could not get language information.");
} else {
$select = array("id");
while ($row = $result->fetch_assoc()) {
$select[] = "name" . $row['abreviation'];
$select[] = "desc" . $row['abreviation'];
}
$select[] = "searchable";
$tableName = array("properties");
$result = simpleSelect($select, $tableName, null, null, null, NULL, NULL, $conn);
if ($result->num_rows == 0) {
$statusMessage = makeStatusMessage(14, "error", "Error getting data from database...");
} else {
while ($row = $result->fetch_assoc()) {
$data[] = $row;
}
$statusMessage = makeStatusMessage(15, "success", "Data gathered succesfully.");
}
}
mysqli_close($conn);
return;
public static function selectWorker($workerId, $date = NULL, $expoId = NULL)
{
try {
$sql = STATION_SELECT_WORKER;
$params = array();
$params[] = $workerId;
if (!is_null($date)) {
$sql .= " AND stopTime > ? ";
$params[] = swwat_format_isodatetime($date);
}
if (!is_null($expoId)) {
$sql .= " AND expoid = ? ";
$params[] = $expoId;
}
$rows = simpleSelect("Station", $sql, $params);
for ($k = 0; $k < count($rows); $k++) {
$rows[$k]->fixDates();
}
// $k
return $rows;
} catch (PDOException $pe) {
logMessage('Station::selectWorker(' . $workerId . ', ' . $date . ', ' . $expoId . ')', $pe->getMessage());
}
}
function getLanguages($conn)
{
$select = array("abreviation");
$tableNames = array("languages");
$result = simpleSelect($select, $tableNames, NULL, NULL, NULL, NULL, NULL, $conn);
if ($result->num_rows == 0) {
return null;
} else {
return $result;
}
}
public function getEmail()
{
$departmentId = null;
if ($this->systemAdmin) {
if (session('department_filter_id')) {
$departmentId = session('department_filter_id');
}
} else {
$departmentId = auth()->user()->department_id;
}
$users = $templates = [];
if ($departmentId) {
$users = simpleSelect(User::where('department_id', $departmentId)->get());
$templates = simpleSelect(EmailTemplate::where('department_id', $departmentId)->where('system', 0)->get(), true);
}
return view('admin.template.email', ['departments' => getNomenclatureSelect($this->getDepartmentsAdmin(), true), 'user_types' => simpleSelect(UserType::active()->get(), true, 'title'), 'users' => $users, 'templates' => $templates]);
}
public static function selectNotStation($expoId, $stationId)
{
try {
return simpleSelect("Worker", WORKER_SELECT_NOTSTATION, array($expoId, $stationId));
} catch (PDOException $pe) {
logMessage('Worker::selectNotStation(' . $expoId . ', ' . $stationId . ')', $pe->getMessage());
}
}
foreach ($propNames as $p) {
if (!isset($_POST['filters'][$p])) {
$select = array("DISTINCT " . $p);
$result = simpleSelect($select, $tableNames, NULL, NULL, $whereFilters, NULL, NULL, $conn);
if ($result->num_rows != 0) {
$filters = array();
while ($row = $result->fetch_assoc()) {
$filters[] = $row[$p];
}
$dataF[] = array("name" => $p, $p => $filters);
}
} else {
$dataF[] = array($p => $_POST['filters'][$p]);
}
}
$select = $propNames;
$select[] = "imgurl";
$tableNames = array("products_" . $_POST['id']);
$result = simpleSelect($select, $tableNames, NULL, NULL, $whereFilters, NULL, NULL, $conn);
if ($result->num_rows == 0) {
$statusMessage = makeStatusMessage(25, "error", "Nothing to select.");
} else {
$dataP = array();
while ($row = $result->fetch_assoc()) {
$dataP[] = $row;
}
$statusMessage = makeStatusMessage(15, "success", "Data sent succesfully.");
$data = array("filters" => $dataF, "products" => $dataP);
}
mysqli_close($conn);
return;
private static function select($sqlWorker, $sqlPrefs, $params)
{
$workers = NULL;
$prefList = NULL;
try {
$workers = simpleSelect("WorkerSchedule", $sqlWorker, $params);
$prefList = simpleSelect("ShiftPreference", $sqlPrefs, $params);
} catch (PDOException $pe) {
logMessage('WorkerScheduleView::select(' . var_export($params, TRUE) . ')', $pe->getMessage());
}
$workerList = array();
foreach ($workers as $worker) {
$workerList[$worker->workerid] = $worker;
}
// $worker
$workers = NULL;
// gc
foreach ($prefList as $preference) {
if (array_key_exists($preference->workerid, $workerList)) {
$worker = $workerList[$preference->workerid];
$worker->jobPreferences[$preference->jobid] = $preference;
}
}
// $preference
foreach ($workerList as $worker) {
$worker->jobPreferences = ShiftPreference::sort($worker->jobPreferences, FALSE);
}
// $worker
$prefList = NULL;
// gc
return $workerList;
}
