#!/usr/local/bin/php
<?php
$TIME = date('YmdHis', strtotime('now'));
$iTAG='$Id: esitesSetup,v 1.41 2011/11/15 18:51:13 henryhou Exp $';
$CUROS=exec('uname -s');
$RELEASE=exec('uname -r');
$OFFSET=exec('dirname $0');
$AUTOINSTALL=0;
$INSTALL_DIR=exec('pwd');
$HTTPD_CONF="/usr/local/apache2/conf/httpd.conf";
$POST3_DB_USER='post3';
$POST3_DB_PASS='post3';


/*
 * Functions 
 */
function logMessage($message, $fp = false, $log_only = false)
{
  if ( $fp ) { fwrite( $fp, date('m/d/Y, H:i:s', strtotime('now')).' : '.$message ); }
  if ( !$log_only ) { printf ($message); }
}

function readline( $prompt = '' )
{
    echo $prompt;
    return rtrim( fgets( STDIN ), "\n" );
}

/*
 * ESITES INSTALL SETUP
 */
  # Setup Logfile
    $LOGFILE="$INSTALL_DIR/install.log";
    $log_fp = fopen($LOGFILE, 'a+');
    if(!$log_fp) { echo "Error! Couldn't open log file."; } else { /* $fp now can be used for I/O */ }
    logMessage( "\n", false );
    logMessage( "----------------------------------------------\n", $log_fp );
    logMessage( "Install Time: ".date('m/d/Y, H:i:s', strtotime('now'))."\n", $log_fp );
    logMessage( '$Id: esitesSetup,v 1.41 2011/11/15 18:51:13 henryhou Exp $', $log_fp );
    logMessage( "\n", false );

    if ( exec("id -u") != 0 )
    {
      logMessage( "\n", false );
      logMessage("Need to be super user to execute this script.\n\n", $log_fp);
      exit(1);
    }
    if ( strpos($_ENV['ORACLE_HOME'], '9i') !== false && !isset($_ENV['LD_PRELOAD']) )
    {
      logMessage( "Please execute the following command and try again.\n\nexport LD_PRELOAD=\$ORACLE_HOME/lib/libclntsh.so\n\n", $log_fp);
      exit(1);
    }

  # Check Root User
    if ( $_ENV['UID'] != 0 ) { logMessage("Need to be super user to execute this script.\n", $log_fp); exit(1); }
    
  #Install Variables
    $ENS_HOME=exec("echo ~ens");
    if ( !is_dir($ENS_HOME) ) { logMessage("Cannont find ens home.\n", $log_fp); exit(1); }
    $WWW_HOME="${ENS_HOME}/www";
    $BACKUP_DIR="${ENS_HOME}/backup";
    if ( !is_dir($BACKUP_DIR) ) { logMessage("Creating Backup folder ${BACKUP_DIR}.\n", $log_fp); exec("mkdir -p ${BACKUP_DIR}; chown ens:users ${BACKUP_DIR}"); }
    $SOAP_HOME="${ENS_HOME}/webapps/EnticeWS";
    if ( !is_dir($SOAP_HOME) ) { logMessage("Default SOAP is not installed, Make sure to verify config.php in all web sites.\n", $log_fp); }
    $CURVERFILE="${WWW_HOME}/release.dat";
    $DATFILE="${INSTALL_DIR}/release.dat";
    $TMPFILE="tmp/.esitesTemp.$$";
    $BACKUPFILE="${BACKUP_DIR}/esites.backup.${TIME}.tar";

  #Default install answers
    $action = 'i';

/*
 * ESITES INSTALL 
 */
  logMessage("\nLoading template.\n\n");

  # Connect to Oracle, so we dont' do anything without oracle
  $conn = oci_connect($POST3_DB_USER, $POST3_DB_PASS, 'ENTICE');
  if (!$conn) 
  {
    $e = ocierror($stmt);
    logmessage($e['message'], $log_fp);
    exit(1);
  }


