public function saveDonationInfo($donationDetail)
{
try {
$sql = "INSERT INTO ngo_donation(campaign_id, donationAmount, email,postDate)\n\t\t\t\t\t\t\tVALUES \n\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\t '" . $donationDetail->getCampaignId() . "',\n\t\t\t\t\t\t\t '" . $donationDetail->getDonationAmount() . "',\n\t\t\t\t\t\t\t '" . $donationDetail->getEmail() . "',\n\t\t\t\t\t\t\t '" . $donationDetail->getDonationPostDate() . "'\n\t\t\t\t\t\t\t )";
$isInserted = mysqli_query($this->con, $sql);
if ($isInserted) {
$this->data = "DONATION_DETAILS_SAVED_SUCCESSFULLY";
$SqlDonationDetails = "SELECT c.campaign_id,c.campaignName,c.email as ngoOwnerEmail,\n\t\t\t\t\t\t\t\t\t\t\t\t\tud.ngo_name,\n\t\t\t\t\t\t\t\t\t\t\t\t\tnd.donationAmount, nd.postDate as donation_Date,\n\t\t\t\t\t\t\t\t\t\t\t\t\tu.id as userId, u.name as donarName, u.email as donarEmail,u.mobileno as donarMobileNo\n\t\t\t\t\t\t\t\t\t\t\t\t\tFROM campaign c\n\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN userDetails ud\n\t\t\t\t\t\t\t\t\t\t\t\t\tON c.email=ud.email\n\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN ngo_donation nd\n\t\t\t\t\t\t\t\t\t\t\t\t\tON c.campaign_id = nd.campaign_id\n\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN userDetails u\n\t\t\t\t\t\t\t\t\t\t\t\t\tON u.email = nd.email \n\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE c.campaign_id='" . $donationDetail->getCampaignId() . "'";
$result = mysqli_query($this->con, $SqlDonationDetails);
$donationDetails = array();
while ($rowdata = mysqli_fetch_assoc($result)) {
$donationDetails = $rowdata;
}
//print_r ($donationDetails);
$campaign_id = $donationDetails['campaign_id'];
$donation_Date = $donationDetails['donation_Date'];
$donar_id = $donationDetails['userId'];
$campaignName = $donationDetails['campaignName'];
$ngoName = $donationDetails['ngoName'];
$ngoOwnerEmail = $donationDetails['ngoOwnerEmail'];
$donarName = $donationDetails['donarName'];
$donarEmail = $donationDetails['donarEmail'];
$donarMobileNo = $donationDetails['donarMobileNo'];
$donationAmount = $donationDetails['donationAmount'];
$objDonationEmailDetails = new DonationEmails();
$objDonationEmailDetails->SendDonationEmail($donation_Date, $donar_id, $campaign_id, $campaignName, $ngoName, $ngoOwnerEmail, $donarName, $donarEmail, $donarMobileNo, $donationAmount);
} else {
$this->data = "ERROR";
}
//$this->data=array('donationDetails' => $donationDetails,'donationSave' => $response);
} catch (Exception $e) {
echo 'SQL Exception: ' . $e->getMessage();
}
return $this->data;
}
