{source}<?php
$formid=$_GET['frmid'];
$userid=$_GET['usid'];
$db = JFactory::getDBO();
$query = $db->getQuery(true);
if($formid!="" && $userid!='')
{
$status="true";
$fields = array(
$db->quoteName('approved') .'='. $db->q($status)
);
$conditions = array(
$db->quoteName('form') .'='. $db->q($formid),
$db->quoteName('user_id') .'='. $db->q($userid)
);
$query->update($db->quoteName('#__facileforms_records'))
->set($fields)
->where($conditions);
$db->setQuery($query)
->execute();
$db->setQuery("Select * From #__facileforms_records where form='".$formid."' AND user_id='".$userid."'");
$formrecords = $db->loadAssocList();
if($formrecords[0]['approved']=="true")
{
echo '<p style="color:green;"> Request Approved </p>';
}
?>
<table style="border-color: #000000; background-color: #eeeeee;" cellpadding="10" border="1"><tbody>
<tr>
<td style="text-align: left;"><b>Form Name</b></td>
<td style="text-align: left;" width="125px"><b>Submitted Date</b></td>
<td style="text-align: center;"><b>User Name</b></td>
<td style="text-align: center;"><b>Full Name</b></td>
<td style="text-align: center;"><b>Status</b></td>
</tr>
<tr>
<td style="text-align: left;"><?php if($formrecords[0]['title']!="") { echo $formrecords[0]['title'];} ?></td>
<td style="text-align: left;"><?php if($formrecords[0]['submitted']!="") { echo $formrecords[0]['submitted'];} ?></td>
<td style="text-align: center;"><?php if($formrecords[0]['username']!="") { echo $formrecords[0]['username'];} ?></td>
<td style="text-align: center;"><?php if($formrecords[0]['user_full_name']!="") { echo $formrecords[0]['user_full_name'];} ?></td>
<td style="text-align: center;"><?php if($formrecords[0]['approved']!="") { echo "<strong>".$formrecords[0]['approved']."</strong>";} ?></td>
</tr>
</tbody>
</table>
<?php
}
?>
<?php
if($formrecords[0]['approved']=="true")
{
$useremails=$db->getQuery(true);
$queryuserdetails = $db->getQuery(true);
$queryuserdetails = "SELECT * FROM `#__users` WHERE id='".$userid."'";
$db->setQuery($queryuserdetails);
$resultusers = $db->loadAssocList();
$usertoemail=$resultusers[0]['email'];

$queryrecord = $db->getQuery(true);
$queryrecord = "SELECT * FROM `#__facileforms_records` WHERE form = '".$formid."' AND user_id='".$userid."'";
$db->setQuery($queryrecord);
$resultrecords = $db->loadAssocList();
$entryid=$resultrecords[0]['id'];
$querypageheading = $db->getQuery(true);
$querypageheading = "SELECT `id`,`title`,`name`,`value` FROM `#__facileforms_subrecords` WHERE record = '".$entryid."' AND type!='Hidden Input'";
$db->setQuery($querypageheading);
$resultpage = $db->loadAssocList();

/* Customer Email Code start here */

$body='<table style="border-color: #000000; background-color: #eeeeee;" cellpadding="10" border="1"><tbody><tr>
<td style="text-align: left;"><b>Name</b></td>
<td style="text-align: center;"><b>Value</b></td>
</tr>';
for($k=0;$k<count($resultpage);$k++)
{
$body .='<tr>
<td style="text-align: left;">'.$resultpage[$k]['title'].'</td>
<td style="text-align: left;">'.$resultpage[$k]['value'].'</td>
</tr>';
}
echo '</tbody></table>';

$to = $usertoemail;
$from = This email address is being protected from spambots. You need JavaScript enabled to view it.';
$fromName = 'Anglo-Suisse Capital Limited';

$subject = "".$formrecords[0]['title']."";
$htmlContent = $body;
$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type:text/html;charset=UTF-8" . "\r\n";

// Additional headers
$headers .= 'From: '.$fromName.'<'.$from.'>' . "\r\n";
// Send email
if(mail($to, $subject, $htmlContent, $headers)){
//echo 'Email has sent successfully.';
}else{
//echo 'Email sending failed.';
}
/*Customer Email code end here */

/*Super Admin email code start here */

/*Super admin email code end here */

}
?>{/source}