107
use classes\DBquery;
use classes\UploadFiles;
use core\BaseRepository;
class ObjectRepository extends BaseRepository
{
public static function Get()
{
$filepath = __DIR__ . "/sql/objects/getObjects.sql";
$db = new DBquery();
return $db->queryRowsFile($filepath);
}
public function GetId()
{
$request = $this->Request();
$filepath = __DIR__."/sql/objects/getObjectId.sql";
$db = new DBquery();
$params = [
"id" => $request->id
];
return $db->queryRowFile($filepath, $params);
}
public function AddObject()
{
$request = $_POST;
$addr = json_decode($request["address"], true);
$paramsAddr = [
"street" => $addr["data"]["street"],
"house" => $addr["data"]["house"],
"flat" => $addr["data"]["flat"],
"full_address" => $addr["unrestricted_value"]
];
$paramsOwner = [
"surname" => $request["surname"],
"first_name" => $request["firstName"],
"patronymic" => $request["patronymic"],
"phone" => $request["phone"],
"email" => $request["email"]
];
$addr = $this->db->insert('ro_addr', $paramsAddr);
$owner = $this->db->insert('ro_owner', $paramsOwner);
$paramsObject = [