<?php

/*===============================================*\
|| ############################################# ||
|| # JAKWEB.CH / Version 2.0.6                 # ||
|| # ----------------------------------------- # ||
|| # Copyright 2022 JAKWEB All Rights Reserved # ||
|| ############################################# ||
\*===============================================*/

// Check if the file is accessed only via index.php if not stop the script from running
if (!defined('JAK_ADMIN_PREVENT_ACCESS')) die('You cannot access this file directly.');

// Check if the user has access to this file
if (!JAK_ADMINACCESS) jak_redirect(BASE_URL);

//Import the PHPMailer class into the global namespace
use PHPMailer\PHPMailer\PHPMailer;
use PHPMailer\PHPMailer\SMTP;
use PHPMailer\PHPMailer\Exception;
// use PHPMailer\PHPMailer\OAuth;
//Alias the League Google OAuth2 provider class
// use League\OAuth2\Client\Provider\Google;

// Change for 1.0.3
use JAKWEB\JAKsql;

// All the tables we need for this plugin
$errors = array();
$jaktable = 'support_tickets';

if (!empty(JAKDB_MAIN_NAME) && JAK_MAIN_LOC && JAK_MAIN_OP) {
  
  // Database connection to the main site
  $jakdb1 = new JAKsql([
    // required
    'database_type' => JAKDB_MAIN_DBTYPE,
    'database_name' => JAKDB_MAIN_NAME,
    'server' => JAKDB_MAIN_HOST,
    'username' => JAKDB_MAIN_USER,
    'password' => JAKDB_MAIN_PASS,
    'charset' => 'utf8',
    'port' => JAKDB_MAIN_PORT,
    'prefix' => JAKDB_MAIN_PREFIX,
               
    // [optional] driver_option for connection, read more from http://www.php.net/manual/en/pdo.setattribute.php
    'option' => [PDO::ATTR_CASE => PDO::CASE_NATURAL]
    ]);

  // Get all answers
  $totalAll = $jakdb1->count($jaktable, "id", ["AND" => ["opid" => JAK_USERID, "status[!]" => 2]]);
     
  if ($totalAll != 0) {

    // Paginator
    $tickets = new JAK_Paginator;
    $tickets->items_total = $totalAll;
    $tickets->mid_range = 10;
    $tickets->items_per_page = 20;
    $tickets->jak_get_page = $page1;
    $tickets->jak_where = JAK_rewrite::jakParseurl('tickets');
    $tickets->paginate();
    $JAK_PAGINATE = $tickets->display_pages();

    // Ouput all tickets, well with paginate of course  
    $TICKETS_ALL = $jakdb1->select($jaktable, "*", ["AND" => ["opid" => JAK_USERID, "status[!]" => 2], "ORDER" => ["sent" => "DESC"], "LIMIT" => $tickets->limit]);
        
  }

  // Ok, we need some stuff from the settings table
  $sett = array();
  $settings = $jakdb1->select("settings", ["varname", "used_value"]);
  foreach ($settings as $v) {
      $sett[$v["varname"]] = $v["used_value"]; 
  }

  // Get all admins
  $admins = array();
  $admins = $jakdb1->select("admins", ["name", "email"], ["access" => 1]);

  // Now start with the plugin use a switch to access all pages
  switch ($page1) {

    case 'r':

      if (isset($page2) && is_numeric($page2) && $jakdb1->has($jaktable, ["id" => $page2])) {

        // Now get the user information
            $ticket = $jakdb1->get($jaktable, ["id", "subject", "content"], ["id" => $page2]);

            // Mark message as read
            $jakdb1->update($jaktable, ["readtime" => time()], ["id" => $page2]);

            // Title and Description
        $SECTION_TITLE = $jkl['g318'];
        $SECTION_DESC = '';

        // Form title
        $FORM_TITLE = $ticket["subject"];

        // Include the javascript file for results
        $js_file_footer = 'js_pages.php';

        // Call the template
        $template = 'tickets.php';

      } else {
        // No database information
        $_SESSION["errormsg"] = $jkl['i2'];
        jak_redirect(JAK_rewrite::jakParseurl('tickets'));
      }

    break;
    case 'a':

      if (isset($page2) && is_numeric($page2) && $jakdb1->has($jaktable, ["id" => $page2])) {

        $usr = $jakdb1->get("users", ["id", "username"], ["AND" => ["locationid" => JAK_MAIN_LOC, "opid" => JAK_USERID]]);

        if ($_SERVER['REQUEST_METHOD'] == 'POST') {
            $jkp = $_POST;
            
            if (isset($jkp['create_ticket'])) {

              if (empty($jkp['subject'])) {
                $errors['e'] = $jkl['e2'];
            }
            
                if ($jkp['content'] == '') { 
                  $errors['e1'] = $jkl['e1'];
                }

                if (count($errors) == 0) {

                  $timenow = time();
                        
                  // Insert the news for user(s)
              $jakdb1->insert($jaktable, ["userid" => $usr["id"],
                "opid" => JAK_USERID,
                "ticketid" => $page2,
                "username" => $usr["username"],
                "subject" => trim($jkp['subject']),
                "content" => trim($jkp['content']),
                "isnews" => 0,
                "status" => 3,
                "readtime" => $timenow,
                "sent" => $timenow]);

              // Set status from old ticket as solved
              $jakdb1->update($jaktable, ["status" => 2], ["id" => $page2]);

              // We start the email notifications
              $mail = new PHPMailer(); // defaults to using php "mail()" or optional SMTP

              // Get the email template
              $nlhtml = file_get_contents(APP_PATH.'template/'.JAK_FRONT_TEMPLATE.'/email/index.html');

                // We inform the site owner
                if ($sett["smtp"] == 1) {

                $mail->IsSMTP(); // telling the class to use SMTP
                $mail->Host = $sett["smtphost"];
                $mail->SMTPAuth = ($sett["smtpauth"] ? true : false); // enable SMTP authentication
                $mail->SMTPSecure = $sett["smtpprefix"]; // sets the prefix to the server
                $mail->SMTPKeepAlive = ($sett["smtpalive"] ? true : false); // SMTP connection will not close after each email sent
                $mail->Port = $sett["smtpport"]; // set the SMTP port for the GMAIL server
                $mail->Username = $sett["smtpusername"]; // SMTP account username
                $mail->Password = $sett["smtppass"];        // SMTP account password
                                
              }

              $mail->SetFrom($sett["emailaddress"]);

              // Send email to all admins
              if (isset($admins)) foreach ($admins as $ad) {
                # code...
                $mail->AddAddress($ad["email"]);
              }

              // Say Hello
              $webtext = '<h1>'.$sett["newtickettitle"].'</h1>';

              // Send the operator url
              $webtext .= sprintf($sett["newticketmsg"], $usr["username"]);

              // Get the link to the dashboard
              $webtext .= '<p><a href="'.jak_redirect(JAK_rewrite::jakParseurl('tickets')).'">'.$jkl['m31'].'</a></p>';
                  
              // Change fake vars into real ones.
              $cssAtt = array('{emailcontent}', '{weburl}', '{title}', '{emailtpllogo}', '{emailtplcopy}');
              $cssUrl   = array($webtext, $sett["webaddress"], $sett["newtickettitle"], JAK_EMAILTPLLOGO, JAK_EMAILTPLCOPY);
              $nlcontent = str_replace($cssAtt, $cssUrl, $nlhtml);
                
              $body = str_ireplace("[\]", "", $nlcontent);
                              
              $mail->Subject = $sett["newtickettitle"];
              $mail->MsgHTML($body);
              $mail->Send();

                $_SESSION["successmsg"] = $jkl['i7'];
                  jak_redirect(JAK_rewrite::jakParseurl('tickets'));

              } else {
                  $errors = $errors;
              }

            }
        }

        // Now get the user information
            $ticket = $jakdb1->get($jaktable, ["id", "subject", "content", "sent"], ["id" => $page2]);

            // Mark message as read
            $jakdb1->update($jaktable, ["readtime" => time()], ["id" => $page2]);

            // Title and Description
        $SECTION_TITLE = $jkl['g323'];
        $SECTION_DESC = '';

        // Form title
        $FORM_TITLE = $jkl["g323"];

        // Include the javascript file for results
        $js_file_footer = 'js_pages.php';

        // Call the template
        $template = 'tickets.php';

      } else {
        // No database information
        $_SESSION["errormsg"] = $jkl['i2'];
        jak_redirect(JAK_rewrite::jakParseurl('tickets'));
      }

    break;
    default:

      if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['create_ticket'])) {
        $jkp = $_POST;
            
        if (empty($jkp['subject'])) {
            $errors['e'] = $jkl['e2'];
        }
                
        if (empty($jkp['content'])) {
            $errors['e1'] = $jkl['e1'];
        }            
                
        if (count($errors) == 0) {

          $usr = $jakdb1->get("users", ["id", "username"], ["AND" => ["locationid" => JAK_MAIN_LOC, "opid" => JAK_USERID]]);

          // Insert the news for user(s)
          $result = $jakdb1->insert($jaktable, ["userid" => $usr["id"],
            "opid" => JAK_USERID,
            "username" => $usr["username"],
            "subject" => trim($jkp['subject']),
            "content" => trim($jkp['content']),
            "isnews" => 0,
            "status" => 3,
            "sent" => time()]);
            
            if (!$result) {
              $_SESSION["infomsg"] = $jkl['i'];
              jak_redirect($_SESSION['LCRedirect']);
            } else {

              // We start the email notifications
            $mail = new PHPMailer(); // defaults to using php "mail()" or optional SMTP

            // Get the email template
            $nlhtml = file_get_contents(APP_PATH.'template/'.JAK_FRONT_TEMPLATE.'/email/index.html');

              // We inform the site owner
              if ($sett["smtp"] == 1) {

              $mail->IsSMTP(); // telling the class to use SMTP
              $mail->Host = $sett["smtphost"];
              $mail->SMTPAuth = ($sett["smtpauth"] ? true : false); // enable SMTP authentication
              $mail->SMTPSecure = $sett["smtpprefix"]; // sets the prefix to the server
              $mail->SMTPKeepAlive = ($sett["smtpalive"] ? true : false); // SMTP connection will not close after each email sent
              $mail->Port = $sett["smtpport"]; // set the SMTP port for the GMAIL server
              $mail->Username = $sett["smtpusername"]; // SMTP account username
              $mail->Password = $sett["smtppass"];        // SMTP account password
                                
            }

            $mail->SetFrom($sett["emailaddress"]);

            // Send email to all admins
            if (isset($admins)) foreach ($admins as $ad) {
              # code...
              $mail->AddAddress($ad["email"]);
            }

            // Say Hello
            $webtext = '<h1>'.$sett["newtickettitle"].'</h1>';

            // Send the operator url
            $webtext .= sprintf($sett["newticketmsg"], $usr["username"]);

            // Get the link to the dashboard
            $webtext .= '<p><a href="'.jak_redirect(JAK_rewrite::jakParseurl('tickets')).'">'.$jkl['m31'].'</a></p>';
                  
            // Change fake vars into real ones.
            $cssAtt = array('{emailcontent}', '{weburl}', '{title}', '{emailtpllogo}', '{emailtplcopy}');
            $cssUrl   = array($webtext, $sett["webaddress"], $sett["newtickettitle"], JAK_EMAILTPLLOGO, JAK_EMAILTPLCOPY);
            $nlcontent = str_replace($cssAtt, $cssUrl, $nlhtml);
                
            $body = str_ireplace("[\]", "", $nlcontent);
                              
            $mail->Subject = $sett["newtickettitle"];
            $mail->MsgHTML($body);
            $mail->Send();

              $_SESSION["successmsg"] = $jkl['g14'];
              jak_redirect($_SESSION['LCRedirect']);
            }
            
        // Output the errors
        } else {
          $errors = $errors;
        }
       
      }
        
      // Title and Description
      $SECTION_TITLE = $jkl["m36"];
      $SECTION_DESC = "";

      // Form title
      $FORM_TITLE = $jkl["g322"];
        
      // Include the javascript file for results
      $js_file_footer = 'js_pages.php';
         
      // Call the template
      $template = 'tickets.php';

    }

} else {
  jak_redirect(BASE_URL);
}
?>