관리-도구

편집 파일: smtp_table.php

<?php 
$mysqli=$info['mysqli'];
$pref=$info['dbpref'];
if (isset($_POST['userid'])) {
  $id = $_POST['userid'];
  $delete ="delete from `".$pref."quick_smtp_setting` where id=".$id;
  $mysqli->query($delete);
}
$start_from=0;
if(isset($_GET["pagecount"]))
{
  $start_from=($_GET['pagecount']*get_option('qfnl_max_records_per_page'))-get_option('qfnl_max_records_per_page');
}
$hashcount=$start_from;
$timelimit_condition=1;
  $date_between=dateBetween('created_at');
  if(strlen($date_between[0])>1)
  {
    $timelimit_condition=$date_between[0];
  }
$getcountofusing="(select count(`id`)from `".$pref."quick_sequence` where `smtpid`=`".$pref."quick_smtp_setting`.id) as `usedby_sequence`,(select count(`id`)from `".$pref."quick_funnels` where `primarysmtp`=`".$pref."quick_smtp_setting`.id) as `usedby_funnel`";
if(isset($_POST['onpage_search'])&& strlen($_POST['onpage_search'])>0)
{
  $_POST['onpage_search']=$mysqli->real_escape_string($_POST['onpage_search']);

$keyword_search="`title` like '%".$_POST['onpage_search']."%' or `hostname` like '%".$_POST['onpage_search']."%' or `port` like '%".$_POST['onpage_search']."%' or `encryption` like '%".$_POST['onpage_search']."%' or `fromname` like '%".$_POST['onpage_search']."%' or `fromemail` like '%".$_POST['onpage_search']."%' or `username` like '%".$_POST['onpage_search']."%' or `replyname` like '%".$_POST['onpage_search']."%' or `replyemail` like '%".$_POST['onpage_search']."%'";

$query = "SELECT *,".$getcountofusing." FROM `".$pref."quick_smtp_setting` where ".$keyword_search."  order by `id` DESC";
}
else
{
  $order_by='`id` desc';
  if(isset($_GET['arrange_records_order']))
  {
    $order_by=base64_decode($_GET['arrange_records_order']);
  }

$query = "SELECT *,".$getcountofusing." FROM `".$pref."quick_smtp_setting` where ".$timelimit_condition." order by ".$order_by." LIMIT ".$start_from.", ".get_option('qfnl_max_records_per_page')."";
}

$result = $mysqli->query($query);

$totalpage_query=$mysqli->query("select count(`id`) as `countid` from `".$pref."quick_smtp_setting` where ".$timelimit_condition."");
    $total_ob=$totalpage_query->fetch_object();
?>
<div class="container-fluid ">
<div class="mx-1 mx-sm-3">
<div class="row">
					<div class="col-md-2 mb-2">
					<?php echo createSearchBoxBydate(); ?>
					</div>
					<div class="col-md-3">
					<?php echo showRecordCountSelection(); ?>
          </div>
          <div class="col-md-3">
					<?php echo arranger(array('id'=>'date')); ?>
					</div>
					<div class="col-md-4">
					<div class="mb-3">
						<div class="input-group input-group-sm">
							<div class="input-group-prepend ">
								<span class="input-group-text"><i class="fas fa-search"></i></span>
							</div>
							 <input type="text" class="form-control form-control-sm" placeholder="<?php w("Enter SMTP Title Or Other Crentials"); ?>" onkeyup="searchSMTP(this.value)">
						</div>
					</div>
					</div>
</div>
</div>
<div class="pb-2 border m-3 bg-white  br-rounded cf-course-chbtn" id="hidecard1">
    <div class="pb-2" id="hidecard2">

<div class="row" id="smtpcontainer">
<div class="col-md-12 ">
  <div class="table-responsive">
      <table class="table table-striped">
      <thead>
        <tr>
          <th>#</th>
          <th><?php w("Title"); ?></th>
          <th><?php w("Host Name"); ?></th>
          <th><?php w("Username"); ?></th>
          <th><?php w("Date Created"); ?></th>
          <th><?php w("Action"); ?></th>
        </tr>
      </thead>
<tbody id="keywordsearchresult">

