function GetUserInformation($payload)
{
$connector = new Connector();
$payload = json_decode($payload);
$sql = "";
$sql .= " SELECT";
$sql .= " \t members_info.email";
$sql .= " \t , members_info.lastname";
$sql .= " \t , members_info.firstname";
$sql .= " \t , members_info.middlename";
$sql .= " \t , members_info.contactno";
$sql .= " \t , members_info.status";
$sql .= " \t , members_address.houseno";
$sql .= " \t , members_address.companyname";
$sql .= " \t , members_address.barangay";
$sql .= " \t , members_address.city";
$sql .= " \t , members_address.district";
$sql .= " FROM members_info";
$sql .= " INNER JOIN members_address ON";
$sql .= " \tmembers_info.email = members_address.email";
$sql .= " WHERE";
$sql .= "\tmembers_info.email \t\t\t= '" . $payload->email . "'";
$sql .= "\tAND members_info.password \t= '" . md5($payload->password) . "'";
$mysqliQuery = mysqli_query($connector->GetConnection(), $sql);
if ($mysqliQuery) {
echo json_encode(mysqli_fetch_array($mysqliQuery));
} else {
echo 'error';
}
}
public function GetServiceableAreaList()
{
$connector = new Connector();
$sqlCities = "SELECT cityname FROM cities";
$mysqliQueryCities = mysqli_query($connector->GetConnection(), $sqlCities);
$results = array();
while ($row_city = mysqli_fetch_array($mysqliQueryCities)) {
$city = new City();
$city->cityName = $row_city['cityname'];
$sqlDistricts = "";
$sqlDistricts .= " SELECT districtname, class";
$sqlDistricts .= " FROM district WHERE cityname='" . $city->cityName . "'";
$mysqliQueryDistricts = mysqli_query($connector->GetConnection(), $sqlDistricts);
while ($row_district = mysqli_fetch_array($mysqliQueryDistricts)) {
$district = new District();
$district->districtName = $row_district['districtname'];
$district->class = $row_district['class'];
array_push($city->districts, $district);
}
array_push($results, $city);
}
return json_encode($results);
}
public function GetShippingPrices()
{
$connector = new Connector();
$sql = " SELECT";
$sql .= "\tdistancefrom";
$sql .= " \t, distanceto";
$sql .= "\t, price";
$sql .= " FROM shipping_prices";
$mysqliQuery = mysqli_query($connector->GetConnection(), $sql);
$output = array();
while ($row = mysqli_fetch_array($mysqliQuery, MYSQLI_ASSOC)) {
array_push($output, $row);
}
return json_encode($output);
}
function AddBook($payload)
{
$book = new Book();
$connector = new Connector();
$conn = $connector->GetConnection();
$payload = json_decode($payload);
$book->sender->SetName($payload->sender->name);
$book->sender->SetHouseNo($payload->sender->houseNo);
$book->sender->SetCompanyName($payload->sender->companyName);
$book->sender->SetBarangay($payload->sender->barangay);
$book->sender->SetCity($payload->sender->city);
$book->sender->SetDistrict($payload->sender->district);
$book->sender->SetContactNo($payload->sender->contactNo);
$book->receiver->SetName($payload->receiver->name);
$book->receiver->SetHouseNo($payload->receiver->houseNo);
$book->receiver->SetCompanyName($payload->receiver->companyName);
$book->receiver->SetBarangay($payload->receiver->barangay);
$book->receiver->SetCity($payload->receiver->city);
$book->receiver->SetDistrict($payload->receiver->district);
$book->receiver->SetContactNo($payload->receiver->contactNo);
$book->SetServiceLevel($payload->serviceLevel);
$book->SetSize($payload->size);
$book->SetHeight($payload->height);
$book->SetLength($payload->length);
$book->SetWidth($payload->width);
$book->SetWeight($payload->weight);
$book->SetChargeableWeight($payload->chargeableWeight);
$book->SetDimension($payload->dimension);
$book->SetInsurance($payload->insurance);
$book->SetDeclaredValue($payload->declaredValue);
$book->SetPaymentMethod($payload->paymentMethod);
$payload->cod->bankName = isset($payload->cod->bankName) ? $payload->cod->bankName : "";
$payload->cod->accountName = isset($payload->cod->accountName) ? $payload->cod->accountName : "";
$payload->cod->accountNo = isset($payload->cod->accountNo) ? $payload->cod->accountNo : "";
$payload->cod->amount = isset($payload->cod->amount) ? $payload->cod->amount : 0;
$book->cod->SetBankName($payload->cod->bankName);
$book->cod->SetAccountName($payload->cod->accountName);
$book->cod->SetAccountNo($payload->cod->accountNo);
$book->cod->SetAmount($payload->cod->amount);
$book->SetAmountDue($payload->amountDue);
if ($book->SaveBooking()[1]) {
echo json_encode($book->SaveBooking());
} else {
echo json_encode($book->SaveBooking());
}
}
public function GenerateNewPassword()
{
$connector = new Connector();
$newPassword = $this->GeneratePassword();
$sql = "";
$sql .= " UPDATE members_info";
$sql .= "\tSET password = '******'";
$sql .= " WHERE";
$sql .= " \temail = '" . $this->currentEmail . "'";
$mysqliQuery = mysqli_query($connector->GetConnection(), $sql);
if ($mysqliQuery) {
$mailer = new Mailer();
$mailer->SetRecepient($this->currentEmail);
$mailer->EmailNewPassword($newPassword);
$mailer->SendMail();
return true;
} else {
return false;
}
}
public function SaveBooking()
{
date_default_timezone_set("Asia/Manila");
$connector = new Connector();
$date = date('D');
$hours = date('H:i:s');
$dateToday = date('g:m:s A');
$dateTime = date('Y-m-d');
$randomNumber = mt_rand(0, 99999);
$randomNumber = str_pad($randomNumber, 5, '0', STR_PAD_LEFT);
$day = date('d');
$month = date('m');
$referenceNo = date('Y') . $randomNumber . $month . $day;
$collectOnDelivery = 'NIA';
$cod = 'No';
$this->serviceLevel = str_replace(" Delivery", "", $this->serviceLevel);
if ($this->serviceLevel == 'Same Day Delivery w/ Collect On Delivery' || $this->serviceLevel == 'Next Day Delivery w/ Collect On Delivery') {
$collectOnDelivery = 'Delivery';
$cod = 'Yes';
$this->serviceLevel = str_replace(" w/ Collect On Delivery", "", $this->serviceLevel);
}
$sql = "";
$sql .= " INSERT INTO booking_details";
$sql .= " VALUES";
$sql .= " (";
$sql .= " \t \t'" . $referenceNo . "'";
$sql .= " \t , \t'" . $this->serviceLevel . "'";
$sql .= " \t , \t'" . $this->size . "'";
$sql .= " \t , \t'" . $collectOnDelivery . "'";
$sql .= " \t , \t'" . $cod . "'";
$sql .= " \t , \t'" . $this->declaredValue . "'";
$sql .= " \t , \t''";
$sql .= " \t , \t" . $this->weight;
$sql .= " \t , \t" . $this->height;
$sql .= " \t , \t" . $this->length;
$sql .= " \t , \t" . $this->width;
$sql .= " \t , \t" . $this->amountDue;
$sql .= " \t , ''";
$sql .= " \t , ''";
$sql .= " \t , ''";
$sql .= " \t , ''";
$sql .= " \t , ''";
$sql .= " \t , ''";
$sql .= " \t , ''";
$sql .= " \t , '" . $this->sender->GetEmail() . "'";
$sql .= " \t , '" . $this->sender->GetName() . "'";
$sql .= " \t , '" . $this->receiver->GetName() . "'";
$sql .= " \t , '" . $dateTime . "'";
$sql .= " \t , '" . $this->receiver->GetHouseNo() . "'";
$sql .= " \t , '" . $this->receiver->GetCompanyName() . "'";
$sql .= " \t , '" . $this->receiver->GetBarangay() . "'";
$sql .= " \t , '" . $this->receiver->GetCity() . "'";
$sql .= " \t , '" . $this->receiver->GetDistrict() . "'";
$sql .= " \t , '" . $this->receiver->GetContactNo() . "'";
$sql .= " \t , 'Submitted'";
$sql .= " \t , '" . $this->suggestion . "'";
$sql .= " \t , '" . $dateToday . "'";
$sql .= " \t , '" . $this->sender->GetName() . "'";
$sql .= " \t , '" . $this->sender->GetHouseNo() . "'";
$sql .= " \t , '" . $this->sender->GetCompanyName() . "'";
$sql .= " \t , '" . $this->sender->GetBarangay() . "'";
$sql .= " \t , '" . $this->sender->GetCity() . "'";
$sql .= " \t , '" . $this->sender->GetDistrict() . "'";
$sql .= " \t , '" . $this->sender->GetContactNo() . "'";
$sql .= " \t , '" . $this->cod->GetBankName() . "'";
$sql .= " \t , '" . $this->cod->GetAccountName() . "'";
$sql .= " \t , '" . $this->cod->GetAccountNo() . "'";
$sql .= " \t , '" . $this->cod->GetAmount() . "'";
$sql .= " \t , ''";
$sql .= " \t , ''";
$sql .= " \t , ''";
$sql .= " \t , ''";
$sql .= " \t , ''";
$sql .= " )";
$mysqliQuery = mysqli_query($connector->GetConnection(), $sql);
if ($mysqliQuery) {
return array($referenceNo, true);
} else {
return array($referenceNo, false);
}
}
public function UpdatePersonalInfo()
{
$connector = new Connector();
$sql = "";
$sql .= " SELECT COUNT( email ) AS Counter FROM members_info";
$sql .= " WHERE";
$sql .= " \temail = '" . $this->currentEmail . "'";
$sql .= "\tAND password = '******'";
$mysqliQuery = mysqli_query($connector->GetConnection(), $sql);
$counter = mysqli_fetch_array($mysqliQuery)["Counter"];
if ($counter == '1') {
$sql = "";
$sql .= " UPDATE members_info";
$sql .= " SET";
$sql .= "\tfirstname \t\t= '" . $this->firstName . "'";
$sql .= "\t, middlename \t= '" . $this->middleName . "'";
$sql .= " \t, lastname \t\t= '" . $this->lastName . "'";
$sql .= " WHERE";
$sql .= "\temail = '" . $this->currentEmail . "'";
$mysqliQuery = mysqli_query($connector->GetConnection(), $sql);
if ($mysqliQuery) {
return true;
} else {
return false;
}
} else {
return false;
}
}
public function ValidateEmail($value)
{
$connector = new Connector();
$sql = "";
$sql .= " SELECT COUNT( email ) AS Counter FROM members_info";
$sql .= " WHERE email='" . $value . "'";
$mysqliQuery = mysqli_query($connector->GetConnection(), $sql);
if ($mysqliQuery) {
if (mysqli_fetch_array($mysqliQuery)['Counter'] == 0) {
return false;
} else {
return true;
}
}
return false;
}
