public static function select($id)
{
$connection = Flight::dbMain();
try {
$sql = "SELECT * FROM geofence 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);
$geofence = new Geofence();
$geofence->Id = (int) $row['id'];
$geofence->Company = Company::select($row['company_id']);
$geofence->Name = $row['geofence_name'];
$geofence->Desc = $row['geofence_desc'];
$geofence->Coordinates = $row['geofence_coordinates'];
$geofence->Type = (int) $row['geofence_type'];
$geofence->SpeedMinL = (int) $row['geofence_speed_min_l'];
$geofence->SpeedMaxL = (int) $row['geofence_speed_max_l'];
$geofence->SpeedMinH = (int) $row['geofence_speed_min_h'];
$geofence->SpeedMaxH = (int) $row['geofence_speed_max_h'];
$geofence->IsGlobal = (int) $row['geofence_is_global'];
$geofence->IsVisible = (int) $row['geofence_is_visible'];
return $geofence;
} catch (PDOException $pdoException) {
throw $pdoException;
} catch (Exception $exception) {
throw $exception;
} finally {
$connection = null;
}
}
public static function select($id)
{
$connection = Flight::dbMain();
try {
$sql = "SELECT * FROM route 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);
$route = new Route();
$route->Id = (int) $row['id'];
$route->Name = $row['route_name'];
$route->Desc = $row['route_description'];
$route->Coordinates = $row['route_coordinates'];
$route->IsVisible = (bool) $row['route_is_visible'];
$route->IsGlobal = (bool) $row['route_is_global'];
$route->Company = Company::select($row['company_id']);
return $route;
} catch (PDOException $pdoException) {
throw $pdoException;
} catch (Exception $exception) {
throw $exception;
} finally {
$connection = null;
}
}
/**
* [index - This is for the typeahead lookups, restfull routes are configured in routes.php (/api/v1/)]
* @return [json] [DT compatible object]
*/
public function index()
{
if (Input::get('q')) {
$datums = Company::select('bedrijfsnaam AS value', 'id')->where('bedrijfsnaam', 'like', '%' . Input::get('q') . '%')->take(50)->get();
foreach ($datums as $datum) {
$datum->tokens = explode(' ', $datum->value);
}
return Response::json($datums);
} else {
return Response::json(Company::select('bedrijfsnaam AS value', 'id')->orderBy('updated_at', 'DESC')->take(50)->get());
}
}
public function getCompanyResults()
{
$company = array();
$company['name'] = Input::get('name');
$company['country'] = Input::get('country');
$company['city'] = Input::get('city');
$company['references'] = Input::get('references');
$company_results = Company::select('companies.*', 'c.name as country', 'a.city AS city')->join('adresses AS a', 'companies.address_id', '=', 'a.id')->join('countries AS c', 'a.country_id', '=', 'c.id');
if (empty(Input::get('name')) && empty(Input::get('country')) && empty(Input::get('city')) && empty(Input::get('references'))) {
$company_results->orderBy('companies.id', 'DESC')->take(5);
} else {
if (!empty(Input::get('name'))) {
$company_results->where('companies.name', 'LIKE', '%' . $company['name'] . '%');
}
if (!empty(Input::get('references'))) {
$company_results->where('companies.references', 'LIKE', '%' . $company['references'] . '%');
}
if (!empty(Input::get('city'))) {
$city_search_terms = explode(',', Input::get('city'));
$city_where_str = "";
for ($city_ndx = 0; $city_ndx < count($city_search_terms); $city_ndx++) {
if ($city_ndx !== 0) {
$city_where_str .= " OR a.city LIKE '%" . $city_search_terms[$city_ndx] . "%' ";
} else {
$city_where_str .= " a.city LIKE '%" . $city_search_terms[$city_ndx] . "%' ";
}
}
$company_results->whereRaw("(" . $city_where_str . ")");
}
if (!empty(Input::get('country'))) {
$country_search_terms = explode(',', Input::get('country'));
$country_where_str = "";
for ($country_ndx = 0; $country_ndx < count($country_search_terms); $country_ndx++) {
if ($country_ndx !== 0) {
$country_where_str .= " OR c.name LIKE '%" . $country_search_terms[$country_ndx] . "%' ";
} else {
$country_where_str .= " c.name LIKE '%" . $country_search_terms[$country_ndx] . "%' ";
}
}
$company_results->whereRaw("(" . $country_where_str . ")");
}
}
$company_results = $company_results->get();
$data = [];
foreach ($company_results as $curr_company) {
$curr_company = (object) ['DT_RowId' => $curr_company->id, 'name' => $curr_company->name, 'references' => $curr_company->references, 'country' => $curr_company->country, 'city' => $curr_company->city];
$curr_entry = (object) $curr_company;
$data[] = $curr_entry;
}
echo json_encode(['data' => $data]);
}
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 static function delete($id)
{
$connection = Flight::dbMain();
try {
/* Begin Transaction */
$connection->beginTransaction();
/*Query 1 Select unit*/
$sql = "SELECT * FROM unit WHERE id = :id;";
$query = $connection->prepare($sql);
$query->bindParam(':id', $id, PDO::PARAM_INT);
$query->execute();
$rows = $query->fetchAll(PDO::FETCH_ASSOC);
$row = $rows[0];
$unit = new Unit();
$unit->Id = (int) $row['id'];
$unit->Imei = $row['unit_imei'];
$unit->DtCreated = $row['unit_dt_created'];
$unit->SerialNumber = $row['unit_serial_number'];
$unit->Sim = Sim::select($row['sim_id']);
$unit->UnitStatus = UnitStatus::select($row['e_status_unit_id']);
$unit->UnitType = UnitType::select($row['unit_type_id']);
$unit->Company = Company::select($row['company_id']);
/*Query 2 Delete unit*/
$sql = "\n\t\t\tDELETE FROM unit \n\t\t\tWHERE\n\t\t\tid = :id";
$query = $connection->prepare($sql);
$query->bindParam(':id', $id, PDO::PARAM_INT);
$query->execute();
/*Query 3 Drop data_unit.imei table*/
$year = date('Y');
$schema = "app_data_{$year}";
$imei = $unit->Imei;
$tableName = "data_{$imei}";
$sql = "\n\t\t\t\n\t\t\tDROP TABLE IF EXISTS {$schema}.{$tableName};\n\n\t\t\t";
$query = $connection->prepare($sql);
$query->execute();
$connection->commit();
$result = new Result();
$result->Status = Result::DELETED;
$result->Message = 'Done';
$result->Id = $id;
return $result;
} catch (PDOException $pdoException) {
$connection->rollBack();
throw $pdoException;
} catch (Exception $exception) {
$connection->rollBack();
throw $exception;
} finally {
$connection = null;
}
}
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;
}
}
public static function selectByCompany($id)
{
$connection = Flight::dbMain();
try {
$sql = "SELECT * FROM company_info WHERE company_id = :company_id LIMIT 1;";
$query = $connection->prepare($sql);
$query->bindParam(':company_id', $id, PDO::PARAM_INT);
$query->execute();
if ($query->rowCount() < 1) {
return null;
}
$row = $query->fetch(PDO::FETCH_ASSOC);
$companyInfo = new CompanyInfo();
$companyInfo->Id = (int) $row['id'];
$companyInfo->Logo = $row['info_logo'];
$companyInfo->Alert = (int) $row['info_alert'];
$companyInfo->Notify = (int) $row['info_noti'];
$companyInfo->Theme = (int) $row['info_theme'];
$companyInfo->Field = Field::select($row['e_field_id']);
$companyInfo->Company = Company::select($row['company_id']);
return $companyInfo;
} 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 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 collection 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) {
$collection = new Collection();
$collection->Id = (int) $row['id'];
$collection->Name = $row['collection_name'];
$collection->Desc = $row['collection_desc'];
// $collection->User = $row['user_id'] == null ? null : (int)$row['user_id'];
// $collection->Company = (int)$row['company_id'];
$collection->User = User::select($row['user_id']);
$collection->Company = Company::select($row['company_id']);
// $vehicleCollections = VehicleCollection::selectByCollection($collection->Id);
// foreach ($vehicleCollections as $vehicleCollection) {
// array_push($collection->Vehicles, $vehicleCollection->Vehicle);
// }
array_push($result, $collection);
}
return $result;
} catch (PDOException $pdoException) {
throw $pdoException;
} catch (Exception $exception) {
throw $exception;
} finally {
$connection = null;
}
}
$data = array();
$results = Company::select('company_name')->where('status', '=', '2')->where('company_name', 'LIKE', '%' . $query . '%')->get();
if (count($results) > 0) {
foreach ($results as $row) {
$data[] = strtolower($row->company_name) . "";
}
} else {
$data[] = 'No record found.';
}
return Response::json($data);
});
Route::get('company/{id}/information/{query}', function ($id, $query) {
// $data = array('Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday');
// return Response::json($data);
$data = array();
$results = Company::select('company_name')->where('status', '=', '2')->where('company_name', 'LIKE', '%' . $query . '%')->get();
if (count($results) > 0) {
foreach ($results as $row) {
$data[] = strtolower($row->company_name) . "";
}
} else {
$data[] = 'No record found.';
}
return Response::json($data);
});
Route::get('company/details/{id}', array('as' => 'company.dt', 'uses' => 'CompanyController@details'));
Route::get('ra-company', array('as' => 'company.ra', 'uses' => 'CompanyController@ra'));
Route::put('company/approve/{id}', array('as' => 'company.a', 'uses' => 'CompanyController@a'));
Route::put('company/denied/{id}', array('as' => 'company.d', 'uses' => 'CompanyController@d'));
Route::get('ra-company/details/{id}', array('as' => 'ra.company.dt', 'uses' => 'CompanyController@ra_details'));
Route::resource('project', 'ProjectController');
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;
}
}
}
});
//=============================================================================
//Company
//=============================================================================
Flight::route('GET /v1/main/company', function () {
try {
$array = Company::selectAll();
Flight::ok($array);
} catch (Exception $exception) {
Flight::error($exception);
}
});
Flight::route('GET /v1/main/company/@id', function ($id) {
try {
$object = Company::select($id);
Flight::ok($object);
} catch (Exception $exception) {
Flight::error($exception);
}
});
Flight::route('POST /v1/main/company', function () {
try {
$object = Company::insert();
Flight::ok($object);
} catch (Exception $exception) {
Flight::error($exception);
}
});
Flight::route('PUT /v1/main/company/@id', function ($id) {
try {
public static function selectByCompany($id)
{
$connection = Flight::dbMain();
try {
$sql = "SELECT * FROM poi WHERE company_id = :company_id;";
$query->bindParam(':company_id', $id, PDO::PARAM_INT);
$query = $connection->prepare($sql);
$query->execute();
$rows = $query->fetchAll(PDO::FETCH_ASSOC);
$result = array();
foreach ($rows as $row) {
$poi = new Poi();
$poi->Id = (int) $row['id'];
$poi->Company = Company::select($row['company_id']);
$poi->Name = $row['poi_name'];
$poi->Desc = $row['poi_desc'];
$poi->Coordinate = new Coordinate($row['poi_latitude'], $row['poi_longitude']);
$poi->IsVisible = (bool) $row['poi_is_visible'];
$poi->IsGlobal = (bool) $row['poi_is_global'];
$poi->Image = $row['poi_image'];
array_push($result, $poi);
}
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 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;
}
}
<?php
include_once $CFG->dirroot . "/lib/classes/" . "application/Company.Class.php5";
$companyObj = new Company();
$GeneralObj->getRequestVars();
$section = 'Organization';
$mode = $_REQUEST['mode'];
if ($mode == "Update") {
$companyObj->select($iCompanyId);
$companyObj->getAllVar();
} else {
$mode = "Add";
}
if ($file != '') {
$link = "index.php?file=" . $file . "&mode=" . $mode . "&listfile=" . $listfile;
}
$TOP_HEADER = $mode . ' ' . $section;
if ($mode == 'Update') {
$TOP_HEADER .= ' [' . $vCompanyName . ']';
}
?>
<form name="frmadd" method="post" enctype="multipart/form-data" action="index.php?file=m-companyadd_a">
<input type="hidden" id="mode" name="mode" value="<?php
echo $mode;
?>
">
<input type="hidden" id="SAMPM" name="SAMPM" value="<?php
echo $SAMPM;
?>
">
<input type="hidden" id="EAMPM" name="EAMPM" value="<?php
