public function SendDonationEmail($donation_Date, $donar_id, $campaign_id, $campaignName, $ngoName, $ngoOwnerEmail, $donarName, $donarEmail, $donarMobileNo, $donationAmount)
{
$this->setEmail($email);
$this->setNgoOwnerEmail($ngoOwnerEmail);
//email for customer
$returnEmailForUser = new DonationEmails();
$returnEmailForUser->GenarateEmailForDonar($donation_Date, $donar_id, $campaign_id, $campaignName, $ngoName, $ngoOwnerEmail, $donarName, $donarEmail, $donarMobileNo, $donationAmount);
//email for us
$returnEmailForNgoOwner = new DonationEmails();
$returnEmailForNgoOwner->GenarateEmailForNgoOwner($donation_Date, $donar_id, $campaign_id, $campaignName, $ngoName, $ngoOwnerEmail, $donarName, $donarEmail, $donarMobileNo, $donationAmount);
//email to peto
$returnEmailForPeto = new DonationEmails();
$returnEmailForPeto->GenarateEmailForPeto($donation_Date, $donar_id, $campaign_id, $campaignName, $ngoName, $ngoOwnerEmail, $donarName, $donarEmail, $donarMobileNo, $donationAmount);
$returnEmailSuccessMessage = "EMAIL_SUCCESSFULLY_SENT";
return $returnEmailSuccessMessage;
}
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;
}
$sql = mysqli_query($con, $lastDate);
$NGODetails = array();
while ($rowdata = mysqli_fetch_assoc($sql)) {
$NGODetails[] = $rowdata;
}
//mysqli_close($con);
//print_r ($NGODetails);
foreach ($NGODetails as $value) {
$con->options(MYSQLI_OPT_CONNECT_TIMEOUT, 500);
$campaign_id = $value['campaign_id'];
$campaignName = $value['campaignName'];
$ngoName = $value['ngoName'];
$ngoOwnerEmail = $value['email'];
$lastDateOfCampaign = $value['lastDate'];
$postedDateOfCampaign = $value['postDate'];
//send email
$objCampaignDeleteDetails = new DonationEmails();
$objCampaignDeleteDetails->SendCampaignDeleteDateWiseEmail($campaign_id, $campaignName, $ngoName, $ngoOwnerEmail, $lastDateOfCampaign, $postedDateOfCampaign);
}
//delete todays campaign list
try {
$sql = "DELETE FROM campaign WHERE lastDate = 'currentDateTime'";
$isRemoved = mysqli_query($con, $sql);
if ($isRemoved) {
echo "Campign Successfully Deleted";
} else {
echo "ERROR_WHILE_REMOVING";
}
} catch (Exception $e) {
echo 'SQL Exception: ' . $e->getMessage();
}