/*-------------------------------------------------------------------------------------
 * Start Database update
 --------------------------------------------------------------------------------------*/

  logMessage("\n\nUpdating Templates\n", $log_fp);
  logMessage("~~~~~~~~~~~~~~~~~~\n", $log_fp);
  #update/insert factory templates
  exec("cd ${INSTALL_DIR}/sql; ls LOB_FACTORY_TEMPLATE_8", $lob_files);
  $own_url=preg_replace('/(ServerName)|(\s)/', '', exec('grep -A 2 -B 2 "\"/home/ens/www/owner\"" /usr/local/apache2/conf/httpd.conf | grep "ServerName"'));
  logMessage("Using owner URL of $own_url\n");
  $res_url=preg_replace('/(ServerName)|(\s)/', '', exec('grep -A 2 -B 2 "\"/home/ens/www/reseller\"" /usr/local/apache2/conf/httpd.conf | grep "ServerName"'));
  logMessage("Using reseller URL of $res_url\n");
  $pbx_url=preg_replace('/(ServerName)|(\s)/', '', exec('grep -A 2 -B 2 "\"/home/ens/www/pbx\"" /usr/local/apache2/conf/httpd.conf | grep "ServerName"'));
  logMessage("Using pbx URL of $pbx_url\n");
  $callshop_url=preg_replace('/(ServerName)|(\s)/', '', exec('grep -A 2 -B 2 "\"/home/ens/www/callshop\"" /usr/local/apache2/conf/httpd.conf | grep "ServerName"'));
  logMessage("Using callshop URL of $callshop_url\n");

  foreach ($lob_files as $lob_file)
  {
    $template_type = str_replace("LOB_FACTORY_TEMPLATE_", '', $lob_file);

    $sql = "SELECT TEMPLATE_TYPE FROM TEMPLATE_TYPE WHERE ID='$template_type'";
    $stmt = oci_parse($conn, $sql);
    if ( @oci_execute( $stmt, OCI_DEFAULT ) )
    {
      OCIFetch($stmt);
      $desc = ociresult($stmt, "TEMPLATE_TYPE");
    }
    else
    {
      $e = ocierror($stmt);
      logMessage("SQL: $sql :\n\n", $log_fp);
      logMessage("Error fetching Template Type $template_type : ".$e['message'], $log_fp);
      exit(1);
    }
    oci_free_statement($stmt);

    $sql = "SELECT
               ID
            FROM
               TEMPLATE
            WHERE
               TEMPLATE_TYPE_ID = '$template_type' AND FACTORY_TEMPLATE='1'";
    $stmt = oci_parse($conn, $sql);
    #logMessage("Fetching Factory template of type : $template_type\n", $log_fp);
    // Execute the statement using OCI_DEFAULT (begin a transaction)
    if ( @oci_execute($stmt, OCI_DEFAULT) )
    {
        $all_rows = array();
        $row_count = oci_fetch_all($stmt, $all_rows);
        // Test for 0 rows and add one
        if ( $row_count == 0 )
        {
          oci_free_statement($stmt);
          $sql = "INSERT INTO
                    TEMPLATE
                      (
                        ID,
                        TEMPLATE_TYPE_ID,
                        OWNED_BY_ID,
                        EMAIL_FROM,
                        EMAIL_REPLY_TO,
                        EMAIL_SUBJECT,
                        SHORT_DESCRIPTION,
                        FACTORY_TEMPLATE,
                        XSL_TEMPLATE
                      )
                   VALUES
                      (
                        TEMPLATE_SEQ.NEXTVAL,
                        '$template_type',
                        '0',
                        'from@yourcompany.com',
                        'replyto@yourcompany.com',
                        '$desc',
                        '$desc',
                        '1',
                        TO_NCLOB(:xsl_lob)
                      )";

          #$stmt = oci_parse($conn, mb_convert_encoding($sql, "UCS-2"));
          $stmt = oci_parse($conn, $sql);

          // Creates an "empty" OCI-Lob object to bind to the locator
          $myLOB = oci_new_descriptor($conn, OCI_D_LOB);
    
          // Bind the returned Oracle LOB locator to the PHP LOB object
          oci_bind_by_name($stmt, ":xsl_lob", $myLOB, -1, OCI_B_CLOB);

          // Now write a temporary CLOB that oracle will convert to a NCLOB
          $strLOB=file_get_contents("${INSTALL_DIR}/sql/$lob_file");
          $strLOB=str_replace('-RESELLER_URL-', $res_url, $strLOB);
          $strLOB=str_replace('-OWNER_URL-', $own_url, $strLOB);
          $strLOB=str_replace('-PBX_URL-', $pbx_url, $strLOB);
          $strLOB=str_replace('-CALLSHOP_URL-', $callshop_url, $strLOB);

          if ( !$myLOB->writeTemporary($strLOB) )
          {
            $e = ocierror($stmt);
            logMessage("Error Reading in ${INSTALL_DIR}/sql/$lob_file : ", $log_fp);
            oci_rollback($conn);
            continue;
          }

          // Execute the statement using , OCI_DEFAULT - as a transaction
          if ( !oci_execute($stmt, OCI_DEFAULT) )
          {
            $e = ocierror($stmt);
            logMessage("SQL: $sql :\n\n", $log_fp);
            logMessage("Error executing: ".$e['message'], $log_fp);
            oci_rollback($conn);
          }
          else
          {
            logMessage("Inserting template $template_type\n", $log_fp);
            oci_commit($conn);
          }
          $myLOB->free();
          $myLOB->close();
        }
        else
        {
          foreach ($all_rows as $row)
          { 
            $template_id = $row[0];
            // Write New field
            oci_free_statement($stmt);
            $sql = "UPDATE
                       TEMPLATE
                    SET 
                        XSL_TEMPLATE=TO_NCLOB(:xsl_lob)
                    WHERE
                       ID = '$template_id'
            ";
            $stmt = oci_parse($conn, $sql);
        
            // Creates an "empty" OCI-Lob object to bind to the locator
            $myLOB = oci_new_descriptor($conn, OCI_D_LOB);
      
            // Bind the returned Oracle LOB locator to the PHP LOB object
            oci_bind_by_name($stmt, ":xsl_lob", $myLOB, -1, OCI_B_CLOB);
  
            // Now write a temporary CLOB that oracle will convert to a NCLOB
            $strLOB=file_get_contents("${INSTALL_DIR}/sql/$lob_file");
            $strLOB=str_replace('-RESELLER_URL-', $res_url, $strLOB);
            $strLOB=str_replace('-OWNER_URL-', $own_url, $strLOB);
            $strLOB=str_replace('-PBX_URL-', $pbx_url, $strLOB);
			$strLOB=str_replace('-CALLSHOP_URL-', $callshop_url, $strLOB);

            if ( !$myLOB->writeTemporary($strLOB) )
            {
              $e = ocierror($stmt);
              logMessage("Error Reading in ${INSTALL_DIR}/sql/$lob_file : ", $log_fp);
              oci_rollback($conn);
              continue;
            }
            // Execute the statement using , OCI_DEFAULT - as a transaction
            if ( !oci_execute($stmt, OCI_DEFAULT) )
            {
              $e = ocierror($stmt);
              logMessage("SQL: $sql :\n\n", $log_fp);
              logMessage("Error executing: ".$e['message'], $log_fp);
              oci_rollback($conn);
            }
            else
            {
              logMessage("Updating template $template_type\n", $log_fp);
              oci_commit($conn);
            }
            $myLOB->free();
            //$myLOB->close();
          }
        }
        // Free resources
        oci_free_statement($stmt);
    }
    else
    {
      $e = ocierror($stmt);
      logMessage("SQL: $sql :\n\n", $log_fp);
      logMessage("Error executing  $lob_file - ".$e['message'], $log_fp);
      oci_rollback($conn);
      exit(1);
    }
  }
  // Close down oracle connection
  oci_close($conn);
  logMessage("Templates Finished\n", $log_fp);
  #Close Files
  if(!fclose($log_fp)) { echo "Error! Couldn't close log file."; }
  exit(0);
?>