public function insertOrUpdateProduct($post)
{
parent::createConnection();
$house_no = $post['house_no'];
$street_name = parent::getEscaped($post['street_name']);
$apartment_no = parent::getEscaped($post['apartment_no']);
$city = parent::getEscaped(ucwords($post['city']));
$state = $post['state'];
$country = $post['country'];
$zip = strtoupper($post['zip']);
$type = $post['range'];
$description = parent::getEscaped($post['description']);
$room_no = $post['rooms'];
$bath_no = $post['bathrooms'];
$living_room_no = $post['living_rooms'];
$price = parent::getEscaped($post['price']);
$rangeType = $post['rangeType'];
$loginObj = new Login();
$user_id = $loginObj->getUserId();
if (isset($post['upload']) && isset($_FILES['files'])) {
$query1 = "INSERT INTO address_info VALUES (DEFAULT, '{$house_no}', '{$street_name}', '{$apartment_no}', '{$city}', '{$state}', '{$zip}', '{$country}')";
parent::executeSqlQuery($query1);
$addressId = parent::getLastId();
$query = "INSERT INTO dwellings VALUES (DEFAULT, '{$addressId}', '{$user_id}', '{$type}', '{$description}', '{$room_no}', '{$bath_no}', '{$living_room_no}', '{$price}', '{$rangeType}')";
parent::executeSqlQuery($query);
$this->uploadImages($_FILES);
} elseif (isset($post['update'])) {
$dwelling_Id = $post['hiddenID'];
$address_id = $this->getAddressId($dwelling_Id);
$updateDwellings = "UPDATE dwellings SET type \t\t \t\t= '{$type}', \t\tdescription \t= '{$description}',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t no_of_rooms \t\t= '{$room_no}', \t\tno_of_bathrooms\t= '{$bath_no}', \t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t no_of_living_rooms = '{$living_room_no}',price \t\t\t= '{$price}'\n\t\t\t\t\t\t\t\t\t\t\t\t WHERE dwelling_Id = {$dwelling_Id}";
$updateAddress = "UPDATE address_info SET house_no \t\t\t= '{$house_no}', \t\tstreet_name \t\t= '{$street_name}',\n\t\t\t\t\t\t\t\t\t\t\t\t\t apartment_no \t\t= '{$apartment_no}', \tcity \t\t \t\t= '{$city}',\n\t\t\t\t\t\t\t\t\t\t\t\t\t province \t\t\t= '{$state}', \t\tzip_code \t \t\t= '{$zip}',\n\t\t\t\t\t\t\t\t\t\t\t\t\t country\t\t\t\t= '{$country}'\n\t\t\t\t\t\t\t\t\t\t\t WHERE address_id \t= '{$address_id}'";
parent::executeSqlQuery($updateDwellings);
parent::executeSqlQuery($updateAddress);
}
}
/**
* Drops a table
*
* @return bool|mysqli_result Result of query
*/
public function drop()
{
return parent::createConnection()->query('DROP TABLE ' . $this->name);
}
public function getUserId()
{
$selectUserId = "SELECT user_id FROM users WHERE username = '******'USERNAME'] . "'";
$rs = mysqli_query(parent::createConnection(), $selectUserId);
if ($rs->num_rows > 0) {
while ($row = $rs->fetch_assoc()) {
$user_id = $row['user_id'];
}
return $user_id;
}
return null;
}
