$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"];