$result = $con->query($sqlquery);
if (!$result) {
$flag = 0;
die("CALL failed: (" . $con->errno . ") " . $con->error);
}
$select = $con->query('SELECT @SUCCESS_FLAG');
$result = $select->fetch_assoc();
$flag = $result['@SUCCESS_FLAG'];
if ($flag == 1) {
$select_emailtemp = mysqli_query($con, "SELECT ETD_EMAIL_SUBJECT, ETD_EMAIL_BODY FROM LMC_EMAIL_TEMPLATE_DETAILS WHERE ETD_ID=8");
if ($row = mysqli_fetch_array($select_emailtemp)) {
$sub = $row["ETD_EMAIL_SUBJECT"];
$msgbody = $row["ETD_EMAIL_BODY"];
}
$emailbody = str_replace("[UNAME]", $name, $msgbody);
Mail_part($sub, $emailbody, $finaltable, $reportheadername);
}
echo $flag;
}
function Mail_part($sub, $emailbody, $finaltable, $reportfilename)
{
global $con;
try {
$select_to = mysqli_query($con, "SELECT * FROM LMC_USER_LOGIN_DETAILS WHERE RC_ID=2");
if ($row = mysqli_fetch_array($select_to)) {
$toaddress = $row["ULD_EMAIL_ID"];
}
$select_cc = mysqli_query($con, "SELECT * FROM LMC_USER_RIGHTS_CONFIGURATION WHERE URC_ID=10");
if ($row = mysqli_fetch_array($select_cc)) {
$ccaddress = $row["URC_DATA"];
}
$deltpath = $dir.$parentfolder.DIRECTORY_SEPARATOR.$userfolderid.DIRECTORY_SEPARATOR.$old_imgfileid;
$dir.$parentfolder.DIRECTORY_SEPARATOR.$userfolderid.DIRECTORY_SEPARATOR;
unlink($deltpath);
}
if($flag==1){
$select_emailtemp=mysqli_query($con,"SELECT ETD_EMAIL_SUBJECT, ETD_EMAIL_BODY FROM LMC_EMAIL_TEMPLATE_DETAILS where ETD_ID=4");
if($row=mysqli_fetch_array($select_emailtemp)){
$sub=$row["ETD_EMAIL_SUBJECT"];
$msgbody=$row["ETD_EMAIL_BODY"];
}
$emailbody = str_replace("[LOGINID]",$empnames, $msgbody);
// pdf attachment name
$reportfilename='TIME SHEET UPDATED REPORT FOR '.$empnames.'.pdf';
// excel attachment name
$xlreportfilename='TIME SHEET UPDATED REPORT FOR '.$empnames.'.xls';
Mail_part($sub,$emailbody,$finaltable,$reportfilename,$update_exldata,$xlreportfilename);
}
$flagvalues=array($flag,$dirflag,$writable);
echo json_encode($flagvalues);
}
// MAIL SEND PART
function Mail_part($sub,$emailbody,$finaltable,$reportfilename,$reportexldata,$xlreportfilename){
global $con;
try {
$select_to = mysqli_query($con, "SELECT * FROM LMC_USER_LOGIN_DETAILS WHERE RC_ID=2");
if ($row = mysqli_fetch_array($select_to)) {
$toaddress = $row["ULD_EMAIL_ID"];
}
$select_cc = mysqli_query($con, "SELECT * FROM LMC_USER_RIGHTS_CONFIGURATION WHERE URC_ID=10");
if ($row = mysqli_fetch_array($select_cc)) {
$ccaddress = $row["URC_DATA"];