<?php 
while($res= $result->fetch_assoc())
{
          ++$hashcount;
          $action="<table class='actionedittable mx-auto'><tr><td><a href='index.php?page=smtp_create&id=".$res['id']."'><button class='btn btn-primary' style='' data-bs-toggle='tooltip' title='".t('Edit')."'><i class='fas fa-edit'></i></button></a></td><td><button class='btn btn-info text-white' data-bs-toggle='tooltip' title='".t("Test This SMTP")."' onclick=testSMTP(".$res['id'].",'".base64_encode($res['title'])."')><i class='fas fa-eye text-white '></i></button></td><td><form action='' method='post' onsubmit='return confirmDeletionSMTP(".$res['usedby_sequence'].",".$res['usedby_funnel'].",event,this);'><input type='hidden' value='".$res['id']."' name='userid'  ><button type='submit' class='btn btn-danger' value='".$res['id']."' name='userid' data-bs-toggle='tooltip' title='".t("Delete SMTP")."'><i class='fas fa-trash '></i></button></form></td></tr></table>";

echo "<tr class='text-left'>
          <td>".t($hashcount)."</td>
          <td>".$res['title']."</td>
          <td>".$res['hostname']."</td>
          <td>".$res['username']."</td>
          <td  class='text-right'>".date('d-M-Y h:ia',$res['created_at'])."</td>
          <td>".$action."</td>
        </tr>";
      }
     ?>
    
<tr><td colspan=10 class='total-data' style=""><?php w("Total SMTPs"); ?>: <?php echo t($total_ob->countid); ?></td></tr>
</tbody>

</table>
    </div>

<div class="col-sm-12 row nopadding">
<div class="col-sm-6 mt-2">
<?php 
    $nextpageurl=$_SERVER['REQUEST_URI']."&pagecount";
    $current_page=0;
    if(isset($_GET['pagecount']))
    {
      $current_page=$_GET['pagecount'];
    }
    echo createPager($total_ob->countid,$nextpageurl,$current_page);
    ?>
</div>
<div class="col-sm-6 mt-2 text-right">
<?php if($_SESSION['user_plan_type' . $site_token_for_dashboard]==2 && $total_ob->countid>=1 ) {
?>
<a data-bs-toggle="modal" data-bs-target="#upgradeFromFreeModal"><button class="btn theme-button" > <?php w("Create New"); ?></button></a>
<?php } else {
	?>
<a href="index.php?page=smtp_create"><button class="btn theme-button"><i class="fas fa-pencil-alt"></i> <?php w("Create New"); ?></button></a>
<?php
} ?>
</div>
</div>

</div></div></div></div></div>

var div=document.createElement("div");

div.innerHTML=divdata;

document.getElementById("smtpcontainer").appendChild(div);

var smtpivclose=function(){document.getElementById("smtpcontainer").removeChild(div);dbgcontainer=0;};

doEscapePopup(smtpivclose);
  document.getElementById("closesmtptestdiv").onclick=function(){smtpivclose()};
  dbgcontainer=div;
  var request=new ajaxRequest();
  
  div.getElementsByTagName("button")[0].onclick=function()
  {
   var errspan=div.getElementsByTagName("span")[0];
   div.getElementsByTagName("p")[0].innerHTML="";
   errspan.innerHTML="<font color='green'>"+t("Sending Please Wait...")+"</font>";
   var debug=div.getElementsByTagName("select")[0].value;
   var inputs=div.getElementsByTagName("input");
   var reqstr={"qmlrtestsmtp":1,"toname":inputs[0].value,"toemail":inputs[1].value,"emailsubject":inputs[2].value,"emailbody":inputs[3].value,"debug":debug,"smtpid":id};
   request.postRequestCb('req.php',reqstr,function(data){
  data=data.trim();
  
  if(data=='1'){errspan.innerHTML="<font color='green'>"+t("Mail Sent Successfully")+"</font>";}
  else if(data=='0'){errspan.innerHTML="<font style='color:#e6005c;'>"+t("Unable To Send Mail")+"</font>";}
  else
  {
    errspan.innerHTML="<font color='green'>"+t("View Debug Data Below")+"</font>";
    div.getElementsByTagName("p")[0].innerHTML="<br><strong><u>"+t("Debugged Data")+": </u></strong><br>"+data;
  }
  });
  };
}

function searchSMTP(search)
{
var ob=new OnPageSearch(search,"#keywordsearchresult");
ob.url="<?php echo getProtocol();?>";
ob.url +="<?php echo $_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI']; ?>";
ob.search();
}

}
</script>