sCalendarNotify.php

#!/usr/local/bin/php
<?php

  // ** SET HOMECU FLAGS
  $serviceMinimal = true;
  $serviceShowInfo = false;
  $serviceLoadMenu = false;
  $serviceShowMenu = false;
  $serviceLoadCuInfo = false;

  // ** INCLUDE MAIN GLOBAL SCRIPT -- Handles security / global variable values
  // hcuService will be returning a status object: e.g. ["homecuErrors":{[{"message":"message1"}...{"message":"messageN"}}]
  require_once('/var/www/html/banking/library/hcuService.i');

  // All the functions are here.
  require_once("/var/www/html/system/library/sCalendarNotify.i" );

  $dbhost = getenv('DATABASE_HOST');
  $dbport = getenv('DATABASE_PORT');
  $dbname = getenv('DATABASE_NAME');
  $dbuser = getenv('DATABASE_USER');
  $dbpasswd = getenv('DATABASE_PASSWORD');
  $dbplat = 'Postgres';
  $pReplyEmail = "nobody\@homecu.net";    // used for the From when mailing CU

  // set up the logger
  $logger = $HB_ENV["SYSENV"]["logger"];

  // Get options
  // d -- run the file with a particular date.  Format is YYYY-mm-dd.  If it isn't set, then it runs with the current date (default.)
  // help -- prints out the syntax structure and then exits.
  $allowedOptions = "d::";
  $longOptions = array("help", "dryrun");
  $commandOptions = getopt( $allowedOptions, $longOptions );

  date_default_timezone_set ( "America/Denver" );

  $results = VerifyOpts($commandOptions);
  if ($results["status"] !== "000") {
      if ($results["status"] >= 0) {
          $logger->error($results["error"]);
      }
      $logger->info("Usage: {$argv[0]} [-d\"YYYY-mm-dd\"]");
      exit;
  } else {
      extract($results["opts"]);
  }

  $today = date( "D M d, Y G:i", strtotime($date));
  $currentDate = date ( "Y-m-d", strtotime($date));                      // date formatted like sql date field
  $processName = "Calendar Notify Process";
  $currentYear = explode("-", $date);
  $currentYear = intval($currentYear[0]);
  $nextYear = $currentYear + 1;

  try {
      $logger->info("$processName: $today $currentDate" );

      if ($dryrun) {
        $logger->info("$processName is in dry run mode.  The database will not be updated and no emails will be sent out.");
      }

      $logger->info("$processName: Removing old calendar records.");
      if (!$dryrun) {
        $results = RemoveOldCalendars($dbh, $currentYear);
        if ($results["status"] !== "000") {
            throw new exception ("Old calendars could not be deleted.", 3);
        }
      }

      $results = DoICare($date);
      if ($results["status"] !== "000") {
          throw new exception ("CU List could not be created.", 2);
      }
      if (!$results["doICare"]) {
          $msg = "$processName: Exited due to being too early in the year.";
          $logger->info($msg);
      } else {

          $fullResults = RetrieveCUEmailList($dbh, $currentYear, $nextYear);
          if ($fullResults["status"] !== "000") {
              throw new exception ("CU List could not be created.", 1);
          }

          foreach($fullResults["data"]["lastNotifyList"] as $lastNotifyRow) {
              $cu = trim($lastNotifyRow["cu"]);
              $emails = $lastNotifyRow["emails"];
              if (count($emails) == 0) { // This is an error but continue on.
                  $msg = "$processName: $cu does not have emails set up.";
                  $logger->error($msg);
              }

              $results = ShouldISendEmail($currentDate, $lastNotifyRow["lastnotify"]);
              if ($results["status"] !== "000") {
                  throw new exception ("$processName: Email logic is incorrect.", 3);
              }

              if ($results["shouldISendEmail"]) {
                  $emailSent = false;
                  $msg = "$processName: Sending emails for $cu...";
                  $logger->info($msg);
                  if (!$dryrun) {
                    $results = SendCuEmail($cu, $emails, $nextYear);
                    if ($results["status"] !== "000") { // This is an error but continue on.
                      $logger->error("$processName: Email to $email for $cu failed.");
                    } else {
                      $emailSent = true;
                    }
                  }

                  $logger->info("$processName: Updating calendar record for $cu.");
                  if (!$dryrun) {
                    $results = UpdateCuCalendar($dbh, $cu, $nextYear, $date);
                    if ($results["status"] !== "000") {
                      $logger->error("$processName: Failed updating calendar record for $cu.");
                    }
                  }
              }
          }
      }

      $logger->info("$processName: Script was successful.");
      exit;
  } catch (exception $e) {

      $logger->error("$processName failed: " . $e->getMessage());
      exit ($e->getCode());
  }