public static function insert()
{
$connection = Flight::dbMain();
$dateTime = Flight::dateTime();
try {
$company = json_decode(file_get_contents("php://input"));
if ($company == null) {
throw new Exception(json_get_error());
}
$sql = "\n\t\t\tINSERT INTO company \n\t\t\t(company_name, company_desc, company_dt_created, e_status_id)\n\t\t\tVALUES\n\t\t\t(:company_name, :company_desc, :company_dt_created, :e_status_id);";
$query = $connection->prepare($sql);
$query->bindParam(':company_name', $company->Name, PDO::PARAM_STR);
$query->bindParam(':company_desc', $company->Desc, PDO::PARAM_STR);
$query->bindParam(':company_dt_created', $dateTime, PDO::PARAM_STR);
$query->bindParam(':e_status_id', $company->Status->Id, PDO::PARAM_INT);
$query->execute();
$result = new Result();
$result->Status = Result::INSERTED;
$result->Id = $connection->lastInsertId();
$result->Message = 'Done';
return $result;
} catch (PDOException $pdoException) {
throw $pdoException;
} catch (Exception $exception) {
throw $exception;
} finally {
$connection = null;
}
}
public static function insert()
{
$connection = Flight::dbMain();
$dateTime = Flight::dateTime();
try {
$unit = json_decode(file_get_contents("php://input"));
if ($unit == null) {
throw new Exception(json_get_error());
}
/* Begin Transaction */
$connection->beginTransaction();
//Query 1 //=================================
$sql = "\n\t\t\tINSERT INTO unit \n\t\t\t(unit_imei, unit_serial_number, sim_id, unit_type_id, company_id, e_status_unit_id, unit_dt_created)\n\t\t\tVALUES\n\t\t\t(:unit_imei, :unit_serial_number, :sim_id, :unit_type_id, :company_id, :e_status_unit_id, :unit_dt_created);";
$query = $connection->prepare($sql);
$query->bindParam(':unit_imei', $unit->Imei, PDO::PARAM_INT);
$query->bindParam(':unit_serial_number', $unit->SerialNumber, PDO::PARAM_STR);
$query->bindParam(':sim_id', $unit->Sim->Id, PDO::PARAM_INT);
$query->bindParam(':unit_type_id', $unit->UnitType->Id, PDO::PARAM_INT);
$query->bindParam(':company_id', $unit->Company->Id, PDO::PARAM_INT);
$query->bindParam(':e_status_unit_id', $unit->UnitStatus->Id, PDO::PARAM_INT);
$query->bindParam(':unit_dt_created', $dateTime, PDO::PARAM_STR);
$query->execute();
$result = new Result();
$result->Status = Result::INSERTED;
$result->Id = $connection->lastInsertId();
$result->Message = 'Done';
//Query 2 //=================================
$year = date('Y');
$schema = "app_data_{$year}";
// $tableName = "data_id_" . $result->Id;
$imei = $unit->Imei;
$tableName = "data_{$imei}";
$sql = "\n\t\t\tCREATE TABLE IF NOT EXISTS `" . $schema . "`.`" . $tableName . "` (\n\t\t`id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '',\n\t\t`dt_server` DATETIME NULL COMMENT '',\n\t\t`dt_device` DATETIME NULL COMMENT '',\n\t\t`command` SMALLINT NULL COMMENT '',\n\t\t`event` SMALLINT NULL COMMENT '',\n\t\t`byte` BIGINT NULL COMMENT '',\n\t\t`latitude` DOUBLE NULL COMMENT '',\n\t\t`longitude` DOUBLE NULL COMMENT '',\n\t\t`altitude` DOUBLE NULL COMMENT '',\n\t\t`rfid` BIGINT NULL COMMENT '',\n\t\t`mode` TINYINT NULL COMMENT '',\n\t\t`speed` SMALLINT NULL COMMENT '',\n\t\t`time` BIGINT NULL COMMENT '',\n\t\t`odometer` BIGINT NULL COMMENT '',\n\t\t`heading` SMALLINT NULL COMMENT '',\n\t\t`picture` BIGINT NULL COMMENT '',\n\t\t`gps_satellite` SMALLINT NULL COMMENT '',\n\t\t`gps_status` SMALLINT NULL COMMENT '',\n\t\t`gps_accuracy` SMALLINT NULL COMMENT '',\n\t\t`gprs_signal` SMALLINT NULL COMMENT '',\n\t\t`gprs_status` VARCHAR(25) NULL COMMENT '',\n\t\t`reserve` INT NULL COMMENT '',\n\t\t`di_0` SMALLINT NULL COMMENT '',\n\t\t`di_1` SMALLINT NULL COMMENT '',\n\t\t`di_2` SMALLINT NULL COMMENT '',\n\t\t`di_3` SMALLINT NULL COMMENT '',\n\t\t`di_4` SMALLINT NULL COMMENT '',\n\t\t`di_5` SMALLINT NULL COMMENT '',\n\t\t`di_6` SMALLINT NULL COMMENT '',\n\t\t`di_7` SMALLINT NULL COMMENT '',\n\t\t`di_8` SMALLINT NULL COMMENT '',\n\t\t`di_9` SMALLINT NULL COMMENT '',\n\t\t`di_10` SMALLINT NULL COMMENT '',\n\t\t`do_0` SMALLINT NULL COMMENT '',\n\t\t`do_1` SMALLINT NULL COMMENT '',\n\t\t`do_2` SMALLINT NULL COMMENT '',\n\t\t`do_3` SMALLINT NULL COMMENT '',\n\t\t`ai_0` SMALLINT NULL COMMENT '',\n\t\t`ai_1` SMALLINT NULL COMMENT '',\n\t\t`ai_2` SMALLINT NULL COMMENT '',\n\t\t`ai_3` SMALLINT NULL COMMENT '',\n\t\t`ai_4` SMALLINT NULL COMMENT '',\n\t\t`ai_5` SMALLINT NULL COMMENT '',\n\t\t`ai_6` SMALLINT NULL COMMENT '',\n\t\t`ai_7` SMALLINT NULL COMMENT '',\n\t\t`ai_8` SMALLINT NULL COMMENT '',\n\t\t`ai_9` SMALLINT NULL COMMENT '',\n\t\t`ai_10` SMALLINT NULL COMMENT '',\n\t\t`ao_0` SMALLINT NULL COMMENT '',\n\t\t`ao_1` SMALLINT NULL COMMENT '',\n\t\t`ao_2` SMALLINT NULL COMMENT '',\n\t\t`ao_3` SMALLINT NULL COMMENT '',\n\t\tPRIMARY KEY (`id`) COMMENT '')\n\t\tENGINE = InnoDB\n\t\tPACK_KEYS = DEFAULT\n\t\tKEY_BLOCK_SIZE = 8\n\t\t";
$query = $connection->prepare($sql);
$query->execute();
$connection->commit();
$result = new Result();
$result->Status = Result::INSERTED;
$result->Message = 'Done';
$result->Id = $connection->lastInsertId();
return $result;
} catch (PDOException $pdoException) {
$connection->rollBack();
throw $pdoException;
} catch (Exception $exception) {
$connection->rollBack();
throw $exception;
} finally {
$connection = null;
}
}
public static function insert()
{
$connection = Flight::dbMain();
$dateTime = Flight::dateTime();
try {
$driver = json_decode(file_get_contents("php://input"));
if ($driver == null) {
throw new Exception(json_get_error());
}
$sql = "\n\t\t\tINSERT INTO driver \n\t\t\t(driver_id, driver_name, driver_name_f, driver_name_m, driver_name_l, driver_rfid, e_status_id, company_id, driver_dt_created)\n\t\t\tVALUES\n\t\t\t(:driver_id, :driver_name, :driver_name_f, :driver_name_m, :driver_name_l, :driver_rfid, :e_status_id, :company_id, :driver_dt_created);";
$query = $connection->prepare($sql);
$query->bindParam(':driver_id', $driver->DriverId, PDO::PARAM_STR);
$query->bindParam(':driver_name', $driver->Name, PDO::PARAM_STR);
$query->bindParam(':driver_name_f', $driver->NameFirst, PDO::PARAM_STR);
$query->bindParam(':driver_name_m', $driver->NameMiddle, PDO::PARAM_STR);
$query->bindParam(':driver_name_l', $driver->NameLast, PDO::PARAM_STR);
$query->bindParam(':driver_rfid', $driver->Rfid, PDO::PARAM_STR);
$query->bindParam(':e_status_id', $driver->Status->Id, PDO::PARAM_INT);
$query->bindParam(':company_id', $driver->Company->Id, PDO::PARAM_INT);
$query->bindParam(':driver_dt_created', $dateTime, PDO::PARAM_STR);
$query->execute();
$result = new Result();
$result->Status = Result::INSERTED;
$result->Id = $connection->lastInsertId();
$result->Message = 'Done';
return $result;
} catch (PDOException $pdoException) {
throw $pdoException;
} catch (Exception $exception) {
throw $exception;
} finally {
$connection = null;
}
}
public static function insert()
{
$connection = Flight::dbMain();
$dateTime = Flight::dateTime();
try {
$user = json_decode(file_get_contents("php://input"));
if ($user == null) {
throw new Exception(json_get_error());
}
$sql = "\n\t\t\tINSERT INTO user \n\t\t\t(user_name, user_password, user_dt_created, user_dt_expired, e_privilege_id, e_status_id, company_id, sim_id)\n\t\t\tVALUES\n\t\t\t(:user_name, :user_password, :user_dt_created, :user_dt_expired, :e_privilege_id, :e_status_id, :company_id, :sim_id);";
$query = $connection->prepare($sql);
$query->bindParam(':user_name', $user->Name, PDO::PARAM_STR);
$password = hash('sha256', $user->Password);
$query->bindParam(':user_password', $password, PDO::PARAM_STR);
$query->bindParam(':user_dt_created', $dateTime, PDO::PARAM_STR);
$query->bindParam(':user_dt_expired', $user->DtExpired, PDO::PARAM_STR);
// $query->bindParam(':e_privilege_id', $user->Privilege, PDO::PARAM_INT);
// $query->bindParam(':e_status_id', $user->Status, PDO::PARAM_INT);
// $query->bindParam(':company_id', $user->Company, PDO::PARAM_INT);
// $query->bindParam(':sim_id', $user->Sim, PDO::PARAM_INT);
$query->bindParam(':e_privilege_id', $user->Privilege->Id, PDO::PARAM_INT);
$query->bindParam(':e_status_id', $user->Status->Id, PDO::PARAM_INT);
$query->bindParam(':company_id', $user->Company->Id, PDO::PARAM_INT);
$query->bindParam(':sim_id', $user->Sim->Id, PDO::PARAM_INT);
$query->execute();
$result = new Result();
$result->Status = Result::INSERTED;
$result->Id = (int) $connection->lastInsertId();
$result->Message = 'Done';
return $result;
} catch (PDOException $pdoException) {
throw $pdoException;
} catch (Exception $exception) {
throw $exception;
} finally {
$connection = null;
}
}
public static function insert()
{
$connection = Flight::dbMain();
$dateTime = Flight::dateTime();
try {
$sim = json_decode(file_get_contents("php://input"));
if ($sim == null) {
throw new Exception(json_get_error());
}
$sql = "\n\t\t\tINSERT INTO sim \n\t\t\t(sim_imei, sim_number, sim_roaming, e_sim_vendor_id, e_status_id, sim_dt_created, company_id)\n\t\t\tVALUES\n\t\t\t(:sim_imei, :sim_number, :sim_roaming, :e_sim_vendor_id, :e_status_id, :sim_dt_created, :company_id);";
$query = $connection->prepare($sql);
$query->bindParam(':sim_imei', $sim->Imei, PDO::PARAM_STR);
$query->bindParam(':sim_number', $sim->Number, PDO::PARAM_STR);
$query->bindParam(':sim_roaming', $sim->Roaming, PDO::PARAM_BOOL);
$query->bindParam(':e_sim_vendor_id', $sim->SimVendor->Id, PDO::PARAM_INT);
$query->bindParam(':e_status_id', $sim->Status->Id, PDO::PARAM_INT);
$query->bindParam(':sim_dt_created', $dateTime, PDO::PARAM_STR);
$query->bindParam(':company_id', $sim->Company->Id, PDO::PARAM_INT);
$query->execute();
$result = new Result();
$result->Status = Result::INSERTED;
$result->Id = (int) $connection->lastInsertId();
$result->Message = 'Done';
return $result;
} catch (PDOException $pdoException) {
throw $pdoException;
} catch (Exception $exception) {
throw $exception;
} finally {
$connection = null;
}
}
public static function insert()
{
$connection = Flight::dbMain();
$dateTime = Flight::dateTime();
try {
$vehicle = json_decode(file_get_contents("php://input"));
if ($vehicle == null) {
throw new Exception(json_get_error());
}
$sql = "\n\t\t\tINSERT INTO vehicle \n\t\t\t(\n\t\t\tvehicle_dt_created,\n\t\t\tvehicle_dt_subscribed, \n\t\t\tvehicle_plate, \n\t\t\tvehicle_ma_initial, \n\t\t\tvehicle_ma_limit, \n\t\t\tvehicle_ma_maintenance, \n\t\t\tvehicle_speed_max, \n\t\t\te_status_id, \n\t\t\tvehicle_name, \n\t\t\tvehicle_model,\n\t\t\tvehicle_fuel_max, \n\t\t\tdriver_id,\n\t\t\tunit_id, \n\t\t\tcompany_id,\n\t\t\te_trackee_type_id\n\t\t\t)\n\t\t\t\n\t\t\tVALUES\n\t\t\t(\n\t\t\t:vehicle_dt_created,\n\t\t\t:vehicle_dt_subscribed, \n\t\t\t:vehicle_plate, \n\t\t\t:vehicle_ma_initial, \n\t\t\t:vehicle_ma_limit, \n\t\t\t:vehicle_ma_maintenance, \n\t\t\t:vehicle_speed_max, \n\t\t\t:e_status_id, \n\t\t\t:vehicle_name, \n\t\t\t:vehicle_model,\n\t\t\t:vehicle_fuel_max, \n\t\t\t:driver_id,\n\t\t\t:unit_id, \n\t\t\t:company_id,\n\t\t\t:e_trackee_type_id\n\t\t\t);";
$query = $connection->prepare($sql);
$query->bindParam(':vehicle_dt_created', $dateTime, PDO::PARAM_STR);
$query->bindParam(':vehicle_dt_subscribed', $vehicle->DtSubscribed, PDO::PARAM_STR);
$query->bindParam(':vehicle_plate', $vehicle->Plate, PDO::PARAM_STR);
$query->bindParam(':vehicle_ma_initial', $vehicle->MaInitial, PDO::PARAM_INT);
$query->bindParam(':vehicle_ma_limit', $vehicle->MaLimit, PDO::PARAM_INT);
$query->bindParam(':vehicle_ma_maintenance', $vehicle->MaMaintenance, PDO::PARAM_INT);
$query->bindParam(':vehicle_speed_max', $vehicle->SpeedMax, PDO::PARAM_INT);
$query->bindParam(':e_status_id', $vehicle->Status->Id, PDO::PARAM_INT);
$query->bindParam(':vehicle_name', $vehicle->Name, PDO::PARAM_STR);
$query->bindParam(':vehicle_model', $vehicle->Model, PDO::PARAM_STR);
$query->bindParam(':vehicle_fuel_max', $vehicle->FuelMax, PDO::PARAM_INT);
$query->bindParam(':driver_id', $vehicle->Driver->Id, PDO::PARAM_INT);
$query->bindParam(':unit_id', $vehicle->Unit->Id, PDO::PARAM_INT);
$query->bindParam(':company_id', $vehicle->Company->Id, PDO::PARAM_INT);
$query->bindParam(':e_trackee_type_id', $vehicle->TrackeeType->Id, PDO::PARAM_INT);
$query->execute();
$result = new Result();
$result->Status = Result::INSERTED;
$result->Id = $connection->lastInsertId();
$result->Message = 'Done';
return $result;
} catch (PDOException $pdoException) {
throw $pdoException;
} catch (Exception $exception) {
throw $exception;
} finally {
$connection = null;
}
}
