public static function select($id) { $connection = Flight::dbMain(); try { $sql = "SELECT * FROM company WHERE id = :id;"; $query = $connection->prepare($sql); $query->bindParam(':id', $id, PDO::PARAM_INT); $query->execute(); if ($query->rowCount() < 1) { return null; } $row = $query->fetch(PDO::FETCH_ASSOC); $company = new Company(); $company->Id = (int) $row['id']; $company->Name = $row['company_name']; $company->Desc = $row['company_desc']; $company->DtCreated = $row['company_dt_created']; $company->Status = Status::select($row['e_status_id']); return $company; } catch (PDOException $pdoException) { throw $pdoException; } catch (Exception $exception) { throw $exception; } finally { $connection = null; } }
public static function login() { $connection = Flight::dbMain(); try { $session = json_decode(file_get_contents("php://input")); if ($session == null) { throw new Exception(json_get_error()); } $sql = "SELECT * FROM user WHERE user.user_name = :name and user.user_password = :password;"; $query = $connection->prepare($sql); $password = hash('sha256', $session->Password); $query->bindParam(':name', $session->Name, PDO::PARAM_STR); $query->bindParam(':password', $password, PDO::PARAM_STR); $query->execute(); $row = $query->fetch(PDO::FETCH_ASSOC); if ($query->rowCount() < 1) { throw new Exception("Username or Password is not exist"); } $user = new User(); $user->Id = (int) $row['id']; $user->Name = $row['user_name']; $user->DtCreated = $row['user_dt_created']; $user->DtExpired = $row['user_dt_expired']; // $user->Privilege = (int) $row['e_privilege_id']; // $user->Status = (int) $row['e_status_id']; // $user->Company = (int) $row['company_id']; // $user->Sim = $row['sim_id'] == null ? null : (int) $row['sim_id']; $user->Privilege = Privilege::select($row['e_privilege_id']); $user->Status = Status::select($row['e_status_id']); $user->Company = Company::select($row['company_id']); $user->Sim = Sim::select($row['sim_id']); Flight::ok($user); } catch (PDOException $pdoException) { Flight::error($pdoException); } catch (Exception $exception) { Flight::error($exception); } finally { $connection = null; } }
public function getStatus() { $status = Status::select('ruta', 'estado')->get(); return Response::json(array('status' => $status)); }
public static function selectByCompany($id) { $connection = Flight::dbMain(); try { $sql = "SELECT * FROM driver WHERE company_id = :company;"; $query = $connection->prepare($sql); $query->bindParam(':company', $id, PDO::PARAM_INT); $query->execute(); $rows = $query->fetchAll(PDO::FETCH_ASSOC); $result = array(); foreach ($rows as $row) { $driver = new Driver(); $driver->Id = (int) $row['id']; $driver->DriverId = $row['driver_id']; $driver->Name = $row['driver_name']; $driver->NameFirst = $row['driver_name_f']; $driver->NameMiddle = $row['driver_name_m']; $driver->NameLast = $row['driver_name_l']; $driver->Rfid = $row['driver_rfid']; $driver->DtCreated = $row['driver_dt_created']; $driver->Status = Status::select($row['e_status_id']); $driver->Company = Company::select($row['company_id']); array_push($result, $driver); } return $result; } catch (PDOException $pdoException) { throw $pdoException; } catch (Exception $exception) { throw $exception; } finally { $connection = null; } }
<?php if (isset($_GET['do']) && !empty($_GET['do'])) { $action = $_GET['do']; $result = []; switch ($action) { case 'getposts': require '../class/status.php'; $status = new Status(); $u_id = $_GET['uid']; $limit = $_GET['l']; $id = $_GET['id']; $posts = $status->select($limit, $id); foreach ($posts as $post) { $likes = $status->getLikes($post['id']); if (isset($likes[0]['u_id']) && $likes[0]['u_id'] == 1) { $post['liked'] = 1; } else { $post['liked'] = 0; } $post['likeCount'] = count($likes); $result[] = $post; } break; } $result = json_encode($result); echo $result; } else { echo 'Invalid request!'; }
public static function findEditionByMagazine($magazine = null) { return Status::select('edition')->where('magazine', '=', $magazine)->groupBy('edition')->get(); }
public static function selectByCompany($id) { $connection = Flight::dbMain(); try { $sql = "SELECT * FROM user WHERE company_id = :company;"; $query = $connection->prepare($sql); $query->bindParam(':company', $id, PDO::PARAM_INT); $query->execute(); $rows = $query->fetchAll(PDO::FETCH_ASSOC); $result = array(); foreach ($rows as $row) { $user = new User(); $user->Id = (int) $row['id']; $user->Name = $row['user_name']; $user->DtCreated = $row['user_dt_created']; $user->DtExpired = $row['user_dt_expired']; // $user->Privilege = (int) $row['e_privilege_id']; // $user->Status = (int) $row['e_status_id']; // $user->Company = (int) $row['company_id']; // $user->Sim = $row['sim_id'] == null ? null : (int) $row['sim_id']; $user->Privilege = Privilege::select($row['e_privilege_id']); $user->Status = Status::select($row['e_status_id']); $user->Company = Company::select($row['company_id']); $user->Sim = Sim::select($row['sim_id']); array_push($result, $user); } return $result; } catch (PDOException $pdoException) { throw $pdoException; } catch (Exception $exception) { throw $exception; } finally { $connection = null; } }
public static function selectByCompany($id) { $connection = Flight::dbMain(); try { $sql = "SELECT * FROM sim WHERE company_id = :company;"; $query = $connection->prepare($sql); $query->bindParam(':company', $id, PDO::PARAM_INT); $query->execute(); $rows = $query->fetchAll(PDO::FETCH_ASSOC); $result = array(); foreach ($rows as $row) { $sim = new Sim(); $sim->Id = (int) $row['id']; $sim->Imei = $row['sim_imei']; $sim->Number = $row['sim_number']; $sim->Roaming = (bool) $row['sim_roaming']; $sim->SimVendor = SimVendor::select($row['e_sim_vendor_id']); $sim->DtCreated = $row['sim_dt_created']; $sim->Status = Status::select($row['e_status_id']); $sim->Company = Company::select($row['company_id']); array_push($result, $sim); } return $result; } catch (PDOException $pdoException) { throw $pdoException; } catch (Exception $exception) { throw $exception; } finally { $connection = null; } }
} }); //============================================================================= //Status //============================================================================= Flight::route('GET /v1/main/status', function () { try { $array = Status::selectAll(); Flight::ok($array); } catch (Exception $exception) { Flight::error($exception); } }); Flight::route('GET /v1/main/status/@id', function ($id) { try { $object = Status::select($id); Flight::ok($object); } catch (Exception $exception) { Flight::error($exception); } }); Flight::route('POST /v1/main/status', function () { try { $object = Status::insert(); Flight::ok($object); } catch (Exception $exception) { Flight::error($exception); } }); Flight::route('PUT /v1/main/status/@id', function ($id) { try {
public function getUpdate() { $estados = Status::select('estado')->get(); return Response::json(array('estados' => $estados)); }
public static function selectByCompany($id) { $connection = Flight::dbMain(); try { $sql = "SELECT * FROM vehicle WHERE company_id = :company;"; $query = $connection->prepare($sql); $query->bindParam(':company', $id, PDO::PARAM_INT); $query->execute(); $rows = $query->fetchAll(PDO::FETCH_ASSOC); $result = array(); foreach ($rows as $row) { $vehicle = new Vehicle(); $vehicle->Id = (int) $row['id']; $vehicle->DtCreated = $row['vehicle_dt_created']; $vehicle->DtSubscribed = $row['vehicle_dt_subscribed']; $vehicle->Plate = $row['vehicle_plate']; $vehicle->Name = $row['vehicle_name']; $vehicle->Model = $row['vehicle_model']; $vehicle->MaInitial = (int) $row['vehicle_ma_initial']; $vehicle->MaLimit = (int) $row['vehicle_ma_limit']; $vehicle->MaMaintenance = (int) $row['vehicle_ma_maintenance']; $vehicle->SpeedMax = (int) $row['vehicle_speed_max']; $vehicle->FuelMax = (int) $row['vehicle_fuel_max']; // $vehicle->Status = (int)$row['e_status_id']; // $vehicle->Driver = $row['driver_id'] == null ? null : (int)$row['driver_id']; // $vehicle->Unit = $row['unit_id'] == null ? null : (int)$row['unit_id']; // $vehicle->Company = (int) $row['company_id']; // $vehicle->TrackeeType = (int) $row['e_trackee_type_id']; $vehicle->Status = (int) $row['e_status_id']; $vehicle->Driver = Driver::select($row['driver_id']); $vehicle->Unit = Unit::select($row['unit_id']); $vehicle->Company = Company::select($row['company_id']); $vehicle->TrackeeType = TrackeeType::select($row['e_trackee_type_id']); $vehicle->Status = Status::select($row['e_status_id']); array_push($result, $vehicle); } return $result; } catch (PDOException $pdoException) { throw $pdoException; } catch (Exception $exception) { throw $exception; } finally { $connection = null; } }