관리-도구

편집 파일: sequence_records.php

<?php
$mysqli = $info['mysqli'];
$pref = $info['dbpref'];
if (isset($_POST['delrecid'])) {
  $id = $_POST['delrecid'];
  $delete = "delete from `" . $pref . "quick_sequence` where id=" . $id;
  $mysqli->query($delete);
}

$id = $_GET['id'];
$id = $mysqli->real_escape_string($id);
if ($id == "old") {
  $sequence_id = " `sequence_id`='0' and";
  $fetch = "Old Sequence Email";
} else {
  $sequence_id = " `sequence_id`=$id and";
  $rows = $mysqli->query("SELECT `title` FROM `" . $pref . "new_sequence` WHERE `id`=$id");
  $fetch = $rows->fetch_assoc()['title'];
  $fetch .= " Emails Records";
}

$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('time');
if (strlen($date_between[0]) > 1) {
  $timelimit_condition = $date_between[0];
}
if (isset($_POST['onpage_search']) && strlen($_POST['onpage_search']) > 0) {
  $_POST['onpage_search'] = $mysqli->real_escape_string($_POST['onpage_search']);
  $query = "SELECT * FROM `" . $pref . "quick_sequence` where (`title` like '%" . $_POST['onpage_search'] . "%' or `sentdata` like '%" . $_POST['onpage_search'] . "%') and $sequence_id  `sequence` not in('compose')";
} else {
  $order_by = '`id` desc';
  if (isset($_GET['arrange_records_order'])) {
    $order_by = base64_decode($_GET['arrange_records_order']);
  }

$query = "SELECT * FROM `" . $pref . "quick_sequence` where `sequence` not in('compose')  and $sequence_id " . $timelimit_condition . " order by " . $order_by . " LIMIT " . $start_from . ", " . get_option('qfnl_max_records_per_page') . "";
}

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

$page_query = $mysqli->query("select count(`id`) as `countid` from `" . $pref . "quick_sequence` where  `sequence` not in('compose') and $sequence_id  " . $timelimit_condition . "");
$page_ob =  $page_query->fetch_object();

$link = '<a href="index.php?page=sequences"  style="cursor:pointer">' . $fetch . '</a>';
?>
<div class="container-fluid">
  <div class="card pb-2  br-rounded" id="hidecard1">
    <div class="card-body pb-2" id="hidecard2">
      <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 echo t("Search With Email Title"); ?>" onkeyup="searchSequence(this.value)">
            </div>
          </div>
        </div>
      </div>
      <div class="row">
        <div class="col-sm-12 ">
          <div class="table-responsive">
            <table class="table table-striped">
              <thead>
                <tr>
                  <th>#</th>
                  <th><?php w("Email&nbsp;Title"); ?></th>
                  <th><?php w("Selected Lists"); ?></th>
                  <th><?php w("Sequenced"); ?></th>
                  <th><?php w("Created On"); ?></th>
                  <th><?php w("Action"); ?></th>
                </tr>
              </thead>
              <tbody id="keywordsearchresult">
                
                <?php
                while ($res = $result->fetch_assoc()) {
                  $usedbylists = 0;
                  $getlistidtrim = explode("@", trim($res['listid'], '@'));
                  if (array_search("all", $getlistidtrim) >= 0) {
                    $usedbylists = "all";
                  } elseif (is_numeric($getlistidtrim[0])) {
                    $usedbylists = count($getlistidtrim);
                  }
                  ++$hashcount;
                  $num = $result->num_rows;
                  $listid = $res['listid'];
                  $list = "";
                  if (strpos($listid, '@all@') !== false) {
                    $list = "<a href='index.php?page=listrecords'><i>All Lists</i></a>";
                  } else {
                    $sel = "select id,title from `" . $pref . "quick_list_records` where id in (" . trim(str_replace('@', ',', $listid), ',') . ")";
                    $listquery = $mysqli->query($sel);
                    while ($lists = $listquery->fetch_assoc()) {
                      $list .= "<a href='index.php?page=createlist&listid=" . $lists['id'] . "'>" . $lists['title'] . "</a>, ";
                    }
                  }
                  $title = htmlentities($res['title']);
                  $action = "<table class='actionedittable'><tr><td><a href='index.php?page=sequence&seqid=" . $res['id'] . "&sequence_id=" . $id . "'><button class='btn unstyled-button' style='' data-bs-toggle='tooltip' title='" . t("Edit Email") . "'><i class='fas fa-edit text-primary'></i></button></a></td><td><form action='' method='post' onsubmit=\"return confirmDeletion(this,event,'" . $usedbylists . "','sequence')\"><input type='hidden' value='" . $res['id'] . "' name='delrecid'><button type='submit' class='btn unstyled-button'  data-bs-toggle='tooltip' title='" . t('Delete Email') . "'><i class='fas fa-trash text-danger'></i></button></form></td></tr></table>";

$sequenceed_on = ($res['sequence'] < 1) ? t('During Signup') : t("After \${1} Days", array($res['sequence']));
                  if ($res['sequence'] == '1') {
                    $sequenceed_on = t("Next day");
                  }
                  echo "<tr>
          <td>" . t($hashcount) . "</td>
          <td>" . $title . "</td>
          <td>" . rtrim($list, ",") . "</td>
          <td>" . $sequenceed_on . "</td>
          <td>" . date('d-M-Y h:ia', $res['time']) . "</td>
          <td>" . $action . "</td>
        </tr>";
                }
                ?>
                <tr>
                  <td colspan=10 class="total-data"> <?php w("Total Emails"); ?>: <?php echo t($page_ob->countid); ?></td>
                </tr>
                
              </tbody>
            </table>
          </div>
          <div class="col-sm-12 row pt-2">
            <div class="col-sm-6 me-auto">
              <?php
              $currentpage = 0;

if (isset($_GET['pagecount'])) {
                $currentpage = $_GET['pagecount'];
              }
              $pagenow = $_SERVER['REQUEST_URI'] . "&pagecount";
              echo createPager($page_ob->countid, $pagenow, $currentpage);
              ?>
            </div>
            <div class="col-sm-6">
              <a href="index.php?page=sequence&&sequence_id=<?= $id ?>"><button class="btn theme-button" style="float:right;"><strong><i class="fas fa-pencil-alt"></i> <?php w("Create New"); ?></strong></button></a>
            </div>
          </div>
        </div>
      </div>
    </div>
  </div>
</div>
<script>
  document.getElementById("commoncontainerid").innerHTML = `<?= $link ?>`;

function searchSequence(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>