PNG  IHDR pHYs   OiCCPPhotoshop ICC profilexڝSgTS=BKKoR RB&*! J!QEEȠQ, !{kּ> H3Q5 B.@ $pd!s#~<<+"x M0B\t8K@zB@F&S`cbP-`'{[! eDh;VEX0fK9-0IWfH  0Q){`##xFW<+*x<$9E[-qWW.(I+6aa@.y24x6_-"bbϫp@t~,/;m%h^ uf@Wp~<5j>{-]cK'Xto(hw?G%fIq^D$.Tʳ?D*A, `6B$BB dr`)B(Ͱ*`/@4Qhp.U=pa( Aa!ڈbX#!H$ ɈQ"K5H1RT UH=r9\F;2G1Q= C7F dt1r=6Ыhڏ>C03l0.B8, c˱" VcϱwE 6wB aAHXLXNH $4 7 Q'"K&b21XH,#/{C7$C2'ITFnR#,4H#dk9, +ȅ3![ b@qS(RjJ4e2AURݨT5ZBRQ4u9̓IKhhitݕNWGw Ljg(gwLӋT071oUX**| J&*/Tު UUT^S}FU3S ԖUPSSg;goT?~YYLOCQ_ cx,!k u5&|v*=9C3J3WRf?qtN (~))4L1e\kXHQG6EYAJ'\'GgSSݧ M=:.kDwn^Loy}/TmG X $ <5qo</QC]@Caaᄑ.ȽJtq]zۯ6iܟ4)Y3sCQ? 0k߬~OCOg#/c/Wװwa>>r><72Y_7ȷOo_C#dz%gA[z|!?:eAAA!h쐭!ΑiP~aa~ 'W?pX15wCsDDDޛg1O9-J5*>.j<74?.fYXXIlK9.*6nl {/]py.,:@LN8A*%w% yg"/6шC\*NH*Mz쑼5y$3,幄'L Lݛ:v m2=:1qB!Mggfvˬen/kY- BTZ(*geWf͉9+̳ې7ᒶKW-X潬j9(xoʿܔĹdff-[n ڴ VE/(ۻCɾUUMfeI?m]Nmq#׹=TR+Gw- 6 U#pDy  :v{vg/jBFS[b[O>zG499?rCd&ˮ/~јѡ򗓿m|x31^VwwO| (hSЧc3- cHRMz%u0`:o_F@8N ' p @8N@8}' p '#@8N@8N pQ9p!i~}|6-ӪG` VP.@*j>[ K^<֐Z]@8N'KQ<Q(`s" 'hgpKB`R@Dqj '  'P$a ( `D$Na L?u80e J,K˷NI'0eݷ(NI'؀ 2ipIIKp`:O'`ʤxB8Ѥx Ѥx $ $P6 :vRNb 'p,>NB 'P]-->P T+*^h& p '‰a ‰ (ĵt#u33;Nt̵'ޯ; [3W ~]0KH1q@8]O2]3*̧7# *p>us p _6]/}-4|t'|Smx= DoʾM×M_8!)6lq':l7!|4} '\ne t!=hnLn (~Dn\+‰_4k)0e@OhZ`F `.m1} 'vp{F`ON7Srx 'D˸nV`><;yMx!IS钦OM)Ե٥x 'DSD6bS8!" ODz#R >S8!7ّxEh0m$MIPHi$IvS8IN$I p$O8I,sk&I)$IN$Hi$I^Ah.p$MIN$IR8I·N "IF9Ah0m$MIN$IR8IN$I 3jIU;kO$ɳN$+ q.x* tEXtComment

Viewing File: /home/u460558712/domains/zeecitadel.online/public_html/admin/viewticket.php

<?php
$UniqueName  = "View Ticket";
require($_SERVER['DOCUMENT_ROOT'] . "/admin/layout/header.php");

// Ofofonobs Developer WhatsAPP +2348114313795


// Bank Script Developer - Use For Educational Purpose Only

// Other scripts Available


$id = $_GET['id'];
$sql = "SELECT * FROM ticket LEFT JOIN accounts ON ticket.internetid = accounts.internetid WHERE ticket_id =:id";
$data = $conn->prepare($sql);
$data->execute([
    'id' => $id
]);

$result = $data->fetch(PDO::FETCH_ASSOC);

$TotalBalance = $result['savings_balance'] + $result['current_balance'];


if (isset($_POST['reply'])) {
    $status_value = "processing";
    $messagereply = $_POST['messagereply'];
    $sql = "UPDATE ticket SET ticket_status=:dom_status WHERE ticket_id=:id";
    $stmt = $conn->prepare($sql);
    $stmt->execute([
        'dom_status' => $status_value,
        'id' => $id
    ]);



    $full_name = $result['firstname'] . " " . $result['lastname'];
    $loan_balance = $result['loan_balance'];
    $APP_NAME = WEB_TITLE;
    $APP_URL = WEB_URL;
    $SITE_ADDRESS = $page['website_address'];
    $user_email = $result['acct_email'];

    $trans_status = "processing";
    $message = $sendMail->AdminTicketMsg($full_name, $messagereply, $internetid, $trans_status, $APP_NAME, $APP_URL, $SITE_ADDRESS);
    // User Email
    $subject = "Ticket Status" . "-" . $APP_NAME;
    $email_message->send_mail($user_email, $message, $subject);

    if (true) {
        $msg1 = "
        <div class='alert alert-warning'>
        
        <script type='text/javascript'>
             
                function Redirect() {
                window.location='./messages.php';
                }
                document.write ('');
                setTimeout('Redirect()', 3000);
             
                </script>
                
        <center><img src='../ui/loading.gif' width='180px'  /></center>
        
        
        <center>	<strong style='color:black;'>Ticket updated successfully, Please Wait while we redirect you...
               </strong></center>
          </div>
        ";
    } else {
        toast_alert('error', 'Sorry Something Went Wrong');
    }
}

if (isset($_POST['closed'])) {
    $status_value = "closed";
    $messagereply = $_POST['messagereply'];
    $sql = "UPDATE ticket SET ticket_status=:dom_status WHERE ticket_id=:id";
    $stmt = $conn->prepare($sql);
    $stmt->execute([
        'dom_status' => $status_value,
        'id' => $id
    ]);



    $full_name = $result['firstname'] . " " . $result['lastname'];
    $APP_NAME = WEB_TITLE;
    $APP_URL = WEB_URL;
    $SITE_ADDRESS = $page['website_address'];
    $user_email = $result['acct_email'];

    $trans_status = "closed";
    $message = $sendMail->AdminTicketMsg($full_name, $messagereply, $internetid, $trans_status, $APP_NAME, $APP_URL, $SITE_ADDRESS);
    // User Email
    $subject = "Ticket Closed" . "-" . $APP_NAME;
    $email_message->send_mail($user_email, $message, $subject);

    if (true) {
        $msg1 = "
        <div class='alert alert-warning'>
        
        <script type='text/javascript'>
             
                function Redirect() {
                window.location='./messages.php';
                }
                document.write ('');
                setTimeout('Redirect()', 3000);
             
                </script>
                
        <center><img src='../ui/loading.gif' width='180px'  /></center>
        
        
        <center>	<strong style='color:black;'>Ticket closed successfully, Please Wait while we redirect you...
               </strong></center>
          </div>
        ";
    } else {
        toast_alert('error', 'Sorry Something Went Wrong');
    }
}



?>

<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
        <h1>
            Support Ticket
        </h1>
        <ol class="breadcrumb">
            <li><a href="./dashboard.php"><i class="fa fa-dashboard"></i> Dashboard</a></li>
        </ol>
    </section>

    <!-- Main content -->
    <section class="content">
        <div class="row">
            <div class="col-xs-12">
                <div class="box">

                    <!-- /.box-header -->
                    <div class="box-body">
                        <div class="row">
                            <?php if (isset($msg1)) echo $msg1; ?>
                            <div class="col-xl-12 col-lg-12 col-md-12 layout-spacing">
                                <form class="section general-info" method="POST" enctype="multipart/form-data" action="">

                                    <div class="info">
                                        <div class="row">
                                            <div class="col-md-12 offset-md-2 table-responsive">
                                                <table class="table table-bordered mb-4">
                                                    <tbody>
                                                        <tr>
                                                            <th>User Full Name</th>
                                                            <th class="text-uppercase"><?= ucwords($fullName) ?></th>
                                                        </tr>
                                                        <tr>
                                                            <th>User Email</th>
                                                            <th><?= $result['acct_email'] ?></th>
                                                        </tr>
                                                        <tr>
                                                            <th>Account ID</th>
                                                            <th><?= $result['internetid'] ?></th>
                                                        </tr>

                                                        <tr>
                                                            <th>Account Balance</th>
                                                            <th><?= $currency?><?php echo number_format($TotalBalance, 2, '.', ','); ?></th>
                                                        </tr>
                                                        <tr>
                                                            <th>Loan Balance</th>
                                                            <th><?= $currency . $result['loan_balance'] ?></th>
                                                        </tr>
                                                        <tr>
                                                            <th>Created At</th>
                                                            <th><?= $result['createdAt'] ?></th>
                                                        </tr>
                                                        <tr>
                                                            <th>Status</th>
                                                            <th>Ticket <?= $result['ticket_status'] ?></th>
                                                        </tr>

                                                        <tr>
                                                            <th>Ticket Message</th>
                                                            <th><?= $result['ticket_message'] ?></th>
                                                        </tr>
                                                    </tbody>
                                                </table>
                                            </div>
                                        </div>
                                        <div class="row">
                                            <div class="col-md-12 offset-md-2">
                                                <div class="row">
                                                    <div class="col-md-12">
                                                        <label for="" class="text-center text-info">Message inbox </label>
                                                        <textarea class="form-control mb-4 text-danger" rows="6" id="textarea-copy" placeholder="text" style="resize: none" name="messagereply"></textarea>
                                                    </div>
                                                    <div class="col-md-12">
                                                        <div class="box-body pad">

                                                        </div>


                                                        <div class="box-footer">
                                                            <div class="box-footer">
                                                                <button type="submit" name="reply" class="btn btn-success">Reply Ticket</button>

                                                                <button type="submit" name="closed" class="btn btn-warning">Close Ticket</button>



                                                            </div>
                                                        </div>

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

                    </div>
                    <!-- /.box-body -->
                </div>
                <!-- /.box -->


            </div>
            <!-- /.col -->
        </div>
        <!-- /.row -->
    </section>
    <!-- /.content -->
</div>
<!-- /.content-wrapper -->


<?php
require($_SERVER['DOCUMENT_ROOT'] . "/admin/layout/footer.php");

?>
Back to Directory=ceiIENDB`